scraping_data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Web Scrape NBA Game Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import dependencies\n",
    "import pandas as pd\n",
    "from webdriver_manager.chrome import ChromeDriverManager\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.support.ui import Select\n",
    "from selenium.webdriver.common.by import By\n",
    "import time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "====== WebDriver manager ======\n",
      "Could not get version for google-chrome with the command:  powershell \"$ErrorActionPreference='silentlycontinue' ; (Get-Item -Path \"$env:PROGRAMFILES\\Google\\Chrome\\Application\\chrome.exe\").VersionInfo.FileVersion ; if (-not $? -or $? -match $error) { (Get-Item -Path \"$env:PROGRAMFILES(x86)\\Google\\Chrome\\Application\\chrome.exe\").VersionInfo.FileVersion } if (-not $? -or $? -match $error) { (Get-Item -Path \"$env:LOCALAPPDATA\\Google\\Chrome\\Application\\chrome.exe\").VersionInfo.FileVersion } if (-not $? -or $? -match $error) { reg query \"HKCU\\SOFTWARE\\Google\\Chrome\\BLBeacon\" /v version } if (-not $? -or $? -match $error) { reg query \"HKLM\\SOFTWARE\\Wow6432Node\\Microsoft\\Windows\\CurrentVersion\\Uninstall\\Google Chrome\" /v version }\"\n",
      "Current google-chrome version is UNKNOWN\n",
      "Get LATEST chromedriver version for UNKNOWN google-chrome\n",
      "Trying to download new driver from https://chromedriver.storage.googleapis.com/110.0.5481.77/chromedriver_win32.zip\n",
      "Driver has been saved in cache [C:\\Users\\emera\\.wdm\\drivers\\chromedriver\\win32\\110.0.5481.77]\n",
      "<ipython-input-2-83694e59ee80>:2: DeprecationWarning: executable_path has been deprecated, please pass in a Service object\n",
      "  driver = webdriver.Chrome(ChromeDriverManager().install())\n"
     ]
    }
   ],
   "source": [
    "# Create a Web Driver Object\n",
    "driver = webdriver.Chrome(ChromeDriverManager().install())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pull Regular Season Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Connect to the website\n",
    "driver.get(url=\"https://www.nba.com/stats/teams/boxscores/?Season=2021-22&SeasonType=Regular%20Season\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select the drop down element that allows user to choose which page to view\n",
    "table_section = driver.find_element(By.CLASS_NAME, \"Crom_base__f0niE\")\n",
    "sel = Select(table_section.find_element(By.CLASS_NAME, \"DropDown_select__4pIg9\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select the \"ALL\" option, which is Index 0\n",
    "sel.select_by_visible_text(\"All\")\n",
    "# sel.select_by_index(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the game stats table on the webpage\n",
    "time.sleep(1) # In case the table takes a while to load\n",
    "stats = driver.find_element(By.CLASS_NAME, \"Crom_table__p1iZz\").get_attribute('outerHTML')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert the table (list) into a DataFrame\n",
    "result = pd.read_html(stats)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>Team</th>\n",
       "      <th>Match Up</th>\n",
       "      <th>Game Date</th>\n",
       "      <th>W/L</th>\n",
       "      <th>MIN</th>\n",
       "      <th>PTS</th>\n",
       "      <th>FGM</th>\n",
       "      <th>FGA</th>\n",
       "      <th>FG%</th>\n",
       "      <th>3PM</th>\n",
       "      <th>...</th>\n",
       "      <th>FT%</th>\n",
       "      <th>OREB</th>\n",
       "      <th>DREB</th>\n",
       "      <th>REB</th>\n",
       "      <th>AST</th>\n",
       "      <th>STL</th>\n",
       "      <th>BLK</th>\n",
       "      <th>TOV</th>\n",
       "      <th>PF</th>\n",
       "      <th>+/-</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BOS</td>\n",
       "      <td>BOS @ MEM</td>\n",
       "      <td>04/09/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>139</td>\n",
       "      <td>54</td>\n",
       "      <td>99</td>\n",
       "      <td>54.5</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>14</td>\n",
       "      <td>42</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>20</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CLE</td>\n",
       "      <td>CLE vs. MIL</td>\n",
       "      <td>04/09/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>133</td>\n",
       "      <td>51</td>\n",
       "      <td>94</td>\n",
       "      <td>54.3</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>70.6</td>\n",
       "      <td>10</td>\n",
       "      <td>38</td>\n",
       "      <td>48</td>\n",
       "      <td>39</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>26</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>MIL</td>\n",
       "      <td>MIL @ CLE</td>\n",
       "      <td>04/09/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>115</td>\n",
       "      <td>39</td>\n",
       "      <td>88</td>\n",
       "      <td>44.3</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>78.1</td>\n",
       "      <td>8</td>\n",
       "      <td>33</td>\n",
       "      <td>41</td>\n",
       "      <td>27</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ATL</td>\n",
       "      <td>ATL @ HOU</td>\n",
       "      <td>04/09/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>130</td>\n",
       "      <td>45</td>\n",
       "      <td>87</td>\n",
       "      <td>51.7</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>79.2</td>\n",
       "      <td>13</td>\n",
       "      <td>37</td>\n",
       "      <td>50</td>\n",
       "      <td>29</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>WAS</td>\n",
       "      <td>WAS @ CHA</td>\n",
       "      <td>04/09/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>108</td>\n",
       "      <td>42</td>\n",
       "      <td>94</td>\n",
       "      <td>44.7</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>61.5</td>\n",
       "      <td>17</td>\n",
       "      <td>26</td>\n",
       "      <td>43</td>\n",
       "      <td>25</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "      <td>-16</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>2455</th>\n",
       "      <td>HOU</td>\n",
       "      <td>HOU @ MIN</td>\n",
       "      <td>10/19/2021</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>106</td>\n",
       "      <td>40</td>\n",
       "      <td>88</td>\n",
       "      <td>45.5</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>68.2</td>\n",
       "      <td>12</td>\n",
       "      <td>29</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>25</td>\n",
       "      <td>-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2456</th>\n",
       "      <td>LAL</td>\n",
       "      <td>LAL vs. GSW</td>\n",
       "      <td>10/18/2021</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>114</td>\n",
       "      <td>45</td>\n",
       "      <td>95</td>\n",
       "      <td>47.4</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>47.4</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>25</td>\n",
       "      <td>-7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2457</th>\n",
       "      <td>GSW</td>\n",
       "      <td>GSW @ LAL</td>\n",
       "      <td>10/18/2021</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>121</td>\n",
       "      <td>41</td>\n",
       "      <td>93</td>\n",
       "      <td>44.1</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>83.3</td>\n",
       "      <td>9</td>\n",
       "      <td>41</td>\n",
       "      <td>50</td>\n",
       "      <td>30</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2458</th>\n",
       "      <td>MIL</td>\n",
       "      <td>MIL vs. BKN</td>\n",
       "      <td>10/18/2021</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>127</td>\n",
       "      <td>48</td>\n",
       "      <td>105</td>\n",
       "      <td>45.7</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>77.8</td>\n",
       "      <td>13</td>\n",
       "      <td>41</td>\n",
       "      <td>54</td>\n",
       "      <td>25</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>19</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2459</th>\n",
       "      <td>BKN</td>\n",
       "      <td>BKN @ MIL</td>\n",
       "      <td>10/18/2021</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>104</td>\n",
       "      <td>37</td>\n",
       "      <td>84</td>\n",
       "      <td>44.0</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>56.5</td>\n",
       "      <td>5</td>\n",
       "      <td>39</td>\n",
       "      <td>44</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>-23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2460 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Team     Match Up   Game Date W/L  MIN  PTS  FGM  FGA   FG%  3PM  ...  \\\n",
       "0     BOS    BOS @ MEM  04/09/2022   W  240  139   54   99  54.5   18  ...   \n",
       "1     CLE  CLE vs. MIL  04/09/2022   W  240  133   51   94  54.3   19  ...   \n",
       "2     MIL    MIL @ CLE  04/09/2022   L  240  115   39   88  44.3   12  ...   \n",
       "3     ATL    ATL @ HOU  04/09/2022   W  240  130   45   87  51.7   21  ...   \n",
       "4     WAS    WAS @ CHA  04/09/2022   L  240  108   42   94  44.7    8  ...   \n",
       "...   ...          ...         ...  ..  ...  ...  ...  ...   ...  ...  ...   \n",
       "2455  HOU    HOU @ MIN  10/19/2021   L  240  106   40   88  45.5   11  ...   \n",
       "2456  LAL  LAL vs. GSW  10/18/2021   L  240  114   45   95  47.4   15  ...   \n",
       "2457  GSW    GSW @ LAL  10/18/2021   W  240  121   41   93  44.1   14  ...   \n",
       "2458  MIL  MIL vs. BKN  10/18/2021   W  240  127   48  105  45.7   17  ...   \n",
       "2459  BKN    BKN @ MIL  10/18/2021   L  240  104   37   84  44.0   17  ...   \n",
       "\n",
       "        FT%  OREB  DREB  REB  AST  STL  BLK  TOV  PF  +/-  \n",
       "0     100.0    14    42   56   34    5    2   15  20   29  \n",
       "1      70.6    10    38   48   39    5    5   12  26   18  \n",
       "2      78.1     8    33   41   27    7    2   12  14  -18  \n",
       "3      79.2    13    37   50   29    4    4   13  19   16  \n",
       "4      61.5    17    26   43   25   12    3   11  16  -16  \n",
       "...     ...   ...   ...  ...  ...  ...  ...  ...  ..  ...  \n",
       "2455   68.2    12    29   41   21   13    3   24  25  -18  \n",
       "2456   47.4     5    40   45   21    7    4   18  25   -7  \n",
       "2457   83.3     9    41   50   30    9    2   17  18    7  \n",
       "2458   77.8    13    41   54   25    8    9    8  19   23  \n",
       "2459   56.5     5    39   44   19    3    9   13  17  -23  \n",
       "\n",
       "[2460 rows x 24 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Pull the table into a DataFrame\n",
    "table_df = result[0]\n",
    "table_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop unnecessary columns\n",
    "table_df = table_df.drop(['Match Up', 'Game Date', 'W/L', 'FG%', '3P%', 'FT%'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Rename the columns to match the database schema\n",
    "table_df = table_df.rename(columns={\"Team\":\"team\"})\n",
    "table_df = table_df.rename(columns={\"MIN\":\"min\", \"PTS\":\"pts\", \"FGM\":\"fgm\"})\n",
    "table_df = table_df.rename(columns={\"FGA\":\"fga\", \"3PM\":\"threepm\", \"3PA\":\"threepa\", \"FTM\":\"ftm\", \"FTA\":\"fta\"})\n",
    "table_df = table_df.rename(columns={\"OREB\":\"oreb\", \"DREB\":\"dreb\", \"REB\":\"reb\", \"AST\":\"ast\", \"STL\":\"stl\"})\n",
    "table_df = table_df.rename(columns={\"BLK\":\"blk\", \"TOV\":\"tov\", \"PF\":\"pf\", \"+/-\":\"point_diff\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the dataframe into a CSV file\n",
    "table_df.to_csv(\"Data/Scraped/NBA_Data_Reg_Season_2022.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pull Play-In Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Connect to the website\n",
    "driver.get(url=\"https://www.nba.com/stats/teams/boxscores/?Season=2021-22&SeasonType=PlayIn\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the table on the webpage\n",
    "time.sleep(1) # In case the table takes a while to load\n",
    "stats = driver.find_element(By.CLASS_NAME, \"Crom_table__p1iZz\").get_attribute('outerHTML')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert the table (list) into a DataFrame\n",
    "result = pd.read_html(stats)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>Team</th>\n",
       "      <th>Match Up</th>\n",
       "      <th>Game Date</th>\n",
       "      <th>W/L</th>\n",
       "      <th>MIN</th>\n",
       "      <th>PTS</th>\n",
       "      <th>FGM</th>\n",
       "      <th>FGA</th>\n",
       "      <th>FG%</th>\n",
       "      <th>3PM</th>\n",
       "      <th>...</th>\n",
       "      <th>FT%</th>\n",
       "      <th>OREB</th>\n",
       "      <th>DREB</th>\n",
       "      <th>REB</th>\n",
       "      <th>AST</th>\n",
       "      <th>STL</th>\n",
       "      <th>BLK</th>\n",
       "      <th>TOV</th>\n",
       "      <th>PF</th>\n",
       "      <th>+/-</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ATL</td>\n",
       "      <td>ATL @ CLE</td>\n",
       "      <td>04/14/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>107</td>\n",
       "      <td>39</td>\n",
       "      <td>80</td>\n",
       "      <td>48.8</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>90.9</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>42</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CLE</td>\n",
       "      <td>CLE vs. ATL</td>\n",
       "      <td>04/14/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>101</td>\n",
       "      <td>37</td>\n",
       "      <td>81</td>\n",
       "      <td>45.7</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>82.4</td>\n",
       "      <td>8</td>\n",
       "      <td>28</td>\n",
       "      <td>36</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>20</td>\n",
       "      <td>-6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LAC</td>\n",
       "      <td>LAC vs. NOP</td>\n",
       "      <td>04/14/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>101</td>\n",
       "      <td>35</td>\n",
       "      <td>85</td>\n",
       "      <td>41.2</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>64.7</td>\n",
       "      <td>12</td>\n",
       "      <td>33</td>\n",
       "      <td>45</td>\n",
       "      <td>20</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>21</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NOP</td>\n",
       "      <td>NOP @ LAC</td>\n",
       "      <td>04/14/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>105</td>\n",
       "      <td>43</td>\n",
       "      <td>88</td>\n",
       "      <td>48.9</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>52.0</td>\n",
       "      <td>17</td>\n",
       "      <td>37</td>\n",
       "      <td>54</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>26</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SAS</td>\n",
       "      <td>SAS @ NOP</td>\n",
       "      <td>04/12/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>103</td>\n",
       "      <td>37</td>\n",
       "      <td>91</td>\n",
       "      <td>40.7</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>72.7</td>\n",
       "      <td>8</td>\n",
       "      <td>26</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>20</td>\n",
       "      <td>-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NOP</td>\n",
       "      <td>NOP vs. SAS</td>\n",
       "      <td>04/12/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>113</td>\n",
       "      <td>44</td>\n",
       "      <td>81</td>\n",
       "      <td>54.3</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>73.9</td>\n",
       "      <td>8</td>\n",
       "      <td>45</td>\n",
       "      <td>53</td>\n",
       "      <td>25</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>22</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ATL</td>\n",
       "      <td>ATL vs. CHA</td>\n",
       "      <td>04/12/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>132</td>\n",
       "      <td>49</td>\n",
       "      <td>94</td>\n",
       "      <td>52.1</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>72.0</td>\n",
       "      <td>12</td>\n",
       "      <td>42</td>\n",
       "      <td>54</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CHA</td>\n",
       "      <td>CHA @ ATL</td>\n",
       "      <td>04/12/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>103</td>\n",
       "      <td>34</td>\n",
       "      <td>90</td>\n",
       "      <td>37.8</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>75.9</td>\n",
       "      <td>11</td>\n",
       "      <td>30</td>\n",
       "      <td>41</td>\n",
       "      <td>22</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>24</td>\n",
       "      <td>-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>LAC</td>\n",
       "      <td>LAC @ MIN</td>\n",
       "      <td>04/11/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>104</td>\n",
       "      <td>34</td>\n",
       "      <td>78</td>\n",
       "      <td>43.6</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>74.1</td>\n",
       "      <td>7</td>\n",
       "      <td>32</td>\n",
       "      <td>39</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>17</td>\n",
       "      <td>28</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MIN</td>\n",
       "      <td>MIN vs. LAC</td>\n",
       "      <td>04/11/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>109</td>\n",
       "      <td>36</td>\n",
       "      <td>83</td>\n",
       "      <td>43.4</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>62.2</td>\n",
       "      <td>12</td>\n",
       "      <td>37</td>\n",
       "      <td>49</td>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>26</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BKN</td>\n",
       "      <td>BKN vs. CLE</td>\n",
       "      <td>04/11/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>115</td>\n",
       "      <td>45</td>\n",
       "      <td>84</td>\n",
       "      <td>53.6</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>66.7</td>\n",
       "      <td>10</td>\n",
       "      <td>33</td>\n",
       "      <td>43</td>\n",
       "      <td>33</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>14</td>\n",
       "      <td>20</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CLE</td>\n",
       "      <td>CLE @ BKN</td>\n",
       "      <td>04/11/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>108</td>\n",
       "      <td>41</td>\n",
       "      <td>92</td>\n",
       "      <td>44.6</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>40</td>\n",
       "      <td>26</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>21</td>\n",
       "      <td>-7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Team     Match Up   Game Date W/L  MIN  PTS  FGM  FGA   FG%  3PM  ...  \\\n",
       "0   ATL    ATL @ CLE  04/14/2022   W  240  107   39   80  48.8    9  ...   \n",
       "1   CLE  CLE vs. ATL  04/14/2022   L  240  101   37   81  45.7   13  ...   \n",
       "2   LAC  LAC vs. NOP  04/14/2022   L  240  101   35   85  41.2    9  ...   \n",
       "3   NOP    NOP @ LAC  04/14/2022   W  240  105   43   88  48.9    6  ...   \n",
       "4   SAS    SAS @ NOP  04/12/2022   L  240  103   37   91  40.7   13  ...   \n",
       "5   NOP  NOP vs. SAS  04/12/2022   W  240  113   44   81  54.3    8  ...   \n",
       "6   ATL  ATL vs. CHA  04/12/2022   W  240  132   49   94  52.1   16  ...   \n",
       "7   CHA    CHA @ ATL  04/12/2022   L  240  103   34   90  37.8   13  ...   \n",
       "8   LAC    LAC @ MIN  04/11/2022   L  240  104   34   78  43.6   16  ...   \n",
       "9   MIN  MIN vs. LAC  04/11/2022   W  240  109   36   83  43.4   14  ...   \n",
       "10  BKN  BKN vs. CLE  04/11/2022   W  240  115   45   84  53.6    9  ...   \n",
       "11  CLE    CLE @ BKN  04/11/2022   L  240  108   41   92  44.6    9  ...   \n",
       "\n",
       "     FT%  OREB  DREB  REB  AST  STL  BLK  TOV  PF  +/-  \n",
       "0   90.9    10    32   42   15    5    3   13  19    6  \n",
       "1   82.4     8    28   36   23    8    4   14  20   -6  \n",
       "2   64.7    12    33   45   20    7    3    8  21   -4  \n",
       "3   52.0    17    37   54   20    2    3    9  26    4  \n",
       "4   72.7     8    26   34   19    4    3    6  20  -10  \n",
       "5   73.9     8    45   53   25    4    7   14  22   10  \n",
       "6   72.0    12    42   54   31    5    6   12  25   29  \n",
       "7   75.9    11    30   41   22    4    4   14  24  -29  \n",
       "8   74.1     7    32   39   19    5    5   17  28   -5  \n",
       "9   62.2    12    37   49   19   10    2   13  26    5  \n",
       "10  66.7    10    33   43   33    9    9   14  20    7  \n",
       "11  85.0    10    30   40   26    9    2   15  21   -7  \n",
       "\n",
       "[12 rows x 24 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Pull the table into a DataFrame\n",
    "table_df = result[0]\n",
    "table_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop unnecessary columns\n",
    "table_df = table_df.drop(['Match Up', 'Game Date', 'W/L', 'FG%', '3P%', 'FT%'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Rename the columns to match the database schema\n",
    "table_df = table_df.rename(columns={\"Team\":\"team\"})\n",
    "table_df = table_df.rename(columns={\"MIN\":\"min\", \"PTS\":\"pts\", \"FGM\":\"fgm\"})\n",
    "table_df = table_df.rename(columns={\"FGA\":\"fga\", \"3PM\":\"threepm\", \"3PA\":\"threepa\", \"FTM\":\"ftm\", \"FTA\":\"fta\"})\n",
    "table_df = table_df.rename(columns={\"OREB\":\"oreb\", \"DREB\":\"dreb\", \"REB\":\"reb\", \"AST\":\"ast\", \"STL\":\"stl\"})\n",
    "table_df = table_df.rename(columns={\"BLK\":\"blk\", \"TOV\":\"tov\", \"PF\":\"pf\", \"+/-\":\"point_diff\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the dataframe into a csv file\n",
    "table_df.to_csv(\"Data/Scraped/NBA_Data_Play_In_2022.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pull Playoff Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Connect to the website\n",
    "driver.get(url=\"https://www.nba.com/stats/teams/boxscores/?Season=2021-22&SeasonType=Playoffs\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select the drop down element that allows user to choose which page to view\n",
    "table_section = driver.find_element(By.CLASS_NAME, \"Crom_base__f0niE\")\n",
    "sel = Select(table_section.find_element(By.CLASS_NAME, \"DropDown_select__4pIg9\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select the \"ALL\" option, which is Index 0\n",
    "sel.select_by_visible_text(\"All\")\n",
    "# sel.select_by_index(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the table on the webpage\n",
    "time.sleep(1) # In case the table takes a while to load\n",
    "stats = driver.find_element(By.CLASS_NAME, \"Crom_table__p1iZz\").get_attribute('outerHTML')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert the table (list) into a DataFrame\n",
    "result = pd.read_html(stats)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>Team</th>\n",
       "      <th>Match Up</th>\n",
       "      <th>Game Date</th>\n",
       "      <th>W/L</th>\n",
       "      <th>MIN</th>\n",
       "      <th>PTS</th>\n",
       "      <th>FGM</th>\n",
       "      <th>FGA</th>\n",
       "      <th>FG%</th>\n",
       "      <th>3PM</th>\n",
       "      <th>...</th>\n",
       "      <th>FT%</th>\n",
       "      <th>OREB</th>\n",
       "      <th>DREB</th>\n",
       "      <th>REB</th>\n",
       "      <th>AST</th>\n",
       "      <th>STL</th>\n",
       "      <th>BLK</th>\n",
       "      <th>TOV</th>\n",
       "      <th>PF</th>\n",
       "      <th>+/-</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BOS</td>\n",
       "      <td>BOS vs. GSW</td>\n",
       "      <td>06/15/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>90</td>\n",
       "      <td>34</td>\n",
       "      <td>80</td>\n",
       "      <td>42.5</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>91.7</td>\n",
       "      <td>11</td>\n",
       "      <td>30</td>\n",
       "      <td>41</td>\n",
       "      <td>27</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GSW</td>\n",
       "      <td>GSW @ BOS</td>\n",
       "      <td>06/15/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>103</td>\n",
       "      <td>38</td>\n",
       "      <td>92</td>\n",
       "      <td>41.3</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>15</td>\n",
       "      <td>29</td>\n",
       "      <td>44</td>\n",
       "      <td>27</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>20</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BOS</td>\n",
       "      <td>BOS @ GSW</td>\n",
       "      <td>06/12/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>94</td>\n",
       "      <td>31</td>\n",
       "      <td>75</td>\n",
       "      <td>41.3</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>67.7</td>\n",
       "      <td>8</td>\n",
       "      <td>39</td>\n",
       "      <td>47</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GSW</td>\n",
       "      <td>GSW vs. BOS</td>\n",
       "      <td>06/12/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>104</td>\n",
       "      <td>41</td>\n",
       "      <td>88</td>\n",
       "      <td>46.6</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>86.7</td>\n",
       "      <td>4</td>\n",
       "      <td>35</td>\n",
       "      <td>39</td>\n",
       "      <td>23</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>28</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BOS</td>\n",
       "      <td>BOS vs. GSW</td>\n",
       "      <td>06/09/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>97</td>\n",
       "      <td>34</td>\n",
       "      <td>85</td>\n",
       "      <td>40.0</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>73.7</td>\n",
       "      <td>11</td>\n",
       "      <td>31</td>\n",
       "      <td>42</td>\n",
       "      <td>22</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>17</td>\n",
       "      <td>-10</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>169</th>\n",
       "      <td>TOR</td>\n",
       "      <td>TOR @ PHI</td>\n",
       "      <td>04/15/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>111</td>\n",
       "      <td>40</td>\n",
       "      <td>82</td>\n",
       "      <td>48.8</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>82.6</td>\n",
       "      <td>7</td>\n",
       "      <td>28</td>\n",
       "      <td>35</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>26</td>\n",
       "      <td>-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>GSW</td>\n",
       "      <td>GSW vs. DEN</td>\n",
       "      <td>04/15/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>123</td>\n",
       "      <td>43</td>\n",
       "      <td>82</td>\n",
       "      <td>52.4</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>72.4</td>\n",
       "      <td>10</td>\n",
       "      <td>31</td>\n",
       "      <td>41</td>\n",
       "      <td>33</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>22</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>DEN</td>\n",
       "      <td>DEN @ GSW</td>\n",
       "      <td>04/15/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>107</td>\n",
       "      <td>43</td>\n",
       "      <td>93</td>\n",
       "      <td>46.2</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>76.9</td>\n",
       "      <td>9</td>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>26</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>22</td>\n",
       "      <td>-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>MEM</td>\n",
       "      <td>MEM vs. MIN</td>\n",
       "      <td>04/15/2022</td>\n",
       "      <td>L</td>\n",
       "      <td>240</td>\n",
       "      <td>117</td>\n",
       "      <td>39</td>\n",
       "      <td>86</td>\n",
       "      <td>45.3</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>74.4</td>\n",
       "      <td>8</td>\n",
       "      <td>27</td>\n",
       "      <td>35</td>\n",
       "      <td>25</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>MIN</td>\n",
       "      <td>MIN @ MEM</td>\n",
       "      <td>04/15/2022</td>\n",
       "      <td>W</td>\n",
       "      <td>240</td>\n",
       "      <td>130</td>\n",
       "      <td>45</td>\n",
       "      <td>90</td>\n",
       "      <td>50.0</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>88.9</td>\n",
       "      <td>11</td>\n",
       "      <td>35</td>\n",
       "      <td>46</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>19</td>\n",
       "      <td>32</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>174 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Team     Match Up   Game Date W/L  MIN  PTS  FGM  FGA   FG%  3PM  ...  \\\n",
       "0    BOS  BOS vs. GSW  06/15/2022   L  240   90   34   80  42.5   11  ...   \n",
       "1    GSW    GSW @ BOS  06/15/2022   W  240  103   38   92  41.3   19  ...   \n",
       "2    BOS    BOS @ GSW  06/12/2022   L  240   94   31   75  41.3   11  ...   \n",
       "3    GSW  GSW vs. BOS  06/12/2022   W  240  104   41   88  46.6    9  ...   \n",
       "4    BOS  BOS vs. GSW  06/09/2022   L  240   97   34   85  40.0   15  ...   \n",
       "..   ...          ...         ...  ..  ...  ...  ...  ...   ...  ...  ...   \n",
       "169  TOR    TOR @ PHI  04/15/2022   L  240  111   40   82  48.8   12  ...   \n",
       "170  GSW  GSW vs. DEN  04/15/2022   W  240  123   43   82  52.4   16  ...   \n",
       "171  DEN    DEN @ GSW  04/15/2022   L  240  107   43   93  46.2   11  ...   \n",
       "172  MEM  MEM vs. MIN  04/15/2022   L  240  117   39   86  45.3    7  ...   \n",
       "173  MIN    MIN @ MEM  04/15/2022   W  240  130   45   90  50.0   16  ...   \n",
       "\n",
       "       FT%  OREB  DREB  REB  AST  STL  BLK  TOV  PF  +/-  \n",
       "0     91.7    11    30   41   27    8    8   23  16  -13  \n",
       "1    100.0    15    29   44   27   13    7   17  20   13  \n",
       "2     67.7     8    39   47   18    2    2   18  16  -10  \n",
       "3     86.7     4    35   39   23    9    2    7  28   10  \n",
       "4     73.7    11    31   42   22    8    6   16  17  -10  \n",
       "..     ...   ...   ...  ...  ...  ...  ...  ...  ..  ...  \n",
       "169   82.6     7    28   35   27    1    8    8  26  -20  \n",
       "170   72.4    10    31   41   33    5    8   13  22   16  \n",
       "171   76.9     9    26   35   26    8    3   11  22  -16  \n",
       "172   74.4     8    27   35   25    7    8   12  24  -13  \n",
       "173   88.9    11    35   46   32    5    7   19  32   13  \n",
       "\n",
       "[174 rows x 24 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Pull the table into a DataFrame\n",
    "table_df = result[0]\n",
    "table_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop unnecessary columns\n",
    "table_df = table_df.drop(['Match Up', 'Game Date', 'W/L', 'FG%', '3P%', 'FT%'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Rename the columns to match the database schema\n",
    "table_df = table_df.rename(columns={\"Team\":\"team\"})\n",
    "table_df = table_df.rename(columns={\"MIN\":\"min\", \"PTS\":\"pts\", \"FGM\":\"fgm\"})\n",
    "table_df = table_df.rename(columns={\"FGA\":\"fga\", \"3PM\":\"threepm\", \"3PA\":\"threepa\", \"FTM\":\"ftm\", \"FTA\":\"fta\"})\n",
    "table_df = table_df.rename(columns={\"OREB\":\"oreb\", \"DREB\":\"dreb\", \"REB\":\"reb\", \"AST\":\"ast\", \"STL\":\"stl\"})\n",
    "table_df = table_df.rename(columns={\"BLK\":\"blk\", \"TOV\":\"tov\", \"PF\":\"pf\", \"+/-\":\"point_diff\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the dataframe into a csv file\n",
    "table_df.to_csv(\"Data/Scraped/NBA_Data_Playoffs_2022.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Close the web browser\n",
    "driver.quit()"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "8d393ceb9beff9defd2e1ce9364664e6dc8a0e675a073d816344ce1665b4fead"
  },
  "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.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}