FIFA_dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "e8735c24-3c37-42e4-9732-36c68e03fd2b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "from matplotlib import pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "73caad9c-d8b6-45ce-94ed-0955f92abcbf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data is ready for exporatory\n"
     ]
    },
    {
     "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</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>32</td>\n",
       "      <td>6/24/1987</td>\n",
       "      <td>170</td>\n",
       "      <td>72</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>...</td>\n",
       "      <td>68+2</td>\n",
       "      <td>66+2</td>\n",
       "      <td>66+2</td>\n",
       "      <td>66+2</td>\n",
       "      <td>68+2</td>\n",
       "      <td>63+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>63+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20801</td>\n",
       "      <td>https://sofifa.com/player/20801/c-ronaldo-dos-...</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Cristiano Ronaldo dos Santos Aveiro</td>\n",
       "      <td>34</td>\n",
       "      <td>2/5/1985</td>\n",
       "      <td>187</td>\n",
       "      <td>83</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>...</td>\n",
       "      <td>65+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>65+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>53+3</td>\n",
       "      <td>53+3</td>\n",
       "      <td>53+3</td>\n",
       "      <td>61+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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 Junior</td>\n",
       "      <td>27</td>\n",
       "      <td>2/5/1992</td>\n",
       "      <td>175</td>\n",
       "      <td>68</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Paris Saint-Germain</td>\n",
       "      <td>...</td>\n",
       "      <td>66+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>66+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>46+3</td>\n",
       "      <td>46+3</td>\n",
       "      <td>46+3</td>\n",
       "      <td>61+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>200389</td>\n",
       "      <td>https://sofifa.com/player/200389/jan-oblak/20/...</td>\n",
       "      <td>J. Oblak</td>\n",
       "      <td>Jan Oblak</td>\n",
       "      <td>26</td>\n",
       "      <td>1/7/1993</td>\n",
       "      <td>188</td>\n",
       "      <td>87</td>\n",
       "      <td>Slovenia</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>183277</td>\n",
       "      <td>https://sofifa.com/player/183277/eden-hazard/2...</td>\n",
       "      <td>E. Hazard</td>\n",
       "      <td>Eden Hazard</td>\n",
       "      <td>28</td>\n",
       "      <td>1/7/1991</td>\n",
       "      <td>175</td>\n",
       "      <td>74</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>66+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>66+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>61+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18273</th>\n",
       "      <td>245006</td>\n",
       "      <td>https://sofifa.com/player/245006/shuai-shao/20...</td>\n",
       "      <td>Shao Shuai</td>\n",
       "      <td>邵帅</td>\n",
       "      <td>22</td>\n",
       "      <td>3/10/1997</td>\n",
       "      <td>186</td>\n",
       "      <td>79</td>\n",
       "      <td>China PR</td>\n",
       "      <td>Beijing Renhe FC</td>\n",
       "      <td>...</td>\n",
       "      <td>43+2</td>\n",
       "      <td>42+2</td>\n",
       "      <td>42+2</td>\n",
       "      <td>42+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>45+2</td>\n",
       "      <td>46+2</td>\n",
       "      <td>46+2</td>\n",
       "      <td>46+2</td>\n",
       "      <td>45+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18274</th>\n",
       "      <td>250995</td>\n",
       "      <td>https://sofifa.com/player/250995/mingjie-xiao/...</td>\n",
       "      <td>Xiao Mingjie</td>\n",
       "      <td>Mingjie Xiao</td>\n",
       "      <td>22</td>\n",
       "      <td>1/1/1997</td>\n",
       "      <td>177</td>\n",
       "      <td>66</td>\n",
       "      <td>China PR</td>\n",
       "      <td>Shanghai SIPG FC</td>\n",
       "      <td>...</td>\n",
       "      <td>44+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>44+2</td>\n",
       "      <td>46+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>46+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18275</th>\n",
       "      <td>252332</td>\n",
       "      <td>https://sofifa.com/player/252332/wei-zhang/20/...</td>\n",
       "      <td>Zhang Wei</td>\n",
       "      <td>张威</td>\n",
       "      <td>19</td>\n",
       "      <td>5/16/2000</td>\n",
       "      <td>186</td>\n",
       "      <td>75</td>\n",
       "      <td>China PR</td>\n",
       "      <td>Hebei China Fortune FC</td>\n",
       "      <td>...</td>\n",
       "      <td>47+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>47+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18276</th>\n",
       "      <td>251110</td>\n",
       "      <td>https://sofifa.com/player/251110/haijian-wang/...</td>\n",
       "      <td>Wang Haijian</td>\n",
       "      <td>汪海健</td>\n",
       "      <td>18</td>\n",
       "      <td>8/2/2000</td>\n",
       "      <td>185</td>\n",
       "      <td>74</td>\n",
       "      <td>China PR</td>\n",
       "      <td>Shanghai Greenland Shenhua FC</td>\n",
       "      <td>...</td>\n",
       "      <td>48+2</td>\n",
       "      <td>48+2</td>\n",
       "      <td>48+2</td>\n",
       "      <td>48+2</td>\n",
       "      <td>48+2</td>\n",
       "      <td>48+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>48+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18277</th>\n",
       "      <td>233449</td>\n",
       "      <td>https://sofifa.com/player/233449/ximing-pan/20...</td>\n",
       "      <td>Pan Ximing</td>\n",
       "      <td>潘喜明</td>\n",
       "      <td>26</td>\n",
       "      <td>1/11/1993</td>\n",
       "      <td>182</td>\n",
       "      <td>78</td>\n",
       "      <td>China PR</td>\n",
       "      <td>Hebei China Fortune FC</td>\n",
       "      <td>...</td>\n",
       "      <td>48+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>49+2</td>\n",
       "      <td>48+2</td>\n",
       "      <td>48+2</td>\n",
       "      <td>50+2</td>\n",
       "      <td>50+2</td>\n",
       "      <td>50+2</td>\n",
       "      <td>48+2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18278 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       sofifa_id                                         player_url  \\\n",
       "0         158023  https://sofifa.com/player/158023/lionel-messi/...   \n",
       "1          20801  https://sofifa.com/player/20801/c-ronaldo-dos-...   \n",
       "2         190871  https://sofifa.com/player/190871/neymar-da-sil...   \n",
       "3         200389  https://sofifa.com/player/200389/jan-oblak/20/...   \n",
       "4         183277  https://sofifa.com/player/183277/eden-hazard/2...   \n",
       "...          ...                                                ...   \n",
       "18273     245006  https://sofifa.com/player/245006/shuai-shao/20...   \n",
       "18274     250995  https://sofifa.com/player/250995/mingjie-xiao/...   \n",
       "18275     252332  https://sofifa.com/player/252332/wei-zhang/20/...   \n",
       "18276     251110  https://sofifa.com/player/251110/haijian-wang/...   \n",
       "18277     233449  https://sofifa.com/player/233449/ximing-pan/20...   \n",
       "\n",
       "              short_name                            long_name  age        dob  \\\n",
       "0               L. Messi       Lionel Andrés Messi Cuccittini   32  6/24/1987   \n",
       "1      Cristiano Ronaldo  Cristiano Ronaldo dos Santos Aveiro   34   2/5/1985   \n",
       "2              Neymar Jr        Neymar da Silva Santos Junior   27   2/5/1992   \n",
       "3               J. Oblak                            Jan Oblak   26   1/7/1993   \n",
       "4              E. Hazard                          Eden Hazard   28   1/7/1991   \n",
       "...                  ...                                  ...  ...        ...   \n",
       "18273         Shao Shuai                                   邵帅   22  3/10/1997   \n",
       "18274       Xiao Mingjie                         Mingjie Xiao   22   1/1/1997   \n",
       "18275          Zhang Wei                                   张威   19  5/16/2000   \n",
       "18276       Wang Haijian                                  汪海健   18   8/2/2000   \n",
       "18277         Pan Ximing                                  潘喜明   26  1/11/1993   \n",
       "\n",
       "       height_cm  weight_kg nationality                           club  ...  \\\n",
       "0            170         72   Argentina                   FC Barcelona  ...   \n",
       "1            187         83    Portugal                       Juventus  ...   \n",
       "2            175         68      Brazil            Paris Saint-Germain  ...   \n",
       "3            188         87    Slovenia                Atlético Madrid  ...   \n",
       "4            175         74     Belgium                    Real Madrid  ...   \n",
       "...          ...        ...         ...                            ...  ...   \n",
       "18273        186         79    China PR               Beijing Renhe FC  ...   \n",
       "18274        177         66    China PR               Shanghai SIPG FC  ...   \n",
       "18275        186         75    China PR         Hebei China Fortune FC  ...   \n",
       "18276        185         74    China PR  Shanghai Greenland Shenhua FC  ...   \n",
       "18277        182         78    China PR         Hebei China Fortune FC  ...   \n",
       "\n",
       "        lwb   ldm   cdm   rdm   rwb    lb   lcb    cb   rcb    rb  \n",
       "0      68+2  66+2  66+2  66+2  68+2  63+2  52+2  52+2  52+2  63+2  \n",
       "1      65+3  61+3  61+3  61+3  65+3  61+3  53+3  53+3  53+3  61+3  \n",
       "2      66+3  61+3  61+3  61+3  66+3  61+3  46+3  46+3  46+3  61+3  \n",
       "3       NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "4      66+3  63+3  63+3  63+3  66+3  61+3  49+3  49+3  49+3  61+3  \n",
       "...     ...   ...   ...   ...   ...   ...   ...   ...   ...   ...  \n",
       "18273  43+2  42+2  42+2  42+2  43+2  45+2  46+2  46+2  46+2  45+2  \n",
       "18274  44+2  43+2  43+2  43+2  44+2  46+2  47+2  47+2  47+2  46+2  \n",
       "18275  47+2  49+2  49+2  49+2  47+2  47+2  49+2  49+2  49+2  47+2  \n",
       "18276  48+2  48+2  48+2  48+2  48+2  48+2  49+2  49+2  49+2  48+2  \n",
       "18277  48+2  49+2  49+2  49+2  48+2  48+2  50+2  50+2  50+2  48+2  \n",
       "\n",
       "[18278 rows x 104 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa=pd.read_csv('players_20.csv')\n",
    "print('Data is ready for exporatory')\n",
    "fifa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ee489d1c-faba-402f-b556-666a48da29e1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(18278, 104)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a93e7fe7-8c03-4865-beed-d72356ce1a78",
   "metadata": {},
   "outputs": [],
   "source": [
    "#To drop irrelevant columns\n",
    "fifa.drop([\"sofifa_id\", \"player_url\", \"long_name\", \"dob\"], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6e635ea8-a5cf-4b81-a8e2-d143fd5ba858",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['short_name', 'age', 'height_cm', 'weight_kg', 'nationality', 'club',\n",
       "       'overall', 'potential', 'value_eur', 'wage_eur', 'player_positions',\n",
       "       'preferred_foot', 'international_reputation', 'weak_foot',\n",
       "       'skill_moves', 'work_rate', 'body_type', 'real_face',\n",
       "       'release_clause_eur', 'player_tags', 'team_position',\n",
       "       'team_jersey_number', 'loaned_from', 'joined', 'contract_valid_until',\n",
       "       'nation_position', 'nation_jersey_number', 'pace', 'shooting',\n",
       "       'passing', 'dribbling', 'defending', 'physic', 'gk_diving',\n",
       "       'gk_handling', 'gk_kicking', 'gk_reflexes', 'gk_speed',\n",
       "       'gk_positioning', 'player_traits', 'attacking_crossing',\n",
       "       'attacking_finishing', 'attacking_heading_accuracy',\n",
       "       'attacking_short_passing', 'attacking_volleys', 'skill_dribbling',\n",
       "       'skill_curve', 'skill_fk_accuracy', 'skill_long_passing',\n",
       "       'skill_ball_control', 'movement_acceleration', 'movement_sprint_speed',\n",
       "       'movement_agility', 'movement_reactions', 'movement_balance',\n",
       "       'power_shot_power', 'power_jumping', 'power_stamina', 'power_strength',\n",
       "       'power_long_shots', 'mentality_aggression', 'mentality_interceptions',\n",
       "       'mentality_positioning', 'mentality_vision', 'mentality_penalties',\n",
       "       'mentality_composure', 'defending_marking', 'defending_standing_tackle',\n",
       "       'defending_sliding_tackle', 'goalkeeping_diving',\n",
       "       'goalkeeping_handling', 'goalkeeping_kicking',\n",
       "       'goalkeeping_positioning', 'goalkeeping_reflexes', 'ls', 'st', 'rs',\n",
       "       'lw', 'lf', 'cf', 'rf', 'rw', 'lam', 'cam', 'ram', 'lm', 'lcm', 'cm',\n",
       "       'rcm', 'rm', 'lwb', 'ldm', 'cdm', 'rdm', 'rwb', 'lb', 'lcb', 'cb',\n",
       "       'rcb', 'rb'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "ba735239-a2ba-4f0b-b316-233ad0c28124",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "short_name\n",
      "age\n",
      "height_cm\n",
      "weight_kg\n",
      "nationality\n",
      "club\n",
      "overall\n",
      "potential\n",
      "value_eur\n",
      "wage_eur\n",
      "player_positions\n",
      "preferred_foot\n",
      "international_reputation\n",
      "weak_foot\n",
      "skill_moves\n",
      "work_rate\n",
      "body_type\n",
      "real_face\n",
      "release_clause_eur\n",
      "player_tags\n",
      "team_position\n",
      "team_jersey_number\n",
      "loaned_from\n",
      "joined\n",
      "contract_valid_until\n",
      "nation_position\n",
      "nation_jersey_number\n",
      "pace\n",
      "shooting\n",
      "passing\n",
      "dribbling\n",
      "defending\n",
      "physic\n",
      "gk_diving\n",
      "gk_handling\n",
      "gk_kicking\n",
      "gk_reflexes\n",
      "gk_speed\n",
      "gk_positioning\n",
      "player_traits\n",
      "attacking_crossing\n",
      "attacking_finishing\n",
      "attacking_heading_accuracy\n",
      "attacking_short_passing\n",
      "attacking_volleys\n",
      "skill_dribbling\n",
      "skill_curve\n",
      "skill_fk_accuracy\n",
      "skill_long_passing\n",
      "skill_ball_control\n",
      "movement_acceleration\n",
      "movement_sprint_speed\n",
      "movement_agility\n",
      "movement_reactions\n",
      "movement_balance\n",
      "power_shot_power\n",
      "power_jumping\n",
      "power_stamina\n",
      "power_strength\n",
      "power_long_shots\n",
      "mentality_aggression\n",
      "mentality_interceptions\n",
      "mentality_positioning\n",
      "mentality_vision\n",
      "mentality_penalties\n",
      "mentality_composure\n",
      "defending_marking\n",
      "defending_standing_tackle\n",
      "defending_sliding_tackle\n",
      "goalkeeping_diving\n",
      "goalkeeping_handling\n",
      "goalkeeping_kicking\n",
      "goalkeeping_positioning\n",
      "goalkeeping_reflexes\n",
      "ls\n",
      "st\n",
      "rs\n",
      "lw\n",
      "lf\n",
      "cf\n",
      "rf\n",
      "rw\n",
      "lam\n",
      "cam\n",
      "ram\n",
      "lm\n",
      "lcm\n",
      "cm\n",
      "rcm\n",
      "rm\n",
      "lwb\n",
      "ldm\n",
      "cdm\n",
      "rdm\n",
      "rwb\n",
      "lb\n",
      "lcb\n",
      "cb\n",
      "rcb\n",
      "rb\n"
     ]
    }
   ],
   "source": [
    "#To print columns name using loop\n",
    "for col in fifa.columns:\n",
    "    print(col)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "6a771536-ecf0-41e3-86b8-4b185ff10bbd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(18278, 100)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "b87a149d-bd64-4c20-afdb-c323f25f1144",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "182.78"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "18278/100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "50275321-09d7-4731-854e-da1c2c618fa0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "nationality\n",
       "England                1667\n",
       "Germany                1216\n",
       "Spain                  1035\n",
       "France                  984\n",
       "Argentina               886\n",
       "                       ... \n",
       "Liberia                   1\n",
       "São Tomé & Príncipe       1\n",
       "Puerto Rico               1\n",
       "Bahrain                   1\n",
       "Indonesia                 1\n",
       "Name: count, Length: 162, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To find the nationality of player in a data set\n",
    "fifa['nationality'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "9cbf6cb7-bbc2-4b8b-bfc6-0cd4b161cb90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "nationality\n",
       "England        1667\n",
       "Germany        1216\n",
       "Spain          1035\n",
       "France          984\n",
       "Argentina       886\n",
       "Brazil          824\n",
       "Italy           732\n",
       "Colombia        591\n",
       "Japan           453\n",
       "Netherlands     416\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa['nationality'].value_counts()[0:10]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "e66811b6-084e-4e5f-907b-14ad32fc4c36",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['England', 'Germany', 'Spain', 'France', 'Argentina', 'Brazil', 'Italy',\n",
       "       'Colombia', 'Japan', 'Netherlands'],\n",
       "      dtype='object', name='nationality')"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa['nationality'].value_counts()[0:10].keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "96f55e05-b2fb-499f-a6e9-2af286170d66",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "nationality\n",
       "England      1667\n",
       "Germany      1216\n",
       "Spain        1035\n",
       "France        984\n",
       "Argentina     886\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa['nationality'].value_counts()[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "60278ebb-1f1b-49b6-9328-c9c36084463e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['England', 'Germany', 'Spain', 'France', 'Argentina'], dtype='object', name='nationality')"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa['nationality'].value_counts()[0:5].keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "3277ad13-32fe-48bd-ba30-e35b04c78942",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAekAAAHqCAYAAAAgWrY5AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy81sbWrAAAACXBIWXMAAA9hAAAPYQGoP6dpAAAtqUlEQVR4nO3deXRUZZ7/8U9BQiWpVMISIQRDWMJOICQBBBkRQUEWwXZjUzLYLYLYILKYQQdcGtQGsWUaEIetFQc3dGjkNAICIos0IUGURVYDAmYUTYUtJOb5/eGPakpIWJJUPYH365x7TureW/d+KxreVNUN5TDGGAEAAOtUCPQAAADg4og0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYKmgQA9wLSssLNSRI0fkdrvlcDgCPQ4AwBLGGOXm5iomJkYVKhT9fJlIl6EjR44oNjY20GMAACx16NAh3XjjjUVuJ9JlyO12S/r1P0JERESApwEA2MLj8Sg2NtbbiaIQ6TJ07iXuiIgIIg0AuMCl3grlwjEAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLBQV6gOtBbmauHOHFf7A3cD0JjgpWSO2QQI8BWI9I+0Fmx0y55Ar0GIA9Qiropt1tCDVwCUTaD6aokb5TjUCPAVghTqc0/sxO5f+QT6SBSyDSfpClUO2XO9BjAADKGS4cAwDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLXfORPnjwoBwOhzIzMwM9CgAAV+SqIr1hwwZVrFhR3bp1K+15SiQ1NVV9+vTxWRcbG6ujR4+qefPmgRkKAICrdFWRnjt3rh5//HF9/vnnysrKKnI/Y4wKCgquerjSULFiRUVHRysoKCigcwAAcKWuONInT57Uu+++q6FDh6pnz56aP3++d9uaNWvkcDi0fPlypaSkyOl0at26dcrNzdWAAQPkcrlUs2ZNTZs2TbfeeqtGjhzpve/Zs2c1duxY1apVSy6XS23bttWaNWu82+fPn6/KlStr+fLlatKkicLDw9WtWzcdPXpUkjRx4kQtWLBA//u//yuHwyGHw6E1a9Zc8HL3uRlXrVqllJQUhYWFqX379tq9e7f3XPv27VPv3r1Vo0YNhYeHq3Xr1lq5cuWVfqsAACiRK470O++8o0aNGqlRo0YaOHCg5s2bJ2OMzz5jx47V5MmTtXPnTrVo0UKjRo3S+vXrtWTJEq1YsULr1q3T1q1bfe7z7//+71q/fr0WLVqkL7/8Uvfdd5+6deumPXv2ePc5deqUpkyZojfffFOfffaZsrKyNHr0aEnS6NGjdf/993vDffToUbVv377IxzF+/HhNnTpVW7ZsUVBQkAYPHuzdduLECXXv3l0rV65URkaGunbtql69ehX7qoEk5eXlyePx+CwAAFw1c4Xat29vXn31VWOMMfn5+SYqKsqsWLHCGGPM6tWrjSTz0Ucfeff3eDwmODjYvPfee951P//8swkLCzMjRowwxhizd+9e43A4zHfffedzrs6dO5u0tDRjjDHz5s0zkszevXu92//617+aGjVqeG8PGjTI9O7d2+cYBw4cMJJMRkaGz4wrV6707vPxxx8bSeb06dNFPu6mTZua6dOnF/u9mTBhgpF0wVJPh41kWFhYZEwDecxqrTaedE+xP0/AtSwnJ8dIMjk5OcXud0XPpHfv3q3Nmzerb9++kqSgoCA98MADmjt3rs9+KSkp3q/379+v/Px8tWnTxrsuMjJSjRo18t7eunWrjDFq2LChwsPDvcvatWu1b98+735hYWGqX7++93bNmjWVnZ19JQ/Bq0WLFj7HkeQ91smTJzV27Fg1bdpUlStXVnh4uHbt2nXJZ9JpaWnKycnxLocOHbqq2QAAkKQruppqzpw5KigoUK1atbzrjDEKDg7WTz/95F3ncrl8tkuSw+HwOda59ZJUWFioihUrKj09XRUrVvTZLzw83Pt1cHCwzzaHw+FznCtx/rHOzVZYWChJGjNmjJYvX64pU6YoPj5eoaGhuvfee3X27Nlij+l0OuV0Oq9qHgAAfuuyI11QUKC//e1vmjp1qu644w6fbffcc48WLlx40V9zql+/voKDg7V582bFxsZKkjwej/bs2aOOHTtKklq1aqVffvlF2dnZ+rd/+7erfjCVKlXSL7/8ctX3P2fdunVKTU3V3XffLenX96gPHjxY4uMCAHAlLjvSS5cu1U8//aSHH35YkZGRPtvuvfdezZkzR9OmTbvgfm63W4MGDdKYMWNUtWpVVa9eXRMmTFCFChW8z2AbNmyoAQMG6KGHHtLUqVPVqlUr/fDDD/r000+VkJCg7t27X9aMderU0fLly7V7925Vq1btgjkvV3x8vBYvXqxevXrJ4XDomWee8T7LBgDAXy77Pek5c+aoS5cuFw3fPffco8zMzAuu2D7nlVdeUbt27dSzZ0916dJFN998s5o0aaKQkBDvPvPmzdNDDz2kJ598Uo0aNdJdd92lL774wvvs+3L84Q9/UKNGjZSSkqIbbrhB69evv+z7nm/atGmqUqWK2rdvr169eqlr165KSkq6qmMBAHC1HOZq39QtgZMnT6pWrVqaOnWqHn74YX+f3m88Ho8iIyNVT4e1X7UufQfgOtBAuZqtdCWnJ8ud5A70OEBAnOtDTk6OIiIiitzPL/8MV0ZGhnbt2qU2bdooJydHzz33nCSpd+/e/jg9AADlkt/+rcwpU6Zo9+7dqlSpkpKTk7Vu3TpFRUX56/QAAJQ7fol0q1atlJ6e7o9TAQBwzbjmP6oSAIDyikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWCAj3A9aC2TquicgM9BmCFOJ0K9AhAuUGk/WC0dsulw4EeA7BHSAUFRwUHegrAekTaDxLXJioiPCLQYwDWCI4KVkjtkECPAViPSPuBO9Etd4Q70GMAAMoZLhwDAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSfAqWH+Rm5soR7gj0GMA1j4/AxLWGSPtBZsdMueQK9BjAtS+sgm7a2YZQ45pBpP1gypPSdw0DPQVwbYv7Vho/qVD5P+QTaVwziLQfZMVK+4k0AOAKceEYAACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFjKikinpqbK4XBcsOzduzfQowEAEDBBgR7gnG7dumnevHk+62644Qaf22fPnlWlSpX8ORYAAAFjxTNpSXI6nYqOjvZZOnfurOHDh2vUqFGKiorS7bffLkl65ZVXlJCQIJfLpdjYWA0bNkwnTpzwHmv+/PmqXLmyli9friZNmig8PFzdunXT0aNHfc45d+5cNWvWTE6nUzVr1tTw4cO923JycvTII4+oevXqioiI0G233aZt27b555sBAIAsinRRFixYoKCgIK1fv16vv/66JKlChQp67bXX9NVXX2nBggX69NNPNXbsWJ/7nTp1SlOmTNGbb76pzz77TFlZWRo9erR3+8yZM/XYY4/pkUce0fbt27VkyRLFx8dLkowx6tGjh44dO6Zly5YpPT1dSUlJ6ty5s44fP+6/Bw8AuK5Z83L30qVLFR4e7r195513SpLi4+P18ssv++w7cuRI79d169bV888/r6FDh2rGjBne9fn5+Zo1a5bq168vSRo+fLiee+457/YXXnhBTz75pEaMGOFd17p1a0nS6tWrtX37dmVnZ8vpdEqSpkyZoo8++kjvv/++HnnkkYs+hry8POXl5XlvezyeK/oeAABwPmsi3alTJ82cOdN72+VyqV+/fkpJSblg39WrV2vSpEnasWOHPB6PCgoKdObMGZ08eVIul0uSFBYW5g20JNWsWVPZ2dmSpOzsbB05ckSdO3e+6Czp6ek6ceKEqlWr5rP+9OnT2rdvX5GPYfLkyXr22Wcv/0EDAFAMayLtcrm8Lzf/dv35vv32W3Xv3l2PPvqonn/+eVWtWlWff/65Hn74YeXn53v3Cw4O9rmfw+GQMUaSFBoaWuwshYWFqlmzptasWXPBtsqVKxd5v7S0NI0aNcp72+PxKDY2tthzAQBQFGsifbm2bNmigoICTZ06VRUq/PqW+rvvvntFx3C73apTp45WrVqlTp06XbA9KSlJx44dU1BQkOrUqXPZx3U6nd6XxwEAKCnrLxz7rfr166ugoEDTp0/X/v379eabb2rWrFlXfJyJEydq6tSpeu2117Rnzx5t3bpV06dPlyR16dJF7dq1U58+fbR8+XIdPHhQGzZs0NNPP60tW7aU9kMCAOCiyl2kExMT9corr+ill15S8+bNtXDhQk2ePPmKjzNo0CC9+uqrmjFjhpo1a6aePXtqz549kn59aXzZsmW65ZZbNHjwYDVs2FB9+/bVwYMHVaNGjdJ+SAAAXJTDnHujFqXO4/EoMjJS9V5dqv0tXZe+A4Cr1uAbafYQKTk9We4kd6DHAYp1rg85OTmKiIgocr9y90waAIDrBZEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSRBoAAEsRaQAALEWkAQCwFJEGAMBSQYEe4HpQ+5BUMTTQUwDXtrhvAz0BUPqItB+Mniq5Aj0EcD0Iq6DgqOBATwGUGiLtB4lrExURHhHoMYBrXnBUsEJqhwR6DKDUEGk/cCe65Y5wB3oMAEA5w4VjAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYik/B8oPczFw5wh2BHgPAb/DRlrAdkfaDzI6ZcskV6DEA/EaFEKnN7psINaxFpP2gkaaohr4L9BgAznNKcdp5Zrzyf8gn0rAWkfaDUGXJrf2BHgMAUM5w4RgAAJYi0gAAWIpIAwBgKSINAICliDQAAJYi0gAAWIpIAwBgKSINAICliDQAAJYi0gAAWIpIAwBgKSINAICliDQAAJYi0gAAWIpIAwBgKSINAICliDQAAJYi0gAAWIpIAwBgKSINAICliDQAAJYi0gAAWIpIAwBgKSINAICliDQAAJYi0gAAWIpI/38TJ05UYmJioMcAAMCrXEQ6OztbQ4YMUe3ateV0OhUdHa2uXbtq48aNpXaO0aNHa9WqVaV2PAAASioo0ANcjnvuuUf5+flasGCB6tWrp++//16rVq3S8ePHS+0c4eHhCg8PL7XjAQBQUtY/k/7555/1+eef66WXXlKnTp0UFxenNm3aKC0tTT169JAkORwOzZw5U3feeadCQ0NVt25dvffeez7HGTdunBo2bKiwsDDVq1dPzzzzjPLz873bf/tyd2pqqvr06aMpU6aoZs2aqlatmh577DGf+wAAUJasj/S5Z7gfffSR8vLyitzvmWee0T333KNt27Zp4MCB6tevn3bu3Ond7na7NX/+fO3YsUN/+ctf9MYbb2jatGnFnnv16tXat2+fVq9erQULFmj+/PmaP39+kfvn5eXJ4/H4LAAAXDVTDrz//vumSpUqJiQkxLRv396kpaWZbdu2ebdLMo8++qjPfdq2bWuGDh1a5DFffvllk5yc7L09YcIE07JlS+/tQYMGmbi4OFNQUOBdd99995kHHnigyGNOmDDBSLpgOax6xkgsLCwWLR41MKu12njSPVfyxxFQKnJycowkk5OTU+x+1j+Tln59T/rIkSNasmSJunbtqjVr1igpKcnnWW27du187tOuXTufZ9Lvv/++OnTooOjoaIWHh+uZZ55RVlZWsedt1qyZKlas6L1ds2ZNZWdnF7l/WlqacnJyvMuhQ4eu8JECAPAv5SLSkhQSEqLbb79d//mf/6kNGzYoNTVVEyZMKPY+DodDkrRp0yb17dtXd955p5YuXaqMjAyNHz9eZ8+eLfb+wcHBFxyvsLCwyP2dTqciIiJ8FgAArla5ifRvNW3aVCdPnvTe3rRpk8/2TZs2qXHjxpKk9evXKy4uTuPHj1dKSooaNGigb7/91q/zAgBwpaz/Fawff/xR9913nwYPHqwWLVrI7XZry5Ytevnll9W7d2/vfu+9955SUlLUoUMHLVy4UJs3b9acOXMkSfHx8crKytKiRYvUunVrffzxx/rwww8D9ZAAALgs1kc6PDxcbdu21bRp07Rv3z7l5+crNjZWf/jDH/Qf//Ef3v2effZZLVq0SMOGDVN0dLQWLlyopk2bSpJ69+6tJ554QsOHD1deXp569OihZ555RhMnTgzQowIA4NIcxhgT6CFKyuFw6MMPP1SfPn0CPYoPj8ejyMhIHVY91dL+QI8D4Dy5aqB0zVZyerLcSe5Aj4PrzLk+5OTkFHv9Url9TxoAgGsdkQYAwFLWvyd9Oa6BV+wBALgAz6QBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASwUFeoDrwWnVVq4qBnoMAOc5pbhAjwBcEpH2g90arcNyBXoMAL9RIUQKjgoO9BhAkYi0HySuTVREeESgxwDwG8FRwQqpHRLoMYAiEWk/cCe65Y5wB3oMAEA5w4VjAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYik/B8oPczFw5wh2BHgNAOcNHaYJI+0Fmx0y55Ar0GADKmQphUpudNxHq6xiR9oNGs6eoRvJ3gR4DQDlyamecdg4cr/wf8on0dYxI+0Fooyy5k/YHegwAQDnDhWMAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYCkiDQCApYg0AACWItIAAFiKSAMAYKlSifSxY8c0YsQIxcfHKyQkRDVq1FCHDh00a9YsnTp1qjROAQDAdSeopAfYv3+/br75ZlWuXFmTJk1SQkKCCgoK9M0332ju3LmKiYnRXXfddcXHzc/PV3BwcEnHAwCg3CrxM+lhw4YpKChIW7Zs0f33368mTZooISFB99xzjz7++GP16tVLkpSTk6NHHnlE1atXV0REhG677TZt27bNe5yJEycqMTFRc+fOVb169eR0OmWMkcPh0Ouvv66ePXsqLCxMTZo00caNG7V3717deuutcrlcateunfbt2+c91r59+9S7d2/VqFFD4eHhat26tVauXOkzd506dTRp0iQNHjxYbrdbtWvX1uzZs73bb7vtNg0fPtznPj/++KOcTqc+/fTTkn7bAAC4pBJF+scff9Qnn3yixx57TC6X66L7OBwOGWPUo0cPHTt2TMuWLVN6erqSkpLUuXNnHT9+3Lvv3r179e677+qDDz5QZmamd/3zzz+vhx56SJmZmWrcuLH69++vIUOGKC0tTVu2bJEkn6CeOHFC3bt318qVK5WRkaGuXbuqV69eysrK8plt6tSpSklJUUZGhoYNG6ahQ4dq165dkqTf//73evvtt5WXl+fdf+HChYqJiVGnTp1K8m0DAODymBLYtGmTkWQWL17ss75atWrG5XIZl8tlxo4da1atWmUiIiLMmTNnfParX7++ef31140xxkyYMMEEBweb7Oxsn30kmaefftp7e+PGjUaSmTNnjnfd//zP/5iQkJBiZ23atKmZPn2693ZcXJwZOHCg93ZhYaGpXr26mTlzpjHGmDNnzpiqVauad955x7tPYmKimThxYpHnOHPmjMnJyfEuhw4dMpLM4bX1jDFiYWFhuezFk97ArNZq40n3GFx7cnJyjCSTk5NT7H6lcuGYw+Hwub1582ZlZmaqWbNmysvLU3p6uk6cOKFq1aopPDzcuxw4cMDnZeq4uDjdcMMNFxy/RYsW3q9r1KghSUpISPBZd+bMGXk8HknSyZMnNXbsWDVt2lSVK1dWeHi4du3adcEz6fOP63A4FB0drezsbEmS0+nUwIEDNXfuXElSZmamtm3bptTU1CK/D5MnT1ZkZKR3iY2NLfb7BgBAcUp04Vh8fLwcDof3JeJz6tWrJ0kKDQ2VJBUWFqpmzZpas2bNBceoXLmy9+uiXjI//wKyc38huNi6wsJCSdKYMWO0fPlyTZkyRfHx8QoNDdW9996rs2fPFnncc8c5dwzp15e8ExMTdfjwYc2dO1edO3dWXFzcRWeUpLS0NI0aNcp72+PxEGoAwFUrUaSrVaum22+/Xf/1X/+lxx9/vMjIJiUl6dixYwoKClKdOnVKcsrLsm7dOqWmpuruu++W9Ot71AcPHrzi4yQkJCglJUVvvPGG3n77bU2fPr3Y/Z1Op5xO59WMDADABUr8cveMGTNUUFCglJQUvfPOO9q5c6d2796tt956S7t27VLFihXVpUsXtWvXTn369NHy5ct18OBBbdiwQU8//bT3wq/SFB8fr8WLF3tfou7fv7/PM+Qr8fvf/14vvviifvnlF2/0AQDwhxJHun79+srIyFCXLl2Ulpamli1bKiUlRdOnT9fo0aP1/PPPy+FwaNmyZbrllls0ePBgNWzYUH379tXBgwe97zGXpmnTpqlKlSpq3769evXqpa5duyopKemqjtWvXz8FBQWpf//+CgkJKeVJAQAomsMYYwI9hM0OHTqkOnXq6J///OcVh97j8SgyMlKH19ZTrVv2l9GEAK5FuVsbKD15tpLTk+VOcgd6HJSyc33IyclRREREkfuV+F8cu1bl5+fr6NGjeuqpp3TTTTdd9TNxAACuFh+wUYT169crLi5O6enpmjVrVqDHAQBch3gmXYRbb71VvBMAAAgknkkDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAlgoK9ADXg9O7ays3vGKgxwBQjpzaGRfoEWABIu0Hux8ZrcNyBXoMAOVMhTApOCo40GMggIi0HySuTVREeESgxwBQzgRHBSukdkigx0AAEWk/cCe65Y5wB3oMAEA5w4VjAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYik/B8oPczFw5wh2BHgMAUEL+/vhQIu0HmR0z5ZIr0GMAAErIEVZBbXe28VuoibQf7Hs6RmoSFegxAAAlEHogTw2ePqz8H/KJ9LXkTJxThU1CAz0GAKCc4cIxAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALBUuY/0/PnzVbly5TI/z8GDB+VwOJSZmVnm5wIAQCrjSKempsrhcFywdOvWrSxPCwDANSGorE/QrVs3zZs3z2ed0+ks69MCAFDulfnL3U6nU9HR0T5LlSpVJEkOh0P//d//rbvvvlthYWFq0KCBlixZ4nP/JUuWqEGDBgoNDVWnTp20YMECORwO/fzzzxc93759+9S7d2/VqFFD4eHhat26tVauXOmzT506dTRp0iQNHjxYbrdbtWvX1uzZs3322bx5s1q1aqWQkBClpKQoIyOj9L4pAABchoC/J/3ss8/q/vvv15dffqnu3btrwIABOn78uKRf3we+99571adPH2VmZmrIkCEaP358scc7ceKEunfvrpUrVyojI0Ndu3ZVr169lJWV5bPf1KlTvfEdNmyYhg4dql27dkmSTp48qZ49e6pRo0ZKT0/XxIkTNXr06Es+lry8PHk8Hp8FAICrVeaRXrp0qcLDw32W559/3rs9NTVV/fr1U3x8vCZNmqSTJ09q8+bNkqRZs2apUaNG+vOf/6xGjRqpb9++Sk1NLfZ8LVu21JAhQ5SQkKAGDRrohRdeUL169S54ht69e3cNGzZM8fHxGjdunKKiorRmzRpJ0sKFC/XLL79o7ty5atasmXr27KkxY8Zc8rFOnjxZkZGR3iU2NvbKvlkAAJynzN+T7tSpk2bOnOmzrmrVqt6vW7Ro4f3a5XLJ7XYrOztbkrR79261bt3a575t2rQp9nwnT57Us88+q6VLl+rIkSMqKCjQ6dOnL3gmff55HQ6HoqOjvefduXOnWrZsqbCwMO8+7dq1u+RjTUtL06hRo7y3PR4PoQYAXLUyj7TL5VJ8fHyR24ODg31uOxwOFRYWSpKMMXI4HD7bjTHFnm/MmDFavny5pkyZovj4eIWGhuree+/V2bNnr+i8V8PpdHJRHACg1AT8PeniNG7cWP/85z991m3ZsqXY+6xbt06pqam6++67lZCQoOjoaB08ePCKztu0aVNt27ZNp0+f9q7btGnTFR0DAICSKvNI5+Xl6dixYz7LDz/8cFn3HTJkiHbt2qVx48bpm2++0bvvvqv58+dL0gXPsM+Jj4/X4sWLlZmZqW3btql///7eZ8iXq3///qpQoYIefvhh7dixQ8uWLdOUKVOu6BgAAJRUmUf6H//4h2rWrOmzdOjQ4bLuW7duXb3//vtavHixWrRooZkzZ3qv7i7qZeVp06apSpUqat++vXr16qWuXbsqKSnpimYODw/X3//+d+3YsUOtWrXS+PHj9dJLL13RMQAAKCmHudo3YAPkT3/6k2bNmqVDhw4FepRL8ng8ioyM1EtvfK3C5OqBHgcAUAJhO0+rxYB9Sk5PljvJXaJjnetDTk6OIiIiityvzC8cK6kZM2aodevWqlatmtavX68///nPGj58eKDHAgCgzFkf6T179uiFF17Q8ePHVbt2bT355JNKS0sL9FgAAJQ56yM9bdo0TZs2LdBjAADgd1b/ChYAANczIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAliLSAABYikgDAGApIg0AgKWINAAAlgoK9ADXg5Bv86Sw04EeAwBQAqEH8vx+TiLtB/VfOCKXcgI9BgCghBxhFRQcFey38xFpP0hcm6iI8IhAjwEAKKHgqGCF1A7x2/mItB+4E91yR7gDPQYAoJzhwjEAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLEWkAACxFpAEAsBSRBgDAUkQaAABLBQV6gGuZMUaS5PF4AjwJAMAm57pwrhNFIdJl6Mcff5QkxcbGBngSAICNcnNzFRkZWeR2Il2GqlatKknKysoq9j+CLTwej2JjY3Xo0CFFREQEepzLwsz+wcz+Ud5mLm/zSvbMbIxRbm6uYmJiit2PSJehChV+fcs/MjKy3PwPLEkRERHlal6Jmf2Fmf2jvM1c3uaV7Jj5cp68ceEYAACWItIAAFiKSJchp9OpCRMmyOl0BnqUy1Le5pWY2V+Y2T/K28zlbV6p/M3sMJe6/hsAAAQEz6QBALAUkQYAwFJEGgAASxFpAAAsRaTLyIwZM1S3bl2FhIQoOTlZ69atC8gckydPVuvWreV2u1W9enX16dNHu3fv9tnHGKOJEycqJiZGoaGhuvXWW/X111/77JOXl6fHH39cUVFRcrlcuuuuu3T48GG/PQaHw6GRI0daPfN3332ngQMHqlq1agoLC1NiYqLS09OtnbmgoEBPP/206tatq9DQUNWrV0/PPfecCgsLrZn5s88+U69evRQTEyOHw6GPPvrIZ3tpzffTTz/pwQcfVGRkpCIjI/Xggw/q559/LtV58/PzNW7cOCUkJMjlcikmJkYPPfSQjhw5ErB5LzXzbw0ZMkQOh0Ovvvqq9TPv3LlTd911lyIjI+V2u3XTTTcpKysrYDNfNYNSt2jRIhMcHGzeeOMNs2PHDjNixAjjcrnMt99+6/dZunbtaubNm2e++uork5mZaXr06GFq165tTpw44d3nxRdfNG6323zwwQdm+/bt5oEHHjA1a9Y0Ho/Hu8+jjz5qatWqZVasWGG2bt1qOnXqZFq2bGkKCgrKdP7NmzebOnXqmBYtWpgRI0ZYO/Px48dNXFycSU1NNV988YU5cOCAWblypdm7d6+1M7/wwgumWrVqZunSpebAgQPmvffeM+Hh4ebVV1+1ZuZly5aZ8ePHmw8++MBIMh9++KHP9tKar1u3bqZ58+Zmw4YNZsOGDaZ58+amZ8+epTrvzz//bLp06WLeeecds2vXLrNx40bTtm1bk5yc7HMMf857qZnP9+GHH5qWLVuamJgYM23aNKtn3rt3r6lataoZM2aM2bp1q9m3b59ZunSp+f777wM289Ui0mWgTZs25tFHH/VZ17hxY/PUU08FaKJ/yc7ONpLM2rVrjTHGFBYWmujoaPPiiy969zlz5oyJjIw0s2bNMsb8+odLcHCwWbRokXef7777zlSoUMH84x//KLNZc3NzTYMGDcyKFStMx44dvZG2ceZx48aZDh06FLndxpl79OhhBg8e7LPud7/7nRk4cKCVM//2D+PSmm/Hjh1Gktm0aZN3n40bNxpJZteuXaU278Vs3rzZSPL+BT6Q8xY38+HDh02tWrXMV199ZeLi4nwibePMDzzwgPf/44sJ9MxXgpe7S9nZs2eVnp6uO+64w2f9HXfcoQ0bNgRoqn/JycmR9K8P/zhw4ICOHTvmM6/T6VTHjh2986anpys/P99nn5iYGDVv3rxMH9Njjz2mHj16qEuXLj7rbZx5yZIlSklJ0X333afq1aurVatWeuONN6yeuUOHDlq1apW++eYbSdK2bdv0+eefq3v37tbOfL7Smm/jxo2KjIxU27ZtvfvcdNNNioyMLPPHkJOTI4fDocqVK1s7b2FhoR588EGNGTNGzZo1u2C7bTMXFhbq448/VsOGDdW1a1dVr15dbdu29XlJ3LaZi0OkS9kPP/ygX375RTVq1PBZX6NGDR07dixAU/3KGKNRo0apQ4cOat68uSR5Zypu3mPHjqlSpUqqUqVKkfuUtkWLFmnr1q2aPHnyBdtsnHn//v2aOXOmGjRooOXLl+vRRx/VH//4R/3tb3+zduZx48apX79+aty4sYKDg9WqVSuNHDlS/fr1s3bm85XWfMeOHVP16tUvOH716tXL9DGcOXNGTz31lPr37+/9oAcb533ppZcUFBSkP/7xjxfdbtvM2dnZOnHihF588UV169ZNn3zyie6++2797ne/09q1a62cuTh8ClYZcTgcPreNMRes87fhw4fryy+/1Oeff37BtquZt6we06FDhzRixAh98sknCgkJKXI/m2YuLCxUSkqKJk2aJElq1aqVvv76a82cOVMPPfSQlTO/8847euutt/T222+rWbNmyszM1MiRIxUTE6NBgwZZOfPFlMZ8F9u/LB9Dfn6++vbtq8LCQs2YMeOS+wdq3vT0dP3lL3/R1q1br/jYgZr53IWPvXv31hNPPCFJSkxM1IYNGzRr1ix17NjRupmLwzPpUhYVFaWKFSte8Det7OzsC/7G70+PP/64lixZotWrV+vGG2/0ro+OjpakYueNjo7W2bNn9dNPPxW5T2lKT09Xdna2kpOTFRQUpKCgIK1du1avvfaagoKCvOe0aeaaNWuqadOmPuuaNGnivZrUxu/zmDFj9NRTT6lv375KSEjQgw8+qCeeeML76oWNM5+vtOaLjo7W999/f8Hx/+///q9MHkN+fr7uv/9+HThwQCtWrPD5uETb5l23bp2ys7NVu3Zt78/it99+qyeffFJ16tSxcuaoqCgFBQVd8ufRppmLQ6RLWaVKlZScnKwVK1b4rF+xYoXat2/v93mMMRo+fLgWL16sTz/9VHXr1vXZXrduXUVHR/vMe/bsWa1du9Y7b3JysoKDg332OXr0qL766qsyeUydO3fW9u3blZmZ6V1SUlI0YMAAZWZmql69etbNfPPNN1/wq23ffPON4uLiJNn5fT516pT3M8/PqVixoveZiI0zn6+05mvXrp1ycnK0efNm7z5ffPGFcnJySv0xnAv0nj17tHLlSlWrVs1nu23zPvjgg/ryyy99fhZjYmI0ZswYLV++3MqZK1WqpNatWxf782jbzMXy2yVq15Fzv4I1Z84cs2PHDjNy5EjjcrnMwYMH/T7L0KFDTWRkpFmzZo05evSodzl16pR3nxdffNFERkaaxYsXm+3bt5t+/fpd9NdYbrzxRrNy5UqzdetWc9ttt/nlV7DOOf/qbhtn3rx5swkKCjJ/+tOfzJ49e8zChQtNWFiYeeutt6ydedCgQaZWrVreX8FavHixiYqKMmPHjrVm5tzcXJORkWEyMjKMJPPKK6+YjIwM79XQpTVft27dTIsWLczGjRvNxo0bTUJCwlX9qk1x8+bn55u77rrL3HjjjSYzM9Pn5zEvLy8g815q5ov57dXdNs68ePFiExwcbGbPnm327Nljpk+fbipWrGjWrVsXsJmvFpEuI3/9619NXFycqVSpkklKSvL+ypO/SbroMm/ePO8+hYWFZsKECSY6Oto4nU5zyy23mO3bt/sc5/Tp02b48OGmatWqJjQ01PTs2dNkZWX57XH8NtI2zvz3v//dNG/e3DidTtO4cWMze/Zsn+22zezxeMyIESNM7dq1TUhIiKlXr54ZP368TzACPfPq1asv+v/voEGDSnW+H3/80QwYMMC43W7jdrvNgAEDzE8//VSq8x44cKDIn8fVq1cHZN5LzXwxF4u0jTPPmTPHxMfHm5CQENOyZUvz0UcfBXTmq8VHVQIAYCnekwYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALAUkQYAwFJEGgAASxFpAAAsRaQBALDU/wO47TqRnvJOwwAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 500x500 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(5,5))\n",
    "plt.barh(list(fifa['nationality'].value_counts()[0:5].keys()),list(fifa['nationality'].value_counts()[0:5]),color=('skyblue','yellow','red','c','blue'),ec='m')\n",
    "plt.tight_layout()\n",
    "plt.show()\n",
    "         "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "d7f280cf-8dd0-4b44-925c-9593f4934383",
   "metadata": {},
   "outputs": [],
   "source": [
    "#To find the salary of palyers\n",
    "player_salary = fifa[['short_name','wage_eur']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "ba5677e2-4959-4470-8924-5927a732a93f",
   "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>short_name</th>\n",
       "      <th>wage_eur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>L. Messi</td>\n",
       "      <td>565000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>405000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Neymar Jr</td>\n",
       "      <td>290000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>J. Oblak</td>\n",
       "      <td>125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E. Hazard</td>\n",
       "      <td>470000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          short_name  wage_eur\n",
       "0           L. Messi    565000\n",
       "1  Cristiano Ronaldo    405000\n",
       "2          Neymar Jr    290000\n",
       "3           J. Oblak    125000\n",
       "4          E. Hazard    470000"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Show the salary of top 5 players\n",
    "player_salary.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "efc436aa-f648-4f2b-b86f-7b0ad069b0e3",
   "metadata": {},
   "outputs": [],
   "source": [
    "player_salary = player_salary.sort_values(by=['wage_eur'],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "4f100c01-7754-4078-8ac1-9de932e6a328",
   "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>short_name</th>\n",
       "      <th>wage_eur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>L. Messi</td>\n",
       "      <td>565000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E. Hazard</td>\n",
       "      <td>470000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>405000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>K. De Bruyne</td>\n",
       "      <td>370000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>A. Griezmann</td>\n",
       "      <td>370000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           short_name  wage_eur\n",
       "0            L. Messi    565000\n",
       "4           E. Hazard    470000\n",
       "1   Cristiano Ronaldo    405000\n",
       "5        K. De Bruyne    370000\n",
       "22       A. Griezmann    370000"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_salary.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "b2d5b352-02b9-4720-a633-6580b3c6b551",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAxYAAAHpCAYAAAAf5apCAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy81sbWrAAAACXBIWXMAAA9hAAAPYQGoP6dpAABAjklEQVR4nO3dfVwVdf7//+cR5IQIJ9QEj5FaFmnYxcKuohW6XmDlRdmubSjJZqRBXiy6fjJr1UotU7K0i801cb1Ia5U+fXIj0BQjxQuCkjR1SxNXSDMCNQXF+f7hj/l1BBF8e5H2uN9u53bjzLxm5j1zhjnned4zcxyWZVkCAAAAAAP1LnYDAAAAAFz6CBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMe+L3YBfuhMnTmjv3r3y9/eXw+G42M0BAAAALhjLsnTw4EG53W7Vq1dznwTB4gz27t2rkJCQi90MAAAA4KIpKCjQ1VdfXWMNweIM/P39JZ3cmAEBARe5NQAAAMCFU1paqpCQEPszcU0IFmdQefpTQEAAwQIAAAC/SrW5JICLtwEAAAAYI1gAAAAAMEawAAAAAGCMYAEAAADAGMECAAAAgDGCBQAAAABjBAsAAAAAxggWAAAAAIwRLAAAAAAYI1gAAAAAMEawAAAAAGCMYAEAAADAGMECAAAAgDGCBQAAAABjBAsAAAAAxggWAAAAAIwRLAAAAAAYI1gAAAAAMOZ9sRuAWljkuNgtQG3FWBe7BQAAABcFPRYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMBYnYLFhAkT5HA4PB7BwcH2eMuyNGHCBLndbvn6+qpz58768ssvPeZRVlamYcOGqUmTJvLz81OfPn20Z88ej5ri4mLFxsbK5XLJ5XIpNjZWP/74o0fN7t271bt3b/n5+alJkyYaPny4ysvLPWo2b96sqKgo+fr6qnnz5nrmmWdkWVZdVhkAAABALdS5x+Kmm25SYWGh/di8ebM9burUqUpOTtasWbO0ceNGBQcHq3v37jp48KBdM3LkSKWmpmrx4sXKysrSoUOH1KtXL1VUVNg1MTExysvLU1pamtLS0pSXl6fY2Fh7fEVFhe655x4dPnxYWVlZWrx4sZYuXapRo0bZNaWlperevbvcbrc2btyomTNnatq0aUpOTq7zRgIAAABQM+86T+Dt7dFLUcmyLM2YMUPjxo1Tv379JEnz5s1TUFCQFi1apCFDhqikpERz5szR/Pnz1a1bN0nSggULFBISohUrVig6Olpbt25VWlqasrOz1b59e0nS7NmzFRkZqW3btik0NFTp6enasmWLCgoK5Ha7JUnTp09XXFycJk2apICAAC1cuFBHjx5VSkqKnE6nwsLCtH37diUnJyspKUkOh6Pa9SsrK1NZWZn9vLS0tK6bCAAAAPjVqXOPxY4dO+R2u9WqVSv96U9/0jfffCNJ2rlzp4qKitSjRw+71ul0KioqSmvXrpUk5eTk6NixYx41brdbYWFhds26devkcrnsUCFJHTp0kMvl8qgJCwuzQ4UkRUdHq6ysTDk5OXZNVFSUnE6nR83evXu1a9eu067flClT7FOwXC6XQkJC6rqJAAAAgF+dOgWL9u3b65///Kc++ugjzZ49W0VFRerYsaMOHDigoqIiSVJQUJDHNEFBQfa4oqIi+fj4KDAwsMaapk2bVll206ZNPWpOXU5gYKB8fHxqrKl8XllTnbFjx6qkpMR+FBQU1LxRAAAAANTtVKi77rrL/rtdu3aKjIzUddddp3nz5qlDhw6SVOUUI8uyTnva0elqqqs/FzWVF27X1B6n0+nRywEAAADgzIxuN+vn56d27dppx44d9nUXp/YG7Nu3z+4pCA4OVnl5uYqLi2us+e6776osa//+/R41py6nuLhYx44dq7Fm3759kqr2qgAAAAAwYxQsysrKtHXrVjVr1kytWrVScHCwMjIy7PHl5eXKzMxUx44dJUnh4eGqX7++R01hYaHy8/PtmsjISJWUlGjDhg12zfr161VSUuJRk5+fr8LCQrsmPT1dTqdT4eHhds2aNWs8bkGbnp4ut9utli1bmqw2AAAAgFPUKViMHj1amZmZ2rlzp9avX68//OEPKi0t1aBBg+RwODRy5EhNnjxZqampys/PV1xcnBo0aKCYmBhJksvl0uDBgzVq1CitXLlSubm5GjhwoNq1a2ffJapNmzbq2bOn4uPjlZ2drezsbMXHx6tXr14KDQ2VJPXo0UNt27ZVbGyscnNztXLlSo0ePVrx8fEKCAiQdPKWtU6nU3FxccrPz1dqaqomT55c4x2hAAAAAJydOl1jsWfPHj344IP6/vvvddVVV6lDhw7Kzs5WixYtJEljxozRkSNHlJCQoOLiYrVv317p6eny9/e35/HSSy/J29tb/fv315EjR9S1a1elpKTIy8vLrlm4cKGGDx9u3z2qT58+mjVrlj3ey8tLy5cvV0JCgjp16iRfX1/FxMRo2rRpdo3L5VJGRoYSExMVERGhwMBAJSUlKSkp6ey2FAAAAIDTclj8FHWNSktL5XK5VFJSYveGXHCL6GG5ZMTw7wQAAC4fdfksbHSNBQAAAABIBAsAAAAA5wDBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGPO+2A0AcHYmOiZe7CaglsZb4y92EwAAOO/osQAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADDmbTLxlClT9OSTT2rEiBGaMWOGJMmyLE2cOFFvvvmmiouL1b59e7366qu66aab7OnKyso0evRovf322zpy5Ii6du2q1157TVdffbVdU1xcrOHDh+v999+XJPXp00czZ87UlVdeadfs3r1biYmJ+vjjj+Xr66uYmBhNmzZNPj4+ds3mzZv1+OOPa8OGDWrUqJGGDBmip59+Wg6Hw2TVAeCXKXPTxW4Baisq4mK3AADOqbPusdi4caPefPNN3XzzzR7Dp06dquTkZM2aNUsbN25UcHCwunfvroMHD9o1I0eOVGpqqhYvXqysrCwdOnRIvXr1UkVFhV0TExOjvLw8paWlKS0tTXl5eYqNjbXHV1RU6J577tHhw4eVlZWlxYsXa+nSpRo1apRdU1paqu7du8vtdmvjxo2aOXOmpk2bpuTk5LNdbQAAAADVOKsei0OHDmnAgAGaPXu2nnvuOXu4ZVmaMWOGxo0bp379+kmS5s2bp6CgIC1atEhDhgxRSUmJ5syZo/nz56tbt26SpAULFigkJEQrVqxQdHS0tm7dqrS0NGVnZ6t9+/aSpNmzZysyMlLbtm1TaGio0tPTtWXLFhUUFMjtdkuSpk+frri4OE2aNEkBAQFauHChjh49qpSUFDmdToWFhWn79u1KTk5WUlJStb0WZWVlKisrs5+XlpaezSYCAAAAflXOqsciMTFR99xzjx0MKu3cuVNFRUXq0aOHPczpdCoqKkpr166VJOXk5OjYsWMeNW63W2FhYXbNunXr5HK57FAhSR06dJDL5fKoCQsLs0OFJEVHR6usrEw5OTl2TVRUlJxOp0fN3r17tWvXrmrXbcqUKXK5XPYjJCTkbDYRAAAA8KtS52CxePFiffbZZ5oyZUqVcUVFRZKkoKAgj+FBQUH2uKKiIvn4+CgwMLDGmqZNm1aZf9OmTT1qTl1OYGCgfHx8aqypfF5Zc6qxY8eqpKTEfhQUFFRbBwAAAOD/V6dToQoKCjRixAilp6friiuuOG3dqacYWZZ1xoulT62prv5c1FiWddpppZM9LD/v4QAAAABwZnXqscjJydG+ffsUHh4ub29veXt7KzMzU6+88oq8vb1P2xuwb98+e1xwcLDKy8tVXFxcY813331XZfn79+/3qDl1OcXFxTp27FiNNfv27ZNUtVcFAAAAwNmrU7Do2rWrNm/erLy8PPsRERGhAQMGKC8vT9dee62Cg4OVkZFhT1NeXq7MzEx17NhRkhQeHq769et71BQWFio/P9+uiYyMVElJiTZs2GDXrF+/XiUlJR41+fn5KiwstGvS09PldDoVHh5u16xZs0bl5eUeNW63Wy1btqzLqgMAAACoQZ1OhfL391dYWJjHMD8/PzVu3NgePnLkSE2ePFnXX3+9rr/+ek2ePFkNGjRQTEyMJMnlcmnw4MEaNWqUGjdurEaNGmn06NFq166dfTF4mzZt1LNnT8XHx+vvf/+7JOnRRx9Vr169FBoaKknq0aOH2rZtq9jYWL344ov64YcfNHr0aMXHxysgIEDSyVvWTpw4UXFxcXryySe1Y8cOTZ48WX/729/4HQsAAADgHDL6gbzqjBkzRkeOHFFCQoL9A3np6eny9/e3a1566SV5e3urf//+9g/kpaSkyMvLy65ZuHChhg8fbt89qk+fPpo1a5Y93svLS8uXL1dCQoI6derk8QN5lVwulzIyMpSYmKiIiAgFBgYqKSlJSUlJ53q1AQAAgF81h1V5NTOqVVpaKpfLpZKSErsn5IJbRO/KJSPmwv07TXRMvGDLgpnx1vgLtzB+efvSwS9vA7gE1OWz8Fn/8jYAAAAAVCJYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMa8L3YDAADA+TVxouNiNwG1NH68dcGWNXHixAu2LJgZP378xW5CrdBjAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYKxOweL111/XzTffrICAAAUEBCgyMlIffvihPd6yLE2YMEFut1u+vr7q3LmzvvzyS495lJWVadiwYWrSpIn8/PzUp08f7dmzx6OmuLhYsbGxcrlccrlcio2N1Y8//uhRs3v3bvXu3Vt+fn5q0qSJhg8frvLyco+azZs3KyoqSr6+vmrevLmeeeYZWZZVl1UGAAAAUAt1ChZXX321nn/+eW3atEmbNm3S73//e/Xt29cOD1OnTlVycrJmzZqljRs3Kjg4WN27d9fBgwfteYwcOVKpqalavHixsrKydOjQIfXq1UsVFRV2TUxMjPLy8pSWlqa0tDTl5eUpNjbWHl9RUaF77rlHhw8fVlZWlhYvXqylS5dq1KhRdk1paam6d+8ut9utjRs3aubMmZo2bZqSk5PPemMBAAAAqJ53XYp79+7t8XzSpEl6/fXXlZ2drbZt22rGjBkaN26c+vXrJ0maN2+egoKCtGjRIg0ZMkQlJSWaM2eO5s+fr27dukmSFixYoJCQEK1YsULR0dHaunWr0tLSlJ2drfbt20uSZs+ercjISG3btk2hoaFKT0/Xli1bVFBQILfbLUmaPn264uLiNGnSJAUEBGjhwoU6evSoUlJS5HQ6FRYWpu3btys5OVlJSUlyOBzGGw8AAADASWd9jUVFRYUWL16sw4cPKzIyUjt37lRRUZF69Ohh1zidTkVFRWnt2rWSpJycHB07dsyjxu12KywszK5Zt26dXC6XHSokqUOHDnK5XB41YWFhdqiQpOjoaJWVlSknJ8euiYqKktPp9KjZu3evdu3addr1KisrU2lpqccDAAAAQM3qHCw2b96shg0byul0aujQoUpNTVXbtm1VVFQkSQoKCvKoDwoKsscVFRXJx8dHgYGBNdY0bdq0ynKbNm3qUXPqcgIDA+Xj41NjTeXzyprqTJkyxb62w+VyKSQkpOYNAgAAAKDuwSI0NFR5eXnKzs7WY489pkGDBmnLli32+FNPMbIs64ynHZ1aU139uaipvHC7pvaMHTtWJSUl9qOgoKDGtgMAAAA4i2Dh4+Oj1q1bKyIiQlOmTNEtt9yil19+WcHBwZKq9gbs27fP7ikIDg5WeXm5iouLa6z57rvvqix3//79HjWnLqe4uFjHjh2rsWbfvn2Sqvaq/JzT6bTvelX5AAAAAFAz49+xsCxLZWVlatWqlYKDg5WRkWGPKy8vV2Zmpjp27ChJCg8PV/369T1qCgsLlZ+fb9dERkaqpKREGzZssGvWr1+vkpISj5r8/HwVFhbaNenp6XI6nQoPD7dr1qxZ43EL2vT0dLndbrVs2dJ0tQEAAAD8TJ2CxZNPPqlPPvlEu3bt0ubNmzVu3DitXr1aAwYMkMPh0MiRIzV58mSlpqYqPz9fcXFxatCggWJiYiRJLpdLgwcP1qhRo7Ry5Url5uZq4MCBateunX2XqDZt2qhnz56Kj49Xdna2srOzFR8fr169eik0NFSS1KNHD7Vt21axsbHKzc3VypUrNXr0aMXHx9s9DDExMXI6nYqLi1N+fr5SU1M1efJk7ggFAAAAnAd1ut3sd999p9jYWBUWFsrlcunmm29WWlqaunfvLkkaM2aMjhw5ooSEBBUXF6t9+/ZKT0+Xv7+/PY+XXnpJ3t7e6t+/v44cOaKuXbsqJSVFXl5eds3ChQs1fPhw++5Rffr00axZs+zxXl5eWr58uRISEtSpUyf5+voqJiZG06ZNs2tcLpcyMjKUmJioiIgIBQYGKikpSUlJSWe3pQAAAACclsPip6hrVFpaKpfLpZKSkot3vcUielguGTEX7t9pomPiBVsWzIy3xl+4hWVuunDLgpmoiAu2qIkTeR+5VIwffwHfRybyPnKpGD/+Ar6PnKIun4WNr7EAAAAAAIIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMBYnYLFlClT9Nvf/lb+/v5q2rSp7r33Xm3bts2jxrIsTZgwQW63W76+vurcubO+/PJLj5qysjINGzZMTZo0kZ+fn/r06aM9e/Z41BQXFys2NlYul0sul0uxsbH68ccfPWp2796t3r17y8/PT02aNNHw4cNVXl7uUbN582ZFRUXJ19dXzZs31zPPPCPLsuqy2gAAAADOoE7BIjMzU4mJicrOzlZGRoaOHz+uHj166PDhw3bN1KlTlZycrFmzZmnjxo0KDg5W9+7ddfDgQbtm5MiRSk1N1eLFi5WVlaVDhw6pV69eqqiosGtiYmKUl5entLQ0paWlKS8vT7Gxsfb4iooK3XPPPTp8+LCysrK0ePFiLV26VKNGjbJrSktL1b17d7ndbm3cuFEzZ87UtGnTlJycfFYbCwAAAED1vOtSnJaW5vF87ty5atq0qXJycnTnnXfKsizNmDFD48aNU79+/SRJ8+bNU1BQkBYtWqQhQ4aopKREc+bM0fz589WtWzdJ0oIFCxQSEqIVK1YoOjpaW7duVVpamrKzs9W+fXtJ0uzZsxUZGalt27YpNDRU6enp2rJliwoKCuR2uyVJ06dPV1xcnCZNmqSAgAAtXLhQR48eVUpKipxOp8LCwrR9+3YlJycrKSlJDofDeAMCAAAAMLzGoqSkRJLUqFEjSdLOnTtVVFSkHj162DVOp1NRUVFau3atJCknJ0fHjh3zqHG73QoLC7Nr1q1bJ5fLZYcKSerQoYNcLpdHTVhYmB0qJCk6OlplZWXKycmxa6KiouR0Oj1q9u7dq127dlW7TmVlZSotLfV4AAAAAKjZWQcLy7KUlJSk22+/XWFhYZKkoqIiSVJQUJBHbVBQkD2uqKhIPj4+CgwMrLGmadOmVZbZtGlTj5pTlxMYGCgfH58aayqfV9acasqUKfZ1HS6XSyEhIWfYEgAAAADOOlg8/vjj+uKLL/T2229XGXfqKUaWZZ3xtKNTa6qrPxc1lRdun649Y8eOVUlJif0oKCiosd0AAAAAzjJYDBs2TO+//75WrVqlq6++2h4eHBwsqWpvwL59++yeguDgYJWXl6u4uLjGmu+++67Kcvfv3+9Rc+pyiouLdezYsRpr9u3bJ6lqr0olp9OpgIAAjwcAAACAmtUpWFiWpccff1zLli3Txx9/rFatWnmMb9WqlYKDg5WRkWEPKy8vV2Zmpjp27ChJCg8PV/369T1qCgsLlZ+fb9dERkaqpKREGzZssGvWr1+vkpISj5r8/HwVFhbaNenp6XI6nQoPD7dr1qxZ43EL2vT0dLndbrVs2bIuqw4AAACgBnUKFomJiVqwYIEWLVokf39/FRUVqaioSEeOHJF08vSikSNHavLkyUpNTVV+fr7i4uLUoEEDxcTESJJcLpcGDx6sUaNGaeXKlcrNzdXAgQPVrl07+y5Rbdq0Uc+ePRUfH6/s7GxlZ2crPj5evXr1UmhoqCSpR48eatu2rWJjY5Wbm6uVK1dq9OjRio+Pt3sZYmJi5HQ6FRcXp/z8fKWmpmry5MncEQoAAAA4x+p0u9nXX39dktS5c2eP4XPnzlVcXJwkacyYMTpy5IgSEhJUXFys9u3bKz09Xf7+/nb9Sy+9JG9vb/Xv319HjhxR165dlZKSIi8vL7tm4cKFGj58uH33qD59+mjWrFn2eC8vLy1fvlwJCQnq1KmTfH19FRMTo2nTptk1LpdLGRkZSkxMVEREhAIDA5WUlKSkpKS6rDYAAACAM6hTsKjNL1Y7HA5NmDBBEyZMOG3NFVdcoZkzZ2rmzJmnrWnUqJEWLFhQ47KuueYaffDBBzXWtGvXTmvWrKmxBgAAAIAZo9+xAAAAAACJYAEAAADgHCBYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGCNYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACM1TlYrFmzRr1795bb7ZbD4dB7773nMd6yLE2YMEFut1u+vr7q3LmzvvzyS4+asrIyDRs2TE2aNJGfn5/69OmjPXv2eNQUFxcrNjZWLpdLLpdLsbGx+vHHHz1qdu/erd69e8vPz09NmjTR8OHDVV5e7lGzefNmRUVFydfXV82bN9czzzwjy7LqutoAAAAAalDnYHH48GHdcsstmjVrVrXjp06dquTkZM2aNUsbN25UcHCwunfvroMHD9o1I0eOVGpqqhYvXqysrCwdOnRIvXr1UkVFhV0TExOjvLw8paWlKS0tTXl5eYqNjbXHV1RU6J577tHhw4eVlZWlxYsXa+nSpRo1apRdU1paqu7du8vtdmvjxo2aOXOmpk2bpuTk5LquNgAAAIAaeNd1grvuukt33XVXteMsy9KMGTM0btw49evXT5I0b948BQUFadGiRRoyZIhKSko0Z84czZ8/X926dZMkLViwQCEhIVqxYoWio6O1detWpaWlKTs7W+3bt5ckzZ49W5GRkdq2bZtCQ0OVnp6uLVu2qKCgQG63W5I0ffp0xcXFadKkSQoICNDChQt19OhRpaSkyOl0KiwsTNu3b1dycrKSkpLkcDiqrENZWZnKysrs56WlpXXdRAAAAMCvzjm9xmLnzp0qKipSjx497GFOp1NRUVFau3atJCknJ0fHjh3zqHG73QoLC7Nr1q1bJ5fLZYcKSerQoYNcLpdHTVhYmB0qJCk6OlplZWXKycmxa6KiouR0Oj1q9u7dq127dlW7DlOmTLFPv3K5XAoJCTHcKgAAAMDl75wGi6KiIklSUFCQx/CgoCB7XFFRkXx8fBQYGFhjTdOmTavMv2nTph41py4nMDBQPj4+NdZUPq+sOdXYsWNVUlJiPwoKCs684gAAAMCvXJ1PhaqNU08xsiyr2tOOaqqprv5c1FReuH269jidTo8eDgAAAABndk57LIKDgyVV7Q3Yt2+f3VMQHBys8vJyFRcX11jz3XffVZn//v37PWpOXU5xcbGOHTtWY82+ffskVe1VAQAAAHD2zmmwaNWqlYKDg5WRkWEPKy8vV2Zmpjp27ChJCg8PV/369T1qCgsLlZ+fb9dERkaqpKREGzZssGvWr1+vkpISj5r8/HwVFhbaNenp6XI6nQoPD7dr1qxZ43EL2vT0dLndbrVs2fJcrjoAAADwq1bnYHHo0CHl5eUpLy9P0skLtvPy8rR79245HA6NHDlSkydPVmpqqvLz8xUXF6cGDRooJiZGkuRyuTR48GCNGjVKK1euVG5urgYOHKh27drZd4lq06aNevbsqfj4eGVnZys7O1vx8fHq1auXQkNDJUk9evRQ27ZtFRsbq9zcXK1cuVKjR49WfHy8AgICJJ28Za3T6VRcXJzy8/OVmpqqyZMnn/aOUAAAAADOTp2vsdi0aZO6dOliP09KSpIkDRo0SCkpKRozZoyOHDmihIQEFRcXq3379kpPT5e/v789zUsvvSRvb2/1799fR44cUdeuXZWSkiIvLy+7ZuHChRo+fLh996g+ffp4/HaGl5eXli9froSEBHXq1Em+vr6KiYnRtGnT7BqXy6WMjAwlJiYqIiJCgYGBSkpKstsMAAAA4NxwWPwMdY1KS0vlcrlUUlJi94RccIvoXblkxFy4f6eJjokXbFkwM94af+EWlrnpwi0LZqIiLtiiJk7kfeRSMX78BXwfmcj7yKVi/PgL+D5yirp8Fj6n11gAAAAA+HUiWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjBEsAAAAABgjWAAAAAAwRrAAAAAAYIxgAQAAAMAYwQIAAACAMYIFAAAAAGMECwAAAADGCBYAAAAAjP0qgsVrr72mVq1a6YorrlB4eLg++eSTi90kAAAA4LJy2QeLJUuWaOTIkRo3bpxyc3N1xx136K677tLu3bsvdtMAAACAy4b3xW7A+ZacnKzBgwfrkUcekSTNmDFDH330kV5//XVNmTKlSn1ZWZnKysrs5yUlJZKk0tLSC9Pg6vx08RaNOrqA+8lRHb1gy4KZC3r8OHzowi0LZi7k8YLDxSXjQh4vjrJjXDIu5ufQymVblnXGWodVm6pLVHl5uRo0aKB3331X9913nz18xIgRysvLU2ZmZpVpJkyYoIkTJ17IZgIAAAC/aAUFBbr66qtrrLmseyy+//57VVRUKCgoyGN4UFCQioqKqp1m7NixSkpKsp+fOHFCP/zwgxo3biyHw3Fe2/trUlpaqpCQEBUUFCggIOBiNwe/EOwXOBX7BKrDfoHqsF+cH5Zl6eDBg3K73WesvayDRaVTA4FlWacNCU6nU06n02PYlVdeeb6a9qsXEBDAPz+qYL/AqdgnUB32C1SH/eLcc7lctaq7rC/ebtKkiby8vKr0Tuzbt69KLwYAAACAs3dZBwsfHx+Fh4crIyPDY3hGRoY6dux4kVoFAAAAXH4u+1OhkpKSFBsbq4iICEVGRurNN9/U7t27NXTo0IvdtF81p9Op8ePHVzntDL9u7Bc4FfsEqsN+geqwX1x8l/VdoSq99tprmjp1qgoLCxUWFqaXXnpJd95558VuFgAAAHDZ+FUECwAAAADn12V9jQUAAACAC4NgAQAAAMAYwQIAAACAMYIFLlsTJkzQrbfeerGbgUtE586dNXLkyIvdjPNu9erVcjgc+vHHH896Hr+WbVUXcXFxuvfee2usYbsBdXcujlm4cAgW8FCbN8ea7Nq1Sw6HQ97e3vrvf//rMa6wsFDe3t5yOBzatWuXWUNrYfTo0Vq5cuV5X87lJC4uTg6Ho8qjZ8+etZ5H5T6Ql5dXZRwfrM6doqIiDRs2TNdee62cTqdCQkLUu3fvM+7zHTt2VGFhYa1+RfV0b+jLli3Ts88+a9L8c2LChAn2PlqvXj253W4NGDBABQUFF7tpl6Tqjv//+te/dMUVV2jq1Km1nk/nzp3t18XpdKp58+bq3bu3li1bZtzGyuNL5cPHx0etW7fWc889J+5Fc36sXbtWXl5edXofOFVRUZFGjBih1q1b64orrlBQUJBuv/12vfHGG/rpp59qnLYuxyxcfAQLnBdut1v//Oc/PYbNmzdPzZs3v2BtaNiwoRo3bnzBlne56NmzpwoLCz0eb7/99sVu1jlhWZaOHz9+sZthbNeuXQoPD9fHH3+sqVOnavPmzUpLS1OXLl2UmJh42umOHTsmHx8fBQcHy+FwnPXyGzVqJH9//7Oe/ly66aabVFhYqD179mjJkiXavHmz+vfvf7GbdVn4xz/+oQEDBmjWrFkaM2ZMnaaNj49XYWGh/vOf/2jp0qVq27at/vSnP+nRRx89J21bsWKFCgsLtWPHDk2cOFGTJk3SW2+9ddr68vLyc7LcX6O33npLw4YNU1ZWlnbv3l3n6b/55hvddtttSk9P1+TJk5Wbm6sVK1boL3/5i/7v//5PK1asOO205+qYhQuHYIHzYtCgQZo7d67HsJSUFA0aNKhK7ZYtW3T33XerYcOGCgoKUmxsrL7//nt7/L/+9S+1a9dOvr6+aty4sbp166bDhw9LOvmN6u9+9zv5+fnpyiuvVKdOnfTtt99K4lSos+V0OhUcHOzxCAwMPC/LWrBggSIiIuTv76/g4GDFxMRo37599vjT9aCsXr26VtNXfuP+0UcfKSIiQk6nU5988okOHz6shx56SA0bNlSzZs00ffr087J+50tCQoIcDoc2bNigP/zhD7rhhht00003KSkpSdnZ2Xadw+HQG2+8ob59+8rPz0/PPfdclV6Ib7/9Vr1791ZgYKD8/Px000036d///rd27dqlLl26SJICAwPlcDgUFxcnqWrPU21fh5UrVyoiIkINGjRQx44dtW3bNo/1ev3113XdddfJx8dHoaGhmj9//hm3hbe3t4KDg+V2u3XHHXcoPj5e2dnZKi0trfV8HQ6H/vGPf+i+++5TgwYNdP311+v999+3x1dUVGjw4MFq1aqVfH19FRoaqpdffrnGdtVmHysuLtZDDz2kwMBANWjQQHfddZd27NhxxnW+EKZOnarHH39cixYt0iOPPFLn6Rs0aKDg4GCFhISoQ4cOeuGFF/T3v/9ds2fP9vgg+d///lcPPPCAAgMD1bhxY/Xt27dWPdqNGzdWcHCwWrRooQEDBqhjx4767LPP7PGVvS9TpkyR2+3WDTfcIOnka/3ee+95zOvKK69USkqKJOn3v/+9Hn/8cY/xBw4ckNPp1McffyxJatmypSZPnqyHH35Y/v7+uuaaa/Tmm296THO26/VLc/jwYb3zzjt67LHH1KtXL3s71UVCQoK8vb21adMm9e/fX23atFG7du10//33a/ny5erdu7ddW5tjlnSyF+XOO++Ur6+vQkJCNHz4cI/PBdW9b1Qevyo/G7z11lu65ppr1LBhQz322GOqqKjQ1KlTFRwcrKZNm2rSpEke65GcnKx27drJz89PISEhSkhI0KFDh+zxKSkpuvLKK/XRRx+pTZs2atiwof1FXaXK/XLatGlq1qyZGjdurMTERB07dqzO2/WXimCB86JPnz4qLi5WVlaWJCkrK0s//PCDxwFEOnl6VFRUlG699VZt2rRJaWlp+u677+xvHAsLC/Xggw/q4Ycf1tatW7V69Wr169fP/ub53nvvVVRUlL744gutW7dOjz76KN9qXELKy8v17LPP6vPPP9d7772nnTt32gd/SXr55Zc9ek5GjBihpk2b6sYbb6zV9JXGjBmjKVOmaOvWrbr55pv117/+VatWrVJqaqrS09O1evVq5eTkXKC1NvPDDz8oLS1NiYmJ8vPzqzL+yiuv9Hg+fvx49e3bV5s3b9bDDz9cpT4xMVFlZWVas2aNNm/erBdeeEENGzZUSEiIli5dKknatm2bCgsLT/thuravw7hx4zR9+nRt2rRJ3t7eHu1JTU3ViBEjNGrUKOXn52vIkCH685//rFWrVtV62xQVFWnZsmXy8vKSl5dXneY7ceJE9e/fX1988YXuvvtuDRgwQD/88IMk6cSJE7r66qv1zjvvaMuWLfrb3/6mJ598Uu+8885p21KbfSwuLk6bNm3S+++/r3Xr1smyLN19990X/UPGE088oWeffVYffPCB7r///nM230GDBikwMNA+Jeqnn35Sly5d1LBhQ61Zs0ZZWVn2h7G69DBs2rRJn332mdq3b+8xfOXKldq6dasyMjL0wQcf1GpejzzyiBYtWqSysjJ72MKFC+V2u+2gLUnTp09XRESEcnNzlZCQoMcee0xfffXVOV2vX4IlS5YoNDRUoaGhGjhwoObOnVunU84OHDig9PT00x6vJFV5zz7TMWvz5s2Kjo5Wv3799MUXX2jJkiXKysqyA2HlqVOVj48//lhXXHGFxw8jf/311/rwww+Vlpamt99+W2+99Zbuuece7dmzR5mZmXrhhRf01FNPeXxRU69ePb3yyivKz8/XvHnz9PHHH1fpyfvpp580bdo0zZ8/X2vWrNHu3bs1evRoj5pVq1bp66+/1qpVqzRv3jylpKScVWD7xbKAnxk0aJDVt2/fs55+586dliQrNzfXGjlypPXnP//ZsizL+vOf/2z95S9/sXJzcy1J1s6dOy3Lsqynn37a6tGjh8c8CgoKLEnWtm3brJycHEuStWvXrirLOnDggCXJWr16dbVtGT9+vHXLLbec9br8Gg0aNMjy8vKy/Pz8PB7PPPNMredRuQ/4+vpWmU+9evWsESNGnHbaDRs2WJKsgwcPVhm3dOlSy+l0Wp988kmtp1+1apUlyXrvvffsmoMHD1o+Pj7W4sWL7WEHDhywfH19a2zbL8X69estSdayZcvOWCvJGjlypMewym1SXFxsWZZltWvXzpowYUK1059aWykqKqpOr2PlfFasWGHXLF++3JJkHTlyxLIsy+rYsaMVHx/vMZ8//vGP1t13333a5YwfP96qV6+e5efnZ/n6+lqSLEnW8OHD7ZrazFeS9dRTT9nPDx06ZDkcDuvDDz887bITEhKs+++/337+82Nnbfax7du3W5KsTz/91K75/vvvLV9fX+udd9457XLPp0GDBlk+Pj6WJGvlypVnPZ+a9o/27dtbd911l2VZljVnzhwrNDTUOnHihD2+rKzM8vX1tT766KNqpz/1+FK/fn1LkvXoo49WWZegoCCrrKzMY7gkKzU11WOYy+Wy5s6da1mWZR09etRq1KiRtWTJEnv8rbfe6vE/0qJFC2vgwIH28xMnTlhNmza1Xn/99bNer1+qjh07WjNmzLAsy7KOHTtmNWnSxMrIyKj19NnZ2dUerxo3bmy/L4wZM8YeXptjVmxsbJXX+5NPPrHq1atnH08qff/999Z1111nJSQk2MPGjx9vNWjQwCotLbWHRUdHWy1btrQqKirsYaGhodaUKVNOu27vvPOO1bhxY/v53LlzLUnWf/7zH3vYq6++agUFBdnPBw0aZLVo0cI6fvy4PeyPf/yj9cADD5x2OZcaeixw3gwePFjvvvuuioqK9O6771b7zUNOTo5WrVqlhg0b2o/Kb6O//vpr3XLLLeratavatWunP/7xj5o9e7aKi4slnTzPOy4uTtHR0erdu7f97TbMdOnSRXl5eR6Pms7bP50lS5ZUmU9ERIRHTW5urvr27asWLVrI399fnTt3lqQq5/Hm5ubqoYce0quvvqrbb7+9ztP/fLlff/21ysvLFRkZaQ9r1KiRQkND67yOF4P1/31bWNueuVO3+amGDx+u5557Tp06ddL48eP1xRdf1LlNtX0dbr75ZvvvZs2aSZJ9ytTWrVvVqVMnj/pOnTpp69atNS47NDRUeXl52rhxoyZNmqRbb73V4xSG2s73523z8/OTv7+/x+lcb7zxhiIiInTVVVepYcOGmj179mnPN6/NPrZ161Z5e3t7fMveuHFjhYaGnnGdz6ebb75ZLVu21N/+9jcdPHjwnM/fsix7383JydF//vMf+fv728f/Ro0a6ejRo/r6669rnE/l8eXzzz/XkiVL9L//+7964oknPGratWsnHx+fOrXP6XRq4MCB9vUalcs4tQfu5/uLw+FQcHCwvb+YrNcvybZt27Rhwwb96U9/knTytMMHHnigxmtZTufU49WGDRuUl5enm266yaN3SDrzMSsnJ0cpKSkenxuio6N14sQJ7dy50647duyY7r//fl1zzTVVeltbtmzpcZ1YUFCQ2rZtq3r16nkM+/kxYNWqVerevbuaN28uf39/PfTQQzpw4IB9CpZ08hTA6667zn7erFkzj3lIJ68Lq+xRPV3Npcz7YjcAl6+wsDDdeOONevDBB9WmTRuFhYVVuVPQiRMn1Lt3b73wwgtVpm/WrJm8vLyUkZGhtWvXKj09XTNnztS4ceO0fv16tWrVSnPnztXw4cOVlpamJUuW6KmnnlJGRoY6dOhwgdby8uPn56fWrVsbzyckJKTKfHx9fe2/Dx8+rB49eqhHjx5asGCBrrrqKu3evVvR0dEepwsUFRWpT58+Gjx4sAYPHlzn6SvXqZJ1id855vrrr5fD4dDWrVtrdQe3051+UOmRRx5RdHS0li9frvT0dE2ZMkXTp0/XsGHDatWeurwO9evXt/+u/KBx4sSJKsMq/fxD6OlU3hVIOvmGvWPHDj322GMe11HUZr4/b1vlNJVte+edd/SXv/xF06dPV2RkpPz9/fXiiy9q/fr11bapNvvY6Wpqs87nU/PmzbV06VJ16dJFPXv2VFpa2jm7UL+iokI7duzQb3/7W0knX/vw8HAtXLiwSu1VV11V47x+fnxp06aNvvnmGz399NOaMGGCrrjiCknV7/sOh6PKtj/11LNHHnlEt956q/bs2aO33npLXbt2VYsWLTxqatpfTNbrl2TOnDk6fvy4x01XLMtS/fr1VVxcXKtr71q3bi2Hw2GfJlbp2muvleT5nlDpTMesEydOaMiQIRo+fHiVcddcc43992OPPabdu3dr48aN8vb2/Lhb3etX02v67bff6u6779bQoUP17LPPqlGjRsrKytLgwYM99p/q5nHq/lbTci4H9FjgvHr44Ye1evXqansrJOk3v/mNvvzyS7Vs2VKtW7f2eFQeXBwOhzp16qSJEycqNzdXPj4+Sk1Ntedx2223aezYsVq7dq3CwsK0aNGiC7JuMPPVV1/p+++/1/PPP6877rhDN954Y5VvbY4ePaq+ffvqxhtvVHJycp2nr07r1q1Vv359j3Nni4uLtX379nOzYudZo0aNFB0drVdffdXjm7JKZ3Ov95CQEA0dOlTLli3TqFGjNHv2bEmyv+2tqKg47bRn+zqcqk2bNvY1WZXWrl2rNm3a1Gk+Tz/9tN5++237Qt5zMd9PPvlEHTt2VEJCgm677Ta1bt26xm+ea7OPtW3bVsePH/cIJwcOHND27dvrvM7n2jXXXKPMzEzt27dPPXr08LgQ3sS8efNUXFxsX7fxm9/8Rjt27FDTpk2rHP/remtRLy8vHT9+/IzXMFx11VUePds7duyocrvTdu3aKSIiQrNnz9aiRYtO+/51OudyvS6W48eP65///KemT5/u0ev8+eefq0WLFtWGpuo0btxY3bt316xZs6o9Xp2Nys8Np27b1q1b28es5ORkLVmyRO+///45uTvkpk2bdPz4cU2fPl0dOnTQDTfcoL179xrP93JEsEAVJSUlVU5hqezyf+ihhzR27Nhazys+Pl779+8/7V1FEhMT9cMPP+jBBx/Uhg0b9M033yg9PV0PP/ywKioqtH79ek2ePFmbNm3S7t27tWzZMu3fv19t2rTRzp07NXbsWK1bt07ffvut0tPTfxFvype6srIyFRUVeTx+fpeuuu4Dp3PNNdfIx8dHM2fO1DfffKP333+/ym8jDBkyRAUFBXrllVe0f/9+uz3l5eW1mr46DRs21ODBg/XXv/5VK1euVH5+vuLi4jy6wH/pXnvtNVVUVOh3v/udli5dqh07dmjr1q165ZVXPE6/qY2RI0fqo48+0s6dO/XZZ5/p448/tv+HWrRoIYfDoQ8++ED79+/3uANKpbN9HU7117/+VSkpKXrjjTe0Y8cOJScna9myZVUufDyTa6+9Vn379tXf/va3czbf1q1ba9OmTfroo4+0fft2Pf3009q4ceNp62uzj11//fXq27ev4uPjlZWVpc8//1wDBw5U8+bN1bdv3zqt8/lw9dVXa/Xq1Tpw4IB69OihkpISSScvhq88XbUmP/30k4qKirRnzx6tX79e//M//6OhQ4fqsccesy+CHjBggJo0aaK+ffvqk08+0c6dO5WZmakRI0Zoz549Nc7/wIED9vw//PBDvfzyy+rSpYsCAgJqnO73v/+9Zs2apc8++0ybNm3S0KFDq3yDLJ3stXj++edVUVGh++6774zr+3Mm6/VL8cEHH6i4uFiDBw9WWFiYx+MPf/iD5syZI+nkKU033nhjld+t+rnXXntNx48fV0REhJYsWaKtW7dq27ZtWrBggb766iuP04Jq43/+53+0bt06JSYmKi8vTzt27ND7779v97KuWLFCY8aM0bRp09SkSRP7faNyHz4b1113nY4fP24f5+bPn6833njjrOd3Obt03klxwaxevVq33Xabx6PyTXr37t11uo7B29tbTZo0qdINWcntduvTTz9VRUWFoqOjFRYWphEjRsjlcqlevXoKCAjQmjVrdPfdd+uGG27QU089penTp+uuu+5SgwYN9NVXX+n+++/XDTfcoEcffVSPP/64hgwZck62w69VWlqamjVr5vH4+XUNdd0HTueqq65SSkqK3n33XbVt21bPP/+8pk2b5lGTmZmpwsJCtW3b1qM9a9eurdX0p/Piiy/qzjvvVJ8+fdStWzfdfvvtCg8PN16nC6VVq1b67LPP1KVLF40aNUphYWHq3r27Vq5cqddff71O86qoqFBiYqLatGmjnj17KjQ0VK+99pqkk6fFTJw4UU888YSCgoKq3IZTqt3rWBv33nuvXn75Zb344ou66aab9Pe//11z5861r9eoi1GjRmn58uVav379OZnv0KFD1a9fPz3wwANq3769Dhw4oISEhBqnqc0+NnfuXIWHh6tXr16KjIyUZVn697//Xe0H3YuhefPmyszM1I8//qju3bvrxx9/VElJSZXbBFdn9uzZatasma677jrdd9992rJli5YsWWLvW9LJ89HXrFmja665Rv369VObNm308MMP68iRI2cMCN26dVOzZs3UsmVLPfroo7r77ru1ZMmSM7Zr+vTpCgkJ0Z133qmYmBiNHj1aDRo0qFL34IMPytvbWzExMfapVbVlsl6/FHPmzFG3bt2q7WG5//77lZeXp88++0w//fSTtm3bVuOdzK677jrl5uaqW7duGjt2rG655RZFRERo5syZGj16dJ2/iLj55puVmZmpHTt26I477tBtt92mp59+2r5uKysrSxUVFRo6dKjH+8aIESPqthF+5tZbb1VycrJeeOEFhYWFaeHChZoyZcpZz+9y5rAu9ROOAQAAzqGCggK1bNlSGzdu1G9+85uL3RzgkkGwAAAA0MkLuQsLC/XEE0/o22+/1aeffnqxmwRcUjgVCgAAQNKnn36qFi1aKCcnh3PogbNAjwUAAAAAY/RYAAAAADBGsAAAAABgjGABAAAAwBjBAgAAAIAxggUAAAAAYwQLAAAAAMYIFgAAAACMESwAAAAAGPt/J+VlPAIv/yUAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 800x500 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(8,5))\n",
    "plt.bar(list(player_salary['short_name'])[0:5],list(player_salary['wage_eur'])[0:5],color=('orange','purple','pink','olive','gray'))\n",
    "plt.tight_layout()\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "d035ecec-e9ac-4a1c-8fb9-8c95acee2174",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        False\n",
       "1        False\n",
       "2        False\n",
       "3        False\n",
       "4        False\n",
       "         ...  \n",
       "18273    False\n",
       "18274    False\n",
       "18275    False\n",
       "18276    False\n",
       "18277    False\n",
       "Name: nationality, Length: 18278, dtype: bool"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fifa['nationality']=='Germany'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "1d90959f-8ac3-4792-9e12-432140d48211",
   "metadata": {},
   "outputs": [],
   "source": [
    "#exract records belongs to germany\n",
    "Germany=fifa[fifa['nationality']=='Germany']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "68fc2361-d414-49d5-bc53-51f0da30ad00",
   "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>192448</td>\n",
       "      <td>https://sofifa.com/player/192448/marc-andre-te...</td>\n",
       "      <td>M. ter Stegen</td>\n",
       "      <td>Marc-André ter Stegen</td>\n",
       "      <td>27</td>\n",
       "      <td>4/30/1992</td>\n",
       "      <td>187</td>\n",
       "      <td>85</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>167495</td>\n",
       "      <td>https://sofifa.com/player/167495/manuel-neuer/...</td>\n",
       "      <td>M. Neuer</td>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>33</td>\n",
       "      <td>3/27/1986</td>\n",
       "      <td>193</td>\n",
       "      <td>92</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Bayern München</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>182521</td>\n",
       "      <td>https://sofifa.com/player/182521/toni-kroos/20...</td>\n",
       "      <td>T. Kroos</td>\n",
       "      <td>Toni Kroos</td>\n",
       "      <td>29</td>\n",
       "      <td>1/4/1990</td>\n",
       "      <td>183</td>\n",
       "      <td>76</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>75+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>75+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>72+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>188350</td>\n",
       "      <td>https://sofifa.com/player/188350/marco-reus/20...</td>\n",
       "      <td>M. Reus</td>\n",
       "      <td>Marco Reus</td>\n",
       "      <td>30</td>\n",
       "      <td>5/31/1989</td>\n",
       "      <td>180</td>\n",
       "      <td>71</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Borussia Dortmund</td>\n",
       "      <td>...</td>\n",
       "      <td>69+3</td>\n",
       "      <td>65+3</td>\n",
       "      <td>65+3</td>\n",
       "      <td>65+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>64+3</td>\n",
       "      <td>55+3</td>\n",
       "      <td>55+3</td>\n",
       "      <td>55+3</td>\n",
       "      <td>64+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>178603</td>\n",
       "      <td>https://sofifa.com/player/178603/mats-hummels/...</td>\n",
       "      <td>M. Hummels</td>\n",
       "      <td>Mats  Hummels</td>\n",
       "      <td>30</td>\n",
       "      <td>12/16/1988</td>\n",
       "      <td>191</td>\n",
       "      <td>94</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Borussia Dortmund</td>\n",
       "      <td>...</td>\n",
       "      <td>77+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>77+3</td>\n",
       "      <td>78+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>78+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>222492</td>\n",
       "      <td>https://sofifa.com/player/222492/leroy-sane/20...</td>\n",
       "      <td>L. Sané</td>\n",
       "      <td>Leroy Sané</td>\n",
       "      <td>23</td>\n",
       "      <td>1/11/1996</td>\n",
       "      <td>183</td>\n",
       "      <td>75</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>...</td>\n",
       "      <td>65+2</td>\n",
       "      <td>59+2</td>\n",
       "      <td>59+2</td>\n",
       "      <td>59+2</td>\n",
       "      <td>65+2</td>\n",
       "      <td>61+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>61+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>212622</td>\n",
       "      <td>https://sofifa.com/player/212622/joshua-kimmic...</td>\n",
       "      <td>J. Kimmich</td>\n",
       "      <td>Joshua Kimmich</td>\n",
       "      <td>24</td>\n",
       "      <td>2/8/1995</td>\n",
       "      <td>176</td>\n",
       "      <td>73</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Bayern München</td>\n",
       "      <td>...</td>\n",
       "      <td>83+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>81+3</td>\n",
       "      <td>78+3</td>\n",
       "      <td>78+3</td>\n",
       "      <td>78+3</td>\n",
       "      <td>81+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>189596</td>\n",
       "      <td>https://sofifa.com/player/189596/thomas-muller...</td>\n",
       "      <td>T. Müller</td>\n",
       "      <td>Thomas Müller</td>\n",
       "      <td>29</td>\n",
       "      <td>9/13/1989</td>\n",
       "      <td>186</td>\n",
       "      <td>75</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Bayern München</td>\n",
       "      <td>...</td>\n",
       "      <td>69+3</td>\n",
       "      <td>68+3</td>\n",
       "      <td>68+3</td>\n",
       "      <td>68+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>67+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>67+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>212190</td>\n",
       "      <td>https://sofifa.com/player/212190/niklas-sule/2...</td>\n",
       "      <td>N. Süle</td>\n",
       "      <td>Niklas Süle</td>\n",
       "      <td>23</td>\n",
       "      <td>9/3/1995</td>\n",
       "      <td>195</td>\n",
       "      <td>97</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Bayern München</td>\n",
       "      <td>...</td>\n",
       "      <td>71+2</td>\n",
       "      <td>77+2</td>\n",
       "      <td>77+2</td>\n",
       "      <td>77+2</td>\n",
       "      <td>71+2</td>\n",
       "      <td>75+2</td>\n",
       "      <td>83+2</td>\n",
       "      <td>83+2</td>\n",
       "      <td>83+2</td>\n",
       "      <td>75+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>235790</td>\n",
       "      <td>https://sofifa.com/player/235790/kai-havertz/2...</td>\n",
       "      <td>K. Havertz</td>\n",
       "      <td>Kai Havertz</td>\n",
       "      <td>20</td>\n",
       "      <td>6/11/1999</td>\n",
       "      <td>188</td>\n",
       "      <td>83</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Bayer 04 Leverkusen</td>\n",
       "      <td>...</td>\n",
       "      <td>65+2</td>\n",
       "      <td>63+2</td>\n",
       "      <td>63+2</td>\n",
       "      <td>63+2</td>\n",
       "      <td>65+2</td>\n",
       "      <td>62+2</td>\n",
       "      <td>54+2</td>\n",
       "      <td>54+2</td>\n",
       "      <td>54+2</td>\n",
       "      <td>62+2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     sofifa_id                                         player_url  \\\n",
       "6       192448  https://sofifa.com/player/192448/marc-andre-te...   \n",
       "31      167495  https://sofifa.com/player/167495/manuel-neuer/...   \n",
       "36      182521  https://sofifa.com/player/182521/toni-kroos/20...   \n",
       "37      188350  https://sofifa.com/player/188350/marco-reus/20...   \n",
       "49      178603  https://sofifa.com/player/178603/mats-hummels/...   \n",
       "55      222492  https://sofifa.com/player/222492/leroy-sane/20...   \n",
       "61      212622  https://sofifa.com/player/212622/joshua-kimmic...   \n",
       "70      189596  https://sofifa.com/player/189596/thomas-muller...   \n",
       "77      212190  https://sofifa.com/player/212190/niklas-sule/2...   \n",
       "109     235790  https://sofifa.com/player/235790/kai-havertz/2...   \n",
       "\n",
       "        short_name              long_name  age         dob  height_cm  \\\n",
       "6    M. ter Stegen  Marc-André ter Stegen   27   4/30/1992        187   \n",
       "31        M. Neuer           Manuel Neuer   33   3/27/1986        193   \n",
       "36        T. Kroos             Toni Kroos   29    1/4/1990        183   \n",
       "37         M. Reus             Marco Reus   30   5/31/1989        180   \n",
       "49      M. Hummels          Mats  Hummels   30  12/16/1988        191   \n",
       "55         L. Sané             Leroy Sané   23   1/11/1996        183   \n",
       "61      J. Kimmich         Joshua Kimmich   24    2/8/1995        176   \n",
       "70       T. Müller          Thomas Müller   29   9/13/1989        186   \n",
       "77         N. Süle            Niklas Süle   23    9/3/1995        195   \n",
       "109     K. Havertz            Kai Havertz   20   6/11/1999        188   \n",
       "\n",
       "     weight_kg nationality                 club  ...   lwb   ldm   cdm   rdm  \\\n",
       "6           85     Germany         FC Barcelona  ...   NaN   NaN   NaN   NaN   \n",
       "31          92     Germany    FC Bayern München  ...   NaN   NaN   NaN   NaN   \n",
       "36          76     Germany          Real Madrid  ...  75+3  79+3  79+3  79+3   \n",
       "37          71     Germany    Borussia Dortmund  ...  69+3  65+3  65+3  65+3   \n",
       "49          94     Germany    Borussia Dortmund  ...  77+3  83+3  83+3  83+3   \n",
       "55          75     Germany      Manchester City  ...  65+2  59+2  59+2  59+2   \n",
       "61          73     Germany    FC Bayern München  ...  83+3  82+3  82+3  82+3   \n",
       "70          75     Germany    FC Bayern München  ...  69+3  68+3  68+3  68+3   \n",
       "77          97     Germany    FC Bayern München  ...  71+2  77+2  77+2  77+2   \n",
       "109         83     Germany  Bayer 04 Leverkusen  ...  65+2  63+2  63+2  63+2   \n",
       "\n",
       "      rwb    lb   lcb    cb   rcb    rb  \n",
       "6     NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "31    NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "36   75+3  72+3  69+3  69+3  69+3  72+3  \n",
       "37   69+3  64+3  55+3  55+3  55+3  64+3  \n",
       "49   77+3  78+3  84+3  84+3  84+3  78+3  \n",
       "55   65+2  61+2  52+2  52+2  52+2  61+2  \n",
       "61   83+3  81+3  78+3  78+3  78+3  81+3  \n",
       "70   69+3  67+3  62+3  62+3  62+3  67+3  \n",
       "77   71+2  75+2  83+2  83+2  83+2  75+2  \n",
       "109  65+2  62+2  54+2  54+2  54+2  62+2  \n",
       "\n",
       "[10 rows x 104 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Germany.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "89775395-a3e1-4c0d-93a1-d1b9a131b290",
   "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8016</th>\n",
       "      <td>236831</td>\n",
       "      <td>https://sofifa.com/player/236831/aaron-seydel/...</td>\n",
       "      <td>A. Seydel</td>\n",
       "      <td>Aaron Seydel</td>\n",
       "      <td>23</td>\n",
       "      <td>2/7/1996</td>\n",
       "      <td>199</td>\n",
       "      <td>90</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1. FSV Mainz 05</td>\n",
       "      <td>...</td>\n",
       "      <td>46+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>46+2</td>\n",
       "      <td>44+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>43+2</td>\n",
       "      <td>44+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1217</th>\n",
       "      <td>200212</td>\n",
       "      <td>https://sofifa.com/player/200212/michael-esser...</td>\n",
       "      <td>M. Esser</td>\n",
       "      <td>Michael Esser</td>\n",
       "      <td>31</td>\n",
       "      <td>11/22/1987</td>\n",
       "      <td>198</td>\n",
       "      <td>97</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hannover 96</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1389</th>\n",
       "      <td>199833</td>\n",
       "      <td>https://sofifa.com/player/199833/lars-unnersta...</td>\n",
       "      <td>L. Unnerstall</td>\n",
       "      <td>Lars Unnerstall</td>\n",
       "      <td>28</td>\n",
       "      <td>7/20/1990</td>\n",
       "      <td>198</td>\n",
       "      <td>103</td>\n",
       "      <td>Germany</td>\n",
       "      <td>PSV</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11859</th>\n",
       "      <td>167437</td>\n",
       "      <td>https://sofifa.com/player/167437/dominik-stroh...</td>\n",
       "      <td>D. Stroh-Engel</td>\n",
       "      <td>Dominik Stroh-Engel</td>\n",
       "      <td>33</td>\n",
       "      <td>11/27/1985</td>\n",
       "      <td>197</td>\n",
       "      <td>94</td>\n",
       "      <td>Germany</td>\n",
       "      <td>SpVgg Unterhaching</td>\n",
       "      <td>...</td>\n",
       "      <td>39+2</td>\n",
       "      <td>45+2</td>\n",
       "      <td>45+2</td>\n",
       "      <td>45+2</td>\n",
       "      <td>39+2</td>\n",
       "      <td>39+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>39+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13576</th>\n",
       "      <td>239746</td>\n",
       "      <td>https://sofifa.com/player/239746/lukas-watkowi...</td>\n",
       "      <td>L. Watkowiak</td>\n",
       "      <td>Lukas Watkowiak</td>\n",
       "      <td>23</td>\n",
       "      <td>3/6/1996</td>\n",
       "      <td>197</td>\n",
       "      <td>103</td>\n",
       "      <td>Germany</td>\n",
       "      <td>SV Wehen Wiesbaden</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       sofifa_id                                         player_url  \\\n",
       "8016      236831  https://sofifa.com/player/236831/aaron-seydel/...   \n",
       "1217      200212  https://sofifa.com/player/200212/michael-esser...   \n",
       "1389      199833  https://sofifa.com/player/199833/lars-unnersta...   \n",
       "11859     167437  https://sofifa.com/player/167437/dominik-stroh...   \n",
       "13576     239746  https://sofifa.com/player/239746/lukas-watkowi...   \n",
       "\n",
       "           short_name            long_name  age         dob  height_cm  \\\n",
       "8016        A. Seydel         Aaron Seydel   23    2/7/1996        199   \n",
       "1217         M. Esser        Michael Esser   31  11/22/1987        198   \n",
       "1389    L. Unnerstall      Lars Unnerstall   28   7/20/1990        198   \n",
       "11859  D. Stroh-Engel  Dominik Stroh-Engel   33  11/27/1985        197   \n",
       "13576    L. Watkowiak      Lukas Watkowiak   23    3/6/1996        197   \n",
       "\n",
       "       weight_kg nationality                club  ...   lwb   ldm   cdm   rdm  \\\n",
       "8016          90     Germany     1. FSV Mainz 05  ...  46+2  43+2  43+2  43+2   \n",
       "1217          97     Germany         Hannover 96  ...   NaN   NaN   NaN   NaN   \n",
       "1389         103     Germany                 PSV  ...   NaN   NaN   NaN   NaN   \n",
       "11859         94     Germany  SpVgg Unterhaching  ...  39+2  45+2  45+2  45+2   \n",
       "13576        103     Germany  SV Wehen Wiesbaden  ...   NaN   NaN   NaN   NaN   \n",
       "\n",
       "        rwb    lb   lcb    cb   rcb    rb  \n",
       "8016   46+2  44+2  43+2  43+2  43+2  44+2  \n",
       "1217    NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "1389    NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "11859  39+2  39+2  47+2  47+2  47+2  39+2  \n",
       "13576   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "\n",
       "[5 rows x 104 columns]"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To sort valueds according to height\n",
    "Germany.sort_values(by=['height_cm'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "1c29a31f-5166-4924-9b58-a074e6953b6d",
   "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13576</th>\n",
       "      <td>239746</td>\n",
       "      <td>https://sofifa.com/player/239746/lukas-watkowi...</td>\n",
       "      <td>L. Watkowiak</td>\n",
       "      <td>Lukas Watkowiak</td>\n",
       "      <td>23</td>\n",
       "      <td>3/6/1996</td>\n",
       "      <td>197</td>\n",
       "      <td>103</td>\n",
       "      <td>Germany</td>\n",
       "      <td>SV Wehen Wiesbaden</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1389</th>\n",
       "      <td>199833</td>\n",
       "      <td>https://sofifa.com/player/199833/lars-unnersta...</td>\n",
       "      <td>L. Unnerstall</td>\n",
       "      <td>Lars Unnerstall</td>\n",
       "      <td>28</td>\n",
       "      <td>7/20/1990</td>\n",
       "      <td>198</td>\n",
       "      <td>103</td>\n",
       "      <td>Germany</td>\n",
       "      <td>PSV</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>179783</td>\n",
       "      <td>https://sofifa.com/player/179783/ralf-fahrmann...</td>\n",
       "      <td>R. Fährmann</td>\n",
       "      <td>Ralf Fährmann</td>\n",
       "      <td>30</td>\n",
       "      <td>9/27/1988</td>\n",
       "      <td>197</td>\n",
       "      <td>98</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Norwich City</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1217</th>\n",
       "      <td>200212</td>\n",
       "      <td>https://sofifa.com/player/200212/michael-esser...</td>\n",
       "      <td>M. Esser</td>\n",
       "      <td>Michael Esser</td>\n",
       "      <td>31</td>\n",
       "      <td>11/22/1987</td>\n",
       "      <td>198</td>\n",
       "      <td>97</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hannover 96</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>212190</td>\n",
       "      <td>https://sofifa.com/player/212190/niklas-sule/2...</td>\n",
       "      <td>N. Süle</td>\n",
       "      <td>Niklas Süle</td>\n",
       "      <td>23</td>\n",
       "      <td>9/3/1995</td>\n",
       "      <td>195</td>\n",
       "      <td>97</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Bayern München</td>\n",
       "      <td>...</td>\n",
       "      <td>71+2</td>\n",
       "      <td>77+2</td>\n",
       "      <td>77+2</td>\n",
       "      <td>77+2</td>\n",
       "      <td>71+2</td>\n",
       "      <td>75+2</td>\n",
       "      <td>83+2</td>\n",
       "      <td>83+2</td>\n",
       "      <td>83+2</td>\n",
       "      <td>75+2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       sofifa_id                                         player_url  \\\n",
       "13576     239746  https://sofifa.com/player/239746/lukas-watkowi...   \n",
       "1389      199833  https://sofifa.com/player/199833/lars-unnersta...   \n",
       "518       179783  https://sofifa.com/player/179783/ralf-fahrmann...   \n",
       "1217      200212  https://sofifa.com/player/200212/michael-esser...   \n",
       "77        212190  https://sofifa.com/player/212190/niklas-sule/2...   \n",
       "\n",
       "          short_name        long_name  age         dob  height_cm  weight_kg  \\\n",
       "13576   L. Watkowiak  Lukas Watkowiak   23    3/6/1996        197        103   \n",
       "1389   L. Unnerstall  Lars Unnerstall   28   7/20/1990        198        103   \n",
       "518      R. Fährmann    Ralf Fährmann   30   9/27/1988        197         98   \n",
       "1217        M. Esser    Michael Esser   31  11/22/1987        198         97   \n",
       "77           N. Süle      Niklas Süle   23    9/3/1995        195         97   \n",
       "\n",
       "      nationality                club  ...   lwb   ldm   cdm   rdm   rwb  \\\n",
       "13576     Germany  SV Wehen Wiesbaden  ...   NaN   NaN   NaN   NaN   NaN   \n",
       "1389      Germany                 PSV  ...   NaN   NaN   NaN   NaN   NaN   \n",
       "518       Germany        Norwich City  ...   NaN   NaN   NaN   NaN   NaN   \n",
       "1217      Germany         Hannover 96  ...   NaN   NaN   NaN   NaN   NaN   \n",
       "77        Germany   FC Bayern München  ...  71+2  77+2  77+2  77+2  71+2   \n",
       "\n",
       "         lb   lcb    cb   rcb    rb  \n",
       "13576   NaN   NaN   NaN   NaN   NaN  \n",
       "1389    NaN   NaN   NaN   NaN   NaN  \n",
       "518     NaN   NaN   NaN   NaN   NaN  \n",
       "1217    NaN   NaN   NaN   NaN   NaN  \n",
       "77     75+2  83+2  83+2  83+2  75+2  \n",
       "\n",
       "[5 rows x 104 columns]"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To sort valueds according to weight\n",
    "Germany.sort_values(by=['weight_kg'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "a6be3914-958f-4d0a-8e7f-c4a2fee5d1c7",
   "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>182521</td>\n",
       "      <td>https://sofifa.com/player/182521/toni-kroos/20...</td>\n",
       "      <td>T. Kroos</td>\n",
       "      <td>Toni Kroos</td>\n",
       "      <td>29</td>\n",
       "      <td>1/4/1990</td>\n",
       "      <td>183</td>\n",
       "      <td>76</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>75+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>75+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>72+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>192448</td>\n",
       "      <td>https://sofifa.com/player/192448/marc-andre-te...</td>\n",
       "      <td>M. ter Stegen</td>\n",
       "      <td>Marc-André ter Stegen</td>\n",
       "      <td>27</td>\n",
       "      <td>4/30/1992</td>\n",
       "      <td>187</td>\n",
       "      <td>85</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>222492</td>\n",
       "      <td>https://sofifa.com/player/222492/leroy-sane/20...</td>\n",
       "      <td>L. Sané</td>\n",
       "      <td>Leroy Sané</td>\n",
       "      <td>23</td>\n",
       "      <td>1/11/1996</td>\n",
       "      <td>183</td>\n",
       "      <td>75</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>...</td>\n",
       "      <td>65+2</td>\n",
       "      <td>59+2</td>\n",
       "      <td>59+2</td>\n",
       "      <td>59+2</td>\n",
       "      <td>65+2</td>\n",
       "      <td>61+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>52+2</td>\n",
       "      <td>61+2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>186942</td>\n",
       "      <td>https://sofifa.com/player/186942/ilkay-gundoga...</td>\n",
       "      <td>I. Gündoğan</td>\n",
       "      <td>İlkay Gündoğan</td>\n",
       "      <td>28</td>\n",
       "      <td>10/24/1990</td>\n",
       "      <td>180</td>\n",
       "      <td>80</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>...</td>\n",
       "      <td>76+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>76+3</td>\n",
       "      <td>74+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>74+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>189596</td>\n",
       "      <td>https://sofifa.com/player/189596/thomas-muller...</td>\n",
       "      <td>T. Müller</td>\n",
       "      <td>Thomas Müller</td>\n",
       "      <td>29</td>\n",
       "      <td>9/13/1989</td>\n",
       "      <td>186</td>\n",
       "      <td>75</td>\n",
       "      <td>Germany</td>\n",
       "      <td>FC Bayern München</td>\n",
       "      <td>...</td>\n",
       "      <td>69+3</td>\n",
       "      <td>68+3</td>\n",
       "      <td>68+3</td>\n",
       "      <td>68+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>67+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>67+3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     sofifa_id                                         player_url  \\\n",
       "36      182521  https://sofifa.com/player/182521/toni-kroos/20...   \n",
       "6       192448  https://sofifa.com/player/192448/marc-andre-te...   \n",
       "55      222492  https://sofifa.com/player/222492/leroy-sane/20...   \n",
       "146     186942  https://sofifa.com/player/186942/ilkay-gundoga...   \n",
       "70      189596  https://sofifa.com/player/189596/thomas-muller...   \n",
       "\n",
       "        short_name              long_name  age         dob  height_cm  \\\n",
       "36        T. Kroos             Toni Kroos   29    1/4/1990        183   \n",
       "6    M. ter Stegen  Marc-André ter Stegen   27   4/30/1992        187   \n",
       "55         L. Sané             Leroy Sané   23   1/11/1996        183   \n",
       "146    I. Gündoğan         İlkay Gündoğan   28  10/24/1990        180   \n",
       "70       T. Müller          Thomas Müller   29   9/13/1989        186   \n",
       "\n",
       "     weight_kg nationality               club  ...   lwb   ldm   cdm   rdm  \\\n",
       "36          76     Germany        Real Madrid  ...  75+3  79+3  79+3  79+3   \n",
       "6           85     Germany       FC Barcelona  ...   NaN   NaN   NaN   NaN   \n",
       "55          75     Germany    Manchester City  ...  65+2  59+2  59+2  59+2   \n",
       "146         80     Germany    Manchester City  ...  76+3  79+3  79+3  79+3   \n",
       "70          75     Germany  FC Bayern München  ...  69+3  68+3  68+3  68+3   \n",
       "\n",
       "      rwb    lb   lcb    cb   rcb    rb  \n",
       "36   75+3  72+3  69+3  69+3  69+3  72+3  \n",
       "6     NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "55   65+2  61+2  52+2  52+2  52+2  61+2  \n",
       "146  76+3  74+3  72+3  72+3  72+3  74+3  \n",
       "70   69+3  67+3  62+3  62+3  62+3  67+3  \n",
       "\n",
       "[5 rows x 104 columns]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To sort valueds according to wage\n",
    "Germany.sort_values(by=['wage_eur'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "4c6d627e-54e7-4de8-987b-97137d6aeca2",
   "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>short_name</th>\n",
       "      <th>wage_eur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>T. Kroos</td>\n",
       "      <td>330000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M. ter Stegen</td>\n",
       "      <td>250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>L. Sané</td>\n",
       "      <td>195000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>I. Gündoğan</td>\n",
       "      <td>180000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>T. Müller</td>\n",
       "      <td>170000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        short_name  wage_eur\n",
       "36        T. Kroos    330000\n",
       "6    M. ter Stegen    250000\n",
       "55         L. Sané    195000\n",
       "146    I. Gündoğan    180000\n",
       "70       T. Müller    170000"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To sort valueds according by name with wage\n",
    "Germany[['short_name','wage_eur']].sort_values(by=['wage_eur'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "93034147-8b40-45c3-b4e3-df7650c248bd",
   "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>short_name</th>\n",
       "      <th>shooting</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>L. Messi</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>H. Kane</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>S. Agüero</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>F. Quagliarella</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            short_name  shooting\n",
       "1    Cristiano Ronaldo      93.0\n",
       "0             L. Messi      92.0\n",
       "12             H. Kane      91.0\n",
       "17           S. Agüero      90.0\n",
       "205    F. Quagliarella      89.0"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To determine shooting skills of players by name\n",
    "player_shootings = fifa[['short_name','shooting']]\n",
    "player_shootings.sort_values(by=['shooting'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "158485aa-9a7e-465d-be2a-9facb9b35353",
   "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>short_name</th>\n",
       "      <th>shooting</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>M. Reus</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>K. Volland</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>T. Müller</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>M. Kruse</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>S. Gnabry</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     short_name  shooting\n",
       "37      M. Reus      88.0\n",
       "276  K. Volland      84.0\n",
       "70    T. Müller      83.0\n",
       "217    M. Kruse      83.0\n",
       "120   S. Gnabry      82.0"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Shooting skill by Germany player names\n",
    "Germany[['short_name','shooting']].sort_values(by=['shooting'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "2a3029b7-6f77-49d5-bd5c-9ae594955bce",
   "metadata": {},
   "outputs": [],
   "source": [
    "players_defending=fifa[['short_name','defending','nationality','club']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "edad7caa-4326-49db-849f-78782fa346a5",
   "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>short_name</th>\n",
       "      <th>defending</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>G. Chiellini</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Italy</td>\n",
       "      <td>Juventus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>V. van Dijk</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>Liverpool</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>K. Koulibaly</td>\n",
       "      <td>89.0</td>\n",
       "      <td>Senegal</td>\n",
       "      <td>Napoli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>D. Godín</td>\n",
       "      <td>89.0</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Inter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>M. Hummels</td>\n",
       "      <td>89.0</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Borussia Dortmund</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      short_name  defending  nationality               club\n",
       "16  G. Chiellini       90.0        Italy           Juventus\n",
       "7    V. van Dijk       90.0  Netherlands          Liverpool\n",
       "11  K. Koulibaly       89.0      Senegal             Napoli\n",
       "35      D. Godín       89.0      Uruguay              Inter\n",
       "49    M. Hummels       89.0      Germany  Borussia Dortmund"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players_defending.sort_values(by=['defending'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "id": "060c39fc-385f-482a-8653-f6eab30ca9c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Store the values of real madrid player \n",
    "real_madrid=fifa[fifa['club']=='Real Madrid']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "f6d19098-2a97-4afd-89eb-f7282232fdd4",
   "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>183277</td>\n",
       "      <td>https://sofifa.com/player/183277/eden-hazard/2...</td>\n",
       "      <td>E. Hazard</td>\n",
       "      <td>Eden Hazard</td>\n",
       "      <td>28</td>\n",
       "      <td>1/7/1991</td>\n",
       "      <td>175</td>\n",
       "      <td>74</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>66+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>66+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>61+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>177003</td>\n",
       "      <td>https://sofifa.com/player/177003/luka-modric/2...</td>\n",
       "      <td>L. Modrić</td>\n",
       "      <td>Luka Modrić</td>\n",
       "      <td>33</td>\n",
       "      <td>9/9/1985</td>\n",
       "      <td>172</td>\n",
       "      <td>66</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>81+3</td>\n",
       "      <td>81+3</td>\n",
       "      <td>81+3</td>\n",
       "      <td>81+3</td>\n",
       "      <td>81+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>79+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>182521</td>\n",
       "      <td>https://sofifa.com/player/182521/toni-kroos/20...</td>\n",
       "      <td>T. Kroos</td>\n",
       "      <td>Toni Kroos</td>\n",
       "      <td>29</td>\n",
       "      <td>1/4/1990</td>\n",
       "      <td>183</td>\n",
       "      <td>76</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>75+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>75+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>72+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</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>33</td>\n",
       "      <td>3/30/1986</td>\n",
       "      <td>184</td>\n",
       "      <td>82</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>80+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>80+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>87+3</td>\n",
       "      <td>87+3</td>\n",
       "      <td>87+3</td>\n",
       "      <td>82+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>165153</td>\n",
       "      <td>https://sofifa.com/player/165153/karim-benzema...</td>\n",
       "      <td>K. Benzema</td>\n",
       "      <td>Karim Benzema</td>\n",
       "      <td>31</td>\n",
       "      <td>12/19/1987</td>\n",
       "      <td>185</td>\n",
       "      <td>81</td>\n",
       "      <td>France</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>58+3</td>\n",
       "      <td>54+3</td>\n",
       "      <td>54+3</td>\n",
       "      <td>54+3</td>\n",
       "      <td>58+3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    sofifa_id                                         player_url  \\\n",
       "4      183277  https://sofifa.com/player/183277/eden-hazard/2...   \n",
       "8      177003  https://sofifa.com/player/177003/luka-modric/2...   \n",
       "36     182521  https://sofifa.com/player/182521/toni-kroos/20...   \n",
       "18     155862  https://sofifa.com/player/155862/sergio-ramos-...   \n",
       "46     165153  https://sofifa.com/player/165153/karim-benzema...   \n",
       "\n",
       "      short_name            long_name  age         dob  height_cm  weight_kg  \\\n",
       "4      E. Hazard          Eden Hazard   28    1/7/1991        175         74   \n",
       "8      L. Modrić          Luka Modrić   33    9/9/1985        172         66   \n",
       "36      T. Kroos           Toni Kroos   29    1/4/1990        183         76   \n",
       "18  Sergio Ramos  Sergio Ramos García   33   3/30/1986        184         82   \n",
       "46    K. Benzema        Karim Benzema   31  12/19/1987        185         81   \n",
       "\n",
       "   nationality         club  ...   lwb   ldm   cdm   rdm   rwb    lb   lcb  \\\n",
       "4      Belgium  Real Madrid  ...  66+3  63+3  63+3  63+3  66+3  61+3  49+3   \n",
       "8      Croatia  Real Madrid  ...  81+3  81+3  81+3  81+3  81+3  79+3  72+3   \n",
       "36     Germany  Real Madrid  ...  75+3  79+3  79+3  79+3  75+3  72+3  69+3   \n",
       "18       Spain  Real Madrid  ...  80+3  84+3  84+3  84+3  80+3  82+3  87+3   \n",
       "46      France  Real Madrid  ...  62+3  62+3  62+3  62+3  62+3  58+3  54+3   \n",
       "\n",
       "      cb   rcb    rb  \n",
       "4   49+3  49+3  61+3  \n",
       "8   72+3  72+3  79+3  \n",
       "36  69+3  69+3  72+3  \n",
       "18  87+3  87+3  82+3  \n",
       "46  54+3  54+3  58+3  \n",
       "\n",
       "[5 rows x 104 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To know the highest wages of real madrid players from list\n",
    "real_madrid.sort_values(by=['wage_eur'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "id": "1925e074-c884-4c20-8f7a-a59387c14e3a",
   "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>short_name</th>\n",
       "      <th>wage_eur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E. Hazard</td>\n",
       "      <td>470000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>L. Modrić</td>\n",
       "      <td>340000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>T. Kroos</td>\n",
       "      <td>330000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sergio Ramos</td>\n",
       "      <td>300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>K. Benzema</td>\n",
       "      <td>285000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      short_name  wage_eur\n",
       "4      E. Hazard    470000\n",
       "8      L. Modrić    340000\n",
       "36      T. Kroos    330000\n",
       "18  Sergio Ramos    300000\n",
       "46    K. Benzema    285000"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "real_madrid[['short_name','wage_eur']].sort_values(by=['wage_eur'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "c6252804-cefb-4caf-a43b-9a5b4a30498a",
   "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>173731</td>\n",
       "      <td>https://sofifa.com/player/173731/gareth-bale/2...</td>\n",
       "      <td>G. Bale</td>\n",
       "      <td>Gareth Frank Bale</td>\n",
       "      <td>29</td>\n",
       "      <td>7/16/1989</td>\n",
       "      <td>185</td>\n",
       "      <td>82</td>\n",
       "      <td>Wales</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>72+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>69+3</td>\n",
       "      <td>72+3</td>\n",
       "      <td>70+3</td>\n",
       "      <td>66+3</td>\n",
       "      <td>66+3</td>\n",
       "      <td>66+3</td>\n",
       "      <td>70+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>198710</td>\n",
       "      <td>https://sofifa.com/player/198710/james-rodrigu...</td>\n",
       "      <td>J. Rodríguez</td>\n",
       "      <td>James David Rodríguez Rubio</td>\n",
       "      <td>27</td>\n",
       "      <td>7/12/1991</td>\n",
       "      <td>180</td>\n",
       "      <td>75</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>67+3</td>\n",
       "      <td>67+3</td>\n",
       "      <td>67+3</td>\n",
       "      <td>67+3</td>\n",
       "      <td>67+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>57+3</td>\n",
       "      <td>57+3</td>\n",
       "      <td>57+3</td>\n",
       "      <td>62+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>183277</td>\n",
       "      <td>https://sofifa.com/player/183277/eden-hazard/2...</td>\n",
       "      <td>E. Hazard</td>\n",
       "      <td>Eden Hazard</td>\n",
       "      <td>28</td>\n",
       "      <td>1/7/1991</td>\n",
       "      <td>175</td>\n",
       "      <td>74</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>66+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>63+3</td>\n",
       "      <td>66+3</td>\n",
       "      <td>61+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>49+3</td>\n",
       "      <td>61+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>165153</td>\n",
       "      <td>https://sofifa.com/player/165153/karim-benzema...</td>\n",
       "      <td>K. Benzema</td>\n",
       "      <td>Karim Benzema</td>\n",
       "      <td>31</td>\n",
       "      <td>12/19/1987</td>\n",
       "      <td>185</td>\n",
       "      <td>81</td>\n",
       "      <td>France</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>62+3</td>\n",
       "      <td>58+3</td>\n",
       "      <td>54+3</td>\n",
       "      <td>54+3</td>\n",
       "      <td>54+3</td>\n",
       "      <td>58+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>232432</td>\n",
       "      <td>https://sofifa.com/player/232432/luka-jovic/20...</td>\n",
       "      <td>L. Jović</td>\n",
       "      <td>Luka Jović</td>\n",
       "      <td>21</td>\n",
       "      <td>12/23/1997</td>\n",
       "      <td>182</td>\n",
       "      <td>85</td>\n",
       "      <td>Serbia</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>55+2</td>\n",
       "      <td>53+2</td>\n",
       "      <td>53+2</td>\n",
       "      <td>53+2</td>\n",
       "      <td>55+2</td>\n",
       "      <td>51+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>47+2</td>\n",
       "      <td>51+2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     sofifa_id                                         player_url  \\\n",
       "100     173731  https://sofifa.com/player/173731/gareth-bale/2...   \n",
       "106     198710  https://sofifa.com/player/198710/james-rodrigu...   \n",
       "4       183277  https://sofifa.com/player/183277/eden-hazard/2...   \n",
       "46      165153  https://sofifa.com/player/165153/karim-benzema...   \n",
       "161     232432  https://sofifa.com/player/232432/luka-jovic/20...   \n",
       "\n",
       "       short_name                    long_name  age         dob  height_cm  \\\n",
       "100       G. Bale            Gareth Frank Bale   29   7/16/1989        185   \n",
       "106  J. Rodríguez  James David Rodríguez Rubio   27   7/12/1991        180   \n",
       "4       E. Hazard                  Eden Hazard   28    1/7/1991        175   \n",
       "46     K. Benzema                Karim Benzema   31  12/19/1987        185   \n",
       "161      L. Jović                   Luka Jović   21  12/23/1997        182   \n",
       "\n",
       "     weight_kg nationality         club  ...   lwb   ldm   cdm   rdm   rwb  \\\n",
       "100         82       Wales  Real Madrid  ...  72+3  69+3  69+3  69+3  72+3   \n",
       "106         75    Colombia  Real Madrid  ...  67+3  67+3  67+3  67+3  67+3   \n",
       "4           74     Belgium  Real Madrid  ...  66+3  63+3  63+3  63+3  66+3   \n",
       "46          81      France  Real Madrid  ...  62+3  62+3  62+3  62+3  62+3   \n",
       "161         85      Serbia  Real Madrid  ...  55+2  53+2  53+2  53+2  55+2   \n",
       "\n",
       "       lb   lcb    cb   rcb    rb  \n",
       "100  70+3  66+3  66+3  66+3  70+3  \n",
       "106  62+3  57+3  57+3  57+3  62+3  \n",
       "4    61+3  49+3  49+3  49+3  61+3  \n",
       "46   58+3  54+3  54+3  54+3  58+3  \n",
       "161  51+2  47+2  47+2  47+2  51+2  \n",
       "\n",
       "[5 rows x 104 columns]"
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To extract the best shooter in real madrid\n",
    "real_madrid.sort_values(by=['shooting'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "0f62c947-a763-462e-b420-fec6b7acea97",
   "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>short_name</th>\n",
       "      <th>shooting</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>G. Bale</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>J. Rodríguez</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E. Hazard</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>K. Benzema</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>L. Jović</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       short_name  shooting\n",
       "100       G. Bale      87.0\n",
       "106  J. Rodríguez      86.0\n",
       "4       E. Hazard      83.0\n",
       "46     K. Benzema      82.0\n",
       "161      L. Jović      82.0"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "real_madrid[['short_name','shooting']].sort_values(by=['shooting'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "id": "ce24b346-1d2a-4b6c-91e1-f6b301fc6f8c",
   "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>age</th>\n",
       "      <th>dob</th>\n",
       "      <th>height_cm</th>\n",
       "      <th>weight_kg</th>\n",
       "      <th>nationality</th>\n",
       "      <th>club</th>\n",
       "      <th>...</th>\n",
       "      <th>lwb</th>\n",
       "      <th>ldm</th>\n",
       "      <th>cdm</th>\n",
       "      <th>rdm</th>\n",
       "      <th>rwb</th>\n",
       "      <th>lb</th>\n",
       "      <th>lcb</th>\n",
       "      <th>cb</th>\n",
       "      <th>rcb</th>\n",
       "      <th>rb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18</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>33</td>\n",
       "      <td>3/30/1986</td>\n",
       "      <td>184</td>\n",
       "      <td>82</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>80+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>80+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>87+3</td>\n",
       "      <td>87+3</td>\n",
       "      <td>87+3</td>\n",
       "      <td>82+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>200145</td>\n",
       "      <td>https://sofifa.com/player/200145/carlos-henriq...</td>\n",
       "      <td>Casemiro</td>\n",
       "      <td>Carlos Henrique Venancio Casimiro</td>\n",
       "      <td>27</td>\n",
       "      <td>2/23/1992</td>\n",
       "      <td>185</td>\n",
       "      <td>84</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>78+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>78+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>84+3</td>\n",
       "      <td>79+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>201535</td>\n",
       "      <td>https://sofifa.com/player/201535/raphael-varan...</td>\n",
       "      <td>R. Varane</td>\n",
       "      <td>Raphaël Varane</td>\n",
       "      <td>26</td>\n",
       "      <td>4/25/1993</td>\n",
       "      <td>191</td>\n",
       "      <td>81</td>\n",
       "      <td>France</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>74+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>79+3</td>\n",
       "      <td>74+3</td>\n",
       "      <td>77+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>77+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>204963</td>\n",
       "      <td>https://sofifa.com/player/204963/daniel-carvaj...</td>\n",
       "      <td>Carvajal</td>\n",
       "      <td>Daniel Carvajal Ramos</td>\n",
       "      <td>27</td>\n",
       "      <td>1/11/1992</td>\n",
       "      <td>173</td>\n",
       "      <td>73</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>83+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>82+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>83+3</td>\n",
       "      <td>80+3</td>\n",
       "      <td>80+3</td>\n",
       "      <td>80+3</td>\n",
       "      <td>83+3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>240130</td>\n",
       "      <td>https://sofifa.com/player/240130/eder-gabriel-...</td>\n",
       "      <td>Éder Militão</td>\n",
       "      <td>Éder Gabriel Militão</td>\n",
       "      <td>21</td>\n",
       "      <td>1/18/1998</td>\n",
       "      <td>186</td>\n",
       "      <td>78</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>...</td>\n",
       "      <td>78+2</td>\n",
       "      <td>76+2</td>\n",
       "      <td>76+2</td>\n",
       "      <td>76+2</td>\n",
       "      <td>78+2</td>\n",
       "      <td>78+2</td>\n",
       "      <td>79+2</td>\n",
       "      <td>79+2</td>\n",
       "      <td>79+2</td>\n",
       "      <td>78+2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     sofifa_id                                         player_url  \\\n",
       "18      155862  https://sofifa.com/player/155862/sergio-ramos-...   \n",
       "42      200145  https://sofifa.com/player/200145/carlos-henriq...   \n",
       "76      201535  https://sofifa.com/player/201535/raphael-varan...   \n",
       "94      204963  https://sofifa.com/player/204963/daniel-carvaj...   \n",
       "332     240130  https://sofifa.com/player/240130/eder-gabriel-...   \n",
       "\n",
       "       short_name                          long_name  age        dob  \\\n",
       "18   Sergio Ramos                Sergio Ramos García   33  3/30/1986   \n",
       "42       Casemiro  Carlos Henrique Venancio Casimiro   27  2/23/1992   \n",
       "76      R. Varane                     Raphaël Varane   26  4/25/1993   \n",
       "94       Carvajal              Daniel Carvajal Ramos   27  1/11/1992   \n",
       "332  Éder Militão               Éder Gabriel Militão   21  1/18/1998   \n",
       "\n",
       "     height_cm  weight_kg nationality         club  ...   lwb   ldm   cdm  \\\n",
       "18         184         82       Spain  Real Madrid  ...  80+3  84+3  84+3   \n",
       "42         185         84      Brazil  Real Madrid  ...  78+3  84+3  84+3   \n",
       "76         191         81      France  Real Madrid  ...  74+3  79+3  79+3   \n",
       "94         173         73       Spain  Real Madrid  ...  83+3  82+3  82+3   \n",
       "332        186         78      Brazil  Real Madrid  ...  78+2  76+2  76+2   \n",
       "\n",
       "      rdm   rwb    lb   lcb    cb   rcb    rb  \n",
       "18   84+3  80+3  82+3  87+3  87+3  87+3  82+3  \n",
       "42   84+3  78+3  79+3  84+3  84+3  84+3  79+3  \n",
       "76   79+3  74+3  77+3  83+3  83+3  83+3  77+3  \n",
       "94   82+3  83+3  83+3  80+3  80+3  80+3  83+3  \n",
       "332  76+2  78+2  78+2  79+2  79+2  79+2  78+2  \n",
       "\n",
       "[5 rows x 104 columns]"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To extract the best defender in real madrid\n",
    "real_madrid.sort_values(by=['defending'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "f3b989f2-77b4-42b9-8ac1-b36e4658e9e0",
   "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>short_name</th>\n",
       "      <th>defending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sergio Ramos</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Casemiro</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>R. Varane</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Carvajal</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>Éder Militão</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       short_name  defending\n",
       "18   Sergio Ramos       87.0\n",
       "42       Casemiro       85.0\n",
       "76      R. Varane       85.0\n",
       "94       Carvajal       82.0\n",
       "332  Éder Militão       81.0"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "real_madrid[['short_name','defending']].sort_values(by=['defending'],ascending= False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "d2105310-eb5a-46c7-8183-990b1fae339f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "nationality\n",
       "Spain                 13\n",
       "Brazil                 6\n",
       "France                 3\n",
       "Belgium                2\n",
       "Croatia                1\n",
       "Germany                1\n",
       "Costa Rica             1\n",
       "Wales                  1\n",
       "Colombia               1\n",
       "Serbia                 1\n",
       "Dominican Republic     1\n",
       "Uruguay                1\n",
       "Japan                  1\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To know the nationality of players in real madrid\n",
    "real_madrid['nationality'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5c1cd5a0-716c-43eb-9e11-40e6d1e28971",
   "metadata": {},
   "outputs": [],
   "source": [
    "#To export fifa file in csv format\n",
    "fifa_data_palyers = fifa.to_csv('fifa_dataset.csv', index = True) \n",
    "print('fifa_data is exported to csv') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "180e18d7-749a-4e25-a121-d52a47765438",
   "metadata": {},
   "outputs": [],
   "source": [
    "#To extract fifa file in excel format\n",
    "fifa_data_players = pd.ExcelWriter('fifa_dataset.xlsx')\n",
    "fifa.to_excel(ipl_data, index=False)\n",
    "print(\"fifa File is exported to excel\")"
   ]
  }
 ],
 "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}