Overview

Dataset statistics

Number of variables12
Number of observations109
Missing cells72
Missing cells (%)5.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.7 KiB
Average record size in memory100.2 B

Variable types

Text4
Categorical6
Numeric1
DateTime1

Dataset

Description대전광역시 주정차 허용구간(관리번호, 시군구명, 시군구코드, 도로명, 허용구간, 연장, 허용구분, 허용시간, 용도, 대표이미지, 허용일자, 기타)
URLhttps://www.data.go.kr/data/15076802/fileData.do

Alerts

시군구코드 is highly overall correlated with 시군구명 and 1 other fieldsHigh correlation
시군구명 is highly overall correlated with 시군구코드 and 1 other fieldsHigh correlation
허용구분 is highly overall correlated with 허용시간High correlation
허용시간 is highly overall correlated with 허용구분 and 1 other fieldsHigh correlation
용도 is highly overall correlated with 허용시간High correlation
대표이미지 is highly overall correlated with 시군구명 and 1 other fieldsHigh correlation
허용구간 has 8 (7.3%) missing valuesMissing
허용일자 has 10 (9.2%) missing valuesMissing
기타 has 53 (48.6%) missing valuesMissing
관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 23:19:23.073684
Analysis finished2023-12-12 23:19:24.270210
Duration1.2 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

UNIQUE 

Distinct109
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2023-12-13T08:19:24.387604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

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

Unique

Unique109 ?
Unique (%)100.0%

Sample

1st row3680000_ALLOW_00002
2nd row3680000_ALLOW_00005
3rd row3680000_ALLOW_00007
4th row3680000_ALLOW_00008
5th row3680000_ALLOW_00009
ValueCountFrequency (%)
3680000_allow_00002 1
 
0.9%
3670000_allow_00062 1
 
0.9%
3650000_allow_00103 1
 
0.9%
3650000_allow_00102 1
 
0.9%
3650000_allow_00101 1
 
0.9%
3650000_allow_00099 1
 
0.9%
3650000_allow_00098 1
 
0.9%
3650000_allow_00097 1
 
0.9%
3650000_allow_00096 1
 
0.9%
3650000_allow_00095 1
 
0.9%
Other values (99) 99
90.8%
2023-12-13T08:19:24.660067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 781
37.7%
_ 218
 
10.5%
L 218
 
10.5%
6 157
 
7.6%
3 130
 
6.3%
A 109
 
5.3%
O 109
 
5.3%
W 109
 
5.3%
5 50
 
2.4%
7 43
 
2.1%
Other values (5) 147
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1308
63.2%
Uppercase Letter 545
26.3%
Connector Punctuation 218
 
10.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 781
59.7%
6 157
 
12.0%
3 130
 
9.9%
5 50
 
3.8%
7 43
 
3.3%
8 38
 
2.9%
1 36
 
2.8%
4 33
 
2.5%
9 21
 
1.6%
2 19
 
1.5%
Uppercase Letter
ValueCountFrequency (%)
L 218
40.0%
A 109
20.0%
O 109
20.0%
W 109
20.0%
Connector Punctuation
ValueCountFrequency (%)
_ 218
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1526
73.7%
Latin 545
 
26.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 781
51.2%
_ 218
 
14.3%
6 157
 
10.3%
3 130
 
8.5%
5 50
 
3.3%
7 43
 
2.8%
8 38
 
2.5%
1 36
 
2.4%
4 33
 
2.2%
9 21
 
1.4%
Latin
ValueCountFrequency (%)
L 218
40.0%
A 109
20.0%
O 109
20.0%
W 109
20.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2071
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 781
37.7%
_ 218
 
10.5%
L 218
 
10.5%
6 157
 
7.6%
3 130
 
6.3%
A 109
 
5.3%
O 109
 
5.3%
W 109
 
5.3%
5 50
 
2.4%
7 43
 
2.1%
Other values (5) 147
 
7.1%

시군구명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size1004.0 B
중구
29 
서구
28 
유성구
22 
대덕구
18 
동구
12 

Length

Max length3
Median length2
Mean length2.3669725
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대덕구
2nd row대덕구
3rd row대덕구
4th row대덕구
5th row대덕구

Common Values

ValueCountFrequency (%)
중구 29
26.6%
서구 28
25.7%
유성구 22
20.2%
대덕구 18
16.5%
동구 12
11.0%

Length

2023-12-13T08:19:24.766621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:24.846082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중구 29
26.6%
서구 28
25.7%
유성구 22
20.2%
대덕구 18
16.5%
동구 12
11.0%

시군구코드
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size1004.0 B
3660000
31 
3650000
29 
3670000
22 
3680000
15 
3640000
12 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3660000 31
28.4%
3650000 29
26.6%
3670000 22
20.2%
3680000 15
13.8%
3640000 12
 
11.0%

Length

2023-12-13T08:19:24.931918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:25.008754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3660000 31
28.4%
3650000 29
26.6%
3670000 22
20.2%
3680000 15
13.8%
3640000 12
 
11.0%
Distinct69
Distinct (%)63.9%
Missing1
Missing (%)0.9%
Memory size1004.0 B
2023-12-13T08:19:25.218152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length5.1296296
Min length3

Characters and Unicode

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

Unique

Unique43 ?
Unique (%)39.8%

Sample

1st row계족로664번길
2nd row문평동로18번길
3rd row대전로1033번길20
4th row한남로149번길
5th row대전로1365번길
ValueCountFrequency (%)
유등로 5
 
4.0%
테크노2로 4
 
3.2%
둔산대로 4
 
3.2%
117번길 4
 
3.2%
동서대로 3
 
2.4%
계룡로 3
 
2.4%
천변도시고속화도로 3
 
2.4%
보문산로 3
 
2.4%
테크노3로 3
 
2.4%
대덕대로 3
 
2.4%
Other values (73) 91
72.2%
2023-12-13T08:19:25.545844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
101
 
18.2%
25
 
4.5%
1 22
 
4.0%
18
 
3.2%
13
 
2.3%
13
 
2.3%
2 12
 
2.2%
12
 
2.2%
12
 
2.2%
11
 
2.0%
Other values (95) 315
56.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 447
80.7%
Decimal Number 82
 
14.8%
Space Separator 18
 
3.2%
Close Punctuation 3
 
0.5%
Open Punctuation 3
 
0.5%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
101
22.6%
25
 
5.6%
13
 
2.9%
13
 
2.9%
12
 
2.7%
12
 
2.7%
11
 
2.5%
10
 
2.2%
9
 
2.0%
9
 
2.0%
Other values (81) 232
51.9%
Decimal Number
ValueCountFrequency (%)
1 22
26.8%
2 12
14.6%
7 9
11.0%
3 8
 
9.8%
4 8
 
9.8%
0 7
 
8.5%
8 5
 
6.1%
5 4
 
4.9%
9 4
 
4.9%
6 3
 
3.7%
Space Separator
ValueCountFrequency (%)
18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 447
80.7%
Common 107
 
19.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
101
22.6%
25
 
5.6%
13
 
2.9%
13
 
2.9%
12
 
2.7%
12
 
2.7%
11
 
2.5%
10
 
2.2%
9
 
2.0%
9
 
2.0%
Other values (81) 232
51.9%
Common
ValueCountFrequency (%)
1 22
20.6%
18
16.8%
2 12
11.2%
7 9
8.4%
3 8
 
7.5%
4 8
 
7.5%
0 7
 
6.5%
8 5
 
4.7%
5 4
 
3.7%
9 4
 
3.7%
Other values (4) 10
9.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 447
80.7%
ASCII 107
 
19.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
101
22.6%
25
 
5.6%
13
 
2.9%
13
 
2.9%
12
 
2.7%
12
 
2.7%
11
 
2.5%
10
 
2.2%
9
 
2.0%
9
 
2.0%
Other values (81) 232
51.9%
ASCII
ValueCountFrequency (%)
1 22
20.6%
18
16.8%
2 12
11.2%
7 9
8.4%
3 8
 
7.5%
4 8
 
7.5%
0 7
 
6.5%
8 5
 
4.7%
5 4
 
3.7%
9 4
 
3.7%
Other values (4) 10
9.3%

허용구간
Text

MISSING 

Distinct93
Distinct (%)92.1%
Missing8
Missing (%)7.3%
Memory size1004.0 B
2023-12-13T08:19:25.685494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length209
Median length135
Mean length102.35644
Min length18

Characters and Unicode

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

Unique

Unique85 ?
Unique (%)84.2%

Sample

1st row[계족로 664번길,1819182.6194,994075.3321],[계족로 664번길,1819195.1157,994234.8434]
2nd row[문평동로 18번길,1827712.1382,991417.1546], [문평동로 18번길,1827833.6069,991552.6881]
3rd row[대전로 1033번길,1816418.9812,992361.8815,1816414.7960,992366.2332],[대전로 1032번길,1816678.0396,992623.1373,1816669.8975,992631.1548]
4th row[한남로 1049번길,1816423.5831,992512.8552,1816418.7673,992496.3824],[한남로 149번길,1816578.0954,992356.3406,1816567.4207,992345.8025]
5th row[대전로 1365번길,1819870.3313,993065.9719],[대전로 1365번길,1819521.0523,992972.3914]
ValueCountFrequency (%)
없음 5
 
1.6%
만년동 4
 
1.3%
대전로 3
 
1.0%
월평북로 2
 
0.7%
77~마포 2
 
0.7%
숯불갈비 2
 
0.7%
폴리라인 2
 
0.7%
한야,1824377.4205,992072.9256],테크노10로 2
 
0.7%
59,1824351.6946,991669.5366],[올제텍 2
 
0.7%
29 2
 
0.7%
Other values (240) 278
91.4%
2023-12-13T08:19:25.959268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1081
 
10.5%
9 963
 
9.3%
8 893
 
8.6%
, 702
 
6.8%
2 637
 
6.2%
4 572
 
5.5%
. 548
 
5.3%
3 536
 
5.2%
5 497
 
4.8%
6 496
 
4.8%
Other values (279) 3413
33.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 6605
63.9%
Other Letter 1609
 
15.6%
Other Punctuation 1251
 
12.1%
Open Punctuation 301
 
2.9%
Close Punctuation 299
 
2.9%
Space Separator 203
 
2.0%
Uppercase Letter 34
 
0.3%
Lowercase Letter 19
 
0.2%
Dash Punctuation 10
 
0.1%
Math Symbol 7
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
101
 
6.3%
69
 
4.3%
53
 
3.3%
35
 
2.2%
32
 
2.0%
28
 
1.7%
26
 
1.6%
26
 
1.6%
26
 
1.6%
25
 
1.6%
Other values (240) 1188
73.8%
Lowercase Letter
ValueCountFrequency (%)
l 3
15.8%
i 2
10.5%
t 2
10.5%
n 2
10.5%
a 2
10.5%
p 2
10.5%
m 2
10.5%
d 1
 
5.3%
r 1
 
5.3%
o 1
 
5.3%
Decimal Number
ValueCountFrequency (%)
1 1081
16.4%
9 963
14.6%
8 893
13.5%
2 637
9.6%
4 572
8.7%
3 536
8.1%
5 497
7.5%
6 496
7.5%
0 480
7.3%
7 450
6.8%
Uppercase Letter
ValueCountFrequency (%)
S 11
32.4%
B 8
23.5%
K 8
23.5%
T 2
 
5.9%
I 2
 
5.9%
G 1
 
2.9%
D 1
 
2.9%
M 1
 
2.9%
Other Punctuation
ValueCountFrequency (%)
, 702
56.1%
. 548
43.8%
/ 1
 
0.1%
Close Punctuation
ValueCountFrequency (%)
] 258
86.3%
) 41
 
13.7%
Open Punctuation
ValueCountFrequency (%)
[ 258
85.7%
( 43
 
14.3%
Space Separator
ValueCountFrequency (%)
203
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%
Math Symbol
ValueCountFrequency (%)
~ 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 8676
83.9%
Hangul 1609
 
15.6%
Latin 53
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
101
 
6.3%
69
 
4.3%
53
 
3.3%
35
 
2.2%
32
 
2.0%
28
 
1.7%
26
 
1.6%
26
 
1.6%
26
 
1.6%
25
 
1.6%
Other values (240) 1188
73.8%
Common
ValueCountFrequency (%)
1 1081
12.5%
9 963
11.1%
8 893
10.3%
, 702
8.1%
2 637
 
7.3%
4 572
 
6.6%
. 548
 
6.3%
3 536
 
6.2%
5 497
 
5.7%
6 496
 
5.7%
Other values (10) 1751
20.2%
Latin
ValueCountFrequency (%)
S 11
20.8%
B 8
15.1%
K 8
15.1%
l 3
 
5.7%
T 2
 
3.8%
i 2
 
3.8%
t 2
 
3.8%
n 2
 
3.8%
a 2
 
3.8%
p 2
 
3.8%
Other values (9) 11
20.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8729
84.4%
Hangul 1609
 
15.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1081
12.4%
9 963
11.0%
8 893
10.2%
, 702
 
8.0%
2 637
 
7.3%
4 572
 
6.6%
. 548
 
6.3%
3 536
 
6.1%
5 497
 
5.7%
6 496
 
5.7%
Other values (29) 1804
20.7%
Hangul
ValueCountFrequency (%)
101
 
6.3%
69
 
4.3%
53
 
3.3%
35
 
2.2%
32
 
2.0%
28
 
1.7%
26
 
1.6%
26
 
1.6%
26
 
1.6%
25
 
1.6%
Other values (240) 1188
73.8%

연장
Real number (ℝ)

Distinct51
Distinct (%)46.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.43507339
Minimum0.03
Maximum2
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-13T08:19:26.064975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.03
5-th percentile0.088
Q10.175
median0.32
Q30.5
95-th percentile1.2
Maximum2
Range1.97
Interquartile range (IQR)0.325

Descriptive statistics

Standard deviation0.39280062
Coefficient of variation (CV)0.9028376
Kurtosis3.3246427
Mean0.43507339
Median Absolute Deviation (MAD)0.16
Skewness1.8767695
Sum47.423
Variance0.15429233
MonotonicityNot monotonic
2023-12-13T08:19:26.184857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.32 8
 
7.3%
0.3 7
 
6.4%
0.4 6
 
5.5%
0.15 6
 
5.5%
0.2 5
 
4.6%
0.26 4
 
3.7%
0.5 4
 
3.7%
0.6 4
 
3.7%
0.1 4
 
3.7%
1.2 4
 
3.7%
Other values (41) 57
52.3%
ValueCountFrequency (%)
0.03 1
 
0.9%
0.04 1
 
0.9%
0.06 2
1.8%
0.07 1
 
0.9%
0.08 1
 
0.9%
0.1 4
3.7%
0.115 1
 
0.9%
0.12 3
2.8%
0.13 1
 
0.9%
0.135 2
1.8%
ValueCountFrequency (%)
2.0 1
 
0.9%
1.64 2
1.8%
1.6 1
 
0.9%
1.4 1
 
0.9%
1.2 4
3.7%
1.18 1
 
0.9%
1.1 1
 
0.9%
1.0 3
2.8%
0.9 3
2.8%
0.6 4
3.7%

허용구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1004.0 B
1
63 
2
46 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 63
57.8%
2 46
42.2%

Length

2023-12-13T08:19:26.303950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:26.373455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 63
57.8%
2 46
42.2%

허용시간
Categorical

HIGH CORRELATION 

Distinct41
Distinct (%)37.6%
Missing0
Missing (%)0.0%
Memory size1004.0 B
09:00~18:00 (1회, 15분이내)
11 
매일(24시간) 노상주차장설치
10:00 ~ 17:00 (1회, 15분이내)
06:00~24:00
07~21금지, 단, 주말 공휴일24시간허용
 
6
Other values (36)
67 

Length

Max length49
Median length38
Mean length22.174312
Min length11

Unique

Unique21 ?
Unique (%)19.3%

Sample

1st row11:30∼14:00 (점심시간)
2nd row09:00∼18:00 (시간제 주차허용)
3rd row09:00∼18:00 (시간제 주차허용)
4th row09:00∼18:00 (시간제 주차허용)
5th row20:00∼07:00 (시간제 주차허용)

Common Values

ValueCountFrequency (%)
09:00~18:00 (1회, 15분이내) 11
 
10.1%
매일(24시간) 노상주차장설치 9
 
8.3%
10:00 ~ 17:00 (1회, 15분이내) 8
 
7.3%
06:00~24:00 8
 
7.3%
07~21금지, 단, 주말 공휴일24시간허용 6
 
5.5%
09:00∼18:00 (시간제 주차허용) 6
 
5.5%
11:30∼14:00 (점심시간) 6
 
5.5%
도심주차허용, 토요일공휴일 07~20 허용 4
 
3.7%
09:00~18:00(2시간이내)(금지시간) 4
 
3.7%
18:00~09:00(금지시간) 3
 
2.8%
Other values (31) 44
40.4%

Length

2023-12-13T08:19:26.461838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1회 22
 
7.2%
09:00~18:00 21
 
6.9%
주차허용 21
 
6.9%
15분이내 20
 
6.5%
10
 
3.3%
시간제 10
 
3.3%
매일(24시간 9
 
2.9%
노상주차장설치 9
 
2.9%
06:00~24:00 9
 
2.9%
공휴일 9
 
2.9%
Other values (65) 166
54.2%

용도
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)7.3%
Missing0
Missing (%)0.0%
Memory size1004.0 B
탄력적주정차
50 
택배소형화물차량
22 
공휴일도심주차
16 
재래시장편
14 
재래시장편(한시적, 명절기간)
 
3
Other values (3)
 
4

Length

Max length16
Median length11
Mean length6.8623853
Min length5

Unique

Unique2 ?
Unique (%)1.8%

Sample

1st row탄력적주정차
2nd row탄력적주정차
3rd row탄력적주정차
4th row탄력적주정차
5th row탄력적주정차

Common Values

ValueCountFrequency (%)
탄력적주정차 50
45.9%
택배소형화물차량 22
20.2%
공휴일도심주차 16
 
14.7%
재래시장편 14
 
12.8%
재래시장편(한시적, 명절기간) 3
 
2.8%
공휴일도심주차(종교) 2
 
1.8%
재래시장편(상시) 1
 
0.9%
공휴일도심주차(체육) 1
 
0.9%

Length

2023-12-13T08:19:26.562811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:26.646755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
탄력적주정차 50
44.6%
택배소형화물차량 22
19.6%
공휴일도심주차 16
 
14.3%
재래시장편 14
 
12.5%
재래시장편(한시적 3
 
2.7%
명절기간 3
 
2.7%
공휴일도심주차(종교 2
 
1.8%
재래시장편(상시 1
 
0.9%
공휴일도심주차(체육 1
 
0.9%

대표이미지
Categorical

HIGH CORRELATION 

Distinct27
Distinct (%)24.8%
Missing0
Missing (%)0.0%
Memory size1004.0 B
1,2
26 
1
23 
<NA>
16 
1, 2
10 
1,2,3
Other values (22)
26 

Length

Max length7
Median length5
Mean length2.8807339
Min length1

Unique

Unique21 ?
Unique (%)19.3%

Sample

1st row2
2nd row5
3rd row7
4th row8
5th row9

Common Values

ValueCountFrequency (%)
1,2 26
23.9%
1 23
21.1%
<NA> 16
14.7%
1, 2 10
 
9.2%
1,2,3 8
 
7.3%
1, 2, 3 5
 
4.6%
55 1
 
0.9%
7 1
 
0.9%
8 1
 
0.9%
9 1
 
0.9%
Other values (17) 17
15.6%

Length

2023-12-13T08:19:26.749363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1 38
29.5%
1,2 26
20.2%
na 16
12.4%
2 16
12.4%
1,2,3 8
 
6.2%
3 6
 
4.7%
16 1
 
0.8%
15 1
 
0.8%
11 1
 
0.8%
58 1
 
0.8%
Other values (15) 15
 
11.6%

허용일자
Date

MISSING 

Distinct10
Distinct (%)10.1%
Missing10
Missing (%)9.2%
Memory size1004.0 B
Minimum2009-12-17 00:00:00
Maximum2020-11-18 00:00:00
2023-12-13T08:19:26.830893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T08:19:27.214717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)

기타
Text

MISSING 

Distinct40
Distinct (%)71.4%
Missing53
Missing (%)48.6%
Memory size1004.0 B
2023-12-13T08:19:27.433896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length131
Median length87.5
Mean length55.678571
Min length3

Characters and Unicode

Total characters3118
Distinct characters298
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)50.0%

Sample

1st row법2동 행정복지센터앞 태극안경점까지 표지판이 없어 대전경찰청 자료 참고함
2nd row엑셀데이터 위치와 실제 표지판위기가 달라 실제 표지판 위치로 함
3rd row위치를 못찾겠음
4th row엑셀데이터의 학원이 없어저서 위치를 찾지 못하겠음
5th row주소오류
ValueCountFrequency (%)
31
 
5.6%
수정함 12
 
2.2%
시/종점 11
 
2.0%
맞은편 11
 
2.0%
중복 8
 
1.5%
구간 8
 
1.5%
있음 7
 
1.3%
화물차 6
 
1.1%
없음 6
 
1.1%
주소오류 6
 
1.1%
Other values (286) 445
80.8%
2023-12-13T08:19:27.776189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
498
 
16.0%
0 104
 
3.3%
1 92
 
3.0%
, 91
 
2.9%
2 56
 
1.8%
3 55
 
1.8%
( 53
 
1.7%
5 53
 
1.7%
) 51
 
1.6%
51
 
1.6%
Other values (288) 2014
64.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1616
51.8%
Decimal Number 531
 
17.0%
Space Separator 498
 
16.0%
Other Punctuation 196
 
6.3%
Open Punctuation 61
 
2.0%
Close Punctuation 59
 
1.9%
Uppercase Letter 51
 
1.6%
Math Symbol 46
 
1.5%
Dash Punctuation 31
 
1.0%
Lowercase Letter 21
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
51
 
3.2%
50
 
3.1%
49
 
3.0%
39
 
2.4%
37
 
2.3%
36
 
2.2%
35
 
2.2%
31
 
1.9%
30
 
1.9%
28
 
1.7%
Other values (246) 1230
76.1%
Decimal Number
ValueCountFrequency (%)
0 104
19.6%
1 92
17.3%
2 56
10.5%
3 55
10.4%
5 53
10.0%
4 44
8.3%
8 43
8.1%
9 29
 
5.5%
6 28
 
5.3%
7 27
 
5.1%
Uppercase Letter
ValueCountFrequency (%)
S 10
19.6%
L 8
15.7%
K 6
11.8%
B 6
11.8%
G 4
 
7.8%
A 4
 
7.8%
O 4
 
7.8%
W 4
 
7.8%
T 3
 
5.9%
D 2
 
3.9%
Lowercase Letter
ValueCountFrequency (%)
m 10
47.6%
o 2
 
9.5%
r 2
 
9.5%
k 2
 
9.5%
x 2
 
9.5%
d 1
 
4.8%
l 1
 
4.8%
w 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
, 91
46.4%
. 48
24.5%
/ 31
 
15.8%
: 18
 
9.2%
' 8
 
4.1%
Open Punctuation
ValueCountFrequency (%)
( 53
86.9%
[ 8
 
13.1%
Close Punctuation
ValueCountFrequency (%)
) 51
86.4%
] 8
 
13.6%
Math Symbol
ValueCountFrequency (%)
> 25
54.3%
~ 21
45.7%
Space Separator
ValueCountFrequency (%)
498
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1616
51.8%
Common 1430
45.9%
Latin 72
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
51
 
3.2%
50
 
3.1%
49
 
3.0%
39
 
2.4%
37
 
2.3%
36
 
2.2%
35
 
2.2%
31
 
1.9%
30
 
1.9%
28
 
1.7%
Other values (246) 1230
76.1%
Common
ValueCountFrequency (%)
498
34.8%
0 104
 
7.3%
1 92
 
6.4%
, 91
 
6.4%
2 56
 
3.9%
3 55
 
3.8%
( 53
 
3.7%
5 53
 
3.7%
) 51
 
3.6%
. 48
 
3.4%
Other values (14) 329
23.0%
Latin
ValueCountFrequency (%)
S 10
13.9%
m 10
13.9%
L 8
11.1%
K 6
8.3%
B 6
8.3%
G 4
 
5.6%
A 4
 
5.6%
O 4
 
5.6%
W 4
 
5.6%
T 3
 
4.2%
Other values (8) 13
18.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1616
51.8%
ASCII 1502
48.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
498
33.2%
0 104
 
6.9%
1 92
 
6.1%
, 91
 
6.1%
2 56
 
3.7%
3 55
 
3.7%
( 53
 
3.5%
5 53
 
3.5%
) 51
 
3.4%
. 48
 
3.2%
Other values (32) 401
26.7%
Hangul
ValueCountFrequency (%)
51
 
3.2%
50
 
3.1%
49
 
3.0%
39
 
2.4%
37
 
2.3%
36
 
2.2%
35
 
2.2%
31
 
1.9%
30
 
1.9%
28
 
1.7%
Other values (246) 1230
76.1%

Interactions

2023-12-13T08:19:23.904839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T08:19:27.864810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명시군구코드도로명허용구간연장허용구분허용시간용도대표이미지허용일자기타
시군구명1.0001.0000.9951.0000.0900.2000.8690.3630.8900.9200.980
시군구코드1.0001.0000.9951.0000.0810.1630.8650.3400.8940.9200.980
도로명0.9950.9951.0001.0000.7340.9030.9400.0000.9950.9900.985
허용구간1.0001.0001.0001.0000.9991.0000.9950.9801.0001.0001.000
연장0.0900.0810.7340.9991.0000.3890.0000.0000.0000.0000.960
허용구분0.2000.1630.9031.0000.3891.0000.7700.5210.2060.3320.877
허용시간0.8690.8650.9400.9950.0000.7701.0000.9750.0000.8020.976
용도0.3630.3400.0000.9800.0000.5210.9751.0000.2830.0000.949
대표이미지0.8900.8940.9951.0000.0000.2060.0000.2831.0000.7881.000
허용일자0.9200.9200.9901.0000.0000.3320.8020.0000.7881.0000.000
기타0.9800.9800.9851.0000.9600.8770.9760.9491.0000.0001.000
2023-12-13T08:19:27.972324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
용도시군구코드허용구분허용시간대표이미지시군구명
용도1.0000.2120.3810.6910.0940.228
시군구코드0.2121.0000.1960.4950.5980.967
허용구분0.3810.1961.0000.5300.1290.240
허용시간0.6910.4950.5301.0000.0000.500
대표이미지0.0940.5980.1290.0001.0000.591
시군구명0.2280.9670.2400.5000.5911.000
2023-12-13T08:19:28.060152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연장시군구명시군구코드허용구분허용시간용도대표이미지
연장1.0000.0430.0370.3750.0000.0000.000
시군구명0.0431.0000.9670.2400.5000.2280.591
시군구코드0.0370.9671.0000.1960.4950.2120.598
허용구분0.3750.2400.1961.0000.5300.3810.129
허용시간0.0000.5000.4950.5301.0000.6910.000
용도0.0000.2280.2120.3810.6911.0000.094
대표이미지0.0000.5910.5980.1290.0000.0941.000

Missing values

2023-12-13T08:19:24.002094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T08:19:24.121422image/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.
2023-12-13T08:19:24.218894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

관리번호시군구명시군구코드도로명허용구간연장허용구분허용시간용도대표이미지허용일자기타
03680000_ALLOW_00002대덕구3680000계족로664번길[계족로 664번길,1819182.6194,994075.3321],[계족로 664번길,1819195.1157,994234.8434]0.1111:30∼14:00 (점심시간)탄력적주정차22015-05-12<NA>
13680000_ALLOW_00005대덕구3680000문평동로18번길[문평동로 18번길,1827712.1382,991417.1546], [문평동로 18번길,1827833.6069,991552.6881]0.304109:00∼18:00 (시간제 주차허용)탄력적주정차52015-06-17<NA>
23680000_ALLOW_00007대덕구3680000대전로1033번길20[대전로 1033번길,1816418.9812,992361.8815,1816414.7960,992366.2332],[대전로 1032번길,1816678.0396,992623.1373,1816669.8975,992631.1548]0.22209:00∼18:00 (시간제 주차허용)탄력적주정차72015-06-17<NA>
33680000_ALLOW_00008대덕구3680000한남로149번길[한남로 1049번길,1816423.5831,992512.8552,1816418.7673,992496.3824],[한남로 149번길,1816578.0954,992356.3406,1816567.4207,992345.8025]0.51209:00∼18:00 (시간제 주차허용)탄력적주정차82015-06-17<NA>
43680000_ALLOW_00009대덕구3680000대전로1365번길[대전로 1365번길,1819870.3313,993065.9719],[대전로 1365번길,1819521.0523,992972.3914]0.467120:00∼07:00 (시간제 주차허용)탄력적주정차92015-06-17<NA>
53680000_ALLOW_00010대덕구3680000쌍청당로 25[대덕청소년수련관 입구,1818588.9675,994132.1136],[미성종합건설,1818360.6444,994182.2655]0.15106:00~24:00공휴일도심주차102009-12-17<NA>
63680000_ALLOW_00012대덕구3660000중리시장 정문[중리시장정문,1818502.3858,993294.7989,1818502.0770,993273.8203],[회덕농협,1818703.8559,993287.5063,1818703.8559,993268.4842]1.2218:00~20:00/07:00~09:00(금지시간)재래시장편12<NA><NA>
73680000_ALLOW_00001대덕구3680000중리서로 (중리동448)[중리서로,11818063.4133,992901.2451,1818068.7927,992883.0225],[영진로얄아파트,1818159.0756,992930.3780,1818164.5027,992911.9982]0.25211:30∼14:00 (점심시간)탄력적주정차12015-05-12<NA>
83680000_ALLOW_00014대덕구3680000동춘당로 187[법2동 행정복지센터,1818874.0530,993776.0722],[태극안경점,1818934.1225,994043.7155]0.06109:00~18:00(2시간이내)(금지시간)재래시장편14<NA>법2동 행정복지센터앞 태극안경점까지 표지판이 없어 대전경찰청 자료 참고함
93680000_ALLOW_00004대덕구3680000신탄진동로[신탄진동로,1827792.0519,993804.1065,1827772.4967,993808.3006],[반석연립,1827875.7883,994195.2436,1827856.2330,994199.4377]0.456211:30∼14:00 (점심시간)탄력적주정차42015-06-17<NA>
관리번호시군구명시군구코드도로명허용구간연장허용구분허용시간용도대표이미지허용일자기타
993660000_ALLOW_00052서구3660000천변도시고속화도로[한밭교회,1818722.96899999,988383.691299999],[만년고,1818939.64744552,988591.177326624]0.31한밭교회표지판(공휴일 주차허용, 06~24), 만년고표지판(06~15공휴일 주차허용)공휴일도심주차1,2,32020-11-18시점 수정함, 허용시간 시/종점간 불일치 : 시점(갑천3가 -> 한밭교회), 시점(공휴일06~24허용)/종점(공휴일06~15허용)
1003660000_ALLOW_00044서구3660000갈마로[내동지구대,1815163.95714819,989348.123259059],[맑은아침아파트 상가 앞,1815067.06835935,989442.131570386]0.1351평일07~09, 18~20제외 모든시간 허용탄력적주정차1,22020-11-18평일07~09, 18~20제외 모든시간 허용, 해당구간과 겹치는 허용구간 있음 평일18~09금지, 전통시장이용객2시간허용, 1.5톤이하 화물차 제외(10:00~17:00, 15분이내)
1013660000_ALLOW_00038서구3660000별곡로[가수원4가,1811961.88772417,986827.186640712],[은아아파트 505동,1811026.60155623,987113.553867176]1.0107~21금지, 단, 주말 공휴일24시간허용탄력적주정차1,22020-11-18시/종점 수정함, 시점(가수원4가->벌곡로 1385(가수원네거리) / 종점(벌곡로 1324 맞은편(은아아파트 505동 앞))
1023660000_ALLOW_00045서구3660000동서대로[동구 동서대로 1654(제자들교회),1816715.59467082,994051.146027525],[동구 동서대로 1664(현대오일뱅크 재하주유소,1816754.46757007,994143.281241769]0.11공휴일 주차허용 06~15공휴일도심주차1,22020-11-18시/종점 수정함, 시점(용전4가 -> 동구 동서대로 1654(제자들교회) / 종점(동구 동서대로 1664(현대오일뱅크 재하주유쇼, 버거킹대전터미널DT점))
1033660000_ALLOW_00048서구3660000대덕대로[GS내동주유소,1815397.63520508,988597.71270687],[괴정고가차도 입구(괴정동 산 14-8),1815572.14084152,988641.846399806]0.181공휴일 주차허용 06~15공휴일도심주차1,22020-11-18시/종점/연장 수정함 : 시점(GS주유소-> GS칼텍스 GS내동주유소) / 종점(괴정육교-> 괴정고가차도 전) / 연장 표지판 표기(180m)에 따라 수정(0.25->018), GS주유소에서 대덕대로 북쪽방향구간임, 공공데
1043660000_ALLOW_00049서구3660000대덕대로[대덕구 대덕대로 1605(Tworld),1828127.44217824,993379.867585851],[대덕대로 1591(충남정육점),1828099.50217821,993230.769585699]0.151주정차금지시간 24시간, 5일장날 전일허용공휴일도심주차1,22020-11-18시/종점 수정함, 시점(보건당약국 -> 대덕구 대덕대로 1605(Tworld) 대덕대로 서쪽방향 구간시작) / 종점(국민은행 -> 대덕대로 1591(충남정육점) 구간끝)
1053660000_ALLOW_00047서구3660000구봉산북로시점(동방고3가) / 종점(예비군훈련장4가), 해당시점으로 알 수 없음, 구축데이터1.1106~15공휴일주차허용공휴일도심주차<NA>2020-11-18동방고3가, 예비군훈련장4가 특정불가. 위치가 어디인지, 서구예비군훈련장, 느리울초교 네거리부터 훈련장입구까지 거리비슷
1063660000_ALLOW_00053서구3660000유등로[변동새한(아)5동 맞은편,1814267.72686825,989885.673996077],[동서대로 1144-24 맞은편,1814395.58043794,989964.118018912]0.241도심주차허용, 토요일공휴일 07~20 허용탄력적주정차<NA>2020-11-18시/종점 수정함, 32,53 중복 : 시점(변동세한 5동 맞은편->변동 새한 5동 맞은편) / 종점(가장교->동서대로 1144-24(유등로 맞은편 구간 끝)), 3660000_ALLOW_00053과 중복, 연장(0.24 -> 0.15)
1073660000_ALLOW_00054서구3660000유등로[유등로 427-1(신우빌라)맞은편,1814578.62286857,990072.617996268],[유등로 441 맞은편,1814764.76640731,990254.140950706]0.261도심주차허용, 토요일공휴일 07~20 허용탄력적주정차<NA>2020-11-18시/종점 수정함, 33,54 중복 : 시점(가장교 -> 유등로 427-1(신우빌라) 맞은편 / 종점 쌍용자동차 서비스프라자 맞은편 -> 유등로 441 맞은편), 3660000_ALLOW_00054와 중복
1083660000_ALLOW_00051서구3660000천변도시고속화도로[월평북로 주공아파트 104동 105동 사이 맞은편,1818584.53899999,988198.7793],[하나로아파트 112동 뒤,1818288.883,987761.3913]0.31공휴일 주차허용 06~24공휴일도심주차<NA>2020-11-1850구간과 51구간 합쳐진 듯함, 공공데이터 포털 경찰청자료에 '선사로, 갑천3가~하나로(아)112동 뒤' / '갑천대로, 갑천3가~하나로(아) 112동 뒤' 각 연장 300m로 돼 있음, 현시점 표지판은 시/종점 300m