code/notebooks/estado_inicial_datos.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "905a8b40",
   "metadata": {},
   "source": [
    "## Estado inicial de los datos\n",
    "\n",
    "Hay 5 datasets, uno por cada año entre 2017 y 2021.\n",
    "\n",
    "- ¿Los nombres de columnas, cantidad de columnas y tipos de datos son iguales en todos?\n",
    "- ¿Hay errores de carga de datos?\n",
    "- ¿Hay datos faltantes?\n",
    "\n",
    "\n",
    "##  What does my raw data look like?\n",
    "\n",
    "There are 5 datasets, one per year between 2017 and 2021.\n",
    "\n",
    "- Do column names, number of columns, and data types match in every dataset? \n",
    "- Can I detect any error in data loading?\n",
    "- Are there any missing data?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1686540f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7441db11",
   "metadata": {},
   "outputs": [],
   "source": [
    "csv_dir = os.path.join(os.path.dirname(os.path.dirname(os.path.abspath(''))), 'datasets/csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "bb5b8429",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_2017 = pd.read_csv(os.path.join(csv_dir, 'llamados_atendidos_abuso_sexual_2017.csv'), engine='python')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "7b81895c",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_2018 = pd.read_csv(os.path.join(csv_dir, 'llamados_atendidos_abuso_sexual_2018.csv'), engine='python')\n",
    "data_2019 = pd.read_csv(os.path.join(csv_dir, 'llamados_atendidos_abuso_sexual_2019.csv'), encoding='latin-1')\n",
    "data_2020 = pd.read_csv(os.path.join(csv_dir, 'llamados_atendidos_abuso_sexual_2020.csv'), engine='python')\n",
    "data_2021 = pd.read_csv(os.path.join(csv_dir, 'llamados_atendidos_abuso_sexual_2021.csv'), engine= 'python')\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "340f30ba",
   "metadata": {},
   "source": [
    "### Nombres de columnas / Column names\n",
    "\n",
    "\n",
    "2017 2018 \"llamante_quien_llama\" == 2019, 2020, 2021 == \"llamante_vinculo\"\n",
    "\n",
    "2017 2018 2019 \"llamado_provincia_indec_id\" == 2020, 2021 \"llamado_provincia_id\"\n",
    "\n",
    "2019, 2020, 2021 \"caso_id\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b85efc08",
   "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>2017</th>\n",
       "      <th>2018</th>\n",
       "      <th>2019</th>\n",
       "      <th>2020</th>\n",
       "      <th>2021</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>llamado_fecha_hora</td>\n",
       "      <td>llamado_fecha_hora</td>\n",
       "      <td>caso_id</td>\n",
       "      <td>caso_id</td>\n",
       "      <td>caso_id</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>llamado_provincia</td>\n",
       "      <td>llamado_provincia</td>\n",
       "      <td>llamado_fecha_hora</td>\n",
       "      <td>llamado_fecha_hora</td>\n",
       "      <td>llamado_fecha_hora</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>llamante_edad</td>\n",
       "      <td>llamante_edad</td>\n",
       "      <td>llamado_provincia</td>\n",
       "      <td>llamado_provincia</td>\n",
       "      <td>llamado_provincia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>llamante_genero</td>\n",
       "      <td>llamante_genero</td>\n",
       "      <td>llamante_edad</td>\n",
       "      <td>llamante_edad</td>\n",
       "      <td>llamante_edad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>llamante_quien_llama</td>\n",
       "      <td>llamante_quien_llama</td>\n",
       "      <td>llamante_genero</td>\n",
       "      <td>llamante_genero</td>\n",
       "      <td>llamante_genero</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>caso_judicializado</td>\n",
       "      <td>caso_judicializado</td>\n",
       "      <td>llamante_vinculo</td>\n",
       "      <td>llamante_vinculo</td>\n",
       "      <td>llamante_vinculo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>hecho_lugar</td>\n",
       "      <td>hecho_lugar</td>\n",
       "      <td>caso_judicializado</td>\n",
       "      <td>caso_judicializado</td>\n",
       "      <td>caso_judicializado</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>victima_a_resguardo</td>\n",
       "      <td>victima_a_resguardo</td>\n",
       "      <td>hecho_lugar</td>\n",
       "      <td>hecho_lugar</td>\n",
       "      <td>hecho_lugar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>victima_edad</td>\n",
       "      <td>victima_edad</td>\n",
       "      <td>victima_a_resguardo</td>\n",
       "      <td>victima_a_resguardo</td>\n",
       "      <td>victima_a_resguardo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>victima_genero</td>\n",
       "      <td>victima_genero</td>\n",
       "      <td>victima_edad</td>\n",
       "      <td>victima_edad</td>\n",
       "      <td>victima_edad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>victima_nacionalidad</td>\n",
       "      <td>victima_nacionalidad</td>\n",
       "      <td>victima_genero</td>\n",
       "      <td>victima_genero</td>\n",
       "      <td>victima_genero</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>victima_vinculo_agresor</td>\n",
       "      <td>victima_vinculo_agresor</td>\n",
       "      <td>victima_nacionalidad</td>\n",
       "      <td>victima_nacionalidad</td>\n",
       "      <td>victima_nacionalidad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>victima_discapacidad</td>\n",
       "      <td>victima_discapacidad</td>\n",
       "      <td>victima_vinculo_agresor</td>\n",
       "      <td>victima_vinculo_agresor</td>\n",
       "      <td>victima_vinculo_agresor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>victima_convive_agresor</td>\n",
       "      <td>victima_convive_agresor</td>\n",
       "      <td>victima_discapacidad</td>\n",
       "      <td>victima_discapacidad</td>\n",
       "      <td>victima_discapacidad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>vs_violacion_via_vaginal</td>\n",
       "      <td>vs_violacion_via_vaginal</td>\n",
       "      <td>victima_convive_agresor</td>\n",
       "      <td>victima_convive_agresor</td>\n",
       "      <td>victima_convive_agresor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>vs_violacion_via_anal</td>\n",
       "      <td>vs_violacion_via_anal</td>\n",
       "      <td>vs_violacion_via_vaginal</td>\n",
       "      <td>vs_violacion_via_vaginal</td>\n",
       "      <td>vs_violacion_via_vaginal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>vs_violacion_via_oral</td>\n",
       "      <td>vs_violacion_via_oral</td>\n",
       "      <td>vs_violacion_via_anal</td>\n",
       "      <td>vs_violacion_via_anal</td>\n",
       "      <td>vs_violacion_via_anal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>vs_tentativa_violacion</td>\n",
       "      <td>vs_tentativa_violacion</td>\n",
       "      <td>vs_violacion_via_oral</td>\n",
       "      <td>vs_violacion_via_oral</td>\n",
       "      <td>vs_violacion_via_oral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>vs_tocamiento_sexual</td>\n",
       "      <td>vs_tocamiento_sexual</td>\n",
       "      <td>vs_tentativa_violacion</td>\n",
       "      <td>vs_tentativa_violacion</td>\n",
       "      <td>vs_tentativa_violacion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>vs_intento_tocamiento</td>\n",
       "      <td>vs_intento_tocamiento</td>\n",
       "      <td>vs_tocamiento_sexual</td>\n",
       "      <td>vs_tocamiento_sexual</td>\n",
       "      <td>vs_tocamiento_sexual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>vs_Intento_violación_tercera_persona</td>\n",
       "      <td>vs_Intento_violación_tercera_persona</td>\n",
       "      <td>vs_intento_tocamiento</td>\n",
       "      <td>vs_intento_tocamiento</td>\n",
       "      <td>vs_intento_tocamiento</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>vs_grooming</td>\n",
       "      <td>vs_grooming</td>\n",
       "      <td>vs_Intento_violación_tercera_persona</td>\n",
       "      <td>vs_Intento_violación_tercera_persona</td>\n",
       "      <td>vs_Intento_violación_tercera_persona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>vs_exhibicionismo</td>\n",
       "      <td>vs_exhibicionismo</td>\n",
       "      <td>vs_grooming</td>\n",
       "      <td>vs_grooming</td>\n",
       "      <td>vs_grooming</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>vs_amenazas_verbales_contenido_sexual</td>\n",
       "      <td>vs_amenazas_verbales_contenido_sexual</td>\n",
       "      <td>vs_exhibicionismo</td>\n",
       "      <td>vs_exhibicionismo</td>\n",
       "      <td>vs_exhibicionismo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>vs_explotacion_sexual</td>\n",
       "      <td>vs_explotacion_sexual</td>\n",
       "      <td>vs_amenazas_verbales_contenido_sexual</td>\n",
       "      <td>vs_amenazas_verbales_contenido_sexual</td>\n",
       "      <td>vs_amenazas_verbales_contenido_sexual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>vs_explotacion_sexual_comercial</td>\n",
       "      <td>vs_explotacion_sexual_comercial</td>\n",
       "      <td>vs_explotacion_sexual</td>\n",
       "      <td>vs_explotacion_sexual</td>\n",
       "      <td>vs_explotacion_sexual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>vs_explotacion_sexual_viajes_turismo</td>\n",
       "      <td>vs_explotacion_sexual_viajes_turismo</td>\n",
       "      <td>vs_explotacion_sexual_comercial</td>\n",
       "      <td>vs_explotacion_sexual_comercial</td>\n",
       "      <td>vs_explotacion_sexual_comercial</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>vs_sospecha_trata_personas_fines_sexuales</td>\n",
       "      <td>vs_sospecha_trata_personas_fines_sexuales</td>\n",
       "      <td>vs_explotacion_sexual_viajes_turismo</td>\n",
       "      <td>vs_explotacion_sexual_viajes_turismo</td>\n",
       "      <td>vs_explotacion_sexual_viajes_turismo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>vs_existencia_facilitador_corrupcion_nnya</td>\n",
       "      <td>vs_existencia_facilitador_corrupcion_nnya</td>\n",
       "      <td>vs_sospecha_trata_personas_fines_sexuales</td>\n",
       "      <td>vs_sospecha_trata_personas_fines_sexuales</td>\n",
       "      <td>vs_sospecha_trata_personas_fines_sexuales</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>vs_obligacion_sacarse_fotos_pornograficas</td>\n",
       "      <td>vs_obligacion_sacarse_fotos_pornograficas</td>\n",
       "      <td>vs_existencia_facilitador_corrupcion_nnya</td>\n",
       "      <td>vs_existencia_facilitador_corrupcion_nnya</td>\n",
       "      <td>vs_existencia_facilitador_corrupcion_nnya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>vs_eyaculacion_partes_cuerpo</td>\n",
       "      <td>vs_eyaculacion_partes_cuerpo</td>\n",
       "      <td>vs_obligacion_sacarse_fotos_pornograficas</td>\n",
       "      <td>vs_obligacion_sacarse_fotos_pornograficas</td>\n",
       "      <td>vs_obligacion_sacarse_fotos_pornograficas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>vs_acoso_sexual</td>\n",
       "      <td>vs_acoso_sexual</td>\n",
       "      <td>vs_eyaculacion_partes_cuerpo</td>\n",
       "      <td>vs_eyaculacion_partes_cuerpo</td>\n",
       "      <td>vs_eyaculacion_partes_cuerpo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>vs_iniciacion_sexual_forzada_inducida</td>\n",
       "      <td>vs_iniciacion_sexual_forzada_inducida</td>\n",
       "      <td>vs_acoso_sexual</td>\n",
       "      <td>vs_acoso_sexual</td>\n",
       "      <td>vs_acoso_sexual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>vs_otra_forma_violencia_sexual</td>\n",
       "      <td>vs_otra_forma_violencia_sexual</td>\n",
       "      <td>vs_iniciacion_sexual_forzada_inducida</td>\n",
       "      <td>vs_iniciacion_sexual_forzada_inducida</td>\n",
       "      <td>vs_iniciacion_sexual_forzada_inducida</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>vs_no_sabe_no_contesta</td>\n",
       "      <td>vs_no_sabe_no_contesta</td>\n",
       "      <td>vs_otra_forma_violencia_sexual</td>\n",
       "      <td>vs_otra_forma_violencia_sexual</td>\n",
       "      <td>vs_otra_forma_violencia_sexual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>ofv_sentimiento_amenaza</td>\n",
       "      <td>ofv_sentimiento_amenaza</td>\n",
       "      <td>vs_no_sabe_no_contesta</td>\n",
       "      <td>vs_no_sabe_no_contesta</td>\n",
       "      <td>vs_no_sabe_no_contesta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>ofv_amenaza_explicita</td>\n",
       "      <td>ofv_amenaza_explicita</td>\n",
       "      <td>ofv_sentimiento_amenaza</td>\n",
       "      <td>ofv_sentimiento_amenaza</td>\n",
       "      <td>ofv_sentimiento_amenaza</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>ofv_violencia_fisica</td>\n",
       "      <td>ofv_violencia_fisica</td>\n",
       "      <td>ofv_amenaza_explicita</td>\n",
       "      <td>ofv_amenaza_explicita</td>\n",
       "      <td>ofv_amenaza_explicita</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>ofv_intento_ahorcar</td>\n",
       "      <td>ofv_intento_ahorcar</td>\n",
       "      <td>ofv_violencia_fisica</td>\n",
       "      <td>ofv_violencia_fisica</td>\n",
       "      <td>ofv_violencia_fisica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>ofv_intento_quemar</td>\n",
       "      <td>ofv_intento_quemar</td>\n",
       "      <td>ofv_intento_ahorcar</td>\n",
       "      <td>ofv_intento_ahorcar</td>\n",
       "      <td>ofv_intento_ahorcar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>ofv_intento_ahogar</td>\n",
       "      <td>ofv_intento_ahogar</td>\n",
       "      <td>ofv_intento_quemar</td>\n",
       "      <td>ofv_intento_quemar</td>\n",
       "      <td>ofv_intento_quemar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>ofv_amenaza_muerte</td>\n",
       "      <td>ofv_amenaza_muerte</td>\n",
       "      <td>ofv_intento_ahogar</td>\n",
       "      <td>ofv_intento_ahogar</td>\n",
       "      <td>ofv_intento_ahogar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>ofv_uso_sustancias_psicoactivas</td>\n",
       "      <td>ofv_uso_sustancias_psicoactivas</td>\n",
       "      <td>ofv_amenaza_muerte</td>\n",
       "      <td>ofv_amenaza_muerte</td>\n",
       "      <td>ofv_amenaza_muerte</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>ofv_intento_privacion_libertad</td>\n",
       "      <td>ofv_intento_privacion_libertad</td>\n",
       "      <td>ofv_uso_sustancias_psicoactivas</td>\n",
       "      <td>ofv_uso_sustancias_psicoactivas</td>\n",
       "      <td>ofv_uso_sustancias_psicoactivas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>ofv_privacion_libertad</td>\n",
       "      <td>ofv_privacion_libertad</td>\n",
       "      <td>ofv_intento_privacion_libertad</td>\n",
       "      <td>ofv_intento_privacion_libertad</td>\n",
       "      <td>ofv_intento_privacion_libertad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>ofv_uso_arma_blanca</td>\n",
       "      <td>ofv_uso_arma_blanca</td>\n",
       "      <td>ofv_privacion_libertad</td>\n",
       "      <td>ofv_privacion_libertad</td>\n",
       "      <td>ofv_privacion_libertad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>ofv_uso_arma_fuego</td>\n",
       "      <td>ofv_uso_arma_fuego</td>\n",
       "      <td>ofv_uso_arma_blanca</td>\n",
       "      <td>ofv_uso_arma_blanca</td>\n",
       "      <td>ofv_uso_arma_blanca</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>ofv_enganio_seduccion</td>\n",
       "      <td>ofv_enganio_seduccion</td>\n",
       "      <td>ofv_uso_arma_fuego</td>\n",
       "      <td>ofv_uso_arma_fuego</td>\n",
       "      <td>ofv_uso_arma_fuego</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>ofv_intento_matar</td>\n",
       "      <td>ofv_intento_matar</td>\n",
       "      <td>ofv_enganio_seduccion</td>\n",
       "      <td>ofv_enganio_seduccion</td>\n",
       "      <td>ofv_enganio_seduccion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>ofv_uso_animal_victimizar</td>\n",
       "      <td>ofv_uso_animal_victimizar</td>\n",
       "      <td>ofv_intento_matar</td>\n",
       "      <td>ofv_intento_matar</td>\n",
       "      <td>ofv_intento_matar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>ofv_grooming</td>\n",
       "      <td>ofv_grooming</td>\n",
       "      <td>ofv_uso_animal_victimizar</td>\n",
       "      <td>ofv_uso_animal_victimizar</td>\n",
       "      <td>ofv_uso_animal_victimizar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>ofv_otra_forma_violencia</td>\n",
       "      <td>ofv_otra_forma_violencia</td>\n",
       "      <td>ofv_grooming</td>\n",
       "      <td>ofv_grooming</td>\n",
       "      <td>ofv_grooming</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>ofv_no_sabe_no_contesta</td>\n",
       "      <td>ofv_no_sabe_no_contesta</td>\n",
       "      <td>ofv_otra_forma_violencia</td>\n",
       "      <td>ofv_otra_forma_violencia</td>\n",
       "      <td>ofv_otra_forma_violencia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>llamado_provincia_indec_id</td>\n",
       "      <td>llamado_provincia_indec_id</td>\n",
       "      <td>ofv_no_sabe_no_contesta</td>\n",
       "      <td>ofv_no_sabe_no_contesta</td>\n",
       "      <td>ofv_no_sabe_no_contesta</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         2017  \\\n",
       "0                          llamado_fecha_hora   \n",
       "1                           llamado_provincia   \n",
       "2                               llamante_edad   \n",
       "3                             llamante_genero   \n",
       "4                        llamante_quien_llama   \n",
       "5                          caso_judicializado   \n",
       "6                                 hecho_lugar   \n",
       "7                         victima_a_resguardo   \n",
       "8                                victima_edad   \n",
       "9                              victima_genero   \n",
       "10                       victima_nacionalidad   \n",
       "11                    victima_vinculo_agresor   \n",
       "12                       victima_discapacidad   \n",
       "13                    victima_convive_agresor   \n",
       "14                   vs_violacion_via_vaginal   \n",
       "15                      vs_violacion_via_anal   \n",
       "16                      vs_violacion_via_oral   \n",
       "17                     vs_tentativa_violacion   \n",
       "18                       vs_tocamiento_sexual   \n",
       "19                      vs_intento_tocamiento   \n",
       "20       vs_Intento_violación_tercera_persona   \n",
       "21                                vs_grooming   \n",
       "22                          vs_exhibicionismo   \n",
       "23      vs_amenazas_verbales_contenido_sexual   \n",
       "24                      vs_explotacion_sexual   \n",
       "25            vs_explotacion_sexual_comercial   \n",
       "26       vs_explotacion_sexual_viajes_turismo   \n",
       "27  vs_sospecha_trata_personas_fines_sexuales   \n",
       "28  vs_existencia_facilitador_corrupcion_nnya   \n",
       "29  vs_obligacion_sacarse_fotos_pornograficas   \n",
       "30               vs_eyaculacion_partes_cuerpo   \n",
       "31                            vs_acoso_sexual   \n",
       "32      vs_iniciacion_sexual_forzada_inducida   \n",
       "33             vs_otra_forma_violencia_sexual   \n",
       "34                     vs_no_sabe_no_contesta   \n",
       "35                    ofv_sentimiento_amenaza   \n",
       "36                      ofv_amenaza_explicita   \n",
       "37                       ofv_violencia_fisica   \n",
       "38                        ofv_intento_ahorcar   \n",
       "39                         ofv_intento_quemar   \n",
       "40                         ofv_intento_ahogar   \n",
       "41                         ofv_amenaza_muerte   \n",
       "42            ofv_uso_sustancias_psicoactivas   \n",
       "43             ofv_intento_privacion_libertad   \n",
       "44                     ofv_privacion_libertad   \n",
       "45                        ofv_uso_arma_blanca   \n",
       "46                         ofv_uso_arma_fuego   \n",
       "47                      ofv_enganio_seduccion   \n",
       "48                          ofv_intento_matar   \n",
       "49                  ofv_uso_animal_victimizar   \n",
       "50                               ofv_grooming   \n",
       "51                   ofv_otra_forma_violencia   \n",
       "52                    ofv_no_sabe_no_contesta   \n",
       "53                 llamado_provincia_indec_id   \n",
       "\n",
       "                                         2018  \\\n",
       "0                          llamado_fecha_hora   \n",
       "1                           llamado_provincia   \n",
       "2                               llamante_edad   \n",
       "3                             llamante_genero   \n",
       "4                        llamante_quien_llama   \n",
       "5                          caso_judicializado   \n",
       "6                                 hecho_lugar   \n",
       "7                         victima_a_resguardo   \n",
       "8                                victima_edad   \n",
       "9                              victima_genero   \n",
       "10                       victima_nacionalidad   \n",
       "11                    victima_vinculo_agresor   \n",
       "12                       victima_discapacidad   \n",
       "13                    victima_convive_agresor   \n",
       "14                   vs_violacion_via_vaginal   \n",
       "15                      vs_violacion_via_anal   \n",
       "16                      vs_violacion_via_oral   \n",
       "17                     vs_tentativa_violacion   \n",
       "18                       vs_tocamiento_sexual   \n",
       "19                      vs_intento_tocamiento   \n",
       "20       vs_Intento_violación_tercera_persona   \n",
       "21                                vs_grooming   \n",
       "22                          vs_exhibicionismo   \n",
       "23      vs_amenazas_verbales_contenido_sexual   \n",
       "24                      vs_explotacion_sexual   \n",
       "25            vs_explotacion_sexual_comercial   \n",
       "26       vs_explotacion_sexual_viajes_turismo   \n",
       "27  vs_sospecha_trata_personas_fines_sexuales   \n",
       "28  vs_existencia_facilitador_corrupcion_nnya   \n",
       "29  vs_obligacion_sacarse_fotos_pornograficas   \n",
       "30               vs_eyaculacion_partes_cuerpo   \n",
       "31                            vs_acoso_sexual   \n",
       "32      vs_iniciacion_sexual_forzada_inducida   \n",
       "33             vs_otra_forma_violencia_sexual   \n",
       "34                     vs_no_sabe_no_contesta   \n",
       "35                    ofv_sentimiento_amenaza   \n",
       "36                      ofv_amenaza_explicita   \n",
       "37                       ofv_violencia_fisica   \n",
       "38                        ofv_intento_ahorcar   \n",
       "39                         ofv_intento_quemar   \n",
       "40                         ofv_intento_ahogar   \n",
       "41                         ofv_amenaza_muerte   \n",
       "42            ofv_uso_sustancias_psicoactivas   \n",
       "43             ofv_intento_privacion_libertad   \n",
       "44                     ofv_privacion_libertad   \n",
       "45                        ofv_uso_arma_blanca   \n",
       "46                         ofv_uso_arma_fuego   \n",
       "47                      ofv_enganio_seduccion   \n",
       "48                          ofv_intento_matar   \n",
       "49                  ofv_uso_animal_victimizar   \n",
       "50                               ofv_grooming   \n",
       "51                   ofv_otra_forma_violencia   \n",
       "52                    ofv_no_sabe_no_contesta   \n",
       "53                 llamado_provincia_indec_id   \n",
       "\n",
       "                                         2019  \\\n",
       "0                                     caso_id   \n",
       "1                          llamado_fecha_hora   \n",
       "2                           llamado_provincia   \n",
       "3                               llamante_edad   \n",
       "4                             llamante_genero   \n",
       "5                            llamante_vinculo   \n",
       "6                          caso_judicializado   \n",
       "7                                 hecho_lugar   \n",
       "8                         victima_a_resguardo   \n",
       "9                                victima_edad   \n",
       "10                             victima_genero   \n",
       "11                       victima_nacionalidad   \n",
       "12                    victima_vinculo_agresor   \n",
       "13                       victima_discapacidad   \n",
       "14                    victima_convive_agresor   \n",
       "15                   vs_violacion_via_vaginal   \n",
       "16                      vs_violacion_via_anal   \n",
       "17                      vs_violacion_via_oral   \n",
       "18                     vs_tentativa_violacion   \n",
       "19                       vs_tocamiento_sexual   \n",
       "20                      vs_intento_tocamiento   \n",
       "21       vs_Intento_violación_tercera_persona   \n",
       "22                                vs_grooming   \n",
       "23                          vs_exhibicionismo   \n",
       "24      vs_amenazas_verbales_contenido_sexual   \n",
       "25                      vs_explotacion_sexual   \n",
       "26            vs_explotacion_sexual_comercial   \n",
       "27       vs_explotacion_sexual_viajes_turismo   \n",
       "28  vs_sospecha_trata_personas_fines_sexuales   \n",
       "29  vs_existencia_facilitador_corrupcion_nnya   \n",
       "30  vs_obligacion_sacarse_fotos_pornograficas   \n",
       "31               vs_eyaculacion_partes_cuerpo   \n",
       "32                            vs_acoso_sexual   \n",
       "33      vs_iniciacion_sexual_forzada_inducida   \n",
       "34             vs_otra_forma_violencia_sexual   \n",
       "35                     vs_no_sabe_no_contesta   \n",
       "36                    ofv_sentimiento_amenaza   \n",
       "37                      ofv_amenaza_explicita   \n",
       "38                       ofv_violencia_fisica   \n",
       "39                        ofv_intento_ahorcar   \n",
       "40                         ofv_intento_quemar   \n",
       "41                         ofv_intento_ahogar   \n",
       "42                         ofv_amenaza_muerte   \n",
       "43            ofv_uso_sustancias_psicoactivas   \n",
       "44             ofv_intento_privacion_libertad   \n",
       "45                     ofv_privacion_libertad   \n",
       "46                        ofv_uso_arma_blanca   \n",
       "47                         ofv_uso_arma_fuego   \n",
       "48                      ofv_enganio_seduccion   \n",
       "49                          ofv_intento_matar   \n",
       "50                  ofv_uso_animal_victimizar   \n",
       "51                               ofv_grooming   \n",
       "52                   ofv_otra_forma_violencia   \n",
       "53                    ofv_no_sabe_no_contesta   \n",
       "\n",
       "                                         2020  \\\n",
       "0                                     caso_id   \n",
       "1                          llamado_fecha_hora   \n",
       "2                           llamado_provincia   \n",
       "3                               llamante_edad   \n",
       "4                             llamante_genero   \n",
       "5                            llamante_vinculo   \n",
       "6                          caso_judicializado   \n",
       "7                                 hecho_lugar   \n",
       "8                         victima_a_resguardo   \n",
       "9                                victima_edad   \n",
       "10                             victima_genero   \n",
       "11                       victima_nacionalidad   \n",
       "12                    victima_vinculo_agresor   \n",
       "13                       victima_discapacidad   \n",
       "14                    victima_convive_agresor   \n",
       "15                   vs_violacion_via_vaginal   \n",
       "16                      vs_violacion_via_anal   \n",
       "17                      vs_violacion_via_oral   \n",
       "18                     vs_tentativa_violacion   \n",
       "19                       vs_tocamiento_sexual   \n",
       "20                      vs_intento_tocamiento   \n",
       "21       vs_Intento_violación_tercera_persona   \n",
       "22                                vs_grooming   \n",
       "23                          vs_exhibicionismo   \n",
       "24      vs_amenazas_verbales_contenido_sexual   \n",
       "25                      vs_explotacion_sexual   \n",
       "26            vs_explotacion_sexual_comercial   \n",
       "27       vs_explotacion_sexual_viajes_turismo   \n",
       "28  vs_sospecha_trata_personas_fines_sexuales   \n",
       "29  vs_existencia_facilitador_corrupcion_nnya   \n",
       "30  vs_obligacion_sacarse_fotos_pornograficas   \n",
       "31               vs_eyaculacion_partes_cuerpo   \n",
       "32                            vs_acoso_sexual   \n",
       "33      vs_iniciacion_sexual_forzada_inducida   \n",
       "34             vs_otra_forma_violencia_sexual   \n",
       "35                     vs_no_sabe_no_contesta   \n",
       "36                    ofv_sentimiento_amenaza   \n",
       "37                      ofv_amenaza_explicita   \n",
       "38                       ofv_violencia_fisica   \n",
       "39                        ofv_intento_ahorcar   \n",
       "40                         ofv_intento_quemar   \n",
       "41                         ofv_intento_ahogar   \n",
       "42                         ofv_amenaza_muerte   \n",
       "43            ofv_uso_sustancias_psicoactivas   \n",
       "44             ofv_intento_privacion_libertad   \n",
       "45                     ofv_privacion_libertad   \n",
       "46                        ofv_uso_arma_blanca   \n",
       "47                         ofv_uso_arma_fuego   \n",
       "48                      ofv_enganio_seduccion   \n",
       "49                          ofv_intento_matar   \n",
       "50                  ofv_uso_animal_victimizar   \n",
       "51                               ofv_grooming   \n",
       "52                   ofv_otra_forma_violencia   \n",
       "53                    ofv_no_sabe_no_contesta   \n",
       "\n",
       "                                         2021  \n",
       "0                                     caso_id  \n",
       "1                          llamado_fecha_hora  \n",
       "2                           llamado_provincia  \n",
       "3                               llamante_edad  \n",
       "4                             llamante_genero  \n",
       "5                            llamante_vinculo  \n",
       "6                          caso_judicializado  \n",
       "7                                 hecho_lugar  \n",
       "8                         victima_a_resguardo  \n",
       "9                                victima_edad  \n",
       "10                             victima_genero  \n",
       "11                       victima_nacionalidad  \n",
       "12                    victima_vinculo_agresor  \n",
       "13                       victima_discapacidad  \n",
       "14                    victima_convive_agresor  \n",
       "15                   vs_violacion_via_vaginal  \n",
       "16                      vs_violacion_via_anal  \n",
       "17                      vs_violacion_via_oral  \n",
       "18                     vs_tentativa_violacion  \n",
       "19                       vs_tocamiento_sexual  \n",
       "20                      vs_intento_tocamiento  \n",
       "21       vs_Intento_violación_tercera_persona  \n",
       "22                                vs_grooming  \n",
       "23                          vs_exhibicionismo  \n",
       "24      vs_amenazas_verbales_contenido_sexual  \n",
       "25                      vs_explotacion_sexual  \n",
       "26            vs_explotacion_sexual_comercial  \n",
       "27       vs_explotacion_sexual_viajes_turismo  \n",
       "28  vs_sospecha_trata_personas_fines_sexuales  \n",
       "29  vs_existencia_facilitador_corrupcion_nnya  \n",
       "30  vs_obligacion_sacarse_fotos_pornograficas  \n",
       "31               vs_eyaculacion_partes_cuerpo  \n",
       "32                            vs_acoso_sexual  \n",
       "33      vs_iniciacion_sexual_forzada_inducida  \n",
       "34             vs_otra_forma_violencia_sexual  \n",
       "35                     vs_no_sabe_no_contesta  \n",
       "36                    ofv_sentimiento_amenaza  \n",
       "37                      ofv_amenaza_explicita  \n",
       "38                       ofv_violencia_fisica  \n",
       "39                        ofv_intento_ahorcar  \n",
       "40                         ofv_intento_quemar  \n",
       "41                         ofv_intento_ahogar  \n",
       "42                         ofv_amenaza_muerte  \n",
       "43            ofv_uso_sustancias_psicoactivas  \n",
       "44             ofv_intento_privacion_libertad  \n",
       "45                     ofv_privacion_libertad  \n",
       "46                        ofv_uso_arma_blanca  \n",
       "47                         ofv_uso_arma_fuego  \n",
       "48                      ofv_enganio_seduccion  \n",
       "49                          ofv_intento_matar  \n",
       "50                  ofv_uso_animal_victimizar  \n",
       "51                               ofv_grooming  \n",
       "52                   ofv_otra_forma_violencia  \n",
       "53                    ofv_no_sabe_no_contesta  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calling DataFrame constructor after zipping lists, with columns specified\n",
    "\n",
    "df_columnas = pd.DataFrame(list(zip(data_2017.columns, data_2018.columns, data_2019, data_2020.columns, data_2021.columns)),\n",
    "               columns =['2017', '2018', '2019', '2020', '2021'])\n",
    "df_columnas"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}