Overview

Dataset statistics

Number of variables19
Number of observations3000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory486.5 KiB
Average record size in memory166.0 B

Variable types

DateTime1
Categorical11
Numeric3
Boolean4

Dataset

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

Alerts

수집일시 has constant value ""Constant
수집순번 has constant value ""Constant
멈춤여부 has constant value ""Constant
기어수 has constant value ""Constant
속도 has constant value ""Constant
목표기어수 has constant value ""Constant
목표속도 has constant value ""Constant
목표한계속도 has constant value ""Constant
목표휠각도등급값 has constant value ""Constant
자동화상태 has constant value ""Constant
조종상태 has constant value ""Constant
속도상태 has constant value ""Constant
시작멈춤여부 has constant value ""Constant
좌회전요청여부 has constant value ""Constant
우회전요청여부 has constant value ""Constant
순번 is highly overall correlated with 초수High correlation
초수 is highly overall correlated with 순번High correlation
휠각도등급값 is highly imbalanced (62.9%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2024-03-23 02:25:59.889201
Analysis finished2024-03-23 02:26:04.231919
Duration4.34 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

수집일시
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
Minimum2021-11-11 14:00:00-08:00
Maximum2021-11-11 14:00:00-08:00
2024-03-23T02:26:04.390319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:04.743132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

수집순번
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:05.517809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct3000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23372.5
Minimum21873
Maximum24872
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size26.5 KiB
2024-03-23T02:26:05.925511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum21873
5-th percentile22022.95
Q122622.75
median23372.5
Q324122.25
95-th percentile24722.05
Maximum24872
Range2999
Interquartile range (IQR)1499.5

Descriptive statistics

Standard deviation866.16973
Coefficient of variation (CV)0.037059353
Kurtosis-1.2
Mean23372.5
Median Absolute Deviation (MAD)750
Skewness0
Sum70117500
Variance750250
MonotonicityNot monotonic
2024-03-23T02:26:06.523530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
22203 1
 
< 0.1%
24352 1
 
< 0.1%
24343 1
 
< 0.1%
24344 1
 
< 0.1%
24345 1
 
< 0.1%
24346 1
 
< 0.1%
24347 1
 
< 0.1%
24348 1
 
< 0.1%
24349 1
 
< 0.1%
24350 1
 
< 0.1%
Other values (2990) 2990
99.7%
ValueCountFrequency (%)
21873 1
< 0.1%
21874 1
< 0.1%
21875 1
< 0.1%
21876 1
< 0.1%
21877 1
< 0.1%
21878 1
< 0.1%
21879 1
< 0.1%
21880 1
< 0.1%
21881 1
< 0.1%
21882 1
< 0.1%
ValueCountFrequency (%)
24872 1
< 0.1%
24871 1
< 0.1%
24870 1
< 0.1%
24869 1
< 0.1%
24868 1
< 0.1%
24867 1
< 0.1%
24866 1
< 0.1%
24865 1
< 0.1%
24864 1
< 0.1%
24863 1
< 0.1%

초수
Real number (ℝ)

HIGH CORRELATION 

Distinct61
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.6366078 × 109
Minimum1.6366078 × 109
Maximum1.6366078 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size26.5 KiB
2024-03-23T02:26:06.931845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.6366078 × 109
5-th percentile1.6366078 × 109
Q11.6366078 × 109
median1.6366078 × 109
Q31.6366078 × 109
95-th percentile1.6366078 × 109
Maximum1.6366078 × 109
Range60
Interquartile range (IQR)30

Descriptive statistics

Standard deviation17.328195
Coefficient of variation (CV)1.0587873 × 10-8
Kurtosis-1.1986698
Mean1.6366078 × 109
Median Absolute Deviation (MAD)15
Skewness-1.9174816 × 10-6
Sum4.9098234 × 1012
Variance300.26636
MonotonicityNot monotonic
2024-03-23T02:26:07.344866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1636607775 50
 
1.7%
1636607807 50
 
1.7%
1636607800 50
 
1.7%
1636607789 50
 
1.7%
1636607790 50
 
1.7%
1636607799 50
 
1.7%
1636607803 50
 
1.7%
1636607804 50
 
1.7%
1636607801 50
 
1.7%
1636607802 50
 
1.7%
Other values (51) 2500
83.3%
ValueCountFrequency (%)
1636607768 24
0.8%
1636607769 50
1.7%
1636607770 50
1.7%
1636607771 50
1.7%
1636607772 50
1.7%
1636607773 50
1.7%
1636607774 50
1.7%
1636607775 50
1.7%
1636607776 50
1.7%
1636607777 50
1.7%
ValueCountFrequency (%)
1636607828 26
0.9%
1636607827 50
1.7%
1636607826 50
1.7%
1636607825 50
1.7%
1636607824 50
1.7%
1636607823 50
1.7%
1636607822 50
1.7%
1636607821 50
1.7%
1636607820 50
1.7%
1636607819 50
1.7%

나노초수
Real number (ℝ)

Distinct2998
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.0075648 × 108
Minimum843426
Maximum9.9279087 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size26.5 KiB
2024-03-23T02:26:07.795747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum843426
5-th percentile50810694
Q12.5081472 × 108
median4.9808712 × 108
Q37.5081057 × 108
95-th percentile9.5081312 × 108
Maximum9.9279087 × 108
Range9.9194744 × 108
Interquartile range (IQR)4.9999585 × 108

Descriptive statistics

Standard deviation2.8867267 × 108
Coefficient of variation (CV)0.57647317
Kurtosis-1.2009109
Mean5.0075648 × 108
Median Absolute Deviation (MAD)2.499856 × 108
Skewness-9.9652725 × 10-5
Sum1.5022694 × 1012
Variance8.3331912 × 1016
MonotonicityNot monotonic
2024-03-23T02:26:08.386918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
130804894 2
 
0.1%
750807785 2
 
0.1%
130846512 1
 
< 0.1%
170845961 1
 
< 0.1%
990807775 1
 
< 0.1%
10807037 1
 
< 0.1%
30806315 1
 
< 0.1%
50837927 1
 
< 0.1%
70818274 1
 
< 0.1%
90812403 1
 
< 0.1%
Other values (2988) 2988
99.6%
ValueCountFrequency (%)
843426 1
< 0.1%
10760888 1
< 0.1%
10802283 1
< 0.1%
10802658 1
< 0.1%
10803524 1
< 0.1%
10803545 1
< 0.1%
10803990 1
< 0.1%
10804859 1
< 0.1%
10804890 1
< 0.1%
10805111 1
< 0.1%
ValueCountFrequency (%)
992790866 1
< 0.1%
990945413 1
< 0.1%
990931249 1
< 0.1%
990873214 1
< 0.1%
990869197 1
< 0.1%
990859658 1
< 0.1%
990859087 1
< 0.1%
990841855 1
< 0.1%
990840583 1
< 0.1%
990834294 1
< 0.1%

멈춤여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
False
3000 
ValueCountFrequency (%)
False 3000
100.0%
2024-03-23T02:26:08.727704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

기어수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
3
3000 

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 3000
100.0%

Length

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

Common Values (Plot)

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

속도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:10.147178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

휠각도등급값
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0.0
2437 
0.0054230648092925
425 
-0.0054230648092925
 
132
-0.0108461296185851
 
5
0.0162691939622163
 
1

Length

Max length19
Median length3
Mean length5.8606667
Min length3

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row0.0
2nd row-0.0054230648092925
3rd row0.0
4th row0.0
5th row0.0

Common Values

ValueCountFrequency (%)
0.0 2437
81.2%
0.0054230648092925 425
 
14.2%
-0.0054230648092925 132
 
4.4%
-0.0108461296185851 5
 
0.2%
0.0162691939622163 1
 
< 0.1%

Length

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

Common Values (Plot)

2024-03-23T02:26:10.935847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0.0 2437
81.2%
0.0054230648092925 557
 
18.6%
0.0108461296185851 5
 
0.2%
0.0162691939622163 1
 
< 0.1%

목표기어수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
3
3000 

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 3000
100.0%

Length

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

Common Values (Plot)

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

목표속도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:12.204061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

목표한계속도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:12.854496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

목표휠각도등급값
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:13.438611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

자동화상태
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:14.108360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

조종상태
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:14.812844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

속도상태
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
0
3000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3000
100.0%

Length

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

Common Values (Plot)

2024-03-23T02:26:15.794433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3000
100.0%

시작멈춤여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
True
3000 
ValueCountFrequency (%)
True 3000
100.0%
2024-03-23T02:26:16.102932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

좌회전요청여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
True
3000 
ValueCountFrequency (%)
True 3000
100.0%
2024-03-23T02:26:16.519403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

우회전요청여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
True
3000 
ValueCountFrequency (%)
True 3000
100.0%
2024-03-23T02:26:16.994777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Interactions

2024-03-23T02:26:02.284154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:00.463984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:01.379879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:02.546304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:00.744244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:01.668152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:02.802623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:01.069193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T02:26:01.988897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T02:26:17.303756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번초수나노초수휠각도등급값
순번1.0000.9980.0000.376
초수0.9981.0000.0000.400
나노초수0.0000.0001.0000.080
휠각도등급값0.3760.4000.0801.000
2024-03-23T02:26:17.703159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번초수나노초수휠각도등급값
순번1.0001.000-0.0030.165
초수1.0001.000-0.0190.177
나노초수-0.003-0.0191.0000.033
휠각도등급값0.1650.1770.0331.000

Missing values

2024-03-23T02:26:03.238445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T02:26:03.968177image/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

수집일시수집순번순번초수나노초수멈춤여부기어수속도휠각도등급값목표기어수목표속도목표한계속도목표휠각도등급값자동화상태조종상태속도상태시작멈춤여부좌회전요청여부우회전요청여부
02021-11-11-14-16-080222031636607775130846512N300.03000000YYY
12021-11-11-14-16-080222041636607775150815739N30-0.0054233000000YYY
22021-11-11-14-16-080222051636607775170847433N300.03000000YYY
32021-11-11-14-16-080222061636607775190890568N300.03000000YYY
42021-11-11-14-16-080222071636607775210803532N300.03000000YYY
52021-11-11-14-16-080222081636607775230803988N300.03000000YYY
62021-11-11-14-16-080222091636607775250847371N300.03000000YYY
72021-11-11-14-16-080222101636607775270804370N300.03000000YYY
82021-11-11-14-16-080222111636607775290812173N300.03000000YYY
92021-11-11-14-16-080222121636607775310807324N30-0.0108463000000YYY
수집일시수집순번순번초수나노초수멈춤여부기어수속도휠각도등급값목표기어수목표속도목표한계속도목표휠각도등급값자동화상태조종상태속도상태시작멈춤여부좌회전요청여부우회전요청여부
29902021-11-11-14-16-080247051636607825170826125N300.03000000YYY
29912021-11-11-14-16-080247061636607825190807573N300.03000000YYY
29922021-11-11-14-16-080247071636607825210812172N300.03000000YYY
29932021-11-11-14-16-080244231636607819530809376N300.03000000YYY
29942021-11-11-14-16-080244241636607819550803249N300.03000000YYY
29952021-11-11-14-16-080244251636607819570835610N300.03000000YYY
29962021-11-11-14-16-080244261636607819590807132N300.03000000YYY
29972021-11-11-14-16-080244271636607819610817984N300.03000000YYY
29982021-11-11-14-16-080244281636607819631131835N300.0054233000000YYY
29992021-11-11-14-16-080244291636607819650821383N300.03000000YYY