nba_pbp_scrape.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9c4f1a06",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pylsp "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0d92e0d2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Application directory:   C:\\Users\\Shared.Westover\\AppData\\Local\\anaconda3\\share\\jupyter\\lab\n",
      "User Settings directory: C:\\Users\\Shared.Westover\\.jupyter\\lab\\user-settings\n",
      "Workspaces directory: C:\\Users\\Shared.Westover\\.jupyter\\lab\\workspaces\n"
     ]
    }
   ],
   "source": [
    "!jupyter lab path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "918869dc",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>team_id</th>\n",
       "      <th>team_abbreviation</th>\n",
       "      <th>team_city</th>\n",
       "      <th>player_id</th>\n",
       "      <th>player_name</th>\n",
       "      <th>nickname</th>\n",
       "      <th>start_position</th>\n",
       "      <th>comment</th>\n",
       "      <th>min</th>\n",
       "      <th>...</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>to</th>\n",
       "      <th>pf</th>\n",
       "      <th>pts</th>\n",
       "      <th>plus_minus</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203090</td>\n",
       "      <td>Maurice Harkless</td>\n",
       "      <td>Maurice</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>16.000000:47</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>202329</td>\n",
       "      <td>Al-Farouq Aminu</td>\n",
       "      <td>Al-Farouq</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>7.000000:08</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>202683</td>\n",
       "      <td>Enes Freedom</td>\n",
       "      <td>Enes</td>\n",
       "      <td>C</td>\n",
       "      <td></td>\n",
       "      <td>39.000000:39</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203468</td>\n",
       "      <td>CJ McCollum</td>\n",
       "      <td>CJ</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>45.000000:17</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203081</td>\n",
       "      <td>Damian Lillard</td>\n",
       "      <td>Damian</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>45.000000:25</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>1628380</td>\n",
       "      <td>Zach Collins</td>\n",
       "      <td>Zach</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>23.000000:17</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203918</td>\n",
       "      <td>Rodney Hood</td>\n",
       "      <td>Rodney</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>20.000000:11</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203552</td>\n",
       "      <td>Seth Curry</td>\n",
       "      <td>Seth</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>16.000000:20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>202323</td>\n",
       "      <td>Evan Turner</td>\n",
       "      <td>Evan</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>19.000000:12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203086</td>\n",
       "      <td>Meyers Leonard</td>\n",
       "      <td>Meyers</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>6.000000:44</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>1627746</td>\n",
       "      <td>Skal Labissiere</td>\n",
       "      <td>Skal</td>\n",
       "      <td></td>\n",
       "      <td>DNP - Coach's Decision</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>1627774</td>\n",
       "      <td>Jake Layman</td>\n",
       "      <td>Jake</td>\n",
       "      <td></td>\n",
       "      <td>DNP - Coach's Decision</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>1629014</td>\n",
       "      <td>Anfernee Simons</td>\n",
       "      <td>Anfernee</td>\n",
       "      <td></td>\n",
       "      <td>DNP - Coach's Decision</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1628470</td>\n",
       "      <td>Torrey Craig</td>\n",
       "      <td>Torrey</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>33.000000:01</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>200794</td>\n",
       "      <td>Paul Millsap</td>\n",
       "      <td>Paul</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>31.000000:55</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>203999</td>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>Nikola</td>\n",
       "      <td>C</td>\n",
       "      <td></td>\n",
       "      <td>41.000000:53</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>203914</td>\n",
       "      <td>Gary Harris</td>\n",
       "      <td>Gary</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>39.000000:10</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>-7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1627750</td>\n",
       "      <td>Jamal Murray</td>\n",
       "      <td>Jamal</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>37.000000:53</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>203486</td>\n",
       "      <td>Mason Plumlee</td>\n",
       "      <td>Mason</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>18.000000:48</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>203115</td>\n",
       "      <td>Will Barton</td>\n",
       "      <td>Will</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>19.000000:58</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>-9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1627736</td>\n",
       "      <td>Malik Beasley</td>\n",
       "      <td>Malik</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>7.000000:15</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1628420</td>\n",
       "      <td>Monte Morris</td>\n",
       "      <td>Monte</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>10.000000:07</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1627823</td>\n",
       "      <td>Juancho Hernangomez</td>\n",
       "      <td>Juancho</td>\n",
       "      <td></td>\n",
       "      <td>DNP - Coach's Decision</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1626168</td>\n",
       "      <td>Trey Lyles</td>\n",
       "      <td>Trey</td>\n",
       "      <td></td>\n",
       "      <td>DNP - Coach's Decision</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>202738</td>\n",
       "      <td>Isaiah Thomas</td>\n",
       "      <td>Isaiah</td>\n",
       "      <td></td>\n",
       "      <td>DNP - Coach's Decision</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1629020</td>\n",
       "      <td>Jarred Vanderbilt</td>\n",
       "      <td>Jarred</td>\n",
       "      <td></td>\n",
       "      <td>DNP - Coach's Decision</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>26 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       game_id     team_id team_abbreviation team_city  player_id  \\\n",
       "0   0041800237  1610612757               POR  Portland     203090   \n",
       "1   0041800237  1610612757               POR  Portland     202329   \n",
       "2   0041800237  1610612757               POR  Portland     202683   \n",
       "3   0041800237  1610612757               POR  Portland     203468   \n",
       "4   0041800237  1610612757               POR  Portland     203081   \n",
       "5   0041800237  1610612757               POR  Portland    1628380   \n",
       "6   0041800237  1610612757               POR  Portland     203918   \n",
       "7   0041800237  1610612757               POR  Portland     203552   \n",
       "8   0041800237  1610612757               POR  Portland     202323   \n",
       "9   0041800237  1610612757               POR  Portland     203086   \n",
       "10  0041800237  1610612757               POR  Portland    1627746   \n",
       "11  0041800237  1610612757               POR  Portland    1627774   \n",
       "12  0041800237  1610612757               POR  Portland    1629014   \n",
       "13  0041800237  1610612743               DEN    Denver    1628470   \n",
       "14  0041800237  1610612743               DEN    Denver     200794   \n",
       "15  0041800237  1610612743               DEN    Denver     203999   \n",
       "16  0041800237  1610612743               DEN    Denver     203914   \n",
       "17  0041800237  1610612743               DEN    Denver    1627750   \n",
       "18  0041800237  1610612743               DEN    Denver     203486   \n",
       "19  0041800237  1610612743               DEN    Denver     203115   \n",
       "20  0041800237  1610612743               DEN    Denver    1627736   \n",
       "21  0041800237  1610612743               DEN    Denver    1628420   \n",
       "22  0041800237  1610612743               DEN    Denver    1627823   \n",
       "23  0041800237  1610612743               DEN    Denver    1626168   \n",
       "24  0041800237  1610612743               DEN    Denver     202738   \n",
       "25  0041800237  1610612743               DEN    Denver    1629020   \n",
       "\n",
       "            player_name   nickname start_position                 comment  \\\n",
       "0      Maurice Harkless    Maurice              F                           \n",
       "1       Al-Farouq Aminu  Al-Farouq              F                           \n",
       "2          Enes Freedom       Enes              C                           \n",
       "3           CJ McCollum         CJ              G                           \n",
       "4        Damian Lillard     Damian              G                           \n",
       "5          Zach Collins       Zach                                          \n",
       "6           Rodney Hood     Rodney                                          \n",
       "7            Seth Curry       Seth                                          \n",
       "8           Evan Turner       Evan                                          \n",
       "9        Meyers Leonard     Meyers                                          \n",
       "10      Skal Labissiere       Skal                 DNP - Coach's Decision   \n",
       "11          Jake Layman       Jake                 DNP - Coach's Decision   \n",
       "12      Anfernee Simons   Anfernee                 DNP - Coach's Decision   \n",
       "13         Torrey Craig     Torrey              F                           \n",
       "14         Paul Millsap       Paul              F                           \n",
       "15         Nikola Jokic     Nikola              C                           \n",
       "16          Gary Harris       Gary              G                           \n",
       "17         Jamal Murray      Jamal              G                           \n",
       "18        Mason Plumlee      Mason                                          \n",
       "19          Will Barton       Will                                          \n",
       "20        Malik Beasley      Malik                                          \n",
       "21         Monte Morris      Monte                                          \n",
       "22  Juancho Hernangomez    Juancho                 DNP - Coach's Decision   \n",
       "23           Trey Lyles       Trey                 DNP - Coach's Decision   \n",
       "24        Isaiah Thomas     Isaiah                 DNP - Coach's Decision   \n",
       "25    Jarred Vanderbilt     Jarred                 DNP - Coach's Decision   \n",
       "\n",
       "             min  ...  oreb  dreb   reb  ast  stl  blk   to   pf   pts  \\\n",
       "0   16.000000:47  ...   3.0   2.0   5.0  3.0  1.0  1.0  0.0  5.0   6.0   \n",
       "1    7.000000:08  ...   0.0   3.0   3.0  0.0  0.0  0.0  1.0  1.0   3.0   \n",
       "2   39.000000:39  ...   4.0   8.0  12.0  1.0  0.0  0.0  1.0  3.0  12.0   \n",
       "3   45.000000:17  ...   1.0   8.0   9.0  1.0  1.0  1.0  0.0  1.0  37.0   \n",
       "4   45.000000:25  ...   0.0  10.0  10.0  8.0  3.0  0.0  1.0  3.0  13.0   \n",
       "5   23.000000:17  ...   2.0   4.0   6.0  1.0  0.0  4.0  1.0  5.0   7.0   \n",
       "6   20.000000:11  ...   0.0   3.0   3.0  0.0  0.0  0.0  0.0  1.0   6.0   \n",
       "7   16.000000:20  ...   0.0   0.0   0.0  0.0  0.0  0.0  0.0  5.0   0.0   \n",
       "8   19.000000:12  ...   2.0   5.0   7.0  2.0  0.0  1.0  0.0  4.0  14.0   \n",
       "9    6.000000:44  ...   0.0   0.0   0.0  0.0  0.0  0.0  0.0  3.0   2.0   \n",
       "10          None  ...   NaN   NaN   NaN  NaN  NaN  NaN  NaN  NaN   NaN   \n",
       "11          None  ...   NaN   NaN   NaN  NaN  NaN  NaN  NaN  NaN   NaN   \n",
       "12          None  ...   NaN   NaN   NaN  NaN  NaN  NaN  NaN  NaN   NaN   \n",
       "13  33.000000:01  ...   4.0   4.0   8.0  2.0  0.0  0.0  1.0  2.0   8.0   \n",
       "14  31.000000:55  ...   1.0   6.0   7.0  1.0  0.0  3.0  0.0  6.0  10.0   \n",
       "15  41.000000:53  ...   4.0   9.0  13.0  2.0  0.0  4.0  2.0  3.0  29.0   \n",
       "16  39.000000:10  ...   0.0   6.0   6.0  3.0  0.0  0.0  1.0  3.0  15.0   \n",
       "17  37.000000:53  ...   2.0   4.0   6.0  5.0  0.0  0.0  1.0  1.0  17.0   \n",
       "18  18.000000:48  ...   1.0   5.0   6.0  0.0  0.0  2.0  0.0  3.0   4.0   \n",
       "19  19.000000:58  ...   1.0   2.0   3.0  1.0  0.0  0.0  0.0  3.0   8.0   \n",
       "20   7.000000:15  ...   0.0   0.0   0.0  0.0  0.0  0.0  0.0  1.0   0.0   \n",
       "21  10.000000:07  ...   0.0   2.0   2.0  1.0  1.0  0.0  0.0  1.0   5.0   \n",
       "22          None  ...   NaN   NaN   NaN  NaN  NaN  NaN  NaN  NaN   NaN   \n",
       "23          None  ...   NaN   NaN   NaN  NaN  NaN  NaN  NaN  NaN   NaN   \n",
       "24          None  ...   NaN   NaN   NaN  NaN  NaN  NaN  NaN  NaN   NaN   \n",
       "25          None  ...   NaN   NaN   NaN  NaN  NaN  NaN  NaN  NaN   NaN   \n",
       "\n",
       "    plus_minus  \n",
       "0         -8.0  \n",
       "1         -7.0  \n",
       "2          1.0  \n",
       "3          6.0  \n",
       "4          8.0  \n",
       "5          5.0  \n",
       "6         -2.0  \n",
       "7          7.0  \n",
       "8          1.0  \n",
       "9          9.0  \n",
       "10         NaN  \n",
       "11         NaN  \n",
       "12         NaN  \n",
       "13         6.0  \n",
       "14         3.0  \n",
       "15        -1.0  \n",
       "16        -7.0  \n",
       "17        -2.0  \n",
       "18        -7.0  \n",
       "19        -9.0  \n",
       "20        -1.0  \n",
       "21        -2.0  \n",
       "22         NaN  \n",
       "23         NaN  \n",
       "24         NaN  \n",
       "25         NaN  \n",
       "\n",
       "[26 rows x 29 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd\n",
    "import re\n",
    "import numpy as np\n",
    "import os\n",
    "import datetime as dt\n",
    "\n",
    "box_url = 'https://stats.nba.com/stats/boxscoretraditionalv2?EndPeriod=10&EndRange=28800&GameID=0041800237&RangeType=0&Season=2018-19&SeasonType=Playoffs&StartPeriod=1&StartRange=0'\n",
    "headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64)', 'x-nba-stats-origin': 'stats', 'x-nba-stats-token': 'true', 'Host':'stats.nba.com', 'Referer':'https://stats.nba.com/game/0021900306/'}\n",
    "r= requests.get(box_url, headers=headers, timeout = 7)\n",
    "data = json.loads(r.text)\n",
    "box = pd.DataFrame.from_dict(data['resultSets'][0]['rowSet'])\n",
    "col_names = data['resultSets'][0]['headers']\n",
    "box.columns = col_names\n",
    "box.columns = box.columns.str.lower()\n",
    "box"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "063faf62",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Shared.Westover\\AppData\\Local\\Temp\\ipykernel_3432\\1990449281.py:9: FutureWarning: In a future version of pandas all arguments of StringMethods.split except for the argument 'pat' will be keyword-only.\n",
      "  pbp_times = pbp['pctimestring'].str.split(':',2, expand=True)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>eventnum</th>\n",
       "      <th>eventmsgtype</th>\n",
       "      <th>eventmsgactiontype</th>\n",
       "      <th>period</th>\n",
       "      <th>wctimestring</th>\n",
       "      <th>pctimestring</th>\n",
       "      <th>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>...</th>\n",
       "      <th>player3_team_id</th>\n",
       "      <th>player3_team_city</th>\n",
       "      <th>player3_team_nickname</th>\n",
       "      <th>player3_team_abbreviation</th>\n",
       "      <th>video_available_flag</th>\n",
       "      <th>timeinseconds</th>\n",
       "      <th>play_elapsed_time</th>\n",
       "      <th>total_elapsed_time</th>\n",
       "      <th>max_time</th>\n",
       "      <th>time_remaining</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3:41 PM</td>\n",
       "      <td>12:00</td>\n",
       "      <td>None</td>\n",
       "      <td>Start of 1st Period (3:41 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>720</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2880.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3:41 PM</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Jump Ball Millsap vs. Kanter: Tip to Harkless</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>Portland</td>\n",
       "      <td>Trail Blazers</td>\n",
       "      <td>POR</td>\n",
       "      <td>1</td>\n",
       "      <td>720</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2880.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>3:41 PM</td>\n",
       "      <td>11:45</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Charge Foul (P1.T1) (J.Goble)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>705</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2865.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>3:41 PM</td>\n",
       "      <td>11:45</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Foul Turnover (P1.T1)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>705</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2865.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3:42 PM</td>\n",
       "      <td>11:28</td>\n",
       "      <td>Harris 2' Driving Layup (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>688</td>\n",
       "      <td>17.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2848.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      game_id  eventnum  eventmsgtype  eventmsgactiontype  period  \\\n",
       "0  0041800237         2            12                   0       1   \n",
       "1  0041800237         4            10                   0       1   \n",
       "2  0041800237         7             6                  26       1   \n",
       "3  0041800237         9             5                  37       1   \n",
       "4  0041800237        10             1                   6       1   \n",
       "\n",
       "  wctimestring pctimestring                                homedescription  \\\n",
       "0      3:41 PM        12:00                                           None   \n",
       "1      3:41 PM        12:00  Jump Ball Millsap vs. Kanter: Tip to Harkless   \n",
       "2      3:41 PM        11:45                                           None   \n",
       "3      3:41 PM        11:45                                           None   \n",
       "4      3:42 PM        11:28                Harris 2' Driving Layup (2 PTS)   \n",
       "\n",
       "                  neutraldescription  \\\n",
       "0  Start of 1st Period (3:41 PM EST)   \n",
       "1                               None   \n",
       "2                               None   \n",
       "3                               None   \n",
       "4                               None   \n",
       "\n",
       "                              visitordescription  ... player3_team_id  \\\n",
       "0                                           None  ...             NaN   \n",
       "1                                           None  ...    1.610613e+09   \n",
       "2  Aminu Offensive Charge Foul (P1.T1) (J.Goble)  ...             NaN   \n",
       "3          Aminu Offensive Foul Turnover (P1.T1)  ...             NaN   \n",
       "4                                           None  ...             NaN   \n",
       "\n",
       "   player3_team_city  player3_team_nickname  player3_team_abbreviation  \\\n",
       "0               None                   None                       None   \n",
       "1           Portland          Trail Blazers                        POR   \n",
       "2               None                   None                       None   \n",
       "3               None                   None                       None   \n",
       "4               None                   None                       None   \n",
       "\n",
       "  video_available_flag  timeinseconds play_elapsed_time total_elapsed_time  \\\n",
       "0                    0            720               0.0                0.0   \n",
       "1                    1            720               0.0                0.0   \n",
       "2                    1            705              15.0               15.0   \n",
       "3                    1            705               0.0               15.0   \n",
       "4                    1            688              17.0               32.0   \n",
       "\n",
       "  max_time  time_remaining  \n",
       "0   2880.0          2880.0  \n",
       "1   2880.0          2880.0  \n",
       "2   2880.0          2865.0  \n",
       "3   2880.0          2865.0  \n",
       "4   2880.0          2848.0  \n",
       "\n",
       "[5 rows x 39 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbp_url = 'https://stats.nba.com/stats/playbyplayv2?EndPeriod=10&EndRange=55800&GameID=0041800237&RangeType=2&Season=2018-19&SeasonType=Playoffs&StartPeriod=1&StartRange=0'\n",
    "headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64)', 'x-nba-stats-origin': 'stats', 'x-nba-stats-token': 'true', 'Host':'stats.nba.com', 'Referer':'https://stats.nba.com/game/0021900306/'}\n",
    "r= requests.get(pbp_url, headers=headers, timeout = 5)\n",
    "data = json.loads(r.text)\n",
    "pbp = pd.DataFrame.from_dict(data['resultSets'][0]['rowSet'])\n",
    "col_names = data['resultSets'][0]['headers']\n",
    "pbp.columns = col_names\n",
    "pbp.columns = pbp.columns.str.lower()\n",
    "pbp_times = pbp['pctimestring'].str.split(':',2, expand=True)\n",
    "pbp_times[0] = pbp_times[0].astype(str).astype(int)\n",
    "pbp_times[1] = pbp_times[1].astype(str).astype(int)\n",
    "pbp['timeinseconds'] = (pbp_times[0]*60) + pbp_times[1]\n",
    "pbp['play_elapsed_time'] = pbp['timeinseconds'].shift(1)  - pbp['timeinseconds'] \n",
    "pbp['play_elapsed_time'] = pbp['play_elapsed_time'].fillna(0)\n",
    "pbp['play_elapsed_time'] = np.where(pbp['period'] != pbp['period'].shift(1), 0, pbp['play_elapsed_time'])\n",
    "pbp['total_elapsed_time'] = pbp.groupby(['game_id'])['play_elapsed_time'].cumsum()\n",
    "pbp['max_time'] = pbp.groupby('game_id')['play_elapsed_time'].transform('sum')\n",
    "pbp['time_remaining'] = pbp['max_time'] - pbp['total_elapsed_time']\n",
    "pbp['scoremargin'] = np.where(pbp['scoremargin']=='TIE',0,pbp['scoremargin'])\n",
    "pbp['scoremargin'] = pbp['scoremargin'].fillna(0).astype(int)\n",
    "pbp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "46c27165",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['game_id', 'eventnum', 'eventmsgtype', 'eventmsgactiontype', 'period',\n",
       "       'pctimestring', 'homedescription', 'neutraldescription',\n",
       "       'visitordescription', 'score', 'scoremargin', 'person1type',\n",
       "       'player1_id', 'player1_name', 'player1_team_id',\n",
       "       'player1_team_abbreviation', 'person2type', 'player2_id',\n",
       "       'player2_name', 'player2_team_nickname', 'player2_team_abbreviation',\n",
       "       'person3type', 'player3_id', 'player3_name', 'player3_team_nickname',\n",
       "       'player3_team_abbreviation', 'timeinseconds', 'play_elapsed_time',\n",
       "       'total_elapsed_time', 'max_time', 'time_remaining'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbp = pbp[['game_id', 'eventnum', 'eventmsgtype', 'eventmsgactiontype', 'period',\n",
    "     'pctimestring', 'homedescription', 'neutraldescription',\n",
    "       'visitordescription', 'score', 'scoremargin', 'person1type',\n",
    "       'player1_id', 'player1_name', 'player1_team_id', 'player1_team_abbreviation', 'person2type',\n",
    "       'player2_id', 'player2_name', 'player2_team_nickname', 'player2_team_abbreviation', 'person3type',\n",
    "       'player3_id', 'player3_name',\n",
    "       'player3_team_nickname', 'player3_team_abbreviation',\n",
    "       'timeinseconds', 'play_elapsed_time',\n",
    "       'total_elapsed_time', 'max_time', 'time_remaining']]\n",
    "pbp.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "61f2a741",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "game_id                                            0041800237\n",
       "eventnum                                                   18\n",
       "eventmsgtype                                                2\n",
       "eventmsgactiontype                                         79\n",
       "period                                                      1\n",
       "pctimestring                                            10:13\n",
       "homedescription              MISS Murray 17' Pullup Jump Shot\n",
       "neutraldescription                                       None\n",
       "visitordescription                                       None\n",
       "score                                                    None\n",
       "scoremargin                                                 0\n",
       "person1type                                                 4\n",
       "player1_id                                            1627750\n",
       "player1_name                                     Jamal Murray\n",
       "player1_team_id                                  1610612743.0\n",
       "player1_team_abbreviation                                 DEN\n",
       "person2type                                                 0\n",
       "player2_id                                                  0\n",
       "player2_name                                             None\n",
       "player2_team_nickname                                    None\n",
       "player2_team_abbreviation                                None\n",
       "person3type                                                 0\n",
       "player3_id                                                  0\n",
       "player3_name                                             None\n",
       "player3_team_nickname                                    None\n",
       "player3_team_abbreviation                                None\n",
       "timeinseconds                                             613\n",
       "play_elapsed_time                                        20.0\n",
       "total_elapsed_time                                      107.0\n",
       "max_time                                               2880.0\n",
       "time_remaining                                         2773.0\n",
       "Name: 10, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbp.iloc[10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c079318e",
   "metadata": {},
   "outputs": [],
   "source": [
    "pbp2 = pbp.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "18517e6c",
   "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>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>score</th>\n",
       "      <th>scoremargin</th>\n",
       "      <th>person1type</th>\n",
       "      <th>player1_id</th>\n",
       "      <th>player1_name</th>\n",
       "      <th>player1_team_id</th>\n",
       "      <th>player1_team_abbreviation</th>\n",
       "      <th>person2type</th>\n",
       "      <th>player2_id</th>\n",
       "      <th>player2_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Charge Foul (P1.T1) (J.Goble)</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>202329</td>\n",
       "      <td>Al-Farouq Aminu</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>4</td>\n",
       "      <td>200794</td>\n",
       "      <td>Paul Millsap</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Foul Turnover (P1.T1)</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>202329</td>\n",
       "      <td>Al-Farouq Aminu</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Kanter S.FOUL (P1.T2) (J.Goble)</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>202683</td>\n",
       "      <td>Enes Freedom</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>4</td>\n",
       "      <td>203914</td>\n",
       "      <td>Gary Harris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 2' Driving Layup (2 PTS)</td>\n",
       "      <td>2 - 3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>203468</td>\n",
       "      <td>CJ McCollum</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)</td>\n",
       "      <td>4 - 5</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>202683</td>\n",
       "      <td>Enes Freedom</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>5</td>\n",
       "      <td>203081</td>\n",
       "      <td>Damian Lillard</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Turner Free Throw 1 of 2 (13 PTS)</td>\n",
       "      <td>99 - 96</td>\n",
       "      <td>-3</td>\n",
       "      <td>5</td>\n",
       "      <td>202323</td>\n",
       "      <td>Evan Turner</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>SUB: Kanter FOR Leonard</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>203086</td>\n",
       "      <td>Meyers Leonard</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>5</td>\n",
       "      <td>202683</td>\n",
       "      <td>Enes Freedom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>SUB: Harkless FOR Curry</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>203552</td>\n",
       "      <td>Seth Curry</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>5</td>\n",
       "      <td>203090</td>\n",
       "      <td>Maurice Harkless</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Turner Free Throw 2 of 2 (14 PTS)</td>\n",
       "      <td>100 - 96</td>\n",
       "      <td>-4</td>\n",
       "      <td>5</td>\n",
       "      <td>202323</td>\n",
       "      <td>Evan Turner</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Turner REBOUND (Off:2 Def:5)</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>202323</td>\n",
       "      <td>Evan Turner</td>\n",
       "      <td>1.610613e+09</td>\n",
       "      <td>POR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    homedescription neutraldescription  \\\n",
       "2              None               None   \n",
       "3              None               None   \n",
       "5              None               None   \n",
       "7              None               None   \n",
       "9              None               None   \n",
       "..              ...                ...   \n",
       "493            None               None   \n",
       "494            None               None   \n",
       "495            None               None   \n",
       "496            None               None   \n",
       "500            None               None   \n",
       "\n",
       "                                visitordescription     score  scoremargin  \\\n",
       "2    Aminu Offensive Charge Foul (P1.T1) (J.Goble)      None            0   \n",
       "3            Aminu Offensive Foul Turnover (P1.T1)      None            0   \n",
       "5                  Kanter S.FOUL (P1.T2) (J.Goble)      None            0   \n",
       "7                McCollum 2' Driving Layup (2 PTS)     2 - 3            1   \n",
       "9     Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)     4 - 5            1   \n",
       "..                                             ...       ...          ...   \n",
       "493              Turner Free Throw 1 of 2 (13 PTS)   99 - 96           -3   \n",
       "494                        SUB: Kanter FOR Leonard      None            0   \n",
       "495                        SUB: Harkless FOR Curry      None            0   \n",
       "496              Turner Free Throw 2 of 2 (14 PTS)  100 - 96           -4   \n",
       "500                   Turner REBOUND (Off:2 Def:5)      None            0   \n",
       "\n",
       "     person1type  player1_id     player1_name  player1_team_id  \\\n",
       "2              5      202329  Al-Farouq Aminu     1.610613e+09   \n",
       "3              5      202329  Al-Farouq Aminu     1.610613e+09   \n",
       "5              5      202683     Enes Freedom     1.610613e+09   \n",
       "7              5      203468      CJ McCollum     1.610613e+09   \n",
       "9              5      202683     Enes Freedom     1.610613e+09   \n",
       "..           ...         ...              ...              ...   \n",
       "493            5      202323      Evan Turner     1.610613e+09   \n",
       "494            5      203086   Meyers Leonard     1.610613e+09   \n",
       "495            5      203552       Seth Curry     1.610613e+09   \n",
       "496            5      202323      Evan Turner     1.610613e+09   \n",
       "500            5      202323      Evan Turner     1.610613e+09   \n",
       "\n",
       "    player1_team_abbreviation  person2type  player2_id      player2_name  \n",
       "2                         POR            4      200794      Paul Millsap  \n",
       "3                         POR            0           0              None  \n",
       "5                         POR            4      203914       Gary Harris  \n",
       "7                         POR            0           0              None  \n",
       "9                         POR            5      203081    Damian Lillard  \n",
       "..                        ...          ...         ...               ...  \n",
       "493                       POR            0           0              None  \n",
       "494                       POR            5      202683      Enes Freedom  \n",
       "495                       POR            5      203090  Maurice Harkless  \n",
       "496                       POR            0           0              None  \n",
       "500                       POR            0           0              None  \n",
       "\n",
       "[227 rows x 13 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbp2[['homedescription', 'neutraldescription',\n",
    "       'visitordescription', 'score', 'scoremargin', 'person1type',\n",
    "       'player1_id', 'player1_name', 'player1_team_id', 'player1_team_abbreviation', 'person2type',\n",
    "       'player2_id', 'player2_name']].loc[pbp2.person1type==5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "9bdeabd3",
   "metadata": {},
   "outputs": [],
   "source": [
    "def getQuarterStarters(quarter):\n",
    "    if quarter == 1:\n",
    "        start_range = 0\n",
    "        end_range = 50\n",
    "    elif quarter == 2:\n",
    "        start_range = 7201\n",
    "        end_range = 7493\n",
    "    elif quarter == 3:\n",
    "        start_range = 14410\n",
    "        end_range = 14640\n",
    "    elif quarter == 4:\n",
    "        start_range = 21621\n",
    "        end_range = 21913\n",
    "        \n",
    "    starters_url = 'https://stats.nba.com/stats/boxscoretraditionalv2?EndPeriod=14&GameID=0041800237&RangeType=2&Season=2018-19&SeasonType=Playoffs&StartPeriod=1&StartRange=' + str(start_range) + '&EndRange=' + str(end_range)\n",
    "    headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64)', 'x-nba-stats-origin': 'stats', 'x-nba-stats-token': 'true', 'Host':'stats.nba.com', 'Referer':'https://stats.nba.com/game/0021900306/'}\n",
    "    r= requests.get(starters_url, headers=headers, timeout = 5)\n",
    "    data = json.loads(r.text)\n",
    "    starters = pd.DataFrame.from_dict(data['resultSets'][0]['rowSet'])\n",
    "    col_names = data['resultSets'][0]['headers']\n",
    "    starters.columns = col_names\n",
    "    starters.columns = starters.columns.str.lower()\n",
    "    return starters[['game_id', 'team_id', 'team_abbreviation', 'player_id',\n",
    "       'player_name']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "3789d359",
   "metadata": {},
   "outputs": [],
   "source": [
    "pbp2['h_lineup'] = ''\n",
    "pbp2['a_lineup'] = ''\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "0dd52c89",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>team_id</th>\n",
       "      <th>team_abbreviation</th>\n",
       "      <th>team_city</th>\n",
       "      <th>player_id</th>\n",
       "      <th>player_name</th>\n",
       "      <th>nickname</th>\n",
       "      <th>start_position</th>\n",
       "      <th>comment</th>\n",
       "      <th>min</th>\n",
       "      <th>...</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>to</th>\n",
       "      <th>pf</th>\n",
       "      <th>pts</th>\n",
       "      <th>plus_minus</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203090</td>\n",
       "      <td>Maurice Harkless</td>\n",
       "      <td>Maurice</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>16.000000:47</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>202329</td>\n",
       "      <td>Al-Farouq Aminu</td>\n",
       "      <td>Al-Farouq</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>7.000000:08</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>202683</td>\n",
       "      <td>Enes Freedom</td>\n",
       "      <td>Enes</td>\n",
       "      <td>C</td>\n",
       "      <td></td>\n",
       "      <td>39.000000:39</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203468</td>\n",
       "      <td>CJ McCollum</td>\n",
       "      <td>CJ</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>45.000000:17</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612757</td>\n",
       "      <td>POR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>203081</td>\n",
       "      <td>Damian Lillard</td>\n",
       "      <td>Damian</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>45.000000:25</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1628470</td>\n",
       "      <td>Torrey Craig</td>\n",
       "      <td>Torrey</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>33.000000:01</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>200794</td>\n",
       "      <td>Paul Millsap</td>\n",
       "      <td>Paul</td>\n",
       "      <td>F</td>\n",
       "      <td></td>\n",
       "      <td>31.000000:55</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>203999</td>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>Nikola</td>\n",
       "      <td>C</td>\n",
       "      <td></td>\n",
       "      <td>41.000000:53</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>203914</td>\n",
       "      <td>Gary Harris</td>\n",
       "      <td>Gary</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>39.000000:10</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>-7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>1610612743</td>\n",
       "      <td>DEN</td>\n",
       "      <td>Denver</td>\n",
       "      <td>1627750</td>\n",
       "      <td>Jamal Murray</td>\n",
       "      <td>Jamal</td>\n",
       "      <td>G</td>\n",
       "      <td></td>\n",
       "      <td>37.000000:53</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       game_id     team_id team_abbreviation team_city  player_id  \\\n",
       "0   0041800237  1610612757               POR  Portland     203090   \n",
       "1   0041800237  1610612757               POR  Portland     202329   \n",
       "2   0041800237  1610612757               POR  Portland     202683   \n",
       "3   0041800237  1610612757               POR  Portland     203468   \n",
       "4   0041800237  1610612757               POR  Portland     203081   \n",
       "13  0041800237  1610612743               DEN    Denver    1628470   \n",
       "14  0041800237  1610612743               DEN    Denver     200794   \n",
       "15  0041800237  1610612743               DEN    Denver     203999   \n",
       "16  0041800237  1610612743               DEN    Denver     203914   \n",
       "17  0041800237  1610612743               DEN    Denver    1627750   \n",
       "\n",
       "         player_name   nickname start_position comment           min  ...  \\\n",
       "0   Maurice Harkless    Maurice              F          16.000000:47  ...   \n",
       "1    Al-Farouq Aminu  Al-Farouq              F           7.000000:08  ...   \n",
       "2       Enes Freedom       Enes              C          39.000000:39  ...   \n",
       "3        CJ McCollum         CJ              G          45.000000:17  ...   \n",
       "4     Damian Lillard     Damian              G          45.000000:25  ...   \n",
       "13      Torrey Craig     Torrey              F          33.000000:01  ...   \n",
       "14      Paul Millsap       Paul              F          31.000000:55  ...   \n",
       "15      Nikola Jokic     Nikola              C          41.000000:53  ...   \n",
       "16       Gary Harris       Gary              G          39.000000:10  ...   \n",
       "17      Jamal Murray      Jamal              G          37.000000:53  ...   \n",
       "\n",
       "    oreb  dreb   reb  ast  stl  blk   to   pf   pts  plus_minus  \n",
       "0    3.0   2.0   5.0  3.0  1.0  1.0  0.0  5.0   6.0        -8.0  \n",
       "1    0.0   3.0   3.0  0.0  0.0  0.0  1.0  1.0   3.0        -7.0  \n",
       "2    4.0   8.0  12.0  1.0  0.0  0.0  1.0  3.0  12.0         1.0  \n",
       "3    1.0   8.0   9.0  1.0  1.0  1.0  0.0  1.0  37.0         6.0  \n",
       "4    0.0  10.0  10.0  8.0  3.0  0.0  1.0  3.0  13.0         8.0  \n",
       "13   4.0   4.0   8.0  2.0  0.0  0.0  1.0  2.0   8.0         6.0  \n",
       "14   1.0   6.0   7.0  1.0  0.0  3.0  0.0  6.0  10.0         3.0  \n",
       "15   4.0   9.0  13.0  2.0  0.0  4.0  2.0  3.0  29.0        -1.0  \n",
       "16   0.0   6.0   6.0  3.0  0.0  0.0  1.0  3.0  15.0        -7.0  \n",
       "17   2.0   4.0   6.0  5.0  0.0  0.0  1.0  1.0  17.0        -2.0  \n",
       "\n",
       "[10 rows x 29 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "box.loc[box.start_position != '']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "acb46fcb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2 116\n",
      "3 244\n",
      "4 363\n"
     ]
    }
   ],
   "source": [
    "\n",
    "for idx, row in pbp2.iterrows():\n",
    "    if row.pctimestring == '12:00' and row.period != 1:\n",
    "        print(row.period,idx)\n",
    "        qstart = getQuarterStarters(row.period)\n",
    "        habr = qstart.team_abbreviation[0]\n",
    "        qstarth = qstart.loc[qstart.team_abbreviation == habr]\n",
    "        qstarta = qstart.loc[qstart.team_abbreviation != habr]\n",
    "        pbp2.at[idx,'h_lineup'] = qstarth.player_id.to_list()\n",
    "        pbp2.at[idx,'a_lineup'] = qstarta.player_id.to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d87f29e1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>eventnum</th>\n",
       "      <th>eventmsgtype</th>\n",
       "      <th>eventmsgactiontype</th>\n",
       "      <th>period</th>\n",
       "      <th>pctimestring</th>\n",
       "      <th>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>score</th>\n",
       "      <th>...</th>\n",
       "      <th>player3_name</th>\n",
       "      <th>player3_team_nickname</th>\n",
       "      <th>player3_team_abbreviation</th>\n",
       "      <th>timeinseconds</th>\n",
       "      <th>play_elapsed_time</th>\n",
       "      <th>total_elapsed_time</th>\n",
       "      <th>max_time</th>\n",
       "      <th>time_remaining</th>\n",
       "      <th>h_lineup</th>\n",
       "      <th>a_lineup</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>168</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>12:00</td>\n",
       "      <td>None</td>\n",
       "      <td>Start of 2nd Period (4:11 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>17 - 29</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>720</td>\n",
       "      <td>0.0</td>\n",
       "      <td>720.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2160.0</td>\n",
       "      <td>[203468, 1628380, 203918, 203552, 202323]</td>\n",
       "      <td>[200794, 203486, 203115, 1627736, 1628420]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>343</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>12:00</td>\n",
       "      <td>None</td>\n",
       "      <td>Start of 3rd Period (4:58 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>39 - 48</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>720</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1440.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>1440.0</td>\n",
       "      <td>[202683, 203468, 203081, 1628380, 203918]</td>\n",
       "      <td>[1628470, 200794, 203999, 203914, 1627750]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>509</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>12:00</td>\n",
       "      <td>None</td>\n",
       "      <td>Start of 4th Period (5:31 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>71 - 72</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>720</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2160.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>720.0</td>\n",
       "      <td>[203468, 203081, 1628380, 203552, 202323]</td>\n",
       "      <td>[200794, 203486, 203115, 1627736, 1628420]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_id  eventnum  eventmsgtype  eventmsgactiontype  period  \\\n",
       "116  0041800237       168            12                   0       2   \n",
       "244  0041800237       343            12                   0       3   \n",
       "363  0041800237       509            12                   0       4   \n",
       "\n",
       "    pctimestring homedescription                 neutraldescription  \\\n",
       "116        12:00            None  Start of 2nd Period (4:11 PM EST)   \n",
       "244        12:00            None  Start of 3rd Period (4:58 PM EST)   \n",
       "363        12:00            None  Start of 4th Period (5:31 PM EST)   \n",
       "\n",
       "    visitordescription    score  ...  player3_name  player3_team_nickname  \\\n",
       "116               None  17 - 29  ...          None                   None   \n",
       "244               None  39 - 48  ...          None                   None   \n",
       "363               None  71 - 72  ...          None                   None   \n",
       "\n",
       "     player3_team_abbreviation timeinseconds  play_elapsed_time  \\\n",
       "116                       None           720                0.0   \n",
       "244                       None           720                0.0   \n",
       "363                       None           720                0.0   \n",
       "\n",
       "    total_elapsed_time  max_time  time_remaining  \\\n",
       "116              720.0    2880.0          2160.0   \n",
       "244             1440.0    2880.0          1440.0   \n",
       "363             2160.0    2880.0           720.0   \n",
       "\n",
       "                                      h_lineup  \\\n",
       "116  [203468, 1628380, 203918, 203552, 202323]   \n",
       "244  [202683, 203468, 203081, 1628380, 203918]   \n",
       "363  [203468, 203081, 1628380, 203552, 202323]   \n",
       "\n",
       "                                       a_lineup  \n",
       "116  [200794, 203486, 203115, 1627736, 1628420]  \n",
       "244  [1628470, 200794, 203999, 203914, 1627750]  \n",
       "363  [200794, 203486, 203115, 1627736, 1628420]  \n",
       "\n",
       "[3 rows x 33 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbp2.loc[pbp2.h_lineup != '']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "bb58014e",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "game_id                                                      0041800237\n",
       "eventnum                                                              2\n",
       "eventmsgtype                                                         12\n",
       "eventmsgactiontype                                                    0\n",
       "period                                                                1\n",
       "pctimestring                                                      12:00\n",
       "homedescription                                                    None\n",
       "neutraldescription                    Start of 1st Period (3:41 PM EST)\n",
       "visitordescription                                                 None\n",
       "score                                                              None\n",
       "scoremargin                                                           0\n",
       "person1type                                                           0\n",
       "player1_id                                                            0\n",
       "player1_name                                                       None\n",
       "player1_team_id                                                     NaN\n",
       "player1_team_abbreviation                                          None\n",
       "person2type                                                           0\n",
       "player2_id                                                            0\n",
       "player2_name                                                       None\n",
       "player2_team_nickname                                              None\n",
       "player2_team_abbreviation                                          None\n",
       "person3type                                                           0\n",
       "player3_id                                                            0\n",
       "player3_name                                                       None\n",
       "player3_team_nickname                                              None\n",
       "player3_team_abbreviation                                          None\n",
       "timeinseconds                                                       720\n",
       "play_elapsed_time                                                   0.0\n",
       "total_elapsed_time                                                  0.0\n",
       "max_time                                                         2880.0\n",
       "time_remaining                                                   2880.0\n",
       "h_lineup                       [203090, 202329, 202683, 203468, 203081]\n",
       "a_lineup                     [1628470, 200794, 203999, 203914, 1627750]\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbp2['h_lineup'] = ''\n",
    "pbp2['a_lineup'] = ''\n",
    "starters = box.loc[box.start_position != ''].reset_index()['player_id'].to_list()\n",
    "pbp2.at[0,'h_lineup'] = starters[0:5]\n",
    "pbp2.at[0,'a_lineup'] = starters[5:]\n",
    "pbp2.at[1,'h_lineup'] = starters[0:5]\n",
    "pbp2.at[1,'a_lineup'] = starters[5:]\n",
    "pbp2.loc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "044e8d47",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'POR'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "box.team_abbreviation.unique()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "8e28bee8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "home DEN\n"
     ]
    }
   ],
   "source": [
    "class Game():\n",
    "    def __init__(self,pbp,box):\n",
    "        self.pbp = pbp\n",
    "        self.box = box\n",
    "        self.hteam = self.box.team_abbreviation.unique()[1]\n",
    "        self.ateam = self.box.team_abbreviation.unique()[0]\n",
    "        self.pbp['h_lineup'] = ''\n",
    "        self.pbp['a_lineup'] = ''\n",
    "        \n",
    "        \n",
    "    def parse_game(self):\n",
    "        #getting starters from boxscore df\n",
    "        print('home',self.hteam)\n",
    "        self.h_starters = self.box.loc[(self.box.start_position != '') & \n",
    "                                       (self.box.team_abbreviation == self.hteam)].reset_index()['player_id'].to_list()\n",
    "        self.h_starters = sorted(self.h_starters)\n",
    "        self.a_starters = self.box.loc[(self.box.start_position != '') & \n",
    "                                       (self.box.team_abbreviation == self.ateam)].reset_index()['player_id'].to_list()\n",
    "        self.a_starters = sorted(self.a_starters)\n",
    "        #assigning starters to lineup for start of game\n",
    "        self.pbp.at[0,'h_lineup'] = self.h_starters\n",
    "        self.pbp.at[0,'a_lineup'] = self.a_starters\n",
    "        self.pbp.at[1,'h_lineup'] = self.h_starters\n",
    "        self.pbp.at[1,'a_lineup'] = self.a_starters\n",
    "        #assigning quarter starters from quarter box scores\n",
    "        for idx, row in pbp2.iterrows():\n",
    "            if row.pctimestring == '12:00' and row.period != 1:\n",
    "                qstart = getQuarterStarters(row.period)\n",
    "                qstarth = qstart.loc[qstart.team_abbreviation == self.hteam]\n",
    "                qstarta = qstart.loc[qstart.team_abbreviation != self.hteam]\n",
    "                self.pbp.at[idx,'h_lineup'] = sorted(qstarth.player_id.to_list())\n",
    "                self.pbp.at[idx,'a_lineup'] = sorted(qstarta.player_id.to_list())\n",
    "        \n",
    "        prev_h_lineup = self.h_starters.copy()  # Initialize with the starting lineup\n",
    "        prev_a_lineup = self.a_starters.copy()  # Initialize with the starting lineup\n",
    "\n",
    "        for idx, row in self.pbp.iterrows():\n",
    "            if row.pctimestring == '12:00':\n",
    "                h_lineup = sorted(row['h_lineup'])  # Use the existing lineup for the beginning of the quarter\n",
    "                a_lineup = sorted(row['a_lineup'])  # Use the existing lineup for the beginning of the quarter\n",
    "            else:\n",
    "                h_lineup = prev_h_lineup.copy()  # Create a copy of the previous h_lineup\n",
    "                a_lineup = prev_a_lineup.copy()  # Create a copy of the previous a_lineup\n",
    "\n",
    "                if isinstance(row['homedescription'], str) and row['homedescription'].startswith('SUB'):\n",
    "                    h_lineup.remove(row['player1_id'])\n",
    "                    h_lineup.append(row['player2_id'])\n",
    "\n",
    "                if isinstance(row['visitordescription'], str) and row['visitordescription'].startswith('SUB'):\n",
    "                    a_lineup.remove(row['player1_id'])\n",
    "                    a_lineup.append(row['player2_id'])\n",
    "\n",
    "            self.pbp.at[idx, 'h_lineup'] = sorted(h_lineup)\n",
    "            self.pbp.at[idx, 'a_lineup'] = sorted(a_lineup)\n",
    "            prev_h_lineup = h_lineup  # Update the previous h_lineup for the next iteration\n",
    "            prev_a_lineup = a_lineup  # Update the previous a_lineup for the next iteration\n",
    "        self.pbp['a_lineup'] = self.pbp['a_lineup'].apply(lambda x: tuple(x))\n",
    "        self.pbp['h_lineup'] = self.pbp['h_lineup'].apply(lambda x: tuple(x))\n",
    "        return \n",
    "\n",
    "\n",
    "\n",
    "        \n",
    "    \n",
    "    \n",
    "x = Game(pbp,box)\n",
    "x.parse_game()\n",
    "#x.get_stats()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "06e9ea73",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([(202329, 202683, 203081, 203090, 203468),\n",
       "       (202683, 203081, 203090, 203468, 1628380),\n",
       "       (202683, 203081, 203468, 203918, 1628380),\n",
       "       (202683, 203081, 203552, 203918, 1628380),\n",
       "       (202323, 203468, 203552, 203918, 1628380),\n",
       "       (202323, 203081, 203468, 203552, 1628380),\n",
       "       (202683, 203081, 203468, 203552, 1628380),\n",
       "       (202323, 202683, 203081, 203468, 203918),\n",
       "       (202683, 203081, 203086, 203468, 203918),\n",
       "       (202323, 202683, 203081, 203468, 1628380),\n",
       "       (202323, 202683, 203081, 203090, 203468),\n",
       "       (202683, 203081, 203086, 203090, 203468),\n",
       "       (202323, 202683, 203081, 203468, 203552),\n",
       "       (202323, 203081, 203090, 203468, 203552),\n",
       "       (202683, 203081, 203090, 203468, 203552),\n",
       "       (202323, 203081, 203086, 203468, 203552)], dtype=object)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x.pbp.a_lineup.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "06b6f5b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "test = x.pbp.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "fc87e9fc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>eventnum</th>\n",
       "      <th>eventmsgtype</th>\n",
       "      <th>eventmsgactiontype</th>\n",
       "      <th>period</th>\n",
       "      <th>pctimestring</th>\n",
       "      <th>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>score</th>\n",
       "      <th>...</th>\n",
       "      <th>player3_name</th>\n",
       "      <th>player3_team_nickname</th>\n",
       "      <th>player3_team_abbreviation</th>\n",
       "      <th>timeinseconds</th>\n",
       "      <th>play_elapsed_time</th>\n",
       "      <th>total_elapsed_time</th>\n",
       "      <th>max_time</th>\n",
       "      <th>time_remaining</th>\n",
       "      <th>h_lineup</th>\n",
       "      <th>a_lineup</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12:00</td>\n",
       "      <td>None</td>\n",
       "      <td>Start of 1st Period (3:41 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>720</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Jump Ball Millsap vs. Kanter: Tip to Harkless</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>Maurice Harkless</td>\n",
       "      <td>Trail Blazers</td>\n",
       "      <td>POR</td>\n",
       "      <td>720</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>11:45</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Charge Foul (P1.T1) (J.Goble)</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>705</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2865.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>11:45</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Foul Turnover (P1.T1)</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>705</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2865.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:28</td>\n",
       "      <td>Harris 2' Driving Layup (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0 - 2</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>688</td>\n",
       "      <td>17.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2848.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</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>497</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>698</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0:08</td>\n",
       "      <td>NUGGETS Timeout: Regular (Full 7 Short 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2872.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(203486, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>699</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0:08</td>\n",
       "      <td>SUB: Barton FOR Plumlee</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2872.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>701</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>4</td>\n",
       "      <td>0:05</td>\n",
       "      <td>MISS Jokic 28' 3PT Turnaround Jump Shot</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2875.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>702</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0:01</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Turner REBOUND (Off:2 Def:5)</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2879.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>703</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0:00</td>\n",
       "      <td>None</td>\n",
       "      <td>End of 4th Period (6:14 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>100 - 96</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>502 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_id  eventnum  eventmsgtype  eventmsgactiontype  period  \\\n",
       "0    0041800237         2            12                   0       1   \n",
       "1    0041800237         4            10                   0       1   \n",
       "2    0041800237         7             6                  26       1   \n",
       "3    0041800237         9             5                  37       1   \n",
       "4    0041800237        10             1                   6       1   \n",
       "..          ...       ...           ...                 ...     ...   \n",
       "497  0041800237       698             9                   1       4   \n",
       "498  0041800237       699             8                   0       4   \n",
       "499  0041800237       701             2                  47       4   \n",
       "500  0041800237       702             4                   0       4   \n",
       "501  0041800237       703            13                   0       4   \n",
       "\n",
       "    pctimestring                                homedescription  \\\n",
       "0          12:00                                           None   \n",
       "1          12:00  Jump Ball Millsap vs. Kanter: Tip to Harkless   \n",
       "2          11:45                                           None   \n",
       "3          11:45                                           None   \n",
       "4          11:28                Harris 2' Driving Layup (2 PTS)   \n",
       "..           ...                                            ...   \n",
       "497         0:08      NUGGETS Timeout: Regular (Full 7 Short 0)   \n",
       "498         0:08                        SUB: Barton FOR Plumlee   \n",
       "499         0:05        MISS Jokic 28' 3PT Turnaround Jump Shot   \n",
       "500         0:01                                           None   \n",
       "501         0:00                                           None   \n",
       "\n",
       "                    neutraldescription  \\\n",
       "0    Start of 1st Period (3:41 PM EST)   \n",
       "1                                 None   \n",
       "2                                 None   \n",
       "3                                 None   \n",
       "4                                 None   \n",
       "..                                 ...   \n",
       "497                               None   \n",
       "498                               None   \n",
       "499                               None   \n",
       "500                               None   \n",
       "501    End of 4th Period (6:14 PM EST)   \n",
       "\n",
       "                                visitordescription     score  ...  \\\n",
       "0                                             None      None  ...   \n",
       "1                                             None      None  ...   \n",
       "2    Aminu Offensive Charge Foul (P1.T1) (J.Goble)      None  ...   \n",
       "3            Aminu Offensive Foul Turnover (P1.T1)      None  ...   \n",
       "4                                             None     0 - 2  ...   \n",
       "..                                             ...       ...  ...   \n",
       "497                                           None      None  ...   \n",
       "498                                           None      None  ...   \n",
       "499                                           None      None  ...   \n",
       "500                   Turner REBOUND (Off:2 Def:5)      None  ...   \n",
       "501                                           None  100 - 96  ...   \n",
       "\n",
       "         player3_name  player3_team_nickname  player3_team_abbreviation  \\\n",
       "0                None                   None                       None   \n",
       "1    Maurice Harkless          Trail Blazers                        POR   \n",
       "2                None                   None                       None   \n",
       "3                None                   None                       None   \n",
       "4                None                   None                       None   \n",
       "..                ...                    ...                        ...   \n",
       "497              None                   None                       None   \n",
       "498              None                   None                       None   \n",
       "499              None                   None                       None   \n",
       "500              None                   None                       None   \n",
       "501              None                   None                       None   \n",
       "\n",
       "    timeinseconds  play_elapsed_time total_elapsed_time  max_time  \\\n",
       "0             720                0.0                0.0    2880.0   \n",
       "1             720                0.0                0.0    2880.0   \n",
       "2             705               15.0               15.0    2880.0   \n",
       "3             705                0.0               15.0    2880.0   \n",
       "4             688               17.0               32.0    2880.0   \n",
       "..            ...                ...                ...       ...   \n",
       "497             8                0.0             2872.0    2880.0   \n",
       "498             8                0.0             2872.0    2880.0   \n",
       "499             5                3.0             2875.0    2880.0   \n",
       "500             1                4.0             2879.0    2880.0   \n",
       "501             0                1.0             2880.0    2880.0   \n",
       "\n",
       "     time_remaining                                    h_lineup  \\\n",
       "0            2880.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "1            2880.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "2            2865.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "3            2865.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "4            2848.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "..              ...                                         ...   \n",
       "497             8.0  (203486, 203914, 203999, 1627750, 1628470)   \n",
       "498             8.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "499             5.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "500             1.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "501             0.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "\n",
       "                                     a_lineup  \n",
       "0    (202329, 202683, 203081, 203090, 203468)  \n",
       "1    (202329, 202683, 203081, 203090, 203468)  \n",
       "2    (202329, 202683, 203081, 203090, 203468)  \n",
       "3    (202329, 202683, 203081, 203090, 203468)  \n",
       "4    (202329, 202683, 203081, 203090, 203468)  \n",
       "..                                        ...  \n",
       "497  (202323, 202683, 203081, 203090, 203468)  \n",
       "498  (202323, 202683, 203081, 203090, 203468)  \n",
       "499  (202323, 202683, 203081, 203090, 203468)  \n",
       "500  (202323, 202683, 203081, 203090, 203468)  \n",
       "501  (202323, 202683, 203081, 203090, 203468)  \n",
       "\n",
       "[502 rows x 33 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test['a_lineup'] = test['a_lineup'].apply(lambda x: tuple(x))\n",
    "test['h_lineup'] = test['h_lineup'].apply(lambda x: tuple(x))\n",
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "b776bcaa",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = x.pbp.copy(deep=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "03b59ed4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "game_id                                                      0041800237\n",
       "eventnum                                                             19\n",
       "eventmsgtype                                                          4\n",
       "eventmsgactiontype                                                    0\n",
       "period                                                                1\n",
       "pctimestring                                                      10:11\n",
       "homedescription                                                    None\n",
       "neutraldescription                                                 None\n",
       "visitordescription                        Lillard REBOUND (Off:0 Def:1)\n",
       "score                                                              None\n",
       "scoremargin                                                           0\n",
       "person1type                                                           5\n",
       "player1_id                                                       203081\n",
       "player1_name                                             Damian Lillard\n",
       "player1_team_id                                            1610612757.0\n",
       "player1_team_abbreviation                                           POR\n",
       "person2type                                                           0\n",
       "player2_id                                                            0\n",
       "player2_name                                                       None\n",
       "player2_team_nickname                                              None\n",
       "player2_team_abbreviation                                          None\n",
       "person3type                                                           0\n",
       "player3_id                                                            0\n",
       "player3_name                                                       None\n",
       "player3_team_nickname                                              None\n",
       "player3_team_abbreviation                                          None\n",
       "timeinseconds                                                       611\n",
       "play_elapsed_time                                                   2.0\n",
       "total_elapsed_time                                                109.0\n",
       "max_time                                                         2880.0\n",
       "time_remaining                                                   2771.0\n",
       "h_lineup                     (200794, 203914, 203999, 1627750, 1628470)\n",
       "a_lineup                       (202329, 202683, 203081, 203090, 203468)\n",
       "Name: 11, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[11]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "487230d6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>eventnum</th>\n",
       "      <th>eventmsgtype</th>\n",
       "      <th>eventmsgactiontype</th>\n",
       "      <th>period</th>\n",
       "      <th>pctimestring</th>\n",
       "      <th>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>score</th>\n",
       "      <th>...</th>\n",
       "      <th>player3_name</th>\n",
       "      <th>player3_team_nickname</th>\n",
       "      <th>player3_team_abbreviation</th>\n",
       "      <th>timeinseconds</th>\n",
       "      <th>play_elapsed_time</th>\n",
       "      <th>total_elapsed_time</th>\n",
       "      <th>max_time</th>\n",
       "      <th>time_remaining</th>\n",
       "      <th>h_lineup</th>\n",
       "      <th>a_lineup</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:28</td>\n",
       "      <td>Harris 2' Driving Layup (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0 - 2</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>688</td>\n",
       "      <td>17.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2848.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:12</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 2' Driving Layup (2 PTS)</td>\n",
       "      <td>2 - 3</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>672</td>\n",
       "      <td>16.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2832.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>10:52</td>\n",
       "      <td>Jokic 2' Turnaround Hook Shot (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2 - 5</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>652</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2812.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10:33</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)</td>\n",
       "      <td>4 - 5</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>633</td>\n",
       "      <td>19.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2793.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9:31</td>\n",
       "      <td>Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>4 - 9</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>571</td>\n",
       "      <td>7.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2731.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</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>465</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>649</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>4</td>\n",
       "      <td>2:11</td>\n",
       "      <td>Harris 1' Running Finger Roll Layup (15 PTS) (...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>94 - 91</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>131</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2749.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>654</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>4</td>\n",
       "      <td>1:43</td>\n",
       "      <td>Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>94 - 93</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>103</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2777.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>656</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>1:25</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 15' Pullup Jump Shot (35 PTS)</td>\n",
       "      <td>96 - 93</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>85</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2795.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>662</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>0:30</td>\n",
       "      <td>Murray 13' Pullup Jump Shot (17 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>96 - 95</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>30</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2850.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>668</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>0:12</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 16' Pullup Jump Shot (37 PTS)</td>\n",
       "      <td>98 - 95</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>12</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2868.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>(200794, 203115, 203914, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203468, 203552)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_id  eventnum  eventmsgtype  eventmsgactiontype  period  \\\n",
       "4    0041800237        10             1                   6       1   \n",
       "7    0041800237        14             1                   6       1   \n",
       "8    0041800237        15             1                  58       1   \n",
       "9    0041800237        16             1                   1       1   \n",
       "20   0041800237        30             1                   1       1   \n",
       "..          ...       ...           ...                 ...     ...   \n",
       "465  0041800237       649             1                  76       4   \n",
       "468  0041800237       654             1                  78       4   \n",
       "469  0041800237       656             1                  79       4   \n",
       "474  0041800237       662             1                  79       4   \n",
       "478  0041800237       668             1                  79       4   \n",
       "\n",
       "    pctimestring                                    homedescription  \\\n",
       "4          11:28                    Harris 2' Driving Layup (2 PTS)   \n",
       "7          11:12                                               None   \n",
       "8          10:52              Jokic 2' Turnaround Hook Shot (2 PTS)   \n",
       "9          10:33                                               None   \n",
       "20          9:31     Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)   \n",
       "..           ...                                                ...   \n",
       "465         2:11  Harris 1' Running Finger Roll Layup (15 PTS) (...   \n",
       "468         1:43  Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...   \n",
       "469         1:25                                               None   \n",
       "474         0:30               Murray 13' Pullup Jump Shot (17 PTS)   \n",
       "478         0:12                                               None   \n",
       "\n",
       "    neutraldescription                            visitordescription    score  \\\n",
       "4                 None                                          None    0 - 2   \n",
       "7                 None             McCollum 2' Driving Layup (2 PTS)    2 - 3   \n",
       "8                 None                                          None    2 - 5   \n",
       "9                 None  Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)    4 - 5   \n",
       "20                None                                          None    4 - 9   \n",
       "..                 ...                                           ...      ...   \n",
       "465               None                                          None  94 - 91   \n",
       "468               None                                          None  94 - 93   \n",
       "469               None        McCollum 15' Pullup Jump Shot (35 PTS)  96 - 93   \n",
       "474               None                                          None  96 - 95   \n",
       "478               None        McCollum 16' Pullup Jump Shot (37 PTS)  98 - 95   \n",
       "\n",
       "     ...  player3_name  player3_team_nickname  player3_team_abbreviation  \\\n",
       "4    ...          None                   None                       None   \n",
       "7    ...          None                   None                       None   \n",
       "8    ...          None                   None                       None   \n",
       "9    ...          None                   None                       None   \n",
       "20   ...          None                   None                       None   \n",
       "..   ...           ...                    ...                        ...   \n",
       "465  ...          None                   None                       None   \n",
       "468  ...          None                   None                       None   \n",
       "469  ...          None                   None                       None   \n",
       "474  ...          None                   None                       None   \n",
       "478  ...          None                   None                       None   \n",
       "\n",
       "    timeinseconds  play_elapsed_time total_elapsed_time  max_time  \\\n",
       "4             688               17.0               32.0    2880.0   \n",
       "7             672               16.0               48.0    2880.0   \n",
       "8             652               20.0               68.0    2880.0   \n",
       "9             633               19.0               87.0    2880.0   \n",
       "20            571                7.0              149.0    2880.0   \n",
       "..            ...                ...                ...       ...   \n",
       "465           131                4.0             2749.0    2880.0   \n",
       "468           103                9.0             2777.0    2880.0   \n",
       "469            85               18.0             2795.0    2880.0   \n",
       "474            30               16.0             2850.0    2880.0   \n",
       "478            12               17.0             2868.0    2880.0   \n",
       "\n",
       "     time_remaining                                    h_lineup  \\\n",
       "4            2848.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "7            2832.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "8            2812.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "9            2793.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "20           2731.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "..              ...                                         ...   \n",
       "465           131.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "468           103.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "469            85.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "474            30.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "478            12.0  (200794, 203115, 203914, 1627750, 1628470)   \n",
       "\n",
       "                                     a_lineup  \n",
       "4    (202329, 202683, 203081, 203090, 203468)  \n",
       "7    (202329, 202683, 203081, 203090, 203468)  \n",
       "8    (202329, 202683, 203081, 203090, 203468)  \n",
       "9    (202329, 202683, 203081, 203090, 203468)  \n",
       "20   (202329, 202683, 203081, 203090, 203468)  \n",
       "..                                        ...  \n",
       "465  (202323, 202683, 203081, 203090, 203468)  \n",
       "468  (202323, 202683, 203081, 203090, 203468)  \n",
       "469  (202323, 202683, 203081, 203090, 203468)  \n",
       "474  (202323, 202683, 203081, 203090, 203468)  \n",
       "478  (202323, 202683, 203081, 203468, 203552)  \n",
       "\n",
       "[71 rows x 33 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df.eventmsgtype==1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "5eeb9d9f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([  0,   1,   2,   3,   5,   6,   7,   9,  10,  11,  12,  13,  14,\n",
       "        15,  26,  28,  37,  41,  44,  45,  47,  50,  58,  63,  66,  71,\n",
       "        72,  73,  74,  75,  76,  78,  79,  80,  86,  96,  97,  98, 101,\n",
       "       102, 107, 108], dtype=int64)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.sort(df.eventmsgactiontype.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "2a5a5457",
   "metadata": {},
   "outputs": [],
   "source": [
    "#eventmsgtype mapping\n",
    "eventdict = {1:'FGM',\n",
    "             2:'FGA',\n",
    "             3:'FTA',\n",
    "             4:'TRB',\n",
    "             5:'TURNOVER',\n",
    "             6:'FOUL',\n",
    "             8:'SUB',\n",
    "             9:'TIMEOUT',\n",
    "             10:'JUMP_BALL',\n",
    "             12:'Q_START',\n",
    "             13:'Q_END',\n",
    "             18:'REPLAY'             \n",
    "            }"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "8dd4d6ed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['game_id', 'eventnum', 'eventmsgtype', 'eventmsgactiontype', 'period',\n",
       "       'pctimestring', 'homedescription', 'neutraldescription',\n",
       "       'visitordescription', 'score', 'scoremargin', 'person1type',\n",
       "       'player1_id', 'player1_name', 'player1_team_id',\n",
       "       'player1_team_abbreviation', 'person2type', 'player2_id',\n",
       "       'player2_name', 'player2_team_nickname', 'player2_team_abbreviation',\n",
       "       'person3type', 'player3_id', 'player3_name', 'player3_team_nickname',\n",
       "       'player3_team_abbreviation', 'timeinseconds', 'play_elapsed_time',\n",
       "       'total_elapsed_time', 'max_time', 'time_remaining', 'h_lineup',\n",
       "       'a_lineup'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "06a54b46",
   "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>homedescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>player1_name</th>\n",
       "      <th>player2_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Harris 2' Driving Layup (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>Gary Harris</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 2' Driving Layup (2 PTS)</td>\n",
       "      <td>CJ McCollum</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Jokic 2' Turnaround Hook Shot (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>None</td>\n",
       "      <td>Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)</td>\n",
       "      <td>Enes Freedom</td>\n",
       "      <td>Damian Lillard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)</td>\n",
       "      <td>None</td>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>Jamal Murray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>Harris 1' Running Finger Roll Layup (15 PTS) (...</td>\n",
       "      <td>None</td>\n",
       "      <td>Gary Harris</td>\n",
       "      <td>Nikola Jokic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...</td>\n",
       "      <td>None</td>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>Jamal Murray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 15' Pullup Jump Shot (35 PTS)</td>\n",
       "      <td>CJ McCollum</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>Murray 13' Pullup Jump Shot (17 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>Jamal Murray</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 16' Pullup Jump Shot (37 PTS)</td>\n",
       "      <td>CJ McCollum</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       homedescription  \\\n",
       "4                      Harris 2' Driving Layup (2 PTS)   \n",
       "7                                                 None   \n",
       "8                Jokic 2' Turnaround Hook Shot (2 PTS)   \n",
       "9                                                 None   \n",
       "20      Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)   \n",
       "..                                                 ...   \n",
       "465  Harris 1' Running Finger Roll Layup (15 PTS) (...   \n",
       "468  Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...   \n",
       "469                                               None   \n",
       "474               Murray 13' Pullup Jump Shot (17 PTS)   \n",
       "478                                               None   \n",
       "\n",
       "                               visitordescription  player1_name  \\\n",
       "4                                            None   Gary Harris   \n",
       "7               McCollum 2' Driving Layup (2 PTS)   CJ McCollum   \n",
       "8                                            None  Nikola Jokic   \n",
       "9    Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)  Enes Freedom   \n",
       "20                                           None  Nikola Jokic   \n",
       "..                                            ...           ...   \n",
       "465                                          None   Gary Harris   \n",
       "468                                          None  Nikola Jokic   \n",
       "469        McCollum 15' Pullup Jump Shot (35 PTS)   CJ McCollum   \n",
       "474                                          None  Jamal Murray   \n",
       "478        McCollum 16' Pullup Jump Shot (37 PTS)   CJ McCollum   \n",
       "\n",
       "       player2_name  \n",
       "4              None  \n",
       "7              None  \n",
       "8              None  \n",
       "9    Damian Lillard  \n",
       "20     Jamal Murray  \n",
       "..              ...  \n",
       "465    Nikola Jokic  \n",
       "468    Jamal Murray  \n",
       "469            None  \n",
       "474            None  \n",
       "478            None  \n",
       "\n",
       "[71 rows x 4 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[(df.eventmsgtype==1),['homedescription','visitordescription','player1_name','player2_name']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "ce1bca3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>eventnum</th>\n",
       "      <th>eventmsgtype</th>\n",
       "      <th>eventmsgactiontype</th>\n",
       "      <th>period</th>\n",
       "      <th>pctimestring</th>\n",
       "      <th>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>score</th>\n",
       "      <th>...</th>\n",
       "      <th>max_time</th>\n",
       "      <th>time_remaining</th>\n",
       "      <th>h_lineup</th>\n",
       "      <th>a_lineup</th>\n",
       "      <th>stat1</th>\n",
       "      <th>stat1_value</th>\n",
       "      <th>stat1_player_id</th>\n",
       "      <th>stat2</th>\n",
       "      <th>stat2_value</th>\n",
       "      <th>stat2_player_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:28</td>\n",
       "      <td>Harris 2' Driving Layup (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0 - 2</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2848.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203914</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:12</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 2' Driving Layup (2 PTS)</td>\n",
       "      <td>2 - 3</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2832.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203468</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>10:52</td>\n",
       "      <td>Jokic 2' Turnaround Hook Shot (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2 - 5</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2812.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203999</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10:33</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)</td>\n",
       "      <td>4 - 5</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2793.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>202683</td>\n",
       "      <td>AST</td>\n",
       "      <td>1</td>\n",
       "      <td>203081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9:31</td>\n",
       "      <td>Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>4 - 9</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2731.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>3</td>\n",
       "      <td>203999</td>\n",
       "      <td>AST</td>\n",
       "      <td>1</td>\n",
       "      <td>1627750</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>465</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>649</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>4</td>\n",
       "      <td>2:11</td>\n",
       "      <td>Harris 1' Running Finger Roll Layup (15 PTS) (...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>94 - 91</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203914</td>\n",
       "      <td>AST</td>\n",
       "      <td>1</td>\n",
       "      <td>203999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>654</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>4</td>\n",
       "      <td>1:43</td>\n",
       "      <td>Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>94 - 93</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203999</td>\n",
       "      <td>AST</td>\n",
       "      <td>1</td>\n",
       "      <td>1627750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>656</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>1:25</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 15' Pullup Jump Shot (35 PTS)</td>\n",
       "      <td>96 - 93</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203468</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>662</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>0:30</td>\n",
       "      <td>Murray 13' Pullup Jump Shot (17 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>96 - 95</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>1627750</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>668</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>0:12</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 16' Pullup Jump Shot (37 PTS)</td>\n",
       "      <td>98 - 95</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>(200794, 203115, 203914, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203468, 203552)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203468</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_id  eventnum  eventmsgtype  eventmsgactiontype  period  \\\n",
       "4    0041800237        10             1                   6       1   \n",
       "7    0041800237        14             1                   6       1   \n",
       "8    0041800237        15             1                  58       1   \n",
       "9    0041800237        16             1                   1       1   \n",
       "20   0041800237        30             1                   1       1   \n",
       "..          ...       ...           ...                 ...     ...   \n",
       "465  0041800237       649             1                  76       4   \n",
       "468  0041800237       654             1                  78       4   \n",
       "469  0041800237       656             1                  79       4   \n",
       "474  0041800237       662             1                  79       4   \n",
       "478  0041800237       668             1                  79       4   \n",
       "\n",
       "    pctimestring                                    homedescription  \\\n",
       "4          11:28                    Harris 2' Driving Layup (2 PTS)   \n",
       "7          11:12                                               None   \n",
       "8          10:52              Jokic 2' Turnaround Hook Shot (2 PTS)   \n",
       "9          10:33                                               None   \n",
       "20          9:31     Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)   \n",
       "..           ...                                                ...   \n",
       "465         2:11  Harris 1' Running Finger Roll Layup (15 PTS) (...   \n",
       "468         1:43  Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...   \n",
       "469         1:25                                               None   \n",
       "474         0:30               Murray 13' Pullup Jump Shot (17 PTS)   \n",
       "478         0:12                                               None   \n",
       "\n",
       "    neutraldescription                            visitordescription    score  \\\n",
       "4                 None                                          None    0 - 2   \n",
       "7                 None             McCollum 2' Driving Layup (2 PTS)    2 - 3   \n",
       "8                 None                                          None    2 - 5   \n",
       "9                 None  Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)    4 - 5   \n",
       "20                None                                          None    4 - 9   \n",
       "..                 ...                                           ...      ...   \n",
       "465               None                                          None  94 - 91   \n",
       "468               None                                          None  94 - 93   \n",
       "469               None        McCollum 15' Pullup Jump Shot (35 PTS)  96 - 93   \n",
       "474               None                                          None  96 - 95   \n",
       "478               None        McCollum 16' Pullup Jump Shot (37 PTS)  98 - 95   \n",
       "\n",
       "     ...  max_time  time_remaining  \\\n",
       "4    ...    2880.0          2848.0   \n",
       "7    ...    2880.0          2832.0   \n",
       "8    ...    2880.0          2812.0   \n",
       "9    ...    2880.0          2793.0   \n",
       "20   ...    2880.0          2731.0   \n",
       "..   ...       ...             ...   \n",
       "465  ...    2880.0           131.0   \n",
       "468  ...    2880.0           103.0   \n",
       "469  ...    2880.0            85.0   \n",
       "474  ...    2880.0            30.0   \n",
       "478  ...    2880.0            12.0   \n",
       "\n",
       "                                       h_lineup  \\\n",
       "4    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "7    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "8    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "9    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "20   (200794, 203914, 203999, 1627750, 1628470)   \n",
       "..                                          ...   \n",
       "465  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "468  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "469  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "474  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "478  (200794, 203115, 203914, 1627750, 1628470)   \n",
       "\n",
       "                                     a_lineup  stat1 stat1_value  \\\n",
       "4    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "7    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "8    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "9    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "20   (202329, 202683, 203081, 203090, 203468)    PTS           3   \n",
       "..                                        ...    ...         ...   \n",
       "465  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "468  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "469  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "474  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "478  (202323, 202683, 203081, 203468, 203552)    PTS           2   \n",
       "\n",
       "     stat1_player_id  stat2 stat2_value stat2_player_id  \n",
       "4             203914                  0                  \n",
       "7             203468                  0                  \n",
       "8             203999                  0                  \n",
       "9             202683    AST           1          203081  \n",
       "20            203999    AST           1         1627750  \n",
       "..               ...    ...         ...             ...  \n",
       "465           203914    AST           1          203999  \n",
       "468           203999    AST           1         1627750  \n",
       "469           203468                  0                  \n",
       "474          1627750                  0                  \n",
       "478           203468                  0                  \n",
       "\n",
       "[71 rows x 39 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['stat1'] = ''\n",
    "df['stat1_value'] = 0\n",
    "df['stat1_player_id']=''\n",
    "df['stat2']= ''\n",
    "df['stat2_value'] = 0\n",
    "df['stat2_player_id'] = ''\n",
    "\n",
    "#assisted baskets\n",
    "df['stat2'].mask((df.eventmsgtype==1) & ~df.player2_name.isnull(), 'AST',inplace=True)\n",
    "df['stat2_value'].mask((df.eventmsgtype==1) & ~df.player2_name.isnull(), 1,inplace=True)\n",
    "df['stat2_player_id'].mask((df.eventmsgtype==1) & ~df.player2_name.isnull(),df.player2_id ,inplace=True)\n",
    "\n",
    "#pts from baskets, 2pt default, overwrite with 3pt\n",
    "df['stat1'].mask((df.eventmsgtype==1), 'PTS',inplace=True)\n",
    "df['stat1_value'].mask((df.eventmsgtype==1), 2,inplace=True)\n",
    "df['stat1_value'].mask((df.eventmsgtype==1) & (df.visitordescription.str.contains('3PT',na=False)\n",
    "                      | df.homedescription.str.contains('3PT',na=False)), 3,inplace=True)\n",
    "df['stat1_player_id'].mask((df.eventmsgtype==1),df.player1_id ,inplace=True)\n",
    "\n",
    "df.loc[(df.eventmsgtype==1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "e7ff8bb4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>eventnum</th>\n",
       "      <th>eventmsgtype</th>\n",
       "      <th>eventmsgactiontype</th>\n",
       "      <th>period</th>\n",
       "      <th>pctimestring</th>\n",
       "      <th>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>score</th>\n",
       "      <th>...</th>\n",
       "      <th>max_time</th>\n",
       "      <th>time_remaining</th>\n",
       "      <th>h_lineup</th>\n",
       "      <th>a_lineup</th>\n",
       "      <th>stat1</th>\n",
       "      <th>stat1_value</th>\n",
       "      <th>stat1_player_id</th>\n",
       "      <th>stat2</th>\n",
       "      <th>stat2_value</th>\n",
       "      <th>stat2_player_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12:00</td>\n",
       "      <td>None</td>\n",
       "      <td>Start of 1st Period (3:41 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Jump Ball Millsap vs. Kanter: Tip to Harkless</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>11:45</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Charge Foul (P1.T1) (J.Goble)</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2865.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>11:45</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Aminu Offensive Foul Turnover (P1.T1)</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2865.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:28</td>\n",
       "      <td>Harris 2' Driving Layup (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0 - 2</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2848.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203914</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></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>497</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>698</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0:08</td>\n",
       "      <td>NUGGETS Timeout: Regular (Full 7 Short 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(203486, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>699</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0:08</td>\n",
       "      <td>SUB: Barton FOR Plumlee</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>701</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>4</td>\n",
       "      <td>0:05</td>\n",
       "      <td>MISS Jokic 28' 3PT Turnaround Jump Shot</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>702</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0:01</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Turner REBOUND (Off:2 Def:5)</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>703</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0:00</td>\n",
       "      <td>None</td>\n",
       "      <td>End of 4th Period (6:14 PM EST)</td>\n",
       "      <td>None</td>\n",
       "      <td>100 - 96</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>(203115, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>502 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_id  eventnum  eventmsgtype  eventmsgactiontype  period  \\\n",
       "0    0041800237         2            12                   0       1   \n",
       "1    0041800237         4            10                   0       1   \n",
       "2    0041800237         7             6                  26       1   \n",
       "3    0041800237         9             5                  37       1   \n",
       "4    0041800237        10             1                   6       1   \n",
       "..          ...       ...           ...                 ...     ...   \n",
       "497  0041800237       698             9                   1       4   \n",
       "498  0041800237       699             8                   0       4   \n",
       "499  0041800237       701             2                  47       4   \n",
       "500  0041800237       702             4                   0       4   \n",
       "501  0041800237       703            13                   0       4   \n",
       "\n",
       "    pctimestring                                homedescription  \\\n",
       "0          12:00                                           None   \n",
       "1          12:00  Jump Ball Millsap vs. Kanter: Tip to Harkless   \n",
       "2          11:45                                           None   \n",
       "3          11:45                                           None   \n",
       "4          11:28                Harris 2' Driving Layup (2 PTS)   \n",
       "..           ...                                            ...   \n",
       "497         0:08      NUGGETS Timeout: Regular (Full 7 Short 0)   \n",
       "498         0:08                        SUB: Barton FOR Plumlee   \n",
       "499         0:05        MISS Jokic 28' 3PT Turnaround Jump Shot   \n",
       "500         0:01                                           None   \n",
       "501         0:00                                           None   \n",
       "\n",
       "                    neutraldescription  \\\n",
       "0    Start of 1st Period (3:41 PM EST)   \n",
       "1                                 None   \n",
       "2                                 None   \n",
       "3                                 None   \n",
       "4                                 None   \n",
       "..                                 ...   \n",
       "497                               None   \n",
       "498                               None   \n",
       "499                               None   \n",
       "500                               None   \n",
       "501    End of 4th Period (6:14 PM EST)   \n",
       "\n",
       "                                visitordescription     score  ...  max_time  \\\n",
       "0                                             None      None  ...    2880.0   \n",
       "1                                             None      None  ...    2880.0   \n",
       "2    Aminu Offensive Charge Foul (P1.T1) (J.Goble)      None  ...    2880.0   \n",
       "3            Aminu Offensive Foul Turnover (P1.T1)      None  ...    2880.0   \n",
       "4                                             None     0 - 2  ...    2880.0   \n",
       "..                                             ...       ...  ...       ...   \n",
       "497                                           None      None  ...    2880.0   \n",
       "498                                           None      None  ...    2880.0   \n",
       "499                                           None      None  ...    2880.0   \n",
       "500                   Turner REBOUND (Off:2 Def:5)      None  ...    2880.0   \n",
       "501                                           None  100 - 96  ...    2880.0   \n",
       "\n",
       "     time_remaining                                    h_lineup  \\\n",
       "0            2880.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "1            2880.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "2            2865.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "3            2865.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "4            2848.0  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "..              ...                                         ...   \n",
       "497             8.0  (203486, 203914, 203999, 1627750, 1628470)   \n",
       "498             8.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "499             5.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "500             1.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "501             0.0  (203115, 203914, 203999, 1627750, 1628470)   \n",
       "\n",
       "                                     a_lineup  stat1 stat1_value  \\\n",
       "0    (202329, 202683, 203081, 203090, 203468)                  0   \n",
       "1    (202329, 202683, 203081, 203090, 203468)                  0   \n",
       "2    (202329, 202683, 203081, 203090, 203468)                  0   \n",
       "3    (202329, 202683, 203081, 203090, 203468)                  0   \n",
       "4    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "..                                        ...    ...         ...   \n",
       "497  (202323, 202683, 203081, 203090, 203468)                  0   \n",
       "498  (202323, 202683, 203081, 203090, 203468)                  0   \n",
       "499  (202323, 202683, 203081, 203090, 203468)                  0   \n",
       "500  (202323, 202683, 203081, 203090, 203468)                  0   \n",
       "501  (202323, 202683, 203081, 203090, 203468)                  0   \n",
       "\n",
       "     stat1_player_id  stat2 stat2_value stat2_player_id  \n",
       "0                                     0                  \n",
       "1                                     0                  \n",
       "2                                     0                  \n",
       "3                                     0                  \n",
       "4             203914                  0                  \n",
       "..               ...    ...         ...             ...  \n",
       "497                                   0                  \n",
       "498                                   0                  \n",
       "499                                   0                  \n",
       "500                                   0                  \n",
       "501                                   0                  \n",
       "\n",
       "[502 rows x 39 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['stat1'] = ''\n",
    "df['stat1_value'] = 0\n",
    "df['stat2_value'] = 0\n",
    "df['stat2']= ''\n",
    "df.loc[df.eventmsgtype==1,'stat1'] = 'PTS'\n",
    "df.loc[df.eventmsgtype==1 & (~df.homedescription.isnull()),['stat1_value']] = 2\n",
    "df.loc[df.eventmsgtype==1 & (~df.visitordescription.isnull()),['stat1_value']] = 2\n",
    "df.loc[df.eventmsgtype==1 & (df.homedescription.str.contains('3PT',na=False)),['stat1_value']] = 3\n",
    "df.loc[df.eventmsgtype==1 & (df.visitordescription.str.contains('3PT',na=False)),['stat1_value']] = 3\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "be6f7ad1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>eventnum</th>\n",
       "      <th>eventmsgtype</th>\n",
       "      <th>eventmsgactiontype</th>\n",
       "      <th>period</th>\n",
       "      <th>pctimestring</th>\n",
       "      <th>homedescription</th>\n",
       "      <th>neutraldescription</th>\n",
       "      <th>visitordescription</th>\n",
       "      <th>score</th>\n",
       "      <th>...</th>\n",
       "      <th>max_time</th>\n",
       "      <th>time_remaining</th>\n",
       "      <th>h_lineup</th>\n",
       "      <th>a_lineup</th>\n",
       "      <th>stat1</th>\n",
       "      <th>stat1_value</th>\n",
       "      <th>stat1_player_id</th>\n",
       "      <th>stat2</th>\n",
       "      <th>stat2_value</th>\n",
       "      <th>stat2_player_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:28</td>\n",
       "      <td>Harris 2' Driving Layup (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0 - 2</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2848.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203914</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11:12</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 2' Driving Layup (2 PTS)</td>\n",
       "      <td>2 - 3</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2832.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203468</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>10:52</td>\n",
       "      <td>Jokic 2' Turnaround Hook Shot (2 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2 - 5</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2812.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203999</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10:33</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)</td>\n",
       "      <td>4 - 5</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2793.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>202683</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>203081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9:31</td>\n",
       "      <td>Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>4 - 9</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2731.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202329, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>3</td>\n",
       "      <td>203999</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>1627750</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>465</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>649</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>4</td>\n",
       "      <td>2:11</td>\n",
       "      <td>Harris 1' Running Finger Roll Layup (15 PTS) (...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>94 - 91</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203914</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>203999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>654</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>4</td>\n",
       "      <td>1:43</td>\n",
       "      <td>Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>94 - 93</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203999</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>1627750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>656</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>1:25</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 15' Pullup Jump Shot (35 PTS)</td>\n",
       "      <td>96 - 93</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203468</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>662</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>0:30</td>\n",
       "      <td>Murray 13' Pullup Jump Shot (17 PTS)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>96 - 95</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>(200794, 203914, 203999, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203090, 203468)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>1627750</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>0041800237</td>\n",
       "      <td>668</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>0:12</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>McCollum 16' Pullup Jump Shot (37 PTS)</td>\n",
       "      <td>98 - 95</td>\n",
       "      <td>...</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>(200794, 203115, 203914, 1627750, 1628470)</td>\n",
       "      <td>(202323, 202683, 203081, 203468, 203552)</td>\n",
       "      <td>PTS</td>\n",
       "      <td>2</td>\n",
       "      <td>203468</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_id  eventnum  eventmsgtype  eventmsgactiontype  period  \\\n",
       "4    0041800237        10             1                   6       1   \n",
       "7    0041800237        14             1                   6       1   \n",
       "8    0041800237        15             1                  58       1   \n",
       "9    0041800237        16             1                   1       1   \n",
       "20   0041800237        30             1                   1       1   \n",
       "..          ...       ...           ...                 ...     ...   \n",
       "465  0041800237       649             1                  76       4   \n",
       "468  0041800237       654             1                  78       4   \n",
       "469  0041800237       656             1                  79       4   \n",
       "474  0041800237       662             1                  79       4   \n",
       "478  0041800237       668             1                  79       4   \n",
       "\n",
       "    pctimestring                                    homedescription  \\\n",
       "4          11:28                    Harris 2' Driving Layup (2 PTS)   \n",
       "7          11:12                                               None   \n",
       "8          10:52              Jokic 2' Turnaround Hook Shot (2 PTS)   \n",
       "9          10:33                                               None   \n",
       "20          9:31     Jokic 25' 3PT Jump Shot (5 PTS) (Murray 1 AST)   \n",
       "..           ...                                                ...   \n",
       "465         2:11  Harris 1' Running Finger Roll Layup (15 PTS) (...   \n",
       "468         1:43  Jokic 4' Floating Jump Shot (28 PTS) (Murray 5...   \n",
       "469         1:25                                               None   \n",
       "474         0:30               Murray 13' Pullup Jump Shot (17 PTS)   \n",
       "478         0:12                                               None   \n",
       "\n",
       "    neutraldescription                            visitordescription    score  \\\n",
       "4                 None                                          None    0 - 2   \n",
       "7                 None             McCollum 2' Driving Layup (2 PTS)    2 - 3   \n",
       "8                 None                                          None    2 - 5   \n",
       "9                 None  Kanter 13' Jump Shot (2 PTS) (Lillard 1 AST)    4 - 5   \n",
       "20                None                                          None    4 - 9   \n",
       "..                 ...                                           ...      ...   \n",
       "465               None                                          None  94 - 91   \n",
       "468               None                                          None  94 - 93   \n",
       "469               None        McCollum 15' Pullup Jump Shot (35 PTS)  96 - 93   \n",
       "474               None                                          None  96 - 95   \n",
       "478               None        McCollum 16' Pullup Jump Shot (37 PTS)  98 - 95   \n",
       "\n",
       "     ...  max_time  time_remaining  \\\n",
       "4    ...    2880.0          2848.0   \n",
       "7    ...    2880.0          2832.0   \n",
       "8    ...    2880.0          2812.0   \n",
       "9    ...    2880.0          2793.0   \n",
       "20   ...    2880.0          2731.0   \n",
       "..   ...       ...             ...   \n",
       "465  ...    2880.0           131.0   \n",
       "468  ...    2880.0           103.0   \n",
       "469  ...    2880.0            85.0   \n",
       "474  ...    2880.0            30.0   \n",
       "478  ...    2880.0            12.0   \n",
       "\n",
       "                                       h_lineup  \\\n",
       "4    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "7    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "8    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "9    (200794, 203914, 203999, 1627750, 1628470)   \n",
       "20   (200794, 203914, 203999, 1627750, 1628470)   \n",
       "..                                          ...   \n",
       "465  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "468  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "469  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "474  (200794, 203914, 203999, 1627750, 1628470)   \n",
       "478  (200794, 203115, 203914, 1627750, 1628470)   \n",
       "\n",
       "                                     a_lineup  stat1 stat1_value  \\\n",
       "4    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "7    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "8    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "9    (202329, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "20   (202329, 202683, 203081, 203090, 203468)    PTS           3   \n",
       "..                                        ...    ...         ...   \n",
       "465  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "468  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "469  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "474  (202323, 202683, 203081, 203090, 203468)    PTS           2   \n",
       "478  (202323, 202683, 203081, 203468, 203552)    PTS           2   \n",
       "\n",
       "     stat1_player_id  stat2 stat2_value stat2_player_id  \n",
       "4             203914                  0                  \n",
       "7             203468                  0                  \n",
       "8             203999                  0                  \n",
       "9             202683                  0          203081  \n",
       "20            203999                  0         1627750  \n",
       "..               ...    ...         ...             ...  \n",
       "465           203914                  0          203999  \n",
       "468           203999                  0         1627750  \n",
       "469           203468                  0                  \n",
       "474          1627750                  0                  \n",
       "478           203468                  0                  \n",
       "\n",
       "[71 rows x 39 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df.stat1 =='PTS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "542b5d90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "game_id                                                      0041800237\n",
       "eventnum                                                              2\n",
       "eventmsgtype                                                         12\n",
       "eventmsgactiontype                                                    0\n",
       "period                                                                1\n",
       "pctimestring                                                      12:00\n",
       "homedescription                                                    None\n",
       "neutraldescription                    Start of 1st Period (3:41 PM EST)\n",
       "visitordescription                                                 None\n",
       "score                                                              None\n",
       "scoremargin                                                           0\n",
       "person1type                                                           0\n",
       "player1_id                                                            0\n",
       "player1_name                                                       None\n",
       "player1_team_id                                                     NaN\n",
       "player1_team_abbreviation                                          None\n",
       "person2type                                                           0\n",
       "player2_id                                                            0\n",
       "player2_name                                                       None\n",
       "player2_team_nickname                                              None\n",
       "player2_team_abbreviation                                          None\n",
       "person3type                                                           0\n",
       "player3_id                                                            0\n",
       "player3_name                                                       None\n",
       "player3_team_nickname                                              None\n",
       "player3_team_abbreviation                                          None\n",
       "timeinseconds                                                       720\n",
       "play_elapsed_time                                                   0.0\n",
       "total_elapsed_time                                                  0.0\n",
       "max_time                                                         2880.0\n",
       "time_remaining                                                   2880.0\n",
       "h_lineup                     (200794, 203914, 203999, 1627750, 1628470)\n",
       "a_lineup                       (202329, 202683, 203081, 203090, 203468)\n",
       "stat1                                                                  \n",
       "stat1_value                                                           0\n",
       "stat1_player_id                                                        \n",
       "stat2                                                                  \n",
       "stat2_value                                                           0\n",
       "stat2_player_id                                                        \n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "d86f0377",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('stat_test.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}