{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Cómo usar `latam`\n", "\n", "## `latam.paises`\n", "Comenzamos importando `latam`" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import latam" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Por el momento la versión `0.1.2` incluye solo a México" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "latam.paises.MEX" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "`latam` viene con 3 tipos de entidades: `Ciudad`, `Subdivision` y `Pais`. México es un `Pais`.\n", "\n", "Viene con la siguiente información:" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'nombre': 'Estados Unidos Mexicanos',\n", " 'nombre_comun': 'México',\n", " 'abrev': 'Mex',\n", " 'nombre_pronunciacion_local': \"'me.xi.ko\",\n", " 'alpha_2': 'MX',\n", " 'alpha_3': 'MEX',\n", " 'codigo': '484',\n", " 'capital': 'Ciudad de México',\n", " 'capital_horario': ,\n", " 'capital_latlong': (19.43, -99.13),\n", " 'es_independiente': True,\n", " 'fecha_independencia': datetime.date(1810, 9, 16),\n", " 'es_isla': False,\n", " 'husos_horarios': [,\n", " ,\n", " ,\n", " ],\n", " 'subdivisiones': {'Aguascalientes': ,\n", " 'Baja California': ,\n", " 'Baja California Sur': ,\n", " 'Campeche': ,\n", " 'Chiapas': ,\n", " 'Cihuahua': ,\n", " 'Coahuila': ,\n", " 'Colima': ,\n", " 'Durango': ,\n", " 'Guanajuato': ,\n", " 'Guerrero': ,\n", " 'Hidalgo': ,\n", " 'Jalisco': ,\n", " 'Estado de México': ,\n", " 'Ciudad de México': ,\n", " 'Michoacán': ,\n", " 'Morelos': ,\n", " 'Nayarit': ,\n", " 'Nuevo León': ,\n", " 'Oaxaca': ,\n", " 'Puebla': ,\n", " 'Queretaro': ,\n", " 'Quintana Roo': ,\n", " 'San Luis Potosí': ,\n", " 'Sinaloa': ,\n", " 'Sonora': ,\n", " 'Tabasco': ,\n", " 'Tamaulipas': ,\n", " 'Tlaxcala': ,\n", " 'Veracrz': ,\n", " 'Yucatán': ,\n", " 'Zacatecas': },\n", " 'df': abrev alpha_2 alpha_3 capital capital_horario capital_lat \\\n", " 0 Mex MX MEX Ciudad de México America/Mexico_City 19.43 \n", " \n", " capital_long codigo es_independiente es_isla fecha_independencia \\\n", " 0 -99.13 484 True False 1810-09-16 \n", " \n", " huso_horario \\\n", " 0 [America/Tijuana, America/Hermosillo, America/... \n", " \n", " nombre nombre_comun nombre_pronunciacion_local \\\n", " 0 Estados Unidos Mexicanos México 'me.xi.ko \n", " \n", " subdivisiones \n", " 0 [Aguascalientes, Baja California, Baja Califor... ,\n", " 'subdivisiones_df': abrev capital capital_horario capital_lat \\\n", " 0 AGS Ciudad de Aguascalientes America/Mexico_City 21.88 \n", " 1 BC Mexicali America/Tijuana 32.67 \n", " 2 BCS La Paz America/Hermosillo 24.14 \n", " 3 CAM San Francisco de Campeche America/Mexico_City 19.85 \n", " 4 CHIS Tuxtla Gutiérrez America/Mexico_City 16.75 \n", " 5 CHIH Chihuahua America/Chihuahua 28.64 \n", " 6 COAH Saltillo America/Chihuahua 25.43 \n", " 7 COL Colima America/Mexico_City 19.24 \n", " 8 DUR Victoria de Durango America/Mexico_City 24.02 \n", " 9 GTO Guanajuato America/Mexico_City 21.02 \n", " 10 GRO Chilpancingo de los Bravo America/Mexico_City 17.55 \n", " 11 HGO Pachuca de Soto America/Mexico_City 20.12 \n", " 12 JAL Guadalajara America/Mexico_City 20.67 \n", " 13 EdoMex Toluca de Lerdo America/Mexico_City 19.29 \n", " 14 CDMX Ciudad de México America/Mexico_City 19.43 \n", " 15 MICH Morelia America/Mexico_City 19.77 \n", " 16 MOR Cuernavaca America/Mexico_City 18.92 \n", " 17 NAY Tepic America/Hermosillo 21.51 \n", " 18 NL Monterrey America/Mexico_City 25.67 \n", " 19 OAX Oaxaca de Juárez America/Mexico_City 17.08 \n", " 20 PUE Heroica Puebla de Zaragoza America/Mexico_City 19.03 \n", " 21 QRO Santiago de Queretaro America/Mexico_City 20.59 \n", " 22 QR Chetumal America/Cancun 18.50 \n", " 23 SLP San Luis Potosí America/Mexico_City 22.15 \n", " 24 SNL Culiacán Rosales America/Hermosillo 24.81 \n", " 25 SON Hermosillo America/Hermosillo 29.09 \n", " 26 TAB Villahermosa America/Mexico_City 17.99 \n", " 27 TAMPS Ciudad Victoria America/Mexico_City 23.73 \n", " 28 TLAX Tlaxcala de Xicohténcat America/Mexico_City 19.31 \n", " 29 VER Xalapa-Enríquez America/Mexico_City 19.54 \n", " 30 YUC Merida America/Mexico_City 20.97 \n", " 31 ZAC Zacatecas America/Mexico_City 22.77 \n", " \n", " capital_long alpha_2 codigo_numerico es_contigua es_isla \\\n", " 0 -102.29 AGU 1 True False \n", " 1 -115.47 BCN 2 True False \n", " 2 -110.31 BCS 3 True False \n", " 3 -90.53 CAM 4 True False \n", " 4 -93.12 CHP 7 True False \n", " 5 -106.09 CHH 8 True False \n", " 6 -101.00 COA 5 True False \n", " 7 -103.73 COL 6 True False \n", " 8 -104.67 DUR 10 True False \n", " 9 -101.26 GUA 11 True False \n", " 10 -99.50 GRO 12 True False \n", " 11 -98.74 HGO 13 True False \n", " 12 -103.35 JAL 14 True False \n", " 13 -99.66 MEX 15 True False \n", " 14 -99.13 CMX 9 True False \n", " 15 -101.19 MIC 16 True False \n", " 16 -99.23 MOR 17 True False \n", " 17 -104.89 NAY 18 True False \n", " 18 -100.30 NLE 19 True False \n", " 19 -96.75 OAX 20 True False \n", " 20 -98.18 PUE 21 True False \n", " 21 -100.39 QUE 22 True False \n", " 22 -88.31 ROO 23 True False \n", " 23 -100.99 SLP 24 True False \n", " 24 -107.39 SIN 25 True False \n", " 25 -110.95 SON 26 True False \n", " 26 -92.93 TAB 27 True False \n", " 27 -99.13 TAM 28 True False \n", " 28 -98.24 TLA 29 True False \n", " 29 -96.93 VER 30 True False \n", " 30 -89.62 YUC 31 True False \n", " 31 -102.57 ZAC 32 True False \n", " \n", " fecha_de_fundacion huso_horario nombre \\\n", " 0 1857-02-05 America/Mexico_City Aguascalientes \n", " 1 1952-01-16 America/Tijuana Baja California \n", " 2 1974-10-08 America/Hermosillo Baja California Sur \n", " 3 1863-04-29 America/Mexico_City Campeche \n", " 4 1824-09-14 America/Mexico_City Chiapas \n", " 5 1824-07-06 America/Chihuahua Chihuahua \n", " 6 1824-05-07 America/Chihuahua Coahuila de Zaragoza \n", " 7 1856-12-09 America/Mexico_City Colima \n", " 8 1824-05-22 America/Mexico_City Durango \n", " 9 1823-12-20 America/Mexico_City Guanajuato \n", " 10 1849-10-27 America/Mexico_City Guerrero \n", " 11 1869-01-16 America/Mexico_City Hidalgo \n", " 12 1823-12-23 America/Mexico_City Jalisco \n", " 13 1823-12-20 America/Mexico_City Estado de México \n", " 14 2016-01-29 America/Mexico_City Ciudad de México \n", " 15 1823-12-22 America/Mexico_City Michoacán de Ocampo \n", " 16 1869-04-17 America/Mexico_City Morelos \n", " 17 1917-01-26 America/Hermosillo Nayarit \n", " 18 1824-05-17 America/Mexico_City Nuevo León \n", " 19 1823-12-21 America/Mexico_City Oaxaca \n", " 20 1823-12-21 America/Mexico_City Puebla \n", " 21 1823-12-23 America/Mexico_City Querétaro de Arteaga \n", " 22 1974-10-08 America/Cancun Quintana Roo \n", " 23 1823-12-22 America/Mexico_City San Luis Potosí \n", " 24 1830-10-14 America/Hermosillo Sinaloa \n", " 25 1824-01-10 America/Hermosillo Sonora \n", " 26 1824-02-07 America/Mexico_City Tabasco \n", " 27 1824-02-07 America/Mexico_City Tamaulipas \n", " 28 1856-12-09 America/Mexico_City Tlaxcala \n", " 29 1823-12-22 America/Mexico_City Veracruz de Ignacio de la Llave \n", " 30 1823-12-23 America/Mexico_City Yucatán \n", " 31 1823-12-23 America/Mexico_City Zacatecas \n", " \n", " nombre_comun nombre_pronunciacion_local \\\n", " 0 Aguascalientes a.ɣ̞was.ka'.ljen̟.tes \n", " 1 Baja California 'ba.xa. ka.li'.for.nja \n", " 2 Baja California Sur 'ba.xa. ka.li'.for.nja 'sur \n", " 3 Campeche kam'pe.tʃe \n", " 4 Chiapas tʃjap'.as \n", " 5 Chihuahua tʃi'.wa.wa \n", " 6 Coahuila koa'.wj.la ðe θa.ra'.ɣ̞o.θa \n", " 7 Colima ko'.li.ma \n", " 8 Durango du'.ɾaŋ.ɡo \n", " 9 Guanajuato gwa.na'.xwa.to \n", " 10 Guerrero ɡe'.re.ɾo \n", " 11 Hidalgo i'.ðal.ɣo \n", " 12 Jalisco xa'.lis.ko \n", " 13 Estado de México es'.ta.ðo ðe 'me.xi.ko \n", " 14 Ciudad de México sju'.ða(ð) ðe 'me.xi.ko \n", " 15 Michoacán mi.tʃoa'.kan de o'.kam.po \n", " 16 Morelos mo'.ɾe.los \n", " 17 Nayarit na.ʝa'.ɾit \n", " 18 Nuevo León 'nwe.βo le.'on \n", " 19 Oaxaca wa'.xa.ka \n", " 20 Puebla 'pwe.βla \n", " 21 Queretaro ke'.ɾe.ta.ɾo \n", " 22 Queretaro kin'.ta.na 'roo \n", " 23 San Luis Potosí san 'lwis po.to.'si \n", " 24 Sinaloa si.na'.loa \n", " 25 Sonora so'.no.ɾa \n", " 26 Tabasco ta.'βas.ko \n", " 27 Tamaulipas ta.maw'.li.pas \n", " 28 Tlaxcala tla(k)s'.ka.la \n", " 29 Veracruz be.ɾa'.kɾus \n", " 30 Yucatán ɟʝu.ka.'tan \n", " 31 Zacatecas sa.ka.'te.kas \n", " \n", " nombres_nativos \n", " 0 \n", " 1 \n", " 2 \n", " 3 \n", " 4 \n", " 5 \n", " 6 \n", " 7 \n", " 8 Korian (Tepehuán),Tepēhuahcān (Náhuatl) \n", " 9 kuanhasï juáta (Purépecha) \n", " 10 \n", " 11 \n", " 12 Tlahtohcayotl Xalixco (Náhuatl) \n", " 13 Mēxihco (Náhuatl) \n", " 14 Āltepētl Mēxihco (Náhuatl) \n", " 15 Michhuahcān (Náhuatl) \n", " 16 \n", " 17 \n", " 18 \n", " 19 Huāxyacac (Nahuatl) \n", " 20 Cuetlaxcoapan (Nahuatl) \n", " 21 Hyodi Ndämxei (Otomí) \n", " 22 \n", " 23 \n", " 24 \n", " 25 \n", " 26 \n", " 27 \n", " 28 Tlaxcallān (Nahuatl) \n", " 29 \n", " 30 \n", " 31 }" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "mexico = latam.paises.MEX\n", "mexico.__dict__" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Como puedes ver, México tiene un diccionario de `.subdivisiones` con cada uno de sus estados. \n", "Subdivisión se refiere al primer nivel de gobernación después del nivel nacional. \n", "En algunos paises se le conoce como \"estado\", en otros como \"provincia\" o \"distrito.\"\n", "\n", "Cada `Subdivision` tiene la siguiente información:" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'nombre': 'Baja California',\n", " 'nombre_comun': 'Baja California',\n", " 'nombres_nativos': {},\n", " 'abrev': 'BC',\n", " 'nombre_pronunciacion_local': \"'ba.xa. ka.li'.for.nja\",\n", " 'codigo': 'BCN',\n", " 'codigo_numerico': 2,\n", " 'capital': ,\n", " 'capital_horario': ,\n", " 'capital_latlong': (32.67, -115.47),\n", " 'es_contigua': True,\n", " 'es_isla': False,\n", " 'fecha_de_fundacion': datetime.date(1952, 1, 16),\n", " 'husos_horarios': [],\n", " 'ciudades_grandes': {'Tijuana': }}" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "baja_california = mexico.subdivisiones[\"Baja California\"]\n", "baja_california.__dict__" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Cada `Subdivision` incluye por lo menos una `Ciudad`, su capital. " ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "baja_california.capital" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Cada `Ciudad` incluye la siguiente información:" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'nombre': 'Mexicali',\n", " 'nombre_comun': 'Mexicali',\n", " 'otros_nombres': ['Chicali'],\n", " 'abrev': 'Mxli',\n", " 'nombre_pronunciacion_local': \"me.xi.'ka.li\",\n", " 'latlong': (32.67, -115.47),\n", " 'fecha_de_fundacion': datetime.date(1903, 3, 14),\n", " 'huso_horario': }" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "baja_california.capital.__dict__" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "Entre otras cosas `latam` toma ventaja de ciertos estandares. \n", "* Utilizamos `pytz` para incluir los husos horarios de cada `Ciudad`, `Subdivision` y `Pais`.\n", "* Utilizamos objetos `datetime.date` para las fechas de fundación \n", "* Utilizamos la norma ISO-3611-1 y 2 para los códigos de identificación de cada `Pais` y `Subdivision`.\n", "* Utilizamos el formato EPSG:4326 o WSG84 para la latitud y longitud de cada `Ciudad`.\n", "* Utilizamos el Alfabeto Fonético Internacional (AFI) para el atributo `.nombre_pronunciacion_local`.\n", "\n", "Veamos su utilidad." ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "En la capital de Aguascalientes (Aguascalientes) son las 15H:48M\n", "En la capital de Baja California (Mexicali) son las 13H:48M\n", "En la capital de Baja California Sur (La Paz) son las 13H:48M\n", "En la capital de Campeche (Campeche) son las 15H:48M\n", "En la capital de Chiapas (Tuxtla Gutiérrez) son las 15H:48M\n", "En la capital de Chihuahua (Chihuahua) son las 14H:48M\n", "En la capital de Coahuila (Saltillo) son las 14H:48M\n", "En la capital de Colima (Colima) son las 15H:48M\n", "En la capital de Durango (Durango) son las 15H:48M\n", "En la capital de Guanajuato (Guanajuato) son las 15H:48M\n", "En la capital de Guerrero (Chilpancingo) son las 15H:48M\n", "En la capital de Hidalgo (Pachuca) son las 15H:48M\n", "En la capital de Jalisco (Guadalajara) son las 15H:48M\n", "En la capital de Estado de México (Toluca) son las 15H:48M\n", "En la capital de Ciudad de México (Ciudad de México) son las 15H:48M\n", "En la capital de Michoacán (Morelia) son las 15H:48M\n", "En la capital de Morelos (Cuernavaca) son las 15H:48M\n", "En la capital de Nayarit (Tepic) son las 13H:48M\n", "En la capital de Nuevo León (Monterrey) son las 15H:48M\n", "En la capital de Oaxaca (Oaxaca) son las 15H:48M\n", "En la capital de Puebla (Puebla) son las 15H:48M\n", "En la capital de Queretaro (Queretaro) son las 15H:48M\n", "En la capital de Queretaro (Chetumal) son las 15H:48M\n", "En la capital de San Luis Potosí (San Luis Potosí) son las 15H:48M\n", "En la capital de Sinaloa (Culiacán) son las 13H:48M\n", "En la capital de Sonora (Hermosillo) son las 13H:48M\n", "En la capital de Tabasco (Villahermosa) son las 15H:48M\n", "En la capital de Tamaulipas (Ciudad Victoria) son las 15H:48M\n", "En la capital de Tlaxcala (Tlaxcala) son las 15H:48M\n", "En la capital de Veracruz (Xalapa) son las 15H:48M\n", "En la capital de Yucatán (Merida) son las 15H:48M\n", "En la capital de Zacatecas (Zacatecas) son las 15H:48M\n" ] } ], "source": [ "from datetime import datetime as dt\n", "for subdivision in mexico.subdivisiones.values():\n", " print(f\"En la capital de {subdivision.nombre_comun} ({subdivision.capital.nombre_comun}) son las {dt.now(tz = subdivision.capital.huso_horario).strftime('%HH:%MM')}\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "Cada `Pais` también tiene los atributos `.df` y `.subdivisiones_df` los cuales son DataFrames de Pandas con la información del país y sus subdivisiones, respectivamente." ] }, { "cell_type": "code", "execution_count": 8, "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", "
abrevalpha_2alpha_3capitalcapital_horariocapital_latcapital_longcodigoes_independientees_islafecha_independenciahuso_horarionombrenombre_comunnombre_pronunciacion_localsubdivisiones
0MexMXMEXCiudad de MéxicoAmerica/Mexico_City19.43-99.13484TrueFalse1810-09-16[America/Tijuana, America/Hermosillo, America/...Estados Unidos MexicanosMéxico'me.xi.ko[Aguascalientes, Baja California, Baja Califor...
\n", "
" ], "text/plain": [ " abrev alpha_2 alpha_3 capital capital_horario capital_lat \\\n", "0 Mex MX MEX Ciudad de México America/Mexico_City 19.43 \n", "\n", " capital_long codigo es_independiente es_isla fecha_independencia \\\n", "0 -99.13 484 True False 1810-09-16 \n", "\n", " huso_horario \\\n", "0 [America/Tijuana, America/Hermosillo, America/... \n", "\n", " nombre nombre_comun nombre_pronunciacion_local \\\n", "0 Estados Unidos Mexicanos México 'me.xi.ko \n", "\n", " subdivisiones \n", "0 [Aguascalientes, Baja California, Baja Califor... " ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "mexico.df" ] }, { "cell_type": "code", "execution_count": 9, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
abrevcapitalcapital_horariocapital_latcapital_longalpha_2codigo_numericoes_contiguaes_islafecha_de_fundacionhuso_horarionombrenombre_comunnombre_pronunciacion_localnombres_nativos
0AGSCiudad de AguascalientesAmerica/Mexico_City21.88-102.29AGU1TrueFalse1857-02-05America/Mexico_CityAguascalientesAguascalientesa.ɣ̞was.ka'.ljen̟.tes
1BCMexicaliAmerica/Tijuana32.67-115.47BCN2TrueFalse1952-01-16America/TijuanaBaja CaliforniaBaja California'ba.xa. ka.li'.for.nja
2BCSLa PazAmerica/Hermosillo24.14-110.31BCS3TrueFalse1974-10-08America/HermosilloBaja California SurBaja California Sur'ba.xa. ka.li'.for.nja 'sur
3CAMSan Francisco de CampecheAmerica/Mexico_City19.85-90.53CAM4TrueFalse1863-04-29America/Mexico_CityCampecheCampechekam'pe.tʃe
4CHISTuxtla GutiérrezAmerica/Mexico_City16.75-93.12CHP7TrueFalse1824-09-14America/Mexico_CityChiapasChiapastʃjap'.as
5CHIHChihuahuaAmerica/Chihuahua28.64-106.09CHH8TrueFalse1824-07-06America/ChihuahuaChihuahuaChihuahuatʃi'.wa.wa
6COAHSaltilloAmerica/Chihuahua25.43-101.00COA5TrueFalse1824-05-07America/ChihuahuaCoahuila de ZaragozaCoahuilakoa'.wj.la ðe θa.ra'.ɣ̞o.θa
7COLColimaAmerica/Mexico_City19.24-103.73COL6TrueFalse1856-12-09America/Mexico_CityColimaColimako'.li.ma
8DURVictoria de DurangoAmerica/Mexico_City24.02-104.67DUR10TrueFalse1824-05-22America/Mexico_CityDurangoDurangodu'.ɾaŋ.ɡoKorian (Tepehuán),Tepēhuahcān (Náhuatl)
9GTOGuanajuatoAmerica/Mexico_City21.02-101.26GUA11TrueFalse1823-12-20America/Mexico_CityGuanajuatoGuanajuatogwa.na'.xwa.tokuanhasï juáta (Purépecha)
10GROChilpancingo de los BravoAmerica/Mexico_City17.55-99.50GRO12TrueFalse1849-10-27America/Mexico_CityGuerreroGuerreroɡe'.re.ɾo
11HGOPachuca de SotoAmerica/Mexico_City20.12-98.74HGO13TrueFalse1869-01-16America/Mexico_CityHidalgoHidalgoi'.ðal.ɣo
12JALGuadalajaraAmerica/Mexico_City20.67-103.35JAL14TrueFalse1823-12-23America/Mexico_CityJaliscoJaliscoxa'.lis.koTlahtohcayotl Xalixco (Náhuatl)
13EdoMexToluca de LerdoAmerica/Mexico_City19.29-99.66MEX15TrueFalse1823-12-20America/Mexico_CityEstado de MéxicoEstado de Méxicoes'.ta.ðo ðe 'me.xi.koMēxihco (Náhuatl)
14CDMXCiudad de MéxicoAmerica/Mexico_City19.43-99.13CMX9TrueFalse2016-01-29America/Mexico_CityCiudad de MéxicoCiudad de Méxicosju'.ða(ð) ðe 'me.xi.koĀltepētl Mēxihco (Náhuatl)
15MICHMoreliaAmerica/Mexico_City19.77-101.19MIC16TrueFalse1823-12-22America/Mexico_CityMichoacán de OcampoMichoacánmi.tʃoa'.kan de o'.kam.poMichhuahcān (Náhuatl)
16MORCuernavacaAmerica/Mexico_City18.92-99.23MOR17TrueFalse1869-04-17America/Mexico_CityMorelosMorelosmo'.ɾe.los
17NAYTepicAmerica/Hermosillo21.51-104.89NAY18TrueFalse1917-01-26America/HermosilloNayaritNayaritna.ʝa'.ɾit
18NLMonterreyAmerica/Mexico_City25.67-100.30NLE19TrueFalse1824-05-17America/Mexico_CityNuevo LeónNuevo León'nwe.βo le.'on
19OAXOaxaca de JuárezAmerica/Mexico_City17.08-96.75OAX20TrueFalse1823-12-21America/Mexico_CityOaxacaOaxacawa'.xa.kaHuāxyacac (Nahuatl)
20PUEHeroica Puebla de ZaragozaAmerica/Mexico_City19.03-98.18PUE21TrueFalse1823-12-21America/Mexico_CityPueblaPuebla'pwe.βlaCuetlaxcoapan (Nahuatl)
21QROSantiago de QueretaroAmerica/Mexico_City20.59-100.39QUE22TrueFalse1823-12-23America/Mexico_CityQuerétaro de ArteagaQueretaroke'.ɾe.ta.ɾoHyodi Ndämxei (Otomí)
22QRChetumalAmerica/Cancun18.50-88.31ROO23TrueFalse1974-10-08America/CancunQuintana RooQueretarokin'.ta.na 'roo
23SLPSan Luis PotosíAmerica/Mexico_City22.15-100.99SLP24TrueFalse1823-12-22America/Mexico_CitySan Luis PotosíSan Luis Potosísan 'lwis po.to.'si
24SNLCuliacán RosalesAmerica/Hermosillo24.81-107.39SIN25TrueFalse1830-10-14America/HermosilloSinaloaSinaloasi.na'.loa
25SONHermosilloAmerica/Hermosillo29.09-110.95SON26TrueFalse1824-01-10America/HermosilloSonoraSonoraso'.no.ɾa
26TABVillahermosaAmerica/Mexico_City17.99-92.93TAB27TrueFalse1824-02-07America/Mexico_CityTabascoTabascota.'βas.ko
27TAMPSCiudad VictoriaAmerica/Mexico_City23.73-99.13TAM28TrueFalse1824-02-07America/Mexico_CityTamaulipasTamaulipasta.maw'.li.pas
28TLAXTlaxcala de XicohténcatAmerica/Mexico_City19.31-98.24TLA29TrueFalse1856-12-09America/Mexico_CityTlaxcalaTlaxcalatla(k)s'.ka.laTlaxcallān (Nahuatl)
29VERXalapa-EnríquezAmerica/Mexico_City19.54-96.93VER30TrueFalse1823-12-22America/Mexico_CityVeracruz de Ignacio de la LlaveVeracruzbe.ɾa'.kɾus
30YUCMeridaAmerica/Mexico_City20.97-89.62YUC31TrueFalse1823-12-23America/Mexico_CityYucatánYucatánɟʝu.ka.'tan
31ZACZacatecasAmerica/Mexico_City22.77-102.57ZAC32TrueFalse1823-12-23America/Mexico_CityZacatecasZacatecassa.ka.'te.kas
\n", "
" ], "text/plain": [ " abrev capital capital_horario capital_lat \\\n", "0 AGS Ciudad de Aguascalientes America/Mexico_City 21.88 \n", "1 BC Mexicali America/Tijuana 32.67 \n", "2 BCS La Paz America/Hermosillo 24.14 \n", "3 CAM San Francisco de Campeche America/Mexico_City 19.85 \n", "4 CHIS Tuxtla Gutiérrez America/Mexico_City 16.75 \n", "5 CHIH Chihuahua America/Chihuahua 28.64 \n", "6 COAH Saltillo America/Chihuahua 25.43 \n", "7 COL Colima America/Mexico_City 19.24 \n", "8 DUR Victoria de Durango America/Mexico_City 24.02 \n", "9 GTO Guanajuato America/Mexico_City 21.02 \n", "10 GRO Chilpancingo de los Bravo America/Mexico_City 17.55 \n", "11 HGO Pachuca de Soto America/Mexico_City 20.12 \n", "12 JAL Guadalajara America/Mexico_City 20.67 \n", "13 EdoMex Toluca de Lerdo America/Mexico_City 19.29 \n", "14 CDMX Ciudad de México America/Mexico_City 19.43 \n", "15 MICH Morelia America/Mexico_City 19.77 \n", "16 MOR Cuernavaca America/Mexico_City 18.92 \n", "17 NAY Tepic America/Hermosillo 21.51 \n", "18 NL Monterrey America/Mexico_City 25.67 \n", "19 OAX Oaxaca de Juárez America/Mexico_City 17.08 \n", "20 PUE Heroica Puebla de Zaragoza America/Mexico_City 19.03 \n", "21 QRO Santiago de Queretaro America/Mexico_City 20.59 \n", "22 QR Chetumal America/Cancun 18.50 \n", "23 SLP San Luis Potosí America/Mexico_City 22.15 \n", "24 SNL Culiacán Rosales America/Hermosillo 24.81 \n", "25 SON Hermosillo America/Hermosillo 29.09 \n", "26 TAB Villahermosa America/Mexico_City 17.99 \n", "27 TAMPS Ciudad Victoria America/Mexico_City 23.73 \n", "28 TLAX Tlaxcala de Xicohténcat America/Mexico_City 19.31 \n", "29 VER Xalapa-Enríquez America/Mexico_City 19.54 \n", "30 YUC Merida America/Mexico_City 20.97 \n", "31 ZAC Zacatecas America/Mexico_City 22.77 \n", "\n", " capital_long alpha_2 codigo_numerico es_contigua es_isla \\\n", "0 -102.29 AGU 1 True False \n", "1 -115.47 BCN 2 True False \n", "2 -110.31 BCS 3 True False \n", "3 -90.53 CAM 4 True False \n", "4 -93.12 CHP 7 True False \n", "5 -106.09 CHH 8 True False \n", "6 -101.00 COA 5 True False \n", "7 -103.73 COL 6 True False \n", "8 -104.67 DUR 10 True False \n", "9 -101.26 GUA 11 True False \n", "10 -99.50 GRO 12 True False \n", "11 -98.74 HGO 13 True False \n", "12 -103.35 JAL 14 True False \n", "13 -99.66 MEX 15 True False \n", "14 -99.13 CMX 9 True False \n", "15 -101.19 MIC 16 True False \n", "16 -99.23 MOR 17 True False \n", "17 -104.89 NAY 18 True False \n", "18 -100.30 NLE 19 True False \n", "19 -96.75 OAX 20 True False \n", "20 -98.18 PUE 21 True False \n", "21 -100.39 QUE 22 True False \n", "22 -88.31 ROO 23 True False \n", "23 -100.99 SLP 24 True False \n", "24 -107.39 SIN 25 True False \n", "25 -110.95 SON 26 True False \n", "26 -92.93 TAB 27 True False \n", "27 -99.13 TAM 28 True False \n", "28 -98.24 TLA 29 True False \n", "29 -96.93 VER 30 True False \n", "30 -89.62 YUC 31 True False \n", "31 -102.57 ZAC 32 True False \n", "\n", " fecha_de_fundacion huso_horario nombre \\\n", "0 1857-02-05 America/Mexico_City Aguascalientes \n", "1 1952-01-16 America/Tijuana Baja California \n", "2 1974-10-08 America/Hermosillo Baja California Sur \n", "3 1863-04-29 America/Mexico_City Campeche \n", "4 1824-09-14 America/Mexico_City Chiapas \n", "5 1824-07-06 America/Chihuahua Chihuahua \n", "6 1824-05-07 America/Chihuahua Coahuila de Zaragoza \n", "7 1856-12-09 America/Mexico_City Colima \n", "8 1824-05-22 America/Mexico_City Durango \n", "9 1823-12-20 America/Mexico_City Guanajuato \n", "10 1849-10-27 America/Mexico_City Guerrero \n", "11 1869-01-16 America/Mexico_City Hidalgo \n", "12 1823-12-23 America/Mexico_City Jalisco \n", "13 1823-12-20 America/Mexico_City Estado de México \n", "14 2016-01-29 America/Mexico_City Ciudad de México \n", "15 1823-12-22 America/Mexico_City Michoacán de Ocampo \n", "16 1869-04-17 America/Mexico_City Morelos \n", "17 1917-01-26 America/Hermosillo Nayarit \n", "18 1824-05-17 America/Mexico_City Nuevo León \n", "19 1823-12-21 America/Mexico_City Oaxaca \n", "20 1823-12-21 America/Mexico_City Puebla \n", "21 1823-12-23 America/Mexico_City Querétaro de Arteaga \n", "22 1974-10-08 America/Cancun Quintana Roo \n", "23 1823-12-22 America/Mexico_City San Luis Potosí \n", "24 1830-10-14 America/Hermosillo Sinaloa \n", "25 1824-01-10 America/Hermosillo Sonora \n", "26 1824-02-07 America/Mexico_City Tabasco \n", "27 1824-02-07 America/Mexico_City Tamaulipas \n", "28 1856-12-09 America/Mexico_City Tlaxcala \n", "29 1823-12-22 America/Mexico_City Veracruz de Ignacio de la Llave \n", "30 1823-12-23 America/Mexico_City Yucatán \n", "31 1823-12-23 America/Mexico_City Zacatecas \n", "\n", " nombre_comun nombre_pronunciacion_local \\\n", "0 Aguascalientes a.ɣ̞was.ka'.ljen̟.tes \n", "1 Baja California 'ba.xa. ka.li'.for.nja \n", "2 Baja California Sur 'ba.xa. ka.li'.for.nja 'sur \n", "3 Campeche kam'pe.tʃe \n", "4 Chiapas tʃjap'.as \n", "5 Chihuahua tʃi'.wa.wa \n", "6 Coahuila koa'.wj.la ðe θa.ra'.ɣ̞o.θa \n", "7 Colima ko'.li.ma \n", "8 Durango du'.ɾaŋ.ɡo \n", "9 Guanajuato gwa.na'.xwa.to \n", "10 Guerrero ɡe'.re.ɾo \n", "11 Hidalgo i'.ðal.ɣo \n", "12 Jalisco xa'.lis.ko \n", "13 Estado de México es'.ta.ðo ðe 'me.xi.ko \n", "14 Ciudad de México sju'.ða(ð) ðe 'me.xi.ko \n", "15 Michoacán mi.tʃoa'.kan de o'.kam.po \n", "16 Morelos mo'.ɾe.los \n", "17 Nayarit na.ʝa'.ɾit \n", "18 Nuevo León 'nwe.βo le.'on \n", "19 Oaxaca wa'.xa.ka \n", "20 Puebla 'pwe.βla \n", "21 Queretaro ke'.ɾe.ta.ɾo \n", "22 Queretaro kin'.ta.na 'roo \n", "23 San Luis Potosí san 'lwis po.to.'si \n", "24 Sinaloa si.na'.loa \n", "25 Sonora so'.no.ɾa \n", "26 Tabasco ta.'βas.ko \n", "27 Tamaulipas ta.maw'.li.pas \n", "28 Tlaxcala tla(k)s'.ka.la \n", "29 Veracruz be.ɾa'.kɾus \n", "30 Yucatán ɟʝu.ka.'tan \n", "31 Zacatecas sa.ka.'te.kas \n", "\n", " nombres_nativos \n", "0 \n", "1 \n", "2 \n", "3 \n", "4 \n", "5 \n", "6 \n", "7 \n", "8 Korian (Tepehuán),Tepēhuahcān (Náhuatl) \n", "9 kuanhasï juáta (Purépecha) \n", "10 \n", "11 \n", "12 Tlahtohcayotl Xalixco (Náhuatl) \n", "13 Mēxihco (Náhuatl) \n", "14 Āltepētl Mēxihco (Náhuatl) \n", "15 Michhuahcān (Náhuatl) \n", "16 \n", "17 \n", "18 \n", "19 Huāxyacac (Nahuatl) \n", "20 Cuetlaxcoapan (Nahuatl) \n", "21 Hyodi Ndämxei (Otomí) \n", "22 \n", "23 \n", "24 \n", "25 \n", "26 \n", "27 \n", "28 Tlaxcallān (Nahuatl) \n", "29 \n", "30 \n", "31 " ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "mexico.subdivisiones_df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Esto es para facilitar el análisis de los datos ya que Pandas es una herramienta común en el mundo del análisis de datos en python." ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [], "source": [ "import folium" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [], "source": [ "mapa = folium.Map(\n", " location=[25,-100],\n", " tiles='Stamen Toner',\n", " zoom_start=5,\n", ")\n", "\n", "for fila in mexico.subdivisiones_df.itertuples():\n", " folium.Marker(\n", " location=[fila.capital_lat, fila.capital_long],\n", " popup=f\"{fila.capital}, {fila.nombre_comun}\",\n", " icon=folium.Icon(color='red')\n", " ).add_to(mapa)" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "tags": [ "full-width" ] }, "outputs": [ { "data": { "text/html": [ "
Make this Notebook Trusted to load map: File -> Trust Notebook
" ], "text/plain": [ "" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "mapa" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.8" } }, "nbformat": 4, "nbformat_minor": 4 }