{ "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 la EMT 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", " | line | \n", "stop | \n", "isHead | \n", "destination | \n", "deviation | \n", "bus | \n", "estimateArrive | \n", "DistanceBus | \n", "positionTypeBus | \n", "datetime | \n", "date | \n", "positionBusLon | \n", "positionBusLat | \n", "dayType | \n", "StartTime | \n", "StopTime | \n", "MinimunFrequency | \n", "MaximumFrequency | \n", "strike | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "27 | \n", "56 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "513 | \n", "473 | \n", "1841 | \n", "0 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.690542 | \n", "40.423739 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
1 | \n", "27 | \n", "56 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "521 | \n", "313 | \n", "1221 | \n", "0 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.689019 | \n", "40.429011 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
2 | \n", "150 | \n", "56 | \n", "False | \n", "VIRGEN CORTIJO | \n", "0 | \n", "2549 | \n", "547 | \n", "2081 | \n", "0 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.691608 | \n", "40.421366 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
3 | \n", "150 | \n", "56 | \n", "False | \n", "VIRGEN CORTIJO | \n", "0 | \n", "2561 | \n", "1080 | \n", "2779 | \n", "0 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.698411 | \n", "40.418013 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
4 | \n", "14 | \n", "56 | \n", "False | \n", "PIO XII | \n", "0 | \n", "5571 | \n", "197 | \n", "679 | \n", "0 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.687918 | \n", "40.432850 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1134457 | \n", "174 | \n", "51023 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2141 | \n", "1225 | \n", "8114 | \n", "0 | \n", "2024-03-13 22:59:07.770061 | \n", "2024-03-13 | \n", "-3.667048 | \n", "40.489136 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134458 | \n", "171 | \n", "51023 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "8810 | \n", "2163 | \n", "13290 | \n", "0 | \n", "2024-03-13 22:59:07.770061 | \n", "2024-03-13 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1134459 | \n", "171 | \n", "51023 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "8829 | \n", "396 | \n", "2088 | \n", "0 | \n", "2024-03-13 22:59:07.770061 | \n", "2024-03-13 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1134460 | \n", "174 | \n", "3256 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2290 | \n", "1960 | \n", "13847 | \n", "0 | \n", "2024-03-13 22:59:36.378432 | \n", "2024-03-13 | \n", "-3.623092 | \n", "40.482330 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134461 | \n", "174 | \n", "3256 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "8879 | \n", "746 | \n", "4891 | \n", "0 | \n", "2024-03-13 22:59:36.378432 | \n", "2024-03-13 | \n", "-3.676137 | \n", "40.469620 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134462 rows × 19 columns
\n", "Nota
\n", "\n",
"La API de la EMT nos devuelve información sobre los tiempos de llegada de cada parada, con todas sus líneas conectadas.
\n",
"En esta solución se ha decidido estudiar solo las líneas de Plaza Castilla, por lo que es necesario realizar un filtrado del dataset.\n",
"
\n", " | line | \n", "stop | \n", "isHead | \n", "destination | \n", "deviation | \n", "bus | \n", "estimateArrive | \n", "DistanceBus | \n", "positionTypeBus | \n", "datetime | \n", "date | \n", "positionBusLon | \n", "positionBusLat | \n", "dayType | \n", "StartTime | \n", "StopTime | \n", "MinimunFrequency | \n", "MaximumFrequency | \n", "strike | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "27 | \n", "56 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "513 | \n", "473 | \n", "1841 | \n", "0 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.690542 | \n", "40.423739 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
1 | \n", "27 | \n", "56 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "521 | \n", "313 | \n", "1221 | \n", "0 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.689019 | \n", "40.429011 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
12 | \n", "27 | \n", "60 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "513 | \n", "282 | \n", "1159 | \n", "0 | \n", "2024-03-13 08:00:01.810182 | \n", "2024-03-13 | \n", "-3.690542 | \n", "40.423739 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
13 | \n", "27 | \n", "60 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "521 | \n", "116 | \n", "646 | \n", "0 | \n", "2024-03-13 08:00:01.810182 | \n", "2024-03-13 | \n", "-3.689019 | \n", "40.429011 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
22 | \n", "27 | \n", "66 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "513 | \n", "123 | \n", "391 | \n", "0 | \n", "2024-03-13 08:00:01.810759 | \n", "2024-03-13 | \n", "-3.690542 | \n", "40.423739 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1134453 | \n", "174 | \n", "51022 | \n", "True | \n", "PLAZA CASTILLA | \n", "0 | \n", "2067 | \n", "651 | \n", "3707 | \n", "0 | \n", "2024-03-13 22:59:07.748610 | \n", "2024-03-13 | \n", "-3.621954 | \n", "40.482080 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134456 | \n", "174 | \n", "51023 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2067 | \n", "409 | \n", "3352 | \n", "0 | \n", "2024-03-13 22:59:07.770061 | \n", "2024-03-13 | \n", "-3.621954 | \n", "40.482080 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134457 | \n", "174 | \n", "51023 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2141 | \n", "1225 | \n", "8114 | \n", "0 | \n", "2024-03-13 22:59:07.770061 | \n", "2024-03-13 | \n", "-3.667048 | \n", "40.489136 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134460 | \n", "174 | \n", "3256 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2290 | \n", "1960 | \n", "13847 | \n", "0 | \n", "2024-03-13 22:59:36.378432 | \n", "2024-03-13 | \n", "-3.623092 | \n", "40.482330 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134461 | \n", "174 | \n", "3256 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "8879 | \n", "746 | \n", "4891 | \n", "0 | \n", "2024-03-13 22:59:36.378432 | \n", "2024-03-13 | \n", "-3.676137 | \n", "40.469620 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
598334 rows × 19 columns
\n", "\n", " | PK | \n", "line | \n", "stop | \n", "isHead | \n", "destination | \n", "deviation | \n", "bus | \n", "estimateArrive | \n", "DistanceBus | \n", "datetime | \n", "date | \n", "positionBusLon | \n", "positionBusLat | \n", "dayType | \n", "StartTime | \n", "StopTime | \n", "MinimunFrequency | \n", "MaximumFrequency | \n", "strike | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2024-03-13 08:00:01.765317_B513_L27_S56 | \n", "27 | \n", "56 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "513 | \n", "473 | \n", "1841 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.690542 | \n", "40.423739 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
1 | \n", "2024-03-13 08:00:01.765317_B521_L27_S56 | \n", "27 | \n", "56 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "521 | \n", "313 | \n", "1221 | \n", "2024-03-13 08:00:01.765317 | \n", "2024-03-13 | \n", "-3.689019 | \n", "40.429011 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
12 | \n", "2024-03-13 08:00:01.810182_B513_L27_S60 | \n", "27 | \n", "60 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "513 | \n", "282 | \n", "1159 | \n", "2024-03-13 08:00:01.810182 | \n", "2024-03-13 | \n", "-3.690542 | \n", "40.423739 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
13 | \n", "2024-03-13 08:00:01.810182_B521_L27_S60 | \n", "27 | \n", "60 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "521 | \n", "116 | \n", "646 | \n", "2024-03-13 08:00:01.810182 | \n", "2024-03-13 | \n", "-3.689019 | \n", "40.429011 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
22 | \n", "2024-03-13 08:00:01.810759_B513_L27_S66 | \n", "27 | \n", "66 | \n", "False | \n", "PLAZA CASTILLA | \n", "0 | \n", "513 | \n", "123 | \n", "391 | \n", "2024-03-13 08:00:01.810759 | \n", "2024-03-13 | \n", "-3.690542 | \n", "40.423739 | \n", "LA | \n", "05:55 | \n", "23:30 | \n", "3.0 | \n", "12.0 | \n", "N | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1134453 | \n", "2024-03-13 22:59:07.748610_B2067_L174_S51022 | \n", "174 | \n", "51022 | \n", "True | \n", "PLAZA CASTILLA | \n", "0 | \n", "2067 | \n", "651 | \n", "3707 | \n", "2024-03-13 22:59:07.748610 | \n", "2024-03-13 | \n", "-3.621954 | \n", "40.482080 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134456 | \n", "2024-03-13 22:59:07.770061_B2067_L174_S51023 | \n", "174 | \n", "51023 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2067 | \n", "409 | \n", "3352 | \n", "2024-03-13 22:59:07.770061 | \n", "2024-03-13 | \n", "-3.621954 | \n", "40.482080 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134457 | \n", "2024-03-13 22:59:07.770061_B2141_L174_S51023 | \n", "174 | \n", "51023 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2141 | \n", "1225 | \n", "8114 | \n", "2024-03-13 22:59:07.770061 | \n", "2024-03-13 | \n", "-3.667048 | \n", "40.489136 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134460 | \n", "2024-03-13 22:59:36.378432_B2290_L174_S3256 | \n", "174 | \n", "3256 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2290 | \n", "1960 | \n", "13847 | \n", "2024-03-13 22:59:36.378432 | \n", "2024-03-13 | \n", "-3.623092 | \n", "40.482330 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1134461 | \n", "2024-03-13 22:59:36.378432_B8879_L174_S3256 | \n", "174 | \n", "3256 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "8879 | \n", "746 | \n", "4891 | \n", "2024-03-13 22:59:36.378432 | \n", "2024-03-13 | \n", "-3.676137 | \n", "40.469620 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
598334 rows × 19 columns
\n", "\n", " | PK | \n", "datetime | \n", "bus | \n", "line | \n", "stop | \n", "estimateArrive | \n", "
---|---|---|---|---|---|---|
930138 | \n", "2024-03-13 20:16:53.420475_B581_L70_S250 | \n", "2024-03-13 20:16:53.420475 | \n", "581 | \n", "70 | \n", "250 | \n", "999999 | \n", "
1128452 | \n", "2024-03-13 22:54:53.562759_B2260_L129_S136 | \n", "2024-03-13 22:54:53.562759 | \n", "2260 | \n", "129 | \n", "136 | \n", "999999 | \n", "
1128497 | \n", "2024-03-13 22:54:53.609227_B2260_L129_S203 | \n", "2024-03-13 22:54:53.609227 | \n", "2260 | \n", "129 | \n", "203 | \n", "999999 | \n", "
1128499 | \n", "2024-03-13 22:54:53.613518_B2260_L129_S130 | \n", "2024-03-13 22:54:53.613518 | \n", "2260 | \n", "129 | \n", "130 | \n", "999999 | \n", "
1128682 | \n", "2024-03-13 22:54:53.740388_B2260_L129_S134 | \n", "2024-03-13 22:54:53.740388 | \n", "2260 | \n", "129 | \n", "134 | \n", "999999 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1133976 | \n", "2024-03-13 22:59:02.690123_B2260_L129_S138 | \n", "2024-03-13 22:59:02.690123 | \n", "2260 | \n", "129 | \n", "138 | \n", "999999 | \n", "
1134169 | \n", "2024-03-13 22:59:04.626340_B2260_L129_S2150 | \n", "2024-03-13 22:59:04.626340 | \n", "2260 | \n", "129 | \n", "2150 | \n", "999999 | \n", "
1134193 | \n", "2024-03-13 22:59:04.689090_B2260_L129_S3245 | \n", "2024-03-13 22:59:04.689090 | \n", "2260 | \n", "129 | \n", "3245 | \n", "999999 | \n", "
1134205 | \n", "2024-03-13 22:59:04.703750_B2260_L129_S3247 | \n", "2024-03-13 22:59:04.703750 | \n", "2260 | \n", "129 | \n", "3247 | \n", "999999 | \n", "
1134376 | \n", "2024-03-13 22:59:06.845125_B2263_L135_S5604 | \n", "2024-03-13 22:59:06.845125 | \n", "2263 | \n", "135 | \n", "5604 | \n", "999999 | \n", "
98 rows × 6 columns
\n", "-
\n", "\n", "Con este check de unicidad nos damos cuenta de que la clave primaria del dataset no es única. En algunos casos, para el mismo datetime, bus, línea y parada, tenemos dos estimaciones de tiempos de llegada diferentes, donde una de ellas siempre es 9999999, que es el valor por defecto que indica que el ETA sería mayor de 45 minutos.\n", "
\n", "\n", " | PK | \n", "line | \n", "stop | \n", "isHead | \n", "destination | \n", "deviation | \n", "bus | \n", "estimateArrive | \n", "DistanceBus | \n", "datetime | \n", "date | \n", "positionBusLon | \n", "positionBusLat | \n", "dayType | \n", "StartTime | \n", "StopTime | \n", "MinimunFrequency | \n", "MaximumFrequency | \n", "strike | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
930138 | \n", "2024-03-13 20:16:53.420475_B581_L70_S250 | \n", "70 | \n", "250 | \n", "False | \n", "ALSACIA | \n", "0 | \n", "581 | \n", "999999 | \n", "20810 | \n", "2024-03-13 20:16:53.420475 | \n", "2024-03-13 | \n", "-3.635692 | \n", "40.434676 | \n", "LA | \n", "05:30 | \n", "23:45 | \n", "4.0 | \n", "17.0 | \n", "N | \n", "
1128452 | \n", "2024-03-13 22:54:53.562759_B2260_L129_S136 | \n", "129 | \n", "136 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "16648 | \n", "2024-03-13 22:54:53.562759 | \n", "2024-03-13 | \n", "-3.703954 | \n", "40.462515 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1128497 | \n", "2024-03-13 22:54:53.609227_B2260_L129_S203 | \n", "129 | \n", "203 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "13275 | \n", "2024-03-13 22:54:53.609227 | \n", "2024-03-13 | \n", "-3.703954 | \n", "40.462515 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1128499 | \n", "2024-03-13 22:54:53.613518_B2260_L129_S130 | \n", "129 | \n", "130 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "15717 | \n", "2024-03-13 22:54:53.613518 | \n", "2024-03-13 | \n", "-3.703954 | \n", "40.462515 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1128682 | \n", "2024-03-13 22:54:53.740388_B2260_L129_S134 | \n", "129 | \n", "134 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "16444 | \n", "2024-03-13 22:54:53.740388 | \n", "2024-03-13 | \n", "-3.703954 | \n", "40.462515 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1133976 | \n", "2024-03-13 22:59:02.690123_B2260_L129_S138 | \n", "129 | \n", "138 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "15720 | \n", "2024-03-13 22:59:02.690123 | \n", "2024-03-13 | \n", "-3.688213 | \n", "40.467646 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1134169 | \n", "2024-03-13 22:59:04.626340_B2260_L129_S2150 | \n", "129 | \n", "2150 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "13193 | \n", "2024-03-13 22:59:04.626340 | \n", "2024-03-13 | \n", "-3.688213 | \n", "40.467646 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1134193 | \n", "2024-03-13 22:59:04.689090_B2260_L129_S3245 | \n", "129 | \n", "3245 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "16279 | \n", "2024-03-13 22:59:04.689090 | \n", "2024-03-13 | \n", "-3.688213 | \n", "40.467646 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1134205 | \n", "2024-03-13 22:59:04.703750_B2260_L129_S3247 | \n", "129 | \n", "3247 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "16552 | \n", "2024-03-13 22:59:04.703750 | \n", "2024-03-13 | \n", "-3.688213 | \n", "40.467646 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1134376 | \n", "2024-03-13 22:59:06.845125_B2263_L135_S5604 | \n", "135 | \n", "5604 | \n", "True | \n", "HOSPITAL RAMON Y CAJAL | \n", "0 | \n", "2263 | \n", "999999 | \n", "8955 | \n", "2024-03-13 22:59:06.845125 | \n", "2024-03-13 | \n", "-3.692344 | \n", "40.487187 | \n", "LA | \n", "06:30 | \n", "23:45 | \n", "9.0 | \n", "29.0 | \n", "N | \n", "
98 rows × 19 columns
\n", "\n", " | estimateArrive | \n", "
---|---|
PK | \n", "\n", " |
2024-03-13 22:55:53.067079_B2260_L129_S132 | \n", "2 | \n", "
2024-03-13 22:54:57.042314_B2260_L129_S3594 | \n", "2 | \n", "
2024-03-13 22:56:53.304306_B2260_L129_S510 | \n", "2 | \n", "
2024-03-13 22:56:53.308814_B2260_L129_S126 | \n", "2 | \n", "
2024-03-13 22:57:02.752661_B2260_L129_S203 | \n", "2 | \n", "
... | \n", "... | \n", "
2024-03-13 13:04:08.893280_B2072_L174_S51023 | \n", "1 | \n", "
2024-03-13 13:04:08.893280_B8879_L174_S51023 | \n", "1 | \n", "
2024-03-13 13:04:26.438469_B2079_L134_S5610 | \n", "1 | \n", "
2024-03-13 13:04:26.438469_B2468_L134_S5610 | \n", "1 | \n", "
2024-03-13 22:59:36.378432_B8879_L174_S3256 | \n", "1 | \n", "
598236 rows × 1 columns
\n", "\n", " | PK | \n", "line | \n", "stop | \n", "isHead | \n", "destination | \n", "deviation | \n", "bus | \n", "estimateArrive | \n", "DistanceBus | \n", "datetime | \n", "date | \n", "positionBusLon | \n", "positionBusLat | \n", "dayType | \n", "StartTime | \n", "StopTime | \n", "MinimunFrequency | \n", "MaximumFrequency | \n", "strike | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
930137 | \n", "2024-03-13 20:16:53.420475_B581_L70_S250 | \n", "70 | \n", "250 | \n", "False | \n", "ALSACIA | \n", "0 | \n", "581 | \n", "362 | \n", "1313 | \n", "2024-03-13 20:16:53.420475 | \n", "2024-03-13 | \n", "-3.635692 | \n", "40.434676 | \n", "LA | \n", "05:30 | \n", "23:45 | \n", "4.0 | \n", "17.0 | \n", "N | \n", "
930138 | \n", "2024-03-13 20:16:53.420475_B581_L70_S250 | \n", "70 | \n", "250 | \n", "False | \n", "ALSACIA | \n", "0 | \n", "581 | \n", "999999 | \n", "20810 | \n", "2024-03-13 20:16:53.420475 | \n", "2024-03-13 | \n", "-3.635692 | \n", "40.434676 | \n", "LA | \n", "05:30 | \n", "23:45 | \n", "4.0 | \n", "17.0 | \n", "N | \n", "
1128451 | \n", "2024-03-13 22:54:53.562759_B2260_L129_S136 | \n", "129 | \n", "136 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "957 | \n", "4210 | \n", "2024-03-13 22:54:53.562759 | \n", "2024-03-13 | \n", "-3.703954 | \n", "40.462515 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1128452 | \n", "2024-03-13 22:54:53.562759_B2260_L129_S136 | \n", "129 | \n", "136 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "16648 | \n", "2024-03-13 22:54:53.562759 | \n", "2024-03-13 | \n", "-3.703954 | \n", "40.462515 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1128496 | \n", "2024-03-13 22:54:53.609227_B2260_L129_S203 | \n", "129 | \n", "203 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "440 | \n", "769 | \n", "2024-03-13 22:54:53.609227 | \n", "2024-03-13 | \n", "-3.703954 | \n", "40.462515 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1134193 | \n", "2024-03-13 22:59:04.689090_B2260_L129_S3245 | \n", "129 | \n", "3245 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "16279 | \n", "2024-03-13 22:59:04.689090 | \n", "2024-03-13 | \n", "-3.688213 | \n", "40.467646 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1134204 | \n", "2024-03-13 22:59:04.703750_B2260_L129_S3247 | \n", "129 | \n", "3247 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "915 | \n", "5019 | \n", "2024-03-13 22:59:04.703750 | \n", "2024-03-13 | \n", "-3.688213 | \n", "40.467646 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1134205 | \n", "2024-03-13 22:59:04.703750_B2260_L129_S3247 | \n", "129 | \n", "3247 | \n", "False | \n", "MANOTERAS | \n", "0 | \n", "2260 | \n", "999999 | \n", "16552 | \n", "2024-03-13 22:59:04.703750 | \n", "2024-03-13 | \n", "-3.688213 | \n", "40.467646 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "12.0 | \n", "24.0 | \n", "N | \n", "
1134375 | \n", "2024-03-13 22:59:06.845125_B2263_L135_S5604 | \n", "135 | \n", "5604 | \n", "True | \n", "HOSPITAL RAMON Y CAJAL | \n", "0 | \n", "2263 | \n", "1011 | \n", "2872 | \n", "2024-03-13 22:59:06.845125 | \n", "2024-03-13 | \n", "-3.692344 | \n", "40.487187 | \n", "LA | \n", "06:30 | \n", "23:45 | \n", "9.0 | \n", "29.0 | \n", "N | \n", "
1134376 | \n", "2024-03-13 22:59:06.845125_B2263_L135_S5604 | \n", "135 | \n", "5604 | \n", "True | \n", "HOSPITAL RAMON Y CAJAL | \n", "0 | \n", "2263 | \n", "999999 | \n", "8955 | \n", "2024-03-13 22:59:06.845125 | \n", "2024-03-13 | \n", "-3.692344 | \n", "40.487187 | \n", "LA | \n", "06:30 | \n", "23:45 | \n", "9.0 | \n", "29.0 | \n", "N | \n", "
196 rows × 19 columns
\n", "\n", " | PK | \n", "line | \n", "stop | \n", "isHead | \n", "destination | \n", "deviation | \n", "bus | \n", "estimateArrive | \n", "DistanceBus | \n", "datetime | \n", "date | \n", "positionBusLon | \n", "positionBusLat | \n", "dayType | \n", "StartTime | \n", "StopTime | \n", "MinimunFrequency | \n", "MaximumFrequency | \n", "strike | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1393 | \n", "2024-03-13 08:01:21.907965_B2072_L174_S1487 | \n", "174 | \n", "1487 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2072 | \n", "728 | \n", "-1 | \n", "2024-03-13 08:01:21.907965 | \n", "2024-03-13 | \n", "-3.647684 | \n", "40.483790 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1394 | \n", "2024-03-13 08:01:21.907965_B2147_L175_S1487 | \n", "175 | \n", "1487 | \n", "False | \n", "LAS TABLAS NORTE | \n", "0 | \n", "2147 | \n", "164 | \n", "908 | \n", "2024-03-13 08:01:21.907965 | \n", "2024-03-13 | \n", "-3.688238 | \n", "40.467754 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "9.0 | \n", "22.0 | \n", "N | \n", "
1395 | \n", "2024-03-13 08:01:21.907965_B2163_L174_S1487 | \n", "174 | \n", "1487 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "2163 | \n", "161 | \n", "579 | \n", "2024-03-13 08:01:21.907965 | \n", "2024-03-13 | \n", "-3.688924 | \n", "40.468011 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
1396 | \n", "2024-03-13 08:01:21.907965_B2259_L178_S1487 | \n", "178 | \n", "1487 | \n", "False | \n", "MONTECARMELO | \n", "0 | \n", "2259 | \n", "198 | \n", "941 | \n", "2024-03-13 08:01:21.907965 | \n", "2024-03-13 | \n", "-3.688297 | \n", "40.467753 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "6.0 | \n", "22.0 | \n", "N | \n", "
1397 | \n", "2024-03-13 08:01:21.907965_B2263_L135_S1487 | \n", "135 | \n", "1487 | \n", "False | \n", "HOSPITAL RAMON Y CAJAL | \n", "0 | \n", "2263 | \n", "556 | \n", "655 | \n", "2024-03-13 08:01:21.907965 | \n", "2024-03-13 | \n", "-3.688405 | \n", "40.467987 | \n", "LA | \n", "06:30 | \n", "23:45 | \n", "9.0 | \n", "29.0 | \n", "N | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1134011 | \n", "2024-03-13 22:59:02.692429_B5568_L67_S1487 | \n", "67 | \n", "1487 | \n", "False | \n", "BARRIO PEÑAGRANDE | \n", "0 | \n", "5568 | \n", "1640 | \n", "7879 | \n", "2024-03-13 22:59:02.692429 | \n", "2024-03-13 | \n", "-3.732373 | \n", "40.481259 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "9.0 | \n", "30.0 | \n", "N | \n", "
1134013 | \n", "2024-03-13 22:59:02.692429_B5720_L67_S1487 | \n", "67 | \n", "1487 | \n", "False | \n", "BARRIO PEÑAGRANDE | \n", "0 | \n", "5720 | \n", "681 | \n", "3420 | \n", "2024-03-13 22:59:02.692429 | \n", "2024-03-13 | \n", "-3.699604 | \n", "40.484061 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "9.0 | \n", "30.0 | \n", "N | \n", "
1134014 | \n", "2024-03-13 22:59:02.692429_B8856_L176_S1487 | \n", "176 | \n", "1487 | \n", "False | \n", "LAS TABLAS SUR | \n", "0 | \n", "8856 | \n", "1612 | \n", "8997 | \n", "2024-03-13 22:59:02.692429 | \n", "2024-03-13 | \n", "-3.664880 | \n", "40.505486 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "6.0 | \n", "20.0 | \n", "N | \n", "
1134015 | \n", "2024-03-13 22:59:02.692429_B8864_L176_S1487 | \n", "176 | \n", "1487 | \n", "False | \n", "LAS TABLAS SUR | \n", "0 | \n", "8864 | \n", "474 | \n", "632 | \n", "2024-03-13 22:59:02.692429 | \n", "2024-03-13 | \n", "-3.688390 | \n", "40.470399 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "6.0 | \n", "20.0 | \n", "N | \n", "
1134016 | \n", "2024-03-13 22:59:02.692429_B8879_L174_S1487 | \n", "174 | \n", "1487 | \n", "False | \n", "VALDEBEBAS | \n", "0 | \n", "8879 | \n", "442 | \n", "1628 | \n", "2024-03-13 22:59:02.692429 | \n", "2024-03-13 | \n", "-3.675809 | \n", "40.471649 | \n", "LA | \n", "06:00 | \n", "23:45 | \n", "7.0 | \n", "22.0 | \n", "N | \n", "
13539 rows × 19 columns
\n", "