{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "bcb2eb03-8273-46dd-ba20-f1817691fe42", "metadata": {}, "outputs": [], "source": [ "from functools import cache\n", "import pandas as pd\n", "\n", "pd.set_option(\"display.max_columns\", None)" ] }, { "cell_type": "code", "execution_count": 3, "id": "5b51e9a7-1dbd-4b86-8aad-109a2f4095cd", "metadata": {}, "outputs": [], "source": [ "columns_selected = [\n", " \"edo_captura\",\n", " \"edo_nac_madre\",\n", " \"fecha_nac_madre\",\n", " \"edad_madre\",\n", " \"estado_conyugal\",\n", " \"entidad_residencia_madre\",\n", " \"numero_embarazos\",\n", " \"hijos_nacidos_muertos\",\n", " \"hijos_nacidos_vivos\",\n", " \"hijos_sobrevivientes\",\n", " \"el_hijo_anterior_nacio\",\n", " \"vive_aun_hijo_anterior\",\n", " \"orden_nacimiento\",\n", " \"recibio_atencion_prenatal\",\n", " \"trimestre_recibio_primera_consulta\",\n", " \"total_consultas_recibidas\",\n", " \"madre_sobrevivio_al_parto\",\n", " \"escolaridad_madre\",\n", " \"ocupacion_habitual_madre\",\n", " \"trabaja_actualmente\",\n", " \"fecha_nacimiento_nac_vivo\",\n", " \"hora_nacimiento_nac_vivo\",\n", " \"sexo_nac_vivo\",\n", " \"semanas_gestacion_nac_vivo\",\n", " \"talla_nac_vivo\",\n", " \"peso_nac_vivo\",\n", " \"valoracion_apgar_nac_vivo\",\n", " \"valoracion_silverman_nac_vivo\",\n", " \"producto_de_un_embarazo\",\n", " \"entidad_certifico\",\n", "]" ] }, { "cell_type": "code", "execution_count": 5, "id": "2848508d-264a-487b-951f-99ef8483e3b1", "metadata": {}, "outputs": [], "source": [ "df_original = pd.read_csv(\"~/Downloads/out2.csv\", dtype=object)" ] }, { "cell_type": "code", "execution_count": 6, "id": "a6c8cc59-5461-4362-932f-0ddf8fbcb764", "metadata": {}, "outputs": [], "source": [ "# df_original.columns" ] }, { "cell_type": "code", "execution_count": 7, "id": "f5641028-679f-473b-945d-5775d144dcf2", "metadata": {}, "outputs": [], "source": [ "df = df_original.copy()" ] }, { "cell_type": "code", "execution_count": 8, "id": "b0362862-d25d-40a8-a4d7-95b1e337b955", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "{'entidad_residencia_madre.1', 'edo_captura.1', 'sexo_nacimiento_vivo.1', 'escolaridad_madre.1', 'edo_nac_madre.1', 'madre_sobrevivio_parto.1', 'recibio_atencion_prenatal.1', 'producto_de_un_embarazo.1', 'estado_conyugal'}\n" ] } ], "source": [ "df_cols = df.columns.to_list()\n", "columnas_description = {x for x in df_cols if x[-2:] == \".1\"} | {\"estado_conyugal\"}\n", "df_cols = [x for x in df_cols if x + \".1\" not in columnas_description]\n", "print(columnas_description)\n", "df = df[df_cols]" ] }, { "cell_type": "code", "execution_count": 9, "id": "62f5a056-048a-4d5c-a28b-704cfcc44692", "metadata": {}, "outputs": [], "source": [ "df = df.rename(columns={x: x[:-2] for x in columnas_description})" ] }, { "cell_type": "code", "execution_count": 10, "id": "57fab793-97b6-4189-b6e0-578062763b68", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['Unnamed: 0', 'MPO_NACM', 'fecha_nac_madre', 'edad_madre', 'CON_INDM',\n", " 'HABLA_INDM', 'CUAL_LENGM', 'estado_conyug', 'TIPOVIAL_RES',\n", " 'TIPOASEN_RES', 'MPO_RES', 'LOC_RES', 'numeros_embarazos',\n", " 'hijos_nacidos_muertos', 'hijos_nacidos_vivos', 'hijos_sobrevivientes',\n", " 'hijo_anterior_nacio', 'VIVE_AUN', 'orden_nacimiento', 'TRIM_CONS',\n", " 'total_consultas_recibidas', 'DERHAB', 'DERHAB2',\n", " 'ocupacion_habitual_madre', 'CVEOCUPHAB', 'TRAB_ACT',\n", " 'fecha_nacimiento_vivo', 'hora_nacimiento_vivo',\n", " 'semanas_gestacion_vivo', 'talla_nacimiento_vivo', 'peso_nac_vivo',\n", " 'valoracion_apgar_nac_vivo', 'valoracion_silverman_nac_vivo', 'BCG',\n", " 'HEP_B', 'VIT_A', 'VIT_K', 'TAM_AUD', 'ACELRN', 'CVE_CIE', 'ACELRN2',\n", " 'CVE_CIE2', 'PROCNAC', 'FORCEPS', 'ESPECIFIQUE', 'INST_NAC', 'UNIMED',\n", " 'CLUES', 'ATENDIO', 'ATEN_OTRO', 'TIPOVIAL_NAC', 'TIPOASEN_NAC',\n", " 'lugar_de_nacimiento', 'MPO_NAC', 'LOC_NAC', 'CERT_POR', 'OTROMEDICO',\n", " 'UNIMED_33_1', 'CLUES_33_2', 'TIPOVIAL_CERT', 'TIPOASEN_CERT',\n", " 'ENT_CERT', 'MPO_CERT', 'LOC_CERT', 'FECH_CERT', 'FECH_ALTA',\n", " 'FECH_CAMB', 'IDCAPTURA', 'TIPO_FORMATO', 'edo_nac_madre',\n", " 'edo_captura', 'el_hijo_anterior_nacio', 'entidad_certifico',\n", " 'entidad_residencia_madre', 'escolaridad_madre', 'Descrip',\n", " 'lugar_nacimiento', 'madre_sobrevivio_parto', 'producto_de_un_embarazo',\n", " 'recibio_atencion_prenatal', 'sexo_nacimiento_vivo',\n", " 'trabaja_actualmente', 'trimestre_recibio_primera_consulta',\n", " 'vive_aun_hijo_anterior'],\n", " dtype='object')" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.columns" ] }, { "cell_type": "code", "execution_count": 11, "id": "3e3f76f5-2e5e-4ac6-a5c2-34cecdfa977b", "metadata": {}, "outputs": [], "source": [ "mapper = {\n", " \"numeros_embarazos\": \"numero_embarazos\",\n", " \"madre_sobrevivio_parto\": \"madre_sobrevivio_al_parto\",\n", " \"fecha_nacimiento_vivo\": \"fecha_nacimiento_nac_vivo\",\n", " \"hora_nacimiento_vivo\": \"hora_nacimiento_nac_vivo\",\n", " \"sexo_nacimiento_vivo\": \"sexo_nac_vivo\",\n", " \"semanas_gestacion_vivo\": \"semanas_gestacion_nac_vivo\",\n", " \"talla_nacimiento_vivo\": \"talla_nac_vivo\",\n", " \"Descrip\": \"estado_conyugal\",\n", "}\n", "df = df.rename(columns=mapper)" ] }, { "cell_type": "code", "execution_count": 12, "id": "14f1b915-aa58-42c0-99f9-901ad56509c0", "metadata": {}, "outputs": [], "source": [ "# df_original.sample(n=10)[[\"estado_conyugal\"]]" ] }, { "cell_type": "code", "execution_count": 13, "id": "0aa4b396-b901-441e-9f94-e6521e7146a9", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
edo_capturaedo_nac_madrefecha_nac_madreedad_madreestado_conyugalentidad_residencia_madrenumero_embarazoshijos_nacidos_muertoshijos_nacidos_vivoshijos_sobrevivientesel_hijo_anterior_naciovive_aun_hijo_anteriororden_nacimientorecibio_atencion_prenataltrimestre_recibio_primera_consultatotal_consultas_recibidasmadre_sobrevivio_al_partoescolaridad_madreocupacion_habitual_madretrabaja_actualmentefecha_nacimiento_nac_vivohora_nacimiento_nac_vivosexo_nac_vivosemanas_gestacion_nac_vivotalla_nac_vivopeso_nac_vivovaloracion_apgar_nac_vivovaloracion_silverman_nac_vivoproducto_de_un_embarazoentidad_certificoCVE_CIECVE_CIE2
0CHIAPASCHIAPAS05/07/198036UNIÓN LIBRECHIAPAS9188VIVOSI9SISEGUNDO6SININGUNAHOGARNaN19/04/201702:00:00MUJER4050310080ÚNICOCHIAPAS00000000
1CHIAPASCHIAPAS17/05/199125UNIÓN LIBRECHIAPAS49944VIVOSI4SISEGUNDO4SISECUNDARIA COMPLETAHOGARNaN11/01/201713:00:00MUJER3950390000ÚNICOCHIAPAS00000000
2CHIAPASCHIAPAS27/01/198235CASADACHIAPAS6066VIVOSI6SIPRIMERO3SIPRIMARIA INCOMPLETAAMA DE CASANaN22/05/201712:23:00MUJER3850296090ÚNICOCHIAPAS00000000
3CHIAPASCHIAPAS16/11/198333UNIÓN LIBRECHIAPAS1011S.I.NaN1SITERCERO4SIPRIMARIA COMPLETAAMA DE CASANaN03/06/201710:35:00MUJER994829009999ÚNICOCHIAPAS00000000
4CHIAPASCHIAPAS22/11/198234UNIÓN LIBRECHIAPAS39933VIVOSI3SIPRIMERO5SININGUNAAMA DE CASANaN29/04/201723:12:00MUJER3951305090ÚNICOCHIAPAS00000000
...................................................................................................
5873372ZACATECASOTROS PAISES DE LATINOAMERICA01/07/198731CASADAZACATECAS3122VIVOSI3SIPRIMERO12SIPROFESIONALLIC. EN INFORMATICASI23/05/201916:06:00MUJER3949299090ÚNICOZACATECAS00000000
5873373ZACATECASZACATECAS17/07/198632CASADAZACATECAS3033VIVOSI3SIPRIMERO5SISECUNDARIA COMPLETAHOGARNaN24/05/201916:55:00HOMBRE3750383090ÚNICOZACATECAS00000000
5873374ZACATECASZACATECAS16/01/200019CASADAZACATECAS1011NO HA TENIDO OTROS HIJOS(AS)NaN1SIPRIMERO5SISECUNDARIA COMPLETAHOGARNaN24/05/201923:13:00HOMBRE4256446090ÚNICOZACATECAS00000000
5873375ZACATECASZACATECAS26/06/200018UNIÓN LIBREZACATECAS2022VIVOSI2NONO RECIBIO0SIBACHILLERATO O PREPARATORIA INCOMPLETAHOGARNaN25/05/201901:47:00HOMBRE3949309090ÚNICOZACATECAS00000000
5873376ZACATECASZACATECAS24/09/200216UNIÓN LIBRESAN LUIS POTOSI1011NO HA TENIDO OTROS HIJOS(AS)NaN1SIPRIMERO9SISECUNDARIA INCOMPLETAHOGARNaN25/05/201908:53:00MUJER4054330090ÚNICOZACATECAS00000000
\n", "

5873377 rows × 32 columns

\n", "
" ], "text/plain": [ " edo_captura edo_nac_madre fecha_nac_madre edad_madre \\\n", "0 CHIAPAS CHIAPAS 05/07/1980 36 \n", "1 CHIAPAS CHIAPAS 17/05/1991 25 \n", "2 CHIAPAS CHIAPAS 27/01/1982 35 \n", "3 CHIAPAS CHIAPAS 16/11/1983 33 \n", "4 CHIAPAS CHIAPAS 22/11/1982 34 \n", "... ... ... ... ... \n", "5873372 ZACATECAS OTROS PAISES DE LATINOAMERICA 01/07/1987 31 \n", "5873373 ZACATECAS ZACATECAS 17/07/1986 32 \n", "5873374 ZACATECAS ZACATECAS 16/01/2000 19 \n", "5873375 ZACATECAS ZACATECAS 26/06/2000 18 \n", "5873376 ZACATECAS ZACATECAS 24/09/2002 16 \n", "\n", " estado_conyugal entidad_residencia_madre numero_embarazos \\\n", "0 UNIÓN LIBRE CHIAPAS 9 \n", "1 UNIÓN LIBRE CHIAPAS 4 \n", "2 CASADA CHIAPAS 6 \n", "3 UNIÓN LIBRE CHIAPAS 1 \n", "4 UNIÓN LIBRE CHIAPAS 3 \n", "... ... ... ... \n", "5873372 CASADA ZACATECAS 3 \n", "5873373 CASADA ZACATECAS 3 \n", "5873374 CASADA ZACATECAS 1 \n", "5873375 UNIÓN LIBRE ZACATECAS 2 \n", "5873376 UNIÓN LIBRE SAN LUIS POTOSI 1 \n", "\n", " hijos_nacidos_muertos hijos_nacidos_vivos hijos_sobrevivientes \\\n", "0 1 8 8 \n", "1 99 4 4 \n", "2 0 6 6 \n", "3 0 1 1 \n", "4 99 3 3 \n", "... ... ... ... \n", "5873372 1 2 2 \n", "5873373 0 3 3 \n", "5873374 0 1 1 \n", "5873375 0 2 2 \n", "5873376 0 1 1 \n", "\n", " el_hijo_anterior_nacio vive_aun_hijo_anterior orden_nacimiento \\\n", "0 VIVO SI 9 \n", "1 VIVO SI 4 \n", "2 VIVO SI 6 \n", "3 S.I. NaN 1 \n", "4 VIVO SI 3 \n", "... ... ... ... \n", "5873372 VIVO SI 3 \n", "5873373 VIVO SI 3 \n", "5873374 NO HA TENIDO OTROS HIJOS(AS) NaN 1 \n", "5873375 VIVO SI 2 \n", "5873376 NO HA TENIDO OTROS HIJOS(AS) NaN 1 \n", "\n", " recibio_atencion_prenatal trimestre_recibio_primera_consulta \\\n", "0 SI SEGUNDO \n", "1 SI SEGUNDO \n", "2 SI PRIMERO \n", "3 SI TERCERO \n", "4 SI PRIMERO \n", "... ... ... \n", "5873372 SI PRIMERO \n", "5873373 SI PRIMERO \n", "5873374 SI PRIMERO \n", "5873375 NO NO RECIBIO \n", "5873376 SI PRIMERO \n", "\n", " total_consultas_recibidas madre_sobrevivio_al_parto \\\n", "0 6 SI \n", "1 4 SI \n", "2 3 SI \n", "3 4 SI \n", "4 5 SI \n", "... ... ... \n", "5873372 12 SI \n", "5873373 5 SI \n", "5873374 5 SI \n", "5873375 0 SI \n", "5873376 9 SI \n", "\n", " escolaridad_madre ocupacion_habitual_madre \\\n", "0 NINGUNA HOGAR \n", "1 SECUNDARIA COMPLETA HOGAR \n", "2 PRIMARIA INCOMPLETA AMA DE CASA \n", "3 PRIMARIA COMPLETA AMA DE CASA \n", "4 NINGUNA AMA DE CASA \n", "... ... ... \n", "5873372 PROFESIONAL LIC. EN INFORMATICA \n", "5873373 SECUNDARIA COMPLETA HOGAR \n", "5873374 SECUNDARIA COMPLETA HOGAR \n", "5873375 BACHILLERATO O PREPARATORIA INCOMPLETA HOGAR \n", "5873376 SECUNDARIA INCOMPLETA HOGAR \n", "\n", " trabaja_actualmente fecha_nacimiento_nac_vivo \\\n", "0 NaN 19/04/2017 \n", "1 NaN 11/01/2017 \n", "2 NaN 22/05/2017 \n", "3 NaN 03/06/2017 \n", "4 NaN 29/04/2017 \n", "... ... ... \n", "5873372 SI 23/05/2019 \n", "5873373 NaN 24/05/2019 \n", "5873374 NaN 24/05/2019 \n", "5873375 NaN 25/05/2019 \n", "5873376 NaN 25/05/2019 \n", "\n", " hora_nacimiento_nac_vivo sexo_nac_vivo semanas_gestacion_nac_vivo \\\n", "0 02:00:00 MUJER 40 \n", "1 13:00:00 MUJER 39 \n", "2 12:23:00 MUJER 38 \n", "3 10:35:00 MUJER 99 \n", "4 23:12:00 MUJER 39 \n", "... ... ... ... \n", "5873372 16:06:00 MUJER 39 \n", "5873373 16:55:00 HOMBRE 37 \n", "5873374 23:13:00 HOMBRE 42 \n", "5873375 01:47:00 HOMBRE 39 \n", "5873376 08:53:00 MUJER 40 \n", "\n", " talla_nac_vivo peso_nac_vivo valoracion_apgar_nac_vivo \\\n", "0 50 3100 8 \n", "1 50 3900 0 \n", "2 50 2960 9 \n", "3 48 2900 99 \n", "4 51 3050 9 \n", "... ... ... ... \n", "5873372 49 2990 9 \n", "5873373 50 3830 9 \n", "5873374 56 4460 9 \n", "5873375 49 3090 9 \n", "5873376 54 3300 9 \n", "\n", " valoracion_silverman_nac_vivo producto_de_un_embarazo \\\n", "0 0 ÚNICO \n", "1 0 ÚNICO \n", "2 0 ÚNICO \n", "3 99 ÚNICO \n", "4 0 ÚNICO \n", "... ... ... \n", "5873372 0 ÚNICO \n", "5873373 0 ÚNICO \n", "5873374 0 ÚNICO \n", "5873375 0 ÚNICO \n", "5873376 0 ÚNICO \n", "\n", " entidad_certifico CVE_CIE CVE_CIE2 \n", "0 CHIAPAS 0000 0000 \n", "1 CHIAPAS 0000 0000 \n", "2 CHIAPAS 0000 0000 \n", "3 CHIAPAS 0000 0000 \n", "4 CHIAPAS 0000 0000 \n", "... ... ... ... \n", "5873372 ZACATECAS 0000 0000 \n", "5873373 ZACATECAS 0000 0000 \n", "5873374 ZACATECAS 0000 0000 \n", "5873375 ZACATECAS 0000 0000 \n", "5873376 ZACATECAS 0000 0000 \n", "\n", "[5873377 rows x 32 columns]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[columns_selected + [\"CVE_CIE\", \"CVE_CIE2\"]]" ] }, { "cell_type": "code", "execution_count": 14, "id": "7aaf8aac-3785-4704-b3e2-214a9234602b", "metadata": {}, "outputs": [], "source": [ "def _codigo_de_anomalia(x):\n", " return \",\".join([str(x[\"CVE_CIE\"]), str(x[\"CVE_CIE2\"])])\n", "\n", "\n", "df[\"codigo_anomalia\"] = df[[\"CVE_CIE\", \"CVE_CIE2\"]].apply(_codigo_de_anomalia, axis=1)" ] }, { "cell_type": "code", "execution_count": 16, "id": "f69b89af-239a-4270-818c-89f25f4b2f88", "metadata": {}, "outputs": [], "source": [ "df = df[columns_selected + [\"codigo_anomalia\"]]" ] }, { "cell_type": "code", "execution_count": 17, "id": "904449a1-3e85-4837-ae7c-8e1ee6f3dee9", "metadata": {}, "outputs": [], "source": [ "def _ano_nacimiento_vivo_func(str_date):\n", " try:\n", " return str_date.split(\"/\")[-1]\n", " except:\n", " return \"\"\n", "\n", "\n", "df[\"año_de_nacimiento_vivo\"] = df[\"fecha_nacimiento_nac_vivo\"].apply(\n", " _ano_nacimiento_vivo_func\n", ")" ] }, { "cell_type": "code", "execution_count": 21, "id": "f08a323d-4570-404f-8d11-7288e3973ee7", "metadata": {}, "outputs": [], "source": [ "columnas_finales = [\n", " \"edo_captura\",\n", " \"edo_nac_madre\",\n", " \"fecha_nac_madre\",\n", " \"edad_madre\",\n", " \"estado_conyugal\",\n", " \"entidad_residencia_madre\",\n", " \"numero_embarazos\",\n", " \"hijos_nacidos_muertos\",\n", " \"hijos_nacidos_vivos\",\n", " \"hijos_sobrevivientes\",\n", " \"el_hijo_anterior_nacio\",\n", " \"vive_aun_hijo_anterior\",\n", " \"orden_nacimiento\",\n", " \"recibio_atencion_prenatal\",\n", " \"trimestre_recibio_primera_consulta\",\n", " \"total_consultas_recibidas\",\n", " \"madre_sobrevivio_al_parto\",\n", " \"escolaridad_madre\",\n", " \"ocupacion_habitual_madre\",\n", " \"trabaja_actualmente\",\n", " \"fecha_nacimiento_nac_vivo\",\n", " \"hora_nacimiento_nac_vivo\",\n", " \"sexo_nac_vivo\",\n", " \"semanas_gestacion_nac_vivo\",\n", " \"talla_nac_vivo\",\n", " \"peso_nac_vivo\",\n", " \"valoracion_apgar_nac_vivo\",\n", " \"valoracion_silverman_nac_vivo\",\n", " \"producto_de_un_embarazo\",\n", " \"codigo_anomalia\",\n", " \"entidad_certifico\",\n", "]" ] }, { "cell_type": "code", "execution_count": 23, "id": "010aaf2a-4098-4609-b110-9761902d1118", "metadata": {}, "outputs": [], "source": [ "df[columnas_finales].to_csv(\"2017-2019.csv\")" ] }, { "cell_type": "code", "execution_count": null, "id": "d61bb185-91fa-4872-a2f8-1638c1abc3c4", "metadata": {}, "outputs": [], "source": [] } ], "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.11.6" } }, "nbformat": 4, "nbformat_minor": 5 }