3. FIFA 2022 Win Predict.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "231a5e32",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.ensemble import RandomForestRegressor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "ec608469",
   "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>date</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_team_continent</th>\n",
       "      <th>away_team_continent</th>\n",
       "      <th>home_team_fifa_rank</th>\n",
       "      <th>away_team_fifa_rank</th>\n",
       "      <th>home_team_total_fifa_points</th>\n",
       "      <th>away_team_total_fifa_points</th>\n",
       "      <th>home_team_score</th>\n",
       "      <th>...</th>\n",
       "      <th>shoot_out</th>\n",
       "      <th>home_team_result</th>\n",
       "      <th>home_team_goalkeeper_score</th>\n",
       "      <th>away_team_goalkeeper_score</th>\n",
       "      <th>home_team_mean_defense_score</th>\n",
       "      <th>home_team_mean_offense_score</th>\n",
       "      <th>home_team_mean_midfield_score</th>\n",
       "      <th>away_team_mean_defense_score</th>\n",
       "      <th>away_team_mean_offense_score</th>\n",
       "      <th>away_team_mean_midfield_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>Bolivia</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>59</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Win</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>South America</td>\n",
       "      <td>North America</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Draw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>35</td>\n",
       "      <td>94</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Win</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>65</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Win</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>67</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Lose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date home_team     away_team home_team_continent away_team_continent  \\\n",
       "0  1993-08-08   Bolivia       Uruguay       South America       South America   \n",
       "1  1993-08-08    Brazil        Mexico       South America       North America   \n",
       "2  1993-08-08   Ecuador     Venezuela       South America       South America   \n",
       "3  1993-08-08    Guinea  Sierra Leone              Africa              Africa   \n",
       "4  1993-08-08  Paraguay     Argentina       South America       South America   \n",
       "\n",
       "   home_team_fifa_rank  away_team_fifa_rank  home_team_total_fifa_points  \\\n",
       "0                   59                   22                            0   \n",
       "1                    8                   14                            0   \n",
       "2                   35                   94                            0   \n",
       "3                   65                   86                            0   \n",
       "4                   67                    5                            0   \n",
       "\n",
       "   away_team_total_fifa_points  home_team_score  ...  shoot_out  \\\n",
       "0                            0                3  ...         No   \n",
       "1                            0                1  ...         No   \n",
       "2                            0                5  ...         No   \n",
       "3                            0                1  ...         No   \n",
       "4                            0                1  ...         No   \n",
       "\n",
       "  home_team_result home_team_goalkeeper_score away_team_goalkeeper_score  \\\n",
       "0              Win                        NaN                        NaN   \n",
       "1             Draw                        NaN                        NaN   \n",
       "2              Win                        NaN                        NaN   \n",
       "3              Win                        NaN                        NaN   \n",
       "4             Lose                        NaN                        NaN   \n",
       "\n",
       "   home_team_mean_defense_score home_team_mean_offense_score  \\\n",
       "0                           NaN                          NaN   \n",
       "1                           NaN                          NaN   \n",
       "2                           NaN                          NaN   \n",
       "3                           NaN                          NaN   \n",
       "4                           NaN                          NaN   \n",
       "\n",
       "  home_team_mean_midfield_score  away_team_mean_defense_score  \\\n",
       "0                           NaN                           NaN   \n",
       "1                           NaN                           NaN   \n",
       "2                           NaN                           NaN   \n",
       "3                           NaN                           NaN   \n",
       "4                           NaN                           NaN   \n",
       "\n",
       "   away_team_mean_offense_score  away_team_mean_midfield_score  \n",
       "0                           NaN                            NaN  \n",
       "1                           NaN                            NaN  \n",
       "2                           NaN                            NaN  \n",
       "3                           NaN                            NaN  \n",
       "4                           NaN                            NaN  \n",
       "\n",
       "[5 rows x 25 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"data/proj3/international_matches.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "e5e7c3ae",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>23911</th>\n",
       "      <th>23912</th>\n",
       "      <th>23913</th>\n",
       "      <th>23914</th>\n",
       "      <th>23915</th>\n",
       "      <th>23916</th>\n",
       "      <th>23917</th>\n",
       "      <th>23918</th>\n",
       "      <th>23919</th>\n",
       "      <th>23920</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>1993-08-08</td>\n",
       "      <td>1993-08-09</td>\n",
       "      <td>1993-08-11</td>\n",
       "      <td>1993-08-11</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "      <td>2022-06-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>...</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>Romania</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>Chile</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Korea Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>Eswatini</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>Norway</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>...</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Montenegro</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>Andorra</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Egypt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_continent</th>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>...</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>South America</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_continent</th>\n",
       "      <td>South America</td>\n",
       "      <td>North America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>...</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_fifa_rank</th>\n",
       "      <td>59</td>\n",
       "      <td>8</td>\n",
       "      <td>35</td>\n",
       "      <td>65</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>50</td>\n",
       "      <td>65</td>\n",
       "      <td>111</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>59</td>\n",
       "      <td>48</td>\n",
       "      <td>94</td>\n",
       "      <td>43</td>\n",
       "      <td>180</td>\n",
       "      <td>192</td>\n",
       "      <td>28</td>\n",
       "      <td>23</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_fifa_rank</th>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>94</td>\n",
       "      <td>86</td>\n",
       "      <td>5</td>\n",
       "      <td>19</td>\n",
       "      <td>102</td>\n",
       "      <td>86</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>57</td>\n",
       "      <td>70</td>\n",
       "      <td>124</td>\n",
       "      <td>138</td>\n",
       "      <td>153</td>\n",
       "      <td>135</td>\n",
       "      <td>60</td>\n",
       "      <td>35</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_total_fifa_points</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1535</td>\n",
       "      <td>1388</td>\n",
       "      <td>1446</td>\n",
       "      <td>1229</td>\n",
       "      <td>1461</td>\n",
       "      <td>932</td>\n",
       "      <td>895</td>\n",
       "      <td>1526</td>\n",
       "      <td>1553</td>\n",
       "      <td>1519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_total_fifa_points</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1449</td>\n",
       "      <td>1406</td>\n",
       "      <td>1342</td>\n",
       "      <td>1137</td>\n",
       "      <td>1092</td>\n",
       "      <td>1040</td>\n",
       "      <td>1105</td>\n",
       "      <td>1387</td>\n",
       "      <td>1499</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_score</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_score</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tournament</th>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>...</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>Kirin Cup</td>\n",
       "      <td>Kirin Cup</td>\n",
       "      <td>Friendly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <td>La Paz</td>\n",
       "      <td>Maceió</td>\n",
       "      <td>Quito</td>\n",
       "      <td>Conakry</td>\n",
       "      <td>Asunción</td>\n",
       "      <td>Lima</td>\n",
       "      <td>Harare</td>\n",
       "      <td>Conakry</td>\n",
       "      <td>Toftir</td>\n",
       "      <td>Borås</td>\n",
       "      <td>...</td>\n",
       "      <td>Łódź</td>\n",
       "      <td>Zenica</td>\n",
       "      <td>Bucharest</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>İzmir</td>\n",
       "      <td>Chișinău</td>\n",
       "      <td>Vaduz</td>\n",
       "      <td>Suita</td>\n",
       "      <td>Suita</td>\n",
       "      <td>Seoul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>...</td>\n",
       "      <td>Poland</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>Romania</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Korea Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>neutral_location</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shoot_out</th>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_result</th>\n",
       "      <td>Win</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>...</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_goalkeeper_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>75.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_goalkeeper_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>75.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>71.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_mean_defense_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>74.8</td>\n",
       "      <td>74.2</td>\n",
       "      <td>73.5</td>\n",
       "      <td>68.5</td>\n",
       "      <td>78.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.5</td>\n",
       "      <td>75.2</td>\n",
       "      <td>73.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_mean_offense_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>78.7</td>\n",
       "      <td>77.0</td>\n",
       "      <td>73.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.7</td>\n",
       "      <td>75.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_mean_midfield_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>80.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>69.8</td>\n",
       "      <td>78.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78.2</td>\n",
       "      <td>77.5</td>\n",
       "      <td>73.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_mean_defense_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>76.5</td>\n",
       "      <td>70.0</td>\n",
       "      <td>76.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.5</td>\n",
       "      <td>70.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_mean_offense_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>72.7</td>\n",
       "      <td>72.3</td>\n",
       "      <td>74.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.0</td>\n",
       "      <td>72.3</td>\n",
       "      <td>79.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_mean_midfield_score</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>73.8</td>\n",
       "      <td>73.5</td>\n",
       "      <td>68.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78.2</td>\n",
       "      <td>74.0</td>\n",
       "      <td>70.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 23921 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      0              1      \\\n",
       "date                                             1993-08-08     1993-08-08   \n",
       "home_team                                           Bolivia         Brazil   \n",
       "away_team                                           Uruguay         Mexico   \n",
       "home_team_continent                           South America  South America   \n",
       "away_team_continent                           South America  North America   \n",
       "home_team_fifa_rank                                      59              8   \n",
       "away_team_fifa_rank                                      22             14   \n",
       "home_team_total_fifa_points                               0              0   \n",
       "away_team_total_fifa_points                               0              0   \n",
       "home_team_score                                           3              1   \n",
       "away_team_score                                           1              1   \n",
       "tournament                     FIFA World Cup qualification       Friendly   \n",
       "city                                                 La Paz         Maceió   \n",
       "country                                             Bolivia         Brazil   \n",
       "neutral_location                                      False          False   \n",
       "shoot_out                                                No             No   \n",
       "home_team_result                                        Win           Draw   \n",
       "home_team_goalkeeper_score                              NaN            NaN   \n",
       "away_team_goalkeeper_score                              NaN            NaN   \n",
       "home_team_mean_defense_score                            NaN            NaN   \n",
       "home_team_mean_offense_score                            NaN            NaN   \n",
       "home_team_mean_midfield_score                           NaN            NaN   \n",
       "away_team_mean_defense_score                            NaN            NaN   \n",
       "away_team_mean_offense_score                            NaN            NaN   \n",
       "away_team_mean_midfield_score                           NaN            NaN   \n",
       "\n",
       "                                                      2             3      \\\n",
       "date                                             1993-08-08    1993-08-08   \n",
       "home_team                                           Ecuador        Guinea   \n",
       "away_team                                         Venezuela  Sierra Leone   \n",
       "home_team_continent                           South America        Africa   \n",
       "away_team_continent                           South America        Africa   \n",
       "home_team_fifa_rank                                      35            65   \n",
       "away_team_fifa_rank                                      94            86   \n",
       "home_team_total_fifa_points                               0             0   \n",
       "away_team_total_fifa_points                               0             0   \n",
       "home_team_score                                           5             1   \n",
       "away_team_score                                           0             0   \n",
       "tournament                     FIFA World Cup qualification      Friendly   \n",
       "city                                                  Quito       Conakry   \n",
       "country                                             Ecuador        Guinea   \n",
       "neutral_location                                      False         False   \n",
       "shoot_out                                                No            No   \n",
       "home_team_result                                        Win           Win   \n",
       "home_team_goalkeeper_score                              NaN           NaN   \n",
       "away_team_goalkeeper_score                              NaN           NaN   \n",
       "home_team_mean_defense_score                            NaN           NaN   \n",
       "home_team_mean_offense_score                            NaN           NaN   \n",
       "home_team_mean_midfield_score                           NaN           NaN   \n",
       "away_team_mean_defense_score                            NaN           NaN   \n",
       "away_team_mean_offense_score                            NaN           NaN   \n",
       "away_team_mean_midfield_score                           NaN           NaN   \n",
       "\n",
       "                                                      4      \\\n",
       "date                                             1993-08-08   \n",
       "home_team                                          Paraguay   \n",
       "away_team                                         Argentina   \n",
       "home_team_continent                           South America   \n",
       "away_team_continent                           South America   \n",
       "home_team_fifa_rank                                      67   \n",
       "away_team_fifa_rank                                       5   \n",
       "home_team_total_fifa_points                               0   \n",
       "away_team_total_fifa_points                               0   \n",
       "home_team_score                                           1   \n",
       "away_team_score                                           3   \n",
       "tournament                     FIFA World Cup qualification   \n",
       "city                                               Asunción   \n",
       "country                                            Paraguay   \n",
       "neutral_location                                      False   \n",
       "shoot_out                                                No   \n",
       "home_team_result                                       Lose   \n",
       "home_team_goalkeeper_score                              NaN   \n",
       "away_team_goalkeeper_score                              NaN   \n",
       "home_team_mean_defense_score                            NaN   \n",
       "home_team_mean_offense_score                            NaN   \n",
       "home_team_mean_midfield_score                           NaN   \n",
       "away_team_mean_defense_score                            NaN   \n",
       "away_team_mean_offense_score                            NaN   \n",
       "away_team_mean_midfield_score                           NaN   \n",
       "\n",
       "                                                      5           6      \\\n",
       "date                                             1993-08-08  1993-08-08   \n",
       "home_team                                              Peru    Zimbabwe   \n",
       "away_team                                          Colombia    Eswatini   \n",
       "home_team_continent                           South America      Africa   \n",
       "away_team_continent                           South America      Africa   \n",
       "home_team_fifa_rank                                      70          50   \n",
       "away_team_fifa_rank                                      19         102   \n",
       "home_team_total_fifa_points                               0           0   \n",
       "away_team_total_fifa_points                               0           0   \n",
       "home_team_score                                           0           2   \n",
       "away_team_score                                           1           0   \n",
       "tournament                     FIFA World Cup qualification    Friendly   \n",
       "city                                                   Lima      Harare   \n",
       "country                                                Peru    Zimbabwe   \n",
       "neutral_location                                      False       False   \n",
       "shoot_out                                                No          No   \n",
       "home_team_result                                       Lose         Win   \n",
       "home_team_goalkeeper_score                              NaN         NaN   \n",
       "away_team_goalkeeper_score                              NaN         NaN   \n",
       "home_team_mean_defense_score                            NaN         NaN   \n",
       "home_team_mean_offense_score                            NaN         NaN   \n",
       "home_team_mean_midfield_score                           NaN         NaN   \n",
       "away_team_mean_defense_score                            NaN         NaN   \n",
       "away_team_mean_offense_score                            NaN         NaN   \n",
       "away_team_mean_midfield_score                           NaN         NaN   \n",
       "\n",
       "                                      7              8            9      ...  \\\n",
       "date                             1993-08-09     1993-08-11   1993-08-11  ...   \n",
       "home_team                            Guinea  Faroe Islands       Sweden  ...   \n",
       "away_team                      Sierra Leone         Norway  Switzerland  ...   \n",
       "home_team_continent                  Africa         Europe       Europe  ...   \n",
       "away_team_continent                  Africa         Europe       Europe  ...   \n",
       "home_team_fifa_rank                      65            111            4  ...   \n",
       "away_team_fifa_rank                      86              9            3  ...   \n",
       "home_team_total_fifa_points               0              0            0  ...   \n",
       "away_team_total_fifa_points               0              0            0  ...   \n",
       "home_team_score                           4              0            1  ...   \n",
       "away_team_score                           0              7            2  ...   \n",
       "tournament                         Friendly       Friendly     Friendly  ...   \n",
       "city                                Conakry         Toftir        Borås  ...   \n",
       "country                              Guinea  Faroe Islands       Sweden  ...   \n",
       "neutral_location                      False          False        False  ...   \n",
       "shoot_out                                No             No           No  ...   \n",
       "home_team_result                        Win           Lose         Lose  ...   \n",
       "home_team_goalkeeper_score              NaN            NaN          NaN  ...   \n",
       "away_team_goalkeeper_score              NaN            NaN          NaN  ...   \n",
       "home_team_mean_defense_score            NaN            NaN          NaN  ...   \n",
       "home_team_mean_offense_score            NaN            NaN          NaN  ...   \n",
       "home_team_mean_midfield_score           NaN            NaN          NaN  ...   \n",
       "away_team_mean_defense_score            NaN            NaN          NaN  ...   \n",
       "away_team_mean_offense_score            NaN            NaN          NaN  ...   \n",
       "away_team_mean_midfield_score           NaN            NaN          NaN  ...   \n",
       "\n",
       "                                             23911                   23912  \\\n",
       "date                                    2022-06-14              2022-06-14   \n",
       "home_team                                  Ukraine  Bosnia and Herzegovina   \n",
       "away_team                      Republic of Ireland                 Finland   \n",
       "home_team_continent                         Europe                  Europe   \n",
       "away_team_continent                         Europe                  Europe   \n",
       "home_team_fifa_rank                             27                      59   \n",
       "away_team_fifa_rank                             47                      57   \n",
       "home_team_total_fifa_points                   1535                    1388   \n",
       "away_team_total_fifa_points                   1449                    1406   \n",
       "home_team_score                                  1                       3   \n",
       "away_team_score                                  1                       2   \n",
       "tournament                     UEFA Nations League     UEFA Nations League   \n",
       "city                                          Łódź                  Zenica   \n",
       "country                                     Poland  Bosnia and Herzegovina   \n",
       "neutral_location                              True                   False   \n",
       "shoot_out                                       No                      No   \n",
       "home_team_result                              Draw                     Win   \n",
       "home_team_goalkeeper_score                    75.0                    76.0   \n",
       "away_team_goalkeeper_score                    75.0                    83.0   \n",
       "home_team_mean_defense_score                  74.8                    74.2   \n",
       "home_team_mean_offense_score                  78.7                    77.0   \n",
       "home_team_mean_midfield_score                 80.0                    78.0   \n",
       "away_team_mean_defense_score                  76.5                    70.0   \n",
       "away_team_mean_offense_score                  72.7                    72.3   \n",
       "away_team_mean_midfield_score                 73.8                    73.5   \n",
       "\n",
       "                                             23913                23914  \\\n",
       "date                                    2022-06-14           2022-06-14   \n",
       "home_team                                  Romania           Luxembourg   \n",
       "away_team                               Montenegro        Faroe Islands   \n",
       "home_team_continent                         Europe               Europe   \n",
       "away_team_continent                         Europe               Europe   \n",
       "home_team_fifa_rank                             48                   94   \n",
       "away_team_fifa_rank                             70                  124   \n",
       "home_team_total_fifa_points                   1446                 1229   \n",
       "away_team_total_fifa_points                   1342                 1137   \n",
       "home_team_score                                  0                    2   \n",
       "away_team_score                                  3                    2   \n",
       "tournament                     UEFA Nations League  UEFA Nations League   \n",
       "city                                     Bucharest           Luxembourg   \n",
       "country                                    Romania           Luxembourg   \n",
       "neutral_location                             False                False   \n",
       "shoot_out                                       No                   No   \n",
       "home_team_result                              Lose                 Draw   \n",
       "home_team_goalkeeper_score                    77.0                 69.0   \n",
       "away_team_goalkeeper_score                    65.0                  NaN   \n",
       "home_team_mean_defense_score                  73.5                 68.5   \n",
       "home_team_mean_offense_score                  73.7                  NaN   \n",
       "home_team_mean_midfield_score                 75.0                 69.8   \n",
       "away_team_mean_defense_score                  76.2                  NaN   \n",
       "away_team_mean_offense_score                  74.7                  NaN   \n",
       "away_team_mean_midfield_score                 68.2                  NaN   \n",
       "\n",
       "                                             23915                23916  \\\n",
       "date                                    2022-06-14           2022-06-14   \n",
       "home_team                                   Turkey              Moldova   \n",
       "away_team                                Lithuania              Andorra   \n",
       "home_team_continent                         Europe               Europe   \n",
       "away_team_continent                         Europe               Europe   \n",
       "home_team_fifa_rank                             43                  180   \n",
       "away_team_fifa_rank                            138                  153   \n",
       "home_team_total_fifa_points                   1461                  932   \n",
       "away_team_total_fifa_points                   1092                 1040   \n",
       "home_team_score                                  2                    2   \n",
       "away_team_score                                  0                    1   \n",
       "tournament                     UEFA Nations League  UEFA Nations League   \n",
       "city                                         İzmir             Chișinău   \n",
       "country                                     Turkey              Moldova   \n",
       "neutral_location                             False                False   \n",
       "shoot_out                                       No                   No   \n",
       "home_team_result                               Win                  Win   \n",
       "home_team_goalkeeper_score                    79.0                 65.0   \n",
       "away_team_goalkeeper_score                    71.0                  NaN   \n",
       "home_team_mean_defense_score                  78.2                  NaN   \n",
       "home_team_mean_offense_score                  76.7                  NaN   \n",
       "home_team_mean_midfield_score                 78.2                  NaN   \n",
       "away_team_mean_defense_score                   NaN                  NaN   \n",
       "away_team_mean_offense_score                   NaN                  NaN   \n",
       "away_team_mean_midfield_score                  NaN                  NaN   \n",
       "\n",
       "                                             23917          23918       23919  \\\n",
       "date                                    2022-06-14     2022-06-14  2022-06-14   \n",
       "home_team                            Liechtenstein          Chile       Japan   \n",
       "away_team                                   Latvia          Ghana     Tunisia   \n",
       "home_team_continent                         Europe  South America        Asia   \n",
       "away_team_continent                         Europe         Africa      Africa   \n",
       "home_team_fifa_rank                            192             28          23   \n",
       "away_team_fifa_rank                            135             60          35   \n",
       "home_team_total_fifa_points                    895           1526        1553   \n",
       "away_team_total_fifa_points                   1105           1387        1499   \n",
       "home_team_score                                  0              0           0   \n",
       "away_team_score                                  2              0           3   \n",
       "tournament                     UEFA Nations League      Kirin Cup   Kirin Cup   \n",
       "city                                         Vaduz          Suita       Suita   \n",
       "country                              Liechtenstein          Japan       Japan   \n",
       "neutral_location                             False           True       False   \n",
       "shoot_out                                       No            Yes          No   \n",
       "home_team_result                              Lose           Lose        Lose   \n",
       "home_team_goalkeeper_score                     NaN           79.0        73.0   \n",
       "away_team_goalkeeper_score                    65.0           74.0         NaN   \n",
       "home_team_mean_defense_score                   NaN           75.5        75.2   \n",
       "home_team_mean_offense_score                   NaN           76.7        75.0   \n",
       "home_team_mean_midfield_score                  NaN           78.2        77.5   \n",
       "away_team_mean_defense_score                   NaN           75.5        70.8   \n",
       "away_team_mean_offense_score                   NaN           76.0        72.3   \n",
       "away_team_mean_midfield_score                  NaN           78.2        74.0   \n",
       "\n",
       "                                        23920  \n",
       "date                               2022-06-14  \n",
       "home_team                      Korea Republic  \n",
       "away_team                               Egypt  \n",
       "home_team_continent                      Asia  \n",
       "away_team_continent                    Africa  \n",
       "home_team_fifa_rank                        29  \n",
       "away_team_fifa_rank                        32  \n",
       "home_team_total_fifa_points              1519  \n",
       "away_team_total_fifa_points              1500  \n",
       "home_team_score                             4  \n",
       "away_team_score                             1  \n",
       "tournament                           Friendly  \n",
       "city                                    Seoul  \n",
       "country                        Korea Republic  \n",
       "neutral_location                        False  \n",
       "shoot_out                                  No  \n",
       "home_team_result                          Win  \n",
       "home_team_goalkeeper_score               75.0  \n",
       "away_team_goalkeeper_score                NaN  \n",
       "home_team_mean_defense_score             73.0  \n",
       "home_team_mean_offense_score             80.0  \n",
       "home_team_mean_midfield_score            73.8  \n",
       "away_team_mean_defense_score              NaN  \n",
       "away_team_mean_offense_score             79.3  \n",
       "away_team_mean_midfield_score            70.8  \n",
       "\n",
       "[25 rows x 23921 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "7a4bbfe2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 23921 entries, 0 to 23920\n",
      "Data columns (total 25 columns):\n",
      " #   Column                         Non-Null Count  Dtype  \n",
      "---  ------                         --------------  -----  \n",
      " 0   date                           23921 non-null  object \n",
      " 1   home_team                      23921 non-null  object \n",
      " 2   away_team                      23921 non-null  object \n",
      " 3   home_team_continent            23921 non-null  object \n",
      " 4   away_team_continent            23921 non-null  object \n",
      " 5   home_team_fifa_rank            23921 non-null  int64  \n",
      " 6   away_team_fifa_rank            23921 non-null  int64  \n",
      " 7   home_team_total_fifa_points    23921 non-null  int64  \n",
      " 8   away_team_total_fifa_points    23921 non-null  int64  \n",
      " 9   home_team_score                23921 non-null  int64  \n",
      " 10  away_team_score                23921 non-null  int64  \n",
      " 11  tournament                     23921 non-null  object \n",
      " 12  city                           23921 non-null  object \n",
      " 13  country                        23921 non-null  object \n",
      " 14  neutral_location               23921 non-null  bool   \n",
      " 15  shoot_out                      23921 non-null  object \n",
      " 16  home_team_result               23921 non-null  object \n",
      " 17  home_team_goalkeeper_score     8379 non-null   float64\n",
      " 18  away_team_goalkeeper_score     8095 non-null   float64\n",
      " 19  home_team_mean_defense_score   7787 non-null   float64\n",
      " 20  home_team_mean_offense_score   8510 non-null   float64\n",
      " 21  home_team_mean_midfield_score  8162 non-null   float64\n",
      " 22  away_team_mean_defense_score   7564 non-null   float64\n",
      " 23  away_team_mean_offense_score   8312 non-null   float64\n",
      " 24  away_team_mean_midfield_score  7979 non-null   float64\n",
      "dtypes: bool(1), float64(8), int64(6), object(10)\n",
      "memory usage: 4.4+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "a6ebc40c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tmp = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "a5f2c368",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tmp[\"day\"] = pd.to_datetime(df_tmp[\"date\"]).dt.day\n",
    "df_tmp[\"month\"] = pd.to_datetime(df_tmp[\"date\"]).dt.month\n",
    "df_tmp[\"year\"] = pd.to_datetime(df_tmp[\"date\"]).dt.year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "9c1eada6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tmp.drop([\"home_team_goalkeeper_score\", \"away_team_goalkeeper_score\", \"home_team_mean_defense_score\", \"home_team_mean_offense_score\", \"home_team_mean_midfield_score\", \"away_team_mean_defense_score\", \"away_team_mean_offense_score\", \"away_team_mean_midfield_score\", \"date\"], inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "0869bc65",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>23911</th>\n",
       "      <th>23912</th>\n",
       "      <th>23913</th>\n",
       "      <th>23914</th>\n",
       "      <th>23915</th>\n",
       "      <th>23916</th>\n",
       "      <th>23917</th>\n",
       "      <th>23918</th>\n",
       "      <th>23919</th>\n",
       "      <th>23920</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>home_team</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>...</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>Romania</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>Chile</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Korea Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>Eswatini</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>Norway</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>...</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Montenegro</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>Andorra</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Egypt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_continent</th>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>...</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>South America</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_continent</th>\n",
       "      <td>South America</td>\n",
       "      <td>North America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>...</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_fifa_rank</th>\n",
       "      <td>59</td>\n",
       "      <td>8</td>\n",
       "      <td>35</td>\n",
       "      <td>65</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>50</td>\n",
       "      <td>65</td>\n",
       "      <td>111</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>59</td>\n",
       "      <td>48</td>\n",
       "      <td>94</td>\n",
       "      <td>43</td>\n",
       "      <td>180</td>\n",
       "      <td>192</td>\n",
       "      <td>28</td>\n",
       "      <td>23</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_fifa_rank</th>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>94</td>\n",
       "      <td>86</td>\n",
       "      <td>5</td>\n",
       "      <td>19</td>\n",
       "      <td>102</td>\n",
       "      <td>86</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>57</td>\n",
       "      <td>70</td>\n",
       "      <td>124</td>\n",
       "      <td>138</td>\n",
       "      <td>153</td>\n",
       "      <td>135</td>\n",
       "      <td>60</td>\n",
       "      <td>35</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_total_fifa_points</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1535</td>\n",
       "      <td>1388</td>\n",
       "      <td>1446</td>\n",
       "      <td>1229</td>\n",
       "      <td>1461</td>\n",
       "      <td>932</td>\n",
       "      <td>895</td>\n",
       "      <td>1526</td>\n",
       "      <td>1553</td>\n",
       "      <td>1519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_total_fifa_points</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1449</td>\n",
       "      <td>1406</td>\n",
       "      <td>1342</td>\n",
       "      <td>1137</td>\n",
       "      <td>1092</td>\n",
       "      <td>1040</td>\n",
       "      <td>1105</td>\n",
       "      <td>1387</td>\n",
       "      <td>1499</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_score</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_score</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tournament</th>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>...</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>Kirin Cup</td>\n",
       "      <td>Kirin Cup</td>\n",
       "      <td>Friendly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <td>La Paz</td>\n",
       "      <td>Maceió</td>\n",
       "      <td>Quito</td>\n",
       "      <td>Conakry</td>\n",
       "      <td>Asunción</td>\n",
       "      <td>Lima</td>\n",
       "      <td>Harare</td>\n",
       "      <td>Conakry</td>\n",
       "      <td>Toftir</td>\n",
       "      <td>Borås</td>\n",
       "      <td>...</td>\n",
       "      <td>Łódź</td>\n",
       "      <td>Zenica</td>\n",
       "      <td>Bucharest</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>İzmir</td>\n",
       "      <td>Chișinău</td>\n",
       "      <td>Vaduz</td>\n",
       "      <td>Suita</td>\n",
       "      <td>Suita</td>\n",
       "      <td>Seoul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>...</td>\n",
       "      <td>Poland</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>Romania</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Korea Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>neutral_location</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shoot_out</th>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_result</th>\n",
       "      <td>Win</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>...</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>month</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year</th>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>...</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19 rows × 23921 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    0              1      \\\n",
       "home_team                                         Bolivia         Brazil   \n",
       "away_team                                         Uruguay         Mexico   \n",
       "home_team_continent                         South America  South America   \n",
       "away_team_continent                         South America  North America   \n",
       "home_team_fifa_rank                                    59              8   \n",
       "away_team_fifa_rank                                    22             14   \n",
       "home_team_total_fifa_points                             0              0   \n",
       "away_team_total_fifa_points                             0              0   \n",
       "home_team_score                                         3              1   \n",
       "away_team_score                                         1              1   \n",
       "tournament                   FIFA World Cup qualification       Friendly   \n",
       "city                                               La Paz         Maceió   \n",
       "country                                           Bolivia         Brazil   \n",
       "neutral_location                                    False          False   \n",
       "shoot_out                                              No             No   \n",
       "home_team_result                                      Win           Draw   \n",
       "day                                                     8              8   \n",
       "month                                                   8              8   \n",
       "year                                                 1993           1993   \n",
       "\n",
       "                                                    2             3      \\\n",
       "home_team                                         Ecuador        Guinea   \n",
       "away_team                                       Venezuela  Sierra Leone   \n",
       "home_team_continent                         South America        Africa   \n",
       "away_team_continent                         South America        Africa   \n",
       "home_team_fifa_rank                                    35            65   \n",
       "away_team_fifa_rank                                    94            86   \n",
       "home_team_total_fifa_points                             0             0   \n",
       "away_team_total_fifa_points                             0             0   \n",
       "home_team_score                                         5             1   \n",
       "away_team_score                                         0             0   \n",
       "tournament                   FIFA World Cup qualification      Friendly   \n",
       "city                                                Quito       Conakry   \n",
       "country                                           Ecuador        Guinea   \n",
       "neutral_location                                    False         False   \n",
       "shoot_out                                              No            No   \n",
       "home_team_result                                      Win           Win   \n",
       "day                                                     8             8   \n",
       "month                                                   8             8   \n",
       "year                                                 1993          1993   \n",
       "\n",
       "                                                    4      \\\n",
       "home_team                                        Paraguay   \n",
       "away_team                                       Argentina   \n",
       "home_team_continent                         South America   \n",
       "away_team_continent                         South America   \n",
       "home_team_fifa_rank                                    67   \n",
       "away_team_fifa_rank                                     5   \n",
       "home_team_total_fifa_points                             0   \n",
       "away_team_total_fifa_points                             0   \n",
       "home_team_score                                         1   \n",
       "away_team_score                                         3   \n",
       "tournament                   FIFA World Cup qualification   \n",
       "city                                             Asunción   \n",
       "country                                          Paraguay   \n",
       "neutral_location                                    False   \n",
       "shoot_out                                              No   \n",
       "home_team_result                                     Lose   \n",
       "day                                                     8   \n",
       "month                                                   8   \n",
       "year                                                 1993   \n",
       "\n",
       "                                                    5         6      \\\n",
       "home_team                                            Peru  Zimbabwe   \n",
       "away_team                                        Colombia  Eswatini   \n",
       "home_team_continent                         South America    Africa   \n",
       "away_team_continent                         South America    Africa   \n",
       "home_team_fifa_rank                                    70        50   \n",
       "away_team_fifa_rank                                    19       102   \n",
       "home_team_total_fifa_points                             0         0   \n",
       "away_team_total_fifa_points                             0         0   \n",
       "home_team_score                                         0         2   \n",
       "away_team_score                                         1         0   \n",
       "tournament                   FIFA World Cup qualification  Friendly   \n",
       "city                                                 Lima    Harare   \n",
       "country                                              Peru  Zimbabwe   \n",
       "neutral_location                                    False     False   \n",
       "shoot_out                                              No        No   \n",
       "home_team_result                                     Lose       Win   \n",
       "day                                                     8         8   \n",
       "month                                                   8         8   \n",
       "year                                                 1993      1993   \n",
       "\n",
       "                                    7              8            9      ...  \\\n",
       "home_team                          Guinea  Faroe Islands       Sweden  ...   \n",
       "away_team                    Sierra Leone         Norway  Switzerland  ...   \n",
       "home_team_continent                Africa         Europe       Europe  ...   \n",
       "away_team_continent                Africa         Europe       Europe  ...   \n",
       "home_team_fifa_rank                    65            111            4  ...   \n",
       "away_team_fifa_rank                    86              9            3  ...   \n",
       "home_team_total_fifa_points             0              0            0  ...   \n",
       "away_team_total_fifa_points             0              0            0  ...   \n",
       "home_team_score                         4              0            1  ...   \n",
       "away_team_score                         0              7            2  ...   \n",
       "tournament                       Friendly       Friendly     Friendly  ...   \n",
       "city                              Conakry         Toftir        Borås  ...   \n",
       "country                            Guinea  Faroe Islands       Sweden  ...   \n",
       "neutral_location                    False          False        False  ...   \n",
       "shoot_out                              No             No           No  ...   \n",
       "home_team_result                      Win           Lose         Lose  ...   \n",
       "day                                     9             11           11  ...   \n",
       "month                                   8              8            8  ...   \n",
       "year                                 1993           1993         1993  ...   \n",
       "\n",
       "                                           23911                   23912  \\\n",
       "home_team                                Ukraine  Bosnia and Herzegovina   \n",
       "away_team                    Republic of Ireland                 Finland   \n",
       "home_team_continent                       Europe                  Europe   \n",
       "away_team_continent                       Europe                  Europe   \n",
       "home_team_fifa_rank                           27                      59   \n",
       "away_team_fifa_rank                           47                      57   \n",
       "home_team_total_fifa_points                 1535                    1388   \n",
       "away_team_total_fifa_points                 1449                    1406   \n",
       "home_team_score                                1                       3   \n",
       "away_team_score                                1                       2   \n",
       "tournament                   UEFA Nations League     UEFA Nations League   \n",
       "city                                        Łódź                  Zenica   \n",
       "country                                   Poland  Bosnia and Herzegovina   \n",
       "neutral_location                            True                   False   \n",
       "shoot_out                                     No                      No   \n",
       "home_team_result                            Draw                     Win   \n",
       "day                                           14                      14   \n",
       "month                                          6                       6   \n",
       "year                                        2022                    2022   \n",
       "\n",
       "                                           23913                23914  \\\n",
       "home_team                                Romania           Luxembourg   \n",
       "away_team                             Montenegro        Faroe Islands   \n",
       "home_team_continent                       Europe               Europe   \n",
       "away_team_continent                       Europe               Europe   \n",
       "home_team_fifa_rank                           48                   94   \n",
       "away_team_fifa_rank                           70                  124   \n",
       "home_team_total_fifa_points                 1446                 1229   \n",
       "away_team_total_fifa_points                 1342                 1137   \n",
       "home_team_score                                0                    2   \n",
       "away_team_score                                3                    2   \n",
       "tournament                   UEFA Nations League  UEFA Nations League   \n",
       "city                                   Bucharest           Luxembourg   \n",
       "country                                  Romania           Luxembourg   \n",
       "neutral_location                           False                False   \n",
       "shoot_out                                     No                   No   \n",
       "home_team_result                            Lose                 Draw   \n",
       "day                                           14                   14   \n",
       "month                                          6                    6   \n",
       "year                                        2022                 2022   \n",
       "\n",
       "                                           23915                23916  \\\n",
       "home_team                                 Turkey              Moldova   \n",
       "away_team                              Lithuania              Andorra   \n",
       "home_team_continent                       Europe               Europe   \n",
       "away_team_continent                       Europe               Europe   \n",
       "home_team_fifa_rank                           43                  180   \n",
       "away_team_fifa_rank                          138                  153   \n",
       "home_team_total_fifa_points                 1461                  932   \n",
       "away_team_total_fifa_points                 1092                 1040   \n",
       "home_team_score                                2                    2   \n",
       "away_team_score                                0                    1   \n",
       "tournament                   UEFA Nations League  UEFA Nations League   \n",
       "city                                       İzmir             Chișinău   \n",
       "country                                   Turkey              Moldova   \n",
       "neutral_location                           False                False   \n",
       "shoot_out                                     No                   No   \n",
       "home_team_result                             Win                  Win   \n",
       "day                                           14                   14   \n",
       "month                                          6                    6   \n",
       "year                                        2022                 2022   \n",
       "\n",
       "                                           23917          23918      23919  \\\n",
       "home_team                          Liechtenstein          Chile      Japan   \n",
       "away_team                                 Latvia          Ghana    Tunisia   \n",
       "home_team_continent                       Europe  South America       Asia   \n",
       "away_team_continent                       Europe         Africa     Africa   \n",
       "home_team_fifa_rank                          192             28         23   \n",
       "away_team_fifa_rank                          135             60         35   \n",
       "home_team_total_fifa_points                  895           1526       1553   \n",
       "away_team_total_fifa_points                 1105           1387       1499   \n",
       "home_team_score                                0              0          0   \n",
       "away_team_score                                2              0          3   \n",
       "tournament                   UEFA Nations League      Kirin Cup  Kirin Cup   \n",
       "city                                       Vaduz          Suita      Suita   \n",
       "country                            Liechtenstein          Japan      Japan   \n",
       "neutral_location                           False           True      False   \n",
       "shoot_out                                     No            Yes         No   \n",
       "home_team_result                            Lose           Lose       Lose   \n",
       "day                                           14             14         14   \n",
       "month                                          6              6          6   \n",
       "year                                        2022           2022       2022   \n",
       "\n",
       "                                      23920  \n",
       "home_team                    Korea Republic  \n",
       "away_team                             Egypt  \n",
       "home_team_continent                    Asia  \n",
       "away_team_continent                  Africa  \n",
       "home_team_fifa_rank                      29  \n",
       "away_team_fifa_rank                      32  \n",
       "home_team_total_fifa_points            1519  \n",
       "away_team_total_fifa_points            1500  \n",
       "home_team_score                           4  \n",
       "away_team_score                           1  \n",
       "tournament                         Friendly  \n",
       "city                                  Seoul  \n",
       "country                      Korea Republic  \n",
       "neutral_location                      False  \n",
       "shoot_out                                No  \n",
       "home_team_result                        Win  \n",
       "day                                      14  \n",
       "month                                     6  \n",
       "year                                   2022  \n",
       "\n",
       "[19 rows x 23921 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tmp.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "dcf8f923",
   "metadata": {},
   "outputs": [],
   "source": [
    "for stuff in df_tmp.keys():\n",
    "    if pd.api.types.is_object_dtype(df_tmp[stuff]) == True:\n",
    "        new_cat = pd.Categorical(df_tmp[stuff])\n",
    "        df_tmp[stuff + \"_cat\"] = new_cat.codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "2123e89b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['home_team', 'away_team', 'home_team_continent', 'away_team_continent',\n",
       "       'home_team_fifa_rank', 'away_team_fifa_rank',\n",
       "       'home_team_total_fifa_points', 'away_team_total_fifa_points',\n",
       "       'home_team_score', 'away_team_score', 'tournament', 'city', 'country',\n",
       "       'neutral_location', 'shoot_out', 'home_team_result', 'day', 'month',\n",
       "       'year', 'home_team_cat', 'away_team_cat', 'home_team_continent_cat',\n",
       "       'away_team_continent_cat', 'tournament_cat', 'city_cat', 'country_cat',\n",
       "       'shoot_out_cat', 'home_team_result_cat'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tmp.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "a8574a1b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tmp[\"neutral_location_cat\"] = pd.Categorical(df[\"neutral_location\"]).codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "89a0ad33",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>23911</th>\n",
       "      <th>23912</th>\n",
       "      <th>23913</th>\n",
       "      <th>23914</th>\n",
       "      <th>23915</th>\n",
       "      <th>23916</th>\n",
       "      <th>23917</th>\n",
       "      <th>23918</th>\n",
       "      <th>23919</th>\n",
       "      <th>23920</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>home_team</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>...</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>Romania</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>Chile</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Korea Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>Eswatini</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>Norway</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>...</td>\n",
       "      <td>Republic of Ireland</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Montenegro</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>Andorra</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Egypt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_continent</th>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>...</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>South America</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_continent</th>\n",
       "      <td>South America</td>\n",
       "      <td>North America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>South America</td>\n",
       "      <td>South America</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>...</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_fifa_rank</th>\n",
       "      <td>59</td>\n",
       "      <td>8</td>\n",
       "      <td>35</td>\n",
       "      <td>65</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>50</td>\n",
       "      <td>65</td>\n",
       "      <td>111</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>59</td>\n",
       "      <td>48</td>\n",
       "      <td>94</td>\n",
       "      <td>43</td>\n",
       "      <td>180</td>\n",
       "      <td>192</td>\n",
       "      <td>28</td>\n",
       "      <td>23</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_fifa_rank</th>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>94</td>\n",
       "      <td>86</td>\n",
       "      <td>5</td>\n",
       "      <td>19</td>\n",
       "      <td>102</td>\n",
       "      <td>86</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>57</td>\n",
       "      <td>70</td>\n",
       "      <td>124</td>\n",
       "      <td>138</td>\n",
       "      <td>153</td>\n",
       "      <td>135</td>\n",
       "      <td>60</td>\n",
       "      <td>35</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_total_fifa_points</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1535</td>\n",
       "      <td>1388</td>\n",
       "      <td>1446</td>\n",
       "      <td>1229</td>\n",
       "      <td>1461</td>\n",
       "      <td>932</td>\n",
       "      <td>895</td>\n",
       "      <td>1526</td>\n",
       "      <td>1553</td>\n",
       "      <td>1519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_total_fifa_points</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1449</td>\n",
       "      <td>1406</td>\n",
       "      <td>1342</td>\n",
       "      <td>1137</td>\n",
       "      <td>1092</td>\n",
       "      <td>1040</td>\n",
       "      <td>1105</td>\n",
       "      <td>1387</td>\n",
       "      <td>1499</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_score</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_score</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tournament</th>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>FIFA World Cup qualification</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>Friendly</td>\n",
       "      <td>...</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>UEFA Nations League</td>\n",
       "      <td>Kirin Cup</td>\n",
       "      <td>Kirin Cup</td>\n",
       "      <td>Friendly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <td>La Paz</td>\n",
       "      <td>Maceió</td>\n",
       "      <td>Quito</td>\n",
       "      <td>Conakry</td>\n",
       "      <td>Asunción</td>\n",
       "      <td>Lima</td>\n",
       "      <td>Harare</td>\n",
       "      <td>Conakry</td>\n",
       "      <td>Toftir</td>\n",
       "      <td>Borås</td>\n",
       "      <td>...</td>\n",
       "      <td>Łódź</td>\n",
       "      <td>Zenica</td>\n",
       "      <td>Bucharest</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>İzmir</td>\n",
       "      <td>Chișinău</td>\n",
       "      <td>Vaduz</td>\n",
       "      <td>Suita</td>\n",
       "      <td>Suita</td>\n",
       "      <td>Seoul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>...</td>\n",
       "      <td>Poland</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>Romania</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Korea Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>neutral_location</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shoot_out</th>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_result</th>\n",
       "      <td>Win</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>...</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>month</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year</th>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>...</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_cat</th>\n",
       "      <td>24</td>\n",
       "      <td>27</td>\n",
       "      <td>59</td>\n",
       "      <td>82</td>\n",
       "      <td>148</td>\n",
       "      <td>149</td>\n",
       "      <td>210</td>\n",
       "      <td>82</td>\n",
       "      <td>68</td>\n",
       "      <td>181</td>\n",
       "      <td>...</td>\n",
       "      <td>200</td>\n",
       "      <td>25</td>\n",
       "      <td>156</td>\n",
       "      <td>114</td>\n",
       "      <td>194</td>\n",
       "      <td>125</td>\n",
       "      <td>112</td>\n",
       "      <td>40</td>\n",
       "      <td>97</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_cat</th>\n",
       "      <td>202</td>\n",
       "      <td>124</td>\n",
       "      <td>205</td>\n",
       "      <td>166</td>\n",
       "      <td>8</td>\n",
       "      <td>43</td>\n",
       "      <td>66</td>\n",
       "      <td>166</td>\n",
       "      <td>142</td>\n",
       "      <td>182</td>\n",
       "      <td>...</td>\n",
       "      <td>155</td>\n",
       "      <td>70</td>\n",
       "      <td>127</td>\n",
       "      <td>68</td>\n",
       "      <td>113</td>\n",
       "      <td>4</td>\n",
       "      <td>107</td>\n",
       "      <td>76</td>\n",
       "      <td>193</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_continent_cat</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>away_team_continent_cat</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tournament_cat</th>\n",
       "      <td>37</td>\n",
       "      <td>38</td>\n",
       "      <td>37</td>\n",
       "      <td>38</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>...</td>\n",
       "      <td>74</td>\n",
       "      <td>74</td>\n",
       "      <td>74</td>\n",
       "      <td>74</td>\n",
       "      <td>74</td>\n",
       "      <td>74</td>\n",
       "      <td>74</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city_cat</th>\n",
       "      <td>717</td>\n",
       "      <td>801</td>\n",
       "      <td>1141</td>\n",
       "      <td>341</td>\n",
       "      <td>93</td>\n",
       "      <td>759</td>\n",
       "      <td>537</td>\n",
       "      <td>341</td>\n",
       "      <td>1402</td>\n",
       "      <td>213</td>\n",
       "      <td>...</td>\n",
       "      <td>1571</td>\n",
       "      <td>1546</td>\n",
       "      <td>236</td>\n",
       "      <td>793</td>\n",
       "      <td>1569</td>\n",
       "      <td>309</td>\n",
       "      <td>1447</td>\n",
       "      <td>1337</td>\n",
       "      <td>1337</td>\n",
       "      <td>1278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country_cat</th>\n",
       "      <td>23</td>\n",
       "      <td>26</td>\n",
       "      <td>59</td>\n",
       "      <td>84</td>\n",
       "      <td>153</td>\n",
       "      <td>154</td>\n",
       "      <td>216</td>\n",
       "      <td>84</td>\n",
       "      <td>68</td>\n",
       "      <td>188</td>\n",
       "      <td>...</td>\n",
       "      <td>156</td>\n",
       "      <td>24</td>\n",
       "      <td>161</td>\n",
       "      <td>116</td>\n",
       "      <td>200</td>\n",
       "      <td>128</td>\n",
       "      <td>114</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shoot_out_cat</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>home_team_result_cat</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>neutral_location_cat</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29 rows × 23921 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    0              1      \\\n",
       "home_team                                         Bolivia         Brazil   \n",
       "away_team                                         Uruguay         Mexico   \n",
       "home_team_continent                         South America  South America   \n",
       "away_team_continent                         South America  North America   \n",
       "home_team_fifa_rank                                    59              8   \n",
       "away_team_fifa_rank                                    22             14   \n",
       "home_team_total_fifa_points                             0              0   \n",
       "away_team_total_fifa_points                             0              0   \n",
       "home_team_score                                         3              1   \n",
       "away_team_score                                         1              1   \n",
       "tournament                   FIFA World Cup qualification       Friendly   \n",
       "city                                               La Paz         Maceió   \n",
       "country                                           Bolivia         Brazil   \n",
       "neutral_location                                    False          False   \n",
       "shoot_out                                              No             No   \n",
       "home_team_result                                      Win           Draw   \n",
       "day                                                     8              8   \n",
       "month                                                   8              8   \n",
       "year                                                 1993           1993   \n",
       "home_team_cat                                          24             27   \n",
       "away_team_cat                                         202            124   \n",
       "home_team_continent_cat                                 5              5   \n",
       "away_team_continent_cat                                 5              3   \n",
       "tournament_cat                                         37             38   \n",
       "city_cat                                              717            801   \n",
       "country_cat                                            23             26   \n",
       "shoot_out_cat                                           0              0   \n",
       "home_team_result_cat                                    2              0   \n",
       "neutral_location_cat                                    0              0   \n",
       "\n",
       "                                                    2             3      \\\n",
       "home_team                                         Ecuador        Guinea   \n",
       "away_team                                       Venezuela  Sierra Leone   \n",
       "home_team_continent                         South America        Africa   \n",
       "away_team_continent                         South America        Africa   \n",
       "home_team_fifa_rank                                    35            65   \n",
       "away_team_fifa_rank                                    94            86   \n",
       "home_team_total_fifa_points                             0             0   \n",
       "away_team_total_fifa_points                             0             0   \n",
       "home_team_score                                         5             1   \n",
       "away_team_score                                         0             0   \n",
       "tournament                   FIFA World Cup qualification      Friendly   \n",
       "city                                                Quito       Conakry   \n",
       "country                                           Ecuador        Guinea   \n",
       "neutral_location                                    False         False   \n",
       "shoot_out                                              No            No   \n",
       "home_team_result                                      Win           Win   \n",
       "day                                                     8             8   \n",
       "month                                                   8             8   \n",
       "year                                                 1993          1993   \n",
       "home_team_cat                                          59            82   \n",
       "away_team_cat                                         205           166   \n",
       "home_team_continent_cat                                 5             0   \n",
       "away_team_continent_cat                                 5             0   \n",
       "tournament_cat                                         37            38   \n",
       "city_cat                                             1141           341   \n",
       "country_cat                                            59            84   \n",
       "shoot_out_cat                                           0             0   \n",
       "home_team_result_cat                                    2             2   \n",
       "neutral_location_cat                                    0             0   \n",
       "\n",
       "                                                    4      \\\n",
       "home_team                                        Paraguay   \n",
       "away_team                                       Argentina   \n",
       "home_team_continent                         South America   \n",
       "away_team_continent                         South America   \n",
       "home_team_fifa_rank                                    67   \n",
       "away_team_fifa_rank                                     5   \n",
       "home_team_total_fifa_points                             0   \n",
       "away_team_total_fifa_points                             0   \n",
       "home_team_score                                         1   \n",
       "away_team_score                                         3   \n",
       "tournament                   FIFA World Cup qualification   \n",
       "city                                             Asunción   \n",
       "country                                          Paraguay   \n",
       "neutral_location                                    False   \n",
       "shoot_out                                              No   \n",
       "home_team_result                                     Lose   \n",
       "day                                                     8   \n",
       "month                                                   8   \n",
       "year                                                 1993   \n",
       "home_team_cat                                         148   \n",
       "away_team_cat                                           8   \n",
       "home_team_continent_cat                                 5   \n",
       "away_team_continent_cat                                 5   \n",
       "tournament_cat                                         37   \n",
       "city_cat                                               93   \n",
       "country_cat                                           153   \n",
       "shoot_out_cat                                           0   \n",
       "home_team_result_cat                                    1   \n",
       "neutral_location_cat                                    0   \n",
       "\n",
       "                                                    5         6      \\\n",
       "home_team                                            Peru  Zimbabwe   \n",
       "away_team                                        Colombia  Eswatini   \n",
       "home_team_continent                         South America    Africa   \n",
       "away_team_continent                         South America    Africa   \n",
       "home_team_fifa_rank                                    70        50   \n",
       "away_team_fifa_rank                                    19       102   \n",
       "home_team_total_fifa_points                             0         0   \n",
       "away_team_total_fifa_points                             0         0   \n",
       "home_team_score                                         0         2   \n",
       "away_team_score                                         1         0   \n",
       "tournament                   FIFA World Cup qualification  Friendly   \n",
       "city                                                 Lima    Harare   \n",
       "country                                              Peru  Zimbabwe   \n",
       "neutral_location                                    False     False   \n",
       "shoot_out                                              No        No   \n",
       "home_team_result                                     Lose       Win   \n",
       "day                                                     8         8   \n",
       "month                                                   8         8   \n",
       "year                                                 1993      1993   \n",
       "home_team_cat                                         149       210   \n",
       "away_team_cat                                          43        66   \n",
       "home_team_continent_cat                                 5         0   \n",
       "away_team_continent_cat                                 5         0   \n",
       "tournament_cat                                         37        38   \n",
       "city_cat                                              759       537   \n",
       "country_cat                                           154       216   \n",
       "shoot_out_cat                                           0         0   \n",
       "home_team_result_cat                                    1         2   \n",
       "neutral_location_cat                                    0         0   \n",
       "\n",
       "                                    7              8            9      ...  \\\n",
       "home_team                          Guinea  Faroe Islands       Sweden  ...   \n",
       "away_team                    Sierra Leone         Norway  Switzerland  ...   \n",
       "home_team_continent                Africa         Europe       Europe  ...   \n",
       "away_team_continent                Africa         Europe       Europe  ...   \n",
       "home_team_fifa_rank                    65            111            4  ...   \n",
       "away_team_fifa_rank                    86              9            3  ...   \n",
       "home_team_total_fifa_points             0              0            0  ...   \n",
       "away_team_total_fifa_points             0              0            0  ...   \n",
       "home_team_score                         4              0            1  ...   \n",
       "away_team_score                         0              7            2  ...   \n",
       "tournament                       Friendly       Friendly     Friendly  ...   \n",
       "city                              Conakry         Toftir        Borås  ...   \n",
       "country                            Guinea  Faroe Islands       Sweden  ...   \n",
       "neutral_location                    False          False        False  ...   \n",
       "shoot_out                              No             No           No  ...   \n",
       "home_team_result                      Win           Lose         Lose  ...   \n",
       "day                                     9             11           11  ...   \n",
       "month                                   8              8            8  ...   \n",
       "year                                 1993           1993         1993  ...   \n",
       "home_team_cat                          82             68          181  ...   \n",
       "away_team_cat                         166            142          182  ...   \n",
       "home_team_continent_cat                 0              2            2  ...   \n",
       "away_team_continent_cat                 0              2            2  ...   \n",
       "tournament_cat                         38             38           38  ...   \n",
       "city_cat                              341           1402          213  ...   \n",
       "country_cat                            84             68          188  ...   \n",
       "shoot_out_cat                           0              0            0  ...   \n",
       "home_team_result_cat                    2              1            1  ...   \n",
       "neutral_location_cat                    0              0            0  ...   \n",
       "\n",
       "                                           23911                   23912  \\\n",
       "home_team                                Ukraine  Bosnia and Herzegovina   \n",
       "away_team                    Republic of Ireland                 Finland   \n",
       "home_team_continent                       Europe                  Europe   \n",
       "away_team_continent                       Europe                  Europe   \n",
       "home_team_fifa_rank                           27                      59   \n",
       "away_team_fifa_rank                           47                      57   \n",
       "home_team_total_fifa_points                 1535                    1388   \n",
       "away_team_total_fifa_points                 1449                    1406   \n",
       "home_team_score                                1                       3   \n",
       "away_team_score                                1                       2   \n",
       "tournament                   UEFA Nations League     UEFA Nations League   \n",
       "city                                        Łódź                  Zenica   \n",
       "country                                   Poland  Bosnia and Herzegovina   \n",
       "neutral_location                            True                   False   \n",
       "shoot_out                                     No                      No   \n",
       "home_team_result                            Draw                     Win   \n",
       "day                                           14                      14   \n",
       "month                                          6                       6   \n",
       "year                                        2022                    2022   \n",
       "home_team_cat                                200                      25   \n",
       "away_team_cat                                155                      70   \n",
       "home_team_continent_cat                        2                       2   \n",
       "away_team_continent_cat                        2                       2   \n",
       "tournament_cat                                74                      74   \n",
       "city_cat                                    1571                    1546   \n",
       "country_cat                                  156                      24   \n",
       "shoot_out_cat                                  0                       0   \n",
       "home_team_result_cat                           0                       2   \n",
       "neutral_location_cat                           1                       0   \n",
       "\n",
       "                                           23913                23914  \\\n",
       "home_team                                Romania           Luxembourg   \n",
       "away_team                             Montenegro        Faroe Islands   \n",
       "home_team_continent                       Europe               Europe   \n",
       "away_team_continent                       Europe               Europe   \n",
       "home_team_fifa_rank                           48                   94   \n",
       "away_team_fifa_rank                           70                  124   \n",
       "home_team_total_fifa_points                 1446                 1229   \n",
       "away_team_total_fifa_points                 1342                 1137   \n",
       "home_team_score                                0                    2   \n",
       "away_team_score                                3                    2   \n",
       "tournament                   UEFA Nations League  UEFA Nations League   \n",
       "city                                   Bucharest           Luxembourg   \n",
       "country                                  Romania           Luxembourg   \n",
       "neutral_location                           False                False   \n",
       "shoot_out                                     No                   No   \n",
       "home_team_result                            Lose                 Draw   \n",
       "day                                           14                   14   \n",
       "month                                          6                    6   \n",
       "year                                        2022                 2022   \n",
       "home_team_cat                                156                  114   \n",
       "away_team_cat                                127                   68   \n",
       "home_team_continent_cat                        2                    2   \n",
       "away_team_continent_cat                        2                    2   \n",
       "tournament_cat                                74                   74   \n",
       "city_cat                                     236                  793   \n",
       "country_cat                                  161                  116   \n",
       "shoot_out_cat                                  0                    0   \n",
       "home_team_result_cat                           1                    0   \n",
       "neutral_location_cat                           0                    0   \n",
       "\n",
       "                                           23915                23916  \\\n",
       "home_team                                 Turkey              Moldova   \n",
       "away_team                              Lithuania              Andorra   \n",
       "home_team_continent                       Europe               Europe   \n",
       "away_team_continent                       Europe               Europe   \n",
       "home_team_fifa_rank                           43                  180   \n",
       "away_team_fifa_rank                          138                  153   \n",
       "home_team_total_fifa_points                 1461                  932   \n",
       "away_team_total_fifa_points                 1092                 1040   \n",
       "home_team_score                                2                    2   \n",
       "away_team_score                                0                    1   \n",
       "tournament                   UEFA Nations League  UEFA Nations League   \n",
       "city                                       İzmir             Chișinău   \n",
       "country                                   Turkey              Moldova   \n",
       "neutral_location                           False                False   \n",
       "shoot_out                                     No                   No   \n",
       "home_team_result                             Win                  Win   \n",
       "day                                           14                   14   \n",
       "month                                          6                    6   \n",
       "year                                        2022                 2022   \n",
       "home_team_cat                                194                  125   \n",
       "away_team_cat                                113                    4   \n",
       "home_team_continent_cat                        2                    2   \n",
       "away_team_continent_cat                        2                    2   \n",
       "tournament_cat                                74                   74   \n",
       "city_cat                                    1569                  309   \n",
       "country_cat                                  200                  128   \n",
       "shoot_out_cat                                  0                    0   \n",
       "home_team_result_cat                           2                    2   \n",
       "neutral_location_cat                           0                    0   \n",
       "\n",
       "                                           23917          23918      23919  \\\n",
       "home_team                          Liechtenstein          Chile      Japan   \n",
       "away_team                                 Latvia          Ghana    Tunisia   \n",
       "home_team_continent                       Europe  South America       Asia   \n",
       "away_team_continent                       Europe         Africa     Africa   \n",
       "home_team_fifa_rank                          192             28         23   \n",
       "away_team_fifa_rank                          135             60         35   \n",
       "home_team_total_fifa_points                  895           1526       1553   \n",
       "away_team_total_fifa_points                 1105           1387       1499   \n",
       "home_team_score                                0              0          0   \n",
       "away_team_score                                2              0          3   \n",
       "tournament                   UEFA Nations League      Kirin Cup  Kirin Cup   \n",
       "city                                       Vaduz          Suita      Suita   \n",
       "country                            Liechtenstein          Japan      Japan   \n",
       "neutral_location                           False           True      False   \n",
       "shoot_out                                     No            Yes         No   \n",
       "home_team_result                            Lose           Lose       Lose   \n",
       "day                                           14             14         14   \n",
       "month                                          6              6          6   \n",
       "year                                        2022           2022       2022   \n",
       "home_team_cat                                112             40         97   \n",
       "away_team_cat                                107             76        193   \n",
       "home_team_continent_cat                        2              5          1   \n",
       "away_team_continent_cat                        2              0          0   \n",
       "tournament_cat                                74             46         46   \n",
       "city_cat                                    1447           1337       1337   \n",
       "country_cat                                  114             99         99   \n",
       "shoot_out_cat                                  0              1          0   \n",
       "home_team_result_cat                           1              1          1   \n",
       "neutral_location_cat                           0              1          0   \n",
       "\n",
       "                                      23920  \n",
       "home_team                    Korea Republic  \n",
       "away_team                             Egypt  \n",
       "home_team_continent                    Asia  \n",
       "away_team_continent                  Africa  \n",
       "home_team_fifa_rank                      29  \n",
       "away_team_fifa_rank                      32  \n",
       "home_team_total_fifa_points            1519  \n",
       "away_team_total_fifa_points            1500  \n",
       "home_team_score                           4  \n",
       "away_team_score                           1  \n",
       "tournament                         Friendly  \n",
       "city                                  Seoul  \n",
       "country                      Korea Republic  \n",
       "neutral_location                      False  \n",
       "shoot_out                                No  \n",
       "home_team_result                        Win  \n",
       "day                                      14  \n",
       "month                                     6  \n",
       "year                                   2022  \n",
       "home_team_cat                           102  \n",
       "away_team_cat                            60  \n",
       "home_team_continent_cat                   1  \n",
       "away_team_continent_cat                   0  \n",
       "tournament_cat                           38  \n",
       "city_cat                               1278  \n",
       "country_cat                             104  \n",
       "shoot_out_cat                             0  \n",
       "home_team_result_cat                      2  \n",
       "neutral_location_cat                      0  \n",
       "\n",
       "[29 rows x 23921 columns]"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tmp.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "6b1aa10e",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "\n",
    "X = df_tmp.drop([\"home_team\", \"away_team\", \"home_team_continent\", \"away_team_continent\", \"city\", \"country\", \"shoot_out\", \"home_team_result\", \"home_team_result_cat\", \"tournament\", \"neutral_location\"], axis=1)\n",
    "y = df_tmp[\"home_team_result_cat\"]\n",
    "\n",
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "3467ed85",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(19136, 19136, 4785, 4785)"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(X_train), len(y_train), len(X_test), len(y_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "d704a8bf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RandomForestRegressor()"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model_rr = RandomForestRegressor()\n",
    "model_rr.fit(X_train, y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "656f66d9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.9936333339549566"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model_rr.score(X_test, y_test)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0771b787",
   "metadata": {},
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}