procesar_s1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "import glob\n",
    "import json\n",
    "import datetime\n",
    "from dateutil.parser import parse\n",
    "import gc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#all_files_s1 = glob.glob(os.path.join(\"s1\" , \"*/*.json\"))\n",
    "#s1_df_from_each_file = (pd.read_json(f) for f in all_files_s1)\n",
    "#s1_df = pd.concat(s1_df_from_each_file, ignore_index=True)\n",
    "#s1_df.to_pickle(\"s1_df_raw.pkl\")\n",
    "s1_df = pd.read_pickle(\"s1_df_raw.pkl\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "s1_df = s1_df[[\"declaracion\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "declaracion = pd.json_normalize(s1_df.declaracion)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "del s1_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gc.collect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "declaracion.to_pickle(\"s1_declaracion.pkl\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>situacionPatrimonial.datosGenerales.nombre</th>\n",
       "      <th>situacionPatrimonial.datosGenerales.primerApellido</th>\n",
       "      <th>situacionPatrimonial.datosGenerales.segundoApellido</th>\n",
       "      <th>situacionPatrimonial.datosGenerales.correoElectronico.institucional</th>\n",
       "      <th>situacionPatrimonial.datosCurricularesDeclarante.escolaridad</th>\n",
       "      <th>situacionPatrimonial.datosEmpleoCargoComision.tipoOperacion</th>\n",
       "      <th>situacionPatrimonial.datosEmpleoCargoComision.nivelOrdenGobierno</th>\n",
       "      <th>situacionPatrimonial.datosEmpleoCargoComision.ambitoPublico</th>\n",
       "      <th>situacionPatrimonial.datosEmpleoCargoComision.nombreEntePublico</th>\n",
       "      <th>situacionPatrimonial.datosEmpleoCargoComision.areaAdscripcion</th>\n",
       "      <th>...</th>\n",
       "      <th>situacionPatrimonial.ingresos.otrosIngresosAnualesTotal</th>\n",
       "      <th>situacionPatrimonial.ingresos.remuneracionConclusionCargoPublico</th>\n",
       "      <th>situacionPatrimonial.ingresos.ingresoConclusionNetoDeclarante</th>\n",
       "      <th>situacionPatrimonial.ingresos.totalIngresosConclusionNetos</th>\n",
       "      <th>situacionPatrimonial.ingresos.ingresoConclusionNetoParejaDependiente</th>\n",
       "      <th>situacionPatrimonial.ingresos.remuneracionMensualCargoPublico</th>\n",
       "      <th>situacionPatrimonial.ingresos.otrosIngresosMensualesTotal</th>\n",
       "      <th>situacionPatrimonial.ingresos.ingresoMensualNetoDeclarante</th>\n",
       "      <th>situacionPatrimonial.ingresos.ingresoMensualNetoParejaDependiente</th>\n",
       "      <th>situacionPatrimonial.ingresos.totalIngresosMensualesNetos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ADRIAN</td>\n",
       "      <td>HERNANDEZ</td>\n",
       "      <td>HERNANDEZ</td>\n",
       "      <td>leslieolvera.contauaeh@gmail.com</td>\n",
       "      <td>[{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>EJECUTIVO</td>\n",
       "      <td>Contraloría General</td>\n",
       "      <td>3/ER. BATALLON DE INGENIEROS DE COMBATE</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ABIGAIN YARELI</td>\n",
       "      <td>HERNANDEZ</td>\n",
       "      <td>CRUZ</td>\n",
       "      <td>abilu1909@gmail.com</td>\n",
       "      <td>[{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>EJECUTIVO</td>\n",
       "      <td>Contraloría General</td>\n",
       "      <td>13 BATALLON DE POLICIA MILITAR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ADELFO</td>\n",
       "      <td>HERNANDEZ</td>\n",
       "      <td>NIETO</td>\n",
       "      <td>plutarco@hotmail.com</td>\n",
       "      <td>[{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>EJECUTIVO</td>\n",
       "      <td>Contraloría General</td>\n",
       "      <td>ASISTENTE DE SERVICIOS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ADRIAN EMILIO</td>\n",
       "      <td>MADRIGAL</td>\n",
       "      <td>GONZALEZ</td>\n",
       "      <td></td>\n",
       "      <td>[{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>EJECUTIVO</td>\n",
       "      <td>Contraloría General</td>\n",
       "      <td>21 RCM</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ABEL</td>\n",
       "      <td>LEMUS</td>\n",
       "      <td>TORRES</td>\n",
       "      <td></td>\n",
       "      <td>[{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>EJECUTIVO</td>\n",
       "      <td>Contraloría General</td>\n",
       "      <td>CENTRO PENITENCIARIO</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>1354292</th>\n",
       "      <td>ZULEMA LINETH</td>\n",
       "      <td>HERNANDEZ</td>\n",
       "      <td>SANCHEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'estatus': 'FINALIZADO', 'documentoObtenido'...</td>\n",
       "      <td>SIN_CAMBIOS</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>JUDICIAL</td>\n",
       "      <td>PODER JUDICIAL DEL ESTADO DE ZACATECAS</td>\n",
       "      <td>ÓRGANO INTERNO DE CONTROL</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354293</th>\n",
       "      <td>ZULEMA LINETH</td>\n",
       "      <td>HERNANDEZ</td>\n",
       "      <td>SANCHEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'estatus': 'FINALIZADO', 'documentoObtenido'...</td>\n",
       "      <td>SIN_CAMBIOS</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>JUDICIAL</td>\n",
       "      <td>PODER JUDICIAL DEL ESTADO DE ZACATECAS</td>\n",
       "      <td>ÓRGANO INTERNO DE CONTROL</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354294</th>\n",
       "      <td>ZULMA VERONICA</td>\n",
       "      <td>CASAS</td>\n",
       "      <td>CHAVEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'estatus': 'FINALIZADO', 'documentoObtenido'...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>JUDICIAL</td>\n",
       "      <td>PODER JUDICIAL DEL ESTADO DE ZACATECAS</td>\n",
       "      <td>DIRECCIÓN DE RECURSOS HUMANOS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354295</th>\n",
       "      <td>ZULMA VERONICA</td>\n",
       "      <td>CASAS</td>\n",
       "      <td>CHAVEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'estatus': 'FINALIZADO', 'documentoObtenido'...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>JUDICIAL</td>\n",
       "      <td>PODER JUDICIAL DEL ESTADO DE ZACATECAS</td>\n",
       "      <td>DIRECCIÓN DE RECURSOS HUMANOS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354296</th>\n",
       "      <td>ZULMA VERONICA</td>\n",
       "      <td>CASAS</td>\n",
       "      <td>CHAVEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'estatus': 'FINALIZADO', 'documentoObtenido'...</td>\n",
       "      <td>AGREGAR</td>\n",
       "      <td>ESTATAL</td>\n",
       "      <td>JUDICIAL</td>\n",
       "      <td>PODER JUDICIAL DEL ESTADO DE ZACATECAS</td>\n",
       "      <td>DIRECCIÓN DE RECURSOS HUMANOS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1354297 rows × 376 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        situacionPatrimonial.datosGenerales.nombre  \\\n",
       "0                                           ADRIAN   \n",
       "1                                   ABIGAIN YARELI   \n",
       "2                                           ADELFO   \n",
       "3                                    ADRIAN EMILIO   \n",
       "4                                             ABEL   \n",
       "...                                            ...   \n",
       "1354292                              ZULEMA LINETH   \n",
       "1354293                              ZULEMA LINETH   \n",
       "1354294                             ZULMA VERONICA   \n",
       "1354295                             ZULMA VERONICA   \n",
       "1354296                             ZULMA VERONICA   \n",
       "\n",
       "        situacionPatrimonial.datosGenerales.primerApellido  \\\n",
       "0                                                HERNANDEZ   \n",
       "1                                                HERNANDEZ   \n",
       "2                                                HERNANDEZ   \n",
       "3                                                 MADRIGAL   \n",
       "4                                                    LEMUS   \n",
       "...                                                    ...   \n",
       "1354292                                          HERNANDEZ   \n",
       "1354293                                          HERNANDEZ   \n",
       "1354294                                              CASAS   \n",
       "1354295                                              CASAS   \n",
       "1354296                                              CASAS   \n",
       "\n",
       "        situacionPatrimonial.datosGenerales.segundoApellido  \\\n",
       "0                                                HERNANDEZ    \n",
       "1                                                     CRUZ    \n",
       "2                                                    NIETO    \n",
       "3                                                 GONZALEZ    \n",
       "4                                                   TORRES    \n",
       "...                                                    ...    \n",
       "1354292                                            SANCHEZ    \n",
       "1354293                                            SANCHEZ    \n",
       "1354294                                             CHAVEZ    \n",
       "1354295                                             CHAVEZ    \n",
       "1354296                                             CHAVEZ    \n",
       "\n",
       "        situacionPatrimonial.datosGenerales.correoElectronico.institucional  \\\n",
       "0                         leslieolvera.contauaeh@gmail.com                    \n",
       "1                                      abilu1909@gmail.com                    \n",
       "2                                     plutarco@hotmail.com                    \n",
       "3                                                                             \n",
       "4                                                                             \n",
       "...                                                    ...                    \n",
       "1354292                                                NaN                    \n",
       "1354293                                                NaN                    \n",
       "1354294                                                NaN                    \n",
       "1354295                                                NaN                    \n",
       "1354296                                                NaN                    \n",
       "\n",
       "        situacionPatrimonial.datosCurricularesDeclarante.escolaridad  \\\n",
       "0        [{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...             \n",
       "1        [{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...             \n",
       "2        [{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...             \n",
       "3        [{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...             \n",
       "4        [{'tipoOperacion': 'AGREGAR', 'nivel': {'clave...             \n",
       "...                                                    ...             \n",
       "1354292  [{'estatus': 'FINALIZADO', 'documentoObtenido'...             \n",
       "1354293  [{'estatus': 'FINALIZADO', 'documentoObtenido'...             \n",
       "1354294  [{'estatus': 'FINALIZADO', 'documentoObtenido'...             \n",
       "1354295  [{'estatus': 'FINALIZADO', 'documentoObtenido'...             \n",
       "1354296  [{'estatus': 'FINALIZADO', 'documentoObtenido'...             \n",
       "\n",
       "        situacionPatrimonial.datosEmpleoCargoComision.tipoOperacion  \\\n",
       "0                                                  AGREGAR            \n",
       "1                                                  AGREGAR            \n",
       "2                                                  AGREGAR            \n",
       "3                                                  AGREGAR            \n",
       "4                                                  AGREGAR            \n",
       "...                                                    ...            \n",
       "1354292                                        SIN_CAMBIOS            \n",
       "1354293                                        SIN_CAMBIOS            \n",
       "1354294                                            AGREGAR            \n",
       "1354295                                            AGREGAR            \n",
       "1354296                                            AGREGAR            \n",
       "\n",
       "        situacionPatrimonial.datosEmpleoCargoComision.nivelOrdenGobierno  \\\n",
       "0                                                  ESTATAL                 \n",
       "1                                                  ESTATAL                 \n",
       "2                                                  ESTATAL                 \n",
       "3                                                  ESTATAL                 \n",
       "4                                                  ESTATAL                 \n",
       "...                                                    ...                 \n",
       "1354292                                            ESTATAL                 \n",
       "1354293                                            ESTATAL                 \n",
       "1354294                                            ESTATAL                 \n",
       "1354295                                            ESTATAL                 \n",
       "1354296                                            ESTATAL                 \n",
       "\n",
       "        situacionPatrimonial.datosEmpleoCargoComision.ambitoPublico  \\\n",
       "0                                                EJECUTIVO            \n",
       "1                                                EJECUTIVO            \n",
       "2                                                EJECUTIVO            \n",
       "3                                                EJECUTIVO            \n",
       "4                                                EJECUTIVO            \n",
       "...                                                    ...            \n",
       "1354292                                           JUDICIAL            \n",
       "1354293                                           JUDICIAL            \n",
       "1354294                                           JUDICIAL            \n",
       "1354295                                           JUDICIAL            \n",
       "1354296                                           JUDICIAL            \n",
       "\n",
       "        situacionPatrimonial.datosEmpleoCargoComision.nombreEntePublico  \\\n",
       "0                                      Contraloría General                \n",
       "1                                      Contraloría General                \n",
       "2                                      Contraloría General                \n",
       "3                                      Contraloría General                \n",
       "4                                      Contraloría General                \n",
       "...                                                    ...                \n",
       "1354292             PODER JUDICIAL DEL ESTADO DE ZACATECAS                \n",
       "1354293             PODER JUDICIAL DEL ESTADO DE ZACATECAS                \n",
       "1354294             PODER JUDICIAL DEL ESTADO DE ZACATECAS                \n",
       "1354295             PODER JUDICIAL DEL ESTADO DE ZACATECAS                \n",
       "1354296             PODER JUDICIAL DEL ESTADO DE ZACATECAS                \n",
       "\n",
       "        situacionPatrimonial.datosEmpleoCargoComision.areaAdscripcion  ...  \\\n",
       "0                  3/ER. BATALLON DE INGENIEROS DE COMBATE             ...   \n",
       "1                           13 BATALLON DE POLICIA MILITAR             ...   \n",
       "2                                   ASISTENTE DE SERVICIOS             ...   \n",
       "3                                                   21 RCM             ...   \n",
       "4                                     CENTRO PENITENCIARIO             ...   \n",
       "...                                                    ...             ...   \n",
       "1354292                          ÓRGANO INTERNO DE CONTROL             ...   \n",
       "1354293                          ÓRGANO INTERNO DE CONTROL             ...   \n",
       "1354294                      DIRECCIÓN DE RECURSOS HUMANOS             ...   \n",
       "1354295                      DIRECCIÓN DE RECURSOS HUMANOS             ...   \n",
       "1354296                      DIRECCIÓN DE RECURSOS HUMANOS             ...   \n",
       "\n",
       "        situacionPatrimonial.ingresos.otrosIngresosAnualesTotal  \\\n",
       "0                                                      NaN        \n",
       "1                                                      NaN        \n",
       "2                                                      NaN        \n",
       "3                                                      NaN        \n",
       "4                                                      NaN        \n",
       "...                                                    ...        \n",
       "1354292                                                NaN        \n",
       "1354293                                                NaN        \n",
       "1354294                                                NaN        \n",
       "1354295                                                NaN        \n",
       "1354296                                                NaN        \n",
       "\n",
       "        situacionPatrimonial.ingresos.remuneracionConclusionCargoPublico  \\\n",
       "0                                                      NaN                 \n",
       "1                                                      NaN                 \n",
       "2                                                      NaN                 \n",
       "3                                                      NaN                 \n",
       "4                                                      NaN                 \n",
       "...                                                    ...                 \n",
       "1354292                                                NaN                 \n",
       "1354293                                                NaN                 \n",
       "1354294                                                NaN                 \n",
       "1354295                                                NaN                 \n",
       "1354296                                                NaN                 \n",
       "\n",
       "        situacionPatrimonial.ingresos.ingresoConclusionNetoDeclarante  \\\n",
       "0                                                      NaN              \n",
       "1                                                      NaN              \n",
       "2                                                      NaN              \n",
       "3                                                      NaN              \n",
       "4                                                      NaN              \n",
       "...                                                    ...              \n",
       "1354292                                                NaN              \n",
       "1354293                                                NaN              \n",
       "1354294                                                NaN              \n",
       "1354295                                                NaN              \n",
       "1354296                                                NaN              \n",
       "\n",
       "        situacionPatrimonial.ingresos.totalIngresosConclusionNetos  \\\n",
       "0                                                      NaN           \n",
       "1                                                      NaN           \n",
       "2                                                      NaN           \n",
       "3                                                      NaN           \n",
       "4                                                      NaN           \n",
       "...                                                    ...           \n",
       "1354292                                                NaN           \n",
       "1354293                                                NaN           \n",
       "1354294                                                NaN           \n",
       "1354295                                                NaN           \n",
       "1354296                                                NaN           \n",
       "\n",
       "        situacionPatrimonial.ingresos.ingresoConclusionNetoParejaDependiente  \\\n",
       "0                                                      NaN                     \n",
       "1                                                      NaN                     \n",
       "2                                                      NaN                     \n",
       "3                                                      NaN                     \n",
       "4                                                      NaN                     \n",
       "...                                                    ...                     \n",
       "1354292                                                NaN                     \n",
       "1354293                                                NaN                     \n",
       "1354294                                                NaN                     \n",
       "1354295                                                NaN                     \n",
       "1354296                                                NaN                     \n",
       "\n",
       "        situacionPatrimonial.ingresos.remuneracionMensualCargoPublico  \\\n",
       "0                                                      NaN              \n",
       "1                                                      NaN              \n",
       "2                                                      NaN              \n",
       "3                                                      NaN              \n",
       "4                                                      NaN              \n",
       "...                                                    ...              \n",
       "1354292                                                NaN              \n",
       "1354293                                                NaN              \n",
       "1354294                                                NaN              \n",
       "1354295                                                NaN              \n",
       "1354296                                                NaN              \n",
       "\n",
       "        situacionPatrimonial.ingresos.otrosIngresosMensualesTotal  \\\n",
       "0                                                      NaN          \n",
       "1                                                      NaN          \n",
       "2                                                      NaN          \n",
       "3                                                      NaN          \n",
       "4                                                      NaN          \n",
       "...                                                    ...          \n",
       "1354292                                                NaN          \n",
       "1354293                                                NaN          \n",
       "1354294                                                NaN          \n",
       "1354295                                                NaN          \n",
       "1354296                                                NaN          \n",
       "\n",
       "        situacionPatrimonial.ingresos.ingresoMensualNetoDeclarante  \\\n",
       "0                                                      NaN           \n",
       "1                                                      NaN           \n",
       "2                                                      NaN           \n",
       "3                                                      NaN           \n",
       "4                                                      NaN           \n",
       "...                                                    ...           \n",
       "1354292                                                NaN           \n",
       "1354293                                                NaN           \n",
       "1354294                                                NaN           \n",
       "1354295                                                NaN           \n",
       "1354296                                                NaN           \n",
       "\n",
       "        situacionPatrimonial.ingresos.ingresoMensualNetoParejaDependiente  \\\n",
       "0                                                      NaN                  \n",
       "1                                                      NaN                  \n",
       "2                                                      NaN                  \n",
       "3                                                      NaN                  \n",
       "4                                                      NaN                  \n",
       "...                                                    ...                  \n",
       "1354292                                                NaN                  \n",
       "1354293                                                NaN                  \n",
       "1354294                                                NaN                  \n",
       "1354295                                                NaN                  \n",
       "1354296                                                NaN                  \n",
       "\n",
       "        situacionPatrimonial.ingresos.totalIngresosMensualesNetos  \n",
       "0                                                      NaN         \n",
       "1                                                      NaN         \n",
       "2                                                      NaN         \n",
       "3                                                      NaN         \n",
       "4                                                      NaN         \n",
       "...                                                    ...         \n",
       "1354292                                                NaN         \n",
       "1354293                                                NaN         \n",
       "1354294                                                NaN         \n",
       "1354295                                                NaN         \n",
       "1354296                                                NaN         \n",
       "\n",
       "[1354297 rows x 376 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "declaracion"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}