DF_creation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Position</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Brenden Aaronson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Paxten Aaronson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>James Abankwah</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Centre-Back</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>George Abbott</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Series([], Name: TmPos, dtype: object)']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Yunis Abdelhamid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Centre-Back</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2714</th>\n",
       "      <td>Martin Ødegaard</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2715</th>\n",
       "      <td>Milan Đurić</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Centre-Forward</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2716</th>\n",
       "      <td>Filip Đuričić</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Attacking Midfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2717</th>\n",
       "      <td>Blanco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718</th>\n",
       "      <td>Hugo Guillamón</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Defensive Midfield</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2719 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player  Unnamed: 1                                    Position\n",
       "0     Brenden Aaronson         NaN                          Attacking Midfield\n",
       "1      Paxten Aaronson         NaN                          Attacking Midfield\n",
       "2       James Abankwah         NaN                                 Centre-Back\n",
       "3        George Abbott         NaN  ['Series([], Name: TmPos, dtype: object)']\n",
       "4     Yunis Abdelhamid         NaN                                 Centre-Back\n",
       "...                ...         ...                                         ...\n",
       "2714   Martin Ødegaard         NaN                          Attacking Midfield\n",
       "2715       Milan Đurić         NaN                              Centre-Forward\n",
       "2716     Filip Đuričić         NaN                          Attacking Midfield\n",
       "2717            Blanco         NaN                          Defensive Midfield\n",
       "2718    Hugo Guillamón         NaN                          Defensive Midfield\n",
       "\n",
       "[2719 rows x 3 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ps = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\position.csv\")\n",
    "ps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "ps['Position'] = ps['Position'].str.strip().str.lower()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "centre-back                                   487\n",
       "central midfield                              365\n",
       "centre-forward                                359\n",
       "right-back                                    233\n",
       "defensive midfield                            212\n",
       "left-back                                     208\n",
       "goalkeeper                                    197\n",
       "right winger                                  189\n",
       "left winger                                   186\n",
       "attacking midfield                            179\n",
       "['series([], name: tmpos, dtype: object)']     47\n",
       "second striker                                 29\n",
       "left wingback                                  13\n",
       "right wingback                                  8\n",
       "right midfield                                  2\n",
       "attack                                          2\n",
       "midfield                                        1\n",
       "Name: Position, dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ps[\"Position\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "shooting_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\shooting.csv\")\n",
    "stats_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\stats.csv\")\n",
    "keepersadv_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\keepersadv.csv\")\n",
    "possession_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\possession.csv\")\n",
    "passing_types_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\passing_types.csv\")\n",
    "passing_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\passing.csv\")\n",
    "misc_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\misc.csv\")\n",
    "keepers_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\keepers.csv\")\n",
    "gca_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\gca.csv\")\n",
    "defense_df = pd.read_csv(r\"E:\\2nd year\\3rd sem\\Data science\\Project\\Web scrapping\\Final Data\\defense.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Columns of 'shooting_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'SGls', 'SSh', 'SSoT', 'SSoTp', 'SSh_p90', 'SSoT_90', 'SG_Sh', 'SG_SoT',\n",
      "       'SFK', 'SPK', 'SPKatt', 'xG', 'npxG', 'npxG/Sh', 'G-xG', 'npG-xG',\n",
      "       'SDist'],\n",
      "      dtype='object')\n",
      "Columns of 'stats_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', 'MP',\n",
      "       'Starts', 'Min', '90s', 'Gls', 'Ast', 'GA', 'npg', 'PK', 'PKatt',\n",
      "       'CrdY', 'CrdR', 'xG', 'NPxG', 'xAG', 'NPxG+xAG', 'PrgC', 'PrgP', 'PrgR',\n",
      "       'Gls_p90', 'Ast_p90', 'GA_p90', 'npg_p90', 'npG+A_p90', 'xG_p90',\n",
      "       'xAG_p90', 'xG+xAG_p90', 'NPxG_p90', 'NPxG+xAG_p90', 'Unnamed: 37'],\n",
      "      dtype='object')\n",
      "Columns of 'keepersadv_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'GA', 'PKA', 'FK', 'CK', 'OG', 'PSxG', 'PSxG/SoT', 'PSxG-GA',\n",
      "       'PSxG-GA_p90', 'LCmp', 'LAtt', 'LCmp%', 'PaAtt', 'PaThr', 'PaAvgLen',\n",
      "       'GKAtt', 'GKLp', 'GKAvgLen', 'COpp', 'CStp', 'CStpp', 'SwOPA',\n",
      "       'SwOPA_p90', 'SwAvgDist'],\n",
      "      dtype='object')\n",
      "Columns of 'keepers_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', 'MP',\n",
      "       'Starts', 'Min', '90s', 'GA', 'GA_p90', 'SoTA', 'Saves', 'Savep', 'W',\n",
      "       'D', 'L', 'CS', 'CSp', 'PKatt', 'PKA', 'PKsv', 'PKm', 'PKSp'],\n",
      "      dtype='object')\n",
      "Columns of 'possession_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'Touches', 'Def_Pen', 'Def_3rd', 'Mid_3rd', 'Att_3rd', 'Att_Pen',\n",
      "       'Live', 'TOAtt', 'TOSucc', 'TOSuccp', 'TOTkld', 'TOTkldp', 'Carries',\n",
      "       'CaTotDist', 'CaPrgDist', 'CaPrgC', 'CaFTC', 'CaCPA', 'CaMis', 'CaDis',\n",
      "       'Rec', 'PrgR'],\n",
      "      dtype='object')\n",
      "Columns of 'passing_types_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'Att', 'PTLive', 'PTDead', 'PTFK', 'PTTB', 'PTSw', 'PTCrs', 'PTTI',\n",
      "       'PTCK', 'CKIn', 'CKOut', 'CKStr', 'OCmp', 'OOff', 'OBlocks'],\n",
      "      dtype='object')\n",
      "Columns of 'passing_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'TCmp', 'TAtt', 'TCmpp', 'TTD', 'TPD', 'SCmp', 'SAtt', 'SCmpp', 'MCmp',\n",
      "       'MAtt', 'MCmpp', 'LCmp', 'LAtt', 'LCmpp', 'LAst', 'LxAG', 'LxA',\n",
      "       'LAxAG', 'LKP', 'LFTP', 'LPPA', 'LCrsPA', 'LPrgP'],\n",
      "      dtype='object')\n",
      "Columns of 'misc_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'CrdY', 'CrdR', '2CrdY', 'Fls', 'Fld', 'Off', 'Crs', 'Int', 'TklW',\n",
      "       'PKwon', 'PKcon', 'OG', 'Recov', 'ADWon', 'ADLost', 'ADWonp'],\n",
      "      dtype='object')\n",
      "Columns of 'gca_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'SCA', 'SCA90', 'SCAPL', 'SCAPD', 'SCATO', 'SCASh', 'SCAFld', 'SCADef',\n",
      "       'GCA', 'GCA90', 'GCAPL', 'GCAPD', 'GCATO', 'GCASh', 'GCAFld', 'GCADef'],\n",
      "      dtype='object')\n",
      "Columns of 'defense_df': Index(['Rk', 'Player', 'Nation', 'Pos', 'Squad', 'Comp', 'Age', 'Born', '90s',\n",
      "       'Tkl', 'TklW', 'Def_3rd', 'Mid_3rd', 'Att_3rd', 'CTkl', 'CAtt', 'CTkl%',\n",
      "       'CLost', 'Blocks', 'BSh', 'BPass', 'BInt', 'BTklInt', 'BClr', 'BErr'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "# Print the columns of each DataFrame\n",
    "print(\"Columns of 'shooting_df':\", shooting_df.columns)\n",
    "print(\"Columns of 'stats_df':\", stats_df.columns)\n",
    "print(\"Columns of 'keepersadv_df':\", keepersadv_df.columns)\n",
    "print(\"Columns of 'keepers_df':\", keepers_df.columns)\n",
    "print(\"Columns of 'possession_df':\", possession_df.columns)\n",
    "print(\"Columns of 'passing_types_df':\", passing_types_df.columns)\n",
    "print(\"Columns of 'passing_df':\", passing_df.columns)\n",
    "print(\"Columns of 'misc_df':\", misc_df.columns)\n",
    "print(\"Columns of 'gca_df':\", gca_df.columns)\n",
    "print(\"Columns of 'defense_df':\", defense_df.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Nation</th>\n",
       "      <th>Squad</th>\n",
       "      <th>MP</th>\n",
       "      <th>Min</th>\n",
       "      <th>Gls</th>\n",
       "      <th>Ast</th>\n",
       "      <th>xG</th>\n",
       "      <th>NPxG+xAG</th>\n",
       "      <th>xAG</th>\n",
       "      <th>...</th>\n",
       "      <th>LFTP</th>\n",
       "      <th>LCrsPA</th>\n",
       "      <th>LPrgP</th>\n",
       "      <th>SCA</th>\n",
       "      <th>GCA</th>\n",
       "      <th>BInt</th>\n",
       "      <th>BTklInt</th>\n",
       "      <th>BClr</th>\n",
       "      <th>CTkl</th>\n",
       "      <th>TOSucc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Brenden Aaronson</td>\n",
       "      <td>USA</td>\n",
       "      <td>Leeds United</td>\n",
       "      <td>36</td>\n",
       "      <td>2372</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3.9</td>\n",
       "      <td>8.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>4</td>\n",
       "      <td>86</td>\n",
       "      <td>95</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>50</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Paxten Aaronson</td>\n",
       "      <td>USA</td>\n",
       "      <td>Eint Frankfurt</td>\n",
       "      <td>7</td>\n",
       "      <td>173</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>James Abankwah</td>\n",
       "      <td>IRL</td>\n",
       "      <td>Udinese</td>\n",
       "      <td>2</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>George Abbott</td>\n",
       "      <td>ENG</td>\n",
       "      <td>Tottenham</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Yunis Abdelhamid</td>\n",
       "      <td>MAR</td>\n",
       "      <td>Reims</td>\n",
       "      <td>37</td>\n",
       "      <td>3330</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>155</td>\n",
       "      <td>0</td>\n",
       "      <td>215</td>\n",
       "      <td>43</td>\n",
       "      <td>7</td>\n",
       "      <td>64</td>\n",
       "      <td>146</td>\n",
       "      <td>116</td>\n",
       "      <td>39</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5005</th>\n",
       "      <td>Martin Ødegaard</td>\n",
       "      <td>NOR</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>37</td>\n",
       "      <td>3127</td>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>18.1</td>\n",
       "      <td>8.1</td>\n",
       "      <td>...</td>\n",
       "      <td>135</td>\n",
       "      <td>4</td>\n",
       "      <td>266</td>\n",
       "      <td>163</td>\n",
       "      <td>17</td>\n",
       "      <td>6</td>\n",
       "      <td>42</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5006</th>\n",
       "      <td>Milan Đurić</td>\n",
       "      <td>BIH</td>\n",
       "      <td>Hellas Verona</td>\n",
       "      <td>28</td>\n",
       "      <td>1366</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>36</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5007</th>\n",
       "      <td>Filip Đuričić</td>\n",
       "      <td>SRB</td>\n",
       "      <td>Sampdoria</td>\n",
       "      <td>32</td>\n",
       "      <td>2171</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.6</td>\n",
       "      <td>1.9</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>77</td>\n",
       "      <td>69</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5008</th>\n",
       "      <td>Blanco</td>\n",
       "      <td>0</td>\n",
       "      <td>Cádiz</td>\n",
       "      <td>3</td>\n",
       "      <td>158</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5009</th>\n",
       "      <td>Hugo Guillamón</td>\n",
       "      <td>0</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>25</td>\n",
       "      <td>1632</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5010 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player Nation           Squad  MP   Min  Gls  Ast    xG  \\\n",
       "0     Brenden Aaronson    USA    Leeds United  36  2372    1    3   3.9   \n",
       "1      Paxten Aaronson    USA  Eint Frankfurt   7   173    0    0   0.2   \n",
       "2       James Abankwah    IRL         Udinese   2    63    0    0   0.0   \n",
       "3        George Abbott    ENG       Tottenham   1     1    0    0   0.0   \n",
       "4     Yunis Abdelhamid    MAR           Reims  37  3330    1    2   2.4   \n",
       "...                ...    ...             ...  ..   ...  ...  ...   ...   \n",
       "5005   Martin Ødegaard    NOR         Arsenal  37  3127   15    7  10.0   \n",
       "5006       Milan Đurić    BIH   Hellas Verona  28  1366    1    1   1.4   \n",
       "5007     Filip Đuričić    SRB       Sampdoria  32  2171    3    0   2.7   \n",
       "5008            Blanco      0           Cádiz   3   158    0    0   0.0   \n",
       "5009    Hugo Guillamón      0        Valencia  25  1632    1    4   0.0   \n",
       "\n",
       "      NPxG+xAG  xAG  ...  LFTP  LCrsPA  LPrgP  SCA  GCA  BInt  BTklInt  BClr  \\\n",
       "0          8.1  4.2  ...    47       4     86   95    7     5       50     6   \n",
       "1          0.2  0.0  ...     3       0      6    8    2     0        6     2   \n",
       "2          0.0  0.0  ...     0       0      0    0    0     0        1     5   \n",
       "3          0.0  0.0  ...     0       0      0    0    0     1        1     0   \n",
       "4          3.4  1.0  ...   155       0    215   43    7    64      146   116   \n",
       "...        ...  ...  ...   ...     ...    ...  ...  ...   ...      ...   ...   \n",
       "5005      18.1  8.1  ...   135       4    266  163   17     6       42    12   \n",
       "5006       2.7  1.3  ...    27       0     29   36    2     1        3    24   \n",
       "5007       4.6  1.9  ...    50       4     77   69    3     7       50     8   \n",
       "5008       0.0  0.0  ...     0       0      0    0    0     1        0     0   \n",
       "5009       0.0  0.0  ...     0       0      0    0    0    19        0     0   \n",
       "\n",
       "      CTkl  TOSucc  \n",
       "0       15      34  \n",
       "1        2       3  \n",
       "2        0       1  \n",
       "3        0       0  \n",
       "4       39      21  \n",
       "...    ...     ...  \n",
       "5005    14      48  \n",
       "5006     1       2  \n",
       "5007    14      31  \n",
       "5008     0       0  \n",
       "5009     0       0  \n",
       "\n",
       "[5010 rows x 33 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_charts = misc_df[['Player']]\n",
    "top_charts = top_charts.merge(stats_df[['Player','Nation','Squad','MP','Min','Gls','Ast','xG','NPxG+xAG','xAG']], on='Player', how='left')\n",
    "top_charts = top_charts.merge(keepers_df[['Player','Saves','CS' ]], on='Player', how='left')\n",
    "top_charts = top_charts.merge(keepersadv_df[['Player','CStp', 'SwOPA']], on='Player', how='left')\n",
    "top_charts = top_charts.merge(misc_df[['Player', 'CrdY', 'CrdR', 'Off','ADWon']], on='Player', how='left')\n",
    "top_charts = top_charts.merge(shooting_df[['Player','SSh', 'SSoT','SG_SoT']], on='Player', how='left')\n",
    "top_charts = top_charts.merge(passing_df[['Player','TCmp','LCmpp','LFTP','LCrsPA', 'LPrgP',]], on='Player', how='left')\n",
    "top_charts = top_charts.merge(gca_df[['Player','SCA','GCA' ]], on='Player', how='left')\n",
    "top_charts = top_charts.merge(defense_df[['Player','BInt', 'BTklInt', 'BClr','CTkl']], on='Player', how='left')\n",
    "top_charts = top_charts.merge(possession_df[['Player','TOSucc' ]], on='Player', how='left')\n",
    "top_charts.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "top_charts.fillna(0, inplace=True)\n",
    "\n",
    "top_charts.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\Topping_the_charts.csv')\n",
    "top_charts\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Player', 'Position', '90s', 'xAG', 'NPxG', 'LPPA', 'LPrgP', 'LKP',\n",
       "       'LxA', 'LFTP', 'CaCPA', 'Att_Pen', 'Mid_3rd', 'Att_3rd', 'Live',\n",
       "       'npxG/Sh', 'SSh', 'SSoT', 'SDist', 'ADWon', 'ADWonp', 'Off'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strikers_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>90s</th>\n",
       "      <th>xAG</th>\n",
       "      <th>NPxG</th>\n",
       "      <th>LPPA</th>\n",
       "      <th>LPrgP</th>\n",
       "      <th>LKP</th>\n",
       "      <th>LxA</th>\n",
       "      <th>LFTP</th>\n",
       "      <th>...</th>\n",
       "      <th>Mid_3rd</th>\n",
       "      <th>Att_3rd</th>\n",
       "      <th>Live</th>\n",
       "      <th>npxG/Sh</th>\n",
       "      <th>SSh</th>\n",
       "      <th>SSoT</th>\n",
       "      <th>SDist</th>\n",
       "      <th>ADWon</th>\n",
       "      <th>ADWonp</th>\n",
       "      <th>Off</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Matthis Abline</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>10.20000000</td>\n",
       "      <td>0.09803922</td>\n",
       "      <td>0.27450980</td>\n",
       "      <td>0.39215686</td>\n",
       "      <td>0.98039216</td>\n",
       "      <td>0.68627451</td>\n",
       "      <td>0.04901961</td>\n",
       "      <td>0.78431373</td>\n",
       "      <td>...</td>\n",
       "      <td>11.37254902</td>\n",
       "      <td>12.25490196</td>\n",
       "      <td>24.01960784</td>\n",
       "      <td>0.27450980</td>\n",
       "      <td>2.94117647</td>\n",
       "      <td>0.98039216</td>\n",
       "      <td>-0.07843137</td>\n",
       "      <td>1.27450980</td>\n",
       "      <td>2.71172299</td>\n",
       "      <td>0.58823529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tammy Abraham</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>24.30000000</td>\n",
       "      <td>0.14814815</td>\n",
       "      <td>0.44444444</td>\n",
       "      <td>0.69958848</td>\n",
       "      <td>2.22222222</td>\n",
       "      <td>1.35802469</td>\n",
       "      <td>0.11522634</td>\n",
       "      <td>0.74074074</td>\n",
       "      <td>...</td>\n",
       "      <td>16.09053498</td>\n",
       "      <td>14.60905350</td>\n",
       "      <td>32.34567901</td>\n",
       "      <td>0.44444444</td>\n",
       "      <td>2.55144033</td>\n",
       "      <td>1.15226337</td>\n",
       "      <td>-0.11522634</td>\n",
       "      <td>3.29218107</td>\n",
       "      <td>2.13777992</td>\n",
       "      <td>0.45267490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Che Adams</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>22.10000000</td>\n",
       "      <td>0.12669683</td>\n",
       "      <td>0.29864253</td>\n",
       "      <td>0.49773756</td>\n",
       "      <td>1.53846154</td>\n",
       "      <td>1.08597285</td>\n",
       "      <td>0.09954751</td>\n",
       "      <td>0.95022624</td>\n",
       "      <td>...</td>\n",
       "      <td>12.94117647</td>\n",
       "      <td>17.05882353</td>\n",
       "      <td>32.44343891</td>\n",
       "      <td>0.29864253</td>\n",
       "      <td>2.12669683</td>\n",
       "      <td>0.63348416</td>\n",
       "      <td>-0.07239819</td>\n",
       "      <td>2.76018100</td>\n",
       "      <td>1.68303719</td>\n",
       "      <td>0.63348416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sargis Adamyan</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>7.20000000</td>\n",
       "      <td>0.11111111</td>\n",
       "      <td>0.47222222</td>\n",
       "      <td>1.52777778</td>\n",
       "      <td>3.33333333</td>\n",
       "      <td>1.11111111</td>\n",
       "      <td>0.19444444</td>\n",
       "      <td>0.97222222</td>\n",
       "      <td>...</td>\n",
       "      <td>18.61111111</td>\n",
       "      <td>20.41666667</td>\n",
       "      <td>43.05555556</td>\n",
       "      <td>0.47222222</td>\n",
       "      <td>2.91666667</td>\n",
       "      <td>1.52777778</td>\n",
       "      <td>-0.33333333</td>\n",
       "      <td>1.66666667</td>\n",
       "      <td>4.50450450</td>\n",
       "      <td>0.55555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Karim Adeyemi</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>15.40000000</td>\n",
       "      <td>0.24025974</td>\n",
       "      <td>0.27922078</td>\n",
       "      <td>1.62337662</td>\n",
       "      <td>3.05194805</td>\n",
       "      <td>1.81818182</td>\n",
       "      <td>0.24025974</td>\n",
       "      <td>1.10389610</td>\n",
       "      <td>...</td>\n",
       "      <td>15.58441558</td>\n",
       "      <td>24.93506494</td>\n",
       "      <td>43.83116883</td>\n",
       "      <td>0.27922078</td>\n",
       "      <td>2.40259740</td>\n",
       "      <td>0.90909091</td>\n",
       "      <td>0.11038961</td>\n",
       "      <td>0.64935065</td>\n",
       "      <td>4.63821892</td>\n",
       "      <td>0.06493506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>Kelvin Yeboah</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>3.90000000</td>\n",
       "      <td>0.10256410</td>\n",
       "      <td>0.35897436</td>\n",
       "      <td>0.76923077</td>\n",
       "      <td>1.53846154</td>\n",
       "      <td>1.28205128</td>\n",
       "      <td>0.12820513</td>\n",
       "      <td>1.02564103</td>\n",
       "      <td>...</td>\n",
       "      <td>12.05128205</td>\n",
       "      <td>21.02564103</td>\n",
       "      <td>35.64102564</td>\n",
       "      <td>0.35897436</td>\n",
       "      <td>3.33333333</td>\n",
       "      <td>0.51282051</td>\n",
       "      <td>-0.10256410</td>\n",
       "      <td>3.58974359</td>\n",
       "      <td>9.97150997</td>\n",
       "      <td>0.25641026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>Duván Zapata</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>15.40000000</td>\n",
       "      <td>0.07142857</td>\n",
       "      <td>0.25324675</td>\n",
       "      <td>0.90909091</td>\n",
       "      <td>2.59740260</td>\n",
       "      <td>1.10389610</td>\n",
       "      <td>0.07792208</td>\n",
       "      <td>1.23376623</td>\n",
       "      <td>...</td>\n",
       "      <td>16.36363636</td>\n",
       "      <td>20.71428571</td>\n",
       "      <td>38.76623377</td>\n",
       "      <td>0.25324675</td>\n",
       "      <td>2.66233766</td>\n",
       "      <td>0.51948052</td>\n",
       "      <td>-0.12337662</td>\n",
       "      <td>2.72727273</td>\n",
       "      <td>3.20855615</td>\n",
       "      <td>0.45454545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>Joshua Zirkzee</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>9.10000000</td>\n",
       "      <td>0.15384615</td>\n",
       "      <td>0.34065934</td>\n",
       "      <td>0.65934066</td>\n",
       "      <td>1.86813187</td>\n",
       "      <td>1.75824176</td>\n",
       "      <td>0.05494505</td>\n",
       "      <td>1.31868132</td>\n",
       "      <td>...</td>\n",
       "      <td>19.45054945</td>\n",
       "      <td>20.32967033</td>\n",
       "      <td>41.64835165</td>\n",
       "      <td>0.34065934</td>\n",
       "      <td>3.18681319</td>\n",
       "      <td>0.87912088</td>\n",
       "      <td>-0.12087912</td>\n",
       "      <td>1.31868132</td>\n",
       "      <td>3.56400356</td>\n",
       "      <td>0.21978022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>Simon Zoller</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>16.20000000</td>\n",
       "      <td>0.06790123</td>\n",
       "      <td>0.25308642</td>\n",
       "      <td>0.24691358</td>\n",
       "      <td>1.29629630</td>\n",
       "      <td>0.55555556</td>\n",
       "      <td>0.03086420</td>\n",
       "      <td>0.98765432</td>\n",
       "      <td>...</td>\n",
       "      <td>13.45679012</td>\n",
       "      <td>11.17283951</td>\n",
       "      <td>28.39506173</td>\n",
       "      <td>0.25308642</td>\n",
       "      <td>1.85185185</td>\n",
       "      <td>0.55555556</td>\n",
       "      <td>-0.06790123</td>\n",
       "      <td>0.92592593</td>\n",
       "      <td>2.64550265</td>\n",
       "      <td>0.43209877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>Milan Đurić</td>\n",
       "      <td>centre-forward</td>\n",
       "      <td>15.20000000</td>\n",
       "      <td>0.08552632</td>\n",
       "      <td>0.09210526</td>\n",
       "      <td>0.32894737</td>\n",
       "      <td>1.90789474</td>\n",
       "      <td>1.38157895</td>\n",
       "      <td>0.05921053</td>\n",
       "      <td>1.77631579</td>\n",
       "      <td>...</td>\n",
       "      <td>20.65789474</td>\n",
       "      <td>17.76315789</td>\n",
       "      <td>42.36842105</td>\n",
       "      <td>0.09210526</td>\n",
       "      <td>1.05263158</td>\n",
       "      <td>0.32894737</td>\n",
       "      <td>-0.02631579</td>\n",
       "      <td>12.96052632</td>\n",
       "      <td>5.10256942</td>\n",
       "      <td>0.32894737</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>388 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Player        Position         90s        xAG       NPxG  \\\n",
       "0    Matthis Abline  centre-forward 10.20000000 0.09803922 0.27450980   \n",
       "1     Tammy Abraham  centre-forward 24.30000000 0.14814815 0.44444444   \n",
       "2         Che Adams  centre-forward 22.10000000 0.12669683 0.29864253   \n",
       "3    Sargis Adamyan  centre-forward  7.20000000 0.11111111 0.47222222   \n",
       "4     Karim Adeyemi  centre-forward 15.40000000 0.24025974 0.27922078   \n",
       "..              ...             ...         ...        ...        ...   \n",
       "383   Kelvin Yeboah  centre-forward  3.90000000 0.10256410 0.35897436   \n",
       "384    Duván Zapata  centre-forward 15.40000000 0.07142857 0.25324675   \n",
       "385  Joshua Zirkzee  centre-forward  9.10000000 0.15384615 0.34065934   \n",
       "386    Simon Zoller  centre-forward 16.20000000 0.06790123 0.25308642   \n",
       "387     Milan Đurić  centre-forward 15.20000000 0.08552632 0.09210526   \n",
       "\n",
       "          LPPA      LPrgP        LKP        LxA       LFTP  ...     Mid_3rd  \\\n",
       "0   0.39215686 0.98039216 0.68627451 0.04901961 0.78431373  ... 11.37254902   \n",
       "1   0.69958848 2.22222222 1.35802469 0.11522634 0.74074074  ... 16.09053498   \n",
       "2   0.49773756 1.53846154 1.08597285 0.09954751 0.95022624  ... 12.94117647   \n",
       "3   1.52777778 3.33333333 1.11111111 0.19444444 0.97222222  ... 18.61111111   \n",
       "4   1.62337662 3.05194805 1.81818182 0.24025974 1.10389610  ... 15.58441558   \n",
       "..         ...        ...        ...        ...        ...  ...         ...   \n",
       "383 0.76923077 1.53846154 1.28205128 0.12820513 1.02564103  ... 12.05128205   \n",
       "384 0.90909091 2.59740260 1.10389610 0.07792208 1.23376623  ... 16.36363636   \n",
       "385 0.65934066 1.86813187 1.75824176 0.05494505 1.31868132  ... 19.45054945   \n",
       "386 0.24691358 1.29629630 0.55555556 0.03086420 0.98765432  ... 13.45679012   \n",
       "387 0.32894737 1.90789474 1.38157895 0.05921053 1.77631579  ... 20.65789474   \n",
       "\n",
       "        Att_3rd        Live    npxG/Sh        SSh       SSoT       SDist  \\\n",
       "0   12.25490196 24.01960784 0.27450980 2.94117647 0.98039216 -0.07843137   \n",
       "1   14.60905350 32.34567901 0.44444444 2.55144033 1.15226337 -0.11522634   \n",
       "2   17.05882353 32.44343891 0.29864253 2.12669683 0.63348416 -0.07239819   \n",
       "3   20.41666667 43.05555556 0.47222222 2.91666667 1.52777778 -0.33333333   \n",
       "4   24.93506494 43.83116883 0.27922078 2.40259740 0.90909091  0.11038961   \n",
       "..          ...         ...        ...        ...        ...         ...   \n",
       "383 21.02564103 35.64102564 0.35897436 3.33333333 0.51282051 -0.10256410   \n",
       "384 20.71428571 38.76623377 0.25324675 2.66233766 0.51948052 -0.12337662   \n",
       "385 20.32967033 41.64835165 0.34065934 3.18681319 0.87912088 -0.12087912   \n",
       "386 11.17283951 28.39506173 0.25308642 1.85185185 0.55555556 -0.06790123   \n",
       "387 17.76315789 42.36842105 0.09210526 1.05263158 0.32894737 -0.02631579   \n",
       "\n",
       "          ADWon     ADWonp        Off  \n",
       "0    1.27450980 2.71172299 0.58823529  \n",
       "1    3.29218107 2.13777992 0.45267490  \n",
       "2    2.76018100 1.68303719 0.63348416  \n",
       "3    1.66666667 4.50450450 0.55555556  \n",
       "4    0.64935065 4.63821892 0.06493506  \n",
       "..          ...        ...        ...  \n",
       "383  3.58974359 9.97150997 0.25641026  \n",
       "384  2.72727273 3.20855615 0.45454545  \n",
       "385  1.31868132 3.56400356 0.21978022  \n",
       "386  0.92592593 2.64550265 0.43209877  \n",
       "387 12.96052632 5.10256942 0.32894737  \n",
       "\n",
       "[388 rows x 22 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strikers_df = ps[ps[\"Position\"].isin([\"centre-forward\", \"second striker\"])][['Player', 'Position']]\n",
    "\n",
    "strikers_df = strikers_df.merge(stats_df[['Player', '90s', 'xAG', 'NPxG']], on='Player', how='left')\n",
    "strikers_df = strikers_df.merge(passing_df[['Player', 'LPPA', 'LPrgP', 'LKP', 'LxA', 'LFTP']], on='Player', how='left')\n",
    "strikers_df = strikers_df.merge(possession_df[['Player', 'CaCPA', 'Att_Pen', 'Mid_3rd', 'Att_3rd', 'Live']], on='Player', how='left')\n",
    "strikers_df = strikers_df.merge(shooting_df[['Player', 'npxG/Sh', 'SSh', 'SSoT', 'SDist']], on='Player', how='left')\n",
    "strikers_df = strikers_df.merge(misc_df[['Player', 'ADWon', 'ADWonp', 'Off']], on='Player', how='left')\n",
    "\n",
    "columns_to_divide_by_90 = ['xAG', 'NPxG', 'LPPA', 'LPrgP', 'LKP',\n",
    "       'LxA', 'LFTP', 'CaCPA', 'Att_Pen', 'Mid_3rd', 'Att_3rd', 'Live',\n",
    "       'npxG/Sh', 'SSh', 'SSoT', 'SDist', 'ADWon', 'ADWonp', 'Off']\n",
    "\n",
    "strikers_df[columns_to_divide_by_90] = strikers_df[columns_to_divide_by_90].div(strikers_df['90s'], axis=0)\n",
    "\n",
    "\n",
    "strikers_df.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "strikers_df.fillna(0, inplace=True)\n",
    "\n",
    "\n",
    "strikers_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\strikers.csv')\n",
    "strikers_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>90s</th>\n",
       "      <th>PSxG</th>\n",
       "      <th>PSxG/SoT</th>\n",
       "      <th>PSxG-GA</th>\n",
       "      <th>LCmp</th>\n",
       "      <th>LAtt</th>\n",
       "      <th>PaAtt</th>\n",
       "      <th>PaThr</th>\n",
       "      <th>...</th>\n",
       "      <th>GKAtt</th>\n",
       "      <th>GKAvgLen</th>\n",
       "      <th>COpp</th>\n",
       "      <th>CStp</th>\n",
       "      <th>SwOPA</th>\n",
       "      <th>SoTA</th>\n",
       "      <th>Saves</th>\n",
       "      <th>Savep</th>\n",
       "      <th>CS</th>\n",
       "      <th>PKsv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Álvaro Aceves</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Julen Agirrezabala</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>7.5</td>\n",
       "      <td>5.5</td>\n",
       "      <td>0.30</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>37.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>...</td>\n",
       "      <td>62.0</td>\n",
       "      <td>55.4</td>\n",
       "      <td>96.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>68.421053</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Doğan Alemdar</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6.5</td>\n",
       "      <td>0.29</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>23.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>35.0</td>\n",
       "      <td>51.4</td>\n",
       "      <td>75.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>43.750000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alisson</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>37.0</td>\n",
       "      <td>51.1</td>\n",
       "      <td>0.33</td>\n",
       "      <td>10.1</td>\n",
       "      <td>116.0</td>\n",
       "      <td>283.0</td>\n",
       "      <td>1256.0</td>\n",
       "      <td>210.0</td>\n",
       "      <td>...</td>\n",
       "      <td>193.0</td>\n",
       "      <td>31.3</td>\n",
       "      <td>397.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>71.428571</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alphonse Areola</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>3.4</td>\n",
       "      <td>7.3</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>30.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>56.250000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Joseph Whitworth</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.23</td>\n",
       "      <td>-2.7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>...</td>\n",
       "      <td>15.0</td>\n",
       "      <td>36.7</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>Robin Zentner</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>26.0</td>\n",
       "      <td>35.4</td>\n",
       "      <td>0.30</td>\n",
       "      <td>-3.6</td>\n",
       "      <td>160.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>672.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>...</td>\n",
       "      <td>194.0</td>\n",
       "      <td>54.1</td>\n",
       "      <td>321.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>63.302752</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>Michael Zetterer</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>1.7</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>50.3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>78.571429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Jeroen Zoet</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>3.7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.14</td>\n",
       "      <td>-1.2</td>\n",
       "      <td>25.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>...</td>\n",
       "      <td>23.0</td>\n",
       "      <td>58.4</td>\n",
       "      <td>62.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>69.230769</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>Petar Zovko</td>\n",
       "      <td>goalkeeper</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.55</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>7.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>51.1</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>33.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>197 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Player    Position   90s  PSxG  PSxG/SoT  PSxG-GA   LCmp  \\\n",
       "0         Álvaro Aceves  goalkeeper   0.1   0.1      0.04      0.1    1.0   \n",
       "1    Julen Agirrezabala  goalkeeper   7.5   5.5      0.30     -0.5   37.0   \n",
       "2         Doğan Alemdar  goalkeeper   4.5   6.5      0.29     -1.5   23.0   \n",
       "3               Alisson  goalkeeper  37.0  51.1      0.33     10.1  116.0   \n",
       "4       Alphonse Areola  goalkeeper   3.4   7.3      0.33      0.3   14.0   \n",
       "..                  ...         ...   ...   ...       ...      ...    ...   \n",
       "192    Joseph Whitworth  goalkeeper   2.0   2.3      0.23     -2.7    8.0   \n",
       "193       Robin Zentner  goalkeeper  26.0  35.4      0.30     -3.6  160.0   \n",
       "194    Michael Zetterer  goalkeeper   1.7   3.2      0.24      0.2   16.0   \n",
       "195         Jeroen Zoet  goalkeeper   3.7   2.8      0.14     -1.2   25.0   \n",
       "196         Petar Zovko  goalkeeper   0.8   1.7      0.55     -0.3    7.0   \n",
       "\n",
       "      LAtt   PaAtt  PaThr  ...  GKAtt  GKAvgLen   COpp  CStp  SwOPA   SoTA  \\\n",
       "0      2.0     7.0    3.0  ...    1.0      24.0    1.0   0.0    2.0    3.0   \n",
       "1    101.0   179.0   33.0  ...   62.0      55.4   96.0  11.0   10.0   19.0   \n",
       "2     67.0   109.0   14.0  ...   35.0      51.4   75.0   5.0    5.0   16.0   \n",
       "3    283.0  1256.0  210.0  ...  193.0      31.3  397.0  23.0   89.0  147.0   \n",
       "4     37.0    61.0   14.0  ...   30.0      33.0   47.0   2.0    1.0   16.0   \n",
       "..     ...     ...    ...  ...    ...       ...    ...   ...    ...    ...   \n",
       "192   27.0    68.0    8.0  ...   15.0      36.7   25.0   1.0    3.0   10.0   \n",
       "193  474.0   672.0  146.0  ...  194.0      54.1  321.0  43.0   53.0  109.0   \n",
       "194   33.0    49.0   13.0  ...   12.0      50.3   15.0   3.0    4.0   14.0   \n",
       "195   78.0   110.0   13.0  ...   23.0      58.4   62.0   4.0    6.0   13.0   \n",
       "196   21.0    23.0    3.0  ...   13.0      51.1   24.0   1.0    2.0    3.0   \n",
       "\n",
       "     Saves       Savep    CS  PKsv  \n",
       "0      3.0  100.000000   0.0   0.0  \n",
       "1     13.0   68.421053   2.0   0.0  \n",
       "2      7.0   43.750000   1.0   1.0  \n",
       "3    105.0   71.428571  14.0   1.0  \n",
       "4      9.0   56.250000   1.0   0.0  \n",
       "..     ...         ...   ...   ...  \n",
       "192    5.0   50.000000   0.0   0.0  \n",
       "193   69.0   63.302752   7.0   1.0  \n",
       "194   11.0   78.571429   0.0   0.0  \n",
       "195    9.0   69.230769   0.0   0.0  \n",
       "196    1.0   33.333333   0.0   0.0  \n",
       "\n",
       "[197 rows x 21 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gk_df = ps[ps[\"Position\"].isin([\"goalkeeper\"])]\n",
    "gk_df = gk_df[['Player', 'Position']]\n",
    "gk_df = gk_df.merge(keepersadv_df[['Player','90s','PSxG','PSxG/SoT','PSxG-GA', 'LCmp', 'LAtt',  'PaAtt', 'PaThr', 'PaAvgLen','GKAtt',  'GKAvgLen', 'COpp', 'CStp', 'SwOPA']], on='Player', how='left')\n",
    "gk_df = gk_df.merge(keepers_df[['Player','SoTA', 'Saves', 'Savep', 'CS', 'PKsv']], on='Player', how='left')\n",
    "gk_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\gk.csv')\n",
    "gk_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>BTklInt</th>\n",
       "      <th>CTkl%</th>\n",
       "      <th>PTCrs</th>\n",
       "      <th>PTTB</th>\n",
       "      <th>SCA</th>\n",
       "      <th>LPrgP</th>\n",
       "      <th>LFTP</th>\n",
       "      <th>LxA</th>\n",
       "      <th>CaFTC</th>\n",
       "      <th>CaPrgC</th>\n",
       "      <th>Def_3rd</th>\n",
       "      <th>Mid_3rd</th>\n",
       "      <th>Att_3rd</th>\n",
       "      <th>Live</th>\n",
       "      <th>90s</th>\n",
       "      <th>PrgR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abner</td>\n",
       "      <td>left-back</td>\n",
       "      <td>20</td>\n",
       "      <td>43.750000</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>0.5</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>128</td>\n",
       "      <td>189</td>\n",
       "      <td>113</td>\n",
       "      <td>425</td>\n",
       "      <td>6.7</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Marcos Acuña</td>\n",
       "      <td>left-back</td>\n",
       "      <td>80</td>\n",
       "      <td>71.428571</td>\n",
       "      <td>147</td>\n",
       "      <td>3</td>\n",
       "      <td>65</td>\n",
       "      <td>102</td>\n",
       "      <td>71</td>\n",
       "      <td>5.7</td>\n",
       "      <td>43</td>\n",
       "      <td>49</td>\n",
       "      <td>406</td>\n",
       "      <td>670</td>\n",
       "      <td>467</td>\n",
       "      <td>1523</td>\n",
       "      <td>21.2</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Felix Agu</td>\n",
       "      <td>right-back</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>33</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ruben Aguilar</td>\n",
       "      <td>right-back</td>\n",
       "      <td>37</td>\n",
       "      <td>36.363636</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>102</td>\n",
       "      <td>72</td>\n",
       "      <td>1.2</td>\n",
       "      <td>23</td>\n",
       "      <td>29</td>\n",
       "      <td>210</td>\n",
       "      <td>463</td>\n",
       "      <td>305</td>\n",
       "      <td>975</td>\n",
       "      <td>13.0</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ola Aina</td>\n",
       "      <td>right-back</td>\n",
       "      <td>28</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>43</td>\n",
       "      <td>35</td>\n",
       "      <td>1.9</td>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>146</td>\n",
       "      <td>294</td>\n",
       "      <td>250</td>\n",
       "      <td>679</td>\n",
       "      <td>9.7</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>610</th>\n",
       "      <td>Aaron Zehnter</td>\n",
       "      <td>left-back</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>Jordan Zemura</td>\n",
       "      <td>left-back</td>\n",
       "      <td>55</td>\n",
       "      <td>53.488372</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>45</td>\n",
       "      <td>32</td>\n",
       "      <td>2.1</td>\n",
       "      <td>29</td>\n",
       "      <td>39</td>\n",
       "      <td>302</td>\n",
       "      <td>297</td>\n",
       "      <td>222</td>\n",
       "      <td>808</td>\n",
       "      <td>16.2</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>612</th>\n",
       "      <td>Oleksandr Zinchenko</td>\n",
       "      <td>left-back</td>\n",
       "      <td>62</td>\n",
       "      <td>53.846154</td>\n",
       "      <td>37</td>\n",
       "      <td>6</td>\n",
       "      <td>56</td>\n",
       "      <td>227</td>\n",
       "      <td>201</td>\n",
       "      <td>2.4</td>\n",
       "      <td>66</td>\n",
       "      <td>67</td>\n",
       "      <td>463</td>\n",
       "      <td>1058</td>\n",
       "      <td>610</td>\n",
       "      <td>2112</td>\n",
       "      <td>23.5</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>613</th>\n",
       "      <td>Nadir Zortea</td>\n",
       "      <td>right wingback</td>\n",
       "      <td>29</td>\n",
       "      <td>66.666667</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>47</td>\n",
       "      <td>26</td>\n",
       "      <td>0.7</td>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>205</td>\n",
       "      <td>280</td>\n",
       "      <td>178</td>\n",
       "      <td>659</td>\n",
       "      <td>9.8</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>Nadir Zortea</td>\n",
       "      <td>right wingback</td>\n",
       "      <td>29</td>\n",
       "      <td>66.666667</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>47</td>\n",
       "      <td>26</td>\n",
       "      <td>0.7</td>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>205</td>\n",
       "      <td>280</td>\n",
       "      <td>178</td>\n",
       "      <td>659</td>\n",
       "      <td>9.8</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>615 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Player        Position  BTklInt      CTkl%  PTCrs  PTTB  \\\n",
       "0                  Abner       left-back       20  43.750000     13     0   \n",
       "1           Marcos Acuña       left-back       80  71.428571    147     3   \n",
       "2              Felix Agu      right-back        1   0.000000      1     0   \n",
       "3          Ruben Aguilar      right-back       37  36.363636     39     0   \n",
       "4               Ola Aina      right-back       28  60.000000     35     0   \n",
       "..                   ...             ...      ...        ...    ...   ...   \n",
       "610        Aaron Zehnter       left-back        1   0.000000      0     0   \n",
       "611        Jordan Zemura       left-back       55  53.488372     18     0   \n",
       "612  Oleksandr Zinchenko       left-back       62  53.846154     37     6   \n",
       "613         Nadir Zortea  right wingback       29  66.666667     10     1   \n",
       "614         Nadir Zortea  right wingback       29  66.666667     33     0   \n",
       "\n",
       "     SCA  LPrgP  LFTP  LxA  CaFTC  CaPrgC  Def_3rd  Mid_3rd  Att_3rd  Live  \\\n",
       "0      8     16    18  0.5      7       8      128      189      113   425   \n",
       "1     65    102    71  5.7     43      49      406      670      467  1523   \n",
       "2      4      2     1  0.1      2       0        7       13       14    33   \n",
       "3     18    102    72  1.2     23      29      210      463      305   975   \n",
       "4     27     43    35  1.9     26      35      146      294      250   679   \n",
       "..   ...    ...   ...  ...    ...     ...      ...      ...      ...   ...   \n",
       "610    0      0     0  0.0      0       0        1        2        0     3   \n",
       "611   35     45    32  2.1     29      39      302      297      222   808   \n",
       "612   56    227   201  2.4     66      67      463     1058      610  2112   \n",
       "613   22     47    26  0.7     26      35      205      280      178   659   \n",
       "614   22     47    26  0.7     26      35      205      280      178   659   \n",
       "\n",
       "      90s  PrgR  \n",
       "0     6.7    25  \n",
       "1    21.2    94  \n",
       "2     0.5     2  \n",
       "3    13.0    78  \n",
       "4     9.7    43  \n",
       "..    ...   ...  \n",
       "610   0.0     0  \n",
       "611  16.2    48  \n",
       "612  23.5    68  \n",
       "613   9.8    38  \n",
       "614   9.8    38  \n",
       "\n",
       "[615 rows x 18 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fb_df = ps[ps[\"Position\"].isin([\"left-back\",\"right-back\",\"left wingback\",\"right wingback\"])]\n",
    "fb_df = fb_df[['Player', 'Position']]\n",
    "fb_df = fb_df.merge(defense_df[['Player','BTklInt','CTkl%']], on='Player', how='left')\n",
    "fb_df = fb_df.merge(passing_types_df[['Player','PTCrs','PTTB']], on='Player', how='left')\n",
    "fb_df = fb_df.merge(gca_df[['Player','SCA']], on='Player', how='left')\n",
    "fb_df = fb_df.merge(passing_df[['Player','LPrgP','LFTP','LxA']], on='Player', how='left')\n",
    "fb_df = fb_df.merge(possession_df[['Player','CaFTC','CaPrgC','Def_3rd', 'Mid_3rd', 'Att_3rd','Live']], on='Player', how='left')\n",
    "fb_df = fb_df.merge(stats_df[['Player','90s','PrgR']], on='Player', how='left')\n",
    "fb_df.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "fb_df.fillna(0, inplace=True)\n",
    "fb_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\fb.csv')\n",
    "fb_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>90s</th>\n",
       "      <th>TCmp</th>\n",
       "      <th>LFTP</th>\n",
       "      <th>LPrgP</th>\n",
       "      <th>LPPA</th>\n",
       "      <th>LxA</th>\n",
       "      <th>Def_3rd</th>\n",
       "      <th>Mid_3rd</th>\n",
       "      <th>...</th>\n",
       "      <th>TOSucc</th>\n",
       "      <th>CaPrgC</th>\n",
       "      <th>PrgR</th>\n",
       "      <th>CaFTC</th>\n",
       "      <th>CaCPA</th>\n",
       "      <th>Att_Pen</th>\n",
       "      <th>SSh</th>\n",
       "      <th>npxG</th>\n",
       "      <th>SDist</th>\n",
       "      <th>PTTB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Brenden Aaronson</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>26.4</td>\n",
       "      <td>592</td>\n",
       "      <td>47</td>\n",
       "      <td>86</td>\n",
       "      <td>16</td>\n",
       "      <td>2.6</td>\n",
       "      <td>116</td>\n",
       "      <td>495</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>43</td>\n",
       "      <td>151</td>\n",
       "      <td>34</td>\n",
       "      <td>13</td>\n",
       "      <td>72</td>\n",
       "      <td>41</td>\n",
       "      <td>3.9</td>\n",
       "      <td>-2.9</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Paxten Aaronson</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>1.9</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>6</td>\n",
       "      <td>41</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>4</td>\n",
       "      <td>0.2</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Himad Abdelli</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>23.7</td>\n",
       "      <td>1043</td>\n",
       "      <td>124</td>\n",
       "      <td>151</td>\n",
       "      <td>26</td>\n",
       "      <td>2.5</td>\n",
       "      <td>237</td>\n",
       "      <td>914</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>58</td>\n",
       "      <td>111</td>\n",
       "      <td>60</td>\n",
       "      <td>7</td>\n",
       "      <td>23</td>\n",
       "      <td>24</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Yacine Adli</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>1.6</td>\n",
       "      <td>49</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>14</td>\n",
       "      <td>45</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Maghnes Akliouche</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>4.5</td>\n",
       "      <td>130</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>23</td>\n",
       "      <td>85</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>42</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Nicolò Zaniolo</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>9.9</td>\n",
       "      <td>125</td>\n",
       "      <td>10</td>\n",
       "      <td>19</td>\n",
       "      <td>7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>36</td>\n",
       "      <td>153</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>34</td>\n",
       "      <td>69</td>\n",
       "      <td>27</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>28</td>\n",
       "      <td>2.9</td>\n",
       "      <td>-1.9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>Piotr Zieliński</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>25.4</td>\n",
       "      <td>1300</td>\n",
       "      <td>122</td>\n",
       "      <td>128</td>\n",
       "      <td>45</td>\n",
       "      <td>7.5</td>\n",
       "      <td>183</td>\n",
       "      <td>822</td>\n",
       "      <td>...</td>\n",
       "      <td>22</td>\n",
       "      <td>62</td>\n",
       "      <td>129</td>\n",
       "      <td>75</td>\n",
       "      <td>9</td>\n",
       "      <td>54</td>\n",
       "      <td>53</td>\n",
       "      <td>3.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>Hakim Ziyech</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>7.3</td>\n",
       "      <td>258</td>\n",
       "      <td>20</td>\n",
       "      <td>42</td>\n",
       "      <td>19</td>\n",
       "      <td>1.5</td>\n",
       "      <td>74</td>\n",
       "      <td>184</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>20</td>\n",
       "      <td>69</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>0.6</td>\n",
       "      <td>-0.6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Martin Ødegaard</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>34.7</td>\n",
       "      <td>1449</td>\n",
       "      <td>135</td>\n",
       "      <td>266</td>\n",
       "      <td>91</td>\n",
       "      <td>7.9</td>\n",
       "      <td>199</td>\n",
       "      <td>864</td>\n",
       "      <td>...</td>\n",
       "      <td>48</td>\n",
       "      <td>83</td>\n",
       "      <td>193</td>\n",
       "      <td>60</td>\n",
       "      <td>26</td>\n",
       "      <td>122</td>\n",
       "      <td>93</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Filip Đuričić</td>\n",
       "      <td>attacking midfield</td>\n",
       "      <td>24.1</td>\n",
       "      <td>586</td>\n",
       "      <td>50</td>\n",
       "      <td>77</td>\n",
       "      <td>18</td>\n",
       "      <td>1.6</td>\n",
       "      <td>145</td>\n",
       "      <td>488</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>39</td>\n",
       "      <td>83</td>\n",
       "      <td>42</td>\n",
       "      <td>3</td>\n",
       "      <td>34</td>\n",
       "      <td>26</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>224 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player            Position   90s  TCmp  LFTP  LPrgP  LPPA  \\\n",
       "0     Brenden Aaronson  attacking midfield  26.4   592    47     86    16   \n",
       "1      Paxten Aaronson  attacking midfield   1.9    51     3      6     0   \n",
       "2        Himad Abdelli  attacking midfield  23.7  1043   124    151    26   \n",
       "3          Yacine Adli  attacking midfield   1.6    49     6     10     2   \n",
       "4    Maghnes Akliouche  attacking midfield   4.5   130    12     16     5   \n",
       "..                 ...                 ...   ...   ...   ...    ...   ...   \n",
       "219     Nicolò Zaniolo  attacking midfield   9.9   125    10     19     7   \n",
       "220    Piotr Zieliński  attacking midfield  25.4  1300   122    128    45   \n",
       "221       Hakim Ziyech  attacking midfield   7.3   258    20     42    19   \n",
       "222    Martin Ødegaard  attacking midfield  34.7  1449   135    266    91   \n",
       "223      Filip Đuričić  attacking midfield  24.1   586    50     77    18   \n",
       "\n",
       "     LxA  Def_3rd  Mid_3rd  ...  TOSucc  CaPrgC  PrgR  CaFTC  CaCPA  Att_Pen  \\\n",
       "0    2.6      116      495  ...      34      43   151     34     13       72   \n",
       "1    0.1        6       41  ...       3       8    15      2      2       17   \n",
       "2    2.5      237      914  ...      43      58   111     60      7       23   \n",
       "3    0.2       14       45  ...       4       7     8      5      0        2   \n",
       "4    0.5       23       85  ...       6       9    42      5      2       17   \n",
       "..   ...      ...      ...  ...     ...     ...   ...    ...    ...      ...   \n",
       "219  0.6       36      153  ...      10      34    69     27     10       45   \n",
       "220  7.5      183      822  ...      22      62   129     75      9       54   \n",
       "221  1.5       74      184  ...      14      20    69     17      7       17   \n",
       "222  7.9      199      864  ...      48      83   193     60     26      122   \n",
       "223  1.6      145      488  ...      31      39    83     42      3       34   \n",
       "\n",
       "     SSh  npxG  SDist  PTTB  \n",
       "0     41   3.9   -2.9     8  \n",
       "1      4   0.2   -0.2     0  \n",
       "2     24   1.4    0.6     8  \n",
       "3      2   0.1   -0.1     0  \n",
       "4      5   0.5   -0.5     0  \n",
       "..   ...   ...    ...   ...  \n",
       "219   28   2.9   -1.9     3  \n",
       "220   53   3.5   -0.5     2  \n",
       "221   16   0.6   -0.6     4  \n",
       "222   93  10.0    5.0    23  \n",
       "223   26   2.7    0.3     3  \n",
       "\n",
       "[224 rows x 22 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "am_df = ps[ps[\"Position\"].isin([\"attacking midfield\"])]\n",
    "am_df = am_df[['Player', 'Position']]\n",
    "am_df = am_df.merge(stats_df[['Player','90s']], on='Player', how='left')\n",
    "am_df = am_df.merge(passing_df[['Player','TCmp', 'LFTP','LPrgP','LPPA','LxA']], on='Player', how='left')\n",
    "am_df = am_df.merge(possession_df[['Player', 'Def_3rd', 'Mid_3rd', 'Att_3rd', 'Live','TOSucc','CaPrgC','PrgR','CaFTC','CaCPA','Att_Pen']], on='Player', how='left')\n",
    "am_df = am_df.merge(shooting_df[['Player','SSh','npxG','SDist']], on='Player', how='left')\n",
    "am_df = am_df.merge(passing_types_df[['Player','PTTB']], on='Player', how='left')\n",
    "am_df.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "am_df.fillna(0, inplace=True)\n",
    "am_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\am.csv')\n",
    "am_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>90s</th>\n",
       "      <th>TCmp</th>\n",
       "      <th>LFTP</th>\n",
       "      <th>LPrgP</th>\n",
       "      <th>Def_3rd</th>\n",
       "      <th>Mid_3rd</th>\n",
       "      <th>Att_3rd</th>\n",
       "      <th>Live</th>\n",
       "      <th>TOSucc</th>\n",
       "      <th>CaPrgC</th>\n",
       "      <th>PrgR</th>\n",
       "      <th>BTklInt</th>\n",
       "      <th>CTkl%</th>\n",
       "      <th>BClr</th>\n",
       "      <th>ADWon</th>\n",
       "      <th>ADWonp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Salis Abdul Samed</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>32.2</td>\n",
       "      <td>1819</td>\n",
       "      <td>182</td>\n",
       "      <td>165</td>\n",
       "      <td>404</td>\n",
       "      <td>1502</td>\n",
       "      <td>340</td>\n",
       "      <td>2224</td>\n",
       "      <td>29</td>\n",
       "      <td>33</td>\n",
       "      <td>44</td>\n",
       "      <td>82</td>\n",
       "      <td>55.769231</td>\n",
       "      <td>26</td>\n",
       "      <td>14</td>\n",
       "      <td>45.161290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Laurent Abergel</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1308</td>\n",
       "      <td>144</td>\n",
       "      <td>143</td>\n",
       "      <td>581</td>\n",
       "      <td>1069</td>\n",
       "      <td>151</td>\n",
       "      <td>1779</td>\n",
       "      <td>23</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>126</td>\n",
       "      <td>42.391304</td>\n",
       "      <td>39</td>\n",
       "      <td>8</td>\n",
       "      <td>34.782609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Oliver Abildgaard</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>6.6</td>\n",
       "      <td>115</td>\n",
       "      <td>17</td>\n",
       "      <td>15</td>\n",
       "      <td>82</td>\n",
       "      <td>137</td>\n",
       "      <td>40</td>\n",
       "      <td>257</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>43.750000</td>\n",
       "      <td>17</td>\n",
       "      <td>50</td>\n",
       "      <td>70.422535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tyler Adams</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1108</td>\n",
       "      <td>110</td>\n",
       "      <td>136</td>\n",
       "      <td>376</td>\n",
       "      <td>1010</td>\n",
       "      <td>254</td>\n",
       "      <td>1628</td>\n",
       "      <td>7</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>124</td>\n",
       "      <td>64.935065</td>\n",
       "      <td>29</td>\n",
       "      <td>25</td>\n",
       "      <td>62.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Lucien Agoume</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>12.2</td>\n",
       "      <td>619</td>\n",
       "      <td>62</td>\n",
       "      <td>93</td>\n",
       "      <td>276</td>\n",
       "      <td>480</td>\n",
       "      <td>143</td>\n",
       "      <td>893</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>69</td>\n",
       "      <td>51.515152</td>\n",
       "      <td>24</td>\n",
       "      <td>31</td>\n",
       "      <td>63.265306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>Denis Zakaria</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>6.0</td>\n",
       "      <td>190</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>80</td>\n",
       "      <td>142</td>\n",
       "      <td>53</td>\n",
       "      <td>269</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>20</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>Andre-Frank Zambo Anguissa</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>33.9</td>\n",
       "      <td>1988</td>\n",
       "      <td>185</td>\n",
       "      <td>181</td>\n",
       "      <td>408</td>\n",
       "      <td>1519</td>\n",
       "      <td>758</td>\n",
       "      <td>2647</td>\n",
       "      <td>33</td>\n",
       "      <td>58</td>\n",
       "      <td>140</td>\n",
       "      <td>102</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>25</td>\n",
       "      <td>47</td>\n",
       "      <td>63.513514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>Martín Zubimendi</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>34.5</td>\n",
       "      <td>1545</td>\n",
       "      <td>175</td>\n",
       "      <td>184</td>\n",
       "      <td>509</td>\n",
       "      <td>1350</td>\n",
       "      <td>259</td>\n",
       "      <td>2090</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>29</td>\n",
       "      <td>96</td>\n",
       "      <td>53.333333</td>\n",
       "      <td>55</td>\n",
       "      <td>58</td>\n",
       "      <td>63.043478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>Blanco</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>Hugo Guillamón</td>\n",
       "      <td>defensive midfield</td>\n",
       "      <td>18.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>305 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Player            Position   90s  TCmp  LFTP  LPrgP  \\\n",
       "0             Salis Abdul Samed  defensive midfield  32.2  1819   182    165   \n",
       "1               Laurent Abergel  defensive midfield  26.0  1308   144    143   \n",
       "2             Oliver Abildgaard  defensive midfield   6.6   115    17     15   \n",
       "3                   Tyler Adams  defensive midfield  24.0  1108   110    136   \n",
       "4                 Lucien Agoume  defensive midfield  12.2   619    62     93   \n",
       "..                          ...                 ...   ...   ...   ...    ...   \n",
       "300               Denis Zakaria  defensive midfield   6.0   190    10      9   \n",
       "301  Andre-Frank Zambo Anguissa  defensive midfield  33.9  1988   185    181   \n",
       "302            Martín Zubimendi  defensive midfield  34.5  1545   175    184   \n",
       "303                      Blanco  defensive midfield   1.8     0     0      0   \n",
       "304              Hugo Guillamón  defensive midfield  18.1     0     0      0   \n",
       "\n",
       "     Def_3rd  Mid_3rd  Att_3rd  Live  TOSucc  CaPrgC  PrgR  BTklInt  \\\n",
       "0        404     1502      340  2224      29      33    44       82   \n",
       "1        581     1069      151  1779      23      13    14      126   \n",
       "2         82      137       40   257       1       2     8       15   \n",
       "3        376     1010      254  1628       7      19    20      124   \n",
       "4        276      480      143   893       5       9    10       69   \n",
       "..       ...      ...      ...   ...     ...     ...   ...      ...   \n",
       "300       80      142       53   269       5      11     3       20   \n",
       "301      408     1519      758  2647      33      58   140      102   \n",
       "302      509     1350      259  2090       9      43    29       96   \n",
       "303        0        0        0     0       0       0     0        0   \n",
       "304        0        0        0     0       0       0     0        0   \n",
       "\n",
       "         CTkl%  BClr  ADWon     ADWonp  \n",
       "0    55.769231    26     14  45.161290  \n",
       "1    42.391304    39      8  34.782609  \n",
       "2    43.750000    17     50  70.422535  \n",
       "3    64.935065    29     25  62.500000  \n",
       "4    51.515152    24     31  63.265306  \n",
       "..         ...   ...    ...        ...  \n",
       "300  20.000000    11      0   0.000000  \n",
       "301  25.000000    25     47  63.513514  \n",
       "302  53.333333    55     58  63.043478  \n",
       "303   0.000000     0      0   0.000000  \n",
       "304   0.000000     0      0   0.000000  \n",
       "\n",
       "[305 rows x 18 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dm_df = ps[ps[\"Position\"].isin([\"defensive midfield\"])]\n",
    "dm_df = dm_df[['Player', 'Position']]\n",
    "dm_df = dm_df.merge(stats_df[['Player','90s']], on='Player', how='left')\n",
    "dm_df = dm_df.merge(passing_df[['Player','TCmp', 'LFTP','LPrgP']], on='Player', how='left')\n",
    "dm_df = dm_df.merge(possession_df[['Player', 'Def_3rd', 'Mid_3rd', 'Att_3rd', 'Live','TOSucc','CaPrgC','PrgR',]], on='Player', how='left')\n",
    "dm_df = dm_df.merge(defense_df[['Player','BTklInt','CTkl%','BClr']], on='Player', how='left')\n",
    "dm_df = dm_df.merge(misc_df[['Player','ADWon', 'ADWonp']], on='Player', how='left')\n",
    "dm_df.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "dm_df.fillna(0, inplace=True)\n",
    "dm_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\dm.csv')\n",
    "dm_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>90s</th>\n",
       "      <th>TCmp</th>\n",
       "      <th>LFTP</th>\n",
       "      <th>LPrgP</th>\n",
       "      <th>Def_3rd</th>\n",
       "      <th>Mid_3rd</th>\n",
       "      <th>Att_3rd</th>\n",
       "      <th>Live</th>\n",
       "      <th>TOSucc</th>\n",
       "      <th>CaPrgC</th>\n",
       "      <th>PrgR</th>\n",
       "      <th>TOAtt</th>\n",
       "      <th>BTklInt</th>\n",
       "      <th>PTTB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Christian Acella</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>0.2</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mohamed Achi</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>0.4</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Martin Adeline</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>1.2</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>16</td>\n",
       "      <td>59</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Michel Aebischer</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>17.1</td>\n",
       "      <td>557</td>\n",
       "      <td>37</td>\n",
       "      <td>46</td>\n",
       "      <td>147</td>\n",
       "      <td>400</td>\n",
       "      <td>246</td>\n",
       "      <td>791</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>85</td>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Álvaro Aguado</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>21.0</td>\n",
       "      <td>930</td>\n",
       "      <td>111</td>\n",
       "      <td>139</td>\n",
       "      <td>255</td>\n",
       "      <td>742</td>\n",
       "      <td>315</td>\n",
       "      <td>1292</td>\n",
       "      <td>13</td>\n",
       "      <td>29</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>Xeka</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>6.1</td>\n",
       "      <td>279</td>\n",
       "      <td>32</td>\n",
       "      <td>39</td>\n",
       "      <td>74</td>\n",
       "      <td>248</td>\n",
       "      <td>61</td>\n",
       "      <td>380</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>Ryan Yates</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>20.4</td>\n",
       "      <td>455</td>\n",
       "      <td>26</td>\n",
       "      <td>43</td>\n",
       "      <td>235</td>\n",
       "      <td>418</td>\n",
       "      <td>143</td>\n",
       "      <td>790</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>27</td>\n",
       "      <td>9</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>Oier Zarraga</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>9.5</td>\n",
       "      <td>294</td>\n",
       "      <td>36</td>\n",
       "      <td>37</td>\n",
       "      <td>60</td>\n",
       "      <td>229</td>\n",
       "      <td>168</td>\n",
       "      <td>447</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>32</td>\n",
       "      <td>7</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>Szymon Żurkowski</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>5.1</td>\n",
       "      <td>87</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>46</td>\n",
       "      <td>88</td>\n",
       "      <td>62</td>\n",
       "      <td>194</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>Szymon Żurkowski</td>\n",
       "      <td>central midfield</td>\n",
       "      <td>5.1</td>\n",
       "      <td>87</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>46</td>\n",
       "      <td>88</td>\n",
       "      <td>62</td>\n",
       "      <td>194</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>447 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Player          Position   90s  TCmp  LFTP  LPrgP  Def_3rd  \\\n",
       "0    Christian Acella  central midfield   0.2     9     0      0        1   \n",
       "1        Mohamed Achi  central midfield   0.4    18     1      3        4   \n",
       "2      Martin Adeline  central midfield   1.2    29     2      3       22   \n",
       "3    Michel Aebischer  central midfield  17.1   557    37     46      147   \n",
       "4       Álvaro Aguado  central midfield  21.0   930   111    139      255   \n",
       "..                ...               ...   ...   ...   ...    ...      ...   \n",
       "442              Xeka  central midfield   6.1   279    32     39       74   \n",
       "443        Ryan Yates  central midfield  20.4   455    26     43      235   \n",
       "444      Oier Zarraga  central midfield   9.5   294    36     37       60   \n",
       "445  Szymon Żurkowski  central midfield   5.1    87    10     11       46   \n",
       "446  Szymon Żurkowski  central midfield   5.1    87    10     11       46   \n",
       "\n",
       "     Mid_3rd  Att_3rd  Live  TOSucc  CaPrgC  PrgR  TOAtt  BTklInt  PTTB  \n",
       "0          9        1    11       0       0     0      0        1     0  \n",
       "1         11       10    25       0       2     1      1        1     0  \n",
       "2         22       16    59       1       1     1      3        6     0  \n",
       "3        400      246   791       6      14    85     13       19     0  \n",
       "4        742      315  1292      13      29    50     31       40     3  \n",
       "..       ...      ...   ...     ...     ...   ...    ...      ...   ...  \n",
       "442      248       61   380       1       5    13      6       16     1  \n",
       "443      418      143   790       4      11    27      9       48     0  \n",
       "444      229      168   447       5      12    32      7       24     1  \n",
       "445       88       62   194       8      12    14     12       13     0  \n",
       "446       88       62   194       8      12    14     12       13     0  \n",
       "\n",
       "[447 rows x 16 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cm_df = ps[ps[\"Position\"].isin([\"central midfield\"])]\n",
    "cm_df = cm_df[['Player', 'Position']]\n",
    "cm_df = cm_df.merge(stats_df[['Player','90s']], on='Player', how='left')\n",
    "cm_df = cm_df.merge(passing_df[['Player','TCmp', 'LFTP','LPrgP']], on='Player', how='left')\n",
    "cm_df = cm_df.merge(possession_df[['Player', 'Def_3rd', 'Mid_3rd', 'Att_3rd', 'Live','TOSucc','CaPrgC','PrgR','TOAtt']], on='Player', how='left')\n",
    "cm_df = cm_df.merge(defense_df[['Player','BTklInt']], on='Player', how='left')\n",
    "cm_df = cm_df.merge(passing_types_df[['Player','PTTB']], on='Player', how='left')\n",
    "cm_df.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "cm_df.fillna(0, inplace=True)\n",
    "cm_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\cm.csv')\n",
    "cm_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>BTklInt</th>\n",
       "      <th>CTkl</th>\n",
       "      <th>BClr</th>\n",
       "      <th>BSh</th>\n",
       "      <th>BPass</th>\n",
       "      <th>TCmp</th>\n",
       "      <th>LCmp</th>\n",
       "      <th>LAtt</th>\n",
       "      <th>...</th>\n",
       "      <th>CaPrgC</th>\n",
       "      <th>Def_3rd</th>\n",
       "      <th>Mid_3rd</th>\n",
       "      <th>Att_3rd</th>\n",
       "      <th>Live</th>\n",
       "      <th>PrgC</th>\n",
       "      <th>PrgP</th>\n",
       "      <th>90s</th>\n",
       "      <th>ADWonp</th>\n",
       "      <th>ADWon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>James Abankwah</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Yunis Abdelhamid</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>146</td>\n",
       "      <td>39</td>\n",
       "      <td>116</td>\n",
       "      <td>27</td>\n",
       "      <td>38</td>\n",
       "      <td>1679</td>\n",
       "      <td>155</td>\n",
       "      <td>279</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>1088</td>\n",
       "      <td>1275</td>\n",
       "      <td>123</td>\n",
       "      <td>2459</td>\n",
       "      <td>40</td>\n",
       "      <td>215</td>\n",
       "      <td>37.0</td>\n",
       "      <td>64.583333</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Francesco Acerbi</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>74</td>\n",
       "      <td>20</td>\n",
       "      <td>85</td>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "      <td>1455</td>\n",
       "      <td>149</td>\n",
       "      <td>202</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>858</td>\n",
       "      <td>880</td>\n",
       "      <td>167</td>\n",
       "      <td>1890</td>\n",
       "      <td>39</td>\n",
       "      <td>100</td>\n",
       "      <td>26.9</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tosin Adarabioyo</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>56</td>\n",
       "      <td>16</td>\n",
       "      <td>140</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>1066</td>\n",
       "      <td>136</td>\n",
       "      <td>223</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>776</td>\n",
       "      <td>732</td>\n",
       "      <td>46</td>\n",
       "      <td>1544</td>\n",
       "      <td>16</td>\n",
       "      <td>95</td>\n",
       "      <td>23.2</td>\n",
       "      <td>69.411765</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Emmanuel Agbadou</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>103</td>\n",
       "      <td>42</td>\n",
       "      <td>107</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>1281</td>\n",
       "      <td>202</td>\n",
       "      <td>284</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>851</td>\n",
       "      <td>877</td>\n",
       "      <td>87</td>\n",
       "      <td>1798</td>\n",
       "      <td>15</td>\n",
       "      <td>131</td>\n",
       "      <td>26.5</td>\n",
       "      <td>62.500000</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>544</th>\n",
       "      <td>Dan-Axel Zagadou</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>35</td>\n",
       "      <td>5</td>\n",
       "      <td>81</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>841</td>\n",
       "      <td>124</td>\n",
       "      <td>171</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>631</td>\n",
       "      <td>497</td>\n",
       "      <td>28</td>\n",
       "      <td>1150</td>\n",
       "      <td>3</td>\n",
       "      <td>44</td>\n",
       "      <td>14.1</td>\n",
       "      <td>72.602740</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>545</th>\n",
       "      <td>Nathan Zeze</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>546</th>\n",
       "      <td>David Zima</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>154</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>114</td>\n",
       "      <td>121</td>\n",
       "      <td>12</td>\n",
       "      <td>245</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>4.5</td>\n",
       "      <td>62.500000</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>Kurt Zouma</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>39</td>\n",
       "      <td>5</td>\n",
       "      <td>120</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>701</td>\n",
       "      <td>79</td>\n",
       "      <td>129</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>654</td>\n",
       "      <td>364</td>\n",
       "      <td>35</td>\n",
       "      <td>1050</td>\n",
       "      <td>3</td>\n",
       "      <td>31</td>\n",
       "      <td>22.1</td>\n",
       "      <td>80.882353</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>548</th>\n",
       "      <td>Igor Zubeldia</td>\n",
       "      <td>centre-back</td>\n",
       "      <td>56</td>\n",
       "      <td>25</td>\n",
       "      <td>93</td>\n",
       "      <td>17</td>\n",
       "      <td>6</td>\n",
       "      <td>1329</td>\n",
       "      <td>149</td>\n",
       "      <td>231</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>820</td>\n",
       "      <td>912</td>\n",
       "      <td>48</td>\n",
       "      <td>1772</td>\n",
       "      <td>14</td>\n",
       "      <td>128</td>\n",
       "      <td>28.2</td>\n",
       "      <td>53.097345</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>549 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Player     Position  BTklInt  CTkl  BClr  BSh  BPass  TCmp  \\\n",
       "0      James Abankwah  centre-back        1     0     5    2      2    23   \n",
       "1    Yunis Abdelhamid  centre-back      146    39   116   27     38  1679   \n",
       "2    Francesco Acerbi  centre-back       74    20    85   18      7  1455   \n",
       "3    Tosin Adarabioyo  centre-back       56    16   140   15      5  1066   \n",
       "4    Emmanuel Agbadou  centre-back      103    42   107   14     16  1281   \n",
       "..                ...          ...      ...   ...   ...  ...    ...   ...   \n",
       "544  Dan-Axel Zagadou  centre-back       35     5    81   16      3   841   \n",
       "545       Nathan Zeze  centre-back        3     1     1    0      0    18   \n",
       "546        David Zima  centre-back       18     3    11    2      5   154   \n",
       "547        Kurt Zouma  centre-back       39     5   120   14      3   701   \n",
       "548     Igor Zubeldia  centre-back       56    25    93   17      6  1329   \n",
       "\n",
       "     LCmp  LAtt  ...  CaPrgC  Def_3rd  Mid_3rd  Att_3rd  Live  PrgC  PrgP  \\\n",
       "0       2     5  ...       0       26       13        0    39     0     0   \n",
       "1     155   279  ...      40     1088     1275      123  2459    40   215   \n",
       "2     149   202  ...      39      858      880      167  1890    39   100   \n",
       "3     136   223  ...      16      776      732       46  1544    16    95   \n",
       "4     202   284  ...      15      851      877       87  1798    15   131   \n",
       "..    ...   ...  ...     ...      ...      ...      ...   ...   ...   ...   \n",
       "544   124   171  ...       3      631      497       28  1150     3    44   \n",
       "545     1     2  ...       0       15       15        0    30     0     0   \n",
       "546    12    20  ...       3      114      121       12   245     3    12   \n",
       "547    79   129  ...       3      654      364       35  1050     3    31   \n",
       "548   149   231  ...      14      820      912       48  1772    14   128   \n",
       "\n",
       "      90s      ADWonp  ADWon  \n",
       "0     0.7  100.000000      2  \n",
       "1    37.0   64.583333     93  \n",
       "2    26.9   65.000000     78  \n",
       "3    23.2   69.411765     59  \n",
       "4    26.5   62.500000     60  \n",
       "..    ...         ...    ...  \n",
       "544  14.1   72.602740     53  \n",
       "545   0.7   50.000000      1  \n",
       "546   4.5   62.500000     15  \n",
       "547  22.1   80.882353     55  \n",
       "548  28.2   53.097345     60  \n",
       "\n",
       "[549 rows x 22 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cb_df = ps[ps[\"Position\"].isin([\"centre-back\"])][['Player', 'Position']]\n",
    "cb_df = cb_df.merge(defense_df[['Player', 'BTklInt', 'CTkl', 'BClr', 'BSh', 'BPass']], on='Player', how='left')\n",
    "cb_df = cb_df.merge(passing_df[['Player', 'TCmp', 'LCmp', 'LAtt', 'LPrgP', 'LFTP']], on='Player', how='left')\n",
    "cb_df = cb_df.merge(possession_df[['Player', 'CaPrgC', 'Def_3rd', 'Mid_3rd', 'Att_3rd', 'Live']], on='Player', how='left')\n",
    "cb_df = cb_df.merge(stats_df[['Player', 'PrgC', 'PrgP','90s']], on='Player', how='left')\n",
    "cb_df = cb_df.merge(misc_df[['Player', 'ADWonp', 'ADWon']], on='Player', how='left')\n",
    "\n",
    "cb_df.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "cb_df.fillna(0, inplace=True)\n",
    "cb_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\cb.csv')\n",
    "cb_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>PTCrs</th>\n",
       "      <th>PTTB</th>\n",
       "      <th>LxA</th>\n",
       "      <th>LKP</th>\n",
       "      <th>LFTP</th>\n",
       "      <th>LPPA</th>\n",
       "      <th>LPrgP</th>\n",
       "      <th>Att_Pen</th>\n",
       "      <th>...</th>\n",
       "      <th>TOSucc</th>\n",
       "      <th>CaPrgC</th>\n",
       "      <th>CaCPA</th>\n",
       "      <th>PrgR</th>\n",
       "      <th>90s</th>\n",
       "      <th>npxG</th>\n",
       "      <th>npxG/Sh</th>\n",
       "      <th>SSh_p90</th>\n",
       "      <th>SSoT_90</th>\n",
       "      <th>Off</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Zakaria Aboukhlal</td>\n",
       "      <td>right winger</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>2.8</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>22</td>\n",
       "      <td>72</td>\n",
       "      <td>151</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>100</td>\n",
       "      <td>44</td>\n",
       "      <td>276</td>\n",
       "      <td>27.5</td>\n",
       "      <td>11.5</td>\n",
       "      <td>11.5</td>\n",
       "      <td>3.018182</td>\n",
       "      <td>1.090909</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Amine Adli</td>\n",
       "      <td>right winger</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>20</td>\n",
       "      <td>26</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>67</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>46</td>\n",
       "      <td>15</td>\n",
       "      <td>137</td>\n",
       "      <td>15.9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.327044</td>\n",
       "      <td>1.069182</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kevin Agudelo</td>\n",
       "      <td>right winger</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "      <td>2.6</td>\n",
       "      <td>28</td>\n",
       "      <td>58</td>\n",
       "      <td>31</td>\n",
       "      <td>110</td>\n",
       "      <td>54</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>81</td>\n",
       "      <td>19</td>\n",
       "      <td>100</td>\n",
       "      <td>23.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.181435</td>\n",
       "      <td>0.295359</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Amar Ahmed</td>\n",
       "      <td>left winger</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ángel Alarcón</td>\n",
       "      <td>left winger</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>Nicola Zalewski</td>\n",
       "      <td>left winger</td>\n",
       "      <td>76</td>\n",
       "      <td>2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>12</td>\n",
       "      <td>58</td>\n",
       "      <td>24</td>\n",
       "      <td>85</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>29</td>\n",
       "      <td>92</td>\n",
       "      <td>21</td>\n",
       "      <td>99</td>\n",
       "      <td>24.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.188525</td>\n",
       "      <td>0.368852</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>586</th>\n",
       "      <td>Luca Zanimacchia</td>\n",
       "      <td>right winger</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>26</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>22</td>\n",
       "      <td>8</td>\n",
       "      <td>70</td>\n",
       "      <td>8.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.289157</td>\n",
       "      <td>0.481928</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>587</th>\n",
       "      <td>Arber Zeneli</td>\n",
       "      <td>left winger</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>2.3</td>\n",
       "      <td>22</td>\n",
       "      <td>24</td>\n",
       "      <td>19</td>\n",
       "      <td>51</td>\n",
       "      <td>56</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>45</td>\n",
       "      <td>29</td>\n",
       "      <td>118</td>\n",
       "      <td>11.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.792793</td>\n",
       "      <td>0.540541</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>Alessio Zerbin</td>\n",
       "      <td>left winger</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>20</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>2.272727</td>\n",
       "      <td>1.363636</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>Edon Zhegrova</td>\n",
       "      <td>right winger</td>\n",
       "      <td>73</td>\n",
       "      <td>2</td>\n",
       "      <td>5.3</td>\n",
       "      <td>30</td>\n",
       "      <td>23</td>\n",
       "      <td>33</td>\n",
       "      <td>52</td>\n",
       "      <td>79</td>\n",
       "      <td>...</td>\n",
       "      <td>53</td>\n",
       "      <td>74</td>\n",
       "      <td>35</td>\n",
       "      <td>194</td>\n",
       "      <td>11.7</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.589744</td>\n",
       "      <td>1.196581</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>590 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player      Position  PTCrs  PTTB  LxA  LKP  LFTP  LPPA  \\\n",
       "0    Zakaria Aboukhlal  right winger     29     1  2.8   22    30    22   \n",
       "1           Amine Adli  right winger     18     3  1.9   20    26    10   \n",
       "2        Kevin Agudelo  right winger     34     5  2.6   28    58    31   \n",
       "3           Amar Ahmed   left winger      0     0  0.0    0     0     0   \n",
       "4        Ángel Alarcón   left winger      1     0  0.0    0     0     0   \n",
       "..                 ...           ...    ...   ...  ...  ...   ...   ...   \n",
       "585    Nicola Zalewski   left winger     76     2  1.9   12    58    24   \n",
       "586   Luca Zanimacchia  right winger     46     0  1.0   14    12    12   \n",
       "587       Arber Zeneli   left winger     50     4  2.3   22    24    19   \n",
       "588     Alessio Zerbin   left winger      1     0  0.1    0     3     1   \n",
       "589      Edon Zhegrova  right winger     73     2  5.3   30    23    33   \n",
       "\n",
       "     LPrgP  Att_Pen  ...  TOSucc  CaPrgC  CaCPA  PrgR   90s  npxG  npxG/Sh  \\\n",
       "0       72      151  ...      42     100     44   276  27.5  11.5     11.5   \n",
       "1       49       67  ...      26      46     15   137  15.9   5.0      5.0   \n",
       "2      110       54  ...      50      81     19   100  23.7   1.5      1.5   \n",
       "3        1        0  ...       1       0      0     2   0.2   0.0      0.0   \n",
       "4        0        0  ...       0       0      0     0   0.3   0.0      0.0   \n",
       "..     ...      ...  ...     ...     ...    ...   ...   ...   ...      ...   \n",
       "585     85       33  ...      29      92     21    99  24.4   1.3      1.3   \n",
       "586     26       33  ...       5      22      8    70   8.3   1.2      1.2   \n",
       "587     51       56  ...      17      45     29   118  11.1   2.1      2.1   \n",
       "588      6        9  ...       2       5      3    20   2.2   0.3      0.3   \n",
       "589     52       79  ...      53      74     35   194  11.7   3.6      3.6   \n",
       "\n",
       "      SSh_p90   SSoT_90  Off  \n",
       "0    3.018182  1.090909   20  \n",
       "1    2.327044  1.069182    4  \n",
       "2    1.181435  0.295359    2  \n",
       "3    0.000000  0.000000    0  \n",
       "4    3.333333  3.333333    0  \n",
       "..        ...       ...  ...  \n",
       "585  1.188525  0.368852    1  \n",
       "586  2.289157  0.481928    2  \n",
       "587  2.792793  0.540541    3  \n",
       "588  2.272727  1.363636    1  \n",
       "589  3.589744  1.196581    2  \n",
       "\n",
       "[590 rows x 21 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wi_df = ps[ps[\"Position\"].isin([\"left winger\",\"right winger\"])]\n",
    "wi_df = wi_df[['Player', 'Position']]\n",
    "wi_df = wi_df.merge(passing_types_df[['Player','PTCrs','PTTB']], on='Player', how='left')\n",
    "wi_df = wi_df.merge(passing_df[['Player','LxA','LKP', 'LFTP',  'LPPA','LPrgP']], on='Player', how='left')\n",
    "wi_df = wi_df.merge(possession_df[['Player', 'Att_Pen','TOAtt', 'TOSucc', 'CaPrgC','CaCPA',]], on='Player', how='left')\n",
    "wi_df = wi_df.merge(stats_df[['Player','PrgR','90s']], on='Player', how='left')\n",
    "wi_df = wi_df.merge(shooting_df[['Player','npxG', 'npxG/Sh','SSh_p90', 'SSoT_90']], on='Player', how='left')\n",
    "wi_df = wi_df.merge(misc_df[['Player','Off']], on='Player', how='left') \n",
    "wi_df.replace('#DIV/0!', pd.NA, inplace=True)\n",
    "wi_df.fillna(0, inplace=True)\n",
    "wi_df.to_csv(r'E:\\2nd year\\3rd sem\\Data science\\Project\\FInal_DF\\wi.csv')\n",
    "wi_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import pandas as pd\n",
    "from copy import deepcopy\n",
    "from bs4 import BeautifulSoup\n",
    "from urllib.request import urlopen\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "from matplotlib.patches import Arc\n",
    "import streamlit as st\n",
    "\n",
    "def create_full_pitch(x_lims, y_lims, background_color=\"#0E1117\", line_color=\"white\", line_width=10.):\n",
    "    x_mid = x_lims[1] / 2\n",
    "    y_mid = y_lims[1] / 2\n",
    "\n",
    "    # Create figure:\n",
    "    fig = plt.figure(facecolor=background_color, figsize=(12, 7))\n",
    "    ax = fig.add_subplot(111, facecolor=background_color)\n",
    "\n",
    "    # Pitch Outline & Centre Line\n",
    "    plt.plot([x_lims[0], x_lims[0]], [y_lims[0], y_lims[1]], linewidth=line_width, color=line_color)  # left goal-line\n",
    "    plt.plot([x_lims[0], x_lims[1]], [y_lims[1], y_lims[1]], linewidth=line_width, color=line_color)  # Upper side-line\n",
    "    plt.plot([x_lims[1], x_lims[1]], [y_lims[1], y_lims[0]], linewidth=line_width, color=line_color)  # Right goal-line\n",
    "    plt.plot([x_lims[1], x_lims[0]], [y_lims[0], y_lims[0]], linewidth=line_width, color=line_color)  # Lower side-line\n",
    "    plt.plot([x_mid, x_mid], [y_lims[0], y_lims[1]], linewidth=line_width, color=line_color)  # Center line\n",
    "\n",
    "    # Left Penalty Area\n",
    "    plt.plot([x_lims[0]+.18, x_lims[0]+.18], [y_mid - .22, y_mid + .22], color=line_color)\n",
    "    plt.plot([x_lims[0], x_lims[0]+.18], [y_mid + .22, y_mid + .22], color=line_color)\n",
    "    plt.plot([x_lims[0], x_lims[0]+.18], [y_mid - .22, y_mid - .22], color=line_color)\n",
    "\n",
    "    # Right Penalty Area\n",
    "    plt.plot([x_lims[1] - .18, x_lims[1] - .18], [y_mid - .22, y_mid + .22], color=line_color)\n",
    "    plt.plot([x_lims[1], x_lims[1] - .18], [y_mid + .22, y_mid + .22], color=line_color)\n",
    "    plt.plot([x_lims[1], x_lims[1] - .18], [y_mid - .22, y_mid - .22], color=line_color)\n",
    "\n",
    "    # Left 6yd box Area\n",
    "    plt.plot([x_lims[0]+.06, x_lims[0]+.06], [y_mid - .06, y_mid + .06], color=line_color)\n",
    "    plt.plot([x_lims[0], x_lims[0]+.06], [y_mid + .06, y_mid + .06], color=line_color)\n",
    "    plt.plot([x_lims[0], x_lims[0]+.06], [y_mid - .06, y_mid - .06], color=line_color)\n",
    "\n",
    "    # # Right 6yd box Area\n",
    "    plt.plot([x_lims[1] - .06, x_lims[1] - .06], [y_mid - .06, y_mid + .06], color=line_color)\n",
    "    plt.plot([x_lims[1], x_lims[1] - .06], [y_mid + .06, y_mid + .06], color=line_color)\n",
    "    plt.plot([x_lims[1], x_lims[1] - .06], [y_mid - .06, y_mid - .06], color=line_color)\n",
    "\n",
    "    # Prepare Circles\n",
    "    centre_circle = plt.Circle((x_mid, y_mid), .1, color=line_color, fill=False)\n",
    "    centre_spot = plt.Circle((x_mid, y_mid), 0.005, color=line_color)\n",
    "    left_pen_spot = plt.Circle((x_lims[0]+0.12, y_mid), 0.005, color=line_color)\n",
    "    right_pen_spot = plt.Circle((x_lims[1] - 0.12, y_mid), 0.005, color=line_color)\n",
    "\n",
    "    # Draw Circles\n",
    "    ax.add_patch(centre_circle)\n",
    "    ax.add_patch(centre_spot)\n",
    "    ax.add_patch(left_pen_spot)\n",
    "    ax.add_patch(right_pen_spot)\n",
    "\n",
    "    # Prepare Arcs\n",
    "    left_arc = Arc((x_lims[0] + .12, y_mid), height=.183, width=.183, angle=0, theta1=310, theta2=50, color=line_color)\n",
    "    right_arc = Arc((x_lims[1] - .12, y_mid), height=.183, width=.183, angle=0, theta1=130, theta2=230, color=line_color)\n",
    "\n",
    "    # Draw Arcs\n",
    "    ax.add_patch(left_arc)\n",
    "    ax.add_patch(right_arc)\n",
    "\n",
    "    plt.axis(\"off\")\n",
    "    return ax"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA7YAAAIvCAYAAABA5EenAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/SrBM8AAAACXBIWXMAAA9hAAAPYQGoP6dpAABP+0lEQVR4nO3deZxN9ePH8fe9szBDs1vGnpKlsqQae0IkwpBMWUqo0KZQWVLfpMUaIglRtrJTWbJlK7JmL7KMLbNjhrkz9/7+wPwoezPzuefO6/l4eDDnnjPnzYy5530+n3OOLSC4gEsAAAAAAFiU3XQAAAAAAAD+C4otAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEvzNh0AAAAAcBcFCxbQ0+07KaRgYUkuRe//Q9O+Gq+ExETT0QBcgy0guIDLdAgAAADApFy5cqnPgI91NrC4Zu4+oxNJ5yRJJUL9FFnKT6f+2qpB/d+Ty8WhM+COKLYAAADI0by9vTVkzHh9ucdLhxPOXnGd8uF5VO+24+rb/bXsDQfghnCNLQAAAHK0Zzu9oO8O57pqqZWkbcfOaLe9mOo+Ui8bkwG4URRbAAAA5Gj3VHlI24+evu56C/fEq+ETrbMhEYCbRbEFAABAjnXHHSW197TPDa3rdElncwXL19c3i1MBuFkUWwAAAORYQUGBij934+ufSnUpb968WRcIwC2h2AIAACDHSkhIVHCuG1//Nl+bTp++/rRlANmLYgsAAIAca9++/borr+OG1rXbJL9z8UpNTc3iVABuFsUWAAAAOdr2X1bqnkLXn178aOlg/TBjcjYkAnCzKLYAAADI0b4aO0Yti55T0aDcV12nfLi/yjgPaemSn7IxGYAbZQsILuAyHQIAAAAwKVeuXOr9wcc6F1RcM3ef0Ymk83eUKhHqp+Z3+Slx31YN/uA9uVwcOgPuiGILAAAAXFCwYAE93b6TQgoWllwuRf/1h6Z9NV4JiYmmowG4BootAAAAAMDSuMYWAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYGsUWAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYGsUWAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYGsUWAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYGsUWAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYGsUWAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYGsUWAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYmrfpAJnpWPR+5cqVS+np6ToZE2M6DgAAyhcWJi8vL96bAABu4+J707lz5xRepKTpOJnCFhBcwGU6RGaJO3lEXl5epmMAAAAAgNtLT09XSL7CpmNkCo8asU1PT884K378xAnTcQAAUMECBXhvAgC4lUvfmzyFRxXbkzExKlyokI6fOKFy99xnOg4AANq5fRPvTQAAt3LxvcmTLpHh5lEAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEvzNh0AAJBz5cnjrxZRrVWq3D1yOdO1auliLV28WE6n03Q0AABgIRRbAIARL776uopVqqH5+xyav+e0vOw21Xq4o4a1fV7TPx+mNat+Nh0RAABYBMUWAJDtXunxlg6F3qfpa+MzlqU7XVq+L1HL90mvdeiutPQ0/bp2rcGUAADAKrjGFgCQrQoUyK/gslW1cv+pq64zbO1JPf3CK9mYCgAAWBnFFgCQrdp0eEHf7Tp93fW2JfrqvvsqZUMiAABgdRRbAEC2Ci1UTMcSz153vQ1Hz+q+iGrZkAgAAFgdxRYAAAAAYGkUWwBAtoo9ekjhgbmvu94DhXJr06/cPAoAAFwfxRYAkK2+GTdGLcvmve565QNTtWnT5mxIBAAArI5iCwDIVidO/K34Xev00O23XXWd16rl05Qxw7MxFQAAsDKPeo6tzWbL+N3f399wGrgDPz8/SVJsbKzhJAAuNXzgR3rhlW7qUa2m5u9zaPeJ0/Ky21SrZKBqF7Zp+ueDeIYtAGSS0NBQSVJKSorhJHAXF3uTJ/GYYuvv769C4eGSpELh4ToWvd9wIriTkqXuptwCbmbM8KHKk2eMWkS11mPl7pYzPV2rl36rVxcvksvlMh0PADxCaGio9v+xw3QMuClPKrgeU2wBANZz5kyyJo0bazoGAACwOI8ptsnJyTp67JgKhYfr6LFjqvxAddORYJifn1/GGUqm3gAAgJzo0mOgkqXu5pgIkqSNG9aoUHi4R82Q8phiKynjC+NyuZScnGw4DQAAAOA+UlJSOEaGJHlUob2IuyIDAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACzN23QAAPBULVu3UdVHHpfD5iuf1CSN+3SgdmzfbjoWAACAx6HYAkAWaNriCeW5P1Lvr02QJHnZberb+0O9/3J7xcTEmA0HAADgYZiKDABZoFbDZpq7KyHj43SnS19uOaWoZ9qbCwUAAOChKLYAkAXSbP+eEHM88awKFCxkIA0AAIBno9gCQBY4F39cgX4+ly2rf1eQlv4w31AiAAAAz0WxBYAsMPyj/nqrSl5VKR6ofLfl0hP3hqiM86BWLF9mOhoAAIDH4eZRAJAFYmJi9HK7Vnqs8eNqcEcprflqicZu3GQ6FgAAgEei2AJAFnE4HJo7e5bpGAAAAB6PqcgAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSKLYAAAAAAEuj2AIAAAAALI1iCwAAAACwNIotAAAAAMDSvE0HAADA0/j4+Mjb21teXnbZbefPIdttNvn5+SktLU0Oh8NwQgAAPAvFFgCAG+Tt7a077iipMqXvUvHixZQvLEyhoaEKCwtV2MXfw8KUJ4//v7YNDw/X8SN/SZLOnElWTEyMYmJiFRMbq5iYWMXGxupkTIwOHjyk3Xv2at++/UpLS8vuvyIAAJZEsQUA4AqKFS2qSpUqqEyZ0ipbprRKl75Ld95RUr6+vpKkxKQkxZyMySimO3buzCiq8fEJcjgcSk9P1+CBHyokJERxcfHq+VZv+fj4KDg4KKMIh4aG6s47S6pKxAMKyxemwIAASVJqaqr+3Ldfu3fv0e49e7V79x5t2rRFh6OjTf6zAADglii2AABIKly4kGrWqK4aNaqpVo3qKl68mCTp5MkY7dq9R2vWrNO4cV9p14WiGRsbe0Oft//7/SRJKWdT9N2MWdddPzQ0VGVK36WyZUqrzIVC3alGdeXLFyZJOnjwkH5evUarVq3R6jVrdeTI0Vv8GwMA4DkotgCAHMnX11d169RWw0frq2aN6ipZ8nZJ0u/bd+j7Hxdq1ao1Wr9ho2JiYrI1V2xsrNasXac1a9ddtjwsLEwPPlBZNWtWV80a1dW29VOSpP37/9Kq1Wv048LFWrpshVJTU7M1LwAA7oBiCwDIMby8vPRQrRpq3ryZHm/8mIICA7Vn7179tHS5Vr3XX6vXrFNcXJzpmFcUExOjH35cpB9+XCRJCgkJUY3qVVWzRnU99FANPdOujRISEjR/wQ+aOWuOfl61Runp6YZTAwCQPSi2AACPFxHxgFq2aK5mTR9Xvnxh2rdvv8Z8MU6zZs/V7t17TMe7JXFxcZo3/3vNm/+9JKlMmdJq0bypWkQ2U9s2T+vkyRjNmTtf382cpV9/3WA4LQAAWYtiCwDwSD4+Pmoe2VQvdXlB5cvfq8PR0Zo67VvNnDVHW7ZuMx0v0+3evUcfDPhEHwz4RBUrlFeL5s3UvHlTderYXtu2/a6Ro8Zo1uy5PGoIAOCR7KYDAACQmYKDg/VGt1f0+5YN+uLzkTp+4m81a/6k7q3wgPr2+59Hltp/2rJ1m/r2+5/uKX+/mjV/UsdP/K0vPh+p37ds0OuvvazgoCDTEQEAyFQUWwCARyhWtKgGD/xIO3/fqB7du2nhosV6oEpNtWzVWstX/CyXy2U6YrZzuVxavuJntWzVWg9WraVFi5fozZ5vaMfvmzTokw9VtEgR0xEBAMgUFFsAgKUFBgTof+/21W/rV6vJ4400ZNgI3V3+fr32ek/t3fuH6XhuY8+evXq1Ww+Vu7eyhn46Qk2bNNZv61frvX59Mp6dCwCAVVFsAQCW5OPjo+c7ddDmjevUsUN7DR46XBUrR2jgoKE3/IzZnCg2NlYDBw1VxcoRGjJshDp1fE6bN67T8506yNubW28AAKyJYgsAsJzGjRrqlzUr9NGA/2nB9z+q0v1V9PEng3XmTLLpaJZx5kyyPv5ksO57oKq+/2GhPv7wff26dqUaN2poOhoAADeNYgsAsIyCBQvou+mTNfnrCTpw8KBq1KqrV17rrhMn/jYdzbKOHz+hl199QzVq1dWBgwc1+esJ+m76ZBUsWMB0NAAAbhjFFgBgCU+0iNQva1ao/L33qNVTbdWi5dPauWu36VgeY8fOXWrR8mm1eqqtyt97j35Zs0ItmjczHQsAgBtCsQUAuLWQkBBNnDBW48aO1tJlK1Slem0tXLTEdCyPtXDRElWpXlvLlq/U+C8/11fjv1BISIjpWAAAXBPFFgDgth5t8Ih+WbNCtWpW17PPPa8OnTorPj7edCyPFx8fr+c6vqj2HV7QQ7Vq6Jc1K/Rog0dMxwIA4KootgAAt2O32/XuO701ferX2rxlq6pUr63Zc+aZjpXjzJo9V1Wq19bmLVs1ferX6te3l+x2Dh0AAO6HdycAgFsJCgzUt9O+0Ssvd1Gfd95Tq6facnMog06c+FutnmqrPu+8p1df6arpU7/mubcAALdDsYXHCgoMNB0BwE26vURxLVm0QPdXrqQnnnxaI0aONh0JF4wYOVotW7XWgw9U1k+Lv1eJ4sVMRwJwkzgpBU9GsYXHata0ccaf8+TxN5gEwI148MH79dPiH2S321Xnkce0bPlK05HwD0uXrdDD9RrKbrfrp8U/6IEHKpuOBOA6Lj0Gimz2uMEkQNai2MJjfTVpcsafF/84X2XKlDaYBsC11K37sObPmaE9e/eqXoPG2r//L9ORcBX79/+leg0a648//9SCuTNVt+7DpiMBuIoyZUprycIFGR9femwEeBqKLXKE5JQULfpxnmrWqG46CoB/eLh2LU35eoKWLV+pZs1bcddjC4iPj1fTyCe1bPlKTfl6gmo/VNN0JAD/UKtmdS36cZ7OJCebjgJkC4otcoTIFq20adNmzZoxVVGtWpqOA+CCWjWra+rkiVr582o9076TUlNTTUfCDUpNTdUz7Ttp5c+rNW3KJNWqyYlDwF1EtWqpmd9N1caNmxTZopXpOEC28DYdIDPZbLaM3/393f+aSj8/P0lSbGys4SSe7/TpM2rZqo2GDflEY0aPULFiRfXJwCGmYwE5WvVqVTV96tdas3ad2j7TgVJrQampqWr7TAdNnfyVpk35Wi1btdaatetMxwJytDd7vqFeb/XQpK8nq9sbb8rX19d0pBwhNDRUkpSSkmI4yY252Js8iccUW39/fxUKD5ckFQoP17Ho/YYT3biSpe6m3GaDtLQ0vfTK6zpw8JD69n5LxYsX06uvdVdaWprpaECOUyXiQX077Rv9un6DWrd9TufOnTMdCbfo3LlzerpNe02fMknfTvtGLVo+pV9+XW86FpDjeHt769Nhg9Tm6Si93/9DDRryqSRRbLNBaGio9v+xw3SMW+JJBZepyMhxBg0epk4vdNWTTzTXqJHDPOo/NGAFJW8voelTJ2nT5i16qvWzOnv2rOlI+I/Onj2rqNbPaNPmLZo+dZJuL1HcdCQgR7HZbBr92ad68onm6vRC14xSC+QkHjNim5ycrKPHjqlQeLiOHjumyg+497U+fn5+GWd2rDJlwZN8+91MpaWladzY0YqLj9dbb/c1HQnIEfLk8dfkb75STEys2rRtz88/D5KSkqI2bdtr2U8/avI3X+mRBo105gw3rQGyw0cD3tcTLSL1XMcXNXvOPNNxcpxL38tKlrrbEu9tGzesUaHwcLlcLtNRMo3HFFtJGV8Yl8ulZO4Ah+uYNXuugoOCNGTwx4qJidWgwcNMRwI83qiRn6pokSKqW/8xJSYlmY6DTJaYlKSn27bX0sU/aNTIT/VM+06mIwEer0f3bnrxhY7q9npPSq0bSElJsUQP8aRCexFTkZGjjZswUe9/8JH69n5LHdo/YzoO4NFef+1lNWv6uF7o/JL27NlrOg6yyJ49e/Vil/Nf626vvmQ6DuDROj73rPr0elPv9/9Q47+aZDoOYJRHjdgCt2LQ4GEKDQ3RoIEfKi4+nrOdQBaoV6+O+vZ5Wx8PHKLvf1hoOg6y2ILvf9Qng4bonb69tG37Di1dutx0JMDjRDZrooGfDNBno8dwTS0gRmwBSVKv3v00c9YcfTZimEqVutN0HMCjhISEaMyoEVq8ZKk+/Gig6TjIJgM+HKglPy3TF6NHKiQkxHQcwKPcdVcpfTZimGbOmqPefd41HQdwCxRbQOevM3jlte46cuSIxn/5uXLlymU6EuAxPvzgPXl52fXSK9088poeXJnL5VLXl1+Tl5ddA/q/ZzoO4DFy5cqlcWNHK/pItF55rTs/V4ELKLbABcnJyXqu44sqfVcpvfduH9NxAI9Qt+7DimrVUr36vKuTJ2NMx0E2O3kyRr37vqenolqqbp3apuMAHuF/7/ZV6btK6bkOL1riJkVAdqHYApf4ffsO9e33P3V+oZMebfCI6TiApeXJ46+hgz/RihU/a8rU6abjwJDJU6Zp5cpVGjpkoPLk8TcdB7C0Rxs8ohdf6Kg+7/xP23fsNB0HcCsUW+AfxnwxTj8uXKxRI4epYMECpuMAltW715vKFxaqV7t1Nx0Fhr3arbvyhYWq19s9TUcBLCs8vKBGjRymH35cpC/GjjMdB3A7FFvgCrq89JpSUx0aPPAj01EAS7q7XFl1fqGTPvjwEx04eMh0HBj214GDGvDRQHV+oZPuLlfWdBzAkgZ98qHOnUtV15e7mY4CuCWKLXAFcXFx6tWnnxo3aqg6Dz9kOg5gOW+9+YYOHjykz8d8aToK3MToz8fq0KHDerPnG6ajAJZTt05tNW7UUL369FNcXJzpOIBbotgCVzFr9lytWr1WH3/YX97ePPIZuFF3lyurJo831sDBw5SWlmY6DtxEWlqaBg35VE2bNFa5smVMxwEsw8fHRx8NeF8/r1qj2XPmmY4DuC2KLXANb77VW3feeYeebdfGdBTAMnr2eF0HDhzU9G9nmI4CNzNt+nc6cOCgevZ43XQUwDKeaddGd955h956myc2ANdCsQWuYcfOXZo2fYZ69nhd/v7czfOivHnzqOOLXdT/09H6YNhnqv1wHdOR4CbKlS2jZk0f16AhjNbi39LS0jR46KeKbNZEZRm1Ba4rTx5/9ezeTVOnfacdO3eZjgO4NYotcB0ffjRQwcFB6vxCR9NR3MIdd96hT76cot/DamnwDl8N3e2ngo27atCosfLy8jIdD4b17PG6Dh48pKnTvjMdBW5q6rTvdPDQYfXszg1wgOt58fmOCgoK1EcfDzIdBXB7FFvgOg4dPqzJU6apU8fnuNZW0uv9PtS7K2O19+8zkqR0p0uL9iRo1rG8evEVDlRzsgIF8qvJ44306fDPGK3FVTkcDg0f/pmaNmmsAgXym44DuC1vb2916vicJk+ZpkOHD5uOA7g9ii1wA74c95XCwwvq0QaPmI5iVMUKFbQp3keOdNe/Xtt1Ill3VHzQQCq4i5ZPNJfD4dCMmbNNR4GbmzFzthwOh55oEWk6CuC2Gj5aX+HhBTVu/ETTUQBLoNgCN2D7jp1av+E3Pde+nekoRhUvWVL7E51XfT1VvtmYBu4mqlVL/bhwsRKTkkxHgZtLSEzUwkVLFNWqpekogNt6rn07/bp+g7bv2Gk6CmAJFFvgBo2fMEl16zys20sUNx3FmIP796tk4NV/bPgqNRvTwJ3cc3c53XvP3Vxbixs2ddq3Kn/vPbq7XFnTUQC3U/L2EqrzcG2NnzDJdBTAMii2wA2aPWee4uPj9ewzbU1HMWbL1q26L9ghX69//+goW8Bf+7asN5AK7iCqVUudPBmjpcuWm44Ci/hp6XLFxMQyagtcwbPPtFVcXJzmzJ1vOgpgGRRb4AadPXtWk6dOV5vWT+Xou/8Oee9t9XsoRHflzyNJ8rLb9GiZYDUPP63Phw81nA4m2Gw2PdEiUjNnzeGmUbhhaWlpmjlrjlo+0Vw2m810HMBteHl5qfXTUZo89VudPXvWdBzAMii2wE2YNXuuwsJCValSBdNRjNn35z717Pi07olZqTfuTtVrpZN1dN5wde/SSenp6abjwYC7y5VVeHhBLfj+R9NRYDHzF/yg8PCCKsczbYEM991XUWFhoZo9Z67pKICl8OwS4CZs2bJNCYmJqv1QLf322ybTcYw5ffqMxn0+2nQMuImqVasoNTVVG37baDoKLOa3jZuUmpqqqlWraMfOXabjAG6h9kO1lJCYqM2bt5qOAlgKI7bATUhPT9eqVWtU+6FapqMAbqNa1Qht2ryFKXO4aSkpKdq8ZauqVY0wHQVwG7UfqqVVP6+W03n1pxAA+DeKLXCTVqxcpYgH75e/v7/pKIBbqFa1itat+9V0DFjUunW/qlrVKqZjAG4hTx5/PfhAZa1Yucp0FMByKLbATVqx8mf5+vqqKiMMgEreXkIFCxbQWootbtHadb8qPLxgjn6UGnBR1apV5Ovrq+UrfzYdBbAcii1wk/78c5+ijxzRQzVrmI4CGFelSoScTqd+/ZVHPeHW/PrrejmdTlWpwslC4KGaNRR95Ij27dtvOgpgORRb4BZs375TpUrdaToGYNydd5RU9JGjSkxKMh0FFpWQmKgjR4/qzjtKmo4CGFeq1J36/fcdpmMAlkSxBW7BwYOHVIJpc4CKFi2iw4cPm44Bizt8OFpFixYxHQMwrkSJ4jp48JDpGIAlUWyBW3Dg4EEVL1bMdAzAuCJFCis6+ojpGLC46OgjKlKksOkYgHHFixXVgYMHTccALIliC9yCAwcOKk8ef+XLF2Y6CmDU+RHbaNMxYHHnR2yLmo4BGJU/fz75+/vrwAGKLXArKLbALbg4TYjpyMjJvLy8VCg8nBFb/GfR0UdUKLygvLy8TEcBjLl4TMFUZODWUGxxXX5+fura5QUtW/KDdm3frKWLv1eXzs8rd+7cpqMZc/DQhWJbnGKLnCu84PkicvgIxfZK7ruvkkaOGKoC+fNLkoKCgnTffZUMp3JPh6Kj5e3trfCCBU1HAYy5eInTxWOMnCh37tzq0vl5LV38vXZt36xlS35Q1y4v5OhjTtw4b9MB4N6CAgP1/YLZKlumtGw2m+x2uwoWLKD77qukp59qpUaNI3Pk3VBPnz6jtLQ03ZY3r+kogDF5bzv//Z+UA38GXE/rp6M0cvgQpaeny9v7/Futv5+fli7+Xi+98romT5lmOKF7OXXqlCQpT948hpMA5gTcdpscDofOnEk2HcWIwIAAfb9gtu4uV1aSMo45K1askHHMmZCYaDgl3Bkjtrim1159SWXLlJaXl5fs9vPfLna7XXa7XeXKltHLL3U2nNAch8Mhbx8f0zEAY3wuFDZHqsNwEvcSHBysQZ98KJvNJp9LfkbYbDbZbDYN+uRDBQcHG0zofi5+D138ngJyIm8fbzkcOffn6Ssvd1G5smUyjjOl88ecXl5eKlumtF59pavhhHB3FFtcU2SzJle95snLy0vNI5tmcyL34UhLk68vxRY518XSlpMPxK7k4dq15O/vJ5vN9q/XbDab/P399HDtWgaSua+L30M+nCxEDubr6ytHWprpGMZwzIn/imKLa0pOTpbT6bzia06nU8nJOXO6jCTZZLvqvw2QE7hcLkm6YoHLyW7k52JO/tl5JRe/hy5+TwE5kdPpzNE/TznmxH9FscU1jf1yQsZ0kH+y2+364svx2ZzIffj4eMvhyLlnVoGMUTZfX8NJ3MvSZSt09NgxpV1h5CUtLU1Hjh7V0mUrsj+YG/PxZfQfcDjScvR0/LHjrnPMOTbnHnPixlBscU1fTfpG4yZMlHT+B67D4cgoc2O/nKBvJufcG6D4+voqjYMw5GAXp8z5Mn30Mg6HQ0+3flZxcfGSLh+FjIuLV+s27Slw/+DjfaHY5uBpmIAjNVW+OfhE4dffTNXYLydI+vcx57gJEzXx68km48ECcu5pIdwQp9Op1994UxMnfqOmTRqrQMECOn7suObOW6Btv283Hc+YkJAQ2e12xcTGmo4CGBMXFydJCg0NMZzE/WzeslWV7q+iRo811NDBHytPnjyKj49Xpfur6PTpM6bjuZ2wsFBJyjgZAOREsXFx8vLyUnBwsOLjc97/BafTqe4939akryeraZPGKhheUCeOn9DceQu0ddvvpuPBAii2uCFbt/3OD5VL8BB1QIqJidXZs2dVtGgR01Hc0unTZzT92xnq904v5cmTR8kpKZTaqyhatIhSUlIUExNjOgpgzMVjittLFM+Rxfaibb9vz9GDJ7h1TEUGbsHtJc4/RP3AgYOGkwDmuFwuRUcfUZEiFFv8N0WKFFZ09BHTMQCjLh5TXDx5DuDmUGyBW1C8WDHFxcUp6dQp01EAo6Kjj6gYI7b4j4oVLaLoIxRb5GyJSUmKj49X8WJFTUcBLIliC9yCEiWK68ABpiEDh6OjVaRwYdMxYHFFChfR4cPRpmMAxh04cIgRW+AWUWyBW1CieHEdPESxBQ5HH1ExRhfwHxUtWkSHmYoM6OChQ7q9RAnTMQBLotgCN8nLy0sVK1XQ9h07TUcBjNu5c5fy5QtT4cKFTEeBRRUpXFj58oVp585dpqMAxv2+fYcqVCwvLy8v01EAy6HYAjepUqUKCgwI0PIVK01HAYxb98t6SVLVKhGGk8CqqlY9/71z8XsJyMlWrPxZQYGBqlixvOkogOVQbIGbVPuhWkpITNSWLdtMRwGMi4mJ0Z69e1WtahXTUWBR1apGaPeevYrlueCANm/eqsSkJD38UC3TUQDLodgCN6n2Q7W0atUapaenm44CuIV1635VtWoUW9yaatWqat26X0zHANxCenq6Vq1ao4cotsBNo9gCN8Hf318RD96vFStXmY4CuI21635V2TKlFRwcbDoKLCYkJERlSt+ltet+NR0FcBsrVq5SxIP3y9/f33QUwFIotsBNqF6tqnx9fbVi5c+mowBuY+3a86NtNapXNZwEVlP9wkj/xe8hAOevs82VKxczYYCbRLEFbsJTUS21Z+9e/fnnPtNRALdxODpa23fsVPPIpqajwGJaNG+m7Tt2KvoIj/oBLvrjjz+1d+8feqpVS9NRAEuh2AI3KF++MD3e+DGNnzDJdBTA7Uz/doYea9hAgQEBpqPAIgIDAtTw0fqaNv0701EAtzP+q0lq8ngjhYWFmY4CWAbFFrhBbVs/pfT0dE2bxkEY8E/ffjdTPj4+atq0sekosIhmzR6Xj4+Pvpsxy3QUwO1Mm/ad0tPT1bZ1lOkogGVQbIEbYLfb9ewzbTVz9lwlJCaajgO4nePHT2jlz6vU6kmmzuHGtHryCa1Y+bOOHz9hOgrgduITEjRr9jy1f7adbDab6TiAJVBsgRtQp05tFS9eTOMnTDQdBXBbU6d9pxrVq6pY0aKmo8DNFS9WTNWrVdVUZsAAVzX+q4kqXryY6tSpbToKYAkUW+AGvNCpg7Zt+10bN242HQVwWwu+/1GnTp3Ws8+0MR0Fbu6Zdq116tRpff/DQtNRALf122+btO337Xrx+Y6mowCWQLEFrqNKxIOq/0hdDRv+mekogFtLTk7W+AkT1anTcwoOCjIdB24qODhYnTo9p3Hjv1JycrLpOIBb+3T4Z6r/SF1FRDxgOgrg9ii2wHW826+3tm7dplmz55qOAri94SNHy8vupS5dnjcdBW6qa+fn5WX30vCRo01HAdzezFlztG3b73r3nd6mowBuj2ILXEOjxx5V1SoReu/9AXK5XKbjAG4vJiZG4ydM1AvPd1RQYKDpOHAzwUFBeuGFjho3/ivFxsaajgO4PZfLpXffH6BqVavosYYNTMcB3BrFFriK3Llza0D/97R4yVItXbbCdBzAMj4d8Zl8vL3VuTOjtrhc587Py9vLS5+OGGU6CmAZS5cu15KflmlA//eUK1cu03EAt0WxBa7i5Zc6q1ChcL3d+x3TUQBLOXkyRuMmTFLnFztxrS0yBAcF6cUXOmrc+ImKiYkxHQewlLd69VWRIoX18kudTUcB3BbFFriCe+4upx5vvKZRo7/Qn3/uMx0HsJxPh4+Uy+XS/97razoK3MT7/3tHLpdLn47gRnzAzfrzz336bNQY9XjjNd1zdznTcQC3RLEF/sHf318Txo3Rnr1/aMBHA03HASzp5MkY9Xv3fbVr21q1alY3HQeGPVSrhtq2eVrv9PufTp5ktBa4FQM+Gqi9f/yp8eM+l7+/v+k4gNuh2AL/8PGH76tw4cJ6ruOLOnfunOk4gGVNnDRZq9es06dDB8nPz890HBji5+enT4cO0qrVazXp6ymm4wCWde7cOT3X8UUVKVxEHw34n+k4gNuh2AKXaB7ZVO3atlbPt3rrjz/+NB0HsDSXy6VXu3VXoULheqvnG6bjwJC33+yu8PCCerVbd+4uD/xHf/zxp958u7eeaddGzSObmo4DuBWKLXBB8WLFNGzoQM2cNUffTJ5qOg7gEf78c58+GThEL3V9URXK32s6DrJZhfL36qWuL+rjTwZr3779puMAHuHrb6Zq1uy5GjZ0oIoXK2Y6DuA2KLaApMCAAE3+ZoIS4hP0WrcepuMAHuXTEaO0c9dujf/ycwUGBJiOg2wSGBCg8V9+rh07dmr4yNGm4wAe5dXXuishPkHffD2en6vABRRb5Hh+fn6aNnWSihQupFZPt1PSqVOmIwEeJS0tTc8821FhYaH6YsxnstlspiMhi9lsNo39YpTCwkLV7tmOSktLMx0J8ChJp06p1dPtVKxoEU2dMlG5c+c2HQkwjmKLHM3b21sTxo1RhfLl1TKqjXbt2m06EuCR9v91QM916qz6j9TV228xK8LT9Xq7hx6pV0fPdeqsvw4cNB0H8Ei7du3WE61aq2KFCpowboy8vb1NRwKMotgix7LZbPpsxFDVq/uw2j7bQRs2bDQdCfBoS5cu1/v9P9SbPV5X40YNTcdBFnm88WPq2f11/e/9AVq6dLnpOIBH27Bho9o+20GP1KujkcOHMiMGOZpHndq5+J/ZZrO5/fO9ePSFeQM+eE9Ptmyhjs934eALyCZDho1QhQrl9fmoEapb/zHt2bPXdCRkojJlSmv0Z8M1e848Df10pOk4QI6wdOlyvdD5ZX35xSjFxcepV+9+piPlaFY5xvfEkyAeU2z9/f1VKDxcklQoPFzHoq1z90U/Pz8lJyebjpFjeHt7a8igj/RMuzZ6o8fbmjlrjulIQI7S5aVXtXjhAs2eOU2NGkcyVdVDlLy9hGbPmKaDhw6p68uvmY4D5CgzZ81RcHCwBg/8UHnz5NHr3d/i2vZsdGmZ3f/HDoNJbp4nFVymIiNHue22vJo+dZKefqqVXuzyir4cN8F0JCDHOXMmWc2fiFLymWTNnzeTx1V4gBLFi2n+vJk6ffq0Ilu00pkznKwFstuX4yaoc9dX9fRTrTR96iTlzZvHdCQgW3nMiG1ycrKOHjumQuHhOnrsmCo/UN10pOu6eHYnNjbWcJKcITy8oL6bPlnFihVVi5ZPaeXPq01HAnKsEyf+1uPNntD382Zp/ryZatQ4Uoejo03Hwi0oVrSo5s+bpbMpZ/V4syf0998nTUcCcqwpU6fr6NGjmjRxnH78fq6ejGqjxMQk07E8XmxsrEqWuluSlJKSYjjNjdm4YY0KhYfL5XKZjpJpPKbYSsr4wrhcLktM7bVCRk9RtkxpTZr4pVwulxo0bMLdjwE3cOzYcTVu2kI/zJ+tBfNm6rHHI3XkyFHTsXATihQurPlzZyg9LU2PN3tCx4+fMB0JyPFWrFylRxs20bfTv9FPi79X23YdTEfKEaw2UOVJhfYipiIjR5gz+1vFnIxRvfqNKLWAGzl69JgaN2khm82mBXOZlmwlxYsV0/y5M2Sz2dS4SQsdPXrMdCQAF+zctVv16jdSbEys5s75znQcIFtQbOGxLr2Qf9myFXrs8UhGEwA3FH3kiBo3aSFJ+mnx96pcuZLhRLie+++/T0uX/CBJatykhaKPHDGcCMA/HT9+Qg0bN9OyZSsyllnljr3AraDYwmM9FdUy48+du77KzUwAN3bo8GHVrd9I+//6S9/Pm6WmTRqbjoSraNb0cS2YO1N/7tunuvUb6dDhw6YjAbiKM2eS1bnrqxkfX3psBHgaii081lcTvzYdAcBNiIuLU5NmLfX9Dws16asv1btXT496DIHV2Ww29en1piZOGKvvf1ioppFPKi4uznQsADeBYyN4Mo+6eRRwKafT8y6KBzzduXPn1KFTZ23fvkPv9O2le++5Ry92flkJiYmmo+VoQYGBGvP5SNV/pK76vdtfw4aPNB0JwC3g2AiejBFbAIDbGfrpSD0Z1VZVq0Zo7ZrlqluntulIOVbdOrW1bs0KVanyoFpGtaHUAgDcEsUWAOCWlvy0VNVqPKy9e//QrBnTNGTQx8qTx990rBwjTx5/DR38sWbNmKbde/aoWo2H9dNPy0zHAgDgiii2AAC3deTIUUW2iNIb3d9SVKuWWvPzMlWJeNB0LI9XtUqE1vy8TK2ebKnX33hTkS2ieMYwAMCtUWwBAG7N5XLpy/FfqUatOjrx99/68fs56v/+uwq47TbT0TxOwG23qf/77+qHBbN1/MQJ1ahVR+MmTDQdCwCA66LYAgAsYf9fB9SwUTO9+94H6tC+nTZv/EUdO7SXtzf3QfyvvL291bFDe23e+Is6tG+nd9/7QI81jtT+vw6YjgYAwA2h2AIALMPpdOrTEZ/pvgeq6cdFizXw4w+0bvVyNXy0vuloltXw0fpat3q5Bn78gX5ctFj3PVBNn474TE6n03Q0AABuGMUWAGA5x44d10svd1Ot2o/o6NFjmjZlkhbMm6X7KlU0Hc0y7qtUUQvmzdK0KZN05OhR1Xyonl56uZuOHTtuOhoAADeNYgsAsKzft+9Q0+ZPqsWTTyssLFTLly7U/Dkz1KD+I7LZbKbjuR2bzaZHGzyi+XNnavnShQoNDVHzlk+pWfNW2r5jp+l4AADcMootAMDyfvppmarXrKNn2ndSbr/c+nba19rwyyp1aP+M/Pz8TMczzt/fXx3aP6MNv6zS9KlfK1cuXz3TvpNq1KqrpUuXm44HAMB/RrEFAHiE9PR0zZk7X480aKx6DRpp+46dGvjJAO38faPe6fO2Spa83XTEbFey5O16p8/b2rHtNw38ZIC279ipeg0aqf6jj2vO3PlKT083HREAgEzBrSQBAB5nw4aNenbD8yperJief/45der0nN54/VVt3rxVM2fP0azZcz32uaxFChdWZGQTtYhspkqVKijp1ClN+nqyxowZp0OHD5uOBwBAlmDEFgDgsQ4eOqTefd7VXWXKq92zHXXo8GH16fWmdv6+ST9+P0cdO7RX/vz5TMf8z/Lnz6eOHdpr4Q9zteP3jerT600dOnxY7Z7tqFKl71XvPu9SagEAHo0RWwCAx0tJSdHceQs0d94C3XZbXj3W8FG1aN5MHw34nwYP/FC7du/RqlVrtGr1Gq1es05xcXGmI19TSEiIalSvqpo1qqtmzeoqW6a0HA6Hli1fqU4vdNWPCxfp1KnTpmMCAJBtKLYAgBzl1KnTmv7tDE3/doaCg4NVt05t1apZXfXqPqznOz0n6fzdlletXqP163/Trt17tG/ffjkcDiN5fXx8dMcdJVW2TGk9+OD9qlmjuu69525J0v79f2nV6jUaNHiYli5bofj4eCMZAQAwjWILAMix4uPjNWPmbM2YOVuSVLhwIdWsUV01alRTo4aPqsuLz0uSHA6H9u3/S7t379Gu3Xu0Z89e7du3XzGxsYqJiVVqaup/yuHr66uwsFCFhYbqjjtKqnTpu1S2TGmVKVNad5S8XT4+PpKkgwcP6efVazRi5GitXrPWY68TBgDgZlFsAQC44MiRo5o2/TtNm/6dpPNTfstcKJkXy2aH9s/867rcpFOnFBsTm1F04+MTlJbmUFpamgIDAiVJQYGBGvHpYHl7+yg4OCijyIaGhSrgttsu+3x//31Su3fv0cqVq/TFF+O0a/ce7d6z1+2nSAMAYArFFgCAq4iLi9Padb9o7bpfLlseEhKiEsWLKTQ09HxBvaSk5gsLU8mSJeTt7S0vu5d8c/lKOj+luFy5skpLS1NCQqJ279l7WRmOiYlVbGysDhw8RIEFAOAmUWwBALhJcXFxN1w+d27fpMKFCulkTIzqPvJYFicDACBn4nE/AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0ii2AAAAAABLo9gCAAAAACyNYgsAAAAAsDSKLQAAAADA0rxNBwAAAPiv6tSrq8datlGqdx7ZbVJ60t+a+uVobd++w3Q0AEA2oNgCAABLe/u9/ooOKKcPN8XL6TolSfLzyat2rw1QmaXfasbUyYYTAgCyGlORAQCAZTVt3lx/+pfRgl3xcrr+f3mKI11j1sfo7vqtdHuJ4uYCAgCyBcUWAABYVu3GLfTTH4lXfX3S1gS1eb5LNiYCAJhAsQUAAJZks9l01jvvNddJSHbIL7RQNiUCAJhCsQUAAAAAWBrFFgAAWJLL5VLutNPXXCfI30cpsUezKREAwBSKLQAAsKwVC2aqXqnAq77erkKQvvliVDYmAgCYQLEFAACWNXfWLN2ZvFuPlwuR3fb/y/18vPTCg2HasXi6/jpw0FxAAEC24Dm2AADA0j7s10cP162rt59so1TvPLLbpLSEE5o69BPt2LHTdDwAQDag2AIAAMtbvnSpli9dajoGAMAQpiIDAAAAACyNYgsAAAAAsDSKLQAAAADA0rjGFgDgsfz8/BQaEiyb3dx53LS0NJ09e1ZpaWkqWrSIsRwup1OxcfFKSUkxlgEAgKxCsQUAeBybzaann3pSDR+tL18fH8l2/W2ySlJSkpLPnFFaeroGDxxgLohLSnU49OPCxZoy9Vu5XC5zWQAAyGQUWwCAx3n6qSf1RPNmCgoKktFWK6l4sWLy9fVVamqqHKlpRrNILj3RvJkkafKU6WajAACQibjGFgDgUfz9/dTw0foKCgqSzWaXzWYz+it37twZv0xnsdnsCgoKUsNH68vPz8/0lwoAgExDsQUAeJSQ4ODz048Nj9S6L5t8fXwUGhJsOggAAJmGYgsA8Cg2u51Oez02Gb2hFgAAmY13NQAAAACApVFsAQAAAACWxl2RAQDIYqmpqRo8eLAmTZqkAwcOyNvbW+HhhVSrVi09+eSTypcvv+mIAABYGsUWAIAsdO7cOTVu3Fjbtm1Tp07Pq0KFigoODtbRo0e0cOFCTZs2TS+//IrpmAAAWBrFFgCA/yA+Pk5PPtlSUVFPqUOHjpKkrVu3qFOnjhox4jP98MMCrV69WuvWrZOPT66M7cLDw1W58v1yuVymogMA4DG4xhYAgP8gODhE/fq9qzFjPtfOnTt05swZ9e3bR61aRSkiIkLTp0/XI488oooVK15xe5uNWzgDAPBfMWILAMB/VKNGTUVGNlfv3r1Urlw55c7tlzG9+I8//tDDDz982fpvvNFNv/zyiySpVKlS+uqrSdmeGQAAT8KILQAAmaBbt9eVnp6uJUuW6IMPBsjX1/eq6771Vi9NnTpdTZs209mzZ7MxJQAAnoliCwBAJoiOjtbJkyflcrl09OjRjOV33nmn9uzZc9m6+fLlU7FixRQQEJDdMQEA8EgUWwAA/iOHw6E+fXqpfv366ty5i95//z3FxcVJklq1aqUlS5Zoy5YtZkMCAODBKLYAAPxHI0eO0OnTp9Wjx5t69tn2KlasuN59t58k6ZVXXlHVqlX16KOPasqUydq1a5eOHDmitWvXau3aNbLbvQynBwDA+rh5FAAA/8Fvv23Q1KlTNGbMWOXNm1eS1L9/f0VFtdJ3332rd9/tp6VLl2rw4MGaOHGiRo4cIafTqUKFCqt69epq3bqN4b8BAADWR7EFAOA/uP/+B7R+/W+XLStUqLB+/nl1xse5cuVS9+7d1bBho+yOBwBAjsBUZAAAAACApXnUiO3Fh9zbbDb5+/sbTgPT/Pz8TEcAAABwGxwb4aKLvcmTeEyx9ff3V6HwcElSofBwHYvebzgR3Imfn5+Sk5NNxwAAAMhWl5bZ/X/sMJgE7siTCi5TkQEAAAAAluYxI7bJyck6euyYCoWH6+ixY6r8QHXTkeAGLp6ljI2NNZwEAAAg+8XGxqpkqbslSSkpKYbTwF1s3LBGhcLD5XK5TEfJNB5TbCVlfGFcLhfTTiFJfB8AAIAcjxP8+CdPKrQXMRUZAAAAAGBpFFsAAAAAgKVRbAEAAAAAlkaxBQAAAABYGsUWAAA3Mn36NDVq1FBVqjyodu3aaPv2329ou0WLFuq++yrq9ddfy9qAAAC4IYotAABuYtGiRRoyZLCef/4FTZkyVaVK3aWuXbsoLi7umtsdPXpEQ4cOUaVK92VTUgAA3AvFFgCAq0hNTdXJkyeVmpqaLfubPPlrRUY2V9OmzVSy5B3q3buPcufOrblz51x1m/T0dPXu3UsvvthZRYoUzpacAAC4G496ji0AAJnB6XRq7tw5+umnJUpNTZWvr6/q1XtETZs2k92eNeeEHQ6Hdu3apfbtn8tYZrfbFRERoW3btl11uy++GKOQkBA1axapzZs3ZUk2AADcHcUWAIB/mDt3jn744fuMj1NTUzM+joxsniX7TEiIV3p6ukJCQi9bHhISqgMHDlxxm82bN2vu3DmaOnV6lmQCAMAqmIoMAMAlUlNT9dNPS6742k8//ZRt05Kv58yZM+rbt7f69n1HwcHBpuMAAGAUI7YAAFwiMTHxquU1NfWcEhMTlS9fvkzfb1BQsLy8vBQXF3vZ8ri4WIWGhv1r/ejowzp69Khee+3VjGVOp1OS9MADlTVr1hwVLVo003MCAOCOKLYAAFwiMDBQvr6+Vyy3vr65FBgYmCX79fHxUdmyZbV+/Xo9/HAdSeeL6vr169WqVdS/1i9R4nZ9++2My5aNGjVSZ84kq0ePnipYsGCW5AQAwB1RbAEAuMTFG0Vdeo3tRfXq1ZOvr2+W7bt167bq16+vypUrp7vvvkdTpkxWSkqKmjRpKknq27eP8ufPr5dffkW5cuXSnXfeedn2t912myT9azkAAJ6OYgsAwD80bdpM0sVras/J1zeX6tWrl7E8qzRo0EDx8fEaPXq0YmNjVLp0aY0cOUqhoedvKHX8+DHZ7bYszQAAgBVRbAEA+Ae73a7IyOZq1KixEhMTM6YnZ4eoqChFRf176rEkjR077prbvvfe+1kRCQAAt0exBQDgKnx9fbPkRlEAACBz8bgfAAAAAIClUWwBAAAAAJZGsQUAAAAAWBrFFgAAAABgaRRbAAAAAIClUWwBAAAAAJZGsQUAAAAAWBrFFgAAAABgaRRbAAAAAICleZsOAAAA/t/06dM0adJExcbG6q677lLPnm/qnnvuveK68+bN1bvv9rtsma+vr375ZX12RAUAwG1QbAEAuIq0tDSlpKTIz89P3t5Z/5a5aNEiDRkyWL169da9996ryZMnq2vXLpo9e65CQkKuuE3evHk1a9acjI9tNluW5wQAwN1QbAEA+IfExETNnz9Pa9eukcPhkI+Pj6pVq64mTZooICAwy/Y7efLXioxsrqZNm0mSevfuo9WrV2nu3Dlq3/65q24XFhaWZZkAALACrrEFAOASiYmJGjCgv1at+lkOh0OS5HA4tGrVz/rgg/5KTEzMkv06HA7t2rVLERERGcvsdrsiIiK0bdu2q26XkpKixx5rqIYNG6hbt9e0b9+fWZIPAAB3RrEFAOAS8+fPU0JCgpxO52XLnU6nEhISNH/+vCzZb0JCvNLT0xUSEnrZ8pCQUMXGxlxxm+LFS6hfv3c1dOhQ9e//gZxOp9q3f1YnTpzIkowAALgrii0AABekpaVp7do1/yq1FzmdTq1du1ZpaWnZnOzKKlSooMaNH1fp0mVUufL9GjRosIKCgjVz5gzT0QAAyFYUWwAALkhJScmYfnw1DkeqUlJSMn3fQUHB8vLyUlxc7GXL4+JiFRp6Y9fQ+vj4qEyZ0jp8+HCm5wMAwJ1RbAEAuMDPz08+Pj7XXMfHx1d+fn6Zvm8fHx+VLVtW69f//6N6nE6n1q9fr/Lly9/Q50hPT9eff/7JzaQAADkOxRYAgAu8vb1VrVp12e1Xfnu02+2qVq1alj36p3Xrtpo9e5bmz5+n/fv3a8CAD5SSkqImTZpKkvr27aMRI4ZnrP/FF2O0bt1aRUdHa9euXerTp7eOHTumyMjILMkHAIC74nE/AABcokmTJvr9923/uoGU3W5XUFCQmjRpkmX7btCggeLj4zV69GjFxsaodOnSGjlylEJDz99Q6vjxY7Lb//85tUlJSXr//fcVGxujgIAAlS1bVhMmTFTJkndkWUYAANwRxRYAgEsEBASqV68+F55ju1YOR6p8fHxVrVq1LH+OrSRFRUUpKirqiq+NHTvuso+7d++h7t17ZGkeAACsgGILAMA/BAYGqk2btoqKekopKSny8/PLsunHAADgv+NdGgCAq/D29tZtt91mOgYAALgObh4FAAAAALA0ii0AAAAAwNIotgAAAAAAS6PYAgAAAAAsjWILAAAAALA0ii0AAAAAwNIotgAAAAAAS6PYAgAAAAAsjWILAIAbmT59mho1aqgqVR5Uu3ZttH3779dc/9SpJH344QDVr19PEREPqFmzJlq9elU2pQUAwD14mw4AAIC7OXv2rH799RetW7dWSUlJCggIUNWq1RQRUUW5c+fOsv0uWrRIQ4YMVq9evXXvvfdq8uTJ6tq1i2bPnquQkJB/re9wONS584sKCQnRJ58MVP78+XXs2DHddtttWZYRAAB3RLEFAOASx44d05Ahg5SQkCCbzSaXy6WYmBjt27dPCxbM1+uvd1d4eHiW7Hvy5K8VGdlcTZs2kyT17t1Hq1ev0ty5c9S+/XP/Wn/u3DlKSkrShAkT5ePjI0kqVKhwlmQDAMCdMRUZAIALzp49qyFDBikpKUmS5HK5Lvs9KSlJQ4YM0tmzZzN93w6HQ7t27VJERETGMrvdroiICG3btu2K26xcuUL33lteH330oerVq6OWLVto3LgvlZ6enun5AABwZxRbAAAu+PXXX5SQkCCn03nF151OpxISErR+/a+Zvu+EhHilp6crJCT0suUhIaGKjY254jZHjhzR0qU/yel0avjwkerY8Xl9883X+vLLsZmeDwAAd0axBQDggnXr1spms11zHZvNprVr12RTomtzOp0KCQlRnz59Va5cOTVo0EAdOnTUzJkzTEcDACBbcY0tAAAXJCUlZUw7vhqXy5UxVTkzBQUFy8vLS3FxsZctj4uLVWho2BW3CQvLJ29vb3l5eWUsu/322xUTEyOHw5Fx3S0AAJ6OEVsAAC4ICAi4oRHbgICATN+3j4+PypYtq/Xr12csczqdWr9+vcqXL3/FbSpUqKDDhw9dNnX64MGDCgvLR6kFAOQoFFsAAC6oWrXaDY3YVqtWPUv237p1W82ePUvz58/T/v37NWDAB0pJSVGTJk0lSX379tGIEcMz1m/Z8kklJSVp4MBPdPDgQa1a9bPGjx+nJ598MkvyAQDgrpiKDADABRERVbRgwXwlJSVd8QZSdrtdAQEBevDBiCts/d81aNBA8fHxGj16tGJjY1S6dGmNHDlKoaHnbyh1/Pgx2e3/P6JcsGBBjRw5SoMHD1KrVi2VP39+PfXU03r22fZZkg8AAHdFsQUA4ILcuXPr9de7/+s5thd/DwgI0Ouvd1fu3LmzLENUVJSioqKu+NrYseP+taxChQqaNOnrLMsDAIAVUGwBALhEeHi43n//A61f/6vWrl2jpKQkBQQEqFq16nrwwYgsLbUAAODWUGwBAPiH3Llzq1ath1Sr1kOmowAAgBvAzaMAAAAAAJZGsQUAAAAAWBrFFgAAAABgaRRbAAAAAIClUWwBAAAAAJZGsQUAAAAAWBrFFgAAAABgaRRbAAAAAICleZsOAACAO4qNjdWWLVuUnHxG/v55VLFiRYWGhmb5fqdPn6ZJkyYqNjZWd911l3r2fFP33HPvFdft1KmDNm7c+K/lNWrU0PDhI7M6KgAAboNiCwDAJRITE/XNN5O0detWSZLdbpfT6dT06VNVoUIFtWnTToGBgVmy70WLFmnIkMHq1au37r33Xk2ePFldu3bR7NlzFRIS8q/1Bw0aIofDcUn2BEVFtVK9eo9kST4AANwVU5EBALggISFBAwb017Zt2+RyueRyuZSenp7x523btmnAgP5KTEzMkv1Pnvy1IiObq2nTZipZ8g717t1HuXPn1ty5c664fmBgoMLCwjJ+/fLLL8qdO7ceeaR+luQDAMBdUWwBALhg8uSvlZCQIKfTecXXnU6nEhIS9M03kzJ93w6HQ7t27VJERETGMrvdroiICG3btu2GPsfcuXNUv34D+fn5ZXo+AADcGcUWAACdv6Z269atVy21FzmdTm3dulVxcXGZuv+EhHilp6crJOTy63hDQkIVGxtz3e23b/9df/75pyIjIzM1FwAAVkCxBQBA0pYtW25q/c2bN2dNkFs0Z84c3XlnqaveaAoAAE9GsQUAQFJy8hnZ7Tf2tmi325WcfCZT9x8UFCwvLy/FxcVetjwuLlahoWHX3DYlJUWLFy9Ss2bNMjUTAABWQbEFAECSv3+e605DvsjpdMrfP0+m7t/Hx0dly5bV+vXrL9vP+vXrVb58+Wtuu2TJYqWmpuqxxxplaiYAAKyCYgsAgKSKFSve1PqVKlXK9AytW7fV7NmzNH/+PO3fv18DBnyglJQUNWnSVJLUt28fjRgx/F/bzZkzR7VrP6ygoKBMzwQAgBXwHFsAACSFhoaqQoUK2rZt2zVHbu12u8qXL3/F58r+Vw0aNFB8fLxGjx6t2NgYlS5dWiNHjlJo6PkbSh0/fkx2u+2ybQ4cOKAtWzZr1KjRmZ4HAACroNgCAHBBmzbtNGBA/6s+8sdutysoKEht2rTLsgxRUVGKioq64mtjx47717ISJUpo06YtWZYHAAArYCoyAAAXBAYGqlevPipfvrxsNptsNpu8vLwy/ly+fHn16tVHgYGBpqMCAIBLMGILAMAlAgMD1bXry4qLi9PmzZuVnHxG/v55VKlSpSyZfgwAAP47ii0AAFcQEhKiunXrmo4BAABuAFORAQAAAACWRrEFAAAAAFgaxRYAAAAAYGkUWwAAAACApVFsAQAAAACWRrEFAAAAAFgaxRYAgKtwOBw6ffq0HA6H6SgAAOAabAHBBVymQ2SWk8cPydfXV+np6Tp+4oTpOAAAA9LS0pSUlKTixYopd+7cN719enq61qxZoxkzZmjjxo1yuVyy2WyqXLmynnjiCVWvXl1eXl43/Pl8fHxks9nkcrluqCCPHj1aQ4cO1fHjx1W+fHkNHTpUDzzwwFXXHz58uL744gsdPnxYYWFhioyMVP/+/a/6dz979qwOHjqkgIAAeXvzOHsAyIkKFiggLy8vpaamKl/BYqbjZAqPeke7eKDh5eWlwoUKGU4DADDh7NmzSj5zRr6+vvL19b2pbc+cOaMePXpo/fr18vLykst1/tyvy+XS5s2b9dtvv+nBBx/UwIEDlSdPnpv63Dab7bp5pk+frp49e+rzzz9XRESEhg0bpsaNG2vPnj3Knz//v9afMmWK+vTpo/Hjx6tatWrau3evnn32WXl7e2vIkCFX3IfT6ZS3l5cK5M9/S8UfAOA5buZErbvzqBHbY9H7lStXLqWnp+tkTIzpOAAAA251xDY9PV3dunXTpk2b5HQ6r7qe3W5X5cqVNWTIkBs6IPD29s4YsU1LS7vmujVq1FDlypX16aefSjpfQu+44w516dJFPXr0+Nf6r776qnbv3q1FixZlLOvZs6c2bNig5cuXX3EfjNgCAPKFhcnLy0vnzp1TeJGSpuNkCo96R/OULwoA4NYVLVpEgwcOkCM1TTab7Ya327Ll/Ijs9TidTm3YsEHTpn2rihUr/oekl3M4HNq0aZOiop7Sjh27Mpbfd999WrLkJz32WON/bVO0aDF98803mj79W91zz72Kjo7W3Lnz1KhRo8s+x6VcLpdOxvytp1o/q8OHozMtPwAAJnlUsQUA4FYtW7ZUdrv9mqO1F9ntdi1btjRTi21CQrzS09MVEhJ62fKQkFAdOHDgits0bPiYEhIS9Nxz7SWdH61+4omW6tChY6blAgDACrgrMgAgx3M4HNq1a9cNlVrp/Kjtrl07rzu1OKv99tsGjR8/Tm+/3UuTJ0/VoEFDtHr1Ko0d+4XRXAAAZDdGbAEAOd65c+duabuzZ88qb968mZIhKChYXl5eiouLvWx5XFysQkPDrrjNqFGj9NhjjRQZ2VySVKpUKaWkpOiDD95Xhw4dZbdz/hoAkDPwjgcAyPFy5cp1S9tl5l2FfXx8VLZsWa1fvz5jmdPp1Pr161W+fPkrbnP27Nl/lVcvr/MfX7yjMwAAOQHFFgCQ410slTc6wmm321W2bLlMv6tw69ZtNXv2LM2fP0/79+/XgAEfKCUlRU2aNJUk9e3bRyNGDM9Yv1atWpox4zstWrRQR44c0S+/rNOoUaNUs2Ytj3qEAwAA18NUZAAAJNWpU1e7dl35TsL/5HQ6VadO3UzP0KBBA8XHx2v06NGKjY1R6dKlNXLkKIWGnr+h1PHjx2S3//+dnjt27CSbzabPPvtMJ0/+reDgYNWsWUsvvfRSpmcDAMCdedRzbAEAuPi4n3xh+W/qcT9Op1PDhg3V7t275XJd/SZSNptdZcuW0auvdrPkNawXH/fzRo9ePO4HAOAxrPeODABAFrDb7erSpYvKlCmT8fE/X5eksmXLqHPnrpYstQAAeCqmIgMAcEHu3H567bVu2rZtm5YtW6pdu3ZmvFa6dBnVqVNX5cuXp9QCAOBmKLYAAFzCbrerYsWKqlixotLS0nT27Fnlzp07028UBQAAMg/v0gAAXIW3t3emPacWAABkHeZSAQA8isvplLgt4rW5Lvw7AQDgISi2AACPEhcfr1SHQ7Tbq3Ep1eFQbFy86SAAAGQaii0AwKMkJ6fox4WLlZCQIJfLKZfLxa+MX04lJCTox4WLlZKSYvpLBQBApuEaWwCAx5ky9VtJUsNH68vXx0e68cfZei6XlOpw6MeFizP+fQAA8BS2gOACzNUCAHgkPz8/hYYEy8bjeeRyOhUbF89ILQDAI1FsAQAAAACWxilsAAAAAIClUWwBAAAAAJZGsQUAAAAAWBrFFgAAAABgaRRbAAAAAIClUWwBAAAAAJZGsQUAAAAAWBrFFgAAAABgaRRbAAAAAIClUWwBAAAAAJZGsQUAAAAAWBrFFgAAAABgaRRbAAAAAIClUWwBAAAAAJb2fyINLv4bWxa1AAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 1200x700 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data = pd.DataFrame({\n",
    "    \"X\": [0.5, 0.3, 0.7, 0.9, 0.4],\n",
    "    \"Y\": [0.6, 0.4, 0.2, 0.8, 0.5],\n",
    "    \"xG\": [0.7, 0.5, 0.6, 0.8, 0.4]\n",
    "})\n",
    "\n",
    "pitch_width = 105  \n",
    "pitch_length = 68  \n",
    "background_color = \"#0E1117\"  \n",
    "line_color = \"white\"  \n",
    "line_width = 2.0  \n",
    "\n",
    "\n",
    "ax = create_full_pitch(x_lims=[0, 1.15], y_lims=[0, 0.74], background_color=background_color, line_color=line_color, line_width=line_width)\n",
    "sns.scatterplot(x=\"X\", y=\"Y\", data=data, size=\"xG\", ax=ax)\n",
    "\n",
    "plt.show()\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}