Scrape Big5 Playing Time Stats.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "0XFPIZmjtLbb"
   },
   "source": [
    "## How to Scrap Big5 Playing Time Stats from FBREF - Soccer/Football\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "-AQZU0n4StVq"
   },
   "source": [
    "Method 1\n",
    "\n",
    "We could modularize the URL and year strings of text that may be useful for programmatic access (in the subsequent code cell)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "executionInfo": {
     "elapsed": 5,
     "status": "ok",
     "timestamp": 1642638872836,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "eviHhQGkleOW"
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "from unidecode import unidecode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "executionInfo": {
     "elapsed": 1656,
     "status": "ok",
     "timestamp": 1642638874488,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "goV7r4FUlfMt"
   },
   "outputs": [],
   "source": [
    "url = 'https://fbref.com/en/comps/Big5/playingtime/players/Big-5-European-Leagues-Stats'\n",
    "html_content = requests.get(url).text.replace('<!--', '').replace('-->', '')\n",
    "df = pd.read_html(html_content, encoding='utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "wlDt8TTxSvEz"
   },
   "source": [
    "Method 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "executionInfo": {
     "elapsed": 13,
     "status": "ok",
     "timestamp": 1642638874488,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "-x78Rt_iRmCa"
   },
   "outputs": [],
   "source": [
    "#url = 'https://fbref.com/en/comps/Big5/defense/players/Big-5-European-Leagues-Stats'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "fhVY2xJJS0FU"
   },
   "source": [
    "Read HTML webpage into pandas"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "Sk1EUVeFUXPq"
   },
   "source": [
    "Using pd.read_html() function to read HTML webpage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "executionInfo": {
     "elapsed": 11,
     "status": "ok",
     "timestamp": 1642638874489,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "4sLS78K-S-r2",
    "outputId": "d8e4bbb5-aeb1-4a74-e2c1-4f94ccb3f976"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[     Unnamed: 0_level_0  Unnamed: 1_level_0 Unnamed: 2_level_0  \\\n",
       "                      Rk              Player             Nation   \n",
       " 0                     1          Max Aarons            eng ENG   \n",
       " 1                     2    Yunis Abdelhamid             ma MAR   \n",
       " 2                     3   Salis Abdul Samed             gh GHA   \n",
       " 3                     4  Suleiman Abdullahi             ng NGA   \n",
       " 4                     5     Laurent Abergel             fr FRA   \n",
       " ...                 ...                 ...                ...   \n",
       " 3730               3588     Emanuele Zuelli             it ITA   \n",
       " 3731               3589    Szymon Żurkowski             pl POL   \n",
       " 3732               3590     Martin Ødegaard             no NOR   \n",
       " 3733               3591         Milan Đurić             ba BIH   \n",
       " 3734               3592       Filip Đuričić             rs SRB   \n",
       " \n",
       "      Unnamed: 3_level_0 Unnamed: 4_level_0  Unnamed: 5_level_0  \\\n",
       "                     Pos              Squad                Comp   \n",
       " 0                    DF       Norwich City  eng Premier League   \n",
       " 1                    DF              Reims          fr Ligue 1   \n",
       " 2                    MF      Clermont Foot          fr Ligue 1   \n",
       " 3                 FW,MF       Union Berlin       de Bundesliga   \n",
       " 4                    MF            Lorient          fr Ligue 1   \n",
       " ...                 ...                ...                 ...   \n",
       " 3730                 MF           Juventus          it Serie A   \n",
       " 3731                 MF             Empoli          it Serie A   \n",
       " 3732                 MF            Arsenal  eng Premier League   \n",
       " 3733                 FW        Salernitana          it Serie A   \n",
       " 3734              MF,FW           Sassuolo          it Serie A   \n",
       " \n",
       "      Unnamed: 6_level_0 Unnamed: 7_level_0 Playing Time        ...  \\\n",
       "                     Age               Born           MP   Min  ...   \n",
       " 0                    21               2000           34  2881  ...   \n",
       " 1                    33               1987           34  2983  ...   \n",
       " 2                    21               2000           31  2462  ...   \n",
       " 3                    24               1996            0   NaN  ...   \n",
       " 4                    28               1993           34  2956  ...   \n",
       " ...                 ...                ...          ...   ...  ...   \n",
       " 3730                 19               2001            0   NaN  ...   \n",
       " 3731                 23               1997           35  2307  ...   \n",
       " 3732                 22               1998           36  2785  ...   \n",
       " 3733                 31               1990           33  2165  ...   \n",
       " 3734                 29               1992           12   671  ...   \n",
       " \n",
       "      Team Success                    Team Success (xG)                       \\\n",
       "              onGA  +/-  +/-90 On-Off              onxG onxGA  xG+/- xG+/-90   \n",
       " 0              69  -51  -1.59  +0.08              25.8  60.8  -35.0   -1.09   \n",
       " 1              41   -3  -0.09  -0.50              32.1  43.7  -11.5   -0.35   \n",
       " 2              43  -17  -0.62  +0.69              29.7  35.9   -6.2   -0.23   \n",
       " 3             NaN  NaN    NaN    NaN               NaN   NaN    NaN     NaN   \n",
       " 4              59  -32  -0.97  -1.75              37.2  48.1  -11.0   -0.33   \n",
       " ...           ...  ...    ...    ...               ...   ...    ...     ...   \n",
       " 3730          NaN  NaN    NaN    NaN               NaN   NaN    NaN     NaN   \n",
       " 3731           43   -7  -0.27  +0.78              29.2  42.6  -13.4   -0.52   \n",
       " 3732           39  +14  +0.45  +0.59              50.5  35.1  +15.4   +0.50   \n",
       " 3733           39  -17  -0.71  +1.30              28.7  38.9  -10.2   -0.43   \n",
       " 3734           10   -2  -0.27  -0.27              10.0  11.6   -1.6   -0.21   \n",
       " \n",
       "             Unnamed: 30_level_0  \n",
       "      On-Off             Matches  \n",
       " 0     +0.35             Matches  \n",
       " 1     -0.58             Matches  \n",
       " 2     -0.05             Matches  \n",
       " 3       NaN             Matches  \n",
       " 4     -0.86             Matches  \n",
       " ...     ...                 ...  \n",
       " 3730    NaN             Matches  \n",
       " 3731  +0.11             Matches  \n",
       " 3732  +0.87             Matches  \n",
       " 3733  +0.86             Matches  \n",
       " 3734  +0.09             Matches  \n",
       " \n",
       " [3735 rows x 31 columns]]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "iVtWB7zuUWIp"
   },
   "source": [
    "How many tables are there in the webpage?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "executionInfo": {
     "elapsed": 7,
     "status": "ok",
     "timestamp": 1642638874489,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "BdIXrthuTApH",
    "outputId": "0b696619-18c7-4e8e-a4ee-be1c0dd7cf57"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "executionInfo": {
     "elapsed": 289,
     "status": "ok",
     "timestamp": 1642638874775,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "_JF0jpfDmdj_"
   },
   "outputs": [],
   "source": [
    "df[0].columns = df[0].columns.droplevel(0) # drop top header row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[0] = df[0].fillna(0)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "glCMVlkWU6ik"
   },
   "source": [
    "Select the first table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 696
    },
    "executionInfo": {
     "elapsed": 12,
     "status": "ok",
     "timestamp": 1642638874775,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "Pv0NHbFeTrEp",
    "outputId": "0c9f3b32-7e29-4a4a-bae2-9b1cd6459898"
   },
   "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>Rk</th>\n",
       "      <th>Player</th>\n",
       "      <th>Nation</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Squad</th>\n",
       "      <th>Comp</th>\n",
       "      <th>Age</th>\n",
       "      <th>Born</th>\n",
       "      <th>MP</th>\n",
       "      <th>Min</th>\n",
       "      <th>...</th>\n",
       "      <th>onGA</th>\n",
       "      <th>+/-</th>\n",
       "      <th>+/-90</th>\n",
       "      <th>On-Off</th>\n",
       "      <th>onxG</th>\n",
       "      <th>onxGA</th>\n",
       "      <th>xG+/-</th>\n",
       "      <th>xG+/-90</th>\n",
       "      <th>On-Off</th>\n",
       "      <th>Matches</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3715</th>\n",
       "      <td>3574</td>\n",
       "      <td>Christoph Zimmermann</td>\n",
       "      <td>de GER</td>\n",
       "      <td>DF</td>\n",
       "      <td>Norwich City</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>28</td>\n",
       "      <td>1993</td>\n",
       "      <td>3</td>\n",
       "      <td>157</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>-8</td>\n",
       "      <td>-4.59</td>\n",
       "      <td>-3.12</td>\n",
       "      <td>0.9</td>\n",
       "      <td>5.5</td>\n",
       "      <td>-4.6</td>\n",
       "      <td>-2.66</td>\n",
       "      <td>-1.58</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3716</th>\n",
       "      <td>3575</td>\n",
       "      <td>Oleksandr Zinchenko</td>\n",
       "      <td>ua UKR</td>\n",
       "      <td>DF</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>24</td>\n",
       "      <td>1996</td>\n",
       "      <td>15</td>\n",
       "      <td>1047</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>+40</td>\n",
       "      <td>+3.44</td>\n",
       "      <td>+2.19</td>\n",
       "      <td>36.9</td>\n",
       "      <td>8.9</td>\n",
       "      <td>+28.0</td>\n",
       "      <td>+2.41</td>\n",
       "      <td>+1.12</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3717</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3718</th>\n",
       "      <td>3576</td>\n",
       "      <td>Zito</td>\n",
       "      <td>ao ANG</td>\n",
       "      <td>FW</td>\n",
       "      <td>Cagliari</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>19</td>\n",
       "      <td>2002</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3719</th>\n",
       "      <td>3577</td>\n",
       "      <td>Hakim Ziyech</td>\n",
       "      <td>ma MAR</td>\n",
       "      <td>FW,MF</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>28</td>\n",
       "      <td>1993</td>\n",
       "      <td>23</td>\n",
       "      <td>1319</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>+10</td>\n",
       "      <td>+0.68</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>24.4</td>\n",
       "      <td>11.5</td>\n",
       "      <td>+12.9</td>\n",
       "      <td>+0.88</td>\n",
       "      <td>+0.09</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3720</th>\n",
       "      <td>3578</td>\n",
       "      <td>Jeroen Zoet</td>\n",
       "      <td>nl NED</td>\n",
       "      <td>GK</td>\n",
       "      <td>Spezia</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>30</td>\n",
       "      <td>1991</td>\n",
       "      <td>7</td>\n",
       "      <td>630</td>\n",
       "      <td>...</td>\n",
       "      <td>19</td>\n",
       "      <td>-11</td>\n",
       "      <td>-1.57</td>\n",
       "      <td>-0.96</td>\n",
       "      <td>6.3</td>\n",
       "      <td>12.2</td>\n",
       "      <td>-5.9</td>\n",
       "      <td>-0.84</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3721</th>\n",
       "      <td>3579</td>\n",
       "      <td>Simon Zoller</td>\n",
       "      <td>de GER</td>\n",
       "      <td>FW</td>\n",
       "      <td>Bochum</td>\n",
       "      <td>de Bundesliga</td>\n",
       "      <td>30</td>\n",
       "      <td>1991</td>\n",
       "      <td>10</td>\n",
       "      <td>596</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>-3</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>6.3</td>\n",
       "      <td>12.6</td>\n",
       "      <td>-6.4</td>\n",
       "      <td>-0.96</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3722</th>\n",
       "      <td>3580</td>\n",
       "      <td>Nadir Zortea</td>\n",
       "      <td>it ITA</td>\n",
       "      <td>DF,MF</td>\n",
       "      <td>Salernitana</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>22</td>\n",
       "      <td>1999</td>\n",
       "      <td>29</td>\n",
       "      <td>1410</td>\n",
       "      <td>...</td>\n",
       "      <td>29</td>\n",
       "      <td>-15</td>\n",
       "      <td>-0.96</td>\n",
       "      <td>+0.39</td>\n",
       "      <td>17.3</td>\n",
       "      <td>24.4</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>+0.50</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3723</th>\n",
       "      <td>3581</td>\n",
       "      <td>Banhie Zoukrou</td>\n",
       "      <td>fr FRA</td>\n",
       "      <td>DF</td>\n",
       "      <td>Troyes</td>\n",
       "      <td>fr Ligue 1</td>\n",
       "      <td>18</td>\n",
       "      <td>2003</td>\n",
       "      <td>4</td>\n",
       "      <td>77</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-3</td>\n",
       "      <td>-3.51</td>\n",
       "      <td>-3.16</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-0.97</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3724</th>\n",
       "      <td>3582</td>\n",
       "      <td>Kurt Zouma</td>\n",
       "      <td>fr FRA</td>\n",
       "      <td>DF</td>\n",
       "      <td>West Ham</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>26</td>\n",
       "      <td>1994</td>\n",
       "      <td>24</td>\n",
       "      <td>2078</td>\n",
       "      <td>...</td>\n",
       "      <td>29</td>\n",
       "      <td>+4</td>\n",
       "      <td>+0.17</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>27.7</td>\n",
       "      <td>29.5</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-0.08</td>\n",
       "      <td>-0.13</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3725</th>\n",
       "      <td>3583</td>\n",
       "      <td>Kurt Zouma</td>\n",
       "      <td>fr FRA</td>\n",
       "      <td>DF</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>26</td>\n",
       "      <td>1994</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3726</th>\n",
       "      <td>3584</td>\n",
       "      <td>Petar Zovko</td>\n",
       "      <td>ba BIH</td>\n",
       "      <td>GK</td>\n",
       "      <td>Spezia</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>19</td>\n",
       "      <td>2002</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>-3.10</td>\n",
       "      <td>-2.33</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>+1.0</td>\n",
       "      <td>+3.10</td>\n",
       "      <td>+3.88</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3727</th>\n",
       "      <td>3585</td>\n",
       "      <td>Igor Zubeldia</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>DF</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>es La Liga</td>\n",
       "      <td>24</td>\n",
       "      <td>1997</td>\n",
       "      <td>26</td>\n",
       "      <td>1648</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>-8</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>-1.00</td>\n",
       "      <td>24.8</td>\n",
       "      <td>21.8</td>\n",
       "      <td>+3.0</td>\n",
       "      <td>+0.17</td>\n",
       "      <td>-0.40</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3728</th>\n",
       "      <td>3586</td>\n",
       "      <td>Martín Zubimendi</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>MF</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>es La Liga</td>\n",
       "      <td>22</td>\n",
       "      <td>1999</td>\n",
       "      <td>36</td>\n",
       "      <td>2591</td>\n",
       "      <td>...</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>43.0</td>\n",
       "      <td>32.9</td>\n",
       "      <td>+10.1</td>\n",
       "      <td>+0.35</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3729</th>\n",
       "      <td>3587</td>\n",
       "      <td>Federico Zuccon</td>\n",
       "      <td>it ITA</td>\n",
       "      <td>FW</td>\n",
       "      <td>Atalanta</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>18</td>\n",
       "      <td>2003</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3730</th>\n",
       "      <td>3588</td>\n",
       "      <td>Emanuele Zuelli</td>\n",
       "      <td>it ITA</td>\n",
       "      <td>MF</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>19</td>\n",
       "      <td>2001</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3731</th>\n",
       "      <td>3589</td>\n",
       "      <td>Szymon Żurkowski</td>\n",
       "      <td>pl POL</td>\n",
       "      <td>MF</td>\n",
       "      <td>Empoli</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>23</td>\n",
       "      <td>1997</td>\n",
       "      <td>35</td>\n",
       "      <td>2307</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>-7</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>+0.78</td>\n",
       "      <td>29.2</td>\n",
       "      <td>42.6</td>\n",
       "      <td>-13.4</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>+0.11</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3732</th>\n",
       "      <td>3590</td>\n",
       "      <td>Martin Ødegaard</td>\n",
       "      <td>no NOR</td>\n",
       "      <td>MF</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>22</td>\n",
       "      <td>1998</td>\n",
       "      <td>36</td>\n",
       "      <td>2785</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>+14</td>\n",
       "      <td>+0.45</td>\n",
       "      <td>+0.59</td>\n",
       "      <td>50.5</td>\n",
       "      <td>35.1</td>\n",
       "      <td>+15.4</td>\n",
       "      <td>+0.50</td>\n",
       "      <td>+0.87</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3733</th>\n",
       "      <td>3591</td>\n",
       "      <td>Milan Đurić</td>\n",
       "      <td>ba BIH</td>\n",
       "      <td>FW</td>\n",
       "      <td>Salernitana</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>31</td>\n",
       "      <td>1990</td>\n",
       "      <td>33</td>\n",
       "      <td>2165</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>-17</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>+1.30</td>\n",
       "      <td>28.7</td>\n",
       "      <td>38.9</td>\n",
       "      <td>-10.2</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>+0.86</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3734</th>\n",
       "      <td>3592</td>\n",
       "      <td>Filip Đuričić</td>\n",
       "      <td>rs SRB</td>\n",
       "      <td>MF,FW</td>\n",
       "      <td>Sassuolo</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>29</td>\n",
       "      <td>1992</td>\n",
       "      <td>12</td>\n",
       "      <td>671</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>-2</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.6</td>\n",
       "      <td>-1.6</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>+0.09</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Rk                Player  Nation    Pos            Squad  \\\n",
       "3715  3574  Christoph Zimmermann  de GER     DF     Norwich City   \n",
       "3716  3575   Oleksandr Zinchenko  ua UKR     DF  Manchester City   \n",
       "3717    Rk                Player  Nation    Pos            Squad   \n",
       "3718  3576                  Zito  ao ANG     FW         Cagliari   \n",
       "3719  3577          Hakim Ziyech  ma MAR  FW,MF          Chelsea   \n",
       "3720  3578           Jeroen Zoet  nl NED     GK           Spezia   \n",
       "3721  3579          Simon Zoller  de GER     FW           Bochum   \n",
       "3722  3580          Nadir Zortea  it ITA  DF,MF      Salernitana   \n",
       "3723  3581        Banhie Zoukrou  fr FRA     DF           Troyes   \n",
       "3724  3582            Kurt Zouma  fr FRA     DF         West Ham   \n",
       "3725  3583            Kurt Zouma  fr FRA     DF          Chelsea   \n",
       "3726  3584           Petar Zovko  ba BIH     GK           Spezia   \n",
       "3727  3585         Igor Zubeldia  es ESP     DF    Real Sociedad   \n",
       "3728  3586      Martín Zubimendi  es ESP     MF    Real Sociedad   \n",
       "3729  3587       Federico Zuccon  it ITA     FW         Atalanta   \n",
       "3730  3588       Emanuele Zuelli  it ITA     MF         Juventus   \n",
       "3731  3589      Szymon Żurkowski  pl POL     MF           Empoli   \n",
       "3732  3590       Martin Ødegaard  no NOR     MF          Arsenal   \n",
       "3733  3591           Milan Đurić  ba BIH     FW      Salernitana   \n",
       "3734  3592         Filip Đuričić  rs SRB  MF,FW         Sassuolo   \n",
       "\n",
       "                    Comp  Age  Born  MP   Min  ...  onGA  +/-  +/-90  On-Off  \\\n",
       "3715  eng Premier League   28  1993   3   157  ...     8   -8  -4.59   -3.12   \n",
       "3716  eng Premier League   24  1996  15  1047  ...     9  +40  +3.44   +2.19   \n",
       "3717                Comp  Age  Born  MP   Min  ...  onGA  +/-  +/-90  On-Off   \n",
       "3718          it Serie A   19  2002   0     0  ...     0    0      0       0   \n",
       "3719  eng Premier League   28  1993  23  1319  ...    12  +10  +0.68   -0.73   \n",
       "3720          it Serie A   30  1991   7   630  ...    19  -11  -1.57   -0.96   \n",
       "3721       de Bundesliga   30  1991  10   596  ...    12   -3  -0.45   -0.05   \n",
       "3722          it Serie A   22  1999  29  1410  ...    29  -15  -0.96   +0.39   \n",
       "3723          fr Ligue 1   18  2003   4    77  ...     3   -3  -3.51   -3.16   \n",
       "3724  eng Premier League   26  1994  24  2078  ...    29   +4  +0.17   -0.16   \n",
       "3725  eng Premier League   26  1994   0     0  ...     0    0      0       0   \n",
       "3726          it Serie A   19  2002   1    29  ...     2   -1  -3.10   -2.33   \n",
       "3727          es La Liga   24  1997  26  1648  ...    25   -8  -0.44   -1.00   \n",
       "3728          es La Liga   22  1999  36  2591  ...    30    0   0.00   -0.33   \n",
       "3729          it Serie A   18  2003   0     0  ...     0    0      0       0   \n",
       "3730          it Serie A   19  2001   0     0  ...     0    0      0       0   \n",
       "3731          it Serie A   23  1997  35  2307  ...    43   -7  -0.27   +0.78   \n",
       "3732  eng Premier League   22  1998  36  2785  ...    39  +14  +0.45   +0.59   \n",
       "3733          it Serie A   31  1990  33  2165  ...    39  -17  -0.71   +1.30   \n",
       "3734          it Serie A   29  1992  12   671  ...    10   -2  -0.27   -0.27   \n",
       "\n",
       "      onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "3715   0.9    5.5   -4.6    -2.66   -1.58  Matches  \n",
       "3716  36.9    8.9  +28.0    +2.41   +1.12  Matches  \n",
       "3717  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "3718     0      0      0        0       0  Matches  \n",
       "3719  24.4   11.5  +12.9    +0.88   +0.09  Matches  \n",
       "3720   6.3   12.2   -5.9    -0.84   -0.12  Matches  \n",
       "3721   6.3   12.6   -6.4    -0.96   -0.61  Matches  \n",
       "3722  17.3   24.4   -7.0    -0.45   +0.50  Matches  \n",
       "3723   0.8    1.9   -1.1    -1.25   -0.97  Matches  \n",
       "3724  27.7   29.5   -1.8    -0.08   -0.13  Matches  \n",
       "3725     0      0      0        0       0  Matches  \n",
       "3726   1.2    0.2   +1.0    +3.10   +3.88  Matches  \n",
       "3727  24.8   21.8   +3.0    +0.17   -0.40  Matches  \n",
       "3728  43.0   32.9  +10.1    +0.35   -0.09  Matches  \n",
       "3729     0      0      0        0       0  Matches  \n",
       "3730     0      0      0        0       0  Matches  \n",
       "3731  29.2   42.6  -13.4    -0.52   +0.11  Matches  \n",
       "3732  50.5   35.1  +15.4    +0.50   +0.87  Matches  \n",
       "3733  28.7   38.9  -10.2    -0.43   +0.86  Matches  \n",
       "3734  10.0   11.6   -1.6    -0.21   +0.09  Matches  \n",
       "\n",
       "[20 rows x 31 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[0].tail(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "executionInfo": {
     "elapsed": 12,
     "status": "ok",
     "timestamp": 1642638874776,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "owwSCuZYU-sT"
   },
   "outputs": [],
   "source": [
    "dfdata = df[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "laW205ykvn0S"
   },
   "source": [
    "Data cleaning"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "b-cH41xd54Tw"
   },
   "source": [
    "We can see that the table header is presented multiple times in several rows."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 1000
    },
    "executionInfo": {
     "elapsed": 11,
     "status": "ok",
     "timestamp": 1642638874776,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "6St9yeuZg9rf",
    "outputId": "c85fa8cd-7dcd-41bf-f00d-8d7bc4b110c6"
   },
   "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>Rk</th>\n",
       "      <th>Player</th>\n",
       "      <th>Nation</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Squad</th>\n",
       "      <th>Comp</th>\n",
       "      <th>Age</th>\n",
       "      <th>Born</th>\n",
       "      <th>MP</th>\n",
       "      <th>Min</th>\n",
       "      <th>...</th>\n",
       "      <th>onGA</th>\n",
       "      <th>+/-</th>\n",
       "      <th>+/-90</th>\n",
       "      <th>On-Off</th>\n",
       "      <th>onxG</th>\n",
       "      <th>onxGA</th>\n",
       "      <th>xG+/-</th>\n",
       "      <th>xG+/-90</th>\n",
       "      <th>On-Off</th>\n",
       "      <th>Matches</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3613</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3639</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3665</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3691</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3717</th>\n",
       "      <td>Rk</td>\n",
       "      <td>Player</td>\n",
       "      <td>Nation</td>\n",
       "      <td>Pos</td>\n",
       "      <td>Squad</td>\n",
       "      <td>Comp</td>\n",
       "      <td>Age</td>\n",
       "      <td>Born</td>\n",
       "      <td>MP</td>\n",
       "      <td>Min</td>\n",
       "      <td>...</td>\n",
       "      <td>onGA</td>\n",
       "      <td>+/-</td>\n",
       "      <td>+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>onxG</td>\n",
       "      <td>onxGA</td>\n",
       "      <td>xG+/-</td>\n",
       "      <td>xG+/-90</td>\n",
       "      <td>On-Off</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>143 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA  \\\n",
       "25    Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "51    Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "77    Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "103   Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "129   Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "...   ..     ...     ...  ...    ...   ...  ...   ...  ..  ...  ...   ...   \n",
       "3613  Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "3639  Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "3665  Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "3691  Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "3717  Rk  Player  Nation  Pos  Squad  Comp  Age  Born  MP  Min  ...  onGA   \n",
       "\n",
       "      +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "25    +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "51    +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "77    +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "103   +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "129   +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "...   ...    ...     ...   ...    ...    ...      ...     ...      ...  \n",
       "3613  +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "3639  +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "3665  +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "3691  +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "3717  +/-  +/-90  On-Off  onxG  onxGA  xG+/-  xG+/-90  On-Off  Matches  \n",
       "\n",
       "[143 rows x 31 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfdata[dfdata.Age == 'Age']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "executionInfo": {
     "elapsed": 10,
     "status": "ok",
     "timestamp": 1642638874776,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "rdRg9UDI5lus",
    "outputId": "fef4cc4f-cde3-427f-aeec-2b74fc79dfb8"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "143"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfdata[dfdata.Age == 'Age'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "executionInfo": {
     "elapsed": 9,
     "status": "ok",
     "timestamp": 1642638874777,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "lG34yiD5e_Cs"
   },
   "outputs": [],
   "source": [
    "dfplayingtime = dfdata.drop(dfdata[dfdata.Age == 'Age'].index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "executionInfo": {
     "elapsed": 9,
     "status": "ok",
     "timestamp": 1642638874777,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "QQHt_VHquyNJ",
    "outputId": "b614bbdf-2e49-4c2f-e813-40034d5c6223"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3592, 31)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfplayingtime.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "executionInfo": {
     "elapsed": 8,
     "status": "ok",
     "timestamp": 1642638874777,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "vZqC36KF8YqE",
    "outputId": "733d9576-4bda-45a6-be48-f4622cb6b56b"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', 'MP',\n",
       "       'Min', 'Mn/MP', 'Min%', '90s', 'Starts', 'Mn/Start', 'Compl', 'Subs',\n",
       "       'Mn/Sub', 'unSub', 'PPM', 'onG', 'onGA', '+/-', '+/-90', 'On-Off',\n",
       "       'onxG', 'onxGA', 'xG+/-', 'xG+/-90', 'On-Off', 'Matches'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfplayingtime.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "executionInfo": {
     "elapsed": 6,
     "status": "ok",
     "timestamp": 1642638875057,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "lE8fOs1T8Ywc"
   },
   "outputs": [],
   "source": [
    "#Convert string to float\n",
    "dfplayingtime['90s'] = dfplayingtime['90s'].astype(float)\n",
    "dfplayingtime['Starts'] = dfplayingtime['Starts'].astype(float)\n",
    "dfplayingtime['Mn/Start'] = dfplayingtime['Mn/Start'].astype(float)\n",
    "dfplayingtime['Compl'] = dfplayingtime['Compl'].astype(float)\n",
    "dfplayingtime['Subs'] = dfplayingtime['Subs'].astype(float)\n",
    "dfplayingtime['Mn/Sub'] = dfplayingtime['Mn/Sub'].astype(float)\n",
    "dfplayingtime['unSub'] = dfplayingtime['unSub'].astype(float)\n",
    "dfplayingtime['PPM'] = dfplayingtime['PPM'].astype(float)\n",
    "dfplayingtime['onG'] = dfplayingtime['onG'].astype(float)\n",
    "dfplayingtime['onGA'] = dfplayingtime['onGA'].astype(float)\n",
    "dfplayingtime['+/-'] = dfplayingtime['+/-'].astype(float)\n",
    "dfplayingtime['+/-90'] = dfplayingtime['+/-90'].astype(float)\n",
    "dfplayingtime['On-Off'] = dfplayingtime['On-Off'].astype(float)\n",
    "dfplayingtime['onxG'] = dfplayingtime['onxG'].astype(float)\n",
    "dfplayingtime['onxGA'] = dfplayingtime['onxGA'].astype(float)\n",
    "dfplayingtime['xG+/-'] = dfplayingtime['xG+/-'].astype(float)\n",
    "dfplayingtime['xG+/-90'] = dfplayingtime['xG+/-90'].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "executionInfo": {
     "elapsed": 5,
     "status": "ok",
     "timestamp": 1642638875057,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "MxbQETvym0T6"
   },
   "outputs": [],
   "source": [
    "#rename duplicate columns but not the first\n",
    "cols = []\n",
    "count = 1\n",
    "for column in dfplayingtime.columns:\n",
    "    if column == 'Onn-Off':\n",
    "        cols.append(f'On-Off_{count}')\n",
    "        count+=1\n",
    "        continue\n",
    "    cols.append(column)\n",
    "dfplayingtime.columns = cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "executionInfo": {
     "elapsed": 6,
     "status": "ok",
     "timestamp": 1642638875058,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "tAKvZSmo8c9F"
   },
   "outputs": [],
   "source": [
    "#turn data into p 90\n",
    "dfplayingtime['Starts'] = dfplayingtime['Starts'] / dfplayingtime['90s']\n",
    "dfplayingtime['Compl'] = dfplayingtime['Compl'] / dfplayingtime['90s']\n",
    "dfplayingtime['Mn/Sub'] = dfplayingtime['Mn/Sub'] / dfplayingtime['90s']\n",
    "dfplayingtime['PPM'] = dfplayingtime['PPM'] / dfplayingtime['90s']\n",
    "dfplayingtime['onG'] = dfplayingtime['onG'] / dfplayingtime['90s']\n",
    "dfplayingtime['Subs'] = dfplayingtime['Subs'] / dfplayingtime['90s']\n",
    "dfplayingtime['onG'] = dfplayingtime['onG'] / dfplayingtime['90s']\n",
    "dfplayingtime['+/-'] = dfplayingtime['+/-'] / dfplayingtime['90s']\n",
    "dfplayingtime['onGA'] = dfplayingtime['onGA'] / dfplayingtime['90s']\n",
    "dfplayingtime['onxG'] = dfplayingtime['onxG'] / dfplayingtime['90s']\n",
    "dfplayingtime['onxGA'] = dfplayingtime['onxGA'] / dfplayingtime['90s']\n",
    "dfplayingtime['xG+/-'] = dfplayingtime['xG+/-'] / dfplayingtime['90s']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 392
    },
    "executionInfo": {
     "elapsed": 6,
     "status": "ok",
     "timestamp": 1642638875058,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "NXoH9Vn1uyWI",
    "outputId": "05590611-c28c-4eb6-abc9-6ed5b0f81b2c"
   },
   "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>Rk</th>\n",
       "      <th>Player</th>\n",
       "      <th>Nation</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Squad</th>\n",
       "      <th>Comp</th>\n",
       "      <th>Age</th>\n",
       "      <th>Born</th>\n",
       "      <th>MP</th>\n",
       "      <th>Min</th>\n",
       "      <th>...</th>\n",
       "      <th>onGA</th>\n",
       "      <th>+/-</th>\n",
       "      <th>+/-90</th>\n",
       "      <th>On-Off</th>\n",
       "      <th>onxG</th>\n",
       "      <th>onxGA</th>\n",
       "      <th>xG+/-</th>\n",
       "      <th>xG+/-90</th>\n",
       "      <th>On-Off</th>\n",
       "      <th>Matches</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Max Aarons</td>\n",
       "      <td>eng ENG</td>\n",
       "      <td>DF</td>\n",
       "      <td>Norwich City</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>21</td>\n",
       "      <td>2000</td>\n",
       "      <td>34</td>\n",
       "      <td>2881</td>\n",
       "      <td>...</td>\n",
       "      <td>2.156250</td>\n",
       "      <td>-1.593750</td>\n",
       "      <td>-1.59</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.806250</td>\n",
       "      <td>1.900000</td>\n",
       "      <td>-1.093750</td>\n",
       "      <td>-1.09</td>\n",
       "      <td>0.35</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Yunis Abdelhamid</td>\n",
       "      <td>ma MAR</td>\n",
       "      <td>DF</td>\n",
       "      <td>Reims</td>\n",
       "      <td>fr Ligue 1</td>\n",
       "      <td>33</td>\n",
       "      <td>1987</td>\n",
       "      <td>34</td>\n",
       "      <td>2983</td>\n",
       "      <td>...</td>\n",
       "      <td>1.238671</td>\n",
       "      <td>-0.090634</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>0.969789</td>\n",
       "      <td>1.320242</td>\n",
       "      <td>-0.347432</td>\n",
       "      <td>-0.35</td>\n",
       "      <td>-0.58</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Salis Abdul Samed</td>\n",
       "      <td>gh GHA</td>\n",
       "      <td>MF</td>\n",
       "      <td>Clermont Foot</td>\n",
       "      <td>fr Ligue 1</td>\n",
       "      <td>21</td>\n",
       "      <td>2000</td>\n",
       "      <td>31</td>\n",
       "      <td>2462</td>\n",
       "      <td>...</td>\n",
       "      <td>1.569343</td>\n",
       "      <td>-0.620438</td>\n",
       "      <td>-0.62</td>\n",
       "      <td>0.69</td>\n",
       "      <td>1.083942</td>\n",
       "      <td>1.310219</td>\n",
       "      <td>-0.226277</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Suleiman Abdullahi</td>\n",
       "      <td>ng NGA</td>\n",
       "      <td>FW,MF</td>\n",
       "      <td>Union Berlin</td>\n",
       "      <td>de Bundesliga</td>\n",
       "      <td>24</td>\n",
       "      <td>1996</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Laurent Abergel</td>\n",
       "      <td>fr FRA</td>\n",
       "      <td>MF</td>\n",
       "      <td>Lorient</td>\n",
       "      <td>fr Ligue 1</td>\n",
       "      <td>28</td>\n",
       "      <td>1993</td>\n",
       "      <td>34</td>\n",
       "      <td>2956</td>\n",
       "      <td>...</td>\n",
       "      <td>1.798780</td>\n",
       "      <td>-0.975610</td>\n",
       "      <td>-0.97</td>\n",
       "      <td>-1.75</td>\n",
       "      <td>1.134146</td>\n",
       "      <td>1.466463</td>\n",
       "      <td>-0.335366</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>-0.86</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3730</th>\n",
       "      <td>3588</td>\n",
       "      <td>Emanuele Zuelli</td>\n",
       "      <td>it ITA</td>\n",
       "      <td>MF</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>19</td>\n",
       "      <td>2001</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3731</th>\n",
       "      <td>3589</td>\n",
       "      <td>Szymon Żurkowski</td>\n",
       "      <td>pl POL</td>\n",
       "      <td>MF</td>\n",
       "      <td>Empoli</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>23</td>\n",
       "      <td>1997</td>\n",
       "      <td>35</td>\n",
       "      <td>2307</td>\n",
       "      <td>...</td>\n",
       "      <td>1.679688</td>\n",
       "      <td>-0.273438</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>0.78</td>\n",
       "      <td>1.140625</td>\n",
       "      <td>1.664062</td>\n",
       "      <td>-0.523438</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>0.11</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3732</th>\n",
       "      <td>3590</td>\n",
       "      <td>Martin Ødegaard</td>\n",
       "      <td>no NOR</td>\n",
       "      <td>MF</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>eng Premier League</td>\n",
       "      <td>22</td>\n",
       "      <td>1998</td>\n",
       "      <td>36</td>\n",
       "      <td>2785</td>\n",
       "      <td>...</td>\n",
       "      <td>1.262136</td>\n",
       "      <td>0.453074</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.59</td>\n",
       "      <td>1.634304</td>\n",
       "      <td>1.135922</td>\n",
       "      <td>0.498382</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.87</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3733</th>\n",
       "      <td>3591</td>\n",
       "      <td>Milan Đurić</td>\n",
       "      <td>ba BIH</td>\n",
       "      <td>FW</td>\n",
       "      <td>Salernitana</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>31</td>\n",
       "      <td>1990</td>\n",
       "      <td>33</td>\n",
       "      <td>2165</td>\n",
       "      <td>...</td>\n",
       "      <td>1.618257</td>\n",
       "      <td>-0.705394</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1.190871</td>\n",
       "      <td>1.614108</td>\n",
       "      <td>-0.423237</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>0.86</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3734</th>\n",
       "      <td>3592</td>\n",
       "      <td>Filip Đuričić</td>\n",
       "      <td>rs SRB</td>\n",
       "      <td>MF,FW</td>\n",
       "      <td>Sassuolo</td>\n",
       "      <td>it Serie A</td>\n",
       "      <td>29</td>\n",
       "      <td>1992</td>\n",
       "      <td>12</td>\n",
       "      <td>671</td>\n",
       "      <td>...</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>-0.266667</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.546667</td>\n",
       "      <td>-0.213333</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>0.09</td>\n",
       "      <td>Matches</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3592 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Rk              Player   Nation    Pos          Squad  \\\n",
       "0        1          Max Aarons  eng ENG     DF   Norwich City   \n",
       "1        2    Yunis Abdelhamid   ma MAR     DF          Reims   \n",
       "2        3   Salis Abdul Samed   gh GHA     MF  Clermont Foot   \n",
       "3        4  Suleiman Abdullahi   ng NGA  FW,MF   Union Berlin   \n",
       "4        5     Laurent Abergel   fr FRA     MF        Lorient   \n",
       "...    ...                 ...      ...    ...            ...   \n",
       "3730  3588     Emanuele Zuelli   it ITA     MF       Juventus   \n",
       "3731  3589    Szymon Żurkowski   pl POL     MF         Empoli   \n",
       "3732  3590     Martin Ødegaard   no NOR     MF        Arsenal   \n",
       "3733  3591         Milan Đurić   ba BIH     FW    Salernitana   \n",
       "3734  3592       Filip Đuričić   rs SRB  MF,FW       Sassuolo   \n",
       "\n",
       "                    Comp Age  Born  MP   Min  ...      onGA       +/-  +/-90  \\\n",
       "0     eng Premier League  21  2000  34  2881  ...  2.156250 -1.593750  -1.59   \n",
       "1             fr Ligue 1  33  1987  34  2983  ...  1.238671 -0.090634  -0.09   \n",
       "2             fr Ligue 1  21  2000  31  2462  ...  1.569343 -0.620438  -0.62   \n",
       "3          de Bundesliga  24  1996   0     0  ...       NaN       NaN   0.00   \n",
       "4             fr Ligue 1  28  1993  34  2956  ...  1.798780 -0.975610  -0.97   \n",
       "...                  ...  ..   ...  ..   ...  ...       ...       ...    ...   \n",
       "3730          it Serie A  19  2001   0     0  ...       NaN       NaN   0.00   \n",
       "3731          it Serie A  23  1997  35  2307  ...  1.679688 -0.273438  -0.27   \n",
       "3732  eng Premier League  22  1998  36  2785  ...  1.262136  0.453074   0.45   \n",
       "3733          it Serie A  31  1990  33  2165  ...  1.618257 -0.705394  -0.71   \n",
       "3734          it Serie A  29  1992  12   671  ...  1.333333 -0.266667  -0.27   \n",
       "\n",
       "      On-Off      onxG     onxGA     xG+/-  xG+/-90  On-Off  Matches  \n",
       "0       0.08  0.806250  1.900000 -1.093750    -1.09    0.35  Matches  \n",
       "1      -0.50  0.969789  1.320242 -0.347432    -0.35   -0.58  Matches  \n",
       "2       0.69  1.083942  1.310219 -0.226277    -0.23   -0.05  Matches  \n",
       "3       0.00       NaN       NaN       NaN     0.00    0.00  Matches  \n",
       "4      -1.75  1.134146  1.466463 -0.335366    -0.33   -0.86  Matches  \n",
       "...      ...       ...       ...       ...      ...     ...      ...  \n",
       "3730    0.00       NaN       NaN       NaN     0.00    0.00  Matches  \n",
       "3731    0.78  1.140625  1.664062 -0.523438    -0.52    0.11  Matches  \n",
       "3732    0.59  1.634304  1.135922  0.498382     0.50    0.87  Matches  \n",
       "3733    1.30  1.190871  1.614108 -0.423237    -0.43    0.86  Matches  \n",
       "3734   -0.27  1.333333  1.546667 -0.213333    -0.21    0.09  Matches  \n",
       "\n",
       "[3592 rows x 31 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfplayingtime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfplayingtime['PlSqu'] = dfplayingtime['Player'] + dfplayingtime['Squad']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfplayingtime['Player'] = dfplayingtime['Player'].apply(unidecode)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfplayingtime['Squad'] = dfplayingtime['Squad'].apply(unidecode)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "executionInfo": {
     "elapsed": 226,
     "status": "ok",
     "timestamp": 1642638893092,
     "user": {
      "displayName": "Gary Davis",
      "photoUrl": "https://lh3.googleusercontent.com/a/default-user=s64",
      "userId": "10026740531512816388"
     },
     "user_tz": 360
    },
    "id": "xhSx7BPdvSjB"
   },
   "outputs": [],
   "source": [
    "dfplayingtime.to_csv('fbrefBig5PlayingTime.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "collapsed_sections": [],
   "name": "Scrape MLS Playing Time Stats.ipynb",
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}