2020_Women.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# All Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['sort', 'pagination', 'cachekey', 'dataType', 'competition', 'leaderboardRows', 'version', 'ordinals', 'totalPages', 'currentPage'])"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import json\n",
    "\n",
    "with open('Women/2020_games.json') as f:\n",
    "    data = json.load(f)\n",
    "    \n",
    "data.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "leaderboard = data['leaderboardRows']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "database = []\n",
    "for i in range(len(leaderboard)):\n",
    "    competitors = leaderboard[i]['entrant']['competitorName']\n",
    "    for j in range(len(leaderboard[i]['scores'])):\n",
    "        workout_number = leaderboard[i]['scores'][j]['ordinal']\n",
    "        times = leaderboard[i]['scores'][j]['time']\n",
    "        ranks = leaderboard[i]['scores'][j]['rank']\n",
    "        score = leaderboard[i]['scores'][j]['breakdown']\n",
    "        database.append([competitors, workout_number, times, ranks, score])\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "full_data = pd.DataFrame(database, columns=['competitors', 'ordinals', 'times', 'ranks', 'score'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Event 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_1 = full_data[full_data['ordinals']==1].sort_values('times')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "total_seconds = []\n",
    "for i, j in event_1.iterrows(): \n",
    "    datetime_convert = datetime.strptime(j['times'],'%M:%S')\n",
    "    total_seconds.append(datetime_convert.second + datetime_convert.minute*60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_1['total_seconds'] = total_seconds\n",
    "\n",
    "lst = list(event_1['total_seconds']-min(event_1['total_seconds']))\n",
    "event_1['adjusted_score'] = [100 - i*(100/max(lst)) for i in lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>1</td>\n",
       "      <td>3:40</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>220</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>1</td>\n",
       "      <td>3:49</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>229</td>\n",
       "      <td>95.287958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>1</td>\n",
       "      <td>4:28</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>268</td>\n",
       "      <td>74.869110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>1</td>\n",
       "      <td>4:33</td>\n",
       "      <td>4</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>273</td>\n",
       "      <td>72.251309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>1</td>\n",
       "      <td>4:36</td>\n",
       "      <td>5</td>\n",
       "      <td>84 pts</td>\n",
       "      <td>276</td>\n",
       "      <td>70.680628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>1</td>\n",
       "      <td>4:41</td>\n",
       "      <td>6</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>281</td>\n",
       "      <td>68.062827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>1</td>\n",
       "      <td>4:42</td>\n",
       "      <td>7</td>\n",
       "      <td>76 pts</td>\n",
       "      <td>282</td>\n",
       "      <td>67.539267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>1</td>\n",
       "      <td>4:45</td>\n",
       "      <td>8</td>\n",
       "      <td>72 pts</td>\n",
       "      <td>285</td>\n",
       "      <td>65.968586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>1</td>\n",
       "      <td>4:46</td>\n",
       "      <td>9</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>286</td>\n",
       "      <td>65.445026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>1</td>\n",
       "      <td>4:48</td>\n",
       "      <td>10</td>\n",
       "      <td>64 pts</td>\n",
       "      <td>288</td>\n",
       "      <td>64.397906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>1</td>\n",
       "      <td>4:54</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>294</td>\n",
       "      <td>61.256545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>1</td>\n",
       "      <td>4:56</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>296</td>\n",
       "      <td>60.209424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>1</td>\n",
       "      <td>5:01</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>301</td>\n",
       "      <td>57.591623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>1</td>\n",
       "      <td>5:02</td>\n",
       "      <td>14</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>302</td>\n",
       "      <td>57.068063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>1</td>\n",
       "      <td>5:13</td>\n",
       "      <td>15</td>\n",
       "      <td>46 pts</td>\n",
       "      <td>313</td>\n",
       "      <td>51.308901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>1</td>\n",
       "      <td>5:16</td>\n",
       "      <td>16</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>316</td>\n",
       "      <td>49.738220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>1</td>\n",
       "      <td>5:18</td>\n",
       "      <td>17T</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>318</td>\n",
       "      <td>48.691099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>1</td>\n",
       "      <td>5:18</td>\n",
       "      <td>17T</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>318</td>\n",
       "      <td>48.691099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>1</td>\n",
       "      <td>5:21</td>\n",
       "      <td>19</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>321</td>\n",
       "      <td>47.120419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>1</td>\n",
       "      <td>5:23</td>\n",
       "      <td>20</td>\n",
       "      <td>31 pts</td>\n",
       "      <td>323</td>\n",
       "      <td>46.073298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>1</td>\n",
       "      <td>5:25</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>325</td>\n",
       "      <td>45.026178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>1</td>\n",
       "      <td>5:26</td>\n",
       "      <td>22</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>326</td>\n",
       "      <td>44.502618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>1</td>\n",
       "      <td>5:45</td>\n",
       "      <td>23</td>\n",
       "      <td>22 pts</td>\n",
       "      <td>345</td>\n",
       "      <td>34.554974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>1</td>\n",
       "      <td>5:47</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>347</td>\n",
       "      <td>33.507853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>1</td>\n",
       "      <td>5:50</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>350</td>\n",
       "      <td>31.937173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>1</td>\n",
       "      <td>5:52</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>352</td>\n",
       "      <td>30.890052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>1</td>\n",
       "      <td>5:54</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>354</td>\n",
       "      <td>29.842932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>1</td>\n",
       "      <td>6:06</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>366</td>\n",
       "      <td>23.560209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>1</td>\n",
       "      <td>6:26</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>386</td>\n",
       "      <td>13.089005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>1</td>\n",
       "      <td>6:51</td>\n",
       "      <td>30</td>\n",
       "      <td>1 pts</td>\n",
       "      <td>411</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals times ranks    score  \\\n",
       "0                  Tia-Clair Toomey         1  3:40     1  100 pts   \n",
       "49                    Kara Saunders         1  3:49     2   96 pts   \n",
       "7                      Brooke Wells         1  4:28     3   92 pts   \n",
       "105                   Kristine Best         1  4:33     4   88 pts   \n",
       "14                      Haley Adams         1  4:36     5   84 pts   \n",
       "56           Kristi Eramo O'Connell         1  4:41     6   80 pts   \n",
       "77                   Jamie Simmonds         1  4:42     7   76 pts   \n",
       "112                Melina Rodriguez         1  4:45     8   72 pts   \n",
       "126                    Emma McQuaid         1  4:46     9   68 pts   \n",
       "28                      Kari Pearce         1  4:48    10   64 pts   \n",
       "70        Carol-Ann Reason-Thibault         1  4:54    11   60 pts   \n",
       "21        Katrin Tanja Davidsdottir         1  4:56    12   56 pts   \n",
       "35                    Kristin Holte         1  5:01    13   52 pts   \n",
       "168                 Samantha Briggs         1  5:02    14   49 pts   \n",
       "133               Bethany Shadburne         1  5:13    15   46 pts   \n",
       "63                    Andrea Nisler         1  5:16    16   43 pts   \n",
       "196                     Brooke Haas         1  5:18   17T   40 pts   \n",
       "119                 Gabriela Migała         1  5:18   17T   40 pts   \n",
       "98                 Danielle Brandon         1  5:21    19   34 pts   \n",
       "154     Camilla Salomonsson Hellman         1  5:23    20   31 pts   \n",
       "147              Kendall Vincelette         1  5:25    21   28 pts   \n",
       "42                  Amanda Barnhart         1  5:26    22   25 pts   \n",
       "91                    Karin Freyová         1  5:45    23   22 pts   \n",
       "161                   Laura Horváth         1  5:47    24   19 pts   \n",
       "84                     Dani Speegle         1  5:50    25   16 pts   \n",
       "182                  Andrea Solberg         1  5:52    26   13 pts   \n",
       "140  Ragnheiður Sara Sigmundsdottir         1  5:54    27   10 pts   \n",
       "175                   Laura Clifton         1  6:06    28    7 pts   \n",
       "189                 Harriet Roberts         1  6:26    29    4 pts   \n",
       "203                Sanna Venäläinen         1  6:51    30    1 pts   \n",
       "\n",
       "     total_seconds  adjusted_score  \n",
       "0              220      100.000000  \n",
       "49             229       95.287958  \n",
       "7              268       74.869110  \n",
       "105            273       72.251309  \n",
       "14             276       70.680628  \n",
       "56             281       68.062827  \n",
       "77             282       67.539267  \n",
       "112            285       65.968586  \n",
       "126            286       65.445026  \n",
       "28             288       64.397906  \n",
       "70             294       61.256545  \n",
       "21             296       60.209424  \n",
       "35             301       57.591623  \n",
       "168            302       57.068063  \n",
       "133            313       51.308901  \n",
       "63             316       49.738220  \n",
       "196            318       48.691099  \n",
       "119            318       48.691099  \n",
       "98             321       47.120419  \n",
       "154            323       46.073298  \n",
       "147            325       45.026178  \n",
       "42             326       44.502618  \n",
       "91             345       34.554974  \n",
       "161            347       33.507853  \n",
       "84             350       31.937173  \n",
       "182            352       30.890052  \n",
       "140            354       29.842932  \n",
       "175            366       23.560209  \n",
       "189            386       13.089005  \n",
       "203            411        0.000000  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Event 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_2 = full_data[full_data['ordinals']==2].sort_values('times')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_2['times'] = [int(i) for i in event_2['times']]\n",
    "lst = list(event_2['times']-min(event_2['times']))\n",
    "event_2['adjusted_score'] = [i*(100/max(lst)) for i in lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>2</td>\n",
       "      <td>215</td>\n",
       "      <td>30</td>\n",
       "      <td>1 pts</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>2</td>\n",
       "      <td>223</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>8.163265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>2</td>\n",
       "      <td>225</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>10.204082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>2</td>\n",
       "      <td>230</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>15.306122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>2</td>\n",
       "      <td>230</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>15.306122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>2</td>\n",
       "      <td>238</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>23.469388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>2</td>\n",
       "      <td>241</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>26.530612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>2</td>\n",
       "      <td>244</td>\n",
       "      <td>23</td>\n",
       "      <td>22 pts</td>\n",
       "      <td>29.591837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>2</td>\n",
       "      <td>246</td>\n",
       "      <td>22</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>31.632653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>2</td>\n",
       "      <td>250</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>35.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>2</td>\n",
       "      <td>253</td>\n",
       "      <td>19</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>38.775510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>2</td>\n",
       "      <td>253</td>\n",
       "      <td>20</td>\n",
       "      <td>31 pts</td>\n",
       "      <td>38.775510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>2</td>\n",
       "      <td>255</td>\n",
       "      <td>18</td>\n",
       "      <td>37 pts</td>\n",
       "      <td>40.816327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>2</td>\n",
       "      <td>259</td>\n",
       "      <td>17</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>44.897959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>2</td>\n",
       "      <td>262</td>\n",
       "      <td>16</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>47.959184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>2</td>\n",
       "      <td>265</td>\n",
       "      <td>15</td>\n",
       "      <td>46 pts</td>\n",
       "      <td>51.020408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>2</td>\n",
       "      <td>267</td>\n",
       "      <td>14</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>53.061224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>2</td>\n",
       "      <td>270</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>56.122449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>2</td>\n",
       "      <td>275</td>\n",
       "      <td>9</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>61.224490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>2</td>\n",
       "      <td>275</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>61.224490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>2</td>\n",
       "      <td>275</td>\n",
       "      <td>10</td>\n",
       "      <td>64 pts</td>\n",
       "      <td>61.224490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>2</td>\n",
       "      <td>275</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>61.224490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>2</td>\n",
       "      <td>281</td>\n",
       "      <td>8</td>\n",
       "      <td>72 pts</td>\n",
       "      <td>67.346939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>2</td>\n",
       "      <td>283</td>\n",
       "      <td>7</td>\n",
       "      <td>76 pts</td>\n",
       "      <td>69.387755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>2</td>\n",
       "      <td>287</td>\n",
       "      <td>6</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>73.469388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>2</td>\n",
       "      <td>291</td>\n",
       "      <td>5</td>\n",
       "      <td>84 pts</td>\n",
       "      <td>77.551020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>2</td>\n",
       "      <td>293</td>\n",
       "      <td>4</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>79.591837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>2</td>\n",
       "      <td>294</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>80.612245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>2</td>\n",
       "      <td>302</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>88.775510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>2</td>\n",
       "      <td>313</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals  times ranks    score  \\\n",
       "183                  Andrea Solberg         2    215    30    1 pts   \n",
       "190                 Harriet Roberts         2    223    29    4 pts   \n",
       "169                 Samantha Briggs         2    225    28    7 pts   \n",
       "15                      Haley Adams         2    230    26   13 pts   \n",
       "22        Katrin Tanja Davidsdottir         2    230    27   10 pts   \n",
       "134               Bethany Shadburne         2    238    25   16 pts   \n",
       "148              Kendall Vincelette         2    241    24   19 pts   \n",
       "99                 Danielle Brandon         2    244    23   22 pts   \n",
       "29                      Kari Pearce         2    246    22   25 pts   \n",
       "71        Carol-Ann Reason-Thibault         2    250    21   28 pts   \n",
       "127                    Emma McQuaid         2    253    19   34 pts   \n",
       "197                     Brooke Haas         2    253    20   31 pts   \n",
       "141  Ragnheiður Sara Sigmundsdottir         2    255    18   37 pts   \n",
       "155     Camilla Salomonsson Hellman         2    259    17   40 pts   \n",
       "204                Sanna Venäläinen         2    262    16   43 pts   \n",
       "120                 Gabriela Migała         2    265    15   46 pts   \n",
       "36                    Kristin Holte         2    267    14   49 pts   \n",
       "78                   Jamie Simmonds         2    270    13   52 pts   \n",
       "113                Melina Rodriguez         2    275     9   68 pts   \n",
       "162                   Laura Horváth         2    275    12   56 pts   \n",
       "8                      Brooke Wells         2    275    10   64 pts   \n",
       "92                    Karin Freyová         2    275    11   60 pts   \n",
       "57           Kristi Eramo O'Connell         2    281     8   72 pts   \n",
       "106                   Kristine Best         2    283     7   76 pts   \n",
       "64                    Andrea Nisler         2    287     6   80 pts   \n",
       "43                  Amanda Barnhart         2    291     5   84 pts   \n",
       "85                     Dani Speegle         2    293     4   88 pts   \n",
       "50                    Kara Saunders         2    294     3   92 pts   \n",
       "176                   Laura Clifton         2    302     2   96 pts   \n",
       "1                  Tia-Clair Toomey         2    313     1  100 pts   \n",
       "\n",
       "     adjusted_score  \n",
       "183        0.000000  \n",
       "190        8.163265  \n",
       "169       10.204082  \n",
       "15        15.306122  \n",
       "22        15.306122  \n",
       "134       23.469388  \n",
       "148       26.530612  \n",
       "99        29.591837  \n",
       "29        31.632653  \n",
       "71        35.714286  \n",
       "127       38.775510  \n",
       "197       38.775510  \n",
       "141       40.816327  \n",
       "155       44.897959  \n",
       "204       47.959184  \n",
       "120       51.020408  \n",
       "36        53.061224  \n",
       "78        56.122449  \n",
       "113       61.224490  \n",
       "162       61.224490  \n",
       "8         61.224490  \n",
       "92        61.224490  \n",
       "57        67.346939  \n",
       "106       69.387755  \n",
       "64        73.469388  \n",
       "43        77.551020  \n",
       "85        79.591837  \n",
       "50        80.612245  \n",
       "176       88.775510  \n",
       "1        100.000000  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Event 3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_3 = full_data[full_data['ordinals']==3].sort_values('times')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "total_seconds = []\n",
    "for i, j in event_3.iterrows(): \n",
    "    if 'CAP' in j['times']:\n",
    "        total_seconds.append(600+7)\n",
    "    else:\n",
    "        datetime_convert = datetime.strptime(j['times'],'%M:%S')\n",
    "        total_seconds.append(datetime_convert.second + datetime_convert.minute*60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_3['total_seconds'] = total_seconds\n",
    "\n",
    "lst = list(event_3['total_seconds']-min(event_3['total_seconds']))\n",
    "event_3['adjusted_score'] = [100 - i*(100/max(lst)) for i in lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>3</td>\n",
       "      <td>2:28</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>148</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>3</td>\n",
       "      <td>2:31</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>151</td>\n",
       "      <td>99.346405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>3</td>\n",
       "      <td>2:34</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>154</td>\n",
       "      <td>98.692810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>3</td>\n",
       "      <td>2:40</td>\n",
       "      <td>4</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>160</td>\n",
       "      <td>97.385621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>3</td>\n",
       "      <td>2:50</td>\n",
       "      <td>5</td>\n",
       "      <td>84 pts</td>\n",
       "      <td>170</td>\n",
       "      <td>95.206972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>3</td>\n",
       "      <td>3:11</td>\n",
       "      <td>6</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>191</td>\n",
       "      <td>90.631808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>3</td>\n",
       "      <td>3:17</td>\n",
       "      <td>7</td>\n",
       "      <td>76 pts</td>\n",
       "      <td>197</td>\n",
       "      <td>89.324619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>3</td>\n",
       "      <td>3:22</td>\n",
       "      <td>8</td>\n",
       "      <td>72 pts</td>\n",
       "      <td>202</td>\n",
       "      <td>88.235294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>3</td>\n",
       "      <td>3:25</td>\n",
       "      <td>9</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>205</td>\n",
       "      <td>87.581699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>3</td>\n",
       "      <td>3:29</td>\n",
       "      <td>10</td>\n",
       "      <td>64 pts</td>\n",
       "      <td>209</td>\n",
       "      <td>86.710240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>3</td>\n",
       "      <td>3:30</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>210</td>\n",
       "      <td>86.492375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>3</td>\n",
       "      <td>3:40</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>220</td>\n",
       "      <td>84.313725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>3</td>\n",
       "      <td>3:42</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>222</td>\n",
       "      <td>83.877996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>3</td>\n",
       "      <td>3:53</td>\n",
       "      <td>14</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>233</td>\n",
       "      <td>81.481481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>3</td>\n",
       "      <td>3:57</td>\n",
       "      <td>15</td>\n",
       "      <td>46 pts</td>\n",
       "      <td>237</td>\n",
       "      <td>80.610022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>3</td>\n",
       "      <td>4:04</td>\n",
       "      <td>16</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>244</td>\n",
       "      <td>79.084967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>3</td>\n",
       "      <td>4:10</td>\n",
       "      <td>17T</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>250</td>\n",
       "      <td>77.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>3</td>\n",
       "      <td>4:10</td>\n",
       "      <td>17T</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>250</td>\n",
       "      <td>77.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>3</td>\n",
       "      <td>4:17</td>\n",
       "      <td>19</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>257</td>\n",
       "      <td>76.252723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>3</td>\n",
       "      <td>4:20</td>\n",
       "      <td>20</td>\n",
       "      <td>31 pts</td>\n",
       "      <td>260</td>\n",
       "      <td>75.599129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>3</td>\n",
       "      <td>4:38</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>278</td>\n",
       "      <td>71.677560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>3</td>\n",
       "      <td>4:45</td>\n",
       "      <td>22</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>285</td>\n",
       "      <td>70.152505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>3</td>\n",
       "      <td>5:04</td>\n",
       "      <td>23</td>\n",
       "      <td>22 pts</td>\n",
       "      <td>304</td>\n",
       "      <td>66.013072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>3</td>\n",
       "      <td>5:09</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>309</td>\n",
       "      <td>64.923747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>3</td>\n",
       "      <td>5:20</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>320</td>\n",
       "      <td>62.527233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>3</td>\n",
       "      <td>5:47</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>347</td>\n",
       "      <td>56.644880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>3</td>\n",
       "      <td>6:41</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>401</td>\n",
       "      <td>44.880174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>3</td>\n",
       "      <td>6:43</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>403</td>\n",
       "      <td>44.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>3</td>\n",
       "      <td>9:01</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>541</td>\n",
       "      <td>14.379085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>3</td>\n",
       "      <td>CAP+7</td>\n",
       "      <td>30</td>\n",
       "      <td>1 pts</td>\n",
       "      <td>607</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals  times ranks    score  \\\n",
       "2                  Tia-Clair Toomey         3   2:28     1  100 pts   \n",
       "72        Carol-Ann Reason-Thibault         3   2:31     2   96 pts   \n",
       "9                      Brooke Wells         3   2:34     3   92 pts   \n",
       "30                      Kari Pearce         3   2:40     4   88 pts   \n",
       "37                    Kristin Holte         3   2:50     5   84 pts   \n",
       "149              Kendall Vincelette         3   3:11     6   80 pts   \n",
       "44                  Amanda Barnhart         3   3:17     7   76 pts   \n",
       "128                    Emma McQuaid         3   3:22     8   72 pts   \n",
       "184                  Andrea Solberg         3   3:25     9   68 pts   \n",
       "86                     Dani Speegle         3   3:29    10   64 pts   \n",
       "23        Katrin Tanja Davidsdottir         3   3:30    11   60 pts   \n",
       "16                      Haley Adams         3   3:40    12   56 pts   \n",
       "100                Danielle Brandon         3   3:42    13   52 pts   \n",
       "58           Kristi Eramo O'Connell         3   3:53    14   49 pts   \n",
       "114                Melina Rodriguez         3   3:57    15   46 pts   \n",
       "191                 Harriet Roberts         3   4:04    16   43 pts   \n",
       "135               Bethany Shadburne         3   4:10   17T   40 pts   \n",
       "79                   Jamie Simmonds         3   4:10   17T   40 pts   \n",
       "121                 Gabriela Migała         3   4:17    19   34 pts   \n",
       "51                    Kara Saunders         3   4:20    20   31 pts   \n",
       "142  Ragnheiður Sara Sigmundsdottir         3   4:38    21   28 pts   \n",
       "198                     Brooke Haas         3   4:45    22   25 pts   \n",
       "65                    Andrea Nisler         3   5:04    23   22 pts   \n",
       "205                Sanna Venäläinen         3   5:09    24   19 pts   \n",
       "107                   Kristine Best         3   5:20    25   16 pts   \n",
       "156     Camilla Salomonsson Hellman         3   5:47    26   13 pts   \n",
       "93                    Karin Freyová         3   6:41    27   10 pts   \n",
       "170                 Samantha Briggs         3   6:43    28    7 pts   \n",
       "177                   Laura Clifton         3   9:01    29    4 pts   \n",
       "163                   Laura Horváth         3  CAP+7    30    1 pts   \n",
       "\n",
       "     total_seconds  adjusted_score  \n",
       "2              148      100.000000  \n",
       "72             151       99.346405  \n",
       "9              154       98.692810  \n",
       "30             160       97.385621  \n",
       "37             170       95.206972  \n",
       "149            191       90.631808  \n",
       "44             197       89.324619  \n",
       "128            202       88.235294  \n",
       "184            205       87.581699  \n",
       "86             209       86.710240  \n",
       "23             210       86.492375  \n",
       "16             220       84.313725  \n",
       "100            222       83.877996  \n",
       "58             233       81.481481  \n",
       "114            237       80.610022  \n",
       "191            244       79.084967  \n",
       "135            250       77.777778  \n",
       "79             250       77.777778  \n",
       "121            257       76.252723  \n",
       "51             260       75.599129  \n",
       "142            278       71.677560  \n",
       "198            285       70.152505  \n",
       "65             304       66.013072  \n",
       "205            309       64.923747  \n",
       "107            320       62.527233  \n",
       "156            347       56.644880  \n",
       "93             401       44.880174  \n",
       "170            403       44.444444  \n",
       "177            541       14.379085  \n",
       "163            607        0.000000  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Event 4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_4 = full_data[full_data['ordinals']==4].sort_values('times')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "total_seconds = []\n",
    "for i, j in event_4.iterrows(): \n",
    "    datetime_convert = datetime.strptime(j['times'],'%M:%S.%f')\n",
    "    total_seconds.append(datetime_convert.second + datetime_convert.minute*60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_4['total_seconds'] = total_seconds\n",
    "\n",
    "lst = list(event_4['total_seconds']-min(event_4['total_seconds']))\n",
    "event_4['adjusted_score'] = [100 - i*(100/max(lst)) for i in lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>4</td>\n",
       "      <td>3:15.80</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>195</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>4</td>\n",
       "      <td>3:17.40</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>197</td>\n",
       "      <td>90.476190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>4</td>\n",
       "      <td>3:18.10</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>198</td>\n",
       "      <td>85.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>4</td>\n",
       "      <td>3:20.60</td>\n",
       "      <td>4</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>200</td>\n",
       "      <td>76.190476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>4</td>\n",
       "      <td>3:21.10</td>\n",
       "      <td>5</td>\n",
       "      <td>84 pts</td>\n",
       "      <td>201</td>\n",
       "      <td>71.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>4</td>\n",
       "      <td>3:21.30</td>\n",
       "      <td>6T</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>201</td>\n",
       "      <td>71.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>4</td>\n",
       "      <td>3:21.30</td>\n",
       "      <td>6T</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>201</td>\n",
       "      <td>71.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>4</td>\n",
       "      <td>3:21.30</td>\n",
       "      <td>6T</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>201</td>\n",
       "      <td>71.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>4</td>\n",
       "      <td>3:21.60</td>\n",
       "      <td>9T</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>201</td>\n",
       "      <td>71.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>4</td>\n",
       "      <td>3:21.60</td>\n",
       "      <td>9T</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>201</td>\n",
       "      <td>71.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>4</td>\n",
       "      <td>3:22.40</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>202</td>\n",
       "      <td>66.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>4</td>\n",
       "      <td>3:22.60</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>202</td>\n",
       "      <td>66.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>4</td>\n",
       "      <td>3:23.20</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>203</td>\n",
       "      <td>61.904762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>4</td>\n",
       "      <td>3:26.00</td>\n",
       "      <td>14</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>206</td>\n",
       "      <td>47.619048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>4</td>\n",
       "      <td>3:27.40</td>\n",
       "      <td>15</td>\n",
       "      <td>46 pts</td>\n",
       "      <td>207</td>\n",
       "      <td>42.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>4</td>\n",
       "      <td>3:27.60</td>\n",
       "      <td>16</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>207</td>\n",
       "      <td>42.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>4</td>\n",
       "      <td>3:29.40</td>\n",
       "      <td>17</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>209</td>\n",
       "      <td>33.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>4</td>\n",
       "      <td>3:29.50</td>\n",
       "      <td>18</td>\n",
       "      <td>37 pts</td>\n",
       "      <td>209</td>\n",
       "      <td>33.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>4</td>\n",
       "      <td>3:30.20</td>\n",
       "      <td>19</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>210</td>\n",
       "      <td>28.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>4</td>\n",
       "      <td>3:30.60</td>\n",
       "      <td>20</td>\n",
       "      <td>31 pts</td>\n",
       "      <td>210</td>\n",
       "      <td>28.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>4</td>\n",
       "      <td>3:31.00</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>211</td>\n",
       "      <td>23.809524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>4</td>\n",
       "      <td>3:32.10</td>\n",
       "      <td>22</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>212</td>\n",
       "      <td>19.047619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>4</td>\n",
       "      <td>3:33.40</td>\n",
       "      <td>23</td>\n",
       "      <td>22 pts</td>\n",
       "      <td>213</td>\n",
       "      <td>14.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>4</td>\n",
       "      <td>3:33.60</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>213</td>\n",
       "      <td>14.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>4</td>\n",
       "      <td>3:33.90</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>213</td>\n",
       "      <td>14.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>4</td>\n",
       "      <td>3:35.70</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>215</td>\n",
       "      <td>4.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>4</td>\n",
       "      <td>3:36.00</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>216</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>4</td>\n",
       "      <td>3:36.20</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>216</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>4</td>\n",
       "      <td>3:36.50</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>216</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>4</td>\n",
       "      <td>3:36.90</td>\n",
       "      <td>30</td>\n",
       "      <td>1 pts</td>\n",
       "      <td>216</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals    times ranks    score  \\\n",
       "94                    Karin Freyová         4  3:15.80     1  100 pts   \n",
       "45                  Amanda Barnhart         4  3:17.40     2   96 pts   \n",
       "87                     Dani Speegle         4  3:18.10     3   92 pts   \n",
       "24        Katrin Tanja Davidsdottir         4  3:20.60     4   88 pts   \n",
       "10                     Brooke Wells         4  3:21.10     5   84 pts   \n",
       "3                  Tia-Clair Toomey         4  3:21.30    6T   80 pts   \n",
       "17                      Haley Adams         4  3:21.30    6T   80 pts   \n",
       "171                 Samantha Briggs         4  3:21.30    6T   80 pts   \n",
       "164                   Laura Horváth         4  3:21.60    9T   68 pts   \n",
       "66                    Andrea Nisler         4  3:21.60    9T   68 pts   \n",
       "143  Ragnheiður Sara Sigmundsdottir         4  3:22.40    11   60 pts   \n",
       "108                   Kristine Best         4  3:22.60    12   56 pts   \n",
       "52                    Kara Saunders         4  3:23.20    13   52 pts   \n",
       "136               Bethany Shadburne         4  3:26.00    14   49 pts   \n",
       "192                 Harriet Roberts         4  3:27.40    15   46 pts   \n",
       "157     Camilla Salomonsson Hellman         4  3:27.60    16   43 pts   \n",
       "122                 Gabriela Migała         4  3:29.40    17   40 pts   \n",
       "178                   Laura Clifton         4  3:29.50    18   37 pts   \n",
       "31                      Kari Pearce         4  3:30.20    19   34 pts   \n",
       "101                Danielle Brandon         4  3:30.60    20   31 pts   \n",
       "38                    Kristin Holte         4  3:31.00    21   28 pts   \n",
       "73        Carol-Ann Reason-Thibault         4  3:32.10    22   25 pts   \n",
       "185                  Andrea Solberg         4  3:33.40    23   22 pts   \n",
       "129                    Emma McQuaid         4  3:33.60    24   19 pts   \n",
       "80                   Jamie Simmonds         4  3:33.90    25   16 pts   \n",
       "150              Kendall Vincelette         4  3:35.70    26   13 pts   \n",
       "199                     Brooke Haas         4  3:36.00    27   10 pts   \n",
       "206                Sanna Venäläinen         4  3:36.20    28    7 pts   \n",
       "59           Kristi Eramo O'Connell         4  3:36.50    29    4 pts   \n",
       "115                Melina Rodriguez         4  3:36.90    30    1 pts   \n",
       "\n",
       "     total_seconds  adjusted_score  \n",
       "94             195      100.000000  \n",
       "45             197       90.476190  \n",
       "87             198       85.714286  \n",
       "24             200       76.190476  \n",
       "10             201       71.428571  \n",
       "3              201       71.428571  \n",
       "17             201       71.428571  \n",
       "171            201       71.428571  \n",
       "164            201       71.428571  \n",
       "66             201       71.428571  \n",
       "143            202       66.666667  \n",
       "108            202       66.666667  \n",
       "52             203       61.904762  \n",
       "136            206       47.619048  \n",
       "192            207       42.857143  \n",
       "157            207       42.857143  \n",
       "122            209       33.333333  \n",
       "178            209       33.333333  \n",
       "31             210       28.571429  \n",
       "101            210       28.571429  \n",
       "38             211       23.809524  \n",
       "73             212       19.047619  \n",
       "185            213       14.285714  \n",
       "129            213       14.285714  \n",
       "80             213       14.285714  \n",
       "150            215        4.761905  \n",
       "199            216        0.000000  \n",
       "206            216        0.000000  \n",
       "59             216        0.000000  \n",
       "115            216        0.000000  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_4"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Event 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_5 = full_data[full_data['ordinals']==5].sort_values('times').iloc[:-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "total_seconds = []\n",
    "for i, j in event_5.iterrows(): \n",
    "    datetime_convert = datetime.strptime(j['times'],'%M:%S')\n",
    "    total_seconds.append(datetime_convert.second + datetime_convert.minute*60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_5['total_seconds'] = total_seconds\n",
    "\n",
    "lst = list(event_5['total_seconds']-min(event_5['total_seconds']))\n",
    "event_5['adjusted_score'] = [100 - i*(100/max(lst)) for i in lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>5</td>\n",
       "      <td>18:16</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>1096</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>5</td>\n",
       "      <td>18:23</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>1103</td>\n",
       "      <td>98.568507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>5</td>\n",
       "      <td>18:26</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>1106</td>\n",
       "      <td>97.955010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>5</td>\n",
       "      <td>18:53</td>\n",
       "      <td>4</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>1133</td>\n",
       "      <td>92.433538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>5</td>\n",
       "      <td>19:21</td>\n",
       "      <td>5</td>\n",
       "      <td>84 pts</td>\n",
       "      <td>1161</td>\n",
       "      <td>86.707566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>5</td>\n",
       "      <td>19:25</td>\n",
       "      <td>6</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>1165</td>\n",
       "      <td>85.889571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>5</td>\n",
       "      <td>19:41</td>\n",
       "      <td>7</td>\n",
       "      <td>76 pts</td>\n",
       "      <td>1181</td>\n",
       "      <td>82.617587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>5</td>\n",
       "      <td>19:46</td>\n",
       "      <td>8</td>\n",
       "      <td>72 pts</td>\n",
       "      <td>1186</td>\n",
       "      <td>81.595092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>5</td>\n",
       "      <td>20:06</td>\n",
       "      <td>9</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>1206</td>\n",
       "      <td>77.505112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>5</td>\n",
       "      <td>20:36</td>\n",
       "      <td>10</td>\n",
       "      <td>64 pts</td>\n",
       "      <td>1236</td>\n",
       "      <td>71.370143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>5</td>\n",
       "      <td>20:37</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>1237</td>\n",
       "      <td>71.165644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>5</td>\n",
       "      <td>20:40</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>1240</td>\n",
       "      <td>70.552147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>5</td>\n",
       "      <td>20:47</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>1247</td>\n",
       "      <td>69.120654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>5</td>\n",
       "      <td>20:49</td>\n",
       "      <td>14</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>1249</td>\n",
       "      <td>68.711656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>5</td>\n",
       "      <td>20:55</td>\n",
       "      <td>15</td>\n",
       "      <td>46 pts</td>\n",
       "      <td>1255</td>\n",
       "      <td>67.484663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>5</td>\n",
       "      <td>21:10</td>\n",
       "      <td>16</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>1270</td>\n",
       "      <td>64.417178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>5</td>\n",
       "      <td>21:13</td>\n",
       "      <td>17</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>1273</td>\n",
       "      <td>63.803681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>5</td>\n",
       "      <td>21:14</td>\n",
       "      <td>18</td>\n",
       "      <td>37 pts</td>\n",
       "      <td>1274</td>\n",
       "      <td>63.599182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>5</td>\n",
       "      <td>21:28</td>\n",
       "      <td>19</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>1288</td>\n",
       "      <td>60.736196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>5</td>\n",
       "      <td>21:49</td>\n",
       "      <td>20</td>\n",
       "      <td>31 pts</td>\n",
       "      <td>1309</td>\n",
       "      <td>56.441718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>5</td>\n",
       "      <td>22:11</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>1331</td>\n",
       "      <td>51.942740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>5</td>\n",
       "      <td>22:25</td>\n",
       "      <td>22</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>1345</td>\n",
       "      <td>49.079755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>5</td>\n",
       "      <td>23:06</td>\n",
       "      <td>23</td>\n",
       "      <td>22 pts</td>\n",
       "      <td>1386</td>\n",
       "      <td>40.695297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>5</td>\n",
       "      <td>23:53</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>1433</td>\n",
       "      <td>31.083845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>5</td>\n",
       "      <td>24:02</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>1442</td>\n",
       "      <td>29.243354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>5</td>\n",
       "      <td>24:55</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>1495</td>\n",
       "      <td>18.404908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>5</td>\n",
       "      <td>24:56</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>1496</td>\n",
       "      <td>18.200409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>5</td>\n",
       "      <td>26:08</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>1568</td>\n",
       "      <td>3.476483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>5</td>\n",
       "      <td>26:25</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>1585</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals  times ranks    score  \\\n",
       "25        Katrin Tanja Davidsdottir         5  18:16     1  100 pts   \n",
       "39                    Kristin Holte         5  18:23     2   96 pts   \n",
       "4                  Tia-Clair Toomey         5  18:26     3   92 pts   \n",
       "18                      Haley Adams         5  18:53     4   88 pts   \n",
       "11                     Brooke Wells         5  19:21     5   84 pts   \n",
       "60           Kristi Eramo O'Connell         5  19:25     6   80 pts   \n",
       "67                    Andrea Nisler         5  19:41     7   76 pts   \n",
       "32                      Kari Pearce         5  19:46     8   72 pts   \n",
       "137               Bethany Shadburne         5  20:06     9   68 pts   \n",
       "123                 Gabriela Migała         5  20:36    10   64 pts   \n",
       "81                   Jamie Simmonds         5  20:37    11   60 pts   \n",
       "74        Carol-Ann Reason-Thibault         5  20:40    12   56 pts   \n",
       "53                    Kara Saunders         5  20:47    13   52 pts   \n",
       "46                  Amanda Barnhart         5  20:49    14   49 pts   \n",
       "102                Danielle Brandon         5  20:55    15   46 pts   \n",
       "144  Ragnheiður Sara Sigmundsdottir         5  21:10    16   43 pts   \n",
       "151              Kendall Vincelette         5  21:13    17   40 pts   \n",
       "130                    Emma McQuaid         5  21:14    18   37 pts   \n",
       "109                   Kristine Best         5  21:28    19   34 pts   \n",
       "95                    Karin Freyová         5  21:49    20   31 pts   \n",
       "158     Camilla Salomonsson Hellman         5  22:11    21   28 pts   \n",
       "179                   Laura Clifton         5  22:25    22   25 pts   \n",
       "207                Sanna Venäläinen         5  23:06    23   22 pts   \n",
       "165                   Laura Horváth         5  23:53    24   19 pts   \n",
       "172                 Samantha Briggs         5  24:02    25   16 pts   \n",
       "186                  Andrea Solberg         5  24:55    26   13 pts   \n",
       "116                Melina Rodriguez         5  24:56    27   10 pts   \n",
       "193                 Harriet Roberts         5  26:08    28    7 pts   \n",
       "88                     Dani Speegle         5  26:25    29    4 pts   \n",
       "\n",
       "     total_seconds  adjusted_score  \n",
       "25            1096      100.000000  \n",
       "39            1103       98.568507  \n",
       "4             1106       97.955010  \n",
       "18            1133       92.433538  \n",
       "11            1161       86.707566  \n",
       "60            1165       85.889571  \n",
       "67            1181       82.617587  \n",
       "32            1186       81.595092  \n",
       "137           1206       77.505112  \n",
       "123           1236       71.370143  \n",
       "81            1237       71.165644  \n",
       "74            1240       70.552147  \n",
       "53            1247       69.120654  \n",
       "46            1249       68.711656  \n",
       "102           1255       67.484663  \n",
       "144           1270       64.417178  \n",
       "151           1273       63.803681  \n",
       "130           1274       63.599182  \n",
       "109           1288       60.736196  \n",
       "95            1309       56.441718  \n",
       "158           1331       51.942740  \n",
       "179           1345       49.079755  \n",
       "207           1386       40.695297  \n",
       "165           1433       31.083845  \n",
       "172           1442       29.243354  \n",
       "186           1495       18.404908  \n",
       "116           1496       18.200409  \n",
       "193           1568        3.476483  \n",
       "88            1585        0.000000  "
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_5"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Event 6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_6 = full_data[full_data['ordinals']==6].sort_values('times')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "total_seconds = []\n",
    "for i, j in event_6.iterrows(): \n",
    "    try:\n",
    "        datetime_convert = datetime.strptime(j['times'],'%M:%S')\n",
    "        total_seconds.append(datetime_convert.second + datetime_convert.minute*60)\n",
    "    except:\n",
    "        datetime_convert = datetime.strptime(j['times'],':%S')\n",
    "        total_seconds.append(datetime_convert.second + datetime_convert.minute*60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_6['total_seconds'] = total_seconds\n",
    "\n",
    "lst = list(event_6['total_seconds']-min(event_6['total_seconds']))\n",
    "event_6['adjusted_score'] = [i*(100/max(lst)) for i in lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>6</td>\n",
       "      <td>2:54</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>174</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>6</td>\n",
       "      <td>2:13</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>133</td>\n",
       "      <td>70.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>6</td>\n",
       "      <td>2:12</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>132</td>\n",
       "      <td>70.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>6</td>\n",
       "      <td>1:59</td>\n",
       "      <td>4T</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>119</td>\n",
       "      <td>60.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>6</td>\n",
       "      <td>1:59</td>\n",
       "      <td>4T</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>119</td>\n",
       "      <td>60.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>6</td>\n",
       "      <td>1:54</td>\n",
       "      <td>6</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>114</td>\n",
       "      <td>57.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>6</td>\n",
       "      <td>1:53</td>\n",
       "      <td>7</td>\n",
       "      <td>76 pts</td>\n",
       "      <td>113</td>\n",
       "      <td>56.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>6</td>\n",
       "      <td>1:50</td>\n",
       "      <td>8</td>\n",
       "      <td>72 pts</td>\n",
       "      <td>110</td>\n",
       "      <td>54.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>6</td>\n",
       "      <td>1:48</td>\n",
       "      <td>9</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>108</td>\n",
       "      <td>52.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>6</td>\n",
       "      <td>1:31</td>\n",
       "      <td>10</td>\n",
       "      <td>64 pts</td>\n",
       "      <td>91</td>\n",
       "      <td>40.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>6</td>\n",
       "      <td>1:27</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>87</td>\n",
       "      <td>37.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>6</td>\n",
       "      <td>1:26</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>86</td>\n",
       "      <td>37.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>6</td>\n",
       "      <td>1:24</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>84</td>\n",
       "      <td>35.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>6</td>\n",
       "      <td>1:19</td>\n",
       "      <td>14T</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>79</td>\n",
       "      <td>32.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>6</td>\n",
       "      <td>1:19</td>\n",
       "      <td>14T</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>79</td>\n",
       "      <td>32.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>6</td>\n",
       "      <td>1:18</td>\n",
       "      <td>16T</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>78</td>\n",
       "      <td>31.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>6</td>\n",
       "      <td>1:18</td>\n",
       "      <td>16T</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>78</td>\n",
       "      <td>31.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>6</td>\n",
       "      <td>1:16</td>\n",
       "      <td>18</td>\n",
       "      <td>37 pts</td>\n",
       "      <td>76</td>\n",
       "      <td>30.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>6</td>\n",
       "      <td>1:15</td>\n",
       "      <td>19T</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>75</td>\n",
       "      <td>29.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>6</td>\n",
       "      <td>1:15</td>\n",
       "      <td>19T</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>75</td>\n",
       "      <td>29.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>6</td>\n",
       "      <td>1:10</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>70</td>\n",
       "      <td>25.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>6</td>\n",
       "      <td>1:09</td>\n",
       "      <td>22T</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>69</td>\n",
       "      <td>25.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>6</td>\n",
       "      <td>1:09</td>\n",
       "      <td>22T</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>69</td>\n",
       "      <td>25.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>6</td>\n",
       "      <td>1:03</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>63</td>\n",
       "      <td>20.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>6</td>\n",
       "      <td>:55</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>55</td>\n",
       "      <td>15.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>6</td>\n",
       "      <td>:54</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>54</td>\n",
       "      <td>14.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>6</td>\n",
       "      <td>:49</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>49</td>\n",
       "      <td>10.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>6</td>\n",
       "      <td>:41</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>41</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>6</td>\n",
       "      <td>:35</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>35</td>\n",
       "      <td>0.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>6</td>\n",
       "      <td>:34</td>\n",
       "      <td>30</td>\n",
       "      <td>1 pts</td>\n",
       "      <td>34</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals times ranks    score  \\\n",
       "26        Katrin Tanja Davidsdottir         6  2:54     1  100 pts   \n",
       "33                      Kari Pearce         6  2:13     2   96 pts   \n",
       "103                Danielle Brandon         6  2:12     3   92 pts   \n",
       "19                      Haley Adams         6  1:59    4T   88 pts   \n",
       "117                Melina Rodriguez         6  1:59    4T   88 pts   \n",
       "40                    Kristin Holte         6  1:54     6   80 pts   \n",
       "187                  Andrea Solberg         6  1:53     7   76 pts   \n",
       "12                     Brooke Wells         6  1:50     8   72 pts   \n",
       "194                 Harriet Roberts         6  1:48     9   68 pts   \n",
       "89                     Dani Speegle         6  1:31    10   64 pts   \n",
       "138               Bethany Shadburne         6  1:27    11   60 pts   \n",
       "82                   Jamie Simmonds         6  1:26    12   56 pts   \n",
       "47                  Amanda Barnhart         6  1:24    13   52 pts   \n",
       "68                    Andrea Nisler         6  1:19   14T   49 pts   \n",
       "159     Camilla Salomonsson Hellman         6  1:19   14T   49 pts   \n",
       "5                  Tia-Clair Toomey         6  1:18   16T   43 pts   \n",
       "96                    Karin Freyová         6  1:18   16T   43 pts   \n",
       "61           Kristi Eramo O'Connell         6  1:16    18   37 pts   \n",
       "75        Carol-Ann Reason-Thibault         6  1:15   19T   34 pts   \n",
       "124                 Gabriela Migała         6  1:15   19T   34 pts   \n",
       "131                    Emma McQuaid         6  1:10    21   28 pts   \n",
       "152              Kendall Vincelette         6  1:09   22T   25 pts   \n",
       "54                    Kara Saunders         6  1:09   22T   25 pts   \n",
       "145  Ragnheiður Sara Sigmundsdottir         6  1:03    24   19 pts   \n",
       "166                   Laura Horváth         6   :55    25   16 pts   \n",
       "110                   Kristine Best         6   :54    26   13 pts   \n",
       "173                 Samantha Briggs         6   :49    27   10 pts   \n",
       "208                Sanna Venäläinen         6   :41    28    7 pts   \n",
       "201                     Brooke Haas         6   :35    29    4 pts   \n",
       "180                   Laura Clifton         6   :34    30    1 pts   \n",
       "\n",
       "     total_seconds  adjusted_score  \n",
       "26             174      100.000000  \n",
       "33             133       70.714286  \n",
       "103            132       70.000000  \n",
       "19             119       60.714286  \n",
       "117            119       60.714286  \n",
       "40             114       57.142857  \n",
       "187            113       56.428571  \n",
       "12             110       54.285714  \n",
       "194            108       52.857143  \n",
       "89              91       40.714286  \n",
       "138             87       37.857143  \n",
       "82              86       37.142857  \n",
       "47              84       35.714286  \n",
       "68              79       32.142857  \n",
       "159             79       32.142857  \n",
       "5               78       31.428571  \n",
       "96              78       31.428571  \n",
       "61              76       30.000000  \n",
       "75              75       29.285714  \n",
       "124             75       29.285714  \n",
       "131             70       25.714286  \n",
       "152             69       25.000000  \n",
       "54              69       25.000000  \n",
       "145             63       20.714286  \n",
       "166             55       15.000000  \n",
       "110             54       14.285714  \n",
       "173             49       10.714286  \n",
       "208             41        5.000000  \n",
       "201             35        0.714286  \n",
       "180             34        0.000000  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_6 = event_6.sort_values('adjusted_score', ascending=False)\n",
    "event_6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Using matplotlib backend: MacOSX\n",
      "0 100.0\n"
     ]
    }
   ],
   "source": [
    "%matplotlib\n",
    "import numpy as np\n",
    "\n",
    "fig, ax = plt.subplots()\n",
    "\n",
    "names = list(event_6['competitors'])\n",
    "y_pos = np.arange(len(names))\n",
    "performance = list(event_6['adjusted_score'])\n",
    "\n",
    "ax.barh(y_pos, performance)\n",
    "ax.set_yticks(y_pos)\n",
    "ax.set_yticklabels(names)\n",
    "ax.invert_yaxis()  # labels read top-to-bottom\n",
    "ax.set_xlabel('Points')\n",
    "ax.set_title('Crossfit Games 2020 Women Event 6: Max Handstand Hold')\n",
    "print(y_pos[0], performance[0])\n",
    "\n",
    "plt.barh(y_pos[0], performance[0], color=['red'])\n",
    "plt.text(performance[0]+2, 0, '2:54, 100 pts', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[1], performance[1], color=['red'])\n",
    "plt.text(performance[1]+2, 1, '2:13, 70.71 pts', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[2], performance[2], color=['red'])\n",
    "plt.text(performance[2]+2, 2, '2:12, 70.00 pts', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[-1], performance[-1], color=['red'])\n",
    "plt.text(performance[-1]+2, 29, '0:34, 0 pts', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "\n",
    "fig.subplots_adjust(left=.25)\n",
    "plt.xlim(0,performance[0]+20)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Event 7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_7 = full_data[full_data['ordinals']==7].sort_values('times')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "total_seconds = []\n",
    "for i, j in event_7.iterrows(): \n",
    "    datetime_convert = datetime.strptime(j['times'],'%M:%S')\n",
    "    total_seconds.append(datetime_convert.second + datetime_convert.minute*60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_7['total_seconds'] = total_seconds\n",
    "\n",
    "lst = list(event_7['total_seconds']-min(event_7['total_seconds']))\n",
    "event_7['adjusted_score'] = [100 - i*(100/max(lst)) for i in lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>7</td>\n",
       "      <td>10:01</td>\n",
       "      <td>10</td>\n",
       "      <td>64 pts</td>\n",
       "      <td>601</td>\n",
       "      <td>82.783357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>7</td>\n",
       "      <td>10:03</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>603</td>\n",
       "      <td>82.496413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>7</td>\n",
       "      <td>10:26</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>626</td>\n",
       "      <td>79.196557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>7</td>\n",
       "      <td>10:27</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>627</td>\n",
       "      <td>79.053085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>7</td>\n",
       "      <td>10:29</td>\n",
       "      <td>14</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>629</td>\n",
       "      <td>78.766141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>7</td>\n",
       "      <td>10:39</td>\n",
       "      <td>15</td>\n",
       "      <td>46 pts</td>\n",
       "      <td>639</td>\n",
       "      <td>77.331420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>7</td>\n",
       "      <td>10:48</td>\n",
       "      <td>16</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>648</td>\n",
       "      <td>76.040172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>7</td>\n",
       "      <td>10:54</td>\n",
       "      <td>17</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>654</td>\n",
       "      <td>75.179340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>7</td>\n",
       "      <td>10:55</td>\n",
       "      <td>18</td>\n",
       "      <td>37 pts</td>\n",
       "      <td>655</td>\n",
       "      <td>75.035868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>7</td>\n",
       "      <td>10:56</td>\n",
       "      <td>19</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>656</td>\n",
       "      <td>74.892396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>7</td>\n",
       "      <td>10:58</td>\n",
       "      <td>20</td>\n",
       "      <td>31 pts</td>\n",
       "      <td>658</td>\n",
       "      <td>74.605452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>7</td>\n",
       "      <td>11:04</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>664</td>\n",
       "      <td>73.744620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>7</td>\n",
       "      <td>11:11</td>\n",
       "      <td>22</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>671</td>\n",
       "      <td>72.740316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>7</td>\n",
       "      <td>11:15</td>\n",
       "      <td>23</td>\n",
       "      <td>22 pts</td>\n",
       "      <td>675</td>\n",
       "      <td>72.166428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>7</td>\n",
       "      <td>11:37</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>697</td>\n",
       "      <td>69.010043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>7</td>\n",
       "      <td>12:21</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>741</td>\n",
       "      <td>62.697274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>7</td>\n",
       "      <td>12:55</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>775</td>\n",
       "      <td>57.819225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>7</td>\n",
       "      <td>14:13</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>853</td>\n",
       "      <td>46.628407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>7</td>\n",
       "      <td>17:23</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>1043</td>\n",
       "      <td>19.368723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>7</td>\n",
       "      <td>18:44</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>1124</td>\n",
       "      <td>7.747489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>7</td>\n",
       "      <td>19:38</td>\n",
       "      <td>30</td>\n",
       "      <td>1 pts</td>\n",
       "      <td>1178</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>7</td>\n",
       "      <td>8:01</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>481</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>7</td>\n",
       "      <td>8:54</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>534</td>\n",
       "      <td>92.395983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>7</td>\n",
       "      <td>9:10</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>550</td>\n",
       "      <td>90.100430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>7</td>\n",
       "      <td>9:19</td>\n",
       "      <td>4</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>559</td>\n",
       "      <td>88.809182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>7</td>\n",
       "      <td>9:28</td>\n",
       "      <td>5</td>\n",
       "      <td>84 pts</td>\n",
       "      <td>568</td>\n",
       "      <td>87.517934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>7</td>\n",
       "      <td>9:34</td>\n",
       "      <td>6</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>574</td>\n",
       "      <td>86.657102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>7</td>\n",
       "      <td>9:43</td>\n",
       "      <td>7</td>\n",
       "      <td>76 pts</td>\n",
       "      <td>583</td>\n",
       "      <td>85.365854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>7</td>\n",
       "      <td>9:46</td>\n",
       "      <td>8</td>\n",
       "      <td>72 pts</td>\n",
       "      <td>586</td>\n",
       "      <td>84.935438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>7</td>\n",
       "      <td>9:55</td>\n",
       "      <td>9</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>595</td>\n",
       "      <td>83.644189</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals  times ranks    score  \\\n",
       "48                  Amanda Barnhart         7  10:01    10   64 pts   \n",
       "41                    Kristin Holte         7  10:03    11   60 pts   \n",
       "69                    Andrea Nisler         7  10:26    12   56 pts   \n",
       "76        Carol-Ann Reason-Thibault         7  10:27    13   52 pts   \n",
       "167                   Laura Horváth         7  10:29    14   49 pts   \n",
       "83                   Jamie Simmonds         7  10:39    15   46 pts   \n",
       "153              Kendall Vincelette         7  10:48    16   43 pts   \n",
       "125                 Gabriela Migała         7  10:54    17   40 pts   \n",
       "104                Danielle Brandon         7  10:55    18   37 pts   \n",
       "174                 Samantha Briggs         7  10:56    19   34 pts   \n",
       "181                   Laura Clifton         7  10:58    20   31 pts   \n",
       "160     Camilla Salomonsson Hellman         7  11:04    21   28 pts   \n",
       "132                    Emma McQuaid         7  11:11    22   25 pts   \n",
       "195                 Harriet Roberts         7  11:15    23   22 pts   \n",
       "111                   Kristine Best         7  11:37    24   19 pts   \n",
       "90                     Dani Speegle         7  12:21    25   16 pts   \n",
       "118                Melina Rodriguez         7  12:55    26   13 pts   \n",
       "209                Sanna Venäläinen         7  14:13    27   10 pts   \n",
       "202                     Brooke Haas         7  17:23    28    7 pts   \n",
       "139               Bethany Shadburne         7  18:44    29    4 pts   \n",
       "188                  Andrea Solberg         7  19:38    30    1 pts   \n",
       "6                  Tia-Clair Toomey         7   8:01     1  100 pts   \n",
       "55                    Kara Saunders         7   8:54     2   96 pts   \n",
       "13                     Brooke Wells         7   9:10     3   92 pts   \n",
       "20                      Haley Adams         7   9:19     4   88 pts   \n",
       "146  Ragnheiður Sara Sigmundsdottir         7   9:28     5   84 pts   \n",
       "62           Kristi Eramo O'Connell         7   9:34     6   80 pts   \n",
       "27        Katrin Tanja Davidsdottir         7   9:43     7   76 pts   \n",
       "34                      Kari Pearce         7   9:46     8   72 pts   \n",
       "97                    Karin Freyová         7   9:55     9   68 pts   \n",
       "\n",
       "     total_seconds  adjusted_score  \n",
       "48             601       82.783357  \n",
       "41             603       82.496413  \n",
       "69             626       79.196557  \n",
       "76             627       79.053085  \n",
       "167            629       78.766141  \n",
       "83             639       77.331420  \n",
       "153            648       76.040172  \n",
       "125            654       75.179340  \n",
       "104            655       75.035868  \n",
       "174            656       74.892396  \n",
       "181            658       74.605452  \n",
       "160            664       73.744620  \n",
       "132            671       72.740316  \n",
       "195            675       72.166428  \n",
       "111            697       69.010043  \n",
       "90             741       62.697274  \n",
       "118            775       57.819225  \n",
       "209            853       46.628407  \n",
       "202           1043       19.368723  \n",
       "139           1124        7.747489  \n",
       "188           1178        0.000000  \n",
       "6              481      100.000000  \n",
       "55             534       92.395983  \n",
       "13             550       90.100430  \n",
       "20             559       88.809182  \n",
       "146            568       87.517934  \n",
       "62             574       86.657102  \n",
       "27             583       85.365854  \n",
       "34             586       84.935438  \n",
       "97             595       83.644189  "
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_7"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Final Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda/lib/python3.6/site-packages/ipykernel_launcher.py:2: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n",
      "of pandas will change to not sort by default.\n",
      "\n",
      "To accept the future behavior, pass 'sort=False'.\n",
      "\n",
      "To retain the current behavior and silence the warning, pass 'sort=True'.\n",
      "\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "frames = [event_1, event_2, event_3, event_4, event_5, event_6, event_7]\n",
    "final_df = pd.concat(frames)[['competitors','adjusted_score', 'score']]\n",
    "final_df['score'] = [int(i[:-4]) for i in final_df['score']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "adjusted_placements = final_df.groupby('competitors').agg({'adjusted_score':'sum','score':'sum'}).sort_values('adjusted_score', ascending=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "adjusted_placements['adjusted_placement'] = [i+1 for i in range(len(adjusted_placements))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "actual_placement = []\n",
    "\n",
    "for i in range(len(leaderboard)):\n",
    "    competitors = leaderboard[i]['entrant']['competitorName']\n",
    "    placement = leaderboard[i]['overallRank']\n",
    "    actual_placement.append((competitors, placement))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "final_placements = pd.DataFrame(actual_placement, columns=['competitors','actual_placement'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "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>competitors</th>\n",
       "      <th>actual_placement</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       competitors actual_placement\n",
       "0                 Tia-Clair Toomey                1\n",
       "1                     Brooke Wells                2\n",
       "2                      Haley Adams                3\n",
       "3        Katrin Tanja Davidsdottir                4\n",
       "4                      Kari Pearce                5\n",
       "5                    Kristin Holte                6\n",
       "6                  Amanda Barnhart                7\n",
       "7                    Kara Saunders                8\n",
       "8           Kristi Eramo O'Connell                9\n",
       "9                    Andrea Nisler               10\n",
       "10       Carol-Ann Reason-Thibault               11\n",
       "11                  Jamie Simmonds               12\n",
       "12                    Dani Speegle               13\n",
       "13                   Karin Freyová               14\n",
       "14                Danielle Brandon               15\n",
       "15                   Kristine Best               16\n",
       "16                Melina Rodriguez               17\n",
       "17                 Gabriela Migała               18\n",
       "18                    Emma McQuaid               19\n",
       "19               Bethany Shadburne               20\n",
       "20  Ragnheiður Sara Sigmundsdottir               21\n",
       "21              Kendall Vincelette               22\n",
       "22     Camilla Salomonsson Hellman               23\n",
       "23                   Laura Horváth               24\n",
       "24                 Samantha Briggs               25\n",
       "25                   Laura Clifton               26\n",
       "26                  Andrea Solberg               27\n",
       "27                 Harriet Roberts               28\n",
       "28                     Brooke Haas               29\n",
       "29                Sanna Venäläinen               30"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_placements"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = final_placements.join(adjusted_placements, how='inner', on='competitors')\n",
    "df = df[['competitors','score','actual_placement','adjusted_score','adjusted_placement']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {
    "scrolled": true
   },
   "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>competitors</th>\n",
       "      <th>score</th>\n",
       "      <th>actual_placement</th>\n",
       "      <th>adjusted_score</th>\n",
       "      <th>adjusted_placement</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>615</td>\n",
       "      <td>1</td>\n",
       "      <td>600.812153</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>580</td>\n",
       "      <td>2</td>\n",
       "      <td>537.308693</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>497</td>\n",
       "      <td>3</td>\n",
       "      <td>483.686053</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>490</td>\n",
       "      <td>4</td>\n",
       "      <td>523.564251</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>451</td>\n",
       "      <td>5</td>\n",
       "      <td>459.232424</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>449</td>\n",
       "      <td>6</td>\n",
       "      <td>467.877121</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>446</td>\n",
       "      <td>7</td>\n",
       "      <td>489.063747</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>444</td>\n",
       "      <td>8</td>\n",
       "      <td>499.920731</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>402</td>\n",
       "      <td>9</td>\n",
       "      <td>419.437920</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>394</td>\n",
       "      <td>10</td>\n",
       "      <td>454.606252</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>351</td>\n",
       "      <td>11</td>\n",
       "      <td>394.255801</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>346</td>\n",
       "      <td>12</td>\n",
       "      <td>401.365130</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>344</td>\n",
       "      <td>13</td>\n",
       "      <td>387.365095</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>334</td>\n",
       "      <td>14</td>\n",
       "      <td>412.174117</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>314</td>\n",
       "      <td>15</td>\n",
       "      <td>401.682210</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>302</td>\n",
       "      <td>16</td>\n",
       "      <td>414.864917</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>298</td>\n",
       "      <td>17</td>\n",
       "      <td>344.537018</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>298</td>\n",
       "      <td>18</td>\n",
       "      <td>385.132762</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>283</td>\n",
       "      <td>19</td>\n",
       "      <td>368.795328</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>283</td>\n",
       "      <td>20</td>\n",
       "      <td>323.284858</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>281</td>\n",
       "      <td>21</td>\n",
       "      <td>381.652883</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>248</td>\n",
       "      <td>22</td>\n",
       "      <td>331.794356</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>232</td>\n",
       "      <td>23</td>\n",
       "      <td>348.303498</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>228</td>\n",
       "      <td>24</td>\n",
       "      <td>291.010900</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>203</td>\n",
       "      <td>25</td>\n",
       "      <td>297.995196</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>201</td>\n",
       "      <td>26</td>\n",
       "      <td>283.733344</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>194</td>\n",
       "      <td>27</td>\n",
       "      <td>207.590945</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>194</td>\n",
       "      <td>28</td>\n",
       "      <td>271.694434</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>117</td>\n",
       "      <td>29</td>\n",
       "      <td>177.702124</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>109</td>\n",
       "      <td>30</td>\n",
       "      <td>205.206635</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       competitors  score actual_placement  adjusted_score  \\\n",
       "0                 Tia-Clair Toomey    615                1      600.812153   \n",
       "1                     Brooke Wells    580                2      537.308693   \n",
       "2                      Haley Adams    497                3      483.686053   \n",
       "3        Katrin Tanja Davidsdottir    490                4      523.564251   \n",
       "4                      Kari Pearce    451                5      459.232424   \n",
       "5                    Kristin Holte    449                6      467.877121   \n",
       "6                  Amanda Barnhart    446                7      489.063747   \n",
       "7                    Kara Saunders    444                8      499.920731   \n",
       "8           Kristi Eramo O'Connell    402                9      419.437920   \n",
       "9                    Andrea Nisler    394               10      454.606252   \n",
       "10       Carol-Ann Reason-Thibault    351               11      394.255801   \n",
       "11                  Jamie Simmonds    346               12      401.365130   \n",
       "12                    Dani Speegle    344               13      387.365095   \n",
       "13                   Karin Freyová    334               14      412.174117   \n",
       "14                Danielle Brandon    314               15      401.682210   \n",
       "15                   Kristine Best    302               16      414.864917   \n",
       "16                Melina Rodriguez    298               17      344.537018   \n",
       "17                 Gabriela Migała    298               18      385.132762   \n",
       "18                    Emma McQuaid    283               19      368.795328   \n",
       "19               Bethany Shadburne    283               20      323.284858   \n",
       "20  Ragnheiður Sara Sigmundsdottir    281               21      381.652883   \n",
       "21              Kendall Vincelette    248               22      331.794356   \n",
       "22     Camilla Salomonsson Hellman    232               23      348.303498   \n",
       "23                   Laura Horváth    228               24      291.010900   \n",
       "24                 Samantha Briggs    203               25      297.995196   \n",
       "25                   Laura Clifton    201               26      283.733344   \n",
       "26                  Andrea Solberg    194               27      207.590945   \n",
       "27                 Harriet Roberts    194               28      271.694434   \n",
       "28                     Brooke Haas    117               29      177.702124   \n",
       "29                Sanna Venäläinen    109               30      205.206635   \n",
       "\n",
       "    adjusted_placement  \n",
       "0                    1  \n",
       "1                    2  \n",
       "2                    6  \n",
       "3                    3  \n",
       "4                    8  \n",
       "5                    7  \n",
       "6                    5  \n",
       "7                    4  \n",
       "8                   10  \n",
       "9                    9  \n",
       "10                  15  \n",
       "11                  14  \n",
       "12                  16  \n",
       "13                  12  \n",
       "14                  13  \n",
       "15                  11  \n",
       "16                  21  \n",
       "17                  17  \n",
       "18                  19  \n",
       "19                  23  \n",
       "20                  18  \n",
       "21                  22  \n",
       "22                  20  \n",
       "23                  25  \n",
       "24                  24  \n",
       "25                  26  \n",
       "26                  28  \n",
       "27                  27  \n",
       "28                  30  \n",
       "29                  29  "
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# df.to_csv('Adjusted_Results/Women_2020.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Using matplotlib backend: MacOSX\n",
      "0 600.8121530820918\n"
     ]
    }
   ],
   "source": [
    "%matplotlib\n",
    "import numpy as np\n",
    "\n",
    "fig, ax = plt.subplots()\n",
    "\n",
    "names = list(df['competitors'])\n",
    "y_pos = np.arange(len(names))\n",
    "performance = list(df['adjusted_score'])\n",
    "\n",
    "ax.barh(y_pos, performance)\n",
    "ax.set_yticks(y_pos)\n",
    "ax.set_yticklabels(names)\n",
    "ax.invert_yaxis()  # labels read top-to-bottom\n",
    "ax.set_xlabel('Points')\n",
    "ax.set_title('Crossfit Games 2020 Women Final Standings')\n",
    "print(y_pos[0], performance[0])\n",
    "\n",
    "plt.barh(y_pos[0], performance[0], color=['cyan'])\n",
    "plt.text(performance[0]+2, 0, 'No Change', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[1], performance[1], color=['cyan'])\n",
    "plt.text(performance[1]+2, 1, 'No Change', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[2], performance[2], color=['red'])\n",
    "plt.text(performance[2]+2, 2, '3rd To 5th', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[3], performance[3], color=['red'])\n",
    "plt.text(performance[3]+2, 3, '4th To 3rd', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[4], performance[4], color=['red'])\n",
    "plt.text(performance[4]+2, 4, '5th to 7th', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "plt.barh(y_pos[7], performance[7], color=['red'])\n",
    "plt.text(performance[7]+2, 7, '8th to 4th', color='black', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "\n",
    "fig.subplots_adjust(left=.25)\n",
    "plt.xlim(0,performance[0]+100)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda/lib/python3.6/site-packages/pandas/core/frame.py:3781: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  return super(DataFrame, self).rename(**kwargs)\n"
     ]
    }
   ],
   "source": [
    "event_1_scores = event_1[['competitors', 'ranks', 'score', 'adjusted_score']]\n",
    "event_1_scores.rename(columns = {'ranks':'ranks_1', 'score':'score_1', 'adjusted_score':'adjusted_score_1'}, inplace = True) \n",
    "\n",
    "event_2_scores = event_2[['competitors', 'ranks', 'score', 'adjusted_score']]\n",
    "event_2_scores.rename(columns = {'ranks':'ranks_2', 'score':'score_2', 'adjusted_score':'adjusted_score_2'}, inplace = True) \n",
    "\n",
    "event_3_scores = event_3[['competitors', 'ranks', 'score', 'adjusted_score']]\n",
    "event_3_scores.rename(columns = {'ranks':'ranks_3', 'score':'score_3', 'adjusted_score':'adjusted_score_3'}, inplace = True) \n",
    "\n",
    "event_4_scores = event_4[['competitors', 'ranks', 'score', 'adjusted_score']]\n",
    "event_4_scores.rename(columns = {'ranks':'ranks_4', 'score':'score_4', 'adjusted_score':'adjusted_score_4'}, inplace = True) \n",
    "\n",
    "event_5_scores = event_5[['competitors', 'ranks', 'score', 'adjusted_score']]\n",
    "event_5_scores.rename(columns = {'ranks':'ranks_5', 'score':'score_5', 'adjusted_score':'adjusted_score_5'}, inplace = True) \n",
    "\n",
    "event_6_scores = event_6[['competitors', 'ranks', 'score', 'adjusted_score']]\n",
    "event_6_scores.rename(columns = {'ranks':'ranks_6', 'score':'score_6', 'adjusted_score':'adjusted_score_6'}, inplace = True) \n",
    "\n",
    "event_7_scores = event_7[['competitors', 'ranks', 'score', 'adjusted_score']]\n",
    "event_7_scores.rename(columns = {'ranks':'ranks_7', 'score':'score_7', 'adjusted_score':'adjusted_score_7'}, inplace = True) \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "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>competitors</th>\n",
       "      <th>ordinals</th>\n",
       "      <th>times</th>\n",
       "      <th>ranks</th>\n",
       "      <th>score</th>\n",
       "      <th>total_seconds</th>\n",
       "      <th>adjusted_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Amanda Barnhart</td>\n",
       "      <td>7</td>\n",
       "      <td>10:01</td>\n",
       "      <td>10</td>\n",
       "      <td>64 pts</td>\n",
       "      <td>601</td>\n",
       "      <td>82.783357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Kristin Holte</td>\n",
       "      <td>7</td>\n",
       "      <td>10:03</td>\n",
       "      <td>11</td>\n",
       "      <td>60 pts</td>\n",
       "      <td>603</td>\n",
       "      <td>82.496413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Andrea Nisler</td>\n",
       "      <td>7</td>\n",
       "      <td>10:26</td>\n",
       "      <td>12</td>\n",
       "      <td>56 pts</td>\n",
       "      <td>626</td>\n",
       "      <td>79.196557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Carol-Ann Reason-Thibault</td>\n",
       "      <td>7</td>\n",
       "      <td>10:27</td>\n",
       "      <td>13</td>\n",
       "      <td>52 pts</td>\n",
       "      <td>627</td>\n",
       "      <td>79.053085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Laura Horváth</td>\n",
       "      <td>7</td>\n",
       "      <td>10:29</td>\n",
       "      <td>14</td>\n",
       "      <td>49 pts</td>\n",
       "      <td>629</td>\n",
       "      <td>78.766141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Jamie Simmonds</td>\n",
       "      <td>7</td>\n",
       "      <td>10:39</td>\n",
       "      <td>15</td>\n",
       "      <td>46 pts</td>\n",
       "      <td>639</td>\n",
       "      <td>77.331420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>Kendall Vincelette</td>\n",
       "      <td>7</td>\n",
       "      <td>10:48</td>\n",
       "      <td>16</td>\n",
       "      <td>43 pts</td>\n",
       "      <td>648</td>\n",
       "      <td>76.040172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Gabriela Migała</td>\n",
       "      <td>7</td>\n",
       "      <td>10:54</td>\n",
       "      <td>17</td>\n",
       "      <td>40 pts</td>\n",
       "      <td>654</td>\n",
       "      <td>75.179340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Danielle Brandon</td>\n",
       "      <td>7</td>\n",
       "      <td>10:55</td>\n",
       "      <td>18</td>\n",
       "      <td>37 pts</td>\n",
       "      <td>655</td>\n",
       "      <td>75.035868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>Samantha Briggs</td>\n",
       "      <td>7</td>\n",
       "      <td>10:56</td>\n",
       "      <td>19</td>\n",
       "      <td>34 pts</td>\n",
       "      <td>656</td>\n",
       "      <td>74.892396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Laura Clifton</td>\n",
       "      <td>7</td>\n",
       "      <td>10:58</td>\n",
       "      <td>20</td>\n",
       "      <td>31 pts</td>\n",
       "      <td>658</td>\n",
       "      <td>74.605452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Camilla Salomonsson Hellman</td>\n",
       "      <td>7</td>\n",
       "      <td>11:04</td>\n",
       "      <td>21</td>\n",
       "      <td>28 pts</td>\n",
       "      <td>664</td>\n",
       "      <td>73.744620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Emma McQuaid</td>\n",
       "      <td>7</td>\n",
       "      <td>11:11</td>\n",
       "      <td>22</td>\n",
       "      <td>25 pts</td>\n",
       "      <td>671</td>\n",
       "      <td>72.740316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Harriet Roberts</td>\n",
       "      <td>7</td>\n",
       "      <td>11:15</td>\n",
       "      <td>23</td>\n",
       "      <td>22 pts</td>\n",
       "      <td>675</td>\n",
       "      <td>72.166428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Kristine Best</td>\n",
       "      <td>7</td>\n",
       "      <td>11:37</td>\n",
       "      <td>24</td>\n",
       "      <td>19 pts</td>\n",
       "      <td>697</td>\n",
       "      <td>69.010043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Dani Speegle</td>\n",
       "      <td>7</td>\n",
       "      <td>12:21</td>\n",
       "      <td>25</td>\n",
       "      <td>16 pts</td>\n",
       "      <td>741</td>\n",
       "      <td>62.697274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Melina Rodriguez</td>\n",
       "      <td>7</td>\n",
       "      <td>12:55</td>\n",
       "      <td>26</td>\n",
       "      <td>13 pts</td>\n",
       "      <td>775</td>\n",
       "      <td>57.819225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Sanna Venäläinen</td>\n",
       "      <td>7</td>\n",
       "      <td>14:13</td>\n",
       "      <td>27</td>\n",
       "      <td>10 pts</td>\n",
       "      <td>853</td>\n",
       "      <td>46.628407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Brooke Haas</td>\n",
       "      <td>7</td>\n",
       "      <td>17:23</td>\n",
       "      <td>28</td>\n",
       "      <td>7 pts</td>\n",
       "      <td>1043</td>\n",
       "      <td>19.368723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Bethany Shadburne</td>\n",
       "      <td>7</td>\n",
       "      <td>18:44</td>\n",
       "      <td>29</td>\n",
       "      <td>4 pts</td>\n",
       "      <td>1124</td>\n",
       "      <td>7.747489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Andrea Solberg</td>\n",
       "      <td>7</td>\n",
       "      <td>19:38</td>\n",
       "      <td>30</td>\n",
       "      <td>1 pts</td>\n",
       "      <td>1178</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Tia-Clair Toomey</td>\n",
       "      <td>7</td>\n",
       "      <td>8:01</td>\n",
       "      <td>1</td>\n",
       "      <td>100 pts</td>\n",
       "      <td>481</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Kara Saunders</td>\n",
       "      <td>7</td>\n",
       "      <td>8:54</td>\n",
       "      <td>2</td>\n",
       "      <td>96 pts</td>\n",
       "      <td>534</td>\n",
       "      <td>92.395983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Brooke Wells</td>\n",
       "      <td>7</td>\n",
       "      <td>9:10</td>\n",
       "      <td>3</td>\n",
       "      <td>92 pts</td>\n",
       "      <td>550</td>\n",
       "      <td>90.100430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Haley Adams</td>\n",
       "      <td>7</td>\n",
       "      <td>9:19</td>\n",
       "      <td>4</td>\n",
       "      <td>88 pts</td>\n",
       "      <td>559</td>\n",
       "      <td>88.809182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Ragnheiður Sara Sigmundsdottir</td>\n",
       "      <td>7</td>\n",
       "      <td>9:28</td>\n",
       "      <td>5</td>\n",
       "      <td>84 pts</td>\n",
       "      <td>568</td>\n",
       "      <td>87.517934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Kristi Eramo O'Connell</td>\n",
       "      <td>7</td>\n",
       "      <td>9:34</td>\n",
       "      <td>6</td>\n",
       "      <td>80 pts</td>\n",
       "      <td>574</td>\n",
       "      <td>86.657102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Katrin Tanja Davidsdottir</td>\n",
       "      <td>7</td>\n",
       "      <td>9:43</td>\n",
       "      <td>7</td>\n",
       "      <td>76 pts</td>\n",
       "      <td>583</td>\n",
       "      <td>85.365854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Kari Pearce</td>\n",
       "      <td>7</td>\n",
       "      <td>9:46</td>\n",
       "      <td>8</td>\n",
       "      <td>72 pts</td>\n",
       "      <td>586</td>\n",
       "      <td>84.935438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Karin Freyová</td>\n",
       "      <td>7</td>\n",
       "      <td>9:55</td>\n",
       "      <td>9</td>\n",
       "      <td>68 pts</td>\n",
       "      <td>595</td>\n",
       "      <td>83.644189</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        competitors  ordinals  times ranks    score  \\\n",
       "48                  Amanda Barnhart         7  10:01    10   64 pts   \n",
       "41                    Kristin Holte         7  10:03    11   60 pts   \n",
       "69                    Andrea Nisler         7  10:26    12   56 pts   \n",
       "76        Carol-Ann Reason-Thibault         7  10:27    13   52 pts   \n",
       "167                   Laura Horváth         7  10:29    14   49 pts   \n",
       "83                   Jamie Simmonds         7  10:39    15   46 pts   \n",
       "153              Kendall Vincelette         7  10:48    16   43 pts   \n",
       "125                 Gabriela Migała         7  10:54    17   40 pts   \n",
       "104                Danielle Brandon         7  10:55    18   37 pts   \n",
       "174                 Samantha Briggs         7  10:56    19   34 pts   \n",
       "181                   Laura Clifton         7  10:58    20   31 pts   \n",
       "160     Camilla Salomonsson Hellman         7  11:04    21   28 pts   \n",
       "132                    Emma McQuaid         7  11:11    22   25 pts   \n",
       "195                 Harriet Roberts         7  11:15    23   22 pts   \n",
       "111                   Kristine Best         7  11:37    24   19 pts   \n",
       "90                     Dani Speegle         7  12:21    25   16 pts   \n",
       "118                Melina Rodriguez         7  12:55    26   13 pts   \n",
       "209                Sanna Venäläinen         7  14:13    27   10 pts   \n",
       "202                     Brooke Haas         7  17:23    28    7 pts   \n",
       "139               Bethany Shadburne         7  18:44    29    4 pts   \n",
       "188                  Andrea Solberg         7  19:38    30    1 pts   \n",
       "6                  Tia-Clair Toomey         7   8:01     1  100 pts   \n",
       "55                    Kara Saunders         7   8:54     2   96 pts   \n",
       "13                     Brooke Wells         7   9:10     3   92 pts   \n",
       "20                      Haley Adams         7   9:19     4   88 pts   \n",
       "146  Ragnheiður Sara Sigmundsdottir         7   9:28     5   84 pts   \n",
       "62           Kristi Eramo O'Connell         7   9:34     6   80 pts   \n",
       "27        Katrin Tanja Davidsdottir         7   9:43     7   76 pts   \n",
       "34                      Kari Pearce         7   9:46     8   72 pts   \n",
       "97                    Karin Freyová         7   9:55     9   68 pts   \n",
       "\n",
       "     total_seconds  adjusted_score  \n",
       "48             601       82.783357  \n",
       "41             603       82.496413  \n",
       "69             626       79.196557  \n",
       "76             627       79.053085  \n",
       "167            629       78.766141  \n",
       "83             639       77.331420  \n",
       "153            648       76.040172  \n",
       "125            654       75.179340  \n",
       "104            655       75.035868  \n",
       "174            656       74.892396  \n",
       "181            658       74.605452  \n",
       "160            664       73.744620  \n",
       "132            671       72.740316  \n",
       "195            675       72.166428  \n",
       "111            697       69.010043  \n",
       "90             741       62.697274  \n",
       "118            775       57.819225  \n",
       "209            853       46.628407  \n",
       "202           1043       19.368723  \n",
       "139           1124        7.747489  \n",
       "188           1178        0.000000  \n",
       "6              481      100.000000  \n",
       "55             534       92.395983  \n",
       "13             550       90.100430  \n",
       "20             559       88.809182  \n",
       "146            568       87.517934  \n",
       "62             574       86.657102  \n",
       "27             583       85.365854  \n",
       "34             586       84.935438  \n",
       "97             595       83.644189  "
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event_7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "merge_1 = event_1_scores.merge(event_2_scores, on='competitors', how='left')\n",
    "merge_2 = merge_1.merge(event_3_scores, on='competitors', how='left')\n",
    "merge_3 = merge_2.merge(event_4_scores, on='competitors', how='left')\n",
    "merge_4 = merge_3.merge(event_5_scores, on='competitors', how='left')\n",
    "merge_5 = merge_4.merge(event_6_scores, on='competitors', how='left')\n",
    "merge_6 = merge_5.merge(event_7_scores, on='competitors', how='left')\n",
    "merge_7 = merge_6.merge(df, on='competitors', how='left')\n",
    "\n",
    "final_df = merge_7.sort_values('score', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Using matplotlib backend: MacOSX\n"
     ]
    }
   ],
   "source": [
    "%matplotlib\n",
    "import numpy as np\n",
    "\n",
    "fig, ax = plt.subplots()\n",
    "\n",
    "names = list(final_df['competitors'])\n",
    "y_pos = np.arange(len(names))\n",
    "perf_1 = list(final_df['adjusted_score_1'])\n",
    "perf_2 = list(final_df['adjusted_score_1'] + final_df['adjusted_score_2'])\n",
    "perf_3 = list(perf_2 + final_df['adjusted_score_3'])\n",
    "perf_4 = list(perf_3 + final_df['adjusted_score_4'])\n",
    "perf_5 = list(perf_4 + final_df['adjusted_score_5'])\n",
    "perf_6 = list(perf_5 + final_df['adjusted_score_6'])\n",
    "perf_7 = list(perf_6 + final_df['adjusted_score_7'])\n",
    "\n",
    "\n",
    "ax.barh(y_pos, perf_7, label='Event 7') \n",
    "ax.barh(y_pos, perf_6, label='Event 6') \n",
    "ax.barh(y_pos, perf_5, label='Event 5') \n",
    "ax.barh(y_pos, perf_4, label='Event 4') \n",
    "ax.barh(y_pos, perf_3, label='Event 3') \n",
    "ax.barh(y_pos, perf_2, label='Event 2') \n",
    "ax.barh(y_pos, perf_1, label='Event 1')\n",
    "\n",
    "\n",
    "ax.set_yticks(y_pos)\n",
    "ax.set_yticklabels(names)\n",
    "ax.invert_yaxis()  # labels read top-to-bottom\n",
    "ax.set_xlabel('Points')\n",
    "ax.set_title('Crossfit Games 2020 Stage 1 Women Adjusted Standings')\n",
    "\n",
    "# plt.barh(y_pos[0], perf_7[0], color=['cyan'])\n",
    "plt.text(performance[0]+2, 0, 'No Change', color='red', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "# plt.barh(y_pos[1], perf_7[1], color=['cyan'])\n",
    "plt.text(performance[1]+2, 1, 'No Change', color='red', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "# plt.barh(y_pos[2], perf_7[2], color=['cyan'])\n",
    "plt.text(performance[2]+2, 2, '3rd To 5th', color='red', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "# plt.barh(y_pos[3], perf_7[3], color=['cyan'])\n",
    "plt.text(performance[3]+2, 3, '4th To 3rd', color='red', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "# plt.barh(y_pos[4], perf_7[4], color=['red'])\n",
    "plt.text(performance[4]+2, 4, '5th to 7th', color='red', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "# plt.barh(y_pos[8], perf_7[8], color=['red'])\n",
    "plt.text(performance[7]+2, 7, '8th to 4th', color='red', fontweight='bold', fontsize=10, ha='left', va='center')\n",
    "\n",
    "fig.subplots_adjust(left=.25)\n",
    "plt.xlim(0,perf_7[0]+100)\n",
    "\n",
    "handles, labels = plt.gca().get_legend_handles_labels()\n",
    "order = [6,5,4,3,2,1,0]\n",
    "plt.legend([handles[idx] for idx in order],[labels[idx] for idx in order], loc='center right')\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}