Overview

Dataset statistics

Number of variables17
Number of observations607
Missing cells1741
Missing cells (%)16.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory86.1 KiB
Average record size in memory145.2 B

Variable types

Categorical8
Text1
Numeric5
Boolean1
Unsupported2

Dataset

Description일방통행 도로 현황(제공표준)
Author경기도
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=86R1OC1U69YW9534ZHYY26938327&infSeq=1

Alerts

시도명 has constant value ""Constant
도로차로수 is highly overall correlated with 도로안내표지일련번호High correlation
시군구명 is highly overall correlated with 지정연도 and 8 other fieldsHigh correlation
지정사유 is highly overall correlated with 지정연도 and 9 other fieldsHigh correlation
데이터기준일자 is highly overall correlated with 지정연도 and 8 other fieldsHigh correlation
도로안내표지일련번호 is highly overall correlated with 도로폭 and 10 other fieldsHigh correlation
보차분리여부 is highly overall correlated with 도로폭 and 6 other fieldsHigh correlation
관리기관명 is highly overall correlated with 시작점위도 and 7 other fieldsHigh correlation
관리기관전화번호 is highly overall correlated with 시작점위도 and 7 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 도로안내표지일련번호High correlation
시작점위도 is highly overall correlated with 종료점위도 and 6 other fieldsHigh correlation
종료점위도 is highly overall correlated with 시작점위도 and 6 other fieldsHigh correlation
지정사유 is highly imbalanced (63.0%)Imbalance
도로차로수 is highly imbalanced (85.9%)Imbalance
도로안내표지일련번호 is highly imbalanced (97.8%)Imbalance
지정연도 has 527 (86.8%) missing valuesMissing
시작점경도 has 607 (100.0%) missing valuesMissing
종료점경도 has 607 (100.0%) missing valuesMissing
시작점경도 is an unsupported type, check if it needs cleaning or further analysisUnsupported
종료점경도 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-05-17 19:13:25.551403
Analysis finished2024-05-17 19:13:35.064871
Duration9.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
경기도
607 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도
2nd row경기도
3rd row경기도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
경기도 607
100.0%

Length

2024-05-18T04:13:35.244412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T04:13:35.588446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 607
100.0%

시군구명
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
안양시
222 
안산시
115 
수원시
77 
의정부시
48 
오산시
25 
Other values (11)
120 

Length

Max length8
Median length3
Mean length3.1894563
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 양평군청
2nd row경기도 양평군청
3rd row경기도 양평군청
4th row경기도 양평군청
5th row경기도 양평군청

Common Values

ValueCountFrequency (%)
안양시 222
36.6%
안산시 115
18.9%
수원시 77
 
12.7%
의정부시 48
 
7.9%
오산시 25
 
4.1%
이천시 24
 
4.0%
하남시 19
 
3.1%
동두천시 17
 
2.8%
파주시 11
 
1.8%
경기도 양평군청 10
 
1.6%
Other values (6) 39
 
6.4%

Length

2024-05-18T04:13:35.958251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
안양시 222
36.0%
안산시 115
18.6%
수원시 77
 
12.5%
의정부시 48
 
7.8%
오산시 25
 
4.1%
이천시 24
 
3.9%
하남시 19
 
3.1%
동두천시 17
 
2.8%
파주시 11
 
1.8%
경기도 10
 
1.6%
Other values (7) 49
 
7.9%

도로명
Text

Distinct468
Distinct (%)77.1%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
2024-05-18T04:13:36.550099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length17
Mean length7.214168
Min length3

Characters and Unicode

Total characters4379
Distinct characters183
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique382 ?
Unique (%)62.9%

Sample

1st row양평시장길
2nd row양평시장길17번길
3rd row다문중앙2길
4th row시민로39번길
5th row관문길8번길
ValueCountFrequency (%)
10
 
1.4%
146번길 9
 
1.3%
동수원로 9
 
1.3%
이화3길 8
 
1.1%
일동로 7
 
1.0%
수원천로 6
 
0.8%
관산2길 5
 
0.7%
안양로384번길 5
 
0.7%
관악대로263번길 5
 
0.7%
매여울로40번길 5
 
0.7%
Other values (513) 639
90.3%
2024-05-18T04:13:37.701993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
로 514
 
11.7%
길 510
 
11.6%
번 388
 
8.9%
1 228
 
5.2%
3 168
 
3.8%
2 165
 
3.8%
4 144
 
3.3%
5 133
 
3.0%
8 114
 
2.6%
101
 
2.3%
Other values (173) 1914
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2935
67.0%
Decimal Number 1295
29.6%
Space Separator 101
 
2.3%
Math Symbol 24
 
0.5%
Dash Punctuation 20
 
0.5%
Close Punctuation 2
 
< 0.1%
Open Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 514
17.5%
길 510
17.4%
번 388
 
13.2%
대 74
 
2.5%
안 65
 
2.2%
양 60
 
2.0%
수 56
 
1.9%
관 53
 
1.8%
동 50
 
1.7%
원 49
 
1.7%
Other values (158) 1116
38.0%
Decimal Number
ValueCountFrequency (%)
1 228
17.6%
3 168
13.0%
2 165
12.7%
4 144
11.1%
5 133
10.3%
8 114
8.8%
6 98
7.6%
7 87
 
6.7%
0 81
 
6.3%
9 77
 
5.9%
Space Separator
ValueCountFrequency (%)
101
100.0%
Math Symbol
ValueCountFrequency (%)
~ 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2935
67.0%
Common 1444
33.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 514
17.5%
길 510
17.4%
번 388
 
13.2%
대 74
 
2.5%
안 65
 
2.2%
양 60
 
2.0%
수 56
 
1.9%
관 53
 
1.8%
동 50
 
1.7%
원 49
 
1.7%
Other values (158) 1116
38.0%
Common
ValueCountFrequency (%)
1 228
15.8%
3 168
11.6%
2 165
11.4%
4 144
10.0%
5 133
9.2%
8 114
7.9%
101
7.0%
6 98
6.8%
7 87
 
6.0%
0 81
 
5.6%
Other values (5) 125
8.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2935
67.0%
ASCII 1444
33.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
로 514
17.5%
길 510
17.4%
번 388
 
13.2%
대 74
 
2.5%
안 65
 
2.2%
양 60
 
2.0%
수 56
 
1.9%
관 53
 
1.8%
동 50
 
1.7%
원 49
 
1.7%
Other values (158) 1116
38.0%
ASCII
ValueCountFrequency (%)
1 228
15.8%
3 168
11.6%
2 165
11.4%
4 144
10.0%
5 133
9.2%
8 114
7.9%
101
7.0%
6 98
6.8%
7 87
 
6.0%
0 81
 
5.6%
Other values (5) 125
8.7%

지정사유
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct7
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
<NA>
500 
통행원활
 
48
주민건의
 
24
원활한 교통흐름 및 보행 안전
 
17
주민편의
 
10
Other values (2)
 
8

Length

Max length16
Median length4
Mean length4.3492586
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주민편의
2nd row주민편의
3rd row주민편의
4th row주민편의
5th row주민편의

Common Values

ValueCountFrequency (%)
<NA> 500
82.4%
통행원활 48
 
7.9%
주민건의 24
 
4.0%
원활한 교통흐름 및 보행 안전 17
 
2.8%
주민편의 10
 
1.6%
보행안전 6
 
1.0%
원활한 교통통행 2
 
0.3%

Length

2024-05-18T04:13:38.415765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T04:13:38.766538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 500
73.9%
통행원활 48
 
7.1%
주민건의 24
 
3.5%
원활한 19
 
2.8%
교통흐름 17
 
2.5%
및 17
 
2.5%
보행 17
 
2.5%
안전 17
 
2.5%
주민편의 10
 
1.5%
보행안전 6
 
0.9%

지정연도
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct19
Distinct (%)23.8%
Missing527
Missing (%)86.8%
Infinite0
Infinite (%)0.0%
Mean2013.0125
Minimum1998
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.5 KiB
2024-05-18T04:13:39.221331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1998
5-th percentile2000
Q12010
median2015
Q32017
95-th percentile2021
Maximum2022
Range24
Interquartile range (IQR)7

Descriptive statistics

Standard deviation5.8989245
Coefficient of variation (CV)0.0029303964
Kurtosis0.34354448
Mean2013.0125
Median Absolute Deviation (MAD)3
Skewness-0.96656809
Sum161041
Variance34.79731
MonotonicityNot monotonic
2024-05-18T04:13:39.665638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
2017 12
 
2.0%
2016 11
 
1.8%
2013 9
 
1.5%
2000 5
 
0.8%
2012 5
 
0.8%
2019 4
 
0.7%
2010 4
 
0.7%
2009 4
 
0.7%
2021 4
 
0.7%
2005 4
 
0.7%
Other values (9) 18
 
3.0%
(Missing) 527
86.8%
ValueCountFrequency (%)
1998 2
 
0.3%
2000 5
0.8%
2005 4
0.7%
2006 2
 
0.3%
2008 1
 
0.2%
2009 4
0.7%
2010 4
0.7%
2011 2
 
0.3%
2012 5
0.8%
2013 9
1.5%
ValueCountFrequency (%)
2022 1
 
0.2%
2021 4
 
0.7%
2020 2
 
0.3%
2019 4
 
0.7%
2018 3
 
0.5%
2017 12
2.0%
2016 11
1.8%
2015 4
 
0.7%
2014 1
 
0.2%
2013 9
1.5%

도로폭
Real number (ℝ)

HIGH CORRELATION 

Distinct23
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.1258649
Minimum2
Maximum15
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.5 KiB
2024-05-18T04:13:40.140117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile3
Q13
median5
Q36
95-th percentile9
Maximum15
Range13
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.241082
Coefficient of variation (CV)0.43721052
Kurtosis1.0963799
Mean5.1258649
Median Absolute Deviation (MAD)2
Skewness0.98551137
Sum3111.4
Variance5.0224487
MonotonicityNot monotonic
2024-05-18T04:13:40.773953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
3.0 243
40.0%
6.0 168
27.7%
8.0 70
 
11.5%
5.0 34
 
5.6%
4.0 34
 
5.6%
10.0 15
 
2.5%
7.0 10
 
1.6%
9.0 6
 
1.0%
12.0 5
 
0.8%
3.5 4
 
0.7%
Other values (13) 18
 
3.0%
ValueCountFrequency (%)
2.0 1
 
0.2%
3.0 243
40.0%
3.5 4
 
0.7%
4.0 34
 
5.6%
5.0 34
 
5.6%
5.5 2
 
0.3%
6.0 168
27.7%
6.3 1
 
0.2%
6.5 1
 
0.2%
7.0 10
 
1.6%
ValueCountFrequency (%)
15.0 2
 
0.3%
14.6 1
 
0.2%
12.0 5
 
0.8%
11.0 2
 
0.3%
10.0 15
2.5%
9.8 1
 
0.2%
9.7 2
 
0.3%
9.0 6
 
1.0%
8.5 1
 
0.2%
8.2 1
 
0.2%

도로연장
Real number (ℝ)

HIGH CORRELATION 

Distinct181
Distinct (%)29.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean212.43921
Minimum25
Maximum1110
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.5 KiB
2024-05-18T04:13:41.302979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum25
5-th percentile56.5
Q1100
median160
Q3260
95-th percentile500
Maximum1110
Range1085
Interquartile range (IQR)160

Descriptive statistics

Standard deviation170.17446
Coefficient of variation (CV)0.80105013
Kurtosis7.008395
Mean212.43921
Median Absolute Deviation (MAD)70
Skewness2.2992901
Sum128950.6
Variance28959.345
MonotonicityNot monotonic
2024-05-18T04:13:41.823224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100.0 30
 
4.9%
200.0 20
 
3.3%
120.0 20
 
3.3%
110.0 20
 
3.3%
130.0 17
 
2.8%
90.0 16
 
2.6%
80.0 16
 
2.6%
85.0 15
 
2.5%
105.0 14
 
2.3%
150.0 14
 
2.3%
Other values (171) 425
70.0%
ValueCountFrequency (%)
25.0 1
 
0.2%
26.0 1
 
0.2%
30.0 4
0.7%
31.0 1
 
0.2%
35.0 2
 
0.3%
40.0 9
1.5%
45.0 3
 
0.5%
50.0 6
1.0%
53.0 1
 
0.2%
54.0 1
 
0.2%
ValueCountFrequency (%)
1110.0 1
0.2%
1100.0 1
0.2%
1080.0 1
0.2%
1030.0 1
0.2%
1000.0 2
0.3%
970.0 1
0.2%
960.0 1
0.2%
842.6 1
0.2%
805.0 1
0.2%
790.0 1
0.2%

도로차로수
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
1
581 
2
 
23
3
 
2
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.2%

Sample

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

Common Values

ValueCountFrequency (%)
1 581
95.7%
2 23
 
3.8%
3 2
 
0.3%
4 1
 
0.2%

Length

2024-05-18T04:13:42.184058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T04:13:42.447551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 581
95.7%
2 23
 
3.8%
3 2
 
0.3%
4 1
 
0.2%

보차분리여부
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size739.0 B
False
489 
True
118 
ValueCountFrequency (%)
False 489
80.6%
True 118
 
19.4%
2024-05-18T04:13:42.677727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

시작점위도
Real number (ℝ)

HIGH CORRELATION 

Distinct602
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.99391
Minimum126.71013
Maximum127.78031
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.5 KiB
2024-05-18T04:13:42.991261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.71013
5-th percentile126.80721
Q1126.91197
median126.9548
Q3127.04632
95-th percentile127.44418
Maximum127.78031
Range1.0701822
Interquartile range (IQR)0.1343427

Descriptive statistics

Standard deviation0.1679375
Coefficient of variation (CV)0.0013224059
Kurtosis4.6718592
Mean126.99391
Median Absolute Deviation (MAD)0.0818891
Skewness1.9944432
Sum77085.301
Variance0.028203003
MonotonicityNot monotonic
2024-05-18T04:13:43.444780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.496111 2
 
0.3%
127.019511 2
 
0.3%
126.918976 2
 
0.3%
127.0518501 2
 
0.3%
127.039384 2
 
0.3%
127.489511 1
 
0.2%
126.912139 1
 
0.2%
126.918715 1
 
0.2%
126.9167 1
 
0.2%
126.91705 1
 
0.2%
Other values (592) 592
97.5%
ValueCountFrequency (%)
126.7101288 1
0.2%
126.750835 1
0.2%
126.7521707 1
0.2%
126.7624734 1
0.2%
126.7715634 1
0.2%
126.7745628 1
0.2%
126.778569 1
0.2%
126.783493 1
0.2%
126.788531 1
0.2%
126.790182 1
0.2%
ValueCountFrequency (%)
127.780311 1
0.2%
127.752222 1
0.2%
127.636047 1
0.2%
127.635508 1
0.2%
127.635252 1
0.2%
127.635124 1
0.2%
127.634943 1
0.2%
127.634825 1
0.2%
127.592111 1
0.2%
127.5551627 1
0.2%

시작점경도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing607
Missing (%)100.0%
Memory size5.5 KiB

종료점위도
Real number (ℝ)

HIGH CORRELATION 

Distinct597
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.9941
Minimum126.71017
Maximum127.77781
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.5 KiB
2024-05-18T04:13:43.848070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.71017
5-th percentile126.81028
Q1126.91141
median126.95506
Q3127.04617
95-th percentile127.44394
Maximum127.77781
Range1.0676441
Interquartile range (IQR)0.1347566

Descriptive statistics

Standard deviation0.16789576
Coefficient of variation (CV)0.0013220753
Kurtosis4.6671038
Mean126.9941
Median Absolute Deviation (MAD)0.081538
Skewness1.993963
Sum77085.417
Variance0.028188986
MonotonicityNot monotonic
2024-05-18T04:13:44.506601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.018384 2
 
0.3%
127.036601 2
 
0.3%
127.017128 2
 
0.3%
127.0481571 2
 
0.3%
127.0411214 2
 
0.3%
126.95329 2
 
0.3%
127.015689 2
 
0.3%
127.0477195 2
 
0.3%
127.492411 2
 
0.3%
127.4459363 2
 
0.3%
Other values (587) 587
96.7%
ValueCountFrequency (%)
126.7101669 1
0.2%
126.7503649 1
0.2%
126.7530555 1
0.2%
126.7624694 1
0.2%
126.7745554 1
0.2%
126.7766301 1
0.2%
126.7788155 1
0.2%
126.7850494 1
0.2%
126.788531 1
0.2%
126.789456 1
0.2%
ValueCountFrequency (%)
127.777811 1
0.2%
127.751511 1
0.2%
127.636631 1
0.2%
127.636331 1
0.2%
127.6361801 1
0.2%
127.635637 1
0.2%
127.635037 1
0.2%
127.633221 1
0.2%
127.593811 1
0.2%
127.5584515 1
0.2%

종료점경도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing607
Missing (%)100.0%
Memory size5.5 KiB

도로안내표지일련번호
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
<NA>
605 
2
 
1
1
 
1

Length

Max length4
Median length4
Mean length3.9901153
Min length1

Unique

Unique2 ?
Unique (%)0.3%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 605
99.7%
2 1
 
0.2%
1 1
 
0.2%

Length

2024-05-18T04:13:44.958958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T04:13:45.283245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 605
99.7%
2 1
 
0.2%
1 1
 
0.2%

관리기관명
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
경기도 안양시청
222 
안산시 단원구 도로교통과
65 
안산시 상록구 도로교통과
50 
경기도 의정부시청
48 
경기도 수원시 영통구청
35 
Other values (15)
187 

Length

Max length18
Median length17
Mean length10.026359
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 양평군청
2nd row경기도 양평군청
3rd row경기도 양평군청
4th row경기도 양평군청
5th row경기도 양평군청

Common Values

ValueCountFrequency (%)
경기도 안양시청 222
36.6%
안산시 단원구 도로교통과 65
 
10.7%
안산시 상록구 도로교통과 50
 
8.2%
경기도 의정부시청 48
 
7.9%
경기도 수원시 영통구청 35
 
5.8%
경기도 오산시 25
 
4.1%
경기도 이천시청 24
 
4.0%
경기도 하남시청 19
 
3.1%
경기도 수원시 팔달구청 18
 
3.0%
경기도 동두천시청 교통행정과 17
 
2.8%
Other values (10) 84
 
13.8%

Length

2024-05-18T04:13:45.628196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 492
34.1%
안양시청 222
15.4%
안산시 115
 
8.0%
도로교통과 115
 
8.0%
수원시 77
 
5.3%
단원구 65
 
4.5%
상록구 50
 
3.5%
의정부시청 48
 
3.3%
영통구청 35
 
2.4%
오산시 25
 
1.7%
Other values (19) 198
13.7%

관리기관전화번호
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
031-8045-5328
222 
031-481-6295
65 
031-481-5579
50 
031-828-4842
48 
031-223-8345
34 
Other values (16)
188 

Length

Max length13
Median length12
Mean length12.439868
Min length12

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row031-770-3755
2nd row031-770-3755
3rd row031-770-3755
4th row031-770-3755
5th row031-770-3755

Common Values

ValueCountFrequency (%)
031-8045-5328 222
36.6%
031-481-6295 65
 
10.7%
031-481-5579 50
 
8.2%
031-828-4842 48
 
7.9%
031-223-8345 34
 
5.6%
031-8036-6799 25
 
4.1%
031-644-2383 24
 
4.0%
031-790-6294 19
 
3.1%
031-228-7435 18
 
3.0%
031-860-2444 17
 
2.8%
Other values (11) 85
 
14.0%

Length

2024-05-18T04:13:45.975251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
031-8045-5328 222
36.6%
031-481-6295 65
 
10.7%
031-481-5579 50
 
8.2%
031-828-4842 48
 
7.9%
031-223-8345 34
 
5.6%
031-8036-6799 25
 
4.1%
031-644-2383 24
 
4.0%
031-790-6294 19
 
3.1%
031-228-7435 18
 
3.0%
031-860-2444 17
 
2.8%
Other values (11) 85
 
14.0%

데이터기준일자
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
2023-02-16
222 
2022-11-30
134 
2023-06-16
77 
2023-02-27
48 
2023-05-23
25 
Other values (9)
101 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-05-24
2nd row2023-05-24
3rd row2023-05-24
4th row2023-05-24
5th row2023-05-24

Common Values

ValueCountFrequency (%)
2023-02-16 222
36.6%
2022-11-30 134
22.1%
2023-06-16 77
 
12.7%
2023-02-27 48
 
7.9%
2023-05-23 25
 
4.1%
2023-07-14 24
 
4.0%
2023-03-27 17
 
2.8%
2023-07-07 16
 
2.6%
2023-10-20 11
 
1.8%
2023-05-24 10
 
1.6%
Other values (4) 23
 
3.8%

Length

2024-05-18T04:13:46.332499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2023-02-16 222
36.6%
2022-11-30 134
22.1%
2023-06-16 77
 
12.7%
2023-02-27 48
 
7.9%
2023-05-23 25
 
4.1%
2023-07-14 24
 
4.0%
2023-03-27 17
 
2.8%
2023-07-07 16
 
2.6%
2023-10-20 11
 
1.8%
2023-05-24 10
 
1.6%
Other values (4) 23
 
3.8%

Interactions

2024-05-18T04:13:32.674098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:27.477947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:28.860470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:30.036029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:31.322862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:32.949266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:27.928877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:29.042803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:30.341539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:31.579278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:33.200453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:28.090389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:29.283027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:30.561247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:31.876706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:33.464275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:28.306190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:29.522819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:30.764156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:32.141305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:33.739777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:28.607844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:29.794791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:31.066235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T04:13:32.408090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-18T04:13:46.564251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명지정사유지정연도도로폭도로연장도로차로수보차분리여부시작점위도종료점위도도로안내표지일련번호관리기관명관리기관전화번호데이터기준일자
시군구명1.0001.0000.7960.7920.3090.5610.7240.9290.930NaN1.0001.0001.000
지정사유1.0001.0000.8260.9650.0000.4350.7190.9450.945NaN1.0001.0001.000
지정연도0.7960.8261.0000.5360.3290.1390.3700.6880.688NaN0.7190.7050.796
도로폭0.7920.9650.5361.0000.2520.5790.5210.5530.560NaN0.8100.8190.773
도로연장0.3090.0000.3290.2521.0000.1740.2320.3320.331NaN0.3880.3260.276
도로차로수0.5610.4350.1390.5790.1741.0000.5340.3260.312NaN0.5680.5080.489
보차분리여부0.7240.7190.3700.5210.2320.5341.0000.3490.332NaN0.7580.6950.693
시작점위도0.9290.9450.6880.5530.3320.3260.3491.0001.000NaN0.9760.9470.891
종료점위도0.9300.9450.6880.5600.3310.3120.3321.0001.000NaN0.9760.9470.893
도로안내표지일련번호NaNNaNNaNNaNNaNNaNNaNNaNNaN1.000NaNNaNNaN
관리기관명1.0001.0000.7190.8100.3880.5680.7580.9760.976NaN1.0001.0001.000
관리기관전화번호1.0001.0000.7050.8190.3260.5080.6950.9470.947NaN1.0001.0001.000
데이터기준일자1.0001.0000.7960.7730.2760.4890.6930.8910.893NaN1.0001.0001.000
2024-05-18T04:13:46.952578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도로차로수시군구명지정사유데이터기준일자도로안내표지일련번호보차분리여부관리기관명관리기관전화번호
도로차로수1.0000.2900.1960.2951.0000.3630.2960.294
시군구명0.2901.0001.0000.9981.0000.5750.9970.996
지정사유0.1961.0001.0001.0001.0000.5211.0001.000
데이터기준일자0.2950.9981.0001.0001.0000.5460.9950.994
도로안내표지일련번호1.0001.0001.0001.0001.0001.0001.0001.000
보차분리여부0.3630.5750.5210.5461.0001.0000.6070.612
관리기관명0.2960.9971.0000.9951.0000.6071.0000.999
관리기관전화번호0.2940.9961.0000.9941.0000.6120.9991.000
2024-05-18T04:13:47.282071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지정연도도로폭도로연장시작점위도종료점위도시군구명지정사유도로차로수보차분리여부도로안내표지일련번호관리기관명관리기관전화번호데이터기준일자
지정연도1.0000.111-0.142-0.134-0.1380.5030.6640.1400.3540.0000.4530.4130.503
도로폭0.1111.0000.1060.0390.0390.4780.7220.4090.5231.0000.4850.4850.465
도로연장-0.1420.1061.000-0.093-0.0890.1250.0000.1040.1771.0000.1310.1250.114
시작점위도-0.1340.039-0.0931.0000.9990.7170.6560.1990.2661.0000.7410.7400.637
종료점위도-0.1380.039-0.0890.9991.0000.7200.6550.1900.2531.0000.7410.7390.640
시군구명0.5030.4780.1250.7170.7201.0001.0000.2900.5751.0000.9970.9960.998
지정사유0.6640.7220.0000.6560.6551.0001.0000.1960.5211.0001.0001.0001.000
도로차로수0.1400.4090.1040.1990.1900.2900.1961.0000.3631.0000.2960.2940.295
보차분리여부0.3540.5230.1770.2660.2530.5750.5210.3631.0001.0000.6070.6120.546
도로안내표지일련번호0.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
관리기관명0.4530.4850.1310.7410.7410.9971.0000.2960.6071.0001.0000.9990.995
관리기관전화번호0.4130.4850.1250.7400.7390.9961.0000.2940.6121.0000.9991.0000.994
데이터기준일자0.5030.4650.1140.6370.6400.9981.0000.2950.5461.0000.9950.9941.000

Missing values

2024-05-18T04:13:34.152645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-18T04:13:34.787880image/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

시도명시군구명도로명지정사유지정연도도로폭도로연장도로차로수보차분리여부시작점위도시작점경도종료점위도종료점경도도로안내표지일련번호관리기관명관리기관전화번호데이터기준일자
0경기도경기도 양평군청양평시장길주민편의20165.0400.01N127.489511<NA>127.492911<NA><NA>경기도 양평군청031-770-37552023-05-24
1경기도경기도 양평군청양평시장길17번길주민편의20165.0200.01N127.491111<NA>127.492411<NA><NA>경기도 양평군청031-770-37552023-05-24
2경기도경기도 양평군청다문중앙2길주민편의20175.0230.01Y127.592111<NA>127.593811<NA><NA>경기도 양평군청031-770-37552023-05-24
3경기도경기도 양평군청시민로39번길주민편의20175.0160.01N127.496111<NA>127.495711<NA><NA>경기도 양평군청031-770-37552023-05-24
4경기도경기도 양평군청관문길8번길주민편의20175.090.01N127.496111<NA>127.497311<NA><NA>경기도 양평군청031-770-37552023-05-24
5경기도경기도 양평군청양평장터길주민편의20185.0220.01Y127.489711<NA>127.492111<NA><NA>경기도 양평군청031-770-37552023-05-24
6경기도경기도 양평군청아래배내1길주민편의20184.0280.01N127.780311<NA>127.777811<NA><NA>경기도 양평군청031-770-37552023-05-24
7경기도경기도 양평군청양평시장길18번길주민편의20185.040.01Y127.492111<NA>127.492411<NA><NA>경기도 양평군청031-770-37552023-05-24
8경기도경기도 양평군청윗목골길주민편의20194.0630.01N127.752222<NA>127.751511<NA><NA>경기도 양평군청031-770-37552023-05-24
9경기도안양시장내로<NA><NA>3.0135.01N126.909494<NA>126.912108<NA><NA>경기도 안양시청031-8045-53282023-02-16
시도명시군구명도로명지정사유지정연도도로폭도로연장도로차로수보차분리여부시작점위도시작점경도종료점위도종료점경도도로안내표지일련번호관리기관명관리기관전화번호데이터기준일자
597경기도수원시동수원로514번길 58-18<NA><NA>6.090.01N127.048788<NA>127.049315<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
598경기도수원시산남로90번길 1<NA><NA>6.0120.01N127.049702<NA>127.050822<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
599경기도수원시산남로80번길<NA><NA>6.0120.01N127.051128<NA>127.050674<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
600경기도수원시매영로46번길 16<NA><NA>6.080.01N127.047229<NA>127.047719<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
601경기도수원시중부대로246번길 34<NA>20164.090.01Y127.041897<NA>127.041121<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
602경기도수원시태장로71번길 30<NA>20178.0130.01Y127.054306<NA>127.054841<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
603경기도수원시매여울로53번길<NA>20196.040.01Y127.042147<NA>127.044422<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
604경기도수원시영통로 153번길 80<NA>20206.0150.01N127.050943<NA>127.050046<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
605경기도수원시권선로908번길 52-9<NA>20216.0130.01Y127.043643<NA>127.044733<NA><NA>경기도 수원시 영통구청031-223-83452023-06-16
606경기도수원시태장로7번길 57<NA>20228.0100.01Y127.049378<NA>127.048512<NA><NA>경기도 수원시 영통구청031-228-83452023-06-16