4_Football Predictions.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "ad48b366",
   "metadata": {},
   "source": [
    "# Football Prediction using Random Forest Classifier\n",
    "## By:\n",
    "## I007 Bhavya Bavishi\n",
    "## I012 Nehaal Choudhary\n",
    "## I020 Aum Ghag\n",
    "## Batch: B1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5ed20198",
   "metadata": {},
   "source": [
    "### Importing Required Libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "40c13c99",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3713e335",
   "metadata": {},
   "source": [
    "Importing Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "2ebd562c",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches = pd.read_csv(\"matches1.csv\", index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "b1ae6969",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>comp</th>\n",
       "      <th>round</th>\n",
       "      <th>day</th>\n",
       "      <th>venue</th>\n",
       "      <th>result</th>\n",
       "      <th>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>opponent</th>\n",
       "      <th>...</th>\n",
       "      <th>referee</th>\n",
       "      <th>match report</th>\n",
       "      <th>notes</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-08-05</td>\n",
       "      <td>20:00</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Matchweek 1</td>\n",
       "      <td>Fri</td>\n",
       "      <td>Away</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>...</td>\n",
       "      <td>Anthony Taylor</td>\n",
       "      <td>Match Report</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-08-13</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Matchweek 2</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Leicester City</td>\n",
       "      <td>...</td>\n",
       "      <td>Darren England</td>\n",
       "      <td>Match Report</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-08-20</td>\n",
       "      <td>17:30</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Matchweek 3</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Away</td>\n",
       "      <td>W</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>...</td>\n",
       "      <td>Craig Pawson</td>\n",
       "      <td>Match Report</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-08-27</td>\n",
       "      <td>17:30</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Matchweek 4</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>...</td>\n",
       "      <td>Jarred Gillett</td>\n",
       "      <td>Match Report</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>19:30</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>Matchweek 5</td>\n",
       "      <td>Wed</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Aston Villa</td>\n",
       "      <td>...</td>\n",
       "      <td>Robert Jones</td>\n",
       "      <td>Match Report</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date   time            comp        round  day venue result   gf   ga  \\\n",
       "0  2022-08-05  20:00  Premier League  Matchweek 1  Fri  Away      W  2.0  0.0   \n",
       "1  2022-08-13  15:00  Premier League  Matchweek 2  Sat  Home      W  4.0  2.0   \n",
       "2  2022-08-20  17:30  Premier League  Matchweek 3  Sat  Away      W  3.0  0.0   \n",
       "3  2022-08-27  17:30  Premier League  Matchweek 4  Sat  Home      W  2.0  1.0   \n",
       "4  2022-08-31  19:30  Premier League  Matchweek 5  Wed  Home      W  2.0  1.0   \n",
       "\n",
       "         opponent  ...         referee  match report  notes    sh  sot  dist  \\\n",
       "0  Crystal Palace  ...  Anthony Taylor  Match Report    NaN  10.0  2.0  14.6   \n",
       "1  Leicester City  ...  Darren England  Match Report    NaN  19.0  7.0  13.0   \n",
       "2     Bournemouth  ...    Craig Pawson  Match Report    NaN  14.0  6.0  14.8   \n",
       "3          Fulham  ...  Jarred Gillett  Match Report    NaN  22.0  8.0  15.5   \n",
       "4     Aston Villa  ...    Robert Jones  Match Report    NaN  22.0  8.0  16.3   \n",
       "\n",
       "    pk pkatt  season     team  \n",
       "0  0.0   0.0    2023  Arsenal  \n",
       "1  0.0   0.0    2023  Arsenal  \n",
       "2  0.0   0.0    2023  Arsenal  \n",
       "3  0.0   0.0    2023  Arsenal  \n",
       "4  0.0   0.0    2023  Arsenal  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "3c2c7841",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(17308, 26)"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "01f49771",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date             object\n",
       "time             object\n",
       "comp             object\n",
       "round            object\n",
       "day              object\n",
       "venue            object\n",
       "result           object\n",
       "gf              float64\n",
       "ga              float64\n",
       "opponent         object\n",
       "xg              float64\n",
       "xga             float64\n",
       "poss            float64\n",
       "attendance      float64\n",
       "captain          object\n",
       "formation        object\n",
       "referee          object\n",
       "match report     object\n",
       "notes           float64\n",
       "sh              float64\n",
       "sot             float64\n",
       "dist            float64\n",
       "pk              float64\n",
       "pkatt           float64\n",
       "season            int64\n",
       "team             object\n",
       "dtype: object"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "146e9844",
   "metadata": {},
   "source": [
    "Dropping columns which are not required"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "1e9b1749",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches = matches.drop(['notes', 'referee', 'match report', 'formation', 'captain', 'attendance', 'poss', 'comp', 'time', 'round'], 1)\n",
    "matches[\"date\"] = pd.to_datetime(matches[\"date\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "74498837",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Tottenham Hotspur           866\n",
       "Everton                     866\n",
       "Chelsea                     866\n",
       "Arsenal                     865\n",
       "Manchester United           865\n",
       "Liverpool                   864\n",
       "Manchester City             827\n",
       "Newcastle United            789\n",
       "Aston Villa                 752\n",
       "West Ham United             751\n",
       "Southampton                 600\n",
       "Fulham                      599\n",
       "Sunderland                  532\n",
       "West Bromwich Albion        494\n",
       "Leicester City              448\n",
       "Blackburn Rovers            418\n",
       "Bolton Wanderers            418\n",
       "Crystal Palace              409\n",
       "Middlesbrough               380\n",
       "Stoke City                  380\n",
       "Wolverhampton Wanderers     334\n",
       "Burnley                     304\n",
       "Wigan Athletic              304\n",
       "Charlton Athletic           266\n",
       "Birmingham City             266\n",
       "Swansea City                266\n",
       "Watford                     266\n",
       "Portsmouth                  266\n",
       "Norwich City                266\n",
       "Leeds United                257\n",
       "Bournemouth                 220\n",
       "Brighton and Hove Albion    218\n",
       "Hull City                   190\n",
       "Derby County                114\n",
       "Reading                     114\n",
       "Sheffield United            114\n",
       "Queens Park Rangers         114\n",
       "Cardiff City                 76\n",
       "Huddersfield Town            76\n",
       "Ipswich Town                 76\n",
       "Brentford                    68\n",
       "Coventry City                38\n",
       "Bradford City                38\n",
       "Blackpool                    38\n",
       "Nottingham Forest            30\n",
       "Name: team, dtype: int64"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches['team'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "139db74a",
   "metadata": {},
   "source": [
    "Classifying W as 1 and L as 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "2bf67f62",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches[\"target\"] = (matches[\"result\"] == \"W\").astype(\"int\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "394f326e",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>day</th>\n",
       "      <th>venue</th>\n",
       "      <th>result</th>\n",
       "      <th>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>opponent</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>team</th>\n",
       "      <th>target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-08-05</td>\n",
       "      <td>Fri</td>\n",
       "      <td>Away</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-08-13</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Leicester City</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-08-20</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Away</td>\n",
       "      <td>W</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-08-27</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>Wed</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Aston Villa</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  day venue result   gf   ga        opponent   xg  xga    sh  sot  \\\n",
       "0 2022-08-05  Fri  Away      W  2.0  0.0  Crystal Palace  1.0  1.2  10.0  2.0   \n",
       "1 2022-08-13  Sat  Home      W  4.0  2.0  Leicester City  2.7  0.5  19.0  7.0   \n",
       "2 2022-08-20  Sat  Away      W  3.0  0.0     Bournemouth  1.3  0.3  14.0  6.0   \n",
       "3 2022-08-27  Sat  Home      W  2.0  1.0          Fulham  2.6  0.8  22.0  8.0   \n",
       "4 2022-08-31  Wed  Home      W  2.0  1.0     Aston Villa  2.4  0.4  22.0  8.0   \n",
       "\n",
       "   dist   pk  pkatt  season     team  target  \n",
       "0  14.6  0.0    0.0    2023  Arsenal       1  \n",
       "1  13.0  0.0    0.0    2023  Arsenal       1  \n",
       "2  14.8  0.0    0.0    2023  Arsenal       1  \n",
       "3  15.5  0.0    0.0    2023  Arsenal       1  \n",
       "4  16.3  0.0    0.0    2023  Arsenal       1  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d309396c",
   "metadata": {},
   "source": [
    "Adding new numeric columns as to fit in the model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "c39b7fc9",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches[\"venue_code\"] = matches[\"venue\"].astype(\"category\").cat.codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "f95df9b3",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches[\"opp_code\"] = matches[\"opponent\"].astype(\"category\").cat.codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "d23713db",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches[\"day_code\"] = matches[\"date\"].dt.dayofweek"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "a6ea5848",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches['team_code'] = matches['team'].astype('category').cat.codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "f0cdb9c6",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>day</th>\n",
       "      <th>venue</th>\n",
       "      <th>result</th>\n",
       "      <th>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>opponent</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>...</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>team</th>\n",
       "      <th>target</th>\n",
       "      <th>venue_code</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-08-05</td>\n",
       "      <td>Fri</td>\n",
       "      <td>Away</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-08-13</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Leicester City</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-08-20</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Away</td>\n",
       "      <td>W</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-08-27</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>...</td>\n",
       "      <td>15.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>Wed</td>\n",
       "      <td>Home</td>\n",
       "      <td>W</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Aston Villa</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>...</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2001-04-28</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Away</td>\n",
       "      <td>L</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Everton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>Bradford City</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2001-05-01</td>\n",
       "      <td>Tue</td>\n",
       "      <td>Home</td>\n",
       "      <td>L</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>Bradford City</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2001-05-05</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Home</td>\n",
       "      <td>D</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Middlesbrough</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>Bradford City</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2001-05-13</td>\n",
       "      <td>Sun</td>\n",
       "      <td>Away</td>\n",
       "      <td>L</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Leeds United</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>Bradford City</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2001-05-19</td>\n",
       "      <td>Sat</td>\n",
       "      <td>Away</td>\n",
       "      <td>D</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Coventry City</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>Bradford City</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17308 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date  day venue result   gf   ga        opponent   xg  xga    sh  \\\n",
       "0  2022-08-05  Fri  Away      W  2.0  0.0  Crystal Palace  1.0  1.2  10.0   \n",
       "1  2022-08-13  Sat  Home      W  4.0  2.0  Leicester City  2.7  0.5  19.0   \n",
       "2  2022-08-20  Sat  Away      W  3.0  0.0     Bournemouth  1.3  0.3  14.0   \n",
       "3  2022-08-27  Sat  Home      W  2.0  1.0          Fulham  2.6  0.8  22.0   \n",
       "4  2022-08-31  Wed  Home      W  2.0  1.0     Aston Villa  2.4  0.4  22.0   \n",
       "..        ...  ...   ...    ...  ...  ...             ...  ...  ...   ...   \n",
       "33 2001-04-28  Sat  Away      L  1.0  2.0         Everton  NaN  NaN   NaN   \n",
       "34 2001-05-01  Tue  Home      L  0.0  2.0       Liverpool  NaN  NaN   NaN   \n",
       "35 2001-05-05  Sat  Home      D  1.0  1.0   Middlesbrough  NaN  NaN   NaN   \n",
       "36 2001-05-13  Sun  Away      L  1.0  6.0    Leeds United  NaN  NaN   NaN   \n",
       "37 2001-05-19  Sat  Away      D  0.0  0.0   Coventry City  NaN  NaN   NaN   \n",
       "\n",
       "    ...  dist   pk  pkatt  season           team target  venue_code  opp_code  \\\n",
       "0   ...  14.6  0.0    0.0    2023        Arsenal      1           0        15   \n",
       "1   ...  13.0  0.0    0.0    2023        Arsenal      1           1        23   \n",
       "2   ...  14.8  0.0    0.0    2023        Arsenal      1           0         6   \n",
       "3   ...  15.5  0.0    0.0    2023        Arsenal      1           1        18   \n",
       "4   ...  16.3  0.0    0.0    2023        Arsenal      1           1         1   \n",
       "..  ...   ...  ...    ...     ...            ...    ...         ...       ...   \n",
       "33  ...   NaN  0.0    NaN    2001  Bradford City      0           0        17   \n",
       "34  ...   NaN  0.0    NaN    2001  Bradford City      0           1        24   \n",
       "35  ...   NaN  0.0    NaN    2001  Bradford City      0           1        27   \n",
       "36  ...   NaN  0.0    NaN    2001  Bradford City      0           0        22   \n",
       "37  ...   NaN  0.0    NaN    2001  Bradford City      0           0        14   \n",
       "\n",
       "    day_code  team_code  \n",
       "0          4          0  \n",
       "1          5          0  \n",
       "2          5          0  \n",
       "3          5          0  \n",
       "4          2          0  \n",
       "..       ...        ...  \n",
       "33         5          7  \n",
       "34         1          7  \n",
       "35         5          7  \n",
       "36         6          7  \n",
       "37         5          7  \n",
       "\n",
       "[17308 rows x 21 columns]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "0542f3ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date          datetime64[ns]\n",
       "day                   object\n",
       "venue                 object\n",
       "result                object\n",
       "gf                   float64\n",
       "ga                   float64\n",
       "opponent              object\n",
       "xg                   float64\n",
       "xga                  float64\n",
       "sh                   float64\n",
       "sot                  float64\n",
       "dist                 float64\n",
       "pk                   float64\n",
       "pkatt                float64\n",
       "season                 int64\n",
       "team                  object\n",
       "target                 int64\n",
       "venue_code              int8\n",
       "opp_code                int8\n",
       "day_code               int64\n",
       "team_code               int8\n",
       "dtype: object"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "eec8dfdf",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "matches = matches.drop(['day', 'venue', 'result', 'opponent', 'team'], 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "1242a355",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>target</th>\n",
       "      <th>venue_code</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-08-05</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-08-13</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-08-20</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-08-27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date   gf   ga   xg  xga    sh  sot  dist   pk  pkatt  season  target  \\\n",
       "0 2022-08-05  2.0  0.0  1.0  1.2  10.0  2.0  14.6  0.0    0.0    2023       1   \n",
       "1 2022-08-13  4.0  2.0  2.7  0.5  19.0  7.0  13.0  0.0    0.0    2023       1   \n",
       "2 2022-08-20  3.0  0.0  1.3  0.3  14.0  6.0  14.8  0.0    0.0    2023       1   \n",
       "3 2022-08-27  2.0  1.0  2.6  0.8  22.0  8.0  15.5  0.0    0.0    2023       1   \n",
       "4 2022-08-31  2.0  1.0  2.4  0.4  22.0  8.0  16.3  0.0    0.0    2023       1   \n",
       "\n",
       "   venue_code  opp_code  day_code  team_code  \n",
       "0           0        15         4          0  \n",
       "1           1        23         5          0  \n",
       "2           0         6         5          0  \n",
       "3           1        18         5          0  \n",
       "4           1         1         2          0  "
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "31271165",
   "metadata": {},
   "outputs": [],
   "source": [
    "train = matches[matches[\"date\"] < '2023-01-01']\n",
    "test = matches[matches[\"date\"] > '2023-01-01']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "da2bd93d",
   "metadata": {},
   "outputs": [],
   "source": [
    "train = train.drop('date', 1)\n",
    "test = test.drop('date', 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "ff96e1c5",
   "metadata": {},
   "outputs": [],
   "source": [
    "train = train.apply(lambda iterator: ((iterator - iterator.mean())/iterator.std()).round(2))\n",
    "test = test.apply(lambda iterator: ((iterator - iterator.mean())/iterator.std()).round(2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "65bbcfb8",
   "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>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>target</th>\n",
       "      <th>venue_code</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.53</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>-0.40</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>-0.46</td>\n",
       "      <td>-0.88</td>\n",
       "      <td>-1.01</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.29</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>-1.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.14</td>\n",
       "      <td>0.53</td>\n",
       "      <td>1.75</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.16</td>\n",
       "      <td>-1.53</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.29</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.34</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>-1.29</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.75</td>\n",
       "      <td>-0.94</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.29</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.27</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.53</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>1.62</td>\n",
       "      <td>-0.66</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1.57</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.29</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.53</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>1.37</td>\n",
       "      <td>-1.17</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1.57</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.29</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>-1.41</td>\n",
       "      <td>-1.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>-0.27</td>\n",
       "      <td>0.53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>-1.08</td>\n",
       "      <td>0.53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>-1.98</td>\n",
       "      <td>-1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>-0.27</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>-0.27</td>\n",
       "      <td>3.76</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>0.90</td>\n",
       "      <td>-1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>-1.08</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.67</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17048 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      gf    ga    xg   xga    sh   sot  dist    pk  pkatt  season  target  \\\n",
       "0   0.53 -1.08 -0.40 -0.15 -0.46 -0.88 -1.01 -0.31  -0.36    1.74    1.29   \n",
       "1   2.14  0.53  1.75 -1.04  1.20  1.16 -1.53 -0.31  -0.36    1.74    1.29   \n",
       "2   1.34 -1.08 -0.02 -1.29  0.28  0.75 -0.94 -0.31  -0.36    1.74    1.29   \n",
       "3   0.53 -0.27  1.62 -0.66  1.75  1.57 -0.71 -0.31  -0.36    1.74    1.29   \n",
       "4   0.53 -0.27  1.37 -1.17  1.75  1.57 -0.45 -0.31  -0.36    1.74    1.29   \n",
       "..   ...   ...   ...   ...   ...   ...   ...   ...    ...     ...     ...   \n",
       "33 -0.27  0.53   NaN   NaN   NaN   NaN   NaN -0.31    NaN   -1.65   -0.78   \n",
       "34 -1.08  0.53   NaN   NaN   NaN   NaN   NaN -0.31    NaN   -1.65   -0.78   \n",
       "35 -0.27 -0.27   NaN   NaN   NaN   NaN   NaN -0.31    NaN   -1.65   -0.78   \n",
       "36 -0.27  3.76   NaN   NaN   NaN   NaN   NaN -0.31    NaN   -1.65   -0.78   \n",
       "37 -1.08 -1.08   NaN   NaN   NaN   NaN   NaN -0.31    NaN   -1.65   -0.78   \n",
       "\n",
       "    venue_code  opp_code  day_code  team_code  \n",
       "0         -1.0     -0.60     -0.25      -1.72  \n",
       "1          1.0      0.00      0.32      -1.72  \n",
       "2         -1.0     -1.27      0.32      -1.72  \n",
       "3          1.0     -0.37      0.32      -1.72  \n",
       "4          1.0     -1.65     -1.41      -1.72  \n",
       "..         ...       ...       ...        ...  \n",
       "33        -1.0     -0.45      0.32      -1.20  \n",
       "34         1.0      0.08     -1.98      -1.20  \n",
       "35         1.0      0.30      0.32      -1.20  \n",
       "36        -1.0     -0.07      0.90      -1.20  \n",
       "37        -1.0     -0.67      0.32      -1.20  \n",
       "\n",
       "[17048 rows x 15 columns]"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "65c5056b",
   "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>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>target</th>\n",
       "      <th>venue_code</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>-1.04</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>-0.51</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.54</td>\n",
       "      <td>-2.01</td>\n",
       "      <td>-1.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.60</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>0.47</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.36</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.28</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1.41</td>\n",
       "      <td>1.00</td>\n",
       "      <td>-1.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1.42</td>\n",
       "      <td>0.60</td>\n",
       "      <td>2.08</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>2.36</td>\n",
       "      <td>0.51</td>\n",
       "      <td>-0.90</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.28</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.38</td>\n",
       "      <td>1.00</td>\n",
       "      <td>-1.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>-1.04</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.49</td>\n",
       "      <td>-0.84</td>\n",
       "      <td>0.25</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>0.39</td>\n",
       "      <td>-1.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>-0.22</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.72</td>\n",
       "      <td>1.99</td>\n",
       "      <td>1.42</td>\n",
       "      <td>0.93</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>0.39</td>\n",
       "      <td>-1.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>-1.04</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>-0.51</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.47</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.38</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>-1.04</td>\n",
       "      <td>0.60</td>\n",
       "      <td>-1.13</td>\n",
       "      <td>0.60</td>\n",
       "      <td>-1.00</td>\n",
       "      <td>-1.74</td>\n",
       "      <td>0.80</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>-1.41</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1.42</td>\n",
       "      <td>1.42</td>\n",
       "      <td>1.22</td>\n",
       "      <td>1.09</td>\n",
       "      <td>1.05</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.93</td>\n",
       "      <td>3.25</td>\n",
       "      <td>2.79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.41</td>\n",
       "      <td>0.39</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>-1.04</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>-1.38</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>1.44</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1.65</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>-0.22</td>\n",
       "      <td>2.24</td>\n",
       "      <td>-1.38</td>\n",
       "      <td>1.46</td>\n",
       "      <td>-1.56</td>\n",
       "      <td>-1.29</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0.39</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>256 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      gf    ga    xg   xga    sh   sot  dist    pk  pkatt  season  target  \\\n",
       "23 -1.04 -1.04 -0.39 -0.51  0.87  0.06  0.05 -0.31  -0.33     NaN   -0.78   \n",
       "25  0.60 -1.04  0.47  0.23  0.31  0.51  0.36 -0.31  -0.33     NaN    1.28   \n",
       "26  1.42  0.60  2.08 -1.25  2.36  0.51 -0.90 -0.31  -0.33     NaN    1.28   \n",
       "28 -1.04 -0.22 -0.64  0.35  0.49 -0.84  0.25 -0.31  -0.33     NaN   -0.78   \n",
       "29 -0.22 -0.22  0.23  0.72  1.99  1.42  0.93 -0.31  -0.33     NaN   -0.78   \n",
       "..   ...   ...   ...   ...   ...   ...   ...   ...    ...     ...     ...   \n",
       "34 -1.04 -1.04 -0.51 -0.76  0.87  0.06  1.47 -0.31  -0.33     NaN   -0.78   \n",
       "35 -1.04  0.60 -1.13  0.60 -1.00 -1.74  0.80 -0.31  -0.33     NaN   -0.78   \n",
       "36  1.42  1.42  1.22  1.09  1.05  0.97  0.93  3.25   2.79     NaN   -0.78   \n",
       "37 -1.04 -0.22 -1.38 -0.02 -0.63 -0.39  1.44 -0.31  -0.33     NaN   -0.78   \n",
       "38 -0.22  2.24 -1.38  1.46 -1.56 -1.29  0.32 -0.31  -0.33     NaN   -0.78   \n",
       "\n",
       "    venue_code  opp_code  day_code  team_code  \n",
       "23         1.0      0.54     -2.01      -1.67  \n",
       "25        -1.0      1.41      1.00      -1.67  \n",
       "26         1.0      0.38      1.00      -1.67  \n",
       "28        -1.0     -0.33      0.39      -1.67  \n",
       "29         1.0     -1.04      0.39      -1.67  \n",
       "..         ...       ...       ...        ...  \n",
       "34        -1.0      0.38      1.00       1.10  \n",
       "35         1.0     -1.04     -1.41       1.10  \n",
       "36         1.0      1.41      0.39       1.10  \n",
       "37        -1.0      1.65      1.00       1.10  \n",
       "38         1.0      0.30      0.39       1.10  \n",
       "\n",
       "[256 rows x 15 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3f2e7fdd",
   "metadata": {},
   "source": [
    "Dividing data into Train and Test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "c01f5430",
   "metadata": {},
   "outputs": [],
   "source": [
    "# train = matches[matches[\"date\"] < '2023-01-01']\n",
    "# test = matches[matches[\"date\"] > '2023-01-01']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "1aec5abf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(17048, 15)"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "8e5fa6a3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(256, 15)"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "96bae869",
   "metadata": {},
   "outputs": [],
   "source": [
    "predictors = [\"venue_code\", \"opp_code\", \"day_code\", 'team_code']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "ee935a84",
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped_matches = matches.groupby(\"team_code\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "2326d5cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>target</th>\n",
       "      <th>venue_code</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2000-08-19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2000-08-27</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2000-09-06</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2000-09-09</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000-09-16</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2023-03-12</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2023-03-18</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2023-04-01</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>22.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2023-04-04</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>20.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2023-04-08</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>752 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date   gf   ga   xg  xga    sh  sot  dist   pk  pkatt  season  \\\n",
       "0  2000-08-19  0.0  0.0  NaN  NaN   NaN  NaN   NaN  0.0    NaN    2001   \n",
       "1  2000-08-27  1.0  1.0  NaN  NaN   NaN  NaN   NaN  0.0    NaN    2001   \n",
       "2  2000-09-06  1.0  3.0  NaN  NaN   NaN  NaN   NaN  0.0    NaN    2001   \n",
       "3  2000-09-09  2.0  1.0  NaN  NaN   NaN  NaN   NaN  0.0    NaN    2001   \n",
       "4  2000-09-16  2.0  0.0  NaN  NaN   NaN  NaN   NaN  1.0    NaN    2001   \n",
       "..        ...  ...  ...  ...  ...   ...  ...   ...  ...    ...     ...   \n",
       "28 2023-03-12  1.0  1.0  1.5  2.1  12.0  4.0  13.3  0.0    0.0    2023   \n",
       "29 2023-03-18  3.0  0.0  3.5  1.3  20.0  9.0  13.9  0.0    0.0    2023   \n",
       "30 2023-04-01  2.0  0.0  0.9  2.1   5.0  2.0  22.5  0.0    0.0    2023   \n",
       "31 2023-04-04  2.0  1.0  1.0  0.5  15.0  5.0  20.3  0.0    0.0    2023   \n",
       "32 2023-04-08  2.0  0.0  1.4  0.2   8.0  3.0  12.0  0.0    0.0    2023   \n",
       "\n",
       "    target  venue_code  opp_code  day_code  team_code  \n",
       "0        0           0        23         5          1  \n",
       "1        0           1        13         6          1  \n",
       "2        0           0        24         2          1  \n",
       "3        1           0        21         5          1  \n",
       "4        1           1         7         5          1  \n",
       "..     ...         ...       ...       ...        ...  \n",
       "28       0           0        42         6          1  \n",
       "29       1           1         6         5          1  \n",
       "30       1           0        13         5          1  \n",
       "31       1           0        23         1          1  \n",
       "32       1           1        30         5          1  \n",
       "\n",
       "[752 rows x 16 columns]"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "group = grouped_matches.get_group(1).sort_values(\"date\")\n",
    "group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "026fcac5",
   "metadata": {},
   "outputs": [],
   "source": [
    "def rolling_averages(group, cols, new_cols):\n",
    "#     group = group.sort_values(\"date\")\n",
    "    rolling_stats = group[cols].rolling(3, closed='left').mean()\n",
    "    group[new_cols] = rolling_stats\n",
    "    group = group.dropna(subset=new_cols)\n",
    "    return group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "80f638e6",
   "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>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>season</th>\n",
       "      <th>...</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "      <th>gf_rolling</th>\n",
       "      <th>ga_rolling</th>\n",
       "      <th>sh_rolling</th>\n",
       "      <th>sot_rolling</th>\n",
       "      <th>dist_rolling</th>\n",
       "      <th>pk_rolling</th>\n",
       "      <th>pkatt_rolling</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.53</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>1.62</td>\n",
       "      <td>-0.66</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1.57</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.72</td>\n",
       "      <td>1.336667</td>\n",
       "      <td>-0.543333</td>\n",
       "      <td>0.340000</td>\n",
       "      <td>0.343333</td>\n",
       "      <td>-1.160000</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.53</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>1.37</td>\n",
       "      <td>-1.17</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1.57</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>-1.41</td>\n",
       "      <td>-1.72</td>\n",
       "      <td>1.336667</td>\n",
       "      <td>-0.273333</td>\n",
       "      <td>1.076667</td>\n",
       "      <td>1.160000</td>\n",
       "      <td>-1.060000</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-0.27</td>\n",
       "      <td>1.34</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.64</td>\n",
       "      <td>-0.47</td>\n",
       "      <td>0.31</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>...</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.90</td>\n",
       "      <td>-1.72</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>-0.540000</td>\n",
       "      <td>1.260000</td>\n",
       "      <td>1.296667</td>\n",
       "      <td>-0.700000</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1.34</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>0.23</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1.16</td>\n",
       "      <td>0.17</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.12</td>\n",
       "      <td>0.90</td>\n",
       "      <td>-1.72</td>\n",
       "      <td>0.263333</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>1.380000</td>\n",
       "      <td>0.890000</td>\n",
       "      <td>-0.283333</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.34</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>1.37</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1.98</td>\n",
       "      <td>0.31</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.74</td>\n",
       "      <td>...</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-1.72</td>\n",
       "      <td>0.533333</td>\n",
       "      <td>-0.003333</td>\n",
       "      <td>0.826667</td>\n",
       "      <td>0.753333</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0.53</td>\n",
       "      <td>0.53</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.01</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>0.97</td>\n",
       "      <td>...</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.32</td>\n",
       "      <td>1.36</td>\n",
       "      <td>-0.270000</td>\n",
       "      <td>-0.273333</td>\n",
       "      <td>-0.276667</td>\n",
       "      <td>-0.336667</td>\n",
       "      <td>-0.133333</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>-0.27</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>0.61</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>-0.88</td>\n",
       "      <td>0.80</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>0.97</td>\n",
       "      <td>...</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.32</td>\n",
       "      <td>1.36</td>\n",
       "      <td>-0.003333</td>\n",
       "      <td>-0.273333</td>\n",
       "      <td>0.030000</td>\n",
       "      <td>0.070000</td>\n",
       "      <td>0.043333</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>-0.27</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>0.36</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>-1.29</td>\n",
       "      <td>-2.45</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>0.97</td>\n",
       "      <td>...</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.32</td>\n",
       "      <td>1.36</td>\n",
       "      <td>-0.003333</td>\n",
       "      <td>-0.543333</td>\n",
       "      <td>-0.340000</td>\n",
       "      <td>-0.066667</td>\n",
       "      <td>0.316667</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>-1.08</td>\n",
       "      <td>0.53</td>\n",
       "      <td>-1.42</td>\n",
       "      <td>1.12</td>\n",
       "      <td>-1.02</td>\n",
       "      <td>-1.29</td>\n",
       "      <td>2.34</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>0.97</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>0.90</td>\n",
       "      <td>1.36</td>\n",
       "      <td>-0.003333</td>\n",
       "      <td>-0.543333</td>\n",
       "      <td>-0.403333</td>\n",
       "      <td>-0.473333</td>\n",
       "      <td>-0.546667</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.53</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.75</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.95</td>\n",
       "      <td>2.44</td>\n",
       "      <td>0.81</td>\n",
       "      <td>...</td>\n",
       "      <td>1.43</td>\n",
       "      <td>-2.56</td>\n",
       "      <td>-0.75</td>\n",
       "      <td>-0.540000</td>\n",
       "      <td>-0.543333</td>\n",
       "      <td>-0.773333</td>\n",
       "      <td>-1.153333</td>\n",
       "      <td>0.230000</td>\n",
       "      <td>-0.31</td>\n",
       "      <td>-0.36</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4117 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      gf    ga    xg   xga    sh   sot  dist    pk  pkatt  season  ...  \\\n",
       "3   0.53 -0.27  1.62 -0.66  1.75  1.57 -0.71 -0.31  -0.36    1.74  ...   \n",
       "4   0.53 -0.27  1.37 -1.17  1.75  1.57 -0.45 -0.31  -0.36    1.74  ...   \n",
       "5  -0.27  1.34 -0.02  0.23  0.64 -0.47  0.31 -0.31  -0.36    1.74  ...   \n",
       "7   1.34 -1.08  0.23 -1.04  0.09  1.16  0.17 -0.31  -0.36    1.74  ...   \n",
       "8   1.34 -0.27  1.37  0.36  1.75  1.98  0.31 -0.31  -0.36    1.74  ...   \n",
       "..   ...   ...   ...   ...   ...   ...   ...   ...    ...     ...  ...   \n",
       "39  0.53  0.53 -0.02 -0.02  0.09  0.75  0.01 -0.31  -0.36    0.97  ...   \n",
       "40 -0.27 -1.08 -0.78  0.61 -0.65 -0.88  0.80 -0.31  -0.36    0.97  ...   \n",
       "41 -0.27 -1.08  0.36 -0.15 -0.65 -1.29 -2.45 -0.31  -0.36    0.97  ...   \n",
       "42 -1.08  0.53 -1.42  1.12 -1.02 -1.29  2.34 -0.31  -0.36    0.97  ...   \n",
       "0   0.53 -0.27   NaN   NaN  0.64  0.75   NaN  2.95   2.44    0.81  ...   \n",
       "\n",
       "    opp_code  day_code  team_code  gf_rolling  ga_rolling  sh_rolling  \\\n",
       "3      -0.37      0.32      -1.72    1.336667   -0.543333    0.340000   \n",
       "4      -1.65     -1.41      -1.72    1.336667   -0.273333    1.076667   \n",
       "5       0.23      0.90      -1.72    0.800000   -0.540000    1.260000   \n",
       "7      -1.12      0.90      -1.72    0.263333    0.266667    1.380000   \n",
       "8       1.20      0.32      -1.72    0.533333   -0.003333    0.826667   \n",
       "..       ...       ...        ...         ...         ...         ...   \n",
       "39      0.08      0.32       1.36   -0.270000   -0.273333   -0.276667   \n",
       "40      0.38      0.32       1.36   -0.003333   -0.273333    0.030000   \n",
       "41      1.20      0.32       1.36   -0.003333   -0.543333   -0.340000   \n",
       "42     -0.60      0.90       1.36   -0.003333   -0.543333   -0.403333   \n",
       "0       1.43     -2.56      -0.75   -0.540000   -0.543333   -0.773333   \n",
       "\n",
       "    sot_rolling  dist_rolling  pk_rolling  pkatt_rolling  \n",
       "3      0.343333     -1.160000       -0.31          -0.36  \n",
       "4      1.160000     -1.060000       -0.31          -0.36  \n",
       "5      1.296667     -0.700000       -0.31          -0.36  \n",
       "7      0.890000     -0.283333       -0.31          -0.36  \n",
       "8      0.753333      0.010000       -0.31          -0.36  \n",
       "..          ...           ...         ...            ...  \n",
       "39    -0.336667     -0.133333       -0.31          -0.36  \n",
       "40     0.070000      0.043333       -0.31          -0.36  \n",
       "41    -0.066667      0.316667       -0.31          -0.36  \n",
       "42    -0.473333     -0.546667       -0.31          -0.36  \n",
       "0     -1.153333      0.230000       -0.31          -0.36  \n",
       "\n",
       "[4117 rows x 22 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cols = [\"gf\", \"ga\", \"sh\", \"sot\", \"dist\", \"pk\", \"pkatt\"]\n",
    "new_cols = [f\"{c}_rolling\" for c in cols]\n",
    "\n",
    "rolling_averages(train, cols, new_cols)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b33e2b4d",
   "metadata": {},
   "source": [
    "Using groupby"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "1bd297f3",
   "metadata": {
    "scrolled": false
   },
   "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></th>\n",
       "      <th>date</th>\n",
       "      <th>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>...</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "      <th>gf_rolling</th>\n",
       "      <th>ga_rolling</th>\n",
       "      <th>sh_rolling</th>\n",
       "      <th>sot_rolling</th>\n",
       "      <th>dist_rolling</th>\n",
       "      <th>pk_rolling</th>\n",
       "      <th>pkatt_rolling</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>team_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">0</th>\n",
       "      <th>3</th>\n",
       "      <td>2022-08-27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>14.333333</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>14.133333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>18.333333</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>14.433333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-09-04</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>19.333333</td>\n",
       "      <td>7.333333</td>\n",
       "      <td>15.533333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-09-18</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>13.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>18.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>6.333333</td>\n",
       "      <td>16.800000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2022-10-01</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>17.700000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">44</th>\n",
       "      <th>42</th>\n",
       "      <td>2019-04-24</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>44</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>16.333333</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>16.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2019-04-27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>44</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>16.800000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2019-05-04</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>18.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>44</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>15.700000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>44</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>13.666667</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>16.900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2011-08-13</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>44</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>12.333333</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>15.700000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4317 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   date   gf   ga   xg  xga    sh  sot  dist   pk  pkatt  ...  \\\n",
       "team_code                                                                 ...   \n",
       "0         3  2022-08-27  2.0  1.0  2.6  0.8  22.0  8.0  15.5  0.0    0.0  ...   \n",
       "          4  2022-08-31  2.0  1.0  2.4  0.4  22.0  8.0  16.3  0.0    0.0  ...   \n",
       "          5  2022-09-04  1.0  3.0  1.3  1.5  16.0  3.0  18.6  0.0    0.0  ...   \n",
       "          7  2022-09-18  3.0  0.0  1.5  0.5  13.0  7.0  18.2  0.0    0.0  ...   \n",
       "          8  2022-10-01  3.0  1.0  2.4  1.6  22.0  9.0  18.6  0.0    0.0  ...   \n",
       "...                 ...  ...  ...  ...  ...   ...  ...   ...  ...    ...  ...   \n",
       "44        42 2019-04-24  3.0  1.0  1.2  0.8  11.0  3.0  16.3  0.0    0.0  ...   \n",
       "          43 2019-04-27  2.0  1.0  2.0  0.8  11.0  3.0  16.2  0.0    0.0  ...   \n",
       "          44 2019-05-04  1.0  0.0  2.0  0.5  19.0  6.0  18.2  0.0    0.0  ...   \n",
       "          45 2019-05-12  0.0  2.0  1.3  1.6   7.0  2.0  12.7  0.0    0.0  ...   \n",
       "          0  2011-08-13  2.0  1.0  NaN  NaN   NaN  NaN   NaN  0.0    NaN  ...   \n",
       "\n",
       "              opp_code  day_code  team_code  gf_rolling  ga_rolling  \\\n",
       "team_code                                                             \n",
       "0         3         18         5          0    3.000000    0.666667   \n",
       "          4          1         2          0    3.000000    1.000000   \n",
       "          5         26         6          0    2.333333    0.666667   \n",
       "          7          8         6          0    1.666667    1.666667   \n",
       "          8         39         5          0    2.000000    1.333333   \n",
       "...                ...       ...        ...         ...         ...   \n",
       "44        42         0         2         44    1.000000    1.333333   \n",
       "          43        40         5         44    1.333333    1.333333   \n",
       "          44        18         5         44    1.666667    0.666667   \n",
       "          45        24         6         44    2.000000    0.666667   \n",
       "          0          3         5         44    1.000000    1.000000   \n",
       "\n",
       "              sh_rolling  sot_rolling  dist_rolling  pk_rolling  pkatt_rolling  \n",
       "team_code                                                                       \n",
       "0         3    14.333333     5.000000     14.133333         0.0            0.0  \n",
       "          4    18.333333     7.000000     14.433333         0.0            0.0  \n",
       "          5    19.333333     7.333333     15.533333         0.0            0.0  \n",
       "          7    20.000000     6.333333     16.800000         0.0            0.0  \n",
       "          8    17.000000     6.000000     17.700000         0.0            0.0  \n",
       "...                  ...          ...           ...         ...            ...  \n",
       "44        42   16.333333     3.000000     16.333333         0.0            0.0  \n",
       "          43   17.000000     3.333333     16.800000         0.0            0.0  \n",
       "          44   15.000000     3.666667     15.700000         0.0            0.0  \n",
       "          45   13.666667     4.000000     16.900000         0.0            0.0  \n",
       "          0    12.333333     3.666667     15.700000         0.0            0.0  \n",
       "\n",
       "[4317 rows x 23 columns]"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches_rolling = matches.groupby(\"team_code\").apply(lambda x: rolling_averages(x, cols, new_cols))\n",
    "matches_rolling"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "e19ce968",
   "metadata": {},
   "outputs": [],
   "source": [
    "# matches_rolling[matches_rolling['team_code']==4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "id": "a93bef3b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>gf</th>\n",
       "      <th>ga</th>\n",
       "      <th>xg</th>\n",
       "      <th>xga</th>\n",
       "      <th>sh</th>\n",
       "      <th>sot</th>\n",
       "      <th>dist</th>\n",
       "      <th>pk</th>\n",
       "      <th>pkatt</th>\n",
       "      <th>...</th>\n",
       "      <th>opp_code</th>\n",
       "      <th>day_code</th>\n",
       "      <th>team_code</th>\n",
       "      <th>gf_rolling</th>\n",
       "      <th>ga_rolling</th>\n",
       "      <th>sh_rolling</th>\n",
       "      <th>sot_rolling</th>\n",
       "      <th>dist_rolling</th>\n",
       "      <th>pk_rolling</th>\n",
       "      <th>pkatt_rolling</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-08-27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>14.333333</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>14.133333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>18.333333</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>14.433333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-09-04</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>19.333333</td>\n",
       "      <td>7.333333</td>\n",
       "      <td>15.533333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-09-18</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>13.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>18.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>6.333333</td>\n",
       "      <td>16.800000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2022-10-01</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>39</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>17.700000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2019-04-24</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>44</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>16.333333</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>16.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2019-04-27</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>44</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>16.800000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2019-05-04</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>18.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>44</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>15.700000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>44</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>13.666667</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>16.900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2011-08-13</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>44</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>12.333333</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>15.700000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4317 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date   gf   ga   xg  xga    sh  sot  dist   pk  pkatt  ...  opp_code  \\\n",
       "3  2022-08-27  2.0  1.0  2.6  0.8  22.0  8.0  15.5  0.0    0.0  ...        18   \n",
       "4  2022-08-31  2.0  1.0  2.4  0.4  22.0  8.0  16.3  0.0    0.0  ...         1   \n",
       "5  2022-09-04  1.0  3.0  1.3  1.5  16.0  3.0  18.6  0.0    0.0  ...        26   \n",
       "7  2022-09-18  3.0  0.0  1.5  0.5  13.0  7.0  18.2  0.0    0.0  ...         8   \n",
       "8  2022-10-01  3.0  1.0  2.4  1.6  22.0  9.0  18.6  0.0    0.0  ...        39   \n",
       "..        ...  ...  ...  ...  ...   ...  ...   ...  ...    ...  ...       ...   \n",
       "42 2019-04-24  3.0  1.0  1.2  0.8  11.0  3.0  16.3  0.0    0.0  ...         0   \n",
       "43 2019-04-27  2.0  1.0  2.0  0.8  11.0  3.0  16.2  0.0    0.0  ...        40   \n",
       "44 2019-05-04  1.0  0.0  2.0  0.5  19.0  6.0  18.2  0.0    0.0  ...        18   \n",
       "45 2019-05-12  0.0  2.0  1.3  1.6   7.0  2.0  12.7  0.0    0.0  ...        24   \n",
       "0  2011-08-13  2.0  1.0  NaN  NaN   NaN  NaN   NaN  0.0    NaN  ...         3   \n",
       "\n",
       "    day_code  team_code  gf_rolling  ga_rolling  sh_rolling  sot_rolling  \\\n",
       "3          5          0    3.000000    0.666667   14.333333     5.000000   \n",
       "4          2          0    3.000000    1.000000   18.333333     7.000000   \n",
       "5          6          0    2.333333    0.666667   19.333333     7.333333   \n",
       "7          6          0    1.666667    1.666667   20.000000     6.333333   \n",
       "8          5          0    2.000000    1.333333   17.000000     6.000000   \n",
       "..       ...        ...         ...         ...         ...          ...   \n",
       "42         2         44    1.000000    1.333333   16.333333     3.000000   \n",
       "43         5         44    1.333333    1.333333   17.000000     3.333333   \n",
       "44         5         44    1.666667    0.666667   15.000000     3.666667   \n",
       "45         6         44    2.000000    0.666667   13.666667     4.000000   \n",
       "0          5         44    1.000000    1.000000   12.333333     3.666667   \n",
       "\n",
       "    dist_rolling  pk_rolling  pkatt_rolling  \n",
       "3      14.133333         0.0            0.0  \n",
       "4      14.433333         0.0            0.0  \n",
       "5      15.533333         0.0            0.0  \n",
       "7      16.800000         0.0            0.0  \n",
       "8      17.700000         0.0            0.0  \n",
       "..           ...         ...            ...  \n",
       "42     16.333333         0.0            0.0  \n",
       "43     16.800000         0.0            0.0  \n",
       "44     15.700000         0.0            0.0  \n",
       "45     16.900000         0.0            0.0  \n",
       "0      15.700000         0.0            0.0  \n",
       "\n",
       "[4317 rows x 23 columns]"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches_rolling = matches_rolling.droplevel('team_code')\n",
    "matches_rolling"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "46e59793",
   "metadata": {},
   "source": [
    "Re-indexing the dataset to avoid mismatches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "id": "9b23f124",
   "metadata": {},
   "outputs": [],
   "source": [
    "matches_rolling.index = range(matches_rolling.shape[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c43b395a",
   "metadata": {},
   "source": [
    "Creating Random Forest Classifier Model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "a495b0cf",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.ensemble import RandomForestClassifier\n",
    "from sklearn.metrics import accuracy_score, precision_score\n",
    "rf = RandomForestClassifier(n_estimators=40, min_samples_split=10, random_state=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "515b90e0",
   "metadata": {},
   "source": [
    "Defining Function to make predictions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "id": "e40a03dc",
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_predictions(data, predictors):\n",
    "    train = data[data[\"date\"] < '2023-01-01']\n",
    "    test = data[data[\"date\"] > '2023-01-01']\n",
    "    rf.fit(train[predictors], train[\"target\"])\n",
    "    preds = rf.predict(test[predictors])\n",
    "    combined = pd.DataFrame(dict(actual=test[\"target\"], predicted=preds), index=test.index)\n",
    "    error = precision_score(test[\"target\"], preds, average='micro')\n",
    "    acc = accuracy_score(test[\"target\"], preds)\n",
    "    return combined, error, acc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "id": "2ef125d0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.66015625"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined, prec_score, acc = make_predictions(matches_rolling, predictors + new_cols)\n",
    "prec_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "b4e095cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "66.015625"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "acc * 100"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "553fdb89",
   "metadata": {},
   "source": [
    "After the Analysis, the model gave us a precision score and accuracy of 64.84375"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "e6d9e669",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined = combined.merge(matches_rolling[[\"date\", \"team_code\", \"opp_code\"]], left_index=True, right_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "58c75cc7",
   "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>actual</th>\n",
       "      <th>predicted</th>\n",
       "      <th>date</th>\n",
       "      <th>team_code</th>\n",
       "      <th>opp_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01-03</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2023-01-15</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2023-01-22</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-02-04</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-02-11</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-02-15</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-02-18</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2023-02-25</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2023-03-01</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-03-04</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-03-12</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-03-19</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-01</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2023-01-04</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2023-01-13</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     actual  predicted       date  team_code  opp_code\n",
       "13        0          1 2023-01-03          0        28\n",
       "14        1          0 2023-01-15          0        39\n",
       "15        1          0 2023-01-22          0        26\n",
       "16        0          1 2023-02-04          0        17\n",
       "17        0          1 2023-02-11          0         8\n",
       "18        0          1 2023-02-15          0        25\n",
       "19        1          1 2023-02-18          0         1\n",
       "20        1          0 2023-02-25          0        23\n",
       "21        1          0 2023-03-01          0        17\n",
       "22        1          1 2023-03-04          0         6\n",
       "23        1          1 2023-03-12          0        18\n",
       "24        1          1 2023-03-19          0        15\n",
       "25        1          1 2023-04-01          0        22\n",
       "231       0          0 2023-01-04          1        44\n",
       "232       1          0 2023-01-13          1        22"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0178d168",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}