new_csv.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches = pd.read_csv('./WorldCupMatches.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>Year</th>\n",
       "      <th>Datetime</th>\n",
       "      <th>Stage</th>\n",
       "      <th>Stadium</th>\n",
       "      <th>City</th>\n",
       "      <th>Home Team Name</th>\n",
       "      <th>Home Team Goals</th>\n",
       "      <th>Away Team Goals</th>\n",
       "      <th>Away Team Name</th>\n",
       "      <th>Win conditions</th>\n",
       "      <th>Attendance</th>\n",
       "      <th>Half-time Home Goals</th>\n",
       "      <th>Half-time Away Goals</th>\n",
       "      <th>Referee</th>\n",
       "      <th>Assistant 1</th>\n",
       "      <th>Assistant 2</th>\n",
       "      <th>RoundID</th>\n",
       "      <th>MatchID</th>\n",
       "      <th>Home Team Initials</th>\n",
       "      <th>Away Team Initials</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1930</td>\n",
       "      <td>13 Jul 1930 - 15:00</td>\n",
       "      <td>Group 1</td>\n",
       "      <td>Pocitos</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>France</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>Mexico</td>\n",
       "      <td></td>\n",
       "      <td>4444.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>LOMBARDI Domingo (URU)</td>\n",
       "      <td>CRISTOPHE Henry (BEL)</td>\n",
       "      <td>REGO Gilberto (BRA)</td>\n",
       "      <td>201</td>\n",
       "      <td>1096</td>\n",
       "      <td>FRA</td>\n",
       "      <td>MEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1930</td>\n",
       "      <td>13 Jul 1930 - 15:00</td>\n",
       "      <td>Group 4</td>\n",
       "      <td>Parque Central</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>USA</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Belgium</td>\n",
       "      <td></td>\n",
       "      <td>18346.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>MACIAS Jose (ARG)</td>\n",
       "      <td>MATEUCCI Francisco (URU)</td>\n",
       "      <td>WARNKEN Alberto (CHI)</td>\n",
       "      <td>201</td>\n",
       "      <td>1090</td>\n",
       "      <td>USA</td>\n",
       "      <td>BEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1930</td>\n",
       "      <td>14 Jul 1930 - 12:45</td>\n",
       "      <td>Group 2</td>\n",
       "      <td>Parque Central</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Brazil</td>\n",
       "      <td></td>\n",
       "      <td>24059.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>TEJADA Anibal (URU)</td>\n",
       "      <td>VALLARINO Ricardo (URU)</td>\n",
       "      <td>BALWAY Thomas (FRA)</td>\n",
       "      <td>201</td>\n",
       "      <td>1093</td>\n",
       "      <td>YUG</td>\n",
       "      <td>BRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1930</td>\n",
       "      <td>14 Jul 1930 - 14:50</td>\n",
       "      <td>Group 3</td>\n",
       "      <td>Pocitos</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Romania</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Peru</td>\n",
       "      <td></td>\n",
       "      <td>2549.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>WARNKEN Alberto (CHI)</td>\n",
       "      <td>LANGENUS Jean (BEL)</td>\n",
       "      <td>MATEUCCI Francisco (URU)</td>\n",
       "      <td>201</td>\n",
       "      <td>1098</td>\n",
       "      <td>ROU</td>\n",
       "      <td>PER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1930</td>\n",
       "      <td>15 Jul 1930 - 16:00</td>\n",
       "      <td>Group 1</td>\n",
       "      <td>Parque Central</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>France</td>\n",
       "      <td></td>\n",
       "      <td>23409.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>REGO Gilberto (BRA)</td>\n",
       "      <td>SAUCEDO Ulises (BOL)</td>\n",
       "      <td>RADULESCU Constantin (ROU)</td>\n",
       "      <td>201</td>\n",
       "      <td>1085</td>\n",
       "      <td>ARG</td>\n",
       "      <td>FRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1930</td>\n",
       "      <td>16 Jul 1930 - 14:45</td>\n",
       "      <td>Group 1</td>\n",
       "      <td>Parque Central</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Chile</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Mexico</td>\n",
       "      <td></td>\n",
       "      <td>9249.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>CRISTOPHE Henry (BEL)</td>\n",
       "      <td>APHESTEGUY Martin (URU)</td>\n",
       "      <td>LANGENUS Jean (BEL)</td>\n",
       "      <td>201</td>\n",
       "      <td>1095</td>\n",
       "      <td>CHI</td>\n",
       "      <td>MEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1930</td>\n",
       "      <td>17 Jul 1930 - 12:45</td>\n",
       "      <td>Group 2</td>\n",
       "      <td>Parque Central</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Bolivia</td>\n",
       "      <td></td>\n",
       "      <td>18306.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MATEUCCI Francisco (URU)</td>\n",
       "      <td>LOMBARDI Domingo (URU)</td>\n",
       "      <td>WARNKEN Alberto (CHI)</td>\n",
       "      <td>201</td>\n",
       "      <td>1092</td>\n",
       "      <td>YUG</td>\n",
       "      <td>BOL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1930</td>\n",
       "      <td>17 Jul 1930 - 14:45</td>\n",
       "      <td>Group 4</td>\n",
       "      <td>Parque Central</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>USA</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td></td>\n",
       "      <td>18306.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>MACIAS Jose (ARG)</td>\n",
       "      <td>APHESTEGUY Martin (URU)</td>\n",
       "      <td>TEJADA Anibal (URU)</td>\n",
       "      <td>201</td>\n",
       "      <td>1097</td>\n",
       "      <td>USA</td>\n",
       "      <td>PAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1930</td>\n",
       "      <td>18 Jul 1930 - 14:30</td>\n",
       "      <td>Group 3</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Peru</td>\n",
       "      <td></td>\n",
       "      <td>57735.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>LANGENUS Jean (BEL)</td>\n",
       "      <td>BALWAY Thomas (FRA)</td>\n",
       "      <td>CRISTOPHE Henry (BEL)</td>\n",
       "      <td>201</td>\n",
       "      <td>1099</td>\n",
       "      <td>URU</td>\n",
       "      <td>PER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1930</td>\n",
       "      <td>19 Jul 1930 - 12:50</td>\n",
       "      <td>Group 1</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Chile</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>France</td>\n",
       "      <td></td>\n",
       "      <td>2000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>TEJADA Anibal (URU)</td>\n",
       "      <td>LOMBARDI Domingo (URU)</td>\n",
       "      <td>REGO Gilberto (BRA)</td>\n",
       "      <td>201</td>\n",
       "      <td>1094</td>\n",
       "      <td>CHI</td>\n",
       "      <td>FRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1930</td>\n",
       "      <td>19 Jul 1930 - 15:00</td>\n",
       "      <td>Group 1</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>Mexico</td>\n",
       "      <td></td>\n",
       "      <td>42100.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>SAUCEDO Ulises (BOL)</td>\n",
       "      <td>ALONSO Gualberto (URU)</td>\n",
       "      <td>RADULESCU Constantin (ROU)</td>\n",
       "      <td>201</td>\n",
       "      <td>1086</td>\n",
       "      <td>ARG</td>\n",
       "      <td>MEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1930</td>\n",
       "      <td>20 Jul 1930 - 13:00</td>\n",
       "      <td>Group 2</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Bolivia</td>\n",
       "      <td></td>\n",
       "      <td>25466.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>BALWAY Thomas (FRA)</td>\n",
       "      <td>MATEUCCI Francisco (URU)</td>\n",
       "      <td>VALLEJO Gaspar (MEX)</td>\n",
       "      <td>201</td>\n",
       "      <td>1091</td>\n",
       "      <td>BRA</td>\n",
       "      <td>BOL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1930</td>\n",
       "      <td>20 Jul 1930 - 15:00</td>\n",
       "      <td>Group 4</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Belgium</td>\n",
       "      <td></td>\n",
       "      <td>12000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>VALLARINO Ricardo (URU)</td>\n",
       "      <td>MACIAS Jose (ARG)</td>\n",
       "      <td>LOMBARDI Domingo (URU)</td>\n",
       "      <td>201</td>\n",
       "      <td>1089</td>\n",
       "      <td>PAR</td>\n",
       "      <td>BEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1930</td>\n",
       "      <td>21 Jul 1930 - 14:50</td>\n",
       "      <td>Group 3</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Romania</td>\n",
       "      <td></td>\n",
       "      <td>70022.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>REGO Gilberto (BRA)</td>\n",
       "      <td>WARNKEN Alberto (CHI)</td>\n",
       "      <td>SAUCEDO Ulises (BOL)</td>\n",
       "      <td>201</td>\n",
       "      <td>1100</td>\n",
       "      <td>URU</td>\n",
       "      <td>ROU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1930</td>\n",
       "      <td>22 Jul 1930 - 14:45</td>\n",
       "      <td>Group 1</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Chile</td>\n",
       "      <td></td>\n",
       "      <td>41459.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>LANGENUS Jean (BEL)</td>\n",
       "      <td>CRISTOPHE Henry (BEL)</td>\n",
       "      <td>SAUCEDO Ulises (BOL)</td>\n",
       "      <td>201</td>\n",
       "      <td>1084</td>\n",
       "      <td>ARG</td>\n",
       "      <td>CHI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1930</td>\n",
       "      <td>26 Jul 1930 - 14:45</td>\n",
       "      <td>Semi-finals</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "      <td></td>\n",
       "      <td>72886.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>LANGENUS Jean (BEL)</td>\n",
       "      <td>VALLEJO Gaspar (MEX)</td>\n",
       "      <td>WARNKEN Alberto (CHI)</td>\n",
       "      <td>202</td>\n",
       "      <td>1088</td>\n",
       "      <td>ARG</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1930</td>\n",
       "      <td>27 Jul 1930 - 14:45</td>\n",
       "      <td>Semi-finals</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td></td>\n",
       "      <td>79867.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>REGO Gilberto (BRA)</td>\n",
       "      <td>SAUCEDO Ulises (BOL)</td>\n",
       "      <td>BALWAY Thomas (FRA)</td>\n",
       "      <td>202</td>\n",
       "      <td>1101</td>\n",
       "      <td>URU</td>\n",
       "      <td>YUG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1930</td>\n",
       "      <td>30 Jul 1930 - 14:15</td>\n",
       "      <td>Final</td>\n",
       "      <td>Estadio Centenario</td>\n",
       "      <td>Montevideo</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>Argentina</td>\n",
       "      <td></td>\n",
       "      <td>68346.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>LANGENUS Jean (BEL)</td>\n",
       "      <td>SAUCEDO Ulises (BOL)</td>\n",
       "      <td>CRISTOPHE Henry (BEL)</td>\n",
       "      <td>405</td>\n",
       "      <td>1087</td>\n",
       "      <td>URU</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>Stadio Benito Mussolini</td>\n",
       "      <td>Turin</td>\n",
       "      <td>Austria</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>France</td>\n",
       "      <td>Austria win after extra time</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>VAN MOORSEL Johannes (NED)</td>\n",
       "      <td>CAIRONI Camillo (ITA)</td>\n",
       "      <td>BAERT Louis (BEL)</td>\n",
       "      <td>204</td>\n",
       "      <td>1104</td>\n",
       "      <td>AUT</td>\n",
       "      <td>FRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>Giorgio Ascarelli</td>\n",
       "      <td>Naples</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>Egypt</td>\n",
       "      <td></td>\n",
       "      <td>9000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>BARLASSINA Rinaldo (ITA)</td>\n",
       "      <td>DATTILO Generoso (ITA)</td>\n",
       "      <td>SASSI Otello (ITA)</td>\n",
       "      <td>204</td>\n",
       "      <td>1119</td>\n",
       "      <td>HUN</td>\n",
       "      <td>EGY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>San Siro</td>\n",
       "      <td>Milan</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td></td>\n",
       "      <td>33000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>EKLIND Ivan (SWE)</td>\n",
       "      <td>BERANEK Alois (AUT)</td>\n",
       "      <td>BONIVENTO Ferruccio (ITA)</td>\n",
       "      <td>204</td>\n",
       "      <td>1133</td>\n",
       "      <td>SUI</td>\n",
       "      <td>NED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>Littorale</td>\n",
       "      <td>Bologna</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Argentina</td>\n",
       "      <td></td>\n",
       "      <td>14000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BRAUN Eugen (AUT)</td>\n",
       "      <td>CARRARO Albino (ITA)</td>\n",
       "      <td>TURBIANI Giuseppe (ITA)</td>\n",
       "      <td>204</td>\n",
       "      <td>1102</td>\n",
       "      <td>SWE</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>Giovanni Berta</td>\n",
       "      <td>Florence</td>\n",
       "      <td>Germany</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Belgium</td>\n",
       "      <td></td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>MATTEA Francesco (ITA)</td>\n",
       "      <td>MELANDRI Ermenegildo (ITA)</td>\n",
       "      <td>BAERT Jacques (FRA)</td>\n",
       "      <td>204</td>\n",
       "      <td>1108</td>\n",
       "      <td>GER</td>\n",
       "      <td>BEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>Luigi Ferraris</td>\n",
       "      <td>Genoa</td>\n",
       "      <td>Spain</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Brazil</td>\n",
       "      <td></td>\n",
       "      <td>21000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>BIRLEM Alfred (GER)</td>\n",
       "      <td>CARMINATI Ettore (ITA)</td>\n",
       "      <td>IVANCSICS Mihaly (HUN)</td>\n",
       "      <td>204</td>\n",
       "      <td>1111</td>\n",
       "      <td>ESP</td>\n",
       "      <td>BRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>Nazionale PNF</td>\n",
       "      <td>Rome</td>\n",
       "      <td>Italy</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "      <td></td>\n",
       "      <td>25000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>MERCET Rene (SUI)</td>\n",
       "      <td>ESCARTIN Pedro (ESP)</td>\n",
       "      <td>ZENISEK Bohumil (TCH)</td>\n",
       "      <td>204</td>\n",
       "      <td>1135</td>\n",
       "      <td>ITA</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1934</td>\n",
       "      <td>27 May 1934 - 16:30</td>\n",
       "      <td>Preliminary round</td>\n",
       "      <td>Littorio</td>\n",
       "      <td>Trieste</td>\n",
       "      <td>Czechoslovakia</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Romania</td>\n",
       "      <td></td>\n",
       "      <td>9000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>LANGENUS Jean (BEL)</td>\n",
       "      <td>SCARPI Giuseppe (ITA)</td>\n",
       "      <td>SCORZONI Raffaele (ITA)</td>\n",
       "      <td>204</td>\n",
       "      <td>1141</td>\n",
       "      <td>TCH</td>\n",
       "      <td>ROU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1934</td>\n",
       "      <td>31 May 1934 - 16:30</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Stadio Benito Mussolini</td>\n",
       "      <td>Turin</td>\n",
       "      <td>Czechoslovakia</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td></td>\n",
       "      <td>12000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BERANEK Alois (AUT)</td>\n",
       "      <td>MOHAMED Youssuf (EGY)</td>\n",
       "      <td>BAERT Jacques (FRA)</td>\n",
       "      <td>418</td>\n",
       "      <td>1143</td>\n",
       "      <td>TCH</td>\n",
       "      <td>SUI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1934</td>\n",
       "      <td>31 May 1934 - 16:30</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>San Siro</td>\n",
       "      <td>Milan</td>\n",
       "      <td>Germany</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Sweden</td>\n",
       "      <td></td>\n",
       "      <td>3000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>BARLASSINA Rinaldo (ITA)</td>\n",
       "      <td>MERCET Rene (SUI)</td>\n",
       "      <td>VAN MOORSEL Johannes (NED)</td>\n",
       "      <td>418</td>\n",
       "      <td>1129</td>\n",
       "      <td>GER</td>\n",
       "      <td>SWE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1934</td>\n",
       "      <td>31 May 1934 - 16:30</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Giovanni Berta</td>\n",
       "      <td>Florence</td>\n",
       "      <td>Italy</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Spain</td>\n",
       "      <td></td>\n",
       "      <td>35000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>BAERT Louis (BEL)</td>\n",
       "      <td>ZENISEK Bohumil (TCH)</td>\n",
       "      <td>IVANCSICS Mihaly (HUN)</td>\n",
       "      <td>418</td>\n",
       "      <td>1122</td>\n",
       "      <td>ITA</td>\n",
       "      <td>ESP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1934</td>\n",
       "      <td>31 May 1934 - 16:30</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Littorale</td>\n",
       "      <td>Bologna</td>\n",
       "      <td>Austria</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Hungary</td>\n",
       "      <td></td>\n",
       "      <td>23000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>MATTEA Francesco (ITA)</td>\n",
       "      <td>ESCARTIN Pedro (ESP)</td>\n",
       "      <td>BIRLEM Alfred (GER)</td>\n",
       "      <td>418</td>\n",
       "      <td>1106</td>\n",
       "      <td>AUT</td>\n",
       "      <td>HUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>2014</td>\n",
       "      <td>30 Jun 2014 - 13:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio Nacional</td>\n",
       "      <td>Brasilia</td>\n",
       "      <td>France</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td></td>\n",
       "      <td>67882.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>GEIGER Mark (USA)</td>\n",
       "      <td>HURD Sean (USA)</td>\n",
       "      <td>FLETCHER Joe (CAN)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186462</td>\n",
       "      <td>FRA</td>\n",
       "      <td>NGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>2014</td>\n",
       "      <td>30 Jun 2014 - 17:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio Beira-Rio</td>\n",
       "      <td>Porto Alegre</td>\n",
       "      <td>Germany</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Germany win after extra time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RICCI Sandro (BRA)</td>\n",
       "      <td>DE CARVALHO Emerson (BRA)</td>\n",
       "      <td>VAN GASSE Marcelo (BRA)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186460</td>\n",
       "      <td>GER</td>\n",
       "      <td>ALG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>2014</td>\n",
       "      <td>04 Jul 2014 - 17:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Estadio Castelao</td>\n",
       "      <td>Fortaleza</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Colombia</td>\n",
       "      <td></td>\n",
       "      <td>60342.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Carlos VELASCO CARBALLO (ESP)</td>\n",
       "      <td>ALONSO FERNANDEZ Roberto (ESP)</td>\n",
       "      <td>YUSTE Juan (ESP)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186461</td>\n",
       "      <td>BRA</td>\n",
       "      <td>COL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>2014</td>\n",
       "      <td>04 Jul 2014 - 13:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Estadio do Maracana</td>\n",
       "      <td>Rio De Janeiro</td>\n",
       "      <td>France</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Germany</td>\n",
       "      <td></td>\n",
       "      <td>74240.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>PITANA Nestor (ARG)</td>\n",
       "      <td>MAIDANA Hernan (ARG)</td>\n",
       "      <td>BELATTI Juan Pablo (ARG)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186485</td>\n",
       "      <td>FRA</td>\n",
       "      <td>GER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>2014</td>\n",
       "      <td>08 Jul 2014 - 17:00</td>\n",
       "      <td>Semi-finals</td>\n",
       "      <td>Estadio Mineirao</td>\n",
       "      <td>Belo Horizonte</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Germany</td>\n",
       "      <td></td>\n",
       "      <td>58141.0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>RODRIGUEZ Marco (MEX)</td>\n",
       "      <td>TORRENTERA Marvin (MEX)</td>\n",
       "      <td>QUINTERO Marcos (MEX)</td>\n",
       "      <td>255955</td>\n",
       "      <td>300186474</td>\n",
       "      <td>BRA</td>\n",
       "      <td>GER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>2014</td>\n",
       "      <td>12 Jul 2014 - 17:00</td>\n",
       "      <td>Play-off for third place</td>\n",
       "      <td>Estadio Nacional</td>\n",
       "      <td>Brasilia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td></td>\n",
       "      <td>68034.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>HAIMOUDI Djamel (ALG)</td>\n",
       "      <td>ACHIK Redouane (MAR)</td>\n",
       "      <td>ETCHIALI Abdelhak (ALG)</td>\n",
       "      <td>255957</td>\n",
       "      <td>300186502</td>\n",
       "      <td>BRA</td>\n",
       "      <td>NED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>2014</td>\n",
       "      <td>13 Jul 2014 - 16:00</td>\n",
       "      <td>Final</td>\n",
       "      <td>Estadio do Maracana</td>\n",
       "      <td>Rio De Janeiro</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Germany win after extra time</td>\n",
       "      <td>74738.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicola RIZZOLI (ITA)</td>\n",
       "      <td>Renato FAVERANI (ITA)</td>\n",
       "      <td>Andrea STEFANI (ITA)</td>\n",
       "      <td>255959</td>\n",
       "      <td>300186501</td>\n",
       "      <td>GER</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>2014</td>\n",
       "      <td>09 Jul 2014 - 17:00</td>\n",
       "      <td>Semi-finals</td>\n",
       "      <td>Arena de Sao Paulo</td>\n",
       "      <td>Sao Paulo</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Argentina win on penalties (2 - 4)</td>\n",
       "      <td>63267.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>C�neyt �AKIR (TUR)</td>\n",
       "      <td>DURAN Bahattin (TUR)</td>\n",
       "      <td>ONGUN Tarik (TUR)</td>\n",
       "      <td>255955</td>\n",
       "      <td>300186490</td>\n",
       "      <td>NED</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>830</th>\n",
       "      <td>2014</td>\n",
       "      <td>05 Jul 2014 - 17:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Arena Fonte Nova</td>\n",
       "      <td>Salvador</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>Netherlands win on penalties (4 - 3)</td>\n",
       "      <td>51179.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Ravshan IRMATOV (UZB)</td>\n",
       "      <td>RASULOV Abduxamidullo (UZB)</td>\n",
       "      <td>KOCHKAROV Bakhadyr (KGZ)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186488</td>\n",
       "      <td>NED</td>\n",
       "      <td>CRC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>831</th>\n",
       "      <td>2014</td>\n",
       "      <td>05 Jul 2014 - 13:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Estadio Nacional</td>\n",
       "      <td>Brasilia</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Belgium</td>\n",
       "      <td></td>\n",
       "      <td>68551.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicola RIZZOLI (ITA)</td>\n",
       "      <td>Renato FAVERANI (ITA)</td>\n",
       "      <td>Andrea STEFANI (ITA)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186504</td>\n",
       "      <td>ARG</td>\n",
       "      <td>BEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>832</th>\n",
       "      <td>2014</td>\n",
       "      <td>29 Jun 2014 - 13:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio Castelao</td>\n",
       "      <td>Fortaleza</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Mexico</td>\n",
       "      <td></td>\n",
       "      <td>58817.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PROENCA Pedro (POR)</td>\n",
       "      <td>MIRANDA Bertino (POR)</td>\n",
       "      <td>TRIGO Jose (POR)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186508</td>\n",
       "      <td>NED</td>\n",
       "      <td>MEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>2014</td>\n",
       "      <td>29 Jun 2014 - 17:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Arena Pernambuco</td>\n",
       "      <td>Recife</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Greece</td>\n",
       "      <td>Costa Rica win on penalties (5 - 3)</td>\n",
       "      <td>41242.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Ben WILLIAMS (AUS)</td>\n",
       "      <td>CREAM Matthew (AUS)</td>\n",
       "      <td>ANAZ Hakan (AUS)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186459</td>\n",
       "      <td>CRC</td>\n",
       "      <td>GRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>2014</td>\n",
       "      <td>01 Jul 2014 - 13:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Arena de Sao Paulo</td>\n",
       "      <td>Sao Paulo</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Argentina win after extra time</td>\n",
       "      <td>63255.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>ERIKSSON Jonas (SWE)</td>\n",
       "      <td>KLASENIUS Mathias (SWE)</td>\n",
       "      <td>WARNMARK Daniel (SWE)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186503</td>\n",
       "      <td>ARG</td>\n",
       "      <td>SUI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>2014</td>\n",
       "      <td>01 Jul 2014 - 17:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Arena Fonte Nova</td>\n",
       "      <td>Salvador</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "      <td>Belgium win after extra time</td>\n",
       "      <td>51227.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>HAIMOUDI Djamel (ALG)</td>\n",
       "      <td>ACHIK Redouane (MAR)</td>\n",
       "      <td>ETCHIALI Abdelhak (ALG)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186497</td>\n",
       "      <td>BEL</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>2014</td>\n",
       "      <td>28 Jun 2014 - 13:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio Mineirao</td>\n",
       "      <td>Belo Horizonte</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Chile</td>\n",
       "      <td>Brazil win on penalties (3 - 2)</td>\n",
       "      <td>57714.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>WEBB Howard (ENG)</td>\n",
       "      <td>MULLARKEY Michael (ENG)</td>\n",
       "      <td>Darren CANN (ENG)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186487</td>\n",
       "      <td>BRA</td>\n",
       "      <td>CHI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>2014</td>\n",
       "      <td>28 Jun 2014 - 17:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio do Maracana</td>\n",
       "      <td>Rio De Janeiro</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td></td>\n",
       "      <td>73804.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Bj�rn KUIPERS (NED)</td>\n",
       "      <td>Sander VAN ROEKEL (NED)</td>\n",
       "      <td>Erwin ZEINSTRA (NED)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186491</td>\n",
       "      <td>COL</td>\n",
       "      <td>URU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>2014</td>\n",
       "      <td>29 Jun 2014 - 13:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio Castelao</td>\n",
       "      <td>Fortaleza</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Mexico</td>\n",
       "      <td></td>\n",
       "      <td>58817.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>PROENCA Pedro (POR)</td>\n",
       "      <td>MIRANDA Bertino (POR)</td>\n",
       "      <td>TRIGO Jose (POR)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186508</td>\n",
       "      <td>NED</td>\n",
       "      <td>MEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>2014</td>\n",
       "      <td>29 Jun 2014 - 17:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Arena Pernambuco</td>\n",
       "      <td>Recife</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Greece</td>\n",
       "      <td>Costa Rica win on penalties (5 - 3)</td>\n",
       "      <td>41242.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Ben WILLIAMS (AUS)</td>\n",
       "      <td>CREAM Matthew (AUS)</td>\n",
       "      <td>ANAZ Hakan (AUS)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186459</td>\n",
       "      <td>CRC</td>\n",
       "      <td>GRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>2014</td>\n",
       "      <td>30 Jun 2014 - 13:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio Nacional</td>\n",
       "      <td>Brasilia</td>\n",
       "      <td>France</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td></td>\n",
       "      <td>67882.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>GEIGER Mark (USA)</td>\n",
       "      <td>HURD Sean (USA)</td>\n",
       "      <td>FLETCHER Joe (CAN)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186462</td>\n",
       "      <td>FRA</td>\n",
       "      <td>NGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>841</th>\n",
       "      <td>2014</td>\n",
       "      <td>30 Jun 2014 - 17:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Estadio Beira-Rio</td>\n",
       "      <td>Porto Alegre</td>\n",
       "      <td>Germany</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Germany win after extra time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RICCI Sandro (BRA)</td>\n",
       "      <td>DE CARVALHO Emerson (BRA)</td>\n",
       "      <td>VAN GASSE Marcelo (BRA)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186460</td>\n",
       "      <td>GER</td>\n",
       "      <td>ALG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>2014</td>\n",
       "      <td>01 Jul 2014 - 13:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Arena de Sao Paulo</td>\n",
       "      <td>Sao Paulo</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Argentina win after extra time</td>\n",
       "      <td>63255.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>ERIKSSON Jonas (SWE)</td>\n",
       "      <td>KLASENIUS Mathias (SWE)</td>\n",
       "      <td>WARNMARK Daniel (SWE)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186503</td>\n",
       "      <td>ARG</td>\n",
       "      <td>SUI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>2014</td>\n",
       "      <td>01 Jul 2014 - 17:00</td>\n",
       "      <td>Round of 16</td>\n",
       "      <td>Arena Fonte Nova</td>\n",
       "      <td>Salvador</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "      <td>Belgium win after extra time</td>\n",
       "      <td>51227.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>HAIMOUDI Djamel (ALG)</td>\n",
       "      <td>ACHIK Redouane (MAR)</td>\n",
       "      <td>ETCHIALI Abdelhak (ALG)</td>\n",
       "      <td>255951</td>\n",
       "      <td>300186497</td>\n",
       "      <td>BEL</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>2014</td>\n",
       "      <td>04 Jul 2014 - 13:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Estadio do Maracana</td>\n",
       "      <td>Rio De Janeiro</td>\n",
       "      <td>France</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Germany</td>\n",
       "      <td></td>\n",
       "      <td>74240.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>PITANA Nestor (ARG)</td>\n",
       "      <td>MAIDANA Hernan (ARG)</td>\n",
       "      <td>BELATTI Juan Pablo (ARG)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186485</td>\n",
       "      <td>FRA</td>\n",
       "      <td>GER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>845</th>\n",
       "      <td>2014</td>\n",
       "      <td>04 Jul 2014 - 17:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Estadio Castelao</td>\n",
       "      <td>Fortaleza</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Colombia</td>\n",
       "      <td></td>\n",
       "      <td>60342.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Carlos VELASCO CARBALLO (ESP)</td>\n",
       "      <td>ALONSO FERNANDEZ Roberto (ESP)</td>\n",
       "      <td>YUSTE Juan (ESP)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186461</td>\n",
       "      <td>BRA</td>\n",
       "      <td>COL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>846</th>\n",
       "      <td>2014</td>\n",
       "      <td>05 Jul 2014 - 13:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Estadio Nacional</td>\n",
       "      <td>Brasilia</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Belgium</td>\n",
       "      <td></td>\n",
       "      <td>68551.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicola RIZZOLI (ITA)</td>\n",
       "      <td>Renato FAVERANI (ITA)</td>\n",
       "      <td>Andrea STEFANI (ITA)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186504</td>\n",
       "      <td>ARG</td>\n",
       "      <td>BEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>847</th>\n",
       "      <td>2014</td>\n",
       "      <td>05 Jul 2014 - 17:00</td>\n",
       "      <td>Quarter-finals</td>\n",
       "      <td>Arena Fonte Nova</td>\n",
       "      <td>Salvador</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>Netherlands win on penalties (4 - 3)</td>\n",
       "      <td>51179.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Ravshan IRMATOV (UZB)</td>\n",
       "      <td>RASULOV Abduxamidullo (UZB)</td>\n",
       "      <td>KOCHKAROV Bakhadyr (KGZ)</td>\n",
       "      <td>255953</td>\n",
       "      <td>300186488</td>\n",
       "      <td>NED</td>\n",
       "      <td>CRC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>848</th>\n",
       "      <td>2014</td>\n",
       "      <td>08 Jul 2014 - 17:00</td>\n",
       "      <td>Semi-finals</td>\n",
       "      <td>Estadio Mineirao</td>\n",
       "      <td>Belo Horizonte</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Germany</td>\n",
       "      <td></td>\n",
       "      <td>58141.0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>RODRIGUEZ Marco (MEX)</td>\n",
       "      <td>TORRENTERA Marvin (MEX)</td>\n",
       "      <td>QUINTERO Marcos (MEX)</td>\n",
       "      <td>255955</td>\n",
       "      <td>300186474</td>\n",
       "      <td>BRA</td>\n",
       "      <td>GER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>2014</td>\n",
       "      <td>09 Jul 2014 - 17:00</td>\n",
       "      <td>Semi-finals</td>\n",
       "      <td>Arena de Sao Paulo</td>\n",
       "      <td>Sao Paulo</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Argentina win on penalties (2 - 4)</td>\n",
       "      <td>63267.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>C�neyt �AKIR (TUR)</td>\n",
       "      <td>DURAN Bahattin (TUR)</td>\n",
       "      <td>ONGUN Tarik (TUR)</td>\n",
       "      <td>255955</td>\n",
       "      <td>300186490</td>\n",
       "      <td>NED</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>2014</td>\n",
       "      <td>12 Jul 2014 - 17:00</td>\n",
       "      <td>Play-off for third place</td>\n",
       "      <td>Estadio Nacional</td>\n",
       "      <td>Brasilia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td></td>\n",
       "      <td>68034.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>HAIMOUDI Djamel (ALG)</td>\n",
       "      <td>ACHIK Redouane (MAR)</td>\n",
       "      <td>ETCHIALI Abdelhak (ALG)</td>\n",
       "      <td>255957</td>\n",
       "      <td>300186502</td>\n",
       "      <td>BRA</td>\n",
       "      <td>NED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>851</th>\n",
       "      <td>2014</td>\n",
       "      <td>13 Jul 2014 - 16:00</td>\n",
       "      <td>Final</td>\n",
       "      <td>Estadio do Maracana</td>\n",
       "      <td>Rio De Janeiro</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Germany win after extra time</td>\n",
       "      <td>74738.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicola RIZZOLI (ITA)</td>\n",
       "      <td>Renato FAVERANI (ITA)</td>\n",
       "      <td>Andrea STEFANI (ITA)</td>\n",
       "      <td>255959</td>\n",
       "      <td>300186501</td>\n",
       "      <td>GER</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>852 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year              Datetime                     Stage  \\\n",
       "0    1930  13 Jul 1930 - 15:00                    Group 1   \n",
       "1    1930  13 Jul 1930 - 15:00                    Group 4   \n",
       "2    1930  14 Jul 1930 - 12:45                    Group 2   \n",
       "3    1930  14 Jul 1930 - 14:50                    Group 3   \n",
       "4    1930  15 Jul 1930 - 16:00                    Group 1   \n",
       "5    1930  16 Jul 1930 - 14:45                    Group 1   \n",
       "6    1930  17 Jul 1930 - 12:45                    Group 2   \n",
       "7    1930  17 Jul 1930 - 14:45                    Group 4   \n",
       "8    1930  18 Jul 1930 - 14:30                    Group 3   \n",
       "9    1930  19 Jul 1930 - 12:50                    Group 1   \n",
       "10   1930  19 Jul 1930 - 15:00                    Group 1   \n",
       "11   1930  20 Jul 1930 - 13:00                    Group 2   \n",
       "12   1930  20 Jul 1930 - 15:00                    Group 4   \n",
       "13   1930  21 Jul 1930 - 14:50                    Group 3   \n",
       "14   1930  22 Jul 1930 - 14:45                    Group 1   \n",
       "15   1930  26 Jul 1930 - 14:45                Semi-finals   \n",
       "16   1930  27 Jul 1930 - 14:45                Semi-finals   \n",
       "17   1930  30 Jul 1930 - 14:15                      Final   \n",
       "18   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "19   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "20   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "21   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "22   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "23   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "24   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "25   1934  27 May 1934 - 16:30          Preliminary round   \n",
       "26   1934  31 May 1934 - 16:30             Quarter-finals   \n",
       "27   1934  31 May 1934 - 16:30             Quarter-finals   \n",
       "28   1934  31 May 1934 - 16:30             Quarter-finals   \n",
       "29   1934  31 May 1934 - 16:30             Quarter-finals   \n",
       "..    ...                   ...                       ...   \n",
       "822  2014  30 Jun 2014 - 13:00                Round of 16   \n",
       "823  2014  30 Jun 2014 - 17:00                Round of 16   \n",
       "824  2014  04 Jul 2014 - 17:00             Quarter-finals   \n",
       "825  2014  04 Jul 2014 - 13:00             Quarter-finals   \n",
       "826  2014  08 Jul 2014 - 17:00                Semi-finals   \n",
       "827  2014  12 Jul 2014 - 17:00   Play-off for third place   \n",
       "828  2014  13 Jul 2014 - 16:00                      Final   \n",
       "829  2014  09 Jul 2014 - 17:00                Semi-finals   \n",
       "830  2014  05 Jul 2014 - 17:00             Quarter-finals   \n",
       "831  2014  05 Jul 2014 - 13:00             Quarter-finals   \n",
       "832  2014  29 Jun 2014 - 13:00                Round of 16   \n",
       "833  2014  29 Jun 2014 - 17:00                Round of 16   \n",
       "834  2014  01 Jul 2014 - 13:00                Round of 16   \n",
       "835  2014  01 Jul 2014 - 17:00                Round of 16   \n",
       "836  2014  28 Jun 2014 - 13:00                Round of 16   \n",
       "837  2014  28 Jun 2014 - 17:00                Round of 16   \n",
       "838  2014  29 Jun 2014 - 13:00                Round of 16   \n",
       "839  2014  29 Jun 2014 - 17:00                Round of 16   \n",
       "840  2014  30 Jun 2014 - 13:00                Round of 16   \n",
       "841  2014  30 Jun 2014 - 17:00                Round of 16   \n",
       "842  2014  01 Jul 2014 - 13:00                Round of 16   \n",
       "843  2014  01 Jul 2014 - 17:00                Round of 16   \n",
       "844  2014  04 Jul 2014 - 13:00             Quarter-finals   \n",
       "845  2014  04 Jul 2014 - 17:00             Quarter-finals   \n",
       "846  2014  05 Jul 2014 - 13:00             Quarter-finals   \n",
       "847  2014  05 Jul 2014 - 17:00             Quarter-finals   \n",
       "848  2014  08 Jul 2014 - 17:00                Semi-finals   \n",
       "849  2014  09 Jul 2014 - 17:00                Semi-finals   \n",
       "850  2014  12 Jul 2014 - 17:00   Play-off for third place   \n",
       "851  2014  13 Jul 2014 - 16:00                      Final   \n",
       "\n",
       "                     Stadium             City  Home Team Name  \\\n",
       "0                    Pocitos      Montevideo           France   \n",
       "1             Parque Central      Montevideo              USA   \n",
       "2             Parque Central      Montevideo       Yugoslavia   \n",
       "3                    Pocitos      Montevideo          Romania   \n",
       "4             Parque Central      Montevideo        Argentina   \n",
       "5             Parque Central      Montevideo            Chile   \n",
       "6             Parque Central      Montevideo       Yugoslavia   \n",
       "7             Parque Central      Montevideo              USA   \n",
       "8         Estadio Centenario      Montevideo          Uruguay   \n",
       "9         Estadio Centenario      Montevideo            Chile   \n",
       "10        Estadio Centenario      Montevideo        Argentina   \n",
       "11        Estadio Centenario      Montevideo           Brazil   \n",
       "12        Estadio Centenario      Montevideo         Paraguay   \n",
       "13        Estadio Centenario      Montevideo          Uruguay   \n",
       "14        Estadio Centenario      Montevideo        Argentina   \n",
       "15        Estadio Centenario      Montevideo        Argentina   \n",
       "16        Estadio Centenario      Montevideo          Uruguay   \n",
       "17        Estadio Centenario      Montevideo          Uruguay   \n",
       "18   Stadio Benito Mussolini           Turin          Austria   \n",
       "19         Giorgio Ascarelli          Naples          Hungary   \n",
       "20                  San Siro           Milan      Switzerland   \n",
       "21                 Littorale         Bologna           Sweden   \n",
       "22            Giovanni Berta        Florence          Germany   \n",
       "23            Luigi Ferraris           Genoa            Spain   \n",
       "24             Nazionale PNF            Rome            Italy   \n",
       "25                  Littorio         Trieste   Czechoslovakia   \n",
       "26   Stadio Benito Mussolini           Turin   Czechoslovakia   \n",
       "27                  San Siro           Milan          Germany   \n",
       "28            Giovanni Berta        Florence            Italy   \n",
       "29                 Littorale         Bologna          Austria   \n",
       "..                       ...              ...             ...   \n",
       "822         Estadio Nacional        Brasilia           France   \n",
       "823        Estadio Beira-Rio    Porto Alegre          Germany   \n",
       "824         Estadio Castelao       Fortaleza           Brazil   \n",
       "825      Estadio do Maracana  Rio De Janeiro           France   \n",
       "826         Estadio Mineirao  Belo Horizonte           Brazil   \n",
       "827         Estadio Nacional        Brasilia           Brazil   \n",
       "828      Estadio do Maracana  Rio De Janeiro          Germany   \n",
       "829       Arena de Sao Paulo       Sao Paulo      Netherlands   \n",
       "830         Arena Fonte Nova        Salvador      Netherlands   \n",
       "831         Estadio Nacional        Brasilia        Argentina   \n",
       "832         Estadio Castelao       Fortaleza      Netherlands   \n",
       "833         Arena Pernambuco          Recife       Costa Rica   \n",
       "834       Arena de Sao Paulo       Sao Paulo        Argentina   \n",
       "835         Arena Fonte Nova        Salvador          Belgium   \n",
       "836         Estadio Mineirao  Belo Horizonte           Brazil   \n",
       "837      Estadio do Maracana  Rio De Janeiro         Colombia   \n",
       "838         Estadio Castelao       Fortaleza      Netherlands   \n",
       "839         Arena Pernambuco          Recife       Costa Rica   \n",
       "840         Estadio Nacional        Brasilia           France   \n",
       "841        Estadio Beira-Rio    Porto Alegre          Germany   \n",
       "842       Arena de Sao Paulo       Sao Paulo        Argentina   \n",
       "843         Arena Fonte Nova        Salvador          Belgium   \n",
       "844      Estadio do Maracana  Rio De Janeiro           France   \n",
       "845         Estadio Castelao       Fortaleza           Brazil   \n",
       "846         Estadio Nacional        Brasilia        Argentina   \n",
       "847         Arena Fonte Nova        Salvador      Netherlands   \n",
       "848         Estadio Mineirao  Belo Horizonte           Brazil   \n",
       "849       Arena de Sao Paulo       Sao Paulo      Netherlands   \n",
       "850         Estadio Nacional        Brasilia           Brazil   \n",
       "851      Estadio do Maracana  Rio De Janeiro          Germany   \n",
       "\n",
       "     Home Team Goals  Away Team Goals Away Team Name  \\\n",
       "0                  4                1         Mexico   \n",
       "1                  3                0        Belgium   \n",
       "2                  2                1         Brazil   \n",
       "3                  3                1           Peru   \n",
       "4                  1                0         France   \n",
       "5                  3                0         Mexico   \n",
       "6                  4                0        Bolivia   \n",
       "7                  3                0       Paraguay   \n",
       "8                  1                0           Peru   \n",
       "9                  1                0         France   \n",
       "10                 6                3         Mexico   \n",
       "11                 4                0        Bolivia   \n",
       "12                 1                0        Belgium   \n",
       "13                 4                0        Romania   \n",
       "14                 3                1          Chile   \n",
       "15                 6                1            USA   \n",
       "16                 6                1     Yugoslavia   \n",
       "17                 4                2      Argentina   \n",
       "18                 3                2         France   \n",
       "19                 4                2          Egypt   \n",
       "20                 3                2    Netherlands   \n",
       "21                 3                2      Argentina   \n",
       "22                 5                2        Belgium   \n",
       "23                 3                1         Brazil   \n",
       "24                 7                1            USA   \n",
       "25                 2                1        Romania   \n",
       "26                 3                2    Switzerland   \n",
       "27                 2                1         Sweden   \n",
       "28                 1                1          Spain   \n",
       "29                 2                1        Hungary   \n",
       "..               ...              ...            ...   \n",
       "822                2                0        Nigeria   \n",
       "823                2                1        Algeria   \n",
       "824                2                1       Colombia   \n",
       "825                0                1        Germany   \n",
       "826                1                7        Germany   \n",
       "827                0                3    Netherlands   \n",
       "828                1                0      Argentina   \n",
       "829                0                0      Argentina   \n",
       "830                0                0     Costa Rica   \n",
       "831                1                0        Belgium   \n",
       "832                2                1         Mexico   \n",
       "833                1                1         Greece   \n",
       "834                1                0    Switzerland   \n",
       "835                2                1            USA   \n",
       "836                1                1          Chile   \n",
       "837                2                0        Uruguay   \n",
       "838                2                1         Mexico   \n",
       "839                1                1         Greece   \n",
       "840                2                0        Nigeria   \n",
       "841                2                1        Algeria   \n",
       "842                1                0    Switzerland   \n",
       "843                2                1            USA   \n",
       "844                0                1        Germany   \n",
       "845                2                1       Colombia   \n",
       "846                1                0        Belgium   \n",
       "847                0                0     Costa Rica   \n",
       "848                1                7        Germany   \n",
       "849                0                0      Argentina   \n",
       "850                0                3    Netherlands   \n",
       "851                1                0      Argentina   \n",
       "\n",
       "                            Win conditions  Attendance  Half-time Home Goals  \\\n",
       "0                                               4444.0                     3   \n",
       "1                                              18346.0                     2   \n",
       "2                                              24059.0                     2   \n",
       "3                                               2549.0                     1   \n",
       "4                                              23409.0                     0   \n",
       "5                                               9249.0                     1   \n",
       "6                                              18306.0                     0   \n",
       "7                                              18306.0                     2   \n",
       "8                                              57735.0                     0   \n",
       "9                                               2000.0                     0   \n",
       "10                                             42100.0                     3   \n",
       "11                                             25466.0                     1   \n",
       "12                                             12000.0                     1   \n",
       "13                                             70022.0                     4   \n",
       "14                                             41459.0                     2   \n",
       "15                                             72886.0                     1   \n",
       "16                                             79867.0                     3   \n",
       "17                                             68346.0                     1   \n",
       "18           Austria win after extra time      16000.0                     0   \n",
       "19                                              9000.0                     2   \n",
       "20                                             33000.0                     2   \n",
       "21                                             14000.0                     1   \n",
       "22                                              8000.0                     1   \n",
       "23                                             21000.0                     3   \n",
       "24                                             25000.0                     3   \n",
       "25                                              9000.0                     0   \n",
       "26                                             12000.0                     1   \n",
       "27                                              3000.0                     0   \n",
       "28                                             35000.0                     0   \n",
       "29                                             23000.0                     1   \n",
       "..                                     ...         ...                   ...   \n",
       "822                                            67882.0                     0   \n",
       "823          Germany win after extra time          NaN                     0   \n",
       "824                                            60342.0                     1   \n",
       "825                                            74240.0                     0   \n",
       "826                                            58141.0                     0   \n",
       "827                                            68034.0                     0   \n",
       "828          Germany win after extra time      74738.0                     0   \n",
       "829    Argentina win on penalties (2 - 4)      63267.0                     0   \n",
       "830  Netherlands win on penalties (4 - 3)      51179.0                     0   \n",
       "831                                            68551.0                     1   \n",
       "832                                            58817.0                     0   \n",
       "833   Costa Rica win on penalties (5 - 3)      41242.0                     0   \n",
       "834        Argentina win after extra time      63255.0                     0   \n",
       "835          Belgium win after extra time      51227.0                     0   \n",
       "836       Brazil win on penalties (3 - 2)      57714.0                     0   \n",
       "837                                            73804.0                     1   \n",
       "838                                            58817.0                     0   \n",
       "839   Costa Rica win on penalties (5 - 3)      41242.0                     0   \n",
       "840                                            67882.0                     0   \n",
       "841          Germany win after extra time          NaN                     0   \n",
       "842        Argentina win after extra time      63255.0                     0   \n",
       "843          Belgium win after extra time      51227.0                     0   \n",
       "844                                            74240.0                     0   \n",
       "845                                            60342.0                     1   \n",
       "846                                            68551.0                     1   \n",
       "847  Netherlands win on penalties (4 - 3)      51179.0                     0   \n",
       "848                                            58141.0                     0   \n",
       "849    Argentina win on penalties (2 - 4)      63267.0                     0   \n",
       "850                                            68034.0                     0   \n",
       "851          Germany win after extra time      74738.0                     0   \n",
       "\n",
       "     Half-time Away Goals                        Referee  \\\n",
       "0                       0         LOMBARDI Domingo (URU)   \n",
       "1                       0              MACIAS Jose (ARG)   \n",
       "2                       0            TEJADA Anibal (URU)   \n",
       "3                       0          WARNKEN Alberto (CHI)   \n",
       "4                       0            REGO Gilberto (BRA)   \n",
       "5                       0          CRISTOPHE Henry (BEL)   \n",
       "6                       0       MATEUCCI Francisco (URU)   \n",
       "7                       0              MACIAS Jose (ARG)   \n",
       "8                       0            LANGENUS Jean (BEL)   \n",
       "9                       0            TEJADA Anibal (URU)   \n",
       "10                      1           SAUCEDO Ulises (BOL)   \n",
       "11                      0            BALWAY Thomas (FRA)   \n",
       "12                      0        VALLARINO Ricardo (URU)   \n",
       "13                      0            REGO Gilberto (BRA)   \n",
       "14                      1            LANGENUS Jean (BEL)   \n",
       "15                      0            LANGENUS Jean (BEL)   \n",
       "16                      1            REGO Gilberto (BRA)   \n",
       "17                      2            LANGENUS Jean (BEL)   \n",
       "18                      0     VAN MOORSEL Johannes (NED)   \n",
       "19                      2       BARLASSINA Rinaldo (ITA)   \n",
       "20                      1              EKLIND Ivan (SWE)   \n",
       "21                      1              BRAUN Eugen (AUT)   \n",
       "22                      2         MATTEA Francesco (ITA)   \n",
       "23                      0            BIRLEM Alfred (GER)   \n",
       "24                      0              MERCET Rene (SUI)   \n",
       "25                      1            LANGENUS Jean (BEL)   \n",
       "26                      1            BERANEK Alois (AUT)   \n",
       "27                      0       BARLASSINA Rinaldo (ITA)   \n",
       "28                      0              BAERT Louis (BEL)   \n",
       "29                      0         MATTEA Francesco (ITA)   \n",
       "..                    ...                            ...   \n",
       "822                     0              GEIGER Mark (USA)   \n",
       "823                     0             RICCI Sandro (BRA)   \n",
       "824                     0  Carlos VELASCO CARBALLO (ESP)   \n",
       "825                     1            PITANA Nestor (ARG)   \n",
       "826                     5          RODRIGUEZ Marco (MEX)   \n",
       "827                     2          HAIMOUDI Djamel (ALG)   \n",
       "828                     0           Nicola RIZZOLI (ITA)   \n",
       "829                     0             C�neyt �AKIR (TUR)   \n",
       "830                     0          Ravshan IRMATOV (UZB)   \n",
       "831                     0           Nicola RIZZOLI (ITA)   \n",
       "832                     0            PROENCA Pedro (POR)   \n",
       "833                     0             Ben WILLIAMS (AUS)   \n",
       "834                     0           ERIKSSON Jonas (SWE)   \n",
       "835                     0          HAIMOUDI Djamel (ALG)   \n",
       "836                     0              WEBB Howard (ENG)   \n",
       "837                     0            Bj�rn KUIPERS (NED)   \n",
       "838                     0            PROENCA Pedro (POR)   \n",
       "839                     0             Ben WILLIAMS (AUS)   \n",
       "840                     0              GEIGER Mark (USA)   \n",
       "841                     0             RICCI Sandro (BRA)   \n",
       "842                     0           ERIKSSON Jonas (SWE)   \n",
       "843                     0          HAIMOUDI Djamel (ALG)   \n",
       "844                     1            PITANA Nestor (ARG)   \n",
       "845                     0  Carlos VELASCO CARBALLO (ESP)   \n",
       "846                     0           Nicola RIZZOLI (ITA)   \n",
       "847                     0          Ravshan IRMATOV (UZB)   \n",
       "848                     5          RODRIGUEZ Marco (MEX)   \n",
       "849                     0             C�neyt �AKIR (TUR)   \n",
       "850                     2          HAIMOUDI Djamel (ALG)   \n",
       "851                     0           Nicola RIZZOLI (ITA)   \n",
       "\n",
       "                        Assistant 1                 Assistant 2  RoundID  \\\n",
       "0             CRISTOPHE Henry (BEL)         REGO Gilberto (BRA)      201   \n",
       "1          MATEUCCI Francisco (URU)       WARNKEN Alberto (CHI)      201   \n",
       "2           VALLARINO Ricardo (URU)         BALWAY Thomas (FRA)      201   \n",
       "3               LANGENUS Jean (BEL)    MATEUCCI Francisco (URU)      201   \n",
       "4              SAUCEDO Ulises (BOL)  RADULESCU Constantin (ROU)      201   \n",
       "5           APHESTEGUY Martin (URU)         LANGENUS Jean (BEL)      201   \n",
       "6            LOMBARDI Domingo (URU)       WARNKEN Alberto (CHI)      201   \n",
       "7           APHESTEGUY Martin (URU)         TEJADA Anibal (URU)      201   \n",
       "8               BALWAY Thomas (FRA)       CRISTOPHE Henry (BEL)      201   \n",
       "9            LOMBARDI Domingo (URU)         REGO Gilberto (BRA)      201   \n",
       "10           ALONSO Gualberto (URU)  RADULESCU Constantin (ROU)      201   \n",
       "11         MATEUCCI Francisco (URU)        VALLEJO Gaspar (MEX)      201   \n",
       "12                MACIAS Jose (ARG)      LOMBARDI Domingo (URU)      201   \n",
       "13            WARNKEN Alberto (CHI)        SAUCEDO Ulises (BOL)      201   \n",
       "14            CRISTOPHE Henry (BEL)        SAUCEDO Ulises (BOL)      201   \n",
       "15             VALLEJO Gaspar (MEX)       WARNKEN Alberto (CHI)      202   \n",
       "16             SAUCEDO Ulises (BOL)         BALWAY Thomas (FRA)      202   \n",
       "17             SAUCEDO Ulises (BOL)       CRISTOPHE Henry (BEL)      405   \n",
       "18            CAIRONI Camillo (ITA)           BAERT Louis (BEL)      204   \n",
       "19           DATTILO Generoso (ITA)          SASSI Otello (ITA)      204   \n",
       "20              BERANEK Alois (AUT)   BONIVENTO Ferruccio (ITA)      204   \n",
       "21             CARRARO Albino (ITA)     TURBIANI Giuseppe (ITA)      204   \n",
       "22       MELANDRI Ermenegildo (ITA)         BAERT Jacques (FRA)      204   \n",
       "23           CARMINATI Ettore (ITA)      IVANCSICS Mihaly (HUN)      204   \n",
       "24             ESCARTIN Pedro (ESP)       ZENISEK Bohumil (TCH)      204   \n",
       "25            SCARPI Giuseppe (ITA)     SCORZONI Raffaele (ITA)      204   \n",
       "26            MOHAMED Youssuf (EGY)         BAERT Jacques (FRA)      418   \n",
       "27                MERCET Rene (SUI)  VAN MOORSEL Johannes (NED)      418   \n",
       "28            ZENISEK Bohumil (TCH)      IVANCSICS Mihaly (HUN)      418   \n",
       "29             ESCARTIN Pedro (ESP)         BIRLEM Alfred (GER)      418   \n",
       "..                              ...                         ...      ...   \n",
       "822                 HURD Sean (USA)          FLETCHER Joe (CAN)   255951   \n",
       "823       DE CARVALHO Emerson (BRA)     VAN GASSE Marcelo (BRA)   255951   \n",
       "824  ALONSO FERNANDEZ Roberto (ESP)            YUSTE Juan (ESP)   255953   \n",
       "825            MAIDANA Hernan (ARG)    BELATTI Juan Pablo (ARG)   255953   \n",
       "826         TORRENTERA Marvin (MEX)       QUINTERO Marcos (MEX)   255955   \n",
       "827            ACHIK Redouane (MAR)     ETCHIALI Abdelhak (ALG)   255957   \n",
       "828           Renato FAVERANI (ITA)        Andrea STEFANI (ITA)   255959   \n",
       "829            DURAN Bahattin (TUR)           ONGUN Tarik (TUR)   255955   \n",
       "830     RASULOV Abduxamidullo (UZB)    KOCHKAROV Bakhadyr (KGZ)   255953   \n",
       "831           Renato FAVERANI (ITA)        Andrea STEFANI (ITA)   255953   \n",
       "832           MIRANDA Bertino (POR)            TRIGO Jose (POR)   255951   \n",
       "833             CREAM Matthew (AUS)            ANAZ Hakan (AUS)   255951   \n",
       "834         KLASENIUS Mathias (SWE)       WARNMARK Daniel (SWE)   255951   \n",
       "835            ACHIK Redouane (MAR)     ETCHIALI Abdelhak (ALG)   255951   \n",
       "836         MULLARKEY Michael (ENG)           Darren CANN (ENG)   255951   \n",
       "837         Sander VAN ROEKEL (NED)        Erwin ZEINSTRA (NED)   255951   \n",
       "838           MIRANDA Bertino (POR)            TRIGO Jose (POR)   255951   \n",
       "839             CREAM Matthew (AUS)            ANAZ Hakan (AUS)   255951   \n",
       "840                 HURD Sean (USA)          FLETCHER Joe (CAN)   255951   \n",
       "841       DE CARVALHO Emerson (BRA)     VAN GASSE Marcelo (BRA)   255951   \n",
       "842         KLASENIUS Mathias (SWE)       WARNMARK Daniel (SWE)   255951   \n",
       "843            ACHIK Redouane (MAR)     ETCHIALI Abdelhak (ALG)   255951   \n",
       "844            MAIDANA Hernan (ARG)    BELATTI Juan Pablo (ARG)   255953   \n",
       "845  ALONSO FERNANDEZ Roberto (ESP)            YUSTE Juan (ESP)   255953   \n",
       "846           Renato FAVERANI (ITA)        Andrea STEFANI (ITA)   255953   \n",
       "847     RASULOV Abduxamidullo (UZB)    KOCHKAROV Bakhadyr (KGZ)   255953   \n",
       "848         TORRENTERA Marvin (MEX)       QUINTERO Marcos (MEX)   255955   \n",
       "849            DURAN Bahattin (TUR)           ONGUN Tarik (TUR)   255955   \n",
       "850            ACHIK Redouane (MAR)     ETCHIALI Abdelhak (ALG)   255957   \n",
       "851           Renato FAVERANI (ITA)        Andrea STEFANI (ITA)   255959   \n",
       "\n",
       "       MatchID Home Team Initials Away Team Initials  \n",
       "0         1096                FRA                MEX  \n",
       "1         1090                USA                BEL  \n",
       "2         1093                YUG                BRA  \n",
       "3         1098                ROU                PER  \n",
       "4         1085                ARG                FRA  \n",
       "5         1095                CHI                MEX  \n",
       "6         1092                YUG                BOL  \n",
       "7         1097                USA                PAR  \n",
       "8         1099                URU                PER  \n",
       "9         1094                CHI                FRA  \n",
       "10        1086                ARG                MEX  \n",
       "11        1091                BRA                BOL  \n",
       "12        1089                PAR                BEL  \n",
       "13        1100                URU                ROU  \n",
       "14        1084                ARG                CHI  \n",
       "15        1088                ARG                USA  \n",
       "16        1101                URU                YUG  \n",
       "17        1087                URU                ARG  \n",
       "18        1104                AUT                FRA  \n",
       "19        1119                HUN                EGY  \n",
       "20        1133                SUI                NED  \n",
       "21        1102                SWE                ARG  \n",
       "22        1108                GER                BEL  \n",
       "23        1111                ESP                BRA  \n",
       "24        1135                ITA                USA  \n",
       "25        1141                TCH                ROU  \n",
       "26        1143                TCH                SUI  \n",
       "27        1129                GER                SWE  \n",
       "28        1122                ITA                ESP  \n",
       "29        1106                AUT                HUN  \n",
       "..         ...                ...                ...  \n",
       "822  300186462                FRA                NGA  \n",
       "823  300186460                GER                ALG  \n",
       "824  300186461                BRA                COL  \n",
       "825  300186485                FRA                GER  \n",
       "826  300186474                BRA                GER  \n",
       "827  300186502                BRA                NED  \n",
       "828  300186501                GER                ARG  \n",
       "829  300186490                NED                ARG  \n",
       "830  300186488                NED                CRC  \n",
       "831  300186504                ARG                BEL  \n",
       "832  300186508                NED                MEX  \n",
       "833  300186459                CRC                GRE  \n",
       "834  300186503                ARG                SUI  \n",
       "835  300186497                BEL                USA  \n",
       "836  300186487                BRA                CHI  \n",
       "837  300186491                COL                URU  \n",
       "838  300186508                NED                MEX  \n",
       "839  300186459                CRC                GRE  \n",
       "840  300186462                FRA                NGA  \n",
       "841  300186460                GER                ALG  \n",
       "842  300186503                ARG                SUI  \n",
       "843  300186497                BEL                USA  \n",
       "844  300186485                FRA                GER  \n",
       "845  300186461                BRA                COL  \n",
       "846  300186504                ARG                BEL  \n",
       "847  300186488                NED                CRC  \n",
       "848  300186474                BRA                GER  \n",
       "849  300186490                NED                ARG  \n",
       "850  300186502                BRA                NED  \n",
       "851  300186501                GER                ARG  \n",
       "\n",
       "[852 rows x 20 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches = matches.rename(index=str, columns={\"Year\": \"year\", \"Home Team Name\" : \"team1\", \"Away Team Name\": \"team2\",\n",
    "                                            \"Home Team Goals\": \"score1\", \"Away Team Goals\": \"score2\"})\n",
    "matches['id'] = matches.index\n",
    "matches = matches.loc[:, ['id', 'year', 'team1', 'score1', 'score2', 'team2']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches = matches[matches.year >= 1950]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "# The given CSV was bad\n",
    "matches.loc[:, ['team1']] = matches['team1'].map(lambda name: name.replace('rn\">', ''))\n",
    "matches.loc[:, ['team2']] = matches['team2'].map(lambda name: name.replace('rn\">', ''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "# unicode problenms, i suspect related to ivory coast\n",
    "matches.loc[:, ['team1']] = matches['team1'].map(lambda name: 'Ivory Coast' if 'Ivoire' in name else name)\n",
    "matches.loc[:, ['team2']] = matches['team2'].map(lambda name: 'Ivory Coast' if 'Ivoire' in name else name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "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>id</th>\n",
       "      <th>year</th>\n",
       "      <th>team1</th>\n",
       "      <th>score1</th>\n",
       "      <th>score2</th>\n",
       "      <th>team2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>53</td>\n",
       "      <td>1950</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Mexico</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>54</td>\n",
       "      <td>1950</td>\n",
       "      <td>England</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Chile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>55</td>\n",
       "      <td>1950</td>\n",
       "      <td>Spain</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>56</td>\n",
       "      <td>1950</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Italy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>57</td>\n",
       "      <td>1950</td>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Switzerland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>58</td>\n",
       "      <td>1950</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Switzerland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>59</td>\n",
       "      <td>1950</td>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>Mexico</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>60</td>\n",
       "      <td>1950</td>\n",
       "      <td>Spain</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Chile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>61</td>\n",
       "      <td>1950</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Paraguay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>62</td>\n",
       "      <td>1950</td>\n",
       "      <td>USA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>63</td>\n",
       "      <td>1950</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Yugoslavia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>64</td>\n",
       "      <td>1950</td>\n",
       "      <td>Spain</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>65</td>\n",
       "      <td>1950</td>\n",
       "      <td>Italy</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Paraguay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>66</td>\n",
       "      <td>1950</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Bolivia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>67</td>\n",
       "      <td>1950</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Mexico</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>68</td>\n",
       "      <td>1950</td>\n",
       "      <td>Chile</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>69</td>\n",
       "      <td>1950</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Spain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>70</td>\n",
       "      <td>1950</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>Sweden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>71</td>\n",
       "      <td>1950</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>Spain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>72</td>\n",
       "      <td>1950</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Sweden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>73</td>\n",
       "      <td>1950</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Spain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>74</td>\n",
       "      <td>1950</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Brazil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>75</td>\n",
       "      <td>1954</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Czechoslovakia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>76</td>\n",
       "      <td>1954</td>\n",
       "      <td>Austria</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Scotland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>77</td>\n",
       "      <td>1954</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Mexico</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>78</td>\n",
       "      <td>1954</td>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>79</td>\n",
       "      <td>1954</td>\n",
       "      <td>Germany FR</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>Turkey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>80</td>\n",
       "      <td>1954</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>Korea Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>81</td>\n",
       "      <td>1954</td>\n",
       "      <td>England</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Belgium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>82</td>\n",
       "      <td>1954</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Italy</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>822</td>\n",
       "      <td>2014</td>\n",
       "      <td>France</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Nigeria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>823</td>\n",
       "      <td>2014</td>\n",
       "      <td>Germany</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Algeria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>824</td>\n",
       "      <td>2014</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Colombia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>825</td>\n",
       "      <td>2014</td>\n",
       "      <td>France</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>826</td>\n",
       "      <td>2014</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>827</td>\n",
       "      <td>2014</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Netherlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>828</td>\n",
       "      <td>2014</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>829</td>\n",
       "      <td>2014</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>830</th>\n",
       "      <td>830</td>\n",
       "      <td>2014</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Costa Rica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>831</th>\n",
       "      <td>831</td>\n",
       "      <td>2014</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Belgium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>832</th>\n",
       "      <td>832</td>\n",
       "      <td>2014</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Mexico</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>833</td>\n",
       "      <td>2014</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Greece</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>834</td>\n",
       "      <td>2014</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Switzerland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>835</td>\n",
       "      <td>2014</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>836</td>\n",
       "      <td>2014</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Chile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>837</td>\n",
       "      <td>2014</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Uruguay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>838</td>\n",
       "      <td>2014</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Mexico</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>839</td>\n",
       "      <td>2014</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Greece</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>840</td>\n",
       "      <td>2014</td>\n",
       "      <td>France</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Nigeria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>841</th>\n",
       "      <td>841</td>\n",
       "      <td>2014</td>\n",
       "      <td>Germany</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Algeria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>842</td>\n",
       "      <td>2014</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Switzerland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>843</td>\n",
       "      <td>2014</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>844</td>\n",
       "      <td>2014</td>\n",
       "      <td>France</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>845</th>\n",
       "      <td>845</td>\n",
       "      <td>2014</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Colombia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>846</th>\n",
       "      <td>846</td>\n",
       "      <td>2014</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Belgium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>847</th>\n",
       "      <td>847</td>\n",
       "      <td>2014</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Costa Rica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>848</th>\n",
       "      <td>848</td>\n",
       "      <td>2014</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>849</td>\n",
       "      <td>2014</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>850</td>\n",
       "      <td>2014</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Netherlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>851</th>\n",
       "      <td>851</td>\n",
       "      <td>2014</td>\n",
       "      <td>Germany</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Argentina</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>799 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id  year        team1  score1  score2           team2\n",
       "53    53  1950       Brazil       4       0          Mexico\n",
       "54    54  1950      England       2       0           Chile\n",
       "55    55  1950        Spain       3       1             USA\n",
       "56    56  1950       Sweden       3       2           Italy\n",
       "57    57  1950   Yugoslavia       3       0     Switzerland\n",
       "58    58  1950       Brazil       2       2     Switzerland\n",
       "59    59  1950   Yugoslavia       4       1          Mexico\n",
       "60    60  1950        Spain       2       0           Chile\n",
       "61    61  1950       Sweden       2       2        Paraguay\n",
       "62    62  1950          USA       1       0         England\n",
       "63    63  1950       Brazil       2       0      Yugoslavia\n",
       "64    64  1950        Spain       1       0         England\n",
       "65    65  1950        Italy       2       0        Paraguay\n",
       "66    66  1950      Uruguay       8       0         Bolivia\n",
       "67    67  1950  Switzerland       2       1          Mexico\n",
       "68    68  1950        Chile       5       2             USA\n",
       "69    69  1950      Uruguay       2       2           Spain\n",
       "70    70  1950       Brazil       7       1          Sweden\n",
       "71    71  1950       Brazil       6       1           Spain\n",
       "72    72  1950      Uruguay       3       2          Sweden\n",
       "73    73  1950       Sweden       3       1           Spain\n",
       "74    74  1950      Uruguay       2       1          Brazil\n",
       "75    75  1954      Uruguay       2       0  Czechoslovakia\n",
       "76    76  1954      Austria       1       0        Scotland\n",
       "77    77  1954       Brazil       5       0          Mexico\n",
       "78    78  1954   Yugoslavia       1       0          France\n",
       "79    79  1954   Germany FR       4       1          Turkey\n",
       "80    80  1954      Hungary       9       0  Korea Republic\n",
       "81    81  1954      England       4       4         Belgium\n",
       "82    82  1954  Switzerland       2       1           Italy\n",
       "..   ...   ...          ...     ...     ...             ...\n",
       "822  822  2014       France       2       0         Nigeria\n",
       "823  823  2014      Germany       2       1         Algeria\n",
       "824  824  2014       Brazil       2       1        Colombia\n",
       "825  825  2014       France       0       1         Germany\n",
       "826  826  2014       Brazil       1       7         Germany\n",
       "827  827  2014       Brazil       0       3     Netherlands\n",
       "828  828  2014      Germany       1       0       Argentina\n",
       "829  829  2014  Netherlands       0       0       Argentina\n",
       "830  830  2014  Netherlands       0       0      Costa Rica\n",
       "831  831  2014    Argentina       1       0         Belgium\n",
       "832  832  2014  Netherlands       2       1          Mexico\n",
       "833  833  2014   Costa Rica       1       1          Greece\n",
       "834  834  2014    Argentina       1       0     Switzerland\n",
       "835  835  2014      Belgium       2       1             USA\n",
       "836  836  2014       Brazil       1       1           Chile\n",
       "837  837  2014     Colombia       2       0         Uruguay\n",
       "838  838  2014  Netherlands       2       1          Mexico\n",
       "839  839  2014   Costa Rica       1       1          Greece\n",
       "840  840  2014       France       2       0         Nigeria\n",
       "841  841  2014      Germany       2       1         Algeria\n",
       "842  842  2014    Argentina       1       0     Switzerland\n",
       "843  843  2014      Belgium       2       1             USA\n",
       "844  844  2014       France       0       1         Germany\n",
       "845  845  2014       Brazil       2       1        Colombia\n",
       "846  846  2014    Argentina       1       0         Belgium\n",
       "847  847  2014  Netherlands       0       0      Costa Rica\n",
       "848  848  2014       Brazil       1       7         Germany\n",
       "849  849  2014  Netherlands       0       0       Argentina\n",
       "850  850  2014       Brazil       0       3     Netherlands\n",
       "851  851  2014      Germany       1       0       Argentina\n",
       "\n",
       "[799 rows x 6 columns]"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_teams = set(list(matches.team1) + list(matches.team2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "old_csv = pd.read_csv('./raw_matches.csv')\n",
    "old_teams = set(list(old_csv.team1) + list(old_csv.team2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Bosnia and Herzegovina',\n",
       " 'German DR',\n",
       " 'Germany FR',\n",
       " 'IR Iran',\n",
       " 'Korea DPR',\n",
       " 'Korea Republic',\n",
       " 'USA'}"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_teams.difference(old_teams)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Bosnia Herzegovina',\n",
       " 'East Germany',\n",
       " 'North Korea',\n",
       " 'South Korea',\n",
       " 'United States',\n",
       " 'West Germany'}"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "old_teams.difference(new_teams)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches.to_csv('raw_matches_new.csv')"
   ]
  },
  {
   "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
}