criterios_admision.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Imports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import matplotlib.gridspec as gridspec\n",
    "import gc\n",
    "import pretty_html_table as phtm\n",
    "#import sys\n",
    "# To be able to import from lib directory\n",
    "#sys.path.append(r'..\\lib\\\\')\n",
    "#do not show warnings\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "69"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gc.collect()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Datos crudos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Cargar todos los datos\n",
    "saber11_20171 = pd.read_csv(r'data\\Saber_11__2017-1.csv')\n",
    "saber11_20172 = pd.read_csv(r'data\\Saber_11__2017-2.csv')\n",
    "saber11_20181 = pd.read_csv(r'data\\Saber_11__2018-1.csv')\n",
    "saber11_20182 = pd.read_csv(r'data\\Saber_11__2018-2.csv')\n",
    "saber11_20191 = pd.read_csv(r'data\\Saber_11__2019-1.csv')\n",
    "saber11_20192 = pd.read_csv(r'data\\Saber_11__2019-2.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Lista de DB\n",
    "datos = [saber11_20171, \n",
    "         saber11_20172, \n",
    "         saber11_20181, \n",
    "         saber11_20182, \n",
    "         saber11_20191, \n",
    "         saber11_20192]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Columnas a minúscula\n",
    "for peri in datos:\n",
    "    peri.columns = [i.lower() for i in peri.columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "variables_cole = [i for i in saber11_20171.columns if 'cole' in i]\n",
    "variables_estu = [i for i in saber11_20171.columns if 'estu' in i]\n",
    "variables_fami = [i for i in saber11_20171.columns if 'fami' in i]\n",
    "\n",
    "key_cole = ['cole_cod_dane_establecimiento', \n",
    "            'cole_cod_dane_sede',\n",
    "            'cole_cod_mcpio_ubicacion',\n",
    "            'cole_cod_depto_ubicacion',\n",
    "            'cole_naturaleza',\n",
    "            'cole_calendario']\n",
    "\n",
    "key_estu = key_cole + ['fami_estratovivienda','punt_global','estu_horassemanatrabaja','periodo','estu_consecutivo']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Colegios"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Concat de todos los periodos: cada fila es un colegio\n",
    "key = key_cole + ['cole_nombre_sede', 'cole_mcpio_ubicacion','cole_depto_ubicacion']\n",
    "colegios_2017_2019 = pd.concat([saber11_20171[key].drop_duplicates(), \n",
    "                                saber11_20172[key].drop_duplicates(),\n",
    "                                saber11_20181[key].drop_duplicates(), \n",
    "                                saber11_20182[key].drop_duplicates(), \n",
    "                                saber11_20191[key].drop_duplicates(), \n",
    "                                saber11_20192[key].drop_duplicates()])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Algunos duplicados por un cambio en el nombre\n",
    "colegios_2017_2019.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Revisar duplicados\n",
    "colegios_2017_2019[key_cole].drop_duplicates().shape[0] == colegios_2017_2019.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Un solo nombre por colegio, escogido de forma alfabética\n",
    "colegios_2017_2019_ = pd.pivot_table(data=colegios_2017_2019,\n",
    "                            index=key_cole,\n",
    "                            aggfunc={'cole_nombre_sede':'min','cole_mcpio_ubicacion':'min','cole_depto_ubicacion':'min'}).reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colegios_2017_2019_[key_cole].drop_duplicates().shape[0] == colegios_2017_2019_.shape[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Estudiantes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Concat de todos los periodos: cada fila es un estudiante\n",
    "estudiantes_2017_2019 = pd.concat([saber11_20171[key_estu], \n",
    "                                   saber11_20172[key_estu], \n",
    "                                   saber11_20181[key_estu], \n",
    "                                   saber11_20182[key_estu], \n",
    "                                   saber11_20191[key_estu], \n",
    "                                   saber11_20192[key_estu]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "cole_cod_dane_establecimiento    0  \n",
       "cole_cod_dane_sede               0  \n",
       "cole_cod_mcpio_ubicacion         0  \n",
       "cole_cod_depto_ubicacion         0  \n",
       "cole_naturaleza                  0  \n",
       "cole_calendario                  0  \n",
       "fami_estratovivienda             26 \n",
       "punt_global                      0  \n",
       "estu_horassemanatrabaja          381\n",
       "periodo                          0  \n",
       "estu_consecutivo                 0  \n",
       "dtype: int64"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Null check\n",
    "estudiantes_2017_2019.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Fill nulls\n",
    "estudiantes_2017_2019['fami_estratovivienda'].fillna('AA-Sin info',inplace=True)\n",
    "estudiantes_2017_2019['estu_horassemanatrabaja'].fillna('AA-Sin info',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Juntar las dos sedes del Marymount en Atlántico\n",
    "estudiantes_2017_2019['cole_cod_dane_establecimiento'] = estudiantes_2017_2019['cole_cod_dane_establecimiento'].apply(lambda x: 308001004209 if x == 308573800031 else x)\n",
    "estudiantes_2017_2019['cole_cod_dane_sede'] = estudiantes_2017_2019['cole_cod_dane_sede'].apply(lambda x: 308001004209 if x == 308573800031 else x)\n",
    "mask = (estudiantes_2017_2019['cole_cod_dane_sede'] == 308001004209) & (estudiantes_2017_2019['cole_cod_mcpio_ubicacion'] == 8573)\n",
    "estudiantes_2017_2019['cole_cod_mcpio_ubicacion'][mask] = 8001"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 180,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Duplicates check\n",
    "estudiantes_2017_2019[['estu_consecutivo']].drop_duplicates().shape[0] == estudiantes_2017_2019.shape[0]\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Cálculos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Método 1: Promedio por institución sobre todos los periodos\n",
    "#Cálculo del promedio de todos lo periodos por colegio y su sigma\n",
    "#Promedio\n",
    "cole_acumulado = pd.pivot_table(data=estudiantes_2017_2019,\n",
    "                                index=key_cole,\n",
    "                                aggfunc={'punt_global':'mean','estu_consecutivo':'count'}).reset_index()\n",
    "cole_acumulado.rename(columns={\"punt_global\": \"prom_punt_global\",\"estu_consecutivo\": \"num_evaluados\"},inplace=True)\n",
    "\n",
    "#Desviación estándar\n",
    "cole_acumulado1 = pd.pivot_table(data=estudiantes_2017_2019,\n",
    "                                 index=key_cole,\n",
    "                                 aggfunc={'punt_global':np.std}).reset_index() \n",
    "cole_acumulado1.rename(columns={\"punt_global\": \"stdve_punt_global\"},inplace=True)\n",
    "\n",
    "#Resultados\n",
    "cole_acumulado_final = cole_acumulado.merge(cole_acumulado1[key_cole+['stdve_punt_global']], \n",
    "                                            how='left',\n",
    "                                            left_on=key_cole, \n",
    "                                            right_on=key_cole)\n",
    "\n",
    "cole_acumulado_final['stdve_punt_global'].fillna(0, inplace=True)\n",
    "\n",
    "#Criterio de Andes = Promedio - 1.25(Desviaciones estándar)\n",
    "cole_acumulado_final['criterio_andes'] = cole_acumulado_final['prom_punt_global'] - 1.25*cole_acumulado_final['stdve_punt_global']\n",
    "\n",
    "#True: Criterio Andes >= 310 , False: Criterio Andes < 310*\n",
    "#Acá se puso en 295 porque es el valor mínimo de un colegio confirmado. Más adelante se cambia el valor con la condición correcta\n",
    "cole_acumulado_final['entrada_directa'] = [False]*cole_acumulado_final.shape[0]\n",
    "cole_acumulado_final['entrada_directa'][cole_acumulado_final.criterio_andes >= 295] = True\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "metadata": {},
   "outputs": [],
   "source": [
    "resultados_cole = cole_acumulado_final[(cole_acumulado_final.entrada_directa) & (cole_acumulado_final.cole_calendario == 'B')].sort_values(by='criterio_andes', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "metadata": {
    "code_folding": []
   },
   "outputs": [],
   "source": [
    "resultados_final = resultados_cole.merge(colegios_2017_2019_,\n",
    "                                         left_on=key_cole, \n",
    "                                         right_on=key_cole)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "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>cole_cod_dane_establecimiento</th>\n",
       "      <th>cole_cod_dane_sede</th>\n",
       "      <th>cole_cod_mcpio_ubicacion</th>\n",
       "      <th>cole_cod_depto_ubicacion</th>\n",
       "      <th>cole_naturaleza</th>\n",
       "      <th>cole_calendario</th>\n",
       "      <th>num_evaluados</th>\n",
       "      <th>prom_punt_global</th>\n",
       "      <th>stdve_punt_global</th>\n",
       "      <th>criterio_andes</th>\n",
       "      <th>entrada_directa</th>\n",
       "      <th>cole_depto_ubicacion</th>\n",
       "      <th>cole_mcpio_ubicacion</th>\n",
       "      <th>cole_nombre_sede</th>\n",
       "      <th>confirmados_el_uniandino</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>58</td>\n",
       "      <td>308001004209</td>\n",
       "      <td>308001004209</td>\n",
       "      <td>8001</td>\n",
       "      <td>8</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>209</td>\n",
       "      <td>349.11</td>\n",
       "      <td>31.67</td>\n",
       "      <td>309.52</td>\n",
       "      <td>No</td>\n",
       "      <td>ATLANTICO</td>\n",
       "      <td>BARRANQUILLA</td>\n",
       "      <td>COL MARYMOUNT -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>59</td>\n",
       "      <td>376001012606</td>\n",
       "      <td>376001012606</td>\n",
       "      <td>76001</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>56</td>\n",
       "      <td>347.77</td>\n",
       "      <td>30.84</td>\n",
       "      <td>309.22</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>CALI</td>\n",
       "      <td>ASPAEN LICEO TACURÍ</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>60</td>\n",
       "      <td>311769003474</td>\n",
       "      <td>311769003474</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>352</td>\n",
       "      <td>344.81</td>\n",
       "      <td>28.61</td>\n",
       "      <td>309.05</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL ANDINO</td>\n",
       "      <td>Entrada directa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61</td>\n",
       "      <td>311001047863</td>\n",
       "      <td>311001047863</td>\n",
       "      <td>25126</td>\n",
       "      <td>25</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>127</td>\n",
       "      <td>343.64</td>\n",
       "      <td>27.85</td>\n",
       "      <td>308.82</td>\n",
       "      <td>No</td>\n",
       "      <td>CUNDINAMARCA</td>\n",
       "      <td>CAJICA</td>\n",
       "      <td>COL FUND CARDENAL JHON HENRY NEWMAN</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>62</td>\n",
       "      <td>325175000549</td>\n",
       "      <td>325175000549</td>\n",
       "      <td>25175</td>\n",
       "      <td>25</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>164</td>\n",
       "      <td>342.60</td>\n",
       "      <td>28.10</td>\n",
       "      <td>307.47</td>\n",
       "      <td>No</td>\n",
       "      <td>CUNDINAMARCA</td>\n",
       "      <td>CHIA</td>\n",
       "      <td>GIMN BRITANICO</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63</td>\n",
       "      <td>311848000936</td>\n",
       "      <td>311848000936</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>244</td>\n",
       "      <td>343.97</td>\n",
       "      <td>29.27</td>\n",
       "      <td>307.38</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL SANTA MARIA</td>\n",
       "      <td>Entrada directa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>64</td>\n",
       "      <td>308001077745</td>\n",
       "      <td>308001077745</td>\n",
       "      <td>8001</td>\n",
       "      <td>8</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>149</td>\n",
       "      <td>349.46</td>\n",
       "      <td>33.67</td>\n",
       "      <td>307.36</td>\n",
       "      <td>No</td>\n",
       "      <td>ATLANTICO</td>\n",
       "      <td>BARRANQUILLA</td>\n",
       "      <td>COL REAL (ROYAL SCHOOL) -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>65</td>\n",
       "      <td>463190000443</td>\n",
       "      <td>463190000443</td>\n",
       "      <td>63690</td>\n",
       "      <td>63</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>35</td>\n",
       "      <td>348.46</td>\n",
       "      <td>33.13</td>\n",
       "      <td>307.04</td>\n",
       "      <td>No</td>\n",
       "      <td>QUINDIO</td>\n",
       "      <td>SALENTO</td>\n",
       "      <td>GIMN INGLES</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>66</td>\n",
       "      <td>405607000476</td>\n",
       "      <td>405607000476</td>\n",
       "      <td>5607</td>\n",
       "      <td>5</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>87</td>\n",
       "      <td>347.37</td>\n",
       "      <td>32.59</td>\n",
       "      <td>306.63</td>\n",
       "      <td>No</td>\n",
       "      <td>ANTIOQUIA</td>\n",
       "      <td>RETIRO</td>\n",
       "      <td>COL GIMN VERMONT</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>67</td>\n",
       "      <td>311001107513</td>\n",
       "      <td>311001107513</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>90</td>\n",
       "      <td>340.92</td>\n",
       "      <td>27.85</td>\n",
       "      <td>306.12</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL VICTORIA -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>68</td>\n",
       "      <td>311848001011</td>\n",
       "      <td>311848001011</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>379</td>\n",
       "      <td>347.03</td>\n",
       "      <td>33.45</td>\n",
       "      <td>305.22</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL ANGLO COLOMBIANO</td>\n",
       "      <td>Entrada directa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>69</td>\n",
       "      <td>313001003931</td>\n",
       "      <td>313001003931</td>\n",
       "      <td>13001</td>\n",
       "      <td>13</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>134</td>\n",
       "      <td>347.90</td>\n",
       "      <td>34.22</td>\n",
       "      <td>305.12</td>\n",
       "      <td>No</td>\n",
       "      <td>BOLIVAR</td>\n",
       "      <td>CARTAGENA</td>\n",
       "      <td>COL JORGE WASHINGTON -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>70</td>\n",
       "      <td>425126800020</td>\n",
       "      <td>425126800020</td>\n",
       "      <td>25126</td>\n",
       "      <td>25</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>77</td>\n",
       "      <td>337.75</td>\n",
       "      <td>26.21</td>\n",
       "      <td>304.99</td>\n",
       "      <td>No</td>\n",
       "      <td>CUNDINAMARCA</td>\n",
       "      <td>CAJICA</td>\n",
       "      <td>COL SAN JOSÉ -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71</td>\n",
       "      <td>311001100985</td>\n",
       "      <td>311001100985</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>159</td>\n",
       "      <td>343.01</td>\n",
       "      <td>30.71</td>\n",
       "      <td>304.62</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL BILING RICHMOND</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>72</td>\n",
       "      <td>376001001221</td>\n",
       "      <td>376001001221</td>\n",
       "      <td>76001</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>245</td>\n",
       "      <td>346.72</td>\n",
       "      <td>33.87</td>\n",
       "      <td>304.39</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>CALI</td>\n",
       "      <td>COL BOLIVAR</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>73</td>\n",
       "      <td>376001030302</td>\n",
       "      <td>376001030302</td>\n",
       "      <td>76001</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>30</td>\n",
       "      <td>340.97</td>\n",
       "      <td>29.30</td>\n",
       "      <td>304.34</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>CALI</td>\n",
       "      <td>COL ANGLO AMERICANO</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>74</td>\n",
       "      <td>305001019681</td>\n",
       "      <td>305001019681</td>\n",
       "      <td>5266</td>\n",
       "      <td>5</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>173</td>\n",
       "      <td>344.78</td>\n",
       "      <td>32.39</td>\n",
       "      <td>304.29</td>\n",
       "      <td>No</td>\n",
       "      <td>ANTIOQUIA</td>\n",
       "      <td>ENVIGADO</td>\n",
       "      <td>CORPORACION COL CUMBRES</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75</td>\n",
       "      <td>311848000693</td>\n",
       "      <td>311848000693</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>316</td>\n",
       "      <td>341.21</td>\n",
       "      <td>29.60</td>\n",
       "      <td>304.21</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL DE INGLATERRA (THE ENGLISH SCHOOL) -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>76</td>\n",
       "      <td>319001003280</td>\n",
       "      <td>319001003280</td>\n",
       "      <td>19001</td>\n",
       "      <td>19</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>19</td>\n",
       "      <td>332.21</td>\n",
       "      <td>22.51</td>\n",
       "      <td>304.08</td>\n",
       "      <td>No</td>\n",
       "      <td>CAUCA</td>\n",
       "      <td>POPAYAN</td>\n",
       "      <td>COL CAMPESTRE AMERICANO -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>77</td>\n",
       "      <td>311001047294</td>\n",
       "      <td>311001047294</td>\n",
       "      <td>25126</td>\n",
       "      <td>25</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>105</td>\n",
       "      <td>341.53</td>\n",
       "      <td>30.19</td>\n",
       "      <td>303.79</td>\n",
       "      <td>No</td>\n",
       "      <td>CUNDINAMARCA</td>\n",
       "      <td>CAJICA</td>\n",
       "      <td>COL MAYOR DE LOS ANDES -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>78</td>\n",
       "      <td>476892099710</td>\n",
       "      <td>476892099710</td>\n",
       "      <td>76892</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>37</td>\n",
       "      <td>338.68</td>\n",
       "      <td>28.09</td>\n",
       "      <td>303.56</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>YUMBO</td>\n",
       "      <td>COL INTERNACIONAL LOS CAÑAVERALES</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>79</td>\n",
       "      <td>308001012805</td>\n",
       "      <td>308001012805</td>\n",
       "      <td>8573</td>\n",
       "      <td>8</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>17</td>\n",
       "      <td>341.53</td>\n",
       "      <td>30.59</td>\n",
       "      <td>303.29</td>\n",
       "      <td>No</td>\n",
       "      <td>ATLANTICO</td>\n",
       "      <td>PUERTO COLOMBIA</td>\n",
       "      <td>ASPAEN GIMN LOS CORALES</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>80</td>\n",
       "      <td>320001002753</td>\n",
       "      <td>320001002753</td>\n",
       "      <td>20001</td>\n",
       "      <td>20</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>127</td>\n",
       "      <td>348.53</td>\n",
       "      <td>36.40</td>\n",
       "      <td>303.03</td>\n",
       "      <td>No</td>\n",
       "      <td>CESAR</td>\n",
       "      <td>VALLEDUPAR</td>\n",
       "      <td>COL FUND.   BILING . DE VALLEDUPAR</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>81</td>\n",
       "      <td>425175000969</td>\n",
       "      <td>425175000969</td>\n",
       "      <td>25175</td>\n",
       "      <td>25</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>180</td>\n",
       "      <td>339.93</td>\n",
       "      <td>30.21</td>\n",
       "      <td>302.16</td>\n",
       "      <td>No</td>\n",
       "      <td>CUNDINAMARCA</td>\n",
       "      <td>CHIA</td>\n",
       "      <td>GIMN LOS CAOBOS</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>82</td>\n",
       "      <td>311001033633</td>\n",
       "      <td>311001033633</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>153</td>\n",
       "      <td>341.81</td>\n",
       "      <td>32.49</td>\n",
       "      <td>301.20</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>CENT EDUC Y CULT ESPAÑOL REYES CATOLICOS</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>83</td>\n",
       "      <td>308001000122</td>\n",
       "      <td>308001000122</td>\n",
       "      <td>8001</td>\n",
       "      <td>8</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>31</td>\n",
       "      <td>337.48</td>\n",
       "      <td>29.06</td>\n",
       "      <td>301.16</td>\n",
       "      <td>No</td>\n",
       "      <td>ATLANTICO</td>\n",
       "      <td>BARRANQUILLA</td>\n",
       "      <td>COL LA MEDALLA  MILAGROSA</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>84</td>\n",
       "      <td>425175032674</td>\n",
       "      <td>425175032674</td>\n",
       "      <td>25175</td>\n",
       "      <td>25</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>179</td>\n",
       "      <td>338.47</td>\n",
       "      <td>29.91</td>\n",
       "      <td>301.09</td>\n",
       "      <td>No</td>\n",
       "      <td>CUNDINAMARCA</td>\n",
       "      <td>CHIA</td>\n",
       "      <td>COL ROCHESTER</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>85</td>\n",
       "      <td>366001003814</td>\n",
       "      <td>366001003814</td>\n",
       "      <td>66001</td>\n",
       "      <td>66</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>95</td>\n",
       "      <td>346.79</td>\n",
       "      <td>36.87</td>\n",
       "      <td>300.70</td>\n",
       "      <td>No</td>\n",
       "      <td>RISARALDA</td>\n",
       "      <td>PEREIRA</td>\n",
       "      <td>COL FUNDACION LIC INGLES</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>86</td>\n",
       "      <td>376001000829</td>\n",
       "      <td>376001000829</td>\n",
       "      <td>76001</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>134</td>\n",
       "      <td>343.98</td>\n",
       "      <td>34.71</td>\n",
       "      <td>300.60</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>CALI</td>\n",
       "      <td>LICEO BENALCAZAR</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>87</td>\n",
       "      <td>319001001180</td>\n",
       "      <td>319001001180</td>\n",
       "      <td>19001</td>\n",
       "      <td>19</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>96</td>\n",
       "      <td>347.61</td>\n",
       "      <td>37.67</td>\n",
       "      <td>300.52</td>\n",
       "      <td>No</td>\n",
       "      <td>CAUCA</td>\n",
       "      <td>POPAYAN</td>\n",
       "      <td>COL LOS ANDES</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>88</td>\n",
       "      <td>425175032208</td>\n",
       "      <td>425175032208</td>\n",
       "      <td>25175</td>\n",
       "      <td>25</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>58</td>\n",
       "      <td>339.43</td>\n",
       "      <td>31.13</td>\n",
       "      <td>300.52</td>\n",
       "      <td>No</td>\n",
       "      <td>CUNDINAMARCA</td>\n",
       "      <td>CHIA</td>\n",
       "      <td>COL INTERNACIONAL SEK COLOMBIA - TRINIDAD DEL  MONTE</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>89</td>\n",
       "      <td>476001029953</td>\n",
       "      <td>476001029953</td>\n",
       "      <td>76001</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>102</td>\n",
       "      <td>347.40</td>\n",
       "      <td>37.91</td>\n",
       "      <td>300.01</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>CALI</td>\n",
       "      <td>COL LA ARBOLEDA -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>90</td>\n",
       "      <td>311001042667</td>\n",
       "      <td>311001042667</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>155</td>\n",
       "      <td>339.90</td>\n",
       "      <td>32.09</td>\n",
       "      <td>299.79</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>GIMN FONTANA</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>91</td>\n",
       "      <td>311848002823</td>\n",
       "      <td>311848002823</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>157</td>\n",
       "      <td>338.66</td>\n",
       "      <td>31.15</td>\n",
       "      <td>299.71</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>GIMN DEL NORTE -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>92</td>\n",
       "      <td>476001044049</td>\n",
       "      <td>476001044049</td>\n",
       "      <td>76001</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>3</td>\n",
       "      <td>325.00</td>\n",
       "      <td>20.30</td>\n",
       "      <td>299.63</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>CALI</td>\n",
       "      <td>LICEO CAMPESTRE INGLES DEL SUR -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>93</td>\n",
       "      <td>376001013157</td>\n",
       "      <td>376001013157</td>\n",
       "      <td>76001</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>61</td>\n",
       "      <td>346.25</td>\n",
       "      <td>37.45</td>\n",
       "      <td>299.43</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>CALI</td>\n",
       "      <td>ASPAEN COL JUANAMBÚ -</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>94</td>\n",
       "      <td>308001101153</td>\n",
       "      <td>308001101153</td>\n",
       "      <td>8573</td>\n",
       "      <td>8</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>166</td>\n",
       "      <td>341.08</td>\n",
       "      <td>33.32</td>\n",
       "      <td>299.42</td>\n",
       "      <td>No</td>\n",
       "      <td>ATLANTICO</td>\n",
       "      <td>PUERTO COLOMBIA</td>\n",
       "      <td>COL BRITANICO INTERNACIONAL</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>95</td>\n",
       "      <td>376892000042</td>\n",
       "      <td>376892000042</td>\n",
       "      <td>76892</td>\n",
       "      <td>76</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>202</td>\n",
       "      <td>342.71</td>\n",
       "      <td>35.25</td>\n",
       "      <td>298.65</td>\n",
       "      <td>No</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>YUMBO</td>\n",
       "      <td>COL JEFFERSON</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>96</td>\n",
       "      <td>311769000998</td>\n",
       "      <td>311769000998</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>46</td>\n",
       "      <td>334.24</td>\n",
       "      <td>29.14</td>\n",
       "      <td>297.81</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL COLOMBO HEBREO</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>97</td>\n",
       "      <td>417873000544</td>\n",
       "      <td>417873000544</td>\n",
       "      <td>17873</td>\n",
       "      <td>17</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>138</td>\n",
       "      <td>342.08</td>\n",
       "      <td>35.44</td>\n",
       "      <td>297.78</td>\n",
       "      <td>No</td>\n",
       "      <td>CALDAS</td>\n",
       "      <td>VILLAMARIA</td>\n",
       "      <td>ASOCIACION COL GRANADINO</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>98</td>\n",
       "      <td>311848000324</td>\n",
       "      <td>311848000324</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>133</td>\n",
       "      <td>338.77</td>\n",
       "      <td>33.77</td>\n",
       "      <td>296.56</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL COLOMBO GALES</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>99</td>\n",
       "      <td>344430001303</td>\n",
       "      <td>344430001303</td>\n",
       "      <td>44035</td>\n",
       "      <td>44</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>76</td>\n",
       "      <td>341.89</td>\n",
       "      <td>37.38</td>\n",
       "      <td>295.16</td>\n",
       "      <td>No</td>\n",
       "      <td>LA GUAJIRA</td>\n",
       "      <td>ALBANIA</td>\n",
       "      <td>COL ALBANIA</td>\n",
       "      <td>Sin información</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>100</td>\n",
       "      <td>311001019941</td>\n",
       "      <td>311001019941</td>\n",
       "      <td>11001</td>\n",
       "      <td>11</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>276</td>\n",
       "      <td>341.81</td>\n",
       "      <td>37.41</td>\n",
       "      <td>295.04</td>\n",
       "      <td>No</td>\n",
       "      <td>BOGOTA</td>\n",
       "      <td>BOGOTÁ D.C.</td>\n",
       "      <td>COL NUEVA GRANADA</td>\n",
       "      <td>Entrada directa</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cole_cod_dane_establecimiento  cole_cod_dane_sede  \\\n",
       "58   308001004209                   308001004209         \n",
       "59   376001012606                   376001012606         \n",
       "60   311769003474                   311769003474         \n",
       "61   311001047863                   311001047863         \n",
       "62   325175000549                   325175000549         \n",
       "63   311848000936                   311848000936         \n",
       "64   308001077745                   308001077745         \n",
       "65   463190000443                   463190000443         \n",
       "66   405607000476                   405607000476         \n",
       "67   311001107513                   311001107513         \n",
       "68   311848001011                   311848001011         \n",
       "69   313001003931                   313001003931         \n",
       "70   425126800020                   425126800020         \n",
       "71   311001100985                   311001100985         \n",
       "72   376001001221                   376001001221         \n",
       "73   376001030302                   376001030302         \n",
       "74   305001019681                   305001019681         \n",
       "75   311848000693                   311848000693         \n",
       "76   319001003280                   319001003280         \n",
       "77   311001047294                   311001047294         \n",
       "78   476892099710                   476892099710         \n",
       "79   308001012805                   308001012805         \n",
       "80   320001002753                   320001002753         \n",
       "81   425175000969                   425175000969         \n",
       "82   311001033633                   311001033633         \n",
       "83   308001000122                   308001000122         \n",
       "84   425175032674                   425175032674         \n",
       "85   366001003814                   366001003814         \n",
       "86   376001000829                   376001000829         \n",
       "87   319001001180                   319001001180         \n",
       "88   425175032208                   425175032208         \n",
       "89   476001029953                   476001029953         \n",
       "90   311001042667                   311001042667         \n",
       "91   311848002823                   311848002823         \n",
       "92   476001044049                   476001044049         \n",
       "93   376001013157                   376001013157         \n",
       "94   308001101153                   308001101153         \n",
       "95   376892000042                   376892000042         \n",
       "96   311769000998                   311769000998         \n",
       "97   417873000544                   417873000544         \n",
       "98   311848000324                   311848000324         \n",
       "99   344430001303                   344430001303         \n",
       "100  311001019941                   311001019941         \n",
       "\n",
       "     cole_cod_mcpio_ubicacion  cole_cod_depto_ubicacion cole_naturaleza  \\\n",
       "58   8001                      8                         NO OFICIAL       \n",
       "59   76001                     76                        NO OFICIAL       \n",
       "60   11001                     11                        NO OFICIAL       \n",
       "61   25126                     25                        NO OFICIAL       \n",
       "62   25175                     25                        NO OFICIAL       \n",
       "63   11001                     11                        NO OFICIAL       \n",
       "64   8001                      8                         NO OFICIAL       \n",
       "65   63690                     63                        NO OFICIAL       \n",
       "66   5607                      5                         NO OFICIAL       \n",
       "67   11001                     11                        NO OFICIAL       \n",
       "68   11001                     11                        NO OFICIAL       \n",
       "69   13001                     13                        NO OFICIAL       \n",
       "70   25126                     25                        NO OFICIAL       \n",
       "71   11001                     11                        NO OFICIAL       \n",
       "72   76001                     76                        NO OFICIAL       \n",
       "73   76001                     76                        NO OFICIAL       \n",
       "74   5266                      5                         NO OFICIAL       \n",
       "75   11001                     11                        NO OFICIAL       \n",
       "76   19001                     19                        NO OFICIAL       \n",
       "77   25126                     25                        NO OFICIAL       \n",
       "78   76892                     76                        NO OFICIAL       \n",
       "79   8573                      8                         NO OFICIAL       \n",
       "80   20001                     20                        NO OFICIAL       \n",
       "81   25175                     25                        NO OFICIAL       \n",
       "82   11001                     11                        NO OFICIAL       \n",
       "83   8001                      8                         NO OFICIAL       \n",
       "84   25175                     25                        NO OFICIAL       \n",
       "85   66001                     66                        NO OFICIAL       \n",
       "86   76001                     76                        NO OFICIAL       \n",
       "87   19001                     19                        NO OFICIAL       \n",
       "88   25175                     25                        NO OFICIAL       \n",
       "89   76001                     76                        NO OFICIAL       \n",
       "90   11001                     11                        NO OFICIAL       \n",
       "91   11001                     11                        NO OFICIAL       \n",
       "92   76001                     76                        NO OFICIAL       \n",
       "93   76001                     76                        NO OFICIAL       \n",
       "94   8573                      8                         NO OFICIAL       \n",
       "95   76892                     76                        NO OFICIAL       \n",
       "96   11001                     11                        NO OFICIAL       \n",
       "97   17873                     17                        NO OFICIAL       \n",
       "98   11001                     11                        NO OFICIAL       \n",
       "99   44035                     44                        NO OFICIAL       \n",
       "100  11001                     11                        NO OFICIAL       \n",
       "\n",
       "    cole_calendario  num_evaluados  prom_punt_global  stdve_punt_global  \\\n",
       "58   B               209            349.11            31.67               \n",
       "59   B               56             347.77            30.84               \n",
       "60   B               352            344.81            28.61               \n",
       "61   B               127            343.64            27.85               \n",
       "62   B               164            342.60            28.10               \n",
       "63   B               244            343.97            29.27               \n",
       "64   B               149            349.46            33.67               \n",
       "65   B               35             348.46            33.13               \n",
       "66   B               87             347.37            32.59               \n",
       "67   B               90             340.92            27.85               \n",
       "68   B               379            347.03            33.45               \n",
       "69   B               134            347.90            34.22               \n",
       "70   B               77             337.75            26.21               \n",
       "71   B               159            343.01            30.71               \n",
       "72   B               245            346.72            33.87               \n",
       "73   B               30             340.97            29.30               \n",
       "74   B               173            344.78            32.39               \n",
       "75   B               316            341.21            29.60               \n",
       "76   B               19             332.21            22.51               \n",
       "77   B               105            341.53            30.19               \n",
       "78   B               37             338.68            28.09               \n",
       "79   B               17             341.53            30.59               \n",
       "80   B               127            348.53            36.40               \n",
       "81   B               180            339.93            30.21               \n",
       "82   B               153            341.81            32.49               \n",
       "83   B               31             337.48            29.06               \n",
       "84   B               179            338.47            29.91               \n",
       "85   B               95             346.79            36.87               \n",
       "86   B               134            343.98            34.71               \n",
       "87   B               96             347.61            37.67               \n",
       "88   B               58             339.43            31.13               \n",
       "89   B               102            347.40            37.91               \n",
       "90   B               155            339.90            32.09               \n",
       "91   B               157            338.66            31.15               \n",
       "92   B               3              325.00            20.30               \n",
       "93   B               61             346.25            37.45               \n",
       "94   B               166            341.08            33.32               \n",
       "95   B               202            342.71            35.25               \n",
       "96   B               46             334.24            29.14               \n",
       "97   B               138            342.08            35.44               \n",
       "98   B               133            338.77            33.77               \n",
       "99   B               76             341.89            37.38               \n",
       "100  B               276            341.81            37.41               \n",
       "\n",
       "     criterio_andes entrada_directa cole_depto_ubicacion cole_mcpio_ubicacion  \\\n",
       "58   309.52          No              ATLANTICO            BARRANQUILLA          \n",
       "59   309.22          No              VALLE                CALI                  \n",
       "60   309.05          No              BOGOTA               BOGOTÁ D.C.           \n",
       "61   308.82          No              CUNDINAMARCA         CAJICA                \n",
       "62   307.47          No              CUNDINAMARCA         CHIA                  \n",
       "63   307.38          No              BOGOTA               BOGOTÁ D.C.           \n",
       "64   307.36          No              ATLANTICO            BARRANQUILLA          \n",
       "65   307.04          No              QUINDIO              SALENTO               \n",
       "66   306.63          No              ANTIOQUIA            RETIRO                \n",
       "67   306.12          No              BOGOTA               BOGOTÁ D.C.           \n",
       "68   305.22          No              BOGOTA               BOGOTÁ D.C.           \n",
       "69   305.12          No              BOLIVAR              CARTAGENA             \n",
       "70   304.99          No              CUNDINAMARCA         CAJICA                \n",
       "71   304.62          No              BOGOTA               BOGOTÁ D.C.           \n",
       "72   304.39          No              VALLE                CALI                  \n",
       "73   304.34          No              VALLE                CALI                  \n",
       "74   304.29          No              ANTIOQUIA            ENVIGADO              \n",
       "75   304.21          No              BOGOTA               BOGOTÁ D.C.           \n",
       "76   304.08          No              CAUCA                POPAYAN               \n",
       "77   303.79          No              CUNDINAMARCA         CAJICA                \n",
       "78   303.56          No              VALLE                YUMBO                 \n",
       "79   303.29          No              ATLANTICO            PUERTO COLOMBIA       \n",
       "80   303.03          No              CESAR                VALLEDUPAR            \n",
       "81   302.16          No              CUNDINAMARCA         CHIA                  \n",
       "82   301.20          No              BOGOTA               BOGOTÁ D.C.           \n",
       "83   301.16          No              ATLANTICO            BARRANQUILLA          \n",
       "84   301.09          No              CUNDINAMARCA         CHIA                  \n",
       "85   300.70          No              RISARALDA            PEREIRA               \n",
       "86   300.60          No              VALLE                CALI                  \n",
       "87   300.52          No              CAUCA                POPAYAN               \n",
       "88   300.52          No              CUNDINAMARCA         CHIA                  \n",
       "89   300.01          No              VALLE                CALI                  \n",
       "90   299.79          No              BOGOTA               BOGOTÁ D.C.           \n",
       "91   299.71          No              BOGOTA               BOGOTÁ D.C.           \n",
       "92   299.63          No              VALLE                CALI                  \n",
       "93   299.43          No              VALLE                CALI                  \n",
       "94   299.42          No              ATLANTICO            PUERTO COLOMBIA       \n",
       "95   298.65          No              VALLE                YUMBO                 \n",
       "96   297.81          No              BOGOTA               BOGOTÁ D.C.           \n",
       "97   297.78          No              CALDAS               VILLAMARIA            \n",
       "98   296.56          No              BOGOTA               BOGOTÁ D.C.           \n",
       "99   295.16          No              LA GUAJIRA           ALBANIA               \n",
       "100  295.04          No              BOGOTA               BOGOTÁ D.C.           \n",
       "\n",
       "                                         cole_nombre_sede  \\\n",
       "58   COL MARYMOUNT -                                        \n",
       "59   ASPAEN LICEO TACURÍ                                    \n",
       "60   COL ANDINO                                             \n",
       "61   COL FUND CARDENAL JHON HENRY NEWMAN                    \n",
       "62   GIMN BRITANICO                                         \n",
       "63   COL SANTA MARIA                                        \n",
       "64   COL REAL (ROYAL SCHOOL) -                              \n",
       "65   GIMN INGLES                                            \n",
       "66   COL GIMN VERMONT                                       \n",
       "67   COL VICTORIA -                                         \n",
       "68   COL ANGLO COLOMBIANO                                   \n",
       "69   COL JORGE WASHINGTON -                                 \n",
       "70   COL SAN JOSÉ -                                         \n",
       "71   COL BILING RICHMOND                                    \n",
       "72   COL BOLIVAR                                            \n",
       "73   COL ANGLO AMERICANO                                    \n",
       "74   CORPORACION COL CUMBRES                                \n",
       "75   COL DE INGLATERRA (THE ENGLISH SCHOOL) -               \n",
       "76   COL CAMPESTRE AMERICANO -                              \n",
       "77   COL MAYOR DE LOS ANDES -                               \n",
       "78   COL INTERNACIONAL LOS CAÑAVERALES                      \n",
       "79   ASPAEN GIMN LOS CORALES                                \n",
       "80   COL FUND.   BILING . DE VALLEDUPAR                     \n",
       "81   GIMN LOS CAOBOS                                        \n",
       "82   CENT EDUC Y CULT ESPAÑOL REYES CATOLICOS               \n",
       "83   COL LA MEDALLA  MILAGROSA                              \n",
       "84   COL ROCHESTER                                          \n",
       "85   COL FUNDACION LIC INGLES                               \n",
       "86   LICEO BENALCAZAR                                       \n",
       "87   COL LOS ANDES                                          \n",
       "88   COL INTERNACIONAL SEK COLOMBIA - TRINIDAD DEL  MONTE   \n",
       "89   COL LA ARBOLEDA -                                      \n",
       "90   GIMN FONTANA                                           \n",
       "91   GIMN DEL NORTE -                                       \n",
       "92   LICEO CAMPESTRE INGLES DEL SUR -                       \n",
       "93   ASPAEN COL JUANAMBÚ -                                  \n",
       "94   COL BRITANICO INTERNACIONAL                            \n",
       "95   COL JEFFERSON                                          \n",
       "96   COL COLOMBO HEBREO                                     \n",
       "97   ASOCIACION COL GRANADINO                               \n",
       "98   COL COLOMBO GALES                                      \n",
       "99   COL ALBANIA                                            \n",
       "100  COL NUEVA GRANADA                                      \n",
       "\n",
       "    confirmados_el_uniandino  \n",
       "58   Sin información          \n",
       "59   Sin información          \n",
       "60   Entrada directa          \n",
       "61   Sin información          \n",
       "62   Sin información          \n",
       "63   Entrada directa          \n",
       "64   Sin información          \n",
       "65   Sin información          \n",
       "66   Sin información          \n",
       "67   Sin información          \n",
       "68   Entrada directa          \n",
       "69   Sin información          \n",
       "70   Sin información          \n",
       "71   Sin información          \n",
       "72   Sin información          \n",
       "73   Sin información          \n",
       "74   Sin información          \n",
       "75   Sin información          \n",
       "76   Sin información          \n",
       "77   Sin información          \n",
       "78   Sin información          \n",
       "79   Sin información          \n",
       "80   Sin información          \n",
       "81   Sin información          \n",
       "82   Sin información          \n",
       "83   Sin información          \n",
       "84   Sin información          \n",
       "85   Sin información          \n",
       "86   Sin información          \n",
       "87   Sin información          \n",
       "88   Sin información          \n",
       "89   Sin información          \n",
       "90   Sin información          \n",
       "91   Sin información          \n",
       "92   Sin información          \n",
       "93   Sin información          \n",
       "94   Sin información          \n",
       "95   Sin información          \n",
       "96   Sin información          \n",
       "97   Sin información          \n",
       "98   Sin información          \n",
       "99   Sin información          \n",
       "100  Entrada directa          "
      ]
     },
     "execution_count": 205,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "resultados_final[resultados_final.entrada_directa=='No']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "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>cole_cod_dane_establecimiento</th>\n",
       "      <th>cole_cod_dane_sede</th>\n",
       "      <th>cole_cod_mcpio_ubicacion</th>\n",
       "      <th>cole_cod_depto_ubicacion</th>\n",
       "      <th>cole_naturaleza</th>\n",
       "      <th>cole_calendario</th>\n",
       "      <th>num_evaluados</th>\n",
       "      <th>prom_punt_global</th>\n",
       "      <th>stdve_punt_global</th>\n",
       "      <th>criterio_andes</th>\n",
       "      <th>entrada_directa</th>\n",
       "      <th>cole_depto_ubicacion</th>\n",
       "      <th>cole_mcpio_ubicacion</th>\n",
       "      <th>cole_nombre_sede</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>79</td>\n",
       "      <td>308001012805</td>\n",
       "      <td>308001012805</td>\n",
       "      <td>8573</td>\n",
       "      <td>8</td>\n",
       "      <td>NO OFICIAL</td>\n",
       "      <td>B</td>\n",
       "      <td>17</td>\n",
       "      <td>341.529412</td>\n",
       "      <td>30.590271</td>\n",
       "      <td>303.291572</td>\n",
       "      <td>True</td>\n",
       "      <td>ATLANTICO</td>\n",
       "      <td>PUERTO COLOMBIA</td>\n",
       "      <td>ASPAEN GIMNASIO LOS CORALES</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    cole_cod_dane_establecimiento  cole_cod_dane_sede  \\\n",
       "79  308001012805                   308001012805         \n",
       "\n",
       "    cole_cod_mcpio_ubicacion  cole_cod_depto_ubicacion cole_naturaleza  \\\n",
       "79  8573                      8                         NO OFICIAL       \n",
       "\n",
       "   cole_calendario  num_evaluados  prom_punt_global  stdve_punt_global  \\\n",
       "79  B               17             341.529412        30.590271           \n",
       "\n",
       "    criterio_andes  entrada_directa cole_depto_ubicacion cole_mcpio_ubicacion  \\\n",
       "79  303.291572      True             ATLANTICO            PUERTO COLOMBIA       \n",
       "\n",
       "               cole_nombre_sede  \n",
       "79  ASPAEN GIMNASIO LOS CORALES  "
      ]
     },
     "execution_count": 185,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "resultados_final[resultados_final['cole_nombre_sede'].str.contains(\"CORALES\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Confirmados por El Uniandino \n",
    "confirmados_el_uniandino = [311769001781, \n",
    "                            311848001011, \n",
    "                            425758800009,\n",
    "                            311769003474,\n",
    "                            311001105430,\n",
    "                            311769000866,\n",
    "                            368001000516,\n",
    "                            376001026968,\n",
    "                            311848000341,\n",
    "                            311001087288,\n",
    "                            311848000278,\n",
    "                            425377800011,\n",
    "                            311769000921,\n",
    "                            311769003342,\n",
    "                            311001019941,\n",
    "                            311001045160,\n",
    "                            311848002424,\n",
    "                            311769000165,\n",
    "                            311848000936,\n",
    "                            425377000529,\n",
    "                            368276000826,\n",
    "                            319001002895,\n",
    "                            308001073952,\n",
    "                            311848000812,\n",
    "                            311848002262,\n",
    "                            311769001846,\n",
    "                            311848000286,\n",
    "                            311769000475,\n",
    "                            376001002279,\n",
    "                            311769003938,\n",
    "                            311769004292,\n",
    "                            466001005641,\n",
    "                            311001019568,\n",
    "                            311001010820,\n",
    "                            311769002818]\n",
    "\n",
    "nombres_confirmados_el_uniandino = ['COL ABRAHAM LINCOLN',\n",
    "                                    'COL ANGLO COLOMBIANO',\n",
    "                                    'COL CAMPOALEGRE LTDA - SEDE PRINCIPAL',\n",
    "                                    'COL ANDINO',\n",
    "                                    'COL LA COLINA',\n",
    "                                    'FUND NUEVO MARYMOUNT',\n",
    "                                    'COL NUEVO CAMBRIDGE',\n",
    "                                    'COLEGIO FREINET',\n",
    "                                    'GIMN CAMPESTRE',\n",
    "                                    'GIMN LA MONTAÑA',\n",
    "                                    'GIMN VERMONT',\n",
    "                                    'COL. HACIENDA LOS ALCAPARROS',\n",
    "                                    'COL HELVETIA',\n",
    "                                    'COL LOS NOGALES',\n",
    "                                    'COL NUEVA GRANADA',\n",
    "                                    'FUND GIMN LOS PORTALES',\n",
    "                                    'COL SAN CARLOS',\n",
    "                                    'COL SAN JORGE DE INGLATERRA',\n",
    "                                    'COL SANTA MARIA',\n",
    "                                    'COL TILATA - SEDE PRINCIPAL',\n",
    "                                    'COL LA QUINTA DEL PUENTE',\n",
    "                                    'COL GIMNASIO CALIBIO',\n",
    "                                    'COLEGIO ALTAMIRA',\n",
    "                                    'GIMN FEMENINO',\n",
    "                                    'COL ITALIANO LEONARDO DA VINCI',\n",
    "                                    'COL SAN TARSICIO',\n",
    "                                    'GIMN DE LOS CERROS',\n",
    "                                    'ASPAEN GIMN IRAGUA',\n",
    "                                    'COL COLOMBO BRITÁNICO',\n",
    "                                    'COL BILING BUCKINGHAM',\n",
    "                                    'COL SAN MATEO APOSTOL',\n",
    "                                    'LIC CAMPESTRE DE PEREIRA',\n",
    "                                    'LIC FRANCES LOUIS PASTEUR',\n",
    "                                    'COL SAN BARTOLOME LA MERCED',\n",
    "                                    'COL. INTERNACIONAL DE EDUCACIÓN INTEGRAL - CIEDI LTDA - SEDE PRINCIPAL']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "35"
      ]
     },
     "execution_count": 187,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(confirmados_el_uniandino)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Pretty results\n",
    "#Nombres\n",
    "resultados_final['cole_nombre_sede'] = [i.replace('COLEGIO','COL') for i in resultados_final['cole_nombre_sede']]\n",
    "resultados_final['cole_nombre_sede'] = [i.replace('COL.','COL') for i in resultados_final['cole_nombre_sede']]\n",
    "resultados_final['cole_nombre_sede'] = [i.replace('SEDE','') for i in resultados_final['cole_nombre_sede']]\n",
    "resultados_final['cole_nombre_sede'] = [i.replace('PRINCIPAL','') for i in resultados_final['cole_nombre_sede']]\n",
    "resultados_final['cole_nombre_sede'] = [i.replace('PRINCIPAL','') for i in resultados_final['cole_nombre_sede']]\n",
    "resultados_final['cole_nombre_sede'] = [i.replace('GIMNASIO','GIMN') for i in resultados_final['cole_nombre_sede']]\n",
    "resultados_final['cole_nombre_sede'] = [i.replace('GIMN.','GIMN') for i in resultados_final['cole_nombre_sede']]\n",
    "\n",
    "#Números\n",
    "resultados_final['prom_punt_global'] = [round(i,2) for i in resultados_final['prom_punt_global']]\n",
    "resultados_final['stdve_punt_global'] = [round(i,2) for i in resultados_final['stdve_punt_global']]\n",
    "resultados_final['criterio_andes'] = [round(i,2) for i in resultados_final['criterio_andes']]\n",
    "\n",
    "#Booleanos\n",
    "resultados_final['confirmados_el_uniandino'] = ['Sin información']*resultados_final.shape[0]\n",
    "resultados_final['confirmados_el_uniandino'][resultados_final.cole_cod_dane_establecimiento.isin(confirmados_el_uniandino)] = 'Entrada directa'\n",
    "resultados_final['entrada_directa'][resultados_final.entrada_directa] = 'Sí'\n",
    "#Condición correcta\n",
    "resultados_final['entrada_directa'][resultados_final.criterio_andes<310] = 'No'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_colwidth', 0)\n",
    "export = ['cole_nombre_sede','cole_depto_ubicacion','prom_punt_global','stdve_punt_global','entrada_directa']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "metadata": {},
   "outputs": [],
   "source": [
    "table_pretty = resultados_final[export+['confirmados_el_uniandino']]\n",
    "\n",
    "table_pretty.rename(columns={\"cole_nombre_sede\": \"Colegio\", \n",
    "                             \"cole_depto_ubicacion\": \"Departamento\",\n",
    "                             \"prom_punt_global\": \"Promedio Saber 11\",\n",
    "                             \"stdve_punt_global\": \"$\\sigma$ Saber 11\",\n",
    "                             \"criterio_andes\":\"Criterio de Los Andes\",\n",
    "                             \"entrada_directa\":\"¿Entra según criterio?\",\n",
    "                             \"confirmados_el_uniandino\":\"Confirmado por El Uniandino\"},inplace=True)\n",
    "\n",
    "table_pretty.index += 1 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 191,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(confirmados_el_uniandino) == len(nombres_confirmados_el_uniandino)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "code_folding": []
   },
   "outputs": [],
   "source": [
    "#Html table\n",
    "<p><table border=\"0\" class=\"dataframe\">\n",
    "  <thead>\n",
    "    <tr style=\"text-align: right;\">\n",
    "      <th style = \"background-color: #FFFFFF;font-family: Arial;color: #305496;text-align: left;border-bottom: 2px solid #305496;padding: 0px 20px 0px 0px\">Colegio</th>\n",
    "      <th style = \"background-color: #FFFFFF;font-family: Arial;color: #305496;text-align: left;border-bottom: 2px solid #305496;padding: 0px 20px 0px 0px\">Departamento</th>\n",
    "      <th style = \"background-color: #FFFFFF;font-family: Arial;color: #305496;text-align: left;border-bottom: 2px solid #305496;padding: 0px 20px 0px 0px\">Promedio Saber 11</th>\n",
    "      <th style = \"background-color: #FFFFFF;font-family: Arial;color: #305496;text-align: left;border-bottom: 2px solid #305496;padding: 0px 20px 0px 0px\">Sigma Saber 11</th>\n",
    "      <th style = \"background-color: #FFFFFF;font-family: Arial;color: #305496;text-align: left;border-bottom: 2px solid #305496;padding: 0px 20px 0px 0px\">¿Entra según criterio?</th>\n",
    "      <th style = \"background-color: #FFFFFF;font-family: Arial;color: #305496;text-align: left;border-bottom: 2px solid #305496;padding: 0px 20px 0px 0px\">Confirmado por El Uniandino</th>\n",
    "    </tr>\n",
    "  </thead>\n",
    "  <tbody>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LA QUINTA DEL PUENTE</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">SANTANDER</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">394.46</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.03</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL NUEVO CAMBRIDGE</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">SANTANDER</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">395.42</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.15</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BILINGUE DIANA OESE</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">393.16</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.66</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL PHILADELPHIA INTERNACIONAL -</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">373.85</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">22.03</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SAN JORGE DE INGLATERRA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">375.27</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">24.16</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LOS NOGALES</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">371.65</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">23.38</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SAN CARLOS</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">374.22</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.07</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN VERMONT</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">370.35</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">24.68</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SANTA FRANCISCA ROMANA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">368.39</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">24.02</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL CAMPOALEGRE LTDA -</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">365.04</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">21.79</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LA COLINA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">372.46</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.5</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SAN MATEO APOSTOL</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">366.99</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.16</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BILING BUCKINGHAM</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">361.92</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">22.14</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL  MONTESSORI BRITISH SCHOOL</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">366.9</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.88</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ABRAHAM LINCOLN</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">368.01</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.93</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN ALESSANDRO VOLTA -</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">362.89</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.53</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL FREINET</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">363.32</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.76</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LEONARDO DA VINCI</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ANTIOQUIA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">361.71</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.72</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL GIMN LA COLINA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">354.41</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">21.89</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL HISPANOAMERICANO</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">361.03</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.54</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">LIC CAMPESTRE DE PEREIRA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">RISARALDA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">357.06</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">24.6</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN LA MONTAÑA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">364.34</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.22</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL MONTESSORI</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ANTIOQUIA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">357.11</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.05</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN DE LOS CERROS</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">361.14</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.56</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">FUND NUEVO MARYMOUNT</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">309.52</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">25.61</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SAN BARTOLOME LA MERCED</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">355.07</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.22</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN CAMPESTRE</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">356.33</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.41</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">FUND GIMN LOS PORTALES</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">355.66</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.19</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL CALATRAVA -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">360.37</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.05</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL INTERNACIONAL LA SIERRA -</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CESAR</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">348.92</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">22.23</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SAN TARSICIO</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">355.7</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.1</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL HELVETIA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">352.8</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">25.94</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN CARTAGENA-ASPAEN</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOLIVAR</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">362.88</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">34.16</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BILING CLERMONT -</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">352.31</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">25.77</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CORP. EDUC. GIMN ALTAIR DE C/GENA.</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOLIVAR</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">355.16</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.06</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL JOSE MAX LEON</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">352.43</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">25.95</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ITALIANO LEONARDO DA VINCI</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">354.64</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.95</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL GIMN CALIBIO</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CAUCA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">354.2</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.27</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL INTERNACIONAL DE EDUCACIÓN INTEGRAL - CIEDI LTDA -</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">353.02</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.39</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL PANAMERICANO</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">SANTANDER</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">356.16</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.95</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ALTAMIRA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ATLANTICO</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">354.84</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.5</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ASPAEN GIMN CARTAGENA DE INDIAS</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOLIVAR</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">356.71</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.59</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LIC FRANCES DE PEREIRA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">RISARALDA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">354.12</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.93</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN CAMP SAN RAFAEL</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">350.94</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.86</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL HACIENDA LOS ALCAPARROS</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">350.43</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.95</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">LIC FRANCES LOUIS PASTEUR</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">351.56</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.98</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL TILATA -</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">350.94</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.39</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN INGLES</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">QUINDIO</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">352.83</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.03</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BRITANICO DE CARTAGENA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOLIVAR</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">357.33</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">35.79</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL COLOMBO BRITÁNICO</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">352.3</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.96</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL HEBREO UNION -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ATLANTICO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">348.63</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.33</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BERCHMANS</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">353.23</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">33.05</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ASPAEN GIMN IRAGUA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">349.23</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.93</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN FEMENINO</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">346.04</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.47</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CORPÓRACION GIMN ALEMÁN FRIENDRICH VON SCHILLER -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">337.25</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">21.06</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CORPORACIÓN CULTURAL COL ALEMÁN -  PRICIPAL</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">349.83</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.24</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #E1FFE3;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL EL CAMINO ACADEMY</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">349.27</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.97</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL CUMBRES</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">348.2</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.44</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sí</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL MARYMOUNT</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ATLANTICO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">347.77</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.67</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ASPAEN LICEO TACURÍ</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">347.77</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.84</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ANDINO</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">344.81</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.61</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL FUND CARDENAL JHON HENRY NEWMAN</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">343.64</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.85</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN BRITANICO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">342.6</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.1</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SANTA MARIA</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">343.97</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.27</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL REAL (ROYAL SCHOOL) -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ATLANTICO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">349.46</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">33.67</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN INGLES</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">QUINDIO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">348.46</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">33.13</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL GIMN VERMONT</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ANTIOQUIA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">347.37</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">32.59</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL VICTORIA -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">340.92</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">27.85</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ANGLO COLOMBIANO</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">347.03</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">33.45</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL JORGE WASHINGTON -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOLIVAR</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">347.9</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">34.22</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL SAN JOSÉ -</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">337.75</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">26.21</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BILING RICHMOND</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">343.01</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.71</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BOLIVAR</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">346.72</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">33.87</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ANGLO AMERICANO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">340.97</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.3</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CORPORACION COL CUMBRES</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ANTIOQUIA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">344.78</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">32.39</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL DE INGLATERRA (THE ENGLISH SCHOOL) -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">341.21</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.6</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL CAMPESTRE AMERICANO -</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CAUCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">332.21</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">22.51</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL MAYOR DE LOS ANDES -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">341.53</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.19</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL INTERNACIONAL LOS CAÑAVERALES</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">338.68</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">28.09</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ASPAEN GIMN LOS CORALES</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ATLANTICO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">341.53</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.59</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL FUND.   BILING . DE VALLEDUPAR</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CESAR</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">348.53</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">36.4</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN LOS CAOBOS</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">339.93</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">30.21</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CENT EDUC Y CULT ESPAÑOL REYES CATOLICOS</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">341.81</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">32.49</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LA MEDALLA  MILAGROSA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ATLANTICO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">337.48</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.06</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ROCHESTER</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">338.47</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.91</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL FUNDACION LIC INGLES</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">RISARALDA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">346.79</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">36.87</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">LICEO BENALCAZAR</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">343.98</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">34.71</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LOS ANDES</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CAUCA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">347.61</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">37.67</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL INTERNACIONAL SEK COLOMBIA - TRINIDAD DEL  MONTE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CUNDINAMARCA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">339.43</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.13</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL LA ARBOLEDA -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">347.4</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">37.91</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN FONTANA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">339.9</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">32.09</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">GIMN DEL NORTE -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">338.66</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">31.15</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">LICEO CAMPESTRE INGLES DEL SUR -</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">325.0</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">20.3</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ASPAEN COL JUANAMBÚ -</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">346.25</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">37.45</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL BRITANICO INTERNACIONAL</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ATLANTICO</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">341.08</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">33.32</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL JEFFERSON</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">VALLE</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">342.71</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">35.25</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL COLOMBO HEBREO</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">334.24</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">29.14</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">ASOCIACION COL GRANADINO</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">CALDAS</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">342.08</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">35.44</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL COLOMBO GALES</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">338.77</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">33.77</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FFFFFF;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL ALBANIA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">LA GUAJIRA</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">341.89</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">37.38</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #D9E1F2;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Sin información</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">COL NUEVA GRANADA</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">BOGOTA</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">341.81</td>\n",
    "      <td style = \"background-color: #FFDAB9;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">37.41</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">No</td>\n",
    "      <td style = \"background-color: #FF8578;font-family: Arial;text-align: left;padding: 0px 0px 0px 0px\">Entrada directa</td>\n",
    "    </tr>\n",
    "  </tbody>\n",
    "</table></p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Método 2: Promedio por periodo-institución y luego por institución\n",
    "#Cálculo del promedio de cada periodo por colegio, luego sacar el promedio por colegio y su sigma\n",
    "#Promedio periodo-colegio\n",
    "cole_acumulado_periodo = pd.pivot_table(data=estudiantes_2017_2019,\n",
    "                                index=key_cole + ['periodo'],\n",
    "                                aggfunc={'punt_global':'mean','estu_consecutivo':'count'}).reset_index()\n",
    "cole_acumulado_periodo.rename(columns={\"punt_global\": \"prom_punt_global\",\"estu_consecutivo\": \"num_evaluados\"},inplace=True)\n",
    "\n",
    "#Promedio colegio\n",
    "cole_acumulado_2 = pd.pivot_table(data=cole_acumulado_periodo,\n",
    "                                index=key_cole,\n",
    "                                aggfunc={'prom_punt_global':'mean','num_evaluados':'sum'}).reset_index()\n",
    "\n",
    "\n",
    "#Desviación estándar\n",
    "cole_acumulado_2_1 = pd.pivot_table(data=cole_acumulado_periodo,\n",
    "                                 index=key_cole,\n",
    "                                 aggfunc={'prom_punt_global':np.std}).reset_index() \n",
    "cole_acumulado_2_1.rename(columns={\"prom_punt_global\": \"stdve_punt_global\"},inplace=True)\n",
    "\n",
    "#Resultados\n",
    "cole_acumulado_final_1 = cole_acumulado_2.merge(cole_acumulado_2_1[key_cole+['stdve_punt_global']], \n",
    "                                                how='left',\n",
    "                                                left_on=key_cole, \n",
    "                                                right_on=key_cole)\n",
    "\n",
    "cole_acumulado_final_1.fillna(0, inplace=True)\n",
    "\n",
    "\n",
    "#Criterio de Andes = Promedio - 1.25(Desviaciones estándar)\n",
    "cole_acumulado_final_1['criterio_andes'] = cole_acumulado_final_1['prom_punt_global'] - 1.25*cole_acumulado_final_1['stdve_punt_global']\n",
    "\n",
    "#True: Criterio Andes >= 310 , False: Criterio Andes < 310\n",
    "cole_acumulado_final_1['entrada_directa'] = [False]*cole_acumulado_final_1.shape[0]\n",
    "cole_acumulado_final_1['entrada_directa'][cole_acumulado_final_1.criterio_andes >= 310] = True\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "resultados_cole_1 = cole_acumulado_final_1[(cole_acumulado_final_1.entrada_directa) & (cole_acumulado_final_1.cole_calendario == 'B')].sort_values(by='criterio_andes', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "resultados_final_1 = resultados_cole_1.merge(colegios_2017_2019_,\n",
    "                                             left_on=key_cole, \n",
    "                                             right_on=key_cole)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "coles = ['cole_depto_ubicacion', \n",
    "         'cole_mcpio_ubicacion', \n",
    "         'cole_nombre_sede',\n",
    "         'cole_calendario',\n",
    "         'num_evaluados',\n",
    "         'prom_punt_global',\n",
    "         'stdve_punt_global',\n",
    "         'criterio_andes',\n",
    "         'entrada_directa']\n",
    "resultados_final[coles].to_csv(r'data\\59_colegios.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Insights"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Saber11_Histórico_vs_Estrato\n",
    "estudiantes_2017_2019['fami_estratovivienda'][estudiantes_2017_2019['fami_estratovivienda']=='-'] = ['AA-Sin info']*estudiantes_2017_2019.shape[0]\n",
    "estudiantes_2017_2019['fami_estratovivienda'][estudiantes_2017_2019['fami_estratovivienda']=='Sin Estrato'] = ['A-Sin Estrato']*estudiantes_2017_2019.shape[0]\n",
    "data = estudiantes_2017_2019.sort_values(by=\"fami_estratovivienda\")\n",
    "\n",
    "data['estrato'] = data['fami_estratovivienda']\n",
    "distribucion = pd.pivot_table(data=data,index=['fami_estratovivienda'],aggfunc={'estrato':'count'}).reset_index()\n",
    "\n",
    "fig = plt.figure(figsize=(11,12))\n",
    "gs = fig.add_gridspec(4, 4)\n",
    "ax1 = plt.subplot(gs[0:3, :])\n",
    "ax3 = plt.subplot(gs[3, :])\n",
    "ax2 = ax1.twinx()\n",
    "\n",
    "sns.boxplot(x=\"fami_estratovivienda\", \n",
    "            y=\"punt_global\", \n",
    "            data=data,\n",
    "            color='lightblue',\n",
    "            ax=ax1)\n",
    "\n",
    "ax1.set_title('Saber 11 vs. Estrato - Histórico Nacional 2017-2019',y=1,fontsize=15)\n",
    "ax1.set_xlabel('',  fontsize=14)\n",
    "ax1.set_ylabel('Promedio del puntaje global en el Saber 11', fontsize=14)\n",
    "ax1.set_ylim(-10,500)\n",
    "ax1.tick_params(axis='both', which='major', labelsize=13)\n",
    "\n",
    "ax2.plot([310]*8,\n",
    "         color='r',\n",
    "         ls='--', \n",
    "         linewidth=2, \n",
    "         label='Corte mínimo de Los Andes (310)')\n",
    "ax2.set_ylim(-10,500)\n",
    "ax2.legend(loc=\"best\",fontsize=15)\n",
    "ax2.tick_params(axis='both', which='major', labelsize=13)\n",
    "\n",
    "ax3.bar(x=distribucion['fami_estratovivienda'], \n",
    "        height=distribucion['estrato']/sum(distribucion['estrato']),\n",
    "        color='mistyrose')\n",
    "ax3.set_xlabel('Estrato de la familia del estudiante',  fontsize=14,y=15)\n",
    "ax3.set_ylabel('%Población evaluada',  fontsize=14)\n",
    "fig.tight_layout()\n",
    "\n",
    "\n",
    "plt.savefig(r'C:\\Users\\Usuario\\Pictures\\Saber11\\saber11_estrato_H.png')\n",
    "plt.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Saber11_B_vs_Estrato\n",
    "data = estudiantes_2017_2019[estudiantes_2017_2019.periodo.isin([20191,20181,20171])]\n",
    "data['fami_estratovivienda'][data['fami_estratovivienda']=='-'] = ['AA-Sin info']*data.shape[0]\n",
    "data['fami_estratovivienda'][data['fami_estratovivienda']=='Sin Estrato'] = ['A-Sin Estrato']*data.shape[0]\n",
    "data = data.sort_values(by=\"fami_estratovivienda\")\n",
    "\n",
    "data['estrato'] = data['fami_estratovivienda']\n",
    "distribucion = pd.pivot_table(data=data,index=['fami_estratovivienda'],aggfunc={'estrato':'count'}).reset_index()\n",
    "\n",
    "fig = plt.figure(figsize=(11,12))\n",
    "gs = fig.add_gridspec(4, 4)\n",
    "ax1 = plt.subplot(gs[0:3, :])\n",
    "ax3 = plt.subplot(gs[3, :])\n",
    "ax2 = ax1.twinx()\n",
    "\n",
    "sns.boxplot(x=\"fami_estratovivienda\", \n",
    "            y=\"punt_global\", \n",
    "            data=data,\n",
    "            color='lightblue',\n",
    "            ax=ax1)\n",
    "\n",
    "ax1.set_title('Saber 11 vs. Estrato - Histórico calendario B 2017-2019',y=1,fontsize=15)\n",
    "ax1.set_xlabel('',  fontsize=14)\n",
    "ax1.set_ylabel('Promedio del puntaje global en el Saber 11', fontsize=14)\n",
    "ax1.set_ylim(-10,500)\n",
    "ax1.tick_params(axis='both', which='major', labelsize=13)\n",
    "\n",
    "ax2.plot([310]*8,\n",
    "         color='r',\n",
    "         ls='--', \n",
    "         linewidth=2, \n",
    "         label='Corte mínimo de Los Andes (310)')\n",
    "ax2.set_ylim(-10,500)\n",
    "ax2.legend(loc=\"best\",fontsize=15)\n",
    "ax2.tick_params(axis='both', which='major', labelsize=13)\n",
    "\n",
    "ax3.bar(x=distribucion['fami_estratovivienda'], \n",
    "        height=distribucion['estrato']/sum(distribucion['estrato']),\n",
    "        color='mistyrose')\n",
    "ax3.set_xlabel('Estrato de la familia del estudiante',  fontsize=14,y=15)\n",
    "ax3.set_ylabel('%Población evaluada',  fontsize=14)\n",
    "fig.tight_layout()\n",
    "\n",
    "\n",
    "plt.savefig(r'C:\\Users\\Usuario\\Pictures\\Saber11\\saber11_estrato_B.png')\n",
    "plt.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Estrato_Confirmados\n",
    "top_59 = resultados_final[resultados_final.criterio_andes>=310].cole_cod_dane_establecimiento.drop_duplicates().values\n",
    "data = estudiantes_2017_2019[(estudiantes_2017_2019.cole_cod_dane_establecimiento.isin(confirmados_el_uniandino+list(top_59)))].sort_values(by='fami_estratovivienda')\n",
    "#data = data[data.cole_cod_dane_establecimiento.isin([top_59])]\n",
    "data['estrato'] = data['fami_estratovivienda']\n",
    "distribucion = pd.pivot_table(data=data,index=['fami_estratovivienda'],aggfunc={'estrato':'count'}).reset_index()\n",
    "\n",
    "data_all = estudiantes_2017_2019.sort_values(by='fami_estratovivienda')\n",
    "data_all['estrato'] = data_all['fami_estratovivienda']\n",
    "distribucion_all = pd.pivot_table(data=data_all,index=['fami_estratovivienda'],aggfunc={'estrato':'count'}).reset_index()\n",
    "\n",
    "\n",
    "fig = plt.figure(figsize=(11,6))\n",
    "ax1 = plt.subplot(211)\n",
    "ax2 = plt.subplot(212)\n",
    "\n",
    "ax1.set_title('Estrato de los colegios con admisión automática según criterio + confirmados', y=1, fontsize=15)\n",
    "ax1.bar(x=distribucion['fami_estratovivienda'], \n",
    "        height=distribucion['estrato']/sum(distribucion['estrato']),\n",
    "        color='mistyrose')\n",
    "ax1.set_ylabel('%Población',  fontsize=14)\n",
    "ax1.set_ylim(0,0.5)\n",
    "\n",
    "ax2.set_title('Estrato estudiantes de los colegios a nivel nacional',y=1,fontsize=15)\n",
    "ax2.bar(x=distribucion_all['fami_estratovivienda'], \n",
    "        height=distribucion_all['estrato']/sum(distribucion_all['estrato']),\n",
    "        color='mistyrose')\n",
    "ax2.set_xlabel('Estrato de la familia del estudiante',  fontsize=14,y=15)\n",
    "ax2.set_ylabel('%Población',  fontsize=14)\n",
    "ax2.set_ylim(0,0.5)\n",
    "\n",
    "plt.subplots_adjust(left=None, bottom=None, right=None, top=None, wspace=None, hspace=0.5)\n",
    "plt.savefig(r'C:\\Users\\Usuario\\Pictures\\Saber11\\estratp_auto.png')\n",
    "plt.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "58"
      ]
     },
     "execution_count": 196,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(top_59)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [],
   "source": [
    "#Regiones_Confirmados\n",
    "data = estudiantes_2017_2019[estudiantes_2017_2019.cole_cod_dane_establecimiento.isin(confirmados_el_uniandino+list(top_59))]\n",
    "data = data.merge(colegios_2017_2019_,\n",
    "                  how='left',\n",
    "                  left_on=key_cole, \n",
    "                  right_on=key_cole).sort_values(by='cole_depto_ubicacion')\n",
    "\n",
    "data['depto'] = data['cole_depto_ubicacion']\n",
    "distribucion = pd.pivot_table(data=data,index=['cole_depto_ubicacion'],aggfunc={'depto':'count'}).reset_index()\n",
    "\n",
    "data_all = estudiantes_2017_2019\n",
    "data_all = data_all.merge(colegios_2017_2019_,\n",
    "                          how='left',\n",
    "                          left_on=key_cole, \n",
    "                          right_on=key_cole).sort_values(by='cole_depto_ubicacion')\n",
    "\n",
    "data_all['depto'] = data_all['cole_depto_ubicacion']\n",
    "distribucion_all = pd.pivot_table(data=data_all,index=['cole_depto_ubicacion'],aggfunc={'depto':'count'}).reset_index()\n",
    "\n",
    "fig = plt.figure(figsize=(11,6))\n",
    "ax1 = plt.subplot(211)\n",
    "ax1.set_title('Departamento de los colegios con admisión automática según criterio + confirmados',y=1,fontsize=15)\n",
    "ax1.bar(x=distribucion['cole_depto_ubicacion'], \n",
    "        height=distribucion['depto']/sum(distribucion['depto']),\n",
    "        color='mistyrose')\n",
    "ax1.set_ylabel('%Población',  fontsize=14)\n",
    "ax1.set_ylim(0,1)\n",
    "ax1.tick_params(axis='x', which='major', labelsize=9,rotation=25)\n",
    "\n",
    "\n",
    "ax2 = plt.subplot(212)\n",
    "ax2.set_title('Departamento de los colegios a nivel nacional', y=1, fontsize=15)\n",
    "ax2.bar(x=distribucion_all['cole_depto_ubicacion'], \n",
    "        height=distribucion_all['depto']/sum(distribucion_all['depto']),\n",
    "        color='mistyrose')\n",
    "ax2.set_xlabel('Departamento del colegio del estudiante',  fontsize=14,y=15)\n",
    "ax2.set_ylabel('%Población',  fontsize=14)\n",
    "ax2.tick_params(axis='x', which='major', labelsize=9,rotation=90)\n",
    "ax2.set_ylim(0,0.3)\n",
    "\n",
    "plt.subplots_adjust(left=None, bottom=None, right=None, top=None, wspace=None, hspace=0.6)\n",
    "plt.savefig(r'C:\\Users\\Usuario\\Pictures\\Saber11\\depto_auto.png')\n",
    "plt.close()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}