Overview

Dataset statistics

Number of variables5
Number of observations133
Missing cells0
Missing cells (%)0.0%
Duplicate rows5
Duplicate rows (%)3.8%
Total size in memory5.7 KiB
Average record size in memory44.0 B

Variable types

Categorical4
Text1

Dataset

Description전라남도 순천시 도로 안전시설물 설치 및 보수 현황 정보입니다. 도로명, 과속방지턱설치장소, 설치년도 등의 항목을 제공합니다.
Author전라남도 순천시
URLhttps://www.data.go.kr/data/3072871/fileData.do

Alerts

적법설치규격(높이) has constant value ""Constant
적법설치규격(폭) has constant value ""Constant
Dataset has 5 (3.8%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 07:10:21.682171
Analysis finished2023-12-12 07:10:21.989285
Duration0.31 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

도로명
Categorical

Distinct6
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
시도
96 
군도
22 
농어촌도로
 
6
지방도
 
5
군도15호선
 
3

Length

Max length6
Median length2
Mean length2.2706767
Min length2

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row시도
2nd row시도
3rd row군도
4th row군도
5th row시도

Common Values

ValueCountFrequency (%)
시도 96
72.2%
군도 22
 
16.5%
농어촌도로 6
 
4.5%
지방도 5
 
3.8%
군도15호선 3
 
2.3%
국지도 1
 
0.8%

Length

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

Common Values (Plot)

2023-12-12T16:10:22.144581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시도 96
72.2%
군도 22
 
16.5%
농어촌도로 6
 
4.5%
지방도 5
 
3.8%
군도15호선 3
 
2.3%
국지도 1
 
0.8%

과속방지턱설치장소
Text

Distinct126
Distinct (%)94.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T16:10:22.342586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length21
Mean length12.706767
Min length7

Characters and Unicode

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

Unique

Unique121 ?
Unique (%)91.0%

Sample

1st row순천시 백연길 105 인근
2nd row순천시 성동2길 28
3rd row주암면 구산리 691-1(구산리 691 인접)
4th row구산리 587-5(구산리 597-1 인접)
5th row풍덕동 장평3길
ValueCountFrequency (%)
앞 29
 
8.7%
별량면 15
 
4.5%
해룡면 13
 
3.9%
덕암동 9
 
2.7%
오천동 7
 
2.1%
왕지동 5
 
1.5%
조례동 5
 
1.5%
덕월동 4
 
1.2%
입구 4
 
1.2%
옆 4
 
1.2%
Other values (199) 239
71.6%
2023-12-12T16:10:22.729410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
203
 
12.0%
동 78
 
4.6%
1 77
 
4.6%
- 53
 
3.1%
앞 51
 
3.0%
2 51
 
3.0%
면 43
 
2.5%
길 38
 
2.2%
리 33
 
2.0%
지 32
 
1.9%
Other values (177) 1031
61.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1047
62.0%
Decimal Number 327
 
19.3%
Space Separator 203
 
12.0%
Dash Punctuation 53
 
3.1%
Open Punctuation 28
 
1.7%
Close Punctuation 28
 
1.7%
Other Punctuation 3
 
0.2%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 78
 
7.4%
앞 51
 
4.9%
면 43
 
4.1%
길 38
 
3.6%
리 33
 
3.2%
지 32
 
3.1%
암 25
 
2.4%
구 25
 
2.4%
번 24
 
2.3%
향 21
 
2.0%
Other values (160) 677
64.7%
Decimal Number
ValueCountFrequency (%)
1 77
23.5%
2 51
15.6%
3 30
 
9.2%
4 30
 
9.2%
9 29
 
8.9%
5 28
 
8.6%
8 25
 
7.6%
6 22
 
6.7%
7 19
 
5.8%
0 16
 
4.9%
Other Punctuation
ValueCountFrequency (%)
, 2
66.7%
@ 1
33.3%
Space Separator
ValueCountFrequency (%)
203
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 53
100.0%
Open Punctuation
ValueCountFrequency (%)
( 28
100.0%
Close Punctuation
ValueCountFrequency (%)
) 28
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1047
62.0%
Common 643
38.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 78
 
7.4%
앞 51
 
4.9%
면 43
 
4.1%
길 38
 
3.6%
리 33
 
3.2%
지 32
 
3.1%
암 25
 
2.4%
구 25
 
2.4%
번 24
 
2.3%
향 21
 
2.0%
Other values (160) 677
64.7%
Common
ValueCountFrequency (%)
203
31.6%
1 77
 
12.0%
- 53
 
8.2%
2 51
 
7.9%
3 30
 
4.7%
4 30
 
4.7%
9 29
 
4.5%
( 28
 
4.4%
) 28
 
4.4%
5 28
 
4.4%
Other values (7) 86
13.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1047
62.0%
ASCII 643
38.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
203
31.6%
1 77
 
12.0%
- 53
 
8.2%
2 51
 
7.9%
3 30
 
4.7%
4 30
 
4.7%
9 29
 
4.5%
( 28
 
4.4%
) 28
 
4.4%
5 28
 
4.4%
Other values (7) 86
13.4%
Hangul
ValueCountFrequency (%)
동 78
 
7.4%
앞 51
 
4.9%
면 43
 
4.1%
길 38
 
3.6%
리 33
 
3.2%
지 32
 
3.1%
암 25
 
2.4%
구 25
 
2.4%
번 24
 
2.3%
향 21
 
2.0%
Other values (160) 677
64.7%

설치년도
Categorical

Distinct4
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2010
102 
2013
16 
2015
14 
2014
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)0.8%

Sample

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

Common Values

ValueCountFrequency (%)
2010 102
76.7%
2013 16
 
12.0%
2015 14
 
10.5%
2014 1
 
0.8%

Length

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

Common Values (Plot)

2023-12-12T16:10:22.977386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2010 102
76.7%
2013 16
 
12.0%
2015 14
 
10.5%
2014 1
 
0.8%

적법설치규격(높이)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
10
133 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 133
100.0%

Length

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

Common Values (Plot)

2023-12-12T16:10:23.174423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 133
100.0%

적법설치규격(폭)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
3.6
133 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3.6
2nd row3.6
3rd row3.6
4th row3.6
5th row3.6

Common Values

ValueCountFrequency (%)
3.6 133
100.0%

Length

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

Common Values (Plot)

2023-12-12T16:10:23.618810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3.6 133
100.0%

Correlations

2023-12-12T16:10:23.668446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도로명설치년도
도로명1.0000.350
설치년도0.3501.000
2023-12-12T16:10:23.741287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치년도도로명
설치년도1.0000.230
도로명0.2301.000
2023-12-12T16:10:23.811407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도로명설치년도
도로명1.0000.230
설치년도0.2301.000

Missing values

2023-12-12T16:10:21.867708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:10:21.953607image/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시도순천시 백연길 105 인근2015103.6
1시도순천시 성동2길 282015103.6
2군도주암면 구산리 691-1(구산리 691 인접)2015103.6
3군도구산리 587-5(구산리 597-1 인접)2015103.6
4시도풍덕동 장평3길2015103.6
5시도풍덕동 장평로 3길 사거리2015103.6
6군도별량면 무풍리 429-4번지2015103.6
7군도별량면 무풍리 568-2번지2015103.6
8군도상사면 오곡리 산86-1번지2015103.6
9시도이수1길 18, 울릉고물상 앞2015103.6
도로명과속방지턱설치장소설치년도적법설치규격(높이)적법설치규격(폭)
123시도왕지동 588-2 옆2010103.6
124시도왕지동 587-1(답) 옆2010103.6
125시도해룡면 신흥중학교 후문2010103.6
126시도해룡면 동신2차~부영8차사이2010103.6
127시도왕조2동주민센터옆2010103.6
128시도삼가동 삼거경로당 앞2010103.6
129시도향동 동해루 앞2010103.6
130시도향동 향교슈퍼 앞2010103.6
131시도향동 행금길 32집앞2010103.6
132시도향동 금곡길 112 집앞2010103.6

Duplicate rows

Most frequently occurring

도로명과속방지턱설치장소설치년도적법설치규격(높이)적법설치규격(폭)# duplicates
1시도덕암동 구암원길139-82010103.63
2시도덕암동 구암원길422-222010103.63
0군도15호선덕월동 월곡마을 앞2013103.62
3시도오천동 건우주택앞2010103.62
4시도오천동880-2번지2010103.62