{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "4100353f-21f2-4ef2-acc6-7c432af14afa",
   "metadata": {},
   "source": [
    "# Club Elo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "605fd454-caf3-4680-89d1-ae836f3e1bf2",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import sys\n",
    "\n",
    "sys.path.append(\"../../\")\n",
    "\n",
    "from penaltyblog.scrapers import ClubElo"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ba3c458d-0832-408e-b9de-b8135ff881e7",
   "metadata": {},
   "source": [
    "### Download all ELO ratings on the 1st January 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7e71b59e-1fb5-4a11-90b3-ef8ce5837b4a",
   "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>rank</th>\n",
       "      <th>country</th>\n",
       "      <th>level</th>\n",
       "      <th>elo</th>\n",
       "      <th>from</th>\n",
       "      <th>to</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Liverpool</th>\n",
       "      <td>1.0</td>\n",
       "      <td>ENG</td>\n",
       "      <td>1</td>\n",
       "      <td>2075.851318</td>\n",
       "      <td>2019-12-30</td>\n",
       "      <td>2020-01-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Man City</th>\n",
       "      <td>2.0</td>\n",
       "      <td>ENG</td>\n",
       "      <td>1</td>\n",
       "      <td>2001.572021</td>\n",
       "      <td>2019-12-30</td>\n",
       "      <td>2020-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Barcelona</th>\n",
       "      <td>3.0</td>\n",
       "      <td>ESP</td>\n",
       "      <td>1</td>\n",
       "      <td>1985.365845</td>\n",
       "      <td>2019-12-22</td>\n",
       "      <td>2020-01-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bayern</th>\n",
       "      <td>4.0</td>\n",
       "      <td>GER</td>\n",
       "      <td>1</td>\n",
       "      <td>1941.557129</td>\n",
       "      <td>2019-12-22</td>\n",
       "      <td>2020-01-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Juventus</th>\n",
       "      <td>5.0</td>\n",
       "      <td>ITA</td>\n",
       "      <td>1</td>\n",
       "      <td>1909.993042</td>\n",
       "      <td>2019-12-19</td>\n",
       "      <td>2020-01-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Santa Coloma</th>\n",
       "      <td>NaN</td>\n",
       "      <td>AND</td>\n",
       "      <td>0</td>\n",
       "      <td>773.999878</td>\n",
       "      <td>2019-08-02</td>\n",
       "      <td>2020-08-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Matecosa Sant Julia</th>\n",
       "      <td>NaN</td>\n",
       "      <td>AND</td>\n",
       "      <td>0</td>\n",
       "      <td>754.937744</td>\n",
       "      <td>2019-08-02</td>\n",
       "      <td>2020-07-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tre Fiori</th>\n",
       "      <td>NaN</td>\n",
       "      <td>SMR</td>\n",
       "      <td>0</td>\n",
       "      <td>707.414734</td>\n",
       "      <td>2019-07-31</td>\n",
       "      <td>2020-08-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tre Penne</th>\n",
       "      <td>NaN</td>\n",
       "      <td>SMR</td>\n",
       "      <td>0</td>\n",
       "      <td>676.546082</td>\n",
       "      <td>2019-07-31</td>\n",
       "      <td>2020-08-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>La Fiorita</th>\n",
       "      <td>NaN</td>\n",
       "      <td>SMR</td>\n",
       "      <td>0</td>\n",
       "      <td>661.198242</td>\n",
       "      <td>2019-07-31</td>\n",
       "      <td>2020-08-08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>642 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     rank country  level          elo       from         to\n",
       "team                                                                       \n",
       "Liverpool             1.0     ENG      1  2075.851318 2019-12-30 2020-01-02\n",
       "Man City              2.0     ENG      1  2001.572021 2019-12-30 2020-01-01\n",
       "Barcelona             3.0     ESP      1  1985.365845 2019-12-22 2020-01-04\n",
       "Bayern                4.0     GER      1  1941.557129 2019-12-22 2020-01-19\n",
       "Juventus              5.0     ITA      1  1909.993042 2019-12-19 2020-01-06\n",
       "...                   ...     ...    ...          ...        ...        ...\n",
       "Santa Coloma          NaN     AND      0   773.999878 2019-08-02 2020-08-08\n",
       "Matecosa Sant Julia   NaN     AND      0   754.937744 2019-08-02 2020-07-01\n",
       "Tre Fiori             NaN     SMR      0   707.414734 2019-07-31 2020-08-08\n",
       "Tre Penne             NaN     SMR      0   676.546082 2019-07-31 2020-08-08\n",
       "La Fiorita            NaN     SMR      0   661.198242 2019-07-31 2020-08-08\n",
       "\n",
       "[642 rows x 6 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ce = ClubElo()\n",
    "\n",
    "ce.get_elo_by_date(\"2020-01-01\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "879c5b9b-e4c1-4277-8ddf-c8941b3909c4",
   "metadata": {},
   "source": [
    "### List all teams available on clubelo.com"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "086709cf-29da-4a60-9fc8-d8bac9ad3e88",
   "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>team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Liverpool</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Man City</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arsenal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Inter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Real Madrid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>FCB Magpies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>Atletic Club Escaldes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>SS Virtus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>627</th>\n",
       "      <td>Tre Penne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>628</th>\n",
       "      <td>La Fiorita</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>629 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      team\n",
       "0                Liverpool\n",
       "1                 Man City\n",
       "2                  Arsenal\n",
       "3                    Inter\n",
       "4              Real Madrid\n",
       "..                     ...\n",
       "624            FCB Magpies\n",
       "625  Atletic Club Escaldes\n",
       "626              SS Virtus\n",
       "627              Tre Penne\n",
       "628             La Fiorita\n",
       "\n",
       "[629 rows x 1 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ce.get_team_names()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "55d29da8-d833-4dba-b7c3-5837743ebc6e",
   "metadata": {},
   "source": [
    "### Download all historical ratings for Bournemouth"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "82bab1de-d4b0-45ee-ad69-bfe828aa53c8",
   "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>rank</th>\n",
       "      <th>team</th>\n",
       "      <th>country</th>\n",
       "      <th>level</th>\n",
       "      <th>elo</th>\n",
       "      <th>to</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>from</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>2024-12-24</th>\n",
       "      <td>34.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>1</td>\n",
       "      <td>1759.336182</td>\n",
       "      <td>2024-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-12-23</th>\n",
       "      <td>34.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>1</td>\n",
       "      <td>1759.336182</td>\n",
       "      <td>2024-12-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-12-17</th>\n",
       "      <td>34.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>1</td>\n",
       "      <td>1759.336182</td>\n",
       "      <td>2024-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-12-11</th>\n",
       "      <td>34.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>1</td>\n",
       "      <td>1759.336182</td>\n",
       "      <td>2024-12-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-12-09</th>\n",
       "      <td>35.0</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>1</td>\n",
       "      <td>1755.398682</td>\n",
       "      <td>2024-12-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-09-01</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>2</td>\n",
       "      <td>1446.301025</td>\n",
       "      <td>1987-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-08-30</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>2</td>\n",
       "      <td>1455.968018</td>\n",
       "      <td>1987-08-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-08-23</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>2</td>\n",
       "      <td>1451.548828</td>\n",
       "      <td>1987-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-08-16</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>2</td>\n",
       "      <td>1441.609131</td>\n",
       "      <td>1987-08-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987-07-01</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bournemouth</td>\n",
       "      <td>ENG</td>\n",
       "      <td>2</td>\n",
       "      <td>1428.954834</td>\n",
       "      <td>1987-08-15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1528 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            rank         team country  level          elo         to\n",
       "from                                                                \n",
       "2024-12-24  34.0  Bournemouth     ENG      1  1759.336182 2024-12-31\n",
       "2024-12-23  34.0  Bournemouth     ENG      1  1759.336182 2024-12-23\n",
       "2024-12-17  34.0  Bournemouth     ENG      1  1759.336182 2024-12-22\n",
       "2024-12-11  34.0  Bournemouth     ENG      1  1759.336182 2024-12-16\n",
       "2024-12-09  35.0  Bournemouth     ENG      1  1755.398682 2024-12-10\n",
       "...          ...          ...     ...    ...          ...        ...\n",
       "1987-09-01   NaN  Bournemouth     ENG      2  1446.301025 1987-09-05\n",
       "1987-08-30   NaN  Bournemouth     ENG      2  1455.968018 1987-08-31\n",
       "1987-08-23   NaN  Bournemouth     ENG      2  1451.548828 1987-08-29\n",
       "1987-08-16   NaN  Bournemouth     ENG      2  1441.609131 1987-08-22\n",
       "1987-07-01   NaN  Bournemouth     ENG      2  1428.954834 1987-08-15\n",
       "\n",
       "[1528 rows x 6 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ce.get_elo_by_team(\"Bournemouth\")"
   ]
  }
 ],
 "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"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}