Base de Dados.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "0ab8eb89",
   "metadata": {},
   "source": [
    "# Análise de Dados e Separação de Times"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "87d49442",
   "metadata": {},
   "source": [
    "#### Fonte de dados: https://www.kaggle.com/datasets/cbhavik/football-transfers-from-199293-to-202122-seasons"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d6c006b6",
   "metadata": {},
   "source": [
    "## Separar dataframes de transferências dos 6 principais times da Premier League:\n",
    "## Arsenal, Chelsea, Liverpool, Manchester City, Manchester United e Tottenham"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6f97a177",
   "metadata": {},
   "source": [
    "### Observação \n",
    "\n",
    "### 1 - Depois de checar no site transfermarket, os valores de 'fee' = '-' or '?' foram substituídos por 0.0, pois descobrimos que foram transferências sem custos.\n",
    "### 2 - Os valores de 'fee_cleaned' estão em milhões de euros."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d31ca856",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "a3c4b98e",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>fee</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>transfer_period</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>league_name</th>\n",
       "      <th>year</th>\n",
       "      <th>season</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Tommy Wright</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>Leicester</td>\n",
       "      <td>€910Th.</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.910</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Jonathan Gittens</td>\n",
       "      <td>28.0</td>\n",
       "      <td>defence</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>€250Th.</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.250</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Chris Morris</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Celtic</td>\n",
       "      <td>?</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Ben Roberts</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Boro U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Andy Todd</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Boro U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Stuart Ripley</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Blackburn</td>\n",
       "      <td>€2.00m</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>2.000</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Gary Parkinson</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Southend United</td>\n",
       "      <td>loan transfer</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Bernie Slaven</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Port Vale</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Andy Payton</td>\n",
       "      <td>24.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Celtic</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Ian Arnold</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Carlisle United</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Dwight Marshall</td>\n",
       "      <td>27.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Plymouth</td>\n",
       "      <td>End of loanMay 31, 1993</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Mark Robins</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Man Utd</td>\n",
       "      <td>€1.00m</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>1.000</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Gary Megson</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Man City</td>\n",
       "      <td>free transfer</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.000</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Mark Peters</td>\n",
       "      <td>19.0</td>\n",
       "      <td>defence</td>\n",
       "      <td>Man City</td>\n",
       "      <td>free transfer</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.000</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Darren Eadie</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Left Midfield</td>\n",
       "      <td>Norwich U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Andy Johnson</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Norwich U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Lee Power</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Charlton</td>\n",
       "      <td>End of loanMay 31, 1993</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Tim Sherwood</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Blackburn</td>\n",
       "      <td>€750Th.</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.750</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Paul Blades</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Wolves</td>\n",
       "      <td>€378Th.</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.378</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Steve Ball</td>\n",
       "      <td>22.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Cambridge Utd.</td>\n",
       "      <td>free transfer</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.000</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Adrian Pennock</td>\n",
       "      <td>21.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>€36Th.</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.036</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Robert Fleck</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>Colin Loss</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Right Midfield</td>\n",
       "      <td>Derby</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Norwich City</td>\n",
       "      <td>David Williams</td>\n",
       "      <td>37.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Retired</td>\n",
       "      <td>-</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Ian Olney</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Aston Villa</td>\n",
       "      <td>€894Th.</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.894</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Neil Pointon</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Man City</td>\n",
       "      <td>€675Th.</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.675</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Steve Redmond</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Man City</td>\n",
       "      <td>€450Th.</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.450</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Chris Makin</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Oldham U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Paul Gerrard</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Oldham U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Chris Makin</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Wigan</td>\n",
       "      <td>End of loanMay 1, 1993</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Paul Moulden</td>\n",
       "      <td>24.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Molde</td>\n",
       "      <td>End of loanJun 30, 1992</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Chris Makin</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Wigan</td>\n",
       "      <td>loan transfer</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Rick Holden</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Left Midfield</td>\n",
       "      <td>Man City</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Mike Fillery</td>\n",
       "      <td>31.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Crawley Town</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>Paul Moulden</td>\n",
       "      <td>24.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>loan transfer</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Queens Park Rangers</td>\n",
       "      <td>Darren Finlay</td>\n",
       "      <td>18.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>QPR U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Queens Park Rangers</td>\n",
       "      <td>Kevin Gallen</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>QPR U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Queens Park Rangers</td>\n",
       "      <td>Gary Waddock</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Swindon Town</td>\n",
       "      <td>End of loanJun 30, 1992</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Queens Park Rangers</td>\n",
       "      <td>Andy Tillson</td>\n",
       "      <td>26.0</td>\n",
       "      <td>defence</td>\n",
       "      <td>Grimsby Town</td>\n",
       "      <td>loan transfer</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Queens Park Rangers</td>\n",
       "      <td>Justin Channing</td>\n",
       "      <td>23.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Bristol Rovers</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Queens Park Rangers</td>\n",
       "      <td>Gary Waddock</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Bristol Rovers</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Sheffield Wednesday</td>\n",
       "      <td>Mark Bright</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>€1.70m</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>1.700</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Sheffield Wednesday</td>\n",
       "      <td>Chris Waddle</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>€1.50m</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>1.500</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Sheffield Wednesday</td>\n",
       "      <td>Simon Stewart</td>\n",
       "      <td>18.0</td>\n",
       "      <td>defence</td>\n",
       "      <td>Sheff Wed U18</td>\n",
       "      <td>-</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Sheffield Wednesday</td>\n",
       "      <td>Marlon Beresford</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Burnley</td>\n",
       "      <td>€140Th.</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.140</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Sheffield Wednesday</td>\n",
       "      <td>Paul Williams</td>\n",
       "      <td>27.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>?</td>\n",
       "      <td>out</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Wimbledon FC</td>\n",
       "      <td>Dean Holdsworth</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Brentford</td>\n",
       "      <td>€1.00m</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>1.000</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Wimbledon FC</td>\n",
       "      <td>Vinnie Jones</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>€830Th.</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.830</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Wimbledon FC</td>\n",
       "      <td>Greg Berry</td>\n",
       "      <td>21.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Leyton Orient</td>\n",
       "      <td>€313Th.</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>0.313</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Wimbledon FC</td>\n",
       "      <td>Peter Fear</td>\n",
       "      <td>18.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>?</td>\n",
       "      <td>in</td>\n",
       "      <td>Summer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992/1993</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              club_name       player_name   age            position  \\\n",
       "0      Middlesbrough FC      Tommy Wright  26.0         Left Winger   \n",
       "1      Middlesbrough FC  Jonathan Gittens  28.0             defence   \n",
       "2      Middlesbrough FC      Chris Morris  28.0          Right-Back   \n",
       "3      Middlesbrough FC       Ben Roberts  17.0          Goalkeeper   \n",
       "4      Middlesbrough FC         Andy Todd  17.0         Centre-Back   \n",
       "5      Middlesbrough FC     Stuart Ripley  24.0        Right Winger   \n",
       "6      Middlesbrough FC    Gary Parkinson  24.0          Right-Back   \n",
       "7      Middlesbrough FC     Bernie Slaven  31.0      Centre-Forward   \n",
       "8      Middlesbrough FC       Andy Payton  24.0              attack   \n",
       "9      Middlesbrough FC        Ian Arnold  20.0      Centre-Forward   \n",
       "10     Middlesbrough FC   Dwight Marshall  27.0              attack   \n",
       "11         Norwich City       Mark Robins  22.0      Centre-Forward   \n",
       "12         Norwich City       Gary Megson  33.0  Defensive Midfield   \n",
       "13         Norwich City       Mark Peters  19.0             defence   \n",
       "14         Norwich City      Darren Eadie  17.0       Left Midfield   \n",
       "15         Norwich City      Andy Johnson  18.0  Attacking Midfield   \n",
       "16         Norwich City         Lee Power  20.0      Centre-Forward   \n",
       "17         Norwich City      Tim Sherwood  23.0    Central Midfield   \n",
       "18         Norwich City       Paul Blades  27.0          Right-Back   \n",
       "19         Norwich City        Steve Ball  22.0            midfield   \n",
       "20         Norwich City    Adrian Pennock  21.0            midfield   \n",
       "21         Norwich City      Robert Fleck  26.0      Centre-Forward   \n",
       "22         Norwich City        Colin Loss  18.0      Right Midfield   \n",
       "23         Norwich City    David Williams  37.0            midfield   \n",
       "24      Oldham Athletic         Ian Olney  22.0      Centre-Forward   \n",
       "25      Oldham Athletic      Neil Pointon  27.0           Left-Back   \n",
       "26      Oldham Athletic     Steve Redmond  24.0         Centre-Back   \n",
       "27      Oldham Athletic       Chris Makin  19.0           Left-Back   \n",
       "28      Oldham Athletic      Paul Gerrard  19.0          Goalkeeper   \n",
       "29      Oldham Athletic       Chris Makin  19.0           Left-Back   \n",
       "30      Oldham Athletic      Paul Moulden  24.0              attack   \n",
       "31      Oldham Athletic       Chris Makin  19.0           Left-Back   \n",
       "32      Oldham Athletic       Rick Holden  27.0       Left Midfield   \n",
       "33      Oldham Athletic      Mike Fillery  31.0            midfield   \n",
       "34      Oldham Athletic      Paul Moulden  24.0              attack   \n",
       "35  Queens Park Rangers     Darren Finlay  18.0            midfield   \n",
       "36  Queens Park Rangers      Kevin Gallen  17.0      Centre-Forward   \n",
       "37  Queens Park Rangers      Gary Waddock  30.0  Defensive Midfield   \n",
       "38  Queens Park Rangers      Andy Tillson  26.0             defence   \n",
       "39  Queens Park Rangers   Justin Channing  23.0            midfield   \n",
       "40  Queens Park Rangers      Gary Waddock  30.0  Defensive Midfield   \n",
       "41  Sheffield Wednesday       Mark Bright  30.0      Centre-Forward   \n",
       "42  Sheffield Wednesday      Chris Waddle  31.0  Attacking Midfield   \n",
       "43  Sheffield Wednesday     Simon Stewart  18.0             defence   \n",
       "44  Sheffield Wednesday  Marlon Beresford  22.0          Goalkeeper   \n",
       "45  Sheffield Wednesday     Paul Williams  27.0              attack   \n",
       "46         Wimbledon FC   Dean Holdsworth  23.0      Centre-Forward   \n",
       "47         Wimbledon FC      Vinnie Jones  27.0  Defensive Midfield   \n",
       "48         Wimbledon FC        Greg Berry  21.0            midfield   \n",
       "49         Wimbledon FC        Peter Fear  18.0            midfield   \n",
       "\n",
       "   club_involved_name                      fee transfer_movement  \\\n",
       "0           Leicester                  €910Th.                in   \n",
       "1         Southampton                  €250Th.                in   \n",
       "2              Celtic                        ?                in   \n",
       "3            Boro U18                        -                in   \n",
       "4            Boro U18                        -                in   \n",
       "5           Blackburn                   €2.00m               out   \n",
       "6     Southend United            loan transfer               out   \n",
       "7           Port Vale                        ?               out   \n",
       "8              Celtic                        ?               out   \n",
       "9     Carlisle United                        ?               out   \n",
       "10           Plymouth  End of loanMay 31, 1993               out   \n",
       "11            Man Utd                   €1.00m                in   \n",
       "12           Man City            free transfer                in   \n",
       "13           Man City            free transfer                in   \n",
       "14        Norwich U18                        -                in   \n",
       "15        Norwich U18                        -                in   \n",
       "16           Charlton  End of loanMay 31, 1993                in   \n",
       "17          Blackburn                  €750Th.               out   \n",
       "18             Wolves                  €378Th.               out   \n",
       "19     Cambridge Utd.            free transfer               out   \n",
       "20        Bournemouth                   €36Th.               out   \n",
       "21            Chelsea                        ?               out   \n",
       "22              Derby                        ?               out   \n",
       "23            Retired                        -               out   \n",
       "24        Aston Villa                  €894Th.                in   \n",
       "25           Man City                  €675Th.                in   \n",
       "26           Man City                  €450Th.                in   \n",
       "27         Oldham U18                        -                in   \n",
       "28         Oldham U18                        -                in   \n",
       "29              Wigan   End of loanMay 1, 1993                in   \n",
       "30              Molde  End of loanJun 30, 1992                in   \n",
       "31              Wigan            loan transfer               out   \n",
       "32           Man City                        ?               out   \n",
       "33       Crawley Town                        ?               out   \n",
       "34           Brighton            loan transfer               out   \n",
       "35            QPR U18                        -                in   \n",
       "36            QPR U18                        -                in   \n",
       "37       Swindon Town  End of loanJun 30, 1992                in   \n",
       "38       Grimsby Town            loan transfer               out   \n",
       "39     Bristol Rovers                        ?               out   \n",
       "40     Bristol Rovers                        ?               out   \n",
       "41     Crystal Palace                   €1.70m                in   \n",
       "42          Marseille                   €1.50m                in   \n",
       "43      Sheff Wed U18                        -                in   \n",
       "44            Burnley                  €140Th.               out   \n",
       "45     Crystal Palace                        ?               out   \n",
       "46          Brentford                   €1.00m                in   \n",
       "47            Chelsea                  €830Th.                in   \n",
       "48      Leyton Orient                  €313Th.                in   \n",
       "49            Unknown                        ?                in   \n",
       "\n",
       "   transfer_period  fee_cleaned     league_name  year     season  \n",
       "0           Summer        0.910  Premier League  1992  1992/1993  \n",
       "1           Summer        0.250  Premier League  1992  1992/1993  \n",
       "2           Summer          NaN  Premier League  1992  1992/1993  \n",
       "3           Summer          NaN  Premier League  1992  1992/1993  \n",
       "4           Summer          NaN  Premier League  1992  1992/1993  \n",
       "5           Summer        2.000  Premier League  1992  1992/1993  \n",
       "6           Summer          NaN  Premier League  1992  1992/1993  \n",
       "7           Summer          NaN  Premier League  1992  1992/1993  \n",
       "8           Summer          NaN  Premier League  1992  1992/1993  \n",
       "9           Summer          NaN  Premier League  1992  1992/1993  \n",
       "10          Summer          NaN  Premier League  1992  1992/1993  \n",
       "11          Summer        1.000  Premier League  1992  1992/1993  \n",
       "12          Summer        0.000  Premier League  1992  1992/1993  \n",
       "13          Summer        0.000  Premier League  1992  1992/1993  \n",
       "14          Summer          NaN  Premier League  1992  1992/1993  \n",
       "15          Summer          NaN  Premier League  1992  1992/1993  \n",
       "16          Summer          NaN  Premier League  1992  1992/1993  \n",
       "17          Summer        0.750  Premier League  1992  1992/1993  \n",
       "18          Summer        0.378  Premier League  1992  1992/1993  \n",
       "19          Summer        0.000  Premier League  1992  1992/1993  \n",
       "20          Summer        0.036  Premier League  1992  1992/1993  \n",
       "21          Summer          NaN  Premier League  1992  1992/1993  \n",
       "22          Summer          NaN  Premier League  1992  1992/1993  \n",
       "23          Summer          NaN  Premier League  1992  1992/1993  \n",
       "24          Summer        0.894  Premier League  1992  1992/1993  \n",
       "25          Summer        0.675  Premier League  1992  1992/1993  \n",
       "26          Summer        0.450  Premier League  1992  1992/1993  \n",
       "27          Summer          NaN  Premier League  1992  1992/1993  \n",
       "28          Summer          NaN  Premier League  1992  1992/1993  \n",
       "29          Summer          NaN  Premier League  1992  1992/1993  \n",
       "30          Summer          NaN  Premier League  1992  1992/1993  \n",
       "31          Summer          NaN  Premier League  1992  1992/1993  \n",
       "32          Summer          NaN  Premier League  1992  1992/1993  \n",
       "33          Summer          NaN  Premier League  1992  1992/1993  \n",
       "34          Summer          NaN  Premier League  1992  1992/1993  \n",
       "35          Summer          NaN  Premier League  1992  1992/1993  \n",
       "36          Summer          NaN  Premier League  1992  1992/1993  \n",
       "37          Summer          NaN  Premier League  1992  1992/1993  \n",
       "38          Summer          NaN  Premier League  1992  1992/1993  \n",
       "39          Summer          NaN  Premier League  1992  1992/1993  \n",
       "40          Summer          NaN  Premier League  1992  1992/1993  \n",
       "41          Summer        1.700  Premier League  1992  1992/1993  \n",
       "42          Summer        1.500  Premier League  1992  1992/1993  \n",
       "43          Summer          NaN  Premier League  1992  1992/1993  \n",
       "44          Summer        0.140  Premier League  1992  1992/1993  \n",
       "45          Summer          NaN  Premier League  1992  1992/1993  \n",
       "46          Summer        1.000  Premier League  1992  1992/1993  \n",
       "47          Summer        0.830  Premier League  1992  1992/1993  \n",
       "48          Summer        0.313  Premier League  1992  1992/1993  \n",
       "49          Summer          NaN  Premier League  1992  1992/1993  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados = pd.read_csv('dados/premier-league.csv')\n",
    "dados.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "63945b97",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "club_name              object\n",
       "player_name            object\n",
       "age                   float64\n",
       "position               object\n",
       "club_involved_name     object\n",
       "fee                    object\n",
       "transfer_movement      object\n",
       "transfer_period        object\n",
       "fee_cleaned           float64\n",
       "league_name            object\n",
       "year                    int64\n",
       "season                 object\n",
       "dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "145011f0",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        0.91\n",
       "1        0.25\n",
       "2         NaN\n",
       "3         NaN\n",
       "4         NaN\n",
       "         ... \n",
       "22970     NaN\n",
       "22971     NaN\n",
       "22972     NaN\n",
       "22973     NaN\n",
       "22974     NaN\n",
       "Name: fee_cleaned, Length: 22975, dtype: float64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.fee_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b08e65b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    8739.000000\n",
       "mean        4.076735\n",
       "std         8.981443\n",
       "min         0.000000\n",
       "25%         0.000000\n",
       "50%         0.700000\n",
       "75%         4.000000\n",
       "max       135.000000\n",
       "Name: fee_cleaned, dtype: float64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['fee_cleaned'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "b421e629",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A base de dados apresenta 22975 registros de transferências e 12 variáveis.\n"
     ]
    }
   ],
   "source": [
    "print(f'A base de dados apresenta {dados.shape[0]} registros de transferências e {dados.shape[1]} variáveis.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "19801f7e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Middlesbrough FC', 'Norwich City', 'Oldham Athletic',\n",
       "       'Queens Park Rangers', 'Sheffield Wednesday', 'Wimbledon FC',\n",
       "       'Coventry City', 'Manchester United', 'Crystal Palace',\n",
       "       'Nottingham Forest', 'Ipswich Town', 'Arsenal FC', 'Chelsea FC',\n",
       "       'Aston Villa', 'Leeds United', 'Sheffield United',\n",
       "       'Manchester City', 'Southampton FC', 'Blackburn Rovers',\n",
       "       'Tottenham Hotspur', 'Liverpool FC', 'Everton FC',\n",
       "       'Newcastle United', 'West Ham United', 'Swindon Town',\n",
       "       'Leicester City', 'Bolton Wanderers', 'Sunderland AFC',\n",
       "       'Derby County', 'Barnsley FC', 'Charlton Athletic',\n",
       "       'Bradford City', 'Watford FC', 'Fulham FC', 'West Bromwich Albion',\n",
       "       'Birmingham City', 'Portsmouth FC', 'Wolverhampton Wanderers',\n",
       "       'Wigan Athletic', 'Reading FC', 'Stoke City', 'Hull City',\n",
       "       'Burnley FC', 'Blackpool FC', 'Swansea City', 'Cardiff City',\n",
       "       'AFC Bournemouth', 'Brighton & Hove Albion', 'Huddersfield Town',\n",
       "       'Brentford FC'], dtype=object)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['club_name'].unique()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "7b935825",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Chelsea FC                 1273\n",
       "Tottenham Hotspur          1196\n",
       "West Ham United            1068\n",
       "Manchester City            1055\n",
       "Liverpool FC               1051\n",
       "Manchester United           980\n",
       "Newcastle United            959\n",
       "Arsenal FC                  934\n",
       "Everton FC                  933\n",
       "Aston Villa                 929\n",
       "Sunderland AFC              822\n",
       "Southampton FC              764\n",
       "Blackburn Rovers            735\n",
       "Fulham FC                   694\n",
       "Middlesbrough FC            557\n",
       "Leicester City              539\n",
       "Bolton Wanderers            533\n",
       "Crystal Palace              504\n",
       "West Bromwich Albion        461\n",
       "Portsmouth FC               442\n",
       "Wolverhampton Wanderers     433\n",
       "Watford FC                  419\n",
       "Stoke City                  417\n",
       "Norwich City                402\n",
       "Leeds United                398\n",
       "Birmingham City             342\n",
       "Wigan Athletic              339\n",
       "Queens Park Rangers         313\n",
       "Charlton Athletic           307\n",
       "Swansea City                304\n",
       "Coventry City               275\n",
       "Brighton & Hove Albion      264\n",
       "Derby County                256\n",
       "Hull City                   255\n",
       "Burnley FC                  253\n",
       "Sheffield Wednesday         206\n",
       "AFC Bournemouth             203\n",
       "Sheffield United            193\n",
       "Reading FC                  179\n",
       "Wimbledon FC                154\n",
       "Nottingham Forest           145\n",
       "Ipswich Town                101\n",
       "Cardiff City                 98\n",
       "Huddersfield Town            73\n",
       "Bradford City                64\n",
       "Blackpool FC                 50\n",
       "Brentford FC                 34\n",
       "Oldham Athletic              31\n",
       "Barnsley FC                  22\n",
       "Swindon Town                 16\n",
       "Name: club_name, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['club_name'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "46123722",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        False\n",
       "1        False\n",
       "2        False\n",
       "3        False\n",
       "4        False\n",
       "         ...  \n",
       "22970    False\n",
       "22971    False\n",
       "22972    False\n",
       "22973    False\n",
       "22974    False\n",
       "Length: 22975, dtype: bool"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selecao = (dados['fee'].str.contains('Th')) & (dados['fee_cleaned'] > 1)\n",
    "selecao"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "d20f94c1",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Tommy Wright</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>Leicester</td>\n",
       "      <td>in</td>\n",
       "      <td>0.91</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Jonathan Gittens</td>\n",
       "      <td>28.0</td>\n",
       "      <td>defence</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Chris Morris</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Celtic</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Ben Roberts</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Boro U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Andy Todd</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Boro U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Stuart Ripley</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Blackburn</td>\n",
       "      <td>out</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Gary Parkinson</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Southend United</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Bernie Slaven</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Port Vale</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Andy Payton</td>\n",
       "      <td>24.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Celtic</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Middlesbrough FC</td>\n",
       "      <td>Ian Arnold</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Carlisle United</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          club_name       player_name   age        position  \\\n",
       "0  Middlesbrough FC      Tommy Wright  26.0     Left Winger   \n",
       "1  Middlesbrough FC  Jonathan Gittens  28.0         defence   \n",
       "2  Middlesbrough FC      Chris Morris  28.0      Right-Back   \n",
       "3  Middlesbrough FC       Ben Roberts  17.0      Goalkeeper   \n",
       "4  Middlesbrough FC         Andy Todd  17.0     Centre-Back   \n",
       "5  Middlesbrough FC     Stuart Ripley  24.0    Right Winger   \n",
       "6  Middlesbrough FC    Gary Parkinson  24.0      Right-Back   \n",
       "7  Middlesbrough FC     Bernie Slaven  31.0  Centre-Forward   \n",
       "8  Middlesbrough FC       Andy Payton  24.0          attack   \n",
       "9  Middlesbrough FC        Ian Arnold  20.0  Centre-Forward   \n",
       "\n",
       "  club_involved_name transfer_movement  fee_cleaned  year  \n",
       "0          Leicester                in         0.91  1992  \n",
       "1        Southampton                in         0.25  1992  \n",
       "2             Celtic                in         0.00  1992  \n",
       "3           Boro U18                in         0.00  1992  \n",
       "4           Boro U18                in         0.00  1992  \n",
       "5          Blackburn               out         2.00  1992  \n",
       "6    Southend United               out         0.00  1992  \n",
       "7          Port Vale               out         0.00  1992  \n",
       "8             Celtic               out         0.00  1992  \n",
       "9    Carlisle United               out         0.00  1992  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Substituindo os valores '-' or '?' por '0'.\n",
    "\n",
    "dados.fee_cleaned = dados.fee_cleaned.fillna(0)\n",
    "dados.drop(columns = ['transfer_period', 'league_name', 'fee', 'season'], axis = 1, inplace = True)\n",
    "dados.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f8dedf3c",
   "metadata": {},
   "source": [
    "## Liverpool FC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "3124e7f1",
   "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_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Paul Stewart</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>in</td>\n",
       "      <td>2.75</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>David James</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Watford</td>\n",
       "      <td>in</td>\n",
       "      <td>1.40</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Torben Piechnik</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>FC Copenhagen</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Dominic Matteo</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Liverpool U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Bruce Grobbelaar</td>\n",
       "      <td>35.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Stoke City</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22555</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Ozan Kabak</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>FC Schalke 04</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22885</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Luis Díaz</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>FC Porto</td>\n",
       "      <td>in</td>\n",
       "      <td>47.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22886</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Rhys Williams</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Swansea</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22887</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Nathaniel Phillips</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22888</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Neco Williams</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1051 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          club_name         player_name   age            position  \\\n",
       "255    Liverpool FC        Paul Stewart  27.0  Defensive Midfield   \n",
       "256    Liverpool FC         David James  21.0          Goalkeeper   \n",
       "257    Liverpool FC     Torben Piechnik  29.0         Centre-Back   \n",
       "258    Liverpool FC      Dominic Matteo  18.0           Left-Back   \n",
       "259    Liverpool FC    Bruce Grobbelaar  35.0          Goalkeeper   \n",
       "...             ...                 ...   ...                 ...   \n",
       "22555  Liverpool FC          Ozan Kabak  21.0         Centre-Back   \n",
       "22885  Liverpool FC           Luis Díaz  25.0         Left Winger   \n",
       "22886  Liverpool FC       Rhys Williams  20.0         Centre-Back   \n",
       "22887  Liverpool FC  Nathaniel Phillips  24.0         Centre-Back   \n",
       "22888  Liverpool FC       Neco Williams  20.0          Right-Back   \n",
       "\n",
       "      club_involved_name transfer_movement  fee_cleaned  year  \n",
       "255                Spurs                in         2.75  1992  \n",
       "256              Watford                in         1.40  1992  \n",
       "257        FC Copenhagen                in         0.00  1992  \n",
       "258        Liverpool U18                in         0.00  1992  \n",
       "259           Stoke City                in         0.00  1992  \n",
       "...                  ...               ...          ...   ...  \n",
       "22555      FC Schalke 04               out         0.00  2021  \n",
       "22885           FC Porto                in        47.00  2021  \n",
       "22886            Swansea                in         0.00  2021  \n",
       "22887        Bournemouth               out         0.00  2021  \n",
       "22888             Fulham               out         0.00  2021  \n",
       "\n",
       "[1051 rows x 8 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liverpool = ['Liverpool FC']\n",
    "selecao = dados['club_name'].isin(liverpool)\n",
    "liverpool_df = dados[selecao]\n",
    "liverpool_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "35b4bfe3",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Paul Stewart</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>in</td>\n",
       "      <td>2.75</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>David James</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Watford</td>\n",
       "      <td>in</td>\n",
       "      <td>1.40</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Torben Piechnik</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>FC Copenhagen</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Dominic Matteo</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Liverpool U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Bruce Grobbelaar</td>\n",
       "      <td>35.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Stoke City</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1046</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Ozan Kabak</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>FC Schalke 04</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Luis Díaz</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>FC Porto</td>\n",
       "      <td>in</td>\n",
       "      <td>47.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Rhys Williams</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Swansea</td>\n",
       "      <td>in</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Nathaniel Phillips</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Neco Williams</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>out</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1051 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         club_name         player_name   age            position  \\\n",
       "0     Liverpool FC        Paul Stewart  27.0  Defensive Midfield   \n",
       "1     Liverpool FC         David James  21.0          Goalkeeper   \n",
       "2     Liverpool FC     Torben Piechnik  29.0         Centre-Back   \n",
       "3     Liverpool FC      Dominic Matteo  18.0           Left-Back   \n",
       "4     Liverpool FC    Bruce Grobbelaar  35.0          Goalkeeper   \n",
       "...            ...                 ...   ...                 ...   \n",
       "1046  Liverpool FC          Ozan Kabak  21.0         Centre-Back   \n",
       "1047  Liverpool FC           Luis Díaz  25.0         Left Winger   \n",
       "1048  Liverpool FC       Rhys Williams  20.0         Centre-Back   \n",
       "1049  Liverpool FC  Nathaniel Phillips  24.0         Centre-Back   \n",
       "1050  Liverpool FC       Neco Williams  20.0          Right-Back   \n",
       "\n",
       "     club_involved_name transfer_movement  fee_cleaned  year  \n",
       "0                 Spurs                in         2.75  1992  \n",
       "1               Watford                in         1.40  1992  \n",
       "2         FC Copenhagen                in         0.00  1992  \n",
       "3         Liverpool U18                in         0.00  1992  \n",
       "4            Stoke City                in         0.00  1992  \n",
       "...                 ...               ...          ...   ...  \n",
       "1046      FC Schalke 04               out         0.00  2021  \n",
       "1047           FC Porto                in        47.00  2021  \n",
       "1048            Swansea                in         0.00  2021  \n",
       "1049        Bournemouth               out         0.00  2021  \n",
       "1050             Fulham               out         0.00  2021  \n",
       "\n",
       "[1051 rows x 8 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liverpool_df.index = range(liverpool_df.shape[0])\n",
    "liverpool_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "092c620d",
   "metadata": {},
   "outputs": [],
   "source": [
    "liverpool_df.to_csv('dados/liverpool/liverpool.csv', sep = ';', index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d1506e45",
   "metadata": {},
   "source": [
    "## Arsenal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "1606df05",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>John Jensen</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Bröndby IF</td>\n",
       "      <td>in</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Gary McKeown</td>\n",
       "      <td>21.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Shrewsbury</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Ian Selley</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Arsenal U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Alan Miller</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Birmingham</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Steve Morrow</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Barnet</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22815</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Sead Kolasinac</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22816</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Calum Chambers</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Aston Villa</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22817</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Pierre-Emerick Aubameyang</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22818</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Pablo Marí</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Udinese Calcio</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22819</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Auston Trusty</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>934 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        club_name                player_name   age          position  \\\n",
       "114    Arsenal FC                John Jensen  27.0  Central Midfield   \n",
       "115    Arsenal FC               Gary McKeown  21.0          midfield   \n",
       "116    Arsenal FC                 Ian Selley  18.0  Central Midfield   \n",
       "117    Arsenal FC                Alan Miller  23.0        Goalkeeper   \n",
       "118    Arsenal FC               Steve Morrow  21.0        Right-Back   \n",
       "...           ...                        ...   ...               ...   \n",
       "22815  Arsenal FC             Sead Kolasinac  28.0         Left-Back   \n",
       "22816  Arsenal FC             Calum Chambers  27.0       Centre-Back   \n",
       "22817  Arsenal FC  Pierre-Emerick Aubameyang  32.0    Centre-Forward   \n",
       "22818  Arsenal FC                 Pablo Marí  28.0       Centre-Back   \n",
       "22819  Arsenal FC              Auston Trusty  23.0       Centre-Back   \n",
       "\n",
       "      club_involved_name transfer_movement  fee_cleaned  year  \n",
       "114           Bröndby IF                in          1.6  1992  \n",
       "115           Shrewsbury                in          0.0  1992  \n",
       "116          Arsenal U18                in          0.0  1992  \n",
       "117           Birmingham                in          0.0  1992  \n",
       "118               Barnet                in          0.0  1992  \n",
       "...                  ...               ...          ...   ...  \n",
       "22815          Marseille               out          0.0  2021  \n",
       "22816        Aston Villa               out          0.0  2021  \n",
       "22817          Barcelona               out          0.0  2021  \n",
       "22818     Udinese Calcio               out          0.0  2021  \n",
       "22819           Colorado               out          0.0  2021  \n",
       "\n",
       "[934 rows x 8 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "arsenal = ['Arsenal FC']\n",
    "selecao = dados['club_name'].isin(arsenal)\n",
    "arsenal_df = dados[selecao]\n",
    "arsenal_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "d9ced73a",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>John Jensen</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Bröndby IF</td>\n",
       "      <td>in</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Gary McKeown</td>\n",
       "      <td>21.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Shrewsbury</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Ian Selley</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Arsenal U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Alan Miller</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Birmingham</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Steve Morrow</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Barnet</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>929</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Sead Kolasinac</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Calum Chambers</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Aston Villa</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>931</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Pierre-Emerick Aubameyang</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Pablo Marí</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Udinese Calcio</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933</th>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Auston Trusty</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>934 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      club_name                player_name   age          position  \\\n",
       "0    Arsenal FC                John Jensen  27.0  Central Midfield   \n",
       "1    Arsenal FC               Gary McKeown  21.0          midfield   \n",
       "2    Arsenal FC                 Ian Selley  18.0  Central Midfield   \n",
       "3    Arsenal FC                Alan Miller  23.0        Goalkeeper   \n",
       "4    Arsenal FC               Steve Morrow  21.0        Right-Back   \n",
       "..          ...                        ...   ...               ...   \n",
       "929  Arsenal FC             Sead Kolasinac  28.0         Left-Back   \n",
       "930  Arsenal FC             Calum Chambers  27.0       Centre-Back   \n",
       "931  Arsenal FC  Pierre-Emerick Aubameyang  32.0    Centre-Forward   \n",
       "932  Arsenal FC                 Pablo Marí  28.0       Centre-Back   \n",
       "933  Arsenal FC              Auston Trusty  23.0       Centre-Back   \n",
       "\n",
       "    club_involved_name transfer_movement  fee_cleaned  year  \n",
       "0           Bröndby IF                in          1.6  1992  \n",
       "1           Shrewsbury                in          0.0  1992  \n",
       "2          Arsenal U18                in          0.0  1992  \n",
       "3           Birmingham                in          0.0  1992  \n",
       "4               Barnet                in          0.0  1992  \n",
       "..                 ...               ...          ...   ...  \n",
       "929          Marseille               out          0.0  2021  \n",
       "930        Aston Villa               out          0.0  2021  \n",
       "931          Barcelona               out          0.0  2021  \n",
       "932     Udinese Calcio               out          0.0  2021  \n",
       "933           Colorado               out          0.0  2021  \n",
       "\n",
       "[934 rows x 8 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "arsenal_df.index = range(arsenal_df.shape[0])\n",
    "arsenal_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "4aefc76d",
   "metadata": {},
   "outputs": [],
   "source": [
    "arsenal_df.to_csv('dados/arsenal/arsenal.csv', sep = ';', index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1c1d558c",
   "metadata": {},
   "source": [
    "## Chelsea"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "06655a18",
   "metadata": {
    "scrolled": false
   },
   "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_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Nigel Spackman</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Rangers</td>\n",
       "      <td>in</td>\n",
       "      <td>0.600</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Anthony Barness</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Charlton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.525</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>David Hopkin</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Right Midfield</td>\n",
       "      <td>Morton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.450</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Mick Harford</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Luton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.350</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Mal Donaghy</td>\n",
       "      <td>34.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Man Utd</td>\n",
       "      <td>in</td>\n",
       "      <td>0.200</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22449</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Billy Gilmour</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Norwich</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22450</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Jamal Blackman</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Without Club</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22451</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Willy Caballero</td>\n",
       "      <td>39.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Without Club</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22865</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Kenedy</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Left Midfield</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22866</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Lewis Baker</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Stoke City</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1273 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        club_name      player_name   age          position club_involved_name  \\\n",
       "124    Chelsea FC   Nigel Spackman  31.0  Central Midfield            Rangers   \n",
       "125    Chelsea FC  Anthony Barness  19.0        Right-Back           Charlton   \n",
       "126    Chelsea FC     David Hopkin  22.0    Right Midfield             Morton   \n",
       "127    Chelsea FC     Mick Harford  33.0    Centre-Forward              Luton   \n",
       "128    Chelsea FC      Mal Donaghy  34.0         Left-Back            Man Utd   \n",
       "...           ...              ...   ...               ...                ...   \n",
       "22449  Chelsea FC    Billy Gilmour  20.0  Central Midfield            Norwich   \n",
       "22450  Chelsea FC   Jamal Blackman  27.0        Goalkeeper       Without Club   \n",
       "22451  Chelsea FC  Willy Caballero  39.0        Goalkeeper       Without Club   \n",
       "22865  Chelsea FC           Kenedy  25.0     Left Midfield           Flamengo   \n",
       "22866  Chelsea FC      Lewis Baker  26.0  Central Midfield         Stoke City   \n",
       "\n",
       "      transfer_movement  fee_cleaned  year  \n",
       "124                  in        0.600  1992  \n",
       "125                  in        0.525  1992  \n",
       "126                  in        0.450  1992  \n",
       "127                  in        0.350  1992  \n",
       "128                  in        0.200  1992  \n",
       "...                 ...          ...   ...  \n",
       "22449               out        0.000  2021  \n",
       "22450               out        0.000  2021  \n",
       "22451               out        0.000  2021  \n",
       "22865                in        0.000  2021  \n",
       "22866               out        0.000  2021  \n",
       "\n",
       "[1273 rows x 8 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chelsea = ['Chelsea FC']\n",
    "selecao = dados['club_name'].isin(chelsea)\n",
    "chelsea_df = dados[selecao]\n",
    "chelsea_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "d49766c8",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Nigel Spackman</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Rangers</td>\n",
       "      <td>in</td>\n",
       "      <td>0.600</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Anthony Barness</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Charlton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.525</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>David Hopkin</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Right Midfield</td>\n",
       "      <td>Morton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.450</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Mick Harford</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Luton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.350</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Mal Donaghy</td>\n",
       "      <td>34.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Man Utd</td>\n",
       "      <td>in</td>\n",
       "      <td>0.200</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1268</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Billy Gilmour</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Norwich</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1269</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Jamal Blackman</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Without Club</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1270</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Willy Caballero</td>\n",
       "      <td>39.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Without Club</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1271</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Kenedy</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Left Midfield</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1272</th>\n",
       "      <td>Chelsea FC</td>\n",
       "      <td>Lewis Baker</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Stoke City</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1273 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       club_name      player_name   age          position club_involved_name  \\\n",
       "0     Chelsea FC   Nigel Spackman  31.0  Central Midfield            Rangers   \n",
       "1     Chelsea FC  Anthony Barness  19.0        Right-Back           Charlton   \n",
       "2     Chelsea FC     David Hopkin  22.0    Right Midfield             Morton   \n",
       "3     Chelsea FC     Mick Harford  33.0    Centre-Forward              Luton   \n",
       "4     Chelsea FC      Mal Donaghy  34.0         Left-Back            Man Utd   \n",
       "...          ...              ...   ...               ...                ...   \n",
       "1268  Chelsea FC    Billy Gilmour  20.0  Central Midfield            Norwich   \n",
       "1269  Chelsea FC   Jamal Blackman  27.0        Goalkeeper       Without Club   \n",
       "1270  Chelsea FC  Willy Caballero  39.0        Goalkeeper       Without Club   \n",
       "1271  Chelsea FC           Kenedy  25.0     Left Midfield           Flamengo   \n",
       "1272  Chelsea FC      Lewis Baker  26.0  Central Midfield         Stoke City   \n",
       "\n",
       "     transfer_movement  fee_cleaned  year  \n",
       "0                   in        0.600  1992  \n",
       "1                   in        0.525  1992  \n",
       "2                   in        0.450  1992  \n",
       "3                   in        0.350  1992  \n",
       "4                   in        0.200  1992  \n",
       "...                ...          ...   ...  \n",
       "1268               out        0.000  2021  \n",
       "1269               out        0.000  2021  \n",
       "1270               out        0.000  2021  \n",
       "1271                in        0.000  2021  \n",
       "1272               out        0.000  2021  \n",
       "\n",
       "[1273 rows x 8 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chelsea_df.index = range(chelsea_df.shape[0])\n",
    "chelsea_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "37aa08e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "chelsea_df.to_csv('dados/chelsea/chelsea.csv', sep = ';', index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "64e39412",
   "metadata": {},
   "source": [
    "## Manchester City"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "60c9711e",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Rick Holden</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Left Midfield</td>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Terry Phelan</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Wimbledon FC</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Richard Edghill</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Man City U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Adrian Mike</td>\n",
       "      <td>18.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Man City U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>John Foster</td>\n",
       "      <td>18.0</td>\n",
       "      <td>defence</td>\n",
       "      <td>Man City U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22895</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Erik Palmer-Brown</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Troyes</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22896</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Philippe Sandler</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Feyenoord</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22897</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Patrick Roberts</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Sunderland</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22898</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Julián Álvarez</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>River Plate</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22899</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Luka Ilic</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Troyes</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1055 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             club_name        player_name   age            position  \\\n",
       "179    Manchester City        Rick Holden  27.0       Left Midfield   \n",
       "180    Manchester City       Terry Phelan  25.0           Left-Back   \n",
       "181    Manchester City    Richard Edghill  17.0          Right-Back   \n",
       "182    Manchester City        Adrian Mike  18.0              attack   \n",
       "183    Manchester City        John Foster  18.0             defence   \n",
       "...                ...                ...   ...                 ...   \n",
       "22895  Manchester City  Erik Palmer-Brown  24.0         Centre-Back   \n",
       "22896  Manchester City   Philippe Sandler  24.0         Centre-Back   \n",
       "22897  Manchester City    Patrick Roberts  24.0        Right Winger   \n",
       "22898  Manchester City     Julián Álvarez  22.0      Centre-Forward   \n",
       "22899  Manchester City          Luka Ilic  22.0  Attacking Midfield   \n",
       "\n",
       "      club_involved_name transfer_movement  fee_cleaned  year  \n",
       "179      Oldham Athletic                in          0.0  1992  \n",
       "180         Wimbledon FC                in          0.0  1992  \n",
       "181         Man City U18                in          0.0  1992  \n",
       "182         Man City U18                in          0.0  1992  \n",
       "183         Man City U18                in          0.0  1992  \n",
       "...                  ...               ...          ...   ...  \n",
       "22895             Troyes               out          0.0  2021  \n",
       "22896          Feyenoord               out          0.0  2021  \n",
       "22897         Sunderland               out          0.0  2021  \n",
       "22898        River Plate               out          0.0  2021  \n",
       "22899             Troyes               out          0.0  2021  \n",
       "\n",
       "[1055 rows x 8 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mancity = ['Manchester City']\n",
    "selecao = dados['club_name'].isin(mancity)\n",
    "mancity_df = dados[selecao]\n",
    "mancity_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "59c00748",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Rick Holden</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Left Midfield</td>\n",
       "      <td>Oldham Athletic</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Terry Phelan</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Left-Back</td>\n",
       "      <td>Wimbledon FC</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Richard Edghill</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Man City U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Adrian Mike</td>\n",
       "      <td>18.0</td>\n",
       "      <td>attack</td>\n",
       "      <td>Man City U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>John Foster</td>\n",
       "      <td>18.0</td>\n",
       "      <td>defence</td>\n",
       "      <td>Man City U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Erik Palmer-Brown</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Troyes</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Philippe Sandler</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Feyenoord</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Patrick Roberts</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Sunderland</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Julián Álvarez</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>River Plate</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>Manchester City</td>\n",
       "      <td>Luka Ilic</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Troyes</td>\n",
       "      <td>out</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1055 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            club_name        player_name   age            position  \\\n",
       "0     Manchester City        Rick Holden  27.0       Left Midfield   \n",
       "1     Manchester City       Terry Phelan  25.0           Left-Back   \n",
       "2     Manchester City    Richard Edghill  17.0          Right-Back   \n",
       "3     Manchester City        Adrian Mike  18.0              attack   \n",
       "4     Manchester City        John Foster  18.0             defence   \n",
       "...               ...                ...   ...                 ...   \n",
       "1050  Manchester City  Erik Palmer-Brown  24.0         Centre-Back   \n",
       "1051  Manchester City   Philippe Sandler  24.0         Centre-Back   \n",
       "1052  Manchester City    Patrick Roberts  24.0        Right Winger   \n",
       "1053  Manchester City     Julián Álvarez  22.0      Centre-Forward   \n",
       "1054  Manchester City          Luka Ilic  22.0  Attacking Midfield   \n",
       "\n",
       "     club_involved_name transfer_movement  fee_cleaned  year  \n",
       "0       Oldham Athletic                in          0.0  1992  \n",
       "1          Wimbledon FC                in          0.0  1992  \n",
       "2          Man City U18                in          0.0  1992  \n",
       "3          Man City U18                in          0.0  1992  \n",
       "4          Man City U18                in          0.0  1992  \n",
       "...                 ...               ...          ...   ...  \n",
       "1050             Troyes               out          0.0  2021  \n",
       "1051          Feyenoord               out          0.0  2021  \n",
       "1052         Sunderland               out          0.0  2021  \n",
       "1053        River Plate               out          0.0  2021  \n",
       "1054             Troyes               out          0.0  2021  \n",
       "\n",
       "[1055 rows x 8 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mancity_df.index = range(mancity_df.shape[0])\n",
    "mancity_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "9abf6ec4",
   "metadata": {},
   "outputs": [],
   "source": [
    "mancity_df.to_csv('dados/mancity/mancity.csv', sep = ';', index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ca11ac33",
   "metadata": {},
   "source": [
    "## Manchester United"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "8ba6eb3f",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Dion Dublin</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Cambridge Utd.</td>\n",
       "      <td>in</td>\n",
       "      <td>1.500</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Pat McGibbon</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Portadown</td>\n",
       "      <td>in</td>\n",
       "      <td>0.225</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Andy Arnott</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Gillingham FC</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Kevin Pilkington</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Man Utd U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Simon Davies</td>\n",
       "      <td>18.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Man Utd U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22900</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Axel Tuanzebe</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>SSC Napoli</td>\n",
       "      <td>out</td>\n",
       "      <td>0.600</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22901</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Teden Mengi</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Birmingham</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22902</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Anthony Martial</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Sevilla FC</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22903</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Amad Diallo</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Rangers</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22904</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Donny van de Beek</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Everton</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>980 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               club_name        player_name   age            position  \\\n",
       "68     Manchester United        Dion Dublin  23.0      Centre-Forward   \n",
       "69     Manchester United       Pat McGibbon  18.0         Centre-Back   \n",
       "70     Manchester United        Andy Arnott  18.0  Defensive Midfield   \n",
       "71     Manchester United   Kevin Pilkington  18.0          Goalkeeper   \n",
       "72     Manchester United       Simon Davies  18.0            midfield   \n",
       "...                  ...                ...   ...                 ...   \n",
       "22900  Manchester United      Axel Tuanzebe  24.0         Centre-Back   \n",
       "22901  Manchester United        Teden Mengi  19.0         Centre-Back   \n",
       "22902  Manchester United    Anthony Martial  26.0      Centre-Forward   \n",
       "22903  Manchester United        Amad Diallo  19.0        Right Winger   \n",
       "22904  Manchester United  Donny van de Beek  24.0    Central Midfield   \n",
       "\n",
       "      club_involved_name transfer_movement  fee_cleaned  year  \n",
       "68        Cambridge Utd.                in        1.500  1992  \n",
       "69             Portadown                in        0.225  1992  \n",
       "70         Gillingham FC                in        0.000  1992  \n",
       "71           Man Utd U18                in        0.000  1992  \n",
       "72           Man Utd U18                in        0.000  1992  \n",
       "...                  ...               ...          ...   ...  \n",
       "22900         SSC Napoli               out        0.600  2021  \n",
       "22901         Birmingham               out        0.000  2021  \n",
       "22902         Sevilla FC               out        0.000  2021  \n",
       "22903            Rangers               out        0.000  2021  \n",
       "22904            Everton               out        0.000  2021  \n",
       "\n",
       "[980 rows x 8 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "manutd = ['Manchester United']\n",
    "selecao = dados['club_name'].isin(manutd)\n",
    "manutd_df = dados[selecao]\n",
    "manutd_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "c2c830ef",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Dion Dublin</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Cambridge Utd.</td>\n",
       "      <td>in</td>\n",
       "      <td>1.500</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Pat McGibbon</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Portadown</td>\n",
       "      <td>in</td>\n",
       "      <td>0.225</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Andy Arnott</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "      <td>Gillingham FC</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Kevin Pilkington</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Man Utd U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Simon Davies</td>\n",
       "      <td>18.0</td>\n",
       "      <td>midfield</td>\n",
       "      <td>Man Utd U18</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Axel Tuanzebe</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>SSC Napoli</td>\n",
       "      <td>out</td>\n",
       "      <td>0.600</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Teden Mengi</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Birmingham</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Anthony Martial</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Sevilla FC</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Amad Diallo</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Rangers</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>Manchester United</td>\n",
       "      <td>Donny van de Beek</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Everton</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>980 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             club_name        player_name   age            position  \\\n",
       "0    Manchester United        Dion Dublin  23.0      Centre-Forward   \n",
       "1    Manchester United       Pat McGibbon  18.0         Centre-Back   \n",
       "2    Manchester United        Andy Arnott  18.0  Defensive Midfield   \n",
       "3    Manchester United   Kevin Pilkington  18.0          Goalkeeper   \n",
       "4    Manchester United       Simon Davies  18.0            midfield   \n",
       "..                 ...                ...   ...                 ...   \n",
       "975  Manchester United      Axel Tuanzebe  24.0         Centre-Back   \n",
       "976  Manchester United        Teden Mengi  19.0         Centre-Back   \n",
       "977  Manchester United    Anthony Martial  26.0      Centre-Forward   \n",
       "978  Manchester United        Amad Diallo  19.0        Right Winger   \n",
       "979  Manchester United  Donny van de Beek  24.0    Central Midfield   \n",
       "\n",
       "    club_involved_name transfer_movement  fee_cleaned  year  \n",
       "0       Cambridge Utd.                in        1.500  1992  \n",
       "1            Portadown                in        0.225  1992  \n",
       "2        Gillingham FC                in        0.000  1992  \n",
       "3          Man Utd U18                in        0.000  1992  \n",
       "4          Man Utd U18                in        0.000  1992  \n",
       "..                 ...               ...          ...   ...  \n",
       "975         SSC Napoli               out        0.600  2021  \n",
       "976         Birmingham               out        0.000  2021  \n",
       "977         Sevilla FC               out        0.000  2021  \n",
       "978            Rangers               out        0.000  2021  \n",
       "979            Everton               out        0.000  2021  \n",
       "\n",
       "[980 rows x 8 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "manutd_df.index = range(manutd_df.shape[0])\n",
    "manutd_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "ea020ad6",
   "metadata": {},
   "outputs": [],
   "source": [
    "manutd_df.to_csv('dados/manutd/manutd.csv', sep = ';', index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d41efa47",
   "metadata": {},
   "source": [
    "## Tottenham"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "a68ed539",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Teddy Sheringham</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Nottm Forest</td>\n",
       "      <td>in</td>\n",
       "      <td>3.150</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Darren Anderton</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Right Midfield</td>\n",
       "      <td>Portsmouth</td>\n",
       "      <td>in</td>\n",
       "      <td>2.700</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Jason Cundy</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>in</td>\n",
       "      <td>0.875</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Neil Ruddock</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.850</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Dean Austin</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Southend United</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22938</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Dele Alli</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Everton</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22939</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Jack Clarke</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Sunderland</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22940</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Bryan Gil</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22941</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Giovani Lo Celso</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22942</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Alfie Whiteman</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Degerfors</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1196 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               club_name       player_name   age            position  \\\n",
       "232    Tottenham Hotspur  Teddy Sheringham  26.0      Centre-Forward   \n",
       "233    Tottenham Hotspur   Darren Anderton  20.0      Right Midfield   \n",
       "234    Tottenham Hotspur       Jason Cundy  22.0         Centre-Back   \n",
       "235    Tottenham Hotspur      Neil Ruddock  24.0         Centre-Back   \n",
       "236    Tottenham Hotspur       Dean Austin  22.0          Right-Back   \n",
       "...                  ...               ...   ...                 ...   \n",
       "22938  Tottenham Hotspur         Dele Alli  25.0  Attacking Midfield   \n",
       "22939  Tottenham Hotspur       Jack Clarke  21.0        Right Winger   \n",
       "22940  Tottenham Hotspur         Bryan Gil  20.0         Left Winger   \n",
       "22941  Tottenham Hotspur  Giovani Lo Celso  25.0    Central Midfield   \n",
       "22942  Tottenham Hotspur    Alfie Whiteman  23.0          Goalkeeper   \n",
       "\n",
       "      club_involved_name transfer_movement  fee_cleaned  year  \n",
       "232         Nottm Forest                in        3.150  1992  \n",
       "233           Portsmouth                in        2.700  1992  \n",
       "234              Chelsea                in        0.875  1992  \n",
       "235          Southampton                in        0.850  1992  \n",
       "236      Southend United                in        0.000  1992  \n",
       "...                  ...               ...          ...   ...  \n",
       "22938            Everton               out        0.000  2021  \n",
       "22939         Sunderland               out        0.000  2021  \n",
       "22940           Valencia               out        0.000  2021  \n",
       "22941         Villarreal               out        0.000  2021  \n",
       "22942          Degerfors               out        0.000  2021  \n",
       "\n",
       "[1196 rows x 8 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tottenham = ['Tottenham Hotspur']\n",
    "selecao = dados['club_name'].isin(tottenham)\n",
    "tottenham_df = dados[selecao]\n",
    "tottenham_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "d7cf6315",
   "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>club_name</th>\n",
       "      <th>player_name</th>\n",
       "      <th>age</th>\n",
       "      <th>position</th>\n",
       "      <th>club_involved_name</th>\n",
       "      <th>transfer_movement</th>\n",
       "      <th>fee_cleaned</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Teddy Sheringham</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Centre-Forward</td>\n",
       "      <td>Nottm Forest</td>\n",
       "      <td>in</td>\n",
       "      <td>3.150</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Darren Anderton</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Right Midfield</td>\n",
       "      <td>Portsmouth</td>\n",
       "      <td>in</td>\n",
       "      <td>2.700</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Jason Cundy</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>in</td>\n",
       "      <td>0.875</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Neil Ruddock</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Centre-Back</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>in</td>\n",
       "      <td>0.850</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Dean Austin</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Right-Back</td>\n",
       "      <td>Southend United</td>\n",
       "      <td>in</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1992</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1191</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Dele Alli</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "      <td>Everton</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1192</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Jack Clarke</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Right Winger</td>\n",
       "      <td>Sunderland</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1193</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Bryan Gil</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Left Winger</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1194</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Giovani Lo Celso</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Central Midfield</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1195</th>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>Alfie Whiteman</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Goalkeeper</td>\n",
       "      <td>Degerfors</td>\n",
       "      <td>out</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1196 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              club_name       player_name   age            position  \\\n",
       "0     Tottenham Hotspur  Teddy Sheringham  26.0      Centre-Forward   \n",
       "1     Tottenham Hotspur   Darren Anderton  20.0      Right Midfield   \n",
       "2     Tottenham Hotspur       Jason Cundy  22.0         Centre-Back   \n",
       "3     Tottenham Hotspur      Neil Ruddock  24.0         Centre-Back   \n",
       "4     Tottenham Hotspur       Dean Austin  22.0          Right-Back   \n",
       "...                 ...               ...   ...                 ...   \n",
       "1191  Tottenham Hotspur         Dele Alli  25.0  Attacking Midfield   \n",
       "1192  Tottenham Hotspur       Jack Clarke  21.0        Right Winger   \n",
       "1193  Tottenham Hotspur         Bryan Gil  20.0         Left Winger   \n",
       "1194  Tottenham Hotspur  Giovani Lo Celso  25.0    Central Midfield   \n",
       "1195  Tottenham Hotspur    Alfie Whiteman  23.0          Goalkeeper   \n",
       "\n",
       "     club_involved_name transfer_movement  fee_cleaned  year  \n",
       "0          Nottm Forest                in        3.150  1992  \n",
       "1            Portsmouth                in        2.700  1992  \n",
       "2               Chelsea                in        0.875  1992  \n",
       "3           Southampton                in        0.850  1992  \n",
       "4       Southend United                in        0.000  1992  \n",
       "...                 ...               ...          ...   ...  \n",
       "1191            Everton               out        0.000  2021  \n",
       "1192         Sunderland               out        0.000  2021  \n",
       "1193           Valencia               out        0.000  2021  \n",
       "1194         Villarreal               out        0.000  2021  \n",
       "1195          Degerfors               out        0.000  2021  \n",
       "\n",
       "[1196 rows x 8 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tottenham_df.index = range(tottenham_df.shape[0])\n",
    "tottenham_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "2835cffa",
   "metadata": {},
   "outputs": [],
   "source": [
    "tottenham_df.to_csv('dados/tottenham/tottenham.csv', sep = ';', index = False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}