Overview

Dataset statistics

Number of variables5
Number of observations25
Missing cells2
Missing cells (%)1.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory46.3 B

Variable types

Text3
Numeric1
Categorical1

Dataset

Description충청남도 청양군의 문화유통업에 대한 현황으로 노래연습장, 게임업, 영화관의 상호명, 영업소 주소 등의 데이터를 제공하고 있습니다
URLhttps://www.data.go.kr/data/15025296/fileData.do

Alerts

우편번호 has 2 (8.0%) missing valuesMissing
상호명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:29:51.704779
Analysis finished2023-12-12 08:29:52.376225
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T17:29:52.539155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length9
Mean length6.8
Min length3

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st row앵콜 노래연습장
2nd row라이브노래연습장
3rd row운곡노래방
4th row올래노래방
5th row스타노래방
ValueCountFrequency (%)
노래연습장 3
 
9.4%
앵콜 1
 
3.1%
작은영화관 1
 
3.1%
청양 1
 
3.1%
인형나라 1
 
3.1%
청양사격장 1
 
3.1%
뽑기뽑기 1
 
3.1%
뽑기짱 1
 
3.1%
글로벌성인게임랜드 1
 
3.1%
청양게임랜드 1
 
3.1%
Other values (20) 20
62.5%
2023-12-12T17:29:53.278402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
14
 
8.2%
14
 
8.2%
11
 
6.5%
10
 
5.9%
10
 
5.9%
7
 
4.1%
6
 
3.5%
P 5
 
2.9%
C 5
 
2.9%
4
 
2.4%
Other values (60) 84
49.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 150
88.2%
Uppercase Letter 11
 
6.5%
Space Separator 7
 
4.1%
Lowercase Letter 2
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
14
 
9.3%
14
 
9.3%
11
 
7.3%
10
 
6.7%
10
 
6.7%
6
 
4.0%
4
 
2.7%
3
 
2.0%
3
 
2.0%
3
 
2.0%
Other values (54) 72
48.0%
Uppercase Letter
ValueCountFrequency (%)
P 5
45.5%
C 5
45.5%
T 1
 
9.1%
Lowercase Letter
ValueCountFrequency (%)
h 1
50.0%
e 1
50.0%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 150
88.2%
Latin 13
 
7.6%
Common 7
 
4.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
14
 
9.3%
14
 
9.3%
11
 
7.3%
10
 
6.7%
10
 
6.7%
6
 
4.0%
4
 
2.7%
3
 
2.0%
3
 
2.0%
3
 
2.0%
Other values (54) 72
48.0%
Latin
ValueCountFrequency (%)
P 5
38.5%
C 5
38.5%
T 1
 
7.7%
h 1
 
7.7%
e 1
 
7.7%
Common
ValueCountFrequency (%)
7
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 150
88.2%
ASCII 20
 
11.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
14
 
9.3%
14
 
9.3%
11
 
7.3%
10
 
6.7%
10
 
6.7%
6
 
4.0%
4
 
2.7%
3
 
2.0%
3
 
2.0%
3
 
2.0%
Other values (54) 72
48.0%
ASCII
ValueCountFrequency (%)
7
35.0%
P 5
25.0%
C 5
25.0%
T 1
 
5.0%
h 1
 
5.0%
e 1
 
5.0%

우편번호
Real number (ℝ)

MISSING 

Distinct7
Distinct (%)30.4%
Missing2
Missing (%)8.0%
Infinite0
Infinite (%)0.0%
Mean33331
Minimum33310
Maximum33351
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2023-12-12T17:29:53.432885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum33310
5-th percentile33316.1
Q133326
median33330
Q333332.5
95-th percentile33351
Maximum33351
Range41
Interquartile range (IQR)6.5

Descriptive statistics

Standard deviation9.6389362
Coefficient of variation (CV)0.00028918833
Kurtosis1.6863292
Mean33331
Median Absolute Deviation (MAD)3
Skewness0.55801482
Sum766613
Variance92.909091
MonotonicityNot monotonic
2023-12-12T17:29:53.576730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
33330 7
28.0%
33326 5
20.0%
33333 3
12.0%
33351 3
12.0%
33332 3
12.0%
33315 1
 
4.0%
33310 1
 
4.0%
(Missing) 2
 
8.0%
ValueCountFrequency (%)
33310 1
 
4.0%
33315 1
 
4.0%
33326 5
20.0%
33330 7
28.0%
33332 3
12.0%
33333 3
12.0%
33351 3
12.0%
ValueCountFrequency (%)
33351 3
12.0%
33333 3
12.0%
33332 3
12.0%
33330 7
28.0%
33326 5
20.0%
33315 1
 
4.0%
33310 1
 
4.0%
Distinct23
Distinct (%)92.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T17:29:53.805091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length28
Mean length22.44
Min length19

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)84.0%

Sample

1st row충청남도 청양군 청양읍 중앙로열길 11
2nd row충청남도 청양군 청양읍 칠갑산로열길 4
3rd row충청남도 청양군 운곡면 청신로 855-5
4th row충청남도 청양군 청양읍 중앙로 140
5th row충청남도 청양군 정산면 정현길 65
ValueCountFrequency (%)
충청남도 25
18.8%
청양군 25
18.8%
청양읍 20
15.0%
중앙로 7
 
5.3%
중앙로11길 4
 
3.0%
13 3
 
2.3%
140 3
 
2.3%
정산면 3
 
2.3%
정현길 3
 
2.3%
4 2
 
1.5%
Other values (33) 38
28.6%
2023-12-12T17:29:54.157200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
108
19.3%
72
12.8%
46
 
8.2%
1 31
 
5.5%
26
 
4.6%
25
 
4.5%
25
 
4.5%
25
 
4.5%
20
 
3.6%
20
 
3.6%
Other values (44) 163
29.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 367
65.4%
Space Separator 108
 
19.3%
Decimal Number 76
 
13.5%
Other Punctuation 6
 
1.1%
Dash Punctuation 4
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
72
19.6%
46
12.5%
26
 
7.1%
25
 
6.8%
25
 
6.8%
25
 
6.8%
20
 
5.4%
20
 
5.4%
16
 
4.4%
15
 
4.1%
Other values (31) 77
21.0%
Decimal Number
ValueCountFrequency (%)
1 31
40.8%
4 9
 
11.8%
3 9
 
11.8%
2 8
 
10.5%
5 5
 
6.6%
7 4
 
5.3%
0 4
 
5.3%
6 3
 
3.9%
9 2
 
2.6%
8 1
 
1.3%
Space Separator
ValueCountFrequency (%)
108
100.0%
Other Punctuation
ValueCountFrequency (%)
, 6
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 367
65.4%
Common 194
34.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
72
19.6%
46
12.5%
26
 
7.1%
25
 
6.8%
25
 
6.8%
25
 
6.8%
20
 
5.4%
20
 
5.4%
16
 
4.4%
15
 
4.1%
Other values (31) 77
21.0%
Common
ValueCountFrequency (%)
108
55.7%
1 31
 
16.0%
4 9
 
4.6%
3 9
 
4.6%
2 8
 
4.1%
, 6
 
3.1%
5 5
 
2.6%
7 4
 
2.1%
0 4
 
2.1%
- 4
 
2.1%
Other values (3) 6
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 367
65.4%
ASCII 194
34.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108
55.7%
1 31
 
16.0%
4 9
 
4.6%
3 9
 
4.6%
2 8
 
4.1%
, 6
 
3.1%
5 5
 
2.6%
7 4
 
2.1%
0 4
 
2.1%
- 4
 
2.1%
Other values (3) 6
 
3.1%
Hangul
ValueCountFrequency (%)
72
19.6%
46
12.5%
26
 
7.1%
25
 
6.8%
25
 
6.8%
25
 
6.8%
20
 
5.4%
20
 
5.4%
16
 
4.4%
15
 
4.1%
Other values (31) 77
21.0%
Distinct22
Distinct (%)88.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T17:29:54.369963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length24
Mean length24.24
Min length23

Characters and Unicode

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

Unique

Unique20 ?
Unique (%)80.0%

Sample

1st row충청남도 청양군 청양읍 읍내리 203-52
2nd row충청남도 청양군 청양읍 읍내리 171-16
3rd row충청남도 청양군 운곡면 모곡리 309-22
4th row충청남도 청양군 청양읍 읍내리 208-10
5th row충청남도 청양군 정산면 서정리 157-5
ValueCountFrequency (%)
충청남도 25
19.7%
청양군 25
19.7%
청양읍 20
15.7%
읍내리 20
15.7%
정산면 3
 
2.4%
서정리 3
 
2.4%
208-10 3
 
2.4%
194-10 2
 
1.6%
547-5 2
 
1.6%
191-5번지 1
 
0.8%
Other values (23) 23
18.1%
2023-12-12T17:29:54.690247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
127
21.0%
71
11.7%
46
 
7.6%
40
 
6.6%
26
 
4.3%
25
 
4.1%
- 25
 
4.1%
25
 
4.1%
25
 
4.1%
25
 
4.1%
Other values (30) 171
28.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 340
56.1%
Space Separator 127
 
21.0%
Decimal Number 114
 
18.8%
Dash Punctuation 25
 
4.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
71
20.9%
46
13.5%
40
11.8%
26
 
7.6%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
20
 
5.9%
7
 
2.1%
Other values (18) 30
8.8%
Decimal Number
ValueCountFrequency (%)
1 23
20.2%
2 20
17.5%
0 17
14.9%
7 12
10.5%
5 9
 
7.9%
3 9
 
7.9%
9 7
 
6.1%
4 6
 
5.3%
8 6
 
5.3%
6 5
 
4.4%
Space Separator
ValueCountFrequency (%)
127
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 340
56.1%
Common 266
43.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
71
20.9%
46
13.5%
40
11.8%
26
 
7.6%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
20
 
5.9%
7
 
2.1%
Other values (18) 30
8.8%
Common
ValueCountFrequency (%)
127
47.7%
- 25
 
9.4%
1 23
 
8.6%
2 20
 
7.5%
0 17
 
6.4%
7 12
 
4.5%
5 9
 
3.4%
3 9
 
3.4%
9 7
 
2.6%
4 6
 
2.3%
Other values (2) 11
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 340
56.1%
ASCII 266
43.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
127
47.7%
- 25
 
9.4%
1 23
 
8.6%
2 20
 
7.5%
0 17
 
6.4%
7 12
 
4.5%
5 9
 
3.4%
3 9
 
3.4%
9 7
 
2.6%
4 6
 
2.3%
Other values (2) 11
 
4.1%
Hangul
ValueCountFrequency (%)
71
20.9%
46
13.5%
40
11.8%
26
 
7.6%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
20
 
5.9%
7
 
2.1%
Other values (18) 30
8.8%

업종
Categorical

Distinct6
Distinct (%)24.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
노래연습장업
13 
인터넷컴퓨터게임시설제공업
청소년게임제공업
복합유통게임제공업
일반게임제공업
 
1

Length

Max length13
Median length6
Mean length7.88
Min length5

Unique

Unique2 ?
Unique (%)8.0%

Sample

1st row노래연습장업
2nd row노래연습장업
3rd row노래연습장업
4th row노래연습장업
5th row노래연습장업

Common Values

ValueCountFrequency (%)
노래연습장업 13
52.0%
인터넷컴퓨터게임시설제공업 5
 
20.0%
청소년게임제공업 3
 
12.0%
복합유통게임제공업 2
 
8.0%
일반게임제공업 1
 
4.0%
영화상영업 1
 
4.0%

Length

2023-12-12T17:29:54.843497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:29:54.980729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노래연습장업 13
52.0%
인터넷컴퓨터게임시설제공업 5
 
20.0%
청소년게임제공업 3
 
12.0%
복합유통게임제공업 2
 
8.0%
일반게임제공업 1
 
4.0%
영화상영업 1
 
4.0%

Interactions

2023-12-12T17:29:52.088970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:29:55.096285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호명우편번호영업소도로명소재지영업소지번소재지업종
상호명1.0001.0001.0001.0001.000
우편번호1.0001.0001.0001.0000.000
영업소도로명소재지1.0001.0001.0001.0000.000
영업소지번소재지1.0001.0001.0001.0000.000
업종1.0000.0000.0000.0001.000
2023-12-12T17:29:55.204916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
우편번호업종
우편번호1.0000.000
업종0.0001.000

Missing values

2023-12-12T17:29:52.216206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:29:52.324562image/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앵콜 노래연습장33326충청남도 청양군 청양읍 중앙로열길 11충청남도 청양군 청양읍 읍내리 203-52노래연습장업
1라이브노래연습장33333충청남도 청양군 청양읍 칠갑산로열길 4충청남도 청양군 청양읍 읍내리 171-16노래연습장업
2운곡노래방33315충청남도 청양군 운곡면 청신로 855-5충청남도 청양군 운곡면 모곡리 309-22노래연습장업
3올래노래방<NA>충청남도 청양군 청양읍 중앙로 140충청남도 청양군 청양읍 읍내리 208-10노래연습장업
4스타노래방33351충청남도 청양군 정산면 정현길 65충청남도 청양군 정산면 서정리 157-5노래연습장업
5찬스노래연습장33330충청남도 청양군 청양읍 중앙로11길 4충청남도 청양군 청양읍 읍내리 210-13노래연습장업
6오페라 노래연습장33351충청남도 청양군 정산면 정현길 72충청남도 청양군 정산면 서정리 547-5노래연습장업
7아싸 노래연습장33330충청남도 청양군 청양읍 중앙로11길 3충청남도 청양군 청양읍 읍내리 208-3노래연습장업
8발리노래연습장33332충청남도 청양군 청양읍 칠갑산로4길 26충청남도 청양군 청양읍 읍내리 177-3노래연습장업
9대흥노래연습장33310충청남도 청양군 화성면 뛰밭골길 49충청남도 청양군 화성면 산정리 187-6노래연습장업
상호명우편번호영업소도로명소재지영업소지번소재지업종
15와드PC33330충청남도 청양군 청양읍 중앙로 131, 2층충청남도 청양군 청양읍 읍내리 201-10인터넷컴퓨터게임시설제공업
16스타게임넷33351충청남도 청양군 정산면 정현길 72, 민성빌딩 2층충청남도 청양군 정산면 서정리 547-5 민성빌딩인터넷컴퓨터게임시설제공업
17부라보PC33326충청남도 청양군 청양읍 중앙로열길 4-1, 1층충청남도 청양군 청양읍 읍내리 209-24인터넷컴퓨터게임시설제공업
18노블PC방<NA>충청남도 청양군 청양읍 칠갑산로4길 37충청남도 청양군 청양읍 읍내리 327-9복합유통게임제공업
19청양게임랜드33326충청남도 청양군 청양읍 중앙로 140, 지하1층충청남도 청양군 청양읍 읍내리 208-10복합유통게임제공업
20글로벌성인게임랜드33326충청남도 청양군 청양읍 중앙로 140충청남도 청양군 청양읍 읍내리 208-10일반게임제공업
21뽑기짱33330충청남도 청양군 청양읍 중앙로11길 13충청남도 청양군 청양읍 읍내리 194-10청소년게임제공업
22뽑기뽑기 청양사격장33332충청남도 청양군 청양읍 중앙로1길 13충청남도 청양군 청양읍 읍내리 327-18청소년게임제공업
23인형나라33326충청남도 청양군 청양읍 중앙로 136-1충청남도 청양군 청양읍 읍내리 209-22청소년게임제공업
24청양 작은영화관 사회적협동조합33330충청남도 청양군 청양읍 칠갑산로 221, 청양군문화체육센타 3층충청남도 청양군 청양읍 읍내리 191-5번지 청양군문화체육센타영화상영업