main.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "synthetic-tractor",
   "metadata": {},
   "source": [
    "![Image source: https://www.infobae.com/aroundtherings/olympics-games/tokyo-2020/2021/08/04/lasha-talakhadze-smashes-world-and-olympic-records-for-weightlifting-gold/](./lasha.jpeg)\n",
    "*Lasha Lifting Image source from [Infobae](https://www.infobae.com/aroundtherings/olympics-games/tokyo-2020/2021/08/04/lasha-talakhadze-smashes-world-and-olympic-records-for-weightlifting-gold/)*\n",
    "\n",
    "# How Good is Lasha?\n",
    "\n",
    "After his performance in the Tokyo 2020 Olympics, Lasha is definetly in his class of his own.\n",
    "\n",
    "To be able to be the last lifter following yourself, not to mention this is the olympics. This is something incredible.\n",
    "\n",
    "But how good is he graphically? Let's see if you can display this graphically based on all the results from the Tokyo 2020 Olympics."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "thousand-doctrine",
   "metadata": {},
   "outputs": [],
   "source": [
    "# import libraries\n",
    "import json\n",
    "import math\n",
    "from pathlib import Path\n",
    "import requests\n",
    "\n",
    "#import PyPDF2 (does not work)\n",
    "import tabula #!conda install tabula-py\n",
    "import pandas as pd\n",
    "import altair as alt"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "least-usage",
   "metadata": {},
   "source": [
    "## Obtaining the pds files\n",
    "\n",
    "Obtaining the .pdf files using the API for this page. https://olympics.com/tokyo-2020/olympic-games/en/results/weightlifting/reports.htm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "excited-sigma",
   "metadata": {},
   "outputs": [],
   "source": [
    "wl_links = 'https://olympics.com/tokyo-2020/olympic-games/en/results/weightlifting/zzjp000b.json'\n",
    "\n",
    "wl_res = requests.get(wl_links)\n",
    "wl_json = json.loads(wl_res.text)\n",
    "\n",
    "URLPREFIX = 'https://olympics.com/tokyo-2020/olympic-games'\n",
    "\n",
    "links = [(link['pdfEvent'], link['pdfLink'].replace('../../..', URLPREFIX)) for link in wl_json['pdfsJSON'] \n",
    "         if link['pdfType'] == 'Phase Reports'] # returns a tuple (event name, pdf link)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "advanced-norfolk",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(\"Men's +109kg\",\n",
       "  'https://olympics.com/tokyo-2020/olympic-games/resOG2020-/pdf/OG2020-/WLF/OG2020-_WLF_C73_WLFMO109KG------------FNL---------.pdf'),\n",
       " (\"Men's 109kg\",\n",
       "  'https://olympics.com/tokyo-2020/olympic-games/resOG2020-/pdf/OG2020-/WLF/OG2020-_WLF_C73_WLFM109KG-------------FNL---------.pdf'),\n",
       " (\"Women's +87kg\",\n",
       "  'https://olympics.com/tokyo-2020/olympic-games/resOG2020-/pdf/OG2020-/WLF/OG2020-_WLF_C73_WLFWO87KG-------------FNL---------.pdf')]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "links[0:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "young-customs",
   "metadata": {},
   "outputs": [],
   "source": [
    "# downloading pdfs\n",
    "\n",
    "for i, tup in enumerate(links):\n",
    "    test_res = requests.get(links[i][1], stream=True)\n",
    "    results_path = Path('results/')\n",
    "    results_path.mkdir(parents=True, exist_ok=True)\n",
    "    filename = links[i][0] + '.pdf'\n",
    "    filepath = results_path / filename\n",
    "    with filepath.open('wb') as f:\n",
    "        f.write(test_res.content)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "recorded-section",
   "metadata": {},
   "source": [
    "## Looking at the results\n",
    "\n",
    "Let's have a look a the results.\n",
    "\n",
    "The aim is to plot the [z-scores](https://en.wikipedia.org/wiki/Standard_score) within each category and then compare this among other caretogies.\n",
    "\n",
    "$ z = \\frac{ x - \\mu }{ \\sigma } $\n",
    "\n",
    "The z-score is difference between the value and the mean divided by the standard deviation. Mean ($\\mu$) is an average; standard deviation ($\\sigma$) provides the spread in data.\n",
    "\n",
    "A very high z-score means the result is exceeds the compeition greatly.\n",
    "\n",
    "We'll start with just the 109+ weight category.\n",
    "\n",
    "I've decided not to use [sinclair coefficient](https://en.wikipedia.org/wiki/Sinclair_coefficient) because this is good for a weight to weight comparison. I want to show how a competitor did within his or her weight category.\n",
    "\n",
    "*TODO: Potentially, save a list of the no totals to display later?*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "thermal-stuff",
   "metadata": {},
   "outputs": [],
   "source": [
    "#PyPDF2 does not work, use tabula"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "impossible-meter",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0: Women's 76kg\n",
      "1: Men's 73kg\n",
      "2: Men's 109kg\n",
      "3: Women's 55kg\n",
      "4: Women's 59kg\n",
      "5: Men's 81kg\n",
      "6: Women's 49kg\n",
      "7: Women's 64kg\n",
      "8: Men's 96kg\n",
      "9: Women's +87kg\n",
      "10: Men's +109kg\n",
      "11: Women's 87kg\n",
      "12: Men's 61kg\n",
      "13: Men's 67kg\n"
     ]
    }
   ],
   "source": [
    "#list all files in results\n",
    "\n",
    "p = Path('./results').glob('./*.pdf')\n",
    "files = [_.name.replace('.pdf', '') for _ in p if _.is_file()]\n",
    "files\n",
    "\n",
    "for i, j in enumerate(files):\n",
    "    print(f'{i}: {j}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "electronic-riding",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Men's +109kg\n"
     ]
    },
    {
     "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>Country</th>\n",
       "      <th>Date of Birth</th>\n",
       "      <th>Final Total</th>\n",
       "      <th>Category</th>\n",
       "      <th>Normalised</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TALAKHADZE Lasha</td>\n",
       "      <td>1.0</td>\n",
       "      <td>GEO</td>\n",
       "      <td>2 OCT 1993</td>\n",
       "      <td>488</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>2.513915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DAVOUDI Ali</td>\n",
       "      <td>2.0</td>\n",
       "      <td>IRI</td>\n",
       "      <td>22 MAR 1999</td>\n",
       "      <td>441</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>1.013547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ASAAD Man</td>\n",
       "      <td>3.0</td>\n",
       "      <td>SYR</td>\n",
       "      <td>20 NOV 1993</td>\n",
       "      <td>424</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>0.470860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TOYCHYYEV Hojamuhammet</td>\n",
       "      <td>4.0</td>\n",
       "      <td>TKM</td>\n",
       "      <td>16 JAN 1992</td>\n",
       "      <td>414</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>0.151633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>LITI David Andrew</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NZL</td>\n",
       "      <td>11 JUL 1996</td>\n",
       "      <td>414</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>0.151633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>KUWORGE Enzo Kofi</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NED</td>\n",
       "      <td>31 AUG 2001</td>\n",
       "      <td>409</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>-0.007981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NAGY Peter</td>\n",
       "      <td>7.0</td>\n",
       "      <td>HUN</td>\n",
       "      <td>16 JAN 1986</td>\n",
       "      <td>396</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>-0.422976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>RUIZ I VELASCO Marcos</td>\n",
       "      <td>8.0</td>\n",
       "      <td>ESP</td>\n",
       "      <td>13 OCT 1996</td>\n",
       "      <td>395</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>-0.454899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>WILKES Caine Morgan</td>\n",
       "      <td>9.0</td>\n",
       "      <td>USA</td>\n",
       "      <td>10 JUL 1987</td>\n",
       "      <td>390</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>-0.614513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>MARTIROSJAN Sargis</td>\n",
       "      <td>10.0</td>\n",
       "      <td>AUT</td>\n",
       "      <td>14 SEP 1986</td>\n",
       "      <td>381</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>-0.901817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>LITVINOV David</td>\n",
       "      <td>11.0</td>\n",
       "      <td>ISR</td>\n",
       "      <td>23 SEP 1993</td>\n",
       "      <td>381</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>-0.901817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HSIEH Yun-Ting</td>\n",
       "      <td>12.0</td>\n",
       "      <td>TPE</td>\n",
       "      <td>8 AUG 1999</td>\n",
       "      <td>378</td>\n",
       "      <td>Men's +109kg</td>\n",
       "      <td>-0.997586</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Name  Rank Country Date of Birth  Final Total  \\\n",
       "1         TALAKHADZE Lasha   1.0     GEO    2 OCT 1993          488   \n",
       "2              DAVOUDI Ali   2.0     IRI   22 MAR 1999          441   \n",
       "3                ASAAD Man   3.0     SYR   20 NOV 1993          424   \n",
       "4   TOYCHYYEV Hojamuhammet   4.0     TKM   16 JAN 1992          414   \n",
       "5        LITI David Andrew   5.0     NZL   11 JUL 1996          414   \n",
       "6        KUWORGE Enzo Kofi   6.0     NED   31 AUG 2001          409   \n",
       "7               NAGY Peter   7.0     HUN   16 JAN 1986          396   \n",
       "8    RUIZ I VELASCO Marcos   8.0     ESP   13 OCT 1996          395   \n",
       "9      WILKES Caine Morgan   9.0     USA   10 JUL 1987          390   \n",
       "10      MARTIROSJAN Sargis  10.0     AUT   14 SEP 1986          381   \n",
       "11          LITVINOV David  11.0     ISR   23 SEP 1993          381   \n",
       "12          HSIEH Yun-Ting  12.0     TPE    8 AUG 1999          378   \n",
       "\n",
       "        Category  Normalised  \n",
       "1   Men's +109kg    2.513915  \n",
       "2   Men's +109kg    1.013547  \n",
       "3   Men's +109kg    0.470860  \n",
       "4   Men's +109kg    0.151633  \n",
       "5   Men's +109kg    0.151633  \n",
       "6   Men's +109kg   -0.007981  \n",
       "7   Men's +109kg   -0.422976  \n",
       "8   Men's +109kg   -0.454899  \n",
       "9   Men's +109kg   -0.614513  \n",
       "10  Men's +109kg   -0.901817  \n",
       "11  Men's +109kg   -0.901817  \n",
       "12  Men's +109kg   -0.997586  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Looking into the 109+ class\n",
    "\n",
    "idx = 10 # 109+ class\n",
    "\n",
    "result = tabula.read_pdf('results/' + files[idx] + '.pdf', pages=1)\n",
    "df = result[0]\n",
    "df['Category'] = files[idx]\n",
    "df.rename(columns={\n",
    "                    'NOC\\rCode': 'Country',\n",
    "                    'Unnamed: 5': 'Final Total'\n",
    "                  },\n",
    "          inplace=True)\n",
    "df = df[['Name', 'Rank', 'Country', 'Date of Birth', 'Final Total', 'Category']]\n",
    "df = df.dropna() # removes NA and those who did not total.\n",
    "\n",
    "# calculates normalized total within category\n",
    "df = df.astype({\n",
    "    'Final Total': 'int'\n",
    "})\n",
    "df['Normalised'] = (df['Final Total'] - df['Final Total'].mean()) / df['Final Total'].std() \n",
    "\n",
    "print(files[idx])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "incorporated-lloyd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-015b259ff04548068b292ec7b61a51ed\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-015b259ff04548068b292ec7b61a51ed\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-015b259ff04548068b292ec7b61a51ed\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function loadScript(lib) {\n",
       "      return new Promise(function(resolve, reject) {\n",
       "        var s = document.createElement('script');\n",
       "        s.src = paths[lib];\n",
       "        s.async = true;\n",
       "        s.onload = () => resolve(paths[lib]);\n",
       "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else if (typeof vegaEmbed === \"function\") {\n",
       "      displayChart(vegaEmbed);\n",
       "    } else {\n",
       "      loadScript(\"vega\")\n",
       "        .then(() => loadScript(\"vega-lite\"))\n",
       "        .then(() => loadScript(\"vega-embed\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300, \"stroke\": null}, \"facet\": {\"spacing\": 0}}, \"data\": {\"name\": \"data-a7ac63050636952ffd564640f2e2fc62\"}, \"mark\": \"circle\", \"encoding\": {\"color\": {\"type\": \"quantitative\", \"field\": \"Rank\", \"legend\": null, \"scale\": {\"scheme\": \"turbo\"}}, \"tooltip\": [{\"type\": \"nominal\", \"field\": \"Name\"}, {\"type\": \"quantitative\", \"field\": \"Rank\"}, {\"type\": \"nominal\", \"field\": \"Category\"}, {\"type\": \"quantitative\", \"field\": \"Final Total\"}], \"x\": {\"type\": \"quantitative\", \"field\": \"Normalised\", \"title\": \"Z-score\"}, \"y\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false, \"labels\": false, \"ticks\": true, \"values\": [0]}, \"field\": \"jitter\", \"scale\": {}, \"title\": null}}, \"title\": \"Distribution of Men's 109+ results\", \"transform\": [{\"calculate\": \"sqrt(-2*log(random()))*cos(2*PI*random())\", \"as\": \"jitter\"}], \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-a7ac63050636952ffd564640f2e2fc62\": [{\"Name\": \"TALAKHADZE Lasha\", \"Rank\": 1.0, \"Country\": \"GEO\", \"Date of Birth\": \"2 OCT 1993\", \"Final Total\": 488, \"Category\": \"Men's +109kg\", \"Normalised\": 2.513915460564078}, {\"Name\": \"DAVOUDI Ali\", \"Rank\": 2.0, \"Country\": \"IRI\", \"Date of Birth\": \"22 MAR 1999\", \"Final Total\": 441, \"Category\": \"Men's +109kg\", \"Normalised\": 1.0135468682274218}, {\"Name\": \"ASAAD Man\", \"Rank\": 3.0, \"Country\": \"SYR\", \"Date of Birth\": \"20 NOV 1993\", \"Final Total\": 424, \"Category\": \"Men's +109kg\", \"Normalised\": 0.47086035610565263}, {\"Name\": \"TOYCHYYEV Hojamuhammet\", \"Rank\": 4.0, \"Country\": \"TKM\", \"Date of Birth\": \"16 JAN 1992\", \"Final Total\": 414, \"Category\": \"Men's +109kg\", \"Normalised\": 0.15163299603402372}, {\"Name\": \"LITI David Andrew\", \"Rank\": 5.0, \"Country\": \"NZL\", \"Date of Birth\": \"11 JUL 1996\", \"Final Total\": 414, \"Category\": \"Men's +109kg\", \"Normalised\": 0.15163299603402372}, {\"Name\": \"KUWORGE Enzo Kofi\", \"Rank\": 6.0, \"Country\": \"NED\", \"Date of Birth\": \"31 AUG 2001\", \"Final Total\": 409, \"Category\": \"Men's +109kg\", \"Normalised\": -0.007980684001790722}, {\"Name\": \"NAGY Peter\", \"Rank\": 7.0, \"Country\": \"HUN\", \"Date of Birth\": \"16 JAN 1986\", \"Final Total\": 396, \"Category\": \"Men's +109kg\", \"Normalised\": -0.4229762520949083}, {\"Name\": \"RUIZ I VELASCO Marcos\", \"Rank\": 8.0, \"Country\": \"ESP\", \"Date of Birth\": \"13 OCT 1996\", \"Final Total\": 395, \"Category\": \"Men's +109kg\", \"Normalised\": -0.4548989881020712}, {\"Name\": \"WILKES Caine Morgan\", \"Rank\": 9.0, \"Country\": \"USA\", \"Date of Birth\": \"10 JUL 1987\", \"Final Total\": 390, \"Category\": \"Men's +109kg\", \"Normalised\": -0.6145126681378856}, {\"Name\": \"MARTIROSJAN Sargis\", \"Rank\": 10.0, \"Country\": \"AUT\", \"Date of Birth\": \"14 SEP 1986\", \"Final Total\": 381, \"Category\": \"Men's +109kg\", \"Normalised\": -0.9018172922023516}, {\"Name\": \"LITVINOV David\", \"Rank\": 11.0, \"Country\": \"ISR\", \"Date of Birth\": \"23 SEP 1993\", \"Final Total\": 381, \"Category\": \"Men's +109kg\", \"Normalised\": -0.9018172922023516}, {\"Name\": \"HSIEH Yun-Ting\", \"Rank\": 12.0, \"Country\": \"TPE\", \"Date of Birth\": \"8 AUG 1999\", \"Final Total\": 378, \"Category\": \"Men's +109kg\", \"Normalised\": -0.9975855002238404}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Plot z-scores for 109+ class\n",
    "\n",
    "alt.Chart(df, title=\"Distribution of Men's 109+ results\",).mark_circle().encode(\n",
    "    y=alt.Y(\n",
    "        'jitter:Q',\n",
    "        title=None,\n",
    "        axis=alt.Axis(values=[0], ticks=True, grid=False, labels=False),\n",
    "        scale=alt.Scale(),\n",
    "        ),\n",
    "    x=alt.X('Normalised:Q', title='Z-score'),\n",
    "    color=alt.Color('Rank:Q', legend=None, scale=alt.Scale(scheme='turbo')),\n",
    "    tooltip=['Name:N', 'Rank:Q', 'Category:N', 'Final Total:Q'],\n",
    "    ).transform_calculate(\n",
    "        jitter='sqrt(-2*log(random()))*cos(2*PI*random())'\n",
    "    ).configure_facet(\n",
    "        spacing=0\n",
    "    ).configure_view(\n",
    "        stroke=None\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "moved-century",
   "metadata": {},
   "source": [
    "## Extrating data from all files\n",
    "\n",
    "We can see that Lasha is above 2.5 standard deviation from the mean. This is truly amazing. Remember the statistics of standard deviation is not derived from the normal population; this is from the population of olympian he was competing against.\n",
    "\n",
    "Unfortuntately, the .pdf files don't extra the same. This mean the .pdf files need to be preprocessed differently.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "acute-finder",
   "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>Country</th>\n",
       "      <th>Date of Birth</th>\n",
       "      <th>Final Total</th>\n",
       "      <th>Category</th>\n",
       "      <th>Normalised</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DAJOMES BARRERA Neisi Patricia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ECU</td>\n",
       "      <td>12 MAY 1998</td>\n",
       "      <td>263</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>1.812496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NYE Katherine Elizabeth</td>\n",
       "      <td>2.0</td>\n",
       "      <td>USA</td>\n",
       "      <td>5 JAN 1999</td>\n",
       "      <td>249</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>1.074072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>FUENTES ZAVALA Aremi</td>\n",
       "      <td>3.0</td>\n",
       "      <td>MEX</td>\n",
       "      <td>23 MAY 1993</td>\n",
       "      <td>245</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>0.863093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>STRENIUS Patricia Caroline</td>\n",
       "      <td>4.0</td>\n",
       "      <td>SWE</td>\n",
       "      <td>23 NOV 1989</td>\n",
       "      <td>235</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>0.335647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NAUMAVA Darya</td>\n",
       "      <td>5.0</td>\n",
       "      <td>BLR</td>\n",
       "      <td>26 AUG 1995</td>\n",
       "      <td>234</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>0.282903</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Name  Rank Country Date of Birth  Final Total  \\\n",
       "0  DAJOMES BARRERA Neisi Patricia   1.0     ECU   12 MAY 1998          263   \n",
       "1         NYE Katherine Elizabeth   2.0     USA    5 JAN 1999          249   \n",
       "2            FUENTES ZAVALA Aremi   3.0     MEX   23 MAY 1993          245   \n",
       "3      STRENIUS Patricia Caroline   4.0     SWE   23 NOV 1989          235   \n",
       "4                   NAUMAVA Darya   5.0     BLR   26 AUG 1995          234   \n",
       "\n",
       "       Category  Normalised  \n",
       "0  Women's 76kg    1.812496  \n",
       "1  Women's 76kg    1.074072  \n",
       "2  Women's 76kg    0.863093  \n",
       "3  Women's 76kg    0.335647  \n",
       "4  Women's 76kg    0.282903  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all_v1 = []\n",
    "idx = [0, 8, 10, 11]\n",
    "\n",
    "for i, file in enumerate(files):\n",
    "    if i in idx:\n",
    "        results = tabula.read_pdf('results/' + file + '.pdf', pages='all')\n",
    "        df = results[0]\n",
    "        df['Category'] = file\n",
    "        df.rename(columns={\n",
    "                            'NOC\\rCode': 'Country',\n",
    "                            'Unnamed: 5': 'Final Total'\n",
    "                          },\n",
    "                  inplace=True)\n",
    "        df = df[['Name', 'Rank', 'Country', 'Date of Birth', 'Final Total', 'Category']]\n",
    "        df = df.dropna() # removes NA and those who did not total.\n",
    "        df = df.astype({'Final Total': 'int'})\n",
    "        df['Normalised'] = (df['Final Total'] - df['Final Total'].mean()) / df['Final Total'].std() \n",
    "        df_all_v1.append(df)\n",
    "df_all_v1 = pd.concat(df_all_v1)\n",
    "df_all_v1.reset_index(inplace=True)\n",
    "df_all_v1.drop(columns=['index'], inplace=True)\n",
    "df_all_v1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "warming-jungle",
   "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>Country</th>\n",
       "      <th>Date of Birth</th>\n",
       "      <th>Final Total</th>\n",
       "      <th>Category</th>\n",
       "      <th>Normalised</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHI Zhiyong</td>\n",
       "      <td>1</td>\n",
       "      <td>CHN</td>\n",
       "      <td>10 OCT 1993</td>\n",
       "      <td>364</td>\n",
       "      <td>Men's 73kg</td>\n",
       "      <td>1.636262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MAYORA PERNIA Julio Ruben</td>\n",
       "      <td>2</td>\n",
       "      <td>VEN</td>\n",
       "      <td>9 FEB 1996</td>\n",
       "      <td>346</td>\n",
       "      <td>Men's 73kg</td>\n",
       "      <td>0.841776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABDULLAH Rahmat Erwin</td>\n",
       "      <td>3</td>\n",
       "      <td>INA</td>\n",
       "      <td>13 OCT 2000</td>\n",
       "      <td>342</td>\n",
       "      <td>Men's 73kg</td>\n",
       "      <td>0.665224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CALJA Briken</td>\n",
       "      <td>4</td>\n",
       "      <td>ALB</td>\n",
       "      <td>19 FEB 1990</td>\n",
       "      <td>341</td>\n",
       "      <td>Men's 73kg</td>\n",
       "      <td>0.621086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ANDREEV Bozhidar Dimitrov</td>\n",
       "      <td>5</td>\n",
       "      <td>BUL</td>\n",
       "      <td>17 JAN 1997</td>\n",
       "      <td>338</td>\n",
       "      <td>Men's 73kg</td>\n",
       "      <td>0.488672</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Name Rank Country Date of Birth  Final Total  \\\n",
       "0                 SHI Zhiyong    1     CHN   10 OCT 1993          364   \n",
       "1   MAYORA PERNIA Julio Ruben    2     VEN    9 FEB 1996          346   \n",
       "2       ABDULLAH Rahmat Erwin    3     INA   13 OCT 2000          342   \n",
       "3                CALJA Briken    4     ALB   19 FEB 1990          341   \n",
       "4   ANDREEV Bozhidar Dimitrov    5     BUL   17 JAN 1997          338   \n",
       "\n",
       "     Category  Normalised  \n",
       "0  Men's 73kg    1.636262  \n",
       "1  Men's 73kg    0.841776  \n",
       "2  Men's 73kg    0.665224  \n",
       "3  Men's 73kg    0.621086  \n",
       "4  Men's 73kg    0.488672  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all_v2 = []\n",
    "leftover = list(range(len(files)))\n",
    "leftover = [_ for _ in leftover if _ not in idx] # .pdf files that need to be edited\n",
    "\n",
    "for i, file in enumerate(files):\n",
    "    if i in leftover:\n",
    "        result = tabula.read_pdf('results/' + file + '.pdf', pages=1)\n",
    "        df = result[0]\n",
    "        df['Category'] = file\n",
    "        df['Name'] = df['Lot'].str.replace('\\d+', '')\n",
    "        df.drop(columns=['Unnamed: 1'], inplace=True)\n",
    "        df.rename(columns={\n",
    "                            'NOC': 'Country',\n",
    "                            'Unnamed: 2': 'Date of Birth',\n",
    "                            'Unnamed: 6': 'Final Total',\n",
    "                            'Unnamed: 0': 'Rank'\n",
    "                          },\n",
    "                  inplace=True)\n",
    "        df = df[['Name', 'Rank', 'Country', 'Date of Birth', 'Final Total', 'Category']]\n",
    "        df = df.dropna() # removes those who did not total\n",
    "        df = df.astype({'Final Total': 'int'})\n",
    "        df['Normalised'] = (df['Final Total'] - df['Final Total'].mean()) / df['Final Total'].std() \n",
    "        df_all_v2.append(df)\n",
    "df_all_v2 = pd.concat(df_all_v2)\n",
    "df_all_v2.reset_index(inplace=True)\n",
    "df_all_v2.drop(columns=['index'], inplace=True)\n",
    "df_all_v2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "facial-tactics",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 175 entries, 0 to 125\n",
      "Data columns (total 7 columns):\n",
      " #   Column         Non-Null Count  Dtype  \n",
      "---  ------         --------------  -----  \n",
      " 0   Name           175 non-null    object \n",
      " 1   Rank           175 non-null    object \n",
      " 2   Country        175 non-null    object \n",
      " 3   Date of Birth  175 non-null    object \n",
      " 4   Final Total    175 non-null    int64  \n",
      " 5   Category       175 non-null    object \n",
      " 6   Normalised     175 non-null    float64\n",
      "dtypes: float64(1), int64(1), object(5)\n",
      "memory usage: 10.9+ KB\n"
     ]
    }
   ],
   "source": [
    "df_all = pd.concat([df_all_v1, df_all_v2])\n",
    "df_all.info()\n",
    "df_all.reset_index(inplace=True)\n",
    "df_all.drop(columns=['index'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "mexican-street",
   "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>Country</th>\n",
       "      <th>Date of Birth</th>\n",
       "      <th>Final Total</th>\n",
       "      <th>Category</th>\n",
       "      <th>Normalised</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DAJOMES BARRERA Neisi Patricia</td>\n",
       "      <td>1</td>\n",
       "      <td>ECU</td>\n",
       "      <td>12 MAY 1998</td>\n",
       "      <td>263</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>1.812496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NYE Katherine Elizabeth</td>\n",
       "      <td>2</td>\n",
       "      <td>USA</td>\n",
       "      <td>5 JAN 1999</td>\n",
       "      <td>249</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>1.074072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>FUENTES ZAVALA Aremi</td>\n",
       "      <td>3</td>\n",
       "      <td>MEX</td>\n",
       "      <td>23 MAY 1993</td>\n",
       "      <td>245</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>0.863093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>STRENIUS Patricia Caroline</td>\n",
       "      <td>4</td>\n",
       "      <td>SWE</td>\n",
       "      <td>23 NOV 1989</td>\n",
       "      <td>235</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>0.335647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NAUMAVA Darya</td>\n",
       "      <td>5</td>\n",
       "      <td>BLR</td>\n",
       "      <td>26 AUG 1995</td>\n",
       "      <td>234</td>\n",
       "      <td>Women's 76kg</td>\n",
       "      <td>0.282903</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Name Rank Country Date of Birth  Final Total  \\\n",
       "0  DAJOMES BARRERA Neisi Patricia    1     ECU   12 MAY 1998          263   \n",
       "1         NYE Katherine Elizabeth    2     USA    5 JAN 1999          249   \n",
       "2            FUENTES ZAVALA Aremi    3     MEX   23 MAY 1993          245   \n",
       "3      STRENIUS Patricia Caroline    4     SWE   23 NOV 1989          235   \n",
       "4                   NAUMAVA Darya    5     BLR   26 AUG 1995          234   \n",
       "\n",
       "       Category  Normalised  \n",
       "0  Women's 76kg    1.812496  \n",
       "1  Women's 76kg    1.074072  \n",
       "2  Women's 76kg    0.863093  \n",
       "3  Women's 76kg    0.335647  \n",
       "4  Women's 76kg    0.282903  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "driving-fashion",
   "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>Country</th>\n",
       "      <th>Date of Birth</th>\n",
       "      <th>Final Total</th>\n",
       "      <th>Category</th>\n",
       "      <th>Normalised</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>CHKHEIDZE Goga</td>\n",
       "      <td>8</td>\n",
       "      <td>GEO</td>\n",
       "      <td>11 FEB 1996</td>\n",
       "      <td>302</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.181349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>DENI .</td>\n",
       "      <td>9</td>\n",
       "      <td>INA</td>\n",
       "      <td>26 JUL 1989</td>\n",
       "      <td>301</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.223199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>MUNOZ MARTINEZ Jonathan Antonio</td>\n",
       "      <td>10</td>\n",
       "      <td>MEX</td>\n",
       "      <td>10 NOV 1995</td>\n",
       "      <td>298</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.348748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>ANDRIANTSITOHAINA Tojonirina Alain</td>\n",
       "      <td>11</td>\n",
       "      <td>MAD</td>\n",
       "      <td>26 FEB 1995</td>\n",
       "      <td>285</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.892796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>KATOATAU Ruben</td>\n",
       "      <td>12</td>\n",
       "      <td>KIR</td>\n",
       "      <td>9 FEB 1997</td>\n",
       "      <td>245</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-2.566788</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Name Rank Country Date of Birth  \\\n",
       "170                       CHKHEIDZE Goga    8     GEO   11 FEB 1996   \n",
       "171                               DENI .    9     INA   26 JUL 1989   \n",
       "172      MUNOZ MARTINEZ Jonathan Antonio   10     MEX   10 NOV 1995   \n",
       "173   ANDRIANTSITOHAINA Tojonirina Alain   11     MAD   26 FEB 1995   \n",
       "174                       KATOATAU Ruben   12     KIR    9 FEB 1997   \n",
       "\n",
       "     Final Total    Category  Normalised  \n",
       "170          302  Men's 67kg   -0.181349  \n",
       "171          301  Men's 67kg   -0.223199  \n",
       "172          298  Men's 67kg   -0.348748  \n",
       "173          285  Men's 67kg   -0.892796  \n",
       "174          245  Men's 67kg   -2.566788  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "outer-arbor",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name             0\n",
       "Rank             0\n",
       "Country          0\n",
       "Date of Birth    0\n",
       "Final Total      0\n",
       "Category         0\n",
       "Normalised       0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all.isna().sum() # checking for NaNs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "classical-court",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-f10aa336da7e49c79400bce2139a5004\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-f10aa336da7e49c79400bce2139a5004\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-f10aa336da7e49c79400bce2139a5004\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function loadScript(lib) {\n",
       "      return new Promise(function(resolve, reject) {\n",
       "        var s = document.createElement('script');\n",
       "        s.src = paths[lib];\n",
       "        s.async = true;\n",
       "        s.onload = () => resolve(paths[lib]);\n",
       "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else if (typeof vegaEmbed === \"function\") {\n",
       "      displayChart(vegaEmbed);\n",
       "    } else {\n",
       "      loadScript(\"vega\")\n",
       "        .then(() => loadScript(\"vega-lite\"))\n",
       "        .then(() => loadScript(\"vega-embed\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300, \"stroke\": null}, \"facet\": {\"spacing\": 0}}, \"data\": {\"name\": \"data-a31502d08336bd843be3ad91d5624f73\"}, \"mark\": \"circle\", \"encoding\": {\"color\": {\"type\": \"quantitative\", \"field\": \"Rank\", \"legend\": null, \"scale\": {\"scheme\": \"turbo\"}}, \"tooltip\": [{\"type\": \"nominal\", \"field\": \"Name\"}, {\"type\": \"quantitative\", \"field\": \"Rank\"}, {\"type\": \"nominal\", \"field\": \"Category\"}, {\"type\": \"quantitative\", \"field\": \"Final Total\"}], \"x\": {\"type\": \"quantitative\", \"field\": \"Normalised\", \"title\": \"Z-score\"}, \"y\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false, \"labels\": false, \"ticks\": true, \"values\": [0]}, \"field\": \"jitter\", \"scale\": {}, \"title\": null}}, \"title\": \"Z-scores for all lifters\", \"transform\": [{\"calculate\": \"sqrt(-2*log(random()))*cos(2*PI*random())\", \"as\": \"jitter\"}], \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-a31502d08336bd843be3ad91d5624f73\": [{\"Name\": \"DAJOMES BARRERA Neisi Patricia\", \"Rank\": 1.0, \"Country\": \"ECU\", \"Date of Birth\": \"12 MAY 1998\", \"Final Total\": 263, \"Category\": \"Women's 76kg\", \"Normalised\": 1.8124962836690874}, {\"Name\": \"NYE Katherine Elizabeth\", \"Rank\": 2.0, \"Country\": \"USA\", \"Date of Birth\": \"5 JAN 1999\", \"Final Total\": 249, \"Category\": \"Women's 76kg\", \"Normalised\": 1.074071871803904}, {\"Name\": \"FUENTES ZAVALA Aremi\", \"Rank\": 3.0, \"Country\": \"MEX\", \"Date of Birth\": \"23 MAY 1993\", \"Final Total\": 245, \"Category\": \"Women's 76kg\", \"Normalised\": 0.8630934684138514}, {\"Name\": \"STRENIUS Patricia Caroline\", \"Rank\": 4.0, \"Country\": \"SWE\", \"Date of Birth\": \"23 NOV 1989\", \"Final Total\": 235, \"Category\": \"Women's 76kg\", \"Normalised\": 0.3356474599387203}, {\"Name\": \"NAUMAVA Darya\", \"Rank\": 5.0, \"Country\": \"BLR\", \"Date of Birth\": \"26 AUG 1995\", \"Final Total\": 234, \"Category\": \"Women's 76kg\", \"Normalised\": 0.2829028590912072}, {\"Name\": \"FAYZULLAEVA Kumushkhon\", \"Rank\": 6.0, \"Country\": \"UZB\", \"Date of Birth\": \"20 JAN 2002\", \"Final Total\": 227, \"Category\": \"Women's 76kg\", \"Normalised\": -0.08630934684138454}, {\"Name\": \"GODLEY Emily Victoria\", \"Rank\": 7.0, \"Country\": \"GBR\", \"Date of Birth\": \"22 OCT 1989\", \"Final Total\": 222, \"Category\": \"Women's 76kg\", \"Normalised\": -0.3500323510789501}, {\"Name\": \"NGARLEM Kristel\", \"Rank\": 8.0, \"Country\": \"CAN\", \"Date of Birth\": \"20 JUL 1995\", \"Final Total\": 218, \"Category\": \"Women's 76kg\", \"Normalised\": -0.5610107544690025}, {\"Name\": \"FATTOUH Mahassen Hala\", \"Rank\": 9.0, \"Country\": \"LBN\", \"Date of Birth\": \"27 AUG 1989\", \"Final Total\": 217, \"Category\": \"Women's 76kg\", \"Normalised\": -0.6137553553165156}, {\"Name\": \"ABOUKE Nancy Genzel\", \"Rank\": 10.0, \"Country\": \"NRU\", \"Date of Birth\": \"5 JUL 2003\", \"Final Total\": 203, \"Category\": \"Women's 76kg\", \"Normalised\": -1.352179767181699}, {\"Name\": \"EYENGA MBOOSI Jeanne Gaelle\", \"Rank\": 11.0, \"Country\": \"CMR\", \"Date of Birth\": \"24 JAN 1999\", \"Final Total\": 202, \"Category\": \"Women's 76kg\", \"Normalised\": -1.4049243680292123}, {\"Name\": \"ELBAKH Fares Ibrahim E H\", \"Rank\": 1.0, \"Country\": \"QAT\", \"Date of Birth\": \"4 JUN 1998\", \"Final Total\": 402, \"Category\": \"Men's 96kg\", \"Normalised\": 1.4074989677217804}, {\"Name\": \"VALLENILLA SANCHEZ Keydomar Giovan.\", \"Rank\": 2.0, \"Country\": \"VEN\", \"Date of Birth\": \"10 AUG 1999\", \"Final Total\": 387, \"Category\": \"Men's 96kg\", \"Normalised\": 0.876624115292869}, {\"Name\": \"PLIESNOI Anton\", \"Rank\": 3.0, \"Country\": \"GEO\", \"Date of Birth\": \"17 SEP 1996\", \"Final Total\": 387, \"Category\": \"Men's 96kg\", \"Normalised\": 0.876624115292869}, {\"Name\": \"SANTAVY Boady Robert\", \"Rank\": 4.0, \"Country\": \"CAN\", \"Date of Birth\": \"22 MAY 1997\", \"Final Total\": 386, \"Category\": \"Men's 96kg\", \"Normalised\": 0.841232458464275}, {\"Name\": \"CHEN Po-Jen\", \"Rank\": 5.0, \"Country\": \"TPE\", \"Date of Birth\": \"11 MAY 1998\", \"Final Total\": 381, \"Category\": \"Men's 96kg\", \"Normalised\": 0.6642741743213045}, {\"Name\": \"RASULBEKOV Bekdoolot\", \"Rank\": 6.0, \"Country\": \"KGZ\", \"Date of Birth\": \"12 AUG 1996\", \"Final Total\": 374, \"Category\": \"Men's 96kg\", \"Normalised\": 0.41653257652114595}, {\"Name\": \"ADAMUS Bartlomiej Stefan\", \"Rank\": 7.0, \"Country\": \"POL\", \"Date of Birth\": \"12 MAY 2000\", \"Final Total\": 360, \"Category\": \"Men's 96kg\", \"Normalised\": -0.07895061907917127}, {\"Name\": \"YU Dongju\", \"Rank\": 8.0, \"Country\": \"KOR\", \"Date of Birth\": \"19 AUG 1993\", \"Final Total\": 360, \"Category\": \"Men's 96kg\", \"Normalised\": -0.07895061907917127}, {\"Name\": \"SAEZ VERA Olfides\", \"Rank\": 9.0, \"Country\": \"CUB\", \"Date of Birth\": \"24 SEP 1994\", \"Final Total\": 359, \"Category\": \"Men's 96kg\", \"Normalised\": -0.11434227590776536}, {\"Name\": \"TCHATCHET II Cyrille\", \"Rank\": 10.0, \"Country\": \"EOR\", \"Date of Birth\": \"1 AUG 1995\", \"Final Total\": 350, \"Category\": \"Men's 96kg\", \"Normalised\": -0.4328671873651121}, {\"Name\": \"IAKOVIDIS Theodoros\", \"Rank\": 11.0, \"Country\": \"GRE\", \"Date of Birth\": \"12 FEB 1991\", \"Final Total\": 338, \"Category\": \"Men's 96kg\", \"Normalised\": -0.8575670693082411}, {\"Name\": \"AMOAH Christian\", \"Rank\": 12.0, \"Country\": \"GHA\", \"Date of Birth\": \"25 JUL 1999\", \"Final Total\": 315, \"Category\": \"Men's 96kg\", \"Normalised\": -1.671575176365905}, {\"Name\": \"HAMADA Mohammed K H\", \"Rank\": 13.0, \"Country\": \"PLE\", \"Date of Birth\": \"14 MAR 2002\", \"Final Total\": 310, \"Category\": \"Men's 96kg\", \"Normalised\": -1.8485334605088755}, {\"Name\": \"TALAKHADZE Lasha\", \"Rank\": 1.0, \"Country\": \"GEO\", \"Date of Birth\": \"2 OCT 1993\", \"Final Total\": 488, \"Category\": \"Men's +109kg\", \"Normalised\": 2.513915460564078}, {\"Name\": \"DAVOUDI Ali\", \"Rank\": 2.0, \"Country\": \"IRI\", \"Date of Birth\": \"22 MAR 1999\", \"Final Total\": 441, \"Category\": \"Men's +109kg\", \"Normalised\": 1.0135468682274218}, {\"Name\": \"ASAAD Man\", \"Rank\": 3.0, \"Country\": \"SYR\", \"Date of Birth\": \"20 NOV 1993\", \"Final Total\": 424, \"Category\": \"Men's +109kg\", \"Normalised\": 0.47086035610565263}, {\"Name\": \"TOYCHYYEV Hojamuhammet\", \"Rank\": 4.0, \"Country\": \"TKM\", \"Date of Birth\": \"16 JAN 1992\", \"Final Total\": 414, \"Category\": \"Men's +109kg\", \"Normalised\": 0.15163299603402372}, {\"Name\": \"LITI David Andrew\", \"Rank\": 5.0, \"Country\": \"NZL\", \"Date of Birth\": \"11 JUL 1996\", \"Final Total\": 414, \"Category\": \"Men's +109kg\", \"Normalised\": 0.15163299603402372}, {\"Name\": \"KUWORGE Enzo Kofi\", \"Rank\": 6.0, \"Country\": \"NED\", \"Date of Birth\": \"31 AUG 2001\", \"Final Total\": 409, \"Category\": \"Men's +109kg\", \"Normalised\": -0.007980684001790722}, {\"Name\": \"NAGY Peter\", \"Rank\": 7.0, \"Country\": \"HUN\", \"Date of Birth\": \"16 JAN 1986\", \"Final Total\": 396, \"Category\": \"Men's +109kg\", \"Normalised\": -0.4229762520949083}, {\"Name\": \"RUIZ I VELASCO Marcos\", \"Rank\": 8.0, \"Country\": \"ESP\", \"Date of Birth\": \"13 OCT 1996\", \"Final Total\": 395, \"Category\": \"Men's +109kg\", \"Normalised\": -0.4548989881020712}, {\"Name\": \"WILKES Caine Morgan\", \"Rank\": 9.0, \"Country\": \"USA\", \"Date of Birth\": \"10 JUL 1987\", \"Final Total\": 390, \"Category\": \"Men's +109kg\", \"Normalised\": -0.6145126681378856}, {\"Name\": \"MARTIROSJAN Sargis\", \"Rank\": 10.0, \"Country\": \"AUT\", \"Date of Birth\": \"14 SEP 1986\", \"Final Total\": 381, \"Category\": \"Men's +109kg\", \"Normalised\": -0.9018172922023516}, {\"Name\": \"LITVINOV David\", \"Rank\": 11.0, \"Country\": \"ISR\", \"Date of Birth\": \"23 SEP 1993\", \"Final Total\": 381, \"Category\": \"Men's +109kg\", \"Normalised\": -0.9018172922023516}, {\"Name\": \"HSIEH Yun-Ting\", \"Rank\": 12.0, \"Country\": \"TPE\", \"Date of Birth\": \"8 AUG 1999\", \"Final Total\": 378, \"Category\": \"Men's +109kg\", \"Normalised\": -0.9975855002238404}, {\"Name\": \"WANG Zhouyu\", \"Rank\": 1.0, \"Country\": \"CHN\", \"Date of Birth\": \"13 MAY 1994\", \"Final Total\": 270, \"Category\": \"Women's 87kg\", \"Normalised\": 1.604424695018269}, {\"Name\": \"SALAZAR ARCE Tamara Yajaira\", \"Rank\": 2.0, \"Country\": \"ECU\", \"Date of Birth\": \"9 AUG 1997\", \"Final Total\": 263, \"Category\": \"Women's 87kg\", \"Normalised\": 1.2329166867570414}, {\"Name\": \"SANTANA PEGUERO Crismery Dominga\", \"Rank\": 3.0, \"Country\": \"DOM\", \"Date of Birth\": \"20 APR 1995\", \"Final Total\": 256, \"Category\": \"Women's 87kg\", \"Normalised\": 0.8614086784958135}, {\"Name\": \"MUNKHJANTSAN Ankhtsetseg\", \"Rank\": 4.0, \"Country\": \"MGL\", \"Date of Birth\": \"25 DEC 1997\", \"Final Total\": 252, \"Category\": \"Women's 87kg\", \"Normalised\": 0.6491183880608262}, {\"Name\": \"NAYO KETCHANKE Gaelle\", \"Rank\": 5.0, \"Country\": \"FRA\", \"Date of Birth\": \"20 APR 1988\", \"Final Total\": 247, \"Category\": \"Women's 87kg\", \"Normalised\": 0.38375552501709215}, {\"Name\": \"ROGERS Martha Ann\", \"Rank\": 6.0, \"Country\": \"USA\", \"Date of Birth\": \"23 AUG 1995\", \"Final Total\": 246, \"Category\": \"Women's 87kg\", \"Normalised\": 0.33068295240834533}, {\"Name\": \"PEREZ REVERON Naryury Alexandra\", \"Rank\": 7.0, \"Country\": \"VEN\", \"Date of Birth\": \"29 SEP 1992\", \"Final Total\": 242, \"Category\": \"Women's 87kg\", \"Normalised\": 0.11839266197335806}, {\"Name\": \"CILCIC Elena\", \"Rank\": 8.0, \"Country\": \"MDA\", \"Date of Birth\": \"3 JUN 1996\", \"Final Total\": 240, \"Category\": \"Women's 87kg\", \"Normalised\": 0.012247516755864418}, {\"Name\": \"KANG Yeounhee\", \"Rank\": 9.0, \"Country\": \"KOR\", \"Date of Birth\": \"15 OCT 1992\", \"Final Total\": 231, \"Category\": \"Women's 87kg\", \"Normalised\": -0.46540563672285695}, {\"Name\": \"VALENTIN PEREZ Lidia\", \"Rank\": 10.0, \"Country\": \"ESP\", \"Date of Birth\": \"10 FEB 1985\", \"Final Total\": 225, \"Category\": \"Women's 87kg\", \"Normalised\": -0.7838410723753378}, {\"Name\": \"MEUKEUGNI NOUMBISSI Clementine\", \"Rank\": 11.0, \"Country\": \"CMR\", \"Date of Birth\": \"1 OCT 1990\", \"Final Total\": 224, \"Category\": \"Women's 87kg\", \"Normalised\": -0.8369136449840847}, {\"Name\": \"ANTONIA FERREIRA Jaqueline\", \"Rank\": 12.0, \"Country\": \"BRA\", \"Date of Birth\": \"5 MAR 1987\", \"Final Total\": 215, \"Category\": \"Women's 87kg\", \"Normalised\": -1.314566798462806}, {\"Name\": \"ANDREWS-NAHU Kanah\", \"Rank\": 13.0, \"Country\": \"NZL\", \"Date of Birth\": \"18 JAN 2001\", \"Final Total\": 206, \"Category\": \"Women's 87kg\", \"Normalised\": -1.7922199519415274}, {\"Name\": \" SHI Zhiyong\", \"Rank\": \"1\", \"Country\": \"CHN\", \"Date of Birth\": \"10 OCT 1993\", \"Final Total\": 364, \"Category\": \"Men's 73kg\", \"Normalised\": 1.6362616823343805}, {\"Name\": \" MAYORA PERNIA Julio Ruben\", \"Rank\": \"2\", \"Country\": \"VEN\", \"Date of Birth\": \"9 FEB 1996\", \"Final Total\": 346, \"Category\": \"Men's 73kg\", \"Normalised\": 0.8417762412009236}, {\"Name\": \" ABDULLAH Rahmat Erwin\", \"Rank\": \"3\", \"Country\": \"INA\", \"Date of Birth\": \"13 OCT 2000\", \"Final Total\": 342, \"Category\": \"Men's 73kg\", \"Normalised\": 0.6652239209490444}, {\"Name\": \" CALJA Briken\", \"Rank\": \"4\", \"Country\": \"ALB\", \"Date of Birth\": \"19 FEB 1990\", \"Final Total\": 341, \"Category\": \"Men's 73kg\", \"Normalised\": 0.6210858408860745}, {\"Name\": \" ANDREEV Bozhidar Dimitrov\", \"Rank\": \"5\", \"Country\": \"BUL\", \"Date of Birth\": \"17 JAN 1997\", \"Final Total\": 338, \"Category\": \"Men's 73kg\", \"Normalised\": 0.48867160069716514}, {\"Name\": \" BEN HNIA Karem\", \"Rank\": \"6\", \"Country\": \"TUN\", \"Date of Birth\": \"13 NOV 1994\", \"Final Total\": 338, \"Category\": \"Men's 73kg\", \"Normalised\": 0.48867160069716514}, {\"Name\": \" MIYAMOTO Masanori\", \"Rank\": \"7\", \"Country\": \"JPN\", \"Date of Birth\": \"3 FEB 1997\", \"Final Total\": 335, \"Category\": \"Men's 73kg\", \"Normalised\": 0.3562573605082557}, {\"Name\": \" ROBU Marin\", \"Rank\": \"8\", \"Country\": \"MDA\", \"Date of Birth\": \"19 MAR 2000\", \"Final Total\": 330, \"Category\": \"Men's 73kg\", \"Normalised\": 0.13556696019340658}, {\"Name\": \" CUMMINGS JR Clarence\", \"Rank\": \"9\", \"Country\": \"USA\", \"Date of Birth\": \"6 JUN 2000\", \"Final Total\": 325, \"Category\": \"Men's 73kg\", \"Normalised\": -0.0851234401214425}, {\"Name\": \" SANCHEZ LOPEZ David\", \"Rank\": \"10\", \"Country\": \"ESP\", \"Date of Birth\": \"20 JUL 1994\", \"Final Total\": 323, \"Category\": \"Men's 73kg\", \"Normalised\": -0.17339960024738216}, {\"Name\": \" CARDENAS ESTRADA Jorge Adan\", \"Rank\": \"11\", \"Country\": \"MEX\", \"Date of Birth\": \"21 APR 1997\", \"Final Total\": 320, \"Category\": \"Men's 73kg\", \"Normalised\": -0.3058138404362916}, {\"Name\": \" ALHUMAYD Mahmoud Mohammed S\", \"Rank\": \"12\", \"Country\": \"KSA\", \"Date of Birth\": \"5 SEP 1993\", \"Final Total\": 306, \"Category\": \"Men's 73kg\", \"Normalised\": -0.923746961317869}, {\"Name\": \" WAKELING Brandon Dean\", \"Rank\": \"13\", \"Country\": \"AUS\", \"Date of Birth\": \"2 FEB 1994\", \"Final Total\": 291, \"Category\": \"Men's 73kg\", \"Normalised\": -1.5858181622624163}, {\"Name\": \" MOUM Abderrahim\", \"Rank\": \"14\", \"Country\": \"MAR\", \"Date of Birth\": \"18 SEP 2000\", \"Final Total\": 278, \"Category\": \"Men's 73kg\", \"Normalised\": -2.159613203081024}, {\"Name\": \" DJURAEV Akbar\", \"Rank\": \"1\", \"Country\": \"UZB\", \"Date of Birth\": \"8 OCT 1999\", \"Final Total\": 430, \"Category\": \"Men's 109kg\", \"Normalised\": 1.3251171354269362}, {\"Name\": \" MARTIROSYAN Simon\", \"Rank\": \"2\", \"Country\": \"ARM\", \"Date of Birth\": \"17 FEB 1997\", \"Final Total\": 423, \"Category\": \"Men's 109kg\", \"Normalised\": 1.1094003924504583}, {\"Name\": \" PLESNIEKS Arturs\", \"Rank\": \"3\", \"Country\": \"LAT\", \"Date of Birth\": \"21 JAN 1992\", \"Final Total\": 410, \"Category\": \"Men's 109kg\", \"Normalised\": 0.7087835840655705}, {\"Name\": \" NANIEV Timur\", \"Rank\": \"4\", \"Country\": \"ROC\", \"Date of Birth\": \"20 SEP 1994\", \"Final Total\": 409, \"Category\": \"Men's 109kg\", \"Normalised\": 0.6779669064975022}, {\"Name\": \" HRISTOV Hristo Dimitrov\", \"Rank\": \"5\", \"Country\": \"BUL\", \"Date of Birth\": \"27 APR 2001\", \"Final Total\": 408, \"Category\": \"Men's 109kg\", \"Normalised\": 0.647150228929434}, {\"Name\": \" JIN Yunseong\", \"Rank\": \"6\", \"Country\": \"KOR\", \"Date of Birth\": \"11 OCT 1995\", \"Final Total\": 400, \"Category\": \"Men's 109kg\", \"Normalised\": 0.40061680838488767}, {\"Name\": \" MICHALSKI Arkadiusz\", \"Rank\": \"7\", \"Country\": \"POL\", \"Date of Birth\": \"7 JAN 1990\", \"Final Total\": 391, \"Category\": \"Men's 109kg\", \"Normalised\": 0.12326671027227314}, {\"Name\": \" KITTS Wesley Brian\", \"Rank\": \"8\", \"Country\": \"USA\", \"Date of Birth\": \"22 MAY 1990\", \"Final Total\": 390, \"Category\": \"Men's 109kg\", \"Normalised\": 0.09245003270420485}, {\"Name\": \" BACHA Aymen\", \"Rank\": \"9\", \"Country\": \"TUN\", \"Date of Birth\": \"26 OCT 1999\", \"Final Total\": 388, \"Category\": \"Men's 109kg\", \"Normalised\": 0.030816677568068284}, {\"Name\": \" OVEZOV Ovez\", \"Rank\": \"10\", \"Country\": \"TKM\", \"Date of Birth\": \"11 JUN 1997\", \"Final Total\": 371, \"Category\": \"Men's 109kg\", \"Normalised\": -0.49306684108909254}, {\"Name\": \" SIDISKIS Arnas\", \"Rank\": \"11\", \"Country\": \"LTU\", \"Date of Birth\": \"5 JUL 1990\", \"Final Total\": 343, \"Category\": \"Men's 109kg\", \"Normalised\": -1.3559338129950045}, {\"Name\": \" LYDEMENT Matthew Ryan\", \"Rank\": \"12\", \"Country\": \"AUS\", \"Date of Birth\": \"15 JAN 1994\", \"Final Total\": 338, \"Category\": \"Men's 109kg\", \"Normalised\": -1.5100172008353459}, {\"Name\": \" JUNGBLUT Tanumafili Malietoa\", \"Rank\": \"13\", \"Country\": \"ASA\", \"Date of Birth\": \"10 JUN 1990\", \"Final Total\": 330, \"Category\": \"Men's 109kg\", \"Normalised\": -1.7565506213798923}, {\"Name\": \" DIAZ Hidilyn\", \"Rank\": \"1\", \"Country\": \"PHI\", \"Date of Birth\": \"20 FEB 1991\", \"Final Total\": 224, \"Category\": \"Women's 55kg\", \"Normalised\": 1.399700954253659}, {\"Name\": \" LIAO Qiuyun\", \"Rank\": \"2\", \"Country\": \"CHN\", \"Date of Birth\": \"13 JUL 1995\", \"Final Total\": 223, \"Category\": \"Women's 55kg\", \"Normalised\": 1.3482683732574614}, {\"Name\": \" CHINSHANLO Zulfiya\", \"Rank\": \"3\", \"Country\": \"KAZ\", \"Date of Birth\": \"25 JUL 1993\", \"Final Total\": 213, \"Category\": \"Women's 55kg\", \"Normalised\": 0.8339425632954872}, {\"Name\": \" NABIEVA Muattar\", \"Rank\": \"4\", \"Country\": \"UZB\", \"Date of Birth\": \"2 JUN 1996\", \"Final Total\": 212, \"Category\": \"Women's 55kg\", \"Normalised\": 0.7825099822992898}, {\"Name\": \" KONOTOP Kamila\", \"Rank\": \"5\", \"Country\": \"UKR\", \"Date of Birth\": \"23 MAR 2001\", \"Final Total\": 206, \"Category\": \"Women's 55kg\", \"Normalised\": 0.47391449632210525}, {\"Name\": \" SHERMETOVA Kristina\", \"Rank\": \"6\", \"Country\": \"TKM\", \"Date of Birth\": \"25 MAY 1993\", \"Final Total\": 205, \"Category\": \"Women's 55kg\", \"Normalised\": 0.42248191532590784}, {\"Name\": \" HAM Eunji\", \"Rank\": \"7\", \"Country\": \"KOR\", \"Date of Birth\": \"23 JUL 1997\", \"Final Total\": 201, \"Category\": \"Women's 55kg\", \"Normalised\": 0.21675159134111813}, {\"Name\": \" LANDOULSI Nouha\", \"Rank\": \"8\", \"Country\": \"TUN\", \"Date of Birth\": \"5 MAY 1998\", \"Final Total\": 196, \"Category\": \"Women's 55kg\", \"Normalised\": -0.04041131363986899}, {\"Name\": \" LOPEZ FERRER Ana Gabriela\", \"Rank\": \"9\", \"Country\": \"MEX\", \"Date of Birth\": \"22 SEP 1994\", \"Final Total\": 195, \"Category\": \"Women's 55kg\", \"Normalised\": -0.0918438946360664}, {\"Name\": \" LOCHOWSKA Joanna\", \"Rank\": \"10\", \"Country\": \"POL\", \"Date of Birth\": \"17 NOV 1988\", \"Final Total\": 186, \"Category\": \"Women's 55kg\", \"Normalised\": -0.5547371236018432}, {\"Name\": \" YAGI Kanae\", \"Rank\": \"11\", \"Country\": \"JPN\", \"Date of Birth\": \"16 JUL 1992\", \"Final Total\": 183, \"Category\": \"Women's 55kg\", \"Normalised\": -0.7090348665904355}, {\"Name\": \" LEBLANC-BAZINET Rachel\", \"Rank\": \"12\", \"Country\": \"CAN\", \"Date of Birth\": \"10 OCT 1988\", \"Final Total\": 181, \"Category\": \"Women's 55kg\", \"Normalised\": -0.8119000285828303}, {\"Name\": \" CHIANG Nien-Hsin\", \"Rank\": \"13\", \"Country\": \"TPE\", \"Date of Birth\": \"29 APR 1997\", \"Final Total\": 176, \"Category\": \"Women's 55kg\", \"Normalised\": -1.0690629335638175}, {\"Name\": \" LIFU Mary Kini\", \"Rank\": \"14\", \"Country\": \"SOL\", \"Date of Birth\": \"15 OCT 1994\", \"Final Total\": 154, \"Category\": \"Women's 55kg\", \"Normalised\": -2.2005797154801607}, {\"Name\": \" KUO Hsing-Chun\", \"Rank\": \"1\", \"Country\": \"TPE\", \"Date of Birth\": \"26 NOV 1993\", \"Final Total\": 236, \"Category\": \"Women's 59kg\", \"Normalised\": 1.9263340801561706}, {\"Name\": \" GURYEVA Polina\", \"Rank\": \"2\", \"Country\": \"TKM\", \"Date of Birth\": \"5 OCT 1999\", \"Final Total\": 217, \"Category\": \"Women's 59kg\", \"Normalised\": 0.7735672290390921}, {\"Name\": \" ANDOH Mikiko\", \"Rank\": \"3\", \"Country\": \"JPN\", \"Date of Birth\": \"30 SEP 1992\", \"Final Total\": 214, \"Category\": \"Women's 59kg\", \"Normalised\": 0.5915514104416587}, {\"Name\": \" TCHAKOUNTE Dora Meiriama\", \"Rank\": \"4\", \"Country\": \"FRA\", \"Date of Birth\": \"23 MAR 1995\", \"Final Total\": 213, \"Category\": \"Women's 59kg\", \"Normalised\": 0.5308794709091809}, {\"Name\": \" HOANG Thi Duyen\", \"Rank\": \"5\", \"Country\": \"VIE\", \"Date of Birth\": \"26 APR 1996\", \"Final Total\": 208, \"Category\": \"Women's 59kg\", \"Normalised\": 0.22751977324679182}, {\"Name\": \" FIGUEROA ROLDAN Yusleidy Mariana\", \"Rank\": \"6\", \"Country\": \"VEN\", \"Date of Birth\": \"1 SEP 1993\", \"Final Total\": 206, \"Category\": \"Women's 59kg\", \"Normalised\": 0.10617589418183618}, {\"Name\": \" YAYLYAN Izabella\", \"Rank\": \"7\", \"Country\": \"ARM\", \"Date of Birth\": \"4 JAN 1995\", \"Final Total\": 205, \"Category\": \"Women's 59kg\", \"Normalised\": 0.04550395464935836}, {\"Name\": \" SMITH Zoe\", \"Rank\": \"8\", \"Country\": \"GBR\", \"Date of Birth\": \"26 APR 1994\", \"Final Total\": 200, \"Category\": \"Women's 59kg\", \"Normalised\": -0.2578557430130307}, {\"Name\": \" DARSIGNY Tali\", \"Rank\": \"9\", \"Country\": \"CAN\", \"Date of Birth\": \"8 MAR 1998\", \"Final Total\": 199, \"Category\": \"Women's 59kg\", \"Normalised\": -0.3185276825455085}, {\"Name\": \" KUSTERER Sabine Beate\", \"Rank\": \"10\", \"Country\": \"GER\", \"Date of Birth\": \"4 JAN 1991\", \"Final Total\": 198, \"Category\": \"Women's 59kg\", \"Normalised\": -0.37919962207798635}, {\"Name\": \" ALEMANNO Maria Grazia\", \"Rank\": \"11\", \"Country\": \"ITA\", \"Date of Birth\": \"2 SEP 1990\", \"Final Total\": 185, \"Category\": \"Women's 59kg\", \"Normalised\": -1.167934836000198}, {\"Name\": \" YAMASAKI Erika Yuriko Iris\", \"Rank\": \"12\", \"Country\": \"AUS\", \"Date of Birth\": \"2 SEP 1987\", \"Final Total\": 170, \"Category\": \"Women's 59kg\", \"Normalised\": -2.078013928987365}, {\"Name\": \" LYU Xiaojun\", \"Rank\": \"1\", \"Country\": \"CHN\", \"Date of Birth\": \"27 JUL 1984\", \"Final Total\": 374, \"Category\": \"Men's 81kg\", \"Normalised\": 1.1716771210714578}, {\"Name\": \" BONNAT MICHEL Zacarias\", \"Rank\": \"2\", \"Country\": \"DOM\", \"Date of Birth\": \"27 FEB 1996\", \"Final Total\": 367, \"Category\": \"Men's 81kg\", \"Normalised\": 0.8761189283687478}, {\"Name\": \" PIZZOLATO Antonino\", \"Rank\": \"3\", \"Country\": \"ITA\", \"Date of Birth\": \"20 AUG 1996\", \"Final Total\": 365, \"Category\": \"Men's 81kg\", \"Normalised\": 0.7916737304536877}, {\"Name\": \" MAURUS Harrison James\", \"Rank\": \"4\", \"Country\": \"USA\", \"Date of Birth\": \"26 FEB 2000\", \"Final Total\": 361, \"Category\": \"Men's 81kg\", \"Normalised\": 0.6227833346235677}, {\"Name\": \" RODALLEGAS CARVAJAL Brayan Santiago\", \"Rank\": \"5\", \"Country\": \"COL\", \"Date of Birth\": \"15 NOV 1997\", \"Final Total\": 359, \"Category\": \"Men's 81kg\", \"Normalised\": 0.5383381367085077}, {\"Name\": \" SUHAREVS Ritvars\", \"Rank\": \"6\", \"Country\": \"LAT\", \"Date of Birth\": \"11 JAN 1999\", \"Final Total\": 358, \"Category\": \"Men's 81kg\", \"Normalised\": 0.49611553775097766}, {\"Name\": \" MUELLER Nico\", \"Rank\": \"7\", \"Country\": \"GER\", \"Date of Birth\": \"2 NOV 1993\", \"Final Total\": 354, \"Category\": \"Men's 81kg\", \"Normalised\": 0.3272251419208576}, {\"Name\": \" MATA PEREZ Andres Eduardo\", \"Rank\": \"8\", \"Country\": \"ESP\", \"Date of Birth\": \"11 NOV 1992\", \"Final Total\": 347, \"Category\": \"Men's 81kg\", \"Normalised\": 0.03166694921814751}, {\"Name\": \" QERIMAJ Erkand\", \"Rank\": \"9\", \"Country\": \"ALB\", \"Date of Birth\": \"10 AUG 1988\", \"Final Total\": 338, \"Category\": \"Men's 81kg\", \"Normalised\": -0.3483364413996226}, {\"Name\": \" AL-KANJARI Amur Salim Ramadhan\", \"Rank\": \"10\", \"Country\": \"OMA\", \"Date of Birth\": \"16 OCT 2000\", \"Final Total\": 317, \"Category\": \"Men's 81kg\", \"Normalised\": -1.2350110195077528}, {\"Name\": \" McTAGGART Cameron David\", \"Rank\": \"11\", \"Country\": \"NZL\", \"Date of Birth\": \"30 SEP 1997\", \"Final Total\": 315, \"Category\": \"Men's 81kg\", \"Normalised\": -1.3194562174228128}, {\"Name\": \" BAHLOUL Ramzi\", \"Rank\": \"12\", \"Country\": \"TUN\", \"Date of Birth\": \"18 OCT 1989\", \"Final Total\": 300, \"Category\": \"Men's 81kg\", \"Normalised\": -1.952795201785763}, {\"Name\": \" HOU Zhihui\", \"Rank\": \"1\", \"Country\": \"CHN\", \"Date of Birth\": \"18 MAR 1997\", \"Final Total\": 210, \"Category\": \"Women's 49kg\", \"Normalised\": 1.9603921176392136}, {\"Name\": \" MIRABAI Chanu Saikhom\", \"Rank\": \"2\", \"Country\": \"IND\", \"Date of Birth\": \"8 AUG 1994\", \"Final Total\": 202, \"Category\": \"Women's 49kg\", \"Normalised\": 1.4002800840280096}, {\"Name\": \" AISAH Windy Cantika\", \"Rank\": \"3\", \"Country\": \"INA\", \"Date of Birth\": \"11 JUN 2002\", \"Final Total\": 194, \"Category\": \"Women's 49kg\", \"Normalised\": 0.8401680504168059}, {\"Name\": \" FANG Wan-Ling\", \"Rank\": \"4\", \"Country\": \"TPE\", \"Date of Birth\": \"1 DEC 1999\", \"Final Total\": 181, \"Category\": \"Women's 49kg\", \"Normalised\": -0.07001400420140048}, {\"Name\": \" STERCKX Nina\", \"Rank\": \"5\", \"Country\": \"BEL\", \"Date of Birth\": \"26 JUL 2002\", \"Final Total\": 180, \"Category\": \"Women's 49kg\", \"Normalised\": -0.14002800840280097}, {\"Name\": \" MONTERO RAMOS Ludia Marguiela\", \"Rank\": \"6\", \"Country\": \"CUB\", \"Date of Birth\": \"17 APR 1999\", \"Final Total\": 178, \"Category\": \"Women's 49kg\", \"Normalised\": -0.28005601680560194}, {\"Name\": \" MICHEL Anais\", \"Rank\": \"7\", \"Country\": \"FRA\", \"Date of Birth\": \"12 JAN 1988\", \"Final Total\": 177, \"Category\": \"Women's 49kg\", \"Normalised\": -0.3500700210070024}, {\"Name\": \" PIRON CANDELARIO Beatriz Elizabeth\", \"Rank\": \"8\", \"Country\": \"DOM\", \"Date of Birth\": \"27 FEB 1995\", \"Final Total\": 176, \"Category\": \"Women's 49kg\", \"Normalised\": -0.42008402520840293}, {\"Name\": \" ROSA FIGUEIREDO Nathasha\", \"Rank\": \"9\", \"Country\": \"BRA\", \"Date of Birth\": \"16 JAN 1996\", \"Final Total\": 173, \"Category\": \"Women's 49kg\", \"Normalised\": -0.6301260378126043}, {\"Name\": \" TOUA Loa Dika\", \"Rank\": \"10\", \"Country\": \"PNG\", \"Date of Birth\": \"23 JUN 1984\", \"Final Total\": 167, \"Category\": \"Women's 49kg\", \"Normalised\": -1.0502100630210074}, {\"Name\": \" RANAIVOSOA Marie Hanitra Roilya\", \"Rank\": \"11\", \"Country\": \"MRI\", \"Date of Birth\": \"14 NOV 1990\", \"Final Total\": 164, \"Category\": \"Women's 49kg\", \"Normalised\": -1.2602520756252087}, {\"Name\": \" CHARRON Maude G\", \"Rank\": \"1\", \"Country\": \"CAN\", \"Date of Birth\": \"28 APR 1993\", \"Final Total\": 236, \"Category\": \"Women's 64kg\", \"Normalised\": 1.2348064155768799}, {\"Name\": \" BORDIGNON Giorgia\", \"Rank\": \"2\", \"Country\": \"ITA\", \"Date of Birth\": \"24 MAY 1987\", \"Final Total\": 232, \"Category\": \"Women's 64kg\", \"Normalised\": 0.929044826957843}, {\"Name\": \" CHEN Wen-Huei\", \"Rank\": \"3\", \"Country\": \"TPE\", \"Date of Birth\": \"23 FEB 1997\", \"Final Total\": 230, \"Category\": \"Women's 64kg\", \"Normalised\": 0.7761640326483246}, {\"Name\": \" PEREZ TIGRERO Mercedes Isabel\", \"Rank\": \"4\", \"Country\": \"COL\", \"Date of Birth\": \"7 AUG 1987\", \"Final Total\": 227, \"Category\": \"Women's 64kg\", \"Normalised\": 0.546842841184047}, {\"Name\": \" DAVIES Sarah\", \"Rank\": \"5\", \"Country\": \"GBR\", \"Date of Birth\": \"19 AUG 1992\", \"Final Total\": 227, \"Category\": \"Women's 64kg\", \"Normalised\": 0.546842841184047}, {\"Name\": \" PALACIOS DAJOMES Angie Paola\", \"Rank\": \"6\", \"Country\": \"ECU\", \"Date of Birth\": \"12 SEP 2000\", \"Final Total\": 226, \"Category\": \"Women's 64kg\", \"Normalised\": 0.4704024440292878}, {\"Name\": \" ANDO Elreen Ann\", \"Rank\": \"7\", \"Country\": \"PHI\", \"Date of Birth\": \"1 NOV 1998\", \"Final Total\": 222, \"Category\": \"Women's 64kg\", \"Normalised\": 0.16464085541025106}, {\"Name\": \" RODRIGUEZ MITJAN Marina de la Cari.\", \"Rank\": \"8\", \"Country\": \"CUB\", \"Date of Birth\": \"2 MAR 1995\", \"Final Total\": 221, \"Category\": \"Women's 64kg\", \"Normalised\": 0.08820045825549187}, {\"Name\": \" LEVENT Nuray\", \"Rank\": \"9\", \"Country\": \"TUR\", \"Date of Birth\": \"8 MAY 2000\", \"Final Total\": 220, \"Category\": \"Women's 64kg\", \"Normalised\": 0.011760061100732685}, {\"Name\": \" SCHWEIZER Lisa Marie\", \"Rank\": \"10\", \"Country\": \"GER\", \"Date of Birth\": \"18 JUL 1995\", \"Final Total\": 217, \"Category\": \"Women's 64kg\", \"Normalised\": -0.21756113036354488}, {\"Name\": \" ELLIOTT Kiana Rose\", \"Rank\": \"11\", \"Country\": \"AUS\", \"Date of Birth\": \"27 JUL 1997\", \"Final Total\": 209, \"Category\": \"Women's 64kg\", \"Normalised\": -0.8290843076016184}, {\"Name\": \" LUDRICK RIVAS Sema Nancy\", \"Rank\": \"12\", \"Country\": \"NCA\", \"Date of Birth\": \"21 DEC 1999\", \"Final Total\": 202, \"Category\": \"Women's 64kg\", \"Normalised\": -1.3641670876849328}, {\"Name\": \" ZAMMIT STEVENS Yasmin\", \"Rank\": \"13\", \"Country\": \"MLT\", \"Date of Birth\": \"21 APR 1993\", \"Final Total\": 189, \"Category\": \"Women's 64kg\", \"Normalised\": -2.357892250696802}, {\"Name\": \" LI Wenwen\", \"Rank\": \"1\", \"Country\": \"CHN\", \"Date of Birth\": \"5 MAR 2000\", \"Final Total\": 320, \"Category\": \"Women's +87kg\", \"Normalised\": 2.0944014896141456}, {\"Name\": \" CAMPBELL Emily Jade\", \"Rank\": \"2\", \"Country\": \"GBR\", \"Date of Birth\": \"6 MAY 1994\", \"Final Total\": 283, \"Category\": \"Women's +87kg\", \"Normalised\": 1.0395249278294292}, {\"Name\": \" ROBLES Sarah Elizabeth\", \"Rank\": \"3\", \"Country\": \"USA\", \"Date of Birth\": \"1 AUG 1988\", \"Final Total\": 282, \"Category\": \"Women's +87kg\", \"Normalised\": 1.0110147504838964}, {\"Name\": \" LEE Seon Mi\", \"Rank\": \"4\", \"Country\": \"KOR\", \"Date of Birth\": \"1 AUG 2000\", \"Final Total\": 277, \"Category\": \"Women's +87kg\", \"Normalised\": 0.868463863756232}, {\"Name\": \" AKMAL Nurul\", \"Rank\": \"5\", \"Country\": \"INA\", \"Date of Birth\": \"12 FEB 1993\", \"Final Total\": 256, \"Category\": \"Women's +87kg\", \"Normalised\": 0.26975013950004156}, {\"Name\": \" AMOE-TARRANT Charisma\", \"Rank\": \"6\", \"Country\": \"AUS\", \"Date of Birth\": \"26 MAY 1999\", \"Final Total\": 243, \"Category\": \"Women's +87kg\", \"Normalised\": -0.1008821659918858}, {\"Name\": \" SALADIN TOLENTINO Veronica Estela\", \"Rank\": \"7\", \"Country\": \"DOM\", \"Date of Birth\": \"21 MAY 1992\", \"Final Total\": 242, \"Category\": \"Women's +87kg\", \"Normalised\": -0.1293923433374187}, {\"Name\": \" MANUMUA Kuinini Juanita Mechteld\", \"Rank\": \"8\", \"Country\": \"TGA\", \"Date of Birth\": \"12 DEC 2000\", \"Final Total\": 228, \"Category\": \"Women's +87kg\", \"Normalised\": -0.5285348261748789}, {\"Name\": \" DUVERGER PILETA Eyurkenia\", \"Rank\": \"9\", \"Country\": \"CUB\", \"Date of Birth\": \"4 OCT 1999\", \"Final Total\": 225, \"Category\": \"Women's +87kg\", \"Normalised\": -0.6140653582114776}, {\"Name\": \" FISCHER Sarah\", \"Rank\": \"10\", \"Country\": \"AUT\", \"Date of Birth\": \"9 NOV 2000\", \"Final Total\": 220, \"Category\": \"Women's +87kg\", \"Normalised\": -0.7566162449391419}, {\"Name\": \" VANBELLINGHEN Anna Marie-Julienne A\", \"Rank\": \"11\", \"Country\": \"BEL\", \"Date of Birth\": \"10 MAR 1994\", \"Final Total\": 219, \"Category\": \"Women's +87kg\", \"Normalised\": -0.7851264222846749}, {\"Name\": \" UCELO MARROQUIN Scarleth\", \"Rank\": \"12\", \"Country\": \"GUA\", \"Date of Birth\": \"7 APR 2000\", \"Final Total\": 207, \"Category\": \"Women's +87kg\", \"Normalised\": -1.1272485504310694}, {\"Name\": \" ERDENEBAT Bilegsaikhan\", \"Rank\": \"13\", \"Country\": \"MGL\", \"Date of Birth\": \"16 SEP 1998\", \"Final Total\": 203, \"Category\": \"Women's +87kg\", \"Normalised\": -1.2412892598132008}, {\"Name\": \" LI Fabin\", \"Rank\": \"1\", \"Country\": \"CHN\", \"Date of Birth\": \"15 JAN 1993\", \"Final Total\": 313, \"Category\": \"Men's 61kg\", \"Normalised\": 1.6248079001625444}, {\"Name\": \" IRAWAN Eko Yuli\", \"Rank\": \"2\", \"Country\": \"INA\", \"Date of Birth\": \"24 JUL 1989\", \"Final Total\": 302, \"Category\": \"Men's 61kg\", \"Normalised\": 1.0677309058211002}, {\"Name\": \" SON Igor\", \"Rank\": \"3\", \"Country\": \"KAZ\", \"Date of Birth\": \"16 NOV 1998\", \"Final Total\": 294, \"Category\": \"Men's 61kg\", \"Normalised\": 0.6625840008455045}, {\"Name\": \" ITOKAZU Yoichi\", \"Rank\": \"4\", \"Country\": \"JPN\", \"Date of Birth\": \"24 MAY 1991\", \"Final Total\": 292, \"Category\": \"Men's 61kg\", \"Normalised\": 0.5612972746016056}, {\"Name\": \" ALSALEEM Seraj Abdulrahim M\", \"Rank\": \"5\", \"Country\": \"KSA\", \"Date of Birth\": \"10 FEB 1996\", \"Final Total\": 288, \"Category\": \"Men's 61kg\", \"Normalised\": 0.35872382211380777}, {\"Name\": \" RUIU Davide\", \"Rank\": \"6\", \"Country\": \"ITA\", \"Date of Birth\": \"22 JUN 2001\", \"Final Total\": 286, \"Category\": \"Men's 61kg\", \"Normalised\": 0.2574370958699088}, {\"Name\": \" MISHVELIDZE Shota\", \"Rank\": \"7\", \"Country\": \"GEO\", \"Date of Birth\": \"18 OCT 1994\", \"Final Total\": 285, \"Category\": \"Men's 61kg\", \"Normalised\": 0.20679373274795937}, {\"Name\": \" GARCIA BRITO Luis Alberto\", \"Rank\": \"8\", \"Country\": \"DOM\", \"Date of Birth\": \"19 APR 1995\", \"Final Total\": 274, \"Category\": \"Men's 61kg\", \"Normalised\": -0.3502832615934848}, {\"Name\": \" BRANDHUBER Simon Josef\", \"Rank\": \"9\", \"Country\": \"GER\", \"Date of Birth\": \"27 JUN 1991\", \"Final Total\": 268, \"Category\": \"Men's 61kg\", \"Normalised\": -0.6541434403251816}, {\"Name\": \" BARU Morea\", \"Rank\": \"10\", \"Country\": \"PNG\", \"Date of Birth\": \"15 APR 1990\", \"Final Total\": 265, \"Category\": \"Men's 61kg\", \"Normalised\": -0.80607352969103}, {\"Name\": \" ANDRIANTSITOHAINA Eric Herman\", \"Rank\": \"11\", \"Country\": \"MAD\", \"Date of Birth\": \"21 JUL 1991\", \"Final Total\": 264, \"Category\": \"Men's 61kg\", \"Normalised\": -0.8567168928129795}, {\"Name\": \" ROJAS CONCHA Marcos Antonio\", \"Rank\": \"12\", \"Country\": \"PER\", \"Date of Birth\": \"2 JUN 1995\", \"Final Total\": 240, \"Category\": \"Men's 61kg\", \"Normalised\": -2.0721576077397668}, {\"Name\": \" CHEN Lijun\", \"Rank\": \"1\", \"Country\": \"CHN\", \"Date of Birth\": \"8 FEB 1993\", \"Final Total\": 332, \"Category\": \"Men's 67kg\", \"Normalised\": 1.0741450728590274}, {\"Name\": \" MOSQUERA LOZANO Luis Javier\", \"Rank\": \"2\", \"Country\": \"COL\", \"Date of Birth\": \"27 MAR 1995\", \"Final Total\": 331, \"Category\": \"Men's 67kg\", \"Normalised\": 1.0322952648255588}, {\"Name\": \" ZANNI Mirko\", \"Rank\": \"3\", \"Country\": \"ITA\", \"Date of Birth\": \"16 OCT 1997\", \"Final Total\": 322, \"Category\": \"Men's 67kg\", \"Normalised\": 0.6556469925243417}, {\"Name\": \" HAN Myeongmok\", \"Rank\": \"4\", \"Country\": \"KOR\", \"Date of Birth\": \"1 FEB 1991\", \"Final Total\": 321, \"Category\": \"Men's 67kg\", \"Normalised\": 0.6137971844908731}, {\"Name\": \" TALIB Talha\", \"Rank\": \"5\", \"Country\": \"PAK\", \"Date of Birth\": \"3 OCT 1999\", \"Final Total\": 320, \"Category\": \"Men's 67kg\", \"Normalised\": 0.5719473764574046}, {\"Name\": \" ERGASHEV Adkhamjon\", \"Rank\": \"6\", \"Country\": \"UZB\", \"Date of Birth\": \"12 MAR 1999\", \"Final Total\": 312, \"Category\": \"Men's 67kg\", \"Normalised\": 0.237148912189656}, {\"Name\": \" KONNAI Mitsunori\", \"Rank\": \"7\", \"Country\": \"JPN\", \"Date of Birth\": \"14 MAR 1996\", \"Final Total\": 307, \"Category\": \"Men's 67kg\", \"Normalised\": 0.02789987202231317}, {\"Name\": \" CHKHEIDZE Goga\", \"Rank\": \"8\", \"Country\": \"GEO\", \"Date of Birth\": \"11 FEB 1996\", \"Final Total\": 302, \"Category\": \"Men's 67kg\", \"Normalised\": -0.18134916814502966}, {\"Name\": \" DENI .\", \"Rank\": \"9\", \"Country\": \"INA\", \"Date of Birth\": \"26 JUL 1989\", \"Final Total\": 301, \"Category\": \"Men's 67kg\", \"Normalised\": -0.2231989761784982}, {\"Name\": \" MUNOZ MARTINEZ Jonathan Antonio\", \"Rank\": \"10\", \"Country\": \"MEX\", \"Date of Birth\": \"10 NOV 1995\", \"Final Total\": 298, \"Category\": \"Men's 67kg\", \"Normalised\": -0.3487484002789039}, {\"Name\": \" ANDRIANTSITOHAINA Tojonirina Alain\", \"Rank\": \"11\", \"Country\": \"MAD\", \"Date of Birth\": \"26 FEB 1995\", \"Final Total\": 285, \"Category\": \"Men's 67kg\", \"Normalised\": -0.8927959047139953}, {\"Name\": \" KATOATAU Ruben\", \"Rank\": \"12\", \"Country\": \"KIR\", \"Date of Birth\": \"9 FEB 1997\", \"Final Total\": 245, \"Category\": \"Men's 67kg\", \"Normalised\": -2.5667882260527377}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Plot z-scores for all lifters\n",
    "\n",
    "alt.Chart(df_all, title=\"Z-scores for all lifters\",).mark_circle().encode(\n",
    "    y=alt.Y(\n",
    "        'jitter:Q',\n",
    "        title=None,\n",
    "        axis=alt.Axis(values=[0], ticks=True, grid=False, labels=False),\n",
    "        scale=alt.Scale(),\n",
    "        ),\n",
    "    x=alt.X('Normalised:Q', title='Z-score'),\n",
    "    color=alt.Color('Rank:Q', legend=None, scale=alt.Scale(scheme='turbo')),\n",
    "    tooltip=['Name:N', 'Rank:Q', 'Category:N', 'Final Total:Q'],\n",
    "    ).transform_calculate(\n",
    "        jitter='sqrt(-2*log(random()))*cos(2*PI*random())'\n",
    "    ).configure_facet(\n",
    "        spacing=0\n",
    "    ).configure_view(\n",
    "        stroke=None\n",
    "    )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "naval-plasma",
   "metadata": {},
   "outputs": [],
   "source": [
    "# save file to pickle for streamlit python files to used\n",
    "df_all = df_all.astype({\n",
    "    'Name': 'str',\n",
    "    'Rank': 'int',\n",
    "    'Country': 'str',\n",
    "    'Date of Birth': 'str',\n",
    "    'Final Total': 'float',\n",
    "    'Category': 'str',\n",
    "    'Normalised': 'float',\n",
    "})\n",
    "df_all.to_pickle('results_all.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "major-sleeve",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 175 entries, 0 to 174\n",
      "Data columns (total 7 columns):\n",
      " #   Column         Non-Null Count  Dtype  \n",
      "---  ------         --------------  -----  \n",
      " 0   Name           175 non-null    object \n",
      " 1   Rank           175 non-null    int64  \n",
      " 2   Country        175 non-null    object \n",
      " 3   Date of Birth  175 non-null    object \n",
      " 4   Final Total    175 non-null    float64\n",
      " 5   Category       175 non-null    object \n",
      " 6   Normalised     175 non-null    float64\n",
      "dtypes: float64(2), int64(1), object(4)\n",
      "memory usage: 9.7+ KB\n"
     ]
    }
   ],
   "source": [
    "df_all.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "intensive-income",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"Women's 76kg\",\n",
       " \"Men's 96kg\",\n",
       " \"Men's +109kg\",\n",
       " \"Women's 87kg\",\n",
       " \"Men's 73kg\",\n",
       " \"Men's 109kg\",\n",
       " \"Women's 55kg\",\n",
       " \"Women's 59kg\",\n",
       " \"Men's 81kg\",\n",
       " \"Women's 49kg\",\n",
       " \"Women's 64kg\",\n",
       " \"Women's +87kg\",\n",
       " \"Men's 61kg\",\n",
       " \"Men's 67kg\"]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = list(df_all['Category'].unique())\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "superior-publicity",
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (<ipython-input-73-beb0d1430932>, line 15)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;36m  File \u001b[0;32m\"<ipython-input-73-beb0d1430932>\"\u001b[0;36m, line \u001b[0;32m15\u001b[0m\n\u001b[0;31m    for\u001b[0m\n\u001b[0m        ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "m_lst = []\n",
    "w_lst = []\n",
    "for cat in x:\n",
    "    gender = cat.split()[0]\n",
    "    weight = cat.split()[1].replace('kg', '')\n",
    "    if gender == \"Men's\":\n",
    "        if not m_lst:\n",
    "            m_lst.append(cat)\n",
    "        elif '+' in weight:\n",
    "            last_m = cat\n",
    "        elif int(weight) <= int(m_lst[0].split()[1].replace('kg', '')):\n",
    "            print(f\"\"\"\n",
    "            {weight} <= {m_lst[0].split()[1].replace('kg', '')\n",
    "            }\"\"\")\n",
    "            for \n",
    "            m_lst.insert(0, cat)\n",
    "        else:\n",
    "            m_lst.append(cat)\n",
    "#     elif cat.split()[0] == \"Women's\":\n",
    "#         lst.insert(-1, cat)\n",
    "lst = w_lst + m_lst + [last_m]\n",
    "lst"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "acquired-pacific",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "cooperative-overview",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'76'"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x[0].split()[1].replace('kg', '')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "institutional-refund",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"Women's 76kg\",\n",
       " \"Men's 96kg\",\n",
       " \"Men's +109kg\",\n",
       " \"Women's 87kg\",\n",
       " \"Men's 73kg\",\n",
       " \"Men's 109kg\",\n",
       " \"Women's 55kg\",\n",
       " \"Women's 59kg\",\n",
       " \"Men's 81kg\",\n",
       " \"Women's 49kg\",\n",
       " \"Women's 64kg\",\n",
       " \"Women's +87kg\",\n",
       " \"Men's 61kg\",\n",
       " \"Men's 67kg\"]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "derived-discrimination",
   "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>Country</th>\n",
       "      <th>Date of Birth</th>\n",
       "      <th>Final Total</th>\n",
       "      <th>Category</th>\n",
       "      <th>Normalised</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>LI Fabin</td>\n",
       "      <td>1</td>\n",
       "      <td>CHN</td>\n",
       "      <td>15 JAN 1993</td>\n",
       "      <td>313.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>1.624808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>IRAWAN Eko Yuli</td>\n",
       "      <td>2</td>\n",
       "      <td>INA</td>\n",
       "      <td>24 JUL 1989</td>\n",
       "      <td>302.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>1.067731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>SON Igor</td>\n",
       "      <td>3</td>\n",
       "      <td>KAZ</td>\n",
       "      <td>16 NOV 1998</td>\n",
       "      <td>294.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>0.662584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>ITOKAZU Yoichi</td>\n",
       "      <td>4</td>\n",
       "      <td>JPN</td>\n",
       "      <td>24 MAY 1991</td>\n",
       "      <td>292.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>0.561297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>ALSALEEM Seraj Abdulrahim M</td>\n",
       "      <td>5</td>\n",
       "      <td>KSA</td>\n",
       "      <td>10 FEB 1996</td>\n",
       "      <td>288.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>0.358724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>RUIU Davide</td>\n",
       "      <td>6</td>\n",
       "      <td>ITA</td>\n",
       "      <td>22 JUN 2001</td>\n",
       "      <td>286.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>0.257437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>MISHVELIDZE Shota</td>\n",
       "      <td>7</td>\n",
       "      <td>GEO</td>\n",
       "      <td>18 OCT 1994</td>\n",
       "      <td>285.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>0.206794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>GARCIA BRITO Luis Alberto</td>\n",
       "      <td>8</td>\n",
       "      <td>DOM</td>\n",
       "      <td>19 APR 1995</td>\n",
       "      <td>274.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>-0.350283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>BRANDHUBER Simon Josef</td>\n",
       "      <td>9</td>\n",
       "      <td>GER</td>\n",
       "      <td>27 JUN 1991</td>\n",
       "      <td>268.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>-0.654143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>BARU Morea</td>\n",
       "      <td>10</td>\n",
       "      <td>PNG</td>\n",
       "      <td>15 APR 1990</td>\n",
       "      <td>265.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>-0.806074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>ANDRIANTSITOHAINA Eric Herman</td>\n",
       "      <td>11</td>\n",
       "      <td>MAD</td>\n",
       "      <td>21 JUL 1991</td>\n",
       "      <td>264.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>-0.856717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>ROJAS CONCHA Marcos Antonio</td>\n",
       "      <td>12</td>\n",
       "      <td>PER</td>\n",
       "      <td>2 JUN 1995</td>\n",
       "      <td>240.0</td>\n",
       "      <td>Men's 61kg</td>\n",
       "      <td>-2.072158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>CHEN Lijun</td>\n",
       "      <td>1</td>\n",
       "      <td>CHN</td>\n",
       "      <td>8 FEB 1993</td>\n",
       "      <td>332.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>1.074145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>MOSQUERA LOZANO Luis Javier</td>\n",
       "      <td>2</td>\n",
       "      <td>COL</td>\n",
       "      <td>27 MAR 1995</td>\n",
       "      <td>331.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>1.032295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>ZANNI Mirko</td>\n",
       "      <td>3</td>\n",
       "      <td>ITA</td>\n",
       "      <td>16 OCT 1997</td>\n",
       "      <td>322.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>0.655647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>HAN Myeongmok</td>\n",
       "      <td>4</td>\n",
       "      <td>KOR</td>\n",
       "      <td>1 FEB 1991</td>\n",
       "      <td>321.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>0.613797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>TALIB Talha</td>\n",
       "      <td>5</td>\n",
       "      <td>PAK</td>\n",
       "      <td>3 OCT 1999</td>\n",
       "      <td>320.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>0.571947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>ERGASHEV Adkhamjon</td>\n",
       "      <td>6</td>\n",
       "      <td>UZB</td>\n",
       "      <td>12 MAR 1999</td>\n",
       "      <td>312.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>0.237149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>KONNAI Mitsunori</td>\n",
       "      <td>7</td>\n",
       "      <td>JPN</td>\n",
       "      <td>14 MAR 1996</td>\n",
       "      <td>307.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>0.027900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>CHKHEIDZE Goga</td>\n",
       "      <td>8</td>\n",
       "      <td>GEO</td>\n",
       "      <td>11 FEB 1996</td>\n",
       "      <td>302.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.181349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>DENI .</td>\n",
       "      <td>9</td>\n",
       "      <td>INA</td>\n",
       "      <td>26 JUL 1989</td>\n",
       "      <td>301.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.223199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>MUNOZ MARTINEZ Jonathan Antonio</td>\n",
       "      <td>10</td>\n",
       "      <td>MEX</td>\n",
       "      <td>10 NOV 1995</td>\n",
       "      <td>298.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.348748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>ANDRIANTSITOHAINA Tojonirina Alain</td>\n",
       "      <td>11</td>\n",
       "      <td>MAD</td>\n",
       "      <td>26 FEB 1995</td>\n",
       "      <td>285.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-0.892796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>KATOATAU Ruben</td>\n",
       "      <td>12</td>\n",
       "      <td>KIR</td>\n",
       "      <td>9 FEB 1997</td>\n",
       "      <td>245.0</td>\n",
       "      <td>Men's 67kg</td>\n",
       "      <td>-2.566788</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Name  Rank Country Date of Birth  \\\n",
       "151                             LI Fabin     1     CHN   15 JAN 1993   \n",
       "152                      IRAWAN Eko Yuli     2     INA   24 JUL 1989   \n",
       "153                             SON Igor     3     KAZ   16 NOV 1998   \n",
       "154                       ITOKAZU Yoichi     4     JPN   24 MAY 1991   \n",
       "155          ALSALEEM Seraj Abdulrahim M     5     KSA   10 FEB 1996   \n",
       "156                          RUIU Davide     6     ITA   22 JUN 2001   \n",
       "157                    MISHVELIDZE Shota     7     GEO   18 OCT 1994   \n",
       "158            GARCIA BRITO Luis Alberto     8     DOM   19 APR 1995   \n",
       "159               BRANDHUBER Simon Josef     9     GER   27 JUN 1991   \n",
       "160                           BARU Morea    10     PNG   15 APR 1990   \n",
       "161        ANDRIANTSITOHAINA Eric Herman    11     MAD   21 JUL 1991   \n",
       "162          ROJAS CONCHA Marcos Antonio    12     PER    2 JUN 1995   \n",
       "163                           CHEN Lijun     1     CHN    8 FEB 1993   \n",
       "164          MOSQUERA LOZANO Luis Javier     2     COL   27 MAR 1995   \n",
       "165                          ZANNI Mirko     3     ITA   16 OCT 1997   \n",
       "166                        HAN Myeongmok     4     KOR    1 FEB 1991   \n",
       "167                          TALIB Talha     5     PAK    3 OCT 1999   \n",
       "168                   ERGASHEV Adkhamjon     6     UZB   12 MAR 1999   \n",
       "169                     KONNAI Mitsunori     7     JPN   14 MAR 1996   \n",
       "170                       CHKHEIDZE Goga     8     GEO   11 FEB 1996   \n",
       "171                               DENI .     9     INA   26 JUL 1989   \n",
       "172      MUNOZ MARTINEZ Jonathan Antonio    10     MEX   10 NOV 1995   \n",
       "173   ANDRIANTSITOHAINA Tojonirina Alain    11     MAD   26 FEB 1995   \n",
       "174                       KATOATAU Ruben    12     KIR    9 FEB 1997   \n",
       "\n",
       "     Final Total    Category  Normalised  \n",
       "151        313.0  Men's 61kg    1.624808  \n",
       "152        302.0  Men's 61kg    1.067731  \n",
       "153        294.0  Men's 61kg    0.662584  \n",
       "154        292.0  Men's 61kg    0.561297  \n",
       "155        288.0  Men's 61kg    0.358724  \n",
       "156        286.0  Men's 61kg    0.257437  \n",
       "157        285.0  Men's 61kg    0.206794  \n",
       "158        274.0  Men's 61kg   -0.350283  \n",
       "159        268.0  Men's 61kg   -0.654143  \n",
       "160        265.0  Men's 61kg   -0.806074  \n",
       "161        264.0  Men's 61kg   -0.856717  \n",
       "162        240.0  Men's 61kg   -2.072158  \n",
       "163        332.0  Men's 67kg    1.074145  \n",
       "164        331.0  Men's 67kg    1.032295  \n",
       "165        322.0  Men's 67kg    0.655647  \n",
       "166        321.0  Men's 67kg    0.613797  \n",
       "167        320.0  Men's 67kg    0.571947  \n",
       "168        312.0  Men's 67kg    0.237149  \n",
       "169        307.0  Men's 67kg    0.027900  \n",
       "170        302.0  Men's 67kg   -0.181349  \n",
       "171        301.0  Men's 67kg   -0.223199  \n",
       "172        298.0  Men's 67kg   -0.348748  \n",
       "173        285.0  Men's 67kg   -0.892796  \n",
       "174        245.0  Men's 67kg   -2.566788  "
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all[df_all['Category'].isin([\"Men's 67kg\", \"Men's 61kg\"])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cellular-recognition",
   "metadata": {},
   "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.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}