Overview

Dataset statistics

Number of variables11
Number of observations9581
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory851.6 KiB
Average record size in memory91.0 B

Variable types

Numeric3
DateTime5
Categorical2
Boolean1

Dataset

Description경상북도 구미시 교통정보센터 DB의 반복정체구간 정보로 정보제공구간ID, 통계년월, 혼잡시작시간, 종료시간등의 분석 데이터를 제공하고 있습니다.
Author경상북도 구미시
URLhttps://www.data.go.kr/data/15092235/fileData.do

Alerts

확정여부 has constant value ""Constant
반복정체구간원본코드 has constant value ""Constant
데이터기준일자 has constant value ""Constant

Reproduction

Analysis started2023-12-12 22:48:26.427817
Analysis finished2023-12-12 22:48:28.024072
Duration1.6 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

정보제공구간식별자
Real number (ℝ)

Distinct180
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.4121646 × 109
Minimum2.2 × 109
Maximum3.5554975 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size84.3 KiB
2023-12-13T07:48:28.082642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.2 × 109
5-th percentile2.2 × 109
Q13.5554655 × 109
median3.5554801 × 109
Q33.555488 × 109
95-th percentile3.5554955 × 109
Maximum3.5554975 × 109
Range1.3554975 × 109
Interquartile range (IQR)22500

Descriptive statistics

Standard deviation4.1682067 × 108
Coefficient of variation (CV)0.12215726
Kurtosis4.5792916
Mean3.4121646 × 109
Median Absolute Deviation (MAD)10500
Skewness-2.5648267
Sum3.2691949 × 1013
Variance1.7373947 × 1017
MonotonicityNot monotonic
2023-12-13T07:48:28.196703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3555443300 176
 
1.8%
3555479700 170
 
1.8%
3555494400 165
 
1.7%
3555443400 165
 
1.7%
3555485300 164
 
1.7%
3555481500 152
 
1.6%
3555490600 149
 
1.6%
3555484800 148
 
1.5%
3555482700 144
 
1.5%
3555494500 144
 
1.5%
Other values (170) 8004
83.5%
ValueCountFrequency (%)
2200000007 17
 
0.2%
2200000008 86
0.9%
2200000009 9
 
0.1%
2200000025 29
 
0.3%
2200000030 80
0.8%
2200000039 95
1.0%
2200000040 1
 
< 0.1%
2200000042 3
 
< 0.1%
2200000043 19
 
0.2%
2200000044 32
 
0.3%
ValueCountFrequency (%)
3555497500 128
1.3%
3555497300 2
 
< 0.1%
3555497100 24
 
0.3%
3555497000 74
0.8%
3555496700 1
 
< 0.1%
3555496500 30
 
0.3%
3555496400 31
 
0.3%
3555496200 9
 
0.1%
3555496100 6
 
0.1%
3555496000 93
1.0%

통계년월
Date

Distinct15
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size75.0 KiB
Minimum2016-05-01 00:00:00
Maximum2020-03-01 00:00:00
2023-12-13T07:48:28.303169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:28.387857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)

요일유형코드
Categorical

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size75.0 KiB
DTW5
1602 
DTW2
1449 
DTW3
1377 
DTW4
1376 
DTW6
1343 
Other values (2)
2434 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
DTW5 1602
16.7%
DTW2 1449
15.1%
DTW3 1377
14.4%
DTW4 1376
14.4%
DTW6 1343
14.0%
DTW1 1341
14.0%
DTW7 1093
11.4%

Length

2023-12-13T07:48:28.487576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:48:28.580354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
dtw5 1602
16.7%
dtw2 1449
15.1%
dtw3 1377
14.4%
dtw4 1376
14.4%
dtw6 1343
14.0%
dtw1 1341
14.0%
dtw7 1093
11.4%

혼잡시작시분
Date

Distinct184
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size75.0 KiB
Minimum2023-12-13 00:05:00
Maximum2023-12-13 23:25:00
2023-12-13T07:48:28.689850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:28.792505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

혼잡종료시분
Date

Distinct196
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size75.0 KiB
Minimum2023-12-13 00:35:00
Maximum2023-12-13 23:55:00
2023-12-13T07:48:28.897442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:29.009265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

평균속도
Real number (ℝ)

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.565077
Minimum4
Maximum20
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size84.3 KiB
2023-12-13T07:48:29.118821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile9
Q111
median13
Q314
95-th percentile18
Maximum20
Range16
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.5482131
Coefficient of variation (CV)0.20280123
Kurtosis1.2763184
Mean12.565077
Median Absolute Deviation (MAD)1
Skewness0.28058959
Sum120386
Variance6.4933898
MonotonicityNot monotonic
2023-12-13T07:48:29.221333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
13 2292
23.9%
14 1796
18.7%
12 1625
17.0%
11 933
9.7%
10 815
 
8.5%
9 579
 
6.0%
8 276
 
2.9%
19 224
 
2.3%
17 220
 
2.3%
18 190
 
2.0%
Other values (7) 631
 
6.6%
ValueCountFrequency (%)
4 56
 
0.6%
5 4
 
< 0.1%
6 26
 
0.3%
7 81
 
0.8%
8 276
 
2.9%
9 579
 
6.0%
10 815
 
8.5%
11 933
9.7%
12 1625
17.0%
13 2292
23.9%
ValueCountFrequency (%)
20 117
 
1.2%
19 224
 
2.3%
18 190
 
2.0%
17 220
 
2.3%
16 186
 
1.9%
15 161
 
1.7%
14 1796
18.7%
13 2292
23.9%
12 1625
17.0%
11 933
9.7%

평균통행시간
Real number (ℝ)

Distinct645
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean166.53658
Minimum22
Maximum1966
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size84.3 KiB
2023-12-13T07:48:29.343163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22
5-th percentile48
Q175
median115
Q3190
95-th percentile421
Maximum1966
Range1944
Interquartile range (IQR)115

Descriptive statistics

Standard deviation193.32074
Coefficient of variation (CV)1.1608305
Kurtosis37.31424
Mean166.53658
Median Absolute Deviation (MAD)47
Skewness5.3786589
Sum1595587
Variance37372.909
MonotonicityNot monotonic
2023-12-13T07:48:29.471347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
70 127
 
1.3%
107 107
 
1.1%
74 104
 
1.1%
75 93
 
1.0%
78 90
 
0.9%
69 87
 
0.9%
95 86
 
0.9%
77 86
 
0.9%
64 84
 
0.9%
63 82
 
0.9%
Other values (635) 8635
90.1%
ValueCountFrequency (%)
22 2
 
< 0.1%
24 1
 
< 0.1%
30 2
 
< 0.1%
31 2
 
< 0.1%
32 17
0.2%
33 21
0.2%
34 35
0.4%
35 30
0.3%
36 14
 
0.1%
37 14
 
0.1%
ValueCountFrequency (%)
1966 1
< 0.1%
1953 1
< 0.1%
1905 1
< 0.1%
1886 1
< 0.1%
1862 1
< 0.1%
1850 1
< 0.1%
1837 1
< 0.1%
1835 1
< 0.1%
1829 1
< 0.1%
1820 1
< 0.1%

확정여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size9.5 KiB
False
9581 
ValueCountFrequency (%)
False 9581
100.0%
2023-12-13T07:48:29.562539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

생성일자
Date

Distinct81
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size75.0 KiB
Minimum2016-05-27 00:00:00
Maximum2020-03-31 00:00:00
2023-12-13T07:48:29.660496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:29.789788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

반복정체구간원본코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size75.0 KiB
RCS1
9581 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
RCS1 9581
100.0%

Length

2023-12-13T07:48:29.949091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:48:30.040063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
rcs1 9581
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size75.0 KiB
Minimum2022-10-12 00:00:00
Maximum2022-10-12 00:00:00
2023-12-13T07:48:30.118055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:30.205760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T07:48:27.544251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.013358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.281655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.633590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.101049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.370019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.726121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.191790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:48:27.454280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:48:30.269812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정보제공구간식별자통계년월요일유형코드평균속도평균통행시간생성일자
정보제공구간식별자1.0000.2720.0330.3210.4160.325
통계년월0.2721.0000.1020.6380.4361.000
요일유형코드0.0330.1021.0000.1720.1331.000
평균속도0.3210.6380.1721.0000.6750.763
평균통행시간0.4160.4360.1330.6751.0000.635
생성일자0.3251.0001.0000.7630.6351.000
2023-12-13T07:48:30.364454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정보제공구간식별자평균속도평균통행시간요일유형코드
정보제공구간식별자1.000-0.231-0.0820.038
평균속도-0.2311.000-0.1930.088
평균통행시간-0.082-0.1931.0000.067
요일유형코드0.0380.0880.0671.000

Missing values

2023-12-13T07:48:27.839922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:48:27.966384image/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

정보제공구간식별자통계년월요일유형코드혼잡시작시분혼잡종료시분평균속도평균통행시간확정여부생성일자반복정체구간원본코드데이터기준일자
035554907002016-07DTW600:4502:4013204N2016-07-31RCS12022-10-12
135554907002016-07DTW606:0523:5513219N2016-07-31RCS12022-10-12
235554914002016-07DTW613:2016:008334N2016-07-31RCS12022-10-12
335554916002016-07DTW600:0500:406238N2016-07-31RCS12022-10-12
435554917002016-07DTW611:4513:009163N2016-07-31RCS12022-10-12
535554917002016-07DTW623:2023:559166N2016-07-31RCS12022-10-12
635554918002016-07DTW601:2002:401065N2016-07-31RCS12022-10-12
735554433002016-07DTW708:3010:201859N2016-07-25RCS12022-10-12
835554433002016-07DTW713:2518:151860N2016-07-25RCS12022-10-12
935554433002016-07DTW720:2521:201860N2016-07-25RCS12022-10-12
정보제공구간식별자통계년월요일유형코드혼잡시작시분혼잡종료시분평균속도평균통행시간확정여부생성일자반복정체구간원본코드데이터기준일자
957135554797002016-11DTW108:2513:5513133N2016-11-29RCS12022-10-12
957235554797002016-11DTW114:2016:2012152N2016-11-29RCS12022-10-12
957335554797002016-11DTW117:2523:5513140N2016-11-29RCS12022-10-12
957435554799002016-11DTW118:2519:2014107N2016-11-29RCS12022-10-12
957535554799002016-11DTW121:2022:2012121N2016-11-29RCS12022-10-12
957635554800002016-11DTW106:2523:101377N2016-11-29RCS12022-10-12
957735554801002016-11DTW112:2515:201375N2016-11-29RCS12022-10-12
957835554801002016-11DTW116:2020:201374N2016-11-29RCS12022-10-12
957935554802002016-11DTW106:2523:101354N2016-11-29RCS12022-10-12
958035554951002020-03DTW108:4009:107995N2020-03-31RCS12022-10-12