{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1ee69dc3-2f18-4110-a232-81d807884da9",
   "metadata": {},
   "source": [
    "# FBRef"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2077b457-872d-420d-8799-9457e1a8f50f",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import sys\n",
    "\n",
    "sys.path.append(\"../../\")\n",
    "\n",
    "import penaltyblog as pb"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "56a9acc8-bf3a-4b1d-becb-f9b1e9ca1a09",
   "metadata": {},
   "source": [
    "## List available competitions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "bea88bf4-476f-4445-9345-379795d85025",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['BEL First Division A',\n",
       " 'BEL First Division B',\n",
       " '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",
       " 'ESP La Liga',\n",
       " 'ESP La Liga Segunda',\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",
       " 'RUS Premier League',\n",
       " 'SCO Premier League',\n",
       " 'SCO Division 1',\n",
       " 'TUR Super Lig']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pb.scrapers.FBRef.list_competitions()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c22b88a5-d0bc-4553-a1b6-700c630a36a7",
   "metadata": {},
   "source": [
    "## Get fixtures"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "88b75ca5-90dd-4a6e-a0b4-4b1a5a63fec2",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/martin/repos/penaltyblog/examples/scrapers/../../penaltyblog/scrapers/fbref.py:160: FutureWarning: Passing literal html to 'read_html' is deprecated and will be removed in a future version. To read from a literal string, wrap it in a 'StringIO' object.\n",
      "  pd.read_html(content)[0]\n"
     ]
    },
    {
     "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>week</th>\n",
       "      <th>day</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>team_home</th>\n",
       "      <th>xg_home</th>\n",
       "      <th>xg_away</th>\n",
       "      <th>team_away</th>\n",
       "      <th>attendance</th>\n",
       "      <th>venue</th>\n",
       "      <th>referee</th>\n",
       "      <th>goals_home</th>\n",
       "      <th>goals_away</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1659657600---crystal_palace---arsenal</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>2022-08-05 20:00:00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fri</td>\n",
       "      <td>2022-08-05</td>\n",
       "      <td>20:00</td>\n",
       "      <td>Crystal Palace</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>25286.0</td>\n",
       "      <td>Selhurst Park</td>\n",
       "      <td>Anthony Taylor</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659744000---bournemouth---aston_villa</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>2022-08-06 15:00:00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Sat</td>\n",
       "      <td>2022-08-06</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>Aston Villa</td>\n",
       "      <td>11013.0</td>\n",
       "      <td>Vitality Stadium</td>\n",
       "      <td>Peter Bankes</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659744000---everton---chelsea</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>2022-08-06 17:30:00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Sat</td>\n",
       "      <td>2022-08-06</td>\n",
       "      <td>17:30</td>\n",
       "      <td>Everton</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>39254.0</td>\n",
       "      <td>Goodison Park</td>\n",
       "      <td>Craig Pawson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659744000---fulham---liverpool</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>2022-08-06 12:30:00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Sat</td>\n",
       "      <td>2022-08-06</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Fulham</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>22207.0</td>\n",
       "      <td>Craven Cottage</td>\n",
       "      <td>Andy Madley</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659744000---leeds_united---wolves</th>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>2022-08-06 15:00:00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Sat</td>\n",
       "      <td>2022-08-06</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Leeds United</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.3</td>\n",
       "      <td>Wolves</td>\n",
       "      <td>36347.0</td>\n",
       "      <td>Elland Road</td>\n",
       "      <td>Robert Jones</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               competition     season  \\\n",
       "id                                                                      \n",
       "1659657600---crystal_palace---arsenal   ENG Premier League  2022-2023   \n",
       "1659744000---bournemouth---aston_villa  ENG Premier League  2022-2023   \n",
       "1659744000---everton---chelsea          ENG Premier League  2022-2023   \n",
       "1659744000---fulham---liverpool         ENG Premier League  2022-2023   \n",
       "1659744000---leeds_united---wolves      ENG Premier League  2022-2023   \n",
       "\n",
       "                                                  datetime  week  day  \\\n",
       "id                                                                      \n",
       "1659657600---crystal_palace---arsenal  2022-08-05 20:00:00   1.0  Fri   \n",
       "1659744000---bournemouth---aston_villa 2022-08-06 15:00:00   1.0  Sat   \n",
       "1659744000---everton---chelsea         2022-08-06 17:30:00   1.0  Sat   \n",
       "1659744000---fulham---liverpool        2022-08-06 12:30:00   1.0  Sat   \n",
       "1659744000---leeds_united---wolves     2022-08-06 15:00:00   1.0  Sat   \n",
       "\n",
       "                                             date   time       team_home  \\\n",
       "id                                                                         \n",
       "1659657600---crystal_palace---arsenal  2022-08-05  20:00  Crystal Palace   \n",
       "1659744000---bournemouth---aston_villa 2022-08-06  15:00     Bournemouth   \n",
       "1659744000---everton---chelsea         2022-08-06  17:30         Everton   \n",
       "1659744000---fulham---liverpool        2022-08-06  12:30          Fulham   \n",
       "1659744000---leeds_united---wolves     2022-08-06  15:00    Leeds United   \n",
       "\n",
       "                                        xg_home  xg_away    team_away  \\\n",
       "id                                                                      \n",
       "1659657600---crystal_palace---arsenal       1.2      1.0      Arsenal   \n",
       "1659744000---bournemouth---aston_villa      0.6      0.7  Aston Villa   \n",
       "1659744000---everton---chelsea              0.7      1.5      Chelsea   \n",
       "1659744000---fulham---liverpool             1.2      1.2    Liverpool   \n",
       "1659744000---leeds_united---wolves          0.8      1.3       Wolves   \n",
       "\n",
       "                                        attendance             venue  \\\n",
       "id                                                                     \n",
       "1659657600---crystal_palace---arsenal      25286.0     Selhurst Park   \n",
       "1659744000---bournemouth---aston_villa     11013.0  Vitality Stadium   \n",
       "1659744000---everton---chelsea             39254.0     Goodison Park   \n",
       "1659744000---fulham---liverpool            22207.0    Craven Cottage   \n",
       "1659744000---leeds_united---wolves         36347.0       Elland Road   \n",
       "\n",
       "                                               referee  goals_home  goals_away  \n",
       "id                                                                              \n",
       "1659657600---crystal_palace---arsenal   Anthony Taylor         0.0         2.0  \n",
       "1659744000---bournemouth---aston_villa    Peter Bankes         2.0         0.0  \n",
       "1659744000---everton---chelsea            Craig Pawson         0.0         1.0  \n",
       "1659744000---fulham---liverpool            Andy Madley         2.0         2.0  \n",
       "1659744000---leeds_united---wolves        Robert Jones         2.0         1.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fbref = pb.scrapers.FBRef(\"ENG Premier League\", \"2022-2023\")\n",
    "df = fbref.get_fixtures()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5efb2de7-dee1-477d-89a3-35e4979cd608",
   "metadata": {},
   "source": [
    "## List stats available for this competition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5c7bef65-a41b-424e-97bc-1e822688a450",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['standard',\n",
       " 'goalkeeping',\n",
       " 'advanced_goalkeeping',\n",
       " 'shooting',\n",
       " 'passing',\n",
       " 'passing_types',\n",
       " 'goal_shot_creation',\n",
       " 'defensive_actions',\n",
       " 'possession',\n",
       " 'playing_time',\n",
       " 'misc']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fbref.list_stat_types()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "99cf8346-4d24-46f2-9217-7425e96dee69",
   "metadata": {},
   "source": [
    "## Get stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "47cc9ddc-f3a8-4dff-a1c2-d84524cb30fe",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/martin/repos/penaltyblog/examples/scrapers/../../penaltyblog/scrapers/fbref.py:233: FutureWarning: Passing literal html to 'read_html' is deprecated and will be removed in a future version. To read from a literal string, wrap it in a 'StringIO' object.\n",
      "  dfs = pd.read_html(content)\n"
     ]
    }
   ],
   "source": [
    "stats = fbref.get_stats(\"standard\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "34c8172f-b721-4f44-ad00-962a1c81adb0",
   "metadata": {
    "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>nation</th>\n",
       "      <th>pos</th>\n",
       "      <th>squad</th>\n",
       "      <th>born</th>\n",
       "      <th>playing_time_mp</th>\n",
       "      <th>playing_time_starts</th>\n",
       "      <th>playing_time_min</th>\n",
       "      <th>playing_time_90s</th>\n",
       "      <th>performance_gls</th>\n",
       "      <th>performance_ast</th>\n",
       "      <th>...</th>\n",
       "      <th>per_90_minutes_g-pk</th>\n",
       "      <th>per_90_minutes_g+a-pk</th>\n",
       "      <th>per_90_minutes_xg</th>\n",
       "      <th>per_90_minutes_xag</th>\n",
       "      <th>per_90_minutes_xg+xag</th>\n",
       "      <th>per_90_minutes_npxg</th>\n",
       "      <th>per_90_minutes_npxg+xag</th>\n",
       "      <th>season</th>\n",
       "      <th>competition</th>\n",
       "      <th>age_years</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>player</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>Aaron Cresswell</th>\n",
       "      <td>eng ENG</td>\n",
       "      <td>DF</td>\n",
       "      <td>West Ham</td>\n",
       "      <td>1989</td>\n",
       "      <td>28.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2235.0</td>\n",
       "      <td>24.8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.16</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aaron Hickey</th>\n",
       "      <td>sct SCO</td>\n",
       "      <td>DF</td>\n",
       "      <td>Brentford</td>\n",
       "      <td>2002</td>\n",
       "      <td>26.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1916.0</td>\n",
       "      <td>21.3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.04</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aaron Ramsdale</th>\n",
       "      <td>eng ENG</td>\n",
       "      <td>GK</td>\n",
       "      <td>Arsenal</td>\n",
       "      <td>1998</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aaron Wan-Bissaka</th>\n",
       "      <td>eng ENG</td>\n",
       "      <td>DF</td>\n",
       "      <td>Manchester Utd</td>\n",
       "      <td>1997</td>\n",
       "      <td>19.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1435.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.14</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abdoulaye Doucouré</th>\n",
       "      <td>ml MLI</td>\n",
       "      <td>MF</td>\n",
       "      <td>Everton</td>\n",
       "      <td>1993</td>\n",
       "      <td>25.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1533.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.27</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     nation pos           squad  born  playing_time_mp  \\\n",
       "player                                                                   \n",
       "Aaron Cresswell     eng ENG  DF        West Ham  1989             28.0   \n",
       "Aaron Hickey        sct SCO  DF       Brentford  2002             26.0   \n",
       "Aaron Ramsdale      eng ENG  GK         Arsenal  1998             38.0   \n",
       "Aaron Wan-Bissaka   eng ENG  DF  Manchester Utd  1997             19.0   \n",
       "Abdoulaye Doucouré   ml MLI  MF         Everton  1993             25.0   \n",
       "\n",
       "                    playing_time_starts  playing_time_min  playing_time_90s  \\\n",
       "player                                                                        \n",
       "Aaron Cresswell                    24.0            2235.0              24.8   \n",
       "Aaron Hickey                       23.0            1916.0              21.3   \n",
       "Aaron Ramsdale                     38.0            3420.0              38.0   \n",
       "Aaron Wan-Bissaka                  16.0            1435.0              15.9   \n",
       "Abdoulaye Doucouré                 17.0            1533.0              17.0   \n",
       "\n",
       "                   performance_gls performance_ast  ... per_90_minutes_g-pk  \\\n",
       "player                                              ...                       \n",
       "Aaron Cresswell                  0               1  ...                0.00   \n",
       "Aaron Hickey                     0               1  ...                0.00   \n",
       "Aaron Ramsdale                   0               0  ...                0.00   \n",
       "Aaron Wan-Bissaka                0               0  ...                0.00   \n",
       "Abdoulaye Doucouré               5               2  ...                0.29   \n",
       "\n",
       "                   per_90_minutes_g+a-pk per_90_minutes_xg per_90_minutes_xag  \\\n",
       "player                                                                          \n",
       "Aaron Cresswell                     0.04              0.01               0.15   \n",
       "Aaron Hickey                        0.05              0.02               0.02   \n",
       "Aaron Ramsdale                      0.00              0.00               0.00   \n",
       "Aaron Wan-Bissaka                   0.00              0.07               0.06   \n",
       "Abdoulaye Doucouré                  0.41              0.14               0.13   \n",
       "\n",
       "                   per_90_minutes_xg+xag per_90_minutes_npxg  \\\n",
       "player                                                         \n",
       "Aaron Cresswell                     0.16                0.01   \n",
       "Aaron Hickey                        0.04                0.02   \n",
       "Aaron Ramsdale                      0.00                0.00   \n",
       "Aaron Wan-Bissaka                   0.14                0.07   \n",
       "Abdoulaye Doucouré                  0.27                0.14   \n",
       "\n",
       "                    per_90_minutes_npxg+xag     season         competition  \\\n",
       "player                                                                       \n",
       "Aaron Cresswell                        0.16  2022-2023  ENG Premier League   \n",
       "Aaron Hickey                           0.04  2022-2023  ENG Premier League   \n",
       "Aaron Ramsdale                         0.00  2022-2023  ENG Premier League   \n",
       "Aaron Wan-Bissaka                      0.14  2022-2023  ENG Premier League   \n",
       "Abdoulaye Doucouré                     0.27  2022-2023  ENG Premier League   \n",
       "\n",
       "                    age_years  \n",
       "player                         \n",
       "Aaron Cresswell          32.0  \n",
       "Aaron Hickey             20.0  \n",
       "Aaron Ramsdale           24.0  \n",
       "Aaron Wan-Bissaka        24.0  \n",
       "Abdoulaye Doucouré       29.0  \n",
       "\n",
       "[5 rows x 36 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stats[\"players\"].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5b2e972b-5ed1-4ff6-b501-e140c02dbe82",
   "metadata": {
    "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>#_pl</th>\n",
       "      <th>age</th>\n",
       "      <th>poss</th>\n",
       "      <th>playing_time_mp</th>\n",
       "      <th>playing_time_starts</th>\n",
       "      <th>playing_time_min</th>\n",
       "      <th>playing_time_90s</th>\n",
       "      <th>performance_gls</th>\n",
       "      <th>performance_ast</th>\n",
       "      <th>performance_g+a</th>\n",
       "      <th>...</th>\n",
       "      <th>per_90_minutes_g+a</th>\n",
       "      <th>per_90_minutes_g-pk</th>\n",
       "      <th>per_90_minutes_g+a-pk</th>\n",
       "      <th>per_90_minutes_xg</th>\n",
       "      <th>per_90_minutes_xag</th>\n",
       "      <th>per_90_minutes_xg+xag</th>\n",
       "      <th>per_90_minutes_npxg</th>\n",
       "      <th>per_90_minutes_npxg+xag</th>\n",
       "      <th>season</th>\n",
       "      <th>competition</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>squad</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>Arsenal</th>\n",
       "      <td>26</td>\n",
       "      <td>24.7</td>\n",
       "      <td>59.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>84</td>\n",
       "      <td>64</td>\n",
       "      <td>148</td>\n",
       "      <td>...</td>\n",
       "      <td>3.89</td>\n",
       "      <td>2.13</td>\n",
       "      <td>3.82</td>\n",
       "      <td>1.88</td>\n",
       "      <td>1.41</td>\n",
       "      <td>3.29</td>\n",
       "      <td>1.81</td>\n",
       "      <td>3.22</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aston Villa</th>\n",
       "      <td>26</td>\n",
       "      <td>27.0</td>\n",
       "      <td>49.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>49</td>\n",
       "      <td>35</td>\n",
       "      <td>84</td>\n",
       "      <td>...</td>\n",
       "      <td>2.21</td>\n",
       "      <td>1.21</td>\n",
       "      <td>2.13</td>\n",
       "      <td>1.32</td>\n",
       "      <td>1.02</td>\n",
       "      <td>2.34</td>\n",
       "      <td>1.24</td>\n",
       "      <td>2.26</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bournemouth</th>\n",
       "      <td>31</td>\n",
       "      <td>26.3</td>\n",
       "      <td>40.4</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>37</td>\n",
       "      <td>24</td>\n",
       "      <td>61</td>\n",
       "      <td>...</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.61</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.76</td>\n",
       "      <td>1.01</td>\n",
       "      <td>1.76</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brentford</th>\n",
       "      <td>25</td>\n",
       "      <td>26.2</td>\n",
       "      <td>43.8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>56</td>\n",
       "      <td>36</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>2.42</td>\n",
       "      <td>1.29</td>\n",
       "      <td>2.24</td>\n",
       "      <td>1.48</td>\n",
       "      <td>1.01</td>\n",
       "      <td>2.49</td>\n",
       "      <td>1.32</td>\n",
       "      <td>2.33</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brighton</th>\n",
       "      <td>29</td>\n",
       "      <td>26.3</td>\n",
       "      <td>60.2</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>68</td>\n",
       "      <td>46</td>\n",
       "      <td>114</td>\n",
       "      <td>...</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.63</td>\n",
       "      <td>2.84</td>\n",
       "      <td>1.93</td>\n",
       "      <td>1.37</td>\n",
       "      <td>3.30</td>\n",
       "      <td>1.81</td>\n",
       "      <td>3.19</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             #_pl   age  poss  playing_time_mp  playing_time_starts  \\\n",
       "squad                                                                 \n",
       "Arsenal        26  24.7  59.3             38.0                418.0   \n",
       "Aston Villa    26  27.0  49.3             38.0                418.0   \n",
       "Bournemouth    31  26.3  40.4             38.0                418.0   \n",
       "Brentford      25  26.2  43.8             38.0                418.0   \n",
       "Brighton       29  26.3  60.2             38.0                418.0   \n",
       "\n",
       "             playing_time_min  playing_time_90s  performance_gls  \\\n",
       "squad                                                              \n",
       "Arsenal                3420.0              38.0               84   \n",
       "Aston Villa            3420.0              38.0               49   \n",
       "Bournemouth            3420.0              38.0               37   \n",
       "Brentford              3420.0              38.0               56   \n",
       "Brighton               3420.0              38.0               68   \n",
       "\n",
       "             performance_ast  performance_g+a  ...  per_90_minutes_g+a  \\\n",
       "squad                                          ...                       \n",
       "Arsenal                   64              148  ...                3.89   \n",
       "Aston Villa               35               84  ...                2.21   \n",
       "Bournemouth               24               61  ...                1.61   \n",
       "Brentford                 36               92  ...                2.42   \n",
       "Brighton                  46              114  ...                3.00   \n",
       "\n",
       "             per_90_minutes_g-pk  per_90_minutes_g+a-pk  per_90_minutes_xg  \\\n",
       "squad                                                                        \n",
       "Arsenal                     2.13                   3.82               1.88   \n",
       "Aston Villa                 1.21                   2.13               1.32   \n",
       "Bournemouth                 0.97                   1.61               1.01   \n",
       "Brentford                   1.29                   2.24               1.48   \n",
       "Brighton                    1.63                   2.84               1.93   \n",
       "\n",
       "             per_90_minutes_xag  per_90_minutes_xg+xag  per_90_minutes_npxg  \\\n",
       "squad                                                                         \n",
       "Arsenal                    1.41                   3.29                 1.81   \n",
       "Aston Villa                1.02                   2.34                 1.24   \n",
       "Bournemouth                0.75                   1.76                 1.01   \n",
       "Brentford                  1.01                   2.49                 1.32   \n",
       "Brighton                   1.37                   3.30                 1.81   \n",
       "\n",
       "             per_90_minutes_npxg+xag     season         competition  \n",
       "squad                                                                \n",
       "Arsenal                         3.22  2022-2023  ENG Premier League  \n",
       "Aston Villa                     2.26  2022-2023  ENG Premier League  \n",
       "Bournemouth                     1.76  2022-2023  ENG Premier League  \n",
       "Brentford                       2.33  2022-2023  ENG Premier League  \n",
       "Brighton                        3.19  2022-2023  ENG Premier League  \n",
       "\n",
       "[5 rows x 33 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stats[\"squad_for\"].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5e0d3dbd-eb49-4349-ad80-d07e32c32537",
   "metadata": {
    "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>#_pl</th>\n",
       "      <th>age</th>\n",
       "      <th>poss</th>\n",
       "      <th>playing_time_mp</th>\n",
       "      <th>playing_time_starts</th>\n",
       "      <th>playing_time_min</th>\n",
       "      <th>playing_time_90s</th>\n",
       "      <th>performance_gls</th>\n",
       "      <th>performance_ast</th>\n",
       "      <th>performance_g+a</th>\n",
       "      <th>...</th>\n",
       "      <th>per_90_minutes_g+a</th>\n",
       "      <th>per_90_minutes_g-pk</th>\n",
       "      <th>per_90_minutes_g+a-pk</th>\n",
       "      <th>per_90_minutes_xg</th>\n",
       "      <th>per_90_minutes_xag</th>\n",
       "      <th>per_90_minutes_xg+xag</th>\n",
       "      <th>per_90_minutes_npxg</th>\n",
       "      <th>per_90_minutes_npxg+xag</th>\n",
       "      <th>season</th>\n",
       "      <th>competition</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>squad</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>vs Arsenal</th>\n",
       "      <td>26</td>\n",
       "      <td>26.7</td>\n",
       "      <td>40.1</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>42</td>\n",
       "      <td>27</td>\n",
       "      <td>69</td>\n",
       "      <td>...</td>\n",
       "      <td>1.82</td>\n",
       "      <td>1.03</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.10</td>\n",
       "      <td>0.83</td>\n",
       "      <td>1.93</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vs Aston Villa</th>\n",
       "      <td>26</td>\n",
       "      <td>26.5</td>\n",
       "      <td>50.6</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>42</td>\n",
       "      <td>25</td>\n",
       "      <td>67</td>\n",
       "      <td>...</td>\n",
       "      <td>1.76</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.63</td>\n",
       "      <td>1.38</td>\n",
       "      <td>0.95</td>\n",
       "      <td>2.33</td>\n",
       "      <td>1.26</td>\n",
       "      <td>2.21</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vs Bournemouth</th>\n",
       "      <td>31</td>\n",
       "      <td>26.6</td>\n",
       "      <td>59.9</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>68</td>\n",
       "      <td>49</td>\n",
       "      <td>117</td>\n",
       "      <td>...</td>\n",
       "      <td>3.08</td>\n",
       "      <td>1.63</td>\n",
       "      <td>2.92</td>\n",
       "      <td>1.68</td>\n",
       "      <td>1.19</td>\n",
       "      <td>2.87</td>\n",
       "      <td>1.54</td>\n",
       "      <td>2.73</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vs Brentford</th>\n",
       "      <td>25</td>\n",
       "      <td>26.6</td>\n",
       "      <td>56.6</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>43</td>\n",
       "      <td>30</td>\n",
       "      <td>73</td>\n",
       "      <td>...</td>\n",
       "      <td>1.92</td>\n",
       "      <td>1.08</td>\n",
       "      <td>1.87</td>\n",
       "      <td>1.28</td>\n",
       "      <td>0.94</td>\n",
       "      <td>2.22</td>\n",
       "      <td>1.25</td>\n",
       "      <td>2.19</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vs Brighton</th>\n",
       "      <td>29</td>\n",
       "      <td>26.5</td>\n",
       "      <td>39.5</td>\n",
       "      <td>38.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>47</td>\n",
       "      <td>34</td>\n",
       "      <td>81</td>\n",
       "      <td>...</td>\n",
       "      <td>2.13</td>\n",
       "      <td>1.08</td>\n",
       "      <td>1.97</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.89</td>\n",
       "      <td>2.21</td>\n",
       "      <td>1.15</td>\n",
       "      <td>2.04</td>\n",
       "      <td>2022-2023</td>\n",
       "      <td>ENG Premier League</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                #_pl   age  poss  playing_time_mp  playing_time_starts  \\\n",
       "squad                                                                    \n",
       "vs Arsenal        26  26.7  40.1             38.0                418.0   \n",
       "vs Aston Villa    26  26.5  50.6             38.0                418.0   \n",
       "vs Bournemouth    31  26.6  59.9             38.0                418.0   \n",
       "vs Brentford      25  26.6  56.6             38.0                418.0   \n",
       "vs Brighton       29  26.5  39.5             38.0                418.0   \n",
       "\n",
       "                playing_time_min  playing_time_90s  performance_gls  \\\n",
       "squad                                                                 \n",
       "vs Arsenal                3420.0              38.0               42   \n",
       "vs Aston Villa            3420.0              38.0               42   \n",
       "vs Bournemouth            3420.0              38.0               68   \n",
       "vs Brentford              3420.0              38.0               43   \n",
       "vs Brighton               3420.0              38.0               47   \n",
       "\n",
       "                performance_ast  performance_g+a  ...  per_90_minutes_g+a  \\\n",
       "squad                                             ...                       \n",
       "vs Arsenal                   27               69  ...                1.82   \n",
       "vs Aston Villa               25               67  ...                1.76   \n",
       "vs Bournemouth               49              117  ...                3.08   \n",
       "vs Brentford                 30               73  ...                1.92   \n",
       "vs Brighton                  34               81  ...                2.13   \n",
       "\n",
       "                per_90_minutes_g-pk  per_90_minutes_g+a-pk  per_90_minutes_xg  \\\n",
       "squad                                                                           \n",
       "vs Arsenal                     1.03                   1.74               1.10   \n",
       "vs Aston Villa                 0.97                   1.63               1.38   \n",
       "vs Bournemouth                 1.63                   2.92               1.68   \n",
       "vs Brentford                   1.08                   1.87               1.28   \n",
       "vs Brighton                    1.08                   1.97               1.32   \n",
       "\n",
       "                per_90_minutes_xag  per_90_minutes_xg+xag  \\\n",
       "squad                                                       \n",
       "vs Arsenal                    0.83                   1.93   \n",
       "vs Aston Villa                0.95                   2.33   \n",
       "vs Bournemouth                1.19                   2.87   \n",
       "vs Brentford                  0.94                   2.22   \n",
       "vs Brighton                   0.89                   2.21   \n",
       "\n",
       "                per_90_minutes_npxg  per_90_minutes_npxg+xag     season  \\\n",
       "squad                                                                     \n",
       "vs Arsenal                     1.00                     1.83  2022-2023   \n",
       "vs Aston Villa                 1.26                     2.21  2022-2023   \n",
       "vs Bournemouth                 1.54                     2.73  2022-2023   \n",
       "vs Brentford                   1.25                     2.19  2022-2023   \n",
       "vs Brighton                    1.15                     2.04  2022-2023   \n",
       "\n",
       "                       competition  \n",
       "squad                               \n",
       "vs Arsenal      ENG Premier League  \n",
       "vs Aston Villa  ENG Premier League  \n",
       "vs Bournemouth  ENG Premier League  \n",
       "vs Brentford    ENG Premier League  \n",
       "vs Brighton     ENG Premier League  \n",
       "\n",
       "[5 rows x 33 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stats[\"squad_against\"].head()"
   ]
  }
 ],
 "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.13.0"
  },
  "vscode": {
   "interpreter": {
    "hash": "5c7b89af1651d0b8571dde13640ecdccf7d5a6204171d6ab33e7c296e100e08a"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}