dreamteam.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "player_df = pd.read_csv(\"data/FullData.csv\")\n",
    "fifa = player_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Club_Joining</th>\n",
       "      <th>Contract_Expiry</th>\n",
       "      <th>Rating</th>\n",
       "      <th>...</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Curve</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>Volleys</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>LS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LW</td>\n",
       "      <td>7.0</td>\n",
       "      <td>07-01-2009</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>94</td>\n",
       "      <td>...</td>\n",
       "      <td>90</td>\n",
       "      <td>81</td>\n",
       "      <td>76</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>07-01-2004</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>93</td>\n",
       "      <td>...</td>\n",
       "      <td>88</td>\n",
       "      <td>89</td>\n",
       "      <td>90</td>\n",
       "      <td>74</td>\n",
       "      <td>85</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>LW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>07-01-2013</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>79</td>\n",
       "      <td>84</td>\n",
       "      <td>81</td>\n",
       "      <td>83</td>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Luis Suárez</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>LS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>07-11-2014</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>86</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>33</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>Germany</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>07-01-2011</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>47</td>\n",
       "      <td>11</td>\n",
       "      <td>91</td>\n",
       "      <td>89</td>\n",
       "      <td>95</td>\n",
       "      <td>90</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Name Nationality National_Position  National_Kit  \\\n",
       "0  Cristiano Ronaldo    Portugal                LS           7.0   \n",
       "1       Lionel Messi   Argentina                RW          10.0   \n",
       "2             Neymar      Brazil                LW          10.0   \n",
       "3        Luis Suárez     Uruguay                LS           9.0   \n",
       "4       Manuel Neuer     Germany                GK           1.0   \n",
       "\n",
       "           Club Club_Position  Club_Kit Club_Joining  Contract_Expiry  Rating  \\\n",
       "0   Real Madrid            LW       7.0   07-01-2009           2021.0      94   \n",
       "1  FC Barcelona            RW      10.0   07-01-2004           2018.0      93   \n",
       "2  FC Barcelona            LW      11.0   07-01-2013           2021.0      92   \n",
       "3  FC Barcelona            ST       9.0   07-11-2014           2021.0      92   \n",
       "4     FC Bayern            GK       1.0   07-01-2011           2021.0      92   \n",
       "\n",
       "      ...      Long_Shots Curve Freekick_Accuracy Penalties  Volleys  \\\n",
       "0     ...              90    81                76        85       88   \n",
       "1     ...              88    89                90        74       85   \n",
       "2     ...              77    79                84        81       83   \n",
       "3     ...              86    86                84        85       88   \n",
       "4     ...              16    14                11        47       11   \n",
       "\n",
       "  GK_Positioning GK_Diving  GK_Kicking  GK_Handling  GK_Reflexes  \n",
       "0             14         7          15           11           11  \n",
       "1             14         6          15           11            8  \n",
       "2             15         9          15            9           11  \n",
       "3             33        27          31           25           37  \n",
       "4             91        89          95           90           89  \n",
       "\n",
       "[5 rows x 53 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "player_df = player_df.drop(['Club_Joining','Contract_Expiry','Height','Weight','Birth_Date','Work_Rate','Weak_foot','Dribbling',\n",
    "'Marking','Sliding_Tackle','Aggression','Reactions','Interceptions','Vision','Composure','Crossing','Balance','Agility','Jumping','Heading','Finishing','Curve','Volleys'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Preffered_Foot</th>\n",
       "      <th>Age</th>\n",
       "      <th>...</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Shot_Power</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>LS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LW</td>\n",
       "      <td>7.0</td>\n",
       "      <td>94</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>80</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "      <td>76</td>\n",
       "      <td>85</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>93</td>\n",
       "      <td>Left</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>90</td>\n",
       "      <td>74</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>LW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>49</td>\n",
       "      <td>78</td>\n",
       "      <td>77</td>\n",
       "      <td>84</td>\n",
       "      <td>81</td>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Luis Suárez</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>LS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>76</td>\n",
       "      <td>87</td>\n",
       "      <td>86</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>33</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>Germany</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>25</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>47</td>\n",
       "      <td>91</td>\n",
       "      <td>89</td>\n",
       "      <td>95</td>\n",
       "      <td>90</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Name Nationality National_Position  National_Kit  \\\n",
       "0  Cristiano Ronaldo    Portugal                LS           7.0   \n",
       "1       Lionel Messi   Argentina                RW          10.0   \n",
       "2             Neymar      Brazil                LW          10.0   \n",
       "3        Luis Suárez     Uruguay                LS           9.0   \n",
       "4       Manuel Neuer     Germany                GK           1.0   \n",
       "\n",
       "           Club Club_Position  Club_Kit  Rating Preffered_Foot  Age  \\\n",
       "0   Real Madrid            LW       7.0      94          Right   32   \n",
       "1  FC Barcelona            RW      10.0      93           Left   29   \n",
       "2  FC Barcelona            LW      11.0      92          Right   25   \n",
       "3  FC Barcelona            ST       9.0      92          Right   30   \n",
       "4     FC Bayern            GK       1.0      92          Right   31   \n",
       "\n",
       "      ...      Strength  Shot_Power  Long_Shots  Freekick_Accuracy  Penalties  \\\n",
       "0     ...            80          92          90                 76         85   \n",
       "1     ...            59          85          88                 90         74   \n",
       "2     ...            49          78          77                 84         81   \n",
       "3     ...            76          87          86                 84         85   \n",
       "4     ...            83          25          16                 11         47   \n",
       "\n",
       "   GK_Positioning  GK_Diving  GK_Kicking  GK_Handling  GK_Reflexes  \n",
       "0              14          7          15           11           11  \n",
       "1              14          6          15           11            8  \n",
       "2              15          9          15            9           11  \n",
       "3              33         27          31           25           37  \n",
       "4              91         89          95           90           89  \n",
       "\n",
       "[5 rows x 30 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(17588, 30)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                      0\n",
       "Nationality               0\n",
       "National_Position     16513\n",
       "National_Kit          16513\n",
       "Club                      0\n",
       "Club_Position             1\n",
       "Club_Kit                  1\n",
       "Rating                    0\n",
       "Preffered_Foot            0\n",
       "Age                       0\n",
       "Preffered_Position        0\n",
       "Skill_Moves               0\n",
       "Ball_Control              0\n",
       "Standing_Tackle           0\n",
       "Attacking_Position        0\n",
       "Short_Pass                0\n",
       "Long_Pass                 0\n",
       "Acceleration              0\n",
       "Speed                     0\n",
       "Stamina                   0\n",
       "Strength                  0\n",
       "Shot_Power                0\n",
       "Long_Shots                0\n",
       "Freekick_Accuracy         0\n",
       "Penalties                 0\n",
       "GK_Positioning            0\n",
       "GK_Diving                 0\n",
       "GK_Kicking                0\n",
       "GK_Handling               0\n",
       "GK_Reflexes               0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Preffered_Foot</th>\n",
       "      <th>Age</th>\n",
       "      <th>...</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Shot_Power</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>Didier Drogba</td>\n",
       "      <td>Ivory Coast</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Free agent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81</td>\n",
       "      <td>Right</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>85</td>\n",
       "      <td>79</td>\n",
       "      <td>84</td>\n",
       "      <td>84</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Name  Nationality National_Position  National_Kit        Club  \\\n",
       "383  Didier Drogba  Ivory Coast               NaN           NaN  Free agent   \n",
       "\n",
       "    Club_Position  Club_Kit  Rating Preffered_Foot  Age     ...      Strength  \\\n",
       "383           NaN       NaN      81          Right   39     ...            86   \n",
       "\n",
       "     Shot_Power  Long_Shots  Freekick_Accuracy  Penalties  GK_Positioning  \\\n",
       "383          85          79                 84         84               6   \n",
       "\n",
       "     GK_Diving  GK_Kicking  GK_Handling  GK_Reflexes  \n",
       "383         10           8           11           14  \n",
       "\n",
       "[1 rows x 30 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df[player_df['Club_Position'].isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Preffered_Foot</th>\n",
       "      <th>Age</th>\n",
       "      <th>...</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Shot_Power</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>LS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LW</td>\n",
       "      <td>7.0</td>\n",
       "      <td>94</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>80</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "      <td>76</td>\n",
       "      <td>85</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>93</td>\n",
       "      <td>Left</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>90</td>\n",
       "      <td>74</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Neymar</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>LW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>49</td>\n",
       "      <td>78</td>\n",
       "      <td>77</td>\n",
       "      <td>84</td>\n",
       "      <td>81</td>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Luis Suárez</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>LS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>76</td>\n",
       "      <td>87</td>\n",
       "      <td>86</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>33</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>Germany</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>25</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>47</td>\n",
       "      <td>91</td>\n",
       "      <td>89</td>\n",
       "      <td>95</td>\n",
       "      <td>90</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>De Gea</td>\n",
       "      <td>Spain</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Manchester Utd</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>90</td>\n",
       "      <td>Right</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>64</td>\n",
       "      <td>31</td>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>40</td>\n",
       "      <td>86</td>\n",
       "      <td>88</td>\n",
       "      <td>87</td>\n",
       "      <td>85</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Robert Lewandowski</td>\n",
       "      <td>Poland</td>\n",
       "      <td>LS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>90</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>81</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Gareth Bale</td>\n",
       "      <td>Wales</td>\n",
       "      <td>RS</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>RW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>90</td>\n",
       "      <td>Left</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>80</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>85</td>\n",
       "      <td>76</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Zlatan Ibrahimović</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manchester Utd</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>90</td>\n",
       "      <td>Right</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>93</td>\n",
       "      <td>93</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>91</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Thibaut Courtois</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>GK</td>\n",
       "      <td>13.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Left</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>70</td>\n",
       "      <td>36</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>27</td>\n",
       "      <td>86</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>91</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Jérôme Boateng</td>\n",
       "      <td>Germany</td>\n",
       "      <td>RCB</td>\n",
       "      <td>17.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>Sub</td>\n",
       "      <td>17.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>91</td>\n",
       "      <td>79</td>\n",
       "      <td>58</td>\n",
       "      <td>31</td>\n",
       "      <td>46</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Eden Hazard</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>LF</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>LW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>79</td>\n",
       "      <td>82</td>\n",
       "      <td>79</td>\n",
       "      <td>86</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Luka Modrić</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>RCM</td>\n",
       "      <td>19.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>73</td>\n",
       "      <td>82</td>\n",
       "      <td>77</td>\n",
       "      <td>80</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Mesut Özil</td>\n",
       "      <td>Germany</td>\n",
       "      <td>CAM</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>CAM</td>\n",
       "      <td>11.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Left</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>70</td>\n",
       "      <td>76</td>\n",
       "      <td>79</td>\n",
       "      <td>67</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Gonzalo Higuaín</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Sub</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>85</td>\n",
       "      <td>86</td>\n",
       "      <td>80</td>\n",
       "      <td>62</td>\n",
       "      <td>70</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Thiago Silva</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Sub</td>\n",
       "      <td>14.0</td>\n",
       "      <td>PSG</td>\n",
       "      <td>LCB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>78</td>\n",
       "      <td>71</td>\n",
       "      <td>73</td>\n",
       "      <td>71</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sergio Ramos</td>\n",
       "      <td>Spain</td>\n",
       "      <td>LCB</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LCB</td>\n",
       "      <td>4.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>79</td>\n",
       "      <td>55</td>\n",
       "      <td>67</td>\n",
       "      <td>68</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sergio Agüero</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Sub</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>ST</td>\n",
       "      <td>10.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>73</td>\n",
       "      <td>87</td>\n",
       "      <td>84</td>\n",
       "      <td>72</td>\n",
       "      <td>80</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Paul Pogba</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manchester Utd</td>\n",
       "      <td>LCM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Antoine Griezmann</td>\n",
       "      <td>France</td>\n",
       "      <td>CAM</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>RS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Left</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "      <td>75</td>\n",
       "      <td>71</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Kevin De Bruyne</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>RCM</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>RCM</td>\n",
       "      <td>17.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>73</td>\n",
       "      <td>85</td>\n",
       "      <td>86</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Marco Reus</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bor. Dortmund</td>\n",
       "      <td>LW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>67</td>\n",
       "      <td>87</td>\n",
       "      <td>85</td>\n",
       "      <td>84</td>\n",
       "      <td>84</td>\n",
       "      <td>13</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Alexis Sánchez</td>\n",
       "      <td>Chile</td>\n",
       "      <td>LW</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>ST</td>\n",
       "      <td>7.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>72</td>\n",
       "      <td>84</td>\n",
       "      <td>81</td>\n",
       "      <td>78</td>\n",
       "      <td>77</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Toni Kroos</td>\n",
       "      <td>Germany</td>\n",
       "      <td>LDM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LCM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>74</td>\n",
       "      <td>87</td>\n",
       "      <td>88</td>\n",
       "      <td>84</td>\n",
       "      <td>73</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Diego Godín</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>LCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>LCB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>80</td>\n",
       "      <td>67</td>\n",
       "      <td>43</td>\n",
       "      <td>51</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Mats Hummels</td>\n",
       "      <td>Germany</td>\n",
       "      <td>LCB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>LCB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>85</td>\n",
       "      <td>71</td>\n",
       "      <td>51</td>\n",
       "      <td>53</td>\n",
       "      <td>68</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Hugo Lloris</td>\n",
       "      <td>France</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Left</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>23</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>82</td>\n",
       "      <td>87</td>\n",
       "      <td>68</td>\n",
       "      <td>87</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Giorgio Chiellini</td>\n",
       "      <td>Italy</td>\n",
       "      <td>LCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Juventus</td>\n",
       "      <td>LCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Left</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>91</td>\n",
       "      <td>78</td>\n",
       "      <td>49</td>\n",
       "      <td>31</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Philipp Lahm</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RB</td>\n",
       "      <td>21.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>57</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>69</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Pepe</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>RCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>RCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>84</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>47</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>10</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>17558</th>\n",
       "      <td>Kieran Butler</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bray Wanderers</td>\n",
       "      <td>Res</td>\n",
       "      <td>30.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "      <td>23</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17559</th>\n",
       "      <td>Kyle Egan</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Exeter City</td>\n",
       "      <td>Res</td>\n",
       "      <td>36.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>63</td>\n",
       "      <td>22</td>\n",
       "      <td>23</td>\n",
       "      <td>28</td>\n",
       "      <td>35</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17560</th>\n",
       "      <td>Alfie Kilgour</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bristol Rovers</td>\n",
       "      <td>Res</td>\n",
       "      <td>32.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>43</td>\n",
       "      <td>28</td>\n",
       "      <td>24</td>\n",
       "      <td>35</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17561</th>\n",
       "      <td>Shane Hanney</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shamrock Rovers</td>\n",
       "      <td>Sub</td>\n",
       "      <td>2.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>43</td>\n",
       "      <td>41</td>\n",
       "      <td>44</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17562</th>\n",
       "      <td>Louis Jones</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Doncaster</td>\n",
       "      <td>Sub</td>\n",
       "      <td>33.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>57</td>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>48</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17563</th>\n",
       "      <td>Ben Kelly</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dundalk</td>\n",
       "      <td>Sub</td>\n",
       "      <td>30.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>67</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "      <td>46</td>\n",
       "      <td>48</td>\n",
       "      <td>50</td>\n",
       "      <td>46</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17564</th>\n",
       "      <td>Kaylen Hinds</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stevenage</td>\n",
       "      <td>Res</td>\n",
       "      <td>26.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>48</td>\n",
       "      <td>47</td>\n",
       "      <td>26</td>\n",
       "      <td>62</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17565</th>\n",
       "      <td>James King</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bradford City</td>\n",
       "      <td>Res</td>\n",
       "      <td>21.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>32</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>32</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17566</th>\n",
       "      <td>Neil McLaughlin</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Partick Thistle</td>\n",
       "      <td>Sub</td>\n",
       "      <td>26.0</td>\n",
       "      <td>47</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>48</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>39</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17567</th>\n",
       "      <td>Nathan Clifford</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finn Harps</td>\n",
       "      <td>Res</td>\n",
       "      <td>33.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>23</td>\n",
       "      <td>22</td>\n",
       "      <td>28</td>\n",
       "      <td>20</td>\n",
       "      <td>13</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17568</th>\n",
       "      <td>Ciaran Kelly</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finn Harps</td>\n",
       "      <td>Sub</td>\n",
       "      <td>35.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>26</td>\n",
       "      <td>17</td>\n",
       "      <td>25</td>\n",
       "      <td>28</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17569</th>\n",
       "      <td>Adam Kelsey</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scunthorpe Utd</td>\n",
       "      <td>Res</td>\n",
       "      <td>41.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>19</td>\n",
       "      <td>7</td>\n",
       "      <td>12</td>\n",
       "      <td>17</td>\n",
       "      <td>43</td>\n",
       "      <td>46</td>\n",
       "      <td>54</td>\n",
       "      <td>47</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17570</th>\n",
       "      <td>Dominic Peppard</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bohemian FC</td>\n",
       "      <td>Sub</td>\n",
       "      <td>22.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>48</td>\n",
       "      <td>39</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17571</th>\n",
       "      <td>Gavin Dowling</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wexford Youths</td>\n",
       "      <td>Sub</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>38</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>23</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>43</td>\n",
       "      <td>45</td>\n",
       "      <td>57</td>\n",
       "      <td>44</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17572</th>\n",
       "      <td>Tommy Käßemodel</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Erzgebirge Aue</td>\n",
       "      <td>Res</td>\n",
       "      <td>29.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>37</td>\n",
       "      <td>52</td>\n",
       "      <td>39</td>\n",
       "      <td>37</td>\n",
       "      <td>41</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17573</th>\n",
       "      <td>Ronan Wilson</td>\n",
       "      <td>Northern Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Derry City</td>\n",
       "      <td>Sub</td>\n",
       "      <td>35.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>33</td>\n",
       "      <td>33</td>\n",
       "      <td>21</td>\n",
       "      <td>36</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17574</th>\n",
       "      <td>Darragh Doherty</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Longford Town</td>\n",
       "      <td>Sub</td>\n",
       "      <td>26.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>41</td>\n",
       "      <td>32</td>\n",
       "      <td>33</td>\n",
       "      <td>40</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17575</th>\n",
       "      <td>Myles Judd</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Leyton Orient</td>\n",
       "      <td>Sub</td>\n",
       "      <td>29.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>21</td>\n",
       "      <td>22</td>\n",
       "      <td>29</td>\n",
       "      <td>33</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17576</th>\n",
       "      <td>Sam Hornby</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Burton Albion</td>\n",
       "      <td>Res</td>\n",
       "      <td>31.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>24</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>41</td>\n",
       "      <td>50</td>\n",
       "      <td>44</td>\n",
       "      <td>42</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17577</th>\n",
       "      <td>Sam Sargeant</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Leyton Orient</td>\n",
       "      <td>Sub</td>\n",
       "      <td>24.0</td>\n",
       "      <td>46</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>33</td>\n",
       "      <td>24</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>24</td>\n",
       "      <td>47</td>\n",
       "      <td>48</td>\n",
       "      <td>43</td>\n",
       "      <td>42</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17578</th>\n",
       "      <td>Steven Alzate</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Leyton Orient</td>\n",
       "      <td>Res</td>\n",
       "      <td>31.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>36</td>\n",
       "      <td>29</td>\n",
       "      <td>22</td>\n",
       "      <td>35</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17579</th>\n",
       "      <td>Sam Dalby</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Leyton Orient</td>\n",
       "      <td>Sub</td>\n",
       "      <td>30.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>36</td>\n",
       "      <td>42</td>\n",
       "      <td>44</td>\n",
       "      <td>23</td>\n",
       "      <td>40</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17580</th>\n",
       "      <td>Henry Ochieng</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Leyton Orient</td>\n",
       "      <td>Sub</td>\n",
       "      <td>32.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>36</td>\n",
       "      <td>31</td>\n",
       "      <td>36</td>\n",
       "      <td>7</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17581</th>\n",
       "      <td>Harry Clifton</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grimsby Town</td>\n",
       "      <td>Res</td>\n",
       "      <td>15.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>28</td>\n",
       "      <td>35</td>\n",
       "      <td>27</td>\n",
       "      <td>24</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17582</th>\n",
       "      <td>Mark McElhinney</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Derry City</td>\n",
       "      <td>Res</td>\n",
       "      <td>20.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>45</td>\n",
       "      <td>18</td>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "      <td>46</td>\n",
       "      <td>41</td>\n",
       "      <td>50</td>\n",
       "      <td>45</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17583</th>\n",
       "      <td>Adam Dunbar</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wexford Youths</td>\n",
       "      <td>Sub</td>\n",
       "      <td>30.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>52</td>\n",
       "      <td>16</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>15</td>\n",
       "      <td>39</td>\n",
       "      <td>44</td>\n",
       "      <td>52</td>\n",
       "      <td>41</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17584</th>\n",
       "      <td>Dylan McGoey</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Longford Town</td>\n",
       "      <td>Sub</td>\n",
       "      <td>28.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>47</td>\n",
       "      <td>39</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17585</th>\n",
       "      <td>Tommy Ouldridge</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Swindon Town</td>\n",
       "      <td>Res</td>\n",
       "      <td>32.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>44</td>\n",
       "      <td>42</td>\n",
       "      <td>36</td>\n",
       "      <td>42</td>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17586</th>\n",
       "      <td>Mark Foden</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ross County</td>\n",
       "      <td>Sub</td>\n",
       "      <td>45.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>23</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>44</td>\n",
       "      <td>43</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17587</th>\n",
       "      <td>Barry Richardson</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wycombe</td>\n",
       "      <td>Sub</td>\n",
       "      <td>13.0</td>\n",
       "      <td>45</td>\n",
       "      <td>Right</td>\n",
       "      <td>47</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>22</td>\n",
       "      <td>58</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>51</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17587 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Name          Nationality National_Position  \\\n",
       "0       Cristiano Ronaldo             Portugal                LS   \n",
       "1            Lionel Messi            Argentina                RW   \n",
       "2                  Neymar               Brazil                LW   \n",
       "3             Luis Suárez              Uruguay                LS   \n",
       "4            Manuel Neuer              Germany                GK   \n",
       "5                  De Gea                Spain                GK   \n",
       "6      Robert Lewandowski               Poland                LS   \n",
       "7             Gareth Bale                Wales                RS   \n",
       "8      Zlatan Ibrahimović               Sweden               NaN   \n",
       "9        Thibaut Courtois              Belgium                GK   \n",
       "10         Jérôme Boateng              Germany               RCB   \n",
       "11            Eden Hazard              Belgium                LF   \n",
       "12            Luka Modrić              Croatia               NaN   \n",
       "13             Mesut Özil              Germany               CAM   \n",
       "14        Gonzalo Higuaín            Argentina               Sub   \n",
       "15           Thiago Silva               Brazil               Sub   \n",
       "16           Sergio Ramos                Spain               LCB   \n",
       "17          Sergio Agüero            Argentina               Sub   \n",
       "18             Paul Pogba               France               NaN   \n",
       "19      Antoine Griezmann               France               CAM   \n",
       "20        Kevin De Bruyne              Belgium               RCM   \n",
       "21             Marco Reus              Germany               NaN   \n",
       "22         Alexis Sánchez                Chile                LW   \n",
       "23             Toni Kroos              Germany               LDM   \n",
       "24            Diego Godín              Uruguay               LCB   \n",
       "25           Mats Hummels              Germany               LCB   \n",
       "26            Hugo Lloris               France                GK   \n",
       "27      Giorgio Chiellini                Italy               LCB   \n",
       "28           Philipp Lahm              Germany               NaN   \n",
       "29                   Pepe             Portugal               RCB   \n",
       "...                   ...                  ...               ...   \n",
       "17558       Kieran Butler  Republic of Ireland               NaN   \n",
       "17559           Kyle Egan              England               NaN   \n",
       "17560       Alfie Kilgour              England               NaN   \n",
       "17561        Shane Hanney  Republic of Ireland               NaN   \n",
       "17562         Louis Jones              England               NaN   \n",
       "17563           Ben Kelly  Republic of Ireland               NaN   \n",
       "17564        Kaylen Hinds              England               NaN   \n",
       "17565          James King              England               NaN   \n",
       "17566     Neil McLaughlin             Scotland               NaN   \n",
       "17567     Nathan Clifford  Republic of Ireland               NaN   \n",
       "17568        Ciaran Kelly  Republic of Ireland               NaN   \n",
       "17569         Adam Kelsey              England               NaN   \n",
       "17570     Dominic Peppard  Republic of Ireland               NaN   \n",
       "17571       Gavin Dowling  Republic of Ireland               NaN   \n",
       "17572     Tommy Käßemodel              Germany               NaN   \n",
       "17573        Ronan Wilson     Northern Ireland               NaN   \n",
       "17574     Darragh Doherty  Republic of Ireland               NaN   \n",
       "17575          Myles Judd              England               NaN   \n",
       "17576          Sam Hornby              England               NaN   \n",
       "17577        Sam Sargeant              England               NaN   \n",
       "17578       Steven Alzate              England               NaN   \n",
       "17579           Sam Dalby              England               NaN   \n",
       "17580       Henry Ochieng              England               NaN   \n",
       "17581       Harry Clifton              England               NaN   \n",
       "17582     Mark McElhinney  Republic of Ireland               NaN   \n",
       "17583         Adam Dunbar  Republic of Ireland               NaN   \n",
       "17584        Dylan McGoey  Republic of Ireland               NaN   \n",
       "17585     Tommy Ouldridge              England               NaN   \n",
       "17586          Mark Foden             Scotland               NaN   \n",
       "17587    Barry Richardson              England               NaN   \n",
       "\n",
       "       National_Kit             Club Club_Position  Club_Kit  Rating  \\\n",
       "0               7.0      Real Madrid            LW       7.0      94   \n",
       "1              10.0     FC Barcelona            RW      10.0      93   \n",
       "2              10.0     FC Barcelona            LW      11.0      92   \n",
       "3               9.0     FC Barcelona            ST       9.0      92   \n",
       "4               1.0        FC Bayern            GK       1.0      92   \n",
       "5               1.0   Manchester Utd            GK       1.0      90   \n",
       "6               9.0        FC Bayern            ST       9.0      90   \n",
       "7              11.0      Real Madrid            RW      11.0      90   \n",
       "8               NaN   Manchester Utd            ST       9.0      90   \n",
       "9               1.0          Chelsea            GK      13.0      89   \n",
       "10             17.0        FC Bayern           Sub      17.0      89   \n",
       "11             10.0          Chelsea            LW      10.0      89   \n",
       "12              NaN      Real Madrid           RCM      19.0      89   \n",
       "13             10.0          Arsenal           CAM      11.0      89   \n",
       "14              9.0         Juventus            ST       9.0      89   \n",
       "15             14.0              PSG           LCB       2.0      89   \n",
       "16             15.0      Real Madrid           LCB       4.0      89   \n",
       "17              7.0  Manchester City            ST      10.0      89   \n",
       "18              NaN   Manchester Utd           LCM       6.0      88   \n",
       "19              7.0  Atlético Madrid            RS       7.0      88   \n",
       "20              7.0  Manchester City           RCM      17.0      88   \n",
       "21              NaN    Bor. Dortmund            LW      11.0      88   \n",
       "22              7.0          Arsenal            ST       7.0      88   \n",
       "23              8.0      Real Madrid           LCM       8.0      88   \n",
       "24              3.0  Atlético Madrid           LCB       2.0      88   \n",
       "25              5.0        FC Bayern           LCB       5.0      88   \n",
       "26              1.0            Spurs            GK       1.0      88   \n",
       "27              3.0         Juventus           LCB       3.0      88   \n",
       "28              NaN        FC Bayern            RB      21.0      88   \n",
       "29              3.0      Real Madrid           RCB       3.0      88   \n",
       "...             ...              ...           ...       ...     ...   \n",
       "17558           NaN   Bray Wanderers           Res      30.0      47   \n",
       "17559           NaN      Exeter City           Res      36.0      47   \n",
       "17560           NaN   Bristol Rovers           Res      32.0      47   \n",
       "17561           NaN  Shamrock Rovers           Sub       2.0      47   \n",
       "17562           NaN        Doncaster           Sub      33.0      47   \n",
       "17563           NaN          Dundalk           Sub      30.0      47   \n",
       "17564           NaN        Stevenage           Res      26.0      47   \n",
       "17565           NaN    Bradford City           Res      21.0      47   \n",
       "17566           NaN  Partick Thistle           Sub      26.0      47   \n",
       "17567           NaN       Finn Harps           Res      33.0      46   \n",
       "17568           NaN       Finn Harps           Sub      35.0      46   \n",
       "17569           NaN   Scunthorpe Utd           Res      41.0      46   \n",
       "17570           NaN      Bohemian FC           Sub      22.0      46   \n",
       "17571           NaN   Wexford Youths           Sub      23.0      46   \n",
       "17572           NaN   Erzgebirge Aue           Res      29.0      46   \n",
       "17573           NaN       Derry City           Sub      35.0      46   \n",
       "17574           NaN    Longford Town           Sub      26.0      46   \n",
       "17575           NaN    Leyton Orient           Sub      29.0      46   \n",
       "17576           NaN    Burton Albion           Res      31.0      46   \n",
       "17577           NaN    Leyton Orient           Sub      24.0      46   \n",
       "17578           NaN    Leyton Orient           Res      31.0      45   \n",
       "17579           NaN    Leyton Orient           Sub      30.0      45   \n",
       "17580           NaN    Leyton Orient           Sub      32.0      45   \n",
       "17581           NaN     Grimsby Town           Res      15.0      45   \n",
       "17582           NaN       Derry City           Res      20.0      45   \n",
       "17583           NaN   Wexford Youths           Sub      30.0      45   \n",
       "17584           NaN    Longford Town           Sub      28.0      45   \n",
       "17585           NaN     Swindon Town           Res      32.0      45   \n",
       "17586           NaN      Ross County           Sub      45.0      45   \n",
       "17587           NaN          Wycombe           Sub      13.0      45   \n",
       "\n",
       "      Preffered_Foot  Age     ...      Strength  Shot_Power  Long_Shots  \\\n",
       "0              Right   32     ...            80          92          90   \n",
       "1               Left   29     ...            59          85          88   \n",
       "2              Right   25     ...            49          78          77   \n",
       "3              Right   30     ...            76          87          86   \n",
       "4              Right   31     ...            83          25          16   \n",
       "5              Right   26     ...            64          31          12   \n",
       "6              Right   28     ...            84          86          82   \n",
       "7               Left   27     ...            80          91          90   \n",
       "8              Right   35     ...            93          93          88   \n",
       "9               Left   24     ...            70          36          17   \n",
       "10             Right   28     ...            91          79          58   \n",
       "11             Right   26     ...            65          79          82   \n",
       "12             Right   31     ...            58          73          82   \n",
       "13              Left   28     ...            56          70          76   \n",
       "14             Right   29     ...            85          86          80   \n",
       "15             Right   32     ...            81          78          71   \n",
       "16             Right   31     ...            81          79          55   \n",
       "17             Right   28     ...            73          87          84   \n",
       "18             Right   24     ...            91          90          88   \n",
       "19              Left   26     ...            61          81          82   \n",
       "20             Right   25     ...            73          85          86   \n",
       "21             Right   27     ...            67          87          85   \n",
       "22             Right   28     ...            72          84          81   \n",
       "23             Right   27     ...            74          87          88   \n",
       "24             Right   31     ...            80          67          43   \n",
       "25             Right   28     ...            85          71          51   \n",
       "26              Left   30     ...            43          23          14   \n",
       "27              Left   32     ...            91          78          49   \n",
       "28             Right   33     ...            59          57          65   \n",
       "29             Right   34     ...            84          63          56   \n",
       "...              ...  ...     ...           ...         ...         ...   \n",
       "17558          Right   17     ...            54          32          23   \n",
       "17559          Right   19     ...            63          22          23   \n",
       "17560          Right   18     ...            68          43          28   \n",
       "17561          Right   19     ...            44          44          43   \n",
       "17562          Right   18     ...            57          22          14   \n",
       "17563          Right   19     ...            67          20          12   \n",
       "17564          Right   19     ...            55          48          47   \n",
       "17565          Right   20     ...            55          32          18   \n",
       "17566          Right   19     ...            56          48          30   \n",
       "17567          Right   19     ...            43          23          22   \n",
       "17568          Right   18     ...            42          26          17   \n",
       "17569          Right   17     ...            50          19           7   \n",
       "17570          Right   17     ...            48          39          16   \n",
       "17571          Right   38     ...            50          23          11   \n",
       "17572          Right   28     ...            37          52          39   \n",
       "17573          Right   18     ...            58          33          33   \n",
       "17574          Right   19     ...            56          41          32   \n",
       "17575          Right   18     ...            40          21          22   \n",
       "17576          Right   22     ...            58          24          18   \n",
       "17577          Right   19     ...            33          24          13   \n",
       "17578          Right   18     ...            44          36          29   \n",
       "17579          Right   17     ...            36          42          44   \n",
       "17580          Right   18     ...            53          47          36   \n",
       "17581          Right   18     ...            56          28          35   \n",
       "17582          Right   19     ...            45          18          12   \n",
       "17583          Right   19     ...            52          16          13   \n",
       "17584          Right   19     ...            42          17          11   \n",
       "17585          Right   18     ...            34          44          42   \n",
       "17586          Right   21     ...            61          23          12   \n",
       "17587          Right   47     ...            47          13          16   \n",
       "\n",
       "       Freekick_Accuracy  Penalties  GK_Positioning  GK_Diving  GK_Kicking  \\\n",
       "0                     76         85              14          7          15   \n",
       "1                     90         74              14          6          15   \n",
       "2                     84         81              15          9          15   \n",
       "3                     84         85              33         27          31   \n",
       "4                     11         47              91         89          95   \n",
       "5                     19         40              86         88          87   \n",
       "6                     76         81               8         15          12   \n",
       "7                     85         76               5         15          11   \n",
       "8                     82         91               9         13          10   \n",
       "9                     11         27              86         84          69   \n",
       "10                    31         46               6          7          15   \n",
       "11                    79         86               8         11           6   \n",
       "12                    77         80              14         13           7   \n",
       "13                    79         67               6          6          10   \n",
       "14                    62         70               5          5           7   \n",
       "15                    73         71               9          9           5   \n",
       "16                    67         68               7         11           9   \n",
       "17                    72         80              11         13           6   \n",
       "18                    82         76               4          5           2   \n",
       "19                    75         71              13         14          14   \n",
       "20                    84         77              10         15           5   \n",
       "21                    84         84              13         12          13   \n",
       "22                    78         77              12         10          15   \n",
       "23                    84         73               7         10          13   \n",
       "24                    51         50               5          6          15   \n",
       "25                    53         68               5         15          10   \n",
       "26                    10         40              82         87          68   \n",
       "27                    31         50               4          3           2   \n",
       "28                    59         69              14         11           5   \n",
       "29                    47         57               9          8           5   \n",
       "...                  ...        ...             ...        ...         ...   \n",
       "17558                 25         35              12         12          12   \n",
       "17559                 28         35               9          7          10   \n",
       "17560                 24         35              10          6          11   \n",
       "17561                 41         44              13         14          12   \n",
       "17562                 13         48              45         45          43   \n",
       "17563                 17         13              46         48          50   \n",
       "17564                 26         62               9         15          13   \n",
       "17565                 16         32              10          6           7   \n",
       "17566                 30         39              14          8          15   \n",
       "17567                 28         20              13         12           8   \n",
       "17568                 25         28               7          7           9   \n",
       "17569                 12         17              43         46          54   \n",
       "17570                 20         31               5         13           5   \n",
       "17571                 10         12              43         45          57   \n",
       "17572                 37         41              13         10           6   \n",
       "17573                 21         36              11         11          11   \n",
       "17574                 33         40               9          7          14   \n",
       "17575                 29         33              12          5          14   \n",
       "17576                 13         14              41         50          44   \n",
       "17577                 13         24              47         48          43   \n",
       "17578                 22         35               7          9           6   \n",
       "17579                 23         40              12          7          14   \n",
       "17580                 31         36               7         12          12   \n",
       "17581                 27         24               7          9           8   \n",
       "17582                 11         16              46         41          50   \n",
       "17583                 13         15              39         44          52   \n",
       "17584                 13         16              47         39          46   \n",
       "17585                 36         42              15          7          13   \n",
       "17586                 12         24              40         45          44   \n",
       "17587                 11         22              58         37          37   \n",
       "\n",
       "       GK_Handling  GK_Reflexes  \n",
       "0               11           11  \n",
       "1               11            8  \n",
       "2                9           11  \n",
       "3               25           37  \n",
       "4               90           89  \n",
       "5               85           90  \n",
       "6                6           10  \n",
       "7               15            6  \n",
       "8               15           12  \n",
       "9               91           89  \n",
       "10              12            5  \n",
       "11              12            8  \n",
       "12               9            9  \n",
       "13              14           14  \n",
       "14              12           10  \n",
       "15              12           10  \n",
       "16               8           11  \n",
       "17              15           14  \n",
       "18               6            3  \n",
       "19               8           14  \n",
       "20              13           13  \n",
       "21              12           11  \n",
       "22              10           13  \n",
       "23              11           10  \n",
       "24               8           15  \n",
       "25               6            6  \n",
       "26              87           90  \n",
       "27               3            3  \n",
       "28              12            5  \n",
       "29              15           10  \n",
       "...            ...          ...  \n",
       "17558            8            6  \n",
       "17559            8            8  \n",
       "17560           11            5  \n",
       "17561            5           14  \n",
       "17562           43           48  \n",
       "17563           46           44  \n",
       "17564           11            6  \n",
       "17565           15           12  \n",
       "17566           16            9  \n",
       "17567           11            5  \n",
       "17568           14           15  \n",
       "17569           47           48  \n",
       "17570           15           13  \n",
       "17571           44           46  \n",
       "17572           12            6  \n",
       "17573            8           10  \n",
       "17574           10           10  \n",
       "17575            5           10  \n",
       "17576           42           48  \n",
       "17577           42           51  \n",
       "17578            6            6  \n",
       "17579           12            7  \n",
       "17580           13            9  \n",
       "17581            6           10  \n",
       "17582           45           44  \n",
       "17583           41           46  \n",
       "17584           46           46  \n",
       "17585           14            7  \n",
       "17586           43           45  \n",
       "17587           51           33  \n",
       "\n",
       "[17587 rows x 30 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df.dropna(subset=['Club_Position'], how=\"all\", inplace=True)\n",
    "player_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Club_Position\n",
       "CAM    89\n",
       "CB     85\n",
       "CDM    86\n",
       "CF     70\n",
       "CM     83\n",
       "GK     92\n",
       "LAM    84\n",
       "LB     86\n",
       "LCB    89\n",
       "LCM    88\n",
       "LDM    87\n",
       "LF     86\n",
       "LM     88\n",
       "LS     83\n",
       "LW     94\n",
       "LWB    81\n",
       "RAM    81\n",
       "RB     88\n",
       "RCB    88\n",
       "RCM    89\n",
       "RDM    86\n",
       "RF     83\n",
       "RM     87\n",
       "RS     88\n",
       "RW     93\n",
       "RWB    82\n",
       "Res    83\n",
       "ST     92\n",
       "Sub    89\n",
       "Name: Rating, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df.groupby('Club_Position')['Rating'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df = player_df[player_df.groupby(['Club_Position'])['Rating'].transform(max) == player_df['Rating']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['LW', 'RW', 'ST', 'GK', 'Sub', 'RCM', 'CAM', 'LCB', 'LCM', 'RS',\n",
       "       'RB', 'RCB', 'LM', 'LDM', 'RM', 'LB', 'CDM', 'RDM', 'LF', 'CB',\n",
       "       'LAM', 'Res', 'CM', 'LS', 'RF', 'RWB', 'RAM', 'LWB', 'CF'], dtype=object)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.Club_Position.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df = df[(df.Club_Position != 'Sub') & (df.Club_Position != 'Res')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Preffered_Foot</th>\n",
       "      <th>Age</th>\n",
       "      <th>...</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Shot_Power</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>LS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LW</td>\n",
       "      <td>7.0</td>\n",
       "      <td>94</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>80</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "      <td>76</td>\n",
       "      <td>85</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>93</td>\n",
       "      <td>Left</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>90</td>\n",
       "      <td>74</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Luis Suárez</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>LS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>76</td>\n",
       "      <td>87</td>\n",
       "      <td>86</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>33</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>Germany</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>GK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>25</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>47</td>\n",
       "      <td>91</td>\n",
       "      <td>89</td>\n",
       "      <td>95</td>\n",
       "      <td>90</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Luka Modrić</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>RCM</td>\n",
       "      <td>19.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>73</td>\n",
       "      <td>82</td>\n",
       "      <td>77</td>\n",
       "      <td>80</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Mesut Özil</td>\n",
       "      <td>Germany</td>\n",
       "      <td>CAM</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>CAM</td>\n",
       "      <td>11.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Left</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>70</td>\n",
       "      <td>76</td>\n",
       "      <td>79</td>\n",
       "      <td>67</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Thiago Silva</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Sub</td>\n",
       "      <td>14.0</td>\n",
       "      <td>PSG</td>\n",
       "      <td>LCB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>78</td>\n",
       "      <td>71</td>\n",
       "      <td>73</td>\n",
       "      <td>71</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sergio Ramos</td>\n",
       "      <td>Spain</td>\n",
       "      <td>LCB</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LCB</td>\n",
       "      <td>4.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>79</td>\n",
       "      <td>55</td>\n",
       "      <td>67</td>\n",
       "      <td>68</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Paul Pogba</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manchester Utd</td>\n",
       "      <td>LCM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Antoine Griezmann</td>\n",
       "      <td>France</td>\n",
       "      <td>CAM</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>RS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Left</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "      <td>75</td>\n",
       "      <td>71</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Toni Kroos</td>\n",
       "      <td>Germany</td>\n",
       "      <td>LDM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LCM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>74</td>\n",
       "      <td>87</td>\n",
       "      <td>88</td>\n",
       "      <td>84</td>\n",
       "      <td>73</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Philipp Lahm</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RB</td>\n",
       "      <td>21.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>57</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>69</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Pepe</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>RCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>RCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>84</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>47</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Iniesta</td>\n",
       "      <td>Spain</td>\n",
       "      <td>LCM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>65</td>\n",
       "      <td>74</td>\n",
       "      <td>70</td>\n",
       "      <td>71</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Arturo Vidal</td>\n",
       "      <td>Chile</td>\n",
       "      <td>CDM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>LDM</td>\n",
       "      <td>23.0</td>\n",
       "      <td>87</td>\n",
       "      <td>Right</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>79</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>68</td>\n",
       "      <td>84</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Arjen Robben</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>RW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RM</td>\n",
       "      <td>10.0</td>\n",
       "      <td>87</td>\n",
       "      <td>Left</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>86</td>\n",
       "      <td>88</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>David Alaba</td>\n",
       "      <td>Austria</td>\n",
       "      <td>LM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>LB</td>\n",
       "      <td>27.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Left</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>69</td>\n",
       "      <td>83</td>\n",
       "      <td>83</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Sergio Busquets</td>\n",
       "      <td>Spain</td>\n",
       "      <td>CDM</td>\n",
       "      <td>5.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>CDM</td>\n",
       "      <td>5.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>61</td>\n",
       "      <td>54</td>\n",
       "      <td>68</td>\n",
       "      <td>60</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Thiago</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Sub</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RDM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Right</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>75</td>\n",
       "      <td>82</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Radja Nainggolan</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>Sub</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Roma</td>\n",
       "      <td>LF</td>\n",
       "      <td>4.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Marcelo</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>LB</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LB</td>\n",
       "      <td>12.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Left</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>83</td>\n",
       "      <td>66</td>\n",
       "      <td>67</td>\n",
       "      <td>59</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Toby Alderweireld</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>RCB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>CB</td>\n",
       "      <td>4.0</td>\n",
       "      <td>85</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>86</td>\n",
       "      <td>66</td>\n",
       "      <td>69</td>\n",
       "      <td>60</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Sokratis</td>\n",
       "      <td>Greece</td>\n",
       "      <td>RCB</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Bor. Dortmund</td>\n",
       "      <td>CB</td>\n",
       "      <td>25.0</td>\n",
       "      <td>85</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>79</td>\n",
       "      <td>44</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Ivan Perišić</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inter</td>\n",
       "      <td>LAM</td>\n",
       "      <td>44.0</td>\n",
       "      <td>84</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Adrien Silva</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sporting CP</td>\n",
       "      <td>CM</td>\n",
       "      <td>23.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>62</td>\n",
       "      <td>83</td>\n",
       "      <td>81</td>\n",
       "      <td>78</td>\n",
       "      <td>85</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>Sebastian Giovinco</td>\n",
       "      <td>Italy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Toronto FC</td>\n",
       "      <td>LS</td>\n",
       "      <td>10.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>48</td>\n",
       "      <td>78</td>\n",
       "      <td>80</td>\n",
       "      <td>86</td>\n",
       "      <td>75</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Anthony Modeste</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>LS</td>\n",
       "      <td>27.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>81</td>\n",
       "      <td>72</td>\n",
       "      <td>56</td>\n",
       "      <td>77</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>Jonas</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SL Benfica</td>\n",
       "      <td>LS</td>\n",
       "      <td>10.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>80</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>83</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Kévin Gameiro</td>\n",
       "      <td>France</td>\n",
       "      <td>Sub</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>LS</td>\n",
       "      <td>21.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>64</td>\n",
       "      <td>84</td>\n",
       "      <td>76</td>\n",
       "      <td>70</td>\n",
       "      <td>85</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Borja Valero</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fiorentina</td>\n",
       "      <td>RF</td>\n",
       "      <td>20.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>66</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>76</td>\n",
       "      <td>72</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>Kyle Walker</td>\n",
       "      <td>England</td>\n",
       "      <td>RB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>RWB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>82</td>\n",
       "      <td>Right</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>86</td>\n",
       "      <td>68</td>\n",
       "      <td>71</td>\n",
       "      <td>63</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Antonio Candreva</td>\n",
       "      <td>Italy</td>\n",
       "      <td>RM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Inter</td>\n",
       "      <td>RAM</td>\n",
       "      <td>87.0</td>\n",
       "      <td>81</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>73</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "      <td>71</td>\n",
       "      <td>86</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>Danny Rose</td>\n",
       "      <td>England</td>\n",
       "      <td>LB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>LWB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>81</td>\n",
       "      <td>Left</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>69</td>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5331</th>\n",
       "      <td>Teddy Chevalier</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KV Kortrijk</td>\n",
       "      <td>CF</td>\n",
       "      <td>9.0</td>\n",
       "      <td>70</td>\n",
       "      <td>Right</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>66</td>\n",
       "      <td>74</td>\n",
       "      <td>72</td>\n",
       "      <td>57</td>\n",
       "      <td>65</td>\n",
       "      <td>16</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>34 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Name  Nationality National_Position  National_Kit  \\\n",
       "0      Cristiano Ronaldo     Portugal                LS           7.0   \n",
       "1           Lionel Messi    Argentina                RW          10.0   \n",
       "3            Luis Suárez      Uruguay                LS           9.0   \n",
       "4           Manuel Neuer      Germany                GK           1.0   \n",
       "12           Luka Modrić      Croatia               NaN           NaN   \n",
       "13            Mesut Özil      Germany               CAM          10.0   \n",
       "15          Thiago Silva       Brazil               Sub          14.0   \n",
       "16          Sergio Ramos        Spain               LCB          15.0   \n",
       "18            Paul Pogba       France               NaN           NaN   \n",
       "19     Antoine Griezmann       France               CAM           7.0   \n",
       "23            Toni Kroos      Germany               LDM           8.0   \n",
       "28          Philipp Lahm      Germany               NaN           NaN   \n",
       "29                  Pepe     Portugal               RCB           3.0   \n",
       "32               Iniesta        Spain               LCM           6.0   \n",
       "37          Arturo Vidal        Chile               CDM           8.0   \n",
       "42          Arjen Robben  Netherlands                RW          11.0   \n",
       "45           David Alaba      Austria                LM           8.0   \n",
       "49       Sergio Busquets        Spain               CDM           5.0   \n",
       "50                Thiago        Spain               Sub          10.0   \n",
       "56      Radja Nainggolan      Belgium               Sub          16.0   \n",
       "57               Marcelo       Brazil                LB          16.0   \n",
       "71     Toby Alderweireld      Belgium               RCB           2.0   \n",
       "78              Sokratis       Greece               RCB          19.0   \n",
       "105         Ivan Perišić      Croatia               NaN           NaN   \n",
       "157         Adrien Silva     Portugal               NaN           NaN   \n",
       "159   Sebastian Giovinco        Italy               NaN           NaN   \n",
       "160      Anthony Modeste       France               NaN           NaN   \n",
       "166                Jonas       Brazil               NaN           NaN   \n",
       "167        Kévin Gameiro       France               Sub          10.0   \n",
       "181         Borja Valero        Spain               NaN           NaN   \n",
       "236          Kyle Walker      England                RB           2.0   \n",
       "355     Antonio Candreva        Italy                RM           6.0   \n",
       "361           Danny Rose      England                LB           3.0   \n",
       "5331     Teddy Chevalier       France               NaN           NaN   \n",
       "\n",
       "                 Club Club_Position  Club_Kit  Rating Preffered_Foot  Age  \\\n",
       "0         Real Madrid            LW       7.0      94          Right   32   \n",
       "1        FC Barcelona            RW      10.0      93           Left   29   \n",
       "3        FC Barcelona            ST       9.0      92          Right   30   \n",
       "4           FC Bayern            GK       1.0      92          Right   31   \n",
       "12        Real Madrid           RCM      19.0      89          Right   31   \n",
       "13            Arsenal           CAM      11.0      89           Left   28   \n",
       "15                PSG           LCB       2.0      89          Right   32   \n",
       "16        Real Madrid           LCB       4.0      89          Right   31   \n",
       "18     Manchester Utd           LCM       6.0      88          Right   24   \n",
       "19    Atlético Madrid            RS       7.0      88           Left   26   \n",
       "23        Real Madrid           LCM       8.0      88          Right   27   \n",
       "28          FC Bayern            RB      21.0      88          Right   33   \n",
       "29        Real Madrid           RCB       3.0      88          Right   34   \n",
       "32       FC Barcelona            LM       8.0      88          Right   32   \n",
       "37          FC Bayern           LDM      23.0      87          Right   29   \n",
       "42          FC Bayern            RM      10.0      87           Left   33   \n",
       "45          FC Bayern            LB      27.0      86           Left   24   \n",
       "49       FC Barcelona           CDM       5.0      86          Right   28   \n",
       "50          FC Bayern           RDM       6.0      86          Right   25   \n",
       "56               Roma            LF       4.0      86          Right   28   \n",
       "57        Real Madrid            LB      12.0      86           Left   28   \n",
       "71              Spurs            CB       4.0      85          Right   28   \n",
       "78      Bor. Dortmund            CB      25.0      85          Right   28   \n",
       "105             Inter           LAM      44.0      84          Right   28   \n",
       "157       Sporting CP            CM      23.0      83          Right   28   \n",
       "159        Toronto FC            LS      10.0      83          Right   30   \n",
       "160        1. FC Köln            LS      27.0      83          Right   28   \n",
       "166        SL Benfica            LS      10.0      83          Right   32   \n",
       "167   Atlético Madrid            LS      21.0      83          Right   29   \n",
       "181        Fiorentina            RF      20.0      83          Right   32   \n",
       "236             Spurs           RWB       2.0      82          Right   26   \n",
       "355             Inter           RAM      87.0      81          Right   30   \n",
       "361             Spurs           LWB       3.0      81           Left   26   \n",
       "5331      KV Kortrijk            CF       9.0      70          Right   29   \n",
       "\n",
       "         ...      Strength  Shot_Power  Long_Shots  Freekick_Accuracy  \\\n",
       "0        ...            80          92          90                 76   \n",
       "1        ...            59          85          88                 90   \n",
       "3        ...            76          87          86                 84   \n",
       "4        ...            83          25          16                 11   \n",
       "12       ...            58          73          82                 77   \n",
       "13       ...            56          70          76                 79   \n",
       "15       ...            81          78          71                 73   \n",
       "16       ...            81          79          55                 67   \n",
       "18       ...            91          90          88                 82   \n",
       "19       ...            61          81          82                 75   \n",
       "23       ...            74          87          88                 84   \n",
       "28       ...            59          57          65                 59   \n",
       "29       ...            84          63          56                 47   \n",
       "32       ...            59          65          74                 70   \n",
       "37       ...            79          84          85                 68   \n",
       "42       ...            65          86          88                 83   \n",
       "45       ...            69          83          83                 83   \n",
       "49       ...            77          61          54                 68   \n",
       "50       ...            59          75          82                 77   \n",
       "56       ...            78          84          86                 68   \n",
       "57       ...            77          83          66                 67   \n",
       "71       ...            81          86          66                 69   \n",
       "78       ...            86          79          44                 35   \n",
       "105      ...            77          83          80                 76   \n",
       "157      ...            62          83          81                 78   \n",
       "159      ...            48          78          80                 86   \n",
       "160      ...            86          81          72                 56   \n",
       "166      ...            61          80          84                 77   \n",
       "167      ...            64          84          76                 70   \n",
       "181      ...            66          72          70                 76   \n",
       "236      ...            77          86          68                 71   \n",
       "355      ...            73          87          87                 71   \n",
       "361      ...            72          72          69                 57   \n",
       "5331     ...            66          74          72                 57   \n",
       "\n",
       "      Penalties  GK_Positioning  GK_Diving  GK_Kicking  GK_Handling  \\\n",
       "0            85              14          7          15           11   \n",
       "1            74              14          6          15           11   \n",
       "3            85              33         27          31           25   \n",
       "4            47              91         89          95           90   \n",
       "12           80              14         13           7            9   \n",
       "13           67               6          6          10           14   \n",
       "15           71               9          9           5           12   \n",
       "16           68               7         11           9            8   \n",
       "18           76               4          5           2            6   \n",
       "19           71              13         14          14            8   \n",
       "23           73               7         10          13           11   \n",
       "28           69              14         11           5           12   \n",
       "29           57               9          8           5           15   \n",
       "32           71              13          6           6           13   \n",
       "37           84               2          4           4            2   \n",
       "42           80               5         10          11            8   \n",
       "45           80              15          5          14            7   \n",
       "49           60               9          5          13            8   \n",
       "50           75               9          6           7           11   \n",
       "56           63               8         11          14           11   \n",
       "57           59               5         12           5            5   \n",
       "71           60              16         16          14            6   \n",
       "78           38              12          6           5            8   \n",
       "105          76               9          6          10            7   \n",
       "157          85              10         15           8            6   \n",
       "159          75               3          6           6            3   \n",
       "160          77               6         10          11           11   \n",
       "166          83               8         12           7           11   \n",
       "167          85               8          6           8           10   \n",
       "181          72               8          5          10            4   \n",
       "236          63              15         12          16            6   \n",
       "355          86               4         10          14            4   \n",
       "361          57              13         10           8           11   \n",
       "5331         65              16          7          16            8   \n",
       "\n",
       "      GK_Reflexes  \n",
       "0              11  \n",
       "1               8  \n",
       "3              37  \n",
       "4              89  \n",
       "12              9  \n",
       "13             14  \n",
       "15             10  \n",
       "16             11  \n",
       "18              3  \n",
       "19             14  \n",
       "23             10  \n",
       "28              5  \n",
       "29             10  \n",
       "32              7  \n",
       "37              4  \n",
       "42             15  \n",
       "45              9  \n",
       "49             13  \n",
       "50             13  \n",
       "56             11  \n",
       "57              9  \n",
       "71             14  \n",
       "78              5  \n",
       "105             6  \n",
       "157             7  \n",
       "159             3  \n",
       "160             8  \n",
       "166             5  \n",
       "167             6  \n",
       "181             7  \n",
       "236             8  \n",
       "355            14  \n",
       "361            13  \n",
       "5331           15  \n",
       "\n",
       "[34 rows x 30 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#df = df.drop_duplicates(subset='Club_Position', keep=\"first\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# categories\n",
    "attackers = ['LW', 'RW', 'ST', 'RS', 'LS', 'LF', 'CF', 'RF']\n",
    "midfielders = ['CM', 'RCM', 'LCM', 'CAM','LAM', 'RAM', 'LM', 'RM', 'CDM', 'RDM', 'LDM']\n",
    "defenders = ['LCB', 'CB', 'RCB', 'LB', 'RDM', 'RB', 'RWB', 'LWB']\n",
    "goalkeeper = ['GK']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Preffered_Foot</th>\n",
       "      <th>Age</th>\n",
       "      <th>...</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Shot_Power</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>LS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LW</td>\n",
       "      <td>7.0</td>\n",
       "      <td>94</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>80</td>\n",
       "      <td>92</td>\n",
       "      <td>90</td>\n",
       "      <td>76</td>\n",
       "      <td>85</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>RW</td>\n",
       "      <td>10.0</td>\n",
       "      <td>93</td>\n",
       "      <td>Left</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>90</td>\n",
       "      <td>74</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Luis Suárez</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>LS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>92</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>76</td>\n",
       "      <td>87</td>\n",
       "      <td>86</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>33</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Antoine Griezmann</td>\n",
       "      <td>France</td>\n",
       "      <td>CAM</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>RS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Left</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "      <td>75</td>\n",
       "      <td>71</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Radja Nainggolan</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>Sub</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Roma</td>\n",
       "      <td>LF</td>\n",
       "      <td>4.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>Sebastian Giovinco</td>\n",
       "      <td>Italy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Toronto FC</td>\n",
       "      <td>LS</td>\n",
       "      <td>10.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>48</td>\n",
       "      <td>78</td>\n",
       "      <td>80</td>\n",
       "      <td>86</td>\n",
       "      <td>75</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Anthony Modeste</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1. FC Köln</td>\n",
       "      <td>LS</td>\n",
       "      <td>27.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>81</td>\n",
       "      <td>72</td>\n",
       "      <td>56</td>\n",
       "      <td>77</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>Jonas</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SL Benfica</td>\n",
       "      <td>LS</td>\n",
       "      <td>10.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>80</td>\n",
       "      <td>84</td>\n",
       "      <td>77</td>\n",
       "      <td>83</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Kévin Gameiro</td>\n",
       "      <td>France</td>\n",
       "      <td>Sub</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>LS</td>\n",
       "      <td>21.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>64</td>\n",
       "      <td>84</td>\n",
       "      <td>76</td>\n",
       "      <td>70</td>\n",
       "      <td>85</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Borja Valero</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fiorentina</td>\n",
       "      <td>RF</td>\n",
       "      <td>20.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>66</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>76</td>\n",
       "      <td>72</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5331</th>\n",
       "      <td>Teddy Chevalier</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KV Kortrijk</td>\n",
       "      <td>CF</td>\n",
       "      <td>9.0</td>\n",
       "      <td>70</td>\n",
       "      <td>Right</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>66</td>\n",
       "      <td>74</td>\n",
       "      <td>72</td>\n",
       "      <td>57</td>\n",
       "      <td>65</td>\n",
       "      <td>16</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Name Nationality National_Position  National_Kit  \\\n",
       "0      Cristiano Ronaldo    Portugal                LS           7.0   \n",
       "1           Lionel Messi   Argentina                RW          10.0   \n",
       "3            Luis Suárez     Uruguay                LS           9.0   \n",
       "19     Antoine Griezmann      France               CAM           7.0   \n",
       "56      Radja Nainggolan     Belgium               Sub          16.0   \n",
       "159   Sebastian Giovinco       Italy               NaN           NaN   \n",
       "160      Anthony Modeste      France               NaN           NaN   \n",
       "166                Jonas      Brazil               NaN           NaN   \n",
       "167        Kévin Gameiro      France               Sub          10.0   \n",
       "181         Borja Valero       Spain               NaN           NaN   \n",
       "5331     Teddy Chevalier      France               NaN           NaN   \n",
       "\n",
       "                 Club Club_Position  Club_Kit  Rating Preffered_Foot  Age  \\\n",
       "0         Real Madrid            LW       7.0      94          Right   32   \n",
       "1        FC Barcelona            RW      10.0      93           Left   29   \n",
       "3        FC Barcelona            ST       9.0      92          Right   30   \n",
       "19    Atlético Madrid            RS       7.0      88           Left   26   \n",
       "56               Roma            LF       4.0      86          Right   28   \n",
       "159        Toronto FC            LS      10.0      83          Right   30   \n",
       "160        1. FC Köln            LS      27.0      83          Right   28   \n",
       "166        SL Benfica            LS      10.0      83          Right   32   \n",
       "167   Atlético Madrid            LS      21.0      83          Right   29   \n",
       "181        Fiorentina            RF      20.0      83          Right   32   \n",
       "5331      KV Kortrijk            CF       9.0      70          Right   29   \n",
       "\n",
       "         ...      Strength  Shot_Power  Long_Shots  Freekick_Accuracy  \\\n",
       "0        ...            80          92          90                 76   \n",
       "1        ...            59          85          88                 90   \n",
       "3        ...            76          87          86                 84   \n",
       "19       ...            61          81          82                 75   \n",
       "56       ...            78          84          86                 68   \n",
       "159      ...            48          78          80                 86   \n",
       "160      ...            86          81          72                 56   \n",
       "166      ...            61          80          84                 77   \n",
       "167      ...            64          84          76                 70   \n",
       "181      ...            66          72          70                 76   \n",
       "5331     ...            66          74          72                 57   \n",
       "\n",
       "      Penalties  GK_Positioning  GK_Diving  GK_Kicking  GK_Handling  \\\n",
       "0            85              14          7          15           11   \n",
       "1            74              14          6          15           11   \n",
       "3            85              33         27          31           25   \n",
       "19           71              13         14          14            8   \n",
       "56           63               8         11          14           11   \n",
       "159          75               3          6           6            3   \n",
       "160          77               6         10          11           11   \n",
       "166          83               8         12           7           11   \n",
       "167          85               8          6           8           10   \n",
       "181          72               8          5          10            4   \n",
       "5331         65              16          7          16            8   \n",
       "\n",
       "      GK_Reflexes  \n",
       "0              11  \n",
       "1               8  \n",
       "3              37  \n",
       "19             14  \n",
       "56             11  \n",
       "159             3  \n",
       "160             8  \n",
       "166             5  \n",
       "167             6  \n",
       "181             7  \n",
       "5331           15  \n",
       "\n",
       "[11 rows x 30 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Club_Position'].isin(attackers)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Preffered_Foot</th>\n",
       "      <th>Age</th>\n",
       "      <th>...</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Shot_Power</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Luka Modrić</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>RCM</td>\n",
       "      <td>19.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>58</td>\n",
       "      <td>73</td>\n",
       "      <td>82</td>\n",
       "      <td>77</td>\n",
       "      <td>80</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Mesut Özil</td>\n",
       "      <td>Germany</td>\n",
       "      <td>CAM</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>CAM</td>\n",
       "      <td>11.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Left</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>70</td>\n",
       "      <td>76</td>\n",
       "      <td>79</td>\n",
       "      <td>67</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Paul Pogba</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manchester Utd</td>\n",
       "      <td>LCM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>91</td>\n",
       "      <td>90</td>\n",
       "      <td>88</td>\n",
       "      <td>82</td>\n",
       "      <td>76</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Toni Kroos</td>\n",
       "      <td>Germany</td>\n",
       "      <td>LDM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LCM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>74</td>\n",
       "      <td>87</td>\n",
       "      <td>88</td>\n",
       "      <td>84</td>\n",
       "      <td>73</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Iniesta</td>\n",
       "      <td>Spain</td>\n",
       "      <td>LCM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>LM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>65</td>\n",
       "      <td>74</td>\n",
       "      <td>70</td>\n",
       "      <td>71</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Arturo Vidal</td>\n",
       "      <td>Chile</td>\n",
       "      <td>CDM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>LDM</td>\n",
       "      <td>23.0</td>\n",
       "      <td>87</td>\n",
       "      <td>Right</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>79</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>68</td>\n",
       "      <td>84</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Arjen Robben</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>RW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RM</td>\n",
       "      <td>10.0</td>\n",
       "      <td>87</td>\n",
       "      <td>Left</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>86</td>\n",
       "      <td>88</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Sergio Busquets</td>\n",
       "      <td>Spain</td>\n",
       "      <td>CDM</td>\n",
       "      <td>5.0</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>CDM</td>\n",
       "      <td>5.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>61</td>\n",
       "      <td>54</td>\n",
       "      <td>68</td>\n",
       "      <td>60</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Thiago</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Sub</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RDM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Right</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>75</td>\n",
       "      <td>82</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Ivan Perišić</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inter</td>\n",
       "      <td>LAM</td>\n",
       "      <td>44.0</td>\n",
       "      <td>84</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Adrien Silva</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sporting CP</td>\n",
       "      <td>CM</td>\n",
       "      <td>23.0</td>\n",
       "      <td>83</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>62</td>\n",
       "      <td>83</td>\n",
       "      <td>81</td>\n",
       "      <td>78</td>\n",
       "      <td>85</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Antonio Candreva</td>\n",
       "      <td>Italy</td>\n",
       "      <td>RM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Inter</td>\n",
       "      <td>RAM</td>\n",
       "      <td>87.0</td>\n",
       "      <td>81</td>\n",
       "      <td>Right</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>73</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "      <td>71</td>\n",
       "      <td>86</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Name  Nationality National_Position  National_Kit  \\\n",
       "12        Luka Modrić      Croatia               NaN           NaN   \n",
       "13         Mesut Özil      Germany               CAM          10.0   \n",
       "18         Paul Pogba       France               NaN           NaN   \n",
       "23         Toni Kroos      Germany               LDM           8.0   \n",
       "32            Iniesta        Spain               LCM           6.0   \n",
       "37       Arturo Vidal        Chile               CDM           8.0   \n",
       "42       Arjen Robben  Netherlands                RW          11.0   \n",
       "49    Sergio Busquets        Spain               CDM           5.0   \n",
       "50             Thiago        Spain               Sub          10.0   \n",
       "105      Ivan Perišić      Croatia               NaN           NaN   \n",
       "157      Adrien Silva     Portugal               NaN           NaN   \n",
       "355  Antonio Candreva        Italy                RM           6.0   \n",
       "\n",
       "               Club Club_Position  Club_Kit  Rating Preffered_Foot  Age  \\\n",
       "12      Real Madrid           RCM      19.0      89          Right   31   \n",
       "13          Arsenal           CAM      11.0      89           Left   28   \n",
       "18   Manchester Utd           LCM       6.0      88          Right   24   \n",
       "23      Real Madrid           LCM       8.0      88          Right   27   \n",
       "32     FC Barcelona            LM       8.0      88          Right   32   \n",
       "37        FC Bayern           LDM      23.0      87          Right   29   \n",
       "42        FC Bayern            RM      10.0      87           Left   33   \n",
       "49     FC Barcelona           CDM       5.0      86          Right   28   \n",
       "50        FC Bayern           RDM       6.0      86          Right   25   \n",
       "105           Inter           LAM      44.0      84          Right   28   \n",
       "157     Sporting CP            CM      23.0      83          Right   28   \n",
       "355           Inter           RAM      87.0      81          Right   30   \n",
       "\n",
       "        ...      Strength  Shot_Power  Long_Shots  Freekick_Accuracy  \\\n",
       "12      ...            58          73          82                 77   \n",
       "13      ...            56          70          76                 79   \n",
       "18      ...            91          90          88                 82   \n",
       "23      ...            74          87          88                 84   \n",
       "32      ...            59          65          74                 70   \n",
       "37      ...            79          84          85                 68   \n",
       "42      ...            65          86          88                 83   \n",
       "49      ...            77          61          54                 68   \n",
       "50      ...            59          75          82                 77   \n",
       "105     ...            77          83          80                 76   \n",
       "157     ...            62          83          81                 78   \n",
       "355     ...            73          87          87                 71   \n",
       "\n",
       "     Penalties  GK_Positioning  GK_Diving  GK_Kicking  GK_Handling  \\\n",
       "12          80              14         13           7            9   \n",
       "13          67               6          6          10           14   \n",
       "18          76               4          5           2            6   \n",
       "23          73               7         10          13           11   \n",
       "32          71              13          6           6           13   \n",
       "37          84               2          4           4            2   \n",
       "42          80               5         10          11            8   \n",
       "49          60               9          5          13            8   \n",
       "50          75               9          6           7           11   \n",
       "105         76               9          6          10            7   \n",
       "157         85              10         15           8            6   \n",
       "355         86               4         10          14            4   \n",
       "\n",
       "     GK_Reflexes  \n",
       "12             9  \n",
       "13            14  \n",
       "18             3  \n",
       "23            10  \n",
       "32             7  \n",
       "37             4  \n",
       "42            15  \n",
       "49            13  \n",
       "50            13  \n",
       "105            6  \n",
       "157            7  \n",
       "355           14  \n",
       "\n",
       "[12 rows x 30 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Club_Position'].isin(midfielders)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>National_Position</th>\n",
       "      <th>National_Kit</th>\n",
       "      <th>Club</th>\n",
       "      <th>Club_Position</th>\n",
       "      <th>Club_Kit</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Preffered_Foot</th>\n",
       "      <th>Age</th>\n",
       "      <th>...</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Shot_Power</th>\n",
       "      <th>Long_Shots</th>\n",
       "      <th>Freekick_Accuracy</th>\n",
       "      <th>Penalties</th>\n",
       "      <th>GK_Positioning</th>\n",
       "      <th>GK_Diving</th>\n",
       "      <th>GK_Kicking</th>\n",
       "      <th>GK_Handling</th>\n",
       "      <th>GK_Reflexes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Thiago Silva</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Sub</td>\n",
       "      <td>14.0</td>\n",
       "      <td>PSG</td>\n",
       "      <td>LCB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>78</td>\n",
       "      <td>71</td>\n",
       "      <td>73</td>\n",
       "      <td>71</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sergio Ramos</td>\n",
       "      <td>Spain</td>\n",
       "      <td>LCB</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LCB</td>\n",
       "      <td>4.0</td>\n",
       "      <td>89</td>\n",
       "      <td>Right</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>79</td>\n",
       "      <td>55</td>\n",
       "      <td>67</td>\n",
       "      <td>68</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Philipp Lahm</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RB</td>\n",
       "      <td>21.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>57</td>\n",
       "      <td>65</td>\n",
       "      <td>59</td>\n",
       "      <td>69</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Pepe</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>RCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>RCB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>88</td>\n",
       "      <td>Right</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>84</td>\n",
       "      <td>63</td>\n",
       "      <td>56</td>\n",
       "      <td>47</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>David Alaba</td>\n",
       "      <td>Austria</td>\n",
       "      <td>LM</td>\n",
       "      <td>8.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>LB</td>\n",
       "      <td>27.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Left</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>69</td>\n",
       "      <td>83</td>\n",
       "      <td>83</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Thiago</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Sub</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FC Bayern</td>\n",
       "      <td>RDM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Right</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>59</td>\n",
       "      <td>75</td>\n",
       "      <td>82</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Marcelo</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>LB</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>LB</td>\n",
       "      <td>12.0</td>\n",
       "      <td>86</td>\n",
       "      <td>Left</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>83</td>\n",
       "      <td>66</td>\n",
       "      <td>67</td>\n",
       "      <td>59</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Toby Alderweireld</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>RCB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>CB</td>\n",
       "      <td>4.0</td>\n",
       "      <td>85</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>86</td>\n",
       "      <td>66</td>\n",
       "      <td>69</td>\n",
       "      <td>60</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Sokratis</td>\n",
       "      <td>Greece</td>\n",
       "      <td>RCB</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Bor. Dortmund</td>\n",
       "      <td>CB</td>\n",
       "      <td>25.0</td>\n",
       "      <td>85</td>\n",
       "      <td>Right</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>86</td>\n",
       "      <td>79</td>\n",
       "      <td>44</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>Kyle Walker</td>\n",
       "      <td>England</td>\n",
       "      <td>RB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>RWB</td>\n",
       "      <td>2.0</td>\n",
       "      <td>82</td>\n",
       "      <td>Right</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>86</td>\n",
       "      <td>68</td>\n",
       "      <td>71</td>\n",
       "      <td>63</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>Danny Rose</td>\n",
       "      <td>England</td>\n",
       "      <td>LB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Spurs</td>\n",
       "      <td>LWB</td>\n",
       "      <td>3.0</td>\n",
       "      <td>81</td>\n",
       "      <td>Left</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>69</td>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Name Nationality National_Position  National_Kit  \\\n",
       "15        Thiago Silva      Brazil               Sub          14.0   \n",
       "16        Sergio Ramos       Spain               LCB          15.0   \n",
       "28        Philipp Lahm     Germany               NaN           NaN   \n",
       "29                Pepe    Portugal               RCB           3.0   \n",
       "45         David Alaba     Austria                LM           8.0   \n",
       "50              Thiago       Spain               Sub          10.0   \n",
       "57             Marcelo      Brazil                LB          16.0   \n",
       "71   Toby Alderweireld     Belgium               RCB           2.0   \n",
       "78            Sokratis      Greece               RCB          19.0   \n",
       "236        Kyle Walker     England                RB           2.0   \n",
       "361         Danny Rose     England                LB           3.0   \n",
       "\n",
       "              Club Club_Position  Club_Kit  Rating Preffered_Foot  Age  \\\n",
       "15             PSG           LCB       2.0      89          Right   32   \n",
       "16     Real Madrid           LCB       4.0      89          Right   31   \n",
       "28       FC Bayern            RB      21.0      88          Right   33   \n",
       "29     Real Madrid           RCB       3.0      88          Right   34   \n",
       "45       FC Bayern            LB      27.0      86           Left   24   \n",
       "50       FC Bayern           RDM       6.0      86          Right   25   \n",
       "57     Real Madrid            LB      12.0      86           Left   28   \n",
       "71           Spurs            CB       4.0      85          Right   28   \n",
       "78   Bor. Dortmund            CB      25.0      85          Right   28   \n",
       "236          Spurs           RWB       2.0      82          Right   26   \n",
       "361          Spurs           LWB       3.0      81           Left   26   \n",
       "\n",
       "        ...      Strength  Shot_Power  Long_Shots  Freekick_Accuracy  \\\n",
       "15      ...            81          78          71                 73   \n",
       "16      ...            81          79          55                 67   \n",
       "28      ...            59          57          65                 59   \n",
       "29      ...            84          63          56                 47   \n",
       "45      ...            69          83          83                 83   \n",
       "50      ...            59          75          82                 77   \n",
       "57      ...            77          83          66                 67   \n",
       "71      ...            81          86          66                 69   \n",
       "78      ...            86          79          44                 35   \n",
       "236     ...            77          86          68                 71   \n",
       "361     ...            72          72          69                 57   \n",
       "\n",
       "     Penalties  GK_Positioning  GK_Diving  GK_Kicking  GK_Handling  \\\n",
       "15          71               9          9           5           12   \n",
       "16          68               7         11           9            8   \n",
       "28          69              14         11           5           12   \n",
       "29          57               9          8           5           15   \n",
       "45          80              15          5          14            7   \n",
       "50          75               9          6           7           11   \n",
       "57          59               5         12           5            5   \n",
       "71          60              16         16          14            6   \n",
       "78          38              12          6           5            8   \n",
       "236         63              15         12          16            6   \n",
       "361         57              13         10           8           11   \n",
       "\n",
       "     GK_Reflexes  \n",
       "15            10  \n",
       "16            11  \n",
       "28             5  \n",
       "29            10  \n",
       "45             9  \n",
       "50            13  \n",
       "57             9  \n",
       "71            14  \n",
       "78             5  \n",
       "236            8  \n",
       "361           13  \n",
       "\n",
       "[11 rows x 30 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Club_Position'].isin(defenders)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thiago Silva</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sergio Ramos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Philipp Lahm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Luka Modrić</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mesut Özil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Paul Pogba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Toni Kroos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Lionel Messi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Luis Suárez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Manuel Neuer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 name\n",
       "0        Thiago Silva\n",
       "1        Sergio Ramos\n",
       "2        Philipp Lahm\n",
       "3         Luka Modrić\n",
       "4          Mesut Özil\n",
       "5          Paul Pogba\n",
       "6          Toni Kroos\n",
       "7   Cristiano Ronaldo\n",
       "8        Lionel Messi\n",
       "9         Luis Suárez\n",
       "10       Manuel Neuer"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def form(d,m,a):\n",
    "    fig = plt.figure()\n",
    "    fig.suptitle('formation', fontsize=14, fontweight='bold')\n",
    "\n",
    "    ax = fig.add_subplot(111)\n",
    "    for i in range(6):\n",
    "        ax.axhline(y=(i+1), color='b', linestyle='-')\n",
    "    \n",
    "    for i in range(d):\n",
    "        ax.text((i+1), 5, i, style='italic', bbox={'facecolor':'red', 'alpha':0.5, 'pad':10})\n",
    "    for i in range(m):\n",
    "        ax.text((i+1), 3, (d+i), style='italic', bbox={'facecolor':'red', 'alpha':0.5, 'pad':10})\n",
    "    for i in range(a):\n",
    "        ax.text((i+1), 1, (m+d+i), style='italic', bbox={'facecolor':'red', 'alpha':0.5, 'pad':10})\n",
    "\n",
    "    ax.text(2, 0, '10', style='italic', bbox={'facecolor':'red', 'alpha':0.5, 'pad':10})\n",
    "    ax.axis([0, 6, 0, 6])\n",
    "    ax.axis('off')\n",
    "    plt.show()\n",
    "\n",
    "def team(d,m,a):\n",
    "    l = []\n",
    "    for i in range(d):\n",
    "        l.append(df[df['Club_Position'].isin(defenders)]['Name'].iloc[i])\n",
    "    for i in range(m):\n",
    "        l.append(df[df['Club_Position'].isin(midfielders)][0:m]['Name'].iloc[i])\n",
    "    for i in range(a):\n",
    "        l.append(df[df['Club_Position'].isin(attackers)][0:a]['Name'].iloc[i])\n",
    "    l.append(df[df['Club_Position'].isin(goalkeeper)]['Name'].iloc[0])\n",
    "    return l\n",
    "\n",
    "t = team(3,4,3)\n",
    "team_df = pd.DataFrame({'name':t})\n",
    "team_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW4AAAEVCAYAAADARw+NAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAEaFJREFUeJzt3XuUnGV9wPHvs8kmIdcNkAsh2Swh\nISAXUVZBDRjEWPAgtFKRYsUAAlEQ7fFQ9KBogWJr7akGtUBVQqlWOdjK8QaxSkCsBIKhSkRCjLmw\nGHK/Z8ll3/4xs7hnTczO7jvz8pv9fs7Zs9l3Zuf5PSF88+67m5mUZRmSpDgaih5AklQZwy1JwRhu\nSQrGcEtSMIZbkoIx3JIUjOFWn6WSf0gptaWUOlJKWUrp5KLn6q2U0rzyHlYUPYu0P4ZbeTgfuB6Y\nACwHFgI7Cp2oB8pxzlJKn+52028p7WFx7aeSDm5g0QOoLhzf5devzrKsT9FOKQ3Ksmx3H2fqtSzL\nbgZuLmp96WA841afpJQWALd0ObQ9pZSVb7s0pfRkSmlXSmlHSumxlNK7unxuS5ez3r9NKX0npbQT\n+GxKaWaX2y5LKT1UfpyFKaXjUkqzUkpPp5S2pZR+kFIa3+Vx35tSejyltD6ltCeltCml9GBK6fXl\n22d2zlj2qa6XRvZ3qSSlNCCl9NGU0pKU0ksppa0ppZ+klM7qcp+uM89OKX0vpbQzpfS7lNLluf7G\nq18z3OqrXwNtXT5eCCxMKX0C+BrwWmAdsAU4Fbg3pXTVfh7nZuBMSpcp9na77cuULsM0AK8Hvgd8\nBxgADAPOAf65y/1PBU4ENgBLgEOAtwH/Uw781vKcndo4+KWRO4DPAa8CVgO7y/POTymds5/730np\nK5E9QAtwZ0rp2D/x+FLPZVnmm299egM+DWSlP04ZlGK6s3zsfkrBbQQeKR9bWz7W0vl5wDNAU/nz\nBwAzu9z2b+Xjt3Q5dkP52D3lj9d0mWc6MLTLx1O7fN7lXY53Hvt0t/3MKx9fUf54CtBRPvbF8rER\nwNLysSfLx7rOfB+QgJO6HJtT9H8r3+rjzTNuVcPxlM5yAb6VZVlHlmV7KMUMYAwwudvn3J1l2WaA\nLMv2dbvtu+X3K/ZzbHn5/dgut40C7k8pbUwpdQDPdbltQiUbKWulFGGAb5Rn3EbpzB/g5JTSgG6f\n8x9ZlmWUviLpNK4Xa0t/xG9Oqtp6+vSTa/7EbVvL7/fu51jn4yeAlNJw4EGgCWindPljD6XLJ1A6\nm++Lnu6n8y+hvSl1Nv/l+Et94hm3qmEJsKv864tSSg0ppUbgL8vH1gErq7T2dErRBrgsy7JTgI8c\n4L6dMw47yGM+yR+C/R6AlNII4Nzysaf281WCVDWGW7nLSj8OeGv5w/MoXeJYAZxePvbJLMs6qrT8\ncv7wM+RfTSn9ktI3MvfnN+X316aUnkgp3bq/O2VZ9ltK32gFuDqltAz4HTCN0rXvT+QyudRDhltV\nkWXZLcBlwC8oXdMeTeknN96dZdkdVVx3E/AuSteWGyj99Mc7DnD3a4FflX/dChzzJx76KuC68uNO\nAgYDDwFvy7Lsh32fXOq5VPr+iSQpCs+4JSkYwy1JwRhuSQrGcEtSMIZbkoIx3JIUjOGWpGAMtyQF\nY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAVTlRcLTokF1XhcSapXWcbMnt7XV8CR\npGC8VCJJwRhuSQrGcEtSMIZbkoIx3JIUjOGWpGAMtyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHc\nkhSM4ZakYAy3JAVjuCUpGMMtScFU5aXLIpqa0k1N0FyLtTbDqmVZdmMt1urk/vJRxN6k7gx3WRM0\nL4IVtVirFVpqsU5X7i8fRexN6s5LJZIUjOGWpGAMtyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHc\nvbQb0rkwayxcMwmufBAOL3qmPN0DE1vg8kFwwzXQWvQ8eboBTpwEV06AD0yGK34ChxU9k1QJw91L\nV8Abt8Iha+CLV8CjN8CZRc+Up2mw7ZtwXzO0tcKLRc+TpxbYugjmvQD/eiYs+TjMLHomqRKGuxfa\noeF70PrvML8BOAteaKuzM+7TYMtpsOUFGHsWrC16njxdASvHwW6AobBnn/8fKBj/wPbCXTB5PKxv\ngXaAjTBoGOwqeKzcLYYRg2H3JHip6FmqYRGM/AbMmAOPFz2LVAnD3Qu/hkOP7nL54DEYNwE2FjlT\nNTwCYyfW2dl2p0dg9Nvhkmth/vthZdHzSJUw3L2wBYYMLX+pDfAgHHsBLClypmpYDOOm1Nn1bYDv\nwti/gEuug/k31eF/N9U/w90Lx8H6Z+EIgNuh5fdw6NWwvOi58vYcjD2hzs6474GJl8DFn4H7r4Ol\nRc8j9UbKsiz/B00syP1Bq2wK5x/7YSa39+S+++jgLn4wZg0bG4dxSMdfM2v9GJr29nStL7ByyHLu\n/03vp61cJft7lF8Nf5DHm3bQPmAwjR0tjG+/ivPW9XStV/L+/o55R7azu2Ekw/YBNDF87wc4v8d/\nORWxN/UPWdbzn27yhRR6YQANvJ9zexyyaGZw4vYZnLi96Dmq4VPMbit6BqmvqnLGHVFrSvNq+Qox\ni7Jsdi3WenlN95fPOgXsTerOa9ySFIzhlqRgDLckBWO4JSkYwy1JwRhuSQrGcEtSMIZbkoIx3JIU\njOGWpGB8rpKyzbCqFVpqtVYt1um+pvvLZ51qryEdjM9VIknBeKlEkoIx3JIUjOGWpGAMtyQFY7gl\nKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCGW5KCMdyS\nFIzhlqRgDLckBWO4JSmYgdV40JRYUI3HlaR6lWXM7Ol9PeOWpGBSlmVFzyBJqoBn3JIUjOGWpGAM\ntyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCG\nW5KCqcpLl0U0NaWbmqC5FmtthlXLsuzGWqzVyf3lo4i9Qf3vT5Ux3GVN0LwIVtRirVZoqcU6Xbm/\nfBSxN6j//akyXiqRpGAMtyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAx3L3wSTjgS\nrpoAc8bDB++GSUXPVA0/gsOHwMcuhTcUPUue7oMjhsL1R8KcI2HOW+DcomfK2y1w3CS4cjx88AR4\nT9HzKF/+k/deuByW3QxPA3wEXnsbnPY+WF30XHlqg8EfhVnjYf0p8GLR8+TpSRhzFvziu/Cjomep\nhttgylfgTQ/DPVNg1zMwrOiZlC/PuHuhBdoBdkLDYjjyjbC84JFy1QG8E879e/jxBmiaBWuKnilP\nz8CYo2Bj0XNUy2fhrTfDA1NgF8BxsKPomZQvw90L7dAwCa4cDdcPhd1z4cmiZ8rTxXDGWbB0Cuxo\ngI7psLPomfK0AsbcC6eOg6vPg7d2FD1Qjn4OTRtg9Dfg+Ilw1clw0QoYUvRcypfh7oUh0LEa7nwC\nbnsUTlwEI4ueKS+fg2mbYOit8Ksfw/hJdXaZBOAu+P4a+PIT8NWFMH0uTC16prw8DOP2QOOF8Mzz\ncMdQeOnj8Pqi51K+vMbdByfB9mGwczUMbYWtRc+Th6/Da38HEw6FY9thcAbpQnjzvfBw0bPl5TWw\nDaAZ2ifCuo0wuOiZ8rIdGo+HZZfCKoBpsHY7DCp6LuWrKuFOiQXVeNxqmsJ5x85lcvvB7vc86xon\nMmYPwEKeGZb4xciV/NXZcyv44mUTK4fU+veop/u7tPRuE8DdPHDYMUxqfwPHHzUXjurpWq/k/W1h\ne8MohncAPMuqwat5+LBhXDhsLoNf15N1itgb9Hx/7bzYuIGHDv887569k/aG+fzXuPfytvVzGTO5\nJ+sUtT9BljGzp/f1jLtC/81PD93ItoGDGNhxGCP3XsU71jbU6RWntWwedAav3lb0HHn6IQublvL8\nIY0M7BjB0H2X8/a1hzA4K3quvDQzbs80Ju76DF+f0EBiFqds7jzRUP1IWVY3f2b7pDWlebV8hZhF\nWTa7Fmu9vKb7y2edAvYG9b8/VaY+TxUlqY4ZbkkKxnBLUjCGW5KCMdySFIzhlqRgDLckBWO4JSkY\nwy1JwRhuSQrG5yop2wyrWqGlVmvVYp3ua7q/fNap9hoHWree96fK+FwlkhSMl0okKRjDLUnBGG5J\nCsZwS1IwhluSgjHckhSM4ZakYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCGW5KCMdySFIzhlqRgDLck\nBWO4JSkYwy1JwRhuSQrGcEtSMIZbkoIZWI0HTYkF1XhcSapXWcbMnt7XM25JCiZlWVb0DJKkCnjG\nLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCGW5KCMdySFIzh\nlqRgDLckBWO4JSkYwy1JwVTlNScjmprSTU3QXIu1NsOqZVl2Yy3W6uT+8lHE3qTuDHdZEzQvghW1\nWKsVWmqxTlfuLx9F7E3qzkslkhSM4ZakYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCGW5KC8R/g9NKp\ncMHzMAZgDwzcAIc+DLfNgE1Fz5aHp2DEJXDuBhi5DwZ8DOZ/BJYVPVceHodRs+EdW2D4SNjxHfj2\ndNhZ9FxST3nG3UsL4dttcHsb3P5meHoGLK6XaANcAX/2ZljaBnd8Fe67Fc4ueqa8XAQXzIGft8Ht\nM2Dp38CMomeSKmG4++iXMPyH0HobPFT0LHnaBw2j4CWAR+CI0bC16Jny8BSMaIfB18JvAY6CLStg\nbMFjSRXxUkkffQjOfDssOgm2Fz1Lni6FRdfBhZ+Hc8bD+m/Bt4ueKQ97IW2F4cvhkEbo+Bq8YRTs\nKHouqRKGuw8egDH/B1OfhS8VPUue7oLmL8AZS+HzjdBxJly0AwYUPVceWmHrBfC/b4LZh8OWYbDr\nGFhT9FxSJQx3H1wHs94HD4+D3UXPkqe74OR3w5PN0A4wATbeD5PPqJNr+HfDz4Cf7YV0JHzwH+HH\nRc8kVcJr3L10O7Ssg6Z/gsVFz5K3UbBrSfm679Mw/CmYOhNeKHisXDwHQzvKv74YzpgOq8+GdYUO\nJVUoZVmW/4MmFuT+oFU2hfOP/TCT23ty34yMz/KfR5zNqZtfzdG7Kl3rC6wcspz7f1P5lL1Xyf62\nsbNhHg+M2crOAQ0kzuQ1W07jVT2+DvxK3t9P+eXwh1g8agAN2TFM2vXnzNjUWMEXnkXsTf1DljGz\np/f1UkkvJBLXc/Hvi56jWkYwtONDvPPFoueohtM5afvpnFRX30hW/1OVM+6IWlOaV8tXiFmUZbNr\nsdbLa7q/fNYpYG9Sd17jlqRgDLckBWO4JSkYwy1JwRhuSQrGcEtSMIZbkoIx3JIUjOGWpGAMtyQF\n43OVlG2GVa3QUqu1arFO9zXdXz7rVHsN6WB8rhJJCsZLJZIUjOGWpGAMtyQFY7glKRh/qqSfmJrS\nTU3QXOQMm2HVsiy7scgZpHpguPuJJmiu1SvgHEitfhxRqndeKpGkYAy3JAVjuCUpGMMtScEYbkkK\nxnBLUjCGW5KCMdySFIzh1n7dAxNb4PJBcMM10Np5fC4cPQHmjIOrr4RTCxxR6rcMt/ZrGmz7JtzX\nDG2t8CLAz6DpFjjn+/D1JXDnvfDGFTCk4FGlfsd/8q79Og22ALwAY8+CtQCfgdddCI+9BrYBHA6b\nnoDRLfD7AkeV+h3PuHVAi2HEYNg9CV4CeBRO+AA803n7SzBoAuwqbkKpfzLcOqBHYOzE8tn2Vhiw\nDwYcDzsA2qFhA4w+BbYWO6XU/xhuHdBiGDelfH17NQwZBLs7b/sSHH0CLBsCHcVNKPVPhlsH9ByM\nPaF8xj0ddu6BxmdhaBsM/hd4y4fhsaJnlPojvzmpP/JROPkr8JadMPQpmPYDeNVi+NY1MP90uKwB\nOmbDo++BtqJnlfqjlGVZ0TOoBlpTmvdKeCGFRVk2u8gZpHrgpRJJCsZwS1IwhluSgjHckhSM4Zak\nYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCGW5KC8Umm+onNsKoVWoqeocj1pXrhk0xJUjBeKpGkYAy3\nJAVjuCUpGMMtScEYbkkKxnBLUjCGW5KCMdySFIzhlqRgDLckBfP/Z1+mXuRmdSwAAAAASUVORK5C\nYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x98b0518>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "form(3,4,3)   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thiago Silva</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sergio Ramos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Philipp Lahm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pepe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>David Alaba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Luka Modrić</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mesut Özil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Paul Pogba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Lionel Messi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Manuel Neuer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 name\n",
       "0        Thiago Silva\n",
       "1        Sergio Ramos\n",
       "2        Philipp Lahm\n",
       "3                Pepe\n",
       "4         David Alaba\n",
       "5         Luka Modrić\n",
       "6          Mesut Özil\n",
       "7          Paul Pogba\n",
       "8   Cristiano Ronaldo\n",
       "9        Lionel Messi\n",
       "10       Manuel Neuer"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t = team(5,3,2)\n",
    "tdf = pd.DataFrame({'name':t})\n",
    "tdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW4AAAEVCAYAAADARw+NAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAEaZJREFUeJzt3XuQnWV9wPHvs5sbuW6QXAjJZomJ\nAbkUZRXEAEGMFUXoKCLVSgPIRUG041B1ULRAsVo71WAtUJVYiiMMOlARBKsECkogGIoiGkJIAsEQ\ncr8uuezTP85Z3ImJOdm857z8dr+fmZ3svufseX4PJN+8++7mnJRzRpIUR1PZA0iS9o7hlqRgDLck\nBWO4JSkYwy1JwRhuSQrGcGufpYp/SiktSyl1ppRySumosufqqZTS7OoeFpc9i7QrhltFOB34NDAO\nWATMBTaVOlENqnHOKaUv7nTTM1T2ML/xU0l71q/sAdQrHNbt/b/IOe9TtFNKA3LOW/dxph7LOV8F\nXFXW+tKeeMatfZJSmgNc3e3QxpRSrt52TkrpsZTSlpTSppTSwyml93f73LZuZ71/n1K6PaW0GfhK\nSml6t9vOTSndV32cuSmlQ1NKM1JKv0kpbUgp3ZVSGtvtcT+cUnokpbQypbQtpbQmpXRPSunN1dun\nd81Y9YXul0Z2dakkpdScUvpUSunJlNLLKaX1KaWfp5RO7naf7jPPTCndmVLanFJ6NqV0XqH/4dWn\nGW7tq98Cy7p9PBeYm1L6HPAd4I3AS8A64Bjg1pTShbt4nKuAk6hcpti+023fpHIZpgl4M3AncDvQ\nDAwBTgH+pdv9jwGOAFYBTwL7Ae8A/qca+PXVObssY8+XRq4Hvgq8HngO2Fqd996U0im7uP8NVL4S\n2Qa0ATeklA75M48v1S7n7Jtv+/QGfBHIld9OGSox3Vw9dgeV4PYHHqgeW1E91tb1ecBTQEv185uB\n6d1u+4/q8au7Hbu8euym6sfLu80zFRjc7ePJ3T7vvG7Hu459caf9zK4eX1z9eBLQWT32jeqxYcCC\n6rHHqse6z3wbkIAjux27qOz/V771jjfPuFUPh1E5ywW4JefcmXPeRiVmAKOAiTt9zndzzmsBcs47\ndrrtR9VfF+/i2KLqr6O73TYCuCOltDql1Ak83e22cXuzkap2KhEG+F51xg1UzvwBjkopNe/0Of+V\nc85UviLpMqYHa0t/wm9Oqt5qffrJ5X/mtvXVX7fv4ljX4yeAlNJQ4B6gBeigcvljG5XLJ1A5m98X\nte6n6y+h7Sl1Nf+V+Ev7xDNu1cOTwJbq+2ellJpSSv2BM6rHXgKW1GntqVSiDXBuzvlo4JO7uW/X\njEP28JiP8cdgfwggpTQMOLV67PFdfJUg1Y3hVuFy5ccBr6l+eBqVSxyLgeOrxz6fc+6s0/KL+OPP\nkH87pfQElW9k7srvqr9emlJ6NKV0za7ulHN+hso3WgEuTiktBJ4FplC59v25QiaXamS4VRc556uB\nc4FfUbmmPZLKT258IOd8fR3XXQO8n8q15SYqP/3xnt3c/VLg19X324HX/ZmHvhC4rPq4E4CBwH3A\nO3LOd+/75FLtUuX7J5KkKDzjlqRgDLckBWO4JSkYwy1JwRhuSQrGcEtSMIZbkoIx3JIUjOGWpGAM\ntyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhRMXV4sOCXm1ONxJam3ypnptd7XV8CRpGC8VCJJ\nwRhuSQrGcEtSMIZbkoIx3JIUjOGWpGAMtyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4Zak\nYAy3JAVjuCUpGMMtScHU5aXLIpqc0pUt0NqItdbC0oU5X9GItbq4v2KUsTdwf0Upa39FM9xVLdA6\nDxY3Yq12aGvEOt25v2KUsTdwf0Upa39F81KJJAVjuCUpGMMtScEYbkkKxnBLUjCGW5KCMdySFIzh\nlqRgDHcPbYV0KswYDZdMgAvugQPKnqlIN8H4NjhvAFx+CbSXPU+RLocjJsAF4+CjE+H8n8Nryp6p\nSJ+Hww+CC8fBRWPhY9+FCWXPVA8/hQMGwWfOgbeUPUujGe4eOh+OWw/7LYdvnA8PXg4nlT1TkabA\nhu/Dba2wrB1eLHueIrXB+nkw+wX495Pgyc/C9LJnKtJ5sHAZXP8CXHcWPHwtHFv2TEVbBgM/BTPG\nwsqje9nvz1oY7h7ogKY7of0/4d4m4GR4YVkvO+M+FtYdC+tegNEnw4qy5ynS+bBkDGwFGAzbdvSy\nPwdt0AGwGZrmw0HHwaKSRypUJ/BeOPUf4WeroGUGLC97pkbrVb9hG+VGmDgWVrZV/4CshgFDYEvJ\nYxVuPgwbCFsnwMtlz1IP82D492DaRfBI2bMUqQOaJsAFI+HTg2HrLHis7JmK9EE44WRYMAk2NUHn\nVNhc9kyNZrh74Lew/2u7fXn2MIwZB6vLnKkeHoDR43vZ2XaXB2Dku+DsS+Hej8CSsucp0iDofA5u\neBSufRCOmAfDy56pKF+FKWtg8DXw65/B2Al98DIJ+OyAPbIOBg2ufqkNcA8c8mH4VZkz1cN8GDOp\nF/7B+BGMngl//Rm4+zJYUPY89XIkbBwCm5+Dwe2wvux5inAzvPFZGLc/HNIBAzOkM+HEW+H+smdr\nJMPdA4fCylvhKIDroO0PsP/Fvew6IsDTMHo6PFP2HEW6CcZfCmd8GW6/oEFPc9tIP4bR765+lfR5\nOLwZdry7F/3lOx9u6Xp/Gpx+PDz7JXiizJnKkHLOxT9oYk7hD1pnkzj9kE8wsaOW++6gkxu5a9Ry\nVvcfwn6df8OMlaNo2V7rWl9nyaBF3PG7nk+79/Zmfw/y66H38EjLJjqaB9K/s42xHRdy2ku1rvVq\n3t8/MPugDrY2DWfIDoAWhm7/KKfXfDmojL1B7fu7lh+OWc2GfgPo1/kahm8/gxNX78/wHbWu82rf\nX3f/zPcPPIMTVx3MgVv3fO+KsvZXi5xr/+kmz7h7oJkmPsKpNYcsmmkcsXEaR2wse456+AIzl5U9\nQz19nPf2mrPrPbmMs/5Q9gxlqcsZd0TtKc1u5CvEzMt5ZiPWemVN91fMOiXsDdxfYeuUtL+i+VMl\nkhSM4ZakYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCGW5KCMdySFIzhlqRgfK6SqrWwtB3aGrVWI9bZ\neU33V8w69V5jd+u6v2LWqfcajeBzlUhSMF4qkaRgDLckBWO4JSkYwy1JwRhuSQrGcEtSMIZbkoIx\n3JIUjOGWpGAMtyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAVjuCUpGMMtScEY\nbkkKpl89HjQl5tTjcSWpt8qZ6bXe1zNuSQom5ZzLnkGStBc845akYAy3JAVjuCUpGMMtScEYbkkK\nxnBLUjCGW5KCMdySFIzhlqRgDLckBWO4JSkYwy1JwRhuSQrGcEtSMIZbkoIx3JIUTF1euiyiySld\n2QKtjVhrLSxdmPMVjViri/srRhl7k3ZmuKtaoHUeLG7EWu3Q1oh1unN/xShjb9LOvFQiScEYbkkK\nxnBLUjCGW5KCMdySFIzhlqRgDLckBWO4JSkYwy1JwfgvJ3voNjjwbDh7JKwDmArP/xzuLHuuIl0N\nh14Px2+DfgfAut/AzWXPVJRj4H3PwyiAbdBvFex/P1w7DdaUPZu0J4a7hx6DUSfDr34EPy17lnq4\nFiZ9C956P9w0CbY8BUPKnqlIc+EHXe+/H6avgGFGW1EY7h56CkYdDKvLnqNevgJvvwbumgRbAA6F\nTWXPVA9PwNC7of0XcF3Zs0i18hp3Dy2GUbfCMWPg4tPg7Z1lD1SgX0LLKhj5PThsPFx4FJy1GAaV\nPVc9fBxOehfMOxI2lj2LVCvD3UM3wo+XwzcfhW/PhamzYHLZMxXlfhizDfqfCU89D9cPhpc/C28u\ne66i/QRG/R9MvhZ+UfYs0t4w3D30BtgA0Aod4+Gl1TCw7JmKshH6HwYLz4GlAFNgxVZoLnuuol0G\nM/4W7h8DW8ueRdobdbnGnRJz6vG49TSJ0w6ZxcSOWu67jo1NIxjaCfB7lg58jvtfM4Qzh8xi4Jtq\n+fw1LBnU6P9Ge7O/Dl7sv4r7DvgaH5i5mY6me/nhmA/zjpWzGDWxls9/te8P4CmWDFrBA/sfzIcG\nzKLpyFo/r4y9qW/Imem13tdvTvbA3cxtWcDz+/WnX+cwBu84j3et2I+Buey5itLKmG1TGL/lS9w8\nronEDI5eO55R28qeqyiZzH/z0MhTOW5Nk190KqCUc6/pzT5pT2l2I18hZl7OMxux1itrur9i1ilh\nb9LOPN2QpGAMtyQFY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAXjc5VUrYWl7dDW\nqLUasc7Oa7q/Ytap9xrSnvhcJZIUjJdKJCkYwy1JwRhuSQrGcEtSMIZbkoIx3JIUjOGWpGAMtyQF\nY7glKRjDLUnBGG5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAVjuCUpGMMtScEYbkkKxnBLUjCGW5KC\n6VePB02JOfV4XEnqrXJmeq339YxbkoJJOeeyZ5Ak7QXPuCUpGMMtScEYbkkKxnBLUjCGW5KCMdyS\nFIzhlqRgDLckBWO4JSkYwy1JwRhuSQrGcEtSMIZbkoIx3JIUjOGWpGAMtyQFY7glKZi6vOZkRJNT\nurIFWhux1lpYujDnKxqxVpfevj+pLzHcVS3QOg8WN2KtdmhrxDrd9fb9SX2Jl0okKRjDLUnBGG5J\nCsZwS1IwhluSgjHckhSM4ZakYAy3JAXjP8Dpocdh2Nlw6ioYvgOaPwP3fhIWlj1XUR6BETPhPetg\n6HDYdDv8YCpsLnsuSZ5x99j58JcnwoJlcP234bZr4J1lz1Sks+B9F8Evl8F102DB38G0smeSVGG4\ne2gHNI2AlwEegANHwvqyZyrK4zCsAwZeCs8AHAzrFsPokseSVOWlkh46B+ZdBmd+DU4ZCytvgR+U\nPVNRtkNaD0MXwX79ofM78JYRsKnsuSRVGO4euBFavw4nLICv9YfOk+CsTdBc9lxFaYf174NfvBVm\nHgDrhsCW18HysueSVGG4e+BGOOoD8FgrdACMg9V3wMQTYE3ZsxXlu/AQ8NB2SAfBx74MPyt7JkkV\nXuPugRGw5cnqNd/fwNDHYfJ0eKHksQrzNAzurL7/QThhKjz3Tnip1KEkvSLlnIt/0MScwh+0ziZx\n+iGfYGJHLffdwOam2fxk1Ho2NzeROIk3rDuW19d8DfjrLBm0iDt+1/Np997e7O9/eWLofcwf0UxT\nfh0TtvwV09b034svzsrYnxRdzkyv9b5eKumBYQzu/DjvfbHsOerleI7ceDxHbix7Dkm7Vpcz7oja\nU5rdyFeImZfzzEas9cqavXx/Ul/iNW5JCsZwS1IwhluSgjHckhSM4ZakYAy3JAVjuCUpGMMtScEY\nbkkKxnBLUjA+V0nVWljaDm2NWqsR6+y8Zm/en9SX+FwlkhSMl0okKRjDLUnBGG5JCsZwS1Iw/lRJ\nHzE5pStboLXMGdbC0oU5X1HmDFJvYLj7iBZobdQr4OxOo34cUertvFQiScEYbkkKxnBLUjCGW5KC\nMdySFIzhlqRgDLckBWO4JSkYw61dugnGt8F5A+DyS6C96/gseO04uGgMXHwBHFPiiFKfZbi1S1Ng\nw/fhtlZY1g4vAjwELVfDKT+Gm5+EG26F4xbDoJJHlfoc/8m7dulYWAfwAow+GVYAfAnedCY8/AbY\nAHAArHkURrbBH0ocVepzPOPWbs2HYQNh6wR4GeBBOPyj8FTX7S/DgHGwpbwJpb7JcGu3HoDR46tn\n2+uheQc0HwabADqgaRWMPBrWlzul1PcYbu3WfBgzqXp9+zkYNAC2dt32b/Daw2HhIOgsb0KpbzLc\n2q2nYfTh1TPuqbB5G/T/PQxeBgP/Fd72CXi47BmlvshvTupPfAqO+ha8bTMMfhym3AWvnw+3XAL3\nHg/nNkHnTHjwQ7Cs7FmlvijlnMueQQ3QntLsV8MLKczLeWaZM0i9gZdKJCkYwy1JwRhuSQrGcEtS\nMIZbkoIx3JIUjOGWpGAMtyQFY7glKRjDLUnBGG5JCsYnmeoj1sLSdmgre4Yy15d6C59kSpKC8VKJ\nJAVjuCUpGMMtScEYbkkKxnBLUjCGW5KCMdySFIzhlqRgDLckBWO4JSmY/wcwvaoqEYhdGwAAAABJ\nRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x997d780>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "form(5,3,2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x9afc208>"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAFeCAYAAACM88jgAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAIABJREFUeJzt3XmYXFWd//H3h7DJviQgEkJQARdk\nDYuIyiIIokRHEBiR/DAamUFBHQdBHGFcZnDfWCMEwQUEFYmKIpssIoGELSCikYBEEIIsMqIg8P39\ncU6RSnd11711q6u6cz+v56mnq07de+pUddX93ntWRQRmZlY/y/W7AGZm1h8OAGZmNeUAYGZWUw4A\nZmY15QBgZlZTDgBmZjXlAGBmVlMOAGZmNeUAYGZWU8v3uwDDGT9+fEyePLnfxTAzG1PmzZv3cERM\naLfdqA4AkydPZu7cuf0uhpnZmCLp3iLbuQrIzKymHADMzGrKAcDMrKYcAMzMasoBwMysphwAzMxq\nygHAzKym2gYASbMkPSTp9gHpH5B0l6Q7JH2uKf1YSQvyc29sSt87py2QdEx334aZmZVVZCDYN4GT\ngHMaCZJ2A6YCW0bEU5LWy+mvAA4CXgm8CLhM0mZ5t5OBPYFFwI2SZkfEb7r1RszMrJy2ASAirpY0\neUDyvwEnRsRTeZuHcvpU4LycvlDSAmCH/NyCiLgbQNJ5edvSAWDyMT8d9vl7Tty3bJZmZrXUaRvA\nZsBrJc2RdJWk7XP6hsB9TdstymlDpZuZWZ90OhfQ8sDawE7A9sD5kl4MqMW2QetAE60yljQDmAEw\nadKkDotnZmbtdHoFsAj4YSQ3AM8B43P6Rk3bTQTuHyZ9kIiYGRFTImLKhAltJ7MzM7MOdRoAfgTs\nDpAbeVcEHgZmAwdJWknSJsCmwA3AjcCmkjaRtCKpoXh21cKbmVnn2lYBSToX2BUYL2kRcDwwC5iV\nu4Y+DUyLiADukHQ+qXH3GeCIiHg25/N+4BJgHDArIu4YgfdjZmYFFekFdPAQTx0yxPafAT7TIv1i\n4OJSpTMzsxHjkcBmZjXlAGBmVlMOAGZmNeUAYGZWUw4AZmY15QBgZlZTDgBmZjXlAGBmVlMOAGZm\nNeUAYGZWUw4AZmY15QBgZlZTDgBmZjXlAGBmVlMOAGZmNeUAYGZWUw4AZmY11TYASJol6aG8/OPA\n5z4iKSSNz48l6WuSFki6TdK2TdtOk/T7fJvW3bdhZmZlFbkC+Caw98BESRsBewJ/bEreh7QQ/KbA\nDODUvO06pLWEdwR2AI6XtHaVgpuZWTVtA0BEXA080uKpLwNHA9GUNhU4J5LrgbUkbQC8Ebg0Ih6J\niEeBS2kRVMzMrHc6agOQtB/wp4i4dcBTGwL3NT1elNOGSjczsz5ZvuwOklYBjgP2avV0i7QYJr1V\n/jNI1UdMmjSpbPHMzKygTq4AXgJsAtwq6R5gInCTpBeSzuw3atp2InD/MOmDRMTMiJgSEVMmTJjQ\nQfHMzKyI0gEgIuZHxHoRMTkiJpMO7ttGxJ+B2cChuTfQTsDjEfEAcAmwl6S1c+PvXjnNzMz6pEg3\n0HOBXwObS1okafowm18M3A0sAL4B/DtARDwCfAq4Md8+mdPMzKxP2rYBRMTBbZ6f3HQ/gCOG2G4W\nMKtk+czMbIR4JLCZWU05AJiZ1ZQDgJlZTTkAmJnVlAOAmVlNOQCYmdWUA4CZWU05AJiZ1ZQDgJlZ\nTTkAmJnVlAOAmVlNOQCYmdWUA4CZWU05AJiZ1ZQDgJlZTTkAmJnVlAOAmVlNFVkScpakhyTd3pT2\neUm/lXSbpAslrdX03LGSFki6S9Ibm9L3zmkLJB3T/bdiZmZlFLkC+Caw94C0S4EtImJL4HfAsQCS\nXgEcBLwy73OKpHGSxgEnA/sArwAOztuamVmftA0AEXE18MiAtF9ExDP54fXAxHx/KnBeRDwVEQtJ\ni8PvkG8LIuLuiHgaOC9va2ZmfdKNNoB3Az/L9zcE7mt6blFOGyp9EEkzJM2VNHfx4sVdKJ6ZmbVS\nKQBIOg54BvhOI6nFZjFM+uDEiJkRMSUipkyYMKFK8czMbBjLd7qjpGnAm4E9IqJxMF8EbNS02UTg\n/nx/qHQzM+uDjq4AJO0NfBTYLyKebHpqNnCQpJUkbQJsCtwA3AhsKmkTSSuSGopnVyu6mZlV0fYK\nQNK5wK7AeEmLgONJvX5WAi6VBHB9RBweEXdIOh/4Dalq6IiIeDbn837gEmAcMCsi7hiB92NmZgW1\nDQARcXCL5DOH2f4zwGdapF8MXFyqdGZmNmI8EtjMrKYcAMzMasoBwMysphwAzMxqygHAzKymHADM\nzGrKAcDMrKYcAMzMaqrjuYDGqsnH/LTtNvecuG8PSmJm1l++AjAzqykHADOzmnIAMDOrKQcAM7Oa\ncgAwM6spBwAzs5pyADAzq6m2AUDSLEkPSbq9KW0dSZdK+n3+u3ZOl6SvSVog6TZJ2zbtMy1v//u8\nnrCZmfVRkSuAbwJ7D0g7Brg8IjYFLs+PAfYhrQO8KTADOBVSwCAtJbkjsANwfCNomJlZf7QNABFx\nNfDIgOSpwNn5/tnAW5vSz4nkemAtSRsAbwQujYhHIuJR4FIGBxUzM+uhTqeCWD8iHgCIiAckrZfT\nNwTua9puUU4bKn1MajedhKeSMLOxoNuNwGqRFsOkD85AmiFprqS5ixcv7mrhzMxsiU4DwIO5aof8\n96GcvgjYqGm7icD9w6QPEhEzI2JKREyZMGFCh8UzM7N2Og0As4FGT55pwEVN6Yfm3kA7AY/nqqJL\ngL0krZ0bf/fKaWZm1idt2wAknQvsCoyXtIjUm+dE4HxJ04E/AgfkzS8G3gQsAJ4EDgOIiEckfQq4\nMW/3yYgY2LBcK25HMLN+axsAIuLgIZ7ao8W2ARwxRD6zgFmlSmdmZiPGI4HNzGrKAcDMrKYcAMzM\nasoBwMysphwAzMxqqtOpIGwUcFdSM6vCVwBmZjXlAGBmVlMOAGZmNeUAYGZWUw4AZmY15QBgZlZT\nDgBmZjXlAGBmVlMOAGZmNeUAYGZWUw4AZmY1VSkASPqQpDsk3S7pXEkrS9pE0hxJv5f0PUkr5m1X\nyo8X5Ocnd+MNmJlZZzoOAJI2BI4EpkTEFsA44CDgs8CXI2JT4FFget5lOvBoRLwU+HLezszM+qRq\nFdDywAskLQ+sAjwA7A58Pz9/NvDWfH9qfkx+fg9Jqvj6ZmbWoY4DQET8CfgC8EfSgf9xYB7wWEQ8\nkzdbBGyY728I3Jf3fSZvv26nr29mZtVUqQJam3RWvwnwImBVYJ8Wm0Zjl2Gea853hqS5kuYuXry4\n0+KZmVkbVaqA3gAsjIjFEfFP4IfAzsBauUoIYCJwf76/CNgIID+/JvDIwEwjYmZETImIKRMmTKhQ\nPDMzG06VAPBHYCdJq+S6/D2A3wBXAvvnbaYBF+X7s/Nj8vNXRMSgKwAzM+uNKm0Ac0iNuTcB83Ne\nM4GPAh+WtIBUx39m3uVMYN2c/mHgmArlNjOziiqtCRwRxwPHD0i+G9ihxbb/AA6o8npmZtY9Hgls\nZlZTla4AbGybfMxP225zz4n79qAkZtYPvgIwM6spBwAzs5pyADAzqykHADOzmnIAMDOrKQcAM7Oa\ncgAwM6spjwOwStqNJfA4ArPRy1cAZmY15QBgZlZTDgBmZjXlAGBmVlMOAGZmNeUAYGZWU5UCgKS1\nJH1f0m8l3Snp1ZLWkXSppN/nv2vnbSXpa5IWSLpN0rbdeQtmZtaJqlcAXwV+HhEvA7YC7iQt9Xh5\nRGwKXM6SpR/3ATbNtxnAqRVf28zMKug4AEhaA3gdec3fiHg6Ih4DpgJn583OBt6a708FzonkemAt\nSRt0XHIzM6ukyhXAi4HFwFmSbpZ0hqRVgfUj4gGA/He9vP2GwH1N+y/KaWZm1gdVAsDywLbAqRGx\nDfA3llT3tKIWaTFoI2mGpLmS5i5evLhC8czMbDhV5gJaBCyKiDn58fdJAeBBSRtExAO5iuehpu03\natp/InD/wEwjYiYwE2DKlCmDAoQtezyfkFl/dHwFEBF/Bu6TtHlO2gP4DTAbmJbTpgEX5fuzgUNz\nb6CdgMcbVUVmZtZ7VWcD/QDwHUkrAncDh5GCyvmSpgN/BA7I214MvAlYADyZtzUzsz6pFAAi4hZg\nSoun9mixbQBHVHk9MzPrHo8ENjOrKQcAM7OacgAwM6spBwAzs5pyADAzqykHADOzmnIAMDOrKQcA\nM7OacgAwM6spBwAzs5pyADAzqykHADOzmqo6G6jZqOA1BczK8xWAmVlNOQCYmdWUq4DMaF+FBK5G\nsmWPrwDMzGqq8hWApHHAXOBPEfFmSZsA5wHrADcB74qIpyWtBJwDbAf8BTgwIu6p+vpmo4Ubom2s\n6cYVwFHAnU2PPwt8OSI2BR4Fpuf06cCjEfFS4Mt5OzMz65NKAUDSRGBf4Iz8WMDuwPfzJmcDb833\np+bH5Of3yNubmVkfVL0C+ApwNPBcfrwu8FhEPJMfLwI2zPc3BO4DyM8/nrc3M7M+6LgNQNKbgYci\nYp6kXRvJLTaNAs815zsDmAEwadKkTotnNia5HcF6qcoVwGuA/STdQ2r03Z10RbCWpEZgmQjcn+8v\nAjYCyM+vCTwyMNOImBkRUyJiyoQJEyoUz8zMhtNxAIiIYyNiYkRMBg4CroiIdwJXAvvnzaYBF+X7\ns/Nj8vNXRMSgKwAzM+uNkRgI9lHgPEmfBm4GzszpZwLfkrSAdOZ/0Ai8tlntuRrJiupKAIiIXwK/\nzPfvBnZosc0/gAO68XpmZladp4Iws6V4Woz6cAAws65zNdTY4ABgZqNS1SDSjSuZZf1qyAHAzGwE\njearIQcAM7NRbqSCiKeDNjOrKQcAM7OacgAwM6spBwAzs5pyADAzqykHADOzmnIAMDOrKQcAM7Oa\ncgAwM6spBwAzs5pyADAzqykHADOzmuo4AEjaSNKVku6UdIeko3L6OpIulfT7/HftnC5JX5O0QNJt\nkrbt1pswM7PyqlwBPAP8R0S8HNgJOELSK4BjgMsjYlPg8vwYYB9g03ybAZxa4bXNzKyijgNARDwQ\nETfl+08AdwIbAlOBs/NmZwNvzfenAudEcj2wlqQNOi65mZlV0pU2AEmTgW2AOcD6EfEApCABrJc3\n2xC4r2m3RTltYF4zJM2VNHfx4sXdKJ6ZmbVQOQBIWg34AfDBiPjrcJu2SItBCREzI2JKREyZMGFC\n1eKZmdkQKgUASSuQDv7fiYgf5uQHG1U7+e9DOX0RsFHT7hOB+6u8vpmZda5KLyABZwJ3RsSXmp6a\nDUzL96cBFzWlH5p7A+0EPN6oKjIzs96rsibwa4B3AfMl3ZLTPgacCJwvaTrwR+CA/NzFwJuABcCT\nwGEVXtvMzCrqOABExLW0rtcH2KPF9gEc0enrmZlZd3kksJlZTTkAmJnVlAOAmVlNOQCYmdWUA4CZ\nWU05AJiZ1ZQDgJlZTTkAmJnVlAOAmVlNOQCYmdWUA4CZWU05AJiZ1ZQDgJlZTTkAmJnVlAOAmVlN\nOQCYmdVUzwOApL0l3SVpgaRjev36ZmaW9DQASBoHnAzsA7wCOFjSK3pZBjMzS3p9BbADsCAi7o6I\np4HzgKk9LoOZmdH7ALAhcF/T40U5zczMekxprfYevZh0APDGiHhPfvwuYIeI+EDTNjOAGfnh5sBd\nbbIdDzxcsWhV8xgNZRgteYyGMnQjj9FQhtGSx2gow2jJYzSUoUgeG0fEhLa5RETPbsCrgUuaHh8L\nHFsxz7ldKFelPEZDGUZLHqOhDH4f/iz8WRS79boK6EZgU0mbSFoROAiY3eMymJkZsHwvXywinpH0\nfuASYBwwKyLu6GUZzMws6WkAAIiIi4GLu5jlzFGQx2gow2jJYzSUoRt5jIYyjJY8RkMZRkseo6EM\n3cqjt43AZmY2engqCDOzmnIAMDOrKQcAM7MekbScpDX6XY6G2gYASWtL2kHS6xq3PpVjF0mH5fsT\nJG1ScL91hruVLMMWnZS9af8vSHpllTwqvv5rJF0q6XeS7pa0UNLdBfd9QtJfh7p1WJZV8/1DJH1J\n0sYl9lfe7xP58SRJO5QtR79JWlnSEZJOkTSrcesgnzdLqnSckrRPi7TDS+axlaT359tWJff9rqQ1\n8vfiN8Bdkv6zTB4jZUw1AkuaDwxZ4IjYsmA+7wGOAiYCtwA7Ab+OiN1LlOVfgM8C6wHKt4iIwtFd\n0vHAFGDziNhM0ouACyLiNQX2XUj6LNTi6YiIF5cox7XAisA3ge9GxGNF9837vwc4jNSr7Czg3Ih4\nvMT+E4CPkiYIXLmRXvT/Iem3wIeAecCzTfv/pUQZPgn8GfgW6TN9J7B6RHyuaB45n9uArYAtc15n\nAv8SEa8vuP+pwHPA7hHxcklrA7+IiO1LlGEl4O3AZJp6+kXEJwvsO9RvrPH9LvobuwD4LfCvwCdJ\nn+edEXFUkf2b8vk2aQDpD4CzIuLOMvvnPK4DPh4RV+THHwV2jYhBgWGI/Y8C3gv8MCe9DZgZEV8v\nuP8tEbG1pHcC25G+6/NKfJZdOe4NtfOYuQEb59vn8u1V+XYi8IkS+cwnHWhuyY9fBnyvZFkWAC+v\n+H5uIf2wbm5Ku61Pn+2mwP/m9/VdYM8O8tg8/y/uzXnsVnC/XwDTgTuB1wOzgM+WeN05XXj/g/Lo\nJF/gpvz3E8D05rSS+zd/J24tWYafA98Djgb+o3EruO/Gw91KlOHm/Pe2/HcF4IoO/zdrAO8Drgd+\nTZoqZvUS+4/P+74W+AwpmKxQYv/bgFWbHq9a5ncK3JHf/wXA68v+T7t13GuZd5Wd+3UDflUkbZj9\nb8x/bwFWatyvWoYO3scN+W/jR1/4iwW8LP/dttWtw/KMI505/ikfjH9LOnstuu9U4EekM/GPAj8G\nziuw77z897amtKtKlPtE4POkM8WOPgPgOtJZ6jhS1eg7ges6+AyvIk1x8jvghTm/+SX2n5P3aXwn\nJtAUDArmcXvV72bVW9N3+2pgi3wQvrtCfuOBDwL3AD8Dfg98oMT+6+UD+Vnkmo8S+84HVm56vHLJ\n/+mR+Td1MemEb2Pgmg4+g0rHvVa3ng8E65JVJe0SEdcCSNqZdPAsapGktUgHq0slPQrcX7IMcyV9\nL+fxVCMxIn449C6DnC/pdGAtSe8F3g18o+C+HyadCX2xxXMBlKnO2pJUhbMvcCnwloi4KVdJ/Zol\nl75D7f8lYD/gcuB/IuKG/NRnJbWbzA/gn/nvA5L2Jf0vJhYtP7Bj/julKa3UZ0CqqvhqvgXwq5xW\n1oF5v+kR8WdJk0jBqaivARcC60n6DLA/8PGSZbhO0qsiYn7J/Z4naSfg68DLSdWD44C/RfEqzpm5\n+uq/SNO9rEa6KipbjreQfhcvIVWp7RARD0lahXSSMmQ1jKQnWLrqZEXgxcD+kqLEezkLmCPpwvz4\nraSqvUIi4muk/2vDvZJ2K7p/k6rHvUHGVBtAg6TtSNUEa+akx4B3R8RNHeT1+pzPzyOtUVB0v7Na\nJEdEvLvk6+8J7EU6M7gkIi4ts383SLoaOIPU/vD3Ac+9KyK+1Wb/d5PO9J9s8dya0aY9QNKbgWuA\njUg/6DWA/46IWs4TJellwB6k78TlUbLeW9JvgJcCC0knJ6Xq73Mec0lzdV1ACqyHAi+NiOPKlKUq\nSecAZ0TE1S2e2yMiLm+zv4CNIuKPFcuxLbAL6bO8OiJuLrHv+sD/AC+KiH2UFsF6dUQUDiI5n64d\n957PcywGgAal7lRqd4AZYt9xwPos3UhW6UvSQRk2AR6IiH/kxy8A1o+Ie0rk8Qfg8xFxWlPaTyLi\nzd0ub5tybEi6tG3+PAf9aEfw9fcFXsnSjchtGz2b9p9AauibzNLvoVBAb3G2uZR2Z5tq03MrIh4p\nUo6cV8teRxFxb4k85kbEFEm3NQKHpOsiYuc2+x0SEd+W9OEhyvClomXoFknzImK7CvvvBNwREU/k\nx6sDr4iIOQX3/xnpKuK4iNhK0vKkar1XdViejo97A43JKqCBvRxSkC/+g5f0AeB44EFSjwtIP962\nZ0iSjo6Iz0n6Oi1+8BFxZJEyZBcAzT+oZ3Na4R4fpOqT3STtCLwvX8UUWmSniz0+TiSdLf6GJb1w\nglT/O9x+XfksJZ0GrALsRrqS2R+4YdidBruIdBVyGU09iYqKiNVzWVr2JiqQxTwG9+pqPA5S1UXR\nstwraRdg04g4Kwe31Yrunz2pNGPvLZI+BzxAseqGxjZF3nNbXaiKArhe0vYRcWOHxTiV1K7U8LcW\nacMZHxHnSzoWnp8Us/R3rOpxr5UxGQBIP9bHST+ap9ps28pRpK6XhbsJNmlcjs/tYN+Blm+udoqI\np/OPrownI+JASUcD10h6B8OciQ7QrauEt5E+z7L/i259ljtHxJb5bPW/JX2RNu0WLawSER+tWA5I\nCx7t2PT4VElzSL03hhQRhcZ/FNHcvZh05rkC8G2gbffiJu8iHWzfT+piuxHp4DOsiDg9//3vcqUe\n0km0qIoqmcduwPsk3Us6eJetElM0VZVExHP5LL6ov0lal/y7zEGtk7P3qse9QcZqAJgYEXtX2P8+\nOvsHEBE/zn/PrvD6DYsl7deo65Y0lfIrBSmX53OS5pGm2i40EKxMlUAbd5MOMqW+lAM/y3xpG41L\n7RIa7RZP5obrvwBlD6g/kfSmSLPVVvFs7u99HukHfzAFrigkvSwifpvrmgcpWc/7NmAb4Ka87/25\n2qKwpu/G34HSB3NJLyY1qO9E+hx+DXwoIgoN0BtQlgWSxkXEs8BZuV9/GYX6+w/jbklHks76Af6d\n9J0v6sOkhvCXSPoVqWfXAR2Uo+pxb5CxGgCq9nK4G/ilpJ+ydA+ewvWTqjh4KTsc+I6kk0gH8vtI\nZzhlPN+zIiIul7QX8P/KZNCFy+wnSVUFl7P051m0CmcK6Ux19fRQjcateQVf/ye5V9fnSQe9oHhv\nqoajgI9JeopUrVZ6YF/WaW+irvXqAp6OiJDUOOMs3VNkiOrBx0lXa58ucPX8XeBkUjCCdBZ/Lkt6\nbBXVaVXU8xrBTNJ6NP1WSzic1Ivn46TP5HKWLFtbxB2k8S2bk75Xd9HZLAyVe3cNNCYbgav2csiX\nyIOUuWyV9AvSYJuPkL4g04DFnVQjSFqN9L8oe+bb2H9t0kCu5kBUuAG2ao8PSdNapRe9SlIaPXtE\nRFyTH+8CnFKm10pTXiuR+mxXbiAbqyR9hPR92JM0uO/dpBHehUau5jw+R7py+W5OOoj0O3sc2CUi\n3tJm/zkDqsKQdH1E7FT4jfB8g/aDpBOTD5F6wJwSEQtK5LEfKbC+CHiI1FnhzojoyfQlkm6KiG3b\npRXIp3LvrkF5jtEAULmXQxfKMC8ithvQS+KqKDjkP2/f8ZD9pjy6Ma1FRz0+ukXSr2LA9Bet0obZ\nf2XSZfkupDO0a4FTG72rSpSjUiDNeVTqTZTz2LnF/ueULEel7sXD/U8kzR+qB0tTb6ajSd0UG1Vh\nB5IGXX6qZDl2B66PFl2MS+RxK+kK6rKI2EapD/7BETHsWXzVTgqSXkjqkPFt0lVgo4F/DeC0iHhZ\nyffR9ePemKwC6vSSTtJXIuKDkn5M63/ofiWKUXXwEnSnUecoUq+h6yNiN6U+5GXrbCtdZktqTCMx\nsDps2J4rTfXdNygNiDuXJQeLX5Yo/znAEywZFHQwqRdO4XrWoQIp5apeoGJvIknfIg16uoWle1SV\nCgD5gF9lTMlqknZsdHVUmpCu0ZPomWH2G9ib6X3NxQJKBQBSdeZpkv5C+lyvAa6NiEdL5PHPiPiL\n0kycy0XElZI+W2C/qp0U3kgq/0SguXr5CeBjZTPrQlVWy0zH3I006vT3pBb9haSunHcU2G+7/Pf1\nrW4ly/Bm0uXoFsCVpC/+fiXzqDxkn+5Ma7Fx/kKtQeoe+yXgJSX2v5Y0cOm2nNcJpIFc7fa7cphb\n4XljaDGvSqu0NnlUnh+qk8++xf53QrmpCpr2fQL461C3knltnz+ThaTpF24DdiCdGLyj6ve2g/f2\nItKUCn8Enim572Wk4PV10knGVykxzQdN00A0pY0vsf/bu/QZdHTcGzbPXv8ju/RB3Aqsy5IJp3Yj\nzc5XdP+jiqT14H3MBF5VMY8LgbXyQfdq0hnoxSXzqPR5sGQun/lNaaXnOqnwGXwT2Knp8Y6keuIy\neVQOpHmfTwNvqvBeLgA2qPh5fJJUJbY6Kaj/G3B0h3mtCazV4b5bAO8gtSkdChzaQR6HAKeT5mqa\nTapaenXJPFYldWxYntRWdySwbon9bxvw/Xo78LuSZdg3l/0TjVsHn0Wl416r21htA2jUWd8KbBOp\nX+4NEVFo3vQhGmVujohtSpSh0c3t1aRIXLqbW7cbddT5tBaVPo/cte21wPeBK0gTX50YEZsX3H8t\n0gFiMkvXexftRXQnqYdFYyT3JNKZ9HMU/DyV5nk5jDTh2O7Ao6QZI99UpAxN+TxBOuCU6k3UVC25\nOrA1aSBbc4+qwtWTQzTADkprk0fLeXui+GDL44FdSdWCF5O6Yl4bEfsXLUPO52HgD8BpwJVRYpR8\ni7zWYOnvV6HR1ZJeRZqC4ZekK5F1gfdExKKC+7ccqBgR00uWv9Jxr5Ux2QYAPJZ7zlxN6kb5EMPX\nSwIg6WBSY8wmkprnmVmd1He8jG50c6vUP1lpoYzbImILgIi4quT+3fo8Pkj6gh9JquPdnXSmVdTF\npOl657NkZHYZlftGR0Tj/3iCpCvJgbSDfDodATubNDXJNQPSX08KqGV0NBZhgL813V+ZVOVZZk6i\n/UnrItwcEYcpzYdzRskyEBHjlRYbeh3wmdzedFdEvKtoHpLeR7oq+jvp+1VqdHVEzFeamO9bpGq2\n1xU9+GfdGKgIHR73hjNWA8BU4B+kbmHvJP1Yi5yZXEdq4BzP0v2tnyBd5pWhWHqStG9Len+ZDKJi\no04+A7hV0qTobB6jrnwesWSI/f+RzqLLWjkiWs4dU/D1W36ORT4TtZ6Dp9HPejWg8Bw8TXl20pto\nKvCxiFjqc5f0N1K7TJmJwyrPbBoRS41HkPQFUpAq6u/5+/lMPvN+iBLTWTS97hqkK7qNSVeIa1L+\nJOEjwCsjouwgy0YZziQ1zG/me2NjAAAYQklEQVQJbAb8WNJJEXFywSy6MVAROj/uDWlMBoCIaD47\nKTwiNx8o7iVV21R1paRjWLqb208bB5Qil5dD9U8mTWpW1AbAHZJuoOmsrUiVQbc+D6WBXMcxeDK4\nolVZ31KaDvsnLF3tUfQSvcrn2LU5eHJZOu1NNHngwR8gIuZKmlymDLmaZGqZfQpYhXKfxdxctfcN\n0mf8f5SfnwlSB4PG7aSSZ94NfyANVuzU7aQqnwAWKg2cLDOpXauBip1cDXV03BvOmGoD0NAzLpYa\ntanuLOe4MN9tlGepA0gUWJKx0/7JA/JoOe6gSHVQFz/Pu4D/ZEAVThTsnyzpCNJKTY81lafQZ5j3\nr/w5dovSCNpGt9ytG91yI+LANvstiIiWc9wM99wQ229GmrZg/YjYQmm9h/0i4tMl30fjfzGONH3B\np6LAYDJJIk1bcF9+PBlYo1WAa5PPONLKcB8ps1+LfLYhz+lPByPVcx4vACZFRJH1LQbuu1LkebKU\nByoC/4iCc2e1+J02Tk46Ha2+RJUW5LF6o8JyjqQf9wubHk8jXRp/DVinZF5zY0nr/nL5/g0V3td4\nOuxCWPHzvLbi/n+gRLe6kfgc84/pEOC/8uNJpMVHypalo95EpPaj97ZIn0755UqvInXZbF5WslSX\nY5ZeCnJD0sSFZfaf16Xv1uVdyOMG0hn7Yfn3Og2YVmL/t5Cmb1iYH28NzC6x/6AlQVul9eM2JquA\nhqi3fSIi/tkivZUHo4PFpbPTgTfkcryONADqA6QvxUxS41dRHTfq5MvQE0l11J8iNVCNB5aTdGhE\nlG7ArOB4SWeQ5kjpZHW0O6h2id74HK+h88axU8iLsZM+zydIa8eWmZobOl9t7oPAhbnxtjEH0hTS\nFAhvG3Kv1laJiBuk5ovS0p/Hp2NAQ6ukbw1MG0bVKZgbbskdFC5g6SrOMo2oz0SFNiZSF+sdyIMT\nI+IWpbU8hqUlI4FfkK9CmkcCr9JJQSRtRepxB2lhmrJtl0sZkwGAVI+2Eamrnkj94B/IP/z3RvtJ\nxKos5zgultRNH0jqh/sD4AeSbin5PqaSGog6adQ5iTSacE1S18t9IuL6XOVwLh30YKngMNLAqRVY\nen2Foj/SZ0k/9Cvp7BJ9P1Lj2FGks/g1KD8aeseI2FbSzfm1H1X5qbmJDnsTRcSDwM65+mqLnPzT\niLiibBmAhyW9hCXTD+9PauwvY6n2E6Xpj8ssqlJ1CuaGdUiNps1tKGW+W5Da62aQ1qgu3cZECiCP\nDwioRerOm0cCf5ElAaCjkcCSjiJNM9J479+RNDNKzPE0KM98OTKm5H61F0bEJfnxXqSugOcDX402\n/Z1VYTlHSbcDW0da1OG3wIzIPTwk3R65S2aBfMaR5mh5Q5HtW+x/S0Rsne/fGREvb3qu1JiGqjTM\n3DAF92/ZZTTaTCY3RBtG40f2D1LV0nHRZtnAnNcc0uI8N+ZAMAH4RdHPcYir0ueVONhUpjRGZSbp\n/TxKGmfyzijQJqO0aMnHgBew5KpMwNOkk51jC5Zh41bpRcrQbU3tdQOKUriN6UzS1e0xpEFgR5LG\niBxecP+355PESpQmTXx15MZgpVlef91BUF2i33VQndzIdb6t0qg4FL/Aax9H6lZ3EXAzS4LoS4Ff\nlcxrNrBmh+W4qdX9Vo978P/4BmmJvCp5rEg6892C9OOqWqZxpH7oheq+SVdgs4FFpAbpu4ADSrze\nQtI04wubbo3Hd/fy/9FUplWB1TvYbzlgVpfL8U7SFU3ZfSeSRrs/RJoV9AekBuZefo6r5O/EjaR5\ngT5Di+khWuz3FmDjpsefILVTzQY26aAc85tfl9SYPL9sPs23sXoF8AtSRD4vJx1Imvp2b/IZXJv9\nK/WSyPXvG5DOEBvReDNgtSixcIek80ndBC9l6frNtlUfSkvKNS6tB56trRwRKxQtR1VKI3FfQufT\nc+9K6tZ2T953I1IjXeU1hSW9L/IqVQW2rboYe1cWIK9KaZ3o60ltIldHxG86yKPqOrorAm8ijT/Y\nm3Tg/mHkRYBK5HMpadBlY8zNIaSrmT1L5lN5htWy8hn7ThHxpKQ3kxqiDyYt1nNARLyxZH4fJjVg\nX5iT3gp8MyK+0nEZx2gAGE8aHLML6cd6LanO93FSV61h5wqXdBWp2+LpkS/xy1TfdEunVR+jTdXL\nfaWVzP41che7HEzPrXIAKkMDRlRXzKvSgbMbclfDHUmNha8htc/cGkvaJ4rkcTLp4FKqEVdpGuqD\nSfXfV5LWzPh6REwuk09Tfs9XdQ6X1iaPljOstjvR0tKj4weJNmNtJN0aEVvl+7NII5g/mx+XXg8g\n77ctS457V0fEzWXzaDYmG4Ejjej7wBBPF1koohu9JDqmPHJ3rB3oW8kHz59WPHiuEE39qyPid5J6\ndgUT1UdUN+tW75cqniXNQ/QsqVH+QVIVShmdNuJeQrry2CUiFgJI+mrJ1272sKRDSB0bIAWXstO2\nTCFVUZY92301aZW+c0ljCDT85oMo9057knRleUrTc2WmsV+ZtOjUS0nVQKdERFeOV2MyAOQzxI8w\n+JKu6Nzt3eglUcWPgG3za/8gItoutj1adengOTc3tDUu85u7QvZKxyOqB9gNOFzSPVTr/VLFX0kH\nii8B34j2yze20uk8VduR5sW6TNLdpGracR3mBWk1s5OAL5N+r9fltDJuB15I+d/4C0lVy405s35K\nujK9o+D+XyFddfyVtALZXHh+YFqZspxNCujXkP4vLyd1G65srFYB3UqaHXAeTZNcRcE1ZIfoJXFI\nVJhpsIzmXjq97rEzEiRdQeov39HBM1dZHEHTpS3pLKfTRXJKU4UR1QPy6XvvF0lTSZ/lDqTeO9eR\nqgva9oYakE9zn/NrIuLWkvu/hnTwfDvpQHhhRMwsk0c35O64VWdYXYn0Xj4PfDIKdr2UtCFpxoFb\nI+K5nLYB6aq30AlTcy+73B33hk6qj1rmPUYDQFfqWXM3quWiw7V4K7zu8/V/ndYFjibdOnguK5TW\nNN40Is7K3UlXa1SH9LgcLyOdMX4QWC8iXlBi34F9zt9G6gZaus95ribcEzgoIgpNFqghpqPOIkos\nLVnl+5kP/PuSDv6TST14ZkVE2RlaOzbwGNHNY8ZYDQAnkOo0L6SzycNajQp8nDR8vexgrtLa9OCJ\nqDK3R5/kM99NI+IySauQBswNG1i19Hwzg/Si2mSIsQTQ4f9CaR78KcDmEbGZ0uyPF0TB9Y27QdIP\nSGe8C8g9gUhnjYXXSB6RPuclSPqPFsmrkqbGWDciVmvx/HD5dfL9PJvULflnwHkRcXuZ1+yWpuMF\nLH3MqHy8GKsBoOrAju+SfqSNLmn7kvr4voz0Y/1cVwpaE0ozec4gzYX0EqU520+LiD3a7NeyuqSh\nl9Um3aI0Gnwb0liMRjXfbT0KZtuTGi03Io2WP4RU/XIPcELRE6Sc13xg+0bQyA2RN0aFAX+dkrQ6\naZT3dNJgzy9GROFG7Qrfz+dYcuAdNBnbWDxRG2hMNgJHRCdzaTdbF9g2Iv4Pnj9r+z5p0Yl5gANA\nOUeQ6pvnAETE75Xm5h9W8wFeacGQxrw7N5T5gY8yT0dESGp0MFi1h699OvCGiLhR1eepOguYo7RS\nGqQ+52XWJKhMaXT1h0mdAs4m/WbLLAbf0On3c7kOXut5GkWjw4dS6Q32mqSjm+4fMOC5/ymR1SRS\n41jDP0kj9v5OU5WSFfZUNC1BmRuqCl9aSnoHqYHuANIasnNyz6yx6HxJpwNr5TPPy0gjpXuh5TxV\nEfFfpC6EhUVEY/bMR0gdJQ6LAgOOlBZwQdI6rW5FX1/S50lX5U+Q1s0+ocODP1T8flYwjzRyeB6w\nGPgdaVH3xfS+l1tLY+0K4CCWnJ0fS5ohsGFvik+w9F1Sf+2L8uO3AOfms7XSoyaNqyR9jDTr4Z6k\nBcnLjPg8jlTd8BBAbji9jHRVNqLUNFd7N0TEF/Jn8FfSOsWfiIhLu5V/G+MkLZ/7iO9BqvZoKPRb\n70Kf8++Slo8caqGdoovK/AfpZOzjwHFNY3Y6qX6p+v3sSKOmQmnustkRcXF+vA95RuF+G1NtAMN1\nnyzbnVLSdjSNJG700bXyci+P6cBeOemSiCi84pEGTCaX87u1F/XNjR4VKjfV8agk6TjS9AsPk65y\nt83VUS8Fzi7SEK00S25zn/N7IqIrfc77ZcD3U6TBamdEjw5+rXotKi/w3ovXH85YuwKIIe63etyS\nlh72Pyouw8aq3N98YqS1Ub+RqzwmANtJeiwiip7B/1zSJSwZ7XkgaaH4XlhRaUqOnZVWiltKlJt3\nHnVhtblORcRnJF3OknmqGr+J5Rh65PxAr2jqc34mJZdxVJqqYLgyFp4rq1siDVb8EfCjiFjc69cn\nDTz9OPBt0nHqEMqPZh4RYy0AbCXpr+SuUPk++XGhodXR3WH/dXc0qVquYUXSSNDVSI2IwwaAfGa6\nfkT8Zz5wNq7Ifg18Z0RKPNjhpEbGtUhVgc3KzjsPqYryLdH5gkOVRMT1LdJ+VyKL5xdVijTledki\nNBaTX5nU0+5W0v90S1Ij7C5lM+yUUuGPB96fy6DcpfLrEVFpMfWSDs7luJD0nbo6p/XdmAoAEVFl\nSHmzVsP+IyK6vZD2sm7FyOu+ZtfmRshHCvZ++Qq53Safaf8QQGmR+a8w+IDcdRFxLXBtviTvRi+X\nKqvNjQZbDTixekHTSVfbK5mI2A1A0nmktTLm58dbkKZv6aUPkibD2z6WzEv0YuBUSR+KiC/3ohD5\nN3GUpNUaPQ9HizHVBtAtA0YGinRWcnBEvHKIXawFDb+Q+R8i4iVt9h9yBtaB7QIjTWn64sNJXYEh\nrat7WhRcZrSp+uj1pDlkOlltbpmhLszi2YUy3AzsGWnyyOb0Uov9dKEcOwNnkEaET1KaYuN9EfHv\nvXj94YypK4BuiYirJG1NmuDpHaS5gE7rb6nGpDmS3hsRS3VzlPQ+itUdD1dtV3jagi45hbSkZWPG\nxneR1ox4T8H9m69WnmRJgzh0VpU01t2ptE50c713r6+MVhh48AeIiMXq4WyzpIns3kiaRoKIuDWP\n0+i7WgUApVlED2LJlLLfI10F7dbXgo1dHwJ+JOlfSSNPIbUBrEQaONTOjUMEkOn0voF++8hzt2dX\nKE06WEjkOW4kvSYiftX8nNKkaHVzGPBvpBG8kOq9T+1xGZ7u8Lmui4j7BrSnPDvUtr1UqyqgPLT7\nGmB65EVjJN0dBaeQsNYk7c6SRcTviIILmefRvxeSfoyNA/4UUmPy2yLiz90u6zBluYm0StMf8uMX\nA9+PkpNuqcVEXa3SbORp6Tl0lnqKHq6aJ+n7pKm5TyKtAHgkMCUiDhp2xx6o1RUAaV6Ug4ArJf2c\nNFd56W4OtrR8wC900B+w34Ok7pe7kSbdgrS4TOm8uuA/Sd+Lu0nfiY1JZ7GFSHo1aXrxCVp6ssE1\nqDYf/pikNF/XoLPLXp5sdbHTSFWHA18FNiStOf0L0mC0vqtVAIiIC4ELcw+Vt5KqMNaXdCpprvJf\n9LWANRURV5KWD+xnGS5XmiRsc1IA+G3JEcIrkrq/Lg+s3pT+V8rNwbOsaB7ktDJpmo/CU0EsYzaP\niHc2J+RqwV8NsX3P1KoKqJU8P8kBwIFRfEUxs5YkbRwR90paNfJUypZIujYiejYOYLQYzdWCtboC\naCX30T0938yqepGkn5GuBkZVl79eGjAieDnSFcHqQ2y+TBoL1YK1DwBmXfYVRmmXvx77YtP9Z0hr\nEryjP0Xpm1FfLegAYAZIehtwRUQ8nh+vBewaET8qm9do7fLXS+5a/fySk1dJ+maM0sWNHADMkuNz\nJwEAIuIxpYWCygaA+/LIz8iji4+k9wOgRgVJ+5K6Bz8/4K/Hc/D0laSv5JlUT1JeIKhZlFiUfqQ4\nAJglrRZH6uT30arL3xEVyjUm5TnwVwF2I02DsD8lZxZdBnwr//1CX0sxjNr3AjIDkDQLeAw4mdR/\n/QPA2hHx//pZrrFKeR3kpr+rAT+MiL3a7mw94ysAs+QDwH+Rpweh5Jm7pE8M83RExKeqFW/M+Xv+\n+6SkF5GmXqm6lveYlPv8n0AaXLg8S2ZW7fsMBA4AZkDus39MhSxa9flflbQS1bpA3QLAT3JD+udJ\n80QFvVsbebQ5kzTodB6jrEOAq4Cs1hoNdZJ+TOupC0o31ElanTQJ2nTgfOCLkdc7riNJK5Hm3nm8\n32XpB0lzImLHfpejFV8BWN11raEujyr/MGmFsbNJa/I+WjXfsUTS9sB9jYn8JB1KmoPrXkkn5IGX\ndXOlpM+TpgRvXiOi58tjDuQrALMuyD/wfwFmAiePtpWfeiXPqvqGiHgkD4A7j9S+sjXw8ogYFQOg\neklSq3muYjRMPeMAYLUmaT4tqn5Y0lC3ZcF8niOd3T0zIL+eLQo/Gki6tbGugqSTgcURcUJ+3NMV\nwaw9VwFZ3b25G5lERKtxBHU0TtLyEfEMsAcwo+m5Wh1vBsz/A+nE4GHS2tkL+1CkQfyltVqLiHsb\nN9IZ/FbAlsBTo3X4/ih3Lmn6g4tIXUGvAZD0UqBujcCrD7itQZoU72eS+r4YDLgKyAwASe8BPkFa\n2Eakxd0/GRGz+lqwMUjSTsAGpIXX/5bTNiMtit73hs9+y50FLhsN00E7AJgBku4Cdo6Iv+TH6wLX\nRcTm/S2ZLYsk3RwR2/S7HK4CMksWAU80PX4CuK9PZbFlWF5De1R0D65Vo4zZQE0NdX8C5uS66wCm\nUr/Jy6yLhuhhtg5wP3Bo70s0mAOA1V1joY4/5FvDRX0oiy1bBvYwC+Avo2mpULcBmJnVlK8AzHh+\ntGaruYD6PlrTbKQ4AJglH2m6vzJp/ppn+lQWs55wFZDZECRdFRGv73c5zEaKrwDMeH5wTsNywHbA\nC/tUHLOecAAwS+aR2gBEqvpZSJrP32yZ5SogM7Oa8hWAGSBpZeDfgV1IVwLXAqdGxD/6WjCzEeQr\nADNA0vmk6R++nZMOBtaOiAP6VyqzkeUAYMbSC5kMl2a2LPFkcGbJzXkaYwAk7Qj8qo/lMRtxvgIw\nAyTdCWwO/DEnTQLuBJ6jxNKQZmOJA4AZIGnj4Z736mC2LHIVkBnPH+A3AnbP9/8GLNe0XKTZMsdX\nAGaApONJ67VuHhGbSXoRcEFEvKbPRTMbMb4CMEveBuxHOvMnIu5nyVoBZsskBwCz5OlIl8MBIGnV\nPpfHbMQ5AJgl50s6HVhL0nuBy4Az+lwmsxHlNgCzTNKewF6kCeEuiYhL+1wksxHlAGDWgqRxwEER\n8Z1+l8VspLgKyGpN0hqSjpV0kqS9lLwfuBt4R7/LZzaSfAVgtSbpIuBR4NfAHsDawIrAURFxSz/L\nZjbSHACs1iTNj4hX5fvjgIeBSRHxRH9LZjbyXAVkdffPxp2IeBZY6IO/1YWvAKzWJD1LHvxF6v3z\nAuDJfD8iYo1+lc1spDkAmJnVlKuAzMxqygHAzKymHADMzGrKAcCWOZJC0hebHn9E0glt9tlV0s5N\njw+XdGiXyzVZ0u35/hRJX2v12ma9sny/C2A2Ap4C/kXS/0bEwwX32RX4P+A6gIg4bYTKRs5/LjC3\n1Wub9YqvAGxZ9AwwE/jQwCckvUXSHEk3S7pM0vqSJgOHAx+SdIuk10o6QdJH8j5bS7pe0m2SLpS0\ndk7/paTPSrpB0u8kvTanT5Z0jaSb8m3Q2X0+6//JEK+9UNIKebs1JN3TeGzWTQ4Atqw6GXinpDUH\npF8L7BQR2wDnAUdHxD3AacCXI2LriLhmwD7nAB/NC8PPB45vem75iNgB+GBT+kPAnhGxLXAg8LWh\nCjnEa/8S2DdvchDwg4j4Z+sczDrnKiBbJkXEXyWdAxwJ/L3pqYnA9yRtQJrzZ+Fw+eQAslZEXJWT\nzgYuaNrkh/nvPGByvr8CcJKkrYFngc1KFv8M4GjgR8BhwHtL7m9WiK8AbFn2FWA60Ly619eBk/L8\nP+8DVq74Gk/lv8+y5ITqQ8CDwFakdYZXLJNhRPwKmCzp9cC4iLi9YhnNWnIAsGVWRDwCnE8KAg1r\nAn/K96c1pT9BizWAI+Jx4NFG/T7wLuCqgdsNsCbwQEQ8l7cf12b7Vq99DnAucFabfc065gBgy7ov\nAuObHp8AXCDpGtLMnw0/Bt7WaIgdkMc04POSbgO2Bj7Z5jVPAaZJup5U/fO3Ntu3eu3vkKamPrfN\nvmYd81xAZqOQpP2BqRHxrn6XxZZdbgQ2G2UkfR3YB3hTv8tiyzZfAZiZ1ZTbAMzMasoBwMysphwA\nzMxqygHAzKymHADMzGrKAcDMrKb+P110+sJey2ZwAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x9b07ac8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#example plot\n",
    "player_df.groupby(\"Nationality\").Name.count().sort_values(ascending=False).head(20).plot(kind=\"bar\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from sklearn.ensemble import RandomForestClassifier\n",
    "from sklearn.model_selection import train_test_split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "train_data, test_data = train_test_split(fifa, test_size=0.20, random_state=0)\n",
    "#choose columns with player stats\n",
    "parameters = fifa.columns[17:53]\n",
    "#split into training - stats and rating\n",
    "X = train_data[parameters]\n",
    "Y = train_data.loc[:,'Rating'] #all rows of rating columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "rfclf = RandomForestClassifier()\n",
    "rfclf.fit(X, Y)\n",
    "prediction = rfclf.predict(test_data[parameters])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Predicted_Rating</th>\n",
       "      <th>difference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15213</th>\n",
       "      <td>Tetsuya Enomoto</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10311</th>\n",
       "      <td>Frederik Helstrup</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16351</th>\n",
       "      <td>Rikiya Uehara</td>\n",
       "      <td>55</td>\n",
       "      <td>54</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3553</th>\n",
       "      <td>Ji Dong Won</td>\n",
       "      <td>72</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16142</th>\n",
       "      <td>David Sauerland</td>\n",
       "      <td>56</td>\n",
       "      <td>60</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Name  Rating  Predicted_Rating  difference\n",
       "15213    Tetsuya Enomoto      58                56           2\n",
       "10311  Frederik Helstrup      65                65           0\n",
       "16351      Rikiya Uehara      55                54           1\n",
       "3553         Ji Dong Won      72                71           1\n",
       "16142    David Sauerland      56                60          -4"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output = test_data.loc[:,['Name','Rating']]\n",
    "output['Predicted_Rating'] = prediction\n",
    "output['difference']=output.loc[:,'Rating']-output.loc[:,'Predicted_Rating']\n",
    "output.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('Mean difference: ', 0.5832859579306424)\n",
      "('Exact match of predicted and actual:', 661)\n"
     ]
    }
   ],
   "source": [
    "print('Mean difference: ',output['difference'].mean())\n",
    "print('Exact match of predicted and actual:',len(output[output['difference']==0]))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}