notebooks/1. Data_Extraction.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Importar librerias y la llave de autenticación de la API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "En este proyecto, no es peligroso compartir llaves de autenticación, pero es una buena práctica no incluirla en el codigo ni en el repositorio. Ir [aqui](https://datosabiertos.enacom.gob.ar/developers/) para obtener una key."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('../auth_key.txt', 'r') as file: # abre y lee el documento en este path\n",
    "    auth_key = file.read().strip() # guarda el contenido del documento en esta variable y le quita los espacios"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Extraction"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'result': None, 'status': None, 'endpoint': 'file://15121/43161/33187717348953697082139756101641380279', 'description': 'Listado de radioaficionados activos', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1687370485000, 'created_at': 1687370479, 'title': 'Listado de Radioaficionados', 'modified_at': 1687370485, 'category_id': '83493', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/197452/listado-de-radioaficionados/', 'user': 'jcarlino', 'status_str': None, 'guid': 'LISTA-DE-RADIO', 'category_name': 'Espectro Radioelectrico'}, {'result': None, 'status': None, 'endpoint': 'file://15121/43161/272913868098282186735641071518799051382', 'description': 'Estadísticas mensuales sobre denuncias y reclamos recibidos por las delegaciones de Enacom', 'parameters': [], 'tags': ['denuncias', 'reclamos'], 'last_revision_id': None, 'timestamp': 1687368671000, 'created_at': 1687368646, 'title': 'Denuncias y reclamos', 'modified_at': 1687368671, 'category_id': '83723', 'methods': None, 'sources': ['Delegaciones Enacom'], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/175520/denuncias-y-reclamos/', 'user': 'CLOSED.cpinfante', 'status_str': None, 'guid': 'DENUN-Y-RECLA-12878', 'category_name': 'Denuncias y Reclamos'}, {'result': None, 'status': None, 'endpoint': 'file://15121/43161/44284949664329718784034050929648151938', 'description': 'Fondos destinados, adjudicados y pagados en programas de servicio universal', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1687367131000, 'created_at': 1687367119, 'title': 'Fondos de servicio universal', 'modified_at': 1687367131, 'category_id': '83830', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196337/fondos-de-servicio-universal/', 'user': 'asrozada', 'status_str': None, 'guid': 'FONDO-DE-SERVI-UNIVE', 'category_name': 'Servicio Universal'}, {'result': None, 'status': None, 'endpoint': 'file://15121/43161/323936423526713957215113353675576214076', 'description': 'Cantidad de proyectos adjudicados por año y cantidad de beneficiarios alcanzados con los mismos.', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1687365863000, 'created_at': 1687365848, 'title': 'Proyectos adjudicados y Beneficiarios alcanzados', 'modified_at': 1687365863, 'category_id': '83731', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196528/proyectos-adjudicados-y-beneficiarios-alcanzados/', 'user': 'scravero', 'status_str': None, 'guid': 'PROYE-ADJUD-Y-BENEF-ALCAN', 'category_name': 'FOMECA'}, {'result': None, 'status': None, 'endpoint': 'file://15121/43161/290083473961441343387566534646449466440', 'description': 'Montos en millones de pesos Pagados y Adjudicados por FOMECA', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1687226746000, 'created_at': 1687226712, 'title': 'FOMECA - Pagos y Adjudicaciones', 'modified_at': 1687226746, 'category_id': '83731', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196463/fomeca-pagos-y-adjudicaciones/', 'user': 'scravero', 'status_str': None, 'guid': 'FOMEC-PAGOS-Y-ADJUD-75939', 'category_name': 'FOMECA'}, {'result': None, 'status': None, 'endpoint': 'file://15121/43161/161349748996189495505882452835117927493', 'description': 'Listado de licencias y autorizaciones audiovisuales', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1685991523000, 'created_at': 1685991515, 'title': 'Listado de licencias audiovisuales', 'modified_at': 1685991523, 'category_id': '83742', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/197789/listado-de-licencias-audiovisuales/', 'user': 'asrozada', 'status_str': None, 'guid': 'LISTA-DE-LICEN-AUDIO', 'category_name': 'Licencias'}, {'result': None, 'status': None, 'endpoint': 'file://15121/37231/82979499673601334962538944643734541819', 'description': 'Mapa geolocalizado de las distintas tecnologías disponibles para el acceso a Internet fijo y móvil', 'parameters': [], 'tags': ['internet', 'telefonia movil', 'banda ancha', 'provincial'], 'last_revision_id': None, 'timestamp': 1679516865000, 'created_at': 1679516861, 'title': 'Conectividad al servicio de Internet', 'modified_at': 1679516865, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176294/conectividad-al-servicio-de-internet/', 'user': 'rpereiro', 'status_str': None, 'guid': 'CONEC-AL-SERVI-DE-INTER', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/37231/124758352392734077684966758499452349631', 'description': 'Accesos, ingresos y penetración del servicio', 'parameters': [], 'tags': ['ingresos', 'telefonia fija', 'provincial', 'penetración'], 'last_revision_id': None, 'timestamp': 1679515480000, 'created_at': 1679515477, 'title': 'Telefonía fija', 'modified_at': 1679515480, 'category_id': '83739', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'ondemand', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176414/telefonia-fija/', 'user': 'rpereiro', 'status_str': None, 'guid': 'TELEF-FIJA', 'category_name': 'Telefonía fija'}, {'result': None, 'status': None, 'endpoint': 'file://15121/39231/115545706106141568592483326689586978153', 'description': 'Accesos, llamadas, minutos, SMS, ingresos y penetración del servicio', 'parameters': [], 'tags': ['ingresos', 'telefonia movil', 'penetración'], 'last_revision_id': None, 'timestamp': 1679435842000, 'created_at': 1679435838, 'title': 'Telefonía móvil', 'modified_at': 1679435842, 'category_id': '83730', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176161/telefonia-movil/', 'user': 'rpereiro', 'status_str': None, 'guid': 'TELEF-MOVIL', 'category_name': 'Telefonía móvil'}, {'result': None, 'status': None, 'endpoint': 'file://15121/39231/302040080508824562211364316240376168457', 'description': 'Correos Privados + Correo Oficial - Unidades de Servicios Postales (Trimestral)', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1679434325000, 'created_at': 1679434323, 'title': 'Mercado Postal - Unidades de Servicios Postales', 'modified_at': 1679434325, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/189691/mercado-postal-unidades-de-servicios-postales/', 'user': 'idawidziuk', 'status_str': None, 'guid': 'MERCA-POSTA-UNIDA-DE-SERVI', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'file://15121/39231/288924164227013097026556890585756748039', 'description': 'Correos Privados + Correo Oficial - Ventas de Servicios Postales (Trimestral)', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1679434299000, 'created_at': 1679434296, 'title': 'Mercado Postal - Ventas de Servicios Postales', 'modified_at': 1679434299, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/189916/mercado-postal-ventas-de-servicios-postales/', 'user': 'idawidziuk', 'status_str': None, 'guid': 'MERCA-POSTA-VENTA-DE-SERVI', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'file://15121/39231/61007794596439725069403526062954155026', 'description': 'Correos Privados + Correo Oficial - Ventas y Unidades por Provincia - Personal Ocupado (Trimestral)', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1679434267000, 'created_at': 1679434261, 'title': 'Mercado Postal - Ventas y Unidades por Provincia - Personal Ocupado', 'modified_at': 1679434267, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/189917/mercado-postal-ventas-y-unidades-por-provincia-personal-ocupado/', 'user': 'idawidziuk', 'status_str': None, 'guid': 'MERCA-POSTA-VENTA-Y-UNIDA', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/44883019853249075674723079188801899514', 'description': 'Penetración del servicio de Internet fijo por métrica de población y métrica de hogares', 'parameters': [], 'tags': ['internet', 'banda ancha', 'penetración'], 'last_revision_id': None, 'timestamp': 1679433343000, 'created_at': 1679433338, 'title': 'Penetración del servicio de Internet fijo', 'modified_at': 1679433343, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176155/penetracion-del-servicio-de-internet-fijo/', 'user': 'nlastra', 'status_str': None, 'guid': 'PENET-DEL-SERVI-DE-INTER', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/185216143225877055803556526887714828647', 'description': 'Accesos, ingresos, penetración de la televisión por suscripción y satelital', 'parameters': [], 'tags': ['ingresos', 'penetración', 'televisión por suscripción', 'televisión satelital'], 'last_revision_id': None, 'timestamp': 1679433075000, 'created_at': 1679433029, 'title': 'Televisión paga', 'modified_at': 1679433075, 'category_id': '83740', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176418/television-paga/', 'user': 'nlastra', 'status_str': None, 'guid': 'TELEV-PAGA', 'category_name': 'TV paga'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/34231934572399101458052606993142863986', 'description': 'Número de accesos al servicio de Internet fijo por tecnología  en cada localidad declarada Categoría', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1679432146000, 'created_at': 1679432000, 'title': 'Accesos a Internet fijo por tecnología y localidad', 'modified_at': 1679432146, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/185537/accesos-a-internet-fijo-por-tecnologia-y-localidad/', 'user': 'nlastra', 'status_str': None, 'guid': 'ACCES-A-INTER-FIJO-46973', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/230096416574664074123064078477672122139', 'description': 'Número de accesos al servicio de Internet fijo por velocidad de bajada en cada localidad declarada', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1679432143000, 'created_at': 1679432064, 'title': 'Accesos a Internet fijo por velocidad de bajada y localidad', 'modified_at': 1679432143, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/185426/accesos-a-internet-fijo-por-velocidad-de-bajada-y-localidad/', 'user': 'nlastra', 'status_str': None, 'guid': 'ACCES-A-INTER-FIJO-86398', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/323412694985426137442164675060720322567', 'description': 'Serie histórica de la velocidad media de bajada de Internet por provincia y nacional (trimestral)', 'parameters': [], 'tags': ['internet', 'velocidad', 'banda ancha'], 'last_revision_id': None, 'timestamp': 1679432140000, 'created_at': 1679432071, 'title': 'Velocidad Media de bajada de Internet por provincia y nacional', 'modified_at': 1679432140, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/179805/velocidad-media-de-bajada-de-internet-por-provincia-y-nacional/', 'user': 'nlastra', 'status_str': None, 'guid': 'VELOC-PROME-DE-BAJAD-DE', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/83477414576439544171692026995617410300', 'description': 'Número de accesos al servicio de Internet fijo por banda ancha y angosta en cada provincia', 'parameters': [], 'tags': ['internet', 'banda ancha', 'provincial', 'banda angosta'], 'last_revision_id': None, 'timestamp': 1679432138000, 'created_at': 1679432080, 'title': 'Acceso a Internet fijo: banda ancha y banda angosta', 'modified_at': 1679432138, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176153/acceso-a-internet-fijo-banda-ancha-y-banda-angosta/', 'user': 'nlastra', 'status_str': None, 'guid': 'ACCES-A-INTER-FIJO-BANDA', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/83249980208134699871201680383929668236', 'description': 'Número de accesos al servicio de Internet fijo por tipo de tecnología en cada provincia', 'parameters': [], 'tags': ['internet', 'banda ancha', 'provincial'], 'last_revision_id': None, 'timestamp': 1679432136000, 'created_at': 1679431590, 'title': 'Acceso a Internet fijo por tecnología y provincia', 'modified_at': 1679432136, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176072/acceso-a-internet-fijo-por-tecnologia-y-provincia/', 'user': 'nlastra', 'status_str': None, 'guid': 'ACCES-A-INTER-FIJO-POR', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/261476698817589619721589971841852060416', 'description': 'Número de accesos al servicio de Internet fijo por rangos de velocidad de bajada en cada provincia', 'parameters': [], 'tags': ['internet', 'banda ancha', 'provincial', 'banda angosta'], 'last_revision_id': None, 'timestamp': 1679432130000, 'created_at': 1679431636, 'title': 'Accesos a Internet fijo por rangos de velocidad bajada  y provincia', 'modified_at': 1679432130, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176090/accesos-a-internet-fijo-por-rangos-de-velocidad-bajada-y-provincia/', 'user': 'nlastra', 'status_str': None, 'guid': 'ACCES-A-INTER-FIJO-51042', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/52070537616547543734200257850480991947', 'description': 'Número de accesos al servicio de Internet fijo por velocidad de bajada en cada provincia', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1679432128000, 'created_at': 1679431949, 'title': 'Accesos a Internet fijo por velocidad bajada  y provincia', 'modified_at': 1679432128, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/180149/accesos-a-internet-fijo-por-velocidad-bajada-y-provincia/', 'user': 'nlastra', 'status_str': None, 'guid': 'ACCES-POR-VELOC-DE-DESCA', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/119489323315239135643440558949163971055', 'description': 'Ingresos trimestrales de los operadores por el servicio de Internet fijo', 'parameters': [], 'tags': ['internet', 'ingresos', 'banda ancha'], 'last_revision_id': None, 'timestamp': 1679432121000, 'created_at': 1679431956, 'title': 'Ingresos por la operación del servicio de Internet fijo', 'modified_at': 1679432121, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176154/ingresos-por-la-operacion-del-servicio-de-internet-fijo/', 'user': 'nlastra', 'status_str': None, 'guid': 'INGRE-POR-LA-OPERA-DEL', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/37231/311951415438627917472348240117662772740', 'description': 'Número de altas y bajas mensuales de la portabilidad numérica móvil por operador', 'parameters': [], 'tags': ['telefonia movil', 'portabilidad'], 'last_revision_id': None, 'timestamp': 1678911476000, 'created_at': 1678911474, 'title': 'Portabilidad numérica móvil por operador', 'modified_at': 1678911476, 'category_id': '83730', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176156/portabilidad-numerica-movil-por-operador/', 'user': 'rpereiro', 'status_str': None, 'guid': 'PORTA-NUMER-MOVIL-POR-OPERA', 'category_name': 'Telefonía móvil'}, {'result': None, 'status': None, 'endpoint': 'file://15121/91951/103220786570765651527117879819395073980', 'description': 'Numeración no geográfica asignada', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1659569628000, 'created_at': 1659569618, 'title': 'Numeración No Geográfica', 'modified_at': 1659569628, 'category_id': '83804', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196783/numeracion-no-geografica/', 'user': 'scravero', 'status_str': None, 'guid': 'NUMER-NO-GEOGR-21454', 'category_name': 'Numeración'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/Servicio_universal/ServicioUniversal_dev.csv', 'description': 'Servicio Universal - Montos destinados, adjudicados y ejecutados por año', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1656377155000, 'created_at': 1656377149, 'title': 'Servicio Universal - Montos destinados, adjudicados y ejecutados', 'modified_at': 1656377155, 'category_id': '83830', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196961/servicio-universal-montos-destinados-adjudicados-y-ejecutados/', 'user': 'asrozada', 'status_str': None, 'guid': 'SERVI-UNIVE-MONTO-DESTI-ADJUD', 'category_name': 'Servicio Universal'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/Empresas_homologadas/Empresas_homologadas.csv', 'description': 'Listado de empresas habilitadas para homologacion de equipos', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1654221615000, 'created_at': 1654221611, 'title': 'Homologaciones Listado de Empresas', 'modified_at': 1654221615, 'category_id': '83496', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'daily', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196899/homologaciones-listado-de-empresas/', 'user': 'asrozada', 'status_str': None, 'guid': 'HOMOL-LISTA-DE-EMPRE', 'category_name': 'Homologación de Equipos'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/Licencias_tics/LicenciasTic.csv', 'description': 'Listado de prestadores con licencias TIC activas', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1654220996000, 'created_at': 1654220805, 'title': 'Listado de licencias TIC otorgadas', 'modified_at': 1654220996, 'category_id': '83742', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'daily', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196600/listado-de-licencias-tic-otorgadas/', 'user': 'asrozada', 'status_str': None, 'guid': 'LISTA-DE-LICEN-TIC-OTORG', 'category_name': 'Licencias'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/Empresas_homologadas/DA_equipos_homologaciones.csv', 'description': 'Listado de equipos homologados', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1652132685000, 'created_at': 1652132644, 'title': 'Equipos Homologados', 'modified_at': 1652132685, 'category_id': '83496', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'daily', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196830/equipos-homologados/', 'user': 'asrozada', 'status_str': None, 'guid': 'EQUIP-HOMOL', 'category_name': 'Homologación de Equipos'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/Numeracion/Numeracion_Geografica.xls', 'description': 'Numeracion geográfica asignada por operador, servicio, modalidad y localidad', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1651723461000, 'created_at': 1651723451, 'title': 'Numeración Geográfica', 'modified_at': 1651723461, 'category_id': '83804', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196864/numeracion-geografica/', 'user': 'asrozada', 'status_str': None, 'guid': 'NUMER-GEOGR-45729', 'category_name': 'Numeración'}, {'result': None, 'status': None, 'endpoint': 'file://15121/16751/220149194550062402857080132970706726811', 'description': 'Listado de licencias y autorizaciones audiovisuales', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1648068972000, 'created_at': 1648068964, 'title': 'Listado licencias y autorizaciones audiovisuales', 'modified_at': 1648068972, 'category_id': '83742', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196739/listado-licencias-y-autorizaciones-audiovisuales/', 'user': 'asrozada', 'status_str': None, 'guid': 'LISTA-LICEN-Y-AUTOR-AUDIO', 'category_name': 'Licencias'}, {'result': None, 'status': None, 'endpoint': 'file://15121/91951/2122138560423185661975640799462590372', 'description': 'Listado de Señales Distintivas especiales', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1643223440000, 'created_at': 1643222538, 'title': 'Señales Distintivas Especiales', 'modified_at': 1643223440, 'category_id': '83493', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196590/senales-distintivas-especiales/', 'user': 'scravero', 'status_str': None, 'guid': 'SENAL-DISTI-ESPEC', 'category_name': 'Espectro Radioelectrico'}, {'result': None, 'status': None, 'endpoint': 'file://15121/91951/45287448986421648602946862406654420627', 'description': 'Listado de Estaciones repetidoras autorizadas', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1643223341000, 'created_at': 1643222944, 'title': 'Estaciones Repetidoras Autorizadas', 'modified_at': 1643223341, 'category_id': '83493', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196591/estaciones-repetidoras-autorizadas/', 'user': 'scravero', 'status_str': None, 'guid': 'ESTAC-REPET-AUTOR', 'category_name': 'Espectro Radioelectrico'}, {'result': None, 'status': None, 'endpoint': 'file://15121/16751/293086406412606278554462902560831156347', 'description': 'Listado de licencias audiovisuales otorgadas', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1641599614000, 'created_at': 1641599192, 'title': 'Listado licencias audiovisuales', 'modified_at': 1641599614, 'category_id': '83742', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196547/listado-licencias-audiovisuales/', 'user': 'asrozada', 'status_str': None, 'guid': 'LISTA-LICEN-AUDIO', 'category_name': 'Licencias'}, {'result': None, 'status': None, 'endpoint': 'file://15121/37231/141262002820081209565995484990203414101', 'description': 'Radiobases reportadas por los operadores en cumplimiento de la Resolución CNC 1494 de 2015', 'parameters': [], 'tags': ['telefonia movil', '4g', 'provincial'], 'last_revision_id': None, 'timestamp': 1640198377000, 'created_at': 1640198373, 'title': 'Despliegue de radiobases 4G', 'modified_at': 1640198377, 'category_id': '83730', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176412/despliegue-de-radiobases-4g/', 'user': 'rpereiro', 'status_str': None, 'guid': 'DESPL-DE-RADIO-4G', 'category_name': 'Telefonía móvil'}, {'result': None, 'status': None, 'endpoint': 'file://15121/16751/52327935223246620038388018377106486589', 'description': 'Mapa para licencias TIC actualizado al 20211126', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1638158178000, 'created_at': 1638158172, 'title': 'Mapa para licencias TIC', 'modified_at': 1638158178, 'category_id': '83742', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/196451/mapa-para-licencias-tic/', 'user': 'asrozada', 'status_str': None, 'guid': 'MAPA-PARA-LICEN-TIC', 'category_name': 'Licencias'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/num_geo.csv', 'description': 'Es la numeración asociada a una zona geográfica en particular.Tiene la siguiente estructura: Indicativo Interurbano + Numero de Abonado', 'parameters': [], 'tags': ['telefonia', 'numeracion'], 'last_revision_id': None, 'timestamp': 1591924457000, 'created_at': 1552503379, 'title': 'Numeración geográfica', 'modified_at': 1591924457, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/169306/numeracion-geografica/', 'user': 'enacom', 'status_str': None, 'guid': 'NUMER-GEOGR', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/num_nogeo.csv', 'description': 'Es aquella numeración que no tiene asociación alguna con una zona geográfica, su destino puede estar en cualquier parte del país', 'parameters': [], 'tags': ['telefonia', 'numeracion'], 'last_revision_id': None, 'timestamp': 1591924453000, 'created_at': 1552503359, 'title': 'Numeración no geográfica', 'modified_at': 1591924453, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/169307/numeracion-no-geografica/', 'user': 'enacom', 'status_str': None, 'guid': 'NUMER-NO-GEOGR', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/RNPSP.csv', 'description': 'Prestadores de servicios postales', 'parameters': [], 'tags': ['licencias'], 'last_revision_id': None, 'timestamp': 1591924422000, 'created_at': 1525889668, 'title': 'Registro de prestadores de servicios postales', 'modified_at': 1591924422, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/178165/registro-de-prestadores-de-servicios-postales/', 'user': 'CLOSED.cpinfante', 'status_str': None, 'guid': 'REGIS-DE-PREST-DE-SERVI', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'https://www.enacom.gob.ar/public/datosabiertos/SPSM.csv', 'description': 'Prestadores de servicios de mensajería', 'parameters': [], 'tags': ['licencias'], 'last_revision_id': None, 'timestamp': 1591924406000, 'created_at': 1525889673, 'title': 'Subregistro de prestadores de servicios de mensajería', 'modified_at': 1591924406, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/178166/subregistro-de-prestadores-de-servicios-de-mensajeria/', 'user': 'CLOSED.cpinfante', 'status_str': None, 'guid': 'SUBRE-DE-PREST-DE-SERVI', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'https://indicadores.enacom.gob.ar/mapasconectividadabierto.aspx', 'description': 'Mapa que incluye todas las tecnologias presentes en cada localiadd', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1591924274000, 'created_at': 1523579920, 'title': 'Mapa de Conectividad', 'modified_at': 1591924274, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/180098/mapa-de-conectividad/', 'user': 'lolivera', 'status_str': None, 'guid': 'MAPA-DE-CONEC', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'http://www.enacom.gob.ar/multimedia/archivos/nomina-de-operadores-postales-RNPSP.xls', 'description': 'Listado de prestadores postales autorizados a dar servicios postales en la Republica Argentina', 'parameters': [], 'tags': ['autorizaciones', 'prestadores postales', 'correo', 'proveedores postales'], 'last_revision_id': None, 'timestamp': 1591924015000, 'created_at': 1474176981, 'title': 'Registro de Proveedores Postales', 'modified_at': 1591924015, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/169283/registro-de-proveedores-postales/', 'user': 'enacom', 'status_str': None, 'guid': 'REGIS-DE-PROVE-POSTA', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'dropbox://Datos Abiertos/DA - Reclamos - V0.xlsx', 'description': 'Reclamos de los usuarios de servicios postales', 'parameters': [], 'tags': ['reclamos', 'usuarios', 'servicios postales'], 'last_revision_id': None, 'timestamp': 1590774308000, 'created_at': 1530217708, 'title': 'Reclamos de usuarios servicios postales', 'modified_at': 1590774308, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'daily', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/180687/reclamos-de-usuarios-servicios-postales/', 'user': 'CLOSED.cpinfante', 'status_str': None, 'guid': 'RECLA-DE-USUAR-SERVI-POSTA', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'dropbox://Datos Abiertos/DA - Sanciones - V1.xlsx', 'description': 'Lista de sanciones por concepto de prestación ilegal de servicios postales.', 'parameters': [], 'tags': ['sanciones', 'prestadores postales', 'servicios postales'], 'last_revision_id': None, 'timestamp': 1590774301000, 'created_at': 1525889268, 'title': 'Sanciones a prestadores postales ilegales', 'modified_at': 1590774301, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'daily', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/180131/sanciones-a-prestadores-postales-ilegales/', 'user': 'CLOSED.cpinfante', 'status_str': None, 'guid': 'SANCI-A-PREST-POSTA-ILEGA', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'dropbox://Datos Abiertos/DA - Libre transito - v0.xlsx', 'description': 'Vehículos utilitarios destinados a la tarea de carga y descarga postal con certificado de libre tránsito y estacionamiento emitido por ENACOM.', 'parameters': [], 'tags': ['certificados', 'proveedores postales'], 'last_revision_id': None, 'timestamp': 1590774291000, 'created_at': 1525889069, 'title': 'Vehículos y motos con certificado de libre tránsito y estacionamiento', 'modified_at': 1590774291, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'daily', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/180250/vehiculos-y-motos-con-certificado-de-libre-transito-y-estacionamiento/', 'user': 'CLOSED.cpinfante', 'status_str': None, 'guid': 'VEHIC-Y-MOTOS-CON-CERTI', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'file://15121/47231/83717018720029466389922395750508193631', 'description': 'Servicios postales: venta de servicios, unidades y personal ocupado', 'parameters': [], 'tags': ['ingresos', 'ocupacion', 'servicios postales', 'servicios telegráficos', 'servicios monetarios'], 'last_revision_id': None, 'timestamp': 1567790444000, 'created_at': 1560192950, 'title': 'Servicios postales', 'modified_at': 1567790444, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'quarterly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/176293/servicios-postales/', 'user': 'idawidziuk', 'status_str': None, 'guid': 'SERVI-POSTA', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'file://15121/89031/19622971086619478128003297424313625445', 'description': 'Inflación, divisas y producto interno bruto', 'parameters': [], 'tags': ['tasa de cambio:dolar', 'macroeconomia'], 'last_revision_id': None, 'timestamp': 1531956897000, 'created_at': 1531956892, 'title': 'Indicadores macroeconómicos', 'modified_at': 1531956897, 'category_id': '83729', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': 'monthly', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/181085/indicadores-macroeconomicos/', 'user': 'CLOSED.cpinfante', 'status_str': None, 'guid': 'INDIC-MACRO', 'category_name': 'Acceso a Internet'}, {'result': None, 'status': None, 'endpoint': 'file://15121/43921/136694966335045317665508831385362765120', 'description': 'Listado de prestadores postales autorizados a dar servicios postales en la Republica Argentina', 'parameters': [], 'tags': ['autorizaciones', 'prestaciones', 'correo', 'proveedores postales'], 'last_revision_id': None, 'timestamp': 1475005392000, 'created_at': 1475005386, 'title': 'Registro de Proveedores Postales', 'modified_at': 1475005392, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/169435/registro-de-proveedores-postales/', 'user': 'enacom', 'status_str': None, 'guid': 'REGIS-DE-PROVE-POSTA-97353', 'category_name': 'Servicios Postales'}, {'result': None, 'status': None, 'endpoint': 'file://15121/43921/15077373221980263436446390108373443130', 'description': 'Listado de prestadores de telefonía - ENACOM', 'parameters': [], 'tags': [], 'last_revision_id': None, 'timestamp': 1474591014000, 'created_at': 1474591010, 'title': 'Listado de prestadores de telefonía', 'modified_at': 1474591014, 'category_id': '83490', 'methods': None, 'sources': [], 'total_revisions': None, 'frequency': '', 'link': 'http://datosabiertos.enacom.gob.ar/datasets/169381/listado-de-prestadores-de-telefonia/', 'user': 'enacom', 'status_str': None, 'guid': 'LISTA-DE-PREST-DE-TELEF', 'category_name': 'Servicios Postales'}]\n"
     ]
    }
   ],
   "source": [
    "total_datasets_api = \"https://api.datosabiertos.enacom.gob.ar/api/v2/datasets/?auth_key={}\".format(auth_key) # links de todos los datasets\n",
    "response = requests.get(total_datasets_api) # guarda la informacion en response\n",
    "\n",
    "if response.status_code == 200: # si el codigo de respuesta es 200, todo ok\n",
    "    total_datasets = response.json()\n",
    "    \n",
    "    print(total_datasets)\n",
    "else:\n",
    "    print(\"Error al realizar la solicitud:\", response.status_code)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>title</th>\n",
       "      <th>category_name</th>\n",
       "      <th>description</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Listado de Radioaficionados</td>\n",
       "      <td>Espectro Radioelectrico</td>\n",
       "      <td>Listado de radioaficionados activos</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Denuncias y reclamos</td>\n",
       "      <td>Denuncias y Reclamos</td>\n",
       "      <td>Estadísticas mensuales sobre denuncias y recla...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fondos de servicio universal</td>\n",
       "      <td>Servicio Universal</td>\n",
       "      <td>Fondos destinados, adjudicados y pagados en pr...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Proyectos adjudicados y Beneficiarios alcanzados</td>\n",
       "      <td>FOMECA</td>\n",
       "      <td>Cantidad de proyectos adjudicados por año y ca...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FOMECA - Pagos y Adjudicaciones</td>\n",
       "      <td>FOMECA</td>\n",
       "      <td>Montos en millones de pesos Pagados y Adjudica...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Listado de licencias audiovisuales</td>\n",
       "      <td>Licencias</td>\n",
       "      <td>Listado de licencias y autorizaciones audiovis...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Conectividad al servicio de Internet</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Mapa geolocalizado de las distintas tecnología...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Telefonía fija</td>\n",
       "      <td>Telefonía fija</td>\n",
       "      <td>Accesos, ingresos y penetración del servicio</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Telefonía móvil</td>\n",
       "      <td>Telefonía móvil</td>\n",
       "      <td>Accesos, llamadas, minutos, SMS, ingresos y pe...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mercado Postal - Unidades de Servicios Postales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Correos Privados + Correo Oficial - Unidades d...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Mercado Postal - Ventas de Servicios Postales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Correos Privados + Correo Oficial - Ventas de ...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mercado Postal - Ventas y Unidades por Provinc...</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Correos Privados + Correo Oficial - Ventas y U...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Penetración del servicio de Internet fijo</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Penetración del servicio de Internet fijo por ...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Televisión paga</td>\n",
       "      <td>TV paga</td>\n",
       "      <td>Accesos, ingresos, penetración de la televisió...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Accesos a Internet fijo por tecnología y local...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Accesos a Internet fijo por velocidad de bajad...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Velocidad Media de bajada de Internet por prov...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Serie histórica de la velocidad media de bajad...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Acceso a Internet fijo: banda ancha y banda an...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Acceso a Internet fijo por tecnología y provincia</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Accesos a Internet fijo por rangos de velocida...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Accesos a Internet fijo por velocidad bajada  ...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Ingresos por la operación del servicio de Inte...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Ingresos trimestrales de los operadores por el...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Portabilidad numérica móvil por operador</td>\n",
       "      <td>Telefonía móvil</td>\n",
       "      <td>Número de altas y bajas mensuales de la portab...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Numeración No Geográfica</td>\n",
       "      <td>Numeración</td>\n",
       "      <td>Numeración no geográfica asignada</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Servicio Universal - Montos destinados, adjudi...</td>\n",
       "      <td>Servicio Universal</td>\n",
       "      <td>Servicio Universal - Montos destinados, adjudi...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Homologaciones Listado de Empresas</td>\n",
       "      <td>Homologación de Equipos</td>\n",
       "      <td>Listado de empresas habilitadas para homologac...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Listado de licencias TIC otorgadas</td>\n",
       "      <td>Licencias</td>\n",
       "      <td>Listado de prestadores con licencias TIC activas</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Equipos Homologados</td>\n",
       "      <td>Homologación de Equipos</td>\n",
       "      <td>Listado de equipos homologados</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Numeración Geográfica</td>\n",
       "      <td>Numeración</td>\n",
       "      <td>Numeracion geográfica asignada por operador, s...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Listado licencias y autorizaciones audiovisuales</td>\n",
       "      <td>Licencias</td>\n",
       "      <td>Listado de licencias y autorizaciones audiovis...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Señales Distintivas Especiales</td>\n",
       "      <td>Espectro Radioelectrico</td>\n",
       "      <td>Listado de Señales Distintivas especiales</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Estaciones Repetidoras Autorizadas</td>\n",
       "      <td>Espectro Radioelectrico</td>\n",
       "      <td>Listado de Estaciones repetidoras autorizadas</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Listado licencias audiovisuales</td>\n",
       "      <td>Licencias</td>\n",
       "      <td>Listado de licencias audiovisuales otorgadas</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Despliegue de radiobases 4G</td>\n",
       "      <td>Telefonía móvil</td>\n",
       "      <td>Radiobases reportadas por los operadores en cu...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Mapa para licencias TIC</td>\n",
       "      <td>Licencias</td>\n",
       "      <td>Mapa para licencias TIC actualizado al 20211126</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Numeración geográfica</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Es la numeración asociada a una zona geográfic...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Numeración no geográfica</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Es aquella numeración que no tiene asociación ...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Registro de prestadores de servicios postales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Prestadores de servicios postales</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Subregistro de prestadores de servicios de men...</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Prestadores de servicios de mensajería</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Mapa de Conectividad</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Mapa que incluye todas las tecnologias present...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Registro de Proveedores Postales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Listado de prestadores postales autorizados a ...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Reclamos de usuarios servicios postales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Reclamos de los usuarios de servicios postales</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Sanciones a prestadores postales ilegales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Lista de sanciones por concepto de prestación ...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Vehículos y motos con certificado de libre trá...</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Vehículos utilitarios destinados a la tarea de...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Servicios postales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Servicios postales: venta de servicios, unidad...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Indicadores macroeconómicos</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Inflación, divisas y producto interno bruto</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Registro de Proveedores Postales</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Listado de prestadores postales autorizados a ...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Listado de prestadores de telefonía</td>\n",
       "      <td>Servicios Postales</td>\n",
       "      <td>Listado de prestadores de telefonía - ENACOM</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/16...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title  \\\n",
       "0                         Listado de Radioaficionados   \n",
       "1                                Denuncias y reclamos   \n",
       "2                        Fondos de servicio universal   \n",
       "3    Proyectos adjudicados y Beneficiarios alcanzados   \n",
       "4                     FOMECA - Pagos y Adjudicaciones   \n",
       "5                  Listado de licencias audiovisuales   \n",
       "6                Conectividad al servicio de Internet   \n",
       "7                                      Telefonía fija   \n",
       "8                                     Telefonía móvil   \n",
       "9     Mercado Postal - Unidades de Servicios Postales   \n",
       "10      Mercado Postal - Ventas de Servicios Postales   \n",
       "11  Mercado Postal - Ventas y Unidades por Provinc...   \n",
       "12          Penetración del servicio de Internet fijo   \n",
       "13                                    Televisión paga   \n",
       "14  Accesos a Internet fijo por tecnología y local...   \n",
       "15  Accesos a Internet fijo por velocidad de bajad...   \n",
       "16  Velocidad Media de bajada de Internet por prov...   \n",
       "17  Acceso a Internet fijo: banda ancha y banda an...   \n",
       "18  Acceso a Internet fijo por tecnología y provincia   \n",
       "19  Accesos a Internet fijo por rangos de velocida...   \n",
       "20  Accesos a Internet fijo por velocidad bajada  ...   \n",
       "21  Ingresos por la operación del servicio de Inte...   \n",
       "22           Portabilidad numérica móvil por operador   \n",
       "23                           Numeración No Geográfica   \n",
       "24  Servicio Universal - Montos destinados, adjudi...   \n",
       "25                 Homologaciones Listado de Empresas   \n",
       "26                 Listado de licencias TIC otorgadas   \n",
       "27                                Equipos Homologados   \n",
       "28                              Numeración Geográfica   \n",
       "29   Listado licencias y autorizaciones audiovisuales   \n",
       "30                     Señales Distintivas Especiales   \n",
       "31                 Estaciones Repetidoras Autorizadas   \n",
       "32                    Listado licencias audiovisuales   \n",
       "33                        Despliegue de radiobases 4G   \n",
       "34                            Mapa para licencias TIC   \n",
       "35                              Numeración geográfica   \n",
       "36                           Numeración no geográfica   \n",
       "37      Registro de prestadores de servicios postales   \n",
       "38  Subregistro de prestadores de servicios de men...   \n",
       "39                               Mapa de Conectividad   \n",
       "40                   Registro de Proveedores Postales   \n",
       "41            Reclamos de usuarios servicios postales   \n",
       "42          Sanciones a prestadores postales ilegales   \n",
       "43  Vehículos y motos con certificado de libre trá...   \n",
       "44                                 Servicios postales   \n",
       "45                        Indicadores macroeconómicos   \n",
       "46                   Registro de Proveedores Postales   \n",
       "47                Listado de prestadores de telefonía   \n",
       "\n",
       "              category_name  \\\n",
       "0   Espectro Radioelectrico   \n",
       "1      Denuncias y Reclamos   \n",
       "2        Servicio Universal   \n",
       "3                    FOMECA   \n",
       "4                    FOMECA   \n",
       "5                 Licencias   \n",
       "6         Acceso a Internet   \n",
       "7            Telefonía fija   \n",
       "8           Telefonía móvil   \n",
       "9        Servicios Postales   \n",
       "10       Servicios Postales   \n",
       "11       Servicios Postales   \n",
       "12        Acceso a Internet   \n",
       "13                  TV paga   \n",
       "14        Acceso a Internet   \n",
       "15        Acceso a Internet   \n",
       "16        Acceso a Internet   \n",
       "17        Acceso a Internet   \n",
       "18        Acceso a Internet   \n",
       "19        Acceso a Internet   \n",
       "20        Acceso a Internet   \n",
       "21        Acceso a Internet   \n",
       "22          Telefonía móvil   \n",
       "23               Numeración   \n",
       "24       Servicio Universal   \n",
       "25  Homologación de Equipos   \n",
       "26                Licencias   \n",
       "27  Homologación de Equipos   \n",
       "28               Numeración   \n",
       "29                Licencias   \n",
       "30  Espectro Radioelectrico   \n",
       "31  Espectro Radioelectrico   \n",
       "32                Licencias   \n",
       "33          Telefonía móvil   \n",
       "34                Licencias   \n",
       "35       Servicios Postales   \n",
       "36       Servicios Postales   \n",
       "37       Servicios Postales   \n",
       "38       Servicios Postales   \n",
       "39        Acceso a Internet   \n",
       "40       Servicios Postales   \n",
       "41       Servicios Postales   \n",
       "42       Servicios Postales   \n",
       "43       Servicios Postales   \n",
       "44       Servicios Postales   \n",
       "45        Acceso a Internet   \n",
       "46       Servicios Postales   \n",
       "47       Servicios Postales   \n",
       "\n",
       "                                          description  \\\n",
       "0                 Listado de radioaficionados activos   \n",
       "1   Estadísticas mensuales sobre denuncias y recla...   \n",
       "2   Fondos destinados, adjudicados y pagados en pr...   \n",
       "3   Cantidad de proyectos adjudicados por año y ca...   \n",
       "4   Montos en millones de pesos Pagados y Adjudica...   \n",
       "5   Listado de licencias y autorizaciones audiovis...   \n",
       "6   Mapa geolocalizado de las distintas tecnología...   \n",
       "7        Accesos, ingresos y penetración del servicio   \n",
       "8   Accesos, llamadas, minutos, SMS, ingresos y pe...   \n",
       "9   Correos Privados + Correo Oficial - Unidades d...   \n",
       "10  Correos Privados + Correo Oficial - Ventas de ...   \n",
       "11  Correos Privados + Correo Oficial - Ventas y U...   \n",
       "12  Penetración del servicio de Internet fijo por ...   \n",
       "13  Accesos, ingresos, penetración de la televisió...   \n",
       "14  Número de accesos al servicio de Internet fijo...   \n",
       "15  Número de accesos al servicio de Internet fijo...   \n",
       "16  Serie histórica de la velocidad media de bajad...   \n",
       "17  Número de accesos al servicio de Internet fijo...   \n",
       "18  Número de accesos al servicio de Internet fijo...   \n",
       "19  Número de accesos al servicio de Internet fijo...   \n",
       "20  Número de accesos al servicio de Internet fijo...   \n",
       "21  Ingresos trimestrales de los operadores por el...   \n",
       "22  Número de altas y bajas mensuales de la portab...   \n",
       "23                  Numeración no geográfica asignada   \n",
       "24  Servicio Universal - Montos destinados, adjudi...   \n",
       "25  Listado de empresas habilitadas para homologac...   \n",
       "26   Listado de prestadores con licencias TIC activas   \n",
       "27                     Listado de equipos homologados   \n",
       "28  Numeracion geográfica asignada por operador, s...   \n",
       "29  Listado de licencias y autorizaciones audiovis...   \n",
       "30          Listado de Señales Distintivas especiales   \n",
       "31      Listado de Estaciones repetidoras autorizadas   \n",
       "32       Listado de licencias audiovisuales otorgadas   \n",
       "33  Radiobases reportadas por los operadores en cu...   \n",
       "34    Mapa para licencias TIC actualizado al 20211126   \n",
       "35  Es la numeración asociada a una zona geográfic...   \n",
       "36  Es aquella numeración que no tiene asociación ...   \n",
       "37                  Prestadores de servicios postales   \n",
       "38             Prestadores de servicios de mensajería   \n",
       "39  Mapa que incluye todas las tecnologias present...   \n",
       "40  Listado de prestadores postales autorizados a ...   \n",
       "41     Reclamos de los usuarios de servicios postales   \n",
       "42  Lista de sanciones por concepto de prestación ...   \n",
       "43  Vehículos utilitarios destinados a la tarea de...   \n",
       "44  Servicios postales: venta de servicios, unidad...   \n",
       "45        Inflación, divisas y producto interno bruto   \n",
       "46  Listado de prestadores postales autorizados a ...   \n",
       "47       Listado de prestadores de telefonía - ENACOM   \n",
       "\n",
       "                                                 link  \n",
       "0   http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "1   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "2   http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "3   http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "4   http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "5   http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "6   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "7   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "8   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "9   http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "10  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "11  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "12  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "13  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "14  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "15  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "16  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "17  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "18  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "19  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "20  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "21  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "22  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "23  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "24  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "25  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "26  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "27  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "28  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "29  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "30  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "31  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "32  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "33  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "34  http://datosabiertos.enacom.gob.ar/datasets/19...  \n",
       "35  http://datosabiertos.enacom.gob.ar/datasets/16...  \n",
       "36  http://datosabiertos.enacom.gob.ar/datasets/16...  \n",
       "37  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "38  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "39  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "40  http://datosabiertos.enacom.gob.ar/datasets/16...  \n",
       "41  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "42  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "43  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "44  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "45  http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "46  http://datosabiertos.enacom.gob.ar/datasets/16...  \n",
       "47  http://datosabiertos.enacom.gob.ar/datasets/16...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chosen_columns = [\"title\", \"category_name\", \"description\", \"link\"] # elegir las columnas a mostrar de la info de la API\n",
    "datasets = pd.DataFrame(total_datasets)[chosen_columns]\n",
    "datasets"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Acceso a Internet  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "`Acceso a Internet` es la categoria principal del proyecto, entonces se filtra la tabla de datasets por nombre de categoria para luego acceder a la columna link."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>title</th>\n",
       "      <th>category_name</th>\n",
       "      <th>description</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Acceso a Internet fijo por tecnología y provincia</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Acceso a Internet fijo: banda ancha y banda an...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Accesos a Internet fijo por rangos de velocida...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Accesos a Internet fijo por tecnología y local...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Accesos a Internet fijo por velocidad bajada  ...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Accesos a Internet fijo por velocidad de bajad...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Número de accesos al servicio de Internet fijo...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Conectividad al servicio de Internet</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Mapa geolocalizado de las distintas tecnología...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Indicadores macroeconómicos</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Inflación, divisas y producto interno bruto</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ingresos por la operación del servicio de Inte...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Ingresos trimestrales de los operadores por el...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mapa de Conectividad</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Mapa que incluye todas las tecnologias present...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Penetración del servicio de Internet fijo</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Penetración del servicio de Internet fijo por ...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Velocidad Media de bajada de Internet por prov...</td>\n",
       "      <td>Acceso a Internet</td>\n",
       "      <td>Serie histórica de la velocidad media de bajad...</td>\n",
       "      <td>http://datosabiertos.enacom.gob.ar/datasets/17...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title      category_name  \\\n",
       "0   Acceso a Internet fijo por tecnología y provincia  Acceso a Internet   \n",
       "1   Acceso a Internet fijo: banda ancha y banda an...  Acceso a Internet   \n",
       "2   Accesos a Internet fijo por rangos de velocida...  Acceso a Internet   \n",
       "3   Accesos a Internet fijo por tecnología y local...  Acceso a Internet   \n",
       "4   Accesos a Internet fijo por velocidad bajada  ...  Acceso a Internet   \n",
       "5   Accesos a Internet fijo por velocidad de bajad...  Acceso a Internet   \n",
       "6                Conectividad al servicio de Internet  Acceso a Internet   \n",
       "7                         Indicadores macroeconómicos  Acceso a Internet   \n",
       "8   Ingresos por la operación del servicio de Inte...  Acceso a Internet   \n",
       "9                                Mapa de Conectividad  Acceso a Internet   \n",
       "10          Penetración del servicio de Internet fijo  Acceso a Internet   \n",
       "11  Velocidad Media de bajada de Internet por prov...  Acceso a Internet   \n",
       "\n",
       "                                          description  \\\n",
       "0   Número de accesos al servicio de Internet fijo...   \n",
       "1   Número de accesos al servicio de Internet fijo...   \n",
       "2   Número de accesos al servicio de Internet fijo...   \n",
       "3   Número de accesos al servicio de Internet fijo...   \n",
       "4   Número de accesos al servicio de Internet fijo...   \n",
       "5   Número de accesos al servicio de Internet fijo...   \n",
       "6   Mapa geolocalizado de las distintas tecnología...   \n",
       "7         Inflación, divisas y producto interno bruto   \n",
       "8   Ingresos trimestrales de los operadores por el...   \n",
       "9   Mapa que incluye todas las tecnologias present...   \n",
       "10  Penetración del servicio de Internet fijo por ...   \n",
       "11  Serie histórica de la velocidad media de bajad...   \n",
       "\n",
       "                                                 link  \n",
       "0   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "1   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "2   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "3   http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "4   http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "5   http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "6   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "7   http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "8   http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "9   http://datosabiertos.enacom.gob.ar/datasets/18...  \n",
       "10  http://datosabiertos.enacom.gob.ar/datasets/17...  \n",
       "11  http://datosabiertos.enacom.gob.ar/datasets/17...  "
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "acceso_internet = datasets[datasets[\"category_name\"] == \"Acceso a Internet\"].sort_values(by=\"title\").reset_index(drop=True)\n",
    "acceso_internet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://datosabiertos.enacom.gob.ar/datasets/176072/acceso-a-internet-fijo-por-tecnologia-y-provincia/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/176153/acceso-a-internet-fijo-banda-ancha-y-banda-angosta/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/176090/accesos-a-internet-fijo-por-rangos-de-velocidad-bajada-y-provincia/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/185537/accesos-a-internet-fijo-por-tecnologia-y-localidad/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/180149/accesos-a-internet-fijo-por-velocidad-bajada-y-provincia/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/185426/accesos-a-internet-fijo-por-velocidad-de-bajada-y-localidad/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/176294/conectividad-al-servicio-de-internet/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/181085/indicadores-macroeconomicos/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/176154/ingresos-por-la-operacion-del-servicio-de-internet-fijo/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/180098/mapa-de-conectividad/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/176155/penetracion-del-servicio-de-internet-fijo/\n",
      "http://datosabiertos.enacom.gob.ar/datasets/179805/velocidad-media-de-bajada-de-internet-por-provincia-y-nacional/\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(acceso_internet[\"link\"])):\n",
    "    print (acceso_internet[\"link\"][i])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para evitar repetir codigo, se crea una función que extrae el contenido de los links conectandose a la dirección de la API que esta dentro de cada uno."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_dataframe(api_dataset):\n",
    "    response = requests.get(api_dataset)  \n",
    "    if response.status_code == 200:  \n",
    "        api_dataset = response.json()  # la columna \"result\" tiene la informacion requerida\n",
    "        api_dataset = pd.DataFrame(api_dataset[\"result\"], columns=api_dataset[\"result\"][0]) # el nombre las columnas esta en la primera fila\n",
    "        api_dataset = api_dataset[1:] # se ignora la primera fila\n",
    "        return api_dataset\n",
    "    else:\n",
    "        return (\"Error:\", response.status_code)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Acceso a Internet fijo por tecnología y provincia  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>ADSL</th>\n",
       "      <th>Cablemodem</th>\n",
       "      <th>Fibra óptica</th>\n",
       "      <th>Wireless</th>\n",
       "      <th>Otros</th>\n",
       "      <th>Total</th>\n",
       "      <th>Periodo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>1,395,277</td>\n",
       "      <td>6,031,970</td>\n",
       "      <td>2,871,541</td>\n",
       "      <td>557,110</td>\n",
       "      <td>235,230</td>\n",
       "      <td>11,091,128</td>\n",
       "      <td>Jul-Sept 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>1,468,333</td>\n",
       "      <td>5,979,214</td>\n",
       "      <td>2,723,285</td>\n",
       "      <td>556,243</td>\n",
       "      <td>231,609</td>\n",
       "      <td>10,958,684</td>\n",
       "      <td>Abr-Jun 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>1,533,240</td>\n",
       "      <td>6,073,426</td>\n",
       "      <td>2,219,533</td>\n",
       "      <td>545,814</td>\n",
       "      <td>251,996</td>\n",
       "      <td>10,624,009</td>\n",
       "      <td>Ene-Mar 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>4</td>\n",
       "      <td>1,657,615</td>\n",
       "      <td>5,984,240</td>\n",
       "      <td>2,072,236</td>\n",
       "      <td>523,107</td>\n",
       "      <td>252,596</td>\n",
       "      <td>10,489,794</td>\n",
       "      <td>Oct-Dic 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>1,950,631</td>\n",
       "      <td>5,826,257</td>\n",
       "      <td>1,566,048</td>\n",
       "      <td>492,415</td>\n",
       "      <td>250,190</td>\n",
       "      <td>10,085,541</td>\n",
       "      <td>Jul-Sept 2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre       ADSL Cablemodem Fibra óptica Wireless    Otros  \\\n",
       "1  2022         3  1,395,277  6,031,970    2,871,541  557,110  235,230   \n",
       "2  2022         2  1,468,333  5,979,214    2,723,285  556,243  231,609   \n",
       "3  2022         1  1,533,240  6,073,426    2,219,533  545,814  251,996   \n",
       "4  2021         4  1,657,615  5,984,240    2,072,236  523,107  252,596   \n",
       "5  2021         3  1,950,631  5,826,257    1,566,048  492,415  250,190   \n",
       "\n",
       "        Total        Periodo  \n",
       "1  11,091,128  Jul-Sept 2022  \n",
       "2  10,958,684   Abr-Jun 2022  \n",
       "3  10,624,009   Ene-Mar 2022  \n",
       "4  10,489,794   Oct-Dic 2021  \n",
       "5  10,085,541  Jul-Sept 2021  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "total_nacional_accesos_internet_fijo_por_tecnologia = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/TOTAL-NACIO-DE-ACCES-A/data.ajson/?auth_key={}\".format(auth_key)\n",
    "total_nacional_accesos_internet_fijo_por_tecnologia_df = get_dataframe(total_nacional_accesos_internet_fijo_por_tecnologia)\n",
    "total_nacional_accesos_internet_fijo_por_tecnologia_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35, 9)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "total_nacional_accesos_internet_fijo_por_tecnologia_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Provincia</th>\n",
       "      <th>ADSL</th>\n",
       "      <th>Cablemodem</th>\n",
       "      <th>Fibra óptica</th>\n",
       "      <th>Wireless</th>\n",
       "      <th>Otros</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Buenos Aires</td>\n",
       "      <td>339,648</td>\n",
       "      <td>2,748,325</td>\n",
       "      <td>1,436,433</td>\n",
       "      <td>126,846</td>\n",
       "      <td>70,416</td>\n",
       "      <td>4,721,668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Capital Federal</td>\n",
       "      <td>140,791</td>\n",
       "      <td>1,240,125</td>\n",
       "      <td>129,218</td>\n",
       "      <td>5,758</td>\n",
       "      <td>31,787</td>\n",
       "      <td>1,547,679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Catamarca</td>\n",
       "      <td>10,010</td>\n",
       "      <td>10,495</td>\n",
       "      <td>46,224</td>\n",
       "      <td>1,329</td>\n",
       "      <td>2,235</td>\n",
       "      <td>70,293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chaco</td>\n",
       "      <td>27,164</td>\n",
       "      <td>61,800</td>\n",
       "      <td>44,645</td>\n",
       "      <td>8,178</td>\n",
       "      <td>2,359</td>\n",
       "      <td>144,146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chubut</td>\n",
       "      <td>45,377</td>\n",
       "      <td>72,212</td>\n",
       "      <td>9,574</td>\n",
       "      <td>29,784</td>\n",
       "      <td>8,831</td>\n",
       "      <td>165,778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre        Provincia     ADSL Cablemodem Fibra óptica Wireless  \\\n",
       "1  2022         3     Buenos Aires  339,648  2,748,325    1,436,433  126,846   \n",
       "2  2022         3  Capital Federal  140,791  1,240,125      129,218    5,758   \n",
       "3  2022         3        Catamarca   10,010     10,495       46,224    1,329   \n",
       "4  2022         3            Chaco   27,164     61,800       44,645    8,178   \n",
       "5  2022         3           Chubut   45,377     72,212        9,574   29,784   \n",
       "\n",
       "    Otros      Total  \n",
       "1  70,416  4,721,668  \n",
       "2  31,787  1,547,679  \n",
       "3   2,235     70,293  \n",
       "4   2,359    144,146  \n",
       "5   8,831    165,778  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "acceso_internet_fijo_por_tecnologia_provincia = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/ACCES-A-INTER-FIJO-POR/data.ajson/?auth_key={}\".format(auth_key)\n",
    "acceso_internet_fijo_por_tecnologia_provincia_df = get_dataframe(acceso_internet_fijo_por_tecnologia_provincia)\n",
    "acceso_internet_fijo_por_tecnologia_provincia_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(841, 9)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "acceso_internet_fijo_por_tecnologia_provincia_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Accesos a Internet fijo por tecnología y localidad "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Provincia</th>\n",
       "      <th>Partido</th>\n",
       "      <th>Localidad</th>\n",
       "      <th>Link Indec</th>\n",
       "      <th>ADSL</th>\n",
       "      <th>CABLEMODEM</th>\n",
       "      <th>DIAL UP</th>\n",
       "      <th>FIBRA OPTICA</th>\n",
       "      <th>OTROS</th>\n",
       "      <th>SATELITAL</th>\n",
       "      <th>WIMAX</th>\n",
       "      <th>WIRELESS</th>\n",
       "      <th>Total general</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>6854100</td>\n",
       "      <td>873</td>\n",
       "      <td>4,704</td>\n",
       "      <td>- 0</td>\n",
       "      <td>2</td>\n",
       "      <td>- 0</td>\n",
       "      <td>975</td>\n",
       "      <td>- 0</td>\n",
       "      <td>664</td>\n",
       "      <td>7,218</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Del Valle</td>\n",
       "      <td>6854020</td>\n",
       "      <td>181</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>192</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Gobernador Ugarte</td>\n",
       "      <td>6854040</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>181</td>\n",
       "      <td>181</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Norberto de la Riestra</td>\n",
       "      <td>6854060</td>\n",
       "      <td>- 0</td>\n",
       "      <td>782</td>\n",
       "      <td>- 0</td>\n",
       "      <td>6</td>\n",
       "      <td>167</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>327</td>\n",
       "      <td>1,282</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Lucas Monteverde</td>\n",
       "      <td>6854050</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Provincia     Partido               Localidad Link Indec ADSL  \\\n",
       "1  BUENOS AIRES  25 de Mayo              25 de Mayo    6854100  873   \n",
       "2  BUENOS AIRES  25 de Mayo               Del Valle    6854020  181   \n",
       "3  BUENOS AIRES  25 de Mayo       Gobernador Ugarte    6854040  - 0   \n",
       "4  BUENOS AIRES  25 de Mayo  Norberto de la Riestra    6854060  - 0   \n",
       "5  BUENOS AIRES  25 de Mayo        Lucas Monteverde    6854050  - 0   \n",
       "\n",
       "  CABLEMODEM DIAL UP FIBRA OPTICA OTROS SATELITAL WIMAX WIRELESS  \\\n",
       "1      4,704     - 0            2   - 0       975   - 0      664   \n",
       "2        - 0     - 0          - 0    10         1   - 0      - 0   \n",
       "3        - 0     - 0          - 0   - 0       - 0   - 0      181   \n",
       "4        782     - 0            6   167       - 0   - 0      327   \n",
       "5        - 0     - 0          - 0   - 0       - 0   - 0        6   \n",
       "\n",
       "  Total general    \n",
       "1         7,218    \n",
       "2           192    \n",
       "3           181    \n",
       "4         1,282    \n",
       "5             6    "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_internet_fijo_por_tecnología_localidad = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/ACCES-A-INTER-FIJO-62463/data.ajson/?auth_key={}\".format(auth_key)\n",
    "accesos_internet_fijo_por_tecnología_localidad_df = get_dataframe(accesos_internet_fijo_por_tecnología_localidad)\n",
    "accesos_internet_fijo_por_tecnología_localidad_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3142, 14)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_internet_fijo_por_tecnología_localidad_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Accesos a Internet fijo por velocidad de bajada y localidad  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Provincia</th>\n",
       "      <th>Partido</th>\n",
       "      <th>Localidad</th>\n",
       "      <th>Link Indec</th>\n",
       "      <th>Otros</th>\n",
       "      <th>0,256 mbps</th>\n",
       "      <th>0,375 mbps</th>\n",
       "      <th>0,5 mbps</th>\n",
       "      <th>0,512 mbps</th>\n",
       "      <th>0,625 mbps</th>\n",
       "      <th>...</th>\n",
       "      <th>75 mbps</th>\n",
       "      <th>78 mbps</th>\n",
       "      <th>80 mbps</th>\n",
       "      <th>82 mbps</th>\n",
       "      <th>83 mbps</th>\n",
       "      <th>85 mbps</th>\n",
       "      <th>90 mbps</th>\n",
       "      <th>92 mbps</th>\n",
       "      <th>95 mbps</th>\n",
       "      <th>100 mbps</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>6854100</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>9</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>2</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Agustín Mosconi</td>\n",
       "      <td>6854010</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>3</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Del Valle</td>\n",
       "      <td>6854020</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1</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>4</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Ernestina</td>\n",
       "      <td>6854030</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>5</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>25 de Mayo</td>\n",
       "      <td>Gobernador Ugarte</td>\n",
       "      <td>6854040</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 83 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Provincia     Partido          Localidad Link Indec Otros 0,256 mbps  \\\n",
       "1  BUENOS AIRES  25 de Mayo         25 de Mayo    6854100                    \n",
       "2  BUENOS AIRES  25 de Mayo    Agustín Mosconi    6854010                    \n",
       "3  BUENOS AIRES  25 de Mayo          Del Valle    6854020                    \n",
       "4  BUENOS AIRES  25 de Mayo          Ernestina    6854030                    \n",
       "5  BUENOS AIRES  25 de Mayo  Gobernador Ugarte    6854040                    \n",
       "\n",
       "  0,375 mbps 0,5 mbps 0,512 mbps 0,625 mbps  ... 75 mbps 78 mbps 80 mbps  \\\n",
       "1                   2                        ...                       9   \n",
       "2                                            ...                           \n",
       "3                   1                        ...                           \n",
       "4                                            ...                           \n",
       "5                                            ...                           \n",
       "\n",
       "  82 mbps 83 mbps 85 mbps 90 mbps 92 mbps 95 mbps 100 mbps  \n",
       "1                                                           \n",
       "2                                                           \n",
       "3                                                           \n",
       "4                                                           \n",
       "5                                                           \n",
       "\n",
       "[5 rows x 83 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_internet_fijo_por_velocidad_localidad = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/ACCES-A-INTER-FIJO-16249/data.ajson/?auth_key={}\".format(auth_key)\n",
    "accesos_internet_fijo_por_velocidad_localidad_df = get_dataframe(accesos_internet_fijo_por_velocidad_localidad)\n",
    "accesos_internet_fijo_por_velocidad_localidad_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3098, 83)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_internet_fijo_por_velocidad_localidad_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Accesos a Internet fijo por velocidad bajada y provincia  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Provincia</th>\n",
       "      <th>Otros</th>\n",
       "      <th>0,256 Mbps</th>\n",
       "      <th>0,375 Mbps</th>\n",
       "      <th>0,625 Mbps</th>\n",
       "      <th>0,5 Mbps</th>\n",
       "      <th>0,512 Mbps</th>\n",
       "      <th>0,75 Mbps</th>\n",
       "      <th>...</th>\n",
       "      <th>70 Mbps</th>\n",
       "      <th>71 Mbps</th>\n",
       "      <th>75 Mbps</th>\n",
       "      <th>77 Mbps</th>\n",
       "      <th>78 Mbps</th>\n",
       "      <th>80 Mbps</th>\n",
       "      <th>81 Mbps</th>\n",
       "      <th>83 Mbps</th>\n",
       "      <th>82 Mbps</th>\n",
       "      <th>86 Mbps</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Buenos Aires</td>\n",
       "      <td>65,821</td>\n",
       "      <td>19</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>29,774</td>\n",
       "      <td>192</td>\n",
       "      <td>4,611</td>\n",
       "      <td>...</td>\n",
       "      <td>3,163</td>\n",
       "      <td>- 0</td>\n",
       "      <td>98,387</td>\n",
       "      <td>- 0</td>\n",
       "      <td>2</td>\n",
       "      <td>223</td>\n",
       "      <td>- 0</td>\n",
       "      <td>1</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Capital Federal</td>\n",
       "      <td>105,477</td>\n",
       "      <td>31</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>451</td>\n",
       "      <td>35</td>\n",
       "      <td>1,307</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>- 0</td>\n",
       "      <td>30,482</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>8</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Catamarca</td>\n",
       "      <td>2,208</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>34</td>\n",
       "      <td>37</td>\n",
       "      <td>- 0</td>\n",
       "      <td>...</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chaco</td>\n",
       "      <td>3,711</td>\n",
       "      <td>- 0</td>\n",
       "      <td>225</td>\n",
       "      <td>111</td>\n",
       "      <td>234</td>\n",
       "      <td>2</td>\n",
       "      <td>- 0</td>\n",
       "      <td>...</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chubut</td>\n",
       "      <td>20,024</td>\n",
       "      <td>8</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>69</td>\n",
       "      <td>32</td>\n",
       "      <td>836</td>\n",
       "      <td>...</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "      <td>- 0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 97 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre        Provincia    Otros 0,256 Mbps 0,375 Mbps 0,625 Mbps  \\\n",
       "1  2022         3     Buenos Aires   65,821         19        - 0        - 0   \n",
       "2  2022         3  Capital Federal  105,477         31        - 0        - 0   \n",
       "3  2022         3        Catamarca    2,208        - 0        - 0        - 0   \n",
       "4  2022         3            Chaco    3,711        - 0        225        111   \n",
       "5  2022         3           Chubut   20,024          8        - 0        - 0   \n",
       "\n",
       "  0,5 Mbps 0,512 Mbps 0,75 Mbps  ... 70 Mbps 71 Mbps 75 Mbps 77 Mbps 78 Mbps  \\\n",
       "1   29,774        192     4,611  ...   3,163     - 0  98,387     - 0       2   \n",
       "2      451         35     1,307  ...       3     - 0  30,482     - 0     - 0   \n",
       "3       34         37       - 0  ...     - 0     - 0     - 0     - 0     - 0   \n",
       "4      234          2       - 0  ...     - 0     - 0     - 0     - 0     - 0   \n",
       "5       69         32       836  ...     - 0     - 0     - 0     - 0     - 0   \n",
       "\n",
       "  80 Mbps 81 Mbps 83 Mbps 82 Mbps 86 Mbps  \n",
       "1     223     - 0       1     - 0     - 0  \n",
       "2       8     - 0     - 0     - 0     - 0  \n",
       "3     - 0     - 0     - 0     - 0     - 0  \n",
       "4     - 0     - 0     - 0     - 0     - 0  \n",
       "5     - 0     - 0     - 0     - 0     - 0  \n",
       "\n",
       "[5 rows x 97 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_internet_fijo_por_velocidad_bajada_provincia = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/ACCES-A-INTER-FIJO-97624/data.ajson/?auth_key={}\".format(auth_key)\n",
    "accesos_internet_fijo_por_velocidad_bajada_provincia_df = get_dataframe(accesos_internet_fijo_por_velocidad_bajada_provincia)\n",
    "accesos_internet_fijo_por_velocidad_bajada_provincia_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(481, 97)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_internet_fijo_por_velocidad_bajada_provincia_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Acceso a Internet fijo: banda ancha y banda angosta  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Banda ancha fija</th>\n",
       "      <th>Dial up</th>\n",
       "      <th>Total</th>\n",
       "      <th>Periodo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>11,078,691</td>\n",
       "      <td>12,437</td>\n",
       "      <td>11,091,128</td>\n",
       "      <td>Jul-Sept 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>10,946,248</td>\n",
       "      <td>12,436</td>\n",
       "      <td>10,958,684</td>\n",
       "      <td>Abr-Jun 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>10,611,390</td>\n",
       "      <td>12,619</td>\n",
       "      <td>10,624,009</td>\n",
       "      <td>Ene-Mar 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>4</td>\n",
       "      <td>10,476,933</td>\n",
       "      <td>12,861</td>\n",
       "      <td>10,489,794</td>\n",
       "      <td>Oct-Dic 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>10,075,184</td>\n",
       "      <td>10,357</td>\n",
       "      <td>10,085,541</td>\n",
       "      <td>Jul-Sept 2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre Banda ancha fija Dial up       Total        Periodo\n",
       "1  2022         3       11,078,691  12,437  11,091,128  Jul-Sept 2022\n",
       "2  2022         2       10,946,248  12,436  10,958,684   Abr-Jun 2022\n",
       "3  2022         1       10,611,390  12,619  10,624,009   Ene-Mar 2022\n",
       "4  2021         4       10,476,933  12,861  10,489,794   Oct-Dic 2021\n",
       "5  2021         3       10,075,184  10,357  10,085,541  Jul-Sept 2021"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "total_nacional_accesos_internet_fijo_por_banda_ancha_banda_angosta = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/TOTAL-NACIO-DE-ACCES-48866/data.ajson/?auth_key={}\".format(auth_key)\n",
    "total_nacional_accesos_internet_fijo_por_banda_ancha_banda_angosta_df = get_dataframe(total_nacional_accesos_internet_fijo_por_banda_ancha_banda_angosta)\n",
    "total_nacional_accesos_internet_fijo_por_banda_ancha_banda_angosta_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35, 6)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "total_nacional_accesos_internet_fijo_por_banda_ancha_banda_angosta_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Provincia</th>\n",
       "      <th>Banda ancha fija</th>\n",
       "      <th>Dial up</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Buenos Aires</td>\n",
       "      <td>4,715,469</td>\n",
       "      <td>6,199</td>\n",
       "      <td>4,721,668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Capital Federal</td>\n",
       "      <td>1,545,534</td>\n",
       "      <td>2,145</td>\n",
       "      <td>1,547,679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Catamarca</td>\n",
       "      <td>70,292</td>\n",
       "      <td>1</td>\n",
       "      <td>70,293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chaco</td>\n",
       "      <td>144,141</td>\n",
       "      <td>5</td>\n",
       "      <td>144,146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chubut</td>\n",
       "      <td>164,874</td>\n",
       "      <td>904</td>\n",
       "      <td>165,778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre        Provincia Banda ancha fija Dial up      Total\n",
       "1  2022         3     Buenos Aires        4,715,469   6,199  4,721,668\n",
       "2  2022         3  Capital Federal        1,545,534   2,145  1,547,679\n",
       "3  2022         3        Catamarca           70,292       1     70,293\n",
       "4  2022         3            Chaco          144,141       5    144,146\n",
       "5  2022         3           Chubut          164,874     904    165,778"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_banda_ancha_banda_angosta_por_provincia = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/BANDA-ANCHA-Y-BANDA-ANGOS/data.ajson/?auth_key={}\".format(auth_key)\n",
    "accesos_banda_ancha_banda_angosta_por_provincia_df = get_dataframe(accesos_banda_ancha_banda_angosta_por_provincia)\n",
    "accesos_banda_ancha_banda_angosta_por_provincia_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(840, 6)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "accesos_banda_ancha_banda_angosta_por_provincia_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Accesos a Internet fijo por rangos de velocidad bajada y provincia  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Provincia</th>\n",
       "      <th>HASTA 512 kbps</th>\n",
       "      <th>+ 512 Kbps - 1 Mbps</th>\n",
       "      <th>+ 1 Mbps - 6 Mbps</th>\n",
       "      <th>+ 6 Mbps - 10 Mbps</th>\n",
       "      <th>+ 10 Mbps - 20 Mbps</th>\n",
       "      <th>+ 20 Mbps - 30 Mbps</th>\n",
       "      <th>+ 30 Mbps</th>\n",
       "      <th>OTROS</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Buenos Aires</td>\n",
       "      <td>29,985</td>\n",
       "      <td>27,709</td>\n",
       "      <td>290,315</td>\n",
       "      <td>297,915</td>\n",
       "      <td>267,044</td>\n",
       "      <td>124,190</td>\n",
       "      <td>3,618,689</td>\n",
       "      <td>65,821</td>\n",
       "      <td>4,721,668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Capital Federal</td>\n",
       "      <td>517</td>\n",
       "      <td>5,742</td>\n",
       "      <td>34,371</td>\n",
       "      <td>67,829</td>\n",
       "      <td>51,946</td>\n",
       "      <td>28,692</td>\n",
       "      <td>1,253,105</td>\n",
       "      <td>105,477</td>\n",
       "      <td>1,547,679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Catamarca</td>\n",
       "      <td>71</td>\n",
       "      <td>384</td>\n",
       "      <td>3,107</td>\n",
       "      <td>5,389</td>\n",
       "      <td>5,099</td>\n",
       "      <td>3,737</td>\n",
       "      <td>50,298</td>\n",
       "      <td>2,208</td>\n",
       "      <td>70,293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chaco</td>\n",
       "      <td>461</td>\n",
       "      <td>987</td>\n",
       "      <td>16,782</td>\n",
       "      <td>18,938</td>\n",
       "      <td>8,049</td>\n",
       "      <td>15,828</td>\n",
       "      <td>79,390</td>\n",
       "      <td>3,711</td>\n",
       "      <td>144,146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chubut</td>\n",
       "      <td>109</td>\n",
       "      <td>1,444</td>\n",
       "      <td>45,707</td>\n",
       "      <td>30,940</td>\n",
       "      <td>34,682</td>\n",
       "      <td>15,309</td>\n",
       "      <td>17,563</td>\n",
       "      <td>20,024</td>\n",
       "      <td>165,778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre        Provincia HASTA 512 kbps + 512 Kbps - 1 Mbps  \\\n",
       "1  2022         3     Buenos Aires         29,985              27,709   \n",
       "2  2022         3  Capital Federal            517               5,742   \n",
       "3  2022         3        Catamarca             71                 384   \n",
       "4  2022         3            Chaco            461                 987   \n",
       "5  2022         3           Chubut            109               1,444   \n",
       "\n",
       "  + 1 Mbps - 6 Mbps + 6 Mbps - 10 Mbps + 10 Mbps - 20 Mbps  \\\n",
       "1           290,315            297,915             267,044   \n",
       "2            34,371             67,829              51,946   \n",
       "3             3,107              5,389               5,099   \n",
       "4            16,782             18,938               8,049   \n",
       "5            45,707             30,940              34,682   \n",
       "\n",
       "  + 20 Mbps - 30 Mbps  + 30 Mbps    OTROS      Total  \n",
       "1             124,190  3,618,689   65,821  4,721,668  \n",
       "2              28,692  1,253,105  105,477  1,547,679  \n",
       "3               3,737     50,298    2,208     70,293  \n",
       "4              15,828     79,390    3,711    144,146  \n",
       "5              15,309     17,563   20,024    165,778  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "acceso_internet_fijo_por_rangos_velocidad_bajada_provincia = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/ACCES-A-INTER-FIJO-23248/data.ajson/?auth_key={}\".format(auth_key)\n",
    "acceso_internet_fijo_por_rangos_velocidad_bajada_provincia_df = get_dataframe(acceso_internet_fijo_por_rangos_velocidad_bajada_provincia)\n",
    "acceso_internet_fijo_por_rangos_velocidad_bajada_provincia_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(840, 12)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "acceso_internet_fijo_por_rangos_velocidad_bajada_provincia_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Hasta 512 kbps</th>\n",
       "      <th>Entre 512 Kbps y 1 Mbps</th>\n",
       "      <th>Entre 1 Mbps y 6 Mbps</th>\n",
       "      <th>Entre 6 Mbps y 10 Mbps</th>\n",
       "      <th>Entre 10 Mbps y 20 Mbps</th>\n",
       "      <th>Entre 20 Mbps y 30 Mbps</th>\n",
       "      <th>Más de 30 Mbps</th>\n",
       "      <th>OTROS</th>\n",
       "      <th>Total</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>33,013</td>\n",
       "      <td>96,727</td>\n",
       "      <td>1,161,370</td>\n",
       "      <td>1,151,906</td>\n",
       "      <td>823,505</td>\n",
       "      <td>479,822</td>\n",
       "      <td>6,995,750</td>\n",
       "      <td>349,035</td>\n",
       "      <td>11,091,128</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>33,667</td>\n",
       "      <td>99,498</td>\n",
       "      <td>1,193,090</td>\n",
       "      <td>1,197,030</td>\n",
       "      <td>856,562</td>\n",
       "      <td>485,321</td>\n",
       "      <td>6,741,922</td>\n",
       "      <td>351,594</td>\n",
       "      <td>10,958,684</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>34,890</td>\n",
       "      <td>104,840</td>\n",
       "      <td>1,263,273</td>\n",
       "      <td>1,209,148</td>\n",
       "      <td>967,508</td>\n",
       "      <td>509,830</td>\n",
       "      <td>6,336,187</td>\n",
       "      <td>198,333</td>\n",
       "      <td>10,624,009</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>4</td>\n",
       "      <td>41,262</td>\n",
       "      <td>28,521</td>\n",
       "      <td>1,413,208</td>\n",
       "      <td>1,245,333</td>\n",
       "      <td>976,539</td>\n",
       "      <td>558,358</td>\n",
       "      <td>6,032,322</td>\n",
       "      <td>194,251</td>\n",
       "      <td>10,489,794</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>40,174</td>\n",
       "      <td>41,437</td>\n",
       "      <td>2,550,229</td>\n",
       "      <td>1,095,772</td>\n",
       "      <td>710,122</td>\n",
       "      <td>536,364</td>\n",
       "      <td>4,948,174</td>\n",
       "      <td>163,269</td>\n",
       "      <td>10,085,541</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre Hasta 512 kbps Entre 512 Kbps y 1 Mbps  \\\n",
       "1  2022         3         33,013                  96,727   \n",
       "2  2022         2         33,667                  99,498   \n",
       "3  2022         1         34,890                 104,840   \n",
       "4  2021         4         41,262                  28,521   \n",
       "5  2021         3         40,174                  41,437   \n",
       "\n",
       "  Entre 1 Mbps y 6 Mbps Entre 6 Mbps y 10 Mbps Entre 10 Mbps y 20 Mbps  \\\n",
       "1             1,161,370              1,151,906                 823,505   \n",
       "2             1,193,090              1,197,030                 856,562   \n",
       "3             1,263,273              1,209,148                 967,508   \n",
       "4             1,413,208              1,245,333                 976,539   \n",
       "5             2,550,229              1,095,772                 710,122   \n",
       "\n",
       "  Entre 20 Mbps y 30 Mbps Más de 30 Mbps    OTROS       Total    \n",
       "1                 479,822      6,995,750  349,035  11,091,128    \n",
       "2                 485,321      6,741,922  351,594  10,958,684    \n",
       "3                 509,830      6,336,187  198,333  10,624,009    \n",
       "4                 558,358      6,032,322  194,251  10,489,794    \n",
       "5                 536,364      4,948,174  163,269  10,085,541    "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "total_nacional_accesos_internet_fijo_por_velocidad_bajada = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/TOTAL-NACIO-DE-ACCES-32663/data.ajson/?auth_key={}\".format(auth_key)\n",
    "total_nacional_accesos_internet_fijo_por_velocidad_bajada_df = get_dataframe(total_nacional_accesos_internet_fijo_por_velocidad_bajada)\n",
    "total_nacional_accesos_internet_fijo_por_velocidad_bajada_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35, 12)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "total_nacional_accesos_internet_fijo_por_velocidad_bajada_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Conectividad al servicio de Internet  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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></th>\n",
       "      <th>Partido</th>\n",
       "      <th>Localidad</th>\n",
       "      <th>ADSL</th>\n",
       "      <th></th>\n",
       "      <th>DIALUP</th>\n",
       "      <th>FIBRAOPTICA</th>\n",
       "      <th>4G</th>\n",
       "      <th></th>\n",
       "      <th>TELEFONIAFIJA</th>\n",
       "      <th></th>\n",
       "      <th>SATELITAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>Bahía Blanca</td>\n",
       "      <td>Villa Bordeau</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>2</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td></td>\n",
       "      <td>Villa Espora</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>3</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>Balcarce</td>\n",
       "      <td></td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td></td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td></td>\n",
       "      <td>Napaleofú</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Partido      Localidad ADSL     DIALUP FIBRAOPTICA  4G  \\\n",
       "1                Bahía Blanca  Villa Bordeau              --          --       \n",
       "2  BUENOS AIRES                 Villa Espora   --  --                 --  --   \n",
       "3  BUENOS AIRES                                SI  SI                     SI   \n",
       "4  BUENOS AIRES      Balcarce                  --  --     --              --   \n",
       "5  BUENOS AIRES                    Napaleofú   --  --                 SI  SI   \n",
       "\n",
       "      TELEFONIAFIJA     SATELITAL  \n",
       "1                --            --  \n",
       "2  --                --            \n",
       "3  SI                SI            \n",
       "4  --            SI  SI        --  \n",
       "5  SI                          --  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listado_localidades_conectividad_internet = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/LISTA-DE-LOCAL-CON-CONEC/data.ajson/?auth_key={}\".format(auth_key)\n",
    "listado_localidades_conectividad_internet_df = get_dataframe(listado_localidades_conectividad_internet)\n",
    "listado_localidades_conectividad_internet_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4312, 12)"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listado_localidades_conectividad_internet_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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></th>\n",
       "      <th>Partido</th>\n",
       "      <th>Localidad</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>CABLEMODEM</th>\n",
       "      <th>DIALUP</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>WIRELESS</th>\n",
       "      <th>TELEFONIAFIJA</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>link</th>\n",
       "      <th>Latitud</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>Bahía Blanca</td>\n",
       "      <td>Villa Bordeau</td>\n",
       "      <td>0</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>SI</td>\n",
       "      <td>6056020</td>\n",
       "      <td>-38,6472605094596</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</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>-38,7765069529222</td>\n",
       "      <td>-62,1851833537179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td></td>\n",
       "      <td>Balcarce</td>\n",
       "      <td>38376</td>\n",
       "      <td>SI</td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td>--</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td>6063010</td>\n",
       "      <td></td>\n",
       "      <td>-58,2551665841248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>337</td>\n",
       "      <td>--</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td></td>\n",
       "      <td>--</td>\n",
       "      <td>6063020</td>\n",
       "      <td>-37,9412057603</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BUENOS AIRES</td>\n",
       "      <td>Balcarce</td>\n",
       "      <td></td>\n",
       "      <td>374</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td></td>\n",
       "      <td>SI</td>\n",
       "      <td>--</td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td>SI</td>\n",
       "      <td></td>\n",
       "      <td>6063030</td>\n",
       "      <td>-37,6254980210026</td>\n",
       "      <td>-58,7461862359423</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Partido      Localidad            CABLEMODEM DIALUP      \\\n",
       "1                Bahía Blanca  Villa Bordeau      0             --     --  --   \n",
       "2  BUENOS AIRES                                   0  --                    --   \n",
       "3  BUENOS AIRES                     Balcarce  38376  SI                SI  SI   \n",
       "4  BUENOS AIRES                                 337  --                    --   \n",
       "5  BUENOS AIRES      Balcarce                   374  --         --         SI   \n",
       "\n",
       "      WIRELESS TELEFONIAFIJA             link            Latitud  \\\n",
       "1           --            --      SI  6056020  -38,6472605094596   \n",
       "2  --                         --  --           -38,7765069529222   \n",
       "3  --                         SI  SI  6063010                      \n",
       "4  --                     SI      --  6063020     -37,9412057603   \n",
       "5  --       SI            SI  SI      6063030  -37,6254980210026   \n",
       "\n",
       "                      \n",
       "1                     \n",
       "2  -62,1851833537179  \n",
       "3  -58,2551665841248  \n",
       "4                     \n",
       "5  -58,7461862359423  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "conectividad_al_servicio_de_internet = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/CONEC-AL-SERVI-DE-INTER/data.ajson/?auth_key={}\".format(auth_key)\n",
    "conectividad_al_servicio_de_internet_df = get_dataframe(conectividad_al_servicio_de_internet)\n",
    "conectividad_al_servicio_de_internet_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4312, 16)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "conectividad_al_servicio_de_internet_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Penetración del servicio de Internet fijo  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Provincia</th>\n",
       "      <th>Accesos por cada 100 hab</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Buenos Aires</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Capital Federal</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Catamarca</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chaco</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chubut</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre        Provincia Accesos por cada 100 hab\n",
       "1  2022         3     Buenos Aires                       26\n",
       "2  2022         3  Capital Federal                       50\n",
       "3  2022         3        Catamarca                       17\n",
       "4  2022         3            Chaco                       12\n",
       "5  2022         3           Chubut                       26"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "penetracion_internet_fijo_por_provincia_cada_100_habitantes = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/PENET-DEL-INTER-FIJO-POR/data.ajson/?auth_key={}\".format(auth_key)\n",
    "penetracion_internet_fijo_por_provincia_cada_100_habitantes_df = get_dataframe(penetracion_internet_fijo_por_provincia_cada_100_habitantes)\n",
    "penetracion_internet_fijo_por_provincia_cada_100_habitantes_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(840, 4)"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "penetracion_internet_fijo_por_provincia_cada_100_habitantes_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Provincia</th>\n",
       "      <th>Accesos por cada 100 hogares</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Buenos Aires</td>\n",
       "      <td>78.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Capital Federal</td>\n",
       "      <td>122.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Catamarca</td>\n",
       "      <td>65.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chaco</td>\n",
       "      <td>43.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chubut</td>\n",
       "      <td>84.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre        Provincia Accesos por cada 100 hogares\n",
       "1  2022         3     Buenos Aires                        78.11\n",
       "2  2022         3  Capital Federal                       122.28\n",
       "3  2022         3        Catamarca                        65.33\n",
       "4  2022         3            Chaco                        43.86\n",
       "5  2022         3           Chubut                        84.38"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "penetracion_internet_fijo_por_provincia_cada_100_hogares = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/PENET-DEL-INTER-FIJO-51614/data.ajson/?auth_key={}\".format(auth_key)\n",
    "penetracion_internet_fijo_por_provincia_cada_100_hogares_df = get_dataframe(penetracion_internet_fijo_por_provincia_cada_100_hogares)\n",
    "penetracion_internet_fijo_por_provincia_cada_100_hogares_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(840, 4)"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "penetracion_internet_fijo_por_provincia_cada_100_hogares_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Accesos por cada 100 hogares</th>\n",
       "      <th>Accesos por cada 100 hab</th>\n",
       "      <th>Periodo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>76.64</td>\n",
       "      <td>23.95</td>\n",
       "      <td>Jul-Sept 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>75.97</td>\n",
       "      <td>23.72</td>\n",
       "      <td>Abr-Jun 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>73.88</td>\n",
       "      <td>23.05</td>\n",
       "      <td>Ene-Mar 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>4</td>\n",
       "      <td>73.18</td>\n",
       "      <td>22.81</td>\n",
       "      <td>Oct-Dic 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>70.58</td>\n",
       "      <td>21.98</td>\n",
       "      <td>Jul-Sept 2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre Accesos por cada 100 hogares Accesos por cada 100 hab  \\\n",
       "1  2022         3                        76.64                    23.95   \n",
       "2  2022         2                        75.97                    23.72   \n",
       "3  2022         1                        73.88                    23.05   \n",
       "4  2021         4                        73.18                    22.81   \n",
       "5  2021         3                        70.58                    21.98   \n",
       "\n",
       "         Periodo  \n",
       "1  Jul-Sept 2022  \n",
       "2   Abr-Jun 2022  \n",
       "3   Ene-Mar 2022  \n",
       "4   Oct-Dic 2021  \n",
       "5  Jul-Sept 2021  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "penetracion_nacional_internet_fijo = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/PENET-NACIO-DEL-INTER-FIJO/data.ajson/?auth_key={}\".format(auth_key)\n",
    "penetracion_nacional_internet_fijo_df = get_dataframe(penetracion_nacional_internet_fijo)\n",
    "penetracion_nacional_internet_fijo_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35, 5)"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "penetracion_nacional_internet_fijo_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Velocidad Media de bajada de Internet por provincia y nacional (National Mean Download Speed and by state)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Mbps (Media de bajada)</th>\n",
       "      <th>Trimestre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>62.46</td>\n",
       "      <td>Jul-Sept 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>58.44</td>\n",
       "      <td>Abr-Jun 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>55.11</td>\n",
       "      <td>Ene-Mar 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>4</td>\n",
       "      <td>52.34</td>\n",
       "      <td>Oct-Dic 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>48.46</td>\n",
       "      <td>Jul-Sept 2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre Mbps (Media de bajada)      Trimestre\n",
       "1  2022         3                  62.46  Jul-Sept 2022\n",
       "2  2022         2                  58.44   Abr-Jun 2022\n",
       "3  2022         1                  55.11   Ene-Mar 2022\n",
       "4  2021         4                  52.34   Oct-Dic 2021\n",
       "5  2021         3                  48.46  Jul-Sept 2021"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "velocidad_media_bajada_internet_nacional = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/VELOC-PROME-DE-BAJAD-51733/data.ajson/?auth_key={}\".format(auth_key)\n",
    "velocidad_media_bajada_internet_nacional_df = get_dataframe(velocidad_media_bajada_internet_nacional)\n",
    "velocidad_media_bajada_internet_nacional_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35, 4)"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "velocidad_media_bajada_internet_nacional_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Provincia</th>\n",
       "      <th>Mbps (Media de bajada)</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Buenos Aires</td>\n",
       "      <td>70.19</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Capital Federal</td>\n",
       "      <td>101.05</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Catamarca</td>\n",
       "      <td>60.99</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chaco</td>\n",
       "      <td>53.21</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>Chubut</td>\n",
       "      <td>15.57</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre        Provincia Mbps (Media de bajada)    \n",
       "1  2022         3     Buenos Aires                  70.19    \n",
       "2  2022         3  Capital Federal                 101.05    \n",
       "3  2022         3        Catamarca                  60.99    \n",
       "4  2022         3            Chaco                  53.21    \n",
       "5  2022         3           Chubut                  15.57    "
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "velocidad_media_bajada_internet_por_provincia = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/VELOC-PROME-DE-BAJAD-DE/data.ajson/?auth_key={}\".format(auth_key)\n",
    "velocidad_media_bajada_internet_por_provincia_df = get_dataframe(velocidad_media_bajada_internet_por_provincia)\n",
    "velocidad_media_bajada_internet_por_provincia_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(840, 6)"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "velocidad_media_bajada_internet_por_provincia_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ingresos por la operación del servicio de Internet fijo "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>Ingresos (miles de pesos)</th>\n",
       "      <th>Periodo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>67,055,930</td>\n",
       "      <td>Jul-Sept 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>60,335,724</td>\n",
       "      <td>Abr-Jun 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>55,589,997</td>\n",
       "      <td>Ene-Mar 2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>4</td>\n",
       "      <td>45,467,887</td>\n",
       "      <td>Oct-Dic 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>42,999,944</td>\n",
       "      <td>Jul-Sept 2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre Ingresos (miles de pesos)        Periodo\n",
       "1  2022         3                67,055,930  Jul-Sept 2022\n",
       "2  2022         2                60,335,724   Abr-Jun 2022\n",
       "3  2022         1                55,589,997   Ene-Mar 2022\n",
       "4  2021         4                45,467,887   Oct-Dic 2021\n",
       "5  2021         3                42,999,944  Jul-Sept 2021"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ingresos_por_operación_servicio_internet_fijo = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/INGRE-POR-LA-OPERA-DEL/data.ajson/?auth_key={}\".format(auth_key)\n",
    "ingresos_por_operación_servicio_internet_fijo_df = get_dataframe(ingresos_por_operación_servicio_internet_fijo)\n",
    "ingresos_por_operación_servicio_internet_fijo_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35, 4)"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ingresos_por_operación_servicio_internet_fijo_df.shape"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Indicadores macroeconómicos  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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>Año</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>IPC US</th>\n",
       "      <th>IPC AR</th>\n",
       "      <th>USDARS oficial</th>\n",
       "      <th>USDARS blue</th>\n",
       "      <th>PBI millones</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2013</td>\n",
       "      <td>1</td>\n",
       "      <td>232773</td>\n",
       "      <td>298</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>2,888,981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>233504</td>\n",
       "      <td>309</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>3,387,811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2013</td>\n",
       "      <td>3</td>\n",
       "      <td>234149</td>\n",
       "      <td>331</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>3,436,547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013</td>\n",
       "      <td>4</td>\n",
       "      <td>233049</td>\n",
       "      <td>351</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>3,679,896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>236293</td>\n",
       "      <td>402</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>3,917,649</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Año Trimestre  IPC US IPC AR USDARS oficial USDARS blue PBI millones\n",
       "1  2013         1  232773    298              5           9    2,888,981\n",
       "2  2013         2  233504    309              5           9    3,387,811\n",
       "3  2013         3  234149    331              6          10    3,436,547\n",
       "4  2013         4  233049    351              6          11    3,679,896\n",
       "5  2014         1  236293    402              8          11    3,917,649"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indicadores_macroeconomicos = \"http://api.datosabiertos.enacom.gob.ar/api/v2/datastreams/INDIC-MACRO/data.ajson/?auth_key={}\".format(auth_key)\n",
    "indicadores_macroeconomicos_df = get_dataframe(indicadores_macroeconomicos)\n",
    "indicadores_macroeconomicos_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(22, 7)"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indicadores_macroeconomicos_df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Se ha guardado en la raiz del proyecto un archivo llamado `raw_data.zip` que sirve como respaldo en caso que el servidor de la API falle."
   ]
  }
 ],
 "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.10.11"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}