Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 2000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 136.8 KiB |
Average record size in memory | 70.1 B |
Variable types
Numeric | 6 |
---|---|
Text | 1 |
Categorical | 1 |
Dataset
Description | 샘플 데이터 |
---|---|
Author | (주)모토브 / 신재훈 |
URL | https://www.bigdata-transportation.kr/frn/prdt/detail?prdtId=PRDTNUM_000000020256 |
register_at has constant value "" | Constant |
accel_sensor_value_id has unique values | Unique |
Reproduction
Analysis started | 2023-12-11 22:42:15.354339 |
---|---|
Analysis finished | 2023-12-11 22:42:20.474561 |
Duration | 5.12 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
accel_sensor_value_id
Real number (ℝ)
UNIQUE
 
Distinct | 2000 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1000.5 |
Minimum | 1 |
---|---|
Maximum | 2000 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 17.7 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 100.95 |
Q1 | 500.75 |
median | 1000.5 |
Q3 | 1500.25 |
95-th percentile | 1900.05 |
Maximum | 2000 |
Range | 1999 |
Interquartile range (IQR) | 999.5 |
Descriptive statistics
Standard deviation | 577.49459 |
---|---|
Coefficient of variation (CV) | 0.57720599 |
Kurtosis | -1.2 |
Mean | 1000.5 |
Median Absolute Deviation (MAD) | 500 |
Skewness | 0 |
Sum | 2001000 |
Variance | 333500 |
Monotonicity | Strictly increasing |
Value | Count | Frequency (%) |
1 | 1 | 0.1% |
1331 | 1 | 0.1% |
1344 | 1 | 0.1% |
1343 | 1 | 0.1% |
1342 | 1 | 0.1% |
1341 | 1 | 0.1% |
1340 | 1 | 0.1% |
1339 | 1 | 0.1% |
1338 | 1 | 0.1% |
1337 | 1 | 0.1% |
Other values (1990) | 1990 |
Value | Count | Frequency (%) |
1 | 1 | |
2 | 1 | |
3 | 1 | |
4 | 1 | |
5 | 1 | |
6 | 1 | |
7 | 1 | |
8 | 1 | |
9 | 1 | |
10 | 1 |
Value | Count | Frequency (%) |
2000 | 1 | |
1999 | 1 | |
1998 | 1 | |
1997 | 1 | |
1996 | 1 | |
1995 | 1 | |
1994 | 1 | |
1993 | 1 | |
1992 | 1 | |
1991 | 1 |
taxi_id
Text
Distinct | 156 |
---|---|
Distinct (%) | 7.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.8 KiB |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Characters and Unicode
Total characters | 20000 |
---|---|
Distinct characters | 12 |
Distinct categories | 3 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | T_96289981 |
---|---|
2nd row | T_73322493 |
3rd row | T_45081461 |
4th row | T_44934973 |
5th row | T_47791477 |
Value | Count | Frequency (%) |
t_48230939 | 14 | 0.7% |
t_44056049 | 13 | 0.7% |
t_96875931 | 13 | 0.7% |
t_17939084 | 13 | 0.7% |
t_48743645 | 13 | 0.7% |
t_98047829 | 13 | 0.7% |
t_93872940 | 13 | 0.7% |
t_98267560 | 13 | 0.7% |
t_48816888 | 13 | 0.7% |
t_17133403 | 13 | 0.7% |
Other values (146) | 1869 |
Most occurring characters
Value | Count | Frequency (%) |
4 | 2133 | |
T | 2000 | |
_ | 2000 | |
9 | 1791 | |
8 | 1731 | |
7 | 1687 | |
3 | 1647 | |
6 | 1578 | |
2 | 1503 | |
1 | 1457 | |
Other values (2) | 2473 |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 16000 | |
Uppercase Letter | 2000 | 10.0% |
Connector Punctuation | 2000 | 10.0% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
4 | 2133 | |
9 | 1791 | |
8 | 1731 | |
7 | 1687 | |
3 | 1647 | |
6 | 1578 | |
2 | 1503 | |
1 | 1457 | |
5 | 1243 | |
0 | 1230 |
Uppercase Letter
Value | Count | Frequency (%) |
T | 2000 |
Connector Punctuation
Value | Count | Frequency (%) |
_ | 2000 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 18000 | |
Latin | 2000 | 10.0% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
4 | 2133 | |
_ | 2000 | |
9 | 1791 | |
8 | 1731 | |
7 | 1687 | |
3 | 1647 | |
6 | 1578 | |
2 | 1503 | |
1 | 1457 | |
5 | 1243 |
Latin
Value | Count | Frequency (%) |
T | 2000 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 20000 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
4 | 2133 | |
T | 2000 | |
_ | 2000 | |
9 | 1791 | |
8 | 1731 | |
7 | 1687 | |
3 | 1647 | |
6 | 1578 | |
2 | 1503 | |
1 | 1457 | |
Other values (2) | 2473 |
latitude
Real number (ℝ)
Distinct | 1311 |
---|---|
Distinct (%) | 65.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 37.496865 |
Minimum | 36.941452 |
---|---|
Maximum | 37.778934 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 17.7 KiB |
Quantile statistics
Minimum | 36.941452 |
---|---|
5-th percentile | 37.407019 |
Q1 | 37.461149 |
median | 37.495274 |
Q3 | 37.529408 |
95-th percentile | 37.602837 |
Maximum | 37.778934 |
Range | 0.837482 |
Interquartile range (IQR) | 0.068259 |
Descriptive statistics
Standard deviation | 0.075858641 |
---|---|
Coefficient of variation (CV) | 0.0020230662 |
Kurtosis | 18.023049 |
Mean | 37.496865 |
Median Absolute Deviation (MAD) | 0.034134 |
Skewness | -2.1109858 |
Sum | 74993.73 |
Variance | 0.0057545334 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
37.479614 | 14 | 0.7% |
37.41697 | 13 | 0.7% |
37.443947 | 13 | 0.7% |
37.46929 | 13 | 0.7% |
37.60681 | 13 | 0.7% |
37.473686 | 13 | 0.7% |
37.523636 | 13 | 0.7% |
37.48688 | 13 | 0.7% |
37.5649 | 13 | 0.7% |
37.43951 | 13 | 0.7% |
Other values (1301) | 1869 |
Value | Count | Frequency (%) |
36.941452 | 1 | |
36.941525 | 1 | |
36.941605 | 1 | |
36.941692 | 1 | |
36.941776 | 1 | |
36.94187 | 1 | |
36.941967 | 1 | |
36.94207 | 1 | |
36.942173 | 1 | |
36.942276 | 1 |
Value | Count | Frequency (%) |
37.778934 | 1 | |
37.778854 | 1 | |
37.778793 | 1 | |
37.77873 | 1 | |
37.778675 | 1 | |
37.778606 | 1 | |
37.77855 | 1 | |
37.778515 | 1 | |
37.7785 | 1 | |
37.778496 | 2 |
longitude
Real number (ℝ)
Distinct | 1008 |
---|---|
Distinct (%) | 50.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 126.82134 |
Minimum | 126.48862 |
---|---|
Maximum | 127.46536 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 17.7 KiB |
Quantile statistics
Minimum | 126.48862 |
---|---|
5-th percentile | 126.63768 |
Q1 | 126.69009 |
median | 126.72744 |
Q3 | 126.97359 |
95-th percentile | 127.12796 |
Maximum | 127.46536 |
Range | 0.976735 |
Interquartile range (IQR) | 0.2835 |
Descriptive statistics
Standard deviation | 0.17404787 |
---|---|
Coefficient of variation (CV) | 0.0013723863 |
Kurtosis | -0.1438309 |
Mean | 126.82134 |
Median Absolute Deviation (MAD) | 0.072755 |
Skewness | 0.77860072 |
Sum | 253642.68 |
Variance | 0.030292662 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
126.69009 | 17 | 0.9% |
127.12796 | 14 | 0.7% |
126.67689 | 14 | 0.7% |
126.63667 | 13 | 0.7% |
126.70612 | 13 | 0.7% |
126.659004 | 13 | 0.7% |
126.97359 | 13 | 0.7% |
126.6923 | 13 | 0.7% |
126.71236 | 13 | 0.7% |
126.70156 | 13 | 0.7% |
Other values (998) | 1864 |
Value | Count | Frequency (%) |
126.488625 | 1 | |
126.48877 | 1 | |
126.48893 | 1 | |
126.48908 | 1 | |
126.48923 | 1 | |
126.48937 | 1 | |
126.4895 | 1 | |
126.48965 | 1 | |
126.48978 | 1 | |
126.48992 | 1 |
Value | Count | Frequency (%) |
127.46536 | 1 | |
127.46499 | 1 | |
127.464615 | 1 | |
127.46424 | 1 | |
127.46387 | 1 | |
127.46349 | 1 | |
127.46312 | 1 | |
127.462746 | 1 | |
127.46239 | 1 | |
127.46201 | 1 |
accel_x
Real number (ℝ)
Distinct | 723 |
---|---|
Distinct (%) | 36.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 41457.549 |
Minimum | 0 |
---|---|
Maximum | 65534 |
Zeros | 3 |
Zeros (%) | 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 17.7 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 39.9 |
Q1 | 284 |
median | 65013 |
Q3 | 65346 |
95-th percentile | 65502 |
Maximum | 65534 |
Range | 65534 |
Interquartile range (IQR) | 65062 |
Descriptive statistics
Standard deviation | 31264.564 |
---|---|
Coefficient of variation (CV) | 0.7541344 |
Kurtosis | -1.6888169 |
Mean | 41457.549 |
Median Absolute Deviation (MAD) | 456 |
Skewness | -0.5588776 |
Sum | 82915098 |
Variance | 9.7747295 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
65332 | 13 | 0.7% |
65456 | 11 | 0.5% |
65384 | 11 | 0.5% |
200 | 11 | 0.5% |
65488 | 10 | 0.5% |
65316 | 10 | 0.5% |
82 | 10 | 0.5% |
65510 | 10 | 0.5% |
65364 | 9 | 0.4% |
65416 | 9 | 0.4% |
Other values (713) | 1896 |
Value | Count | Frequency (%) |
0 | 3 | 0.1% |
2 | 5 | |
4 | 3 | 0.1% |
6 | 4 | |
8 | 7 | |
10 | 4 | |
12 | 7 | |
14 | 6 | |
16 | 9 | |
18 | 5 |
Value | Count | Frequency (%) |
65534 | 9 | |
65532 | 6 | |
65530 | 5 | |
65528 | 4 | |
65526 | 7 | |
65524 | 7 | |
65522 | 4 | |
65520 | 5 | |
65518 | 2 | 0.1% |
65516 | 6 |
accel_y
Real number (ℝ)
Distinct | 914 |
---|---|
Distinct (%) | 45.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 57260.166 |
Minimum | 0 |
---|---|
Maximum | 65534 |
Zeros | 1 |
Zeros (%) | < 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 17.7 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 350 |
Q1 | 64348 |
median | 64757 |
Q3 | 65028 |
95-th percentile | 65350.1 |
Maximum | 65534 |
Range | 65534 |
Interquartile range (IQR) | 680 |
Descriptive statistics
Standard deviation | 20620.378 |
---|---|
Coefficient of variation (CV) | 0.36011733 |
Kurtosis | 3.7235832 |
Mean | 57260.166 |
Median Absolute Deviation (MAD) | 312 |
Skewness | -2.3905999 |
Sum | 1.1452033 × 108 |
Variance | 4.2519998 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
65012 | 10 | 0.5% |
64544 | 9 | 0.4% |
64848 | 9 | 0.4% |
65094 | 9 | 0.4% |
64834 | 8 | 0.4% |
64984 | 8 | 0.4% |
64516 | 8 | 0.4% |
64606 | 8 | 0.4% |
64936 | 8 | 0.4% |
64792 | 7 | 0.4% |
Other values (904) | 1916 |
Value | Count | Frequency (%) |
0 | 1 | 0.1% |
2 | 1 | 0.1% |
4 | 2 | |
6 | 3 | |
8 | 2 | |
10 | 1 | 0.1% |
12 | 2 | |
16 | 1 | 0.1% |
20 | 1 | 0.1% |
24 | 1 | 0.1% |
Value | Count | Frequency (%) |
65534 | 1 | |
65528 | 1 | |
65518 | 1 | |
65516 | 1 | |
65514 | 1 | |
65512 | 1 | |
65508 | 1 | |
65506 | 2 | |
65504 | 2 | |
65500 | 2 |
accel_z
Real number (ℝ)
Distinct | 752 |
---|---|
Distinct (%) | 37.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 8246.941 |
Minimum | 5070 |
---|---|
Maximum | 12044 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 17.7 KiB |
Quantile statistics
Minimum | 5070 |
---|---|
5-th percentile | 7543.8 |
Q1 | 8022 |
median | 8237 |
Q3 | 8450 |
95-th percentile | 8968.1 |
Maximum | 12044 |
Range | 6974 |
Interquartile range (IQR) | 428 |
Descriptive statistics
Standard deviation | 503.73011 |
---|---|
Coefficient of variation (CV) | 0.061080843 |
Kurtosis | 10.546437 |
Mean | 8246.941 |
Median Absolute Deviation (MAD) | 213 |
Skewness | 0.91966934 |
Sum | 16493882 |
Variance | 253744.02 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
8128 | 12 | 0.6% |
8358 | 10 | 0.5% |
8166 | 10 | 0.5% |
8152 | 9 | 0.4% |
8420 | 9 | 0.4% |
8146 | 9 | 0.4% |
8240 | 9 | 0.4% |
8326 | 9 | 0.4% |
8264 | 9 | 0.4% |
8246 | 9 | 0.4% |
Other values (742) | 1905 |
Value | Count | Frequency (%) |
5070 | 1 | |
5296 | 1 | |
6020 | 1 | |
6032 | 1 | |
6060 | 1 | |
6094 | 1 | |
6118 | 1 | |
6252 | 1 | |
6424 | 1 | |
6448 | 1 |
Value | Count | Frequency (%) |
12044 | 1 | |
12024 | 1 | |
11566 | 1 | |
11542 | 1 | |
11464 | 1 | |
11152 | 1 | |
11006 | 1 | |
10992 | 1 | |
10750 | 1 | |
10566 | 1 |
register_at
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.8 KiB |
2020-09-10 22:00 |
---|
Length
Max length | 16 |
---|---|
Median length | 16 |
Mean length | 16 |
Min length | 16 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2020-09-10 22:00 |
---|---|
2nd row | 2020-09-10 22:00 |
3rd row | 2020-09-10 22:00 |
4th row | 2020-09-10 22:00 |
5th row | 2020-09-10 22:00 |
Common Values
Value | Count | Frequency (%) |
2020-09-10 22:00 | 2000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2020-09-10 | 2000 | |
22:00 | 2000 |
accel_sensor_value_id | latitude | longitude | accel_x | accel_y | accel_z | |
---|---|---|---|---|---|---|
accel_sensor_value_id | 1.000 | 0.000 | 0.000 | 0.000 | 0.014 | 0.000 |
latitude | 0.000 | 1.000 | 0.687 | 0.122 | 0.178 | 0.126 |
longitude | 0.000 | 0.687 | 1.000 | 0.235 | 0.086 | 0.143 |
accel_x | 0.000 | 0.122 | 0.235 | 1.000 | 0.000 | 0.066 |
accel_y | 0.014 | 0.178 | 0.086 | 0.000 | 1.000 | 0.196 |
accel_z | 0.000 | 0.126 | 0.143 | 0.066 | 0.196 | 1.000 |
accel_sensor_value_id | latitude | longitude | accel_x | accel_y | accel_z | |
---|---|---|---|---|---|---|
accel_sensor_value_id | 1.000 | -0.000 | 0.011 | 0.026 | -0.019 | 0.031 |
latitude | -0.000 | 1.000 | 0.196 | -0.092 | -0.069 | 0.010 |
longitude | 0.011 | 0.196 | 1.000 | -0.106 | -0.035 | 0.088 |
accel_x | 0.026 | -0.092 | -0.106 | 1.000 | 0.109 | -0.044 |
accel_y | -0.019 | -0.069 | -0.035 | 0.109 | 1.000 | 0.009 |
accel_z | 0.031 | 0.010 | 0.088 | -0.044 | 0.009 | 1.000 |
accel_sensor_value_id | taxi_id | latitude | longitude | accel_x | accel_y | accel_z | register_at | |
---|---|---|---|---|---|---|---|---|
0 | 1 | T_96289981 | 37.610664 | 126.724655 | 0 | 64794 | 8158 | 2020-09-10 22:00 |
1 | 2 | T_73322493 | 37.621788 | 127.08755 | 65526 | 64546 | 8258 | 2020-09-10 22:00 |
2 | 3 | T_45081461 | 37.554714 | 126.673065 | 65442 | 224 | 6552 | 2020-09-10 22:00 |
3 | 4 | T_44934973 | 37.52825 | 126.67643 | 146 | 65054 | 7336 | 2020-09-10 22:00 |
4 | 5 | T_47791477 | 37.502796 | 127.04183 | 50 | 64884 | 8360 | 2020-09-10 22:00 |
5 | 6 | T_43689831 | 37.52204 | 126.79642 | 64454 | 268 | 7376 | 2020-09-10 22:00 |
6 | 7 | T_97388636 | 37.527405 | 126.90563 | 65236 | 64802 | 8412 | 2020-09-10 22:00 |
7 | 8 | T_92701041 | 37.462093 | 126.63755 | 65214 | 2 | 8300 | 2020-09-10 22:00 |
8 | 9 | T_18378546 | 37.50068 | 126.730644 | 65322 | 64800 | 8278 | 2020-09-10 22:00 |
9 | 10 | T_73102763 | 37.55852 | 126.859764 | 65474 | 64564 | 8142 | 2020-09-10 22:00 |
accel_sensor_value_id | taxi_id | latitude | longitude | accel_x | accel_y | accel_z | register_at | |
---|---|---|---|---|---|---|---|---|
1990 | 1991 | T_69074360 | 37.458294 | 126.68937 | 65406 | 64462 | 8082 | 2020-09-10 22:00 |
1991 | 1992 | T_42298201 | 37.47085 | 126.63768 | 65380 | 64836 | 8082 | 2020-09-10 22:00 |
1992 | 1993 | T_48084452 | 37.53413 | 126.90669 | 65376 | 65136 | 8764 | 2020-09-10 22:00 |
1993 | 1994 | T_70832208 | 37.443947 | 126.7028 | 65132 | 64826 | 8390 | 2020-09-10 22:00 |
1994 | 1995 | T_99219728 | 37.58152 | 126.8875 | 65448 | 64542 | 8104 | 2020-09-10 22:00 |
1995 | 1996 | T_98267560 | 37.516994 | 126.94112 | 82 | 64644 | 7826 | 2020-09-10 22:00 |
1996 | 1997 | T_48816888 | 37.48363 | 127.01179 | 65516 | 64202 | 8232 | 2020-09-10 22:00 |
1997 | 1998 | T_68854629 | 37.450733 | 126.696335 | 120 | 64462 | 8618 | 2020-09-10 22:00 |
1998 | 1999 | T_93872940 | 37.46588 | 126.68919 | 54 | 64584 | 8366 | 2020-09-10 22:00 |
1999 | 2000 | T_74494392 | 37.569748 | 126.81935 | 34 | 64926 | 8236 | 2020-09-10 22:00 |