Scrape_FBref.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Much of the scraping code is taken from this repository: https://github.com/chmartin/FBref_EPL\n",
    "#I've made the the necessary changes for the recently added data and for combining it"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#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_og_for\"]\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_og_for\"]\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\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Functions to get the data in a dataframe using BeautifulSoup\n",
    "\n",
    "def get_tables(url):\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",
    "    team_table = all_tables[0]\n",
    "    player_table = all_tables[1]\n",
    "    return player_table, team_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)\n",
    "    df_player = get_frame(features, player_table)\n",
    "    return df_player\n",
    "\n",
    "def frame_for_category_team(category,top,end,features):\n",
    "    url = (top + category + end)\n",
    "    player_table, team_table = get_tables(url)\n",
    "    df_team = get_frame_team(features, team_table)\n",
    "    return df_team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Function to get team-wise data accross all categories as mentioned above\n",
    "def get_team_data(top,end):\n",
    "    df1 = frame_for_category_team('stats',top,end,stats3)\n",
    "    df2 = frame_for_category_team('keepers',top,end,keepers3)\n",
    "    df3 = frame_for_category_team('keepersadv',top,end,keepersadv2)\n",
    "    df4 = frame_for_category_team('shooting',top,end,shooting3)\n",
    "    df5 = frame_for_category_team('passing',top,end,passing2)\n",
    "    df6 = frame_for_category_team('passing_types',top,end,passing_types2)\n",
    "    df7 = frame_for_category_team('gca',top,end,gca2)\n",
    "    df8 = frame_for_category_team('defense',top,end,defense2)\n",
    "    df9 = frame_for_category_team('possession',top,end,possession2)\n",
    "    df10 = frame_for_category_team('misc',top,end,misc2)\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",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>Patrick van Aanholt</td>\n",
       "      <td>nl NED</td>\n",
       "      <td>DF</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>30-153</td>\n",
       "      <td>1990</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>46.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tammy Abraham</td>\n",
       "      <td>eng ENG</td>\n",
       "      <td>FW</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>23-119</td>\n",
       "      <td>1997</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>912.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>18.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>61.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Che Adams</td>\n",
       "      <td>eng ENG</td>\n",
       "      <td>FW</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>24-200</td>\n",
       "      <td>1996</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1507.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>17.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>21.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tosin Adarabioyo</td>\n",
       "      <td>eng ENG</td>\n",
       "      <td>DF</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>23-127</td>\n",
       "      <td>1997</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>66.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Adrián</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>34-026</td>\n",
       "      <td>1987</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</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>472</th>\n",
       "      <td>Andre-Frank Zambo Anguissa</td>\n",
       "      <td>cm CMR</td>\n",
       "      <td>MF</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>25-074</td>\n",
       "      <td>1995</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1542.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>24.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>58.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>Andi Zeqiri</td>\n",
       "      <td>ch SUI</td>\n",
       "      <td>FW,DF</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>21-221</td>\n",
       "      <td>1999</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>33.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>Oleksandr Zinchenko</td>\n",
       "      <td>ua UKR</td>\n",
       "      <td>DF</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>24-045</td>\n",
       "      <td>1996</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>436.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.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>51.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>68.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>Hakim Ziyech</td>\n",
       "      <td>ma MAR</td>\n",
       "      <td>FW,MF</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>27-316</td>\n",
       "      <td>1993</td>\n",
       "      <td>11.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>Kurt Zouma</td>\n",
       "      <td>fr FRA</td>\n",
       "      <td>DF</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>26-094</td>\n",
       "      <td>1994</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>159.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>79.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>477 rows × 154 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         player nationality position            squad     age  \\\n",
       "0           Patrick van Aanholt      nl NED       DF   Crystal Palace  30-153   \n",
       "1                 Tammy Abraham     eng ENG       FW          Chelsea  23-119   \n",
       "2                     Che Adams     eng ENG       FW      Southampton  24-200   \n",
       "3              Tosin Adarabioyo     eng ENG       DF           Fulham  23-127   \n",
       "4                        Adrián      es ESP       GK        Liverpool  34-026   \n",
       "..                          ...         ...      ...              ...     ...   \n",
       "472  Andre-Frank Zambo Anguissa      cm CMR       MF           Fulham  25-074   \n",
       "473                 Andi Zeqiri      ch SUI    FW,DF         Brighton  21-221   \n",
       "474         Oleksandr Zinchenko      ua UKR       DF  Manchester City  24-045   \n",
       "475                Hakim Ziyech      ma MAR    FW,MF          Chelsea  27-316   \n",
       "476                  Kurt Zouma      fr FRA       DF          Chelsea  26-094   \n",
       "\n",
       "    birth_year  games  games_starts  minutes  goals  ...  fouls  fouled  \\\n",
       "0         1990   10.0           9.0    829.0    0.0  ...    6.0     3.0   \n",
       "1         1997   17.0           9.0    912.0    6.0  ...   18.0    12.0   \n",
       "2         1996   18.0          18.0   1507.0    4.0  ...   17.0    26.0   \n",
       "3         1997   15.0          15.0   1350.0    0.0  ...    8.0     4.0   \n",
       "4         1987    2.0           2.0    180.0    0.0  ...    0.0     0.0   \n",
       "..         ...    ...           ...      ...    ...  ...    ...     ...   \n",
       "472       1995   19.0          17.0   1542.0    0.0  ...   24.0    16.0   \n",
       "473       1999    2.0           0.0     64.0    0.0  ...    0.0     0.0   \n",
       "474       1996    6.0           4.0    436.0    0.0  ...    3.0     1.0   \n",
       "475       1993   11.0           8.0    630.0    1.0  ...   11.0     9.0   \n",
       "476       1994   15.0          15.0   1350.0    4.0  ...   11.0     5.0   \n",
       "\n",
       "     offsides  pens_won  pens_conceded  own_goals  ball_recoveries  \\\n",
       "0         3.0       0.0            0.0        0.0             95.0   \n",
       "1         4.0       1.0            0.0        0.0             43.0   \n",
       "2        11.0       0.0            0.0        0.0             63.0   \n",
       "3         1.0       0.0            0.0        0.0            134.0   \n",
       "4         0.0       0.0            0.0        0.0             14.0   \n",
       "..        ...       ...            ...        ...              ...   \n",
       "472       0.0       0.0            0.0        0.0            199.0   \n",
       "473       0.0       0.0            0.0        0.0              5.0   \n",
       "474       0.0       0.0            0.0        0.0             51.0   \n",
       "475       1.0       0.0            0.0        0.0             61.0   \n",
       "476       0.0       0.0            0.0        0.0            159.0   \n",
       "\n",
       "     aerials_won  aerials_lost  aerials_won_pct  \n",
       "0            6.0           7.0             46.2  \n",
       "1           36.0          23.0             61.0  \n",
       "2           22.0          82.0             21.2  \n",
       "3           32.0          16.0             66.7  \n",
       "4            0.0           0.0              0.0  \n",
       "..           ...           ...              ...  \n",
       "472         28.0          20.0             58.3  \n",
       "473          1.0           2.0             33.3  \n",
       "474         13.0           6.0             68.4  \n",
       "475          0.0          13.0              0.0  \n",
       "476         63.0          16.0             79.7  \n",
       "\n",
       "[477 rows x 154 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "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 2019/20, 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\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>Atalanta</td>\n",
       "      <td>28.0</td>\n",
       "      <td>54.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>303.0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1953.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>58.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Benevento</td>\n",
       "      <td>24.0</td>\n",
       "      <td>43.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>248.0</td>\n",
       "      <td>306.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1542.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>323.0</td>\n",
       "      <td>45.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bologna</td>\n",
       "      <td>31.0</td>\n",
       "      <td>51.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>270.0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1660.0</td>\n",
       "      <td>318.0</td>\n",
       "      <td>303.0</td>\n",
       "      <td>51.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cagliari</td>\n",
       "      <td>27.0</td>\n",
       "      <td>44.9</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>248.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1535.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>280.0</td>\n",
       "      <td>49.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Crotone</td>\n",
       "      <td>27.0</td>\n",
       "      <td>49.2</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>275.0</td>\n",
       "      <td>258.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1679.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>44.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Fiorentina</td>\n",
       "      <td>25.0</td>\n",
       "      <td>51.6</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>268.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1606.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>49.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Genoa</td>\n",
       "      <td>31.0</td>\n",
       "      <td>42.9</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>261.0</td>\n",
       "      <td>248.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1674.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>364.0</td>\n",
       "      <td>42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Hellas Verona</td>\n",
       "      <td>28.0</td>\n",
       "      <td>47.2</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>299.0</td>\n",
       "      <td>262.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>421.0</td>\n",
       "      <td>459.0</td>\n",
       "      <td>47.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Inter</td>\n",
       "      <td>22.0</td>\n",
       "      <td>54.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>279.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1539.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>55.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Juventus</td>\n",
       "      <td>26.0</td>\n",
       "      <td>58.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>219.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1393.0</td>\n",
       "      <td>217.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>55.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Lazio</td>\n",
       "      <td>26.0</td>\n",
       "      <td>51.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>251.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1705.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>54.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Milan</td>\n",
       "      <td>28.0</td>\n",
       "      <td>51.1</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>272.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1635.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>302.0</td>\n",
       "      <td>50.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Napoli</td>\n",
       "      <td>25.0</td>\n",
       "      <td>58.1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>167.0</td>\n",
       "      <td>252.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1402.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>48.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Parma</td>\n",
       "      <td>33.0</td>\n",
       "      <td>45.6</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>236.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1443.0</td>\n",
       "      <td>277.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>55.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Roma</td>\n",
       "      <td>23.0</td>\n",
       "      <td>51.2</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>283.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1531.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>214.0</td>\n",
       "      <td>53.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sampdoria</td>\n",
       "      <td>26.0</td>\n",
       "      <td>42.4</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>269.0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1718.0</td>\n",
       "      <td>316.0</td>\n",
       "      <td>362.0</td>\n",
       "      <td>46.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sassuolo</td>\n",
       "      <td>27.0</td>\n",
       "      <td>58.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>232.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1465.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Spezia</td>\n",
       "      <td>34.0</td>\n",
       "      <td>51.6</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>314.0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1501.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>48.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Torino</td>\n",
       "      <td>26.0</td>\n",
       "      <td>47.9</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>277.0</td>\n",
       "      <td>304.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1486.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Udinese</td>\n",
       "      <td>28.0</td>\n",
       "      <td>45.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>270.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1588.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>49.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 191 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            squad  players_used  possession  games  games_starts  minutes  \\\n",
       "0        Atalanta          28.0        54.3   19.0         209.0   1710.0   \n",
       "1       Benevento          24.0        43.7   19.0         209.0   1710.0   \n",
       "2         Bologna          31.0        51.3   19.0         209.0   1710.0   \n",
       "3        Cagliari          27.0        44.9   19.0         209.0   1710.0   \n",
       "4         Crotone          27.0        49.2   19.0         209.0   1710.0   \n",
       "5      Fiorentina          25.0        51.6   19.0         209.0   1710.0   \n",
       "6           Genoa          31.0        42.9   19.0         209.0   1710.0   \n",
       "7   Hellas Verona          28.0        47.2   19.0         209.0   1710.0   \n",
       "8           Inter          22.0        54.3   19.0         209.0   1710.0   \n",
       "9        Juventus          26.0        58.8   18.0         198.0   1620.0   \n",
       "10          Lazio          26.0        51.3   19.0         209.0   1710.0   \n",
       "11          Milan          28.0        51.1   19.0         209.0   1710.0   \n",
       "12         Napoli          25.0        58.1   18.0         198.0   1620.0   \n",
       "13          Parma          33.0        45.6   19.0         209.0   1710.0   \n",
       "14           Roma          23.0        51.2   19.0         209.0   1710.0   \n",
       "15      Sampdoria          26.0        42.4   19.0         209.0   1710.0   \n",
       "16       Sassuolo          27.0        58.7   19.0         209.0   1710.0   \n",
       "17         Spezia          34.0        51.6   19.0         209.0   1710.0   \n",
       "18         Torino          26.0        47.9   19.0         209.0   1710.0   \n",
       "19        Udinese          28.0        45.7   19.0         209.0   1710.0   \n",
       "\n",
       "    goals  assists  pens_made  pens_att  ...  fouls  fouled  offsides  \\\n",
       "0    44.0     30.0        3.0       3.0  ...  303.0   239.0      31.0   \n",
       "1    23.0     14.0        2.0       4.0  ...  248.0   306.0      31.0   \n",
       "2    22.0     17.0        1.0       2.0  ...  270.0   239.0      48.0   \n",
       "3    23.0     13.0        2.0       3.0  ...  248.0   240.0      26.0   \n",
       "4    21.0     14.0        4.0       4.0  ...  275.0   258.0      26.0   \n",
       "5    19.0     14.0        3.0       3.0  ...  268.0   271.0      37.0   \n",
       "6    19.0     15.0        1.0       1.0  ...  261.0   248.0      45.0   \n",
       "7    20.0     14.0        3.0       3.0  ...  299.0   262.0      48.0   \n",
       "8    42.0     34.0        3.0       4.0  ...  279.0   222.0      33.0   \n",
       "9    37.0     30.0        4.0       5.0  ...  219.0   223.0      48.0   \n",
       "10   32.0     21.0        3.0       4.0  ...  251.0   228.0      42.0   \n",
       "11   38.0     24.0        9.0      12.0  ...  272.0   260.0      49.0   \n",
       "12   41.0     30.0        3.0       3.0  ...  167.0   252.0      33.0   \n",
       "13   14.0     11.0        1.0       1.0  ...  236.0   241.0      48.0   \n",
       "14   40.0     30.0        5.0       5.0  ...  283.0   231.0      34.0   \n",
       "15   30.0     22.0        3.0       4.0  ...  269.0   239.0      40.0   \n",
       "16   31.0     19.0        5.0       5.0  ...  232.0   234.0      27.0   \n",
       "17   26.0     17.0        3.0       3.0  ...  314.0   239.0      44.0   \n",
       "18   27.0     16.0        3.0       3.0  ...  277.0   304.0      35.0   \n",
       "19   19.0     13.0        1.0       1.0  ...  270.0   244.0      42.0   \n",
       "\n",
       "    pens_won  pens_conceded  own_goals  ball_recoveries  aerials_won  \\\n",
       "0        3.0            3.0        0.0           1953.0        347.0   \n",
       "1        4.0            3.0        1.0           1542.0        271.0   \n",
       "2        2.0            2.0        2.0           1660.0        318.0   \n",
       "3        3.0            4.0        0.0           1535.0        270.0   \n",
       "4        4.0            3.0        1.0           1679.0        224.0   \n",
       "5        3.0            6.0        1.0           1606.0        271.0   \n",
       "6        1.0            4.0        1.0           1674.0        266.0   \n",
       "7        3.0            3.0        1.0           2021.0        421.0   \n",
       "8        2.0            4.0        0.0           1539.0        278.0   \n",
       "9        4.0            2.0        1.0           1393.0        217.0   \n",
       "10       3.0            3.0        1.0           1705.0        271.0   \n",
       "11      11.0            5.0        1.0           1635.0        311.0   \n",
       "12       2.0            3.0        0.0           1402.0        183.0   \n",
       "13       1.0            1.0        1.0           1443.0        277.0   \n",
       "14       4.0            4.0        1.0           1531.0        242.0   \n",
       "15       2.0            7.0        1.0           1718.0        316.0   \n",
       "16       3.0            2.0        1.0           1465.0        231.0   \n",
       "17       3.0            6.0        0.0           1501.0        259.0   \n",
       "18       3.0            5.0        0.0           1486.0        254.0   \n",
       "19       1.0            3.0        0.0           1588.0        260.0   \n",
       "\n",
       "    aerials_lost  aerials_won_pct  \n",
       "0          244.0             58.7  \n",
       "1          323.0             45.6  \n",
       "2          303.0             51.2  \n",
       "3          280.0             49.1  \n",
       "4          275.0             44.9  \n",
       "5          278.0             49.4  \n",
       "6          364.0             42.2  \n",
       "7          459.0             47.8  \n",
       "8          225.0             55.3  \n",
       "9          177.0             55.1  \n",
       "10         231.0             54.0  \n",
       "11         302.0             50.7  \n",
       "12         191.0             48.9  \n",
       "13         220.0             55.7  \n",
       "14         214.0             53.1  \n",
       "15         362.0             46.6  \n",
       "16         222.0             51.0  \n",
       "17         276.0             48.4  \n",
       "18         275.0             48.0  \n",
       "19         266.0             49.4  \n",
       "\n",
       "[20 rows x 191 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "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 2019/20, 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/11/','/Serie-A-Stats')\n",
    "total_teams = int(len(df_team)/2)\n",
    "df_team = df_team[total_teams:2*total_teams]\n",
    "df_team = df_team.reset_index(drop=True)\n",
    "\n",
    "#Save csv file to Desktop\n",
    "df_team.to_csv('SerieA2021_teams.csv',index=False)\n",
    "\n",
    "df_team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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 Atalanta</td>\n",
       "      <td>28.0</td>\n",
       "      <td>45.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>253.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1676.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>41.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>vs Benevento</td>\n",
       "      <td>24.0</td>\n",
       "      <td>56.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>319.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1559.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>54.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>vs Bologna</td>\n",
       "      <td>31.0</td>\n",
       "      <td>48.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>246.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1660.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>314.0</td>\n",
       "      <td>48.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>vs Cagliari</td>\n",
       "      <td>27.0</td>\n",
       "      <td>55.1</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>248.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1530.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>50.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>vs Crotone</td>\n",
       "      <td>27.0</td>\n",
       "      <td>50.8</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>272.0</td>\n",
       "      <td>263.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1667.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>55.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>vs Fiorentina</td>\n",
       "      <td>25.0</td>\n",
       "      <td>48.4</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>285.0</td>\n",
       "      <td>258.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1559.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>50.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>vs Genoa</td>\n",
       "      <td>31.0</td>\n",
       "      <td>57.1</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>259.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>364.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>57.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>vs Hellas Verona</td>\n",
       "      <td>28.0</td>\n",
       "      <td>52.8</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>283.0</td>\n",
       "      <td>288.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2066.0</td>\n",
       "      <td>459.0</td>\n",
       "      <td>421.0</td>\n",
       "      <td>52.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>vs Inter</td>\n",
       "      <td>22.0</td>\n",
       "      <td>45.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>232.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1340.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>44.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>vs Juventus</td>\n",
       "      <td>26.0</td>\n",
       "      <td>41.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>233.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1255.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>44.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>vs Lazio</td>\n",
       "      <td>26.0</td>\n",
       "      <td>48.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>236.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>45.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>vs Milan</td>\n",
       "      <td>28.0</td>\n",
       "      <td>48.9</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>270.0</td>\n",
       "      <td>257.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1596.0</td>\n",
       "      <td>302.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>49.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>vs Napoli</td>\n",
       "      <td>25.0</td>\n",
       "      <td>41.9</td>\n",
       "      <td>18.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>264.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1230.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>51.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>vs Parma</td>\n",
       "      <td>33.0</td>\n",
       "      <td>54.4</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1628.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>44.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>vs Roma</td>\n",
       "      <td>23.0</td>\n",
       "      <td>48.8</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>241.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1552.0</td>\n",
       "      <td>214.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>46.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>vs Sampdoria</td>\n",
       "      <td>26.0</td>\n",
       "      <td>57.6</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>263.0</td>\n",
       "      <td>251.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1853.0</td>\n",
       "      <td>361.0</td>\n",
       "      <td>314.0</td>\n",
       "      <td>53.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>vs Sassuolo</td>\n",
       "      <td>27.0</td>\n",
       "      <td>41.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>257.0</td>\n",
       "      <td>217.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1493.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>vs Spezia</td>\n",
       "      <td>34.0</td>\n",
       "      <td>48.4</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>249.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1652.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>51.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>vs Torino</td>\n",
       "      <td>26.0</td>\n",
       "      <td>52.1</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>316.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1556.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>52.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>vs Udinese</td>\n",
       "      <td>28.0</td>\n",
       "      <td>54.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>265.0</td>\n",
       "      <td>257.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1547.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>50.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 191 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               squad  players_used  possession  games  games_starts  minutes  \\\n",
       "0        vs Atalanta          28.0        45.7   19.0         209.0   1710.0   \n",
       "1       vs Benevento          24.0        56.3   19.0         209.0   1710.0   \n",
       "2         vs Bologna          31.0        48.7   19.0         209.0   1710.0   \n",
       "3        vs Cagliari          27.0        55.1   19.0         209.0   1710.0   \n",
       "4         vs Crotone          27.0        50.8   19.0         209.0   1710.0   \n",
       "5      vs Fiorentina          25.0        48.4   19.0         209.0   1710.0   \n",
       "6           vs Genoa          31.0        57.1   19.0         209.0   1710.0   \n",
       "7   vs Hellas Verona          28.0        52.8   19.0         209.0   1710.0   \n",
       "8           vs Inter          22.0        45.7   19.0         209.0   1710.0   \n",
       "9        vs Juventus          26.0        41.2   18.0         198.0   1620.0   \n",
       "10          vs Lazio          26.0        48.7   19.0         209.0   1710.0   \n",
       "11          vs Milan          28.0        48.9   19.0         209.0   1710.0   \n",
       "12         vs Napoli          25.0        41.9   18.0         198.0   1620.0   \n",
       "13          vs Parma          33.0        54.4   19.0         209.0   1710.0   \n",
       "14           vs Roma          23.0        48.8   19.0         209.0   1710.0   \n",
       "15      vs Sampdoria          26.0        57.6   19.0         209.0   1710.0   \n",
       "16       vs Sassuolo          27.0        41.3   19.0         209.0   1710.0   \n",
       "17         vs Spezia          34.0        48.4   19.0         209.0   1710.0   \n",
       "18         vs Torino          26.0        52.1   19.0         209.0   1710.0   \n",
       "19        vs Udinese          28.0        54.3   19.0         209.0   1710.0   \n",
       "\n",
       "    goals  assists  pens_made  pens_att  ...  fouls  fouled  offsides  \\\n",
       "0    23.0     21.0        1.0       3.0  ...  253.0   287.0      18.0   \n",
       "1    35.0     28.0        3.0       3.0  ...  319.0   231.0      48.0   \n",
       "2    31.0     22.0        2.0       2.0  ...  246.0   254.0      39.0   \n",
       "3    37.0     27.0        4.0       4.0  ...  248.0   237.0      49.0   \n",
       "4    42.0     29.0        3.0       3.0  ...  272.0   263.0      54.0   \n",
       "5    29.0     18.0        4.0       6.0  ...  285.0   258.0      46.0   \n",
       "6    29.0     22.0        4.0       4.0  ...  259.0   256.0      26.0   \n",
       "7    17.0     13.0        2.0       3.0  ...  283.0   288.0      21.0   \n",
       "8    23.0     16.0        3.0       4.0  ...  232.0   261.0      21.0   \n",
       "9    17.0     12.0        2.0       2.0  ...  233.0   213.0      18.0   \n",
       "10   25.0     15.0        3.0       3.0  ...  236.0   241.0      25.0   \n",
       "11   21.0     11.0        3.0       5.0  ...  270.0   257.0      21.0   \n",
       "12   19.0     12.0        3.0       3.0  ...  264.0   157.0      36.0   \n",
       "13   35.0     26.0        1.0       1.0  ...  250.0   224.0      43.0   \n",
       "14   28.0     16.0        3.0       4.0  ...  241.0   272.0      65.0   \n",
       "15   28.0     16.0        6.0       7.0  ...  263.0   251.0      49.0   \n",
       "16   28.0     22.0        2.0       2.0  ...  257.0   217.0      41.0   \n",
       "17   36.0     26.0        5.0       6.0  ...  249.0   301.0      74.0   \n",
       "18   37.0     24.0        5.0       5.0  ...  316.0   255.0      44.0   \n",
       "19   28.0     22.0        3.0       3.0  ...  265.0   257.0      29.0   \n",
       "\n",
       "    pens_won  pens_conceded  own_goals  ball_recoveries  aerials_won  \\\n",
       "0        2.0            3.0        0.0           1676.0        244.0   \n",
       "1        2.0            4.0        0.0           1559.0        321.0   \n",
       "2        2.0            2.0        2.0           1660.0        300.0   \n",
       "3        3.0            3.0        0.0           1530.0        278.0   \n",
       "4        2.0            4.0        1.0           1667.0        275.0   \n",
       "5        6.0            3.0        1.0           1559.0        278.0   \n",
       "6        4.0            1.0        0.0           2004.0        364.0   \n",
       "7        3.0            3.0        2.0           2066.0        459.0   \n",
       "8        3.0            4.0        3.0           1340.0        225.0   \n",
       "9        1.0            5.0        0.0           1255.0        176.0   \n",
       "10       3.0            4.0        0.0           1653.0        230.0   \n",
       "11       5.0           12.0        1.0           1596.0        302.0   \n",
       "12       3.0            3.0        0.0           1230.0        191.0   \n",
       "13       1.0            1.0        0.0           1628.0        220.0   \n",
       "14       3.0            5.0        1.0           1552.0        214.0   \n",
       "15       5.0            4.0        0.0           1853.0        361.0   \n",
       "16       2.0            5.0        1.0           1493.0        222.0   \n",
       "17       5.0            3.0        0.0           1652.0        286.0   \n",
       "18       4.0            3.0        1.0           1556.0        275.0   \n",
       "19       3.0            1.0        1.0           1547.0        266.0   \n",
       "\n",
       "    aerials_lost  aerials_won_pct  \n",
       "0          347.0             41.3  \n",
       "1          270.0             54.3  \n",
       "2          314.0             48.9  \n",
       "3          270.0             50.7  \n",
       "4          224.0             55.1  \n",
       "5          271.0             50.6  \n",
       "6          266.0             57.8  \n",
       "7          421.0             52.2  \n",
       "8          278.0             44.7  \n",
       "9          216.0             44.9  \n",
       "10         271.0             45.9  \n",
       "11         311.0             49.3  \n",
       "12         183.0             51.1  \n",
       "13         276.0             44.4  \n",
       "14         242.0             46.9  \n",
       "15         314.0             53.5  \n",
       "16         231.0             49.0  \n",
       "17         269.0             51.5  \n",
       "18         254.0             52.0  \n",
       "19         259.0             50.7  \n",
       "\n",
       "[20 rows x 191 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "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 2019/20, 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/11/','/Serie-A-Stats')\n",
    "total_teams = int(len(df_team)/2)\n",
    "df_team = df_team[0:total_teams]\n",
    "\n",
    "#Save csv file to Desktop\n",
    "df_team.to_csv('SerieA2021_teams_vs.csv',index=False)\n",
    "\n",
    "df_team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>Sergio Asenjo</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>31-215</td>\n",
       "      <td>1989</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>...</td>\n",
       "      <td>34.9</td>\n",
       "      <td>139.0</td>\n",
       "      <td>47.5</td>\n",
       "      <td>41.8</td>\n",
       "      <td>221.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>10.4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.40</td>\n",
       "      <td>12.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Édgar Badía</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Elche</td>\n",
       "      <td>28-352</td>\n",
       "      <td>1992</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>...</td>\n",
       "      <td>32.8</td>\n",
       "      <td>172.0</td>\n",
       "      <td>52.9</td>\n",
       "      <td>36.2</td>\n",
       "      <td>199.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.72</td>\n",
       "      <td>12.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Rubén Blanco</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>25-188</td>\n",
       "      <td>1995</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1170.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>...</td>\n",
       "      <td>35.7</td>\n",
       "      <td>96.0</td>\n",
       "      <td>60.4</td>\n",
       "      <td>43.7</td>\n",
       "      <td>112.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.3</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.54</td>\n",
       "      <td>15.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Yassine Bounou</td>\n",
       "      <td>ma MAR</td>\n",
       "      <td>GK</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>29-299</td>\n",
       "      <td>1991</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1440.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>...</td>\n",
       "      <td>34.9</td>\n",
       "      <td>96.0</td>\n",
       "      <td>60.4</td>\n",
       "      <td>45.2</td>\n",
       "      <td>130.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.63</td>\n",
       "      <td>15.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Claudio Bravo</td>\n",
       "      <td>cl CHI</td>\n",
       "      <td>GK</td>\n",
       "      <td>Betis</td>\n",
       "      <td>37-291</td>\n",
       "      <td>1983</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>810.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>...</td>\n",
       "      <td>41.1</td>\n",
       "      <td>48.0</td>\n",
       "      <td>58.3</td>\n",
       "      <td>47.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>12.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Dani Cárdenas</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Levante</td>\n",
       "      <td>23-307</td>\n",
       "      <td>1997</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>30.5</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.3</td>\n",
       "      <td>18.4</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>15.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alberto Cifuentes</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Cádiz</td>\n",
       "      <td>41-245</td>\n",
       "      <td>1979</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>59.7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>87.5</td>\n",
       "      <td>61.1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>14.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Thibaut Courtois</td>\n",
       "      <td>be BEL</td>\n",
       "      <td>GK</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>28-263</td>\n",
       "      <td>1992</td>\n",
       "      <td>19.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>...</td>\n",
       "      <td>31.6</td>\n",
       "      <td>122.0</td>\n",
       "      <td>41.8</td>\n",
       "      <td>39.6</td>\n",
       "      <td>154.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>10.4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.53</td>\n",
       "      <td>14.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Marko Dmitrović</td>\n",
       "      <td>rs SRB</td>\n",
       "      <td>GK</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>29-005</td>\n",
       "      <td>1992</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>...</td>\n",
       "      <td>57.4</td>\n",
       "      <td>129.0</td>\n",
       "      <td>94.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>169.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.05</td>\n",
       "      <td>16.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Jaume Doménech</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>30-085</td>\n",
       "      <td>1990</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>...</td>\n",
       "      <td>42.3</td>\n",
       "      <td>188.0</td>\n",
       "      <td>75.5</td>\n",
       "      <td>54.6</td>\n",
       "      <td>239.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.50</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Aitor Fernández</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Levante</td>\n",
       "      <td>29-271</td>\n",
       "      <td>1991</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1530.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>...</td>\n",
       "      <td>37.7</td>\n",
       "      <td>129.0</td>\n",
       "      <td>29.5</td>\n",
       "      <td>30.6</td>\n",
       "      <td>161.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>15.6</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>Huesca</td>\n",
       "      <td>22-291</td>\n",
       "      <td>1998</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>810.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>36.5</td>\n",
       "      <td>69.0</td>\n",
       "      <td>39.1</td>\n",
       "      <td>39.5</td>\n",
       "      <td>80.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.56</td>\n",
       "      <td>16.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Andrés Fernández</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Huesca</td>\n",
       "      <td>34-043</td>\n",
       "      <td>1986</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>990.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>...</td>\n",
       "      <td>37.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>53.7</td>\n",
       "      <td>43.8</td>\n",
       "      <td>109.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.27</td>\n",
       "      <td>11.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>David Gil</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Cádiz</td>\n",
       "      <td>27-018</td>\n",
       "      <td>1994</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>51.4</td>\n",
       "      <td>9.0</td>\n",
       "      <td>88.9</td>\n",
       "      <td>64.3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sergio Herrera</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Osasuna</td>\n",
       "      <td>27-238</td>\n",
       "      <td>1993</td>\n",
       "      <td>18.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1608.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>...</td>\n",
       "      <td>54.1</td>\n",
       "      <td>133.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>64.8</td>\n",
       "      <td>206.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>9.7</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1.90</td>\n",
       "      <td>16.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Ángel Jiménez</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Granada</td>\n",
       "      <td>18-221</td>\n",
       "      <td>2002</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>50.1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>82.4</td>\n",
       "      <td>55.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>14.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Jeremías Ledesma</td>\n",
       "      <td>ar ARG</td>\n",
       "      <td>GK</td>\n",
       "      <td>Cádiz</td>\n",
       "      <td>27-351</td>\n",
       "      <td>1993</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>57.4</td>\n",
       "      <td>140.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>68.6</td>\n",
       "      <td>176.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>12.5</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.53</td>\n",
       "      <td>14.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Jordi Masip</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Valladolid</td>\n",
       "      <td>32-026</td>\n",
       "      <td>1989</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1260.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>...</td>\n",
       "      <td>49.9</td>\n",
       "      <td>121.0</td>\n",
       "      <td>86.8</td>\n",
       "      <td>63.3</td>\n",
       "      <td>173.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.64</td>\n",
       "      <td>13.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Neto</td>\n",
       "      <td>br BRA</td>\n",
       "      <td>GK</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>31-194</td>\n",
       "      <td>1989</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>540.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27.3</td>\n",
       "      <td>41.0</td>\n",
       "      <td>17.1</td>\n",
       "      <td>24.4</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.67</td>\n",
       "      <td>15.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Jan Oblak</td>\n",
       "      <td>si SVN</td>\n",
       "      <td>GK</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>28-022</td>\n",
       "      <td>1993</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1620.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.9</td>\n",
       "      <td>157.0</td>\n",
       "      <td>67.5</td>\n",
       "      <td>49.4</td>\n",
       "      <td>168.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.28</td>\n",
       "      <td>13.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Fernando Pacheco</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Alavés</td>\n",
       "      <td>28-256</td>\n",
       "      <td>1992</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>...</td>\n",
       "      <td>45.5</td>\n",
       "      <td>169.0</td>\n",
       "      <td>63.3</td>\n",
       "      <td>47.2</td>\n",
       "      <td>178.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>15.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Álex Remiro</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>25-311</td>\n",
       "      <td>1995</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>...</td>\n",
       "      <td>38.2</td>\n",
       "      <td>107.0</td>\n",
       "      <td>58.9</td>\n",
       "      <td>48.5</td>\n",
       "      <td>148.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.4</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Roberto</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Valladolid</td>\n",
       "      <td>34-354</td>\n",
       "      <td>1986</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>540.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>51.1</td>\n",
       "      <td>52.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>68.8</td>\n",
       "      <td>58.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.83</td>\n",
       "      <td>14.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Joel Robles</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Betis</td>\n",
       "      <td>30-226</td>\n",
       "      <td>1990</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>990.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>...</td>\n",
       "      <td>44.8</td>\n",
       "      <td>76.0</td>\n",
       "      <td>56.6</td>\n",
       "      <td>45.9</td>\n",
       "      <td>89.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.6</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.82</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Rubén</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK,MF</td>\n",
       "      <td>Osasuna</td>\n",
       "      <td>36-221</td>\n",
       "      <td>1984</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>55.7</td>\n",
       "      <td>15.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>65.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.44</td>\n",
       "      <td>14.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Rui Silva</td>\n",
       "      <td>pt POR</td>\n",
       "      <td>GK</td>\n",
       "      <td>Granada</td>\n",
       "      <td>26-357</td>\n",
       "      <td>1994</td>\n",
       "      <td>19.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>...</td>\n",
       "      <td>49.3</td>\n",
       "      <td>155.0</td>\n",
       "      <td>79.4</td>\n",
       "      <td>56.9</td>\n",
       "      <td>189.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.63</td>\n",
       "      <td>14.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Unai Simón</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>23-232</td>\n",
       "      <td>1997</td>\n",
       "      <td>19.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1710.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>...</td>\n",
       "      <td>42.6</td>\n",
       "      <td>132.0</td>\n",
       "      <td>87.1</td>\n",
       "      <td>64.8</td>\n",
       "      <td>179.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>7.3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.68</td>\n",
       "      <td>14.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>David Soria</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>27-300</td>\n",
       "      <td>1993</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1080.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>58.7</td>\n",
       "      <td>87.0</td>\n",
       "      <td>75.9</td>\n",
       "      <td>53.1</td>\n",
       "      <td>75.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Marc-André ter Stegen</td>\n",
       "      <td>de GER</td>\n",
       "      <td>GK</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>28-274</td>\n",
       "      <td>1992</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1170.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>...</td>\n",
       "      <td>29.3</td>\n",
       "      <td>69.0</td>\n",
       "      <td>40.6</td>\n",
       "      <td>36.6</td>\n",
       "      <td>73.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13.7</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.69</td>\n",
       "      <td>16.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Tomáš Vaclík</td>\n",
       "      <td>cz CZE</td>\n",
       "      <td>GK</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>31-306</td>\n",
       "      <td>1989</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>31.7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>38.3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.67</td>\n",
       "      <td>14.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Koke Vegas</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Levante</td>\n",
       "      <td>25-124</td>\n",
       "      <td>1995</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>37.7</td>\n",
       "      <td>11.0</td>\n",
       "      <td>27.3</td>\n",
       "      <td>30.5</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>18.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Iván Villar</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>23-204</td>\n",
       "      <td>1997</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>39.2</td>\n",
       "      <td>56.0</td>\n",
       "      <td>46.4</td>\n",
       "      <td>40.8</td>\n",
       "      <td>67.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.14</td>\n",
       "      <td>17.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Rubén Yáñez</td>\n",
       "      <td>es ESP</td>\n",
       "      <td>GK</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>27-109</td>\n",
       "      <td>1993</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>48.9</td>\n",
       "      <td>37.0</td>\n",
       "      <td>83.8</td>\n",
       "      <td>57.7</td>\n",
       "      <td>55.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.71</td>\n",
       "      <td>15.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   player nationality position            squad     age  \\\n",
       "0           Sergio Asenjo      es ESP       GK       Villarreal  31-215   \n",
       "1             Édgar Badía      es ESP       GK            Elche  28-352   \n",
       "2            Rubén Blanco      es ESP       GK       Celta Vigo  25-188   \n",
       "3          Yassine Bounou      ma MAR       GK          Sevilla  29-299   \n",
       "4           Claudio Bravo      cl CHI       GK            Betis  37-291   \n",
       "5           Dani Cárdenas      es ESP       GK          Levante  23-307   \n",
       "6       Alberto Cifuentes      es ESP       GK            Cádiz  41-245   \n",
       "7        Thibaut Courtois      be BEL       GK      Real Madrid  28-263   \n",
       "8         Marko Dmitrović      rs SRB       GK            Eibar  29-005   \n",
       "9          Jaume Doménech      es ESP       GK         Valencia  30-085   \n",
       "10        Aitor Fernández      es ESP       GK          Levante  29-271   \n",
       "11       Álvaro Fernández      es ESP       GK           Huesca  22-291   \n",
       "12       Andrés Fernández      es ESP       GK           Huesca  34-043   \n",
       "13              David Gil      es ESP       GK            Cádiz  27-018   \n",
       "14         Sergio Herrera      es ESP       GK          Osasuna  27-238   \n",
       "15          Ángel Jiménez      es ESP       GK          Granada  18-221   \n",
       "16       Jeremías Ledesma      ar ARG       GK            Cádiz  27-351   \n",
       "17            Jordi Masip      es ESP       GK       Valladolid  32-026   \n",
       "18                   Neto      br BRA       GK        Barcelona  31-194   \n",
       "19              Jan Oblak      si SVN       GK  Atlético Madrid  28-022   \n",
       "20       Fernando Pacheco      es ESP       GK           Alavés  28-256   \n",
       "21            Álex Remiro      es ESP       GK    Real Sociedad  25-311   \n",
       "22                Roberto      es ESP       GK       Valladolid  34-354   \n",
       "23            Joel Robles      es ESP       GK            Betis  30-226   \n",
       "24                  Rubén      es ESP    GK,MF          Osasuna  36-221   \n",
       "25              Rui Silva      pt POR       GK          Granada  26-357   \n",
       "26             Unai Simón      es ESP       GK    Athletic Club  23-232   \n",
       "27            David Soria      es ESP       GK           Getafe  27-300   \n",
       "28  Marc-André ter Stegen      de GER       GK        Barcelona  28-274   \n",
       "29           Tomáš Vaclík      cz CZE       GK          Sevilla  31-306   \n",
       "30             Koke Vegas      es ESP       GK          Levante  25-124   \n",
       "31            Iván Villar      es ESP       GK       Celta Vigo  23-204   \n",
       "32            Rubén Yáñez      es ESP       GK           Getafe  27-109   \n",
       "\n",
       "   birth_year  games_gk  games_starts_gk  minutes_gk  goals_against_gk  ...  \\\n",
       "0        1989      20.0             20.0      1800.0              20.0  ...   \n",
       "1        1992      18.0             18.0      1620.0              25.0  ...   \n",
       "2        1995      13.0             13.0      1170.0              21.0  ...   \n",
       "3        1991      16.0             16.0      1440.0              13.0  ...   \n",
       "4        1983       9.0              9.0       810.0              16.0  ...   \n",
       "5        1997       1.0              1.0        90.0               1.0  ...   \n",
       "6        1979       2.0              2.0       180.0               3.0  ...   \n",
       "7        1992      19.0             19.0      1710.0              16.0  ...   \n",
       "8        1992      20.0             20.0      1800.0              21.0  ...   \n",
       "9        1990      20.0             20.0      1800.0              29.0  ...   \n",
       "10       1991      17.0             17.0      1530.0              25.0  ...   \n",
       "11       1998       9.0              9.0       810.0              12.0  ...   \n",
       "12       1986      11.0             11.0       990.0              17.0  ...   \n",
       "13       1994       1.0              1.0        90.0               2.0  ...   \n",
       "14       1993      18.0             17.0      1608.0              24.0  ...   \n",
       "15       2002       1.0              1.0        90.0               2.0  ...   \n",
       "16       1993      17.0             17.0      1530.0              22.0  ...   \n",
       "17       1989      14.0             14.0      1260.0              19.0  ...   \n",
       "18       1989       6.0              6.0       540.0               6.0  ...   \n",
       "19       1993      18.0             18.0      1620.0               8.0  ...   \n",
       "20       1992      20.0             20.0      1800.0              29.0  ...   \n",
       "21       1995      20.0             20.0      1800.0              18.0  ...   \n",
       "22       1986       6.0              6.0       540.0              10.0  ...   \n",
       "23       1990      11.0             11.0       990.0              18.0  ...   \n",
       "24       1984       3.0              3.0       187.0               5.0  ...   \n",
       "25       1994      19.0             19.0      1710.0              32.0  ...   \n",
       "26       1997      19.0             19.0      1710.0              23.0  ...   \n",
       "27       1993      12.0             12.0      1080.0              14.0  ...   \n",
       "28       1992      13.0             13.0      1170.0              11.0  ...   \n",
       "29       1989       3.0              3.0       270.0               3.0  ...   \n",
       "30       1995       1.0              1.0        90.0               2.0  ...   \n",
       "31       1997       7.0              7.0       630.0              10.0  ...   \n",
       "32       1993       7.0              7.0       630.0               9.0  ...   \n",
       "\n",
       "    passes_length_avg_gk  goal_kicks  pct_goal_kicks_launched  \\\n",
       "0                   34.9       139.0                     47.5   \n",
       "1                   32.8       172.0                     52.9   \n",
       "2                   35.7        96.0                     60.4   \n",
       "3                   34.9        96.0                     60.4   \n",
       "4                   41.1        48.0                     58.3   \n",
       "5                   30.5         7.0                     14.3   \n",
       "6                   59.7        16.0                     87.5   \n",
       "7                   31.6       122.0                     41.8   \n",
       "8                   57.4       129.0                     94.6   \n",
       "9                   42.3       188.0                     75.5   \n",
       "10                  37.7       129.0                     29.5   \n",
       "11                  36.5        69.0                     39.1   \n",
       "12                  37.0        82.0                     53.7   \n",
       "13                  51.4         9.0                     88.9   \n",
       "14                  54.1       133.0                     97.0   \n",
       "15                  50.1        17.0                     82.4   \n",
       "16                  57.4       140.0                     95.0   \n",
       "17                  49.9       121.0                     86.8   \n",
       "18                  27.3        41.0                     17.1   \n",
       "19                  43.9       157.0                     67.5   \n",
       "20                  45.5       169.0                     63.3   \n",
       "21                  38.2       107.0                     58.9   \n",
       "22                  51.1        52.0                     86.5   \n",
       "23                  44.8        76.0                     56.6   \n",
       "24                  55.7        15.0                    100.0   \n",
       "25                  49.3       155.0                     79.4   \n",
       "26                  42.6       132.0                     87.1   \n",
       "27                  58.7        87.0                     75.9   \n",
       "28                  29.3        69.0                     40.6   \n",
       "29                  31.7         8.0                     50.0   \n",
       "30                  37.7        11.0                     27.3   \n",
       "31                  39.2        56.0                     46.4   \n",
       "32                  48.9        37.0                     83.8   \n",
       "\n",
       "    goal_kick_length_avg  crosses_gk  crosses_stopped_gk  \\\n",
       "0                   41.8       221.0                23.0   \n",
       "1                   36.2       199.0                13.0   \n",
       "2                   43.7       112.0                 7.0   \n",
       "3                   45.2       130.0                10.0   \n",
       "4                   47.0        61.0                 3.0   \n",
       "5                   18.4        16.0                 2.0   \n",
       "6                   61.1        17.0                 1.0   \n",
       "7                   39.6       154.0                16.0   \n",
       "8                   75.4       169.0                11.0   \n",
       "9                   54.6       239.0                16.0   \n",
       "10                  30.6       161.0                11.0   \n",
       "11                  39.5        80.0                 6.0   \n",
       "12                  43.8       109.0                 9.0   \n",
       "13                  64.3         5.0                 0.0   \n",
       "14                  64.8       206.0                20.0   \n",
       "15                  55.0        10.0                 0.0   \n",
       "16                  68.6       176.0                22.0   \n",
       "17                  63.3       173.0                11.0   \n",
       "18                  24.4        52.0                 2.0   \n",
       "19                  49.4       168.0                10.0   \n",
       "20                  47.2       178.0                16.0   \n",
       "21                  48.5       148.0                11.0   \n",
       "22                  68.8        58.0                 5.0   \n",
       "23                  45.9        89.0                 5.0   \n",
       "24                  65.7        19.0                 1.0   \n",
       "25                  56.9       189.0                 6.0   \n",
       "26                  64.8       179.0                13.0   \n",
       "27                  53.1        75.0                 9.0   \n",
       "28                  36.6        73.0                10.0   \n",
       "29                  38.3        19.0                 1.0   \n",
       "30                  30.5         7.0                 0.0   \n",
       "31                  40.8        67.0                 5.0   \n",
       "32                  57.7        55.0                 5.0   \n",
       "\n",
       "    crosses_stopped_pct_gk  def_actions_outside_pen_area_gk  \\\n",
       "0                     10.4                              8.0   \n",
       "1                      6.5                             13.0   \n",
       "2                      6.3                              7.0   \n",
       "3                      7.7                             10.0   \n",
       "4                      4.9                              3.0   \n",
       "5                     12.5                              1.0   \n",
       "6                      5.9                              2.0   \n",
       "7                     10.4                             10.0   \n",
       "8                      6.5                             21.0   \n",
       "9                      6.7                             10.0   \n",
       "10                     6.8                             17.0   \n",
       "11                     7.5                              5.0   \n",
       "12                     8.3                              3.0   \n",
       "13                     0.0                              0.0   \n",
       "14                     9.7                             34.0   \n",
       "15                     0.0                              1.0   \n",
       "16                    12.5                              9.0   \n",
       "17                     6.4                              9.0   \n",
       "18                     3.8                              4.0   \n",
       "19                     6.0                              5.0   \n",
       "20                     9.0                             15.0   \n",
       "21                     7.4                             11.0   \n",
       "22                     8.6                              5.0   \n",
       "23                     5.6                              9.0   \n",
       "24                     5.3                              3.0   \n",
       "25                     3.2                             12.0   \n",
       "26                     7.3                             13.0   \n",
       "27                    12.0                             15.0   \n",
       "28                    13.7                              9.0   \n",
       "29                     5.3                              2.0   \n",
       "30                     0.0                              1.0   \n",
       "31                     7.5                              8.0   \n",
       "32                     9.1                              5.0   \n",
       "\n",
       "    def_actions_outside_pen_area_per90_gk  avg_distance_def_actions_gk  \n",
       "0                                    0.40                         12.9  \n",
       "1                                    0.72                         12.8  \n",
       "2                                    0.54                         15.2  \n",
       "3                                    0.63                         15.2  \n",
       "4                                    0.33                         12.1  \n",
       "5                                    1.00                         15.3  \n",
       "6                                    1.00                         14.3  \n",
       "7                                    0.53                         14.4  \n",
       "8                                    1.05                         16.8  \n",
       "9                                    0.50                         13.5  \n",
       "10                                   1.00                         15.6  \n",
       "11                                   0.56                         16.5  \n",
       "12                                   0.27                         11.9  \n",
       "13                                   0.00                          9.0  \n",
       "14                                   1.90                         16.6  \n",
       "15                                   1.00                         14.3  \n",
       "16                                   0.53                         14.1  \n",
       "17                                   0.64                         13.3  \n",
       "18                                   0.67                         15.7  \n",
       "19                                   0.28                         13.9  \n",
       "20                                   0.75                         15.1  \n",
       "21                                   0.55                         15.0  \n",
       "22                                   0.83                         14.8  \n",
       "23                                   0.82                         18.0  \n",
       "24                                   1.44                         14.6  \n",
       "25                                   0.63                         14.8  \n",
       "26                                   0.68                         14.1  \n",
       "27                                   1.25                         15.6  \n",
       "28                                   0.69                         16.7  \n",
       "29                                   0.67                         14.9  \n",
       "30                                   1.00                         18.8  \n",
       "31                                   1.14                         17.2  \n",
       "32                                   0.71                         15.6  \n",
       "\n",
       "[33 rows x 47 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "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 2019/20, 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/12/','/La-Liga-Stats')\n",
    "\n",
    "#Save csv file to Desktop\n",
    "df_team.to_csv('LaLiga2021_keepers.csv',index=False)\n",
    "\n",
    "df_keeper"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}