nba_cleaning_1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 342,
   "id": "8c0382db-6e00-4388-881a-1d6f67ae0e8e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "f93389d0-c232-44f7-9c10-8485cba0f7d1",
   "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>Unnamed: 0</th>\n",
       "      <th>Rank</th>\n",
       "      <th>Player</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>First</th>\n",
       "      <th>Pts Won</th>\n",
       "      <th>Pts Max</th>\n",
       "      <th>Share</th>\n",
       "      <th>G</th>\n",
       "      <th>...</th>\n",
       "      <th>TRB</th>\n",
       "      <th>AST</th>\n",
       "      <th>STL</th>\n",
       "      <th>BLK</th>\n",
       "      <th>FG%</th>\n",
       "      <th>3P%</th>\n",
       "      <th>FT%</th>\n",
       "      <th>WS</th>\n",
       "      <th>WS/48</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Michael Jordan</td>\n",
       "      <td>27</td>\n",
       "      <td>CHI</td>\n",
       "      <td>77.0</td>\n",
       "      <td>891.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.928</td>\n",
       "      <td>82</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.539</td>\n",
       "      <td>0.312</td>\n",
       "      <td>0.851</td>\n",
       "      <td>20.3</td>\n",
       "      <td>0.321</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Magic Johnson</td>\n",
       "      <td>31</td>\n",
       "      <td>LAL</td>\n",
       "      <td>10.0</td>\n",
       "      <td>497.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.518</td>\n",
       "      <td>79</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>12.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.477</td>\n",
       "      <td>0.320</td>\n",
       "      <td>0.906</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.251</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>David Robinson</td>\n",
       "      <td>25</td>\n",
       "      <td>SAS</td>\n",
       "      <td>6.0</td>\n",
       "      <td>476.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.496</td>\n",
       "      <td>82</td>\n",
       "      <td>...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0.552</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.762</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.264</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Charles Barkley</td>\n",
       "      <td>27</td>\n",
       "      <td>PHI</td>\n",
       "      <td>2.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.231</td>\n",
       "      <td>67</td>\n",
       "      <td>...</td>\n",
       "      <td>10.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.570</td>\n",
       "      <td>0.284</td>\n",
       "      <td>0.722</td>\n",
       "      <td>13.4</td>\n",
       "      <td>0.258</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Karl Malone</td>\n",
       "      <td>27</td>\n",
       "      <td>UTA</td>\n",
       "      <td>0.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.148</td>\n",
       "      <td>82</td>\n",
       "      <td>...</td>\n",
       "      <td>11.8</td>\n",
       "      <td>3.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.527</td>\n",
       "      <td>0.286</td>\n",
       "      <td>0.770</td>\n",
       "      <td>15.5</td>\n",
       "      <td>0.225</td>\n",
       "      <td>1991</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>Stephen Curry</td>\n",
       "      <td>33</td>\n",
       "      <td>GSW</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.004</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>5.2</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.437</td>\n",
       "      <td>0.380</td>\n",
       "      <td>0.923</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.173</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>Chris Paul</td>\n",
       "      <td>36</td>\n",
       "      <td>PHO</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.002</td>\n",
       "      <td>65</td>\n",
       "      <td>...</td>\n",
       "      <td>4.4</td>\n",
       "      <td>10.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.493</td>\n",
       "      <td>0.317</td>\n",
       "      <td>0.837</td>\n",
       "      <td>9.4</td>\n",
       "      <td>0.210</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>9</td>\n",
       "      <td>10T</td>\n",
       "      <td>DeMar DeRozan</td>\n",
       "      <td>32</td>\n",
       "      <td>CHI</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.001</td>\n",
       "      <td>76</td>\n",
       "      <td>...</td>\n",
       "      <td>5.2</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.504</td>\n",
       "      <td>0.352</td>\n",
       "      <td>0.877</td>\n",
       "      <td>8.8</td>\n",
       "      <td>0.154</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>10</td>\n",
       "      <td>10T</td>\n",
       "      <td>Kevin Durant</td>\n",
       "      <td>33</td>\n",
       "      <td>BRK</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.001</td>\n",
       "      <td>55</td>\n",
       "      <td>...</td>\n",
       "      <td>7.4</td>\n",
       "      <td>6.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.518</td>\n",
       "      <td>0.383</td>\n",
       "      <td>0.910</td>\n",
       "      <td>8.4</td>\n",
       "      <td>0.198</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>11</td>\n",
       "      <td>10T</td>\n",
       "      <td>LeBron James</td>\n",
       "      <td>37</td>\n",
       "      <td>LAL</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.001</td>\n",
       "      <td>56</td>\n",
       "      <td>...</td>\n",
       "      <td>8.2</td>\n",
       "      <td>6.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.524</td>\n",
       "      <td>0.359</td>\n",
       "      <td>0.756</td>\n",
       "      <td>7.5</td>\n",
       "      <td>0.172</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>486 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0 Rank           Player  Age   Tm  First  Pts Won  Pts Max  \\\n",
       "0             0    1   Michael Jordan   27  CHI   77.0    891.0      960   \n",
       "1             1    2    Magic Johnson   31  LAL   10.0    497.0      960   \n",
       "2             2    3   David Robinson   25  SAS    6.0    476.0      960   \n",
       "3             3    4  Charles Barkley   27  PHI    2.0    222.0      960   \n",
       "4             4    5      Karl Malone   27  UTA    0.0    142.0      960   \n",
       "..          ...  ...              ...  ...  ...    ...      ...      ...   \n",
       "481           7    8    Stephen Curry   33  GSW    0.0      4.0     1000   \n",
       "482           8    9       Chris Paul   36  PHO    0.0      2.0     1000   \n",
       "483           9  10T    DeMar DeRozan   32  CHI    0.0      1.0     1000   \n",
       "484          10  10T     Kevin Durant   33  BRK    0.0      1.0     1000   \n",
       "485          11  10T     LeBron James   37  LAL    0.0      1.0     1000   \n",
       "\n",
       "     Share   G  ...   TRB   AST  STL  BLK    FG%    3P%    FT%    WS  WS/48  \\\n",
       "0    0.928  82  ...   6.0   5.5  2.7  1.0  0.539  0.312  0.851  20.3  0.321   \n",
       "1    0.518  79  ...   7.0  12.5  1.3  0.2  0.477  0.320  0.906  15.4  0.251   \n",
       "2    0.496  82  ...  13.0   2.5  1.5  3.9  0.552  0.143  0.762  17.0  0.264   \n",
       "3    0.231  67  ...  10.1   4.2  1.6  0.5  0.570  0.284  0.722  13.4  0.258   \n",
       "4    0.148  82  ...  11.8   3.3  1.1  1.0  0.527  0.286  0.770  15.5  0.225   \n",
       "..     ...  ..  ...   ...   ...  ...  ...    ...    ...    ...   ...    ...   \n",
       "481  0.004  64  ...   5.2   6.3  1.3  0.4  0.437  0.380  0.923   8.0  0.173   \n",
       "482  0.002  65  ...   4.4  10.8  1.9  0.3  0.493  0.317  0.837   9.4  0.210   \n",
       "483  0.001  76  ...   5.2   4.9  0.9  0.3  0.504  0.352  0.877   8.8  0.154   \n",
       "484  0.001  55  ...   7.4   6.4  0.9  0.9  0.518  0.383  0.910   8.4  0.198   \n",
       "485  0.001  56  ...   8.2   6.2  1.3  1.1  0.524  0.359  0.756   7.5  0.172   \n",
       "\n",
       "     Year  \n",
       "0    1991  \n",
       "1    1991  \n",
       "2    1991  \n",
       "3    1991  \n",
       "4    1991  \n",
       "..    ...  \n",
       "481  2022  \n",
       "482  2022  \n",
       "483  2022  \n",
       "484  2022  \n",
       "485  2022  \n",
       "\n",
       "[486 rows x 22 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mvp = pd.read_csv (\"mvps_table.csv\")\n",
    "mvp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "311cbc44-619e-458f-9584-83b2067b0480",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'Rank', 'Player', 'Age', 'Tm', 'First', 'Pts Won',\n",
       "       'Pts Max', 'Share', 'G', 'MP', 'PTS', 'TRB', 'AST', 'STL', 'BLK', 'FG%',\n",
       "       '3P%', 'FT%', 'WS', 'WS/48', 'Year'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mvp.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "75718719-fdcd-4210-b037-731940b7b868",
   "metadata": {},
   "outputs": [],
   "source": [
    "mvp.drop(mvp[mvp[\"Year\"] == 1991].index, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "22415653-c404-4d84-9f9d-012681f520b3",
   "metadata": {},
   "outputs": [],
   "source": [
    "mvp = mvp[['Player', 'Year','Pts Won', 'Pts Max', 'Share']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "3e858b51-9e7e-4b89-b321-242b56920fae",
   "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</th>\n",
       "      <th>Year</th>\n",
       "      <th>Pts Won</th>\n",
       "      <th>Pts Max</th>\n",
       "      <th>Share</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Michael Jordan</td>\n",
       "      <td>1992</td>\n",
       "      <td>900.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Clyde Drexler</td>\n",
       "      <td>1992</td>\n",
       "      <td>561.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>David Robinson</td>\n",
       "      <td>1992</td>\n",
       "      <td>337.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Karl Malone</td>\n",
       "      <td>1992</td>\n",
       "      <td>262.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Patrick Ewing</td>\n",
       "      <td>1992</td>\n",
       "      <td>100.0</td>\n",
       "      <td>960</td>\n",
       "      <td>0.104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>Stephen Curry</td>\n",
       "      <td>2022</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>Chris Paul</td>\n",
       "      <td>2022</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>DeMar DeRozan</td>\n",
       "      <td>2022</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>Kevin Durant</td>\n",
       "      <td>2022</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>LeBron James</td>\n",
       "      <td>2022</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>466 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Player  Year  Pts Won  Pts Max  Share\n",
       "20   Michael Jordan  1992    900.0      960  0.938\n",
       "21    Clyde Drexler  1992    561.0      960  0.584\n",
       "22   David Robinson  1992    337.0      960  0.351\n",
       "23      Karl Malone  1992    262.0      960  0.273\n",
       "24    Patrick Ewing  1992    100.0      960  0.104\n",
       "..              ...   ...      ...      ...    ...\n",
       "481   Stephen Curry  2022      4.0     1000  0.004\n",
       "482      Chris Paul  2022      2.0     1000  0.002\n",
       "483   DeMar DeRozan  2022      1.0     1000  0.001\n",
       "484    Kevin Durant  2022      1.0     1000  0.001\n",
       "485    LeBron James  2022      1.0     1000  0.001\n",
       "\n",
       "[466 rows x 5 columns]"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mvp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "1da8d976-b7fa-4d58-af95-b802716ab415",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Player      object\n",
       "Year         int64\n",
       "Pts Won    float64\n",
       "Pts Max      int64\n",
       "Share      float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mvp.dtypes"
   ]
  },
  {
   "cell_type": "raw",
   "id": "da2dca20-8149-4621-a010-6ead3bba22b3",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "7c6350f4-dee7-42e0-b16b-c2e531a27303",
   "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>Rk</th>\n",
       "      <th>Player</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>MP</th>\n",
       "      <th>FG</th>\n",
       "      <th>FGA</th>\n",
       "      <th>...</th>\n",
       "      <th>ORB</th>\n",
       "      <th>DRB</th>\n",
       "      <th>TRB</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>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Alaa Abdelnaby</td>\n",
       "      <td>PF</td>\n",
       "      <td>22</td>\n",
       "      <td>POR</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Mahmoud Abdul-Rauf</td>\n",
       "      <td>PG</td>\n",
       "      <td>21</td>\n",
       "      <td>DEN</td>\n",
       "      <td>67</td>\n",
       "      <td>19</td>\n",
       "      <td>22.5</td>\n",
       "      <td>6.2</td>\n",
       "      <td>15.1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.2</td>\n",
       "      <td>14.1</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Mark Acres</td>\n",
       "      <td>C</td>\n",
       "      <td>28</td>\n",
       "      <td>ORL</td>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>19.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.1</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td>5.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Michael Adams</td>\n",
       "      <td>PG</td>\n",
       "      <td>28</td>\n",
       "      <td>DEN</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>35.5</td>\n",
       "      <td>8.5</td>\n",
       "      <td>21.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>10.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Mark Aguirre</td>\n",
       "      <td>SF</td>\n",
       "      <td>31</td>\n",
       "      <td>DET</td>\n",
       "      <td>78</td>\n",
       "      <td>13</td>\n",
       "      <td>25.7</td>\n",
       "      <td>5.4</td>\n",
       "      <td>11.7</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>4.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>14.2</td>\n",
       "      <td>1992</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18435</th>\n",
       "      <td>601</td>\n",
       "      <td>Thaddeus Young</td>\n",
       "      <td>PF</td>\n",
       "      <td>33</td>\n",
       "      <td>TOR</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>18.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.5</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.4</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>6.3</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18436</th>\n",
       "      <td>602</td>\n",
       "      <td>Trae Young</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>ATL</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "      <td>34.9</td>\n",
       "      <td>9.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.7</td>\n",
       "      <td>9.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>28.4</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18437</th>\n",
       "      <td>603</td>\n",
       "      <td>Omer Yurtseven</td>\n",
       "      <td>C</td>\n",
       "      <td>23</td>\n",
       "      <td>MIA</td>\n",
       "      <td>56</td>\n",
       "      <td>12</td>\n",
       "      <td>12.6</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.4</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.7</td>\n",
       "      <td>5.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18438</th>\n",
       "      <td>604</td>\n",
       "      <td>Cody Zeller</td>\n",
       "      <td>C</td>\n",
       "      <td>29</td>\n",
       "      <td>POR</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>13.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>3.3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.1</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18439</th>\n",
       "      <td>605</td>\n",
       "      <td>Ivica Zubac</td>\n",
       "      <td>C</td>\n",
       "      <td>24</td>\n",
       "      <td>LAC</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "      <td>24.4</td>\n",
       "      <td>4.1</td>\n",
       "      <td>6.5</td>\n",
       "      <td>...</td>\n",
       "      <td>2.9</td>\n",
       "      <td>5.6</td>\n",
       "      <td>8.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>10.3</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18440 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Rk              Player Pos Age   Tm   G  GS    MP   FG   FGA  ...  \\\n",
       "0        1      Alaa Abdelnaby  PF  22  POR  43   0   6.7  1.3   2.7  ...   \n",
       "1        2  Mahmoud Abdul-Rauf  PG  21  DEN  67  19  22.5  6.2  15.1  ...   \n",
       "2        3          Mark Acres   C  28  ORL  68   0  19.3  1.6   3.1  ...   \n",
       "3        4       Michael Adams  PG  28  DEN  66  66  35.5  8.5  21.5  ...   \n",
       "4        5        Mark Aguirre  SF  31  DET  78  13  25.7  5.4  11.7  ...   \n",
       "...    ...                 ...  ..  ..  ...  ..  ..   ...  ...   ...  ...   \n",
       "18435  601      Thaddeus Young  PF  33  TOR  26   0  18.3  2.6   5.5  ...   \n",
       "18436  602          Trae Young  PG  23  ATL  76  76  34.9  9.4  20.3  ...   \n",
       "18437  603      Omer Yurtseven   C  23  MIA  56  12  12.6  2.3   4.4  ...   \n",
       "18438  604         Cody Zeller   C  29  POR  27   0  13.1  1.9   3.3  ...   \n",
       "18439  605         Ivica Zubac   C  24  LAC  76  76  24.4  4.1   6.5  ...   \n",
       "\n",
       "       ORB  DRB  TRB   AST  STL  BLK  TOV   PF   PTS  Year  \n",
       "0      0.6  1.4  2.1   0.3  0.1  0.3  0.5  0.9   3.1  1992  \n",
       "1      0.5  1.3  1.8   3.1  0.8  0.1  1.6  2.2  14.1  1992  \n",
       "2      2.1  3.2  5.3   0.4  0.4  0.4  0.6  3.2   4.2  1992  \n",
       "3      0.9  3.0  3.9  10.5  2.2  0.1  3.6  2.5  26.5  1992  \n",
       "4      1.7  3.1  4.8   1.8  0.6  0.3  1.6  2.7  14.2  1992  \n",
       "...    ...  ...  ...   ...  ...  ...  ...  ...   ...   ...  \n",
       "18435  1.5  2.9  4.4   1.7  1.2  0.4  0.8  1.7   6.3  2022  \n",
       "18436  0.7  3.1  3.7   9.7  0.9  0.1  4.0  1.7  28.4  2022  \n",
       "18437  1.5  3.7  5.3   0.9  0.3  0.4  0.7  1.5   5.3  2022  \n",
       "18438  1.9  2.8  4.6   0.8  0.3  0.2  0.7  2.1   5.2  2022  \n",
       "18439  2.9  5.6  8.5   1.6  0.5  1.0  1.5  2.7  10.3  2022  \n",
       "\n",
       "[18440 rows x 31 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players = pd.read_csv(\"players.csv\")\n",
    "players"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "6a2ebba1-14d7-4a2d-b5b3-1ea3a20eb832",
   "metadata": {},
   "outputs": [],
   "source": [
    "c = players.columns\n",
    "d = mvp.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "edc94b4f-ec30-44ff-9a8a-4f7385b5456c",
   "metadata": {},
   "outputs": [],
   "source": [
    "#cross-checking for similar columns\n",
    "def check_the_columns(players, mvps):\n",
    "    PC = players.columns\n",
    "    MC = mvps.columns\n",
    "    for c in PC:\n",
    "        if c in [d for d in MC]: \n",
    "            print (c)\n",
    "        else:\n",
    "            pass\n",
    "\n",
    "\n",
    "\n",
    "def find_common_columns(df1, df2):\n",
    "    common_columns = set(df1.columns) & set(df2.columns)\n",
    "    return common_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f4cb6f52-fb88-41af-abef-5eb5d5b1c375",
   "metadata": {},
   "outputs": [],
   "source": [
    "check_the_columns(players, mvp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "071bdbb0-e69d-4e43-8b89-ebb71085a63d",
   "metadata": {},
   "outputs": [],
   "source": [
    "del players[\"Rk\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 317,
   "id": "286036d7-58e7-4704-a865-6422f87eea37",
   "metadata": {},
   "outputs": [],
   "source": [
    "players['Player'] = players['Player'].str.replace('*', '', regex=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 318,
   "id": "348acd5b-5c9d-412f-bf82-0683859bcf2a",
   "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>Player</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>MP</th>\n",
       "      <th>FG</th>\n",
       "      <th>FGA</th>\n",
       "      <th>FG%</th>\n",
       "      <th>...</th>\n",
       "      <th>ORB</th>\n",
       "      <th>DRB</th>\n",
       "      <th>TRB</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>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>21</td>\n",
       "      <td>26.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.6</td>\n",
       "      <td>.476</td>\n",
       "      <td>...</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3.8</td>\n",
       "      <td>6.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>9.1</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>29</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>55</td>\n",
       "      <td>34.4</td>\n",
       "      <td>4.6</td>\n",
       "      <td>8.6</td>\n",
       "      <td>.537</td>\n",
       "      <td>...</td>\n",
       "      <td>3.5</td>\n",
       "      <td>5.2</td>\n",
       "      <td>8.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1106</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>30</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>55</td>\n",
       "      <td>34.5</td>\n",
       "      <td>5.7</td>\n",
       "      <td>11.3</td>\n",
       "      <td>.502</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>5.8</td>\n",
       "      <td>9.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>14.7</td>\n",
       "      <td>1994.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1595</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>SF</td>\n",
       "      <td>31</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>52</td>\n",
       "      <td>32.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>7.5</td>\n",
       "      <td>.504</td>\n",
       "      <td>...</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.8</td>\n",
       "      <td>8.2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>11.2</td>\n",
       "      <td>1995.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2092</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>SF</td>\n",
       "      <td>32</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>36</td>\n",
       "      <td>25.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.4</td>\n",
       "      <td>.484</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>6.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>7.5</td>\n",
       "      <td>1996.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2668</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83</td>\n",
       "      <td>73</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>5.8</td>\n",
       "      <td>.483</td>\n",
       "      <td>...</td>\n",
       "      <td>2.7</td>\n",
       "      <td>5.2</td>\n",
       "      <td>7.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.7</td>\n",
       "      <td>7.2</td>\n",
       "      <td>1997.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3256</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>34</td>\n",
       "      <td>DAL</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>32.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>.453</td>\n",
       "      <td>...</td>\n",
       "      <td>2.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>8.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>7.3</td>\n",
       "      <td>1998.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3815</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>35</td>\n",
       "      <td>DAL</td>\n",
       "      <td>50</td>\n",
       "      <td>35</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>.422</td>\n",
       "      <td>...</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>4.9</td>\n",
       "      <td>1999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4344</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>36</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>4.7</td>\n",
       "      <td>.447</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4864</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>37</td>\n",
       "      <td>MIA</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>17.2</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.0</td>\n",
       "      <td>.444</td>\n",
       "      <td>...</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4217</th>\n",
       "      <td>A.J. Bramlett</td>\n",
       "      <td>C</td>\n",
       "      <td>23</td>\n",
       "      <td>CLE</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>7.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>.190</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>A.J. English</td>\n",
       "      <td>SG</td>\n",
       "      <td>23</td>\n",
       "      <td>WSB</td>\n",
       "      <td>70</td>\n",
       "      <td>12</td>\n",
       "      <td>20.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>8.2</td>\n",
       "      <td>.439</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.8</td>\n",
       "      <td>8.8</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4867</th>\n",
       "      <td>A.J. Guyton</td>\n",
       "      <td>PG</td>\n",
       "      <td>22</td>\n",
       "      <td>CHI</td>\n",
       "      <td>33</td>\n",
       "      <td>8</td>\n",
       "      <td>19.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.8</td>\n",
       "      <td>.406</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5421</th>\n",
       "      <td>A.J. Guyton</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>CHI</td>\n",
       "      <td>45</td>\n",
       "      <td>6</td>\n",
       "      <td>13.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.4</td>\n",
       "      <td>.361</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>2002.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5929</th>\n",
       "      <td>A.J. Guyton</td>\n",
       "      <td>PG</td>\n",
       "      <td>24</td>\n",
       "      <td>GSW</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2003.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14364</th>\n",
       "      <td>A.J. Hammons</td>\n",
       "      <td>C</td>\n",
       "      <td>24</td>\n",
       "      <td>DAL</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>7.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>.405</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10270</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>IND</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>15.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>6.3</td>\n",
       "      <td>.410</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>7.3</td>\n",
       "      <td>2010.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10900</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>24</td>\n",
       "      <td>IND</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>6.4</td>\n",
       "      <td>.356</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>6.5</td>\n",
       "      <td>2011.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11485</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>25</td>\n",
       "      <td>IND</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>12.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>.339</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>2012.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12078</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>26</td>\n",
       "      <td>WAS</td>\n",
       "      <td>57</td>\n",
       "      <td>22</td>\n",
       "      <td>22.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>7.2</td>\n",
       "      <td>.390</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.3</td>\n",
       "      <td>7.7</td>\n",
       "      <td>2013.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Player Pos Age   Tm   G  GS    MP   FG   FGA   FG%  ...  ORB  \\\n",
       "165       A.C. Green  PF  27  LAL  82  21  26.4  3.1   6.6  .476  ...  2.5   \n",
       "618       A.C. Green  PF  29  LAL  82  55  34.4  4.6   8.6  .537  ...  3.5   \n",
       "1106      A.C. Green  PF  30  PHO  82  55  34.5  5.7  11.3  .502  ...  3.4   \n",
       "1595      A.C. Green  SF  31  PHO  82  52  32.8  3.8   7.5  .504  ...  2.4   \n",
       "2092      A.C. Green  SF  32  PHO  82  36  25.8  2.6   5.4  .484  ...  2.0   \n",
       "2668      A.C. Green  PF  33  NaN  83  73  30.0  2.8   5.8  .483  ...  2.7   \n",
       "3256      A.C. Green  PF  34  DAL  82  68  32.3  3.0   6.5  .453  ...  2.7   \n",
       "3815      A.C. Green  PF  35  DAL  50  35  18.5  2.2   5.1  .422  ...  1.6   \n",
       "4344      A.C. Green  PF  36  LAL  82  82  23.5  2.1   4.7  .447  ...  2.0   \n",
       "4864      A.C. Green  PF  37  MIA  82   1  17.2  1.8   4.0  .444  ...  1.3   \n",
       "4217   A.J. Bramlett   C  23  CLE   8   0   7.6  0.5   2.6  .190  ...  1.5   \n",
       "128     A.J. English  SG  23  WSB  70  12  20.6  3.6   8.2  .439  ...  0.9   \n",
       "4867     A.J. Guyton  PG  22  CHI  33   8  19.1  2.4   5.8  .406  ...  0.3   \n",
       "5421     A.J. Guyton  PG  23  CHI  45   6  13.5  2.0   5.4  .361  ...  0.3   \n",
       "5929     A.J. Guyton  PG  24  GSW   2   0   4.5  0.0   2.0  .000  ...  0.0   \n",
       "14364   A.J. Hammons   C  24  DAL  22   0   7.4  0.8   1.9  .405  ...  0.4   \n",
       "10270     A.J. Price  PG  23  IND  56   2  15.4  2.6   6.3  .410  ...  0.2   \n",
       "10900     A.J. Price  PG  24  IND  50   0  15.9  2.3   6.4  .356  ...  0.3   \n",
       "11485     A.J. Price  PG  25  IND  44   1  12.9  1.3   4.0  .339  ...  0.3   \n",
       "12078     A.J. Price  PG  26  WAS  57  22  22.4  2.8   7.2  .390  ...  0.4   \n",
       "\n",
       "       DRB  TRB  AST  STL  BLK  TOV   PF   PTS    Year  \n",
       "165    3.8  6.3  0.9  0.7  0.3  1.2  1.4   9.1  1992.0  \n",
       "618    5.2  8.7  1.4  1.1  0.5  1.4  1.8  12.8  1993.0  \n",
       "1106   5.8  9.2  1.7  0.9  0.5  1.2  1.7  14.7  1994.0  \n",
       "1595   5.8  8.2  1.5  0.7  0.4  1.4  1.8  11.2  1995.0  \n",
       "2092   4.7  6.8  0.9  0.5  0.3  1.0  1.7   7.5  1996.0  \n",
       "2668   5.2  7.9  0.8  0.8  0.2  0.9  1.7   7.2  1997.0  \n",
       "3256   5.5  8.1  1.5  1.0  0.3  0.8  1.9   7.3  1998.0  \n",
       "3815   2.9  4.6  0.5  0.6  0.2  0.4  1.4   4.9  1999.0  \n",
       "4344   4.0  5.9  1.0  0.6  0.2  0.6  1.5   5.0  2000.0  \n",
       "4864   2.5  3.8  0.5  0.4  0.1  0.5  1.5   4.5  2001.0  \n",
       "4217   1.3  2.8  0.0  0.1  0.0  0.4  1.6   1.0  2000.0  \n",
       "128    1.2  2.1  2.5  0.4  0.2  1.6  1.8   8.8  1992.0  \n",
       "4867   0.8  1.1  1.9  0.3  0.2  0.7  1.1   6.0  2001.0  \n",
       "5421   0.7  1.0  1.8  0.2  0.2  0.8  0.5   5.4  2002.0  \n",
       "5929   0.0  0.0  1.0  0.5  0.0  0.5  0.0   0.0  2003.0  \n",
       "14364  1.3  1.6  0.2  0.0  0.6  0.5  1.0   2.2  2017.0  \n",
       "10270  1.4  1.6  1.9  0.6  0.1  1.1  0.9   7.3  2010.0  \n",
       "10900  1.1  1.4  2.2  0.6  0.0  1.1  1.2   6.5  2011.0  \n",
       "11485  1.1  1.4  2.0  0.5  0.0  0.7  0.7   3.9  2012.0  \n",
       "12078  1.6  2.0  3.6  0.6  0.1  1.1  1.3   7.7  2013.0  \n",
       "\n",
       "[20 rows x 30 columns]"
      ]
     },
     "execution_count": 318,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 407,
   "id": "0e6d11f8-eeed-4da1-8879-9e0d4d0ab012",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.generic.DataFrameGroupBy object at 0x00000211D4075CD0>"
      ]
     },
     "execution_count": 407,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players.groupby(['Player', 'Year'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 320,
   "id": "81da80ca-8318-4e48-aebd-20191188268d",
   "metadata": {},
   "outputs": [],
   "source": [
    "def single_row(df):\n",
    "    if df.shape[0] == 1:\n",
    "        return df\n",
    "    else:\n",
    "        row = df[df['Tm'] == 'TOT']\n",
    "        row[\"Tm\"] = df.iloc[-1:][\"Tm\"]\n",
    "        return row\n",
    "\n",
    "\n",
    "players = players.groupby(['Player', 'Year']).apply(single_row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 323,
   "id": "b7e47641-891d-4942-b76c-009840280737",
   "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></th>\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>MP</th>\n",
       "      <th>FG</th>\n",
       "      <th>FGA</th>\n",
       "      <th>FG%</th>\n",
       "      <th>...</th>\n",
       "      <th>ORB</th>\n",
       "      <th>DRB</th>\n",
       "      <th>TRB</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>Year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Player</th>\n",
       "      <th>Year</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",
       "      <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",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"10\" valign=\"top\">A.C. Green</th>\n",
       "      <th>1992.0</th>\n",
       "      <th>165</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>21</td>\n",
       "      <td>26.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.6</td>\n",
       "      <td>.476</td>\n",
       "      <td>...</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3.8</td>\n",
       "      <td>6.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>9.1</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1993.0</th>\n",
       "      <th>618</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>29</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>55</td>\n",
       "      <td>34.4</td>\n",
       "      <td>4.6</td>\n",
       "      <td>8.6</td>\n",
       "      <td>.537</td>\n",
       "      <td>...</td>\n",
       "      <td>3.5</td>\n",
       "      <td>5.2</td>\n",
       "      <td>8.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1994.0</th>\n",
       "      <th>1106</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>30</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>55</td>\n",
       "      <td>34.5</td>\n",
       "      <td>5.7</td>\n",
       "      <td>11.3</td>\n",
       "      <td>.502</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>5.8</td>\n",
       "      <td>9.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>14.7</td>\n",
       "      <td>1994.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995.0</th>\n",
       "      <th>1595</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>SF</td>\n",
       "      <td>31</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>52</td>\n",
       "      <td>32.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>7.5</td>\n",
       "      <td>.504</td>\n",
       "      <td>...</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.8</td>\n",
       "      <td>8.2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>11.2</td>\n",
       "      <td>1995.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996.0</th>\n",
       "      <th>2092</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>SF</td>\n",
       "      <td>32</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>36</td>\n",
       "      <td>25.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.4</td>\n",
       "      <td>.484</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>6.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>7.5</td>\n",
       "      <td>1996.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997.0</th>\n",
       "      <th>2668</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83</td>\n",
       "      <td>73</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>5.8</td>\n",
       "      <td>.483</td>\n",
       "      <td>...</td>\n",
       "      <td>2.7</td>\n",
       "      <td>5.2</td>\n",
       "      <td>7.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.7</td>\n",
       "      <td>7.2</td>\n",
       "      <td>1997.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998.0</th>\n",
       "      <th>3256</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>34</td>\n",
       "      <td>DAL</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>32.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>.453</td>\n",
       "      <td>...</td>\n",
       "      <td>2.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>8.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>7.3</td>\n",
       "      <td>1998.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999.0</th>\n",
       "      <th>3815</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>35</td>\n",
       "      <td>DAL</td>\n",
       "      <td>50</td>\n",
       "      <td>35</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>5.1</td>\n",
       "      <td>.422</td>\n",
       "      <td>...</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>4.9</td>\n",
       "      <td>1999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000.0</th>\n",
       "      <th>4344</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>36</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>4.7</td>\n",
       "      <td>.447</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001.0</th>\n",
       "      <th>4864</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>37</td>\n",
       "      <td>MIA</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>17.2</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.0</td>\n",
       "      <td>.444</td>\n",
       "      <td>...</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A.J. Bramlett</th>\n",
       "      <th>2000.0</th>\n",
       "      <th>4217</th>\n",
       "      <td>A.J. Bramlett</td>\n",
       "      <td>C</td>\n",
       "      <td>23</td>\n",
       "      <td>CLE</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>7.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>.190</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A.J. English</th>\n",
       "      <th>1992.0</th>\n",
       "      <th>128</th>\n",
       "      <td>A.J. English</td>\n",
       "      <td>SG</td>\n",
       "      <td>23</td>\n",
       "      <td>WSB</td>\n",
       "      <td>70</td>\n",
       "      <td>12</td>\n",
       "      <td>20.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>8.2</td>\n",
       "      <td>.439</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.8</td>\n",
       "      <td>8.8</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">A.J. Guyton</th>\n",
       "      <th>2001.0</th>\n",
       "      <th>4867</th>\n",
       "      <td>A.J. Guyton</td>\n",
       "      <td>PG</td>\n",
       "      <td>22</td>\n",
       "      <td>CHI</td>\n",
       "      <td>33</td>\n",
       "      <td>8</td>\n",
       "      <td>19.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.8</td>\n",
       "      <td>.406</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002.0</th>\n",
       "      <th>5421</th>\n",
       "      <td>A.J. Guyton</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>CHI</td>\n",
       "      <td>45</td>\n",
       "      <td>6</td>\n",
       "      <td>13.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.4</td>\n",
       "      <td>.361</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>2002.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003.0</th>\n",
       "      <th>5929</th>\n",
       "      <td>A.J. Guyton</td>\n",
       "      <td>PG</td>\n",
       "      <td>24</td>\n",
       "      <td>GSW</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2003.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A.J. Hammons</th>\n",
       "      <th>2017.0</th>\n",
       "      <th>14364</th>\n",
       "      <td>A.J. Hammons</td>\n",
       "      <td>C</td>\n",
       "      <td>24</td>\n",
       "      <td>DAL</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>7.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>.405</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">A.J. Price</th>\n",
       "      <th>2010.0</th>\n",
       "      <th>10270</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>IND</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>15.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>6.3</td>\n",
       "      <td>.410</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>7.3</td>\n",
       "      <td>2010.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <th>10900</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>24</td>\n",
       "      <td>IND</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>6.4</td>\n",
       "      <td>.356</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>6.5</td>\n",
       "      <td>2011.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <th>11485</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>25</td>\n",
       "      <td>IND</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>12.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>.339</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>2012.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <th>12078</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>26</td>\n",
       "      <td>WAS</td>\n",
       "      <td>57</td>\n",
       "      <td>22</td>\n",
       "      <td>22.4</td>\n",
       "      <td>2.8</td>\n",
       "      <td>7.2</td>\n",
       "      <td>.390</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.3</td>\n",
       "      <td>7.7</td>\n",
       "      <td>2013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <th>12709</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>SG</td>\n",
       "      <td>27</td>\n",
       "      <td>MIN</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>.413</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <th>13358</th>\n",
       "      <td>A.J. Price</td>\n",
       "      <td>PG</td>\n",
       "      <td>28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>12.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.3</td>\n",
       "      <td>.372</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A.J. Wynder</th>\n",
       "      <th>1992.0</th>\n",
       "      <th>458</th>\n",
       "      <td>A.J. Wynder</td>\n",
       "      <td>PG</td>\n",
       "      <td>26</td>\n",
       "      <td>BOS</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>.250</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"10\" valign=\"top\">Aaron Brooks</th>\n",
       "      <th>2008.0</th>\n",
       "      <th>8672</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>HOU</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "      <td>11.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.4</td>\n",
       "      <td>.413</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.4</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009.0</th>\n",
       "      <th>9294</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>24</td>\n",
       "      <td>HOU</td>\n",
       "      <td>80</td>\n",
       "      <td>35</td>\n",
       "      <td>25.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.8</td>\n",
       "      <td>.404</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.9</td>\n",
       "      <td>11.2</td>\n",
       "      <td>2009.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010.0</th>\n",
       "      <th>9896</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>25</td>\n",
       "      <td>HOU</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>35.6</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16.2</td>\n",
       "      <td>.432</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.4</td>\n",
       "      <td>19.6</td>\n",
       "      <td>2010.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <th>10513</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>59</td>\n",
       "      <td>12</td>\n",
       "      <td>21.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>9.9</td>\n",
       "      <td>.375</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>10.7</td>\n",
       "      <td>2011.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <th>11714</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53</td>\n",
       "      <td>20</td>\n",
       "      <td>18.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>6.0</td>\n",
       "      <td>.453</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>7.1</td>\n",
       "      <td>2013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <th>12323</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72</td>\n",
       "      <td>12</td>\n",
       "      <td>21.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>8.1</td>\n",
       "      <td>.401</td>\n",
       "      <td>...</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <th>12948</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>30</td>\n",
       "      <td>CHI</td>\n",
       "      <td>82</td>\n",
       "      <td>21</td>\n",
       "      <td>23.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>.421</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>11.6</td>\n",
       "      <td>2015.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <th>13614</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>31</td>\n",
       "      <td>CHI</td>\n",
       "      <td>69</td>\n",
       "      <td>0</td>\n",
       "      <td>16.1</td>\n",
       "      <td>2.7</td>\n",
       "      <td>6.8</td>\n",
       "      <td>.401</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>7.1</td>\n",
       "      <td>2016.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017.0</th>\n",
       "      <th>14218</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>32</td>\n",
       "      <td>IND</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>13.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>.403</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018.0</th>\n",
       "      <th>14848</th>\n",
       "      <td>Aaron Brooks</td>\n",
       "      <td>PG</td>\n",
       "      <td>33</td>\n",
       "      <td>MIN</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>5.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2.2</td>\n",
       "      <td>.406</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">Aaron Gordon</th>\n",
       "      <th>2015.0</th>\n",
       "      <th>13102</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>PF</td>\n",
       "      <td>19</td>\n",
       "      <td>ORL</td>\n",
       "      <td>47</td>\n",
       "      <td>8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>.447</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2015.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <th>13735</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>PF</td>\n",
       "      <td>20</td>\n",
       "      <td>ORL</td>\n",
       "      <td>78</td>\n",
       "      <td>37</td>\n",
       "      <td>23.9</td>\n",
       "      <td>3.5</td>\n",
       "      <td>7.4</td>\n",
       "      <td>.473</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.2</td>\n",
       "      <td>2016.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017.0</th>\n",
       "      <th>14348</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>SF</td>\n",
       "      <td>21</td>\n",
       "      <td>ORL</td>\n",
       "      <td>80</td>\n",
       "      <td>72</td>\n",
       "      <td>28.7</td>\n",
       "      <td>4.9</td>\n",
       "      <td>10.8</td>\n",
       "      <td>.454</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.6</td>\n",
       "      <td>5.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>12.7</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018.0</th>\n",
       "      <th>14990</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>PF</td>\n",
       "      <td>22</td>\n",
       "      <td>ORL</td>\n",
       "      <td>58</td>\n",
       "      <td>57</td>\n",
       "      <td>32.9</td>\n",
       "      <td>6.5</td>\n",
       "      <td>14.9</td>\n",
       "      <td>.434</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>6.4</td>\n",
       "      <td>7.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>17.6</td>\n",
       "      <td>2018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019.0</th>\n",
       "      <th>15714</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>PF</td>\n",
       "      <td>23</td>\n",
       "      <td>ORL</td>\n",
       "      <td>78</td>\n",
       "      <td>78</td>\n",
       "      <td>33.8</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.4</td>\n",
       "      <td>.449</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>7.4</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020.0</th>\n",
       "      <th>16430</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>PF</td>\n",
       "      <td>24</td>\n",
       "      <td>ORL</td>\n",
       "      <td>62</td>\n",
       "      <td>62</td>\n",
       "      <td>32.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12.4</td>\n",
       "      <td>.437</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>5.9</td>\n",
       "      <td>7.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.4</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021.0</th>\n",
       "      <th>17107</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>PF</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>27.7</td>\n",
       "      <td>4.6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>.463</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>5.7</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1.8</td>\n",
       "      <td>12.4</td>\n",
       "      <td>2021.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022.0</th>\n",
       "      <th>17867</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>PF</td>\n",
       "      <td>26</td>\n",
       "      <td>DEN</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>31.7</td>\n",
       "      <td>5.8</td>\n",
       "      <td>11.1</td>\n",
       "      <td>.520</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.2</td>\n",
       "      <td>5.9</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">Aaron Gray</th>\n",
       "      <th>2008.0</th>\n",
       "      <th>8812</th>\n",
       "      <td>Aaron Gray</td>\n",
       "      <td>C</td>\n",
       "      <td>23</td>\n",
       "      <td>CHI</td>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>3.3</td>\n",
       "      <td>.505</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009.0</th>\n",
       "      <th>9434</th>\n",
       "      <td>Aaron Gray</td>\n",
       "      <td>C</td>\n",
       "      <td>24</td>\n",
       "      <td>CHI</td>\n",
       "      <td>56</td>\n",
       "      <td>18</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1.4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>.485</td>\n",
       "      <td>...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2009.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010.0</th>\n",
       "      <th>10025</th>\n",
       "      <td>Aaron Gray</td>\n",
       "      <td>C</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>9.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>.512</td>\n",
       "      <td>...</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>3.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>3.3</td>\n",
       "      <td>2010.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <th>10677</th>\n",
       "      <td>Aaron Gray</td>\n",
       "      <td>C</td>\n",
       "      <td>26</td>\n",
       "      <td>NOH</td>\n",
       "      <td>41</td>\n",
       "      <td>6</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>.566</td>\n",
       "      <td>...</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>2011.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <th>11275</th>\n",
       "      <td>Aaron Gray</td>\n",
       "      <td>C</td>\n",
       "      <td>27</td>\n",
       "      <td>TOR</td>\n",
       "      <td>49</td>\n",
       "      <td>40</td>\n",
       "      <td>16.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>3.3</td>\n",
       "      <td>.516</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.9</td>\n",
       "      <td>2012.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <th>11841</th>\n",
       "      <td>Aaron Gray</td>\n",
       "      <td>C</td>\n",
       "      <td>28</td>\n",
       "      <td>TOR</td>\n",
       "      <td>42</td>\n",
       "      <td>16</td>\n",
       "      <td>12.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>.533</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <th>12478</th>\n",
       "      <td>Aaron Gray</td>\n",
       "      <td>C</td>\n",
       "      <td>29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37</td>\n",
       "      <td>6</td>\n",
       "      <td>9.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>.443</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Aaron Harrison</th>\n",
       "      <th>2016.0</th>\n",
       "      <th>13771</th>\n",
       "      <td>Aaron Harrison</td>\n",
       "      <td>SG</td>\n",
       "      <td>21</td>\n",
       "      <td>CHO</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>.263</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2016.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017.0</th>\n",
       "      <th>14376</th>\n",
       "      <td>Aaron Harrison</td>\n",
       "      <td>SG</td>\n",
       "      <td>22</td>\n",
       "      <td>CHO</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2017.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Player Pos Age   Tm   G  GS    MP   FG  \\\n",
       "Player         Year                                                           \n",
       "A.C. Green     1992.0 165        A.C. Green  PF  27  LAL  82  21  26.4  3.1   \n",
       "               1993.0 618        A.C. Green  PF  29  LAL  82  55  34.4  4.6   \n",
       "               1994.0 1106       A.C. Green  PF  30  PHO  82  55  34.5  5.7   \n",
       "               1995.0 1595       A.C. Green  SF  31  PHO  82  52  32.8  3.8   \n",
       "               1996.0 2092       A.C. Green  SF  32  PHO  82  36  25.8  2.6   \n",
       "               1997.0 2668       A.C. Green  PF  33  NaN  83  73  30.0  2.8   \n",
       "               1998.0 3256       A.C. Green  PF  34  DAL  82  68  32.3  3.0   \n",
       "               1999.0 3815       A.C. Green  PF  35  DAL  50  35  18.5  2.2   \n",
       "               2000.0 4344       A.C. Green  PF  36  LAL  82  82  23.5  2.1   \n",
       "               2001.0 4864       A.C. Green  PF  37  MIA  82   1  17.2  1.8   \n",
       "A.J. Bramlett  2000.0 4217    A.J. Bramlett   C  23  CLE   8   0   7.6  0.5   \n",
       "A.J. English   1992.0 128      A.J. English  SG  23  WSB  70  12  20.6  3.6   \n",
       "A.J. Guyton    2001.0 4867      A.J. Guyton  PG  22  CHI  33   8  19.1  2.4   \n",
       "               2002.0 5421      A.J. Guyton  PG  23  CHI  45   6  13.5  2.0   \n",
       "               2003.0 5929      A.J. Guyton  PG  24  GSW   2   0   4.5  0.0   \n",
       "A.J. Hammons   2017.0 14364    A.J. Hammons   C  24  DAL  22   0   7.4  0.8   \n",
       "A.J. Price     2010.0 10270      A.J. Price  PG  23  IND  56   2  15.4  2.6   \n",
       "               2011.0 10900      A.J. Price  PG  24  IND  50   0  15.9  2.3   \n",
       "               2012.0 11485      A.J. Price  PG  25  IND  44   1  12.9  1.3   \n",
       "               2013.0 12078      A.J. Price  PG  26  WAS  57  22  22.4  2.8   \n",
       "               2014.0 12709      A.J. Price  SG  27  MIN  28   0   3.5  0.7   \n",
       "               2015.0 13358      A.J. Price  PG  28  NaN  26   0  12.5  2.0   \n",
       "A.J. Wynder    1992.0 458       A.J. Wynder  PG  26  BOS   6   0   6.5  0.5   \n",
       "Aaron Brooks   2008.0 8672     Aaron Brooks  PG  23  HOU  51   0  11.9  1.8   \n",
       "               2009.0 9294     Aaron Brooks  PG  24  HOU  80  35  25.0  4.0   \n",
       "               2010.0 9896     Aaron Brooks  PG  25  HOU  82  82  35.6  7.0   \n",
       "               2011.0 10513    Aaron Brooks  PG  26  NaN  59  12  21.8  3.7   \n",
       "               2013.0 11714    Aaron Brooks  PG  28  NaN  53  20  18.8  2.7   \n",
       "               2014.0 12323    Aaron Brooks  PG  29  NaN  72  12  21.6  3.2   \n",
       "               2015.0 12948    Aaron Brooks  PG  30  CHI  82  21  23.0  4.2   \n",
       "               2016.0 13614    Aaron Brooks  PG  31  CHI  69   0  16.1  2.7   \n",
       "               2017.0 14218    Aaron Brooks  PG  32  IND  65   0  13.8  1.9   \n",
       "               2018.0 14848    Aaron Brooks  PG  33  MIN  32   1   5.9  0.9   \n",
       "Aaron Gordon   2015.0 13102    Aaron Gordon  PF  19  ORL  47   8  17.0  2.0   \n",
       "               2016.0 13735    Aaron Gordon  PF  20  ORL  78  37  23.9  3.5   \n",
       "               2017.0 14348    Aaron Gordon  SF  21  ORL  80  72  28.7  4.9   \n",
       "               2018.0 14990    Aaron Gordon  PF  22  ORL  58  57  32.9  6.5   \n",
       "               2019.0 15714    Aaron Gordon  PF  23  ORL  78  78  33.8  6.0   \n",
       "               2020.0 16430    Aaron Gordon  PF  24  ORL  62  62  32.5  5.4   \n",
       "               2021.0 17107    Aaron Gordon  PF  25  NaN  50  50  27.7  4.6   \n",
       "               2022.0 17867    Aaron Gordon  PF  26  DEN  75  75  31.7  5.8   \n",
       "Aaron Gray     2008.0 8812       Aaron Gray   C  23  CHI  61   1  10.0  1.7   \n",
       "               2009.0 9434       Aaron Gray   C  24  CHI  56  18  12.8  1.4   \n",
       "               2010.0 10025      Aaron Gray   C  25  NaN  32   0   9.7  1.3   \n",
       "               2011.0 10677      Aaron Gray   C  26  NOH  41   6  13.0  1.4   \n",
       "               2012.0 11275      Aaron Gray   C  27  TOR  49  40  16.6  1.7   \n",
       "               2013.0 11841      Aaron Gray   C  28  TOR  42  16  12.2  1.1   \n",
       "               2014.0 12478      Aaron Gray   C  29  NaN  37   6   9.6  0.7   \n",
       "Aaron Harrison 2016.0 13771  Aaron Harrison  SG  21  CHO  21   0   4.4  0.2   \n",
       "               2017.0 14376  Aaron Harrison  SG  22  CHO   5   0   3.4  0.0   \n",
       "\n",
       "                              FGA   FG%  ...  ORB  DRB  TRB  AST  STL  BLK  \\\n",
       "Player         Year                      ...                                 \n",
       "A.C. Green     1992.0 165     6.6  .476  ...  2.5  3.8  6.3  0.9  0.7  0.3   \n",
       "               1993.0 618     8.6  .537  ...  3.5  5.2  8.7  1.4  1.1  0.5   \n",
       "               1994.0 1106   11.3  .502  ...  3.4  5.8  9.2  1.7  0.9  0.5   \n",
       "               1995.0 1595    7.5  .504  ...  2.4  5.8  8.2  1.5  0.7  0.4   \n",
       "               1996.0 2092    5.4  .484  ...  2.0  4.7  6.8  0.9  0.5  0.3   \n",
       "               1997.0 2668    5.8  .483  ...  2.7  5.2  7.9  0.8  0.8  0.2   \n",
       "               1998.0 3256    6.5  .453  ...  2.7  5.5  8.1  1.5  1.0  0.3   \n",
       "               1999.0 3815    5.1  .422  ...  1.6  2.9  4.6  0.5  0.6  0.2   \n",
       "               2000.0 4344    4.7  .447  ...  2.0  4.0  5.9  1.0  0.6  0.2   \n",
       "               2001.0 4864    4.0  .444  ...  1.3  2.5  3.8  0.5  0.4  0.1   \n",
       "A.J. Bramlett  2000.0 4217    2.6  .190  ...  1.5  1.3  2.8  0.0  0.1  0.0   \n",
       "A.J. English   1992.0 128     8.2  .439  ...  0.9  1.2  2.1  2.5  0.4  0.2   \n",
       "A.J. Guyton    2001.0 4867    5.8  .406  ...  0.3  0.8  1.1  1.9  0.3  0.2   \n",
       "               2002.0 5421    5.4  .361  ...  0.3  0.7  1.0  1.8  0.2  0.2   \n",
       "               2003.0 5929    2.0  .000  ...  0.0  0.0  0.0  1.0  0.5  0.0   \n",
       "A.J. Hammons   2017.0 14364   1.9  .405  ...  0.4  1.3  1.6  0.2  0.0  0.6   \n",
       "A.J. Price     2010.0 10270   6.3  .410  ...  0.2  1.4  1.6  1.9  0.6  0.1   \n",
       "               2011.0 10900   6.4  .356  ...  0.3  1.1  1.4  2.2  0.6  0.0   \n",
       "               2012.0 11485   4.0  .339  ...  0.3  1.1  1.4  2.0  0.5  0.0   \n",
       "               2013.0 12078   7.2  .390  ...  0.4  1.6  2.0  3.6  0.6  0.1   \n",
       "               2014.0 12709   1.6  .413  ...  0.0  0.3  0.4  0.5  0.0  0.0   \n",
       "               2015.0 13358   5.3  .372  ...  0.2  1.0  1.2  1.8  0.3  0.0   \n",
       "A.J. Wynder    1992.0 458     2.0  .250  ...  0.2  0.3  0.5  1.3  0.2  0.0   \n",
       "Aaron Brooks   2008.0 8672    4.4  .413  ...  0.3  0.8  1.1  1.7  0.3  0.1   \n",
       "               2009.0 9294    9.8  .404  ...  0.4  1.6  2.0  3.0  0.6  0.1   \n",
       "               2010.0 9896   16.2  .432  ...  0.7  2.0  2.6  5.3  0.8  0.2   \n",
       "               2011.0 10513   9.9  .375  ...  0.3  1.0  1.3  3.9  0.6  0.1   \n",
       "               2013.0 11714   6.0  .453  ...  0.2  1.3  1.5  2.2  0.6  0.2   \n",
       "               2014.0 12323   8.1  .401  ...  0.6  1.3  1.9  3.2  0.7  0.2   \n",
       "               2015.0 12948  10.0  .421  ...  0.4  1.6  2.0  3.2  0.7  0.2   \n",
       "               2016.0 13614   6.8  .401  ...  0.3  1.2  1.5  2.6  0.4  0.1   \n",
       "               2017.0 14218   4.6  .403  ...  0.3  0.8  1.1  1.9  0.4  0.1   \n",
       "               2018.0 14848   2.2  .406  ...  0.2  0.3  0.5  0.6  0.2  0.0   \n",
       "Aaron Gordon   2015.0 13102   4.4  .447  ...  1.0  2.6  3.6  0.7  0.4  0.5   \n",
       "               2016.0 13735   7.4  .473  ...  2.0  4.5  6.5  1.6  0.8  0.7   \n",
       "               2017.0 14348  10.8  .454  ...  1.5  3.6  5.1  1.9  0.8  0.5   \n",
       "               2018.0 14990  14.9  .434  ...  1.5  6.4  7.9  2.3  1.0  0.8   \n",
       "               2019.0 15714  13.4  .449  ...  1.7  5.7  7.4  3.7  0.7  0.7   \n",
       "               2020.0 16430  12.4  .437  ...  1.7  5.9  7.7  3.7  0.8  0.6   \n",
       "               2021.0 17107  10.0  .463  ...  1.5  4.1  5.7  3.2  0.7  0.7   \n",
       "               2022.0 17867  11.1  .520  ...  1.7  4.2  5.9  2.5  0.6  0.6   \n",
       "Aaron Gray     2008.0 8812    3.3  .505  ...  1.1  1.6  2.8  0.7  0.3  0.3   \n",
       "               2009.0 9434    3.0  .485  ...  1.5  2.4  3.9  0.8  0.3  0.3   \n",
       "               2010.0 10025   2.6  .512  ...  1.4  1.9  3.3  0.7  0.3  0.3   \n",
       "               2011.0 10677   2.4  .566  ...  1.4  2.7  4.2  0.4  0.3  0.3   \n",
       "               2012.0 11275   3.3  .516  ...  1.7  4.0  5.7  0.6  0.4  0.3   \n",
       "               2013.0 11841   2.1  .533  ...  1.1  2.0  3.2  0.8  0.2  0.1   \n",
       "               2014.0 12478   1.6  .443  ...  1.1  1.9  3.0  0.6  0.3  0.2   \n",
       "Aaron Harrison 2016.0 13771   0.9  .263  ...  0.2  0.5  0.7  0.1  0.3  0.0   \n",
       "               2017.0 14376   0.8  .000  ...  0.0  0.6  0.6  0.6  0.0  0.0   \n",
       "\n",
       "                             TOV   PF   PTS    Year  \n",
       "Player         Year                                  \n",
       "A.C. Green     1992.0 165    1.2  1.4   9.1  1992.0  \n",
       "               1993.0 618    1.4  1.8  12.8  1993.0  \n",
       "               1994.0 1106   1.2  1.7  14.7  1994.0  \n",
       "               1995.0 1595   1.4  1.8  11.2  1995.0  \n",
       "               1996.0 2092   1.0  1.7   7.5  1996.0  \n",
       "               1997.0 2668   0.9  1.7   7.2  1997.0  \n",
       "               1998.0 3256   0.8  1.9   7.3  1998.0  \n",
       "               1999.0 3815   0.4  1.4   4.9  1999.0  \n",
       "               2000.0 4344   0.6  1.5   5.0  2000.0  \n",
       "               2001.0 4864   0.5  1.5   4.5  2001.0  \n",
       "A.J. Bramlett  2000.0 4217   0.4  1.6   1.0  2000.0  \n",
       "A.J. English   1992.0 128    1.6  1.8   8.8  1992.0  \n",
       "A.J. Guyton    2001.0 4867   0.7  1.1   6.0  2001.0  \n",
       "               2002.0 5421   0.8  0.5   5.4  2002.0  \n",
       "               2003.0 5929   0.5  0.0   0.0  2003.0  \n",
       "A.J. Hammons   2017.0 14364  0.5  1.0   2.2  2017.0  \n",
       "A.J. Price     2010.0 10270  1.1  0.9   7.3  2010.0  \n",
       "               2011.0 10900  1.1  1.2   6.5  2011.0  \n",
       "               2012.0 11485  0.7  0.7   3.9  2012.0  \n",
       "               2013.0 12078  1.1  1.3   7.7  2013.0  \n",
       "               2014.0 12709  0.3  0.2   1.6  2014.0  \n",
       "               2015.0 13358  0.5  0.6   5.1  2015.0  \n",
       "A.J. Wynder    1992.0 458    0.7  0.2   2.0  1992.0  \n",
       "Aaron Brooks   2008.0 8672   0.9  1.4   5.2  2008.0  \n",
       "               2009.0 9294   1.6  1.9  11.2  2009.0  \n",
       "               2010.0 9896   2.8  2.4  19.6  2010.0  \n",
       "               2011.0 10513  1.7  1.9  10.7  2011.0  \n",
       "               2013.0 11714  1.3  1.8   7.1  2013.0  \n",
       "               2014.0 12323  1.6  2.0   9.0  2014.0  \n",
       "               2015.0 12948  1.9  2.3  11.6  2015.0  \n",
       "               2016.0 13614  1.2  1.9   7.1  2016.0  \n",
       "               2017.0 14218  1.0  1.4   5.0  2017.0  \n",
       "               2018.0 14848  0.3  0.9   2.3  2018.0  \n",
       "Aaron Gordon   2015.0 13102  0.8  1.8   5.2  2015.0  \n",
       "               2016.0 13735  0.8  2.0   9.2  2016.0  \n",
       "               2017.0 14348  1.1  2.2  12.7  2017.0  \n",
       "               2018.0 14990  1.8  1.9  17.6  2018.0  \n",
       "               2019.0 15714  2.1  2.2  16.0  2019.0  \n",
       "               2020.0 16430  1.6  2.0  14.4  2020.0  \n",
       "               2021.0 17107  1.9  1.8  12.4  2021.0  \n",
       "               2022.0 17867  1.8  2.0  15.0  2022.0  \n",
       "Aaron Gray     2008.0 8812   0.9  1.9   4.3  2008.0  \n",
       "               2009.0 9434   0.7  2.4   3.5  2009.0  \n",
       "               2010.0 10025  0.6  1.7   3.3  2010.0  \n",
       "               2011.0 10677  0.8  2.3   3.1  2011.0  \n",
       "               2012.0 11275  1.0  2.6   3.9  2012.0  \n",
       "               2013.0 11841  0.9  2.0   2.8  2013.0  \n",
       "               2014.0 12478  0.8  1.7   1.8  2014.0  \n",
       "Aaron Harrison 2016.0 13771  0.2  0.5   0.9  2016.0  \n",
       "               2017.0 14376  0.0  0.4   0.2  2017.0  \n",
       "\n",
       "[50 rows x 30 columns]"
      ]
     },
     "execution_count": 323,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 324,
   "id": "194af300-bf4f-4f93-9b6b-e53e7a72c9c7",
   "metadata": {},
   "outputs": [],
   "source": [
    "players.index = players.index.droplevel()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 325,
   "id": "b81104d2-54f8-42de-aeb4-cf233c323f21",
   "metadata": {},
   "outputs": [],
   "source": [
    "players.index = players.index.droplevel()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 405,
   "id": "7ac736b0-8877-4fbc-919a-71676b9b10ad",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Player       0\n",
       "Pos          0\n",
       "Age          0\n",
       "Tm        1650\n",
       "G            0\n",
       "GS           0\n",
       "MP           0\n",
       "FG           0\n",
       "FGA          0\n",
       "FG%         54\n",
       "3P           0\n",
       "3PA          0\n",
       "3P%       2025\n",
       "2P           0\n",
       "2PA          0\n",
       "2P%         95\n",
       "eFG%        54\n",
       "FT           0\n",
       "FTA          0\n",
       "FT%        509\n",
       "ORB          0\n",
       "DRB          0\n",
       "TRB          0\n",
       "AST          0\n",
       "STL          0\n",
       "BLK          0\n",
       "TOV          0\n",
       "PF           0\n",
       "PTS          0\n",
       "Year         0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 405,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#some players are without teams. seems wrong but we will work with it \n",
    "players.apply(pd.isna).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 363,
   "id": "af4e88a3-ce74-415d-a313-622b92a1691a",
   "metadata": {},
   "outputs": [],
   "source": [
    "all_stats = players.merge(mvp, how=\"outer\", on = [\"Player\", \"Year\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1fbc779e-a7df-4076-b374-ca1df1fa476d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 367,
   "id": "c893e174-d22d-4c36-8d71-8093461f4053",
   "metadata": {},
   "outputs": [],
   "source": [
    "all_stats[[\"Pts Won\", \"Pts Max\", \"Share\"]] = all_stats[[\"Pts Won\", \"Pts Max\", \"Share\"]].fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 413,
   "id": "2740849e-82f9-41e7-a711-12b9eed75272",
   "metadata": {},
   "outputs": [],
   "source": [
    "#The empty teams will lead to inconsistency during the machine learning process\n",
    "#Drop the rows with Teams empty\n",
    "all_stats.apply(pd.isna).sum()\n",
    "all_stats = all_stats.drop(all_stats[pd.isna(all_stats[\"Tm\"])].index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9ee45321-5776-4dca-8188-518dc02f89a4",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Reshaping the index\n",
    "all_stats.index = range(all_stats.shape[0])\n",
    "all_stats.isna().sum()\n",
    "\n",
    "\n",
    "all_stats[\"FG%\", \"3P%\", \"FT%\"] = all_stats[\"FG%\", \"3P%\", \"FT%\"].fillna(0)  #columns are still objects"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "80fa50ed-2dd3-4641-b2e9-1ebd06ea9cde",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "all_stats.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d4e009a3-fb30-488d-b7c9-ac18519b7c7b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "id": "dc41c706-ec73-47b6-b691-7c3c5f671868",
   "metadata": {},
   "outputs": [],
   "source": [
    "teams = pd.read_csv(\"teams.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "id": "e09f038c-9ea8-493e-9f8d-6b12373fd7c1",
   "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>Unnamed: 0</th>\n",
       "      <th>W</th>\n",
       "      <th>L</th>\n",
       "      <th>W/L%</th>\n",
       "      <th>GB</th>\n",
       "      <th>PS/G</th>\n",
       "      <th>PA/G</th>\n",
       "      <th>SRS</th>\n",
       "      <th>Year</th>\n",
       "      <th>Team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>.683</td>\n",
       "      <td>—</td>\n",
       "      <td>111.5</td>\n",
       "      <td>105.7</td>\n",
       "      <td>5.22</td>\n",
       "      <td>1991</td>\n",
       "      <td>Boston Celtics*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>38</td>\n",
       "      <td>.537</td>\n",
       "      <td>12.0</td>\n",
       "      <td>105.4</td>\n",
       "      <td>105.6</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>1991</td>\n",
       "      <td>Philadelphia 76ers*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>43</td>\n",
       "      <td>.476</td>\n",
       "      <td>17.0</td>\n",
       "      <td>103.1</td>\n",
       "      <td>103.3</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>1991</td>\n",
       "      <td>New York Knicks*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>52</td>\n",
       "      <td>.366</td>\n",
       "      <td>26.0</td>\n",
       "      <td>101.4</td>\n",
       "      <td>106.4</td>\n",
       "      <td>-4.84</td>\n",
       "      <td>1991</td>\n",
       "      <td>Washington Bullets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>56</td>\n",
       "      <td>.317</td>\n",
       "      <td>30.0</td>\n",
       "      <td>102.9</td>\n",
       "      <td>107.5</td>\n",
       "      <td>-4.53</td>\n",
       "      <td>1991</td>\n",
       "      <td>New Jersey Nets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>58</td>\n",
       "      <td>.293</td>\n",
       "      <td>32.0</td>\n",
       "      <td>101.8</td>\n",
       "      <td>107.8</td>\n",
       "      <td>-5.91</td>\n",
       "      <td>1991</td>\n",
       "      <td>Miami Heat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Central Division</td>\n",
       "      <td>Central Division</td>\n",
       "      <td>Central Division</td>\n",
       "      <td>Central Division</td>\n",
       "      <td>Central Division</td>\n",
       "      <td>Central Division</td>\n",
       "      <td>Central Division</td>\n",
       "      <td>1991</td>\n",
       "      <td>Central Division</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>61</td>\n",
       "      <td>21</td>\n",
       "      <td>.744</td>\n",
       "      <td>—</td>\n",
       "      <td>110.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>8.57</td>\n",
       "      <td>1991</td>\n",
       "      <td>Chicago Bulls*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>32</td>\n",
       "      <td>.610</td>\n",
       "      <td>11.0</td>\n",
       "      <td>100.1</td>\n",
       "      <td>96.8</td>\n",
       "      <td>3.08</td>\n",
       "      <td>1991</td>\n",
       "      <td>Detroit Pistons*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>48</td>\n",
       "      <td>34</td>\n",
       "      <td>.585</td>\n",
       "      <td>13.0</td>\n",
       "      <td>106.4</td>\n",
       "      <td>104.0</td>\n",
       "      <td>2.33</td>\n",
       "      <td>1991</td>\n",
       "      <td>Milwaukee Bucks*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>.524</td>\n",
       "      <td>18.0</td>\n",
       "      <td>109.8</td>\n",
       "      <td>109.0</td>\n",
       "      <td>0.72</td>\n",
       "      <td>1991</td>\n",
       "      <td>Atlanta Hawks*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>.500</td>\n",
       "      <td>20.0</td>\n",
       "      <td>111.7</td>\n",
       "      <td>112.1</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>1991</td>\n",
       "      <td>Indiana Pacers*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>33</td>\n",
       "      <td>49</td>\n",
       "      <td>.402</td>\n",
       "      <td>28.0</td>\n",
       "      <td>101.7</td>\n",
       "      <td>104.2</td>\n",
       "      <td>-2.33</td>\n",
       "      <td>1991</td>\n",
       "      <td>Cleveland Cavaliers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>26</td>\n",
       "      <td>56</td>\n",
       "      <td>.317</td>\n",
       "      <td>35.0</td>\n",
       "      <td>102.8</td>\n",
       "      <td>108.0</td>\n",
       "      <td>-4.95</td>\n",
       "      <td>1991</td>\n",
       "      <td>Charlotte Hornets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>Midwest Division</td>\n",
       "      <td>Midwest Division</td>\n",
       "      <td>Midwest Division</td>\n",
       "      <td>Midwest Division</td>\n",
       "      <td>Midwest Division</td>\n",
       "      <td>Midwest Division</td>\n",
       "      <td>Midwest Division</td>\n",
       "      <td>1991</td>\n",
       "      <td>Midwest Division</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>27</td>\n",
       "      <td>.671</td>\n",
       "      <td>—</td>\n",
       "      <td>107.1</td>\n",
       "      <td>102.6</td>\n",
       "      <td>4.30</td>\n",
       "      <td>1991</td>\n",
       "      <td>San Antonio Spurs*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>54</td>\n",
       "      <td>28</td>\n",
       "      <td>.659</td>\n",
       "      <td>1.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>100.7</td>\n",
       "      <td>3.18</td>\n",
       "      <td>1991</td>\n",
       "      <td>Utah Jazz*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3</td>\n",
       "      <td>52</td>\n",
       "      <td>30</td>\n",
       "      <td>.634</td>\n",
       "      <td>3.0</td>\n",
       "      <td>106.7</td>\n",
       "      <td>103.2</td>\n",
       "      <td>3.27</td>\n",
       "      <td>1991</td>\n",
       "      <td>Houston Rockets*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4</td>\n",
       "      <td>31</td>\n",
       "      <td>51</td>\n",
       "      <td>.378</td>\n",
       "      <td>24.0</td>\n",
       "      <td>105.9</td>\n",
       "      <td>109.9</td>\n",
       "      <td>-3.79</td>\n",
       "      <td>1991</td>\n",
       "      <td>Orlando Magic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5</td>\n",
       "      <td>29</td>\n",
       "      <td>53</td>\n",
       "      <td>.354</td>\n",
       "      <td>26.0</td>\n",
       "      <td>99.6</td>\n",
       "      <td>103.5</td>\n",
       "      <td>-3.75</td>\n",
       "      <td>1991</td>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0                 W                 L              W/L%  \\\n",
       "0            0                56                26              .683   \n",
       "1            1                44                38              .537   \n",
       "2            2                39                43              .476   \n",
       "3            3                30                52              .366   \n",
       "4            4                26                56              .317   \n",
       "5            5                24                58              .293   \n",
       "6            6  Central Division  Central Division  Central Division   \n",
       "7            7                61                21              .744   \n",
       "8            8                50                32              .610   \n",
       "9            9                48                34              .585   \n",
       "10          10                43                39              .524   \n",
       "11          11                41                41              .500   \n",
       "12          12                33                49              .402   \n",
       "13          13                26                56              .317   \n",
       "14           0  Midwest Division  Midwest Division  Midwest Division   \n",
       "15           1                55                27              .671   \n",
       "16           2                54                28              .659   \n",
       "17           3                52                30              .634   \n",
       "18           4                31                51              .378   \n",
       "19           5                29                53              .354   \n",
       "\n",
       "                  GB              PS/G              PA/G               SRS  \\\n",
       "0                  —             111.5             105.7              5.22   \n",
       "1               12.0             105.4             105.6             -0.39   \n",
       "2               17.0             103.1             103.3             -0.43   \n",
       "3               26.0             101.4             106.4             -4.84   \n",
       "4               30.0             102.9             107.5             -4.53   \n",
       "5               32.0             101.8             107.8             -5.91   \n",
       "6   Central Division  Central Division  Central Division  Central Division   \n",
       "7                  —             110.0             101.0              8.57   \n",
       "8               11.0             100.1              96.8              3.08   \n",
       "9               13.0             106.4             104.0              2.33   \n",
       "10              18.0             109.8             109.0              0.72   \n",
       "11              20.0             111.7             112.1             -0.37   \n",
       "12              28.0             101.7             104.2             -2.33   \n",
       "13              35.0             102.8             108.0             -4.95   \n",
       "14  Midwest Division  Midwest Division  Midwest Division  Midwest Division   \n",
       "15                 —             107.1             102.6              4.30   \n",
       "16               1.0             104.0             100.7              3.18   \n",
       "17               3.0             106.7             103.2              3.27   \n",
       "18              24.0             105.9             109.9             -3.79   \n",
       "19              26.0              99.6             103.5             -3.75   \n",
       "\n",
       "    Year                    Team  \n",
       "0   1991         Boston Celtics*  \n",
       "1   1991     Philadelphia 76ers*  \n",
       "2   1991        New York Knicks*  \n",
       "3   1991      Washington Bullets  \n",
       "4   1991         New Jersey Nets  \n",
       "5   1991              Miami Heat  \n",
       "6   1991        Central Division  \n",
       "7   1991          Chicago Bulls*  \n",
       "8   1991        Detroit Pistons*  \n",
       "9   1991        Milwaukee Bucks*  \n",
       "10  1991          Atlanta Hawks*  \n",
       "11  1991         Indiana Pacers*  \n",
       "12  1991     Cleveland Cavaliers  \n",
       "13  1991       Charlotte Hornets  \n",
       "14  1991        Midwest Division  \n",
       "15  1991      San Antonio Spurs*  \n",
       "16  1991              Utah Jazz*  \n",
       "17  1991        Houston Rockets*  \n",
       "18  1991           Orlando Magic  \n",
       "19  1991  Minnesota Timberwolves  "
      ]
     },
     "execution_count": 287,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 288,
   "id": "878ae285-ac56-4e88-b199-7e2ed74aaf04",
   "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>W</th>\n",
       "      <th>L</th>\n",
       "      <th>W/L%</th>\n",
       "      <th>GB</th>\n",
       "      <th>PS/G</th>\n",
       "      <th>PA/G</th>\n",
       "      <th>SRS</th>\n",
       "      <th>Year</th>\n",
       "      <th>Team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>.683</td>\n",
       "      <td>—</td>\n",
       "      <td>111.5</td>\n",
       "      <td>105.7</td>\n",
       "      <td>5.22</td>\n",
       "      <td>1991</td>\n",
       "      <td>Boston Celtics*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>38</td>\n",
       "      <td>.537</td>\n",
       "      <td>12.0</td>\n",
       "      <td>105.4</td>\n",
       "      <td>105.6</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>1991</td>\n",
       "      <td>Philadelphia 76ers*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>43</td>\n",
       "      <td>.476</td>\n",
       "      <td>17.0</td>\n",
       "      <td>103.1</td>\n",
       "      <td>103.3</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>1991</td>\n",
       "      <td>New York Knicks*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>52</td>\n",
       "      <td>.366</td>\n",
       "      <td>26.0</td>\n",
       "      <td>101.4</td>\n",
       "      <td>106.4</td>\n",
       "      <td>-4.84</td>\n",
       "      <td>1991</td>\n",
       "      <td>Washington Bullets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>56</td>\n",
       "      <td>.317</td>\n",
       "      <td>30.0</td>\n",
       "      <td>102.9</td>\n",
       "      <td>107.5</td>\n",
       "      <td>-4.53</td>\n",
       "      <td>1991</td>\n",
       "      <td>New Jersey Nets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>58</td>\n",
       "      <td>.293</td>\n",
       "      <td>32.0</td>\n",
       "      <td>101.8</td>\n",
       "      <td>107.8</td>\n",
       "      <td>-5.91</td>\n",
       "      <td>1991</td>\n",
       "      <td>Miami Heat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>61</td>\n",
       "      <td>21</td>\n",
       "      <td>.744</td>\n",
       "      <td>—</td>\n",
       "      <td>110.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>8.57</td>\n",
       "      <td>1991</td>\n",
       "      <td>Chicago Bulls*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>32</td>\n",
       "      <td>.610</td>\n",
       "      <td>11.0</td>\n",
       "      <td>100.1</td>\n",
       "      <td>96.8</td>\n",
       "      <td>3.08</td>\n",
       "      <td>1991</td>\n",
       "      <td>Detroit Pistons*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>48</td>\n",
       "      <td>34</td>\n",
       "      <td>.585</td>\n",
       "      <td>13.0</td>\n",
       "      <td>106.4</td>\n",
       "      <td>104.0</td>\n",
       "      <td>2.33</td>\n",
       "      <td>1991</td>\n",
       "      <td>Milwaukee Bucks*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>.524</td>\n",
       "      <td>18.0</td>\n",
       "      <td>109.8</td>\n",
       "      <td>109.0</td>\n",
       "      <td>0.72</td>\n",
       "      <td>1991</td>\n",
       "      <td>Atlanta Hawks*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>.500</td>\n",
       "      <td>20.0</td>\n",
       "      <td>111.7</td>\n",
       "      <td>112.1</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>1991</td>\n",
       "      <td>Indiana Pacers*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>33</td>\n",
       "      <td>49</td>\n",
       "      <td>.402</td>\n",
       "      <td>28.0</td>\n",
       "      <td>101.7</td>\n",
       "      <td>104.2</td>\n",
       "      <td>-2.33</td>\n",
       "      <td>1991</td>\n",
       "      <td>Cleveland Cavaliers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>26</td>\n",
       "      <td>56</td>\n",
       "      <td>.317</td>\n",
       "      <td>35.0</td>\n",
       "      <td>102.8</td>\n",
       "      <td>108.0</td>\n",
       "      <td>-4.95</td>\n",
       "      <td>1991</td>\n",
       "      <td>Charlotte Hornets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>27</td>\n",
       "      <td>.671</td>\n",
       "      <td>—</td>\n",
       "      <td>107.1</td>\n",
       "      <td>102.6</td>\n",
       "      <td>4.30</td>\n",
       "      <td>1991</td>\n",
       "      <td>San Antonio Spurs*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>54</td>\n",
       "      <td>28</td>\n",
       "      <td>.659</td>\n",
       "      <td>1.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>100.7</td>\n",
       "      <td>3.18</td>\n",
       "      <td>1991</td>\n",
       "      <td>Utah Jazz*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3</td>\n",
       "      <td>52</td>\n",
       "      <td>30</td>\n",
       "      <td>.634</td>\n",
       "      <td>3.0</td>\n",
       "      <td>106.7</td>\n",
       "      <td>103.2</td>\n",
       "      <td>3.27</td>\n",
       "      <td>1991</td>\n",
       "      <td>Houston Rockets*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4</td>\n",
       "      <td>31</td>\n",
       "      <td>51</td>\n",
       "      <td>.378</td>\n",
       "      <td>24.0</td>\n",
       "      <td>105.9</td>\n",
       "      <td>109.9</td>\n",
       "      <td>-3.79</td>\n",
       "      <td>1991</td>\n",
       "      <td>Orlando Magic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5</td>\n",
       "      <td>29</td>\n",
       "      <td>53</td>\n",
       "      <td>.354</td>\n",
       "      <td>26.0</td>\n",
       "      <td>99.6</td>\n",
       "      <td>103.5</td>\n",
       "      <td>-3.75</td>\n",
       "      <td>1991</td>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>6</td>\n",
       "      <td>28</td>\n",
       "      <td>54</td>\n",
       "      <td>.341</td>\n",
       "      <td>27.0</td>\n",
       "      <td>99.9</td>\n",
       "      <td>104.5</td>\n",
       "      <td>-4.27</td>\n",
       "      <td>1991</td>\n",
       "      <td>Dallas Mavericks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>7</td>\n",
       "      <td>20</td>\n",
       "      <td>62</td>\n",
       "      <td>.244</td>\n",
       "      <td>35.0</td>\n",
       "      <td>119.9</td>\n",
       "      <td>130.8</td>\n",
       "      <td>-10.31</td>\n",
       "      <td>1991</td>\n",
       "      <td>Denver Nuggets</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0   W   L  W/L%    GB   PS/G   PA/G     SRS  Year  \\\n",
       "0            0  56  26  .683     —  111.5  105.7    5.22  1991   \n",
       "1            1  44  38  .537  12.0  105.4  105.6   -0.39  1991   \n",
       "2            2  39  43  .476  17.0  103.1  103.3   -0.43  1991   \n",
       "3            3  30  52  .366  26.0  101.4  106.4   -4.84  1991   \n",
       "4            4  26  56  .317  30.0  102.9  107.5   -4.53  1991   \n",
       "5            5  24  58  .293  32.0  101.8  107.8   -5.91  1991   \n",
       "7            7  61  21  .744     —  110.0  101.0    8.57  1991   \n",
       "8            8  50  32  .610  11.0  100.1   96.8    3.08  1991   \n",
       "9            9  48  34  .585  13.0  106.4  104.0    2.33  1991   \n",
       "10          10  43  39  .524  18.0  109.8  109.0    0.72  1991   \n",
       "11          11  41  41  .500  20.0  111.7  112.1   -0.37  1991   \n",
       "12          12  33  49  .402  28.0  101.7  104.2   -2.33  1991   \n",
       "13          13  26  56  .317  35.0  102.8  108.0   -4.95  1991   \n",
       "15           1  55  27  .671     —  107.1  102.6    4.30  1991   \n",
       "16           2  54  28  .659   1.0  104.0  100.7    3.18  1991   \n",
       "17           3  52  30  .634   3.0  106.7  103.2    3.27  1991   \n",
       "18           4  31  51  .378  24.0  105.9  109.9   -3.79  1991   \n",
       "19           5  29  53  .354  26.0   99.6  103.5   -3.75  1991   \n",
       "20           6  28  54  .341  27.0   99.9  104.5   -4.27  1991   \n",
       "21           7  20  62  .244  35.0  119.9  130.8  -10.31  1991   \n",
       "\n",
       "                      Team  \n",
       "0          Boston Celtics*  \n",
       "1      Philadelphia 76ers*  \n",
       "2         New York Knicks*  \n",
       "3       Washington Bullets  \n",
       "4          New Jersey Nets  \n",
       "5               Miami Heat  \n",
       "7           Chicago Bulls*  \n",
       "8         Detroit Pistons*  \n",
       "9         Milwaukee Bucks*  \n",
       "10          Atlanta Hawks*  \n",
       "11         Indiana Pacers*  \n",
       "12     Cleveland Cavaliers  \n",
       "13       Charlotte Hornets  \n",
       "15      San Antonio Spurs*  \n",
       "16              Utah Jazz*  \n",
       "17        Houston Rockets*  \n",
       "18           Orlando Magic  \n",
       "19  Minnesota Timberwolves  \n",
       "20        Dallas Mavericks  \n",
       "21          Denver Nuggets  "
      ]
     },
     "execution_count": 288,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams = teams[~teams[\"W\"].str.contains(\"Division\")]\n",
    "teams.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 289,
   "id": "b7c1f5ee-13e2-4635-986b-d3b636576e92",
   "metadata": {},
   "outputs": [],
   "source": [
    "teams[\"Team\"] = teams[\"Team\"].str.replace(\"*\", \"\", regex=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 291,
   "id": "7b572a78-fdb6-416f-82c6-ee36aee5b03a",
   "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>W</th>\n",
       "      <th>L</th>\n",
       "      <th>W/L%</th>\n",
       "      <th>GB</th>\n",
       "      <th>PS/G</th>\n",
       "      <th>PA/G</th>\n",
       "      <th>SRS</th>\n",
       "      <th>Year</th>\n",
       "      <th>Team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>.683</td>\n",
       "      <td>0</td>\n",
       "      <td>111.5</td>\n",
       "      <td>105.7</td>\n",
       "      <td>5.22</td>\n",
       "      <td>1991</td>\n",
       "      <td>Boston Celtics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>38</td>\n",
       "      <td>.537</td>\n",
       "      <td>12.0</td>\n",
       "      <td>105.4</td>\n",
       "      <td>105.6</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>1991</td>\n",
       "      <td>Philadelphia 76ers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>43</td>\n",
       "      <td>.476</td>\n",
       "      <td>17.0</td>\n",
       "      <td>103.1</td>\n",
       "      <td>103.3</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>1991</td>\n",
       "      <td>New York Knicks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>52</td>\n",
       "      <td>.366</td>\n",
       "      <td>26.0</td>\n",
       "      <td>101.4</td>\n",
       "      <td>106.4</td>\n",
       "      <td>-4.84</td>\n",
       "      <td>1991</td>\n",
       "      <td>Washington Bullets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>56</td>\n",
       "      <td>.317</td>\n",
       "      <td>30.0</td>\n",
       "      <td>102.9</td>\n",
       "      <td>107.5</td>\n",
       "      <td>-4.53</td>\n",
       "      <td>1991</td>\n",
       "      <td>New Jersey Nets</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>1063</th>\n",
       "      <td>13</td>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>.683</td>\n",
       "      <td>0</td>\n",
       "      <td>115.6</td>\n",
       "      <td>109.9</td>\n",
       "      <td>5.37</td>\n",
       "      <td>2022</td>\n",
       "      <td>Memphis Grizzlies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>14</td>\n",
       "      <td>52</td>\n",
       "      <td>30</td>\n",
       "      <td>.634</td>\n",
       "      <td>4.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>104.7</td>\n",
       "      <td>3.12</td>\n",
       "      <td>2022</td>\n",
       "      <td>Dallas Mavericks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>15</td>\n",
       "      <td>36</td>\n",
       "      <td>46</td>\n",
       "      <td>.439</td>\n",
       "      <td>20.0</td>\n",
       "      <td>109.3</td>\n",
       "      <td>110.3</td>\n",
       "      <td>-0.84</td>\n",
       "      <td>2022</td>\n",
       "      <td>New Orleans Pelicans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>16</td>\n",
       "      <td>34</td>\n",
       "      <td>48</td>\n",
       "      <td>.415</td>\n",
       "      <td>22.0</td>\n",
       "      <td>113.2</td>\n",
       "      <td>113.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>2022</td>\n",
       "      <td>San Antonio Spurs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>17</td>\n",
       "      <td>20</td>\n",
       "      <td>62</td>\n",
       "      <td>.244</td>\n",
       "      <td>36.0</td>\n",
       "      <td>109.7</td>\n",
       "      <td>118.2</td>\n",
       "      <td>-8.26</td>\n",
       "      <td>2022</td>\n",
       "      <td>Houston Rockets</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>936 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0   W   L  W/L%    GB   PS/G   PA/G    SRS  Year  \\\n",
       "0              0  56  26  .683     0  111.5  105.7   5.22  1991   \n",
       "1              1  44  38  .537  12.0  105.4  105.6  -0.39  1991   \n",
       "2              2  39  43  .476  17.0  103.1  103.3  -0.43  1991   \n",
       "3              3  30  52  .366  26.0  101.4  106.4  -4.84  1991   \n",
       "4              4  26  56  .317  30.0  102.9  107.5  -4.53  1991   \n",
       "...          ...  ..  ..   ...   ...    ...    ...    ...   ...   \n",
       "1063          13  56  26  .683     0  115.6  109.9   5.37  2022   \n",
       "1064          14  52  30  .634   4.0  108.0  104.7   3.12  2022   \n",
       "1065          15  36  46  .439  20.0  109.3  110.3  -0.84  2022   \n",
       "1066          16  34  48  .415  22.0  113.2  113.0   0.02  2022   \n",
       "1067          17  20  62  .244  36.0  109.7  118.2  -8.26  2022   \n",
       "\n",
       "                      Team  \n",
       "0           Boston Celtics  \n",
       "1       Philadelphia 76ers  \n",
       "2          New York Knicks  \n",
       "3       Washington Bullets  \n",
       "4          New Jersey Nets  \n",
       "...                    ...  \n",
       "1063     Memphis Grizzlies  \n",
       "1064      Dallas Mavericks  \n",
       "1065  New Orleans Pelicans  \n",
       "1066     San Antonio Spurs  \n",
       "1067       Houston Rockets  \n",
       "\n",
       "[936 rows x 10 columns]"
      ]
     },
     "execution_count": 291,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams.replace(\"—\", \"0\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 372,
   "id": "8301bc5e-e4c7-48b1-9d10-f4ce64bb6bee",
   "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>W</th>\n",
       "      <th>L</th>\n",
       "      <th>W/L%</th>\n",
       "      <th>GB</th>\n",
       "      <th>PS/G</th>\n",
       "      <th>PA/G</th>\n",
       "      <th>SRS</th>\n",
       "      <th>Year</th>\n",
       "      <th>Team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>.622</td>\n",
       "      <td>0</td>\n",
       "      <td>106.6</td>\n",
       "      <td>103.0</td>\n",
       "      <td>3.41</td>\n",
       "      <td>1992</td>\n",
       "      <td>Boston Celtics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>.622</td>\n",
       "      <td>0</td>\n",
       "      <td>101.6</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3.67</td>\n",
       "      <td>1992</td>\n",
       "      <td>New York Knicks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>40</td>\n",
       "      <td>42</td>\n",
       "      <td>.488</td>\n",
       "      <td>11.0</td>\n",
       "      <td>105.4</td>\n",
       "      <td>107.1</td>\n",
       "      <td>-1.54</td>\n",
       "      <td>1992</td>\n",
       "      <td>New Jersey Nets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>38</td>\n",
       "      <td>44</td>\n",
       "      <td>.463</td>\n",
       "      <td>13.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>109.2</td>\n",
       "      <td>-3.94</td>\n",
       "      <td>1992</td>\n",
       "      <td>Miami Heat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>47</td>\n",
       "      <td>.427</td>\n",
       "      <td>16.0</td>\n",
       "      <td>101.9</td>\n",
       "      <td>103.2</td>\n",
       "      <td>-1.34</td>\n",
       "      <td>1992</td>\n",
       "      <td>Philadelphia 76ers</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>.683</td>\n",
       "      <td>0</td>\n",
       "      <td>115.6</td>\n",
       "      <td>109.9</td>\n",
       "      <td>5.37</td>\n",
       "      <td>2022</td>\n",
       "      <td>Memphis Grizzlies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>52</td>\n",
       "      <td>30</td>\n",
       "      <td>.634</td>\n",
       "      <td>4.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>104.7</td>\n",
       "      <td>3.12</td>\n",
       "      <td>2022</td>\n",
       "      <td>Dallas Mavericks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>36</td>\n",
       "      <td>46</td>\n",
       "      <td>.439</td>\n",
       "      <td>20.0</td>\n",
       "      <td>109.3</td>\n",
       "      <td>110.3</td>\n",
       "      <td>-0.84</td>\n",
       "      <td>2022</td>\n",
       "      <td>New Orleans Pelicans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>34</td>\n",
       "      <td>48</td>\n",
       "      <td>.415</td>\n",
       "      <td>22.0</td>\n",
       "      <td>113.2</td>\n",
       "      <td>113.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>2022</td>\n",
       "      <td>San Antonio Spurs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>20</td>\n",
       "      <td>62</td>\n",
       "      <td>.244</td>\n",
       "      <td>36.0</td>\n",
       "      <td>109.7</td>\n",
       "      <td>118.2</td>\n",
       "      <td>-8.26</td>\n",
       "      <td>2022</td>\n",
       "      <td>Houston Rockets</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>909 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       W   L  W/L%    GB   PS/G   PA/G    SRS  Year                  Team\n",
       "30    51  31  .622     0  106.6  103.0   3.41  1992        Boston Celtics\n",
       "31    51  31  .622     0  101.6   97.7   3.67  1992       New York Knicks\n",
       "32    40  42  .488  11.0  105.4  107.1  -1.54  1992       New Jersey Nets\n",
       "33    38  44  .463  13.0  105.0  109.2  -3.94  1992            Miami Heat\n",
       "34    35  47  .427  16.0  101.9  103.2  -1.34  1992    Philadelphia 76ers\n",
       "...   ..  ..   ...   ...    ...    ...    ...   ...                   ...\n",
       "1063  56  26  .683     0  115.6  109.9   5.37  2022     Memphis Grizzlies\n",
       "1064  52  30  .634   4.0  108.0  104.7   3.12  2022      Dallas Mavericks\n",
       "1065  36  46  .439  20.0  109.3  110.3  -0.84  2022  New Orleans Pelicans\n",
       "1066  34  48  .415  22.0  113.2  113.0   0.02  2022     San Antonio Spurs\n",
       "1067  20  62  .244  36.0  109.7  118.2  -8.26  2022       Houston Rockets\n",
       "\n",
       "[909 rows x 9 columns]"
      ]
     },
     "execution_count": 372,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams = teams.drop(teams[teams[\"Year\"] == 1991].index)\n",
    "teams"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 373,
   "id": "982c659d-a3b6-40bc-844f-5c0431c9bc43",
   "metadata": {},
   "outputs": [],
   "source": [
    "teams = teams.replace(\"—\", \"0\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "22c5c9b8-5066-4141-b56c-3aba3674c093",
   "metadata": {},
   "outputs": [],
   "source": [
    "del teams[\"Unnamed: 0\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 429,
   "id": "703bb6d8-8b3a-4090-8662-b5dfef4195bd",
   "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>W</th>\n",
       "      <th>L</th>\n",
       "      <th>W/L%</th>\n",
       "      <th>GB</th>\n",
       "      <th>PS/G</th>\n",
       "      <th>PA/G</th>\n",
       "      <th>SRS</th>\n",
       "      <th>Year</th>\n",
       "      <th>Team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>.622</td>\n",
       "      <td>0</td>\n",
       "      <td>106.6</td>\n",
       "      <td>103.0</td>\n",
       "      <td>3.41</td>\n",
       "      <td>1992</td>\n",
       "      <td>Boston Celtics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>.622</td>\n",
       "      <td>0</td>\n",
       "      <td>101.6</td>\n",
       "      <td>97.7</td>\n",
       "      <td>3.67</td>\n",
       "      <td>1992</td>\n",
       "      <td>New York Knicks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>40</td>\n",
       "      <td>42</td>\n",
       "      <td>.488</td>\n",
       "      <td>11.0</td>\n",
       "      <td>105.4</td>\n",
       "      <td>107.1</td>\n",
       "      <td>-1.54</td>\n",
       "      <td>1992</td>\n",
       "      <td>New Jersey Nets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>38</td>\n",
       "      <td>44</td>\n",
       "      <td>.463</td>\n",
       "      <td>13.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>109.2</td>\n",
       "      <td>-3.94</td>\n",
       "      <td>1992</td>\n",
       "      <td>Miami Heat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>47</td>\n",
       "      <td>.427</td>\n",
       "      <td>16.0</td>\n",
       "      <td>101.9</td>\n",
       "      <td>103.2</td>\n",
       "      <td>-1.34</td>\n",
       "      <td>1992</td>\n",
       "      <td>Philadelphia 76ers</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>.683</td>\n",
       "      <td>0</td>\n",
       "      <td>115.6</td>\n",
       "      <td>109.9</td>\n",
       "      <td>5.37</td>\n",
       "      <td>2022</td>\n",
       "      <td>Memphis Grizzlies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>52</td>\n",
       "      <td>30</td>\n",
       "      <td>.634</td>\n",
       "      <td>4.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>104.7</td>\n",
       "      <td>3.12</td>\n",
       "      <td>2022</td>\n",
       "      <td>Dallas Mavericks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>36</td>\n",
       "      <td>46</td>\n",
       "      <td>.439</td>\n",
       "      <td>20.0</td>\n",
       "      <td>109.3</td>\n",
       "      <td>110.3</td>\n",
       "      <td>-0.84</td>\n",
       "      <td>2022</td>\n",
       "      <td>New Orleans Pelicans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>34</td>\n",
       "      <td>48</td>\n",
       "      <td>.415</td>\n",
       "      <td>22.0</td>\n",
       "      <td>113.2</td>\n",
       "      <td>113.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>2022</td>\n",
       "      <td>San Antonio Spurs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>20</td>\n",
       "      <td>62</td>\n",
       "      <td>.244</td>\n",
       "      <td>36.0</td>\n",
       "      <td>109.7</td>\n",
       "      <td>118.2</td>\n",
       "      <td>-8.26</td>\n",
       "      <td>2022</td>\n",
       "      <td>Houston Rockets</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>909 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       W   L  W/L%    GB   PS/G   PA/G    SRS  Year                  Team\n",
       "30    51  31  .622     0  106.6  103.0   3.41  1992        Boston Celtics\n",
       "31    51  31  .622     0  101.6   97.7   3.67  1992       New York Knicks\n",
       "32    40  42  .488  11.0  105.4  107.1  -1.54  1992       New Jersey Nets\n",
       "33    38  44  .463  13.0  105.0  109.2  -3.94  1992            Miami Heat\n",
       "34    35  47  .427  16.0  101.9  103.2  -1.34  1992    Philadelphia 76ers\n",
       "...   ..  ..   ...   ...    ...    ...    ...   ...                   ...\n",
       "1063  56  26  .683     0  115.6  109.9   5.37  2022     Memphis Grizzlies\n",
       "1064  52  30  .634   4.0  108.0  104.7   3.12  2022      Dallas Mavericks\n",
       "1065  36  46  .439  20.0  109.3  110.3  -0.84  2022  New Orleans Pelicans\n",
       "1066  34  48  .415  22.0  113.2  113.0   0.02  2022     San Antonio Spurs\n",
       "1067  20  62  .244  36.0  109.7  118.2  -8.26  2022       Houston Rockets\n",
       "\n",
       "[909 rows x 9 columns]"
      ]
     },
     "execution_count": 429,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e106c0c3-e748-4bcd-ab23-2e792dabf756",
   "metadata": {},
   "outputs": [],
   "source": [
    "spec = teams[\"Team\"].unique()\n",
    "spec"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "10b37590-3745-4956-9ca6-b1e27523b666",
   "metadata": {},
   "outputs": [],
   "source": [
    "spec_2 = all_stats[\"Tm\"].unique()\n",
    "spec_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 430,
   "id": "fef34010-db67-444c-84ab-e21a13271815",
   "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</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>MP</th>\n",
       "      <th>FG</th>\n",
       "      <th>FGA</th>\n",
       "      <th>FG%</th>\n",
       "      <th>...</th>\n",
       "      <th>STL</th>\n",
       "      <th>BLK</th>\n",
       "      <th>TOV</th>\n",
       "      <th>PF</th>\n",
       "      <th>PTS</th>\n",
       "      <th>Year</th>\n",
       "      <th>Pts Won</th>\n",
       "      <th>Pts Max</th>\n",
       "      <th>Share</th>\n",
       "      <th>Team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>21</td>\n",
       "      <td>26.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.6</td>\n",
       "      <td>.476</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>9.1</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>29</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>55</td>\n",
       "      <td>34.4</td>\n",
       "      <td>4.6</td>\n",
       "      <td>8.6</td>\n",
       "      <td>.537</td>\n",
       "      <td>...</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>30</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>55</td>\n",
       "      <td>34.5</td>\n",
       "      <td>5.7</td>\n",
       "      <td>11.3</td>\n",
       "      <td>.502</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>14.7</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Pheonix Suns</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>SF</td>\n",
       "      <td>31</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>52</td>\n",
       "      <td>32.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>7.5</td>\n",
       "      <td>.504</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>11.2</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Pheonix Suns</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>SF</td>\n",
       "      <td>32</td>\n",
       "      <td>PHO</td>\n",
       "      <td>82</td>\n",
       "      <td>36</td>\n",
       "      <td>25.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.4</td>\n",
       "      <td>.484</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>7.5</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Pheonix Suns</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12656</th>\n",
       "      <td>Žarko Čabarkapa</td>\n",
       "      <td>PF</td>\n",
       "      <td>24</td>\n",
       "      <td>GSW</td>\n",
       "      <td>61</td>\n",
       "      <td>0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.9</td>\n",
       "      <td>.385</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>3.3</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Golden State Warriors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12657</th>\n",
       "      <td>Željko Rebrača</td>\n",
       "      <td>C</td>\n",
       "      <td>29</td>\n",
       "      <td>DET</td>\n",
       "      <td>74</td>\n",
       "      <td>4</td>\n",
       "      <td>15.9</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.1</td>\n",
       "      <td>.505</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.6</td>\n",
       "      <td>6.9</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Detroit Pistons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12658</th>\n",
       "      <td>Željko Rebrača</td>\n",
       "      <td>C</td>\n",
       "      <td>30</td>\n",
       "      <td>DET</td>\n",
       "      <td>30</td>\n",
       "      <td>12</td>\n",
       "      <td>16.3</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.8</td>\n",
       "      <td>.552</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>6.6</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Detroit Pistons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12659</th>\n",
       "      <td>Željko Rebrača</td>\n",
       "      <td>C</td>\n",
       "      <td>32</td>\n",
       "      <td>LAC</td>\n",
       "      <td>58</td>\n",
       "      <td>2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>.568</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.2</td>\n",
       "      <td>5.8</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Clippers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12660</th>\n",
       "      <td>Željko Rebrača</td>\n",
       "      <td>C</td>\n",
       "      <td>33</td>\n",
       "      <td>LAC</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>14.2</td>\n",
       "      <td>1.8</td>\n",
       "      <td>3.3</td>\n",
       "      <td>.542</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Clippers</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12661 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player Pos Age   Tm   G  GS    MP   FG   FGA   FG%  ...  STL  \\\n",
       "0           A.C. Green  PF  27  LAL  82  21  26.4  3.1   6.6  .476  ...  0.7   \n",
       "1           A.C. Green  PF  29  LAL  82  55  34.4  4.6   8.6  .537  ...  1.1   \n",
       "2           A.C. Green  PF  30  PHO  82  55  34.5  5.7  11.3  .502  ...  0.9   \n",
       "3           A.C. Green  SF  31  PHO  82  52  32.8  3.8   7.5  .504  ...  0.7   \n",
       "4           A.C. Green  SF  32  PHO  82  36  25.8  2.6   5.4  .484  ...  0.5   \n",
       "...                ...  ..  ..  ...  ..  ..   ...  ...   ...   ...  ...  ...   \n",
       "12656  Žarko Čabarkapa  PF  24  GSW  61   0   8.3  1.1   2.9  .385  ...  0.2   \n",
       "12657   Željko Rebrača   C  29  DET  74   4  15.9  2.6   5.1  .505  ...  0.4   \n",
       "12658   Željko Rebrača   C  30  DET  30  12  16.3  2.7   4.8  .552  ...  0.2   \n",
       "12659   Željko Rebrača   C  32  LAC  58   2  16.0  2.3   4.0  .568  ...  0.2   \n",
       "12660   Željko Rebrača   C  33  LAC  29   2  14.2  1.8   3.3  .542  ...  0.2   \n",
       "\n",
       "       BLK  TOV   PF   PTS    Year Pts Won Pts Max Share  \\\n",
       "0      0.3  1.2  1.4   9.1  1992.0     0.0     0.0   0.0   \n",
       "1      0.5  1.4  1.8  12.8  1993.0     0.0     0.0   0.0   \n",
       "2      0.5  1.2  1.7  14.7  1994.0     0.0     0.0   0.0   \n",
       "3      0.4  1.4  1.8  11.2  1995.0     0.0     0.0   0.0   \n",
       "4      0.3  1.0  1.7   7.5  1996.0     0.0     0.0   0.0   \n",
       "...    ...  ...  ...   ...     ...     ...     ...   ...   \n",
       "12656  0.1  0.6  1.4   3.3  2006.0     0.0     0.0   0.0   \n",
       "12657  1.0  1.1  2.6   6.9  2002.0     0.0     0.0   0.0   \n",
       "12658  0.6  1.0  2.6   6.6  2003.0     0.0     0.0   0.0   \n",
       "12659  0.7  0.8  2.2   5.8  2005.0     0.0     0.0   0.0   \n",
       "12660  0.7  0.8  2.0   4.7  2006.0     0.0     0.0   0.0   \n",
       "\n",
       "                        Team  \n",
       "0         Los Angeles Lakers  \n",
       "1         Los Angeles Lakers  \n",
       "2               Pheonix Suns  \n",
       "3               Pheonix Suns  \n",
       "4               Pheonix Suns  \n",
       "...                      ...  \n",
       "12656  Golden State Warriors  \n",
       "12657        Detroit Pistons  \n",
       "12658        Detroit Pistons  \n",
       "12659   Los Angeles Clippers  \n",
       "12660   Los Angeles Clippers  \n",
       "\n",
       "[12661 rows x 34 columns]"
      ]
     },
     "execution_count": 430,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 431,
   "id": "77a17179-0662-4953-9632-c83d6e563b42",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "nicknames = {}\n",
    "\n",
    "with open(\"nicknames.csv\") as f:\n",
    "    lines = f.readlines()\n",
    "    for line in lines[1:]:\n",
    "        name, abbrev = line.replace(\"\\n\", \"\").split(\",\")\n",
    "        nicknames[abbrev] = name\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "949edb53-e4bf-4062-8ff3-32ae9e671909",
   "metadata": {},
   "outputs": [],
   "source": [
    "all_stats[\"Team\"] = all_stats[\"Tm\"].map(nicknames)\n",
    "all_stats[all_stats[\"Tm\"] == \"CHA\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 433,
   "id": "005fc829-7004-4dbf-9604-b21b83283733",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_nba_stat = all_stats.merge(teams, how=\"outer\", on = [\"Team\", \"Year\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 434,
   "id": "24d24b21-0136-4627-97c2-3482b4470a3b",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Player       43\n",
       "Pos          43\n",
       "Age          43\n",
       "Tm           43\n",
       "G            43\n",
       "GS           43\n",
       "MP           43\n",
       "FG           43\n",
       "FGA          43\n",
       "FG%          97\n",
       "3P           43\n",
       "3PA          43\n",
       "3P%        1847\n",
       "2P           43\n",
       "2PA          43\n",
       "2P%         137\n",
       "eFG%         97\n",
       "FT           43\n",
       "FTA          43\n",
       "FT%         515\n",
       "ORB          43\n",
       "DRB          43\n",
       "TRB          43\n",
       "AST          43\n",
       "STL          43\n",
       "BLK          43\n",
       "TOV          43\n",
       "PF           43\n",
       "PTS          43\n",
       "Year          0\n",
       "Pts Won      43\n",
       "Pts Max      43\n",
       "Share        43\n",
       "Team          0\n",
       "W           607\n",
       "L           607\n",
       "W/L%        607\n",
       "GB          607\n",
       "PS/G        607\n",
       "PA/G        607\n",
       "SRS         607\n",
       "dtype: int64"
      ]
     },
     "execution_count": 434,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_nba_stat.apply(pd.isnull).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 435,
   "id": "00405f78-b803-464b-8328-f6ac8ff8ce45",
   "metadata": {},
   "outputs": [],
   "source": [
    "#drop rows where the players are empty\n",
    "combined_nba_stat= combined_nba_stat.drop(combined_nba_stat[pd.isna(combined_nba_stat[\"Player\"])].index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 436,
   "id": "9d020998-1983-4e93-b919-2c786a2952d9",
   "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</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>MP</th>\n",
       "      <th>FG</th>\n",
       "      <th>FGA</th>\n",
       "      <th>FG%</th>\n",
       "      <th>...</th>\n",
       "      <th>Pts Max</th>\n",
       "      <th>Share</th>\n",
       "      <th>Team</th>\n",
       "      <th>W</th>\n",
       "      <th>L</th>\n",
       "      <th>W/L%</th>\n",
       "      <th>GB</th>\n",
       "      <th>PS/G</th>\n",
       "      <th>PA/G</th>\n",
       "      <th>SRS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A.C. Green</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>21</td>\n",
       "      <td>26.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.6</td>\n",
       "      <td>.476</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>.524</td>\n",
       "      <td>14.0</td>\n",
       "      <td>100.4</td>\n",
       "      <td>101.5</td>\n",
       "      <td>-0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Byron Scott</td>\n",
       "      <td>SG</td>\n",
       "      <td>29</td>\n",
       "      <td>LAL</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>32.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>12.8</td>\n",
       "      <td>.477</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>.524</td>\n",
       "      <td>14.0</td>\n",
       "      <td>100.4</td>\n",
       "      <td>101.5</td>\n",
       "      <td>-0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Elden Campbell</td>\n",
       "      <td>PF</td>\n",
       "      <td>22</td>\n",
       "      <td>LAL</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>7.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>.455</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>.524</td>\n",
       "      <td>14.0</td>\n",
       "      <td>100.4</td>\n",
       "      <td>101.5</td>\n",
       "      <td>-0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Irving Thomas</td>\n",
       "      <td>PF</td>\n",
       "      <td>25</td>\n",
       "      <td>LAL</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.9</td>\n",
       "      <td>.340</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>.524</td>\n",
       "      <td>14.0</td>\n",
       "      <td>100.4</td>\n",
       "      <td>101.5</td>\n",
       "      <td>-0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>James Worthy</td>\n",
       "      <td>SF</td>\n",
       "      <td>29</td>\n",
       "      <td>LAL</td>\n",
       "      <td>78</td>\n",
       "      <td>74</td>\n",
       "      <td>38.6</td>\n",
       "      <td>9.2</td>\n",
       "      <td>18.7</td>\n",
       "      <td>.492</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>.524</td>\n",
       "      <td>14.0</td>\n",
       "      <td>100.4</td>\n",
       "      <td>101.5</td>\n",
       "      <td>-0.95</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12656</th>\n",
       "      <td>Jordan McLaughlin</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>MIN</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>19.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>5.9</td>\n",
       "      <td>.489</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "      <td>19</td>\n",
       "      <td>45</td>\n",
       "      <td>.297</td>\n",
       "      <td>22.5</td>\n",
       "      <td>113.3</td>\n",
       "      <td>117.5</td>\n",
       "      <td>-4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12657</th>\n",
       "      <td>Josh Okogie</td>\n",
       "      <td>SG</td>\n",
       "      <td>21</td>\n",
       "      <td>MIN</td>\n",
       "      <td>62</td>\n",
       "      <td>28</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>6.4</td>\n",
       "      <td>.427</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "      <td>19</td>\n",
       "      <td>45</td>\n",
       "      <td>.297</td>\n",
       "      <td>22.5</td>\n",
       "      <td>113.3</td>\n",
       "      <td>117.5</td>\n",
       "      <td>-4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12658</th>\n",
       "      <td>Karl-Anthony Towns</td>\n",
       "      <td>C</td>\n",
       "      <td>24</td>\n",
       "      <td>MIN</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>33.9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>17.8</td>\n",
       "      <td>.508</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "      <td>19</td>\n",
       "      <td>45</td>\n",
       "      <td>.297</td>\n",
       "      <td>22.5</td>\n",
       "      <td>113.3</td>\n",
       "      <td>117.5</td>\n",
       "      <td>-4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12659</th>\n",
       "      <td>Kelan Martin</td>\n",
       "      <td>SF</td>\n",
       "      <td>24</td>\n",
       "      <td>MIN</td>\n",
       "      <td>31</td>\n",
       "      <td>4</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>5.8</td>\n",
       "      <td>.392</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "      <td>19</td>\n",
       "      <td>45</td>\n",
       "      <td>.297</td>\n",
       "      <td>22.5</td>\n",
       "      <td>113.3</td>\n",
       "      <td>117.5</td>\n",
       "      <td>-4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12660</th>\n",
       "      <td>Naz Reid</td>\n",
       "      <td>C</td>\n",
       "      <td>20</td>\n",
       "      <td>MIN</td>\n",
       "      <td>30</td>\n",
       "      <td>11</td>\n",
       "      <td>16.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>8.1</td>\n",
       "      <td>.412</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "      <td>19</td>\n",
       "      <td>45</td>\n",
       "      <td>.297</td>\n",
       "      <td>22.5</td>\n",
       "      <td>113.3</td>\n",
       "      <td>117.5</td>\n",
       "      <td>-4.02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12661 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Player Pos Age   Tm   G  GS    MP   FG   FGA   FG%  ...  \\\n",
       "0              A.C. Green  PF  27  LAL  82  21  26.4  3.1   6.6  .476  ...   \n",
       "1             Byron Scott  SG  29  LAL  82  82  32.1  6.1  12.8  .477  ...   \n",
       "2          Elden Campbell  PF  22  LAL  52   0   7.3  1.1   2.4  .455  ...   \n",
       "3           Irving Thomas  PF  25  LAL  26   0   4.2  0.7   1.9  .340  ...   \n",
       "4            James Worthy  SF  29  LAL  78  74  38.6  9.2  18.7  .492  ...   \n",
       "...                   ...  ..  ..  ...  ..  ..   ...  ...   ...   ...  ...   \n",
       "12656   Jordan McLaughlin  PG  23  MIN  30   2  19.7  2.9   5.9  .489  ...   \n",
       "12657         Josh Okogie  SG  21  MIN  62  28  25.0  2.7   6.4  .427  ...   \n",
       "12658  Karl-Anthony Towns   C  24  MIN  35  35  33.9  9.0  17.8  .508  ...   \n",
       "12659        Kelan Martin  SF  24  MIN  31   4  16.0  2.3   5.8  .392  ...   \n",
       "12660            Naz Reid   C  20  MIN  30  11  16.5  3.3   8.1  .412  ...   \n",
       "\n",
       "      Pts Max Share                    Team   W   L  W/L%    GB   PS/G   PA/G  \\\n",
       "0         0.0   0.0      Los Angeles Lakers  43  39  .524  14.0  100.4  101.5   \n",
       "1         0.0   0.0      Los Angeles Lakers  43  39  .524  14.0  100.4  101.5   \n",
       "2         0.0   0.0      Los Angeles Lakers  43  39  .524  14.0  100.4  101.5   \n",
       "3         0.0   0.0      Los Angeles Lakers  43  39  .524  14.0  100.4  101.5   \n",
       "4         0.0   0.0      Los Angeles Lakers  43  39  .524  14.0  100.4  101.5   \n",
       "...       ...   ...                     ...  ..  ..   ...   ...    ...    ...   \n",
       "12656     0.0   0.0  Minnesota Timberwolves  19  45  .297  22.5  113.3  117.5   \n",
       "12657     0.0   0.0  Minnesota Timberwolves  19  45  .297  22.5  113.3  117.5   \n",
       "12658     0.0   0.0  Minnesota Timberwolves  19  45  .297  22.5  113.3  117.5   \n",
       "12659     0.0   0.0  Minnesota Timberwolves  19  45  .297  22.5  113.3  117.5   \n",
       "12660     0.0   0.0  Minnesota Timberwolves  19  45  .297  22.5  113.3  117.5   \n",
       "\n",
       "         SRS  \n",
       "0      -0.95  \n",
       "1      -0.95  \n",
       "2      -0.95  \n",
       "3      -0.95  \n",
       "4      -0.95  \n",
       "...      ...  \n",
       "12656  -4.02  \n",
       "12657  -4.02  \n",
       "12658  -4.02  \n",
       "12659  -4.02  \n",
       "12660  -4.02  \n",
       "\n",
       "[12661 rows x 41 columns]"
      ]
     },
     "execution_count": 436,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_nba_stat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 441,
   "id": "848b668b-5f74-4e3e-91ae-5f1ea20fb767",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Player      object\n",
       "Pos         object\n",
       "Age          int64\n",
       "Tm          object\n",
       "G            int64\n",
       "GS           int64\n",
       "MP         float64\n",
       "FG         float64\n",
       "FGA        float64\n",
       "FG%        float64\n",
       "3P         float64\n",
       "3PA        float64\n",
       "3P%        float64\n",
       "2P         float64\n",
       "2PA        float64\n",
       "2P%        float64\n",
       "eFG%       float64\n",
       "FT         float64\n",
       "FTA        float64\n",
       "FT%        float64\n",
       "ORB        float64\n",
       "DRB        float64\n",
       "TRB        float64\n",
       "AST        float64\n",
       "STL        float64\n",
       "BLK        float64\n",
       "TOV        float64\n",
       "PF         float64\n",
       "PTS        float64\n",
       "Year       float64\n",
       "Pts Won    float64\n",
       "Pts Max    float64\n",
       "Share      float64\n",
       "Team        object\n",
       "W          float64\n",
       "L          float64\n",
       "W/L%       float64\n",
       "GB         float64\n",
       "PS/G       float64\n",
       "PA/G       float64\n",
       "SRS        float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 441,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_nba_stat.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 444,
   "id": "5d3e695d-76fa-4cb0-b362-50778f90afa6",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_nba_stat = combined_nba_stat.apply(pd.to_numeric, errors = \"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 446,
   "id": "9a3372f9-fcdb-44a1-9777-68773ae62cc8",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_nba_stat[[\"FG%\", \"3P%\", \"FT%\"]] = combined_nba_stat[[\"FG%\", \"3P%\", \"FT%\"]].fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 448,
   "id": "6ec9101a-c07e-4e30-9eb8-5214d64e62b6",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Player       0\n",
       "Pos          0\n",
       "Age          0\n",
       "Tm           0\n",
       "G            0\n",
       "GS           0\n",
       "MP           0\n",
       "FG           0\n",
       "FGA          0\n",
       "FG%          0\n",
       "3P           0\n",
       "3PA          0\n",
       "3P%          0\n",
       "2P           0\n",
       "2PA          0\n",
       "2P%         94\n",
       "eFG%        54\n",
       "FT           0\n",
       "FTA          0\n",
       "FT%          0\n",
       "ORB          0\n",
       "DRB          0\n",
       "TRB          0\n",
       "AST          0\n",
       "STL          0\n",
       "BLK          0\n",
       "TOV          0\n",
       "PF           0\n",
       "PTS          0\n",
       "Year         0\n",
       "Pts Won      0\n",
       "Pts Max      0\n",
       "Share        0\n",
       "Team         0\n",
       "W          607\n",
       "L          607\n",
       "W/L%       607\n",
       "GB         607\n",
       "PS/G       607\n",
       "PA/G       607\n",
       "SRS        607\n",
       "dtype: int64"
      ]
     },
     "execution_count": 448,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_nba_stat.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 449,
   "id": "4d53d4b3-1dcf-4ff9-a90d-bdc8029538a2",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_nba_stat= combined_nba_stat.drop(combined_nba_stat[pd.isna(combined_nba_stat[\"W\"])].index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 451,
   "id": "5dd9439e-672e-425c-a911-2679ae5c215d",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_nba_stat.index = range(combined_nba_stat.shape[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 453,
   "id": "9d373b21-25d2-452d-84ad-6349e12a2a7c",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_nba_stat.to_csv(\"combined_nba_stats.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8695f3b3-efb2-4262-a5c1-f089eb50df75",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "62107a83-d50d-414b-9d8a-1930a0721a8d",
   "metadata": {},
   "source": [
    "HANDLING NICKNAMES DATA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 454,
   "id": "d5fd9efb-8f08-4d83-9dd6-e419723504b2",
   "metadata": {},
   "outputs": [],
   "source": [
    "nicknamess = pd.read_csv(\"nicknames.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 455,
   "id": "1658225c-3c81-4726-a473-eea81573b4e3",
   "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>Franchise</th>\n",
       "      <th>short</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Atlanta Hawks</td>\n",
       "      <td>ATL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Boston Celtics</td>\n",
       "      <td>BOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Brooklyn Nets</td>\n",
       "      <td>BKN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Charlotte Hornets</td>\n",
       "      <td>CHA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chicago Bulls</td>\n",
       "      <td>CHI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Cleveland Cavaliers</td>\n",
       "      <td>CLE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Dallas Mavericks</td>\n",
       "      <td>DAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Denver Nuggets</td>\n",
       "      <td>DEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Detroit Pistons</td>\n",
       "      <td>DET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Golden State Warriors</td>\n",
       "      <td>GSW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Houston Rockets</td>\n",
       "      <td>HOU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Indiana Pacers</td>\n",
       "      <td>IND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Los Angeles Clippers</td>\n",
       "      <td>LAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>LAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Memphis Grizzlies</td>\n",
       "      <td>MEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Miami Heat</td>\n",
       "      <td>MIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Milwaukee Bucks</td>\n",
       "      <td>MIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "      <td>MIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>New Orleans Pelicans</td>\n",
       "      <td>NOP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>New York Knicks</td>\n",
       "      <td>NYK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Oklahoma City Thunder</td>\n",
       "      <td>OKC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Orlando Magic</td>\n",
       "      <td>ORL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Philadelphia 76ers</td>\n",
       "      <td>PHI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Phoenix Suns</td>\n",
       "      <td>PHX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Portland Trail Blazers</td>\n",
       "      <td>POR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Sacramento Kings</td>\n",
       "      <td>SAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>San Antonio Spurs</td>\n",
       "      <td>SAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Toronto Raptors</td>\n",
       "      <td>TOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Utah Jazz</td>\n",
       "      <td>UTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Washington Wizards</td>\n",
       "      <td>WAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Brookyln Nets</td>\n",
       "      <td>BRK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Charlotte Hornets</td>\n",
       "      <td>CHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Charlotte Hornets</td>\n",
       "      <td>CHO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Charlotte Bobcats</td>\n",
       "      <td>CHA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>New Jersey Nets</td>\n",
       "      <td>NJN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>New Orleans Hornets</td>\n",
       "      <td>NOH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Seattle SuperSonics</td>\n",
       "      <td>SEA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>New Orleans Oklahoma</td>\n",
       "      <td>NOK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Pheonix Suns</td>\n",
       "      <td>PHO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Vancouver Grizzlies</td>\n",
       "      <td>VAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Washington Bullets</td>\n",
       "      <td>WSB</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Franchise short\n",
       "0            Atlanta Hawks   ATL\n",
       "1           Boston Celtics   BOS\n",
       "2            Brooklyn Nets   BKN\n",
       "3        Charlotte Hornets   CHA\n",
       "4            Chicago Bulls   CHI\n",
       "5      Cleveland Cavaliers   CLE\n",
       "6         Dallas Mavericks   DAL\n",
       "7           Denver Nuggets   DEN\n",
       "8          Detroit Pistons   DET\n",
       "9    Golden State Warriors   GSW\n",
       "10         Houston Rockets   HOU\n",
       "11          Indiana Pacers   IND\n",
       "12    Los Angeles Clippers   LAC\n",
       "13      Los Angeles Lakers   LAL\n",
       "14       Memphis Grizzlies   MEM\n",
       "15              Miami Heat   MIA\n",
       "16         Milwaukee Bucks   MIL\n",
       "17  Minnesota Timberwolves   MIN\n",
       "18    New Orleans Pelicans   NOP\n",
       "19         New York Knicks   NYK\n",
       "20   Oklahoma City Thunder   OKC\n",
       "21           Orlando Magic   ORL\n",
       "22      Philadelphia 76ers   PHI\n",
       "23            Phoenix Suns   PHX\n",
       "24  Portland Trail Blazers   POR\n",
       "25        Sacramento Kings   SAC\n",
       "26       San Antonio Spurs   SAS\n",
       "27         Toronto Raptors   TOR\n",
       "28               Utah Jazz   UTA\n",
       "29      Washington Wizards   WAS\n",
       "30           Brookyln Nets   BRK\n",
       "31       Charlotte Hornets   CHH\n",
       "32       Charlotte Hornets   CHO\n",
       "33       Charlotte Bobcats   CHA\n",
       "34         New Jersey Nets   NJN\n",
       "35     New Orleans Hornets   NOH\n",
       "36     Seattle SuperSonics   SEA\n",
       "37    New Orleans Oklahoma   NOK\n",
       "38            Pheonix Suns   PHO\n",
       "39     Vancouver Grizzlies   VAN\n",
       "40      Washington Bullets   WSB"
      ]
     },
     "execution_count": 455,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#charlotte hornets(CHA) is wrong \n",
    "nicknamess\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "id": "74b723e5-6821-4665-bbb3-0a0325305a78",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_names = pd.DataFrame(\n",
    "    {'Franchise': [\"Brookyln Nets\", \"Charlotte Hornets\", \"Charlotte Hornets\",\"Charlotte Bobcats\", \"New Jersey Nets\",\"New Orleans Hornets\",\"Seattle SuperSonics\", \"New Orleans Oklahoma\",\"Pheonix Suns\", \"Vancouver Grizzlies\",\"Washington Bullets\"], \n",
    "     'short': [\"BRK\",\"CHH\",\"CHO\", \"CHA\", \"NJN\",\"NOH\", \"SEA\", \"NOK\", \"PHO\", \"VAN\", \"WSB\"]})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "13af8367-ad82-4aab-a47c-5cd11940c23c",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "new_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9630cd62-bd50-4505-9114-57145eb07513",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "nicknames = pd.concat([nick, new_names], ignore_index=True)\n",
    "nicknames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "id": "dcf3f692-b1a2-49ec-8aa5-3fdb0da42da3",
   "metadata": {},
   "outputs": [],
   "source": [
    "nicknames.to_csv(\"nicknames.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "89843b12-0e0a-4e07-b36d-0bcb0993a75c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "6ef93857-c0d5-4f2f-87f2-7a854ea22316",
   "metadata": {},
   "source": [
    "DEALING WITH NAN AND FILL-NA VALUES"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 463,
   "id": "3a005645-06c1-40a6-b4fe-25ab71d29a69",
   "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>Franchise</th>\n",
       "      <th>short</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Atlanta Hawks</td>\n",
       "      <td>ATL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Boston Celtics</td>\n",
       "      <td>BOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Brooklyn Nets</td>\n",
       "      <td>BKN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chicago Bulls</td>\n",
       "      <td>CHI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Cleveland Cavaliers</td>\n",
       "      <td>CLE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Dallas Mavericks</td>\n",
       "      <td>DAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Denver Nuggets</td>\n",
       "      <td>DEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Detroit Pistons</td>\n",
       "      <td>DET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Golden State Warriors</td>\n",
       "      <td>GSW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Houston Rockets</td>\n",
       "      <td>HOU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Indiana Pacers</td>\n",
       "      <td>IND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Los Angeles Clippers</td>\n",
       "      <td>LAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Los Angeles Lakers</td>\n",
       "      <td>LAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Memphis Grizzlies</td>\n",
       "      <td>MEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Miami Heat</td>\n",
       "      <td>MIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Milwaukee Bucks</td>\n",
       "      <td>MIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Minnesota Timberwolves</td>\n",
       "      <td>MIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>New Orleans Pelicans</td>\n",
       "      <td>NOP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>New York Knicks</td>\n",
       "      <td>NYK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Oklahoma City Thunder</td>\n",
       "      <td>OKC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Orlando Magic</td>\n",
       "      <td>ORL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Philadelphia 76ers</td>\n",
       "      <td>PHI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Phoenix Suns</td>\n",
       "      <td>PHX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Portland Trail Blazers</td>\n",
       "      <td>POR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Sacramento Kings</td>\n",
       "      <td>SAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>San Antonio Spurs</td>\n",
       "      <td>SAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Toronto Raptors</td>\n",
       "      <td>TOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Utah Jazz</td>\n",
       "      <td>UTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Washington Wizards</td>\n",
       "      <td>WAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Brookyln Nets</td>\n",
       "      <td>BRK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Charlotte Hornets</td>\n",
       "      <td>CHH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Charlotte Hornets</td>\n",
       "      <td>CHO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>New Jersey Nets</td>\n",
       "      <td>NJN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>New Orleans Hornets</td>\n",
       "      <td>NOH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Seattle SuperSonics</td>\n",
       "      <td>SEA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>New Orleans Oklahoma</td>\n",
       "      <td>NOK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Pheonix Suns</td>\n",
       "      <td>PHO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Vancouver Grizzlies</td>\n",
       "      <td>VAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Washington Bullets</td>\n",
       "      <td>WSB</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Franchise short\n",
       "0            Atlanta Hawks   ATL\n",
       "1           Boston Celtics   BOS\n",
       "2            Brooklyn Nets   BKN\n",
       "4            Chicago Bulls   CHI\n",
       "5      Cleveland Cavaliers   CLE\n",
       "6         Dallas Mavericks   DAL\n",
       "7           Denver Nuggets   DEN\n",
       "8          Detroit Pistons   DET\n",
       "9    Golden State Warriors   GSW\n",
       "10         Houston Rockets   HOU\n",
       "11          Indiana Pacers   IND\n",
       "12    Los Angeles Clippers   LAC\n",
       "13      Los Angeles Lakers   LAL\n",
       "14       Memphis Grizzlies   MEM\n",
       "15              Miami Heat   MIA\n",
       "16         Milwaukee Bucks   MIL\n",
       "17  Minnesota Timberwolves   MIN\n",
       "18    New Orleans Pelicans   NOP\n",
       "19         New York Knicks   NYK\n",
       "20   Oklahoma City Thunder   OKC\n",
       "21           Orlando Magic   ORL\n",
       "22      Philadelphia 76ers   PHI\n",
       "23            Phoenix Suns   PHX\n",
       "24  Portland Trail Blazers   POR\n",
       "25        Sacramento Kings   SAC\n",
       "26       San Antonio Spurs   SAS\n",
       "27         Toronto Raptors   TOR\n",
       "28               Utah Jazz   UTA\n",
       "29      Washington Wizards   WAS\n",
       "30           Brookyln Nets   BRK\n",
       "31       Charlotte Hornets   CHH\n",
       "32       Charlotte Hornets   CHO\n",
       "34         New Jersey Nets   NJN\n",
       "35     New Orleans Hornets   NOH\n",
       "36     Seattle SuperSonics   SEA\n",
       "37    New Orleans Oklahoma   NOK\n",
       "38            Pheonix Suns   PHO\n",
       "39     Vancouver Grizzlies   VAN\n",
       "40      Washington Bullets   WSB"
      ]
     },
     "execution_count": 463,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#the row was dropped and carefully added back to the dataframea\n",
    "nicknamess.drop(nicknamess[nicknamess[\"short\"] == \"CHA\"].index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 466,
   "id": "0481755d-2899-4a54-a77d-f08ce5655c09",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     ATL\n",
       "1     BOS\n",
       "2     BKN\n",
       "3     CHA\n",
       "4     CHI\n",
       "5     CLE\n",
       "6     DAL\n",
       "7     DEN\n",
       "8     DET\n",
       "9     GSW\n",
       "10    HOU\n",
       "11    IND\n",
       "12    LAC\n",
       "13    LAL\n",
       "14    MEM\n",
       "15    MIA\n",
       "16    MIL\n",
       "17    MIN\n",
       "18    NOP\n",
       "19    NYK\n",
       "20    OKC\n",
       "21    ORL\n",
       "22    PHI\n",
       "23    PHX\n",
       "24    POR\n",
       "25    SAC\n",
       "26    SAS\n",
       "27    TOR\n",
       "28    UTA\n",
       "29    WAS\n",
       "30    BRK\n",
       "31    CHH\n",
       "32    CHO\n",
       "33    CHA\n",
       "34    NJN\n",
       "35    NOH\n",
       "36    SEA\n",
       "37    NOK\n",
       "38    PHO\n",
       "39    VAN\n",
       "40    WSB\n",
       "Name: short, dtype: object"
      ]
     },
     "execution_count": 466,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nicknamess['short'].str.slice(stop=3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "29928464-c025-442c-97b9-c8e1acaf2ebb",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}