NBA_Racing_Barchart - Tyler.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "from scipy.stats import linregress\n",
    "# from wordcloud import WordCloud\n",
    "import seaborn as sns\n",
    "import bar_chart_race as bcr\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>First_Name</th>\n",
       "      <th>Last_Name</th>\n",
       "      <th>player_id</th>\n",
       "      <th>Position</th>\n",
       "      <th>Points</th>\n",
       "      <th>Free_Throw_Percent</th>\n",
       "      <th>Two_Pt_Percent</th>\n",
       "      <th>Three_Pt_Percent</th>\n",
       "      <th>...</th>\n",
       "      <th>Turnovers</th>\n",
       "      <th>Team</th>\n",
       "      <th>Home_Away</th>\n",
       "      <th>win</th>\n",
       "      <th>Team_points</th>\n",
       "      <th>Min_played</th>\n",
       "      <th>Crowd</th>\n",
       "      <th>Stadium_Cap</th>\n",
       "      <th>game_id</th>\n",
       "      <th>game_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>LeBron</td>\n",
       "      <td>James</td>\n",
       "      <td>0afbe608-940a-4d5d-a1f7-468718c67d91</td>\n",
       "      <td>F</td>\n",
       "      <td>19</td>\n",
       "      <td>50.0</td>\n",
       "      <td>81.818</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>32:23</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>James</td>\n",
       "      <td>Jones</td>\n",
       "      <td>09d25155-c3be-4246-a986-55921a1b5e61</td>\n",
       "      <td>G-F</td>\n",
       "      <td>5</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>5:30</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>J.R.</td>\n",
       "      <td>Smith</td>\n",
       "      <td>5934134d-0d27-42ea-a554-4b0e3e85ce56</td>\n",
       "      <td>G-F</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.000</td>\n",
       "      <td>25.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>25:14</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Kay</td>\n",
       "      <td>Felder</td>\n",
       "      <td>8d3acdd5-9b5a-4d69-9912-de42d979c31a</td>\n",
       "      <td>G</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>00:00</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Mike</td>\n",
       "      <td>Dunleavy</td>\n",
       "      <td>4ec1bff7-ec1b-488b-8a24-aed83e62b4ce</td>\n",
       "      <td>G-F</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>22:32</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Mo</td>\n",
       "      <td>Williams</td>\n",
       "      <td>e43acd9a-43b7-4676-9e97-2ba1d34ef2de</td>\n",
       "      <td>G</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>00:00</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Love</td>\n",
       "      <td>7d615ccd-db96-42a3-9a6c-7f18ea25634e</td>\n",
       "      <td>F</td>\n",
       "      <td>23</td>\n",
       "      <td>75.0</td>\n",
       "      <td>44.444</td>\n",
       "      <td>33.3</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>24:59</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>Richard</td>\n",
       "      <td>Jefferson</td>\n",
       "      <td>262d9b81-107d-4921-9002-7ece87bb8004</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>50.0</td>\n",
       "      <td>75.000</td>\n",
       "      <td>66.7</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>25:47</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>Kyrie</td>\n",
       "      <td>Irving</td>\n",
       "      <td>dd146010-902b-4ad7-b98c-650d0363a2f0</td>\n",
       "      <td>G</td>\n",
       "      <td>29</td>\n",
       "      <td>100.0</td>\n",
       "      <td>53.333</td>\n",
       "      <td>57.1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>29:48</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>Tristan</td>\n",
       "      <td>Thompson</td>\n",
       "      <td>335097c3-7919-49d5-80b0-8062d5d3e89c</td>\n",
       "      <td>C-F</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>Cavaliers</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>117</td>\n",
       "      <td>22:25</td>\n",
       "      <td>20562</td>\n",
       "      <td>20562</td>\n",
       "      <td>0da78f13-73ac-4465-8e31-ecc3029a5dc6</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Unnamed: 0.1 First_Name  Last_Name  \\\n",
       "0           0             0     LeBron      James   \n",
       "1           1             1      James      Jones   \n",
       "2           2             2       J.R.      Smith   \n",
       "3           3             3        Kay     Felder   \n",
       "4           4             4       Mike   Dunleavy   \n",
       "5           5             5         Mo   Williams   \n",
       "6           6             6      Kevin       Love   \n",
       "7           7             7    Richard  Jefferson   \n",
       "8           8             8      Kyrie     Irving   \n",
       "9           9             9    Tristan   Thompson   \n",
       "\n",
       "                              player_id Position  Points  Free_Throw_Percent  \\\n",
       "0  0afbe608-940a-4d5d-a1f7-468718c67d91        F      19                50.0   \n",
       "1  09d25155-c3be-4246-a986-55921a1b5e61      G-F       5               100.0   \n",
       "2  5934134d-0d27-42ea-a554-4b0e3e85ce56      G-F       8                 0.0   \n",
       "3  8d3acdd5-9b5a-4d69-9912-de42d979c31a        G       0                 0.0   \n",
       "4  4ec1bff7-ec1b-488b-8a24-aed83e62b4ce      G-F       4                 0.0   \n",
       "5  e43acd9a-43b7-4676-9e97-2ba1d34ef2de        G       0                 0.0   \n",
       "6  7d615ccd-db96-42a3-9a6c-7f18ea25634e        F      23                75.0   \n",
       "7  262d9b81-107d-4921-9002-7ece87bb8004        F      13                50.0   \n",
       "8  dd146010-902b-4ad7-b98c-650d0363a2f0        G      29               100.0   \n",
       "9  335097c3-7919-49d5-80b0-8062d5d3e89c      C-F       0                 0.0   \n",
       "\n",
       "   Two_Pt_Percent  Three_Pt_Percent  ...  Turnovers       Team  Home_Away  \\\n",
       "0          81.818               0.0  ...          4  Cavaliers          1   \n",
       "1           0.000             100.0  ...          0  Cavaliers          1   \n",
       "2          20.000              25.0  ...          0  Cavaliers          1   \n",
       "3           0.000               0.0  ...          0  Cavaliers          1   \n",
       "4         100.000               0.0  ...          0  Cavaliers          1   \n",
       "5           0.000               0.0  ...          0  Cavaliers          1   \n",
       "6          44.444              33.3  ...          2  Cavaliers          1   \n",
       "7          75.000              66.7  ...          2  Cavaliers          1   \n",
       "8          53.333              57.1  ...          0  Cavaliers          1   \n",
       "9           0.000               0.0  ...          2  Cavaliers          1   \n",
       "\n",
       "   win  Team_points  Min_played  Crowd  Stadium_Cap  \\\n",
       "0    1          117       32:23  20562        20562   \n",
       "1    1          117        5:30  20562        20562   \n",
       "2    1          117       25:14  20562        20562   \n",
       "3    1          117       00:00  20562        20562   \n",
       "4    1          117       22:32  20562        20562   \n",
       "5    1          117       00:00  20562        20562   \n",
       "6    1          117       24:59  20562        20562   \n",
       "7    1          117       25:47  20562        20562   \n",
       "8    1          117       29:48  20562        20562   \n",
       "9    1          117       22:25  20562        20562   \n",
       "\n",
       "                                game_id                  game_date  \n",
       "0  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "1  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "2  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "3  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "4  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "5  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "6  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "7  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "8  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "9  0da78f13-73ac-4465-8e31-ecc3029a5dc6  2016-10-25T23:30:00+00:00  \n",
       "\n",
       "[10 rows x 27 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_top50 = pd.read_csv(\"../data_files/fullplayerstatslist.csv\")\n",
    "nba_top50.head(10)"
   ]
  },
  {
   "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>player_name</th>\n",
       "      <th>Points</th>\n",
       "      <th>Position</th>\n",
       "      <th>game_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LeBron James</td>\n",
       "      <td>19</td>\n",
       "      <td>F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>James Jones</td>\n",
       "      <td>5</td>\n",
       "      <td>G-F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>J.R. Smith</td>\n",
       "      <td>8</td>\n",
       "      <td>G-F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kay Felder</td>\n",
       "      <td>0</td>\n",
       "      <td>G</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mike Dunleavy</td>\n",
       "      <td>4</td>\n",
       "      <td>G-F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182364</th>\n",
       "      <td>Marial Shayok</td>\n",
       "      <td>5</td>\n",
       "      <td>G-F</td>\n",
       "      <td>2020-08-15T01:00:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182365</th>\n",
       "      <td>Josh Richardson</td>\n",
       "      <td>5</td>\n",
       "      <td>G</td>\n",
       "      <td>2020-08-15T01:00:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182366</th>\n",
       "      <td>Glenn Robinson III</td>\n",
       "      <td>0</td>\n",
       "      <td>F</td>\n",
       "      <td>2020-08-15T01:00:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182367</th>\n",
       "      <td>Raul Neto</td>\n",
       "      <td>14</td>\n",
       "      <td>G</td>\n",
       "      <td>2020-08-15T01:00:00+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182368</th>\n",
       "      <td>Tobias Harris</td>\n",
       "      <td>18</td>\n",
       "      <td>F</td>\n",
       "      <td>2020-08-15T01:00:00+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>182369 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               player_name  Points Position                  game_date\n",
       "0             LeBron James      19        F  2016-10-25T23:30:00+00:00\n",
       "1              James Jones       5      G-F  2016-10-25T23:30:00+00:00\n",
       "2               J.R. Smith       8      G-F  2016-10-25T23:30:00+00:00\n",
       "3               Kay Felder       0        G  2016-10-25T23:30:00+00:00\n",
       "4            Mike Dunleavy       4      G-F  2016-10-25T23:30:00+00:00\n",
       "...                    ...     ...      ...                        ...\n",
       "182364       Marial Shayok       5      G-F  2020-08-15T01:00:00+00:00\n",
       "182365     Josh Richardson       5        G  2020-08-15T01:00:00+00:00\n",
       "182366  Glenn Robinson III       0        F  2020-08-15T01:00:00+00:00\n",
       "182367           Raul Neto      14        G  2020-08-15T01:00:00+00:00\n",
       "182368       Tobias Harris      18        F  2020-08-15T01:00:00+00:00\n",
       "\n",
       "[182369 rows x 4 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_top50['player_name'] = nba_top50['First_Name'].str.cat(nba_top50['Last_Name'], sep =\" \")\n",
    "nba_top50 = nba_top50[['player_name', 'Points','Position','game_date']]\n",
    "nba_top50\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "player_name                 object\n",
       "Points                       int64\n",
       "Position                    object\n",
       "game_date                   object\n",
       "Date           datetime64[ns, UTC]\n",
       "dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_top50['Date'] = pd.to_datetime(nba_top50['game_date'], errors='coerce')\n",
    "nba_top50.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "nba_top50['Date'] = nba_top50['Date'].dt.normalize()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "nba_top50['Date'] = nba_top50['Date'].dt.date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>player_name</th>\n",
       "      <th>Points</th>\n",
       "      <th>Position</th>\n",
       "      <th>game_date</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LeBron James</td>\n",
       "      <td>19</td>\n",
       "      <td>F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "      <td>2016-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>James Jones</td>\n",
       "      <td>5</td>\n",
       "      <td>G-F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "      <td>2016-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>J.R. Smith</td>\n",
       "      <td>8</td>\n",
       "      <td>G-F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "      <td>2016-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kay Felder</td>\n",
       "      <td>0</td>\n",
       "      <td>G</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "      <td>2016-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mike Dunleavy</td>\n",
       "      <td>4</td>\n",
       "      <td>G-F</td>\n",
       "      <td>2016-10-25T23:30:00+00:00</td>\n",
       "      <td>2016-10-25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     player_name  Points Position                  game_date        Date\n",
       "0   LeBron James      19        F  2016-10-25T23:30:00+00:00  2016-10-25\n",
       "1    James Jones       5      G-F  2016-10-25T23:30:00+00:00  2016-10-25\n",
       "2     J.R. Smith       8      G-F  2016-10-25T23:30:00+00:00  2016-10-25\n",
       "3     Kay Felder       0        G  2016-10-25T23:30:00+00:00  2016-10-25\n",
       "4  Mike Dunleavy       4      G-F  2016-10-25T23:30:00+00:00  2016-10-25"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_top50.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "player_name\n",
       "Damian Lillard           9787\n",
       "Russell Westbrook        9699\n",
       "Giannis Antetokounmpo    9392\n",
       "Anthony Davis            9300\n",
       "LeBron James             9262\n",
       "Bradley Beal             9017\n",
       "DeMar DeRozan            8832\n",
       "James Harden             8683\n",
       "Kemba Walker             8524\n",
       "Karl-Anthony Towns       8408\n",
       "Name: Points, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_top10 = nba_top50.groupby('player_name').sum()['Points']\n",
    "nba_top10 = nba_top10.sort_values(ascending=False)\n",
    "nba_top10 = nba_top10.head(10)\n",
    "nba_top10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>player_name</th>\n",
       "      <th>Damian Lillard</th>\n",
       "      <th>Russell Westbrook</th>\n",
       "      <th>Giannis Antetokounmpo</th>\n",
       "      <th>Anthony Davis</th>\n",
       "      <th>LeBron James</th>\n",
       "      <th>Bradley Beal</th>\n",
       "      <th>DeMar DeRozan</th>\n",
       "      <th>James Harden</th>\n",
       "      <th>Kemba Walker</th>\n",
       "      <th>Karl-Anthony Towns</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2016-10-25</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-26</th>\n",
       "      <td>39.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-27</th>\n",
       "      <td>NaN</td>\n",
       "      <td>32.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-28</th>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-29</th>\n",
       "      <td>NaN</td>\n",
       "      <td>51.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-11</th>\n",
       "      <td>61.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-12</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-14</th>\n",
       "      <td>42.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-15</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>651 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "player_name  Damian Lillard  Russell Westbrook  Giannis Antetokounmpo  \\\n",
       "Date                                                                    \n",
       "2016-10-25              NaN                NaN                    NaN   \n",
       "2016-10-26             39.0                NaN                    NaN   \n",
       "2016-10-27              NaN               32.0                   31.0   \n",
       "2016-10-28             29.0                NaN                    NaN   \n",
       "2016-10-29              NaN               51.0                    NaN   \n",
       "...                     ...                ...                    ...   \n",
       "2020-08-11             61.0               20.0                    NaN   \n",
       "2020-08-12              NaN                0.0                   12.0   \n",
       "2020-08-13              NaN                NaN                    0.0   \n",
       "2020-08-14             42.0                NaN                    NaN   \n",
       "2020-08-15              NaN                0.0                    NaN   \n",
       "\n",
       "player_name  Anthony Davis  LeBron James  Bradley Beal  DeMar DeRozan  \\\n",
       "Date                                                                    \n",
       "2016-10-25             NaN          19.0           NaN            NaN   \n",
       "2016-10-26             NaN           NaN           NaN           40.0   \n",
       "2016-10-27            50.0           NaN          13.0            NaN   \n",
       "2016-10-28             NaN          21.0           NaN           32.0   \n",
       "2016-10-29            45.0          23.0           NaN            NaN   \n",
       "...                    ...           ...           ...            ...   \n",
       "2020-08-11            27.0          29.0           NaN           23.0   \n",
       "2020-08-12             NaN           NaN           NaN            NaN   \n",
       "2020-08-13             0.0          17.0           NaN            0.0   \n",
       "2020-08-14             NaN           NaN           NaN            NaN   \n",
       "2020-08-15             NaN           NaN           NaN            NaN   \n",
       "\n",
       "player_name  James Harden  Kemba Walker  Karl-Anthony Towns  \n",
       "Date                                                         \n",
       "2016-10-25            NaN           NaN                 NaN  \n",
       "2016-10-26            NaN           NaN                 NaN  \n",
       "2016-10-27           34.0          17.0                21.0  \n",
       "2016-10-28            NaN           NaN                 NaN  \n",
       "2016-10-29           26.0          26.5                 NaN  \n",
       "...                   ...           ...                 ...  \n",
       "2020-08-11            0.0          19.0                 NaN  \n",
       "2020-08-12           45.0           NaN                 NaN  \n",
       "2020-08-13            NaN           0.0                 NaN  \n",
       "2020-08-14            NaN           NaN                 NaN  \n",
       "2020-08-15           27.0           NaN                 NaN  \n",
       "\n",
       "[651 rows x 10 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_data = nba_top50.pivot_table(index='Date',columns='player_name',values='Points')\n",
    "nba_data = nba_data[nba_top10.index.values]\n",
    "nba_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>player_name</th>\n",
       "      <th>Damian Lillard</th>\n",
       "      <th>Russell Westbrook</th>\n",
       "      <th>Giannis Antetokounmpo</th>\n",
       "      <th>Anthony Davis</th>\n",
       "      <th>LeBron James</th>\n",
       "      <th>Bradley Beal</th>\n",
       "      <th>DeMar DeRozan</th>\n",
       "      <th>James Harden</th>\n",
       "      <th>Kemba Walker</th>\n",
       "      <th>Karl-Anthony Towns</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2016-10-25</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-26</th>\n",
       "      <td>39.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-27</th>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-28</th>\n",
       "      <td>29.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-29</th>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.5</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-11</th>\n",
       "      <td>61.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-12</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-13</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-14</th>\n",
       "      <td>42.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-15</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>651 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "player_name  Damian Lillard  Russell Westbrook  Giannis Antetokounmpo  \\\n",
       "Date                                                                    \n",
       "2016-10-25              0.0                0.0                    0.0   \n",
       "2016-10-26             39.0                0.0                    0.0   \n",
       "2016-10-27              0.0               32.0                   31.0   \n",
       "2016-10-28             29.0                0.0                    0.0   \n",
       "2016-10-29              0.0               51.0                    0.0   \n",
       "...                     ...                ...                    ...   \n",
       "2020-08-11             61.0               20.0                    0.0   \n",
       "2020-08-12              0.0                0.0                   12.0   \n",
       "2020-08-13              0.0                0.0                    0.0   \n",
       "2020-08-14             42.0                0.0                    0.0   \n",
       "2020-08-15              0.0                0.0                    0.0   \n",
       "\n",
       "player_name  Anthony Davis  LeBron James  Bradley Beal  DeMar DeRozan  \\\n",
       "Date                                                                    \n",
       "2016-10-25             0.0          19.0           0.0            0.0   \n",
       "2016-10-26             0.0           0.0           0.0           40.0   \n",
       "2016-10-27            50.0           0.0          13.0            0.0   \n",
       "2016-10-28             0.0          21.0           0.0           32.0   \n",
       "2016-10-29            45.0          23.0           0.0            0.0   \n",
       "...                    ...           ...           ...            ...   \n",
       "2020-08-11            27.0          29.0           0.0           23.0   \n",
       "2020-08-12             0.0           0.0           0.0            0.0   \n",
       "2020-08-13             0.0          17.0           0.0            0.0   \n",
       "2020-08-14             0.0           0.0           0.0            0.0   \n",
       "2020-08-15             0.0           0.0           0.0            0.0   \n",
       "\n",
       "player_name  James Harden  Kemba Walker  Karl-Anthony Towns  \n",
       "Date                                                         \n",
       "2016-10-25            0.0           0.0                 0.0  \n",
       "2016-10-26            0.0           0.0                 0.0  \n",
       "2016-10-27           34.0          17.0                21.0  \n",
       "2016-10-28            0.0           0.0                 0.0  \n",
       "2016-10-29           26.0          26.5                 0.0  \n",
       "...                   ...           ...                 ...  \n",
       "2020-08-11            0.0          19.0                 0.0  \n",
       "2020-08-12           45.0           0.0                 0.0  \n",
       "2020-08-13            0.0           0.0                 0.0  \n",
       "2020-08-14            0.0           0.0                 0.0  \n",
       "2020-08-15           27.0           0.0                 0.0  \n",
       "\n",
       "[651 rows x 10 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_data = nba_data.fillna(0)\n",
    "nba_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>player_name</th>\n",
       "      <th>Damian Lillard</th>\n",
       "      <th>Russell Westbrook</th>\n",
       "      <th>Giannis Antetokounmpo</th>\n",
       "      <th>Anthony Davis</th>\n",
       "      <th>LeBron James</th>\n",
       "      <th>Bradley Beal</th>\n",
       "      <th>DeMar DeRozan</th>\n",
       "      <th>James Harden</th>\n",
       "      <th>Kemba Walker</th>\n",
       "      <th>Karl-Anthony Towns</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2016-10-25</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-26</th>\n",
       "      <td>39.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-27</th>\n",
       "      <td>39.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-28</th>\n",
       "      <td>68.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-29</th>\n",
       "      <td>68.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>43.5</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-11</th>\n",
       "      <td>7692.0</td>\n",
       "      <td>7057.0</td>\n",
       "      <td>7478.0</td>\n",
       "      <td>7082.5</td>\n",
       "      <td>7076.0</td>\n",
       "      <td>7163.0</td>\n",
       "      <td>6760.0</td>\n",
       "      <td>6211.0</td>\n",
       "      <td>6640.0</td>\n",
       "      <td>6300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-12</th>\n",
       "      <td>7692.0</td>\n",
       "      <td>7057.0</td>\n",
       "      <td>7490.0</td>\n",
       "      <td>7082.5</td>\n",
       "      <td>7076.0</td>\n",
       "      <td>7163.0</td>\n",
       "      <td>6760.0</td>\n",
       "      <td>6256.0</td>\n",
       "      <td>6640.0</td>\n",
       "      <td>6300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-13</th>\n",
       "      <td>7692.0</td>\n",
       "      <td>7057.0</td>\n",
       "      <td>7490.0</td>\n",
       "      <td>7082.5</td>\n",
       "      <td>7093.0</td>\n",
       "      <td>7163.0</td>\n",
       "      <td>6760.0</td>\n",
       "      <td>6256.0</td>\n",
       "      <td>6640.0</td>\n",
       "      <td>6300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-14</th>\n",
       "      <td>7734.0</td>\n",
       "      <td>7057.0</td>\n",
       "      <td>7490.0</td>\n",
       "      <td>7082.5</td>\n",
       "      <td>7093.0</td>\n",
       "      <td>7163.0</td>\n",
       "      <td>6760.0</td>\n",
       "      <td>6256.0</td>\n",
       "      <td>6640.0</td>\n",
       "      <td>6300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-15</th>\n",
       "      <td>7734.0</td>\n",
       "      <td>7057.0</td>\n",
       "      <td>7490.0</td>\n",
       "      <td>7082.5</td>\n",
       "      <td>7093.0</td>\n",
       "      <td>7163.0</td>\n",
       "      <td>6760.0</td>\n",
       "      <td>6283.0</td>\n",
       "      <td>6640.0</td>\n",
       "      <td>6300.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>651 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "player_name  Damian Lillard  Russell Westbrook  Giannis Antetokounmpo  \\\n",
       "Date                                                                    \n",
       "2016-10-25              0.0                0.0                    0.0   \n",
       "2016-10-26             39.0                0.0                    0.0   \n",
       "2016-10-27             39.0               32.0                   31.0   \n",
       "2016-10-28             68.0               32.0                   31.0   \n",
       "2016-10-29             68.0               83.0                   31.0   \n",
       "...                     ...                ...                    ...   \n",
       "2020-08-11           7692.0             7057.0                 7478.0   \n",
       "2020-08-12           7692.0             7057.0                 7490.0   \n",
       "2020-08-13           7692.0             7057.0                 7490.0   \n",
       "2020-08-14           7734.0             7057.0                 7490.0   \n",
       "2020-08-15           7734.0             7057.0                 7490.0   \n",
       "\n",
       "player_name  Anthony Davis  LeBron James  Bradley Beal  DeMar DeRozan  \\\n",
       "Date                                                                    \n",
       "2016-10-25             0.0          19.0           0.0            0.0   \n",
       "2016-10-26             0.0          19.0           0.0           40.0   \n",
       "2016-10-27            50.0          19.0          13.0           40.0   \n",
       "2016-10-28            50.0          40.0          13.0           72.0   \n",
       "2016-10-29            95.0          63.0          13.0           72.0   \n",
       "...                    ...           ...           ...            ...   \n",
       "2020-08-11          7082.5        7076.0        7163.0         6760.0   \n",
       "2020-08-12          7082.5        7076.0        7163.0         6760.0   \n",
       "2020-08-13          7082.5        7093.0        7163.0         6760.0   \n",
       "2020-08-14          7082.5        7093.0        7163.0         6760.0   \n",
       "2020-08-15          7082.5        7093.0        7163.0         6760.0   \n",
       "\n",
       "player_name  James Harden  Kemba Walker  Karl-Anthony Towns  \n",
       "Date                                                         \n",
       "2016-10-25            0.0           0.0                 0.0  \n",
       "2016-10-26            0.0           0.0                 0.0  \n",
       "2016-10-27           34.0          17.0                21.0  \n",
       "2016-10-28           34.0          17.0                21.0  \n",
       "2016-10-29           60.0          43.5                21.0  \n",
       "...                   ...           ...                 ...  \n",
       "2020-08-11         6211.0        6640.0              6300.0  \n",
       "2020-08-12         6256.0        6640.0              6300.0  \n",
       "2020-08-13         6256.0        6640.0              6300.0  \n",
       "2020-08-14         6256.0        6640.0              6300.0  \n",
       "2020-08-15         6283.0        6640.0              6300.0  \n",
       "\n",
       "[651 rows x 10 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nba_data = nba_data.cumsum()\n",
    "nba_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "bcr.bar_chart_race(df=nba_data, filename='nba_points.mp4')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'anim' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-18-fb7cb63bfb26>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0manim\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msave\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'animation.gif'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mwriter\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'imagemagick'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mfps\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m60\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m: name 'anim' is not defined"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# colors = dict(zip(\n",
    "#         ['Damian Lillard','Russell Westbrook','Giannis Antetokounmpo','Anthony Davis','LeBron James','Bradley Beal','DeMar DeRozan','James Harden','Kemba Walker','Karl-Anthony Towns'],\n",
    "#         ['#adb0ff','#ffb3ff','#90d595','#e48381','#aafbff','#f7bb5f','#eafb50','#6060c0','#ff5668','#cee5ff']\n",
    "# ))\n",
    "\n",
    "# colors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# group_lk = nba_data.set_index(\"player_name\")['Points'].to_dict()\n",
    "# group_lk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# fig, ax = plt.subplots(figsize=(15,8))\n",
    "\n",
    "# def racing_barchart(game_date):\n",
    "#     dff =nba_top50[nba_top50['game_date'].eq(game_date)].sort_values(by='Points',ascending=True).tail(10)\n",
    "#     ax.barh(dff['player_name'],dff['Points'], color=[colors[group_lk[x]] for x in dff['player_name']])\n",
    "# plt.show()\n",
    "\n",
    "# racing_barchart(2016-10-25)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# nba_top50.pivot_table(index='STATE',columns='PLAYERS',values='AST')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}