{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
""
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Physical Data Engineering\n",
"##### Notebook to engineer physical data data using [pandas](http://pandas.pydata.org/).\n",
"\n",
"### By [Edd Webster](https://www.twitter.com/eddwebster)\n",
"Notebook first written: 20/01/2022
\n",
"Notebook last updated: 01/02/2022\n",
"\n",
"\n",
"\n",
"Click [here](#section4) to jump straight into the Data Engineering section and skip the [Notebook Brief](#section2) and [Data Sources](#section3) sections."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"___\n",
"\n",
"\n",
"## Introduction\n",
"This notebook engineers a an anonymised dataset of physical data provided by [Watford F.C](https://www.watfordfc.com/), using [pandas](http://pandas.pydata.org/) for data manipulation through DataFrames.\n",
"\n",
"For more information about this notebook and the author, I am available through all the following channels:\n",
"* [eddwebster.com](https://www.eddwebster.com/);\n",
"* edd.j.webster@gmail.com;\n",
"* [@eddwebster](https://www.twitter.com/eddwebster);\n",
"* [linkedin.com/in/eddwebster](https://www.linkedin.com/in/eddwebster/);\n",
"* [github/eddwebster](https://github.com/eddwebster/); and\n",
"* [public.tableau.com/profile/edd.webster](https://public.tableau.com/profile/edd.webster).\n",
"\n",
"A static version of this notebook can be found [here](https://nbviewer.org/github/eddwebster/watford/blob/main/notebooks/2_data_engineering/Opta%20Data%20Engineering.ipynb). This notebook has an accompanying [`watford`](https://github.com/eddwebster/watford) GitHub repository and for my full repository of football analysis, see my [`football_analysis`](https://github.com/eddwebster/football_analytics) GitHub repository."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"___\n",
"\n",
"## Notebook Contents\n",
"1. [Notebook Dependencies](#section1)
\n",
"2. [Notebook Brief](#section2)
\n",
"3. [Data Sources](#section3)
\n",
" 1. [Introduction](#section3.1)
\n",
" 2. [Read in the Datasets](#section3.2)
\n",
" 3. [Initial Data Handling](#section3.3)
\n",
"4. [Data Engineering](#section4)
\n",
" 1. [Assign Raw DataFrame to Engineered DataFrame](#section4.1)
\n",
"5. [Summary](#section5)
\n",
"6. [Next Steps](#section6)
\n",
"7. [References](#section7)
"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"___\n",
"\n",
"\n",
"\n",
"## 1. Notebook Dependencies\n",
"\n",
"This notebook was written using [Python 3](https://docs.python.org/3.7/) and requires the following libraries:\n",
"* [`Jupyter notebooks`](https://jupyter.org/) for this notebook environment with which this project is presented;\n",
"* [`NumPy`](http://www.numpy.org/) for multidimensional array computing; and\n",
"* [`pandas`](http://pandas.pydata.org/) for data analysis and manipulation.\n",
"\n",
"All packages used for this notebook can be obtained by downloading and installing the [Conda](https://anaconda.org/anaconda/conda) distribution, available on all platforms (Windows, Linux and Mac OSX). Step-by-step guides on how to install Anaconda can be found for Windows [here](https://medium.com/@GalarnykMichael/install-python-on-windows-anaconda-c63c7c3d1444) and Mac [here](https://medium.com/@GalarnykMichael/install-python-on-mac-anaconda-ccd9f2014072), as well as in the Anaconda documentation itself [here](https://docs.anaconda.com/anaconda/install/)."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Import Libraries and Modules"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Setup Complete\n"
]
}
],
"source": [
"# Python ≥3.5 (ideally)\n",
"import platform\n",
"import sys, getopt\n",
"assert sys.version_info >= (3, 5)\n",
"import csv\n",
"\n",
"# Import Dependencies\n",
"%matplotlib inline\n",
"\n",
"# Math Operations\n",
"import numpy as np\n",
"from math import pi\n",
"\n",
"# Datetime\n",
"import datetime\n",
"from datetime import date\n",
"import time\n",
"\n",
"# Data Preprocessing\n",
"import pandas as pd\n",
"import pandas_profiling as pp\n",
"import os\n",
"import re\n",
"import chardet\n",
"import random\n",
"from io import BytesIO\n",
"from pathlib import Path\n",
"\n",
"# Reading Directories\n",
"import glob\n",
"import os\n",
"\n",
"# Working with JSON\n",
"import json\n",
"from pandas import json_normalize\n",
"\n",
"# Data Visualisation\n",
"import matplotlib as mpl\n",
"import matplotlib.pyplot as plt\n",
"import seaborn as sns\n",
"import missingno as msno\n",
"\n",
"# Requests and downloads\n",
"import tqdm\n",
"import requests\n",
"\n",
"# Display in Jupyter\n",
"from IPython.display import Image, YouTubeVideo\n",
"from IPython.core.display import HTML\n",
"\n",
"# Ignore Warnings\n",
"import warnings\n",
"warnings.filterwarnings(action=\"ignore\", message=\"^internal gelsd\")\n",
"\n",
"# Print message\n",
"print(\"Setup Complete\")"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"scrolled": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Python: 3.7.6\n",
"NumPy: 1.19.1\n",
"pandas: 1.1.3\n",
"matplotlib: 3.3.1\n"
]
}
],
"source": [
"# Python / module versions used here for reference\n",
"print('Python: {}'.format(platform.python_version()))\n",
"print('NumPy: {}'.format(np.__version__))\n",
"print('pandas: {}'.format(pd.__version__))\n",
"print('matplotlib: {}'.format(mpl.__version__))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Defined Filepaths"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"# Set up initial paths to subfolders\n",
"base_dir = os.path.join('..', '..')\n",
"data_dir = os.path.join(base_dir, 'data')\n",
"data_dir_physical = os.path.join(base_dir, 'data', 'physical')\n",
"scripts_dir = os.path.join(base_dir, 'scripts')\n",
"models_dir = os.path.join(base_dir, 'models')\n",
"img_dir = os.path.join(base_dir, 'img')\n",
"fig_dir = os.path.join(base_dir, 'img', 'fig')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Notebook Settings"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"# Display all columns of displayed pandas DataFrames\n",
"pd.set_option('display.max_columns', None)\n",
"#pd.set_option('display.max_rows', None)\n",
"pd.options.mode.chained_assignment = None"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"---\n",
"\n",
"\n",
"\n",
"## 2. Notebook Brief\n",
"This notebook parses and engineers [Opta data](https://www.statsperform.com/opta/) by [Stats Perform](https://www.statsperform.com/) ... using [pandas](http://pandas.pydata.org/).\n",
"\n",
"\n",
"**Notebook Conventions**:
\n",
"* Variables that refer a `DataFrame` object are prefixed with `df_`.\n",
"* Variables that refer to a collection of `DataFrame` objects (e.g., a list, a set or a dict) are prefixed with `dfs_`."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"---\n",
"\n",
"\n",
"\n",
"## 3. Data Sources"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"\n",
"\n",
"### 3.1. Introduction\n",
"The physical data..."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"\n",
"\n",
"### 3.2. Import Data\n",
"These `CSV` file provided is read in as [pandas](https://pandas.pydata.org/) DataFrames."
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"[]\n"
]
}
],
"source": [
"# Show files in directory\n",
"print(glob.glob(os.path.join(data_dir_physical, 'raw', 'F7/*.csv')))"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"# Import CSV file as a pandas DataFrame\n",
"df_physical_raw = pd.read_csv(os.path.join(data_dir_physical, 'raw', 'Physical Output.csv'))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"\n",
"\n",
"### 3.3. Initial Data Handling\n",
"First check the quality of the dataset by looking first and last rows in pandas using the [`head()`](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.head.html) and [`tail()`](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.tail.html) methods."
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Match Date | \n",
" Match | \n",
" Home/Away | \n",
" Team | \n",
" Player Name | \n",
" Minutes Played | \n",
" Ball In Play Time | \n",
" Time In Possession | \n",
" Time Opponent In Possession | \n",
" Time In Uncontrolled Possession | \n",
" Time In Established Possession | \n",
" Total Distance | \n",
" Total Low Intensity Distance | \n",
" Total High Intensity Distance | \n",
" Stand Distance | \n",
" Walk Distance | \n",
" Jog Distance | \n",
" Run Distance | \n",
" High Speed Run Distance | \n",
" High Speed Distance - Player Average | \n",
" Sprint Distance | \n",
" Ball In Play Total Distance | \n",
" In Possession Total Distance | \n",
" Opponent In Possession Total Distance | \n",
" Uncontrolled Possession Total Distance | \n",
" Ball Out Of Play Total Distance | \n",
" Total Distance (m/min) | \n",
" Total Distance In Possession (m/min) | \n",
" Total Distance Opponent In Possession (m/min) | \n",
" Total Distance Uncontrolled Possession (m/min) | \n",
" Ball In Play HI Distance | \n",
" In Possession HI Distance | \n",
" Opponent In Possession HI Distance | \n",
" Uncontrolled Possession HI Distance | \n",
" Ball Out Of Play HI Distance | \n",
" HI Distance (m/min) | \n",
" HI Distance In Possession (m/min) | \n",
" HI Distance Opponent In Possession (m/min) | \n",
" HI Distance Uncontrolled Possession (m/min) | \n",
" Ball In Play Sprint Distance | \n",
" In Possession Sprint Distance | \n",
" Opponent In Possession Sprint Distance | \n",
" Uncontrolled Possession Sprint Distance | \n",
" Ball Out Of Play Sprint Distance | \n",
" Sprint Distance (m/min) | \n",
" Sprint Distance In Possession (m/min) | \n",
" Sprint Distance Opponent In Possession (m/min) | \n",
" Sprint Distance Uncontrolled Possession (m/min) | \n",
" HI Events | \n",
" Sprint Events | \n",
" HS Run Events | \n",
" Maximum Speed (km/h) | \n",
" Deceleration Very High Events | \n",
" Deceleration High Events | \n",
" Deceleration Medium Events | \n",
" Deceleration Low Events | \n",
" Acceleration Low Events | \n",
" Acceleration Medium Events | \n",
" Acceleration High Events | \n",
" Acceleration Very High Events | \n",
" 1-5TD | \n",
" 6-10TD | \n",
" 11-15TD | \n",
" 16-20TD | \n",
" 21-25TD | \n",
" 26-30TD | \n",
" 31-35TD | \n",
" 36-40TD | \n",
" 41-45TD | \n",
" 45+TD | \n",
" 46-50TD | \n",
" 51-55TD | \n",
" 56-60TD | \n",
" 61-65TD | \n",
" 66-70TD | \n",
" 71-75TD | \n",
" 76-80TD | \n",
" 81-85TD | \n",
" 86-90TD | \n",
" 90+TD | \n",
" 1-5HID | \n",
" 6-10HID | \n",
" 11-15HID | \n",
" 16-20HID | \n",
" 21-25HID | \n",
" 26-30HID | \n",
" 31-35HID | \n",
" 36-40HID | \n",
" 41-45HID | \n",
" 45+HID | \n",
" 46-50HID | \n",
" 51-55HID | \n",
" 56-60HID | \n",
" 61-65HID | \n",
" 66-70HID | \n",
" 71-75HID | \n",
" 76-80HID | \n",
" 81-85HID | \n",
" 86-90HID | \n",
" 90+HID | \n",
"
\n",
" \n",
" \n",
" \n",
" | 0 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 11 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 10274.7 | \n",
" 9537.4 | \n",
" 737.3 | \n",
" 55.7 | \n",
" 3852.9 | \n",
" 3818.9 | \n",
" 1809.8 | \n",
" 639.4 | \n",
" 550.388462 | \n",
" 97.9 | \n",
" 6499.6 | \n",
" 2863.4 | \n",
" 3374.8 | \n",
" 261.4 | \n",
" 3775.1 | \n",
" 105.9 | \n",
" 135.1 | \n",
" 159.9 | \n",
" 124.5 | \n",
" 705.3 | \n",
" 292.0 | \n",
" 410.6 | \n",
" 2.7 | \n",
" 32.0 | \n",
" 7.6 | \n",
" 13.8 | \n",
" 19.5 | \n",
" 1.3 | \n",
" 88.3 | \n",
" 47.4 | \n",
" 40.9 | \n",
" 0.0 | \n",
" 9.7 | \n",
" 1.0 | \n",
" 2.2 | \n",
" 1.9 | \n",
" NaN | \n",
" 40 | \n",
" 7 | \n",
" 41 | \n",
" 29.7 | \n",
" 2 | \n",
" 19 | \n",
" 70 | \n",
" 220 | \n",
" 236 | \n",
" 69 | \n",
" 9 | \n",
" 0 | \n",
" 598.8 | \n",
" 542.0 | \n",
" 633.3 | \n",
" 581.5 | \n",
" 605.0 | \n",
" 546.2 | \n",
" 420.3 | \n",
" 486.3 | \n",
" 501.1 | \n",
" 173.3 | \n",
" 600.7 | \n",
" 604.2 | \n",
" 553.1 | \n",
" 393.7 | \n",
" 514.5 | \n",
" 474.5 | \n",
" 475.1 | \n",
" 539.8 | \n",
" 505.5 | \n",
" 525.8 | \n",
" 32.5 | \n",
" 54.3 | \n",
" 57.2 | \n",
" 19.5 | \n",
" 49.3 | \n",
" 31.5 | \n",
" 57.1 | \n",
" 40.4 | \n",
" 35.2 | \n",
" 7.7 | \n",
" 47.2 | \n",
" 81.7 | \n",
" 82.6 | \n",
" 2.9 | \n",
" 13.2 | \n",
" 20.2 | \n",
" 12.9 | \n",
" 32.5 | \n",
" 8.0 | \n",
" 51.6 | \n",
"
\n",
" \n",
" | 1 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 23 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 9847.5 | \n",
" 9317.7 | \n",
" 529.8 | \n",
" 51.0 | \n",
" 3890.7 | \n",
" 3742.7 | \n",
" 1633.3 | \n",
" 420.0 | \n",
" 295.738462 | \n",
" 109.8 | \n",
" 6380.2 | \n",
" 2789.5 | \n",
" 3306.3 | \n",
" 284.4 | \n",
" 3467.3 | \n",
" 101.5 | \n",
" 131.6 | \n",
" 156.7 | \n",
" 135.4 | \n",
" 497.7 | \n",
" 100.3 | \n",
" 392.2 | \n",
" 5.2 | \n",
" 32.1 | \n",
" 5.5 | \n",
" 4.7 | \n",
" 18.6 | \n",
" 2.5 | \n",
" 109.8 | \n",
" 9.3 | \n",
" 100.5 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 1.1 | \n",
" 0.4 | \n",
" 4.8 | \n",
" NaN | \n",
" 25 | \n",
" 6 | \n",
" 26 | \n",
" 29.7 | \n",
" 2 | \n",
" 16 | \n",
" 81 | \n",
" 279 | \n",
" 312 | \n",
" 99 | \n",
" 16 | \n",
" 2 | \n",
" 453.7 | \n",
" 568.7 | \n",
" 675.7 | \n",
" 570.0 | \n",
" 598.5 | \n",
" 560.6 | \n",
" 451.5 | \n",
" 455.7 | \n",
" 508.2 | \n",
" 203.8 | \n",
" 473.7 | \n",
" 548.9 | \n",
" 564.4 | \n",
" 387.2 | \n",
" 434.7 | \n",
" 468.7 | \n",
" 465.5 | \n",
" 578.9 | \n",
" 450.1 | \n",
" 429.0 | \n",
" 13.7 | \n",
" 45.0 | \n",
" 72.5 | \n",
" 36.8 | \n",
" 9.7 | \n",
" 30.7 | \n",
" 23.5 | \n",
" 61.9 | \n",
" 54.0 | \n",
" 15.7 | \n",
" 5.1 | \n",
" 38.7 | \n",
" 25.1 | \n",
" 5.9 | \n",
" 5.5 | \n",
" 0.0 | \n",
" 8.0 | \n",
" 45.6 | \n",
" 13.3 | \n",
" 18.9 | \n",
"
\n",
" \n",
" | 2 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 13 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 10587.6 | \n",
" 9614.4 | \n",
" 973.2 | \n",
" 40.1 | \n",
" 3771.9 | \n",
" 3904.7 | \n",
" 1897.7 | \n",
" 744.1 | \n",
" 752.552941 | \n",
" 229.1 | \n",
" 7225.3 | \n",
" 3196.8 | \n",
" 3710.0 | \n",
" 318.5 | \n",
" 3362.3 | \n",
" 109.2 | \n",
" 150.8 | \n",
" 175.8 | \n",
" 151.7 | \n",
" 945.4 | \n",
" 421.0 | \n",
" 515.8 | \n",
" 8.6 | \n",
" 27.8 | \n",
" 10.0 | \n",
" 19.9 | \n",
" 24.4 | \n",
" 4.1 | \n",
" 224.9 | \n",
" 115.8 | \n",
" 109.1 | \n",
" 0.0 | \n",
" 4.2 | \n",
" 2.4 | \n",
" 5.5 | \n",
" 5.2 | \n",
" NaN | \n",
" 48 | \n",
" 12 | \n",
" 36 | \n",
" 31.9 | \n",
" 4 | \n",
" 18 | \n",
" 72 | \n",
" 272 | \n",
" 299 | \n",
" 75 | \n",
" 8 | \n",
" 1 | \n",
" 562.2 | \n",
" 509.0 | \n",
" 660.1 | \n",
" 579.8 | \n",
" 650.2 | \n",
" 536.3 | \n",
" 511.8 | \n",
" 482.3 | \n",
" 502.6 | \n",
" 175.2 | \n",
" 578.5 | \n",
" 641.4 | \n",
" 592.5 | \n",
" 395.1 | \n",
" 521.6 | \n",
" 499.3 | \n",
" 567.0 | \n",
" 556.8 | \n",
" 541.1 | \n",
" 524.8 | \n",
" 50.5 | \n",
" 36.1 | \n",
" 124.5 | \n",
" 47.9 | \n",
" 38.6 | \n",
" 58.7 | \n",
" 56.9 | \n",
" 42.9 | \n",
" 50.2 | \n",
" 12.3 | \n",
" 47.9 | \n",
" 103.6 | \n",
" 54.8 | \n",
" 12.6 | \n",
" 9.2 | \n",
" 15.1 | \n",
" 33.5 | \n",
" 60.8 | \n",
" 51.9 | \n",
" 65.2 | \n",
"
\n",
" \n",
" | 3 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 1 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 9799.4 | \n",
" 8918.8 | \n",
" 880.5 | \n",
" 42.4 | \n",
" 4219.4 | \n",
" 3293.4 | \n",
" 1363.6 | \n",
" 639.7 | \n",
" 641.346154 | \n",
" 240.8 | \n",
" 6423.5 | \n",
" 3355.7 | \n",
" 2803.4 | \n",
" 264.4 | \n",
" 3375.9 | \n",
" 101.0 | \n",
" 158.3 | \n",
" 132.9 | \n",
" 125.9 | \n",
" 861.8 | \n",
" 624.8 | \n",
" 217.5 | \n",
" 19.5 | \n",
" 18.7 | \n",
" 9.1 | \n",
" 29.5 | \n",
" 10.3 | \n",
" 9.3 | \n",
" 240.8 | \n",
" 198.0 | \n",
" 42.8 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 2.5 | \n",
" 9.3 | \n",
" 2.0 | \n",
" NaN | \n",
" 46 | \n",
" 9 | \n",
" 43 | \n",
" 37.8 | \n",
" 5 | \n",
" 13 | \n",
" 59 | \n",
" 213 | \n",
" 203 | \n",
" 76 | \n",
" 19 | \n",
" 0 | \n",
" 548.0 | \n",
" 479.9 | \n",
" 605.1 | \n",
" 531.7 | \n",
" 608.1 | \n",
" 543.5 | \n",
" 400.4 | \n",
" 518.9 | \n",
" 462.1 | \n",
" 190.3 | \n",
" 564.0 | \n",
" 559.9 | \n",
" 488.7 | \n",
" 301.3 | \n",
" 475.0 | \n",
" 534.6 | \n",
" 517.9 | \n",
" 517.4 | \n",
" 446.3 | \n",
" 506.4 | \n",
" 125.0 | \n",
" 16.4 | \n",
" 75.2 | \n",
" 79.6 | \n",
" 71.8 | \n",
" 62.7 | \n",
" 15.0 | \n",
" 87.2 | \n",
" 3.9 | \n",
" 4.5 | \n",
" 65.8 | \n",
" 17.1 | \n",
" 43.9 | \n",
" 15.6 | \n",
" 35.8 | \n",
" 45.2 | \n",
" 4.9 | \n",
" 16.6 | \n",
" 65.0 | \n",
" 29.4 | \n",
"
\n",
" \n",
" | 4 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 14 | \n",
" 67 | \n",
" 31.8 | \n",
" 16.4 | \n",
" 14.5 | \n",
" 0.9 | \n",
" 7.4 | \n",
" 7460.8 | \n",
" 6797.3 | \n",
" 663.5 | \n",
" 28.2 | \n",
" 2807.5 | \n",
" 2817.7 | \n",
" 1143.9 | \n",
" 501.2 | \n",
" 564.011905 | \n",
" 162.3 | \n",
" 4956.5 | \n",
" 2629.0 | \n",
" 2195.0 | \n",
" 132.4 | \n",
" 2504.4 | \n",
" 111.4 | \n",
" 160.3 | \n",
" 151.4 | \n",
" 147.1 | \n",
" 641.6 | \n",
" 458.6 | \n",
" 183.0 | \n",
" 0.0 | \n",
" 22.0 | \n",
" 9.9 | \n",
" 28.0 | \n",
" 12.6 | \n",
" NaN | \n",
" 158.0 | \n",
" 123.0 | \n",
" 35.1 | \n",
" 0.0 | \n",
" 4.3 | \n",
" 2.4 | \n",
" 7.5 | \n",
" 2.4 | \n",
" NaN | \n",
" 29 | \n",
" 7 | \n",
" 29 | \n",
" 32.1 | \n",
" 0 | \n",
" 15 | \n",
" 57 | \n",
" 153 | \n",
" 197 | \n",
" 49 | \n",
" 6 | \n",
" 2 | \n",
" 546.2 | \n",
" 633.9 | \n",
" 691.5 | \n",
" 543.7 | \n",
" 666.0 | \n",
" 554.7 | \n",
" 476.4 | \n",
" 502.2 | \n",
" 516.4 | \n",
" 202.8 | \n",
" 563.1 | \n",
" 654.0 | \n",
" 542.9 | \n",
" 366.9 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 75.0 | \n",
" 52.3 | \n",
" 39.6 | \n",
" 16.0 | \n",
" 83.2 | \n",
" 23.1 | \n",
" 43.1 | \n",
" 55.8 | \n",
" 33.1 | \n",
" 22.6 | \n",
" 42.2 | \n",
" 88.6 | \n",
" 54.1 | \n",
" 34.8 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
"
\n",
" \n",
"
\n",
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Match Date | \n",
" Match | \n",
" Home/Away | \n",
" Team | \n",
" Player Name | \n",
" Minutes Played | \n",
" Ball In Play Time | \n",
" Time In Possession | \n",
" Time Opponent In Possession | \n",
" Time In Uncontrolled Possession | \n",
" Time In Established Possession | \n",
" Total Distance | \n",
" Total Low Intensity Distance | \n",
" Total High Intensity Distance | \n",
" Stand Distance | \n",
" Walk Distance | \n",
" Jog Distance | \n",
" Run Distance | \n",
" High Speed Run Distance | \n",
" High Speed Distance - Player Average | \n",
" Sprint Distance | \n",
" Ball In Play Total Distance | \n",
" In Possession Total Distance | \n",
" Opponent In Possession Total Distance | \n",
" Uncontrolled Possession Total Distance | \n",
" Ball Out Of Play Total Distance | \n",
" Total Distance (m/min) | \n",
" Total Distance In Possession (m/min) | \n",
" Total Distance Opponent In Possession (m/min) | \n",
" Total Distance Uncontrolled Possession (m/min) | \n",
" Ball In Play HI Distance | \n",
" In Possession HI Distance | \n",
" Opponent In Possession HI Distance | \n",
" Uncontrolled Possession HI Distance | \n",
" Ball Out Of Play HI Distance | \n",
" HI Distance (m/min) | \n",
" HI Distance In Possession (m/min) | \n",
" HI Distance Opponent In Possession (m/min) | \n",
" HI Distance Uncontrolled Possession (m/min) | \n",
" Ball In Play Sprint Distance | \n",
" In Possession Sprint Distance | \n",
" Opponent In Possession Sprint Distance | \n",
" Uncontrolled Possession Sprint Distance | \n",
" Ball Out Of Play Sprint Distance | \n",
" Sprint Distance (m/min) | \n",
" Sprint Distance In Possession (m/min) | \n",
" Sprint Distance Opponent In Possession (m/min) | \n",
" Sprint Distance Uncontrolled Possession (m/min) | \n",
" HI Events | \n",
" Sprint Events | \n",
" HS Run Events | \n",
" Maximum Speed (km/h) | \n",
" Deceleration Very High Events | \n",
" Deceleration High Events | \n",
" Deceleration Medium Events | \n",
" Deceleration Low Events | \n",
" Acceleration Low Events | \n",
" Acceleration Medium Events | \n",
" Acceleration High Events | \n",
" Acceleration Very High Events | \n",
" 1-5TD | \n",
" 6-10TD | \n",
" 11-15TD | \n",
" 16-20TD | \n",
" 21-25TD | \n",
" 26-30TD | \n",
" 31-35TD | \n",
" 36-40TD | \n",
" 41-45TD | \n",
" 45+TD | \n",
" 46-50TD | \n",
" 51-55TD | \n",
" 56-60TD | \n",
" 61-65TD | \n",
" 66-70TD | \n",
" 71-75TD | \n",
" 76-80TD | \n",
" 81-85TD | \n",
" 86-90TD | \n",
" 90+TD | \n",
" 1-5HID | \n",
" 6-10HID | \n",
" 11-15HID | \n",
" 16-20HID | \n",
" 21-25HID | \n",
" 26-30HID | \n",
" 31-35HID | \n",
" 36-40HID | \n",
" 41-45HID | \n",
" 45+HID | \n",
" 46-50HID | \n",
" 51-55HID | \n",
" 56-60HID | \n",
" 61-65HID | \n",
" 66-70HID | \n",
" 71-75HID | \n",
" 76-80HID | \n",
" 81-85HID | \n",
" 86-90HID | \n",
" 90+HID | \n",
"
\n",
" \n",
" \n",
" \n",
" | 415 | \n",
" 08/05/2018 | \n",
" Team A v Team H | \n",
" home | \n",
" Team A | \n",
" Player 15 | \n",
" 28 | \n",
" 16.2 | \n",
" 8.5 | \n",
" 7.4 | \n",
" 0.3 | \n",
" 5.0 | \n",
" 3648.5 | \n",
" 3362.5 | \n",
" 286.0 | \n",
" 8.8 | \n",
" 951.3 | \n",
" 1529.9 | \n",
" 872.5 | \n",
" 255.5 | \n",
" 589.753125 | \n",
" 30.5 | \n",
" 2814.6 | \n",
" 1335.0 | \n",
" 1434.1 | \n",
" 45.5 | \n",
" 833.9 | \n",
" 130.3 | \n",
" 157.1 | \n",
" 193.8 | \n",
" 151.7 | \n",
" 286.0 | \n",
" 42.3 | \n",
" 243.8 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 10.2 | \n",
" 5.0 | \n",
" 32.9 | \n",
" NaN | \n",
" 30.5 | \n",
" 0.0 | \n",
" 30.5 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 1.1 | \n",
" NaN | \n",
" 4.1 | \n",
" NaN | \n",
" 15 | \n",
" 1 | \n",
" 15 | \n",
" 29.7 | \n",
" 2 | \n",
" 3 | \n",
" 28 | \n",
" 102 | \n",
" 101 | \n",
" 29 | \n",
" 4 | \n",
" 0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 682.2 | \n",
" 735.4 | \n",
" 684.6 | \n",
" 559.2 | \n",
" 673.9 | \n",
" 313.2 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 32.5 | \n",
" 51.5 | \n",
" 62.9 | \n",
" 17.5 | \n",
" 38.5 | \n",
" 83.2 | \n",
"
\n",
" \n",
" | 416 | \n",
" 08/05/2018 | \n",
" Team A v Team H | \n",
" home | \n",
" Team A | \n",
" Player 27 | \n",
" 94 | \n",
" 57.9 | \n",
" 28.5 | \n",
" 28.6 | \n",
" 0.8 | \n",
" 17.0 | \n",
" 10396.2 | \n",
" 9207.7 | \n",
" 1188.5 | \n",
" 35.6 | \n",
" 3804.6 | \n",
" 3632.7 | \n",
" 1734.9 | \n",
" 953.8 | \n",
" 307.780000 | \n",
" 234.7 | \n",
" 8073.1 | \n",
" 3797.8 | \n",
" 4165.2 | \n",
" 110.0 | \n",
" 2323.2 | \n",
" 110.6 | \n",
" 133.3 | \n",
" 145.6 | \n",
" 137.5 | \n",
" 1170.2 | \n",
" 599.8 | \n",
" 558.3 | \n",
" 12.1 | \n",
" 18.3 | \n",
" 12.6 | \n",
" 21.0 | \n",
" 19.5 | \n",
" 15.1 | \n",
" 226.5 | \n",
" 135.6 | \n",
" 90.8 | \n",
" 0.0 | \n",
" 8.2 | \n",
" 2.5 | \n",
" 4.8 | \n",
" 3.2 | \n",
" NaN | \n",
" 58 | \n",
" 14 | \n",
" 55 | \n",
" 32.2 | \n",
" 0 | \n",
" 16 | \n",
" 88 | \n",
" 233 | \n",
" 269 | \n",
" 89 | \n",
" 15 | \n",
" 1 | \n",
" 619.5 | \n",
" 526.6 | \n",
" 480.5 | \n",
" 549.8 | \n",
" 502.0 | \n",
" 625.3 | \n",
" 390.6 | \n",
" 516.5 | \n",
" 597.9 | \n",
" 112.9 | \n",
" 706.2 | \n",
" 634.6 | \n",
" 604.4 | \n",
" 445.3 | \n",
" 522.7 | \n",
" 692.7 | \n",
" 545.1 | \n",
" 482.1 | \n",
" 629.4 | \n",
" 212.0 | \n",
" 86.5 | \n",
" 37.5 | \n",
" 8.8 | \n",
" 45.6 | \n",
" 28.0 | \n",
" 104.6 | \n",
" 31.9 | \n",
" 69.2 | \n",
" 61.4 | \n",
" 12.5 | \n",
" 115.2 | \n",
" 109.3 | \n",
" 59.9 | \n",
" 47.8 | \n",
" 42.2 | \n",
" 139.1 | \n",
" 42.4 | \n",
" 44.9 | \n",
" 88.8 | \n",
" 12.8 | \n",
"
\n",
" \n",
" | 417 | \n",
" 08/05/2018 | \n",
" Team A v Team H | \n",
" home | \n",
" Team A | \n",
" Player 3 | \n",
" 94 | \n",
" 57.9 | \n",
" 28.5 | \n",
" 28.6 | \n",
" 0.8 | \n",
" 17.0 | \n",
" 9752.5 | \n",
" 8885.9 | \n",
" 866.6 | \n",
" 53.4 | \n",
" 3514.1 | \n",
" 3884.0 | \n",
" 1434.5 | \n",
" 657.4 | \n",
" 417.075000 | \n",
" 209.2 | \n",
" 7768.4 | \n",
" 3265.2 | \n",
" 4365.0 | \n",
" 138.2 | \n",
" 1984.1 | \n",
" 103.8 | \n",
" 114.6 | \n",
" 152.6 | \n",
" 172.7 | \n",
" 845.7 | \n",
" 108.4 | \n",
" 697.7 | \n",
" 39.6 | \n",
" 20.9 | \n",
" 9.2 | \n",
" 3.8 | \n",
" 24.4 | \n",
" 49.5 | \n",
" 209.2 | \n",
" 27.6 | \n",
" 158.2 | \n",
" 23.3 | \n",
" 0.0 | \n",
" 2.2 | \n",
" 1.0 | \n",
" 5.5 | \n",
" 29.1 | \n",
" 45 | \n",
" 11 | \n",
" 37 | \n",
" 32.8 | \n",
" 4 | \n",
" 16 | \n",
" 74 | \n",
" 245 | \n",
" 256 | \n",
" 82 | \n",
" 21 | \n",
" 0 | \n",
" 568.7 | \n",
" 592.9 | \n",
" 552.0 | \n",
" 527.8 | \n",
" 516.4 | \n",
" 623.2 | \n",
" 420.1 | \n",
" 554.9 | \n",
" 548.0 | \n",
" 70.2 | \n",
" 639.5 | \n",
" 575.0 | \n",
" 591.6 | \n",
" 409.7 | \n",
" 450.3 | \n",
" 493.2 | \n",
" 442.3 | \n",
" 441.8 | \n",
" 457.0 | \n",
" 278.1 | \n",
" 38.5 | \n",
" 83.7 | \n",
" 31.2 | \n",
" 82.4 | \n",
" 23.6 | \n",
" 59.8 | \n",
" 10.2 | \n",
" 94.8 | \n",
" 55.4 | \n",
" 10.2 | \n",
" 54.8 | \n",
" 45.1 | \n",
" 80.1 | \n",
" 5.6 | \n",
" 51.7 | \n",
" 22.0 | \n",
" 13.5 | \n",
" 5.4 | \n",
" 35.4 | \n",
" 63.2 | \n",
"
\n",
" \n",
" | 418 | \n",
" 08/05/2018 | \n",
" Team A v Team H | \n",
" home | \n",
" Team A | \n",
" Player 31 | \n",
" 65 | \n",
" 41.7 | \n",
" 19.9 | \n",
" 21.3 | \n",
" 0.5 | \n",
" 12.0 | \n",
" 7809.6 | \n",
" 7430.5 | \n",
" 379.1 | \n",
" 19.9 | \n",
" 2308.7 | \n",
" 3700.3 | \n",
" 1401.6 | \n",
" 379.1 | \n",
" 208.133333 | \n",
" 0.0 | \n",
" 6385.4 | \n",
" 2757.5 | \n",
" 3544.9 | \n",
" 83.1 | \n",
" 1424.1 | \n",
" 120.1 | \n",
" 138.6 | \n",
" 166.4 | \n",
" 166.2 | \n",
" 375.9 | \n",
" 8.2 | \n",
" 364.9 | \n",
" 2.9 | \n",
" 3.2 | \n",
" 5.8 | \n",
" 0.4 | \n",
" 17.1 | \n",
" 5.8 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 17 | \n",
" 0 | \n",
" 17 | \n",
" 24.9 | \n",
" 0 | \n",
" 7 | \n",
" 49 | \n",
" 193 | \n",
" 226 | \n",
" 45 | \n",
" 2 | \n",
" 2 | \n",
" 700.3 | \n",
" 581.3 | \n",
" 590.6 | \n",
" 601.4 | \n",
" 533.3 | \n",
" 599.8 | \n",
" 470.8 | \n",
" 623.5 | \n",
" 603.5 | \n",
" 64.6 | \n",
" 762.7 | \n",
" 611.3 | \n",
" 606.0 | \n",
" 460.5 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 26.2 | \n",
" 14.2 | \n",
" 33.2 | \n",
" 39.1 | \n",
" 6.5 | \n",
" 6.0 | \n",
" 17.5 | \n",
" 27.3 | \n",
" 10.6 | \n",
" 0.0 | \n",
" 93.1 | \n",
" 52.4 | \n",
" 25.6 | \n",
" 27.4 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
"
\n",
" \n",
" | 419 | \n",
" 08/05/2018 | \n",
" Team A v Team H | \n",
" home | \n",
" Team A | \n",
" Player 22 | \n",
" 94 | \n",
" 57.9 | \n",
" 28.5 | \n",
" 28.6 | \n",
" 0.8 | \n",
" 17.0 | \n",
" 11289.7 | \n",
" 10122.8 | \n",
" 1167.0 | \n",
" 22.7 | \n",
" 3781.0 | \n",
" 4501.2 | \n",
" 1817.9 | \n",
" 927.1 | \n",
" 394.375000 | \n",
" 239.8 | \n",
" 8671.3 | \n",
" 3759.6 | \n",
" 4785.2 | \n",
" 126.5 | \n",
" 2618.5 | \n",
" 120.1 | \n",
" 131.9 | \n",
" 167.3 | \n",
" 158.1 | \n",
" 1145.3 | \n",
" 256.4 | \n",
" 883.4 | \n",
" 5.5 | \n",
" 21.7 | \n",
" 12.4 | \n",
" 9.0 | \n",
" 30.9 | \n",
" 6.9 | \n",
" 239.8 | \n",
" 82.3 | \n",
" 157.5 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 2.6 | \n",
" 2.9 | \n",
" 5.5 | \n",
" NaN | \n",
" 60 | \n",
" 11 | \n",
" 53 | \n",
" 29.8 | \n",
" 5 | \n",
" 14 | \n",
" 101 | \n",
" 290 | \n",
" 304 | \n",
" 92 | \n",
" 24 | \n",
" 1 | \n",
" 626.4 | \n",
" 625.3 | \n",
" 568.9 | \n",
" 634.3 | \n",
" 621.1 | \n",
" 674.1 | \n",
" 417.1 | \n",
" 621.7 | \n",
" 595.0 | \n",
" 135.5 | \n",
" 773.4 | \n",
" 668.1 | \n",
" 582.7 | \n",
" 501.4 | \n",
" 542.4 | \n",
" 690.0 | \n",
" 571.9 | \n",
" 530.2 | \n",
" 601.4 | \n",
" 309.0 | \n",
" 49.7 | \n",
" 60.4 | \n",
" 101.0 | \n",
" 90.2 | \n",
" 50.5 | \n",
" 70.6 | \n",
" 19.8 | \n",
" 65.8 | \n",
" 21.3 | \n",
" 38.6 | \n",
" 129.3 | \n",
" 60.1 | \n",
" 23.3 | \n",
" 84.4 | \n",
" 41.5 | \n",
" 85.4 | \n",
" 27.9 | \n",
" 35.5 | \n",
" 43.7 | \n",
" 67.9 | \n",
"
\n",
" \n",
"
\n",
"
"
]
},
"metadata": {
"needs_background": "light"
},
"output_type": "display_data"
}
],
"source": [
"# Plot visualisation of the missing values for each feature of the raw DataFrame, df_physical_raw\n",
"msno.matrix(df_physical_raw, figsize = (30, 7))"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"HI Distance In Possession (m/min) 2\n",
"HI Distance Opponent In Possession (m/min) 4\n",
"HI Distance Uncontrolled Possession (m/min) 60\n",
"Sprint Distance (m/min) 10\n",
"Sprint Distance In Possession (m/min) 40\n",
"Sprint Distance Opponent In Possession (m/min) 26\n",
"Sprint Distance Uncontrolled Possession (m/min) 240\n",
"dtype: int64"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Counts of missing values\n",
"null_value_stats = df_physical_raw.isnull().sum(axis=0)\n",
"null_value_stats[null_value_stats != 0]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"---\n",
"\n",
"\n",
"\n",
"## 4. Data Engineering\n",
"The next step is to wrangle the dataset to into a format that’s suitable for analysis.\n",
"\n",
"This section is broken down into the following subsections:\n",
"\n",
"4.1. [Assign Raw DataFrame to Engineered DataFrame](#section4.1)
"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"\n",
"\n",
"### 4.1. Assign Raw DataFrames to Engineered DataFrames"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [],
"source": [
"# Assign Raw DataFrame to Engineered DataFrame\n",
"df_physical = df_physical_raw.copy()"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Match Date | \n",
" Match | \n",
" Home/Away | \n",
" Team | \n",
" Player Name | \n",
" Minutes Played | \n",
" Ball In Play Time | \n",
" Time In Possession | \n",
" Time Opponent In Possession | \n",
" Time In Uncontrolled Possession | \n",
" Time In Established Possession | \n",
" Total Distance | \n",
" Total Low Intensity Distance | \n",
" Total High Intensity Distance | \n",
" Stand Distance | \n",
" Walk Distance | \n",
" Jog Distance | \n",
" Run Distance | \n",
" High Speed Run Distance | \n",
" High Speed Distance - Player Average | \n",
" Sprint Distance | \n",
" Ball In Play Total Distance | \n",
" In Possession Total Distance | \n",
" Opponent In Possession Total Distance | \n",
" Uncontrolled Possession Total Distance | \n",
" Ball Out Of Play Total Distance | \n",
" Total Distance (m/min) | \n",
" Total Distance In Possession (m/min) | \n",
" Total Distance Opponent In Possession (m/min) | \n",
" Total Distance Uncontrolled Possession (m/min) | \n",
" Ball In Play HI Distance | \n",
" In Possession HI Distance | \n",
" Opponent In Possession HI Distance | \n",
" Uncontrolled Possession HI Distance | \n",
" Ball Out Of Play HI Distance | \n",
" HI Distance (m/min) | \n",
" HI Distance In Possession (m/min) | \n",
" HI Distance Opponent In Possession (m/min) | \n",
" HI Distance Uncontrolled Possession (m/min) | \n",
" Ball In Play Sprint Distance | \n",
" In Possession Sprint Distance | \n",
" Opponent In Possession Sprint Distance | \n",
" Uncontrolled Possession Sprint Distance | \n",
" Ball Out Of Play Sprint Distance | \n",
" Sprint Distance (m/min) | \n",
" Sprint Distance In Possession (m/min) | \n",
" Sprint Distance Opponent In Possession (m/min) | \n",
" Sprint Distance Uncontrolled Possession (m/min) | \n",
" HI Events | \n",
" Sprint Events | \n",
" HS Run Events | \n",
" Maximum Speed (km/h) | \n",
" Deceleration Very High Events | \n",
" Deceleration High Events | \n",
" Deceleration Medium Events | \n",
" Deceleration Low Events | \n",
" Acceleration Low Events | \n",
" Acceleration Medium Events | \n",
" Acceleration High Events | \n",
" Acceleration Very High Events | \n",
" 1-5TD | \n",
" 6-10TD | \n",
" 11-15TD | \n",
" 16-20TD | \n",
" 21-25TD | \n",
" 26-30TD | \n",
" 31-35TD | \n",
" 36-40TD | \n",
" 41-45TD | \n",
" 45+TD | \n",
" 46-50TD | \n",
" 51-55TD | \n",
" 56-60TD | \n",
" 61-65TD | \n",
" 66-70TD | \n",
" 71-75TD | \n",
" 76-80TD | \n",
" 81-85TD | \n",
" 86-90TD | \n",
" 90+TD | \n",
" 1-5HID | \n",
" 6-10HID | \n",
" 11-15HID | \n",
" 16-20HID | \n",
" 21-25HID | \n",
" 26-30HID | \n",
" 31-35HID | \n",
" 36-40HID | \n",
" 41-45HID | \n",
" 45+HID | \n",
" 46-50HID | \n",
" 51-55HID | \n",
" 56-60HID | \n",
" 61-65HID | \n",
" 66-70HID | \n",
" 71-75HID | \n",
" 76-80HID | \n",
" 81-85HID | \n",
" 86-90HID | \n",
" 90+HID | \n",
"
\n",
" \n",
" \n",
" \n",
" | 0 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 11 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 10274.7 | \n",
" 9537.4 | \n",
" 737.3 | \n",
" 55.7 | \n",
" 3852.9 | \n",
" 3818.9 | \n",
" 1809.8 | \n",
" 639.4 | \n",
" 550.388462 | \n",
" 97.9 | \n",
" 6499.6 | \n",
" 2863.4 | \n",
" 3374.8 | \n",
" 261.4 | \n",
" 3775.1 | \n",
" 105.9 | \n",
" 135.1 | \n",
" 159.9 | \n",
" 124.5 | \n",
" 705.3 | \n",
" 292.0 | \n",
" 410.6 | \n",
" 2.7 | \n",
" 32.0 | \n",
" 7.6 | \n",
" 13.8 | \n",
" 19.5 | \n",
" 1.3 | \n",
" 88.3 | \n",
" 47.4 | \n",
" 40.9 | \n",
" 0.0 | \n",
" 9.7 | \n",
" 1.0 | \n",
" 2.2 | \n",
" 1.9 | \n",
" NaN | \n",
" 40 | \n",
" 7 | \n",
" 41 | \n",
" 29.7 | \n",
" 2 | \n",
" 19 | \n",
" 70 | \n",
" 220 | \n",
" 236 | \n",
" 69 | \n",
" 9 | \n",
" 0 | \n",
" 598.8 | \n",
" 542.0 | \n",
" 633.3 | \n",
" 581.5 | \n",
" 605.0 | \n",
" 546.2 | \n",
" 420.3 | \n",
" 486.3 | \n",
" 501.1 | \n",
" 173.3 | \n",
" 600.7 | \n",
" 604.2 | \n",
" 553.1 | \n",
" 393.7 | \n",
" 514.5 | \n",
" 474.5 | \n",
" 475.1 | \n",
" 539.8 | \n",
" 505.5 | \n",
" 525.8 | \n",
" 32.5 | \n",
" 54.3 | \n",
" 57.2 | \n",
" 19.5 | \n",
" 49.3 | \n",
" 31.5 | \n",
" 57.1 | \n",
" 40.4 | \n",
" 35.2 | \n",
" 7.7 | \n",
" 47.2 | \n",
" 81.7 | \n",
" 82.6 | \n",
" 2.9 | \n",
" 13.2 | \n",
" 20.2 | \n",
" 12.9 | \n",
" 32.5 | \n",
" 8.0 | \n",
" 51.6 | \n",
"
\n",
" \n",
" | 1 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 23 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 9847.5 | \n",
" 9317.7 | \n",
" 529.8 | \n",
" 51.0 | \n",
" 3890.7 | \n",
" 3742.7 | \n",
" 1633.3 | \n",
" 420.0 | \n",
" 295.738462 | \n",
" 109.8 | \n",
" 6380.2 | \n",
" 2789.5 | \n",
" 3306.3 | \n",
" 284.4 | \n",
" 3467.3 | \n",
" 101.5 | \n",
" 131.6 | \n",
" 156.7 | \n",
" 135.4 | \n",
" 497.7 | \n",
" 100.3 | \n",
" 392.2 | \n",
" 5.2 | \n",
" 32.1 | \n",
" 5.5 | \n",
" 4.7 | \n",
" 18.6 | \n",
" 2.5 | \n",
" 109.8 | \n",
" 9.3 | \n",
" 100.5 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 1.1 | \n",
" 0.4 | \n",
" 4.8 | \n",
" NaN | \n",
" 25 | \n",
" 6 | \n",
" 26 | \n",
" 29.7 | \n",
" 2 | \n",
" 16 | \n",
" 81 | \n",
" 279 | \n",
" 312 | \n",
" 99 | \n",
" 16 | \n",
" 2 | \n",
" 453.7 | \n",
" 568.7 | \n",
" 675.7 | \n",
" 570.0 | \n",
" 598.5 | \n",
" 560.6 | \n",
" 451.5 | \n",
" 455.7 | \n",
" 508.2 | \n",
" 203.8 | \n",
" 473.7 | \n",
" 548.9 | \n",
" 564.4 | \n",
" 387.2 | \n",
" 434.7 | \n",
" 468.7 | \n",
" 465.5 | \n",
" 578.9 | \n",
" 450.1 | \n",
" 429.0 | \n",
" 13.7 | \n",
" 45.0 | \n",
" 72.5 | \n",
" 36.8 | \n",
" 9.7 | \n",
" 30.7 | \n",
" 23.5 | \n",
" 61.9 | \n",
" 54.0 | \n",
" 15.7 | \n",
" 5.1 | \n",
" 38.7 | \n",
" 25.1 | \n",
" 5.9 | \n",
" 5.5 | \n",
" 0.0 | \n",
" 8.0 | \n",
" 45.6 | \n",
" 13.3 | \n",
" 18.9 | \n",
"
\n",
" \n",
" | 2 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 13 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 10587.6 | \n",
" 9614.4 | \n",
" 973.2 | \n",
" 40.1 | \n",
" 3771.9 | \n",
" 3904.7 | \n",
" 1897.7 | \n",
" 744.1 | \n",
" 752.552941 | \n",
" 229.1 | \n",
" 7225.3 | \n",
" 3196.8 | \n",
" 3710.0 | \n",
" 318.5 | \n",
" 3362.3 | \n",
" 109.2 | \n",
" 150.8 | \n",
" 175.8 | \n",
" 151.7 | \n",
" 945.4 | \n",
" 421.0 | \n",
" 515.8 | \n",
" 8.6 | \n",
" 27.8 | \n",
" 10.0 | \n",
" 19.9 | \n",
" 24.4 | \n",
" 4.1 | \n",
" 224.9 | \n",
" 115.8 | \n",
" 109.1 | \n",
" 0.0 | \n",
" 4.2 | \n",
" 2.4 | \n",
" 5.5 | \n",
" 5.2 | \n",
" NaN | \n",
" 48 | \n",
" 12 | \n",
" 36 | \n",
" 31.9 | \n",
" 4 | \n",
" 18 | \n",
" 72 | \n",
" 272 | \n",
" 299 | \n",
" 75 | \n",
" 8 | \n",
" 1 | \n",
" 562.2 | \n",
" 509.0 | \n",
" 660.1 | \n",
" 579.8 | \n",
" 650.2 | \n",
" 536.3 | \n",
" 511.8 | \n",
" 482.3 | \n",
" 502.6 | \n",
" 175.2 | \n",
" 578.5 | \n",
" 641.4 | \n",
" 592.5 | \n",
" 395.1 | \n",
" 521.6 | \n",
" 499.3 | \n",
" 567.0 | \n",
" 556.8 | \n",
" 541.1 | \n",
" 524.8 | \n",
" 50.5 | \n",
" 36.1 | \n",
" 124.5 | \n",
" 47.9 | \n",
" 38.6 | \n",
" 58.7 | \n",
" 56.9 | \n",
" 42.9 | \n",
" 50.2 | \n",
" 12.3 | \n",
" 47.9 | \n",
" 103.6 | \n",
" 54.8 | \n",
" 12.6 | \n",
" 9.2 | \n",
" 15.1 | \n",
" 33.5 | \n",
" 60.8 | \n",
" 51.9 | \n",
" 65.2 | \n",
"
\n",
" \n",
" | 3 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 1 | \n",
" 97 | \n",
" 44.4 | \n",
" 21.2 | \n",
" 21.1 | \n",
" 2.1 | \n",
" 7.7 | \n",
" 9799.4 | \n",
" 8918.8 | \n",
" 880.5 | \n",
" 42.4 | \n",
" 4219.4 | \n",
" 3293.4 | \n",
" 1363.6 | \n",
" 639.7 | \n",
" 641.346154 | \n",
" 240.8 | \n",
" 6423.5 | \n",
" 3355.7 | \n",
" 2803.4 | \n",
" 264.4 | \n",
" 3375.9 | \n",
" 101.0 | \n",
" 158.3 | \n",
" 132.9 | \n",
" 125.9 | \n",
" 861.8 | \n",
" 624.8 | \n",
" 217.5 | \n",
" 19.5 | \n",
" 18.7 | \n",
" 9.1 | \n",
" 29.5 | \n",
" 10.3 | \n",
" 9.3 | \n",
" 240.8 | \n",
" 198.0 | \n",
" 42.8 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 2.5 | \n",
" 9.3 | \n",
" 2.0 | \n",
" NaN | \n",
" 46 | \n",
" 9 | \n",
" 43 | \n",
" 37.8 | \n",
" 5 | \n",
" 13 | \n",
" 59 | \n",
" 213 | \n",
" 203 | \n",
" 76 | \n",
" 19 | \n",
" 0 | \n",
" 548.0 | \n",
" 479.9 | \n",
" 605.1 | \n",
" 531.7 | \n",
" 608.1 | \n",
" 543.5 | \n",
" 400.4 | \n",
" 518.9 | \n",
" 462.1 | \n",
" 190.3 | \n",
" 564.0 | \n",
" 559.9 | \n",
" 488.7 | \n",
" 301.3 | \n",
" 475.0 | \n",
" 534.6 | \n",
" 517.9 | \n",
" 517.4 | \n",
" 446.3 | \n",
" 506.4 | \n",
" 125.0 | \n",
" 16.4 | \n",
" 75.2 | \n",
" 79.6 | \n",
" 71.8 | \n",
" 62.7 | \n",
" 15.0 | \n",
" 87.2 | \n",
" 3.9 | \n",
" 4.5 | \n",
" 65.8 | \n",
" 17.1 | \n",
" 43.9 | \n",
" 15.6 | \n",
" 35.8 | \n",
" 45.2 | \n",
" 4.9 | \n",
" 16.6 | \n",
" 65.0 | \n",
" 29.4 | \n",
"
\n",
" \n",
" | 4 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 14 | \n",
" 67 | \n",
" 31.8 | \n",
" 16.4 | \n",
" 14.5 | \n",
" 0.9 | \n",
" 7.4 | \n",
" 7460.8 | \n",
" 6797.3 | \n",
" 663.5 | \n",
" 28.2 | \n",
" 2807.5 | \n",
" 2817.7 | \n",
" 1143.9 | \n",
" 501.2 | \n",
" 564.011905 | \n",
" 162.3 | \n",
" 4956.5 | \n",
" 2629.0 | \n",
" 2195.0 | \n",
" 132.4 | \n",
" 2504.4 | \n",
" 111.4 | \n",
" 160.3 | \n",
" 151.4 | \n",
" 147.1 | \n",
" 641.6 | \n",
" 458.6 | \n",
" 183.0 | \n",
" 0.0 | \n",
" 22.0 | \n",
" 9.9 | \n",
" 28.0 | \n",
" 12.6 | \n",
" NaN | \n",
" 158.0 | \n",
" 123.0 | \n",
" 35.1 | \n",
" 0.0 | \n",
" 4.3 | \n",
" 2.4 | \n",
" 7.5 | \n",
" 2.4 | \n",
" NaN | \n",
" 29 | \n",
" 7 | \n",
" 29 | \n",
" 32.1 | \n",
" 0 | \n",
" 15 | \n",
" 57 | \n",
" 153 | \n",
" 197 | \n",
" 49 | \n",
" 6 | \n",
" 2 | \n",
" 546.2 | \n",
" 633.9 | \n",
" 691.5 | \n",
" 543.7 | \n",
" 666.0 | \n",
" 554.7 | \n",
" 476.4 | \n",
" 502.2 | \n",
" 516.4 | \n",
" 202.8 | \n",
" 563.1 | \n",
" 654.0 | \n",
" 542.9 | \n",
" 366.9 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 75.0 | \n",
" 52.3 | \n",
" 39.6 | \n",
" 16.0 | \n",
" 83.2 | \n",
" 23.1 | \n",
" 43.1 | \n",
" 55.8 | \n",
" 33.1 | \n",
" 22.6 | \n",
" 42.2 | \n",
" 88.6 | \n",
" 54.1 | \n",
" 34.8 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
" 0.0 | \n",
"
\n",
" \n",
"
\n",
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Match Date | \n",
" Match | \n",
" Home/Away | \n",
" Team | \n",
" Player Name | \n",
" Minutes Played | \n",
" Time Period | \n",
" Total Distance | \n",
"
\n",
" \n",
" \n",
" \n",
" | 0 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 11 | \n",
" 97 | \n",
" 1-5TD | \n",
" 598.8 | \n",
"
\n",
" \n",
" | 1 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 23 | \n",
" 97 | \n",
" 1-5TD | \n",
" 453.7 | \n",
"
\n",
" \n",
" | 2 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 13 | \n",
" 97 | \n",
" 1-5TD | \n",
" 562.2 | \n",
"
\n",
" \n",
" | 3 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 1 | \n",
" 97 | \n",
" 1-5TD | \n",
" 548.0 | \n",
"
\n",
" \n",
" | 4 | \n",
" 11/09/2017 | \n",
" Team A v Team Q | \n",
" home | \n",
" Team A | \n",
" Player 14 | \n",
" 67 | \n",
" 1-5TD | \n",
" 546.2 | \n",
"
\n",
" \n",
"
\n",
"