Overview

Dataset statistics

Number of variables3
Number of observations302
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.2 KiB
Average record size in memory24.4 B

Variable types

Categorical1
Text2

Dataset

Description대구광역시_수성구_유흥단란주점 현황_20191121
Author대구광역시 수성구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3075323&dataSetDetailId=30753231d1756f372cf1&provdMethod=FILE

Reproduction

Analysis started2024-04-20 17:47:52.543728
Analysis finished2024-04-20 17:47:53.259736
Duration0.72 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.5 KiB
유흥주점영업
206 
단란주점
96 

Length

Max length6
Median length6
Mean length5.3642384
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유흥주점영업
2nd row유흥주점영업
3rd row유흥주점영업
4th row유흥주점영업
5th row유흥주점영업

Common Values

ValueCountFrequency (%)
유흥주점영업 206
68.2%
단란주점 96
31.8%

Length

2024-04-21T02:47:53.494918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T02:47:53.829203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 206
68.2%
단란주점 96
31.8%

업소명
Text

Distinct282
Distinct (%)93.4%
Missing0
Missing (%)0.0%
Memory size2.5 KiB
2024-04-21T02:47:54.851181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length14
Mean length4.0364238
Min length1

Characters and Unicode

Total characters1219
Distinct characters311
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique262 ?
Unique (%)86.8%

Sample

1st row뉴썬
2nd row더문
3rd row갤럭시
4th row까치유흥주점
5th row틈클럽
ValueCountFrequency (%)
로망스 2
 
0.6%
골드 2
 
0.6%
아테네 2
 
0.6%
토마토단란주점 2
 
0.6%
오렌지 2
 
0.6%
하얏트 2
 
0.6%
놀이터 2
 
0.6%
모나코 2
 
0.6%
팡팡 2
 
0.6%
골든벨 2
 
0.6%
Other values (278) 288
93.5%
2024-04-21T02:47:56.135036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 52
 
4.3%
이 40
 
3.3%
리 35
 
2.9%
주 34
 
2.8%
점 34
 
2.8%
( 29
 
2.4%
) 29
 
2.4%
아 24
 
2.0%
비 22
 
1.8%
라 21
 
1.7%
Other values (301) 899
73.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1023
83.9%
Uppercase Letter 62
 
5.1%
Lowercase Letter 53
 
4.3%
Open Punctuation 29
 
2.4%
Close Punctuation 29
 
2.4%
Decimal Number 13
 
1.1%
Space Separator 6
 
0.5%
Other Punctuation 3
 
0.2%
Other Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 52
 
5.1%
이 40
 
3.9%
리 35
 
3.4%
주 34
 
3.3%
점 34
 
3.3%
아 24
 
2.3%
비 22
 
2.2%
라 21
 
2.1%
노 19
 
1.9%
란 19
 
1.9%
Other values (254) 723
70.7%
Uppercase Letter
ValueCountFrequency (%)
A 7
11.3%
S 7
11.3%
L 6
 
9.7%
B 6
 
9.7%
O 5
 
8.1%
F 4
 
6.5%
P 4
 
6.5%
X 2
 
3.2%
E 2
 
3.2%
N 2
 
3.2%
Other values (14) 17
27.4%
Lowercase Letter
ValueCountFrequency (%)
e 9
17.0%
o 6
11.3%
s 6
11.3%
u 5
9.4%
n 5
9.4%
i 5
9.4%
r 4
7.5%
t 4
7.5%
m 3
 
5.7%
c 2
 
3.8%
Other values (4) 4
7.5%
Decimal Number
ValueCountFrequency (%)
2 6
46.2%
1 4
30.8%
3 3
23.1%
Other Punctuation
ValueCountFrequency (%)
. 2
66.7%
& 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 29
100.0%
Close Punctuation
ValueCountFrequency (%)
) 29
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Other Number
ValueCountFrequency (%)
₂ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1023
83.9%
Latin 115
 
9.4%
Common 81
 
6.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 52
 
5.1%
이 40
 
3.9%
리 35
 
3.4%
주 34
 
3.3%
점 34
 
3.3%
아 24
 
2.3%
비 22
 
2.2%
라 21
 
2.1%
노 19
 
1.9%
란 19
 
1.9%
Other values (254) 723
70.7%
Latin
ValueCountFrequency (%)
e 9
 
7.8%
A 7
 
6.1%
S 7
 
6.1%
o 6
 
5.2%
L 6
 
5.2%
B 6
 
5.2%
s 6
 
5.2%
u 5
 
4.3%
n 5
 
4.3%
i 5
 
4.3%
Other values (28) 53
46.1%
Common
ValueCountFrequency (%)
( 29
35.8%
) 29
35.8%
6
 
7.4%
2 6
 
7.4%
1 4
 
4.9%
3 3
 
3.7%
. 2
 
2.5%
₂ 1
 
1.2%
& 1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1023
83.9%
ASCII 195
 
16.0%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 52
 
5.1%
이 40
 
3.9%
리 35
 
3.4%
주 34
 
3.3%
점 34
 
3.3%
아 24
 
2.3%
비 22
 
2.2%
라 21
 
2.1%
노 19
 
1.9%
란 19
 
1.9%
Other values (254) 723
70.7%
ASCII
ValueCountFrequency (%)
( 29
 
14.9%
) 29
 
14.9%
e 9
 
4.6%
A 7
 
3.6%
S 7
 
3.6%
6
 
3.1%
o 6
 
3.1%
L 6
 
3.1%
B 6
 
3.1%
2 6
 
3.1%
Other values (36) 84
43.1%
None
ValueCountFrequency (%)
₂ 1
100.0%

소재지(도로명)
Text

Distinct243
Distinct (%)80.5%
Missing0
Missing (%)0.0%
Memory size2.5 KiB
2024-04-21T02:47:56.902653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length33
Mean length25.374172
Min length21

Characters and Unicode

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

Unique

Unique204 ?
Unique (%)67.5%

Sample

1st row대구광역시 수성구 동대구로 80 (지산동)
2nd row대구광역시 수성구 청수로25길 24 (황금동)
3rd row대구광역시 수성구 동대구로 115-5 (황금동)
4th row대구광역시 수성구 명덕로 425 (수성동2가)
5th row대구광역시 수성구 동대구로 341-3 (범어동)
ValueCountFrequency (%)
대구광역시 302
19.5%
수성구 302
19.5%
두산동 87
 
5.6%
황금동 76
 
4.9%
동대구로 61
 
3.9%
범어동 47
 
3.0%
청수로 41
 
2.6%
수성못2길 30
 
1.9%
동대구로25길 26
 
1.7%
청수로25길 16
 
1.0%
Other values (232) 561
36.2%
2024-04-21T02:47:57.916059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1247
16.3%
구 725
 
9.5%
수 449
 
5.9%
대 423
 
5.5%
동 401
 
5.2%
성 371
 
4.8%
( 315
 
4.1%
) 315
 
4.1%
시 302
 
3.9%
역 302
 
3.9%
Other values (67) 2813
36.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4623
60.3%
Space Separator 1247
 
16.3%
Decimal Number 1060
 
13.8%
Open Punctuation 315
 
4.1%
Close Punctuation 315
 
4.1%
Other Punctuation 75
 
1.0%
Dash Punctuation 28
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 725
15.7%
수 449
9.7%
대 423
9.1%
동 401
8.7%
성 371
 
8.0%
시 302
 
6.5%
역 302
 
6.5%
광 302
 
6.5%
로 267
 
5.8%
길 129
 
2.8%
Other values (52) 952
20.6%
Decimal Number
ValueCountFrequency (%)
2 260
24.5%
1 216
20.4%
5 117
11.0%
3 95
 
9.0%
4 93
 
8.8%
6 66
 
6.2%
0 59
 
5.6%
7 55
 
5.2%
8 51
 
4.8%
9 48
 
4.5%
Space Separator
ValueCountFrequency (%)
1247
100.0%
Open Punctuation
ValueCountFrequency (%)
( 315
100.0%
Close Punctuation
ValueCountFrequency (%)
) 315
100.0%
Other Punctuation
ValueCountFrequency (%)
, 75
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4623
60.3%
Common 3040
39.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 725
15.7%
수 449
9.7%
대 423
9.1%
동 401
8.7%
성 371
 
8.0%
시 302
 
6.5%
역 302
 
6.5%
광 302
 
6.5%
로 267
 
5.8%
길 129
 
2.8%
Other values (52) 952
20.6%
Common
ValueCountFrequency (%)
1247
41.0%
( 315
 
10.4%
) 315
 
10.4%
2 260
 
8.6%
1 216
 
7.1%
5 117
 
3.8%
3 95
 
3.1%
4 93
 
3.1%
, 75
 
2.5%
6 66
 
2.2%
Other values (5) 241
 
7.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4623
60.3%
ASCII 3040
39.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1247
41.0%
( 315
 
10.4%
) 315
 
10.4%
2 260
 
8.6%
1 216
 
7.1%
5 117
 
3.8%
3 95
 
3.1%
4 93
 
3.1%
, 75
 
2.5%
6 66
 
2.2%
Other values (5) 241
 
7.9%
Hangul
ValueCountFrequency (%)
구 725
15.7%
수 449
9.7%
대 423
9.1%
동 401
8.7%
성 371
 
8.0%
시 302
 
6.5%
역 302
 
6.5%
광 302
 
6.5%
로 267
 
5.8%
길 129
 
2.8%
Other values (52) 952
20.6%

Missing values

2024-04-21T02:47:52.922571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T02:47:53.164626image/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유흥주점영업뉴썬대구광역시 수성구 동대구로 80 (지산동)
1유흥주점영업더문대구광역시 수성구 청수로25길 24 (황금동)
2유흥주점영업갤럭시대구광역시 수성구 동대구로 115-5 (황금동)
3유흥주점영업까치유흥주점대구광역시 수성구 명덕로 425 (수성동2가)
4유흥주점영업틈클럽대구광역시 수성구 동대구로 341-3 (범어동)
5유흥주점영업아바타대구광역시 수성구 수성로 259 (중동)
6유흥주점영업엘리스대구광역시 수성구 동대구로 197 (황금동)
7유흥주점영업힙대구광역시 수성구 청수로24길 87 (두산동)
8유흥주점영업립스대구광역시 수성구 동대구로 379 (범어동)
9유흥주점영업라솔(LASOL)대구광역시 수성구 동대구로 115 (황금동)
업종명업소명소재지(도로명)
292단란주점플레이(PLAY)단란주점대구광역시 수성구 청수로 118 (두산동, 2층)
293단란주점예술대구광역시 수성구 수성못2길 47 (두산동)
294단란주점코리아나대구광역시 수성구 청수로 127 (황금동)
295단란주점엠지(MG)대구광역시 수성구 동대구로 11, 5층 (두산동)
296단란주점에스에스단란주점대구광역시 수성구 청수로 120 (두산동)
297단란주점팍스(PAX)대구광역시 수성구 동대구로 27, 8층 (두산동)
298단란주점놀이터대구광역시 수성구 동대구로 165 (황금동)
299단란주점와이키키브라더스대구광역시 수성구 수성못2길 15 (두산동)
300단란주점소나타대구광역시 수성구 수성못6길 6 (두산동)
301단란주점인투(in2)대구광역시 수성구 청수로 117, 2층 (황금동)