Overview

Dataset statistics

Number of variables21
Number of observations2275
Missing cells21
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory388.9 KiB
Average record size in memory175.1 B

Variable types

Categorical12
Numeric5
Text4

Dataset

Description경기도 광주시 관내 도로표지판 현황에 대한 데이터로 위치지점, 위치방향, 표지명칭, 높이, 규격, 설치일 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15036916/fileData.do

Alerts

지형지물부호 has constant value ""Constant
관리기관 is highly imbalanced (94.7%)Imbalance
취득구분 is highly imbalanced (78.5%)Imbalance
취득금액 is highly imbalanced (63.4%)Imbalance
관리부서 is highly imbalanced (80.9%)Imbalance
내용연수 is highly imbalanced (64.5%)Imbalance
관리번호 has 50 (2.2%) zerosZeros
도로구간번호 has 36 (1.6%) zerosZeros
높이 has 44 (1.9%) zerosZeros

Reproduction

Analysis started2023-12-12 11:27:17.165741
Analysis finished2023-12-12 11:27:18.336636
Duration1.17 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
도로표지판
2275 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도로표지판
2nd row도로표지판
3rd row도로표지판
4th row도로표지판
5th row도로표지판

Common Values

ValueCountFrequency (%)
도로표지판 2275
100.0%

Length

2023-12-12T20:27:18.457805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:18.627105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로표지판 2275
100.0%

관리번호
Real number (ℝ)

ZEROS 

Distinct2226
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27277857
Minimum0
Maximum92024066
Zeros50
Zeros (%)2.2%
Negative0
Negative (%)0.0%
Memory size20.1 KiB
2023-12-12T20:27:19.354718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile67.7
Q1261004.5
median1231001
Q390459016
95-th percentile91917004
Maximum92024066
Range92024066
Interquartile range (IQR)90198012

Descriptive statistics

Standard deviation40484880
Coefficient of variation (CV)1.4841665
Kurtosis-1.154819
Mean27277857
Median Absolute Deviation (MAD)1110001
Skewness0.89829482
Sum6.2057124 × 1010
Variance1.6390255 × 1015
MonotonicityDecreasing
2023-12-12T20:27:19.650288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 50
 
2.2%
92024066 1
 
< 0.1%
616003 1
 
< 0.1%
624003 1
 
< 0.1%
624002 1
 
< 0.1%
624001 1
 
< 0.1%
616033 1
 
< 0.1%
616005 1
 
< 0.1%
616004 1
 
< 0.1%
616002 1
 
< 0.1%
Other values (2216) 2216
97.4%
ValueCountFrequency (%)
0 50
2.2%
1 1
 
< 0.1%
2 1
 
< 0.1%
3 1
 
< 0.1%
4 1
 
< 0.1%
5 1
 
< 0.1%
7 1
 
< 0.1%
8 1
 
< 0.1%
9 1
 
< 0.1%
10 1
 
< 0.1%
ValueCountFrequency (%)
92024066 1
< 0.1%
92024065 1
< 0.1%
92024064 1
< 0.1%
92024063 1
< 0.1%
92024062 1
< 0.1%
92024061 1
< 0.1%
92024056 1
< 0.1%
92024055 1
< 0.1%
92024054 1
< 0.1%
92024053 1
< 0.1%

행정구역
Categorical

Distinct17
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
남한산성면
352 
곤지암읍
291 
초월읍
268 
퇴촌면
211 
광남동
199 
Other values (12)
954 

Length

Max length5
Median length3
Mean length3.5534066
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row곤지암읍
2nd row경안동
3rd row경안동
4th row경안동
5th row초월읍

Common Values

ValueCountFrequency (%)
남한산성면 352
15.5%
곤지암읍 291
12.8%
초월읍 268
11.8%
퇴촌면 211
9.3%
광남동 199
8.7%
송정동 193
8.5%
도척면 157
6.9%
오포1동 155
6.8%
남종면 129
 
5.7%
경안동 117
 
5.1%
Other values (7) 203
8.9%

Length

2023-12-12T20:27:19.955226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
남한산성면 352
15.5%
곤지암읍 291
12.8%
초월읍 268
11.8%
퇴촌면 211
9.3%
광남동 199
8.7%
송정동 193
8.5%
도척면 157
6.9%
오포1동 155
6.8%
남종면 129
 
5.7%
경안동 117
 
5.1%
Other values (7) 203
8.9%

법정구역
Categorical

Distinct27
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
남한산성면
352 
곤지암읍
291 
초월읍
268 
퇴촌면
211 
도척면
157 
Other values (22)
996 

Length

Max length5
Median length3
Mean length3.3850549
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row곤지암읍
2nd row경안동
3rd row역동
4th row역동
5th row초월읍

Common Values

ValueCountFrequency (%)
남한산성면 352
15.5%
곤지암읍 291
12.8%
초월읍 268
11.8%
퇴촌면 211
 
9.3%
도척면 157
 
6.9%
남종면 129
 
5.7%
송정동 90
 
4.0%
역동 72
 
3.2%
문형동 71
 
3.1%
장지동 65
 
2.9%
Other values (17) 569
25.0%

Length

2023-12-12T20:27:20.240747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
남한산성면 352
15.5%
곤지암읍 291
12.8%
초월읍 268
11.8%
퇴촌면 211
 
9.3%
도척면 157
 
6.9%
남종면 129
 
5.7%
송정동 90
 
4.0%
역동 72
 
3.2%
문형동 71
 
3.1%
장지동 65
 
2.9%
Other values (17) 569
25.0%

관리기관
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
광주시
2252 
미분류
 
22
기타
 
1

Length

Max length3
Median length3
Mean length2.9995604
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row광주시
2nd row광주시
3rd row광주시
4th row광주시
5th row광주시

Common Values

ValueCountFrequency (%)
광주시 2252
99.0%
미분류 22
 
1.0%
기타 1
 
< 0.1%

Length

2023-12-12T20:27:20.452073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:20.660091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주시 2252
99.0%
미분류 22
 
1.0%
기타 1
 
< 0.1%

도로구간번호
Real number (ℝ)

ZEROS 

Distinct940
Distinct (%)41.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean211131.94
Minimum0
Maximum900382
Zeros36
Zeros (%)1.6%
Negative0
Negative (%)0.0%
Memory size20.1 KiB
2023-12-12T20:27:20.854904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1057
Q1120975
median240050
Q3340009
95-th percentile360549
Maximum900382
Range900382
Interquartile range (IQR)219034

Descriptive statistics

Standard deviation135992.3
Coefficient of variation (CV)0.6441105
Kurtosis3.6919703
Mean211131.94
Median Absolute Deviation (MAD)117189
Skewness0.83240178
Sum4.8032516 × 108
Variance1.8493905 × 1010
MonotonicityNot monotonic
2023-12-12T20:27:21.088913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
320351 44
 
1.9%
0 36
 
1.6%
320264 32
 
1.4%
123200 31
 
1.4%
120510 27
 
1.2%
120645 24
 
1.1%
360011 23
 
1.0%
360114 21
 
0.9%
240452 20
 
0.9%
140601 20
 
0.9%
Other values (930) 1997
87.8%
ValueCountFrequency (%)
0 36
1.6%
1 1
 
< 0.1%
5 6
 
0.3%
18 2
 
0.1%
25 1
 
< 0.1%
37 1
 
< 0.1%
44 2
 
0.1%
45 3
 
0.1%
56 11
 
0.5%
57 2
 
0.1%
ValueCountFrequency (%)
900382 1
 
< 0.1%
900265 2
0.1%
900183 2
0.1%
900077 1
 
< 0.1%
900052 1
 
< 0.1%
900033 1
 
< 0.1%
900028 2
0.1%
900014 1
 
< 0.1%
900013 1
 
< 0.1%
900006 3
0.1%

위치지점
Text

Distinct1504
Distinct (%)66.3%
Missing5
Missing (%)0.2%
Memory size17.9 KiB
2023-12-12T20:27:21.629791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length16
Mean length11.377093
Min length1

Characters and Unicode

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

Unique

Unique1212 ?
Unique (%)53.4%

Sample

1st row
2nd row
3rd row
4th row
5th row
ValueCountFrequency (%)
남한산성면 349
 
6.5%
곤지암읍 258
 
4.8%
초월읍 241
 
4.5%
퇴촌면 196
 
3.7%
도척면 153
 
2.9%
남종면 128
 
2.4%
상번천리 103
 
1.9%
송정동 79
 
1.5%
문형동 69
 
1.3%
산성리 63
 
1.2%
Other values (1559) 3698
69.3%
2023-12-12T20:27:22.483236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3611
 
14.0%
- 1585
 
6.1%
1 1387
 
5.4%
리 1323
 
5.1%
도 1112
 
4.3%
2 1016
 
3.9%
산 888
 
3.4%
3 873
 
3.4%
면 827
 
3.2%
4 790
 
3.1%
Other values (116) 12414
48.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 13296
51.5%
Decimal Number 7334
28.4%
Space Separator 3611
 
14.0%
Dash Punctuation 1585
 
6.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 1323
 
10.0%
도 1112
 
8.4%
산 888
 
6.7%
면 827
 
6.2%
동 735
 
5.5%
지 507
 
3.8%
읍 499
 
3.8%
남 477
 
3.6%
성 436
 
3.3%
천 389
 
2.9%
Other values (104) 6103
45.9%
Decimal Number
ValueCountFrequency (%)
1 1387
18.9%
2 1016
13.9%
3 873
11.9%
4 790
10.8%
6 729
9.9%
5 728
9.9%
7 508
 
6.9%
8 487
 
6.6%
0 417
 
5.7%
9 399
 
5.4%
Space Separator
ValueCountFrequency (%)
3611
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1585
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 13296
51.5%
Common 12530
48.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 1323
 
10.0%
도 1112
 
8.4%
산 888
 
6.7%
면 827
 
6.2%
동 735
 
5.5%
지 507
 
3.8%
읍 499
 
3.8%
남 477
 
3.6%
성 436
 
3.3%
천 389
 
2.9%
Other values (104) 6103
45.9%
Common
ValueCountFrequency (%)
3611
28.8%
- 1585
12.6%
1 1387
 
11.1%
2 1016
 
8.1%
3 873
 
7.0%
4 790
 
6.3%
6 729
 
5.8%
5 728
 
5.8%
7 508
 
4.1%
8 487
 
3.9%
Other values (2) 816
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 13296
51.5%
ASCII 12530
48.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3611
28.8%
- 1585
12.6%
1 1387
 
11.1%
2 1016
 
8.1%
3 873
 
7.0%
4 790
 
6.3%
6 729
 
5.8%
5 728
 
5.8%
7 508
 
4.1%
8 487
 
3.9%
Other values (2) 816
 
6.5%
Hangul
ValueCountFrequency (%)
리 1323
 
10.0%
도 1112
 
8.4%
산 888
 
6.7%
면 827
 
6.2%
동 735
 
5.5%
지 507
 
3.8%
읍 499
 
3.8%
남 477
 
3.6%
성 436
 
3.3%
천 389
 
2.9%
Other values (104) 6103
45.9%

위치방향
Categorical

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
하행(좌)
1097 
상행(우)
1054 
미분류
 
57
<NA>
 
43
기타
 
24

Length

Max length5
Median length5
Mean length4.8993407
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row하행(좌)
2nd row하행(좌)
3rd row하행(좌)
4th row상행(우)
5th row상행(우)

Common Values

ValueCountFrequency (%)
하행(좌) 1097
48.2%
상행(우) 1054
46.3%
미분류 57
 
2.5%
<NA> 43
 
1.9%
기타 24
 
1.1%

Length

2023-12-12T20:27:22.742161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:22.923088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
하행(좌 1097
48.2%
상행(우 1054
46.3%
미분류 57
 
2.5%
na 43
 
1.9%
기타 24
 
1.1%

표지종류
Categorical

Distinct10
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
도로안내(기타)
939 
도로안내(방향)
694 
기타
212 
도로안내(이정)
173 
도로안내(노선)
107 
Other values (5)
150 

Length

Max length10
Median length8
Mean length7.4303297
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도로안내(기타)
2nd row도로안내(기타)
3rd row도로안내(방향)
4th row도로안내(이정)
5th row도로안내(기타)

Common Values

ValueCountFrequency (%)
도로안내(기타) 939
41.3%
도로안내(방향) 694
30.5%
기타 212
 
9.3%
도로안내(이정) 173
 
7.6%
도로안내(노선) 107
 
4.7%
도로안내(경계) 53
 
2.3%
도로안내(방향예고) 52
 
2.3%
미분류 22
 
1.0%
도로안내(보조) 17
 
0.7%
도로정보판 6
 
0.3%

Length

2023-12-12T20:27:23.122104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:23.305544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로안내(기타 939
41.3%
도로안내(방향 694
30.5%
기타 212
 
9.3%
도로안내(이정 173
 
7.6%
도로안내(노선 107
 
4.7%
도로안내(경계 53
 
2.3%
도로안내(방향예고 52
 
2.3%
미분류 22
 
1.0%
도로안내(보조 17
 
0.7%
도로정보판 6
 
0.3%

표지명칭
Categorical

Distinct33
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
기타
1076 
2방향표지
254 
3방향표지
185 
미분류
 
98
하천표지
 
74
Other values (28)
588 

Length

Max length11
Median length8
Mean length3.730989
Min length2

Unique

Unique5 ?
Unique (%)0.2%

Sample

1st row하천표지
2nd row주차장표지
3rd row2지명방향표지
4th row1지명방향표지
5th row하천표지

Common Values

ValueCountFrequency (%)
기타 1076
47.3%
2방향표지 254
 
11.2%
3방향표지 185
 
8.1%
미분류 98
 
4.3%
하천표지 74
 
3.3%
단일노선표지 73
 
3.2%
2방향예고표지 68
 
3.0%
3방향예고표지 64
 
2.8%
방향표지 56
 
2.5%
관광지표지 50
 
2.2%
Other values (23) 277
 
12.2%

Length

2023-12-12T20:27:23.518824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타 1076
46.1%
2방향표지 254
 
10.9%
3방향표지 185
 
7.9%
미분류 98
 
4.2%
하천표지 74
 
3.2%
단일노선표지 73
 
3.1%
2방향예고표지 68
 
2.9%
3방향예고표지 64
 
2.7%
이정표지 60
 
2.6%
방향표지 56
 
2.4%
Other values (24) 327
 
14.0%

지주형식
Categorical

Distinct11
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
복주식
859 
편지식
650 
단주식
447 
부착식
87 
현수식
 
73
Other values (6)
159 

Length

Max length3
Median length3
Mean length2.981978
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row복주식
2nd row편지식
3rd row편지식
4th row편지식
5th row복주식

Common Values

ValueCountFrequency (%)
복주식 859
37.8%
편지식 650
28.6%
단주식 447
19.6%
부착식 87
 
3.8%
현수식 73
 
3.2%
측주식 51
 
2.2%
기타 41
 
1.8%
미분류 27
 
1.2%
문형식 20
 
0.9%
내민식 19
 
0.8%

Length

2023-12-12T20:27:23.705324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
복주식 859
37.8%
편지식 650
28.6%
단주식 447
19.6%
부착식 87
 
3.8%
현수식 73
 
3.2%
측주식 51
 
2.2%
기타 41
 
1.8%
미분류 27
 
1.2%
문형식 20
 
0.9%
내민식 19
 
0.8%

높이
Real number (ℝ)

ZEROS 

Distinct76
Distinct (%)3.3%
Missing1
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean3.569956
Minimum0
Maximum9.5
Zeros44
Zeros (%)1.9%
Negative0
Negative (%)0.0%
Memory size20.1 KiB
2023-12-12T20:27:23.941501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q35
95-th percentile6.5
Maximum9.5
Range9.5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.9345584
Coefficient of variation (CV)0.54189978
Kurtosis-0.39247704
Mean3.569956
Median Absolute Deviation (MAD)1.5
Skewness0.46803386
Sum8118.08
Variance3.7425161
MonotonicityNot monotonic
2023-12-12T20:27:24.157413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5.0 266
 
11.7%
5.5 179
 
7.9%
6.0 155
 
6.8%
2.0 120
 
5.3%
4.5 118
 
5.2%
3.0 113
 
5.0%
2.5 105
 
4.6%
4.0 69
 
3.0%
1.7 64
 
2.8%
1.0 63
 
2.8%
Other values (66) 1022
44.9%
ValueCountFrequency (%)
0.0 44
1.9%
0.1 1
 
< 0.1%
0.5 5
 
0.2%
0.6 7
 
0.3%
0.7 1
 
< 0.1%
0.8 11
 
0.5%
0.9 6
 
0.3%
1.0 63
2.8%
1.1 11
 
0.5%
1.14 1
 
< 0.1%
ValueCountFrequency (%)
9.5 3
 
0.1%
9.3 2
 
0.1%
9.0 36
1.6%
8.0 11
 
0.5%
7.5 13
 
0.6%
7.2 2
 
0.1%
7.0 39
1.7%
6.8 1
 
< 0.1%
6.5 8
 
0.4%
6.3 44
1.9%

규격
Text

Distinct364
Distinct (%)16.0%
Missing5
Missing (%)0.2%
Memory size17.9 KiB
2023-12-12T20:27:24.707657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length7
Mean length7.007489
Min length1

Characters and Unicode

Total characters15907
Distinct characters26
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique166 ?
Unique (%)7.3%

Sample

1st row3.2X2.5
2nd row1.0X0.7
3rd row3.2X2.5
4th row2.5X1.0
5th row2.5X1.0
ValueCountFrequency (%)
3.6x2.2 164
 
7.4%
4.0x2.5 91
 
4.1%
1.5x1.0 90
 
4.0%
1.0x1.0 86
 
3.9%
1.8x1.2 66
 
3.0%
4.45x2.2 63
 
2.8%
1.5x1.2 58
 
2.6%
1.6x1.2 58
 
2.6%
2.5x1.5 54
 
2.4%
3.0x2.0 52
 
2.3%
Other values (354) 1443
64.9%
2023-12-12T20:27:25.475752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 4411
27.7%
X 2133
13.4%
1 1974
12.4%
0 1835
11.5%
2 1783
11.2%
5 1139
 
7.2%
4 609
 
3.8%
6 573
 
3.6%
3 532
 
3.3%
8 335
 
2.1%
Other values (16) 583
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 9153
57.5%
Other Punctuation 4484
28.2%
Uppercase Letter 2146
 
13.5%
Space Separator 57
 
0.4%
Other Symbol 35
 
0.2%
Other Letter 18
 
0.1%
Dash Punctuation 8
 
0.1%
Lowercase Letter 4
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1974
21.6%
0 1835
20.0%
2 1783
19.5%
5 1139
12.4%
4 609
 
6.7%
6 573
 
6.3%
3 532
 
5.8%
8 335
 
3.7%
7 227
 
2.5%
9 146
 
1.6%
Uppercase Letter
ValueCountFrequency (%)
X 2133
99.4%
Ø 5
 
0.2%
E 4
 
0.2%
A 4
 
0.2%
Other Letter
ValueCountFrequency (%)
사 8
44.4%
각 8
44.4%
양 1
 
5.6%
면 1
 
5.6%
Other Punctuation
ValueCountFrequency (%)
. 4411
98.4%
* 73
 
1.6%
Space Separator
ValueCountFrequency (%)
57
100.0%
Other Symbol
ValueCountFrequency (%)
□ 35
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Lowercase Letter
ValueCountFrequency (%)
x 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 13739
86.4%
Latin 2150
 
13.5%
Hangul 18
 
0.1%

Most frequent character per script

Common
ValueCountFrequency (%)
. 4411
32.1%
1 1974
14.4%
0 1835
13.4%
2 1783
13.0%
5 1139
 
8.3%
4 609
 
4.4%
6 573
 
4.2%
3 532
 
3.9%
8 335
 
2.4%
7 227
 
1.7%
Other values (7) 321
 
2.3%
Latin
ValueCountFrequency (%)
X 2133
99.2%
Ø 5
 
0.2%
E 4
 
0.2%
A 4
 
0.2%
x 4
 
0.2%
Hangul
ValueCountFrequency (%)
사 8
44.4%
각 8
44.4%
양 1
 
5.6%
면 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 15849
99.6%
Geometric Shapes 35
 
0.2%
Hangul 18
 
0.1%
None 5
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 4411
27.8%
X 2133
13.5%
1 1974
12.5%
0 1835
11.6%
2 1783
11.2%
5 1139
 
7.2%
4 609
 
3.8%
6 573
 
3.6%
3 532
 
3.4%
8 335
 
2.1%
Other values (10) 525
 
3.3%
Geometric Shapes
ValueCountFrequency (%)
□ 35
100.0%
Hangul
ValueCountFrequency (%)
사 8
44.4%
각 8
44.4%
양 1
 
5.6%
면 1
 
5.6%
None
ValueCountFrequency (%)
Ø 5
100.0%

설치일
Text

Distinct51
Distinct (%)2.2%
Missing5
Missing (%)0.2%
Memory size17.9 KiB
2023-12-12T20:27:25.763256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.8017621
Min length1

Characters and Unicode

Total characters22250
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique13 ?
Unique (%)0.6%

Sample

1st row2000-01-01
2nd row2017-01-01
3rd row2000-01-01
4th row2000-01-01
5th row2015-01-01
ValueCountFrequency (%)
1900-01-01 1877
84.5%
2021-11-01 31
 
1.4%
2021-04-30 28
 
1.3%
2017-01-01 26
 
1.2%
2018-01-01 21
 
0.9%
2009-01-01 20
 
0.9%
2000-01-01 16
 
0.7%
2013-01-01 15
 
0.7%
2021-01-01 15
 
0.7%
2010-01-01 15
 
0.7%
Other values (40) 156
 
7.0%
2023-12-12T20:27:26.268887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 8547
38.4%
1 6508
29.2%
- 4440
20.0%
9 1933
 
8.7%
2 526
 
2.4%
3 61
 
0.3%
50
 
0.2%
7 48
 
0.2%
8 44
 
0.2%
4 43
 
0.2%
Other values (2) 50
 
0.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 17760
79.8%
Dash Punctuation 4440
 
20.0%
Space Separator 50
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 8547
48.1%
1 6508
36.6%
9 1933
 
10.9%
2 526
 
3.0%
3 61
 
0.3%
7 48
 
0.3%
8 44
 
0.2%
4 43
 
0.2%
6 30
 
0.2%
5 20
 
0.1%
Dash Punctuation
ValueCountFrequency (%)
- 4440
100.0%
Space Separator
ValueCountFrequency (%)
50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 22250
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 8547
38.4%
1 6508
29.2%
- 4440
20.0%
9 1933
 
8.7%
2 526
 
2.4%
3 61
 
0.3%
50
 
0.2%
7 48
 
0.2%
8 44
 
0.2%
4 43
 
0.2%
Other values (2) 50
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 22250
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 8547
38.4%
1 6508
29.2%
- 4440
20.0%
9 1933
 
8.7%
2 526
 
2.4%
3 61
 
0.3%
50
 
0.2%
7 48
 
0.2%
8 44
 
0.2%
4 43
 
0.2%
Other values (2) 50
 
0.2%

취득구분
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
매입
2052 
미분류
210 
기부채납
 
10
<NA>
 
2
기타
 
1

Length

Max length4
Median length2
Mean length2.1028571
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row매입
2nd row매입
3rd row매입
4th row매입
5th row매입

Common Values

ValueCountFrequency (%)
매입 2052
90.2%
미분류 210
 
9.2%
기부채납 10
 
0.4%
<NA> 2
 
0.1%
기타 1
 
< 0.1%

Length

2023-12-12T20:27:26.538651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:26.756308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
매입 2052
90.2%
미분류 210
 
9.2%
기부채납 10
 
0.4%
na 2
 
0.1%
기타 1
 
< 0.1%

취득금액
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
1900000
1974 
0
296 
<NA>
 
5

Length

Max length7
Median length7
Mean length6.2127473
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1900000 1974
86.8%
0 296
 
13.0%
<NA> 5
 
0.2%

Length

2023-12-12T20:27:26.979468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:27.168018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1900000 1974
86.8%
0 296
 
13.0%
na 5
 
0.2%

관리부서
Categorical

IMBALANCE 

Distinct6
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
도로관리과
2070 
 
183
도로사업과
 
14
<NA>
 
5
MNG001
 
2

Length

Max length6
Median length5
Mean length4.6764835
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row도로관리과
2nd row도로관리과
3rd row도로관리과
4th row도로관리과
5th row도로관리과

Common Values

ValueCountFrequency (%)
도로관리과 2070
91.0%
183
 
8.0%
도로사업과 14
 
0.6%
<NA> 5
 
0.2%
MNG001 2
 
0.1%
도관리과 1
 
< 0.1%

Length

2023-12-12T20:27:27.365835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:27.572997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로관리과 2070
98.9%
도로사업과 14
 
0.7%
na 5
 
0.2%
mng001 2
 
0.1%
도관리과 1
 
< 0.1%

내용연수
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size17.9 KiB
10
1988 
0
282 
<NA>
 
5

Length

Max length4
Median length2
Mean length1.8804396
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 1988
87.4%
0 282
 
12.4%
<NA> 5
 
0.2%

Length

2023-12-12T20:27:27.800533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:27:28.004948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 1988
87.4%
0 282
 
12.4%
na 5
 
0.2%

비고
Text

Distinct347
Distinct (%)15.3%
Missing5
Missing (%)0.2%
Memory size17.9 KiB
2023-12-12T20:27:28.464786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length1
Mean length2.9744493
Min length1

Characters and Unicode

Total characters6752
Distinct characters311
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique238 ?
Unique (%)10.5%

Sample

1st row상오향천
2nd row
3rd row
4th row
5th row
ValueCountFrequency (%)
상수원보호구역 77
 
8.2%
감속운행 30
 
3.2%
3방향표지 29
 
3.1%
2방향표지 23
 
2.5%
경고문 21
 
2.2%
접도구역 17
 
1.8%
단일노선표시 16
 
1.7%
알림판 15
 
1.6%
상수도보호구역 14
 
1.5%
2방향예고표지 13
 
1.4%
Other values (381) 682
72.8%
2023-12-12T20:27:29.322494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1547
22.9%
지 265
 
3.9%
역 183
 
2.7%
구 167
 
2.5%
수 158
 
2.3%
표 149
 
2.2%
상 123
 
1.8%
보 121
 
1.8%
호 117
 
1.7%
안 116
 
1.7%
Other values (301) 3806
56.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4862
72.0%
Space Separator 1547
 
22.9%
Decimal Number 220
 
3.3%
Other Punctuation 77
 
1.1%
Uppercase Letter 32
 
0.5%
Close Punctuation 5
 
0.1%
Open Punctuation 5
 
0.1%
Lowercase Letter 3
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 265
 
5.5%
역 183
 
3.8%
구 167
 
3.4%
수 158
 
3.2%
표 149
 
3.1%
상 123
 
2.5%
보 121
 
2.5%
호 117
 
2.4%
안 116
 
2.4%
원 109
 
2.2%
Other values (273) 3354
69.0%
Decimal Number
ValueCountFrequency (%)
2 69
31.4%
3 48
21.8%
0 38
17.3%
1 34
15.5%
5 11
 
5.0%
8 9
 
4.1%
7 4
 
1.8%
4 3
 
1.4%
9 3
 
1.4%
6 1
 
0.5%
Uppercase Letter
ValueCountFrequency (%)
M 10
31.2%
X 10
31.2%
K 6
18.8%
C 1
 
3.1%
I 1
 
3.1%
T 1
 
3.1%
P 1
 
3.1%
A 1
 
3.1%
Æ 1
 
3.1%
Other Punctuation
ValueCountFrequency (%)
. 38
49.4%
, 36
46.8%
* 3
 
3.9%
Lowercase Letter
ValueCountFrequency (%)
m 2
66.7%
k 1
33.3%
Space Separator
ValueCountFrequency (%)
1547
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4862
72.0%
Common 1855
 
27.5%
Latin 35
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 265
 
5.5%
역 183
 
3.8%
구 167
 
3.4%
수 158
 
3.2%
표 149
 
3.1%
상 123
 
2.5%
보 121
 
2.5%
호 117
 
2.4%
안 116
 
2.4%
원 109
 
2.2%
Other values (273) 3354
69.0%
Common
ValueCountFrequency (%)
1547
83.4%
2 69
 
3.7%
3 48
 
2.6%
0 38
 
2.0%
. 38
 
2.0%
, 36
 
1.9%
1 34
 
1.8%
5 11
 
0.6%
8 9
 
0.5%
) 5
 
0.3%
Other values (7) 20
 
1.1%
Latin
ValueCountFrequency (%)
M 10
28.6%
X 10
28.6%
K 6
17.1%
m 2
 
5.7%
C 1
 
2.9%
I 1
 
2.9%
T 1
 
2.9%
P 1
 
2.9%
A 1
 
2.9%
Æ 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4862
72.0%
ASCII 1889
 
28.0%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1547
81.9%
2 69
 
3.7%
3 48
 
2.5%
0 38
 
2.0%
. 38
 
2.0%
, 36
 
1.9%
1 34
 
1.8%
5 11
 
0.6%
M 10
 
0.5%
X 10
 
0.5%
Other values (17) 48
 
2.5%
Hangul
ValueCountFrequency (%)
지 265
 
5.5%
역 183
 
3.8%
구 167
 
3.4%
수 158
 
3.2%
표 149
 
3.1%
상 123
 
2.5%
보 121
 
2.5%
호 117
 
2.4%
안 116
 
2.4%
원 109
 
2.2%
Other values (273) 3354
69.0%
None
ValueCountFrequency (%)
Æ 1
100.0%

경도
Real number (ℝ)

Distinct2250
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.27608
Minimum127.14192
Maximum127.43092
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.1 KiB
2023-12-12T20:27:29.581415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.14192
5-th percentile127.1839
Q1127.23691
median127.26548
Q3127.31721
95-th percentile127.38254
Maximum127.43092
Range0.289002
Interquartile range (IQR)0.08029935

Descriptive statistics

Standard deviation0.058837903
Coefficient of variation (CV)0.00046228563
Kurtosis-0.5449417
Mean127.27608
Median Absolute Deviation (MAD)0.0412631
Skewness0.19740242
Sum289553.08
Variance0.0034618988
MonotonicityNot monotonic
2023-12-12T20:27:29.854043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.2518687 3
 
0.1%
127.2465584 3
 
0.1%
127.2496207 3
 
0.1%
127.236377 3
 
0.1%
127.2484415 2
 
0.1%
127.1795603 2
 
0.1%
127.3951326 2
 
0.1%
127.1996147 2
 
0.1%
127.2550487 2
 
0.1%
127.2505541 2
 
0.1%
Other values (2240) 2251
98.9%
ValueCountFrequency (%)
127.1419174 1
< 0.1%
127.1439838 1
< 0.1%
127.1477162 1
< 0.1%
127.1495416 1
< 0.1%
127.1498402 1
< 0.1%
127.150158 1
< 0.1%
127.1501656 1
< 0.1%
127.1502214 1
< 0.1%
127.1503577 1
< 0.1%
127.1504081 1
< 0.1%
ValueCountFrequency (%)
127.4309194 1
< 0.1%
127.4168066 1
< 0.1%
127.4163766 1
< 0.1%
127.4163023 1
< 0.1%
127.4161779 1
< 0.1%
127.4125484 1
< 0.1%
127.4106453 1
< 0.1%
127.4091534 1
< 0.1%
127.4080187 1
< 0.1%
127.4077741 1
< 0.1%

위도
Real number (ℝ)

Distinct2250
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.404384
Minimum37.27169
Maximum37.532808
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.1 KiB
2023-12-12T20:27:30.132027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.27169
5-th percentile37.307678
Q137.360446
median37.405675
Q337.447064
95-th percentile37.487623
Maximum37.532808
Range0.26111798
Interquartile range (IQR)0.08661774

Descriptive statistics

Standard deviation0.055032154
Coefficient of variation (CV)0.0014712755
Kurtosis-0.51841526
Mean37.404384
Median Absolute Deviation (MAD)0.04338382
Skewness-0.098810401
Sum85094.975
Variance0.003028538
MonotonicityNot monotonic
2023-12-12T20:27:30.371393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.42829977 3
 
0.1%
37.3710777 3
 
0.1%
37.3946361 3
 
0.1%
37.39646676 3
 
0.1%
37.39412389 2
 
0.1%
37.42811583 2
 
0.1%
37.34533705 2
 
0.1%
37.43065256 2
 
0.1%
37.38870737 2
 
0.1%
37.40189946 2
 
0.1%
Other values (2240) 2251
98.9%
ValueCountFrequency (%)
37.27168964 1
< 0.1%
37.27171548 1
< 0.1%
37.2717957 1
< 0.1%
37.27181665 1
< 0.1%
37.27200425 1
< 0.1%
37.27337774 1
< 0.1%
37.27358574 1
< 0.1%
37.27447522 1
< 0.1%
37.27473962 1
< 0.1%
37.2765387 1
< 0.1%
ValueCountFrequency (%)
37.53280762 1
< 0.1%
37.53256293 1
< 0.1%
37.53226291 1
< 0.1%
37.5320859 1
< 0.1%
37.53166235 1
< 0.1%
37.53152267 1
< 0.1%
37.5311511 1
< 0.1%
37.53074733 1
< 0.1%
37.53054727 1
< 0.1%
37.53023489 1
< 0.1%

Sample

지형지물부호관리번호행정구역법정구역관리기관도로구간번호위치지점위치방향표지종류표지명칭지주형식높이규격설치일취득구분취득금액관리부서내용연수비고경도위도
0도로표지판92024066곤지암읍곤지암읍광주시122757하행(좌)도로안내(기타)하천표지복주식3.03.2X2.52000-01-01매입0도로관리과0상오향천127.37593537.359854
1도로표지판92024065경안동경안동광주시301하행(좌)도로안내(기타)주차장표지편지식5.01.0X0.72017-01-01매입0도로관리과0127.25759937.411102
2도로표지판92024064경안동역동광주시45하행(좌)도로안내(방향)2지명방향표지편지식5.03.2X2.52000-01-01매입0도로관리과0127.24957837.400759
3도로표지판92024063경안동역동광주시160395상행(우)도로안내(이정)1지명방향표지편지식5.02.5X1.02000-01-01매입0도로관리과0127.24255337.401437
4도로표지판92024062초월읍초월읍광주시240452상행(우)도로안내(기타)하천표지복주식2.52.5X1.02015-01-01매입0도로관리과0127.29064437.412707
5도로표지판92024061초월읍초월읍광주시240452하행(좌)도로안내(기타)관광지표지부착식4.51.0X0.72015-01-01매입0도로관리과0127.28826637.4164
6도로표지판92024056경안동경안동광주시1006상행(우)도로안내(기타)관광지표지복주식5.06.0X5.02008-01-01매입0도로관리과0127.25104837.415966
7도로표지판92024055송정동탄벌동광주시1822하행(좌)도로안내(방향)3방향표지편지식5.03.2X2.52010-01-01매입0도로관리과0127.24718237.414654
8도로표지판92024054송정동탄벌동광주시183상행(우)도로안내(방향)3방향표지편지식5.03.2X2.02010-01-01매입0도로관리과0127.24887737.414856
9도로표지판92024053송정동탄벌동광주시1072상행(우)도로안내(방향)방향표지편지식5.01.6X1.22000-01-01매입0도로관리과0127.2506937.415046
지형지물부호관리번호행정구역법정구역관리기관도로구간번호위치지점위치방향표지종류표지명칭지주형식높이규격설치일취득구분취득금액관리부서내용연수비고경도위도
2265도로표지판0<NA><NA>광주시0미분류도로안내(노선)출구점예고표지단주식3.0미분류00127.32280937.289323
2266도로표지판0<NA><NA>광주시0미분류도로안내(방향)2방향표지편지식5.0미분류00127.32329837.289733
2267도로표지판0<NA><NA>기타0미분류기타기타편지식5.0미분류00127.32388637.289591
2268도로표지판0<NA><NA>광주시0미분류도로안내(방향)분기점표지단주식0.0미분류00127.3245437.290697
2269도로표지판0<NA><NA>광주시0미분류도로안내(방향)2방향표지편지식5.0미분류00127.32412337.290463
2270도로표지판0<NA><NA>광주시0<NA>미분류도로안내(방향)2방향표지측주식5.0<NA><NA>미분류<NA><NA><NA><NA>127.40611737.385542
2271도로표지판0<NA><NA>광주시200013<NA>미분류도로안내(방향예고)2방향예고표지내민식5.0<NA><NA>미분류<NA><NA><NA><NA>127.40575137.379551
2272도로표지판0<NA><NA>광주시396<NA>미분류도로안내(기타)주차장표지측주식5.0<NA><NA>미분류<NA><NA><NA><NA>127.25990537.40625
2273도로표지판0<NA><NA>광주시0<NA>미분류도로안내(방향)관광지표지복주식2.0<NA><NA>미분류<NA><NA><NA><NA>127.27490737.472617
2274도로표지판0<NA><NA>미분류0<NA>미분류미분류미분류미분류<NA><NA><NA>미분류<NA><NA><NA><NA>127.15806737.3599