Merging Player + Team Stats (Step 2).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d1db86b5",
   "metadata": {},
   "outputs": [],
   "source": [
    "%reset -fs\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.model_selection import train_test_split\n",
    "import pandas_profiling as pp\n",
    "from fuzzywuzzy import fuzz\n",
    "from fuzzywuzzy import process"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "407c2240",
   "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>Date</th>\n",
       "      <th>Name</th>\n",
       "      <th>Team</th>\n",
       "      <th>Position</th>\n",
       "      <th>Opp</th>\n",
       "      <th>Home/Away</th>\n",
       "      <th>Line</th>\n",
       "      <th>Moneyline</th>\n",
       "      <th>Projection</th>\n",
       "      <th>Diff</th>\n",
       "      <th>Pick</th>\n",
       "      <th>Result</th>\n",
       "      <th>over_under</th>\n",
       "      <th>seven_day_accuracy</th>\n",
       "      <th>successful_pick</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-10-21</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>DAL</td>\n",
       "      <td>vs.</td>\n",
       "      <td>15.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>16.57</td>\n",
       "      <td>1.07</td>\n",
       "      <td>15.5</td>\n",
       "      <td>11.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.47</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-10-23</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>CLE</td>\n",
       "      <td>@</td>\n",
       "      <td>14.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>15.29</td>\n",
       "      <td>0.79</td>\n",
       "      <td>14.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-10-25</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>DET</td>\n",
       "      <td>vs.</td>\n",
       "      <td>15.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>12.85</td>\n",
       "      <td>-2.65</td>\n",
       "      <td>15.5</td>\n",
       "      <td>14.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-10-27</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>NOR</td>\n",
       "      <td>@</td>\n",
       "      <td>12.5</td>\n",
       "      <td>-125</td>\n",
       "      <td>13.70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>12.5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-10-28</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>WAS</td>\n",
       "      <td>@</td>\n",
       "      <td>12.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>16.72</td>\n",
       "      <td>4.22</td>\n",
       "      <td>12.5</td>\n",
       "      <td>14.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9386</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>CHI</td>\n",
       "      <td>vs.</td>\n",
       "      <td>8.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>6.11</td>\n",
       "      <td>-2.39</td>\n",
       "      <td>8.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.58</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9387</th>\n",
       "      <td>2022-01-19</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>MIL</td>\n",
       "      <td>@</td>\n",
       "      <td>9.5</td>\n",
       "      <td>-103</td>\n",
       "      <td>8.70</td>\n",
       "      <td>-0.80</td>\n",
       "      <td>9.5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9388</th>\n",
       "      <td>2022-01-21</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>DEN</td>\n",
       "      <td>@</td>\n",
       "      <td>9.5</td>\n",
       "      <td>100</td>\n",
       "      <td>8.90</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>9.5</td>\n",
       "      <td>17.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9389</th>\n",
       "      <td>2022-01-23</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>DAL</td>\n",
       "      <td>@</td>\n",
       "      <td>10.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>8.60</td>\n",
       "      <td>-1.90</td>\n",
       "      <td>10.5</td>\n",
       "      <td>9.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9390</th>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>SAS</td>\n",
       "      <td>@</td>\n",
       "      <td>10.5</td>\n",
       "      <td>-132</td>\n",
       "      <td>8.20</td>\n",
       "      <td>-2.30</td>\n",
       "      <td>10.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>u</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9391 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date             Name Team Position  Opp Home/Away  Line  \\\n",
       "0     2021-10-21           Bogdan  ATL        G  DAL       vs.  15.5   \n",
       "1     2021-10-23           Bogdan  ATL        G  CLE         @  14.5   \n",
       "2     2021-10-25           Bogdan  ATL        G  DET       vs.  15.5   \n",
       "3     2021-10-27           Bogdan  ATL        G  NOR         @  12.5   \n",
       "4     2021-10-28           Bogdan  ATL        G  WAS         @  12.5   \n",
       "...          ...              ...  ...      ...  ...       ...   ...   \n",
       "9386  2022-01-17  Ziaire Williams  MEM        G  CHI       vs.   8.5   \n",
       "9387  2022-01-19  Ziaire Williams  MEM        G  MIL         @   9.5   \n",
       "9388  2022-01-21  Ziaire Williams  MEM        G  DEN         @   9.5   \n",
       "9389  2022-01-23  Ziaire Williams  MEM        G  DAL         @  10.5   \n",
       "9390  2022-01-26  Ziaire Williams  MEM        G  SAS         @  10.5   \n",
       "\n",
       "      Moneyline  Projection  Diff  Pick  Result over_under  \\\n",
       "0          -115       16.57  1.07  15.5    11.0          o   \n",
       "1          -115       15.29  0.79  14.5     5.0          o   \n",
       "2          -115       12.85 -2.65  15.5    14.0          u   \n",
       "3          -125       13.70  1.20  12.5    12.0          o   \n",
       "4          -105       16.72  4.22  12.5    14.0          o   \n",
       "...         ...         ...   ...   ...     ...        ...   \n",
       "9386       -105        6.11 -2.39   8.5     2.0          u   \n",
       "9387       -103        8.70 -0.80   9.5    10.0          u   \n",
       "9388        100        8.90 -0.60   9.5    17.0          u   \n",
       "9389       -105        8.60 -1.90  10.5     9.0          u   \n",
       "9390       -132        8.20 -2.30  10.5     NaN          u   \n",
       "\n",
       "      seven_day_accuracy  successful_pick  \n",
       "0                   0.47                0  \n",
       "1                   0.45                0  \n",
       "2                   0.45                1  \n",
       "3                   0.45                0  \n",
       "4                   0.42                1  \n",
       "...                  ...              ...  \n",
       "9386                0.58                1  \n",
       "9387                0.62                0  \n",
       "9388                0.59                0  \n",
       "9389                0.55                1  \n",
       "9390                0.43                0  \n",
       "\n",
       "[9391 rows x 15 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bet_df = pd.read_csv('betting_data.csv', index_col=0);bet_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "97ce372e",
   "metadata": {},
   "outputs": [],
   "source": [
    "bet_df.Date = pd.to_datetime(bet_df.Date, infer_datetime_format=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "fa72b90a",
   "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>Age</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Tm</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Opp</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Date</th>\n",
       "      <th>GS</th>\n",
       "      <th>MP</th>\n",
       "      <th>...</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>GmSc</th>\n",
       "      <th>BPM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rk</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>1</th>\n",
       "      <td>LaMarcus Aldridge\\aldrila01</td>\n",
       "      <td>36-092</td>\n",
       "      <td>F-C</td>\n",
       "      <td>BRK</td>\n",
       "      <td>@</td>\n",
       "      <td>MIL</td>\n",
       "      <td>L</td>\n",
       "      <td>2021-10-19</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>-15.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Grayson Allen\\allengr01</td>\n",
       "      <td>26-011</td>\n",
       "      <td>G</td>\n",
       "      <td>MIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRK</td>\n",
       "      <td>W</td>\n",
       "      <td>2021-10-19</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>11.6</td>\n",
       "      <td>6.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Giannis Antetokounmpo\\antetgi01</td>\n",
       "      <td>26-317</td>\n",
       "      <td>F-G</td>\n",
       "      <td>MIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRK</td>\n",
       "      <td>W</td>\n",
       "      <td>2021-10-19</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>32</td>\n",
       "      <td>26.4</td>\n",
       "      <td>11.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Thanasis Antetokounmpo\\antetth01</td>\n",
       "      <td>29-093</td>\n",
       "      <td>F</td>\n",
       "      <td>MIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRK</td>\n",
       "      <td>W</td>\n",
       "      <td>2021-10-19</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>7.3</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Carmelo Anthony\\anthoca01</td>\n",
       "      <td>37-143</td>\n",
       "      <td>F</td>\n",
       "      <td>LAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GSW</td>\n",
       "      <td>L</td>\n",
       "      <td>2021-10-19</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>4.3</td>\n",
       "      <td>-3.2</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>15495</th>\n",
       "      <td>Robert Woodard II\\woodaro01</td>\n",
       "      <td>22-126</td>\n",
       "      <td>F</td>\n",
       "      <td>SAC</td>\n",
       "      <td>@</td>\n",
       "      <td>ATL</td>\n",
       "      <td>L</td>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-11.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15496</th>\n",
       "      <td>Delon Wright\\wrighde01</td>\n",
       "      <td>29-275</td>\n",
       "      <td>G</td>\n",
       "      <td>ATL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SAC</td>\n",
       "      <td>W</td>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>5.6</td>\n",
       "      <td>-4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15497</th>\n",
       "      <td>Trae Young\\youngtr01</td>\n",
       "      <td>23-129</td>\n",
       "      <td>G</td>\n",
       "      <td>ATL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SAC</td>\n",
       "      <td>W</td>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>15.5</td>\n",
       "      <td>7.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15498</th>\n",
       "      <td>Omer Yurtseven\\yurtsom01</td>\n",
       "      <td>23-221</td>\n",
       "      <td>C</td>\n",
       "      <td>MIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NYK</td>\n",
       "      <td>W</td>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15499</th>\n",
       "      <td>Ivica Zubac\\zubaciv01</td>\n",
       "      <td>24-314</td>\n",
       "      <td>C</td>\n",
       "      <td>LAC</td>\n",
       "      <td>@</td>\n",
       "      <td>ORL</td>\n",
       "      <td>W</td>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>3.5</td>\n",
       "      <td>-8.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15498 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Player     Age  Pos   Tm Unnamed: 5  Opp  \\\n",
       "Rk                                                                          \n",
       "1           LaMarcus Aldridge\\aldrila01  36-092  F-C  BRK          @  MIL   \n",
       "2               Grayson Allen\\allengr01  26-011    G  MIL        NaN  BRK   \n",
       "3       Giannis Antetokounmpo\\antetgi01  26-317  F-G  MIL        NaN  BRK   \n",
       "4      Thanasis Antetokounmpo\\antetth01  29-093    F  MIL        NaN  BRK   \n",
       "5             Carmelo Anthony\\anthoca01  37-143    F  LAL        NaN  GSW   \n",
       "...                                 ...     ...  ...  ...        ...  ...   \n",
       "15495       Robert Woodard II\\woodaro01  22-126    F  SAC          @  ATL   \n",
       "15496            Delon Wright\\wrighde01  29-275    G  ATL        NaN  SAC   \n",
       "15497              Trae Young\\youngtr01  23-129    G  ATL        NaN  SAC   \n",
       "15498          Omer Yurtseven\\yurtsom01  23-221    C  MIA        NaN  NYK   \n",
       "15499             Ivica Zubac\\zubaciv01  24-314    C  LAC          @  ORL   \n",
       "\n",
       "      Unnamed: 7        Date  GS  MP  ...  DRB  TRB  AST  STL  BLK  TOV  PF  \\\n",
       "Rk                                    ...                                     \n",
       "1              L  2021-10-19   0  16  ...    3    3    1    0    1    1   2   \n",
       "2              W  2021-10-19   1  28  ...    4    4    6    2    0    0   0   \n",
       "3              W  2021-10-19   1  31  ...    9   14    7    1    2    4   4   \n",
       "4              W  2021-10-19   0  12  ...    3    4    1    0    1    0   1   \n",
       "5              L  2021-10-19   0  26  ...    4    4    2    0    0    1   2   \n",
       "...          ...         ...  ..  ..  ...  ...  ...  ...  ...  ...  ...  ..   \n",
       "15495          L  2022-01-26   0   4  ...    1    2    0    0    0    0   0   \n",
       "15496          W  2022-01-26   0  28  ...    2    2    1    1    0    0   1   \n",
       "15497          W  2022-01-26   1  25  ...    2    3   10    4    0    4   0   \n",
       "15498          W  2022-01-26   0   2  ...    0    0    0    0    0    0   1   \n",
       "15499          W  2022-01-26   1  22  ...    6    7    2    1    0    3   5   \n",
       "\n",
       "       PTS  GmSc   BPM  \n",
       "Rk                      \n",
       "1        1  -1.1 -15.2  \n",
       "2       10  11.6   6.4  \n",
       "3       32  26.4  11.4  \n",
       "4        6   7.3   8.0  \n",
       "5        9   4.3  -3.2  \n",
       "...    ...   ...   ...  \n",
       "15495    0   0.3 -11.9  \n",
       "15496    6   5.6  -4.5  \n",
       "15497   17  15.5   7.7  \n",
       "15498    2   1.3   3.5  \n",
       "15499    8   3.5  -8.7  \n",
       "\n",
       "[15498 rows x 34 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stat_df = pd.read_csv('stathead_data.csv', index_col=0); stat_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a087b45f",
   "metadata": {},
   "outputs": [],
   "source": [
    "stat_df.rename(columns={'Unnamed: 5': 'Home/Away', 'Unnamed: 7':'Game Result'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "42b0d6df",
   "metadata": {},
   "outputs": [],
   "source": [
    "stat_df['Home/Away'] = stat_df['Home/Away'].fillna('Home')\n",
    "stat_df['Home/Away'] = stat_df['Home/Away'].replace('@','Away')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "337f90bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "stat_df.Date = pd.to_datetime(stat_df.Date, infer_datetime_format=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "40c9c8d4",
   "metadata": {},
   "outputs": [],
   "source": [
    "players = stat_df.Player.str.split('\\\\', expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "a48c20fe",
   "metadata": {},
   "outputs": [],
   "source": [
    "stat_df.Player = players[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2e959f94",
   "metadata": {},
   "outputs": [],
   "source": [
    "stat_df = stat_df.sort_values(by=['Player', 'Date'], axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "971ea430",
   "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>Age</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Tm</th>\n",
       "      <th>Home/Away</th>\n",
       "      <th>Opp</th>\n",
       "      <th>Game Result</th>\n",
       "      <th>Date</th>\n",
       "      <th>GS</th>\n",
       "      <th>MP</th>\n",
       "      <th>...</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>GmSc</th>\n",
       "      <th>BPM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rk</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>124</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>26-034</td>\n",
       "      <td>F</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Away</td>\n",
       "      <td>PHO</td>\n",
       "      <td>W</td>\n",
       "      <td>2021-10-20</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>12.3</td>\n",
       "      <td>6.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>26-036</td>\n",
       "      <td>F</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Home</td>\n",
       "      <td>SAS</td>\n",
       "      <td>W</td>\n",
       "      <td>2021-10-22</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-8.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>959</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>26-039</td>\n",
       "      <td>F</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Home</td>\n",
       "      <td>CLE</td>\n",
       "      <td>L</td>\n",
       "      <td>2021-10-25</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>4.6</td>\n",
       "      <td>-6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1137</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>26-040</td>\n",
       "      <td>F</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Away</td>\n",
       "      <td>UTA</td>\n",
       "      <td>L</td>\n",
       "      <td>2021-10-26</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>20</td>\n",
       "      <td>12.6</td>\n",
       "      <td>-3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1611</th>\n",
       "      <td>Aaron Gordon</td>\n",
       "      <td>26-043</td>\n",
       "      <td>F</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Home</td>\n",
       "      <td>DAL</td>\n",
       "      <td>W</td>\n",
       "      <td>2021-10-29</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>11.3</td>\n",
       "      <td>8.3</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>14416</th>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>20-129</td>\n",
       "      <td>F</td>\n",
       "      <td>MEM</td>\n",
       "      <td>Away</td>\n",
       "      <td>MIL</td>\n",
       "      <td>L</td>\n",
       "      <td>2022-01-19</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>5.5</td>\n",
       "      <td>-6.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14701</th>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>20-131</td>\n",
       "      <td>F</td>\n",
       "      <td>MEM</td>\n",
       "      <td>Away</td>\n",
       "      <td>DEN</td>\n",
       "      <td>W</td>\n",
       "      <td>2022-01-21</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>16.4</td>\n",
       "      <td>8.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14998</th>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>20-133</td>\n",
       "      <td>F</td>\n",
       "      <td>MEM</td>\n",
       "      <td>Away</td>\n",
       "      <td>DAL</td>\n",
       "      <td>L</td>\n",
       "      <td>2022-01-23</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>-9.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15492</th>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>20-136</td>\n",
       "      <td>F</td>\n",
       "      <td>MEM</td>\n",
       "      <td>Away</td>\n",
       "      <td>SAS</td>\n",
       "      <td>W</td>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>6.4</td>\n",
       "      <td>-4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13098</th>\n",
       "      <td>Zylan Cheatham</td>\n",
       "      <td>26-056</td>\n",
       "      <td>F</td>\n",
       "      <td>UTA</td>\n",
       "      <td>Home</td>\n",
       "      <td>CLE</td>\n",
       "      <td>L</td>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>-30.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15498 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player     Age Pos   Tm Home/Away  Opp Game Result       Date  \\\n",
       "Rk                                                                              \n",
       "124       Aaron Gordon  26-034   F  DEN      Away  PHO           W 2021-10-20   \n",
       "435       Aaron Gordon  26-036   F  DEN      Home  SAS           W 2021-10-22   \n",
       "959       Aaron Gordon  26-039   F  DEN      Home  CLE           L 2021-10-25   \n",
       "1137      Aaron Gordon  26-040   F  DEN      Away  UTA           L 2021-10-26   \n",
       "1611      Aaron Gordon  26-043   F  DEN      Home  DAL           W 2021-10-29   \n",
       "...                ...     ...  ..  ...       ...  ...         ...        ...   \n",
       "14416  Ziaire Williams  20-129   F  MEM      Away  MIL           L 2022-01-19   \n",
       "14701  Ziaire Williams  20-131   F  MEM      Away  DEN           W 2022-01-21   \n",
       "14998  Ziaire Williams  20-133   F  MEM      Away  DAL           L 2022-01-23   \n",
       "15492  Ziaire Williams  20-136   F  MEM      Away  SAS           W 2022-01-26   \n",
       "13098   Zylan Cheatham  26-056   F  UTA      Home  CLE           L 2022-01-12   \n",
       "\n",
       "       GS  MP  ...  DRB  TRB  AST  STL  BLK  TOV  PF  PTS  GmSc   BPM  \n",
       "Rk             ...                                                     \n",
       "124     1  29  ...    6    8    4    0    1    3   2   12  12.3   6.1  \n",
       "435     1  30  ...    3    5    1    0    0    3   5    8   3.0  -8.1  \n",
       "959     1  28  ...    6    9    1    0    0    3   2   12   4.6  -6.5  \n",
       "1137    1  34  ...    6    7    1    1    1    4   5   20  12.6  -3.2  \n",
       "1611    1  24  ...    4    5    2    1    1    2   1   13  11.3   8.3  \n",
       "...    ..  ..  ...  ...  ...  ...  ...  ...  ...  ..  ...   ...   ...  \n",
       "14416   1  33  ...    1    1    1    1    0    0   1   10   5.5  -6.3  \n",
       "14701   1  31  ...    4    5    0    2    1    0   4   17  16.4   8.1  \n",
       "14998   1  23  ...    0    1    1    0    0    0   5    9   0.9  -9.6  \n",
       "15492   1  26  ...    3    3    2    1    0    2   3   11   6.4  -4.7  \n",
       "13098   0   5  ...    0    0    0    0    0    0   0    0  -2.1 -30.2  \n",
       "\n",
       "[15498 rows x 34 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stat_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "8d38c7e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "team_stat_df = pd.read_csv('teamstats.csv', index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "23b9b3c7",
   "metadata": {},
   "outputs": [],
   "source": [
    "team_stat_df.rename(columns={'Unnamed: 3': 'Home/Away'}, inplace=True)\n",
    "team_stat_df['Home/Away'] = team_stat_df['Home/Away'].fillna('Home')\n",
    "team_stat_df['Home/Away'] = team_stat_df['Home/Away'].replace('@','Away')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b86c1883",
   "metadata": {},
   "outputs": [],
   "source": [
    "team_stat_df['Date'] = pd.to_datetime(team_stat_df.Date, infer_datetime_format=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6c7fd940",
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df_1 = pd.merge(stat_df, team_stat_df,  how='left', left_on=['Date','Tm', 'Opp'], right_on = ['Date','Tm', 'Opp'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "5648a1ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df_1.to_csv('player_team_stats_merged.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "8440d623",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Aaron Gordon', 'Aaron Henry', 'Aaron Holiday', 'Aaron Nesmith',\n",
       "       'Aaron Wiggins', 'Abdel Nader', 'Ade Murkey', 'Admiral Schofield',\n",
       "       'Ahmad Caver', 'Al Horford', 'Alec Burks', 'Aleem Ford',\n",
       "       'Aleksej Pokusevski', 'Alex Caruso', 'Alex Len',\n",
       "       'Alfonzo McKinnie', 'Alize Johnson', 'Alperen Şengün',\n",
       "       'Amir Coffey', 'Andre Drummond', 'Andre Iguodala',\n",
       "       'Andrew Wiggins', 'Anfernee Simons', 'Anthony Davis',\n",
       "       'Anthony Edwards', 'Anthony Gill', 'Anthony Lamb', 'Armoni Brooks',\n",
       "       'Arnoldas Kulboka', 'Austin Reaves', 'Austin Rivers',\n",
       "       'Avery Bradley', 'Ayo Dosunmu', 'B.J. Johnson', 'Bam Adebayo',\n",
       "       'Ben McLemore', 'Bismack Biyombo', 'Blake Griffin',\n",
       "       'Boban Marjanović', 'Bobby Portis', 'Bogdan Bogdanović',\n",
       "       'Bojan Bogdanović', 'Bol Bol', 'Bones Hyland', 'Brad Wanamaker',\n",
       "       'Bradley Beal', 'Brandon Boston Jr.', 'Brandon Clarke',\n",
       "       'Brandon Goodwin', 'Brandon Ingram', 'Brandon Knight',\n",
       "       'Brandon Williams', 'Braxton Key', 'Brodric Thomas', 'Brook Lopez',\n",
       "       'Bruce Brown', 'Bruno Fernando', 'Bryn Forbes', 'Buddy Hield',\n",
       "       'C.J. Miles', 'CJ Elleby', 'CJ McCollum', 'Cade Cunningham',\n",
       "       'Caleb Martin', 'Cam Reddish', 'Cam Thomas', 'Cameron Johnson',\n",
       "       'Cameron McGriff', 'Cameron Oliver', 'Cameron Payne',\n",
       "       'Caris LeVert', 'Carlik Jones', 'Carmelo Anthony',\n",
       "       'Cassius Stanley', 'Cassius Winston', 'Cat Barber', 'Cedi Osman',\n",
       "       'Chandler Hutchison', 'Charles Bassey', 'Charlie Brown Jr.',\n",
       "       'Chaundee Brown Jr.', 'Cheick Diallo', 'Chimezie Metu',\n",
       "       'Chris Boucher', 'Chris Chiozza', 'Chris Duarte', 'Chris Paul',\n",
       "       'Chris Silva', 'Christian Wood', 'Chuma Okeke', 'Clint Capela',\n",
       "       'Coby White', 'Cody Martin', 'Cody Zeller', 'Cole Anthony',\n",
       "       'Collin Sexton', 'Corey Kispert', 'Cory Joseph', 'Craig Sword',\n",
       "       \"D'Angelo Russell\", 'D.J. Augustin', 'D.J. Wilson',\n",
       "       'DaQuan Jeffries', 'Daishen Nix', 'Dakota Mathias',\n",
       "       'Dalano Banton', 'Damian Jones', 'Damian Lillard', 'Damion Lee',\n",
       "       'Damyean Dotson', 'Daniel Gafford', 'Daniel Oturu', 'Daniel Theis',\n",
       "       'Danilo Gallinari', 'Danny Green', 'Danuel House Jr.',\n",
       "       'Darius Bazley', 'Darius Garland', 'Darren Collison',\n",
       "       'David Duke Jr.', 'David Johnson', 'David Nwaba',\n",
       "       'Davion Mitchell', 'Davon Reed', \"Day'Ron Sharpe\", \"De'Aaron Fox\",\n",
       "       \"De'Andre Hunter\", \"De'Anthony Melton\", 'DeAndre Jordan',\n",
       "       \"DeAndre' Bembry\", 'DeJon Jarreau', 'DeMar DeRozan',\n",
       "       'DeMarcus Cousins', 'Dean Wade', 'Deandre Ayton',\n",
       "       'Deividas Sirvydis', 'Dejounte Murray', 'Delon Wright',\n",
       "       'Deni Avdija', 'Dennis Schröder', 'Dennis Smith Jr.',\n",
       "       'Denzel Valentine', 'Derrick Favors', 'Derrick Jones Jr.',\n",
       "       'Derrick Rose', 'Derrick Walton', 'Derrick White', 'Desmond Bane',\n",
       "       'Devin Booker', 'Devin Vassell', 'Devon Dotson', 'Devontae Cacok',\n",
       "       \"Devonte' Graham\", 'Dewayne Dedmon', 'Didi Louzada',\n",
       "       'Dillon Brooks', 'Domantas Sabonis', 'Donovan Mitchell',\n",
       "       'Donte DiVincenzo', 'Dorian Finney-Smith', 'Doug McDermott',\n",
       "       'Draymond Green', 'Drew Eubanks', 'Duane Washington Jr.',\n",
       "       'Duncan Robinson', 'Dwight Howard', 'Dwight Powell',\n",
       "       'Dylan Windler', 'Dāvis Bertāns', 'Ed Davis', 'Elfrid Payton',\n",
       "       'Elijah Hughes', 'Emanuel Terry', 'Emmanuel Mudiay',\n",
       "       'Enes Freedom', 'Eric Bledsoe', 'Eric Gordon', 'Eric Paschall',\n",
       "       'Eugene Omoruyi', 'Evan Fournier', 'Evan Mobley',\n",
       "       'Facundo Campazzo', 'Frank Jackson', 'Frank Kaminsky',\n",
       "       'Frank Ntilikina', 'Franz Wagner', 'Fred VanVleet',\n",
       "       'Freddie Gillespie', 'Furkan Korkmaz', 'Gabe Vincent',\n",
       "       'Gabriel Deck', 'Garrett Temple', 'Garrison Mathews', 'Gary Clark',\n",
       "       'Gary Harris', 'Gary Payton II', 'Gary Trent Jr.', 'George Hill',\n",
       "       'George King', 'Georges Niang', 'Georgios Kalaitzakis',\n",
       "       'Giannis Antetokounmpo', 'Goga Bitadze', 'Goran Dragić',\n",
       "       'Gordon Hayward', 'Gorgui Dieng', 'Grant Williams',\n",
       "       'Grayson Allen', 'Greg Brown III', 'Greg Monroe', 'Hamidou Diallo',\n",
       "       'Harrison Barnes', 'Hassan Whiteside', 'Hassani Gravett',\n",
       "       'Haywood Highsmith', 'Herbert Jones', 'Ignas Brazdeikis',\n",
       "       'Immanuel Quickley', 'Isaac Bonga', 'Isaac Okoro',\n",
       "       'Isaiah Hartenstein', 'Isaiah Jackson', 'Isaiah Joe',\n",
       "       'Isaiah Livers', 'Isaiah Roby', 'Isaiah Stewart', 'Isaiah Thomas',\n",
       "       'Isaiah Todd', 'Ish Smith', 'Ish Wainright', 'Ivica Zubac',\n",
       "       'JT Thor', 'Ja Morant', 'JaMychal Green', 'JaQuori McLaughlin',\n",
       "       'JaVale McGee', 'Jabari Parker', 'Jaden McDaniels',\n",
       "       'Jaden Springer', 'Jae Crowder', \"Jae'Sean Tate\",\n",
       "       \"Jahmi'us Ramsey\", 'Jaime Echenique', 'Jake Layman',\n",
       "       'Jakob Poeltl', 'Jalen Brunson', 'Jalen Green', 'Jalen Johnson',\n",
       "       'Jalen McDaniels', 'Jalen Smith', 'Jalen Suggs', 'James Bouknight',\n",
       "       'James Ennis III', 'James Harden', 'James Johnson',\n",
       "       'Jamorko Pickett', 'Jared Butler', 'Jared Harper',\n",
       "       'Jaren Jackson Jr.', 'Jarred Vanderbilt', 'Jarrett Allen',\n",
       "       'Jarrett Culver', 'Jarron Cumberland', 'Javin DeLaurier',\n",
       "       'Javonte Green', 'Javonte Smart', 'Jaxson Hayes', 'Jay Huff',\n",
       "       'Jay Scrubb', 'Jaylen Brown', 'Jaylen Hoard', 'Jaylen Morris',\n",
       "       'Jaylen Nowell', 'Jaysean Paige', 'Jayson Tatum', 'Jeff Dowtin',\n",
       "       'Jeff Green', 'Jemerrio Jones', 'Jerami Grant',\n",
       "       'Jeremiah Robinson-Earl', 'Jeremy Lamb', 'Jericho Sims',\n",
       "       'Jevon Carter', 'Jimmy Butler', 'Jock Landale', 'Joe Harris',\n",
       "       'Joe Ingles', 'Joe Johnson', 'Joe Wieskamp', 'Joel Ayayi',\n",
       "       'Joel Embiid', 'John Collins', 'John Konchar', 'Jon Teske',\n",
       "       'Jonas Valančiūnas', 'Jonathan Kuminga', 'Jordan Bell',\n",
       "       'Jordan Clarkson', 'Jordan Goodwin', 'Jordan McLaughlin',\n",
       "       'Jordan Nwora', 'Jordan Poole', 'Jordan Schakel', 'Jose Alvarado',\n",
       "       'Josh Christopher', 'Josh Giddey', 'Josh Green', 'Josh Hart',\n",
       "       'Josh Jackson', 'Josh Okogie', 'Josh Richardson', 'Joshua Primo',\n",
       "       'Jrue Holiday', 'Juan Toscano-Anderson', 'Juancho Hernangómez',\n",
       "       'Julius Randle', 'Justin Anderson', 'Justin Champagnie',\n",
       "       'Justin Holiday', 'Justin Jackson', 'Justin Robinson',\n",
       "       'Justise Winslow', 'Jusuf Nurkić', 'Juwan Morgan', 'KZ Okpala',\n",
       "       'Kai Jones', 'Karl-Anthony Towns', 'Keifer Sykes',\n",
       "       'Keita Bates-Diop', 'Kelan Martin', 'Keldon Johnson',\n",
       "       'Keljin Blevins', 'Kelly Olynyk', 'Kelly Oubre Jr.',\n",
       "       'Kemba Walker', 'Kenrich Williams', 'Kent Bazemore',\n",
       "       'Kentavious Caldwell-Pope', 'Kenyon Martin Jr.', 'Keon Johnson',\n",
       "       'Kessler Edwards', 'Kevin Durant', 'Kevin Huerter', 'Kevin Knox',\n",
       "       'Kevin Love', 'Kevin Pangos', 'Kevin Porter Jr.', 'Kevon Looney',\n",
       "       'Khem Birch', 'Khris Middleton', 'Killian Hayes', 'Killian Tillie',\n",
       "       'Kira Lewis Jr.', 'Klay Thompson', 'Kristaps Porziņģis',\n",
       "       'Kyle Anderson', 'Kyle Guy', 'Kyle Kuzma', 'Kyle Lowry',\n",
       "       'Kyrie Irving', 'LaMarcus Aldridge', 'LaMelo Ball',\n",
       "       'Lamar Stevens', 'Lance Stephenson', 'Landry Shamet',\n",
       "       'Langston Galloway', 'Larry Nance Jr.', 'Lauri Markkanen',\n",
       "       'LeBron James', 'Leandro Bolmaro', 'Lindell Wigginton',\n",
       "       'Lonnie Walker IV', 'Lonzo Ball', 'Lou Williams', 'Louis King',\n",
       "       'Luguentz Dort', 'Luka Dončić', 'Luka Garza', 'Luke Kennard',\n",
       "       'Luke Kornet', 'M.J. Walker', 'Mac McClung', 'Malachi Flynn',\n",
       "       'Malcolm Brogdon', 'Malcolm Hill', 'Malik Beasley', 'Malik Fitts',\n",
       "       'Malik Monk', 'Malik Newman', 'Mamadi Diakite', 'Marcus Garrett',\n",
       "       'Marcus Morris', 'Marcus Smart', 'Markieff Morris',\n",
       "       'Marko Simonovic', 'Markus Howard', 'Marquese Chriss',\n",
       "       'Marvin Bagley III', 'Mason Jones', 'Mason Plumlee',\n",
       "       'Matisse Thybulle', 'Matt Mooney', 'Matt Thomas',\n",
       "       'Maurice Harkless', 'Max Strus', 'Maxi Kleber',\n",
       "       'McKinley Wright IV', 'Micah Potter', 'Michael Porter Jr.',\n",
       "       'Mikal Bridges', 'Mike Conley', 'Mike Muscala', 'Miles Bridges',\n",
       "       'Miles McBride', 'Mitchell Robinson', 'Miye Oni', 'Mo Bamba',\n",
       "       'Monte Morris', 'Montrezl Harrell', 'Moritz Wagner', 'Moses Brown',\n",
       "       'Moses Moody', 'Moses Wright', 'Mychal Mulder', 'Myles Powell',\n",
       "       'Myles Turner', 'Naji Marshall', 'Nassir Little', 'Nate Hinton',\n",
       "       'Nathan Knight', 'Naz Reid', 'Neemias Queta', 'Nemanja Bjelica',\n",
       "       'Nerlens Noel', 'Nic Claxton', 'Nick Richards',\n",
       "       'Nickeil Alexander-Walker', 'Nicolas Batum', 'Nik Stauskas',\n",
       "       'Nikola Jokić', 'Nikola Vučević', 'Norman Powell', 'Norvel Pelle',\n",
       "       'OG Anunoby', 'Obi Toppin', 'Olivier Sarr', 'Omer Yurtseven',\n",
       "       'Onyeka Okongwu', 'Oshae Brissett', 'Otto Porter Jr.',\n",
       "       'P.J. Tucker', 'P.J. Washington', 'PJ Dozier', 'Paris Bass',\n",
       "       'Pascal Siakam', 'Pat Connaughton', 'Patrick Beverley',\n",
       "       'Patrick Williams', 'Patty Mills', 'Paul George', 'Paul Millsap',\n",
       "       'Paul Reed', 'Paul Watson', 'Payton Pritchard', 'Petr Cornelie',\n",
       "       'Precious Achiuwa', 'Quentin Grimes', 'Quinndary Weatherspoon',\n",
       "       'R.J. Hampton', 'RJ Barrett', 'RJ Nembhard Jr.', 'Rajon Rondo',\n",
       "       'Raul Neto', 'Rayjon Tucker', 'Reggie Bullock', 'Reggie Jackson',\n",
       "       'Reggie Perry', 'Richaun Holmes', 'Ricky Rubio', 'Rob Edwards',\n",
       "       'Robert Covington', 'Robert Williams', 'Robert Woodard II',\n",
       "       'Robin Lopez', 'Rodney Hood', 'Rodney McGruder', 'Romeo Langford',\n",
       "       \"Royce O'Neale\", 'Rudy Gay', 'Rudy Gobert', 'Rui Hachimura',\n",
       "       'Russell Westbrook', 'Saben Lee', 'Saddiq Bey', 'Sam Dekker',\n",
       "       'Sam Hauser', 'Sam Merrill', 'Sandro Mamukelashvili',\n",
       "       'Santi Aldama', 'Scottie Barnes', 'Scottie Lewis', 'Scotty Hopson',\n",
       "       'Sekou Doumbouya', 'Semi Ojeleye', 'Serge Ibaka', 'Seth Curry',\n",
       "       'Shai Gilgeous-Alexander', 'Shake Milton', 'Shaq Buchanan',\n",
       "       'Shaquille Harrison', 'Sharife Cooper', 'Skylar Mays',\n",
       "       'Solomon Hill', 'Spencer Dinwiddie', 'Stanley Johnson',\n",
       "       'Stephen Curry', 'Sterling Brown', 'Steven Adams',\n",
       "       'Svi Mykhailiuk', 'T.J. McConnell', 'Tacko Fall', 'Taj Gibson',\n",
       "       'Talen Horton-Tucker', 'Taurean Prince', 'Terance Mann',\n",
       "       'Terence Davis', 'Terrence Ross', 'Terry Rozier', 'Terry Taylor',\n",
       "       'Thaddeus Young', 'Thanasis Antetokounmpo', 'Theo Pinson',\n",
       "       'Thomas Bryant', 'Théo Maledon', 'Tim Frazier', 'Tim Hardaway Jr.',\n",
       "       'Timothé Luwawu-Cabarrot', 'Tobias Harris', 'Tomáš Satoranský',\n",
       "       'Tony Bradley', 'Tony Snell', 'Torrey Craig', 'Trae Young',\n",
       "       'Trayvon Palmer', 'Tre Jones', 'Tre Mann', 'Tre Scott',\n",
       "       'Tremont Waters', 'Trendon Watford', 'Trent Forrest',\n",
       "       'Trevelin Queen', 'Trevor Ariza', 'Trey Burke', 'Trey Lyles',\n",
       "       'Trey Murphy III', 'Tristan Thompson', 'Troy Brown Jr.',\n",
       "       'Ty Jerome', 'Tyler Cook', 'Tyler Hall', 'Tyler Herro',\n",
       "       'Tyler Johnson', 'Tyrell Terry', 'Tyrese Haliburton',\n",
       "       'Tyrese Maxey', 'Tyus Jones', 'Udoka Azubuike', 'Udonis Haslem',\n",
       "       'Usman Garuba', 'Vernon Carey Jr.', 'Vit Krejci', 'Vlatko Čančar',\n",
       "       'Wayne Ellington', 'Wayne Selden', 'Wendell Carter Jr.',\n",
       "       'Wenyen Gabriel', 'Wes Iwundu', 'Wesley Matthews', 'Will Barton',\n",
       "       'Willie Cauley-Stein', 'Willy Hernangómez', 'Xavier Moon',\n",
       "       'Xavier Sneed', 'Xavier Tillman Sr.', 'Yuta Watanabe', 'Yves Pons',\n",
       "       'Zach LaVine', 'Zeke Nnaji', 'Ziaire Williams', 'Zylan Cheatham'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df_1.Player.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "bcb9ff25",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date                  datetime64[ns]\n",
       "Name                          object\n",
       "Team                          object\n",
       "Position                      object\n",
       "Opp                           object\n",
       "Home/Away                     object\n",
       "Line                         float64\n",
       "Moneyline                      int64\n",
       "Projection                   float64\n",
       "Diff                         float64\n",
       "Pick                         float64\n",
       "Result                       float64\n",
       "over_under                    object\n",
       "seven_day_accuracy           float64\n",
       "successful_pick                int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bet_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "9da2cb3a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Player          object\n",
       "Age             object\n",
       "Pos             object\n",
       "Tm              object\n",
       "Home/Away_x     object\n",
       "                ...   \n",
       "3P%.1          float64\n",
       "FT.1             int64\n",
       "FTA.1            int64\n",
       "FT%.1          float64\n",
       "PTS.1            int64\n",
       "Length: 63, dtype: object"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df_1.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "c3d69cf6",
   "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>Date</th>\n",
       "      <th>Name</th>\n",
       "      <th>Team</th>\n",
       "      <th>Position</th>\n",
       "      <th>Opp</th>\n",
       "      <th>Home/Away</th>\n",
       "      <th>Line</th>\n",
       "      <th>Moneyline</th>\n",
       "      <th>Projection</th>\n",
       "      <th>Diff</th>\n",
       "      <th>Pick</th>\n",
       "      <th>Result</th>\n",
       "      <th>over_under</th>\n",
       "      <th>seven_day_accuracy</th>\n",
       "      <th>successful_pick</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-10-21</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>DAL</td>\n",
       "      <td>vs.</td>\n",
       "      <td>15.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>16.57</td>\n",
       "      <td>1.07</td>\n",
       "      <td>15.5</td>\n",
       "      <td>11.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.47</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-10-23</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>CLE</td>\n",
       "      <td>@</td>\n",
       "      <td>14.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>15.29</td>\n",
       "      <td>0.79</td>\n",
       "      <td>14.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-10-25</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>DET</td>\n",
       "      <td>vs.</td>\n",
       "      <td>15.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>12.85</td>\n",
       "      <td>-2.65</td>\n",
       "      <td>15.5</td>\n",
       "      <td>14.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-10-27</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>NOR</td>\n",
       "      <td>@</td>\n",
       "      <td>12.5</td>\n",
       "      <td>-125</td>\n",
       "      <td>13.70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>12.5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-10-28</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>WAS</td>\n",
       "      <td>@</td>\n",
       "      <td>12.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>16.72</td>\n",
       "      <td>4.22</td>\n",
       "      <td>12.5</td>\n",
       "      <td>14.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9386</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>CHI</td>\n",
       "      <td>vs.</td>\n",
       "      <td>8.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>6.11</td>\n",
       "      <td>-2.39</td>\n",
       "      <td>8.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.58</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9387</th>\n",
       "      <td>2022-01-19</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>MIL</td>\n",
       "      <td>@</td>\n",
       "      <td>9.5</td>\n",
       "      <td>-103</td>\n",
       "      <td>8.70</td>\n",
       "      <td>-0.80</td>\n",
       "      <td>9.5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9388</th>\n",
       "      <td>2022-01-21</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>DEN</td>\n",
       "      <td>@</td>\n",
       "      <td>9.5</td>\n",
       "      <td>100</td>\n",
       "      <td>8.90</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>9.5</td>\n",
       "      <td>17.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9389</th>\n",
       "      <td>2022-01-23</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>DAL</td>\n",
       "      <td>@</td>\n",
       "      <td>10.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>8.60</td>\n",
       "      <td>-1.90</td>\n",
       "      <td>10.5</td>\n",
       "      <td>9.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9390</th>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>SAS</td>\n",
       "      <td>@</td>\n",
       "      <td>10.5</td>\n",
       "      <td>-132</td>\n",
       "      <td>8.20</td>\n",
       "      <td>-2.30</td>\n",
       "      <td>10.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>u</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9391 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date             Name Team Position  Opp Home/Away  Line  \\\n",
       "0    2021-10-21           Bogdan  ATL        G  DAL       vs.  15.5   \n",
       "1    2021-10-23           Bogdan  ATL        G  CLE         @  14.5   \n",
       "2    2021-10-25           Bogdan  ATL        G  DET       vs.  15.5   \n",
       "3    2021-10-27           Bogdan  ATL        G  NOR         @  12.5   \n",
       "4    2021-10-28           Bogdan  ATL        G  WAS         @  12.5   \n",
       "...         ...              ...  ...      ...  ...       ...   ...   \n",
       "9386 2022-01-17  Ziaire Williams  MEM        G  CHI       vs.   8.5   \n",
       "9387 2022-01-19  Ziaire Williams  MEM        G  MIL         @   9.5   \n",
       "9388 2022-01-21  Ziaire Williams  MEM        G  DEN         @   9.5   \n",
       "9389 2022-01-23  Ziaire Williams  MEM        G  DAL         @  10.5   \n",
       "9390 2022-01-26  Ziaire Williams  MEM        G  SAS         @  10.5   \n",
       "\n",
       "      Moneyline  Projection  Diff  Pick  Result over_under  \\\n",
       "0          -115       16.57  1.07  15.5    11.0          o   \n",
       "1          -115       15.29  0.79  14.5     5.0          o   \n",
       "2          -115       12.85 -2.65  15.5    14.0          u   \n",
       "3          -125       13.70  1.20  12.5    12.0          o   \n",
       "4          -105       16.72  4.22  12.5    14.0          o   \n",
       "...         ...         ...   ...   ...     ...        ...   \n",
       "9386       -105        6.11 -2.39   8.5     2.0          u   \n",
       "9387       -103        8.70 -0.80   9.5    10.0          u   \n",
       "9388        100        8.90 -0.60   9.5    17.0          u   \n",
       "9389       -105        8.60 -1.90  10.5     9.0          u   \n",
       "9390       -132        8.20 -2.30  10.5     NaN          u   \n",
       "\n",
       "      seven_day_accuracy  successful_pick  \n",
       "0                   0.47                0  \n",
       "1                   0.45                0  \n",
       "2                   0.45                1  \n",
       "3                   0.45                0  \n",
       "4                   0.42                1  \n",
       "...                  ...              ...  \n",
       "9386                0.58                1  \n",
       "9387                0.62                0  \n",
       "9388                0.59                0  \n",
       "9389                0.55                1  \n",
       "9390                0.43                0  \n",
       "\n",
       "[9391 rows x 15 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bet_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "76beb410",
   "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>Date</th>\n",
       "      <th>Name</th>\n",
       "      <th>Team</th>\n",
       "      <th>Position</th>\n",
       "      <th>Opp</th>\n",
       "      <th>Home/Away</th>\n",
       "      <th>Line</th>\n",
       "      <th>Moneyline</th>\n",
       "      <th>Projection</th>\n",
       "      <th>Diff</th>\n",
       "      <th>Pick</th>\n",
       "      <th>Result</th>\n",
       "      <th>over_under</th>\n",
       "      <th>seven_day_accuracy</th>\n",
       "      <th>successful_pick</th>\n",
       "      <th>Matches</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-10-21</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>DAL</td>\n",
       "      <td>vs.</td>\n",
       "      <td>15.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>16.57</td>\n",
       "      <td>1.07</td>\n",
       "      <td>15.5</td>\n",
       "      <td>11.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.47</td>\n",
       "      <td>0</td>\n",
       "      <td>[(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-10-23</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>CLE</td>\n",
       "      <td>@</td>\n",
       "      <td>14.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>15.29</td>\n",
       "      <td>0.79</td>\n",
       "      <td>14.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>[(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-10-25</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>DET</td>\n",
       "      <td>vs.</td>\n",
       "      <td>15.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>12.85</td>\n",
       "      <td>-2.65</td>\n",
       "      <td>15.5</td>\n",
       "      <td>14.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1</td>\n",
       "      <td>[(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-10-27</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>NOR</td>\n",
       "      <td>@</td>\n",
       "      <td>12.5</td>\n",
       "      <td>-125</td>\n",
       "      <td>13.70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>12.5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>[(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-10-28</td>\n",
       "      <td>Bogdan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>G</td>\n",
       "      <td>WAS</td>\n",
       "      <td>@</td>\n",
       "      <td>12.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>16.72</td>\n",
       "      <td>4.22</td>\n",
       "      <td>12.5</td>\n",
       "      <td>14.0</td>\n",
       "      <td>o</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1</td>\n",
       "      <td>[(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9386</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>CHI</td>\n",
       "      <td>vs.</td>\n",
       "      <td>8.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>6.11</td>\n",
       "      <td>-2.39</td>\n",
       "      <td>8.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.58</td>\n",
       "      <td>1</td>\n",
       "      <td>[(Ziaire Williams, 100), (Ziaire Williams, 100)]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9387</th>\n",
       "      <td>2022-01-19</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>MIL</td>\n",
       "      <td>@</td>\n",
       "      <td>9.5</td>\n",
       "      <td>-103</td>\n",
       "      <td>8.70</td>\n",
       "      <td>-0.80</td>\n",
       "      <td>9.5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0</td>\n",
       "      <td>[(Ziaire Williams, 100), (Ziaire Williams, 100)]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9388</th>\n",
       "      <td>2022-01-21</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>DEN</td>\n",
       "      <td>@</td>\n",
       "      <td>9.5</td>\n",
       "      <td>100</td>\n",
       "      <td>8.90</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>9.5</td>\n",
       "      <td>17.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0</td>\n",
       "      <td>[(Ziaire Williams, 100), (Ziaire Williams, 100)]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9389</th>\n",
       "      <td>2022-01-23</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>DAL</td>\n",
       "      <td>@</td>\n",
       "      <td>10.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>8.60</td>\n",
       "      <td>-1.90</td>\n",
       "      <td>10.5</td>\n",
       "      <td>9.0</td>\n",
       "      <td>u</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1</td>\n",
       "      <td>[(Ziaire Williams, 100), (Ziaire Williams, 100)]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9390</th>\n",
       "      <td>2022-01-26</td>\n",
       "      <td>Ziaire Williams</td>\n",
       "      <td>MEM</td>\n",
       "      <td>G</td>\n",
       "      <td>SAS</td>\n",
       "      <td>@</td>\n",
       "      <td>10.5</td>\n",
       "      <td>-132</td>\n",
       "      <td>8.20</td>\n",
       "      <td>-2.30</td>\n",
       "      <td>10.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>u</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0</td>\n",
       "      <td>[(Ziaire Williams, 100), (Ziaire Williams, 100)]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9391 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date             Name Team Position  Opp Home/Away  Line  \\\n",
       "0    2021-10-21           Bogdan  ATL        G  DAL       vs.  15.5   \n",
       "1    2021-10-23           Bogdan  ATL        G  CLE         @  14.5   \n",
       "2    2021-10-25           Bogdan  ATL        G  DET       vs.  15.5   \n",
       "3    2021-10-27           Bogdan  ATL        G  NOR         @  12.5   \n",
       "4    2021-10-28           Bogdan  ATL        G  WAS         @  12.5   \n",
       "...         ...              ...  ...      ...  ...       ...   ...   \n",
       "9386 2022-01-17  Ziaire Williams  MEM        G  CHI       vs.   8.5   \n",
       "9387 2022-01-19  Ziaire Williams  MEM        G  MIL         @   9.5   \n",
       "9388 2022-01-21  Ziaire Williams  MEM        G  DEN         @   9.5   \n",
       "9389 2022-01-23  Ziaire Williams  MEM        G  DAL         @  10.5   \n",
       "9390 2022-01-26  Ziaire Williams  MEM        G  SAS         @  10.5   \n",
       "\n",
       "      Moneyline  Projection  Diff  Pick  Result over_under  \\\n",
       "0          -115       16.57  1.07  15.5    11.0          o   \n",
       "1          -115       15.29  0.79  14.5     5.0          o   \n",
       "2          -115       12.85 -2.65  15.5    14.0          u   \n",
       "3          -125       13.70  1.20  12.5    12.0          o   \n",
       "4          -105       16.72  4.22  12.5    14.0          o   \n",
       "...         ...         ...   ...   ...     ...        ...   \n",
       "9386       -105        6.11 -2.39   8.5     2.0          u   \n",
       "9387       -103        8.70 -0.80   9.5    10.0          u   \n",
       "9388        100        8.90 -0.60   9.5    17.0          u   \n",
       "9389       -105        8.60 -1.90  10.5     9.0          u   \n",
       "9390       -132        8.20 -2.30  10.5     NaN          u   \n",
       "\n",
       "      seven_day_accuracy  successful_pick  \\\n",
       "0                   0.47                0   \n",
       "1                   0.45                0   \n",
       "2                   0.45                1   \n",
       "3                   0.45                0   \n",
       "4                   0.42                1   \n",
       "...                  ...              ...   \n",
       "9386                0.58                1   \n",
       "9387                0.62                0   \n",
       "9388                0.59                0   \n",
       "9389                0.55                1   \n",
       "9390                0.43                0   \n",
       "\n",
       "                                                Matches  \n",
       "0     [(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...  \n",
       "1     [(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...  \n",
       "2     [(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...  \n",
       "3     [(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...  \n",
       "4     [(Bogdan Bogdanović, 90), (Bogdan Bogdanović, ...  \n",
       "...                                                 ...  \n",
       "9386   [(Ziaire Williams, 100), (Ziaire Williams, 100)]  \n",
       "9387   [(Ziaire Williams, 100), (Ziaire Williams, 100)]  \n",
       "9388   [(Ziaire Williams, 100), (Ziaire Williams, 100)]  \n",
       "9389   [(Ziaire Williams, 100), (Ziaire Williams, 100)]  \n",
       "9390   [(Ziaire Williams, 100), (Ziaire Williams, 100)]  \n",
       "\n",
       "[9391 rows x 16 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mat1 = []\n",
    "mat2 = []\n",
    "\n",
    "\n",
    "list1 = bet_df['Name'].tolist()\n",
    "list2 = merged_df_1['Player'].tolist()\n",
    "\n",
    "threshold=75\n",
    "\n",
    "for i in list1:\n",
    "    mat1.append(process.extract(i, list2, limit=2))\n",
    "bet_df['Matches'] = mat1\n",
    "bet_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "b4982090",
   "metadata": {},
   "outputs": [],
   "source": [
    "bet_df.to_csv('fuzzy_matches_bet_df.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:metis] *",
   "language": "python",
   "name": "conda-env-metis-py"
  },
  "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}