Overview

Dataset statistics

Number of variables5
Number of observations208
Missing cells38
Missing cells (%)3.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.2 KiB
Average record size in memory40.6 B

Variable types

Categorical1
Text4

Dataset

Description부산광역시북구_유흥단란주점현황_20221027
Author부산광역시 북구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15006767

Alerts

소재지전화 has 38 (18.3%) missing valuesMissing

Reproduction

Analysis started2024-04-21 10:01:15.688702
Analysis finished2024-04-21 10:01:16.443039
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
유흥주점영업
142 
단란주점
66 

Length

Max length6
Median length6
Mean length5.3653846
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
유흥주점영업 142
68.3%
단란주점 66
31.7%

Length

2024-04-21T19:01:16.578290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T19:01:16.776903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 142
68.3%
단란주점 66
31.7%

업소명
Text

Distinct204
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-04-21T19:01:17.503523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length5.2644231
Min length1

Characters and Unicode

Total characters1095
Distinct characters288
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

Unique200 ?
Unique (%)96.2%

Sample

1st row애니팡
2nd row볼륨노래타운
3rd row롯데
4th row룰루랄라
5th row에로스
ValueCountFrequency (%)
뉴코뮤직타운 3
 
1.4%
오아시스 2
 
0.9%
왕비 2
 
0.9%
피앙새노래주점 2
 
0.9%
황금 2
 
0.9%
설탕 2
 
0.9%
실내포장 1
 
0.5%
샘물 1
 
0.5%
윙크노래방 1
 
0.5%
애니팡 1
 
0.5%
Other values (198) 198
92.1%
2024-04-21T19:01:18.490815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 69
 
6.3%
래 67
 
6.1%
노 66
 
6.0%
주 66
 
6.0%
이 27
 
2.5%
스 27
 
2.5%
타 26
 
2.4%
방 24
 
2.2%
비 18
 
1.6%
장 16
 
1.5%
Other values (278) 689
62.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1026
93.7%
Decimal Number 35
 
3.2%
Uppercase Letter 14
 
1.3%
Space Separator 7
 
0.6%
Lowercase Letter 5
 
0.5%
Close Punctuation 4
 
0.4%
Open Punctuation 4
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 69
 
6.7%
래 67
 
6.5%
노 66
 
6.4%
주 66
 
6.4%
이 27
 
2.6%
스 27
 
2.6%
타 26
 
2.5%
방 24
 
2.3%
비 18
 
1.8%
장 16
 
1.6%
Other values (253) 620
60.4%
Uppercase Letter
ValueCountFrequency (%)
N 3
21.4%
I 2
14.3%
E 2
14.3%
T 1
 
7.1%
J 1
 
7.1%
R 1
 
7.1%
A 1
 
7.1%
L 1
 
7.1%
V 1
 
7.1%
P 1
 
7.1%
Decimal Number
ValueCountFrequency (%)
0 12
34.3%
7 6
17.1%
8 6
17.1%
2 3
 
8.6%
3 3
 
8.6%
9 2
 
5.7%
4 1
 
2.9%
1 1
 
2.9%
6 1
 
2.9%
Lowercase Letter
ValueCountFrequency (%)
i 2
40.0%
z 2
40.0%
a 1
20.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1026
93.7%
Common 50
 
4.6%
Latin 19
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 69
 
6.7%
래 67
 
6.5%
노 66
 
6.4%
주 66
 
6.4%
이 27
 
2.6%
스 27
 
2.6%
타 26
 
2.5%
방 24
 
2.3%
비 18
 
1.8%
장 16
 
1.6%
Other values (253) 620
60.4%
Latin
ValueCountFrequency (%)
N 3
15.8%
I 2
10.5%
i 2
10.5%
z 2
10.5%
E 2
10.5%
T 1
 
5.3%
J 1
 
5.3%
a 1
 
5.3%
R 1
 
5.3%
A 1
 
5.3%
Other values (3) 3
15.8%
Common
ValueCountFrequency (%)
0 12
24.0%
7
14.0%
7 6
12.0%
8 6
12.0%
) 4
 
8.0%
( 4
 
8.0%
2 3
 
6.0%
3 3
 
6.0%
9 2
 
4.0%
4 1
 
2.0%
Other values (2) 2
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1026
93.7%
ASCII 69
 
6.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 69
 
6.7%
래 67
 
6.5%
노 66
 
6.4%
주 66
 
6.4%
이 27
 
2.6%
스 27
 
2.6%
타 26
 
2.5%
방 24
 
2.3%
비 18
 
1.8%
장 16
 
1.6%
Other values (253) 620
60.4%
ASCII
ValueCountFrequency (%)
0 12
17.4%
7
 
10.1%
7 6
 
8.7%
8 6
 
8.7%
) 4
 
5.8%
( 4
 
5.8%
2 3
 
4.3%
3 3
 
4.3%
N 3
 
4.3%
9 2
 
2.9%
Other values (15) 19
27.5%

소재지(도로명)
Text

Distinct191
Distinct (%)91.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-04-21T19:01:19.203123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length40
Mean length28.322115
Min length20

Characters and Unicode

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

Unique

Unique176 ?
Unique (%)84.6%

Sample

1st row부산광역시 북구 낙동대로 1778 (구포동)
2nd row부산광역시 북구 만덕대로16번길 8 (덕천동)
3rd row부산광역시 북구 낙동대로 1688 (구포동)
4th row부산광역시 북구 구포만세길 69 (구포동)
5th row부산광역시 북구 금곡대로 12, 지하1층 (덕천동)
ValueCountFrequency (%)
부산광역시 208
18.1%
북구 208
18.1%
구포동 69
 
6.0%
덕천동 64
 
5.6%
화명동 30
 
2.6%
금곡대로285번길 24
 
2.1%
낙동대로 17
 
1.5%
금곡대로8번길 17
 
1.5%
2층 17
 
1.5%
5 16
 
1.4%
Other values (189) 479
41.7%
2024-04-21T19:01:20.168766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
941
 
16.0%
구 304
 
5.2%
동 252
 
4.3%
시 240
 
4.1%
1 227
 
3.9%
부 210
 
3.6%
) 209
 
3.5%
( 209
 
3.5%
광 208
 
3.5%
역 208
 
3.5%
Other values (89) 2883
48.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3478
59.0%
Space Separator 941
 
16.0%
Decimal Number 915
 
15.5%
Close Punctuation 209
 
3.5%
Open Punctuation 209
 
3.5%
Other Punctuation 121
 
2.1%
Dash Punctuation 17
 
0.3%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 304
 
8.7%
동 252
 
7.2%
시 240
 
6.9%
부 210
 
6.0%
광 208
 
6.0%
역 208
 
6.0%
북 208
 
6.0%
산 208
 
6.0%
로 177
 
5.1%
대 143
 
4.1%
Other values (73) 1320
38.0%
Decimal Number
ValueCountFrequency (%)
1 227
24.8%
2 112
12.2%
3 97
10.6%
0 83
 
9.1%
7 81
 
8.9%
8 77
 
8.4%
5 73
 
8.0%
6 68
 
7.4%
4 50
 
5.5%
9 47
 
5.1%
Space Separator
ValueCountFrequency (%)
941
100.0%
Close Punctuation
ValueCountFrequency (%)
) 209
100.0%
Open Punctuation
ValueCountFrequency (%)
( 209
100.0%
Other Punctuation
ValueCountFrequency (%)
, 121
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3478
59.0%
Common 2412
40.9%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 304
 
8.7%
동 252
 
7.2%
시 240
 
6.9%
부 210
 
6.0%
광 208
 
6.0%
역 208
 
6.0%
북 208
 
6.0%
산 208
 
6.0%
로 177
 
5.1%
대 143
 
4.1%
Other values (73) 1320
38.0%
Common
ValueCountFrequency (%)
941
39.0%
1 227
 
9.4%
) 209
 
8.7%
( 209
 
8.7%
, 121
 
5.0%
2 112
 
4.6%
3 97
 
4.0%
0 83
 
3.4%
7 81
 
3.4%
8 77
 
3.2%
Other values (5) 255
 
10.6%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3478
59.0%
ASCII 2413
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
941
39.0%
1 227
 
9.4%
) 209
 
8.7%
( 209
 
8.7%
, 121
 
5.0%
2 112
 
4.6%
3 97
 
4.0%
0 83
 
3.4%
7 81
 
3.4%
8 77
 
3.2%
Other values (6) 256
 
10.6%
Hangul
ValueCountFrequency (%)
구 304
 
8.7%
동 252
 
7.2%
시 240
 
6.9%
부 210
 
6.0%
광 208
 
6.0%
역 208
 
6.0%
북 208
 
6.0%
산 208
 
6.0%
로 177
 
5.1%
대 143
 
4.1%
Other values (73) 1320
38.0%

소재지(지번)
Text

Distinct181
Distinct (%)87.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-04-21T19:01:21.168339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length35
Mean length22.125
Min length17

Characters and Unicode

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

Unique

Unique158 ?
Unique (%)76.0%

Sample

1st row부산광역시 북구 구포동 145-1
2nd row부산광역시 북구 덕천동 400-8
3rd row부산광역시 북구 구포동 1060-288
4th row부산광역시 북구 구포동 1060-266
5th row부산광역시 북구 덕천동 396-1 (지하1층)
ValueCountFrequency (%)
부산광역시 208
22.3%
북구 208
22.3%
구포동 73
 
7.8%
덕천동 71
 
7.6%
화명동 51
 
5.5%
만덕동 13
 
1.4%
2층 11
 
1.2%
지층 11
 
1.2%
지하1층 9
 
1.0%
396-7 6
 
0.6%
Other values (188) 273
29.2%
2024-04-21T19:01:22.443228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
923
20.1%
구 281
 
6.1%
부 209
 
4.5%
동 209
 
4.5%
북 208
 
4.5%
산 208
 
4.5%
시 208
 
4.5%
역 208
 
4.5%
광 208
 
4.5%
- 202
 
4.4%
Other values (73) 1738
37.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2349
51.0%
Decimal Number 1110
24.1%
Space Separator 923
 
20.1%
Dash Punctuation 202
 
4.4%
Other Punctuation 7
 
0.2%
Close Punctuation 5
 
0.1%
Open Punctuation 5
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 281
12.0%
부 209
8.9%
동 209
8.9%
북 208
8.9%
산 208
8.9%
시 208
8.9%
역 208
8.9%
광 208
8.9%
덕 84
 
3.6%
포 74
 
3.2%
Other values (57) 452
19.2%
Decimal Number
ValueCountFrequency (%)
2 186
16.8%
1 157
14.1%
5 133
12.0%
3 133
12.0%
0 106
9.5%
7 92
8.3%
4 88
7.9%
9 88
7.9%
6 75
6.8%
8 52
 
4.7%
Space Separator
ValueCountFrequency (%)
923
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 202
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2349
51.0%
Common 2252
48.9%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 281
12.0%
부 209
8.9%
동 209
8.9%
북 208
8.9%
산 208
8.9%
시 208
8.9%
역 208
8.9%
광 208
8.9%
덕 84
 
3.6%
포 74
 
3.2%
Other values (57) 452
19.2%
Common
ValueCountFrequency (%)
923
41.0%
- 202
 
9.0%
2 186
 
8.3%
1 157
 
7.0%
5 133
 
5.9%
3 133
 
5.9%
0 106
 
4.7%
7 92
 
4.1%
4 88
 
3.9%
9 88
 
3.9%
Other values (5) 144
 
6.4%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2349
51.0%
ASCII 2253
49.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
923
41.0%
- 202
 
9.0%
2 186
 
8.3%
1 157
 
7.0%
5 133
 
5.9%
3 133
 
5.9%
0 106
 
4.7%
7 92
 
4.1%
4 88
 
3.9%
9 88
 
3.9%
Other values (6) 145
 
6.4%
Hangul
ValueCountFrequency (%)
구 281
12.0%
부 209
8.9%
동 209
8.9%
북 208
8.9%
산 208
8.9%
시 208
8.9%
역 208
8.9%
광 208
8.9%
덕 84
 
3.6%
포 74
 
3.2%
Other values (57) 452
19.2%

소재지전화
Text

MISSING 

Distinct165
Distinct (%)97.1%
Missing38
Missing (%)18.3%
Memory size1.8 KiB
2024-04-21T19:01:23.327226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.264706
Min length12

Characters and Unicode

Total characters2085
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique160 ?
Unique (%)94.1%

Sample

1st row 051-332-3913
2nd row051-337-6336
3rd row 051-337-6620
4th row051-334-3343
5th row 051-336-2112
ValueCountFrequency (%)
051-331-4745 2
 
1.2%
051-341-1218 2
 
1.2%
051-334-6660 2
 
1.2%
051-361-7589 2
 
1.2%
051-364-3007 2
 
1.2%
051-341-3040 2
 
1.2%
051-332-3913 1
 
0.6%
051-335-1914 1
 
0.6%
051-338-5914 1
 
0.6%
051-338-5053 1
 
0.6%
Other values (155) 155
90.6%
2024-04-21T19:01:24.424201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 380
18.2%
- 340
16.3%
1 280
13.4%
0 261
12.5%
5 260
12.5%
6 126
 
6.0%
4 107
 
5.1%
8 84
 
4.0%
2 81
 
3.9%
7 78
 
3.7%
Other values (2) 88
 
4.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1700
81.5%
Dash Punctuation 340
 
16.3%
Space Separator 45
 
2.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 380
22.4%
1 280
16.5%
0 261
15.4%
5 260
15.3%
6 126
 
7.4%
4 107
 
6.3%
8 84
 
4.9%
2 81
 
4.8%
7 78
 
4.6%
9 43
 
2.5%
Dash Punctuation
ValueCountFrequency (%)
- 340
100.0%
Space Separator
ValueCountFrequency (%)
45
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2085
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 380
18.2%
- 340
16.3%
1 280
13.4%
0 261
12.5%
5 260
12.5%
6 126
 
6.0%
4 107
 
5.1%
8 84
 
4.0%
2 81
 
3.9%
7 78
 
3.7%
Other values (2) 88
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2085
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 380
18.2%
- 340
16.3%
1 280
13.4%
0 261
12.5%
5 260
12.5%
6 126
 
6.0%
4 107
 
5.1%
8 84
 
4.0%
2 81
 
3.9%
7 78
 
3.7%
Other values (2) 88
 
4.2%

Missing values

2024-04-21T19:01:16.211691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T19:01:16.378761image/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유흥주점영업애니팡부산광역시 북구 낙동대로 1778 (구포동)부산광역시 북구 구포동 145-1051-332-3913
1유흥주점영업볼륨노래타운부산광역시 북구 만덕대로16번길 8 (덕천동)부산광역시 북구 덕천동 400-8051-337-6336
2유흥주점영업롯데부산광역시 북구 낙동대로 1688 (구포동)부산광역시 북구 구포동 1060-288<NA>
3유흥주점영업룰루랄라부산광역시 북구 구포만세길 69 (구포동)부산광역시 북구 구포동 1060-266051-337-6620
4유흥주점영업에로스부산광역시 북구 금곡대로 12, 지하1층 (덕천동)부산광역시 북구 덕천동 396-1 (지하1층)051-334-3343
5유흥주점영업로얄스텐드노래주점부산광역시 북구 낙동대로1781번길 9, 지층 (덕천동)부산광역시 북구 덕천동 352-4 지층051-336-2112
6유흥주점영업베스트노래방주점부산광역시 북구 백양대로 1197 (구포동,지층)부산광역시 북구 구포동 147-9 지층051-335-9727
7유흥주점영업피라밋노래주점부산광역시 북구 만덕대로 9 (덕천동)부산광역시 북구 덕천동 399-4051-363-2845
8유흥주점영업해성노래방주점부산광역시 북구 백양대로 1199-10 (구포동)부산광역시 북구 구포동 146-9051-342-9883
9유흥주점영업쵸이스노래방식주점부산광역시 북구 금곡대로7번길 11 (덕천동, 지층)부산광역시 북구 덕천동 353-16 지층051-331-4745
업종명업소명소재지(도로명)소재지(지번)소재지전화
198단란주점락휴노래타운덕천점부산광역시 북구 덕천1길 41, 3층 301호 (덕천동)부산광역시 북구 덕천동 401-7 (3층) 301호051-334-6660
199단란주점비바노래타운부산광역시 북구 만덕대로28번길 9, 2층 (덕천동)부산광역시 북구 덕천동 383-12<NA>
200단란주점수정단란주점부산광역시 북구 금곡대로303번길 80, 3층 305호 (화명동, 화명코아프라자)부산광역시 북구 화명동 2266-3 화명코아프라자 305호051-337-5215
201단란주점코뿔소라이브부산광역시 북구 화명신도시로 130, 3층 303호 (화명동, 로얄펠리스)부산광역시 북구 화명동 2272-1 로얄펠리스 303호051-361-3269
202단란주점꿈의대화라이브부산광역시 북구 금곡대로285번길 39 (화명동, 대일코아빌딩 203호)부산광역시 북구 화명동 2286-2051-331-4480
203단란주점7080딥퍼플가라오케부산광역시 북구 금곡대로285번길 40, 3층 303호 (화명동, 한빛프라자)부산광역시 북구 화명동 2276-5 한빛프라자 303호<NA>
204단란주점로타리실내포장부산광역시 북구 만덕대로 11-1, 지하1층 (덕천동)부산광역시 북구 덕천동 399-7 지하1층<NA>
205단란주점그날 실내포장부산광역시 북구 구포시장길 3, 지하1층 (구포동)부산광역시 북구 구포동 599-6 지하1층051-338-7403
206단란주점티니(TiNi)부산광역시 북구 낙동대로 1708-1, 지하1층,1층 (구포동)부산광역시 북구 구포동 1060-407<NA>
207단란주점고고단란주점부산광역시 북구 금곡대로285번길 62, 스카이타워 203호 (화명동)부산광역시 북구 화명동 2275-5 스카이타워 203호<NA>