{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import os\n", "import statistics\n", "import polars as pl\n", "import pandas as pd\n", "import seaborn as sns\n", "import polars.selectors as cs\n", "import matplotlib.pyplot as plt\n", "from datetime import datetime, timedelta\n", "\n", "import warnings\n", "\n", "warnings.filterwarnings(\"ignore\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# KPI\n", "\n", "Vamos a utilizar el **MAE**. Para ello necesitamos obtener las variables:\n", "- `y_pred`: la predicción de la hora que llega el autobús que ofrece la API cuando se realiza la llamada\n", "- `y_true`: para cada autobús,linea, parada y destino concreto, la predicción que ofrece la API más fiable (entendiendose por fiable aquella que es inferior a 60 segundos).\n", "\n", "Para obtener `y_true`, cogemos el valor de `y_pred` para los valores en los que `estimateArrive` sea inferior a 60 segundos de cada autobús, linea, parada y destino concretos\n" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "sample_data_02 = pl.scan_csv('/home/mlia/proyectos/data-generation/data/train/emt/2024/03/03/emt_20240303.csv')\n", "sample_data_aux_02 = pl.scan_csv('/home/mlia/proyectos/data-generation/data/train/emt/2024/03/03/emt_20240303_aux.csv')" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
PK | date | datetime | bus | line | stop | positionBusLon | positionBusLat | DistanceBus | destination | MinimunFrequency | isHead | dayType | estimateArrive | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
i64 | str | str | str | i64 | str | i64 | f64 | f64 | i64 | str | f64 | i64 | str | i64 |
0 | "2024-03-03 22:… | "2024-03-03" | "2024-03-03 22:… | 2331 | "127" | 1617 | -3.71898 | 40.465098 | 3645 | "CUATRO CAMINOS… | null | 0 | "FE" | 818 |
1 | "2024-03-03 10:… | "2024-03-03" | "2024-03-03 10:… | 2133 | "107" | 497 | -3.688693 | 40.467328 | 2778 | "HORTALEZA" | 15.0 | 0 | "FE" | 555 |
2 | "2024-03-03 20:… | "2024-03-03" | "2024-03-03 20:… | 541 | "70" | 232 | -3.675485 | 40.467472 | 6703 | "ALSACIA" | 12.0 | 0 | "FE" | 1369 |
3 | "2024-03-03 13:… | "2024-03-03" | "2024-03-03 13:… | 2268 | "175" | 4508 | -3.696627 | 40.486987 | 13206 | "PLAZA CASTILLA… | 20.0 | 1 | "FE" | 2318 |
4 | "2024-03-03 15:… | "2024-03-03" | "2024-03-03 15:… | 3273 | "11" | 220 | -3.669398 | 40.458809 | 8153 | "BARRIO BLANCO" | null | 0 | "FE" | 2399 |
PK | reliable_arrival_date | predict_arrival_date | interval_time | estimateArrive | |
---|---|---|---|---|---|
i64 | str | str | str | str | i64 |
0 | "2024-03-03 13:… | "2024-03-03 13:… | "2024-03-03 14:… | "[12 14]" | 2318 |
1 | "2024-03-03 15:… | "2024-03-03 15:… | "2024-03-03 16:… | "[14 16]" | 2399 |
2 | "2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 13:… | "[11 13]" | 2053 |
3 | "2024-03-03 13:… | "2024-03-03 13:… | "2024-03-03 13:… | "[12 14]" | 56 |
4 | "2024-03-03 19:… | "2024-03-03 19:… | "2024-03-03 19:… | "[18 20]" | 201 |
PK | reliable_arrival_date | predict_arrival_date | interval_time | estimateArrive | _right | date | datetime | bus | line | stop | positionBusLon | positionBusLat | DistanceBus | destination | MinimunFrequency | isHead | dayType | estimateArrive_right | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
i64 | str | str | str | str | i64 | i64 | str | str | i64 | str | i64 | f64 | f64 | i64 | str | f64 | i64 | str | i64 |
13333 | "2024-03-03 11:… | "2024-03-03 11:… | "2024-03-03 11:… | "[10 12]" | 864 | 17814 | "2024-03-03" | "2024-03-03 11:… | 51 | "BR1" | 4366 | -3.698413 | 40.490519 | 8045 | "VALDEBEBAS" | null | 0 | "FE" | 864 |
20709 | "2024-03-03 11:… | "2024-03-03 11:… | "2024-03-03 11:… | "[10 12]" | 540 | 27536 | "2024-03-03" | "2024-03-03 11:… | 51 | "BR1" | 4366 | -3.661998 | 40.498973 | 3287 | "VALDEBEBAS" | null | 0 | "FE" | 540 |
32386 | "2024-03-03 11:… | "2024-03-03 11:… | "2024-03-03 11:… | "[10 12]" | 1250 | 43012 | "2024-03-03" | "2024-03-03 11:… | 51 | "BR1" | 4366 | -3.692432 | 40.486629 | 10340 | "VALDEBEBAS" | null | 0 | "FE" | 1250 |
35941 | "2024-03-03 08:… | "2024-03-03 08:… | "2024-03-03 08:… | "[7 9]" | 2044 | 47768 | "2024-03-03" | "2024-03-03 08:… | 51 | "BR1" | 4366 | -3.641676 | 40.484641 | 18705 | "VALDEBEBAS" | null | 0 | "FE" | 2044 |
40658 | "2024-03-03 10:… | "2024-03-03 10:… | "2024-03-03 11:… | "[ 9 11]" | 1410 | 54070 | "2024-03-03" | "2024-03-03 10:… | 51 | "BR1" | 4366 | -3.67561 | 40.484079 | 12528 | "VALDEBEBAS" | null | 0 | "FE" | 1410 |
… | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … |
780200 | "2024-03-03 08:… | "2024-03-03 08:… | "2024-03-03 08:… | "[7 9]" | 628 | 1037349 | "2024-03-03" | "2024-03-03 08:… | 51 | "BR1" | 4366 | -3.676432 | 40.483876 | 6105 | "VALDEBEBAS" | null | 0 | "FE" | 628 |
786139 | "2024-03-03 10:… | "2024-03-03 10:… | "2024-03-03 10:… | "[ 9 11]" | 168 | 1045276 | "2024-03-03" | "2024-03-03 10:… | 51 | "BR1" | 4366 | -3.653508 | 40.487681 | 868 | "VALDEBEBAS" | null | 0 | "FE" | 168 |
797676 | "2024-03-03 08:… | "2024-03-03 08:… | "2024-03-03 08:… | "[7 9]" | 0 | 1060661 | "2024-03-03" | "2024-03-03 08:… | 51 | "BR1" | 4366 | -3.642333 | 40.484241 | 0 | "VALDEBEBAS" | null | 0 | "FE" | 0 |
807589 | "2024-03-03 10:… | "2024-03-03 10:… | "2024-03-03 11:… | "[ 9 11]" | 1239 | 1073832 | "2024-03-03" | "2024-03-03 10:… | 51 | "BR1" | 4366 | -3.696335 | 40.487389 | 10513 | "VALDEBEBAS" | null | 0 | "FE" | 1239 |
831602 | "2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | "[11 13]" | 343 | 1106062 | "2024-03-03" | "2024-03-03 12:… | 51 | "BR1" | 4366 | -3.658238 | 40.493502 | 2131 | "VALDEBEBAS" | null | 0 | "FE" | 343 |
datetime | reliable_arrival_date | predict_arrival_date | estimateArrive | KPI_value |
---|---|---|---|---|
str | str | str | i64 | f64 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 1958 | 341.567779 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 1716 | 341.148263 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 1837 | 341.135457 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 1898 | 340.938425 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 2061 | 340.932139 |
… | … | … | … | … |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 175 | 0.396977 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 1180 | 0.389483 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 1196 | 0.331104 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 1075 | 0.265574 |
"2024-03-03 12:… | "2024-03-03 12:… | "2024-03-03 12:… | 56 | 0.0 |
PK | date | datetime | bus | line | stop | positionBusLon | positionBusLat | DistanceBus | destination | MinimunFrequency | isHead | dayType | estimateArrive |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
str | date | datetime[μs] | str | str | i64 | f64 | f64 | i64 | str | i64 | u8 | str | i64 |
"2024-03-26 21:… | 2024-03-26 | 2024-03-26 21:40:09.739783 | "2536" | "170" | 5399 | -3.684673 | 40.511029 | 5665 | "SANCHINARRO" | null | 0 | "LA" | 967 |
"2024-03-26 08:… | 2024-03-26 | 2024-03-26 08:10:09.881904 | "9109" | "177" | 5803 | -3.688479 | 40.467095 | 1383 | "MARQUES DE VIA… | 9 | 0 | "LA" | 300 |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:23:08.488793 | "2477" | "173" | 5518 | -3.664287 | 40.493674 | 1672 | "PLAZA CASTILLA… | 7 | 1 | "LA" | 590 |
"2024-03-26 16:… | 2024-03-26 | 2024-03-26 16:50:07.442667 | "2497" | "170" | 2970 | -3.701602 | 40.504168 | 9687 | "SANCHINARRO" | null | 0 | "LA" | 2178 |
"2024-03-26 20:… | 2024-03-26 | 2024-03-26 20:30:06.307634 | "3279" | "11" | 222 | -3.693661 | 40.459219 | 3559 | "BARRIO BLANCO" | null | 0 | "LA" | 1062 |
… | … | … | … | … | … | … | … | … | … | … | … | … | … |
"2024-03-26 21:… | 2024-03-26 | 2024-03-26 21:42:07.452901 | "4708" | "82" | 1629 | -3.727311 | 40.445077 | 6819 | "PITIS" | null | 0 | "LA" | 1068 |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:13:08.297954 | "2477" | "173" | 3603 | -3.689128 | 40.468215 | 4298 | "SANCHINARRO" | 7 | 0 | "LA" | 499 |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:46:11.429187 | "51" | "BR1" | 5899 | -3.63154 | 40.48568 | 505 | "VALDEBEBAS" | null | 0 | "LA" | 94 |
"2024-03-26 16:… | 2024-03-26 | 2024-03-26 16:42:05.914865 | "2468" | "134" | 1022 | -3.714127 | 40.48642 | 4337 | "MONTECARMELO" | 9 | 0 | "LA" | 893 |
"2024-03-26 15:… | 2024-03-26 | 2024-03-26 15:44:08.527764 | "2514" | "175" | 4508 | -3.6655 | 40.504171 | 0 | "PLAZA CASTILLA… | 9 | 1 | "LA" | 231 |
PK | date | datetime | bus | line | stop | positionBusLon | positionBusLat | DistanceBus | destination | MinimunFrequency | isHead | dayType | estimateArrive |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
str | date | datetime[μs] | str | str | i64 | f64 | f64 | i64 | str | i64 | u8 | str | i64 |
"2024-03-26 09:… | 2024-03-26 | 2024-03-26 09:07:08.486404 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 9195 | "VALDEBEBAS" | null | 0 | "LA" | 1536 |
"2024-03-26 09:… | 2024-03-26 | 2024-03-26 09:08:08.881899 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 8836 | "VALDEBEBAS" | null | 0 | "LA" | 1476 |
"2024-03-26 09:… | 2024-03-26 | 2024-03-26 09:09:08.755131 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 9226 | "VALDEBEBAS" | null | 0 | "LA" | 1381 |
"2024-03-26 09:… | 2024-03-26 | 2024-03-26 09:10:08.875354 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 8825 | "VALDEBEBAS" | null | 0 | "LA" | 1321 |
"2024-03-26 09:… | 2024-03-26 | 2024-03-26 09:11:10.677695 | "51" | "BR1" | 4366 | -3.696617 | 40.48821 | 9028 | "VALDEBEBAS" | null | 0 | "LA" | 1239 |
… | … | … | … | … | … | … | … | … | … | … | … | … | … |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:39:07.409588 | "51" | "BR1" | 4366 | -3.658057 | 40.493668 | 1920 | "VALDEBEBAS" | null | 0 | "LA" | 339 |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:40:08.462574 | "51" | "BR1" | 4366 | -3.659287 | 40.490522 | 1455 | "VALDEBEBAS" | null | 0 | "LA" | 263 |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:41:08.942691 | "51" | "BR1" | 4366 | -3.654665 | 40.488051 | 1123 | "VALDEBEBAS" | null | 0 | "LA" | 203 |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:42:10.443984 | "51" | "BR1" | 4366 | -3.650573 | 40.486745 | 760 | "VALDEBEBAS" | null | 0 | "LA" | 198 |
"2024-03-26 22:… | 2024-03-26 | 2024-03-26 22:43:10.564491 | "51" | "BR1" | 4366 | -3.645521 | 40.485224 | 236 | "VALDEBEBAS" | null | 0 | "LA" | 39 |
PK | date | datetime | bus | line | stop | positionBusLon | positionBusLat | DistanceBus | destination | MinimunFrequency | isHead | dayType | estimateArrive | predict_arrival_date | bloque_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
str | datetime[ms] | datetime[μs] | str | str | i64 | f64 | f64 | i64 | str | f64 | u8 | str | i64 | datetime[μs] | i64 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:05:08.146916 | "51" | "BR1" | 4366 | -3.625174 | 40.482623 | 19754 | "VALDEBEBAS" | null | 0 | "LA" | 2515 | 2024-03-26 22:47:03.146916 | 9 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:06:08.223862 | "51" | "BR1" | 4366 | -3.635248 | 40.486303 | 19275 | "VALDEBEBAS" | null | 0 | "LA" | 2454 | 2024-03-26 22:47:02.223862 | 9 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:07:07.950631 | "51" | "BR1" | 4366 | -3.643053 | 40.484473 | 18804 | "VALDEBEBAS" | null | 0 | "LA" | 2394 | 2024-03-26 22:47:01.950631 | 9 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:08:08.530312 | "51" | "BR1" | 4366 | -3.643053 | 40.484473 | 18286 | "VALDEBEBAS" | null | 0 | "LA" | 2328 | 2024-03-26 22:46:56.530312 | 9 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:09:08.167593 | "51" | "BR1" | 4366 | -3.643053 | 40.484473 | 17862 | "VALDEBEBAS" | null | 0 | "LA" | 2274 | 2024-03-26 22:47:02.167593 | 9 |
… | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:23:08.256559 | "51" | "BR1" | 4366 | -3.659662 | 40.4922 | 1746 | "VALDEBEBAS" | null | 0 | "LA" | 321 | 2024-03-26 09:28:29.256559 | 1 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:24:08.643877 | "51" | "BR1" | 4366 | -3.658428 | 40.489981 | 1276 | "VALDEBEBAS" | null | 0 | "LA" | 232 | 2024-03-26 09:28:00.643877 | 1 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:25:09.036527 | "51" | "BR1" | 4366 | -3.655349 | 40.487956 | 847 | "VALDEBEBAS" | null | 0 | "LA" | 159 | 2024-03-26 09:27:48.036527 | 1 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:26:08.257810 | "51" | "BR1" | 4366 | -3.650483 | 40.486716 | 533 | "VALDEBEBAS" | null | 0 | "LA" | 100 | 2024-03-26 09:27:48.257810 | 1 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:27:08.674862 | "51" | "BR1" | 4366 | -3.643678 | 40.48467 | 0 | "VALDEBEBAS" | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 1 |
bus | line | stop | destination | date | bloque_id | PK | datetime | positionBusLon | positionBusLat | DistanceBus | MinimunFrequency | isHead | dayType | estimateArrive | predict_arrival_date | reliable_arrival_date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
str | str | i64 | str | datetime[ms] | i64 | str | datetime[μs] | f64 | f64 | i64 | f64 | u8 | str | i64 | datetime[μs] | datetime[μs] |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 4 | "2024-03-26 13:… | 2024-03-26 13:42:09.058943 | -3.649841 | 40.486513 | 202 | null | 0 | "LA" | 28 | 2024-03-26 13:42:37.058943 | 2024-03-26 13:42:37.058943 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 3 | "2024-03-26 12:… | 2024-03-26 12:15:09.310898 | -3.646471 | 40.485319 | 0 | null | 0 | "LA" | 0 | 2024-03-26 12:15:09.310898 | 2024-03-26 12:15:09.310898 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 7 | "2024-03-26 20:… | 2024-03-26 20:00:08.897971 | -3.647037 | 40.485411 | 214 | null | 0 | "LA" | 33 | 2024-03-26 20:00:41.897971 | 2024-03-26 20:00:41.897971 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 8 | "2024-03-26 21:… | 2024-03-26 21:22:09.062779 | -3.647071 | 40.484471 | 0 | null | 0 | "LA" | 0 | 2024-03-26 21:22:55.062779 | 2024-03-26 21:22:55.062779 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 6 | "2024-03-26 18:… | 2024-03-26 18:31:10.487315 | -3.643471 | 40.484603 | 0 | null | 0 | "LA" | 0 | 2024-03-26 18:31:10.487315 | 2024-03-26 18:31:10.487315 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 1 | "2024-03-26 09:… | 2024-03-26 09:27:08.674862 | -3.643678 | 40.48467 | 0 | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:27:08.674862 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 2 | "2024-03-26 10:… | 2024-03-26 10:49:07.411681 | -3.644106 | 40.484726 | 0 | null | 0 | "LA" | 0 | 2024-03-26 10:49:23.411681 | 2024-03-26 10:49:23.411681 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 9 | "2024-03-26 22:… | 2024-03-26 22:43:10.564491 | -3.645521 | 40.485224 | 236 | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 2024-03-26 22:43:49.564491 |
bus | line | stop | destination | date | bloque_id | PK | datetime | positionBusLon | positionBusLat | DistanceBus | MinimunFrequency | isHead | dayType | estimateArrive | predict_arrival_date | reliable_arrival_date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
str | str | i64 | str | datetime[ms] | i64 | str | datetime[μs] | f64 | f64 | i64 | f64 | u8 | str | i64 | datetime[μs] | datetime[μs] |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 4 | "2024-03-26 13:… | 2024-03-26 13:42:09.058943 | -3.649841 | 40.486513 | 202 | null | 0 | "LA" | 28 | 2024-03-26 13:42:37.058943 | 2024-03-26 13:42:37.058943 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 3 | "2024-03-26 12:… | 2024-03-26 12:15:09.310898 | -3.646471 | 40.485319 | 0 | null | 0 | "LA" | 0 | 2024-03-26 12:15:09.310898 | 2024-03-26 12:15:09.310898 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 7 | "2024-03-26 20:… | 2024-03-26 20:00:08.897971 | -3.647037 | 40.485411 | 214 | null | 0 | "LA" | 33 | 2024-03-26 20:00:41.897971 | 2024-03-26 20:00:41.897971 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 8 | "2024-03-26 21:… | 2024-03-26 21:22:09.062779 | -3.647071 | 40.484471 | 0 | null | 0 | "LA" | 0 | 2024-03-26 21:22:55.062779 | 2024-03-26 21:22:55.062779 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 6 | "2024-03-26 18:… | 2024-03-26 18:31:10.487315 | -3.643471 | 40.484603 | 0 | null | 0 | "LA" | 0 | 2024-03-26 18:31:10.487315 | 2024-03-26 18:31:10.487315 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 1 | "2024-03-26 09:… | 2024-03-26 09:27:08.674862 | -3.643678 | 40.48467 | 0 | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:27:08.674862 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 2 | "2024-03-26 10:… | 2024-03-26 10:49:07.411681 | -3.644106 | 40.484726 | 0 | null | 0 | "LA" | 0 | 2024-03-26 10:49:23.411681 | 2024-03-26 10:49:23.411681 |
"51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | 9 | "2024-03-26 22:… | 2024-03-26 22:43:10.564491 | -3.645521 | 40.485224 | 236 | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 2024-03-26 22:43:49.564491 |
PK | date | datetime | bus | line | stop | positionBusLon | positionBusLat | DistanceBus | destination | MinimunFrequency | isHead | dayType | estimateArrive | predict_arrival_date | bloque_id | bus_right | line_right | stop_right | destination_right | date_right | PK_right | datetime_right | positionBusLon_right | positionBusLat_right | DistanceBus_right | MinimunFrequency_right | isHead_right | dayType_right | estimateArrive_right | predict_arrival_date_right | reliable_arrival_date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
str | datetime[ms] | datetime[μs] | str | str | i64 | f64 | f64 | i64 | str | f64 | u8 | str | i64 | datetime[μs] | i64 | str | str | i64 | str | datetime[ms] | str | datetime[μs] | f64 | f64 | i64 | f64 | u8 | str | i64 | datetime[μs] | datetime[μs] |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:07:08.486404 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 9195 | "VALDEBEBAS" | null | 0 | "LA" | 1536 | 2024-03-26 09:32:44.486404 | 1 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 09:… | 2024-03-26 09:27:08.674862 | -3.643678 | 40.48467 | 0 | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:27:08.674862 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:08:08.881899 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 8836 | "VALDEBEBAS" | null | 0 | "LA" | 1476 | 2024-03-26 09:32:44.881899 | 1 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 09:… | 2024-03-26 09:27:08.674862 | -3.643678 | 40.48467 | 0 | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:27:08.674862 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:09:08.755131 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 9226 | "VALDEBEBAS" | null | 0 | "LA" | 1381 | 2024-03-26 09:32:09.755131 | 1 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 09:… | 2024-03-26 09:27:08.674862 | -3.643678 | 40.48467 | 0 | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:27:08.674862 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:10:08.875354 | "51" | "BR1" | 4366 | -3.695309 | 40.486747 | 8825 | "VALDEBEBAS" | null | 0 | "LA" | 1321 | 2024-03-26 09:32:09.875354 | 1 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 09:… | 2024-03-26 09:27:08.674862 | -3.643678 | 40.48467 | 0 | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:27:08.674862 |
"2024-03-26 09:… | 2024-03-26 00:00:00 | 2024-03-26 09:11:10.677695 | "51" | "BR1" | 4366 | -3.696617 | 40.48821 | 9028 | "VALDEBEBAS" | null | 0 | "LA" | 1239 | 2024-03-26 09:31:49.677695 | 1 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 09:… | 2024-03-26 09:27:08.674862 | -3.643678 | 40.48467 | 0 | null | 0 | "LA" | 0 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:27:08.674862 |
… | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:39:07.409588 | "51" | "BR1" | 4366 | -3.658057 | 40.493668 | 1920 | "VALDEBEBAS" | null | 0 | "LA" | 339 | 2024-03-26 22:44:46.409588 | 9 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 22:… | 2024-03-26 22:43:10.564491 | -3.645521 | 40.485224 | 236 | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 2024-03-26 22:43:49.564491 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:40:08.462574 | "51" | "BR1" | 4366 | -3.659287 | 40.490522 | 1455 | "VALDEBEBAS" | null | 0 | "LA" | 263 | 2024-03-26 22:44:31.462574 | 9 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 22:… | 2024-03-26 22:43:10.564491 | -3.645521 | 40.485224 | 236 | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 2024-03-26 22:43:49.564491 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:41:08.942691 | "51" | "BR1" | 4366 | -3.654665 | 40.488051 | 1123 | "VALDEBEBAS" | null | 0 | "LA" | 203 | 2024-03-26 22:44:31.942691 | 9 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 22:… | 2024-03-26 22:43:10.564491 | -3.645521 | 40.485224 | 236 | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 2024-03-26 22:43:49.564491 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:42:10.443984 | "51" | "BR1" | 4366 | -3.650573 | 40.486745 | 760 | "VALDEBEBAS" | null | 0 | "LA" | 198 | 2024-03-26 22:45:28.443984 | 9 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 22:… | 2024-03-26 22:43:10.564491 | -3.645521 | 40.485224 | 236 | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 2024-03-26 22:43:49.564491 |
"2024-03-26 22:… | 2024-03-26 00:00:00 | 2024-03-26 22:43:10.564491 | "51" | "BR1" | 4366 | -3.645521 | 40.485224 | 236 | "VALDEBEBAS" | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 9 | "51" | "BR1" | 4366 | "VALDEBEBAS" | 2024-03-26 00:00:00 | "2024-03-26 22:… | 2024-03-26 22:43:10.564491 | -3.645521 | 40.485224 | 236 | null | 0 | "LA" | 39 | 2024-03-26 22:43:49.564491 | 2024-03-26 22:43:49.564491 |
\n", " | PK | \n", "datetime | \n", "reliable_arrival_date | \n", "predict_arrival_date | \n", "bloque_id | \n", "estimateArrive | \n", "
---|---|---|---|---|---|---|
0 | \n", "2024-03-26 09:07:08.486404_B51_LBR1_S4366 | \n", "2024-03-26 09:07:08.486404 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.486404 | \n", "1 | \n", "1536 | \n", "
1 | \n", "2024-03-26 09:08:08.881899_B51_LBR1_S4366 | \n", "2024-03-26 09:08:08.881899 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.881899 | \n", "1 | \n", "1476 | \n", "
2 | \n", "2024-03-26 09:09:08.755131_B51_LBR1_S4366 | \n", "2024-03-26 09:09:08.755131 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.755131 | \n", "1 | \n", "1381 | \n", "
3 | \n", "2024-03-26 09:10:08.875354_B51_LBR1_S4366 | \n", "2024-03-26 09:10:08.875354 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.875354 | \n", "1 | \n", "1321 | \n", "
4 | \n", "2024-03-26 09:11:10.677695_B51_LBR1_S4366 | \n", "2024-03-26 09:11:10.677695 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:49.677695 | \n", "1 | \n", "1239 | \n", "
5 | \n", "2024-03-26 09:12:08.822076_B51_LBR1_S4366 | \n", "2024-03-26 09:12:08.822076 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:53.822076 | \n", "1 | \n", "1185 | \n", "
6 | \n", "2024-03-26 09:13:09.160954_B51_LBR1_S4366 | \n", "2024-03-26 09:13:09.160954 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:28.160954 | \n", "1 | \n", "1039 | \n", "
7 | \n", "2024-03-26 09:14:08.414499_B51_LBR1_S4366 | \n", "2024-03-26 09:14:08.414499 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:00.414499 | \n", "1 | \n", "952 | \n", "
8 | \n", "2024-03-26 09:15:09.979541_B51_LBR1_S4366 | \n", "2024-03-26 09:15:09.979541 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:29:15.979541 | \n", "1 | \n", "846 | \n", "
9 | \n", "2024-03-26 09:17:07.807332_B51_LBR1_S4366 | \n", "2024-03-26 09:17:07.807332 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.807332 | \n", "1 | \n", "682 | \n", "
10 | \n", "2024-03-26 09:18:09.292909_B51_LBR1_S4366 | \n", "2024-03-26 09:18:09.292909 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.292909 | \n", "1 | \n", "620 | \n", "
11 | \n", "2024-03-26 09:19:09.264869_B51_LBR1_S4366 | \n", "2024-03-26 09:19:09.264869 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.264869 | \n", "1 | \n", "560 | \n", "
12 | \n", "2024-03-26 09:20:08.308902_B51_LBR1_S4366 | \n", "2024-03-26 09:20:08.308902 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:28.308902 | \n", "1 | \n", "500 | \n", "
13 | \n", "2024-03-26 09:22:08.748819_B51_LBR1_S4366 | \n", "2024-03-26 09:22:08.748819 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.748819 | \n", "1 | \n", "381 | \n", "
14 | \n", "2024-03-26 09:23:08.256559_B51_LBR1_S4366 | \n", "2024-03-26 09:23:08.256559 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.256559 | \n", "1 | \n", "321 | \n", "
15 | \n", "2024-03-26 09:24:08.643877_B51_LBR1_S4366 | \n", "2024-03-26 09:24:08.643877 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:00.643877 | \n", "1 | \n", "232 | \n", "
16 | \n", "2024-03-26 09:25:09.036527_B51_LBR1_S4366 | \n", "2024-03-26 09:25:09.036527 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.036527 | \n", "1 | \n", "159 | \n", "
17 | \n", "2024-03-26 09:26:08.257810_B51_LBR1_S4366 | \n", "2024-03-26 09:26:08.257810 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.257810 | \n", "1 | \n", "100 | \n", "
18 | \n", "2024-03-26 09:27:08.674862_B51_LBR1_S4366 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "1 | \n", "0 | \n", "
19 | \n", "2024-03-26 10:28:06.759858_B51_LBR1_S4366 | \n", "2024-03-26 10:28:06.759858 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 11:06:15.759858 | \n", "2 | \n", "2289 | \n", "
20 | \n", "2024-03-26 10:29:08.164543_B51_LBR1_S4366 | \n", "2024-03-26 10:29:08.164543 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 11:07:21.164543 | \n", "2 | \n", "2293 | \n", "
21 | \n", "2024-03-26 10:30:08.351999_B51_LBR1_S4366 | \n", "2024-03-26 10:30:08.351999 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 11:08:30.351999 | \n", "2 | \n", "2302 | \n", "
22 | \n", "2024-03-26 10:31:08.228017_B51_LBR1_S4366 | \n", "2024-03-26 10:31:08.228017 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 11:08:25.228017 | \n", "2 | \n", "2237 | \n", "
23 | \n", "2024-03-26 10:32:08.593895_B51_LBR1_S4366 | \n", "2024-03-26 10:32:08.593895 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 11:09:56.593895 | \n", "2 | \n", "2268 | \n", "
24 | \n", "2024-03-26 10:34:08.147077_B51_LBR1_S4366 | \n", "2024-03-26 10:34:08.147077 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 11:03:07.147077 | \n", "2 | \n", "1739 | \n", "
25 | \n", "2024-03-26 10:35:06.721532_B51_LBR1_S4366 | \n", "2024-03-26 10:35:06.721532 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 11:03:06.721532 | \n", "2 | \n", "1680 | \n", "
26 | \n", "2024-03-26 10:36:08.939174_B51_LBR1_S4366 | \n", "2024-03-26 10:36:08.939174 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:55:26.939174 | \n", "2 | \n", "1158 | \n", "
27 | \n", "2024-03-26 10:38:07.059568_B51_LBR1_S4366 | \n", "2024-03-26 10:38:07.059568 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:54:28.059568 | \n", "2 | \n", "981 | \n", "
28 | \n", "2024-03-26 10:39:07.192176_B51_LBR1_S4366 | \n", "2024-03-26 10:39:07.192176 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:54:09.192176 | \n", "2 | \n", "902 | \n", "
29 | \n", "2024-03-26 10:40:08.062428_B51_LBR1_S4366 | \n", "2024-03-26 10:40:08.062428 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:52:33.062428 | \n", "2 | \n", "745 | \n", "
30 | \n", "2024-03-26 10:41:08.947750_B51_LBR1_S4366 | \n", "2024-03-26 10:41:08.947750 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:52:36.947750 | \n", "2 | \n", "688 | \n", "
31 | \n", "2024-03-26 10:43:08.450481_B51_LBR1_S4366 | \n", "2024-03-26 10:43:08.450481 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:51:55.450481 | \n", "2 | \n", "527 | \n", "
32 | \n", "2024-03-26 10:44:08.198504_B51_LBR1_S4366 | \n", "2024-03-26 10:44:08.198504 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:51:56.198504 | \n", "2 | \n", "468 | \n", "
33 | \n", "2024-03-26 10:45:08.323245_B51_LBR1_S4366 | \n", "2024-03-26 10:45:08.323245 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:51:55.323245 | \n", "2 | \n", "407 | \n", "
34 | \n", "2024-03-26 10:46:08.687412_B51_LBR1_S4366 | \n", "2024-03-26 10:46:08.687412 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:51:23.687412 | \n", "2 | \n", "315 | \n", "
35 | \n", "2024-03-26 10:47:09.993700_B51_LBR1_S4366 | \n", "2024-03-26 10:47:09.993700 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:50:42.993700 | \n", "2 | \n", "213 | \n", "
36 | \n", "2024-03-26 10:48:08.170464_B51_LBR1_S4366 | \n", "2024-03-26 10:48:08.170464 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:50:27.170464 | \n", "2 | \n", "139 | \n", "
37 | \n", "2024-03-26 10:49:07.411681_B51_LBR1_S4366 | \n", "2024-03-26 10:49:07.411681 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:49:23.411681 | \n", "2 | \n", "16 | \n", "
38 | \n", "2024-03-26 10:50:08.062525_B51_LBR1_S4366 | \n", "2024-03-26 10:50:08.062525 | \n", "2024-03-26 10:49:23.411681 | \n", "2024-03-26 10:50:08.062525 | \n", "2 | \n", "0 | \n", "
39 | \n", "2024-03-26 11:51:09.085827_B51_LBR1_S4366 | \n", "2024-03-26 11:51:09.085827 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:18:49.085827 | \n", "3 | \n", "1660 | \n", "
40 | \n", "2024-03-26 11:52:09.190452_B51_LBR1_S4366 | \n", "2024-03-26 11:52:09.190452 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:19:54.190452 | \n", "3 | \n", "1665 | \n", "
41 | \n", "2024-03-26 11:53:08.698945_B51_LBR1_S4366 | \n", "2024-03-26 11:53:08.698945 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:23:53.698945 | \n", "3 | \n", "1845 | \n", "
42 | \n", "2024-03-26 11:54:08.804854_B51_LBR1_S4366 | \n", "2024-03-26 11:54:08.804854 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:26:07.804854 | \n", "3 | \n", "1919 | \n", "
43 | \n", "2024-03-26 11:55:08.948127_B51_LBR1_S4366 | \n", "2024-03-26 11:55:08.948127 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:26:06.948127 | \n", "3 | \n", "1858 | \n", "
44 | \n", "2024-03-26 11:56:10.271055_B51_LBR1_S4366 | \n", "2024-03-26 11:56:10.271055 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:27:19.271055 | \n", "3 | \n", "1869 | \n", "
45 | \n", "2024-03-26 11:57:08.365116_B51_LBR1_S4366 | \n", "2024-03-26 11:57:08.365116 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:28:25.365116 | \n", "3 | \n", "1877 | \n", "
46 | \n", "2024-03-26 11:58:08.667291_B51_LBR1_S4366 | \n", "2024-03-26 11:58:08.667291 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:29:35.667291 | \n", "3 | \n", "1887 | \n", "
47 | \n", "2024-03-26 12:00:08.855249_B51_LBR1_S4366 | \n", "2024-03-26 12:00:08.855249 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:21:28.855249 | \n", "3 | \n", "1280 | \n", "
48 | \n", "2024-03-26 12:01:08.169960_B51_LBR1_S4366 | \n", "2024-03-26 12:01:08.169960 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:21:28.169960 | \n", "3 | \n", "1220 | \n", "
49 | \n", "2024-03-26 12:02:08.420660_B51_LBR1_S4366 | \n", "2024-03-26 12:02:08.420660 | \n", "2024-03-26 12:15:09.310898 | \n", "2024-03-26 12:20:54.420660 | \n", "3 | \n", "1126 | \n", "
PK | datetime | reliable_arrival_date | predict_arrival_date | bloque_id | estimateArrive | KPI_value |
---|---|---|---|---|---|---|
str | datetime[μs] | datetime[μs] | datetime[μs] | i64 | i64 | f64 |
"2024-03-26 09:… | 2024-03-26 09:07:08.486404 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:32:44.486404 | 1 | 1536 | 335.811542 |
"2024-03-26 09:… | 2024-03-26 09:08:08.881899 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:32:44.881899 | 1 | 1476 | 336.207037 |
"2024-03-26 09:… | 2024-03-26 09:09:08.755131 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:32:09.755131 | 1 | 1381 | 301.080269 |
"2024-03-26 09:… | 2024-03-26 09:10:08.875354 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:32:09.875354 | 1 | 1321 | 301.200492 |
"2024-03-26 09:… | 2024-03-26 09:11:10.677695 | 2024-03-26 09:27:08.674862 | 2024-03-26 09:31:49.677695 | 1 | 1239 | 281.002833 |
… | … | … | … | … | … | … |
"2024-03-26 10:… | 2024-03-26 10:41:08.947750 | 2024-03-26 10:49:23.411681 | 2024-03-26 10:52:36.947750 | 2 | 688 | 193.536069 |
"2024-03-26 10:… | 2024-03-26 10:43:08.450481 | 2024-03-26 10:49:23.411681 | 2024-03-26 10:51:55.450481 | 2 | 527 | 152.0388 |
"2024-03-26 10:… | 2024-03-26 10:44:08.198504 | 2024-03-26 10:49:23.411681 | 2024-03-26 10:51:56.198504 | 2 | 468 | 152.786823 |
"2024-03-26 10:… | 2024-03-26 10:45:08.323245 | 2024-03-26 10:49:23.411681 | 2024-03-26 10:51:55.323245 | 2 | 407 | 151.911564 |
"2024-03-26 10:… | 2024-03-26 10:46:08.687412 | 2024-03-26 10:49:23.411681 | 2024-03-26 10:51:23.687412 | 2 | 315 | 120.275731 |
\n", " | estimateArrive | \n", "KPI_value | \n", "reliable_arrival_date | \n", "predict_arrival_date | \n", "datetime | \n", "reliable_estimateArrive | \n", "
---|---|---|---|---|---|---|
0 | \n", "1536 | \n", "335.811542 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.486404 | \n", "2024-03-26 09:07:08.486404 | \n", "1200.188458 | \n", "
1 | \n", "1476 | \n", "336.207037 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.881899 | \n", "2024-03-26 09:08:08.881899 | \n", "1139.792963 | \n", "
2 | \n", "1381 | \n", "301.080269 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.755131 | \n", "2024-03-26 09:09:08.755131 | \n", "1079.919731 | \n", "
3 | \n", "1321 | \n", "301.200492 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.875354 | \n", "2024-03-26 09:10:08.875354 | \n", "1019.799508 | \n", "
4 | \n", "1239 | \n", "281.002833 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:49.677695 | \n", "2024-03-26 09:11:10.677695 | \n", "957.997167 | \n", "
5 | \n", "1185 | \n", "285.147214 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:53.822076 | \n", "2024-03-26 09:12:08.822076 | \n", "899.852786 | \n", "
6 | \n", "1039 | \n", "199.486092 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:28.160954 | \n", "2024-03-26 09:13:09.160954 | \n", "839.513908 | \n", "
7 | \n", "952 | \n", "171.739637 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:00.414499 | \n", "2024-03-26 09:14:08.414499 | \n", "780.260363 | \n", "
8 | \n", "846 | \n", "127.304679 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:29:15.979541 | \n", "2024-03-26 09:15:09.979541 | \n", "718.695321 | \n", "
9 | \n", "682 | \n", "81.132470 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.807332 | \n", "2024-03-26 09:17:07.807332 | \n", "600.867530 | \n", "
10 | \n", "620 | \n", "80.618047 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.292909 | \n", "2024-03-26 09:18:09.292909 | \n", "539.381953 | \n", "
11 | \n", "560 | \n", "80.590007 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.264869 | \n", "2024-03-26 09:19:09.264869 | \n", "479.409993 | \n", "
12 | \n", "500 | \n", "79.634040 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:28.308902 | \n", "2024-03-26 09:20:08.308902 | \n", "420.365960 | \n", "
13 | \n", "381 | \n", "81.073957 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.748819 | \n", "2024-03-26 09:22:08.748819 | \n", "299.926043 | \n", "
14 | \n", "321 | \n", "80.581697 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.256559 | \n", "2024-03-26 09:23:08.256559 | \n", "240.418303 | \n", "
15 | \n", "232 | \n", "51.969015 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:00.643877 | \n", "2024-03-26 09:24:08.643877 | \n", "180.030985 | \n", "
16 | \n", "159 | \n", "39.361665 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.036527 | \n", "2024-03-26 09:25:09.036527 | \n", "119.638335 | \n", "
17 | \n", "100 | \n", "39.582948 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.257810 | \n", "2024-03-26 09:26:08.257810 | \n", "60.417052 | \n", "
18 | \n", "0 | \n", "0.000000 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "0.000000 | \n", "
\n", " | estimateArrive | \n", "KPI_value | \n", "reliable_arrival_date | \n", "predict_arrival_date | \n", "datetime | \n", "reliable_estimateArrive | \n", "MAPE | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "1536 | \n", "335.811542 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.486404 | \n", "2024-03-26 09:07:08.486404 | \n", "1200.188458 | \n", "27.979901 | \n", "
1 | \n", "1476 | \n", "336.207037 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.881899 | \n", "2024-03-26 09:08:08.881899 | \n", "1139.792963 | \n", "29.497202 | \n", "
2 | \n", "1381 | \n", "301.080269 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.755131 | \n", "2024-03-26 09:09:08.755131 | \n", "1079.919731 | \n", "27.879875 | \n", "
3 | \n", "1321 | \n", "301.200492 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.875354 | \n", "2024-03-26 09:10:08.875354 | \n", "1019.799508 | \n", "29.535265 | \n", "
4 | \n", "1239 | \n", "281.002833 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:49.677695 | \n", "2024-03-26 09:11:10.677695 | \n", "957.997167 | \n", "29.332324 | \n", "
5 | \n", "1185 | \n", "285.147214 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:53.822076 | \n", "2024-03-26 09:12:08.822076 | \n", "899.852786 | \n", "31.688207 | \n", "
6 | \n", "1039 | \n", "199.486092 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:28.160954 | \n", "2024-03-26 09:13:09.160954 | \n", "839.513908 | \n", "23.762095 | \n", "
7 | \n", "952 | \n", "171.739637 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:00.414499 | \n", "2024-03-26 09:14:08.414499 | \n", "780.260363 | \n", "22.010555 | \n", "
8 | \n", "846 | \n", "127.304679 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:29:15.979541 | \n", "2024-03-26 09:15:09.979541 | \n", "718.695321 | \n", "17.713303 | \n", "
9 | \n", "682 | \n", "81.132470 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.807332 | \n", "2024-03-26 09:17:07.807332 | \n", "600.867530 | \n", "13.502555 | \n", "
10 | \n", "620 | \n", "80.618047 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.292909 | \n", "2024-03-26 09:18:09.292909 | \n", "539.381953 | \n", "14.946375 | \n", "
11 | \n", "560 | \n", "80.590007 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.264869 | \n", "2024-03-26 09:19:09.264869 | \n", "479.409993 | \n", "16.810248 | \n", "
12 | \n", "500 | \n", "79.634040 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:28.308902 | \n", "2024-03-26 09:20:08.308902 | \n", "420.365960 | \n", "18.943979 | \n", "
13 | \n", "381 | \n", "81.073957 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.748819 | \n", "2024-03-26 09:22:08.748819 | \n", "299.926043 | \n", "27.031316 | \n", "
14 | \n", "321 | \n", "80.581697 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.256559 | \n", "2024-03-26 09:23:08.256559 | \n", "240.418303 | \n", "33.517289 | \n", "
15 | \n", "232 | \n", "51.969015 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:00.643877 | \n", "2024-03-26 09:24:08.643877 | \n", "180.030985 | \n", "28.866706 | \n", "
16 | \n", "159 | \n", "39.361665 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.036527 | \n", "2024-03-26 09:25:09.036527 | \n", "119.638335 | \n", "32.900546 | \n", "
17 | \n", "100 | \n", "39.582948 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.257810 | \n", "2024-03-26 09:26:08.257810 | \n", "60.417052 | \n", "65.516186 | \n", "
18 | \n", "0 | \n", "0.000000 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "0.000000 | \n", "NaN | \n", "
\n", " | estimateArrive | \n", "KPI_value | \n", "reliable_arrival_date | \n", "predict_arrival_date | \n", "datetime | \n", "reliable_estimateArrive | \n", "MAPE | \n", "MAPE2 | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "1536 | \n", "335.811542 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.486404 | \n", "2024-03-26 09:07:08.486404 | \n", "1200.188458 | \n", "27.979901 | \n", "21.862731 | \n", "
1 | \n", "1476 | \n", "336.207037 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:44.881899 | \n", "2024-03-26 09:08:08.881899 | \n", "1139.792963 | \n", "29.497202 | \n", "22.778255 | \n", "
2 | \n", "1381 | \n", "301.080269 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.755131 | \n", "2024-03-26 09:09:08.755131 | \n", "1079.919731 | \n", "27.879875 | \n", "21.801613 | \n", "
3 | \n", "1321 | \n", "301.200492 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:32:09.875354 | \n", "2024-03-26 09:10:08.875354 | \n", "1019.799508 | \n", "29.535265 | \n", "22.800946 | \n", "
4 | \n", "1239 | \n", "281.002833 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:49.677695 | \n", "2024-03-26 09:11:10.677695 | \n", "957.997167 | \n", "29.332324 | \n", "22.679809 | \n", "
5 | \n", "1185 | \n", "285.147214 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:31:53.822076 | \n", "2024-03-26 09:12:08.822076 | \n", "899.852786 | \n", "31.688207 | \n", "24.063056 | \n", "
6 | \n", "1039 | \n", "199.486092 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:28.160954 | \n", "2024-03-26 09:13:09.160954 | \n", "839.513908 | \n", "23.762095 | \n", "19.199816 | \n", "
7 | \n", "952 | \n", "171.739637 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:30:00.414499 | \n", "2024-03-26 09:14:08.414499 | \n", "780.260363 | \n", "22.010555 | \n", "18.039878 | \n", "
8 | \n", "846 | \n", "127.304679 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:29:15.979541 | \n", "2024-03-26 09:15:09.979541 | \n", "718.695321 | \n", "17.713303 | \n", "15.047834 | \n", "
9 | \n", "682 | \n", "81.132470 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.807332 | \n", "2024-03-26 09:17:07.807332 | \n", "600.867530 | \n", "13.502555 | \n", "11.896257 | \n", "
10 | \n", "620 | \n", "80.618047 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.292909 | \n", "2024-03-26 09:18:09.292909 | \n", "539.381953 | \n", "14.946375 | \n", "13.002911 | \n", "
11 | \n", "560 | \n", "80.590007 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.264869 | \n", "2024-03-26 09:19:09.264869 | \n", "479.409993 | \n", "16.810248 | \n", "14.391073 | \n", "
12 | \n", "500 | \n", "79.634040 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:28.308902 | \n", "2024-03-26 09:20:08.308902 | \n", "420.365960 | \n", "18.943979 | \n", "15.926808 | \n", "
13 | \n", "381 | \n", "81.073957 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.748819 | \n", "2024-03-26 09:22:08.748819 | \n", "299.926043 | \n", "27.031316 | \n", "21.279254 | \n", "
14 | \n", "321 | \n", "80.581697 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:29.256559 | \n", "2024-03-26 09:23:08.256559 | \n", "240.418303 | \n", "33.517289 | \n", "25.103332 | \n", "
15 | \n", "232 | \n", "51.969015 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:28:00.643877 | \n", "2024-03-26 09:24:08.643877 | \n", "180.030985 | \n", "28.866706 | \n", "22.400438 | \n", "
16 | \n", "159 | \n", "39.361665 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.036527 | \n", "2024-03-26 09:25:09.036527 | \n", "119.638335 | \n", "32.900546 | \n", "24.755764 | \n", "
17 | \n", "100 | \n", "39.582948 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:48.257810 | \n", "2024-03-26 09:26:08.257810 | \n", "60.417052 | \n", "65.516186 | \n", "39.582948 | \n", "
18 | \n", "0 | \n", "0.000000 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "2024-03-26 09:27:08.674862 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
PK | date | datetime | bus | line | stop | positionBusLon | positionBusLat | DistanceBus | destination | MinimunFrequency | isHead | dayType | estimateArrive |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
str | date | datetime[μs] | str | str | i64 | f64 | f64 | i64 | str | i64 | u8 | str | i64 |
"2024-03-26 19:… | 2024-03-26 | 2024-03-26 19:04:07.830005 | "2592" | "178" | 1487 | -3.697154 | 40.487528 | 2377 | "MONTECARMELO" | 6 | 0 | "LA" | 729 |
"2024-03-26 11:… | 2024-03-26 | 2024-03-26 11:13:06.952057 | "8828" | "9" | 218 | -3.649361 | 40.472321 | 1724 | "SOL SEVILLA" | null | 0 | "LA" | 496 |
"2024-03-26 13:… | 2024-03-26 | 2024-03-26 13:39:08.711052 | "2515" | "175" | 3769 | -3.696384 | 40.487048 | 6472 | "LAS TABLAS NOR… | 9 | 0 | "LA" | 918 |
"2024-03-26 13:… | 2024-03-26 | 2024-03-26 13:41:09.490335 | "8831" | "171" | 5911 | -3.631982 | 40.468928 | 4366 | "VALDEBEBAS" | null | 0 | "LA" | 1159 |
"2024-03-26 16:… | 2024-03-26 | 2024-03-26 16:30:07.126711 | "8857" | "176" | 3261 | -3.687647 | 40.470278 | 3590 | "LAS TABLAS SUR… | 6 | 0 | "LA" | 375 |
… | … | … | … | … | … | … | … | … | … | … | … | … | … |
"2024-03-26 19:… | 2024-03-26 | 2024-03-26 19:44:09.474926 | "4737" | "49" | 5329 | -3.704893 | 40.47915 | 281 | "PITIS" | 4 | 0 | "LA" | 137 |
"2024-03-26 14:… | 2024-03-26 | 2024-03-26 14:26:08.037914 | "2078" | "174" | 3256 | -3.685166 | 40.466831 | 4128 | "VALDEBEBAS" | 7 | 0 | "LA" | 922 |
"2024-03-26 09:… | 2024-03-26 | 2024-03-26 09:05:08.090547 | "8856" | "176" | 2653 | -3.688789 | 40.467426 | 1094 | "LAS TABLAS SUR… | 6 | 0 | "LA" | 553 |
"2024-03-26 13:… | 2024-03-26 | 2024-03-26 13:47:09.444763 | "53" | "BR1" | 5397 | -3.694223 | 40.487813 | 8534 | "VALDEBEBAS" | null | 0 | "LA" | 1073 |
"2024-03-26 08:… | 2024-03-26 | 2024-03-26 08:16:07.762153 | "5563" | "67" | 1604 | -3.686624 | 40.476524 | 3230 | "BARRIO PEÑAGRA… | 9 | 0 | "LA" | 1322 |
bus | line | stop | destination | count |
---|---|---|---|---|
str | str | i64 | str | u32 |
"5726" | "147" | 29 | "BARRIO DEL PIL… | 114 |
"8835" | "171" | 5892 | "VALDEBEBAS" | 29 |
"2550" | "150" | 60 | "VIRGEN CORTIJO… | 123 |
"2298" | "29" | 214 | "MANOTERAS" | 171 |
"4796" | "45" | 66 | "REINA VICTORIA… | 207 |
… | … | … | … | … |
"577" | "70" | 5603 | "ALSACIA" | 119 |
"4794" | "45" | 60 | "REINA VICTORIA… | 65 |
"4836" | "132" | 1364 | "HOSPITAL LA PA… | 108 |
"539" | "70" | 212 | "ALSACIA" | 185 |
"54" | "BR1" | 5917 | "VALDEBEBAS" | 29 |
\n", " | bus | \n", "line | \n", "stop | \n", "destination | \n", "count | \n", "
---|---|---|---|---|---|
0 | \n", "5726 | \n", "147 | \n", "29 | \n", "BARRIO DEL PILAR | \n", "114 | \n", "
1 | \n", "8835 | \n", "171 | \n", "5892 | \n", "VALDEBEBAS | \n", "29 | \n", "
2 | \n", "2550 | \n", "150 | \n", "60 | \n", "VIRGEN CORTIJO | \n", "123 | \n", "
3 | \n", "2298 | \n", "29 | \n", "214 | \n", "MANOTERAS | \n", "171 | \n", "
4 | \n", "4796 | \n", "45 | \n", "66 | \n", "REINA VICTORIA | \n", "207 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
7908 | \n", "577 | \n", "70 | \n", "5603 | \n", "ALSACIA | \n", "119 | \n", "
7909 | \n", "4794 | \n", "45 | \n", "60 | \n", "REINA VICTORIA | \n", "65 | \n", "
7910 | \n", "4836 | \n", "132 | \n", "1364 | \n", "HOSPITAL LA PAZ | \n", "108 | \n", "
7911 | \n", "539 | \n", "70 | \n", "212 | \n", "ALSACIA | \n", "185 | \n", "
7912 | \n", "54 | \n", "BR1 | \n", "5917 | \n", "VALDEBEBAS | \n", "29 | \n", "
7913 rows × 5 columns
\n", "