python.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "# pd.set_option('display.max_rows',None)\n",
    "pd.set_option('display.max_columns',None)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\styt-\\AppData\\Local\\Temp\\ipykernel_12900\\3221867704.py:1: DtypeWarning: Columns (5) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df_econ = pd.read_csv(\"CSGO_ProfessionalPlay/economy.csv\",encoding=\"utf-8\")\n"
     ]
    }
   ],
   "source": [
    "df_econ = pd.read_csv(\"CSGO_ProfessionalPlay/economy.csv\",encoding=\"utf-8\")\n",
    "df_pick = pd.read_csv(\"CSGO_ProfessionalPlay/picks.csv\",encoding=\"utf-8\")\n",
    "df_play = pd.read_csv(\"CSGO_ProfessionalPlay/players.csv\",encoding=\"utf-8\")\n",
    "df_res = pd.read_csv(\"CSGO_ProfessionalPlay/results.csv\",encoding=\"utf-8\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# PREPROCESSING FOR THE results.csv FILE\n",
    "# Map the names of teams to unique numbers\n",
    "all_teams = pd.concat([df_res[\"team_1\"], df_res[\"team_2\"]])\n",
    "unique_teams = all_teams.unique()\n",
    "team_map = {team: i+1 for i, team in enumerate(unique_teams)}\n",
    "df_res[\"team_1_mapped\"] = df_res[\"team_1\"].map(team_map)\n",
    "df_res[\"team_2_mapped\"] = df_res[\"team_2\"].map(team_map)\n",
    "df_res.drop(\"team_1\",axis=1, inplace=True)\n",
    "df_res.drop(\"team_2\",axis=1, inplace=True)\n",
    "\n",
    "# Map the names of maps to unique numbers\n",
    "unique_maps = df_res[\"_map\"].unique()\n",
    "maps_map = {map: i+1 for i, map in enumerate(unique_maps)}\n",
    "df_res[\"maps_mapped\"] = df_res[\"_map\"].map(maps_map)\n",
    "df_res.drop(\"_map\",axis=1, inplace=True)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# PREPROCESSING OF player.csv FILE\n",
    "df_play.drop(\"player_name\",axis=1,inplace=True)\n",
    "\n",
    "df_play[\"team_mapped\"] = df_play[\"team\"].map(team_map)\n",
    "df_play[\"opponent_mapped\"] = df_play[\"opponent\"].map(team_map)\n",
    "\n",
    "unique_countries = df_play[\"country\"].unique()\n",
    "country_map = {country: i+1 for i, country in enumerate(unique_countries)}\n",
    "df_play[\"country_mapped\"] = df_play[\"country\"].map(country_map)\n",
    "df_play.drop(\"country\",axis=1,inplace=True)\n",
    "df_play.drop(\"opponent\",axis=1,inplace=True)\n",
    "df_play.drop(\"team\",axis=1,inplace=True)\n",
    "# Map the names of maps to unique numbers\n",
    "df_play[\"map_1_mapped\"] = df_play[\"map_1\"].map(maps_map)\n",
    "df_play[\"map_2_mapped\"] = df_play[\"map_2\"].map(maps_map)\n",
    "df_play[\"map_3_mapped\"] = df_play[\"map_3\"].map(maps_map)\n",
    "df_play.drop(\"map_1\",axis=1,inplace=True)\n",
    "df_play.drop(\"map_2\",axis=1,inplace=True)\n",
    "df_play.drop(\"map_3\",axis=1,inplace=True)\n",
    "df_play.drop(\"event_name\",axis=1,inplace=True)\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# PREPROCESSING OF picks.csv FILE\n",
    "df_pick[\"team_1_mapped\"] = df_pick[\"team_1\"].map(team_map)\n",
    "df_pick[\"team_2_mapped\"] = df_pick[\"team_2\"].map(team_map)\n",
    "df_pick.drop(\"team_1\",axis=1, inplace=True)\n",
    "df_pick.drop(\"team_2\",axis=1, inplace=True)\n",
    "\n",
    "df_pick[\"t1_removed_1_mapped\"] = df_pick[\"t1_removed_1\"].map(maps_map)\n",
    "df_pick[\"t1_removed_2_mapped\"] = df_pick[\"t1_removed_2\"].map(maps_map)\n",
    "df_pick[\"t1_removed_3_mapped\"] = df_pick[\"t1_removed_3\"].map(maps_map)\n",
    "df_pick[\"t2_removed_1_mapped\"] = df_pick[\"t2_removed_1\"].map(maps_map)\n",
    "df_pick[\"t2_removed_2_mapped\"] = df_pick[\"t2_removed_2\"].map(maps_map)\n",
    "df_pick[\"t2_removed_3_mapped\"] = df_pick[\"t2_removed_3\"].map(maps_map)\n",
    "df_pick[\"t1_picked_1_mapped\"] = df_pick[\"t1_picked_1\"].map(maps_map)\n",
    "df_pick[\"t2_picked_1_mapped\"] = df_pick[\"t2_picked_1\"].map(maps_map)\n",
    "df_pick[\"left_over_mapped\"] = df_pick[\"left_over\"].map(maps_map)\n",
    "df_pick.drop(\"t1_removed_1\",axis=1, inplace=True)\n",
    "df_pick.drop(\"t1_removed_2\",axis=1, inplace=True)\n",
    "df_pick.drop(\"t1_removed_3\",axis=1, inplace=True)\n",
    "df_pick.drop(\"t2_removed_1\",axis=1, inplace=True)\n",
    "df_pick.drop(\"t2_removed_2\",axis=1, inplace=True)\n",
    "df_pick.drop(\"t2_removed_3\",axis=1, inplace=True)\n",
    "df_pick.drop(\"t1_picked_1\",axis=1, inplace=True)\n",
    "df_pick.drop(\"t2_picked_1\",axis=1, inplace=True)\n",
    "df_pick.drop(\"left_over\",axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# PREPROCESSING OF economy.csv FILE\n",
    "df_econ[\"team_1_mapped\"] = df_econ[\"team_1\"].map(team_map)\n",
    "df_econ[\"team_2_mapped\"] = df_econ[\"team_2\"].map(team_map)\n",
    "df_econ.drop(\"team_1\",axis=1, inplace=True)\n",
    "df_econ.drop(\"team_2\",axis=1, inplace=True)\n",
    "\n",
    "df_econ[\"maps_mapped\"] = df_econ[\"_map\"].map(maps_map)\n",
    "df_econ.drop(\"_map\",axis=1, inplace=True)\n",
    "\n",
    "\n",
    "t_ct = df_econ[\"t1_start\"].unique()\n",
    "t_ct_map = {t_ct_: i+1 for i, t_ct_ in enumerate(t_ct)}\n",
    "df_econ[\"t1_start_mapped\"] = df_econ[\"t1_start\"].map(t_ct_map)\n",
    "df_econ[\"t2_start_mapped\"] = df_econ[\"t2_start\"].map(t_ct_map)\n",
    "df_econ.drop(\"t1_start\",axis=1, inplace=True)\n",
    "df_econ.drop(\"t2_start\",axis=1, inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>match_id</th>\n",
       "      <th>date</th>\n",
       "      <th>team_1_mapped</th>\n",
       "      <th>team_2_mapped</th>\n",
       "      <th>maps_mapped</th>\n",
       "      <th>results_1</th>\n",
       "      <th>results_2</th>\n",
       "      <th>map_winner</th>\n",
       "      <th>starting_ct</th>\n",
       "      <th>cts_1</th>\n",
       "      <th>ts_2</th>\n",
       "      <th>ts_1</th>\n",
       "      <th>cts_2</th>\n",
       "      <th>event_id</th>\n",
       "      <th>rank_1</th>\n",
       "      <th>rank_2</th>\n",
       "      <th>map_wins_1</th>\n",
       "      <th>map_wins_2</th>\n",
       "      <th>match_winner</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2299001</td>\n",
       "      <td>2015-11-03</td>\n",
       "      <td>98</td>\n",
       "      <td>83</td>\n",
       "      <td>7</td>\n",
       "      <td>[16]</td>\n",
       "      <td>[4]</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[4]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>[12]</td>\n",
       "      <td>[3]</td>\n",
       "      <td>1934</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2299003</td>\n",
       "      <td>2015-11-03</td>\n",
       "      <td>98</td>\n",
       "      <td>74</td>\n",
       "      <td>10</td>\n",
       "      <td>[16]</td>\n",
       "      <td>[9]</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[4]</td>\n",
       "      <td>[6]</td>\n",
       "      <td>[12]</td>\n",
       "      <td>[3]</td>\n",
       "      <td>1934</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2299011</td>\n",
       "      <td>2015-11-04</td>\n",
       "      <td>832</td>\n",
       "      <td>136</td>\n",
       "      <td>2</td>\n",
       "      <td>[16]</td>\n",
       "      <td>[12]</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[7]</td>\n",
       "      <td>[8]</td>\n",
       "      <td>[9]</td>\n",
       "      <td>[4]</td>\n",
       "      <td>1934</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2299040</td>\n",
       "      <td>2015-11-05</td>\n",
       "      <td>832</td>\n",
       "      <td>347</td>\n",
       "      <td>9</td>\n",
       "      <td>[4]</td>\n",
       "      <td>[16]</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>[1]</td>\n",
       "      <td>[4]</td>\n",
       "      <td>[3]</td>\n",
       "      <td>[12]</td>\n",
       "      <td>1934</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2299042</td>\n",
       "      <td>2015-11-05</td>\n",
       "      <td>136</td>\n",
       "      <td>347</td>\n",
       "      <td>10</td>\n",
       "      <td>[16]</td>\n",
       "      <td>[6]</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[9]</td>\n",
       "      <td>[6]</td>\n",
       "      <td>[7]</td>\n",
       "      <td>[0]</td>\n",
       "      <td>1934</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>6</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27240</th>\n",
       "      <td>2340453</td>\n",
       "      <td>2020-03-18</td>\n",
       "      <td>3</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>[7, 8]</td>\n",
       "      <td>[16, 16]</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>[0, 4]</td>\n",
       "      <td>[8, 5]</td>\n",
       "      <td>[7, 4]</td>\n",
       "      <td>[8, 11]</td>\n",
       "      <td>5151</td>\n",
       "      <td>61</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27241</th>\n",
       "      <td>2340454</td>\n",
       "      <td>2020-03-18</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>[0, 13]</td>\n",
       "      <td>[16, 16]</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>[0, 8]</td>\n",
       "      <td>[1, 6]</td>\n",
       "      <td>[0, 5]</td>\n",
       "      <td>[15, 10]</td>\n",
       "      <td>5151</td>\n",
       "      <td>62</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27242</th>\n",
       "      <td>2340455</td>\n",
       "      <td>2020-03-17</td>\n",
       "      <td>5</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>[16, 16]</td>\n",
       "      <td>[10, 10]</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[3, 7]</td>\n",
       "      <td>[8, 8]</td>\n",
       "      <td>[13, 9]</td>\n",
       "      <td>[2, 2]</td>\n",
       "      <td>5247</td>\n",
       "      <td>56</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27243</th>\n",
       "      <td>2340456</td>\n",
       "      <td>2020-03-17</td>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "      <td>[13, 11]</td>\n",
       "      <td>[16, 16]</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>[8, 6]</td>\n",
       "      <td>[6, 9]</td>\n",
       "      <td>[5, 5]</td>\n",
       "      <td>[10, 7]</td>\n",
       "      <td>5247</td>\n",
       "      <td>71</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27244</th>\n",
       "      <td>2340461</td>\n",
       "      <td>2020-03-18</td>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>2</td>\n",
       "      <td>[12]</td>\n",
       "      <td>[16]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>[9]</td>\n",
       "      <td>[6]</td>\n",
       "      <td>[3]</td>\n",
       "      <td>[10]</td>\n",
       "      <td>5243</td>\n",
       "      <td>140</td>\n",
       "      <td>118</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27245 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       match_id        date  team_1_mapped  team_2_mapped  maps_mapped  \\\n",
       "0       2299001  2015-11-03             98             83            7   \n",
       "1       2299003  2015-11-03             98             74           10   \n",
       "2       2299011  2015-11-04            832            136            2   \n",
       "3       2299040  2015-11-05            832            347            9   \n",
       "4       2299042  2015-11-05            136            347           10   \n",
       "...         ...         ...            ...            ...          ...   \n",
       "27240   2340453  2020-03-18              3             18            2   \n",
       "27241   2340454  2020-03-18              1             28            1   \n",
       "27242   2340455  2020-03-17              5            160            1   \n",
       "27243   2340456  2020-03-17              4             30            4   \n",
       "27244   2340461  2020-03-18              2             46            2   \n",
       "\n",
       "      results_1 results_2  map_winner  starting_ct   cts_1    ts_2     ts_1  \\\n",
       "0          [16]       [4]           1            2     [4]     [1]     [12]   \n",
       "1          [16]       [9]           1            2     [4]     [6]     [12]   \n",
       "2          [16]      [12]           1            1     [7]     [8]      [9]   \n",
       "3           [4]      [16]           2            2     [1]     [4]      [3]   \n",
       "4          [16]       [6]           1            1     [9]     [6]      [7]   \n",
       "...         ...       ...         ...          ...     ...     ...      ...   \n",
       "27240    [7, 8]  [16, 16]           2            2  [0, 4]  [8, 5]   [7, 4]   \n",
       "27241   [0, 13]  [16, 16]           2            2  [0, 8]  [1, 6]   [0, 5]   \n",
       "27242  [16, 16]  [10, 10]           1            2  [3, 7]  [8, 8]  [13, 9]   \n",
       "27243  [13, 11]  [16, 16]           2            2  [8, 6]  [6, 9]   [5, 5]   \n",
       "27244      [12]      [16]           2            1     [9]     [6]      [3]   \n",
       "\n",
       "          cts_2  event_id  rank_1  rank_2  map_wins_1  map_wins_2  \\\n",
       "0           [3]      1934       6      12          16           4   \n",
       "1           [3]      1934       6       1          16           9   \n",
       "2           [4]      1934      10      14          16          12   \n",
       "3          [12]      1934      10       9           4          16   \n",
       "4           [0]      1934      14       9          16           6   \n",
       "...         ...       ...     ...     ...         ...         ...   \n",
       "27240   [8, 11]      5151      61      38           0           2   \n",
       "27241  [15, 10]      5151      62      63           0           2   \n",
       "27242    [2, 2]      5247      56      77           2           0   \n",
       "27243   [10, 7]      5247      71      41           0           2   \n",
       "27244      [10]      5243     140     118          12          16   \n",
       "\n",
       "       match_winner  \n",
       "0                 1  \n",
       "1                 1  \n",
       "2                 1  \n",
       "3                 2  \n",
       "4                 1  \n",
       "...             ...  \n",
       "27240             2  \n",
       "27241             2  \n",
       "27242             1  \n",
       "27243             2  \n",
       "27244             2  \n",
       "\n",
       "[27245 rows x 19 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Group by the match ID and concatenate the values in the other columns\n",
    "df_merged_res = df_res.groupby(['match_id'], as_index=False).agg({\n",
    "    'date': lambda x: x.iloc[0],\n",
    "    'team_1_mapped': lambda x: x.iloc[0],\n",
    "    'team_2_mapped': lambda x: x.iloc[0],\n",
    "    'maps_mapped': lambda x: x.iloc[0],\n",
    "    'result_1': lambda x: list(x),\n",
    "    'result_2': lambda x: list(x),\n",
    "    'map_winner': lambda x: x.iloc[0],\n",
    "    'starting_ct': lambda x: x.iloc[0],\n",
    "    'ct_1': lambda x: list(x),\n",
    "    't_2': lambda x: list(x),\n",
    "    't_1': lambda x: list(x),\n",
    "    'ct_2': lambda x: list(x),\n",
    "    'event_id': lambda x: x.iloc[0],\n",
    "    'rank_1' : lambda x: x.iloc[0],\n",
    "    'rank_2' : lambda x: x.iloc[0],\n",
    "    'map_wins_1' : lambda x: x.iloc[0],\n",
    "    'map_wins_2' : lambda x: x.iloc[0],\n",
    "    'match_winner' : lambda x: x.iloc[0]\n",
    "\n",
    "})\n",
    "\n",
    "# Rename the columns to indicate that they contain lists of values\n",
    "df_merged_res = df_merged_res.rename(columns={\n",
    "    'result_1': 'results_1',\n",
    "    'result_2': 'results_2',\n",
    "    'ct_1': 'cts_1',\n",
    "    't_2': 'ts_2',\n",
    "    't_1': 'ts_1',\n",
    "    'ct_2': 'cts_2'\n",
    "})\n",
    "\n",
    "# Reset the index\n",
    "df_merged_res = df_merged_res.reset_index(drop=True)\n",
    "df_merged_res\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>uid</th>\n",
       "      <th>date</th>\n",
       "      <th>team_mapped</th>\n",
       "      <th>opponent_mapped</th>\n",
       "      <th>country_mapped</th>\n",
       "      <th>player_id</th>\n",
       "      <th>match_id</th>\n",
       "      <th>event_id</th>\n",
       "      <th>best_of</th>\n",
       "      <th>map_1_mapped</th>\n",
       "      <th>map_2_mapped</th>\n",
       "      <th>map_3_mapped</th>\n",
       "      <th>kills</th>\n",
       "      <th>assists</th>\n",
       "      <th>deaths</th>\n",
       "      <th>hs</th>\n",
       "      <th>flash_assists</th>\n",
       "      <th>kast</th>\n",
       "      <th>kddiff</th>\n",
       "      <th>adr</th>\n",
       "      <th>fkdiff</th>\n",
       "      <th>rating</th>\n",
       "      <th>m1_kills</th>\n",
       "      <th>m1_assists</th>\n",
       "      <th>m1_deaths</th>\n",
       "      <th>m1_hs</th>\n",
       "      <th>m1_flash_assists</th>\n",
       "      <th>m1_kast</th>\n",
       "      <th>m1_kddiff</th>\n",
       "      <th>m1_adr</th>\n",
       "      <th>m1_fkdiff</th>\n",
       "      <th>m1_rating</th>\n",
       "      <th>m2_kills</th>\n",
       "      <th>m2_assists</th>\n",
       "      <th>m2_deaths</th>\n",
       "      <th>m2_hs</th>\n",
       "      <th>m2_flash_assists</th>\n",
       "      <th>m2_kast</th>\n",
       "      <th>m2_kddiff</th>\n",
       "      <th>m2_adr</th>\n",
       "      <th>m2_fkdiff</th>\n",
       "      <th>m2_rating</th>\n",
       "      <th>m3_kills</th>\n",
       "      <th>m3_assists</th>\n",
       "      <th>m3_deaths</th>\n",
       "      <th>m3_hs</th>\n",
       "      <th>m3_flash_assists</th>\n",
       "      <th>m3_kast</th>\n",
       "      <th>m3_kddiff</th>\n",
       "      <th>m3_adr</th>\n",
       "      <th>m3_fkdiff</th>\n",
       "      <th>m3_rating</th>\n",
       "      <th>kills_ct</th>\n",
       "      <th>deaths_ct</th>\n",
       "      <th>kddiff_ct</th>\n",
       "      <th>adr_ct</th>\n",
       "      <th>kast_ct</th>\n",
       "      <th>rating_ct</th>\n",
       "      <th>kills_t</th>\n",
       "      <th>deaths_t</th>\n",
       "      <th>kddiff_t</th>\n",
       "      <th>adr_t</th>\n",
       "      <th>kast_t</th>\n",
       "      <th>rating_t</th>\n",
       "      <th>m1_kills_ct</th>\n",
       "      <th>m1_deaths_ct</th>\n",
       "      <th>m1_kddiff_ct</th>\n",
       "      <th>m1_adr_ct</th>\n",
       "      <th>m1_kast_ct</th>\n",
       "      <th>m1_rating_ct</th>\n",
       "      <th>m1_kills_t</th>\n",
       "      <th>m1_deaths_t</th>\n",
       "      <th>m1_kddiff_t</th>\n",
       "      <th>m1_adr_t</th>\n",
       "      <th>m1_kast_t</th>\n",
       "      <th>m1_rating_t</th>\n",
       "      <th>m2_kills_ct</th>\n",
       "      <th>m2_deaths_ct</th>\n",
       "      <th>m2_kddiff_ct</th>\n",
       "      <th>m2_adr_ct</th>\n",
       "      <th>m2_kast_ct</th>\n",
       "      <th>m2_rating_ct</th>\n",
       "      <th>m2_kills_t</th>\n",
       "      <th>m2_deaths_t</th>\n",
       "      <th>m2_kddiff_t</th>\n",
       "      <th>m2_adr_t</th>\n",
       "      <th>m2_kast_t</th>\n",
       "      <th>m2_rating_t</th>\n",
       "      <th>m3_kills_ct</th>\n",
       "      <th>m3_deaths_ct</th>\n",
       "      <th>m3_kddiff_ct</th>\n",
       "      <th>m3_adr_ct</th>\n",
       "      <th>m3_kast_ct</th>\n",
       "      <th>m3_rating_ct</th>\n",
       "      <th>m3_kills_t</th>\n",
       "      <th>m3_deaths_t</th>\n",
       "      <th>m3_kddiff_t</th>\n",
       "      <th>m3_adr_t</th>\n",
       "      <th>m3_kast_t</th>\n",
       "      <th>m3_rating_t</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2297880_700.0</td>\n",
       "      <td>2015-10-15</td>\n",
       "      <td>700.0</td>\n",
       "      <td>832.0</td>\n",
       "      <td>[3, 1, 3, 3, 3]</td>\n",
       "      <td>[6455, 8350, 3887, 8515, 8494]</td>\n",
       "      <td>2297880</td>\n",
       "      <td>1890</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[16, 27, 12, 19, 15]</td>\n",
       "      <td>[2, 2, 4, 4, 3]</td>\n",
       "      <td>[36, 32, 34, 32, 34]</td>\n",
       "      <td>[12, 14, 4, 7, 5]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-20, -5, -22, -13, -19]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-5, -3, -5, -6, -3]</td>\n",
       "      <td>[0.42, 0.96, 0.39, 0.64, 0.47]</td>\n",
       "      <td>[8, 10, 8, 7, 8]</td>\n",
       "      <td>[1, 0, 2, 3, 2]</td>\n",
       "      <td>[17, 17, 17, 16, 17]</td>\n",
       "      <td>[5, 3, 4, 4, 3]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-9, -7, -9, -9, -9]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-1, 0, -1, -4, -1]</td>\n",
       "      <td>[0.46, 0.59, 0.53, 0.46, 0.5]</td>\n",
       "      <td>[8.0, 17.0, 4.0, 12.0, 7.0]</td>\n",
       "      <td>[1.0, 2.0, 2.0, 1.0, 1.0]</td>\n",
       "      <td>[19.0, 15.0, 17.0, 16.0, 17.0]</td>\n",
       "      <td>[7.0, 11.0, 0.0, 3.0, 2.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-11.0, 2.0, -13.0, -4.0, -10.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-4.0, -3.0, -4.0, -2.0, -2.0]</td>\n",
       "      <td>[0.38, 1.29, 0.26, 0.81, 0.45]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2297880_832.0</td>\n",
       "      <td>2015-10-15</td>\n",
       "      <td>832.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>[3, 1, 1, 1, 1]</td>\n",
       "      <td>[6451, 8347, 8346, 8137, 8523]</td>\n",
       "      <td>2297880</td>\n",
       "      <td>1890</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[34, 33, 32, 33, 36]</td>\n",
       "      <td>[8, 4, 9, 10, 6]</td>\n",
       "      <td>[18, 18, 19, 17, 17]</td>\n",
       "      <td>[14, 11, 5, 16, 14]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[16, 15, 13, 16, 19]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[7, 5, 7, 3, 0]</td>\n",
       "      <td>[1.39, 1.48, 1.45, 1.41, 1.46]</td>\n",
       "      <td>[15, 10, 19, 20, 20]</td>\n",
       "      <td>[4, 2, 6, 4, 5]</td>\n",
       "      <td>[8, 8, 8, 8, 9]</td>\n",
       "      <td>[7, 3, 3, 11, 8]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[7, 2, 11, 12, 11]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[3, 0, 2, 1, 1]</td>\n",
       "      <td>[1.34, 0.99, 1.95, 1.82, 1.57]</td>\n",
       "      <td>[19.0, 23.0, 13.0, 13.0, 16.0]</td>\n",
       "      <td>[4.0, 2.0, 3.0, 6.0, 1.0]</td>\n",
       "      <td>[10.0, 10.0, 11.0, 9.0, 8.0]</td>\n",
       "      <td>[7.0, 8.0, 2.0, 5.0, 6.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[9.0, 13.0, 2.0, 4.0, 8.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[4.0, 5.0, 5.0, 2.0, -1.0]</td>\n",
       "      <td>[1.44, 1.92, 1.01, 1.03, 1.36]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2298447_675.0</td>\n",
       "      <td>2015-10-18</td>\n",
       "      <td>675.0</td>\n",
       "      <td>792.0</td>\n",
       "      <td>[18, 17, 17, 18, 18]</td>\n",
       "      <td>[472, 8124, 7403, 2131, 338]</td>\n",
       "      <td>2298447</td>\n",
       "      <td>1881</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[41, 20, 52, 46, 40]</td>\n",
       "      <td>[10, 7, 5, 9, 13]</td>\n",
       "      <td>[41, 43, 33, 32, 35]</td>\n",
       "      <td>[15, 5, 14, 24, 17]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[0, -23, 19, 14, 5]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[0, -2, 0, 2, 1]</td>\n",
       "      <td>[1.02, 0.55, 1.4, 1.28, 1.09]</td>\n",
       "      <td>[22, 6, 24, 30, 25]</td>\n",
       "      <td>[5, 6, 3, 4, 7]</td>\n",
       "      <td>[20, 22, 19, 13, 17]</td>\n",
       "      <td>[5, 2, 8, 17, 10]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[2, -16, 5, 17, 8]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[1, -2, -4, 2, 1]</td>\n",
       "      <td>[1.13, 0.37, 1.25, 1.71, 1.3]</td>\n",
       "      <td>[19.0, 14.0, 28.0, 16.0, 15.0]</td>\n",
       "      <td>[5.0, 1.0, 2.0, 5.0, 6.0]</td>\n",
       "      <td>[21.0, 21.0, 14.0, 19.0, 18.0]</td>\n",
       "      <td>[10.0, 3.0, 6.0, 7.0, 7.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-2.0, -7.0, 14.0, -3.0, -3.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-1.0, 0.0, 4.0, 0.0, 0.0]</td>\n",
       "      <td>[0.91, 0.73, 1.55, 0.84, 0.88]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2298447_792.0</td>\n",
       "      <td>2015-10-18</td>\n",
       "      <td>792.0</td>\n",
       "      <td>675.0</td>\n",
       "      <td>[14, 14, 14, 14, 14]</td>\n",
       "      <td>[7415, 8783, 5061, 7412, 8150]</td>\n",
       "      <td>2298447</td>\n",
       "      <td>1881</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[25, 39, 39, 43, 38]</td>\n",
       "      <td>[8, 2, 5, 11, 7]</td>\n",
       "      <td>[42, 38, 38, 43, 39]</td>\n",
       "      <td>[8, 10, 16, 17, 13]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-17, 1, 1, 0, -1]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-3, 7, 0, -2, -4]</td>\n",
       "      <td>[0.67, 0.92, 0.99, 1.01, 0.96]</td>\n",
       "      <td>[7, 20, 26, 24, 14]</td>\n",
       "      <td>[4, 1, 1, 5, 4]</td>\n",
       "      <td>[22, 21, 21, 24, 20]</td>\n",
       "      <td>[2, 4, 12, 7, 5]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-15, -1, 5, 0, -6]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-2, 5, 2, -1, -3]</td>\n",
       "      <td>[0.42, 0.9, 1.19, 1.03, 0.74]</td>\n",
       "      <td>[18.0, 19.0, 13.0, 19.0, 24.0]</td>\n",
       "      <td>[4.0, 1.0, 4.0, 6.0, 3.0]</td>\n",
       "      <td>[20.0, 17.0, 17.0, 19.0, 19.0]</td>\n",
       "      <td>[6.0, 6.0, 4.0, 10.0, 8.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-2.0, 2.0, -4.0, 0.0, 5.0]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-1.0, 2.0, -2.0, -1.0, -1.0]</td>\n",
       "      <td>[0.91, 0.95, 0.79, 0.99, 1.19]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2298484_6.0</td>\n",
       "      <td>2015-10-07</td>\n",
       "      <td>6.0</td>\n",
       "      <td>666.0</td>\n",
       "      <td>[9, 9, 9, 9, 9]</td>\n",
       "      <td>[3849, 7528, 1146, 3055, 885]</td>\n",
       "      <td>2298484</td>\n",
       "      <td>1934</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[14, 16, 14, 24, 30]</td>\n",
       "      <td>[3, 5, 4, 7, 4]</td>\n",
       "      <td>[15, 14, 16, 13, 16]</td>\n",
       "      <td>[3, 5, 6, 9, 13]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-1, 2, -2, 11, 14]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[2, -1, 1, 1, -1]</td>\n",
       "      <td>[0.88, 0.96, 0.81, 1.4, 1.55]</td>\n",
       "      <td>[14, 16, 14, 24, 30]</td>\n",
       "      <td>[3, 5, 4, 7, 4]</td>\n",
       "      <td>[15, 14, 16, 13, 16]</td>\n",
       "      <td>[3, 5, 6, 9, 13]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[-1, 2, -2, 11, 14]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[2, -1, 1, 1, -1]</td>\n",
       "      <td>[0.88, 0.96, 0.81, 1.4, 1.55]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, 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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>75520</th>\n",
       "      <td>2339816_46.0</td>\n",
       "      <td>2020-02-27</td>\n",
       "      <td>46.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>[1, 3, 1, 3, 1]</td>\n",
       "      <td>[12090, 11445, 14022, 14613, 14489]</td>\n",
       "      <td>2339816</td>\n",
       "      <td>5151</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[9, 5, 7, 8, 10]</td>\n",
       "      <td>[0, 2, 0, 4, 4]</td>\n",
       "      <td>[16, 18, 18, 17, 16]</td>\n",
       "      <td>[8, 2, 4, 4, 6]</td>\n",
       "      <td>[0.0, 0.0, 0.0, 1.0, 0.0]</td>\n",
       "      <td>[55.6, 38.9, 33.3, 55.6, 55.6]</td>\n",
       "      <td>[-7, -13, -11, -9, -6]</td>\n",
       "      <td>[54.2, 49.0, 47.4, 51.8, 71.6]</td>\n",
       "      <td>[-1, -4, -2, -5, -2]</td>\n",
       "      <td>[0.52, 0.31, 0.32, 0.44, 0.63]</td>\n",
       "      <td>[9, 5, 7, 8, 10]</td>\n",
       "      <td>[0, 2, 0, 4, 4]</td>\n",
       "      <td>[16, 18, 18, 17, 16]</td>\n",
       "      <td>[8, 2, 4, 4, 6]</td>\n",
       "      <td>[0.0, 0.0, 0.0, 1.0, 0.0]</td>\n",
       "      <td>[55.6, 38.9, 33.3, 55.6, 55.6]</td>\n",
       "      <td>[-7, -13, -11, -9, -6]</td>\n",
       "      <td>[54.2, 49.0, 47.4, 51.8, 71.6]</td>\n",
       "      <td>[-1, -4, -2, -5, -2]</td>\n",
       "      <td>[0.52, 0.31, 0.32, 0.44, 0.63]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[8.0, nan, 6.0, nan, 9.0]</td>\n",
       "      <td>[13.0, nan, 15.0, nan, 13.0]</td>\n",
       "      <td>[-5.0, nan, -9.0, nan, -4.0]</td>\n",
       "      <td>[62.5, nan, 47.9, nan, 69.6]</td>\n",
       "      <td>[60.0, nan, 33.3, nan, 53.3]</td>\n",
       "      <td>[0.6, nan, 0.33, nan, 0.65]</td>\n",
       "      <td>[1.0, nan, 1.0, nan, 1.0]</td>\n",
       "      <td>[3.0, nan, 3.0, nan, 3.0]</td>\n",
       "      <td>[-2.0, nan, -2.0, nan, -2.0]</td>\n",
       "      <td>[12.3, nan, 45.0, nan, 81.7]</td>\n",
       "      <td>[33.3, nan, 33.3, nan, 66.7]</td>\n",
       "      <td>[0.14, nan, 0.27, nan, 0.56]</td>\n",
       "      <td>[8.0, nan, 6.0, nan, 9.0]</td>\n",
       "      <td>[13.0, nan, 15.0, nan, 13.0]</td>\n",
       "      <td>[-5.0, nan, -9.0, nan, -4.0]</td>\n",
       "      <td>[62.5, nan, 47.9, nan, 69.6]</td>\n",
       "      <td>[60.0, nan, 33.3, nan, 53.3]</td>\n",
       "      <td>[0.6, nan, 0.33, nan, 0.65]</td>\n",
       "      <td>[1.0, nan, 1.0, nan, 1.0]</td>\n",
       "      <td>[3.0, nan, 3.0, nan, 3.0]</td>\n",
       "      <td>[-2.0, nan, -2.0, nan, -2.0]</td>\n",
       "      <td>[12.3, nan, 45.0, nan, 81.7]</td>\n",
       "      <td>[33.3, nan, 33.3, nan, 66.7]</td>\n",
       "      <td>[0.14, nan, 0.27, nan, 0.56]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75521</th>\n",
       "      <td>2339817_40.0</td>\n",
       "      <td>2020-02-27</td>\n",
       "      <td>40.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>[1, 1, 1, 1, 1]</td>\n",
       "      <td>[15526, 14827, 14933, 13177, 13576]</td>\n",
       "      <td>2339817</td>\n",
       "      <td>5151</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[12, 21, 21, 23, 24]</td>\n",
       "      <td>[6, 10, 8, 10, 3]</td>\n",
       "      <td>[18, 21, 15, 17, 18]</td>\n",
       "      <td>[7, 4, 14, 9, 14]</td>\n",
       "      <td>[0.0, 5.0, 3.0, 3.0, 1.0]</td>\n",
       "      <td>[70.4, 77.8, 74.1, 77.8, 81.5]</td>\n",
       "      <td>[-6, 0, 6, 6, 6]</td>\n",
       "      <td>[52.7, 81.4, 76.0, 98.3, 87.1]</td>\n",
       "      <td>[-1, -4, 1, 2, 3]</td>\n",
       "      <td>[0.84, 1.09, 1.28, 1.47, 1.32]</td>\n",
       "      <td>[12, 21, 21, 23, 24]</td>\n",
       "      <td>[6, 10, 8, 10, 3]</td>\n",
       "      <td>[18, 21, 15, 17, 18]</td>\n",
       "      <td>[7, 4, 14, 9, 14]</td>\n",
       "      <td>[0.0, 5.0, 3.0, 3.0, 1.0]</td>\n",
       "      <td>[70.4, 77.8, 74.1, 77.8, 81.5]</td>\n",
       "      <td>[-6, 0, 6, 6, 6]</td>\n",
       "      <td>[52.7, 81.4, 76.0, 98.3, 87.1]</td>\n",
       "      <td>[-1, -4, 1, 2, 3]</td>\n",
       "      <td>[0.84, 1.09, 1.28, 1.47, 1.32]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[6.0, 13.0, 19.0, 11.0, 15.0]</td>\n",
       "      <td>[8.0, 11.0, 7.0, 8.0, 10.0]</td>\n",
       "      <td>[-2.0, 2.0, 12.0, 3.0, 5.0]</td>\n",
       "      <td>[54.1, 82.0, 119.3, 92.4, 89.4]</td>\n",
       "      <td>[73.3, 73.3, 93.3, 80.0, 80.0]</td>\n",
       "      <td>[0.81, 1.07, 1.94, 1.4, 1.28]</td>\n",
       "      <td>[6.0, 8.0, 2.0, 12.0, 9.0]</td>\n",
       "      <td>[10.0, 10.0, 8.0, 9.0, 8.0]</td>\n",
       "      <td>[-4.0, -2.0, -6.0, 3.0, 1.0]</td>\n",
       "      <td>[51.0, 80.8, 22.0, 105.7, 84.2]</td>\n",
       "      <td>[66.7, 83.3, 50.0, 75.0, 83.3]</td>\n",
       "      <td>[0.88, 1.1, 0.45, 1.56, 1.37]</td>\n",
       "      <td>[6.0, 13.0, 19.0, 11.0, 15.0]</td>\n",
       "      <td>[8.0, 11.0, 7.0, 8.0, 10.0]</td>\n",
       "      <td>[-2.0, 2.0, 12.0, 3.0, 5.0]</td>\n",
       "      <td>[54.1, 82.0, 119.3, 92.4, 89.4]</td>\n",
       "      <td>[73.3, 73.3, 93.3, 80.0, 80.0]</td>\n",
       "      <td>[0.81, 1.07, 1.94, 1.4, 1.28]</td>\n",
       "      <td>[6.0, 8.0, 2.0, 12.0, 9.0]</td>\n",
       "      <td>[10.0, 10.0, 8.0, 9.0, 8.0]</td>\n",
       "      <td>[-4.0, -2.0, -6.0, 3.0, 1.0]</td>\n",
       "      <td>[51.0, 80.8, 22.0, 105.7, 84.2]</td>\n",
       "      <td>[66.7, 83.3, 50.0, 75.0, 83.3]</td>\n",
       "      <td>[0.88, 1.1, 0.45, 1.56, 1.37]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75522</th>\n",
       "      <td>2339817_45.0</td>\n",
       "      <td>2020-02-27</td>\n",
       "      <td>45.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>[3, 3, 3, 1, 3]</td>\n",
       "      <td>[17510, 17511, 17470, 12937, 17658]</td>\n",
       "      <td>2339817</td>\n",
       "      <td>5151</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[17, 16, 20, 23, 12]</td>\n",
       "      <td>[3, 7, 5, 4, 6]</td>\n",
       "      <td>[20, 21, 23, 17, 20]</td>\n",
       "      <td>[11, 7, 13, 10, 4]</td>\n",
       "      <td>[1.0, 2.0, 2.0, 1.0, 3.0]</td>\n",
       "      <td>[66.7, 74.1, 59.3, 70.4, 74.1]</td>\n",
       "      <td>[-3, -5, -3, 6, -8]</td>\n",
       "      <td>[69.3, 69.7, 73.5, 87.9, 62.7]</td>\n",
       "      <td>[-1, 4, -2, 1, -3]</td>\n",
       "      <td>[0.87, 1.0, 0.85, 1.27, 0.81]</td>\n",
       "      <td>[17, 16, 20, 23, 12]</td>\n",
       "      <td>[3, 7, 5, 4, 6]</td>\n",
       "      <td>[20, 21, 23, 17, 20]</td>\n",
       "      <td>[11, 7, 13, 10, 4]</td>\n",
       "      <td>[1.0, 2.0, 2.0, 1.0, 3.0]</td>\n",
       "      <td>[66.7, 74.1, 59.3, 70.4, 74.1]</td>\n",
       "      <td>[-3, -5, -3, 6, -8]</td>\n",
       "      <td>[69.3, 69.7, 73.5, 87.9, 62.7]</td>\n",
       "      <td>[-1, 4, -2, 1, -3]</td>\n",
       "      <td>[0.87, 1.0, 0.85, 1.27, 0.81]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[10.0, 8.0, 9.0, 12.0, 6.0]</td>\n",
       "      <td>[8.0, 7.0, 10.0, 5.0, 7.0]</td>\n",
       "      <td>[2.0, 1.0, -1.0, 7.0, -1.0]</td>\n",
       "      <td>[74.3, 72.2, 82.8, 97.6, 63.8]</td>\n",
       "      <td>[83.3, 83.3, 50.0, 83.3, 58.3]</td>\n",
       "      <td>[1.08, 1.1, 0.82, 1.59, 0.75]</td>\n",
       "      <td>[7.0, 8.0, 11.0, 11.0, 6.0]</td>\n",
       "      <td>[12.0, 14.0, 13.0, 12.0, 13.0]</td>\n",
       "      <td>[-5.0, -6.0, -2.0, -1.0, -7.0]</td>\n",
       "      <td>[65.3, 67.8, 66.1, 80.2, 61.8]</td>\n",
       "      <td>[53.3, 66.7, 66.7, 60.0, 86.7]</td>\n",
       "      <td>[0.7, 0.93, 0.87, 1.01, 0.85]</td>\n",
       "      <td>[10.0, 8.0, 9.0, 12.0, 6.0]</td>\n",
       "      <td>[8.0, 7.0, 10.0, 5.0, 7.0]</td>\n",
       "      <td>[2.0, 1.0, -1.0, 7.0, -1.0]</td>\n",
       "      <td>[74.3, 72.2, 82.8, 97.6, 63.8]</td>\n",
       "      <td>[83.3, 83.3, 50.0, 83.3, 58.3]</td>\n",
       "      <td>[1.08, 1.1, 0.82, 1.59, 0.75]</td>\n",
       "      <td>[7.0, 8.0, 11.0, 11.0, 6.0]</td>\n",
       "      <td>[12.0, 14.0, 13.0, 12.0, 13.0]</td>\n",
       "      <td>[-5.0, -6.0, -2.0, -1.0, -7.0]</td>\n",
       "      <td>[65.3, 67.8, 66.1, 80.2, 61.8]</td>\n",
       "      <td>[53.3, 66.7, 66.7, 60.0, 86.7]</td>\n",
       "      <td>[0.7, 0.93, 0.87, 1.01, 0.85]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75523</th>\n",
       "      <td>2339828_110.0</td>\n",
       "      <td>2020-02-26</td>\n",
       "      <td>110.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>[21, 21, 21, 21, 21]</td>\n",
       "      <td>[12917, 11806, 18736, 17307, 16281]</td>\n",
       "      <td>2339828</td>\n",
       "      <td>5152</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[13, 10, 19, 13, 11]</td>\n",
       "      <td>[2, 1, 3, 2, 2]</td>\n",
       "      <td>[20, 20, 17, 18, 19]</td>\n",
       "      <td>[6, 7, 5, 4, 4]</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 1.0]</td>\n",
       "      <td>[52.2, 47.8, 73.9, 60.9, 47.8]</td>\n",
       "      <td>[-7, -10, 2, -5, -8]</td>\n",
       "      <td>[58.9, 47.8, 87.9, 74.2, 52.7]</td>\n",
       "      <td>[-3, -3, -3, -2, -4]</td>\n",
       "      <td>[0.62, 0.56, 1.15, 0.9, 0.63]</td>\n",
       "      <td>[13, 10, 19, 13, 11]</td>\n",
       "      <td>[2, 1, 3, 2, 2]</td>\n",
       "      <td>[20, 20, 17, 18, 19]</td>\n",
       "      <td>[6, 7, 5, 4, 4]</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 1.0]</td>\n",
       "      <td>[52.2, 47.8, 73.9, 60.9, 47.8]</td>\n",
       "      <td>[-7, -10, 2, -5, -8]</td>\n",
       "      <td>[58.9, 47.8, 87.9, 74.2, 52.7]</td>\n",
       "      <td>[-3, -3, -3, -2, -4]</td>\n",
       "      <td>[0.62, 0.56, 1.15, 0.9, 0.63]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[3.0, 6.0, 4.0, 2.0, 5.0]</td>\n",
       "      <td>[8.0, 7.0, 7.0, 7.0, 6.0]</td>\n",
       "      <td>[-5.0, -1.0, -3.0, -5.0, -1.0]</td>\n",
       "      <td>[42.9, 63.2, 61.2, 59.1, 61.4]</td>\n",
       "      <td>[37.5, 62.5, 62.5, 50.0, 37.5]</td>\n",
       "      <td>[0.23, 0.75, 0.73, 0.35, 0.68]</td>\n",
       "      <td>[10.0, 4.0, 15.0, 11.0, 6.0]</td>\n",
       "      <td>[12.0, 13.0, 10.0, 11.0, 13.0]</td>\n",
       "      <td>[-2.0, -9.0, 5.0, 0.0, -7.0]</td>\n",
       "      <td>[67.4, 39.6, 102.1, 82.2, 48.0]</td>\n",
       "      <td>[60.0, 40.0, 80.0, 66.7, 53.3]</td>\n",
       "      <td>[0.83, 0.46, 1.37, 1.19, 0.61]</td>\n",
       "      <td>[3.0, 6.0, 4.0, 2.0, 5.0]</td>\n",
       "      <td>[8.0, 7.0, 7.0, 7.0, 6.0]</td>\n",
       "      <td>[-5.0, -1.0, -3.0, -5.0, -1.0]</td>\n",
       "      <td>[42.9, 63.2, 61.2, 59.1, 61.4]</td>\n",
       "      <td>[37.5, 62.5, 62.5, 50.0, 37.5]</td>\n",
       "      <td>[0.23, 0.75, 0.73, 0.35, 0.68]</td>\n",
       "      <td>[10.0, 4.0, 15.0, 11.0, 6.0]</td>\n",
       "      <td>[12.0, 13.0, 10.0, 11.0, 13.0]</td>\n",
       "      <td>[-2.0, -9.0, 5.0, 0.0, -7.0]</td>\n",
       "      <td>[67.4, 39.6, 102.1, 82.2, 48.0]</td>\n",
       "      <td>[60.0, 40.0, 80.0, 66.7, 53.3]</td>\n",
       "      <td>[0.83, 0.46, 1.37, 1.19, 0.61]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75524</th>\n",
       "      <td>2339828_56.0</td>\n",
       "      <td>2020-02-26</td>\n",
       "      <td>56.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>[21, 21, 21, 21, 21]</td>\n",
       "      <td>[11538, 14957, 14290, 12872, 12086]</td>\n",
       "      <td>2339828</td>\n",
       "      <td>5152</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[19, 28, 18, 18, 11]</td>\n",
       "      <td>[1, 9, 7, 10, 3]</td>\n",
       "      <td>[14, 13, 16, 13, 10]</td>\n",
       "      <td>[11, 10, 9, 3, 4]</td>\n",
       "      <td>[0.0, 3.0, 0.0, 6.0, 1.0]</td>\n",
       "      <td>[78.3, 91.3, 73.9, 82.6, 78.3]</td>\n",
       "      <td>[5, 15, 2, 5, 1]</td>\n",
       "      <td>[78.9, 135.0, 87.6, 82.4, 47.0]</td>\n",
       "      <td>[4, 6, 0, 4, 1]</td>\n",
       "      <td>[1.27, 2.04, 1.21, 1.28, 0.91]</td>\n",
       "      <td>[19, 28, 18, 18, 11]</td>\n",
       "      <td>[1, 9, 7, 10, 3]</td>\n",
       "      <td>[14, 13, 16, 13, 10]</td>\n",
       "      <td>[11, 10, 9, 3, 4]</td>\n",
       "      <td>[0.0, 3.0, 0.0, 6.0, 1.0]</td>\n",
       "      <td>[78.3, 91.3, 73.9, 82.6, 78.3]</td>\n",
       "      <td>[5, 15, 2, 5, 1]</td>\n",
       "      <td>[78.9, 135.0, 87.6, 82.4, 47.0]</td>\n",
       "      <td>[4, 6, 0, 4, 1]</td>\n",
       "      <td>[1.27, 2.04, 1.21, 1.28, 0.91]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[13.0, 12.0, 14.0, 13.0, 7.0]</td>\n",
       "      <td>[10.0, 10.0, 9.0, 9.0, 8.0]</td>\n",
       "      <td>[3.0, 2.0, 5.0, 4.0, -1.0]</td>\n",
       "      <td>[85.6, 100.5, 100.9, 85.6, 47.3]</td>\n",
       "      <td>[80.0, 86.7, 86.7, 80.0, 73.3]</td>\n",
       "      <td>[1.18, 1.33, 1.46, 1.28, 0.84]</td>\n",
       "      <td>[6.0, 16.0, 4.0, 5.0, 4.0]</td>\n",
       "      <td>[4.0, 3.0, 7.0, 4.0, 2.0]</td>\n",
       "      <td>[2.0, 13.0, -3.0, 1.0, 2.0]</td>\n",
       "      <td>[66.4, 199.6, 62.6, 76.4, 46.5]</td>\n",
       "      <td>[75.0, 100.0, 50.0, 87.5, 87.5]</td>\n",
       "      <td>[1.44, 3.36, 0.72, 1.29, 1.05]</td>\n",
       "      <td>[13.0, 12.0, 14.0, 13.0, 7.0]</td>\n",
       "      <td>[10.0, 10.0, 9.0, 9.0, 8.0]</td>\n",
       "      <td>[3.0, 2.0, 5.0, 4.0, -1.0]</td>\n",
       "      <td>[85.6, 100.5, 100.9, 85.6, 47.3]</td>\n",
       "      <td>[80.0, 86.7, 86.7, 80.0, 73.3]</td>\n",
       "      <td>[1.18, 1.33, 1.46, 1.28, 0.84]</td>\n",
       "      <td>[6.0, 16.0, 4.0, 5.0, 4.0]</td>\n",
       "      <td>[4.0, 3.0, 7.0, 4.0, 2.0]</td>\n",
       "      <td>[2.0, 13.0, -3.0, 1.0, 2.0]</td>\n",
       "      <td>[66.4, 199.6, 62.6, 76.4, 46.5]</td>\n",
       "      <td>[75.0, 100.0, 50.0, 87.5, 87.5]</td>\n",
       "      <td>[1.44, 3.36, 0.72, 1.29, 1.05]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "      <td>[nan, nan, nan, nan, nan]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75525 rows × 100 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 uid        date  team_mapped  opponent_mapped  \\\n",
       "0      2297880_700.0  2015-10-15        700.0            832.0   \n",
       "1      2297880_832.0  2015-10-15        832.0            700.0   \n",
       "2      2298447_675.0  2015-10-18        675.0            792.0   \n",
       "3      2298447_792.0  2015-10-18        792.0            675.0   \n",
       "4        2298484_6.0  2015-10-07          6.0            666.0   \n",
       "...              ...         ...          ...              ...   \n",
       "75520   2339816_46.0  2020-02-27         46.0             17.0   \n",
       "75521   2339817_40.0  2020-02-27         40.0             45.0   \n",
       "75522   2339817_45.0  2020-02-27         45.0             40.0   \n",
       "75523  2339828_110.0  2020-02-26        110.0             56.0   \n",
       "75524   2339828_56.0  2020-02-26         56.0            110.0   \n",
       "\n",
       "             country_mapped                            player_id  match_id  \\\n",
       "0           [3, 1, 3, 3, 3]       [6455, 8350, 3887, 8515, 8494]   2297880   \n",
       "1           [3, 1, 1, 1, 1]       [6451, 8347, 8346, 8137, 8523]   2297880   \n",
       "2      [18, 17, 17, 18, 18]         [472, 8124, 7403, 2131, 338]   2298447   \n",
       "3      [14, 14, 14, 14, 14]       [7415, 8783, 5061, 7412, 8150]   2298447   \n",
       "4           [9, 9, 9, 9, 9]        [3849, 7528, 1146, 3055, 885]   2298484   \n",
       "...                     ...                                  ...       ...   \n",
       "75520       [1, 3, 1, 3, 1]  [12090, 11445, 14022, 14613, 14489]   2339816   \n",
       "75521       [1, 1, 1, 1, 1]  [15526, 14827, 14933, 13177, 13576]   2339817   \n",
       "75522       [3, 3, 3, 1, 3]  [17510, 17511, 17470, 12937, 17658]   2339817   \n",
       "75523  [21, 21, 21, 21, 21]  [12917, 11806, 18736, 17307, 16281]   2339828   \n",
       "75524  [21, 21, 21, 21, 21]  [11538, 14957, 14290, 12872, 12086]   2339828   \n",
       "\n",
       "       event_id  best_of  map_1_mapped  map_2_mapped  map_3_mapped  \\\n",
       "0          1890        2            10           7.0           NaN   \n",
       "1          1890        2            10           7.0           NaN   \n",
       "2          1881        2            10           4.0           NaN   \n",
       "3          1881        2            10           4.0           NaN   \n",
       "4          1934        1            10           NaN           NaN   \n",
       "...         ...      ...           ...           ...           ...   \n",
       "75520      5151        1             4           NaN           NaN   \n",
       "75521      5151        1             1           NaN           NaN   \n",
       "75522      5151        1             1           NaN           NaN   \n",
       "75523      5152        1             2           NaN           NaN   \n",
       "75524      5152        1             2           NaN           NaN   \n",
       "\n",
       "                      kills            assists                deaths  \\\n",
       "0      [16, 27, 12, 19, 15]    [2, 2, 4, 4, 3]  [36, 32, 34, 32, 34]   \n",
       "1      [34, 33, 32, 33, 36]   [8, 4, 9, 10, 6]  [18, 18, 19, 17, 17]   \n",
       "2      [41, 20, 52, 46, 40]  [10, 7, 5, 9, 13]  [41, 43, 33, 32, 35]   \n",
       "3      [25, 39, 39, 43, 38]   [8, 2, 5, 11, 7]  [42, 38, 38, 43, 39]   \n",
       "4      [14, 16, 14, 24, 30]    [3, 5, 4, 7, 4]  [15, 14, 16, 13, 16]   \n",
       "...                     ...                ...                   ...   \n",
       "75520      [9, 5, 7, 8, 10]    [0, 2, 0, 4, 4]  [16, 18, 18, 17, 16]   \n",
       "75521  [12, 21, 21, 23, 24]  [6, 10, 8, 10, 3]  [18, 21, 15, 17, 18]   \n",
       "75522  [17, 16, 20, 23, 12]    [3, 7, 5, 4, 6]  [20, 21, 23, 17, 20]   \n",
       "75523  [13, 10, 19, 13, 11]    [2, 1, 3, 2, 2]  [20, 20, 17, 18, 19]   \n",
       "75524  [19, 28, 18, 18, 11]   [1, 9, 7, 10, 3]  [14, 13, 16, 13, 10]   \n",
       "\n",
       "                        hs              flash_assists  \\\n",
       "0        [12, 14, 4, 7, 5]  [nan, nan, nan, nan, nan]   \n",
       "1      [14, 11, 5, 16, 14]  [nan, nan, nan, nan, nan]   \n",
       "2      [15, 5, 14, 24, 17]  [nan, nan, nan, nan, nan]   \n",
       "3      [8, 10, 16, 17, 13]  [nan, nan, nan, nan, nan]   \n",
       "4         [3, 5, 6, 9, 13]  [nan, nan, nan, nan, nan]   \n",
       "...                    ...                        ...   \n",
       "75520      [8, 2, 4, 4, 6]  [0.0, 0.0, 0.0, 1.0, 0.0]   \n",
       "75521    [7, 4, 14, 9, 14]  [0.0, 5.0, 3.0, 3.0, 1.0]   \n",
       "75522   [11, 7, 13, 10, 4]  [1.0, 2.0, 2.0, 1.0, 3.0]   \n",
       "75523      [6, 7, 5, 4, 4]  [0.0, 0.0, 0.0, 0.0, 1.0]   \n",
       "75524    [11, 10, 9, 3, 4]  [0.0, 3.0, 0.0, 6.0, 1.0]   \n",
       "\n",
       "                                 kast                    kddiff  \\\n",
       "0           [nan, nan, nan, nan, nan]  [-20, -5, -22, -13, -19]   \n",
       "1           [nan, nan, nan, nan, nan]      [16, 15, 13, 16, 19]   \n",
       "2           [nan, nan, nan, nan, nan]       [0, -23, 19, 14, 5]   \n",
       "3           [nan, nan, nan, nan, nan]        [-17, 1, 1, 0, -1]   \n",
       "4           [nan, nan, nan, nan, nan]       [-1, 2, -2, 11, 14]   \n",
       "...                               ...                       ...   \n",
       "75520  [55.6, 38.9, 33.3, 55.6, 55.6]    [-7, -13, -11, -9, -6]   \n",
       "75521  [70.4, 77.8, 74.1, 77.8, 81.5]          [-6, 0, 6, 6, 6]   \n",
       "75522  [66.7, 74.1, 59.3, 70.4, 74.1]       [-3, -5, -3, 6, -8]   \n",
       "75523  [52.2, 47.8, 73.9, 60.9, 47.8]      [-7, -10, 2, -5, -8]   \n",
       "75524  [78.3, 91.3, 73.9, 82.6, 78.3]          [5, 15, 2, 5, 1]   \n",
       "\n",
       "                                   adr                fkdiff  \\\n",
       "0            [nan, nan, nan, nan, nan]  [-5, -3, -5, -6, -3]   \n",
       "1            [nan, nan, nan, nan, nan]       [7, 5, 7, 3, 0]   \n",
       "2            [nan, nan, nan, nan, nan]      [0, -2, 0, 2, 1]   \n",
       "3            [nan, nan, nan, nan, nan]    [-3, 7, 0, -2, -4]   \n",
       "4            [nan, nan, nan, nan, nan]     [2, -1, 1, 1, -1]   \n",
       "...                                ...                   ...   \n",
       "75520   [54.2, 49.0, 47.4, 51.8, 71.6]  [-1, -4, -2, -5, -2]   \n",
       "75521   [52.7, 81.4, 76.0, 98.3, 87.1]     [-1, -4, 1, 2, 3]   \n",
       "75522   [69.3, 69.7, 73.5, 87.9, 62.7]    [-1, 4, -2, 1, -3]   \n",
       "75523   [58.9, 47.8, 87.9, 74.2, 52.7]  [-3, -3, -3, -2, -4]   \n",
       "75524  [78.9, 135.0, 87.6, 82.4, 47.0]       [4, 6, 0, 4, 1]   \n",
       "\n",
       "                               rating              m1_kills  \\\n",
       "0      [0.42, 0.96, 0.39, 0.64, 0.47]      [8, 10, 8, 7, 8]   \n",
       "1      [1.39, 1.48, 1.45, 1.41, 1.46]  [15, 10, 19, 20, 20]   \n",
       "2       [1.02, 0.55, 1.4, 1.28, 1.09]   [22, 6, 24, 30, 25]   \n",
       "3      [0.67, 0.92, 0.99, 1.01, 0.96]   [7, 20, 26, 24, 14]   \n",
       "4       [0.88, 0.96, 0.81, 1.4, 1.55]  [14, 16, 14, 24, 30]   \n",
       "...                               ...                   ...   \n",
       "75520  [0.52, 0.31, 0.32, 0.44, 0.63]      [9, 5, 7, 8, 10]   \n",
       "75521  [0.84, 1.09, 1.28, 1.47, 1.32]  [12, 21, 21, 23, 24]   \n",
       "75522   [0.87, 1.0, 0.85, 1.27, 0.81]  [17, 16, 20, 23, 12]   \n",
       "75523   [0.62, 0.56, 1.15, 0.9, 0.63]  [13, 10, 19, 13, 11]   \n",
       "75524  [1.27, 2.04, 1.21, 1.28, 0.91]  [19, 28, 18, 18, 11]   \n",
       "\n",
       "              m1_assists             m1_deaths               m1_hs  \\\n",
       "0        [1, 0, 2, 3, 2]  [17, 17, 17, 16, 17]     [5, 3, 4, 4, 3]   \n",
       "1        [4, 2, 6, 4, 5]       [8, 8, 8, 8, 9]    [7, 3, 3, 11, 8]   \n",
       "2        [5, 6, 3, 4, 7]  [20, 22, 19, 13, 17]   [5, 2, 8, 17, 10]   \n",
       "3        [4, 1, 1, 5, 4]  [22, 21, 21, 24, 20]    [2, 4, 12, 7, 5]   \n",
       "4        [3, 5, 4, 7, 4]  [15, 14, 16, 13, 16]    [3, 5, 6, 9, 13]   \n",
       "...                  ...                   ...                 ...   \n",
       "75520    [0, 2, 0, 4, 4]  [16, 18, 18, 17, 16]     [8, 2, 4, 4, 6]   \n",
       "75521  [6, 10, 8, 10, 3]  [18, 21, 15, 17, 18]   [7, 4, 14, 9, 14]   \n",
       "75522    [3, 7, 5, 4, 6]  [20, 21, 23, 17, 20]  [11, 7, 13, 10, 4]   \n",
       "75523    [2, 1, 3, 2, 2]  [20, 20, 17, 18, 19]     [6, 7, 5, 4, 4]   \n",
       "75524   [1, 9, 7, 10, 3]  [14, 13, 16, 13, 10]   [11, 10, 9, 3, 4]   \n",
       "\n",
       "                m1_flash_assists                         m1_kast  \\\n",
       "0      [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                          ...                             ...   \n",
       "75520  [0.0, 0.0, 0.0, 1.0, 0.0]  [55.6, 38.9, 33.3, 55.6, 55.6]   \n",
       "75521  [0.0, 5.0, 3.0, 3.0, 1.0]  [70.4, 77.8, 74.1, 77.8, 81.5]   \n",
       "75522  [1.0, 2.0, 2.0, 1.0, 3.0]  [66.7, 74.1, 59.3, 70.4, 74.1]   \n",
       "75523  [0.0, 0.0, 0.0, 0.0, 1.0]  [52.2, 47.8, 73.9, 60.9, 47.8]   \n",
       "75524  [0.0, 3.0, 0.0, 6.0, 1.0]  [78.3, 91.3, 73.9, 82.6, 78.3]   \n",
       "\n",
       "                    m1_kddiff                           m1_adr  \\\n",
       "0        [-9, -7, -9, -9, -9]        [nan, nan, nan, nan, nan]   \n",
       "1          [7, 2, 11, 12, 11]        [nan, nan, nan, nan, nan]   \n",
       "2          [2, -16, 5, 17, 8]        [nan, nan, nan, nan, nan]   \n",
       "3         [-15, -1, 5, 0, -6]        [nan, nan, nan, nan, nan]   \n",
       "4         [-1, 2, -2, 11, 14]        [nan, nan, nan, nan, nan]   \n",
       "...                       ...                              ...   \n",
       "75520  [-7, -13, -11, -9, -6]   [54.2, 49.0, 47.4, 51.8, 71.6]   \n",
       "75521        [-6, 0, 6, 6, 6]   [52.7, 81.4, 76.0, 98.3, 87.1]   \n",
       "75522     [-3, -5, -3, 6, -8]   [69.3, 69.7, 73.5, 87.9, 62.7]   \n",
       "75523    [-7, -10, 2, -5, -8]   [58.9, 47.8, 87.9, 74.2, 52.7]   \n",
       "75524        [5, 15, 2, 5, 1]  [78.9, 135.0, 87.6, 82.4, 47.0]   \n",
       "\n",
       "                  m1_fkdiff                       m1_rating  \\\n",
       "0       [-1, 0, -1, -4, -1]   [0.46, 0.59, 0.53, 0.46, 0.5]   \n",
       "1           [3, 0, 2, 1, 1]  [1.34, 0.99, 1.95, 1.82, 1.57]   \n",
       "2         [1, -2, -4, 2, 1]   [1.13, 0.37, 1.25, 1.71, 1.3]   \n",
       "3        [-2, 5, 2, -1, -3]   [0.42, 0.9, 1.19, 1.03, 0.74]   \n",
       "4         [2, -1, 1, 1, -1]   [0.88, 0.96, 0.81, 1.4, 1.55]   \n",
       "...                     ...                             ...   \n",
       "75520  [-1, -4, -2, -5, -2]  [0.52, 0.31, 0.32, 0.44, 0.63]   \n",
       "75521     [-1, -4, 1, 2, 3]  [0.84, 1.09, 1.28, 1.47, 1.32]   \n",
       "75522    [-1, 4, -2, 1, -3]   [0.87, 1.0, 0.85, 1.27, 0.81]   \n",
       "75523  [-3, -3, -3, -2, -4]   [0.62, 0.56, 1.15, 0.9, 0.63]   \n",
       "75524       [4, 6, 0, 4, 1]  [1.27, 2.04, 1.21, 1.28, 0.91]   \n",
       "\n",
       "                             m2_kills                 m2_assists  \\\n",
       "0         [8.0, 17.0, 4.0, 12.0, 7.0]  [1.0, 2.0, 2.0, 1.0, 1.0]   \n",
       "1      [19.0, 23.0, 13.0, 13.0, 16.0]  [4.0, 2.0, 3.0, 6.0, 1.0]   \n",
       "2      [19.0, 14.0, 28.0, 16.0, 15.0]  [5.0, 1.0, 2.0, 5.0, 6.0]   \n",
       "3      [18.0, 19.0, 13.0, 19.0, 24.0]  [4.0, 1.0, 4.0, 6.0, 3.0]   \n",
       "4           [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                               ...                        ...   \n",
       "75520       [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521       [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522       [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523       [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524       [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                            m2_deaths                       m2_hs  \\\n",
       "0      [19.0, 15.0, 17.0, 16.0, 17.0]  [7.0, 11.0, 0.0, 3.0, 2.0]   \n",
       "1        [10.0, 10.0, 11.0, 9.0, 8.0]   [7.0, 8.0, 2.0, 5.0, 6.0]   \n",
       "2      [21.0, 21.0, 14.0, 19.0, 18.0]  [10.0, 3.0, 6.0, 7.0, 7.0]   \n",
       "3      [20.0, 17.0, 17.0, 19.0, 19.0]  [6.0, 6.0, 4.0, 10.0, 8.0]   \n",
       "4           [nan, nan, nan, nan, nan]   [nan, nan, nan, nan, nan]   \n",
       "...                               ...                         ...   \n",
       "75520       [nan, nan, nan, nan, nan]   [nan, nan, nan, nan, nan]   \n",
       "75521       [nan, nan, nan, nan, nan]   [nan, nan, nan, nan, nan]   \n",
       "75522       [nan, nan, nan, nan, nan]   [nan, nan, nan, nan, nan]   \n",
       "75523       [nan, nan, nan, nan, nan]   [nan, nan, nan, nan, nan]   \n",
       "75524       [nan, nan, nan, nan, nan]   [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                m2_flash_assists                    m2_kast  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                              m2_kddiff                     m2_adr  \\\n",
       "0      [-11.0, 2.0, -13.0, -4.0, -10.0]  [nan, nan, nan, nan, nan]   \n",
       "1            [9.0, 13.0, 2.0, 4.0, 8.0]  [nan, nan, nan, nan, nan]   \n",
       "2        [-2.0, -7.0, 14.0, -3.0, -3.0]  [nan, nan, nan, nan, nan]   \n",
       "3           [-2.0, 2.0, -4.0, 0.0, 5.0]  [nan, nan, nan, nan, nan]   \n",
       "4             [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                                 ...                        ...   \n",
       "75520         [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521         [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522         [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523         [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524         [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                            m2_fkdiff                       m2_rating  \\\n",
       "0      [-4.0, -3.0, -4.0, -2.0, -2.0]  [0.38, 1.29, 0.26, 0.81, 0.45]   \n",
       "1          [4.0, 5.0, 5.0, 2.0, -1.0]  [1.44, 1.92, 1.01, 1.03, 1.36]   \n",
       "2          [-1.0, 0.0, 4.0, 0.0, 0.0]  [0.91, 0.73, 1.55, 0.84, 0.88]   \n",
       "3       [-1.0, 2.0, -2.0, -1.0, -1.0]  [0.91, 0.95, 0.79, 0.99, 1.19]   \n",
       "4           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                               ...                             ...   \n",
       "75520       [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "75521       [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "75522       [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "75523       [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "75524       [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                        m3_kills                 m3_assists  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                       m3_deaths                      m3_hs  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                m3_flash_assists                    m3_kast  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                       m3_kddiff                     m3_adr  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                       m3_fkdiff                  m3_rating  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                            kills_ct                     deaths_ct  \\\n",
       "0          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "1          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "2          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "3          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "4          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "...                              ...                           ...   \n",
       "75520      [8.0, nan, 6.0, nan, 9.0]  [13.0, nan, 15.0, nan, 13.0]   \n",
       "75521  [6.0, 13.0, 19.0, 11.0, 15.0]   [8.0, 11.0, 7.0, 8.0, 10.0]   \n",
       "75522    [10.0, 8.0, 9.0, 12.0, 6.0]    [8.0, 7.0, 10.0, 5.0, 7.0]   \n",
       "75523      [3.0, 6.0, 4.0, 2.0, 5.0]     [8.0, 7.0, 7.0, 7.0, 6.0]   \n",
       "75524  [13.0, 12.0, 14.0, 13.0, 7.0]   [10.0, 10.0, 9.0, 9.0, 8.0]   \n",
       "\n",
       "                            kddiff_ct                            adr_ct  \\\n",
       "0           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "1           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "2           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "3           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "4           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "...                               ...                               ...   \n",
       "75520    [-5.0, nan, -9.0, nan, -4.0]      [62.5, nan, 47.9, nan, 69.6]   \n",
       "75521     [-2.0, 2.0, 12.0, 3.0, 5.0]   [54.1, 82.0, 119.3, 92.4, 89.4]   \n",
       "75522     [2.0, 1.0, -1.0, 7.0, -1.0]    [74.3, 72.2, 82.8, 97.6, 63.8]   \n",
       "75523  [-5.0, -1.0, -3.0, -5.0, -1.0]    [42.9, 63.2, 61.2, 59.1, 61.4]   \n",
       "75524      [3.0, 2.0, 5.0, 4.0, -1.0]  [85.6, 100.5, 100.9, 85.6, 47.3]   \n",
       "\n",
       "                              kast_ct                       rating_ct  \\\n",
       "0           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "1           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "2           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "3           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "4           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                               ...                             ...   \n",
       "75520    [60.0, nan, 33.3, nan, 53.3]     [0.6, nan, 0.33, nan, 0.65]   \n",
       "75521  [73.3, 73.3, 93.3, 80.0, 80.0]   [0.81, 1.07, 1.94, 1.4, 1.28]   \n",
       "75522  [83.3, 83.3, 50.0, 83.3, 58.3]   [1.08, 1.1, 0.82, 1.59, 0.75]   \n",
       "75523  [37.5, 62.5, 62.5, 50.0, 37.5]  [0.23, 0.75, 0.73, 0.35, 0.68]   \n",
       "75524  [80.0, 86.7, 86.7, 80.0, 73.3]  [1.18, 1.33, 1.46, 1.28, 0.84]   \n",
       "\n",
       "                            kills_t                        deaths_t  \\\n",
       "0         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "1         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "2         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "3         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "4         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                             ...                             ...   \n",
       "75520     [1.0, nan, 1.0, nan, 1.0]       [3.0, nan, 3.0, nan, 3.0]   \n",
       "75521    [6.0, 8.0, 2.0, 12.0, 9.0]     [10.0, 10.0, 8.0, 9.0, 8.0]   \n",
       "75522   [7.0, 8.0, 11.0, 11.0, 6.0]  [12.0, 14.0, 13.0, 12.0, 13.0]   \n",
       "75523  [10.0, 4.0, 15.0, 11.0, 6.0]  [12.0, 13.0, 10.0, 11.0, 13.0]   \n",
       "75524    [6.0, 16.0, 4.0, 5.0, 4.0]       [4.0, 3.0, 7.0, 4.0, 2.0]   \n",
       "\n",
       "                             kddiff_t                            adr_t  \\\n",
       "0           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "1           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "2           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "3           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "4           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "...                               ...                              ...   \n",
       "75520    [-2.0, nan, -2.0, nan, -2.0]     [12.3, nan, 45.0, nan, 81.7]   \n",
       "75521    [-4.0, -2.0, -6.0, 3.0, 1.0]  [51.0, 80.8, 22.0, 105.7, 84.2]   \n",
       "75522  [-5.0, -6.0, -2.0, -1.0, -7.0]   [65.3, 67.8, 66.1, 80.2, 61.8]   \n",
       "75523    [-2.0, -9.0, 5.0, 0.0, -7.0]  [67.4, 39.6, 102.1, 82.2, 48.0]   \n",
       "75524     [2.0, 13.0, -3.0, 1.0, 2.0]  [66.4, 199.6, 62.6, 76.4, 46.5]   \n",
       "\n",
       "                                kast_t                        rating_t  \\\n",
       "0            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "1            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "2            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "3            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "4            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                                ...                             ...   \n",
       "75520     [33.3, nan, 33.3, nan, 66.7]    [0.14, nan, 0.27, nan, 0.56]   \n",
       "75521   [66.7, 83.3, 50.0, 75.0, 83.3]   [0.88, 1.1, 0.45, 1.56, 1.37]   \n",
       "75522   [53.3, 66.7, 66.7, 60.0, 86.7]   [0.7, 0.93, 0.87, 1.01, 0.85]   \n",
       "75523   [60.0, 40.0, 80.0, 66.7, 53.3]  [0.83, 0.46, 1.37, 1.19, 0.61]   \n",
       "75524  [75.0, 100.0, 50.0, 87.5, 87.5]  [1.44, 3.36, 0.72, 1.29, 1.05]   \n",
       "\n",
       "                         m1_kills_ct                  m1_deaths_ct  \\\n",
       "0          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "1          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "2          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "3          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "4          [nan, nan, nan, nan, nan]     [nan, nan, nan, nan, nan]   \n",
       "...                              ...                           ...   \n",
       "75520      [8.0, nan, 6.0, nan, 9.0]  [13.0, nan, 15.0, nan, 13.0]   \n",
       "75521  [6.0, 13.0, 19.0, 11.0, 15.0]   [8.0, 11.0, 7.0, 8.0, 10.0]   \n",
       "75522    [10.0, 8.0, 9.0, 12.0, 6.0]    [8.0, 7.0, 10.0, 5.0, 7.0]   \n",
       "75523      [3.0, 6.0, 4.0, 2.0, 5.0]     [8.0, 7.0, 7.0, 7.0, 6.0]   \n",
       "75524  [13.0, 12.0, 14.0, 13.0, 7.0]   [10.0, 10.0, 9.0, 9.0, 8.0]   \n",
       "\n",
       "                         m1_kddiff_ct                         m1_adr_ct  \\\n",
       "0           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "1           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "2           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "3           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "4           [nan, nan, nan, nan, nan]         [nan, nan, nan, nan, nan]   \n",
       "...                               ...                               ...   \n",
       "75520    [-5.0, nan, -9.0, nan, -4.0]      [62.5, nan, 47.9, nan, 69.6]   \n",
       "75521     [-2.0, 2.0, 12.0, 3.0, 5.0]   [54.1, 82.0, 119.3, 92.4, 89.4]   \n",
       "75522     [2.0, 1.0, -1.0, 7.0, -1.0]    [74.3, 72.2, 82.8, 97.6, 63.8]   \n",
       "75523  [-5.0, -1.0, -3.0, -5.0, -1.0]    [42.9, 63.2, 61.2, 59.1, 61.4]   \n",
       "75524      [3.0, 2.0, 5.0, 4.0, -1.0]  [85.6, 100.5, 100.9, 85.6, 47.3]   \n",
       "\n",
       "                           m1_kast_ct                    m1_rating_ct  \\\n",
       "0           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "1           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "2           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "3           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "4           [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                               ...                             ...   \n",
       "75520    [60.0, nan, 33.3, nan, 53.3]     [0.6, nan, 0.33, nan, 0.65]   \n",
       "75521  [73.3, 73.3, 93.3, 80.0, 80.0]   [0.81, 1.07, 1.94, 1.4, 1.28]   \n",
       "75522  [83.3, 83.3, 50.0, 83.3, 58.3]   [1.08, 1.1, 0.82, 1.59, 0.75]   \n",
       "75523  [37.5, 62.5, 62.5, 50.0, 37.5]  [0.23, 0.75, 0.73, 0.35, 0.68]   \n",
       "75524  [80.0, 86.7, 86.7, 80.0, 73.3]  [1.18, 1.33, 1.46, 1.28, 0.84]   \n",
       "\n",
       "                         m1_kills_t                     m1_deaths_t  \\\n",
       "0         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "1         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "2         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "3         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "4         [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                             ...                             ...   \n",
       "75520     [1.0, nan, 1.0, nan, 1.0]       [3.0, nan, 3.0, nan, 3.0]   \n",
       "75521    [6.0, 8.0, 2.0, 12.0, 9.0]     [10.0, 10.0, 8.0, 9.0, 8.0]   \n",
       "75522   [7.0, 8.0, 11.0, 11.0, 6.0]  [12.0, 14.0, 13.0, 12.0, 13.0]   \n",
       "75523  [10.0, 4.0, 15.0, 11.0, 6.0]  [12.0, 13.0, 10.0, 11.0, 13.0]   \n",
       "75524    [6.0, 16.0, 4.0, 5.0, 4.0]       [4.0, 3.0, 7.0, 4.0, 2.0]   \n",
       "\n",
       "                          m1_kddiff_t                         m1_adr_t  \\\n",
       "0           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "1           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "2           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "3           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "4           [nan, nan, nan, nan, nan]        [nan, nan, nan, nan, nan]   \n",
       "...                               ...                              ...   \n",
       "75520    [-2.0, nan, -2.0, nan, -2.0]     [12.3, nan, 45.0, nan, 81.7]   \n",
       "75521    [-4.0, -2.0, -6.0, 3.0, 1.0]  [51.0, 80.8, 22.0, 105.7, 84.2]   \n",
       "75522  [-5.0, -6.0, -2.0, -1.0, -7.0]   [65.3, 67.8, 66.1, 80.2, 61.8]   \n",
       "75523    [-2.0, -9.0, 5.0, 0.0, -7.0]  [67.4, 39.6, 102.1, 82.2, 48.0]   \n",
       "75524     [2.0, 13.0, -3.0, 1.0, 2.0]  [66.4, 199.6, 62.6, 76.4, 46.5]   \n",
       "\n",
       "                             m1_kast_t                     m1_rating_t  \\\n",
       "0            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "1            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "2            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "3            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "4            [nan, nan, nan, nan, nan]       [nan, nan, nan, nan, nan]   \n",
       "...                                ...                             ...   \n",
       "75520     [33.3, nan, 33.3, nan, 66.7]    [0.14, nan, 0.27, nan, 0.56]   \n",
       "75521   [66.7, 83.3, 50.0, 75.0, 83.3]   [0.88, 1.1, 0.45, 1.56, 1.37]   \n",
       "75522   [53.3, 66.7, 66.7, 60.0, 86.7]   [0.7, 0.93, 0.87, 1.01, 0.85]   \n",
       "75523   [60.0, 40.0, 80.0, 66.7, 53.3]  [0.83, 0.46, 1.37, 1.19, 0.61]   \n",
       "75524  [75.0, 100.0, 50.0, 87.5, 87.5]  [1.44, 3.36, 0.72, 1.29, 1.05]   \n",
       "\n",
       "                     m2_kills_ct               m2_deaths_ct  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                    m2_kddiff_ct                  m2_adr_ct  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                      m2_kast_ct               m2_rating_ct  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                      m2_kills_t                m2_deaths_t  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                     m2_kddiff_t                   m2_adr_t  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                       m2_kast_t                m2_rating_t  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                     m3_kills_ct               m3_deaths_ct  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                    m3_kddiff_ct                  m3_adr_ct  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                      m3_kast_ct               m3_rating_ct  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                      m3_kills_t                m3_deaths_t  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                     m3_kddiff_t                   m3_adr_t  \\\n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "...                          ...                        ...   \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]   \n",
       "\n",
       "                       m3_kast_t                m3_rating_t  \n",
       "0      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "1      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "2      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "3      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "4      [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "...                          ...                        ...  \n",
       "75520  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "75521  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "75522  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "75523  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "75524  [nan, nan, nan, nan, nan]  [nan, nan, nan, nan, nan]  \n",
       "\n",
       "[75525 rows x 100 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_play['uid']  = df_play['match_id'].astype(str) + '_' + df_play['team_mapped'].astype(str)\n",
    "df_grouped_play = df_play.groupby(['uid'], as_index=False).agg({\n",
    "    'date': lambda x: x.iloc[0],\n",
    "    'team_mapped' : lambda x: x.iloc[0],\n",
    "    'opponent_mapped' : lambda x: x.iloc[0],\n",
    "    'country_mapped' : lambda x: list(x),\n",
    "    'player_id' : lambda x: list(x),\n",
    "    'match_id' : lambda x: x.iloc[0],\n",
    "    'event_id' : lambda x: x.iloc[0],\n",
    "    'best_of' : lambda x: x.iloc[0],\n",
    "    'map_1_mapped' : lambda x: x.iloc[0],\n",
    "    'map_2_mapped' : lambda x: x.iloc[0],\n",
    "    'map_3_mapped' : lambda x: x.iloc[0],\n",
    "    'kills' : lambda x: list(x),\n",
    "    'assists' : lambda x: list(x),\n",
    "    'deaths' : lambda x: list(x),\n",
    "    'hs' : lambda x: list(x),\n",
    "    'flash_assists' : lambda x: list(x),\n",
    "    'kast' : lambda x: list(x),\n",
    "    'kddiff' : lambda x: list(x),\n",
    "    'adr' : lambda x: list(x),\n",
    "    'fkdiff' : lambda x: list(x),\n",
    "    'rating' : lambda x: list(x),\n",
    "    'm1_kills' : lambda x: list(x),\n",
    "    'm1_assists' : lambda x: list(x),\n",
    "    'm1_deaths' : lambda x: list(x),\n",
    "    'm1_hs' : lambda x: list(x),\n",
    "    'm1_flash_assists' : lambda x: list(x),\n",
    "    'm1_kast' : lambda x: list(x),\n",
    "    'm1_kddiff' : lambda x: list(x),\n",
    "    'm1_adr' : lambda x: list(x),\n",
    "    'm1_fkdiff' : lambda x: list(x),\n",
    "    'm1_rating' : lambda x: list(x),\n",
    "    \n",
    "    'm2_kills' : lambda x: list(x),\n",
    "    'm2_assists' : lambda x: list(x),\n",
    "    'm2_deaths' : lambda x: list(x),\n",
    "    'm2_hs' : lambda x: list(x),\n",
    "    'm2_flash_assists' : lambda x: list(x),\n",
    "    'm2_kast' : lambda x: list(x),\n",
    "    'm2_kddiff' : lambda x: list(x),\n",
    "    'm2_adr' : lambda x: list(x),\n",
    "    'm2_fkdiff' : lambda x: list(x),\n",
    "    'm2_rating' : lambda x: list(x),\n",
    "\n",
    "    'm3_kills' : lambda x: list(x),\n",
    "    'm3_assists' : lambda x: list(x),\n",
    "    'm3_deaths' : lambda x: list(x),\n",
    "    'm3_hs' : lambda x: list(x),\n",
    "    'm3_flash_assists' : lambda x: list(x),\n",
    "    'm3_kast' : lambda x: list(x),\n",
    "    'm3_kddiff' : lambda x: list(x),\n",
    "    'm3_adr' : lambda x: list(x),\n",
    "    'm3_fkdiff' : lambda x: list(x),\n",
    "    'm3_rating' : lambda x: list(x),\n",
    "    \n",
    "    'kills_ct' : lambda x: list(x),\n",
    "    'deaths_ct' : lambda x: list(x),\n",
    "    'kddiff_ct' : lambda x: list(x),\n",
    "    'adr_ct' : lambda x: list(x),\n",
    "    'kast_ct' : lambda x: list(x),\n",
    "    'rating_ct' : lambda x: list(x),\n",
    "\n",
    "    'kills_t' : lambda x: list(x),\n",
    "    'deaths_t' : lambda x: list(x),\n",
    "    'kddiff_t' : lambda x: list(x),\n",
    "    'adr_t' : lambda x: list(x),\n",
    "    'kast_t' : lambda x: list(x),\n",
    "    'rating_t' : lambda x: list(x),\n",
    "\n",
    "    'm1_kills_ct' : lambda x: list(x),\n",
    "    'm1_deaths_ct' : lambda x: list(x),\n",
    "    'm1_kddiff_ct' : lambda x: list(x),\n",
    "    'm1_adr_ct' : lambda x: list(x),\n",
    "    'm1_kast_ct' : lambda x: list(x),\n",
    "    'm1_rating_ct' : lambda x: list(x),\n",
    "    'm1_kills_t' : lambda x: list(x),\n",
    "    'm1_deaths_t' : lambda x: list(x),\n",
    "    'm1_kddiff_t' : lambda x: list(x),\n",
    "    'm1_adr_t' : lambda x: list(x),\n",
    "    'm1_kast_t' : lambda x: list(x),\n",
    "    'm1_rating_t' : lambda x: list(x),\n",
    "\n",
    "    'm2_kills_ct' : lambda x: list(x),\n",
    "    'm2_deaths_ct' : lambda x: list(x),\n",
    "    'm2_kddiff_ct' : lambda x: list(x),\n",
    "    'm2_adr_ct' : lambda x: list(x),\n",
    "    'm2_kast_ct' : lambda x: list(x),\n",
    "    'm2_rating_ct' : lambda x: list(x),\n",
    "    'm2_kills_t' : lambda x: list(x),\n",
    "    'm2_deaths_t' : lambda x: list(x),\n",
    "    'm2_kddiff_t' : lambda x: list(x),\n",
    "    'm2_adr_t' : lambda x: list(x),\n",
    "    'm2_kast_t' : lambda x: list(x),\n",
    "    'm2_rating_t' : lambda x: list(x),\n",
    "\n",
    "    'm3_kills_ct' : lambda x: list(x),\n",
    "    'm3_deaths_ct' : lambda x: list(x),\n",
    "    'm3_kddiff_ct' : lambda x: list(x),\n",
    "    'm3_adr_ct' : lambda x: list(x),\n",
    "    'm3_kast_ct' : lambda x: list(x),\n",
    "    'm3_rating_ct' : lambda x: list(x),\n",
    "    'm3_kills_t' : lambda x: list(x),\n",
    "    'm3_deaths_t' : lambda x: list(x),\n",
    "    'm3_kddiff_t' : lambda x: list(x),\n",
    "    'm3_adr_t' : lambda x: list(x),\n",
    "    'm3_kast_t' : lambda x: list(x),\n",
    "    'm3_rating_t' : lambda x: list(x),\n",
    "\n",
    "\n",
    "\n",
    "})\n",
    "\n",
    "# # Rename the columns to indicate that they contain lists of values\n",
    "# df_merged_res = df_merged_res.rename(columns={\n",
    "#     'result_1': 'results_1',\n",
    "#     'result_2': 'results_2',\n",
    "#     'ct_1': 'cts_1',\n",
    "#     't_2': 'ts_2',\n",
    "#     't_1': 'ts_1',\n",
    "#     'ct_2': 'cts_2'\n",
    "# })\n",
    "\n",
    "# Reset the index\n",
    "df_grouped_play = df_grouped_play.reset_index(drop=True)\n",
    "df_grouped_play\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# # df_merge\n",
    "# corr = df_merge.corr()\n",
    "# plt.figure(figsize=(50,50))\n",
    "# sns.heatmap(corr,cmap='coolwarm',annot=True, fmt='.2f')\n",
    "# plt.show()\n",
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.11"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}