docs/scrapers/footballdata.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "fdfeabe5-ff98-444e-a107-de870427f5f5",
   "metadata": {},
   "source": [
    "# football-data.co.uk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "01177c79-baa8-4f27-a3f3-4c8e2737c563",
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys\n",
    "sys.path.append(\"../\")\n",
    "\n",
    "import penaltyblog as pb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b8a9b9b5-d452-4d28-9978-e6e2917597c1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'0.4.0'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pb.__version__"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d2787af4-680c-4fdf-835c-082602443172",
   "metadata": {},
   "source": [
    "### List the available countries to download data for"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6c0c661b-9ae2-4c41-a354-5f9ab6870f28",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['DEU Bundesliga 1',\n",
       " 'DEU Bundesliga 2',\n",
       " 'ENG Premier League',\n",
       " 'ENG Championship',\n",
       " 'ENG League 1',\n",
       " 'ENG League 2',\n",
       " 'ENG Conference',\n",
       " 'FRA Ligue 1',\n",
       " 'FRA Ligue 2',\n",
       " 'GRC Super League',\n",
       " 'ITA Serie A',\n",
       " 'ITA Serie B',\n",
       " 'NLD Eredivisie',\n",
       " 'PRT Liga 1',\n",
       " 'SCO Premier League',\n",
       " 'SCO Division 1',\n",
       " 'SCO Division 2',\n",
       " 'SCO Division 3',\n",
       " 'TUR Super Lig']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pb.scrapers.FootballData.list_competitions()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9be833ab-9653-402c-8dd9-decaeffe39d1",
   "metadata": {},
   "source": [
    "### Download the data for the English Premier League"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "dd11c0a6-3ed1-4131-9dbb-020c89ce066c",
   "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>competition</th>\n",
       "      <th>season</th>\n",
       "      <th>datetime</th>\n",
       "      <th>div</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>team_home</th>\n",
       "      <th>team_away</th>\n",
       "      <th>fthg</th>\n",
       "      <th>ftag</th>\n",
       "      <th>...</th>\n",
       "      <th>avg_c&lt;2.5</th>\n",
       "      <th>ah_ch</th>\n",
       "      <th>b365_cahh</th>\n",
       "      <th>b365_caha</th>\n",
       "      <th>pcahh</th>\n",
       "      <th>pcaha</th>\n",
       "      <th>max_cahh</th>\n",
       "      <th>max_caha</th>\n",
       "      <th>avg_cahh</th>\n",
       "      <th>avg_caha</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</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>1628812800---brentford---arsenal</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-13 20:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-13</td>\n",
       "      <td>20:00</td>\n",
       "      <td>Brentford</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.62</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.81</td>\n",
       "      <td>2.13</td>\n",
       "      <td>2.05</td>\n",
       "      <td>2.17</td>\n",
       "      <td>1.80</td>\n",
       "      <td>2.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---burnley---brighton</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Burnley</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.62</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.79</td>\n",
       "      <td>2.15</td>\n",
       "      <td>1.81</td>\n",
       "      <td>2.14</td>\n",
       "      <td>1.82</td>\n",
       "      <td>2.19</td>\n",
       "      <td>1.79</td>\n",
       "      <td>2.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---chelsea---crystal_palace</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.94</td>\n",
       "      <td>-1.50</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.12</td>\n",
       "      <td>1.81</td>\n",
       "      <td>2.16</td>\n",
       "      <td>1.93</td>\n",
       "      <td>2.06</td>\n",
       "      <td>1.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---everton---southampton</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Everton</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.67</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.88</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.88</td>\n",
       "      <td>2.08</td>\n",
       "      <td>1.90</td>\n",
       "      <td>2.03</td>\n",
       "      <td>1.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---leicester---wolves</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Leicester</td>\n",
       "      <td>Wolves</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.79</td>\n",
       "      <td>-0.75</td>\n",
       "      <td>2.02</td>\n",
       "      <td>1.91</td>\n",
       "      <td>2.01</td>\n",
       "      <td>1.92</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.95</td>\n",
       "      <td>1.99</td>\n",
       "      <td>1.89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 109 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              competition     season  \\\n",
       "id                                                                     \n",
       "1628812800---brentford---arsenal       ENG Premier League  2021-2022   \n",
       "1628899200---burnley---brighton        ENG Premier League  2021-2022   \n",
       "1628899200---chelsea---crystal_palace  ENG Premier League  2021-2022   \n",
       "1628899200---everton---southampton     ENG Premier League  2021-2022   \n",
       "1628899200---leicester---wolves        ENG Premier League  2021-2022   \n",
       "\n",
       "                                                 datetime div       date  \\\n",
       "id                                                                         \n",
       "1628812800---brentford---arsenal      2021-08-13 20:00:00  E0 2021-08-13   \n",
       "1628899200---burnley---brighton       2021-08-14 15:00:00  E0 2021-08-14   \n",
       "1628899200---chelsea---crystal_palace 2021-08-14 15:00:00  E0 2021-08-14   \n",
       "1628899200---everton---southampton    2021-08-14 15:00:00  E0 2021-08-14   \n",
       "1628899200---leicester---wolves       2021-08-14 15:00:00  E0 2021-08-14   \n",
       "\n",
       "                                        time  team_home       team_away  fthg  \\\n",
       "id                                                                              \n",
       "1628812800---brentford---arsenal       20:00  Brentford         Arsenal     2   \n",
       "1628899200---burnley---brighton        15:00    Burnley        Brighton     1   \n",
       "1628899200---chelsea---crystal_palace  15:00    Chelsea  Crystal Palace     3   \n",
       "1628899200---everton---southampton     15:00    Everton     Southampton     3   \n",
       "1628899200---leicester---wolves        15:00  Leicester          Wolves     1   \n",
       "\n",
       "                                       ftag  ... avg_c<2.5  ah_ch  b365_cahh  \\\n",
       "id                                           ...                               \n",
       "1628812800---brentford---arsenal          0  ...      1.62   0.50       1.75   \n",
       "1628899200---burnley---brighton           2  ...      1.62   0.25       1.79   \n",
       "1628899200---chelsea---crystal_palace     0  ...      1.94  -1.50       2.05   \n",
       "1628899200---everton---southampton        1  ...      1.67  -0.50       2.05   \n",
       "1628899200---leicester---wolves           0  ...      1.79  -0.75       2.02   \n",
       "\n",
       "                                      b365_caha pcahh  pcaha  max_cahh  \\\n",
       "id                                                                       \n",
       "1628812800---brentford---arsenal           2.05  1.81   2.13      2.05   \n",
       "1628899200---burnley---brighton            2.15  1.81   2.14      1.82   \n",
       "1628899200---chelsea---crystal_palace      1.75  2.12   1.81      2.16   \n",
       "1628899200---everton---southampton         1.88  2.05   1.88      2.08   \n",
       "1628899200---leicester---wolves            1.91  2.01   1.92      2.05   \n",
       "\n",
       "                                       max_caha  avg_cahh  avg_caha  \n",
       "id                                                                   \n",
       "1628812800---brentford---arsenal           2.17      1.80      2.09  \n",
       "1628899200---burnley---brighton            2.19      1.79      2.12  \n",
       "1628899200---chelsea---crystal_palace      1.93      2.06      1.82  \n",
       "1628899200---everton---southampton         1.90      2.03      1.86  \n",
       "1628899200---leicester---wolves            1.95      1.99      1.89  \n",
       "\n",
       "[5 rows x 109 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fb = pb.scrapers.FootballData(\"ENG Premier League\", \"2021-2022\")\n",
    "df = fb.get_fixtures()\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d1517234-e0c2-4718-aa84-2a9cacfaa81f",
   "metadata": {},
   "source": [
    "### Download the data for the English Premier League and map team names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "20190a0b-f01e-437d-ab3e-fc6ff701cceb",
   "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>competition</th>\n",
       "      <th>season</th>\n",
       "      <th>datetime</th>\n",
       "      <th>div</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>team_home</th>\n",
       "      <th>team_away</th>\n",
       "      <th>fthg</th>\n",
       "      <th>ftag</th>\n",
       "      <th>...</th>\n",
       "      <th>avg_c&lt;2.5</th>\n",
       "      <th>ah_ch</th>\n",
       "      <th>b365_cahh</th>\n",
       "      <th>b365_caha</th>\n",
       "      <th>pcahh</th>\n",
       "      <th>pcaha</th>\n",
       "      <th>max_cahh</th>\n",
       "      <th>max_caha</th>\n",
       "      <th>avg_cahh</th>\n",
       "      <th>avg_caha</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</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>1628812800---brentford---arsenal</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-13 20:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-13</td>\n",
       "      <td>20:00</td>\n",
       "      <td>Brentford</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.62</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.81</td>\n",
       "      <td>2.13</td>\n",
       "      <td>2.05</td>\n",
       "      <td>2.17</td>\n",
       "      <td>1.80</td>\n",
       "      <td>2.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---burnley---brighton</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Burnley</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.62</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.79</td>\n",
       "      <td>2.15</td>\n",
       "      <td>1.81</td>\n",
       "      <td>2.14</td>\n",
       "      <td>1.82</td>\n",
       "      <td>2.19</td>\n",
       "      <td>1.79</td>\n",
       "      <td>2.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---chelsea---crystal_palace</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.94</td>\n",
       "      <td>-1.50</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.12</td>\n",
       "      <td>1.81</td>\n",
       "      <td>2.16</td>\n",
       "      <td>1.93</td>\n",
       "      <td>2.06</td>\n",
       "      <td>1.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---everton---southampton</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Everton</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.67</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.88</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.88</td>\n",
       "      <td>2.08</td>\n",
       "      <td>1.90</td>\n",
       "      <td>2.03</td>\n",
       "      <td>1.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628899200---leicester_city---wolverhampton_wanderers</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2021-2022</td>\n",
       "      <td>2021-08-14 15:00:00</td>\n",
       "      <td>E0</td>\n",
       "      <td>2021-08-14</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Leicester City</td>\n",
       "      <td>Wolverhampton Wanderers</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.79</td>\n",
       "      <td>-0.75</td>\n",
       "      <td>2.02</td>\n",
       "      <td>1.91</td>\n",
       "      <td>2.01</td>\n",
       "      <td>1.92</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.95</td>\n",
       "      <td>1.99</td>\n",
       "      <td>1.89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 109 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           competition  \\\n",
       "id                                                                       \n",
       "1628812800---brentford---arsenal                    ENG Premier League   \n",
       "1628899200---burnley---brighton                     ENG Premier League   \n",
       "1628899200---chelsea---crystal_palace               ENG Premier League   \n",
       "1628899200---everton---southampton                  ENG Premier League   \n",
       "1628899200---leicester_city---wolverhampton_wan...  ENG Premier League   \n",
       "\n",
       "                                                       season  \\\n",
       "id                                                              \n",
       "1628812800---brentford---arsenal                    2021-2022   \n",
       "1628899200---burnley---brighton                     2021-2022   \n",
       "1628899200---chelsea---crystal_palace               2021-2022   \n",
       "1628899200---everton---southampton                  2021-2022   \n",
       "1628899200---leicester_city---wolverhampton_wan...  2021-2022   \n",
       "\n",
       "                                                              datetime div  \\\n",
       "id                                                                           \n",
       "1628812800---brentford---arsenal                   2021-08-13 20:00:00  E0   \n",
       "1628899200---burnley---brighton                    2021-08-14 15:00:00  E0   \n",
       "1628899200---chelsea---crystal_palace              2021-08-14 15:00:00  E0   \n",
       "1628899200---everton---southampton                 2021-08-14 15:00:00  E0   \n",
       "1628899200---leicester_city---wolverhampton_wan... 2021-08-14 15:00:00  E0   \n",
       "\n",
       "                                                         date   time  \\\n",
       "id                                                                     \n",
       "1628812800---brentford---arsenal                   2021-08-13  20:00   \n",
       "1628899200---burnley---brighton                    2021-08-14  15:00   \n",
       "1628899200---chelsea---crystal_palace              2021-08-14  15:00   \n",
       "1628899200---everton---southampton                 2021-08-14  15:00   \n",
       "1628899200---leicester_city---wolverhampton_wan... 2021-08-14  15:00   \n",
       "\n",
       "                                                         team_home  \\\n",
       "id                                                                   \n",
       "1628812800---brentford---arsenal                         Brentford   \n",
       "1628899200---burnley---brighton                            Burnley   \n",
       "1628899200---chelsea---crystal_palace                      Chelsea   \n",
       "1628899200---everton---southampton                         Everton   \n",
       "1628899200---leicester_city---wolverhampton_wan...  Leicester City   \n",
       "\n",
       "                                                                  team_away  \\\n",
       "id                                                                            \n",
       "1628812800---brentford---arsenal                                    Arsenal   \n",
       "1628899200---burnley---brighton                                    Brighton   \n",
       "1628899200---chelsea---crystal_palace                        Crystal Palace   \n",
       "1628899200---everton---southampton                              Southampton   \n",
       "1628899200---leicester_city---wolverhampton_wan...  Wolverhampton Wanderers   \n",
       "\n",
       "                                                    fthg  ftag  ... avg_c<2.5  \\\n",
       "id                                                              ...             \n",
       "1628812800---brentford---arsenal                       2     0  ...      1.62   \n",
       "1628899200---burnley---brighton                        1     2  ...      1.62   \n",
       "1628899200---chelsea---crystal_palace                  3     0  ...      1.94   \n",
       "1628899200---everton---southampton                     3     1  ...      1.67   \n",
       "1628899200---leicester_city---wolverhampton_wan...     1     0  ...      1.79   \n",
       "\n",
       "                                                    ah_ch  b365_cahh  \\\n",
       "id                                                                     \n",
       "1628812800---brentford---arsenal                     0.50       1.75   \n",
       "1628899200---burnley---brighton                      0.25       1.79   \n",
       "1628899200---chelsea---crystal_palace               -1.50       2.05   \n",
       "1628899200---everton---southampton                  -0.50       2.05   \n",
       "1628899200---leicester_city---wolverhampton_wan...  -0.75       2.02   \n",
       "\n",
       "                                                   b365_caha pcahh  pcaha  \\\n",
       "id                                                                          \n",
       "1628812800---brentford---arsenal                        2.05  1.81   2.13   \n",
       "1628899200---burnley---brighton                         2.15  1.81   2.14   \n",
       "1628899200---chelsea---crystal_palace                   1.75  2.12   1.81   \n",
       "1628899200---everton---southampton                      1.88  2.05   1.88   \n",
       "1628899200---leicester_city---wolverhampton_wan...      1.91  2.01   1.92   \n",
       "\n",
       "                                                    max_cahh  max_caha  \\\n",
       "id                                                                       \n",
       "1628812800---brentford---arsenal                        2.05      2.17   \n",
       "1628899200---burnley---brighton                         1.82      2.19   \n",
       "1628899200---chelsea---crystal_palace                   2.16      1.93   \n",
       "1628899200---everton---southampton                      2.08      1.90   \n",
       "1628899200---leicester_city---wolverhampton_wan...      2.05      1.95   \n",
       "\n",
       "                                                    avg_cahh  avg_caha  \n",
       "id                                                                      \n",
       "1628812800---brentford---arsenal                        1.80      2.09  \n",
       "1628899200---burnley---brighton                         1.79      2.12  \n",
       "1628899200---chelsea---crystal_palace                   2.06      1.82  \n",
       "1628899200---everton---southampton                      2.03      1.86  \n",
       "1628899200---leicester_city---wolverhampton_wan...      1.99      1.89  \n",
       "\n",
       "[5 rows x 109 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_mappings = pb.scrapers.get_example_team_name_mappings()\n",
    "\n",
    "fb = pb.scrapers.FootballData(\"ENG Premier League\", \"2021-2022\", team_mappings)\n",
    "df = fb.get_fixtures()\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "6ff439bc-4486-4593-8ec5-66540243f05e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"Wolverhampton Wanderers\" in df[\"team_home\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "5556026f-d2a6-4f8e-b1e4-4e972631050a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Brentford', 'Burnley', 'Chelsea', 'Everton', 'Leicester City',\n",
       "       'Manchester United', 'Norwich City', 'Watford', 'Newcastle United',\n",
       "       'Tottenham Hotspur', 'Aston Villa', 'Brighton', 'Crystal Palace',\n",
       "       'Leeds United', 'Liverpool', 'Manchester City', 'Arsenal',\n",
       "       'Southampton', 'Wolverhampton Wanderers', 'West Ham'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"team_home\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b028c2f7-0614-4f00-9ad0-de0285348f64",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}