data_collection.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c9fb3808",
   "metadata": {},
   "source": [
    "Data for both season standings and NCAA Tournament exist from 1939-onwards. However, 2019-20 season should be ignored because the 2020 tournament was cancelled that season."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "31e7e4d3",
   "metadata": {},
   "source": [
    "I intend to use 1985 onwards because that's when the modern format began"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 277,
   "id": "55b9cdf5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import os\n",
    "from bs4 import BeautifulSoup as bs\n",
    "from bs4 import Comment"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "2a2fd548",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 293,
   "id": "bc737f52",
   "metadata": {},
   "outputs": [],
   "source": [
    "import re"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6f34bd12",
   "metadata": {},
   "source": [
    "### Get HTML Data of Tournament Results "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "ef20e4ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "years = list(range(1985, 2024))\n",
    "years.remove(2020)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "006fe7c4",
   "metadata": {},
   "outputs": [],
   "source": [
    "url_tournament = \"https://www.sports-reference.com/cbb/postseason/men/{}-ncaa.html\"\n",
    "\n",
    "for year in years:\n",
    "    url = url_tournament.format(year)\n",
    "    \n",
    "    data = requests.get(url)\n",
    "    \n",
    "    with open(f\"tournament/{year}.html\", \"w+\") as f:\n",
    "        f.write(data.text)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d10d7d81",
   "metadata": {},
   "source": [
    "### Parse HTML Data of Tounament Results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 453,
   "id": "ce8326d7",
   "metadata": {},
   "outputs": [],
   "source": [
    "def parse_tournament_html(year):\n",
    "    with open(f\"tournament/{year}.html\") as f:\n",
    "        page = f.read()\n",
    "    soup = bs(page, 'html.parser')\n",
    "    brackets = soup.find(\"div\", {\"id\": \"brackets\"})\n",
    "    if brackets:\n",
    "        children = []\n",
    "        for child in brackets.findChildren():\n",
    "            child_id = child.get(\"id\")\n",
    "            if not child_id == None and not child_id == \"bracket\":\n",
    "                children.append(child_id)\n",
    "        return year, children, brackets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 454,
   "id": "780333f5",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def parse_brackets(year):\n",
    "    data = []\n",
    "    \n",
    "    brackets = parse_tournament_html(year)\n",
    "    \n",
    "    for b in brackets[1]:\n",
    "        rounds = brackets[2].find(\"div\", {\"id\": b}).find_all(\"div\", {\"class\": \"round\"})\n",
    "\n",
    "        if b != \"national\":\n",
    "            round_names = [\"First Round\", \"Second Round\", \"Sweet Sixteen\", \"Elite Eight\"]\n",
    "        else:\n",
    "            round_names = [\"Final Four\", \"National Championship\"]\n",
    "\n",
    "        for r in rounds[:-1]:\n",
    "            games = r.find_all(\"div\", recursive=False)\n",
    "            for g in games:\n",
    "                g_items = g.find_all(recursive=False)\n",
    "\n",
    "                team_one_wins = False\n",
    "\n",
    "                t1 = g_items[0]\n",
    "                i1 = t1.find_all(recursive=False)\n",
    "                \n",
    "                if len(i1) == 2:\n",
    "                    # Oregon vs VCU in 2021 was cancelled\n",
    "                    continue\n",
    "\n",
    "                t2 = g_items[1]\n",
    "                i2 = t2.find_all(recursive=False)\n",
    "\n",
    "\n",
    "                if t1.get(\"class\") == [\"winner\"]:\n",
    "                    team_one_wins = True\n",
    "\n",
    "\n",
    "                data.append({\n",
    "                    'year': year,\n",
    "                    'bracket': b.title(),\n",
    "                    'round': round_names[0],\n",
    "                    'location': g_items[-1].getText().replace('at', '').strip(),\n",
    "                    'team_one_rank': i1[0].getText(),\n",
    "                    'team_one': i1[1].getText(),\n",
    "                    'team_one_score': i1[2].getText(),\n",
    "                    'team_two_rank': i2[0].getText(),\n",
    "                    'team_two': i2[1].getText(),\n",
    "                    'team_two_score': i2[2].getText(),\n",
    "                    'team_one_wins': team_one_wins\n",
    "                })\n",
    "            round_names.pop(0)\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1dc2db54",
   "metadata": {},
   "outputs": [],
   "source": [
    "bracket_data = []\n",
    "for year in years:\n",
    "    try:\n",
    "        bracket_data.extend(parse_brackets(year))\n",
    "    except:\n",
    "        print(year)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "44eda596",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(data)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "id": "d65372c5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data/tournaments.csv', sep=',', index=False, encoding='utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "59713cbf",
   "metadata": {},
   "source": [
    "### Get Data of Season Standings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "id": "be8aa427",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2021, 2022, 2023]\n"
     ]
    }
   ],
   "source": [
    "print(years)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "id": "e2df5be8",
   "metadata": {},
   "outputs": [],
   "source": [
    "url_season = \"https://www.sports-reference.com/cbb/seasons/men/{}-standings.html\"\n",
    "\n",
    "for year in range(2015, 2024):\n",
    "    url = url_season.format(year)\n",
    "    \n",
    "    data = requests.get(url)\n",
    "    \n",
    "    with open(f\"seasons/{year}.html\", \"w+\") as f:\n",
    "        f.write(data.text)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fdffa196",
   "metadata": {},
   "source": [
    "### Parse HTML Data of Season Standings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 424,
   "id": "ff2882db",
   "metadata": {},
   "outputs": [],
   "source": [
    "def parse_standings(year):\n",
    "    data = []\n",
    "    with open(f\"seasons/{year}.html\") as f:\n",
    "        page = f.read()\n",
    "    soup = bs(page, 'html.parser')\n",
    "    conferences = soup.find(\"div\", {\"id\": \"content\"})\n",
    "\n",
    "    for c in conferences.find_all(\"div\", recursive=False):\n",
    "        if c.get('id') and 'all_standings' in c.get('id'):\n",
    "            conf = ' '.join(c.get('id')[len('all_standings') + 1:].split('-'))\n",
    "            \n",
    "            for child in c.descendants:\n",
    "                if isinstance(child, Comment):\n",
    "                    parsed_child = BeautifulSoup(child.string, \"html\")\n",
    "                    for t in parsed_child.find_all(\"tr\")[2:]:\n",
    "                        info = [h.getText() for h in t.find_all(recursive=False)]\n",
    "                        \n",
    "                        conference_tournament_champion = False\n",
    "                        if info[21]:\n",
    "                            for i in info[21].split(\";\"):\n",
    "                                if 'Conf. Tournament Champion' in i:\n",
    "                                    conference_tournament_champion = True\n",
    "                        \n",
    "                        \n",
    "                        data.append({\n",
    "                            'year': year,\n",
    "                            'conference': info[2],\n",
    "                            'rank': int(info[0]) if info[0] else None,\n",
    "                            'team': info[1],\n",
    "                            'overall_wins': int(info[3]) if info[3] else None,\n",
    "                            'overall_losses': int(info[4]) if info[4] else None,\n",
    "                            'overall_win_loss_percentage': float(info[5]) if info[5] else None,\n",
    "                            'conference_wins': int(info[7]) if info[7] else None,\n",
    "                            'conference_losses': int(info[8]) if info[8] else None,\n",
    "                            'conference_win_loss_percentage': float(info[9]) if info[9] else None,\n",
    "                            'own_points_per_game': float(info[11]) if info[11] else None,\n",
    "                            'opp_points_per_game': float(info[12]) if info[12] else None,\n",
    "                            'strength_of_schedule': float(info[14]) if info[14] else None,\n",
    "                            'simple_rating_system': float(info[15]) if info[15] else None,\n",
    "                            'ap_pre': int(info[17]) if info[17] else None,\n",
    "                            'ap_high': int(info[18]) if info[18] else None,\n",
    "                            'ap_final': int(info[19]) if info[19] else None,\n",
    "                            'conference_tournament_champion': conference_tournament_champion\n",
    "                        })\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 425,
   "id": "87888e13",
   "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>year</th>\n",
       "      <th>conference</th>\n",
       "      <th>rank</th>\n",
       "      <th>team</th>\n",
       "      <th>overall_wins</th>\n",
       "      <th>overall_losses</th>\n",
       "      <th>overall_win_loss_percentage</th>\n",
       "      <th>conference_wins</th>\n",
       "      <th>conference_losses</th>\n",
       "      <th>conference_win_loss_percentage</th>\n",
       "      <th>own_points_per_game</th>\n",
       "      <th>opp_points_per_game</th>\n",
       "      <th>strength_of_schedule</th>\n",
       "      <th>simple_rating_system</th>\n",
       "      <th>ap_pre</th>\n",
       "      <th>ap_high</th>\n",
       "      <th>ap_final</th>\n",
       "      <th>conference_tournament_champion</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1985</td>\n",
       "      <td>ACC</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Georgia Tech</td>\n",
       "      <td>27.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.771</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.643</td>\n",
       "      <td>69.9</td>\n",
       "      <td>60.9</td>\n",
       "      <td>16.45</td>\n",
       "      <td>7.42</td>\n",
       "      <td>20.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1985</td>\n",
       "      <td>ACC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>North Carolina</td>\n",
       "      <td>27.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.750</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.643</td>\n",
       "      <td>73.1</td>\n",
       "      <td>65.9</td>\n",
       "      <td>15.33</td>\n",
       "      <td>8.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1985</td>\n",
       "      <td>ACC</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NC State</td>\n",
       "      <td>23.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.697</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.643</td>\n",
       "      <td>73.3</td>\n",
       "      <td>65.0</td>\n",
       "      <td>15.02</td>\n",
       "      <td>6.78</td>\n",
       "      <td>13.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1985</td>\n",
       "      <td>ACC</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Duke</td>\n",
       "      <td>23.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.742</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.571</td>\n",
       "      <td>78.9</td>\n",
       "      <td>67.9</td>\n",
       "      <td>18.38</td>\n",
       "      <td>7.38</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1985</td>\n",
       "      <td>ACC</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Maryland</td>\n",
       "      <td>25.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.676</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.571</td>\n",
       "      <td>70.8</td>\n",
       "      <td>65.3</td>\n",
       "      <td>13.92</td>\n",
       "      <td>8.47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12453</th>\n",
       "      <td>2023</td>\n",
       "      <td>WCC</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Brigham Young</td>\n",
       "      <td>19.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.559</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.438</td>\n",
       "      <td>74.1</td>\n",
       "      <td>70.1</td>\n",
       "      <td>9.43</td>\n",
       "      <td>5.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12454</th>\n",
       "      <td>2023</td>\n",
       "      <td>WCC</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Pacific</td>\n",
       "      <td>15.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.455</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.438</td>\n",
       "      <td>75.8</td>\n",
       "      <td>78.4</td>\n",
       "      <td>-0.56</td>\n",
       "      <td>2.05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12455</th>\n",
       "      <td>2023</td>\n",
       "      <td>WCC</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Portland</td>\n",
       "      <td>14.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.424</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.313</td>\n",
       "      <td>76.7</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.68</td>\n",
       "      <td>4.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12456</th>\n",
       "      <td>2023</td>\n",
       "      <td>WCC</td>\n",
       "      <td>9.0</td>\n",
       "      <td>San Diego</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.355</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.250</td>\n",
       "      <td>76.3</td>\n",
       "      <td>81.6</td>\n",
       "      <td>-2.06</td>\n",
       "      <td>3.28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12457</th>\n",
       "      <td>2023</td>\n",
       "      <td>WCC</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Pepperdine</td>\n",
       "      <td>9.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.290</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.125</td>\n",
       "      <td>76.9</td>\n",
       "      <td>81.8</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>4.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12458 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       year conference  rank            team  overall_wins  overall_losses  \\\n",
       "0      1985        ACC   1.0    Georgia Tech          27.0             8.0   \n",
       "1      1985        ACC   2.0  North Carolina          27.0             9.0   \n",
       "2      1985        ACC   3.0        NC State          23.0            10.0   \n",
       "3      1985        ACC   4.0            Duke          23.0             8.0   \n",
       "4      1985        ACC   5.0        Maryland          25.0            12.0   \n",
       "...     ...        ...   ...             ...           ...             ...   \n",
       "12453  2023        WCC   6.0   Brigham Young          19.0            15.0   \n",
       "12454  2023        WCC   7.0         Pacific          15.0            18.0   \n",
       "12455  2023        WCC   8.0        Portland          14.0            19.0   \n",
       "12456  2023        WCC   9.0       San Diego          11.0            20.0   \n",
       "12457  2023        WCC  10.0      Pepperdine           9.0            22.0   \n",
       "\n",
       "       overall_win_loss_percentage  conference_wins  conference_losses  \\\n",
       "0                            0.771              9.0                5.0   \n",
       "1                            0.750              9.0                5.0   \n",
       "2                            0.697              9.0                5.0   \n",
       "3                            0.742              8.0                6.0   \n",
       "4                            0.676              8.0                6.0   \n",
       "...                            ...              ...                ...   \n",
       "12453                        0.559              7.0                9.0   \n",
       "12454                        0.455              7.0                9.0   \n",
       "12455                        0.424              5.0               11.0   \n",
       "12456                        0.355              4.0               12.0   \n",
       "12457                        0.290              2.0               14.0   \n",
       "\n",
       "       conference_win_loss_percentage  own_points_per_game  \\\n",
       "0                               0.643                 69.9   \n",
       "1                               0.643                 73.1   \n",
       "2                               0.643                 73.3   \n",
       "3                               0.571                 78.9   \n",
       "4                               0.571                 70.8   \n",
       "...                               ...                  ...   \n",
       "12453                           0.438                 74.1   \n",
       "12454                           0.438                 75.8   \n",
       "12455                           0.313                 76.7   \n",
       "12456                           0.250                 76.3   \n",
       "12457                           0.125                 76.9   \n",
       "\n",
       "       opp_points_per_game  strength_of_schedule  simple_rating_system  \\\n",
       "0                     60.9                 16.45                  7.42   \n",
       "1                     65.9                 15.33                  8.13   \n",
       "2                     65.0                 15.02                  6.78   \n",
       "3                     67.9                 18.38                  7.38   \n",
       "4                     65.3                 13.92                  8.47   \n",
       "...                    ...                   ...                   ...   \n",
       "12453                 70.1                  9.43                  5.40   \n",
       "12454                 78.4                 -0.56                  2.05   \n",
       "12455                 79.1                  1.68                  4.13   \n",
       "12456                 81.6                 -2.06                  3.28   \n",
       "12457                 81.8                 -0.12                  4.71   \n",
       "\n",
       "       ap_pre  ap_high  ap_final  conference_tournament_champion  \n",
       "0        20.0      6.0       6.0                            True  \n",
       "1         NaN      5.0       7.0                           False  \n",
       "2        13.0      9.0      16.0                           False  \n",
       "3         6.0      2.0      10.0                           False  \n",
       "4         NaN     17.0       NaN                           False  \n",
       "...       ...      ...       ...                             ...  \n",
       "12453     NaN      NaN       NaN                           False  \n",
       "12454     NaN      NaN       NaN                           False  \n",
       "12455     NaN      NaN       NaN                           False  \n",
       "12456     NaN      NaN       NaN                           False  \n",
       "12457     NaN      NaN       NaN                           False  \n",
       "\n",
       "[12458 rows x 18 columns]"
      ]
     },
     "execution_count": 425,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "standings_data = []\n",
    "\n",
    "for year in years:\n",
    "    standings_data.extend(parse_standings(year))\n",
    "\n",
    "df2 = pd.DataFrame(standings_data)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 452,
   "id": "7a0361cd",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv('data/standings.csv', sep=',', index=False, encoding='utf-8')"
   ]
  }
 ],
 "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}