Get All-Star Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Load All-Star Data From NBA API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def boxscoretraditionalv2(GameID,EndPeriod='10',EndRange='28800',RangeType='0',StartPeriod='1',StartRange='0'):\n",
    "    url = 'http://stats.nba.com/stats/boxscoretraditionalv2?'\n",
    "    api_param = {\n",
    "        'EndPeriod' : EndPeriod,\n",
    "        'EndRange' : EndRange,\n",
    "        'GameID' : GameID,\n",
    "        'RangeType' : RangeType,\n",
    "        'StartPeriod' : StartPeriod,\n",
    "        'StartRange' : StartRange,\n",
    "        }\n",
    "    u_a = \"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.82 Safari/537.36\"\n",
    "    response = requests.get(url,params=api_param,headers={\"USER-AGENT\":u_a})\n",
    "    data = response.json()\n",
    "    return pd.DataFrame(data['resultSets'][0]['rowSet'],columns=data['resultSets'][0]['headers'])\n",
    "\n",
    "def commonallplayers(currentseason=0,leagueid='00',season='2015-16'):\n",
    "    url = 'http://stats.nba.com/stats/commonallplayers?'\n",
    "    api_param = {\n",
    "        'IsOnlyCurrentSeason' : currentseason,\n",
    "        'LeagueID' : leagueid,\n",
    "        'Season' : season,             \n",
    "    }\n",
    "    u_a = \"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.82 Safari/537.36\"\n",
    "    response = requests.get(url,params=api_param,headers={\"USER-AGENT\":u_a})\n",
    "    data = response.json()\n",
    "    return pd.DataFrame(data['resultSets'][0]['rowSet'],columns=data['resultSets'][0]['headers'])\n",
    "\n",
    "def seasons_string(start,end):\n",
    "    '''\n",
    "    creates a list of NBA seasons from start-end\n",
    "    '''\n",
    "    years = np.arange(start,end+1)\n",
    "    seasons = []\n",
    "    for year in years:\n",
    "        string1 = str(year)\n",
    "        string2 = str(year+1)\n",
    "        season = '{}-{}'.format(string1,string2[-2:])\n",
    "        seasons.append(season)\n",
    "    return seasons\n",
    "\n",
    "def gamelog(counter = 1000,datefrom='',dateto='',direction='DESC',leagueid='00',\n",
    "            playerorteam='T',season='2015-16',seasontype='Regular Season',sorter='PTS'):   \n",
    "    url = 'http://stats.nba.com/stats/leaguegamelog?'\n",
    "    api_param = {\n",
    "        'Counter' : counter,\n",
    "        'DateFrom' :  datefrom,\n",
    "        'DateTo' : dateto,\n",
    "        'Direction' : direction,\n",
    "        'LeagueID' : leagueid,\n",
    "        'PlayerOrTeam' : playerorteam,\n",
    "        'Season' : season,\n",
    "        'SeasonType' : seasontype,\n",
    "        'Sorter' : sorter,              \n",
    "    }\n",
    "    u_a = \"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.82 Safari/537.36\"\n",
    "    response = requests.get(url,params=api_param,headers={\"USER-AGENT\":u_a})\n",
    "    data = response.json()\n",
    "    return pd.DataFrame(data['resultSets'][0]['rowSet'],columns=data['resultSets'][0]['headers'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get game logs for all all-star games since 1978"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SEASON_ID</th>\n",
       "      <th>TEAM_ID</th>\n",
       "      <th>TEAM_ABBREVIATION</th>\n",
       "      <th>TEAM_NAME</th>\n",
       "      <th>GAME_ID</th>\n",
       "      <th>GAME_DATE</th>\n",
       "      <th>MATCHUP</th>\n",
       "      <th>WL</th>\n",
       "      <th>MIN</th>\n",
       "      <th>FGM</th>\n",
       "      <th>...</th>\n",
       "      <th>DREB</th>\n",
       "      <th>REB</th>\n",
       "      <th>AST</th>\n",
       "      <th>STL</th>\n",
       "      <th>BLK</th>\n",
       "      <th>TOV</th>\n",
       "      <th>PF</th>\n",
       "      <th>PTS</th>\n",
       "      <th>PLUS_MINUS</th>\n",
       "      <th>VIDEO_AVAILABLE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31978</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars West</td>\n",
       "      <td>0037800029</td>\n",
       "      <td>1979-02-04</td>\n",
       "      <td>WST @ EST</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>56</td>\n",
       "      <td>...</td>\n",
       "      <td>30</td>\n",
       "      <td>45</td>\n",
       "      <td>25</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>24</td>\n",
       "      <td>134</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31978</td>\n",
       "      <td>1610616833</td>\n",
       "      <td>EST</td>\n",
       "      <td>East NBA All Stars East</td>\n",
       "      <td>0037800029</td>\n",
       "      <td>1979-02-04</td>\n",
       "      <td>EST vs. WST</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>50</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>53</td>\n",
       "      <td>22</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>26</td>\n",
       "      <td>129</td>\n",
       "      <td>-5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31979</td>\n",
       "      <td>1610616833</td>\n",
       "      <td>EST</td>\n",
       "      <td>East NBA All Stars East</td>\n",
       "      <td>0037900001</td>\n",
       "      <td>1980-02-03</td>\n",
       "      <td>EST vs. WST</td>\n",
       "      <td>W</td>\n",
       "      <td>265</td>\n",
       "      <td>58</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>62</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>9</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>144</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31979</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars West</td>\n",
       "      <td>0037900001</td>\n",
       "      <td>1980-02-03</td>\n",
       "      <td>WST @ EST</td>\n",
       "      <td>L</td>\n",
       "      <td>265</td>\n",
       "      <td>53</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>55</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>29</td>\n",
       "      <td>32</td>\n",
       "      <td>136</td>\n",
       "      <td>-8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31980</td>\n",
       "      <td>1610616833</td>\n",
       "      <td>EST</td>\n",
       "      <td>East NBA All Stars East</td>\n",
       "      <td>0038000001</td>\n",
       "      <td>1981-02-01</td>\n",
       "      <td>EST vs. WST</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>49</td>\n",
       "      <td>...</td>\n",
       "      <td>28</td>\n",
       "      <td>48</td>\n",
       "      <td>30</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>123</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>31980</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars West</td>\n",
       "      <td>0038000001</td>\n",
       "      <td>1981-02-01</td>\n",
       "      <td>WST @ EST</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>46</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>51</td>\n",
       "      <td>22</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "      <td>28</td>\n",
       "      <td>120</td>\n",
       "      <td>-3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>31981</td>\n",
       "      <td>1610616833</td>\n",
       "      <td>EST</td>\n",
       "      <td>East NBA All Stars East</td>\n",
       "      <td>0038100002</td>\n",
       "      <td>1982-01-31</td>\n",
       "      <td>EST vs. WST</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>51</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>57</td>\n",
       "      <td>30</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>21</td>\n",
       "      <td>28</td>\n",
       "      <td>120</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>31981</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars West</td>\n",
       "      <td>0038100002</td>\n",
       "      <td>1982-01-31</td>\n",
       "      <td>WST @ EST</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>50</td>\n",
       "      <td>...</td>\n",
       "      <td>37</td>\n",
       "      <td>60</td>\n",
       "      <td>25</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>16</td>\n",
       "      <td>27</td>\n",
       "      <td>118</td>\n",
       "      <td>-2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>31982</td>\n",
       "      <td>1610616833</td>\n",
       "      <td>EST</td>\n",
       "      <td>East NBA All Stars East</td>\n",
       "      <td>0038200001</td>\n",
       "      <td>1983-02-13</td>\n",
       "      <td>EST @ WST</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>57</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>52</td>\n",
       "      <td>36</td>\n",
       "      <td>17</td>\n",
       "      <td>6</td>\n",
       "      <td>22</td>\n",
       "      <td>15</td>\n",
       "      <td>132</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>31982</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars West</td>\n",
       "      <td>0038200001</td>\n",
       "      <td>1983-02-13</td>\n",
       "      <td>WST vs. EST</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>55</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>24</td>\n",
       "      <td>18</td>\n",
       "      <td>123</td>\n",
       "      <td>-9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  SEASON_ID     TEAM_ID TEAM_ABBREVIATION                TEAM_NAME  \\\n",
       "0     31978  1610616834               WST  West NBA All Stars West   \n",
       "1     31978  1610616833               EST  East NBA All Stars East   \n",
       "2     31979  1610616833               EST  East NBA All Stars East   \n",
       "3     31979  1610616834               WST  West NBA All Stars West   \n",
       "4     31980  1610616833               EST  East NBA All Stars East   \n",
       "5     31980  1610616834               WST  West NBA All Stars West   \n",
       "6     31981  1610616833               EST  East NBA All Stars East   \n",
       "7     31981  1610616834               WST  West NBA All Stars West   \n",
       "8     31982  1610616833               EST  East NBA All Stars East   \n",
       "9     31982  1610616834               WST  West NBA All Stars West   \n",
       "\n",
       "      GAME_ID   GAME_DATE      MATCHUP WL  MIN FGM       ...       DREB  REB  \\\n",
       "0  0037800029  1979-02-04    WST @ EST  W  240  56       ...         30   45   \n",
       "1  0037800029  1979-02-04  EST vs. WST  L  240  50       ...         31   53   \n",
       "2  0037900001  1980-02-03  EST vs. WST  W  265  58       ...         31   62   \n",
       "3  0037900001  1980-02-03    WST @ EST  L  265  53       ...         31   55   \n",
       "4  0038000001  1981-02-01  EST vs. WST  W  240  49       ...         28   48   \n",
       "5  0038000001  1981-02-01    WST @ EST  L  240  46       ...         34   51   \n",
       "6  0038100002  1982-01-31  EST vs. WST  W  240  51       ...         44   57   \n",
       "7  0038100002  1982-01-31    WST @ EST  L  240  50       ...         37   60   \n",
       "8  0038200001  1983-02-13    EST @ WST  W  240  57       ...         31   52   \n",
       "9  0038200001  1983-02-13  WST vs. EST  L  240  55       ...         25   37   \n",
       "\n",
       "  AST STL BLK TOV  PF  PTS PLUS_MINUS VIDEO_AVAILABLE  \n",
       "0  25  10   3  13  24  134          5               0  \n",
       "1  22   8   3  16  26  129         -5               0  \n",
       "2  34  20   9  30  30  144          8               0  \n",
       "3  34  17  16  29  32  136         -8               0  \n",
       "4  30  15   5  17  23  123          3               0  \n",
       "5  22  10   7  22  28  120         -3               0  \n",
       "6  30  10   9  21  28  120          2               0  \n",
       "7  25  13  10  16  27  118         -2               0  \n",
       "8  36  17   6  22  15  132          9               0  \n",
       "9  37  17   7  24  18  123         -9               0  \n",
       "\n",
       "[10 rows x 29 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games = []\n",
    "for season in seasons_string(1978,2017):\n",
    "    df  = gamelog(season=season,seasontype='All Star')\n",
    "    games.append(df)\n",
    "games = pd.concat(games,ignore_index=True)\n",
    "games.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load box score for all the all-star games"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GAME_ID</th>\n",
       "      <th>TEAM_ID</th>\n",
       "      <th>TEAM_ABBREVIATION</th>\n",
       "      <th>TEAM_CITY</th>\n",
       "      <th>PLAYER_ID</th>\n",
       "      <th>PLAYER_NAME</th>\n",
       "      <th>START_POSITION</th>\n",
       "      <th>COMMENT</th>\n",
       "      <th>MIN</th>\n",
       "      <th>FGM</th>\n",
       "      <th>...</th>\n",
       "      <th>DREB</th>\n",
       "      <th>REB</th>\n",
       "      <th>AST</th>\n",
       "      <th>STL</th>\n",
       "      <th>BLK</th>\n",
       "      <th>TO</th>\n",
       "      <th>PF</th>\n",
       "      <th>PTS</th>\n",
       "      <th>PLUS_MINUS</th>\n",
       "      <th>SEASON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0030000001</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars</td>\n",
       "      <td>1495</td>\n",
       "      <td>Tim Duncan</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>28:14</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2017-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0030000001</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars</td>\n",
       "      <td>185</td>\n",
       "      <td>Chris Webber</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>28:57</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9</td>\n",
       "      <td>2017-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0030000001</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars</td>\n",
       "      <td>708</td>\n",
       "      <td>Kevin Garnett</td>\n",
       "      <td>C</td>\n",
       "      <td></td>\n",
       "      <td>27:20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>10</td>\n",
       "      <td>2017-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0030000001</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars</td>\n",
       "      <td>977</td>\n",
       "      <td>Kobe Bryant</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>29:31</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0030000001</td>\n",
       "      <td>1610616834</td>\n",
       "      <td>WST</td>\n",
       "      <td>West NBA All Stars</td>\n",
       "      <td>467</td>\n",
       "      <td>Jason Kidd</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>29:40</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>-3</td>\n",
       "      <td>2017-18</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      GAME_ID     TEAM_ID TEAM_ABBREVIATION           TEAM_CITY  PLAYER_ID  \\\n",
       "0  0030000001  1610616834               WST  West NBA All Stars       1495   \n",
       "1  0030000001  1610616834               WST  West NBA All Stars        185   \n",
       "2  0030000001  1610616834               WST  West NBA All Stars        708   \n",
       "3  0030000001  1610616834               WST  West NBA All Stars        977   \n",
       "4  0030000001  1610616834               WST  West NBA All Stars        467   \n",
       "\n",
       "     PLAYER_NAME START_POSITION COMMENT    MIN  FGM   ...     DREB   REB  AST  \\\n",
       "0     Tim Duncan              F          28:14  5.0   ...     10.0  14.0  1.0   \n",
       "1   Chris Webber              F          28:57  6.0   ...      5.0   9.0  3.0   \n",
       "2  Kevin Garnett              C          27:20  7.0   ...      3.0   4.0  4.0   \n",
       "3    Kobe Bryant              G          29:31  9.0   ...      2.0   4.0  7.0   \n",
       "4     Jason Kidd              G          29:40  4.0   ...      4.0   4.0  2.0   \n",
       "\n",
       "   STL  BLK   TO   PF   PTS  PLUS_MINUS   SEASON  \n",
       "0  2.0  1.0  2.0  1.0  14.0           8  2017-18  \n",
       "1  1.0  0.0  1.0  2.0  14.0           9  2017-18  \n",
       "2  1.0  3.0  2.0  0.0  14.0          10  2017-18  \n",
       "3  1.0  0.0  3.0  3.0  19.0           0  2017-18  \n",
       "4  5.0  0.0  5.0  3.0  11.0          -3  2017-18  \n",
       "\n",
       "[5 rows x 29 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = []\n",
    "ugames = np.unique(games['GAME_ID'].values)\n",
    "for gameid in ugames:\n",
    "    temp = boxscoretraditionalv2(gameid)\n",
    "    temp['SEASON'] = season\n",
    "    df.append(temp)\n",
    "df = pd.concat(df,ignore_index=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>AllStar_count</th>\n",
       "      <th>PLAYER_NAME</th>\n",
       "      <th>PLAYER_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17</td>\n",
       "      <td>Kobe Bryant</td>\n",
       "      <td>977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>15</td>\n",
       "      <td>Tim Duncan</td>\n",
       "      <td>1495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>Kevin Garnett</td>\n",
       "      <td>708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>14</td>\n",
       "      <td>LeBron James</td>\n",
       "      <td>2544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13</td>\n",
       "      <td>Michael Jordan</td>\n",
       "      <td>893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>13</td>\n",
       "      <td>Dirk Nowitzki</td>\n",
       "      <td>1717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>13</td>\n",
       "      <td>Shaquille O'Neal</td>\n",
       "      <td>406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>12</td>\n",
       "      <td>Karl Malone</td>\n",
       "      <td>252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>12</td>\n",
       "      <td>Hakeem Olajuwon</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11</td>\n",
       "      <td>Kareem Abdul-Jabbar</td>\n",
       "      <td>76003</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   AllStar_count          PLAYER_NAME  PLAYER_ID\n",
       "0             17          Kobe Bryant        977\n",
       "1             15           Tim Duncan       1495\n",
       "2             14        Kevin Garnett        708\n",
       "3             14         LeBron James       2544\n",
       "4             13       Michael Jordan        893\n",
       "5             13        Dirk Nowitzki       1717\n",
       "6             13     Shaquille O'Neal        406\n",
       "7             12          Karl Malone        252\n",
       "8             12      Hakeem Olajuwon        165\n",
       "9             11  Kareem Abdul-Jabbar      76003"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['PLAYER'] = zip(df['PLAYER_NAME'],df['PLAYER_ID']) # create a unique player column from name + id\n",
    "\n",
    "# Groupby to count how many times a player appeared in the games\n",
    "g = df.groupby('PLAYER').size()\n",
    "g = pd.DataFrame(g,index=g.index,columns=['AllStar_count'])\n",
    "g['PLAYER_NAME'],g['PLAYER_ID'] = zip(*g.index)\n",
    "g = g.sort_values(by='AllStar_count',ascending=False).reset_index(drop=True)\n",
    "g.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}