Scrape_FBref.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Scrape_FBref.ipynb",
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9zGOV7uSk8ZT"
      },
      "source": [
        "This notebook is to scrape football data from fbref.com\n",
        "\n",
        "Much of the scraping code is taken from this repository: https://github.com/chmartin/FBref_EPL.\n",
        "\n",
        "Run the first cell and then the further cells to get data for whichever leagues you want.\n",
        "\n",
        "All data is courtesy of StatsBomb via FBref. Find me on Twitter @pathaleee!\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2qYGN7pfk3gK",
        "cellView": "form"
      },
      "source": [
        "#@title\n",
        "\n",
        "#standard(stats)\n",
        "stats = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"games\",\"games_starts\",\"minutes\",\"goals\",\"assists\",\"pens_made\",\"pens_att\",\"cards_yellow\",\"cards_red\",\"goals_per90\",\"assists_per90\",\"goals_assists_per90\",\"goals_pens_per90\",\"goals_assists_pens_per90\",\"xg\",\"npxg\",\"xa\",\"xg_per90\",\"xa_per90\",\"xg_xa_per90\",\"npxg_per90\",\"npxg_xa_per90\"]\n",
        "stats3 = [\"players_used\",\"possession\",\"games\",\"games_starts\",\"minutes\",\"goals\",\"assists\",\"pens_made\",\"pens_att\",\"cards_yellow\",\"cards_red\",\"goals_per90\",\"assists_per90\",\"goals_assists_per90\",\"goals_pens_per90\",\"goals_assists_pens_per90\",\"xg\",\"npxg\",\"xa\",\"xg_per90\",\"xa_per90\",\"xg_xa_per90\",\"npxg_per90\",\"npxg_xa_per90\"] \n",
        "#goalkeeping(keepers)\n",
        "keepers = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"games_gk\",\"games_starts_gk\",\"minutes_gk\",\"goals_against_gk\",\"goals_against_per90_gk\",\"shots_on_target_against\",\"saves\",\"save_pct\",\"wins_gk\",\"draws_gk\",\"losses_gk\",\"clean_sheets\",\"clean_sheets_pct\",\"pens_att_gk\",\"pens_allowed\",\"pens_saved\",\"pens_missed_gk\"]\n",
        "keepers3 = [\"players_used\",\"games_gk\",\"games_starts_gk\",\"minutes_gk\",\"goals_against_gk\",\"goals_against_per90_gk\",\"shots_on_target_against\",\"saves\",\"save_pct\",\"wins_gk\",\"draws_gk\",\"losses_gk\",\"clean_sheets\",\"clean_sheets_pct\",\"pens_att_gk\",\"pens_allowed\",\"pens_saved\",\"pens_missed_gk\"]\n",
        "#advance goalkeeping(keepersadv)\n",
        "keepersadv = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"goals_against_gk\",\"pens_allowed\",\"free_kick_goals_against_gk\",\"corner_kick_goals_against_gk\",\"own_goals_against_gk\",\"psxg_gk\",\"psnpxg_per_shot_on_target_against\",\"psxg_net_gk\",\"psxg_net_per90_gk\",\"passes_completed_launched_gk\",\"passes_launched_gk\",\"passes_pct_launched_gk\",\"passes_gk\",\"passes_throws_gk\",\"pct_passes_launched_gk\",\"passes_length_avg_gk\",\"goal_kicks\",\"pct_goal_kicks_launched\",\"goal_kick_length_avg\",\"crosses_gk\",\"crosses_stopped_gk\",\"crosses_stopped_pct_gk\",\"def_actions_outside_pen_area_gk\",\"def_actions_outside_pen_area_per90_gk\",\"avg_distance_def_actions_gk\"]\n",
        "keepersadv2 = [\"minutes_90s\",\"goals_against_gk\",\"pens_allowed\",\"free_kick_goals_against_gk\",\"corner_kick_goals_against_gk\",\"own_goals_against_gk\",\"psxg_gk\",\"psnpxg_per_shot_on_target_against\",\"psxg_net_gk\",\"psxg_net_per90_gk\",\"passes_completed_launched_gk\",\"passes_launched_gk\",\"passes_pct_launched_gk\",\"passes_gk\",\"passes_throws_gk\",\"pct_passes_launched_gk\",\"passes_length_avg_gk\",\"goal_kicks\",\"pct_goal_kicks_launched\",\"goal_kick_length_avg\",\"crosses_gk\",\"crosses_stopped_gk\",\"crosses_stopped_pct_gk\",\"def_actions_outside_pen_area_gk\",\"def_actions_outside_pen_area_per90_gk\",\"avg_distance_def_actions_gk\"]\n",
        "#shooting(shooting)\n",
        "shooting = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"goals\",\"pens_made\",\"pens_att\",\"shots_total\",\"shots_on_target\",\"shots_free_kicks\",\"shots_on_target_pct\",\"shots_total_per90\",\"shots_on_target_per90\",\"goals_per_shot\",\"goals_per_shot_on_target\",\"xg\",\"npxg\",\"npxg_per_shot\",\"xg_net\",\"npxg_net\"]\n",
        "shooting2 = [\"minutes_90s\",\"goals\",\"pens_made\",\"pens_att\",\"shots_total\",\"shots_on_target\",\"shots_free_kicks\",\"shots_on_target_pct\",\"shots_total_per90\",\"shots_on_target_per90\",\"goals_per_shot\",\"goals_per_shot_on_target\",\"xg\",\"npxg\",\"npxg_per_shot\",\"xg_net\",\"npxg_net\"]\n",
        "shooting3 = [\"goals\",\"pens_made\",\"pens_att\",\"shots_total\",\"shots_on_target\",\"shots_free_kicks\",\"shots_on_target_pct\",\"shots_total_per90\",\"shots_on_target_per90\",\"goals_per_shot\",\"goals_per_shot_on_target\",\"xg\",\"npxg\",\"npxg_per_shot\",\"xg_net\",\"npxg_net\"]\n",
        "#passing(passing)\n",
        "passing = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"passes_completed\",\"passes\",\"passes_pct\",\"passes_total_distance\",\"passes_progressive_distance\",\"passes_completed_short\",\"passes_short\",\"passes_pct_short\",\"passes_completed_medium\",\"passes_medium\",\"passes_pct_medium\",\"passes_completed_long\",\"passes_long\",\"passes_pct_long\",\"assists\",\"xa\",\"xa_net\",\"assisted_shots\",\"passes_into_final_third\",\"passes_into_penalty_area\",\"crosses_into_penalty_area\",\"progressive_passes\"]\n",
        "passing2 = [\"passes_completed\",\"passes\",\"passes_pct\",\"passes_total_distance\",\"passes_progressive_distance\",\"passes_completed_short\",\"passes_short\",\"passes_pct_short\",\"passes_completed_medium\",\"passes_medium\",\"passes_pct_medium\",\"passes_completed_long\",\"passes_long\",\"passes_pct_long\",\"assists\",\"xa\",\"xa_net\",\"assisted_shots\",\"passes_into_final_third\",\"passes_into_penalty_area\",\"crosses_into_penalty_area\",\"progressive_passes\"]\n",
        "#passtypes(passing_types)\n",
        "passing_types = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"passes\",\"passes_live\",\"passes_dead\",\"passes_free_kicks\",\"through_balls\",\"passes_pressure\",\"passes_switches\",\"crosses\",\"corner_kicks\",\"corner_kicks_in\",\"corner_kicks_out\",\"corner_kicks_straight\",\"passes_ground\",\"passes_low\",\"passes_high\",\"passes_left_foot\",\"passes_right_foot\",\"passes_head\",\"throw_ins\",\"passes_other_body\",\"passes_completed\",\"passes_offsides\",\"passes_oob\",\"passes_intercepted\",\"passes_blocked\"]\n",
        "passing_types2 = [\"passes\",\"passes_live\",\"passes_dead\",\"passes_free_kicks\",\"through_balls\",\"passes_pressure\",\"passes_switches\",\"crosses\",\"corner_kicks\",\"corner_kicks_in\",\"corner_kicks_out\",\"corner_kicks_straight\",\"passes_ground\",\"passes_low\",\"passes_high\",\"passes_left_foot\",\"passes_right_foot\",\"passes_head\",\"throw_ins\",\"passes_other_body\",\"passes_completed\",\"passes_offsides\",\"passes_oob\",\"passes_intercepted\",\"passes_blocked\"]\n",
        "#goal and shot creation(gca)\n",
        "gca = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"sca\",\"sca_per90\",\"sca_passes_live\",\"sca_passes_dead\",\"sca_dribbles\",\"sca_shots\",\"sca_fouled\",\"gca\",\"gca_per90\",\"gca_passes_live\",\"gca_passes_dead\",\"gca_dribbles\",\"gca_shots\",\"gca_fouled\",\"gca_defense\"]\n",
        "gca2 = [\"sca\",\"sca_per90\",\"sca_passes_live\",\"sca_passes_dead\",\"sca_dribbles\",\"sca_shots\",\"sca_fouled\",\"gca\",\"gca_per90\",\"gca_passes_live\",\"gca_passes_dead\",\"gca_dribbles\",\"gca_shots\",\"gca_fouled\",\"gca_defense\"]\n",
        "#defensive actions(defense)\n",
        "defense = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"tackles\",\"tackles_won\",\"tackles_def_3rd\",\"tackles_mid_3rd\",\"tackles_att_3rd\",\"dribble_tackles\",\"dribbles_vs\",\"dribble_tackles_pct\",\"dribbled_past\",\"pressures\",\"pressure_regains\",\"pressure_regain_pct\",\"pressures_def_3rd\",\"pressures_mid_3rd\",\"pressures_att_3rd\",\"blocks\",\"blocked_shots\",\"blocked_shots_saves\",\"blocked_passes\",\"interceptions\",\"clearances\",\"errors\"]\n",
        "defense2 = [\"tackles\",\"tackles_won\",\"tackles_def_3rd\",\"tackles_mid_3rd\",\"tackles_att_3rd\",\"dribble_tackles\",\"dribbles_vs\",\"dribble_tackles_pct\",\"dribbled_past\",\"pressures\",\"pressure_regains\",\"pressure_regain_pct\",\"pressures_def_3rd\",\"pressures_mid_3rd\",\"pressures_att_3rd\",\"blocks\",\"blocked_shots\",\"blocked_shots_saves\",\"blocked_passes\",\"interceptions\",\"clearances\",\"errors\"]\n",
        "#possession(possession)\n",
        "possession = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"touches\",\"touches_def_pen_area\",\"touches_def_3rd\",\"touches_mid_3rd\",\"touches_att_3rd\",\"touches_att_pen_area\",\"touches_live_ball\",\"dribbles_completed\",\"dribbles\",\"dribbles_completed_pct\",\"players_dribbled_past\",\"nutmegs\",\"carries\",\"carry_distance\",\"carry_progressive_distance\",\"progressive_carries\",\"carries_into_final_third\",\"carries_into_penalty_area\",\"pass_targets\",\"passes_received\",\"passes_received_pct\",\"miscontrols\",\"dispossessed\"]\n",
        "possession2 = [\"touches\",\"touches_def_pen_area\",\"touches_def_3rd\",\"touches_mid_3rd\",\"touches_att_3rd\",\"touches_att_pen_area\",\"touches_live_ball\",\"dribbles_completed\",\"dribbles\",\"dribbles_completed_pct\",\"players_dribbled_past\",\"nutmegs\",\"carries\",\"carry_distance\",\"carry_progressive_distance\",\"progressive_carries\",\"carries_into_final_third\",\"carries_into_penalty_area\",\"pass_targets\",\"passes_received\",\"passes_received_pct\",\"miscontrols\",\"dispossessed\"]\n",
        "#playingtime(playingtime)\n",
        "playingtime = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"games\",\"minutes\",\"minutes_per_game\",\"minutes_pct\",\"games_starts\",\"minutes_per_start\",\"games_subs\",\"minutes_per_sub\",\"unused_subs\",\"points_per_match\",\"on_goals_for\",\"on_goals_against\",\"plus_minus\",\"plus_minus_per90\",\"plus_minus_wowy\",\"on_xg_for\",\"on_xg_against\",\"xg_plus_minus\",\"xg_plus_minus_per90\",\"xg_plus_minus_wowy\"]\n",
        "playingtime2 = [\"games\",\"minutes\",\"minutes_per_game\",\"minutes_pct\",\"games_starts\",\"minutes_per_start\",\"games_subs\",\"minutes_per_sub\",\"unused_subs\",\"points_per_match\",\"on_goals_for\",\"on_goals_against\",\"plus_minus\",\"plus_minus_per90\",\"plus_minus_wowy\",\"on_xg_for\",\"on_xg_against\",\"xg_plus_minus\",\"xg_plus_minus_per90\",\"xg_plus_minus_wowy\"]\n",
        "#miscallaneous(misc)\n",
        "misc = [\"player\",\"nationality\",\"position\",\"squad\",\"age\",\"birth_year\",\"minutes_90s\",\"cards_yellow\",\"cards_red\",\"cards_yellow_red\",\"fouls\",\"fouled\",\"offsides\",\"crosses\",\"interceptions\",\"tackles_won\",\"pens_won\",\"pens_conceded\",\"own_goals\",\"ball_recoveries\",\"aerials_won\",\"aerials_lost\",\"aerials_won_pct\"]\n",
        "misc2 = [\"cards_yellow\",\"cards_red\",\"cards_yellow_red\",\"fouls\",\"fouled\",\"offsides\",\"crosses\",\"interceptions\",\"tackles_won\",\"pens_won\",\"pens_conceded\",\"own_goals\",\"ball_recoveries\",\"aerials_won\",\"aerials_lost\",\"aerials_won_pct\"]\n",
        "\n",
        "\n",
        "\n",
        "import requests\n",
        "from bs4 import BeautifulSoup\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "import re\n",
        "import sys, getopt\n",
        "import csv\n",
        "\n",
        "\n",
        "\n",
        "#Functions to get the data in a dataframe using BeautifulSoup\n",
        "\n",
        "def get_tables(url,text):\n",
        "    res = requests.get(url)\n",
        "    ## The next two lines get around the issue with comments breaking the parsing.\n",
        "    comm = re.compile(\"<!--|-->\")\n",
        "    soup = BeautifulSoup(comm.sub(\"\",res.text),'lxml')\n",
        "    all_tables = soup.findAll(\"tbody\")\n",
        "    \n",
        "    team_table = all_tables[0]\n",
        "    team_vs_table = all_tables[1]\n",
        "    player_table = all_tables[2]\n",
        "    if text == 'for':\n",
        "      return player_table, team_table\n",
        "    if text == 'vs':\n",
        "      return player_table, team_vs_table\n",
        "\n",
        "def get_frame(features, player_table):\n",
        "    pre_df_player = dict()\n",
        "    features_wanted_player = features\n",
        "    rows_player = player_table.find_all('tr')\n",
        "    for row in rows_player:\n",
        "        if(row.find('th',{\"scope\":\"row\"}) != None):\n",
        "    \n",
        "            for f in features_wanted_player:\n",
        "                cell = row.find(\"td\",{\"data-stat\": f})\n",
        "                a = cell.text.strip().encode()\n",
        "                text=a.decode(\"utf-8\")\n",
        "                if(text == ''):\n",
        "                    text = '0'\n",
        "                if((f!='player')&(f!='nationality')&(f!='position')&(f!='squad')&(f!='age')&(f!='birth_year')):\n",
        "                    text = float(text.replace(',',''))\n",
        "                if f in pre_df_player:\n",
        "                    pre_df_player[f].append(text)\n",
        "                else:\n",
        "                    pre_df_player[f] = [text]\n",
        "    df_player = pd.DataFrame.from_dict(pre_df_player)\n",
        "    return df_player\n",
        "\n",
        "def get_frame_team(features, team_table):\n",
        "    pre_df_squad = dict()\n",
        "    #Note: features does not contain squad name, it requires special treatment\n",
        "    features_wanted_squad = features\n",
        "    rows_squad = team_table.find_all('tr')\n",
        "    for row in rows_squad:\n",
        "        if(row.find('th',{\"scope\":\"row\"}) != None):\n",
        "            name = row.find('th',{\"data-stat\":\"squad\"}).text.strip().encode().decode(\"utf-8\")\n",
        "            if 'squad' in pre_df_squad:\n",
        "                pre_df_squad['squad'].append(name)\n",
        "            else:\n",
        "                pre_df_squad['squad'] = [name]\n",
        "            for f in features_wanted_squad:\n",
        "                cell = row.find(\"td\",{\"data-stat\": f})\n",
        "                a = cell.text.strip().encode()\n",
        "                text=a.decode(\"utf-8\")\n",
        "                if(text == ''):\n",
        "                    text = '0'\n",
        "                if((f!='player')&(f!='nationality')&(f!='position')&(f!='squad')&(f!='age')&(f!='birth_year')):\n",
        "                    text = float(text.replace(',',''))\n",
        "                if f in pre_df_squad:\n",
        "                    pre_df_squad[f].append(text)\n",
        "                else:\n",
        "                    pre_df_squad[f] = [text]\n",
        "    df_squad = pd.DataFrame.from_dict(pre_df_squad)\n",
        "    return df_squad\n",
        "\n",
        "def frame_for_category(category,top,end,features):\n",
        "    url = (top + category + end)\n",
        "    player_table, team_table = get_tables(url,'for')\n",
        "    df_player = get_frame(features, player_table)\n",
        "    return df_player\n",
        "\n",
        "def frame_for_category_team(category,top,end,features,text):\n",
        "    url = (top + category + end)\n",
        "    player_table, team_table = get_tables(url,text)\n",
        "    df_team = get_frame_team(features, team_table)\n",
        "    return df_team\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "#Function to get the player data for outfield player, includes all categories - standard stats, shooting\n",
        "#passing, passing types, goal and shot creation, defensive actions, possession, and miscallaneous\n",
        "def get_outfield_data(top, end):\n",
        "    df1 = frame_for_category('stats',top,end,stats)\n",
        "    df2 = frame_for_category('shooting',top,end,shooting2)\n",
        "    df3 = frame_for_category('passing',top,end,passing2)\n",
        "    df4 = frame_for_category('passing_types',top,end,passing_types2)\n",
        "    df5 = frame_for_category('gca',top,end,gca2)\n",
        "    df6 = frame_for_category('defense',top,end,defense2)\n",
        "    df7 = frame_for_category('possession',top,end,possession2)\n",
        "    df8 = frame_for_category('misc',top,end,misc2)\n",
        "    df = pd.concat([df1, df2, df3, df4, df5, df6, df7, df8], axis=1)\n",
        "    df = df.loc[:,~df.columns.duplicated()]\n",
        "    return df\n",
        "\n",
        "\n",
        "#Function to get keeping and advance goalkeeping data\n",
        "def get_keeper_data(top,end):\n",
        "    df1 = frame_for_category('keepers',top,end,keepers)\n",
        "    df2 = frame_for_category('keepersadv',top,end,keepersadv2)\n",
        "    df = pd.concat([df1, df2], axis=1)\n",
        "    df = df.loc[:,~df.columns.duplicated()]\n",
        "    return df\n",
        "\n",
        "\n",
        "\n",
        "#Function to get team-wise data accross all categories as mentioned above\n",
        "def get_team_data(top,end,text):\n",
        "    df1 = frame_for_category_team('stats',top,end,stats3,text)\n",
        "    df2 = frame_for_category_team('keepers',top,end,keepers3,text)\n",
        "    df3 = frame_for_category_team('keepersadv',top,end,keepersadv2,text)\n",
        "    df4 = frame_for_category_team('shooting',top,end,shooting3,text)\n",
        "    df5 = frame_for_category_team('passing',top,end,passing2,text)\n",
        "    df6 = frame_for_category_team('passing_types',top,end,passing_types2,text)\n",
        "    df7 = frame_for_category_team('gca',top,end,gca2,text)\n",
        "    df8 = frame_for_category_team('defense',top,end,defense2,text)\n",
        "    df9 = frame_for_category_team('possession',top,end,possession2,text)\n",
        "    df10 = frame_for_category_team('misc',top,end,misc2,text)\n",
        "    df = pd.concat([df1, df2, df3, df4, df5, df6, df7, df8, df9, df10], axis=1)\n",
        "    df = df.loc[:,~df.columns.duplicated()]\n",
        "    return df\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 653
        },
        "id": "gPK7Y54NmUVA",
        "outputId": "070bcbb1-ad32-4322-d34f-fa09ff24bae9"
      },
      "source": [
        "#This cell is to get the outfield player data for any competition\n",
        "\n",
        "#Go to the 'Standard stats' page of the league\n",
        "#For Premier League 2020/21, the link is this: https://fbref.com/en/comps/9/stats/Premier-League-Stats\n",
        "#Remove the 'stats', and pass the first and third part of the link as parameters like below\n",
        "df_outfield = get_outfield_data('https://fbref.com/en/comps/9/','/Premier-League-Stats')\n",
        "\n",
        "#Save csv file to Desktop\n",
        "df_outfield.to_csv('PL2021_Outfield.csv',index=False)\n",
        "\n",
        "df_outfield"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                   player nationality position            squad     age  \\\n",
              "0              Max Aarons     eng ENG       DF     Norwich City  22-076   \n",
              "1               Che Adams     sct SCO       FW      Southampton  25-251   \n",
              "2         Rayan Aït Nouri      fr FRA       DF           Wolves  20-288   \n",
              "3         Kristoffer Ajer      no NOR       DF        Brentford  23-338   \n",
              "4              Nathan Aké      nl NED       DF  Manchester City  27-031   \n",
              "..                    ...         ...      ...              ...     ...   \n",
              "524  Christoph Zimmermann      de GER       DF     Norwich City  29-068   \n",
              "525   Oleksandr Zinchenko      ua UKR       DF  Manchester City  25-096   \n",
              "526          Hakim Ziyech      ma MAR    FW,MF          Chelsea  29-002   \n",
              "527            Kurt Zouma      fr FRA       DF         West Ham  27-145   \n",
              "528       Martin Ødegaard      no NOR       MF          Arsenal  23-094   \n",
              "\n",
              "    birth_year  games  games_starts  minutes  goals  ...  fouls  fouled  \\\n",
              "0         2000   28.0          27.0   2398.0    0.0  ...   27.0    47.0   \n",
              "1         1996   23.0          19.0   1647.0    7.0  ...   25.0    38.0   \n",
              "2         2001   17.0          15.0   1373.0    0.0  ...   16.0    16.0   \n",
              "3         1998   17.0          16.0   1405.0    0.0  ...   16.0    15.0   \n",
              "4         1995    9.0           7.0    671.0    1.0  ...    6.0     2.0   \n",
              "..         ...    ...           ...      ...    ...  ...    ...     ...   \n",
              "524       1993    1.0           1.0     45.0    0.0  ...    0.0     1.0   \n",
              "525       1996    8.0           6.0    597.0    0.0  ...    5.0     4.0   \n",
              "526       1993   15.0          11.0    966.0    4.0  ...   22.0    31.0   \n",
              "527       1994   18.0          18.0   1600.0    1.0  ...   10.0     7.0   \n",
              "528       1998   26.0          22.0   1886.0    5.0  ...   22.0    16.0   \n",
              "\n",
              "     offsides  pens_won  pens_conceded  own_goals  ball_recoveries  \\\n",
              "0         1.0       0.0            2.0        1.0            145.0   \n",
              "1         7.0       0.0            0.0        0.0            105.0   \n",
              "2         2.0       1.0            0.0        0.0            102.0   \n",
              "3         0.0       0.0            0.0        0.0            129.0   \n",
              "4         0.0       0.0            0.0        0.0             56.0   \n",
              "..        ...       ...            ...        ...              ...   \n",
              "524       0.0       0.0            0.0        0.0              3.0   \n",
              "525       0.0       0.0            0.0        0.0             54.0   \n",
              "526       5.0       0.0            0.0        0.0            100.0   \n",
              "527       0.0       0.0            0.0        1.0            133.0   \n",
              "528       2.0       0.0            1.0        0.0            160.0   \n",
              "\n",
              "     aerials_won  aerials_lost  aerials_won_pct  \n",
              "0           14.0          44.0             24.1  \n",
              "1           43.0          85.0             33.6  \n",
              "2           18.0          19.0             48.6  \n",
              "3           46.0          27.0             63.0  \n",
              "4           31.0           5.0             86.1  \n",
              "..           ...           ...              ...  \n",
              "524          0.0           0.0              0.0  \n",
              "525          9.0          10.0             47.4  \n",
              "526          9.0          15.0             37.5  \n",
              "527         46.0          17.0             73.0  \n",
              "528         13.0          15.0             46.4  \n",
              "\n",
              "[529 rows x 154 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-45484c31-c484-4664-914a-9204084767bd\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>player</th>\n",
              "      <th>nationality</th>\n",
              "      <th>position</th>\n",
              "      <th>squad</th>\n",
              "      <th>age</th>\n",
              "      <th>birth_year</th>\n",
              "      <th>games</th>\n",
              "      <th>games_starts</th>\n",
              "      <th>minutes</th>\n",
              "      <th>goals</th>\n",
              "      <th>...</th>\n",
              "      <th>fouls</th>\n",
              "      <th>fouled</th>\n",
              "      <th>offsides</th>\n",
              "      <th>pens_won</th>\n",
              "      <th>pens_conceded</th>\n",
              "      <th>own_goals</th>\n",
              "      <th>ball_recoveries</th>\n",
              "      <th>aerials_won</th>\n",
              "      <th>aerials_lost</th>\n",
              "      <th>aerials_won_pct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Max Aarons</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>DF</td>\n",
              "      <td>Norwich City</td>\n",
              "      <td>22-076</td>\n",
              "      <td>2000</td>\n",
              "      <td>28.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>2398.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>27.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>145.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>44.0</td>\n",
              "      <td>24.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Che Adams</td>\n",
              "      <td>sct SCO</td>\n",
              "      <td>FW</td>\n",
              "      <td>Southampton</td>\n",
              "      <td>25-251</td>\n",
              "      <td>1996</td>\n",
              "      <td>23.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>1647.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>...</td>\n",
              "      <td>25.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>105.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>33.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Rayan Aït Nouri</td>\n",
              "      <td>fr FRA</td>\n",
              "      <td>DF</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>20-288</td>\n",
              "      <td>2001</td>\n",
              "      <td>17.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>1373.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>16.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>102.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>48.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Kristoffer Ajer</td>\n",
              "      <td>no NOR</td>\n",
              "      <td>DF</td>\n",
              "      <td>Brentford</td>\n",
              "      <td>23-338</td>\n",
              "      <td>1998</td>\n",
              "      <td>17.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>1405.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>16.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>129.0</td>\n",
              "      <td>46.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>63.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Nathan Aké</td>\n",
              "      <td>nl NED</td>\n",
              "      <td>DF</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>27-031</td>\n",
              "      <td>1995</td>\n",
              "      <td>9.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>671.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>6.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>86.1</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>524</th>\n",
              "      <td>Christoph Zimmermann</td>\n",
              "      <td>de GER</td>\n",
              "      <td>DF</td>\n",
              "      <td>Norwich City</td>\n",
              "      <td>29-068</td>\n",
              "      <td>1993</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>525</th>\n",
              "      <td>Oleksandr Zinchenko</td>\n",
              "      <td>ua UKR</td>\n",
              "      <td>DF</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>25-096</td>\n",
              "      <td>1996</td>\n",
              "      <td>8.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>597.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>5.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>54.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>47.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>526</th>\n",
              "      <td>Hakim Ziyech</td>\n",
              "      <td>ma MAR</td>\n",
              "      <td>FW,MF</td>\n",
              "      <td>Chelsea</td>\n",
              "      <td>29-002</td>\n",
              "      <td>1993</td>\n",
              "      <td>15.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>966.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>22.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>37.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>527</th>\n",
              "      <td>Kurt Zouma</td>\n",
              "      <td>fr FRA</td>\n",
              "      <td>DF</td>\n",
              "      <td>West Ham</td>\n",
              "      <td>27-145</td>\n",
              "      <td>1994</td>\n",
              "      <td>18.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1600.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>10.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>133.0</td>\n",
              "      <td>46.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>73.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>528</th>\n",
              "      <td>Martin Ødegaard</td>\n",
              "      <td>no NOR</td>\n",
              "      <td>MF</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>23-094</td>\n",
              "      <td>1998</td>\n",
              "      <td>26.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>1886.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>22.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>46.4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>529 rows × 154 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-45484c31-c484-4664-914a-9204084767bd')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http:https://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-45484c31-c484-4664-914a-9204084767bd button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-45484c31-c484-4664-914a-9204084767bd');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 847
        },
        "id": "5e_hIIV3mYP-",
        "outputId": "613375c0-e015-4e4e-f18d-ff8778e13a9a"
      },
      "source": [
        "#This cell is to get the data FOR all teams in any competition\n",
        "\n",
        "#Go to the 'Standard stats' page of the league\n",
        "#For Premier League 2020/21, the link is this: https://fbref.com/en/comps/9/stats/Premier-League-Stats\n",
        "#Remove the 'stats', and pass the first and third part of the link as parameters like below\n",
        "df_team = get_team_data('https://fbref.com/en/comps/9/','/Premier-League-Stats','for')\n",
        "\n",
        "#Save csv file to Desktop\n",
        "df_team.to_csv('PL2021_teams.csv',index=False)\n",
        "\n",
        "df_team"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              squad  players_used  possession  games  games_starts  minutes  \\\n",
              "0           Arsenal          27.0        51.8   28.0         308.0   2520.0   \n",
              "1       Aston Villa          30.0        46.2   29.0         319.0   2610.0   \n",
              "2         Brentford          28.0        44.2   30.0         330.0   2700.0   \n",
              "3          Brighton          25.0        57.0   29.0         319.0   2610.0   \n",
              "4           Burnley          22.0        38.9   27.0         297.0   2430.0   \n",
              "5           Chelsea          25.0        60.1   28.0         308.0   2520.0   \n",
              "6    Crystal Palace          24.0        50.4   29.0         319.0   2610.0   \n",
              "7           Everton          32.0        41.6   27.0         297.0   2430.0   \n",
              "8      Leeds United          29.0        54.3   30.0         330.0   2700.0   \n",
              "9    Leicester City          25.0        50.1   27.0         297.0   2430.0   \n",
              "10        Liverpool          27.0        62.3   29.0         319.0   2610.0   \n",
              "11  Manchester City          25.0        68.4   29.0         319.0   2610.0   \n",
              "12   Manchester Utd          25.0        52.9   29.0         319.0   2610.0   \n",
              "13    Newcastle Utd          29.0        39.8   29.0         319.0   2610.0   \n",
              "14     Norwich City          27.0        43.0   29.0         319.0   2610.0   \n",
              "15      Southampton          25.0        49.6   29.0         319.0   2610.0   \n",
              "16        Tottenham          25.0        51.7   29.0         319.0   2610.0   \n",
              "17          Watford          30.0        40.9   29.0         319.0   2610.0   \n",
              "18         West Ham          25.0        47.4   30.0         330.0   2700.0   \n",
              "19           Wolves          24.0        49.6   30.0         330.0   2700.0   \n",
              "\n",
              "    goals  assists  pens_made  pens_att  ...  fouls  fouled  offsides  \\\n",
              "0    43.0     31.0        2.0       5.0  ...  311.0   320.0      50.0   \n",
              "1    39.0     33.0        2.0       2.0  ...  363.0   457.0      37.0   \n",
              "2    32.0     20.0        6.0       6.0  ...  371.0   341.0      61.0   \n",
              "3    25.0     21.0        3.0       4.0  ...  360.0   332.0      38.0   \n",
              "4    20.0     17.0        0.0       0.0  ...  340.0   270.0      75.0   \n",
              "5    56.0     40.0        7.0       7.0  ...  359.0   390.0      54.0   \n",
              "6    39.0     25.0        4.0       5.0  ...  372.0   424.0      47.0   \n",
              "7    28.0     21.0        3.0       4.0  ...  323.0   334.0      47.0   \n",
              "8    34.0     22.0        4.0       4.0  ...  437.0   363.0      55.0   \n",
              "9    42.0     31.0        2.0       2.0  ...  307.0   352.0      51.0   \n",
              "10   75.0     55.0        6.0       7.0  ...  333.0   298.0      48.0   \n",
              "11   66.0     40.0        6.0       7.0  ...  300.0   335.0      54.0   \n",
              "12   47.0     40.0        2.0       3.0  ...  364.0   321.0      62.0   \n",
              "13   30.0     19.0        1.0       1.0  ...  391.0   346.0      44.0   \n",
              "14   16.0     12.0        3.0       3.0  ...  356.0   398.0      47.0   \n",
              "15   34.0     22.0        3.0       3.0  ...  400.0   344.0      30.0   \n",
              "16   41.0     34.0        3.0       3.0  ...  355.0   397.0      51.0   \n",
              "17   29.0     23.0        1.0       2.0  ...  427.0   302.0      38.0   \n",
              "18   47.0     40.0        3.0       5.0  ...  292.0   273.0      47.0   \n",
              "19   29.0     18.0        1.0       1.0  ...  369.0   343.0      53.0   \n",
              "\n",
              "    pens_won  pens_conceded  own_goals  ball_recoveries  aerials_won  \\\n",
              "0        4.0            3.0        0.0           2319.0        427.0   \n",
              "1        1.0            5.0        1.0           2312.0        460.0   \n",
              "2        6.0            2.0        2.0           2753.0        651.0   \n",
              "3        3.0            4.0        0.0           2585.0        481.0   \n",
              "4        0.0            0.0        1.0           2472.0        724.0   \n",
              "5        6.0            4.0        1.0           2294.0        452.0   \n",
              "6        4.0            4.0        2.0           2516.0        565.0   \n",
              "7        4.0            1.0        4.0           2420.0        493.0   \n",
              "8        3.0            5.0        1.0           2590.0        413.0   \n",
              "9        1.0            7.0        1.0           2164.0        446.0   \n",
              "10       4.0            0.0        1.0           2911.0        476.0   \n",
              "11       5.0            1.0        0.0           2316.0        393.0   \n",
              "12       2.0            4.0        3.0           2459.0        496.0   \n",
              "13       0.0            6.0        2.0           2284.0        617.0   \n",
              "14       2.0           10.0        2.0           2219.0        460.0   \n",
              "15       3.0            1.0        1.0           2714.0        576.0   \n",
              "16       2.0            2.0        1.0           2205.0        488.0   \n",
              "17       2.0            4.0        3.0           2498.0        636.0   \n",
              "18       3.0            2.0        1.0           2526.0        569.0   \n",
              "19       1.0            5.0        1.0           2449.0        450.0   \n",
              "\n",
              "    aerials_lost  aerials_won_pct  \n",
              "0          497.0             46.2  \n",
              "1          499.0             48.0  \n",
              "2          664.0             49.5  \n",
              "3          481.0             50.0  \n",
              "4          649.0             52.7  \n",
              "5          421.0             51.8  \n",
              "6          502.0             53.0  \n",
              "7          612.0             44.6  \n",
              "8          502.0             45.1  \n",
              "9          422.0             51.4  \n",
              "10         411.0             53.7  \n",
              "11         331.0             54.3  \n",
              "12         389.0             56.0  \n",
              "13         578.0             51.6  \n",
              "14         528.0             46.6  \n",
              "15         693.0             45.4  \n",
              "16         416.0             54.0  \n",
              "17         651.0             49.4  \n",
              "18         555.0             50.6  \n",
              "19         472.0             48.8  \n",
              "\n",
              "[20 rows x 191 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c1495302-8527-4093-b97e-c31adf8f5d54\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>squad</th>\n",
              "      <th>players_used</th>\n",
              "      <th>possession</th>\n",
              "      <th>games</th>\n",
              "      <th>games_starts</th>\n",
              "      <th>minutes</th>\n",
              "      <th>goals</th>\n",
              "      <th>assists</th>\n",
              "      <th>pens_made</th>\n",
              "      <th>pens_att</th>\n",
              "      <th>...</th>\n",
              "      <th>fouls</th>\n",
              "      <th>fouled</th>\n",
              "      <th>offsides</th>\n",
              "      <th>pens_won</th>\n",
              "      <th>pens_conceded</th>\n",
              "      <th>own_goals</th>\n",
              "      <th>ball_recoveries</th>\n",
              "      <th>aerials_won</th>\n",
              "      <th>aerials_lost</th>\n",
              "      <th>aerials_won_pct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Arsenal</td>\n",
              "      <td>27.0</td>\n",
              "      <td>51.8</td>\n",
              "      <td>28.0</td>\n",
              "      <td>308.0</td>\n",
              "      <td>2520.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>311.0</td>\n",
              "      <td>320.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2319.0</td>\n",
              "      <td>427.0</td>\n",
              "      <td>497.0</td>\n",
              "      <td>46.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Aston Villa</td>\n",
              "      <td>30.0</td>\n",
              "      <td>46.2</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>39.0</td>\n",
              "      <td>33.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>363.0</td>\n",
              "      <td>457.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2312.0</td>\n",
              "      <td>460.0</td>\n",
              "      <td>499.0</td>\n",
              "      <td>48.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Brentford</td>\n",
              "      <td>28.0</td>\n",
              "      <td>44.2</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>...</td>\n",
              "      <td>371.0</td>\n",
              "      <td>341.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2753.0</td>\n",
              "      <td>651.0</td>\n",
              "      <td>664.0</td>\n",
              "      <td>49.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Brighton</td>\n",
              "      <td>25.0</td>\n",
              "      <td>57.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>21.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>360.0</td>\n",
              "      <td>332.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2585.0</td>\n",
              "      <td>481.0</td>\n",
              "      <td>481.0</td>\n",
              "      <td>50.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Burnley</td>\n",
              "      <td>22.0</td>\n",
              "      <td>38.9</td>\n",
              "      <td>27.0</td>\n",
              "      <td>297.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>340.0</td>\n",
              "      <td>270.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2472.0</td>\n",
              "      <td>724.0</td>\n",
              "      <td>649.0</td>\n",
              "      <td>52.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Chelsea</td>\n",
              "      <td>25.0</td>\n",
              "      <td>60.1</td>\n",
              "      <td>28.0</td>\n",
              "      <td>308.0</td>\n",
              "      <td>2520.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>...</td>\n",
              "      <td>359.0</td>\n",
              "      <td>390.0</td>\n",
              "      <td>54.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2294.0</td>\n",
              "      <td>452.0</td>\n",
              "      <td>421.0</td>\n",
              "      <td>51.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Crystal Palace</td>\n",
              "      <td>24.0</td>\n",
              "      <td>50.4</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>39.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>372.0</td>\n",
              "      <td>424.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2516.0</td>\n",
              "      <td>565.0</td>\n",
              "      <td>502.0</td>\n",
              "      <td>53.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Everton</td>\n",
              "      <td>32.0</td>\n",
              "      <td>41.6</td>\n",
              "      <td>27.0</td>\n",
              "      <td>297.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>21.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>323.0</td>\n",
              "      <td>334.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2420.0</td>\n",
              "      <td>493.0</td>\n",
              "      <td>612.0</td>\n",
              "      <td>44.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Leeds United</td>\n",
              "      <td>29.0</td>\n",
              "      <td>54.3</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>437.0</td>\n",
              "      <td>363.0</td>\n",
              "      <td>55.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2590.0</td>\n",
              "      <td>413.0</td>\n",
              "      <td>502.0</td>\n",
              "      <td>45.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Leicester City</td>\n",
              "      <td>25.0</td>\n",
              "      <td>50.1</td>\n",
              "      <td>27.0</td>\n",
              "      <td>297.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>42.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>307.0</td>\n",
              "      <td>352.0</td>\n",
              "      <td>51.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2164.0</td>\n",
              "      <td>446.0</td>\n",
              "      <td>422.0</td>\n",
              "      <td>51.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Liverpool</td>\n",
              "      <td>27.0</td>\n",
              "      <td>62.3</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>55.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>...</td>\n",
              "      <td>333.0</td>\n",
              "      <td>298.0</td>\n",
              "      <td>48.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2911.0</td>\n",
              "      <td>476.0</td>\n",
              "      <td>411.0</td>\n",
              "      <td>53.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Manchester City</td>\n",
              "      <td>25.0</td>\n",
              "      <td>68.4</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>...</td>\n",
              "      <td>300.0</td>\n",
              "      <td>335.0</td>\n",
              "      <td>54.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2316.0</td>\n",
              "      <td>393.0</td>\n",
              "      <td>331.0</td>\n",
              "      <td>54.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Manchester Utd</td>\n",
              "      <td>25.0</td>\n",
              "      <td>52.9</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>364.0</td>\n",
              "      <td>321.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2459.0</td>\n",
              "      <td>496.0</td>\n",
              "      <td>389.0</td>\n",
              "      <td>56.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Newcastle Utd</td>\n",
              "      <td>29.0</td>\n",
              "      <td>39.8</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>391.0</td>\n",
              "      <td>346.0</td>\n",
              "      <td>44.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2284.0</td>\n",
              "      <td>617.0</td>\n",
              "      <td>578.0</td>\n",
              "      <td>51.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Norwich City</td>\n",
              "      <td>27.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>356.0</td>\n",
              "      <td>398.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2219.0</td>\n",
              "      <td>460.0</td>\n",
              "      <td>528.0</td>\n",
              "      <td>46.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Southampton</td>\n",
              "      <td>25.0</td>\n",
              "      <td>49.6</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>400.0</td>\n",
              "      <td>344.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2714.0</td>\n",
              "      <td>576.0</td>\n",
              "      <td>693.0</td>\n",
              "      <td>45.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Tottenham</td>\n",
              "      <td>25.0</td>\n",
              "      <td>51.7</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>355.0</td>\n",
              "      <td>397.0</td>\n",
              "      <td>51.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2205.0</td>\n",
              "      <td>488.0</td>\n",
              "      <td>416.0</td>\n",
              "      <td>54.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Watford</td>\n",
              "      <td>30.0</td>\n",
              "      <td>40.9</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>427.0</td>\n",
              "      <td>302.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2498.0</td>\n",
              "      <td>636.0</td>\n",
              "      <td>651.0</td>\n",
              "      <td>49.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>West Ham</td>\n",
              "      <td>25.0</td>\n",
              "      <td>47.4</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>292.0</td>\n",
              "      <td>273.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2526.0</td>\n",
              "      <td>569.0</td>\n",
              "      <td>555.0</td>\n",
              "      <td>50.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Wolves</td>\n",
              "      <td>24.0</td>\n",
              "      <td>49.6</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>369.0</td>\n",
              "      <td>343.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2449.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>472.0</td>\n",
              "      <td>48.8</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>20 rows × 191 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c1495302-8527-4093-b97e-c31adf8f5d54')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http:https://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c1495302-8527-4093-b97e-c31adf8f5d54 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c1495302-8527-4093-b97e-c31adf8f5d54');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 949
        },
        "id": "vuOBpUtwmbmI",
        "outputId": "60a0be51-0d86-4e38-8a1a-3224bcac7bf0"
      },
      "source": [
        "#This cell is to get the data VS all teams in any competition\n",
        "\n",
        "#Go to the 'Standard stats' page of the league\n",
        "#For Premier League 2020/21, the link is this: https://fbref.com/en/comps/9/stats/Premier-League-Stats\n",
        "#Remove the 'stats', and pass the first and third part of the link as parameters like below\n",
        "df_team = get_team_data('https://fbref.com/en/comps/9/','/Premier-League-Stats','vs')\n",
        "\n",
        "#Save csv file to Desktop\n",
        "df_team.to_csv('PL2021_teams_vs.csv',index=False)\n",
        "\n",
        "df_team"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 squad  players_used  possession  games  games_starts  \\\n",
              "0           vs Arsenal          27.0        48.2   28.0         308.0   \n",
              "1       vs Aston Villa          30.0        53.8   29.0         319.0   \n",
              "2         vs Brentford          28.0        55.8   30.0         330.0   \n",
              "3          vs Brighton          25.0        43.0   29.0         319.0   \n",
              "4           vs Burnley          22.0        61.1   27.0         297.0   \n",
              "5           vs Chelsea          25.0        39.9   28.0         308.0   \n",
              "6    vs Crystal Palace          24.0        49.6   29.0         319.0   \n",
              "7           vs Everton          32.0        58.4   27.0         297.0   \n",
              "8      vs Leeds United          29.0        45.7   30.0         330.0   \n",
              "9    vs Leicester City          25.0        49.9   27.0         297.0   \n",
              "10        vs Liverpool          27.0        37.7   29.0         319.0   \n",
              "11  vs Manchester City          25.0        31.6   29.0         319.0   \n",
              "12   vs Manchester Utd          25.0        47.1   29.0         319.0   \n",
              "13    vs Newcastle Utd          29.0        60.2   29.0         319.0   \n",
              "14     vs Norwich City          27.0        57.0   29.0         319.0   \n",
              "15      vs Southampton          25.0        50.4   29.0         319.0   \n",
              "16        vs Tottenham          25.0        48.3   29.0         319.0   \n",
              "17          vs Watford          30.0        59.1   29.0         319.0   \n",
              "18         vs West Ham          25.0        52.6   30.0         330.0   \n",
              "19           vs Wolves          24.0        50.4   30.0         330.0   \n",
              "\n",
              "    minutes  goals  assists  pens_made  pens_att  ...  fouls  fouled  \\\n",
              "0    2520.0   31.0     22.0        3.0       3.0  ...  331.0   299.0   \n",
              "1    2610.0   39.0     26.0        3.0       5.0  ...  467.0   360.0   \n",
              "2    2700.0   45.0     36.0        2.0       2.0  ...  352.0   362.0   \n",
              "3    2610.0   36.0     29.0        3.0       4.0  ...  344.0   346.0   \n",
              "4    2430.0   37.0     27.0        1.0       1.0  ...  274.0   333.0   \n",
              "5    2520.0   18.0     11.0        5.0       5.0  ...  398.0   347.0   \n",
              "6    2610.0   36.0     23.0        3.0       4.0  ...  435.0   356.0   \n",
              "7    2430.0   43.0     34.0        1.0       1.0  ...  340.0   310.0   \n",
              "8    2700.0   66.0     50.0        5.0       5.0  ...  374.0   437.0   \n",
              "9    2430.0   45.0     30.0        6.0       7.0  ...  363.0   300.0   \n",
              "10   2610.0   19.0     13.0        0.0       0.0  ...  315.0   326.0   \n",
              "11   2610.0   18.0     15.0        1.0       1.0  ...  345.0   291.0   \n",
              "12   2610.0   37.0     30.0        2.0       4.0  ...  327.0   357.0   \n",
              "13   2610.0   47.0     33.0        5.0       6.0  ...  355.0   379.0   \n",
              "14   2610.0   61.0     43.0        8.0      10.0  ...  405.0   346.0   \n",
              "15   2610.0   44.0     35.0        2.0       2.0  ...  352.0   387.0   \n",
              "16   2610.0   35.0     27.0        2.0       2.0  ...  400.0   345.0   \n",
              "17   2610.0   52.0     38.0        3.0       4.0  ...  308.0   415.0   \n",
              "18   2700.0   38.0     28.0        2.0       3.0  ...  287.0   283.0   \n",
              "19   2700.0   25.0     14.0        5.0       5.0  ...  358.0   361.0   \n",
              "\n",
              "    offsides  pens_won  pens_conceded  own_goals  ball_recoveries  \\\n",
              "0       47.0       3.0            4.0        1.0           2130.0   \n",
              "1       32.0       4.0            2.0        2.0           2390.0   \n",
              "2       59.0       2.0            5.0        1.0           2873.0   \n",
              "3       30.0       3.0            4.0        1.0           2384.0   \n",
              "4       40.0       1.0            0.0        2.0           2755.0   \n",
              "5       55.0       3.0            7.0        1.0           2113.0   \n",
              "6       41.0       2.0            5.0        0.0           2510.0   \n",
              "7       26.0       1.0            4.0        1.0           2441.0   \n",
              "8       43.0       4.0            4.0        0.0           2545.0   \n",
              "9       58.0       5.0            2.0        0.0           2312.0   \n",
              "10     121.0       0.0            6.0        0.0           2398.0   \n",
              "11      71.0       1.0            7.0        2.0           1808.0   \n",
              "12      55.0       2.0            3.0        1.0           2358.0   \n",
              "13      46.0       5.0            1.0        2.0           2615.0   \n",
              "14      39.0       8.0            3.0        2.0           2615.0   \n",
              "15      52.0       2.0            3.0        2.0           2667.0   \n",
              "16      32.0       0.0            2.0        6.0           2237.0   \n",
              "17      48.0       4.0            2.0        0.0           2778.0   \n",
              "18      28.0       2.0            5.0        2.0           2500.0   \n",
              "19      66.0       4.0            1.0        2.0           2577.0   \n",
              "\n",
              "    aerials_won  aerials_lost  aerials_won_pct  \n",
              "0         497.0         427.0             53.8  \n",
              "1         499.0         460.0             52.0  \n",
              "2         664.0         651.0             50.5  \n",
              "3         481.0         481.0             50.0  \n",
              "4         649.0         724.0             47.3  \n",
              "5         421.0         452.0             48.2  \n",
              "6         502.0         565.0             47.0  \n",
              "7         612.0         493.0             55.4  \n",
              "8         502.0         413.0             54.9  \n",
              "9         422.0         446.0             48.6  \n",
              "10        411.0         476.0             46.3  \n",
              "11        331.0         393.0             45.7  \n",
              "12        389.0         496.0             44.0  \n",
              "13        578.0         617.0             48.4  \n",
              "14        528.0         460.0             53.4  \n",
              "15        693.0         576.0             54.6  \n",
              "16        416.0         488.0             46.0  \n",
              "17        651.0         636.0             50.6  \n",
              "18        555.0         569.0             49.4  \n",
              "19        472.0         450.0             51.2  \n",
              "\n",
              "[20 rows x 191 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-cc330aaa-aa5e-4c11-b568-e9b4b5e8303c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>squad</th>\n",
              "      <th>players_used</th>\n",
              "      <th>possession</th>\n",
              "      <th>games</th>\n",
              "      <th>games_starts</th>\n",
              "      <th>minutes</th>\n",
              "      <th>goals</th>\n",
              "      <th>assists</th>\n",
              "      <th>pens_made</th>\n",
              "      <th>pens_att</th>\n",
              "      <th>...</th>\n",
              "      <th>fouls</th>\n",
              "      <th>fouled</th>\n",
              "      <th>offsides</th>\n",
              "      <th>pens_won</th>\n",
              "      <th>pens_conceded</th>\n",
              "      <th>own_goals</th>\n",
              "      <th>ball_recoveries</th>\n",
              "      <th>aerials_won</th>\n",
              "      <th>aerials_lost</th>\n",
              "      <th>aerials_won_pct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>vs Arsenal</td>\n",
              "      <td>27.0</td>\n",
              "      <td>48.2</td>\n",
              "      <td>28.0</td>\n",
              "      <td>308.0</td>\n",
              "      <td>2520.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>331.0</td>\n",
              "      <td>299.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2130.0</td>\n",
              "      <td>497.0</td>\n",
              "      <td>427.0</td>\n",
              "      <td>53.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>vs Aston Villa</td>\n",
              "      <td>30.0</td>\n",
              "      <td>53.8</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>39.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>467.0</td>\n",
              "      <td>360.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2390.0</td>\n",
              "      <td>499.0</td>\n",
              "      <td>460.0</td>\n",
              "      <td>52.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>vs Brentford</td>\n",
              "      <td>28.0</td>\n",
              "      <td>55.8</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>352.0</td>\n",
              "      <td>362.0</td>\n",
              "      <td>59.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2873.0</td>\n",
              "      <td>664.0</td>\n",
              "      <td>651.0</td>\n",
              "      <td>50.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>vs Brighton</td>\n",
              "      <td>25.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>344.0</td>\n",
              "      <td>346.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2384.0</td>\n",
              "      <td>481.0</td>\n",
              "      <td>481.0</td>\n",
              "      <td>50.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>vs Burnley</td>\n",
              "      <td>22.0</td>\n",
              "      <td>61.1</td>\n",
              "      <td>27.0</td>\n",
              "      <td>297.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>274.0</td>\n",
              "      <td>333.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2755.0</td>\n",
              "      <td>649.0</td>\n",
              "      <td>724.0</td>\n",
              "      <td>47.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>vs Chelsea</td>\n",
              "      <td>25.0</td>\n",
              "      <td>39.9</td>\n",
              "      <td>28.0</td>\n",
              "      <td>308.0</td>\n",
              "      <td>2520.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>398.0</td>\n",
              "      <td>347.0</td>\n",
              "      <td>55.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2113.0</td>\n",
              "      <td>421.0</td>\n",
              "      <td>452.0</td>\n",
              "      <td>48.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>vs Crystal Palace</td>\n",
              "      <td>24.0</td>\n",
              "      <td>49.6</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>435.0</td>\n",
              "      <td>356.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2510.0</td>\n",
              "      <td>502.0</td>\n",
              "      <td>565.0</td>\n",
              "      <td>47.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>vs Everton</td>\n",
              "      <td>32.0</td>\n",
              "      <td>58.4</td>\n",
              "      <td>27.0</td>\n",
              "      <td>297.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>340.0</td>\n",
              "      <td>310.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2441.0</td>\n",
              "      <td>612.0</td>\n",
              "      <td>493.0</td>\n",
              "      <td>55.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>vs Leeds United</td>\n",
              "      <td>29.0</td>\n",
              "      <td>45.7</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>374.0</td>\n",
              "      <td>437.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2545.0</td>\n",
              "      <td>502.0</td>\n",
              "      <td>413.0</td>\n",
              "      <td>54.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>vs Leicester City</td>\n",
              "      <td>25.0</td>\n",
              "      <td>49.9</td>\n",
              "      <td>27.0</td>\n",
              "      <td>297.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>...</td>\n",
              "      <td>363.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>58.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2312.0</td>\n",
              "      <td>422.0</td>\n",
              "      <td>446.0</td>\n",
              "      <td>48.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>vs Liverpool</td>\n",
              "      <td>27.0</td>\n",
              "      <td>37.7</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>315.0</td>\n",
              "      <td>326.0</td>\n",
              "      <td>121.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2398.0</td>\n",
              "      <td>411.0</td>\n",
              "      <td>476.0</td>\n",
              "      <td>46.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>vs Manchester City</td>\n",
              "      <td>25.0</td>\n",
              "      <td>31.6</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>345.0</td>\n",
              "      <td>291.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1808.0</td>\n",
              "      <td>331.0</td>\n",
              "      <td>393.0</td>\n",
              "      <td>45.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>vs Manchester Utd</td>\n",
              "      <td>25.0</td>\n",
              "      <td>47.1</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>327.0</td>\n",
              "      <td>357.0</td>\n",
              "      <td>55.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2358.0</td>\n",
              "      <td>389.0</td>\n",
              "      <td>496.0</td>\n",
              "      <td>44.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>vs Newcastle Utd</td>\n",
              "      <td>29.0</td>\n",
              "      <td>60.2</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>33.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>...</td>\n",
              "      <td>355.0</td>\n",
              "      <td>379.0</td>\n",
              "      <td>46.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2615.0</td>\n",
              "      <td>578.0</td>\n",
              "      <td>617.0</td>\n",
              "      <td>48.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>vs Norwich City</td>\n",
              "      <td>27.0</td>\n",
              "      <td>57.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>...</td>\n",
              "      <td>405.0</td>\n",
              "      <td>346.0</td>\n",
              "      <td>39.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2615.0</td>\n",
              "      <td>528.0</td>\n",
              "      <td>460.0</td>\n",
              "      <td>53.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>vs Southampton</td>\n",
              "      <td>25.0</td>\n",
              "      <td>50.4</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>44.0</td>\n",
              "      <td>35.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>352.0</td>\n",
              "      <td>387.0</td>\n",
              "      <td>52.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2667.0</td>\n",
              "      <td>693.0</td>\n",
              "      <td>576.0</td>\n",
              "      <td>54.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>vs Tottenham</td>\n",
              "      <td>25.0</td>\n",
              "      <td>48.3</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>35.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>400.0</td>\n",
              "      <td>345.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>2237.0</td>\n",
              "      <td>416.0</td>\n",
              "      <td>488.0</td>\n",
              "      <td>46.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>vs Watford</td>\n",
              "      <td>30.0</td>\n",
              "      <td>59.1</td>\n",
              "      <td>29.0</td>\n",
              "      <td>319.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>52.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</td>\n",
              "      <td>308.0</td>\n",
              "      <td>415.0</td>\n",
              "      <td>48.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2778.0</td>\n",
              "      <td>651.0</td>\n",
              "      <td>636.0</td>\n",
              "      <td>50.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>vs West Ham</td>\n",
              "      <td>25.0</td>\n",
              "      <td>52.6</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>287.0</td>\n",
              "      <td>283.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2500.0</td>\n",
              "      <td>555.0</td>\n",
              "      <td>569.0</td>\n",
              "      <td>49.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>vs Wolves</td>\n",
              "      <td>24.0</td>\n",
              "      <td>50.4</td>\n",
              "      <td>30.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>358.0</td>\n",
              "      <td>361.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2577.0</td>\n",
              "      <td>472.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>51.2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>20 rows × 191 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cc330aaa-aa5e-4c11-b568-e9b4b5e8303c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http:https://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-cc330aaa-aa5e-4c11-b568-e9b4b5e8303c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-cc330aaa-aa5e-4c11-b568-e9b4b5e8303c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "bvMefm5dmcWs",
        "outputId": "efdd1b8b-95ac-4c8e-c152-36889c7d59cb"
      },
      "source": [
        "#This cell is to get the goalkeeper data for any competition\n",
        "\n",
        "#Go to the 'Standard stats' page of the league\n",
        "#For Premier League 2020/21, the link is this: https://fbref.com/en/comps/9/stats/Premier-League-Stats\n",
        "#Remove the 'stats', and pass the first and third part of the link as parameters like below\n",
        "df_keeper = get_keeper_data('https://fbref.com/en/comps/9/','/Premier-League-Stats')\n",
        "\n",
        "#Save csv file to Desktop\n",
        "df_keeper.to_csv('PL2021_keepers.csv',index=False)\n",
        "\n",
        "df_keeper"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 player nationality position            squad     age  \\\n",
              "0               Alisson      br BRA       GK        Liverpool  29-170   \n",
              "1       Alphonse Areola      fr FRA       GK         West Ham  29-022   \n",
              "2     Kepa Arrizabalaga      es ESP       GK          Chelsea  27-169   \n",
              "3       Daniel Bachmann      at AUT       GK          Watford  27-255   \n",
              "4         Asmir Begović      ba BIH       GK          Everton  34-274   \n",
              "5          Jack Butland     eng ENG       GK   Crystal Palace  29-011   \n",
              "6       Willy Caballero      ar ARG       GK      Southampton  40-174   \n",
              "7           Karl Darlow     eng ENG       GK    Newcastle Utd  31-164   \n",
              "8       Martin Dúbravka      sk SVK       GK    Newcastle Utd  33-065   \n",
              "9               Ederson      br BRA       GK  Manchester City  28-216   \n",
              "10     Łukasz Fabiański      pl POL       GK         West Ham  36-337   \n",
              "11     Álvaro Fernández      es ESP       GK        Brentford  23-342   \n",
              "12       Fraser Forster     eng ENG       GK      Southampton  34-004   \n",
              "13           Ben Foster     eng ENG       GK          Watford  38-352   \n",
              "14         David de Gea      es ESP       GK   Manchester Utd  31-134   \n",
              "15       Vicente Guaita      es ESP       GK   Crystal Palace  35-070   \n",
              "16           Angus Gunn     eng ENG       GK     Norwich City  26-058   \n",
              "17      Wayne Hennessey     wls WAL       GK          Burnley  35-056   \n",
              "18    Caoimhín Kelleher      ie IRL       GK        Liverpool  23-118   \n",
              "19  Kristoffer Klaesson      no NOR       GK     Leeds United  21-114   \n",
              "20             Tim Krul      nl NED       GK     Norwich City  33-352   \n",
              "21           Bernd Leno      de GER       GK          Arsenal  30-017   \n",
              "22          Hugo Lloris      fr FRA       GK        Tottenham  35-085   \n",
              "23          Jonas Lössl      dk DEN       GK        Brentford  33-048   \n",
              "24    Emiliano Martínez      ar ARG       GK      Aston Villa  29-200   \n",
              "25        Alex McCarthy     eng ENG       GK      Southampton  32-108   \n",
              "26        Edouard Mendy      sn SEN       GK          Chelsea  30-020   \n",
              "27        Illan Meslier      fr FRA       GK     Leeds United  22-019   \n",
              "28      Jordan Pickford     eng ENG       GK          Everton  28-014   \n",
              "29            Nick Pope     eng ENG       GK          Burnley  29-336   \n",
              "30       Aaron Ramsdale     eng ENG       GK          Arsenal  23-311   \n",
              "31           David Raya      es ESP       GK        Brentford  26-187   \n",
              "32              José Sá      pt POR       GK           Wolves  29-063   \n",
              "33       Robert Sánchez      es ESP       GK         Brighton  24-123   \n",
              "34    Kasper Schmeichel      dk DEN       GK   Leicester City  35-136   \n",
              "35         Jason Steele     eng ENG       GK         Brighton  31-215   \n",
              "36            Jed Steer     eng ENG       GK      Aston Villa  29-179   \n",
              "37         Zack Steffen      us USA       GK  Manchester City  26-353   \n",
              "38      Freddie Woodman     eng ENG       GK    Newcastle Utd  25-017   \n",
              "\n",
              "   birth_year  games_gk  games_starts_gk  minutes_gk  goals_against_gk  ...  \\\n",
              "0        1992      27.0             27.0      2430.0              18.0  ...   \n",
              "1        1993       1.0              1.0        90.0               1.0  ...   \n",
              "2        1994       4.0              4.0       360.0               2.0  ...   \n",
              "3        1994      11.0             11.0       990.0              26.0  ...   \n",
              "4        1987       2.0              2.0       180.0               3.0  ...   \n",
              "5        1993       6.0              5.0       495.0               9.0  ...   \n",
              "6        1981       2.0              2.0       180.0               5.0  ...   \n",
              "7        1990       8.0              8.0       720.0              15.0  ...   \n",
              "8        1989      17.0             17.0      1530.0              22.0  ...   \n",
              "9        1993      28.0             28.0      2520.0              18.0  ...   \n",
              "10       1985      29.0             29.0      2610.0              38.0  ...   \n",
              "11       1998      12.0             12.0      1080.0              24.0  ...   \n",
              "12       1988      12.0             12.0      1080.0              19.0  ...   \n",
              "13       1983      18.0             18.0      1620.0              29.0  ...   \n",
              "14       1990      29.0             29.0      2610.0              40.0  ...   \n",
              "15       1987      24.0             24.0      2115.0              29.0  ...   \n",
              "16       1996       7.0              7.0       630.0              18.0  ...   \n",
              "17       1987       2.0              2.0       180.0               6.0  ...   \n",
              "18       1998       2.0              2.0       180.0               2.0  ...   \n",
              "19       2000       1.0              0.0        36.0               0.0  ...   \n",
              "20       1988      22.0             22.0      1980.0              45.0  ...   \n",
              "21       1992       4.0              4.0       360.0               9.0  ...   \n",
              "22       1986      29.0             29.0      2610.0              36.0  ...   \n",
              "23       1989       2.0              2.0       180.0               5.0  ...   \n",
              "24       1992      28.0             28.0      2520.0              37.0  ...   \n",
              "25       1989      15.0             15.0      1350.0              21.0  ...   \n",
              "26       1992      24.0             24.0      2160.0              17.0  ...   \n",
              "27       2000      30.0             30.0      2664.0              67.0  ...   \n",
              "28       1994      25.0             25.0      2250.0              44.0  ...   \n",
              "29       1992      25.0             25.0      2250.0              32.0  ...   \n",
              "30       1998      24.0             24.0      2160.0              22.0  ...   \n",
              "31       1995      16.0             16.0      1440.0              18.0  ...   \n",
              "32       1993      30.0             30.0      2700.0              26.0  ...   \n",
              "33       1997      28.0             28.0      2519.0              34.0  ...   \n",
              "34       1986      27.0             27.0      2430.0              46.0  ...   \n",
              "35       1990       1.0              1.0        90.0               2.0  ...   \n",
              "36       1992       1.0              1.0        90.0               3.0  ...   \n",
              "37       1995       1.0              1.0        90.0               0.0  ...   \n",
              "38       1997       4.0              4.0       360.0              12.0  ...   \n",
              "\n",
              "    passes_length_avg_gk  goal_kicks  pct_goal_kicks_launched  \\\n",
              "0                   29.8       129.0                     43.4   \n",
              "1                   49.7        14.0                     71.4   \n",
              "2                   30.8        21.0                     28.6   \n",
              "3                   47.1        80.0                     68.8   \n",
              "4                   57.3        23.0                     82.6   \n",
              "5                   33.1        44.0                     47.7   \n",
              "6                   42.1        13.0                     92.3   \n",
              "7                   49.8        64.0                     78.1   \n",
              "8                   42.2       159.0                     92.5   \n",
              "9                   30.0       110.0                     24.5   \n",
              "10                  45.2       210.0                     74.3   \n",
              "11                  38.6        83.0                     56.6   \n",
              "12                  43.0        83.0                     78.3   \n",
              "13                  51.3       155.0                     89.0   \n",
              "14                  35.9       233.0                     52.8   \n",
              "15                  32.6       157.0                     45.2   \n",
              "16                  40.3        62.0                     41.9   \n",
              "17                  57.8        21.0                     95.2   \n",
              "18                  26.3        13.0                     15.4   \n",
              "19                  34.4         3.0                     33.3   \n",
              "20                  39.7       169.0                     50.3   \n",
              "21                  37.1        37.0                     67.6   \n",
              "22                  34.5       205.0                     42.0   \n",
              "23                  38.9        13.0                     30.8   \n",
              "24                  38.1       223.0                     46.6   \n",
              "25                  39.9       109.0                     76.1   \n",
              "26                  29.3       127.0                     36.2   \n",
              "27                  31.8       219.0                     37.0   \n",
              "28                  50.4       188.0                     77.7   \n",
              "29                  53.4       188.0                     92.6   \n",
              "30                  38.0       139.0                     75.5   \n",
              "31                  43.4       121.0                     78.5   \n",
              "32                  39.6       212.0                     51.4   \n",
              "33                  36.4       171.0                     67.3   \n",
              "34                  39.8       218.0                     53.7   \n",
              "35                  26.2         6.0                     50.0   \n",
              "36                  34.4         6.0                     66.7   \n",
              "37                  26.0         7.0                     28.6   \n",
              "38                  43.3        43.0                     65.1   \n",
              "\n",
              "    goal_kick_length_avg  crosses_gk  crosses_stopped_gk  \\\n",
              "0                   38.9       173.0                17.0   \n",
              "1                   53.2        13.0                 1.0   \n",
              "2                   30.2        31.0                 1.0   \n",
              "3                   51.5       101.0                 3.0   \n",
              "4                   58.5        12.0                 1.0   \n",
              "5                   40.0        57.0                 3.0   \n",
              "6                   59.1        21.0                 1.0   \n",
              "7                   59.8        69.0                 8.0   \n",
              "8                   63.2       144.0                13.0   \n",
              "9                   31.5       137.0                12.0   \n",
              "10                  54.5       252.0                11.0   \n",
              "11                  41.0       123.0                 7.0   \n",
              "12                  54.4       121.0                10.0   \n",
              "13                  63.6       187.0                10.0   \n",
              "14                  43.1       231.0                 7.0   \n",
              "15                  36.7       185.0                14.0   \n",
              "16                  38.5        69.0                 6.0   \n",
              "17                  69.9        20.0                 1.0   \n",
              "18                  26.3        11.0                 0.0   \n",
              "19                  31.0         4.0                 1.0   \n",
              "20                  43.4       184.0                 7.0   \n",
              "21                  49.8        48.0                 2.0   \n",
              "22                  35.2       265.0                18.0   \n",
              "23                  34.2        14.0                 0.0   \n",
              "24                  40.1       222.0                12.0   \n",
              "25                  56.8       135.0                17.0   \n",
              "26                  31.5       189.0                18.0   \n",
              "27                  35.5       172.0                14.0   \n",
              "28                  62.3       209.0                15.0   \n",
              "29                  65.0       245.0                22.0   \n",
              "30                  59.0       187.0                19.0   \n",
              "31                  56.2       150.0                12.0   \n",
              "32                  43.0       274.0                28.0   \n",
              "33                  53.1       227.0                28.0   \n",
              "34                  44.8       218.0                15.0   \n",
              "35                  43.8        11.0                 1.0   \n",
              "36                  53.8         8.0                 1.0   \n",
              "37                  25.3         7.0                 0.0   \n",
              "38                  52.0        33.0                 2.0   \n",
              "\n",
              "    crosses_stopped_pct_gk  def_actions_outside_pen_area_gk  \\\n",
              "0                      9.8                             40.0   \n",
              "1                      7.7                              0.0   \n",
              "2                      3.2                              5.0   \n",
              "3                      3.0                              8.0   \n",
              "4                      8.3                              0.0   \n",
              "5                      5.3                              2.0   \n",
              "6                      4.8                              4.0   \n",
              "7                     11.6                              4.0   \n",
              "8                      9.0                              4.0   \n",
              "9                      8.8                             26.0   \n",
              "10                     4.4                              6.0   \n",
              "11                     5.7                             10.0   \n",
              "12                     8.3                              8.0   \n",
              "13                     5.3                             18.0   \n",
              "14                     3.0                              6.0   \n",
              "15                     7.6                             12.0   \n",
              "16                     8.7                              6.0   \n",
              "17                     5.0                              3.0   \n",
              "18                     0.0                              3.0   \n",
              "19                    25.0                              0.0   \n",
              "20                     3.8                             10.0   \n",
              "21                     4.2                              1.0   \n",
              "22                     6.8                             20.0   \n",
              "23                     0.0                              4.0   \n",
              "24                     5.4                             21.0   \n",
              "25                    12.6                              3.0   \n",
              "26                     9.5                             15.0   \n",
              "27                     8.1                             30.0   \n",
              "28                     7.2                             17.0   \n",
              "29                     9.0                             40.0   \n",
              "30                    10.2                             19.0   \n",
              "31                     8.0                             20.0   \n",
              "32                    10.2                             34.0   \n",
              "33                    12.3                             29.0   \n",
              "34                     6.9                             14.0   \n",
              "35                     9.1                              0.0   \n",
              "36                    12.5                              1.0   \n",
              "37                     0.0                              2.0   \n",
              "38                     6.1                              0.0   \n",
              "\n",
              "    def_actions_outside_pen_area_per90_gk  avg_distance_def_actions_gk  \n",
              "0                                    1.48                         17.6  \n",
              "1                                    0.00                          7.0  \n",
              "2                                    1.25                         16.2  \n",
              "3                                    0.73                         13.7  \n",
              "4                                    0.00                         14.7  \n",
              "5                                    0.36                         12.1  \n",
              "6                                    2.00                         21.7  \n",
              "7                                    0.50                         14.9  \n",
              "8                                    0.24                         12.0  \n",
              "9                                    0.93                         16.6  \n",
              "10                                   0.21                         12.0  \n",
              "11                                   0.83                         14.3  \n",
              "12                                   0.67                         13.2  \n",
              "13                                   1.00                         16.1  \n",
              "14                                   0.21                         13.6  \n",
              "15                                   0.51                         14.3  \n",
              "16                                   0.86                         14.6  \n",
              "17                                   1.50                         15.9  \n",
              "18                                   1.50                         16.4  \n",
              "19                                   0.00                         25.0  \n",
              "20                                   0.45                         12.9  \n",
              "21                                   0.25                         12.9  \n",
              "22                                   0.71                         14.8  \n",
              "23                                   2.00                         19.8  \n",
              "24                                   0.75                         14.3  \n",
              "25                                   0.20                         12.4  \n",
              "26                                   0.63                         13.8  \n",
              "27                                   1.01                         14.8  \n",
              "28                                   0.68                         15.2  \n",
              "29                                   1.60                         18.3  \n",
              "30                                   0.79                         15.3  \n",
              "31                                   1.33                         15.5  \n",
              "32                                   1.13                         15.6  \n",
              "33                                   1.04                         15.0  \n",
              "34                                   0.54                         13.0  \n",
              "35                                   0.00                         13.0  \n",
              "36                                   1.00                         14.3  \n",
              "37                                   2.00                         17.5  \n",
              "38                                   0.00                         11.6  \n",
              "\n",
              "[39 rows x 47 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bca82bd0-62ad-46a9-9b73-c9ff7b58045d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>player</th>\n",
              "      <th>nationality</th>\n",
              "      <th>position</th>\n",
              "      <th>squad</th>\n",
              "      <th>age</th>\n",
              "      <th>birth_year</th>\n",
              "      <th>games_gk</th>\n",
              "      <th>games_starts_gk</th>\n",
              "      <th>minutes_gk</th>\n",
              "      <th>goals_against_gk</th>\n",
              "      <th>...</th>\n",
              "      <th>passes_length_avg_gk</th>\n",
              "      <th>goal_kicks</th>\n",
              "      <th>pct_goal_kicks_launched</th>\n",
              "      <th>goal_kick_length_avg</th>\n",
              "      <th>crosses_gk</th>\n",
              "      <th>crosses_stopped_gk</th>\n",
              "      <th>crosses_stopped_pct_gk</th>\n",
              "      <th>def_actions_outside_pen_area_gk</th>\n",
              "      <th>def_actions_outside_pen_area_per90_gk</th>\n",
              "      <th>avg_distance_def_actions_gk</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Alisson</td>\n",
              "      <td>br BRA</td>\n",
              "      <td>GK</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>29-170</td>\n",
              "      <td>1992</td>\n",
              "      <td>27.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>...</td>\n",
              "      <td>29.8</td>\n",
              "      <td>129.0</td>\n",
              "      <td>43.4</td>\n",
              "      <td>38.9</td>\n",
              "      <td>173.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>9.8</td>\n",
              "      <td>40.0</td>\n",
              "      <td>1.48</td>\n",
              "      <td>17.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Alphonse Areola</td>\n",
              "      <td>fr FRA</td>\n",
              "      <td>GK</td>\n",
              "      <td>West Ham</td>\n",
              "      <td>29-022</td>\n",
              "      <td>1993</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>...</td>\n",
              "      <td>49.7</td>\n",
              "      <td>14.0</td>\n",
              "      <td>71.4</td>\n",
              "      <td>53.2</td>\n",
              "      <td>13.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>7.7</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>7.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Kepa Arrizabalaga</td>\n",
              "      <td>es ESP</td>\n",
              "      <td>GK</td>\n",
              "      <td>Chelsea</td>\n",
              "      <td>27-169</td>\n",
              "      <td>1994</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>360.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>30.8</td>\n",
              "      <td>21.0</td>\n",
              "      <td>28.6</td>\n",
              "      <td>30.2</td>\n",
              "      <td>31.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.2</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>16.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Daniel Bachmann</td>\n",
              "      <td>at AUT</td>\n",
              "      <td>GK</td>\n",
              "      <td>Watford</td>\n",
              "      <td>27-255</td>\n",
              "      <td>1994</td>\n",
              "      <td>11.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>990.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>...</td>\n",
              "      <td>47.1</td>\n",
              "      <td>80.0</td>\n",
              "      <td>68.8</td>\n",
              "      <td>51.5</td>\n",
              "      <td>101.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>0.73</td>\n",
              "      <td>13.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Asmir Begović</td>\n",
              "      <td>ba BIH</td>\n",
              "      <td>GK</td>\n",
              "      <td>Everton</td>\n",
              "      <td>34-274</td>\n",
              "      <td>1987</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>57.3</td>\n",
              "      <td>23.0</td>\n",
              "      <td>82.6</td>\n",
              "      <td>58.5</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>8.3</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>14.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Jack Butland</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Crystal Palace</td>\n",
              "      <td>29-011</td>\n",
              "      <td>1993</td>\n",
              "      <td>6.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>495.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>...</td>\n",
              "      <td>33.1</td>\n",
              "      <td>44.0</td>\n",
              "      <td>47.7</td>\n",
              "      <td>40.0</td>\n",
              "      <td>57.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>5.3</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.36</td>\n",
              "      <td>12.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Willy Caballero</td>\n",
              "      <td>ar ARG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Southampton</td>\n",
              "      <td>40-174</td>\n",
              "      <td>1981</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>42.1</td>\n",
              "      <td>13.0</td>\n",
              "      <td>92.3</td>\n",
              "      <td>59.1</td>\n",
              "      <td>21.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>4.8</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.00</td>\n",
              "      <td>21.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Karl Darlow</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Newcastle Utd</td>\n",
              "      <td>31-164</td>\n",
              "      <td>1990</td>\n",
              "      <td>8.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>720.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>...</td>\n",
              "      <td>49.8</td>\n",
              "      <td>64.0</td>\n",
              "      <td>78.1</td>\n",
              "      <td>59.8</td>\n",
              "      <td>69.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>11.6</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.50</td>\n",
              "      <td>14.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Martin Dúbravka</td>\n",
              "      <td>sk SVK</td>\n",
              "      <td>GK</td>\n",
              "      <td>Newcastle Utd</td>\n",
              "      <td>33-065</td>\n",
              "      <td>1989</td>\n",
              "      <td>17.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>1530.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>...</td>\n",
              "      <td>42.2</td>\n",
              "      <td>159.0</td>\n",
              "      <td>92.5</td>\n",
              "      <td>63.2</td>\n",
              "      <td>144.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.24</td>\n",
              "      <td>12.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Ederson</td>\n",
              "      <td>br BRA</td>\n",
              "      <td>GK</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>28-216</td>\n",
              "      <td>1993</td>\n",
              "      <td>28.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>2520.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>...</td>\n",
              "      <td>30.0</td>\n",
              "      <td>110.0</td>\n",
              "      <td>24.5</td>\n",
              "      <td>31.5</td>\n",
              "      <td>137.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>8.8</td>\n",
              "      <td>26.0</td>\n",
              "      <td>0.93</td>\n",
              "      <td>16.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Łukasz Fabiański</td>\n",
              "      <td>pl POL</td>\n",
              "      <td>GK</td>\n",
              "      <td>West Ham</td>\n",
              "      <td>36-337</td>\n",
              "      <td>1985</td>\n",
              "      <td>29.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>...</td>\n",
              "      <td>45.2</td>\n",
              "      <td>210.0</td>\n",
              "      <td>74.3</td>\n",
              "      <td>54.5</td>\n",
              "      <td>252.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>4.4</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.21</td>\n",
              "      <td>12.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Álvaro Fernández</td>\n",
              "      <td>es ESP</td>\n",
              "      <td>GK</td>\n",
              "      <td>Brentford</td>\n",
              "      <td>23-342</td>\n",
              "      <td>1998</td>\n",
              "      <td>12.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1080.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>...</td>\n",
              "      <td>38.6</td>\n",
              "      <td>83.0</td>\n",
              "      <td>56.6</td>\n",
              "      <td>41.0</td>\n",
              "      <td>123.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5.7</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.83</td>\n",
              "      <td>14.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Fraser Forster</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Southampton</td>\n",
              "      <td>34-004</td>\n",
              "      <td>1988</td>\n",
              "      <td>12.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1080.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>...</td>\n",
              "      <td>43.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>78.3</td>\n",
              "      <td>54.4</td>\n",
              "      <td>121.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>8.3</td>\n",
              "      <td>8.0</td>\n",
              "      <td>0.67</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Ben Foster</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Watford</td>\n",
              "      <td>38-352</td>\n",
              "      <td>1983</td>\n",
              "      <td>18.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1620.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>...</td>\n",
              "      <td>51.3</td>\n",
              "      <td>155.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>63.6</td>\n",
              "      <td>187.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>5.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>16.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>David de Gea</td>\n",
              "      <td>es ESP</td>\n",
              "      <td>GK</td>\n",
              "      <td>Manchester Utd</td>\n",
              "      <td>31-134</td>\n",
              "      <td>1990</td>\n",
              "      <td>29.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>...</td>\n",
              "      <td>35.9</td>\n",
              "      <td>233.0</td>\n",
              "      <td>52.8</td>\n",
              "      <td>43.1</td>\n",
              "      <td>231.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.21</td>\n",
              "      <td>13.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Vicente Guaita</td>\n",
              "      <td>es ESP</td>\n",
              "      <td>GK</td>\n",
              "      <td>Crystal Palace</td>\n",
              "      <td>35-070</td>\n",
              "      <td>1987</td>\n",
              "      <td>24.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>2115.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>...</td>\n",
              "      <td>32.6</td>\n",
              "      <td>157.0</td>\n",
              "      <td>45.2</td>\n",
              "      <td>36.7</td>\n",
              "      <td>185.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>7.6</td>\n",
              "      <td>12.0</td>\n",
              "      <td>0.51</td>\n",
              "      <td>14.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Angus Gunn</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Norwich City</td>\n",
              "      <td>26-058</td>\n",
              "      <td>1996</td>\n",
              "      <td>7.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>630.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>...</td>\n",
              "      <td>40.3</td>\n",
              "      <td>62.0</td>\n",
              "      <td>41.9</td>\n",
              "      <td>38.5</td>\n",
              "      <td>69.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>8.7</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.86</td>\n",
              "      <td>14.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Wayne Hennessey</td>\n",
              "      <td>wls WAL</td>\n",
              "      <td>GK</td>\n",
              "      <td>Burnley</td>\n",
              "      <td>35-056</td>\n",
              "      <td>1987</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>...</td>\n",
              "      <td>57.8</td>\n",
              "      <td>21.0</td>\n",
              "      <td>95.2</td>\n",
              "      <td>69.9</td>\n",
              "      <td>20.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.50</td>\n",
              "      <td>15.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Caoimhín Kelleher</td>\n",
              "      <td>ie IRL</td>\n",
              "      <td>GK</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>23-118</td>\n",
              "      <td>1998</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>26.3</td>\n",
              "      <td>13.0</td>\n",
              "      <td>15.4</td>\n",
              "      <td>26.3</td>\n",
              "      <td>11.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.50</td>\n",
              "      <td>16.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Kristoffer Klaesson</td>\n",
              "      <td>no NOR</td>\n",
              "      <td>GK</td>\n",
              "      <td>Leeds United</td>\n",
              "      <td>21-114</td>\n",
              "      <td>2000</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>34.4</td>\n",
              "      <td>3.0</td>\n",
              "      <td>33.3</td>\n",
              "      <td>31.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>25.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Tim Krul</td>\n",
              "      <td>nl NED</td>\n",
              "      <td>GK</td>\n",
              "      <td>Norwich City</td>\n",
              "      <td>33-352</td>\n",
              "      <td>1988</td>\n",
              "      <td>22.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>1980.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>...</td>\n",
              "      <td>39.7</td>\n",
              "      <td>169.0</td>\n",
              "      <td>50.3</td>\n",
              "      <td>43.4</td>\n",
              "      <td>184.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.45</td>\n",
              "      <td>12.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Bernd Leno</td>\n",
              "      <td>de GER</td>\n",
              "      <td>GK</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>30-017</td>\n",
              "      <td>1992</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>360.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>...</td>\n",
              "      <td>37.1</td>\n",
              "      <td>37.0</td>\n",
              "      <td>67.6</td>\n",
              "      <td>49.8</td>\n",
              "      <td>48.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.2</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.25</td>\n",
              "      <td>12.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Hugo Lloris</td>\n",
              "      <td>fr FRA</td>\n",
              "      <td>GK</td>\n",
              "      <td>Tottenham</td>\n",
              "      <td>35-085</td>\n",
              "      <td>1986</td>\n",
              "      <td>29.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>2610.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>...</td>\n",
              "      <td>34.5</td>\n",
              "      <td>205.0</td>\n",
              "      <td>42.0</td>\n",
              "      <td>35.2</td>\n",
              "      <td>265.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>6.8</td>\n",
              "      <td>20.0</td>\n",
              "      <td>0.71</td>\n",
              "      <td>14.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Jonas Lössl</td>\n",
              "      <td>dk DEN</td>\n",
              "      <td>GK</td>\n",
              "      <td>Brentford</td>\n",
              "      <td>33-048</td>\n",
              "      <td>1989</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>...</td>\n",
              "      <td>38.9</td>\n",
              "      <td>13.0</td>\n",
              "      <td>30.8</td>\n",
              "      <td>34.2</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.00</td>\n",
              "      <td>19.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Emiliano Martínez</td>\n",
              "      <td>ar ARG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Aston Villa</td>\n",
              "      <td>29-200</td>\n",
              "      <td>1992</td>\n",
              "      <td>28.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>2520.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>...</td>\n",
              "      <td>38.1</td>\n",
              "      <td>223.0</td>\n",
              "      <td>46.6</td>\n",
              "      <td>40.1</td>\n",
              "      <td>222.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>5.4</td>\n",
              "      <td>21.0</td>\n",
              "      <td>0.75</td>\n",
              "      <td>14.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Alex McCarthy</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Southampton</td>\n",
              "      <td>32-108</td>\n",
              "      <td>1989</td>\n",
              "      <td>15.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>1350.0</td>\n",
              "      <td>21.0</td>\n",
              "      <td>...</td>\n",
              "      <td>39.9</td>\n",
              "      <td>109.0</td>\n",
              "      <td>76.1</td>\n",
              "      <td>56.8</td>\n",
              "      <td>135.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>12.6</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.20</td>\n",
              "      <td>12.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Edouard Mendy</td>\n",
              "      <td>sn SEN</td>\n",
              "      <td>GK</td>\n",
              "      <td>Chelsea</td>\n",
              "      <td>30-020</td>\n",
              "      <td>1992</td>\n",
              "      <td>24.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>2160.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>...</td>\n",
              "      <td>29.3</td>\n",
              "      <td>127.0</td>\n",
              "      <td>36.2</td>\n",
              "      <td>31.5</td>\n",
              "      <td>189.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>9.5</td>\n",
              "      <td>15.0</td>\n",
              "      <td>0.63</td>\n",
              "      <td>13.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Illan Meslier</td>\n",
              "      <td>fr FRA</td>\n",
              "      <td>GK</td>\n",
              "      <td>Leeds United</td>\n",
              "      <td>22-019</td>\n",
              "      <td>2000</td>\n",
              "      <td>30.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>2664.0</td>\n",
              "      <td>67.0</td>\n",
              "      <td>...</td>\n",
              "      <td>31.8</td>\n",
              "      <td>219.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>35.5</td>\n",
              "      <td>172.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>8.1</td>\n",
              "      <td>30.0</td>\n",
              "      <td>1.01</td>\n",
              "      <td>14.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Jordan Pickford</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Everton</td>\n",
              "      <td>28-014</td>\n",
              "      <td>1994</td>\n",
              "      <td>25.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>2250.0</td>\n",
              "      <td>44.0</td>\n",
              "      <td>...</td>\n",
              "      <td>50.4</td>\n",
              "      <td>188.0</td>\n",
              "      <td>77.7</td>\n",
              "      <td>62.3</td>\n",
              "      <td>209.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>7.2</td>\n",
              "      <td>17.0</td>\n",
              "      <td>0.68</td>\n",
              "      <td>15.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Nick Pope</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Burnley</td>\n",
              "      <td>29-336</td>\n",
              "      <td>1992</td>\n",
              "      <td>25.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>2250.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>...</td>\n",
              "      <td>53.4</td>\n",
              "      <td>188.0</td>\n",
              "      <td>92.6</td>\n",
              "      <td>65.0</td>\n",
              "      <td>245.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>1.60</td>\n",
              "      <td>18.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Aaron Ramsdale</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>23-311</td>\n",
              "      <td>1998</td>\n",
              "      <td>24.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>2160.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>...</td>\n",
              "      <td>38.0</td>\n",
              "      <td>139.0</td>\n",
              "      <td>75.5</td>\n",
              "      <td>59.0</td>\n",
              "      <td>187.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>10.2</td>\n",
              "      <td>19.0</td>\n",
              "      <td>0.79</td>\n",
              "      <td>15.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>David Raya</td>\n",
              "      <td>es ESP</td>\n",
              "      <td>GK</td>\n",
              "      <td>Brentford</td>\n",
              "      <td>26-187</td>\n",
              "      <td>1995</td>\n",
              "      <td>16.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>1440.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>...</td>\n",
              "      <td>43.4</td>\n",
              "      <td>121.0</td>\n",
              "      <td>78.5</td>\n",
              "      <td>56.2</td>\n",
              "      <td>150.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>1.33</td>\n",
              "      <td>15.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>José Sá</td>\n",
              "      <td>pt POR</td>\n",
              "      <td>GK</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>29-063</td>\n",
              "      <td>1993</td>\n",
              "      <td>30.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>2700.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>...</td>\n",
              "      <td>39.6</td>\n",
              "      <td>212.0</td>\n",
              "      <td>51.4</td>\n",
              "      <td>43.0</td>\n",
              "      <td>274.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>10.2</td>\n",
              "      <td>34.0</td>\n",
              "      <td>1.13</td>\n",
              "      <td>15.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>Robert Sánchez</td>\n",
              "      <td>es ESP</td>\n",
              "      <td>GK</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>24-123</td>\n",
              "      <td>1997</td>\n",
              "      <td>28.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>2519.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>...</td>\n",
              "      <td>36.4</td>\n",
              "      <td>171.0</td>\n",
              "      <td>67.3</td>\n",
              "      <td>53.1</td>\n",
              "      <td>227.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>12.3</td>\n",
              "      <td>29.0</td>\n",
              "      <td>1.04</td>\n",
              "      <td>15.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Kasper Schmeichel</td>\n",
              "      <td>dk DEN</td>\n",
              "      <td>GK</td>\n",
              "      <td>Leicester City</td>\n",
              "      <td>35-136</td>\n",
              "      <td>1986</td>\n",
              "      <td>27.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>2430.0</td>\n",
              "      <td>46.0</td>\n",
              "      <td>...</td>\n",
              "      <td>39.8</td>\n",
              "      <td>218.0</td>\n",
              "      <td>53.7</td>\n",
              "      <td>44.8</td>\n",
              "      <td>218.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>6.9</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.54</td>\n",
              "      <td>13.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Jason Steele</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>31-215</td>\n",
              "      <td>1990</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>...</td>\n",
              "      <td>26.2</td>\n",
              "      <td>6.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>43.8</td>\n",
              "      <td>11.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>9.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>13.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Jed Steer</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Aston Villa</td>\n",
              "      <td>29-179</td>\n",
              "      <td>1992</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</td>\n",
              "      <td>34.4</td>\n",
              "      <td>6.0</td>\n",
              "      <td>66.7</td>\n",
              "      <td>53.8</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>12.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>14.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>Zack Steffen</td>\n",
              "      <td>us USA</td>\n",
              "      <td>GK</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>26-353</td>\n",
              "      <td>1995</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>26.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>28.6</td>\n",
              "      <td>25.3</td>\n",
              "      <td>7.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.00</td>\n",
              "      <td>17.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Freddie Woodman</td>\n",
              "      <td>eng ENG</td>\n",
              "      <td>GK</td>\n",
              "      <td>Newcastle Utd</td>\n",
              "      <td>25-017</td>\n",
              "      <td>1997</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>360.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>...</td>\n",
              "      <td>43.3</td>\n",
              "      <td>43.0</td>\n",
              "      <td>65.1</td>\n",
              "      <td>52.0</td>\n",
              "      <td>33.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>6.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>11.6</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>39 rows × 47 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bca82bd0-62ad-46a9-9b73-c9ff7b58045d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http:https://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bca82bd0-62ad-46a9-9b73-c9ff7b58045d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bca82bd0-62ad-46a9-9b73-c9ff7b58045d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    }
  ]
}