{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "
Nota
\n", "\n",
"Este dataset ha sido creado ejecutando el comando create
del paquete de Python inesdata_mov_datasets
.
\n",
"Para poder ejecutar este comando es necesario haber ejecutado antes el comando extract
, que realiza la extracción de datos de la API de Informo y los almacena en Minio. El comando create
se encargaría de descargar dichos datos y unirlos todos en un único dataset.\n",
"
-
\n", "\n", "Vamos a analizar la calidad del dataset generado solamente para el día 13 de marzo, en el futuro dispondremos de más días.\n", "
\n", "\n", " | idelem | \n", "descripcion | \n", "accesoAsociado | \n", "intensidad | \n", "ocupacion | \n", "carga | \n", "nivelServicio | \n", "intensidadSat | \n", "error | \n", "subarea | \n", "st_x | \n", "st_y | \n", "velocidad | \n", "datetime | \n", "date | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "6711 | \n", "NaN | \n", "NaN | \n", "3840 | \n", "30 | \n", "105 | \n", "1.0 | \n", "NaN | \n", "N | \n", "NaN | \n", "442306,196584557 | \n", "4481615,71687789 | \n", "37.0 | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
1 | \n", "10112 | \n", "Arturo Soria - Pablo Vidal - Vicente Muzas | \n", "4604002.0 | \n", "740 | \n", "4 | \n", "29 | \n", "1.0 | \n", "2438.0 | \n", "N | \n", "3203.0 | \n", "443972,01821329 | \n", "4478986,47739102 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
2 | \n", "6038 | \n", "Torrelaguna - Arturo Baldasano-José Silva | \n", "4627002.0 | \n", "380 | \n", "2 | \n", "28 | \n", "1.0 | \n", "1390.0 | \n", "N | \n", "3246.0 | \n", "443981,955537857 | \n", "4478451,45254494 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
3 | \n", "6039 | \n", "Torrelaguna - Av. Ramón y Cajal-Acceso M30 | \n", "4628002.0 | \n", "840 | \n", "6 | \n", "24 | \n", "0.0 | \n", "3000.0 | \n", "N | \n", "3215.0 | \n", "443984,139107713 | \n", "4478277,30226478 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
4 | \n", "6040 | \n", "Torrelaguna - Sorzano-Acceso M30 | \n", "4628001.0 | \n", "520 | \n", "5 | \n", "31 | \n", "1.0 | \n", "2000.0 | \n", "N | \n", "3215.0 | \n", "444079,304201131 | \n", "4478026,60397703 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
853109 | \n", "10031 | \n", "Narcís Monturiol N-S - Sangenjo-Av. Ilustración | \n", "4304002.0 | \n", "20 | \n", "0 | \n", "2 | \n", "0.0 | \n", "775.0 | \n", "N | \n", "314.0 | \n", "440656,756311705 | \n", "4481793,23972478 | \n", "NaN | \n", "2024-03-13 22:50:11 | \n", "2024-03-13 | \n", "
853110 | \n", "10463 | \n", "Av. Ilustración O-E (Azobispo Morcillo - Nudo ... | \n", "NaN | \n", "700 | \n", "1 | \n", "14 | \n", "0.0 | \n", "4420.0 | \n", "N | \n", "314.0 | \n", "440789,229442877 | \n", "4481734,1912437 | \n", "NaN | \n", "2024-03-13 22:50:11 | \n", "2024-03-13 | \n", "
853111 | \n", "3421 | \n", "Bravo Murillo E-O - Pl.Castilla-Conde Serrallo | \n", "6201004.0 | \n", "480 | \n", "1 | \n", "16 | \n", "0.0 | \n", "2900.0 | \n", "N | \n", "304.0 | \n", "441453,970035479 | \n", "4479675,62306307 | \n", "NaN | \n", "2024-03-13 22:50:11 | \n", "2024-03-13 | \n", "
853112 | \n", "3423 | \n", "Lateral Pº Castellana N-S - Pl.Castilla-Rosari... | \n", "6003012.0 | \n", "280 | \n", "2 | \n", "8 | \n", "0.0 | \n", "3200.0 | \n", "N | \n", "301.0 | \n", "441493,761559993 | \n", "4479352,76508833 | \n", "NaN | \n", "2024-03-13 22:50:11 | \n", "2024-03-13 | \n", "
853113 | \n", "10899 | \n", "Av. Entrevías - Mejorana-Sierra de Albarracín | \n", "6805002.0 | \n", "220 | \n", "1 | \n", "17 | \n", "0.0 | \n", "1800.0 | \n", "N | \n", "3008.0 | \n", "443058,894528119 | \n", "4470747,45219509 | \n", "NaN | \n", "2024-03-13 22:50:11 | \n", "2024-03-13 | \n", "
853114 rows × 15 columns
\n", "\n", " | PK | \n", "idelem | \n", "descripcion | \n", "accesoAsociado | \n", "intensidad | \n", "ocupacion | \n", "carga | \n", "nivelServicio | \n", "intensidadSat | \n", "error | \n", "subarea | \n", "st_x | \n", "st_y | \n", "velocidad | \n", "datetime | \n", "date | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2024-03-13 07:55:08_I6711_Snan | \n", "6711 | \n", "NaN | \n", "NaN | \n", "3840 | \n", "30 | \n", "105 | \n", "1.0 | \n", "NaN | \n", "N | \n", "nan | \n", "442306,196584557 | \n", "4481615,71687789 | \n", "37.0 | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
1 | \n", "2024-03-13 07:55:08_I10112_S3203.0 | \n", "10112 | \n", "Arturo Soria - Pablo Vidal - Vicente Muzas | \n", "4604002.0 | \n", "740 | \n", "4 | \n", "29 | \n", "1.0 | \n", "2438.0 | \n", "N | \n", "3203.0 | \n", "443972,01821329 | \n", "4478986,47739102 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
2 | \n", "2024-03-13 07:55:08_I6038_S3246.0 | \n", "6038 | \n", "Torrelaguna - Arturo Baldasano-José Silva | \n", "4627002.0 | \n", "380 | \n", "2 | \n", "28 | \n", "1.0 | \n", "1390.0 | \n", "N | \n", "3246.0 | \n", "443981,955537857 | \n", "4478451,45254494 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
3 | \n", "2024-03-13 07:55:08_I6039_S3215.0 | \n", "6039 | \n", "Torrelaguna - Av. Ramón y Cajal-Acceso M30 | \n", "4628002.0 | \n", "840 | \n", "6 | \n", "24 | \n", "0.0 | \n", "3000.0 | \n", "N | \n", "3215.0 | \n", "443984,139107713 | \n", "4478277,30226478 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "
4 | \n", "2024-03-13 07:55:08_I6040_S3215.0 | \n", "6040 | \n", "Torrelaguna - Sorzano-Acceso M30 | \n", "4628001.0 | \n", "520 | \n", "5 | \n", "31 | \n", "1.0 | \n", "2000.0 | \n", "N | \n", "3215.0 | \n", "444079,304201131 | \n", "4478026,60397703 | \n", "NaN | \n", "2024-03-13 07:55:08 | \n", "2024-03-13 | \n", "