banin_2022_parser.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "e6dc79c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "from tika import parser\n",
    "\n",
    "pd.set_option('display.max_rows', 500)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "110de5b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "def text_score_to_float(text_score):\n",
    "    return float(text_score.replace(\",\", \".\"))\n",
    "\n",
    "def sort_by_specific_score(scores_df, column_name):\n",
    "    base_name, factor_str = column_name.replace(\")\", \"\").split(\"/\")\n",
    "    factor = int(factor_str)\n",
    "    scores_by_current_score = scores_df[column_name].sort_values(ascending=False).reset_index(level=0)\n",
    "    scores_by_current_score[f\"{base_name}/100)\"] = scores_by_current_score[column_name] / factor * 100\n",
    "    scores_by_current_score.index = scores_by_current_score.index.set_names([\"Rank\"]) + 1\n",
    "    \n",
    "    return scores_by_current_score"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a197a01c",
   "metadata": {},
   "source": [
    "### Ejecución del servidor tika\n",
    "\n",
    "Si el servidor no se ha ejecutado, descomentar la siguiente línea para iniciar tika. Es necesario tener instalado Java y que el sistema reconozca el comando `java` (para lo cual debe estar agregado al PATH)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "863e1d26",
   "metadata": {},
   "outputs": [],
   "source": [
    "#!java -jar tika-server-1.25.jar"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1cf93d28",
   "metadata": {},
   "source": [
    "## Lectura de datos\n",
    "\n",
    "El archivo de puntajes de hoja de vida para el Centro Industrial de Mantenimiento Integral (Girón, Santander) está publicado en el blog oficial del centro, más precisamente en [esta página](https://centroindustrialmantenimientointegral.blogspot.com/2021/11/publicacion-verificacion-hoja-de-vida.html). \n",
    "\n",
    "El documento de Word publicado en dicha página, con los puntajes de las hojas de vida, está alojado en OneDrive y puede consultarse [aquí](https://onedrive.live.com/redir?resid=6F159E97EAA13858%211096&authkey=%21AAEmIExDy4eOee4&page=View&wdEmbedFS=1).\n",
    "\n",
    "He archivado ambas páginas, en caso de que alguna de las fuentes sea modificada:\n",
    "* [Entrada en el blog](https://archive.md/rEwZg) - [respaldo](https://web.archive.org/web/20211204161526/https://centroindustrialmantenimientointegral.blogspot.com/2021/11/publicacion-verificacion-hoja-de-vida.html)\n",
    "* [Listado de puntajes](https://archive.md/N9Smx) - [respaldo](https://web.archive.org/web/20211204161643/https://onedrive.live.com/View.aspx?resid=6F159E97EAA13858!1096&wdEmbedFS=1&wdo=2&authkey=!AAEmIExDy4eOee4)\n",
    "\n",
    "En cuanto a los resultados generales, fueron obtenidos de la [página de concursos y convocatorias de la ESAP](https://www.esap.edu.co/portal/index.php/concursos-y-convocatorias-2/). Allí han sido publicados los resultados preliminares de las pruebas; [éste es el enlace de descarga directa](https://www.esap.edu.co/portal/index.php/Descargas/3238/sena/61237/result-prueba-impr-03122021.pdf).\n",
    "\n",
    "También he archivado la página de la ESAP con los resultados; el enlace de descarga puede verificarse pasando el puntero sobre el botón de descarga y observando la esquina inferior izquierda (o, utilizando la opción copiar dirección del enlace):\n",
    "* [Página ESAP](https://archive.md/Y1Hls) - [respaldo](https://web.archive.org/web/20211204161658/https://www.esap.edu.co/portal/index.php/concursos-y-convocatorias-2/)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0e8ebd3d",
   "metadata": {},
   "outputs": [],
   "source": [
    "parsed_test_results_pdf = parser.from_file(\"Result-Prueba-Impr-03122021.pdf\")\n",
    "parsed_giron_cvs_pdf = parser.from_file(\"PUBLICACIÓN DE RESULTADOS CIMI (1).pdf\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ebdba083",
   "metadata": {},
   "source": [
    "### Limpieza de datos\n",
    "\n",
    "Transforma los \"No presentó prueba\" a `0` y remueve el nombre del centro de los datos relevantes para que sea más fácil leerlos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3fb3721d",
   "metadata": {},
   "outputs": [],
   "source": [
    "test_results_data = parsed_test_results_pdf[\"content\"]\n",
    "test_results_data = test_results_data.replace(\"No presentó prueba\", \"0\")\n",
    "\n",
    "giron_csv_data = parsed_giron_cvs_pdf[\"content\"]\n",
    "giron_csv_data = giron_csv_data.replace(\"Centro Industrial de Mantenimiento Integral \", \"\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cdd429d5",
   "metadata": {},
   "source": [
    "### Lectura de Datos - Girón\n",
    "\n",
    "Lee el pdf con los puntajes de las hojas de vida de Girón, conserva únicamente los datos relevantes y los guarda en un diccionario cuyas llaves son los `national_id`s (en su mayoría cédulas de ciudadanía) mapeados al puntaje de la hoja de vida."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "231b33c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "giron_scores = {}\n",
    "\n",
    "for giron_csv_datum in giron_csv_data.split(\"\\n\"):\n",
    "    split_line = giron_csv_datum.split()[1:]\n",
    "    if len(split_line) == 2 and split_line[0].isnumeric():\n",
    "        national_id = split_line[0]\n",
    "        cv_score = split_line[1]\n",
    "        giron_scores[national_id] = text_score_to_float(cv_score)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "452ce801",
   "metadata": {},
   "source": [
    "###  Lectura de datos - Puntajes de prueba (ESAP)\n",
    "\n",
    "Lee el pdf con los puntajes de las pruebas (habilidades digitales y socioemocional), conserva los datos relevantes y los agrega a un diccionario cuyas llaves son los `national_id`s mapeados en una tupla a los puntajes obtenidos, transformados en valores de punto flotante (i.e. números con decimales)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8ebc923b",
   "metadata": {},
   "outputs": [],
   "source": [
    "test_result_scores = {}\n",
    "\n",
    "for test_result_datum in test_results_data.split(\"\\n\"):\n",
    "    split_line = test_result_datum.split()[1:]\n",
    "    if len(split_line) == 3 and split_line[0].isnumeric():\n",
    "        national_id = split_line[0]\n",
    "        scores = (\n",
    "            text_score_to_float(split_line[1]),\n",
    "            text_score_to_float(split_line[2])\n",
    "        )\n",
    "        test_result_scores[national_id] = scores"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "60b85c38",
   "metadata": {},
   "source": [
    "### Cálculo de Puntajes\n",
    "\n",
    "Toma los datos anteriores, itera los puntajes para Girón (relevantes para este caso) y para cada persona (basado en su `national_id`) calcula el puntaje total y los puntajes por cada ítem estandarizados al rango correspondiente:\n",
    "* Hojas de vida: 0 a 40.\n",
    "* Prueba habilidades digitales (`test_1`): 0 a 20.\n",
    "* Prueba socioemocional (`test_2`): 0 a 40.\n",
    "\n",
    "Los resultados son conservados en un nuevo diccionario mapeado por `national_id` a una tupla que contiene como primer elemento el puntaje total, seguido de los puntajes descritos anteriormente, en ese orden."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c209a749",
   "metadata": {},
   "outputs": [],
   "source": [
    "total_scores = {}\n",
    "\n",
    "for national_id in giron_scores:\n",
    "    cv_score = giron_scores[national_id] * 0.4\n",
    "    test_1_score = test_result_scores[national_id][0] * 0.2\n",
    "    test_2_score = test_result_scores[national_id][1] * 0.4\n",
    "    total = cv_score + test_1_score + test_2_score\n",
    "    total_scores[national_id] = (total, cv_score, test_1_score, test_2_score)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b68c068f",
   "metadata": {},
   "source": [
    "### Presentación de Resultados\n",
    "\n",
    "Convierte el diccionario con los resultados a un `DataFrame` de pandas, indizado por `national_id`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f8907d0d",
   "metadata": {},
   "outputs": [],
   "source": [
    "scores_df_columns = [\n",
    "    \"Total score (/100)\",\n",
    "    \"CV sore (/40)\",\n",
    "    \"Test 1 score (/20)\",\n",
    "    \"Test 2 score (/40)\"\n",
    "]\n",
    "scores_df = pd.DataFrame.from_dict(total_scores, orient=\"index\", columns=scores_df_columns)\n",
    "scores_df.index = scores_df.index.set_names([\"National ID\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6bfb485a",
   "metadata": {},
   "source": [
    "#### Puntaje total\n",
    "\n",
    "Resultados organizados por puntaje total."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "92ed5be1",
   "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>National ID</th>\n",
       "      <th>Total score (/100)</th>\n",
       "      <th>CV sore (/40)</th>\n",
       "      <th>Test 1 score (/20)</th>\n",
       "      <th>Test 2 score (/40)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>91485661</td>\n",
       "      <td>83.5104</td>\n",
       "      <td>33.7104</td>\n",
       "      <td>15.000</td>\n",
       "      <td>34.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>91228781</td>\n",
       "      <td>82.7340</td>\n",
       "      <td>38.0000</td>\n",
       "      <td>14.334</td>\n",
       "      <td>30.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>23181732</td>\n",
       "      <td>78.1916</td>\n",
       "      <td>34.4576</td>\n",
       "      <td>13.334</td>\n",
       "      <td>30.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13706489</td>\n",
       "      <td>77.3980</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>15.666</td>\n",
       "      <td>29.732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>63490103</td>\n",
       "      <td>76.5340</td>\n",
       "      <td>29.6000</td>\n",
       "      <td>15.334</td>\n",
       "      <td>31.600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>63509285</td>\n",
       "      <td>76.4752</td>\n",
       "      <td>29.9432</td>\n",
       "      <td>14.000</td>\n",
       "      <td>32.532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>91420169</td>\n",
       "      <td>76.3340</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>13.666</td>\n",
       "      <td>30.668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>91487046</td>\n",
       "      <td>76.1556</td>\n",
       "      <td>30.0236</td>\n",
       "      <td>14.000</td>\n",
       "      <td>32.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>91281598</td>\n",
       "      <td>76.0940</td>\n",
       "      <td>28.1600</td>\n",
       "      <td>15.666</td>\n",
       "      <td>32.268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>63507562</td>\n",
       "      <td>74.5740</td>\n",
       "      <td>29.3080</td>\n",
       "      <td>16.334</td>\n",
       "      <td>28.932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1098603445</td>\n",
       "      <td>74.4896</td>\n",
       "      <td>27.0896</td>\n",
       "      <td>15.000</td>\n",
       "      <td>32.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>63511924</td>\n",
       "      <td>74.3748</td>\n",
       "      <td>28.3768</td>\n",
       "      <td>16.666</td>\n",
       "      <td>29.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1098649274</td>\n",
       "      <td>73.4988</td>\n",
       "      <td>24.4968</td>\n",
       "      <td>16.334</td>\n",
       "      <td>32.668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1098635329</td>\n",
       "      <td>73.2080</td>\n",
       "      <td>26.6740</td>\n",
       "      <td>15.334</td>\n",
       "      <td>31.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>91159510</td>\n",
       "      <td>72.9028</td>\n",
       "      <td>25.2368</td>\n",
       "      <td>16.334</td>\n",
       "      <td>31.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>91241521</td>\n",
       "      <td>72.7320</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>15.000</td>\n",
       "      <td>25.732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>8678080</td>\n",
       "      <td>72.3340</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>9.666</td>\n",
       "      <td>30.668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>91538394</td>\n",
       "      <td>71.6400</td>\n",
       "      <td>26.9740</td>\n",
       "      <td>12.666</td>\n",
       "      <td>32.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>63354984</td>\n",
       "      <td>71.5500</td>\n",
       "      <td>27.6840</td>\n",
       "      <td>12.666</td>\n",
       "      <td>31.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1098670142</td>\n",
       "      <td>71.2528</td>\n",
       "      <td>23.9868</td>\n",
       "      <td>14.334</td>\n",
       "      <td>32.932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5622430</td>\n",
       "      <td>70.9156</td>\n",
       "      <td>24.3816</td>\n",
       "      <td>13.334</td>\n",
       "      <td>33.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>13956532</td>\n",
       "      <td>70.1936</td>\n",
       "      <td>24.2596</td>\n",
       "      <td>16.334</td>\n",
       "      <td>29.600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>91242913</td>\n",
       "      <td>69.6412</td>\n",
       "      <td>23.1752</td>\n",
       "      <td>14.334</td>\n",
       "      <td>32.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>88030156</td>\n",
       "      <td>69.0768</td>\n",
       "      <td>22.6788</td>\n",
       "      <td>14.666</td>\n",
       "      <td>31.732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1098652669</td>\n",
       "      <td>68.8748</td>\n",
       "      <td>25.2768</td>\n",
       "      <td>12.666</td>\n",
       "      <td>30.932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>37548548</td>\n",
       "      <td>68.7836</td>\n",
       "      <td>23.2496</td>\n",
       "      <td>14.334</td>\n",
       "      <td>31.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>91222328</td>\n",
       "      <td>68.5388</td>\n",
       "      <td>25.4068</td>\n",
       "      <td>15.000</td>\n",
       "      <td>28.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>13465771</td>\n",
       "      <td>68.5340</td>\n",
       "      <td>32.8000</td>\n",
       "      <td>12.666</td>\n",
       "      <td>23.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1098725244</td>\n",
       "      <td>68.3360</td>\n",
       "      <td>22.3360</td>\n",
       "      <td>14.000</td>\n",
       "      <td>32.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>13740054</td>\n",
       "      <td>68.0104</td>\n",
       "      <td>25.8084</td>\n",
       "      <td>12.334</td>\n",
       "      <td>29.868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>91472753</td>\n",
       "      <td>67.6924</td>\n",
       "      <td>31.5584</td>\n",
       "      <td>14.666</td>\n",
       "      <td>21.468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>91476285</td>\n",
       "      <td>67.5920</td>\n",
       "      <td>30.9940</td>\n",
       "      <td>13.666</td>\n",
       "      <td>22.932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>91479901</td>\n",
       "      <td>67.4376</td>\n",
       "      <td>25.8376</td>\n",
       "      <td>12.000</td>\n",
       "      <td>29.600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>91297969</td>\n",
       "      <td>67.2764</td>\n",
       "      <td>24.8764</td>\n",
       "      <td>14.000</td>\n",
       "      <td>28.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>91264734</td>\n",
       "      <td>67.1340</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>14.334</td>\n",
       "      <td>20.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>13516138</td>\n",
       "      <td>67.0672</td>\n",
       "      <td>22.3332</td>\n",
       "      <td>14.334</td>\n",
       "      <td>30.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>13957933</td>\n",
       "      <td>67.0496</td>\n",
       "      <td>26.8476</td>\n",
       "      <td>12.334</td>\n",
       "      <td>27.868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>91517000</td>\n",
       "      <td>66.9088</td>\n",
       "      <td>18.5088</td>\n",
       "      <td>14.000</td>\n",
       "      <td>34.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1095932710</td>\n",
       "      <td>66.6816</td>\n",
       "      <td>21.7476</td>\n",
       "      <td>15.334</td>\n",
       "      <td>29.600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>37727082</td>\n",
       "      <td>66.6624</td>\n",
       "      <td>20.9944</td>\n",
       "      <td>13.000</td>\n",
       "      <td>32.668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>63532509</td>\n",
       "      <td>66.6124</td>\n",
       "      <td>19.3444</td>\n",
       "      <td>15.000</td>\n",
       "      <td>32.268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>91254270</td>\n",
       "      <td>66.5980</td>\n",
       "      <td>28.0000</td>\n",
       "      <td>9.666</td>\n",
       "      <td>28.932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1098635446</td>\n",
       "      <td>66.4936</td>\n",
       "      <td>24.5596</td>\n",
       "      <td>14.334</td>\n",
       "      <td>27.600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>75105514</td>\n",
       "      <td>66.4500</td>\n",
       "      <td>21.7160</td>\n",
       "      <td>13.666</td>\n",
       "      <td>31.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>91541184</td>\n",
       "      <td>66.3812</td>\n",
       "      <td>17.3132</td>\n",
       "      <td>16.000</td>\n",
       "      <td>33.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>91183047</td>\n",
       "      <td>66.0724</td>\n",
       "      <td>23.2044</td>\n",
       "      <td>13.000</td>\n",
       "      <td>29.868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1098727350</td>\n",
       "      <td>65.7580</td>\n",
       "      <td>22.3580</td>\n",
       "      <td>15.000</td>\n",
       "      <td>28.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>37840056</td>\n",
       "      <td>65.0208</td>\n",
       "      <td>26.4888</td>\n",
       "      <td>8.000</td>\n",
       "      <td>30.532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>13747270</td>\n",
       "      <td>64.7256</td>\n",
       "      <td>18.1916</td>\n",
       "      <td>14.666</td>\n",
       "      <td>31.868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>63546268</td>\n",
       "      <td>64.5956</td>\n",
       "      <td>20.7296</td>\n",
       "      <td>12.666</td>\n",
       "      <td>31.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>63498067</td>\n",
       "      <td>64.4844</td>\n",
       "      <td>19.4844</td>\n",
       "      <td>13.000</td>\n",
       "      <td>32.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>1095822478</td>\n",
       "      <td>64.1756</td>\n",
       "      <td>14.3756</td>\n",
       "      <td>17.000</td>\n",
       "      <td>32.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>63510407</td>\n",
       "      <td>64.1516</td>\n",
       "      <td>24.8196</td>\n",
       "      <td>14.000</td>\n",
       "      <td>25.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>13716299</td>\n",
       "      <td>63.8752</td>\n",
       "      <td>32.0772</td>\n",
       "      <td>3.666</td>\n",
       "      <td>28.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>13749120</td>\n",
       "      <td>63.8520</td>\n",
       "      <td>22.4500</td>\n",
       "      <td>10.334</td>\n",
       "      <td>31.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>63507533</td>\n",
       "      <td>63.3740</td>\n",
       "      <td>18.0400</td>\n",
       "      <td>14.666</td>\n",
       "      <td>30.668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>1098669880</td>\n",
       "      <td>63.2364</td>\n",
       "      <td>21.5704</td>\n",
       "      <td>14.334</td>\n",
       "      <td>27.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>19202966</td>\n",
       "      <td>63.2000</td>\n",
       "      <td>29.6000</td>\n",
       "      <td>14.000</td>\n",
       "      <td>19.600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>91515163</td>\n",
       "      <td>63.0464</td>\n",
       "      <td>25.5804</td>\n",
       "      <td>13.334</td>\n",
       "      <td>24.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>37933266</td>\n",
       "      <td>62.9108</td>\n",
       "      <td>21.3768</td>\n",
       "      <td>11.666</td>\n",
       "      <td>29.868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>1098674727</td>\n",
       "      <td>62.6560</td>\n",
       "      <td>16.7220</td>\n",
       "      <td>13.666</td>\n",
       "      <td>32.268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>63550823</td>\n",
       "      <td>62.2612</td>\n",
       "      <td>16.7932</td>\n",
       "      <td>16.000</td>\n",
       "      <td>29.468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>91185455</td>\n",
       "      <td>61.8200</td>\n",
       "      <td>16.9540</td>\n",
       "      <td>13.666</td>\n",
       "      <td>31.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>88239656</td>\n",
       "      <td>61.7672</td>\n",
       "      <td>16.3012</td>\n",
       "      <td>14.666</td>\n",
       "      <td>30.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1143369873</td>\n",
       "      <td>61.5856</td>\n",
       "      <td>17.8516</td>\n",
       "      <td>13.334</td>\n",
       "      <td>30.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>91536552</td>\n",
       "      <td>61.3276</td>\n",
       "      <td>22.9276</td>\n",
       "      <td>14.000</td>\n",
       "      <td>24.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>13847900</td>\n",
       "      <td>60.9332</td>\n",
       "      <td>20.0672</td>\n",
       "      <td>14.334</td>\n",
       "      <td>26.532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>77192317</td>\n",
       "      <td>60.5644</td>\n",
       "      <td>13.0324</td>\n",
       "      <td>15.000</td>\n",
       "      <td>32.532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>1095806179</td>\n",
       "      <td>60.4888</td>\n",
       "      <td>19.0208</td>\n",
       "      <td>12.000</td>\n",
       "      <td>29.468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>1098755264</td>\n",
       "      <td>60.3220</td>\n",
       "      <td>11.2540</td>\n",
       "      <td>16.000</td>\n",
       "      <td>33.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>60260984</td>\n",
       "      <td>60.2580</td>\n",
       "      <td>16.5240</td>\n",
       "      <td>13.334</td>\n",
       "      <td>30.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>91275647</td>\n",
       "      <td>60.0680</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>13.000</td>\n",
       "      <td>15.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>13719373</td>\n",
       "      <td>58.2352</td>\n",
       "      <td>19.2352</td>\n",
       "      <td>15.000</td>\n",
       "      <td>24.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>37558777</td>\n",
       "      <td>57.5752</td>\n",
       "      <td>23.3752</td>\n",
       "      <td>15.000</td>\n",
       "      <td>19.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>1095923854</td>\n",
       "      <td>56.9396</td>\n",
       "      <td>15.5376</td>\n",
       "      <td>12.334</td>\n",
       "      <td>29.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>91429425</td>\n",
       "      <td>56.7476</td>\n",
       "      <td>24.0136</td>\n",
       "      <td>13.666</td>\n",
       "      <td>19.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>63550752</td>\n",
       "      <td>56.5060</td>\n",
       "      <td>19.7740</td>\n",
       "      <td>13.000</td>\n",
       "      <td>23.732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>1098705285</td>\n",
       "      <td>55.5272</td>\n",
       "      <td>17.3272</td>\n",
       "      <td>17.000</td>\n",
       "      <td>21.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>13723457</td>\n",
       "      <td>55.3148</td>\n",
       "      <td>21.5128</td>\n",
       "      <td>14.334</td>\n",
       "      <td>19.468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1095790157</td>\n",
       "      <td>54.9572</td>\n",
       "      <td>13.8252</td>\n",
       "      <td>13.000</td>\n",
       "      <td>28.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>91111869</td>\n",
       "      <td>54.8372</td>\n",
       "      <td>17.4372</td>\n",
       "      <td>9.000</td>\n",
       "      <td>28.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>63536498</td>\n",
       "      <td>54.5088</td>\n",
       "      <td>20.3748</td>\n",
       "      <td>12.666</td>\n",
       "      <td>21.468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>28393300</td>\n",
       "      <td>54.0888</td>\n",
       "      <td>24.6888</td>\n",
       "      <td>11.000</td>\n",
       "      <td>18.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>72288606</td>\n",
       "      <td>54.0344</td>\n",
       "      <td>20.4344</td>\n",
       "      <td>12.000</td>\n",
       "      <td>21.600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>1098772750</td>\n",
       "      <td>52.9248</td>\n",
       "      <td>11.1248</td>\n",
       "      <td>13.000</td>\n",
       "      <td>28.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1095818612</td>\n",
       "      <td>51.0072</td>\n",
       "      <td>16.4732</td>\n",
       "      <td>11.334</td>\n",
       "      <td>23.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>91237800</td>\n",
       "      <td>50.7788</td>\n",
       "      <td>31.3768</td>\n",
       "      <td>10.334</td>\n",
       "      <td>9.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>91244661</td>\n",
       "      <td>50.7700</td>\n",
       "      <td>19.3040</td>\n",
       "      <td>11.334</td>\n",
       "      <td>20.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>91531901</td>\n",
       "      <td>46.2372</td>\n",
       "      <td>16.5712</td>\n",
       "      <td>12.334</td>\n",
       "      <td>17.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>1095937416</td>\n",
       "      <td>37.9252</td>\n",
       "      <td>11.3232</td>\n",
       "      <td>14.334</td>\n",
       "      <td>12.268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>91542098</td>\n",
       "      <td>23.6532</td>\n",
       "      <td>23.6532</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>78691143</td>\n",
       "      <td>22.5616</td>\n",
       "      <td>22.5616</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>13870951</td>\n",
       "      <td>22.2316</td>\n",
       "      <td>22.2316</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>91530525</td>\n",
       "      <td>20.9196</td>\n",
       "      <td>20.9196</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>91488595</td>\n",
       "      <td>18.0404</td>\n",
       "      <td>18.0404</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1098734230</td>\n",
       "      <td>16.3720</td>\n",
       "      <td>16.3720</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>1101755626</td>\n",
       "      <td>14.9684</td>\n",
       "      <td>14.9684</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>91076334</td>\n",
       "      <td>11.9612</td>\n",
       "      <td>11.9612</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>1098679890</td>\n",
       "      <td>10.6792</td>\n",
       "      <td>10.6792</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>1052405562</td>\n",
       "      <td>10.1680</td>\n",
       "      <td>10.1680</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>88033083</td>\n",
       "      <td>9.3832</td>\n",
       "      <td>9.3832</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     National ID  Total score (/100)  CV sore (/40)  Test 1 score (/20)  \\\n",
       "Rank                                                                      \n",
       "1       91485661             83.5104        33.7104              15.000   \n",
       "2       91228781             82.7340        38.0000              14.334   \n",
       "3       23181732             78.1916        34.4576              13.334   \n",
       "4       13706489             77.3980        32.0000              15.666   \n",
       "5       63490103             76.5340        29.6000              15.334   \n",
       "6       63509285             76.4752        29.9432              14.000   \n",
       "7       91420169             76.3340        32.0000              13.666   \n",
       "8       91487046             76.1556        30.0236              14.000   \n",
       "9       91281598             76.0940        28.1600              15.666   \n",
       "10      63507562             74.5740        29.3080              16.334   \n",
       "11    1098603445             74.4896        27.0896              15.000   \n",
       "12      63511924             74.3748        28.3768              16.666   \n",
       "13    1098649274             73.4988        24.4968              16.334   \n",
       "14    1098635329             73.2080        26.6740              15.334   \n",
       "15      91159510             72.9028        25.2368              16.334   \n",
       "16      91241521             72.7320        32.0000              15.000   \n",
       "17       8678080             72.3340        32.0000               9.666   \n",
       "18      91538394             71.6400        26.9740              12.666   \n",
       "19      63354984             71.5500        27.6840              12.666   \n",
       "20    1098670142             71.2528        23.9868              14.334   \n",
       "21       5622430             70.9156        24.3816              13.334   \n",
       "22      13956532             70.1936        24.2596              16.334   \n",
       "23      91242913             69.6412        23.1752              14.334   \n",
       "24      88030156             69.0768        22.6788              14.666   \n",
       "25    1098652669             68.8748        25.2768              12.666   \n",
       "26      37548548             68.7836        23.2496              14.334   \n",
       "27      91222328             68.5388        25.4068              15.000   \n",
       "28      13465771             68.5340        32.8000              12.666   \n",
       "29    1098725244             68.3360        22.3360              14.000   \n",
       "30      13740054             68.0104        25.8084              12.334   \n",
       "31      91472753             67.6924        31.5584              14.666   \n",
       "32      91476285             67.5920        30.9940              13.666   \n",
       "33      91479901             67.4376        25.8376              12.000   \n",
       "34      91297969             67.2764        24.8764              14.000   \n",
       "35      91264734             67.1340        32.0000              14.334   \n",
       "36      13516138             67.0672        22.3332              14.334   \n",
       "37      13957933             67.0496        26.8476              12.334   \n",
       "38      91517000             66.9088        18.5088              14.000   \n",
       "39    1095932710             66.6816        21.7476              15.334   \n",
       "40      37727082             66.6624        20.9944              13.000   \n",
       "41      63532509             66.6124        19.3444              15.000   \n",
       "42      91254270             66.5980        28.0000               9.666   \n",
       "43    1098635446             66.4936        24.5596              14.334   \n",
       "44      75105514             66.4500        21.7160              13.666   \n",
       "45      91541184             66.3812        17.3132              16.000   \n",
       "46      91183047             66.0724        23.2044              13.000   \n",
       "47    1098727350             65.7580        22.3580              15.000   \n",
       "48      37840056             65.0208        26.4888               8.000   \n",
       "49      13747270             64.7256        18.1916              14.666   \n",
       "50      63546268             64.5956        20.7296              12.666   \n",
       "51      63498067             64.4844        19.4844              13.000   \n",
       "52    1095822478             64.1756        14.3756              17.000   \n",
       "53      63510407             64.1516        24.8196              14.000   \n",
       "54      13716299             63.8752        32.0772               3.666   \n",
       "55      13749120             63.8520        22.4500              10.334   \n",
       "56      63507533             63.3740        18.0400              14.666   \n",
       "57    1098669880             63.2364        21.5704              14.334   \n",
       "58      19202966             63.2000        29.6000              14.000   \n",
       "59      91515163             63.0464        25.5804              13.334   \n",
       "60      37933266             62.9108        21.3768              11.666   \n",
       "61    1098674727             62.6560        16.7220              13.666   \n",
       "62      63550823             62.2612        16.7932              16.000   \n",
       "63      91185455             61.8200        16.9540              13.666   \n",
       "64      88239656             61.7672        16.3012              14.666   \n",
       "65    1143369873             61.5856        17.8516              13.334   \n",
       "66      91536552             61.3276        22.9276              14.000   \n",
       "67      13847900             60.9332        20.0672              14.334   \n",
       "68      77192317             60.5644        13.0324              15.000   \n",
       "69    1095806179             60.4888        19.0208              12.000   \n",
       "70    1098755264             60.3220        11.2540              16.000   \n",
       "71      60260984             60.2580        16.5240              13.334   \n",
       "72      91275647             60.0680        32.0000              13.000   \n",
       "73      13719373             58.2352        19.2352              15.000   \n",
       "74      37558777             57.5752        23.3752              15.000   \n",
       "75    1095923854             56.9396        15.5376              12.334   \n",
       "76      91429425             56.7476        24.0136              13.666   \n",
       "77      63550752             56.5060        19.7740              13.000   \n",
       "78    1098705285             55.5272        17.3272              17.000   \n",
       "79      13723457             55.3148        21.5128              14.334   \n",
       "80    1095790157             54.9572        13.8252              13.000   \n",
       "81      91111869             54.8372        17.4372               9.000   \n",
       "82      63536498             54.5088        20.3748              12.666   \n",
       "83      28393300             54.0888        24.6888              11.000   \n",
       "84      72288606             54.0344        20.4344              12.000   \n",
       "85    1098772750             52.9248        11.1248              13.000   \n",
       "86    1095818612             51.0072        16.4732              11.334   \n",
       "87      91237800             50.7788        31.3768              10.334   \n",
       "88      91244661             50.7700        19.3040              11.334   \n",
       "89      91531901             46.2372        16.5712              12.334   \n",
       "90    1095937416             37.9252        11.3232              14.334   \n",
       "91      91542098             23.6532        23.6532               0.000   \n",
       "92      78691143             22.5616        22.5616               0.000   \n",
       "93      13870951             22.2316        22.2316               0.000   \n",
       "94      91530525             20.9196        20.9196               0.000   \n",
       "95      91488595             18.0404        18.0404               0.000   \n",
       "96    1098734230             16.3720        16.3720               0.000   \n",
       "97    1101755626             14.9684        14.9684               0.000   \n",
       "98      91076334             11.9612        11.9612               0.000   \n",
       "99    1098679890             10.6792        10.6792               0.000   \n",
       "100   1052405562             10.1680        10.1680               0.000   \n",
       "101     88033083              9.3832         9.3832               0.000   \n",
       "\n",
       "      Test 2 score (/40)  \n",
       "Rank                      \n",
       "1                 34.800  \n",
       "2                 30.400  \n",
       "3                 30.400  \n",
       "4                 29.732  \n",
       "5                 31.600  \n",
       "6                 32.532  \n",
       "7                 30.668  \n",
       "8                 32.132  \n",
       "9                 32.268  \n",
       "10                28.932  \n",
       "11                32.400  \n",
       "12                29.332  \n",
       "13                32.668  \n",
       "14                31.200  \n",
       "15                31.332  \n",
       "16                25.732  \n",
       "17                30.668  \n",
       "18                32.000  \n",
       "19                31.200  \n",
       "20                32.932  \n",
       "21                33.200  \n",
       "22                29.600  \n",
       "23                32.132  \n",
       "24                31.732  \n",
       "25                30.932  \n",
       "26                31.200  \n",
       "27                28.132  \n",
       "28                23.068  \n",
       "29                32.000  \n",
       "30                29.868  \n",
       "31                21.468  \n",
       "32                22.932  \n",
       "33                29.600  \n",
       "34                28.400  \n",
       "35                20.800  \n",
       "36                30.400  \n",
       "37                27.868  \n",
       "38                34.400  \n",
       "39                29.600  \n",
       "40                32.668  \n",
       "41                32.268  \n",
       "42                28.932  \n",
       "43                27.600  \n",
       "44                31.068  \n",
       "45                33.068  \n",
       "46                29.868  \n",
       "47                28.400  \n",
       "48                30.532  \n",
       "49                31.868  \n",
       "50                31.200  \n",
       "51                32.000  \n",
       "52                32.800  \n",
       "53                25.332  \n",
       "54                28.132  \n",
       "55                31.068  \n",
       "56                30.668  \n",
       "57                27.332  \n",
       "58                19.600  \n",
       "59                24.132  \n",
       "60                29.868  \n",
       "61                32.268  \n",
       "62                29.468  \n",
       "63                31.200  \n",
       "64                30.800  \n",
       "65                30.400  \n",
       "66                24.400  \n",
       "67                26.532  \n",
       "68                32.532  \n",
       "69                29.468  \n",
       "70                33.068  \n",
       "71                30.400  \n",
       "72                15.068  \n",
       "73                24.000  \n",
       "74                19.200  \n",
       "75                29.068  \n",
       "76                19.068  \n",
       "77                23.732  \n",
       "78                21.200  \n",
       "79                19.468  \n",
       "80                28.132  \n",
       "81                28.400  \n",
       "82                21.468  \n",
       "83                18.400  \n",
       "84                21.600  \n",
       "85                28.800  \n",
       "86                23.200  \n",
       "87                 9.068  \n",
       "88                20.132  \n",
       "89                17.332  \n",
       "90                12.268  \n",
       "91                 0.000  \n",
       "92                 0.000  \n",
       "93                 0.000  \n",
       "94                 0.000  \n",
       "95                 0.000  \n",
       "96                 0.000  \n",
       "97                 0.000  \n",
       "98                 0.000  \n",
       "99                 0.000  \n",
       "100                0.000  \n",
       "101                0.000  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "scores_by_total = scores_df.sort_values(by=scores_df_columns[0], ascending=False).reset_index(level=0)\n",
    "scores_by_total.index = scores_by_total.index.set_names([\"Rank\"]) + 1\n",
    "scores_by_total"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4902938b",
   "metadata": {},
   "source": [
    "#### Puntaje hoja de vida\n",
    "\n",
    "Resultados organizados por puntaje en la hoja de vida."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "c8eb9223",
   "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>National ID</th>\n",
       "      <th>CV sore (/40)</th>\n",
       "      <th>CV sore (/100)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>91228781</td>\n",
       "      <td>38.0000</td>\n",
       "      <td>95.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23181732</td>\n",
       "      <td>34.4576</td>\n",
       "      <td>86.144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>91485661</td>\n",
       "      <td>33.7104</td>\n",
       "      <td>84.276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13465771</td>\n",
       "      <td>32.8000</td>\n",
       "      <td>82.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>13716299</td>\n",
       "      <td>32.0772</td>\n",
       "      <td>80.193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>91264734</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>80.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>91275647</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>80.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>91420169</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>80.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>91241521</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>80.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>13706489</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>80.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>8678080</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>80.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>91472753</td>\n",
       "      <td>31.5584</td>\n",
       "      <td>78.896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>91237800</td>\n",
       "      <td>31.3768</td>\n",
       "      <td>78.442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>91476285</td>\n",
       "      <td>30.9940</td>\n",
       "      <td>77.485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>91487046</td>\n",
       "      <td>30.0236</td>\n",
       "      <td>75.059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>63509285</td>\n",
       "      <td>29.9432</td>\n",
       "      <td>74.858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>63490103</td>\n",
       "      <td>29.6000</td>\n",
       "      <td>74.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19202966</td>\n",
       "      <td>29.6000</td>\n",
       "      <td>74.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>63507562</td>\n",
       "      <td>29.3080</td>\n",
       "      <td>73.270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>63511924</td>\n",
       "      <td>28.3768</td>\n",
       "      <td>70.942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>91281598</td>\n",
       "      <td>28.1600</td>\n",
       "      <td>70.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>91254270</td>\n",
       "      <td>28.0000</td>\n",
       "      <td>70.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>63354984</td>\n",
       "      <td>27.6840</td>\n",
       "      <td>69.210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1098603445</td>\n",
       "      <td>27.0896</td>\n",
       "      <td>67.724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>91538394</td>\n",
       "      <td>26.9740</td>\n",
       "      <td>67.435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>13957933</td>\n",
       "      <td>26.8476</td>\n",
       "      <td>67.119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1098635329</td>\n",
       "      <td>26.6740</td>\n",
       "      <td>66.685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>37840056</td>\n",
       "      <td>26.4888</td>\n",
       "      <td>66.222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>91479901</td>\n",
       "      <td>25.8376</td>\n",
       "      <td>64.594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>13740054</td>\n",
       "      <td>25.8084</td>\n",
       "      <td>64.521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>91515163</td>\n",
       "      <td>25.5804</td>\n",
       "      <td>63.951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>91222328</td>\n",
       "      <td>25.4068</td>\n",
       "      <td>63.517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1098652669</td>\n",
       "      <td>25.2768</td>\n",
       "      <td>63.192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>91159510</td>\n",
       "      <td>25.2368</td>\n",
       "      <td>63.092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>91297969</td>\n",
       "      <td>24.8764</td>\n",
       "      <td>62.191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>63510407</td>\n",
       "      <td>24.8196</td>\n",
       "      <td>62.049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>28393300</td>\n",
       "      <td>24.6888</td>\n",
       "      <td>61.722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1098635446</td>\n",
       "      <td>24.5596</td>\n",
       "      <td>61.399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1098649274</td>\n",
       "      <td>24.4968</td>\n",
       "      <td>61.242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>5622430</td>\n",
       "      <td>24.3816</td>\n",
       "      <td>60.954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>13956532</td>\n",
       "      <td>24.2596</td>\n",
       "      <td>60.649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>91429425</td>\n",
       "      <td>24.0136</td>\n",
       "      <td>60.034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1098670142</td>\n",
       "      <td>23.9868</td>\n",
       "      <td>59.967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>91542098</td>\n",
       "      <td>23.6532</td>\n",
       "      <td>59.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>37558777</td>\n",
       "      <td>23.3752</td>\n",
       "      <td>58.438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>37548548</td>\n",
       "      <td>23.2496</td>\n",
       "      <td>58.124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>91183047</td>\n",
       "      <td>23.2044</td>\n",
       "      <td>58.011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>91242913</td>\n",
       "      <td>23.1752</td>\n",
       "      <td>57.938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>91536552</td>\n",
       "      <td>22.9276</td>\n",
       "      <td>57.319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>88030156</td>\n",
       "      <td>22.6788</td>\n",
       "      <td>56.697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>78691143</td>\n",
       "      <td>22.5616</td>\n",
       "      <td>56.404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>13749120</td>\n",
       "      <td>22.4500</td>\n",
       "      <td>56.125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1098727350</td>\n",
       "      <td>22.3580</td>\n",
       "      <td>55.895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1098725244</td>\n",
       "      <td>22.3360</td>\n",
       "      <td>55.840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>13516138</td>\n",
       "      <td>22.3332</td>\n",
       "      <td>55.833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>13870951</td>\n",
       "      <td>22.2316</td>\n",
       "      <td>55.579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>1095932710</td>\n",
       "      <td>21.7476</td>\n",
       "      <td>54.369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>75105514</td>\n",
       "      <td>21.7160</td>\n",
       "      <td>54.290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>1098669880</td>\n",
       "      <td>21.5704</td>\n",
       "      <td>53.926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>13723457</td>\n",
       "      <td>21.5128</td>\n",
       "      <td>53.782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>37933266</td>\n",
       "      <td>21.3768</td>\n",
       "      <td>53.442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>37727082</td>\n",
       "      <td>20.9944</td>\n",
       "      <td>52.486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>91530525</td>\n",
       "      <td>20.9196</td>\n",
       "      <td>52.299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>63546268</td>\n",
       "      <td>20.7296</td>\n",
       "      <td>51.824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>72288606</td>\n",
       "      <td>20.4344</td>\n",
       "      <td>51.086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>63536498</td>\n",
       "      <td>20.3748</td>\n",
       "      <td>50.937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>13847900</td>\n",
       "      <td>20.0672</td>\n",
       "      <td>50.168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>63550752</td>\n",
       "      <td>19.7740</td>\n",
       "      <td>49.435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>63498067</td>\n",
       "      <td>19.4844</td>\n",
       "      <td>48.711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>63532509</td>\n",
       "      <td>19.3444</td>\n",
       "      <td>48.361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>91244661</td>\n",
       "      <td>19.3040</td>\n",
       "      <td>48.260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>13719373</td>\n",
       "      <td>19.2352</td>\n",
       "      <td>48.088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>1095806179</td>\n",
       "      <td>19.0208</td>\n",
       "      <td>47.552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>91517000</td>\n",
       "      <td>18.5088</td>\n",
       "      <td>46.272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>13747270</td>\n",
       "      <td>18.1916</td>\n",
       "      <td>45.479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>91488595</td>\n",
       "      <td>18.0404</td>\n",
       "      <td>45.101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>63507533</td>\n",
       "      <td>18.0400</td>\n",
       "      <td>45.100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>1143369873</td>\n",
       "      <td>17.8516</td>\n",
       "      <td>44.629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>91111869</td>\n",
       "      <td>17.4372</td>\n",
       "      <td>43.593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1098705285</td>\n",
       "      <td>17.3272</td>\n",
       "      <td>43.318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>91541184</td>\n",
       "      <td>17.3132</td>\n",
       "      <td>43.283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>91185455</td>\n",
       "      <td>16.9540</td>\n",
       "      <td>42.385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>63550823</td>\n",
       "      <td>16.7932</td>\n",
       "      <td>41.983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1098674727</td>\n",
       "      <td>16.7220</td>\n",
       "      <td>41.805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>91531901</td>\n",
       "      <td>16.5712</td>\n",
       "      <td>41.428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>60260984</td>\n",
       "      <td>16.5240</td>\n",
       "      <td>41.310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>1095818612</td>\n",
       "      <td>16.4732</td>\n",
       "      <td>41.183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>1098734230</td>\n",
       "      <td>16.3720</td>\n",
       "      <td>40.930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>88239656</td>\n",
       "      <td>16.3012</td>\n",
       "      <td>40.753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>1095923854</td>\n",
       "      <td>15.5376</td>\n",
       "      <td>38.844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>1101755626</td>\n",
       "      <td>14.9684</td>\n",
       "      <td>37.421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1095822478</td>\n",
       "      <td>14.3756</td>\n",
       "      <td>35.939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1095790157</td>\n",
       "      <td>13.8252</td>\n",
       "      <td>34.563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>77192317</td>\n",
       "      <td>13.0324</td>\n",
       "      <td>32.581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>91076334</td>\n",
       "      <td>11.9612</td>\n",
       "      <td>29.903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1095937416</td>\n",
       "      <td>11.3232</td>\n",
       "      <td>28.308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>1098755264</td>\n",
       "      <td>11.2540</td>\n",
       "      <td>28.135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>1098772750</td>\n",
       "      <td>11.1248</td>\n",
       "      <td>27.812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>1098679890</td>\n",
       "      <td>10.6792</td>\n",
       "      <td>26.698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>1052405562</td>\n",
       "      <td>10.1680</td>\n",
       "      <td>25.420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>88033083</td>\n",
       "      <td>9.3832</td>\n",
       "      <td>23.458</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     National ID  CV sore (/40)  CV sore (/100)\n",
       "Rank                                           \n",
       "1       91228781        38.0000          95.000\n",
       "2       23181732        34.4576          86.144\n",
       "3       91485661        33.7104          84.276\n",
       "4       13465771        32.8000          82.000\n",
       "5       13716299        32.0772          80.193\n",
       "6       91264734        32.0000          80.000\n",
       "7       91275647        32.0000          80.000\n",
       "8       91420169        32.0000          80.000\n",
       "9       91241521        32.0000          80.000\n",
       "10      13706489        32.0000          80.000\n",
       "11       8678080        32.0000          80.000\n",
       "12      91472753        31.5584          78.896\n",
       "13      91237800        31.3768          78.442\n",
       "14      91476285        30.9940          77.485\n",
       "15      91487046        30.0236          75.059\n",
       "16      63509285        29.9432          74.858\n",
       "17      63490103        29.6000          74.000\n",
       "18      19202966        29.6000          74.000\n",
       "19      63507562        29.3080          73.270\n",
       "20      63511924        28.3768          70.942\n",
       "21      91281598        28.1600          70.400\n",
       "22      91254270        28.0000          70.000\n",
       "23      63354984        27.6840          69.210\n",
       "24    1098603445        27.0896          67.724\n",
       "25      91538394        26.9740          67.435\n",
       "26      13957933        26.8476          67.119\n",
       "27    1098635329        26.6740          66.685\n",
       "28      37840056        26.4888          66.222\n",
       "29      91479901        25.8376          64.594\n",
       "30      13740054        25.8084          64.521\n",
       "31      91515163        25.5804          63.951\n",
       "32      91222328        25.4068          63.517\n",
       "33    1098652669        25.2768          63.192\n",
       "34      91159510        25.2368          63.092\n",
       "35      91297969        24.8764          62.191\n",
       "36      63510407        24.8196          62.049\n",
       "37      28393300        24.6888          61.722\n",
       "38    1098635446        24.5596          61.399\n",
       "39    1098649274        24.4968          61.242\n",
       "40       5622430        24.3816          60.954\n",
       "41      13956532        24.2596          60.649\n",
       "42      91429425        24.0136          60.034\n",
       "43    1098670142        23.9868          59.967\n",
       "44      91542098        23.6532          59.133\n",
       "45      37558777        23.3752          58.438\n",
       "46      37548548        23.2496          58.124\n",
       "47      91183047        23.2044          58.011\n",
       "48      91242913        23.1752          57.938\n",
       "49      91536552        22.9276          57.319\n",
       "50      88030156        22.6788          56.697\n",
       "51      78691143        22.5616          56.404\n",
       "52      13749120        22.4500          56.125\n",
       "53    1098727350        22.3580          55.895\n",
       "54    1098725244        22.3360          55.840\n",
       "55      13516138        22.3332          55.833\n",
       "56      13870951        22.2316          55.579\n",
       "57    1095932710        21.7476          54.369\n",
       "58      75105514        21.7160          54.290\n",
       "59    1098669880        21.5704          53.926\n",
       "60      13723457        21.5128          53.782\n",
       "61      37933266        21.3768          53.442\n",
       "62      37727082        20.9944          52.486\n",
       "63      91530525        20.9196          52.299\n",
       "64      63546268        20.7296          51.824\n",
       "65      72288606        20.4344          51.086\n",
       "66      63536498        20.3748          50.937\n",
       "67      13847900        20.0672          50.168\n",
       "68      63550752        19.7740          49.435\n",
       "69      63498067        19.4844          48.711\n",
       "70      63532509        19.3444          48.361\n",
       "71      91244661        19.3040          48.260\n",
       "72      13719373        19.2352          48.088\n",
       "73    1095806179        19.0208          47.552\n",
       "74      91517000        18.5088          46.272\n",
       "75      13747270        18.1916          45.479\n",
       "76      91488595        18.0404          45.101\n",
       "77      63507533        18.0400          45.100\n",
       "78    1143369873        17.8516          44.629\n",
       "79      91111869        17.4372          43.593\n",
       "80    1098705285        17.3272          43.318\n",
       "81      91541184        17.3132          43.283\n",
       "82      91185455        16.9540          42.385\n",
       "83      63550823        16.7932          41.983\n",
       "84    1098674727        16.7220          41.805\n",
       "85      91531901        16.5712          41.428\n",
       "86      60260984        16.5240          41.310\n",
       "87    1095818612        16.4732          41.183\n",
       "88    1098734230        16.3720          40.930\n",
       "89      88239656        16.3012          40.753\n",
       "90    1095923854        15.5376          38.844\n",
       "91    1101755626        14.9684          37.421\n",
       "92    1095822478        14.3756          35.939\n",
       "93    1095790157        13.8252          34.563\n",
       "94      77192317        13.0324          32.581\n",
       "95      91076334        11.9612          29.903\n",
       "96    1095937416        11.3232          28.308\n",
       "97    1098755264        11.2540          28.135\n",
       "98    1098772750        11.1248          27.812\n",
       "99    1098679890        10.6792          26.698\n",
       "100   1052405562        10.1680          25.420\n",
       "101     88033083         9.3832          23.458"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "column_cv = scores_df_columns[1]\n",
    "\n",
    "scores_by_cv = sort_by_specific_score(scores_df, column_cv)\n",
    "scores_by_cv"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "260db95c",
   "metadata": {},
   "source": [
    "#### Puntaje prueba de habilidades digitales\n",
    "\n",
    "Resultados organizados por puntaje en la prueba de habilidades digitales. Se presentan dos columnas: una con el puntaje estandarizado y la otra con el puntaje en escala 0 a 100."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "9d622456",
   "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>National ID</th>\n",
       "      <th>Test 1 score (/20)</th>\n",
       "      <th>Test 1 score (/100)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1095822478</td>\n",
       "      <td>17.000</td>\n",
       "      <td>85.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1098705285</td>\n",
       "      <td>17.000</td>\n",
       "      <td>85.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>63511924</td>\n",
       "      <td>16.666</td>\n",
       "      <td>83.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>91159510</td>\n",
       "      <td>16.334</td>\n",
       "      <td>81.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1098649274</td>\n",
       "      <td>16.334</td>\n",
       "      <td>81.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>63507562</td>\n",
       "      <td>16.334</td>\n",
       "      <td>81.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>13956532</td>\n",
       "      <td>16.334</td>\n",
       "      <td>81.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>91541184</td>\n",
       "      <td>16.000</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1098755264</td>\n",
       "      <td>16.000</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>63550823</td>\n",
       "      <td>16.000</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>91281598</td>\n",
       "      <td>15.666</td>\n",
       "      <td>78.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13706489</td>\n",
       "      <td>15.666</td>\n",
       "      <td>78.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>63490103</td>\n",
       "      <td>15.334</td>\n",
       "      <td>76.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1095932710</td>\n",
       "      <td>15.334</td>\n",
       "      <td>76.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1098635329</td>\n",
       "      <td>15.334</td>\n",
       "      <td>76.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1098603445</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>63532509</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>37558777</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>91222328</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>13719373</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>77192317</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>91485661</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1098727350</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>91241521</td>\n",
       "      <td>15.000</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>88030156</td>\n",
       "      <td>14.666</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>88239656</td>\n",
       "      <td>14.666</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>91472753</td>\n",
       "      <td>14.666</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>63507533</td>\n",
       "      <td>14.666</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>13747270</td>\n",
       "      <td>14.666</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>91264734</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1098669880</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>91242913</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>13516138</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>13723457</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>13847900</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1098670142</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37548548</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1098635446</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1095937416</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>91228781</td>\n",
       "      <td>14.334</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>91487046</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>63509285</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>91536552</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1098725244</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>19202966</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>91297969</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>63510407</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>91517000</td>\n",
       "      <td>14.000</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>1098674727</td>\n",
       "      <td>13.666</td>\n",
       "      <td>68.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>91476285</td>\n",
       "      <td>13.666</td>\n",
       "      <td>68.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>91429425</td>\n",
       "      <td>13.666</td>\n",
       "      <td>68.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>91185455</td>\n",
       "      <td>13.666</td>\n",
       "      <td>68.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>91420169</td>\n",
       "      <td>13.666</td>\n",
       "      <td>68.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>75105514</td>\n",
       "      <td>13.666</td>\n",
       "      <td>68.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>91515163</td>\n",
       "      <td>13.334</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>5622430</td>\n",
       "      <td>13.334</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>1143369873</td>\n",
       "      <td>13.334</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>23181732</td>\n",
       "      <td>13.334</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>60260984</td>\n",
       "      <td>13.334</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>91275647</td>\n",
       "      <td>13.000</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>63550752</td>\n",
       "      <td>13.000</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>91183047</td>\n",
       "      <td>13.000</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>1098772750</td>\n",
       "      <td>13.000</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>37727082</td>\n",
       "      <td>13.000</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1095790157</td>\n",
       "      <td>13.000</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>63498067</td>\n",
       "      <td>13.000</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>63536498</td>\n",
       "      <td>12.666</td>\n",
       "      <td>63.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>91538394</td>\n",
       "      <td>12.666</td>\n",
       "      <td>63.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>63546268</td>\n",
       "      <td>12.666</td>\n",
       "      <td>63.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>13465771</td>\n",
       "      <td>12.666</td>\n",
       "      <td>63.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>1098652669</td>\n",
       "      <td>12.666</td>\n",
       "      <td>63.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>63354984</td>\n",
       "      <td>12.666</td>\n",
       "      <td>63.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>1095923854</td>\n",
       "      <td>12.334</td>\n",
       "      <td>61.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>91531901</td>\n",
       "      <td>12.334</td>\n",
       "      <td>61.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>13740054</td>\n",
       "      <td>12.334</td>\n",
       "      <td>61.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>13957933</td>\n",
       "      <td>12.334</td>\n",
       "      <td>61.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>1095806179</td>\n",
       "      <td>12.000</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>72288606</td>\n",
       "      <td>12.000</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>91479901</td>\n",
       "      <td>12.000</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>37933266</td>\n",
       "      <td>11.666</td>\n",
       "      <td>58.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>1095818612</td>\n",
       "      <td>11.334</td>\n",
       "      <td>56.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>91244661</td>\n",
       "      <td>11.334</td>\n",
       "      <td>56.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>28393300</td>\n",
       "      <td>11.000</td>\n",
       "      <td>55.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>13749120</td>\n",
       "      <td>10.334</td>\n",
       "      <td>51.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>91237800</td>\n",
       "      <td>10.334</td>\n",
       "      <td>51.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>91254270</td>\n",
       "      <td>9.666</td>\n",
       "      <td>48.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>8678080</td>\n",
       "      <td>9.666</td>\n",
       "      <td>48.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>91111869</td>\n",
       "      <td>9.000</td>\n",
       "      <td>45.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>37840056</td>\n",
       "      <td>8.000</td>\n",
       "      <td>40.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>13716299</td>\n",
       "      <td>3.666</td>\n",
       "      <td>18.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>1101755626</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1098734230</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1052405562</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>1098679890</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>13870951</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>91542098</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>88033083</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>78691143</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>91488595</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>91530525</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>91076334</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     National ID  Test 1 score (/20)  Test 1 score (/100)\n",
       "Rank                                                     \n",
       "1     1095822478              17.000                85.00\n",
       "2     1098705285              17.000                85.00\n",
       "3       63511924              16.666                83.33\n",
       "4       91159510              16.334                81.67\n",
       "5     1098649274              16.334                81.67\n",
       "6       63507562              16.334                81.67\n",
       "7       13956532              16.334                81.67\n",
       "8       91541184              16.000                80.00\n",
       "9     1098755264              16.000                80.00\n",
       "10      63550823              16.000                80.00\n",
       "11      91281598              15.666                78.33\n",
       "12      13706489              15.666                78.33\n",
       "13      63490103              15.334                76.67\n",
       "14    1095932710              15.334                76.67\n",
       "15    1098635329              15.334                76.67\n",
       "16    1098603445              15.000                75.00\n",
       "17      63532509              15.000                75.00\n",
       "18      37558777              15.000                75.00\n",
       "19      91222328              15.000                75.00\n",
       "20      13719373              15.000                75.00\n",
       "21      77192317              15.000                75.00\n",
       "22      91485661              15.000                75.00\n",
       "23    1098727350              15.000                75.00\n",
       "24      91241521              15.000                75.00\n",
       "25      88030156              14.666                73.33\n",
       "26      88239656              14.666                73.33\n",
       "27      91472753              14.666                73.33\n",
       "28      63507533              14.666                73.33\n",
       "29      13747270              14.666                73.33\n",
       "30      91264734              14.334                71.67\n",
       "31    1098669880              14.334                71.67\n",
       "32      91242913              14.334                71.67\n",
       "33      13516138              14.334                71.67\n",
       "34      13723457              14.334                71.67\n",
       "35      13847900              14.334                71.67\n",
       "36    1098670142              14.334                71.67\n",
       "37      37548548              14.334                71.67\n",
       "38    1098635446              14.334                71.67\n",
       "39    1095937416              14.334                71.67\n",
       "40      91228781              14.334                71.67\n",
       "41      91487046              14.000                70.00\n",
       "42      63509285              14.000                70.00\n",
       "43      91536552              14.000                70.00\n",
       "44    1098725244              14.000                70.00\n",
       "45      19202966              14.000                70.00\n",
       "46      91297969              14.000                70.00\n",
       "47      63510407              14.000                70.00\n",
       "48      91517000              14.000                70.00\n",
       "49    1098674727              13.666                68.33\n",
       "50      91476285              13.666                68.33\n",
       "51      91429425              13.666                68.33\n",
       "52      91185455              13.666                68.33\n",
       "53      91420169              13.666                68.33\n",
       "54      75105514              13.666                68.33\n",
       "55      91515163              13.334                66.67\n",
       "56       5622430              13.334                66.67\n",
       "57    1143369873              13.334                66.67\n",
       "58      23181732              13.334                66.67\n",
       "59      60260984              13.334                66.67\n",
       "60      91275647              13.000                65.00\n",
       "61      63550752              13.000                65.00\n",
       "62      91183047              13.000                65.00\n",
       "63    1098772750              13.000                65.00\n",
       "64      37727082              13.000                65.00\n",
       "65    1095790157              13.000                65.00\n",
       "66      63498067              13.000                65.00\n",
       "67      63536498              12.666                63.33\n",
       "68      91538394              12.666                63.33\n",
       "69      63546268              12.666                63.33\n",
       "70      13465771              12.666                63.33\n",
       "71    1098652669              12.666                63.33\n",
       "72      63354984              12.666                63.33\n",
       "73    1095923854              12.334                61.67\n",
       "74      91531901              12.334                61.67\n",
       "75      13740054              12.334                61.67\n",
       "76      13957933              12.334                61.67\n",
       "77    1095806179              12.000                60.00\n",
       "78      72288606              12.000                60.00\n",
       "79      91479901              12.000                60.00\n",
       "80      37933266              11.666                58.33\n",
       "81    1095818612              11.334                56.67\n",
       "82      91244661              11.334                56.67\n",
       "83      28393300              11.000                55.00\n",
       "84      13749120              10.334                51.67\n",
       "85      91237800              10.334                51.67\n",
       "86      91254270               9.666                48.33\n",
       "87       8678080               9.666                48.33\n",
       "88      91111869               9.000                45.00\n",
       "89      37840056               8.000                40.00\n",
       "90      13716299               3.666                18.33\n",
       "91    1101755626               0.000                 0.00\n",
       "92    1098734230               0.000                 0.00\n",
       "93    1052405562               0.000                 0.00\n",
       "94    1098679890               0.000                 0.00\n",
       "95      13870951               0.000                 0.00\n",
       "96      91542098               0.000                 0.00\n",
       "97      88033083               0.000                 0.00\n",
       "98      78691143               0.000                 0.00\n",
       "99      91488595               0.000                 0.00\n",
       "100     91530525               0.000                 0.00\n",
       "101     91076334               0.000                 0.00"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "column_test_1 = scores_df_columns[2]\n",
    "\n",
    "scores_by_test_1 = sort_by_specific_score(scores_df, column_test_1)\n",
    "scores_by_test_1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d6cec1f9",
   "metadata": {},
   "source": [
    "#### Puntaje prueba de habilidades socioemocionales\n",
    "\n",
    "Resultados organizados por puntaje en la prueba de habilidades socioemocionales. Se presentan dos columnas: una con el puntaje estandarizado y la otra con el puntaje en escala 0 a 100."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "872dff84",
   "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>National ID</th>\n",
       "      <th>Test 2 score (/40)</th>\n",
       "      <th>Test 2 score (/100)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>91485661</td>\n",
       "      <td>34.800</td>\n",
       "      <td>87.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>91517000</td>\n",
       "      <td>34.400</td>\n",
       "      <td>86.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5622430</td>\n",
       "      <td>33.200</td>\n",
       "      <td>83.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1098755264</td>\n",
       "      <td>33.068</td>\n",
       "      <td>82.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>91541184</td>\n",
       "      <td>33.068</td>\n",
       "      <td>82.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1098670142</td>\n",
       "      <td>32.932</td>\n",
       "      <td>82.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1095822478</td>\n",
       "      <td>32.800</td>\n",
       "      <td>82.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>37727082</td>\n",
       "      <td>32.668</td>\n",
       "      <td>81.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1098649274</td>\n",
       "      <td>32.668</td>\n",
       "      <td>81.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>63509285</td>\n",
       "      <td>32.532</td>\n",
       "      <td>81.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>77192317</td>\n",
       "      <td>32.532</td>\n",
       "      <td>81.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1098603445</td>\n",
       "      <td>32.400</td>\n",
       "      <td>81.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>63532509</td>\n",
       "      <td>32.268</td>\n",
       "      <td>80.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1098674727</td>\n",
       "      <td>32.268</td>\n",
       "      <td>80.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>91281598</td>\n",
       "      <td>32.268</td>\n",
       "      <td>80.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>91487046</td>\n",
       "      <td>32.132</td>\n",
       "      <td>80.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>91242913</td>\n",
       "      <td>32.132</td>\n",
       "      <td>80.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>63498067</td>\n",
       "      <td>32.000</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>91538394</td>\n",
       "      <td>32.000</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1098725244</td>\n",
       "      <td>32.000</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>13747270</td>\n",
       "      <td>31.868</td>\n",
       "      <td>79.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>88030156</td>\n",
       "      <td>31.732</td>\n",
       "      <td>79.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>63490103</td>\n",
       "      <td>31.600</td>\n",
       "      <td>79.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>91159510</td>\n",
       "      <td>31.332</td>\n",
       "      <td>78.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>63546268</td>\n",
       "      <td>31.200</td>\n",
       "      <td>78.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>91185455</td>\n",
       "      <td>31.200</td>\n",
       "      <td>78.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>63354984</td>\n",
       "      <td>31.200</td>\n",
       "      <td>78.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1098635329</td>\n",
       "      <td>31.200</td>\n",
       "      <td>78.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>37548548</td>\n",
       "      <td>31.200</td>\n",
       "      <td>78.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>13749120</td>\n",
       "      <td>31.068</td>\n",
       "      <td>77.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>75105514</td>\n",
       "      <td>31.068</td>\n",
       "      <td>77.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1098652669</td>\n",
       "      <td>30.932</td>\n",
       "      <td>77.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>88239656</td>\n",
       "      <td>30.800</td>\n",
       "      <td>77.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>63507533</td>\n",
       "      <td>30.668</td>\n",
       "      <td>76.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>8678080</td>\n",
       "      <td>30.668</td>\n",
       "      <td>76.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>91420169</td>\n",
       "      <td>30.668</td>\n",
       "      <td>76.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37840056</td>\n",
       "      <td>30.532</td>\n",
       "      <td>76.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>91228781</td>\n",
       "      <td>30.400</td>\n",
       "      <td>76.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1143369873</td>\n",
       "      <td>30.400</td>\n",
       "      <td>76.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>23181732</td>\n",
       "      <td>30.400</td>\n",
       "      <td>76.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>13516138</td>\n",
       "      <td>30.400</td>\n",
       "      <td>76.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>60260984</td>\n",
       "      <td>30.400</td>\n",
       "      <td>76.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>13740054</td>\n",
       "      <td>29.868</td>\n",
       "      <td>74.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>37933266</td>\n",
       "      <td>29.868</td>\n",
       "      <td>74.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>91183047</td>\n",
       "      <td>29.868</td>\n",
       "      <td>74.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>13706489</td>\n",
       "      <td>29.732</td>\n",
       "      <td>74.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1095932710</td>\n",
       "      <td>29.600</td>\n",
       "      <td>74.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>91479901</td>\n",
       "      <td>29.600</td>\n",
       "      <td>74.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>13956532</td>\n",
       "      <td>29.600</td>\n",
       "      <td>74.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>1095806179</td>\n",
       "      <td>29.468</td>\n",
       "      <td>73.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>63550823</td>\n",
       "      <td>29.468</td>\n",
       "      <td>73.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>63511924</td>\n",
       "      <td>29.332</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1095923854</td>\n",
       "      <td>29.068</td>\n",
       "      <td>72.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>91254270</td>\n",
       "      <td>28.932</td>\n",
       "      <td>72.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>63507562</td>\n",
       "      <td>28.932</td>\n",
       "      <td>72.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>1098772750</td>\n",
       "      <td>28.800</td>\n",
       "      <td>72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>91111869</td>\n",
       "      <td>28.400</td>\n",
       "      <td>71.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>91297969</td>\n",
       "      <td>28.400</td>\n",
       "      <td>71.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>1098727350</td>\n",
       "      <td>28.400</td>\n",
       "      <td>71.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>91222328</td>\n",
       "      <td>28.132</td>\n",
       "      <td>70.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>13716299</td>\n",
       "      <td>28.132</td>\n",
       "      <td>70.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>1095790157</td>\n",
       "      <td>28.132</td>\n",
       "      <td>70.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>13957933</td>\n",
       "      <td>27.868</td>\n",
       "      <td>69.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>1098635446</td>\n",
       "      <td>27.600</td>\n",
       "      <td>69.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1098669880</td>\n",
       "      <td>27.332</td>\n",
       "      <td>68.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>13847900</td>\n",
       "      <td>26.532</td>\n",
       "      <td>66.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>91241521</td>\n",
       "      <td>25.732</td>\n",
       "      <td>64.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>63510407</td>\n",
       "      <td>25.332</td>\n",
       "      <td>63.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>91536552</td>\n",
       "      <td>24.400</td>\n",
       "      <td>61.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>91515163</td>\n",
       "      <td>24.132</td>\n",
       "      <td>60.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>13719373</td>\n",
       "      <td>24.000</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>63550752</td>\n",
       "      <td>23.732</td>\n",
       "      <td>59.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>1095818612</td>\n",
       "      <td>23.200</td>\n",
       "      <td>58.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>13465771</td>\n",
       "      <td>23.068</td>\n",
       "      <td>57.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>91476285</td>\n",
       "      <td>22.932</td>\n",
       "      <td>57.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>72288606</td>\n",
       "      <td>21.600</td>\n",
       "      <td>54.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>63536498</td>\n",
       "      <td>21.468</td>\n",
       "      <td>53.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>91472753</td>\n",
       "      <td>21.468</td>\n",
       "      <td>53.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>1098705285</td>\n",
       "      <td>21.200</td>\n",
       "      <td>53.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>91264734</td>\n",
       "      <td>20.800</td>\n",
       "      <td>52.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>91244661</td>\n",
       "      <td>20.132</td>\n",
       "      <td>50.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>19202966</td>\n",
       "      <td>19.600</td>\n",
       "      <td>49.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>13723457</td>\n",
       "      <td>19.468</td>\n",
       "      <td>48.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>37558777</td>\n",
       "      <td>19.200</td>\n",
       "      <td>48.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>91429425</td>\n",
       "      <td>19.068</td>\n",
       "      <td>47.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>28393300</td>\n",
       "      <td>18.400</td>\n",
       "      <td>46.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>91531901</td>\n",
       "      <td>17.332</td>\n",
       "      <td>43.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>91275647</td>\n",
       "      <td>15.068</td>\n",
       "      <td>37.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>1095937416</td>\n",
       "      <td>12.268</td>\n",
       "      <td>30.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>91237800</td>\n",
       "      <td>9.068</td>\n",
       "      <td>22.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>91542098</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>91488595</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1098679890</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>13870951</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>91076334</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>91530525</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>1098734230</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>88033083</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>78691143</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>1101755626</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1052405562</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     National ID  Test 2 score (/40)  Test 2 score (/100)\n",
       "Rank                                                     \n",
       "1       91485661              34.800                87.00\n",
       "2       91517000              34.400                86.00\n",
       "3        5622430              33.200                83.00\n",
       "4     1098755264              33.068                82.67\n",
       "5       91541184              33.068                82.67\n",
       "6     1098670142              32.932                82.33\n",
       "7     1095822478              32.800                82.00\n",
       "8       37727082              32.668                81.67\n",
       "9     1098649274              32.668                81.67\n",
       "10      63509285              32.532                81.33\n",
       "11      77192317              32.532                81.33\n",
       "12    1098603445              32.400                81.00\n",
       "13      63532509              32.268                80.67\n",
       "14    1098674727              32.268                80.67\n",
       "15      91281598              32.268                80.67\n",
       "16      91487046              32.132                80.33\n",
       "17      91242913              32.132                80.33\n",
       "18      63498067              32.000                80.00\n",
       "19      91538394              32.000                80.00\n",
       "20    1098725244              32.000                80.00\n",
       "21      13747270              31.868                79.67\n",
       "22      88030156              31.732                79.33\n",
       "23      63490103              31.600                79.00\n",
       "24      91159510              31.332                78.33\n",
       "25      63546268              31.200                78.00\n",
       "26      91185455              31.200                78.00\n",
       "27      63354984              31.200                78.00\n",
       "28    1098635329              31.200                78.00\n",
       "29      37548548              31.200                78.00\n",
       "30      13749120              31.068                77.67\n",
       "31      75105514              31.068                77.67\n",
       "32    1098652669              30.932                77.33\n",
       "33      88239656              30.800                77.00\n",
       "34      63507533              30.668                76.67\n",
       "35       8678080              30.668                76.67\n",
       "36      91420169              30.668                76.67\n",
       "37      37840056              30.532                76.33\n",
       "38      91228781              30.400                76.00\n",
       "39    1143369873              30.400                76.00\n",
       "40      23181732              30.400                76.00\n",
       "41      13516138              30.400                76.00\n",
       "42      60260984              30.400                76.00\n",
       "43      13740054              29.868                74.67\n",
       "44      37933266              29.868                74.67\n",
       "45      91183047              29.868                74.67\n",
       "46      13706489              29.732                74.33\n",
       "47    1095932710              29.600                74.00\n",
       "48      91479901              29.600                74.00\n",
       "49      13956532              29.600                74.00\n",
       "50    1095806179              29.468                73.67\n",
       "51      63550823              29.468                73.67\n",
       "52      63511924              29.332                73.33\n",
       "53    1095923854              29.068                72.67\n",
       "54      91254270              28.932                72.33\n",
       "55      63507562              28.932                72.33\n",
       "56    1098772750              28.800                72.00\n",
       "57      91111869              28.400                71.00\n",
       "58      91297969              28.400                71.00\n",
       "59    1098727350              28.400                71.00\n",
       "60      91222328              28.132                70.33\n",
       "61      13716299              28.132                70.33\n",
       "62    1095790157              28.132                70.33\n",
       "63      13957933              27.868                69.67\n",
       "64    1098635446              27.600                69.00\n",
       "65    1098669880              27.332                68.33\n",
       "66      13847900              26.532                66.33\n",
       "67      91241521              25.732                64.33\n",
       "68      63510407              25.332                63.33\n",
       "69      91536552              24.400                61.00\n",
       "70      91515163              24.132                60.33\n",
       "71      13719373              24.000                60.00\n",
       "72      63550752              23.732                59.33\n",
       "73    1095818612              23.200                58.00\n",
       "74      13465771              23.068                57.67\n",
       "75      91476285              22.932                57.33\n",
       "76      72288606              21.600                54.00\n",
       "77      63536498              21.468                53.67\n",
       "78      91472753              21.468                53.67\n",
       "79    1098705285              21.200                53.00\n",
       "80      91264734              20.800                52.00\n",
       "81      91244661              20.132                50.33\n",
       "82      19202966              19.600                49.00\n",
       "83      13723457              19.468                48.67\n",
       "84      37558777              19.200                48.00\n",
       "85      91429425              19.068                47.67\n",
       "86      28393300              18.400                46.00\n",
       "87      91531901              17.332                43.33\n",
       "88      91275647              15.068                37.67\n",
       "89    1095937416              12.268                30.67\n",
       "90      91237800               9.068                22.67\n",
       "91      91542098               0.000                 0.00\n",
       "92      91488595               0.000                 0.00\n",
       "93    1098679890               0.000                 0.00\n",
       "94      13870951               0.000                 0.00\n",
       "95      91076334               0.000                 0.00\n",
       "96      91530525               0.000                 0.00\n",
       "97    1098734230               0.000                 0.00\n",
       "98      88033083               0.000                 0.00\n",
       "99      78691143               0.000                 0.00\n",
       "100   1101755626               0.000                 0.00\n",
       "101   1052405562               0.000                 0.00"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "column_test_2 = scores_df_columns[3]\n",
    "\n",
    "scores_by_test_2 = sort_by_specific_score(scores_df, column_test_2)\n",
    "scores_by_test_2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ef2762a1",
   "metadata": {},
   "source": [
    "### Almacenamiento de resultados\n",
    "\n",
    "Conserva los resultados en un archivo de Excel, con cada criterio de clasificación en una hoja de cálculo apropiadamente nombrada."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "edce3225",
   "metadata": {},
   "outputs": [],
   "source": [
    "with pd.ExcelWriter('ResultadosSENA2022.xlsx') as writer:\n",
    "    scores_by_total.to_excel(writer, sheet_name=\"Generales\")\n",
    "    scores_by_cv.to_excel(writer, sheet_name=\"Hoja de Vida\")\n",
    "    scores_by_test_1.to_excel(writer, sheet_name=\"Prueba Habilidades Digitales\")\n",
    "    scores_by_test_2.to_excel(writer, sheet_name=\"Prueba Socioemocional\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "34d2734c",
   "metadata": {},
   "source": [
    "Los resultados anteriores están sujetos a las reclamaciones que reciba la ESAP (que, sin conocer las respuestas, no deberían llevar a modificar sensiblemente los puntajes). Además, las posiciones no toman en cuenta a qué cargo está aplicando cada participante pues esta información no es pública a la fecha\n",
    "\n",
    "La intención de este análisis es contribuir a que el proceso sea más transparente. Es fácil modificar el código aquí contenido para analizar otros centros o para obtener los puntajes al 60% de todos los aplicantes del país."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}