Overview

Dataset statistics

Number of variables7
Number of observations53
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory60.5 B

Variable types

Numeric2
Text2
Categorical3

Dataset

Description충청남도 청양군 옥외광고물 게시대명, 지번주소, 게시대 형태,규격,게시면 등에 대한 현황을 제공하고 있습니다.
Author충청남도 청양군
URLhttps://www.data.go.kr/data/15060559/fileData.do

Alerts

데이터기준일 has constant value ""Constant
번호 is highly overall correlated with 규격High correlation
게시면 is highly overall correlated with 규격High correlation
규격 is highly overall correlated with 번호 and 1 other fieldsHigh correlation
번호 has unique valuesUnique

Reproduction

Analysis started2024-05-18 08:52:57.270437
Analysis finished2024-05-18 08:52:59.501624
Duration2.23 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct53
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27
Minimum1
Maximum53
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size609.0 B
2024-05-18T17:52:59.706944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.6
Q114
median27
Q340
95-th percentile50.4
Maximum53
Range52
Interquartile range (IQR)26

Descriptive statistics

Standard deviation15.443445
Coefficient of variation (CV)0.57197945
Kurtosis-1.2
Mean27
Median Absolute Deviation (MAD)13
Skewness0
Sum1431
Variance238.5
MonotonicityStrictly increasing
2024-05-18T17:53:00.191108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.9%
41 1
 
1.9%
30 1
 
1.9%
31 1
 
1.9%
32 1
 
1.9%
33 1
 
1.9%
34 1
 
1.9%
35 1
 
1.9%
36 1
 
1.9%
37 1
 
1.9%
Other values (43) 43
81.1%
ValueCountFrequency (%)
1 1
1.9%
2 1
1.9%
3 1
1.9%
4 1
1.9%
5 1
1.9%
6 1
1.9%
7 1
1.9%
8 1
1.9%
9 1
1.9%
10 1
1.9%
ValueCountFrequency (%)
53 1
1.9%
52 1
1.9%
51 1
1.9%
50 1
1.9%
49 1
1.9%
48 1
1.9%
47 1
1.9%
46 1
1.9%
45 1
1.9%
44 1
1.9%
Distinct48
Distinct (%)90.6%
Missing0
Missing (%)0.0%
Memory size556.0 B
2024-05-18T17:53:00.699050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length20
Mean length17.698113
Min length14

Characters and Unicode

Total characters938
Distinct characters119
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

Unique44 ?
Unique (%)83.0%

Sample

1st row현수막지정게시대(멜론농협창고앞)
2nd row현수막지정게시대(하나로마트 앞)
3rd row현수막지정게시대(주공(A)앞)
4th row현수막지정게시대(백세공원)
5th row현수막지정게시대(멜론농협창고입구)
ValueCountFrequency (%)
4
 
6.6%
현수막지정게시대(회전교차로군청(앞 3
 
4.9%
현수막지정게시대(장평면사무소광장(앞 2
 
3.3%
현수막지정게시대(공용주차장앞 2
 
3.3%
현수막지정게시대(우체국(앞 2
 
3.3%
현수막지정게시대(미당 1
 
1.6%
현수막지정게시대(안심교(앞 1
 
1.6%
현수막지정게시대(안심교(옆 1
 
1.6%
현수막지정게시대(문성초폐교(맞은편 1
 
1.6%
현수막지정게시대(상장리(입구 1
 
1.6%
Other values (43) 43
70.5%
2024-05-18T17:53:01.888304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 90
 
9.6%
) 90
 
9.6%
59
 
6.3%
57
 
6.1%
55
 
5.9%
54
 
5.8%
54
 
5.8%
53
 
5.7%
53
 
5.7%
53
 
5.7%
Other values (109) 320
34.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 745
79.4%
Open Punctuation 90
 
9.6%
Close Punctuation 90
 
9.6%
Space Separator 8
 
0.9%
Uppercase Letter 3
 
0.3%
Decimal Number 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
59
 
7.9%
57
 
7.7%
55
 
7.4%
54
 
7.2%
54
 
7.2%
53
 
7.1%
53
 
7.1%
53
 
7.1%
35
 
4.7%
15
 
2.0%
Other values (101) 257
34.5%
Uppercase Letter
ValueCountFrequency (%)
A 1
33.3%
I 1
33.3%
C 1
33.3%
Decimal Number
ValueCountFrequency (%)
4 1
50.0%
3 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 90
100.0%
Close Punctuation
ValueCountFrequency (%)
) 90
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 745
79.4%
Common 190
 
20.3%
Latin 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
59
 
7.9%
57
 
7.7%
55
 
7.4%
54
 
7.2%
54
 
7.2%
53
 
7.1%
53
 
7.1%
53
 
7.1%
35
 
4.7%
15
 
2.0%
Other values (101) 257
34.5%
Common
ValueCountFrequency (%)
( 90
47.4%
) 90
47.4%
8
 
4.2%
4 1
 
0.5%
3 1
 
0.5%
Latin
ValueCountFrequency (%)
A 1
33.3%
I 1
33.3%
C 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 745
79.4%
ASCII 193
 
20.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 90
46.6%
) 90
46.6%
8
 
4.1%
4 1
 
0.5%
3 1
 
0.5%
A 1
 
0.5%
I 1
 
0.5%
C 1
 
0.5%
Hangul
ValueCountFrequency (%)
59
 
7.9%
57
 
7.7%
55
 
7.4%
54
 
7.2%
54
 
7.2%
53
 
7.1%
53
 
7.1%
53
 
7.1%
35
 
4.7%
15
 
2.0%
Other values (101) 257
34.5%
Distinct47
Distinct (%)88.7%
Missing0
Missing (%)0.0%
Memory size556.0 B
2024-05-18T17:53:02.411762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length24
Mean length21.943396
Min length20

Characters and Unicode

Total characters1163
Distinct characters72
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

Unique41 ?
Unique (%)77.4%

Sample

1st row충청남도 청양군 청양읍 벽천리 289-7
2nd row충청남도 청양군 청양읍 벽천리 277-1
3rd row충청남도 청양군 청양읍 읍내리 328-1
4th row충청남도 청양군 청양읍 읍내리 백세공원(104-39)
5th row충청남도 청양군 청양읍 읍내리 296-3
ValueCountFrequency (%)
충청남도 53
19.8%
청양군 53
19.8%
청양읍 17
 
6.3%
정산면 10
 
3.7%
송방리 7
 
2.6%
서정리 5
 
1.9%
대치면 4
 
1.5%
화성면 4
 
1.5%
청남면 4
 
1.5%
남양면 4
 
1.5%
Other values (76) 107
39.9%
2024-05-18T17:53:03.528929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
216
18.6%
129
 
11.1%
74
 
6.4%
61
 
5.2%
53
 
4.6%
53
 
4.6%
53
 
4.6%
53
 
4.6%
- 48
 
4.1%
1 40
 
3.4%
Other values (62) 383
32.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 693
59.6%
Space Separator 216
 
18.6%
Decimal Number 204
 
17.5%
Dash Punctuation 48
 
4.1%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
129
18.6%
74
10.7%
61
8.8%
53
 
7.6%
53
 
7.6%
53
 
7.6%
53
 
7.6%
36
 
5.2%
21
 
3.0%
20
 
2.9%
Other values (48) 140
20.2%
Decimal Number
ValueCountFrequency (%)
1 40
19.6%
2 25
12.3%
9 23
11.3%
5 22
10.8%
3 20
9.8%
4 18
8.8%
7 18
8.8%
8 15
 
7.4%
6 15
 
7.4%
0 8
 
3.9%
Space Separator
ValueCountFrequency (%)
216
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 693
59.6%
Common 470
40.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
129
18.6%
74
10.7%
61
8.8%
53
 
7.6%
53
 
7.6%
53
 
7.6%
53
 
7.6%
36
 
5.2%
21
 
3.0%
20
 
2.9%
Other values (48) 140
20.2%
Common
ValueCountFrequency (%)
216
46.0%
- 48
 
10.2%
1 40
 
8.5%
2 25
 
5.3%
9 23
 
4.9%
5 22
 
4.7%
3 20
 
4.3%
4 18
 
3.8%
7 18
 
3.8%
8 15
 
3.2%
Other values (4) 25
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 693
59.6%
ASCII 470
40.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
216
46.0%
- 48
 
10.2%
1 40
 
8.5%
2 25
 
5.3%
9 23
 
4.9%
5 22
 
4.7%
3 20
 
4.3%
4 18
 
3.8%
7 18
 
3.8%
8 15
 
3.2%
Other values (4) 25
 
5.3%
Hangul
ValueCountFrequency (%)
129
18.6%
74
10.7%
61
8.8%
53
 
7.6%
53
 
7.6%
53
 
7.6%
53
 
7.6%
36
 
5.2%
21
 
3.0%
20
 
2.9%
Other values (48) 140
20.2%

게시대 형태
Categorical

Distinct2
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size556.0 B
스텐레스(접철식)
37 
스텐레스(테크봉식)
16 

Length

Max length10
Median length9
Mean length9.3018868
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
스텐레스(접철식) 37
69.8%
스텐레스(테크봉식) 16
30.2%

Length

2024-05-18T17:53:04.096529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T17:53:04.484263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
스텐레스(접철식 37
69.8%
스텐레스(테크봉식 16
30.2%

규격
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size556.0 B
6×0.7
22 
5.8×0.9
20 
6×0.9
11 

Length

Max length7
Median length5
Mean length5.754717
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
6×0.7 22
41.5%
5.8×0.9 20
37.7%
6×0.9 11
20.8%

Length

2024-05-18T17:53:04.946043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T17:53:05.269102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
6×0.7 22
41.5%
5.8×0.9 20
37.7%
6×0.9 11
20.8%

게시면
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.2641509
Minimum1
Maximum18
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size609.0 B
2024-05-18T17:53:05.476945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5
Q15
median10
Q310
95-th percentile12
Maximum18
Range17
Interquartile range (IQR)5

Descriptive statistics

Standard deviation3.3232916
Coefficient of variation (CV)0.40213346
Kurtosis-0.2884997
Mean8.2641509
Median Absolute Deviation (MAD)2
Skewness0.30814063
Sum438
Variance11.044267
MonotonicityNot monotonic
2024-05-18T17:53:05.701879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
5 17
32.1%
10 14
26.4%
12 12
22.6%
6 7
13.2%
8 1
 
1.9%
18 1
 
1.9%
1 1
 
1.9%
ValueCountFrequency (%)
1 1
 
1.9%
5 17
32.1%
6 7
13.2%
8 1
 
1.9%
10 14
26.4%
12 12
22.6%
18 1
 
1.9%
ValueCountFrequency (%)
18 1
 
1.9%
12 12
22.6%
10 14
26.4%
8 1
 
1.9%
6 7
13.2%
5 17
32.1%
1 1
 
1.9%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size556.0 B
2024-05-13
53 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-05-13
2nd row2024-05-13
3rd row2024-05-13
4th row2024-05-13
5th row2024-05-13

Common Values

ValueCountFrequency (%)
2024-05-13 53
100.0%

Length

2024-05-18T17:53:06.074872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T17:53:06.486874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-05-13 53
100.0%

Interactions

2024-05-18T17:52:58.436476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T17:52:57.936742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/