Overview

Dataset statistics

Number of variables18
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.7 KiB
Average record size in memory159.4 B

Variable types

DateTime3
Categorical12
Numeric2
Boolean1

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/717d9f1b-01dc-469f-a610-8f67b4a48968

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
가속도Y 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
가속도X is highly imbalanced (78.9%)Imbalance
운행_일시 has unique valuesUnique
속도 has 7 (23.3%) zerosZeros
방위각 has 7 (23.3%) zerosZeros

Reproduction

Analysis started2023-12-10 13:54:10.668348
Analysis finished2023-12-10 13:54:12.259244
Duration1.59 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

운행_일시
Date

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-01-01 04:32:41
Maximum2023-01-01 04:33:57
2023-12-10T22:54:12.424598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:12.735326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)

차량_번호
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
3bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a860
30 

Length

Max length64
Median length64
Mean length64
Min length64

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a860 30
100.0%

Length

2023-12-10T22:54:12.971868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:13.116999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a860 30
100.0%

노선_번호
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
7612
30 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
7612 30
100.0%

Length

2023-12-10T22:54:13.441827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:13.658744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
7612 30
100.0%

노선_유형
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
지선
30 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row지선
2nd row지선
3rd row지선
4th row지선
5th row지선

Common Values

ValueCountFrequency (%)
지선 30
100.0%

Length

2023-12-10T22:54:13.851206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:14.006700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
지선 30
100.0%

출차_시간
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-12-10 04:32:41
Maximum2023-12-10 04:32:41
2023-12-10T22:54:14.265927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:14.576496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

정류장_수
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
47
30 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
47 30
100.0%

Length

2023-12-10T22:54:14.840213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:15.029692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
47 30
100.0%

평균_정류장_간격
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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

Length

2023-12-10T22:54:15.218435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:15.447574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

소요_시간
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
71
30 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
71 30
100.0%

Length

2023-12-10T22:54:15.654782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:15.808686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
71 30
100.0%

주행_거리
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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

Length

2023-12-10T22:54:15.976305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:16.128875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

속도
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct15
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.033333
Minimum0
Maximum33
Zeros7
Zeros (%)23.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:54:16.267713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q13.75
median23
Q330.75
95-th percentile33
Maximum33
Range33
Interquartile range (IQR)27

Descriptive statistics

Standard deviation13.047614
Coefficient of variation (CV)0.72352758
Kurtosis-1.5838823
Mean18.033333
Median Absolute Deviation (MAD)10
Skewness-0.31647204
Sum541
Variance170.24023
MonotonicityNot monotonic
2023-12-10T22:54:16.436986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
0 7
23.3%
33 4
13.3%
27 3
10.0%
16 2
 
6.7%
25 2
 
6.7%
31 2
 
6.7%
32 2
 
6.7%
3 1
 
3.3%
6 1
 
3.3%
22 1
 
3.3%
Other values (5) 5
16.7%
ValueCountFrequency (%)
0 7
23.3%
3 1
 
3.3%
6 1
 
3.3%
10 1
 
3.3%
12 1
 
3.3%
13 1
 
3.3%
16 2
 
6.7%
22 1
 
3.3%
24 1
 
3.3%
25 2
 
6.7%
ValueCountFrequency (%)
33 4
13.3%
32 2
6.7%
31 2
6.7%
30 1
 
3.3%
27 3
10.0%
25 2
6.7%
24 1
 
3.3%
22 1
 
3.3%
16 2
6.7%
13 1
 
3.3%

브레이크_유무
Boolean

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size162.0 B
False
30 
ValueCountFrequency (%)
False 30
100.0%
2023-12-10T22:54:16.660134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

위도
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
37
30 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
37 30
100.0%

Length

2023-12-10T22:54:16.843611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:16.986702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
37 30
100.0%

경도
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
126
30 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
126 30
100.0%

Length

2023-12-10T22:54:17.139376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:17.296626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
126 30
100.0%

방위각
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct9
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean173.83333
Minimum0
Maximum240
Zeros7
Zeros (%)23.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:54:17.437280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1134.25
median235
Q3236
95-th percentile237
Maximum240
Range240
Interquartile range (IQR)101.75

Descriptive statistics

Standard deviation100.72122
Coefficient of variation (CV)0.57941259
Kurtosis-0.57586719
Mean173.83333
Median Absolute Deviation (MAD)1
Skewness-1.1558975
Sum5215
Variance10144.764
MonotonicityNot monotonic
2023-12-10T22:54:17.621578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
0 7
23.3%
236 7
23.3%
235 6
20.0%
234 3
10.0%
237 2
 
6.7%
233 2
 
6.7%
133 1
 
3.3%
138 1
 
3.3%
240 1
 
3.3%
ValueCountFrequency (%)
0 7
23.3%
133 1
 
3.3%
138 1
 
3.3%
233 2
 
6.7%
234 3
10.0%
235 6
20.0%
236 7
23.3%
237 2
 
6.7%
240 1
 
3.3%
ValueCountFrequency (%)
240 1
 
3.3%
237 2
 
6.7%
236 7
23.3%
235 6
20.0%
234 3
10.0%
233 2
 
6.7%
138 1
 
3.3%
133 1
 
3.3%
0 7
23.3%

가속도X
Categorical

IMBALANCE 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
29 
-1
 
1

Length

Max length2
Median length1
Mean length1.0333333
Min length1

Unique

Unique1 ?
Unique (%)3.3%

Sample

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

Common Values

ValueCountFrequency (%)
0 29
96.7%
-1 1
 
3.3%

Length

2023-12-10T22:54:17.834684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:18.018884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 29
96.7%
1 1
 
3.3%

가속도Y
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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

Length

2023-12-10T22:54:18.192539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:18.351639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2022-10-26 전기차 운행이력
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-10-26 전기차 운행이력
2nd row2022-10-26 전기차 운행이력
3rd row2022-10-26 전기차 운행이력
4th row2022-10-26 전기차 운행이력
5th row2022-10-26 전기차 운행이력

Common Values

ValueCountFrequency (%)
2022-10-26 전기차 운행이력 30
100.0%

Length

2023-12-10T22:54:18.593651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:54:18.760007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-10-26 30
33.3%
전기차 30
33.3%
운행이력 30
33.3%

생산_일시
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2022-10-26 14:15:24
Maximum2022-10-26 14:15:24
2023-12-10T22:54:18.883731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:19.051180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-10T22:54:11.280684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:11.033156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:11.447237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:11.152220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:54:19.163050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
운행_일시속도방위각가속도X
운행_일시1.0001.0001.0001.000
속도1.0001.0000.8460.422
방위각1.0000.8461.0000.000
가속도X1.0000.4220.0001.000
2023-12-10T22:54:19.308560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
속도방위각가속도X
속도1.0000.6920.267
방위각0.6921.0000.000
가속도X0.2670.0001.000

Missing values

2023-12-10T22:54:11.660825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:54:12.072049image/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

운행_일시차량_번호노선_번호노선_유형출차_시간정류장_수평균_정류장_간격소요_시간주행_거리속도브레이크_유무위도경도방위각가속도X가속도Y비고생산_일시
02023-01-01 04:32:413bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707100N371260002022-10-26 전기차 운행이력2022-10-26 14:15:24
12023-01-01 04:32:423bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707100N371260002022-10-26 전기차 운행이력2022-10-26 14:15:24
22023-01-01 04:32:433bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707100N371260002022-10-26 전기차 운행이력2022-10-26 14:15:24
32023-01-01 04:32:443bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707100N371260002022-10-26 전기차 운행이력2022-10-26 14:15:24
42023-01-01 04:32:463bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707100N371260002022-10-26 전기차 운행이력2022-10-26 14:15:24
52023-01-01 04:32:493bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707100N371260002022-10-26 전기차 운행이력2022-10-26 14:15:24
62023-01-01 04:32:503bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707100N371260002022-10-26 전기차 운행이력2022-10-26 14:15:24
72023-01-01 04:32:523bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707103N37126133002022-10-26 전기차 운행이력2022-10-26 14:15:24
82023-01-01 04:32:553bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:414707106N37126138002022-10-26 전기차 운행이력2022-10-26 14:15:24
92023-01-01 04:33:063bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071016N37126240002022-10-26 전기차 운행이력2022-10-26 14:15:24
운행_일시차량_번호노선_번호노선_유형출차_시간정류장_수평균_정류장_간격소요_시간주행_거리속도브레이크_유무위도경도방위각가속도X가속도Y비고생산_일시
202023-01-01 04:33:423bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071033N37126235002022-10-26 전기차 운행이력2022-10-26 14:15:24
212023-01-01 04:33:433bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071033N37126235002022-10-26 전기차 운행이력2022-10-26 14:15:24
222023-01-01 04:33:453bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071032N37126234002022-10-26 전기차 운행이력2022-10-26 14:15:24
232023-01-01 04:33:473bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071031N37126235002022-10-26 전기차 운행이력2022-10-26 14:15:24
242023-01-01 04:33:483bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071030N37126235002022-10-26 전기차 운행이력2022-10-26 14:15:24
252023-01-01 04:33:503bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071025N37126235-102022-10-26 전기차 운행이력2022-10-26 14:15:24
262023-01-01 04:33:533bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071016N37126234002022-10-26 전기차 운행이력2022-10-26 14:15:24
272023-01-01 04:33:543bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071013N37126233002022-10-26 전기차 운행이력2022-10-26 14:15:24
282023-01-01 04:33:553bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071012N37126233002022-10-26 전기차 운행이력2022-10-26 14:15:24
292023-01-01 04:33:573bf6556f8fe5486859c710c7c29a757b35adbdb9f6ddd2aef64286bd6994a8607612지선04:32:4147071010N37126237002022-10-26 전기차 운행이력2022-10-26 14:15:24