analisis_poblacional.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "9278df39",
   "metadata": {},
   "source": [
    "# Análisis poblacional de la región de Aysén\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0e364c7c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "3d4e1dcf",
   "metadata": {},
   "source": [
    "## Importación de datos y librerias"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f3b38d9c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importa librerias necesarias para el análisis\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import plotly.express as px"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4dbdd79f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importa base de datos generada mediante merging \n",
    "\n",
    "data = pd.read_csv(\"data/data_con_establecimiento_cp.csv\", \n",
    "                   low_memory=False\n",
    "                  )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "22e29185",
   "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>Unnamed: 0</th>\n",
       "      <th>id_formulario_eno</th>\n",
       "      <th>numero_folio</th>\n",
       "      <th>id_enfermedad_eno</th>\n",
       "      <th>enfermedad_notificada</th>\n",
       "      <th>semana_epidemiologica</th>\n",
       "      <th>fecha_notificacion</th>\n",
       "      <th>etapa_clinica</th>\n",
       "      <th>establecimiento_salud</th>\n",
       "      <th>region</th>\n",
       "      <th>...</th>\n",
       "      <th>fecha_resultado_otro_cultivo_3</th>\n",
       "      <th>factor_riesgo_caso_confirmado</th>\n",
       "      <th>factor_riesgo_caso_sospechoso</th>\n",
       "      <th>factor_riesgo_viaje_internacional</th>\n",
       "      <th>factor_riesgo_viaje_nacional</th>\n",
       "      <th>ningun_factor_riesgo</th>\n",
       "      <th>test_antigeno_sars_positivo</th>\n",
       "      <th>tac_torax_covid</th>\n",
       "      <th>comuna_seremi_xi</th>\n",
       "      <th>provincia_seremi_xi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>100166</td>\n",
       "      <td>50166</td>\n",
       "      <td>50</td>\n",
       "      <td>Coronavirus (COVID-19)</td>\n",
       "      <td>11</td>\n",
       "      <td>2020-03-12</td>\n",
       "      <td>DESCARTADA</td>\n",
       "      <td>Hospital Regional (Coihaique)</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Coyhaique</td>\n",
       "      <td>Coyhaique</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 276 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  id_formulario_eno  numero_folio  id_enfermedad_eno  \\\n",
       "0           0             100166         50166                 50   \n",
       "\n",
       "    enfermedad_notificada  semana_epidemiologica fecha_notificacion  \\\n",
       "0  Coronavirus (COVID-19)                     11         2020-03-12   \n",
       "\n",
       "  etapa_clinica          establecimiento_salud  \\\n",
       "0    DESCARTADA  Hospital Regional (Coihaique)   \n",
       "\n",
       "                                              region  ...  \\\n",
       "0  Región de Aysén del General Carlos Ibáñez del ...  ...   \n",
       "\n",
       "  fecha_resultado_otro_cultivo_3 factor_riesgo_caso_confirmado  \\\n",
       "0                            NaN                           NaN   \n",
       "\n",
       "  factor_riesgo_caso_sospechoso  factor_riesgo_viaje_internacional  \\\n",
       "0                           NaN                                NaN   \n",
       "\n",
       "  factor_riesgo_viaje_nacional ningun_factor_riesgo  \\\n",
       "0                          NaN                  NaN   \n",
       "\n",
       "  test_antigeno_sars_positivo tac_torax_covid comuna_seremi_xi  \\\n",
       "0                         NaN             NaN        Coyhaique   \n",
       "\n",
       "  provincia_seremi_xi  \n",
       "0           Coyhaique  \n",
       "\n",
       "[1 rows x 276 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Filtra datos obtenidos solo para pacientes con residencia en la Región de Aysén\n",
    "\n",
    "data_aysen = data[data['region_residencia'] == 'Región de Aysén del General Carlos Ibáñez del Campo']\n",
    "\n",
    "data_aysen.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "2b609c0b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_pop = pd.read_excel('data/datos_poblacionales_region_aysen.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e6ca3500",
   "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>ORDEN</th>\n",
       "      <th>NOMBRE REGIÓN</th>\n",
       "      <th>Código Región</th>\n",
       "      <th>NOMBRE PROVINCIA</th>\n",
       "      <th>Código Provincia</th>\n",
       "      <th>NOMBRE COMUNA</th>\n",
       "      <th>Código Comuna</th>\n",
       "      <th>Edad</th>\n",
       "      <th>Hombres</th>\n",
       "      <th>Mujeres</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7172</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>COYHAIQUE</td>\n",
       "      <td>111</td>\n",
       "      <td>COYHAIQUE</td>\n",
       "      <td>11101</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>28763</td>\n",
       "      <td>29055</td>\n",
       "      <td>57818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7194</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>COYHAIQUE</td>\n",
       "      <td>111</td>\n",
       "      <td>LAGO VERDE</td>\n",
       "      <td>11102</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>494</td>\n",
       "      <td>358</td>\n",
       "      <td>852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7216</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>112</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>11201</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>12719</td>\n",
       "      <td>11240</td>\n",
       "      <td>23959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7238</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>112</td>\n",
       "      <td>CISNES</td>\n",
       "      <td>11202</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>3922</td>\n",
       "      <td>2595</td>\n",
       "      <td>6517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7260</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>112</td>\n",
       "      <td>GUAITECAS</td>\n",
       "      <td>11203</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>1166</td>\n",
       "      <td>677</td>\n",
       "      <td>1843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7282</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>CAPITÁN PRAT</td>\n",
       "      <td>113</td>\n",
       "      <td>COCHRANE</td>\n",
       "      <td>11301</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>1902</td>\n",
       "      <td>1588</td>\n",
       "      <td>3490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7304</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>CAPITÁN PRAT</td>\n",
       "      <td>113</td>\n",
       "      <td>O'HIGGINS</td>\n",
       "      <td>11302</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>374</td>\n",
       "      <td>251</td>\n",
       "      <td>625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7326</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>CAPITÁN PRAT</td>\n",
       "      <td>113</td>\n",
       "      <td>TORTEL</td>\n",
       "      <td>11303</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>285</td>\n",
       "      <td>238</td>\n",
       "      <td>523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7348</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>GENERAL CARRERA</td>\n",
       "      <td>114</td>\n",
       "      <td>CHILE CHICO</td>\n",
       "      <td>11401</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>2577</td>\n",
       "      <td>2288</td>\n",
       "      <td>4865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7370</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>GENERAL CARRERA</td>\n",
       "      <td>114</td>\n",
       "      <td>RÍO IBÁÑEZ</td>\n",
       "      <td>11402</td>\n",
       "      <td>Total Comunal</td>\n",
       "      <td>1445</td>\n",
       "      <td>1221</td>\n",
       "      <td>2666</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ORDEN                              NOMBRE REGIÓN  Código Región  \\\n",
       "0   7172  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "1   7194  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "2   7216  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "3   7238  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "4   7260  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "5   7282  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "6   7304  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "7   7326  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "8   7348  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "9   7370  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "\n",
       "  NOMBRE PROVINCIA  Código Provincia NOMBRE COMUNA  Código Comuna  \\\n",
       "0        COYHAIQUE               111     COYHAIQUE          11101   \n",
       "1        COYHAIQUE               111    LAGO VERDE          11102   \n",
       "2            AYSÉN               112         AYSÉN          11201   \n",
       "3            AYSÉN               112        CISNES          11202   \n",
       "4            AYSÉN               112     GUAITECAS          11203   \n",
       "5     CAPITÁN PRAT               113      COCHRANE          11301   \n",
       "6     CAPITÁN PRAT               113     O'HIGGINS          11302   \n",
       "7     CAPITÁN PRAT               113        TORTEL          11303   \n",
       "8  GENERAL CARRERA               114   CHILE CHICO          11401   \n",
       "9  GENERAL CARRERA               114    RÍO IBÁÑEZ          11402   \n",
       "\n",
       "            Edad  Hombres  Mujeres  TOTAL  \n",
       "0  Total Comunal    28763    29055  57818  \n",
       "1  Total Comunal      494      358    852  \n",
       "2  Total Comunal    12719    11240  23959  \n",
       "3  Total Comunal     3922     2595   6517  \n",
       "4  Total Comunal     1166      677   1843  \n",
       "5  Total Comunal     1902     1588   3490  \n",
       "6  Total Comunal      374      251    625  \n",
       "7  Total Comunal      285      238    523  \n",
       "8  Total Comunal     2577     2288   4865  \n",
       "9  Total Comunal     1445     1221   2666  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pop"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "fa314d11",
   "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>Hombres</th>\n",
       "      <th>Mujeres</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE REGIÓN</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</th>\n",
       "      <td>53647</td>\n",
       "      <td>49511</td>\n",
       "      <td>103158</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           Hombres  Mujeres   TOTAL\n",
       "NOMBRE REGIÓN                                                      \n",
       "AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO    53647    49511  103158"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculo poblacion regional\n",
    "\n",
    "df_pop.groupby('NOMBRE REGIÓN')[['Hombres','Mujeres','TOTAL']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "649911ae",
   "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>Hombres</th>\n",
       "      <th>Mujeres</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE PROVINCIA</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AYSÉN</th>\n",
       "      <td>17807</td>\n",
       "      <td>14512</td>\n",
       "      <td>32319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAPITÁN PRAT</th>\n",
       "      <td>2561</td>\n",
       "      <td>2077</td>\n",
       "      <td>4638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COYHAIQUE</th>\n",
       "      <td>29257</td>\n",
       "      <td>29413</td>\n",
       "      <td>58670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GENERAL CARRERA</th>\n",
       "      <td>4022</td>\n",
       "      <td>3509</td>\n",
       "      <td>7531</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Hombres  Mujeres  TOTAL\n",
       "NOMBRE PROVINCIA                         \n",
       "AYSÉN               17807    14512  32319\n",
       "CAPITÁN PRAT         2561     2077   4638\n",
       "COYHAIQUE           29257    29413  58670\n",
       "GENERAL CARRERA      4022     3509   7531"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculo poblacion provincial\n",
    "\n",
    "df_pop.groupby('NOMBRE PROVINCIA')[['Hombres','Mujeres','TOTAL']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d40a1f8b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import janitor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9f9cfa98",
   "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>orden</th>\n",
       "      <th>nombre_region</th>\n",
       "      <th>codigo_region</th>\n",
       "      <th>nombre_provincia</th>\n",
       "      <th>codigo_provincia</th>\n",
       "      <th>nombre_comuna</th>\n",
       "      <th>codigo_comuna</th>\n",
       "      <th>edad_hombres</th>\n",
       "      <th>edad_mujeres</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7172</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>COYHAIQUE</td>\n",
       "      <td>111</td>\n",
       "      <td>COYHAIQUE</td>\n",
       "      <td>11101</td>\n",
       "      <td>28763</td>\n",
       "      <td>29055</td>\n",
       "      <td>57818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7194</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>COYHAIQUE</td>\n",
       "      <td>111</td>\n",
       "      <td>LAGO VERDE</td>\n",
       "      <td>11102</td>\n",
       "      <td>494</td>\n",
       "      <td>358</td>\n",
       "      <td>852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7216</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>112</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>11201</td>\n",
       "      <td>12719</td>\n",
       "      <td>11240</td>\n",
       "      <td>23959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7238</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>112</td>\n",
       "      <td>CISNES</td>\n",
       "      <td>11202</td>\n",
       "      <td>3922</td>\n",
       "      <td>2595</td>\n",
       "      <td>6517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7260</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>AYSÉN</td>\n",
       "      <td>112</td>\n",
       "      <td>GUAITECAS</td>\n",
       "      <td>11203</td>\n",
       "      <td>1166</td>\n",
       "      <td>677</td>\n",
       "      <td>1843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7282</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>CAPITÁN PRAT</td>\n",
       "      <td>113</td>\n",
       "      <td>COCHRANE</td>\n",
       "      <td>11301</td>\n",
       "      <td>1902</td>\n",
       "      <td>1588</td>\n",
       "      <td>3490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7304</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>CAPITÁN PRAT</td>\n",
       "      <td>113</td>\n",
       "      <td>O'HIGGINS</td>\n",
       "      <td>11302</td>\n",
       "      <td>374</td>\n",
       "      <td>251</td>\n",
       "      <td>625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7326</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>CAPITÁN PRAT</td>\n",
       "      <td>113</td>\n",
       "      <td>TORTEL</td>\n",
       "      <td>11303</td>\n",
       "      <td>285</td>\n",
       "      <td>238</td>\n",
       "      <td>523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7348</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>GENERAL CARRERA</td>\n",
       "      <td>114</td>\n",
       "      <td>CHILE CHICO</td>\n",
       "      <td>11401</td>\n",
       "      <td>2577</td>\n",
       "      <td>2288</td>\n",
       "      <td>4865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7370</td>\n",
       "      <td>AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO</td>\n",
       "      <td>11</td>\n",
       "      <td>GENERAL CARRERA</td>\n",
       "      <td>114</td>\n",
       "      <td>RÍO IBÁÑEZ</td>\n",
       "      <td>11402</td>\n",
       "      <td>1445</td>\n",
       "      <td>1221</td>\n",
       "      <td>2666</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   orden                              nombre_region  codigo_region  \\\n",
       "0   7172  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "1   7194  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "2   7216  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "3   7238  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "4   7260  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "5   7282  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "6   7304  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "7   7326  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "8   7348  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "9   7370  AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO             11   \n",
       "\n",
       "  nombre_provincia  codigo_provincia nombre_comuna  codigo_comuna  \\\n",
       "0        COYHAIQUE               111     COYHAIQUE          11101   \n",
       "1        COYHAIQUE               111    LAGO VERDE          11102   \n",
       "2            AYSÉN               112         AYSÉN          11201   \n",
       "3            AYSÉN               112        CISNES          11202   \n",
       "4            AYSÉN               112     GUAITECAS          11203   \n",
       "5     CAPITÁN PRAT               113      COCHRANE          11301   \n",
       "6     CAPITÁN PRAT               113     O'HIGGINS          11302   \n",
       "7     CAPITÁN PRAT               113        TORTEL          11303   \n",
       "8  GENERAL CARRERA               114   CHILE CHICO          11401   \n",
       "9  GENERAL CARRERA               114    RÍO IBÁÑEZ          11402   \n",
       "\n",
       "   edad_hombres  edad_mujeres  total  \n",
       "0         28763         29055  57818  \n",
       "1           494           358    852  \n",
       "2         12719         11240  23959  \n",
       "3          3922          2595   6517  \n",
       "4          1166           677   1843  \n",
       "5          1902          1588   3490  \n",
       "6           374           251    625  \n",
       "7           285           238    523  \n",
       "8          2577          2288   4865  \n",
       "9          1445          1221   2666  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pop = df_pop.clean_names().rename(columns={'hombres':'edad_hombres','mujeres':'edad_mujeres'}).drop(columns=['edad'])\n",
    "\n",
    "df_pop"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "17058419",
   "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>orden</th>\n",
       "      <th>nombre_region</th>\n",
       "      <th>codigo_region</th>\n",
       "      <th>nombre_provincia</th>\n",
       "      <th>codigo_provincia</th>\n",
       "      <th>nombre_comuna</th>\n",
       "      <th>codigo_comuna</th>\n",
       "      <th>edad_hombres</th>\n",
       "      <th>edad_mujeres</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7172</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Coyhaique</td>\n",
       "      <td>111</td>\n",
       "      <td>Coyhaique</td>\n",
       "      <td>11101</td>\n",
       "      <td>28763</td>\n",
       "      <td>29055</td>\n",
       "      <td>57818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7194</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Coyhaique</td>\n",
       "      <td>111</td>\n",
       "      <td>Lago Verde</td>\n",
       "      <td>11102</td>\n",
       "      <td>494</td>\n",
       "      <td>358</td>\n",
       "      <td>852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7216</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Aysén</td>\n",
       "      <td>112</td>\n",
       "      <td>Aysén</td>\n",
       "      <td>11201</td>\n",
       "      <td>12719</td>\n",
       "      <td>11240</td>\n",
       "      <td>23959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7238</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Aysén</td>\n",
       "      <td>112</td>\n",
       "      <td>Cisnes</td>\n",
       "      <td>11202</td>\n",
       "      <td>3922</td>\n",
       "      <td>2595</td>\n",
       "      <td>6517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7260</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Aysén</td>\n",
       "      <td>112</td>\n",
       "      <td>Guaitecas</td>\n",
       "      <td>11203</td>\n",
       "      <td>1166</td>\n",
       "      <td>677</td>\n",
       "      <td>1843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7282</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Capitán Prat</td>\n",
       "      <td>113</td>\n",
       "      <td>Cochrane</td>\n",
       "      <td>11301</td>\n",
       "      <td>1902</td>\n",
       "      <td>1588</td>\n",
       "      <td>3490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7304</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Capitán Prat</td>\n",
       "      <td>113</td>\n",
       "      <td>O'Higgins</td>\n",
       "      <td>11302</td>\n",
       "      <td>374</td>\n",
       "      <td>251</td>\n",
       "      <td>625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7326</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Capitán Prat</td>\n",
       "      <td>113</td>\n",
       "      <td>Tortel</td>\n",
       "      <td>11303</td>\n",
       "      <td>285</td>\n",
       "      <td>238</td>\n",
       "      <td>523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7348</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>General Carrera</td>\n",
       "      <td>114</td>\n",
       "      <td>Chile Chico</td>\n",
       "      <td>11401</td>\n",
       "      <td>2577</td>\n",
       "      <td>2288</td>\n",
       "      <td>4865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7370</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>General Carrera</td>\n",
       "      <td>114</td>\n",
       "      <td>Río Ibáñez</td>\n",
       "      <td>11402</td>\n",
       "      <td>1445</td>\n",
       "      <td>1221</td>\n",
       "      <td>2666</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   orden                                      nombre_region  codigo_region  \\\n",
       "0   7172  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "1   7194  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "2   7216  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "3   7238  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "4   7260  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "5   7282  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "6   7304  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "7   7326  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "8   7348  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "9   7370  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "\n",
       "  nombre_provincia  codigo_provincia nombre_comuna  codigo_comuna  \\\n",
       "0        Coyhaique               111     Coyhaique          11101   \n",
       "1        Coyhaique               111    Lago Verde          11102   \n",
       "2            Aysén               112         Aysén          11201   \n",
       "3            Aysén               112        Cisnes          11202   \n",
       "4            Aysén               112     Guaitecas          11203   \n",
       "5     Capitán Prat               113      Cochrane          11301   \n",
       "6     Capitán Prat               113     O'Higgins          11302   \n",
       "7     Capitán Prat               113        Tortel          11303   \n",
       "8  General Carrera               114   Chile Chico          11401   \n",
       "9  General Carrera               114    Río Ibáñez          11402   \n",
       "\n",
       "   edad_hombres  edad_mujeres  total  \n",
       "0         28763         29055  57818  \n",
       "1           494           358    852  \n",
       "2         12719         11240  23959  \n",
       "3          3922          2595   6517  \n",
       "4          1166           677   1843  \n",
       "5          1902          1588   3490  \n",
       "6           374           251    625  \n",
       "7           285           238    523  \n",
       "8          2577          2288   4865  \n",
       "9          1445          1221   2666  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Valores deben ser transformados de formato upper a title \n",
    "\n",
    "df_pop['nombre_region'] = df_pop['nombre_region'].str.title()\n",
    "\n",
    "df_pop['nombre_region'] = 'Región de Aysén del General Carlos Ibáñez del Campo'\n",
    "\n",
    "df_pop['nombre_provincia'] = df_pop['nombre_provincia'].str.title()\n",
    "\n",
    "df_pop['nombre_comuna'] = df_pop['nombre_comuna'].str.title()\n",
    "\n",
    "df_pop"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "75b0bb25",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Debemos eliminar tildes de los valores evitando la remoción de la virgulilla de la ñ\n",
    "\n",
    "import re\n",
    "from unicodedata import normalize\n",
    "\n",
    "def tilde_remover(x):\n",
    "    return normalize( 'NFC', re.sub(\n",
    "                r\"([^n\\u0300-\\u036f]|n(?!\\u0303(?![\\u0300-\\u036f])))[\\u0300-\\u036f]+\", r\"\\1\", \n",
    "                normalize( \"NFD\", x), 0, re.I\n",
    "            ))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "1efc3a0b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_pop['nombre_provincia'] = df_pop['nombre_provincia'].apply(lambda x: tilde_remover(x))\n",
    "\n",
    "df_pop['nombre_comuna'] = df_pop['nombre_comuna'].apply(lambda x: tilde_remover(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "144e0d24",
   "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>orden</th>\n",
       "      <th>nombre_region</th>\n",
       "      <th>codigo_region</th>\n",
       "      <th>nombre_provincia</th>\n",
       "      <th>codigo_provincia</th>\n",
       "      <th>nombre_comuna</th>\n",
       "      <th>codigo_comuna</th>\n",
       "      <th>edad_hombres</th>\n",
       "      <th>edad_mujeres</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7172</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Coyhaique</td>\n",
       "      <td>111</td>\n",
       "      <td>Coyhaique</td>\n",
       "      <td>11101</td>\n",
       "      <td>28763</td>\n",
       "      <td>29055</td>\n",
       "      <td>57818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7194</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Coyhaique</td>\n",
       "      <td>111</td>\n",
       "      <td>Lago Verde</td>\n",
       "      <td>11102</td>\n",
       "      <td>494</td>\n",
       "      <td>358</td>\n",
       "      <td>852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7216</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Aysen</td>\n",
       "      <td>112</td>\n",
       "      <td>Aysen</td>\n",
       "      <td>11201</td>\n",
       "      <td>12719</td>\n",
       "      <td>11240</td>\n",
       "      <td>23959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7238</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Aysen</td>\n",
       "      <td>112</td>\n",
       "      <td>Cisnes</td>\n",
       "      <td>11202</td>\n",
       "      <td>3922</td>\n",
       "      <td>2595</td>\n",
       "      <td>6517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7260</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Aysen</td>\n",
       "      <td>112</td>\n",
       "      <td>Guaitecas</td>\n",
       "      <td>11203</td>\n",
       "      <td>1166</td>\n",
       "      <td>677</td>\n",
       "      <td>1843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7282</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Capitan Prat</td>\n",
       "      <td>113</td>\n",
       "      <td>Cochrane</td>\n",
       "      <td>11301</td>\n",
       "      <td>1902</td>\n",
       "      <td>1588</td>\n",
       "      <td>3490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7304</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Capitan Prat</td>\n",
       "      <td>113</td>\n",
       "      <td>O'Higgins</td>\n",
       "      <td>11302</td>\n",
       "      <td>374</td>\n",
       "      <td>251</td>\n",
       "      <td>625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7326</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>Capitan Prat</td>\n",
       "      <td>113</td>\n",
       "      <td>Tortel</td>\n",
       "      <td>11303</td>\n",
       "      <td>285</td>\n",
       "      <td>238</td>\n",
       "      <td>523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7348</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>General Carrera</td>\n",
       "      <td>114</td>\n",
       "      <td>Chile Chico</td>\n",
       "      <td>11401</td>\n",
       "      <td>2577</td>\n",
       "      <td>2288</td>\n",
       "      <td>4865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7370</td>\n",
       "      <td>Región de Aysén del General Carlos Ibáñez del ...</td>\n",
       "      <td>11</td>\n",
       "      <td>General Carrera</td>\n",
       "      <td>114</td>\n",
       "      <td>Rio Ibañez</td>\n",
       "      <td>11402</td>\n",
       "      <td>1445</td>\n",
       "      <td>1221</td>\n",
       "      <td>2666</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   orden                                      nombre_region  codigo_region  \\\n",
       "0   7172  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "1   7194  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "2   7216  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "3   7238  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "4   7260  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "5   7282  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "6   7304  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "7   7326  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "8   7348  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "9   7370  Región de Aysén del General Carlos Ibáñez del ...             11   \n",
       "\n",
       "  nombre_provincia  codigo_provincia nombre_comuna  codigo_comuna  \\\n",
       "0        Coyhaique               111     Coyhaique          11101   \n",
       "1        Coyhaique               111    Lago Verde          11102   \n",
       "2            Aysen               112         Aysen          11201   \n",
       "3            Aysen               112        Cisnes          11202   \n",
       "4            Aysen               112     Guaitecas          11203   \n",
       "5     Capitan Prat               113      Cochrane          11301   \n",
       "6     Capitan Prat               113     O'Higgins          11302   \n",
       "7     Capitan Prat               113        Tortel          11303   \n",
       "8  General Carrera               114   Chile Chico          11401   \n",
       "9  General Carrera               114    Rio Ibañez          11402   \n",
       "\n",
       "   edad_hombres  edad_mujeres  total  \n",
       "0         28763         29055  57818  \n",
       "1           494           358    852  \n",
       "2         12719         11240  23959  \n",
       "3          3922          2595   6517  \n",
       "4          1166           677   1843  \n",
       "5          1902          1588   3490  \n",
       "6           374           251    625  \n",
       "7           285           238    523  \n",
       "8          2577          2288   4865  \n",
       "9          1445          1221   2666  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pop"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "f5f53737",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Se exporta el DF a CSV\n",
    "\n",
    "df_pop.to_csv('data/aysen_population.csv')"
   ]
  }
 ],
 "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.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}