risk-level.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "import json\n",
    "import time\n",
    "import datetime\n",
    "from importlib import reload\n",
    "\n",
    "import requests\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.cluster import DBSCAN\n",
    "\n",
    "import external as ext"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "desert_main = pd.read_csv('miramar.csv')\n",
    "baltic_main = pd.read_csv('erangel.csv')\n",
    "savage_main = pd.read_csv('sanhok.csv')\n",
    "summerland_main = pd.read_csv('karakin.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "desert_main = desert_main.iloc[:,1:]\n",
    "baltic_main = baltic_main.iloc[:,1:]\n",
    "savage_main = savage_main.iloc[:,1:]\n",
    "summerland_main = summerland_main.iloc[:,1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "def risklevel(x,y,mapname):\n",
    "    if mapname == 'Desert_Main':\n",
    "        try:\n",
    "            risk = desert_main.iloc[y,x]\n",
    "        except:\n",
    "            risk = 0\n",
    "    elif mapname == 'Baltic_Main':\n",
    "        try:\n",
    "            risk = baltic_main.iloc[y,x] \n",
    "        except:\n",
    "            risk = 0\n",
    "    elif mapname == 'Savage_Main':\n",
    "        try:\n",
    "            risk = savage_main.iloc[y,x] \n",
    "        except:\n",
    "            risk = 0\n",
    "    elif mapname == 'Summerland_Main':\n",
    "        try:\n",
    "            risk = summerland_main.iloc[y,x]\n",
    "        except:\n",
    "            risk = 0\n",
    "        # correction due to lower max number of players\n",
    "        risk = risk * 1,5625\n",
    "    lst.append(risk)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# <font color=red> Preparing DataFrame </font>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# RUN THIS CELL TO WORK WITH THE FILE UPLOADED IN THE REPOSITORY\n",
    "# read files extracted from this as DataFrame\n",
    "with open('telemetry_data/2020-04-09/pc/4c76d82b-90f7-4fd1-9ceb-97b99347e94e.json', 'r') as file:\n",
    "    json_data = file.read()\n",
    "    file.close()\n",
    "data = []\n",
    "head = []\n",
    "for i in json.loads(json_data):\n",
    "    if i[\"_T\"] in (\"LogPlayerPosition\", \"LogParachuteLanding\"):\n",
    "        data.append(i)\n",
    "    if i[\"_T\"] in (\"LogMatchStart\"):\n",
    "        head.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": false
   },
   "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>_D</th>\n",
       "      <th>_T</th>\n",
       "      <th>character</th>\n",
       "      <th>common</th>\n",
       "      <th>distance</th>\n",
       "      <th>elapsedTime</th>\n",
       "      <th>numAlivePlayers</th>\n",
       "      <th>vehicle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-08T22:33:24.153Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'Wenurous', 'teamId': 4, 'health': 10...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'STSSEVEN', 'teamId': 11, 'health': 1...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'OMGNOWAYTHATSBS', 'teamId': 8, 'heal...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'LOCKLOAD007', 'teamId': 8, 'health':...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'Cadenn', 'teamId': 7, 'health': 100,...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         _D                 _T  \\\n",
       "0  2020-04-08T22:33:24.153Z  LogPlayerPosition   \n",
       "1  2020-04-08T22:33:24.220Z  LogPlayerPosition   \n",
       "2  2020-04-08T22:33:24.220Z  LogPlayerPosition   \n",
       "3  2020-04-08T22:33:24.287Z  LogPlayerPosition   \n",
       "4  2020-04-08T22:33:24.287Z  LogPlayerPosition   \n",
       "\n",
       "                                           character         common  distance  \\\n",
       "0  {'name': 'Wenurous', 'teamId': 4, 'health': 10...  {'isGame': 0}       NaN   \n",
       "1  {'name': 'STSSEVEN', 'teamId': 11, 'health': 1...  {'isGame': 0}       NaN   \n",
       "2  {'name': 'OMGNOWAYTHATSBS', 'teamId': 8, 'heal...  {'isGame': 0}       NaN   \n",
       "3  {'name': 'LOCKLOAD007', 'teamId': 8, 'health':...  {'isGame': 0}       NaN   \n",
       "4  {'name': 'Cadenn', 'teamId': 7, 'health': 100,...  {'isGame': 0}       NaN   \n",
       "\n",
       "   elapsedTime  numAlivePlayers vehicle  \n",
       "0          0.0             50.0    None  \n",
       "1          0.0             50.0    None  \n",
       "2          0.0             50.0    None  \n",
       "3          0.0             50.0    None  \n",
       "4          0.0             50.0    None  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get events data into pandas dataframe\n",
    "data = pd.read_json(json.dumps(data))\n",
    "head = pd.read_json(json.dumps(head))\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# get map name\n",
    "mn = head.loc[0, 'mapName']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": false
   },
   "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>_D</th>\n",
       "      <th>_T</th>\n",
       "      <th>character</th>\n",
       "      <th>common</th>\n",
       "      <th>distance</th>\n",
       "      <th>elapsedTime</th>\n",
       "      <th>numAlivePlayers</th>\n",
       "      <th>vehicle</th>\n",
       "      <th>MatchId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-08T22:33:24.153Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'Wenurous', 'teamId': 4, 'health': 10...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'STSSEVEN', 'teamId': 11, 'health': 1...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'OMGNOWAYTHATSBS', 'teamId': 8, 'heal...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'LOCKLOAD007', 'teamId': 8, 'health':...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'name': 'Cadenn', 'teamId': 7, 'health': 100,...</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         _D                 _T  \\\n",
       "0  2020-04-08T22:33:24.153Z  LogPlayerPosition   \n",
       "1  2020-04-08T22:33:24.220Z  LogPlayerPosition   \n",
       "2  2020-04-08T22:33:24.220Z  LogPlayerPosition   \n",
       "3  2020-04-08T22:33:24.287Z  LogPlayerPosition   \n",
       "4  2020-04-08T22:33:24.287Z  LogPlayerPosition   \n",
       "\n",
       "                                           character         common  distance  \\\n",
       "0  {'name': 'Wenurous', 'teamId': 4, 'health': 10...  {'isGame': 0}       NaN   \n",
       "1  {'name': 'STSSEVEN', 'teamId': 11, 'health': 1...  {'isGame': 0}       NaN   \n",
       "2  {'name': 'OMGNOWAYTHATSBS', 'teamId': 8, 'heal...  {'isGame': 0}       NaN   \n",
       "3  {'name': 'LOCKLOAD007', 'teamId': 8, 'health':...  {'isGame': 0}       NaN   \n",
       "4  {'name': 'Cadenn', 'teamId': 7, 'health': 100,...  {'isGame': 0}       NaN   \n",
       "\n",
       "   elapsedTime  numAlivePlayers vehicle  \\\n",
       "0          0.0             50.0    None   \n",
       "1          0.0             50.0    None   \n",
       "2          0.0             50.0    None   \n",
       "3          0.0             50.0    None   \n",
       "4          0.0             50.0    None   \n",
       "\n",
       "                                             MatchId  \n",
       "0  match.bro.official.pc-2018-06.steam.squad.na.2...  \n",
       "1  match.bro.official.pc-2018-06.steam.squad.na.2...  \n",
       "2  match.bro.official.pc-2018-06.steam.squad.na.2...  \n",
       "3  match.bro.official.pc-2018-06.steam.squad.na.2...  \n",
       "4  match.bro.official.pc-2018-06.steam.squad.na.2...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# copy match id to all rows and drop LogMatchDefinition event\n",
    "# we will use this later to add use it for future merging tasks\n",
    "matchid = json.loads(json_data)[0][\"MatchId\"]\n",
    "data['MatchId'] = matchid\n",
    "\n",
    "#reset indexes\n",
    "data.reset_index(drop=True, inplace=True)\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['_D', '_T', 'character', 'common', 'distance', 'elapsedTime',\n",
       "       'numAlivePlayers', 'vehicle', 'MatchId'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Extracting Player information variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>_D</th>\n",
       "      <th>_T</th>\n",
       "      <th>common</th>\n",
       "      <th>distance</th>\n",
       "      <th>elapsedTime</th>\n",
       "      <th>numAlivePlayers</th>\n",
       "      <th>vehicle</th>\n",
       "      <th>MatchId</th>\n",
       "      <th>accountId</th>\n",
       "      <th>health</th>\n",
       "      <th>isInBlueZone</th>\n",
       "      <th>isInRedZone</th>\n",
       "      <th>location.x</th>\n",
       "      <th>location.y</th>\n",
       "      <th>location.z</th>\n",
       "      <th>name</th>\n",
       "      <th>ranking</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-08T22:33:24.153Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.534e426ebc5643d781264f68e02f8adb</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>84096.40625</td>\n",
       "      <td>730290.9375</td>\n",
       "      <td>5105.000000</td>\n",
       "      <td>Wenurous</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.c57f3b1dd9484b238b44a68f3321dfd2</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>718799.81250</td>\n",
       "      <td>546016.3125</td>\n",
       "      <td>-620.969971</td>\n",
       "      <td>STSSEVEN</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.54a138a899ea43919a51de65323d9287</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>491143.65625</td>\n",
       "      <td>634140.8750</td>\n",
       "      <td>12665.149414</td>\n",
       "      <td>OMGNOWAYTHATSBS</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.749c1f3bc22841ccb17fd9aa3e65bccf</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>490809.96875</td>\n",
       "      <td>634214.4375</td>\n",
       "      <td>12665.154297</td>\n",
       "      <td>LOCKLOAD007</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>{'isGame': 0}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.fa20a446eea64586b4033135908d921a</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>718356.50000</td>\n",
       "      <td>546602.7500</td>\n",
       "      <td>-701.961487</td>\n",
       "      <td>Cadenn</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         _D                 _T         common  distance  \\\n",
       "0  2020-04-08T22:33:24.153Z  LogPlayerPosition  {'isGame': 0}       NaN   \n",
       "1  2020-04-08T22:33:24.220Z  LogPlayerPosition  {'isGame': 0}       NaN   \n",
       "2  2020-04-08T22:33:24.220Z  LogPlayerPosition  {'isGame': 0}       NaN   \n",
       "3  2020-04-08T22:33:24.287Z  LogPlayerPosition  {'isGame': 0}       NaN   \n",
       "4  2020-04-08T22:33:24.287Z  LogPlayerPosition  {'isGame': 0}       NaN   \n",
       "\n",
       "   elapsedTime  numAlivePlayers vehicle  \\\n",
       "0          0.0             50.0    None   \n",
       "1          0.0             50.0    None   \n",
       "2          0.0             50.0    None   \n",
       "3          0.0             50.0    None   \n",
       "4          0.0             50.0    None   \n",
       "\n",
       "                                             MatchId  \\\n",
       "0  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "1  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "2  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "3  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "4  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "\n",
       "                                  accountId  health  isInBlueZone  \\\n",
       "0  account.534e426ebc5643d781264f68e02f8adb   100.0         False   \n",
       "1  account.c57f3b1dd9484b238b44a68f3321dfd2   100.0         False   \n",
       "2  account.54a138a899ea43919a51de65323d9287   100.0         False   \n",
       "3  account.749c1f3bc22841ccb17fd9aa3e65bccf   100.0         False   \n",
       "4  account.fa20a446eea64586b4033135908d921a   100.0         False   \n",
       "\n",
       "   isInRedZone    location.x   location.y    location.z             name  \\\n",
       "0        False   84096.40625  730290.9375   5105.000000         Wenurous   \n",
       "1        False  718799.81250  546016.3125   -620.969971         STSSEVEN   \n",
       "2        False  491143.65625  634140.8750  12665.149414  OMGNOWAYTHATSBS   \n",
       "3        False  490809.96875  634214.4375  12665.154297      LOCKLOAD007   \n",
       "4        False  718356.50000  546602.7500   -701.961487           Cadenn   \n",
       "\n",
       "   ranking  teamId  \n",
       "0        0       4  \n",
       "1        0      11  \n",
       "2        0       8  \n",
       "3        0       8  \n",
       "4        0       7  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get player information\n",
    "from pandas.io.json import json_normalize\n",
    "# we need to expand the json documents on the character column\n",
    "data = pd.concat([data, json_normalize(data['character'])], axis=1).drop(['character', 'zone'], axis=1)\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Set isGame variable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def isGame(x):\n",
    "    return x['isGame']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_D</th>\n",
       "      <th>_T</th>\n",
       "      <th>distance</th>\n",
       "      <th>elapsedTime</th>\n",
       "      <th>numAlivePlayers</th>\n",
       "      <th>vehicle</th>\n",
       "      <th>MatchId</th>\n",
       "      <th>accountId</th>\n",
       "      <th>health</th>\n",
       "      <th>isInBlueZone</th>\n",
       "      <th>isInRedZone</th>\n",
       "      <th>location.x</th>\n",
       "      <th>location.y</th>\n",
       "      <th>location.z</th>\n",
       "      <th>name</th>\n",
       "      <th>ranking</th>\n",
       "      <th>teamId</th>\n",
       "      <th>isGame</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-08T22:33:24.153Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.534e426ebc5643d781264f68e02f8adb</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>84096.40625</td>\n",
       "      <td>730290.9375</td>\n",
       "      <td>5105.000000</td>\n",
       "      <td>Wenurous</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.c57f3b1dd9484b238b44a68f3321dfd2</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>718799.81250</td>\n",
       "      <td>546016.3125</td>\n",
       "      <td>-620.969971</td>\n",
       "      <td>STSSEVEN</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-04-08T22:33:24.220Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.54a138a899ea43919a51de65323d9287</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>491143.65625</td>\n",
       "      <td>634140.8750</td>\n",
       "      <td>12665.149414</td>\n",
       "      <td>OMGNOWAYTHATSBS</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.749c1f3bc22841ccb17fd9aa3e65bccf</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>490809.96875</td>\n",
       "      <td>634214.4375</td>\n",
       "      <td>12665.154297</td>\n",
       "      <td>LOCKLOAD007</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-04-08T22:33:24.287Z</td>\n",
       "      <td>LogPlayerPosition</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>account.fa20a446eea64586b4033135908d921a</td>\n",
       "      <td>100.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>718356.50000</td>\n",
       "      <td>546602.7500</td>\n",
       "      <td>-701.961487</td>\n",
       "      <td>Cadenn</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         _D                 _T  distance  elapsedTime  \\\n",
       "0  2020-04-08T22:33:24.153Z  LogPlayerPosition       NaN          0.0   \n",
       "1  2020-04-08T22:33:24.220Z  LogPlayerPosition       NaN          0.0   \n",
       "2  2020-04-08T22:33:24.220Z  LogPlayerPosition       NaN          0.0   \n",
       "3  2020-04-08T22:33:24.287Z  LogPlayerPosition       NaN          0.0   \n",
       "4  2020-04-08T22:33:24.287Z  LogPlayerPosition       NaN          0.0   \n",
       "\n",
       "   numAlivePlayers vehicle                                            MatchId  \\\n",
       "0             50.0    None  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "1             50.0    None  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "2             50.0    None  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "3             50.0    None  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "4             50.0    None  match.bro.official.pc-2018-06.steam.squad.na.2...   \n",
       "\n",
       "                                  accountId  health  isInBlueZone  \\\n",
       "0  account.534e426ebc5643d781264f68e02f8adb   100.0         False   \n",
       "1  account.c57f3b1dd9484b238b44a68f3321dfd2   100.0         False   \n",
       "2  account.54a138a899ea43919a51de65323d9287   100.0         False   \n",
       "3  account.749c1f3bc22841ccb17fd9aa3e65bccf   100.0         False   \n",
       "4  account.fa20a446eea64586b4033135908d921a   100.0         False   \n",
       "\n",
       "   isInRedZone    location.x   location.y    location.z             name  \\\n",
       "0        False   84096.40625  730290.9375   5105.000000         Wenurous   \n",
       "1        False  718799.81250  546016.3125   -620.969971         STSSEVEN   \n",
       "2        False  491143.65625  634140.8750  12665.149414  OMGNOWAYTHATSBS   \n",
       "3        False  490809.96875  634214.4375  12665.154297      LOCKLOAD007   \n",
       "4        False  718356.50000  546602.7500   -701.961487           Cadenn   \n",
       "\n",
       "   ranking  teamId  isGame  \n",
       "0        0       4     0.0  \n",
       "1        0      11     0.0  \n",
       "2        0       8     0.0  \n",
       "3        0       8     0.0  \n",
       "4        0       7     0.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['isGame'] = data['common'].apply(isGame)\n",
    "data = data.drop('common', axis=1)\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# we will use the vehicle to check what players are still in the airplane\n",
    "data.vehicle = data.vehicle.apply(lambda x: {} if pd.isna(x) else x)\n",
    "data['vehicle'] = json_normalize(data.vehicle)['vehicleType']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Interpolate players location for all elapsed times"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.0 has 680 observations\n",
      "1.0 has 21 observations\n",
      "2.0 has 13 observations\n",
      "3.0 has 5 observations\n",
      "4.0 has 5 observations\n",
      "5.0 has 7 observations\n",
      "6.0 has 7 observations\n",
      "7.0 has 1 observations\n",
      "8.0 has 1 observations\n",
      "9.0 has 6 observations\n",
      "10.0 has 14 observations\n",
      "11.0 has 22 observations\n",
      "12.0 has 8 observations\n",
      "13.0 has 5 observations\n",
      "14.0 has 6 observations\n",
      "15.0 has 6 observations\n",
      "16.0 has 7 observations\n",
      "17.0 has 1 observations\n",
      "18.0 has 1 observations\n",
      "19.0 has 6 observations\n",
      "20.0 has 15 observations\n",
      "21.0 has 22 observations\n",
      "22.0 has 7 observations\n",
      "23.0 has 6 observations\n",
      "24.0 has 6 observations\n",
      "25.0 has 5 observations\n",
      "26.0 has 7 observations\n",
      "27.0 has 1 observations\n",
      "28.0 has 1 observations\n",
      "29.0 has 7 observations\n",
      "30.0 has 15 observations\n",
      "31.0 has 21 observations\n",
      "32.0 has 8 observations\n",
      "33.0 has 5 observations\n",
      "34.0 has 9 observations\n",
      "35.0 has 4 observations\n",
      "36.0 has 5 observations\n",
      "37.0 has 1 observations\n",
      "38.0 has 3 observations\n",
      "39.0 has 6 observations\n",
      "40.0 has 17 observations\n",
      "41.0 has 19 observations\n",
      "42.0 has 8 observations\n",
      "43.0 has 4 observations\n",
      "44.0 has 9 observations\n",
      "45.0 has 5 observations\n",
      "46.0 has 4 observations\n",
      "47.0 has 1 observations\n",
      "48.0 has 3 observations\n",
      "49.0 has 9 observations\n",
      "50.0 has 19 observations\n",
      "51.0 has 15 observations\n",
      "52.0 has 7 observations\n",
      "53.0 has 4 observations\n",
      "54.0 has 10 observations\n",
      "55.0 has 5 observations\n",
      "56.0 has 3 observations\n",
      "57.0 has 1 observations\n",
      "58.0 has 3 observations\n",
      "59.0 has 9 observations\n",
      "60.0 has 22 observations\n",
      "nan has 0 observations\n",
      "61.0 has 14 observations\n",
      "62.0 has 6 observations\n",
      "63.0 has 4 observations\n",
      "64.0 has 9 observations\n",
      "65.0 has 5 observations\n",
      "66.0 has 3 observations\n",
      "67.0 has 1 observations\n",
      "68.0 has 4 observations\n",
      "69.0 has 9 observations\n",
      "70.0 has 21 observations\n",
      "71.0 has 15 observations\n",
      "72.0 has 5 observations\n",
      "73.0 has 4 observations\n",
      "74.0 has 10 observations\n",
      "75.0 has 6 observations\n",
      "76.0 has 2 observations\n",
      "78.0 has 5 observations\n",
      "79.0 has 12 observations\n",
      "80.0 has 20 observations\n",
      "81.0 has 13 observations\n",
      "82.0 has 6 observations\n",
      "83.0 has 4 observations\n",
      "84.0 has 8 observations\n",
      "85.0 has 7 observations\n",
      "86.0 has 1 observations\n",
      "88.0 has 5 observations\n",
      "89.0 has 13 observations\n",
      "90.0 has 20 observations\n",
      "91.0 has 13 observations\n",
      "92.0 has 5 observations\n",
      "93.0 has 5 observations\n",
      "94.0 has 7 observations\n",
      "95.0 has 7 observations\n",
      "96.0 has 1 observations\n",
      "97.0 has 1 observations\n",
      "98.0 has 6 observations\n",
      "99.0 has 12 observations\n",
      "100.0 has 24 observations\n",
      "101.0 has 8 observations\n",
      "102.0 has 6 observations\n",
      "103.0 has 5 observations\n",
      "104.0 has 6 observations\n",
      "105.0 has 7 observations\n",
      "106.0 has 1 observations\n",
      "107.0 has 1 observations\n",
      "108.0 has 6 observations\n",
      "109.0 has 15 observations\n",
      "110.0 has 22 observations\n",
      "111.0 has 7 observations\n",
      "112.0 has 6 observations\n",
      "113.0 has 8 observations\n",
      "114.0 has 3 observations\n",
      "115.0 has 7 observations\n",
      "116.0 has 1 observations\n",
      "117.0 has 2 observations\n",
      "118.0 has 6 observations\n",
      "119.0 has 17 observations\n",
      "120.0 has 19 observations\n",
      "121.0 has 8 observations\n",
      "122.0 has 5 observations\n",
      "123.0 has 9 observations\n",
      "124.0 has 4 observations\n",
      "125.0 has 5 observations\n",
      "126.0 has 1 observations\n",
      "127.0 has 3 observations\n",
      "128.0 has 9 observations\n",
      "129.0 has 16 observations\n",
      "130.0 has 16 observations\n",
      "131.0 has 7 observations\n",
      "132.0 has 4 observations\n",
      "133.0 has 10 observations\n",
      "134.0 has 4 observations\n",
      "135.0 has 4 observations\n",
      "136.0 has 1 observations\n",
      "137.0 has 3 observations\n",
      "138.0 has 9 observations\n",
      "139.0 has 19 observations\n",
      "140.0 has 15 observations\n",
      "141.0 has 5 observations\n",
      "142.0 has 4 observations\n",
      "143.0 has 10 observations\n",
      "144.0 has 5 observations\n",
      "145.0 has 3 observations\n",
      "146.0 has 1 observations\n",
      "147.0 has 3 observations\n",
      "148.0 has 9 observations\n",
      "149.0 has 21 observations\n",
      "150.0 has 12 observations\n",
      "151.0 has 6 observations\n",
      "152.0 has 3 observations\n",
      "153.0 has 10 observations\n",
      "154.0 has 5 observations\n",
      "155.0 has 3 observations\n",
      "156.0 has 1 observations\n",
      "157.0 has 4 observations\n",
      "158.0 has 9 observations\n",
      "159.0 has 19 observations\n",
      "160.0 has 12 observations\n",
      "161.0 has 6 observations\n",
      "162.0 has 4 observations\n",
      "163.0 has 10 observations\n",
      "164.0 has 4 observations\n",
      "165.0 has 3 observations\n",
      "166.0 has 1 observations\n",
      "167.0 has 4 observations\n",
      "168.0 has 11 observations\n",
      "169.0 has 19 observations\n",
      "170.0 has 11 observations\n",
      "171.0 has 6 observations\n",
      "172.0 has 5 observations\n",
      "173.0 has 8 observations\n",
      "174.0 has 5 observations\n",
      "175.0 has 2 observations\n",
      "177.0 has 5 observations\n",
      "178.0 has 13 observations\n",
      "179.0 has 17 observations\n",
      "180.0 has 12 observations\n",
      "181.0 has 5 observations\n",
      "182.0 has 4 observations\n",
      "183.0 has 7 observations\n",
      "184.0 has 6 observations\n",
      "185.0 has 1 observations\n",
      "187.0 has 5 observations\n",
      "188.0 has 13 observations\n",
      "189.0 has 19 observations\n",
      "190.0 has 10 observations\n",
      "191.0 has 5 observations\n",
      "192.0 has 6 observations\n",
      "193.0 has 5 observations\n",
      "194.0 has 6 observations\n",
      "195.0 has 1 observations\n",
      "196.0 has 1 observations\n",
      "197.0 has 6 observations\n",
      "198.0 has 14 observations\n",
      "199.0 has 19 observations\n",
      "200.0 has 7 observations\n",
      "201.0 has 6 observations\n",
      "202.0 has 5 observations\n",
      "203.0 has 5 observations\n",
      "204.0 has 6 observations\n",
      "205.0 has 1 observations\n",
      "206.0 has 2 observations\n",
      "207.0 has 6 observations\n",
      "208.0 has 16 observations\n",
      "209.0 has 16 observations\n",
      "210.0 has 8 observations\n",
      "211.0 has 5 observations\n",
      "212.0 has 8 observations\n",
      "213.0 has 4 observations\n",
      "214.0 has 4 observations\n",
      "215.0 has 1 observations\n",
      "216.0 has 3 observations\n",
      "217.0 has 6 observations\n",
      "218.0 has 17 observations\n",
      "219.0 has 13 observations\n",
      "220.0 has 7 observations\n",
      "221.0 has 5 observations\n",
      "222.0 has 8 observations\n",
      "223.0 has 4 observations\n",
      "224.0 has 3 observations\n",
      "225.0 has 1 observations\n",
      "226.0 has 3 observations\n",
      "227.0 has 9 observations\n",
      "228.0 has 16 observations\n",
      "229.0 has 11 observations\n",
      "230.0 has 7 observations\n",
      "231.0 has 4 observations\n",
      "232.0 has 9 observations\n",
      "233.0 has 3 observations\n",
      "234.0 has 3 observations\n",
      "235.0 has 1 observations\n",
      "236.0 has 3 observations\n",
      "237.0 has 9 observations\n",
      "238.0 has 17 observations\n",
      "239.0 has 12 observations\n",
      "240.0 has 6 observations\n",
      "241.0 has 3 observations\n",
      "242.0 has 9 observations\n",
      "243.0 has 4 observations\n",
      "244.0 has 2 observations\n",
      "245.0 has 1 observations\n",
      "246.0 has 4 observations\n",
      "247.0 has 9 observations\n",
      "248.0 has 16 observations\n",
      "249.0 has 12 observations\n",
      "250.0 has 6 observations\n",
      "251.0 has 4 observations\n",
      "252.0 has 9 observations\n",
      "253.0 has 3 observations\n",
      "254.0 has 2 observations\n",
      "255.0 has 1 observations\n",
      "256.0 has 4 observations\n",
      "257.0 has 11 observations\n",
      "258.0 has 16 observations\n",
      "259.0 has 11 observations\n",
      "260.0 has 6 observations\n",
      "261.0 has 4 observations\n",
      "262.0 has 8 observations\n",
      "263.0 has 5 observations\n",
      "264.0 has 1 observations\n",
      "266.0 has 5 observations\n",
      "267.0 has 13 observations\n",
      "268.0 has 14 observations\n",
      "269.0 has 12 observations\n",
      "270.0 has 5 observations\n",
      "271.0 has 5 observations\n",
      "272.0 has 6 observations\n",
      "273.0 has 5 observations\n",
      "274.0 has 1 observations\n",
      "275.0 has 1 observations\n",
      "276.0 has 6 observations\n",
      "277.0 has 14 observations\n",
      "278.0 has 16 observations\n",
      "279.0 has 7 observations\n",
      "280.0 has 6 observations\n",
      "281.0 has 5 observations\n",
      "282.0 has 5 observations\n",
      "283.0 has 5 observations\n",
      "284.0 has 1 observations\n",
      "285.0 has 2 observations\n",
      "286.0 has 6 observations\n",
      "287.0 has 16 observations\n",
      "288.0 has 13 observations\n",
      "289.0 has 8 observations\n",
      "290.0 has 5 observations\n",
      "291.0 has 8 observations\n",
      "292.0 has 4 observations\n",
      "293.0 has 3 observations\n",
      "294.0 has 1 observations\n",
      "295.0 has 3 observations\n",
      "296.0 has 6 observations\n",
      "297.0 has 16 observations\n",
      "298.0 has 13 observations\n",
      "299.0 has 8 observations\n",
      "300.0 has 4 observations\n",
      "301.0 has 9 observations\n",
      "302.0 has 3 observations\n",
      "303.0 has 3 observations\n",
      "304.0 has 1 observations\n",
      "305.0 has 3 observations\n",
      "306.0 has 8 observations\n",
      "307.0 has 16 observations\n",
      "308.0 has 13 observations\n",
      "309.0 has 5 observations\n",
      "310.0 has 4 observations\n",
      "311.0 has 9 observations\n",
      "312.0 has 4 observations\n",
      "313.0 has 2 observations\n",
      "314.0 has 1 observations\n",
      "315.0 has 3 observations\n",
      "316.0 has 9 observations\n",
      "317.0 has 16 observations\n",
      "318.0 has 11 observations\n",
      "319.0 has 5 observations\n",
      "320.0 has 4 observations\n",
      "321.0 has 9 observations\n",
      "322.0 has 3 observations\n",
      "323.0 has 2 observations\n",
      "324.0 has 1 observations\n",
      "325.0 has 3 observations\n",
      "326.0 has 12 observations\n",
      "327.0 has 15 observations\n",
      "328.0 has 8 observations\n",
      "329.0 has 6 observations\n",
      "330.0 has 4 observations\n",
      "331.0 has 7 observations\n",
      "332.0 has 5 observations\n",
      "333.0 has 1 observations\n",
      "335.0 has 4 observations\n",
      "336.0 has 12 observations\n",
      "337.0 has 14 observations\n",
      "338.0 has 9 observations\n",
      "339.0 has 5 observations\n",
      "340.0 has 5 observations\n",
      "341.0 has 6 observations\n",
      "342.0 has 5 observations\n",
      "343.0 has 1 observations\n",
      "344.0 has 1 observations\n",
      "345.0 has 5 observations\n",
      "346.0 has 13 observations\n",
      "347.0 has 15 observations\n",
      "348.0 has 5 observations\n",
      "349.0 has 6 observations\n",
      "350.0 has 5 observations\n",
      "351.0 has 5 observations\n",
      "352.0 has 5 observations\n",
      "353.0 has 1 observations\n",
      "354.0 has 2 observations\n",
      "355.0 has 5 observations\n",
      "356.0 has 16 observations\n",
      "357.0 has 11 observations\n",
      "358.0 has 6 observations\n",
      "359.0 has 5 observations\n",
      "360.0 has 8 observations\n",
      "361.0 has 4 observations\n",
      "362.0 has 3 observations\n",
      "363.0 has 1 observations\n",
      "364.0 has 3 observations\n",
      "365.0 has 5 observations\n",
      "366.0 has 17 observations\n",
      "367.0 has 11 observations\n",
      "368.0 has 5 observations\n",
      "369.0 has 4 observations\n",
      "370.0 has 9 observations\n",
      "371.0 has 3 observations\n",
      "372.0 has 3 observations\n",
      "373.0 has 1 observations\n",
      "374.0 has 3 observations\n",
      "375.0 has 8 observations\n",
      "376.0 has 15 observations\n",
      "377.0 has 11 observations\n",
      "378.0 has 3 observations\n",
      "379.0 has 4 observations\n",
      "380.0 has 8 observations\n",
      "381.0 has 4 observations\n",
      "382.0 has 2 observations\n",
      "383.0 has 1 observations\n",
      "384.0 has 3 observations\n",
      "385.0 has 8 observations\n",
      "386.0 has 16 observations\n",
      "387.0 has 10 observations\n",
      "388.0 has 4 observations\n",
      "389.0 has 4 observations\n",
      "390.0 has 7 observations\n",
      "391.0 has 4 observations\n",
      "392.0 has 2 observations\n",
      "393.0 has 1 observations\n",
      "394.0 has 3 observations\n",
      "395.0 has 10 observations\n",
      "396.0 has 14 observations\n",
      "397.0 has 10 observations\n",
      "398.0 has 4 observations\n",
      "399.0 has 4 observations\n",
      "400.0 has 8 observations\n",
      "401.0 has 3 observations\n",
      "402.0 has 2 observations\n",
      "403.0 has 1 observations\n",
      "404.0 has 4 observations\n",
      "405.0 has 11 observations\n",
      "406.0 has 15 observations\n",
      "407.0 has 7 observations\n",
      "408.0 has 6 observations\n",
      "409.0 has 5 observations\n",
      "410.0 has 5 observations\n",
      "411.0 has 5 observations\n",
      "412.0 has 1 observations\n",
      "413.0 has 1 observations\n",
      "414.0 has 3 observations\n",
      "415.0 has 12 observations\n",
      "416.0 has 15 observations\n",
      "417.0 has 7 observations\n",
      "418.0 has 5 observations\n",
      "419.0 has 6 observations\n",
      "420.0 has 4 observations\n",
      "421.0 has 5 observations\n",
      "422.0 has 1 observations\n",
      "423.0 has 1 observations\n",
      "424.0 has 5 observations\n",
      "425.0 has 14 observations\n",
      "426.0 has 14 observations\n",
      "427.0 has 4 observations\n",
      "428.0 has 6 observations\n",
      "429.0 has 6 observations\n",
      "430.0 has 5 observations\n",
      "431.0 has 3 observations\n",
      "432.0 has 1 observations\n",
      "433.0 has 2 observations\n",
      "434.0 has 5 observations\n",
      "435.0 has 16 observations\n",
      "436.0 has 11 observations\n",
      "437.0 has 5 observations\n",
      "438.0 has 5 observations\n",
      "439.0 has 7 observations\n",
      "440.0 has 4 observations\n",
      "441.0 has 3 observations\n",
      "442.0 has 1 observations\n",
      "443.0 has 3 observations\n",
      "444.0 has 8 observations\n",
      "445.0 has 14 observations\n",
      "446.0 has 11 observations\n",
      "447.0 has 4 observations\n",
      "448.0 has 4 observations\n",
      "449.0 has 8 observations\n",
      "450.0 has 3 observations\n",
      "451.0 has 3 observations\n",
      "452.0 has 1 observations\n",
      "453.0 has 3 observations\n",
      "454.0 has 8 observations\n",
      "455.0 has 15 observations\n",
      "456.0 has 11 observations\n",
      "457.0 has 3 observations\n",
      "458.0 has 4 observations\n",
      "459.0 has 8 observations\n",
      "460.0 has 4 observations\n",
      "461.0 has 2 observations\n",
      "462.0 has 1 observations\n",
      "463.0 has 3 observations\n",
      "464.0 has 9 observations\n",
      "465.0 has 15 observations\n",
      "466.0 has 10 observations\n",
      "467.0 has 4 observations\n",
      "468.0 has 4 observations\n",
      "469.0 has 8 observations\n",
      "470.0 has 4 observations\n",
      "471.0 has 2 observations\n",
      "473.0 has 4 observations\n",
      "474.0 has 12 observations\n",
      "475.0 has 13 observations\n",
      "476.0 has 6 observations\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "477.0 has 6 observations\n",
      "478.0 has 4 observations\n",
      "479.0 has 6 observations\n",
      "480.0 has 5 observations\n",
      "481.0 has 1 observations\n",
      "482.0 has 1 observations\n",
      "483.0 has 5 observations\n",
      "484.0 has 10 observations\n",
      "485.0 has 14 observations\n",
      "486.0 has 6 observations\n",
      "487.0 has 5 observations\n",
      "488.0 has 6 observations\n",
      "489.0 has 4 observations\n",
      "490.0 has 5 observations\n",
      "491.0 has 1 observations\n",
      "492.0 has 1 observations\n",
      "493.0 has 5 observations\n",
      "494.0 has 15 observations\n",
      "495.0 has 12 observations\n",
      "496.0 has 4 observations\n",
      "497.0 has 4 observations\n",
      "498.0 has 6 observations\n",
      "499.0 has 5 observations\n",
      "500.0 has 3 observations\n",
      "501.0 has 1 observations\n",
      "502.0 has 3 observations\n",
      "503.0 has 5 observations\n",
      "504.0 has 15 observations\n",
      "505.0 has 11 observations\n",
      "506.0 has 3 observations\n",
      "507.0 has 4 observations\n",
      "508.0 has 7 observations\n",
      "509.0 has 4 observations\n",
      "510.0 has 3 observations\n",
      "511.0 has 1 observations\n",
      "512.0 has 3 observations\n",
      "513.0 has 8 observations\n",
      "514.0 has 15 observations\n",
      "515.0 has 9 observations\n",
      "516.0 has 3 observations\n",
      "517.0 has 3 observations\n",
      "518.0 has 8 observations\n",
      "519.0 has 4 observations\n",
      "520.0 has 2 observations\n",
      "521.0 has 1 observations\n",
      "522.0 has 3 observations\n",
      "523.0 has 8 observations\n",
      "524.0 has 16 observations\n",
      "525.0 has 8 observations\n",
      "526.0 has 3 observations\n",
      "527.0 has 2 observations\n",
      "528.0 has 8 observations\n",
      "529.0 has 4 observations\n",
      "530.0 has 2 observations\n",
      "531.0 has 1 observations\n",
      "532.0 has 3 observations\n",
      "533.0 has 8 observations\n",
      "534.0 has 16 observations\n",
      "535.0 has 7 observations\n",
      "536.0 has 3 observations\n",
      "537.0 has 3 observations\n",
      "538.0 has 8 observations\n",
      "539.0 has 3 observations\n",
      "540.0 has 2 observations\n",
      "541.0 has 1 observations\n",
      "542.0 has 3 observations\n",
      "543.0 has 12 observations\n",
      "544.0 has 14 observations\n",
      "545.0 has 5 observations\n",
      "546.0 has 4 observations\n",
      "547.0 has 4 observations\n",
      "548.0 has 6 observations\n",
      "549.0 has 4 observations\n",
      "550.0 has 2 observations\n",
      "552.0 has 4 observations\n",
      "553.0 has 12 observations\n",
      "554.0 has 13 observations\n",
      "555.0 has 6 observations\n",
      "556.0 has 3 observations\n",
      "557.0 has 5 observations\n",
      "558.0 has 5 observations\n",
      "559.0 has 5 observations\n",
      "560.0 has 1 observations\n",
      "561.0 has 1 observations\n",
      "562.0 has 5 observations\n",
      "563.0 has 10 observations\n",
      "564.0 has 14 observations\n",
      "565.0 has 5 observations\n",
      "566.0 has 3 observations\n",
      "567.0 has 6 observations\n",
      "568.0 has 4 observations\n",
      "569.0 has 5 observations\n",
      "570.0 has 1 observations\n",
      "571.0 has 1 observations\n",
      "572.0 has 5 observations\n",
      "573.0 has 14 observations\n",
      "574.0 has 12 observations\n",
      "575.0 has 2 observations\n",
      "576.0 has 4 observations\n",
      "577.0 has 5 observations\n",
      "578.0 has 4 observations\n",
      "579.0 has 5 observations\n",
      "580.0 has 1 observations\n",
      "581.0 has 1 observations\n",
      "582.0 has 6 observations\n",
      "583.0 has 15 observations\n",
      "584.0 has 10 observations\n",
      "585.0 has 3 observations\n",
      "586.0 has 3 observations\n",
      "587.0 has 7 observations\n",
      "588.0 has 4 observations\n",
      "589.0 has 3 observations\n",
      "590.0 has 1 observations\n",
      "591.0 has 3 observations\n",
      "592.0 has 8 observations\n",
      "593.0 has 14 observations\n",
      "594.0 has 8 observations\n",
      "595.0 has 3 observations\n",
      "596.0 has 2 observations\n",
      "597.0 has 8 observations\n",
      "598.0 has 3 observations\n",
      "599.0 has 3 observations\n",
      "600.0 has 1 observations\n",
      "601.0 has 3 observations\n",
      "602.0 has 8 observations\n",
      "603.0 has 15 observations\n",
      "604.0 has 7 observations\n",
      "605.0 has 3 observations\n",
      "606.0 has 2 observations\n",
      "607.0 has 8 observations\n",
      "608.0 has 4 observations\n",
      "609.0 has 2 observations\n",
      "610.0 has 1 observations\n",
      "611.0 has 3 observations\n",
      "612.0 has 12 observations\n",
      "613.0 has 13 observations\n",
      "614.0 has 5 observations\n",
      "615.0 has 4 observations\n",
      "616.0 has 4 observations\n",
      "617.0 has 6 observations\n",
      "618.0 has 5 observations\n",
      "619.0 has 1 observations\n",
      "621.0 has 4 observations\n",
      "622.0 has 12 observations\n",
      "623.0 has 12 observations\n",
      "624.0 has 6 observations\n",
      "625.0 has 3 observations\n",
      "626.0 has 5 observations\n",
      "627.0 has 5 observations\n",
      "628.0 has 5 observations\n",
      "629.0 has 1 observations\n",
      "630.0 has 1 observations\n",
      "631.0 has 5 observations\n",
      "632.0 has 9 observations\n",
      "633.0 has 13 observations\n",
      "634.0 has 5 observations\n",
      "635.0 has 4 observations\n",
      "636.0 has 5 observations\n",
      "637.0 has 4 observations\n",
      "638.0 has 5 observations\n",
      "639.0 has 1 observations\n",
      "640.0 has 1 observations\n",
      "641.0 has 5 observations\n",
      "642.0 has 14 observations\n",
      "643.0 has 10 observations\n",
      "644.0 has 3 observations\n",
      "645.0 has 3 observations\n",
      "646.0 has 5 observations\n",
      "647.0 has 5 observations\n",
      "648.0 has 3 observations\n",
      "649.0 has 1 observations\n",
      "650.0 has 3 observations\n",
      "651.0 has 5 observations\n",
      "652.0 has 13 observations\n",
      "653.0 has 9 observations\n",
      "654.0 has 4 observations\n",
      "655.0 has 2 observations\n",
      "656.0 has 6 observations\n",
      "657.0 has 4 observations\n",
      "658.0 has 3 observations\n",
      "659.0 has 1 observations\n",
      "660.0 has 3 observations\n",
      "661.0 has 8 observations\n",
      "662.0 has 13 observations\n",
      "663.0 has 7 observations\n",
      "664.0 has 3 observations\n",
      "665.0 has 2 observations\n",
      "666.0 has 7 observations\n",
      "667.0 has 4 observations\n",
      "668.0 has 2 observations\n",
      "669.0 has 1 observations\n",
      "670.0 has 3 observations\n",
      "671.0 has 8 observations\n",
      "672.0 has 14 observations\n",
      "673.0 has 6 observations\n",
      "674.0 has 3 observations\n",
      "675.0 has 3 observations\n",
      "676.0 has 6 observations\n",
      "677.0 has 4 observations\n",
      "678.0 has 2 observations\n",
      "679.0 has 1 observations\n",
      "680.0 has 3 observations\n",
      "681.0 has 10 observations\n",
      "682.0 has 12 observations\n",
      "683.0 has 6 observations\n",
      "684.0 has 4 observations\n",
      "685.0 has 2 observations\n",
      "686.0 has 7 observations\n",
      "687.0 has 3 observations\n",
      "688.0 has 2 observations\n",
      "689.0 has 1 observations\n",
      "690.0 has 3 observations\n",
      "691.0 has 10 observations\n",
      "692.0 has 13 observations\n",
      "693.0 has 5 observations\n",
      "694.0 has 4 observations\n",
      "695.0 has 2 observations\n",
      "696.0 has 7 observations\n",
      "697.0 has 4 observations\n",
      "698.0 has 2 observations\n",
      "700.0 has 4 observations\n",
      "701.0 has 11 observations\n",
      "702.0 has 12 observations\n",
      "703.0 has 5 observations\n",
      "704.0 has 3 observations\n",
      "705.0 has 4 observations\n",
      "706.0 has 5 observations\n",
      "707.0 has 5 observations\n",
      "708.0 has 1 observations\n",
      "710.0 has 4 observations\n",
      "711.0 has 11 observations\n",
      "712.0 has 12 observations\n",
      "713.0 has 5 observations\n",
      "714.0 has 3 observations\n",
      "715.0 has 5 observations\n",
      "716.0 has 4 observations\n",
      "717.0 has 5 observations\n",
      "718.0 has 1 observations\n",
      "719.0 has 1 observations\n",
      "720.0 has 5 observations\n",
      "721.0 has 13 observations\n",
      "722.0 has 11 observations\n",
      "723.0 has 2 observations\n",
      "724.0 has 4 observations\n",
      "725.0 has 4 observations\n",
      "726.0 has 4 observations\n",
      "727.0 has 5 observations\n",
      "728.0 has 1 observations\n",
      "729.0 has 1 observations\n",
      "730.0 has 5 observations\n",
      "731.0 has 14 observations\n",
      "732.0 has 10 observations\n",
      "733.0 has 3 observations\n",
      "734.0 has 3 observations\n",
      "735.0 has 5 observations\n",
      "736.0 has 5 observations\n",
      "737.0 has 3 observations\n",
      "738.0 has 1 observations\n",
      "739.0 has 3 observations\n",
      "740.0 has 8 observations\n",
      "741.0 has 12 observations\n",
      "742.0 has 8 observations\n",
      "743.0 has 3 observations\n",
      "744.0 has 2 observations\n",
      "745.0 has 7 observations\n",
      "746.0 has 3 observations\n",
      "747.0 has 3 observations\n",
      "748.0 has 1 observations\n",
      "749.0 has 3 observations\n",
      "750.0 has 8 observations\n",
      "751.0 has 13 observations\n",
      "752.0 has 7 observations\n",
      "753.0 has 3 observations\n",
      "754.0 has 2 observations\n",
      "755.0 has 7 observations\n",
      "756.0 has 4 observations\n",
      "757.0 has 2 observations\n",
      "758.0 has 1 observations\n",
      "759.0 has 3 observations\n",
      "760.0 has 8 observations\n",
      "761.0 has 14 observations\n",
      "762.0 has 6 observations\n",
      "763.0 has 3 observations\n",
      "764.0 has 3 observations\n",
      "765.0 has 7 observations\n",
      "766.0 has 4 observations\n",
      "767.0 has 2 observations\n",
      "769.0 has 4 observations\n",
      "770.0 has 10 observations\n",
      "771.0 has 13 observations\n",
      "772.0 has 4 observations\n",
      "773.0 has 4 observations\n",
      "774.0 has 3 observations\n",
      "775.0 has 6 observations\n",
      "776.0 has 5 observations\n",
      "779.0 has 4 observations\n",
      "780.0 has 11 observations\n",
      "781.0 has 12 observations\n",
      "782.0 has 5 observations\n",
      "783.0 has 3 observations\n",
      "784.0 has 4 observations\n",
      "785.0 has 5 observations\n",
      "786.0 has 4 observations\n",
      "788.0 has 1 observations\n",
      "789.0 has 5 observations\n",
      "790.0 has 12 observations\n",
      "791.0 has 12 observations\n",
      "792.0 has 2 observations\n",
      "793.0 has 4 observations\n",
      "794.0 has 4 observations\n",
      "795.0 has 3 observations\n",
      "796.0 has 3 observations\n",
      "798.0 has 1 observations\n",
      "799.0 has 5 observations\n",
      "800.0 has 14 observations\n",
      "801.0 has 10 observations\n",
      "802.0 has 3 observations\n",
      "803.0 has 3 observations\n",
      "804.0 has 6 observations\n",
      "805.0 has 2 observations\n",
      "806.0 has 1 observations\n",
      "808.0 has 3 observations\n",
      "809.0 has 8 observations\n",
      "810.0 has 12 observations\n",
      "811.0 has 8 observations\n",
      "812.0 has 3 observations\n",
      "813.0 has 2 observations\n",
      "814.0 has 7 observations\n",
      "815.0 has 1 observations\n",
      "816.0 has 1 observations\n",
      "818.0 has 3 observations\n",
      "819.0 has 8 observations\n",
      "820.0 has 14 observations\n",
      "821.0 has 6 observations\n",
      "822.0 has 3 observations\n",
      "823.0 has 2 observations\n",
      "824.0 has 7 observations\n",
      "825.0 has 1 observations\n",
      "826.0 has 1 observations\n",
      "828.0 has 3 observations\n",
      "829.0 has 8 observations\n",
      "830.0 has 14 observations\n",
      "831.0 has 6 observations\n",
      "832.0 has 3 observations\n",
      "833.0 has 3 observations\n",
      "834.0 has 6 observations\n",
      "835.0 has 1 observations\n",
      "836.0 has 1 observations\n",
      "838.0 has 3 observations\n",
      "839.0 has 9 observations\n",
      "840.0 has 13 observations\n",
      "841.0 has 4 observations\n",
      "842.0 has 4 observations\n",
      "843.0 has 2 observations\n",
      "844.0 has 6 observations\n",
      "845.0 has 2 observations\n",
      "848.0 has 4 observations\n",
      "849.0 has 10 observations\n",
      "850.0 has 12 observations\n",
      "851.0 has 3 observations\n",
      "852.0 has 3 observations\n",
      "853.0 has 4 observations\n",
      "854.0 has 4 observations\n",
      "855.0 has 2 observations\n",
      "857.0 has 1 observations\n",
      "858.0 has 3 observations\n",
      "859.0 has 11 observations\n",
      "860.0 has 12 observations\n",
      "861.0 has 2 observations\n",
      "862.0 has 4 observations\n",
      "863.0 has 4 observations\n",
      "864.0 has 3 observations\n",
      "865.0 has 2 observations\n",
      "867.0 has 1 observations\n",
      "868.0 has 5 observations\n",
      "869.0 has 13 observations\n",
      "870.0 has 8 observations\n",
      "871.0 has 2 observations\n",
      "872.0 has 4 observations\n",
      "873.0 has 5 observations\n",
      "874.0 has 2 observations\n",
      "875.0 has 2 observations\n",
      "877.0 has 2 observations\n",
      "878.0 has 5 observations\n",
      "879.0 has 13 observations\n",
      "880.0 has 7 observations\n",
      "881.0 has 3 observations\n",
      "882.0 has 3 observations\n",
      "883.0 has 6 observations\n",
      "884.0 has 2 observations\n",
      "885.0 has 1 observations\n",
      "887.0 has 3 observations\n",
      "888.0 has 8 observations\n",
      "889.0 has 11 observations\n",
      "890.0 has 6 observations\n",
      "891.0 has 3 observations\n",
      "892.0 has 2 observations\n",
      "893.0 has 7 observations\n",
      "894.0 has 1 observations\n",
      "895.0 has 1 observations\n",
      "897.0 has 3 observations\n",
      "898.0 has 8 observations\n",
      "899.0 has 13 observations\n",
      "900.0 has 4 observations\n",
      "901.0 has 3 observations\n",
      "902.0 has 2 observations\n",
      "903.0 has 7 observations\n",
      "904.0 has 1 observations\n",
      "905.0 has 1 observations\n",
      "907.0 has 3 observations\n",
      "908.0 has 8 observations\n",
      "909.0 has 13 observations\n",
      "910.0 has 3 observations\n",
      "911.0 has 3 observations\n",
      "912.0 has 3 observations\n",
      "913.0 has 6 observations\n",
      "914.0 has 1 observations\n",
      "915.0 has 1 observations\n",
      "917.0 has 3 observations\n",
      "918.0 has 8 observations\n",
      "919.0 has 13 observations\n",
      "920.0 has 3 observations\n",
      "921.0 has 3 observations\n",
      "922.0 has 3 observations\n",
      "923.0 has 5 observations\n",
      "924.0 has 2 observations\n",
      "927.0 has 4 observations\n",
      "928.0 has 10 observations\n",
      "929.0 has 12 observations\n",
      "930.0 has 1 observations\n",
      "931.0 has 3 observations\n",
      "932.0 has 4 observations\n",
      "933.0 has 4 observations\n",
      "934.0 has 2 observations\n",
      "936.0 has 1 observations\n",
      "937.0 has 5 observations\n",
      "938.0 has 11 observations\n",
      "939.0 has 10 observations\n",
      "941.0 has 4 observations\n",
      "942.0 has 4 observations\n",
      "943.0 has 3 observations\n",
      "944.0 has 2 observations\n",
      "946.0 has 1 observations\n",
      "947.0 has 6 observations\n",
      "948.0 has 12 observations\n",
      "949.0 has 8 observations\n",
      "950.0 has 1 observations\n",
      "951.0 has 3 observations\n",
      "952.0 has 5 observations\n",
      "953.0 has 3 observations\n",
      "954.0 has 1 observations\n",
      "956.0 has 3 observations\n",
      "957.0 has 5 observations\n",
      "958.0 has 12 observations\n",
      "959.0 has 7 observations\n",
      "960.0 has 1 observations\n",
      "961.0 has 3 observations\n",
      "962.0 has 6 observations\n",
      "963.0 has 2 observations\n",
      "964.0 has 1 observations\n",
      "966.0 has 3 observations\n",
      "967.0 has 8 observations\n",
      "968.0 has 11 observations\n",
      "969.0 has 5 observations\n",
      "970.0 has 2 observations\n",
      "971.0 has 2 observations\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "972.0 has 7 observations\n",
      "973.0 has 1 observations\n",
      "974.0 has 1 observations\n",
      "976.0 has 3 observations\n",
      "977.0 has 8 observations\n",
      "978.0 has 13 observations\n",
      "979.0 has 3 observations\n",
      "980.0 has 2 observations\n",
      "981.0 has 2 observations\n",
      "982.0 has 7 observations\n",
      "983.0 has 1 observations\n",
      "984.0 has 1 observations\n",
      "986.0 has 3 observations\n",
      "987.0 has 8 observations\n",
      "988.0 has 13 observations\n",
      "989.0 has 3 observations\n",
      "990.0 has 2 observations\n",
      "991.0 has 3 observations\n",
      "992.0 has 6 observations\n",
      "993.0 has 1 observations\n",
      "994.0 has 1 observations\n",
      "996.0 has 3 observations\n",
      "997.0 has 9 observations\n",
      "998.0 has 11 observations\n",
      "999.0 has 2 observations\n",
      "1000.0 has 3 observations\n",
      "1001.0 has 3 observations\n",
      "1002.0 has 5 observations\n",
      "1003.0 has 2 observations\n",
      "1006.0 has 4 observations\n",
      "1007.0 has 9 observations\n",
      "1008.0 has 11 observations\n",
      "1009.0 has 1 observations\n",
      "1010.0 has 3 observations\n",
      "1011.0 has 3 observations\n",
      "1012.0 has 5 observations\n",
      "1013.0 has 2 observations\n",
      "1016.0 has 4 observations\n",
      "1017.0 has 10 observations\n",
      "1018.0 has 11 observations\n",
      "1020.0 has 3 observations\n",
      "1021.0 has 5 observations\n",
      "1022.0 has 3 observations\n",
      "1023.0 has 2 observations\n",
      "1025.0 has 1 observations\n",
      "1026.0 has 5 observations\n",
      "1027.0 has 12 observations\n",
      "1028.0 has 7 observations\n",
      "1029.0 has 1 observations\n",
      "1030.0 has 3 observations\n",
      "1031.0 has 5 observations\n",
      "1032.0 has 2 observations\n",
      "1033.0 has 2 observations\n",
      "1035.0 has 3 observations\n",
      "1036.0 has 5 observations\n",
      "1037.0 has 11 observations\n",
      "1038.0 has 6 observations\n",
      "1039.0 has 1 observations\n",
      "1040.0 has 3 observations\n",
      "1041.0 has 6 observations\n",
      "1042.0 has 2 observations\n",
      "1043.0 has 1 observations\n",
      "1045.0 has 3 observations\n",
      "1046.0 has 8 observations\n",
      "1047.0 has 9 observations\n",
      "1048.0 has 5 observations\n",
      "1049.0 has 2 observations\n",
      "1050.0 has 2 observations\n",
      "1051.0 has 7 observations\n",
      "1052.0 has 1 observations\n",
      "1053.0 has 1 observations\n",
      "1055.0 has 3 observations\n",
      "1056.0 has 8 observations\n",
      "1057.0 has 11 observations\n",
      "1058.0 has 3 observations\n",
      "1059.0 has 2 observations\n",
      "1060.0 has 2 observations\n",
      "1061.0 has 7 observations\n",
      "1062.0 has 1 observations\n",
      "1063.0 has 1 observations\n",
      "1065.0 has 3 observations\n",
      "1066.0 has 8 observations\n",
      "1067.0 has 11 observations\n",
      "1068.0 has 3 observations\n",
      "1069.0 has 2 observations\n",
      "1070.0 has 3 observations\n",
      "1071.0 has 6 observations\n",
      "1072.0 has 2 observations\n",
      "1075.0 has 4 observations\n",
      "1076.0 has 10 observations\n",
      "1077.0 has 10 observations\n",
      "1078.0 has 1 observations\n",
      "1079.0 has 3 observations\n",
      "1080.0 has 4 observations\n",
      "1081.0 has 4 observations\n",
      "1082.0 has 2 observations\n",
      "1084.0 has 1 observations\n",
      "1085.0 has 5 observations\n",
      "1086.0 has 8 observations\n",
      "1087.0 has 11 observations\n",
      "1089.0 has 4 observations\n",
      "1090.0 has 4 observations\n",
      "1091.0 has 3 observations\n",
      "1092.0 has 1 observations\n",
      "1094.0 has 1 observations\n",
      "1095.0 has 5 observations\n",
      "1096.0 has 12 observations\n",
      "1097.0 has 6 observations\n",
      "1098.0 has 1 observations\n",
      "1099.0 has 3 observations\n",
      "1100.0 has 5 observations\n",
      "1101.0 has 3 observations\n",
      "1104.0 has 3 observations\n",
      "1105.0 has 5 observations\n",
      "1106.0 has 11 observations\n",
      "1107.0 has 5 observations\n",
      "1108.0 has 1 observations\n",
      "1109.0 has 3 observations\n",
      "1110.0 has 6 observations\n",
      "1111.0 has 2 observations\n",
      "1114.0 has 3 observations\n",
      "1115.0 has 8 observations\n",
      "1116.0 has 10 observations\n",
      "1117.0 has 2 observations\n",
      "1118.0 has 2 observations\n",
      "1119.0 has 2 observations\n",
      "1120.0 has 7 observations\n",
      "1121.0 has 1 observations\n",
      "1124.0 has 3 observations\n",
      "1125.0 has 8 observations\n",
      "1126.0 has 11 observations\n",
      "1127.0 has 1 observations\n",
      "1128.0 has 2 observations\n",
      "1129.0 has 2 observations\n",
      "1130.0 has 7 observations\n",
      "1131.0 has 1 observations\n",
      "1134.0 has 2 observations\n",
      "1135.0 has 8 observations\n",
      "1136.0 has 11 observations\n",
      "1137.0 has 1 observations\n",
      "1138.0 has 2 observations\n",
      "1139.0 has 3 observations\n",
      "1140.0 has 6 observations\n",
      "1141.0 has 1 observations\n",
      "1144.0 has 2 observations\n",
      "1145.0 has 10 observations\n",
      "1146.0 has 9 observations\n",
      "1147.0 has 1 observations\n",
      "1148.0 has 3 observations\n",
      "1149.0 has 3 observations\n",
      "1150.0 has 5 observations\n",
      "1151.0 has 1 observations\n",
      "1154.0 has 3 observations\n",
      "1155.0 has 10 observations\n",
      "1156.0 has 8 observations\n",
      "1157.0 has 1 observations\n",
      "1158.0 has 3 observations\n",
      "1159.0 has 4 observations\n",
      "1160.0 has 4 observations\n",
      "1161.0 has 1 observations\n",
      "1163.0 has 1 observations\n",
      "1164.0 has 2 observations\n",
      "1165.0 has 10 observations\n",
      "1166.0 has 9 observations\n",
      "1168.0 has 3 observations\n",
      "1169.0 has 5 observations\n",
      "1170.0 has 3 observations\n",
      "1171.0 has 1 observations\n",
      "1173.0 has 1 observations\n",
      "1174.0 has 4 observations\n",
      "1175.0 has 12 observations\n",
      "1176.0 has 5 observations\n",
      "1178.0 has 4 observations\n",
      "1179.0 has 4 observations\n",
      "1180.0 has 3 observations\n",
      "1181.0 has 1 observations\n",
      "1183.0 has 1 observations\n",
      "1184.0 has 5 observations\n",
      "1185.0 has 11 observations\n",
      "1186.0 has 5 observations\n",
      "1187.0 has 1 observations\n",
      "1188.0 has 3 observations\n",
      "1189.0 has 6 observations\n",
      "1190.0 has 2 observations\n",
      "1193.0 has 2 observations\n",
      "1194.0 has 8 observations\n",
      "1195.0 has 10 observations\n",
      "1196.0 has 2 observations\n",
      "1197.0 has 2 observations\n",
      "1198.0 has 2 observations\n",
      "1199.0 has 7 observations\n",
      "1200.0 has 1 observations\n",
      "1203.0 has 2 observations\n",
      "1204.0 has 8 observations\n",
      "1205.0 has 11 observations\n",
      "1206.0 has 1 observations\n",
      "1207.0 has 2 observations\n",
      "1208.0 has 1 observations\n",
      "1209.0 has 6 observations\n",
      "1210.0 has 1 observations\n",
      "1213.0 has 2 observations\n",
      "1214.0 has 9 observations\n",
      "1215.0 has 10 observations\n",
      "1216.0 has 1 observations\n",
      "1217.0 has 2 observations\n",
      "1218.0 has 2 observations\n",
      "1219.0 has 5 observations\n",
      "1220.0 has 1 observations\n",
      "1223.0 has 3 observations\n",
      "1224.0 has 10 observations\n",
      "1225.0 has 9 observations\n",
      "1227.0 has 2 observations\n",
      "1228.0 has 4 observations\n",
      "1229.0 has 3 observations\n",
      "1230.0 has 1 observations\n",
      "1232.0 has 1 observations\n",
      "1233.0 has 4 observations\n",
      "1234.0 has 12 observations\n",
      "1235.0 has 5 observations\n",
      "1236.0 has 1 observations\n",
      "1237.0 has 2 observations\n",
      "1238.0 has 5 observations\n",
      "1239.0 has 2 observations\n",
      "1242.0 has 2 observations\n",
      "1243.0 has 5 observations\n",
      "1244.0 has 11 observations\n",
      "1245.0 has 4 observations\n",
      "1246.0 has 2 observations\n",
      "1247.0 has 1 observations\n",
      "1248.0 has 6 observations\n",
      "1249.0 has 1 observations\n",
      "1252.0 has 2 observations\n",
      "1253.0 has 8 observations\n",
      "1254.0 has 10 observations\n",
      "1255.0 has 2 observations\n",
      "1256.0 has 2 observations\n",
      "1257.0 has 1 observations\n",
      "1258.0 has 6 observations\n",
      "1259.0 has 1 observations\n",
      "1262.0 has 2 observations\n",
      "1263.0 has 8 observations\n",
      "1264.0 has 11 observations\n",
      "1265.0 has 1 observations\n",
      "1266.0 has 2 observations\n",
      "1267.0 has 1 observations\n",
      "1268.0 has 5 observations\n",
      "1269.0 has 1 observations\n",
      "1272.0 has 3 observations\n",
      "1273.0 has 9 observations\n",
      "1274.0 has 9 observations\n",
      "1275.0 has 1 observations\n",
      "1276.0 has 2 observations\n",
      "1277.0 has 2 observations\n",
      "1278.0 has 4 observations\n",
      "1279.0 has 1 observations\n",
      "1282.0 has 3 observations\n",
      "1283.0 has 10 observations\n",
      "1284.0 has 8 observations\n",
      "1285.0 has 1 observations\n",
      "1286.0 has 2 observations\n",
      "1287.0 has 3 observations\n",
      "1288.0 has 3 observations\n",
      "1289.0 has 1 observations\n",
      "1292.0 has 3 observations\n",
      "1293.0 has 9 observations\n",
      "1294.0 has 8 observations\n",
      "1295.0 has 1 observations\n",
      "1296.0 has 2 observations\n",
      "1297.0 has 3 observations\n",
      "1298.0 has 3 observations\n",
      "1299.0 has 1 observations\n",
      "1301.0 has 1 observations\n",
      "1302.0 has 4 observations\n",
      "1303.0 has 11 observations\n",
      "1304.0 has 5 observations\n",
      "1305.0 has 1 observations\n",
      "1306.0 has 2 observations\n",
      "1307.0 has 3 observations\n",
      "1308.0 has 3 observations\n",
      "1311.0 has 2 observations\n",
      "1312.0 has 7 observations\n",
      "1313.0 has 9 observations\n",
      "1314.0 has 3 observations\n",
      "1315.0 has 2 observations\n",
      "1316.0 has 1 observations\n",
      "1317.0 has 5 observations\n",
      "1318.0 has 1 observations\n",
      "1321.0 has 2 observations\n",
      "1322.0 has 7 observations\n",
      "1323.0 has 10 observations\n",
      "1324.0 has 2 observations\n",
      "1325.0 has 2 observations\n",
      "1326.0 has 1 observations\n",
      "1327.0 has 5 observations\n",
      "1328.0 has 1 observations\n",
      "1331.0 has 2 observations\n",
      "1332.0 has 7 observations\n",
      "1333.0 has 11 observations\n",
      "1334.0 has 1 observations\n",
      "1335.0 has 2 observations\n",
      "1336.0 has 1 observations\n",
      "1337.0 has 5 observations\n",
      "1338.0 has 1 observations\n",
      "1341.0 has 2 observations\n",
      "1342.0 has 8 observations\n",
      "1343.0 has 10 observations\n",
      "1344.0 has 1 observations\n",
      "1345.0 has 2 observations\n",
      "1346.0 has 2 observations\n",
      "1347.0 has 4 observations\n",
      "1348.0 has 1 observations\n",
      "1351.0 has 3 observations\n",
      "1352.0 has 9 observations\n",
      "1353.0 has 8 observations\n",
      "1354.0 has 1 observations\n",
      "1355.0 has 2 observations\n",
      "1356.0 has 3 observations\n",
      "1357.0 has 3 observations\n",
      "1358.0 has 1 observations\n",
      "1360.0 has 1 observations\n",
      "1361.0 has 4 observations\n",
      "1362.0 has 9 observations\n",
      "1363.0 has 7 observations\n",
      "1365.0 has 3 observations\n",
      "1366.0 has 2 observations\n",
      "1367.0 has 2 observations\n",
      "1368.0 has 1 observations\n",
      "1370.0 has 1 observations\n",
      "1371.0 has 5 observations\n",
      "1372.0 has 10 observations\n",
      "1373.0 has 5 observations\n",
      "1374.0 has 1 observations\n",
      "1375.0 has 2 observations\n",
      "1376.0 has 3 observations\n",
      "1377.0 has 1 observations\n",
      "1380.0 has 2 observations\n",
      "1381.0 has 6 observations\n",
      "1382.0 has 10 observations\n",
      "1383.0 has 3 observations\n",
      "1384.0 has 2 observations\n",
      "1385.0 has 1 observations\n",
      "1386.0 has 3 observations\n",
      "1387.0 has 1 observations\n",
      "1390.0 has 2 observations\n",
      "1391.0 has 7 observations\n",
      "1392.0 has 10 observations\n",
      "1393.0 has 2 observations\n",
      "1394.0 has 2 observations\n",
      "1395.0 has 1 observations\n",
      "1396.0 has 3 observations\n",
      "1397.0 has 1 observations\n",
      "1400.0 has 2 observations\n",
      "1401.0 has 7 observations\n",
      "1402.0 has 11 observations\n",
      "1403.0 has 1 observations\n",
      "1404.0 has 2 observations\n",
      "1405.0 has 1 observations\n",
      "1406.0 has 3 observations\n",
      "1407.0 has 1 observations\n",
      "1410.0 has 3 observations\n",
      "1411.0 has 9 observations\n",
      "1412.0 has 8 observations\n",
      "1413.0 has 1 observations\n",
      "1414.0 has 2 observations\n",
      "1415.0 has 2 observations\n",
      "1416.0 has 2 observations\n",
      "1417.0 has 1 observations\n",
      "1419.0 has 1 observations\n",
      "1420.0 has 2 observations\n",
      "1421.0 has 9 observations\n",
      "1422.0 has 9 observations\n",
      "1424.0 has 2 observations\n",
      "1425.0 has 3 observations\n",
      "1426.0 has 1 observations\n",
      "1427.0 has 1 observations\n",
      "1429.0 has 1 observations\n",
      "1430.0 has 4 observations\n",
      "1431.0 has 10 observations\n",
      "1432.0 has 6 observations\n",
      "1433.0 has 1 observations\n",
      "1434.0 has 2 observations\n",
      "1435.0 has 2 observations\n",
      "1436.0 has 1 observations\n",
      "1437.0 has 1 observations\n",
      "1439.0 has 1 observations\n",
      "1440.0 has 5 observations\n",
      "1441.0 has 11 observations\n",
      "1442.0 has 3 observations\n",
      "1443.0 has 2 observations\n",
      "1444.0 has 1 observations\n",
      "1445.0 has 3 observations\n",
      "1446.0 has 1 observations\n",
      "1449.0 has 2 observations\n",
      "1450.0 has 7 observations\n",
      "1451.0 has 10 observations\n",
      "1452.0 has 1 observations\n",
      "1453.0 has 2 observations\n",
      "1454.0 has 1 observations\n",
      "1455.0 has 3 observations\n",
      "1456.0 has 1 observations\n",
      "1459.0 has 2 observations\n",
      "1460.0 has 6 observations\n",
      "1461.0 has 10 observations\n",
      "1462.0 has 1 observations\n",
      "1463.0 has 2 observations\n",
      "1464.0 has 1 observations\n",
      "1465.0 has 3 observations\n",
      "1466.0 has 1 observations\n",
      "1469.0 has 2 observations\n",
      "1470.0 has 6 observations\n",
      "1471.0 has 10 observations\n",
      "1472.0 has 1 observations\n",
      "1473.0 has 2 observations\n",
      "1474.0 has 1 observations\n",
      "1475.0 has 3 observations\n",
      "1479.0 has 3 observations\n",
      "1480.0 has 7 observations\n",
      "1481.0 has 8 observations\n",
      "1482.0 has 1 observations\n",
      "1483.0 has 2 observations\n",
      "1484.0 has 2 observations\n",
      "1485.0 has 2 observations\n",
      "1489.0 has 3 observations\n",
      "1490.0 has 8 observations\n",
      "1491.0 has 8 observations\n",
      "1493.0 has 2 observations\n",
      "1494.0 has 3 observations\n",
      "1495.0 has 1 observations\n",
      "1499.0 has 4 observations\n",
      "1500.0 has 8 observations\n",
      "1501.0 has 4 observations\n",
      "1503.0 has 3 observations\n",
      "1504.0 has 2 observations\n",
      "1505.0 has 1 observations\n",
      "1509.0 has 2 observations\n",
      "1510.0 has 8 observations\n",
      "1511.0 has 3 observations\n",
      "1512.0 has 1 observations\n",
      "1513.0 has 2 observations\n",
      "1514.0 has 3 observations\n",
      "1519.0 has 3 observations\n",
      "1520.0 has 7 observations\n",
      "1521.0 has 2 observations\n",
      "1522.0 has 2 observations\n",
      "1523.0 has 1 observations\n",
      "1524.0 has 3 observations\n",
      "1529.0 has 4 observations\n",
      "1530.0 has 7 observations\n",
      "1531.0 has 1 observations\n",
      "1532.0 has 1 observations\n",
      "1533.0 has 1 observations\n",
      "1534.0 has 3 observations\n",
      "1539.0 has 4 observations\n",
      "1540.0 has 6 observations\n",
      "1541.0 has 1 observations\n",
      "1542.0 has 1 observations\n",
      "1543.0 has 1 observations\n",
      "1544.0 has 3 observations\n",
      "1549.0 has 4 observations\n",
      "1550.0 has 6 observations\n",
      "1551.0 has 1 observations\n",
      "1552.0 has 1 observations\n",
      "1553.0 has 1 observations\n",
      "1554.0 has 3 observations\n",
      "1558.0 has 1 observations\n",
      "1559.0 has 5 observations\n",
      "1560.0 has 4 observations\n",
      "1561.0 has 1 observations\n",
      "1562.0 has 1 observations\n",
      "1563.0 has 3 observations\n",
      "1564.0 has 1 observations\n",
      "1568.0 has 2 observations\n",
      "1569.0 has 4 observations\n",
      "1570.0 has 5 observations\n",
      "1572.0 has 1 observations\n",
      "1573.0 has 3 observations\n",
      "1574.0 has 1 observations\n",
      "1578.0 has 2 observations\n",
      "1579.0 has 8 observations\n",
      "1580.0 has 1 observations\n",
      "1582.0 has 2 observations\n",
      "1583.0 has 2 observations\n",
      "1584.0 has 1 observations\n",
      "1588.0 has 2 observations\n",
      "1589.0 has 7 observations\n",
      "1590.0 has 1 observations\n",
      "1591.0 has 1 observations\n",
      "1592.0 has 1 observations\n",
      "1593.0 has 3 observations\n",
      "1598.0 has 3 observations\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1599.0 has 6 observations\n",
      "1600.0 has 1 observations\n",
      "1601.0 has 1 observations\n",
      "1602.0 has 1 observations\n",
      "1603.0 has 3 observations\n",
      "1608.0 has 4 observations\n",
      "1609.0 has 5 observations\n",
      "1610.0 has 1 observations\n",
      "1611.0 has 1 observations\n",
      "1612.0 has 1 observations\n",
      "1613.0 has 3 observations\n",
      "1618.0 has 4 observations\n",
      "1619.0 has 4 observations\n",
      "1620.0 has 1 observations\n",
      "1621.0 has 1 observations\n",
      "1622.0 has 1 observations\n",
      "1623.0 has 3 observations\n",
      "1628.0 has 2 observations\n",
      "1629.0 has 4 observations\n",
      "1630.0 has 1 observations\n",
      "1631.0 has 1 observations\n",
      "1632.0 has 1 observations\n",
      "1633.0 has 3 observations\n",
      "1638.0 has 3 observations\n",
      "1639.0 has 3 observations\n",
      "1640.0 has 1 observations\n",
      "1641.0 has 1 observations\n",
      "1642.0 has 2 observations\n",
      "1643.0 has 2 observations\n",
      "1648.0 has 3 observations\n",
      "1649.0 has 4 observations\n",
      "1651.0 has 1 observations\n",
      "1652.0 has 3 observations\n",
      "1653.0 has 1 observations\n",
      "1658.0 has 4 observations\n",
      "1659.0 has 1 observations\n",
      "1660.0 has 1 observations\n",
      "1661.0 has 1 observations\n",
      "1662.0 has 2 observations\n",
      "1663.0 has 1 observations\n",
      "1668.0 has 4 observations\n",
      "1669.0 has 1 observations\n",
      "1670.0 has 1 observations\n",
      "1671.0 has 1 observations\n",
      "1672.0 has 3 observations\n",
      "1678.0 has 4 observations\n",
      "1679.0 has 1 observations\n",
      "1680.0 has 1 observations\n",
      "1681.0 has 1 observations\n",
      "1682.0 has 3 observations\n",
      "1688.0 has 4 observations\n",
      "1689.0 has 1 observations\n",
      "1690.0 has 1 observations\n",
      "1691.0 has 1 observations\n",
      "1692.0 has 3 observations\n",
      "1698.0 has 2 observations\n",
      "1699.0 has 1 observations\n",
      "1700.0 has 1 observations\n",
      "1701.0 has 1 observations\n",
      "1702.0 has 3 observations\n",
      "1708.0 has 2 observations\n",
      "1709.0 has 1 observations\n",
      "1711.0 has 1 observations\n",
      "1712.0 has 3 observations\n",
      "1717.0 has 1 observations\n",
      "1718.0 has 1 observations\n",
      "1719.0 has 1 observations\n",
      "1721.0 has 3 observations\n",
      "1722.0 has 1 observations\n",
      "1727.0 has 2 observations\n",
      "1728.0 has 1 observations\n",
      "1730.0 has 1 observations\n",
      "1731.0 has 2 observations\n",
      "1732.0 has 1 observations\n",
      "1737.0 has 2 observations\n",
      "1738.0 has 1 observations\n",
      "1740.0 has 1 observations\n",
      "1741.0 has 3 observations\n",
      "1746.0 has 19 observations\n"
     ]
    }
   ],
   "source": [
    "# check how many players' locations we have at each point in time\n",
    "# we want to make sure that after this process, all players have harmonized times and locations\n",
    "for i in data.elapsedTime.unique():\n",
    "    obs = len(data[data['elapsedTime'] == i])\n",
    "    print(f'{i} has {obs} observations')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>elapsedTime</th>\n",
       "      <th>name</th>\n",
       "      <th>location.x</th>\n",
       "      <th>location.y</th>\n",
       "      <th>vehicle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>10Baerini</td>\n",
       "      <td>719536</td>\n",
       "      <td>546556</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10Baerini</td>\n",
       "      <td>254099</td>\n",
       "      <td>954480</td>\n",
       "      <td>TransportAircraft</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11.0</td>\n",
       "      <td>10Baerini</td>\n",
       "      <td>258308</td>\n",
       "      <td>811172</td>\n",
       "      <td>TransportAircraft</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>21.0</td>\n",
       "      <td>10Baerini</td>\n",
       "      <td>262449</td>\n",
       "      <td>670174</td>\n",
       "      <td>TransportAircraft</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30.0</td>\n",
       "      <td>10Baerini</td>\n",
       "      <td>266591</td>\n",
       "      <td>529161</td>\n",
       "      <td>TransportAircraft</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   elapsedTime       name  location.x  location.y            vehicle\n",
       "0          0.0  10Baerini      719536      546556                NaN\n",
       "1          1.0  10Baerini      254099      954480  TransportAircraft\n",
       "2         11.0  10Baerini      258308      811172  TransportAircraft\n",
       "3         21.0  10Baerini      262449      670174  TransportAircraft\n",
       "4         30.0  10Baerini      266591      529161  TransportAircraft"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# we create a new dataframe with the necessary information to interpolate locations\n",
    "data_new_coords = data[['elapsedTime','name','location.x','location.y', 'vehicle']].sort_values(['name','elapsedTime']).drop_duplicates()\n",
    "data_new_coords = data_new_coords.reset_index().drop('index', axis=1)\n",
    "data_new_coords = data_new_coords.dropna(subset = ['elapsedTime'])\n",
    "# we round coordinates for ease of calculations, and because a difference in location smaller than a cm is negligible\n",
    "data_new_coords['location.x'] = data_new_coords['location.x'].apply(round)\n",
    "data_new_coords['location.y'] = data_new_coords['location.y'].apply(round)\n",
    "data_new_coords.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([   0,    1,   11, ..., 1043, 1053, 1063])"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new_coords.elapsedTime.unique().astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 1min 36s, sys: 392 ms, total: 1min 37s\n",
      "Wall time: 1min 37s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "# since different elapsed times don't show the location of all players, we want to interpolate the position of the players at each\n",
    "# point in time. e.g. if player a is in position (x,y) at second 10.0 and in position (x+10,y+10) at second 20.0\n",
    "# we can expect that this player will be at position (x+1,y+1) at second 11.0, and so on\n",
    "def getNewCoord(t, n):\n",
    "    aa = data_new_coords[(data_new_coords['elapsedTime'] < t) & (data_new_coords['name'] == n)] # get previous observations\n",
    "    bb = data_new_coords[(data_new_coords['elapsedTime'] > t) & (data_new_coords['name'] == n)] # get following observations\n",
    "    if (bool(aa['location.x'].any())) & (bool(bb['location.x'].any())): # if we have both previous and following observation\n",
    "        a = aa.iloc[-1] # get last previous observation\n",
    "        b = bb.iloc[0] # get first following observation\n",
    "        time = b[0] - a[0] # calculate the time difference\n",
    "        # get x and y coordinate by calculating movement speed in cm/s and get full coordinate\n",
    "        new_coord_x = a[2] + ((b[2] - a[2]) / time)*(t-a[0])  \n",
    "        new_coord_y = a[3] + ((b[3] - a[3]) / time)*(t-a[0])\n",
    "        # we also get the vehicle to check if a player has jumped from the airplane or not\n",
    "        in_aircraft = b['vehicle']\n",
    "        return new_coord_x, new_coord_y, in_aircraft\n",
    "    elif (not bool(aa['location.x'].any())) & (bool(bb['location.x'].any())):\n",
    "        # if there is no previous observation, set first following location to be current location\n",
    "        in_aircraft = b['vehicle']\n",
    "        return b.iat[0,2], b.iat[0,3], in_aircraft\n",
    "\n",
    "    # If a player doesn't have a future location, that indicates the player is dead\n",
    "    elif (bool(aa['location.x'].any())) & (not bool(bb['location.x'].any())):\n",
    "        # if there is no following observation, we assume the player has died (we hope that only in the match)\n",
    "        return 'dead', 'dead', 'dead'\n",
    "\n",
    "names=[]\n",
    "times=[]\n",
    "x_coords=[]\n",
    "y_coords=[]\n",
    "aircraft=[]\n",
    "# we will get the location every 10 seconds from second 1 (e.g. 1.0, 11.0, 21.0), and at the last second\n",
    "times_list = data_new_coords.elapsedTime.unique().astype(int)\n",
    "# we get the times in intervals of 10s from second 1 to the last second of the game\n",
    "unique_times_10s = np.arange(1, max(times_list), 10).tolist()\n",
    "# we also append the last second, regardless of the 10s interval\n",
    "unique_times_10s.append(max(times_list))\n",
    "for t in unique_times_10s:\n",
    "    for n in data_new_coords.name.unique():\n",
    "        # for every player, we get their location at these times\n",
    "        a = data_new_coords[(data_new_coords['elapsedTime'] == t) & (data_new_coords['name'] == n)]\n",
    "        # if the player has a location, we take it\n",
    "        if a['location.x'].any():\n",
    "            names.append(n)\n",
    "            times.append(t)\n",
    "            x_coords.append(a.iat[0,2])\n",
    "            y_coords.append(a.iat[0,3])\n",
    "            aircraft.append(a['vehicle'])\n",
    "        # if not, we interpolate it\n",
    "        else:\n",
    "            x_coord, y_coord, in_aircraft = getNewCoord(t,n)\n",
    "            names.append(n)\n",
    "            times.append(t)\n",
    "            x_coords.append(x_coord)\n",
    "            y_coords.append(y_coord)\n",
    "            aircraft.append(in_aircraft)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>name</th>\n",
       "      <th>location.x</th>\n",
       "      <th>location.y</th>\n",
       "      <th>inAircraft</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>10Baerini</td>\n",
       "      <td>254099</td>\n",
       "      <td>954480</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2092</td>\n",
       "      <td>dead</td>\n",
       "      <td>dead</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>7Burial</td>\n",
       "      <td>626733</td>\n",
       "      <td>616448</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>7ooc_-_</td>\n",
       "      <td>254324</td>\n",
       "      <td>946841</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8255</td>\n",
       "      <td>665941</td>\n",
       "      <td>572083</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>8344</td>\n",
       "      <td>254361</td>\n",
       "      <td>945559</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>91VinsmokeSanjii</td>\n",
       "      <td>dead</td>\n",
       "      <td>dead</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>AEPs4O4</td>\n",
       "      <td>254050</td>\n",
       "      <td>956144</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>AKA447</td>\n",
       "      <td>566028</td>\n",
       "      <td>662904</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>AeJiGooYo</td>\n",
       "      <td>dead</td>\n",
       "      <td>dead</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   time              name location.x location.y  inAircraft\n",
       "0     1         10Baerini     254099     954480           0\n",
       "1     1              2092       dead       dead           0\n",
       "2     1           7Burial     626733     616448           1\n",
       "3     1           7ooc_-_     254324     946841           1\n",
       "4     1              8255     665941     572083           1\n",
       "5     1              8344     254361     945559           1\n",
       "6     1  91VinsmokeSanjii       dead       dead           0\n",
       "7     1           AEPs4O4     254050     956144           0\n",
       "8     1            AKA447     566028     662904           1\n",
       "9     1         AeJiGooYo       dead       dead           0"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# we create the dataframe from these locations\n",
    "players_location = pd.DataFrame(list(zip(times,names,x_coords, y_coords, aircraft)),\n",
    "             columns=['time','name','location.x','location.y', 'inAircraft'])\n",
    "# we also check if the players are or aren't in the aircraft with a binary variable\n",
    "players_location['inAircraft'] = players_location['inAircraft'].apply(lambda x: 1 if str(x) == 'TransportAircraft' else 0)\n",
    "players_location.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 has 100 observations\n",
      "11 has 100 observations\n",
      "21 has 100 observations\n",
      "31 has 100 observations\n",
      "41 has 100 observations\n",
      "51 has 100 observations\n",
      "61 has 100 observations\n",
      "71 has 100 observations\n",
      "81 has 100 observations\n",
      "91 has 100 observations\n",
      "101 has 100 observations\n",
      "111 has 100 observations\n",
      "121 has 100 observations\n",
      "131 has 100 observations\n",
      "141 has 100 observations\n",
      "151 has 100 observations\n",
      "161 has 100 observations\n",
      "171 has 100 observations\n",
      "181 has 100 observations\n",
      "191 has 100 observations\n",
      "201 has 100 observations\n",
      "211 has 100 observations\n",
      "221 has 100 observations\n",
      "231 has 100 observations\n",
      "241 has 100 observations\n",
      "251 has 100 observations\n",
      "261 has 100 observations\n",
      "271 has 100 observations\n",
      "281 has 100 observations\n",
      "291 has 100 observations\n",
      "301 has 100 observations\n",
      "311 has 100 observations\n",
      "321 has 100 observations\n",
      "331 has 100 observations\n",
      "341 has 100 observations\n",
      "351 has 100 observations\n",
      "361 has 100 observations\n",
      "371 has 100 observations\n",
      "381 has 100 observations\n",
      "391 has 100 observations\n",
      "401 has 100 observations\n",
      "411 has 100 observations\n",
      "421 has 100 observations\n",
      "431 has 100 observations\n",
      "441 has 100 observations\n",
      "451 has 100 observations\n",
      "461 has 100 observations\n",
      "471 has 100 observations\n",
      "481 has 100 observations\n",
      "491 has 100 observations\n",
      "501 has 100 observations\n",
      "511 has 100 observations\n",
      "521 has 100 observations\n",
      "531 has 100 observations\n",
      "541 has 100 observations\n",
      "551 has 100 observations\n",
      "561 has 100 observations\n",
      "571 has 100 observations\n",
      "581 has 100 observations\n",
      "591 has 100 observations\n",
      "601 has 100 observations\n",
      "611 has 100 observations\n",
      "621 has 100 observations\n",
      "631 has 100 observations\n",
      "641 has 100 observations\n",
      "651 has 100 observations\n",
      "661 has 100 observations\n",
      "671 has 100 observations\n",
      "681 has 100 observations\n",
      "691 has 100 observations\n",
      "701 has 100 observations\n",
      "711 has 100 observations\n",
      "721 has 100 observations\n",
      "731 has 100 observations\n",
      "741 has 100 observations\n",
      "751 has 100 observations\n",
      "761 has 100 observations\n",
      "771 has 100 observations\n",
      "781 has 100 observations\n",
      "791 has 100 observations\n",
      "801 has 100 observations\n",
      "811 has 100 observations\n",
      "821 has 100 observations\n",
      "831 has 100 observations\n",
      "841 has 100 observations\n",
      "851 has 100 observations\n",
      "861 has 100 observations\n",
      "871 has 100 observations\n",
      "881 has 100 observations\n",
      "891 has 100 observations\n",
      "901 has 100 observations\n",
      "911 has 100 observations\n",
      "921 has 100 observations\n",
      "931 has 100 observations\n",
      "941 has 100 observations\n",
      "951 has 100 observations\n",
      "961 has 100 observations\n",
      "971 has 100 observations\n",
      "981 has 100 observations\n",
      "991 has 100 observations\n",
      "1001 has 100 observations\n",
      "1011 has 100 observations\n",
      "1021 has 100 observations\n",
      "1031 has 100 observations\n",
      "1041 has 100 observations\n",
      "1051 has 100 observations\n",
      "1061 has 100 observations\n",
      "1071 has 100 observations\n",
      "1081 has 100 observations\n",
      "1091 has 100 observations\n",
      "1101 has 100 observations\n",
      "1111 has 100 observations\n",
      "1121 has 100 observations\n",
      "1131 has 100 observations\n",
      "1141 has 100 observations\n",
      "1151 has 100 observations\n",
      "1161 has 100 observations\n",
      "1171 has 100 observations\n",
      "1181 has 100 observations\n",
      "1191 has 100 observations\n",
      "1201 has 100 observations\n",
      "1211 has 100 observations\n",
      "1221 has 100 observations\n",
      "1231 has 100 observations\n",
      "1241 has 100 observations\n",
      "1251 has 100 observations\n",
      "1261 has 100 observations\n",
      "1271 has 100 observations\n",
      "1281 has 100 observations\n",
      "1291 has 100 observations\n",
      "1301 has 100 observations\n",
      "1311 has 100 observations\n",
      "1321 has 100 observations\n",
      "1331 has 100 observations\n",
      "1341 has 100 observations\n",
      "1351 has 100 observations\n",
      "1361 has 100 observations\n",
      "1371 has 100 observations\n",
      "1381 has 100 observations\n",
      "1391 has 100 observations\n",
      "1401 has 100 observations\n",
      "1411 has 100 observations\n",
      "1421 has 100 observations\n",
      "1431 has 100 observations\n",
      "1441 has 100 observations\n",
      "1451 has 100 observations\n",
      "1461 has 100 observations\n",
      "1471 has 100 observations\n",
      "1481 has 100 observations\n",
      "1491 has 100 observations\n",
      "1501 has 100 observations\n",
      "1511 has 100 observations\n",
      "1521 has 100 observations\n",
      "1531 has 100 observations\n",
      "1541 has 100 observations\n",
      "1551 has 100 observations\n",
      "1561 has 100 observations\n",
      "1571 has 100 observations\n",
      "1581 has 100 observations\n",
      "1591 has 100 observations\n",
      "1601 has 100 observations\n",
      "1611 has 100 observations\n",
      "1621 has 100 observations\n",
      "1631 has 100 observations\n",
      "1641 has 100 observations\n",
      "1651 has 100 observations\n",
      "1661 has 100 observations\n",
      "1671 has 100 observations\n",
      "1681 has 100 observations\n",
      "1691 has 100 observations\n",
      "1701 has 100 observations\n",
      "1711 has 100 observations\n",
      "1721 has 100 observations\n",
      "1731 has 100 observations\n",
      "1741 has 100 observations\n",
      "1746 has 100 observations\n"
     ]
    }
   ],
   "source": [
    "# we make sure that harmonization of times and observations has been done\n",
    "for i in players_location.time.unique():\n",
    "    obs = len(players_location[players_location['time'] == i])\n",
    "    print(f'{i} has {obs} observations')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get Collaboration information"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>name</th>\n",
       "      <th>accountId</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>dxnub</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>spekture</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HITECHPLUMBER69</td>\n",
       "      <td>account.08c1815b804c4b1494002f149c6d6601</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Odmin</td>\n",
       "      <td>account.038f96e8563f4e03af57d48c684d7773</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>THE_IRONMAFIA</td>\n",
       "      <td>account.c7c9bf6dae124f5cb98cf581e0ce2c6d</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Neal_No1</td>\n",
       "      <td>account.98a361b6ee494c9c8ae2c3f739415a84</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>RUCY06</td>\n",
       "      <td>account.3d2c03735ec84f6c9ecaa0554aafead3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>WishLucy</td>\n",
       "      <td>account.ec1a36a3fd3c4847a2e7ea7e66696fde</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>IzaDiamond</td>\n",
       "      <td>account.95bd37bc6e7d45f0b230bbd037984adc</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AeJiGooYo</td>\n",
       "      <td>account.6606ff25e7834c94bec300a504f2f3f7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AwesomeSStarry</td>\n",
       "      <td>account.de4b6a5940884cbaaae74d2b0cb06c9f</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Wenurous</td>\n",
       "      <td>account.534e426ebc5643d781264f68e02f8adb</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Bougieee</td>\n",
       "      <td>account.674fcff6cf024d32a0c03f5109a163ba</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>boujeeeee</td>\n",
       "      <td>account.f0defe88915348408df0b547fecb3eb0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Youlaoban</td>\n",
       "      <td>account.c3d2339935824cdc9e55f9c7b575e355</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Tiamo_zer</td>\n",
       "      <td>account.2f3d0d46cd984fbabaf733f67b3c44da</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>DeathSs_LiuDeHua</td>\n",
       "      <td>account.93785a3f37e041ed8fe9221f9e8b9ca5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ChiWoDaDiao-</td>\n",
       "      <td>account.c2200a42a77349e582788e9a6081aeb4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>YEzi_YearSzy</td>\n",
       "      <td>account.9f0da77bfcab40149791be996d9e2e59</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>SLyx7cIOs</td>\n",
       "      <td>account.e4d70b1f31ce451fa55e46eb95278715</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>AEPs4O4</td>\n",
       "      <td>account.acd6626ba55f4f128e3395a627b4d2da</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Kev1nMo</td>\n",
       "      <td>account.6c124c8a6df840308d5ccd5324871b44</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>heysasa</td>\n",
       "      <td>account.e4464ed974c441bbaf5d75342810bcad</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Cadenn</td>\n",
       "      <td>account.fa20a446eea64586b4033135908d921a</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>L4_Desweet</td>\n",
       "      <td>account.4b0e221bb7b441218123956666fcc5c5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>AhYeahAhYeah</td>\n",
       "      <td>account.38fab72c58f74955b1cc6b780b1c7417</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Bubbabear85</td>\n",
       "      <td>account.50adcc0db4de465aa9ae3b726498f5c7</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>OMGNOWAYTHATSBS</td>\n",
       "      <td>account.54a138a899ea43919a51de65323d9287</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>MiracleMan74</td>\n",
       "      <td>account.0d8958712dab4d8da4ac5183f2c2385a</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>KILLer___AJ</td>\n",
       "      <td>account.824eb122d6a543d9a0e372ffc9657ecd</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>G7_WenG</td>\n",
       "      <td>account.0b4c6fd0d4d84cb69ad625fc35c87721</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>8255</td>\n",
       "      <td>account.f3c3476295344033b5f098651acc73e7</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>8344</td>\n",
       "      <td>account.ff1ec4f49b224de8a8107bc73fae0081</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>kfox7197</td>\n",
       "      <td>account.6edabfe353ef4a12835f740fcf198c76</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Bob_Roberts</td>\n",
       "      <td>account.aaccc75f95d5416ebf19960691dc13c6</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Solomon5968</td>\n",
       "      <td>account.d22cd0ef458c411caef12c9f5db9ea27</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>The_Bryonic_Man</td>\n",
       "      <td>account.e5be34fde69841ab9cf6b6681482d9d2</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>KQ_ZhanDouJi</td>\n",
       "      <td>account.22528554f5594e39aa5f7c150d7a97a0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Elessare</td>\n",
       "      <td>account.1750c61aa81441f6a9dcf81ed98196b6</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>duoduobaby0613</td>\n",
       "      <td>account.dfdb53bf20534cffa29b7207076923d2</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>7Burial</td>\n",
       "      <td>account.3759e2262f4c492cbd989527b78345b5</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>INOV77</td>\n",
       "      <td>account.ffad5b1280314f6dab6a48d6cf8cdf54</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Azarothe</td>\n",
       "      <td>account.c54691c19cfd49c1bbd3ce003104dc49</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Faxe99</td>\n",
       "      <td>account.eedb2af394cf40c2bc5809264a43df99</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>BLAVKMUSIKPCXB</td>\n",
       "      <td>account.c3baffb7b59f424cb8e0234e8a3d5542</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2092</td>\n",
       "      <td>account.c841a1c88ec54acebf3b216be19e3403</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>PannaCottaOVO</td>\n",
       "      <td>account.69a9a5bced8243a58b61099ba725f5d0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>D4NoK_Yz</td>\n",
       "      <td>account.a4f17373c02f477b8915db9b932a42d6</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>PinaColadaOVO</td>\n",
       "      <td>account.f2fd4ff371dc41dd8bb42449cd17ccaa</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Fudorin</td>\n",
       "      <td>account.6122a9daf65d448b930772a88651b53c</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Mondoja</td>\n",
       "      <td>account.430e7112176d4d849d2a873e19ec199e</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Dancingly</td>\n",
       "      <td>account.c4f12abe7d2143bdbb3d4a9ea4ccd31e</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>fuji_-_</td>\n",
       "      <td>account.ccf6080a643c43a098eef9911e09c6c2</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Jesse_yjho</td>\n",
       "      <td>account.6d4a5ce82af74fe8899746889a2de50c</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>mattbarn</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>LDrai29</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                name                                 accountId  teamId\n",
       "0              dxnub  account.f41a6e2001664439b818784d15ffc124       1\n",
       "1           Mac_1205  account.aae7ef8724284447953034a9ccbe89aa       1\n",
       "2           spekture  account.6b46d60583254839bf6e8c3df814f115       1\n",
       "3          Asin_Sira  account.154d4fd125a348e9a1f8df2daaabd9cb       1\n",
       "4    HITECHPLUMBER69  account.08c1815b804c4b1494002f149c6d6601       2\n",
       "5              Odmin  account.038f96e8563f4e03af57d48c684d7773       2\n",
       "6      THE_IRONMAFIA  account.c7c9bf6dae124f5cb98cf581e0ce2c6d       2\n",
       "7           Neal_No1  account.98a361b6ee494c9c8ae2c3f739415a84       2\n",
       "8             RUCY06  account.3d2c03735ec84f6c9ecaa0554aafead3       3\n",
       "9           WishLucy  account.ec1a36a3fd3c4847a2e7ea7e66696fde       3\n",
       "10        IzaDiamond  account.95bd37bc6e7d45f0b230bbd037984adc       3\n",
       "11         AeJiGooYo  account.6606ff25e7834c94bec300a504f2f3f7       3\n",
       "12    AwesomeSStarry  account.de4b6a5940884cbaaae74d2b0cb06c9f       4\n",
       "13          Wenurous  account.534e426ebc5643d781264f68e02f8adb       4\n",
       "14          Bougieee  account.674fcff6cf024d32a0c03f5109a163ba       4\n",
       "15         boujeeeee  account.f0defe88915348408df0b547fecb3eb0       4\n",
       "16         Youlaoban  account.c3d2339935824cdc9e55f9c7b575e355       5\n",
       "17         Tiamo_zer  account.2f3d0d46cd984fbabaf733f67b3c44da       5\n",
       "18  DeathSs_LiuDeHua  account.93785a3f37e041ed8fe9221f9e8b9ca5       5\n",
       "19      ChiWoDaDiao-  account.c2200a42a77349e582788e9a6081aeb4       5\n",
       "20      YEzi_YearSzy  account.9f0da77bfcab40149791be996d9e2e59       6\n",
       "21         SLyx7cIOs  account.e4d70b1f31ce451fa55e46eb95278715       6\n",
       "22           AEPs4O4  account.acd6626ba55f4f128e3395a627b4d2da       6\n",
       "23           Kev1nMo  account.6c124c8a6df840308d5ccd5324871b44       6\n",
       "24           heysasa  account.e4464ed974c441bbaf5d75342810bcad       7\n",
       "25            Cadenn  account.fa20a446eea64586b4033135908d921a       7\n",
       "26        L4_Desweet  account.4b0e221bb7b441218123956666fcc5c5       7\n",
       "27      AhYeahAhYeah  account.38fab72c58f74955b1cc6b780b1c7417       7\n",
       "28       Bubbabear85  account.50adcc0db4de465aa9ae3b726498f5c7       8\n",
       "29   OMGNOWAYTHATSBS  account.54a138a899ea43919a51de65323d9287       8\n",
       "..               ...                                       ...     ...\n",
       "70      MiracleMan74  account.0d8958712dab4d8da4ac5183f2c2385a      19\n",
       "71       KILLer___AJ  account.824eb122d6a543d9a0e372ffc9657ecd      20\n",
       "72           G7_WenG  account.0b4c6fd0d4d84cb69ad625fc35c87721      20\n",
       "73              8255  account.f3c3476295344033b5f098651acc73e7      20\n",
       "74              8344  account.ff1ec4f49b224de8a8107bc73fae0081      20\n",
       "75          kfox7197  account.6edabfe353ef4a12835f740fcf198c76      21\n",
       "76       Bob_Roberts  account.aaccc75f95d5416ebf19960691dc13c6      21\n",
       "77       Solomon5968  account.d22cd0ef458c411caef12c9f5db9ea27      21\n",
       "78   The_Bryonic_Man  account.e5be34fde69841ab9cf6b6681482d9d2      21\n",
       "79      KQ_ZhanDouJi  account.22528554f5594e39aa5f7c150d7a97a0      22\n",
       "80          Elessare  account.1750c61aa81441f6a9dcf81ed98196b6      22\n",
       "81    duoduobaby0613  account.dfdb53bf20534cffa29b7207076923d2      22\n",
       "82           7Burial  account.3759e2262f4c492cbd989527b78345b5      22\n",
       "83            INOV77  account.ffad5b1280314f6dab6a48d6cf8cdf54      23\n",
       "84          Azarothe  account.c54691c19cfd49c1bbd3ce003104dc49      23\n",
       "85            Faxe99  account.eedb2af394cf40c2bc5809264a43df99      23\n",
       "86    BLAVKMUSIKPCXB  account.c3baffb7b59f424cb8e0234e8a3d5542      23\n",
       "87              2092  account.c841a1c88ec54acebf3b216be19e3403      24\n",
       "88     PannaCottaOVO  account.69a9a5bced8243a58b61099ba725f5d0      24\n",
       "89          D4NoK_Yz  account.a4f17373c02f477b8915db9b932a42d6      24\n",
       "90     PinaColadaOVO  account.f2fd4ff371dc41dd8bb42449cd17ccaa      24\n",
       "91           Fudorin  account.6122a9daf65d448b930772a88651b53c      25\n",
       "92           Mondoja  account.430e7112176d4d849d2a873e19ec199e      25\n",
       "93         Dancingly  account.c4f12abe7d2143bdbb3d4a9ea4ccd31e      25\n",
       "94           fuji_-_  account.ccf6080a643c43a098eef9911e09c6c2      26\n",
       "95        Jesse_yjho  account.6d4a5ce82af74fe8899746889a2de50c      26\n",
       "96      HotDoggHands  account.1b9f91fb61504402b9774fcfa430e57e      27\n",
       "97          mattbarn  account.1093943b709c4a39b37343249ac8a65d      27\n",
       "98       Diesvtfocus  account.41435623c76a4bae90077cbce53601a3      27\n",
       "99           LDrai29  account.d9863a055ddd4cf8b192fc7a094692c3      27\n",
       "\n",
       "[100 rows x 3 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# encode player names\n",
    "# we do this to get the teamIds in the main dataframe\n",
    "players = data[['name', 'accountId','teamId']].drop_duplicates()\n",
    "players = players.sort_values('teamId').reset_index().drop(['index'], axis=1)\n",
    "players"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>name</th>\n",
       "      <th>location.x</th>\n",
       "      <th>location.y</th>\n",
       "      <th>inAircraft</th>\n",
       "      <th>accountId</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>254264</td>\n",
       "      <td>948862</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>254201</td>\n",
       "      <td>950985</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>443251</td>\n",
       "      <td>687020</td>\n",
       "      <td>1</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>spekture</td>\n",
       "      <td>254157</td>\n",
       "      <td>952488</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>258465</td>\n",
       "      <td>805831</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   time       name location.x location.y  inAircraft  \\\n",
       "0     1  Asin_Sira     254264     948862           0   \n",
       "1     1   Mac_1205     254201     950985           0   \n",
       "2     1      dxnub     443251     687020           1   \n",
       "3     1   spekture     254157     952488           0   \n",
       "4    11  Asin_Sira     258465     805831           0   \n",
       "\n",
       "                                  accountId  teamId  \n",
       "0  account.154d4fd125a348e9a1f8df2daaabd9cb       1  \n",
       "1  account.aae7ef8724284447953034a9ccbe89aa       1  \n",
       "2  account.f41a6e2001664439b818784d15ffc124       1  \n",
       "3  account.6b46d60583254839bf6e8c3df814f115       1  \n",
       "4  account.154d4fd125a348e9a1f8df2daaabd9cb       1  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# we merge these names to get accountId and teamId in the dataframe\n",
    "players_location = pd.merge(players_location,\n",
    "                            players,\n",
    "                            left_on = 'name',\n",
    "                            right_on = 'name',\n",
    "                            how = 'left')\n",
    "# moreover, since we are goint to later \"asign\" a number to the players (e.g. player1, player2), we want to make sure\n",
    "# that the criteria is consistent for all teams. Therefore, we do it with the .sort_values method\n",
    "# players on each team are ordered with this method inside the team\n",
    "players_location = players_location[players_location['time'] >= 0].sort_values(['teamId','time', 'name']).reset_index().drop(['index'], axis=1)\n",
    "players_location.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "players_location = players_location.replace('dead',0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>name</th>\n",
       "      <th>location.x</th>\n",
       "      <th>location.y</th>\n",
       "      <th>inAircraft</th>\n",
       "      <th>accountId</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>254</td>\n",
       "      <td>948</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>254</td>\n",
       "      <td>950</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>443</td>\n",
       "      <td>687</td>\n",
       "      <td>1</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>spekture</td>\n",
       "      <td>254</td>\n",
       "      <td>952</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>258</td>\n",
       "      <td>805</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   time       name  location.x  location.y  inAircraft  \\\n",
       "0     1  Asin_Sira         254         948           0   \n",
       "1     1   Mac_1205         254         950           0   \n",
       "2     1      dxnub         443         687           1   \n",
       "3     1   spekture         254         952           0   \n",
       "4    11  Asin_Sira         258         805           0   \n",
       "\n",
       "                                  accountId  teamId  \n",
       "0  account.154d4fd125a348e9a1f8df2daaabd9cb       1  \n",
       "1  account.aae7ef8724284447953034a9ccbe89aa       1  \n",
       "2  account.f41a6e2001664439b818784d15ffc124       1  \n",
       "3  account.6b46d60583254839bf6e8c3df814f115       1  \n",
       "4  account.154d4fd125a348e9a1f8df2daaabd9cb       1  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert to 10 meters from cms\n",
    "players_location[['location.x','location.y']] = players_location[['location.x','location.y']].apply(lambda x: x.astype(int))\n",
    "players_location[['location.x','location.y']] = players_location[['location.x','location.y']].apply(lambda x: x // 1000)\n",
    "players_location.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>location.x</th>\n",
       "      <th>location.y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>254</td>\n",
       "      <td>948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>254</td>\n",
       "      <td>950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>443</td>\n",
       "      <td>687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>254</td>\n",
       "      <td>952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>258</td>\n",
       "      <td>805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>258</td>\n",
       "      <td>807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>258</td>\n",
       "      <td>812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>258</td>\n",
       "      <td>808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>262</td>\n",
       "      <td>664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>262</td>\n",
       "      <td>666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>262</td>\n",
       "      <td>661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>262</td>\n",
       "      <td>667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>266</td>\n",
       "      <td>523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>266</td>\n",
       "      <td>525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>266</td>\n",
       "      <td>523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>266</td>\n",
       "      <td>526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>282</td>\n",
       "      <td>454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>283</td>\n",
       "      <td>457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>293</td>\n",
       "      <td>472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>268</td>\n",
       "      <td>468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>327</td>\n",
       "      <td>446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>331</td>\n",
       "      <td>447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>333</td>\n",
       "      <td>454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>272</td>\n",
       "      <td>467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>358</td>\n",
       "      <td>440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>352</td>\n",
       "      <td>442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>353</td>\n",
       "      <td>445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>296</td>\n",
       "      <td>460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>366</td>\n",
       "      <td>442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>363</td>\n",
       "      <td>440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17570</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17571</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17572</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17573</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17574</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17575</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17576</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17577</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17578</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17579</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17580</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17581</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17582</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17583</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17584</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17585</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17586</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17587</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17588</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17589</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17590</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17591</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17592</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17593</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17594</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17595</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17596</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17597</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17598</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17599</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17600 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       location.x  location.y\n",
       "0             254         948\n",
       "1             254         950\n",
       "2             443         687\n",
       "3             254         952\n",
       "4             258         805\n",
       "5             258         807\n",
       "6             258         812\n",
       "7             258         808\n",
       "8             262         664\n",
       "9             262         666\n",
       "10            262         661\n",
       "11            262         667\n",
       "12            266         523\n",
       "13            266         525\n",
       "14            266         523\n",
       "15            266         526\n",
       "16            282         454\n",
       "17            283         457\n",
       "18            293         472\n",
       "19            268         468\n",
       "20            327         446\n",
       "21            331         447\n",
       "22            333         454\n",
       "23            272         467\n",
       "24            358         440\n",
       "25            352         442\n",
       "26            353         445\n",
       "27            296         460\n",
       "28            366         442\n",
       "29            363         440\n",
       "...           ...         ...\n",
       "17570           0           0\n",
       "17571           0           0\n",
       "17572           0           0\n",
       "17573           0           0\n",
       "17574           0           0\n",
       "17575           0           0\n",
       "17576           0           0\n",
       "17577           0           0\n",
       "17578           0           0\n",
       "17579           0           0\n",
       "17580           0           0\n",
       "17581           0           0\n",
       "17582           0           0\n",
       "17583           0           0\n",
       "17584           0           0\n",
       "17585           0           0\n",
       "17586           0           0\n",
       "17587           0           0\n",
       "17588           0           0\n",
       "17589           0           0\n",
       "17590           0           0\n",
       "17591           0           0\n",
       "17592           0           0\n",
       "17593           0           0\n",
       "17594           0           0\n",
       "17595           0           0\n",
       "17596           0           0\n",
       "17597           0           0\n",
       "17598           0           0\n",
       "17599           0           0\n",
       "\n",
       "[17600 rows x 2 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = players_location[['location.x','location.y']]\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(254, 948),\n",
       " (254, 950),\n",
       " (443, 687),\n",
       " (254, 952),\n",
       " (258, 805),\n",
       " (258, 807),\n",
       " (258, 812),\n",
       " (258, 808),\n",
       " (262, 664),\n",
       " (262, 666),\n",
       " (262, 661),\n",
       " (262, 667),\n",
       " (266, 523),\n",
       " (266, 525),\n",
       " (266, 523),\n",
       " (266, 526),\n",
       " (282, 454),\n",
       " (283, 457),\n",
       " (293, 472),\n",
       " (268, 468),\n",
       " (327, 446),\n",
       " (331, 447),\n",
       " (333, 454),\n",
       " (272, 467),\n",
       " (358, 440),\n",
       " (352, 442),\n",
       " (353, 445),\n",
       " (296, 460),\n",
       " (366, 442),\n",
       " (363, 440),\n",
       " (362, 441),\n",
       " (288, 453),\n",
       " (366, 438),\n",
       " (370, 441),\n",
       " (365, 439),\n",
       " (288, 450),\n",
       " (366, 439),\n",
       " (369, 442),\n",
       " (366, 439),\n",
       " (296, 448),\n",
       " (366, 438),\n",
       " (370, 442),\n",
       " (365, 440),\n",
       " (296, 450),\n",
       " (365, 440),\n",
       " (369, 442),\n",
       " (365, 440),\n",
       " (298, 451),\n",
       " (366, 439),\n",
       " (369, 442),\n",
       " (365, 440),\n",
       " (296, 452),\n",
       " (366, 438),\n",
       " (367, 440),\n",
       " (365, 440),\n",
       " (294, 450),\n",
       " (366, 438),\n",
       " (365, 440),\n",
       " (365, 440),\n",
       " (296, 453),\n",
       " (366, 438),\n",
       " (365, 440),\n",
       " (365, 440),\n",
       " (305, 453),\n",
       " (366, 438),\n",
       " (365, 439),\n",
       " (365, 440),\n",
       " (327, 451),\n",
       " (366, 438),\n",
       " (365, 439),\n",
       " (365, 440),\n",
       " (343, 450),\n",
       " (366, 438),\n",
       " (365, 439),\n",
       " (0, 0),\n",
       " (358, 442),\n",
       " (366, 438),\n",
       " (365, 439),\n",
       " (0, 0),\n",
       " (367, 436),\n",
       " (366, 438),\n",
       " (365, 439),\n",
       " (0, 0),\n",
       " (366, 437),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (366, 439),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (0, 0),\n",
       " (412, 728),\n",
       " (254, 949),\n",
       " (254, 955),\n",
       " (254, 945),\n",
       " (258, 808),\n",
       " (258, 806),\n",
       " (258, 811),\n",
       " (258, 803),\n",
       " (262, 668),\n",
       " (262, 665),\n",
       " (262, 656),\n",
       " (262, 661),\n",
       " (266, 526),\n",
       " (266, 524),\n",
       " (266, 515),\n",
       " (266, 520),\n",
       " (271, 373),\n",
       " (270, 383),\n",
       " (271, 375),\n",
       " (270, 380),\n",
       " (276, 259),\n",
       " (274, 262),\n",
       " (275, 242),\n",
       " (274, 243),\n",
       " (314, 235),\n",
       " (313, 243),\n",
       " (287, 175),\n",
       " (277, 239),\n",
       " (357, 220),\n",
       " (354, 227),\n",
       " (331, 178),\n",
       " (302, 233),\n",
       " (382, 211),\n",
       " (378, 218),\n",
       " (374, 182),\n",
       " (312, 229),\n",
       " (396, 207),\n",
       " (391, 213),\n",
       " (391, 183),\n",
       " (318, 227),\n",
       " (408, 203),\n",
       " (404, 209),\n",
       " (401, 183),\n",
       " (330, 224),\n",
       " (419, 199),\n",
       " (418, 205),\n",
       " (398, 181),\n",
       " (337, 222),\n",
       " (425, 197),\n",
       " (428, 200),\n",
       " (394, 179),\n",
       " (342, 216),\n",
       " (425, 195),\n",
       " (429, 200),\n",
       " (394, 179),\n",
       " (341, 217),\n",
       " (424, 195),\n",
       " (430, 200),\n",
       " (393, 180),\n",
       " (341, 217),\n",
       " (423, 194),\n",
       " (430, 199),\n",
       " (392, 181),\n",
       " (341, 216),\n",
       " (424, 192),\n",
       " (431, 200),\n",
       " (390, 181),\n",
       " (342, 218),\n",
       " (425, 192),\n",
       " (431, 200),\n",
       " (389, 181),\n",
       " (343, 218),\n",
       " (424, 189),\n",
       " (434, 199),\n",
       " (389, 181),\n",
       " (341, 219),\n",
       " (424, 188),\n",
       " (434, 198),\n",
       " (390, 183),\n",
       " (341, 220),\n",
       " (424, 189),\n",
       " (435, 198),\n",
       " (389, 183),\n",
       " (350, 217),\n",
       " (424, 187),\n",
       " (436, 198),\n",
       " (389, 183),\n",
       " (363, 214),\n",
       " (424, 187),\n",
       " (435, 196),\n",
       " (389, 183),\n",
       " (377, 208),\n",
       " (424, 185),\n",
       " (436, 196),\n",
       " (389, 182),\n",
       " (393, 202),\n",
       " (424, 183),\n",
       " (435, 192),\n",
       " (389, 182),\n",
       " (413, 197),\n",
       " (424, 183),\n",
       " (435, 190),\n",
       " (388, 182),\n",
       " (423, 194),\n",
       " (424, 182),\n",
       " (436, 189),\n",
       " (387, 180),\n",
       " (428, 194),\n",
       " (425, 178),\n",
       " (435, 187),\n",
       " (388, 176),\n",
       " (432, 195),\n",
       " (427, 178),\n",
       " (436, 185),\n",
       " (387, 176),\n",
       " (434, 196),\n",
       " (428, 176),\n",
       " (435, 183),\n",
       " (386, 177),\n",
       " (435, 196),\n",
       " (427, 175),\n",
       " (435, 182),\n",
       " (386, 176),\n",
       " (435, 196),\n",
       " (428, 176),\n",
       " (436, 181),\n",
       " (384, 177),\n",
       " (434, 195),\n",
       " (429, 180),\n",
       " (433, 183),\n",
       " (384, 175),\n",
       " (433, 194),\n",
       " (427, 183),\n",
       " (431, 185),\n",
       " (385, 173),\n",
       " (433, 189),\n",
       " (429, 184),\n",
       " (431, 184),\n",
       " (385, 173),\n",
       " (431, 186),\n",
       " (429, 184),\n",
       " (429, 184),\n",
       " (386, 172),\n",
       " (430, 184),\n",
       " (427, 184),\n",
       " (428, 184),\n",
       " (387, 172),\n",
       " (429, 184),\n",
       " (427, 185),\n",
       " (427, 184),\n",
       " (387, 172),\n",
       " (428, 184),\n",
       " (427, 185),\n",
       " (427, 185),\n",
       " (387, 172),\n",
       " (427, 184),\n",
       " (427, 185),\n",
       " (427, 189),\n",
       " (387, 173),\n",
       " (427, 184),\n",
       " (428, 186),\n",
       " (427, 194),\n",
       " (383, 174),\n",
       " (427, 186),\n",
       " (429, 186),\n",
       " (427, 199),\n",
       " (379, 175),\n",
       " (427, 187),\n",
       " (429, 186),\n",
       " (430, 202),\n",
       " (377, 176),\n",
       " (428, 187),\n",
       " (430, 186),\n",
       " (432, 206),\n",
       " (376, 177),\n",
       " (430, 187),\n",
       " (430, 186),\n",
       " (432, 212),\n",
       " (379, 178),\n",
       " (432, 185),\n",
       " (430, 186),\n",
       " (432, 214),\n",
       " (385, 179),\n",
       " (430, 183),\n",
       " (428, 186),\n",
       " (431, 217),\n",
       " (389, 178),\n",
       " (428, 183),\n",
       " (428, 187),\n",
       " (432, 220),\n",
       " (381, 178),\n",
       " (428, 184),\n",
       " (429, 189),\n",
       " (433, 221),\n",
       " (360, 178),\n",
       " (428, 184),\n",
       " (429, 191),\n",
       " (433, 222),\n",
       " (349, 182),\n",
       " (428, 184),\n",
       " (428, 191),\n",
       " (434, 225),\n",
       " (346, 184),\n",
       " (428, 184),\n",
       " (427, 192),\n",
       " (437, 230),\n",
       " (346, 184),\n",
       " (428, 184),\n",
       " (429, 195),\n",
       " (440, 236),\n",
       " (346, 184),\n",
       " (428, 184),\n",
       " (430, 197),\n",
       " (440, 239),\n",
       " (345, 183),\n",
       " (429, 184),\n",
       " (430, 200),\n",
       " (441, 240),\n",
       " (341, 182),\n",
       " (430, 184),\n",
       " (430, 204),\n",
       " (442, 240),\n",
       " (340, 180),\n",
       " (431, 185),\n",
       " (431, 209),\n",
       " (443, 240),\n",
       " (339, 180),\n",
       " (432, 189),\n",
       " (432, 215),\n",
       " (447, 241),\n",
       " (340, 182),\n",
       " (432, 194),\n",
       " (432, 219),\n",
       " (449, 240),\n",
       " (344, 181),\n",
       " (432, 201),\n",
       " (433, 221),\n",
       " (449, 240),\n",
       " (350, 181),\n",
       " (432, 203),\n",
       " (432, 222),\n",
       " (448, 241),\n",
       " (367, 189),\n",
       " (433, 203),\n",
       " (434, 225),\n",
       " (449, 239),\n",
       " (387, 200),\n",
       " (433, 206),\n",
       " (437, 229),\n",
       " (448, 237),\n",
       " (408, 214),\n",
       " (433, 207),\n",
       " (440, 233),\n",
       " (451, 238),\n",
       " (426, 224),\n",
       " (433, 207),\n",
       " (442, 236),\n",
       " (450, 236),\n",
       " (447, 233),\n",
       " (434, 210),\n",
       " (442, 236),\n",
       " (449, 235),\n",
       " (447, 235),\n",
       " (434, 215),\n",
       " (442, 236),\n",
       " (448, 234),\n",
       " (443, 236),\n",
       " (437, 220),\n",
       " (442, 236),\n",
       " (457, 223),\n",
       " (442, 236),\n",
       " (438, 226),\n",
       " (442, 236),\n",
       " (461, 219),\n",
       " (443, 236),\n",
       " (440, 232),\n",
       " (444, 236),\n",
       " (463, 219),\n",
       " (444, 237),\n",
       " (442, 236),\n",
       " (447, 237),\n",
       " (463, 219),\n",
       " (445, 237),\n",
       " (442, 236),\n",
       " (451, 239),\n",
       " (461, 219),\n",
       " (443, 240),\n",
       " (442, 236),\n",
       " (450, 238),\n",
       " (461, 219),\n",
       " (442, 240),\n",
       " (443, 236),\n",
       " (449, 238),\n",
       " (460, 220),\n",
       " (442, 241),\n",
       " (444, 237),\n",
       " ...]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert df to list of tuples\n",
    "records = data.to_records(index=False)\n",
    "result = list(records)\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>risk</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   risk\n",
       "0     0\n",
       "1     0\n",
       "2     0\n",
       "3     0\n",
       "4     0"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cols = ['risk']\n",
    "lst = []\n",
    "\n",
    "for i in result:\n",
    "    risklevel(*i, mapname=mn)\n",
    "\n",
    "    \n",
    "    \n",
    "riskordered = pd.DataFrame(lst, columns=cols)\n",
    "riskordered.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>name</th>\n",
       "      <th>location.x</th>\n",
       "      <th>location.y</th>\n",
       "      <th>inAircraft</th>\n",
       "      <th>accountId</th>\n",
       "      <th>teamId</th>\n",
       "      <th>risk</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>254</td>\n",
       "      <td>948</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>254</td>\n",
       "      <td>950</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>443</td>\n",
       "      <td>687</td>\n",
       "      <td>1</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>spekture</td>\n",
       "      <td>254</td>\n",
       "      <td>952</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>258</td>\n",
       "      <td>805</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>258</td>\n",
       "      <td>807</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>11</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>258</td>\n",
       "      <td>812</td>\n",
       "      <td>1</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>11</td>\n",
       "      <td>spekture</td>\n",
       "      <td>258</td>\n",
       "      <td>808</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>21</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>262</td>\n",
       "      <td>664</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>21</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>262</td>\n",
       "      <td>666</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>21</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>262</td>\n",
       "      <td>661</td>\n",
       "      <td>1</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>21</td>\n",
       "      <td>spekture</td>\n",
       "      <td>262</td>\n",
       "      <td>667</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>31</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>266</td>\n",
       "      <td>523</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>31</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>266</td>\n",
       "      <td>525</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>31</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>266</td>\n",
       "      <td>523</td>\n",
       "      <td>0</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>31</td>\n",
       "      <td>spekture</td>\n",
       "      <td>266</td>\n",
       "      <td>526</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>41</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>282</td>\n",
       "      <td>454</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>41</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>283</td>\n",
       "      <td>457</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>41</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>293</td>\n",
       "      <td>472</td>\n",
       "      <td>0</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>41</td>\n",
       "      <td>spekture</td>\n",
       "      <td>268</td>\n",
       "      <td>468</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>51</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>327</td>\n",
       "      <td>446</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>51</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>331</td>\n",
       "      <td>447</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>51</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>333</td>\n",
       "      <td>454</td>\n",
       "      <td>0</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>51</td>\n",
       "      <td>spekture</td>\n",
       "      <td>272</td>\n",
       "      <td>467</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>61</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>358</td>\n",
       "      <td>440</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>61</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>352</td>\n",
       "      <td>442</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>61</td>\n",
       "      <td>dxnub</td>\n",
       "      <td>353</td>\n",
       "      <td>445</td>\n",
       "      <td>0</td>\n",
       "      <td>account.f41a6e2001664439b818784d15ffc124</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>61</td>\n",
       "      <td>spekture</td>\n",
       "      <td>296</td>\n",
       "      <td>460</td>\n",
       "      <td>0</td>\n",
       "      <td>account.6b46d60583254839bf6e8c3df814f115</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>71</td>\n",
       "      <td>Asin_Sira</td>\n",
       "      <td>366</td>\n",
       "      <td>442</td>\n",
       "      <td>0</td>\n",
       "      <td>account.154d4fd125a348e9a1f8df2daaabd9cb</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>71</td>\n",
       "      <td>Mac_1205</td>\n",
       "      <td>363</td>\n",
       "      <td>440</td>\n",
       "      <td>0</td>\n",
       "      <td>account.aae7ef8724284447953034a9ccbe89aa</td>\n",
       "      <td>1</td>\n",
       "      <td>2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17570</th>\n",
       "      <td>1681</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17571</th>\n",
       "      <td>1681</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17572</th>\n",
       "      <td>1691</td>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17573</th>\n",
       "      <td>1691</td>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17574</th>\n",
       "      <td>1691</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17575</th>\n",
       "      <td>1691</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17576</th>\n",
       "      <td>1701</td>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17577</th>\n",
       "      <td>1701</td>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17578</th>\n",
       "      <td>1701</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17579</th>\n",
       "      <td>1701</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17580</th>\n",
       "      <td>1711</td>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17581</th>\n",
       "      <td>1711</td>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17582</th>\n",
       "      <td>1711</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17583</th>\n",
       "      <td>1711</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17584</th>\n",
       "      <td>1721</td>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17585</th>\n",
       "      <td>1721</td>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17586</th>\n",
       "      <td>1721</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17587</th>\n",
       "      <td>1721</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17588</th>\n",
       "      <td>1731</td>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17589</th>\n",
       "      <td>1731</td>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17590</th>\n",
       "      <td>1731</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17591</th>\n",
       "      <td>1731</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17592</th>\n",
       "      <td>1741</td>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17593</th>\n",
       "      <td>1741</td>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17594</th>\n",
       "      <td>1741</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17595</th>\n",
       "      <td>1741</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17596</th>\n",
       "      <td>1746</td>\n",
       "      <td>Diesvtfocus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.41435623c76a4bae90077cbce53601a3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17597</th>\n",
       "      <td>1746</td>\n",
       "      <td>HotDoggHands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1b9f91fb61504402b9774fcfa430e57e</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17598</th>\n",
       "      <td>1746</td>\n",
       "      <td>LDrai29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.d9863a055ddd4cf8b192fc7a094692c3</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17599</th>\n",
       "      <td>1746</td>\n",
       "      <td>mattbarn</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>account.1093943b709c4a39b37343249ac8a65d</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17600 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       time          name  location.x  location.y  inAircraft  \\\n",
       "0         1     Asin_Sira         254         948           0   \n",
       "1         1      Mac_1205         254         950           0   \n",
       "2         1         dxnub         443         687           1   \n",
       "3         1      spekture         254         952           0   \n",
       "4        11     Asin_Sira         258         805           0   \n",
       "5        11      Mac_1205         258         807           0   \n",
       "6        11         dxnub         258         812           1   \n",
       "7        11      spekture         258         808           0   \n",
       "8        21     Asin_Sira         262         664           0   \n",
       "9        21      Mac_1205         262         666           0   \n",
       "10       21         dxnub         262         661           1   \n",
       "11       21      spekture         262         667           0   \n",
       "12       31     Asin_Sira         266         523           0   \n",
       "13       31      Mac_1205         266         525           0   \n",
       "14       31         dxnub         266         523           0   \n",
       "15       31      spekture         266         526           0   \n",
       "16       41     Asin_Sira         282         454           0   \n",
       "17       41      Mac_1205         283         457           0   \n",
       "18       41         dxnub         293         472           0   \n",
       "19       41      spekture         268         468           0   \n",
       "20       51     Asin_Sira         327         446           0   \n",
       "21       51      Mac_1205         331         447           0   \n",
       "22       51         dxnub         333         454           0   \n",
       "23       51      spekture         272         467           0   \n",
       "24       61     Asin_Sira         358         440           0   \n",
       "25       61      Mac_1205         352         442           0   \n",
       "26       61         dxnub         353         445           0   \n",
       "27       61      spekture         296         460           0   \n",
       "28       71     Asin_Sira         366         442           0   \n",
       "29       71      Mac_1205         363         440           0   \n",
       "...     ...           ...         ...         ...         ...   \n",
       "17570  1681       LDrai29           0           0           0   \n",
       "17571  1681      mattbarn           0           0           0   \n",
       "17572  1691   Diesvtfocus           0           0           0   \n",
       "17573  1691  HotDoggHands           0           0           0   \n",
       "17574  1691       LDrai29           0           0           0   \n",
       "17575  1691      mattbarn           0           0           0   \n",
       "17576  1701   Diesvtfocus           0           0           0   \n",
       "17577  1701  HotDoggHands           0           0           0   \n",
       "17578  1701       LDrai29           0           0           0   \n",
       "17579  1701      mattbarn           0           0           0   \n",
       "17580  1711   Diesvtfocus           0           0           0   \n",
       "17581  1711  HotDoggHands           0           0           0   \n",
       "17582  1711       LDrai29           0           0           0   \n",
       "17583  1711      mattbarn           0           0           0   \n",
       "17584  1721   Diesvtfocus           0           0           0   \n",
       "17585  1721  HotDoggHands           0           0           0   \n",
       "17586  1721       LDrai29           0           0           0   \n",
       "17587  1721      mattbarn           0           0           0   \n",
       "17588  1731   Diesvtfocus           0           0           0   \n",
       "17589  1731  HotDoggHands           0           0           0   \n",
       "17590  1731       LDrai29           0           0           0   \n",
       "17591  1731      mattbarn           0           0           0   \n",
       "17592  1741   Diesvtfocus           0           0           0   \n",
       "17593  1741  HotDoggHands           0           0           0   \n",
       "17594  1741       LDrai29           0           0           0   \n",
       "17595  1741      mattbarn           0           0           0   \n",
       "17596  1746   Diesvtfocus           0           0           0   \n",
       "17597  1746  HotDoggHands           0           0           0   \n",
       "17598  1746       LDrai29           0           0           0   \n",
       "17599  1746      mattbarn           0           0           0   \n",
       "\n",
       "                                      accountId  teamId  risk  \n",
       "0      account.154d4fd125a348e9a1f8df2daaabd9cb       1     0  \n",
       "1      account.aae7ef8724284447953034a9ccbe89aa       1     0  \n",
       "2      account.f41a6e2001664439b818784d15ffc124       1     0  \n",
       "3      account.6b46d60583254839bf6e8c3df814f115       1     0  \n",
       "4      account.154d4fd125a348e9a1f8df2daaabd9cb       1     0  \n",
       "5      account.aae7ef8724284447953034a9ccbe89aa       1     0  \n",
       "6      account.f41a6e2001664439b818784d15ffc124       1     0  \n",
       "7      account.6b46d60583254839bf6e8c3df814f115       1     0  \n",
       "8      account.154d4fd125a348e9a1f8df2daaabd9cb       1     0  \n",
       "9      account.aae7ef8724284447953034a9ccbe89aa       1     0  \n",
       "10     account.f41a6e2001664439b818784d15ffc124       1     0  \n",
       "11     account.6b46d60583254839bf6e8c3df814f115       1     0  \n",
       "12     account.154d4fd125a348e9a1f8df2daaabd9cb       1     1  \n",
       "13     account.aae7ef8724284447953034a9ccbe89aa       1     0  \n",
       "14     account.f41a6e2001664439b818784d15ffc124       1     1  \n",
       "15     account.6b46d60583254839bf6e8c3df814f115       1     0  \n",
       "16     account.154d4fd125a348e9a1f8df2daaabd9cb       1     0  \n",
       "17     account.aae7ef8724284447953034a9ccbe89aa       1     0  \n",
       "18     account.f41a6e2001664439b818784d15ffc124       1     0  \n",
       "19     account.6b46d60583254839bf6e8c3df814f115       1     0  \n",
       "20     account.154d4fd125a348e9a1f8df2daaabd9cb       1     0  \n",
       "21     account.aae7ef8724284447953034a9ccbe89aa       1     0  \n",
       "22     account.f41a6e2001664439b818784d15ffc124       1     0  \n",
       "23     account.6b46d60583254839bf6e8c3df814f115       1     0  \n",
       "24     account.154d4fd125a348e9a1f8df2daaabd9cb       1     0  \n",
       "25     account.aae7ef8724284447953034a9ccbe89aa       1     0  \n",
       "26     account.f41a6e2001664439b818784d15ffc124       1     0  \n",
       "27     account.6b46d60583254839bf6e8c3df814f115       1     0  \n",
       "28     account.154d4fd125a348e9a1f8df2daaabd9cb       1     9  \n",
       "29     account.aae7ef8724284447953034a9ccbe89aa       1     2  \n",
       "...                                         ...     ...   ...  \n",
       "17570  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17571  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "17572  account.41435623c76a4bae90077cbce53601a3      27     0  \n",
       "17573  account.1b9f91fb61504402b9774fcfa430e57e      27     0  \n",
       "17574  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17575  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "17576  account.41435623c76a4bae90077cbce53601a3      27     0  \n",
       "17577  account.1b9f91fb61504402b9774fcfa430e57e      27     0  \n",
       "17578  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17579  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "17580  account.41435623c76a4bae90077cbce53601a3      27     0  \n",
       "17581  account.1b9f91fb61504402b9774fcfa430e57e      27     0  \n",
       "17582  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17583  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "17584  account.41435623c76a4bae90077cbce53601a3      27     0  \n",
       "17585  account.1b9f91fb61504402b9774fcfa430e57e      27     0  \n",
       "17586  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17587  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "17588  account.41435623c76a4bae90077cbce53601a3      27     0  \n",
       "17589  account.1b9f91fb61504402b9774fcfa430e57e      27     0  \n",
       "17590  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17591  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "17592  account.41435623c76a4bae90077cbce53601a3      27     0  \n",
       "17593  account.1b9f91fb61504402b9774fcfa430e57e      27     0  \n",
       "17594  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17595  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "17596  account.41435623c76a4bae90077cbce53601a3      27     0  \n",
       "17597  account.1b9f91fb61504402b9774fcfa430e57e      27     0  \n",
       "17598  account.d9863a055ddd4cf8b192fc7a094692c3      27     0  \n",
       "17599  account.1093943b709c4a39b37343249ac8a65d      27     0  \n",
       "\n",
       "[17600 rows x 8 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.concat([players_location, riskordered], axis=1, sort=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Export to .csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "# export match telemetry data into .csv format\n",
    "players_location.to_csv(path_or_buf=f'{matchid}.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}