predict_final.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>attempts_off_target_1</th>\n",
       "      <th>attempts_off_target_2</th>\n",
       "      <th>attempts_on_target_1</th>\n",
       "      <th>attempts_on_target_2</th>\n",
       "      <th>clearances_1</th>\n",
       "      <th>clearances_2</th>\n",
       "      <th>goals_against_1</th>\n",
       "      <th>goals_against_2</th>\n",
       "      <th>goals_scored_1</th>\n",
       "      <th>goals_scored_2</th>\n",
       "      <th>matches_played_1</th>\n",
       "      <th>matches_played_2</th>\n",
       "      <th>results</th>\n",
       "      <th>shots_attempted_1</th>\n",
       "      <th>shots_attempted_2</th>\n",
       "      <th>shots_blocked_1</th>\n",
       "      <th>shots_blocked_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>France</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>27</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>33</td>\n",
       "      <td>135</td>\n",
       "      <td>105</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56</td>\n",
       "      <td>85</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Team_1   Team_2  attempts_off_target_1  attempts_off_target_2  \\\n",
       "60  France  Belgium                     27                     32   \n",
       "\n",
       "    attempts_on_target_1  attempts_on_target_2  clearances_1  clearances_2  \\\n",
       "60                    19                    33           135           105   \n",
       "\n",
       "    goals_against_1  goals_against_2  goals_scored_1  goals_scored_2  \\\n",
       "60                4                5               8              13   \n",
       "\n",
       "    matches_played_1  matches_played_2  results  shots_attempted_1  \\\n",
       "60                 5                 5      NaN                 56   \n",
       "\n",
       "    shots_attempted_2  shots_blocked_1  shots_blocked_2  \n",
       "60                 85               10               20  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "# FIFA TEAM STATS FOR WC 2018 upto R16\n",
    "df = pd.read_csv('fifa_team_stats.csv')\n",
    "# MATCHES RESULTS IN WC 2018 upto R16\n",
    "matches = pd.read_csv('ALL_MATCHES.csv')\n",
    "matches[60:]\n",
    "#add_match = pd.DataFrame({'Team_1':'France', 'Team_2':'Belgium', 'attempts_off_target_1':27, 'attempts_off_target_2':32,'attempts_on_target_1':19,'attempts_on_target_2':33,'clearances_1':)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1.0\n",
       "1     0.0\n",
       "2     0.0\n",
       "3     0.0\n",
       "4     1.0\n",
       "5     1.0\n",
       "6     0.0\n",
       "7     1.0\n",
       "8     0.0\n",
       "9     0.0\n",
       "10    1.0\n",
       "11    1.0\n",
       "12    1.0\n",
       "13    0.0\n",
       "14    0.0\n",
       "15    0.0\n",
       "16    1.0\n",
       "17    1.0\n",
       "18    1.0\n",
       "19    0.0\n",
       "20    1.0\n",
       "21    1.0\n",
       "22    0.0\n",
       "23    1.0\n",
       "24    1.0\n",
       "25    0.0\n",
       "26    1.0\n",
       "27    0.0\n",
       "28    1.0\n",
       "29    1.0\n",
       "     ... \n",
       "31    0.0\n",
       "32    1.0\n",
       "33    1.0\n",
       "34    1.0\n",
       "35    0.0\n",
       "36    0.0\n",
       "37    0.0\n",
       "38    0.0\n",
       "39    0.0\n",
       "40    1.0\n",
       "41    0.0\n",
       "42    0.0\n",
       "43    1.0\n",
       "44    0.0\n",
       "45    0.0\n",
       "46    0.0\n",
       "47    0.0\n",
       "48    1.0\n",
       "49    1.0\n",
       "50    0.0\n",
       "51    1.0\n",
       "52    1.0\n",
       "53    1.0\n",
       "54    1.0\n",
       "55    0.0\n",
       "56    0.0\n",
       "57    0.0\n",
       "58    0.0\n",
       "59    0.0\n",
       "60    NaN\n",
       "Name: results, Length: 61, dtype: float64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches['results']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>attempts_off_target_1</th>\n",
       "      <th>attempts_off_target_2</th>\n",
       "      <th>attempts_on_target_1</th>\n",
       "      <th>attempts_on_target_2</th>\n",
       "      <th>clearances_1</th>\n",
       "      <th>clearances_2</th>\n",
       "      <th>goals_against_1</th>\n",
       "      <th>goals_against_2</th>\n",
       "      <th>goals_scored_1</th>\n",
       "      <th>goals_scored_2</th>\n",
       "      <th>matches_played_1</th>\n",
       "      <th>matches_played_2</th>\n",
       "      <th>results</th>\n",
       "      <th>shots_attempted_1</th>\n",
       "      <th>shots_attempted_2</th>\n",
       "      <th>shots_blocked_1</th>\n",
       "      <th>shots_blocked_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>France</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.250000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>13.250000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>21.800000</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.200000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>4.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Russia</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>2.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>26.250000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>1.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>23.750000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>14.250000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>Japan</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>3.750000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>37.400000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>2.400000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>England</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>25.750000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.750000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>4.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>France</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>21.800000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.200000</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>7.600000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>18.200000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.600000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>England</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>37.400000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>2.400000</td>\n",
       "      <td>4.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Russia</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>France</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>Russia</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>22.333333</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>2.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>21.800000</td>\n",
       "      <td>31.666667</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.200000</td>\n",
       "      <td>9.666667</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>2.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Iran</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>30.333333</td>\n",
       "      <td>20.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>11.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>2.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>4.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Australia</td>\n",
       "      <td>France</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>27.666667</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>6.333333</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>26.666667</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>2.250000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>13.250000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>4.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>Peru</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>26.250000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>2.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Serbia</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>25.333333</td>\n",
       "      <td>32.333333</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>9.333333</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>Germany</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>6.666667</td>\n",
       "      <td>23.750000</td>\n",
       "      <td>11.666667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.250000</td>\n",
       "      <td>22.333333</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>7.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>7.600000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>18.200000</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>20.600000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Korea Republic</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>31.333333</td>\n",
       "      <td>37.400000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>2.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Panama</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>24.333333</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.666667</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>England</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>19.333333</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>3.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Japan</td>\n",
       "      <td>Columbia</td>\n",
       "      <td>3.750000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>25.750000</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>9.750000</td>\n",
       "      <td>2.750000</td>\n",
       "      <td>3.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Senegal</td>\n",
       "      <td>Poland</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>24.666667</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Egypt</td>\n",
       "      <td>Russia</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>31.666667</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.666667</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>2.200000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>Poland</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>25.750000</td>\n",
       "      <td>24.666667</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.750000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Russia</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>21.800000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>12.200000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Egypt</td>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>31.666667</td>\n",
       "      <td>22.333333</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.666667</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>3.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Morocco</td>\n",
       "      <td>Spain</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>20.666667</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.666667</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>5.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>Iran</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>30.333333</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Peru</td>\n",
       "      <td>Australia</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>27.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>3.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>France</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>26.250000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>2.250000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.250000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>4.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>Iceland</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>6.333333</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>26.666667</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>1.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Germany</td>\n",
       "      <td>Korea Republic</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>6.666667</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>11.666667</td>\n",
       "      <td>31.333333</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.333333</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>7.666667</td>\n",
       "      <td>4.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>37.400000</td>\n",
       "      <td>23.750000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>14.250000</td>\n",
       "      <td>2.400000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>Serbia</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>7.600000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>18.200000</td>\n",
       "      <td>25.333333</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.600000</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>2.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>32.333333</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.333333</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Poland</td>\n",
       "      <td>Japan</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>3.750000</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>24.666667</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>2.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>Columbia</td>\n",
       "      <td>Senegal</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>25.750000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.750000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>1.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Panama</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>19.333333</td>\n",
       "      <td>24.333333</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>7.666667</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>England</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>France</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>2.250000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.250000</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>21.800000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>12.200000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Russia</td>\n",
       "      <td>Spain</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>5.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>26.250000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>Spain</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>23.750000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.250000</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Japan</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>3.750000</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>2.750000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>37.400000</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>2.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>England</td>\n",
       "      <td>Columbia</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>25.750000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>9.750000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>3.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>France</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>21.800000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>1.200000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>12.200000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>7.600000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>18.200000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>20.600000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>England</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>37.400000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>2.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>Russia</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>France</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>74 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Team_1          Team_2  attempts_off_target_1  \\\n",
       "48           France       Argentina               5.400000   \n",
       "49          Uruguay        Portugal               5.200000   \n",
       "50            Spain          Russia               7.000000   \n",
       "51          Croatia         Denmark               7.800000   \n",
       "52            Spain          Mexico               7.000000   \n",
       "53          Belgium           Japan               6.400000   \n",
       "54           Sweden     Switzerland               4.400000   \n",
       "55         Columbia         England               3.500000   \n",
       "56          Uruguay          France               5.200000   \n",
       "57           Brazil         Belgium               7.000000   \n",
       "58           Sweden         England               4.400000   \n",
       "59           Russia         Croatia               3.200000   \n",
       "60           France         Belgium               5.400000   \n",
       "61     Saudi Arabia          Russia               5.333333   \n",
       "62          Uruguay           Egypt               5.200000   \n",
       "63             Iran         Morocco               5.000000   \n",
       "64            Spain        Portugal               7.000000   \n",
       "65        Australia          France               4.666667   \n",
       "66          Iceland       Argentina               6.333333   \n",
       "67          Denmark            Peru               5.500000   \n",
       "68          Nigeria         Croatia               5.333333   \n",
       "69           Serbia      Costa Rica               5.666667   \n",
       "70           Mexico         Germany               6.000000   \n",
       "71      Switzerland          Brazil               5.500000   \n",
       "72   Korea Republic          Sweden               3.000000   \n",
       "73           Panama         Belgium               4.333333   \n",
       "74          England         Tunisia               6.000000   \n",
       "75            Japan        Columbia               3.750000   \n",
       "76          Senegal          Poland               4.333333   \n",
       "77            Egypt          Russia               5.666667   \n",
       "..              ...             ...                    ...   \n",
       "92         Columbia          Poland               3.500000   \n",
       "93           Russia         Uruguay               3.200000   \n",
       "94            Egypt    Saudi Arabia               5.666667   \n",
       "95          Morocco           Spain               6.000000   \n",
       "96         Portugal            Iran               5.000000   \n",
       "97             Peru       Australia               4.666667   \n",
       "98           France         Denmark               5.400000   \n",
       "99        Argentina         Nigeria               4.000000   \n",
       "100         Croatia         Iceland               7.800000   \n",
       "101         Germany  Korea Republic               8.000000   \n",
       "102          Sweden          Mexico               4.400000   \n",
       "103          Brazil          Serbia               7.000000   \n",
       "104      Costa Rica     Switzerland               4.333333   \n",
       "105          Poland           Japan               4.333333   \n",
       "106        Columbia         Senegal               3.500000   \n",
       "107         Tunisia          Panama               4.333333   \n",
       "108         Belgium         England               6.400000   \n",
       "109       Argentina          France               4.000000   \n",
       "110        Portugal         Uruguay               5.000000   \n",
       "111          Russia           Spain               3.200000   \n",
       "112         Denmark         Croatia               5.500000   \n",
       "113          Mexico           Spain               6.000000   \n",
       "114           Japan         Belgium               3.750000   \n",
       "115     Switzerland          Sweden               5.500000   \n",
       "116         England        Columbia               6.000000   \n",
       "117          France         Uruguay               5.400000   \n",
       "118         Belgium          Brazil               6.400000   \n",
       "119         England          Sweden               6.000000   \n",
       "120         Croatia          Russia               7.800000   \n",
       "121         Belgium          France               6.400000   \n",
       "\n",
       "     attempts_off_target_2  attempts_on_target_1  attempts_on_target_2  \\\n",
       "48                4.000000              3.800000              4.500000   \n",
       "49                5.000000              4.400000              3.500000   \n",
       "50                3.200000              5.250000              3.800000   \n",
       "51                5.500000              3.800000              3.000000   \n",
       "52                6.000000              5.250000              3.250000   \n",
       "53                3.750000              6.600000              4.000000   \n",
       "54                5.500000              4.200000              3.500000   \n",
       "55                6.000000              3.000000              3.800000   \n",
       "56                5.400000              4.400000              3.800000   \n",
       "57                6.400000              7.600000              6.600000   \n",
       "58                6.000000              4.200000              3.800000   \n",
       "59                7.800000              3.800000              3.800000   \n",
       "60                6.400000              3.800000              6.600000   \n",
       "61                3.200000              3.333333              3.800000   \n",
       "62                5.666667              4.400000              1.666667   \n",
       "63                6.000000              1.333333              3.333333   \n",
       "64                5.000000              5.250000              3.500000   \n",
       "65                5.400000              2.666667              3.800000   \n",
       "66                4.000000              4.000000              4.500000   \n",
       "67                4.666667              3.000000              3.666667   \n",
       "68                7.800000              3.000000              3.800000   \n",
       "69                4.333333              2.333333              3.000000   \n",
       "70                8.000000              3.250000              6.666667   \n",
       "71                7.000000              3.500000              7.600000   \n",
       "72                4.400000              3.666667              4.200000   \n",
       "73                6.400000              2.666667              6.600000   \n",
       "74                4.333333              3.800000              4.333333   \n",
       "75                3.500000              4.000000              3.000000   \n",
       "76                4.333333              4.000000              2.666667   \n",
       "77                3.200000              1.666667              3.800000   \n",
       "..                     ...                   ...                   ...   \n",
       "92                4.333333              3.000000              2.666667   \n",
       "93                5.200000              3.800000              4.400000   \n",
       "94                5.333333              1.666667              3.333333   \n",
       "95                7.000000              3.333333              5.250000   \n",
       "96                5.000000              3.500000              1.333333   \n",
       "97                4.666667              3.666667              2.666667   \n",
       "98                5.500000              3.800000              3.000000   \n",
       "99                5.333333              4.500000              3.000000   \n",
       "100               6.333333              3.800000              4.000000   \n",
       "101               3.000000              6.666667              3.666667   \n",
       "102               6.000000              4.200000              3.250000   \n",
       "103               5.666667              7.600000              2.333333   \n",
       "104               5.500000              3.000000              3.500000   \n",
       "105               3.750000              2.666667              4.000000   \n",
       "106               4.333333              3.000000              4.000000   \n",
       "107               4.333333              4.333333              2.666667   \n",
       "108               6.000000              6.600000              3.800000   \n",
       "109               5.400000              4.500000              3.800000   \n",
       "110               5.200000              3.500000              4.400000   \n",
       "111               7.000000              3.800000              5.250000   \n",
       "112               7.800000              3.000000              3.800000   \n",
       "113               7.000000              3.250000              5.250000   \n",
       "114               6.400000              4.000000              6.600000   \n",
       "115               4.400000              3.500000              4.200000   \n",
       "116               3.500000              3.800000              3.000000   \n",
       "117               5.200000              3.800000              4.400000   \n",
       "118               7.000000              6.600000              7.600000   \n",
       "119               4.400000              3.800000              4.200000   \n",
       "120               3.200000              3.800000              3.800000   \n",
       "121               5.400000              6.600000              3.800000   \n",
       "\n",
       "     clearances_1  clearances_2  goals_against_1  goals_against_2  \\\n",
       "48      27.000000     18.000000         0.800000         2.250000   \n",
       "49      21.800000     21.750000         0.600000         1.500000   \n",
       "50       9.000000     35.200000         1.500000         1.400000   \n",
       "51      28.800000     26.250000         0.800000         0.500000   \n",
       "52       9.000000     23.750000         1.500000         1.500000   \n",
       "53      21.000000     30.500000         1.000000         1.750000   \n",
       "54      37.400000     16.000000         0.800000         1.250000   \n",
       "55      25.750000     15.600000         0.750000         0.800000   \n",
       "56      21.800000     27.000000         0.600000         0.800000   \n",
       "57      18.200000     21.000000         0.600000         1.000000   \n",
       "58      37.400000     15.600000         0.800000         0.800000   \n",
       "59      35.200000     28.800000         1.400000         0.800000   \n",
       "60      27.000000     21.000000         0.800000         1.000000   \n",
       "61      22.333333     35.200000         2.333333         1.400000   \n",
       "62      21.800000     31.666667         0.600000         2.000000   \n",
       "63      30.333333     20.666667         0.666667         1.333333   \n",
       "64       9.000000     21.750000         1.500000         1.500000   \n",
       "65      27.666667     27.000000         1.666667         0.800000   \n",
       "66      26.666667     18.000000         1.666667         2.250000   \n",
       "67      26.250000     20.000000         0.500000         0.666667   \n",
       "68      32.000000     28.800000         1.333333         0.800000   \n",
       "69      25.333333     32.333333         1.333333         1.666667   \n",
       "70      23.750000     11.666667         1.500000         1.333333   \n",
       "71      16.000000     18.200000         1.250000         0.600000   \n",
       "72      31.333333     37.400000         1.000000         0.800000   \n",
       "73      24.333333     21.000000         3.666667         1.000000   \n",
       "74      15.600000     19.333333         0.800000         2.666667   \n",
       "75      30.500000     25.750000         1.750000         0.750000   \n",
       "76      31.000000     24.666667         1.333333         1.666667   \n",
       "77      31.666667     35.200000         2.000000         1.400000   \n",
       "..            ...           ...              ...              ...   \n",
       "92      25.750000     24.666667         0.750000         1.666667   \n",
       "93      35.200000     21.800000         1.400000         0.600000   \n",
       "94      31.666667     22.333333         2.000000         2.333333   \n",
       "95      20.666667      9.000000         1.333333         1.500000   \n",
       "96      21.750000     30.333333         1.500000         0.666667   \n",
       "97      20.000000     27.666667         0.666667         1.666667   \n",
       "98      27.000000     26.250000         0.800000         0.500000   \n",
       "99      18.000000     32.000000         2.250000         1.333333   \n",
       "100     28.800000     26.666667         0.800000         1.666667   \n",
       "101     11.666667     31.333333         1.333333         1.000000   \n",
       "102     37.400000     23.750000         0.800000         1.500000   \n",
       "103     18.200000     25.333333         0.600000         1.333333   \n",
       "104     32.333333     16.000000         1.666667         1.250000   \n",
       "105     24.666667     30.500000         1.666667         1.750000   \n",
       "106     25.750000     31.000000         0.750000         1.333333   \n",
       "107     19.333333     24.333333         2.666667         3.666667   \n",
       "108     21.000000     15.600000         1.000000         0.800000   \n",
       "109     18.000000     27.000000         2.250000         0.800000   \n",
       "110     21.750000     21.800000         1.500000         0.600000   \n",
       "111     35.200000      9.000000         1.400000         1.500000   \n",
       "112     26.250000     28.800000         0.500000         0.800000   \n",
       "113     23.750000      9.000000         1.500000         1.500000   \n",
       "114     30.500000     21.000000         1.750000         1.000000   \n",
       "115     16.000000     37.400000         1.250000         0.800000   \n",
       "116     15.600000     25.750000         0.800000         0.750000   \n",
       "117     27.000000     21.800000         0.800000         0.600000   \n",
       "118     21.000000     18.200000         1.000000         0.600000   \n",
       "119     15.600000     37.400000         0.800000         0.800000   \n",
       "120     28.800000     35.200000         0.800000         1.400000   \n",
       "121     21.000000     27.000000         1.000000         0.800000   \n",
       "\n",
       "     goals_scored_1  goals_scored_2  matches_played_1  matches_played_2  \\\n",
       "48         1.600000        1.500000                 5                 4   \n",
       "49         1.200000        1.500000                 5                 4   \n",
       "50         1.500000        2.000000                 4                 5   \n",
       "51         1.800000        0.750000                 5                 4   \n",
       "52         1.500000        0.750000                 4                 4   \n",
       "53         2.600000        1.500000                 5                 4   \n",
       "54         1.000000        1.250000                 5                 4   \n",
       "55         1.500000        2.200000                 4                 5   \n",
       "56         1.200000        1.600000                 5                 5   \n",
       "57         1.600000        2.600000                 5                 5   \n",
       "58         1.000000        2.200000                 5                 5   \n",
       "59         2.000000        1.800000                 5                 5   \n",
       "60         1.600000        2.600000                 5                 5   \n",
       "61         0.666667        2.000000                 3                 5   \n",
       "62         1.200000        0.666667                 5                 3   \n",
       "63         0.333333        0.666667                 3                 3   \n",
       "64         1.500000        1.500000                 4                 4   \n",
       "65         0.666667        1.600000                 3                 5   \n",
       "66         0.666667        1.500000                 3                 4   \n",
       "67         0.750000        0.666667                 4                 3   \n",
       "68         1.000000        1.800000                 3                 5   \n",
       "69         0.666667        0.333333                 3                 3   \n",
       "70         0.750000        0.666667                 4                 3   \n",
       "71         1.250000        1.600000                 4                 5   \n",
       "72         1.000000        1.000000                 3                 5   \n",
       "73         0.333333        2.600000                 3                 5   \n",
       "74         2.200000        1.666667                 5                 3   \n",
       "75         1.500000        1.500000                 4                 4   \n",
       "76         1.000000        0.666667                 3                 3   \n",
       "77         0.666667        2.000000                 3                 5   \n",
       "..              ...             ...               ...               ...   \n",
       "92         1.500000        0.666667                 4                 3   \n",
       "93         2.000000        1.200000                 5                 5   \n",
       "94         0.666667        0.666667                 3                 3   \n",
       "95         0.666667        1.500000                 3                 4   \n",
       "96         1.500000        0.333333                 4                 3   \n",
       "97         0.666667        0.666667                 3                 3   \n",
       "98         1.600000        0.750000                 5                 4   \n",
       "99         1.500000        1.000000                 4                 3   \n",
       "100        1.800000        0.666667                 5                 3   \n",
       "101        0.666667        1.000000                 3                 3   \n",
       "102        1.000000        0.750000                 5                 4   \n",
       "103        1.600000        0.666667                 5                 3   \n",
       "104        0.333333        1.250000                 3                 4   \n",
       "105        0.666667        1.500000                 3                 4   \n",
       "106        1.500000        1.000000                 4                 3   \n",
       "107        1.666667        0.333333                 3                 3   \n",
       "108        2.600000        2.200000                 5                 5   \n",
       "109        1.500000        1.600000                 4                 5   \n",
       "110        1.500000        1.200000                 4                 5   \n",
       "111        2.000000        1.500000                 5                 4   \n",
       "112        0.750000        1.800000                 4                 5   \n",
       "113        0.750000        1.500000                 4                 4   \n",
       "114        1.500000        2.600000                 4                 5   \n",
       "115        1.250000        1.000000                 4                 5   \n",
       "116        2.200000        1.500000                 5                 4   \n",
       "117        1.600000        1.200000                 5                 5   \n",
       "118        2.600000        1.600000                 5                 5   \n",
       "119        2.200000        1.000000                 5                 5   \n",
       "120        1.800000        2.000000                 5                 5   \n",
       "121        2.600000        1.600000                 5                 5   \n",
       "\n",
       "     results  shots_attempted_1  shots_attempted_2  shots_blocked_1  \\\n",
       "48       1.0          11.200000          13.250000         2.000000   \n",
       "49       1.0          12.200000          13.000000         2.600000   \n",
       "50       0.0          17.500000           9.200000         5.250000   \n",
       "51       1.0          15.600000          10.000000         4.000000   \n",
       "52       1.0          17.500000          14.250000         5.250000   \n",
       "53       1.0          17.000000          10.500000         4.000000   \n",
       "54       1.0          11.000000          14.000000         2.400000   \n",
       "55       0.0           9.750000          14.000000         3.250000   \n",
       "56       0.0          12.200000          11.200000         2.600000   \n",
       "57       0.0          20.600000          17.000000         6.000000   \n",
       "58       0.0          11.000000          14.000000         2.400000   \n",
       "59       0.0           9.200000          15.600000         2.200000   \n",
       "60       NaN          11.200000          17.000000         2.000000   \n",
       "61       0.0          12.000000           9.200000         3.333333   \n",
       "62       1.0          12.200000           9.666667         2.600000   \n",
       "63       1.0           7.000000          11.666667         0.666667   \n",
       "64       1.0          17.500000          13.000000         5.250000   \n",
       "65       0.0          10.666667          11.200000         3.333333   \n",
       "66       0.0          12.000000          13.250000         1.666667   \n",
       "67       1.0          10.000000          10.666667         1.500000   \n",
       "68       0.0          13.000000          15.600000         4.666667   \n",
       "69       1.0          10.666667           9.333333         2.666667   \n",
       "70       1.0          14.250000          22.333333         5.000000   \n",
       "71       0.0          14.000000          20.600000         5.000000   \n",
       "72       0.0          11.000000          11.000000         4.333333   \n",
       "73       0.0           7.666667          17.000000         0.666667   \n",
       "74       1.0          14.000000          12.000000         4.200000   \n",
       "75       1.0          10.500000           9.750000         2.750000   \n",
       "76       1.0          10.000000          10.000000         1.666667   \n",
       "77       0.0           9.666667           9.200000         2.333333   \n",
       "..       ...                ...                ...              ...   \n",
       "92       1.0           9.750000          10.000000         3.250000   \n",
       "93       0.0           9.200000          12.200000         2.200000   \n",
       "94       0.0           9.666667          12.000000         2.333333   \n",
       "95       0.0          11.666667          17.500000         2.333333   \n",
       "96       1.0          13.000000           7.000000         4.500000   \n",
       "97       1.0          10.666667          10.666667         2.333333   \n",
       "98       1.0          11.200000          10.000000         2.000000   \n",
       "99       1.0          13.250000          13.000000         4.750000   \n",
       "100      1.0          15.600000          12.000000         4.000000   \n",
       "101      0.0          22.333333          11.000000         7.666667   \n",
       "102      1.0          11.000000          14.250000         2.400000   \n",
       "103      1.0          20.600000          10.666667         6.000000   \n",
       "104      0.0           9.333333          14.000000         2.000000   \n",
       "105      1.0          10.000000          10.500000         3.000000   \n",
       "106      1.0           9.750000          10.000000         3.250000   \n",
       "107      1.0          12.000000           7.666667         3.333333   \n",
       "108      1.0          17.000000          14.000000         4.000000   \n",
       "109      0.0          13.250000          11.200000         4.750000   \n",
       "110      0.0          13.000000          12.200000         4.500000   \n",
       "111      1.0           9.200000          17.500000         2.200000   \n",
       "112      0.0          10.000000          15.600000         1.500000   \n",
       "113      0.0          14.250000          17.500000         5.000000   \n",
       "114      0.0          10.500000          17.000000         2.750000   \n",
       "115      0.0          14.000000          11.000000         5.000000   \n",
       "116      1.0          14.000000           9.750000         4.200000   \n",
       "117      1.0          11.200000          12.200000         2.000000   \n",
       "118      1.0          17.000000          20.600000         4.000000   \n",
       "119      1.0          14.000000          11.000000         4.200000   \n",
       "120      1.0          15.600000           9.200000         4.000000   \n",
       "121      NaN          17.000000          11.200000         4.000000   \n",
       "\n",
       "     shots_blocked_2  \n",
       "48          4.750000  \n",
       "49          4.500000  \n",
       "50          2.200000  \n",
       "51          1.500000  \n",
       "52          5.000000  \n",
       "53          2.750000  \n",
       "54          5.000000  \n",
       "55          4.200000  \n",
       "56          2.000000  \n",
       "57          4.000000  \n",
       "58          4.200000  \n",
       "59          4.000000  \n",
       "60          4.000000  \n",
       "61          2.200000  \n",
       "62          2.333333  \n",
       "63          2.333333  \n",
       "64          4.500000  \n",
       "65          2.000000  \n",
       "66          4.750000  \n",
       "67          2.333333  \n",
       "68          4.000000  \n",
       "69          2.000000  \n",
       "70          7.666667  \n",
       "71          6.000000  \n",
       "72          2.400000  \n",
       "73          4.000000  \n",
       "74          3.333333  \n",
       "75          3.250000  \n",
       "76          3.000000  \n",
       "77          2.200000  \n",
       "..               ...  \n",
       "92          3.000000  \n",
       "93          2.600000  \n",
       "94          3.333333  \n",
       "95          5.250000  \n",
       "96          0.666667  \n",
       "97          3.333333  \n",
       "98          1.500000  \n",
       "99          4.666667  \n",
       "100         1.666667  \n",
       "101         4.333333  \n",
       "102         5.000000  \n",
       "103         2.666667  \n",
       "104         5.000000  \n",
       "105         2.750000  \n",
       "106         1.666667  \n",
       "107         0.666667  \n",
       "108         4.200000  \n",
       "109         2.000000  \n",
       "110         2.600000  \n",
       "111         5.250000  \n",
       "112         4.000000  \n",
       "113         5.250000  \n",
       "114         4.000000  \n",
       "115         2.400000  \n",
       "116         3.250000  \n",
       "117         2.600000  \n",
       "118         6.000000  \n",
       "119         2.400000  \n",
       "120         2.200000  \n",
       "121         2.000000  \n",
       "\n",
       "[74 rows x 19 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Normailizing\n",
    "matches['goals_scored_1']=matches['goals_scored_1']/matches['matches_played_1']\n",
    "\n",
    "matches['goals_scored_2']=matches['goals_scored_2']/matches['matches_played_2']\n",
    "\n",
    "matches['goals_against_2']=matches['goals_against_2']/matches['matches_played_2']\n",
    "\n",
    "matches['attempts_on_target_2']=matches['attempts_on_target_2']/matches['matches_played_2']\n",
    "\n",
    "matches['shots_attempted_2']=matches['shots_attempted_2']/matches['matches_played_2']\n",
    "\n",
    "matches['attempts_off_target_2']=matches['attempts_off_target_2']/matches['matches_played_2']\n",
    "\n",
    "matches['shots_blocked_2']=matches['shots_blocked_2']/matches['matches_played_2']\n",
    "\n",
    "matches['clearances_2']=matches['clearances_2']/matches['matches_played_2']\n",
    "\n",
    "matches['goals_against_1']=matches['goals_against_1']/matches['matches_played_1']\n",
    "\n",
    "matches['attempts_on_target_1']=matches['attempts_on_target_1']/matches['matches_played_1']\n",
    "\n",
    "matches['shots_attempted_1']=matches['shots_attempted_1']/matches['matches_played_1']\n",
    "\n",
    "matches['attempts_off_target_1']=matches['attempts_off_target_1']/matches['matches_played_1']\n",
    "\n",
    "matches['shots_blocked_1']=matches['shots_blocked_1']/matches['matches_played_1']\n",
    "\n",
    "matches['clearances_1']=matches['clearances_1']/matches['matches_played_1']\n",
    "\n",
    "matches.head()\n",
    "matches_2 = pd.DataFrame()\n",
    "visited=[]\n",
    "for col in matches.columns:\n",
    "    c_name = str(col)\n",
    "    if ('result' not in c_name):\n",
    "        col_names = c_name.split('_')\n",
    "        y = len(col_names)\n",
    "        c_name_2 = \"\"\n",
    "        for j in range(y-1):\n",
    "            if (c_name_2):\n",
    "                c_name_2 = c_name_2 + \"_\"\n",
    "            c_name_2=c_name_2 + col_names[j]\n",
    "        if (c_name_2 not in visited):\n",
    "            matches_2[c_name_2+\"_2\"]=matches[col]\n",
    "            visited.append(c_name_2)\n",
    "        else:\n",
    "            matches_2[c_name_2+\"_1\"]=matches[col]\n",
    "    else:\n",
    "        matches_2['results']=1-matches['results']\n",
    "matches_2.head()\n",
    "matches=matches.append(matches_2)\n",
    "matches = matches.reset_index(drop=True)\n",
    "\n",
    "matches[matches['Team_1']=='Russia']\n",
    "matches[48:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "120\n"
     ]
    }
   ],
   "source": [
    "res=[5,0,0,3,2,1,0,2,0,0,1,1,3,1,1,1,3,1,1,0,1,1,0,2,2,1,5,1,2,6,2,0,3,2,2,1,0,0,1,1,2,0,0,2,0,0,1,0,4,2,1,1,2,3,1,1,0,1,0,2,0,1,1,3,1,1,1,0,1,1,1,0,0,2,2,2,1,0,0,1,1,0,3,0,0,2,2,2,1,1,2,3,0,1,2,1,2,0,2,2,0,3,2,2,1,1,2,1,3,1,1,1,0,2,0,1,2,2,2,2]\n",
    "print (len(res))\n",
    "res.insert(60,1)\n",
    "res.append(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>attempts_off_target_1</th>\n",
       "      <th>attempts_off_target_2</th>\n",
       "      <th>attempts_on_target_1</th>\n",
       "      <th>attempts_on_target_2</th>\n",
       "      <th>clearances_1</th>\n",
       "      <th>clearances_2</th>\n",
       "      <th>goals_against_1</th>\n",
       "      <th>goals_against_2</th>\n",
       "      <th>...</th>\n",
       "      <th>shots_attempted_2</th>\n",
       "      <th>shots_blocked_1</th>\n",
       "      <th>shots_blocked_2</th>\n",
       "      <th>diff_goals_scored</th>\n",
       "      <th>diff_goals_against</th>\n",
       "      <th>diff_attempts_on_target</th>\n",
       "      <th>diff_shots_attempted</th>\n",
       "      <th>diff_attempts_off_target</th>\n",
       "      <th>diff_shots_blocked</th>\n",
       "      <th>diff_clearances</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Russia</td>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>35.200000</td>\n",
       "      <td>22.333333</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>...</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>2.200000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>-0.933333</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>-2.800000</td>\n",
       "      <td>-2.133333</td>\n",
       "      <td>-1.133333</td>\n",
       "      <td>12.866667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Egypt</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>31.666667</td>\n",
       "      <td>21.800000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>...</td>\n",
       "      <td>12.200000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>-0.533333</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>-2.733333</td>\n",
       "      <td>-2.533333</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>-0.266667</td>\n",
       "      <td>9.866667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Morocco</td>\n",
       "      <td>Iran</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>20.666667</td>\n",
       "      <td>30.333333</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>...</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>-9.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>Spain</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-1.750000</td>\n",
       "      <td>-4.500000</td>\n",
       "      <td>-2.000000</td>\n",
       "      <td>-0.750000</td>\n",
       "      <td>12.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>France</td>\n",
       "      <td>Australia</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>27.666667</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>...</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>0.933333</td>\n",
       "      <td>-0.866667</td>\n",
       "      <td>1.133333</td>\n",
       "      <td>0.533333</td>\n",
       "      <td>0.733333</td>\n",
       "      <td>-1.333333</td>\n",
       "      <td>-0.666667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Team_1        Team_2  attempts_off_target_1  attempts_off_target_2  \\\n",
       "0    Russia  Saudi Arabia               3.200000               5.333333   \n",
       "1     Egypt       Uruguay               5.666667               5.200000   \n",
       "2   Morocco          Iran               6.000000               5.000000   \n",
       "3  Portugal         Spain               5.000000               7.000000   \n",
       "4    France     Australia               5.400000               4.666667   \n",
       "\n",
       "   attempts_on_target_1  attempts_on_target_2  clearances_1  clearances_2  \\\n",
       "0              3.800000              3.333333     35.200000     22.333333   \n",
       "1              1.666667              4.400000     31.666667     21.800000   \n",
       "2              3.333333              1.333333     20.666667     30.333333   \n",
       "3              3.500000              5.250000     21.750000      9.000000   \n",
       "4              3.800000              2.666667     27.000000     27.666667   \n",
       "\n",
       "   goals_against_1  goals_against_2       ...         shots_attempted_2  \\\n",
       "0         1.400000         2.333333       ...                 12.000000   \n",
       "1         2.000000         0.600000       ...                 12.200000   \n",
       "2         1.333333         0.666667       ...                  7.000000   \n",
       "3         1.500000         1.500000       ...                 17.500000   \n",
       "4         0.800000         1.666667       ...                 10.666667   \n",
       "\n",
       "   shots_blocked_1  shots_blocked_2  diff_goals_scored  diff_goals_against  \\\n",
       "0         2.200000         3.333333           1.333333           -0.933333   \n",
       "1         2.333333         2.600000          -0.533333            1.400000   \n",
       "2         2.333333         0.666667           0.333333            0.666667   \n",
       "3         4.500000         5.250000           0.000000            0.000000   \n",
       "4         2.000000         3.333333           0.933333           -0.866667   \n",
       "\n",
       "   diff_attempts_on_target  diff_shots_attempted  diff_attempts_off_target  \\\n",
       "0                 0.466667             -2.800000                 -2.133333   \n",
       "1                -2.733333             -2.533333                  0.466667   \n",
       "2                 2.000000              4.666667                  1.000000   \n",
       "3                -1.750000             -4.500000                 -2.000000   \n",
       "4                 1.133333              0.533333                  0.733333   \n",
       "\n",
       "   diff_shots_blocked  diff_clearances  \n",
       "0           -1.133333        12.866667  \n",
       "1           -0.266667         9.866667  \n",
       "2            1.666667        -9.666667  \n",
       "3           -0.750000        12.750000  \n",
       "4           -1.333333        -0.666667  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Difference in Opposing Teams\n",
    "matches['results']=res\n",
    "matches['diff_goals_scored']=matches['goals_scored_1']-matches['goals_scored_2']\n",
    "\n",
    "matches['diff_goals_against']=matches['goals_against_1']-matches['goals_against_2']\n",
    "\n",
    "matches['diff_attempts_on_target']=matches['attempts_on_target_1']-matches['attempts_on_target_2']\n",
    "\n",
    "matches['diff_shots_attempted']=matches['shots_attempted_1']-matches['shots_attempted_2']\n",
    "\n",
    "matches['diff_attempts_off_target']=matches['attempts_off_target_1']-matches['attempts_off_target_2']\n",
    "\n",
    "matches['diff_shots_blocked']=matches['shots_blocked_1']-matches['shots_blocked_2']\n",
    "\n",
    "matches['diff_clearances']=matches['clearances_1']-matches['clearances_2']\n",
    "\n",
    "matches.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    5\n",
       "1    0\n",
       "2    0\n",
       "3    3\n",
       "4    2\n",
       "Name: results, dtype: int64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Training Data\n",
    "columns_of_interest = ['diff_goals_scored','diff_goals_against','diff_attempts_on_target','diff_shots_attempted','diff_attempts_off_target','diff_shots_blocked','diff_clearances']    \n",
    "\n",
    "train_X = matches[columns_of_interest]\n",
    "\n",
    "train_Y = matches['results']\n",
    "\n",
    "from sklearn.ensemble import RandomForestRegressor\n",
    "\n",
    "rf = RandomForestRegressor(n_estimators=100)\n",
    "\n",
    "train_X[train_X.isnull()]\n",
    "train_X=train_X.dropna()\n",
    "\n",
    "rf.fit(train_X,train_Y)\n",
    "train_Y.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Function to return weight of wining of team_1 against team_2\n",
    "\n",
    "def winning_probability (team_1,team_2):\n",
    "    test_matches = pd.DataFrame()\n",
    "    \n",
    "    for i in range(len(team_1)):\n",
    "        first = pd.DataFrame(df[df['Team']==team_1[i]])\n",
    "        second = pd.DataFrame(df[df['Team']==team_2[i]])\n",
    "        first = first.reset_index(drop=True)\n",
    "        second = second.reset_index(drop=True)\n",
    "        res = pd.DataFrame()\n",
    "\n",
    "        for col in df.columns:\n",
    "            res[col+\"_1\"]=pd.DataFrame(first[col])\n",
    "            res[col+\"_2\"]=pd.DataFrame(second[col])\n",
    "\t\t\t\n",
    "        test_matches = test_matches.append(res)\n",
    "        \n",
    "        test_matches['goals_scored_1']=test_matches['goals_scored_1']/test_matches['matches_played_1']\n",
    "\n",
    "        test_matches['goals_scored_2']=test_matches['goals_scored_2']/test_matches['matches_played_2']\n",
    "\n",
    "        test_matches['goals_against_2']=test_matches['goals_against_2']/test_matches['matches_played_2']\n",
    "\n",
    "        test_matches['attempts_on_target_2']=test_matches['attempts_on_target_2']/test_matches['matches_played_2']\n",
    "\n",
    "        test_matches['shots_attempted_2']=test_matches['shots_attempted_2']/test_matches['matches_played_2']\n",
    "\n",
    "        test_matches['attempts_off_target_2']=test_matches['attempts_off_target_2']/test_matches['matches_played_2']\n",
    "\n",
    "        test_matches['shots_blocked_2']=test_matches['shots_blocked_2']/test_matches['matches_played_2']\n",
    "\n",
    "        test_matches['clearances_2']=test_matches['clearances_2']/test_matches['matches_played_2']\n",
    "\n",
    "        test_matches['goals_against_1']=test_matches['goals_against_1']/test_matches['matches_played_1']\n",
    "\n",
    "        test_matches['attempts_on_target_1']=test_matches['attempts_on_target_1']/test_matches['matches_played_1']\n",
    "\n",
    "        test_matches['shots_attempted_1']=test_matches['shots_attempted_1']/test_matches['matches_played_1']\n",
    "\n",
    "        test_matches['attempts_off_target_1']=test_matches['attempts_off_target_1']/test_matches['matches_played_1']\n",
    "\n",
    "        test_matches['shots_blocked_1']=test_matches['shots_blocked_1']/test_matches['matches_played_1']\n",
    "\n",
    "        test_matches['clearances_1']=test_matches['clearances_1']/test_matches['matches_played_1']\n",
    "\n",
    "        test_matches['diff_goals_scored']=test_matches['goals_scored_1']-test_matches['goals_scored_2']\n",
    "    \n",
    "        test_matches['diff_goals_against']=test_matches['goals_against_1']-test_matches['goals_against_2']\n",
    "    \n",
    "        test_matches['diff_attempts_on_target']=test_matches['attempts_on_target_1']-test_matches['attempts_on_target_2']\n",
    "    \n",
    "        test_matches['diff_shots_attempted']=test_matches['shots_attempted_1']-test_matches['shots_attempted_2']\n",
    "       \n",
    "        test_matches['diff_attempts_off_target']=test_matches['attempts_off_target_1']-test_matches['attempts_off_target_2']\n",
    "    \n",
    "        test_matches['diff_shots_blocked']=test_matches['shots_blocked_1']-test_matches['shots_blocked_2']\n",
    "        \n",
    "        test_matches['diff_clearances']=matches['clearances_1']-matches['clearances_2']\n",
    "    \n",
    "        test_X = test_matches[columns_of_interest]\n",
    "    \n",
    "        test_X[test_X.isnull()]\n",
    "    \n",
    "        test_X=test_X.dropna()\n",
    "        pred_Y = rf.predict(test_X)\n",
    "        return pred_Y[0]\n",
    "\n",
    "#Function to return probability of winning of Team 1 against Team 2\n",
    "\n",
    "def get_probability (team_1,team_2):\n",
    "    X1 = winning_probability(team_1,team_2)\n",
    "    X2 = winning_probability(team_2,team_1)\n",
    "    X = X1/(X1+X2)\n",
    "    return X\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Belgium vs France -> 0.283422\n",
      "Croatia vs England -> 0.264706\n"
     ]
    }
   ],
   "source": [
    "# Quarter Finals Winning Probabilites: #\n",
    "print ('Belgium vs France -> %f' %(get_probability(['Belgium'],['France'])))\n",
    "print ('Croatia vs England -> %f' %(get_probability(['Croatia'],['England'])))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}