Web_Scraping_Transfermarkt.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "cda98352",
   "metadata": {},
   "source": [
    "<h1><center>WebScraping Transfermarkt</center></h1>\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "694ec27c",
   "metadata": {},
   "source": [
    "This Notebook will be utilising the BeautifulSoup Web scraping library, to web scrape data from the popular football transfer website Transfermarkt. The aim of this notebook is to be an introduction to web scraping football data, it will demonstrate a very easy way to scrape football transfer data as shown by the FC Python community website. Knowledge of HTML, CSS is advantageous when doing web scraping however not specifically required."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2415762b",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import Libraries\n",
    "import requests\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from bs4 import BeautifulSoup\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "id": "a1a9ef16",
   "metadata": {},
   "outputs": [],
   "source": [
    "#This will tell the browser that we are a browser and not a scraping tool\n",
    "headers = {'User-Agent':\n",
    "          'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36'}\n",
    "\n",
    "#The page will be the page to be scraped\n",
    "page = 'https://www.transfermarkt.co.uk/transfers/transferrekorde/statistik/top/plus/0/galerie/0?saison_id=2021'\n",
    "pageTree = requests.get(page, headers=headers)\n",
    "pageSoup = BeautifulSoup(pageTree.content, 'html.parser')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "3c0ba603",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Find all the td tags with the class \"hauptlink\" and store it in the\n",
    "#variable Players\n",
    "Players = pageSoup.find_all(\"td\", {\"class\":\"hauptlink\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "9538bb49",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'bs4.element.ResultSet'>\n",
      "75\n"
     ]
    }
   ],
   "source": [
    "#The type of the variable Players\n",
    "print(type(Players))\n",
    "\n",
    "#Length of the element resultset\n",
    "print(len(Players))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "8a582330",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\nJack Grealish '"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Text value of the first element in Players\n",
    "Players[0].text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "730e33e4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 <td class=\"hauptlink\">\n",
      "<a href=\"/jack-grealish/profil/spieler/203460\" title=\"Jack Grealish\">Jack Grealish</a> </td>\n",
      "1 <td class=\"hauptlink\">\n",
      "<a href=\"/manchester-city/startseite/verein/281/saison_id/2021\" title=\"Manchester City\">Man City</a> </td>\n",
      "2 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/203460/transfer_id/3479948\">£105.75m</a></td>\n",
      "3 <td class=\"hauptlink\">\n",
      "<a href=\"/romelu-lukaku/profil/spieler/96341\" title=\"Romelu Lukaku\">Romelu Lukaku</a> </td>\n",
      "4 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-chelsea/startseite/verein/631/saison_id/2021\" title=\"Chelsea FC\">Chelsea</a> </td>\n",
      "5 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/96341/transfer_id/3494597\">£101.70m</a></td>\n",
      "6 <td class=\"hauptlink\">\n",
      "<a href=\"/jadon-sancho/profil/spieler/401173\" title=\"Jadon Sancho\">Jadon Sancho</a> </td>\n",
      "7 <td class=\"hauptlink\">\n",
      "<a href=\"/manchester-united/startseite/verein/985/saison_id/2021\" title=\"Manchester United\">Man Utd</a> </td>\n",
      "8 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/401173/transfer_id/3456520\">£76.50m</a></td>\n",
      "9 <td class=\"hauptlink\">\n",
      "<a href=\"/dusan-vlahovic/profil/spieler/357498\" title=\"Dusan Vlahovic\">Dusan Vlahovic</a> </td>\n",
      "10 <td class=\"hauptlink\">\n",
      "<a href=\"/juventus-turin/startseite/verein/506/saison_id/2021\" title=\"Juventus FC\">Juventus</a> </td>\n",
      "11 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/357498/transfer_id/3717441\">£73.44m</a></td>\n",
      "12 <td class=\"hauptlink\">\n",
      "<a href=\"/achraf-hakimi/profil/spieler/398073\" title=\"Achraf Hakimi\">Achraf Hakimi</a> </td>\n",
      "13 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-paris-saint-germain/startseite/verein/583/saison_id/2021\" title=\"Paris Saint-Germain\">Paris SG</a> </td>\n",
      "14 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/398073/transfer_id/3425954\">£59.85m</a></td>\n",
      "15 <td class=\"hauptlink\">\n",
      "<a href=\"/ben-white/profil/spieler/335721\" title=\"Ben White\">Ben White</a> </td>\n",
      "16 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-arsenal/startseite/verein/11/saison_id/2021\" title=\"Arsenal FC\">Arsenal</a> </td>\n",
      "17 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/335721/transfer_id/3469581\">£52.65m</a></td>\n",
      "18 <td class=\"hauptlink\">\n",
      "<a href=\"/ferran-torres/profil/spieler/398184\" title=\"Ferran Torres\">Ferran Torres</a> </td>\n",
      "19 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-barcelona/startseite/verein/131/saison_id/2021\" title=\"FC Barcelona\">Barcelona</a> </td>\n",
      "20 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/398184/transfer_id/3669718\">£49.50m</a></td>\n",
      "21 <td class=\"hauptlink\">\n",
      "<a href=\"/luis-diaz/profil/spieler/480692\" title=\"Luis Díaz\">Luis Díaz</a> </td>\n",
      "22 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-liverpool/startseite/verein/31/saison_id/2021\" title=\"Liverpool FC\">Liverpool</a> </td>\n",
      "23 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/480692/transfer_id/3720042\">£40.50m</a></td>\n",
      "24 <td class=\"hauptlink\">\n",
      "<a href=\"/dayot-upamecano/profil/spieler/344695\" title=\"Dayot Upamecano\">Dayot Upamecano</a> </td>\n",
      "25 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-bayern-munchen/startseite/verein/27/saison_id/2021\" title=\"Bayern Munich\">FC Bayern </a> </td>\n",
      "26 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/344695/transfer_id/3252783\">£38.25m</a></td>\n",
      "27 <td class=\"hauptlink\">\n",
      "<a href=\"/bruno-guimaraes/profil/spieler/520624\" title=\"Bruno Guimarães\">Bruno Guimarães</a> </td>\n",
      "28 <td class=\"hauptlink\">\n",
      "<a href=\"/newcastle-united/startseite/verein/762/saison_id/2021\" title=\"Newcastle United\">Newcastle</a> </td>\n",
      "29 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/520624/transfer_id/3720274\">£37.89m</a></td>\n",
      "30 <td class=\"hauptlink\">\n",
      "<a href=\"/raphael-varane/profil/spieler/164770\" title=\"Raphaël Varane\">Raphaël Varane</a> </td>\n",
      "31 <td class=\"hauptlink\">\n",
      "<a href=\"/manchester-united/startseite/verein/985/saison_id/2021\" title=\"Manchester United\">Man Utd</a> </td>\n",
      "32 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/164770/transfer_id/3498143\">£36.00m</a></td>\n",
      "33 <td class=\"hauptlink\">\n",
      "<a href=\"/tammy-abraham/profil/spieler/331726\" title=\"Tammy Abraham\">Tammy Abraham</a> </td>\n",
      "34 <td class=\"hauptlink\">\n",
      "<a href=\"/as-rom/startseite/verein/12/saison_id/2021\" title=\"AS Roma\">AS Roma</a> </td>\n",
      "35 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/331726/transfer_id/3503145\">£36.00m</a></td>\n",
      "36 <td class=\"hauptlink\">\n",
      "<a href=\"/ibrahima-konate/profil/spieler/357119\" title=\"Ibrahima Konaté\">Ibrahima Konaté</a> </td>\n",
      "37 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-liverpool/startseite/verein/31/saison_id/2021\" title=\"Liverpool FC\">Liverpool</a> </td>\n",
      "38 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/357119/transfer_id/3380058\">£36.00m</a></td>\n",
      "39 <td class=\"hauptlink\">\n",
      "<a href=\"/emiliano-buendia/profil/spieler/321247\" title=\"Emiliano Buendía\">Emiliano Buendía</a> </td>\n",
      "40 <td class=\"hauptlink\">\n",
      "<a href=\"/aston-villa/startseite/verein/405/saison_id/2021\" title=\"Aston Villa\">Aston Villa</a> </td>\n",
      "41 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/321247/transfer_id/3392957\">£34.56m</a></td>\n",
      "42 <td class=\"hauptlink\">\n",
      "<a href=\"/martin-odegaard/profil/spieler/316264\" title=\"Martin Ødegaard\">Martin Ødegaard</a> </td>\n",
      "43 <td class=\"hauptlink\">\n",
      "<a href=\"/fc-arsenal/startseite/verein/11/saison_id/2021\" title=\"Arsenal FC\">Arsenal</a> </td>\n",
      "44 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/316264/transfer_id/3509558\">£31.50m</a></td>\n",
      "45 <td class=\"hauptlink\">\n",
      "<a href=\"/rodrigo-de-paul/profil/spieler/255901\" title=\"Rodrigo de Paul\">Rodrigo de Paul</a> </td>\n",
      "46 <td class=\"hauptlink\">\n",
      "<a href=\"/atletico-madrid/startseite/verein/13/saison_id/2021\" title=\"Atlético de Madrid\">Atlético Madrid</a> </td>\n",
      "47 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/255901/transfer_id/3436047\">£31.50m</a></td>\n",
      "48 <td class=\"hauptlink\">\n",
      "<a href=\"/kurt-zouma/profil/spieler/157509\" title=\"Kurt Zouma\">Kurt Zouma</a> </td>\n",
      "49 <td class=\"hauptlink\">\n",
      "<a href=\"/west-ham-united/startseite/verein/379/saison_id/2021\" title=\"West Ham United\">West Ham</a> </td>\n",
      "50 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/157509/transfer_id/3523391\">£31.50m</a></td>\n",
      "51 <td class=\"hauptlink\">\n",
      "<a href=\"/leon-bailey/profil/spieler/387626\" title=\"Leon Bailey\">Leon Bailey</a> </td>\n",
      "52 <td class=\"hauptlink\">\n",
      "<a href=\"/aston-villa/startseite/verein/405/saison_id/2021\" title=\"Aston Villa\">Aston Villa</a> </td>\n",
      "53 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/387626/transfer_id/3477204\">£28.80m</a></td>\n",
      "54 <td class=\"hauptlink\">\n",
      "<a href=\"/eduardo-camavinga/profil/spieler/640428\" title=\"Eduardo Camavinga\">Eduardo Camavinga</a> </td>\n",
      "55 <td class=\"hauptlink\">\n",
      "<a href=\"/real-madrid/startseite/verein/418/saison_id/2021\" title=\"Real Madrid\">Real Madrid</a> </td>\n",
      "56 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/640428/transfer_id/3529684\">£27.90m</a></td>\n",
      "57 <td class=\"hauptlink\">\n",
      "<a href=\"/nikola-vlasic/profil/spieler/293200\" title=\"Nikola Vlasic\">Nikola Vlasic</a> </td>\n",
      "58 <td class=\"hauptlink\">\n",
      "<a href=\"/west-ham-united/startseite/verein/379/saison_id/2021\" title=\"West Ham United\">West Ham</a> </td>\n",
      "59 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/293200/transfer_id/3527846\">£27.00m</a></td>\n",
      "60 <td class=\"hauptlink\">\n",
      "<a href=\"/donyell-malen/profil/spieler/326029\" title=\"Donyell Malen\">Donyell Malen</a> </td>\n",
      "61 <td class=\"hauptlink\">\n",
      "<a href=\"/borussia-dortmund/startseite/verein/16/saison_id/2021\" title=\"Borussia Dortmund\">Bor. Dortmund</a> </td>\n",
      "62 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/326029/transfer_id/3464322\">£27.00m</a></td>\n",
      "63 <td class=\"hauptlink\">\n",
      "<a href=\"/lucas-digne/profil/spieler/126664\" title=\"Lucas Digne\">Lucas Digne</a> </td>\n",
      "64 <td class=\"hauptlink\">\n",
      "<a href=\"/aston-villa/startseite/verein/405/saison_id/2021\" title=\"Aston Villa\">Aston Villa</a> </td>\n",
      "65 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/126664/transfer_id/3693135\">£27.00m</a></td>\n",
      "66 <td class=\"hauptlink\">\n",
      "<a href=\"/patson-daka/profil/spieler/365172\" title=\"Patson Daka\">Patson Daka</a> </td>\n",
      "67 <td class=\"hauptlink\">\n",
      "<a href=\"/leicester-city/startseite/verein/1003/saison_id/2021\" title=\"Leicester City\">Leicester</a> </td>\n",
      "68 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/365172/transfer_id/3415690\">£27.00m</a></td>\n",
      "69 <td class=\"hauptlink\">\n",
      "<a href=\"/chris-wood/profil/spieler/108725\" title=\"Chris Wood\">Chris Wood</a> </td>\n",
      "70 <td class=\"hauptlink\">\n",
      "<a href=\"/newcastle-united/startseite/verein/762/saison_id/2021\" title=\"Newcastle United\">Newcastle</a> </td>\n",
      "71 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/108725/transfer_id/3693123\">£27.00m</a></td>\n",
      "72 <td class=\"hauptlink\">\n",
      "<a href=\"/danny-ings/profil/spieler/134294\" title=\"Danny Ings\">Danny Ings</a> </td>\n",
      "73 <td class=\"hauptlink\">\n",
      "<a href=\"/aston-villa/startseite/verein/405/saison_id/2021\" title=\"Aston Villa\">Aston Villa</a> </td>\n",
      "74 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/134294/transfer_id/3478204\">£26.48m</a></td>\n"
     ]
    }
   ],
   "source": [
    "#Printing out the index and the value in each index in\n",
    "#The Players list \n",
    "for i,player in enumerate(Players):\n",
    "    print(i, player)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "bf4cf16d",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Find all the td tags with the class \"rechts hauptlink\"\n",
    "Fees = pageSoup.find_all(\"td\", \"rechts hauptlink\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "7127e625",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'bs4.element.ResultSet'>\n"
     ]
    }
   ],
   "source": [
    "#the type of the variable Fees\n",
    "print(type(Fees))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "17c64347",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'£105.75m'"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The text value of the first element of Fees\n",
    "Fees[0].text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "985fd949",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/203460/transfer_id/3479948\">£105.75m</a></td>\n",
      "1 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/96341/transfer_id/3494597\">£101.70m</a></td>\n",
      "2 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/401173/transfer_id/3456520\">£76.50m</a></td>\n",
      "3 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/357498/transfer_id/3717441\">£73.44m</a></td>\n",
      "4 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/398073/transfer_id/3425954\">£59.85m</a></td>\n",
      "5 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/335721/transfer_id/3469581\">£52.65m</a></td>\n",
      "6 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/398184/transfer_id/3669718\">£49.50m</a></td>\n",
      "7 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/480692/transfer_id/3720042\">£40.50m</a></td>\n",
      "8 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/344695/transfer_id/3252783\">£38.25m</a></td>\n",
      "9 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/520624/transfer_id/3720274\">£37.89m</a></td>\n",
      "10 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/164770/transfer_id/3498143\">£36.00m</a></td>\n",
      "11 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/331726/transfer_id/3503145\">£36.00m</a></td>\n",
      "12 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/357119/transfer_id/3380058\">£36.00m</a></td>\n",
      "13 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/321247/transfer_id/3392957\">£34.56m</a></td>\n",
      "14 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/316264/transfer_id/3509558\">£31.50m</a></td>\n",
      "15 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/255901/transfer_id/3436047\">£31.50m</a></td>\n",
      "16 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/157509/transfer_id/3523391\">£31.50m</a></td>\n",
      "17 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/387626/transfer_id/3477204\">£28.80m</a></td>\n",
      "18 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/640428/transfer_id/3529684\">£27.90m</a></td>\n",
      "19 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/293200/transfer_id/3527846\">£27.00m</a></td>\n",
      "20 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/326029/transfer_id/3464322\">£27.00m</a></td>\n",
      "21 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/126664/transfer_id/3693135\">£27.00m</a></td>\n",
      "22 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/365172/transfer_id/3415690\">£27.00m</a></td>\n",
      "23 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/108725/transfer_id/3693123\">£27.00m</a></td>\n",
      "24 <td class=\"rechts hauptlink\"><a href=\"/jumplist/transfers/spieler/134294/transfer_id/3478204\">£26.48m</a></td>\n"
     ]
    }
   ],
   "source": [
    "#Print the index and element of the Result Set\n",
    "for i, row in enumerate(Fees):\n",
    "    print(i, row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "id": "8045b087",
   "metadata": {},
   "outputs": [],
   "source": [
    "#`create two lists one for the Players and one for the Fees\n",
    "PlayersList = []\n",
    "FeesList = []\n",
    "\n",
    "count = 0\n",
    "#For loop to add the names of the players and their corresponding fees\n",
    "#to their respective lists\n",
    "for i, fee in enumerate(Fees):\n",
    "    \n",
    "    PlayersList.append(Players[count].text)\n",
    "    FeesList.append(Fees[i].text)\n",
    "    \n",
    "    count+=3\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "id": "e5615ac3",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Create DataFrame of the Players List and Fees List\n",
    "df_transfer = pd.DataFrame({\"Players\":PlayersList, \"Transfer Fees (£)\": FeesList})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "id": "69ce0939",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Remove the newline character, '£' and 'm' from the Dataframe\n",
    "df_transfer.replace('\\n', '', regex=True, inplace=True)\n",
    "df_transfer.replace('£', '', regex=True, inplace=True)\n",
    "df_transfer['Transfer Fees (£)'].replace('m', '', regex=True, inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "id": "c44c53b1",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Applys the float function to each row in the Transfer Fees column\n",
    "df_transfer['Transfer Fees (£)'] = df_transfer['Transfer Fees (£)'].apply(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "id": "bcd44fcf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Players               object\n",
       "Transfer Fees (£)    float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 163,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Check the Data types in the Dataframe\n",
    "df_transfer.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "id": "0fd16201",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 25 entries, 0 to 24\n",
      "Data columns (total 2 columns):\n",
      " #   Column             Non-Null Count  Dtype  \n",
      "---  ------             --------------  -----  \n",
      " 0   Players            25 non-null     object \n",
      " 1   Transfer Fees (£)  25 non-null     float64\n",
      "dtypes: float64(1), object(1)\n",
      "memory usage: 528.0+ bytes\n"
     ]
    }
   ],
   "source": [
    "#Check the information of the Dataframe\n",
    "df_transfer.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "id": "2f82d207",
   "metadata": {},
   "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>Players</th>\n",
       "      <th>Transfer Fees (£)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jack Grealish</td>\n",
       "      <td>105.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Romelu Lukaku</td>\n",
       "      <td>101.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jadon Sancho</td>\n",
       "      <td>76.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dusan Vlahovic</td>\n",
       "      <td>73.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Achraf Hakimi</td>\n",
       "      <td>59.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ben White</td>\n",
       "      <td>52.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ferran Torres</td>\n",
       "      <td>49.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Luis Díaz</td>\n",
       "      <td>40.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dayot Upamecano</td>\n",
       "      <td>38.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Bruno Guimarães</td>\n",
       "      <td>37.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Raphaël Varane</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Tammy Abraham</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Ibrahima Konaté</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Emiliano Buendía</td>\n",
       "      <td>34.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Martin Ødegaard</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Rodrigo de Paul</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kurt Zouma</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Leon Bailey</td>\n",
       "      <td>28.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Eduardo Camavinga</td>\n",
       "      <td>27.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Nikola Vlasic</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Donyell Malen</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Lucas Digne</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Patson Daka</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Chris Wood</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Danny Ings</td>\n",
       "      <td>26.48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Players  Transfer Fees (£)\n",
       "0       Jack Grealish              105.75\n",
       "1       Romelu Lukaku              101.70\n",
       "2        Jadon Sancho               76.50\n",
       "3      Dusan Vlahovic               73.44\n",
       "4       Achraf Hakimi               59.85\n",
       "5           Ben White               52.65\n",
       "6       Ferran Torres               49.50\n",
       "7           Luis Díaz               40.50\n",
       "8     Dayot Upamecano               38.25\n",
       "9     Bruno Guimarães               37.89\n",
       "10     Raphaël Varane               36.00\n",
       "11      Tammy Abraham               36.00\n",
       "12    Ibrahima Konaté               36.00\n",
       "13   Emiliano Buendía               34.56\n",
       "14    Martin Ødegaard               31.50\n",
       "15    Rodrigo de Paul               31.50\n",
       "16         Kurt Zouma               31.50\n",
       "17        Leon Bailey               28.80\n",
       "18  Eduardo Camavinga               27.90\n",
       "19      Nikola Vlasic               27.00\n",
       "20      Donyell Malen               27.00\n",
       "21        Lucas Digne               27.00\n",
       "22        Patson Daka               27.00\n",
       "23         Chris Wood               27.00\n",
       "24         Danny Ings               26.48"
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_transfer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "id": "5bb185c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Second url for 2020 Transfer data\n",
    "page2 = 'https://www.transfermarkt.co.uk/transfers/transferrekorde/statistik/top/plus/0/galerie/0?saison_id=2020'\n",
    "pageTree2 = requests.get(page2, headers=headers)\n",
    "pageSoup2 = BeautifulSoup(pageTree2.content, 'html.parser')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "ab54d062",
   "metadata": {},
   "outputs": [],
   "source": [
    "Players2 = pageSoup2.find_all(\"td\", \"hauptlink\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "c15d7406",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\nKai Havertz '"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The first element in the Players2\n",
    "Players2[0].text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "08d0aeb9",
   "metadata": {},
   "outputs": [],
   "source": [
    "Fees2 = pageSoup2.find_all(\"td\", \"rechts hauptlink\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "ef1fa3a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'£68.40m'"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The first element in the Fees2\n",
    "Fees2[0].text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "id": "21df96d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Create two lists for the Players2 and Fees2 resultsets\n",
    "PlayersList2 = []\n",
    "FeesList2 = []\n",
    "\n",
    "count = 0\n",
    "for i, fee in enumerate(Fees2):\n",
    "    \n",
    "    PlayersList2.append(Players2[count].text)\n",
    "    FeesList2.append(Fees2[i].text)\n",
    "    \n",
    "    count+=3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "id": "5b32936d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['\\nKai Havertz ',\n",
       " '\\nArthur ',\n",
       " '\\nVictor Osimhen ',\n",
       " '\\nRúben Dias ',\n",
       " '\\nLeroy Sané ',\n",
       " '\\nMiralem Pjanic ',\n",
       " '\\nTimo Werner ',\n",
       " '\\nBen Chilwell ',\n",
       " '\\nMauro Icardi ',\n",
       " '\\nThomas Partey ',\n",
       " '\\nNathan Aké ',\n",
       " '\\nDiogo Jota ',\n",
       " '\\nAchraf Hakimi ',\n",
       " '\\nHakim Ziyech ',\n",
       " '\\nFábio Silva ',\n",
       " '\\nDonny van de Beek ',\n",
       " '\\nÁlvaro Morata ',\n",
       " '\\nWesley Fofana ',\n",
       " '\\nOllie Watkins ',\n",
       " '\\nFerran Torres ',\n",
       " '\\nNicolò Barella ',\n",
       " '\\nGiovani Lo Celso ',\n",
       " '\\nNélson Semedo ',\n",
       " '\\nFrancisco Trincão ',\n",
       " '\\nRodrigo ']"
      ]
     },
     "execution_count": 167,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Check the list PlayersList2\n",
    "PlayersList2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "id": "4030a2e5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['£72.00m',\n",
       " '£68.40m',\n",
       " '£67.50m',\n",
       " '£61.20m',\n",
       " '£54.00m',\n",
       " '£54.00m',\n",
       " '£47.70m',\n",
       " '£45.18m',\n",
       " '£45.00m',\n",
       " '£45.00m',\n",
       " '£40.77m',\n",
       " '£40.23m',\n",
       " '£38.70m',\n",
       " '£36.00m',\n",
       " '£36.00m',\n",
       " '£35.10m',\n",
       " '£31.50m',\n",
       " '£31.50m',\n",
       " '£30.60m',\n",
       " '£30.15m',\n",
       " '£29.25m',\n",
       " '£28.80m',\n",
       " '£28.80m',\n",
       " '£27.90m',\n",
       " '£27.00m']"
      ]
     },
     "execution_count": 168,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Check the list FeesList2\n",
    "FeesList2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "id": "dc9f05cf",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_transfer2 = pd.DataFrame({\"Players\":PlayersList2, \"Transfer Fees (£)\":FeesList2})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 171,
   "id": "1d0a97b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_transfer2.replace('\\n', '', regex=True, inplace=True)\n",
    "df_transfer2.replace('£', '', regex=True, inplace=True)\n",
    "df_transfer2['Transfer Fees (£)'].replace('m', '', regex=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "id": "9297be64",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_transfer['Transfer Fees (£)'] = df_transfer['Transfer Fees (£)'].apply(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "id": "9cf92870",
   "metadata": {},
   "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>Players</th>\n",
       "      <th>Transfer Fees (£)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kai Havertz</td>\n",
       "      <td>72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Arthur</td>\n",
       "      <td>68.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Victor Osimhen</td>\n",
       "      <td>67.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Rúben Dias</td>\n",
       "      <td>61.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Leroy Sané</td>\n",
       "      <td>54.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Miralem Pjanic</td>\n",
       "      <td>54.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Timo Werner</td>\n",
       "      <td>47.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ben Chilwell</td>\n",
       "      <td>45.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Mauro Icardi</td>\n",
       "      <td>45.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Thomas Partey</td>\n",
       "      <td>45.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Nathan Aké</td>\n",
       "      <td>40.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Diogo Jota</td>\n",
       "      <td>40.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Achraf Hakimi</td>\n",
       "      <td>38.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Hakim Ziyech</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Fábio Silva</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Donny van de Beek</td>\n",
       "      <td>35.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Álvaro Morata</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Wesley Fofana</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Ollie Watkins</td>\n",
       "      <td>30.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Ferran Torres</td>\n",
       "      <td>30.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Nicolò Barella</td>\n",
       "      <td>29.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Giovani Lo Celso</td>\n",
       "      <td>28.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Nélson Semedo</td>\n",
       "      <td>28.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Francisco Trincão</td>\n",
       "      <td>27.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Rodrigo</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Players Transfer Fees (£)\n",
       "0         Kai Havertz              72.00\n",
       "1              Arthur              68.40\n",
       "2      Victor Osimhen              67.50\n",
       "3          Rúben Dias              61.20\n",
       "4          Leroy Sané              54.00\n",
       "5      Miralem Pjanic              54.00\n",
       "6         Timo Werner              47.70\n",
       "7        Ben Chilwell              45.18\n",
       "8        Mauro Icardi              45.00\n",
       "9       Thomas Partey              45.00\n",
       "10         Nathan Aké              40.77\n",
       "11         Diogo Jota              40.23\n",
       "12      Achraf Hakimi              38.70\n",
       "13       Hakim Ziyech              36.00\n",
       "14        Fábio Silva              36.00\n",
       "15  Donny van de Beek              35.10\n",
       "16      Álvaro Morata              31.50\n",
       "17      Wesley Fofana              31.50\n",
       "18      Ollie Watkins              30.60\n",
       "19      Ferran Torres              30.15\n",
       "20     Nicolò Barella              29.25\n",
       "21   Giovani Lo Celso              28.80\n",
       "22      Nélson Semedo              28.80\n",
       "23  Francisco Trincão              27.90\n",
       "24            Rodrigo              27.00"
      ]
     },
     "execution_count": 174,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_transfer2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 277,
   "id": "6658cd0a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#We are going to write the above code into a function\n",
    "#Helper function to populate lists\n",
    "def populateLists(players, playerList, fees, feeList):\n",
    "   \n",
    "    \n",
    "    count = 0\n",
    "    for i, fee in enumerate(fees):\n",
    "        \n",
    "        playerList.append(players[count].text)\n",
    "        feeList.append(fees[i].text)\n",
    "        \n",
    "        #players name is in every third index\n",
    "        count+=3\n",
    "        \n",
    "#Helper function to clean a Transfer dataframe \n",
    "def cleanTransferDataFrame(df):\n",
    "    df.replace('\\n', '', regex=True, inplace=True)\n",
    "    df.replace('£', '', regex=True, inplace=True)\n",
    "    df['Transfer Fee (£)'].replace('m', '', regex=True, inplace=True)\n",
    "    df['Transfer Fee (£)'] = df['Transfer Fee (£)'].apply(float)\n",
    "    \n",
    "    return df\n",
    "    \n",
    "\n",
    "def scrapeTransferPage(year):\n",
    "    \n",
    "    if type(year) == int:\n",
    "        year = str(year)\n",
    "    \n",
    "    elif type(year) == str:\n",
    "        pass\n",
    "    \n",
    "    else:\n",
    "        raise Exception(\"Wrong data type used: use str or int\")\n",
    "        \n",
    "    page = 'https://www.transfermarkt.co.uk/transfers/transferrekorde/statistik/top/plus/0/galerie/0?saison_id='+year\n",
    "    pageTree = requests.get(page, headers={'User-Agent':\n",
    "          'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36'})\n",
    "    pageSoup = BeautifulSoup(pageTree.content, 'html.parser')\n",
    "    \n",
    "    if pageTree.status_code == 404:\n",
    "        \n",
    "        raise Exception(\"404 Error: Web Page is not available\")\n",
    "        \n",
    "    \n",
    "    Players = pageSoup.find_all(\"td\", {\"class\":\"hauptlink\"})\n",
    "    Fees = pageSoup.find_all(\"td\", \"rechts hauptlink\")\n",
    "    \n",
    "    \n",
    "    playerList = []\n",
    "    feeList = []\n",
    "    populateLists(Players, playerList, Fees, feeList)\n",
    "        \n",
    "    if len(playerList) > 0 and len(feeList) > 0:\n",
    "        df = pd.DataFrame({\"Players\":playerList, \"Transfer Fee (£)\":feeList})\n",
    "        df = cleanTransferDataFrame(df)\n",
    "    else:\n",
    "        raise Exception('Player List or FeeList is empty and has not been populated')\n",
    "    \n",
    "    return df\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "id": "65e6c437",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#Get the top Transfers from the 2021\n",
    "transfers_2021 = scrapeTransferPage('2021')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "id": "7a9a832b",
   "metadata": {},
   "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>Players</th>\n",
       "      <th>Transfer Fee (£)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jack Grealish</td>\n",
       "      <td>105.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Romelu Lukaku</td>\n",
       "      <td>101.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jadon Sancho</td>\n",
       "      <td>76.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dusan Vlahovic</td>\n",
       "      <td>73.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Achraf Hakimi</td>\n",
       "      <td>59.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ben White</td>\n",
       "      <td>52.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ferran Torres</td>\n",
       "      <td>49.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Luis Díaz</td>\n",
       "      <td>40.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dayot Upamecano</td>\n",
       "      <td>38.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Bruno Guimarães</td>\n",
       "      <td>37.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Raphaël Varane</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Tammy Abraham</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Ibrahima Konaté</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Emiliano Buendía</td>\n",
       "      <td>34.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Martin Ødegaard</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Rodrigo de Paul</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kurt Zouma</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Leon Bailey</td>\n",
       "      <td>28.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Eduardo Camavinga</td>\n",
       "      <td>27.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Nikola Vlasic</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Donyell Malen</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Lucas Digne</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Patson Daka</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Chris Wood</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Danny Ings</td>\n",
       "      <td>26.48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Players  Transfer Fee (£)\n",
       "0       Jack Grealish             105.75\n",
       "1       Romelu Lukaku             101.70\n",
       "2        Jadon Sancho              76.50\n",
       "3      Dusan Vlahovic              73.44\n",
       "4       Achraf Hakimi              59.85\n",
       "5           Ben White              52.65\n",
       "6       Ferran Torres              49.50\n",
       "7           Luis Díaz              40.50\n",
       "8     Dayot Upamecano              38.25\n",
       "9     Bruno Guimarães              37.89\n",
       "10     Raphaël Varane              36.00\n",
       "11      Tammy Abraham              36.00\n",
       "12    Ibrahima Konaté              36.00\n",
       "13   Emiliano Buendía              34.56\n",
       "14    Martin Ødegaard              31.50\n",
       "15    Rodrigo de Paul              31.50\n",
       "16         Kurt Zouma              31.50\n",
       "17        Leon Bailey              28.80\n",
       "18  Eduardo Camavinga              27.90\n",
       "19      Nikola Vlasic              27.00\n",
       "20      Donyell Malen              27.00\n",
       "21        Lucas Digne              27.00\n",
       "22        Patson Daka              27.00\n",
       "23         Chris Wood              27.00\n",
       "24         Danny Ings              26.48"
      ]
     },
     "execution_count": 282,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "transfers_2021"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 293,
   "id": "a5e01f8b",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Dictionary to store all the top transfers in the season\n",
    "topTransfers = {}\n",
    "\n",
    "#Populate the dictionary with transfers from 2000 to 2020\n",
    "for i in range(2000, 2021):\n",
    "    \n",
    "    topTransfers[i] = scrapeTransferPage(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 294,
   "id": "a6d5e482",
   "metadata": {},
   "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>Players</th>\n",
       "      <th>Transfer Fee (£)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Luís Figo</td>\n",
       "      <td>54.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hernán Crespo</td>\n",
       "      <td>51.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gabriel Batistuta</td>\n",
       "      <td>32.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Nicolas Anelka</td>\n",
       "      <td>31.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Marc Overmars</td>\n",
       "      <td>26.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Rio Ferdinand</td>\n",
       "      <td>23.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Flávio Conceição</td>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Savo Milosevic</td>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>David Trézéguet</td>\n",
       "      <td>20.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Matías Almeyda</td>\n",
       "      <td>20.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Claudio López</td>\n",
       "      <td>20.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Jimmy Floyd Hasselbaink</td>\n",
       "      <td>20.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Gerard López</td>\n",
       "      <td>19.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Lucas</td>\n",
       "      <td>19.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Pablo Aimar</td>\n",
       "      <td>19.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Wálter Samuel</td>\n",
       "      <td>18.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Shabani Nonda</td>\n",
       "      <td>18.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Robbie Keane</td>\n",
       "      <td>17.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Jonathan Zebina</td>\n",
       "      <td>16.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Émerson</td>\n",
       "      <td>16.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Tore André Flo</td>\n",
       "      <td>16.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sergiy Rebrov</td>\n",
       "      <td>16.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Angelo Peruzzi</td>\n",
       "      <td>16.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Diego Tristán</td>\n",
       "      <td>15.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Sylvain Wiltord</td>\n",
       "      <td>15.75</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Players  Transfer Fee (£)\n",
       "0                 Luís Figo              54.00\n",
       "1             Hernán Crespo              51.13\n",
       "2         Gabriel Batistuta              32.54\n",
       "3            Nicolas Anelka              31.05\n",
       "4             Marc Overmars              26.37\n",
       "5             Rio Ferdinand              23.40\n",
       "6          Flávio Conceição              22.50\n",
       "7            Savo Milosevic              22.50\n",
       "8           David Trézéguet              20.92\n",
       "9            Matías Almeyda              20.70\n",
       "10            Claudio López              20.70\n",
       "11  Jimmy Floyd Hasselbaink              20.25\n",
       "12             Gerard López              19.44\n",
       "13                    Lucas              19.17\n",
       "14              Pablo Aimar              19.13\n",
       "15            Wálter Samuel              18.72\n",
       "16            Shabani Nonda              18.00\n",
       "17             Robbie Keane              17.55\n",
       "18          Jonathan Zebina              16.56\n",
       "19                  Émerson              16.20\n",
       "20           Tore André Flo              16.20\n",
       "21            Sergiy Rebrov              16.20\n",
       "22           Angelo Peruzzi              16.11\n",
       "23            Diego Tristán              15.98\n",
       "24          Sylvain Wiltord              15.75"
      ]
     },
     "execution_count": 294,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Top transfers in the year 2000\n",
    "topTransfers[2000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "id": "3c90312c",
   "metadata": {},
   "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>Players</th>\n",
       "      <th>Transfer Fee (£)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fernando Torres</td>\n",
       "      <td>52.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andy Carroll</td>\n",
       "      <td>36.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>David Villa</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Edin Dzeko</td>\n",
       "      <td>33.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ángel Di María</td>\n",
       "      <td>29.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Yaya Touré</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mario Balotelli</td>\n",
       "      <td>26.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>David Silva</td>\n",
       "      <td>25.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Luis Suárez</td>\n",
       "      <td>23.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>David Luiz</td>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Aleksandar Kolarov</td>\n",
       "      <td>21.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Yoann Gourcuff</td>\n",
       "      <td>19.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>James Milner</td>\n",
       "      <td>19.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Bruno Alves</td>\n",
       "      <td>19.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Ramires</td>\n",
       "      <td>19.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Darren Bent</td>\n",
       "      <td>19.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Robinho</td>\n",
       "      <td>18.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Javier Mascherano</td>\n",
       "      <td>18.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Carlos Eduardo</td>\n",
       "      <td>18.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mesut Özil</td>\n",
       "      <td>16.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Giampaolo Pazzini</td>\n",
       "      <td>16.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Luiz Gustavo</td>\n",
       "      <td>15.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>André-Pierre Gignac</td>\n",
       "      <td>14.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Asamoah Gyan</td>\n",
       "      <td>14.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Diego</td>\n",
       "      <td>13.95</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Players  Transfer Fee (£)\n",
       "0       Fernando Torres              52.65\n",
       "1          Andy Carroll              36.90\n",
       "2           David Villa              36.00\n",
       "3            Edin Dzeko              33.30\n",
       "4        Ángel Di María              29.70\n",
       "5            Yaya Touré              27.00\n",
       "6       Mario Balotelli              26.55\n",
       "7           David Silva              25.88\n",
       "8           Luis Suárez              23.85\n",
       "9            David Luiz              22.50\n",
       "10   Aleksandar Kolarov              21.47\n",
       "11       Yoann Gourcuff              19.80\n",
       "12         James Milner              19.80\n",
       "13          Bruno Alves              19.80\n",
       "14              Ramires              19.80\n",
       "15          Darren Bent              19.35\n",
       "16              Robinho              18.90\n",
       "17    Javier Mascherano              18.00\n",
       "18       Carlos Eduardo              18.00\n",
       "19           Mesut Özil              16.20\n",
       "20    Giampaolo Pazzini              16.20\n",
       "21         Luiz Gustavo              15.30\n",
       "22  André-Pierre Gignac              14.40\n",
       "23         Asamoah Gyan              14.40\n",
       "24                Diego              13.95"
      ]
     },
     "execution_count": 295,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Top Transfers in 2010\n",
    "topTransfers[2010]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 299,
   "id": "5dfef51c",
   "metadata": {},
   "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>Players</th>\n",
       "      <th>Transfer Fee (£)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kevin De Bruyne</td>\n",
       "      <td>68.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raheem Sterling</td>\n",
       "      <td>57.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ángel Di María</td>\n",
       "      <td>56.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Anthony Martial</td>\n",
       "      <td>54.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alex Teixeira</td>\n",
       "      <td>45.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Players  Transfer Fee (£)\n",
       "0  Kevin De Bruyne              68.40\n",
       "1  Raheem Sterling              57.33\n",
       "2   Ángel Di María              56.70\n",
       "3  Anthony Martial              54.00\n",
       "4    Alex Teixeira              45.00"
      ]
     },
     "execution_count": 299,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "topTransfers[2015].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 300,
   "id": "f3e15af5",
   "metadata": {},
   "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>Players</th>\n",
       "      <th>Transfer Fee (£)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Nicolò Barella</td>\n",
       "      <td>29.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Giovani Lo Celso</td>\n",
       "      <td>28.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Nélson Semedo</td>\n",
       "      <td>28.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Francisco Trincão</td>\n",
       "      <td>27.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Rodrigo</td>\n",
       "      <td>27.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Players  Transfer Fee (£)\n",
       "20     Nicolò Barella              29.25\n",
       "21   Giovani Lo Celso              28.80\n",
       "22      Nélson Semedo              28.80\n",
       "23  Francisco Trincão              27.90\n",
       "24            Rodrigo              27.00"
      ]
     },
     "execution_count": 300,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "topTransfers[2020].tail()"
   ]
  }
 ],
 "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.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}