Overview

Dataset statistics

Number of variables9
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory849.6 KiB
Average record size in memory87.0 B

Variable types

Categorical3
Numeric5
Boolean1

Dataset

Description제로셔틀 차량제어정보 조회
Author차세대융합기술연구원
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=05X2SPLFUER2GM7D4EUI31948294&infSeq=1

Alerts

멈춤여부 has constant value ""Constant
기어수 has constant value ""Constant
수집일시 is highly overall correlated with 순번 and 2 other fieldsHigh correlation
수집순번 is highly overall correlated with 순번 and 2 other fieldsHigh correlation
순번 is highly overall correlated with 초수 and 2 other fieldsHigh correlation
초수 is highly overall correlated with 순번 and 2 other fieldsHigh correlation
휠각도등급값 is highly skewed (γ1 = 39.89003052)Skewed
순번 has unique valuesUnique
속도 has 3656 (36.6%) zerosZeros
휠각도등급값 has 965 (9.7%) zerosZeros

Reproduction

Analysis started2024-03-23 02:09:26.805537
Analysis finished2024-03-23 02:09:37.099729
Duration10.29 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

수집일시
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2021-11-11-14-23-40
2342 
2021-11-11-14-31-15
2280 
2021-11-11-14-38-54
2275 
2021-11-11-14-16-08
2180 
2021-11-11-14-46-33
923 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-11-11-14-16-08
2nd row2021-11-11-14-23-40
3rd row2021-11-11-14-23-40
4th row2021-11-11-14-23-40
5th row2021-11-11-14-38-54

Common Values

ValueCountFrequency (%)
2021-11-11-14-23-40 2342
23.4%
2021-11-11-14-31-15 2280
22.8%
2021-11-11-14-38-54 2275
22.8%
2021-11-11-14-16-08 2180
21.8%
2021-11-11-14-46-33 923
 
9.2%

Length

2024-03-23T02:09:37.374463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T02:09:37.719022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-11-11-14-23-40 2342
23.4%
2021-11-11-14-31-15 2280
22.8%
2021-11-11-14-38-54 2275
22.8%
2021-11-11-14-16-08 2180
21.8%
2021-11-11-14-46-33 923
 
9.2%

수집순번
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
2342 
2
2280 
3
2275 
0
2180 
4
923 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row1
3rd row1
4th row1
5th row3

Common Values

ValueCountFrequency (%)
1 2342
23.4%
2 2280
22.8%
3 2275
22.8%
0 2180
21.8%
4 923
 
9.2%

Length

2024-03-23T02:09:38.099508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T02:09:38.410260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 2342
23.4%
2 2280
22.8%
3 2275
22.8%
0 2180
21.8%
4 923
 
9.2%

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51316.523
Minimum785
Maximum104471
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T02:09:38.788669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum785
5-th percentile6013.7
Q126234.5
median51218.5
Q376320.75
95-th percentile97020.5
Maximum104471
Range103686
Interquartile range (IQR)50086.25

Descriptive statistics

Standard deviation29113.347
Coefficient of variation (CV)0.5673289
Kurtosis-1.1664418
Mean51316.523
Median Absolute Deviation (MAD)25019.5
Skewness0.029754335
Sum5.1316523 × 108
Variance8.4758695 × 108
MonotonicityNot monotonic
2024-03-23T02:09:39.224556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15620 1
 
< 0.1%
16909 1
 
< 0.1%
80432 1
 
< 0.1%
34424 1
 
< 0.1%
24013 1
 
< 0.1%
74775 1
 
< 0.1%
57824 1
 
< 0.1%
77807 1
 
< 0.1%
25961 1
 
< 0.1%
70634 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
785 1
< 0.1%
788 1
< 0.1%
792 1
< 0.1%
804 1
< 0.1%
833 1
< 0.1%
841 1
< 0.1%
845 1
< 0.1%
872 1
< 0.1%
889 1
< 0.1%
932 1
< 0.1%
ValueCountFrequency (%)
104471 1
< 0.1%
104463 1
< 0.1%
104444 1
< 0.1%
104425 1
< 0.1%
104401 1
< 0.1%
104386 1
< 0.1%
104380 1
< 0.1%
104376 1
< 0.1%
104374 1
< 0.1%
104370 1
< 0.1%

초수
Real number (ℝ)

HIGH CORRELATION 

Distinct2012
Distinct (%)20.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.6366088 × 109
Minimum1.6366078 × 109
Maximum1.6366098 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T02:09:39.653539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.6366078 × 109
5-th percentile1.6366079 × 109
Q11.6366083 × 109
median1.6366088 × 109
Q31.6366093 × 109
95-th percentile1.6366097 × 109
Maximum1.6366098 × 109
Range2074
Interquartile range (IQR)1002

Descriptive statistics

Standard deviation582.27557
Coefficient of variation (CV)3.5578177 × 10-7
Kurtosis-1.1664438
Mean1.6366088 × 109
Median Absolute Deviation (MAD)500
Skewness0.029734256
Sum1.6366088 × 1013
Variance339044.84
MonotonicityNot monotonic
2024-03-23T02:09:40.067930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1636609580 13
 
0.1%
1636608551 12
 
0.1%
1636607786 12
 
0.1%
1636609365 12
 
0.1%
1636609144 12
 
0.1%
1636609594 12
 
0.1%
1636608604 11
 
0.1%
1636607916 11
 
0.1%
1636609783 11
 
0.1%
1636609072 11
 
0.1%
Other values (2002) 9883
98.8%
ValueCountFrequency (%)
1636607768 3
 
< 0.1%
1636607769 4
< 0.1%
1636607770 2
 
< 0.1%
1636607771 2
 
< 0.1%
1636607772 2
 
< 0.1%
1636607773 5
0.1%
1636607774 4
< 0.1%
1636607775 8
0.1%
1636607776 7
0.1%
1636607777 7
0.1%
ValueCountFrequency (%)
1636609842 2
 
< 0.1%
1636609841 3
< 0.1%
1636609840 7
0.1%
1636609839 2
 
< 0.1%
1636609838 1
 
< 0.1%
1636609832 3
< 0.1%
1636609831 4
< 0.1%
1636609830 6
0.1%
1636609829 5
0.1%
1636609828 6
0.1%

나노초수
Real number (ℝ)

Distinct9998
Distinct (%)> 99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.0116434 × 108
Minimum5181
Maximum9.9975126 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T02:09:40.560012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5181
5-th percentile55167227
Q12.5311078 × 108
median4.9479623 × 108
Q37.5521924 × 108
95-th percentile9.5426928 × 108
Maximum9.9975126 × 108
Range9.9974608 × 108
Interquartile range (IQR)5.0210845 × 108

Descriptive statistics

Standard deviation2.9003194 × 108
Coefficient of variation (CV)0.57871623
Kurtosis-1.2248297
Mean5.0116434 × 108
Median Absolute Deviation (MAD)2.5877911 × 108
Skewness0.029625785
Sum5.0116434 × 1012
Variance8.4118527 × 1016
MonotonicityNot monotonic
2024-03-23T02:09:41.045693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
593378580 2
 
< 0.1%
173548062 2
 
< 0.1%
493812748 1
 
< 0.1%
275452897 1
 
< 0.1%
756614027 1
 
< 0.1%
573912945 1
 
< 0.1%
352707409 1
 
< 0.1%
614789341 1
 
< 0.1%
597177870 1
 
< 0.1%
256062884 1
 
< 0.1%
Other values (9988) 9988
99.9%
ValueCountFrequency (%)
5181 1
< 0.1%
535001 1
< 0.1%
12158701 1
< 0.1%
12242561 1
< 0.1%
12335632 1
< 0.1%
12359170 1
< 0.1%
12389367 1
< 0.1%
12416021 1
< 0.1%
12435427 1
< 0.1%
12440646 1
< 0.1%
ValueCountFrequency (%)
999751262 1
< 0.1%
999697545 1
< 0.1%
999396898 1
< 0.1%
999394304 1
< 0.1%
999141591 1
< 0.1%
998669639 1
< 0.1%
998658376 1
< 0.1%
998428536 1
< 0.1%
998209285 1
< 0.1%
998195423 1
< 0.1%

멈춤여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2024-03-23T02:09:41.406503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

기어수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
3
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3
2nd row3
3rd row3
4th row3
5th row3

Common Values

ValueCountFrequency (%)
3 10000
100.0%

Length

2024-03-23T02:09:41.773542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T02:09:42.035762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 10000
100.0%

속도
Real number (ℝ)

ZEROS 

Distinct2581
Distinct (%)25.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.872947
Minimum0
Maximum24.379999
Zeros3656
Zeros (%)36.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T02:09:42.380266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median15.790001
Q321.780001
95-th percentile23.081976
Maximum24.379999
Range24.379999
Interquartile range (IQR)21.780001

Descriptive statistics

Standard deviation10.005557
Coefficient of variation (CV)0.84271897
Kurtosis-1.7860757
Mean11.872947
Median Absolute Deviation (MAD)7.0299988
Skewness-0.19575059
Sum118729.47
Variance100.11118
MonotonicityNot monotonic
2024-03-23T02:09:42.850466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 3656
36.6%
11.656207084655762 91
 
0.9%
12.84206771850586 73
 
0.7%
3.837639331817627 58
 
0.6%
11.989962577819824 52
 
0.5%
3.1158223152160645 48
 
0.5%
0.1728082299232483 47
 
0.5%
22.799999237060547 43
 
0.4%
5.532433986663818 43
 
0.4%
22.81999969482422 43
 
0.4%
Other values (2571) 5846
58.5%
ValueCountFrequency (%)
0.0 3656
36.6%
0.0099999997764825 1
 
< 0.1%
0.0199999995529651 1
 
< 0.1%
0.0299999974668025 1
 
< 0.1%
0.0399999991059303 1
 
< 0.1%
0.0575678087770938 1
 
< 0.1%
0.081618383526802 1
 
< 0.1%
0.1151875331997871 1
 
< 0.1%
0.1264612674713134 1
 
< 0.1%
0.1264796704053878 1
 
< 0.1%
ValueCountFrequency (%)
24.3799991607666 1
 
< 0.1%
24.3715934753418 1
 
< 0.1%
24.3700008392334 1
 
< 0.1%
24.36000061035156 6
0.1%
24.350000381469727 4
< 0.1%
24.32999992370605 2
 
< 0.1%
24.26000022888184 5
0.1%
24.25 5
0.1%
24.239999771118164 5
0.1%
24.229999542236328 6
0.1%

휠각도등급값
Real number (ℝ)

SKEWED  ZEROS 

Distinct817
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.41896319
Minimum-4.8319507
Maximum177.69756
Zeros965
Zeros (%)9.7%
Negative3593
Negative (%)35.9%
Memory size166.0 KiB
2024-03-23T02:09:43.371079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-4.8319507
5-th percentile-0.63449854
Q1-0.01084613
median0.0054230648
Q30.31996077
95-th percentile1.7516499
Maximum177.69756
Range182.52951
Interquartile range (IQR)0.3308069

Descriptive statistics

Standard deviation3.8305146
Coefficient of variation (CV)9.1428429
Kurtosis1833.8815
Mean0.41896319
Median Absolute Deviation (MAD)0.070499841
Skewness39.890031
Sum4189.6319
Variance14.672842
MonotonicityNot monotonic
2024-03-23T02:09:43.810439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0054230648092925 1158
 
11.6%
0.0 965
 
9.7%
0.0162691939622163 688
 
6.9%
-0.0108461296185851 675
 
6.8%
-0.0054230648092925 502
 
5.0%
-0.0162691939622163 376
 
3.8%
-0.0271153226494789 199
 
2.0%
0.0271153226494789 99
 
1.0%
-0.0488075837492942 83
 
0.8%
0.5965370535850525 55
 
0.5%
Other values (807) 5200
52.0%
ValueCountFrequency (%)
-4.831950664520264 4
< 0.1%
-4.821104526519775 2
< 0.1%
-4.674681663513184 1
 
< 0.1%
-4.457758903503418 1
 
< 0.1%
-4.349297523498535 1
 
< 0.1%
-4.154067516326904 1
 
< 0.1%
-3.237569808959961 2
< 0.1%
-3.205031156539917 1
 
< 0.1%
-3.134531259536743 1
 
< 0.1%
-3.0694541931152344 2
< 0.1%
ValueCountFrequency (%)
177.6975555419922 4
< 0.1%
13.693238258361816 1
 
< 0.1%
13.687814712524414 1
 
< 0.1%
13.622737884521484 1
 
< 0.1%
13.259391784667969 1
 
< 0.1%
13.112970352172852 1
 
< 0.1%
13.058738708496094 1
 
< 0.1%
12.109703063964844 1
 
< 0.1%
11.654165267944336 1
 
< 0.1%
11.155244827270508 1
 
< 0.1%

Interactions

2024-03-23T02:09:34.887580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:28.793149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:30.309070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:31.683408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:33.471280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:35.168166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:29.060542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:30.565791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:31.967872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:33.734803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:35.434790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:29.338506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:30.847542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:32.261473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:33.993945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:35.746995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:29.725530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:31.113096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:32.528913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:34.279223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:36.028449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:30.009093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:31.406313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:32.959148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:09:34.570544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T02:09:44.089815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수집일시수집순번순번초수나노초수속도휠각도등급값
수집일시1.0001.0000.9950.9950.0000.4810.052
수집순번1.0001.0000.9950.9950.0000.4810.052
순번0.9950.9951.0001.0000.0000.6000.077
초수0.9950.9951.0001.0000.0000.6010.077
나노초수0.0000.0000.0000.0001.0000.0090.031
속도0.4810.4810.6000.6010.0091.0000.105
휠각도등급값0.0520.0520.0770.0770.0310.1051.000
2024-03-23T02:09:44.451517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수집일시수집순번
수집일시1.0001.000
수집순번1.0001.000
2024-03-23T02:09:44.676876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번초수나노초수속도휠각도등급값수집일시수집순번
순번1.0001.0000.005-0.0310.1010.8960.896
초수1.0001.0000.004-0.0310.1010.8950.895
나노초수0.0050.0041.000-0.0060.0120.0000.000
속도-0.031-0.031-0.0061.0000.1340.2200.220
휠각도등급값0.1010.1010.0120.1341.0000.0390.039
수집일시0.8960.8950.0000.2200.0391.0001.000
수집순번0.8960.8950.0000.2200.0391.0001.000

Missing values

2024-03-23T02:09:36.424792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T02:09:36.889054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

수집일시수집순번순번초수나노초수멈춤여부기어수속도휠각도등급값
237962021-11-11-14-16-080156201636608065493812748N30.0-0.016269
247732021-11-11-14-23-401280841636608314772228539N318.76-0.016269
353602021-11-11-14-23-401382611636608518335367870N321.080.401307
419502021-11-11-14-23-401458011636608669136844752N318.7199990.113884
726642021-11-11-14-38-543750271636609253655185193N312.8420680.764652
910872021-11-11-14-46-334957641636609668395585170N322.7800010.824306
223932021-11-11-14-16-080206571636608166234854957N323.680.048808
7702021-11-11-14-16-08014821636607782732771992N30.00.0
209012021-11-11-14-16-08021596163660818516380364N322.760.2115
442952021-11-11-14-23-401428531636608610174344931N30.00.0
수집일시수집순번순번초수나노초수멈춤여부기어수속도휠각도등급값
573572021-11-11-14-31-152596781636608946677516720N30.0-0.103038
288052021-11-11-14-23-401305261636608363613827842N30.00.005423
807492021-11-11-14-38-543872541636609498195254637N312.9985931.561843
897832021-11-11-14-46-33492147163660959660306678N320.0479530.732114
490292021-11-11-14-31-152551541636608856195975101N323.241632-0.005423
91572021-11-11-14-16-080128721636608010534835221N30.00.0
638382021-11-11-14-38-54369845163660915014115547N30.00.0
204682021-11-11-14-16-080148271636608049633449381N30.00.0
787752021-11-11-14-38-543726791636609206694158263N30.00.005423
906322021-11-11-14-46-334947031636609647177425352N320.5067710.634499