SoccerPrediction.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "player_attributes = pd.read_csv('Player_Attributes.csv')\n",
    "matches_epl = pd.read_csv('Matches_EPL.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "players_df = pd.read_csv('data/player_attributes_transformed.csv')\n",
    "                         #dtype={\"player_api_id\":int,\"year\":int,\"player_fifa_api_id\":int,\"overall_rating\":float})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Function to populate result column for each match row\n",
    "def get_results(home_goal,away_goal):\n",
    "    \n",
    "    #Win or Defeat on the basis of home team\n",
    "    if home_goal > away_goal:\n",
    "        return \"Win\"\n",
    "    elif home_goal == away_goal:\n",
    "        return \"Draw\"\n",
    "    else:\n",
    "        return \"Defeat\"\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Creating a column result from the final scoreline\n",
    "matches_epl['result'] = matches_epl.apply(lambda x: get_results(x['home_team_goal'],x['away_team_goal']),axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "home_players_list = ['home_player_1','home_player_2','home_player_3','home_player_4','home_player_5','home_player_6','home_player_7','home_player_8','home_player_9','home_player_10','home_player_11']\n",
    "away_players_list = ['away_player_1','away_player_2','away_player_3','away_player_4','away_player_5','away_player_6','away_player_7','away_player_8','away_player_9','away_player_10','away_player_11']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Changing Dtype of ids in the dataframe and handling NaNs\n",
    "matches_epl[home_players_list] = matches_epl[home_players_list].fillna(-1)\n",
    "matches_epl[home_players_list] = matches_epl[home_players_list].astype(int)\n",
    "\n",
    "matches_epl[away_players_list] = matches_epl[away_players_list].fillna(-1)\n",
    "matches_epl[away_players_list] = matches_epl[away_players_list].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Changing date format in dataframe from string to datetime\n",
    "matches_epl['date'] = pd.to_datetime(matches_epl['date'], format=\"%Y-%m-%d\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# for player in home_players_list:\n",
    "#     print(player, \"no. of nulls\", matches_epl[player].isnull().sum())\n",
    "# print('---------------')\n",
    "# for player in away_players_list:\n",
    "    \n",
    "#     print(player, \"no. of nulls\", matches_epl[player].isnull().sum())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Getting team squad api ids from multiple columns into one list\n",
    "matches_epl['home_players_ids']= matches_epl[home_players_list].values.tolist()\n",
    "matches_epl['away_players_ids']= matches_epl[away_players_list].values.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches_epl['season'] = matches_epl['season'].apply(lambda x: int(x.split('/')[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_team_ratings(ids_list,season):\n",
    "    team_rating = []\n",
    "    for player_id in ids_list:\n",
    "        if(player_id!=-1):\n",
    "            #Ignoring null values which were converted to -1 in the previous code\n",
    "            rating = players_df[(players_df['player_api_id']==player_id) & (players_df['year']==season)]['overall_rating']\n",
    "            if not rating.empty:\n",
    "                #If player data for that season exists, fetch the rating of player for that season\n",
    "                team_rating.append(rating.iloc[0])\n",
    "    team_rating = sum(team_rating)/len(team_rating)\n",
    "    return team_rating\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches_epl['home_rating'] = matches_epl.apply(lambda x: get_team_ratings(x['home_players_ids'],x['season']), axis=1)\n",
    "matches_epl['away_rating'] = matches_epl.apply(lambda x: get_team_ratings(x['away_players_ids'],x['season']), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#retrieving only important columns for the model\n",
    "matches_columns = ['id','season','date','match_api_id','home_team_api_id','away_team_api_id',\\\n",
    "                   'home_team_goal','away_team_goal',\\\n",
    "                   'home_rating','away_rating','result']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches_epl = matches_epl[matches_columns]\n",
    "temp_df = matches_epl[matches_epl['season']==2008]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([10260,  9825,  8472,  8654, 10252,  8668,  8549,  8559,  8667,\n",
       "        8455, 10194,  8650, 10261,  9879,  8586,  8659,  8462,  8456,\n",
       "        8655,  8528], dtype=int64)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "home_teams = temp_df.home_team_api_id.unique()\n",
    "home_teams"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([10261,  8659,  8650,  8528,  8456,  8655,  8586, 10194,  9879,\n",
       "        8462,  8654,  8668,  8455,  8472,  8667, 10252,  9825, 10260,\n",
       "        8549,  8559], dtype=int64)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "away_teams = temp_df.away_team_api_id.unique()\n",
    "away_teams"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches_epl = matches_epl.sort_values(by='date',ascending=False).reset_index(drop=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>index</th>\n",
       "      <th>id</th>\n",
       "      <th>season</th>\n",
       "      <th>date</th>\n",
       "      <th>match_api_id</th>\n",
       "      <th>home_team_api_id</th>\n",
       "      <th>away_team_api_id</th>\n",
       "      <th>home_team_goal</th>\n",
       "      <th>away_team_goal</th>\n",
       "      <th>home_rating</th>\n",
       "      <th>away_rating</th>\n",
       "      <th>result</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2971</td>\n",
       "      <td>4700</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-05-15</td>\n",
       "      <td>1987598</td>\n",
       "      <td>8455</td>\n",
       "      <td>8197</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>81.815702</td>\n",
       "      <td>71.847619</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2951</td>\n",
       "      <td>4680</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-05-02</td>\n",
       "      <td>1989061</td>\n",
       "      <td>8455</td>\n",
       "      <td>8586</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>82.443506</td>\n",
       "      <td>78.987234</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2932</td>\n",
       "      <td>4661</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-04-16</td>\n",
       "      <td>1989042</td>\n",
       "      <td>8455</td>\n",
       "      <td>8456</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>79.760724</td>\n",
       "      <td>82.540404</td>\n",
       "      <td>Defeat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2900</td>\n",
       "      <td>4629</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-03-19</td>\n",
       "      <td>1989010</td>\n",
       "      <td>8455</td>\n",
       "      <td>8654</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>81.172727</td>\n",
       "      <td>75.666667</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2870</td>\n",
       "      <td>4599</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-03-05</td>\n",
       "      <td>1988990</td>\n",
       "      <td>8455</td>\n",
       "      <td>10194</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>81.164187</td>\n",
       "      <td>76.057576</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2843</td>\n",
       "      <td>4572</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-02-13</td>\n",
       "      <td>1988963</td>\n",
       "      <td>8455</td>\n",
       "      <td>10261</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>83.820779</td>\n",
       "      <td>75.601010</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>2832</td>\n",
       "      <td>4561</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-02-07</td>\n",
       "      <td>1988952</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>82.381385</td>\n",
       "      <td>77.005119</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2802</td>\n",
       "      <td>4531</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-01-16</td>\n",
       "      <td>1988922</td>\n",
       "      <td>8455</td>\n",
       "      <td>8668</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>82.290476</td>\n",
       "      <td>77.995671</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>2794</td>\n",
       "      <td>4523</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-01-13</td>\n",
       "      <td>1988914</td>\n",
       "      <td>8455</td>\n",
       "      <td>8659</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>82.308658</td>\n",
       "      <td>74.501732</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>2752</td>\n",
       "      <td>4481</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-26</td>\n",
       "      <td>1988882</td>\n",
       "      <td>8455</td>\n",
       "      <td>9817</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>83.420779</td>\n",
       "      <td>73.941991</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>2741</td>\n",
       "      <td>4470</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-19</td>\n",
       "      <td>1988871</td>\n",
       "      <td>8455</td>\n",
       "      <td>8472</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>82.881385</td>\n",
       "      <td>73.839935</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>2721</td>\n",
       "      <td>4450</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-05</td>\n",
       "      <td>1988851</td>\n",
       "      <td>8455</td>\n",
       "      <td>8678</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>82.291460</td>\n",
       "      <td>69.951515</td>\n",
       "      <td>Defeat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>2700</td>\n",
       "      <td>4429</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-11-21</td>\n",
       "      <td>1988830</td>\n",
       "      <td>8455</td>\n",
       "      <td>9850</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>81.804113</td>\n",
       "      <td>73.091558</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>2680</td>\n",
       "      <td>4409</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-10-31</td>\n",
       "      <td>1988810</td>\n",
       "      <td>8455</td>\n",
       "      <td>8650</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>82.079870</td>\n",
       "      <td>79.092172</td>\n",
       "      <td>Defeat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>3030</td>\n",
       "      <td>4759</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-10-17</td>\n",
       "      <td>1988790</td>\n",
       "      <td>8455</td>\n",
       "      <td>10252</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>79.341027</td>\n",
       "      <td>74.472294</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>3023</td>\n",
       "      <td>4752</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-10-03</td>\n",
       "      <td>1988783</td>\n",
       "      <td>8455</td>\n",
       "      <td>8466</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>83.197727</td>\n",
       "      <td>76.337807</td>\n",
       "      <td>Defeat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>3002</td>\n",
       "      <td>4731</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-09-19</td>\n",
       "      <td>1988762</td>\n",
       "      <td>8455</td>\n",
       "      <td>9825</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>82.979870</td>\n",
       "      <td>80.429545</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>2982</td>\n",
       "      <td>4711</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-08-29</td>\n",
       "      <td>1988742</td>\n",
       "      <td>8455</td>\n",
       "      <td>9826</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>83.184416</td>\n",
       "      <td>75.123485</td>\n",
       "      <td>Defeat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>2662</td>\n",
       "      <td>4391</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-08-08</td>\n",
       "      <td>1987034</td>\n",
       "      <td>8455</td>\n",
       "      <td>10003</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>83.911688</td>\n",
       "      <td>76.984848</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>2592</td>\n",
       "      <td>4321</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-05-24</td>\n",
       "      <td>1724354</td>\n",
       "      <td>8455</td>\n",
       "      <td>8472</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>82.087013</td>\n",
       "      <td>73.992075</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>2572</td>\n",
       "      <td>4301</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-05-10</td>\n",
       "      <td>1724334</td>\n",
       "      <td>8455</td>\n",
       "      <td>8650</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>79.433045</td>\n",
       "      <td>78.690115</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>2561</td>\n",
       "      <td>4290</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-05-03</td>\n",
       "      <td>1724323</td>\n",
       "      <td>8455</td>\n",
       "      <td>9826</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>82.632468</td>\n",
       "      <td>72.331277</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>2542</td>\n",
       "      <td>4271</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-04-18</td>\n",
       "      <td>1724304</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>82.011039</td>\n",
       "      <td>79.283838</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>2522</td>\n",
       "      <td>4251</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-04-04</td>\n",
       "      <td>1724284</td>\n",
       "      <td>8455</td>\n",
       "      <td>10194</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>82.516811</td>\n",
       "      <td>75.241126</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>2492</td>\n",
       "      <td>4221</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-03-15</td>\n",
       "      <td>1724264</td>\n",
       "      <td>8455</td>\n",
       "      <td>8466</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>82.885498</td>\n",
       "      <td>75.870701</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>2461</td>\n",
       "      <td>4190</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-02-21</td>\n",
       "      <td>1724233</td>\n",
       "      <td>8455</td>\n",
       "      <td>8191</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>82.634848</td>\n",
       "      <td>69.712843</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>2457</td>\n",
       "      <td>4186</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-02-11</td>\n",
       "      <td>1724229</td>\n",
       "      <td>8455</td>\n",
       "      <td>8668</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>81.494084</td>\n",
       "      <td>76.144805</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>538</th>\n",
       "      <td>2431</td>\n",
       "      <td>4160</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-01-31</td>\n",
       "      <td>1724203</td>\n",
       "      <td>8455</td>\n",
       "      <td>8456</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>81.625902</td>\n",
       "      <td>82.247980</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>555</th>\n",
       "      <td>2412</td>\n",
       "      <td>4141</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-01-10</td>\n",
       "      <td>1724184</td>\n",
       "      <td>8455</td>\n",
       "      <td>10261</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>82.321861</td>\n",
       "      <td>73.928030</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>2372</td>\n",
       "      <td>4101</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014-12-26</td>\n",
       "      <td>1724154</td>\n",
       "      <td>8455</td>\n",
       "      <td>8654</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>82.885498</td>\n",
       "      <td>73.452709</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2457</th>\n",
       "      <td>526</td>\n",
       "      <td>2255</td>\n",
       "      <td>2009</td>\n",
       "      <td>2010-01-16</td>\n",
       "      <td>658952</td>\n",
       "      <td>8455</td>\n",
       "      <td>8472</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>83.272727</td>\n",
       "      <td>71.500000</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2469</th>\n",
       "      <td>505</td>\n",
       "      <td>2234</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-12-28</td>\n",
       "      <td>658931</td>\n",
       "      <td>8455</td>\n",
       "      <td>9879</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>83.500000</td>\n",
       "      <td>73.727273</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2495</th>\n",
       "      <td>469</td>\n",
       "      <td>2198</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-12-16</td>\n",
       "      <td>658838</td>\n",
       "      <td>8455</td>\n",
       "      <td>8462</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>83.227273</td>\n",
       "      <td>70.636364</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2504</th>\n",
       "      <td>456</td>\n",
       "      <td>2185</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-12-12</td>\n",
       "      <td>658825</td>\n",
       "      <td>8455</td>\n",
       "      <td>8668</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>84.000000</td>\n",
       "      <td>77.909091</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2539</th>\n",
       "      <td>424</td>\n",
       "      <td>2153</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-11-21</td>\n",
       "      <td>658793</td>\n",
       "      <td>8455</td>\n",
       "      <td>8602</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>82.818182</td>\n",
       "      <td>69.727273</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2545</th>\n",
       "      <td>419</td>\n",
       "      <td>2148</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-11-08</td>\n",
       "      <td>658728</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>84.227273</td>\n",
       "      <td>81.454545</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2573</th>\n",
       "      <td>391</td>\n",
       "      <td>2120</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-10-24</td>\n",
       "      <td>658700</td>\n",
       "      <td>8455</td>\n",
       "      <td>8655</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>83.818182</td>\n",
       "      <td>72.555556</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2585</th>\n",
       "      <td>744</td>\n",
       "      <td>2473</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-10-04</td>\n",
       "      <td>658683</td>\n",
       "      <td>8455</td>\n",
       "      <td>8650</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>83.000000</td>\n",
       "      <td>82.318182</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>729</td>\n",
       "      <td>2458</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-09-20</td>\n",
       "      <td>658632</td>\n",
       "      <td>8455</td>\n",
       "      <td>8586</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>84.500000</td>\n",
       "      <td>78.000000</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2633</th>\n",
       "      <td>709</td>\n",
       "      <td>2438</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-08-29</td>\n",
       "      <td>658612</td>\n",
       "      <td>8455</td>\n",
       "      <td>8191</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>84.545455</td>\n",
       "      <td>71.950000</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2657</th>\n",
       "      <td>389</td>\n",
       "      <td>2118</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-08-15</td>\n",
       "      <td>658582</td>\n",
       "      <td>8455</td>\n",
       "      <td>8667</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>84.272727</td>\n",
       "      <td>70.318182</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2671</th>\n",
       "      <td>309</td>\n",
       "      <td>2038</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-05-17</td>\n",
       "      <td>489412</td>\n",
       "      <td>8455</td>\n",
       "      <td>8655</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>84.500000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2700</th>\n",
       "      <td>289</td>\n",
       "      <td>2018</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-05-02</td>\n",
       "      <td>489392</td>\n",
       "      <td>8455</td>\n",
       "      <td>9879</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>84.500000</td>\n",
       "      <td>73.181818</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>269</td>\n",
       "      <td>1998</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-04-22</td>\n",
       "      <td>489372</td>\n",
       "      <td>8455</td>\n",
       "      <td>8668</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>84.090909</td>\n",
       "      <td>77.363636</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2728</th>\n",
       "      <td>259</td>\n",
       "      <td>1988</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-04-11</td>\n",
       "      <td>489362</td>\n",
       "      <td>8455</td>\n",
       "      <td>8559</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>83.500000</td>\n",
       "      <td>73.772727</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2752</th>\n",
       "      <td>219</td>\n",
       "      <td>1948</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-03-15</td>\n",
       "      <td>489332</td>\n",
       "      <td>8455</td>\n",
       "      <td>8456</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>85.409091</td>\n",
       "      <td>78.590909</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2780</th>\n",
       "      <td>199</td>\n",
       "      <td>1928</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-02-28</td>\n",
       "      <td>489312</td>\n",
       "      <td>8455</td>\n",
       "      <td>8528</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>82.681818</td>\n",
       "      <td>71.909091</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2795</th>\n",
       "      <td>179</td>\n",
       "      <td>1908</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-02-07</td>\n",
       "      <td>489292</td>\n",
       "      <td>8455</td>\n",
       "      <td>8667</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>82.500000</td>\n",
       "      <td>67.636364</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>159</td>\n",
       "      <td>1888</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-01-28</td>\n",
       "      <td>489272</td>\n",
       "      <td>8455</td>\n",
       "      <td>8549</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>83.772727</td>\n",
       "      <td>71.136364</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2831</th>\n",
       "      <td>149</td>\n",
       "      <td>1878</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-01-17</td>\n",
       "      <td>489262</td>\n",
       "      <td>8455</td>\n",
       "      <td>10194</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>83.500000</td>\n",
       "      <td>69.454545</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2861</th>\n",
       "      <td>109</td>\n",
       "      <td>1838</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-12-26</td>\n",
       "      <td>489232</td>\n",
       "      <td>8455</td>\n",
       "      <td>8659</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>83.181818</td>\n",
       "      <td>70.454545</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2871</th>\n",
       "      <td>89</td>\n",
       "      <td>1818</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-12-14</td>\n",
       "      <td>489211</td>\n",
       "      <td>8455</td>\n",
       "      <td>8654</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.409091</td>\n",
       "      <td>74.272727</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2892</th>\n",
       "      <td>69</td>\n",
       "      <td>1798</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-30</td>\n",
       "      <td>489191</td>\n",
       "      <td>8455</td>\n",
       "      <td>9825</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>83.090909</td>\n",
       "      <td>81.000000</td>\n",
       "      <td>Defeat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2909</th>\n",
       "      <td>59</td>\n",
       "      <td>1788</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-22</td>\n",
       "      <td>489181</td>\n",
       "      <td>8455</td>\n",
       "      <td>10261</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>83.272727</td>\n",
       "      <td>75.772727</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2940</th>\n",
       "      <td>29</td>\n",
       "      <td>1758</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-01</td>\n",
       "      <td>489151</td>\n",
       "      <td>8455</td>\n",
       "      <td>8472</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>84.136364</td>\n",
       "      <td>72.045455</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2951</th>\n",
       "      <td>379</td>\n",
       "      <td>2108</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-10-26</td>\n",
       "      <td>489131</td>\n",
       "      <td>8455</td>\n",
       "      <td>8650</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>83.954545</td>\n",
       "      <td>81.909091</td>\n",
       "      <td>Defeat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2976</th>\n",
       "      <td>359</td>\n",
       "      <td>2088</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-10-05</td>\n",
       "      <td>489111</td>\n",
       "      <td>8455</td>\n",
       "      <td>10252</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>83.363636</td>\n",
       "      <td>78.818182</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2992</th>\n",
       "      <td>339</td>\n",
       "      <td>2068</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-09-21</td>\n",
       "      <td>489091</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.500000</td>\n",
       "      <td>81.772727</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3011</th>\n",
       "      <td>229</td>\n",
       "      <td>1958</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-08-31</td>\n",
       "      <td>489071</td>\n",
       "      <td>8455</td>\n",
       "      <td>8586</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.318182</td>\n",
       "      <td>78.090909</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3032</th>\n",
       "      <td>9</td>\n",
       "      <td>1738</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-08-17</td>\n",
       "      <td>489051</td>\n",
       "      <td>8455</td>\n",
       "      <td>8462</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>84.681818</td>\n",
       "      <td>77.590909</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>152 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index    id  season       date  match_api_id  home_team_api_id  \\\n",
       "8      2971  4700    2015 2016-05-15       1987598              8455   \n",
       "24     2951  4680    2015 2016-05-02       1989061              8455   \n",
       "54     2932  4661    2015 2016-04-16       1989042              8455   \n",
       "82     2900  4629    2015 2016-03-19       1989010              8455   \n",
       "99     2870  4599    2015 2016-03-05       1988990              8455   \n",
       "127    2843  4572    2015 2016-02-13       1988963              8455   \n",
       "131    2832  4561    2015 2016-02-07       1988952              8455   \n",
       "168    2802  4531    2015 2016-01-16       1988922              8455   \n",
       "172    2794  4523    2015 2016-01-13       1988914              8455   \n",
       "203    2752  4481    2015 2015-12-26       1988882              8455   \n",
       "213    2741  4470    2015 2015-12-19       1988871              8455   \n",
       "236    2721  4450    2015 2015-12-05       1988851              8455   \n",
       "259    2700  4429    2015 2015-11-21       1988830              8455   \n",
       "278    2680  4409    2015 2015-10-31       1988810              8455   \n",
       "298    3030  4759    2015 2015-10-17       1988790              8455   \n",
       "306    3023  4752    2015 2015-10-03       1988783              8455   \n",
       "327    3002  4731    2015 2015-09-19       1988762              8455   \n",
       "345    2982  4711    2015 2015-08-29       1988742              8455   \n",
       "376    2662  4391    2015 2015-08-08       1987034              8455   \n",
       "387    2592  4321    2014 2015-05-24       1724354              8455   \n",
       "403    2572  4301    2014 2015-05-10       1724334              8455   \n",
       "412    2561  4290    2014 2015-05-03       1724323              8455   \n",
       "439    2542  4271    2014 2015-04-18       1724304              8455   \n",
       "456    2522  4251    2014 2015-04-04       1724284              8455   \n",
       "473    2492  4221    2014 2015-03-15       1724264              8455   \n",
       "507    2461  4190    2014 2015-02-21       1724233              8455   \n",
       "514    2457  4186    2014 2015-02-11       1724229              8455   \n",
       "538    2431  4160    2014 2015-01-31       1724203              8455   \n",
       "555    2412  4141    2014 2015-01-10       1724184              8455   \n",
       "585    2372  4101    2014 2014-12-26       1724154              8455   \n",
       "...     ...   ...     ...        ...           ...               ...   \n",
       "2457    526  2255    2009 2010-01-16        658952              8455   \n",
       "2469    505  2234    2009 2009-12-28        658931              8455   \n",
       "2495    469  2198    2009 2009-12-16        658838              8455   \n",
       "2504    456  2185    2009 2009-12-12        658825              8455   \n",
       "2539    424  2153    2009 2009-11-21        658793              8455   \n",
       "2545    419  2148    2009 2009-11-08        658728              8455   \n",
       "2573    391  2120    2009 2009-10-24        658700              8455   \n",
       "2585    744  2473    2009 2009-10-04        658683              8455   \n",
       "2604    729  2458    2009 2009-09-20        658632              8455   \n",
       "2633    709  2438    2009 2009-08-29        658612              8455   \n",
       "2657    389  2118    2009 2009-08-15        658582              8455   \n",
       "2671    309  2038    2008 2009-05-17        489412              8455   \n",
       "2700    289  2018    2008 2009-05-02        489392              8455   \n",
       "2711    269  1998    2008 2009-04-22        489372              8455   \n",
       "2728    259  1988    2008 2009-04-11        489362              8455   \n",
       "2752    219  1948    2008 2009-03-15        489332              8455   \n",
       "2780    199  1928    2008 2009-02-28        489312              8455   \n",
       "2795    179  1908    2008 2009-02-07        489292              8455   \n",
       "2813    159  1888    2008 2009-01-28        489272              8455   \n",
       "2831    149  1878    2008 2009-01-17        489262              8455   \n",
       "2861    109  1838    2008 2008-12-26        489232              8455   \n",
       "2871     89  1818    2008 2008-12-14        489211              8455   \n",
       "2892     69  1798    2008 2008-11-30        489191              8455   \n",
       "2909     59  1788    2008 2008-11-22        489181              8455   \n",
       "2940     29  1758    2008 2008-11-01        489151              8455   \n",
       "2951    379  2108    2008 2008-10-26        489131              8455   \n",
       "2976    359  2088    2008 2008-10-05        489111              8455   \n",
       "2992    339  2068    2008 2008-09-21        489091              8455   \n",
       "3011    229  1958    2008 2008-08-31        489071              8455   \n",
       "3032      9  1738    2008 2008-08-17        489051              8455   \n",
       "\n",
       "      away_team_api_id  home_team_goal  away_team_goal  home_rating  \\\n",
       "8                 8197               1               1    81.815702   \n",
       "24                8586               2               2    82.443506   \n",
       "54                8456               0               3    79.760724   \n",
       "82                8654               2               2    81.172727   \n",
       "99               10194               1               1    81.164187   \n",
       "127              10261               5               1    83.820779   \n",
       "131              10260               1               1    82.381385   \n",
       "168               8668               3               3    82.290476   \n",
       "172               8659               2               2    82.308658   \n",
       "203               9817               2               2    83.420779   \n",
       "213               8472               3               1    82.881385   \n",
       "236               8678               0               1    82.291460   \n",
       "259               9850               1               0    81.804113   \n",
       "278               8650               1               3    82.079870   \n",
       "298              10252               2               0    79.341027   \n",
       "306               8466               1               3    83.197727   \n",
       "327               9825               2               0    82.979870   \n",
       "345               9826               1               2    83.184416   \n",
       "376              10003               2               2    83.911688   \n",
       "387               8472               3               1    82.087013   \n",
       "403               8650               1               1    79.433045   \n",
       "412               9826               1               0    82.632468   \n",
       "439              10260               1               0    82.011039   \n",
       "456              10194               2               1    82.516811   \n",
       "473               8466               1               1    82.885498   \n",
       "507               8191               1               1    82.634848   \n",
       "514               8668               1               0    81.494084   \n",
       "538               8456               1               1    81.625902   \n",
       "555              10261               2               0    82.321861   \n",
       "585               8654               2               0    82.885498   \n",
       "...                ...             ...             ...          ...   \n",
       "2457              8472               7               2    83.272727   \n",
       "2469              9879               2               1    83.500000   \n",
       "2495              8462               2               1    83.227273   \n",
       "2504              8668               3               3    84.000000   \n",
       "2539              8602               4               0    82.818182   \n",
       "2545             10260               1               0    84.227273   \n",
       "2573              8655               5               0    83.818182   \n",
       "2585              8650               2               0    83.000000   \n",
       "2604              8586               3               0    84.500000   \n",
       "2633              8191               3               0    84.545455   \n",
       "2657              8667               2               1    84.272727   \n",
       "2671              8655               2               0    84.500000   \n",
       "2700              9879               3               1    84.500000   \n",
       "2711              8668               0               0    84.090909   \n",
       "2728              8559               4               3    83.500000   \n",
       "2752              8456               1               0    85.409091   \n",
       "2780              8528               2               1    82.681818   \n",
       "2795              8667               0               0    82.500000   \n",
       "2813              8549               2               0    83.772727   \n",
       "2831             10194               2               1    83.500000   \n",
       "2861              8659               2               0    83.181818   \n",
       "2871              8654               1               1    84.409091   \n",
       "2892              9825               1               2    83.090909   \n",
       "2909             10261               0               0    83.272727   \n",
       "2940              8472               5               0    84.136364   \n",
       "2951              8650               0               1    83.954545   \n",
       "2976             10252               2               0    83.363636   \n",
       "2992             10260               1               1    84.500000   \n",
       "3011              8586               1               1    84.318182   \n",
       "3032              8462               4               0    84.681818   \n",
       "\n",
       "      away_rating  result  \n",
       "8       71.847619    Draw  \n",
       "24      78.987234    Draw  \n",
       "54      82.540404  Defeat  \n",
       "82      75.666667    Draw  \n",
       "99      76.057576    Draw  \n",
       "127     75.601010     Win  \n",
       "131     77.005119    Draw  \n",
       "168     77.995671    Draw  \n",
       "172     74.501732    Draw  \n",
       "203     73.941991    Draw  \n",
       "213     73.839935     Win  \n",
       "236     69.951515  Defeat  \n",
       "259     73.091558     Win  \n",
       "278     79.092172  Defeat  \n",
       "298     74.472294     Win  \n",
       "306     76.337807  Defeat  \n",
       "327     80.429545     Win  \n",
       "345     75.123485  Defeat  \n",
       "376     76.984848    Draw  \n",
       "387     73.992075     Win  \n",
       "403     78.690115    Draw  \n",
       "412     72.331277     Win  \n",
       "439     79.283838     Win  \n",
       "456     75.241126     Win  \n",
       "473     75.870701    Draw  \n",
       "507     69.712843    Draw  \n",
       "514     76.144805     Win  \n",
       "538     82.247980    Draw  \n",
       "555     73.928030     Win  \n",
       "585     73.452709     Win  \n",
       "...           ...     ...  \n",
       "2457    71.500000     Win  \n",
       "2469    73.727273     Win  \n",
       "2495    70.636364     Win  \n",
       "2504    77.909091    Draw  \n",
       "2539    69.727273     Win  \n",
       "2545    81.454545     Win  \n",
       "2573    72.555556     Win  \n",
       "2585    82.318182     Win  \n",
       "2604    78.000000     Win  \n",
       "2633    71.950000     Win  \n",
       "2657    70.318182     Win  \n",
       "2671    75.000000     Win  \n",
       "2700    73.181818     Win  \n",
       "2711    77.363636    Draw  \n",
       "2728    73.772727     Win  \n",
       "2752    78.590909     Win  \n",
       "2780    71.909091     Win  \n",
       "2795    67.636364    Draw  \n",
       "2813    71.136364     Win  \n",
       "2831    69.454545     Win  \n",
       "2861    70.454545     Win  \n",
       "2871    74.272727    Draw  \n",
       "2892    81.000000  Defeat  \n",
       "2909    75.772727    Draw  \n",
       "2940    72.045455     Win  \n",
       "2951    81.909091  Defeat  \n",
       "2976    78.818182     Win  \n",
       "2992    81.772727    Draw  \n",
       "3011    78.090909    Draw  \n",
       "3032    77.590909     Win  \n",
       "\n",
       "[152 rows x 12 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches_epl[(matches_epl['home_team_api_id']==8455)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy\n",
    "def get_last_five_score(team,date):\n",
    "    streak_score=0\n",
    "    last_five = matches_epl[((matches_epl['home_team_api_id']==team) | (matches_epl['away_team_api_id']==team)) & (matches_epl['date']<date)].head(5)\n",
    "#     print(len(last_five))\n",
    "#     last_five['team_ground'] = last_five.apply(lambda x: 'home' if x['home_team_api_id']==team else 'away', axis=1)\n",
    "    #Last 5 not empty - i.e. no previous match data for this team id\n",
    "    if not last_five.empty:\n",
    "#         #To determine whether the last match of team was at home or away to get the score difference \n",
    "#         last_five['team_score'] = \n",
    "        last_five['team_score'] = last_five.apply(lambda x: (x['home_team_goal']-x['away_team_goal'] if (x['home_team_api_id']==team) else x['away_team_goal']-x['home_team_goal'] ),axis=1)\n",
    "        streak_score = last_five.team_score.sum()\n",
    "#         print('=--------',date)\n",
    "#         print(last_five)\n",
    "#         print(streak_score)\n",
    "    \n",
    "        if type(streak_score)!= numpy.int64:\n",
    "            return streak_score.values[0]\n",
    "        else:\n",
    "            return streak_score\n",
    "    else:\n",
    "        \n",
    "        print(date,'--------------------------------Empty')\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2015-08-08 00:00:00 --------------------------------Empty\n",
      "2014-08-16 00:00:00 --------------------------------Empty\n",
      "2013-08-18 00:00:00 --------------------------------Empty\n",
      "2012-08-18 00:00:00 --------------------------------Empty\n",
      "2011-08-13 00:00:00 --------------------------------Empty\n",
      "2009-08-15 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n"
     ]
    }
   ],
   "source": [
    "matches_epl['home_last_five_score'] = matches_epl.apply(lambda x: get_last_five_score(x['home_team_api_id'],x['date']),axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2015-08-08 00:00:00 --------------------------------Empty\n",
      "2013-08-17 00:00:00 --------------------------------Empty\n",
      "2012-08-19 00:00:00 --------------------------------Empty\n",
      "2011-08-15 00:00:00 --------------------------------Empty\n",
      "2011-08-13 00:00:00 --------------------------------Empty\n",
      "2010-08-14 00:00:00 --------------------------------Empty\n",
      "2009-08-16 00:00:00 --------------------------------Empty\n",
      "2009-08-15 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n"
     ]
    }
   ],
   "source": [
    "matches_epl['away_last_five_score'] = matches_epl.apply(lambda x: get_last_five_score(x['away_team_api_id'],x['date']),axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>id</th>\n",
       "      <th>season</th>\n",
       "      <th>date</th>\n",
       "      <th>match_api_id</th>\n",
       "      <th>home_team_api_id</th>\n",
       "      <th>away_team_api_id</th>\n",
       "      <th>home_team_goal</th>\n",
       "      <th>away_team_goal</th>\n",
       "      <th>home_rating</th>\n",
       "      <th>away_rating</th>\n",
       "      <th>result</th>\n",
       "      <th>home_last_five_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2971</td>\n",
       "      <td>4700</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-05-15</td>\n",
       "      <td>1987598</td>\n",
       "      <td>8455</td>\n",
       "      <td>8197</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>81.815702</td>\n",
       "      <td>71.847619</td>\n",
       "      <td>Draw</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2894</td>\n",
       "      <td>4623</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-05-11</td>\n",
       "      <td>1989004</td>\n",
       "      <td>8650</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>79.077020</td>\n",
       "      <td>81.171763</td>\n",
       "      <td>Draw</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2967</td>\n",
       "      <td>4696</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-05-07</td>\n",
       "      <td>1989077</td>\n",
       "      <td>8472</td>\n",
       "      <td>8455</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>75.132576</td>\n",
       "      <td>83.320779</td>\n",
       "      <td>Win</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2951</td>\n",
       "      <td>4680</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-05-02</td>\n",
       "      <td>1989061</td>\n",
       "      <td>8455</td>\n",
       "      <td>8586</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>82.443506</td>\n",
       "      <td>78.987234</td>\n",
       "      <td>Draw</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2941</td>\n",
       "      <td>4670</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-04-23</td>\n",
       "      <td>1989051</td>\n",
       "      <td>8678</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>69.701515</td>\n",
       "      <td>82.074360</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2932</td>\n",
       "      <td>4661</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-04-16</td>\n",
       "      <td>1989042</td>\n",
       "      <td>8455</td>\n",
       "      <td>8456</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>79.760724</td>\n",
       "      <td>82.540404</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2926</td>\n",
       "      <td>4655</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-04-09</td>\n",
       "      <td>1989036</td>\n",
       "      <td>10003</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>77.053030</td>\n",
       "      <td>77.503960</td>\n",
       "      <td>Win</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2911</td>\n",
       "      <td>4640</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-04-02</td>\n",
       "      <td>1989021</td>\n",
       "      <td>10252</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>74.962554</td>\n",
       "      <td>76.617596</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2900</td>\n",
       "      <td>4629</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-03-19</td>\n",
       "      <td>1989010</td>\n",
       "      <td>8455</td>\n",
       "      <td>8654</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>81.172727</td>\n",
       "      <td>75.666667</td>\n",
       "      <td>Draw</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2870</td>\n",
       "      <td>4599</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-03-05</td>\n",
       "      <td>1988990</td>\n",
       "      <td>8455</td>\n",
       "      <td>10194</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>81.164187</td>\n",
       "      <td>76.057576</td>\n",
       "      <td>Draw</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>2864</td>\n",
       "      <td>4593</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>1988984</td>\n",
       "      <td>9850</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>73.221905</td>\n",
       "      <td>81.890476</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>2854</td>\n",
       "      <td>4583</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-02-27</td>\n",
       "      <td>1988974</td>\n",
       "      <td>8466</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>74.678139</td>\n",
       "      <td>82.327391</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2843</td>\n",
       "      <td>4572</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-02-13</td>\n",
       "      <td>1988963</td>\n",
       "      <td>8455</td>\n",
       "      <td>10261</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>83.820779</td>\n",
       "      <td>75.601010</td>\n",
       "      <td>Win</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>2832</td>\n",
       "      <td>4561</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-02-07</td>\n",
       "      <td>1988952</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>82.381385</td>\n",
       "      <td>77.005119</td>\n",
       "      <td>Draw</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>2824</td>\n",
       "      <td>4553</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-02-03</td>\n",
       "      <td>1988944</td>\n",
       "      <td>9817</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>73.975325</td>\n",
       "      <td>82.381385</td>\n",
       "      <td>Draw</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>2810</td>\n",
       "      <td>4539</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-01-24</td>\n",
       "      <td>1988930</td>\n",
       "      <td>9825</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>79.725758</td>\n",
       "      <td>82.381385</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2802</td>\n",
       "      <td>4531</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-01-16</td>\n",
       "      <td>1988922</td>\n",
       "      <td>8455</td>\n",
       "      <td>8668</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>82.290476</td>\n",
       "      <td>77.995671</td>\n",
       "      <td>Draw</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>2794</td>\n",
       "      <td>4523</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-01-13</td>\n",
       "      <td>1988914</td>\n",
       "      <td>8455</td>\n",
       "      <td>8659</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>82.308658</td>\n",
       "      <td>74.501732</td>\n",
       "      <td>Draw</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2781</td>\n",
       "      <td>4510</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>1988901</td>\n",
       "      <td>9826</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>74.321970</td>\n",
       "      <td>82.799567</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>2764</td>\n",
       "      <td>4493</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-28</td>\n",
       "      <td>1988894</td>\n",
       "      <td>10260</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>81.102955</td>\n",
       "      <td>82.409091</td>\n",
       "      <td>Draw</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>2752</td>\n",
       "      <td>4481</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-26</td>\n",
       "      <td>1988882</td>\n",
       "      <td>8455</td>\n",
       "      <td>9817</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>83.420779</td>\n",
       "      <td>73.941991</td>\n",
       "      <td>Draw</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>2741</td>\n",
       "      <td>4470</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-19</td>\n",
       "      <td>1988871</td>\n",
       "      <td>8455</td>\n",
       "      <td>8472</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>82.881385</td>\n",
       "      <td>73.839935</td>\n",
       "      <td>Win</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>2733</td>\n",
       "      <td>4462</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-14</td>\n",
       "      <td>1988863</td>\n",
       "      <td>8197</td>\n",
       "      <td>8455</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>72.954113</td>\n",
       "      <td>82.857143</td>\n",
       "      <td>Win</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>2721</td>\n",
       "      <td>4450</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-12-05</td>\n",
       "      <td>1988851</td>\n",
       "      <td>8455</td>\n",
       "      <td>8678</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>82.291460</td>\n",
       "      <td>69.951515</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>2718</td>\n",
       "      <td>4447</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-11-29</td>\n",
       "      <td>1988848</td>\n",
       "      <td>8586</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>78.366022</td>\n",
       "      <td>82.668182</td>\n",
       "      <td>Draw</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>2700</td>\n",
       "      <td>4429</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-11-21</td>\n",
       "      <td>1988830</td>\n",
       "      <td>8455</td>\n",
       "      <td>9850</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>81.804113</td>\n",
       "      <td>73.091558</td>\n",
       "      <td>Win</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>2697</td>\n",
       "      <td>4426</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-11-07</td>\n",
       "      <td>1988827</td>\n",
       "      <td>10194</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>76.136364</td>\n",
       "      <td>81.737997</td>\n",
       "      <td>Win</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>2680</td>\n",
       "      <td>4409</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-10-31</td>\n",
       "      <td>1988810</td>\n",
       "      <td>8455</td>\n",
       "      <td>8650</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>82.079870</td>\n",
       "      <td>79.092172</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>2679</td>\n",
       "      <td>4408</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>1988809</td>\n",
       "      <td>8654</td>\n",
       "      <td>8455</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>75.204545</td>\n",
       "      <td>82.804113</td>\n",
       "      <td>Win</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>3030</td>\n",
       "      <td>4759</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-10-17</td>\n",
       "      <td>1988790</td>\n",
       "      <td>8455</td>\n",
       "      <td>10252</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>79.341027</td>\n",
       "      <td>74.472294</td>\n",
       "      <td>Win</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2746</th>\n",
       "      <td>231</td>\n",
       "      <td>1960</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-03-21</td>\n",
       "      <td>489334</td>\n",
       "      <td>8586</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>79.090909</td>\n",
       "      <td>84.409091</td>\n",
       "      <td>Win</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2752</th>\n",
       "      <td>219</td>\n",
       "      <td>1948</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-03-15</td>\n",
       "      <td>489332</td>\n",
       "      <td>8455</td>\n",
       "      <td>8456</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>85.409091</td>\n",
       "      <td>78.590909</td>\n",
       "      <td>Win</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2770</th>\n",
       "      <td>202</td>\n",
       "      <td>1931</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-03-03</td>\n",
       "      <td>489315</td>\n",
       "      <td>8462</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>76.000000</td>\n",
       "      <td>84.090909</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2780</th>\n",
       "      <td>199</td>\n",
       "      <td>1928</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-02-28</td>\n",
       "      <td>489312</td>\n",
       "      <td>8455</td>\n",
       "      <td>8528</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>82.681818</td>\n",
       "      <td>71.909091</td>\n",
       "      <td>Win</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2786</th>\n",
       "      <td>183</td>\n",
       "      <td>1912</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-02-21</td>\n",
       "      <td>489296</td>\n",
       "      <td>10252</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>79.300000</td>\n",
       "      <td>83.681818</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2795</th>\n",
       "      <td>179</td>\n",
       "      <td>1908</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-02-07</td>\n",
       "      <td>489292</td>\n",
       "      <td>8455</td>\n",
       "      <td>8667</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>82.500000</td>\n",
       "      <td>67.636364</td>\n",
       "      <td>Draw</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2804</th>\n",
       "      <td>162</td>\n",
       "      <td>1891</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-02-01</td>\n",
       "      <td>489275</td>\n",
       "      <td>8650</td>\n",
       "      <td>8455</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>81.772727</td>\n",
       "      <td>83.772727</td>\n",
       "      <td>Win</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>159</td>\n",
       "      <td>1888</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-01-28</td>\n",
       "      <td>489272</td>\n",
       "      <td>8455</td>\n",
       "      <td>8549</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>83.772727</td>\n",
       "      <td>71.136364</td>\n",
       "      <td>Win</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2831</th>\n",
       "      <td>149</td>\n",
       "      <td>1878</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-01-17</td>\n",
       "      <td>489262</td>\n",
       "      <td>8455</td>\n",
       "      <td>10194</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>83.500000</td>\n",
       "      <td>69.454545</td>\n",
       "      <td>Win</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2835</th>\n",
       "      <td>130</td>\n",
       "      <td>1859</td>\n",
       "      <td>2008</td>\n",
       "      <td>2009-01-11</td>\n",
       "      <td>489243</td>\n",
       "      <td>10260</td>\n",
       "      <td>8455</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>82.136364</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>Win</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2849</th>\n",
       "      <td>126</td>\n",
       "      <td>1855</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-12-28</td>\n",
       "      <td>489239</td>\n",
       "      <td>9879</td>\n",
       "      <td>8455</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>73.636364</td>\n",
       "      <td>83.045455</td>\n",
       "      <td>Draw</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2861</th>\n",
       "      <td>109</td>\n",
       "      <td>1838</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-12-26</td>\n",
       "      <td>489232</td>\n",
       "      <td>8455</td>\n",
       "      <td>8659</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>83.181818</td>\n",
       "      <td>70.454545</td>\n",
       "      <td>Win</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2862</th>\n",
       "      <td>93</td>\n",
       "      <td>1822</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-12-22</td>\n",
       "      <td>489215</td>\n",
       "      <td>8668</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>78.272727</td>\n",
       "      <td>84.409091</td>\n",
       "      <td>Draw</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2871</th>\n",
       "      <td>89</td>\n",
       "      <td>1818</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-12-14</td>\n",
       "      <td>489211</td>\n",
       "      <td>8455</td>\n",
       "      <td>8654</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.409091</td>\n",
       "      <td>74.272727</td>\n",
       "      <td>Draw</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2887</th>\n",
       "      <td>77</td>\n",
       "      <td>1806</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-12-06</td>\n",
       "      <td>489199</td>\n",
       "      <td>8559</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>74.454545</td>\n",
       "      <td>83.954545</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2892</th>\n",
       "      <td>69</td>\n",
       "      <td>1798</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-30</td>\n",
       "      <td>489191</td>\n",
       "      <td>8455</td>\n",
       "      <td>9825</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>83.090909</td>\n",
       "      <td>81.000000</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2909</th>\n",
       "      <td>59</td>\n",
       "      <td>1788</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-22</td>\n",
       "      <td>489181</td>\n",
       "      <td>8455</td>\n",
       "      <td>10261</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>83.272727</td>\n",
       "      <td>75.772727</td>\n",
       "      <td>Draw</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2914</th>\n",
       "      <td>48</td>\n",
       "      <td>1777</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-15</td>\n",
       "      <td>489170</td>\n",
       "      <td>8659</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>81.090909</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2922</th>\n",
       "      <td>36</td>\n",
       "      <td>1765</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-09</td>\n",
       "      <td>489158</td>\n",
       "      <td>8655</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>72.300000</td>\n",
       "      <td>83.136364</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2940</th>\n",
       "      <td>29</td>\n",
       "      <td>1758</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-11-01</td>\n",
       "      <td>489151</td>\n",
       "      <td>8455</td>\n",
       "      <td>8472</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>84.136364</td>\n",
       "      <td>72.045455</td>\n",
       "      <td>Win</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2945</th>\n",
       "      <td>14</td>\n",
       "      <td>1743</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-10-29</td>\n",
       "      <td>489136</td>\n",
       "      <td>8667</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>70.909091</td>\n",
       "      <td>84.409091</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2951</th>\n",
       "      <td>379</td>\n",
       "      <td>2108</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-10-26</td>\n",
       "      <td>489131</td>\n",
       "      <td>8455</td>\n",
       "      <td>8650</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>83.954545</td>\n",
       "      <td>81.909091</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2970</th>\n",
       "      <td>364</td>\n",
       "      <td>2093</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-10-18</td>\n",
       "      <td>489116</td>\n",
       "      <td>8549</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>71.090909</td>\n",
       "      <td>81.227273</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2976</th>\n",
       "      <td>359</td>\n",
       "      <td>2088</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-10-05</td>\n",
       "      <td>489111</td>\n",
       "      <td>8455</td>\n",
       "      <td>10252</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>83.363636</td>\n",
       "      <td>78.818182</td>\n",
       "      <td>Win</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2983</th>\n",
       "      <td>348</td>\n",
       "      <td>2077</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-09-27</td>\n",
       "      <td>489100</td>\n",
       "      <td>10194</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>69.727273</td>\n",
       "      <td>84.090909</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2992</th>\n",
       "      <td>339</td>\n",
       "      <td>2068</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-09-21</td>\n",
       "      <td>489091</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.500000</td>\n",
       "      <td>81.772727</td>\n",
       "      <td>Draw</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3009</th>\n",
       "      <td>323</td>\n",
       "      <td>2052</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-09-13</td>\n",
       "      <td>489075</td>\n",
       "      <td>8456</td>\n",
       "      <td>8455</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>77.545455</td>\n",
       "      <td>84.409091</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3011</th>\n",
       "      <td>229</td>\n",
       "      <td>1958</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-08-31</td>\n",
       "      <td>489071</td>\n",
       "      <td>8455</td>\n",
       "      <td>8586</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.318182</td>\n",
       "      <td>78.090909</td>\n",
       "      <td>Draw</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3021</th>\n",
       "      <td>119</td>\n",
       "      <td>1848</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-08-24</td>\n",
       "      <td>489061</td>\n",
       "      <td>8528</td>\n",
       "      <td>8455</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>72.181818</td>\n",
       "      <td>85.136364</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3032</th>\n",
       "      <td>9</td>\n",
       "      <td>1738</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-08-17</td>\n",
       "      <td>489051</td>\n",
       "      <td>8455</td>\n",
       "      <td>8462</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>84.681818</td>\n",
       "      <td>77.590909</td>\n",
       "      <td>Win</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>304 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index    id  season       date  match_api_id  home_team_api_id  \\\n",
       "8      2971  4700    2015 2016-05-15       1987598              8455   \n",
       "12     2894  4623    2015 2016-05-11       1989004              8650   \n",
       "23     2967  4696    2015 2016-05-07       1989077              8472   \n",
       "24     2951  4680    2015 2016-05-02       1989061              8455   \n",
       "40     2941  4670    2015 2016-04-23       1989051              8678   \n",
       "54     2932  4661    2015 2016-04-16       1989042              8455   \n",
       "63     2926  4655    2015 2016-04-09       1989036             10003   \n",
       "70     2911  4640    2015 2016-04-02       1989021             10252   \n",
       "82     2900  4629    2015 2016-03-19       1989010              8455   \n",
       "99     2870  4599    2015 2016-03-05       1988990              8455   \n",
       "108    2864  4593    2015 2016-03-01       1988984              9850   \n",
       "118    2854  4583    2015 2016-02-27       1988974              8466   \n",
       "127    2843  4572    2015 2016-02-13       1988963              8455   \n",
       "131    2832  4561    2015 2016-02-07       1988952              8455   \n",
       "141    2824  4553    2015 2016-02-03       1988944              9817   \n",
       "151    2810  4539    2015 2016-01-24       1988930              9825   \n",
       "168    2802  4531    2015 2016-01-16       1988922              8455   \n",
       "172    2794  4523    2015 2016-01-13       1988914              8455   \n",
       "181    2781  4510    2015 2016-01-03       1988901              9826   \n",
       "198    2764  4493    2015 2015-12-28       1988894             10260   \n",
       "203    2752  4481    2015 2015-12-26       1988882              8455   \n",
       "213    2741  4470    2015 2015-12-19       1988871              8455   \n",
       "220    2733  4462    2015 2015-12-14       1988863              8197   \n",
       "236    2721  4450    2015 2015-12-05       1988851              8455   \n",
       "241    2718  4447    2015 2015-11-29       1988848              8586   \n",
       "259    2700  4429    2015 2015-11-21       1988830              8455   \n",
       "266    2697  4426    2015 2015-11-07       1988827             10194   \n",
       "278    2680  4409    2015 2015-10-31       1988810              8455   \n",
       "284    2679  4408    2015 2015-10-24       1988809              8654   \n",
       "298    3030  4759    2015 2015-10-17       1988790              8455   \n",
       "...     ...   ...     ...        ...           ...               ...   \n",
       "2746    231  1960    2008 2009-03-21        489334              8586   \n",
       "2752    219  1948    2008 2009-03-15        489332              8455   \n",
       "2770    202  1931    2008 2009-03-03        489315              8462   \n",
       "2780    199  1928    2008 2009-02-28        489312              8455   \n",
       "2786    183  1912    2008 2009-02-21        489296             10252   \n",
       "2795    179  1908    2008 2009-02-07        489292              8455   \n",
       "2804    162  1891    2008 2009-02-01        489275              8650   \n",
       "2813    159  1888    2008 2009-01-28        489272              8455   \n",
       "2831    149  1878    2008 2009-01-17        489262              8455   \n",
       "2835    130  1859    2008 2009-01-11        489243             10260   \n",
       "2849    126  1855    2008 2008-12-28        489239              9879   \n",
       "2861    109  1838    2008 2008-12-26        489232              8455   \n",
       "2862     93  1822    2008 2008-12-22        489215              8668   \n",
       "2871     89  1818    2008 2008-12-14        489211              8455   \n",
       "2887     77  1806    2008 2008-12-06        489199              8559   \n",
       "2892     69  1798    2008 2008-11-30        489191              8455   \n",
       "2909     59  1788    2008 2008-11-22        489181              8455   \n",
       "2914     48  1777    2008 2008-11-15        489170              8659   \n",
       "2922     36  1765    2008 2008-11-09        489158              8655   \n",
       "2940     29  1758    2008 2008-11-01        489151              8455   \n",
       "2945     14  1743    2008 2008-10-29        489136              8667   \n",
       "2951    379  2108    2008 2008-10-26        489131              8455   \n",
       "2970    364  2093    2008 2008-10-18        489116              8549   \n",
       "2976    359  2088    2008 2008-10-05        489111              8455   \n",
       "2983    348  2077    2008 2008-09-27        489100             10194   \n",
       "2992    339  2068    2008 2008-09-21        489091              8455   \n",
       "3009    323  2052    2008 2008-09-13        489075              8456   \n",
       "3011    229  1958    2008 2008-08-31        489071              8455   \n",
       "3021    119  1848    2008 2008-08-24        489061              8528   \n",
       "3032      9  1738    2008 2008-08-17        489051              8455   \n",
       "\n",
       "      away_team_api_id  home_team_goal  away_team_goal  home_rating  \\\n",
       "8                 8197               1               1    81.815702   \n",
       "12                8455               1               1    79.077020   \n",
       "23                8455               3               2    75.132576   \n",
       "24                8586               2               2    82.443506   \n",
       "40                8455               1               4    69.701515   \n",
       "54                8456               0               3    79.760724   \n",
       "63                8455               1               0    77.053030   \n",
       "70                8455               0               4    74.962554   \n",
       "82                8654               2               2    81.172727   \n",
       "99               10194               1               1    81.164187   \n",
       "108               8455               1               2    73.221905   \n",
       "118               8455               1               2    74.678139   \n",
       "127              10261               5               1    83.820779   \n",
       "131              10260               1               1    82.381385   \n",
       "141               8455               0               0    73.975325   \n",
       "151               8455               0               1    79.725758   \n",
       "168               8668               3               3    82.290476   \n",
       "172               8659               2               2    82.308658   \n",
       "181               8455               0               3    74.321970   \n",
       "198               8455               0               0    81.102955   \n",
       "203               9817               2               2    83.420779   \n",
       "213               8472               3               1    82.881385   \n",
       "220               8455               2               1    72.954113   \n",
       "236               8678               0               1    82.291460   \n",
       "241               8455               0               0    78.366022   \n",
       "259               9850               1               0    81.804113   \n",
       "266               8455               1               0    76.136364   \n",
       "278               8650               1               3    82.079870   \n",
       "284               8455               2               1    75.204545   \n",
       "298              10252               2               0    79.341027   \n",
       "...                ...             ...             ...          ...   \n",
       "2746              8455               1               0    79.090909   \n",
       "2752              8456               1               0    85.409091   \n",
       "2770              8455               0               1    76.000000   \n",
       "2780              8528               2               1    82.681818   \n",
       "2786              8455               0               1    79.300000   \n",
       "2795              8667               0               0    82.500000   \n",
       "2804              8455               2               0    81.772727   \n",
       "2813              8549               2               0    83.772727   \n",
       "2831             10194               2               1    83.500000   \n",
       "2835              8455               3               0    82.136364   \n",
       "2849              8455               2               2    73.636364   \n",
       "2861              8659               2               0    83.181818   \n",
       "2862              8455               0               0    78.272727   \n",
       "2871              8654               1               1    84.409091   \n",
       "2887              8455               0               2    74.454545   \n",
       "2892              9825               1               2    83.090909   \n",
       "2909             10261               0               0    83.272727   \n",
       "2914              8455               0               3    71.000000   \n",
       "2922              8455               0               2    72.300000   \n",
       "2940              8472               5               0    84.136364   \n",
       "2945              8455               0               3    70.909091   \n",
       "2951              8650               0               1    83.954545   \n",
       "2970              8455               0               5    71.090909   \n",
       "2976             10252               2               0    83.363636   \n",
       "2983              8455               0               2    69.727273   \n",
       "2992             10260               1               1    84.500000   \n",
       "3009              8455               1               3    77.545455   \n",
       "3011              8586               1               1    84.318182   \n",
       "3021              8455               0               1    72.181818   \n",
       "3032              8462               4               0    84.681818   \n",
       "\n",
       "      away_rating  result  home_last_five_score  \n",
       "8       71.847619    Draw                    -1  \n",
       "12      81.171763    Draw                     5  \n",
       "23      83.320779     Win                     1  \n",
       "24      78.987234    Draw                     3  \n",
       "40      82.074360  Defeat                    -6  \n",
       "54      82.540404  Defeat                     4  \n",
       "63      77.503960     Win                     2  \n",
       "70      76.617596  Defeat                   -10  \n",
       "82      75.666667    Draw                     6  \n",
       "99      76.057576    Draw                     6  \n",
       "108     81.890476  Defeat                    -7  \n",
       "118     82.327391  Defeat                     6  \n",
       "127     75.601010     Win                     1  \n",
       "131     77.005119    Draw                     4  \n",
       "141     82.381385    Draw                    -4  \n",
       "151     82.381385  Defeat                    -1  \n",
       "168     77.995671    Draw                     5  \n",
       "172     74.501732    Draw                     4  \n",
       "181     82.799567  Defeat                     2  \n",
       "198     82.409091    Draw                    -4  \n",
       "203     73.941991    Draw                     1  \n",
       "213     73.839935     Win                    -2  \n",
       "220     82.857143     Win                     8  \n",
       "236     69.951515  Defeat                    -3  \n",
       "241     82.668182    Draw                     9  \n",
       "259     73.091558     Win                    -4  \n",
       "266     81.737997     Win                     1  \n",
       "278     79.092172  Defeat                     1  \n",
       "284     82.804113     Win                     5  \n",
       "298     74.472294     Win                    -3  \n",
       "...           ...     ...                   ...  \n",
       "2746    84.409091     Win                     6  \n",
       "2752    78.590909     Win                     1  \n",
       "2770    84.090909  Defeat                    -2  \n",
       "2780    71.909091     Win                     2  \n",
       "2786    83.681818  Defeat                     5  \n",
       "2795    67.636364    Draw                    -2  \n",
       "2804    83.772727     Win                     7  \n",
       "2813    71.136364     Win                     0  \n",
       "2831    69.454545     Win                    -1  \n",
       "2835    85.000000     Win                     4  \n",
       "2849    83.045455    Draw                     3  \n",
       "2861    70.454545     Win                     1  \n",
       "2862    84.409091    Draw                     0  \n",
       "2871    74.272727    Draw                     6  \n",
       "2887    83.954545  Defeat                     6  \n",
       "2892    81.000000  Defeat                    13  \n",
       "2909    75.772727    Draw                    12  \n",
       "2914    81.090909  Defeat                   -11  \n",
       "2922    83.136364  Defeat                    -3  \n",
       "2940    72.045455     Win                    11  \n",
       "2945    84.409091  Defeat                     6  \n",
       "2951    81.909091  Defeat                    11  \n",
       "2970    81.227273  Defeat                    -2  \n",
       "2976    78.818182     Win                     5  \n",
       "2983    84.090909  Defeat                    -3  \n",
       "2992    81.772727    Draw                     7  \n",
       "3009    84.409091  Defeat                     4  \n",
       "3011    78.090909    Draw                     5  \n",
       "3021    85.136364  Defeat                    -1  \n",
       "3032    77.590909     Win                     0  \n",
       "\n",
       "[304 rows x 13 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches_epl[(matches_epl['home_team_api_id']==8455) |(matches_epl['away_team_api_id']==8455)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_last_five_opponent(team,date,opponent):\n",
    "    last_five = matches_epl[((matches_epl['home_team_api_id']==team) & (matches_epl['away_team_api_id']==opponent)) & (matches_epl['date']<date)].head(5)\n",
    "    if not last_five.empty:\n",
    "        streak_score = last_five.groupby('id').apply(lambda x: x['home_team_goal']-x['away_team_goal']).sum()\n",
    "        if type(streak_score)!= numpy.int64:\n",
    "            return streak_score.values[0]\n",
    "        else:\n",
    "            return streak_score\n",
    "    else:\n",
    "        \n",
    "        print(date,'--------------------------------Empty')\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2016-05-17 00:00:00 --------------------------------Empty\n",
      "2016-05-15 00:00:00 --------------------------------Empty\n",
      "2016-05-11 00:00:00 --------------------------------Empty\n",
      "2016-05-08 00:00:00 --------------------------------Empty\n",
      "2016-05-07 00:00:00 --------------------------------Empty\n",
      "2016-04-30 00:00:00 --------------------------------Empty\n",
      "2016-04-30 00:00:00 --------------------------------Empty\n",
      "2016-04-23 00:00:00 --------------------------------Empty\n",
      "2016-04-20 00:00:00 --------------------------------Empty\n",
      "2016-04-17 00:00:00 --------------------------------Empty\n",
      "2016-04-16 00:00:00 --------------------------------Empty\n",
      "2016-04-09 00:00:00 --------------------------------Empty\n",
      "2016-04-09 00:00:00 --------------------------------Empty\n",
      "2016-04-02 00:00:00 --------------------------------Empty\n",
      "2016-04-02 00:00:00 --------------------------------Empty\n",
      "2016-03-20 00:00:00 --------------------------------Empty\n",
      "2016-03-19 00:00:00 --------------------------------Empty\n",
      "2016-03-12 00:00:00 --------------------------------Empty\n",
      "2016-03-05 00:00:00 --------------------------------Empty\n",
      "2016-03-05 00:00:00 --------------------------------Empty\n",
      "2016-03-02 00:00:00 --------------------------------Empty\n",
      "2016-03-01 00:00:00 --------------------------------Empty\n",
      "2016-02-27 00:00:00 --------------------------------Empty\n",
      "2016-02-27 00:00:00 --------------------------------Empty\n",
      "2016-02-13 00:00:00 --------------------------------Empty\n",
      "2016-02-13 00:00:00 --------------------------------Empty\n",
      "2016-02-07 00:00:00 --------------------------------Empty\n",
      "2016-02-06 00:00:00 --------------------------------Empty\n",
      "2016-02-03 00:00:00 --------------------------------Empty\n",
      "2016-02-02 00:00:00 --------------------------------Empty\n",
      "2016-01-23 00:00:00 --------------------------------Empty\n",
      "2016-01-23 00:00:00 --------------------------------Empty\n",
      "2016-01-18 00:00:00 --------------------------------Empty\n",
      "2016-01-16 00:00:00 --------------------------------Empty\n",
      "2016-01-13 00:00:00 --------------------------------Empty\n",
      "2016-01-12 00:00:00 --------------------------------Empty\n",
      "2016-01-02 00:00:00 --------------------------------Empty\n",
      "2016-01-02 00:00:00 --------------------------------Empty\n",
      "2015-12-28 00:00:00 --------------------------------Empty\n",
      "2015-12-28 00:00:00 --------------------------------Empty\n",
      "2015-12-26 00:00:00 --------------------------------Empty\n",
      "2015-12-26 00:00:00 --------------------------------Empty\n",
      "2015-12-20 00:00:00 --------------------------------Empty\n",
      "2015-12-19 00:00:00 --------------------------------Empty\n",
      "2015-12-12 00:00:00 --------------------------------Empty\n",
      "2015-12-12 00:00:00 --------------------------------Empty\n",
      "2015-12-05 00:00:00 --------------------------------Empty\n",
      "2015-12-05 00:00:00 --------------------------------Empty\n",
      "2015-11-28 00:00:00 --------------------------------Empty\n",
      "2015-11-28 00:00:00 --------------------------------Empty\n",
      "2015-11-21 00:00:00 --------------------------------Empty\n",
      "2015-11-21 00:00:00 --------------------------------Empty\n",
      "2015-11-07 00:00:00 --------------------------------Empty\n",
      "2015-11-07 00:00:00 --------------------------------Empty\n",
      "2015-11-01 00:00:00 --------------------------------Empty\n",
      "2015-10-31 00:00:00 --------------------------------Empty\n",
      "2015-10-25 00:00:00 --------------------------------Empty\n",
      "2015-10-24 00:00:00 --------------------------------Empty\n",
      "2015-10-17 00:00:00 --------------------------------Empty\n",
      "2015-10-17 00:00:00 --------------------------------Empty\n",
      "2015-10-03 00:00:00 --------------------------------Empty\n",
      "2015-10-03 00:00:00 --------------------------------Empty\n",
      "2015-09-27 00:00:00 --------------------------------Empty\n",
      "2015-09-26 00:00:00 --------------------------------Empty\n",
      "2015-09-19 00:00:00 --------------------------------Empty\n",
      "2015-09-19 00:00:00 --------------------------------Empty\n",
      "2015-09-12 00:00:00 --------------------------------Empty\n",
      "2015-09-12 00:00:00 --------------------------------Empty\n",
      "2015-08-29 00:00:00 --------------------------------Empty\n",
      "2015-08-29 00:00:00 --------------------------------Empty\n",
      "2015-08-23 00:00:00 --------------------------------Empty\n",
      "2015-08-22 00:00:00 --------------------------------Empty\n",
      "2015-08-17 00:00:00 --------------------------------Empty\n",
      "2015-08-15 00:00:00 --------------------------------Empty\n",
      "2015-08-08 00:00:00 --------------------------------Empty\n",
      "2015-08-08 00:00:00 --------------------------------Empty\n",
      "2015-05-24 00:00:00 --------------------------------Empty\n",
      "2015-05-16 00:00:00 --------------------------------Empty\n",
      "2015-05-09 00:00:00 --------------------------------Empty\n",
      "2015-05-02 00:00:00 --------------------------------Empty\n",
      "2015-04-29 00:00:00 --------------------------------Empty\n",
      "2015-04-25 00:00:00 --------------------------------Empty\n",
      "2015-04-18 00:00:00 --------------------------------Empty\n",
      "2015-04-11 00:00:00 --------------------------------Empty\n",
      "2015-04-04 00:00:00 --------------------------------Empty\n",
      "2015-03-21 00:00:00 --------------------------------Empty\n",
      "2015-03-21 00:00:00 --------------------------------Empty\n",
      "2015-03-14 00:00:00 --------------------------------Empty\n",
      "2015-03-14 00:00:00 --------------------------------Empty\n",
      "2015-03-04 00:00:00 --------------------------------Empty\n",
      "2015-02-28 00:00:00 --------------------------------Empty\n",
      "2015-02-22 00:00:00 --------------------------------Empty\n",
      "2015-02-21 00:00:00 --------------------------------Empty\n",
      "2015-02-10 00:00:00 --------------------------------Empty\n",
      "2015-02-08 00:00:00 --------------------------------Empty\n",
      "2015-02-07 00:00:00 --------------------------------Empty\n",
      "2015-01-31 00:00:00 --------------------------------Empty\n",
      "2015-01-17 00:00:00 --------------------------------Empty\n",
      "2015-01-17 00:00:00 --------------------------------Empty\n",
      "2015-01-10 00:00:00 --------------------------------Empty\n",
      "2015-01-10 00:00:00 --------------------------------Empty\n",
      "2015-01-01 00:00:00 --------------------------------Empty\n",
      "2015-01-01 00:00:00 --------------------------------Empty\n",
      "2014-12-28 00:00:00 --------------------------------Empty\n",
      "2014-12-28 00:00:00 --------------------------------Empty\n",
      "2014-12-26 00:00:00 --------------------------------Empty\n",
      "2014-12-20 00:00:00 --------------------------------Empty\n",
      "2014-12-13 00:00:00 --------------------------------Empty\n",
      "2014-12-13 00:00:00 --------------------------------Empty\n",
      "2014-12-07 00:00:00 --------------------------------Empty\n",
      "2014-12-06 00:00:00 --------------------------------Empty\n",
      "2014-12-02 00:00:00 --------------------------------Empty\n",
      "2014-12-02 00:00:00 --------------------------------Empty\n",
      "2014-11-29 00:00:00 --------------------------------Empty\n",
      "2014-11-22 00:00:00 --------------------------------Empty\n",
      "2014-11-08 00:00:00 --------------------------------Empty\n",
      "2014-11-01 00:00:00 --------------------------------Empty\n",
      "2014-10-25 00:00:00 --------------------------------Empty\n",
      "2014-10-18 00:00:00 --------------------------------Empty\n",
      "2014-10-04 00:00:00 --------------------------------Empty\n",
      "2014-09-28 00:00:00 --------------------------------Empty\n",
      "2014-09-27 00:00:00 --------------------------------Empty\n",
      "2014-09-21 00:00:00 --------------------------------Empty\n",
      "2014-09-13 00:00:00 --------------------------------Empty\n",
      "2014-09-13 00:00:00 --------------------------------Empty\n",
      "2014-08-31 00:00:00 --------------------------------Empty\n",
      "2014-08-23 00:00:00 --------------------------------Empty\n",
      "2014-08-23 00:00:00 --------------------------------Empty\n",
      "2014-08-16 00:00:00 --------------------------------Empty\n",
      "2014-08-16 00:00:00 --------------------------------Empty\n",
      "2014-05-11 00:00:00 --------------------------------Empty\n",
      "2014-05-11 00:00:00 --------------------------------Empty\n",
      "2014-05-05 00:00:00 --------------------------------Empty\n",
      "2014-05-03 00:00:00 --------------------------------Empty\n",
      "2014-04-27 00:00:00 --------------------------------Empty\n",
      "2014-04-27 00:00:00 --------------------------------Empty\n",
      "2014-04-19 00:00:00 --------------------------------Empty\n",
      "2014-04-19 00:00:00 --------------------------------Empty\n",
      "2014-04-16 00:00:00 --------------------------------Empty\n",
      "2014-04-12 00:00:00 --------------------------------Empty\n",
      "2014-04-12 00:00:00 --------------------------------Empty\n",
      "2014-04-05 00:00:00 --------------------------------Empty\n",
      "2014-04-05 00:00:00 --------------------------------Empty\n",
      "2014-03-29 00:00:00 --------------------------------Empty\n",
      "2014-03-29 00:00:00 --------------------------------Empty\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2014-03-22 00:00:00 --------------------------------Empty\n",
      "2014-03-22 00:00:00 --------------------------------Empty\n",
      "2014-03-15 00:00:00 --------------------------------Empty\n",
      "2014-03-15 00:00:00 --------------------------------Empty\n",
      "2014-03-08 00:00:00 --------------------------------Empty\n",
      "2014-03-08 00:00:00 --------------------------------Empty\n",
      "2014-03-02 00:00:00 --------------------------------Empty\n",
      "2014-03-02 00:00:00 --------------------------------Empty\n",
      "2014-02-22 00:00:00 --------------------------------Empty\n",
      "2014-02-22 00:00:00 --------------------------------Empty\n",
      "2014-02-11 00:00:00 --------------------------------Empty\n",
      "2014-02-11 00:00:00 --------------------------------Empty\n",
      "2014-02-08 00:00:00 --------------------------------Empty\n",
      "2014-02-08 00:00:00 --------------------------------Empty\n",
      "2014-02-02 00:00:00 --------------------------------Empty\n",
      "2014-02-01 00:00:00 --------------------------------Empty\n",
      "2014-01-28 00:00:00 --------------------------------Empty\n",
      "2014-01-28 00:00:00 --------------------------------Empty\n",
      "2014-01-18 00:00:00 --------------------------------Empty\n",
      "2014-01-18 00:00:00 --------------------------------Empty\n",
      "2014-01-18 00:00:00 --------------------------------Empty\n",
      "2014-01-11 00:00:00 --------------------------------Empty\n",
      "2014-01-11 00:00:00 --------------------------------Empty\n",
      "2014-01-01 00:00:00 --------------------------------Empty\n",
      "2014-01-01 00:00:00 --------------------------------Empty\n",
      "2013-12-28 00:00:00 --------------------------------Empty\n",
      "2013-12-28 00:00:00 --------------------------------Empty\n",
      "2013-12-26 00:00:00 --------------------------------Empty\n",
      "2013-12-26 00:00:00 --------------------------------Empty\n",
      "2013-12-21 00:00:00 --------------------------------Empty\n",
      "2013-12-21 00:00:00 --------------------------------Empty\n",
      "2013-12-14 00:00:00 --------------------------------Empty\n",
      "2013-12-14 00:00:00 --------------------------------Empty\n",
      "2013-12-09 00:00:00 --------------------------------Empty\n",
      "2013-12-07 00:00:00 --------------------------------Empty\n",
      "2013-12-04 00:00:00 --------------------------------Empty\n",
      "2013-12-03 00:00:00 --------------------------------Empty\n",
      "2013-11-30 00:00:00 --------------------------------Empty\n",
      "2013-11-30 00:00:00 --------------------------------Empty\n",
      "2013-11-24 00:00:00 --------------------------------Empty\n",
      "2013-11-23 00:00:00 --------------------------------Empty\n",
      "2013-11-09 00:00:00 --------------------------------Empty\n",
      "2013-11-09 00:00:00 --------------------------------Empty\n",
      "2013-11-09 00:00:00 --------------------------------Empty\n",
      "2013-11-03 00:00:00 --------------------------------Empty\n",
      "2013-11-02 00:00:00 --------------------------------Empty\n",
      "2013-10-26 00:00:00 --------------------------------Empty\n",
      "2013-10-26 00:00:00 --------------------------------Empty\n",
      "2013-10-21 00:00:00 --------------------------------Empty\n",
      "2013-10-19 00:00:00 --------------------------------Empty\n",
      "2013-10-05 00:00:00 --------------------------------Empty\n",
      "2013-10-05 00:00:00 --------------------------------Empty\n",
      "2013-09-28 00:00:00 --------------------------------Empty\n",
      "2013-09-28 00:00:00 --------------------------------Empty\n",
      "2013-09-22 00:00:00 --------------------------------Empty\n",
      "2013-09-22 00:00:00 --------------------------------Empty\n",
      "2013-09-14 00:00:00 --------------------------------Empty\n",
      "2013-09-14 00:00:00 --------------------------------Empty\n",
      "2013-08-31 00:00:00 --------------------------------Empty\n",
      "2013-08-31 00:00:00 --------------------------------Empty\n",
      "2013-08-25 00:00:00 --------------------------------Empty\n",
      "2013-08-24 00:00:00 --------------------------------Empty\n",
      "2013-08-24 00:00:00 --------------------------------Empty\n",
      "2013-08-18 00:00:00 --------------------------------Empty\n",
      "2013-08-17 00:00:00 --------------------------------Empty\n",
      "2013-05-19 00:00:00 --------------------------------Empty\n",
      "2013-05-19 00:00:00 --------------------------------Empty\n",
      "2013-05-14 00:00:00 --------------------------------Empty\n",
      "2013-05-12 00:00:00 --------------------------------Empty\n",
      "2013-05-04 00:00:00 --------------------------------Empty\n",
      "2013-05-04 00:00:00 --------------------------------Empty\n",
      "2013-04-28 00:00:00 --------------------------------Empty\n",
      "2013-04-27 00:00:00 --------------------------------Empty\n",
      "2013-04-20 00:00:00 --------------------------------Empty\n",
      "2013-04-20 00:00:00 --------------------------------Empty\n",
      "2013-04-13 00:00:00 --------------------------------Empty\n",
      "2013-04-13 00:00:00 --------------------------------Empty\n",
      "2013-04-06 00:00:00 --------------------------------Empty\n",
      "2013-03-30 00:00:00 --------------------------------Empty\n",
      "2013-03-30 00:00:00 --------------------------------Empty\n",
      "2013-03-16 00:00:00 --------------------------------Empty\n",
      "2013-03-16 00:00:00 --------------------------------Empty\n",
      "2013-03-09 00:00:00 --------------------------------Empty\n",
      "2013-03-09 00:00:00 --------------------------------Empty\n",
      "2013-03-02 00:00:00 --------------------------------Empty\n",
      "2013-03-02 00:00:00 --------------------------------Empty\n",
      "2013-02-24 00:00:00 --------------------------------Empty\n",
      "2013-02-23 00:00:00 --------------------------------Empty\n",
      "2013-02-09 00:00:00 --------------------------------Empty\n",
      "2013-02-09 00:00:00 --------------------------------Empty\n",
      "2013-02-02 00:00:00 --------------------------------Empty\n",
      "2013-02-02 00:00:00 --------------------------------Empty\n",
      "2013-02-02 00:00:00 --------------------------------Empty\n",
      "2013-01-30 00:00:00 --------------------------------Empty\n",
      "2013-01-30 00:00:00 --------------------------------Empty\n",
      "2013-01-21 00:00:00 --------------------------------Empty\n",
      "2013-01-19 00:00:00 --------------------------------Empty\n",
      "2013-01-19 00:00:00 --------------------------------Empty\n",
      "2013-01-16 00:00:00 --------------------------------Empty\n",
      "2013-01-12 00:00:00 --------------------------------Empty\n",
      "2013-01-12 00:00:00 --------------------------------Empty\n",
      "2013-01-01 00:00:00 --------------------------------Empty\n",
      "2013-01-01 00:00:00 --------------------------------Empty\n",
      "2013-01-01 00:00:00 --------------------------------Empty\n",
      "2012-12-29 00:00:00 --------------------------------Empty\n",
      "2012-12-29 00:00:00 --------------------------------Empty\n",
      "2012-12-26 00:00:00 --------------------------------Empty\n",
      "2012-12-26 00:00:00 --------------------------------Empty\n",
      "2012-12-22 00:00:00 --------------------------------Empty\n",
      "2012-12-22 00:00:00 --------------------------------Empty\n",
      "2012-12-17 00:00:00 --------------------------------Empty\n",
      "2012-12-11 00:00:00 --------------------------------Empty\n",
      "2012-12-08 00:00:00 --------------------------------Empty\n",
      "2012-12-01 00:00:00 --------------------------------Empty\n",
      "2012-12-01 00:00:00 --------------------------------Empty\n",
      "2012-11-28 00:00:00 --------------------------------Empty\n",
      "2012-11-27 00:00:00 --------------------------------Empty\n",
      "2012-11-25 00:00:00 --------------------------------Empty\n",
      "2012-11-24 00:00:00 --------------------------------Empty\n",
      "2012-11-17 00:00:00 --------------------------------Empty\n",
      "2012-11-17 00:00:00 --------------------------------Empty\n",
      "2012-11-10 00:00:00 --------------------------------Empty\n",
      "2012-11-10 00:00:00 --------------------------------Empty\n",
      "2012-11-05 00:00:00 --------------------------------Empty\n",
      "2012-11-04 00:00:00 --------------------------------Empty\n",
      "2012-10-28 00:00:00 --------------------------------Empty\n",
      "2012-10-27 00:00:00 --------------------------------Empty\n",
      "2012-10-20 00:00:00 --------------------------------Empty\n",
      "2012-10-20 00:00:00 --------------------------------Empty\n",
      "2012-10-07 00:00:00 --------------------------------Empty\n",
      "2012-10-06 00:00:00 --------------------------------Empty\n",
      "2012-10-01 00:00:00 --------------------------------Empty\n",
      "2012-09-29 00:00:00 --------------------------------Empty\n",
      "2012-09-29 00:00:00 --------------------------------Empty\n",
      "2012-09-22 00:00:00 --------------------------------Empty\n",
      "2012-09-22 00:00:00 --------------------------------Empty\n",
      "2012-09-16 00:00:00 --------------------------------Empty\n",
      "2012-09-15 00:00:00 --------------------------------Empty\n",
      "2012-09-15 00:00:00 --------------------------------Empty\n",
      "2012-09-02 00:00:00 --------------------------------Empty\n",
      "2012-08-25 00:00:00 --------------------------------Empty\n",
      "2012-08-25 00:00:00 --------------------------------Empty\n",
      "2012-08-22 00:00:00 --------------------------------Empty\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2012-08-19 00:00:00 --------------------------------Empty\n",
      "2012-08-18 00:00:00 --------------------------------Empty\n",
      "2012-05-13 00:00:00 --------------------------------Empty\n",
      "2012-05-13 00:00:00 --------------------------------Empty\n",
      "2012-05-13 00:00:00 --------------------------------Empty\n",
      "2012-05-06 00:00:00 --------------------------------Empty\n",
      "2012-05-06 00:00:00 --------------------------------Empty\n",
      "2012-05-05 00:00:00 --------------------------------Empty\n",
      "2012-04-29 00:00:00 --------------------------------Empty\n",
      "2012-04-28 00:00:00 --------------------------------Empty\n",
      "2012-04-28 00:00:00 --------------------------------Empty\n",
      "2012-04-21 00:00:00 --------------------------------Empty\n",
      "2012-04-21 00:00:00 --------------------------------Empty\n",
      "2012-04-21 00:00:00 --------------------------------Empty\n",
      "2012-04-14 00:00:00 --------------------------------Empty\n",
      "2012-04-14 00:00:00 --------------------------------Empty\n",
      "2012-04-14 00:00:00 --------------------------------Empty\n",
      "2012-04-11 00:00:00 --------------------------------Empty\n",
      "2012-04-09 00:00:00 --------------------------------Empty\n",
      "2012-04-08 00:00:00 --------------------------------Empty\n",
      "2012-04-07 00:00:00 --------------------------------Empty\n",
      "2012-04-06 00:00:00 --------------------------------Empty\n",
      "2012-04-01 00:00:00 --------------------------------Empty\n",
      "2012-03-31 00:00:00 --------------------------------Empty\n",
      "2012-03-31 00:00:00 --------------------------------Empty\n",
      "2012-03-24 00:00:00 --------------------------------Empty\n",
      "2012-03-24 00:00:00 --------------------------------Empty\n",
      "2012-03-24 00:00:00 --------------------------------Empty\n",
      "2012-03-21 00:00:00 --------------------------------Empty\n",
      "2012-03-18 00:00:00 --------------------------------Empty\n",
      "2012-03-17 00:00:00 --------------------------------Empty\n",
      "2012-03-11 00:00:00 --------------------------------Empty\n",
      "2012-03-11 00:00:00 --------------------------------Empty\n",
      "2012-03-10 00:00:00 --------------------------------Empty\n",
      "2012-03-03 00:00:00 --------------------------------Empty\n",
      "2012-03-03 00:00:00 --------------------------------Empty\n",
      "2012-03-03 00:00:00 --------------------------------Empty\n",
      "2012-02-26 00:00:00 --------------------------------Empty\n",
      "2012-02-26 00:00:00 --------------------------------Empty\n",
      "2012-02-25 00:00:00 --------------------------------Empty\n",
      "2012-02-11 00:00:00 --------------------------------Empty\n",
      "2012-02-11 00:00:00 --------------------------------Empty\n",
      "2012-02-04 00:00:00 --------------------------------Empty\n",
      "2012-02-04 00:00:00 --------------------------------Empty\n",
      "2012-02-04 00:00:00 --------------------------------Empty\n",
      "2012-02-01 00:00:00 --------------------------------Empty\n",
      "2012-02-01 00:00:00 --------------------------------Empty\n",
      "2012-01-31 00:00:00 --------------------------------Empty\n",
      "2012-01-21 00:00:00 --------------------------------Empty\n",
      "2012-01-21 00:00:00 --------------------------------Empty\n",
      "2012-01-21 00:00:00 --------------------------------Empty\n",
      "2012-01-15 00:00:00 --------------------------------Empty\n",
      "2012-01-15 00:00:00 --------------------------------Empty\n",
      "2012-01-14 00:00:00 --------------------------------Empty\n",
      "2012-01-02 00:00:00 --------------------------------Empty\n",
      "2012-01-02 00:00:00 --------------------------------Empty\n",
      "2011-12-31 00:00:00 --------------------------------Empty\n",
      "2011-12-31 00:00:00 --------------------------------Empty\n",
      "2011-12-31 00:00:00 --------------------------------Empty\n",
      "2011-12-27 00:00:00 --------------------------------Empty\n",
      "2011-12-27 00:00:00 --------------------------------Empty\n",
      "2011-12-21 00:00:00 --------------------------------Empty\n",
      "2011-12-21 00:00:00 --------------------------------Empty\n",
      "2011-12-20 00:00:00 --------------------------------Empty\n",
      "2011-12-18 00:00:00 --------------------------------Empty\n",
      "2011-12-17 00:00:00 --------------------------------Empty\n",
      "2011-12-17 00:00:00 --------------------------------Empty\n",
      "2011-12-10 00:00:00 --------------------------------Empty\n",
      "2011-12-10 00:00:00 --------------------------------Empty\n",
      "2011-12-10 00:00:00 --------------------------------Empty\n",
      "2011-12-03 00:00:00 --------------------------------Empty\n",
      "2011-12-03 00:00:00 --------------------------------Empty\n",
      "2011-12-03 00:00:00 --------------------------------Empty\n",
      "2011-11-27 00:00:00 --------------------------------Empty\n",
      "2011-11-26 00:00:00 --------------------------------Empty\n",
      "2011-11-19 00:00:00 --------------------------------Empty\n",
      "2011-11-19 00:00:00 --------------------------------Empty\n",
      "2011-11-19 00:00:00 --------------------------------Empty\n",
      "2011-11-05 00:00:00 --------------------------------Empty\n",
      "2011-11-05 00:00:00 --------------------------------Empty\n",
      "2011-11-05 00:00:00 --------------------------------Empty\n",
      "2011-10-30 00:00:00 --------------------------------Empty\n",
      "2011-10-29 00:00:00 --------------------------------Empty\n",
      "2011-10-29 00:00:00 --------------------------------Empty\n",
      "2011-10-23 00:00:00 --------------------------------Empty\n",
      "2011-10-22 00:00:00 --------------------------------Empty\n",
      "2011-10-22 00:00:00 --------------------------------Empty\n",
      "2011-10-15 00:00:00 --------------------------------Empty\n",
      "2011-10-15 00:00:00 --------------------------------Empty\n",
      "2011-10-02 00:00:00 --------------------------------Empty\n",
      "2011-10-02 00:00:00 --------------------------------Empty\n",
      "2011-10-01 00:00:00 --------------------------------Empty\n",
      "2011-09-26 00:00:00 --------------------------------Empty\n",
      "2011-09-25 00:00:00 --------------------------------Empty\n",
      "2011-09-24 00:00:00 --------------------------------Empty\n",
      "2011-09-17 00:00:00 --------------------------------Empty\n",
      "2011-09-17 00:00:00 --------------------------------Empty\n",
      "2011-09-17 00:00:00 --------------------------------Empty\n",
      "2011-09-12 00:00:00 --------------------------------Empty\n",
      "2011-09-11 00:00:00 --------------------------------Empty\n",
      "2011-09-10 00:00:00 --------------------------------Empty\n",
      "2011-08-27 00:00:00 --------------------------------Empty\n",
      "2011-08-27 00:00:00 --------------------------------Empty\n",
      "2011-08-27 00:00:00 --------------------------------Empty\n",
      "2011-08-21 00:00:00 --------------------------------Empty\n",
      "2011-08-20 00:00:00 --------------------------------Empty\n",
      "2011-08-20 00:00:00 --------------------------------Empty\n",
      "2011-08-15 00:00:00 --------------------------------Empty\n",
      "2011-08-13 00:00:00 --------------------------------Empty\n",
      "2011-08-13 00:00:00 --------------------------------Empty\n",
      "2011-05-22 00:00:00 --------------------------------Empty\n",
      "2011-05-14 00:00:00 --------------------------------Empty\n",
      "2011-05-08 00:00:00 --------------------------------Empty\n",
      "2011-05-07 00:00:00 --------------------------------Empty\n",
      "2011-05-07 00:00:00 --------------------------------Empty\n",
      "2011-04-30 00:00:00 --------------------------------Empty\n",
      "2011-04-23 00:00:00 --------------------------------Empty\n",
      "2011-04-16 00:00:00 --------------------------------Empty\n",
      "2011-04-10 00:00:00 --------------------------------Empty\n",
      "2011-04-03 00:00:00 --------------------------------Empty\n",
      "2011-04-02 00:00:00 --------------------------------Empty\n",
      "2011-03-19 00:00:00 --------------------------------Empty\n",
      "2011-03-07 00:00:00 --------------------------------Empty\n",
      "2011-03-05 00:00:00 --------------------------------Empty\n",
      "2011-02-26 00:00:00 --------------------------------Empty\n",
      "2011-02-22 00:00:00 --------------------------------Empty\n",
      "2011-02-20 00:00:00 --------------------------------Empty\n",
      "2011-02-15 00:00:00 --------------------------------Empty\n",
      "2011-02-12 00:00:00 --------------------------------Empty\n",
      "2011-02-05 00:00:00 --------------------------------Empty\n",
      "2011-02-02 00:00:00 --------------------------------Empty\n",
      "2011-01-25 00:00:00 --------------------------------Empty\n",
      "2011-01-22 00:00:00 --------------------------------Empty\n",
      "2011-01-15 00:00:00 --------------------------------Empty\n",
      "2011-01-12 00:00:00 --------------------------------Empty\n",
      "2011-01-04 00:00:00 --------------------------------Empty\n",
      "2011-01-01 00:00:00 --------------------------------Empty\n",
      "2010-12-28 00:00:00 --------------------------------Empty\n",
      "2010-12-11 00:00:00 --------------------------------Empty\n",
      "2010-11-27 00:00:00 --------------------------------Empty\n",
      "2010-11-20 00:00:00 --------------------------------Empty\n",
      "2010-11-13 00:00:00 --------------------------------Empty\n",
      "2010-11-10 00:00:00 --------------------------------Empty\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2010-11-06 00:00:00 --------------------------------Empty\n",
      "2010-11-01 00:00:00 --------------------------------Empty\n",
      "2010-10-23 00:00:00 --------------------------------Empty\n",
      "2010-10-17 00:00:00 --------------------------------Empty\n",
      "2010-10-03 00:00:00 --------------------------------Empty\n",
      "2010-09-25 00:00:00 --------------------------------Empty\n",
      "2010-09-19 00:00:00 --------------------------------Empty\n",
      "2010-09-18 00:00:00 --------------------------------Empty\n",
      "2010-09-11 00:00:00 --------------------------------Empty\n",
      "2010-08-28 00:00:00 --------------------------------Empty\n",
      "2010-08-28 00:00:00 --------------------------------Empty\n",
      "2010-08-21 00:00:00 --------------------------------Empty\n",
      "2010-08-14 00:00:00 --------------------------------Empty\n",
      "2010-05-09 00:00:00 --------------------------------Empty\n",
      "2010-05-09 00:00:00 --------------------------------Empty\n",
      "2010-05-09 00:00:00 --------------------------------Empty\n",
      "2010-05-01 00:00:00 --------------------------------Empty\n",
      "2010-05-01 00:00:00 --------------------------------Empty\n",
      "2010-04-25 00:00:00 --------------------------------Empty\n",
      "2010-04-25 00:00:00 --------------------------------Empty\n",
      "2010-04-24 00:00:00 --------------------------------Empty\n",
      "2010-04-17 00:00:00 --------------------------------Empty\n",
      "2010-04-17 00:00:00 --------------------------------Empty\n",
      "2010-04-17 00:00:00 --------------------------------Empty\n",
      "2010-04-11 00:00:00 --------------------------------Empty\n",
      "2010-04-11 00:00:00 --------------------------------Empty\n",
      "2010-04-10 00:00:00 --------------------------------Empty\n",
      "2010-04-04 00:00:00 --------------------------------Empty\n",
      "2010-04-03 00:00:00 --------------------------------Empty\n",
      "2010-04-03 00:00:00 --------------------------------Empty\n",
      "2010-03-28 00:00:00 --------------------------------Empty\n",
      "2010-03-27 00:00:00 --------------------------------Empty\n",
      "2010-03-27 00:00:00 --------------------------------Empty\n",
      "2010-03-24 00:00:00 --------------------------------Empty\n",
      "2010-03-23 00:00:00 --------------------------------Empty\n",
      "2010-03-20 00:00:00 --------------------------------Empty\n",
      "2010-03-20 00:00:00 --------------------------------Empty\n",
      "2010-03-20 00:00:00 --------------------------------Empty\n",
      "2010-03-13 00:00:00 --------------------------------Empty\n",
      "2010-03-13 00:00:00 --------------------------------Empty\n",
      "2010-03-10 00:00:00 --------------------------------Empty\n",
      "2010-03-09 00:00:00 --------------------------------Empty\n",
      "2010-03-06 00:00:00 --------------------------------Empty\n",
      "2010-03-06 00:00:00 --------------------------------Empty\n",
      "2010-02-27 00:00:00 --------------------------------Empty\n",
      "2010-02-27 00:00:00 --------------------------------Empty\n",
      "2010-02-27 00:00:00 --------------------------------Empty\n",
      "2010-02-21 00:00:00 --------------------------------Empty\n",
      "2010-02-21 00:00:00 --------------------------------Empty\n",
      "2010-02-20 00:00:00 --------------------------------Empty\n",
      "2010-02-10 00:00:00 --------------------------------Empty\n",
      "2010-02-10 00:00:00 --------------------------------Empty\n",
      "2010-02-09 00:00:00 --------------------------------Empty\n",
      "2010-02-07 00:00:00 --------------------------------Empty\n",
      "2010-02-06 00:00:00 --------------------------------Empty\n",
      "2010-01-30 00:00:00 --------------------------------Empty\n",
      "2010-01-30 00:00:00 --------------------------------Empty\n",
      "2010-01-30 00:00:00 --------------------------------Empty\n",
      "2010-01-27 00:00:00 --------------------------------Empty\n",
      "2010-01-26 00:00:00 --------------------------------Empty\n",
      "2010-01-26 00:00:00 --------------------------------Empty\n",
      "2010-01-16 00:00:00 --------------------------------Empty\n",
      "2010-01-16 00:00:00 --------------------------------Empty\n",
      "2010-01-09 00:00:00 --------------------------------Empty\n",
      "2009-12-28 00:00:00 --------------------------------Empty\n",
      "2009-12-28 00:00:00 --------------------------------Empty\n",
      "2009-12-28 00:00:00 --------------------------------Empty\n",
      "2009-12-26 00:00:00 --------------------------------Empty\n",
      "2009-12-26 00:00:00 --------------------------------Empty\n",
      "2009-12-26 00:00:00 --------------------------------Empty\n",
      "2009-12-20 00:00:00 --------------------------------Empty\n",
      "2009-12-20 00:00:00 --------------------------------Empty\n",
      "2009-12-16 00:00:00 --------------------------------Empty\n",
      "2009-12-15 00:00:00 --------------------------------Empty\n",
      "2009-12-15 00:00:00 --------------------------------Empty\n",
      "2009-12-12 00:00:00 --------------------------------Empty\n",
      "2009-12-12 00:00:00 --------------------------------Empty\n",
      "2009-12-12 00:00:00 --------------------------------Empty\n",
      "2009-12-05 00:00:00 --------------------------------Empty\n",
      "2009-12-05 00:00:00 --------------------------------Empty\n",
      "2009-12-05 00:00:00 --------------------------------Empty\n",
      "2009-11-29 00:00:00 --------------------------------Empty\n",
      "2009-11-28 00:00:00 --------------------------------Empty\n",
      "2009-11-21 00:00:00 --------------------------------Empty\n",
      "2009-11-21 00:00:00 --------------------------------Empty\n",
      "2009-11-21 00:00:00 --------------------------------Empty\n",
      "2009-11-09 00:00:00 --------------------------------Empty\n",
      "2009-11-07 00:00:00 --------------------------------Empty\n",
      "2009-11-07 00:00:00 --------------------------------Empty\n",
      "2009-11-01 00:00:00 --------------------------------Empty\n",
      "2009-10-31 00:00:00 --------------------------------Empty\n",
      "2009-10-31 00:00:00 --------------------------------Empty\n",
      "2009-10-24 00:00:00 --------------------------------Empty\n",
      "2009-10-24 00:00:00 --------------------------------Empty\n",
      "2009-10-24 00:00:00 --------------------------------Empty\n",
      "2009-10-18 00:00:00 --------------------------------Empty\n",
      "2009-10-17 00:00:00 --------------------------------Empty\n",
      "2009-10-17 00:00:00 --------------------------------Empty\n",
      "2009-10-03 00:00:00 --------------------------------Empty\n",
      "2009-10-03 00:00:00 --------------------------------Empty\n",
      "2009-09-27 00:00:00 --------------------------------Empty\n",
      "2009-09-26 00:00:00 --------------------------------Empty\n",
      "2009-09-26 00:00:00 --------------------------------Empty\n",
      "2009-09-20 00:00:00 --------------------------------Empty\n",
      "2009-09-19 00:00:00 --------------------------------Empty\n",
      "2009-09-19 00:00:00 --------------------------------Empty\n",
      "2009-09-13 00:00:00 --------------------------------Empty\n",
      "2009-09-12 00:00:00 --------------------------------Empty\n",
      "2009-09-12 00:00:00 --------------------------------Empty\n",
      "2009-08-29 00:00:00 --------------------------------Empty\n",
      "2009-08-29 00:00:00 --------------------------------Empty\n",
      "2009-08-29 00:00:00 --------------------------------Empty\n",
      "2009-08-23 00:00:00 --------------------------------Empty\n",
      "2009-08-22 00:00:00 --------------------------------Empty\n",
      "2009-08-22 00:00:00 --------------------------------Empty\n",
      "2009-08-19 00:00:00 --------------------------------Empty\n",
      "2009-08-19 00:00:00 --------------------------------Empty\n",
      "2009-08-18 00:00:00 --------------------------------Empty\n",
      "2009-08-16 00:00:00 --------------------------------Empty\n",
      "2009-08-15 00:00:00 --------------------------------Empty\n",
      "2009-08-15 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-24 00:00:00 --------------------------------Empty\n",
      "2009-05-18 00:00:00 --------------------------------Empty\n",
      "2009-05-17 00:00:00 --------------------------------Empty\n",
      "2009-05-17 00:00:00 --------------------------------Empty\n",
      "2009-05-16 00:00:00 --------------------------------Empty\n",
      "2009-05-16 00:00:00 --------------------------------Empty\n",
      "2009-05-16 00:00:00 --------------------------------Empty\n",
      "2009-05-16 00:00:00 --------------------------------Empty\n",
      "2009-05-16 00:00:00 --------------------------------Empty\n",
      "2009-05-16 00:00:00 --------------------------------Empty\n",
      "2009-05-16 00:00:00 --------------------------------Empty\n",
      "2009-05-13 00:00:00 --------------------------------Empty\n",
      "2009-05-11 00:00:00 --------------------------------Empty\n",
      "2009-05-10 00:00:00 --------------------------------Empty\n",
      "2009-05-10 00:00:00 --------------------------------Empty\n",
      "2009-05-09 00:00:00 --------------------------------Empty\n",
      "2009-05-09 00:00:00 --------------------------------Empty\n",
      "2009-05-09 00:00:00 --------------------------------Empty\n",
      "2009-05-09 00:00:00 --------------------------------Empty\n",
      "2009-05-09 00:00:00 --------------------------------Empty\n",
      "2009-05-09 00:00:00 --------------------------------Empty\n",
      "2009-05-09 00:00:00 --------------------------------Empty\n",
      "2009-05-04 00:00:00 --------------------------------Empty\n",
      "2009-05-03 00:00:00 --------------------------------Empty\n",
      "2009-05-03 00:00:00 --------------------------------Empty\n",
      "2009-05-02 00:00:00 --------------------------------Empty\n",
      "2009-05-02 00:00:00 --------------------------------Empty\n",
      "2009-05-02 00:00:00 --------------------------------Empty\n",
      "2009-05-02 00:00:00 --------------------------------Empty\n",
      "2009-05-02 00:00:00 --------------------------------Empty\n",
      "2009-05-02 00:00:00 --------------------------------Empty\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2009-05-02 00:00:00 --------------------------------Empty\n",
      "2009-04-27 00:00:00 --------------------------------Empty\n",
      "2009-04-26 00:00:00 --------------------------------Empty\n",
      "2009-04-26 00:00:00 --------------------------------Empty\n",
      "2009-04-25 00:00:00 --------------------------------Empty\n",
      "2009-04-25 00:00:00 --------------------------------Empty\n",
      "2009-04-25 00:00:00 --------------------------------Empty\n",
      "2009-04-25 00:00:00 --------------------------------Empty\n",
      "2009-04-25 00:00:00 --------------------------------Empty\n",
      "2009-04-25 00:00:00 --------------------------------Empty\n",
      "2009-04-25 00:00:00 --------------------------------Empty\n",
      "2009-04-22 00:00:00 --------------------------------Empty\n",
      "2009-04-22 00:00:00 --------------------------------Empty\n",
      "2009-04-21 00:00:00 --------------------------------Empty\n",
      "2009-04-19 00:00:00 --------------------------------Empty\n",
      "2009-04-19 00:00:00 --------------------------------Empty\n",
      "2009-04-18 00:00:00 --------------------------------Empty\n",
      "2009-04-18 00:00:00 --------------------------------Empty\n",
      "2009-04-18 00:00:00 --------------------------------Empty\n",
      "2009-04-18 00:00:00 --------------------------------Empty\n",
      "2009-04-18 00:00:00 --------------------------------Empty\n",
      "2009-04-12 00:00:00 --------------------------------Empty\n",
      "2009-04-12 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-11 00:00:00 --------------------------------Empty\n",
      "2009-04-05 00:00:00 --------------------------------Empty\n",
      "2009-04-05 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-04-04 00:00:00 --------------------------------Empty\n",
      "2009-03-22 00:00:00 --------------------------------Empty\n",
      "2009-03-22 00:00:00 --------------------------------Empty\n",
      "2009-03-22 00:00:00 --------------------------------Empty\n",
      "2009-03-21 00:00:00 --------------------------------Empty\n",
      "2009-03-21 00:00:00 --------------------------------Empty\n",
      "2009-03-21 00:00:00 --------------------------------Empty\n",
      "2009-03-21 00:00:00 --------------------------------Empty\n",
      "2009-03-21 00:00:00 --------------------------------Empty\n",
      "2009-03-21 00:00:00 --------------------------------Empty\n",
      "2009-03-21 00:00:00 --------------------------------Empty\n",
      "2009-03-16 00:00:00 --------------------------------Empty\n",
      "2009-03-15 00:00:00 --------------------------------Empty\n",
      "2009-03-15 00:00:00 --------------------------------Empty\n",
      "2009-03-14 00:00:00 --------------------------------Empty\n",
      "2009-03-14 00:00:00 --------------------------------Empty\n",
      "2009-03-14 00:00:00 --------------------------------Empty\n",
      "2009-03-14 00:00:00 --------------------------------Empty\n",
      "2009-03-14 00:00:00 --------------------------------Empty\n",
      "2009-03-14 00:00:00 --------------------------------Empty\n",
      "2009-03-14 00:00:00 --------------------------------Empty\n",
      "2009-03-11 00:00:00 --------------------------------Empty\n",
      "2009-03-07 00:00:00 --------------------------------Empty\n",
      "2009-03-04 00:00:00 --------------------------------Empty\n",
      "2009-03-04 00:00:00 --------------------------------Empty\n",
      "2009-03-04 00:00:00 --------------------------------Empty\n",
      "2009-03-04 00:00:00 --------------------------------Empty\n",
      "2009-03-04 00:00:00 --------------------------------Empty\n",
      "2009-03-04 00:00:00 --------------------------------Empty\n",
      "2009-03-04 00:00:00 --------------------------------Empty\n",
      "2009-03-03 00:00:00 --------------------------------Empty\n",
      "2009-03-03 00:00:00 --------------------------------Empty\n",
      "2009-03-03 00:00:00 --------------------------------Empty\n",
      "2009-03-01 00:00:00 --------------------------------Empty\n",
      "2009-03-01 00:00:00 --------------------------------Empty\n",
      "2009-03-01 00:00:00 --------------------------------Empty\n",
      "2009-03-01 00:00:00 --------------------------------Empty\n",
      "2009-02-28 00:00:00 --------------------------------Empty\n",
      "2009-02-28 00:00:00 --------------------------------Empty\n",
      "2009-02-28 00:00:00 --------------------------------Empty\n",
      "2009-02-28 00:00:00 --------------------------------Empty\n",
      "2009-02-23 00:00:00 --------------------------------Empty\n",
      "2009-02-22 00:00:00 --------------------------------Empty\n",
      "2009-02-22 00:00:00 --------------------------------Empty\n",
      "2009-02-22 00:00:00 --------------------------------Empty\n",
      "2009-02-21 00:00:00 --------------------------------Empty\n",
      "2009-02-21 00:00:00 --------------------------------Empty\n",
      "2009-02-21 00:00:00 --------------------------------Empty\n",
      "2009-02-21 00:00:00 --------------------------------Empty\n",
      "2009-02-21 00:00:00 --------------------------------Empty\n",
      "2009-02-21 00:00:00 --------------------------------Empty\n",
      "2009-02-18 00:00:00 --------------------------------Empty\n",
      "2009-02-14 00:00:00 --------------------------------Empty\n",
      "2009-02-08 00:00:00 --------------------------------Empty\n",
      "2009-02-08 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-07 00:00:00 --------------------------------Empty\n",
      "2009-02-01 00:00:00 --------------------------------Empty\n",
      "2009-02-01 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-31 00:00:00 --------------------------------Empty\n",
      "2009-01-28 00:00:00 --------------------------------Empty\n",
      "2009-01-28 00:00:00 --------------------------------Empty\n",
      "2009-01-28 00:00:00 --------------------------------Empty\n",
      "2009-01-28 00:00:00 --------------------------------Empty\n",
      "2009-01-28 00:00:00 --------------------------------Empty\n",
      "2009-01-28 00:00:00 --------------------------------Empty\n",
      "2009-01-27 00:00:00 --------------------------------Empty\n",
      "2009-01-27 00:00:00 --------------------------------Empty\n",
      "2009-01-27 00:00:00 --------------------------------Empty\n",
      "2009-01-27 00:00:00 --------------------------------Empty\n",
      "2009-01-19 00:00:00 --------------------------------Empty\n",
      "2009-01-18 00:00:00 --------------------------------Empty\n",
      "2009-01-18 00:00:00 --------------------------------Empty\n",
      "2009-01-17 00:00:00 --------------------------------Empty\n",
      "2009-01-17 00:00:00 --------------------------------Empty\n",
      "2009-01-17 00:00:00 --------------------------------Empty\n",
      "2009-01-17 00:00:00 --------------------------------Empty\n",
      "2009-01-17 00:00:00 --------------------------------Empty\n",
      "2009-01-17 00:00:00 --------------------------------Empty\n",
      "2009-01-17 00:00:00 --------------------------------Empty\n",
      "2009-01-14 00:00:00 --------------------------------Empty\n",
      "2009-01-11 00:00:00 --------------------------------Empty\n",
      "2009-01-11 00:00:00 --------------------------------Empty\n",
      "2009-01-10 00:00:00 --------------------------------Empty\n",
      "2009-01-10 00:00:00 --------------------------------Empty\n",
      "2009-01-10 00:00:00 --------------------------------Empty\n",
      "2009-01-10 00:00:00 --------------------------------Empty\n",
      "2009-01-10 00:00:00 --------------------------------Empty\n",
      "2009-01-10 00:00:00 --------------------------------Empty\n",
      "2008-12-30 00:00:00 --------------------------------Empty\n",
      "2008-12-29 00:00:00 --------------------------------Empty\n",
      "2008-12-28 00:00:00 --------------------------------Empty\n",
      "2008-12-28 00:00:00 --------------------------------Empty\n",
      "2008-12-28 00:00:00 --------------------------------Empty\n",
      "2008-12-28 00:00:00 --------------------------------Empty\n",
      "2008-12-28 00:00:00 --------------------------------Empty\n",
      "2008-12-28 00:00:00 --------------------------------Empty\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2008-12-28 00:00:00 --------------------------------Empty\n",
      "2008-12-28 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-26 00:00:00 --------------------------------Empty\n",
      "2008-12-22 00:00:00 --------------------------------Empty\n",
      "2008-12-21 00:00:00 --------------------------------Empty\n",
      "2008-12-21 00:00:00 --------------------------------Empty\n",
      "2008-12-21 00:00:00 --------------------------------Empty\n",
      "2008-12-20 00:00:00 --------------------------------Empty\n",
      "2008-12-20 00:00:00 --------------------------------Empty\n",
      "2008-12-20 00:00:00 --------------------------------Empty\n",
      "2008-12-20 00:00:00 --------------------------------Empty\n",
      "2008-12-20 00:00:00 --------------------------------Empty\n",
      "2008-12-14 00:00:00 --------------------------------Empty\n",
      "2008-12-14 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-13 00:00:00 --------------------------------Empty\n",
      "2008-12-08 00:00:00 --------------------------------Empty\n",
      "2008-12-07 00:00:00 --------------------------------Empty\n",
      "2008-12-07 00:00:00 --------------------------------Empty\n",
      "2008-12-06 00:00:00 --------------------------------Empty\n",
      "2008-12-06 00:00:00 --------------------------------Empty\n",
      "2008-12-06 00:00:00 --------------------------------Empty\n",
      "2008-12-06 00:00:00 --------------------------------Empty\n",
      "2008-12-06 00:00:00 --------------------------------Empty\n",
      "2008-12-06 00:00:00 --------------------------------Empty\n",
      "2008-12-06 00:00:00 --------------------------------Empty\n",
      "2008-12-01 00:00:00 --------------------------------Empty\n",
      "2008-11-30 00:00:00 --------------------------------Empty\n",
      "2008-11-30 00:00:00 --------------------------------Empty\n",
      "2008-11-30 00:00:00 --------------------------------Empty\n",
      "2008-11-30 00:00:00 --------------------------------Empty\n",
      "2008-11-29 00:00:00 --------------------------------Empty\n",
      "2008-11-29 00:00:00 --------------------------------Empty\n",
      "2008-11-29 00:00:00 --------------------------------Empty\n",
      "2008-11-29 00:00:00 --------------------------------Empty\n",
      "2008-11-29 00:00:00 --------------------------------Empty\n",
      "2008-11-24 00:00:00 --------------------------------Empty\n",
      "2008-11-23 00:00:00 --------------------------------Empty\n",
      "2008-11-23 00:00:00 --------------------------------Empty\n",
      "2008-11-22 00:00:00 --------------------------------Empty\n",
      "2008-11-22 00:00:00 --------------------------------Empty\n",
      "2008-11-22 00:00:00 --------------------------------Empty\n",
      "2008-11-22 00:00:00 --------------------------------Empty\n",
      "2008-11-22 00:00:00 --------------------------------Empty\n",
      "2008-11-22 00:00:00 --------------------------------Empty\n",
      "2008-11-22 00:00:00 --------------------------------Empty\n",
      "2008-11-16 00:00:00 --------------------------------Empty\n",
      "2008-11-16 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-15 00:00:00 --------------------------------Empty\n",
      "2008-11-09 00:00:00 --------------------------------Empty\n",
      "2008-11-09 00:00:00 --------------------------------Empty\n",
      "2008-11-09 00:00:00 --------------------------------Empty\n",
      "2008-11-09 00:00:00 --------------------------------Empty\n",
      "2008-11-08 00:00:00 --------------------------------Empty\n",
      "2008-11-08 00:00:00 --------------------------------Empty\n",
      "2008-11-08 00:00:00 --------------------------------Empty\n",
      "2008-11-08 00:00:00 --------------------------------Empty\n",
      "2008-11-08 00:00:00 --------------------------------Empty\n",
      "2008-11-08 00:00:00 --------------------------------Empty\n",
      "2008-11-03 00:00:00 --------------------------------Empty\n",
      "2008-11-02 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-11-01 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-29 00:00:00 --------------------------------Empty\n",
      "2008-10-28 00:00:00 --------------------------------Empty\n",
      "2008-10-26 00:00:00 --------------------------------Empty\n",
      "2008-10-26 00:00:00 --------------------------------Empty\n",
      "2008-10-26 00:00:00 --------------------------------Empty\n",
      "2008-10-26 00:00:00 --------------------------------Empty\n",
      "2008-10-26 00:00:00 --------------------------------Empty\n",
      "2008-10-26 00:00:00 --------------------------------Empty\n",
      "2008-10-25 00:00:00 --------------------------------Empty\n",
      "2008-10-25 00:00:00 --------------------------------Empty\n",
      "2008-10-25 00:00:00 --------------------------------Empty\n",
      "2008-10-25 00:00:00 --------------------------------Empty\n",
      "2008-10-20 00:00:00 --------------------------------Empty\n",
      "2008-10-19 00:00:00 --------------------------------Empty\n",
      "2008-10-19 00:00:00 --------------------------------Empty\n",
      "2008-10-18 00:00:00 --------------------------------Empty\n",
      "2008-10-18 00:00:00 --------------------------------Empty\n",
      "2008-10-18 00:00:00 --------------------------------Empty\n",
      "2008-10-18 00:00:00 --------------------------------Empty\n",
      "2008-10-18 00:00:00 --------------------------------Empty\n",
      "2008-10-18 00:00:00 --------------------------------Empty\n",
      "2008-10-18 00:00:00 --------------------------------Empty\n",
      "2008-10-05 00:00:00 --------------------------------Empty\n",
      "2008-10-05 00:00:00 --------------------------------Empty\n",
      "2008-10-05 00:00:00 --------------------------------Empty\n",
      "2008-10-05 00:00:00 --------------------------------Empty\n",
      "2008-10-05 00:00:00 --------------------------------Empty\n",
      "2008-10-05 00:00:00 --------------------------------Empty\n",
      "2008-10-04 00:00:00 --------------------------------Empty\n",
      "2008-10-04 00:00:00 --------------------------------Empty\n",
      "2008-10-04 00:00:00 --------------------------------Empty\n",
      "2008-10-04 00:00:00 --------------------------------Empty\n",
      "2008-09-28 00:00:00 --------------------------------Empty\n",
      "2008-09-28 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-27 00:00:00 --------------------------------Empty\n",
      "2008-09-21 00:00:00 --------------------------------Empty\n",
      "2008-09-21 00:00:00 --------------------------------Empty\n",
      "2008-09-21 00:00:00 --------------------------------Empty\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2008-09-21 00:00:00 --------------------------------Empty\n",
      "2008-09-21 00:00:00 --------------------------------Empty\n",
      "2008-09-20 00:00:00 --------------------------------Empty\n",
      "2008-09-20 00:00:00 --------------------------------Empty\n",
      "2008-09-20 00:00:00 --------------------------------Empty\n",
      "2008-09-20 00:00:00 --------------------------------Empty\n",
      "2008-09-20 00:00:00 --------------------------------Empty\n",
      "2008-09-15 00:00:00 --------------------------------Empty\n",
      "2008-09-14 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-09-13 00:00:00 --------------------------------Empty\n",
      "2008-08-31 00:00:00 --------------------------------Empty\n",
      "2008-08-31 00:00:00 --------------------------------Empty\n",
      "2008-08-31 00:00:00 --------------------------------Empty\n",
      "2008-08-30 00:00:00 --------------------------------Empty\n",
      "2008-08-30 00:00:00 --------------------------------Empty\n",
      "2008-08-30 00:00:00 --------------------------------Empty\n",
      "2008-08-30 00:00:00 --------------------------------Empty\n",
      "2008-08-30 00:00:00 --------------------------------Empty\n",
      "2008-08-30 00:00:00 --------------------------------Empty\n",
      "2008-08-25 00:00:00 --------------------------------Empty\n",
      "2008-08-24 00:00:00 --------------------------------Empty\n",
      "2008-08-24 00:00:00 --------------------------------Empty\n",
      "2008-08-23 00:00:00 --------------------------------Empty\n",
      "2008-08-23 00:00:00 --------------------------------Empty\n",
      "2008-08-23 00:00:00 --------------------------------Empty\n",
      "2008-08-23 00:00:00 --------------------------------Empty\n",
      "2008-08-23 00:00:00 --------------------------------Empty\n",
      "2008-08-23 00:00:00 --------------------------------Empty\n",
      "2008-08-23 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-17 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n",
      "2008-08-16 00:00:00 --------------------------------Empty\n"
     ]
    }
   ],
   "source": [
    "#Stores last 5 games' performance of a team vs an opponent at home - to factor in home advantage\n",
    "matches_epl['home_opponent_score'] = matches_epl.apply(lambda x: get_last_five_opponent(x['home_team_api_id'],x['date'], x['away_team_api_id']),axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>id</th>\n",
       "      <th>season</th>\n",
       "      <th>date</th>\n",
       "      <th>match_api_id</th>\n",
       "      <th>home_team_api_id</th>\n",
       "      <th>away_team_api_id</th>\n",
       "      <th>home_team_goal</th>\n",
       "      <th>away_team_goal</th>\n",
       "      <th>home_rating</th>\n",
       "      <th>away_rating</th>\n",
       "      <th>result</th>\n",
       "      <th>home_last_five_score</th>\n",
       "      <th>away_last_five_score</th>\n",
       "      <th>home_opponent_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>2832</td>\n",
       "      <td>4561</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-02-07</td>\n",
       "      <td>1988952</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>82.381385</td>\n",
       "      <td>77.005119</td>\n",
       "      <td>Draw</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>2542</td>\n",
       "      <td>4271</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-04-18</td>\n",
       "      <td>1724304</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>82.011039</td>\n",
       "      <td>79.283838</td>\n",
       "      <td>Win</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>2041</td>\n",
       "      <td>3770</td>\n",
       "      <td>2013</td>\n",
       "      <td>2014-01-19</td>\n",
       "      <td>1474923</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>81.766811</td>\n",
       "      <td>78.591017</td>\n",
       "      <td>Win</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1432</th>\n",
       "      <td>1892</td>\n",
       "      <td>3621</td>\n",
       "      <td>2012</td>\n",
       "      <td>2012-10-28</td>\n",
       "      <td>1229187</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>82.227273</td>\n",
       "      <td>80.727273</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1662</th>\n",
       "      <td>1301</td>\n",
       "      <td>3030</td>\n",
       "      <td>2011</td>\n",
       "      <td>2012-02-05</td>\n",
       "      <td>1025473</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>82.045455</td>\n",
       "      <td>82.050000</td>\n",
       "      <td>Draw</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>859</td>\n",
       "      <td>2588</td>\n",
       "      <td>2010</td>\n",
       "      <td>2011-03-01</td>\n",
       "      <td>839993</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>83.727273</td>\n",
       "      <td>82.136364</td>\n",
       "      <td>Win</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2545</th>\n",
       "      <td>419</td>\n",
       "      <td>2148</td>\n",
       "      <td>2009</td>\n",
       "      <td>2009-11-08</td>\n",
       "      <td>658728</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>84.227273</td>\n",
       "      <td>81.454545</td>\n",
       "      <td>Win</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2992</th>\n",
       "      <td>339</td>\n",
       "      <td>2068</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-09-21</td>\n",
       "      <td>489091</td>\n",
       "      <td>8455</td>\n",
       "      <td>10260</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.500000</td>\n",
       "      <td>81.772727</td>\n",
       "      <td>Draw</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      index    id  season       date  match_api_id  home_team_api_id  \\\n",
       "131    2832  4561    2015 2016-02-07       1988952              8455   \n",
       "439    2542  4271    2014 2015-04-18       1724304              8455   \n",
       "922    2041  3770    2013 2014-01-19       1474923              8455   \n",
       "1432   1892  3621    2012 2012-10-28       1229187              8455   \n",
       "1662   1301  3030    2011 2012-02-05       1025473              8455   \n",
       "2003    859  2588    2010 2011-03-01        839993              8455   \n",
       "2545    419  2148    2009 2009-11-08        658728              8455   \n",
       "2992    339  2068    2008 2008-09-21        489091              8455   \n",
       "\n",
       "      away_team_api_id  home_team_goal  away_team_goal  home_rating  \\\n",
       "131              10260               1               1    82.381385   \n",
       "439              10260               1               0    82.011039   \n",
       "922              10260               3               1    81.766811   \n",
       "1432             10260               2               3    82.227273   \n",
       "1662             10260               3               3    82.045455   \n",
       "2003             10260               2               1    83.727273   \n",
       "2545             10260               1               0    84.227273   \n",
       "2992             10260               1               1    84.500000   \n",
       "\n",
       "      away_rating  result  home_last_five_score  away_last_five_score  \\\n",
       "131     77.005119    Draw                     4                     4   \n",
       "439     79.283838     Win                     4                     9   \n",
       "922     78.591017     Win                     7                     5   \n",
       "1432    80.727273  Defeat                     7                     9   \n",
       "1662    82.050000    Draw                     0                     2   \n",
       "2003    82.136364     Win                     7                     7   \n",
       "2545    81.454545     Win                     8                     3   \n",
       "2992    81.772727    Draw                     7                     0   \n",
       "\n",
       "      home_opponent_score  \n",
       "131                     3  \n",
       "439                     3  \n",
       "922                     1  \n",
       "1432                    2  \n",
       "1662                    2  \n",
       "2003                    1  \n",
       "2545                    0  \n",
       "2992                    0  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches_epl[(matches_epl['home_team_api_id']==8455) & (matches_epl['away_team_api_id']==10260)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>index</th>\n",
       "      <th>id</th>\n",
       "      <th>season</th>\n",
       "      <th>date</th>\n",
       "      <th>match_api_id</th>\n",
       "      <th>home_team_api_id</th>\n",
       "      <th>away_team_api_id</th>\n",
       "      <th>home_team_goal</th>\n",
       "      <th>away_team_goal</th>\n",
       "      <th>home_rating</th>\n",
       "      <th>away_rating</th>\n",
       "      <th>result</th>\n",
       "      <th>home_last_five_score</th>\n",
       "      <th>away_last_five_score</th>\n",
       "      <th>home_opponent_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2938</td>\n",
       "      <td>4667</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016-04-18</td>\n",
       "      <td>1989048</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>76.765152</td>\n",
       "      <td>77.916780</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-3</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>2579</td>\n",
       "      <td>4308</td>\n",
       "      <td>2014</td>\n",
       "      <td>2015-05-09</td>\n",
       "      <td>1724341</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>74.036580</td>\n",
       "      <td>76.157969</td>\n",
       "      <td>Win</td>\n",
       "      <td>-2</td>\n",
       "      <td>0</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>789</th>\n",
       "      <td>2196</td>\n",
       "      <td>3925</td>\n",
       "      <td>2013</td>\n",
       "      <td>2014-04-26</td>\n",
       "      <td>1475093</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>75.015476</td>\n",
       "      <td>77.694697</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1152</th>\n",
       "      <td>1828</td>\n",
       "      <td>3557</td>\n",
       "      <td>2012</td>\n",
       "      <td>2013-05-12</td>\n",
       "      <td>1229501</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>75.500000</td>\n",
       "      <td>80.409091</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1752</th>\n",
       "      <td>1206</td>\n",
       "      <td>2935</td>\n",
       "      <td>2011</td>\n",
       "      <td>2011-12-11</td>\n",
       "      <td>1024952</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>74.954545</td>\n",
       "      <td>81.136364</td>\n",
       "      <td>Win</td>\n",
       "      <td>-5</td>\n",
       "      <td>11</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2264</th>\n",
       "      <td>878</td>\n",
       "      <td>2607</td>\n",
       "      <td>2010</td>\n",
       "      <td>2010-08-21</td>\n",
       "      <td>839832</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>73.954545</td>\n",
       "      <td>79.409091</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-11</td>\n",
       "      <td>-2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2361</th>\n",
       "      <td>629</td>\n",
       "      <td>2358</td>\n",
       "      <td>2009</td>\n",
       "      <td>2010-03-20</td>\n",
       "      <td>659128</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>73.227273</td>\n",
       "      <td>76.590909</td>\n",
       "      <td>Defeat</td>\n",
       "      <td>-1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2962</th>\n",
       "      <td>369</td>\n",
       "      <td>2098</td>\n",
       "      <td>2008</td>\n",
       "      <td>2008-10-19</td>\n",
       "      <td>489121</td>\n",
       "      <td>10194</td>\n",
       "      <td>8586</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>69.090909</td>\n",
       "      <td>79.590909</td>\n",
       "      <td>Win</td>\n",
       "      <td>-5</td>\n",
       "      <td>-4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      index    id  season       date  match_api_id  home_team_api_id  \\\n",
       "46     2938  4667    2015 2016-04-18       1989048             10194   \n",
       "407    2579  4308    2014 2015-05-09       1724341             10194   \n",
       "789    2196  3925    2013 2014-04-26       1475093             10194   \n",
       "1152   1828  3557    2012 2013-05-12       1229501             10194   \n",
       "1752   1206  2935    2011 2011-12-11       1024952             10194   \n",
       "2264    878  2607    2010 2010-08-21        839832             10194   \n",
       "2361    629  2358    2009 2010-03-20        659128             10194   \n",
       "2962    369  2098    2008 2008-10-19        489121             10194   \n",
       "\n",
       "      away_team_api_id  home_team_goal  away_team_goal  home_rating  \\\n",
       "46                8586               0               4    76.765152   \n",
       "407               8586               3               0    74.036580   \n",
       "789               8586               0               1    75.015476   \n",
       "1152              8586               1               2    75.500000   \n",
       "1752              8586               2               1    74.954545   \n",
       "2264              8586               1               2    73.954545   \n",
       "2361              8586               1               2    73.227273   \n",
       "2962              8586               2               1    69.090909   \n",
       "\n",
       "      away_rating  result  home_last_five_score  away_last_five_score  \\\n",
       "46      77.916780  Defeat                    -3                     8   \n",
       "407     76.157969     Win                    -2                     0   \n",
       "789     77.694697  Defeat                     2                     3   \n",
       "1152    80.409091  Defeat                    -1                     3   \n",
       "1752    81.136364     Win                    -5                    11   \n",
       "2264    79.409091  Defeat                   -11                    -2   \n",
       "2361    76.590909  Defeat                    -1                     5   \n",
       "2962    79.590909     Win                    -5                    -4   \n",
       "\n",
       "      home_opponent_score  \n",
       "46                      1  \n",
       "407                    -3  \n",
       "789                    -1  \n",
       "1152                    0  \n",
       "1752                   -1  \n",
       "2264                    0  \n",
       "2361                    1  \n",
       "2962                    0  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches_epl[(matches_epl['home_team_api_id']==10194) & (matches_epl['away_team_api_id']==8586)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches_epl['final_rating'] = matches_epl['home_rating'] - matches_epl['away_rating']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "matches_epl.to_csv('Matches_EPL_processed.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}