Overview

Dataset statistics

Number of variables6
Number of observations95
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)1.1%
Total size in memory4.8 KiB
Average record size in memory51.4 B

Variable types

Categorical4
Text1
DateTime1

Dataset

Description보령시에 설치되어 있는 현수막 지정 게시대의 정보(설치 읍면동, 위치, 현수막 규격, 상업용 게시면수, 행정용 게시면수)를 제공하는 파일데이터 입니다. (제공부서: 도시과 041-930-3881)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=419&beforeMenuCd=DOM_000000201001001000&publicdatapk=15031394

Alerts

규격(m) has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 1 (1.1%) duplicate rowsDuplicates
게시면수(상업용) is highly overall correlated with 게시면수(행정용)High correlation
게시면수(행정용) is highly overall correlated with 읍면동 and 1 other fieldsHigh correlation
읍면동 is highly overall correlated with 게시면수(행정용)High correlation

Reproduction

Analysis started2024-01-09 22:49:05.964081
Analysis finished2024-01-09 22:49:06.294579
Duration0.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

읍면동
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)17.9%
Missing0
Missing (%)0.0%
Memory size892.0 B
대천4동
34 
남포면
8 
대천5동
7 
웅천읍
7 
대천3동
6 
Other values (12)
33 

Length

Max length5
Median length4
Mean length3.5894737
Min length3

Unique

Unique1 ?
Unique (%)1.1%

Sample

1st row남포면
2nd row남포면
3rd row남포면
4th row남포면
5th row남포면

Common Values

ValueCountFrequency (%)
대천4동 34
35.8%
남포면 8
 
8.4%
대천5동 7
 
7.4%
웅천읍 7
 
7.4%
대천3동 6
 
6.3%
주교면 5
 
5.3%
천북면 4
 
4.2%
대천2동 4
 
4.2%
대천1동 3
 
3.2%
오천면 3
 
3.2%
Other values (7) 14
14.7%

Length

2024-01-10T07:49:06.355156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
대천4동 34
35.8%
남포면 8
 
8.4%
대천5동 7
 
7.4%
웅천읍 7
 
7.4%
대천3동 6
 
6.3%
주교면 5
 
5.3%
천북면 4
 
4.2%
대천2동 4
 
4.2%
대천1동 4
 
4.2%
오천면 3
 
3.2%
Other values (6) 13
 
13.7%

위치
Text

Distinct76
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Memory size892.0 B
2024-01-10T07:49:06.585637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length10.894737
Min length5

Characters and Unicode

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

Unique

Unique75 ?
Unique (%)78.9%

Sample

1st row남포저수지 앞
2nd row남포중학교 입구
3rd row남포보건소 앞
4th row남포파출소 앞
5th row남포면사무소 앞
ValueCountFrequency (%)
앞 26
 
10.0%
터미널사거리 20
 
7.7%
신설사거리 20
 
7.7%
20
 
7.7%
삼거리 9
 
3.4%
입구 8
 
3.1%
2 6
 
2.3%
1 6
 
2.3%
주차장 6
 
2.3%
앞(1 5
 
1.9%
Other values (94) 135
51.7%
2024-01-10T07:49:06.929283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
175
 
16.9%
리 66
 
6.4%
거 53
 
5.1%
사 52
 
5.0%
앞 37
 
3.6%
) 30
 
2.9%
( 30
 
2.9%
신 27
 
2.6%
터 24
 
2.3%
미 24
 
2.3%
Other values (126) 517
50.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 744
71.9%
Space Separator 175
 
16.9%
Decimal Number 33
 
3.2%
Close Punctuation 30
 
2.9%
Open Punctuation 30
 
2.9%
Math Symbol 20
 
1.9%
Uppercase Letter 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 66
 
8.9%
거 53
 
7.1%
사 52
 
7.0%
앞 37
 
5.0%
신 27
 
3.6%
터 24
 
3.2%
미 24
 
3.2%
널 22
 
3.0%
설 22
 
3.0%
주 19
 
2.6%
Other values (115) 398
53.5%
Decimal Number
ValueCountFrequency (%)
1 16
48.5%
2 14
42.4%
3 2
 
6.1%
5 1
 
3.0%
Uppercase Letter
ValueCountFrequency (%)
G 1
33.3%
P 1
33.3%
L 1
33.3%
Space Separator
ValueCountFrequency (%)
175
100.0%
Close Punctuation
ValueCountFrequency (%)
) 30
100.0%
Open Punctuation
ValueCountFrequency (%)
( 30
100.0%
Math Symbol
ValueCountFrequency (%)
~ 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 744
71.9%
Common 288
 
27.8%
Latin 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 66
 
8.9%
거 53
 
7.1%
사 52
 
7.0%
앞 37
 
5.0%
신 27
 
3.6%
터 24
 
3.2%
미 24
 
3.2%
널 22
 
3.0%
설 22
 
3.0%
주 19
 
2.6%
Other values (115) 398
53.5%
Common
ValueCountFrequency (%)
175
60.8%
) 30
 
10.4%
( 30
 
10.4%
~ 20
 
6.9%
1 16
 
5.6%
2 14
 
4.9%
3 2
 
0.7%
5 1
 
0.3%
Latin
ValueCountFrequency (%)
G 1
33.3%
P 1
33.3%
L 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 744
71.9%
ASCII 291
 
28.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
175
60.1%
) 30
 
10.3%
( 30
 
10.3%
~ 20
 
6.9%
1 16
 
5.5%
2 14
 
4.8%
3 2
 
0.7%
5 1
 
0.3%
G 1
 
0.3%
P 1
 
0.3%
Hangul
ValueCountFrequency (%)
리 66
 
8.9%
거 53
 
7.1%
사 52
 
7.0%
앞 37
 
5.0%
신 27
 
3.6%
터 24
 
3.2%
미 24
 
3.2%
널 22
 
3.0%
설 22
 
3.0%
주 19
 
2.6%
Other values (115) 398
53.5%

규격(m)
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size892.0 B
5.6 x 0.7
95 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5.6 x 0.7
2nd row5.6 x 0.7
3rd row5.6 x 0.7
4th row5.6 x 0.7
5th row5.6 x 0.7

Common Values

ValueCountFrequency (%)
5.6 x 0.7 95
100.0%

Length

2024-01-10T07:49:07.040094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:49:07.110115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5.6 95
33.3%
x 95
33.3%
0.7 95
33.3%

게시면수(상업용)
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size892.0 B
5
48 
6
26 
0
20 
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.1%

Sample

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

Common Values

ValueCountFrequency (%)
5 48
50.5%
6 26
27.4%
0 20
21.1%
2 1
 
1.1%

Length

2024-01-10T07:49:07.183243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:49:07.264550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5 48
50.5%
6 26
27.4%
0 20
21.1%
2 1
 
1.1%

게시면수(행정용)
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size892.0 B
0
75 
1
20 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 75
78.9%
1 20
 
21.1%

Length

2024-01-10T07:49:07.348363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:49:07.423824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 75
78.9%
1 20
 
21.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size892.0 B
Minimum2019-09-06 00:00:00
Maximum2019-09-06 00:00:00
2024-01-10T07:49:07.487451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:49:07.559333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-10T07:49:07.620580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동위치게시면수(상업용)게시면수(행정용)
읍면동1.0001.0000.5440.669
위치1.0001.0001.0001.000
게시면수(상업용)0.5441.0001.0001.000
게시면수(행정용)0.6691.0001.0001.000
2024-01-10T07:49:07.706665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동게시면수(상업용)게시면수(행정용)
읍면동1.0000.3060.558
게시면수(상업용)0.3061.0000.989
게시면수(행정용)0.5580.9891.000
2024-01-10T07:49:07.787435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동게시면수(상업용)게시면수(행정용)
읍면동1.0000.3060.558
게시면수(상업용)0.3061.0000.989
게시면수(행정용)0.5580.9891.000

Missing values

2024-01-10T07:49:06.174318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:49:06.259472image/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

읍면동위치규격(m)게시면수(상업용)게시면수(행정용)데이터기준일자
0남포면남포저수지 앞5.6 x 0.7502019-09-06
1남포면남포중학교 입구5.6 x 0.7502019-09-06
2남포면남포보건소 앞5.6 x 0.7502019-09-06
3남포면남포파출소 앞5.6 x 0.7502019-09-06
4남포면남포면사무소 앞5.6 x 0.7502019-09-06
5남포면욕장 흑포 삼거리 (1)5.6 x 0.7602019-09-06
6남포면욕장 흑포 삼거리 (2)5.6 x 0.7602019-09-06
7남포면죽도 입구 앞5.6 x 0.7202019-09-06
8대천1동대천 체육관 앞(2)5.6 x 0.7602019-09-06
9대천1동대천노인복지관 앞5.6 x 0.7502019-09-06
읍면동위치규격(m)게시면수(상업용)게시면수(행정용)데이터기준일자
85대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
86대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
87대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
88대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
89대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
90대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
91대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
92대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
93대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06
94대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-06

Duplicate rows

Most frequently occurring

읍면동위치규격(m)게시면수(상업용)게시면수(행정용)데이터기준일자# duplicates
0대천4동터미널사거리 ~ 신설사거리5.6 x 0.7012019-09-0620