In [2]:
#Import Packages
import pandas as pd
import numpy as np
import time
from Players import Players
from Player import Player

In [13]:
%%timeit -r1
p_list = Players('2015-16', 0, 100)


The slowest run took 9.64 times longer than the fastest. This could mean that an intermediate result is being cached.
1 loop, best of 1: 8.74 s per loop

In [15]:
%%timeit -r1
p_list = Players('2015-16', 100, 200)


The slowest run took 4.94 times longer than the fastest. This could mean that an intermediate result is being cached.
1 loop, best of 1: 22.7 s per loop

In [16]:
%%timeit -r1
p_list = Players('2015-16', 200, 300)


The slowest run took 4.21 times longer than the fastest. This could mean that an intermediate result is being cached.
1 loop, best of 1: 31.3 s per loop

In [17]:
%%timeit -r1
p_list = Players('2015-16', 300, 400)


1 loop, best of 1: 38.5 s per loop

In [14]:
%%timeit -r1
p_list = Players('2015-16', 400, 500)


The slowest run took 7.05 times longer than the fastest. This could mean that an intermediate result is being cached.
1 loop, best of 1: 11.1 s per loop

In [2]:
p_list = Players('2015-16')

In [6]:
p1 = p_list.players[1495]
p1.desc


Out[6]:
FIRST_NAME LAST_NAME BIRTHDATE HEIGHT WEIGHT SEASON_EXP POSITION ROSTERSTATUS TEAM_ID TEAM_NAME
0 Tim Duncan 1976-04-25T00:00:00 6-11 250 19 Center-Forward Active 1610612759 Spurs

In [7]:
p1.game_logs


Out[7]:
SEASON_ID Player_ID Game_ID GAME_DATE MATCHUP WL MIN FGM FGA FG_PCT ... DREB REB AST STL BLK TOV PF PTS PLUS_MINUS VIDEO_AVAILABLE
10534 22015 1495 21501215 APR 12, 2016 SAS vs. OKC W 34 5 14 0.357 ... 5 9 3 0 1 1 2 12 2 1
10535 22015 1495 21501186 APR 08, 2016 SAS @ DEN L 34 9 15 0.600 ... 5 7 2 0 1 2 1 21 -3 1
10536 22015 1495 21501177 APR 07, 2016 SAS @ GSW L 19 2 6 0.333 ... 2 3 1 0 0 2 0 4 -13 1
10537 22015 1495 21501161 APR 05, 2016 SAS @ UTA W 24 0 3 0.000 ... 2 2 2 0 2 1 2 3 -10 1
10538 22015 1495 21501140 APR 02, 2016 SAS vs. TOR W 29 2 7 0.286 ... 6 11 0 1 3 1 0 5 7 1
10539 22015 1495 21501118 MAR 30, 2016 SAS vs. NOP W 27 3 10 0.300 ... 8 9 1 0 3 0 1 8 16 1
10540 22015 1495 21501078 MAR 25, 2016 SAS vs. MEM W 31 6 8 0.750 ... 6 8 7 1 0 1 0 12 -1 1
10541 22015 1495 21501063 MAR 23, 2016 SAS vs. MIA W 24 1 2 0.500 ... 8 9 4 1 0 2 0 4 24 1
10542 22015 1495 21501043 MAR 21, 2016 SAS @ CHA L 31 7 11 0.636 ... 7 10 2 2 4 1 2 16 1 1
10543 22015 1495 21501036 MAR 19, 2016 SAS vs. GSW W 8 0 1 0.000 ... 0 2 0 0 0 2 1 1 -3 1
10544 22015 1495 21501018 MAR 17, 2016 SAS vs. POR W 21 5 6 0.833 ... 7 7 0 0 2 0 2 11 23 1
10545 22015 1495 21501001 MAR 15, 2016 SAS vs. LAC W 22 3 5 0.600 ... 3 7 2 0 0 0 2 6 0 1
10546 22015 1495 21500979 MAR 12, 2016 SAS vs. OKC W 22 5 7 0.714 ... 3 6 1 2 0 0 3 11 -5 1
10547 22015 1495 21500960 MAR 10, 2016 SAS vs. CHI W 28 3 7 0.429 ... 2 3 4 2 0 0 1 7 3 1
10548 22015 1495 21500939 MAR 07, 2016 SAS @ IND L 28 3 9 0.333 ... 8 14 4 1 2 3 3 9 -3 1
10549 22015 1495 21500909 MAR 03, 2016 SAS @ NOP W 22 2 6 0.333 ... 3 5 2 0 2 1 1 7 14 1
10550 22015 1495 21500905 MAR 02, 2016 SAS vs. DET W 20 6 9 0.667 ... 5 8 1 1 0 1 1 12 17 1
10551 22015 1495 21500872 FEB 27, 2016 SAS @ HOU W 25 3 7 0.429 ... 5 6 6 0 1 2 4 6 18 1
10552 22015 1495 21500860 FEB 25, 2016 SAS @ UTA W 32 7 11 0.636 ... 8 11 2 1 1 3 3 14 12 1
10553 22015 1495 21500854 FEB 24, 2016 SAS @ SAC W 12 0 2 0.000 ... 2 2 0 0 0 0 2 0 -8 1
10554 22015 1495 21500826 FEB 21, 2016 SAS @ PHX W 17 1 5 0.200 ... 3 3 2 1 1 0 2 6 1 1
10555 22015 1495 21500818 FEB 19, 2016 SAS @ LAL W 28 4 9 0.444 ... 8 13 1 0 3 0 1 12 6 1
10556 22015 1495 21500804 FEB 18, 2016 SAS @ LAC L 20 1 6 0.167 ... 6 6 1 1 0 3 2 2 -18 1
10557 22015 1495 21500790 FEB 10, 2016 SAS @ ORL W 18 2 9 0.222 ... 5 7 5 0 3 1 1 5 4 1
10558 22015 1495 21500653 JAN 22, 2016 SAS @ LAL W 21 1 5 0.200 ... 2 3 3 1 1 1 0 4 8 1
10559 22015 1495 21500612 JAN 17, 2016 SAS vs. DAL W 21 0 4 0.000 ... 5 5 1 0 1 0 2 2 16 1
10560 22015 1495 21500590 JAN 14, 2016 SAS vs. CLE W 33 4 10 0.400 ... 4 6 3 1 2 1 3 9 3 1
10561 22015 1495 21500570 JAN 12, 2016 SAS @ DET W 30 5 8 0.625 ... 7 9 3 4 2 2 3 14 6 1
10562 22015 1495 21500566 JAN 11, 2016 SAS @ BKN W 22 4 7 0.571 ... 3 4 2 1 2 1 2 8 11 1
10563 22015 1495 21500546 JAN 08, 2016 SAS vs. NYK W 21 3 5 0.600 ... 4 5 1 1 0 2 1 7 6 1
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
10565 22015 1495 21500516 JAN 04, 2016 SAS @ MIL W 27 7 11 0.636 ... 8 10 4 2 1 1 5 14 12 1
10566 22015 1495 21500502 JAN 02, 2016 SAS vs. HOU W 14 0 3 0.000 ... 4 4 2 0 0 1 1 0 -1 1
10567 22015 1495 21500439 DEC 25, 2015 SAS @ HOU L 32 5 10 0.500 ... 9 11 3 0 0 3 4 13 2 1
10568 22015 1495 21500431 DEC 23, 2015 SAS @ MIN W 24 1 6 0.167 ... 3 5 5 1 4 2 2 2 17 1
10569 22015 1495 21500416 DEC 21, 2015 SAS vs. IND W 23 3 6 0.500 ... 4 5 3 2 2 1 3 7 1 1
10570 22015 1495 21500393 DEC 18, 2015 SAS vs. LAC W 29 5 8 0.625 ... 2 5 4 1 0 2 2 14 5 1
10571 22015 1495 21500364 DEC 14, 2015 SAS vs. UTA W 18 2 2 1.000 ... 4 5 1 0 0 2 2 5 32 1
10572 22015 1495 21500347 DEC 12, 2015 SAS @ ATL W 31 2 6 0.333 ... 10 10 4 1 0 4 2 4 28 1
10573 22015 1495 21500342 DEC 11, 2015 SAS vs. LAL W 20 2 5 0.400 ... 4 4 2 1 1 2 0 5 13 1
10574 22015 1495 21500323 DEC 09, 2015 SAS @ TOR L 20 4 8 0.500 ... 0 2 2 0 0 1 1 8 -12 1
10575 22015 1495 21500296 DEC 05, 2015 SAS vs. BOS W 24 3 5 0.600 ... 4 5 4 0 1 1 1 6 1 1
10576 22015 1495 21500280 DEC 03, 2015 SAS @ MEM W 31 3 6 0.500 ... 9 10 5 1 3 1 3 6 12 2
10577 22015 1495 21500275 DEC 02, 2015 SAS vs. MIL W 20 7 11 0.636 ... 7 10 1 1 0 2 1 16 11 1
10578 22015 1495 21500257 NOV 30, 2015 SAS @ CHI L 30 3 7 0.429 ... 8 12 3 0 1 2 3 6 10 1
10579 22015 1495 21500242 NOV 28, 2015 SAS vs. ATL W 28 5 9 0.556 ... 13 18 4 1 2 1 3 10 24 1
10580 22015 1495 21500224 NOV 25, 2015 SAS vs. DAL W 28 1 4 0.250 ... 8 9 4 0 2 2 2 2 13 1
10581 22015 1495 21500207 NOV 23, 2015 SAS vs. PHX W 32 2 6 0.333 ... 5 8 1 2 1 2 3 7 20 1
10582 22015 1495 21500195 NOV 21, 2015 SAS vs. MEM W 36 5 8 0.625 ... 8 10 4 4 2 3 5 10 6 1
10583 22015 1495 21500182 NOV 20, 2015 SAS @ NOP L 19 2 6 0.333 ... 0 0 2 1 1 0 2 6 7 1
10584 22015 1495 21500172 NOV 18, 2015 SAS vs. DEN W 28 5 8 0.625 ... 6 11 6 1 6 2 3 12 15 1
10585 22015 1495 21500156 NOV 16, 2015 SAS vs. POR W 29 4 8 0.500 ... 5 9 2 0 2 2 0 10 0 1
10586 22015 1495 21500142 NOV 14, 2015 SAS vs. PHI W 27 7 12 0.583 ... 3 4 2 1 4 1 2 15 17 1
10587 22015 1495 21500123 NOV 11, 2015 SAS @ POR W 21 5 7 0.714 ... 6 6 2 1 2 1 3 12 -8 1
10588 22015 1495 21500103 NOV 09, 2015 SAS @ SAC W 23 4 8 0.500 ... 10 14 2 0 0 2 3 11 11 1
10589 22015 1495 21500090 NOV 07, 2015 SAS vs. CHA W 24 4 5 0.800 ... 7 8 2 0 0 3 2 11 -4 1
10590 22015 1495 21500061 NOV 04, 2015 SAS @ WAS L 27 3 5 0.600 ... 9 11 5 0 0 4 4 8 -12 1
10591 22015 1495 21500048 NOV 02, 2015 SAS @ NYK W 35 6 10 0.600 ... 9 10 6 1 2 1 4 16 20 1
10592 22015 1495 21500040 NOV 01, 2015 SAS @ BOS W 29 3 9 0.333 ... 8 9 5 0 1 4 4 7 5 1
10593 22015 1495 21500028 OCT 30, 2015 SAS vs. BKN W 29 4 7 0.571 ... 8 8 1 0 0 2 2 15 26 1
10594 22015 1495 21500013 OCT 28, 2015 SAS @ OKC L 26 3 8 0.375 ... 3 6 0 2 3 1 2 8 -6 1

61 rows × 27 columns


In [12]:
date_list = p1.game_logs['GAME_DATE'].sort_values(ascending=False)
date_list


Out[12]:
10593    OCT 30, 2015
10594    OCT 28, 2015
10578    NOV 30, 2015
10579    NOV 28, 2015
10580    NOV 25, 2015
10581    NOV 23, 2015
10582    NOV 21, 2015
10583    NOV 20, 2015
10584    NOV 18, 2015
10585    NOV 16, 2015
10586    NOV 14, 2015
10587    NOV 11, 2015
10588    NOV 09, 2015
10589    NOV 07, 2015
10590    NOV 04, 2015
10591    NOV 02, 2015
10592    NOV 01, 2015
10539    MAR 30, 2016
10540    MAR 25, 2016
10541    MAR 23, 2016
10542    MAR 21, 2016
10543    MAR 19, 2016
10544    MAR 17, 2016
10545    MAR 15, 2016
10546    MAR 12, 2016
10547    MAR 10, 2016
10548    MAR 07, 2016
10549    MAR 03, 2016
10550    MAR 02, 2016
10558    JAN 22, 2016
             ...     
10560    JAN 14, 2016
10561    JAN 12, 2016
10562    JAN 11, 2016
10563    JAN 08, 2016
10564    JAN 06, 2016
10565    JAN 04, 2016
10566    JAN 02, 2016
10551    FEB 27, 2016
10552    FEB 25, 2016
10553    FEB 24, 2016
10554    FEB 21, 2016
10555    FEB 19, 2016
10556    FEB 18, 2016
10557    FEB 10, 2016
10567    DEC 25, 2015
10568    DEC 23, 2015
10569    DEC 21, 2015
10570    DEC 18, 2015
10571    DEC 14, 2015
10572    DEC 12, 2015
10573    DEC 11, 2015
10574    DEC 09, 2015
10575    DEC 05, 2015
10576    DEC 03, 2015
10577    DEC 02, 2015
10534    APR 12, 2016
10535    APR 08, 2016
10536    APR 07, 2016
10537    APR 05, 2016
10538    APR 02, 2016
Name: GAME_DATE, dtype: object

In [21]:
training=pd.DataFrame()
date_col='GAME_DATE'
target = 'PTS'
for d in date_list:
    avg_val = np.mean(p1.game_logs[p1.game_logs[date_col]<d][target])
    print d,avg_val,p1.game_logs[p1.game_logs[date_col]==d][target].reset_index(drop=True).ix[0]


OCT 30, 2015 8.45 15
OCT 28, 2015 8.45762711864 8
NOV 30, 2015 8.5 6
NOV 28, 2015 8.47368421053 10
NOV 25, 2015 8.58928571429 2
NOV 23, 2015 8.61818181818 7
NOV 21, 2015 8.59259259259 10
NOV 20, 2015 8.64150943396 6
NOV 18, 2015 8.57692307692 12
NOV 16, 2015 8.54901960784 10
NOV 14, 2015 8.42 15
NOV 11, 2015 8.34693877551 12
NOV 09, 2015 8.29166666667 11
NOV 07, 2015 8.23404255319 11
NOV 04, 2015 8.23913043478 8
NOV 02, 2015 8.06666666667 16
NOV 01, 2015 8.09090909091 7
MAR 30, 2016 8.09302325581 8
MAR 25, 2016 8.0 12
MAR 23, 2016 8.09756097561 4
MAR 21, 2016 7.9 16
MAR 19, 2016 8.07692307692 1
MAR 17, 2016 8.0 11
MAR 15, 2016 8.05405405405 6
MAR 12, 2016 7.97222222222 11
MAR 10, 2016 8.0 7
MAR 07, 2016 7.97058823529 9
MAR 03, 2016 8.0 7
MAR 02, 2016 7.875 12
JAN 22, 2016 8.0 4
JAN 17, 2016 8.2 2
JAN 14, 2016 8.1724137931 9
JAN 12, 2016 7.96428571429 14
JAN 11, 2016 7.96296296296 8
JAN 08, 2016 8.0 7
JAN 06, 2016 7.6 18
JAN 04, 2016 7.33333333333 14
JAN 02, 2016 7.65217391304 0
FEB 27, 2016 7.72727272727 6
FEB 25, 2016 7.42857142857 14
FEB 24, 2016 7.8 0
FEB 21, 2016 7.89473684211 6
FEB 19, 2016 7.66666666667 12
FEB 18, 2016 8.0 2
FEB 10, 2016 8.1875 5
DEC 25, 2015 7.86666666667 13
DEC 23, 2015 8.28571428571 2
DEC 21, 2015 8.38461538462 7
DEC 18, 2015 7.91666666667 14
DEC 14, 2015 8.18181818182 5
DEC 12, 2015 8.6 4
DEC 11, 2015 9.0 5
DEC 09, 2015 9.125 8
DEC 05, 2015 9.57142857143 6
DEC 03, 2015 10.1666666667 6
DEC 02, 2015 9.0 16
APR 12, 2016 8.25 12
APR 08, 2016 4.0 21
APR 07, 2016 4.0 4
APR 05, 2016 5.0 3
APR 02, 2016 nan 5

In [24]:
p = Player(pid=203112)
ga = p.game_logs
ga[['GAME_DATE', 'Game_ID','MIN', 'PTS']]


Out[24]:
GAME_DATE Game_ID MIN PTS
76 APR 13, 2016 21501224 29 10
77 APR 11, 2016 21501211 16 9
78 APR 09, 2016 21501193 21 7
79 APR 07, 2016 21501176 28 17
80 APR 05, 2016 21501162 15 8
81 APR 02, 2016 21501141 17 5
82 APR 01, 2016 21501135 14 4
83 MAR 30, 2016 21501120 13 7
84 MAR 28, 2016 21501105 28 10
85 MAR 27, 2016 21501095 17 7
86 MAR 25, 2016 21501079 19 14
87 MAR 23, 2016 21501062 22 9
88 MAR 21, 2016 21501049 11 2
89 MAR 20, 2016 21501042 23 3
90 MAR 18, 2016 21501022 18 6
91 MAR 16, 2016 21501010 14 5
92 MAR 15, 2016 21501002 5 1
93 MAR 13, 2016 21500986 11 2
94 MAR 11, 2016 21500970 14 3
95 MAR 09, 2016 21500957 21 8
96 MAR 07, 2016 21500941 20 2
97 MAR 05, 2016 21500928 31 16
98 MAR 03, 2016 21500910 16 4
99 MAR 02, 2016 21500902 26 11
100 FEB 29, 2016 21500889 28 10
101 FEB 26, 2016 21500867 15 4
102 FEB 24, 2016 21500854 23 15
103 FEB 23, 2016 21500842 13 0
104 FEB 19, 2016 21500816 15 0
105 FEB 10, 2016 21500791 15 6
106 FEB 08, 2016 21500775 5 3
107 FEB 07, 2016 21500773 3 0
108 FEB 05, 2016 21500754 6 0
109 FEB 01, 2016 21500729 17 4
110 JAN 30, 2016 21500712 11 6
111 JAN 28, 2016 21500696 19 3
112 JAN 26, 2016 21500682 17 4
113 JAN 21, 2016 21500643 11 4
114 JAN 20, 2016 21500638 2 2
115 JAN 13, 2016 21500585 9 0
116 JAN 09, 2016 21500556 22 9
117 JAN 07, 2016 21500539 25 18
118 JAN 05, 2016 21500523 16 12
119 JAN 04, 2016 21500517 5 0
120 JAN 02, 2016 21500496 4 2
121 DEC 30, 2015 21500483 9 2
122 DEC 28, 2015 21500468 25 8
123 DEC 15, 2015 21500369 1 0
124 DEC 05, 2015 21500293 4 2
125 DEC 03, 2015 21500282 7 2
126 NOV 28, 2015 21500245 15 9
127 NOV 27, 2015 21500237 9 1
128 NOV 19, 2015 21500175 5 0
129 NOV 18, 2015 21500169 16 0
130 NOV 15, 2015 21500150 15 2
131 NOV 13, 2015 21500137 19 3
132 NOV 09, 2015 21500103 3 3
133 NOV 07, 2015 21500092 15 3
134 NOV 04, 2015 21500067 4 0

In [16]:
ga.columns


Out[16]:
Index([u'SEASON_ID', u'Player_ID', u'Game_ID', u'GAME_DATE', u'MATCHUP', u'WL',
       u'MIN', u'FGM', u'FGA', u'FG_PCT', u'FG3M', u'FG3A', u'FG3_PCT', u'FTM',
       u'FTA', u'FT_PCT', u'OREB', u'DREB', u'REB', u'AST', u'STL', u'BLK',
       u'TOV', u'PF', u'PTS', u'PLUS_MINUS', u'VIDEO_AVAILABLE'],
      dtype='object')

In [22]:
date_col = 'GAME_DATE'
target_col = 'PTS'
id_col = 'Game_ID'
n=3
stats=pd.DataFrame()
ga[date_col] = pd.to_datetime(ga[date_col])
for index, g in ga.sort_values(date_col).iterrows():
    curr_dt = pd.to_datetime(g[date_col])
    past_games = ga[ga[date_col]<curr_dt]
    if len(past_games) > n:
        past_games = past_games.sort_values(date_col, ascending=False).head(n)
    print past_games
    avg_val = np.mean(past_games[target_col])
    stats.set_value(index, id_col, g[id_col])
    stats.set_value(index, target_col, g[target_col])
    stats.set_value(index, (target_col + '_avg'), avg_val)


Empty DataFrame
Columns: [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]
Index: []

[0 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
134      22015     203112  21500067 2015-11-04  SAC @ PHX  L    4    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
134     0.0       ...            1    1    1    0    0    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
134          -1                1  

[1 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
133      22015     203112  21500092 2015-11-07  SAC vs. GSW  L   15    1    1   
134      22015     203112  21500067 2015-11-04    SAC @ PHX  L    4    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
133     1.0       ...            3    3    2    0    1    1   0    3   
134     0.0       ...            1    1    1    0    0    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
133           8                1  
134          -1                1  

[2 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
132      22015     203112  21500103 2015-11-09  SAC vs. SAS  L    3    1    1   
133      22015     203112  21500092 2015-11-07  SAC vs. GSW  L   15    1    1   
134      22015     203112  21500067 2015-11-04    SAC @ PHX  L    4    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
132     1.0       ...            0    0    0    0    0    0   0    3   
133     1.0       ...            3    3    2    0    1    1   0    3   
134     0.0       ...            1    1    1    0    0    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
132           2                1  
133           8                1  
134          -1                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
131      22015     203112  21500137 2015-11-13  SAC vs. BKN  W   19    1    2   
132      22015     203112  21500103 2015-11-09  SAC vs. SAS  L    3    1    1   
133      22015     203112  21500092 2015-11-07  SAC vs. GSW  L   15    1    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
131     0.5       ...            1    1    0    2    0    1   0    3   
132     1.0       ...            0    0    0    0    0    0   0    3   
133     1.0       ...            3    3    2    0    1    1   0    3   

     PLUS_MINUS  VIDEO_AVAILABLE  
131          13                1  
132           2                1  
133           8                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
130      22015     203112  21500150 2015-11-15  SAC vs. TOR  W   15    1    2   
131      22015     203112  21500137 2015-11-13  SAC vs. BKN  W   19    1    2   
132      22015     203112  21500103 2015-11-09  SAC vs. SAS  L    3    1    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
130     0.5       ...            3    3    1    0    0    0   3    2   
131     0.5       ...            1    1    0    2    0    1   0    3   
132     1.0       ...            0    0    0    0    0    0   0    3   

     PLUS_MINUS  VIDEO_AVAILABLE  
130          -5                1  
131          13                1  
132           2                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
129      22015     203112  21500169 2015-11-18    SAC @ ATL  L   16    0    0   
130      22015     203112  21500150 2015-11-15  SAC vs. TOR  W   15    1    2   
131      22015     203112  21500137 2015-11-13  SAC vs. BKN  W   19    1    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
129     0.0       ...            1    1    1    0    1    1   3    0   
130     0.5       ...            3    3    1    0    0    0   3    2   
131     0.5       ...            1    1    0    2    0    1   0    3   

     PLUS_MINUS  VIDEO_AVAILABLE  
129         -10                1  
130          -5                1  
131          13                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
128      22015     203112  21500175 2015-11-19    SAC @ MIA  L    5    0    1   
129      22015     203112  21500169 2015-11-18    SAC @ ATL  L   16    0    0   
130      22015     203112  21500150 2015-11-15  SAC vs. TOR  W   15    1    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
128     0.0       ...            0    1    0    0    0    0   0    0   
129     0.0       ...            1    1    1    0    1    1   3    0   
130     0.5       ...            3    3    1    0    0    0   3    2   

     PLUS_MINUS  VIDEO_AVAILABLE  
128          -1                1  
129         -10                1  
130          -5                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
127      22015     203112  21500237 2015-11-27  SAC vs. MIN  L    9    0    1   
128      22015     203112  21500175 2015-11-19    SAC @ MIA  L    5    0    1   
129      22015     203112  21500169 2015-11-18    SAC @ ATL  L   16    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
127     0.0       ...            1    1    0    0    0    0   3    1   
128     0.0       ...            0    1    0    0    0    0   0    0   
129     0.0       ...            1    1    1    0    1    1   3    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
127          -8                1  
128          -1                1  
129         -10                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
126      22015     203112  21500245 2015-11-28    SAC @ GSW  L   15    4    7   
127      22015     203112  21500237 2015-11-27  SAC vs. MIN  L    9    0    1   
128      22015     203112  21500175 2015-11-19    SAC @ MIA  L    5    0    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
126   0.571       ...            3    7    1    0    0    1   3    9   
127   0.000       ...            1    1    0    0    0    0   3    1   
128   0.000       ...            0    1    0    0    0    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
126         -12                1  
127          -8                1  
128          -1                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
125      22015     203112  21500282 2015-12-03  SAC vs. BOS  L    7    1    4   
126      22015     203112  21500245 2015-11-28    SAC @ GSW  L   15    4    7   
127      22015     203112  21500237 2015-11-27  SAC vs. MIN  L    9    0    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
125   0.250       ...            0    1    0    1    0    0   0    2   
126   0.571       ...            3    7    1    0    0    1   3    9   
127   0.000       ...            1    1    0    0    0    0   3    1   

     PLUS_MINUS  VIDEO_AVAILABLE  
125          -7                1  
126         -12                1  
127          -8                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
124      22015     203112  21500293 2015-12-05    SAC @ HOU  L    4    1    2   
125      22015     203112  21500282 2015-12-03  SAC vs. BOS  L    7    1    4   
126      22015     203112  21500245 2015-11-28    SAC @ GSW  L   15    4    7   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
124   0.500       ...            0    1    0    0    0    0   2    2   
125   0.250       ...            0    1    0    1    0    0   0    2   
126   0.571       ...            3    7    1    0    0    1   3    9   

     PLUS_MINUS  VIDEO_AVAILABLE  
124          -6                1  
125          -7                1  
126         -12                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
123      22015     203112  21500369 2015-12-15  SAC vs. HOU  W    1    0    1   
124      22015     203112  21500293 2015-12-05    SAC @ HOU  L    4    1    2   
125      22015     203112  21500282 2015-12-03  SAC vs. BOS  L    7    1    4   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
123    0.00       ...            0    0    0    0    0    0   0    0   
124    0.50       ...            0    1    0    0    0    0   2    2   
125    0.25       ...            0    1    0    1    0    0   0    2   

     PLUS_MINUS  VIDEO_AVAILABLE  
123          -3                1  
124          -6                1  
125          -7                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
122      22015     203112  21500468 2015-12-28    SAC @ GSW  L   25    3    7   
123      22015     203112  21500369 2015-12-15  SAC vs. HOU  W    1    0    1   
124      22015     203112  21500293 2015-12-05    SAC @ HOU  L    4    1    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
122   0.429       ...            7   10    1    2    3    2   4    8   
123   0.000       ...            0    0    0    0    0    0   0    0   
124   0.500       ...            0    1    0    0    0    0   2    2   

     PLUS_MINUS  VIDEO_AVAILABLE  
122          -6                1  
123          -3                1  
124          -6                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
121      22015     203112  21500483 2015-12-30  SAC vs. PHI  L    9    0    1   
122      22015     203112  21500468 2015-12-28    SAC @ GSW  L   25    3    7   
123      22015     203112  21500369 2015-12-15  SAC vs. HOU  W    1    0    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
121   0.000       ...            3    5    0    1    0    0   1    2   
122   0.429       ...            7   10    1    2    3    2   4    8   
123   0.000       ...            0    0    0    0    0    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
121           6                1  
122          -6                1  
123          -3                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
120      22015     203112  21500496 2016-01-02  SAC vs. PHX  W    4    1    2   
121      22015     203112  21500483 2015-12-30  SAC vs. PHI  L    9    0    1   
122      22015     203112  21500468 2015-12-28    SAC @ GSW  L   25    3    7   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
120   0.500       ...            0    0    0    1    0    0   1    2   
121   0.000       ...            3    5    0    1    0    0   1    2   
122   0.429       ...            7   10    1    2    3    2   4    8   

     PLUS_MINUS  VIDEO_AVAILABLE  
120           0                1  
121           6                1  
122          -6                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
119      22015     203112  21500517 2016-01-04    SAC @ OKC  W    5    0    0   
120      22015     203112  21500496 2016-01-02  SAC vs. PHX  W    4    1    2   
121      22015     203112  21500483 2015-12-30  SAC vs. PHI  L    9    0    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
119     0.0       ...            0    1    0    0    0    0   1    0   
120     0.5       ...            0    0    0    1    0    0   1    2   
121     0.0       ...            3    5    0    1    0    0   1    2   

     PLUS_MINUS  VIDEO_AVAILABLE  
119          -6                1  
120           0                1  
121           6                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
118      22015     203112  21500523 2016-01-05    SAC @ DAL  L   16    4    4   
119      22015     203112  21500517 2016-01-04    SAC @ OKC  W    5    0    0   
120      22015     203112  21500496 2016-01-02  SAC vs. PHX  W    4    1    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
118     1.0       ...            3    6    0    1    0    0   3   12   
119     0.0       ...            0    1    0    0    0    0   1    0   
120     0.5       ...            0    0    0    1    0    0   1    2   

     PLUS_MINUS  VIDEO_AVAILABLE  
118          -5                1  
119          -6                1  
120           0                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
117      22015     203112  21500539 2016-01-07  SAC vs. LAL  W   25    8    9   
118      22015     203112  21500523 2016-01-05    SAC @ DAL  L   16    4    4   
119      22015     203112  21500517 2016-01-04    SAC @ OKC  W    5    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
117   0.889       ...            2    4    0    1    2    0   1   18   
118   1.000       ...            3    6    0    1    0    0   3   12   
119   0.000       ...            0    1    0    0    0    0   1    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
117          16                1  
118          -5                1  
119          -6                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
116      22015     203112  21500556 2016-01-09  SAC vs. GSW  L   22    3    4   
117      22015     203112  21500539 2016-01-07  SAC vs. LAL  W   25    8    9   
118      22015     203112  21500523 2016-01-05    SAC @ DAL  L   16    4    4   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
116   0.750       ...            2    3    0    0    0    0   3    9   
117   0.889       ...            2    4    0    1    2    0   1   18   
118   1.000       ...            3    6    0    1    0    0   3   12   

     PLUS_MINUS  VIDEO_AVAILABLE  
116          -8                1  
117          16                1  
118          -5                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
115      22015     203112  21500585 2016-01-13  SAC vs. NOP  L    9    0    1   
116      22015     203112  21500556 2016-01-09  SAC vs. GSW  L   22    3    4   
117      22015     203112  21500539 2016-01-07  SAC vs. LAL  W   25    8    9   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
115   0.000       ...            2    2    1    0    1    0   0    0   
116   0.750       ...            2    3    0    0    0    0   3    9   
117   0.889       ...            2    4    0    1    2    0   1   18   

     PLUS_MINUS  VIDEO_AVAILABLE  
115          -1                1  
116          -8                1  
117          16                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
114      22015     203112  21500638 2016-01-20    SAC @ LAL  W    2    1    2   
115      22015     203112  21500585 2016-01-13  SAC vs. NOP  L    9    0    1   
116      22015     203112  21500556 2016-01-09  SAC vs. GSW  L   22    3    4   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
114    0.50       ...            0    0    0    0    0    0   0    2   
115    0.00       ...            2    2    1    0    1    0   0    0   
116    0.75       ...            2    3    0    0    0    0   3    9   

     PLUS_MINUS  VIDEO_AVAILABLE  
114           1                1  
115          -1                1  
116          -8                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
113      22015     203112  21500643 2016-01-21  SAC vs. ATL  W   11    1    2   
114      22015     203112  21500638 2016-01-20    SAC @ LAL  W    2    1    2   
115      22015     203112  21500585 2016-01-13  SAC vs. NOP  L    9    0    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
113     0.5       ...            1    1    0    0    0    0   1    4   
114     0.5       ...            0    0    0    0    0    0   0    2   
115     0.0       ...            2    2    1    0    1    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
113         -10                1  
114           1                1  
115          -1                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
112      22015     203112  21500682 2016-01-26    SAC @ POR  L   17    2    4   
113      22015     203112  21500643 2016-01-21  SAC vs. ATL  W   11    1    2   
114      22015     203112  21500638 2016-01-20    SAC @ LAL  W    2    1    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
112     0.5       ...            3    6    1    1    0    1   1    4   
113     0.5       ...            1    1    0    0    0    0   1    4   
114     0.5       ...            0    0    0    0    0    0   0    2   

     PLUS_MINUS  VIDEO_AVAILABLE  
112          -3                1  
113         -10                1  
114           1                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
111      22015     203112  21500696 2016-01-28    SAC @ NOP  L   19    1    3   
112      22015     203112  21500682 2016-01-26    SAC @ POR  L   17    2    4   
113      22015     203112  21500643 2016-01-21  SAC vs. ATL  W   11    1    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
111   0.333       ...            7    9    0    0    0    1   2    3   
112   0.500       ...            3    6    1    1    0    1   1    4   
113   0.500       ...            1    1    0    0    0    0   1    4   

     PLUS_MINUS  VIDEO_AVAILABLE  
111           3                1  
112          -3                1  
113         -10                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
110      22015     203112  21500712 2016-01-30  SAC @ MEM  L   11    3    3   
111      22015     203112  21500696 2016-01-28  SAC @ NOP  L   19    1    3   
112      22015     203112  21500682 2016-01-26  SAC @ POR  L   17    2    4   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
110   1.000       ...            1    3    0    0    0    0   2    6   
111   0.333       ...            7    9    0    0    0    1   2    3   
112   0.500       ...            3    6    1    1    0    1   1    4   

     PLUS_MINUS  VIDEO_AVAILABLE  
110           4                1  
111           3                1  
112          -3                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
109      22015     203112  21500729 2016-02-01  SAC vs. MIL  W   17    2    7   
110      22015     203112  21500712 2016-01-30    SAC @ MEM  L   11    3    3   
111      22015     203112  21500696 2016-01-28    SAC @ NOP  L   19    1    3   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
109   0.286       ...            1    8    1    0    0    0   2    4   
110   1.000       ...            1    3    0    0    0    0   2    6   
111   0.333       ...            7    9    0    0    0    1   2    3   

     PLUS_MINUS  VIDEO_AVAILABLE  
109          -3                1  
110           4                1  
111           3                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
108      22015     203112  21500754 2016-02-05    SAC @ BKN  L    6    0    0   
109      22015     203112  21500729 2016-02-01  SAC vs. MIL  W   17    2    7   
110      22015     203112  21500712 2016-01-30    SAC @ MEM  L   11    3    3   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
108   0.000       ...            0    0    0    0    1    0   0    0   
109   0.286       ...            1    8    1    0    0    0   2    4   
110   1.000       ...            1    3    0    0    0    0   2    6   

     PLUS_MINUS  VIDEO_AVAILABLE  
108          -4                1  
109          -3                1  
110           4                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
107      22015     203112  21500773 2016-02-07    SAC @ BOS  L    3    0    0   
108      22015     203112  21500754 2016-02-05    SAC @ BKN  L    6    0    0   
109      22015     203112  21500729 2016-02-01  SAC vs. MIL  W   17    2    7   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
107   0.000       ...            0    1    0    0    0    0   0    0   
108   0.000       ...            0    0    0    0    1    0   0    0   
109   0.286       ...            1    8    1    0    0    0   2    4   

     PLUS_MINUS  VIDEO_AVAILABLE  
107          -2                1  
108          -4                1  
109          -3                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
106      22015     203112  21500775 2016-02-08  SAC @ CLE  L    5    1    2   
107      22015     203112  21500773 2016-02-07  SAC @ BOS  L    3    0    0   
108      22015     203112  21500754 2016-02-05  SAC @ BKN  L    6    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
106     0.5       ...            0    1    0    1    0    0   0    3   
107     0.0       ...            0    1    0    0    0    0   0    0   
108     0.0       ...            0    0    0    0    1    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
106          -2                1  
107          -2                1  
108          -4                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
105      22015     203112  21500791 2016-02-10  SAC @ PHI  W   15    2    3   
106      22015     203112  21500775 2016-02-08  SAC @ CLE  L    5    1    2   
107      22015     203112  21500773 2016-02-07  SAC @ BOS  L    3    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
105   0.667       ...            1    4    0    0    2    1   3    6   
106   0.500       ...            0    1    0    1    0    0   0    3   
107   0.000       ...            0    1    0    0    0    0   0    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
105          13                1  
106          -2                1  
107          -2                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
104      22015     203112  21500816 2016-02-19  SAC vs. DEN  W   15    0    0   
105      22015     203112  21500791 2016-02-10    SAC @ PHI  W   15    2    3   
106      22015     203112  21500775 2016-02-08    SAC @ CLE  L    5    1    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
104   0.000       ...            3    3    0    0    0    1   1    0   
105   0.667       ...            1    4    0    0    2    1   3    6   
106   0.500       ...            0    1    0    1    0    0   0    3   

     PLUS_MINUS  VIDEO_AVAILABLE  
104           2                1  
105          13                1  
106          -2                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
103      22015     203112  21500842 2016-02-23    SAC @ DEN  W   13    0    2   
104      22015     203112  21500816 2016-02-19  SAC vs. DEN  W   15    0    0   
105      22015     203112  21500791 2016-02-10    SAC @ PHI  W   15    2    3   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
103   0.000       ...            3    3    0    0    3    0   1    0   
104   0.000       ...            3    3    0    0    0    1   1    0   
105   0.667       ...            1    4    0    0    2    1   3    6   

     PLUS_MINUS  VIDEO_AVAILABLE  
103          -1                1  
104           2                1  
105          13                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
102      22015     203112  21500854 2016-02-24  SAC vs. SAS  L   23    6    9   
103      22015     203112  21500842 2016-02-23    SAC @ DEN  W   13    0    2   
104      22015     203112  21500816 2016-02-19  SAC vs. DEN  W   15    0    0   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
102   0.667       ...            2    2    0    2    0    1   4   15   
103   0.000       ...            3    3    0    0    3    0   1    0   
104   0.000       ...            3    3    0    0    0    1   1    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
102          13                1  
103          -1                1  
104           2                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
101      22015     203112  21500867 2016-02-26  SAC vs. LAC  L   15    1    1   
102      22015     203112  21500854 2016-02-24  SAC vs. SAS  L   23    6    9   
103      22015     203112  21500842 2016-02-23    SAC @ DEN  W   13    0    2   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
101   1.000       ...            0    0    0    0    1    0   3    4   
102   0.667       ...            2    2    0    2    0    1   4   15   
103   0.000       ...            3    3    0    0    3    0   1    0   

     PLUS_MINUS  VIDEO_AVAILABLE  
101         -12                1  
102          13                1  
103          -1                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
100      22015     203112  21500889 2016-02-29  SAC vs. OKC  L   28    5    9   
101      22015     203112  21500867 2016-02-26  SAC vs. LAC  L   15    1    1   
102      22015     203112  21500854 2016-02-24  SAC vs. SAS  L   23    6    9   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
100   0.556       ...            0    4    2    3    0    0   3   10   
101   1.000       ...            0    0    0    0    1    0   3    4   
102   0.667       ...            2    2    0    2    0    1   4   15   

     PLUS_MINUS  VIDEO_AVAILABLE  
100         -16                1  
101         -12                1  
102          13                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
99       22015     203112  21500902 2016-03-02    SAC @ MEM  L   26    5    6   
100      22015     203112  21500889 2016-02-29  SAC vs. OKC  L   28    5    9   
101      22015     203112  21500867 2016-02-26  SAC vs. LAC  L   15    1    1   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
99    0.833       ...            2    3    1    1    0    1   5   11   
100   0.556       ...            0    4    2    3    0    0   3   10   
101   1.000       ...            0    0    0    0    1    0   3    4   

     PLUS_MINUS  VIDEO_AVAILABLE  
99           -5                1  
100         -16                1  
101         -12                1  

[3 rows x 27 columns]
     SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
98       22015     203112  21500910 2016-03-03    SAC @ DAL  W   16    2    2   
99       22015     203112  21500902 2016-03-02    SAC @ MEM  L   26    5    6   
100      22015     203112  21500889 2016-02-29  SAC vs. OKC  L   28    5    9   

     FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
98    1.000       ...            3    3    0    0    0    2   1    4   
99    0.833       ...            2    3    1    1    0    1   5   11   
100   0.556       ...            0    4    2    3    0    0   3   10   

     PLUS_MINUS  VIDEO_AVAILABLE  
98            1                1  
99           -5                1  
100         -16                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
97      22015     203112  21500928 2016-03-05  SAC @ SAS  L   31    7    7   
98      22015     203112  21500910 2016-03-03  SAC @ DAL  W   16    2    2   
99      22015     203112  21500902 2016-03-02  SAC @ MEM  L   26    5    6   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
97   1.000       ...            6    7    1    1    0    1   4   16   
98   1.000       ...            3    3    0    0    0    2   1    4   
99   0.833       ...            2    3    1    1    0    1   5   11   

    PLUS_MINUS  VIDEO_AVAILABLE  
97         -10                1  
98           1                1  
99          -5                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
96      22015     203112  21500941 2016-03-07  SAC @ NOP  L   20    1    2   
97      22015     203112  21500928 2016-03-05  SAC @ SAS  L   31    7    7   
98      22015     203112  21500910 2016-03-03  SAC @ DAL  W   16    2    2   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
96     0.5       ...            6    8    2    0    0    0   3    2   
97     1.0       ...            6    7    1    1    0    1   4   16   
98     1.0       ...            3    3    0    0    0    2   1    4   

    PLUS_MINUS  VIDEO_AVAILABLE  
96           1                1  
97         -10                1  
98           1                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
95      22015     203112  21500957 2016-03-09  SAC vs. CLE  L   21    3    5   
96      22015     203112  21500941 2016-03-07    SAC @ NOP  L   20    1    2   
97      22015     203112  21500928 2016-03-05    SAC @ SAS  L   31    7    7   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
95     0.6       ...            4    4    0    0    1    0   3    8   
96     0.5       ...            6    8    2    0    0    0   3    2   
97     1.0       ...            6    7    1    1    0    1   4   16   

    PLUS_MINUS  VIDEO_AVAILABLE  
95          -6                1  
96           1                1  
97         -10                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
94      22015     203112  21500970 2016-03-11  SAC vs. ORL  L   14    1    2   
95      22015     203112  21500957 2016-03-09  SAC vs. CLE  L   21    3    5   
96      22015     203112  21500941 2016-03-07    SAC @ NOP  L   20    1    2   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
94     0.5       ...            3    4    1    0    0    1   2    3   
95     0.6       ...            4    4    0    0    1    0   3    8   
96     0.5       ...            6    8    2    0    0    0   3    2   

    PLUS_MINUS  VIDEO_AVAILABLE  
94         -15                1  
95          -6                1  
96           1                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
93      22015     203112  21500986 2016-03-13  SAC vs. UTA  L   11    1    2   
94      22015     203112  21500970 2016-03-11  SAC vs. ORL  L   14    1    2   
95      22015     203112  21500957 2016-03-09  SAC vs. CLE  L   21    3    5   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
93     0.5       ...            1    1    0    0    0    0   2    2   
94     0.5       ...            3    4    1    0    0    1   2    3   
95     0.6       ...            4    4    0    0    1    0   3    8   

    PLUS_MINUS  VIDEO_AVAILABLE  
93         -17                1  
94         -15                1  
95          -6                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
92      22015     203112  21501002 2016-03-15    SAC @ LAL  W    5    0    1   
93      22015     203112  21500986 2016-03-13  SAC vs. UTA  L   11    1    2   
94      22015     203112  21500970 2016-03-11  SAC vs. ORL  L   14    1    2   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
92     0.0       ...            1    1    0    0    0    0   0    1   
93     0.5       ...            1    1    0    0    0    0   2    2   
94     0.5       ...            3    4    1    0    0    1   2    3   

    PLUS_MINUS  VIDEO_AVAILABLE  
92          -5                1  
93         -17                1  
94         -15                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
91      22015     203112  21501010 2016-03-16  SAC vs. NOP  L   14    2    2   
92      22015     203112  21501002 2016-03-15    SAC @ LAL  W    5    0    1   
93      22015     203112  21500986 2016-03-13  SAC vs. UTA  L   11    1    2   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
91     1.0       ...            1    1    0    1    0    0   3    5   
92     0.0       ...            1    1    0    0    0    0   0    1   
93     0.5       ...            1    1    0    0    0    0   2    2   

    PLUS_MINUS  VIDEO_AVAILABLE  
91          10                1  
92          -5                1  
93         -17                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
90      22015     203112  21501022 2016-03-18    SAC @ DET  L   18    1    3   
91      22015     203112  21501010 2016-03-16  SAC vs. NOP  L   14    2    2   
92      22015     203112  21501002 2016-03-15    SAC @ LAL  W    5    0    1   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
90   0.333       ...            1    3    1    1    0    1   2    6   
91   1.000       ...            1    1    0    1    0    0   3    5   
92   0.000       ...            1    1    0    0    0    0   0    1   

    PLUS_MINUS  VIDEO_AVAILABLE  
90          -6                1  
91          10                1  
92          -5                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
89      22015     203112  21501042 2016-03-20    SAC @ NYK  W   23    1    4   
90      22015     203112  21501022 2016-03-18    SAC @ DET  L   18    1    3   
91      22015     203112  21501010 2016-03-16  SAC vs. NOP  L   14    2    2   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
89   0.250       ...            4    4    1    1    0    1   2    3   
90   0.333       ...            1    3    1    1    0    1   2    6   
91   1.000       ...            1    1    0    1    0    0   3    5   

    PLUS_MINUS  VIDEO_AVAILABLE  
89           3                1  
90          -6                1  
91          10                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
88      22015     203112  21501049 2016-03-21  SAC @ CHI  L   11    1    2   
89      22015     203112  21501042 2016-03-20  SAC @ NYK  W   23    1    4   
90      22015     203112  21501022 2016-03-18  SAC @ DET  L   18    1    3   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
88   0.500       ...            1    1    0    0    0    0   2    2   
89   0.250       ...            4    4    1    1    0    1   2    3   
90   0.333       ...            1    3    1    1    0    1   2    6   

    PLUS_MINUS  VIDEO_AVAILABLE  
88          -3                1  
89           3                1  
90          -6                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE    MATCHUP WL  MIN  FGM  FGA  \
87      22015     203112  21501062 2016-03-23  SAC @ MIN  L   22    4    5   
88      22015     203112  21501049 2016-03-21  SAC @ CHI  L   11    1    2   
89      22015     203112  21501042 2016-03-20  SAC @ NYK  W   23    1    4   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
87    0.80       ...            0    2    1    0    0    1   3    9   
88    0.50       ...            1    1    0    0    0    0   2    2   
89    0.25       ...            4    4    1    1    0    1   2    3   

    PLUS_MINUS  VIDEO_AVAILABLE  
87          -7                1  
88          -3                1  
89           3                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
86      22015     203112  21501079 2016-03-25  SAC vs. PHX  W   19    4    9   
87      22015     203112  21501062 2016-03-23    SAC @ MIN  L   22    4    5   
88      22015     203112  21501049 2016-03-21    SAC @ CHI  L   11    1    2   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
86   0.444       ...            7    7    0    0    2    1   4   14   
87   0.800       ...            0    2    1    0    0    1   3    9   
88   0.500       ...            1    1    0    0    0    0   2    2   

    PLUS_MINUS  VIDEO_AVAILABLE  
86           9                1  
87          -7                1  
88          -3                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
85      22015     203112  21501095 2016-03-27  SAC vs. DAL  W   17    3    4   
86      22015     203112  21501079 2016-03-25  SAC vs. PHX  W   19    4    9   
87      22015     203112  21501062 2016-03-23    SAC @ MIN  L   22    4    5   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
85   0.750       ...            2    3    0    2    0    0   1    7   
86   0.444       ...            7    7    0    0    2    1   4   14   
87   0.800       ...            0    2    1    0    0    1   3    9   

    PLUS_MINUS  VIDEO_AVAILABLE  
85           8                1  
86           9                1  
87          -7                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
84      22015     203112  21501105 2016-03-28    SAC @ POR  L   28    4    8   
85      22015     203112  21501095 2016-03-27  SAC vs. DAL  W   17    3    4   
86      22015     203112  21501079 2016-03-25  SAC vs. PHX  W   19    4    9   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
84   0.500       ...            3    4    1    1    1    1   3   10   
85   0.750       ...            2    3    0    2    0    0   1    7   
86   0.444       ...            7    7    0    0    2    1   4   14   

    PLUS_MINUS  VIDEO_AVAILABLE  
84          -4                1  
85           8                1  
86           9                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
83      22015     203112  21501120 2016-03-30  SAC vs. WAS  W   13    3    3   
84      22015     203112  21501105 2016-03-28    SAC @ POR  L   28    4    8   
85      22015     203112  21501095 2016-03-27  SAC vs. DAL  W   17    3    4   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
83    1.00       ...            4    5    0    1    0    0   1    7   
84    0.50       ...            3    4    1    1    1    1   3   10   
85    0.75       ...            2    3    0    2    0    0   1    7   

    PLUS_MINUS  VIDEO_AVAILABLE  
83           3                1  
84          -4                1  
85           8                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
82      22015     203112  21501135 2016-04-01  SAC vs. MIA  L   14    2    6   
83      22015     203112  21501120 2016-03-30  SAC vs. WAS  W   13    3    3   
84      22015     203112  21501105 2016-03-28    SAC @ POR  L   28    4    8   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
82   0.333       ...            0    2    0    0    0    0   2    4   
83   1.000       ...            4    5    0    1    0    0   1    7   
84   0.500       ...            3    4    1    1    1    1   3   10   

    PLUS_MINUS  VIDEO_AVAILABLE  
82         -10                1  
83           3                1  
84          -4                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
81      22015     203112  21501141 2016-04-02    SAC @ DEN  W   17    2    8   
82      22015     203112  21501135 2016-04-01  SAC vs. MIA  L   14    2    6   
83      22015     203112  21501120 2016-03-30  SAC vs. WAS  W   13    3    3   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
81   0.250       ...            4    6    2    0    1    0   2    5   
82   0.333       ...            0    2    0    0    0    0   2    4   
83   1.000       ...            4    5    0    1    0    0   1    7   

    PLUS_MINUS  VIDEO_AVAILABLE  
81          -5                1  
82         -10                1  
83           3                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
80      22015     203112  21501162 2016-04-05  SAC vs. POR  L   15    3    5   
81      22015     203112  21501141 2016-04-02    SAC @ DEN  W   17    2    8   
82      22015     203112  21501135 2016-04-01  SAC vs. MIA  L   14    2    6   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
80   0.600       ...            0    0    0    0    0    0   1    8   
81   0.250       ...            4    6    2    0    1    0   2    5   
82   0.333       ...            0    2    0    0    0    0   2    4   

    PLUS_MINUS  VIDEO_AVAILABLE  
80         -15                1  
81          -5                1  
82         -10                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
79      22015     203112  21501176 2016-04-07  SAC vs. MIN  L   28    7   12   
80      22015     203112  21501162 2016-04-05  SAC vs. POR  L   15    3    5   
81      22015     203112  21501141 2016-04-02    SAC @ DEN  W   17    2    8   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
79   0.583       ...            3    6    1    0    1    1   3   17   
80   0.600       ...            0    0    0    0    0    0   1    8   
81   0.250       ...            4    6    2    0    1    0   2    5   

    PLUS_MINUS  VIDEO_AVAILABLE  
79         -10                1  
80         -15                1  
81          -5                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
78      22015     203112  21501193 2016-04-09  SAC vs. OKC  W   21    3    5   
79      22015     203112  21501176 2016-04-07  SAC vs. MIN  L   28    7   12   
80      22015     203112  21501162 2016-04-05  SAC vs. POR  L   15    3    5   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
78   0.600       ...            5    8    0    1    0    1   1    7   
79   0.583       ...            3    6    1    0    1    1   3   17   
80   0.600       ...            0    0    0    0    0    0   1    8   

    PLUS_MINUS  VIDEO_AVAILABLE  
78          16                1  
79         -10                1  
80         -15                1  

[3 rows x 27 columns]
    SEASON_ID  Player_ID   Game_ID  GAME_DATE      MATCHUP WL  MIN  FGM  FGA  \
77      22015     203112  21501211 2016-04-11    SAC @ PHX  W   16    2    2   
78      22015     203112  21501193 2016-04-09  SAC vs. OKC  W   21    3    5   
79      22015     203112  21501176 2016-04-07  SAC vs. MIN  L   28    7   12   

    FG_PCT       ...         DREB  REB  AST  STL  BLK  TOV  PF  PTS  \
77   1.000       ...            0    1    1    1    2    3   2    9   
78   0.600       ...            5    8    0    1    0    1   1    7   
79   0.583       ...            3    6    1    0    1    1   3   17   

    PLUS_MINUS  VIDEO_AVAILABLE  
77           8                1  
78          16                1  
79         -10                1  

[3 rows x 27 columns]

In [23]:
stats


Out[23]:
Game_ID PTS PTS_avg
134 21500067.0 0.0 NaN
133 21500092.0 3.0 0.000000
132 21500103.0 3.0 1.500000
131 21500137.0 3.0 2.000000
130 21500150.0 2.0 3.000000
129 21500169.0 0.0 2.666667
128 21500175.0 0.0 1.666667
127 21500237.0 1.0 0.666667
126 21500245.0 9.0 0.333333
125 21500282.0 2.0 3.333333
124 21500293.0 2.0 4.000000
123 21500369.0 0.0 4.333333
122 21500468.0 8.0 1.333333
121 21500483.0 2.0 3.333333
120 21500496.0 2.0 3.333333
119 21500517.0 0.0 4.000000
118 21500523.0 12.0 1.333333
117 21500539.0 18.0 4.666667
116 21500556.0 9.0 10.000000
115 21500585.0 0.0 13.000000
114 21500638.0 2.0 9.000000
113 21500643.0 4.0 3.666667
112 21500682.0 4.0 2.000000
111 21500696.0 3.0 3.333333
110 21500712.0 6.0 3.666667
109 21500729.0 4.0 4.333333
108 21500754.0 0.0 4.333333
107 21500773.0 0.0 3.333333
106 21500775.0 3.0 1.333333
105 21500791.0 6.0 1.000000
104 21500816.0 0.0 3.000000
103 21500842.0 0.0 3.000000
102 21500854.0 15.0 2.000000
101 21500867.0 4.0 5.000000
100 21500889.0 10.0 6.333333
99 21500902.0 11.0 9.666667
98 21500910.0 4.0 8.333333
97 21500928.0 16.0 8.333333
96 21500941.0 2.0 10.333333
95 21500957.0 8.0 7.333333
94 21500970.0 3.0 8.666667
93 21500986.0 2.0 4.333333
92 21501002.0 1.0 4.333333
91 21501010.0 5.0 2.000000
90 21501022.0 6.0 2.666667
89 21501042.0 3.0 4.000000
88 21501049.0 2.0 4.666667
87 21501062.0 9.0 3.666667
86 21501079.0 14.0 4.666667
85 21501095.0 7.0 8.333333
84 21501105.0 10.0 10.000000
83 21501120.0 7.0 10.333333
82 21501135.0 4.0 8.000000
81 21501141.0 5.0 7.000000
80 21501162.0 8.0 5.333333
79 21501176.0 17.0 5.666667
78 21501193.0 7.0 10.000000
77 21501211.0 9.0 10.666667
76 21501224.0 10.0 11.000000

In [26]:



---------------------------------------------------------------------------
ImportError                               Traceback (most recent call last)
<ipython-input-26-758b8d67f268> in <module>()
----> 1 from Regression.Reg_Model import Reg_Model
      2 p = Player(pid=203112)
      3 ga = p.game_logs
      4 stats=p.get_stats('GAME_DATE', 'Game_ID', 'PTS', ['PTS', 'MIN', 'FGM', 'FGA', 'FG_PCT'],5)
      5 model = Reg_Model()

ImportError: No module named Regression.Reg_Model

In [ ]: