from __future__ import print_function
import time
import cfbd
from cfbd.rest import ApiException
from pprint import pprint
# Configure API key authorization: ApiKeyAuth
configuration = cfbd.Configuration()
configuration.api_key[
'Authorization'] = 'XBWTTfw3Jo8o/r/jmDnRA6SsnoHp0MKKPBEE0UGID/hPKqzKLV/+0Ljn06dCbQRS'
configuration.api_key_prefix['Authorization'] = 'Bearer'
# create an instance of the API class
api_instance = cfbd.BettingApi(cfbd.ApiClient(configuration))
game_id = 56 # int | Game id filter (optional)
year = 56 # int | Year/season filter for games (optional)
week = 56 # int | Week filter (optional)
season_type = 'regular' # str | Season type filter (regular or postseason) (optional) (default to regular)
team = 'team_example' # str | Team (optional)
home = 'home_example' # str | Home team filter (optional)
away = 'away_example' # str | Away team filter (optional)
conference = 'conference_example' # str | Conference abbreviation filter (optional)
try:
# Betting lines
api_response = api_instance.get_lines(game_id=game_id,
year=year,
week=week,
season_type=season_type,
team=team,
home=home,
import time
import cfbd
from cfbd.rest import ApiException
from pprint import pprint
import pandas as pd
import numpy as np
from cfbFcns import standardizeTeamName
# Configure API key authorization: ApiKeyAuth
configuration = cfbd.Configuration()
configuration.api_key[
'Authorization'] = 'XBWTTfw3Jo8o/r/jmDnRA6SsnoHp0MKKPBEE0UGID/hPKqzKLV/+0Ljn06dCbQRS'
configuration.api_key_prefix['Authorization'] = 'Bearer'
# create an instance of the API class
api_instance = cfbd.StatsApi(cfbd.ApiClient(configuration))
year = 2021 # int | Year/season filter for games (optional)
week = 4 # int | Week filter (optional)
api_response = api_instance.get_advanced_team_game_stats(year=year,
week=week,
season_type="regular")
dict = {}
dict["gameId"] = []
dict["week"] = []
dict["team"] = []
dict["opponent"] = []
for a in ["offense", "defense"]:
dict[a + ".ppa"] = []
dict[a + ".successRate"] = []
dict[a + ".explosiveness"] = []
bets = pd.read_csv('./new_csv_Data/2021/predictionsWeek' + str(week) + '.csv',
encoding="ISO-8859-1")
spreadSum = 0
ouSum = 0
spreadNum = 0
ouNum = 0
spreadVol = 0
ouVol = 0
configuration = cfbd.Configuration()
configuration.api_key[
'Authorization'] = 'XBWTTfw3Jo8o/r/jmDnRA6SsnoHp0MKKPBEE0UGID/hPKqzKLV/+0Ljn06dCbQRS'
configuration.api_key_prefix['Authorization'] = 'Bearer'
api_instance = cfbd.GamesApi(cfbd.ApiClient(configuration))
year = 2021
api_response = api_instance.get_games(year=year,
week=week,
season_type="regular")
for index, row in bets.iterrows():
for x in api_response:
if (standardizeTeamName(x.home_team, False) == standardizeTeamName(
row["Home Team"], False)
and standardizeTeamName(x.away_team, False)
== standardizeTeamName(row["Road Team"], False)):
if (not pd.isnull(row["Spread Bet"])):
spreadNum += 1
spreadVol += float(row["Spread Amt"])
if ('+' in row["Spread Bet"]):
team = row["Spread Bet"].split(" +")[0]
import time
# Import files
import write_to_db
##########################################
year = 2009
##########################################
# Configure API key for College Football Data API
cfbd_config = cfbd.Configuration()
cfbd_config.api_key[
"Authorization"] = "kf4KXdtp2JFvq+7wy4yipT75+3mcVzeTl56SvjdONO3cdEksOHxWuZdPf2fB92hl"
cfbd_config.api_key_prefix["Authorization"] = "Bearer"
teams_api = cfbd.TeamsApi(cfbd.ApiClient(cfbd_config))
games_api = cfbd.GamesApi(cfbd.ApiClient(cfbd_config))
# Build out DataFrame with basic team info
teams = teams_api.get_fbs_teams()
# teams_df = pd.DataFrame.from_records(
# [
# dict(
# id=t.id,
# team=t.school,
# conference=t.conference,
# division=t.division,
# city=t.location["city"],
# state=t.location["state"],
# )
def get_rankings(*args, **kwargs) -> List[cfbd.RankingWeek]:
""" Get rankings data. """
config = cfbd.Configuration()
config.verify_ssl = False
api = cfbd.RankingsApi(cfbd.ApiClient(config))
return api.get_rankings(*args, **kwargs)
def get_teams(**kwargs) -> List[cfbd.Team]:
""" Get teams data. """
config = cfbd.Configuration()
config.verify_ssl = False
api = cfbd.TeamsApi(cfbd.ApiClient(config))
return api.get_teams(**kwargs)
def get_games(*args, **kwargs) -> List[cfbd.Game]:
""" Get games data. """
config = cfbd.Configuration()
config.verify_ssl = False
api = cfbd.GamesApi(cfbd.ApiClient(config))
return api.get_games(*args, **kwargs)
