main_nba.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The autoreload extension is already loaded. To reload it, use:\n",
      "  %reload_ext autoreload\n"
     ]
    }
   ],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2\n",
    "\n",
    "import os\n",
    "import shutil\n",
    "\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from py7zr import unpack_7zarchive\n",
    "\n",
    "from src.animator import Animator\n",
    "from src.nba_parser import NBAParser\n",
    "from src.nba_processor import NBAProcessor\n",
    "\n",
    "pd.set_option(\"display.max_rows\", 50)\n",
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Unzipping .7z Files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "zip_dir = \"data/nba_raw_7z\"\n",
    "zip_files = np.sort([f for f in os.listdir(zip_dir) if f.endswith(\".7z\")])\n",
    "\n",
    "if not os.path.exists(\"data/nba_json\"):\n",
    "    os.mkdir(\"data/nba_json\")\n",
    "\n",
    "shutil.register_unpack_format(\"7zip\", [\".7z\"], unpack_7zarchive)\n",
    "for f in zip_files:\n",
    "    shutil.unpack_archive(f\"{zip_dir}/{f}\", \"data/nba_jsons\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Formatting Match Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "2015-12-05 - Boston Celtics at San Antonio Spurs\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 187/187 [00:01<00:00, 127.81it/s]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data saved in data/nba_traces/21500296.csv.\n",
      "Metadata saved in data/nba_traces/21500296.json.\n",
      "\n",
      "2016-01-01 - Dallas Mavericks at Miami Heat\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 187/187 [00:01<00:00, 126.80it/s]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data saved in data/nba_traces/21500491.csv.\n",
      "Metadata saved in data/nba_traces/21500491.json.\n",
      "\n",
      "2016-01-01 - Charlotte Hornets at Toronto Raptors\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 197/197 [00:01<00:00, 122.84it/s]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data saved in data/nba_traces/21500492.csv.\n",
      "Metadata saved in data/nba_traces/21500492.json.\n"
     ]
    }
   ],
   "source": [
    "json_dir = \"data/nba_raw_json\"\n",
    "match_ids = np.sort([f.split(\".\")[0] for f in os.listdir(json_dir) if f.endswith(\".json\")])\n",
    "for match_id in match_ids:\n",
    "    parser = NBAParser(match_id)\n",
    "    parser.run(save=True, verbose=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Preprocessing Match Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "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>time</th>\n",
       "      <th>quarter</th>\n",
       "      <th>time_left</th>\n",
       "      <th>shot_clock</th>\n",
       "      <th>phase</th>\n",
       "      <th>episode</th>\n",
       "      <th>ball_x</th>\n",
       "      <th>ball_y</th>\n",
       "      <th>ball_z</th>\n",
       "      <th>A21_x</th>\n",
       "      <th>A21_y</th>\n",
       "      <th>A20_x</th>\n",
       "      <th>A20_y</th>\n",
       "      <th>A09_x</th>\n",
       "      <th>A09_y</th>\n",
       "      <th>A30_x</th>\n",
       "      <th>A30_y</th>\n",
       "      <th>A33_x</th>\n",
       "      <th>A33_y</th>\n",
       "      <th>A15_x</th>\n",
       "      <th>A15_y</th>\n",
       "      <th>A12_x</th>\n",
       "      <th>A12_y</th>\n",
       "      <th>A14_x</th>\n",
       "      <th>A14_y</th>\n",
       "      <th>A08_x</th>\n",
       "      <th>A08_y</th>\n",
       "      <th>A02_x</th>\n",
       "      <th>A02_y</th>\n",
       "      <th>A03_x</th>\n",
       "      <th>A03_y</th>\n",
       "      <th>A17_x</th>\n",
       "      <th>A17_y</th>\n",
       "      <th>A01_x</th>\n",
       "      <th>A01_y</th>\n",
       "      <th>B42_x</th>\n",
       "      <th>B42_y</th>\n",
       "      <th>B90_x</th>\n",
       "      <th>B90_y</th>\n",
       "      <th>B08_x</th>\n",
       "      <th>B08_y</th>\n",
       "      <th>B11_x</th>\n",
       "      <th>B11_y</th>\n",
       "      <th>B00_x</th>\n",
       "      <th>B00_y</th>\n",
       "      <th>B04_x</th>\n",
       "      <th>B04_y</th>\n",
       "      <th>B44_x</th>\n",
       "      <th>B44_y</th>\n",
       "      <th>B07_x</th>\n",
       "      <th>B07_y</th>\n",
       "      <th>B99_x</th>\n",
       "      <th>B99_y</th>\n",
       "      <th>B41_x</th>\n",
       "      <th>B41_y</th>\n",
       "      <th>B13_x</th>\n",
       "      <th>B13_y</th>\n",
       "      <th>B28_x</th>\n",
       "      <th>B28_y</th>\n",
       "      <th>B12_x</th>\n",
       "      <th>B12_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>692.14</td>\n",
       "      <td>11.82</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.46792</td>\n",
       "      <td>22.75675</td>\n",
       "      <td>13.03461</td>\n",
       "      <td>67.16087</td>\n",
       "      <td>29.59313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.96864</td>\n",
       "      <td>47.85704</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>78.30237</td>\n",
       "      <td>17.57163</td>\n",
       "      <td>69.48956</td>\n",
       "      <td>44.72622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.99244</td>\n",
       "      <td>4.89813</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>80.84386</td>\n",
       "      <td>18.00934</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.87042</td>\n",
       "      <td>39.17521</td>\n",
       "      <td>89.59344</td>\n",
       "      <td>34.15218</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.75791</td>\n",
       "      <td>27.27651</td>\n",
       "      <td>78.91164</td>\n",
       "      <td>12.26497</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>1</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>692.10</td>\n",
       "      <td>11.79</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.66539</td>\n",
       "      <td>22.97231</td>\n",
       "      <td>12.98191</td>\n",
       "      <td>67.01950</td>\n",
       "      <td>29.53259</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.78642</td>\n",
       "      <td>47.80307</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>78.08224</td>\n",
       "      <td>17.46593</td>\n",
       "      <td>69.40549</td>\n",
       "      <td>44.61300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.78343</td>\n",
       "      <td>4.95053</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>80.66856</td>\n",
       "      <td>17.89438</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.76690</td>\n",
       "      <td>39.17315</td>\n",
       "      <td>89.58985</td>\n",
       "      <td>33.77513</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.00638</td>\n",
       "      <td>27.21322</td>\n",
       "      <td>79.08796</td>\n",
       "      <td>12.39129</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>2</th>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>692.06</td>\n",
       "      <td>11.75</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>85.10040</td>\n",
       "      <td>23.15495</td>\n",
       "      <td>12.90829</td>\n",
       "      <td>66.84565</td>\n",
       "      <td>29.46317</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.60391</td>\n",
       "      <td>47.73646</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>77.81610</td>\n",
       "      <td>17.30892</td>\n",
       "      <td>69.31841</td>\n",
       "      <td>44.49632</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.53882</td>\n",
       "      <td>5.01084</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>80.49417</td>\n",
       "      <td>17.80361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.65437</td>\n",
       "      <td>39.17154</td>\n",
       "      <td>89.59990</td>\n",
       "      <td>33.40121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.26086</td>\n",
       "      <td>27.13552</td>\n",
       "      <td>79.23460</td>\n",
       "      <td>12.52712</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>3</th>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>692.02</td>\n",
       "      <td>11.72</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>85.33708</td>\n",
       "      <td>23.46550</td>\n",
       "      <td>12.68268</td>\n",
       "      <td>66.65021</td>\n",
       "      <td>29.37945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.40563</td>\n",
       "      <td>47.66385</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>77.55261</td>\n",
       "      <td>17.18232</td>\n",
       "      <td>69.22388</td>\n",
       "      <td>44.38025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.30137</td>\n",
       "      <td>5.09012</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>80.31226</td>\n",
       "      <td>17.70554</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.53207</td>\n",
       "      <td>39.17316</td>\n",
       "      <td>89.58999</td>\n",
       "      <td>33.02797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.51330</td>\n",
       "      <td>27.04849</td>\n",
       "      <td>79.38436</td>\n",
       "      <td>12.62605</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>4</th>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>691.98</td>\n",
       "      <td>11.68</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>85.82441</td>\n",
       "      <td>23.74433</td>\n",
       "      <td>12.44327</td>\n",
       "      <td>66.42761</td>\n",
       "      <td>29.31333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.20060</td>\n",
       "      <td>47.57324</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>77.26987</td>\n",
       "      <td>17.08339</td>\n",
       "      <td>69.12495</td>\n",
       "      <td>44.26393</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.05920</td>\n",
       "      <td>5.16150</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>80.16399</td>\n",
       "      <td>17.67595</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.39826</td>\n",
       "      <td>39.17764</td>\n",
       "      <td>89.58705</td>\n",
       "      <td>32.66373</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.76414</td>\n",
       "      <td>26.96373</td>\n",
       "      <td>79.55919</td>\n",
       "      <td>12.73218</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>...</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",
       "      <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",
       "      <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>68617</th>\n",
       "      <td>8213160</td>\n",
       "      <td>4</td>\n",
       "      <td>1.88</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>96.67976</td>\n",
       "      <td>33.72578</td>\n",
       "      <td>7.22921</td>\n",
       "      <td>83.45848</td>\n",
       "      <td>33.98625</td>\n",
       "      <td>71.18024</td>\n",
       "      <td>37.43370</td>\n",
       "      <td>67.83715</td>\n",
       "      <td>15.14724</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>48.39282</td>\n",
       "      <td>17.68947</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.40613</td>\n",
       "      <td>28.61137</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>73.70716</td>\n",
       "      <td>44.63824</td>\n",
       "      <td>71.66736</td>\n",
       "      <td>14.03311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.26698</td>\n",
       "      <td>30.04334</td>\n",
       "      <td>0.48415</td>\n",
       "      <td>36.12527</td>\n",
       "      <td>58.38010</td>\n",
       "      <td>35.89495</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>68618</th>\n",
       "      <td>8213200</td>\n",
       "      <td>4</td>\n",
       "      <td>1.84</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>95.87549</td>\n",
       "      <td>33.51411</td>\n",
       "      <td>7.63900</td>\n",
       "      <td>83.54958</td>\n",
       "      <td>34.03643</td>\n",
       "      <td>71.88244</td>\n",
       "      <td>37.72820</td>\n",
       "      <td>68.47667</td>\n",
       "      <td>15.21572</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>48.92855</td>\n",
       "      <td>17.75173</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.80381</td>\n",
       "      <td>28.34747</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74.41699</td>\n",
       "      <td>44.91530</td>\n",
       "      <td>72.39644</td>\n",
       "      <td>14.35001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.86354</td>\n",
       "      <td>29.56931</td>\n",
       "      <td>0.48716</td>\n",
       "      <td>36.11387</td>\n",
       "      <td>58.75971</td>\n",
       "      <td>35.78474</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>68619</th>\n",
       "      <td>8213240</td>\n",
       "      <td>4</td>\n",
       "      <td>1.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>95.07244</td>\n",
       "      <td>32.97908</td>\n",
       "      <td>8.05605</td>\n",
       "      <td>83.62714</td>\n",
       "      <td>33.98297</td>\n",
       "      <td>72.57170</td>\n",
       "      <td>38.02594</td>\n",
       "      <td>69.10716</td>\n",
       "      <td>15.29066</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>49.45850</td>\n",
       "      <td>17.81537</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.17711</td>\n",
       "      <td>28.07886</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.11215</td>\n",
       "      <td>45.16999</td>\n",
       "      <td>73.09587</td>\n",
       "      <td>14.63846</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.46338</td>\n",
       "      <td>29.05990</td>\n",
       "      <td>0.49581</td>\n",
       "      <td>36.09873</td>\n",
       "      <td>59.13618</td>\n",
       "      <td>35.66490</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>68620</th>\n",
       "      <td>8213280</td>\n",
       "      <td>4</td>\n",
       "      <td>1.76</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>94.02723</td>\n",
       "      <td>32.64123</td>\n",
       "      <td>8.64631</td>\n",
       "      <td>83.69452</td>\n",
       "      <td>33.95490</td>\n",
       "      <td>73.25213</td>\n",
       "      <td>38.32471</td>\n",
       "      <td>69.72662</td>\n",
       "      <td>15.37668</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>49.98789</td>\n",
       "      <td>17.88629</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.52427</td>\n",
       "      <td>27.80459</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.79071</td>\n",
       "      <td>45.41082</td>\n",
       "      <td>73.81773</td>\n",
       "      <td>14.90764</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.12796</td>\n",
       "      <td>28.57012</td>\n",
       "      <td>0.49725</td>\n",
       "      <td>36.09488</td>\n",
       "      <td>59.49403</td>\n",
       "      <td>35.54672</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>68621</th>\n",
       "      <td>8213320</td>\n",
       "      <td>4</td>\n",
       "      <td>1.72</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>93.09027</td>\n",
       "      <td>32.25905</td>\n",
       "      <td>9.03557</td>\n",
       "      <td>83.75073</td>\n",
       "      <td>33.90670</td>\n",
       "      <td>73.92566</td>\n",
       "      <td>38.62207</td>\n",
       "      <td>70.33493</td>\n",
       "      <td>15.48152</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>50.51776</td>\n",
       "      <td>17.94421</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.87025</td>\n",
       "      <td>27.49374</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.45720</td>\n",
       "      <td>45.61628</td>\n",
       "      <td>74.53049</td>\n",
       "      <td>15.18578</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.86682</td>\n",
       "      <td>28.08887</td>\n",
       "      <td>0.50388</td>\n",
       "      <td>36.08560</td>\n",
       "      <td>59.84347</td>\n",
       "      <td>35.39536</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>68622 rows × 61 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          time  quarter  time_left  shot_clock  phase  episode    ball_x  \\\n",
       "0            0        1     692.14       11.82      1        1  84.46792   \n",
       "1           40        1     692.10       11.79      1        1  84.66539   \n",
       "2           80        1     692.06       11.75      1        1  85.10040   \n",
       "3          120        1     692.02       11.72      1        1  85.33708   \n",
       "4          160        1     691.98       11.68      1        1  85.82441   \n",
       "...        ...      ...        ...         ...    ...      ...       ...   \n",
       "68617  8213160        4       1.88         NaN     36       82  96.67976   \n",
       "68618  8213200        4       1.84         NaN     36       82  95.87549   \n",
       "68619  8213240        4       1.80         NaN     36       82  95.07244   \n",
       "68620  8213280        4       1.76         NaN     36       82  94.02723   \n",
       "68621  8213320        4       1.72         NaN     36       82  93.09027   \n",
       "\n",
       "         ball_y    ball_z     A21_x     A21_y     A20_x     A20_y     A09_x  \\\n",
       "0      22.75675  13.03461  67.16087  29.59313       NaN       NaN  88.96864   \n",
       "1      22.97231  12.98191  67.01950  29.53259       NaN       NaN  88.78642   \n",
       "2      23.15495  12.90829  66.84565  29.46317       NaN       NaN  88.60391   \n",
       "3      23.46550  12.68268  66.65021  29.37945       NaN       NaN  88.40563   \n",
       "4      23.74433  12.44327  66.42761  29.31333       NaN       NaN  88.20060   \n",
       "...         ...       ...       ...       ...       ...       ...       ...   \n",
       "68617  33.72578   7.22921  83.45848  33.98625  71.18024  37.43370  67.83715   \n",
       "68618  33.51411   7.63900  83.54958  34.03643  71.88244  37.72820  68.47667   \n",
       "68619  32.97908   8.05605  83.62714  33.98297  72.57170  38.02594  69.10716   \n",
       "68620  32.64123   8.64631  83.69452  33.95490  73.25213  38.32471  69.72662   \n",
       "68621  32.25905   9.03557  83.75073  33.90670  73.92566  38.62207  70.33493   \n",
       "\n",
       "          A09_y  A30_x  A30_y  A33_x  A33_y  A15_x  A15_y     A12_x     A12_y  \\\n",
       "0      47.85704    NaN    NaN    NaN    NaN    NaN    NaN  78.30237  17.57163   \n",
       "1      47.80307    NaN    NaN    NaN    NaN    NaN    NaN  78.08224  17.46593   \n",
       "2      47.73646    NaN    NaN    NaN    NaN    NaN    NaN  77.81610  17.30892   \n",
       "3      47.66385    NaN    NaN    NaN    NaN    NaN    NaN  77.55261  17.18232   \n",
       "4      47.57324    NaN    NaN    NaN    NaN    NaN    NaN  77.26987  17.08339   \n",
       "...         ...    ...    ...    ...    ...    ...    ...       ...       ...   \n",
       "68617  15.14724    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN   \n",
       "68618  15.21572    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN   \n",
       "68619  15.29066    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN   \n",
       "68620  15.37668    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN   \n",
       "68621  15.48152    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN   \n",
       "\n",
       "          A14_x     A14_y  A08_x  A08_y     A02_x     A02_y  A03_x  A03_y  \\\n",
       "0      69.48956  44.72622    NaN    NaN  65.99244   4.89813    NaN    NaN   \n",
       "1      69.40549  44.61300    NaN    NaN  65.78343   4.95053    NaN    NaN   \n",
       "2      69.31841  44.49632    NaN    NaN  65.53882   5.01084    NaN    NaN   \n",
       "3      69.22388  44.38025    NaN    NaN  65.30137   5.09012    NaN    NaN   \n",
       "4      69.12495  44.26393    NaN    NaN  65.05920   5.16150    NaN    NaN   \n",
       "...         ...       ...    ...    ...       ...       ...    ...    ...   \n",
       "68617  48.39282  17.68947    NaN    NaN  83.40613  28.61137    NaN    NaN   \n",
       "68618  48.92855  17.75173    NaN    NaN  83.80381  28.34747    NaN    NaN   \n",
       "68619  49.45850  17.81537    NaN    NaN  84.17711  28.07886    NaN    NaN   \n",
       "68620  49.98789  17.88629    NaN    NaN  84.52427  27.80459    NaN    NaN   \n",
       "68621  50.51776  17.94421    NaN    NaN  84.87025  27.49374    NaN    NaN   \n",
       "\n",
       "       A17_x  A17_y  A01_x  A01_y  B42_x  B42_y     B90_x     B90_y  B08_x  \\\n",
       "0        NaN    NaN    NaN    NaN    NaN    NaN  80.84386  18.00934    NaN   \n",
       "1        NaN    NaN    NaN    NaN    NaN    NaN  80.66856  17.89438    NaN   \n",
       "2        NaN    NaN    NaN    NaN    NaN    NaN  80.49417  17.80361    NaN   \n",
       "3        NaN    NaN    NaN    NaN    NaN    NaN  80.31226  17.70554    NaN   \n",
       "4        NaN    NaN    NaN    NaN    NaN    NaN  80.16399  17.67595    NaN   \n",
       "...      ...    ...    ...    ...    ...    ...       ...       ...    ...   \n",
       "68617    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN    NaN   \n",
       "68618    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN    NaN   \n",
       "68619    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN    NaN   \n",
       "68620    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN    NaN   \n",
       "68621    NaN    NaN    NaN    NaN    NaN    NaN       NaN       NaN    NaN   \n",
       "\n",
       "       B08_y  B11_x  B11_y     B00_x     B00_y     B04_x     B04_y  B44_x  \\\n",
       "0        NaN    NaN    NaN  75.87042  39.17521  89.59344  34.15218    NaN   \n",
       "1        NaN    NaN    NaN  75.76690  39.17315  89.58985  33.77513    NaN   \n",
       "2        NaN    NaN    NaN  75.65437  39.17154  89.59990  33.40121    NaN   \n",
       "3        NaN    NaN    NaN  75.53207  39.17316  89.58999  33.02797    NaN   \n",
       "4        NaN    NaN    NaN  75.39826  39.17764  89.58705  32.66373    NaN   \n",
       "...      ...    ...    ...       ...       ...       ...       ...    ...   \n",
       "68617    NaN    NaN    NaN  73.70716  44.63824  71.66736  14.03311    NaN   \n",
       "68618    NaN    NaN    NaN  74.41699  44.91530  72.39644  14.35001    NaN   \n",
       "68619    NaN    NaN    NaN  75.11215  45.16999  73.09587  14.63846    NaN   \n",
       "68620    NaN    NaN    NaN  75.79071  45.41082  73.81773  14.90764    NaN   \n",
       "68621    NaN    NaN    NaN  76.45720  45.61628  74.53049  15.18578    NaN   \n",
       "\n",
       "       B44_y     B07_x     B07_y     B99_x     B99_y     B41_x     B41_y  \\\n",
       "0        NaN  82.75791  27.27651  78.91164  12.26497       NaN       NaN   \n",
       "1        NaN  83.00638  27.21322  79.08796  12.39129       NaN       NaN   \n",
       "2        NaN  83.26086  27.13552  79.23460  12.52712       NaN       NaN   \n",
       "3        NaN  83.51330  27.04849  79.38436  12.62605       NaN       NaN   \n",
       "4        NaN  83.76414  26.96373  79.55919  12.73218       NaN       NaN   \n",
       "...      ...       ...       ...       ...       ...       ...       ...   \n",
       "68617    NaN  88.26698  30.04334   0.48415  36.12527  58.38010  35.89495   \n",
       "68618    NaN  87.86354  29.56931   0.48716  36.11387  58.75971  35.78474   \n",
       "68619    NaN  87.46338  29.05990   0.49581  36.09873  59.13618  35.66490   \n",
       "68620    NaN  87.12796  28.57012   0.49725  36.09488  59.49403  35.54672   \n",
       "68621    NaN  86.86682  28.08887   0.50388  36.08560  59.84347  35.39536   \n",
       "\n",
       "       B13_x  B13_y  B28_x  B28_y  B12_x  B12_y  \n",
       "0        NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "1        NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "2        NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "3        NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "4        NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "...      ...    ...    ...    ...    ...    ...  \n",
       "68617    NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "68618    NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "68619    NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "68620    NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "68621    NaN    NaN    NaN    NaN    NaN    NaN  \n",
       "\n",
       "[68622 rows x 61 columns]"
      ]
     },
     "execution_count": 241,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_traces = pd.read_csv(\"data/nba_traces/21500296.csv\", header=0)\n",
    "processor = NBAProcessor(match_traces)\n",
    "processor.traces"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "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>time</th>\n",
       "      <th>quarter</th>\n",
       "      <th>time_left</th>\n",
       "      <th>shot_clock</th>\n",
       "      <th>phase</th>\n",
       "      <th>episode</th>\n",
       "      <th>ball_x</th>\n",
       "      <th>ball_y</th>\n",
       "      <th>ball_z</th>\n",
       "      <th>A21_x</th>\n",
       "      <th>A21_y</th>\n",
       "      <th>A20_x</th>\n",
       "      <th>A20_y</th>\n",
       "      <th>A09_x</th>\n",
       "      <th>A09_y</th>\n",
       "      <th>A30_x</th>\n",
       "      <th>A30_y</th>\n",
       "      <th>A33_x</th>\n",
       "      <th>A33_y</th>\n",
       "      <th>A15_x</th>\n",
       "      <th>A15_y</th>\n",
       "      <th>A12_x</th>\n",
       "      <th>A12_y</th>\n",
       "      <th>A14_x</th>\n",
       "      <th>A14_y</th>\n",
       "      <th>A08_x</th>\n",
       "      <th>A08_y</th>\n",
       "      <th>A02_x</th>\n",
       "      <th>A02_y</th>\n",
       "      <th>A03_x</th>\n",
       "      <th>A03_y</th>\n",
       "      <th>A17_x</th>\n",
       "      <th>A17_y</th>\n",
       "      <th>A01_x</th>\n",
       "      <th>A01_y</th>\n",
       "      <th>B42_x</th>\n",
       "      <th>B42_y</th>\n",
       "      <th>B90_x</th>\n",
       "      <th>B90_y</th>\n",
       "      <th>B08_x</th>\n",
       "      <th>B08_y</th>\n",
       "      <th>B11_x</th>\n",
       "      <th>B11_y</th>\n",
       "      <th>B00_x</th>\n",
       "      <th>B00_y</th>\n",
       "      <th>B04_x</th>\n",
       "      <th>B04_y</th>\n",
       "      <th>B44_x</th>\n",
       "      <th>B44_y</th>\n",
       "      <th>B07_x</th>\n",
       "      <th>B07_y</th>\n",
       "      <th>B99_x</th>\n",
       "      <th>B99_y</th>\n",
       "      <th>B41_x</th>\n",
       "      <th>B41_y</th>\n",
       "      <th>B13_x</th>\n",
       "      <th>B13_y</th>\n",
       "      <th>B28_x</th>\n",
       "      <th>B28_y</th>\n",
       "      <th>B12_x</th>\n",
       "      <th>B12_y</th>\n",
       "      <th>attack_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>692.1</td>\n",
       "      <td>11.8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.467920</td>\n",
       "      <td>22.756750</td>\n",
       "      <td>13.034610</td>\n",
       "      <td>67.160870</td>\n",
       "      <td>29.593130</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.968640</td>\n",
       "      <td>47.857040</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>78.302370</td>\n",
       "      <td>17.571630</td>\n",
       "      <td>69.489560</td>\n",
       "      <td>44.726220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.992440</td>\n",
       "      <td>4.898130</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>80.843860</td>\n",
       "      <td>18.009340</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.870420</td>\n",
       "      <td>39.175210</td>\n",
       "      <td>89.593440</td>\n",
       "      <td>34.152180</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.757910</td>\n",
       "      <td>27.276510</td>\n",
       "      <td>78.911640</td>\n",
       "      <td>12.264970</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.1</td>\n",
       "      <td>1</td>\n",
       "      <td>692.0</td>\n",
       "      <td>11.7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>85.218740</td>\n",
       "      <td>23.310225</td>\n",
       "      <td>12.795485</td>\n",
       "      <td>66.747930</td>\n",
       "      <td>29.421310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.504770</td>\n",
       "      <td>47.700155</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>77.684355</td>\n",
       "      <td>17.245620</td>\n",
       "      <td>69.271145</td>\n",
       "      <td>44.438285</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.420095</td>\n",
       "      <td>5.050480</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>80.403215</td>\n",
       "      <td>17.754575</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.593220</td>\n",
       "      <td>39.172350</td>\n",
       "      <td>89.594945</td>\n",
       "      <td>33.214590</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.387080</td>\n",
       "      <td>27.092005</td>\n",
       "      <td>79.309480</td>\n",
       "      <td>12.576585</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.2</td>\n",
       "      <td>1</td>\n",
       "      <td>691.9</td>\n",
       "      <td>11.6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>86.142630</td>\n",
       "      <td>23.896400</td>\n",
       "      <td>12.221390</td>\n",
       "      <td>66.208660</td>\n",
       "      <td>29.264780</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.987420</td>\n",
       "      <td>47.473810</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>76.991410</td>\n",
       "      <td>16.986360</td>\n",
       "      <td>69.029190</td>\n",
       "      <td>44.142550</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64.807280</td>\n",
       "      <td>5.223380</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>80.023840</td>\n",
       "      <td>17.627740</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.255640</td>\n",
       "      <td>39.189030</td>\n",
       "      <td>89.586960</td>\n",
       "      <td>32.302380</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.016990</td>\n",
       "      <td>26.875770</td>\n",
       "      <td>79.680370</td>\n",
       "      <td>12.910950</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.3</td>\n",
       "      <td>1</td>\n",
       "      <td>691.8</td>\n",
       "      <td>11.6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>86.965765</td>\n",
       "      <td>24.523960</td>\n",
       "      <td>11.305590</td>\n",
       "      <td>65.652820</td>\n",
       "      <td>29.171900</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.419755</td>\n",
       "      <td>47.177575</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>76.264045</td>\n",
       "      <td>16.755405</td>\n",
       "      <td>68.749195</td>\n",
       "      <td>43.842570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64.175330</td>\n",
       "      <td>5.371300</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>79.638305</td>\n",
       "      <td>17.437890</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74.863510</td>\n",
       "      <td>39.231585</td>\n",
       "      <td>89.515250</td>\n",
       "      <td>31.423230</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.646525</td>\n",
       "      <td>26.580760</td>\n",
       "      <td>79.959105</td>\n",
       "      <td>13.333745</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.4</td>\n",
       "      <td>1</td>\n",
       "      <td>691.7</td>\n",
       "      <td>11.5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>87.623240</td>\n",
       "      <td>25.075430</td>\n",
       "      <td>10.302060</td>\n",
       "      <td>65.079570</td>\n",
       "      <td>29.057190</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.774180</td>\n",
       "      <td>46.827600</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>75.502370</td>\n",
       "      <td>16.508620</td>\n",
       "      <td>68.390980</td>\n",
       "      <td>43.536770</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63.579910</td>\n",
       "      <td>5.544400</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>79.200260</td>\n",
       "      <td>17.025310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74.410670</td>\n",
       "      <td>39.314460</td>\n",
       "      <td>89.336950</td>\n",
       "      <td>30.653520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.170210</td>\n",
       "      <td>26.306700</td>\n",
       "      <td>80.296760</td>\n",
       "      <td>13.686930</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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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",
       "      <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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28132</th>\n",
       "      <td>8212.9</td>\n",
       "      <td>4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>94.920735</td>\n",
       "      <td>33.774750</td>\n",
       "      <td>6.039140</td>\n",
       "      <td>82.429975</td>\n",
       "      <td>33.563640</td>\n",
       "      <td>66.537605</td>\n",
       "      <td>35.540095</td>\n",
       "      <td>63.720340</td>\n",
       "      <td>14.737810</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>44.851835</td>\n",
       "      <td>17.311575</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.436565</td>\n",
       "      <td>30.069990</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>68.895470</td>\n",
       "      <td>42.404315</td>\n",
       "      <td>66.631015</td>\n",
       "      <td>12.311610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.377425</td>\n",
       "      <td>32.525705</td>\n",
       "      <td>0.424150</td>\n",
       "      <td>36.176025</td>\n",
       "      <td>55.789665</td>\n",
       "      <td>36.429200</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>407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28133</th>\n",
       "      <td>8213.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>95.894760</td>\n",
       "      <td>34.124460</td>\n",
       "      <td>5.020700</td>\n",
       "      <td>82.909330</td>\n",
       "      <td>33.728410</td>\n",
       "      <td>68.347050</td>\n",
       "      <td>36.253290</td>\n",
       "      <td>65.294720</td>\n",
       "      <td>14.899860</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>46.222770</td>\n",
       "      <td>17.444190</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.633960</td>\n",
       "      <td>29.629230</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70.754060</td>\n",
       "      <td>43.324320</td>\n",
       "      <td>68.608680</td>\n",
       "      <td>12.922570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>89.804230</td>\n",
       "      <td>31.738040</td>\n",
       "      <td>0.449680</td>\n",
       "      <td>36.167650</td>\n",
       "      <td>56.806410</td>\n",
       "      <td>36.292490</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>407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28134</th>\n",
       "      <td>8213.1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>96.690350</td>\n",
       "      <td>34.184875</td>\n",
       "      <td>6.015505</td>\n",
       "      <td>83.271195</td>\n",
       "      <td>33.887045</td>\n",
       "      <td>70.126140</td>\n",
       "      <td>36.989570</td>\n",
       "      <td>66.882015</td>\n",
       "      <td>15.051900</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>47.581435</td>\n",
       "      <td>17.589040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.764145</td>\n",
       "      <td>29.033885</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72.621155</td>\n",
       "      <td>44.171140</td>\n",
       "      <td>70.529975</td>\n",
       "      <td>13.585885</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.858970</td>\n",
       "      <td>30.724200</td>\n",
       "      <td>0.469860</td>\n",
       "      <td>36.141500</td>\n",
       "      <td>57.806560</td>\n",
       "      <td>36.047205</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>407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28135</th>\n",
       "      <td>8213.2</td>\n",
       "      <td>4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>95.875490</td>\n",
       "      <td>33.514110</td>\n",
       "      <td>7.639000</td>\n",
       "      <td>83.549580</td>\n",
       "      <td>34.036430</td>\n",
       "      <td>71.882440</td>\n",
       "      <td>37.728200</td>\n",
       "      <td>68.476670</td>\n",
       "      <td>15.215720</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>48.928550</td>\n",
       "      <td>17.751730</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.803810</td>\n",
       "      <td>28.347470</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74.416990</td>\n",
       "      <td>44.915300</td>\n",
       "      <td>72.396440</td>\n",
       "      <td>14.350010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.863540</td>\n",
       "      <td>29.569310</td>\n",
       "      <td>0.487160</td>\n",
       "      <td>36.113870</td>\n",
       "      <td>58.759710</td>\n",
       "      <td>35.784740</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>407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28136</th>\n",
       "      <td>8213.3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.7</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>93.558750</td>\n",
       "      <td>32.450140</td>\n",
       "      <td>8.840940</td>\n",
       "      <td>83.722625</td>\n",
       "      <td>33.930800</td>\n",
       "      <td>73.588895</td>\n",
       "      <td>38.473390</td>\n",
       "      <td>70.030775</td>\n",
       "      <td>15.429100</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>50.252825</td>\n",
       "      <td>17.915250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.697260</td>\n",
       "      <td>27.649165</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.123955</td>\n",
       "      <td>45.513550</td>\n",
       "      <td>74.174110</td>\n",
       "      <td>15.046710</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.997390</td>\n",
       "      <td>28.329495</td>\n",
       "      <td>0.500565</td>\n",
       "      <td>36.090240</td>\n",
       "      <td>59.668750</td>\n",
       "      <td>35.471040</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>407</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>28137 rows × 62 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         time  quarter  time_left  shot_clock  phase  episode     ball_x  \\\n",
       "0         0.0        1      692.1        11.8      1        1  84.467920   \n",
       "1         0.1        1      692.0        11.7      1        1  85.218740   \n",
       "2         0.2        1      691.9        11.6      1        1  86.142630   \n",
       "3         0.3        1      691.8        11.6      1        1  86.965765   \n",
       "4         0.4        1      691.7        11.5      1        1  87.623240   \n",
       "...       ...      ...        ...         ...    ...      ...        ...   \n",
       "28132  8212.9        4        2.0         7.9     36       82  94.920735   \n",
       "28133  8213.0        4        2.0         7.9     36       82  95.894760   \n",
       "28134  8213.1        4        1.9         7.9     36       82  96.690350   \n",
       "28135  8213.2        4        1.8         7.9     36       82  95.875490   \n",
       "28136  8213.3        4        1.7         7.9     36       82  93.558750   \n",
       "\n",
       "          ball_y     ball_z      A21_x      A21_y      A20_x      A20_y  \\\n",
       "0      22.756750  13.034610  67.160870  29.593130        NaN        NaN   \n",
       "1      23.310225  12.795485  66.747930  29.421310        NaN        NaN   \n",
       "2      23.896400  12.221390  66.208660  29.264780        NaN        NaN   \n",
       "3      24.523960  11.305590  65.652820  29.171900        NaN        NaN   \n",
       "4      25.075430  10.302060  65.079570  29.057190        NaN        NaN   \n",
       "...          ...        ...        ...        ...        ...        ...   \n",
       "28132  33.774750   6.039140  82.429975  33.563640  66.537605  35.540095   \n",
       "28133  34.124460   5.020700  82.909330  33.728410  68.347050  36.253290   \n",
       "28134  34.184875   6.015505  83.271195  33.887045  70.126140  36.989570   \n",
       "28135  33.514110   7.639000  83.549580  34.036430  71.882440  37.728200   \n",
       "28136  32.450140   8.840940  83.722625  33.930800  73.588895  38.473390   \n",
       "\n",
       "           A09_x      A09_y  A30_x  A30_y  A33_x  A33_y  A15_x  A15_y  \\\n",
       "0      88.968640  47.857040    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "1      88.504770  47.700155    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "2      87.987420  47.473810    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "3      87.419755  47.177575    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "4      86.774180  46.827600    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "...          ...        ...    ...    ...    ...    ...    ...    ...   \n",
       "28132  63.720340  14.737810    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28133  65.294720  14.899860    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28134  66.882015  15.051900    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28135  68.476670  15.215720    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28136  70.030775  15.429100    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "\n",
       "           A12_x      A12_y      A14_x      A14_y  A08_x  A08_y      A02_x  \\\n",
       "0      78.302370  17.571630  69.489560  44.726220    NaN    NaN  65.992440   \n",
       "1      77.684355  17.245620  69.271145  44.438285    NaN    NaN  65.420095   \n",
       "2      76.991410  16.986360  69.029190  44.142550    NaN    NaN  64.807280   \n",
       "3      76.264045  16.755405  68.749195  43.842570    NaN    NaN  64.175330   \n",
       "4      75.502370  16.508620  68.390980  43.536770    NaN    NaN  63.579910   \n",
       "...          ...        ...        ...        ...    ...    ...        ...   \n",
       "28132        NaN        NaN  44.851835  17.311575    NaN    NaN  80.436565   \n",
       "28133        NaN        NaN  46.222770  17.444190    NaN    NaN  81.633960   \n",
       "28134        NaN        NaN  47.581435  17.589040    NaN    NaN  82.764145   \n",
       "28135        NaN        NaN  48.928550  17.751730    NaN    NaN  83.803810   \n",
       "28136        NaN        NaN  50.252825  17.915250    NaN    NaN  84.697260   \n",
       "\n",
       "           A02_y  A03_x  A03_y  A17_x  A17_y  A01_x  A01_y  B42_x  B42_y  \\\n",
       "0       4.898130    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "1       5.050480    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "2       5.223380    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "3       5.371300    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "4       5.544400    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "...          ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "28132  30.069990    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28133  29.629230    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28134  29.033885    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28135  28.347470    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "28136  27.649165    NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "\n",
       "           B90_x      B90_y  B08_x  B08_y  B11_x  B11_y      B00_x      B00_y  \\\n",
       "0      80.843860  18.009340    NaN    NaN    NaN    NaN  75.870420  39.175210   \n",
       "1      80.403215  17.754575    NaN    NaN    NaN    NaN  75.593220  39.172350   \n",
       "2      80.023840  17.627740    NaN    NaN    NaN    NaN  75.255640  39.189030   \n",
       "3      79.638305  17.437890    NaN    NaN    NaN    NaN  74.863510  39.231585   \n",
       "4      79.200260  17.025310    NaN    NaN    NaN    NaN  74.410670  39.314460   \n",
       "...          ...        ...    ...    ...    ...    ...        ...        ...   \n",
       "28132        NaN        NaN    NaN    NaN    NaN    NaN  68.895470  42.404315   \n",
       "28133        NaN        NaN    NaN    NaN    NaN    NaN  70.754060  43.324320   \n",
       "28134        NaN        NaN    NaN    NaN    NaN    NaN  72.621155  44.171140   \n",
       "28135        NaN        NaN    NaN    NaN    NaN    NaN  74.416990  44.915300   \n",
       "28136        NaN        NaN    NaN    NaN    NaN    NaN  76.123955  45.513550   \n",
       "\n",
       "           B04_x      B04_y  B44_x  B44_y      B07_x      B07_y      B99_x  \\\n",
       "0      89.593440  34.152180    NaN    NaN  82.757910  27.276510  78.911640   \n",
       "1      89.594945  33.214590    NaN    NaN  83.387080  27.092005  79.309480   \n",
       "2      89.586960  32.302380    NaN    NaN  84.016990  26.875770  79.680370   \n",
       "3      89.515250  31.423230    NaN    NaN  84.646525  26.580760  79.959105   \n",
       "4      89.336950  30.653520    NaN    NaN  85.170210  26.306700  80.296760   \n",
       "...          ...        ...    ...    ...        ...        ...        ...   \n",
       "28132  66.631015  12.311610    NaN    NaN  90.377425  32.525705   0.424150   \n",
       "28133  68.608680  12.922570    NaN    NaN  89.804230  31.738040   0.449680   \n",
       "28134  70.529975  13.585885    NaN    NaN  88.858970  30.724200   0.469860   \n",
       "28135  72.396440  14.350010    NaN    NaN  87.863540  29.569310   0.487160   \n",
       "28136  74.174110  15.046710    NaN    NaN  86.997390  28.329495   0.500565   \n",
       "\n",
       "           B99_y      B41_x      B41_y  B13_x  B13_y  B28_x  B28_y  B12_x  \\\n",
       "0      12.264970        NaN        NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "1      12.576585        NaN        NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "2      12.910950        NaN        NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "3      13.333745        NaN        NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "4      13.686930        NaN        NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "...          ...        ...        ...    ...    ...    ...    ...    ...   \n",
       "28132  36.176025  55.789665  36.429200    NaN    NaN    NaN    NaN    NaN   \n",
       "28133  36.167650  56.806410  36.292490    NaN    NaN    NaN    NaN    NaN   \n",
       "28134  36.141500  57.806560  36.047205    NaN    NaN    NaN    NaN    NaN   \n",
       "28135  36.113870  58.759710  35.784740    NaN    NaN    NaN    NaN    NaN   \n",
       "28136  36.090240  59.668750  35.471040    NaN    NaN    NaN    NaN    NaN   \n",
       "\n",
       "       B12_y  attack_id  \n",
       "0        NaN          1  \n",
       "1        NaN          1  \n",
       "2        NaN          1  \n",
       "3        NaN          1  \n",
       "4        NaN          1  \n",
       "...      ...        ...  \n",
       "28132    NaN        407  \n",
       "28133    NaN        407  \n",
       "28134    NaN        407  \n",
       "28135    NaN        407  \n",
       "28136    NaN        407  \n",
       "\n",
       "[28137 rows x 62 columns]"
      ]
     },
     "execution_count": 242,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "processor.downsample_to_10fps()\n",
    "processor.traces"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Calculating player velocities: 100%|██████████| 26/26 [00:01<00:00, 14.47it/s]\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>time</th>\n",
       "      <th>quarter</th>\n",
       "      <th>time_left</th>\n",
       "      <th>shot_clock</th>\n",
       "      <th>phase</th>\n",
       "      <th>episode</th>\n",
       "      <th>attack_id</th>\n",
       "      <th>A01_x</th>\n",
       "      <th>A01_y</th>\n",
       "      <th>A01_vx</th>\n",
       "      <th>A01_vy</th>\n",
       "      <th>A02_x</th>\n",
       "      <th>A02_y</th>\n",
       "      <th>A02_vx</th>\n",
       "      <th>A02_vy</th>\n",
       "      <th>A03_x</th>\n",
       "      <th>A03_y</th>\n",
       "      <th>A03_vx</th>\n",
       "      <th>A03_vy</th>\n",
       "      <th>A08_x</th>\n",
       "      <th>A08_y</th>\n",
       "      <th>A08_vx</th>\n",
       "      <th>A08_vy</th>\n",
       "      <th>A09_x</th>\n",
       "      <th>A09_y</th>\n",
       "      <th>A09_vx</th>\n",
       "      <th>A09_vy</th>\n",
       "      <th>A12_x</th>\n",
       "      <th>A12_y</th>\n",
       "      <th>A12_vx</th>\n",
       "      <th>A12_vy</th>\n",
       "      <th>A14_x</th>\n",
       "      <th>A14_y</th>\n",
       "      <th>A14_vx</th>\n",
       "      <th>A14_vy</th>\n",
       "      <th>A15_x</th>\n",
       "      <th>A15_y</th>\n",
       "      <th>A15_vx</th>\n",
       "      <th>A15_vy</th>\n",
       "      <th>A17_x</th>\n",
       "      <th>A17_y</th>\n",
       "      <th>A17_vx</th>\n",
       "      <th>A17_vy</th>\n",
       "      <th>A20_x</th>\n",
       "      <th>A20_y</th>\n",
       "      <th>A20_vx</th>\n",
       "      <th>A20_vy</th>\n",
       "      <th>A21_x</th>\n",
       "      <th>A21_y</th>\n",
       "      <th>A21_vx</th>\n",
       "      <th>A21_vy</th>\n",
       "      <th>A30_x</th>\n",
       "      <th>A30_y</th>\n",
       "      <th>A30_vx</th>\n",
       "      <th>A30_vy</th>\n",
       "      <th>A33_x</th>\n",
       "      <th>A33_y</th>\n",
       "      <th>A33_vx</th>\n",
       "      <th>A33_vy</th>\n",
       "      <th>B00_x</th>\n",
       "      <th>B00_y</th>\n",
       "      <th>B00_vx</th>\n",
       "      <th>B00_vy</th>\n",
       "      <th>B04_x</th>\n",
       "      <th>B04_y</th>\n",
       "      <th>B04_vx</th>\n",
       "      <th>B04_vy</th>\n",
       "      <th>B07_x</th>\n",
       "      <th>B07_y</th>\n",
       "      <th>B07_vx</th>\n",
       "      <th>B07_vy</th>\n",
       "      <th>B08_x</th>\n",
       "      <th>B08_y</th>\n",
       "      <th>B08_vx</th>\n",
       "      <th>B08_vy</th>\n",
       "      <th>B11_x</th>\n",
       "      <th>B11_y</th>\n",
       "      <th>B11_vx</th>\n",
       "      <th>B11_vy</th>\n",
       "      <th>B12_x</th>\n",
       "      <th>B12_y</th>\n",
       "      <th>B12_vx</th>\n",
       "      <th>B12_vy</th>\n",
       "      <th>B13_x</th>\n",
       "      <th>B13_y</th>\n",
       "      <th>B13_vx</th>\n",
       "      <th>B13_vy</th>\n",
       "      <th>B28_x</th>\n",
       "      <th>B28_y</th>\n",
       "      <th>B28_vx</th>\n",
       "      <th>B28_vy</th>\n",
       "      <th>B41_x</th>\n",
       "      <th>B41_y</th>\n",
       "      <th>B41_vx</th>\n",
       "      <th>B41_vy</th>\n",
       "      <th>B42_x</th>\n",
       "      <th>B42_y</th>\n",
       "      <th>B42_vx</th>\n",
       "      <th>B42_vy</th>\n",
       "      <th>B44_x</th>\n",
       "      <th>B44_y</th>\n",
       "      <th>B44_vx</th>\n",
       "      <th>B44_vy</th>\n",
       "      <th>B90_x</th>\n",
       "      <th>B90_y</th>\n",
       "      <th>B90_vx</th>\n",
       "      <th>B90_vy</th>\n",
       "      <th>B99_x</th>\n",
       "      <th>B99_y</th>\n",
       "      <th>B99_vx</th>\n",
       "      <th>B99_vy</th>\n",
       "      <th>ball_x</th>\n",
       "      <th>ball_y</th>\n",
       "      <th>ball_z</th>\n",
       "      <th>ball_vx</th>\n",
       "      <th>ball_vy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>692.1</td>\n",
       "      <td>11.8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.785121</td>\n",
       "      <td>1.425455</td>\n",
       "      <td>-1.697714</td>\n",
       "      <td>0.772240</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>26.740388</td>\n",
       "      <td>14.429423</td>\n",
       "      <td>-1.711422</td>\n",
       "      <td>-0.936562</td>\n",
       "      <td>23.524818</td>\n",
       "      <td>5.302147</td>\n",
       "      <td>-2.137299</td>\n",
       "      <td>-1.002956</td>\n",
       "      <td>20.873405</td>\n",
       "      <td>13.412041</td>\n",
       "      <td>-0.778407</td>\n",
       "      <td>-0.884742</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.174437</td>\n",
       "      <td>8.819221</td>\n",
       "      <td>-1.544859</td>\n",
       "      <td>-0.201247</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>22.878861</td>\n",
       "      <td>11.737098</td>\n",
       "      <td>-1.597269</td>\n",
       "      <td>0.178869</td>\n",
       "      <td>26.994781</td>\n",
       "      <td>10.151064</td>\n",
       "      <td>-0.434501</td>\n",
       "      <td>-2.487465</td>\n",
       "      <td>24.878534</td>\n",
       "      <td>8.194209</td>\n",
       "      <td>1.745615</td>\n",
       "      <td>-0.559515</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.158185</td>\n",
       "      <td>5.479669</td>\n",
       "      <td>-0.681589</td>\n",
       "      <td>-1.097153</td>\n",
       "      <td>23.564414</td>\n",
       "      <td>3.668931</td>\n",
       "      <td>1.709916</td>\n",
       "      <td>1.162039</td>\n",
       "      <td>25.340376</td>\n",
       "      <td>6.827025</td>\n",
       "      <td>3.910383</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.1</td>\n",
       "      <td>1</td>\n",
       "      <td>692.0</td>\n",
       "      <td>11.7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.615925</td>\n",
       "      <td>1.504358</td>\n",
       "      <td>-1.703008</td>\n",
       "      <td>0.756797</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>26.576244</td>\n",
       "      <td>14.341800</td>\n",
       "      <td>-1.775765</td>\n",
       "      <td>-0.992032</td>\n",
       "      <td>23.315887</td>\n",
       "      <td>5.195711</td>\n",
       "      <td>-2.181419</td>\n",
       "      <td>-0.946496</td>\n",
       "      <td>20.804271</td>\n",
       "      <td>13.321966</td>\n",
       "      <td>-0.858472</td>\n",
       "      <td>-0.870023</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.024861</td>\n",
       "      <td>8.800411</td>\n",
       "      <td>-1.590008</td>\n",
       "      <td>-0.213339</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>22.718900</td>\n",
       "      <td>11.753463</td>\n",
       "      <td>-1.595119</td>\n",
       "      <td>0.192865</td>\n",
       "      <td>26.963840</td>\n",
       "      <td>9.891161</td>\n",
       "      <td>-0.549526</td>\n",
       "      <td>-2.384881</td>\n",
       "      <td>25.063909</td>\n",
       "      <td>8.136124</td>\n",
       "      <td>1.646187</td>\n",
       "      <td>-0.539896</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.100867</td>\n",
       "      <td>5.367952</td>\n",
       "      <td>-0.781268</td>\n",
       "      <td>-1.078746</td>\n",
       "      <td>23.746529</td>\n",
       "      <td>3.788690</td>\n",
       "      <td>1.607638</td>\n",
       "      <td>1.129349</td>\n",
       "      <td>25.565622</td>\n",
       "      <td>6.993068</td>\n",
       "      <td>3.838645</td>\n",
       "      <td>2.252460</td>\n",
       "      <td>1.660425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.2</td>\n",
       "      <td>1</td>\n",
       "      <td>691.9</td>\n",
       "      <td>11.6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.445660</td>\n",
       "      <td>1.580143</td>\n",
       "      <td>-1.709199</td>\n",
       "      <td>0.738736</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>26.399104</td>\n",
       "      <td>14.242972</td>\n",
       "      <td>-1.851014</td>\n",
       "      <td>-1.056904</td>\n",
       "      <td>23.098044</td>\n",
       "      <td>5.100679</td>\n",
       "      <td>-2.233017</td>\n",
       "      <td>-0.880467</td>\n",
       "      <td>20.718967</td>\n",
       "      <td>13.234863</td>\n",
       "      <td>-0.952107</td>\n",
       "      <td>-0.852808</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.866167</td>\n",
       "      <td>8.779159</td>\n",
       "      <td>-1.642810</td>\n",
       "      <td>-0.227481</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>22.559374</td>\n",
       "      <td>11.772655</td>\n",
       "      <td>-1.592605</td>\n",
       "      <td>0.209233</td>\n",
       "      <td>26.909668</td>\n",
       "      <td>9.651978</td>\n",
       "      <td>-0.684046</td>\n",
       "      <td>-2.264910</td>\n",
       "      <td>25.229202</td>\n",
       "      <td>8.082001</td>\n",
       "      <td>1.529908</td>\n",
       "      <td>-0.516951</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.023416</td>\n",
       "      <td>5.259952</td>\n",
       "      <td>-0.897843</td>\n",
       "      <td>-1.057220</td>\n",
       "      <td>23.907987</td>\n",
       "      <td>3.901847</td>\n",
       "      <td>1.488024</td>\n",
       "      <td>1.091120</td>\n",
       "      <td>25.842789</td>\n",
       "      <td>7.168920</td>\n",
       "      <td>3.666417</td>\n",
       "      <td>2.771670</td>\n",
       "      <td>1.758525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.3</td>\n",
       "      <td>1</td>\n",
       "      <td>691.8</td>\n",
       "      <td>11.6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.274326</td>\n",
       "      <td>1.652808</td>\n",
       "      <td>-1.716288</td>\n",
       "      <td>0.718058</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>26.208968</td>\n",
       "      <td>14.132941</td>\n",
       "      <td>-1.937168</td>\n",
       "      <td>-1.131177</td>\n",
       "      <td>22.871290</td>\n",
       "      <td>5.017050</td>\n",
       "      <td>-2.292093</td>\n",
       "      <td>-0.804868</td>\n",
       "      <td>20.617491</td>\n",
       "      <td>13.150734</td>\n",
       "      <td>-1.059312</td>\n",
       "      <td>-0.833099</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.698353</td>\n",
       "      <td>8.755465</td>\n",
       "      <td>-1.703264</td>\n",
       "      <td>-0.243672</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>22.400281</td>\n",
       "      <td>11.794673</td>\n",
       "      <td>-1.589727</td>\n",
       "      <td>0.227972</td>\n",
       "      <td>26.832263</td>\n",
       "      <td>9.433514</td>\n",
       "      <td>-0.838063</td>\n",
       "      <td>-2.127551</td>\n",
       "      <td>25.374412</td>\n",
       "      <td>8.031841</td>\n",
       "      <td>1.396776</td>\n",
       "      <td>-0.490681</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.925832</td>\n",
       "      <td>5.155671</td>\n",
       "      <td>-1.031312</td>\n",
       "      <td>-1.032573</td>\n",
       "      <td>24.048786</td>\n",
       "      <td>4.008401</td>\n",
       "      <td>1.351076</td>\n",
       "      <td>1.047349</td>\n",
       "      <td>26.089730</td>\n",
       "      <td>7.357188</td>\n",
       "      <td>3.391677</td>\n",
       "      <td>2.469405</td>\n",
       "      <td>1.882680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.4</td>\n",
       "      <td>1</td>\n",
       "      <td>691.7</td>\n",
       "      <td>11.5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.101922</td>\n",
       "      <td>1.722354</td>\n",
       "      <td>-1.724274</td>\n",
       "      <td>0.694762</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>26.005836</td>\n",
       "      <td>14.011707</td>\n",
       "      <td>-2.034227</td>\n",
       "      <td>-1.214852</td>\n",
       "      <td>22.635624</td>\n",
       "      <td>4.944825</td>\n",
       "      <td>-2.358648</td>\n",
       "      <td>-0.719699</td>\n",
       "      <td>20.499845</td>\n",
       "      <td>13.069579</td>\n",
       "      <td>-1.180088</td>\n",
       "      <td>-0.810894</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.521420</td>\n",
       "      <td>8.729329</td>\n",
       "      <td>-1.771371</td>\n",
       "      <td>-0.261912</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>22.241623</td>\n",
       "      <td>11.819518</td>\n",
       "      <td>-1.586484</td>\n",
       "      <td>0.249084</td>\n",
       "      <td>26.731625</td>\n",
       "      <td>9.235769</td>\n",
       "      <td>-1.011574</td>\n",
       "      <td>-1.972806</td>\n",
       "      <td>25.499541</td>\n",
       "      <td>7.985644</td>\n",
       "      <td>1.246792</td>\n",
       "      <td>-0.461086</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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.808115</td>\n",
       "      <td>5.055107</td>\n",
       "      <td>-1.181676</td>\n",
       "      <td>-1.004807</td>\n",
       "      <td>24.168927</td>\n",
       "      <td>4.108353</td>\n",
       "      <td>1.196792</td>\n",
       "      <td>0.998038</td>\n",
       "      <td>26.286972</td>\n",
       "      <td>7.522629</td>\n",
       "      <td>3.090618</td>\n",
       "      <td>1.972425</td>\n",
       "      <td>1.654410</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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <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>28132</th>\n",
       "      <td>8212.9</td>\n",
       "      <td>4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.962958</td>\n",
       "      <td>8.901634</td>\n",
       "      <td>4.264577</td>\n",
       "      <td>-0.875640</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>19.075324</td>\n",
       "      <td>4.321346</td>\n",
       "      <td>4.621708</td>\n",
       "      <td>0.541600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.381986</td>\n",
       "      <td>5.139954</td>\n",
       "      <td>4.261967</td>\n",
       "      <td>0.314273</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>19.906936</td>\n",
       "      <td>10.660952</td>\n",
       "      <td>5.371589</td>\n",
       "      <td>2.186802</td>\n",
       "      <td>24.552440</td>\n",
       "      <td>10.096246</td>\n",
       "      <td>2.340394</td>\n",
       "      <td>0.147493</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>20.599456</td>\n",
       "      <td>12.674387</td>\n",
       "      <td>5.712417</td>\n",
       "      <td>2.728683</td>\n",
       "      <td>19.910104</td>\n",
       "      <td>3.599947</td>\n",
       "      <td>6.000484</td>\n",
       "      <td>1.850492</td>\n",
       "      <td>26.655054</td>\n",
       "      <td>9.581450</td>\n",
       "      <td>0.913126</td>\n",
       "      <td>-1.558759</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",
       "      <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",
       "      <td>16.653472</td>\n",
       "      <td>10.928526</td>\n",
       "      <td>3.254720</td>\n",
       "      <td>-0.136453</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.121979</td>\n",
       "      <td>10.849233</td>\n",
       "      <td>0.099989</td>\n",
       "      <td>-0.019777</td>\n",
       "      <td>28.476220</td>\n",
       "      <td>10.132425</td>\n",
       "      <td>1.811742</td>\n",
       "      <td>2.152305</td>\n",
       "      <td>-0.419940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28133</th>\n",
       "      <td>8213.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.394685</td>\n",
       "      <td>8.804957</td>\n",
       "      <td>4.267991</td>\n",
       "      <td>-0.986734</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>19.557380</td>\n",
       "      <td>4.401934</td>\n",
       "      <td>4.801634</td>\n",
       "      <td>0.784653</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.824150</td>\n",
       "      <td>5.193051</td>\n",
       "      <td>4.388477</td>\n",
       "      <td>0.520662</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>20.458679</td>\n",
       "      <td>10.880543</td>\n",
       "      <td>5.496925</td>\n",
       "      <td>2.202721</td>\n",
       "      <td>24.789796</td>\n",
       "      <td>10.110178</td>\n",
       "      <td>2.300408</td>\n",
       "      <td>0.135646</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>21.184967</td>\n",
       "      <td>12.940565</td>\n",
       "      <td>5.814868</td>\n",
       "      <td>2.663178</td>\n",
       "      <td>20.523531</td>\n",
       "      <td>3.818770</td>\n",
       "      <td>6.097726</td>\n",
       "      <td>2.169629</td>\n",
       "      <td>26.721495</td>\n",
       "      <td>9.408491</td>\n",
       "      <td>0.575991</td>\n",
       "      <td>-1.762124</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",
       "      <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",
       "      <td>16.988693</td>\n",
       "      <td>10.891935</td>\n",
       "      <td>3.336698</td>\n",
       "      <td>-0.378937</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.131731</td>\n",
       "      <td>10.846705</td>\n",
       "      <td>0.096225</td>\n",
       "      <td>-0.026794</td>\n",
       "      <td>28.768428</td>\n",
       "      <td>10.237338</td>\n",
       "      <td>1.506210</td>\n",
       "      <td>2.922075</td>\n",
       "      <td>1.049130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28134</th>\n",
       "      <td>8213.1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.826425</td>\n",
       "      <td>8.697038</td>\n",
       "      <td>4.287830</td>\n",
       "      <td>-1.091172</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>20.057303</td>\n",
       "      <td>4.506685</td>\n",
       "      <td>4.987871</td>\n",
       "      <td>1.034780</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.278743</td>\n",
       "      <td>5.266719</td>\n",
       "      <td>4.526039</td>\n",
       "      <td>0.730489</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>21.022819</td>\n",
       "      <td>11.101772</td>\n",
       "      <td>5.629096</td>\n",
       "      <td>2.216372</td>\n",
       "      <td>25.022666</td>\n",
       "      <td>10.122899</td>\n",
       "      <td>2.284806</td>\n",
       "      <td>0.125020</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>21.780455</td>\n",
       "      <td>13.200202</td>\n",
       "      <td>5.930733</td>\n",
       "      <td>2.597207</td>\n",
       "      <td>21.146439</td>\n",
       "      <td>4.069383</td>\n",
       "      <td>6.207149</td>\n",
       "      <td>2.494967</td>\n",
       "      <td>26.754276</td>\n",
       "      <td>9.215215</td>\n",
       "      <td>0.270623</td>\n",
       "      <td>-1.953799</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",
       "      <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",
       "      <td>17.332008</td>\n",
       "      <td>10.831009</td>\n",
       "      <td>3.423847</td>\n",
       "      <td>-0.617079</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.141097</td>\n",
       "      <td>10.843464</td>\n",
       "      <td>0.092892</td>\n",
       "      <td>-0.033309</td>\n",
       "      <td>29.007105</td>\n",
       "      <td>10.255463</td>\n",
       "      <td>1.804651</td>\n",
       "      <td>2.386770</td>\n",
       "      <td>0.181245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28135</th>\n",
       "      <td>8213.2</td>\n",
       "      <td>4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.258177</td>\n",
       "      <td>8.577876</td>\n",
       "      <td>4.324094</td>\n",
       "      <td>-1.188955</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>20.575092</td>\n",
       "      <td>4.635600</td>\n",
       "      <td>5.180417</td>\n",
       "      <td>1.291982</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.745767</td>\n",
       "      <td>5.360956</td>\n",
       "      <td>4.674655</td>\n",
       "      <td>0.943751</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>21.599356</td>\n",
       "      <td>11.324638</td>\n",
       "      <td>5.768100</td>\n",
       "      <td>2.227754</td>\n",
       "      <td>25.251049</td>\n",
       "      <td>10.134412</td>\n",
       "      <td>2.293589</td>\n",
       "      <td>0.115616</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>22.385919</td>\n",
       "      <td>13.453298</td>\n",
       "      <td>6.060012</td>\n",
       "      <td>2.530771</td>\n",
       "      <td>21.778827</td>\n",
       "      <td>4.351786</td>\n",
       "      <td>6.328755</td>\n",
       "      <td>2.826506</td>\n",
       "      <td>26.753396</td>\n",
       "      <td>9.001622</td>\n",
       "      <td>-0.002976</td>\n",
       "      <td>-2.133786</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",
       "      <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",
       "      <td>17.683418</td>\n",
       "      <td>10.745748</td>\n",
       "      <td>3.516166</td>\n",
       "      <td>-0.850877</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.150079</td>\n",
       "      <td>10.839512</td>\n",
       "      <td>0.089989</td>\n",
       "      <td>-0.039323</td>\n",
       "      <td>28.762647</td>\n",
       "      <td>10.054233</td>\n",
       "      <td>2.291700</td>\n",
       "      <td>-2.444580</td>\n",
       "      <td>-2.012295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28136</th>\n",
       "      <td>8213.3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.7</td>\n",
       "      <td>7.9</td>\n",
       "      <td>36</td>\n",
       "      <td>82</td>\n",
       "      <td>407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.689942</td>\n",
       "      <td>8.447472</td>\n",
       "      <td>4.376783</td>\n",
       "      <td>-1.280083</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>21.110748</td>\n",
       "      <td>4.788679</td>\n",
       "      <td>5.379275</td>\n",
       "      <td>1.556259</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.225220</td>\n",
       "      <td>5.475764</td>\n",
       "      <td>4.834324</td>\n",
       "      <td>1.160450</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>22.188289</td>\n",
       "      <td>11.549142</td>\n",
       "      <td>5.913938</td>\n",
       "      <td>2.236868</td>\n",
       "      <td>25.474947</td>\n",
       "      <td>10.144716</td>\n",
       "      <td>2.326756</td>\n",
       "      <td>0.107434</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>23.001361</td>\n",
       "      <td>13.699852</td>\n",
       "      <td>6.202705</td>\n",
       "      <td>2.463869</td>\n",
       "      <td>22.420696</td>\n",
       "      <td>4.665978</td>\n",
       "      <td>6.462542</td>\n",
       "      <td>3.164246</td>\n",
       "      <td>26.718855</td>\n",
       "      <td>8.767712</td>\n",
       "      <td>-0.244808</td>\n",
       "      <td>-2.302084</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",
       "      <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",
       "      <td>18.042923</td>\n",
       "      <td>10.636151</td>\n",
       "      <td>3.613655</td>\n",
       "      <td>-1.080333</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.158676</td>\n",
       "      <td>10.834848</td>\n",
       "      <td>0.087516</td>\n",
       "      <td>-0.044834</td>\n",
       "      <td>28.067625</td>\n",
       "      <td>9.735042</td>\n",
       "      <td>2.652282</td>\n",
       "      <td>-6.950220</td>\n",
       "      <td>-3.191910</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>28137 rows × 116 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         time  quarter  time_left  shot_clock  phase  episode  attack_id  \\\n",
       "0         0.0        1      692.1        11.8      1        1          1   \n",
       "1         0.1        1      692.0        11.7      1        1          1   \n",
       "2         0.2        1      691.9        11.6      1        1          1   \n",
       "3         0.3        1      691.8        11.6      1        1          1   \n",
       "4         0.4        1      691.7        11.5      1        1          1   \n",
       "...       ...      ...        ...         ...    ...      ...        ...   \n",
       "28132  8212.9        4        2.0         7.9     36       82        407   \n",
       "28133  8213.0        4        2.0         7.9     36       82        407   \n",
       "28134  8213.1        4        1.9         7.9     36       82        407   \n",
       "28135  8213.2        4        1.8         7.9     36       82        407   \n",
       "28136  8213.3        4        1.7         7.9     36       82        407   \n",
       "\n",
       "       A01_x  A01_y  A01_vx  A01_vy      A02_x     A02_y    A02_vx    A02_vy  \\\n",
       "0        NaN    NaN     NaN     NaN  19.785121  1.425455 -1.697714  0.772240   \n",
       "1        NaN    NaN     NaN     NaN  19.615925  1.504358 -1.703008  0.756797   \n",
       "2        NaN    NaN     NaN     NaN  19.445660  1.580143 -1.709199  0.738736   \n",
       "3        NaN    NaN     NaN     NaN  19.274326  1.652808 -1.716288  0.718058   \n",
       "4        NaN    NaN     NaN     NaN  19.101922  1.722354 -1.724274  0.694762   \n",
       "...      ...    ...     ...     ...        ...       ...       ...       ...   \n",
       "28132    NaN    NaN     NaN     NaN  23.962958  8.901634  4.264577 -0.875640   \n",
       "28133    NaN    NaN     NaN     NaN  24.394685  8.804957  4.267991 -0.986734   \n",
       "28134    NaN    NaN     NaN     NaN  24.826425  8.697038  4.287830 -1.091172   \n",
       "28135    NaN    NaN     NaN     NaN  25.258177  8.577876  4.324094 -1.188955   \n",
       "28136    NaN    NaN     NaN     NaN  25.689942  8.447472  4.376783 -1.280083   \n",
       "\n",
       "       A03_x  A03_y  A03_vx  A03_vy  A08_x  A08_y  A08_vx  A08_vy      A09_x  \\\n",
       "0        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  26.740388   \n",
       "1        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  26.576244   \n",
       "2        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  26.399104   \n",
       "3        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  26.208968   \n",
       "4        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  26.005836   \n",
       "...      ...    ...     ...     ...    ...    ...     ...     ...        ...   \n",
       "28132    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  19.075324   \n",
       "28133    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  19.557380   \n",
       "28134    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  20.057303   \n",
       "28135    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  20.575092   \n",
       "28136    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  21.110748   \n",
       "\n",
       "           A09_y    A09_vx    A09_vy      A12_x     A12_y    A12_vx    A12_vy  \\\n",
       "0      14.429423 -1.711422 -0.936562  23.524818  5.302147 -2.137299 -1.002956   \n",
       "1      14.341800 -1.775765 -0.992032  23.315887  5.195711 -2.181419 -0.946496   \n",
       "2      14.242972 -1.851014 -1.056904  23.098044  5.100679 -2.233017 -0.880467   \n",
       "3      14.132941 -1.937168 -1.131177  22.871290  5.017050 -2.292093 -0.804868   \n",
       "4      14.011707 -2.034227 -1.214852  22.635624  4.944825 -2.358648 -0.719699   \n",
       "...          ...       ...       ...        ...       ...       ...       ...   \n",
       "28132   4.321346  4.621708  0.541600        NaN       NaN       NaN       NaN   \n",
       "28133   4.401934  4.801634  0.784653        NaN       NaN       NaN       NaN   \n",
       "28134   4.506685  4.987871  1.034780        NaN       NaN       NaN       NaN   \n",
       "28135   4.635600  5.180417  1.291982        NaN       NaN       NaN       NaN   \n",
       "28136   4.788679  5.379275  1.556259        NaN       NaN       NaN       NaN   \n",
       "\n",
       "           A14_x      A14_y    A14_vx    A14_vy  A15_x  A15_y  A15_vx  A15_vy  \\\n",
       "0      20.873405  13.412041 -0.778407 -0.884742    NaN    NaN     NaN     NaN   \n",
       "1      20.804271  13.321966 -0.858472 -0.870023    NaN    NaN     NaN     NaN   \n",
       "2      20.718967  13.234863 -0.952107 -0.852808    NaN    NaN     NaN     NaN   \n",
       "3      20.617491  13.150734 -1.059312 -0.833099    NaN    NaN     NaN     NaN   \n",
       "4      20.499845  13.069579 -1.180088 -0.810894    NaN    NaN     NaN     NaN   \n",
       "...          ...        ...       ...       ...    ...    ...     ...     ...   \n",
       "28132  13.381986   5.139954  4.261967  0.314273    NaN    NaN     NaN     NaN   \n",
       "28133  13.824150   5.193051  4.388477  0.520662    NaN    NaN     NaN     NaN   \n",
       "28134  14.278743   5.266719  4.526039  0.730489    NaN    NaN     NaN     NaN   \n",
       "28135  14.745767   5.360956  4.674655  0.943751    NaN    NaN     NaN     NaN   \n",
       "28136  15.225220   5.475764  4.834324  1.160450    NaN    NaN     NaN     NaN   \n",
       "\n",
       "       A17_x  A17_y  A17_vx  A17_vy      A20_x      A20_y    A20_vx    A20_vy  \\\n",
       "0        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "1        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "2        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "3        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "4        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "...      ...    ...     ...     ...        ...        ...       ...       ...   \n",
       "28132    NaN    NaN     NaN     NaN  19.906936  10.660952  5.371589  2.186802   \n",
       "28133    NaN    NaN     NaN     NaN  20.458679  10.880543  5.496925  2.202721   \n",
       "28134    NaN    NaN     NaN     NaN  21.022819  11.101772  5.629096  2.216372   \n",
       "28135    NaN    NaN     NaN     NaN  21.599356  11.324638  5.768100  2.227754   \n",
       "28136    NaN    NaN     NaN     NaN  22.188289  11.549142  5.913938  2.236868   \n",
       "\n",
       "           A21_x      A21_y    A21_vx    A21_vy  A30_x  A30_y  A30_vx  A30_vy  \\\n",
       "0      20.174437   8.819221 -1.544859 -0.201247    NaN    NaN     NaN     NaN   \n",
       "1      20.024861   8.800411 -1.590008 -0.213339    NaN    NaN     NaN     NaN   \n",
       "2      19.866167   8.779159 -1.642810 -0.227481    NaN    NaN     NaN     NaN   \n",
       "3      19.698353   8.755465 -1.703264 -0.243672    NaN    NaN     NaN     NaN   \n",
       "4      19.521420   8.729329 -1.771371 -0.261912    NaN    NaN     NaN     NaN   \n",
       "...          ...        ...       ...       ...    ...    ...     ...     ...   \n",
       "28132  24.552440  10.096246  2.340394  0.147493    NaN    NaN     NaN     NaN   \n",
       "28133  24.789796  10.110178  2.300408  0.135646    NaN    NaN     NaN     NaN   \n",
       "28134  25.022666  10.122899  2.284806  0.125020    NaN    NaN     NaN     NaN   \n",
       "28135  25.251049  10.134412  2.293589  0.115616    NaN    NaN     NaN     NaN   \n",
       "28136  25.474947  10.144716  2.326756  0.107434    NaN    NaN     NaN     NaN   \n",
       "\n",
       "       A33_x  A33_y  A33_vx  A33_vy      B00_x      B00_y    B00_vx    B00_vy  \\\n",
       "0        NaN    NaN     NaN     NaN  22.878861  11.737098 -1.597269  0.178869   \n",
       "1        NaN    NaN     NaN     NaN  22.718900  11.753463 -1.595119  0.192865   \n",
       "2        NaN    NaN     NaN     NaN  22.559374  11.772655 -1.592605  0.209233   \n",
       "3        NaN    NaN     NaN     NaN  22.400281  11.794673 -1.589727  0.227972   \n",
       "4        NaN    NaN     NaN     NaN  22.241623  11.819518 -1.586484  0.249084   \n",
       "...      ...    ...     ...     ...        ...        ...       ...       ...   \n",
       "28132    NaN    NaN     NaN     NaN  20.599456  12.674387  5.712417  2.728683   \n",
       "28133    NaN    NaN     NaN     NaN  21.184967  12.940565  5.814868  2.663178   \n",
       "28134    NaN    NaN     NaN     NaN  21.780455  13.200202  5.930733  2.597207   \n",
       "28135    NaN    NaN     NaN     NaN  22.385919  13.453298  6.060012  2.530771   \n",
       "28136    NaN    NaN     NaN     NaN  23.001361  13.699852  6.202705  2.463869   \n",
       "\n",
       "           B04_x      B04_y    B04_vx    B04_vy      B07_x     B07_y  \\\n",
       "0      26.994781  10.151064 -0.434501 -2.487465  24.878534  8.194209   \n",
       "1      26.963840   9.891161 -0.549526 -2.384881  25.063909  8.136124   \n",
       "2      26.909668   9.651978 -0.684046 -2.264910  25.229202  8.082001   \n",
       "3      26.832263   9.433514 -0.838063 -2.127551  25.374412  8.031841   \n",
       "4      26.731625   9.235769 -1.011574 -1.972806  25.499541  7.985644   \n",
       "...          ...        ...       ...       ...        ...       ...   \n",
       "28132  19.910104   3.599947  6.000484  1.850492  26.655054  9.581450   \n",
       "28133  20.523531   3.818770  6.097726  2.169629  26.721495  9.408491   \n",
       "28134  21.146439   4.069383  6.207149  2.494967  26.754276  9.215215   \n",
       "28135  21.778827   4.351786  6.328755  2.826506  26.753396  9.001622   \n",
       "28136  22.420696   4.665978  6.462542  3.164246  26.718855  8.767712   \n",
       "\n",
       "         B07_vx    B07_vy  B08_x  B08_y  B08_vx  B08_vy  B11_x  B11_y  B11_vx  \\\n",
       "0      1.745615 -0.559515    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "1      1.646187 -0.539896    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "2      1.529908 -0.516951    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "3      1.396776 -0.490681    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "4      1.246792 -0.461086    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "...         ...       ...    ...    ...     ...     ...    ...    ...     ...   \n",
       "28132  0.913126 -1.558759    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "28133  0.575991 -1.762124    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "28134  0.270623 -1.953799    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "28135 -0.002976 -2.133786    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "28136 -0.244808 -2.302084    NaN    NaN     NaN     NaN    NaN    NaN     NaN   \n",
       "\n",
       "       B11_vy  B12_x  B12_y  B12_vx  B12_vy  B13_x  B13_y  B13_vx  B13_vy  \\\n",
       "0         NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "1         NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "2         NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "3         NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "4         NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "...       ...    ...    ...     ...     ...    ...    ...     ...     ...   \n",
       "28132     NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "28133     NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "28134     NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "28135     NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "28136     NaN    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN   \n",
       "\n",
       "       B28_x  B28_y  B28_vx  B28_vy      B41_x      B41_y    B41_vx    B41_vy  \\\n",
       "0        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "1        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "2        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "3        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "4        NaN    NaN     NaN     NaN        NaN        NaN       NaN       NaN   \n",
       "...      ...    ...     ...     ...        ...        ...       ...       ...   \n",
       "28132    NaN    NaN     NaN     NaN  16.653472  10.928526  3.254720 -0.136453   \n",
       "28133    NaN    NaN     NaN     NaN  16.988693  10.891935  3.336698 -0.378937   \n",
       "28134    NaN    NaN     NaN     NaN  17.332008  10.831009  3.423847 -0.617079   \n",
       "28135    NaN    NaN     NaN     NaN  17.683418  10.745748  3.516166 -0.850877   \n",
       "28136    NaN    NaN     NaN     NaN  18.042923  10.636151  3.613655 -1.080333   \n",
       "\n",
       "       B42_x  B42_y  B42_vx  B42_vy  B44_x  B44_y  B44_vx  B44_vy      B90_x  \\\n",
       "0        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  24.158185   \n",
       "1        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  24.100867   \n",
       "2        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  24.023416   \n",
       "3        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  23.925832   \n",
       "4        NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN  23.808115   \n",
       "...      ...    ...     ...     ...    ...    ...     ...     ...        ...   \n",
       "28132    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN        NaN   \n",
       "28133    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN        NaN   \n",
       "28134    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN        NaN   \n",
       "28135    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN        NaN   \n",
       "28136    NaN    NaN     NaN     NaN    NaN    NaN     NaN     NaN        NaN   \n",
       "\n",
       "          B90_y    B90_vx    B90_vy      B99_x      B99_y    B99_vx    B99_vy  \\\n",
       "0      5.479669 -0.681589 -1.097153  23.564414   3.668931  1.709916  1.162039   \n",
       "1      5.367952 -0.781268 -1.078746  23.746529   3.788690  1.607638  1.129349   \n",
       "2      5.259952 -0.897843 -1.057220  23.907987   3.901847  1.488024  1.091120   \n",
       "3      5.155671 -1.031312 -1.032573  24.048786   4.008401  1.351076  1.047349   \n",
       "4      5.055107 -1.181676 -1.004807  24.168927   4.108353  1.196792  0.998038   \n",
       "...         ...       ...       ...        ...        ...       ...       ...   \n",
       "28132       NaN       NaN       NaN   0.121979  10.849233  0.099989 -0.019777   \n",
       "28133       NaN       NaN       NaN   0.131731  10.846705  0.096225 -0.026794   \n",
       "28134       NaN       NaN       NaN   0.141097  10.843464  0.092892 -0.033309   \n",
       "28135       NaN       NaN       NaN   0.150079  10.839512  0.089989 -0.039323   \n",
       "28136       NaN       NaN       NaN   0.158676  10.834848  0.087516 -0.044834   \n",
       "\n",
       "          ball_x     ball_y    ball_z   ball_vx   ball_vy  \n",
       "0      25.340376   6.827025  3.910383  0.000000  0.000000  \n",
       "1      25.565622   6.993068  3.838645  2.252460  1.660425  \n",
       "2      25.842789   7.168920  3.666417  2.771670  1.758525  \n",
       "3      26.089730   7.357188  3.391677  2.469405  1.882680  \n",
       "4      26.286972   7.522629  3.090618  1.972425  1.654410  \n",
       "...          ...        ...       ...       ...       ...  \n",
       "28132  28.476220  10.132425  1.811742  2.152305 -0.419940  \n",
       "28133  28.768428  10.237338  1.506210  2.922075  1.049130  \n",
       "28134  29.007105  10.255463  1.804651  2.386770  0.181245  \n",
       "28135  28.762647  10.054233  2.291700 -2.444580 -2.012295  \n",
       "28136  28.067625   9.735042  2.652282 -6.950220 -3.191910  \n",
       "\n",
       "[28137 rows x 116 columns]"
      ]
     },
     "execution_count": 243,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "processor.convert_to_meters()\n",
    "processor.calc_velocities()\n",
    "processor.traces"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "ohcoach",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}