robocupsimdata_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Cleaning RoboCupSimData\n",
    "\n",
    "## About RoboCup\n",
    "[RoboCup](https://www.robocup.org/) is an international scientific robot competition in which teams of multiple robots compete against each other. Its different leagues provide many sources of robotics data, that can be used for further analysis and application of machine learning.\n",
    "\n",
    "## Objectives\n",
    "This project intends to clean the dataset in order to make it more easy to work with in *soccer analysis* projects.\n",
    "\n",
    "## Data\n",
    "### Input\n",
    "  * */data/input/groundtruth.csv*: CSV file from RoboCupSimData project ([Paper](https://arxiv.org/pdf/1711.01703.pdf)) ([Files Overview](http://oliver.obst.eu/data/RoboCupSimData/overview.html)). In this project, we used a *groundtruth* file from an example game between Gliders2016 and HELIOS2016, winner and runner up of RoboCup 2016. This file recorded for each time point the play mode (e.g. kickoff), the current ball position coordinates and its velocity. Furthermore, the positions and velocities of each player of the left (L) and the right (R) team including the goalkeeper (G) is stated.\n",
    "\n",
    "### Output\n",
    "  * */data/output/groundtruth_cleaned.csv*: Dataset cleaned\n",
    "\n",
    "## Sources\n",
    "  * [xyFootyPy](https://github.com/znstrider/xyFootyPy)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Imports\n",
    "import pandas as pd\n",
    "import re\n",
    "from IPython.display import display, Markdown as md\n",
    "\n",
    "# Config\n",
    "pd.options.display.max_columns = None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/markdown": [
       "**Initial** DataFrame shape: (6329, 184)"
      ],
      "text/plain": [
       "<IPython.core.display.Markdown object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>playmode</th>\n",
       "      <th>score left</th>\n",
       "      <th>score right</th>\n",
       "      <th>ball_x</th>\n",
       "      <th>ball_y</th>\n",
       "      <th>ball_vx</th>\n",
       "      <th>ball_vy</th>\n",
       "      <th>LG1 x</th>\n",
       "      <th>LG1 y</th>\n",
       "      <th>LG1 vx</th>\n",
       "      <th>LG1 vy</th>\n",
       "      <th>LG1 body</th>\n",
       "      <th>LG1 head</th>\n",
       "      <th>LG1 vieww</th>\n",
       "      <th>LG1 viewq</th>\n",
       "      <th>L2 x</th>\n",
       "      <th>L2 y</th>\n",
       "      <th>L2 vx</th>\n",
       "      <th>L2 vy</th>\n",
       "      <th>L2 body</th>\n",
       "      <th>L2 head</th>\n",
       "      <th>L2 vieww</th>\n",
       "      <th>L2 viewq</th>\n",
       "      <th>L3 x</th>\n",
       "      <th>L3 y</th>\n",
       "      <th>L3 vx</th>\n",
       "      <th>L3 vy</th>\n",
       "      <th>L3 body</th>\n",
       "      <th>L3 head</th>\n",
       "      <th>L3 vieww</th>\n",
       "      <th>L3 viewq</th>\n",
       "      <th>L4 x</th>\n",
       "      <th>L4 y</th>\n",
       "      <th>L4 vx</th>\n",
       "      <th>L4 vy</th>\n",
       "      <th>L4 body</th>\n",
       "      <th>L4 head</th>\n",
       "      <th>L4 vieww</th>\n",
       "      <th>L4 viewq</th>\n",
       "      <th>L5 x</th>\n",
       "      <th>L5 y</th>\n",
       "      <th>L5 vx</th>\n",
       "      <th>L5 vy</th>\n",
       "      <th>L5 body</th>\n",
       "      <th>L5 head</th>\n",
       "      <th>L5 vieww</th>\n",
       "      <th>L5 viewq</th>\n",
       "      <th>L6 x</th>\n",
       "      <th>L6 y</th>\n",
       "      <th>L6 vx</th>\n",
       "      <th>L6 vy</th>\n",
       "      <th>L6 body</th>\n",
       "      <th>L6 head</th>\n",
       "      <th>L6 vieww</th>\n",
       "      <th>L6 viewq</th>\n",
       "      <th>L7 x</th>\n",
       "      <th>L7 y</th>\n",
       "      <th>L7 vx</th>\n",
       "      <th>L7 vy</th>\n",
       "      <th>L7 body</th>\n",
       "      <th>L7 head</th>\n",
       "      <th>L7 vieww</th>\n",
       "      <th>L7 viewq</th>\n",
       "      <th>L8 x</th>\n",
       "      <th>L8 y</th>\n",
       "      <th>L8 vx</th>\n",
       "      <th>L8 vy</th>\n",
       "      <th>L8 body</th>\n",
       "      <th>L8 head</th>\n",
       "      <th>L8 vieww</th>\n",
       "      <th>L8 viewq</th>\n",
       "      <th>L9 x</th>\n",
       "      <th>L9 y</th>\n",
       "      <th>L9 vx</th>\n",
       "      <th>L9 vy</th>\n",
       "      <th>L9 body</th>\n",
       "      <th>L9 head</th>\n",
       "      <th>L9 vieww</th>\n",
       "      <th>L9 viewq</th>\n",
       "      <th>L10 x</th>\n",
       "      <th>L10 y</th>\n",
       "      <th>L10 vx</th>\n",
       "      <th>L10 vy</th>\n",
       "      <th>L10 body</th>\n",
       "      <th>L10 head</th>\n",
       "      <th>L10 vieww</th>\n",
       "      <th>L10 viewq</th>\n",
       "      <th>L11 x</th>\n",
       "      <th>L11 y</th>\n",
       "      <th>L11 vx</th>\n",
       "      <th>L11 vy</th>\n",
       "      <th>L11 body</th>\n",
       "      <th>L11 head</th>\n",
       "      <th>L11 vieww</th>\n",
       "      <th>L11 viewq</th>\n",
       "      <th>RG1 x</th>\n",
       "      <th>RG1 y</th>\n",
       "      <th>RG1 vx</th>\n",
       "      <th>RG1 vy</th>\n",
       "      <th>RG1 body</th>\n",
       "      <th>RG1 head</th>\n",
       "      <th>RG1 vieww</th>\n",
       "      <th>RG1 viewq</th>\n",
       "      <th>R2 x</th>\n",
       "      <th>R2 y</th>\n",
       "      <th>R2 vx</th>\n",
       "      <th>R2 vy</th>\n",
       "      <th>R2 body</th>\n",
       "      <th>R2 head</th>\n",
       "      <th>R2 vieww</th>\n",
       "      <th>R2 viewq</th>\n",
       "      <th>R3 x</th>\n",
       "      <th>R3 y</th>\n",
       "      <th>R3 vx</th>\n",
       "      <th>R3 vy</th>\n",
       "      <th>R3 body</th>\n",
       "      <th>R3 head</th>\n",
       "      <th>R3 vieww</th>\n",
       "      <th>R3 viewq</th>\n",
       "      <th>R4 x</th>\n",
       "      <th>R4 y</th>\n",
       "      <th>R4 vx</th>\n",
       "      <th>R4 vy</th>\n",
       "      <th>R4 body</th>\n",
       "      <th>R4 head</th>\n",
       "      <th>R4 vieww</th>\n",
       "      <th>R4 viewq</th>\n",
       "      <th>R5 x</th>\n",
       "      <th>R5 y</th>\n",
       "      <th>R5 vx</th>\n",
       "      <th>R5 vy</th>\n",
       "      <th>R5 body</th>\n",
       "      <th>R5 head</th>\n",
       "      <th>R5 vieww</th>\n",
       "      <th>R5 viewq</th>\n",
       "      <th>R6 x</th>\n",
       "      <th>R6 y</th>\n",
       "      <th>R6 vx</th>\n",
       "      <th>R6 vy</th>\n",
       "      <th>R6 body</th>\n",
       "      <th>R6 head</th>\n",
       "      <th>R6 vieww</th>\n",
       "      <th>R6 viewq</th>\n",
       "      <th>R7 x</th>\n",
       "      <th>R7 y</th>\n",
       "      <th>R7 vx</th>\n",
       "      <th>R7 vy</th>\n",
       "      <th>R7 body</th>\n",
       "      <th>R7 head</th>\n",
       "      <th>R7 vieww</th>\n",
       "      <th>R7 viewq</th>\n",
       "      <th>R8 x</th>\n",
       "      <th>R8 y</th>\n",
       "      <th>R8 vx</th>\n",
       "      <th>R8 vy</th>\n",
       "      <th>R8 body</th>\n",
       "      <th>R8 head</th>\n",
       "      <th>R8 vieww</th>\n",
       "      <th>R8 viewq</th>\n",
       "      <th>R9 x</th>\n",
       "      <th>R9 y</th>\n",
       "      <th>R9 vx</th>\n",
       "      <th>R9 vy</th>\n",
       "      <th>R9 body</th>\n",
       "      <th>R9 head</th>\n",
       "      <th>R9 vieww</th>\n",
       "      <th>R9 viewq</th>\n",
       "      <th>R10 x</th>\n",
       "      <th>R10 y</th>\n",
       "      <th>R10 vx</th>\n",
       "      <th>R10 vy</th>\n",
       "      <th>R10 body</th>\n",
       "      <th>R10 head</th>\n",
       "      <th>R10 vieww</th>\n",
       "      <th>R10 viewq</th>\n",
       "      <th>R11 x</th>\n",
       "      <th>R11 y</th>\n",
       "      <th>R11 vx</th>\n",
       "      <th>R11 vy</th>\n",
       "      <th>R11 body</th>\n",
       "      <th>R11 head</th>\n",
       "      <th>R11 vieww</th>\n",
       "      <th>R11 viewq</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>kick_off_l</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-163.056</td>\n",
       "      <td>106.943</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>-12.5</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.4732</td>\n",
       "      <td>124.473</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>-12.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-31.3922</td>\n",
       "      <td>-6.39262</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>-11.6</td>\n",
       "      <td>-15.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.8049</td>\n",
       "      <td>0.805197</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>-11.6</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-80.8318</td>\n",
       "      <td>-21.8321</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>-6.7</td>\n",
       "      <td>-1.89999</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.17302</td>\n",
       "      <td>-16.827</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>-10.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.2849</td>\n",
       "      <td>6.28509</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>10.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-72.9407</td>\n",
       "      <td>-123.941</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-23.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>109.856</td>\n",
       "      <td>78.856</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>23.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-95.509</td>\n",
       "      <td>-5.50874</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.384995</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>156.067</td>\n",
       "      <td>66.0664</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>163.922</td>\n",
       "      <td>83.9215</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>163.92</td>\n",
       "      <td>172.92</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>172.62</td>\n",
       "      <td>170.62</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>24.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-166.368</td>\n",
       "      <td>-150.368</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>24.0</td>\n",
       "      <td>-18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>149.646</td>\n",
       "      <td>133.646</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>10.125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.4797</td>\n",
       "      <td>160.48</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>169.27</td>\n",
       "      <td>-113.73</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-176.985</td>\n",
       "      <td>-153.985</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>3.3709</td>\n",
       "      <td>23.5612</td>\n",
       "      <td>0.141205</td>\n",
       "      <td>-0.167007</td>\n",
       "      <td>-49.5647</td>\n",
       "      <td>-5.56469</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45.3481</td>\n",
       "      <td>103.349</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>9.52499</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-107.666</td>\n",
       "      <td>162.334</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   # time     playmode   score left   score right   ball_x   ball_y   ball_vx  \\\n",
       "0       1   kick_off_l            0             0      0.0      0.0       0.0   \n",
       "\n",
       "    ball_vy   LG1 x   LG1 y   LG1 vx   LG1 vy   LG1 body   LG1 head  \\\n",
       "0       0.0   -49.0     0.0      0.0      0.0   -163.056    106.943   \n",
       "\n",
       "    LG1 vieww   LG1 viewq   L2 x   L2 y   L2 vx   L2 vy   L2 body   L2 head  \\\n",
       "0         180           1  -12.5   -5.0     0.0     0.0   40.4732   124.473   \n",
       "\n",
       "    L2 vieww   L2 viewq   L3 x   L3 y   L3 vx   L3 vy   L3 body   L3 head  \\\n",
       "0        120          1  -12.5    5.0     0.0     0.0  -31.3922  -6.39262   \n",
       "\n",
       "    L3 vieww   L3 viewq   L4 x   L4 y   L4 vx   L4 vy   L4 body   L4 head  \\\n",
       "0        180          1  -11.6  -15.8     0.0     0.0   59.8049  0.805197   \n",
       "\n",
       "    L4 vieww   L4 viewq   L5 x   L5 y   L5 vx   L5 vy   L5 body   L5 head  \\\n",
       "0        180          1  -11.6   15.8     0.0     0.0  -80.8318  -21.8321   \n",
       "\n",
       "    L5 vieww   L5 viewq   L6 x     L6 y   L6 vx   L6 vy   L6 body   L6 head  \\\n",
       "0        180          1   -6.7 -1.89999     0.0     0.0   5.17302   -16.827   \n",
       "\n",
       "    L6 vieww   L6 viewq   L7 x   L7 y   L7 vx   L7 vy   L7 body   L7 head  \\\n",
       "0        180          1  -10.0  -10.8     0.0     0.0   60.2849   6.28509   \n",
       "\n",
       "    L7 vieww   L7 viewq   L8 x   L8 y   L8 vx   L8 vy   L8 body   L8 head  \\\n",
       "0        180          1  -10.0   10.8     0.0     0.0  -72.9407  -123.941   \n",
       "\n",
       "    L8 vieww   L8 viewq   L9 x   L9 y   L9 vx   L9 vy   L9 body   L9 head  \\\n",
       "0        120          1   -0.5  -23.8     0.0     0.0   109.856    78.856   \n",
       "\n",
       "    L9 vieww   L9 viewq   L10 x   L10 y   L10 vx   L10 vy   L10 body  \\\n",
       "0        120          1    -0.5    23.8      0.0      0.0    -95.509   \n",
       "\n",
       "    L10 head   L10 vieww   L10 viewq     L11 x   L11 y   L11 vx   L11 vy  \\\n",
       "0   -5.50874         180           1 -0.384995     0.0      0.0      0.0   \n",
       "\n",
       "    L11 body   L11 head   L11 vieww   L11 viewq   RG1 x   RG1 y   RG1 vx  \\\n",
       "0    156.067    66.0664         180           1    49.0     0.0      0.0   \n",
       "\n",
       "    RG1 vy   RG1 body   RG1 head   RG1 vieww   RG1 viewq   R2 x   R2 y  \\\n",
       "0      0.0    163.922    83.9215         180           1   25.0    5.0   \n",
       "\n",
       "    R2 vx   R2 vy   R2 body   R2 head   R2 vieww   R2 viewq   R3 x   R3 y  \\\n",
       "0     0.0     0.0    163.92    172.92        180          1   25.0   -5.0   \n",
       "\n",
       "    R3 vx   R3 vy   R3 body   R3 head   R3 vieww   R3 viewq   R4 x   R4 y  \\\n",
       "0     0.0     0.0    172.62    170.62        180          1   24.0   18.0   \n",
       "\n",
       "    R4 vx   R4 vy   R4 body   R4 head   R4 vieww   R4 viewq   R5 x   R5 y  \\\n",
       "0     0.0     0.0  -166.368  -150.368        180          1   24.0  -18.0   \n",
       "\n",
       "    R5 vx   R5 vy   R5 body   R5 head   R5 vieww   R5 viewq    R6 x   R6 y  \\\n",
       "0     0.0     0.0   149.646   133.646        180          1  10.125    0.0   \n",
       "\n",
       "    R6 vx   R6 vy   R6 body   R6 head   R6 vieww   R6 viewq   R7 x   R7 y  \\\n",
       "0     0.0     0.0   70.4797    160.48        180          1   15.0    9.0   \n",
       "\n",
       "    R7 vx   R7 vy   R7 body   R7 head   R7 vieww   R7 viewq   R8 x   R8 y  \\\n",
       "0     0.0     0.0    169.27   -113.73        120          1   15.0   -9.0   \n",
       "\n",
       "    R8 vx   R8 vy   R8 body   R8 head   R8 vieww   R8 viewq    R9 x     R9 y  \\\n",
       "0     0.0     0.0  -176.985  -153.985        120          1  3.3709  23.5612   \n",
       "\n",
       "      R9 vx     R9 vy   R9 body   R9 head   R9 vieww   R9 viewq   R10 x  \\\n",
       "0  0.141205 -0.167007  -49.5647  -5.56469        180          1     3.0   \n",
       "\n",
       "    R10 y   R10 vx   R10 vy   R10 body   R10 head   R10 vieww   R10 viewq  \\\n",
       "0   -24.0      0.0      0.0    45.3481    103.349         180           1   \n",
       "\n",
       "     R11 x   R11 y   R11 vx   R11 vy   R11 body   R11 head   R11 vieww  \\\n",
       "0  9.52499     0.0      0.0      0.0   -107.666    162.334         180   \n",
       "\n",
       "    R11 viewq  \n",
       "0           1  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Reads the .csv file into a DataFrame\n",
    "df = pd.read_csv(\"data/input/groundtruth.csv\")\n",
    "\n",
    "# DataFrame preview\n",
    "display(md(\"**Initial** DataFrame shape: {0}\".format(df.shape)))\n",
    "display(df.head(1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/markdown": [
       "**Actual** DataFrame shape: (6329, 96)"
      ],
      "text/plain": [
       "<IPython.core.display.Markdown object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>playmode</th>\n",
       "      <th>score left</th>\n",
       "      <th>score right</th>\n",
       "      <th>ball_x</th>\n",
       "      <th>ball_y</th>\n",
       "      <th>ball_vx</th>\n",
       "      <th>ball_vy</th>\n",
       "      <th>LG1 x</th>\n",
       "      <th>LG1 y</th>\n",
       "      <th>LG1 vx</th>\n",
       "      <th>LG1 vy</th>\n",
       "      <th>L2 x</th>\n",
       "      <th>L2 y</th>\n",
       "      <th>L2 vx</th>\n",
       "      <th>L2 vy</th>\n",
       "      <th>L3 x</th>\n",
       "      <th>L3 y</th>\n",
       "      <th>L3 vx</th>\n",
       "      <th>L3 vy</th>\n",
       "      <th>L4 x</th>\n",
       "      <th>L4 y</th>\n",
       "      <th>L4 vx</th>\n",
       "      <th>L4 vy</th>\n",
       "      <th>L5 x</th>\n",
       "      <th>L5 y</th>\n",
       "      <th>L5 vx</th>\n",
       "      <th>L5 vy</th>\n",
       "      <th>L6 x</th>\n",
       "      <th>L6 y</th>\n",
       "      <th>L6 vx</th>\n",
       "      <th>L6 vy</th>\n",
       "      <th>L7 x</th>\n",
       "      <th>L7 y</th>\n",
       "      <th>L7 vx</th>\n",
       "      <th>L7 vy</th>\n",
       "      <th>L8 x</th>\n",
       "      <th>L8 y</th>\n",
       "      <th>L8 vx</th>\n",
       "      <th>L8 vy</th>\n",
       "      <th>L9 x</th>\n",
       "      <th>L9 y</th>\n",
       "      <th>L9 vx</th>\n",
       "      <th>L9 vy</th>\n",
       "      <th>L10 x</th>\n",
       "      <th>L10 y</th>\n",
       "      <th>L10 vx</th>\n",
       "      <th>L10 vy</th>\n",
       "      <th>L11 x</th>\n",
       "      <th>L11 y</th>\n",
       "      <th>L11 vx</th>\n",
       "      <th>L11 vy</th>\n",
       "      <th>RG1 x</th>\n",
       "      <th>RG1 y</th>\n",
       "      <th>RG1 vx</th>\n",
       "      <th>RG1 vy</th>\n",
       "      <th>R2 x</th>\n",
       "      <th>R2 y</th>\n",
       "      <th>R2 vx</th>\n",
       "      <th>R2 vy</th>\n",
       "      <th>R3 x</th>\n",
       "      <th>R3 y</th>\n",
       "      <th>R3 vx</th>\n",
       "      <th>R3 vy</th>\n",
       "      <th>R4 x</th>\n",
       "      <th>R4 y</th>\n",
       "      <th>R4 vx</th>\n",
       "      <th>R4 vy</th>\n",
       "      <th>R5 x</th>\n",
       "      <th>R5 y</th>\n",
       "      <th>R5 vx</th>\n",
       "      <th>R5 vy</th>\n",
       "      <th>R6 x</th>\n",
       "      <th>R6 y</th>\n",
       "      <th>R6 vx</th>\n",
       "      <th>R6 vy</th>\n",
       "      <th>R7 x</th>\n",
       "      <th>R7 y</th>\n",
       "      <th>R7 vx</th>\n",
       "      <th>R7 vy</th>\n",
       "      <th>R8 x</th>\n",
       "      <th>R8 y</th>\n",
       "      <th>R8 vx</th>\n",
       "      <th>R8 vy</th>\n",
       "      <th>R9 x</th>\n",
       "      <th>R9 y</th>\n",
       "      <th>R9 vx</th>\n",
       "      <th>R9 vy</th>\n",
       "      <th>R10 x</th>\n",
       "      <th>R10 y</th>\n",
       "      <th>R10 vx</th>\n",
       "      <th>R10 vy</th>\n",
       "      <th>R11 x</th>\n",
       "      <th>R11 y</th>\n",
       "      <th>R11 vx</th>\n",
       "      <th>R11 vy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>kick_off_l</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.5</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-11.6</td>\n",
       "      <td>-15.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-11.6</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-6.7</td>\n",
       "      <td>-1.89999</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>-10.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>10.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-23.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>23.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.384995</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>-18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.3709</td>\n",
       "      <td>23.5612</td>\n",
       "      <td>0.141205</td>\n",
       "      <td>-0.167007</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.52499</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   # time     playmode   score left   score right   ball_x   ball_y   ball_vx  \\\n",
       "0       1   kick_off_l            0             0      0.0      0.0       0.0   \n",
       "\n",
       "    ball_vy   LG1 x   LG1 y   LG1 vx   LG1 vy   L2 x   L2 y   L2 vx   L2 vy  \\\n",
       "0       0.0   -49.0     0.0      0.0      0.0  -12.5   -5.0     0.0     0.0   \n",
       "\n",
       "    L3 x   L3 y   L3 vx   L3 vy   L4 x   L4 y   L4 vx   L4 vy   L5 x   L5 y  \\\n",
       "0  -12.5    5.0     0.0     0.0  -11.6  -15.8     0.0     0.0  -11.6   15.8   \n",
       "\n",
       "    L5 vx   L5 vy   L6 x     L6 y   L6 vx   L6 vy   L7 x   L7 y   L7 vx  \\\n",
       "0     0.0     0.0   -6.7 -1.89999     0.0     0.0  -10.0  -10.8     0.0   \n",
       "\n",
       "    L7 vy   L8 x   L8 y   L8 vx   L8 vy   L9 x   L9 y   L9 vx   L9 vy   L10 x  \\\n",
       "0     0.0  -10.0   10.8     0.0     0.0   -0.5  -23.8     0.0     0.0    -0.5   \n",
       "\n",
       "    L10 y   L10 vx   L10 vy     L11 x   L11 y   L11 vx   L11 vy   RG1 x  \\\n",
       "0    23.8      0.0      0.0 -0.384995     0.0      0.0      0.0    49.0   \n",
       "\n",
       "    RG1 y   RG1 vx   RG1 vy   R2 x   R2 y   R2 vx   R2 vy   R3 x   R3 y  \\\n",
       "0     0.0      0.0      0.0   25.0    5.0     0.0     0.0   25.0   -5.0   \n",
       "\n",
       "    R3 vx   R3 vy   R4 x   R4 y   R4 vx   R4 vy   R5 x   R5 y   R5 vx   R5 vy  \\\n",
       "0     0.0     0.0   24.0   18.0     0.0     0.0   24.0  -18.0     0.0     0.0   \n",
       "\n",
       "     R6 x   R6 y   R6 vx   R6 vy   R7 x   R7 y   R7 vx   R7 vy   R8 x   R8 y  \\\n",
       "0  10.125    0.0     0.0     0.0   15.0    9.0     0.0     0.0   15.0   -9.0   \n",
       "\n",
       "    R8 vx   R8 vy    R9 x     R9 y     R9 vx     R9 vy   R10 x   R10 y  \\\n",
       "0     0.0     0.0  3.3709  23.5612  0.141205 -0.167007     3.0   -24.0   \n",
       "\n",
       "    R10 vx   R10 vy    R11 x   R11 y   R11 vx   R11 vy  \n",
       "0      0.0      0.0  9.52499     0.0      0.0      0.0  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# To simplify, let's ignore columns about the robots body, head orientation and their view angle and quality\n",
    "columns = [c for c in df.columns.values if not re.search(\"view|body|head\", c)]\n",
    "df = df.loc[:, columns]\n",
    "\n",
    "display(md(\"**Actual** DataFrame shape: {0}\".format(df.shape)))\n",
    "display(df.head(1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>playmode</th>\n",
       "      <th>score_L</th>\n",
       "      <th>score_R</th>\n",
       "      <th>ball_pos_x</th>\n",
       "      <th>ball_pos_y</th>\n",
       "      <th>ball_vel_x</th>\n",
       "      <th>ball_vel_y</th>\n",
       "      <th>L_01_pos_x</th>\n",
       "      <th>L_01_pos_y</th>\n",
       "      <th>L_01_vel_x</th>\n",
       "      <th>L_01_vel_y</th>\n",
       "      <th>L_02_pos_x</th>\n",
       "      <th>L_02_pos_y</th>\n",
       "      <th>L_02_vel_x</th>\n",
       "      <th>L_02_vel_y</th>\n",
       "      <th>L_03_pos_x</th>\n",
       "      <th>L_03_pos_y</th>\n",
       "      <th>L_03_vel_x</th>\n",
       "      <th>L_03_vel_y</th>\n",
       "      <th>L_04_pos_x</th>\n",
       "      <th>L_04_pos_y</th>\n",
       "      <th>L_04_vel_x</th>\n",
       "      <th>L_04_vel_y</th>\n",
       "      <th>L_05_pos_x</th>\n",
       "      <th>L_05_pos_y</th>\n",
       "      <th>L_05_vel_x</th>\n",
       "      <th>L_05_vel_y</th>\n",
       "      <th>L_06_pos_x</th>\n",
       "      <th>L_06_pos_y</th>\n",
       "      <th>L_06_vel_x</th>\n",
       "      <th>L_06_vel_y</th>\n",
       "      <th>L_07_pos_x</th>\n",
       "      <th>L_07_pos_y</th>\n",
       "      <th>L_07_vel_x</th>\n",
       "      <th>L_07_vel_y</th>\n",
       "      <th>L_08_pos_x</th>\n",
       "      <th>L_08_pos_y</th>\n",
       "      <th>L_08_vel_x</th>\n",
       "      <th>L_08_vel_y</th>\n",
       "      <th>L_09_pos_x</th>\n",
       "      <th>L_09_pos_y</th>\n",
       "      <th>L_09_vel_x</th>\n",
       "      <th>L_09_vel_y</th>\n",
       "      <th>L_10_pos_x</th>\n",
       "      <th>L_10_pos_y</th>\n",
       "      <th>L_10_vel_x</th>\n",
       "      <th>L_10_vel_y</th>\n",
       "      <th>L_11_pos_x</th>\n",
       "      <th>L_11_pos_y</th>\n",
       "      <th>L_11_vel_x</th>\n",
       "      <th>L_11_vel_y</th>\n",
       "      <th>R_01_pos_x</th>\n",
       "      <th>R_01_pos_y</th>\n",
       "      <th>R_01_vel_x</th>\n",
       "      <th>R_01_vel_y</th>\n",
       "      <th>R_02_pos_x</th>\n",
       "      <th>R_02_pos_y</th>\n",
       "      <th>R_02_vel_x</th>\n",
       "      <th>R_02_vel_y</th>\n",
       "      <th>R_03_pos_x</th>\n",
       "      <th>R_03_pos_y</th>\n",
       "      <th>R_03_vel_x</th>\n",
       "      <th>R_03_vel_y</th>\n",
       "      <th>R_04_pos_x</th>\n",
       "      <th>R_04_pos_y</th>\n",
       "      <th>R_04_vel_x</th>\n",
       "      <th>R_04_vel_y</th>\n",
       "      <th>R_05_pos_x</th>\n",
       "      <th>R_05_pos_y</th>\n",
       "      <th>R_05_vel_x</th>\n",
       "      <th>R_05_vel_y</th>\n",
       "      <th>R_06_pos_x</th>\n",
       "      <th>R_06_pos_y</th>\n",
       "      <th>R_06_vel_x</th>\n",
       "      <th>R_06_vel_y</th>\n",
       "      <th>R_07_pos_x</th>\n",
       "      <th>R_07_pos_y</th>\n",
       "      <th>R_07_vel_x</th>\n",
       "      <th>R_07_vel_y</th>\n",
       "      <th>R_08_pos_x</th>\n",
       "      <th>R_08_pos_y</th>\n",
       "      <th>R_08_vel_x</th>\n",
       "      <th>R_08_vel_y</th>\n",
       "      <th>R_09_pos_x</th>\n",
       "      <th>R_09_pos_y</th>\n",
       "      <th>R_09_vel_x</th>\n",
       "      <th>R_09_vel_y</th>\n",
       "      <th>R_10_pos_x</th>\n",
       "      <th>R_10_pos_y</th>\n",
       "      <th>R_10_vel_x</th>\n",
       "      <th>R_10_vel_y</th>\n",
       "      <th>R_11_pos_x</th>\n",
       "      <th>R_11_pos_y</th>\n",
       "      <th>R_11_vel_x</th>\n",
       "      <th>R_11_vel_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>kick_off_l</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.5</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-11.6</td>\n",
       "      <td>-15.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-11.6</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-6.7</td>\n",
       "      <td>-1.89999</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>-10.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>10.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-23.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>23.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.384995</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>-18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.3709</td>\n",
       "      <td>23.5612</td>\n",
       "      <td>0.141205</td>\n",
       "      <td>-0.167007</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.52499</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   time     playmode  score_L  score_R  ball_pos_x  ball_pos_y  ball_vel_x  \\\n",
       "0     1   kick_off_l        0        0         0.0         0.0         0.0   \n",
       "\n",
       "   ball_vel_y  L_01_pos_x  L_01_pos_y  L_01_vel_x  L_01_vel_y  L_02_pos_x  \\\n",
       "0         0.0       -49.0         0.0         0.0         0.0       -12.5   \n",
       "\n",
       "   L_02_pos_y  L_02_vel_x  L_02_vel_y  L_03_pos_x  L_03_pos_y  L_03_vel_x  \\\n",
       "0        -5.0         0.0         0.0       -12.5         5.0         0.0   \n",
       "\n",
       "   L_03_vel_y  L_04_pos_x  L_04_pos_y  L_04_vel_x  L_04_vel_y  L_05_pos_x  \\\n",
       "0         0.0       -11.6       -15.8         0.0         0.0       -11.6   \n",
       "\n",
       "   L_05_pos_y  L_05_vel_x  L_05_vel_y  L_06_pos_x  L_06_pos_y  L_06_vel_x  \\\n",
       "0        15.8         0.0         0.0        -6.7    -1.89999         0.0   \n",
       "\n",
       "   L_06_vel_y  L_07_pos_x  L_07_pos_y  L_07_vel_x  L_07_vel_y  L_08_pos_x  \\\n",
       "0         0.0       -10.0       -10.8         0.0         0.0       -10.0   \n",
       "\n",
       "   L_08_pos_y  L_08_vel_x  L_08_vel_y  L_09_pos_x  L_09_pos_y  L_09_vel_x  \\\n",
       "0        10.8         0.0         0.0        -0.5       -23.8         0.0   \n",
       "\n",
       "   L_09_vel_y  L_10_pos_x  L_10_pos_y  L_10_vel_x  L_10_vel_y  L_11_pos_x  \\\n",
       "0         0.0        -0.5        23.8         0.0         0.0   -0.384995   \n",
       "\n",
       "   L_11_pos_y  L_11_vel_x  L_11_vel_y  R_01_pos_x  R_01_pos_y  R_01_vel_x  \\\n",
       "0         0.0         0.0         0.0        49.0         0.0         0.0   \n",
       "\n",
       "   R_01_vel_y  R_02_pos_x  R_02_pos_y  R_02_vel_x  R_02_vel_y  R_03_pos_x  \\\n",
       "0         0.0        25.0         5.0         0.0         0.0        25.0   \n",
       "\n",
       "   R_03_pos_y  R_03_vel_x  R_03_vel_y  R_04_pos_x  R_04_pos_y  R_04_vel_x  \\\n",
       "0        -5.0         0.0         0.0        24.0        18.0         0.0   \n",
       "\n",
       "   R_04_vel_y  R_05_pos_x  R_05_pos_y  R_05_vel_x  R_05_vel_y  R_06_pos_x  \\\n",
       "0         0.0        24.0       -18.0         0.0         0.0      10.125   \n",
       "\n",
       "   R_06_pos_y  R_06_vel_x  R_06_vel_y  R_07_pos_x  R_07_pos_y  R_07_vel_x  \\\n",
       "0         0.0         0.0         0.0        15.0         9.0         0.0   \n",
       "\n",
       "   R_07_vel_y  R_08_pos_x  R_08_pos_y  R_08_vel_x  R_08_vel_y  R_09_pos_x  \\\n",
       "0         0.0        15.0        -9.0         0.0         0.0      3.3709   \n",
       "\n",
       "   R_09_pos_y  R_09_vel_x  R_09_vel_y  R_10_pos_x  R_10_pos_y  R_10_vel_x  \\\n",
       "0     23.5612    0.141205   -0.167007         3.0       -24.0         0.0   \n",
       "\n",
       "   R_10_vel_y  R_11_pos_x  R_11_pos_y  R_11_vel_x  R_11_vel_y  \n",
       "0         0.0     9.52499         0.0         0.0         0.0  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Renames columns\n",
    "# Expected format: [Team Letter]_[Player Number]_[pos/vel]_[x/y]\n",
    "columns = [c.strip().replace(\" \", \"_\") for c in columns] # Remove whitespaces\n",
    "\n",
    "initial_columns = [\"time\", \"playmode\", \"score_L\", \"score_R\", \"ball_pos_x\", \"ball_pos_y\", \"ball_vel_x\", \"ball_vel_y\"]\n",
    "players_columns = []\n",
    "for team_letter in [\"L\", \"R\"]:\n",
    "    for player_number in [\"01\", \"02\", \"03\", \"04\", \"05\", \"06\", \"07\", \"08\", \"09\", \"10\", \"11\"]:\n",
    "        for pos_vel in [\"pos\", \"vel\"]:\n",
    "            for coordinate in [\"x\", \"y\"]:\n",
    "                players_columns = players_columns + [\"{0}_{1}_{2}_{3}\".format(team_letter, player_number, pos_vel, coordinate)]\n",
    "                \n",
    "df.columns = initial_columns + players_columns\n",
    "\n",
    "display(df.head(1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>score_L</th>\n",
       "      <th>score_R</th>\n",
       "      <th>ball_pos_x</th>\n",
       "      <th>ball_pos_y</th>\n",
       "      <th>ball_vel_x</th>\n",
       "      <th>ball_vel_y</th>\n",
       "      <th>L_01_pos_x</th>\n",
       "      <th>L_01_pos_y</th>\n",
       "      <th>L_01_vel_x</th>\n",
       "      <th>L_01_vel_y</th>\n",
       "      <th>L_02_pos_x</th>\n",
       "      <th>L_02_pos_y</th>\n",
       "      <th>L_02_vel_x</th>\n",
       "      <th>L_02_vel_y</th>\n",
       "      <th>L_03_pos_x</th>\n",
       "      <th>L_03_pos_y</th>\n",
       "      <th>L_03_vel_x</th>\n",
       "      <th>L_03_vel_y</th>\n",
       "      <th>L_04_pos_x</th>\n",
       "      <th>L_04_pos_y</th>\n",
       "      <th>L_04_vel_x</th>\n",
       "      <th>L_04_vel_y</th>\n",
       "      <th>L_05_pos_x</th>\n",
       "      <th>L_05_pos_y</th>\n",
       "      <th>L_05_vel_x</th>\n",
       "      <th>L_05_vel_y</th>\n",
       "      <th>L_06_pos_x</th>\n",
       "      <th>L_06_pos_y</th>\n",
       "      <th>L_06_vel_x</th>\n",
       "      <th>L_06_vel_y</th>\n",
       "      <th>L_07_pos_x</th>\n",
       "      <th>L_07_pos_y</th>\n",
       "      <th>L_07_vel_x</th>\n",
       "      <th>L_07_vel_y</th>\n",
       "      <th>L_08_pos_x</th>\n",
       "      <th>L_08_pos_y</th>\n",
       "      <th>L_08_vel_x</th>\n",
       "      <th>L_08_vel_y</th>\n",
       "      <th>L_09_pos_x</th>\n",
       "      <th>L_09_pos_y</th>\n",
       "      <th>L_09_vel_x</th>\n",
       "      <th>L_09_vel_y</th>\n",
       "      <th>L_10_pos_x</th>\n",
       "      <th>L_10_pos_y</th>\n",
       "      <th>L_10_vel_x</th>\n",
       "      <th>L_10_vel_y</th>\n",
       "      <th>L_11_pos_x</th>\n",
       "      <th>L_11_pos_y</th>\n",
       "      <th>L_11_vel_x</th>\n",
       "      <th>L_11_vel_y</th>\n",
       "      <th>R_01_pos_x</th>\n",
       "      <th>R_01_pos_y</th>\n",
       "      <th>R_01_vel_x</th>\n",
       "      <th>R_01_vel_y</th>\n",
       "      <th>R_02_pos_x</th>\n",
       "      <th>R_02_pos_y</th>\n",
       "      <th>R_02_vel_x</th>\n",
       "      <th>R_02_vel_y</th>\n",
       "      <th>R_03_pos_x</th>\n",
       "      <th>R_03_pos_y</th>\n",
       "      <th>R_03_vel_x</th>\n",
       "      <th>R_03_vel_y</th>\n",
       "      <th>R_04_pos_x</th>\n",
       "      <th>R_04_pos_y</th>\n",
       "      <th>R_04_vel_x</th>\n",
       "      <th>R_04_vel_y</th>\n",
       "      <th>R_05_pos_x</th>\n",
       "      <th>R_05_pos_y</th>\n",
       "      <th>R_05_vel_x</th>\n",
       "      <th>R_05_vel_y</th>\n",
       "      <th>R_06_pos_x</th>\n",
       "      <th>R_06_pos_y</th>\n",
       "      <th>R_06_vel_x</th>\n",
       "      <th>R_06_vel_y</th>\n",
       "      <th>R_07_pos_x</th>\n",
       "      <th>R_07_pos_y</th>\n",
       "      <th>R_07_vel_x</th>\n",
       "      <th>R_07_vel_y</th>\n",
       "      <th>R_08_pos_x</th>\n",
       "      <th>R_08_pos_y</th>\n",
       "      <th>R_08_vel_x</th>\n",
       "      <th>R_08_vel_y</th>\n",
       "      <th>R_09_pos_x</th>\n",
       "      <th>R_09_pos_y</th>\n",
       "      <th>R_09_vel_x</th>\n",
       "      <th>R_09_vel_y</th>\n",
       "      <th>R_10_pos_x</th>\n",
       "      <th>R_10_pos_y</th>\n",
       "      <th>R_10_vel_x</th>\n",
       "      <th>R_10_vel_y</th>\n",
       "      <th>R_11_pos_x</th>\n",
       "      <th>R_11_pos_y</th>\n",
       "      <th>R_11_vel_x</th>\n",
       "      <th>R_11_vel_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.0</td>\n",
       "      <td>6329.0</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2960.614631</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-6.103772</td>\n",
       "      <td>6.669864</td>\n",
       "      <td>-0.001189</td>\n",
       "      <td>0.004512</td>\n",
       "      <td>-50.666835</td>\n",
       "      <td>0.583756</td>\n",
       "      <td>-0.000179</td>\n",
       "      <td>0.000254</td>\n",
       "      <td>-17.339277</td>\n",
       "      <td>-3.263884</td>\n",
       "      <td>-0.000919</td>\n",
       "      <td>0.001018</td>\n",
       "      <td>-17.885416</td>\n",
       "      <td>8.327948</td>\n",
       "      <td>-0.000949</td>\n",
       "      <td>0.000656</td>\n",
       "      <td>-15.985322</td>\n",
       "      <td>-14.269397</td>\n",
       "      <td>-0.000064</td>\n",
       "      <td>-0.000167</td>\n",
       "      <td>-15.763670</td>\n",
       "      <td>19.006224</td>\n",
       "      <td>-0.000271</td>\n",
       "      <td>0.001170</td>\n",
       "      <td>-11.153197</td>\n",
       "      <td>3.271286</td>\n",
       "      <td>-0.001078</td>\n",
       "      <td>0.000776</td>\n",
       "      <td>-6.897718</td>\n",
       "      <td>-9.899154</td>\n",
       "      <td>0.001008</td>\n",
       "      <td>0.000240</td>\n",
       "      <td>-7.528027</td>\n",
       "      <td>16.274952</td>\n",
       "      <td>0.000098</td>\n",
       "      <td>0.001970</td>\n",
       "      <td>-3.725991</td>\n",
       "      <td>-12.003608</td>\n",
       "      <td>-0.001249</td>\n",
       "      <td>0.002065</td>\n",
       "      <td>-3.658397</td>\n",
       "      <td>17.932787</td>\n",
       "      <td>-0.001409</td>\n",
       "      <td>-0.000706</td>\n",
       "      <td>-3.637949</td>\n",
       "      <td>3.241093</td>\n",
       "      <td>-0.000712</td>\n",
       "      <td>0.000206</td>\n",
       "      <td>42.732766</td>\n",
       "      <td>0.905185</td>\n",
       "      <td>-0.000615</td>\n",
       "      <td>0.000207</td>\n",
       "      <td>2.759877</td>\n",
       "      <td>2.241877</td>\n",
       "      <td>-0.002761</td>\n",
       "      <td>0.000503</td>\n",
       "      <td>12.483964</td>\n",
       "      <td>3.055914</td>\n",
       "      <td>-0.001476</td>\n",
       "      <td>0.001070</td>\n",
       "      <td>11.340124</td>\n",
       "      <td>20.183273</td>\n",
       "      <td>-0.001397</td>\n",
       "      <td>0.000605</td>\n",
       "      <td>11.233974</td>\n",
       "      <td>-14.787518</td>\n",
       "      <td>-0.002037</td>\n",
       "      <td>0.000530</td>\n",
       "      <td>-9.168780</td>\n",
       "      <td>1.848916</td>\n",
       "      <td>-0.003843</td>\n",
       "      <td>-0.000359</td>\n",
       "      <td>-2.569106</td>\n",
       "      <td>17.545564</td>\n",
       "      <td>-0.002471</td>\n",
       "      <td>0.002153</td>\n",
       "      <td>-2.929361</td>\n",
       "      <td>-12.056731</td>\n",
       "      <td>-0.002918</td>\n",
       "      <td>-0.000477</td>\n",
       "      <td>-11.915094</td>\n",
       "      <td>23.903453</td>\n",
       "      <td>-0.001999</td>\n",
       "      <td>0.000863</td>\n",
       "      <td>-13.432943</td>\n",
       "      <td>-21.725926</td>\n",
       "      <td>-0.002099</td>\n",
       "      <td>-0.000408</td>\n",
       "      <td>-15.715282</td>\n",
       "      <td>2.699512</td>\n",
       "      <td>-0.002674</td>\n",
       "      <td>0.001877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1733.865701</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.021567</td>\n",
       "      <td>21.579363</td>\n",
       "      <td>0.678898</td>\n",
       "      <td>0.950819</td>\n",
       "      <td>0.330235</td>\n",
       "      <td>3.194201</td>\n",
       "      <td>0.006138</td>\n",
       "      <td>0.030724</td>\n",
       "      <td>12.648209</td>\n",
       "      <td>8.506397</td>\n",
       "      <td>0.148115</td>\n",
       "      <td>0.130605</td>\n",
       "      <td>12.948650</td>\n",
       "      <td>8.907047</td>\n",
       "      <td>0.145684</td>\n",
       "      <td>0.134668</td>\n",
       "      <td>14.083729</td>\n",
       "      <td>7.270781</td>\n",
       "      <td>0.119555</td>\n",
       "      <td>0.102194</td>\n",
       "      <td>14.080687</td>\n",
       "      <td>8.250549</td>\n",
       "      <td>0.111272</td>\n",
       "      <td>0.104445</td>\n",
       "      <td>16.155567</td>\n",
       "      <td>10.079861</td>\n",
       "      <td>0.135256</td>\n",
       "      <td>0.116929</td>\n",
       "      <td>16.924414</td>\n",
       "      <td>10.777474</td>\n",
       "      <td>0.116310</td>\n",
       "      <td>0.123406</td>\n",
       "      <td>17.462262</td>\n",
       "      <td>9.872817</td>\n",
       "      <td>0.153242</td>\n",
       "      <td>0.153821</td>\n",
       "      <td>18.734913</td>\n",
       "      <td>9.052817</td>\n",
       "      <td>0.123677</td>\n",
       "      <td>0.121331</td>\n",
       "      <td>19.609866</td>\n",
       "      <td>9.462135</td>\n",
       "      <td>0.128758</td>\n",
       "      <td>0.111542</td>\n",
       "      <td>19.209872</td>\n",
       "      <td>8.265025</td>\n",
       "      <td>0.099697</td>\n",
       "      <td>0.080986</td>\n",
       "      <td>2.837626</td>\n",
       "      <td>2.610050</td>\n",
       "      <td>0.044355</td>\n",
       "      <td>0.046475</td>\n",
       "      <td>15.166566</td>\n",
       "      <td>8.666231</td>\n",
       "      <td>0.121613</td>\n",
       "      <td>0.089535</td>\n",
       "      <td>10.698310</td>\n",
       "      <td>8.155176</td>\n",
       "      <td>0.087549</td>\n",
       "      <td>0.102035</td>\n",
       "      <td>11.834271</td>\n",
       "      <td>6.245019</td>\n",
       "      <td>0.086969</td>\n",
       "      <td>0.091738</td>\n",
       "      <td>11.701539</td>\n",
       "      <td>8.056235</td>\n",
       "      <td>0.092552</td>\n",
       "      <td>0.104250</td>\n",
       "      <td>15.907319</td>\n",
       "      <td>6.684897</td>\n",
       "      <td>0.110747</td>\n",
       "      <td>0.085229</td>\n",
       "      <td>16.462147</td>\n",
       "      <td>8.176656</td>\n",
       "      <td>0.114722</td>\n",
       "      <td>0.103710</td>\n",
       "      <td>16.065072</td>\n",
       "      <td>9.553319</td>\n",
       "      <td>0.138136</td>\n",
       "      <td>0.123001</td>\n",
       "      <td>17.738374</td>\n",
       "      <td>7.170880</td>\n",
       "      <td>0.124528</td>\n",
       "      <td>0.102679</td>\n",
       "      <td>15.770871</td>\n",
       "      <td>6.923577</td>\n",
       "      <td>0.117219</td>\n",
       "      <td>0.107745</td>\n",
       "      <td>14.631273</td>\n",
       "      <td>14.358356</td>\n",
       "      <td>0.120981</td>\n",
       "      <td>0.158287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-51.500000</td>\n",
       "      <td>-34.000000</td>\n",
       "      <td>-2.635600</td>\n",
       "      <td>-2.835900</td>\n",
       "      <td>-51.306600</td>\n",
       "      <td>-6.511990</td>\n",
       "      <td>-0.147903</td>\n",
       "      <td>-0.316299</td>\n",
       "      <td>-46.147700</td>\n",
       "      <td>-29.222700</td>\n",
       "      <td>-0.451996</td>\n",
       "      <td>-0.445404</td>\n",
       "      <td>-50.734000</td>\n",
       "      <td>-9.666310</td>\n",
       "      <td>-0.434204</td>\n",
       "      <td>-0.422607</td>\n",
       "      <td>-49.712500</td>\n",
       "      <td>-32.027100</td>\n",
       "      <td>-0.348907</td>\n",
       "      <td>-0.339401</td>\n",
       "      <td>-47.375600</td>\n",
       "      <td>0.064194</td>\n",
       "      <td>-0.330505</td>\n",
       "      <td>-0.320908</td>\n",
       "      <td>-40.394700</td>\n",
       "      <td>-17.432600</td>\n",
       "      <td>-0.381897</td>\n",
       "      <td>-0.369095</td>\n",
       "      <td>-43.084000</td>\n",
       "      <td>-32.597900</td>\n",
       "      <td>-0.334503</td>\n",
       "      <td>-0.336304</td>\n",
       "      <td>-39.791100</td>\n",
       "      <td>-10.103800</td>\n",
       "      <td>-0.444107</td>\n",
       "      <td>-0.427795</td>\n",
       "      <td>-35.918000</td>\n",
       "      <td>-30.354400</td>\n",
       "      <td>-0.379898</td>\n",
       "      <td>-0.383698</td>\n",
       "      <td>-40.575500</td>\n",
       "      <td>-1.080090</td>\n",
       "      <td>-0.378998</td>\n",
       "      <td>-0.360901</td>\n",
       "      <td>-37.837400</td>\n",
       "      <td>-20.312300</td>\n",
       "      <td>-0.308197</td>\n",
       "      <td>-0.306900</td>\n",
       "      <td>34.958700</td>\n",
       "      <td>-8.380200</td>\n",
       "      <td>-0.416397</td>\n",
       "      <td>-0.397293</td>\n",
       "      <td>-30.934200</td>\n",
       "      <td>-18.623800</td>\n",
       "      <td>-0.340897</td>\n",
       "      <td>-0.319397</td>\n",
       "      <td>-1.651310</td>\n",
       "      <td>-18.115700</td>\n",
       "      <td>-0.316605</td>\n",
       "      <td>-0.325699</td>\n",
       "      <td>-8.951510</td>\n",
       "      <td>4.121700</td>\n",
       "      <td>-0.319901</td>\n",
       "      <td>-0.306595</td>\n",
       "      <td>-9.902600</td>\n",
       "      <td>-35.137200</td>\n",
       "      <td>-0.332108</td>\n",
       "      <td>-0.318695</td>\n",
       "      <td>-44.756700</td>\n",
       "      <td>-22.696800</td>\n",
       "      <td>-0.326202</td>\n",
       "      <td>-0.322205</td>\n",
       "      <td>-33.808900</td>\n",
       "      <td>-7.353610</td>\n",
       "      <td>-0.358307</td>\n",
       "      <td>-0.340393</td>\n",
       "      <td>-41.703300</td>\n",
       "      <td>-35.869000</td>\n",
       "      <td>-0.412003</td>\n",
       "      <td>-0.398895</td>\n",
       "      <td>-50.662500</td>\n",
       "      <td>-8.987000</td>\n",
       "      <td>-0.370895</td>\n",
       "      <td>-0.372192</td>\n",
       "      <td>-51.529500</td>\n",
       "      <td>-34.797300</td>\n",
       "      <td>-0.373795</td>\n",
       "      <td>-0.381104</td>\n",
       "      <td>-51.884100</td>\n",
       "      <td>-28.881200</td>\n",
       "      <td>-0.443802</td>\n",
       "      <td>-0.451004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1463.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-17.480400</td>\n",
       "      <td>-8.481800</td>\n",
       "      <td>-0.190500</td>\n",
       "      <td>-0.172800</td>\n",
       "      <td>-50.942000</td>\n",
       "      <td>-1.353700</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-24.425600</td>\n",
       "      <td>-9.515590</td>\n",
       "      <td>-0.010498</td>\n",
       "      <td>-0.014694</td>\n",
       "      <td>-23.804900</td>\n",
       "      <td>1.224400</td>\n",
       "      <td>-0.008301</td>\n",
       "      <td>-0.012695</td>\n",
       "      <td>-24.701400</td>\n",
       "      <td>-20.209500</td>\n",
       "      <td>-0.001999</td>\n",
       "      <td>-0.004196</td>\n",
       "      <td>-21.870800</td>\n",
       "      <td>12.627100</td>\n",
       "      <td>-0.002502</td>\n",
       "      <td>-0.008301</td>\n",
       "      <td>-19.266300</td>\n",
       "      <td>-4.300900</td>\n",
       "      <td>-0.028107</td>\n",
       "      <td>-0.025604</td>\n",
       "      <td>-16.107500</td>\n",
       "      <td>-18.295400</td>\n",
       "      <td>-0.017899</td>\n",
       "      <td>-0.037201</td>\n",
       "      <td>-15.861500</td>\n",
       "      <td>9.313710</td>\n",
       "      <td>-0.037796</td>\n",
       "      <td>-0.041199</td>\n",
       "      <td>-14.365400</td>\n",
       "      <td>-19.158100</td>\n",
       "      <td>-0.014496</td>\n",
       "      <td>-0.031097</td>\n",
       "      <td>-14.006800</td>\n",
       "      <td>9.293900</td>\n",
       "      <td>-0.017502</td>\n",
       "      <td>-0.018494</td>\n",
       "      <td>-15.218200</td>\n",
       "      <td>-1.031600</td>\n",
       "      <td>-0.009003</td>\n",
       "      <td>-0.005203</td>\n",
       "      <td>40.668000</td>\n",
       "      <td>-0.524597</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-8.455990</td>\n",
       "      <td>-4.964100</td>\n",
       "      <td>-0.037399</td>\n",
       "      <td>-0.012695</td>\n",
       "      <td>4.456500</td>\n",
       "      <td>-3.384510</td>\n",
       "      <td>-0.016296</td>\n",
       "      <td>-0.008896</td>\n",
       "      <td>3.149600</td>\n",
       "      <td>14.964500</td>\n",
       "      <td>-0.014404</td>\n",
       "      <td>-0.006897</td>\n",
       "      <td>2.877400</td>\n",
       "      <td>-19.990800</td>\n",
       "      <td>-0.021606</td>\n",
       "      <td>-0.011597</td>\n",
       "      <td>-19.787800</td>\n",
       "      <td>-0.975494</td>\n",
       "      <td>-0.020294</td>\n",
       "      <td>-0.005798</td>\n",
       "      <td>-10.111400</td>\n",
       "      <td>11.084100</td>\n",
       "      <td>-0.024399</td>\n",
       "      <td>-0.012894</td>\n",
       "      <td>-10.403100</td>\n",
       "      <td>-19.569400</td>\n",
       "      <td>-0.019394</td>\n",
       "      <td>-0.018204</td>\n",
       "      <td>-20.883700</td>\n",
       "      <td>21.314300</td>\n",
       "      <td>-0.013107</td>\n",
       "      <td>-0.010605</td>\n",
       "      <td>-20.335600</td>\n",
       "      <td>-27.339000</td>\n",
       "      <td>-0.016602</td>\n",
       "      <td>-0.016098</td>\n",
       "      <td>-21.287900</td>\n",
       "      <td>-8.644900</td>\n",
       "      <td>-0.013306</td>\n",
       "      <td>-0.018097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2955.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-2.838800</td>\n",
       "      <td>8.697800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-50.666500</td>\n",
       "      <td>0.784302</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-13.625400</td>\n",
       "      <td>-1.142700</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-13.525200</td>\n",
       "      <td>8.727490</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-12.581500</td>\n",
       "      <td>-12.288000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-12.337500</td>\n",
       "      <td>18.746400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-8.700590</td>\n",
       "      <td>5.052200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-5.382800</td>\n",
       "      <td>-9.015000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-5.896500</td>\n",
       "      <td>17.082200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-7.336300</td>\n",
       "      <td>-11.316000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-7.601000</td>\n",
       "      <td>19.369900</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-8.886510</td>\n",
       "      <td>1.759700</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>43.089600</td>\n",
       "      <td>0.935303</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.878204</td>\n",
       "      <td>4.643010</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.868600</td>\n",
       "      <td>3.913300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.187200</td>\n",
       "      <td>20.702200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.701800</td>\n",
       "      <td>-14.435800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-9.580700</td>\n",
       "      <td>0.933502</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.500900</td>\n",
       "      <td>17.093500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-1.702390</td>\n",
       "      <td>-10.110200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-11.266900</td>\n",
       "      <td>25.051100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-11.587300</td>\n",
       "      <td>-22.965500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-12.015500</td>\n",
       "      <td>4.451400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>4448.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.629000</td>\n",
       "      <td>27.677800</td>\n",
       "      <td>0.174600</td>\n",
       "      <td>0.234900</td>\n",
       "      <td>-50.522600</td>\n",
       "      <td>3.280810</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-8.868800</td>\n",
       "      <td>4.127300</td>\n",
       "      <td>0.027801</td>\n",
       "      <td>0.018799</td>\n",
       "      <td>-9.089200</td>\n",
       "      <td>16.536100</td>\n",
       "      <td>0.024307</td>\n",
       "      <td>0.011795</td>\n",
       "      <td>-7.516910</td>\n",
       "      <td>-8.974700</td>\n",
       "      <td>0.012299</td>\n",
       "      <td>0.007599</td>\n",
       "      <td>-6.552510</td>\n",
       "      <td>25.285800</td>\n",
       "      <td>0.014297</td>\n",
       "      <td>0.007202</td>\n",
       "      <td>-2.065090</td>\n",
       "      <td>12.233500</td>\n",
       "      <td>0.041596</td>\n",
       "      <td>0.034699</td>\n",
       "      <td>2.771500</td>\n",
       "      <td>-1.206500</td>\n",
       "      <td>0.031799</td>\n",
       "      <td>0.033905</td>\n",
       "      <td>2.724700</td>\n",
       "      <td>24.100700</td>\n",
       "      <td>0.047806</td>\n",
       "      <td>0.056503</td>\n",
       "      <td>7.320600</td>\n",
       "      <td>-4.665890</td>\n",
       "      <td>0.036194</td>\n",
       "      <td>0.028397</td>\n",
       "      <td>6.519700</td>\n",
       "      <td>26.415000</td>\n",
       "      <td>0.032898</td>\n",
       "      <td>0.022293</td>\n",
       "      <td>6.621800</td>\n",
       "      <td>7.519590</td>\n",
       "      <td>0.009506</td>\n",
       "      <td>0.005707</td>\n",
       "      <td>44.413200</td>\n",
       "      <td>2.123990</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.529400</td>\n",
       "      <td>9.573500</td>\n",
       "      <td>0.009506</td>\n",
       "      <td>0.007507</td>\n",
       "      <td>16.478800</td>\n",
       "      <td>9.018010</td>\n",
       "      <td>0.005402</td>\n",
       "      <td>0.016403</td>\n",
       "      <td>15.949200</td>\n",
       "      <td>25.502600</td>\n",
       "      <td>0.002502</td>\n",
       "      <td>0.007095</td>\n",
       "      <td>16.514500</td>\n",
       "      <td>-11.086600</td>\n",
       "      <td>0.003998</td>\n",
       "      <td>0.009598</td>\n",
       "      <td>0.275101</td>\n",
       "      <td>5.569400</td>\n",
       "      <td>0.007904</td>\n",
       "      <td>0.005600</td>\n",
       "      <td>5.860200</td>\n",
       "      <td>25.091100</td>\n",
       "      <td>0.016495</td>\n",
       "      <td>0.018600</td>\n",
       "      <td>4.779300</td>\n",
       "      <td>-6.947400</td>\n",
       "      <td>0.024200</td>\n",
       "      <td>0.014801</td>\n",
       "      <td>-2.361690</td>\n",
       "      <td>28.897600</td>\n",
       "      <td>0.022598</td>\n",
       "      <td>0.017395</td>\n",
       "      <td>-3.941890</td>\n",
       "      <td>-16.225400</td>\n",
       "      <td>0.015594</td>\n",
       "      <td>0.007095</td>\n",
       "      <td>-6.763310</td>\n",
       "      <td>14.652700</td>\n",
       "      <td>0.011200</td>\n",
       "      <td>0.019501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>6000.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.557500</td>\n",
       "      <td>34.065600</td>\n",
       "      <td>2.737600</td>\n",
       "      <td>2.927600</td>\n",
       "      <td>-49.000000</td>\n",
       "      <td>6.564900</td>\n",
       "      <td>0.089706</td>\n",
       "      <td>0.274307</td>\n",
       "      <td>4.230100</td>\n",
       "      <td>9.584400</td>\n",
       "      <td>0.439301</td>\n",
       "      <td>0.453003</td>\n",
       "      <td>-0.007294</td>\n",
       "      <td>27.822700</td>\n",
       "      <td>0.427399</td>\n",
       "      <td>0.428696</td>\n",
       "      <td>14.079400</td>\n",
       "      <td>-1.307800</td>\n",
       "      <td>0.351700</td>\n",
       "      <td>0.354706</td>\n",
       "      <td>12.513100</td>\n",
       "      <td>35.743200</td>\n",
       "      <td>0.323395</td>\n",
       "      <td>0.328598</td>\n",
       "      <td>31.910600</td>\n",
       "      <td>26.264500</td>\n",
       "      <td>0.371307</td>\n",
       "      <td>0.365005</td>\n",
       "      <td>41.341200</td>\n",
       "      <td>14.686400</td>\n",
       "      <td>0.332596</td>\n",
       "      <td>0.335098</td>\n",
       "      <td>45.266200</td>\n",
       "      <td>32.699300</td>\n",
       "      <td>0.434402</td>\n",
       "      <td>0.419403</td>\n",
       "      <td>46.611300</td>\n",
       "      <td>15.126900</td>\n",
       "      <td>0.389694</td>\n",
       "      <td>0.384903</td>\n",
       "      <td>51.890000</td>\n",
       "      <td>34.358600</td>\n",
       "      <td>0.371994</td>\n",
       "      <td>0.375793</td>\n",
       "      <td>48.807400</td>\n",
       "      <td>26.865500</td>\n",
       "      <td>0.310196</td>\n",
       "      <td>0.302597</td>\n",
       "      <td>51.180400</td>\n",
       "      <td>6.797610</td>\n",
       "      <td>0.391205</td>\n",
       "      <td>0.417297</td>\n",
       "      <td>49.087700</td>\n",
       "      <td>16.457400</td>\n",
       "      <td>0.352402</td>\n",
       "      <td>0.343704</td>\n",
       "      <td>46.261000</td>\n",
       "      <td>25.478800</td>\n",
       "      <td>0.312897</td>\n",
       "      <td>0.317993</td>\n",
       "      <td>48.785100</td>\n",
       "      <td>32.298900</td>\n",
       "      <td>0.308197</td>\n",
       "      <td>0.312195</td>\n",
       "      <td>46.236000</td>\n",
       "      <td>11.077900</td>\n",
       "      <td>0.334595</td>\n",
       "      <td>0.325607</td>\n",
       "      <td>33.504400</td>\n",
       "      <td>20.489000</td>\n",
       "      <td>0.322800</td>\n",
       "      <td>0.332703</td>\n",
       "      <td>44.911000</td>\n",
       "      <td>31.878500</td>\n",
       "      <td>0.364197</td>\n",
       "      <td>0.349304</td>\n",
       "      <td>41.982500</td>\n",
       "      <td>10.363800</td>\n",
       "      <td>0.432999</td>\n",
       "      <td>0.417206</td>\n",
       "      <td>35.992200</td>\n",
       "      <td>35.710800</td>\n",
       "      <td>0.374893</td>\n",
       "      <td>0.364700</td>\n",
       "      <td>25.237200</td>\n",
       "      <td>-5.982300</td>\n",
       "      <td>0.385895</td>\n",
       "      <td>0.391800</td>\n",
       "      <td>12.934700</td>\n",
       "      <td>27.954800</td>\n",
       "      <td>0.421799</td>\n",
       "      <td>0.458298</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              time  score_L  score_R   ball_pos_x   ball_pos_y   ball_vel_x  \\\n",
       "count  6329.000000   6329.0   6329.0  6329.000000  6329.000000  6329.000000   \n",
       "mean   2960.614631      0.0      0.0    -6.103772     6.669864    -0.001189   \n",
       "std    1733.865701      0.0      0.0    20.021567    21.579363     0.678898   \n",
       "min       1.000000      0.0      0.0   -51.500000   -34.000000    -2.635600   \n",
       "25%    1463.000000      0.0      0.0   -17.480400    -8.481800    -0.190500   \n",
       "50%    2955.000000      0.0      0.0    -2.838800     8.697800     0.000000   \n",
       "75%    4448.000000      0.0      0.0     4.629000    27.677800     0.174600   \n",
       "max    6000.000000      0.0      0.0    52.557500    34.065600     2.737600   \n",
       "\n",
       "        ball_vel_y   L_01_pos_x   L_01_pos_y   L_01_vel_x   L_01_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.004512   -50.666835     0.583756    -0.000179     0.000254   \n",
       "std       0.950819     0.330235     3.194201     0.006138     0.030724   \n",
       "min      -2.835900   -51.306600    -6.511990    -0.147903    -0.316299   \n",
       "25%      -0.172800   -50.942000    -1.353700     0.000000     0.000000   \n",
       "50%       0.000000   -50.666500     0.784302     0.000000     0.000000   \n",
       "75%       0.234900   -50.522600     3.280810     0.000000     0.000000   \n",
       "max       2.927600   -49.000000     6.564900     0.089706     0.274307   \n",
       "\n",
       "        L_02_pos_x   L_02_pos_y   L_02_vel_x   L_02_vel_y   L_03_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean    -17.339277    -3.263884    -0.000919     0.001018   -17.885416   \n",
       "std      12.648209     8.506397     0.148115     0.130605    12.948650   \n",
       "min     -46.147700   -29.222700    -0.451996    -0.445404   -50.734000   \n",
       "25%     -24.425600    -9.515590    -0.010498    -0.014694   -23.804900   \n",
       "50%     -13.625400    -1.142700     0.000000     0.000000   -13.525200   \n",
       "75%      -8.868800     4.127300     0.027801     0.018799    -9.089200   \n",
       "max       4.230100     9.584400     0.439301     0.453003    -0.007294   \n",
       "\n",
       "        L_03_pos_y   L_03_vel_x   L_03_vel_y   L_04_pos_x   L_04_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      8.327948    -0.000949     0.000656   -15.985322   -14.269397   \n",
       "std       8.907047     0.145684     0.134668    14.083729     7.270781   \n",
       "min      -9.666310    -0.434204    -0.422607   -49.712500   -32.027100   \n",
       "25%       1.224400    -0.008301    -0.012695   -24.701400   -20.209500   \n",
       "50%       8.727490     0.000000     0.000000   -12.581500   -12.288000   \n",
       "75%      16.536100     0.024307     0.011795    -7.516910    -8.974700   \n",
       "max      27.822700     0.427399     0.428696    14.079400    -1.307800   \n",
       "\n",
       "        L_04_vel_x   L_04_vel_y   L_05_pos_x   L_05_pos_y   L_05_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.000064    -0.000167   -15.763670    19.006224    -0.000271   \n",
       "std       0.119555     0.102194    14.080687     8.250549     0.111272   \n",
       "min      -0.348907    -0.339401   -47.375600     0.064194    -0.330505   \n",
       "25%      -0.001999    -0.004196   -21.870800    12.627100    -0.002502   \n",
       "50%       0.000000     0.000000   -12.337500    18.746400     0.000000   \n",
       "75%       0.012299     0.007599    -6.552510    25.285800     0.014297   \n",
       "max       0.351700     0.354706    12.513100    35.743200     0.323395   \n",
       "\n",
       "        L_05_vel_y   L_06_pos_x   L_06_pos_y   L_06_vel_x   L_06_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.001170   -11.153197     3.271286    -0.001078     0.000776   \n",
       "std       0.104445    16.155567    10.079861     0.135256     0.116929   \n",
       "min      -0.320908   -40.394700   -17.432600    -0.381897    -0.369095   \n",
       "25%      -0.008301   -19.266300    -4.300900    -0.028107    -0.025604   \n",
       "50%       0.000000    -8.700590     5.052200     0.000000     0.000000   \n",
       "75%       0.007202    -2.065090    12.233500     0.041596     0.034699   \n",
       "max       0.328598    31.910600    26.264500     0.371307     0.365005   \n",
       "\n",
       "        L_07_pos_x   L_07_pos_y   L_07_vel_x   L_07_vel_y   L_08_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -6.897718    -9.899154     0.001008     0.000240    -7.528027   \n",
       "std      16.924414    10.777474     0.116310     0.123406    17.462262   \n",
       "min     -43.084000   -32.597900    -0.334503    -0.336304   -39.791100   \n",
       "25%     -16.107500   -18.295400    -0.017899    -0.037201   -15.861500   \n",
       "50%      -5.382800    -9.015000     0.000000     0.000000    -5.896500   \n",
       "75%       2.771500    -1.206500     0.031799     0.033905     2.724700   \n",
       "max      41.341200    14.686400     0.332596     0.335098    45.266200   \n",
       "\n",
       "        L_08_pos_y   L_08_vel_x   L_08_vel_y   L_09_pos_x   L_09_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     16.274952     0.000098     0.001970    -3.725991   -12.003608   \n",
       "std       9.872817     0.153242     0.153821    18.734913     9.052817   \n",
       "min     -10.103800    -0.444107    -0.427795   -35.918000   -30.354400   \n",
       "25%       9.313710    -0.037796    -0.041199   -14.365400   -19.158100   \n",
       "50%      17.082200     0.000000     0.000000    -7.336300   -11.316000   \n",
       "75%      24.100700     0.047806     0.056503     7.320600    -4.665890   \n",
       "max      32.699300     0.434402     0.419403    46.611300    15.126900   \n",
       "\n",
       "        L_09_vel_x   L_09_vel_y   L_10_pos_x   L_10_pos_y   L_10_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.001249     0.002065    -3.658397    17.932787    -0.001409   \n",
       "std       0.123677     0.121331    19.609866     9.462135     0.128758   \n",
       "min      -0.379898    -0.383698   -40.575500    -1.080090    -0.378998   \n",
       "25%      -0.014496    -0.031097   -14.006800     9.293900    -0.017502   \n",
       "50%       0.000000     0.000000    -7.601000    19.369900     0.000000   \n",
       "75%       0.036194     0.028397     6.519700    26.415000     0.032898   \n",
       "max       0.389694     0.384903    51.890000    34.358600     0.371994   \n",
       "\n",
       "        L_10_vel_y   L_11_pos_x   L_11_pos_y   L_11_vel_x   L_11_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.000706    -3.637949     3.241093    -0.000712     0.000206   \n",
       "std       0.111542    19.209872     8.265025     0.099697     0.080986   \n",
       "min      -0.360901   -37.837400   -20.312300    -0.308197    -0.306900   \n",
       "25%      -0.018494   -15.218200    -1.031600    -0.009003    -0.005203   \n",
       "50%       0.000000    -8.886510     1.759700     0.000000     0.000000   \n",
       "75%       0.022293     6.621800     7.519590     0.009506     0.005707   \n",
       "max       0.375793    48.807400    26.865500     0.310196     0.302597   \n",
       "\n",
       "        R_01_pos_x   R_01_pos_y   R_01_vel_x   R_01_vel_y   R_02_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     42.732766     0.905185    -0.000615     0.000207     2.759877   \n",
       "std       2.837626     2.610050     0.044355     0.046475    15.166566   \n",
       "min      34.958700    -8.380200    -0.416397    -0.397293   -30.934200   \n",
       "25%      40.668000    -0.524597     0.000000     0.000000    -8.455990   \n",
       "50%      43.089600     0.935303     0.000000     0.000000     0.878204   \n",
       "75%      44.413200     2.123990     0.000000     0.000000    10.529400   \n",
       "max      51.180400     6.797610     0.391205     0.417297    49.087700   \n",
       "\n",
       "        R_02_pos_y   R_02_vel_x   R_02_vel_y   R_03_pos_x   R_03_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      2.241877    -0.002761     0.000503    12.483964     3.055914   \n",
       "std       8.666231     0.121613     0.089535    10.698310     8.155176   \n",
       "min     -18.623800    -0.340897    -0.319397    -1.651310   -18.115700   \n",
       "25%      -4.964100    -0.037399    -0.012695     4.456500    -3.384510   \n",
       "50%       4.643010     0.000000     0.000000    10.868600     3.913300   \n",
       "75%       9.573500     0.009506     0.007507    16.478800     9.018010   \n",
       "max      16.457400     0.352402     0.343704    46.261000    25.478800   \n",
       "\n",
       "        R_03_vel_x   R_03_vel_y   R_04_pos_x   R_04_pos_y   R_04_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.001476     0.001070    11.340124    20.183273    -0.001397   \n",
       "std       0.087549     0.102035    11.834271     6.245019     0.086969   \n",
       "min      -0.316605    -0.325699    -8.951510     4.121700    -0.319901   \n",
       "25%      -0.016296    -0.008896     3.149600    14.964500    -0.014404   \n",
       "50%       0.000000     0.000000    10.187200    20.702200     0.000000   \n",
       "75%       0.005402     0.016403    15.949200    25.502600     0.002502   \n",
       "max       0.312897     0.317993    48.785100    32.298900     0.308197   \n",
       "\n",
       "        R_04_vel_y   R_05_pos_x   R_05_pos_y   R_05_vel_x   R_05_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.000605    11.233974   -14.787518    -0.002037     0.000530   \n",
       "std       0.091738    11.701539     8.056235     0.092552     0.104250   \n",
       "min      -0.306595    -9.902600   -35.137200    -0.332108    -0.318695   \n",
       "25%      -0.006897     2.877400   -19.990800    -0.021606    -0.011597   \n",
       "50%       0.000000    10.701800   -14.435800     0.000000     0.000000   \n",
       "75%       0.007095    16.514500   -11.086600     0.003998     0.009598   \n",
       "max       0.312195    46.236000    11.077900     0.334595     0.325607   \n",
       "\n",
       "        R_06_pos_x   R_06_pos_y   R_06_vel_x   R_06_vel_y   R_07_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -9.168780     1.848916    -0.003843    -0.000359    -2.569106   \n",
       "std      15.907319     6.684897     0.110747     0.085229    16.462147   \n",
       "min     -44.756700   -22.696800    -0.326202    -0.322205   -33.808900   \n",
       "25%     -19.787800    -0.975494    -0.020294    -0.005798   -10.111400   \n",
       "50%      -9.580700     0.933502     0.000000     0.000000    -0.500900   \n",
       "75%       0.275101     5.569400     0.007904     0.005600     5.860200   \n",
       "max      33.504400    20.489000     0.322800     0.332703    44.911000   \n",
       "\n",
       "        R_07_pos_y   R_07_vel_x   R_07_vel_y   R_08_pos_x   R_08_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     17.545564    -0.002471     0.002153    -2.929361   -12.056731   \n",
       "std       8.176656     0.114722     0.103710    16.065072     9.553319   \n",
       "min      -7.353610    -0.358307    -0.340393   -41.703300   -35.869000   \n",
       "25%      11.084100    -0.024399    -0.012894   -10.403100   -19.569400   \n",
       "50%      17.093500     0.000000     0.000000    -1.702390   -10.110200   \n",
       "75%      25.091100     0.016495     0.018600     4.779300    -6.947400   \n",
       "max      31.878500     0.364197     0.349304    41.982500    10.363800   \n",
       "\n",
       "        R_08_vel_x   R_08_vel_y   R_09_pos_x   R_09_pos_y   R_09_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.002918    -0.000477   -11.915094    23.903453    -0.001999   \n",
       "std       0.138136     0.123001    17.738374     7.170880     0.124528   \n",
       "min      -0.412003    -0.398895   -50.662500    -8.987000    -0.370895   \n",
       "25%      -0.019394    -0.018204   -20.883700    21.314300    -0.013107   \n",
       "50%       0.000000     0.000000   -11.266900    25.051100     0.000000   \n",
       "75%       0.024200     0.014801    -2.361690    28.897600     0.022598   \n",
       "max       0.432999     0.417206    35.992200    35.710800     0.374893   \n",
       "\n",
       "        R_09_vel_y   R_10_pos_x   R_10_pos_y   R_10_vel_x   R_10_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.000863   -13.432943   -21.725926    -0.002099    -0.000408   \n",
       "std       0.102679    15.770871     6.923577     0.117219     0.107745   \n",
       "min      -0.372192   -51.529500   -34.797300    -0.373795    -0.381104   \n",
       "25%      -0.010605   -20.335600   -27.339000    -0.016602    -0.016098   \n",
       "50%       0.000000   -11.587300   -22.965500     0.000000     0.000000   \n",
       "75%       0.017395    -3.941890   -16.225400     0.015594     0.007095   \n",
       "max       0.364700    25.237200    -5.982300     0.385895     0.391800   \n",
       "\n",
       "        R_11_pos_x   R_11_pos_y   R_11_vel_x   R_11_vel_y  \n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  \n",
       "mean    -15.715282     2.699512    -0.002674     0.001877  \n",
       "std      14.631273    14.358356     0.120981     0.158287  \n",
       "min     -51.884100   -28.881200    -0.443802    -0.451004  \n",
       "25%     -21.287900    -8.644900    -0.013306    -0.018097  \n",
       "50%     -12.015500     4.451400     0.000000     0.000000  \n",
       "75%      -6.763310    14.652700     0.011200     0.019501  \n",
       "max      12.934700    27.954800     0.421799     0.458298  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# The origin of the coordinate system is the center point. Because of this, some position values are negative\n",
    "display(df.describe())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>score_L</th>\n",
       "      <th>score_R</th>\n",
       "      <th>ball_pos_x</th>\n",
       "      <th>ball_pos_y</th>\n",
       "      <th>ball_vel_x</th>\n",
       "      <th>ball_vel_y</th>\n",
       "      <th>L_01_pos_x</th>\n",
       "      <th>L_01_pos_y</th>\n",
       "      <th>L_01_vel_x</th>\n",
       "      <th>L_01_vel_y</th>\n",
       "      <th>L_02_pos_x</th>\n",
       "      <th>L_02_pos_y</th>\n",
       "      <th>L_02_vel_x</th>\n",
       "      <th>L_02_vel_y</th>\n",
       "      <th>L_03_pos_x</th>\n",
       "      <th>L_03_pos_y</th>\n",
       "      <th>L_03_vel_x</th>\n",
       "      <th>L_03_vel_y</th>\n",
       "      <th>L_04_pos_x</th>\n",
       "      <th>L_04_pos_y</th>\n",
       "      <th>L_04_vel_x</th>\n",
       "      <th>L_04_vel_y</th>\n",
       "      <th>L_05_pos_x</th>\n",
       "      <th>L_05_pos_y</th>\n",
       "      <th>L_05_vel_x</th>\n",
       "      <th>L_05_vel_y</th>\n",
       "      <th>L_06_pos_x</th>\n",
       "      <th>L_06_pos_y</th>\n",
       "      <th>L_06_vel_x</th>\n",
       "      <th>L_06_vel_y</th>\n",
       "      <th>L_07_pos_x</th>\n",
       "      <th>L_07_pos_y</th>\n",
       "      <th>L_07_vel_x</th>\n",
       "      <th>L_07_vel_y</th>\n",
       "      <th>L_08_pos_x</th>\n",
       "      <th>L_08_pos_y</th>\n",
       "      <th>L_08_vel_x</th>\n",
       "      <th>L_08_vel_y</th>\n",
       "      <th>L_09_pos_x</th>\n",
       "      <th>L_09_pos_y</th>\n",
       "      <th>L_09_vel_x</th>\n",
       "      <th>L_09_vel_y</th>\n",
       "      <th>L_10_pos_x</th>\n",
       "      <th>L_10_pos_y</th>\n",
       "      <th>L_10_vel_x</th>\n",
       "      <th>L_10_vel_y</th>\n",
       "      <th>L_11_pos_x</th>\n",
       "      <th>L_11_pos_y</th>\n",
       "      <th>L_11_vel_x</th>\n",
       "      <th>L_11_vel_y</th>\n",
       "      <th>R_01_pos_x</th>\n",
       "      <th>R_01_pos_y</th>\n",
       "      <th>R_01_vel_x</th>\n",
       "      <th>R_01_vel_y</th>\n",
       "      <th>R_02_pos_x</th>\n",
       "      <th>R_02_pos_y</th>\n",
       "      <th>R_02_vel_x</th>\n",
       "      <th>R_02_vel_y</th>\n",
       "      <th>R_03_pos_x</th>\n",
       "      <th>R_03_pos_y</th>\n",
       "      <th>R_03_vel_x</th>\n",
       "      <th>R_03_vel_y</th>\n",
       "      <th>R_04_pos_x</th>\n",
       "      <th>R_04_pos_y</th>\n",
       "      <th>R_04_vel_x</th>\n",
       "      <th>R_04_vel_y</th>\n",
       "      <th>R_05_pos_x</th>\n",
       "      <th>R_05_pos_y</th>\n",
       "      <th>R_05_vel_x</th>\n",
       "      <th>R_05_vel_y</th>\n",
       "      <th>R_06_pos_x</th>\n",
       "      <th>R_06_pos_y</th>\n",
       "      <th>R_06_vel_x</th>\n",
       "      <th>R_06_vel_y</th>\n",
       "      <th>R_07_pos_x</th>\n",
       "      <th>R_07_pos_y</th>\n",
       "      <th>R_07_vel_x</th>\n",
       "      <th>R_07_vel_y</th>\n",
       "      <th>R_08_pos_x</th>\n",
       "      <th>R_08_pos_y</th>\n",
       "      <th>R_08_vel_x</th>\n",
       "      <th>R_08_vel_y</th>\n",
       "      <th>R_09_pos_x</th>\n",
       "      <th>R_09_pos_y</th>\n",
       "      <th>R_09_vel_x</th>\n",
       "      <th>R_09_vel_y</th>\n",
       "      <th>R_10_pos_x</th>\n",
       "      <th>R_10_pos_y</th>\n",
       "      <th>R_10_vel_x</th>\n",
       "      <th>R_10_vel_y</th>\n",
       "      <th>R_11_pos_x</th>\n",
       "      <th>R_11_pos_y</th>\n",
       "      <th>R_11_vel_x</th>\n",
       "      <th>R_11_vel_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.0</td>\n",
       "      <td>6329.0</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "      <td>6329.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2960.614631</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>46.396219</td>\n",
       "      <td>40.669853</td>\n",
       "      <td>-0.001189</td>\n",
       "      <td>0.004512</td>\n",
       "      <td>1.833165</td>\n",
       "      <td>34.583756</td>\n",
       "      <td>-0.000179</td>\n",
       "      <td>0.000254</td>\n",
       "      <td>35.160723</td>\n",
       "      <td>30.736116</td>\n",
       "      <td>-0.000919</td>\n",
       "      <td>0.001018</td>\n",
       "      <td>34.614584</td>\n",
       "      <td>42.327948</td>\n",
       "      <td>-0.000949</td>\n",
       "      <td>0.000656</td>\n",
       "      <td>36.514678</td>\n",
       "      <td>19.730603</td>\n",
       "      <td>-0.000064</td>\n",
       "      <td>-0.000167</td>\n",
       "      <td>36.736330</td>\n",
       "      <td>52.987116</td>\n",
       "      <td>-0.000271</td>\n",
       "      <td>0.001170</td>\n",
       "      <td>41.346803</td>\n",
       "      <td>37.271286</td>\n",
       "      <td>-0.001078</td>\n",
       "      <td>0.000776</td>\n",
       "      <td>45.602282</td>\n",
       "      <td>24.100846</td>\n",
       "      <td>0.001008</td>\n",
       "      <td>0.000240</td>\n",
       "      <td>44.971973</td>\n",
       "      <td>50.274952</td>\n",
       "      <td>0.000098</td>\n",
       "      <td>0.001970</td>\n",
       "      <td>48.774009</td>\n",
       "      <td>21.996392</td>\n",
       "      <td>-0.001249</td>\n",
       "      <td>0.002065</td>\n",
       "      <td>48.841603</td>\n",
       "      <td>51.932572</td>\n",
       "      <td>-0.001409</td>\n",
       "      <td>-0.000706</td>\n",
       "      <td>48.862051</td>\n",
       "      <td>37.241093</td>\n",
       "      <td>-0.000712</td>\n",
       "      <td>0.000206</td>\n",
       "      <td>95.232766</td>\n",
       "      <td>34.905185</td>\n",
       "      <td>-0.000615</td>\n",
       "      <td>0.000207</td>\n",
       "      <td>55.259877</td>\n",
       "      <td>36.241877</td>\n",
       "      <td>-0.002761</td>\n",
       "      <td>0.000503</td>\n",
       "      <td>64.983964</td>\n",
       "      <td>37.055914</td>\n",
       "      <td>-0.001476</td>\n",
       "      <td>0.001070</td>\n",
       "      <td>63.840124</td>\n",
       "      <td>54.183273</td>\n",
       "      <td>-0.001397</td>\n",
       "      <td>0.000605</td>\n",
       "      <td>63.733974</td>\n",
       "      <td>19.217843</td>\n",
       "      <td>-0.002037</td>\n",
       "      <td>0.000530</td>\n",
       "      <td>43.331220</td>\n",
       "      <td>35.848916</td>\n",
       "      <td>-0.003843</td>\n",
       "      <td>-0.000359</td>\n",
       "      <td>49.930894</td>\n",
       "      <td>51.545564</td>\n",
       "      <td>-0.002471</td>\n",
       "      <td>0.002153</td>\n",
       "      <td>49.570639</td>\n",
       "      <td>21.949756</td>\n",
       "      <td>-0.002918</td>\n",
       "      <td>-0.000477</td>\n",
       "      <td>40.584906</td>\n",
       "      <td>57.897337</td>\n",
       "      <td>-0.001999</td>\n",
       "      <td>0.000863</td>\n",
       "      <td>39.067057</td>\n",
       "      <td>12.274574</td>\n",
       "      <td>-0.002099</td>\n",
       "      <td>-0.000408</td>\n",
       "      <td>36.784718</td>\n",
       "      <td>36.699512</td>\n",
       "      <td>-0.002674</td>\n",
       "      <td>0.001877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1733.865701</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.021540</td>\n",
       "      <td>21.579349</td>\n",
       "      <td>0.678898</td>\n",
       "      <td>0.950819</td>\n",
       "      <td>0.330235</td>\n",
       "      <td>3.194201</td>\n",
       "      <td>0.006138</td>\n",
       "      <td>0.030724</td>\n",
       "      <td>12.648209</td>\n",
       "      <td>8.506397</td>\n",
       "      <td>0.148115</td>\n",
       "      <td>0.130605</td>\n",
       "      <td>12.948650</td>\n",
       "      <td>8.907047</td>\n",
       "      <td>0.145684</td>\n",
       "      <td>0.134668</td>\n",
       "      <td>14.083729</td>\n",
       "      <td>7.270781</td>\n",
       "      <td>0.119555</td>\n",
       "      <td>0.102194</td>\n",
       "      <td>14.080687</td>\n",
       "      <td>8.214933</td>\n",
       "      <td>0.111272</td>\n",
       "      <td>0.104445</td>\n",
       "      <td>16.155567</td>\n",
       "      <td>10.079861</td>\n",
       "      <td>0.135256</td>\n",
       "      <td>0.116929</td>\n",
       "      <td>16.924414</td>\n",
       "      <td>10.777474</td>\n",
       "      <td>0.116310</td>\n",
       "      <td>0.123406</td>\n",
       "      <td>17.462262</td>\n",
       "      <td>9.872817</td>\n",
       "      <td>0.153242</td>\n",
       "      <td>0.153821</td>\n",
       "      <td>18.734913</td>\n",
       "      <td>9.052817</td>\n",
       "      <td>0.123677</td>\n",
       "      <td>0.121331</td>\n",
       "      <td>19.609866</td>\n",
       "      <td>9.461766</td>\n",
       "      <td>0.128758</td>\n",
       "      <td>0.111542</td>\n",
       "      <td>19.209872</td>\n",
       "      <td>8.265025</td>\n",
       "      <td>0.099697</td>\n",
       "      <td>0.080986</td>\n",
       "      <td>2.837626</td>\n",
       "      <td>2.610050</td>\n",
       "      <td>0.044355</td>\n",
       "      <td>0.046475</td>\n",
       "      <td>15.166566</td>\n",
       "      <td>8.666231</td>\n",
       "      <td>0.121613</td>\n",
       "      <td>0.089535</td>\n",
       "      <td>10.698310</td>\n",
       "      <td>8.155176</td>\n",
       "      <td>0.087549</td>\n",
       "      <td>0.102035</td>\n",
       "      <td>11.834271</td>\n",
       "      <td>6.245019</td>\n",
       "      <td>0.086969</td>\n",
       "      <td>0.091738</td>\n",
       "      <td>11.701539</td>\n",
       "      <td>8.043282</td>\n",
       "      <td>0.092552</td>\n",
       "      <td>0.104250</td>\n",
       "      <td>15.907319</td>\n",
       "      <td>6.684897</td>\n",
       "      <td>0.110747</td>\n",
       "      <td>0.085229</td>\n",
       "      <td>16.462147</td>\n",
       "      <td>8.176656</td>\n",
       "      <td>0.114722</td>\n",
       "      <td>0.103710</td>\n",
       "      <td>16.065072</td>\n",
       "      <td>9.538154</td>\n",
       "      <td>0.138136</td>\n",
       "      <td>0.123001</td>\n",
       "      <td>17.738374</td>\n",
       "      <td>7.161993</td>\n",
       "      <td>0.124528</td>\n",
       "      <td>0.102679</td>\n",
       "      <td>15.770871</td>\n",
       "      <td>6.922669</td>\n",
       "      <td>0.117219</td>\n",
       "      <td>0.107745</td>\n",
       "      <td>14.631273</td>\n",
       "      <td>14.358356</td>\n",
       "      <td>0.120981</td>\n",
       "      <td>0.158287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-2.635600</td>\n",
       "      <td>-2.835900</td>\n",
       "      <td>1.193400</td>\n",
       "      <td>27.488010</td>\n",
       "      <td>-0.147903</td>\n",
       "      <td>-0.316299</td>\n",
       "      <td>6.352300</td>\n",
       "      <td>4.777300</td>\n",
       "      <td>-0.451996</td>\n",
       "      <td>-0.445404</td>\n",
       "      <td>1.766000</td>\n",
       "      <td>24.333690</td>\n",
       "      <td>-0.434204</td>\n",
       "      <td>-0.422607</td>\n",
       "      <td>2.787500</td>\n",
       "      <td>1.972900</td>\n",
       "      <td>-0.348907</td>\n",
       "      <td>-0.339401</td>\n",
       "      <td>5.124400</td>\n",
       "      <td>34.064194</td>\n",
       "      <td>-0.330505</td>\n",
       "      <td>-0.320908</td>\n",
       "      <td>12.105300</td>\n",
       "      <td>16.567400</td>\n",
       "      <td>-0.381897</td>\n",
       "      <td>-0.369095</td>\n",
       "      <td>9.416000</td>\n",
       "      <td>1.402100</td>\n",
       "      <td>-0.334503</td>\n",
       "      <td>-0.336304</td>\n",
       "      <td>12.708900</td>\n",
       "      <td>23.896200</td>\n",
       "      <td>-0.444107</td>\n",
       "      <td>-0.427795</td>\n",
       "      <td>16.582000</td>\n",
       "      <td>3.645600</td>\n",
       "      <td>-0.379898</td>\n",
       "      <td>-0.383698</td>\n",
       "      <td>11.924500</td>\n",
       "      <td>32.919910</td>\n",
       "      <td>-0.378998</td>\n",
       "      <td>-0.360901</td>\n",
       "      <td>14.662600</td>\n",
       "      <td>13.687700</td>\n",
       "      <td>-0.308197</td>\n",
       "      <td>-0.306900</td>\n",
       "      <td>87.458700</td>\n",
       "      <td>25.619800</td>\n",
       "      <td>-0.416397</td>\n",
       "      <td>-0.397293</td>\n",
       "      <td>21.565800</td>\n",
       "      <td>15.376200</td>\n",
       "      <td>-0.340897</td>\n",
       "      <td>-0.319397</td>\n",
       "      <td>50.848690</td>\n",
       "      <td>15.884300</td>\n",
       "      <td>-0.316605</td>\n",
       "      <td>-0.325699</td>\n",
       "      <td>43.548490</td>\n",
       "      <td>38.121700</td>\n",
       "      <td>-0.319901</td>\n",
       "      <td>-0.306595</td>\n",
       "      <td>42.597400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.332108</td>\n",
       "      <td>-0.318695</td>\n",
       "      <td>7.743300</td>\n",
       "      <td>11.303200</td>\n",
       "      <td>-0.326202</td>\n",
       "      <td>-0.322205</td>\n",
       "      <td>18.691100</td>\n",
       "      <td>26.646390</td>\n",
       "      <td>-0.358307</td>\n",
       "      <td>-0.340393</td>\n",
       "      <td>10.796700</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.412003</td>\n",
       "      <td>-0.398895</td>\n",
       "      <td>1.837500</td>\n",
       "      <td>25.013000</td>\n",
       "      <td>-0.370895</td>\n",
       "      <td>-0.372192</td>\n",
       "      <td>0.970500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.373795</td>\n",
       "      <td>-0.381104</td>\n",
       "      <td>0.615900</td>\n",
       "      <td>5.118800</td>\n",
       "      <td>-0.443802</td>\n",
       "      <td>-0.451004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1463.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.019600</td>\n",
       "      <td>25.518200</td>\n",
       "      <td>-0.190500</td>\n",
       "      <td>-0.172800</td>\n",
       "      <td>1.558000</td>\n",
       "      <td>32.646300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>28.074400</td>\n",
       "      <td>24.484410</td>\n",
       "      <td>-0.010498</td>\n",
       "      <td>-0.014694</td>\n",
       "      <td>28.695100</td>\n",
       "      <td>35.224400</td>\n",
       "      <td>-0.008301</td>\n",
       "      <td>-0.012695</td>\n",
       "      <td>27.798600</td>\n",
       "      <td>13.790500</td>\n",
       "      <td>-0.001999</td>\n",
       "      <td>-0.004196</td>\n",
       "      <td>30.629200</td>\n",
       "      <td>46.627100</td>\n",
       "      <td>-0.002502</td>\n",
       "      <td>-0.008301</td>\n",
       "      <td>33.233700</td>\n",
       "      <td>29.699100</td>\n",
       "      <td>-0.028107</td>\n",
       "      <td>-0.025604</td>\n",
       "      <td>36.392500</td>\n",
       "      <td>15.704600</td>\n",
       "      <td>-0.017899</td>\n",
       "      <td>-0.037201</td>\n",
       "      <td>36.638500</td>\n",
       "      <td>43.313710</td>\n",
       "      <td>-0.037796</td>\n",
       "      <td>-0.041199</td>\n",
       "      <td>38.134600</td>\n",
       "      <td>14.841900</td>\n",
       "      <td>-0.014496</td>\n",
       "      <td>-0.031097</td>\n",
       "      <td>38.493200</td>\n",
       "      <td>43.293900</td>\n",
       "      <td>-0.017502</td>\n",
       "      <td>-0.018494</td>\n",
       "      <td>37.281800</td>\n",
       "      <td>32.968400</td>\n",
       "      <td>-0.009003</td>\n",
       "      <td>-0.005203</td>\n",
       "      <td>93.168000</td>\n",
       "      <td>33.475403</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>44.044010</td>\n",
       "      <td>29.035900</td>\n",
       "      <td>-0.037399</td>\n",
       "      <td>-0.012695</td>\n",
       "      <td>56.956500</td>\n",
       "      <td>30.615490</td>\n",
       "      <td>-0.016296</td>\n",
       "      <td>-0.008896</td>\n",
       "      <td>55.649600</td>\n",
       "      <td>48.964500</td>\n",
       "      <td>-0.014404</td>\n",
       "      <td>-0.006897</td>\n",
       "      <td>55.377400</td>\n",
       "      <td>14.009200</td>\n",
       "      <td>-0.021606</td>\n",
       "      <td>-0.011597</td>\n",
       "      <td>32.712200</td>\n",
       "      <td>33.024506</td>\n",
       "      <td>-0.020294</td>\n",
       "      <td>-0.005798</td>\n",
       "      <td>42.388600</td>\n",
       "      <td>45.084100</td>\n",
       "      <td>-0.024399</td>\n",
       "      <td>-0.012894</td>\n",
       "      <td>42.096900</td>\n",
       "      <td>14.430600</td>\n",
       "      <td>-0.019394</td>\n",
       "      <td>-0.018204</td>\n",
       "      <td>31.616300</td>\n",
       "      <td>55.314300</td>\n",
       "      <td>-0.013107</td>\n",
       "      <td>-0.010605</td>\n",
       "      <td>32.164400</td>\n",
       "      <td>6.661000</td>\n",
       "      <td>-0.016602</td>\n",
       "      <td>-0.016098</td>\n",
       "      <td>31.212100</td>\n",
       "      <td>25.355100</td>\n",
       "      <td>-0.013306</td>\n",
       "      <td>-0.018097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2955.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>49.661200</td>\n",
       "      <td>42.697800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.833500</td>\n",
       "      <td>34.784302</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>38.874600</td>\n",
       "      <td>32.857300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>38.974800</td>\n",
       "      <td>42.727490</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>39.918500</td>\n",
       "      <td>21.712000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>40.162500</td>\n",
       "      <td>52.746400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>43.799410</td>\n",
       "      <td>39.052200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>47.117200</td>\n",
       "      <td>24.985000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>46.603500</td>\n",
       "      <td>51.082200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>45.163700</td>\n",
       "      <td>22.684000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>44.899000</td>\n",
       "      <td>53.369900</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>43.613490</td>\n",
       "      <td>35.759700</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>95.589600</td>\n",
       "      <td>34.935303</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>53.378204</td>\n",
       "      <td>38.643010</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>63.368600</td>\n",
       "      <td>37.913300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>62.687200</td>\n",
       "      <td>54.702200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>63.201800</td>\n",
       "      <td>19.564200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.919300</td>\n",
       "      <td>34.933502</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>51.999100</td>\n",
       "      <td>51.093500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>50.797610</td>\n",
       "      <td>23.889800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>41.233100</td>\n",
       "      <td>59.051100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>40.912700</td>\n",
       "      <td>11.034500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>40.484500</td>\n",
       "      <td>38.451400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>4448.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.129000</td>\n",
       "      <td>61.677800</td>\n",
       "      <td>0.174600</td>\n",
       "      <td>0.234900</td>\n",
       "      <td>1.977400</td>\n",
       "      <td>37.280810</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>43.631200</td>\n",
       "      <td>38.127300</td>\n",
       "      <td>0.027801</td>\n",
       "      <td>0.018799</td>\n",
       "      <td>43.410800</td>\n",
       "      <td>50.536100</td>\n",
       "      <td>0.024307</td>\n",
       "      <td>0.011795</td>\n",
       "      <td>44.983090</td>\n",
       "      <td>25.025300</td>\n",
       "      <td>0.012299</td>\n",
       "      <td>0.007599</td>\n",
       "      <td>45.947490</td>\n",
       "      <td>59.285800</td>\n",
       "      <td>0.014297</td>\n",
       "      <td>0.007202</td>\n",
       "      <td>50.434910</td>\n",
       "      <td>46.233500</td>\n",
       "      <td>0.041596</td>\n",
       "      <td>0.034699</td>\n",
       "      <td>55.271500</td>\n",
       "      <td>32.793500</td>\n",
       "      <td>0.031799</td>\n",
       "      <td>0.033905</td>\n",
       "      <td>55.224700</td>\n",
       "      <td>58.100700</td>\n",
       "      <td>0.047806</td>\n",
       "      <td>0.056503</td>\n",
       "      <td>59.820600</td>\n",
       "      <td>29.334110</td>\n",
       "      <td>0.036194</td>\n",
       "      <td>0.028397</td>\n",
       "      <td>59.019700</td>\n",
       "      <td>60.415000</td>\n",
       "      <td>0.032898</td>\n",
       "      <td>0.022293</td>\n",
       "      <td>59.121800</td>\n",
       "      <td>41.519590</td>\n",
       "      <td>0.009506</td>\n",
       "      <td>0.005707</td>\n",
       "      <td>96.913200</td>\n",
       "      <td>36.123990</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>63.029400</td>\n",
       "      <td>43.573500</td>\n",
       "      <td>0.009506</td>\n",
       "      <td>0.007507</td>\n",
       "      <td>68.978800</td>\n",
       "      <td>43.018010</td>\n",
       "      <td>0.005402</td>\n",
       "      <td>0.016403</td>\n",
       "      <td>68.449200</td>\n",
       "      <td>59.502600</td>\n",
       "      <td>0.002502</td>\n",
       "      <td>0.007095</td>\n",
       "      <td>69.014500</td>\n",
       "      <td>22.913400</td>\n",
       "      <td>0.003998</td>\n",
       "      <td>0.009598</td>\n",
       "      <td>52.775101</td>\n",
       "      <td>39.569400</td>\n",
       "      <td>0.007904</td>\n",
       "      <td>0.005600</td>\n",
       "      <td>58.360200</td>\n",
       "      <td>59.091100</td>\n",
       "      <td>0.016495</td>\n",
       "      <td>0.018600</td>\n",
       "      <td>57.279300</td>\n",
       "      <td>27.052600</td>\n",
       "      <td>0.024200</td>\n",
       "      <td>0.014801</td>\n",
       "      <td>50.138310</td>\n",
       "      <td>62.897600</td>\n",
       "      <td>0.022598</td>\n",
       "      <td>0.017395</td>\n",
       "      <td>48.558110</td>\n",
       "      <td>17.774600</td>\n",
       "      <td>0.015594</td>\n",
       "      <td>0.007095</td>\n",
       "      <td>45.736690</td>\n",
       "      <td>48.652700</td>\n",
       "      <td>0.011200</td>\n",
       "      <td>0.019501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>6000.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105.000000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>2.737600</td>\n",
       "      <td>2.927600</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>40.564900</td>\n",
       "      <td>0.089706</td>\n",
       "      <td>0.274307</td>\n",
       "      <td>56.730100</td>\n",
       "      <td>43.584400</td>\n",
       "      <td>0.439301</td>\n",
       "      <td>0.453003</td>\n",
       "      <td>52.492706</td>\n",
       "      <td>61.822700</td>\n",
       "      <td>0.427399</td>\n",
       "      <td>0.428696</td>\n",
       "      <td>66.579400</td>\n",
       "      <td>32.692200</td>\n",
       "      <td>0.351700</td>\n",
       "      <td>0.354706</td>\n",
       "      <td>65.013100</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>0.323395</td>\n",
       "      <td>0.328598</td>\n",
       "      <td>84.410600</td>\n",
       "      <td>60.264500</td>\n",
       "      <td>0.371307</td>\n",
       "      <td>0.365005</td>\n",
       "      <td>93.841200</td>\n",
       "      <td>48.686400</td>\n",
       "      <td>0.332596</td>\n",
       "      <td>0.335098</td>\n",
       "      <td>97.766200</td>\n",
       "      <td>66.699300</td>\n",
       "      <td>0.434402</td>\n",
       "      <td>0.419403</td>\n",
       "      <td>99.111300</td>\n",
       "      <td>49.126900</td>\n",
       "      <td>0.389694</td>\n",
       "      <td>0.384903</td>\n",
       "      <td>104.390000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>0.371994</td>\n",
       "      <td>0.375793</td>\n",
       "      <td>101.307400</td>\n",
       "      <td>60.865500</td>\n",
       "      <td>0.310196</td>\n",
       "      <td>0.302597</td>\n",
       "      <td>103.680400</td>\n",
       "      <td>40.797610</td>\n",
       "      <td>0.391205</td>\n",
       "      <td>0.417297</td>\n",
       "      <td>101.587700</td>\n",
       "      <td>50.457400</td>\n",
       "      <td>0.352402</td>\n",
       "      <td>0.343704</td>\n",
       "      <td>98.761000</td>\n",
       "      <td>59.478800</td>\n",
       "      <td>0.312897</td>\n",
       "      <td>0.317993</td>\n",
       "      <td>101.285100</td>\n",
       "      <td>66.298900</td>\n",
       "      <td>0.308197</td>\n",
       "      <td>0.312195</td>\n",
       "      <td>98.736000</td>\n",
       "      <td>45.077900</td>\n",
       "      <td>0.334595</td>\n",
       "      <td>0.325607</td>\n",
       "      <td>86.004400</td>\n",
       "      <td>54.489000</td>\n",
       "      <td>0.322800</td>\n",
       "      <td>0.332703</td>\n",
       "      <td>97.411000</td>\n",
       "      <td>65.878500</td>\n",
       "      <td>0.364197</td>\n",
       "      <td>0.349304</td>\n",
       "      <td>94.482500</td>\n",
       "      <td>44.363800</td>\n",
       "      <td>0.432999</td>\n",
       "      <td>0.417206</td>\n",
       "      <td>88.492200</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>0.374893</td>\n",
       "      <td>0.364700</td>\n",
       "      <td>77.737200</td>\n",
       "      <td>28.017700</td>\n",
       "      <td>0.385895</td>\n",
       "      <td>0.391800</td>\n",
       "      <td>65.434700</td>\n",
       "      <td>61.954800</td>\n",
       "      <td>0.421799</td>\n",
       "      <td>0.458298</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              time  score_L  score_R   ball_pos_x   ball_pos_y   ball_vel_x  \\\n",
       "count  6329.000000   6329.0   6329.0  6329.000000  6329.000000  6329.000000   \n",
       "mean   2960.614631      0.0      0.0    46.396219    40.669853    -0.001189   \n",
       "std    1733.865701      0.0      0.0    20.021540    21.579349     0.678898   \n",
       "min       1.000000      0.0      0.0     1.000000     0.000000    -2.635600   \n",
       "25%    1463.000000      0.0      0.0    35.019600    25.518200    -0.190500   \n",
       "50%    2955.000000      0.0      0.0    49.661200    42.697800     0.000000   \n",
       "75%    4448.000000      0.0      0.0    57.129000    61.677800     0.174600   \n",
       "max    6000.000000      0.0      0.0   105.000000    68.000000     2.737600   \n",
       "\n",
       "        ball_vel_y   L_01_pos_x   L_01_pos_y   L_01_vel_x   L_01_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.004512     1.833165    34.583756    -0.000179     0.000254   \n",
       "std       0.950819     0.330235     3.194201     0.006138     0.030724   \n",
       "min      -2.835900     1.193400    27.488010    -0.147903    -0.316299   \n",
       "25%      -0.172800     1.558000    32.646300     0.000000     0.000000   \n",
       "50%       0.000000     1.833500    34.784302     0.000000     0.000000   \n",
       "75%       0.234900     1.977400    37.280810     0.000000     0.000000   \n",
       "max       2.927600     3.500000    40.564900     0.089706     0.274307   \n",
       "\n",
       "        L_02_pos_x   L_02_pos_y   L_02_vel_x   L_02_vel_y   L_03_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     35.160723    30.736116    -0.000919     0.001018    34.614584   \n",
       "std      12.648209     8.506397     0.148115     0.130605    12.948650   \n",
       "min       6.352300     4.777300    -0.451996    -0.445404     1.766000   \n",
       "25%      28.074400    24.484410    -0.010498    -0.014694    28.695100   \n",
       "50%      38.874600    32.857300     0.000000     0.000000    38.974800   \n",
       "75%      43.631200    38.127300     0.027801     0.018799    43.410800   \n",
       "max      56.730100    43.584400     0.439301     0.453003    52.492706   \n",
       "\n",
       "        L_03_pos_y   L_03_vel_x   L_03_vel_y   L_04_pos_x   L_04_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     42.327948    -0.000949     0.000656    36.514678    19.730603   \n",
       "std       8.907047     0.145684     0.134668    14.083729     7.270781   \n",
       "min      24.333690    -0.434204    -0.422607     2.787500     1.972900   \n",
       "25%      35.224400    -0.008301    -0.012695    27.798600    13.790500   \n",
       "50%      42.727490     0.000000     0.000000    39.918500    21.712000   \n",
       "75%      50.536100     0.024307     0.011795    44.983090    25.025300   \n",
       "max      61.822700     0.427399     0.428696    66.579400    32.692200   \n",
       "\n",
       "        L_04_vel_x   L_04_vel_y   L_05_pos_x   L_05_pos_y   L_05_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.000064    -0.000167    36.736330    52.987116    -0.000271   \n",
       "std       0.119555     0.102194    14.080687     8.214933     0.111272   \n",
       "min      -0.348907    -0.339401     5.124400    34.064194    -0.330505   \n",
       "25%      -0.001999    -0.004196    30.629200    46.627100    -0.002502   \n",
       "50%       0.000000     0.000000    40.162500    52.746400     0.000000   \n",
       "75%       0.012299     0.007599    45.947490    59.285800     0.014297   \n",
       "max       0.351700     0.354706    65.013100    68.000000     0.323395   \n",
       "\n",
       "        L_05_vel_y   L_06_pos_x   L_06_pos_y   L_06_vel_x   L_06_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.001170    41.346803    37.271286    -0.001078     0.000776   \n",
       "std       0.104445    16.155567    10.079861     0.135256     0.116929   \n",
       "min      -0.320908    12.105300    16.567400    -0.381897    -0.369095   \n",
       "25%      -0.008301    33.233700    29.699100    -0.028107    -0.025604   \n",
       "50%       0.000000    43.799410    39.052200     0.000000     0.000000   \n",
       "75%       0.007202    50.434910    46.233500     0.041596     0.034699   \n",
       "max       0.328598    84.410600    60.264500     0.371307     0.365005   \n",
       "\n",
       "        L_07_pos_x   L_07_pos_y   L_07_vel_x   L_07_vel_y   L_08_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     45.602282    24.100846     0.001008     0.000240    44.971973   \n",
       "std      16.924414    10.777474     0.116310     0.123406    17.462262   \n",
       "min       9.416000     1.402100    -0.334503    -0.336304    12.708900   \n",
       "25%      36.392500    15.704600    -0.017899    -0.037201    36.638500   \n",
       "50%      47.117200    24.985000     0.000000     0.000000    46.603500   \n",
       "75%      55.271500    32.793500     0.031799     0.033905    55.224700   \n",
       "max      93.841200    48.686400     0.332596     0.335098    97.766200   \n",
       "\n",
       "        L_08_pos_y   L_08_vel_x   L_08_vel_y   L_09_pos_x   L_09_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     50.274952     0.000098     0.001970    48.774009    21.996392   \n",
       "std       9.872817     0.153242     0.153821    18.734913     9.052817   \n",
       "min      23.896200    -0.444107    -0.427795    16.582000     3.645600   \n",
       "25%      43.313710    -0.037796    -0.041199    38.134600    14.841900   \n",
       "50%      51.082200     0.000000     0.000000    45.163700    22.684000   \n",
       "75%      58.100700     0.047806     0.056503    59.820600    29.334110   \n",
       "max      66.699300     0.434402     0.419403    99.111300    49.126900   \n",
       "\n",
       "        L_09_vel_x   L_09_vel_y   L_10_pos_x   L_10_pos_y   L_10_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.001249     0.002065    48.841603    51.932572    -0.001409   \n",
       "std       0.123677     0.121331    19.609866     9.461766     0.128758   \n",
       "min      -0.379898    -0.383698    11.924500    32.919910    -0.378998   \n",
       "25%      -0.014496    -0.031097    38.493200    43.293900    -0.017502   \n",
       "50%       0.000000     0.000000    44.899000    53.369900     0.000000   \n",
       "75%       0.036194     0.028397    59.019700    60.415000     0.032898   \n",
       "max       0.389694     0.384903   104.390000    68.000000     0.371994   \n",
       "\n",
       "        L_10_vel_y   L_11_pos_x   L_11_pos_y   L_11_vel_x   L_11_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.000706    48.862051    37.241093    -0.000712     0.000206   \n",
       "std       0.111542    19.209872     8.265025     0.099697     0.080986   \n",
       "min      -0.360901    14.662600    13.687700    -0.308197    -0.306900   \n",
       "25%      -0.018494    37.281800    32.968400    -0.009003    -0.005203   \n",
       "50%       0.000000    43.613490    35.759700     0.000000     0.000000   \n",
       "75%       0.022293    59.121800    41.519590     0.009506     0.005707   \n",
       "max       0.375793   101.307400    60.865500     0.310196     0.302597   \n",
       "\n",
       "        R_01_pos_x   R_01_pos_y   R_01_vel_x   R_01_vel_y   R_02_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     95.232766    34.905185    -0.000615     0.000207    55.259877   \n",
       "std       2.837626     2.610050     0.044355     0.046475    15.166566   \n",
       "min      87.458700    25.619800    -0.416397    -0.397293    21.565800   \n",
       "25%      93.168000    33.475403     0.000000     0.000000    44.044010   \n",
       "50%      95.589600    34.935303     0.000000     0.000000    53.378204   \n",
       "75%      96.913200    36.123990     0.000000     0.000000    63.029400   \n",
       "max     103.680400    40.797610     0.391205     0.417297   101.587700   \n",
       "\n",
       "        R_02_pos_y   R_02_vel_x   R_02_vel_y   R_03_pos_x   R_03_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     36.241877    -0.002761     0.000503    64.983964    37.055914   \n",
       "std       8.666231     0.121613     0.089535    10.698310     8.155176   \n",
       "min      15.376200    -0.340897    -0.319397    50.848690    15.884300   \n",
       "25%      29.035900    -0.037399    -0.012695    56.956500    30.615490   \n",
       "50%      38.643010     0.000000     0.000000    63.368600    37.913300   \n",
       "75%      43.573500     0.009506     0.007507    68.978800    43.018010   \n",
       "max      50.457400     0.352402     0.343704    98.761000    59.478800   \n",
       "\n",
       "        R_03_vel_x   R_03_vel_y   R_04_pos_x   R_04_pos_y   R_04_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.001476     0.001070    63.840124    54.183273    -0.001397   \n",
       "std       0.087549     0.102035    11.834271     6.245019     0.086969   \n",
       "min      -0.316605    -0.325699    43.548490    38.121700    -0.319901   \n",
       "25%      -0.016296    -0.008896    55.649600    48.964500    -0.014404   \n",
       "50%       0.000000     0.000000    62.687200    54.702200     0.000000   \n",
       "75%       0.005402     0.016403    68.449200    59.502600     0.002502   \n",
       "max       0.312897     0.317993   101.285100    66.298900     0.308197   \n",
       "\n",
       "        R_04_vel_y   R_05_pos_x   R_05_pos_y   R_05_vel_x   R_05_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.000605    63.733974    19.217843    -0.002037     0.000530   \n",
       "std       0.091738    11.701539     8.043282     0.092552     0.104250   \n",
       "min      -0.306595    42.597400     0.000000    -0.332108    -0.318695   \n",
       "25%      -0.006897    55.377400    14.009200    -0.021606    -0.011597   \n",
       "50%       0.000000    63.201800    19.564200     0.000000     0.000000   \n",
       "75%       0.007095    69.014500    22.913400     0.003998     0.009598   \n",
       "max       0.312195    98.736000    45.077900     0.334595     0.325607   \n",
       "\n",
       "        R_06_pos_x   R_06_pos_y   R_06_vel_x   R_06_vel_y   R_07_pos_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     43.331220    35.848916    -0.003843    -0.000359    49.930894   \n",
       "std      15.907319     6.684897     0.110747     0.085229    16.462147   \n",
       "min       7.743300    11.303200    -0.326202    -0.322205    18.691100   \n",
       "25%      32.712200    33.024506    -0.020294    -0.005798    42.388600   \n",
       "50%      42.919300    34.933502     0.000000     0.000000    51.999100   \n",
       "75%      52.775101    39.569400     0.007904     0.005600    58.360200   \n",
       "max      86.004400    54.489000     0.322800     0.332703    97.411000   \n",
       "\n",
       "        R_07_pos_y   R_07_vel_x   R_07_vel_y   R_08_pos_x   R_08_pos_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     51.545564    -0.002471     0.002153    49.570639    21.949756   \n",
       "std       8.176656     0.114722     0.103710    16.065072     9.538154   \n",
       "min      26.646390    -0.358307    -0.340393    10.796700     0.000000   \n",
       "25%      45.084100    -0.024399    -0.012894    42.096900    14.430600   \n",
       "50%      51.093500     0.000000     0.000000    50.797610    23.889800   \n",
       "75%      59.091100     0.016495     0.018600    57.279300    27.052600   \n",
       "max      65.878500     0.364197     0.349304    94.482500    44.363800   \n",
       "\n",
       "        R_08_vel_x   R_08_vel_y   R_09_pos_x   R_09_pos_y   R_09_vel_x  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean     -0.002918    -0.000477    40.584906    57.897337    -0.001999   \n",
       "std       0.138136     0.123001    17.738374     7.161993     0.124528   \n",
       "min      -0.412003    -0.398895     1.837500    25.013000    -0.370895   \n",
       "25%      -0.019394    -0.018204    31.616300    55.314300    -0.013107   \n",
       "50%       0.000000     0.000000    41.233100    59.051100     0.000000   \n",
       "75%       0.024200     0.014801    50.138310    62.897600     0.022598   \n",
       "max       0.432999     0.417206    88.492200    68.000000     0.374893   \n",
       "\n",
       "        R_09_vel_y   R_10_pos_x   R_10_pos_y   R_10_vel_x   R_10_vel_y  \\\n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  6329.000000   \n",
       "mean      0.000863    39.067057    12.274574    -0.002099    -0.000408   \n",
       "std       0.102679    15.770871     6.922669     0.117219     0.107745   \n",
       "min      -0.372192     0.970500     0.000000    -0.373795    -0.381104   \n",
       "25%      -0.010605    32.164400     6.661000    -0.016602    -0.016098   \n",
       "50%       0.000000    40.912700    11.034500     0.000000     0.000000   \n",
       "75%       0.017395    48.558110    17.774600     0.015594     0.007095   \n",
       "max       0.364700    77.737200    28.017700     0.385895     0.391800   \n",
       "\n",
       "        R_11_pos_x   R_11_pos_y   R_11_vel_x   R_11_vel_y  \n",
       "count  6329.000000  6329.000000  6329.000000  6329.000000  \n",
       "mean     36.784718    36.699512    -0.002674     0.001877  \n",
       "std      14.631273    14.358356     0.120981     0.158287  \n",
       "min       0.615900     5.118800    -0.443802    -0.451004  \n",
       "25%      31.212100    25.355100    -0.013306    -0.018097  \n",
       "50%      40.484500    38.451400     0.000000     0.000000  \n",
       "75%      45.736690    48.652700     0.011200     0.019501  \n",
       "max      65.434700    61.954800     0.421799     0.458298  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Let's move the origin to the lower left corner, so all the positions are positive values.\n",
    "# Pitch size: 105m x 68m\n",
    "\n",
    "position_columns = [c for c in df.columns if \"pos\" in c]\n",
    "for position_column in position_columns:\n",
    "    shift_value = 52.5 if \"x\" in position_column else 34\n",
    "    max_value = shift_value * 2\n",
    "    df.loc[:, position_column] = df.loc[:, position_column] + shift_value\n",
    "    df[position_column].where(df[position_column]  >= 0, 0, inplace=True)\n",
    "    df[position_column].where(df[position_column]  <= max_value, max_value, inplace=True)\n",
    "    \n",
    "display(df.describe())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([' kick_off_l', ' play_on', ' foul_charge_r', ' free_kick_l',\n",
       "       ' kick_in_l', ' foul_charge_l', ' free_kick_r', ' kick_in_r',\n",
       "       ' corner_kick_l', ' corner_kick_r', ' kick_off_r', ' time_over'],\n",
       "      dtype=object)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Let's check the 'playmode' values\n",
    "display(df[\"playmode\"].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/markdown": [
       "**Match result**: 0 L - 0 R"
      ],
      "text/plain": [
       "<IPython.core.display.Markdown object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# And the final match result...\n",
    "time_over_row = df[\"playmode\"] == \" time_over\"\n",
    "final_score_L = df.loc[time_over_row].iloc[0][\"score_L\"]\n",
    "final_score_R = df.loc[time_over_row].iloc[0][\"score_R\"]\n",
    "display(md(\"**Match result**: {0} L - {1} R\".format(final_score_L, final_score_R)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export results\n",
    "df.to_csv(\"data/output/groundtruth_cleaned.csv\", sep=\";\", encoding=\"utf-8\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "robocupsimdata",
   "language": "python",
   "name": "robocupsimdata"
  },
  "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.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}