2022-03-24-ff-elo-line-chart-race.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "9683f783",
   "metadata": {},
   "source": [
    "## Import libraries and dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f17b280a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.options.display.max_columns = 12\n",
    "\n",
    "elo_over_time = pd.read_csv(\"C:\\\\Users\\\\chris\\\\Documents\\\\Datasets\\\\FFL\\\\elo_over_time.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bc943186",
   "metadata": {},
   "source": [
    "## Format data for use with Flourish. Replace zeroes with empty strings."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b9772ea4",
   "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>...</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>0</th>\n",
       "      <td>2014-00</td>\n",
       "      <td>1500</td>\n",
       "      <td>1500</td>\n",
       "      <td>1500</td>\n",
       "      <td>1500</td>\n",
       "      <td>1500</td>\n",
       "      <td>...</td>\n",
       "      <td>1500</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01</td>\n",
       "      <td>1485</td>\n",
       "      <td>1485</td>\n",
       "      <td>1515</td>\n",
       "      <td>1515</td>\n",
       "      <td>1515</td>\n",
       "      <td>...</td>\n",
       "      <td>1485</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-02</td>\n",
       "      <td>1471</td>\n",
       "      <td>1501</td>\n",
       "      <td>1499</td>\n",
       "      <td>1529</td>\n",
       "      <td>1499</td>\n",
       "      <td>...</td>\n",
       "      <td>1501</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-03</td>\n",
       "      <td>1456</td>\n",
       "      <td>1486</td>\n",
       "      <td>1514</td>\n",
       "      <td>1514</td>\n",
       "      <td>1484</td>\n",
       "      <td>...</td>\n",
       "      <td>1516</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-04</td>\n",
       "      <td>1443</td>\n",
       "      <td>1500</td>\n",
       "      <td>1529</td>\n",
       "      <td>1499</td>\n",
       "      <td>1501</td>\n",
       "      <td>...</td>\n",
       "      <td>1530</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></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",
       "    </tr>\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>...</td>\n",
       "      <td></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>...</td>\n",
       "      <td></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>...</td>\n",
       "      <td></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>...</td>\n",
       "      <td></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>...</td>\n",
       "      <td></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",
       "<p>117 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        DATE  CHRIS  ANDREW  STEVE  MATT  KYLE  ...  DREW   SAM DYLAN  NICK  \\\n",
       "0    2014-00   1500    1500   1500  1500  1500  ...  1500                     \n",
       "1    2014-01   1485    1485   1515  1515  1515  ...  1485                     \n",
       "2    2014-02   1471    1501   1499  1529  1499  ...  1501                     \n",
       "3    2014-03   1456    1486   1514  1514  1484  ...  1516                     \n",
       "4    2014-04   1443    1500   1529  1499  1501  ...  1530                     \n",
       "..       ...    ...     ...    ...   ...   ...  ...   ...   ...   ...   ...   \n",
       "112  2021-11   1644    1521   1523  1369  1533  ...        1487  1454  1518   \n",
       "113  2021-12   1654    1533   1513  1390  1511  ...        1505  1442  1530   \n",
       "114  2021-13   1663    1547   1529  1381  1502  ...        1491  1427  1540   \n",
       "115  2021-14   1643    1567   1544  1368  1487  ...        1506  1440  1524   \n",
       "116  2021-15   1653    1581   1530  1388  1500  ...        1520  1427  1514   \n",
       "\n",
       "    JASON  NOAH  \n",
       "0                \n",
       "1                \n",
       "2                \n",
       "3                \n",
       "4                \n",
       "..    ...   ...  \n",
       "112  1465  1542  \n",
       "113  1453  1524  \n",
       "114  1467  1509  \n",
       "115  1484  1492  \n",
       "116  1470  1472  \n",
       "\n",
       "[117 rows x 14 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "elo_over_time = elo_over_time.replace(0, \"\")\n",
    "elo_over_time"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cb31cf34",
   "metadata": {},
   "source": [
    "## Transpose dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "edbdd53a",
   "metadata": {},
   "outputs": [],
   "source": [
    "elo_over_time = elo_over_time.T"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "14ad151f",
   "metadata": {},
   "source": [
    "## Set \"Date\" row as the column header row."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "9699a368",
   "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>DATE</th>\n",
       "      <th>2014-00</th>\n",
       "      <th>2014-01</th>\n",
       "      <th>2014-02</th>\n",
       "      <th>2014-03</th>\n",
       "      <th>2014-04</th>\n",
       "      <th>2014-05</th>\n",
       "      <th>...</th>\n",
       "      <th>2021-10</th>\n",
       "      <th>2021-11</th>\n",
       "      <th>2021-12</th>\n",
       "      <th>2021-13</th>\n",
       "      <th>2021-14</th>\n",
       "      <th>2021-15</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CHRIS</th>\n",
       "      <td>1500</td>\n",
       "      <td>1485</td>\n",
       "      <td>1471</td>\n",
       "      <td>1456</td>\n",
       "      <td>1443</td>\n",
       "      <td>1460</td>\n",
       "      <td>...</td>\n",
       "      <td>1634</td>\n",
       "      <td>1644</td>\n",
       "      <td>1654</td>\n",
       "      <td>1663</td>\n",
       "      <td>1643</td>\n",
       "      <td>1653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANDREW</th>\n",
       "      <td>1500</td>\n",
       "      <td>1485</td>\n",
       "      <td>1501</td>\n",
       "      <td>1486</td>\n",
       "      <td>1500</td>\n",
       "      <td>1514</td>\n",
       "      <td>...</td>\n",
       "      <td>1504</td>\n",
       "      <td>1521</td>\n",
       "      <td>1533</td>\n",
       "      <td>1547</td>\n",
       "      <td>1567</td>\n",
       "      <td>1581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STEVE</th>\n",
       "      <td>1500</td>\n",
       "      <td>1515</td>\n",
       "      <td>1499</td>\n",
       "      <td>1514</td>\n",
       "      <td>1529</td>\n",
       "      <td>1514</td>\n",
       "      <td>...</td>\n",
       "      <td>1507</td>\n",
       "      <td>1523</td>\n",
       "      <td>1513</td>\n",
       "      <td>1529</td>\n",
       "      <td>1544</td>\n",
       "      <td>1530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MATT</th>\n",
       "      <td>1500</td>\n",
       "      <td>1515</td>\n",
       "      <td>1529</td>\n",
       "      <td>1514</td>\n",
       "      <td>1499</td>\n",
       "      <td>1515</td>\n",
       "      <td>...</td>\n",
       "      <td>1381</td>\n",
       "      <td>1369</td>\n",
       "      <td>1390</td>\n",
       "      <td>1381</td>\n",
       "      <td>1368</td>\n",
       "      <td>1388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KYLE</th>\n",
       "      <td>1500</td>\n",
       "      <td>1515</td>\n",
       "      <td>1499</td>\n",
       "      <td>1484</td>\n",
       "      <td>1501</td>\n",
       "      <td>1484</td>\n",
       "      <td>...</td>\n",
       "      <td>1550</td>\n",
       "      <td>1533</td>\n",
       "      <td>1511</td>\n",
       "      <td>1502</td>\n",
       "      <td>1487</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CARLEN</th>\n",
       "      <td>1500</td>\n",
       "      <td>1515</td>\n",
       "      <td>1529</td>\n",
       "      <td>1544</td>\n",
       "      <td>1526</td>\n",
       "      <td>1541</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>NATHAN</th>\n",
       "      <td>1500</td>\n",
       "      <td>1485</td>\n",
       "      <td>1471</td>\n",
       "      <td>1486</td>\n",
       "      <td>1473</td>\n",
       "      <td>1459</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>DREW</th>\n",
       "      <td>1500</td>\n",
       "      <td>1485</td>\n",
       "      <td>1501</td>\n",
       "      <td>1516</td>\n",
       "      <td>1530</td>\n",
       "      <td>1514</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>SAM</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1497</td>\n",
       "      <td>1487</td>\n",
       "      <td>1505</td>\n",
       "      <td>1491</td>\n",
       "      <td>1506</td>\n",
       "      <td>1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DYLAN</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1442</td>\n",
       "      <td>1454</td>\n",
       "      <td>1442</td>\n",
       "      <td>1427</td>\n",
       "      <td>1440</td>\n",
       "      <td>1427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NICK</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1535</td>\n",
       "      <td>1518</td>\n",
       "      <td>1530</td>\n",
       "      <td>1540</td>\n",
       "      <td>1524</td>\n",
       "      <td>1514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JASON</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1478</td>\n",
       "      <td>1465</td>\n",
       "      <td>1453</td>\n",
       "      <td>1467</td>\n",
       "      <td>1484</td>\n",
       "      <td>1470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOAH</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1529</td>\n",
       "      <td>1542</td>\n",
       "      <td>1524</td>\n",
       "      <td>1509</td>\n",
       "      <td>1492</td>\n",
       "      <td>1472</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13 rows × 117 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "DATE   2014-00 2014-01 2014-02 2014-03 2014-04 2014-05  ... 2021-10 2021-11  \\\n",
       "CHRIS     1500    1485    1471    1456    1443    1460  ...    1634    1644   \n",
       "ANDREW    1500    1485    1501    1486    1500    1514  ...    1504    1521   \n",
       "STEVE     1500    1515    1499    1514    1529    1514  ...    1507    1523   \n",
       "MATT      1500    1515    1529    1514    1499    1515  ...    1381    1369   \n",
       "KYLE      1500    1515    1499    1484    1501    1484  ...    1550    1533   \n",
       "CARLEN    1500    1515    1529    1544    1526    1541  ...                   \n",
       "NATHAN    1500    1485    1471    1486    1473    1459  ...                   \n",
       "DREW      1500    1485    1501    1516    1530    1514  ...                   \n",
       "SAM                                                     ...    1497    1487   \n",
       "DYLAN                                                   ...    1442    1454   \n",
       "NICK                                                    ...    1535    1518   \n",
       "JASON                                                   ...    1478    1465   \n",
       "NOAH                                                    ...    1529    1542   \n",
       "\n",
       "DATE   2021-12 2021-13 2021-14 2021-15  \n",
       "CHRIS     1654    1663    1643    1653  \n",
       "ANDREW    1533    1547    1567    1581  \n",
       "STEVE     1513    1529    1544    1530  \n",
       "MATT      1390    1381    1368    1388  \n",
       "KYLE      1511    1502    1487    1500  \n",
       "CARLEN                                  \n",
       "NATHAN                                  \n",
       "DREW                                    \n",
       "SAM       1505    1491    1506    1520  \n",
       "DYLAN     1442    1427    1440    1427  \n",
       "NICK      1530    1540    1524    1514  \n",
       "JASON     1453    1467    1484    1470  \n",
       "NOAH      1524    1509    1492    1472  \n",
       "\n",
       "[13 rows x 117 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "elo_over_time.columns = elo_over_time.iloc[0]\n",
    "elo_over_time = elo_over_time[1:]\n",
    "elo_over_time"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea5b0627",
   "metadata": {},
   "source": [
    "## Export dataframe to CSV."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "2e6ae0d8",
   "metadata": {},
   "outputs": [],
   "source": [
    "elo_over_time.to_csv(\"C:\\\\Users\\\\chris\\\\Desktop\\\\line_race_data.csv\", index=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "80620948",
   "metadata": {},
   "source": [
    "## Upload CSV to Flourish. Create visualization using \"Line chart race\" template."
   ]
  }
 ],
 "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
}