time-stamp-relation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "cc5d55d5",
   "metadata": {
    "_cell_guid": "b1076dfc-b9ad-4769-8c92-a6c4dae69d19",
    "_uuid": "8f2839f25d086af736a60e9eeb907d3b93b6e0e5",
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:29.320738Z",
     "iopub.status.busy": "2022-04-16T16:25:29.318814Z",
     "iopub.status.idle": "2022-04-16T16:25:30.452237Z",
     "shell.execute_reply": "2022-04-16T16:25:30.451263Z",
     "shell.execute_reply.started": "2022-04-16T15:08:21.705767Z"
    },
    "papermill": {
     "duration": 1.178468,
     "end_time": "2022-04-16T16:25:30.452472",
     "exception": false,
     "start_time": "2022-04-16T16:25:29.274004",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "from matplotlib.patches import Arc\n",
    "import bz2\n",
    "from glob import glob\n",
    "import imageio\n",
    "import json\n",
    "# from IPython.core.interactiveshell import InteractiveShell\n",
    "# InteractiveShell.ast_node_interactivity = \"all\"\n",
    "# from IPython import display"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "31eb5115",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:30.532785Z",
     "iopub.status.busy": "2022-04-16T16:25:30.531664Z",
     "iopub.status.idle": "2022-04-16T16:25:42.894198Z",
     "shell.execute_reply": "2022-04-16T16:25:42.893570Z",
     "shell.execute_reply.started": "2022-04-16T15:16:35.847724Z"
    },
    "papermill": {
     "duration": 12.403825,
     "end_time": "2022-04-16T16:25:42.894386",
     "exception": false,
     "start_time": "2022-04-16T16:25:30.490561",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting tables\r\n",
      "  Downloading tables-3.7.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (5.9 MB)\r\n",
      "     |████████████████████████████████| 5.9 MB 894 kB/s            \r\n",
      "\u001b[?25hRequirement already satisfied: numexpr>=2.6.2 in /opt/conda/lib/python3.7/site-packages (from tables) (2.8.1)\r\n",
      "Requirement already satisfied: numpy>=1.19.0 in /opt/conda/lib/python3.7/site-packages (from tables) (1.20.3)\r\n",
      "Requirement already satisfied: packaging in /opt/conda/lib/python3.7/site-packages (from tables) (21.3)\r\n",
      "Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in /opt/conda/lib/python3.7/site-packages (from packaging->tables) (3.0.6)\r\n",
      "Installing collected packages: tables\r\n",
      "Successfully installed tables-3.7.0\r\n",
      "\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\r\n"
     ]
    }
   ],
   "source": [
    "!pip install tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "abab409d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:42.990313Z",
     "iopub.status.busy": "2022-04-16T16:25:42.989641Z",
     "iopub.status.idle": "2022-04-16T16:25:42.992357Z",
     "shell.execute_reply": "2022-04-16T16:25:42.991724Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.028633Z"
    },
    "papermill": {
     "duration": 0.053045,
     "end_time": "2022-04-16T16:25:42.992522",
     "exception": false,
     "start_time": "2022-04-16T16:25:42.939477",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "sns.set(rc={'figure.figsize':(15,10)})\n",
    "length = 105\n",
    "width = 68"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ee7a20b8",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.112340Z",
     "iopub.status.busy": "2022-04-16T16:25:43.093233Z",
     "iopub.status.idle": "2022-04-16T16:25:43.114874Z",
     "shell.execute_reply": "2022-04-16T16:25:43.114254Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.039447Z"
    },
    "jupyter": {
     "source_hidden": true
    },
    "papermill": {
     "duration": 0.074502,
     "end_time": "2022-04-16T16:25:43.115028",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.040526",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "def create_pitch(length, width, linecolor, bounds = 15):\n",
    "\n",
    "    \"\"\"\n",
    "    mainly stolen from fc python\n",
    "    param length: an int the length of the field\n",
    "    param width: an int the height of the field\n",
    "    param linecolor: the color of the lines\n",
    "\"\"\"\n",
    "    #Create figure\n",
    "    fig=plt.figure()\n",
    "    #fig.set_size_inches(7, 5)\n",
    "    ax=fig.add_subplot(1,1,1)\n",
    "\n",
    "    #Pitch Outline & Centre Line\n",
    "    plt.plot([0,0],[0,width], color=linecolor)\n",
    "    plt.plot([0,length],[width,width], color=linecolor)\n",
    "    plt.plot([length,length],[width,0], color=linecolor)\n",
    "    plt.plot([length,0],[0,0], color=linecolor)\n",
    "    plt.plot([length/2,length/2],[0,width], color=linecolor)\n",
    "    plt.fill_between(x = [-bounds, length+bounds],\n",
    "                     y1 = [width+bounds, width + bounds],\n",
    "                     y2 = [-bounds, -bounds], color='green')\n",
    "\n",
    "    #Left Penalty Area\n",
    "    plt.plot([16.5 ,16.5],[(width/2 +16.5),(width/2-16.5)],color=linecolor)\n",
    "    plt.plot([0,16.5],[(width/2 +16.5),(width/2 +16.5)],color=linecolor)\n",
    "    plt.plot([16.5,0],[(width/2 -16.5),(width/2 -16.5)],color=linecolor)\n",
    "\n",
    "    #Right Penalty Area\n",
    "    plt.plot([(length-16.5),length],[(width/2 +16.5),(width/2 +16.5)],color=linecolor)\n",
    "    plt.plot([(length-16.5), (length-16.5)],[(width/2 +16.5),(width/2-16.5)],color=linecolor)\n",
    "    plt.plot([(length-16.5),length],[(width/2 -16.5),(width/2 -16.5)],color=linecolor)\n",
    "\n",
    "    #Left 5-meters Box\n",
    "    plt.plot([0,5.5],[(width/2+7.32/2+5.5),(width/2+7.32/2+5.5)],color=linecolor)\n",
    "    plt.plot([5.5,5.5],[(width/2+7.32/2+5.5),(width/2-7.32/2-5.5)],color=linecolor)\n",
    "    plt.plot([5.5,0.5],[(width/2-7.32/2-5.5),(width/2-7.32/2-5.5)],color=linecolor)\n",
    "\n",
    "    #Right 5-meters Box\n",
    "    plt.plot([length,length-5.5],[(width/2+7.32/2+5.5),(width/2+7.32/2+5.5)],color=linecolor)\n",
    "    plt.plot([length-5.5,length-5.5],[(width/2+7.32/2+5.5),width/2-7.32/2-5.5],color=linecolor)\n",
    "    plt.plot([length-5.5,length],[width/2-7.32/2-5.5,width/2-7.32/2-5.5],color=linecolor)\n",
    "\n",
    "    #Prepare Circles\n",
    "    centreCircle = plt.Circle((length/2,width/2),9.15,color=linecolor,fill=False)\n",
    "    centreSpot = plt.Circle((length/2,width/2),0.8,color=linecolor)\n",
    "    leftPenSpot = plt.Circle((11,width/2),0.8,color=linecolor)\n",
    "    rightPenSpot = plt.Circle((length-11,width/2),0.8,color=linecolor)\n",
    "\n",
    "    #Draw Circles\n",
    "    ax.add_patch(centreCircle)\n",
    "    ax.add_patch(centreSpot)\n",
    "    ax.add_patch(leftPenSpot)\n",
    "    ax.add_patch(rightPenSpot)\n",
    "\n",
    "    #Prepare Arcs\n",
    "    leftArc = Arc((11,width/2),height=18.3,width=18.3,angle=0,theta1=308,theta2=52,color=linecolor)\n",
    "    rightArc = Arc((length-11,width/2),height=18.3,width=18.3,angle=0,theta1=128,theta2=232,color=linecolor)\n",
    "\n",
    "    #Draw Arcs\n",
    "    ax.add_patch(leftArc)\n",
    "    ax.add_patch(rightArc)\n",
    "            #Axis titles\n",
    "    #Tidy Axes\n",
    "    plt.axis('off')\n",
    "    \n",
    "    return fig,ax"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "0fde82ab",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.209954Z",
     "iopub.status.busy": "2022-04-16T16:25:43.209190Z",
     "iopub.status.idle": "2022-04-16T16:25:43.249115Z",
     "shell.execute_reply": "2022-04-16T16:25:43.249722Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.077996Z"
    },
    "papermill": {
     "duration": 0.090388,
     "end_time": "2022-04-16T16:25:43.249916",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.159528",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "match_results = pd.read_csv(\"../input/euro-cup-2020/eurocup_2020_results.csv\")\n",
    "#original dataset has whitespaces, so annoying\n",
    "match_results[['team_name_home', 'team_name_away']] = match_results[['team_name_home', 'team_name_away']].applymap(lambda x: str.strip(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e3bb0026",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.342784Z",
     "iopub.status.busy": "2022-04-16T16:25:43.342085Z",
     "iopub.status.idle": "2022-04-16T16:25:43.350380Z",
     "shell.execute_reply": "2022-04-16T16:25:43.350977Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.143639Z"
    },
    "papermill": {
     "duration": 0.056866,
     "end_time": "2022-04-16T16:25:43.351163",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.294297",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "iw_mask = (match_results.team_name_home == \"Italy\") & (match_results.team_name_away == \"Wales\")\n",
    "italy_wales = match_results[iw_mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "7a4e3a59",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.442349Z",
     "iopub.status.busy": "2022-04-16T16:25:43.441686Z",
     "iopub.status.idle": "2022-04-16T16:25:43.448992Z",
     "shell.execute_reply": "2022-04-16T16:25:43.449615Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.155821Z"
    },
    "papermill": {
     "duration": 0.05463,
     "end_time": "2022-04-16T16:25:43.449793",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.395163",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "italy_wales_matches = match_results['team_name_home'].isin([\"Italy\", \"Wales\"]) | match_results['team_name_away'].isin([\"Italy\", \"Wales\"])\n",
    "iw_matches = match_results[italy_wales_matches]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "95d13795",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.544946Z",
     "iopub.status.busy": "2022-04-16T16:25:43.544265Z",
     "iopub.status.idle": "2022-04-16T16:25:43.569366Z",
     "shell.execute_reply": "2022-04-16T16:25:43.569899Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.176149Z"
    },
    "papermill": {
     "duration": 0.073955,
     "end_time": "2022-04-16T16:25:43.570074",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.496119",
     "status": "completed"
    },
    "tags": []
   },
   "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>stage</th>\n",
       "      <th>date</th>\n",
       "      <th>pens</th>\n",
       "      <th>pens_home_score</th>\n",
       "      <th>pens_away_score</th>\n",
       "      <th>team_name_home</th>\n",
       "      <th>team_name_away</th>\n",
       "      <th>team_home_score</th>\n",
       "      <th>team_away_score</th>\n",
       "      <th>possession_home</th>\n",
       "      <th>possession_away</th>\n",
       "      <th>total_shots_home</th>\n",
       "      <th>total_shots_away</th>\n",
       "      <th>shots_on_target_home</th>\n",
       "      <th>shots_on_target_away</th>\n",
       "      <th>duels_won_home</th>\n",
       "      <th>duels_won_away</th>\n",
       "      <th>events_list</th>\n",
       "      <th>lineup_home</th>\n",
       "      <th>lineup_away</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Final</td>\n",
       "      <td>11.07.2021</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Italy</td>\n",
       "      <td>England</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>66%</td>\n",
       "      <td>34%</td>\n",
       "      <td>19</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>[{'event_team': 'away', 'event_time': \" 2' \", ...</td>\n",
       "      <td>[{'Player_Name': 'Insigne', 'Player_Number': '...</td>\n",
       "      <td>[{'Player_Name': 'Kane', 'Player_Number': '9'}...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Semi-finals</td>\n",
       "      <td>06.07.2021</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>Italy</td>\n",
       "      <td>Spain</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>29%</td>\n",
       "      <td>71%</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>49%</td>\n",
       "      <td>51%</td>\n",
       "      <td>[{'event_team': 'away', 'event_time': \" 51' \",...</td>\n",
       "      <td>[{'Player_Name': 'Insigne', 'Player_Number': '...</td>\n",
       "      <td>[{'Player_Name': 'Torres', 'Player_Number': '1...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           stage        date  pens pens_home_score pens_away_score  \\\n",
       "0         Final   11.07.2021  True               3               2   \n",
       "2   Semi-finals   06.07.2021  True               4               2   \n",
       "\n",
       "  team_name_home team_name_away  team_home_score  team_away_score  \\\n",
       "0          Italy        England                1                1   \n",
       "2          Italy          Spain                1                1   \n",
       "\n",
       "  possession_home possession_away  total_shots_home  total_shots_away  \\\n",
       "0             66%            34%                 19                 6   \n",
       "2             29%            71%                  7                16   \n",
       "\n",
       "   shots_on_target_home  shots_on_target_away duels_won_home duels_won_away  \\\n",
       "0                     6                     2            53%           47%    \n",
       "2                     4                     5            49%           51%    \n",
       "\n",
       "                                         events_list  \\\n",
       "0  [{'event_team': 'away', 'event_time': \" 2' \", ...   \n",
       "2  [{'event_team': 'away', 'event_time': \" 51' \",...   \n",
       "\n",
       "                                         lineup_home  \\\n",
       "0  [{'Player_Name': 'Insigne', 'Player_Number': '...   \n",
       "2  [{'Player_Name': 'Insigne', 'Player_Number': '...   \n",
       "\n",
       "                                         lineup_away  \n",
       "0  [{'Player_Name': 'Kane', 'Player_Number': '9'}...  \n",
       "2  [{'Player_Name': 'Torres', 'Player_Number': '1...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iw_matches.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "48e7cdef",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.662562Z",
     "iopub.status.busy": "2022-04-16T16:25:43.661881Z",
     "iopub.status.idle": "2022-04-16T16:25:43.685695Z",
     "shell.execute_reply": "2022-04-16T16:25:43.686263Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.222256Z"
    },
    "papermill": {
     "duration": 0.071873,
     "end_time": "2022-04-16T16:25:43.686485",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.614612",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "\n",
    "with open('../input/socceranalytics/matches.json') as f:\n",
    "    data = json.load(f)\n",
    "    matches = pd.json_normalize(data, sep = \"_\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "5522d30c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.779338Z",
     "iopub.status.busy": "2022-04-16T16:25:43.778601Z",
     "iopub.status.idle": "2022-04-16T16:25:43.783700Z",
     "shell.execute_reply": "2022-04-16T16:25:43.784179Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.247834Z"
    },
    "papermill": {
     "duration": 0.053361,
     "end_time": "2022-04-16T16:25:43.784392",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.731031",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['match_id', 'match_date', 'kick_off', 'home_score', 'away_score',\n",
       "       'match_status', 'match_status_360', 'last_updated', 'last_updated_360',\n",
       "       'match_week', 'competition_competition_id', 'competition_country_name',\n",
       "       'competition_competition_name', 'season_season_id',\n",
       "       'season_season_name', 'home_team_home_team_id',\n",
       "       'home_team_home_team_name', 'home_team_home_team_gender',\n",
       "       'home_team_home_team_group', 'home_team_country_id',\n",
       "       'home_team_country_name', 'home_team_managers',\n",
       "       'away_team_away_team_id', 'away_team_away_team_name',\n",
       "       'away_team_away_team_gender', 'away_team_away_team_group',\n",
       "       'away_team_country_id', 'away_team_country_name', 'away_team_managers',\n",
       "       'metadata_data_version', 'metadata_shot_fidelity_version',\n",
       "       'metadata_xy_fidelity_version', 'competition_stage_id',\n",
       "       'competition_stage_name', 'stadium_id', 'stadium_name',\n",
       "       'stadium_country_id', 'stadium_country_name', 'referee_id',\n",
       "       'referee_name', 'referee_country_id', 'referee_country_name'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7d6cb2ab",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.881235Z",
     "iopub.status.busy": "2022-04-16T16:25:43.880531Z",
     "iopub.status.idle": "2022-04-16T16:25:43.883558Z",
     "shell.execute_reply": "2022-04-16T16:25:43.884042Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.262542Z"
    },
    "papermill": {
     "duration": 0.054523,
     "end_time": "2022-04-16T16:25:43.884211",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.829688",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'id': 3622,\n",
       "  'name': 'Markku Kanerva',\n",
       "  'nickname': None,\n",
       "  'dob': '1964-05-24',\n",
       "  'country': {'id': 77, 'name': 'Finland'}}]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches['home_team_managers'].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ab547ea0",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:43.979843Z",
     "iopub.status.busy": "2022-04-16T16:25:43.979145Z",
     "iopub.status.idle": "2022-04-16T16:25:43.986260Z",
     "shell.execute_reply": "2022-04-16T16:25:43.986973Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.278917Z"
    },
    "papermill": {
     "duration": 0.056513,
     "end_time": "2022-04-16T16:25:43.987167",
     "exception": false,
     "start_time": "2022-04-16T16:25:43.930654",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "to_drop = ['away_team_away_team_gender',\n",
    "           'home_team_home_team_gender',\n",
    "           'competition_country_name',\n",
    "           'competition_competition_id',\n",
    "           'last_updated_360',\n",
    "           'last_updated',\n",
    "           'season_season_name',\n",
    "           'competition_competition_name',\n",
    "           'competition_competition_id',\n",
    "           'match_status',\n",
    "           'match_week']\n",
    "matches = matches.drop(to_drop, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "cc14f36c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:44.087018Z",
     "iopub.status.busy": "2022-04-16T16:25:44.081424Z",
     "iopub.status.idle": "2022-04-16T16:25:44.088619Z",
     "shell.execute_reply": "2022-04-16T16:25:44.089153Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.295504Z"
    },
    "papermill": {
     "duration": 0.056754,
     "end_time": "2022-04-16T16:25:44.089347",
     "exception": false,
     "start_time": "2022-04-16T16:25:44.032593",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "mask = (matches[\"home_team_home_team_name\"] == \"Italy\") | (matches[\"away_team_away_team_name\"] == \"Italy\")\n",
    "italy_matches = matches[mask]\n",
    "mask = (matches[\"home_team_home_team_name\"] == \"Wales\") | (matches[\"away_team_away_team_name\"] == \"Wales\")\n",
    "wales_matches = matches[mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "42f9fc93",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:44.183237Z",
     "iopub.status.busy": "2022-04-16T16:25:44.182571Z",
     "iopub.status.idle": "2022-04-16T16:25:44.187118Z",
     "shell.execute_reply": "2022-04-16T16:25:44.187696Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.320504Z"
    },
    "papermill": {
     "duration": 0.053246,
     "end_time": "2022-04-16T16:25:44.187880",
     "exception": false,
     "start_time": "2022-04-16T16:25:44.134634",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "match_id = italy_matches[italy_matches[\"away_team_away_team_name\"] == \"Wales\"].match_id.iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "ca791e7d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:44.282370Z",
     "iopub.status.busy": "2022-04-16T16:25:44.281681Z",
     "iopub.status.idle": "2022-04-16T16:25:44.305250Z",
     "shell.execute_reply": "2022-04-16T16:25:44.305850Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.335662Z"
    },
    "papermill": {
     "duration": 0.072481,
     "end_time": "2022-04-16T16:25:44.306037",
     "exception": false,
     "start_time": "2022-04-16T16:25:44.233556",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match_id</th>\n",
       "      <th>match_date</th>\n",
       "      <th>kick_off</th>\n",
       "      <th>home_score</th>\n",
       "      <th>away_score</th>\n",
       "      <th>match_status_360</th>\n",
       "      <th>season_season_id</th>\n",
       "      <th>home_team_home_team_id</th>\n",
       "      <th>home_team_home_team_name</th>\n",
       "      <th>home_team_home_team_group</th>\n",
       "      <th>...</th>\n",
       "      <th>competition_stage_id</th>\n",
       "      <th>competition_stage_name</th>\n",
       "      <th>stadium_id</th>\n",
       "      <th>stadium_name</th>\n",
       "      <th>stadium_country_id</th>\n",
       "      <th>stadium_country_name</th>\n",
       "      <th>referee_id</th>\n",
       "      <th>referee_name</th>\n",
       "      <th>referee_country_id</th>\n",
       "      <th>referee_country_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3794689</td>\n",
       "      <td>2021-06-26</td>\n",
       "      <td>18:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>available</td>\n",
       "      <td>43</td>\n",
       "      <td>907</td>\n",
       "      <td>Wales</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>33</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>4815</td>\n",
       "      <td>Johan Cruijff Arena (Amsterdam)</td>\n",
       "      <td>160</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>225</td>\n",
       "      <td>Daniel Siebert</td>\n",
       "      <td>85</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3788766</td>\n",
       "      <td>2021-06-20</td>\n",
       "      <td>18:00:00.000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>43</td>\n",
       "      <td>914</td>\n",
       "      <td>Italy</td>\n",
       "      <td>Group A</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>Group Stage</td>\n",
       "      <td>381</td>\n",
       "      <td>Stadio Olimpico (Roma)</td>\n",
       "      <td>112</td>\n",
       "      <td>Italy</td>\n",
       "      <td>448</td>\n",
       "      <td>Ovidiu Alin Hațegan</td>\n",
       "      <td>187</td>\n",
       "      <td>Romania</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3788755</td>\n",
       "      <td>2021-06-16</td>\n",
       "      <td>18:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>43</td>\n",
       "      <td>909</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Group A</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>Group Stage</td>\n",
       "      <td>4549</td>\n",
       "      <td>Bakı Olimpiya Stadionu</td>\n",
       "      <td>16</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>2445</td>\n",
       "      <td>Artur Manuel Ribeiro Soares Dias</td>\n",
       "      <td>183</td>\n",
       "      <td>Portugal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>3788744</td>\n",
       "      <td>2021-06-12</td>\n",
       "      <td>15:00:00.000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>43</td>\n",
       "      <td>907</td>\n",
       "      <td>Wales</td>\n",
       "      <td>Group A</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>Group Stage</td>\n",
       "      <td>4549</td>\n",
       "      <td>Bakı Olimpiya Stadionu</td>\n",
       "      <td>16</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>76</td>\n",
       "      <td>Clément Turpin</td>\n",
       "      <td>78</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    match_id  match_date      kick_off  home_score  away_score  \\\n",
       "23   3794689  2021-06-26  18:00:00.000           0           4   \n",
       "27   3788766  2021-06-20  18:00:00.000           1           0   \n",
       "29   3788755  2021-06-16  18:00:00.000           0           2   \n",
       "50   3788744  2021-06-12  15:00:00.000           1           1   \n",
       "\n",
       "   match_status_360  season_season_id  home_team_home_team_id  \\\n",
       "23        available                43                     907   \n",
       "27        available                43                     914   \n",
       "29        available                43                     909   \n",
       "50        available                43                     907   \n",
       "\n",
       "   home_team_home_team_name home_team_home_team_group  ...  \\\n",
       "23                    Wales                      None  ...   \n",
       "27                    Italy                   Group A  ...   \n",
       "29                   Turkey                   Group A  ...   \n",
       "50                    Wales                   Group A  ...   \n",
       "\n",
       "    competition_stage_id competition_stage_name stadium_id  \\\n",
       "23                    33            Round of 16       4815   \n",
       "27                    10            Group Stage        381   \n",
       "29                    10            Group Stage       4549   \n",
       "50                    10            Group Stage       4549   \n",
       "\n",
       "                       stadium_name stadium_country_id stadium_country_name  \\\n",
       "23  Johan Cruijff Arena (Amsterdam)                160          Netherlands   \n",
       "27           Stadio Olimpico (Roma)                112                Italy   \n",
       "29           Bakı Olimpiya Stadionu                 16           Azerbaijan   \n",
       "50           Bakı Olimpiya Stadionu                 16           Azerbaijan   \n",
       "\n",
       "    referee_id                      referee_name referee_country_id  \\\n",
       "23         225                    Daniel Siebert                 85   \n",
       "27         448               Ovidiu Alin Hațegan                187   \n",
       "29        2445  Artur Manuel Ribeiro Soares Dias                183   \n",
       "50          76                    Clément Turpin                 78   \n",
       "\n",
       "   referee_country_name  \n",
       "23              Germany  \n",
       "27              Romania  \n",
       "29             Portugal  \n",
       "50               France  \n",
       "\n",
       "[4 rows x 32 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wales_matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "0d6b74c3",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:44.402855Z",
     "iopub.status.busy": "2022-04-16T16:25:44.402163Z",
     "iopub.status.idle": "2022-04-16T16:25:45.027925Z",
     "shell.execute_reply": "2022-04-16T16:25:45.027248Z",
     "shell.execute_reply.started": "2022-04-16T15:16:52.376960Z"
    },
    "papermill": {
     "duration": 0.675664,
     "end_time": "2022-04-16T16:25:45.028077",
     "exception": false,
     "start_time": "2022-04-16T16:25:44.352413",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "import bz2\n",
    "zipfile = bz2.BZ2File(f\"../input/socceranalytics/three-sixty/three-sixty/{match_id}.json.bz2\")\n",
    "file = zipfile.read()\n",
    "open(f\"{match_id}.json\", 'wb').write(file)\n",
    "with open(f\"{match_id}.json\") as f:\n",
    "    threesixty = json.load(f)\n",
    "    match_events360 = pd.json_normalize(threesixty)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "c724a0da",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:45.125175Z",
     "iopub.status.busy": "2022-04-16T16:25:45.124105Z",
     "iopub.status.idle": "2022-04-16T16:25:45.510944Z",
     "shell.execute_reply": "2022-04-16T16:25:45.510242Z",
     "shell.execute_reply.started": "2022-04-16T15:16:53.300548Z"
    },
    "papermill": {
     "duration": 0.436604,
     "end_time": "2022-04-16T16:25:45.511099",
     "exception": false,
     "start_time": "2022-04-16T16:25:45.074495",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "zipfile = bz2.BZ2File(f\"../input/socceranalytics/events/events/{match_id}.json.bz2\")\n",
    "file = zipfile.read()\n",
    "open(f\"{match_id}.json\", 'wb').write(file)\n",
    "with open(f\"{match_id}.json\") as f:\n",
    "    events = json.load(f)\n",
    "    match_events = pd.json_normalize(events[2:], sep = \"_\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "21cf19b9",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:45.609077Z",
     "iopub.status.busy": "2022-04-16T16:25:45.608461Z",
     "iopub.status.idle": "2022-04-16T16:25:45.617769Z",
     "shell.execute_reply": "2022-04-16T16:25:45.617199Z",
     "shell.execute_reply.started": "2022-04-16T15:16:53.780879Z"
    },
    "papermill": {
     "duration": 0.058885,
     "end_time": "2022-04-16T16:25:45.617937",
     "exception": false,
     "start_time": "2022-04-16T16:25:45.559052",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "shots = match_events[match_events['type_name'] == 'Shot']\n",
    "passes = match_events[match_events['type_name'] == 'Pass']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "aadb815b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:45.716736Z",
     "iopub.status.busy": "2022-04-16T16:25:45.715844Z",
     "iopub.status.idle": "2022-04-16T16:25:45.718134Z",
     "shell.execute_reply": "2022-04-16T16:25:45.718720Z",
     "shell.execute_reply.started": "2022-04-16T15:16:53.796403Z"
    },
    "papermill": {
     "duration": 0.054672,
     "end_time": "2022-04-16T16:25:45.718897",
     "exception": false,
     "start_time": "2022-04-16T16:25:45.664225",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "def restore_df(path):\n",
    "    with pd.HDFStore(path, mode = 'r') as store:\n",
    "        df = store.get('df')\n",
    "        df.attrs = store.get_storer('df').attrs.my_attribute\n",
    "        return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "a5fd5026",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:45.820554Z",
     "iopub.status.busy": "2022-04-16T16:25:45.819794Z",
     "iopub.status.idle": "2022-04-16T16:25:45.825224Z",
     "shell.execute_reply": "2022-04-16T16:25:45.825740Z",
     "shell.execute_reply.started": "2022-04-16T15:16:53.811997Z"
    },
    "papermill": {
     "duration": 0.060607,
     "end_time": "2022-04-16T16:25:45.825943",
     "exception": false,
     "start_time": "2022-04-16T16:25:45.765336",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "goal = shots[shots['shot_outcome_name']=='Goal'][['location','player_name', 'timestamp']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "0cbed1c0",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:45.924608Z",
     "iopub.status.busy": "2022-04-16T16:25:45.923945Z",
     "iopub.status.idle": "2022-04-16T16:25:45.928869Z",
     "shell.execute_reply": "2022-04-16T16:25:45.928154Z",
     "shell.execute_reply.started": "2022-04-16T15:16:53.831720Z"
    },
    "papermill": {
     "duration": 0.054364,
     "end_time": "2022-04-16T16:25:45.929020",
     "exception": false,
     "start_time": "2022-04-16T16:25:45.874656",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "first_half_start=\"2021-06-20T16:00:41.126\" \n",
    "first_half_end=\"2021-06-20T16:45:43.02\"\n",
    "snd_half_start=\"2021-06-20T17:02:35.054\" \n",
    "snd_half_end=\"2021-06-20T17:50:34.332\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "ee56e7de",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:46.028765Z",
     "iopub.status.busy": "2022-04-16T16:25:46.028017Z",
     "iopub.status.idle": "2022-04-16T16:25:46.031134Z",
     "shell.execute_reply": "2022-04-16T16:25:46.030590Z",
     "shell.execute_reply.started": "2022-04-16T15:16:53.849567Z"
    },
    "papermill": {
     "duration": 0.055811,
     "end_time": "2022-04-16T16:25:46.031316",
     "exception": false,
     "start_time": "2022-04-16T16:25:45.975505",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "start = pd.to_datetime(first_half_start)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "b19fe028",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:46.129770Z",
     "iopub.status.busy": "2022-04-16T16:25:46.129062Z",
     "iopub.status.idle": "2022-04-16T16:25:48.670520Z",
     "shell.execute_reply": "2022-04-16T16:25:48.669902Z",
     "shell.execute_reply.started": "2022-04-16T15:16:53.871458Z"
    },
    "papermill": {
     "duration": 2.592325,
     "end_time": "2022-04-16T16:25:48.670692",
     "exception": false,
     "start_time": "2022-04-16T16:25:46.078367",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "df = restore_df('../input/socceranalytics/dfmeta/dfmeta/italyvwales.h5')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "bd9b6e08",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:48.780638Z",
     "iopub.status.busy": "2022-04-16T16:25:48.779732Z",
     "iopub.status.idle": "2022-04-16T16:25:48.782797Z",
     "shell.execute_reply": "2022-04-16T16:25:48.782122Z",
     "shell.execute_reply.started": "2022-04-16T15:16:56.489945Z"
    },
    "papermill": {
     "duration": 0.064758,
     "end_time": "2022-04-16T16:25:48.783002",
     "exception": false,
     "start_time": "2022-04-16T16:25:48.718244",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "goal_time = start + pd.Timedelta(goal['timestamp'].iloc[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "bbf3c5f6",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:48.891125Z",
     "iopub.status.busy": "2022-04-16T16:25:48.889819Z",
     "iopub.status.idle": "2022-04-16T16:25:48.893483Z",
     "shell.execute_reply": "2022-04-16T16:25:48.894000Z",
     "shell.execute_reply.started": "2022-04-16T15:29:19.604541Z"
    },
    "papermill": {
     "duration": 0.060496,
     "end_time": "2022-04-16T16:25:48.894192",
     "exception": false,
     "start_time": "2022-04-16T16:25:48.833696",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2021-06-20 16:38:56.646000')"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "goal_time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "cfee2b7b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:48.995707Z",
     "iopub.status.busy": "2022-04-16T16:25:48.994681Z",
     "iopub.status.idle": "2022-04-16T16:25:49.000062Z",
     "shell.execute_reply": "2022-04-16T16:25:48.999530Z",
     "shell.execute_reply.started": "2022-04-16T15:16:56.499976Z"
    },
    "papermill": {
     "duration": 0.05752,
     "end_time": "2022-04-16T16:25:49.000215",
     "exception": false,
     "start_time": "2022-04-16T16:25:48.942695",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "1d4fbcd1",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:49.103020Z",
     "iopub.status.busy": "2022-04-16T16:25:49.102091Z",
     "iopub.status.idle": "2022-04-16T16:25:49.105902Z",
     "shell.execute_reply": "2022-04-16T16:25:49.106616Z",
     "shell.execute_reply.started": "2022-04-16T15:16:56.516361Z"
    },
    "papermill": {
     "duration": 0.059439,
     "end_time": "2022-04-16T16:25:49.106818",
     "exception": false,
     "start_time": "2022-04-16T16:25:49.047379",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'106737': 'Salvatore Sirigu',\n",
       " '250078922': 'Gianluigi Donnarumma',\n",
       " '250066753': 'Alex Meret',\n",
       " '250064229': 'Giovanni Di Lorenzo',\n",
       " '59142': 'Giorgio Chiellini',\n",
       " '250020885': 'Leonardo Spinazzola',\n",
       " '250100056': 'Emerson',\n",
       " '250052957': 'Francesco Acerbi',\n",
       " '250017925': 'Leonardo Bonucci',\n",
       " '250091199': 'Alessandro Bastoni',\n",
       " '250026962': 'Alessandro Florenzi',\n",
       " '250112488': 'Rafael Tolói',\n",
       " '250066747': 'Manuel Locatelli',\n",
       " '250006200': 'Marco Verratti',\n",
       " '250138434': 'Gaetano Castrovilli',\n",
       " '250067749': 'Jorginho',\n",
       " '250121401': 'Matteo Pessina',\n",
       " '250041741': 'Bryan Cristante',\n",
       " '250066739': 'Nicolò Barella',\n",
       " '250061597': 'Federico Bernardeschi',\n",
       " '250050378': 'Andrea Belotti',\n",
       " '250026037': 'Lorenzo Insigne',\n",
       " '250058759': 'Domenico Berardi',\n",
       " '250090398': 'Federico Chiesa',\n",
       " '250005254': 'Ciro Immobile',\n",
       " '250105617': 'Giacomo Raspadori',\n",
       " '74897': 'Wayne Hennessey',\n",
       " '250012939': 'Danny Ward',\n",
       " '250100010': 'Adam Davies',\n",
       " '102221': 'Chris Gunter',\n",
       " '250113272': 'Neco Williams',\n",
       " '250012942': 'Ben Davies',\n",
       " '250090824': 'Tom Lockyer',\n",
       " '250101045': 'Joe Rodon',\n",
       " '250097244': 'Connor Roberts',\n",
       " '250097090': 'Ethan Ampadu',\n",
       " '250116809': 'Rhys Norrington-Davies',\n",
       " '250112383': 'Chris Mepham',\n",
       " '250103440': 'Ben Cabango',\n",
       " '107011': 'Joe Allen',\n",
       " '250065203': 'Harry Wilson',\n",
       " '103769': 'Aaron Ramsey',\n",
       " '250065196': 'Joe Morrell',\n",
       " '250007344': 'Jonny Williams',\n",
       " '250076590': 'David Brooks',\n",
       " '250065198': 'Daniel James',\n",
       " '250103444': 'Dylan Levitt',\n",
       " '250117658': 'Rubin Colwill',\n",
       " '250081812': 'Matthew Smith',\n",
       " '250079203': 'Tyler Roberts',\n",
       " '102225': 'Gareth Bale',\n",
       " '250130512': 'Kieffer Moore'}"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.attrs['player_map']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "828767d8",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:49.209762Z",
     "iopub.status.busy": "2022-04-16T16:25:49.208781Z",
     "iopub.status.idle": "2022-04-16T16:25:49.215624Z",
     "shell.execute_reply": "2022-04-16T16:25:49.215008Z",
     "shell.execute_reply.started": "2022-04-16T16:22:28.675812Z"
    },
    "papermill": {
     "duration": 0.061097,
     "end_time": "2022-04-16T16:25:49.215789",
     "exception": false,
     "start_time": "2022-04-16T16:25:49.154692",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "pes_cols = ['250121401_x', '250121401_y', 'ball_x', 'ball_y']\n",
    "pes_goool = df[(df['time'] > (goal_time - dt.timedelta(seconds = 1))) & (df['time'] < goal_time + dt.timedelta(seconds = 1))][pes_cols] / 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "3f569be3",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:49.332856Z",
     "iopub.status.busy": "2022-04-16T16:25:49.329094Z",
     "iopub.status.idle": "2022-04-16T16:25:49.756404Z",
     "shell.execute_reply": "2022-04-16T16:25:49.755658Z",
     "shell.execute_reply.started": "2022-04-16T16:24:12.380338Z"
    },
    "papermill": {
     "duration": 0.485649,
     "end_time": "2022-04-16T16:25:49.756556",
     "exception": false,
     "start_time": "2022-04-16T16:25:49.270907",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<matplotlib.lines.Line2D at 0x7f6906544ed0>]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA1MAAAIuCAYAAABac1I3AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAA0jElEQVR4nO3deZzd86H/8fdkl5UgIwihqCIRS6sJUlsRW2spKpaiSlvV1q3qdaub9va2equlddV6JdZaq5ZQRKOEK4REUVtCEBNbZJN15vdH7vWrZkJ9xHznzDyfj4c/fL/TzHvaZmZe53vO+dY1NTU1BQAAgPelQ9UDAAAAapGYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKdKp6QIneP+2d2QtnVz0DAABYQXp16ZVZ/zqr6hnvS01emRJSAADQttTi7/g1GVMAAABVE1MAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAU6FT1AKp3zp7nZPi6w9Mwt6HqKQDvUN+jPkl8fwJanfoe9Rn33Lgcd9NxVU+hQq5MkeHrDk//Xv2rngGwjP69+vv+BLRK/Xv1z/B1h1c9g4q5MkUa5jakYW5Ddrx4x6qnALzD2CPGJonvT0Cr83/fn2jfXJkCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAo0KnqAVSvvkd9+vfqn7FHjK16SrtR36M+454bl+NuOq7qKQC0AefseU6Grzs8DXMbqp7SbgxZY0imz55e9Qwq5soUVKB/r/4Zvu7wqmcA0EYMX3d4+vfqX/UMaHdcmSINcxvSMLchO168Y9VT2g1XAQFYkfwsb3l+lpO4MgUAAFBETAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAU6FT1AKpX36M+/Xv1z9gjxlbyucc9Ny7H3XRci39uoHp9uvbJ+qusn/qe9anvUZ/6nvXp16Nf+nTtk04dOuVjq30sTWnKBftckPmL52fG3BlpmNuQhjkNaZjbkBdnvZjn33w+TWmq+ksBKnDOnudk+LrD0zC3ocU/95A1hmT67Okt/nlpXcQUlerfq3+Grzu86hlAC1inzzoZuvbQDK4fnEH9BmVw/eD0XalvnnnjmbfjaMbcGXl5zst54tUnsmjJomyz1jZJXXLPtHvSvXP39OvRL0PWGLI0vHrUZ0CfAendtXcenfFoJjVMyqSGSXlo+kOZ8NKELGlaUvWXDHzIhq87PP179a8kpiARUyRLH+Wd25AdL96xxT93FVfDgJbRs0vP7DBwh+z6kV2z6/q7pu9KfXP383fnkYZHcuHDF2ZSw6RMeWPKu15V+sKQLyRJLpx44XI/ZpVuq2RQ/aAM6jcoQ9YYkmO3Ojbr9Fknd029K7c9e1tue+a2PPvGsyv6ywNaAb/DUDUxBcAK06Vjl+y10V45YvMjsuPAHXP/i/fnT8/+KQdfc3AeefmRD+XpeG/MfyPjnhuXcc+Ne/tYvx79ssv6u2TX9XfNqcNPzZvz38yoSaMy+pHReXH2iyt8AwDtk5gC4APbqv9WOWqLo3LgpgdmUsOkjHpkVEZeOzJzFs6pZM+MuTNy2eTLctnky5IkQ9cemiOGHJFJX56UB196MKMmjcpVf70qC5YsqGQfAG2Dd/MDoNhO6+2U2w+7PdcceE1emv1Stjp3q+w8audc/MjFlYVUc8a/MD7H3Xhc1vrlWjnvofMyctDIPHPCMzlx6Inp0blH1fMAqFFiCoD3be+N9s59R9+X3+7x24yaNCobnLVBfnL3T/L8m89XPe1dzV88P1c9dlVGXDoie162Zz6x5icy5etT8r1PfS+rdFul6nkA1BhP8wPgn7Z5/eb5zR6/Sc8uPfPjcT/OdU9cl8amxqpnFXmk4ZEcfM3B2bDvhvnOdt/JE8c/ke/f9f2c++C5Nfs1AdCyXJkC4D2t3G3lnDXirNx66K25+JGLs9W5W+Wax69pE9Hx1OtP5egbjs7Oo3bOwZsenAeOeSCfXPuTVc8CoAaIKQDe1cGbHZzHv/p4OtR1yCZnb5LzHzq/TUTUP3p0xqPZ4eId8ot7f5GrP3d1zt/n/PTq0qvqWQC0YmIKKrJ699Wz+wa7Vz0DlqtH5x65cJ8L8/1PfT97XbZXvnrzV/P6W69XPetDd/mjl+djv/1YljQuyUPHPpSt+m9V9SRYrn49+uXHO/246hnQbokpqMjCJQvzu71+l//c9T/TpWOXqufAO2xev3kmfGlCkmTrc7fOg9MfrHhRy5q9cHaOvfHY/Osd/5qbR96cb37ym6lLXdWz4B0+vf6nM/HYiUni/59QETEFFXlzwZsZcs6QbNB3g4wZOSZ9uvapehIkSY4ccmT+dNifctq403LUDUdl7qK5VU+qzNWPXZ1tzt8mB256YP5w8B887Y9W46sf/2ou+sxFGXntyHz3zu9+KDfEBt6bmIIKvTH/jex75b55uOHh3HPUPRnQe0DVk2jH6lKXH+/045yy/SnZ7qLt3r7hbXs3debUbH/R9nlx9ou5+8i7s1avtaqeRDtWl7r8/NM/z/GfOD7bXbRd7pp6V9WToF0TU1CxxqbGnHjriTl/4vm59+h7s3n95lVPoh3q1KFTLvrMRdlx4I4ZesHQPPnak1VPalUWNy7Ol2/6ci6ZfEnuPfrebLzaxlVPoh3q2rFrLt//8nxyrU9m2AXDMnXm1KonQbvnPlPQSvzqvl9l2pvTcttht+Xgqw/O2Kljq55EO9GlY5f8/oDfp3PHztll1C55a/FbVU9qtX5x7y/SMKchY48Ymz0u3SMTX55Y9STaiZ5deubGz9+YhrkN+fToT2fBkgVVTwIipqBVuebxa/LKvFdy1eeuyohLR+Sh6Q9VPYk2rkNdh4zed3Sa0pTPXvHZLGpcVPWkVm/0pNGZs3BObjrkpnzqvz+Vp15/qupJtHGdO3TOtQdemydffzLH/vFYr4+CVsTT/KCVGffcuBzzx2Pyx8//MRv03aDqObRxZ444M6t3Xz0HX32wkHofrnviuvzbnf+WWw+9NWv2WrPqObRhdanLxZ+9OLMXzs5xNx4npKCVcWUKWqEb/nZDVu++esaMHJNtL9w2DXMbqp5EG/T9T30/Q9cemh3+ewdPGSpw0cMXZbXuq+XWQ2/N8IuG5435b1Q9iTbojN3PyJq91sxul+zWJm+WDbXOlSlopS6YeEEueviijDl0THp07lH1HNqYwwYflkMHH5oRl47I7IWzq55Ts06/9/SMeXpMrj3o2nSs61j1HNqYk4adlB0H7pjPXPEZD3hAKyWmoBX7yd0/ycTpE3PmiDOrnkIbsvFqG+eXu/0y+165b2bMnVH1nJp38u0nZ3Hj4nzvU9+regptyHbrbJdvfvKbGXHpiLy54M2q5wDLIaaglfvaLV/L9utsnwM2OaDqKbQBK3VaKb8/4Pf51zv+NY/OeLTqOW1CY1NjRl47MkdvcXR2Xm/nqufQBvTp2iej9x2dY/54TF6a/VLVc4B3IaaglZu7aG4OufaQ/GbEb7J277WrnkON+/WIX2fyjMk5/6Hzq57SpsyYOyOHX394Ru07KvU96queQ407e8+zc9NTN+Wmp26qegrwHsQU1IAJL03Ir+//dUbvOzod6vy1pcyuH9k1O6+3c4698diqp7RJd065MxdOvDC/2eM3VU+hho0cNDJD1hiSk247qeopLMdnN05GfTbZvP7EbNn/K5l0XPLEV5Nz9kp6d616HS3Nb2VQI352z8/Soa5Djtv6uKqnUIO6dOySs0acla/d8rXMWTin6jlt1o/H/ThbrLFFdll/l6qnUINW7756ztjtjIy8dqSbZ7dSRw5JrjsoOWzzZJWVJqZ318czqD756GrJsVsl//2ZqhfS0sQU1IjGpsZ89eav5nvDv5dVuq1S9RxqzIlDT8wTrz6Rm5+6ueopbdqCJQvyjVu/kbNGnJXOHTpXPYcac9pOp+XSyZfm4ZcfrnoKy/GFIe9+fpf1W2QGrYiYghry6IxHc+0T1+bUT51a9RRqyIDeA/Ktod/KN8Z8o+op7cKNT96Yp19/Ot8c+s2qp1BDNuu3WT770c/mh3/+YdVTeBcN73Fh/1FvkNruiCmoMT+46wc5fPDhGdB7QNVTqBHfHf7dnPPgOZkyc0rVU9qNb4z5Rr497Nvp3bV31VOoEafteFr+457/yMz5M6uewrv44Z+Xf27hkuTbt7fcFloHMQU1ZsbcGTn3oXNdneKfskbPNXLAJgfkjPFnVD2lXXnmjWcy5ukxXuPIP+Xja348W6+5df7rgf+qegrvYeGSZNGS5s8dd2Pyl+dbdg/VE1NQg06/5/Qc8LEDslr31aqeQit3wjYn5NLJl+a1t16rekq78/N7f56vb/P1dOnYpeoptHInDj0xp997ehYsWVD1FN5Fzy7J9QcnnTsue+5n9yQXPdzik2gFxBTUoDfmv5Eb/nZDDt/88Kqn0Ir16tIrx2x5TH45/pdVT2mXJjVMyiMvP5LDBh9W9RRasdW6r5bdN9g9ox4ZVfUU3kWHuuTS/ZJNVl/23E1PJqfc0fKbaB3EFNSo8x46L8dseUzVM2jFDtv8sNzx7B2ZOnNq1VPardPvPT0nbHNC1TNoxQ7f/PDc8LcbvFaqlfv3nZN9Prrs8XmL1srIa5PGppbfROsgpqBG3TPtnjQ2NWb7dbavegqt1MGbHpxRkzzaXaW7pt6Vviv1zcarbVz1FFqpY7Y8Juc+eG7VM3gXh2+enLztsseXNHbLX2ecljc9O7NdE1NQw1ydYnnW6rVWNll9k/zpmT9VPaVda0pTrnrsqhy06UFVT6EV2m6d7dLY1Jh7pt1T9RSWY9sByXl7N3/u8VdPydxF67XsIFodMQU17LLJl2Xvj+6djnXNvBqWdu1zm34u1//t+ixqXFT1lHbvykevFFM0a9+N981lky+regbLMXDl5LqDki7N/Ig95Y7k1XmeGYKYgpo2Y+6MPP/m89my/5ZVT6GV+dwmn8vv//r7qmeQ5P4X789KnVfKZv02q3oKrczO6+2c2591Y6LWqFeX5I+fT1bvsey5SyYlP/1Ly2+idRJTUOPunHJndlpvp6pn0Iqs1GmlbF6/ef489V3uLkmLumPKHRm+7vCqZ9CKrNZ9tQxceWAmvDSh6ik044zdk836LXt8/LTkize0/B5aLzEFNU5M8Y+2XnPrPDrjUfesaUXunXZvhq49tOoZtCI7DNwhdz9/d5Y0LecOsFRmh4HJ0Vsse/y5mclnr0wW+J+MvyOmoMaNe25chq491I1BeduwAcMy/oXxVc/g74yfNl5M8Q47rbdT7pxyZ9Uz+AddOya/22vZ43MWJntfnsyY2/KbaN3EFNS4Nxe8mefefC6brL5J1VNoJYauPVRMtTJPvPpE+q7UN6t3b+aOn7RLW/ff2t/TVuj7OyQbrbrs8W/dlkye0eJzqAFiCtqAZ994NgNXHlj1DFqJQfWDMnH6xKpn8Hea0pSHX344g+sHVz2FVmK9VdbLs288W/UM/s7J2yb/ut2yx+95Pjn3wZbfQ20QU9AGTJk5Jeut7F4XJHWpy1q91sq0WdOqnsI/mDZrWtbuvXbVM2gFenbpmZU6rZQZc13qaC1+sEPyH7sse3zhkuRLNyZNLb6IWtGp6gHQ0np07pF9P7ZvNlltk8xbPC+3PXNb/ufF/6l61gcy5Y0p+Ujfj1Q9g1Zg9R6rZ9aCWZm/eH7VUz6QlbutnP0+tl/WX2X9LG5cnEH9BmXyjMlVz/pAps2algF9BlQ9g1Zg4MoDM3Xm1KpnfGCrd189B2xyQNbps05ef+v1XP/E9Xnq9aeqnvW+/WSn5JTl3DLqJ3cnj73SsnuoLWKKduW4rY7Lf+72n1ncuDi9u/bO4sbFOXnbk/PCrBey52V71uxTLqbOnJqd19u56hm0AgN6D6j5q1KnDj81p2x/ShY3Lk7PLj3T2NSY8UePz2OvPJZ9rtgnL895ueqJRV6Y9UKGrDGk6hm0ArUeUx3qOuRXu/0qx2x1TJY0LkmPLj2yYPGC/GCHH2T8tPHZ//f7580Fb1Y985/ys12Sb2/b/LmLJiY/Hteye6g9nuZHu3H44MPzi11/ke6du6d3195Jkk4dOqVnl57ZsO+Gue/o+94+XmumzZqWtXqvVfUMWoG1eq+VF2e9WPWMYqdsd0q+ve23061Tt/Ts0jPJ0l/cenTpkSFrDMn4o8enc4fOFa8s8+KsF7N2L0/zI1mr11p5YfYLVc8odubuZ+aoLY5Kt07d0qPL0rvadu3UNd07d8+262ybsUeMrXjhe6tLcuaI5YfUbx9Ijr4hafT8Pt6DmKJd6FjXMafvevrb3/SXOd+hY7p37p6vfPwrLbxsxViweEG6duxa9Qxage6du2fOwjlVzyjSo3OPfGf777wdUf+oc8fOWXWlVXPIoENaeNmKMWfhnHTv3L3qGbQCXTt1rdmn4q7Rc40ctcVRy/152q1Tt2zQd4PsvsHuLbzsn9ehLjl37+Rrn2j+/C/HJ8ff7HVS/HPEFO3Cpv02TbdO3d71Y3p06ZHPb/b5Flq0Yi1cstB9pkiSdO7QOYsbF1c9o8iwAcPS2Nj4rh/Tq2uvmv17uqhxUTp3rM2raqxYXTp2yaIli6qeUWSX9Xd5z+8xvbr2yv4f27+FFr0/HeuSUZ9Nvrhl8+d/dk/yL7e16CRqnNdMAQDQ5nXukFxxQLLfx5o//5O7k++6jzLvkytTtAt/nfHX93xKxdyFc3P5o5e30KIVq0vHLlm4ZGHVM2gFFjUuSqcOtfk42b3T7k2HDu/+Y2n2gtk1+/e0c4fONXs1ghVr4ZKFNXuV8vZnb3/P7zGzF8zONY9f00KL/jndOiXXH7z8kPq3O4UUZcQU7cKSpiU56baTMnfh3ObPNy7JvEXzcvYDZ7fwshWja6euWbBkQdUzaAXmLZq33NcctXZzF83Nf9z9H8t9zdeiJYvy2luv5bLJl7XwshWjZ5eembdoXtUzaAUWLF7wnk89b61envNyLpx44XL/ns5fPD9Pv/50xjw9poWXLV+PzslNhyR7bNj8+RNvTf797pbdRNshpmg3Rk0alW/d9q3MWzQvsxbMSpIsblycOQvm5KnXn8onL/jk28drzYDeA2r6HdxYcV6c9WJNv7Pjv//l3/Pze36e+Yvnv/3LWmNTY+YunJuJL0/M0AuGZlFjbV7dWat3bb+DGyvOi7Nr+50dTxhzQi6ceGHmL57/9oOUCxYvyLxF8/KX5/+SHS/eseKF/1/vrsmthyY7Lee+9sfdmJxxX8tuom2pzeeCQKFzHjwnoyeNzmc3/mw2XX3TzFs8L7c+fWseeOmBqqd9IANXHpipb06tegatwLRZ0zKgd23fGPa0caflzPvPzP6b7J/vDf9eljQtyWeu+EwenfFo1dM+kLV7r50XZokplt4bcODKA6ueUayxqTFfH/P1/Hjcj7P/Jvtn3T7r5rW3Xsv1T1yfp19/uup5b+vzvyG1TTPduqQxOeqGZNQjLb+LtkVM0e7MXTQ3l06+tOoZK9R6q6yXKW9MqXoGrcArc19J7669061Tt5p96+UkeXPBm7lw4oU5bPBhSVLzIZUsvYJ85xQvyqD2Y+r/vDLvlZwz4ZyqZzRrlW7JbYclW6+57LlFS5KR1yZXPdbyu2h7PM0P2oD1Vl4vU2aKKZKmNOXF2S/W/NWptmhA7wGuTJFk6T3H3lr8Vvr16Ff1lDZpjZ7Jn7/QfEgtWJzs/3shxYojpqANWH+V9TN15tSqZ9BKTG6YnC36b1H1DP5OXeoyZI0hmdQwqeoptBJT3piS9VdZv+oZbc66fZK7j0wG1S977q1FyT5XJH98suV30XaJKahxfbr2ybp91s1jr3iYjaXGvzA+Q9ceWvUM/s7Gq22c1996Pa/Me6XqKbQSE6ZP8Pd0BRu4cjLuyGSDvsuem7co2evy5LZnWnwWbZyYgho3fN3hGf/CePeZ4m33TrvXL2mtzNABQzP+hfFVz6AVuXPKndlpvZ2qntFmDOid3Hl4sk6fZc/NXpCMuDS507Ph+RCIKahxO623kxe18w4TXpqQzfptlq4du1Y9hf81bMAwMcU73DX1rmy/zvY1e5Pt1qR756kZd2Sy3irLnnttXrLTqGTccy2/i/ZBTEGNE1P8o7cWv5VHGh7JpwZ+quop/K+d19s5454bV/UMWpFX572aqTOnZqv+W1U9pab16fpwtljjaxm48rLnXp6TDP/vZMJLLb2K9kRMQQ3r16Nf1umzTh6a/lDVU2hlrnrsqhy46YFVzyDJNmttk7cWvdUm3t6dFeuOKXdkl/V3qXpGzTpo02TzNb6dzh3nLHNuxtxkp4uTx7xMkQ+ZmIIadsigQ/LHv/0xS5qWVD2FVuaqv16Vz370s+ncoXPVU9q9gzY7KFf+9cqqZ9AKXffEdRk5aGTVM2rS1z6RXHFA0qFu0TLnXpmb7DIqefzVCobR7ogpqGHHbHlMznvovKpn0Aq9OPvFPPbKY/n0Rz5d9ZR2rS51+dwmnxNTNOsvz/8lSbLtgG0rXlJbTtsxOXNE8+eefC355AXJ5Bktu4n2S0xBjdp2wLbpUNchdz9/d9VTaKWu+OsVOXzw4VXPaNd2GLhDXn/r9Tzx6hNVT6GVOn/i+fnSVl+qekZN6FiXnLt38t3hzZ+/d1oy7ILk2Tdadhftm5iCGuWqFO9l9COjs/P6O2fgygOrntJunTTspJx5/5lVz6AVu/jhi7PPR/fJyt1WrnpKq7ZSp+S6g5Jjtmz+/PVPJDuPSl57q2V3gZiCGrRKt1Wyz0f3ycUPX1z1FFqx2Qtn57yHzsuJQ0+sekq7NLh+cDZfY/OMnjS66im0Yq+99VrGPD0mh2/uKvLy9F0puePwZO+PNn9++uw9csDvk/mLW3YXJGIKatJJ256Uqx+/Oq+99VrVU2jlzrz/zIwcNDKrdV+t6intzreHfTu/vv/XbqjNe/rl+F/mpGEnpVunblVPaXXW7ZPcc1QydEDz55+beUj+9tq3sqSpZXfB/xFTUGP69eiXL235pZz259OqnkINeHnOy7n6savzjU9+o+op7cpHVvlIdt9g95wz4Zyqp1ADHnjpgUx4aUKO2/q4qqe0KpvXJ+OPTjZu5rGgxqbk+JuTKTOPSVLX4tvg/4gpqDE/2OEHGTVpVKbNmlb1FGrEaeNOy3FbHZf1Vl6v6intxq92/1V+fu/PM2vBrKqnUCNOHXtqvrPtd7x26n/tvF4y7sikf69lzy1YnBx4VfLbB1p+F/wjMQU1ZFC/Qdlv4/1cleJ9eWHWC/nF+F/kV7v/quop7cJeG+2VDfpukDPGn1H1FGrIozMezfV/uz7f/9T3q55SuaO2SG4ZmfTuuuy5mfOTXS9Jrnm85XdBc8QU1IgOdR3y2z1+mx+N+1HemO99X3l/fjn+l9l4tY2zx4Z7VD2lTevasWt+tduv8rVbvpZFjcveTBTezXfv/G5GDhqZIWsMqXpKJeqS/GSn5IJ9ks4dlz3/wqxk+4uScc+1+DRYLjEFNeLkbU/O4sbFXoNBkYVLFuZrt3wtZ404Kz279Kx6Tpv13eHfzcSXJ+b2Z2+vego16NV5r+abt34zl+53aVbqtFLVc1pU147JZfsnp2zf/Pm/zkiGXpA86ma8tDJiCmrAx9f8eL6+zddz+PWHp7Gpseo51Kjbnrktd0y5I7/b63dVT2mTdlpvpxy1xVE5/ubjq55CDbt08qV5+OWHc/qup1c9pcWs+r9vfX7wZs2fv2vq0itSL3gJIq2QmIJWrkfnHrl0v0tz/C3H54VZL1Q9hxr39Vu+nkH9BuWLW36x6iltSn2P+oz67Kgcdt1haZjbUPUcatxXbvpK9txwz+y10V5VT/nQbdh36Tv2bbtO8+dHPZLsOjp5Y37L7oJ/lpiCVu6sEWfl7ufvztWPXV31FNqAtxa/lQOvPjA/3fmnGdRvUNVz2oQOdR1yyX6X5IKJF+TOKXdWPYc24M0Fb+bQaw/NuXudmzV7rVn1nA/NTusl930x2XDV5s9//67kiOuTRZ6QQSsmpqAV+7ft/y1D1hiSE245oeoptCFPvPpETrz1xFx70LXp16Nf1XNq3s8//fN06tApP/rzj6qeQhtyz7R7csZ9Z+SWkbekT9c+Vc9Z4b68dXLroUnfZl4atnBJcui1yY/+3PK74P0SU9BKfXHLL+bIIUdmxKUjMnfR3Krn0MaMnjQ6l0y6JGNGjknvrr2rnlOzThp2Unb7yG7Z78r9sqRpSdVzaGNOv/f03Dnlztzw+RvSrVO3quesEB3rkrNGJGfvmXRq5rfQ199KPj06uXRyy2+DEmIKWqF9PrpPfrjDD7PbJbt5/QUfmh/++Ye594V784eD/5CuHZu5oQvv6sghR+bLW385u12ym9sV8KE58dYT88KsF3LZfpelQ11t/9rWo3Pyh4OT4z/R/PlnXk+GXeCtz6kttf23Etqg4esOz3l7n5e9L987z7zxTNVzaONOuOWENMxpyBUHXJHOHTpXPadm7LvxvvnJTj/Jbpfslpdmv1T1HNqwpjTlC9d/IT279Mw5e52TutRVPanImr2Su49M9tyo+fN3TU22OT/522stOgs+MDEFrcgBmxyQqz53VQ66+qA8NP2hqufQDjQ2Nebw6w9PXeryh4P/0O7ubVPi8M0Pz9l7np09L9szT73+VNVzaAcWNS7Kfr/fLxv13ShXHHBFzV1J3mat5L6jky36N3/+3AeXvmPfa2+17C5YEcQUtBLf+OQ3csZuZ2TX0bvmrql3VT2HdmThkoXZ//f7p2FuQ24//Pas1n21qie1WicNOyk/2uFH2eG/d8jElydWPYd2ZM7COdntkt3S1NSUPx32p6zSbZWqJ72nuiQnDVt6RWpAM++h0diUfPPW5NgbvWMftUtMQcU61HXIGbudkaO3ODrDLhiWRxoeqXoS7dCSpiU56g9H5c4pd2b80eOz0arLeS5OO9WpQ6f8157/lZGDRmbbC7fN3177W9WTaIcWLFmQz1/z+Yx/YXzuPfreDFx5YNWTlmu17snNI5Offzrp3HHZ8/MWJftdmfzqvpbfBitSp6oHQHvWd6W+uegzF6VXl17Z7sLt8uaCN6ueRDvWlKacOvbUPPvGs/nLkX/JN2/9Zi6dfGnVsyo3cOWBuXz/y/PK3Fey/UXbZ/bC2VVPoh1rSlNOvv3kPPfmc/nLkX/JYdcdlrFTx7bcgCdHJI/vn/R5Phk8Ouk7ZZkPGdQvueHzycCVm/8jXp6T7H15MsHLDWkDxBRUpE/XPpl47MRc9dhVOeWOU7JwycKqJ0GS5KKHL8qD0x/MlQdcmV3W3yXH33x8u317/s9t8rn8Zo/f5Kd/+Wl+dd+vqp4Dbzv7gbPz5GtPZvS+o3PxIxenLnVpStOH+0kf2zf5/bX//9///L3kI7cmG92YfOzapFdD9t04GbVv0rNL83/E/S8kB16dPO+xQ9oIT/ODinTp2CXH3nhsvnXbt4QUrc6khknZ6tyt0tjUmAe/9GC26r9V1ZNaVK8uvfK7vX6Xn+z0k4y4dISQolW6/dnbs8XvtkhjU+OHH1JJMumwd/57U8fk6T2Sm89O/vPlfKfDN3PtQcsPqdPvTba/SEjRtogpqMgr817JmKfHVD0Dlmveonk5+oaj84M//yA3HnJjzt7z7PRdqW/Vsz50hww6JI9/9fF07NAxW527lXfWpFV7Zd4rOXXsqS3zybq/stxTX/7y2fnpqWc0e+611/pmxMFn59tHX5tFY36WTDokmTngw1oJLcrT/AB4V1c8ekXGPD0mP9rxR3nsK4/l1LGn5oKJF6SxqW29/dZm/TbLb0b8Jj279MwBVx2Q+17wynh4h+1+ljy7SzJz/XccHjHi5px11tea/Y9MnrxZPvOZP2TKlPWXPdn3yaVPERx8SbKmd8ekNrkyBcB7mjl/Zk645YTsdsluOXzzw/Pglx7MAZsckA51tf9jZKNVN8oF+1yQOw6/I5c/enk+cf4nhBQ0p++zyXFbJDt/J+nzXJJk8OBHcuWVB6Vjx2UfXPnDH/bJsGH3Nh9SSfL6Rsl9JybnPpRcdFfyzM5piWcrwopU+z8FAWgxjzQ8ku0v2j6njj01/zL0X/LXr/w1R2x+RDp1qL0nOmxev3muPODK3H3k3Zk6c2o2/s3G+d2Dv2tzV9xgheo2K9n+Z8nX189qJ3w8N/5peHr1mrPMh51//tHZd9/rMmdOr3/uz33uU8no25PfPZRM+FKysPsKHg4fDjEFwPt245M3ZugFQ/OVm76SQwcfmqe/9nS+O/y7WbfPulVPe1fdOnXLgZsemDEjx+SmQ27KfS/cl/V/vX5OG3da3pj/RtXzoGbUdWjMxcdPyIB+s5Y5d9uDA/Pl322Tpv4Tkq4z398f/PIWyY2/S379bHL/8cnizitmMHxIau+hRABajbFTx2bs1LHZsv+WOWqLozLhSxMyuWFyRk0alasfuzpzFi77iHUVhg0YliM2PyIHbHJAJrw0IaMeWbpvwZIFVU+DmvQvw5I9Nlz2+KMzks/9aWoW7/WlpQeaksxbLXltw+T1DZOGQclzw5OXts67PqY/tz655axk/DeTXU9a+tbrdR/GVwIfjJgC4AN7aPpDeWj6Qznx1hOz54Z75ojNj8iZu5+Z/3nxf/KnZ/+U2565LQ+//HDLvH1zkvoe9dll/V2y60d2zS7r75KZ82dm1COjMvi/BufF2S+2yAZoq7ZZK/n3nZY9/uq8ZK/Lkll//xhFXZIery79Z53x///43FWTx/dL7v968sqmy/9kM9dPfn9NssHNyYgTklWfWVFfBqwQYgqAFWbhkoW57onrct0T16Vnl5751Lqfyq4f2TWX7X9ZVl1p1dz9/N2Z1DDp7X+efePZDxxYq3RbJYPrB2dQ/aAMrh+cT6z5iazTZ52MnTo2tz1zW3745x/m2TeeXUFfIbRvPbskl++fdO647Lkjrk+e+2fvIdXjtWTr85Itz0+e2De591vJC0OX//FP75H8dpdk6C+THX6YdJ5fMh9WODHFOxw2+LActcVRLfb5hqwxJNNnT2+xzwe0nDkL5+Smp27KTU/dlCQZ0HtAhg0YlkH1g/KFIV/I4PrBWa37annm9WfSMLchDXMaMmPejDTMacjM+TOzqHFR6nvUp66uLkdvcXRW6rxS6nvUp1+PfqnvUZ/6nvUZ0HtAenXtlckNkzNpxqQ8NP2hXPDQBZnw0oQsaVpS8X8D0Pb8/NPJeqsse/wX9yY3P1XwB3ZoSja5duk/0zdfGlWTD0mzTwFs7JLc853ksc8lexyfbDgm9T3q079X/4w9YmzBJ/9g/A5DIqao2PTZ0zPuuXFVzwBawLRZ03LlX6/MlX+98u1jfbr2yfqrrL80kHrWvx1LG626UTrWdcwqKy39rW3ogKGZv3h+ZsydkYemP/R2fL04+8U8/+bzVX1J0K7svF7y5a2XPX7/C8kpd6yAT9D/kWT/w5Jhv0hu/4/kmd2b/7g3PpJcekvy0T/kj9tMyN5bNTMKWoiY4h1GTxqd0ZNGVz0DaCfeXPBmJr68/Jt1/t+jzV+84YstNQloRq8uyQX7LHt87sJk5LXJohV5R4H+jySHjkie+Exyy5nJrHWa/7i/fSYn7/dqTt73iGSjm1fggH9OFVfDaH28NToAAO/qvL2TdVde9vjJtyfPfBh3FahL8rE/JMd/LPnUD5OOy3nnzbdWSy67Kbnt58mSZl7IBR8yMQUAwHKdODQ5aLNlj4+dkpz9wIf8ybvMS3b8QXLckGTdu5b/cfeelFz+x2RBzw95ELyTmAIAoFk7DEx+tsuyx+csTI66IS10s4Mkqz+RfGHHZP+Dkx4NzX/M0yOSi/6czFqzpVaBmAIAYFlr906uPCDp1Mxvi8f8MZk6s4UH1SUZdGXy5UFL7zvVnJe3TM67P2lo5lIafAjEFAAA79C1Y3LNgUm/Hsue++X45IpHW37T23q+khyyV7LLyUmaeeeL2WsnF41LXtqixafR/ogpAADe4b/2TD6x1rLH/zx16ZtOVK5DU7Ldz5PPfybpNG/Z8/NXSUbdnkwf0uLTaF/EFAAAb/vKx5Mjm7mo8+Ks5MCrk8Ur8m3QP6iP3ph8YYekZzM3z53fNxn1p+SVjVt8Fu2HmAIAIEmy6krJLz697PEFi5P9fp/MmNvym97T2g8kRw9NVv3bsufeWi25+M7k1Q1bfhftgpgCACBJMmxAslLnZY9/+abkf15s+T3/tFWeS47YMen75LLn5vRPRt2RzFzOzX/hAxBTAAAkSR5/NVm05J3Hzn4guejhSua8P72nL3379FWeWfbcrAHJJbckb63c4rNo28QUAABJkqdfT75049Kn8721KPn1/ck3xlS96n3o/VJy2KeT3tOWPffqJsl1o5LGupbfRZslpgAAeNt/P5ys+Z9J939fGlKLWtMbTvwz+k5Z+pS/5t6U4sm9k/u+0eKTaLvEFAAA77CkqeoFH9CqzySH7pZ0fXPZc7f/R/LCx1t+E22SmAIAoO1ZY3Ky72HLHm/ssvTpfoubeacNeJ/EFAAAbdPGf0w+ecayx1/bOJl0aMvvoc0RUwAAtF27fCfpP2HZ49OGtfwW2hwxBQBA29VpYfKZo5IOi955fK0HqtlDmyKmAABo29aYnBy0b9L3qaTrzGSbXyVbnlf1KtqATlUPAACAD91Hb1r6T2Nd0qHW366Q1sKVKQAA2g8hxQokpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAKdqh5A9ep71Kd/r/4Ze8TYqqe0G0PWGJLps6dXPQOANsLP8pbnZzmJK1NQiemzp2fcc+OqngFAGzHuuXF+sYcKuDJFGuY2pGFuQ3a8eMeqpwAABY676biqJ7Q7rgKSuDIFAABQREwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQoFPVA6hefY/69O/VP2OPGFv1FIB3GLLGkCTx/QlodYasMSTTZ0+vegYVc2WKjHtunG8GQKs0ffZ035+AVmn67OkZ99y4qmdQsbqmpqamqke8X3U/rKt6AgAAsII1fb+20sSVKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoEBNxlSvLr2qngAAAKxAtfg7fl1TU1NT1SMAAABqTU1emQIAAKiamAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKPD/AC1xgI0iD9cLAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1080x720 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "length, width = 105, 68\n",
    "fig, ax = create_pitch(length, width,'white')\n",
    "x = length/2 + pes_goool.iloc[:, 0] \n",
    "y = width/2 + pes_goool.iloc[:, 1] \n",
    "bx = length/2 + pes_goool.iloc[:, 2] \n",
    "by = width/2 + pes_goool.iloc[:, 3] \n",
    "plt.plot(x, y, linewidth = 5, color = 'blue')\n",
    "plt.plot(bx, by, linewidth = 5, color = 'yellow')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "12edb69c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:49.886840Z",
     "iopub.status.busy": "2022-04-16T16:25:49.885931Z",
     "iopub.status.idle": "2022-04-16T16:25:50.716844Z",
     "shell.execute_reply": "2022-04-16T16:25:50.717322Z",
     "shell.execute_reply.started": "2022-04-16T16:22:42.860512Z"
    },
    "papermill": {
     "duration": 0.907295,
     "end_time": "2022-04-16T16:25:50.717518",
     "exception": false,
     "start_time": "2022-04-16T16:25:49.810223",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA1MAAAIuCAYAAABac1I3AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAA0wUlEQVR4nO3debiXdYH38c857BwWMWVRUTQzNVBMpwIT11zSNNcsUkuznBYrn2maabSmrOeZJ50s28xcHiFN09zKRFMxLMxJRRHNcgFFxIMLICLrOef54wduuX5F7t/vnNfrus7l5QHjw1wDnDf3fX/vpo6Ojo4AAADwhjRXPQAAAKARiSkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoED3qgeUGPB/BmTR8kVVzwAAANaQ/j375+l/f7rqGW9IQ16ZElIAANC5NOLX+A0ZUwAAAFUTUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABToXvUAqnfGvmdk3Cbj0rq4teopAC8ypGVIkvj9Cag7Q1qGZMpDU3LcVcdVPYUKuTJFxm0yLsP6D6t6BsA/GNZ/mN+fgLo0rP+wjNtkXNUzqJgrU6R1cWtaF7dm1/N2rXoKwItMPmpykvj9Cag7q39/omtzZQoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKCAmAIAACggpgAAAAqIKQAAgAJiCgAAoICYAgAAKCCmAAAACogpAACAAmIKAACggJgCAAAoIKYAAAAKiCkAAIACYgoAAKBA96oHUL0hLUMyrP+wTD5qctVTuowhLUMy5aEpOe6q46qeAkAncMa+Z2TcJuPSuri16ildxuihozN30dyqZ1AxV6agAsP6D8u4TcZVPQOATmLcJuMyrP+wqmdAl+PKFGld3JrWxa3Z9bxdq57SZbgKCMCa5M/ytc+f5SSuTAEAABQRUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFulc9gOoNaRmSYf2HZfJRkyv5sac8NCXHXXXcWv+xgeoN7DUwmw3aLEP6DcmQliEZ0m9IBrcMzsBeA9O9uXu2Wm+rdKQjZ+9/dpauXJp5i+eldXFrWp9pTevi1sx5ek4eXvhwOtJR9U8FqMAZ+56RcZuMS+vi1rX+Y48eOjpzF81d6z8u9UVMUalh/Ydl3Cbjqp4BrAUbD9w4YzYak22GbJNRg0dlmyHbZN0+6+aB+Q88F0fzFs/LY888lnufuDcr2lbkvRu+N2lK/jT7T+nbo28GtwzO6KGja+HVMiTDBw7PgF4DMmPejExvnZ7prdNz+9zbc+ujt6ato63qnzLwFhu3ybgM6z+skpiCREyR1P6Wd3Frdj1v17X+Y1dxNQxYO/r17JddRuySPd++Z/bcbM+s22fd3PTwTbmz9c6cc8c5md46PTPnz3zVq0qfGP2JJMk50855xe8zqPegjBoyKqMGj8rooaPzme0/k40HbpwbZ92Yax+8Ntc+cG0enP/gmv7pAXXA1zBUTUwBsMb07NYz+22xX47a9qjsOmLX3DLnlvz+wd/n8F8fnjsfu/MtuR1v/tL5mfLQlEx5aMpznxvcMjh7bLZH9txsz5w07qQsXLowE6ZPyMQ7J2bOojlrfAMAXZOYAuBN237Y9jl6u6Nz2LsOy/TW6Zlw54SMv3R8nln+TCV75i2elwvuuiAX3HVBkmTMRmNy1OijMv2fp+e2R2/LhOkTcvHdF2dZ27JK9gHQOTjND4Biu226W6474rr8+rBf59FFj2b7M7fP7hN2z3l3nldZSL2cmx+5Ocf99rhs+L0N8/Pbf57xo8bngeMfyAljTkhLj5aq5wHQoMQUAG/Yh7b4UP58zJ/z4w/+OBOmT8jmP9w837npO3l44cNVT3tVS1cuzcX3XJx9zt8n+16wb96zwXsy84sz8/Wdv55BvQdVPQ+ABuM2PwBet22HbJsfffBH6dezX7495du57N7L0t7RXvWsIne23pnDf3143rHuO/Jv7/+33Pv5e/ONG7+RM287s2F/TgCsXa5MAfCa1um9Tn64zw9zzcevyXl3npftz9w+v/7rrztFdNz31H055spjsvuE3XP4uw7PX479S9630fuqngVAAxBTALyqw0cenr9+7q9pbmrO1j/ZOmfdflaniKiXmjFvRnY5b5ecOvXUXHLoJTlr/7PSv2f/qmcBUMfEFFRk/b7rZ+/N9656Bryilh4tOWf/c/KNnb+R/S7YL5/73efy1JKnqp71lvvljF9mqx9vlbb2ttz+mduz/bDtq54Er2hwy+B8e7dvVz0DuiwxBRVZ3rY8P9vvZ/nvPf87Pbv1rHoOvMi2Q7bNrZ++NUmyw5k75La5t1W8aO1atHxRPvPbz+Tfr//3/G787/Ll9305TWmqeha8yAc2+0CmfWZakvj/T6iImIKKLFy2MKPPGJ3N1908k8ZPysBeA6ueBEmST47+ZH5/xO9z8pSTc/SVR2fxisVVT6rMJfdckvee9d4c9q7DcsXhV7jtj7rxuX/6XM494NyMv3R8TrzhxLfkhdjAaxNTUKH5S+fnwIsOzB2td+RPR/8pwwcMr3oSXVhTmvLt3b6dr+30tbz/3Pc/98Lbrm7WglnZ6dydMmfRnNz0yZuyYf8Nq55EF9aUpnz3A9/N59/z+bz/3Pfnxlk3Vj0JujQxBRVr72jPCdeckLOmnZWpx0zNtkO2rXoSXVD35u4594Bzs+uIXTPm7DH5+5N/r3pSXVnZvjL/fNU/5xd3/SJTj5maLdfbsupJdEG9uvXKLw/+Zd634fsy9uyxmbVgVtWToMvznimoE9//8/cze+HsXHvEtTn8ksMzedbkqifRRfTs1jO/OuRX6dGtR/aYsEeWrFxS9aS6derUU9P6TGsmHzU5Hzz/g5n22LSqJ9FF9OvZL7/96G/Turg1H5j4gSxrW1b1JCBiCurKr//66zz+7OO5+NCLs8/5++T2ubdXPYlOrrmpORMPnJiOdOTDF344K9pXVD2p7k2cPjHPLH8mV33squz8/3bOfU/dV/UkOrkezT1y6WGX5u9P/T2f+c1nPB8FdcRtflBnpjw0Jcf+5tj85qO/yebrbl71HDq50/c5Pev3XT+HX3K4kHoDLrv3svzHDf+Raz5+TTbov0HVc+jEmtKU8z58XhYtX5TjfnuckII648oU1KEr/3Zl1u+7fiaNn5Qdz9kxrYtbq55EJ/SNnb+RMRuNyS7/bxe3DBU4945zs17f9XLNx6/JuHPHZf7S+VVPohM6be/TskH/DbLXL/bqlC/LhkbnyhTUqbOnnZ1z7zg3kz4+KS09WqqeQydzxDZH5OPbfDz7nL9PFi1fVPWchnXK1FMy6f5JufQjl6ZbU7eq59DJfGXsV7LriF1zwIUH+AsPqFNiCurYd276TqbNnZbT9zm96il0Iluut2W+t9f3cuBFB2be4nlVz2l4X73uq1nZvjJf3/nrVU+hE3n/xu/Pl9/35exz/j5ZuGxh1XOAVyCmoM594eovZKeNd8ohWx9S9RQ6gT7d++RXh/wq/379v2fGvBlVz+kU2jvaM/7S8Tlmu2Oy+6a7Vz2HTmBgr4GZeODEHPubY/PookerngO8CjEFdW7xisX52KUfy4/2+VE2GrBR1XNocD/Y5we5a95dOev2s6qe0qnMWzwvR15+ZCYcOCFDWoZUPYcG95N9f5Kr7rsqV913VdVTgNfgAApoALc+emt+cMsPMvHAidl9wu4eQqbInm/fM7tvunu2PcOLod8KN8y8IedMOyc/+uCPcujFh1Y9hwY1ftT4jB46OjucuUPVU3gFZ30oOXLbpPuqSxJtJ636Z0cyvTX5xBXJDHdQdxmuTEGD+L9/+r9pbmrOcTscV/UUGlDPbj3zw31+mC9c/YU8s/yZqud0Wt+e8u1sN3S77LHZHlVPoQGt33f9nLbXaRl/6Xgvz65TZ30o+eTo50MqSZqaah/dmpLthia/PjQZObiyiaxlYgoaRHtHez73u8/l6+O+nkG9B1U9hwZzwpgTcu8T9+Z39/2u6imd2rK2ZfnSNV/KD/f5YXo096h6Dg3m5N1Ozvl3nZ87Hruj6im8go+NqoXTy1n9+U0HJQdttfY2US0xBQ1kxrwZufTeS3PSzidVPYUGMnzA8PzLmH/JlyZ9qeopXcJv//7b3P/U/fnymC9XPYUGMnLwyHz4nR/ON//wzaqn8Cp6vI6vnJubkk0GvvVbqA9iChrMf974nzlymyMzfMDwqqfQIE4cd2LOuO2MzFwws+opXcaXJn0p/zr2XzOg14Cqp9AgTt715PzXn/4rC5YuqHoKr2LF63hkub0jechp9l2GmIIGM2/xvJx5+5muTvG6DO03NIdsfUhOu/m0qqd0KQ/MfyCT7p/kGUdel3/a4J+ywwY75Kd/+WnVU3gNV9+XdHS8/Let/vTM+cmlf11rk6iYmIIGdMqfTskhWx2S9fquV/UU6tzx7z0+5991fp5c8mTVU7qc7079br743i+mZ7eeVU+hzp0w5oScMvWULGtbVvUUXsXIwcmiFcm8xS8Oqo6O5z+mPZYcfLHT/LoSMQUNaP7S+bnyb1fmyG2PrHoKdax/z/459t3H5ns3f6/qKV3S9NbpufOxO3PENkdUPYU6tl7f9bL35ntnwp0Tqp7Cazhoq2T+kuTSe5Pp85JFy2sftzyaTLwrGf2zZIefC6muRkxBg/r57T/Pse8+tuoZ1LEjtj0i1z94fWYtmFX1lC7rlKmn5Pj3Hl/1DOrYkdsemSv/dqVnperYyMHJ13dOxo9Mth1a+9zU2Ulbe9KUpFe35NSpIqqrElPQoP40+09p72jPThvvVPUU6tTh7zo8E6b72+4q3TjrxqzbZ91sud6WVU+hTh377mNz5m1nVj2DVzBycPIvY5NBvZNHFyXr9ErGrjr/aeGy2scVfxNSXZmYggbm6hSvZMP+G2br9bfO7x/4fdVTurSOdOTiey7OR971kaqnUIfev/H7097Rnj/N/lPVU3gFq2/tW7A0ueeJ2rukOjqSrdavvbi3e7PDJro6MQUN7IK7LsiH3vmhdGvqVvUU6syh7zo0l//t8qxoX1H1lC7vohkXiSle1oFbHpgL7rqg6hm8gpGDkwPemey8SbLziNrnps5OFi5NNuxXOyZ99kJXpbo6MQUNbN7ieXl44cN597B3Vz2FOnPo1ofmV3f/quoZJLllzi3p06NPRg4eWfUU6szum+6e6x68ruoZvIzVt/ctW5ksa0v6dH/+9r47WpPzZyQPLUgW+/uqLk9MQYO7YeYN2W3T3aqeQR3p071Pth2ybf4w6w9VT2GV62den3GbjKt6BnVkvb7rZcQ6I3Lro7dWPYWXsfr2vmmPJb271z63dGWy3bBkUB+39vE8MQUNTkzxUjtssENmzJvhnTV1ZOrsqRmz0ZiqZ1BHdhmxS256+Ka0dbRVPYWXscnA2u188xbXbu1bsqJ2ap+T+3gpMQUNbspDUzJmozFeDMpzxg4fm5sfubnqGbzAzbNvFlO8yG6b7pYbZt5Q9QxeYvUx6KOHJntungxuqQXVHx6qfTi5j5cSU9DgFi5bmIcWPpSt19+66inUiTEbjRFTdebeJ+7Nun3Wzfp91696CnVih2E7+HVaZ154DPotjyQDeyW7jEiGtCTr9HZ7Hy9PTEEn8OD8BzNinRFVz6BOjBoyKtPmTqt6Bi/QkY7c8dgd2WbINlVPoU5sOmjTPDj/wapnsMrIwcnpeyc7DKu9mLcjyY2zarf6vXejZP5St/fx8rpXPQB482YumJlN19m06hnUgaY0ZcP+G2b207OrnsJLzH56djYasFHVM6gD/Xr2S5/ufTJvsa/M68HqK1KDW5LHn33+5L6ps5NrH0iGD0y+5TwfXoGYostp6dGSA7c6MFuvt3WeXflsrn3g2vzPnP+petabMnP+zLx93bdXPYM6sH7L+nl62dNZunJp1VPelHV6r5ODtjoomw3aLCvbV2bU4FG5a95dVc96U2Y/PTvDBw6vegZ1YMQ6IzJrwayqZ7xp6/ddP4dsfUg2HrhxnlryVC6/9/Lc99R9Vc96w1af3DdvcdKnR+3UvqT2Yt7lbclDC6vdR30TU3Qpx21/XP57r//OyvaVGdBrQFa2r8xXd/xqHnn6kex7wb4Ne8vFrAWzsvumu1c9gzowfMDwhr8qddK4k/K1nb6Wle0r069nv7R3tOfmY27OPY/fk/0v3D+PPfNY1ROLPPL0Ixk9dHTVM6gDjR5TzU3N+f5e38+x2x+btva2tPRsybKVy/Kfu/xnbp59cw7+1cFZuKwxCmT1i3mbUnsJ74BeyYKltaAa3Lf2nNTZ7prmVXhmii7jyG2OzKl7npq+PfpmQK8BSZLuzd3Tr2e/vGPdd+TPx/z5uc83mtlPz86GAzasegZ1YMMBG2bO03OqnlHsa+//Wv51x39N7+69069nvyS1L9xaerZk9NDRufmYm9OjuUfFK8vMeXpONurvNj+SDftvmEcWPVL1jGKn7316jt7u6PTu3jstPVuSJL2690rfHn2z48Y7ZvJRkyte+Pq89MW87R21zzc3Jev3rV2p8pwUr0VM0SV0a+qWU/Y85bnf9P/h25u7pW+PvvnsP312LS9bM5atXJZe3XpVPYM60LdH3zyz/JmqZxRp6dGSf9vp356LqJfq0a1H3tbnbfnYqI+t5WVrxjPLn0nfHn2rnkEd6NW9V8Peiju039Acvd3Rr/jnae/uvbP5uptn7833XsvLXr/Vx5+f9+Fki7fVbuNb/WLeBUuTto7k1rnJ8ZOEFK9NTNElvGvwu9K7e+9X/T4tPVvy0ZEfXUuL1qzlbcu9Z4okSY/mHlnZvrLqGUXGDh+b9vb2V/0+/Xv1b9hfpyvaV6RHt8a8qsaa1bNbz6xoW1H1jCJ7bLbHa/4e079X/xy81cFradEb88Ljz5tS+9hyveTeJ7yYlzKemQIAoNNbffz54JZk3rO1Z6SS2vNRQ/olf5hVe5/U/KVCitfPlSm6hLvn3f2at1QsXr44v5zxy7W0aM3q2a1nlrctr3oGdWBF+4p0b27MvyebOntqmptf/Y+lRcsWNeyv0x7NPRr2agRr1vK25Q17lfK6B697zd9jFi1blF//9ddradHr83LHnw/oVYunJFmnlxfzUkZM0SW0dbTlK9d+JYuXL375b29vy7Mrns1P/vKTtbxszejVvVeWtS2regZ14NkVz77iM0f1bvGKxfmvm/7rFZ/5WtG2Ik8ueTIX3HXBWl62ZvTr2S/Prni26hnUgWUrl73mref16rFnHss50855xV+nS1cuzf1P3Z9J909ay8te2QtfyNu3R+0Wv6Ura89HPb0s6eiovaTXi3kp0Zh/fQkFJkyfkL49+v7D0ehLVyzNI4tqR6M/vezpqmcWGT5geEOf4MaaM+fpOQ19suP//uP/Trfmbv9wNPqSFUty9+N354ALD8iK9sa8urPhgMY+wY01Z86iOfnQFh+qekax4ycdn7aOtnx6+0+/6Gj0to62TJ09NYf86pCqJz7npVekBvVONlp1cO/8pbVT+26dK6IoJ6boUs647YxMnD4xH97yw3nX+u/KsyufzTX3X5O/PPqXqqe9KSPWGZFZC2dVPYM6MPvp2Rk+oLFfDHvylJNz+i2n5+CtD87Xx309bR1tOeDCAzJj3oyqp70pGw3YKI88LaaovRtwxDojqp5RrL2jPV+c9MV8e8q3c/DWB2eTgZvkySVP5vJ7L8/9T91f9bwXeekLeeevuuN/QK+ke7Pjz3nzxBRdzuIVi3P+XedXPWON2nTQppk5f2bVM6gDjy9+PAN6DUjv7r0b9ujlJFm4bGHOmXZOjtjmiCRp+JBKaleQb5h5Q9UzqAONHlOrPf7s4znj1jOqnvGKXumFvPOX1kLKFSnWBM9MQSew6TqbZuYCMUXSkY7MWTSn4a9OdUbDBwx3ZYoktXeOLVm5JINbBlc9pdPyQl7WFjEFncBmgzbLrAWzqp5Bnbir9a5sN2y7qmfwAk1pyuihozO9dXrVU6gTM+fPzGaDNqt6RqfjhbysbWIKGtzAXgOzycBNcs/j91Q9hTpx8yM3Z8xGY6qewQtsud6WeWrJU3n82cernkKduHXurX6drmFeyEsVxBQ0uHGbjMvNj9zsPVM8Z+rsqb5IqzNjho/JzY/cXPUM6sgNM2/IbpvuVvWMTuOFx59vO/RlXsj7UO3jir8JKdYsMQUNbrdNd/NQOy9y66O3ZuTgkenVrVfVU1hl7PCxYooXuXHWjdlp450a9iXb9aSlhxfyUh0xBQ1OTPFSS1YuyZ2td2bnETtXPYVVdt9090x5aErVM6gjTzz7RGYtmJXth21f9ZSGNXJwssk6tVv5tnhbsnhF7fkoL+RlbRJT0MAGtwzOxgM3zu1zb696CnXm4nsuzmHvOqzqGSR574bvzZIVSzrF8e6sWdfPvD57bLZH1TMa0urno3qs+kq2Kc9fjVodVC09kr8/lRx1efKtPwgp3hpiChrYx0Z9LL/522/S1tFW9RTqzMV3X5wPv/PD6dHco+opXd5HRn4kF919UdUzqEOX3XtZxo8aX/WMhrT6Zbwr22sfyfNXo5ascPw5a4+YggZ27LuPzc9v/3nVM6hDcxbNyT2P35MPvP0DVU/p0prSlEO3PlRM8bL++PAfkyQ7Dt+x4iWNY/XR5+NH1g6a6NGcPLvi+ePPezQnd7Y6/py1R0xBg9px+I5pbmrOTQ/fVPUU6tSFd1+YI7c5suoZXdouI3bJU0ueyr1P3Fv1FOrUWdPOyqe3/3TVMxrCC48+f3RR7WCJgasOmZg62/NRVENMQYNyVYrXMvHOidl9s90zYp0RVU/psr4y9is5/ZbTq55BHTvvjvOy/zv3zzq916l6St1bfWvfgqXJPU8kTU21gOrbM1ne5vkoqiGmoAEN6j0o+79z/5x3x3lVT6GOLVq+KD+//ec5YcwJVU/pkrYZsk22HbptJk6fWPUU6tiTS57MpPsn5chtXUV+JS+9tW9wS+15qKmzk7b22ot4XY2iKmIKGtBXdvxKLvnrJXlyyZNVT6HOnX7L6Rk/anzW67te1VO6nH8d+6/5wS0/8EJtXtP3bv5evjL2K+ndvXfVU+rOy93aN3b480H1zIqkdbGrUVRHTEGDGdwyOJ9+96dz8h9OrnoKDeCxZx7LJfdcki+970tVT+lS3j7o7dl7871zxq1nVD2FBvCXR/+SWx+9NcftcFzVU+rG6qtR53249g6pnt1efGvfVuvXjkHv3pw8sbjqtXRlYgoazH/u8p+ZMH1CZj89u+opNIiTp5yc47Y/Lpuus2nVU7qM7+/9/Xx36nfz9LKnq55Cgzhp8kn5tx3/zbNTefHVqKbUPsYOr33b1NnJwqXJhv1qt/bNXlh7WS9URUxBAxk1eFQO2vIgV6V4Qx55+pGcevOp+f7e3696Spew3xb7ZfN1N89pN59W9RQayIx5M3L53y7PN3b+RtVTKvfCgyYWLK19bunK2tWoeYuTO1qT82fUbu0TUlRNTEGDaG5qzo8/+ON8a8q3Mn/p/Krn0GC+d/P3suV6W+aD7/hg1VM6tV7deuX7e30/X7j6C1nR7qs83pgTbzgx40eNz+iho6ueUomXO2jir088/w6pdXrVbu0b1Ce59K/VboXVxBQ0iK/u+NWsbF/pGQyKLG9bni9c/YX8cJ8fpl/PflXP6bROHHdipj02Ldc9eF3VU2hATzz7RL58zZdz/kHnp0/3PlXPWate6aCJxDukqG9iChrAP23wT/nie7+YIy8/Mu0d7VXPoUFd+8C1uX7m9fnZfj+rekqntNumu+Xo7Y7O53/3+aqn0MDOv+v83PHYHTllz1OqnrJWvdI7pLZa3zukqG9iCupcS4+WnH/Q+fn81Z/PI08/UvUcGtwXr/5iRg0elU+9+1NVT+lUhrQMyYQPT8gRlx2R1sWtVc+hwX32qs9m33fsm/222K/qKW+5V3uH1AsPmnA1inolpqDO/XCfH+amh2/KJfdcUvUUOoElK5fksEsOy//Z/f9k1OBRVc/pFJqbmvOLg36Rs6ednRtm3lD1HDqBhcsW5uOXfjxn7ndmNui/QdVz3jKv9Q6pFx40IaSoV2IK6th/7PQfGT10dI6/+viqp9CJ3PvEvTnhmhNy6UcuzeCWwVXPaXjf/cB30725e771h29VPYVO5E+z/5TT/nxarh5/dQb2Glj1nDXq9b5DykETNAIxBXXqU+/+VD45+pPZ5/x9sniFNxKyZk2cPjG/mP6LTBo/KQN6Dah6TsP6ytivZK+375WDLjoobR1tVc+hkzll6im5YeYNufKjV6Z3995Vz1kj3sg7pNzaRyMQU1CH9n/n/vnmLt/MXr/Yy/MXvGW++YdvZuojU3PF4VekV7deVc9pOJ8c/cn88w7/nL1+sZfXFfCWOeGaE/LI04/kgoMuSHNT43/Z9kbeISWkaASN/6sSOplxm4zLzz/083zolx/KA/MfqHoOndzxVx+f1mdac+EhF6ZHc4+q5zSMA7c8MN/Z7TvZ6xd75dFFj1Y9h06sIx35xOWfSL+e/XLGfmekKU1VTyriHVJ0VmIK6sghWx+Siw+9OB+55CO5fe7tVc+hC2jvaM+Rlx+ZpjTlisOv6HLvtilx5LZH5if7/iT7XrBv7nvqvqrn0AWsaF+Rg351ULZYd4tceMiFDXcl2Tuk6MzEFNSJL73vSzltr9Oy58Q9c+OsG6ueQxeyvG15Dv7VwWld3Jrrjrwu6/Vdr+pJdesrY7+Sb+3yrezy/3bJtMemVT2HLuSZ5c9kr1/slY6Ojvz+iN9nUO9BVU963bxDis5MTEHFmpuac9pep+WY7Y7J2LPH5s7WO6ueRBfU1tGWo684OjfMvCE3H3NztnjbFlVPqivdm7vnp/v+NONHjc+O5+yYvz35t6on0QUta1uWj/76o7n5kZsz9ZipGbHOiKonvaLVt/WdvX9ywDuTXt1qn/cOKTqb7lUPgK5s3T7r5twDzk3/nv3z/nPen4XLFlY9iS6sIx05afJJeXD+g/njJ/+YL1/z5Zx/1/lVz6rciHVG5JcH/zKPL348O527UxYtX1T1JLqwjnTkq9d9NQ8tfCh//OQfc8RlR2TyrMlrb8BjI5O/HJc8Mqb27xv9OfmnnyZDZzz3XVbf1jd/STJ7YbLVesnOI5IbZ9Viat7i2hWpyQ/VrkZBI3NlCioysNfATPvMtNz31H3Z+/y9hRR149w7zs0eE/fIieNOzLkHnJuWHi1VT6rMoVsfmls+dUsuuvui7H/h/kKKuvGTv/wkn7jiE5l44MR8Z7fvrJ2DKR4bmVz/7WTWrklbt+TpDZLbjk7O/J/ktAeyznU/zqc3Gvmi90d1JJn2WO0/325Y7Sh0B03QmbgyBRXp2a1nPvPbz2TS/ZOqngL/YHrr9Gx/5vb54T4/zG2fvi3jLx2f2+beVvWstaZ/z/45dc9Ts+uIXbPP+fs4EIa6dN2D12W7n22X4997fDrS8db/gH89KFk8OGlakTyzYbK8b9LUnLQnWTg8C6YekzOnHp2JvZalqdvK9Ojell4Dn8zwbSZnzuE/zcG7zsjwgclDC5Ozp7m1j85BTEFFHn/2cSFFXXt2xbM55spjcvjIw/Pbj/02l917WU684cQ8teSpqqe9pT426mP57h7fzaQHJmX7M7d3NYq69vizj+ekySdl8lFr4Va/hZskbb2T5QOS9h5JmmuXnrLqgaj22g1PS5b0SFNTR5Y2tWXRov6ZN/uY3HbV0fluz2VZ2b4y6daW9H0yGTH5H24RhEbjNj8AXtWFMy7MVj/eKivbV+aez96TY999bKd4eehLjRw8MjcedWNOeN8JOeTiQ/KpKz8lpOCFBj6UdFuarGhJOppTu2nv5X4vaEpHR9Le3i3tbT2T9u5Je4+sXNovWT4wWTIweXJEctsxz90imN/8uHYbITSYzvenIQBr3IKlC3L81cdnr1/slSO3PTK3ffq2HLL1IZ0iqrZ42xY5e/+zc/2R1+eXM36Z95z1nvz5kT9XPQvqz1aXJi2r7s3rSO1889XPar3oka3Vn3/pc1yr/71bkp5Juift3ZKFw5NpRyfn3JRc9EtRRUNp/D8FAVhr7my9Mzudu1NOmnxS/teY/5W7P3t3jtr2qHRvbry7xrcdsm0uOuSi3PTJmzJrwaxs+aMt87Pbfpb2jvaqp0F9Gjoj2f3EZMT1SdqSJE3NbWlqblsVVqu90vNbL42sjtTCqrl2i+DyPsm9B4sqGoqYAuAN++3ff5sxZ4/JZ6/6bD6+zcdz/xfuz4njTswmAzepetqr6t29dw5712GZNH5SrvrYVfnzI3/OZj/YLCdPOTnzl86veh7Uv6Ezko98LPnUTnn3fmdnwPqzk6a2pKktTd2Wp7nbylf5j18aWaujqj21qOpe+y6iigbSeH+VCEDdmDxrcibPmpx3D3t3jt7u6Nz66VtzV+tdmTB9Qi6555I8s/yZqicmScYOH5ujtj0qh2x9SG599NZMuLO2b1nbsqqnQWMaOiOf+/TnM3thMveBkbn1iuMyc9queXbBeklHtyxd1i1Z2Tu1YGpP7e/vu73C/9gLr1Q1pRZV7c9H1QN7J2+flOz8HYdVUHfEFABv2u1zb8/tc2/PCdeckH3fsW+O2vaonL736fmfOf+T3z/4+1z7wLW547E71s7xzUmGtAzJHpvtkT3fvmf22GyPLFi6IBPunJBtfrpN5iyas1Y2QGc1cnBy0FbJ6KHJVusn01pmZOjbP5+k9g6p+UtXvYx39Qt+Z+6aPLte7fmo9hdG1gufocqqf++IqKKRiCkA1pjlbctz2b2X5bJ7L0u/nv2y8yY7Z8+375kLDr4gb+vzttz08E2Z3jr9uY8H5z/4pgNrUO9B2WbINhk1ZFS2GbJN3rPBe7LxwI0zedbkXPvAtfnmH76ZB+c/uIZ+htC1jRyc/MvYZP6S5JZHkp1HJLuMSP4wK1nWVnsZ79nTVn3noTOSD33+H/9HVkfWfXsnizZIOpqSplUB1bH6CZSXiaoVvZO/H5C0jk52+1oy8rK3+qcLr0lM8SJHbHNEjt7u6LX2440eOjpzF81daz8esPY8s/yZXHXfVbnqvquSJMMHDM/Y4WMzasiofGL0J7LNkG2yXt/18sBTD6R1cWtan2nNvGfnpfWZ1ixYuiAr2ldkSMuQNDU15ZjtjkmfHn0ypGVIBrcMzpCWIRnSb0iGDxie/r36567WuzJ93vTcPvf2nH372bn10VvT1tFW8f8FoPM5aKtaSC1YWvv3G2cl2w1N3rtRcsXfXufLeF8YWY+NTP7wteS+fZKVLbXnr14pqjqak7amZP5myeW/SO6+Mgt23ji7vG/dtfOerZfwNQyJmKJicxfNzZSHplQ9A1gLZj89OxfdfVEuuvui5z43sNfAbDZos1og9RvyXCxt8bYt0q2pWwb1GZQkGTN8TJauXJp5i+fl9rm3PxdfcxbNycMLH67qpwRdysjByQHvrF0rWrAs+evjybzFybUPJMMHrrq1741afaDFa0bV6ueuUjs5cGX35O8H5DNHLc2/f31RRu++Rn6K8IaJKV5k4vSJmTh9YtUzgC5i4bKFmfbYtFf89tV/2/ypKz+1tiYBL2P17X3LViZNTUmf7snY4cnU2cnytuShhW/yB3jNqFr9jNXqqGpL2rtl3pye+fIXuyf7nL7Wb/ur4moY9cfR6AAAvKrVt/dNeyzpveqv4peuTLYbVntO6tK/rqEf6AVHr2erS5Juz666y6/j+bBKR9LUXLtC1dY9Wbxe7bY/x6hTATEFAMCr2mRgsnBp7ba+qbOTJSuSXt1qH6dOfR3PSb1RL42qphW1zze11z46ktqXsd2TtD93219+dXEy48A1PAZemdv8AAB4Wf9wDPrcWlDNW/z8MehrPKReaHVUzTgwueE7yYIRSUe3VUHVLUn7qqtU7bVj1xcOT67+8arxTvvjrefKFAAA/2D1c1KDeteOQR/Yq3YM+pCWWkit0dv7XnPMZclhhyXvvDxpWpmk+cVXqVbf9tfeLVmyTi2oXKFiLRBTAAD8gxceg966uHYM+sKltWPQ5y99i27vezWrr1Id9PGk7xMvvvXvuaBa9aWtoGItcZsfAAD/YJOByewXnNL3po9BX1NW3773D7f9NSdpTjpWHTm4Oqhe+N/AGubKFAAAzxk5OPn6zrXnpPbcPBnc8vy3Dey9Bo5BXxNe9ra/tqRpeZIeq275a3LSH285MQUAQJI6e07qtfzDbX8dtStSWZF09EjSrfb9VvZI7tsvueoHgoo1TkwBAJCkDp+Tej1GXpbs87mkz4Lavzc1rfqGF3yZ29Yrmfue2guBYQ0SUwAAJHn+fVKrrX5O6o7Has9J1V1IrfbSoEpTkvY896VuR5KVvZK/HeBQCtYoMQUAQJLa81ADe7/4c3XznNRreVFQdaz65AuCKqnd/ueUP9YgMQUAQJLa81CD+tSej2pKHT4n9VpWB1Xv+an9DJIXB1WbY9NZo8QUAABJarfxnTq19nzU8IF1/JzUqxl5WbLfcbWgakqev+WvKWluS7otrR1KcdNJDqTgTfOeKQAAnjNjXoPF08tZ/V6pq39cuxKVrDouvXuSpqRpWbK0f/LXg2qnAkIhMQUAQOfzwqBaPChpak6aVybpqP1zRUsyd3SVC+kExBQAAJ3T6qC64rykrXvSbXnSfVntc70XJMvWqWoZnYRnpgAA6LxGXpZs8D+1eOq2Ium+JGlpTbotq30O3gRXpgAA6NxGTEn6P5os2ihZuk4tovo/krzt/qqX0eBcmQIAoHPb6tKkuT0Zcmfyzitr/2xur30e3gQxBQBA5zZ0RjL21KTP/OTp4bV/jj3VSX68aW7zAwCg8xs6QzyxxrkyBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUKB71QOo3pCWIRnWf1gmHzW56ildxuihozN30dyqZwDQSfizfO3zZzmJK1NQibmL5mbKQ1OqngFAJzHloSm+sIcKuDJFWhe3pnVxa3Y9b9eqpwAABY676riqJ3Q5rgKSuDIFAABQREwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQoHvVA6jekJYhGdZ/WCYfNbnqKQAvMnro6CTx+xNQd0YPHZ25i+ZWPYOKuTJFpjw0xW8GQF2au2iu35+AujR30dxMeWhK1TOoWFNHR0dH1SPeqKZvNlU9AQAAWMM6vtFYaeLKFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUKAhY6p/z/5VTwAAANagRvwav6mjo6Oj6hEAAACNpiGvTAEAAFRNTAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFBBTAAAABcQUAABAATEFAABQQEwBAAAUEFMAAAAFxBQAAEABMQUAAFBATAEAABQQUwAAAAXEFAAAQAExBQAAUEBMAQAAFPj/jjGUWVOKI0oAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 1080x720 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "length, width = 105, 68\n",
    "fig, ax = create_pitch(length, width,'white')\n",
    "for i, row in pes_goool.iterrows():\n",
    "    x, y, bx, by = row.to_numpy()\n",
    "    x = length/2.0 + x\n",
    "    y = width/2.0 + y\n",
    "    bx = length/2.0 + bx\n",
    "    by = width/2.0 + by\n",
    "    plt.plot(x,y, marker = 'o', color = 'blue', alpha = 0.5)\n",
    "    plt.scatter(bx,by, marker = 'o', color = 'yellow', alpha = 0.5)\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "e6a54c79",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:50.821457Z",
     "iopub.status.busy": "2022-04-16T16:25:50.820745Z",
     "iopub.status.idle": "2022-04-16T16:25:50.826538Z",
     "shell.execute_reply": "2022-04-16T16:25:50.827336Z",
     "shell.execute_reply.started": "2022-04-16T15:36:54.045092Z"
    },
    "papermill": {
     "duration": 0.060135,
     "end_time": "2022-04-16T16:25:50.827591",
     "exception": false,
     "start_time": "2022-04-16T16:25:50.767456",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "shots['total_seconds'] = shots['minute'] * 60 + shots['second']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "cc90c9f7",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:50.936455Z",
     "iopub.status.busy": "2022-04-16T16:25:50.935698Z",
     "iopub.status.idle": "2022-04-16T16:25:50.955748Z",
     "shell.execute_reply": "2022-04-16T16:25:50.955130Z",
     "shell.execute_reply.started": "2022-04-16T15:35:03.265761Z"
    },
    "papermill": {
     "duration": 0.075881,
     "end_time": "2022-04-16T16:25:50.955924",
     "exception": false,
     "start_time": "2022-04-16T16:25:50.880043",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "id\n",
      "index\n",
      "period\n",
      "timestamp\n",
      "minute\n",
      "second\n",
      "possession\n",
      "duration\n",
      "related_events\n",
      "type_id\n",
      "type_name\n",
      "possession_team_id\n",
      "possession_team_name\n",
      "play_pattern_id\n",
      "play_pattern_name\n",
      "team_id\n",
      "team_name\n",
      "location\n",
      "player_id\n",
      "player_name\n",
      "position_id\n",
      "position_name\n",
      "pass_recipient_id\n",
      "pass_recipient_name\n",
      "pass_length\n",
      "pass_angle\n",
      "pass_height_id\n",
      "pass_height_name\n",
      "pass_end_location\n",
      "pass_type_id\n",
      "pass_type_name\n",
      "pass_body_part_id\n",
      "pass_body_part_name\n",
      "carry_end_location\n",
      "under_pressure\n",
      "counterpress\n",
      "pass_outcome_id\n",
      "pass_outcome_name\n",
      "ball_receipt_outcome_id\n",
      "ball_receipt_outcome_name\n",
      "duel_type_id\n",
      "duel_type_name\n",
      "pass_aerial_won\n",
      "duel_outcome_id\n",
      "duel_outcome_name\n",
      "dribble_outcome_id\n",
      "dribble_outcome_name\n",
      "pass_switch\n",
      "pass_cross\n",
      "interception_outcome_id\n",
      "interception_outcome_name\n",
      "off_camera\n",
      "clearance_head\n",
      "clearance_body_part_id\n",
      "clearance_body_part_name\n",
      "clearance_aerial_won\n",
      "out\n",
      "foul_committed_advantage\n",
      "foul_won_advantage\n",
      "pass_assisted_shot_id\n",
      "pass_shot_assist\n",
      "shot_statsbomb_xg\n",
      "shot_end_location\n",
      "shot_key_pass_id\n",
      "shot_outcome_id\n",
      "shot_outcome_name\n",
      "shot_type_id\n",
      "shot_type_name\n",
      "shot_body_part_id\n",
      "shot_body_part_name\n",
      "shot_technique_id\n",
      "shot_technique_name\n",
      "shot_first_time\n",
      "shot_freeze_frame\n",
      "goalkeeper_end_location\n",
      "goalkeeper_type_id\n",
      "goalkeeper_type_name\n",
      "goalkeeper_position_id\n",
      "goalkeeper_position_name\n",
      "tactics_formation\n",
      "tactics_lineup\n",
      "ball_recovery_recovery_failure\n",
      "goalkeeper_outcome_id\n",
      "goalkeeper_outcome_name\n",
      "goalkeeper_body_part_id\n",
      "goalkeeper_body_part_name\n",
      "goalkeeper_technique_id\n",
      "goalkeeper_technique_name\n",
      "shot_redirect\n",
      "foul_committed_type_id\n",
      "foul_committed_type_name\n",
      "clearance_right_foot\n",
      "pass_inswinging\n",
      "pass_technique_id\n",
      "pass_technique_name\n",
      "pass_cut_back\n",
      "pass_outswinging\n",
      "clearance_left_foot\n",
      "foul_won_defensive\n",
      "pass_through_ball\n",
      "pass_goal_assist\n",
      "substitution_outcome_id\n",
      "substitution_outcome_name\n",
      "substitution_replacement_id\n",
      "substitution_replacement_name\n",
      "foul_committed_card_id\n",
      "foul_committed_card_name\n",
      "dribble_nutmeg\n",
      "miscontrol_aerial_won\n",
      "shot_deflected\n",
      "block_deflection\n",
      "total_seconds\n"
     ]
    }
   ],
   "source": [
    "for col in shots.columns:\n",
    "    print(col)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "3be752be",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:51.066617Z",
     "iopub.status.busy": "2022-04-16T16:25:51.065854Z",
     "iopub.status.idle": "2022-04-16T16:25:51.069304Z",
     "shell.execute_reply": "2022-04-16T16:25:51.068715Z",
     "shell.execute_reply.started": "2022-04-16T15:50:15.466312Z"
    },
    "papermill": {
     "duration": 0.062404,
     "end_time": "2022-04-16T16:25:51.069456",
     "exception": false,
     "start_time": "2022-04-16T16:25:51.007052",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "shot_cols = [col for col in shots.columns if 'shot' in col]\n",
    "cols_ = ['timestamp', 'total_seconds', 'position_name', 'location', 'player_name']\n",
    "shotr = shots[cols_ + shot_cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "35ed606e",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:51.229996Z",
     "iopub.status.busy": "2022-04-16T16:25:51.224421Z",
     "iopub.status.idle": "2022-04-16T16:25:51.724628Z",
     "shell.execute_reply": "2022-04-16T16:25:51.725144Z",
     "shell.execute_reply.started": "2022-04-16T15:50:15.638570Z"
    },
    "papermill": {
     "duration": 0.603852,
     "end_time": "2022-04-16T16:25:51.725348",
     "exception": false,
     "start_time": "2022-04-16T16:25:51.121496",
     "status": "completed"
    },
    "tags": []
   },
   "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>timestamp</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>position_name</th>\n",
       "      <th>location</th>\n",
       "      <th>player_name</th>\n",
       "      <th>pass_assisted_shot_id</th>\n",
       "      <th>pass_shot_assist</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_end_location</th>\n",
       "      <th>shot_key_pass_id</th>\n",
       "      <th>...</th>\n",
       "      <th>shot_type_id</th>\n",
       "      <th>shot_type_name</th>\n",
       "      <th>shot_body_part_id</th>\n",
       "      <th>shot_body_part_name</th>\n",
       "      <th>shot_technique_id</th>\n",
       "      <th>shot_technique_name</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_freeze_frame</th>\n",
       "      <th>shot_redirect</th>\n",
       "      <th>shot_deflected</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>00:11:05.681</td>\n",
       "      <td>665</td>\n",
       "      <td>Center Forward</td>\n",
       "      <td>[115.6, 43.6]</td>\n",
       "      <td>Andrea Belotti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.313013</td>\n",
       "      <td>[120.0, 46.7, 1.1]</td>\n",
       "      <td>7d5f132d-f953-4cbb-8794-5fdaed616253</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>95.0</td>\n",
       "      <td>Volley</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [112.1, 48.6], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>00:14:14.318</td>\n",
       "      <td>854</td>\n",
       "      <td>Left Back</td>\n",
       "      <td>[91.2, 26.2]</td>\n",
       "      <td>Emerson Palmieri dos Santos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.014014</td>\n",
       "      <td>[117.3, 39.7, 0.5]</td>\n",
       "      <td>7c5870aa-e246-41ee-9b53-a1e8d14ecb37</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [86.6, 30.6], 'player': {'id': 3...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>00:16:20.148</td>\n",
       "      <td>980</td>\n",
       "      <td>Right Back</td>\n",
       "      <td>[97.3, 51.8]</td>\n",
       "      <td>Rafael Tolói</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.016376</td>\n",
       "      <td>[105.4, 40.8]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>95.0</td>\n",
       "      <td>Volley</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [97.3, 33.0], 'player': {'id': 2...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>00:16:20.567</td>\n",
       "      <td>980</td>\n",
       "      <td>Right Center Midfield</td>\n",
       "      <td>[105.7, 40.9]</td>\n",
       "      <td>Matteo Pessina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.198156</td>\n",
       "      <td>[116.0, 42.2, 0.5]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>91.0</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [111.2, 43.8], 'player': {'id': ...</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>00:23:40.866</td>\n",
       "      <td>1420</td>\n",
       "      <td>Center Forward</td>\n",
       "      <td>[112.6, 51.6]</td>\n",
       "      <td>Andrea Belotti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.232000</td>\n",
       "      <td>[120.0, 26.1, 0.1]</td>\n",
       "      <td>1b06ad71-9c5d-4f9a-b80c-65c490d96ebd</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [98.9, 39.7], 'player': {'id': 2...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>00:26:21.756</td>\n",
       "      <td>1581</td>\n",
       "      <td>Left Center Back</td>\n",
       "      <td>[110.7, 34.4]</td>\n",
       "      <td>Chris Gunter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.065273</td>\n",
       "      <td>[120.0, 35.6, 2.9]</td>\n",
       "      <td>6870c73b-1bba-48b8-bd54-b12ceb0829d9</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>37.0</td>\n",
       "      <td>Head</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [114.2, 45.0], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1074</th>\n",
       "      <td>00:27:07.140</td>\n",
       "      <td>1627</td>\n",
       "      <td>Left Center Midfield</td>\n",
       "      <td>[103.3, 24.9]</td>\n",
       "      <td>Marco Verratti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.036475</td>\n",
       "      <td>[120.0, 54.9, 2.4]</td>\n",
       "      <td>1321cec4-bea0-4ba0-b229-76c9082b6cea</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [107.7, 44.3], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1151</th>\n",
       "      <td>00:28:52.456</td>\n",
       "      <td>1732</td>\n",
       "      <td>Right Wing</td>\n",
       "      <td>[115.9, 50.9]</td>\n",
       "      <td>Federico Chiesa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.089812</td>\n",
       "      <td>[118.3, 40.0]</td>\n",
       "      <td>b34ab63e-cf05-4927-b03d-3098887e3525</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>91.0</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [116.0, 44.8], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1284</th>\n",
       "      <td>00:33:47.020</td>\n",
       "      <td>2027</td>\n",
       "      <td>Right Center Back</td>\n",
       "      <td>[108.2, 29.7]</td>\n",
       "      <td>Joe Rodon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.017186</td>\n",
       "      <td>[116.6, 37.4, 0.7]</td>\n",
       "      <td>479b5b58-82f4-4106-8481-67f7711b4bf4</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>37.0</td>\n",
       "      <td>Head</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [109.4, 31.1], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1402</th>\n",
       "      <td>00:36:33.566</td>\n",
       "      <td>2193</td>\n",
       "      <td>Left Wing</td>\n",
       "      <td>[96.1, 29.6]</td>\n",
       "      <td>Federico Bernardeschi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.024330</td>\n",
       "      <td>[99.5, 31.0]</td>\n",
       "      <td>41bb5e3c-7aad-4d67-9a8a-bf2ef9d1ac96</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [87.3, 36.1], 'player': {'id': 3...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1430</th>\n",
       "      <td>00:38:15.520</td>\n",
       "      <td>2295</td>\n",
       "      <td>Right Center Midfield</td>\n",
       "      <td>[109.4, 45.1]</td>\n",
       "      <td>Matteo Pessina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.112976</td>\n",
       "      <td>[120.0, 36.5, 0.5]</td>\n",
       "      <td>fe1d3434-0e23-4e93-aa25-c6e74ac9721b</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>95.0</td>\n",
       "      <td>Volley</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [110.9, 39.4], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1534</th>\n",
       "      <td>00:41:21.131</td>\n",
       "      <td>2481</td>\n",
       "      <td>Right Center Midfield</td>\n",
       "      <td>[109.7, 36.2]</td>\n",
       "      <td>Matteo Pessina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.245341</td>\n",
       "      <td>[112.3, 37.7]</td>\n",
       "      <td>dde73380-18fc-47ed-a913-79a628dd4fab</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>91.0</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [107.2, 26.9], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1944</th>\n",
       "      <td>00:07:08.954</td>\n",
       "      <td>3128</td>\n",
       "      <td>Left Wing</td>\n",
       "      <td>[90.4, 44.8]</td>\n",
       "      <td>Federico Bernardeschi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.036614</td>\n",
       "      <td>[120.0, 36.0, 0.4]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Free Kick</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [101.4, 38.5], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2042</th>\n",
       "      <td>00:09:13.194</td>\n",
       "      <td>3253</td>\n",
       "      <td>Center Forward</td>\n",
       "      <td>[111.7, 58.8]</td>\n",
       "      <td>Andrea Belotti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.023563</td>\n",
       "      <td>[120.0, 44.9, 5.6]</td>\n",
       "      <td>04d311ce-67c7-4d48-80cb-cc07043135ad</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>91.0</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [107.7, 59.5], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2095</th>\n",
       "      <td>00:12:12.368</td>\n",
       "      <td>3432</td>\n",
       "      <td>Right Wing</td>\n",
       "      <td>[103.6, 56.4]</td>\n",
       "      <td>Federico Chiesa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.038120</td>\n",
       "      <td>[116.8, 42.7, 0.2]</td>\n",
       "      <td>5262866b-c690-4ec4-bcd5-31508d4f912e</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [96.7, 49.4], 'player': {'id': 7...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2310</th>\n",
       "      <td>00:19:09.004</td>\n",
       "      <td>3849</td>\n",
       "      <td>Center Forward</td>\n",
       "      <td>[112.6, 48.3]</td>\n",
       "      <td>Andrea Belotti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.084685</td>\n",
       "      <td>[117.7, 43.7, 0.4]</td>\n",
       "      <td>308d2357-cc7c-44f0-9bd3-cdda72ccf6f2</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [103.3, 32.6], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2315</th>\n",
       "      <td>00:20:19.661</td>\n",
       "      <td>3919</td>\n",
       "      <td>Right Back</td>\n",
       "      <td>[116.2, 51.5]</td>\n",
       "      <td>Rafael Tolói</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.032864</td>\n",
       "      <td>[120.0, 46.2, 1.4]</td>\n",
       "      <td>2081a0ef-46ba-47ee-b07c-e97f173d27af</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>37.0</td>\n",
       "      <td>Head</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Diving Header</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [118.1, 41.7], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2349</th>\n",
       "      <td>00:21:30.289</td>\n",
       "      <td>3990</td>\n",
       "      <td>Right Wing</td>\n",
       "      <td>[98.5, 56.7]</td>\n",
       "      <td>Federico Bernardeschi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.022030</td>\n",
       "      <td>[107.2, 40.4]</td>\n",
       "      <td>05181e91-c045-41a0-b7b8-4afed1300a5e</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [91.8, 36.3], 'player': {'id': 3...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2377</th>\n",
       "      <td>00:22:01.173</td>\n",
       "      <td>4021</td>\n",
       "      <td>Left Back</td>\n",
       "      <td>[109.6, 47.6]</td>\n",
       "      <td>Emerson Palmieri dos Santos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.173465</td>\n",
       "      <td>[110.3, 47.1]</td>\n",
       "      <td>4a7191c2-66c3-4a88-b7d0-af9ae0178d6f</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [117.5, 42.1], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2539</th>\n",
       "      <td>00:29:57.482</td>\n",
       "      <td>4497</td>\n",
       "      <td>Right Wing</td>\n",
       "      <td>[110.1, 45.7]</td>\n",
       "      <td>Gareth Frank Bale</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.378296</td>\n",
       "      <td>[120.0, 40.6, 6.7]</td>\n",
       "      <td>c1033b7d-cfce-4e47-8741-d4cb05f02f72</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>95.0</td>\n",
       "      <td>Volley</td>\n",
       "      <td>True</td>\n",
       "      <td>[{'location': [101.0, 37.7], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2800</th>\n",
       "      <td>00:37:26.575</td>\n",
       "      <td>4946</td>\n",
       "      <td>Right Wing</td>\n",
       "      <td>[113.8, 54.6]</td>\n",
       "      <td>Federico Chiesa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.030460</td>\n",
       "      <td>[114.4, 53.5]</td>\n",
       "      <td>44a9b9d5-431c-4aae-b59c-e349018477e5</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [104.8, 36.6], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2809</th>\n",
       "      <td>00:38:16.292</td>\n",
       "      <td>4996</td>\n",
       "      <td>Right Wing</td>\n",
       "      <td>[110.4, 24.4]</td>\n",
       "      <td>Federico Chiesa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.026152</td>\n",
       "      <td>[112.2, 26.8]</td>\n",
       "      <td>abb4280c-6307-4c6f-86a5-a17031086553</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [113.7, 35.3], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2919</th>\n",
       "      <td>00:42:49.026</td>\n",
       "      <td>5269</td>\n",
       "      <td>Left Center Midfield</td>\n",
       "      <td>[95.9, 32.3]</td>\n",
       "      <td>Marco Verratti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.029100</td>\n",
       "      <td>[97.4, 32.9]</td>\n",
       "      <td>7ab08576-e638-4280-a0ce-38e02a20b8ae</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [99.8, 18.2], 'player': {'id': 4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2931</th>\n",
       "      <td>00:42:57.487</td>\n",
       "      <td>5277</td>\n",
       "      <td>Left Wing</td>\n",
       "      <td>[101.5, 32.5]</td>\n",
       "      <td>Giacomo Raspadori</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.084696</td>\n",
       "      <td>[102.0, 32.7]</td>\n",
       "      <td>7da01164-ea19-4031-bd93-6b12ba5579e4</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [103.8, 49.2], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2937</th>\n",
       "      <td>00:42:59.785</td>\n",
       "      <td>5279</td>\n",
       "      <td>Center Forward</td>\n",
       "      <td>[101.9, 42.2]</td>\n",
       "      <td>Andrea Belotti</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.042234</td>\n",
       "      <td>[117.5, 42.2, 1.3]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [103.2, 51.4], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3053</th>\n",
       "      <td>00:46:01.386</td>\n",
       "      <td>5461</td>\n",
       "      <td>Center Defensive Midfield</td>\n",
       "      <td>[93.7, 53.3]</td>\n",
       "      <td>Bryan Cristante</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.018741</td>\n",
       "      <td>[114.7, 40.3, 0.2]</td>\n",
       "      <td>a4a5c9b0-3448-466c-a191-b8168b70db22</td>\n",
       "      <td>...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'location': [116.9, 41.4], 'player': {'id': ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>26 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         timestamp  total_seconds              position_name       location  \\\n",
       "443   00:11:05.681            665             Center Forward  [115.6, 43.6]   \n",
       "540   00:14:14.318            854                  Left Back   [91.2, 26.2]   \n",
       "647   00:16:20.148            980                 Right Back   [97.3, 51.8]   \n",
       "649   00:16:20.567            980      Right Center Midfield  [105.7, 40.9]   \n",
       "955   00:23:40.866           1420             Center Forward  [112.6, 51.6]   \n",
       "1049  00:26:21.756           1581           Left Center Back  [110.7, 34.4]   \n",
       "1074  00:27:07.140           1627       Left Center Midfield  [103.3, 24.9]   \n",
       "1151  00:28:52.456           1732                 Right Wing  [115.9, 50.9]   \n",
       "1284  00:33:47.020           2027          Right Center Back  [108.2, 29.7]   \n",
       "1402  00:36:33.566           2193                  Left Wing   [96.1, 29.6]   \n",
       "1430  00:38:15.520           2295      Right Center Midfield  [109.4, 45.1]   \n",
       "1534  00:41:21.131           2481      Right Center Midfield  [109.7, 36.2]   \n",
       "1944  00:07:08.954           3128                  Left Wing   [90.4, 44.8]   \n",
       "2042  00:09:13.194           3253             Center Forward  [111.7, 58.8]   \n",
       "2095  00:12:12.368           3432                 Right Wing  [103.6, 56.4]   \n",
       "2310  00:19:09.004           3849             Center Forward  [112.6, 48.3]   \n",
       "2315  00:20:19.661           3919                 Right Back  [116.2, 51.5]   \n",
       "2349  00:21:30.289           3990                 Right Wing   [98.5, 56.7]   \n",
       "2377  00:22:01.173           4021                  Left Back  [109.6, 47.6]   \n",
       "2539  00:29:57.482           4497                 Right Wing  [110.1, 45.7]   \n",
       "2800  00:37:26.575           4946                 Right Wing  [113.8, 54.6]   \n",
       "2809  00:38:16.292           4996                 Right Wing  [110.4, 24.4]   \n",
       "2919  00:42:49.026           5269       Left Center Midfield   [95.9, 32.3]   \n",
       "2931  00:42:57.487           5277                  Left Wing  [101.5, 32.5]   \n",
       "2937  00:42:59.785           5279             Center Forward  [101.9, 42.2]   \n",
       "3053  00:46:01.386           5461  Center Defensive Midfield   [93.7, 53.3]   \n",
       "\n",
       "                      player_name pass_assisted_shot_id pass_shot_assist  \\\n",
       "443                Andrea Belotti                   NaN              NaN   \n",
       "540   Emerson Palmieri dos Santos                   NaN              NaN   \n",
       "647                  Rafael Tolói                   NaN              NaN   \n",
       "649                Matteo Pessina                   NaN              NaN   \n",
       "955                Andrea Belotti                   NaN              NaN   \n",
       "1049                 Chris Gunter                   NaN              NaN   \n",
       "1074               Marco Verratti                   NaN              NaN   \n",
       "1151              Federico Chiesa                   NaN              NaN   \n",
       "1284                    Joe Rodon                   NaN              NaN   \n",
       "1402        Federico Bernardeschi                   NaN              NaN   \n",
       "1430               Matteo Pessina                   NaN              NaN   \n",
       "1534               Matteo Pessina                   NaN              NaN   \n",
       "1944        Federico Bernardeschi                   NaN              NaN   \n",
       "2042               Andrea Belotti                   NaN              NaN   \n",
       "2095              Federico Chiesa                   NaN              NaN   \n",
       "2310               Andrea Belotti                   NaN              NaN   \n",
       "2315                 Rafael Tolói                   NaN              NaN   \n",
       "2349        Federico Bernardeschi                   NaN              NaN   \n",
       "2377  Emerson Palmieri dos Santos                   NaN              NaN   \n",
       "2539            Gareth Frank Bale                   NaN              NaN   \n",
       "2800              Federico Chiesa                   NaN              NaN   \n",
       "2809              Federico Chiesa                   NaN              NaN   \n",
       "2919               Marco Verratti                   NaN              NaN   \n",
       "2931            Giacomo Raspadori                   NaN              NaN   \n",
       "2937               Andrea Belotti                   NaN              NaN   \n",
       "3053              Bryan Cristante                   NaN              NaN   \n",
       "\n",
       "      shot_statsbomb_xg   shot_end_location  \\\n",
       "443            0.313013  [120.0, 46.7, 1.1]   \n",
       "540            0.014014  [117.3, 39.7, 0.5]   \n",
       "647            0.016376       [105.4, 40.8]   \n",
       "649            0.198156  [116.0, 42.2, 0.5]   \n",
       "955            0.232000  [120.0, 26.1, 0.1]   \n",
       "1049           0.065273  [120.0, 35.6, 2.9]   \n",
       "1074           0.036475  [120.0, 54.9, 2.4]   \n",
       "1151           0.089812       [118.3, 40.0]   \n",
       "1284           0.017186  [116.6, 37.4, 0.7]   \n",
       "1402           0.024330        [99.5, 31.0]   \n",
       "1430           0.112976  [120.0, 36.5, 0.5]   \n",
       "1534           0.245341       [112.3, 37.7]   \n",
       "1944           0.036614  [120.0, 36.0, 0.4]   \n",
       "2042           0.023563  [120.0, 44.9, 5.6]   \n",
       "2095           0.038120  [116.8, 42.7, 0.2]   \n",
       "2310           0.084685  [117.7, 43.7, 0.4]   \n",
       "2315           0.032864  [120.0, 46.2, 1.4]   \n",
       "2349           0.022030       [107.2, 40.4]   \n",
       "2377           0.173465       [110.3, 47.1]   \n",
       "2539           0.378296  [120.0, 40.6, 6.7]   \n",
       "2800           0.030460       [114.4, 53.5]   \n",
       "2809           0.026152       [112.2, 26.8]   \n",
       "2919           0.029100        [97.4, 32.9]   \n",
       "2931           0.084696       [102.0, 32.7]   \n",
       "2937           0.042234  [117.5, 42.2, 1.3]   \n",
       "3053           0.018741  [114.7, 40.3, 0.2]   \n",
       "\n",
       "                          shot_key_pass_id  ...  shot_type_id shot_type_name  \\\n",
       "443   7d5f132d-f953-4cbb-8794-5fdaed616253  ...          87.0      Open Play   \n",
       "540   7c5870aa-e246-41ee-9b53-a1e8d14ecb37  ...          87.0      Open Play   \n",
       "647                                    NaN  ...          87.0      Open Play   \n",
       "649                                    NaN  ...          87.0      Open Play   \n",
       "955   1b06ad71-9c5d-4f9a-b80c-65c490d96ebd  ...          87.0      Open Play   \n",
       "1049  6870c73b-1bba-48b8-bd54-b12ceb0829d9  ...          87.0      Open Play   \n",
       "1074  1321cec4-bea0-4ba0-b229-76c9082b6cea  ...          87.0      Open Play   \n",
       "1151  b34ab63e-cf05-4927-b03d-3098887e3525  ...          87.0      Open Play   \n",
       "1284  479b5b58-82f4-4106-8481-67f7711b4bf4  ...          87.0      Open Play   \n",
       "1402  41bb5e3c-7aad-4d67-9a8a-bf2ef9d1ac96  ...          87.0      Open Play   \n",
       "1430  fe1d3434-0e23-4e93-aa25-c6e74ac9721b  ...          87.0      Open Play   \n",
       "1534  dde73380-18fc-47ed-a913-79a628dd4fab  ...          87.0      Open Play   \n",
       "1944                                   NaN  ...          62.0      Free Kick   \n",
       "2042  04d311ce-67c7-4d48-80cb-cc07043135ad  ...          87.0      Open Play   \n",
       "2095  5262866b-c690-4ec4-bcd5-31508d4f912e  ...          87.0      Open Play   \n",
       "2310  308d2357-cc7c-44f0-9bd3-cdda72ccf6f2  ...          87.0      Open Play   \n",
       "2315  2081a0ef-46ba-47ee-b07c-e97f173d27af  ...          87.0      Open Play   \n",
       "2349  05181e91-c045-41a0-b7b8-4afed1300a5e  ...          87.0      Open Play   \n",
       "2377  4a7191c2-66c3-4a88-b7d0-af9ae0178d6f  ...          87.0      Open Play   \n",
       "2539  c1033b7d-cfce-4e47-8741-d4cb05f02f72  ...          87.0      Open Play   \n",
       "2800  44a9b9d5-431c-4aae-b59c-e349018477e5  ...          87.0      Open Play   \n",
       "2809  abb4280c-6307-4c6f-86a5-a17031086553  ...          87.0      Open Play   \n",
       "2919  7ab08576-e638-4280-a0ce-38e02a20b8ae  ...          87.0      Open Play   \n",
       "2931  7da01164-ea19-4031-bd93-6b12ba5579e4  ...          87.0      Open Play   \n",
       "2937                                   NaN  ...          87.0      Open Play   \n",
       "3053  a4a5c9b0-3448-466c-a191-b8168b70db22  ...          87.0      Open Play   \n",
       "\n",
       "      shot_body_part_id shot_body_part_name  shot_technique_id  \\\n",
       "443                40.0          Right Foot               95.0   \n",
       "540                38.0           Left Foot               93.0   \n",
       "647                40.0          Right Foot               95.0   \n",
       "649                40.0          Right Foot               91.0   \n",
       "955                40.0          Right Foot               93.0   \n",
       "1049               37.0                Head               93.0   \n",
       "1074               40.0          Right Foot               93.0   \n",
       "1151               40.0          Right Foot               91.0   \n",
       "1284               37.0                Head               93.0   \n",
       "1402               38.0           Left Foot               93.0   \n",
       "1430               40.0          Right Foot               95.0   \n",
       "1534               38.0           Left Foot               91.0   \n",
       "1944               38.0           Left Foot               93.0   \n",
       "2042               40.0          Right Foot               91.0   \n",
       "2095               38.0           Left Foot               93.0   \n",
       "2310               40.0          Right Foot               93.0   \n",
       "2315               37.0                Head               90.0   \n",
       "2349               38.0           Left Foot               93.0   \n",
       "2377               38.0           Left Foot               93.0   \n",
       "2539               38.0           Left Foot               95.0   \n",
       "2800               40.0          Right Foot               93.0   \n",
       "2809               38.0           Left Foot               93.0   \n",
       "2919               40.0          Right Foot               93.0   \n",
       "2931               40.0          Right Foot               93.0   \n",
       "2937               40.0          Right Foot               93.0   \n",
       "3053               40.0          Right Foot               93.0   \n",
       "\n",
       "     shot_technique_name  shot_first_time  \\\n",
       "443               Volley             True   \n",
       "540               Normal              NaN   \n",
       "647               Volley             True   \n",
       "649          Half Volley              NaN   \n",
       "955               Normal             True   \n",
       "1049              Normal              NaN   \n",
       "1074              Normal              NaN   \n",
       "1151         Half Volley              NaN   \n",
       "1284              Normal              NaN   \n",
       "1402              Normal              NaN   \n",
       "1430              Volley             True   \n",
       "1534         Half Volley             True   \n",
       "1944              Normal              NaN   \n",
       "2042         Half Volley             True   \n",
       "2095              Normal              NaN   \n",
       "2310              Normal             True   \n",
       "2315       Diving Header              NaN   \n",
       "2349              Normal              NaN   \n",
       "2377              Normal              NaN   \n",
       "2539              Volley             True   \n",
       "2800              Normal              NaN   \n",
       "2809              Normal              NaN   \n",
       "2919              Normal              NaN   \n",
       "2931              Normal              NaN   \n",
       "2937              Normal              NaN   \n",
       "3053              Normal              NaN   \n",
       "\n",
       "                                      shot_freeze_frame shot_redirect  \\\n",
       "443   [{'location': [112.1, 48.6], 'player': {'id': ...           NaN   \n",
       "540   [{'location': [86.6, 30.6], 'player': {'id': 3...           NaN   \n",
       "647   [{'location': [97.3, 33.0], 'player': {'id': 2...           NaN   \n",
       "649   [{'location': [111.2, 43.8], 'player': {'id': ...          True   \n",
       "955   [{'location': [98.9, 39.7], 'player': {'id': 2...           NaN   \n",
       "1049  [{'location': [114.2, 45.0], 'player': {'id': ...           NaN   \n",
       "1074  [{'location': [107.7, 44.3], 'player': {'id': ...           NaN   \n",
       "1151  [{'location': [116.0, 44.8], 'player': {'id': ...           NaN   \n",
       "1284  [{'location': [109.4, 31.1], 'player': {'id': ...           NaN   \n",
       "1402  [{'location': [87.3, 36.1], 'player': {'id': 3...           NaN   \n",
       "1430  [{'location': [110.9, 39.4], 'player': {'id': ...           NaN   \n",
       "1534  [{'location': [107.2, 26.9], 'player': {'id': ...           NaN   \n",
       "1944  [{'location': [101.4, 38.5], 'player': {'id': ...           NaN   \n",
       "2042  [{'location': [107.7, 59.5], 'player': {'id': ...           NaN   \n",
       "2095  [{'location': [96.7, 49.4], 'player': {'id': 7...           NaN   \n",
       "2310  [{'location': [103.3, 32.6], 'player': {'id': ...           NaN   \n",
       "2315  [{'location': [118.1, 41.7], 'player': {'id': ...           NaN   \n",
       "2349  [{'location': [91.8, 36.3], 'player': {'id': 3...           NaN   \n",
       "2377  [{'location': [117.5, 42.1], 'player': {'id': ...           NaN   \n",
       "2539  [{'location': [101.0, 37.7], 'player': {'id': ...           NaN   \n",
       "2800  [{'location': [104.8, 36.6], 'player': {'id': ...           NaN   \n",
       "2809  [{'location': [113.7, 35.3], 'player': {'id': ...           NaN   \n",
       "2919  [{'location': [99.8, 18.2], 'player': {'id': 4...           NaN   \n",
       "2931  [{'location': [103.8, 49.2], 'player': {'id': ...           NaN   \n",
       "2937  [{'location': [103.2, 51.4], 'player': {'id': ...           NaN   \n",
       "3053  [{'location': [116.9, 41.4], 'player': {'id': ...           NaN   \n",
       "\n",
       "     shot_deflected  \n",
       "443             NaN  \n",
       "540             NaN  \n",
       "647             NaN  \n",
       "649             NaN  \n",
       "955             NaN  \n",
       "1049            NaN  \n",
       "1074            NaN  \n",
       "1151            NaN  \n",
       "1284            NaN  \n",
       "1402            NaN  \n",
       "1430            NaN  \n",
       "1534            NaN  \n",
       "1944            NaN  \n",
       "2042            NaN  \n",
       "2095            NaN  \n",
       "2310            NaN  \n",
       "2315            NaN  \n",
       "2349            NaN  \n",
       "2377            NaN  \n",
       "2539            NaN  \n",
       "2800            NaN  \n",
       "2809            NaN  \n",
       "2919            NaN  \n",
       "2931            NaN  \n",
       "2937            NaN  \n",
       "3053           True  \n",
       "\n",
       "[26 rows x 22 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shotr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "4f74c586",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:51.834186Z",
     "iopub.status.busy": "2022-04-16T16:25:51.832707Z",
     "iopub.status.idle": "2022-04-16T16:25:51.838803Z",
     "shell.execute_reply": "2022-04-16T16:25:51.839438Z",
     "shell.execute_reply.started": "2022-04-16T15:30:00.861793Z"
    },
    "papermill": {
     "duration": 0.061776,
     "end_time": "2022-04-16T16:25:51.839619",
     "exception": false,
     "start_time": "2022-04-16T16:25:51.777843",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "665.681"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.Timedelta(shots['timestamp'].iloc[0]).total_seconds()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "98ac9508",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:51.953529Z",
     "iopub.status.busy": "2022-04-16T16:25:51.948962Z",
     "iopub.status.idle": "2022-04-16T16:25:51.955983Z",
     "shell.execute_reply": "2022-04-16T16:25:51.956503Z",
     "shell.execute_reply.started": "2022-04-16T15:16:56.611359Z"
    },
    "papermill": {
     "duration": 0.064192,
     "end_time": "2022-04-16T16:25:51.956684",
     "exception": false,
     "start_time": "2022-04-16T16:25:51.892492",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        2021-06-20 16:00:41.134\n",
       "1        2021-06-20 16:00:41.174\n",
       "2        2021-06-20 16:00:41.214\n",
       "3        2021-06-20 16:00:41.254\n",
       "4        2021-06-20 16:00:41.294\n",
       "                   ...          \n",
       "139525   2021-06-20 17:50:34.134\n",
       "139526   2021-06-20 17:50:34.174\n",
       "139527   2021-06-20 17:50:34.214\n",
       "139528   2021-06-20 17:50:34.254\n",
       "139529   2021-06-20 17:50:34.294\n",
       "Name: time, Length: 139530, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['time']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "e0b44025",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-04-16T16:25:52.067604Z",
     "iopub.status.busy": "2022-04-16T16:25:52.066836Z",
     "iopub.status.idle": "2022-04-16T16:25:52.070691Z",
     "shell.execute_reply": "2022-04-16T16:25:52.071205Z",
     "shell.execute_reply.started": "2022-04-16T15:16:56.627988Z"
    },
    "papermill": {
     "duration": 0.061299,
     "end_time": "2022-04-16T16:25:52.071427",
     "exception": false,
     "start_time": "2022-04-16T16:25:52.010128",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "shots = shots.reset_index(drop = True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.12"
  },
  "papermill": {
   "default_parameters": {},
   "duration": 34.149658,
   "end_time": "2022-04-16T16:25:52.937089",
   "environment_variables": {},
   "exception": null,
   "input_path": "__notebook__.ipynb",
   "output_path": "__notebook__.ipynb",
   "parameters": {},
   "start_time": "2022-04-16T16:25:18.787431",
   "version": "2.3.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}