notebooks/alternative-scenarios.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Calculating Alternative Scoring Scenarios\n",
    "\n",
    "The analysis below calculates the total points and final standings of the ice dance and men's competitions under two alternative scenarios:\n",
    "\n",
    "1. The scores of two countries' judges were replaced with the \"average\" of the rest of the judging panel.\n",
    "2. The scores of two countries' judges were removed from the judging panel entirely.\n",
    "\n",
    "For ice dance, those countries are Canada and France.\n",
    "\n",
    "For men's figure skating, those countries are the United States and China."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load scoring data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "performances = pd.read_csv(\"../data/performances.csv\")\n",
    "aspects = pd.read_csv(\"../data/judged-aspects.csv\")\n",
    "scores = pd.read_csv(\"../data/judge-scores.csv\")\n",
    "judge_goe = pd.read_csv(\"../data/judge-goe.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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></th>\n",
       "      <th>performances</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>program</th>\n",
       "      <th>competition</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Ice Dance - Free Dance</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ice Dance - Short Dance</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ladies Single Skating - Short Program</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Men Single Skating - Free Skating</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Men Single Skating - Short Program</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pair Skating - Free Skating</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pair Skating - Short Program</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Ice Dance Free Dance</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Ice Dance Short Dance</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Ladies Single Skating Free Skating</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Ladies Single Skating Short Program</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Men Single Skating Free Skating</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Men Single Skating Short Program</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Pair Skating Free Skating</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team Event - Pair Skating Short Program</th>\n",
       "      <th>Olympic Winter Games 2018</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                            performances\n",
       "program                                          competition                            \n",
       "Ice Dance - Free Dance                           Olympic Winter Games 2018            20\n",
       "Ice Dance - Short Dance                          Olympic Winter Games 2018            24\n",
       "Ladies Single Skating - Short Program            Olympic Winter Games 2018            30\n",
       "Men Single Skating - Free Skating                Olympic Winter Games 2018            24\n",
       "Men Single Skating - Short Program               Olympic Winter Games 2018            30\n",
       "Pair Skating - Free Skating                      Olympic Winter Games 2018            16\n",
       "Pair Skating - Short Program                     Olympic Winter Games 2018            22\n",
       "Team Event - Ice Dance Free Dance                Olympic Winter Games 2018             5\n",
       "Team Event - Ice Dance Short Dance               Olympic Winter Games 2018            10\n",
       "Team Event - Ladies Single Skating Free Skating  Olympic Winter Games 2018             5\n",
       "Team Event - Ladies Single Skating Short Program Olympic Winter Games 2018            10\n",
       "Team Event - Men Single Skating Free Skating     Olympic Winter Games 2018             5\n",
       "Team Event - Men Single Skating Short Program    Olympic Winter Games 2018            10\n",
       "Team Event - Pair Skating Free Skating           Olympic Winter Games 2018             5\n",
       "Team Event - Pair Skating Short Program          Olympic Winter Games 2018            10"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "performances.groupby([\"program\", \"competition\"])\\\n",
    "    .size().to_frame(\"performances\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "scores_with_context = scores.pipe(\n",
    "    pd.merge,\n",
    "    aspects,\n",
    "    on = \"aspect_id\",\n",
    "    how = \"left\"\n",
    ").pipe(\n",
    "    pd.merge,\n",
    "    performances,\n",
    "    on = \"performance_id\",\n",
    "    how = \"left\"\n",
    ").pipe(\n",
    "    pd.merge,\n",
    "    judge_goe,\n",
    "    on = [ \"aspect_id\", \"judge\" ],\n",
    "    how = \"left\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "assert len(scores) == len(scores_with_context)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Set up score-totaling calculations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# The ISU's scoring system uses a trimmed mean, which removes the highest and \n",
    "# lowest score for each element and component.\n",
    "# To calculate the proper score for a competition, we do the same here.\n",
    "def calc_trimmed_mean(score_list):\n",
    "    trimmed = sorted(score_list)[1:-1]\n",
    "    return round(sum(trimmed) / len(trimmed), 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calculate_aspect_scores(aspect_judgments):\n",
    "\n",
    "    aspects_grp = aspect_judgments.groupby(\"aspect_id\")\n",
    "    \n",
    "    scores = pd.DataFrame({\n",
    "        \"name\": aspects_grp[\"name\"].first(),\n",
    "        \"program\": aspects_grp[\"program\"].first(),\n",
    "        \"section\": aspects_grp[\"section\"].first(),\n",
    "        \"performance_id\": aspects_grp[\"performance_id\"].first(),\n",
    "        \"factor\": aspects_grp[\"factor\"].first(),\n",
    "        \"base_value\": aspects_grp[\"base_value\"].first(),\n",
    "        \"score\": aspects_grp[\"score\"].apply(lambda x: calc_trimmed_mean(x)),\n",
    "        \"judge_goe\": aspects_grp[\"judge_goe\"].apply(lambda x: calc_trimmed_mean(x)),\n",
    "        \"total_deductions\": aspects_grp[\"total_deductions\"].first()\n",
    "    })\n",
    "    \n",
    "    return scores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def total_points(row):\n",
    "    if row[\"section\"] == \"elements\":\n",
    "        return round(row[\"base_value\"] + row[\"judge_goe\"], 2)\n",
    "    \n",
    "    elif row[\"section\"] == \"components\":\n",
    "        return round(row[\"factor\"] * row[\"score\"], 2)\n",
    "    \n",
    "    else:\n",
    "        print(\"Unknown section: {}\".format(row[\"section\"]))\n",
    "        return None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calculate_results(scores):\n",
    "    \n",
    "    scores[\"total_points\"] = scores.apply(total_points, axis=1)\n",
    "    \n",
    "    perfs_grp = scores.groupby(\"performance_id\")\n",
    "    \n",
    "    perfs = pd.DataFrame({\n",
    "        \"score\": perfs_grp[\"total_points\"].sum(),\n",
    "        \"deductions\": perfs_grp[\"total_deductions\"].first(),\n",
    "        \"program\": perfs_grp[\"program\"].first(),\n",
    "        \"name\": perfs_grp[\"name\"].first()\n",
    "    })\n",
    "    \n",
    "    perfs[\"total_score\"] = perfs[\"score\"] - perfs[\"deductions\"]\n",
    "    \n",
    "    comp_grp = perfs.groupby(\"name\")\n",
    "    \n",
    "    results = pd.DataFrame({\n",
    "        \"final_score\": comp_grp[\"total_score\"].sum()\n",
    "     })\n",
    "    \n",
    "    return results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calc_trimmed_mean_with_average_judge(score_list):\n",
    "    average = sum(score_list) / len(score_list)\n",
    "    score_list = score_list.tolist() + [average] * (9-len(score_list))\n",
    "    trimmed = sorted(score_list)[1:-1]\n",
    "    return round(sum(trimmed) / len(trimmed), 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calculate_score_with_average_judge(dataframe):\n",
    "\n",
    "    aspects = dataframe.groupby(\"aspect_id\")\n",
    "    \n",
    "    scores = pd.DataFrame({\n",
    "        \"name\": aspects[\"name\"].first(),\n",
    "        \"program\": aspects[\"program\"].first(),\n",
    "        \"section\": aspects[\"section\"].first(),\n",
    "        \"performance_id\": aspects[\"performance_id\"].first(),\n",
    "        \"factor\": aspects[\"factor\"].first(),\n",
    "        \"base_value\": aspects[\"base_value\"].first(),\n",
    "        \"scores_of_panel\": aspects[\"scores_of_panel\"].first(),\n",
    "        \"score\": aspects[\"score\"].apply(lambda x: calc_trimmed_mean_with_average_judge(x)),\n",
    "        \"judge_goe\": aspects[\"judge_goe\"].apply(lambda x: calc_trimmed_mean_with_average_judge(x)),\n",
    "        \"total_deductions\": aspects[\"total_deductions\"].first()\n",
    "    })\n",
    "    \n",
    "    return scores"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "## Ice Dance Calculations"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Create subsets of scores with/without Canadian and French judges"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "id_olympics = scores_with_context[\n",
    "    scores_with_context[\"program\"].str.contains(\"Ice Dance\") &\n",
    "    ~scores_with_context[\"program\"].str.contains(\"Team\")\n",
    "].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>judge</th>\n",
       "      <th>J1</th>\n",
       "      <th>J2</th>\n",
       "      <th>J3</th>\n",
       "      <th>J4</th>\n",
       "      <th>J5</th>\n",
       "      <th>J6</th>\n",
       "      <th>J7</th>\n",
       "      <th>J8</th>\n",
       "      <th>J9</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>program</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>Ice Dance - Free Dance</th>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ice Dance - Short Dance</th>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "judge                     J1   J2   J3   J4   J5   J6   J7   J8   J9\n",
       "program                                                             \n",
       "Ice Dance - Free Dance   277  277  277  277  277  277  277  277  277\n",
       "Ice Dance - Short Dance  240  240  240  240  240  240  240  240  240"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "id_olympics\\\n",
    "    .groupby([ \"program\", \"judge\"])\\\n",
    "    .size().unstack()\\\n",
    "    .fillna(0).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "id_olympics_without_canada_france = id_olympics[\n",
    "    ~(\n",
    "        # Canada\n",
    "        (\n",
    "            (id_olympics[\"judge\"] == \"J1\") &\n",
    "            (id_olympics[\"program\"] == \"Ice Dance - Short Dance\")\n",
    "        ) |\n",
    "        (\n",
    "            (id_olympics[\"judge\"] == \"J2\") &\n",
    "            (id_olympics[\"program\"] == \"Ice Dance - Free Dance\")\n",
    "        ) |\n",
    "      \n",
    "        # France\n",
    "        (\n",
    "\n",
    "            (id_olympics[\"judge\"] == \"J4\") &\n",
    "            (id_olympics[\"program\"] == \"Ice Dance - Short Dance\")\n",
    "        )\n",
    "    )\n",
    "].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>judge</th>\n",
       "      <th>J1</th>\n",
       "      <th>J2</th>\n",
       "      <th>J3</th>\n",
       "      <th>J4</th>\n",
       "      <th>J5</th>\n",
       "      <th>J6</th>\n",
       "      <th>J7</th>\n",
       "      <th>J8</th>\n",
       "      <th>J9</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>program</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>Ice Dance - Free Dance</th>\n",
       "      <td>277</td>\n",
       "      <td>0</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "      <td>277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ice Dance - Short Dance</th>\n",
       "      <td>0</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>0</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "judge                     J1   J2   J3   J4   J5   J6   J7   J8   J9\n",
       "program                                                             \n",
       "Ice Dance - Free Dance   277    0  277  277  277  277  277  277  277\n",
       "Ice Dance - Short Dance    0  240  240    0  240  240  240  240  240"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "id_olympics_without_canada_france\\\n",
    "    .groupby([ \"program\", \"judge\"])\\\n",
    "    .size().unstack()\\\n",
    "    .fillna(0).astype(int)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Calculate actual and alternate scoring scenarios for Ice Dance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "aspect_scores = calculate_aspect_scores(id_olympics)\n",
    "final_actual = calculate_results(aspect_scores)\\\n",
    "    .sort_values(\"final_score\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "scores_with_replacement = calculate_score_with_average_judge(id_olympics_without_canada_france)\n",
    "final_with_replacement = calculate_results(scores_with_replacement)\\\n",
    "    .sort_values(\"final_score\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "scores_no_replacement = calculate_aspect_scores(id_olympics_without_canada_france)\n",
    "final_with_removal = calculate_results(scores_no_replacement)\\\n",
    "    .sort_values(\"final_score\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Actual scores vs. scores with CAN/FRA replaced by \"average\" judgments"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>final_score_actual</th>\n",
       "      <th>final_score_with_replacement</th>\n",
       "      <th>rank_actual</th>\n",
       "      <th>rank_with_replacement</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>VIRTUE Tessa / MOIR Scott</th>\n",
       "      <td>206.07</td>\n",
       "      <td>205.74</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAPADAKIS Gabriella / CIZERON Guillaume</th>\n",
       "      <td>205.28</td>\n",
       "      <td>206.13</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SHIBUTANI Maia / SHIBUTANI Alex</th>\n",
       "      <td>192.59</td>\n",
       "      <td>192.27</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HUBBELL Madison / DONOHUE Zachary</th>\n",
       "      <td>189.69</td>\n",
       "      <td>189.48</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BOBROVA Ekaterina / SOLOVIEV Dmitri</th>\n",
       "      <td>186.92</td>\n",
       "      <td>187.76</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAPPELLINI Anna / LANOTTE Luca</th>\n",
       "      <td>186.91</td>\n",
       "      <td>186.99</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEAVER Kaitlyn / POJE Andrew</th>\n",
       "      <td>181.98</td>\n",
       "      <td>180.31</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHOCK Madison / BATES Evan</th>\n",
       "      <td>179.58</td>\n",
       "      <td>178.95</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GILLES Piper / POIRIER Paul</th>\n",
       "      <td>176.91</td>\n",
       "      <td>176.18</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GUIGNARD Charlene / FABBRI Marco</th>\n",
       "      <td>173.47</td>\n",
       "      <td>173.09</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COOMES Penny / BUCKLAND Nicholas</th>\n",
       "      <td>170.32</td>\n",
       "      <td>169.77</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HURTADO Sara / KHALIAVIN Kirill</th>\n",
       "      <td>168.33</td>\n",
       "      <td>169.07</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZAGORSKI Tiffani / GUERREIRO Jonathan</th>\n",
       "      <td>162.24</td>\n",
       "      <td>162.64</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KALISZEK Natalia / SPODYRIEV Maksym</th>\n",
       "      <td>161.35</td>\n",
       "      <td>162.16</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MURAMOTO Kana / REED Chris</th>\n",
       "      <td>160.63</td>\n",
       "      <td>159.89</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LORENZ Kavita / POLIZOAKIS Joti</th>\n",
       "      <td>150.49</td>\n",
       "      <td>149.67</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAURIAULT Marie-Jade / le GAC Romain</th>\n",
       "      <td>149.59</td>\n",
       "      <td>149.63</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIN Yura / GAMELIN Alexander</th>\n",
       "      <td>147.74</td>\n",
       "      <td>147.24</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGAFONOVA Alisa / UCAR Alper</th>\n",
       "      <td>147.18</td>\n",
       "      <td>148.78</td>\n",
       "      <td>19</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MYSLIVECKOVA Lucie / CSOLLEY Lukas</th>\n",
       "      <td>142.57</td>\n",
       "      <td>143.39</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WANG Shiyue / LIU Xinyu</th>\n",
       "      <td>59.81</td>\n",
       "      <td>60.48</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAZAROVA Alexandra / NIKITIN Maxim</th>\n",
       "      <td>57.97</td>\n",
       "      <td>58.34</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANSOUROVA Cortney / CESKA Michal</th>\n",
       "      <td>53.53</td>\n",
       "      <td>53.94</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TANKOVA Adel / ZILBERBERG Ronald</th>\n",
       "      <td>46.66</td>\n",
       "      <td>46.96</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         final_score_actual  \\\n",
       "name                                                          \n",
       "VIRTUE Tessa / MOIR Scott                            206.07   \n",
       "PAPADAKIS Gabriella / CIZERON Guillaume              205.28   \n",
       "SHIBUTANI Maia / SHIBUTANI Alex                      192.59   \n",
       "HUBBELL Madison / DONOHUE Zachary                    189.69   \n",
       "BOBROVA Ekaterina / SOLOVIEV Dmitri                  186.92   \n",
       "CAPPELLINI Anna / LANOTTE Luca                       186.91   \n",
       "WEAVER Kaitlyn / POJE Andrew                         181.98   \n",
       "CHOCK Madison / BATES Evan                           179.58   \n",
       "GILLES Piper / POIRIER Paul                          176.91   \n",
       "GUIGNARD Charlene / FABBRI Marco                     173.47   \n",
       "COOMES Penny / BUCKLAND Nicholas                     170.32   \n",
       "HURTADO Sara / KHALIAVIN Kirill                      168.33   \n",
       "ZAGORSKI Tiffani / GUERREIRO Jonathan                162.24   \n",
       "KALISZEK Natalia / SPODYRIEV Maksym                  161.35   \n",
       "MURAMOTO Kana / REED Chris                           160.63   \n",
       "LORENZ Kavita / POLIZOAKIS Joti                      150.49   \n",
       "LAURIAULT Marie-Jade / le GAC Romain                 149.59   \n",
       "MIN Yura / GAMELIN Alexander                         147.74   \n",
       "AGAFONOVA Alisa / UCAR Alper                         147.18   \n",
       "MYSLIVECKOVA Lucie / CSOLLEY Lukas                   142.57   \n",
       "WANG Shiyue / LIU Xinyu                               59.81   \n",
       "NAZAROVA Alexandra / NIKITIN Maxim                    57.97   \n",
       "MANSOUROVA Cortney / CESKA Michal                     53.53   \n",
       "TANKOVA Adel / ZILBERBERG Ronald                      46.66   \n",
       "\n",
       "                                         final_score_with_replacement  \\\n",
       "name                                                                    \n",
       "VIRTUE Tessa / MOIR Scott                                      205.74   \n",
       "PAPADAKIS Gabriella / CIZERON Guillaume                        206.13   \n",
       "SHIBUTANI Maia / SHIBUTANI Alex                                192.27   \n",
       "HUBBELL Madison / DONOHUE Zachary                              189.48   \n",
       "BOBROVA Ekaterina / SOLOVIEV Dmitri                            187.76   \n",
       "CAPPELLINI Anna / LANOTTE Luca                                 186.99   \n",
       "WEAVER Kaitlyn / POJE Andrew                                   180.31   \n",
       "CHOCK Madison / BATES Evan                                     178.95   \n",
       "GILLES Piper / POIRIER Paul                                    176.18   \n",
       "GUIGNARD Charlene / FABBRI Marco                               173.09   \n",
       "COOMES Penny / BUCKLAND Nicholas                               169.77   \n",
       "HURTADO Sara / KHALIAVIN Kirill                                169.07   \n",
       "ZAGORSKI Tiffani / GUERREIRO Jonathan                          162.64   \n",
       "KALISZEK Natalia / SPODYRIEV Maksym                            162.16   \n",
       "MURAMOTO Kana / REED Chris                                     159.89   \n",
       "LORENZ Kavita / POLIZOAKIS Joti                                149.67   \n",
       "LAURIAULT Marie-Jade / le GAC Romain                           149.63   \n",
       "MIN Yura / GAMELIN Alexander                                   147.24   \n",
       "AGAFONOVA Alisa / UCAR Alper                                   148.78   \n",
       "MYSLIVECKOVA Lucie / CSOLLEY Lukas                             143.39   \n",
       "WANG Shiyue / LIU Xinyu                                         60.48   \n",
       "NAZAROVA Alexandra / NIKITIN Maxim                              58.34   \n",
       "MANSOUROVA Cortney / CESKA Michal                               53.94   \n",
       "TANKOVA Adel / ZILBERBERG Ronald                                46.96   \n",
       "\n",
       "                                         rank_actual  rank_with_replacement  \n",
       "name                                                                         \n",
       "VIRTUE Tessa / MOIR Scott                          1                      2  \n",
       "PAPADAKIS Gabriella / CIZERON Guillaume            2                      1  \n",
       "SHIBUTANI Maia / SHIBUTANI Alex                    3                      3  \n",
       "HUBBELL Madison / DONOHUE Zachary                  4                      4  \n",
       "BOBROVA Ekaterina / SOLOVIEV Dmitri                5                      5  \n",
       "CAPPELLINI Anna / LANOTTE Luca                     6                      6  \n",
       "WEAVER Kaitlyn / POJE Andrew                       7                      7  \n",
       "CHOCK Madison / BATES Evan                         8                      8  \n",
       "GILLES Piper / POIRIER Paul                        9                      9  \n",
       "GUIGNARD Charlene / FABBRI Marco                  10                     10  \n",
       "COOMES Penny / BUCKLAND Nicholas                  11                     11  \n",
       "HURTADO Sara / KHALIAVIN Kirill                   12                     12  \n",
       "ZAGORSKI Tiffani / GUERREIRO Jonathan             13                     13  \n",
       "KALISZEK Natalia / SPODYRIEV Maksym               14                     14  \n",
       "MURAMOTO Kana / REED Chris                        15                     15  \n",
       "LORENZ Kavita / POLIZOAKIS Joti                   16                     16  \n",
       "LAURIAULT Marie-Jade / le GAC Romain              17                     17  \n",
       "MIN Yura / GAMELIN Alexander                      18                     19  \n",
       "AGAFONOVA Alisa / UCAR Alper                      19                     18  \n",
       "MYSLIVECKOVA Lucie / CSOLLEY Lukas                20                     20  \n",
       "WANG Shiyue / LIU Xinyu                           21                     21  \n",
       "NAZAROVA Alexandra / NIKITIN Maxim                22                     22  \n",
       "MANSOUROVA Cortney / CESKA Michal                 23                     23  \n",
       "TANKOVA Adel / ZILBERBERG Ronald                  24                     24  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(\n",
    "    final_actual.reset_index(),\n",
    "    final_with_replacement.reset_index(),\n",
    "    on=\"name\",\n",
    "    suffixes=[\"_actual\", \"_with_replacement\"]\n",
    ").set_index(\"name\")\\\n",
    "    .assign(\n",
    "        rank_actual = lambda x: x[\"final_score_actual\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "        rank_with_replacement = lambda x: x[\"final_score_with_replacement\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Actual scores vs. scores with CAN/FRA removed (and not replaced)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>final_score_actual</th>\n",
       "      <th>final_score_with_removal</th>\n",
       "      <th>rank_actual</th>\n",
       "      <th>rank_with_removal</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>VIRTUE Tessa / MOIR Scott</th>\n",
       "      <td>206.07</td>\n",
       "      <td>205.86</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAPADAKIS Gabriella / CIZERON Guillaume</th>\n",
       "      <td>205.28</td>\n",
       "      <td>206.32</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SHIBUTANI Maia / SHIBUTANI Alex</th>\n",
       "      <td>192.59</td>\n",
       "      <td>192.27</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HUBBELL Madison / DONOHUE Zachary</th>\n",
       "      <td>189.69</td>\n",
       "      <td>189.42</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BOBROVA Ekaterina / SOLOVIEV Dmitri</th>\n",
       "      <td>186.92</td>\n",
       "      <td>187.97</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAPPELLINI Anna / LANOTTE Luca</th>\n",
       "      <td>186.91</td>\n",
       "      <td>187.00</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEAVER Kaitlyn / POJE Andrew</th>\n",
       "      <td>181.98</td>\n",
       "      <td>180.34</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHOCK Madison / BATES Evan</th>\n",
       "      <td>179.58</td>\n",
       "      <td>178.83</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GILLES Piper / POIRIER Paul</th>\n",
       "      <td>176.91</td>\n",
       "      <td>176.22</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GUIGNARD Charlene / FABBRI Marco</th>\n",
       "      <td>173.47</td>\n",
       "      <td>173.19</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COOMES Penny / BUCKLAND Nicholas</th>\n",
       "      <td>170.32</td>\n",
       "      <td>169.86</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HURTADO Sara / KHALIAVIN Kirill</th>\n",
       "      <td>168.33</td>\n",
       "      <td>169.08</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZAGORSKI Tiffani / GUERREIRO Jonathan</th>\n",
       "      <td>162.24</td>\n",
       "      <td>162.68</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KALISZEK Natalia / SPODYRIEV Maksym</th>\n",
       "      <td>161.35</td>\n",
       "      <td>162.31</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MURAMOTO Kana / REED Chris</th>\n",
       "      <td>160.63</td>\n",
       "      <td>159.90</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LORENZ Kavita / POLIZOAKIS Joti</th>\n",
       "      <td>150.49</td>\n",
       "      <td>149.80</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAURIAULT Marie-Jade / le GAC Romain</th>\n",
       "      <td>149.59</td>\n",
       "      <td>149.57</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIN Yura / GAMELIN Alexander</th>\n",
       "      <td>147.74</td>\n",
       "      <td>147.25</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGAFONOVA Alisa / UCAR Alper</th>\n",
       "      <td>147.18</td>\n",
       "      <td>148.93</td>\n",
       "      <td>19</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MYSLIVECKOVA Lucie / CSOLLEY Lukas</th>\n",
       "      <td>142.57</td>\n",
       "      <td>143.37</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WANG Shiyue / LIU Xinyu</th>\n",
       "      <td>59.81</td>\n",
       "      <td>60.62</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAZAROVA Alexandra / NIKITIN Maxim</th>\n",
       "      <td>57.97</td>\n",
       "      <td>58.34</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANSOUROVA Cortney / CESKA Michal</th>\n",
       "      <td>53.53</td>\n",
       "      <td>54.02</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TANKOVA Adel / ZILBERBERG Ronald</th>\n",
       "      <td>46.66</td>\n",
       "      <td>46.98</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         final_score_actual  \\\n",
       "name                                                          \n",
       "VIRTUE Tessa / MOIR Scott                            206.07   \n",
       "PAPADAKIS Gabriella / CIZERON Guillaume              205.28   \n",
       "SHIBUTANI Maia / SHIBUTANI Alex                      192.59   \n",
       "HUBBELL Madison / DONOHUE Zachary                    189.69   \n",
       "BOBROVA Ekaterina / SOLOVIEV Dmitri                  186.92   \n",
       "CAPPELLINI Anna / LANOTTE Luca                       186.91   \n",
       "WEAVER Kaitlyn / POJE Andrew                         181.98   \n",
       "CHOCK Madison / BATES Evan                           179.58   \n",
       "GILLES Piper / POIRIER Paul                          176.91   \n",
       "GUIGNARD Charlene / FABBRI Marco                     173.47   \n",
       "COOMES Penny / BUCKLAND Nicholas                     170.32   \n",
       "HURTADO Sara / KHALIAVIN Kirill                      168.33   \n",
       "ZAGORSKI Tiffani / GUERREIRO Jonathan                162.24   \n",
       "KALISZEK Natalia / SPODYRIEV Maksym                  161.35   \n",
       "MURAMOTO Kana / REED Chris                           160.63   \n",
       "LORENZ Kavita / POLIZOAKIS Joti                      150.49   \n",
       "LAURIAULT Marie-Jade / le GAC Romain                 149.59   \n",
       "MIN Yura / GAMELIN Alexander                         147.74   \n",
       "AGAFONOVA Alisa / UCAR Alper                         147.18   \n",
       "MYSLIVECKOVA Lucie / CSOLLEY Lukas                   142.57   \n",
       "WANG Shiyue / LIU Xinyu                               59.81   \n",
       "NAZAROVA Alexandra / NIKITIN Maxim                    57.97   \n",
       "MANSOUROVA Cortney / CESKA Michal                     53.53   \n",
       "TANKOVA Adel / ZILBERBERG Ronald                      46.66   \n",
       "\n",
       "                                         final_score_with_removal  \\\n",
       "name                                                                \n",
       "VIRTUE Tessa / MOIR Scott                                  205.86   \n",
       "PAPADAKIS Gabriella / CIZERON Guillaume                    206.32   \n",
       "SHIBUTANI Maia / SHIBUTANI Alex                            192.27   \n",
       "HUBBELL Madison / DONOHUE Zachary                          189.42   \n",
       "BOBROVA Ekaterina / SOLOVIEV Dmitri                        187.97   \n",
       "CAPPELLINI Anna / LANOTTE Luca                             187.00   \n",
       "WEAVER Kaitlyn / POJE Andrew                               180.34   \n",
       "CHOCK Madison / BATES Evan                                 178.83   \n",
       "GILLES Piper / POIRIER Paul                                176.22   \n",
       "GUIGNARD Charlene / FABBRI Marco                           173.19   \n",
       "COOMES Penny / BUCKLAND Nicholas                           169.86   \n",
       "HURTADO Sara / KHALIAVIN Kirill                            169.08   \n",
       "ZAGORSKI Tiffani / GUERREIRO Jonathan                      162.68   \n",
       "KALISZEK Natalia / SPODYRIEV Maksym                        162.31   \n",
       "MURAMOTO Kana / REED Chris                                 159.90   \n",
       "LORENZ Kavita / POLIZOAKIS Joti                            149.80   \n",
       "LAURIAULT Marie-Jade / le GAC Romain                       149.57   \n",
       "MIN Yura / GAMELIN Alexander                               147.25   \n",
       "AGAFONOVA Alisa / UCAR Alper                               148.93   \n",
       "MYSLIVECKOVA Lucie / CSOLLEY Lukas                         143.37   \n",
       "WANG Shiyue / LIU Xinyu                                     60.62   \n",
       "NAZAROVA Alexandra / NIKITIN Maxim                          58.34   \n",
       "MANSOUROVA Cortney / CESKA Michal                           54.02   \n",
       "TANKOVA Adel / ZILBERBERG Ronald                            46.98   \n",
       "\n",
       "                                         rank_actual  rank_with_removal  \n",
       "name                                                                     \n",
       "VIRTUE Tessa / MOIR Scott                          1                  2  \n",
       "PAPADAKIS Gabriella / CIZERON Guillaume            2                  1  \n",
       "SHIBUTANI Maia / SHIBUTANI Alex                    3                  3  \n",
       "HUBBELL Madison / DONOHUE Zachary                  4                  4  \n",
       "BOBROVA Ekaterina / SOLOVIEV Dmitri                5                  5  \n",
       "CAPPELLINI Anna / LANOTTE Luca                     6                  6  \n",
       "WEAVER Kaitlyn / POJE Andrew                       7                  7  \n",
       "CHOCK Madison / BATES Evan                         8                  8  \n",
       "GILLES Piper / POIRIER Paul                        9                  9  \n",
       "GUIGNARD Charlene / FABBRI Marco                  10                 10  \n",
       "COOMES Penny / BUCKLAND Nicholas                  11                 11  \n",
       "HURTADO Sara / KHALIAVIN Kirill                   12                 12  \n",
       "ZAGORSKI Tiffani / GUERREIRO Jonathan             13                 13  \n",
       "KALISZEK Natalia / SPODYRIEV Maksym               14                 14  \n",
       "MURAMOTO Kana / REED Chris                        15                 15  \n",
       "LORENZ Kavita / POLIZOAKIS Joti                   16                 16  \n",
       "LAURIAULT Marie-Jade / le GAC Romain              17                 17  \n",
       "MIN Yura / GAMELIN Alexander                      18                 19  \n",
       "AGAFONOVA Alisa / UCAR Alper                      19                 18  \n",
       "MYSLIVECKOVA Lucie / CSOLLEY Lukas                20                 20  \n",
       "WANG Shiyue / LIU Xinyu                           21                 21  \n",
       "NAZAROVA Alexandra / NIKITIN Maxim                22                 22  \n",
       "MANSOUROVA Cortney / CESKA Michal                 23                 23  \n",
       "TANKOVA Adel / ZILBERBERG Ronald                  24                 24  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(\n",
    "    final_actual.reset_index(),\n",
    "    final_with_removal.reset_index(),\n",
    "    on=\"name\",\n",
    "    suffixes=[\"_actual\", \"_with_removal\"]\n",
    ").set_index(\"name\")\\\n",
    "    .assign(\n",
    "        rank_actual = lambda x: x[\"final_score_actual\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "        rank_with_removal = lambda x: x[\"final_score_with_removal\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "## Men's Figure Skating Calculations"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Create subsets of scores with/without American and Chinese judges"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "men_olympics = scores_with_context[\n",
    "    scores_with_context[\"program\"].str.contains(\"Men\") &\n",
    "    ~scores_with_context[\"program\"].str.contains(\"Team\")\n",
    "].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>judge</th>\n",
       "      <th>J1</th>\n",
       "      <th>J2</th>\n",
       "      <th>J3</th>\n",
       "      <th>J4</th>\n",
       "      <th>J5</th>\n",
       "      <th>J6</th>\n",
       "      <th>J7</th>\n",
       "      <th>J8</th>\n",
       "      <th>J9</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>program</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>Men Single Skating - Free Skating</th>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Men Single Skating - Short Program</th>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "judge                                J1   J2   J3   J4   J5   J6   J7   J8  \\\n",
       "program                                                                      \n",
       "Men Single Skating - Free Skating   432  432  432  432  432  432  432  432   \n",
       "Men Single Skating - Short Program  358  358  358  358  358  358  358  358   \n",
       "\n",
       "judge                                J9  \n",
       "program                                  \n",
       "Men Single Skating - Free Skating   432  \n",
       "Men Single Skating - Short Program  358  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "men_olympics\\\n",
    "    .groupby([ \"program\", \"judge\"])\\\n",
    "    .size().unstack()\\\n",
    "    .fillna(0).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "men_olympics_without_usa_china = men_olympics[\n",
    "    ~(\n",
    "        # China\n",
    "        (\n",
    "            (men_olympics[\"judge\"] == \"J9\") &\n",
    "            (men_olympics[\"program\"] == \"Men Single Skating - Short Program\")\n",
    "        ) |\n",
    "        (\n",
    "            (men_olympics[\"judge\"] == \"J7\") &\n",
    "            (men_olympics[\"program\"] == \"Men Single Skating - Free Skating\")\n",
    "        ) |\n",
    "      \n",
    "        # United States\n",
    "        (\n",
    "\n",
    "            (men_olympics[\"judge\"] == \"J2\") &\n",
    "            (men_olympics[\"program\"] == \"Men Single Skating - Free Skating\")\n",
    "        )\n",
    "    )\n",
    "].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>judge</th>\n",
       "      <th>J1</th>\n",
       "      <th>J2</th>\n",
       "      <th>J3</th>\n",
       "      <th>J4</th>\n",
       "      <th>J5</th>\n",
       "      <th>J6</th>\n",
       "      <th>J7</th>\n",
       "      <th>J8</th>\n",
       "      <th>J9</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>program</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>Men Single Skating - Free Skating</th>\n",
       "      <td>432</td>\n",
       "      <td>0</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "      <td>0</td>\n",
       "      <td>432</td>\n",
       "      <td>432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Men Single Skating - Short Program</th>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>358</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "judge                                J1   J2   J3   J4   J5   J6   J7   J8  \\\n",
       "program                                                                      \n",
       "Men Single Skating - Free Skating   432    0  432  432  432  432    0  432   \n",
       "Men Single Skating - Short Program  358  358  358  358  358  358  358  358   \n",
       "\n",
       "judge                                J9  \n",
       "program                                  \n",
       "Men Single Skating - Free Skating   432  \n",
       "Men Single Skating - Short Program    0  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "men_olympics_without_usa_china\\\n",
    "    .groupby([ \"program\", \"judge\"])\\\n",
    "    .size().unstack()\\\n",
    "    .fillna(0).astype(int)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Calculate actual and alternate scoring scenarios for Men"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "men_aspect_scores = calculate_aspect_scores(men_olympics)\n",
    "men_final_actual = calculate_results(men_aspect_scores)\\\n",
    "    .sort_values(\"final_score\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "men_scores_with_replacement = calculate_score_with_average_judge(men_olympics_without_usa_china)\n",
    "men_final_with_replacement = calculate_results(men_scores_with_replacement)\\\n",
    "    .sort_values(\"final_score\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "men_scores_no_replacement = calculate_aspect_scores(men_olympics_without_usa_china)\n",
    "men_final_with_removal = calculate_results(men_scores_no_replacement)\\\n",
    "    .sort_values(\"final_score\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Actual scores vs. scores with CHN/USA replaced by \"average\" judgments"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>final_score_actual</th>\n",
       "      <th>final_score_with_replacement</th>\n",
       "      <th>rank_actual</th>\n",
       "      <th>rank_with_replacement</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>HANYU Yuzuru</th>\n",
       "      <td>317.85</td>\n",
       "      <td>318.68</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UNO Shoma</th>\n",
       "      <td>308.90</td>\n",
       "      <td>310.34</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FERNANDEZ Javier</th>\n",
       "      <td>305.24</td>\n",
       "      <td>307.01</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JIN Boyang</th>\n",
       "      <td>299.77</td>\n",
       "      <td>298.09</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHEN Nathan</th>\n",
       "      <td>299.35</td>\n",
       "      <td>298.73</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZHOU Vincent</th>\n",
       "      <td>276.69</td>\n",
       "      <td>275.75</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALIEV Dmitri</th>\n",
       "      <td>271.51</td>\n",
       "      <td>272.60</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KOLYADA Mikhail</th>\n",
       "      <td>270.25</td>\n",
       "      <td>271.83</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHAN Patrick</th>\n",
       "      <td>265.43</td>\n",
       "      <td>264.71</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RIPPON Adam</th>\n",
       "      <td>259.36</td>\n",
       "      <td>258.19</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MESSING Keegan</th>\n",
       "      <td>257.43</td>\n",
       "      <td>257.55</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BYCHENKO Alexei</th>\n",
       "      <td>257.01</td>\n",
       "      <td>258.35</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAMOHIN Daniel</th>\n",
       "      <td>253.44</td>\n",
       "      <td>253.42</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TANAKA Keiji</th>\n",
       "      <td>250.83</td>\n",
       "      <td>251.18</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHA Junhwan</th>\n",
       "      <td>250.59</td>\n",
       "      <td>249.17</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HENDRICKX Jorik</th>\n",
       "      <td>248.95</td>\n",
       "      <td>248.56</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BREZINA Michal</th>\n",
       "      <td>246.07</td>\n",
       "      <td>246.73</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GE Misha</th>\n",
       "      <td>244.94</td>\n",
       "      <td>244.19</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VASILJEVS Deniss</th>\n",
       "      <td>240.58</td>\n",
       "      <td>240.39</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KERRY Brendan</th>\n",
       "      <td>233.81</td>\n",
       "      <td>232.81</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RIZZO Matteo</th>\n",
       "      <td>232.41</td>\n",
       "      <td>232.66</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KVITELASHVILI Morisi</th>\n",
       "      <td>218.57</td>\n",
       "      <td>218.91</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YAN Han</th>\n",
       "      <td>217.01</td>\n",
       "      <td>215.56</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FENTZ Paul</th>\n",
       "      <td>214.55</td>\n",
       "      <td>214.42</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YEE Julian Zhi Jie</th>\n",
       "      <td>73.58</td>\n",
       "      <td>73.80</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BESSEGHIER Chafik</th>\n",
       "      <td>72.10</td>\n",
       "      <td>72.40</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TEN Denis</th>\n",
       "      <td>70.12</td>\n",
       "      <td>70.56</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARTINEZ Michael Christian</th>\n",
       "      <td>55.56</td>\n",
       "      <td>55.15</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MONTOYA Felipe</th>\n",
       "      <td>54.41</td>\n",
       "      <td>54.49</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PANIOT Yaroslav</th>\n",
       "      <td>50.58</td>\n",
       "      <td>50.51</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            final_score_actual  final_score_with_replacement  \\\n",
       "name                                                                           \n",
       "HANYU Yuzuru                            317.85                        318.68   \n",
       "UNO Shoma                               308.90                        310.34   \n",
       "FERNANDEZ Javier                        305.24                        307.01   \n",
       "JIN Boyang                              299.77                        298.09   \n",
       "CHEN Nathan                             299.35                        298.73   \n",
       "ZHOU Vincent                            276.69                        275.75   \n",
       "ALIEV Dmitri                            271.51                        272.60   \n",
       "KOLYADA Mikhail                         270.25                        271.83   \n",
       "CHAN Patrick                            265.43                        264.71   \n",
       "RIPPON Adam                             259.36                        258.19   \n",
       "MESSING Keegan                          257.43                        257.55   \n",
       "BYCHENKO Alexei                         257.01                        258.35   \n",
       "SAMOHIN Daniel                          253.44                        253.42   \n",
       "TANAKA Keiji                            250.83                        251.18   \n",
       "CHA Junhwan                             250.59                        249.17   \n",
       "HENDRICKX Jorik                         248.95                        248.56   \n",
       "BREZINA Michal                          246.07                        246.73   \n",
       "GE Misha                                244.94                        244.19   \n",
       "VASILJEVS Deniss                        240.58                        240.39   \n",
       "KERRY Brendan                           233.81                        232.81   \n",
       "RIZZO Matteo                            232.41                        232.66   \n",
       "KVITELASHVILI Morisi                    218.57                        218.91   \n",
       "YAN Han                                 217.01                        215.56   \n",
       "FENTZ Paul                              214.55                        214.42   \n",
       "YEE Julian Zhi Jie                       73.58                         73.80   \n",
       "BESSEGHIER Chafik                        72.10                         72.40   \n",
       "TEN Denis                                70.12                         70.56   \n",
       "MARTINEZ Michael Christian               55.56                         55.15   \n",
       "MONTOYA Felipe                           54.41                         54.49   \n",
       "PANIOT Yaroslav                          50.58                         50.51   \n",
       "\n",
       "                            rank_actual  rank_with_replacement  \n",
       "name                                                            \n",
       "HANYU Yuzuru                          1                      1  \n",
       "UNO Shoma                             2                      2  \n",
       "FERNANDEZ Javier                      3                      3  \n",
       "JIN Boyang                            4                      5  \n",
       "CHEN Nathan                           5                      4  \n",
       "ZHOU Vincent                          6                      6  \n",
       "ALIEV Dmitri                          7                      7  \n",
       "KOLYADA Mikhail                       8                      8  \n",
       "CHAN Patrick                          9                      9  \n",
       "RIPPON Adam                          10                     11  \n",
       "MESSING Keegan                       11                     12  \n",
       "BYCHENKO Alexei                      12                     10  \n",
       "SAMOHIN Daniel                       13                     13  \n",
       "TANAKA Keiji                         14                     14  \n",
       "CHA Junhwan                          15                     15  \n",
       "HENDRICKX Jorik                      16                     16  \n",
       "BREZINA Michal                       17                     17  \n",
       "GE Misha                             18                     18  \n",
       "VASILJEVS Deniss                     19                     19  \n",
       "KERRY Brendan                        20                     20  \n",
       "RIZZO Matteo                         21                     21  \n",
       "KVITELASHVILI Morisi                 22                     22  \n",
       "YAN Han                              23                     23  \n",
       "FENTZ Paul                           24                     24  \n",
       "YEE Julian Zhi Jie                   25                     25  \n",
       "BESSEGHIER Chafik                    26                     26  \n",
       "TEN Denis                            27                     27  \n",
       "MARTINEZ Michael Christian           28                     28  \n",
       "MONTOYA Felipe                       29                     29  \n",
       "PANIOT Yaroslav                      30                     30  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(\n",
    "    men_final_actual.reset_index(),\n",
    "    men_final_with_replacement.reset_index(),\n",
    "    on=\"name\",\n",
    "    suffixes=[\"_actual\", \"_with_replacement\"]\n",
    ").set_index(\"name\")\\\n",
    "    .assign(\n",
    "        rank_actual = lambda x: x[\"final_score_actual\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "        rank_with_replacement = lambda x: x[\"final_score_with_replacement\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Actual scores vs. scores with CHN/USA removed (and not replaced)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>final_score_actual</th>\n",
       "      <th>final_score_with_removal</th>\n",
       "      <th>rank_actual</th>\n",
       "      <th>rank_with_removal</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>HANYU Yuzuru</th>\n",
       "      <td>317.85</td>\n",
       "      <td>318.80</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UNO Shoma</th>\n",
       "      <td>308.90</td>\n",
       "      <td>310.44</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FERNANDEZ Javier</th>\n",
       "      <td>305.24</td>\n",
       "      <td>307.14</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JIN Boyang</th>\n",
       "      <td>299.77</td>\n",
       "      <td>298.15</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHEN Nathan</th>\n",
       "      <td>299.35</td>\n",
       "      <td>298.82</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZHOU Vincent</th>\n",
       "      <td>276.69</td>\n",
       "      <td>275.80</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALIEV Dmitri</th>\n",
       "      <td>271.51</td>\n",
       "      <td>272.63</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KOLYADA Mikhail</th>\n",
       "      <td>270.25</td>\n",
       "      <td>271.92</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHAN Patrick</th>\n",
       "      <td>265.43</td>\n",
       "      <td>264.67</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RIPPON Adam</th>\n",
       "      <td>259.36</td>\n",
       "      <td>258.23</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MESSING Keegan</th>\n",
       "      <td>257.43</td>\n",
       "      <td>257.46</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BYCHENKO Alexei</th>\n",
       "      <td>257.01</td>\n",
       "      <td>258.34</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAMOHIN Daniel</th>\n",
       "      <td>253.44</td>\n",
       "      <td>253.48</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TANAKA Keiji</th>\n",
       "      <td>250.83</td>\n",
       "      <td>251.34</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHA Junhwan</th>\n",
       "      <td>250.59</td>\n",
       "      <td>249.18</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HENDRICKX Jorik</th>\n",
       "      <td>248.95</td>\n",
       "      <td>248.54</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BREZINA Michal</th>\n",
       "      <td>246.07</td>\n",
       "      <td>246.70</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GE Misha</th>\n",
       "      <td>244.94</td>\n",
       "      <td>244.16</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VASILJEVS Deniss</th>\n",
       "      <td>240.58</td>\n",
       "      <td>240.35</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KERRY Brendan</th>\n",
       "      <td>233.81</td>\n",
       "      <td>232.70</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RIZZO Matteo</th>\n",
       "      <td>232.41</td>\n",
       "      <td>232.54</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KVITELASHVILI Morisi</th>\n",
       "      <td>218.57</td>\n",
       "      <td>218.89</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YAN Han</th>\n",
       "      <td>217.01</td>\n",
       "      <td>215.78</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FENTZ Paul</th>\n",
       "      <td>214.55</td>\n",
       "      <td>214.26</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YEE Julian Zhi Jie</th>\n",
       "      <td>73.58</td>\n",
       "      <td>73.75</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BESSEGHIER Chafik</th>\n",
       "      <td>72.10</td>\n",
       "      <td>72.41</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TEN Denis</th>\n",
       "      <td>70.12</td>\n",
       "      <td>70.56</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARTINEZ Michael Christian</th>\n",
       "      <td>55.56</td>\n",
       "      <td>55.15</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MONTOYA Felipe</th>\n",
       "      <td>54.41</td>\n",
       "      <td>54.47</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PANIOT Yaroslav</th>\n",
       "      <td>50.58</td>\n",
       "      <td>50.51</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            final_score_actual  final_score_with_removal  \\\n",
       "name                                                                       \n",
       "HANYU Yuzuru                            317.85                    318.80   \n",
       "UNO Shoma                               308.90                    310.44   \n",
       "FERNANDEZ Javier                        305.24                    307.14   \n",
       "JIN Boyang                              299.77                    298.15   \n",
       "CHEN Nathan                             299.35                    298.82   \n",
       "ZHOU Vincent                            276.69                    275.80   \n",
       "ALIEV Dmitri                            271.51                    272.63   \n",
       "KOLYADA Mikhail                         270.25                    271.92   \n",
       "CHAN Patrick                            265.43                    264.67   \n",
       "RIPPON Adam                             259.36                    258.23   \n",
       "MESSING Keegan                          257.43                    257.46   \n",
       "BYCHENKO Alexei                         257.01                    258.34   \n",
       "SAMOHIN Daniel                          253.44                    253.48   \n",
       "TANAKA Keiji                            250.83                    251.34   \n",
       "CHA Junhwan                             250.59                    249.18   \n",
       "HENDRICKX Jorik                         248.95                    248.54   \n",
       "BREZINA Michal                          246.07                    246.70   \n",
       "GE Misha                                244.94                    244.16   \n",
       "VASILJEVS Deniss                        240.58                    240.35   \n",
       "KERRY Brendan                           233.81                    232.70   \n",
       "RIZZO Matteo                            232.41                    232.54   \n",
       "KVITELASHVILI Morisi                    218.57                    218.89   \n",
       "YAN Han                                 217.01                    215.78   \n",
       "FENTZ Paul                              214.55                    214.26   \n",
       "YEE Julian Zhi Jie                       73.58                     73.75   \n",
       "BESSEGHIER Chafik                        72.10                     72.41   \n",
       "TEN Denis                                70.12                     70.56   \n",
       "MARTINEZ Michael Christian               55.56                     55.15   \n",
       "MONTOYA Felipe                           54.41                     54.47   \n",
       "PANIOT Yaroslav                          50.58                     50.51   \n",
       "\n",
       "                            rank_actual  rank_with_removal  \n",
       "name                                                        \n",
       "HANYU Yuzuru                          1                  1  \n",
       "UNO Shoma                             2                  2  \n",
       "FERNANDEZ Javier                      3                  3  \n",
       "JIN Boyang                            4                  5  \n",
       "CHEN Nathan                           5                  4  \n",
       "ZHOU Vincent                          6                  6  \n",
       "ALIEV Dmitri                          7                  7  \n",
       "KOLYADA Mikhail                       8                  8  \n",
       "CHAN Patrick                          9                  9  \n",
       "RIPPON Adam                          10                 11  \n",
       "MESSING Keegan                       11                 12  \n",
       "BYCHENKO Alexei                      12                 10  \n",
       "SAMOHIN Daniel                       13                 13  \n",
       "TANAKA Keiji                         14                 14  \n",
       "CHA Junhwan                          15                 15  \n",
       "HENDRICKX Jorik                      16                 16  \n",
       "BREZINA Michal                       17                 17  \n",
       "GE Misha                             18                 18  \n",
       "VASILJEVS Deniss                     19                 19  \n",
       "KERRY Brendan                        20                 20  \n",
       "RIZZO Matteo                         21                 21  \n",
       "KVITELASHVILI Morisi                 22                 22  \n",
       "YAN Han                              23                 23  \n",
       "FENTZ Paul                           24                 24  \n",
       "YEE Julian Zhi Jie                   25                 25  \n",
       "BESSEGHIER Chafik                    26                 26  \n",
       "TEN Denis                            27                 27  \n",
       "MARTINEZ Michael Christian           28                 28  \n",
       "MONTOYA Felipe                       29                 29  \n",
       "PANIOT Yaroslav                      30                 30  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(\n",
    "    men_final_actual.reset_index(),\n",
    "    men_final_with_removal.reset_index(),\n",
    "    on=\"name\",\n",
    "    suffixes=[\"_actual\", \"_with_removal\"]\n",
    ").set_index(\"name\")\\\n",
    "    .assign(\n",
    "        rank_actual = lambda x: x[\"final_score_actual\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "        rank_with_removal = lambda x: x[\"final_score_with_removal\"]\\\n",
    "            .rank(ascending = False)\\\n",
    "            .astype(int),\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "---\n",
    "\n",
    "---"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}