Overview

Dataset statistics

Number of variables6
Number of observations50
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory52.6 B

Variable types

Numeric1
Text2
Categorical3

Dataset

Description충청남도 청양군 옥외광고물 게시대명, 지번주소, 게시대 형태,규격,게시면 등에 대한 현황을 제공하고 있습니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=382&beforeMenuCd=DOM_000000201001001000&publicdatapk=15060559

Alerts

규격 is highly overall correlated with 게시면High correlation
게시면 is highly overall correlated with 규격High correlation

Reproduction

Analysis started2024-01-09 22:22:33.024298
Analysis finished2024-01-09 22:22:33.525569
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

Distinct49
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.38
Minimum1
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2024-01-10T07:22:33.581673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.45
Q112.25
median25.5
Q337.75
95-th percentile47.55
Maximum50
Range49
Interquartile range (IQR)25.5

Descriptive statistics

Standard deviation14.681503
Coefficient of variation (CV)0.57846742
Kurtosis-1.2315507
Mean25.38
Median Absolute Deviation (MAD)13
Skewness0.006286614
Sum1269
Variance215.54653
MonotonicityNot monotonic
2024-01-10T07:22:33.692587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
10 2
 
4.0%
1 1
 
2.0%
40 1
 
2.0%
30 1
 
2.0%
31 1
 
2.0%
32 1
 
2.0%
33 1
 
2.0%
34 1
 
2.0%
35 1
 
2.0%
36 1
 
2.0%
Other values (39) 39
78.0%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
5 1
2.0%
6 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 2
4.0%
ValueCountFrequency (%)
50 1
2.0%
49 1
2.0%
48 1
2.0%
47 1
2.0%
46 1
2.0%
45 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%
41 1
2.0%
Distinct45
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-01-10T07:22:33.907739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length20
Mean length17.32
Min length13

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)82.0%

Sample

1st row현수막지정게시대(주공(A)앞)
2nd row현수막지정게시대(백세공원)
3rd row현수막지정게시대(멜론농협창고입구)
4th row현수막지정게시대(청양교(옆))
5th row현수막지정게시대(청양공설운동장4거리)
ValueCountFrequency (%)
현수막지정게시대(면사무소(앞 3
 
5.9%
현수막지정게시대(우체국(앞 2
 
3.9%
현수막지정게시대(회전교차로군청(앞 2
 
3.9%
현수막지정게시대(면사무소광장(앞 2
 
3.9%
현수막지정게시대(청남삼거리 1
 
2.0%
현수막지정게시대(사거리(앞 1
 
2.0%
현수막지정게시대(주공(a)앞 1
 
2.0%
현수막지정게시대(쓰레기소각장(앞 1
 
2.0%
현수막지정게시대(안심교(앞 1
 
2.0%
현수막지정게시대(안심교(옆 1
 
2.0%
Other values (36) 36
70.6%
2024-01-10T07:22:34.200577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
) 90
 
10.4%
( 90
 
10.4%
55
 
6.4%
52
 
6.0%
52
 
6.0%
51
 
5.9%
50
 
5.8%
50
 
5.8%
50
 
5.8%
50
 
5.8%
Other values (105) 276
31.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 678
78.3%
Close Punctuation 90
 
10.4%
Open Punctuation 90
 
10.4%
Decimal Number 4
 
0.5%
Uppercase Letter 3
 
0.3%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
55
 
8.1%
52
 
7.7%
52
 
7.7%
51
 
7.5%
50
 
7.4%
50
 
7.4%
50
 
7.4%
50
 
7.4%
33
 
4.9%
13
 
1.9%
Other values (97) 222
32.7%
Uppercase Letter
ValueCountFrequency (%)
A 1
33.3%
C 1
33.3%
I 1
33.3%
Decimal Number
ValueCountFrequency (%)
4 3
75.0%
3 1
 
25.0%
Close Punctuation
ValueCountFrequency (%)
) 90
100.0%
Open Punctuation
ValueCountFrequency (%)
( 90
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 678
78.3%
Common 185
 
21.4%
Latin 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
55
 
8.1%
52
 
7.7%
52
 
7.7%
51
 
7.5%
50
 
7.4%
50
 
7.4%
50
 
7.4%
50
 
7.4%
33
 
4.9%
13
 
1.9%
Other values (97) 222
32.7%
Common
ValueCountFrequency (%)
) 90
48.6%
( 90
48.6%
4 3
 
1.6%
1
 
0.5%
3 1
 
0.5%
Latin
ValueCountFrequency (%)
A 1
33.3%
C 1
33.3%
I 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 678
78.3%
ASCII 188
 
21.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
) 90
47.9%
( 90
47.9%
4 3
 
1.6%
A 1
 
0.5%
1
 
0.5%
C 1
 
0.5%
I 1
 
0.5%
3 1
 
0.5%
Hangul
ValueCountFrequency (%)
55
 
8.1%
52
 
7.7%
52
 
7.7%
51
 
7.5%
50
 
7.4%
50
 
7.4%
50
 
7.4%
50
 
7.4%
33
 
4.9%
13
 
1.9%
Other values (97) 222
32.7%
Distinct48
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-01-10T07:22:34.417374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length24
Mean length22.04
Min length20

Characters and Unicode

Total characters1102
Distinct characters76
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

Unique46 ?
Unique (%)92.0%

Sample

1st row충청남도 청양군 청양읍 읍내리 328-1
2nd row충청남도 청양군 청양읍 읍내리 백세공원(104-39)
3rd row충청남도 청양군 청양읍 읍내리 296-3
4th row충청남도 청양군 청양읍 교월리 81-4
5th row충청남도 청양군 청양읍 백천리 공설운동장(산66-6)
ValueCountFrequency (%)
충청남도 50
19.8%
청양군 50
19.8%
청양읍 15
 
5.9%
정산면 8
 
3.2%
송방리 6
 
2.4%
청남면 5
 
2.0%
남양면 4
 
1.6%
서정리 4
 
1.6%
화성면 4
 
1.6%
읍내리 3
 
1.2%
Other values (80) 104
41.1%
2024-01-10T07:22:34.712689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
204
18.5%
122
 
11.1%
69
 
6.3%
59
 
5.4%
50
 
4.5%
50
 
4.5%
50
 
4.5%
50
 
4.5%
- 45
 
4.1%
35
 
3.2%
Other values (66) 368
33.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 660
59.9%
Space Separator 204
 
18.5%
Decimal Number 189
 
17.2%
Dash Punctuation 45
 
4.1%
Close Punctuation 2
 
0.2%
Open Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
122
18.5%
69
10.5%
59
8.9%
50
 
7.6%
50
 
7.6%
50
 
7.6%
50
 
7.6%
35
 
5.3%
18
 
2.7%
17
 
2.6%
Other values (52) 140
21.2%
Decimal Number
ValueCountFrequency (%)
1 30
15.9%
9 22
11.6%
3 22
11.6%
2 21
11.1%
5 20
10.6%
4 19
10.1%
6 18
9.5%
7 15
7.9%
8 13
6.9%
0 9
 
4.8%
Space Separator
ValueCountFrequency (%)
204
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 45
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 660
59.9%
Common 442
40.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
122
18.5%
69
10.5%
59
8.9%
50
 
7.6%
50
 
7.6%
50
 
7.6%
50
 
7.6%
35
 
5.3%
18
 
2.7%
17
 
2.6%
Other values (52) 140
21.2%
Common
ValueCountFrequency (%)
204
46.2%
- 45
 
10.2%
1 30
 
6.8%
9 22
 
5.0%
3 22
 
5.0%
2 21
 
4.8%
5 20
 
4.5%
4 19
 
4.3%
6 18
 
4.1%
7 15
 
3.4%
Other values (4) 26
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 660
59.9%
ASCII 442
40.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
204
46.2%
- 45
 
10.2%
1 30
 
6.8%
9 22
 
5.0%
3 22
 
5.0%
2 21
 
4.8%
5 20
 
4.5%
4 19
 
4.3%
6 18
 
4.1%
7 15
 
3.4%
Other values (4) 26
 
5.9%
Hangul
ValueCountFrequency (%)
122
18.5%
69
10.5%
59
8.9%
50
 
7.6%
50
 
7.6%
50
 
7.6%
50
 
7.6%
35
 
5.3%
18
 
2.7%
17
 
2.6%
Other values (52) 140
21.2%

게시대 형태
Categorical

Distinct2
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
스텐레스(접철식)
30 
스텐레스(테크봉식)
20 

Length

Max length10
Median length9
Mean length9.4
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row스텐레스(접철식)
2nd row스텐레스(테크봉식)
3rd row스텐레스(접철식)
4th row스텐레스(접철식)
5th row스텐레스(테크봉식)

Common Values

ValueCountFrequency (%)
스텐레스(접철식) 30
60.0%
스텐레스(테크봉식) 20
40.0%

Length

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

Common Values (Plot)

2024-01-10T07:22:34.897445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
스텐레스(접철식 30
60.0%
스텐레스(테크봉식 20
40.0%

규격
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
5.8×0.9
41 
6×0.7
6×0.9
 
3

Length

Max length7
Median length7
Mean length6.64
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row6×0.7
2nd row6×0.9
3rd row5.8×0.9
4th row5.8×0.9
5th row5.8×0.9

Common Values

ValueCountFrequency (%)
5.8×0.9 41
82.0%
6×0.7 6
 
12.0%
6×0.9 3
 
6.0%

Length

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

Common Values (Plot)

2024-01-10T07:22:35.063898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5.8×0.9 41
82.0%
6×0.7 6
 
12.0%
6×0.9 3
 
6.0%

게시면
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
5
20 
10
18 
12
6
18
 
1

Length

Max length2
Median length2
Mean length1.52
Min length1

Unique

Unique1 ?
Unique (%)2.0%

Sample

1st row12
2nd row5
3rd row6
4th row10
5th row10

Common Values

ValueCountFrequency (%)
5 20
40.0%
10 18
36.0%
12 7
 
14.0%
6 4
 
8.0%
18 1
 
2.0%

Length

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

Common Values (Plot)

2024-01-10T07:22:35.225283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5 20
40.0%
10 18
36.0%
12 7
 
14.0%
6 4
 
8.0%
18 1
 
2.0%

Interactions

2024-01-10T07:22:33.335500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:22:35.285209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호게시대명지번주소게시대 형태규격게시면
번호1.0000.9701.0000.0000.0000.139
게시대명0.9701.0000.9940.5190.8980.000
지번주소1.0000.9941.0001.0001.0001.000
게시대 형태0.0000.5191.0001.0000.0470.000
규격0.0000.8981.0000.0471.0000.671
게시면0.1390.0001.0000.0000.6711.000
2024-01-10T07:22:35.364602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
게시대 형태규격게시면
게시대 형태1.0000.0710.000
규격0.0711.0000.630
게시면0.0000.6301.000
2024-01-10T07:22:35.432557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호게시대 형태규격게시면
번호1.0000.0000.0000.000
게시대 형태0.0001.0000.0710.000
규격0.0000.0711.0000.630
게시면0.0000.0000.6301.000

Missing values

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

번호게시대명지번주소게시대 형태규격게시면
01현수막지정게시대(주공(A)앞)충청남도 청양군 청양읍 읍내리 328-1스텐레스(접철식)6×0.712
12현수막지정게시대(백세공원)충청남도 청양군 청양읍 읍내리 백세공원(104-39)스텐레스(테크봉식)6×0.95
23현수막지정게시대(멜론농협창고입구)충청남도 청양군 청양읍 읍내리 296-3스텐레스(접철식)5.8×0.96
34현수막지정게시대(청양교(옆))충청남도 청양군 청양읍 교월리 81-4스텐레스(접철식)5.8×0.910
45현수막지정게시대(청양공설운동장4거리)충청남도 청양군 청양읍 백천리 공설운동장(산66-6)스텐레스(테크봉식)5.8×0.910
56현수막지정게시대(회전교차로군청(앞))충청남도 청양군 청양읍 송방리 74-5스텐레스(테크봉식)5.8×0.912
67현수막지정게시대(회전교차로군청(앞))충청남도 청양군 청양읍 송방리 68-5스텐레스(접철식)5.8×0.918
78현수막지정게시대(송방교(앞))충청남도 청양군 청양읍 송방리 414-5스텐레스(접철식)5.8×0.96
89현수막지정게시대(청양고4거리(회전교차로))충청남도 청양군 청양읍 송방리 188스텐레스(접철식)5.8×0.96
910현수막지정게시대(세월교(옆)필로스아파트앞)충청남도 청양군 청양읍 벽천리 270-9스텐레스(테크봉식)6×0.712
번호게시대명지번주소게시대 형태규격게시면
4041현수막지정게시대(숭의청소년원(앞))충청남도 청양군 남양면 구룡리 315-1스텐레스(접철식)5.8×0.95
4142현수막지정게시대(금정교화단(앞))충청남도 청양군 남양면 금정리 산 22-4스텐레스(테크봉식)5.8×0.95
4243현수막지정게시대(남양면사무소 앞)충청남도 청양군 남양면 구룡리 19-1스텐레스(접철식)5.8×0.95
4344현수막지정게시대(게이트볼(앞))충청남도 청양군 화성면 화강리 1-2스텐레스(테크봉식)5.8×0.910
4445현수막지정게시대(파출소(앞))충청남도 청양군 화성면 산정리 165-8스텐레스(접철식)5.8×0.910
4546현수막지정게시대(농공단지(앞))충청남도 청양군 화성면 장계리 758-1스텐레스(테크봉식)5.8×0.95
4647현수막지정게시대(우체국(앞))충청남도 청양군 화성면 산정리 191-7스텐레스(접철식)5.8×0.95
4748현수막지정게시대(우체국(앞))충청남도 청양군 비봉면 녹평리 50-6스텐레스(접철식)5.8×0.910
4849현수막지정게시대(사거리(앞))충청남도 청양군 비봉면 용천리 406-4스텐레스(테크봉식)5.8×0.95
4950현수막지정게시대(삼거리(앞))충청남도 청양군 비봉면 장재리 391-6스텐레스(테크봉식)5.8×0.95