Datasets_Exploratory_Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "802ec94c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "7981d857",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load Databases\n",
    "fd = 'D:\\Descargas\\Proyecto Final\\Resources'\n",
    "appearances = f'{fd}/appearances.csv'\n",
    "clubs = f'{fd}/clubs.csv'\n",
    "competitions = f'{fd}/competitions.csv'\n",
    "games = f'{fd}/games.csv'\n",
    "players = f'{fd}/players.csv'\n",
    "top250 = f'{fd}/top250.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1f8b4943",
   "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>player_id</th>\n",
       "      <th>game_id</th>\n",
       "      <th>appearance_id</th>\n",
       "      <th>competition_id</th>\n",
       "      <th>player_club_id</th>\n",
       "      <th>goals</th>\n",
       "      <th>assists</th>\n",
       "      <th>minutes_played</th>\n",
       "      <th>yellow_cards</th>\n",
       "      <th>red_cards</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>410184</td>\n",
       "      <td>2602706</td>\n",
       "      <td>2602706_410184</td>\n",
       "      <td>UKR1</td>\n",
       "      <td>6994</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>84938</td>\n",
       "      <td>2581152</td>\n",
       "      <td>2581152_84938</td>\n",
       "      <td>L1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>84938</td>\n",
       "      <td>2581178</td>\n",
       "      <td>2581178_84938</td>\n",
       "      <td>L1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>84938</td>\n",
       "      <td>2581188</td>\n",
       "      <td>2581188_84938</td>\n",
       "      <td>L1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>84938</td>\n",
       "      <td>2581196</td>\n",
       "      <td>2581196_84938</td>\n",
       "      <td>L1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   player_id  game_id   appearance_id competition_id  player_club_id  goals  \\\n",
       "0     410184  2602706  2602706_410184           UKR1            6994      0   \n",
       "1      84938  2581152   2581152_84938             L1               3      0   \n",
       "2      84938  2581178   2581178_84938             L1               3      0   \n",
       "3      84938  2581188   2581188_84938             L1               3      0   \n",
       "4      84938  2581196   2581196_84938             L1               3      0   \n",
       "\n",
       "   assists  minutes_played  yellow_cards  red_cards  \n",
       "0        0              45             0          0  \n",
       "1        0              90             0          0  \n",
       "2        0              90             0          0  \n",
       "3        0              90             0          0  \n",
       "4        0              90             0          0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "appearances_df = pd.read_csv(appearances)\n",
    "appearances_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "978c2c0a",
   "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>club_id</th>\n",
       "      <th>name</th>\n",
       "      <th>pretty_name</th>\n",
       "      <th>domestic_competition_id</th>\n",
       "      <th>total_market_value</th>\n",
       "      <th>squad_size</th>\n",
       "      <th>average_age</th>\n",
       "      <th>foreigners_number</th>\n",
       "      <th>foreigners_percentage</th>\n",
       "      <th>national_team_players</th>\n",
       "      <th>stadium_name</th>\n",
       "      <th>stadium_seats</th>\n",
       "      <th>net_transfer_record</th>\n",
       "      <th>coach_name</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6996</td>\n",
       "      <td>goverla-uzhgorod</td>\n",
       "      <td>Goverla Uzhgorod</td>\n",
       "      <td>UKR1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Avangard</td>\n",
       "      <td>10640</td>\n",
       "      <td>+-0</td>\n",
       "      <td>Vyacheslav Groznyi</td>\n",
       "      <td>https://www.transfermarkt.co.uk/goverla-uzhgor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6994</td>\n",
       "      <td>metalurg-zaporizhya-bis-2016-</td>\n",
       "      <td>Metalurg Zaporizhya Bis 2016</td>\n",
       "      <td>UKR1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>ZAZ Stadion</td>\n",
       "      <td>15000</td>\n",
       "      <td>+-0</td>\n",
       "      <td>Anatoliy Chantsev</td>\n",
       "      <td>https://www.transfermarkt.co.uk/metalurg-zapor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7185</td>\n",
       "      <td>panthrakikos-komotini</td>\n",
       "      <td>Panthrakikos Komotini</td>\n",
       "      <td>GR1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>5</td>\n",
       "      <td>26.3</td>\n",
       "      <td>3</td>\n",
       "      <td>60.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Stadio Komotinis OPAP</td>\n",
       "      <td>5601</td>\n",
       "      <td>+-0</td>\n",
       "      <td>José Manuel Roca</td>\n",
       "      <td>https://www.transfermarkt.co.uk/panthrakikos-k...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3216</td>\n",
       "      <td>mersin-idmanyurdu</td>\n",
       "      <td>Mersin Idmanyurdu</td>\n",
       "      <td>TR1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Mersin Stadyumu</td>\n",
       "      <td>25497</td>\n",
       "      <td>+-0</td>\n",
       "      <td>Mesut Bakkal</td>\n",
       "      <td>https://www.transfermarkt.co.uk/mersin-idmanyu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>28956</td>\n",
       "      <td>ael-kalloni</td>\n",
       "      <td>Ael Kalloni</td>\n",
       "      <td>GR1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Stadio Mytilinis</td>\n",
       "      <td>4000</td>\n",
       "      <td>+-0</td>\n",
       "      <td>Thalis Theodoridis</td>\n",
       "      <td>https://www.transfermarkt.co.uk/ael-kalloni/st...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   club_id                           name                    pretty_name  \\\n",
       "0     6996               goverla-uzhgorod               Goverla Uzhgorod   \n",
       "1     6994  metalurg-zaporizhya-bis-2016-  Metalurg Zaporizhya Bis 2016    \n",
       "2     7185          panthrakikos-komotini          Panthrakikos Komotini   \n",
       "3     3216              mersin-idmanyurdu              Mersin Idmanyurdu   \n",
       "4    28956                    ael-kalloni                    Ael Kalloni   \n",
       "\n",
       "  domestic_competition_id  total_market_value  squad_size  average_age  \\\n",
       "0                    UKR1                 NaN           0          0.0   \n",
       "1                    UKR1                 NaN           0          0.0   \n",
       "2                     GR1                23.0           5         26.3   \n",
       "3                     TR1                 NaN           0          0.0   \n",
       "4                     GR1                 NaN           0          0.0   \n",
       "\n",
       "   foreigners_number  foreigners_percentage  national_team_players  \\\n",
       "0                  0                    NaN                      0   \n",
       "1                  0                    NaN                      0   \n",
       "2                  3                   60.0                      1   \n",
       "3                  0                    NaN                      0   \n",
       "4                  0                    NaN                      0   \n",
       "\n",
       "            stadium_name  stadium_seats net_transfer_record  \\\n",
       "0               Avangard          10640                 +-0   \n",
       "1            ZAZ Stadion          15000                 +-0   \n",
       "2  Stadio Komotinis OPAP           5601                 +-0   \n",
       "3        Mersin Stadyumu          25497                 +-0   \n",
       "4       Stadio Mytilinis           4000                 +-0   \n",
       "\n",
       "           coach_name                                                url  \n",
       "0  Vyacheslav Groznyi  https://www.transfermarkt.co.uk/goverla-uzhgor...  \n",
       "1   Anatoliy Chantsev  https://www.transfermarkt.co.uk/metalurg-zapor...  \n",
       "2    José Manuel Roca  https://www.transfermarkt.co.uk/panthrakikos-k...  \n",
       "3        Mesut Bakkal  https://www.transfermarkt.co.uk/mersin-idmanyu...  \n",
       "4  Thalis Theodoridis  https://www.transfermarkt.co.uk/ael-kalloni/st...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clubs_df = pd.read_csv(clubs)\n",
    "clubs_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "831a077d",
   "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>competition_id</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>country_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>domestic_league_code</th>\n",
       "      <th>confederation</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>L1</td>\n",
       "      <td>bundesliga</td>\n",
       "      <td>first_tier</td>\n",
       "      <td>40</td>\n",
       "      <td>Germany</td>\n",
       "      <td>L1</td>\n",
       "      <td>europa</td>\n",
       "      <td>https://www.transfermarkt.co.uk/bundesliga/sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DFB</td>\n",
       "      <td>dfb-pokal</td>\n",
       "      <td>domestic_cup</td>\n",
       "      <td>40</td>\n",
       "      <td>Germany</td>\n",
       "      <td>L1</td>\n",
       "      <td>europa</td>\n",
       "      <td>https://www.transfermarkt.co.uk/dfb-pokal/star...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DFL</td>\n",
       "      <td>dfl-supercup</td>\n",
       "      <td>domestic_super_cup</td>\n",
       "      <td>40</td>\n",
       "      <td>Germany</td>\n",
       "      <td>L1</td>\n",
       "      <td>europa</td>\n",
       "      <td>https://www.transfermarkt.co.uk/dfl-supercup/s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NL1</td>\n",
       "      <td>eredivisie</td>\n",
       "      <td>first_tier</td>\n",
       "      <td>122</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>NL1</td>\n",
       "      <td>europa</td>\n",
       "      <td>https://www.transfermarkt.co.uk/eredivisie/sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NLP</td>\n",
       "      <td>toto-knvb-beker</td>\n",
       "      <td>domestic_cup</td>\n",
       "      <td>122</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>NL1</td>\n",
       "      <td>europa</td>\n",
       "      <td>https://www.transfermarkt.co.uk/toto-knvb-beke...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  competition_id             name                type  country_id  \\\n",
       "0             L1       bundesliga          first_tier          40   \n",
       "1            DFB        dfb-pokal        domestic_cup          40   \n",
       "2            DFL     dfl-supercup  domestic_super_cup          40   \n",
       "3            NL1       eredivisie          first_tier         122   \n",
       "4            NLP  toto-knvb-beker        domestic_cup         122   \n",
       "\n",
       "  country_name domestic_league_code confederation  \\\n",
       "0      Germany                   L1        europa   \n",
       "1      Germany                   L1        europa   \n",
       "2      Germany                   L1        europa   \n",
       "3  Netherlands                  NL1        europa   \n",
       "4  Netherlands                  NL1        europa   \n",
       "\n",
       "                                                 url  \n",
       "0  https://www.transfermarkt.co.uk/bundesliga/sta...  \n",
       "1  https://www.transfermarkt.co.uk/dfb-pokal/star...  \n",
       "2  https://www.transfermarkt.co.uk/dfl-supercup/s...  \n",
       "3  https://www.transfermarkt.co.uk/eredivisie/sta...  \n",
       "4  https://www.transfermarkt.co.uk/toto-knvb-beke...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "competitions_df = pd.read_csv(competitions)\n",
    "competitions_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "20e91cf4",
   "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>game_id</th>\n",
       "      <th>competition_code</th>\n",
       "      <th>season</th>\n",
       "      <th>round</th>\n",
       "      <th>date</th>\n",
       "      <th>home_club_id</th>\n",
       "      <th>away_club_id</th>\n",
       "      <th>home_club_goals</th>\n",
       "      <th>away_club_goals</th>\n",
       "      <th>home_club_position</th>\n",
       "      <th>away_club_position</th>\n",
       "      <th>stadium</th>\n",
       "      <th>attendance</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2581147</td>\n",
       "      <td>L1</td>\n",
       "      <td>2015</td>\n",
       "      <td>1. Matchday</td>\n",
       "      <td>2015-08-14</td>\n",
       "      <td>27</td>\n",
       "      <td>41</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Allianz Arena</td>\n",
       "      <td>75024.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/bayern-munich_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2576512</td>\n",
       "      <td>DFL</td>\n",
       "      <td>2015</td>\n",
       "      <td>Final</td>\n",
       "      <td>2015-08-01</td>\n",
       "      <td>82</td>\n",
       "      <td>27</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Volkswagen Arena</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2581181</td>\n",
       "      <td>L1</td>\n",
       "      <td>2015</td>\n",
       "      <td>2. Matchday</td>\n",
       "      <td>2015-08-22</td>\n",
       "      <td>533</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>PreZero Arena</td>\n",
       "      <td>30150.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/tsg-1899-hoffe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2581179</td>\n",
       "      <td>L1</td>\n",
       "      <td>2015</td>\n",
       "      <td>2. Matchday</td>\n",
       "      <td>2015-08-22</td>\n",
       "      <td>42</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>HDI-Arena</td>\n",
       "      <td>39100.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/hannover-96_ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2581178</td>\n",
       "      <td>L1</td>\n",
       "      <td>2015</td>\n",
       "      <td>2. Matchday</td>\n",
       "      <td>2015-08-22</td>\n",
       "      <td>3</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>RheinEnergieStadion</td>\n",
       "      <td>46000.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/1-fc-koln_vfl-...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   game_id competition_code  season        round        date  home_club_id  \\\n",
       "0  2581147               L1    2015  1. Matchday  2015-08-14            27   \n",
       "1  2576512              DFL    2015        Final  2015-08-01            82   \n",
       "2  2581181               L1    2015  2. Matchday  2015-08-22           533   \n",
       "3  2581179               L1    2015  2. Matchday  2015-08-22            42   \n",
       "4  2581178               L1    2015  2. Matchday  2015-08-22             3   \n",
       "\n",
       "   away_club_id  home_club_goals  away_club_goals  home_club_position  \\\n",
       "0            41                5                0                 1.0   \n",
       "1            27                6                5                 NaN   \n",
       "2            27                1                2                16.0   \n",
       "3            15                0                1                13.0   \n",
       "4            82                1                1                 5.0   \n",
       "\n",
       "   away_club_position              stadium  attendance  \\\n",
       "0                18.0        Allianz Arena     75024.0   \n",
       "1                 NaN     Volkswagen Arena     30000.0   \n",
       "2                 2.0        PreZero Arena     30150.0   \n",
       "3                 3.0            HDI-Arena     39100.0   \n",
       "4                 6.0  RheinEnergieStadion     46000.0   \n",
       "\n",
       "                                                 url  \n",
       "0  https://www.transfermarkt.co.uk/bayern-munich_...  \n",
       "1  https://www.transfermarkt.co.uk/spielbericht/i...  \n",
       "2  https://www.transfermarkt.co.uk/tsg-1899-hoffe...  \n",
       "3  https://www.transfermarkt.co.uk/hannover-96_ba...  \n",
       "4  https://www.transfermarkt.co.uk/1-fc-koln_vfl-...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_df = pd.read_csv(games)\n",
    "games_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "b0f2acc7",
   "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_id</th>\n",
       "      <th>current_club_id</th>\n",
       "      <th>name</th>\n",
       "      <th>pretty_name</th>\n",
       "      <th>country_of_birth</th>\n",
       "      <th>country_of_citizenship</th>\n",
       "      <th>date_of_birth</th>\n",
       "      <th>position</th>\n",
       "      <th>sub_position</th>\n",
       "      <th>foot</th>\n",
       "      <th>height_in_cm</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>257767</td>\n",
       "      <td>4795</td>\n",
       "      <td>aloy-ihenacho</td>\n",
       "      <td>Aloy Ihenacho</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>1995-07-21</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Left</td>\n",
       "      <td>182</td>\n",
       "      <td>https://www.transfermarkt.co.uk/aloy-ihenacho/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>320889</td>\n",
       "      <td>4795</td>\n",
       "      <td>thomas-blomeyer</td>\n",
       "      <td>Thomas Blomeyer</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1996-04-24</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Both</td>\n",
       "      <td>191</td>\n",
       "      <td>https://www.transfermarkt.co.uk/thomas-blomeye...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>42318</td>\n",
       "      <td>4795</td>\n",
       "      <td>konstantin-engel</td>\n",
       "      <td>Konstantin Engel</td>\n",
       "      <td>UdSSR</td>\n",
       "      <td>Kazakhstan</td>\n",
       "      <td>1988-07-27</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Right</td>\n",
       "      <td>179</td>\n",
       "      <td>https://www.transfermarkt.co.uk/konstantin-eng...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>94598</td>\n",
       "      <td>4795</td>\n",
       "      <td>stefan-wannenwetsch</td>\n",
       "      <td>Stefan Wannenwetsch</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>177</td>\n",
       "      <td>https://www.transfermarkt.co.uk/stefan-wannenw...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>381921</td>\n",
       "      <td>6994</td>\n",
       "      <td>ivan-komlev</td>\n",
       "      <td>Ivan Komlev</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>1994-07-22</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>NaN</td>\n",
       "      <td>181</td>\n",
       "      <td>https://www.transfermarkt.co.uk/ivan-komlev/pr...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   player_id  current_club_id                 name          pretty_name  \\\n",
       "0     257767             4795        aloy-ihenacho        Aloy Ihenacho   \n",
       "1     320889             4795      thomas-blomeyer      Thomas Blomeyer   \n",
       "2      42318             4795     konstantin-engel     Konstantin Engel   \n",
       "3      94598             4795  stefan-wannenwetsch  Stefan Wannenwetsch   \n",
       "4     381921             6994          ivan-komlev          Ivan Komlev   \n",
       "\n",
       "  country_of_birth country_of_citizenship date_of_birth  position  \\\n",
       "0          Nigeria                Nigeria    1995-07-21    Attack   \n",
       "1          Germany                Germany    1996-04-24  Defender   \n",
       "2            UdSSR             Kazakhstan    1988-07-27  Defender   \n",
       "3          Germany                Germany           NaN  Midfield   \n",
       "4              NaN                Ukraine    1994-07-22  Defender   \n",
       "\n",
       "         sub_position   foot  height_in_cm  \\\n",
       "0      Centre-Forward   Left           182   \n",
       "1         Centre-Back   Both           191   \n",
       "2         Centre-Back  Right           179   \n",
       "3  Defensive Midfield  Right           177   \n",
       "4         Centre-Back    NaN           181   \n",
       "\n",
       "                                                 url  \n",
       "0  https://www.transfermarkt.co.uk/aloy-ihenacho/...  \n",
       "1  https://www.transfermarkt.co.uk/thomas-blomeye...  \n",
       "2  https://www.transfermarkt.co.uk/konstantin-eng...  \n",
       "3  https://www.transfermarkt.co.uk/stefan-wannenw...  \n",
       "4  https://www.transfermarkt.co.uk/ivan-komlev/pr...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players_df = pd.read_csv(players)\n",
    "players_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "b537efea",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "APPEARANCES_DF has columns with NaN values:\n",
      "player_id         0\n",
      "game_id           0\n",
      "appearance_id     0\n",
      "competition_id    0\n",
      "player_club_id    0\n",
      "goals             0\n",
      "assists           0\n",
      "minutes_played    0\n",
      "yellow_cards      0\n",
      "red_cards         0\n",
      "dtype: int64\n",
      " \n",
      "CLUBS_DF has columns with NaN values:\n",
      "club_id                     0\n",
      "name                        0\n",
      "pretty_name                 0\n",
      "domestic_competition_id     0\n",
      "total_market_value         18\n",
      "squad_size                  0\n",
      "average_age                 0\n",
      "foreigners_number           0\n",
      "foreigners_percentage      27\n",
      "national_team_players       0\n",
      "stadium_name                0\n",
      "stadium_seats               0\n",
      "net_transfer_record         0\n",
      "coach_name                  0\n",
      "url                         0\n",
      "dtype: int64\n",
      " \n",
      "COMPETITIONS_DF has columns with NaN values:\n",
      "competition_id          0\n",
      "name                    0\n",
      "type                    0\n",
      "country_id              0\n",
      "country_name            7\n",
      "domestic_league_code    7\n",
      "confederation           0\n",
      "url                     0\n",
      "dtype: int64\n",
      " \n",
      "GAMES_DF has columns with NaN values:\n",
      "game_id                   0\n",
      "competition_code          0\n",
      "season                    0\n",
      "round                     0\n",
      "date                      0\n",
      "home_club_id              0\n",
      "away_club_id              0\n",
      "home_club_goals           0\n",
      "away_club_goals           0\n",
      "home_club_position    10429\n",
      "away_club_position    10430\n",
      "stadium                  93\n",
      "attendance             7514\n",
      "url                       0\n",
      "dtype: int64\n",
      " \n",
      "PLAYERS_DF has columns with NaN values:\n",
      "player_id                    0\n",
      "current_club_id              0\n",
      "name                         0\n",
      "pretty_name                  0\n",
      "country_of_birth          1502\n",
      "country_of_citizenship       0\n",
      "date_of_birth               21\n",
      "position                     0\n",
      "sub_position                 0\n",
      "foot                      1661\n",
      "height_in_cm                 0\n",
      "url                          0\n",
      "dtype: int64\n",
      " \n"
     ]
    }
   ],
   "source": [
    "df_list = [appearances_df, clubs_df, competitions_df, games_df, players_df]\n",
    "name_list = [\"appearances_df\", \"clubs_df\", \"competitions_df\", \"games_df\", \"players_df\"]\n",
    "for i in range(len(name_list)):\n",
    "    print(f'{name_list[i].upper()} has columns with NaN values:')\n",
    "    print(df_list[i].isna().sum())\n",
    "    print(\" \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "38f7b593",
   "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_id</th>\n",
       "      <th>current_club_id</th>\n",
       "      <th>height_in_cm</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>20626.000000</td>\n",
       "      <td>20626.000000</td>\n",
       "      <td>20626.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>289222.910889</td>\n",
       "      <td>4145.085378</td>\n",
       "      <td>172.197227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>203292.082994</td>\n",
       "      <td>9223.325976</td>\n",
       "      <td>42.135029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>10.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>111058.750000</td>\n",
       "      <td>383.000000</td>\n",
       "      <td>176.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>265527.500000</td>\n",
       "      <td>1050.000000</td>\n",
       "      <td>182.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>422451.250000</td>\n",
       "      <td>2999.000000</td>\n",
       "      <td>187.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>949337.000000</td>\n",
       "      <td>61825.000000</td>\n",
       "      <td>206.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           player_id  current_club_id  height_in_cm\n",
       "count   20626.000000     20626.000000  20626.000000\n",
       "mean   289222.910889      4145.085378    172.197227\n",
       "std    203292.082994      9223.325976     42.135029\n",
       "min        10.000000         3.000000      0.000000\n",
       "25%    111058.750000       383.000000    176.000000\n",
       "50%    265527.500000      1050.000000    182.000000\n",
       "75%    422451.250000      2999.000000    187.000000\n",
       "max    949337.000000     61825.000000    206.000000"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "67823f5b",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "player_id                  int64\n",
       "current_club_id            int64\n",
       "name                      object\n",
       "pretty_name               object\n",
       "country_of_birth          object\n",
       "country_of_citizenship    object\n",
       "date_of_birth             object\n",
       "position                  object\n",
       "sub_position              object\n",
       "foot                      object\n",
       "height_in_cm               int64\n",
       "url                       object\n",
       "dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "5fae968a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(820242, 10)\n",
      "(20626, 12)\n",
      "(364, 15)\n"
     ]
    }
   ],
   "source": [
    "# Dropping NaN values from columns of interest (Appereances, Clubs and Players)\n",
    "players_df.dropna()\n",
    "appearances_df.dropna()\n",
    "clubs_df.dropna()\n",
    "games_df #2021 filtro\n",
    "# Print new shape\n",
    "print(appearances_df.shape)\n",
    "print(players_df.shape)\n",
    "print(clubs_df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d34775f3",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "game_id               5641\n",
       "competition_code      5641\n",
       "season                5641\n",
       "round                 5641\n",
       "date                  5641\n",
       "home_club_id          5641\n",
       "away_club_id          5641\n",
       "home_club_goals       5641\n",
       "away_club_goals       5641\n",
       "home_club_position    3986\n",
       "away_club_position    3986\n",
       "stadium               5631\n",
       "attendance            5305\n",
       "url                   5641\n",
       "dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 2018 games are 5641\n",
    "games_df[games_df[\"season\"] == 2018].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6454f621",
   "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>Name</th>\n",
       "      <th>Position</th>\n",
       "      <th>Age</th>\n",
       "      <th>Team_from</th>\n",
       "      <th>League_from</th>\n",
       "      <th>Team_to</th>\n",
       "      <th>League_to</th>\n",
       "      <th>Season</th>\n",
       "      <th>Market_value</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>Right Winger</td>\n",
       "      <td>27</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2000-2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hernán Crespo</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>25</td>\n",
       "      <td>Parma</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>Lazio</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2000-2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56810000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Marc Overmars</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>27</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2000-2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gabriel Batistuta</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>31</td>\n",
       "      <td>Fiorentina</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>AS Roma</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2000-2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nicolas Anelka</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>21</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2000-2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34500000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4695</th>\n",
       "      <td>Jasmin Kurtic</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>29</td>\n",
       "      <td>Atalanta</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>SPAL</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4696</th>\n",
       "      <td>Tchê Tchê</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>25</td>\n",
       "      <td>Palmeiras</td>\n",
       "      <td>Série A</td>\n",
       "      <td>Dynamo Kyiv</td>\n",
       "      <td>Premier Liga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4697</th>\n",
       "      <td>Silvan Widmer</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>25</td>\n",
       "      <td>Udinese Calcio</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>FC Basel</td>\n",
       "      <td>Super League</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>8500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4698</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4699</th>\n",
       "      <td>Kyle Bartley</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>27</td>\n",
       "      <td>Swansea</td>\n",
       "      <td>Championship</td>\n",
       "      <td>West Brom</td>\n",
       "      <td>Championship</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4700 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Name            Position  Age       Team_from  \\\n",
       "0             Luís Figo        Right Winger   27    FC Barcelona   \n",
       "1         Hernán Crespo      Centre-Forward   25           Parma   \n",
       "2         Marc Overmars         Left Winger   27         Arsenal   \n",
       "3     Gabriel Batistuta      Centre-Forward   31      Fiorentina   \n",
       "4        Nicolas Anelka      Centre-Forward   21     Real Madrid   \n",
       "...                 ...                 ...  ...             ...   \n",
       "4695      Jasmin Kurtic  Attacking Midfield   29        Atalanta   \n",
       "4696          Tchê Tchê    Central Midfield   25       Palmeiras   \n",
       "4697      Silvan Widmer          Right-Back   25  Udinese Calcio   \n",
       "4698         Yuya Osako      Second Striker   28      1. FC Köln   \n",
       "4699       Kyle Bartley         Centre-Back   27         Swansea   \n",
       "\n",
       "         League_from        Team_to     League_to     Season  Market_value  \\\n",
       "0             LaLiga    Real Madrid        LaLiga  2000-2001           NaN   \n",
       "1            Serie A          Lazio       Serie A  2000-2001           NaN   \n",
       "2     Premier League   FC Barcelona        LaLiga  2000-2001           NaN   \n",
       "3            Serie A        AS Roma       Serie A  2000-2001           NaN   \n",
       "4             LaLiga       Paris SG       Ligue 1  2000-2001           NaN   \n",
       "...              ...            ...           ...        ...           ...   \n",
       "4695         Serie A           SPAL       Serie A  2018-2019     5000000.0   \n",
       "4696         Série A    Dynamo Kyiv  Premier Liga  2018-2019     3000000.0   \n",
       "4697         Serie A       FC Basel  Super League  2018-2019     8500000.0   \n",
       "4698    2.Bundesliga  Werder Bremen  1.Bundesliga  2018-2019     4500000.0   \n",
       "4699    Championship      West Brom  Championship  2018-2019     3500000.0   \n",
       "\n",
       "      Transfer_fee  \n",
       "0         60000000  \n",
       "1         56810000  \n",
       "2         40000000  \n",
       "3         36150000  \n",
       "4         34500000  \n",
       "...            ...  \n",
       "4695       4800000  \n",
       "4696       4800000  \n",
       "4697       4500000  \n",
       "4698       4500000  \n",
       "4699       4500000  \n",
       "\n",
       "[4700 rows x 10 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Adding new dataset in order to obtain the market value of each players\n",
    "top250_df = pd.read_csv(top250)\n",
    "top250_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "3812e726",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name             object\n",
       "Position         object\n",
       "Age               int64\n",
       "Team_from        object\n",
       "League_from      object\n",
       "Team_to          object\n",
       "League_to        object\n",
       "Season           object\n",
       "Market_value    float64\n",
       "Transfer_fee      int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top250_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "c16307d7",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name               0\n",
       "Position           0\n",
       "Age                0\n",
       "Team_from          0\n",
       "League_from        0\n",
       "Team_to            0\n",
       "League_to          0\n",
       "Season             0\n",
       "Market_value    1260\n",
       "Transfer_fee       0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top250_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "71554337",
   "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>Name</th>\n",
       "      <th>Position</th>\n",
       "      <th>Age</th>\n",
       "      <th>Team_from</th>\n",
       "      <th>League_from</th>\n",
       "      <th>Team_to</th>\n",
       "      <th>League_to</th>\n",
       "      <th>Season</th>\n",
       "      <th>Market_value</th>\n",
       "      <th>Transfer_fee</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Carlos Tévez</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>20</td>\n",
       "      <td>Boca Juniors</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Corinthians</td>\n",
       "      <td>Série A</td>\n",
       "      <td>2004-2005</td>\n",
       "      <td>15000000.0</td>\n",
       "      <td>15000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>Valeri Bojinov</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>18</td>\n",
       "      <td>Lecce</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>Fiorentina</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2004-2005</td>\n",
       "      <td>13000000.0</td>\n",
       "      <td>14000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1004</th>\n",
       "      <td>Jiri Jarosik</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>27</td>\n",
       "      <td>CSKA Moscow</td>\n",
       "      <td>Premier Liga</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2004-2005</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>12000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009</th>\n",
       "      <td>Jean-Alain Boumsong</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>25</td>\n",
       "      <td>Rangers</td>\n",
       "      <td>Premiership</td>\n",
       "      <td>Newcastle</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2004-2005</td>\n",
       "      <td>8500000.0</td>\n",
       "      <td>11300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011</th>\n",
       "      <td>Nicolas Anelka</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>25</td>\n",
       "      <td>Man City</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Fenerbahce</td>\n",
       "      <td>Süper Lig</td>\n",
       "      <td>2004-2005</td>\n",
       "      <td>15000000.0</td>\n",
       "      <td>10700000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4695</th>\n",
       "      <td>Jasmin Kurtic</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>29</td>\n",
       "      <td>Atalanta</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>SPAL</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4696</th>\n",
       "      <td>Tchê Tchê</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>25</td>\n",
       "      <td>Palmeiras</td>\n",
       "      <td>Série A</td>\n",
       "      <td>Dynamo Kyiv</td>\n",
       "      <td>Premier Liga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4697</th>\n",
       "      <td>Silvan Widmer</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>25</td>\n",
       "      <td>Udinese Calcio</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>FC Basel</td>\n",
       "      <td>Super League</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>8500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4698</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4699</th>\n",
       "      <td>Kyle Bartley</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>27</td>\n",
       "      <td>Swansea</td>\n",
       "      <td>Championship</td>\n",
       "      <td>West Brom</td>\n",
       "      <td>Championship</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3440 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Name            Position  Age       Team_from  \\\n",
       "999          Carlos Tévez      Second Striker   20    Boca Juniors   \n",
       "1001       Valeri Bojinov      Centre-Forward   18           Lecce   \n",
       "1004         Jiri Jarosik         Centre-Back   27     CSKA Moscow   \n",
       "1009  Jean-Alain Boumsong         Centre-Back   25         Rangers   \n",
       "1011       Nicolas Anelka      Centre-Forward   25        Man City   \n",
       "...                   ...                 ...  ...             ...   \n",
       "4695        Jasmin Kurtic  Attacking Midfield   29        Atalanta   \n",
       "4696            Tchê Tchê    Central Midfield   25       Palmeiras   \n",
       "4697        Silvan Widmer          Right-Back   25  Udinese Calcio   \n",
       "4698           Yuya Osako      Second Striker   28      1. FC Köln   \n",
       "4699         Kyle Bartley         Centre-Back   27         Swansea   \n",
       "\n",
       "         League_from        Team_to       League_to     Season  Market_value  \\\n",
       "999        Argentina    Corinthians         Série A  2004-2005    15000000.0   \n",
       "1001         Serie A     Fiorentina         Serie A  2004-2005    13000000.0   \n",
       "1004    Premier Liga        Chelsea  Premier League  2004-2005     5000000.0   \n",
       "1009     Premiership      Newcastle  Premier League  2004-2005     8500000.0   \n",
       "1011  Premier League     Fenerbahce       Süper Lig  2004-2005    15000000.0   \n",
       "...              ...            ...             ...        ...           ...   \n",
       "4695         Serie A           SPAL         Serie A  2018-2019     5000000.0   \n",
       "4696         Série A    Dynamo Kyiv    Premier Liga  2018-2019     3000000.0   \n",
       "4697         Serie A       FC Basel    Super League  2018-2019     8500000.0   \n",
       "4698    2.Bundesliga  Werder Bremen    1.Bundesliga  2018-2019     4500000.0   \n",
       "4699    Championship      West Brom    Championship  2018-2019     3500000.0   \n",
       "\n",
       "      Transfer_fee  \n",
       "999       15000000  \n",
       "1001      14000000  \n",
       "1004      12000000  \n",
       "1009      11300000  \n",
       "1011      10700000  \n",
       "...            ...  \n",
       "4695       4800000  \n",
       "4696       4800000  \n",
       "4697       4500000  \n",
       "4698       4500000  \n",
       "4699       4500000  \n",
       "\n",
       "[3440 rows x 10 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Dropping NaN values\n",
    "top250_NaN = top250_df.dropna()\n",
    "top250_NaN"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "bf76eb5c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2016-2017    249\n",
       "2011-2012    248\n",
       "2015-2016    248\n",
       "2013-2014    248\n",
       "2009-2010    247\n",
       "2012-2013    246\n",
       "2014-2015    245\n",
       "2008-2009    243\n",
       "2018-2019    242\n",
       "2010-2011    241\n",
       "2017-2018    241\n",
       "2007-2008    235\n",
       "2006-2007    229\n",
       "2005-2006    219\n",
       "2004-2005     59\n",
       "Name: Season, dtype: int64"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Counting athletes per season\n",
    "top250_NaN[\"Season\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "3a5c721c",
   "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>Name</th>\n",
       "      <th>Position</th>\n",
       "      <th>Age</th>\n",
       "      <th>Team_from</th>\n",
       "      <th>League_from</th>\n",
       "      <th>Team_to</th>\n",
       "      <th>League_to</th>\n",
       "      <th>Season</th>\n",
       "      <th>Market_value</th>\n",
       "      <th>Transfer_fee</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4211</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>25</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>222000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4212</th>\n",
       "      <td>Philippe Coutinho</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>25</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>90000000.0</td>\n",
       "      <td>125000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4213</th>\n",
       "      <td>Ousmane Dembélé</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>20</td>\n",
       "      <td>Bor. Dortmund</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>33000000.0</td>\n",
       "      <td>115000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4214</th>\n",
       "      <td>Romelu Lukaku</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>24</td>\n",
       "      <td>Everton</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Man Utd</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>50000000.0</td>\n",
       "      <td>84700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4215</th>\n",
       "      <td>Virgil van Dijk</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>26</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>30000000.0</td>\n",
       "      <td>78800000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4450</th>\n",
       "      <td>Diego Llorente</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>23</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>7500000.0</td>\n",
       "      <td>7000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4451</th>\n",
       "      <td>Clinton N'Jie</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>23</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>7000000.0</td>\n",
       "      <td>7000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4452</th>\n",
       "      <td>Marcelo</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>30</td>\n",
       "      <td>Besiktas</td>\n",
       "      <td>Süper Lig</td>\n",
       "      <td>Olympique Lyon</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>6500000.0</td>\n",
       "      <td>7000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4453</th>\n",
       "      <td>Jorge Meré</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>20</td>\n",
       "      <td>Sporting Gijón</td>\n",
       "      <td>LaLiga2</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>6000000.0</td>\n",
       "      <td>7000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4454</th>\n",
       "      <td>Víctor Camarasa</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>23</td>\n",
       "      <td>Levante UD</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Real Betis</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>7000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>241 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Name            Position  Age       Team_from  \\\n",
       "4211             Neymar         Left Winger   25    FC Barcelona   \n",
       "4212  Philippe Coutinho  Attacking Midfield   25       Liverpool   \n",
       "4213    Ousmane Dembélé        Right Winger   20   Bor. Dortmund   \n",
       "4214      Romelu Lukaku      Centre-Forward   24         Everton   \n",
       "4215    Virgil van Dijk         Centre-Back   26     Southampton   \n",
       "...                 ...                 ...  ...             ...   \n",
       "4450     Diego Llorente         Centre-Back   23     Real Madrid   \n",
       "4451      Clinton N'Jie      Centre-Forward   23           Spurs   \n",
       "4452            Marcelo         Centre-Back   30        Besiktas   \n",
       "4453         Jorge Meré         Centre-Back   20  Sporting Gijón   \n",
       "4454    Víctor Camarasa    Central Midfield   23      Levante UD   \n",
       "\n",
       "         League_from         Team_to       League_to     Season  Market_value  \\\n",
       "4211          LaLiga        Paris SG         Ligue 1  2017-2018   100000000.0   \n",
       "4212  Premier League    FC Barcelona          LaLiga  2017-2018    90000000.0   \n",
       "4213    1.Bundesliga    FC Barcelona          LaLiga  2017-2018    33000000.0   \n",
       "4214  Premier League         Man Utd  Premier League  2017-2018    50000000.0   \n",
       "4215  Premier League       Liverpool  Premier League  2017-2018    30000000.0   \n",
       "...              ...             ...             ...        ...           ...   \n",
       "4450          LaLiga   Real Sociedad          LaLiga  2017-2018     7500000.0   \n",
       "4451  Premier League       Marseille         Ligue 1  2017-2018     7000000.0   \n",
       "4452       Süper Lig  Olympique Lyon         Ligue 1  2017-2018     6500000.0   \n",
       "4453         LaLiga2      1. FC Köln    1.Bundesliga  2017-2018     6000000.0   \n",
       "4454          LaLiga      Real Betis          LaLiga  2017-2018     5000000.0   \n",
       "\n",
       "      Transfer_fee  \n",
       "4211     222000000  \n",
       "4212     125000000  \n",
       "4213     115000000  \n",
       "4214      84700000  \n",
       "4215      78800000  \n",
       "...            ...  \n",
       "4450       7000000  \n",
       "4451       7000000  \n",
       "4452       7000000  \n",
       "4453       7000000  \n",
       "4454       7000000  \n",
       "\n",
       "[241 rows x 10 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 241 athletes in the 2017-2018 season\n",
    "top250_NaN[top250_NaN['Season'] == \"2017-2018\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "aeb701ee",
   "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>Name</th>\n",
       "      <th>Position</th>\n",
       "      <th>Age</th>\n",
       "      <th>Team_from</th>\n",
       "      <th>League_from</th>\n",
       "      <th>Team_to</th>\n",
       "      <th>League_to</th>\n",
       "      <th>Season</th>\n",
       "      <th>Market_value</th>\n",
       "      <th>Transfer_fee</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4455</th>\n",
       "      <td>Kylian Mbappé</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>19</td>\n",
       "      <td>Monaco</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>120000000.0</td>\n",
       "      <td>135000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4456</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>33</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>117000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4457</th>\n",
       "      <td>Thomas Lemar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>22</td>\n",
       "      <td>Monaco</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>65000000.0</td>\n",
       "      <td>70000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4458</th>\n",
       "      <td>Riyad Mahrez</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>27</td>\n",
       "      <td>Leicester</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Man City</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>50000000.0</td>\n",
       "      <td>67800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4459</th>\n",
       "      <td>Alisson</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>25</td>\n",
       "      <td>AS Roma</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>60000000.0</td>\n",
       "      <td>62500000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4695</th>\n",
       "      <td>Jasmin Kurtic</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>29</td>\n",
       "      <td>Atalanta</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>SPAL</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4696</th>\n",
       "      <td>Tchê Tchê</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>25</td>\n",
       "      <td>Palmeiras</td>\n",
       "      <td>Série A</td>\n",
       "      <td>Dynamo Kyiv</td>\n",
       "      <td>Premier Liga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4697</th>\n",
       "      <td>Silvan Widmer</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>25</td>\n",
       "      <td>Udinese Calcio</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>FC Basel</td>\n",
       "      <td>Super League</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>8500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4698</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4699</th>\n",
       "      <td>Kyle Bartley</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>27</td>\n",
       "      <td>Swansea</td>\n",
       "      <td>Championship</td>\n",
       "      <td>West Brom</td>\n",
       "      <td>Championship</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>242 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Name            Position  Age       Team_from  \\\n",
       "4455      Kylian Mbappé        Right Winger   19          Monaco   \n",
       "4456  Cristiano Ronaldo      Centre-Forward   33     Real Madrid   \n",
       "4457       Thomas Lemar         Left Winger   22          Monaco   \n",
       "4458       Riyad Mahrez        Right Winger   27       Leicester   \n",
       "4459            Alisson          Goalkeeper   25         AS Roma   \n",
       "...                 ...                 ...  ...             ...   \n",
       "4695      Jasmin Kurtic  Attacking Midfield   29        Atalanta   \n",
       "4696          Tchê Tchê    Central Midfield   25       Palmeiras   \n",
       "4697      Silvan Widmer          Right-Back   25  Udinese Calcio   \n",
       "4698         Yuya Osako      Second Striker   28      1. FC Köln   \n",
       "4699       Kyle Bartley         Centre-Back   27         Swansea   \n",
       "\n",
       "         League_from          Team_to       League_to     Season  \\\n",
       "4455         Ligue 1         Paris SG         Ligue 1  2018-2019   \n",
       "4456          LaLiga         Juventus         Serie A  2018-2019   \n",
       "4457         Ligue 1  Atlético Madrid          LaLiga  2018-2019   \n",
       "4458  Premier League         Man City  Premier League  2018-2019   \n",
       "4459         Serie A        Liverpool  Premier League  2018-2019   \n",
       "...              ...              ...             ...        ...   \n",
       "4695         Serie A             SPAL         Serie A  2018-2019   \n",
       "4696         Série A      Dynamo Kyiv    Premier Liga  2018-2019   \n",
       "4697         Serie A         FC Basel    Super League  2018-2019   \n",
       "4698    2.Bundesliga    Werder Bremen    1.Bundesliga  2018-2019   \n",
       "4699    Championship        West Brom    Championship  2018-2019   \n",
       "\n",
       "      Market_value  Transfer_fee  \n",
       "4455   120000000.0     135000000  \n",
       "4456   100000000.0     117000000  \n",
       "4457    65000000.0      70000000  \n",
       "4458    50000000.0      67800000  \n",
       "4459    60000000.0      62500000  \n",
       "...            ...           ...  \n",
       "4695     5000000.0       4800000  \n",
       "4696     3000000.0       4800000  \n",
       "4697     8500000.0       4500000  \n",
       "4698     4500000.0       4500000  \n",
       "4699     3500000.0       4500000  \n",
       "\n",
       "[242 rows x 10 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 242 athletes in the 2018-2019 season\n",
    "top250_NaN[top250_NaN['Season'] == \"2018-2019\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "6bf5af97",
   "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>Name</th>\n",
       "      <th>Position</th>\n",
       "      <th>Age</th>\n",
       "      <th>Team_from</th>\n",
       "      <th>League_from</th>\n",
       "      <th>Team_to</th>\n",
       "      <th>League_to</th>\n",
       "      <th>Season</th>\n",
       "      <th>Market_value</th>\n",
       "      <th>Transfer_fee</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4211</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>25</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>222000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4212</th>\n",
       "      <td>Philippe Coutinho</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>25</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>90000000.0</td>\n",
       "      <td>125000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4213</th>\n",
       "      <td>Ousmane Dembélé</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>20</td>\n",
       "      <td>Bor. Dortmund</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>33000000.0</td>\n",
       "      <td>115000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4214</th>\n",
       "      <td>Romelu Lukaku</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>24</td>\n",
       "      <td>Everton</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Man Utd</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>50000000.0</td>\n",
       "      <td>84700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4215</th>\n",
       "      <td>Virgil van Dijk</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>26</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>30000000.0</td>\n",
       "      <td>78800000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4695</th>\n",
       "      <td>Jasmin Kurtic</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>29</td>\n",
       "      <td>Atalanta</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>SPAL</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4696</th>\n",
       "      <td>Tchê Tchê</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>25</td>\n",
       "      <td>Palmeiras</td>\n",
       "      <td>Série A</td>\n",
       "      <td>Dynamo Kyiv</td>\n",
       "      <td>Premier Liga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3000000.0</td>\n",
       "      <td>4800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4697</th>\n",
       "      <td>Silvan Widmer</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>25</td>\n",
       "      <td>Udinese Calcio</td>\n",
       "      <td>Serie A</td>\n",
       "      <td>FC Basel</td>\n",
       "      <td>Super League</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>8500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4698</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4699</th>\n",
       "      <td>Kyle Bartley</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>27</td>\n",
       "      <td>Swansea</td>\n",
       "      <td>Championship</td>\n",
       "      <td>West Brom</td>\n",
       "      <td>Championship</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>3500000.0</td>\n",
       "      <td>4500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>483 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Name            Position  Age       Team_from  \\\n",
       "4211             Neymar         Left Winger   25    FC Barcelona   \n",
       "4212  Philippe Coutinho  Attacking Midfield   25       Liverpool   \n",
       "4213    Ousmane Dembélé        Right Winger   20   Bor. Dortmund   \n",
       "4214      Romelu Lukaku      Centre-Forward   24         Everton   \n",
       "4215    Virgil van Dijk         Centre-Back   26     Southampton   \n",
       "...                 ...                 ...  ...             ...   \n",
       "4695      Jasmin Kurtic  Attacking Midfield   29        Atalanta   \n",
       "4696          Tchê Tchê    Central Midfield   25       Palmeiras   \n",
       "4697      Silvan Widmer          Right-Back   25  Udinese Calcio   \n",
       "4698         Yuya Osako      Second Striker   28      1. FC Köln   \n",
       "4699       Kyle Bartley         Centre-Back   27         Swansea   \n",
       "\n",
       "         League_from        Team_to       League_to     Season  Market_value  \\\n",
       "4211          LaLiga       Paris SG         Ligue 1  2017-2018   100000000.0   \n",
       "4212  Premier League   FC Barcelona          LaLiga  2017-2018    90000000.0   \n",
       "4213    1.Bundesliga   FC Barcelona          LaLiga  2017-2018    33000000.0   \n",
       "4214  Premier League        Man Utd  Premier League  2017-2018    50000000.0   \n",
       "4215  Premier League      Liverpool  Premier League  2017-2018    30000000.0   \n",
       "...              ...            ...             ...        ...           ...   \n",
       "4695         Serie A           SPAL         Serie A  2018-2019     5000000.0   \n",
       "4696         Série A    Dynamo Kyiv    Premier Liga  2018-2019     3000000.0   \n",
       "4697         Serie A       FC Basel    Super League  2018-2019     8500000.0   \n",
       "4698    2.Bundesliga  Werder Bremen    1.Bundesliga  2018-2019     4500000.0   \n",
       "4699    Championship      West Brom    Championship  2018-2019     3500000.0   \n",
       "\n",
       "      Transfer_fee  \n",
       "4211     222000000  \n",
       "4212     125000000  \n",
       "4213     115000000  \n",
       "4214      84700000  \n",
       "4215      78800000  \n",
       "...            ...  \n",
       "4695       4800000  \n",
       "4696       4800000  \n",
       "4697       4500000  \n",
       "4698       4500000  \n",
       "4699       4500000  \n",
       "\n",
       "[483 rows x 10 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 483 in both seasons\n",
    "top250_2018 = top250_NaN[(top250_NaN['Season'] == \"2017-2018\") | (top250_NaN['Season'] == \"2018-2019\")]\n",
    "top250_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "e0ca91a5",
   "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>game_id</th>\n",
       "      <th>competition_code</th>\n",
       "      <th>season</th>\n",
       "      <th>round</th>\n",
       "      <th>date</th>\n",
       "      <th>home_club_id</th>\n",
       "      <th>away_club_id</th>\n",
       "      <th>home_club_goals</th>\n",
       "      <th>away_club_goals</th>\n",
       "      <th>home_club_position</th>\n",
       "      <th>...</th>\n",
       "      <th>url</th>\n",
       "      <th>player_id</th>\n",
       "      <th>appearance_id</th>\n",
       "      <th>competition_id</th>\n",
       "      <th>player_club_id</th>\n",
       "      <th>goals</th>\n",
       "      <th>assists</th>\n",
       "      <th>minutes_played</th>\n",
       "      <th>yellow_cards</th>\n",
       "      <th>red_cards</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>391397</th>\n",
       "      <td>3055009</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>2018</td>\n",
       "      <td>Final</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>383</td>\n",
       "      <td>234</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>287579</td>\n",
       "      <td>3055009_287579</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>234</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391398</th>\n",
       "      <td>3055009</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>2018</td>\n",
       "      <td>Final</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>383</td>\n",
       "      <td>234</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>104223</td>\n",
       "      <td>3055009_104223</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>234</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391399</th>\n",
       "      <td>3055009</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>2018</td>\n",
       "      <td>Final</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>383</td>\n",
       "      <td>234</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>315121</td>\n",
       "      <td>3055009_315121</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>234</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391400</th>\n",
       "      <td>3055009</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>2018</td>\n",
       "      <td>Final</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>383</td>\n",
       "      <td>234</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>182581</td>\n",
       "      <td>3055009_182581</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>234</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391401</th>\n",
       "      <td>3055009</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>2018</td>\n",
       "      <td>Final</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>383</td>\n",
       "      <td>234</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>369319</td>\n",
       "      <td>3055009_369319</td>\n",
       "      <td>NLSC</td>\n",
       "      <td>234</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>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>636021</th>\n",
       "      <td>3223001</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>2018</td>\n",
       "      <td>Second Round 1st leg</td>\n",
       "      <td>2019-07-25</td>\n",
       "      <td>10695</td>\n",
       "      <td>3426</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>156116</td>\n",
       "      <td>3223001_156116</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>3426</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636022</th>\n",
       "      <td>3223001</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>2018</td>\n",
       "      <td>Second Round 1st leg</td>\n",
       "      <td>2019-07-25</td>\n",
       "      <td>10695</td>\n",
       "      <td>3426</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>73662</td>\n",
       "      <td>3223001_73662</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>3426</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636023</th>\n",
       "      <td>3223001</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>2018</td>\n",
       "      <td>Second Round 1st leg</td>\n",
       "      <td>2019-07-25</td>\n",
       "      <td>10695</td>\n",
       "      <td>3426</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>77855</td>\n",
       "      <td>3223001_77855</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>3426</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636024</th>\n",
       "      <td>3223001</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>2018</td>\n",
       "      <td>Second Round 1st leg</td>\n",
       "      <td>2019-07-25</td>\n",
       "      <td>10695</td>\n",
       "      <td>3426</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>390664</td>\n",
       "      <td>3223001_390664</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>3426</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636025</th>\n",
       "      <td>3223001</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>2018</td>\n",
       "      <td>Second Round 1st leg</td>\n",
       "      <td>2019-07-25</td>\n",
       "      <td>10695</td>\n",
       "      <td>3426</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>345595</td>\n",
       "      <td>3223001_345595</td>\n",
       "      <td>ELQ</td>\n",
       "      <td>3426</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>129526 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_id competition_code  season                 round        date  \\\n",
       "391397  3055009             NLSC    2018                 Final  2018-08-04   \n",
       "391398  3055009             NLSC    2018                 Final  2018-08-04   \n",
       "391399  3055009             NLSC    2018                 Final  2018-08-04   \n",
       "391400  3055009             NLSC    2018                 Final  2018-08-04   \n",
       "391401  3055009             NLSC    2018                 Final  2018-08-04   \n",
       "...         ...              ...     ...                   ...         ...   \n",
       "636021  3223001              ELQ    2018  Second Round 1st leg  2019-07-25   \n",
       "636022  3223001              ELQ    2018  Second Round 1st leg  2019-07-25   \n",
       "636023  3223001              ELQ    2018  Second Round 1st leg  2019-07-25   \n",
       "636024  3223001              ELQ    2018  Second Round 1st leg  2019-07-25   \n",
       "636025  3223001              ELQ    2018  Second Round 1st leg  2019-07-25   \n",
       "\n",
       "        home_club_id  away_club_id  home_club_goals  away_club_goals  \\\n",
       "391397           383           234                6                7   \n",
       "391398           383           234                6                7   \n",
       "391399           383           234                6                7   \n",
       "391400           383           234                6                7   \n",
       "391401           383           234                6                7   \n",
       "...              ...           ...              ...              ...   \n",
       "636021         10695          3426                2                0   \n",
       "636022         10695          3426                2                0   \n",
       "636023         10695          3426                2                0   \n",
       "636024         10695          3426                2                0   \n",
       "636025         10695          3426                2                0   \n",
       "\n",
       "        home_club_position  ...  \\\n",
       "391397                 NaN  ...   \n",
       "391398                 NaN  ...   \n",
       "391399                 NaN  ...   \n",
       "391400                 NaN  ...   \n",
       "391401                 NaN  ...   \n",
       "...                    ...  ...   \n",
       "636021                 NaN  ...   \n",
       "636022                 NaN  ...   \n",
       "636023                 NaN  ...   \n",
       "636024                 NaN  ...   \n",
       "636025                 NaN  ...   \n",
       "\n",
       "                                                      url player_id  \\\n",
       "391397  https://www.transfermarkt.co.uk/spielbericht/i...    287579   \n",
       "391398  https://www.transfermarkt.co.uk/spielbericht/i...    104223   \n",
       "391399  https://www.transfermarkt.co.uk/spielbericht/i...    315121   \n",
       "391400  https://www.transfermarkt.co.uk/spielbericht/i...    182581   \n",
       "391401  https://www.transfermarkt.co.uk/spielbericht/i...    369319   \n",
       "...                                                   ...       ...   \n",
       "636021  https://www.transfermarkt.co.uk/spielbericht/i...    156116   \n",
       "636022  https://www.transfermarkt.co.uk/spielbericht/i...     73662   \n",
       "636023  https://www.transfermarkt.co.uk/spielbericht/i...     77855   \n",
       "636024  https://www.transfermarkt.co.uk/spielbericht/i...    390664   \n",
       "636025  https://www.transfermarkt.co.uk/spielbericht/i...    345595   \n",
       "\n",
       "         appearance_id competition_id  player_club_id goals assists  \\\n",
       "391397  3055009_287579           NLSC             234     0       0   \n",
       "391398  3055009_104223           NLSC             234     1       0   \n",
       "391399  3055009_315121           NLSC             234     0       0   \n",
       "391400  3055009_182581           NLSC             234     1       0   \n",
       "391401  3055009_369319           NLSC             234     1       0   \n",
       "...                ...            ...             ...   ...     ...   \n",
       "636021  3223001_156116            ELQ            3426     0       0   \n",
       "636022   3223001_73662            ELQ            3426     0       0   \n",
       "636023   3223001_77855            ELQ            3426     0       0   \n",
       "636024  3223001_390664            ELQ            3426     0       0   \n",
       "636025  3223001_345595            ELQ            3426     0       0   \n",
       "\n",
       "        minutes_played  yellow_cards  red_cards  \n",
       "391397              28             0          0  \n",
       "391398              90             0          0  \n",
       "391399              90             0          0  \n",
       "391400              90             0          0  \n",
       "391401               6             0          0  \n",
       "...                ...           ...        ...  \n",
       "636021              90             0          0  \n",
       "636022              45             0          0  \n",
       "636023              21             0          0  \n",
       "636024              45             0          0  \n",
       "636025              90             0          0  \n",
       "\n",
       "[129526 rows x 23 columns]"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merging games_df and appearances_df in order and filtering by 2018 season\n",
    "df_2018 = pd.merge(games_df, appearances_df, how=\"inner\", on=[\"game_id\", \"game_id\"])\n",
    "df_2018 = df_2018.loc[df_2018[\"season\"] == 2018]\n",
    "df_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "id": "65234a17",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7088"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df_2018[\"player_id\"].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "e5e4d6ec",
   "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_id</th>\n",
       "      <th>current_club_id</th>\n",
       "      <th>name</th>\n",
       "      <th>pretty_name</th>\n",
       "      <th>country_of_birth</th>\n",
       "      <th>country_of_citizenship</th>\n",
       "      <th>date_of_birth</th>\n",
       "      <th>position</th>\n",
       "      <th>sub_position</th>\n",
       "      <th>foot</th>\n",
       "      <th>...</th>\n",
       "      <th>attendance</th>\n",
       "      <th>url_y</th>\n",
       "      <th>appearance_id</th>\n",
       "      <th>competition_id</th>\n",
       "      <th>player_club_id</th>\n",
       "      <th>goals</th>\n",
       "      <th>assists</th>\n",
       "      <th>minutes_played</th>\n",
       "      <th>yellow_cards</th>\n",
       "      <th>red_cards</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/fortuna-dussel...</td>\n",
       "      <td>3058728_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>30400.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/hannover-96_1-...</td>\n",
       "      <td>3058699_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>38916.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/hertha-bsc_han...</td>\n",
       "      <td>3058688_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>40200.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/hannover-96_bo...</td>\n",
       "      <td>3058681_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>23512.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/vfl-wolfsburg_...</td>\n",
       "      <td>3058674_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>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>129521</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>41257.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/borussia-monch...</td>\n",
       "      <td>3058454_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129522</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>48755.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>3096458_7161</td>\n",
       "      <td>DFB</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129523</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>54022.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/borussia-monch...</td>\n",
       "      <td>3058436_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129524</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>29580.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/fc-augsburg_bo...</td>\n",
       "      <td>3058430_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129525</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>53087.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/borussia-monch...</td>\n",
       "      <td>3058408_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>129526 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        player_id  current_club_id            name     pretty_name  \\\n",
       "0           39426               42  nicolai-muller  Nicolai Muller   \n",
       "1           39426               42  nicolai-muller  Nicolai Muller   \n",
       "2           39426               42  nicolai-muller  Nicolai Muller   \n",
       "3           39426               42  nicolai-muller  Nicolai Muller   \n",
       "4           39426               42  nicolai-muller  Nicolai Muller   \n",
       "...           ...              ...             ...             ...   \n",
       "129521       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129522       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129523       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129524       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129525       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "\n",
       "       country_of_birth country_of_citizenship date_of_birth  position  \\\n",
       "0               Germany                Germany    1987-09-25  Midfield   \n",
       "1               Germany                Germany    1987-09-25  Midfield   \n",
       "2               Germany                Germany    1987-09-25  Midfield   \n",
       "3               Germany                Germany    1987-09-25  Midfield   \n",
       "4               Germany                Germany    1987-09-25  Midfield   \n",
       "...                 ...                    ...           ...       ...   \n",
       "129521          Germany                Germany    1992-07-14    Attack   \n",
       "129522          Germany                Germany    1992-07-14    Attack   \n",
       "129523          Germany                Germany    1992-07-14    Attack   \n",
       "129524          Germany                Germany    1992-07-14    Attack   \n",
       "129525          Germany                Germany    1992-07-14    Attack   \n",
       "\n",
       "              sub_position   foot  ...  attendance  \\\n",
       "0       Attacking Midfield  Right  ...     50000.0   \n",
       "1       Attacking Midfield  Right  ...     30400.0   \n",
       "2       Attacking Midfield  Right  ...     38916.0   \n",
       "3       Attacking Midfield  Right  ...     40200.0   \n",
       "4       Attacking Midfield  Right  ...     23512.0   \n",
       "...                    ...    ...  ...         ...   \n",
       "129521        Right Winger  Right  ...     41257.0   \n",
       "129522        Right Winger  Right  ...     48755.0   \n",
       "129523        Right Winger  Right  ...     54022.0   \n",
       "129524        Right Winger  Right  ...     29580.0   \n",
       "129525        Right Winger  Right  ...     53087.0   \n",
       "\n",
       "                                                    url_y  appearance_id  \\\n",
       "0       https://www.transfermarkt.co.uk/fortuna-dussel...  3058728_39426   \n",
       "1       https://www.transfermarkt.co.uk/hannover-96_1-...  3058699_39426   \n",
       "2       https://www.transfermarkt.co.uk/hertha-bsc_han...  3058688_39426   \n",
       "3       https://www.transfermarkt.co.uk/hannover-96_bo...  3058681_39426   \n",
       "4       https://www.transfermarkt.co.uk/vfl-wolfsburg_...  3058674_39426   \n",
       "...                                                   ...            ...   \n",
       "129521  https://www.transfermarkt.co.uk/borussia-monch...   3058454_7161   \n",
       "129522  https://www.transfermarkt.co.uk/spielbericht/i...   3096458_7161   \n",
       "129523  https://www.transfermarkt.co.uk/borussia-monch...   3058436_7161   \n",
       "129524  https://www.transfermarkt.co.uk/fc-augsburg_bo...   3058430_7161   \n",
       "129525  https://www.transfermarkt.co.uk/borussia-monch...   3058408_7161   \n",
       "\n",
       "       competition_id  player_club_id goals assists  minutes_played  \\\n",
       "0                  L1              42     1       0              20   \n",
       "1                  L1              42     0       0              45   \n",
       "2                  L1              42     0       0              17   \n",
       "3                  L1              42     0       0              90   \n",
       "4                  L1              42     0       0              70   \n",
       "...               ...             ...   ...     ...             ...   \n",
       "129521             L1              18     0       0              90   \n",
       "129522            DFB              18     0       0              75   \n",
       "129523             L1              18     0       1              90   \n",
       "129524             L1              18     0       0              90   \n",
       "129525             L1              18     1       0              90   \n",
       "\n",
       "        yellow_cards  red_cards  \n",
       "0                  0          0  \n",
       "1                  0          0  \n",
       "2                  0          0  \n",
       "3                  0          0  \n",
       "4                  1          0  \n",
       "...              ...        ...  \n",
       "129521             0          0  \n",
       "129522             0          0  \n",
       "129523             0          0  \n",
       "129524             0          0  \n",
       "129525             0          0  \n",
       "\n",
       "[129526 rows x 34 columns]"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merging players_df and df_2018 \n",
    "players_2018 = pd.merge(players_df, df_2018, how=\"inner\", on=[\"player_id\", \"player_id\"])\n",
    "players_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "id": "a4c8f5f8",
   "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>player_id</th>\n",
       "      <th>current_club_id</th>\n",
       "      <th>name</th>\n",
       "      <th>Name</th>\n",
       "      <th>country_of_birth</th>\n",
       "      <th>country_of_citizenship</th>\n",
       "      <th>date_of_birth</th>\n",
       "      <th>position</th>\n",
       "      <th>sub_position</th>\n",
       "      <th>foot</th>\n",
       "      <th>...</th>\n",
       "      <th>attendance</th>\n",
       "      <th>url_y</th>\n",
       "      <th>appearance_id</th>\n",
       "      <th>competition_id</th>\n",
       "      <th>player_club_id</th>\n",
       "      <th>goals</th>\n",
       "      <th>assists</th>\n",
       "      <th>minutes_played</th>\n",
       "      <th>yellow_cards</th>\n",
       "      <th>red_cards</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/fortuna-dussel...</td>\n",
       "      <td>3058728_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>30400.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/hannover-96_1-...</td>\n",
       "      <td>3058699_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>38916.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/hertha-bsc_han...</td>\n",
       "      <td>3058688_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>40200.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/hannover-96_bo...</td>\n",
       "      <td>3058681_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>39426</td>\n",
       "      <td>42</td>\n",
       "      <td>nicolai-muller</td>\n",
       "      <td>Nicolai Muller</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1987-09-25</td>\n",
       "      <td>Midfield</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>23512.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/vfl-wolfsburg_...</td>\n",
       "      <td>3058674_39426</td>\n",
       "      <td>L1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>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>129521</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>41257.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/borussia-monch...</td>\n",
       "      <td>3058454_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129522</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>48755.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>3096458_7161</td>\n",
       "      <td>DFB</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129523</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>54022.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/borussia-monch...</td>\n",
       "      <td>3058436_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129524</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>29580.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/fc-augsburg_bo...</td>\n",
       "      <td>3058430_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129525</th>\n",
       "      <td>7161</td>\n",
       "      <td>18</td>\n",
       "      <td>jonas-hofmann</td>\n",
       "      <td>Jonas Hofmann</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1992-07-14</td>\n",
       "      <td>Attack</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Right</td>\n",
       "      <td>...</td>\n",
       "      <td>53087.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/borussia-monch...</td>\n",
       "      <td>3058408_7161</td>\n",
       "      <td>L1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>129526 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        player_id  current_club_id            name            Name  \\\n",
       "0           39426               42  nicolai-muller  Nicolai Muller   \n",
       "1           39426               42  nicolai-muller  Nicolai Muller   \n",
       "2           39426               42  nicolai-muller  Nicolai Muller   \n",
       "3           39426               42  nicolai-muller  Nicolai Muller   \n",
       "4           39426               42  nicolai-muller  Nicolai Muller   \n",
       "...           ...              ...             ...             ...   \n",
       "129521       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129522       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129523       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129524       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "129525       7161               18   jonas-hofmann   Jonas Hofmann   \n",
       "\n",
       "       country_of_birth country_of_citizenship date_of_birth  position  \\\n",
       "0               Germany                Germany    1987-09-25  Midfield   \n",
       "1               Germany                Germany    1987-09-25  Midfield   \n",
       "2               Germany                Germany    1987-09-25  Midfield   \n",
       "3               Germany                Germany    1987-09-25  Midfield   \n",
       "4               Germany                Germany    1987-09-25  Midfield   \n",
       "...                 ...                    ...           ...       ...   \n",
       "129521          Germany                Germany    1992-07-14    Attack   \n",
       "129522          Germany                Germany    1992-07-14    Attack   \n",
       "129523          Germany                Germany    1992-07-14    Attack   \n",
       "129524          Germany                Germany    1992-07-14    Attack   \n",
       "129525          Germany                Germany    1992-07-14    Attack   \n",
       "\n",
       "              sub_position   foot  ...  attendance  \\\n",
       "0       Attacking Midfield  Right  ...     50000.0   \n",
       "1       Attacking Midfield  Right  ...     30400.0   \n",
       "2       Attacking Midfield  Right  ...     38916.0   \n",
       "3       Attacking Midfield  Right  ...     40200.0   \n",
       "4       Attacking Midfield  Right  ...     23512.0   \n",
       "...                    ...    ...  ...         ...   \n",
       "129521        Right Winger  Right  ...     41257.0   \n",
       "129522        Right Winger  Right  ...     48755.0   \n",
       "129523        Right Winger  Right  ...     54022.0   \n",
       "129524        Right Winger  Right  ...     29580.0   \n",
       "129525        Right Winger  Right  ...     53087.0   \n",
       "\n",
       "                                                    url_y  appearance_id  \\\n",
       "0       https://www.transfermarkt.co.uk/fortuna-dussel...  3058728_39426   \n",
       "1       https://www.transfermarkt.co.uk/hannover-96_1-...  3058699_39426   \n",
       "2       https://www.transfermarkt.co.uk/hertha-bsc_han...  3058688_39426   \n",
       "3       https://www.transfermarkt.co.uk/hannover-96_bo...  3058681_39426   \n",
       "4       https://www.transfermarkt.co.uk/vfl-wolfsburg_...  3058674_39426   \n",
       "...                                                   ...            ...   \n",
       "129521  https://www.transfermarkt.co.uk/borussia-monch...   3058454_7161   \n",
       "129522  https://www.transfermarkt.co.uk/spielbericht/i...   3096458_7161   \n",
       "129523  https://www.transfermarkt.co.uk/borussia-monch...   3058436_7161   \n",
       "129524  https://www.transfermarkt.co.uk/fc-augsburg_bo...   3058430_7161   \n",
       "129525  https://www.transfermarkt.co.uk/borussia-monch...   3058408_7161   \n",
       "\n",
       "       competition_id  player_club_id goals assists  minutes_played  \\\n",
       "0                  L1              42     1       0              20   \n",
       "1                  L1              42     0       0              45   \n",
       "2                  L1              42     0       0              17   \n",
       "3                  L1              42     0       0              90   \n",
       "4                  L1              42     0       0              70   \n",
       "...               ...             ...   ...     ...             ...   \n",
       "129521             L1              18     0       0              90   \n",
       "129522            DFB              18     0       0              75   \n",
       "129523             L1              18     0       1              90   \n",
       "129524             L1              18     0       0              90   \n",
       "129525             L1              18     1       0              90   \n",
       "\n",
       "        yellow_cards  red_cards  \n",
       "0                  0          0  \n",
       "1                  0          0  \n",
       "2                  0          0  \n",
       "3                  0          0  \n",
       "4                  1          0  \n",
       "...              ...        ...  \n",
       "129521             0          0  \n",
       "129522             0          0  \n",
       "129523             0          0  \n",
       "129524             0          0  \n",
       "129525             0          0  \n",
       "\n",
       "[129526 rows x 34 columns]"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players_2018.rename(columns={\"pretty_name\": \"Name\"}, inplace=True)\n",
    "players_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "id": "d8944bfe",
   "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>Name</th>\n",
       "      <th>Position</th>\n",
       "      <th>Age</th>\n",
       "      <th>Team_from</th>\n",
       "      <th>League_from</th>\n",
       "      <th>Team_to</th>\n",
       "      <th>League_to</th>\n",
       "      <th>Season</th>\n",
       "      <th>Market_value</th>\n",
       "      <th>Transfer_fee</th>\n",
       "      <th>...</th>\n",
       "      <th>attendance</th>\n",
       "      <th>url_y</th>\n",
       "      <th>appearance_id</th>\n",
       "      <th>competition_id</th>\n",
       "      <th>player_club_id</th>\n",
       "      <th>goals</th>\n",
       "      <th>assists</th>\n",
       "      <th>minutes_played</th>\n",
       "      <th>yellow_cards</th>\n",
       "      <th>red_cards</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>25</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>222000000</td>\n",
       "      <td>...</td>\n",
       "      <td>33138.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/ogc-nice_paris...</td>\n",
       "      <td>3047536_68290</td>\n",
       "      <td>FR1</td>\n",
       "      <td>583</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>25</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>222000000</td>\n",
       "      <td>...</td>\n",
       "      <td>14728.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/sco-angers_par...</td>\n",
       "      <td>3047871_68290</td>\n",
       "      <td>FR1</td>\n",
       "      <td>583</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>25</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>222000000</td>\n",
       "      <td>...</td>\n",
       "      <td>47283.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/paris-saint-ge...</td>\n",
       "      <td>3047866_68290</td>\n",
       "      <td>FR1</td>\n",
       "      <td>583</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>25</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>222000000</td>\n",
       "      <td>...</td>\n",
       "      <td>20477.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/montpellier-hs...</td>\n",
       "      <td>3047856_68290</td>\n",
       "      <td>FR1</td>\n",
       "      <td>583</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>25</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LaLiga</td>\n",
       "      <td>Paris SG</td>\n",
       "      <td>Ligue 1</td>\n",
       "      <td>2017-2018</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>222000000</td>\n",
       "      <td>...</td>\n",
       "      <td>43581.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/paris-saint-ge...</td>\n",
       "      <td>3047846_68290</td>\n",
       "      <td>FR1</td>\n",
       "      <td>583</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>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>9304</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "      <td>...</td>\n",
       "      <td>39100.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/sv-werder-brem...</td>\n",
       "      <td>3058455_108650</td>\n",
       "      <td>L1</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9305</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "      <td>...</td>\n",
       "      <td>42100.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/spielbericht/i...</td>\n",
       "      <td>3174557_108650</td>\n",
       "      <td>DFB</td>\n",
       "      <td>86</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9306</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "      <td>...</td>\n",
       "      <td>42100.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/sv-werder-brem...</td>\n",
       "      <td>3058437_108650</td>\n",
       "      <td>L1</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>88</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9307</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "      <td>...</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/eintracht-fran...</td>\n",
       "      <td>3058429_108650</td>\n",
       "      <td>L1</td>\n",
       "      <td>86</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9308</th>\n",
       "      <td>Yuya Osako</td>\n",
       "      <td>Second Striker</td>\n",
       "      <td>28</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>2.Bundesliga</td>\n",
       "      <td>Werder Bremen</td>\n",
       "      <td>1.Bundesliga</td>\n",
       "      <td>2018-2019</td>\n",
       "      <td>4500000.0</td>\n",
       "      <td>4500000</td>\n",
       "      <td>...</td>\n",
       "      <td>42100.0</td>\n",
       "      <td>https://www.transfermarkt.co.uk/sv-werder-brem...</td>\n",
       "      <td>3058410_108650</td>\n",
       "      <td>L1</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9309 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Name        Position  Age     Team_from   League_from  \\\n",
       "0         Neymar     Left Winger   25  FC Barcelona        LaLiga   \n",
       "1         Neymar     Left Winger   25  FC Barcelona        LaLiga   \n",
       "2         Neymar     Left Winger   25  FC Barcelona        LaLiga   \n",
       "3         Neymar     Left Winger   25  FC Barcelona        LaLiga   \n",
       "4         Neymar     Left Winger   25  FC Barcelona        LaLiga   \n",
       "...          ...             ...  ...           ...           ...   \n",
       "9304  Yuya Osako  Second Striker   28    1. FC Köln  2.Bundesliga   \n",
       "9305  Yuya Osako  Second Striker   28    1. FC Köln  2.Bundesliga   \n",
       "9306  Yuya Osako  Second Striker   28    1. FC Köln  2.Bundesliga   \n",
       "9307  Yuya Osako  Second Striker   28    1. FC Köln  2.Bundesliga   \n",
       "9308  Yuya Osako  Second Striker   28    1. FC Köln  2.Bundesliga   \n",
       "\n",
       "            Team_to     League_to     Season  Market_value  Transfer_fee  ...  \\\n",
       "0          Paris SG       Ligue 1  2017-2018   100000000.0     222000000  ...   \n",
       "1          Paris SG       Ligue 1  2017-2018   100000000.0     222000000  ...   \n",
       "2          Paris SG       Ligue 1  2017-2018   100000000.0     222000000  ...   \n",
       "3          Paris SG       Ligue 1  2017-2018   100000000.0     222000000  ...   \n",
       "4          Paris SG       Ligue 1  2017-2018   100000000.0     222000000  ...   \n",
       "...             ...           ...        ...           ...           ...  ...   \n",
       "9304  Werder Bremen  1.Bundesliga  2018-2019     4500000.0       4500000  ...   \n",
       "9305  Werder Bremen  1.Bundesliga  2018-2019     4500000.0       4500000  ...   \n",
       "9306  Werder Bremen  1.Bundesliga  2018-2019     4500000.0       4500000  ...   \n",
       "9307  Werder Bremen  1.Bundesliga  2018-2019     4500000.0       4500000  ...   \n",
       "9308  Werder Bremen  1.Bundesliga  2018-2019     4500000.0       4500000  ...   \n",
       "\n",
       "      attendance                                              url_y  \\\n",
       "0        33138.0  https://www.transfermarkt.co.uk/ogc-nice_paris...   \n",
       "1        14728.0  https://www.transfermarkt.co.uk/sco-angers_par...   \n",
       "2        47283.0  https://www.transfermarkt.co.uk/paris-saint-ge...   \n",
       "3        20477.0  https://www.transfermarkt.co.uk/montpellier-hs...   \n",
       "4        43581.0  https://www.transfermarkt.co.uk/paris-saint-ge...   \n",
       "...          ...                                                ...   \n",
       "9304     39100.0  https://www.transfermarkt.co.uk/sv-werder-brem...   \n",
       "9305     42100.0  https://www.transfermarkt.co.uk/spielbericht/i...   \n",
       "9306     42100.0  https://www.transfermarkt.co.uk/sv-werder-brem...   \n",
       "9307     50000.0  https://www.transfermarkt.co.uk/eintracht-fran...   \n",
       "9308     42100.0  https://www.transfermarkt.co.uk/sv-werder-brem...   \n",
       "\n",
       "       appearance_id competition_id player_club_id goals assists  \\\n",
       "0      3047536_68290            FR1            583     2       0   \n",
       "1      3047871_68290            FR1            583     1       1   \n",
       "2      3047866_68290            FR1            583     1       0   \n",
       "3      3047856_68290            FR1            583     0       0   \n",
       "4      3047846_68290            FR1            583     0       0   \n",
       "...              ...            ...            ...   ...     ...   \n",
       "9304  3058455_108650             L1             86     0       0   \n",
       "9305  3174557_108650            DFB             86     1       0   \n",
       "9306  3058437_108650             L1             86     0       0   \n",
       "9307  3058429_108650             L1             86     1       0   \n",
       "9308  3058410_108650             L1             86     0       0   \n",
       "\n",
       "     minutes_played yellow_cards  red_cards  \n",
       "0                90            0          0  \n",
       "1                90            0          0  \n",
       "2                90            0          0  \n",
       "3                90            0          0  \n",
       "4                45            0          0  \n",
       "...             ...          ...        ...  \n",
       "9304             90            0          0  \n",
       "9305             90            0          0  \n",
       "9306             88            0          0  \n",
       "9307             90            0          0  \n",
       "9308             90            0          0  \n",
       "\n",
       "[9309 rows x 43 columns]"
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "market_value_2018 = pd.merge(top250_2018, players_2018, how=\"inner\", on=[\"Name\", \"Name\"])\n",
    "market_value_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "e172bf3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "307"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(market_value_2018[\"Name\"].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "05c035c7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "7024\n"
     ]
    }
   ],
   "source": [
    "# Get the total unique players in 2018\n",
    "print(len(players_2018[\"pretty_name\"].unique())) #20,290\n",
    "unique_players_2018 = players_2018[\"pretty_name\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "id": "687c9ed3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Nicolai Muller', 'Julian Korb', 'Pirmin Schwegler', ...,\n",
       "       'Marcel Halstenberg', 'Philipp Tschauner', 'Jonas Hofmann'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unique_players_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "id": "1b05033f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No\n"
     ]
    }
   ],
   "source": [
    "if \"Aloy Ihenacho\" in unique_players_2018:\n",
    "    print(\"Yes\")\n",
    "else:\n",
    "    print(\"No\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "b822e695",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "365\n"
     ]
    }
   ],
   "source": [
    "# Unique players in both lists\n",
    "list_player_names = players_df[\"pretty_name\"].tolist()\n",
    "\n",
    "counter = 0\n",
    "for name in list_player_names:\n",
    "    if name in top250_2018[\"Name\"].tolist():\n",
    "        counter += 1\n",
    "    else:\n",
    "        counter = counter\n",
    "print(counter)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "51a3b58a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "20626"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(list_player_names)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "286731ef",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "307"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Unique players in 2018 in both lists\n",
    "x = 0\n",
    "for name in unique_players_2018:\n",
    "    if name in names:\n",
    "        x += 1\n",
    "    else:\n",
    "        x = x\n",
    "x"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "PythonDATA",
   "language": "python",
   "name": "pythondata"
  },
  "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.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}