Notebook-EPL1020.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# DATA PREPARATION"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Import all packages need."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests as rq\n",
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## COLLECT & DISCOVER DATA"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Get and collect EPL matches season 2010/11 to 2020/21 data in JSON format. Click [here](https://github.com/openfootball/football.json) for the data source.\n",
    "\n",
    "Complete URL ex: `https://raw.githubusercontent.com/openfootball/football.json/master/2010-11//en.1.json`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "urlLeft = 'https://raw.githubusercontent.com/openfootball/football.json/master/'\n",
    "urlRight = '/en.1.json'\n",
    "\n",
    "seasonIntl = list(range(2010, 2021)) # season start\n",
    "seasonInt2 = list(range(11, 22)) # season end\n",
    "\n",
    "seasonStr1 = []\n",
    "seasonStr2 = []\n",
    "for s1, s2 in zip(seasonIntl, seasonInt2):\n",
    "    seasonStr1.append(str(s1))\n",
    "    seasonStr2.append(str(s2))\n",
    "\n",
    "seasonMerge = []\n",
    "for s1, s2 in zip(seasonStr1, seasonStr2):\n",
    "    seasonMerge.append(urlLeft + s1 + '-' +s2 + urlRight)\n",
    "\n",
    "# convert data to python\n",
    "pythonData = []\n",
    "for x in seasonMerge:\n",
    "    convert = json.loads(rq.get(x).content) # get JSON content\n",
    "    pythonData.append(convert)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true,
    "tags": []
   },
   "outputs": [],
   "source": [
    "# pythonData[0] # season 2010/11"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true,
    "tags": []
   },
   "outputs": [],
   "source": [
    "# pythonData[8] # season 2018/19"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Explanation:** Season 2010/11 to 2017/18 and season 2018/19 to 2020/21 has a different nested dict-list format."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>season</th>\n",
       "      <th>matchday</th>\n",
       "      <th>date</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_goals</th>\n",
       "      <th>away_goals</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>Premier League 2020/21</td>\n",
       "      <td>Matchday 31</td>\n",
       "      <td>2021-04-10</td>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>Aston Villa FC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2150</th>\n",
       "      <td>Premier League 2015/16</td>\n",
       "      <td>Matchday 26</td>\n",
       "      <td>2016-02-13</td>\n",
       "      <td>Norwich City FC</td>\n",
       "      <td>West Ham United FC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>627</th>\n",
       "      <td>Premier League 2011/12</td>\n",
       "      <td>Matchday 25</td>\n",
       "      <td>2012-02-11</td>\n",
       "      <td>Manchester United FC</td>\n",
       "      <td>Liverpool FC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336</th>\n",
       "      <td>Premier League 2013/14</td>\n",
       "      <td>Matchday 20</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>Arsenal FC</td>\n",
       "      <td>Cardiff City FC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1954</th>\n",
       "      <td>Premier League 2015/16</td>\n",
       "      <td>Matchday 6</td>\n",
       "      <td>2015-09-19</td>\n",
       "      <td>Manchester City FC</td>\n",
       "      <td>West Ham United FC</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      season     matchday        date             home_team  \\\n",
       "1064  Premier League 2020/21  Matchday 31  2021-04-10          Liverpool FC   \n",
       "2150  Premier League 2015/16  Matchday 26  2016-02-13       Norwich City FC   \n",
       "627   Premier League 2011/12  Matchday 25  2012-02-11  Manchester United FC   \n",
       "1336  Premier League 2013/14  Matchday 20  2014-01-01            Arsenal FC   \n",
       "1954  Premier League 2015/16   Matchday 6  2015-09-19    Manchester City FC   \n",
       "\n",
       "               away_team  home_goals  away_goals  \n",
       "1064      Aston Villa FC         NaN         NaN  \n",
       "2150  West Ham United FC         2.0         2.0  \n",
       "627         Liverpool FC         2.0         1.0  \n",
       "1336     Cardiff City FC         2.0         0.0  \n",
       "1954  West Ham United FC         1.0         2.0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matchesPart1 = [] # season 2010/11\n",
    "for x1 in pythonData[0:8]:\n",
    "    seasonValue = x1['name']  # pythonData[i]['name'] value\n",
    "    nestedList1 = x1['rounds']  # pythonData[i]['rounds'] list\n",
    "    for x2 in nestedList1:\n",
    "        matchdayValue = x2['name'] # pythonData[i]['rounds'][i]['name'] value\n",
    "        nestedList2 = x2['matches'] # pythonData[i]['rounds'][i]['matches'] list\n",
    "        for x3 in nestedList2:\n",
    "            dateValue = x3['date'] # pythonData[i]['rounds'][i]['matches'][i]['date'] value\n",
    "            hometeamValue = x3['team1'] # pythonData[i]['rounds'][i]['matches'][i]['team1'] value\n",
    "            awayteamValue = x3['team2'] # pythonData[i]['rounds'][i]['matches'][i]['team2'] value\n",
    "            hometeamScoreValue = x3['score']['ft'][0] # pythonData[i]['rounds'][i]['matches'][i]['score']['ft'][0] value\n",
    "            awayteamScoreValue = x3['score']['ft'][1] # pythonData[i]['rounds'][i]['matches'][i]['score']['ft'][1] value\n",
    "            matchesPart1.append({\n",
    "                'season' : seasonValue,\n",
    "                'matchday' : matchdayValue,\n",
    "                'date' : dateValue,\n",
    "                'home_team' : hometeamValue,\n",
    "                'away_team' : awayteamValue,\n",
    "                'home_goals' : hometeamScoreValue,\n",
    "                'away_goals' : awayteamScoreValue\n",
    "            })\n",
    "\n",
    "matchesPart2 = [] # season 2018/19\n",
    "for x1 in pythonData[8:]:\n",
    "    seasonValue = x1['name']  # pythonData[i]['name'] value\n",
    "    nestedList1 = x1['matches']  # pythonData[i]['matches'] list\n",
    "    for x2 in nestedList1:\n",
    "        matchdayValue = x2['round'] # pythonData[i]['matches'][i]['round'] value\n",
    "        dateValue = x2['date'] # pythonData[i]['matches'][i]['date'] value\n",
    "        hometeamValue = x2['team1'] # pythonData[i]['matches'][i]['team1'] value\n",
    "        awayteamValue = x2['team2'] # pythonData[i]['matches'][i]['team2'] value\n",
    "        if ('score' in x2.keys()) == True:\n",
    "            hometeamScoreValue = x2['score']['ft'][0] # pythonData[i]['matches'][i]['score']['ft'][0] value\n",
    "            awayteamScoreValue = x2['score']['ft'][1] # pythonData[i]['matches'][i]['score']['ft'][1] value\n",
    "            matchesPart2.append({\n",
    "                'season' : seasonValue,\n",
    "                'matchday' : matchdayValue,\n",
    "                'date' : dateValue,\n",
    "                'home_team' : hometeamValue,\n",
    "                'away_team' : awayteamValue,\n",
    "                'home_goals' : hometeamScoreValue,\n",
    "                'away_goals' : awayteamScoreValue\n",
    "            })\n",
    "        else:\n",
    "            matchesPart2.append({\n",
    "                'season' : seasonValue,\n",
    "                'matchday' : matchdayValue,\n",
    "                'date' : dateValue,\n",
    "                'home_team' : hometeamValue,\n",
    "                'away_team' : awayteamValue,\n",
    "                'home_goals' : None,\n",
    "                'away_goals' : None\n",
    "            })\n",
    "\n",
    "# create dataframe\n",
    "tempdfPart1 = pd.DataFrame(matchesPart1) # season 2010/11\n",
    "tempdfPart2 = pd.DataFrame(matchesPart2) # season 2018/19\n",
    "dfMatches = tempdfPart1.append(tempdfPart2)\n",
    "\n",
    "dfMatches.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 4180 entries, 0 to 1139\n",
      "Data columns (total 7 columns):\n",
      " #   Column      Non-Null Count  Dtype  \n",
      "---  ------      --------------  -----  \n",
      " 0   season      4180 non-null   object \n",
      " 1   matchday    4180 non-null   object \n",
      " 2   date        4180 non-null   object \n",
      " 3   home_team   4180 non-null   object \n",
      " 4   away_team   4180 non-null   object \n",
      " 5   home_goals  3879 non-null   float64\n",
      " 6   away_goals  3879 non-null   float64\n",
      "dtypes: float64(2), object(5)\n",
      "memory usage: 261.2+ KB\n"
     ]
    }
   ],
   "source": [
    "dfMatches.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Explanation:**\n",
    "- Data type of `date` need to change to date\n",
    "- Data type of `home_goals` and `away_goals` need to change to integer\n",
    "- There are 301 null values in each of `home_goals` and `away_goals`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## CLEANSE DATA"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Duplicated Values"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Check if there are duplicated values."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfMatches.duplicated().any()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Explanation:** There are no duplicated values."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Null Values"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There are null values in `home_goals` and `away_goals`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>season</th>\n",
       "      <th>matchday</th>\n",
       "      <th>date</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>301</td>\n",
       "      <td>301</td>\n",
       "      <td>301</td>\n",
       "      <td>301</td>\n",
       "      <td>301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>40</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>Premier League 2020/21</td>\n",
       "      <td>Matchday 23</td>\n",
       "      <td>2021-01-30</td>\n",
       "      <td>Burnley FC</td>\n",
       "      <td>Manchester United FC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>301</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        season     matchday        date   home_team  \\\n",
       "count                      301          301         301         301   \n",
       "unique                       1           31          40          20   \n",
       "top     Premier League 2020/21  Matchday 23  2021-01-30  Burnley FC   \n",
       "freq                       301           10          10          16   \n",
       "\n",
       "                   away_team  \n",
       "count                    301  \n",
       "unique                    20  \n",
       "top     Manchester United FC  \n",
       "freq                      16  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfTemp = dfMatches.loc[dfMatches['home_goals'].isnull() | dfMatches['home_goals'].isnull()] # filter by null value\n",
    "dfTemp[['season', 'matchday', 'date', 'home_team', 'away_team']].describe() # string statistics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Matchday 1', 'Matchday 9', 'Matchday 10', 'Matchday 11',\n",
       "       'Matchday 12', 'Matchday 13', 'Matchday 14', 'Matchday 15',\n",
       "       'Matchday 16', 'Matchday 17', 'Matchday 18', 'Matchday 19',\n",
       "       'Matchday 20', 'Matchday 21', 'Matchday 22', 'Matchday 23',\n",
       "       'Matchday 24', 'Matchday 25', 'Matchday 26', 'Matchday 27',\n",
       "       'Matchday 28', 'Matchday 29', 'Matchday 30', 'Matchday 31',\n",
       "       'Matchday 32', 'Matchday 33', 'Matchday 34', 'Matchday 35',\n",
       "       'Matchday 36', 'Matchday 37', 'Matchday 38'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfTemp['matchday'].unique() # matchday list that contains null value"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Explanation:** Null values on matchday 1 and 9 to 38 in season 2020/21. Numeric data for that season can't be processed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>season</th>\n",
       "      <th>matchday</th>\n",
       "      <th>date</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_goals</th>\n",
       "      <th>away_goals</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Premier League 2010/11</td>\n",
       "      <td>Matchday 1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Bolton Wanderers FC</td>\n",
       "      <td>Fulham FC</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Premier League 2010/11</td>\n",
       "      <td>Matchday 1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Wigan Athletic FC</td>\n",
       "      <td>Blackpool FC</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   season    matchday       date            home_team  \\\n",
       "0  Premier League 2010/11  Matchday 1 2010-08-14  Bolton Wanderers FC   \n",
       "1  Premier League 2010/11  Matchday 1 2010-08-14    Wigan Athletic FC   \n",
       "\n",
       "      away_team  home_goals  away_goals  \n",
       "0     Fulham FC           0           0  \n",
       "1  Blackpool FC           0           4  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# remove data\n",
    "dfMatchesClean = dfMatches.copy()\n",
    "dfMatchesClean = dfMatchesClean.loc[~(dfMatches['season'] == 'Premier League 2020/21')]\n",
    "\n",
    "# change data type\n",
    "dfMatchesClean['date'] = pd.to_datetime(dfMatchesClean['date']) # str to date\n",
    "dfMatchesClean = dfMatchesClean.astype({\n",
    "    'home_goals' : 'int64', # float to int\n",
    "    'away_goals' : 'int64' # float to int\n",
    "})\n",
    "\n",
    "dfMatchesClean.head(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We have clean dataframe `dfMatchesClean` which contains season from 2010/11 to 2019/20 with goals data."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# DATA PROCESSING"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>season_start</th>\n",
       "      <th>matchday</th>\n",
       "      <th>date</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_goals</th>\n",
       "      <th>away_goals</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2010</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Aston Villa FC</td>\n",
       "      <td>West Ham United FC</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2010</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Blackburn Rovers FC</td>\n",
       "      <td>Everton FC</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   season_start  matchday       date            home_team           away_team  \\\n",
       "0          2010         1 2010-08-14       Aston Villa FC  West Ham United FC   \n",
       "1          2010         1 2010-08-14  Blackburn Rovers FC          Everton FC   \n",
       "\n",
       "   home_goals  away_goals  \n",
       "0           3           0  \n",
       "1           1           0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfMatchesComplete = dfMatchesClean.copy()\n",
    "\n",
    "# split columns\n",
    "seasonStartList = dfMatchesComplete['season'].str.split(expand = True)[2].str.split('/', expand = True)[0]\n",
    "matchdayList = dfMatchesComplete['matchday'].str.split(expand = True)[1]\n",
    "dfMatchesComplete['season'] = seasonStartList\n",
    "dfMatchesComplete['matchday'] = matchdayList\n",
    "dfMatchesComplete = dfMatchesComplete.rename({'season' : 'season_start'}, axis = 1)\n",
    "\n",
    "# drop columns\n",
    "# dfMatchesComplete = dfMatchesComplete.drop(columns = ['date'], axis = 1)\n",
    "\n",
    "# change data type\n",
    "dfMatchesComplete = dfMatchesComplete.astype({\n",
    "    'season_start' : 'int64',\n",
    "    'matchday' : 'int64'\n",
    "})\n",
    "\n",
    "dfMatchesComplete = dfMatchesComplete.sort_values([\n",
    "    'season_start',\n",
    "    'matchday',\n",
    "    'date',\n",
    "    'home_team'\n",
    "]).reset_index(drop = True)\n",
    "\n",
    "dfMatchesComplete.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>season_start</th>\n",
       "      <th>matchday</th>\n",
       "      <th>date</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_goals</th>\n",
       "      <th>away_goals</th>\n",
       "      <th>is_home_cleansheet</th>\n",
       "      <th>is_away_cleansheet</th>\n",
       "      <th>home_point</th>\n",
       "      <th>away_point</th>\n",
       "      <th>home_result</th>\n",
       "      <th>away_result</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2010</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Aston Villa FC</td>\n",
       "      <td>West Ham United FC</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Won</td>\n",
       "      <td>Loss</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2010</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Blackburn Rovers FC</td>\n",
       "      <td>Everton FC</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Won</td>\n",
       "      <td>Loss</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   season_start  matchday       date            home_team           away_team  \\\n",
       "0          2010         1 2010-08-14       Aston Villa FC  West Ham United FC   \n",
       "1          2010         1 2010-08-14  Blackburn Rovers FC          Everton FC   \n",
       "\n",
       "   home_goals  away_goals  is_home_cleansheet  is_away_cleansheet  home_point  \\\n",
       "0           3           0               False                True           3   \n",
       "1           1           0               False                True           3   \n",
       "\n",
       "   away_point home_result away_result  \n",
       "0           0         Won        Loss  \n",
       "1           0         Won        Loss  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# home-away clean sheet by goals condition\n",
    "homeCleanSheet = []\n",
    "awayCleanSheet = []\n",
    "for ((index1, value1), (index2, value2)) in zip(dfMatchesComplete['home_goals'].items(), dfMatchesComplete['away_goals'].items()):\n",
    "    if value1 == 0:\n",
    "        homeCleanSheet.append(True)\n",
    "    else:\n",
    "        homeCleanSheet.append(False)\n",
    "    if value2 == 0:\n",
    "        awayCleanSheet.append(True)\n",
    "    else:\n",
    "        awayCleanSheet.append(False)\n",
    "\n",
    "# home-away point and result by goals condition\n",
    "homePoint = []\n",
    "awayPoint = []\n",
    "homeResult = []\n",
    "awayResult = []\n",
    "for ((index1, value1), (index2, value2)) in zip(dfMatchesComplete['home_goals'].items(), dfMatchesComplete['away_goals'].items()):\n",
    "    if value1 > value2:\n",
    "        homePoint.append(3)\n",
    "        awayPoint.append(0)\n",
    "        homeResult.append('Won')\n",
    "        awayResult.append('Loss')\n",
    "    elif value1 < value2:\n",
    "        homePoint.append(0)\n",
    "        awayPoint.append(3)\n",
    "        homeResult.append('Loss')\n",
    "        awayResult.append('Won')\n",
    "    else:\n",
    "        homePoint.append(1)\n",
    "        awayPoint.append(1)\n",
    "        homeResult.append('Draw')\n",
    "        awayResult.append('Draw')\n",
    "\n",
    "# create new columns\n",
    "dfMatchesComplete['is_home_cleansheet'] = homeCleanSheet\n",
    "dfMatchesComplete['is_away_cleansheet'] = awayCleanSheet\n",
    "dfMatchesComplete['home_point'] = homePoint\n",
    "dfMatchesComplete['away_point'] = awayPoint\n",
    "dfMatchesComplete['home_result'] = homeResult\n",
    "dfMatchesComplete['away_result'] = awayResult\n",
    "\n",
    "dfMatchesComplete.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>season_start</th>\n",
       "      <th>matchday</th>\n",
       "      <th>date</th>\n",
       "      <th>team</th>\n",
       "      <th>side</th>\n",
       "      <th>goals_scored</th>\n",
       "      <th>goals_concedad</th>\n",
       "      <th>is_cleansheet</th>\n",
       "      <th>point</th>\n",
       "      <th>result</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2010</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Birmingham City FC</td>\n",
       "      <td>Away</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2010</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>Blackburn Rovers FC</td>\n",
       "      <td>Home</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>Won</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3799</th>\n",
       "      <td>2014</td>\n",
       "      <td>38</td>\n",
       "      <td>2015-05-24</td>\n",
       "      <td>West Ham United FC</td>\n",
       "      <td>Away</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>Loss</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3800</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>2015-08-08</td>\n",
       "      <td>AFC Bournemouth</td>\n",
       "      <td>Home</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>Loss</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7598</th>\n",
       "      <td>2019</td>\n",
       "      <td>38</td>\n",
       "      <td>2020-07-26</td>\n",
       "      <td>West Ham United FC</td>\n",
       "      <td>Home</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7599</th>\n",
       "      <td>2019</td>\n",
       "      <td>38</td>\n",
       "      <td>2020-07-26</td>\n",
       "      <td>Wolverhampton Wanderers FC</td>\n",
       "      <td>Away</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>Loss</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      season_start  matchday       date                        team  side  \\\n",
       "1             2010         1 2010-08-14          Birmingham City FC  Away   \n",
       "2             2010         1 2010-08-14         Blackburn Rovers FC  Home   \n",
       "3799          2014        38 2015-05-24          West Ham United FC  Away   \n",
       "3800          2015         1 2015-08-08             AFC Bournemouth  Home   \n",
       "7598          2019        38 2020-07-26          West Ham United FC  Home   \n",
       "7599          2019        38 2020-07-26  Wolverhampton Wanderers FC  Away   \n",
       "\n",
       "      goals_scored  goals_concedad  is_cleansheet  point result  \n",
       "1                2               2          False      1   Draw  \n",
       "2                1               0          False      3    Won  \n",
       "3799             0               2           True      0   Loss  \n",
       "3800             0               1           True      0   Loss  \n",
       "7598             1               1          False      1   Draw  \n",
       "7599             0               2           True      0   Loss  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# home team\n",
    "dfHomeMatches = dfMatchesComplete.copy()\n",
    "dfHomeMatches['side'] = 'Home'\n",
    "dfHomeMatches = dfHomeMatches[[\n",
    "    'season_start',\n",
    "    'matchday',\n",
    "    'date',\n",
    "    'home_team',\n",
    "    'side',\n",
    "    'home_goals',\n",
    "    'away_goals',\n",
    "    'is_home_cleansheet',\n",
    "    'home_point',\n",
    "    'home_result'\n",
    "]]\n",
    "dfHomeMatches = dfHomeMatches.rename({\n",
    "    'home_team' : 'team',\n",
    "    'home_goals' : 'goals_scored',\n",
    "    'away_goals' : 'goals_concedad',\n",
    "    'is_home_cleansheet' : 'is_cleansheet',\n",
    "    'home_point' : 'point',\n",
    "    'home_result' : 'result',\n",
    "}, axis = 1)\n",
    "\n",
    "# away team\n",
    "dfAwayMatches = dfMatchesComplete.copy()\n",
    "dfAwayMatches['side'] = 'Away'\n",
    "dfAwayMatches = dfAwayMatches[[\n",
    "    'season_start',\n",
    "    'matchday',\n",
    "    'date',\n",
    "    'away_team',\n",
    "    'side',\n",
    "    'away_goals',\n",
    "    'home_goals',\n",
    "    'is_away_cleansheet',\n",
    "    'away_point',\n",
    "    'away_result'\n",
    "]]\n",
    "dfAwayMatches = dfAwayMatches.rename({\n",
    "    'away_team' : 'team',\n",
    "    'away_goals' : 'goals_scored',\n",
    "    'home_goals' : 'goals_concedad',\n",
    "    'is_away_cleansheet' : 'is_cleansheet',\n",
    "    'away_point' : 'point',\n",
    "    'away_result' : 'result',\n",
    "}, axis = 1)\n",
    "\n",
    "# union home-away team\n",
    "dfTeamResult = dfHomeMatches.append(dfAwayMatches)\n",
    "dfTeamResult = dfTeamResult.sort_values([\n",
    "    'season_start',\n",
    "    'matchday',\n",
    "    'date',\n",
    "    'team'\n",
    "]).reset_index(drop = True)\n",
    "\n",
    "dfTeamResult.iloc[[1, 2, 3799, 3800, 7598, 7599]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true,
    "tags": []
   },
   "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>2010/2011 - Matchday 1</th>\n",
       "      <th>2010/2011 - Matchday 2</th>\n",
       "      <th>2010/2011 - Matchday 3</th>\n",
       "      <th>2010/2011 - Matchday 4</th>\n",
       "      <th>2010/2011 - Matchday 5</th>\n",
       "      <th>2010/2011 - Matchday 6</th>\n",
       "      <th>2010/2011 - Matchday 7</th>\n",
       "      <th>2010/2011 - Matchday 8</th>\n",
       "      <th>2010/2011 - Matchday 9</th>\n",
       "      <th>2010/2011 - Matchday 10</th>\n",
       "      <th>...</th>\n",
       "      <th>2019/2020 - Matchday 30</th>\n",
       "      <th>2019/2020 - Matchday 31</th>\n",
       "      <th>2019/2020 - Matchday 32</th>\n",
       "      <th>2019/2020 - Matchday 33</th>\n",
       "      <th>2019/2020 - Matchday 34</th>\n",
       "      <th>2019/2020 - Matchday 35</th>\n",
       "      <th>2019/2020 - Matchday 36</th>\n",
       "      <th>2019/2020 - Matchday 37</th>\n",
       "      <th>2019/2020 - Matchday 38</th>\n",
       "      <th>logo_url</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>team</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>AFC Bournemouth</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>230</td>\n",
       "      <td>230</td>\n",
       "      <td>231</td>\n",
       "      <td>233</td>\n",
       "      <td>233</td>\n",
       "      <td>237</td>\n",
       "      <td>238</td>\n",
       "      <td>238</td>\n",
       "      <td>241</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Arsenal FC</th>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>21</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>687</td>\n",
       "      <td>689</td>\n",
       "      <td>693</td>\n",
       "      <td>695</td>\n",
       "      <td>696</td>\n",
       "      <td>697</td>\n",
       "      <td>699</td>\n",
       "      <td>699</td>\n",
       "      <td>702</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aston Villa FC</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>264</td>\n",
       "      <td>265</td>\n",
       "      <td>265</td>\n",
       "      <td>265</td>\n",
       "      <td>265</td>\n",
       "      <td>267</td>\n",
       "      <td>268</td>\n",
       "      <td>269</td>\n",
       "      <td>270</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Birmingham City FC</th>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Blackburn Rovers FC</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Blackpool FC</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bolton Wanderers FC</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>98</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brighton &amp; Hove Albion FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>104</td>\n",
       "      <td>105</td>\n",
       "      <td>105</td>\n",
       "      <td>106</td>\n",
       "      <td>106</td>\n",
       "      <td>108</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Burnley FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>182</td>\n",
       "      <td>183</td>\n",
       "      <td>184</td>\n",
       "      <td>185</td>\n",
       "      <td>186</td>\n",
       "      <td>187</td>\n",
       "      <td>188</td>\n",
       "      <td>190</td>\n",
       "      <td>191</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cardiff City FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chelsea FC</th>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>25</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>675</td>\n",
       "      <td>677</td>\n",
       "      <td>679</td>\n",
       "      <td>682</td>\n",
       "      <td>685</td>\n",
       "      <td>685</td>\n",
       "      <td>686</td>\n",
       "      <td>689</td>\n",
       "      <td>691</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crystal Palace FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>293</td>\n",
       "      <td>293</td>\n",
       "      <td>293</td>\n",
       "      <td>293</td>\n",
       "      <td>295</td>\n",
       "      <td>295</td>\n",
       "      <td>295</td>\n",
       "      <td>295</td>\n",
       "      <td>296</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Everton FC</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>521</td>\n",
       "      <td>522</td>\n",
       "      <td>524</td>\n",
       "      <td>524</td>\n",
       "      <td>525</td>\n",
       "      <td>525</td>\n",
       "      <td>526</td>\n",
       "      <td>527</td>\n",
       "      <td>528</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fulham FC</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>221</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Huddersfield Town AFC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hull City AFC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>108</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Leicester City FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>328</td>\n",
       "      <td>328</td>\n",
       "      <td>329</td>\n",
       "      <td>332</td>\n",
       "      <td>333</td>\n",
       "      <td>334</td>\n",
       "      <td>336</td>\n",
       "      <td>336</td>\n",
       "      <td>336</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Liverpool FC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>710</td>\n",
       "      <td>714</td>\n",
       "      <td>714</td>\n",
       "      <td>716</td>\n",
       "      <td>719</td>\n",
       "      <td>720</td>\n",
       "      <td>721</td>\n",
       "      <td>726</td>\n",
       "      <td>729</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Manchester City FC</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>832</td>\n",
       "      <td>833</td>\n",
       "      <td>837</td>\n",
       "      <td>837</td>\n",
       "      <td>842</td>\n",
       "      <td>847</td>\n",
       "      <td>849</td>\n",
       "      <td>853</td>\n",
       "      <td>858</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Manchester United FC</th>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>20</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>660</td>\n",
       "      <td>663</td>\n",
       "      <td>666</td>\n",
       "      <td>671</td>\n",
       "      <td>674</td>\n",
       "      <td>676</td>\n",
       "      <td>678</td>\n",
       "      <td>679</td>\n",
       "      <td>681</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middlesbrough FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Newcastle United FC</th>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>393</td>\n",
       "      <td>394</td>\n",
       "      <td>398</td>\n",
       "      <td>400</td>\n",
       "      <td>400</td>\n",
       "      <td>401</td>\n",
       "      <td>402</td>\n",
       "      <td>402</td>\n",
       "      <td>403</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Norwich City FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>185</td>\n",
       "      <td>185</td>\n",
       "      <td>185</td>\n",
       "      <td>185</td>\n",
       "      <td>186</td>\n",
       "      <td>186</td>\n",
       "      <td>186</td>\n",
       "      <td>186</td>\n",
       "      <td>186</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Queens Park Rangers FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Reading FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sheffield United FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>33</td>\n",
       "      <td>34</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>39</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Southampton FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>377</td>\n",
       "      <td>377</td>\n",
       "      <td>380</td>\n",
       "      <td>381</td>\n",
       "      <td>382</td>\n",
       "      <td>384</td>\n",
       "      <td>385</td>\n",
       "      <td>387</td>\n",
       "      <td>390</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stoke City FC</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sunderland AFC</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>280</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Swansea City FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>306</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tottenham Hotspur FC</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>644</td>\n",
       "      <td>646</td>\n",
       "      <td>647</td>\n",
       "      <td>648</td>\n",
       "      <td>648</td>\n",
       "      <td>650</td>\n",
       "      <td>653</td>\n",
       "      <td>656</td>\n",
       "      <td>657</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Watford FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>204</td>\n",
       "      <td>204</td>\n",
       "      <td>205</td>\n",
       "      <td>205</td>\n",
       "      <td>207</td>\n",
       "      <td>209</td>\n",
       "      <td>210</td>\n",
       "      <td>210</td>\n",
       "      <td>212</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Bromwich Albion FC</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>343</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Ham United FC</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>419</td>\n",
       "      <td>419</td>\n",
       "      <td>422</td>\n",
       "      <td>424</td>\n",
       "      <td>424</td>\n",
       "      <td>428</td>\n",
       "      <td>431</td>\n",
       "      <td>432</td>\n",
       "      <td>433</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wigan Athletic FC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>129</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wolverhampton Wanderers FC</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>176</td>\n",
       "      <td>177</td>\n",
       "      <td>178</td>\n",
       "      <td>178</td>\n",
       "      <td>178</td>\n",
       "      <td>181</td>\n",
       "      <td>182</td>\n",
       "      <td>184</td>\n",
       "      <td>184</td>\n",
       "      <td>https://raw.githubusercontent.com/faisalydth/M...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>36 rows × 381 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            2010/2011 - Matchday 1  2010/2011 - Matchday 2  \\\n",
       "team                                                                         \n",
       "AFC Bournemouth                                  0                       0   \n",
       "Arsenal FC                                       1                       7   \n",
       "Aston Villa FC                                   3                       3   \n",
       "Birmingham City FC                               2                       4   \n",
       "Blackburn Rovers FC                              1                       2   \n",
       "Blackpool FC                                     4                       4   \n",
       "Bolton Wanderers FC                              0                       3   \n",
       "Brighton & Hove Albion FC                        0                       0   \n",
       "Burnley FC                                       0                       0   \n",
       "Cardiff City FC                                  0                       0   \n",
       "Chelsea FC                                       6                      12   \n",
       "Crystal Palace FC                                0                       0   \n",
       "Everton FC                                       0                       1   \n",
       "Fulham FC                                        0                       2   \n",
       "Huddersfield Town AFC                            0                       0   \n",
       "Hull City AFC                                    0                       0   \n",
       "Leicester City FC                                0                       0   \n",
       "Liverpool FC                                     1                       1   \n",
       "Manchester City FC                               0                       3   \n",
       "Manchester United FC                             3                       5   \n",
       "Middlesbrough FC                                 0                       0   \n",
       "Newcastle United FC                              0                       6   \n",
       "Norwich City FC                                  0                       0   \n",
       "Queens Park Rangers FC                           0                       0   \n",
       "Reading FC                                       0                       0   \n",
       "Sheffield United FC                              0                       0   \n",
       "Southampton FC                                   0                       0   \n",
       "Stoke City FC                                    1                       2   \n",
       "Sunderland AFC                                   2                       2   \n",
       "Swansea City FC                                  0                       0   \n",
       "Tottenham Hotspur FC                             0                       2   \n",
       "Watford FC                                       0                       0   \n",
       "West Bromwich Albion FC                          0                       1   \n",
       "West Ham United FC                               0                       1   \n",
       "Wigan Athletic FC                                0                       0   \n",
       "Wolverhampton Wanderers FC                       2                       3   \n",
       "\n",
       "                            2010/2011 - Matchday 3  2010/2011 - Matchday 4  \\\n",
       "team                                                                         \n",
       "AFC Bournemouth                                  0                       0   \n",
       "Arsenal FC                                       9                      13   \n",
       "Aston Villa FC                                   4                       5   \n",
       "Birmingham City FC                               6                       6   \n",
       "Blackburn Rovers FC                              3                       4   \n",
       "Blackpool FC                                     6                       8   \n",
       "Bolton Wanderers FC                              5                       6   \n",
       "Brighton & Hove Albion FC                        0                       0   \n",
       "Burnley FC                                       0                       0   \n",
       "Cardiff City FC                                  0                       0   \n",
       "Chelsea FC                                      14                      17   \n",
       "Crystal Palace FC                                0                       0   \n",
       "Everton FC                                       1                       4   \n",
       "Fulham FC                                        4                       6   \n",
       "Huddersfield Town AFC                            0                       0   \n",
       "Hull City AFC                                    0                       0   \n",
       "Leicester City FC                                0                       0   \n",
       "Liverpool FC                                     2                       2   \n",
       "Manchester City FC                               3                       4   \n",
       "Manchester United FC                             8                      11   \n",
       "Middlesbrough FC                                 0                       0   \n",
       "Newcastle United FC                              7                       7   \n",
       "Norwich City FC                                  0                       0   \n",
       "Queens Park Rangers FC                           0                       0   \n",
       "Reading FC                                       0                       0   \n",
       "Sheffield United FC                              0                       0   \n",
       "Southampton FC                                   0                       0   \n",
       "Stoke City FC                                    2                       4   \n",
       "Sunderland AFC                                   3                       4   \n",
       "Swansea City FC                                  0                       0   \n",
       "Tottenham Hotspur FC                             2                       3   \n",
       "Watford FC                                       0                       0   \n",
       "West Bromwich Albion FC                          1                       2   \n",
       "West Ham United FC                               1                       2   \n",
       "Wigan Athletic FC                                1                       2   \n",
       "Wolverhampton Wanderers FC                       4                       5   \n",
       "\n",
       "                            2010/2011 - Matchday 5  2010/2011 - Matchday 6  \\\n",
       "team                                                                         \n",
       "AFC Bournemouth                                  0                       0   \n",
       "Arsenal FC                                      14                      16   \n",
       "Aston Villa FC                                   6                       8   \n",
       "Birmingham City FC                               7                       7   \n",
       "Blackburn Rovers FC                              5                       7   \n",
       "Blackpool FC                                     8                       9   \n",
       "Bolton Wanderers FC                              7                       9   \n",
       "Brighton & Hove Albion FC                        0                       0   \n",
       "Burnley FC                                       0                       0   \n",
       "Cardiff City FC                                  0                       0   \n",
       "Chelsea FC                                      21                      21   \n",
       "Crystal Palace FC                                0                       0   \n",
       "Everton FC                                       4                       4   \n",
       "Fulham FC                                        7                       7   \n",
       "Huddersfield Town AFC                            0                       0   \n",
       "Hull City AFC                                    0                       0   \n",
       "Leicester City FC                                0                       0   \n",
       "Liverpool FC                                     4                       6   \n",
       "Manchester City FC                               6                       7   \n",
       "Manchester United FC                            14                      16   \n",
       "Middlesbrough FC                                 0                       0   \n",
       "Newcastle United FC                              8                       9   \n",
       "Norwich City FC                                  0                       0   \n",
       "Queens Park Rangers FC                           0                       0   \n",
       "Reading FC                                       0                       0   \n",
       "Sheffield United FC                              0                       0   \n",
       "Southampton FC                                   0                       0   \n",
       "Stoke City FC                                    5                       7   \n",
       "Sunderland AFC                                   5                       7   \n",
       "Swansea City FC                                  0                       0   \n",
       "Tottenham Hotspur FC                             6                       6   \n",
       "Watford FC                                       0                       0   \n",
       "West Bromwich Albion FC                          5                       8   \n",
       "West Ham United FC                               3                       4   \n",
       "Wigan Athletic FC                                2                       2   \n",
       "Wolverhampton Wanderers FC                       6                       7   \n",
       "\n",
       "                            2010/2011 - Matchday 7  2010/2011 - Matchday 8  \\\n",
       "team                                                                         \n",
       "AFC Bournemouth                                  0                       0   \n",
       "Arsenal FC                                      16                      18   \n",
       "Aston Villa FC                                   9                       9   \n",
       "Birmingham City FC                               7                       8   \n",
       "Blackburn Rovers FC                              7                       7   \n",
       "Blackpool FC                                    11                      13   \n",
       "Bolton Wanderers FC                             10                      12   \n",
       "Brighton & Hove Albion FC                        0                       0   \n",
       "Burnley FC                                       0                       0   \n",
       "Cardiff City FC                                  0                       0   \n",
       "Chelsea FC                                      23                      23   \n",
       "Crystal Palace FC                                0                       0   \n",
       "Everton FC                                       6                       8   \n",
       "Fulham FC                                        8                       9   \n",
       "Huddersfield Town AFC                            0                       0   \n",
       "Hull City AFC                                    0                       0   \n",
       "Leicester City FC                                0                       0   \n",
       "Liverpool FC                                     7                       7   \n",
       "Manchester City FC                               9                      12   \n",
       "Manchester United FC                            16                      18   \n",
       "Middlesbrough FC                                 0                       0   \n",
       "Newcastle United FC                             10                      12   \n",
       "Norwich City FC                                  0                       0   \n",
       "Queens Park Rangers FC                           0                       0   \n",
       "Reading FC                                       0                       0   \n",
       "Sheffield United FC                              0                       0   \n",
       "Southampton FC                                   0                       0   \n",
       "Stoke City FC                                    8                       9   \n",
       "Sunderland AFC                                   7                       7   \n",
       "Swansea City FC                                  0                       0   \n",
       "Tottenham Hotspur FC                             8                      10   \n",
       "Watford FC                                       0                       0   \n",
       "West Bromwich Albion FC                          9                      11   \n",
       "West Ham United FC                               5                       6   \n",
       "Wigan Athletic FC                                4                       6   \n",
       "Wolverhampton Wanderers FC                       7                       8   \n",
       "\n",
       "                            2010/2011 - Matchday 9  2010/2011 - Matchday 10  \\\n",
       "team                                                                          \n",
       "AFC Bournemouth                                  0                        0   \n",
       "Arsenal FC                                      21                       22   \n",
       "Aston Villa FC                                   9                        9   \n",
       "Birmingham City FC                              10                       10   \n",
       "Blackburn Rovers FC                              8                        9   \n",
       "Blackpool FC                                    13                       15   \n",
       "Bolton Wanderers FC                             13                       13   \n",
       "Brighton & Hove Albion FC                        0                        0   \n",
       "Burnley FC                                       0                        0   \n",
       "Cardiff City FC                                  0                        0   \n",
       "Chelsea FC                                      25                       27   \n",
       "Crystal Palace FC                                0                        0   \n",
       "Everton FC                                       9                       10   \n",
       "Fulham FC                                       10                       12   \n",
       "Huddersfield Town AFC                            0                        0   \n",
       "Hull City AFC                                    0                        0   \n",
       "Leicester City FC                                0                        0   \n",
       "Liverpool FC                                     9                       10   \n",
       "Manchester City FC                              12                       13   \n",
       "Manchester United FC                            20                       22   \n",
       "Middlesbrough FC                                 0                        0   \n",
       "Newcastle United FC                             14                       19   \n",
       "Norwich City FC                                  0                        0   \n",
       "Queens Park Rangers FC                           0                        0   \n",
       "Reading FC                                       0                        0   \n",
       "Sheffield United FC                              0                        0   \n",
       "Southampton FC                                   0                        0   \n",
       "Stoke City FC                                   10                       10   \n",
       "Sunderland AFC                                   8                        9   \n",
       "Swansea City FC                                  0                        0   \n",
       "Tottenham Hotspur FC                            11                       11   \n",
       "Watford FC                                       0                        0   \n",
       "West Bromwich Albion FC                         13                       14   \n",
       "West Ham United FC                               7                        7   \n",
       "Wigan Athletic FC                                7                        7   \n",
       "Wolverhampton Wanderers FC                       8                       10   \n",
       "\n",
       "                            ...  2019/2020 - Matchday 30  \\\n",
       "team                        ...                            \n",
       "AFC Bournemouth             ...                      230   \n",
       "Arsenal FC                  ...                      687   \n",
       "Aston Villa FC              ...                      264   \n",
       "Birmingham City FC          ...                       37   \n",
       "Blackburn Rovers FC         ...                       94   \n",
       "Blackpool FC                ...                       55   \n",
       "Bolton Wanderers FC         ...                       98   \n",
       "Brighton & Hove Albion FC   ...                      103   \n",
       "Burnley FC                  ...                      182   \n",
       "Cardiff City FC             ...                       66   \n",
       "Chelsea FC                  ...                      675   \n",
       "Crystal Palace FC           ...                      293   \n",
       "Everton FC                  ...                      521   \n",
       "Fulham FC                   ...                      221   \n",
       "Huddersfield Town AFC       ...                       50   \n",
       "Hull City AFC               ...                      108   \n",
       "Leicester City FC           ...                      328   \n",
       "Liverpool FC                ...                      710   \n",
       "Manchester City FC          ...                      832   \n",
       "Manchester United FC        ...                      660   \n",
       "Middlesbrough FC            ...                       27   \n",
       "Newcastle United FC         ...                      393   \n",
       "Norwich City FC             ...                      185   \n",
       "Queens Park Rangers FC      ...                      115   \n",
       "Reading FC                  ...                       43   \n",
       "Sheffield United FC         ...                       30   \n",
       "Southampton FC              ...                      377   \n",
       "Stoke City FC               ...                      326   \n",
       "Sunderland AFC              ...                      280   \n",
       "Swansea City FC             ...                      306   \n",
       "Tottenham Hotspur FC        ...                      644   \n",
       "Watford FC                  ...                      204   \n",
       "West Bromwich Albion FC     ...                      343   \n",
       "West Ham United FC          ...                      419   \n",
       "Wigan Athletic FC           ...                      129   \n",
       "Wolverhampton Wanderers FC  ...                      176   \n",
       "\n",
       "                            2019/2020 - Matchday 31  2019/2020 - Matchday 32  \\\n",
       "team                                                                           \n",
       "AFC Bournemouth                                 230                      231   \n",
       "Arsenal FC                                      689                      693   \n",
       "Aston Villa FC                                  265                      265   \n",
       "Birmingham City FC                               37                       37   \n",
       "Blackburn Rovers FC                              94                       94   \n",
       "Blackpool FC                                     55                       55   \n",
       "Bolton Wanderers FC                              98                       98   \n",
       "Brighton & Hove Albion FC                       103                      103   \n",
       "Burnley FC                                      183                      184   \n",
       "Cardiff City FC                                  66                       66   \n",
       "Chelsea FC                                      677                      679   \n",
       "Crystal Palace FC                               293                      293   \n",
       "Everton FC                                      522                      524   \n",
       "Fulham FC                                       221                      221   \n",
       "Huddersfield Town AFC                            50                       50   \n",
       "Hull City AFC                                   108                      108   \n",
       "Leicester City FC                               328                      329   \n",
       "Liverpool FC                                    714                      714   \n",
       "Manchester City FC                              833                      837   \n",
       "Manchester United FC                            663                      666   \n",
       "Middlesbrough FC                                 27                       27   \n",
       "Newcastle United FC                             394                      398   \n",
       "Norwich City FC                                 185                      185   \n",
       "Queens Park Rangers FC                          115                      115   \n",
       "Reading FC                                       43                       43   \n",
       "Sheffield United FC                              30                       33   \n",
       "Southampton FC                                  377                      380   \n",
       "Stoke City FC                                   326                      326   \n",
       "Sunderland AFC                                  280                      280   \n",
       "Swansea City FC                                 306                      306   \n",
       "Tottenham Hotspur FC                            646                      647   \n",
       "Watford FC                                      204                      205   \n",
       "West Bromwich Albion FC                         343                      343   \n",
       "West Ham United FC                              419                      422   \n",
       "Wigan Athletic FC                               129                      129   \n",
       "Wolverhampton Wanderers FC                      177                      178   \n",
       "\n",
       "                            2019/2020 - Matchday 33  2019/2020 - Matchday 34  \\\n",
       "team                                                                           \n",
       "AFC Bournemouth                                 233                      233   \n",
       "Arsenal FC                                      695                      696   \n",
       "Aston Villa FC                                  265                      265   \n",
       "Birmingham City FC                               37                       37   \n",
       "Blackburn Rovers FC                              94                       94   \n",
       "Blackpool FC                                     55                       55   \n",
       "Bolton Wanderers FC                              98                       98   \n",
       "Brighton & Hove Albion FC                       104                      105   \n",
       "Burnley FC                                      185                      186   \n",
       "Cardiff City FC                                  66                       66   \n",
       "Chelsea FC                                      682                      685   \n",
       "Crystal Palace FC                               293                      295   \n",
       "Everton FC                                      524                      525   \n",
       "Fulham FC                                       221                      221   \n",
       "Huddersfield Town AFC                            50                       50   \n",
       "Hull City AFC                                   108                      108   \n",
       "Leicester City FC                               332                      333   \n",
       "Liverpool FC                                    716                      719   \n",
       "Manchester City FC                              837                      842   \n",
       "Manchester United FC                            671                      674   \n",
       "Middlesbrough FC                                 27                       27   \n",
       "Newcastle United FC                             400                      400   \n",
       "Norwich City FC                                 185                      186   \n",
       "Queens Park Rangers FC                          115                      115   \n",
       "Reading FC                                       43                       43   \n",
       "Sheffield United FC                              34                       35   \n",
       "Southampton FC                                  381                      382   \n",
       "Stoke City FC                                   326                      326   \n",
       "Sunderland AFC                                  280                      280   \n",
       "Swansea City FC                                 306                      306   \n",
       "Tottenham Hotspur FC                            648                      648   \n",
       "Watford FC                                      205                      207   \n",
       "West Bromwich Albion FC                         343                      343   \n",
       "West Ham United FC                              424                      424   \n",
       "Wigan Athletic FC                               129                      129   \n",
       "Wolverhampton Wanderers FC                      178                      178   \n",
       "\n",
       "                            2019/2020 - Matchday 35  2019/2020 - Matchday 36  \\\n",
       "team                                                                           \n",
       "AFC Bournemouth                                 237                      238   \n",
       "Arsenal FC                                      697                      699   \n",
       "Aston Villa FC                                  267                      268   \n",
       "Birmingham City FC                               37                       37   \n",
       "Blackburn Rovers FC                              94                       94   \n",
       "Blackpool FC                                     55                       55   \n",
       "Bolton Wanderers FC                              98                       98   \n",
       "Brighton & Hove Albion FC                       105                      106   \n",
       "Burnley FC                                      187                      188   \n",
       "Cardiff City FC                                  66                       66   \n",
       "Chelsea FC                                      685                      686   \n",
       "Crystal Palace FC                               295                      295   \n",
       "Everton FC                                      525                      526   \n",
       "Fulham FC                                       221                      221   \n",
       "Huddersfield Town AFC                            50                       50   \n",
       "Hull City AFC                                   108                      108   \n",
       "Leicester City FC                               334                      336   \n",
       "Liverpool FC                                    720                      721   \n",
       "Manchester City FC                              847                      849   \n",
       "Manchester United FC                            676                      678   \n",
       "Middlesbrough FC                                 27                       27   \n",
       "Newcastle United FC                             401                      402   \n",
       "Norwich City FC                                 186                      186   \n",
       "Queens Park Rangers FC                          115                      115   \n",
       "Reading FC                                       43                       43   \n",
       "Sheffield United FC                              38                       38   \n",
       "Southampton FC                                  384                      385   \n",
       "Stoke City FC                                   326                      326   \n",
       "Sunderland AFC                                  280                      280   \n",
       "Swansea City FC                                 306                      306   \n",
       "Tottenham Hotspur FC                            650                      653   \n",
       "Watford FC                                      209                      210   \n",
       "West Bromwich Albion FC                         343                      343   \n",
       "West Ham United FC                              428                      431   \n",
       "Wigan Athletic FC                               129                      129   \n",
       "Wolverhampton Wanderers FC                      181                      182   \n",
       "\n",
       "                            2019/2020 - Matchday 37  2019/2020 - Matchday 38  \\\n",
       "team                                                                           \n",
       "AFC Bournemouth                                 238                      241   \n",
       "Arsenal FC                                      699                      702   \n",
       "Aston Villa FC                                  269                      270   \n",
       "Birmingham City FC                               37                       37   \n",
       "Blackburn Rovers FC                              94                       94   \n",
       "Blackpool FC                                     55                       55   \n",
       "Bolton Wanderers FC                              98                       98   \n",
       "Brighton & Hove Albion FC                       106                      108   \n",
       "Burnley FC                                      190                      191   \n",
       "Cardiff City FC                                  66                       66   \n",
       "Chelsea FC                                      689                      691   \n",
       "Crystal Palace FC                               295                      296   \n",
       "Everton FC                                      527                      528   \n",
       "Fulham FC                                       221                      221   \n",
       "Huddersfield Town AFC                            50                       50   \n",
       "Hull City AFC                                   108                      108   \n",
       "Leicester City FC                               336                      336   \n",
       "Liverpool FC                                    726                      729   \n",
       "Manchester City FC                              853                      858   \n",
       "Manchester United FC                            679                      681   \n",
       "Middlesbrough FC                                 27                       27   \n",
       "Newcastle United FC                             402                      403   \n",
       "Norwich City FC                                 186                      186   \n",
       "Queens Park Rangers FC                          115                      115   \n",
       "Reading FC                                       43                       43   \n",
       "Sheffield United FC                              38                       39   \n",
       "Southampton FC                                  387                      390   \n",
       "Stoke City FC                                   326                      326   \n",
       "Sunderland AFC                                  280                      280   \n",
       "Swansea City FC                                 306                      306   \n",
       "Tottenham Hotspur FC                            656                      657   \n",
       "Watford FC                                      210                      212   \n",
       "West Bromwich Albion FC                         343                      343   \n",
       "West Ham United FC                              432                      433   \n",
       "Wigan Athletic FC                               129                      129   \n",
       "Wolverhampton Wanderers FC                      184                      184   \n",
       "\n",
       "                                                                     logo_url  \n",
       "team                                                                           \n",
       "AFC Bournemouth             https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Arsenal FC                  https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Aston Villa FC              https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Birmingham City FC          https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Blackburn Rovers FC         https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Blackpool FC                https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Bolton Wanderers FC         https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Brighton & Hove Albion FC   https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Burnley FC                  https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Cardiff City FC             https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Chelsea FC                  https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Crystal Palace FC           https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Everton FC                  https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Fulham FC                   https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Huddersfield Town AFC       https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Hull City AFC               https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Leicester City FC           https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Liverpool FC                https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Manchester City FC          https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Manchester United FC        https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Middlesbrough FC            https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Newcastle United FC         https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Norwich City FC             https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Queens Park Rangers FC      https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Reading FC                  https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Sheffield United FC         https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Southampton FC              https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Stoke City FC               https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Sunderland AFC              https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Swansea City FC             https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Tottenham Hotspur FC        https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Watford FC                  https://raw.githubusercontent.com/faisalydth/M...  \n",
       "West Bromwich Albion FC     https://raw.githubusercontent.com/faisalydth/M...  \n",
       "West Ham United FC          https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Wigan Athletic FC           https://raw.githubusercontent.com/faisalydth/M...  \n",
       "Wolverhampton Wanderers FC  https://raw.githubusercontent.com/faisalydth/M...  \n",
       "\n",
       "[36 rows x 381 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create pivot table\n",
    "goalsScoredPivot = pd.pivot_table(\n",
    "    data = dfTeamResult,\n",
    "    values = 'goals_scored',\n",
    "    index = ['team'],\n",
    "    columns = ['season_start', 'matchday'],\n",
    "    fill_value = 0,\n",
    "    aggfunc = 'sum',\n",
    ")\n",
    "goalsScoredPivot = goalsScoredPivot.cumsum(axis = 1)\n",
    "\n",
    "columnLevel0 = goalsScoredPivot.columns.get_level_values(0).tolist()\n",
    "columnLevel1 = goalsScoredPivot.columns.get_level_values(1).tolist()\n",
    "columnName = []\n",
    "for col1, col2 in zip(columnLevel0, columnLevel1):\n",
    "    columnName.append(str(col1) + '/' + str(col1 + 1) + ' - Matchday ' + str(col2))\n",
    "goalsScoredPivot.columns = columnName\n",
    "\n",
    "urlLogoMain = 'https://raw.githubusercontent.com/faisalydth/MP-EPL1020/main/Logo/'\n",
    "urlLogo = []\n",
    "for x in range(1, 37):\n",
    "    urlLogo.append(urlLogoMain + str(x) + '.svg')\n",
    "goalsScoredPivot['logo_url'] = urlLogo\n",
    "\n",
    "goalsScoredPivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# save to CSV\n",
    "goalsScoredPivot.to_csv('Table-GoalsScored.csv', index = True)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "a2628063118a4d807edce410295c8f6c97a747ef3964f1b5f778714a2377a0ea"
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}