RA- Dump Notebook .ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "8cc87e2b",
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d4f94376",
   "metadata": {},
   "outputs": [],
   "source": [
    "from opti_recruit.data import get_data, clean_data\n",
    "import opti_recruit.feature_engineering as fe\n",
    "import opti_recruit.get_team_features as gtf\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3d14ec0a",
   "metadata": {},
   "outputs": [],
   "source": [
    "! pwd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0f6366b7",
   "metadata": {},
   "outputs": [],
   "source": [
    "! cd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8d702044",
   "metadata": {},
   "outputs": [],
   "source": [
    "! ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d45cbbac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys([17, 18, 19, 20, 21, 22])"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs = get_data()\n",
    "dfs.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b7840c12",
   "metadata": {},
   "outputs": [],
   "source": [
    "df22 = dfs[22]\n",
    "df21 = dfs[21]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7704a99f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df22_new = fe.add_features(df22)\n",
    "df21_new = fe.add_features(df21)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "3425d0d4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['sofifa_id', 'short_name', 'player_positions', 'overall', 'potential',\n",
       "       'value_eur', 'wage_eur', 'age', 'height_cm', 'weight_kg',\n",
       "       'club_team_id', 'club_name', 'league_name', 'league_level',\n",
       "       'club_position', 'club_joined', 'club_contract_valid_until',\n",
       "       'nationality_name', 'nation_team_id', 'preferred_foot', 'weak_foot',\n",
       "       'skill_moves', 'international_reputation', 'work_rate', 'body_type',\n",
       "       'release_clause_eur', 'player_tags', 'player_traits', 'pace',\n",
       "       'shooting', 'passing', 'dribbling', 'defending', 'physic',\n",
       "       'attacking_crossing', 'attacking_finishing',\n",
       "       'attacking_heading_accuracy', 'attacking_short_passing',\n",
       "       'attacking_volleys', 'skill_dribbling', 'skill_curve',\n",
       "       'skill_fk_accuracy', 'skill_long_passing', 'skill_ball_control',\n",
       "       'movement_acceleration', 'movement_sprint_speed', 'movement_agility',\n",
       "       'movement_reactions', 'movement_balance', 'power_shot_power',\n",
       "       'power_jumping', 'power_stamina', 'power_strength', 'power_long_shots',\n",
       "       'mentality_aggression', 'mentality_interceptions',\n",
       "       'mentality_positioning', 'mentality_vision', 'mentality_penalties',\n",
       "       'mentality_composure', 'defending_marking_awareness',\n",
       "       'defending_standing_tackle', 'defending_sliding_tackle', 'is_bench',\n",
       "       'potential_diff', 'att_rate', 'def_rate', 'age_bin', 'prefered_pos',\n",
       "       'player_pos', 'new_nationality'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df22_new.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "67956481",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[17, 18, 19, 20, 21, 22]\n"
     ]
    }
   ],
   "source": [
    "listing=list(dfs)\n",
    "print(listing)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "fe9e63a9",
   "metadata": {},
   "outputs": [],
   "source": [
    "teams_avg = ['df22_team','df21_team']\n",
    "team_pos = ['df22_team_pos','df21_team_pos']\n",
    "team_start = ['df22_team_start','df21_team_start']\n",
    "frames = [df22_new,df21_new]\n",
    "\n",
    "d_avg = {teams_avg[i]: frames[i] for i in range(0,2)}\n",
    "d_avg_pos = {team_pos[i]: frames[i] for i in range(0,2)}\n",
    "d_avg_start = {team_start[i]: frames[i] for i in range(0,2)}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "97fa130c",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'df22_team':        sofifa_id          short_name player_positions  overall  potential  \\\n",
       " 0         158023            L. Messi       RW, ST, CF       93         93   \n",
       " 1         188545      R. Lewandowski               ST       92         92   \n",
       " 2          20801   Cristiano Ronaldo           ST, LW       91         91   \n",
       " 3         190871           Neymar Jr          LW, CAM       91         91   \n",
       " 4         192985        K. De Bruyne          CM, CAM       91         91   \n",
       " ...          ...                 ...              ...      ...        ...   \n",
       " 19234     261962           Song Defu              CDM       47         52   \n",
       " 19235     262040           C. Porter               CM       47         59   \n",
       " 19236     262760            N. Logue               CM       47         55   \n",
       " 19237     262820           L. Rudden               ST       47         60   \n",
       " 19238     264540  E. Lalchhanchhuaha              CAM       47         60   \n",
       " \n",
       "          value_eur  wage_eur  age  height_cm  weight_kg  ...  \\\n",
       " 0       78000000.0  320000.0   34        170         72  ...   \n",
       " 1      119500000.0  270000.0   32        185         81  ...   \n",
       " 2       45000000.0  270000.0   36        187         83  ...   \n",
       " 3      129000000.0  270000.0   29        175         68  ...   \n",
       " 4      125500000.0  350000.0   30        181         70  ...   \n",
       " ...            ...       ...  ...        ...        ...  ...   \n",
       " 19234      70000.0    1000.0   22        180         64  ...   \n",
       " 19235     110000.0     500.0   19        175         70  ...   \n",
       " 19236     100000.0     500.0   21        178         72  ...   \n",
       " 19237     110000.0     500.0   19        173         66  ...   \n",
       " 19238     110000.0     500.0   19        167         61  ...   \n",
       " \n",
       "        defending_standing_tackle defending_sliding_tackle is_bench  \\\n",
       " 0                             35                       24    False   \n",
       " 1                             42                       19    False   \n",
       " 2                             32                       24    False   \n",
       " 3                             32                       29    False   \n",
       " 4                             65                       53    False   \n",
       " ...                          ...                      ...      ...   \n",
       " 19234                         43                       48     True   \n",
       " 19235                         44                       47     True   \n",
       " 19236                         44                       48     True   \n",
       " 19237                         14                       11     True   \n",
       " 19238                         31                       37     True   \n",
       " \n",
       "        potential_diff att_rate def_rate   age_bin prefered_pos  player_pos  \\\n",
       " 0                   0   Medium      Low     30-34           RW         ATT   \n",
       " 1                   0     High   Medium     30-34           ST         ATT   \n",
       " 2                   0     High      Low   Over 34           ST         ATT   \n",
       " 3                   0     High   Medium     25-29           LW         ATT   \n",
       " 4                   0     High     High     30-34           CM         MID   \n",
       " ...               ...      ...      ...       ...          ...         ...   \n",
       " 19234               5   Medium   Medium     20-24          CDM         MID   \n",
       " 19235              12   Medium   Medium  Below 20           CM         MID   \n",
       " 19236               8   Medium   Medium     20-24           CM         MID   \n",
       " 19237              13   Medium   Medium  Below 20           ST         ATT   \n",
       " 19238              13   Medium   Medium  Below 20          CAM         MID   \n",
       " \n",
       "            new_nationality  \n",
       " 0                Argentina  \n",
       " 1                   Poland  \n",
       " 2                 Portugal  \n",
       " 3                   Brazil  \n",
       " 4                   Others  \n",
       " ...                    ...  \n",
       " 19234             China PR  \n",
       " 19235  Republic of Ireland  \n",
       " 19236  Republic of Ireland  \n",
       " 19237  Republic of Ireland  \n",
       " 19238               Others  \n",
       " \n",
       " [19239 rows x 71 columns],\n",
       " 'df21_team':        sofifa_id         short_name player_positions  overall  potential  \\\n",
       " 0         158023           L. Messi       RW, ST, CF       93         93   \n",
       " 1          20801  Cristiano Ronaldo           ST, LW       92         92   \n",
       " 2         188545     R. Lewandowski               ST       91         91   \n",
       " 3         190871          Neymar Jr          LW, CAM       91         91   \n",
       " 4         192985       K. De Bruyne          CAM, CM       91         91   \n",
       " ...          ...                ...              ...      ...        ...   \n",
       " 18939     257710     Zhang Mengxuan               CB       47         52   \n",
       " 18940     257933      Huang Wenzhou               CM       47         53   \n",
       " 18941     257936           Song Yue               CM       47         47   \n",
       " 18942     258736        V. Da Silva               ST       47         67   \n",
       " 18943     258760           B. Hough               CM       47         67   \n",
       " \n",
       "          value_eur  wage_eur  age  height_cm  weight_kg  ...  \\\n",
       " 0      103500000.0  560000.0   33        170         72  ...   \n",
       " 1       63000000.0  220000.0   35        187         83  ...   \n",
       " 2      111000000.0  240000.0   31        184         80  ...   \n",
       " 3      132000000.0  270000.0   28        175         68  ...   \n",
       " 4      129000000.0  370000.0   29        181         70  ...   \n",
       " ...            ...       ...  ...        ...        ...  ...   \n",
       " 18939      70000.0    1000.0   21        177         70  ...   \n",
       " 18940      70000.0    1000.0   21        174         68  ...   \n",
       " 18941      45000.0    2000.0   28        185         79  ...   \n",
       " 18942     130000.0     500.0   17        171         58  ...   \n",
       " 18943     130000.0     500.0   17        175         65  ...   \n",
       " \n",
       "        defending_standing_tackle defending_sliding_tackle is_bench  \\\n",
       " 0                             35                       24    False   \n",
       " 1                             32                       24    False   \n",
       " 2                             42                       19    False   \n",
       " 3                             30                       29    False   \n",
       " 4                             65                       53    False   \n",
       " ...                          ...                      ...      ...   \n",
       " 18939                         56                       47     True   \n",
       " 18940                         42                       53     True   \n",
       " 18941                         43                       45     True   \n",
       " 18942                         11                       13     True   \n",
       " 18943                         44                       40     True   \n",
       " \n",
       "        potential_diff att_rate def_rate   age_bin prefered_pos  player_pos  \\\n",
       " 0                   0   Medium      Low     30-34           RW         ATT   \n",
       " 1                   0     High      Low   Over 34           ST         ATT   \n",
       " 2                   0     High   Medium     30-34           ST         ATT   \n",
       " 3                   0     High   Medium     25-29           LW         ATT   \n",
       " 4                   0     High     High     25-29          CAM         MID   \n",
       " ...               ...      ...      ...       ...          ...         ...   \n",
       " 18939               5      Low      Low     20-24           CB         DEF   \n",
       " 18940               6      Low      Low     20-24           CM         MID   \n",
       " 18941               0      Low      Low     25-29           CM         MID   \n",
       " 18942              20   Medium   Medium  Below 20           ST         ATT   \n",
       " 18943              20   Medium   Medium  Below 20           CM         MID   \n",
       " \n",
       "       new_nationality  \n",
       " 0           Argentina  \n",
       " 1            Portugal  \n",
       " 2              Poland  \n",
       " 3              Brazil  \n",
       " 4              Others  \n",
       " ...               ...  \n",
       " 18939        China PR  \n",
       " 18940        China PR  \n",
       " 18941        China PR  \n",
       " 18942         England  \n",
       " 18943         England  \n",
       " \n",
       " [18944 rows x 71 columns]}"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d_avg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "5639b409",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in d_avg.keys():\n",
    "    vars()[df] = d_avg[df].groupby(['club_name'])[['value_eur','overall','potential']].mean() \\\n",
    "        .reset_index() \\\n",
    "        .add_suffix('_mean') \\\n",
    "        .rename(columns={\"club_name_mean\": \"club_name\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "66ec5662",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>club_name</th>\n",
       "      <th>value_eur_mean</th>\n",
       "      <th>overall_mean</th>\n",
       "      <th>potential_mean</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1. FC Heidenheim 1846</td>\n",
       "      <td>1.349333e+06</td>\n",
       "      <td>66.266667</td>\n",
       "      <td>71.433333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1. FC Kaiserslautern</td>\n",
       "      <td>8.403571e+05</td>\n",
       "      <td>62.785714</td>\n",
       "      <td>68.821429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>4.252500e+06</td>\n",
       "      <td>70.266667</td>\n",
       "      <td>76.700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1. FC Magdeburg</td>\n",
       "      <td>6.175926e+05</td>\n",
       "      <td>62.074074</td>\n",
       "      <td>68.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1. FC Nürnberg</td>\n",
       "      <td>1.790500e+06</td>\n",
       "      <td>66.833333</td>\n",
       "      <td>72.866667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>Örebro SK</td>\n",
       "      <td>5.523077e+05</td>\n",
       "      <td>60.884615</td>\n",
       "      <td>65.692308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>Östersunds FK</td>\n",
       "      <td>5.520370e+05</td>\n",
       "      <td>60.814815</td>\n",
       "      <td>66.259259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>İstanbul Başakşehir FK</td>\n",
       "      <td>4.541667e+06</td>\n",
       "      <td>71.433333</td>\n",
       "      <td>74.466667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>İttifak Holding Konyaspor</td>\n",
       "      <td>1.405769e+06</td>\n",
       "      <td>68.230769</td>\n",
       "      <td>70.307692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Śląsk Wrocław</td>\n",
       "      <td>7.040741e+05</td>\n",
       "      <td>63.148148</td>\n",
       "      <td>68.703704</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>681 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     club_name  value_eur_mean  overall_mean  potential_mean\n",
       "0        1. FC Heidenheim 1846    1.349333e+06     66.266667       71.433333\n",
       "1         1. FC Kaiserslautern    8.403571e+05     62.785714       68.821429\n",
       "2                   1. FC Köln    4.252500e+06     70.266667       76.700000\n",
       "3              1. FC Magdeburg    6.175926e+05     62.074074       68.000000\n",
       "4               1. FC Nürnberg    1.790500e+06     66.833333       72.866667\n",
       "..                         ...             ...           ...             ...\n",
       "676                  Örebro SK    5.523077e+05     60.884615       65.692308\n",
       "677              Östersunds FK    5.520370e+05     60.814815       66.259259\n",
       "678     İstanbul Başakşehir FK    4.541667e+06     71.433333       74.466667\n",
       "679  İttifak Holding Konyaspor    1.405769e+06     68.230769       70.307692\n",
       "680              Śląsk Wrocław    7.040741e+05     63.148148       68.703704\n",
       "\n",
       "[681 rows x 4 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df21_team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "75068fb8",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in d_avg_pos.keys():\n",
    "    vars()[df]  = d_avg_pos[df].groupby(['club_name','player_pos'])[['value_eur','overall','potential']] \\\n",
    "        .mean() \\\n",
    "        .reset_index() \\\n",
    "        .pivot(index='club_name',columns='player_pos',values=['value_eur','overall','potential'])\n",
    "    vars()[df].columns = list(map(\"_\".join, vars()[df].columns))\n",
    "    vars()[df] = vars()[df].rename(columns={\"club_name_\": \"club_name\"}).reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "2931347a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>club_name</th>\n",
       "      <th>value_eur_ATT</th>\n",
       "      <th>value_eur_DEF</th>\n",
       "      <th>value_eur_GK</th>\n",
       "      <th>value_eur_MID</th>\n",
       "      <th>overall_ATT</th>\n",
       "      <th>overall_DEF</th>\n",
       "      <th>overall_GK</th>\n",
       "      <th>overall_MID</th>\n",
       "      <th>potential_ATT</th>\n",
       "      <th>potential_DEF</th>\n",
       "      <th>potential_GK</th>\n",
       "      <th>potential_MID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1. FC Heidenheim 1846</td>\n",
       "      <td>1.287500e+06</td>\n",
       "      <td>1.789286e+06</td>\n",
       "      <td>8.825000e+05</td>\n",
       "      <td>1.284615e+06</td>\n",
       "      <td>65.666667</td>\n",
       "      <td>68.571429</td>\n",
       "      <td>63.250000</td>\n",
       "      <td>66.230769</td>\n",
       "      <td>70.333333</td>\n",
       "      <td>73.142857</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>71.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1. FC Kaiserslautern</td>\n",
       "      <td>9.062500e+05</td>\n",
       "      <td>8.225000e+05</td>\n",
       "      <td>6.750000e+05</td>\n",
       "      <td>8.553571e+05</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>62.625000</td>\n",
       "      <td>59.500000</td>\n",
       "      <td>62.714286</td>\n",
       "      <td>67.500000</td>\n",
       "      <td>68.125000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>69.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>4.216667e+06</td>\n",
       "      <td>3.352273e+06</td>\n",
       "      <td>4.516667e+06</td>\n",
       "      <td>4.961538e+06</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>68.272727</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>71.846154</td>\n",
       "      <td>74.666667</td>\n",
       "      <td>76.000000</td>\n",
       "      <td>76.666667</td>\n",
       "      <td>77.769231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1. FC Magdeburg</td>\n",
       "      <td>5.750000e+05</td>\n",
       "      <td>6.750000e+05</td>\n",
       "      <td>5.833333e+05</td>\n",
       "      <td>5.875000e+05</td>\n",
       "      <td>62.750000</td>\n",
       "      <td>62.700000</td>\n",
       "      <td>60.333333</td>\n",
       "      <td>61.700000</td>\n",
       "      <td>65.750000</td>\n",
       "      <td>68.600000</td>\n",
       "      <td>69.666667</td>\n",
       "      <td>67.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1. FC Nürnberg</td>\n",
       "      <td>1.437500e+06</td>\n",
       "      <td>1.442500e+06</td>\n",
       "      <td>1.110000e+06</td>\n",
       "      <td>2.622500e+06</td>\n",
       "      <td>66.500000</td>\n",
       "      <td>66.200000</td>\n",
       "      <td>67.250000</td>\n",
       "      <td>67.500000</td>\n",
       "      <td>71.333333</td>\n",
       "      <td>72.400000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>74.600000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>Örebro SK</td>\n",
       "      <td>5.333333e+05</td>\n",
       "      <td>4.762500e+05</td>\n",
       "      <td>3.750000e+05</td>\n",
       "      <td>6.916667e+05</td>\n",
       "      <td>61.333333</td>\n",
       "      <td>61.000000</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>61.777778</td>\n",
       "      <td>64.500000</td>\n",
       "      <td>64.500000</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>68.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>Östersunds FK</td>\n",
       "      <td>5.750000e+05</td>\n",
       "      <td>6.083333e+05</td>\n",
       "      <td>2.783333e+05</td>\n",
       "      <td>5.844444e+05</td>\n",
       "      <td>61.333333</td>\n",
       "      <td>62.333333</td>\n",
       "      <td>59.666667</td>\n",
       "      <td>60.666667</td>\n",
       "      <td>67.333333</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>66.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>İstanbul Başakşehir FK</td>\n",
       "      <td>4.995000e+06</td>\n",
       "      <td>3.252083e+06</td>\n",
       "      <td>2.566667e+06</td>\n",
       "      <td>6.455000e+06</td>\n",
       "      <td>70.800000</td>\n",
       "      <td>71.333333</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>74.400000</td>\n",
       "      <td>74.250000</td>\n",
       "      <td>73.333333</td>\n",
       "      <td>75.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>İttifak Holding Konyaspor</td>\n",
       "      <td>7.875000e+05</td>\n",
       "      <td>1.038636e+06</td>\n",
       "      <td>6.875000e+05</td>\n",
       "      <td>2.015909e+06</td>\n",
       "      <td>65.500000</td>\n",
       "      <td>67.272727</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>65.500000</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>72.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Śląsk Wrocław</td>\n",
       "      <td>9.833333e+05</td>\n",
       "      <td>7.711111e+05</td>\n",
       "      <td>3.025000e+05</td>\n",
       "      <td>6.550000e+05</td>\n",
       "      <td>62.000000</td>\n",
       "      <td>65.111111</td>\n",
       "      <td>65.500000</td>\n",
       "      <td>61.692308</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>67.555556</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>69.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>681 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     club_name  value_eur_ATT  value_eur_DEF  value_eur_GK  \\\n",
       "0        1. FC Heidenheim 1846   1.287500e+06   1.789286e+06  8.825000e+05   \n",
       "1         1. FC Kaiserslautern   9.062500e+05   8.225000e+05  6.750000e+05   \n",
       "2                   1. FC Köln   4.216667e+06   3.352273e+06  4.516667e+06   \n",
       "3              1. FC Magdeburg   5.750000e+05   6.750000e+05  5.833333e+05   \n",
       "4               1. FC Nürnberg   1.437500e+06   1.442500e+06  1.110000e+06   \n",
       "..                         ...            ...            ...           ...   \n",
       "676                  Örebro SK   5.333333e+05   4.762500e+05  3.750000e+05   \n",
       "677              Östersunds FK   5.750000e+05   6.083333e+05  2.783333e+05   \n",
       "678     İstanbul Başakşehir FK   4.995000e+06   3.252083e+06  2.566667e+06   \n",
       "679  İttifak Holding Konyaspor   7.875000e+05   1.038636e+06  6.875000e+05   \n",
       "680              Śląsk Wrocław   9.833333e+05   7.711111e+05  3.025000e+05   \n",
       "\n",
       "     value_eur_MID  overall_ATT  overall_DEF  overall_GK  overall_MID  \\\n",
       "0     1.284615e+06    65.666667    68.571429   63.250000    66.230769   \n",
       "1     8.553571e+05    65.000000    62.625000   59.500000    62.714286   \n",
       "2     4.961538e+06    70.000000    68.272727   71.000000    71.846154   \n",
       "3     5.875000e+05    62.750000    62.700000   60.333333    61.700000   \n",
       "4     2.622500e+06    66.500000    66.200000   67.250000    67.500000   \n",
       "..             ...          ...          ...         ...          ...   \n",
       "676   6.916667e+05    61.333333    61.000000   57.000000    61.777778   \n",
       "677   5.844444e+05    61.333333    62.333333   59.666667    60.666667   \n",
       "678   6.455000e+06    70.800000    71.333333   71.000000    72.000000   \n",
       "679   2.015909e+06    65.500000    67.272727   72.000000    69.000000   \n",
       "680   6.550000e+05    62.000000    65.111111   65.500000    61.692308   \n",
       "\n",
       "     potential_ATT  potential_DEF  potential_GK  potential_MID  \n",
       "0        70.333333      73.142857     71.000000      71.153846  \n",
       "1        67.500000      68.125000     70.000000      69.428571  \n",
       "2        74.666667      76.000000     76.666667      77.769231  \n",
       "3        65.750000      68.600000     69.666667      67.800000  \n",
       "4        71.333333      72.400000     72.000000      74.600000  \n",
       "..             ...            ...           ...            ...  \n",
       "676      64.500000      64.500000     63.000000      68.444444  \n",
       "677      67.333333      67.000000     63.000000      66.500000  \n",
       "678      74.400000      74.250000     73.333333      75.100000  \n",
       "679      65.500000      69.000000     72.000000      72.181818  \n",
       "680      72.000000      67.555556     67.000000      69.000000  \n",
       "\n",
       "[681 rows x 13 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df21_team_pos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "e9c8fd6f",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in d_avg_start.keys():\n",
    "    vars()[df]  = d_avg_start[df][d_avg_start[df]['is_bench']==False] \\\n",
    "        .groupby(['club_name','player_pos'])[['value_eur','overall','potential']] \\\n",
    "        .mean() \\\n",
    "        .reset_index() \\\n",
    "        .pivot(index='club_name',columns='player_pos',values=['value_eur','overall','potential'])\n",
    "    vars()[df].columns = list(map(\"_\".join, vars()[df].columns))\n",
    "    vars()[df] = vars()[df].rename(columns={\"club_name_\": \"club_name\"}) \\\n",
    "        .add_suffix('_start').reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "ae6e27f3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>club_name</th>\n",
       "      <th>value_eur_ATT_start</th>\n",
       "      <th>value_eur_DEF_start</th>\n",
       "      <th>value_eur_GK_start</th>\n",
       "      <th>value_eur_MID_start</th>\n",
       "      <th>overall_ATT_start</th>\n",
       "      <th>overall_DEF_start</th>\n",
       "      <th>overall_GK_start</th>\n",
       "      <th>overall_MID_start</th>\n",
       "      <th>potential_ATT_start</th>\n",
       "      <th>potential_DEF_start</th>\n",
       "      <th>potential_GK_start</th>\n",
       "      <th>potential_MID_start</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1. FC Heidenheim 1846</td>\n",
       "      <td>1200000.0</td>\n",
       "      <td>2.175000e+06</td>\n",
       "      <td>2100000.0</td>\n",
       "      <td>1.555000e+06</td>\n",
       "      <td>67.0</td>\n",
       "      <td>71.500000</td>\n",
       "      <td>73.0</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>73.500000</td>\n",
       "      <td>73.0</td>\n",
       "      <td>70.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1. FC Kaiserslautern</td>\n",
       "      <td>937500.0</td>\n",
       "      <td>1.250000e+06</td>\n",
       "      <td>1100000.0</td>\n",
       "      <td>1.100000e+06</td>\n",
       "      <td>64.5</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>64.0</td>\n",
       "      <td>65.400000</td>\n",
       "      <td>68.5</td>\n",
       "      <td>69.666667</td>\n",
       "      <td>72.0</td>\n",
       "      <td>69.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>7500000.0</td>\n",
       "      <td>5.700000e+06</td>\n",
       "      <td>10500000.0</td>\n",
       "      <td>7.100000e+06</td>\n",
       "      <td>76.0</td>\n",
       "      <td>72.750000</td>\n",
       "      <td>77.0</td>\n",
       "      <td>73.000000</td>\n",
       "      <td>76.0</td>\n",
       "      <td>77.750000</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1. FC Magdeburg</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>8.687500e+05</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>5.562500e+05</td>\n",
       "      <td>65.0</td>\n",
       "      <td>64.750000</td>\n",
       "      <td>66.0</td>\n",
       "      <td>63.750000</td>\n",
       "      <td>65.0</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>71.0</td>\n",
       "      <td>66.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1. FC Nürnberg</td>\n",
       "      <td>1200000.0</td>\n",
       "      <td>2.118750e+06</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>3.575000e+06</td>\n",
       "      <td>68.0</td>\n",
       "      <td>68.750000</td>\n",
       "      <td>72.0</td>\n",
       "      <td>68.800000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>74.0</td>\n",
       "      <td>76.400000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>Örebro SK</td>\n",
       "      <td>662500.0</td>\n",
       "      <td>6.750000e+05</td>\n",
       "      <td>925000.0</td>\n",
       "      <td>9.875000e+05</td>\n",
       "      <td>64.0</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>65.500000</td>\n",
       "      <td>64.0</td>\n",
       "      <td>66.750000</td>\n",
       "      <td>69.0</td>\n",
       "      <td>69.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>Östersunds FK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.083333e+05</td>\n",
       "      <td>275000.0</td>\n",
       "      <td>7.285714e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.333333</td>\n",
       "      <td>66.0</td>\n",
       "      <td>61.857143</td>\n",
       "      <td>NaN</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>66.0</td>\n",
       "      <td>68.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>İstanbul Başakşehir FK</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>4.675000e+06</td>\n",
       "      <td>5500000.0</td>\n",
       "      <td>1.106000e+07</td>\n",
       "      <td>72.0</td>\n",
       "      <td>76.250000</td>\n",
       "      <td>77.0</td>\n",
       "      <td>75.600000</td>\n",
       "      <td>72.0</td>\n",
       "      <td>76.250000</td>\n",
       "      <td>77.0</td>\n",
       "      <td>76.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>İttifak Holding Konyaspor</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>1.462500e+06</td>\n",
       "      <td>625000.0</td>\n",
       "      <td>2.480000e+06</td>\n",
       "      <td>67.0</td>\n",
       "      <td>70.500000</td>\n",
       "      <td>75.0</td>\n",
       "      <td>71.200000</td>\n",
       "      <td>67.0</td>\n",
       "      <td>70.500000</td>\n",
       "      <td>75.0</td>\n",
       "      <td>72.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Śląsk Wrocław</td>\n",
       "      <td>875000.0</td>\n",
       "      <td>6.130000e+05</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>7.125000e+05</td>\n",
       "      <td>64.0</td>\n",
       "      <td>65.200000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>63.250000</td>\n",
       "      <td>69.0</td>\n",
       "      <td>66.600000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>70.500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>681 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     club_name  value_eur_ATT_start  value_eur_DEF_start  \\\n",
       "0        1. FC Heidenheim 1846            1200000.0         2.175000e+06   \n",
       "1         1. FC Kaiserslautern             937500.0         1.250000e+06   \n",
       "2                   1. FC Köln            7500000.0         5.700000e+06   \n",
       "3              1. FC Magdeburg             650000.0         8.687500e+05   \n",
       "4               1. FC Nürnberg            1200000.0         2.118750e+06   \n",
       "..                         ...                  ...                  ...   \n",
       "676                  Örebro SK             662500.0         6.750000e+05   \n",
       "677              Östersunds FK                  NaN         6.083333e+05   \n",
       "678     İstanbul Başakşehir FK            1000000.0         4.675000e+06   \n",
       "679  İttifak Holding Konyaspor            1000000.0         1.462500e+06   \n",
       "680              Śląsk Wrocław             875000.0         6.130000e+05   \n",
       "\n",
       "     value_eur_GK_start  value_eur_MID_start  overall_ATT_start  \\\n",
       "0             2100000.0         1.555000e+06               67.0   \n",
       "1             1100000.0         1.100000e+06               64.5   \n",
       "2            10500000.0         7.100000e+06               76.0   \n",
       "3             1000000.0         5.562500e+05               65.0   \n",
       "4             2000000.0         3.575000e+06               68.0   \n",
       "..                  ...                  ...                ...   \n",
       "676            925000.0         9.875000e+05               64.0   \n",
       "677            275000.0         7.285714e+05                NaN   \n",
       "678           5500000.0         1.106000e+07               72.0   \n",
       "679            625000.0         2.480000e+06               67.0   \n",
       "680            130000.0         7.125000e+05               64.0   \n",
       "\n",
       "     overall_DEF_start  overall_GK_start  overall_MID_start  \\\n",
       "0            71.500000              73.0          70.000000   \n",
       "1            68.000000              64.0          65.400000   \n",
       "2            72.750000              77.0          73.000000   \n",
       "3            64.750000              66.0          63.750000   \n",
       "4            68.750000              72.0          68.800000   \n",
       "..                 ...               ...                ...   \n",
       "676          64.000000              68.0          65.500000   \n",
       "677          62.333333              66.0          61.857143   \n",
       "678          76.250000              77.0          75.600000   \n",
       "679          70.500000              75.0          71.200000   \n",
       "680          65.200000              68.0          63.250000   \n",
       "\n",
       "     potential_ATT_start  potential_DEF_start  potential_GK_start  \\\n",
       "0                   68.0            73.500000                73.0   \n",
       "1                   68.5            69.666667                72.0   \n",
       "2                   76.0            77.750000                80.0   \n",
       "3                   65.0            69.000000                71.0   \n",
       "4                   68.0            74.000000                74.0   \n",
       "..                   ...                  ...                 ...   \n",
       "676                 64.0            66.750000                69.0   \n",
       "677                  NaN            67.000000                66.0   \n",
       "678                 72.0            76.250000                77.0   \n",
       "679                 67.0            70.500000                75.0   \n",
       "680                 69.0            66.600000                68.0   \n",
       "\n",
       "     potential_MID_start  \n",
       "0              70.600000  \n",
       "1              69.400000  \n",
       "2              80.200000  \n",
       "3              66.250000  \n",
       "4              76.400000  \n",
       "..                   ...  \n",
       "676            69.250000  \n",
       "677            68.142857  \n",
       "678            76.800000  \n",
       "679            72.000000  \n",
       "680            70.500000  \n",
       "\n",
       "[681 rows x 13 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df21_team_start"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "73896fec",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['df22_team_pos', 'df21_team_pos'])"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d_avg_pos.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "2fe81301",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['df22_team', 'df21_team', 'df20_team', 'df19_team'])"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_avg,team_avg_pos,avg_pos_start = gtf.get_team_metrics()\n",
    "team_avg.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "c99cc286",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['df22_team_pos', 'df21_team_pos', 'df20_team_pos', 'df19_team_pos'])"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_avg_pos.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "e0797db3",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>club_name</th>\n",
       "      <th>value_eur_ATT</th>\n",
       "      <th>value_eur_DEF</th>\n",
       "      <th>value_eur_GK</th>\n",
       "      <th>value_eur_MID</th>\n",
       "      <th>overall_ATT</th>\n",
       "      <th>overall_DEF</th>\n",
       "      <th>overall_GK</th>\n",
       "      <th>overall_MID</th>\n",
       "      <th>potential_ATT</th>\n",
       "      <th>potential_DEF</th>\n",
       "      <th>potential_GK</th>\n",
       "      <th>potential_MID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1. FC Heidenheim 1846</td>\n",
       "      <td>6.430000e+05</td>\n",
       "      <td>1.230000e+06</td>\n",
       "      <td>6.300000e+05</td>\n",
       "      <td>1.552500e+06</td>\n",
       "      <td>62.800000</td>\n",
       "      <td>67.300000</td>\n",
       "      <td>62.000000</td>\n",
       "      <td>67.300000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>71.600000</td>\n",
       "      <td>70.500000</td>\n",
       "      <td>72.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1. FC Kaiserslautern</td>\n",
       "      <td>7.333333e+05</td>\n",
       "      <td>4.877778e+05</td>\n",
       "      <td>4.483333e+05</td>\n",
       "      <td>6.765000e+05</td>\n",
       "      <td>65.166667</td>\n",
       "      <td>62.777778</td>\n",
       "      <td>60.666667</td>\n",
       "      <td>64.700000</td>\n",
       "      <td>68.500000</td>\n",
       "      <td>69.333333</td>\n",
       "      <td>72.333333</td>\n",
       "      <td>69.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>9.333333e+06</td>\n",
       "      <td>4.533333e+06</td>\n",
       "      <td>4.315000e+06</td>\n",
       "      <td>5.340000e+06</td>\n",
       "      <td>77.000000</td>\n",
       "      <td>71.555556</td>\n",
       "      <td>67.250000</td>\n",
       "      <td>71.733333</td>\n",
       "      <td>78.000000</td>\n",
       "      <td>77.222222</td>\n",
       "      <td>74.250000</td>\n",
       "      <td>77.733333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1. FC Magdeburg</td>\n",
       "      <td>5.250000e+05</td>\n",
       "      <td>5.535714e+05</td>\n",
       "      <td>4.750000e+05</td>\n",
       "      <td>7.000000e+05</td>\n",
       "      <td>62.750000</td>\n",
       "      <td>64.285714</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>65.181818</td>\n",
       "      <td>70.750000</td>\n",
       "      <td>68.714286</td>\n",
       "      <td>71.500000</td>\n",
       "      <td>70.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1. FC Nürnberg</td>\n",
       "      <td>2.420455e+06</td>\n",
       "      <td>1.950000e+06</td>\n",
       "      <td>2.030000e+06</td>\n",
       "      <td>2.931250e+06</td>\n",
       "      <td>68.272727</td>\n",
       "      <td>68.375000</td>\n",
       "      <td>69.333333</td>\n",
       "      <td>69.750000</td>\n",
       "      <td>74.454545</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>74.500000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>Östersunds FK</td>\n",
       "      <td>4.675000e+05</td>\n",
       "      <td>4.361111e+05</td>\n",
       "      <td>2.433333e+05</td>\n",
       "      <td>4.413636e+05</td>\n",
       "      <td>59.750000</td>\n",
       "      <td>61.666667</td>\n",
       "      <td>59.000000</td>\n",
       "      <td>61.090909</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.444444</td>\n",
       "      <td>63.333333</td>\n",
       "      <td>68.909091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>İstanbul Başakşehir FK</td>\n",
       "      <td>3.900000e+06</td>\n",
       "      <td>3.685000e+06</td>\n",
       "      <td>4.750000e+06</td>\n",
       "      <td>5.830769e+06</td>\n",
       "      <td>72.800000</td>\n",
       "      <td>73.600000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>73.384615</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>74.500000</td>\n",
       "      <td>75.500000</td>\n",
       "      <td>75.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>İttifak Holding Konyaspor</td>\n",
       "      <td>1.262500e+06</td>\n",
       "      <td>1.246154e+06</td>\n",
       "      <td>2.012500e+06</td>\n",
       "      <td>2.753125e+06</td>\n",
       "      <td>65.750000</td>\n",
       "      <td>68.384615</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>70.250000</td>\n",
       "      <td>72.500000</td>\n",
       "      <td>69.615385</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>73.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>ŁKS Łódź</td>\n",
       "      <td>3.266667e+05</td>\n",
       "      <td>1.850000e+05</td>\n",
       "      <td>1.166667e+05</td>\n",
       "      <td>2.634615e+05</td>\n",
       "      <td>61.666667</td>\n",
       "      <td>57.750000</td>\n",
       "      <td>56.666667</td>\n",
       "      <td>59.153846</td>\n",
       "      <td>61.666667</td>\n",
       "      <td>61.500000</td>\n",
       "      <td>62.333333</td>\n",
       "      <td>64.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>Śląsk Wrocław</td>\n",
       "      <td>4.325000e+05</td>\n",
       "      <td>4.250000e+05</td>\n",
       "      <td>1.683333e+05</td>\n",
       "      <td>5.062500e+05</td>\n",
       "      <td>60.250000</td>\n",
       "      <td>64.375000</td>\n",
       "      <td>57.666667</td>\n",
       "      <td>62.833333</td>\n",
       "      <td>72.250000</td>\n",
       "      <td>67.125000</td>\n",
       "      <td>59.666667</td>\n",
       "      <td>68.666667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>668 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     club_name  value_eur_ATT  value_eur_DEF  value_eur_GK  \\\n",
       "0        1. FC Heidenheim 1846   6.430000e+05   1.230000e+06  6.300000e+05   \n",
       "1         1. FC Kaiserslautern   7.333333e+05   4.877778e+05  4.483333e+05   \n",
       "2                   1. FC Köln   9.333333e+06   4.533333e+06  4.315000e+06   \n",
       "3              1. FC Magdeburg   5.250000e+05   5.535714e+05  4.750000e+05   \n",
       "4               1. FC Nürnberg   2.420455e+06   1.950000e+06  2.030000e+06   \n",
       "..                         ...            ...            ...           ...   \n",
       "663              Östersunds FK   4.675000e+05   4.361111e+05  2.433333e+05   \n",
       "664     İstanbul Başakşehir FK   3.900000e+06   3.685000e+06  4.750000e+06   \n",
       "665  İttifak Holding Konyaspor   1.262500e+06   1.246154e+06  2.012500e+06   \n",
       "666                   ŁKS Łódź   3.266667e+05   1.850000e+05  1.166667e+05   \n",
       "667              Śląsk Wrocław   4.325000e+05   4.250000e+05  1.683333e+05   \n",
       "\n",
       "     value_eur_MID  overall_ATT  overall_DEF  overall_GK  overall_MID  \\\n",
       "0     1.552500e+06    62.800000    67.300000   62.000000    67.300000   \n",
       "1     6.765000e+05    65.166667    62.777778   60.666667    64.700000   \n",
       "2     5.340000e+06    77.000000    71.555556   67.250000    71.733333   \n",
       "3     7.000000e+05    62.750000    64.285714   63.000000    65.181818   \n",
       "4     2.931250e+06    68.272727    68.375000   69.333333    69.750000   \n",
       "..             ...          ...          ...         ...          ...   \n",
       "663   4.413636e+05    59.750000    61.666667   59.000000    61.090909   \n",
       "664   5.830769e+06    72.800000    73.600000   75.000000    73.384615   \n",
       "665   2.753125e+06    65.750000    68.384615   72.000000    70.250000   \n",
       "666   2.634615e+05    61.666667    57.750000   56.666667    59.153846   \n",
       "667   5.062500e+05    60.250000    64.375000   57.666667    62.833333   \n",
       "\n",
       "     potential_ATT  potential_DEF  potential_GK  potential_MID  \n",
       "0        70.000000      71.600000     70.500000      72.800000  \n",
       "1        68.500000      69.333333     72.333333      69.900000  \n",
       "2        78.000000      77.222222     74.250000      77.733333  \n",
       "3        70.750000      68.714286     71.500000      70.000000  \n",
       "4        74.454545      74.000000     70.000000      74.500000  \n",
       "..             ...            ...           ...            ...  \n",
       "663      68.000000      68.444444     63.333333      68.909091  \n",
       "664      74.000000      74.500000     75.500000      75.000000  \n",
       "665      72.500000      69.615385     72.000000      73.500000  \n",
       "666      61.666667      61.500000     62.333333      64.153846  \n",
       "667      72.250000      67.125000     59.666667      68.666667  \n",
       "\n",
       "[668 rows x 13 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_avg_pos['df20_team_pos']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "ebec3c4f",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_items([('df22_team',                      club_name  value_eur_mean  overall_mean  potential_mean\n",
       "0        1. FC Heidenheim 1846    1.574074e+06     66.925926       71.185185\n",
       "1         1. FC Kaiserslautern    7.600000e+05     62.821429       68.142857\n",
       "2                   1. FC Köln    3.290161e+06     69.161290       75.451613\n",
       "3              1. FC Magdeburg    6.687500e+05     62.107143       67.500000\n",
       "4               1. FC Nürnberg    1.281379e+06     65.689655       70.896552\n",
       "..                         ...             ...           ...             ...\n",
       "696                  Örebro SK    5.572000e+05     61.440000       65.640000\n",
       "697              Östersunds FK    5.629167e+05     61.666667       65.833333\n",
       "698     İstanbul Başakşehir FK    2.963889e+06     70.000000       73.222222\n",
       "699  İttifak Holding Konyaspor    1.350000e+06     67.750000       69.583333\n",
       "700              Śląsk Wrocław    7.235714e+05     62.964286       68.428571\n",
       "\n",
       "[701 rows x 4 columns]), ('df21_team',                      club_name  value_eur_mean  overall_mean  potential_mean\n",
       "0        1. FC Heidenheim 1846    1.349333e+06     66.266667       71.433333\n",
       "1         1. FC Kaiserslautern    8.403571e+05     62.785714       68.821429\n",
       "2                   1. FC Köln    4.252500e+06     70.266667       76.700000\n",
       "3              1. FC Magdeburg    6.175926e+05     62.074074       68.000000\n",
       "4               1. FC Nürnberg    1.790500e+06     66.833333       72.866667\n",
       "..                         ...             ...           ...             ...\n",
       "676                  Örebro SK    5.523077e+05     60.884615       65.692308\n",
       "677              Östersunds FK    5.520370e+05     60.814815       66.259259\n",
       "678     İstanbul Başakşehir FK    4.541667e+06     71.433333       74.466667\n",
       "679  İttifak Holding Konyaspor    1.405769e+06     68.230769       70.307692\n",
       "680              Śląsk Wrocław    7.040741e+05     63.148148       68.703704\n",
       "\n",
       "[681 rows x 4 columns]), ('df20_team',                      club_name  value_eur_mean  overall_mean  potential_mean\n",
       "0        1. FC Heidenheim 1846    1.157241e+06     65.793103       71.586207\n",
       "1         1. FC Kaiserslautern    6.035714e+05     63.750000       69.678571\n",
       "2                   1. FC Köln    5.360000e+06     71.612903       77.161290\n",
       "3              1. FC Magdeburg    6.093750e+05     64.333333       69.875000\n",
       "4               1. FC Nürnberg    2.392167e+06     68.800000       73.900000\n",
       "..                         ...             ...           ...             ...\n",
       "663              Östersunds FK    4.214815e+05     60.851852       68.000000\n",
       "664     İstanbul Başakşehir FK    4.721667e+06     73.466667       74.700000\n",
       "665  İttifak Holding Konyaspor    1.751852e+06     68.814815       71.370370\n",
       "666                   ŁKS Łódź    2.309259e+05     58.740741       62.888889\n",
       "667              Śląsk Wrocław    4.337037e+05     62.333333       67.740741\n",
       "\n",
       "[668 rows x 4 columns]), ('df19_team',                      club_name  value_eur_mean  overall_mean  potential_mean\n",
       "0        1. FC Heidenheim 1846    9.791071e+05     65.571429       71.928571\n",
       "1         1. FC Kaiserslautern    6.792000e+05     63.720000       69.960000\n",
       "2                   1. FC Köln    4.942321e+06     70.821429       76.642857\n",
       "3              1. FC Magdeburg    7.684000e+05     65.320000       70.360000\n",
       "4               1. FC Nürnberg    2.029000e+06     68.000000       74.360000\n",
       "..                         ...             ...           ...             ...\n",
       "646                  Örebro SK    4.019231e+05     60.230769       66.346154\n",
       "647              Östersunds FK    6.747826e+05     62.913043       68.956522\n",
       "648     İstanbul Başakşehir FK    4.317407e+06     72.703704       73.962963\n",
       "649  İttifak Holding Konyaspor    2.090517e+06     69.689655       72.137931\n",
       "650              Śląsk Wrocław    3.864583e+05     62.291667       65.041667\n",
       "\n",
       "[651 rows x 4 columns])])"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_avg.items()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "a501eea5",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>club_name</th>\n",
       "      <th>value_eur_mean</th>\n",
       "      <th>overall_mean</th>\n",
       "      <th>potential_mean</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1. FC Heidenheim 1846</td>\n",
       "      <td>1.574074e+06</td>\n",
       "      <td>66.925926</td>\n",
       "      <td>71.185185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1. FC Kaiserslautern</td>\n",
       "      <td>7.600000e+05</td>\n",
       "      <td>62.821429</td>\n",
       "      <td>68.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>3.290161e+06</td>\n",
       "      <td>69.161290</td>\n",
       "      <td>75.451613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1. FC Magdeburg</td>\n",
       "      <td>6.687500e+05</td>\n",
       "      <td>62.107143</td>\n",
       "      <td>67.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1. FC Nürnberg</td>\n",
       "      <td>1.281379e+06</td>\n",
       "      <td>65.689655</td>\n",
       "      <td>70.896552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>Örebro SK</td>\n",
       "      <td>5.572000e+05</td>\n",
       "      <td>61.440000</td>\n",
       "      <td>65.640000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>697</th>\n",
       "      <td>Östersunds FK</td>\n",
       "      <td>5.629167e+05</td>\n",
       "      <td>61.666667</td>\n",
       "      <td>65.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>İstanbul Başakşehir FK</td>\n",
       "      <td>2.963889e+06</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>73.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>İttifak Holding Konyaspor</td>\n",
       "      <td>1.350000e+06</td>\n",
       "      <td>67.750000</td>\n",
       "      <td>69.583333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>Śląsk Wrocław</td>\n",
       "      <td>7.235714e+05</td>\n",
       "      <td>62.964286</td>\n",
       "      <td>68.428571</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>701 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     club_name  value_eur_mean  overall_mean  potential_mean\n",
       "0        1. FC Heidenheim 1846    1.574074e+06     66.925926       71.185185\n",
       "1         1. FC Kaiserslautern    7.600000e+05     62.821429       68.142857\n",
       "2                   1. FC Köln    3.290161e+06     69.161290       75.451613\n",
       "3              1. FC Magdeburg    6.687500e+05     62.107143       67.500000\n",
       "4               1. FC Nürnberg    1.281379e+06     65.689655       70.896552\n",
       "..                         ...             ...           ...             ...\n",
       "696                  Örebro SK    5.572000e+05     61.440000       65.640000\n",
       "697              Östersunds FK    5.629167e+05     61.666667       65.833333\n",
       "698     İstanbul Başakşehir FK    2.963889e+06     70.000000       73.222222\n",
       "699  İttifak Holding Konyaspor    1.350000e+06     67.750000       69.583333\n",
       "700              Śląsk Wrocław    7.235714e+05     62.964286       68.428571\n",
       "\n",
       "[701 rows x 4 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_avg['df22_team']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "84a7520b",
   "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>sofifa_id</th>\n",
       "      <th>player_url</th>\n",
       "      <th>short_name</th>\n",
       "      <th>long_name</th>\n",
       "      <th>player_positions</th>\n",
       "      <th>overall</th>\n",
       "      <th>potential</th>\n",
       "      <th>value_eur</th>\n",
       "      <th>wage_eur</th>\n",
       "      <th>age</th>\n",
       "      <th>...</th>\n",
       "      <th>value_eur_GK_start</th>\n",
       "      <th>value_eur_MID_start</th>\n",
       "      <th>overall_ATT_start</th>\n",
       "      <th>overall_DEF_start</th>\n",
       "      <th>overall_GK_start</th>\n",
       "      <th>overall_MID_start</th>\n",
       "      <th>potential_ATT_start</th>\n",
       "      <th>potential_DEF_start</th>\n",
       "      <th>potential_GK_start</th>\n",
       "      <th>potential_MID_start</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>158023</td>\n",
       "      <td>https://sofifa.com/player/158023/lionel-messi/...</td>\n",
       "      <td>L. Messi</td>\n",
       "      <td>Lionel Andrés Messi Cuccittini</td>\n",
       "      <td>RW, ST, CF</td>\n",
       "      <td>93</td>\n",
       "      <td>93</td>\n",
       "      <td>78000000.0</td>\n",
       "      <td>320000.0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>190871</td>\n",
       "      <td>https://sofifa.com/player/190871/neymar-da-sil...</td>\n",
       "      <td>Neymar Jr</td>\n",
       "      <td>Neymar da Silva Santos Júnior</td>\n",
       "      <td>LW, CAM</td>\n",
       "      <td>91</td>\n",
       "      <td>91</td>\n",
       "      <td>129000000.0</td>\n",
       "      <td>270000.0</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>231747</td>\n",
       "      <td>https://sofifa.com/player/231747/kylian-mbappe...</td>\n",
       "      <td>K. Mbappé</td>\n",
       "      <td>Kylian Mbappé Lottin</td>\n",
       "      <td>ST, LW</td>\n",
       "      <td>91</td>\n",
       "      <td>95</td>\n",
       "      <td>194000000.0</td>\n",
       "      <td>230000.0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>230621</td>\n",
       "      <td>https://sofifa.com/player/230621/gianluigi-don...</td>\n",
       "      <td>G. Donnarumma</td>\n",
       "      <td>Gianluigi Donnarumma</td>\n",
       "      <td>GK</td>\n",
       "      <td>89</td>\n",
       "      <td>93</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>155862</td>\n",
       "      <td>https://sofifa.com/player/155862/sergio-ramos-...</td>\n",
       "      <td>Sergio Ramos</td>\n",
       "      <td>Sergio Ramos García</td>\n",
       "      <td>CB</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>24000000.0</td>\n",
       "      <td>115000.0</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>193041</td>\n",
       "      <td>https://sofifa.com/player/193041/keylor-navas/...</td>\n",
       "      <td>K. Navas</td>\n",
       "      <td>Keylor Navas Gamboa</td>\n",
       "      <td>GK</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>15500000.0</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>183898</td>\n",
       "      <td>https://sofifa.com/player/183898/angel-di-mari...</td>\n",
       "      <td>Á. Di María</td>\n",
       "      <td>Ángel Fabián Di María Hernández</td>\n",
       "      <td>RW, LW</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "      <td>49500000.0</td>\n",
       "      <td>160000.0</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>199556</td>\n",
       "      <td>https://sofifa.com/player/199556/marco-verratt...</td>\n",
       "      <td>M. Verratti</td>\n",
       "      <td>Marco Verratti</td>\n",
       "      <td>CM, CAM</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "      <td>79500000.0</td>\n",
       "      <td>155000.0</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>207865</td>\n",
       "      <td>https://sofifa.com/player/207865/marcos-aoas-c...</td>\n",
       "      <td>Marquinhos</td>\n",
       "      <td>Marcos Aoás Corrêa</td>\n",
       "      <td>CB, CDM</td>\n",
       "      <td>87</td>\n",
       "      <td>90</td>\n",
       "      <td>90500000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>235212</td>\n",
       "      <td>https://sofifa.com/player/235212/achraf-hakimi...</td>\n",
       "      <td>A. Hakimi</td>\n",
       "      <td>Achraf Hakimi Mouh</td>\n",
       "      <td>RB, RWB</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>69500000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>4.716667e+07</td>\n",
       "      <td>91.666667</td>\n",
       "      <td>85.5</td>\n",
       "      <td>89.0</td>\n",
       "      <td>84.333333</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.333333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 137 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   sofifa_id                                         player_url  \\\n",
       "0     158023  https://sofifa.com/player/158023/lionel-messi/...   \n",
       "1     190871  https://sofifa.com/player/190871/neymar-da-sil...   \n",
       "2     231747  https://sofifa.com/player/231747/kylian-mbappe...   \n",
       "3     230621  https://sofifa.com/player/230621/gianluigi-don...   \n",
       "4     155862  https://sofifa.com/player/155862/sergio-ramos-...   \n",
       "5     193041  https://sofifa.com/player/193041/keylor-navas/...   \n",
       "6     183898  https://sofifa.com/player/183898/angel-di-mari...   \n",
       "7     199556  https://sofifa.com/player/199556/marco-verratt...   \n",
       "8     207865  https://sofifa.com/player/207865/marcos-aoas-c...   \n",
       "9     235212  https://sofifa.com/player/235212/achraf-hakimi...   \n",
       "\n",
       "      short_name                        long_name player_positions  overall  \\\n",
       "0       L. Messi   Lionel Andrés Messi Cuccittini       RW, ST, CF       93   \n",
       "1      Neymar Jr    Neymar da Silva Santos Júnior          LW, CAM       91   \n",
       "2      K. Mbappé             Kylian Mbappé Lottin           ST, LW       91   \n",
       "3  G. Donnarumma             Gianluigi Donnarumma               GK       89   \n",
       "4   Sergio Ramos              Sergio Ramos García               CB       88   \n",
       "5       K. Navas              Keylor Navas Gamboa               GK       88   \n",
       "6    Á. Di María  Ángel Fabián Di María Hernández           RW, LW       87   \n",
       "7    M. Verratti                   Marco Verratti          CM, CAM       87   \n",
       "8     Marquinhos               Marcos Aoás Corrêa          CB, CDM       87   \n",
       "9      A. Hakimi               Achraf Hakimi Mouh          RB, RWB       85   \n",
       "\n",
       "   potential    value_eur  wage_eur  age  ... value_eur_GK_start  \\\n",
       "0         93   78000000.0  320000.0   34  ...        119500000.0   \n",
       "1         91  129000000.0  270000.0   29  ...        119500000.0   \n",
       "2         95  194000000.0  230000.0   22  ...        119500000.0   \n",
       "3         93  119500000.0  110000.0   22  ...        119500000.0   \n",
       "4         88   24000000.0  115000.0   35  ...        119500000.0   \n",
       "5         88   15500000.0  130000.0   34  ...        119500000.0   \n",
       "6         87   49500000.0  160000.0   33  ...        119500000.0   \n",
       "7         87   79500000.0  155000.0   28  ...        119500000.0   \n",
       "8         90   90500000.0  135000.0   27  ...        119500000.0   \n",
       "9         88   69500000.0  100000.0   22  ...        119500000.0   \n",
       "\n",
       "   value_eur_MID_start  overall_ATT_start  overall_DEF_start overall_GK_start  \\\n",
       "0         4.716667e+07          91.666667               85.5             89.0   \n",
       "1         4.716667e+07          91.666667               85.5             89.0   \n",
       "2         4.716667e+07          91.666667               85.5             89.0   \n",
       "3         4.716667e+07          91.666667               85.5             89.0   \n",
       "4         4.716667e+07          91.666667               85.5             89.0   \n",
       "5         4.716667e+07          91.666667               85.5             89.0   \n",
       "6         4.716667e+07          91.666667               85.5             89.0   \n",
       "7         4.716667e+07          91.666667               85.5             89.0   \n",
       "8         4.716667e+07          91.666667               85.5             89.0   \n",
       "9         4.716667e+07          91.666667               85.5             89.0   \n",
       "\n",
       "  overall_MID_start  potential_ATT_start potential_DEF_start  \\\n",
       "0         84.333333                 93.0                87.0   \n",
       "1         84.333333                 93.0                87.0   \n",
       "2         84.333333                 93.0                87.0   \n",
       "3         84.333333                 93.0                87.0   \n",
       "4         84.333333                 93.0                87.0   \n",
       "5         84.333333                 93.0                87.0   \n",
       "6         84.333333                 93.0                87.0   \n",
       "7         84.333333                 93.0                87.0   \n",
       "8         84.333333                 93.0                87.0   \n",
       "9         84.333333                 93.0                87.0   \n",
       "\n",
       "   potential_GK_start potential_MID_start  \n",
       "0                93.0           84.333333  \n",
       "1                93.0           84.333333  \n",
       "2                93.0           84.333333  \n",
       "3                93.0           84.333333  \n",
       "4                93.0           84.333333  \n",
       "5                93.0           84.333333  \n",
       "6                93.0           84.333333  \n",
       "7                93.0           84.333333  \n",
       "8                93.0           84.333333  \n",
       "9                93.0           84.333333  \n",
       "\n",
       "[10 rows x 137 columns]"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2022,df_2021,df_2020,df_2019 = gtf.join_team_df()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "id": "9e0d0bb7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(19239, 137)"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2022.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "570e9f2e",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "import numpy as np \n",
    "A=np.array([7,3,5])\n",
    "B=np.array([3,7,10])\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "176ba985",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[7 3 5] [[7 3 5]]\n"
     ]
    }
   ],
   "source": [
    "\n",
    "print(A,A.reshape(1,-1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "id": "3707e664",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.1966214394919974"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from scipy.spatial import distance\n",
    "distance.cosine(A.reshape(1,-1),B.reshape(1,-1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "5bf25e14",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.1966214394919974"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "distance.cosine(A,B)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "fb99e85d",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_index(x):\n",
    "    return df_2022[df_2022['short_name']==x].index.tolist()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "0e17dfd2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "61"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_index('Cristiano Ronaldo')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "4b36d863",
   "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>sofifa_id</th>\n",
       "      <th>short_name</th>\n",
       "      <th>player_positions</th>\n",
       "      <th>overall</th>\n",
       "      <th>potential</th>\n",
       "      <th>value_eur</th>\n",
       "      <th>wage_eur</th>\n",
       "      <th>age</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>...</th>\n",
       "      <th>defending_standing_tackle</th>\n",
       "      <th>defending_sliding_tackle</th>\n",
       "      <th>is_bench</th>\n",
       "      <th>potential_diff</th>\n",
       "      <th>att_rate</th>\n",
       "      <th>def_rate</th>\n",
       "      <th>age_bin</th>\n",
       "      <th>prefered_pos</th>\n",
       "      <th>player_pos</th>\n",
       "      <th>new_nationality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>158023</td>\n",
       "      <td>L. Messi</td>\n",
       "      <td>RW, ST, CF</td>\n",
       "      <td>93</td>\n",
       "      <td>93</td>\n",
       "      <td>78000000.0</td>\n",
       "      <td>320000.0</td>\n",
       "      <td>34</td>\n",
       "      <td>170</td>\n",
       "      <td>72</td>\n",
       "      <td>...</td>\n",
       "      <td>35</td>\n",
       "      <td>24</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Low</td>\n",
       "      <td>30-34</td>\n",
       "      <td>RW</td>\n",
       "      <td>ATT</td>\n",
       "      <td>Argentina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>188545</td>\n",
       "      <td>R. Lewandowski</td>\n",
       "      <td>ST</td>\n",
       "      <td>92</td>\n",
       "      <td>92</td>\n",
       "      <td>119500000.0</td>\n",
       "      <td>270000.0</td>\n",
       "      <td>32</td>\n",
       "      <td>185</td>\n",
       "      <td>81</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>19</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>High</td>\n",
       "      <td>Medium</td>\n",
       "      <td>30-34</td>\n",
       "      <td>ST</td>\n",
       "      <td>ATT</td>\n",
       "      <td>Poland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20801</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>ST, LW</td>\n",
       "      <td>91</td>\n",
       "      <td>91</td>\n",
       "      <td>45000000.0</td>\n",
       "      <td>270000.0</td>\n",
       "      <td>36</td>\n",
       "      <td>187</td>\n",
       "      <td>83</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>24</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>High</td>\n",
       "      <td>Low</td>\n",
       "      <td>Over 34</td>\n",
       "      <td>ST</td>\n",
       "      <td>ATT</td>\n",
       "      <td>Portugal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>190871</td>\n",
       "      <td>Neymar Jr</td>\n",
       "      <td>LW, CAM</td>\n",
       "      <td>91</td>\n",
       "      <td>91</td>\n",
       "      <td>129000000.0</td>\n",
       "      <td>270000.0</td>\n",
       "      <td>29</td>\n",
       "      <td>175</td>\n",
       "      <td>68</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>29</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>High</td>\n",
       "      <td>Medium</td>\n",
       "      <td>25-29</td>\n",
       "      <td>LW</td>\n",
       "      <td>ATT</td>\n",
       "      <td>Brazil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>192985</td>\n",
       "      <td>K. De Bruyne</td>\n",
       "      <td>CM, CAM</td>\n",
       "      <td>91</td>\n",
       "      <td>91</td>\n",
       "      <td>125500000.0</td>\n",
       "      <td>350000.0</td>\n",
       "      <td>30</td>\n",
       "      <td>181</td>\n",
       "      <td>70</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>53</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>High</td>\n",
       "      <td>High</td>\n",
       "      <td>30-34</td>\n",
       "      <td>CM</td>\n",
       "      <td>MID</td>\n",
       "      <td>Others</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 71 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   sofifa_id         short_name player_positions  overall  potential  \\\n",
       "0     158023           L. Messi       RW, ST, CF       93         93   \n",
       "1     188545     R. Lewandowski               ST       92         92   \n",
       "2      20801  Cristiano Ronaldo           ST, LW       91         91   \n",
       "3     190871          Neymar Jr          LW, CAM       91         91   \n",
       "4     192985       K. De Bruyne          CM, CAM       91         91   \n",
       "\n",
       "     value_eur  wage_eur  age  height_cm  weight_kg  ...  \\\n",
       "0   78000000.0  320000.0   34        170         72  ...   \n",
       "1  119500000.0  270000.0   32        185         81  ...   \n",
       "2   45000000.0  270000.0   36        187         83  ...   \n",
       "3  129000000.0  270000.0   29        175         68  ...   \n",
       "4  125500000.0  350000.0   30        181         70  ...   \n",
       "\n",
       "   defending_standing_tackle defending_sliding_tackle is_bench  \\\n",
       "0                         35                       24    False   \n",
       "1                         42                       19    False   \n",
       "2                         32                       24    False   \n",
       "3                         32                       29    False   \n",
       "4                         65                       53    False   \n",
       "\n",
       "   potential_diff att_rate def_rate  age_bin prefered_pos  player_pos  \\\n",
       "0               0   Medium      Low    30-34           RW         ATT   \n",
       "1               0     High   Medium    30-34           ST         ATT   \n",
       "2               0     High      Low  Over 34           ST         ATT   \n",
       "3               0     High   Medium    25-29           LW         ATT   \n",
       "4               0     High     High    30-34           CM         MID   \n",
       "\n",
       "  new_nationality  \n",
       "0       Argentina  \n",
       "1          Poland  \n",
       "2        Portugal  \n",
       "3          Brazil  \n",
       "4          Others  \n",
       "\n",
       "[5 rows x 71 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df22_new.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "id": "335a8e86",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "from sklearn.metrics.pairwise import cosine_similarity \n",
    "# def recommend_cosine(player):\n",
    "#     index = get_index(player)\n",
    "\n",
    "numerics = ['int16', 'int32', 'int64', 'float16', 'float32', 'float64']\n",
    "\n",
    "newdf = df_2022.select_dtypes(include=numerics).fillna(0)\n",
    "\n",
    "similarities = cosine_similarity(newdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "fb9cf1be",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sofifa_id                 20801.00\n",
       "overall                      91.00\n",
       "potential                    91.00\n",
       "value_eur              45000000.00\n",
       "wage_eur                 270000.00\n",
       "                          ...     \n",
       "overall_MID_start            84.20\n",
       "potential_ATT_start          91.00\n",
       "potential_DEF_start          86.75\n",
       "potential_GK_start           84.00\n",
       "potential_MID_start          87.40\n",
       "Name: 61, Length: 87, dtype: float64"
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf.loc[61,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "f8e10c8f",
   "metadata": {},
   "outputs": [],
   "source": [
    "playerIndex = similarities[61,:].argsort()[-16:][::-1][1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "d8eae409",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "H. Maguire\n",
      "L. Shaw\n",
      "A. Wan-Bissaka\n",
      "D. van de Beek\n",
      "D. Henderson\n",
      "S. Uçan\n",
      "G. Nkoudou\n",
      "C. Larin\n",
      "A. Martial\n",
      "P. Köpke\n",
      "N. Geyrhofer\n",
      "J. Geis\n",
      "M. Sarkaria\n",
      "K. Fischer\n",
      "A. Nordin\n"
     ]
    }
   ],
   "source": [
    "playerIndex = similarities[61,:].argsort()[-16:][::-1][1:]\n",
    "for i in playerIndex:\n",
    "        print(df_2022.loc[i,'short_name'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "id": "29fa6b6f",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.neighbors import NearestNeighbors\n",
    "\n",
    "reco = NearestNeighbors(n_neighbors=11, algorithm='ball_tree').fit(newdf)\n",
    "players_recommended = reco.kneighbors(newdf)[1]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "id": "994a1183",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Here are 10 players similar to Cristiano Ronaldo:\n",
      "\n",
      "H. Maguire\n",
      "L. Shaw\n",
      "A. Wan-Bissaka\n",
      "D. van de Beek\n",
      "D. Henderson\n",
      "A. Martial\n",
      "M. Greenwood\n",
      "S. McTominay\n",
      "De Gea\n"
     ]
    }
   ],
   "source": [
    "print('Here are 10 players similar to Cristiano Ronaldo:' '\\n')\n",
    "for i in players_recommended[61][1:]:\n",
    "    print(df_2022.iloc[i]['short_name'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a31342d6",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.12"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}