1. Ajustes ENEMDU 2020.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "bf33258d",
   "metadata": {},
   "source": [
    "# Tratamiento de datos para obtener una muestra de votantes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2692fc4b",
   "metadata": {},
   "source": [
    "El estudio va a utilizar la muestra del ENEMDU del 2020, a diciembre, para simular la decisión del voto de la primera vuelta.\n",
    "La intención es usar datos de la misma encuensta a abril del 2021, para simular los de la segunda vueta de las elecciones del 2021, pero de momento no existen los identificadores de hogar en la base del INEC respectiva, como para hacerlo."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "id": "3331ddad",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importar paquetes \n",
    "\n",
    "import pandas as pd\n",
    "import pyreadstat as pyd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "id": "9a6cc20c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Crear dfs para los módulos \n",
    "\n",
    "df_persona, meta_p = pyd.read_sav('Data/Enemdu_2020/enemdu_persona_2020_12.sav', apply_value_formats=True)\n",
    "df_consumidor, meta_c = pyd.read_sav('Data/Enemdu_2020/enemdu_consumidor_2020_12.sav', apply_value_formats=True)\n",
    "df_vivienda, meta_v = pyd.read_sav('Data/Enemdu_2020/enemdu_vivienda_hogar_2020_12.sav', apply_value_formats=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "id": "f0851c2c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Vamos a decodificar el nombre de las variables\n",
    "\n",
    "df_persona.rename(columns=meta_p.column_names_to_labels, inplace=True) # meta.column_names_to_labels sirve como diccionarios\n",
    "df_consumidor.rename(columns=meta_c.column_names_to_labels, inplace=True)\n",
    "df_vivienda.rename(columns=meta_v.column_names_to_labels, inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "291b36a2",
   "metadata": {},
   "source": [
    "# Tipología del hogar, según INEC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "id": "b449ae20",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Area\n",
      "Ciudad\n",
      "Conglomerado\n",
      "Panelm\n",
      "Vivienda\n",
      "Hogar\n",
      "Persona\n",
      "Sexo\n",
      "Edad\n",
      "Relación de parentesco\n",
      "Seguro Social - Alternativa 1\n",
      "Seguro Social - Alternativa 2\n",
      "Estado civil\n",
      "Asiste a clases\n",
      "Jornada a la que asiste\n",
      "Modalidad de estudio a la que asiste\n",
      "Tipo de conexión para actividades educativas\n",
      "Razón por la que no asiste\n",
      "Nivel de instrucción\n",
      "Año aprobado\n",
      "Sabe leer y escribir\n",
      "Por sus estudios obtuvo algún título\n",
      "Qué título obtuvo\n",
      "Cómo se considera\n",
      "Donde nació\n",
      "Lugar de nacimiento\n",
      "Código del Informante\n",
      "Trabajó la semana pasada\n",
      "Actividad que realizó para ayudar en su hogar\n",
      "Tiene trabajo del cual estuvo ausente\n",
      "Razón por la que no trabajó\n",
      "Razón relacionada con el COVID19\n",
      "Continua(ó) recibiendo algún ingreso durante ausencia del trabajo\n",
      "Desde que dejó de trabajar hasta que espera regresar ¿Cuánto tiempo estará (...) ausente\n",
      "Horas de trabajo en la semana anterior\n",
      "Razón por la que trabajó menos de 40 horas\n",
      "Razón relacionada con el COVID19\n",
      "Razón por la que trabajó más de 40 horas\n",
      "Desea trabajar más horas\n",
      "Está disponible para trabajar horas adicionales\n",
      "Cuántas horas a la semana estaría disponible para trabajar\n",
      "Gestión realizada para cambiar la situación actual de trabajo\n",
      "Razón por la que busca cambiar la situación actual de trabajo\n",
      "Buscó trabajo el mes anterior\n",
      "Semanas que busca trabajo\n",
      "Razón por la que no buscó trabajo\n",
      "Razón relacionada con el COVID19\n",
      "Desea trabajar y está dispuesto a hacerlo\n",
      "Razón relacionada con el COVID19\n",
      "Condición de inactividad\n",
      "Trabajó anteriormente\n",
      "Motivos por los que dejó de trabajar\n",
      "Razón relacionada con el COVID19\n",
      "Número de semanas que no trabaja\n",
      "Rama de actividad\n",
      "Grupo de ocupación\n",
      "Categoría de ocupación\n",
      "Es socio de cooperativa o asociación\n",
      "El trabajo que tiene es\n",
      "Recibe alimentación\n",
      "Recibe vivienda\n",
      "Recibe transporte\n",
      "Recibe vacaciones\n",
      "Recibe ropa de trabajo\n",
      "Recibe seguro social\n",
      "Recibe seguro médico\n",
      "Recibe guardería\n",
      "Recibe cursos de capacitación\n",
      "Recibe 13er sueldo\n",
      "Recibe 14to sueldo\n",
      "Cuántos años trabaja\n",
      "Sitio de trabajo\n",
      "Tamaño del establecimiento\n",
      "Número personas trabajan en el establecimiento\n",
      "En el establecimiento se lleva\n",
      "El establecimiento tiene RUC\n",
      "Número de trabajos\n",
      "Horas de trabajo principal\n",
      "Horas de trabajo secundario\n",
      "Horas de otros trabajos\n",
      "Rama de actividad - trabajo secundario\n",
      "Grupo de ocupación - trabajo secundario\n",
      "Categoría de ocupación - trabajo secundario\n",
      "Es socio de cooperativa o asociación - trabajo secundario\n",
      "Sitio de trabajo secundario\n",
      "Tamaño establecimiento - trabajo secundario\n",
      "Personas que trabajan - trabajo secundario\n",
      "En el establecimiento de trabajo secundario se lleva\n",
      "El establecimiento de trabajo secundario tiene RUC\n",
      "Cómo se siente en su trabajo\n",
      "Descontento por ingresos bajos\n",
      "Descontento por muchas horas de trabajo\n",
      "Descontento por horarios inconvenientes\n",
      "Descontento por sobrecarga de trabajo\n",
      "Descontento por no tener estabilidad\n",
      "Descontento por ambiente perjudicial\n",
      "Descontento por trabajar en la calle\n",
      "Descontento por posibles accidentes\n",
      "Descontento por las activ. que realiza\n",
      "Descontento por pocas posibilidades de progreso\n",
      "Descontento por malas relaciones laborales\n",
      "A cuál de las siguientes formas de seguridad social aporta actualmente\n",
      "Dispone computador portátil o de escritorio para realizar sus actividades diarias (Educativas, laborales, recreación, etc.)\n",
      "Dispone de Tablet para realizar sus actividades diarias (Educativas, laborales, recreación, etc.)\n",
      "Dispone de Smartphone o teléfono inteligente para realizar sus actividades diarias (Educativas, laborales, recreación, etc.)\n",
      "Ingresos - Patronos Cuenta Propia\n",
      "Retiró bienes del negocio\n",
      "Monto de retiro de bienes del negocio\n",
      "Monto gastado en funcionamiento negocio\n",
      "Ingreso de asalariados y/o empleados domésticos\n",
      "Descuentos de asalariados\n",
      "Recibió ingreso en especies\n",
      "Ingreso en especies de asalariados\n",
      "Ingreso ocup. secundaria - asalariados e independientes\n",
      "Recibió pago en especies - trabajo secundario\n",
      "Pago en especies - trabajo secundario\n",
      "Recibió ingresos derivados del capital\n",
      "Ingreso recibido por transacciones de capital\n",
      "Recibe jubilación o pensiones\n",
      "Ingreso por jubilación o pensiones\n",
      "Recibió regalos o donaciones\n",
      "Ingreso por regalos o donaciones - Monto\n",
      "Recibió dinero del exterior\n",
      "Ingreso del exterior - Monto\n",
      "Recibió el Bono de Desarrollo Humano\n",
      "Monto que recibió por el Bono de Desarrollo Humano\n",
      "Recibió el Bono por discapacidad (Joaquin Gallegos Lara  - BJGL)\n",
      "Monto recibido por el Bono por discapacidad (Joaquin Gallegos Lara - BJGL)\n",
      "Recibe el BONO DE PROTECCIÓN FAMILIAR\n",
      "Monto recibido por el BONO DE PROTECCIÓN FAMILIAR\n",
      "Recibe el BONO DE APOYO NUTRICIONAL\n",
      "Monto recibido por el APOYO NUTRICIONAL\n",
      "Realizó USTED algún trabajo por paga o para obtener ganancias\n",
      "La semana pasada que no tenía trabajo - Estudió o estuvo capacitándose\n",
      "La semana pasada que no tenía trabajo - Hizo actividades de esparcimiento (deporte)\n",
      "La semana pasada que no tenía trabajo - Realizó alguna gestión para buscar trabajo\n",
      "La semana pasada que no tenía trabajo - Ayudó o se dedicó a otras labores del hogar o la familia\n",
      "La semana pasada que no tenía trabajo - Ayudó como voluntario/a\n",
      "La semana pasada que no tenía trabajo - Realizó trabajo agrícola, cría animales o pesca\n",
      "La semana pasada que no tenía trabajo - Realizó manualidades o tejidos para la venta\n",
      "La semana pasada que no tenía trabajo - Ayudó en algún negocio familiar\n",
      "La semana pasada que no tenía trabajo - Dio clases particulares, tareas dirigidas pagadas\n",
      "La semana pasada que no tenía trabajo - Realizó venta de productos por internet, catálogo o venta directa\n",
      "La semana pasada que no tenía trabajo - Otro\n",
      "El principal motivo por el que usted está sin trabajo es:\n",
      "Tiene cédula de identidad\n",
      "Ingreso Laboral\n",
      "Factor de expansión\n",
      "Condición de actividad\n",
      "Sectorización de los empleados (15 años y más)\n",
      "Población con empleo\n",
      "Población con desempleo\n",
      "Grupo de Ocupación CIUO8 (población ocupada de 15 años y más)\n",
      "Rama de Actividad CIIU4 (población ocupada de 15 años y más)\n",
      "Ingreso per cápita\n",
      "Pobreza\n",
      "Extrema Pobreza\n",
      "Nivel de instrucción\n",
      "Estratos\n",
      "Unidad primaria de muestreo\n",
      "Identificador de vivienda\n",
      "Identificador de hogar\n",
      "Identificador de persona\n",
      "Periodo\n"
     ]
    }
   ],
   "source": [
    "for i in df_persona.columns:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "id": "5d12e67c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Jefe', 'Hijo o Hija', 'Jefe', 'Cónyuge', 'Hijo o Hija', ..., 'Hijo o Hija', 'Hijo o Hija', 'Hijo o Hija', 'Hijo o Hija', 'Yerno o nuera']\n",
       "Length: 30646\n",
       "Categories (9, object): ['Cónyuge', 'Empleado(a) doméstico(a)', 'Hijo o Hija', 'Jefe', ..., 'Otros no parientes', 'Otros parientes', 'Padres o suegros', 'Yerno o nuera']"
      ]
     },
     "execution_count": 182,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Ver los posibles resultados de la Relación de parentesco\n",
    "\n",
    "df_persona['Relación de parentesco'].values"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c07eb741",
   "metadata": {},
   "source": [
    "# Número de personas según relación de parentesco"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "id": "b4b6b71b",
   "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>Identificador de hogar</th>\n",
       "      <th>Relación de parentesco</th>\n",
       "      <th>cuenta_parentesco</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Cónyuge</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Empleado(a) doméstico(a)</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Hijo o Hija</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Jefe</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Nieto o nieta</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78799</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Nieto o nieta</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78800</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Otros no parientes</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78801</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Otros parientes</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78802</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Padres o suegros</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78803</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Yerno o nuera</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>78804 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Identificador de hogar    Relación de parentesco  cuenta_parentesco\n",
       "0         010150000503009011                   Cónyuge                  1\n",
       "1         010150000503009011  Empleado(a) doméstico(a)                  0\n",
       "2         010150000503009011               Hijo o Hija                  1\n",
       "3         010150000503009011                      Jefe                  1\n",
       "4         010150000503009011             Nieto o nieta                  0\n",
       "...                      ...                       ...                ...\n",
       "78799     240350001406005071             Nieto o nieta                  1\n",
       "78800     240350001406005071        Otros no parientes                  0\n",
       "78801     240350001406005071           Otros parientes                  0\n",
       "78802     240350001406005071          Padres o suegros                  0\n",
       "78803     240350001406005071             Yerno o nuera                  0\n",
       "\n",
       "[78804 rows x 3 columns]"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c_par = df_persona.groupby(by=['Identificador de hogar', \n",
    "                               'Relación de parentesco']).size().reset_index(name='cuenta_parentesco')\n",
    "c_par\n",
    "# cuenta_parentesco es la variable que muestra el número de persona para cada relación de parentesco"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c7c43e22",
   "metadata": {},
   "source": [
    "## Número de personas en el hogar que son parientes y por género"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2cee9ace",
   "metadata": {},
   "source": [
    "Hay que tener un cuenta que ya no es posible distinguir a parientes filiales de los no fialiales, porque por ejemplo una persona del hogar puede responder que es padre (persona filial) o suegro (no filiar) del jefe de hogar. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 184,
   "id": "152285f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "c_par = c_par.pivot(index='Identificador de hogar', columns='Relación de parentesco', values='cuenta_parentesco')\n",
    "c_par = c_par.reset_index()\n",
    "c_par['Parientes'] = c_par['Nieto o nieta'] + c_par['Otros parientes'] + c_par['Padres o suegros'] + c_par['Yerno o nuera'] # Parientes no incluye hijos\n",
    "c_par['No parientes'] = c_par['Cónyuge'] + c_par['Otros no parientes']\n",
    "c_par = c_par[['Identificador de hogar', 'Cónyuge', 'Hijo o Hija', 'Parientes', 'No parientes', 'Empleado(a) doméstico(a)']]\n",
    "# Para más información revisar https://pandas.pydata.org/pandas-docs/stable/user_guide/reshaping.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "id": "e1286f97",
   "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>Relación de parentesco</th>\n",
       "      <th>Identificador de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>010150000503009021</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>010150000503009031</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010150000503009041</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>010150000503009051</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8751</th>\n",
       "      <td>240350001406005031</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8752</th>\n",
       "      <td>240350001406005041</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8753</th>\n",
       "      <td>240350001406005051</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8754</th>\n",
       "      <td>240350001406005061</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8756 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Relación de parentesco Identificador de hogar  Cónyuge  Hijo o Hija  \\\n",
       "0                          010150000503009011        1            1   \n",
       "1                          010150000503009021        0            4   \n",
       "2                          010150000503009031        0            4   \n",
       "3                          010150000503009041        1            1   \n",
       "4                          010150000503009051        1            2   \n",
       "...                                       ...      ...          ...   \n",
       "8751                       240350001406005031        0            1   \n",
       "8752                       240350001406005041        1            4   \n",
       "8753                       240350001406005051        0            1   \n",
       "8754                       240350001406005061        1            3   \n",
       "8755                       240350001406005071        1            1   \n",
       "\n",
       "Relación de parentesco  Parientes  No parientes  Empleado(a) doméstico(a)  \n",
       "0                               0             1                         0  \n",
       "1                               3             0                         0  \n",
       "2                               3             0                         0  \n",
       "3                               0             1                         0  \n",
       "4                               0             1                         0  \n",
       "...                           ...           ...                       ...  \n",
       "8751                            2             0                         0  \n",
       "8752                            0             1                         0  \n",
       "8753                            2             0                         0  \n",
       "8754                            0             1                         0  \n",
       "8755                            1             1                         0  \n",
       "\n",
       "[8756 rows x 6 columns]"
      ]
     },
     "execution_count": 185,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c_par"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "id": "1d2f4cbe",
   "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>Identificador de hogar</th>\n",
       "      <th>Género del jefe/a de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>010150000503009021</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>010150000503009031</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010150000503009041</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>010150000503009051</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8751</th>\n",
       "      <td>240350001406005031</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8752</th>\n",
       "      <td>240350001406005041</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8753</th>\n",
       "      <td>240350001406005051</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8754</th>\n",
       "      <td>240350001406005061</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8756 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Identificador de hogar Género del jefe/a de hogar  Cónyuge  Hijo o Hija  \\\n",
       "0        010150000503009011                     Hombre        1            1   \n",
       "1        010150000503009021                      Mujer        0            4   \n",
       "2        010150000503009031                      Mujer        0            4   \n",
       "3        010150000503009041                     Hombre        1            1   \n",
       "4        010150000503009051                     Hombre        1            2   \n",
       "...                     ...                        ...      ...          ...   \n",
       "8751     240350001406005031                      Mujer        0            1   \n",
       "8752     240350001406005041                     Hombre        1            4   \n",
       "8753     240350001406005051                      Mujer        0            1   \n",
       "8754     240350001406005061                     Hombre        1            3   \n",
       "8755     240350001406005071                     Hombre        1            1   \n",
       "\n",
       "      Parientes  No parientes  Empleado(a) doméstico(a)  \n",
       "0             0             1                         0  \n",
       "1             3             0                         0  \n",
       "2             3             0                         0  \n",
       "3             0             1                         0  \n",
       "4             0             1                         0  \n",
       "...         ...           ...                       ...  \n",
       "8751          2             0                         0  \n",
       "8752          0             1                         0  \n",
       "8753          2             0                         0  \n",
       "8754          0             1                         0  \n",
       "8755          1             1                         0  \n",
       "\n",
       "[8756 rows x 7 columns]"
      ]
     },
     "execution_count": 186,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Necesitamos una variable más para proceder a tipificar el hogar ecuatoriano, el género del jefe del hogar. Está codificada \n",
    "# como Sexo. \n",
    "\n",
    "gender = df_persona[df_persona['Relación de parentesco'] == 'Jefe'][['Identificador de hogar', 'Sexo']]\n",
    "c_par = c_par.merge(gender, on=['Identificador de hogar'])\n",
    "# Cambiar el orden de las columnas\n",
    "c_par = c_par.rename(columns={'Sexo': 'Género del jefe/a de hogar'})\n",
    "c_par['Género del jefe/a de hogar'] = c_par['Género del jefe/a de hogar'].str.slice(start=1) # La variable tiene un espacio innecesario\n",
    "c_par = c_par.iloc[:, [0, 6, 1, 2, 3, 4, 5]]\n",
    "c_par"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0da571ea",
   "metadata": {},
   "source": [
    "# Algorítmo de tipificación "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "id": "37b4c25a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Los nans son diferentes de 0, así que usamos un pequeños truco para cerciorarnos, ya que si el valor fuera na\n",
    "# significaría que ese tipo de variable no existe.\n",
    "\n",
    "v = ['Cónyuge', 'Hijo o Hija', 'Parientes', 'No parientes']\n",
    "for variable in v:\n",
    "    c_par[variable] = c_par[variable].fillna(0)\n",
    "\n",
    "\n",
    "# Agregamos una columna para reemplazar valor\n",
    "\n",
    "T = []\n",
    "\n",
    "for i in range(c_par.shape[0]):\n",
    "    if c_par['Cónyuge'][i] != 0:\n",
    "        if c_par['Hijo o Hija'][i] != 0:\n",
    "            if c_par['Parientes'][i] != 0:\n",
    "                if c_par['No parientes'][i] != 0:\n",
    "                    T.append('Hogar tipo 16')\n",
    "                else:\n",
    "                    T.append('Hogar tipo 6')\n",
    "            elif c_par['No parientes'][i] != 0:\n",
    "                T.append('Hogar tipo 10')\n",
    "            else:\n",
    "                T.append('Hogar tipo 2')\n",
    "        elif c_par['Parientes'][i] != 0:\n",
    "            if c_par['No parientes'][i] != 0:\n",
    "                T.append('Hogar tipo 16')\n",
    "            else:\n",
    "                T.append('Hogar tipo 7')\n",
    "        elif c_par['No parientes'][i] != 0:\n",
    "            T.append('Hogar tipo 11')\n",
    "        else:\n",
    "            T.append('Hogar tipo 3')\n",
    "    else:\n",
    "        if c_par['Hijo o Hija'][i] != 0:\n",
    "            if c_par['Parientes'][i] != 0:\n",
    "                if c_par['No parientes'][i] != 0:\n",
    "                    T.append('Hogar tipo 16')\n",
    "                else:\n",
    "                    if c_par['Género del jefe/a de hogar'][i] == 'Hombre':\n",
    "                        T.append('Hogar tipo 8')\n",
    "                    elif c_par['Género del jefe/a de hogar'][i] == 'Mujer':\n",
    "                        T.append('Hogar tipo 9')\n",
    "                    else:\n",
    "                        T.append('nan')\n",
    "            elif c_par['No parientes'][i] != 0:\n",
    "                if c_par['Género del jefe/a de hogar'][i] == 'Hombre':\n",
    "                    T.append('Hogar tipo 12')\n",
    "                elif c_par['Género del jefe/a de hogar'][i] == 'Mujer':\n",
    "                    T.append('Hogar tipo 13')\n",
    "                else:\n",
    "                    T.append('nan')\n",
    "            else:\n",
    "                if c_par['Género del jefe/a de hogar'][i] == 'Hombre':\n",
    "                    T.append('Hogar tipo 4')\n",
    "                elif c_par['Género del jefe/a de hogar'][i] == 'Mujer':\n",
    "                    T.append('Hogar tipo 5')\n",
    "                else:\n",
    "                    T.append('nan')\n",
    "        elif c_par['Parientes'][i] != 0:\n",
    "            if c_par['No parientes'][i] != 0:\n",
    "                T.append('Hogar tipo 16')\n",
    "            else:\n",
    "                T.append('Hogar tipo 14')\n",
    "        elif c_par['No parientes'][i] != 0:\n",
    "            T.append('Hogar tipo 15')\n",
    "        else:\n",
    "            T.append('Hogar tipo 1')\n",
    "\n",
    "\n",
    "# Agregar columna en la base de datos\n",
    "\n",
    "c_par['Tipology'] = T\n",
    "\n",
    "\n",
    "# c_par.to_csv('C:/Users/micha/Downloads/YAF.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "id": "70a30e65",
   "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>Identificador de hogar</th>\n",
       "      <th>Género del jefe/a de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "      <th>Tipology</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>010150000503009021</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>010150000503009031</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010150000503009041</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>010150000503009051</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8751</th>\n",
       "      <td>240350001406005031</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8752</th>\n",
       "      <td>240350001406005041</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8753</th>\n",
       "      <td>240350001406005051</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8754</th>\n",
       "      <td>240350001406005061</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8756 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Identificador de hogar Género del jefe/a de hogar  Cónyuge  Hijo o Hija  \\\n",
       "0        010150000503009011                     Hombre        1            1   \n",
       "1        010150000503009021                      Mujer        0            4   \n",
       "2        010150000503009031                      Mujer        0            4   \n",
       "3        010150000503009041                     Hombre        1            1   \n",
       "4        010150000503009051                     Hombre        1            2   \n",
       "...                     ...                        ...      ...          ...   \n",
       "8751     240350001406005031                      Mujer        0            1   \n",
       "8752     240350001406005041                     Hombre        1            4   \n",
       "8753     240350001406005051                      Mujer        0            1   \n",
       "8754     240350001406005061                     Hombre        1            3   \n",
       "8755     240350001406005071                     Hombre        1            1   \n",
       "\n",
       "      Parientes  No parientes  Empleado(a) doméstico(a)       Tipology  \n",
       "0             0             1                         0  Hogar tipo 10  \n",
       "1             3             0                         0   Hogar tipo 9  \n",
       "2             3             0                         0   Hogar tipo 9  \n",
       "3             0             1                         0  Hogar tipo 10  \n",
       "4             0             1                         0  Hogar tipo 10  \n",
       "...         ...           ...                       ...            ...  \n",
       "8751          2             0                         0   Hogar tipo 9  \n",
       "8752          0             1                         0  Hogar tipo 10  \n",
       "8753          2             0                         0   Hogar tipo 9  \n",
       "8754          0             1                         0  Hogar tipo 10  \n",
       "8755          1             1                         0  Hogar tipo 16  \n",
       "\n",
       "[8756 rows x 8 columns]"
      ]
     },
     "execution_count": 188,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c_par"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "94015b39",
   "metadata": {},
   "source": [
    "## Verificación de consistencia"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "01869e22",
   "metadata": {},
   "source": [
    "Ahora hay que verificar que todos los hogares hayan sido tipificados. Vamos a empezar creando un descriptivo del número de hogares por código de tipo."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "id": "3e84028e",
   "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>Tipology</th>\n",
       "      <th>N</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Hogar tipo 1</td>\n",
       "      <td>1161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>2914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hogar tipo 11</td>\n",
       "      <td>929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Hogar tipo 12</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hogar tipo 13</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Hogar tipo 14</td>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Hogar tipo 15</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Hogar tipo 16</td>\n",
       "      <td>1476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Hogar tipo 4</td>\n",
       "      <td>201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Hogar tipo 5</td>\n",
       "      <td>1009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Hogar tipo 8</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Hogar tipo 9</td>\n",
       "      <td>551</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Tipology     N\n",
       "0    Hogar tipo 1  1161\n",
       "1   Hogar tipo 10  2914\n",
       "2   Hogar tipo 11   929\n",
       "3   Hogar tipo 12     6\n",
       "4   Hogar tipo 13     6\n",
       "5   Hogar tipo 14   355\n",
       "6   Hogar tipo 15    31\n",
       "7   Hogar tipo 16  1476\n",
       "8    Hogar tipo 4   201\n",
       "9    Hogar tipo 5  1009\n",
       "10   Hogar tipo 8   117\n",
       "11   Hogar tipo 9   551"
      ]
     },
     "execution_count": 189,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table = c_par.groupby(by=['Tipology']).size().reset_index(name='N')\n",
    "table.sort_values('Tipology')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "24867924",
   "metadata": {},
   "source": [
    "Vamos a confirmalo verificando que el número de hogares de la base ajustada y la base bruta sean los mismo a continuación."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "id": "242312fa",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "La suma del número de hogares es igual a la cantidad de hogares de la base bruta del ENEMDU: 8756=8756\n"
     ]
    }
   ],
   "source": [
    "a = c_par.groupby(by=['Tipology']).size().sum()\n",
    "b = c_par.shape[0]\n",
    "print('La suma del número de hogares es igual a la cantidad de hogares de la base bruta del ENEMDU: ' + str(a) + '=' + str(b))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "28e0a395",
   "metadata": {},
   "source": [
    "Para ser más exhaustivos, vamos a verificar que del hogar tipo 2 que no fue tipificado no exista ni un solo caso en la base. Esto se hace filtrando la base de datos por condicionales, lo que sería equivalente a identificar todos los hogares  de tipo 2 en la base. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "id": "039b3745",
   "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>Identificador de hogar</th>\n",
       "      <th>Género del jefe/a de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "      <th>Tipology</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Identificador de hogar, Género del jefe/a de hogar, Cónyuge, Hijo o Hija, Parientes, No parientes, Empleado(a) doméstico(a), Tipology]\n",
       "Index: []"
      ]
     },
     "execution_count": 191,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c_par.loc[((c_par['Cónyuge'] != 0) & (c_par['Hijo o Hija'] != 0) & (c_par['Parientes'] == 0) & (c_par['No parientes'] == 0)), ]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "32a079cd",
   "metadata": {},
   "source": [
    "Para cerciorarnos más vamos a verificar dentro de la base si existen hogares sin parientes y no parientes donde el jefe de hogar tenga cónyuge."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "id": "b0d819ff",
   "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>Identificador de hogar</th>\n",
       "      <th>Género del jefe/a de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "      <th>Tipology</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Identificador de hogar, Género del jefe/a de hogar, Cónyuge, Hijo o Hija, Parientes, No parientes, Empleado(a) doméstico(a), Tipology]\n",
       "Index: []"
      ]
     },
     "execution_count": 192,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c_par.loc[((c_par['No parientes'] == 0) & (c_par['Parientes'] == 0) & (c_par['Cónyuge'] == 1)), ]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5bdcdefb",
   "metadata": {},
   "source": [
    "Ahora podemos estar seguros de que los cálculos implementados son correctos, pero también podemos dudar sobre la representatividad de la muestra proporcionada por el INEC."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d12708de",
   "metadata": {},
   "source": [
    "## Mapa interactivo según tipo de hogar "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "id": "1c40694c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import geopandas as gpd\n",
    "import folium "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "id": "927a7eda",
   "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>Identificador de hogar</th>\n",
       "      <th>Género del jefe/a de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "      <th>Tipology</th>\n",
       "      <th>Ciudad</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>010150000503009021</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "      <td>10150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>010150000503009031</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "      <td>10150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010150000503009041</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Identificador de hogar Género del jefe/a de hogar  Cónyuge  Hijo o Hija  \\\n",
       "0     010150000503009011                     Hombre        1            1   \n",
       "1     010150000503009021                      Mujer        0            4   \n",
       "2     010150000503009031                      Mujer        0            4   \n",
       "3     010150000503009041                     Hombre        1            1   \n",
       "\n",
       "   Parientes  No parientes  Empleado(a) doméstico(a)       Tipology Ciudad  \n",
       "0          0             1                         0  Hogar tipo 10  10150  \n",
       "1          3             0                         0   Hogar tipo 9  10150  \n",
       "2          3             0                         0   Hogar tipo 9  10150  \n",
       "3          0             1                         0  Hogar tipo 10  10150  "
      ]
     },
     "execution_count": 194,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Agregamos los códigos de ciudad en la base c_par\n",
    "\n",
    "c_par = c_par.merge(df_vivienda[['Ciudad', 'Identificador de hogar']], on='Identificador de hogar')\n",
    "c_par['Ciudad'] = c_par['Ciudad'].astype(int).astype(str)\n",
    "c_par.head(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "id": "22822ed3",
   "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>Género del jefe/a de hogar</th>\n",
       "      <th>Ciudad</th>\n",
       "      <th>Número de jefes de hogar</th>\n",
       "      <th>Número de jefas de hogar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100150</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100152</td>\n",
       "      <td>6.00</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100153</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>100157</td>\n",
       "      <td>7.00</td>\n",
       "      <td>7.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100250</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>92150</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>92250</td>\n",
       "      <td>6.00</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>92251</td>\n",
       "      <td>10.00</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>92350</td>\n",
       "      <td>9.00</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>92750</td>\n",
       "      <td>10.00</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Género del jefe/a de hogar  Ciudad  Número de jefes de hogar  \\\n",
       "0                           100150                      4.00   \n",
       "1                           100152                      6.00   \n",
       "2                           100153                      4.00   \n",
       "3                           100157                      7.00   \n",
       "4                           100250                      3.00   \n",
       "..                             ...                       ...   \n",
       "361                          92150                      5.00   \n",
       "362                          92250                      6.00   \n",
       "363                          92251                     10.00   \n",
       "364                          92350                      9.00   \n",
       "365                          92750                     10.00   \n",
       "\n",
       "Género del jefe/a de hogar  Número de jefas de hogar  \n",
       "0                                               3.00  \n",
       "1                                               1.00  \n",
       "2                                               3.00  \n",
       "3                                               7.00  \n",
       "4                                               4.00  \n",
       "..                                               ...  \n",
       "361                                             1.00  \n",
       "362                                             1.00  \n",
       "363                                             4.00  \n",
       "364                                             5.00  \n",
       "365                                             4.00  \n",
       "\n",
       "[366 rows x 3 columns]"
      ]
     },
     "execution_count": 195,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Crear una tabla que contenga el número de jefes o jefas del hogar del muestreo para la ciudad respectiva\n",
    "\n",
    "j_gender = c_par.groupby(by=['Ciudad', 'Género del jefe/a de hogar']).size().reset_index(name='Número de jefes/as de hoagr por género')\n",
    "j_gender = j_gender.pivot(index='Ciudad', columns='Género del jefe/a de hogar', values='Número de jefes/as de hoagr por género').reset_index()\n",
    "j_gender = j_gender.rename(columns={'Hombre': 'Número de jefes de hogar', 'Mujer': 'Número de jefas de hogar'})\n",
    "j_gender"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "id": "e4bb6313",
   "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>Ciudad</th>\n",
       "      <th>Número de hogares en la ciudad encuestada</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100150</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100152</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100153</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>100157</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100250</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>92150</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>92250</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>92251</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>92350</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>92750</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Ciudad  Número de hogares en la ciudad encuestada\n",
       "0    100150                                          7\n",
       "1    100152                                          7\n",
       "2    100153                                          7\n",
       "3    100157                                         14\n",
       "4    100250                                          7\n",
       "..      ...                                        ...\n",
       "361   92150                                          6\n",
       "362   92250                                          7\n",
       "363   92251                                         14\n",
       "364   92350                                         14\n",
       "365   92750                                         14\n",
       "\n",
       "[366 rows x 2 columns]"
      ]
     },
     "execution_count": 196,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Contar el número de hogares por ciudad. (Aquí es más útil usar la función count).\n",
    "\n",
    "N = c_par.groupby(by=['Ciudad'])['Identificador de hogar'].count().reset_index(name='Número de hogares en la ciudad encuestada')\n",
    "N"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "id": "0b01b7ed",
   "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>Ciudad</th>\n",
       "      <th>Hogar tipo 1</th>\n",
       "      <th>Hogar tipo 10</th>\n",
       "      <th>Hogar tipo 11</th>\n",
       "      <th>Hogar tipo 12</th>\n",
       "      <th>Hogar tipo 13</th>\n",
       "      <th>Hogar tipo 14</th>\n",
       "      <th>Hogar tipo 15</th>\n",
       "      <th>Hogar tipo 16</th>\n",
       "      <th>Hogar tipo 4</th>\n",
       "      <th>Hogar tipo 5</th>\n",
       "      <th>Hogar tipo 8</th>\n",
       "      <th>Hogar tipo 9</th>\n",
       "      <th>Número de hogares en la ciudad encuestada</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100150</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100152</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100153</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>100157</td>\n",
       "      <td>1.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100250</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>92150</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>92250</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>92251</td>\n",
       "      <td>3.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>92350</td>\n",
       "      <td>3.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>92750</td>\n",
       "      <td>4.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Ciudad  Hogar tipo 1  Hogar tipo 10  Hogar tipo 11  Hogar tipo 12  \\\n",
       "0    100150          2.00           3.00            NaN            NaN   \n",
       "1    100152          1.00           2.00           3.00            NaN   \n",
       "2    100153          1.00            NaN            NaN            NaN   \n",
       "3    100157          1.00           4.00            NaN            NaN   \n",
       "4    100250          2.00           1.00            NaN            NaN   \n",
       "..      ...           ...            ...            ...            ...   \n",
       "361   92150          1.00           1.00            NaN            NaN   \n",
       "362   92250          1.00           3.00           2.00            NaN   \n",
       "363   92251          3.00           2.00           3.00            NaN   \n",
       "364   92350          3.00           2.00           2.00            NaN   \n",
       "365   92750          4.00           5.00           1.00            NaN   \n",
       "\n",
       "     Hogar tipo 13  Hogar tipo 14  Hogar tipo 15  Hogar tipo 16  Hogar tipo 4  \\\n",
       "0              NaN            NaN            NaN           1.00           NaN   \n",
       "1              NaN            NaN            NaN           1.00           NaN   \n",
       "2              NaN           1.00            NaN           2.00           NaN   \n",
       "3              NaN            NaN            NaN           2.00          1.00   \n",
       "4              NaN            NaN            NaN           3.00           NaN   \n",
       "..             ...            ...            ...            ...           ...   \n",
       "361            NaN            NaN            NaN           3.00           NaN   \n",
       "362            NaN            NaN            NaN           1.00           NaN   \n",
       "363            NaN            NaN            NaN           2.00          1.00   \n",
       "364            NaN           1.00            NaN           2.00           NaN   \n",
       "365            NaN           1.00            NaN           3.00           NaN   \n",
       "\n",
       "     Hogar tipo 5  Hogar tipo 8  Hogar tipo 9  \\\n",
       "0            1.00           NaN           NaN   \n",
       "1             NaN           NaN           NaN   \n",
       "2            2.00           NaN          1.00   \n",
       "3            5.00           NaN          1.00   \n",
       "4            1.00           NaN           NaN   \n",
       "..            ...           ...           ...   \n",
       "361           NaN           NaN          1.00   \n",
       "362           NaN           NaN           NaN   \n",
       "363          2.00           NaN          1.00   \n",
       "364          3.00          1.00           NaN   \n",
       "365           NaN           NaN           NaN   \n",
       "\n",
       "     Número de hogares en la ciudad encuestada  \n",
       "0                                            7  \n",
       "1                                            7  \n",
       "2                                            7  \n",
       "3                                           14  \n",
       "4                                            7  \n",
       "..                                         ...  \n",
       "361                                          6  \n",
       "362                                          7  \n",
       "363                                         14  \n",
       "364                                         14  \n",
       "365                                         14  \n",
       "\n",
       "[366 rows x 14 columns]"
      ]
     },
     "execution_count": 197,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Número de hogares\n",
    "\n",
    "# Crear una tabla que contenga el número de jefes o jefas del hogar del muestreo para la ciudad respectiva\n",
    "\n",
    "N_tipo = c_par.groupby(by=['Ciudad', 'Tipology']).size().reset_index(name='Número de hogares por tipo')\n",
    "N_tipo = N_tipo.pivot(index='Ciudad', columns='Tipology', values='Número de hogares por tipo').reset_index()\n",
    "N_tipo = N_tipo.merge(N, on='Ciudad')\n",
    "N_tipo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "id": "1199aad5",
   "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>ADM3_ES</th>\n",
       "      <th>ADM3_PCODE</th>\n",
       "      <th>ADM3_REF</th>\n",
       "      <th>ADM3ALT1ES</th>\n",
       "      <th>ADM3ALT2ES</th>\n",
       "      <th>ADM2_ES</th>\n",
       "      <th>ADM2_PCODE</th>\n",
       "      <th>ADM1_ES</th>\n",
       "      <th>ADM1_PCODE</th>\n",
       "      <th>ADM0_EN</th>\n",
       "      <th>ADM0_ES</th>\n",
       "      <th>ADM0_PCODE</th>\n",
       "      <th>date</th>\n",
       "      <th>validOn</th>\n",
       "      <th>validTo</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>Shape_Area</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Ciudad</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10 de Agosto</td>\n",
       "      <td>EC131752</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Pedernales</td>\n",
       "      <td>EC1317</td>\n",
       "      <td>Manabi</td>\n",
       "      <td>EC13</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Ecuador (el)</td>\n",
       "      <td>EC</td>\n",
       "      <td>2018-12-17</td>\n",
       "      <td>2019-07-24</td>\n",
       "      <td>None</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.02</td>\n",
       "      <td>POLYGON ((-80.06370 -0.04398, -80.06400 -0.044...</td>\n",
       "      <td>131752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10 de Agosto</td>\n",
       "      <td>EC210160</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Lago Agrio</td>\n",
       "      <td>EC2101</td>\n",
       "      <td>Sucumbios</td>\n",
       "      <td>EC21</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Ecuador (el)</td>\n",
       "      <td>EC</td>\n",
       "      <td>2018-12-17</td>\n",
       "      <td>2019-07-24</td>\n",
       "      <td>None</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.00</td>\n",
       "      <td>POLYGON ((-76.89351 0.24284, -76.88845 0.22824...</td>\n",
       "      <td>210160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11 de Noviembre (Ilinchisi)</td>\n",
       "      <td>EC050157</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Latacunga</td>\n",
       "      <td>EC0501</td>\n",
       "      <td>Cotopaxi</td>\n",
       "      <td>EC05</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Ecuador (el)</td>\n",
       "      <td>EC</td>\n",
       "      <td>2018-12-17</td>\n",
       "      <td>2019-07-24</td>\n",
       "      <td>None</td>\n",
       "      <td>0.12</td>\n",
       "      <td>0.00</td>\n",
       "      <td>POLYGON ((-78.65780 -0.89633, -78.65733 -0.897...</td>\n",
       "      <td>50157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12 de Diciembre (Cab. en Achiotes)</td>\n",
       "      <td>EC111452</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Pindal</td>\n",
       "      <td>EC1114</td>\n",
       "      <td>Loja</td>\n",
       "      <td>EC11</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Ecuador (el)</td>\n",
       "      <td>EC</td>\n",
       "      <td>2018-12-17</td>\n",
       "      <td>2019-07-24</td>\n",
       "      <td>None</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.00</td>\n",
       "      <td>POLYGON ((-80.13218 -4.02787, -80.13193 -4.028...</td>\n",
       "      <td>111452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16 de Agosto</td>\n",
       "      <td>EC140455</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Palora</td>\n",
       "      <td>EC1404</td>\n",
       "      <td>Morona Santiago</td>\n",
       "      <td>EC14</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Ecuador (el)</td>\n",
       "      <td>EC</td>\n",
       "      <td>2018-12-17</td>\n",
       "      <td>2019-07-24</td>\n",
       "      <td>None</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.01</td>\n",
       "      <td>POLYGON ((-77.90145 -1.68901, -77.90020 -1.689...</td>\n",
       "      <td>140455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>27 de Abril (Cab. en la Naranja)</td>\n",
       "      <td>EC110654</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Espindola</td>\n",
       "      <td>EC1106</td>\n",
       "      <td>Loja</td>\n",
       "      <td>EC11</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>Ecuador (el)</td>\n",
       "      <td>EC</td>\n",
       "      <td>2018-12-17</td>\n",
       "      <td>2019-07-24</td>\n",
       "      <td>None</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.00</td>\n",
       "      <td>POLYGON ((-79.45788 -4.41708, -79.45780 -4.417...</td>\n",
       "      <td>110654</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              ADM3_ES ADM3_PCODE ADM3_REF ADM3ALT1ES  \\\n",
       "0                        10 de Agosto   EC131752     None       None   \n",
       "1                        10 de Agosto   EC210160     None       None   \n",
       "2         11 de Noviembre (Ilinchisi)   EC050157     None       None   \n",
       "3  12 de Diciembre (Cab. en Achiotes)   EC111452     None       None   \n",
       "4                        16 de Agosto   EC140455     None       None   \n",
       "5    27 de Abril (Cab. en la Naranja)   EC110654     None       None   \n",
       "\n",
       "  ADM3ALT2ES     ADM2_ES ADM2_PCODE          ADM1_ES ADM1_PCODE  ADM0_EN  \\\n",
       "0       None  Pedernales     EC1317           Manabi       EC13  Ecuador   \n",
       "1       None  Lago Agrio     EC2101        Sucumbios       EC21  Ecuador   \n",
       "2       None   Latacunga     EC0501         Cotopaxi       EC05  Ecuador   \n",
       "3       None      Pindal     EC1114             Loja       EC11  Ecuador   \n",
       "4       None      Palora     EC1404  Morona Santiago       EC14  Ecuador   \n",
       "5       None   Espindola     EC1106             Loja       EC11  Ecuador   \n",
       "\n",
       "        ADM0_ES ADM0_PCODE        date     validOn validTo  Shape_Leng  \\\n",
       "0  Ecuador (el)         EC  2018-12-17  2019-07-24    None        0.65   \n",
       "1  Ecuador (el)         EC  2018-12-17  2019-07-24    None        0.42   \n",
       "2  Ecuador (el)         EC  2018-12-17  2019-07-24    None        0.12   \n",
       "3  Ecuador (el)         EC  2018-12-17  2019-07-24    None        0.40   \n",
       "4  Ecuador (el)         EC  2018-12-17  2019-07-24    None        0.55   \n",
       "5  Ecuador (el)         EC  2018-12-17  2019-07-24    None        0.31   \n",
       "\n",
       "   Shape_Area                                           geometry  Ciudad  \n",
       "0        0.02  POLYGON ((-80.06370 -0.04398, -80.06400 -0.044...  131752  \n",
       "1        0.00  POLYGON ((-76.89351 0.24284, -76.88845 0.22824...  210160  \n",
       "2        0.00  POLYGON ((-78.65780 -0.89633, -78.65733 -0.897...   50157  \n",
       "3        0.00  POLYGON ((-80.13218 -4.02787, -80.13193 -4.028...  111452  \n",
       "4        0.01  POLYGON ((-77.90145 -1.68901, -77.90020 -1.689...  140455  \n",
       "5        0.00  POLYGON ((-79.45788 -4.41708, -79.45780 -4.417...  110654  "
      ]
     },
     "execution_count": 198,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Load maps\n",
    "\n",
    "mapa = gpd.read_file('Data/mapa_ecuador/', layer='ecu_admbnda_adm3_inec_20190724')\n",
    "mapa['Ciudad'] = mapa['ADM3_PCODE'].str.slice(start=2).astype(int).astype(str)\n",
    "mapa.head(6)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0064f787",
   "metadata": {},
   "source": [
    "## Mapa según número de hogares de tipo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "id": "31954e35",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ADM3_ES', 'ADM3_PCODE', 'ADM3_REF', 'ADM3ALT1ES', 'ADM3ALT2ES',\n",
       "       'ADM2_ES', 'ADM2_PCODE', 'ADM1_ES', 'ADM1_PCODE', 'ADM0_EN', 'ADM0_ES',\n",
       "       'ADM0_PCODE', 'date', 'validOn', 'validTo', 'Shape_Leng', 'Shape_Area',\n",
       "       'geometry', 'Ciudad', 'Hogar tipo 1', 'Hogar tipo 10', 'Hogar tipo 11',\n",
       "       'Hogar tipo 12', 'Hogar tipo 13', 'Hogar tipo 14', 'Hogar tipo 15',\n",
       "       'Hogar tipo 16', 'Hogar tipo 4', 'Hogar tipo 5', 'Hogar tipo 8',\n",
       "       'Hogar tipo 9', 'Número de hogares en la ciudad encuestada'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 199,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Unimos las bases\n",
    "\n",
    "mapa = mapa.merge(N_tipo, on=['Ciudad'])\n",
    "mapa.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "id": "d75a3fda",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Me quedo con las variables necesarias\n",
    "\n",
    "N_tipo = mapa[['Ciudad', 'ADM3_ES', 'Shape_Leng', 'Shape_Area',\n",
    "               'geometry', 'Hogar tipo 1', 'Hogar tipo 10', 'Hogar tipo 11',\n",
    "               'Hogar tipo 12', 'Hogar tipo 13', 'Hogar tipo 14', 'Hogar tipo 15',\n",
    "               'Hogar tipo 16', 'Hogar tipo 4', 'Hogar tipo 5', 'Hogar tipo 8',\n",
    "               'Hogar tipo 9', 'Número de hogares en la ciudad encuestada']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "id": "1b13df6f",
   "metadata": {},
   "outputs": [],
   "source": [
    "Mapa_N_tipo = N_tipo.explore(column='Número de hogares en la ciudad encuestada',  # make choropleth based on \"BoroName\" column\n",
    "                             scheme=\"naturalbreaks\",  # use mapclassify's natural breaks scheme\n",
    "                             legend=True, # show legend\n",
    "                             k=10, # use 10 bins\n",
    "                             legend_kwds=dict(colorbar=False), # do not use colorbar\n",
    "                             name=\"ADM3_ES\" # name of the layer in the map\n",
    "                            )\n",
    "\n",
    "Mapa_N_tipo.save('Maps\\hogares.html')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "799c269d",
   "metadata": {},
   "source": [
    "# Selección de la muestra "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "67d37c8a",
   "metadata": {},
   "source": [
    "El número de personas en el hogar no incluye a la empleada o empleoado doméstico. Incialmente, se había pensado incluirla, pero existen asmitreías de conexión y roles para que se puede una persona que tiene un efecto en lso otros miembros del hogar. Por ejemplo, la intención de la variable número de mujeres es medir si existe alguna tendencia de voto más progresista en el hogar, por la influencia de discursos feministas cuya probabilidad de presencia aumenta con el número de mujeres de cierto nivel de instrucción."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "id": "ea3f8119",
   "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>Identificador de hogar</th>\n",
       "      <th>Género del jefe/a de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "      <th>Tipology</th>\n",
       "      <th>Ciudad</th>\n",
       "      <th>Número de mujeres en el hogar</th>\n",
       "      <th>Número de personas del hogar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>010150000503009021</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "      <td>10150</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>010150000503009031</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "      <td>10150</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010150000503009041</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>010150000503009051</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>010150000503009081</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>010150001101005011</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 16</td>\n",
       "      <td>10150</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>010150001101005021</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>010150001101005031</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 5</td>\n",
       "      <td>10150</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>010150001101005041</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>10150</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Identificador de hogar Género del jefe/a de hogar  Cónyuge  Hijo o Hija  \\\n",
       "0     010150000503009011                     Hombre        1            1   \n",
       "1     010150000503009021                      Mujer        0            4   \n",
       "2     010150000503009031                      Mujer        0            4   \n",
       "3     010150000503009041                     Hombre        1            1   \n",
       "4     010150000503009051                     Hombre        1            2   \n",
       "5     010150000503009081                     Hombre        1            2   \n",
       "6     010150001101005011                     Hombre        1            0   \n",
       "7     010150001101005021                     Hombre        1            2   \n",
       "8     010150001101005031                      Mujer        0            3   \n",
       "9     010150001101005041                     Hombre        1            1   \n",
       "\n",
       "   Parientes  No parientes  Empleado(a) doméstico(a)       Tipology Ciudad  \\\n",
       "0          0             1                         0  Hogar tipo 10  10150   \n",
       "1          3             0                         0   Hogar tipo 9  10150   \n",
       "2          3             0                         0   Hogar tipo 9  10150   \n",
       "3          0             1                         0  Hogar tipo 10  10150   \n",
       "4          0             1                         0  Hogar tipo 10  10150   \n",
       "5          0             1                         0  Hogar tipo 10  10150   \n",
       "6          1             1                         0  Hogar tipo 16  10150   \n",
       "7          0             1                         0  Hogar tipo 10  10150   \n",
       "8          0             0                         0   Hogar tipo 5  10150   \n",
       "9          0             1                         0  Hogar tipo 10  10150   \n",
       "\n",
       "   Número de mujeres en el hogar  Número de personas del hogar  \n",
       "0                              2                             3  \n",
       "1                              4                             8  \n",
       "2                              6                             8  \n",
       "3                              1                             3  \n",
       "4                              2                             4  \n",
       "5                              2                             4  \n",
       "6                              1                             3  \n",
       "7                              3                             4  \n",
       "8                              2                             4  \n",
       "9                              2                             3  "
      ]
     },
     "execution_count": 202,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Nota: Personas que no son empleados/as domésticas. \n",
    "\n",
    "# Número de personas del hogar\n",
    "a = df_persona.loc[df_persona['Relación de parentesco'] != 'Empleado(a) doméstico(a)', ].groupby(['Identificador de hogar'])['Identificador de persona'].size().reset_index(name='Número de personas del hogar')\n",
    "# Número de mujeres del hogar\n",
    "b = df_persona.loc[( ( df_persona['Relación de parentesco'] != 'Empleado(a) doméstico(a)' ) & ( df_persona['Sexo'] == ' Mujer' ) ), ].groupby(['Identificador de hogar']).size().reset_index(name='Número de mujeres en el hogar')\n",
    "# Junte de a y b\n",
    "N_m = b.merge(a, on='Identificador de hogar')\n",
    "Muestra = c_par.merge(N_m, on=['Identificador de hogar'])\n",
    "Muestra.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "26bc7084",
   "metadata": {},
   "source": [
    "# Selección de variables, módulo persona"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "id": "72f6a8d7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Area',\n",
       " 'Ciudad',\n",
       " 'Conglomerado',\n",
       " 'Panelm',\n",
       " 'Vivienda',\n",
       " 'Hogar',\n",
       " 'Persona',\n",
       " 'Sexo',\n",
       " 'Edad',\n",
       " 'Relación de parentesco',\n",
       " 'Seguro Social - Alternativa 1',\n",
       " 'Seguro Social - Alternativa 2',\n",
       " 'Estado civil',\n",
       " 'Asiste a clases',\n",
       " 'Jornada a la que asiste',\n",
       " 'Modalidad de estudio a la que asiste',\n",
       " 'Tipo de conexión para actividades educativas',\n",
       " 'Razón por la que no asiste',\n",
       " 'Nivel de instrucción',\n",
       " 'Año aprobado',\n",
       " 'Sabe leer y escribir',\n",
       " 'Por sus estudios obtuvo algún título',\n",
       " 'Qué título obtuvo',\n",
       " 'Cómo se considera',\n",
       " 'Donde nació',\n",
       " 'Lugar de nacimiento',\n",
       " 'Código del Informante',\n",
       " 'Trabajó la semana pasada',\n",
       " 'Actividad que realizó para ayudar en su hogar',\n",
       " 'Tiene trabajo del cual estuvo ausente',\n",
       " 'Razón por la que no trabajó',\n",
       " 'Razón relacionada con el COVID19',\n",
       " 'Continua(ó) recibiendo algún ingreso durante ausencia del trabajo',\n",
       " 'Desde que dejó de trabajar hasta que espera regresar ¿Cuánto tiempo estará (...) ausente',\n",
       " 'Horas de trabajo en la semana anterior',\n",
       " 'Razón por la que trabajó menos de 40 horas',\n",
       " 'Razón relacionada con el COVID19',\n",
       " 'Razón por la que trabajó más de 40 horas',\n",
       " 'Desea trabajar más horas',\n",
       " 'Está disponible para trabajar horas adicionales',\n",
       " 'Cuántas horas a la semana estaría disponible para trabajar',\n",
       " 'Gestión realizada para cambiar la situación actual de trabajo',\n",
       " 'Razón por la que busca cambiar la situación actual de trabajo',\n",
       " 'Buscó trabajo el mes anterior',\n",
       " 'Semanas que busca trabajo',\n",
       " 'Razón por la que no buscó trabajo',\n",
       " 'Razón relacionada con el COVID19',\n",
       " 'Desea trabajar y está dispuesto a hacerlo',\n",
       " 'Razón relacionada con el COVID19',\n",
       " 'Condición de inactividad',\n",
       " 'Trabajó anteriormente',\n",
       " 'Motivos por los que dejó de trabajar',\n",
       " 'Razón relacionada con el COVID19',\n",
       " 'Número de semanas que no trabaja',\n",
       " 'Rama de actividad',\n",
       " 'Grupo de ocupación',\n",
       " 'Categoría de ocupación',\n",
       " 'Es socio de cooperativa o asociación',\n",
       " 'El trabajo que tiene es',\n",
       " 'Recibe alimentación',\n",
       " 'Recibe vivienda',\n",
       " 'Recibe transporte',\n",
       " 'Recibe vacaciones',\n",
       " 'Recibe ropa de trabajo',\n",
       " 'Recibe seguro social',\n",
       " 'Recibe seguro médico',\n",
       " 'Recibe guardería',\n",
       " 'Recibe cursos de capacitación',\n",
       " 'Recibe 13er sueldo',\n",
       " 'Recibe 14to sueldo',\n",
       " 'Cuántos años trabaja',\n",
       " 'Sitio de trabajo',\n",
       " 'Tamaño del establecimiento',\n",
       " 'Número personas trabajan en el establecimiento',\n",
       " 'En el establecimiento se lleva',\n",
       " 'El establecimiento tiene RUC',\n",
       " 'Número de trabajos',\n",
       " 'Horas de trabajo principal',\n",
       " 'Horas de trabajo secundario',\n",
       " 'Horas de otros trabajos',\n",
       " 'Rama de actividad - trabajo secundario',\n",
       " 'Grupo de ocupación - trabajo secundario',\n",
       " 'Categoría de ocupación - trabajo secundario',\n",
       " 'Es socio de cooperativa o asociación - trabajo secundario',\n",
       " 'Sitio de trabajo secundario',\n",
       " 'Tamaño establecimiento - trabajo secundario',\n",
       " 'Personas que trabajan - trabajo secundario',\n",
       " 'En el establecimiento de trabajo secundario se lleva',\n",
       " 'El establecimiento de trabajo secundario tiene RUC',\n",
       " 'Cómo se siente en su trabajo',\n",
       " 'Descontento por ingresos bajos',\n",
       " 'Descontento por muchas horas de trabajo',\n",
       " 'Descontento por horarios inconvenientes',\n",
       " 'Descontento por sobrecarga de trabajo',\n",
       " 'Descontento por no tener estabilidad',\n",
       " 'Descontento por ambiente perjudicial',\n",
       " 'Descontento por trabajar en la calle',\n",
       " 'Descontento por posibles accidentes',\n",
       " 'Descontento por las activ. que realiza',\n",
       " 'Descontento por pocas posibilidades de progreso',\n",
       " 'Descontento por malas relaciones laborales',\n",
       " 'A cuál de las siguientes formas de seguridad social aporta actualmente',\n",
       " 'Dispone computador portátil o de escritorio para realizar sus actividades diarias (Educativas, laborales, recreación, etc.)',\n",
       " 'Dispone de Tablet para realizar sus actividades diarias (Educativas, laborales, recreación, etc.)',\n",
       " 'Dispone de Smartphone o teléfono inteligente para realizar sus actividades diarias (Educativas, laborales, recreación, etc.)',\n",
       " 'Ingresos - Patronos Cuenta Propia',\n",
       " 'Retiró bienes del negocio',\n",
       " 'Monto de retiro de bienes del negocio',\n",
       " 'Monto gastado en funcionamiento negocio',\n",
       " 'Ingreso de asalariados y/o empleados domésticos',\n",
       " 'Descuentos de asalariados',\n",
       " 'Recibió ingreso en especies',\n",
       " 'Ingreso en especies de asalariados',\n",
       " 'Ingreso ocup. secundaria - asalariados e independientes',\n",
       " 'Recibió pago en especies - trabajo secundario',\n",
       " 'Pago en especies - trabajo secundario',\n",
       " 'Recibió ingresos derivados del capital',\n",
       " 'Ingreso recibido por transacciones de capital',\n",
       " 'Recibe jubilación o pensiones',\n",
       " 'Ingreso por jubilación o pensiones',\n",
       " 'Recibió regalos o donaciones',\n",
       " 'Ingreso por regalos o donaciones - Monto',\n",
       " 'Recibió dinero del exterior',\n",
       " 'Ingreso del exterior - Monto',\n",
       " 'Recibió el Bono de Desarrollo Humano',\n",
       " 'Monto que recibió por el Bono de Desarrollo Humano',\n",
       " 'Recibió el Bono por discapacidad (Joaquin Gallegos Lara  - BJGL)',\n",
       " 'Monto recibido por el Bono por discapacidad (Joaquin Gallegos Lara - BJGL)',\n",
       " 'Recibe el BONO DE PROTECCIÓN FAMILIAR',\n",
       " 'Monto recibido por el BONO DE PROTECCIÓN FAMILIAR',\n",
       " 'Recibe el BONO DE APOYO NUTRICIONAL',\n",
       " 'Monto recibido por el APOYO NUTRICIONAL',\n",
       " 'Realizó USTED algún trabajo por paga o para obtener ganancias',\n",
       " 'La semana pasada que no tenía trabajo - Estudió o estuvo capacitándose',\n",
       " 'La semana pasada que no tenía trabajo - Hizo actividades de esparcimiento (deporte)',\n",
       " 'La semana pasada que no tenía trabajo - Realizó alguna gestión para buscar trabajo',\n",
       " 'La semana pasada que no tenía trabajo - Ayudó o se dedicó a otras labores del hogar o la familia',\n",
       " 'La semana pasada que no tenía trabajo - Ayudó como voluntario/a',\n",
       " 'La semana pasada que no tenía trabajo - Realizó trabajo agrícola, cría animales o pesca',\n",
       " 'La semana pasada que no tenía trabajo - Realizó manualidades o tejidos para la venta',\n",
       " 'La semana pasada que no tenía trabajo - Ayudó en algún negocio familiar',\n",
       " 'La semana pasada que no tenía trabajo - Dio clases particulares, tareas dirigidas pagadas',\n",
       " 'La semana pasada que no tenía trabajo - Realizó venta de productos por internet, catálogo o venta directa',\n",
       " 'La semana pasada que no tenía trabajo - Otro',\n",
       " 'El principal motivo por el que usted está sin trabajo es:',\n",
       " 'Tiene cédula de identidad',\n",
       " 'Ingreso Laboral',\n",
       " 'Factor de expansión',\n",
       " 'Condición de actividad',\n",
       " 'Sectorización de los empleados (15 años y más)',\n",
       " 'Población con empleo',\n",
       " 'Población con desempleo',\n",
       " 'Grupo de Ocupación CIUO8 (población ocupada de 15 años y más)',\n",
       " 'Rama de Actividad CIIU4 (población ocupada de 15 años y más)',\n",
       " 'Ingreso per cápita',\n",
       " 'Pobreza',\n",
       " 'Extrema Pobreza',\n",
       " 'Nivel de instrucción',\n",
       " 'Estratos',\n",
       " 'Unidad primaria de muestreo',\n",
       " 'Identificador de vivienda',\n",
       " 'Identificador de hogar',\n",
       " 'Identificador de persona',\n",
       " 'Periodo']"
      ]
     },
     "execution_count": 203,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[f for f in df_persona.columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 204,
   "id": "4f2229d3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Area',\n",
       " 'Ciudad',\n",
       " 'Sexo',\n",
       " 'Edad',\n",
       " 'Seguro Social - Alternativa 1',\n",
       " 'Seguro Social - Alternativa 2',\n",
       " 'Estado civil',\n",
       " 'Nivel de instrucción',\n",
       " 'Cómo se considera',\n",
       " 'Trabajó la semana pasada',\n",
       " 'Continua(ó) recibiendo algún ingreso durante ausencia del trabajoSemanas que busca trabajo',\n",
       " 'Desea trabajar y está dispuesto a hacerlo',\n",
       " 'Condición de inactividad',\n",
       " 'Rama de actividad',\n",
       " 'Grupo de ocupación',\n",
       " 'Categoría de ocupación',\n",
       " 'Recibe alimentación',\n",
       " 'Recibe vivienda',\n",
       " 'Recibe transporte',\n",
       " 'Recibe vacaciones',\n",
       " 'Recibe ropa de trabajo',\n",
       " 'Recibe seguro social',\n",
       " 'Recibe seguro médico',\n",
       " 'Recibe guardería',\n",
       " 'Recibe cursos de capacitación',\n",
       " 'Recibe 13er sueldo',\n",
       " 'Recibe 14to sueldo',\n",
       " 'Cuántos años trabaja',\n",
       " 'Condición de actividad',\n",
       " 'Ingreso Laboral',\n",
       " 'Grupo de Ocupación CIUO8 (población ocupada de 15 años y más)',\n",
       " 'Rama de Actividad CIIU4 (población ocupada de 15 años y más)',\n",
       " 'Ingreso per cápita',\n",
       " 'Pobreza',\n",
       " 'Extrema Pobreza',\n",
       " 'Nivel de instrucción',\n",
       " 'Identificador de persona']"
      ]
     },
     "execution_count": 204,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "['Area', \n",
    " 'Ciudad', \n",
    " 'Sexo', \n",
    " 'Edad', \n",
    " 'Seguro Social - Alternativa 1', # Ver si es seguro social del jefe\n",
    " 'Seguro Social - Alternativa 2', # Ver si es seguro social de la cónyuge\n",
    " 'Estado civil', \n",
    " 'Nivel de instrucción',\n",
    " 'Cómo se considera',\n",
    " 'Trabajó la semana pasada', # ** Trabajo --\n",
    " 'Continua(ó) recibiendo algún ingreso durante ausencia del trabajo'\n",
    " 'Semanas que busca trabajo',\n",
    " 'Desea trabajar y está dispuesto a hacerlo',\n",
    " 'Condición de inactividad', \n",
    " 'Rama de actividad',\n",
    " 'Grupo de ocupación',\n",
    " 'Categoría de ocupación', \n",
    " 'Recibe alimentación',\n",
    " 'Recibe vivienda',\n",
    " 'Recibe transporte',\n",
    " 'Recibe vacaciones',\n",
    " 'Recibe ropa de trabajo',\n",
    " 'Recibe seguro social',\n",
    " 'Recibe seguro médico',\n",
    " 'Recibe guardería',\n",
    " 'Recibe cursos de capacitación',\n",
    " 'Recibe 13er sueldo',\n",
    " 'Recibe 14to sueldo',\n",
    " 'Cuántos años trabaja',\n",
    " 'Condición de actividad',\n",
    " 'Ingreso Laboral', \n",
    " 'Grupo de Ocupación CIUO8 (población ocupada de 15 años y más)',\n",
    " 'Rama de Actividad CIIU4 (población ocupada de 15 años y más)',\n",
    " 'Ingreso per cápita',\n",
    " 'Pobreza',\n",
    " 'Extrema Pobreza',\n",
    " 'Nivel de instrucción',\n",
    " 'Identificador de persona'] "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7d23d70a",
   "metadata": {},
   "source": [
    "'Cómo se considera' es etnia (mestizo, mulato, etc)."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ca70817e",
   "metadata": {},
   "source": [
    "## Lista a tener en cuenta\n",
    "Estas variables aparentan la mayor relevancia:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "id": "568e60f5",
   "metadata": {},
   "outputs": [],
   "source": [
    "persona_variables = ['Identificador de persona',\n",
    "                     'Identificador de hogar',\n",
    "                     'Area', \n",
    "                     'Ciudad', \n",
    "                     'Sexo',\n",
    "                     'Edad',\n",
    "                     'Seguro Social - Alternativa 1', # Ver si es seguro social del jefe\n",
    "                     'Seguro Social - Alternativa 2', # Ver si es seguro social de la cónyuge\n",
    "                     'Estado civil', \n",
    "                     'Nivel de instrucción',\n",
    "                     'Cómo se considera',\n",
    "                     'Condición de inactividad', \n",
    "                     'Categoría de ocupación',\n",
    "                     'Cuántos años trabaja',\n",
    "                     'Condición de actividad',\n",
    "                     'Ingreso Laboral',\n",
    "                     'Grupo de Ocupación CIUO8 (población ocupada de 15 años y más)',\n",
    "                     'Rama de Actividad CIIU4 (población ocupada de 15 años y más)',\n",
    "                     'Ingreso per cápita', \n",
    "                     'Pobreza',\n",
    "                     'Extrema Pobreza'] \n",
    "\n",
    "# El ingreso per cápita por el número de miembros del hogar es el ingreso familar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "id": "b951bb95",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Hay dos variables de nombre Nivel de instrucción y vamos a eleminar la primera, porque la segunda contiene\n",
    "# mejor detalle. La columna nivel de instrucción es la 9, y es la que vamos a eliminar:\n",
    "\n",
    "df_persona = df_persona.drop([9])\n",
    "persona_variables = df_persona[persona_variables]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fc302fcf",
   "metadata": {},
   "source": [
    "Ahora, vamos a seleccionar variables de interés de los módulos consumidor y vivienda."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "id": "0b3ea915",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Módulo vivienda\n",
    "\n",
    "variables_vivienda = df_vivienda[['Identificador de hogar', 'Forma de tenencia de la vivienda']] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "id": "223e473d",
   "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>Identificador de hogar</th>\n",
       "      <th>Con relación al mes anterior, la situación económica de su hogar es:</th>\n",
       "      <th>Cómo cree usted que será la situación económica de su hogar dentro de los próximos 3 meses:</th>\n",
       "      <th>Planea usted o algún miembro del hogar adquirir un vehículo en los próximos 3 meses</th>\n",
       "      <th>Planea usted o algún miembro del hogar adquirir un inmueble (casa, departamento, pieza) en los próximos 3 meses</th>\n",
       "      <th>Usted o algún miembro del hogar tiene planes de endeudamiento en los próximos 3 meses (bancos, financieras, etc.)</th>\n",
       "      <th>Con relación al mes anterior, la situación económica del país es:</th>\n",
       "      <th>Usted considera que durante los próximos 3 meses la situación económica del país será:</th>\n",
       "      <th>En los 3 meses anteriores, considera que la situación en Ecuador para encontrar/mejorar un puesto de trabajo es:</th>\n",
       "      <th>Considera usted que la situación en Ecuador para encontrar/mejorar un puesto de trabajo dentro de 3 meses será:</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>010150000503009011</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>010150000503009021</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Igual</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>010150000503009031</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Mejor</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010150000503009041</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Mejor</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>010150000503009051</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8751</th>\n",
       "      <td>240350001406005031</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Peor</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8752</th>\n",
       "      <td>240350001406005041</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8753</th>\n",
       "      <td>240350001406005051</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Igual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8754</th>\n",
       "      <td>240350001406005061</td>\n",
       "      <td>Igual</td>\n",
       "      <td>Igual</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>240350001406005071</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Igual</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "      <td>Peor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8756 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Identificador de hogar  \\\n",
       "0        010150000503009011   \n",
       "1        010150000503009021   \n",
       "2        010150000503009031   \n",
       "3        010150000503009041   \n",
       "4        010150000503009051   \n",
       "...                     ...   \n",
       "8751     240350001406005031   \n",
       "8752     240350001406005041   \n",
       "8753     240350001406005051   \n",
       "8754     240350001406005061   \n",
       "8755     240350001406005071   \n",
       "\n",
       "     Con relación al mes anterior, la situación económica de su hogar es:  \\\n",
       "0                                                 Igual                     \n",
       "1                                                  Peor                     \n",
       "2                                                  Peor                     \n",
       "3                                                  Peor                     \n",
       "4                                                 Igual                     \n",
       "...                                                 ...                     \n",
       "8751                                              Igual                     \n",
       "8752                                               Peor                     \n",
       "8753                                              Igual                     \n",
       "8754                                              Igual                     \n",
       "8755                                               Peor                     \n",
       "\n",
       "     Cómo cree usted que será la situación económica de su hogar dentro de los próximos 3 meses:  \\\n",
       "0                                                 Igual                                            \n",
       "1                                                 Igual                                            \n",
       "2                                                 Mejor                                            \n",
       "3                                                 Mejor                                            \n",
       "4                                                 Igual                                            \n",
       "...                                                 ...                                            \n",
       "8751                                               Peor                                            \n",
       "8752                                               Peor                                            \n",
       "8753                                              Igual                                            \n",
       "8754                                              Igual                                            \n",
       "8755                                              Igual                                            \n",
       "\n",
       "     Planea usted o algún miembro del hogar adquirir un vehículo en los próximos 3 meses  \\\n",
       "0                                                    No                                    \n",
       "1                                                    No                                    \n",
       "2                                                    No                                    \n",
       "3                                                    No                                    \n",
       "4                                                    No                                    \n",
       "...                                                 ...                                    \n",
       "8751                                                 No                                    \n",
       "8752                                                 No                                    \n",
       "8753                                                 No                                    \n",
       "8754                                                 No                                    \n",
       "8755                                                 No                                    \n",
       "\n",
       "     Planea usted o algún miembro del hogar adquirir un inmueble (casa, departamento, pieza) en los próximos 3 meses  \\\n",
       "0                                                    No                                                                \n",
       "1                                                    No                                                                \n",
       "2                                                    No                                                                \n",
       "3                                                    No                                                                \n",
       "4                                                    No                                                                \n",
       "...                                                 ...                                                                \n",
       "8751                                                 No                                                                \n",
       "8752                                                 No                                                                \n",
       "8753                                                 No                                                                \n",
       "8754                                                 No                                                                \n",
       "8755                                                 No                                                                \n",
       "\n",
       "     Usted o algún miembro del hogar tiene planes de endeudamiento en los próximos 3 meses (bancos, financieras, etc.)  \\\n",
       "0                                                    No                                                                  \n",
       "1                                                    No                                                                  \n",
       "2                                                    No                                                                  \n",
       "3                                                    No                                                                  \n",
       "4                                                    No                                                                  \n",
       "...                                                 ...                                                                  \n",
       "8751                                                 No                                                                  \n",
       "8752                                                 No                                                                  \n",
       "8753                                                 No                                                                  \n",
       "8754                                                 No                                                                  \n",
       "8755                                                 No                                                                  \n",
       "\n",
       "     Con relación al mes anterior, la situación económica del país es:  \\\n",
       "0                                                 Igual                  \n",
       "1                                                  Peor                  \n",
       "2                                                  Peor                  \n",
       "3                                                 Igual                  \n",
       "4                                                  Peor                  \n",
       "...                                                 ...                  \n",
       "8751                                               Peor                  \n",
       "8752                                               Peor                  \n",
       "8753                                              Igual                  \n",
       "8754                                               Peor                  \n",
       "8755                                               Peor                  \n",
       "\n",
       "     Usted considera que durante los próximos 3 meses la situación económica del país será:  \\\n",
       "0                                                 Igual                                       \n",
       "1                                                  Peor                                       \n",
       "2                                                 Igual                                       \n",
       "3                                                 Igual                                       \n",
       "4                                                  Peor                                       \n",
       "...                                                 ...                                       \n",
       "8751                                               Peor                                       \n",
       "8752                                               Peor                                       \n",
       "8753                                              Igual                                       \n",
       "8754                                               Peor                                       \n",
       "8755                                               Peor                                       \n",
       "\n",
       "     En los 3 meses anteriores, considera que la situación en Ecuador para encontrar/mejorar un puesto de trabajo es:  \\\n",
       "0                                                 Igual                                                                 \n",
       "1                                                  Peor                                                                 \n",
       "2                                                  Peor                                                                 \n",
       "3                                                  Peor                                                                 \n",
       "4                                                  Peor                                                                 \n",
       "...                                                 ...                                                                 \n",
       "8751                                               Peor                                                                 \n",
       "8752                                               Peor                                                                 \n",
       "8753                                               Peor                                                                 \n",
       "8754                                               Peor                                                                 \n",
       "8755                                               Peor                                                                 \n",
       "\n",
       "     Considera usted que la situación en Ecuador para encontrar/mejorar un puesto de trabajo dentro de 3 meses será:  \n",
       "0                                                 Igual                                                               \n",
       "1                                                  Peor                                                               \n",
       "2                                                  Peor                                                               \n",
       "3                                                  Peor                                                               \n",
       "4                                                  Peor                                                               \n",
       "...                                                 ...                                                               \n",
       "8751                                               Peor                                                               \n",
       "8752                                               Peor                                                               \n",
       "8753                                              Igual                                                               \n",
       "8754                                               Peor                                                               \n",
       "8755                                               Peor                                                               \n",
       "\n",
       "[8756 rows x 10 columns]"
      ]
     },
     "execution_count": 208,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Módulo consumo\n",
    "\n",
    "variables_consumo = ['Con relación al mes anterior, la situación económica de su hogar es:',\n",
    "                     'Cómo cree usted que será la situación económica de su hogar dentro de los próximos 3 meses:',\n",
    "                     'Planea usted o algún miembro del hogar adquirir un vehículo en los próximos 3 meses',\n",
    "                     'Planea usted o algún miembro del hogar adquirir un inmueble (casa, departamento, pieza) en los próximos 3 meses',\n",
    "                     'Usted o algún miembro del hogar tiene planes de endeudamiento en los próximos 3 meses (bancos, financieras, etc.)',\n",
    "                     'Con relación al mes anterior, la situación económica del país es:',\n",
    "                     'Usted considera que durante los próximos 3 meses la situación económica del país será:',\n",
    "                     'En los 3 meses anteriores, considera que la situación en Ecuador para encontrar/mejorar un puesto de trabajo es:',\n",
    "                     'Considera usted que la situación en Ecuador para encontrar/mejorar un puesto de trabajo dentro de 3 meses será:'\n",
    "                     ] \n",
    "\n",
    "\n",
    "variables_consumo = df_consumidor[['Identificador de hogar']+variables_consumo]\n",
    "variables_consumo\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "39f43536",
   "metadata": {},
   "source": [
    "### Muestra para el estudio *¿Por quién votan los ecuatorianos y por qué? Factores sociales, económicos y demográficos.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "id": "9bcce1b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "persona_variables = persona_variables.merge(variables_vivienda, on=['Identificador de hogar'])\n",
    "persona_variables = persona_variables.merge(variables_consumo, on=['Identificador de hogar'])\n",
    "\n",
    "# Ya que los votantes son mayores de 16 años debido al voto facultativo, vamos a filtrar la base para\n",
    "# poder identificar a los potenciales votantes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "id": "ac0ec8eb",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\micha\\Documents\\Electoral\\Electoral\\lib\\site-packages\\pandas\\core\\generic.py:6619: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  return self._update_inplace(result)\n"
     ]
    }
   ],
   "source": [
    "# Hay un problema que resolver antes: la variable edad está codificada como categoría.\n",
    "\n",
    "persona_variables['Edad'].replace({' 98 y más': '99'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "id": "1eeab558",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Volvemos la variable float\n",
    "\n",
    "persona_variables['Edad'] = persona_variables['Edad'].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "id": "9510c810",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Finalmete filtramos la base de datos\n",
    "\n",
    "persona_variables = persona_variables[persona_variables['Edad'] >= 16]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "id": "a51e50af",
   "metadata": {},
   "outputs": [],
   "source": [
    "persona_variables = persona_variables.merge(Muestra, on='Identificador de hogar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 214,
   "id": "9bc03a1d",
   "metadata": {},
   "outputs": [],
   "source": [
    "persona_variables = persona_variables.drop(columns=['Ciudad_x'])\n",
    "persona_variables.rename(columns={'Ciudad_y': 'Ciudad'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "id": "3baf352a",
   "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>Identificador de persona</th>\n",
       "      <th>Identificador de hogar</th>\n",
       "      <th>Area</th>\n",
       "      <th>Sexo</th>\n",
       "      <th>Edad</th>\n",
       "      <th>Seguro Social - Alternativa 1</th>\n",
       "      <th>Seguro Social - Alternativa 2</th>\n",
       "      <th>Estado civil</th>\n",
       "      <th>Nivel de instrucción</th>\n",
       "      <th>Nivel de instrucción</th>\n",
       "      <th>...</th>\n",
       "      <th>Género del jefe/a de hogar</th>\n",
       "      <th>Cónyuge</th>\n",
       "      <th>Hijo o Hija</th>\n",
       "      <th>Parientes</th>\n",
       "      <th>No parientes</th>\n",
       "      <th>Empleado(a) doméstico(a)</th>\n",
       "      <th>Tipology</th>\n",
       "      <th>Ciudad</th>\n",
       "      <th>Número de mujeres en el hogar</th>\n",
       "      <th>Número de personas del hogar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20025000002200502101</td>\n",
       "      <td>200250000022005021</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>55.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Separado(a)</td>\n",
       "      <td>Secundaria</td>\n",
       "      <td>Educación Básica</td>\n",
       "      <td>...</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 5</td>\n",
       "      <td>200250</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20025000002200502102</td>\n",
       "      <td>200250000022005021</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>39.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Soltero(a)</td>\n",
       "      <td>Secundaria</td>\n",
       "      <td>Educación Básica</td>\n",
       "      <td>...</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 5</td>\n",
       "      <td>200250</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20025000002200503101</td>\n",
       "      <td>200250000022005031</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>30.00</td>\n",
       "      <td>IESS, seguro general voluntario</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Casado(a)</td>\n",
       "      <td>Superior Universitario</td>\n",
       "      <td>Superior</td>\n",
       "      <td>...</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>200250</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20025000002200503102</td>\n",
       "      <td>200250000022005031</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>33.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Casado(a)</td>\n",
       "      <td>Superior Universitario</td>\n",
       "      <td>Superior</td>\n",
       "      <td>...</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 10</td>\n",
       "      <td>200250</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20025000002200505101</td>\n",
       "      <td>200250000022005051</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>58.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Divorciado(a)</td>\n",
       "      <td>Secundaria</td>\n",
       "      <td>Educación Media/Bachillerato</td>\n",
       "      <td>...</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 9</td>\n",
       "      <td>200250</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21828</th>\n",
       "      <td>05015091010200909101</td>\n",
       "      <td>050150910102009091</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>48.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Casado(a)</td>\n",
       "      <td>Primaria</td>\n",
       "      <td>Educación Básica</td>\n",
       "      <td>...</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 16</td>\n",
       "      <td>50150</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21829</th>\n",
       "      <td>05015091010200909102</td>\n",
       "      <td>050150910102009091</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>45.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Casado(a)</td>\n",
       "      <td>Primaria</td>\n",
       "      <td>Educación Básica</td>\n",
       "      <td>...</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 16</td>\n",
       "      <td>50150</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21830</th>\n",
       "      <td>05015091010200909103</td>\n",
       "      <td>050150910102009091</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>21.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Soltero(a)</td>\n",
       "      <td>Educación  Media</td>\n",
       "      <td>Educación Media/Bachillerato</td>\n",
       "      <td>...</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 16</td>\n",
       "      <td>50150</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21831</th>\n",
       "      <td>05015091010200909104</td>\n",
       "      <td>050150910102009091</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>17.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Unión libre</td>\n",
       "      <td>Educación  Media</td>\n",
       "      <td>Educación Media/Bachillerato</td>\n",
       "      <td>...</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 16</td>\n",
       "      <td>50150</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21832</th>\n",
       "      <td>05015091010200909107</td>\n",
       "      <td>050150910102009091</td>\n",
       "      <td>Rural</td>\n",
       "      <td>Mujer</td>\n",
       "      <td>20.00</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Ninguno</td>\n",
       "      <td>Unión libre</td>\n",
       "      <td>Educación  Media</td>\n",
       "      <td>Educación Media/Bachillerato</td>\n",
       "      <td>...</td>\n",
       "      <td>Hombre</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hogar tipo 16</td>\n",
       "      <td>50150</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21833 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Identificador de persona Identificador de hogar    Area     Sexo  Edad  \\\n",
       "0         20025000002200502101     200250000022005021   Rural    Mujer 55.00   \n",
       "1         20025000002200502102     200250000022005021   Rural   Hombre 39.00   \n",
       "2         20025000002200503101     200250000022005031   Rural    Mujer 30.00   \n",
       "3         20025000002200503102     200250000022005031   Rural   Hombre 33.00   \n",
       "4         20025000002200505101     200250000022005051   Rural    Mujer 58.00   \n",
       "...                        ...                    ...     ...      ...   ...   \n",
       "21828     05015091010200909101     050150910102009091   Rural   Hombre 48.00   \n",
       "21829     05015091010200909102     050150910102009091   Rural    Mujer 45.00   \n",
       "21830     05015091010200909103     050150910102009091   Rural   Hombre 21.00   \n",
       "21831     05015091010200909104     050150910102009091   Rural   Hombre 17.00   \n",
       "21832     05015091010200909107     050150910102009091   Rural    Mujer 20.00   \n",
       "\n",
       "          Seguro Social - Alternativa 1 Seguro Social - Alternativa 2  \\\n",
       "0                               Ninguno                       Ninguno   \n",
       "1                               Ninguno                       Ninguno   \n",
       "2       IESS, seguro general voluntario                       Ninguno   \n",
       "3                               Ninguno                       Ninguno   \n",
       "4                               Ninguno                       Ninguno   \n",
       "...                                 ...                           ...   \n",
       "21828                           Ninguno                       Ninguno   \n",
       "21829                           Ninguno                       Ninguno   \n",
       "21830                           Ninguno                       Ninguno   \n",
       "21831                           Ninguno                       Ninguno   \n",
       "21832                           Ninguno                       Ninguno   \n",
       "\n",
       "         Estado civil     Nivel de instrucción          Nivel de instrucción  \\\n",
       "0         Separado(a)               Secundaria              Educación Básica   \n",
       "1          Soltero(a)               Secundaria              Educación Básica   \n",
       "2           Casado(a)   Superior Universitario                      Superior   \n",
       "3           Casado(a)   Superior Universitario                      Superior   \n",
       "4       Divorciado(a)               Secundaria  Educación Media/Bachillerato   \n",
       "...               ...                      ...                           ...   \n",
       "21828       Casado(a)                 Primaria              Educación Básica   \n",
       "21829       Casado(a)                 Primaria              Educación Básica   \n",
       "21830      Soltero(a)         Educación  Media  Educación Media/Bachillerato   \n",
       "21831     Unión libre         Educación  Media  Educación Media/Bachillerato   \n",
       "21832     Unión libre         Educación  Media  Educación Media/Bachillerato   \n",
       "\n",
       "       ... Género del jefe/a de hogar Cónyuge Hijo o Hija Parientes  \\\n",
       "0      ...                      Mujer       0           1         0   \n",
       "1      ...                      Mujer       0           1         0   \n",
       "2      ...                      Mujer       1           1         0   \n",
       "3      ...                      Mujer       1           1         0   \n",
       "4      ...                      Mujer       0           1         1   \n",
       "...    ...                        ...     ...         ...       ...   \n",
       "21828  ...                     Hombre       1           4         1   \n",
       "21829  ...                     Hombre       1           4         1   \n",
       "21830  ...                     Hombre       1           4         1   \n",
       "21831  ...                     Hombre       1           4         1   \n",
       "21832  ...                     Hombre       1           4         1   \n",
       "\n",
       "      No parientes Empleado(a) doméstico(a)       Tipology  Ciudad  \\\n",
       "0                0                        0   Hogar tipo 5  200250   \n",
       "1                0                        0   Hogar tipo 5  200250   \n",
       "2                1                        0  Hogar tipo 10  200250   \n",
       "3                1                        0  Hogar tipo 10  200250   \n",
       "4                0                        0   Hogar tipo 9  200250   \n",
       "...            ...                      ...            ...     ...   \n",
       "21828            1                        0  Hogar tipo 16   50150   \n",
       "21829            1                        0  Hogar tipo 16   50150   \n",
       "21830            1                        0  Hogar tipo 16   50150   \n",
       "21831            1                        0  Hogar tipo 16   50150   \n",
       "21832            1                        0  Hogar tipo 16   50150   \n",
       "\n",
       "       Número de mujeres en el hogar Número de personas del hogar  \n",
       "0                                  1                            2  \n",
       "1                                  1                            2  \n",
       "2                                  2                            3  \n",
       "3                                  2                            3  \n",
       "4                                  1                            3  \n",
       "...                              ...                          ...  \n",
       "21828                              3                            7  \n",
       "21829                              3                            7  \n",
       "21830                              3                            7  \n",
       "21831                              3                            7  \n",
       "21832                              3                            7  \n",
       "\n",
       "[21833 rows x 41 columns]"
      ]
     },
     "execution_count": 215,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "persona_variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 218,
   "id": "55dff17f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Mostar 2 decimales\n",
    "\n",
    "pd.options.display.float_format = '{:,.2f}'.format\n",
    "persona_variables.to_csv('Data/muestra.csv', index_label=False, encoding='utf-8')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Electoral",
   "language": "python",
   "name": "electoral"
  },
  "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.9.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}