def getADVStats(gameList):
df1 = pd.DataFrame()
for a in gameList:
print(a)
boxscore_summary = game.BoxscoreSummary(a)
sql_team_basic = boxscore_summary.game_summary()
sql_team_basic = sql_team_basic[['GAME_DATE_EST', 'GAMECODE']]
boxscore_advanced = game.BoxscoreAdvanced(a)
sql_team_advanced = boxscore_advanced.sql_team_advanced()
team_four_factors = game.BoxscoreFourFactors(a)
sql_team_four_factors = team_four_factors.sql_team_four_factors()
boxscore = game.Boxscore(a)
sql_team_scoring = boxscore.team_stats()
df = pd.concat([
sql_team_basic, sql_team_advanced, sql_team_four_factors,
sql_team_scoring
],
axis=1)
df1 = pd.concat([df1, df], axis=0)
df1.fillna(method='ffill', inplace=True)
# print(df1.head())
print('Stats Compiled')
return df1
def test():
gid = '0041400122'
assert game.BoxscoreScoring(gid)
assert game.BoxscoreUsage(gid)
assert game.BoxscoreMisc(gid)
assert game.BoxscoreAdvanced(gid)
assert game.BoxscoreFourFactors(gid)
assert game.PlayByPlay(gid)
def testAll(self):
assert game.BoxscoreSummary(self.gameId)
assert game.Boxscore(self.gameId)
assert game.BoxscoreScoring(self.gameId)
assert game.BoxscoreUsage(self.gameId)
assert game.BoxscoreMisc(self.gameId)
assert game.BoxscoreAdvanced(self.gameId)
assert game.BoxscoreFourFactors(self.gameId)
assert game.PlayByPlay(self.gameId)
assert game.HustleStats(self.gameId)
def testBoxScoreFourFactors(self):
boxscorefourfactors = game.BoxscoreFourFactors(self.gameId)
playerfourfactors = boxscorefourfactors.sql_players_four_factors()
self.assertTrue((26, 17), playerfourfactors.shape)
self.assertTrue(
('Aaron Gordon' == playerfourfactors[1:2].PLAYER_NAME).all())
teamfourfactors = boxscorefourfactors.sql_team_four_factors()
self.assertTrue((2, 14), teamfourfactors.shape)
self.assertTrue(('Celtics' == teamfourfactors[1:2].TEAM_NAME).all())
def test():
gid = '0041400122'
print(game.BoxscoreSummary(gid).line_score())
assert game.BoxscoreSummary(gid)
assert game.Boxscore(gid)
assert game.BoxscoreScoring(gid)
assert game.BoxscoreUsage(gid)
assert game.BoxscoreMisc(gid)
assert game.BoxscoreAdvanced(gid)
assert game.BoxscoreFourFactors(gid)
assert game.PlayByPlay(gid)
assert game.HustleStats(gid)
def testBoxScoreFourFactorsWithArguments(self):
boxscorefourfactors = game.BoxscoreFourFactors(self.gameId, '2017-18',
'Regular Season', '0',
'0', '0', '0', '0')
playerfourfactors = boxscorefourfactors.sql_players_four_factors()
self.assertTrue((26, 17), playerfourfactors.shape)
self.assertTrue(
('Aaron Gordon' == playerfourfactors[1:2].PLAYER_NAME).all())
teamfourfactors = boxscorefourfactors.sql_team_four_factors()
self.assertTrue((2, 14), teamfourfactors.shape)
self.assertTrue(('Celtics' == teamfourfactors[1:2].TEAM_NAME).all())
foo = foo.team_stats()
return '00' + str(
int(recent_id) - 15
) # Need to subtract 15 games because todays games are incomplete and will raise an error if included
recent_id = most_recent(dataset_id)
#%%
# Collect and process data of the latest games played currently not used in the model
g_id = '00' + str(int(dataset_id) + 1)
trad = game.Boxscore(g_id)
trad = trad.team_stats()
adv = game.BoxscoreAdvanced(g_id)
adv = adv.sql_team_advanced()
ff = game.BoxscoreFourFactors(g_id)
ff = ff.sql_team_four_factors()
df = []
df.append(trad)
df.append(adv)
df.append(ff)
merge0 = pd.concat(df, axis=1)
df1, df2 = np.split(merge0, [1], axis=0)
cols_A = [col + 'A' for col in df1.columns]
cols_B = [col + 'B' for col in df2.columns]
df1.columns = cols_A
df2.columns = cols_B
df2 = df2.reset_index(drop=True)
summ = game.BoxscoreSummary(g_id)
hc_df = summ.game_summary()
hc_df = hc_df[['HOME_TEAM_ID']]
from __future__ import print_function
from nba_py import game
# pbp = game.PlayByPlay('0041400122')
# print pbp.info()
box = game.Boxscore('0041400122')
print(box.game_summary())
bss = game.BoxscoreScoring('0041400122')
print(bss.sql_team_scoring())
bsu = game.BoxscoreUsage('0041400122')
print(bsu.sql_team_usage())
bsa = game.BoxscoreAdvanced('0041400122')
print(bsa.sql_team_advanced())
bsf = game.BoxscoreFourFactors('0041400122')
print(bsf.sql_team_four_factors())
pt = game.PlayerTracking('0041400122')
print(pt.info())
def boxscore_four_factors(game_id, start_period, end_period, start_range,
end_range, range_type):
return game.BoxscoreFourFactors(game_id, start_period=start_period,
end_period=end_period, start_range=start_range,
end_range=end_range, range_type=range_type)
