2022-03-16-ff-elo-over-time.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "d032c8ed",
   "metadata": {},
   "source": [
    "## Import libraries and dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "299a0d9e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "elo_history = pd.read_csv(\"C:\\\\Users\\\\chris\\\\Documents\\\\Datasets\\\\FFL\\\\elo_history.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3e4a4498",
   "metadata": {},
   "source": [
    "## Get list of teams."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "231c6cd1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['CHRIS',\n",
       " 'ANDREW',\n",
       " 'STEVE',\n",
       " 'MATT',\n",
       " 'KYLE',\n",
       " 'CARLEN',\n",
       " 'NATHAN',\n",
       " 'DREW',\n",
       " 'SAM',\n",
       " 'DYLAN',\n",
       " 'NICK',\n",
       " 'JASON',\n",
       " 'NOAH']"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_list = list(elo_history.team_1.unique())\n",
    "team_list"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bb471c40",
   "metadata": {},
   "source": [
    "## Create \"Dates\" column."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "20197b05",
   "metadata": {},
   "outputs": [],
   "source": [
    "dates = list(elo_history.date.unique())\n",
    "dates.insert(0, \"2014-00\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0197e31b",
   "metadata": {},
   "source": [
    "## Initialize team elo rating columns at 0."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "cc949441",
   "metadata": {},
   "outputs": [],
   "source": [
    "elo_dict = {}\n",
    "\n",
    "for i in team_list:\n",
    "    elo_dict[i] = [0] * len(dates)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6106ca3f",
   "metadata": {},
   "source": [
    "## Populate columns with data from elo history dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "e4a2d95b",
   "metadata": {},
   "outputs": [],
   "source": [
    "curr_date = \"\"\n",
    "date_index = 0\n",
    "for index,row in elo_history.iterrows():\n",
    "    if row[\"date\"] != curr_date:\n",
    "        curr_date = row[\"date\"]\n",
    "        date_index += 1\n",
    "        \n",
    "    elo_dict[row[\"team_1\"]][date_index] = round(row[\"team1_elo_post\"])\n",
    "    elo_dict[row[\"team_2\"]][date_index] = round(row[\"team2_elo_post\"])\n",
    "\n",
    "# Add initial rating value of 1500 prior to team's first result.\n",
    "for i in team_list:\n",
    "    for index,j in enumerate(elo_dict[i]):\n",
    "        if (j != 0):\n",
    "            elo_dict[i][index - 1] = 1500\n",
    "            break\n",
    "\n",
    "# Replace values of 0 (due to playoff byes) with team's current rating value.\n",
    "for i in team_list:\n",
    "    for index,j in enumerate(elo_dict[i]):\n",
    "        if (j == 0):\n",
    "            if (index > 0) & (index < len(elo_dict[i]) - 1):\n",
    "                if (elo_dict[i][index - 1] != 0) & (elo_dict[i][index + 1] != 0):\n",
    "                    elo_dict[i][index] = elo_dict[i][index - 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "ed81ce50",
   "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>date</th>\n",
       "      <th>team_1</th>\n",
       "      <th>team_2</th>\n",
       "      <th>win</th>\n",
       "      <th>team1_elo_pre</th>\n",
       "      <th>team2_elo_pre</th>\n",
       "      <th>team1_elo_post</th>\n",
       "      <th>team2_elo_post</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01</td>\n",
       "      <td>CHRIS</td>\n",
       "      <td>CARLEN</td>\n",
       "      <td>0</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1485.000000</td>\n",
       "      <td>1515.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01</td>\n",
       "      <td>ANDREW</td>\n",
       "      <td>KYLE</td>\n",
       "      <td>0</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1485.000000</td>\n",
       "      <td>1515.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01</td>\n",
       "      <td>STEVE</td>\n",
       "      <td>DREW</td>\n",
       "      <td>1</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1515.000000</td>\n",
       "      <td>1485.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01</td>\n",
       "      <td>MATT</td>\n",
       "      <td>NATHAN</td>\n",
       "      <td>1</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>1515.000000</td>\n",
       "      <td>1485.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-02</td>\n",
       "      <td>MATT</td>\n",
       "      <td>CHRIS</td>\n",
       "      <td>1</td>\n",
       "      <td>1515.000000</td>\n",
       "      <td>1485.000000</td>\n",
       "      <td>1528.708005</td>\n",
       "      <td>1471.291995</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559</th>\n",
       "      <td>2021-15</td>\n",
       "      <td>ANDREW</td>\n",
       "      <td>STEVE</td>\n",
       "      <td>1</td>\n",
       "      <td>1566.736021</td>\n",
       "      <td>1544.313236</td>\n",
       "      <td>1580.769293</td>\n",
       "      <td>1530.279964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>560</th>\n",
       "      <td>2021-15</td>\n",
       "      <td>NICK</td>\n",
       "      <td>CHRIS</td>\n",
       "      <td>0</td>\n",
       "      <td>1524.258537</td>\n",
       "      <td>1642.915931</td>\n",
       "      <td>1514.191088</td>\n",
       "      <td>1652.983380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561</th>\n",
       "      <td>2021-15</td>\n",
       "      <td>JASON</td>\n",
       "      <td>SAM</td>\n",
       "      <td>0</td>\n",
       "      <td>1483.865477</td>\n",
       "      <td>1506.451432</td>\n",
       "      <td>1469.839220</td>\n",
       "      <td>1520.477689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>562</th>\n",
       "      <td>2021-15</td>\n",
       "      <td>DYLAN</td>\n",
       "      <td>KYLE</td>\n",
       "      <td>0</td>\n",
       "      <td>1440.436529</td>\n",
       "      <td>1486.708300</td>\n",
       "      <td>1427.422514</td>\n",
       "      <td>1499.722315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>2021-15</td>\n",
       "      <td>MATT</td>\n",
       "      <td>NOAH</td>\n",
       "      <td>1</td>\n",
       "      <td>1368.148791</td>\n",
       "      <td>1492.111812</td>\n",
       "      <td>1388.284599</td>\n",
       "      <td>1471.976003</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>564 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  team_1  team_2  win  team1_elo_pre  team2_elo_pre  \\\n",
       "0    2014-01   CHRIS  CARLEN    0    1500.000000    1500.000000   \n",
       "1    2014-01  ANDREW    KYLE    0    1500.000000    1500.000000   \n",
       "2    2014-01   STEVE    DREW    1    1500.000000    1500.000000   \n",
       "3    2014-01    MATT  NATHAN    1    1500.000000    1500.000000   \n",
       "4    2014-02    MATT   CHRIS    1    1515.000000    1485.000000   \n",
       "..       ...     ...     ...  ...            ...            ...   \n",
       "559  2021-15  ANDREW   STEVE    1    1566.736021    1544.313236   \n",
       "560  2021-15    NICK   CHRIS    0    1524.258537    1642.915931   \n",
       "561  2021-15   JASON     SAM    0    1483.865477    1506.451432   \n",
       "562  2021-15   DYLAN    KYLE    0    1440.436529    1486.708300   \n",
       "563  2021-15    MATT    NOAH    1    1368.148791    1492.111812   \n",
       "\n",
       "     team1_elo_post  team2_elo_post  \n",
       "0       1485.000000     1515.000000  \n",
       "1       1485.000000     1515.000000  \n",
       "2       1515.000000     1485.000000  \n",
       "3       1515.000000     1485.000000  \n",
       "4       1528.708005     1471.291995  \n",
       "..              ...             ...  \n",
       "559     1580.769293     1530.279964  \n",
       "560     1514.191088     1652.983380  \n",
       "561     1469.839220     1520.477689  \n",
       "562     1427.422514     1499.722315  \n",
       "563     1388.284599     1471.976003  \n",
       "\n",
       "[564 rows x 8 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "elo_history"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d2108a4c",
   "metadata": {},
   "source": [
    "## Merge team elo rating columns and date column."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "c1c8409e",
   "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>DATE</th>\n",
       "      <th>CHRIS</th>\n",
       "      <th>ANDREW</th>\n",
       "      <th>STEVE</th>\n",
       "      <th>MATT</th>\n",
       "      <th>KYLE</th>\n",
       "      <th>CARLEN</th>\n",
       "      <th>NATHAN</th>\n",
       "      <th>DREW</th>\n",
       "      <th>SAM</th>\n",
       "      <th>DYLAN</th>\n",
       "      <th>NICK</th>\n",
       "      <th>JASON</th>\n",
       "      <th>NOAH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>2021-11</td>\n",
       "      <td>1644</td>\n",
       "      <td>1521</td>\n",
       "      <td>1523</td>\n",
       "      <td>1369</td>\n",
       "      <td>1533</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487</td>\n",
       "      <td>1454</td>\n",
       "      <td>1518</td>\n",
       "      <td>1465</td>\n",
       "      <td>1542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>2021-12</td>\n",
       "      <td>1654</td>\n",
       "      <td>1533</td>\n",
       "      <td>1513</td>\n",
       "      <td>1390</td>\n",
       "      <td>1511</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1505</td>\n",
       "      <td>1442</td>\n",
       "      <td>1530</td>\n",
       "      <td>1453</td>\n",
       "      <td>1524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2021-13</td>\n",
       "      <td>1663</td>\n",
       "      <td>1547</td>\n",
       "      <td>1529</td>\n",
       "      <td>1381</td>\n",
       "      <td>1502</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1491</td>\n",
       "      <td>1427</td>\n",
       "      <td>1540</td>\n",
       "      <td>1467</td>\n",
       "      <td>1509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2021-14</td>\n",
       "      <td>1643</td>\n",
       "      <td>1567</td>\n",
       "      <td>1544</td>\n",
       "      <td>1368</td>\n",
       "      <td>1487</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1506</td>\n",
       "      <td>1440</td>\n",
       "      <td>1524</td>\n",
       "      <td>1484</td>\n",
       "      <td>1492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>2021-15</td>\n",
       "      <td>1653</td>\n",
       "      <td>1581</td>\n",
       "      <td>1530</td>\n",
       "      <td>1388</td>\n",
       "      <td>1500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1520</td>\n",
       "      <td>1427</td>\n",
       "      <td>1514</td>\n",
       "      <td>1470</td>\n",
       "      <td>1472</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        DATE  CHRIS  ANDREW  STEVE  MATT  KYLE  CARLEN  NATHAN  DREW   SAM  \\\n",
       "112  2021-11   1644    1521   1523  1369  1533       0       0     0  1487   \n",
       "113  2021-12   1654    1533   1513  1390  1511       0       0     0  1505   \n",
       "114  2021-13   1663    1547   1529  1381  1502       0       0     0  1491   \n",
       "115  2021-14   1643    1567   1544  1368  1487       0       0     0  1506   \n",
       "116  2021-15   1653    1581   1530  1388  1500       0       0     0  1520   \n",
       "\n",
       "     DYLAN  NICK  JASON  NOAH  \n",
       "112   1454  1518   1465  1542  \n",
       "113   1442  1530   1453  1524  \n",
       "114   1427  1540   1467  1509  \n",
       "115   1440  1524   1484  1492  \n",
       "116   1427  1514   1470  1472  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({\"DATE\" : dates} | elo_dict)\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "37c4b9ba",
   "metadata": {},
   "source": [
    "## Save and export table to CSV."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "54436ae3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"C:\\\\Users\\\\chris\\\\Desktop\\\\elo_over_time.csv\", index=False)"
   ]
  }
 ],
 "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}