Dataset statistics
Number of variables | 19 |
---|---|
Number of observations | 598334 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 285.8 MiB |
Average record size in memory | 500.8 B |
Variable types
Text | 1 |
---|---|
Categorical | 8 |
Boolean | 2 |
Numeric | 6 |
DateTime | 2 |
Dataset
Description | EMT - Estimaciones del tiempo de llegada del Bus |
---|---|
URL | https://apidocs.emtmadrid.es/#api-Block_3_TRANSPORT_BUSEMTMAD-arrives |
Variable descriptions
PK | Identificador único (Primary Key) del dataset, compuesto por <datetime>_B<bus>_L<linea>_S<parada> |
---|---|
date | Fecha de la petición a la API |
datetime | Fecha y hora de la petición a la API |
line | LÃnea de bus |
stop | Parada de bus |
bus | Número identificador del bus |
positionBusLon | Longitud de las coordenadas del bus |
positionBusLat | Latitud de las coordenadas del bus |
DistanceBus | Distancia del bus a la parada (en metros) |
destination | Destino del itinerario |
deviation | Desviación en el cálculo del ETA |
StartTime | Hora de inicio de la lÃnea |
StopTime | Hora de fin de la lÃnea |
MinimunFrequency | Frecuencia mÃnima de la lÃnea |
MaximumFrequency | Frecuencia máxima de la lÃnea |
isHead | Variable booleana para indicar si la parada es la cabecera de la lÃnea |
dayType | Tipo de dÃa (LA: laboral, FE: festivo, SA: sábado) |
strike | Variable para indicar si ese dÃa hay huelga (S) o no (N) |
estimateArrive | Tiempo estimado de espera del bus (en segundos) |
date has constant value "" | Constant |
dayType has constant value "" | Constant |
strike has constant value "" | Constant |
stop has a high cardinality: 283 distinct values | High cardinality |
bus has a high cardinality: 182 distinct values | High cardinality |
isHead is highly imbalanced (57.9%) | Imbalance |
deviation is highly imbalanced (> 99.9%) | Imbalance |
estimateArrive is highly skewed (γ1 = 43.1852418) | Skewed |
positionBusLon is highly skewed (γ1 = 65.67607433) | Skewed |
positionBusLat is highly skewed (γ1 = -85.712563) | Skewed |
estimateArrive has 14093 (2.4%) zeros | Zeros |
DistanceBus has 25283 (4.2%) zeros | Zeros |
Reproduction
Analysis started | 2024-03-21 12:11:10.937978 |
---|---|
Analysis finished | 2024-03-21 12:11:46.789568 |
Duration | 35.85 seconds |
Software version | ydata-profiling vv4.7.0 |
Download configuration | config.json |
PK
Text
Identificador único (Primary Key) del dataset, compuesto por
Distinct | 598236 |
---|---|
Distinct (%) | > 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 61.1 MiB |
Length
Max length | 44 |
---|---|
Median length | 43 |
Mean length | 42.133484 |
Min length | 39 |
Characters and Unicode
Total characters | 25209896 |
---|---|
Distinct characters | 18 |
Distinct categories | 6 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 598138 ? |
---|---|
Unique (%) | > 99.9% |
Sample
1st row | 2024-03-13 08:00:01.765317_B513_L27_S56 |
---|---|
2nd row | 2024-03-13 08:00:01.765317_B521_L27_S56 |
3rd row | 2024-03-13 08:00:01.810182_B513_L27_S60 |
4th row | 2024-03-13 08:00:01.810182_B521_L27_S60 |
5th row | 2024-03-13 08:00:01.810759_B513_L27_S66 |
Value | Count | Frequency (%) |
2024-03-13 | 598334 | |
22:57:52.951111_b2260_l129_s132 | 2 | < 0.1% |
22:56:55.394377_b2260_l129_s3247 | 2 | < 0.1% |
22:56:55.370013_b2260_l129_s3245 | 2 | < 0.1% |
22:59:02.506093_b2260_l129_s30 | 2 | < 0.1% |
22:57:55.429266_b2260_l129_s3594 | 2 | < 0.1% |
22:56:57.823445_b2260_l129_s5606 | 2 | < 0.1% |
22:55:56.740337_b2263_l135_s5604 | 2 | < 0.1% |
22:57:53.065915_b2260_l129_s509 | 2 | < 0.1% |
22:57:53.020156_b2260_l129_s203 | 2 | < 0.1% |
Other values (598227) | 598316 |
Most occurring characters
Value | Count | Frequency (%) |
2 | 2806263 | |
0 | 2611227 | |
1 | 2472669 | |
3 | 2444352 | |
4 | 1976647 | 7.8% |
_ | 1795002 | 7.1% |
5 | 1698959 | 6.7% |
7 | 1277971 | 5.1% |
- | 1196668 | 4.7% |
: | 1196668 | 4.7% |
Other values (8) | 5733470 |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 18029888 | |
Connector Punctuation | 1795002 | 7.1% |
Other Punctuation | 1795002 | 7.1% |
Uppercase Letter | 1795002 | 7.1% |
Dash Punctuation | 1196668 | 4.7% |
Space Separator | 598334 | 2.4% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
2 | 2806263 | |
0 | 2611227 | |
1 | 2472669 | |
3 | 2444352 | |
4 | 1976647 | |
5 | 1698959 | |
7 | 1277971 | |
6 | 1011995 | 5.6% |
8 | 897893 | 5.0% |
9 | 831912 | 4.6% |
Uppercase Letter
Value | Count | Frequency (%) |
B | 598334 | |
L | 598334 | |
S | 598334 |
Other Punctuation
Value | Count | Frequency (%) |
: | 1196668 | |
. | 598334 |
Connector Punctuation
Value | Count | Frequency (%) |
_ | 1795002 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 1196668 |
Space Separator
Value | Count | Frequency (%) |
598334 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 23414894 | |
Latin | 1795002 | 7.1% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
2 | 2806263 | |
0 | 2611227 | |
1 | 2472669 | |
3 | 2444352 | |
4 | 1976647 | |
_ | 1795002 | |
5 | 1698959 | |
7 | 1277971 | 5.5% |
- | 1196668 | 5.1% |
: | 1196668 | 5.1% |
Other values (5) | 3938468 |
Latin
Value | Count | Frequency (%) |
B | 598334 | |
L | 598334 | |
S | 598334 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 25209896 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
2 | 2806263 | |
0 | 2611227 | |
1 | 2472669 | |
3 | 2444352 | |
4 | 1976647 | 7.8% |
_ | 1795002 | 7.1% |
5 | 1698959 | 6.7% |
7 | 1277971 | 5.1% |
- | 1196668 | 4.7% |
: | 1196668 | 4.7% |
Other values (8) | 5733470 |
line
Categorical
LÃnea de bus
Distinct | 15 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 5.1 MiB |
49 | |
---|---|
174 | |
134 | |
70 | |
27 | |
Other values (10) |
Common Values
Value | Count | Frequency (%) |
49 | 61761 | |
174 | 54823 | |
134 | 54672 | |
70 | 49559 | 8.3% |
27 | 47468 | 7.9% |
67 | 46139 | 7.7% |
129 | 41073 | 6.9% |
107 | 41060 | 6.9% |
176 | 37704 | 6.3% |
42 | 37687 | 6.3% |
Other values (5) | 126388 |
Length
Value | Count | Frequency (%) |
49 | 61761 | |
174 | 54823 | |
134 | 54672 | |
70 | 49559 | 8.3% |
27 | 47468 | 7.9% |
67 | 46139 | 7.7% |
129 | 41073 | 6.9% |
107 | 41060 | 6.9% |
176 | 37704 | 6.3% |
42 | 37687 | 6.3% |
Other values (5) | 126388 |
Most occurring characters
Value | Count | Frequency (%) |
7 | 413590 | |
1 | 355720 | |
4 | 208943 | |
2 | 126228 | 8.1% |
9 | 102834 | 6.6% |
3 | 92128 | 5.9% |
0 | 90619 | 5.8% |
6 | 83843 | 5.4% |
5 | 44315 | 2.9% |
8 | 34168 | 2.2% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 1552388 |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
7 | 413590 | |
1 | 355720 | |
4 | 208943 | |
2 | 126228 | 8.1% |
9 | 102834 | 6.6% |
3 | 92128 | 5.9% |
0 | 90619 | 5.8% |
6 | 83843 | 5.4% |
5 | 44315 | 2.9% |
8 | 34168 | 2.2% |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 1552388 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
7 | 413590 | |
1 | 355720 | |
4 | 208943 | |
2 | 126228 | 8.1% |
9 | 102834 | 6.6% |
3 | 92128 | 5.9% |
0 | 90619 | 5.8% |
6 | 83843 | 5.4% |
5 | 44315 | 2.9% |
8 | 34168 | 2.2% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1552388 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
7 | 413590 | |
1 | 355720 | |
4 | 208943 | |
2 | 126228 | 8.1% |
9 | 102834 | 6.6% |
3 | 92128 | 5.9% |
0 | 90619 | 5.8% |
6 | 83843 | 5.4% |
5 | 44315 | 2.9% |
8 | 34168 | 2.2% |
Distinct | 283 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 5.7 MiB |
1487 | 13539 |
---|---|
3252 | 8568 |
2653 | 8511 |
1488 | 8503 |
207 | 5168 |
Other values (278) |
Common Values
Value | Count | Frequency (%) |
1487 | 13539 | 2.3% |
3252 | 8568 | 1.4% |
2653 | 8511 | 1.4% |
1488 | 8503 | 1.4% |
207 | 5168 | 0.9% |
205 | 5157 | 0.9% |
203 | 5133 | 0.9% |
3253 | 5126 | 0.9% |
30 | 5116 | 0.9% |
3826 | 5109 | 0.9% |
Other values (273) | 528404 |
Length
Value | Count | Frequency (%) |
1487 | 13539 | 2.3% |
3252 | 8568 | 1.4% |
2653 | 8511 | 1.4% |
1488 | 8503 | 1.4% |
207 | 5168 | 0.9% |
205 | 5157 | 0.9% |
203 | 5133 | 0.9% |
3253 | 5126 | 0.9% |
30 | 5116 | 0.9% |
3826 | 5109 | 0.9% |
Other values (273) | 528404 |
Most occurring characters
Value | Count | Frequency (%) |
1 | 304273 | |
5 | 299509 | |
3 | 282354 | |
2 | 276931 | |
6 | 217248 | |
4 | 205171 | |
0 | 177870 | |
8 | 174111 | |
7 | 159119 | |
9 | 117925 | 5.3% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 2214511 |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
1 | 304273 | |
5 | 299509 | |
3 | 282354 | |
2 | 276931 | |
6 | 217248 | |
4 | 205171 | |
0 | 177870 | |
8 | 174111 | |
7 | 159119 | |
9 | 117925 | 5.3% |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2214511 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
1 | 304273 | |
5 | 299509 | |
3 | 282354 | |
2 | 276931 | |
6 | 217248 | |
4 | 205171 | |
0 | 177870 | |
8 | 174111 | |
7 | 159119 | |
9 | 117925 | 5.3% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2214511 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
1 | 304273 | |
5 | 299509 | |
3 | 282354 | |
2 | 276931 | |
6 | 217248 | |
4 | 205171 | |
0 | 177870 | |
8 | 174111 | |
7 | 159119 | |
9 | 117925 | 5.3% |
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 5.1 MiB |
False | |
---|---|
True | 51152 |
Value | Count | Frequency (%) |
False | 547182 | |
True | 51152 | 8.5% |
destination
Categorical
Destino del itinerario
Distinct | 14 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 47.2 MiB |
MONTECARMELO | |
---|---|
BARRIO PEÑAGRANDE | |
PLAZA CASTILLA | |
PITIS | |
VALDEBEBAS | |
Other values (9) |
Length
Max length | 22 |
---|---|
Median length | 14 |
Mean length | 11.883378 |
Min length | 5 |
Characters and Unicode
Total characters | 7110229 |
---|---|
Distinct characters | 24 |
Distinct categories | 2 ? |
Distinct scripts | 2 ? |
Distinct blocks | 2 ? |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | PLAZA CASTILLA |
---|---|
2nd row | PLAZA CASTILLA |
3rd row | PLAZA CASTILLA |
4th row | PLAZA CASTILLA |
5th row | PLAZA CASTILLA |
Common Values
Value | Count | Frequency (%) |
MONTECARMELO | 85436 | |
BARRIO PEÑAGRANDE | 80413 | |
PLAZA CASTILLA | 76392 | |
PITIS | 58329 | |
VALDEBEBAS | 51427 | |
ALSACIA | 47869 | |
MANOTERAS | 39371 | |
HORTALEZA | 39351 | |
LAS TABLAS SUR | 34275 | |
LAS TABLAS NORTE | 27396 | 4.6% |
Other values (4) | 58075 |
Length
Value | Count | Frequency (%) |
montecarmelo | 85436 | 8.9% |
peñagrande | 80413 | 8.4% |
barrio | 80413 | 8.4% |
plaza | 76392 | 8.0% |
castilla | 76392 | 8.0% |
las | 61671 | 6.4% |
tablas | 61671 | 6.4% |
pitis | 58329 | 6.1% |
valdebebas | 51427 | 5.4% |
alsacia | 47869 | 5.0% |
Other values (13) | 278641 |
Most occurring characters
Value | Count | Frequency (%) |
A | 1383333 | |
L | 600343 | 8.4% |
E | 588620 | 8.3% |
R | 547372 | 7.7% |
S | 489080 | 6.9% |
O | 405069 | 5.7% |
T | 399817 | 5.6% |
I | 377712 | 5.3% |
360320 | 5.1% | |
N | 311225 | 4.4% |
Other values (14) | 1647338 |
Most occurring categories
Value | Count | Frequency (%) |
Uppercase Letter | 6749909 | |
Space Separator | 360320 | 5.1% |
Most frequent character per category
Uppercase Letter
Value | Count | Frequency (%) |
A | 1383333 | |
L | 600343 | |
E | 588620 | |
R | 547372 | 8.1% |
S | 489080 | 7.2% |
O | 405069 | 6.0% |
T | 399817 | 5.9% |
I | 377712 | 5.6% |
N | 311225 | 4.6% |
B | 246633 | 3.7% |
Other values (13) | 1400705 |
Space Separator
Value | Count | Frequency (%) |
360320 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 6749909 | |
Common | 360320 | 5.1% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
A | 1383333 | |
L | 600343 | |
E | 588620 | |
R | 547372 | 8.1% |
S | 489080 | 7.2% |
O | 405069 | 6.0% |
T | 399817 | 5.9% |
I | 377712 | 5.6% |
N | 311225 | 4.6% |
B | 246633 | 3.7% |
Other values (13) | 1400705 |
Common
Value | Count | Frequency (%) |
360320 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 7029816 | |
None | 80413 | 1.1% |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
A | 1383333 | |
L | 600343 | 8.5% |
E | 588620 | 8.4% |
R | 547372 | 7.8% |
S | 489080 | 7.0% |
O | 405069 | 5.8% |
T | 399817 | 5.7% |
I | 377712 | 5.4% |
360320 | 5.1% | |
N | 311225 | 4.4% |
Other values (13) | 1566925 |
None
Value | Count | Frequency (%) |
Ñ | 80413 |
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 37.7 MiB |
0 | |
---|---|
288 | 2 |
Common Values
Value | Count | Frequency (%) |
0 | 598332 | |
288 | 2 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 598332 | |
288 | 2 | < 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
0 | 598332 | |
8 | 4 | < 0.1% |
2 | 2 | < 0.1% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 598338 |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
0 | 598332 | |
8 | 4 | < 0.1% |
2 | 2 | < 0.1% |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 598338 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
0 | 598332 | |
8 | 4 | < 0.1% |
2 | 2 | < 0.1% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 598338 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
0 | 598332 | |
8 | 4 | < 0.1% |
2 | 2 | < 0.1% |
Distinct | 182 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 5.7 MiB |
2137 | 10005 |
---|---|
2134 | 8849 |
2133 | 8592 |
2132 | 8310 |
2135 | 8212 |
Other values (177) |
Common Values
Value | Count | Frequency (%) |
2137 | 10005 | 1.7% |
2134 | 8849 | 1.5% |
2133 | 8592 | 1.4% |
2132 | 8310 | 1.4% |
2135 | 8212 | 1.4% |
2260 | 8102 | 1.4% |
9125 | 7883 | 1.3% |
2471 | 7737 | 1.3% |
2464 | 7703 | 1.3% |
9120 | 7613 | 1.3% |
Other values (172) | 515328 |
Length
Value | Count | Frequency (%) |
2137 | 10005 | 1.7% |
2134 | 8849 | 1.5% |
2133 | 8592 | 1.4% |
2132 | 8310 | 1.4% |
2135 | 8212 | 1.4% |
2260 | 8102 | 1.4% |
9125 | 7883 | 1.3% |
2471 | 7737 | 1.3% |
2464 | 7703 | 1.3% |
9120 | 7613 | 1.3% |
Other values (172) | 515328 |
Most occurring characters
Value | Count | Frequency (%) |
5 | 428304 | |
2 | 423674 | |
4 | 263698 | |
1 | 213202 | |
3 | 192432 | |
7 | 184268 | |
6 | 170101 | 7.4% |
0 | 166468 | 7.2% |
8 | 155274 | 6.8% |
9 | 98888 | 4.3% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 2296309 |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
5 | 428304 | |
2 | 423674 | |
4 | 263698 | |
1 | 213202 | |
3 | 192432 | |
7 | 184268 | |
6 | 170101 | 7.4% |
0 | 166468 | 7.2% |
8 | 155274 | 6.8% |
9 | 98888 | 4.3% |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2296309 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
5 | 428304 | |
2 | 423674 | |
4 | 263698 | |
1 | 213202 | |
3 | 192432 | |
7 | 184268 | |
6 | 170101 | 7.4% |
0 | 166468 | 7.2% |
8 | 155274 | 6.8% |
9 | 98888 | 4.3% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2296309 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
5 | 428304 | |
2 | 423674 | |
4 | 263698 | |
1 | 213202 | |
3 | 192432 | |
7 | 184268 | |
6 | 170101 | 7.4% |
0 | 166468 | 7.2% |
8 | 155274 | 6.8% |
9 | 98888 | 4.3% |
estimateArrive
Real number (ℝ)
SKEWED
  ZEROS
 
Tiempo estimado de espera del bus (en segundos)
Distinct | 2588 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1129.2919 |
Minimum | 0 |
---|---|
Maximum | 999999 |
Zeros | 14093 |
Zeros (%) | 2.4% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 9.1 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 50 |
Q1 | 255 |
median | 530 |
Q3 | 870 |
95-th percentile | 1365 |
Maximum | 999999 |
Range | 999999 |
Interquartile range (IQR) | 615 |
Descriptive statistics
Standard deviation | 23109.991 |
---|---|
Coefficient of variation (CV) | 20.464143 |
Kurtosis | 1863.5844 |
Mean | 1129.2919 |
Median Absolute Deviation (MAD) | 300 |
Skewness | 43.185242 |
Sum | 6.7569374 × 108 |
Variance | 5.3407169 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 14093 | 2.4% |
112 | 877 | 0.1% |
172 | 848 | 0.1% |
232 | 837 | 0.1% |
233 | 829 | 0.1% |
412 | 825 | 0.1% |
173 | 823 | 0.1% |
180 | 820 | 0.1% |
352 | 820 | 0.1% |
413 | 794 | 0.1% |
Other values (2578) | 576768 |
Value | Count | Frequency (%) |
0 | 14093 | |
1 | 343 | 0.1% |
2 | 312 | 0.1% |
3 | 316 | 0.1% |
4 | 263 | < 0.1% |
5 | 272 | < 0.1% |
6 | 293 | < 0.1% |
7 | 257 | < 0.1% |
8 | 303 | 0.1% |
9 | 262 | < 0.1% |
Value | Count | Frequency (%) |
999999 | 320 | |
2700 | 2 | < 0.1% |
2699 | 1 | < 0.1% |
2698 | 2 | < 0.1% |
2697 | 1 | < 0.1% |
2695 | 1 | < 0.1% |
2693 | 3 | < 0.1% |
2691 | 2 | < 0.1% |
2690 | 1 | < 0.1% |
2689 | 2 | < 0.1% |
Distinct | 11811 |
---|---|
Distinct (%) | 2.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2458.6632 |
Minimum | -1485 |
---|---|
Maximum | 27157 |
Zeros | 25283 |
Zeros (%) | 4.2% |
Negative | 2313 |
Negative (%) | 0.4% |
Memory size | 9.1 MiB |
Quantile statistics
Minimum | -1485 |
---|---|
5-th percentile | 24 |
Q1 | 887 |
median | 1939 |
Q3 | 3564 |
95-th percentile | 6450 |
Maximum | 27157 |
Range | 28642 |
Interquartile range (IQR) | 2677 |
Descriptive statistics
Standard deviation | 2058.1719 |
---|---|
Coefficient of variation (CV) | 0.83711013 |
Kurtosis | 2.1536088 |
Mean | 2458.6632 |
Median Absolute Deviation (MAD) | 1238 |
Skewness | 1.2766121 |
Sum | 1.4711018 × 109 |
Variance | 4236071.5 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 25283 | 4.2% |
-1 | 918 | 0.2% |
830 | 197 | < 0.1% |
733 | 196 | < 0.1% |
696 | 195 | < 0.1% |
600 | 194 | < 0.1% |
697 | 193 | < 0.1% |
1061 | 192 | < 0.1% |
569 | 191 | < 0.1% |
646 | 191 | < 0.1% |
Other values (11801) | 570584 |
Value | Count | Frequency (%) |
-1485 | 1 | |
-969 | 1 | |
-672 | 1 | |
-529 | 1 | |
-486 | 1 | |
-483 | 1 | |
-346 | 1 | |
-341 | 1 | |
-317 | 1 | |
-314 | 1 |
Value | Count | Frequency (%) |
27157 | 1 | |
20810 | 1 | |
19758 | 1 | |
18385 | 1 | |
18239 | 1 | |
18198 | 1 | |
18072 | 1 | |
18030 | 1 | |
17975 | 1 | |
17965 | 1 |
datetime
Date
Fecha y hora de la petición a la API
Distinct | 240350 |
---|---|
Distinct (%) | 40.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 9.1 MiB |
Minimum | 2024-03-13 08:00:01.765317 |
---|---|
Maximum | 2024-03-13 22:59:36.378432 |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 9.1 MiB |
Minimum | 2024-03-13 00:00:00 |
---|---|
Maximum | 2024-03-13 00:00:00 |
Distinct | 44977 |
---|---|
Distinct (%) | 7.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -3.6859704 |
Minimum | -3.7341244 |
---|---|
Maximum | 0 |
Zeros | 81 |
Zeros (%) | < 0.1% |
Negative | 598253 |
Negative (%) | > 99.9% |
Memory size | 9.1 MiB |
Quantile statistics
Minimum | -3.7341244 |
---|---|
5-th percentile | -3.7136074 |
Q1 | -3.6959401 |
median | -3.6885849 |
Q3 | -3.6799993 |
95-th percentile | -3.6484984 |
Maximum | 0 |
Range | 3.7341244 |
Interquartile range (IQR) | 0.015940745 |
Descriptive statistics
Standard deviation | 0.046925738 |
---|---|
Coefficient of variation (CV) | -0.012730905 |
Kurtosis | 5150.7228 |
Mean | -3.6859704 |
Median Absolute Deviation (MAD) | 0.0078188502 |
Skewness | 65.676074 |
Sum | -2205441.4 |
Variance | 0.0022020249 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-3.682079884 | 2412 | 0.4% |
-3.688422131 | 1456 | 0.2% |
-3.693550381 | 1067 | 0.2% |
-3.664880434 | 1067 | 0.2% |
-3.688710463 | 1061 | 0.2% |
-3.705829598 | 893 | 0.1% |
-3.692177664 | 712 | 0.1% |
-3.688586292 | 637 | 0.1% |
-3.688495343 | 572 | 0.1% |
-3.725200986 | 569 | 0.1% |
Other values (44967) | 587888 |
Value | Count | Frequency (%) |
-3.734124388 | 1 | |
-3.734116208 | 1 | |
-3.734110755 | 2 | |
-3.734105302 | 1 | |
-3.734102575 | 2 | |
-3.734099849 | 1 | |
-3.734091499 | 2 | |
-3.734078036 | 2 | |
-3.73407531 | 2 | |
-3.73406713 | 2 |
Value | Count | Frequency (%) |
0 | 81 | |
-3.578007767 | 14 | < 0.1% |
-3.608182303 | 1 | < 0.1% |
-3.60821038 | 1 | < 0.1% |
-3.608210624 | 1 | < 0.1% |
-3.608222343 | 1 | < 0.1% |
-3.608248468 | 1 | < 0.1% |
-3.608271664 | 1 | < 0.1% |
-3.608481448 | 2 | < 0.1% |
-3.608498301 | 1 | < 0.1% |
Distinct | 44977 |
---|---|
Distinct (%) | 7.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 40.466236 |
Minimum | 0 |
---|---|
Maximum | 40.673134 |
Zeros | 81 |
Zeros (%) | < 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 9.1 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 40.428719 |
Q1 | 40.467263 |
median | 40.47133 |
Q3 | 40.482079 |
95-th percentile | 40.499322 |
Maximum | 40.673134 |
Range | 40.673134 |
Interquartile range (IQR) | 0.014815961 |
Descriptive statistics
Standard deviation | 0.47125847 |
---|---|
Coefficient of variation (CV) | 0.01164572 |
Kurtosis | 7357.0535 |
Mean | 40.466236 |
Median Absolute Deviation (MAD) | 0.0057603363 |
Skewness | -85.712563 |
Sum | 24212325 |
Variance | 0.22208455 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
40.48036006 | 2412 | 0.4% |
40.46825881 | 1456 | 0.2% |
40.48778618 | 1067 | 0.2% |
40.50548572 | 1067 | 0.2% |
40.4665018 | 1061 | 0.2% |
40.46415416 | 893 | 0.1% |
40.51048521 | 712 | 0.1% |
40.46763543 | 637 | 0.1% |
40.46798163 | 572 | 0.1% |
40.49518427 | 569 | 0.1% |
Other values (44967) | 587888 |
Value | Count | Frequency (%) |
0 | 81 | |
40.4040894 | 2 | < 0.1% |
40.40408989 | 17 | < 0.1% |
40.40409038 | 3 | < 0.1% |
40.40409087 | 4 | < 0.1% |
40.40409136 | 13 | < 0.1% |
40.40409283 | 5 | < 0.1% |
40.40409332 | 5 | < 0.1% |
40.4040943 | 25 | < 0.1% |
40.40409479 | 13 | < 0.1% |
Value | Count | Frequency (%) |
40.67313425 | 24 | < 0.1% |
40.65915359 | 23 | < 0.1% |
40.59692139 | 270 | |
40.59691793 | 18 | < 0.1% |
40.51655589 | 6 | < 0.1% |
40.51654381 | 2 | < 0.1% |
40.51654093 | 2 | < 0.1% |
40.51653792 | 1 | < 0.1% |
40.51651572 | 9 | < 0.1% |
40.51651082 | 1 | < 0.1% |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 38.2 MiB |
LA |
---|
Common Values
Value | Count | Frequency (%) |
LA | 598334 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
la | 598334 |
Most occurring characters
Value | Count | Frequency (%) |
L | 598334 | |
A | 598334 |
Most occurring categories
Value | Count | Frequency (%) |
Uppercase Letter | 1196668 |
Most frequent character per category
Uppercase Letter
Value | Count | Frequency (%) |
L | 598334 | |
A | 598334 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 1196668 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
L | 598334 | |
A | 598334 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1196668 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
L | 598334 | |
A | 598334 |
StartTime
Categorical
Hora de inicio de la lÃnea
Distinct | 8 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 39.9 MiB |
06:00 | |
---|---|
06:10 | |
06:25 | |
05:30 | |
05:55 | |
Other values (3) |
Common Values
Value | Count | Frequency (%) |
06:00 | 306319 | |
06:10 | 61761 | 10.3% |
06:25 | 54672 | 9.1% |
05:30 | 49559 | 8.3% |
05:55 | 47468 | 7.9% |
06:15 | 41060 | 6.9% |
06:20 | 23972 | 4.0% |
06:30 | 13523 | 2.3% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
06:00 | 306319 | |
06:10 | 61761 | 10.3% |
06:25 | 54672 | 9.1% |
05:30 | 49559 | 8.3% |
05:55 | 47468 | 7.9% |
06:15 | 41060 | 6.9% |
06:20 | 23972 | 4.0% |
06:30 | 13523 | 2.3% |
Most occurring characters
Value | Count | Frequency (%) |
0 | 1359787 | |
: | 598334 | |
6 | 501307 | 16.8% |
5 | 287695 | 9.6% |
1 | 102821 | 3.4% |
2 | 78644 | 2.6% |
3 | 63082 | 2.1% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 2393336 | |
Other Punctuation | 598334 | 20.0% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
0 | 1359787 | |
6 | 501307 | 20.9% |
5 | 287695 | 12.0% |
1 | 102821 | 4.3% |
2 | 78644 | 3.3% |
3 | 63082 | 2.6% |
Other Punctuation
Value | Count | Frequency (%) |
: | 598334 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2991670 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
0 | 1359787 | |
: | 598334 | |
6 | 501307 | 16.8% |
5 | 287695 | 9.6% |
1 | 102821 | 3.4% |
2 | 78644 | 2.6% |
3 | 63082 | 2.1% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2991670 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
0 | 1359787 | |
: | 598334 | |
6 | 501307 | 16.8% |
5 | 287695 | 9.6% |
1 | 102821 | 3.4% |
2 | 78644 | 2.6% |
3 | 63082 | 2.1% |
StopTime
Categorical
Hora de fin de la lÃnea
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 39.9 MiB |
23:45 | |
---|---|
23:30 |
Common Values
Value | Count | Frequency (%) |
23:45 | 526894 | |
23:30 | 71440 | 11.9% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
23:45 | 526894 | |
23:30 | 71440 | 11.9% |
Most occurring characters
Value | Count | Frequency (%) |
3 | 669774 | |
2 | 598334 | |
: | 598334 | |
4 | 526894 | |
5 | 526894 | |
0 | 71440 | 2.4% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 2393336 | |
Other Punctuation | 598334 | 20.0% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
3 | 669774 | |
2 | 598334 | |
4 | 526894 | |
5 | 526894 | |
0 | 71440 | 3.0% |
Other Punctuation
Value | Count | Frequency (%) |
: | 598334 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2991670 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
3 | 669774 | |
2 | 598334 | |
: | 598334 | |
4 | 526894 | |
5 | 526894 | |
0 | 71440 | 2.4% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2991670 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
3 | 669774 | |
2 | 598334 | |
: | 598334 | |
4 | 526894 | |
5 | 526894 | |
0 | 71440 | 2.4% |
MinimunFrequency
Real number (ℝ)
Frecuencia mÃnima de la lÃnea
Distinct | 7 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 7.1873485 |
Minimum | 3 |
---|---|
Maximum | 12 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 9.1 MiB |
Quantile statistics
Minimum | 3 |
---|---|
5-th percentile | 3 |
Q1 | 4 |
median | 7 |
Q3 | 9 |
95-th percentile | 12 |
Maximum | 12 |
Range | 9 |
Interquartile range (IQR) | 5 |
Descriptive statistics
Standard deviation | 2.6407197 |
---|---|
Coefficient of variation (CV) | 0.36741223 |
Kurtosis | -0.98041952 |
Mean | 7.1873485 |
Median Absolute Deviation (MAD) | 2 |
Skewness | 0.059017423 |
Sum | 4300435 |
Variance | 6.9734008 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
9 | 169098 | |
7 | 116443 | |
4 | 111320 | |
6 | 71872 | |
3 | 47468 | 7.9% |
12 | 41073 | 6.9% |
11 | 41060 | 6.9% |
Value | Count | Frequency (%) |
3 | 47468 | 7.9% |
4 | 111320 | |
6 | 71872 | |
7 | 116443 | |
9 | 169098 | |
11 | 41060 | 6.9% |
12 | 41073 | 6.9% |
Value | Count | Frequency (%) |
12 | 41073 | 6.9% |
11 | 41060 | 6.9% |
9 | 169098 | |
7 | 116443 | |
6 | 71872 | |
4 | 111320 | |
3 | 47468 | 7.9% |
MaximumFrequency
Real number (ℝ)
Frecuencia máxima de la lÃnea
Distinct | 10 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 21.387937 |
Minimum | 12 |
---|---|
Maximum | 30 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 9.1 MiB |
Quantile statistics
Minimum | 12 |
---|---|
5-th percentile | 12 |
Q1 | 17 |
median | 22 |
Q3 | 24 |
95-th percentile | 30 |
Maximum | 30 |
Range | 18 |
Interquartile range (IQR) | 7 |
Descriptive statistics
Standard deviation | 4.813608 |
---|---|
Coefficient of variation (CV) | 0.22506182 |
Kurtosis | -0.45107401 |
Mean | 21.387937 |
Median Absolute Deviation (MAD) | 2 |
Skewness | -0.25468157 |
Sum | 12797130 |
Variance | 23.170822 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
22 | 160843 | |
24 | 102732 | |
15 | 61761 | 10.3% |
26 | 54672 | 9.1% |
17 | 49559 | 8.3% |
12 | 47468 | 7.9% |
30 | 46139 | 7.7% |
20 | 37704 | 6.3% |
21 | 23933 | 4.0% |
29 | 13523 | 2.3% |
Value | Count | Frequency (%) |
12 | 47468 | 7.9% |
15 | 61761 | 10.3% |
17 | 49559 | 8.3% |
20 | 37704 | 6.3% |
21 | 23933 | 4.0% |
22 | 160843 | |
24 | 102732 | |
26 | 54672 | 9.1% |
29 | 13523 | 2.3% |
30 | 46139 | 7.7% |
Value | Count | Frequency (%) |
30 | 46139 | 7.7% |
29 | 13523 | 2.3% |
26 | 54672 | 9.1% |
24 | 102732 | |
22 | 160843 | |
21 | 23933 | 4.0% |
20 | 37704 | 6.3% |
17 | 49559 | 8.3% |
15 | 61761 | 10.3% |
12 | 47468 | 7.9% |
PK | line | stop | isHead | destination | deviation | bus | estimateArrive | DistanceBus | datetime | date | positionBusLon | positionBusLat | dayType | StartTime | StopTime | MinimunFrequency | MaximumFrequency | strike | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2024-03-13 08:00:01.765317_B513_L27_S56 | 27 | 56 | False | PLAZA CASTILLA | 0 | 513 | 473 | 1841 | 2024-03-13 08:00:01.765317 | 2024-03-13 | -3.690542 | 40.423739 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
1 | 2024-03-13 08:00:01.765317_B521_L27_S56 | 27 | 56 | False | PLAZA CASTILLA | 0 | 521 | 313 | 1221 | 2024-03-13 08:00:01.765317 | 2024-03-13 | -3.689019 | 40.429011 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
12 | 2024-03-13 08:00:01.810182_B513_L27_S60 | 27 | 60 | False | PLAZA CASTILLA | 0 | 513 | 282 | 1159 | 2024-03-13 08:00:01.810182 | 2024-03-13 | -3.690542 | 40.423739 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
13 | 2024-03-13 08:00:01.810182_B521_L27_S60 | 27 | 60 | False | PLAZA CASTILLA | 0 | 521 | 116 | 646 | 2024-03-13 08:00:01.810182 | 2024-03-13 | -3.689019 | 40.429011 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
22 | 2024-03-13 08:00:01.810759_B513_L27_S66 | 27 | 66 | False | PLAZA CASTILLA | 0 | 513 | 123 | 391 | 2024-03-13 08:00:01.810759 | 2024-03-13 | -3.690542 | 40.423739 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
23 | 2024-03-13 08:00:01.810759_B526_L27_S66 | 27 | 66 | False | PLAZA CASTILLA | 0 | 526 | 424 | 1378 | 2024-03-13 08:00:01.810759 | 2024-03-13 | -3.693451 | 40.415523 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
32 | 2024-03-13 08:00:01.811512_B521_L27_S52 | 27 | 52 | False | PLAZA CASTILLA | 0 | 521 | 419 | 1775 | 2024-03-13 08:00:01.811512 | 2024-03-13 | -3.689019 | 40.429011 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
33 | 2024-03-13 08:00:01.811512_B537_L27_S52 | 27 | 52 | False | PLAZA CASTILLA | 0 | 537 | 117 | 656 | 2024-03-13 08:00:01.811512 | 2024-03-13 | -3.690119 | 40.438093 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
51 | 2024-03-13 08:00:01.812652_B511_L27_S85 | 27 | 85 | False | PLAZA CASTILLA | 0 | 511 | 184 | 591 | 2024-03-13 08:00:01.812652 | 2024-03-13 | -3.702306 | 40.405239 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
52 | 2024-03-13 08:00:01.812652_B524_L27_S85 | 27 | 85 | False | PLAZA CASTILLA | 0 | 524 | 295 | 489 | 2024-03-13 08:00:01.812652 | 2024-03-13 | -3.702096 | 40.405283 | LA | 05:55 | 23:30 | 3.0 | 12.0 | N |
PK | line | stop | isHead | destination | deviation | bus | estimateArrive | DistanceBus | datetime | date | positionBusLon | positionBusLat | dayType | StartTime | StopTime | MinimunFrequency | MaximumFrequency | strike | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1134446 | 2024-03-13 22:59:07.675931_B2545_L173_S5927 | 173 | 5927 | False | SANCHINARRO | 0 | 2545 | 51 | 196 | 2024-03-13 22:59:07.675931 | 2024-03-13 | -3.657475 | 40.493921 | LA | 06:00 | 23:45 | 7.0 | 21.0 | N |
1134447 | 2024-03-13 22:59:07.708629_B8851_L176_S5984 | 176 | 5984 | False | LAS TABLAS SUR | 0 | 8851 | 432 | 2001 | 2024-03-13 22:59:07.708629 | 2024-03-13 | -3.668304 | 40.493645 | LA | 06:00 | 23:45 | 6.0 | 20.0 | N |
1134448 | 2024-03-13 22:59:07.708629_B8864_L176_S5984 | 176 | 5984 | False | LAS TABLAS SUR | 0 | 8864 | 1263 | 6709 | 2024-03-13 22:59:07.708629 | 2024-03-13 | -3.688390 | 40.470399 | LA | 06:00 | 23:45 | 6.0 | 20.0 | N |
1134451 | 2024-03-13 22:59:07.744969_B4965_L42_S5996 | 42 | 5996 | True | PLAZA CASTILLA | 0 | 4965 | 110 | 0 | 2024-03-13 22:59:07.744969 | 2024-03-13 | -3.728814 | 40.473979 | LA | 06:00 | 23:45 | 7.0 | 24.0 | N |
1134452 | 2024-03-13 22:59:07.744969_B5550_L42_S5996 | 42 | 5996 | True | PLAZA CASTILLA | 0 | 5550 | 1551 | 5908 | 2024-03-13 22:59:07.744969 | 2024-03-13 | -3.689050 | 40.467641 | LA | 06:00 | 23:45 | 7.0 | 24.0 | N |
1134453 | 2024-03-13 22:59:07.748610_B2067_L174_S51022 | 174 | 51022 | True | PLAZA CASTILLA | 0 | 2067 | 651 | 3707 | 2024-03-13 22:59:07.748610 | 2024-03-13 | -3.621954 | 40.482080 | LA | 06:00 | 23:45 | 7.0 | 22.0 | N |
1134456 | 2024-03-13 22:59:07.770061_B2067_L174_S51023 | 174 | 51023 | False | VALDEBEBAS | 0 | 2067 | 409 | 3352 | 2024-03-13 22:59:07.770061 | 2024-03-13 | -3.621954 | 40.482080 | LA | 06:00 | 23:45 | 7.0 | 22.0 | N |
1134457 | 2024-03-13 22:59:07.770061_B2141_L174_S51023 | 174 | 51023 | False | VALDEBEBAS | 0 | 2141 | 1225 | 8114 | 2024-03-13 22:59:07.770061 | 2024-03-13 | -3.667048 | 40.489136 | LA | 06:00 | 23:45 | 7.0 | 22.0 | N |
1134460 | 2024-03-13 22:59:36.378432_B2290_L174_S3256 | 174 | 3256 | False | VALDEBEBAS | 0 | 2290 | 1960 | 13847 | 2024-03-13 22:59:36.378432 | 2024-03-13 | -3.623092 | 40.482330 | LA | 06:00 | 23:45 | 7.0 | 22.0 | N |
1134461 | 2024-03-13 22:59:36.378432_B8879_L174_S3256 | 174 | 3256 | False | VALDEBEBAS | 0 | 8879 | 746 | 4891 | 2024-03-13 22:59:36.378432 | 2024-03-13 | -3.676137 | 40.469620 | LA | 06:00 | 23:45 | 7.0 | 22.0 | N |