get_game_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "base = \"data\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "games_df = pd.read_csv(os.sep.join([base, \"games.csv\"]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2021090900\n"
     ]
    }
   ],
   "source": [
    "gameId = games_df.iloc[0, :][\"gameId\"]\n",
    "print(gameId)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "class Play:\n",
    "    def __init__(self, details, player_tracking, pff):\n",
    "        self.details = details\n",
    "        self.player_tracking = player_tracking\n",
    "        self.pff = pff\n",
    "        self.frames = list(self.player_tracking[\"frameId\"].unique())\n",
    "    def get_frame(self, frameId):\n",
    "        frame_player_tracking = self.player_tracking[self.player_tracking[\"frameId\"] == frameId]\n",
    "        return frame_player_tracking"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "class Game:\n",
    "    def __init__(self, gameId):\n",
    "        self.load_game_data(gameId)\n",
    "        self.plays_ids = list(self.player_tracking[\"playId\"].unique())\n",
    "        \n",
    "    def load_game_data(self, gameId):\n",
    "        \n",
    "        games_df = pd.read_csv(os.sep.join([base, \"games.csv\"]))\n",
    "        self.details = games_df[games_df[\"gameId\"] == gameId].iloc[0, :].to_dict()\n",
    "        \n",
    "        player_tracking = pd.read_csv(os.sep.join([base, f\"week{self.details['week']}.csv\"]))\n",
    "        self.player_tracking = player_tracking[player_tracking[\"gameId\"] == gameId]\n",
    "        \n",
    "        pff = pd.read_csv(os.sep.join([base, \"pffScoutingData.csv\"]))\n",
    "        self.pff = pff[pff[\"gameId\"] == gameId]\n",
    "        \n",
    "        plays = pd.read_csv(os.sep.join([base, \"plays.csv\"]))\n",
    "        self.play_data = plays[plays[\"gameId\"] == gameId]\n",
    "        \n",
    "    def get_play(self, playId):\n",
    "        play_tracking_data = self.player_tracking[self.player_tracking[\"playId\"] == playId]\n",
    "        play_pff_data = self.pff[self.pff[\"playId\"] == playId]\n",
    "        play_details = self.play_data[self.play_data[\"playId\"] == playId].iloc[0,:].to_dict()\n",
    "        \n",
    "        return Play(play_details, play_tracking_data, play_pff_data)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Make a play class?\n",
    "#Add a list of the frames by frame num\n",
    "#Add a method to get the frame by frame num"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "game_data = Game(gameId)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "play = game_data.get_play(97)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>gameId</th>\n",
       "      <th>playId</th>\n",
       "      <th>nflId</th>\n",
       "      <th>frameId</th>\n",
       "      <th>time</th>\n",
       "      <th>jerseyNumber</th>\n",
       "      <th>team</th>\n",
       "      <th>playDirection</th>\n",
       "      <th>x</th>\n",
       "      <th>y</th>\n",
       "      <th>s</th>\n",
       "      <th>a</th>\n",
       "      <th>dis</th>\n",
       "      <th>o</th>\n",
       "      <th>dir</th>\n",
       "      <th>event</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>25511.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>12.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>37.77</td>\n",
       "      <td>24.22</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0.03</td>\n",
       "      <td>165.16</td>\n",
       "      <td>84.99</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>35481.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>87.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>41.08</td>\n",
       "      <td>29.15</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.03</td>\n",
       "      <td>35.96</td>\n",
       "      <td>238.77</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>35634.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>81.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>40.99</td>\n",
       "      <td>36.74</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>113.75</td>\n",
       "      <td>325.69</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>39985.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>25.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>37.54</td>\n",
       "      <td>22.26</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.02</td>\n",
       "      <td>91.78</td>\n",
       "      <td>132.28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>40151.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>66.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>42.18</td>\n",
       "      <td>23.97</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>45.36</td>\n",
       "      <td>206.92</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>41233.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>13.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>42.01</td>\n",
       "      <td>16.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>131.20</td>\n",
       "      <td>232.25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>41263.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>90.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>43.66</td>\n",
       "      <td>18.70</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.05</td>\n",
       "      <td>308.77</td>\n",
       "      <td>337.59</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>42377.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>76.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>41.55</td>\n",
       "      <td>26.89</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>148.02</td>\n",
       "      <td>132.28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>42403.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>94.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>44.03</td>\n",
       "      <td>32.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>265.97</td>\n",
       "      <td>215.94</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>42404.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>74.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>41.95</td>\n",
       "      <td>25.66</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>108.14</td>\n",
       "      <td>151.12</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>43306.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>42.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>44.59</td>\n",
       "      <td>29.62</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0.03</td>\n",
       "      <td>264.41</td>\n",
       "      <td>162.64</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>43478.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>30.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>43.49</td>\n",
       "      <td>37.55</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.07</td>\n",
       "      <td>302.07</td>\n",
       "      <td>58.43</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>44896.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>14.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>40.09</td>\n",
       "      <td>36.72</td>\n",
       "      <td>3.54</td>\n",
       "      <td>1.47</td>\n",
       "      <td>0.36</td>\n",
       "      <td>67.72</td>\n",
       "      <td>183.27</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>44904.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>26.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>44.50</td>\n",
       "      <td>37.78</td>\n",
       "      <td>3.28</td>\n",
       "      <td>1.29</td>\n",
       "      <td>0.32</td>\n",
       "      <td>89.72</td>\n",
       "      <td>168.38</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>44955.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>91.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>43.47</td>\n",
       "      <td>25.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>43.02</td>\n",
       "      <td>104.69</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>645</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>44962.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>18.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>58.60</td>\n",
       "      <td>27.33</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.06</td>\n",
       "      <td>299.23</td>\n",
       "      <td>140.01</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>46163.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>65.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>41.42</td>\n",
       "      <td>22.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>107.71</td>\n",
       "      <td>216.03</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>47996.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>6.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>48.36</td>\n",
       "      <td>22.80</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.05</td>\n",
       "      <td>296.75</td>\n",
       "      <td>236.15</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>52421.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>78.0</td>\n",
       "      <td>TB</td>\n",
       "      <td>right</td>\n",
       "      <td>41.15</td>\n",
       "      <td>21.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>49.72</td>\n",
       "      <td>293.16</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>52459.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>7.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>43.50</td>\n",
       "      <td>16.27</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.08</td>\n",
       "      <td>311.97</td>\n",
       "      <td>202.95</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>53441.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>11.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>43.71</td>\n",
       "      <td>21.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>276.51</td>\n",
       "      <td>290.12</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>53504.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>97.0</td>\n",
       "      <td>DAL</td>\n",
       "      <td>right</td>\n",
       "      <td>43.69</td>\n",
       "      <td>26.67</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>222.44</td>\n",
       "      <td>328.69</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>2021090900</td>\n",
       "      <td>97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-10T00:26:31.100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>football</td>\n",
       "      <td>right</td>\n",
       "      <td>42.92</td>\n",
       "      <td>24.04</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         gameId  playId    nflId  frameId                     time  \\\n",
       "0    2021090900      97  25511.0        1  2021-09-10T00:26:31.100   \n",
       "43   2021090900      97  35481.0        1  2021-09-10T00:26:31.100   \n",
       "86   2021090900      97  35634.0        1  2021-09-10T00:26:31.100   \n",
       "129  2021090900      97  39985.0        1  2021-09-10T00:26:31.100   \n",
       "172  2021090900      97  40151.0        1  2021-09-10T00:26:31.100   \n",
       "215  2021090900      97  41233.0        1  2021-09-10T00:26:31.100   \n",
       "258  2021090900      97  41263.0        1  2021-09-10T00:26:31.100   \n",
       "301  2021090900      97  42377.0        1  2021-09-10T00:26:31.100   \n",
       "344  2021090900      97  42403.0        1  2021-09-10T00:26:31.100   \n",
       "387  2021090900      97  42404.0        1  2021-09-10T00:26:31.100   \n",
       "430  2021090900      97  43306.0        1  2021-09-10T00:26:31.100   \n",
       "473  2021090900      97  43478.0        1  2021-09-10T00:26:31.100   \n",
       "516  2021090900      97  44896.0        1  2021-09-10T00:26:31.100   \n",
       "559  2021090900      97  44904.0        1  2021-09-10T00:26:31.100   \n",
       "602  2021090900      97  44955.0        1  2021-09-10T00:26:31.100   \n",
       "645  2021090900      97  44962.0        1  2021-09-10T00:26:31.100   \n",
       "688  2021090900      97  46163.0        1  2021-09-10T00:26:31.100   \n",
       "731  2021090900      97  47996.0        1  2021-09-10T00:26:31.100   \n",
       "774  2021090900      97  52421.0        1  2021-09-10T00:26:31.100   \n",
       "817  2021090900      97  52459.0        1  2021-09-10T00:26:31.100   \n",
       "860  2021090900      97  53441.0        1  2021-09-10T00:26:31.100   \n",
       "903  2021090900      97  53504.0        1  2021-09-10T00:26:31.100   \n",
       "946  2021090900      97      NaN        1  2021-09-10T00:26:31.100   \n",
       "\n",
       "     jerseyNumber      team playDirection      x      y     s     a   dis  \\\n",
       "0            12.0        TB         right  37.77  24.22  0.29  0.30  0.03   \n",
       "43           87.0        TB         right  41.08  29.15  0.31  0.43  0.03   \n",
       "86           81.0        TB         right  40.99  36.74  0.00  0.00  0.00   \n",
       "129          25.0        TB         right  37.54  22.26  0.11  0.07  0.02   \n",
       "172          66.0        TB         right  42.18  23.97  0.00  0.00  0.01   \n",
       "215          13.0        TB         right  42.01  16.19  0.00  0.00  0.00   \n",
       "258          90.0       DAL         right  43.66  18.70  0.45  0.92  0.05   \n",
       "301          76.0        TB         right  41.55  26.89  0.00  0.00  0.00   \n",
       "344          94.0       DAL         right  44.03  32.69  0.00  0.00  0.01   \n",
       "387          74.0        TB         right  41.95  25.66  0.00  0.00  0.00   \n",
       "430          42.0       DAL         right  44.59  29.62  0.25  0.26  0.03   \n",
       "473          30.0       DAL         right  43.49  37.55  0.19  0.09  0.07   \n",
       "516          14.0        TB         right  40.09  36.72  3.54  1.47  0.36   \n",
       "559          26.0       DAL         right  44.50  37.78  3.28  1.29  0.32   \n",
       "602          91.0       DAL         right  43.47  25.14  0.00  0.00  0.01   \n",
       "645          18.0       DAL         right  58.60  27.33  0.55  0.87  0.06   \n",
       "688          65.0        TB         right  41.42  22.63  0.00  0.00  0.00   \n",
       "731           6.0       DAL         right  48.36  22.80  0.57  0.87  0.05   \n",
       "774          78.0        TB         right  41.15  21.36  0.00  0.00  0.01   \n",
       "817           7.0       DAL         right  43.50  16.27  0.80  0.57  0.08   \n",
       "860          11.0       DAL         right  43.71  21.88  0.00  0.00  0.01   \n",
       "903          97.0       DAL         right  43.69  26.67  0.01  0.01  0.00   \n",
       "946           NaN  football         right  42.92  24.04  0.00  0.00  0.00   \n",
       "\n",
       "          o     dir event  \n",
       "0    165.16   84.99  None  \n",
       "43    35.96  238.77  None  \n",
       "86   113.75  325.69  None  \n",
       "129   91.78  132.28  None  \n",
       "172   45.36  206.92  None  \n",
       "215  131.20  232.25  None  \n",
       "258  308.77  337.59  None  \n",
       "301  148.02  132.28  None  \n",
       "344  265.97  215.94  None  \n",
       "387  108.14  151.12  None  \n",
       "430  264.41  162.64  None  \n",
       "473  302.07   58.43  None  \n",
       "516   67.72  183.27  None  \n",
       "559   89.72  168.38  None  \n",
       "602   43.02  104.69  None  \n",
       "645  299.23  140.01  None  \n",
       "688  107.71  216.03  None  \n",
       "731  296.75  236.15  None  \n",
       "774   49.72  293.16  None  \n",
       "817  311.97  202.95  None  \n",
       "860  276.51  290.12  None  \n",
       "903  222.44  328.69  None  \n",
       "946     NaN     NaN  None  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "play.get_frame(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "nfl_2023",
   "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.9.7"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "8592f001470b732d7b988114f1e13a1cb6fd1f53b86cc60250329e84f6a6b278"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}