Skip to content

Instantly share code, notes, and snippets.

We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 27 columns, instead of 16 in line 8.
SEASON_ID,Player_ID,Game_ID,GAME_DATE,MATCHUP,WL,MIN,FGM,FGA,FG_PCT,FG3M,FG3A,FG3_PCT,FTM,FTA,FT_PCT,OREB,DREB,REB,AST,STL,BLK,TOV,PF,PTS,PLUS_MINUS,VIDEO_AVAILABLE
22019,203081,0021901309,"AUG 13, 2020",POR @ BKN,W,44,13,22,0.591,8,14,0.571,8,9,0.889,0,3,3,12,2,0,1,1,42,-1,1
22019,203081,0021901300,"AUG 11, 2020",POR @ DAL,W,41,17,32,0.531,9,17,0.529,18,18,1.0,2,3,5,8,1,0,3,2,61,8,1
22019,203081,0021901289,"AUG 09, 2020",POR vs. PHI,W,40,16,28,0.571,4,12,0.333,15,16,0.938,0,3,3,7,2,0,6,1,51,6,1
22019,203081,0021901280,"AUG 08, 2020",POR vs. LAC,L,39,10,23,0.435,2,10,0.2,0,2,0.0,1,2,3,5,1,0,3,2,22,-9,1
22019,203081,0021901272,"AUG 06, 2020",POR @ DEN,W,41,13,21,0.619,11,18,0.611,8,10,0.8,0,4,4,12,3,0,2,2,45,6,1
22019,203081,0021901261,"AUG 04, 2020",POR vs. HOU,W,40,6,19,0.316,3,7,0.429,6,7,0.857,0,9,9,8,2,0,3,1,21,3,1
22019,203081,0021901245,"AUG 02, 2020",POR @ BOS,L,44,8,20,0.4,5,14,0.357,9,9,1.0,0,2,2,16,0,1,5,3,30,3,1
22019,203081,0021901234,"JUL 31, 2020",POR vs. MEM,W,45,10,22,0.455,2,9,0.222,7,9,0.778
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 26 columns, instead of 25 in line 3.
SHOT_ZONE_AREA,SHOT_ZONE_BASIC,SHOT_ZONE_RANGE,GRID_TYPE,GAME_ID,GAME_EVENT_ID,PLAYER_ID,PLAYER_NAME,TEAM_ID,TEAM_NAME,PERIOD,MINUTES_REMAINING,SECONDS_REMAINING,EVENT_TYPE,ACTION_TYPE,SHOT_TYPE,SHOT_DISTANCE,LOC_X,LOC_Y,SHOT_ATTEMPTED_FLAG,SHOT_MADE_FLAG,GAME_DATE,HTM,VTM,FG_PCT,LG_FG_PCT
Center(C),In The Paint (Non-RA),Less Than 8 ft.,Shot Chart Detail,0021900013,22,203081,Damian Lillard,1610612757,Portland Trail Blazers,1,10,25,Missed Shot,Driving Floating Jump Shot,2PT Field Goal,5,58,-5,1,0,20191023,POR,DEN,0.36538461538461536,0.385
Center(C),In The Paint (Non-RA),Less Than 8 ft.,Shot Chart Detail,0021900024,77,203081,Damian Lillard,1610612757,Portland Trail Blazers,1,5,15,Made Shot,Cutting Layup Shot,2PT Field Goal,4,32,24,1,1,20191025,SAC,POR,0.36538461538461536,0.385
Center(C),In The Paint (Non-RA),Less Than 8 ft.,Shot Chart Detail,0021900038,142,203081,Damian Lillard,1610612757,Portland Trail Blazers,1,1,33,Missed Shot,Driving Floating Jump Shot,2PT Field Goal,4,4,42,1,0,20191027,DAL,POR,0.3653846153