Overview

Dataset statistics

Number of variables5
Number of observations207
Missing cells39
Missing cells (%)3.8%
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부산광역시 북구 관내에 존재하는 유흥업소 및 단란주점 현황 데이터로 업종, 업소명, 도로명주소, 지번주소, 전화번호 등의 항목을 제공합니다.
Author부산광역시 북구
URLhttps://www.data.go.kr/data/15006767/fileData.do

Alerts

소재지전화 has 39 (18.8%) missing valuesMissing

Reproduction

Analysis started2023-12-12 13:58:00.698684
Analysis finished2023-12-12 13:58:01.157097
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

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

Length

Max length6
Median length6
Mean length5.3623188
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
유흥주점영업 141
68.1%
단란주점 66
31.9%

Length

2023-12-12T22:58:01.232651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:58:01.346663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 141
68.1%
단란주점 66
31.9%
Distinct203
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-12T22:58:01.624286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length5.2898551
Min length1

Characters and Unicode

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

Unique199 ?
Unique (%)96.1%

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%
2023-12-12T22:58:02.074625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
67
 
6.1%
66
 
6.0%
66
 
6.0%
63
 
5.8%
29
 
2.6%
27
 
2.5%
26
 
2.4%
25
 
2.3%
17
 
1.6%
16
 
1.5%
Other values (273) 693
63.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1022
93.3%
Decimal Number 37
 
3.4%
Uppercase Letter 15
 
1.4%
Space Separator 8
 
0.7%
Lowercase Letter 5
 
0.5%
Close Punctuation 4
 
0.4%
Open Punctuation 4
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
67
 
6.6%
66
 
6.5%
66
 
6.5%
63
 
6.2%
29
 
2.8%
27
 
2.6%
26
 
2.5%
25
 
2.4%
17
 
1.7%
16
 
1.6%
Other values (248) 620
60.7%
Uppercase Letter
ValueCountFrequency (%)
N 3
20.0%
E 2
13.3%
I 2
13.3%
M 1
 
6.7%
T 1
 
6.7%
J 1
 
6.7%
R 1
 
6.7%
A 1
 
6.7%
L 1
 
6.7%
V 1
 
6.7%
Decimal Number
ValueCountFrequency (%)
0 14
37.8%
7 7
18.9%
8 7
18.9%
3 3
 
8.1%
2 2
 
5.4%
9 2
 
5.4%
1 1
 
2.7%
6 1
 
2.7%
Lowercase Letter
ValueCountFrequency (%)
i 2
40.0%
z 2
40.0%
a 1
20.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1022
93.3%
Common 53
 
4.8%
Latin 20
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
67
 
6.6%
66
 
6.5%
66
 
6.5%
63
 
6.2%
29
 
2.8%
27
 
2.6%
26
 
2.5%
25
 
2.4%
17
 
1.7%
16
 
1.6%
Other values (248) 620
60.7%
Latin
ValueCountFrequency (%)
N 3
15.0%
i 2
10.0%
E 2
10.0%
z 2
10.0%
I 2
10.0%
a 1
 
5.0%
M 1
 
5.0%
T 1
 
5.0%
J 1
 
5.0%
R 1
 
5.0%
Other values (4) 4
20.0%
Common
ValueCountFrequency (%)
0 14
26.4%
8
15.1%
7 7
13.2%
8 7
13.2%
) 4
 
7.5%
( 4
 
7.5%
3 3
 
5.7%
2 2
 
3.8%
9 2
 
3.8%
1 1
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1022
93.3%
ASCII 73
 
6.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
67
 
6.6%
66
 
6.5%
66
 
6.5%
63
 
6.2%
29
 
2.8%
27
 
2.6%
26
 
2.5%
25
 
2.4%
17
 
1.7%
16
 
1.6%
Other values (248) 620
60.7%
ASCII
ValueCountFrequency (%)
0 14
19.2%
8
11.0%
7 7
 
9.6%
8 7
 
9.6%
) 4
 
5.5%
( 4
 
5.5%
3 3
 
4.1%
N 3
 
4.1%
2 2
 
2.7%
9 2
 
2.7%
Other values (15) 19
26.0%
Distinct190
Distinct (%)91.8%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-12T22:58:02.356415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length40
Mean length28.478261
Min length20

Characters and Unicode

Total characters5895
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

Unique175 ?
Unique (%)84.5%

Sample

1st row부산광역시 북구 낙동대로 1778 (구포동)
2nd row부산광역시 북구 만덕대로16번길 8 (덕천동)
3rd row부산광역시 북구 낙동대로 1688 (구포동)
4th row부산광역시 북구 구포만세길 69 (구포동)
5th row부산광역시 북구 금곡대로 12, 지하1층 (덕천동)
ValueCountFrequency (%)
부산광역시 207
18.0%
북구 207
18.0%
구포동 66
 
5.7%
덕천동 65
 
5.7%
화명동 31
 
2.7%
금곡대로285번길 25
 
2.2%
금곡대로8번길 18
 
1.6%
2층 18
 
1.6%
5 17
 
1.5%
낙동대로 15
 
1.3%
Other values (188) 479
41.7%
2023-12-12T22:58:02.769625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
941
 
16.0%
299
 
5.1%
249
 
4.2%
239
 
4.1%
1 227
 
3.9%
209
 
3.5%
) 208
 
3.5%
( 208
 
3.5%
207
 
3.5%
207
 
3.5%
Other values (89) 2901
49.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3480
59.0%
Space Separator 941
 
16.0%
Decimal Number 917
 
15.6%
Close Punctuation 208
 
3.5%
Open Punctuation 208
 
3.5%
Other Punctuation 123
 
2.1%
Dash Punctuation 17
 
0.3%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
299
 
8.6%
249
 
7.2%
239
 
6.9%
209
 
6.0%
207
 
5.9%
207
 
5.9%
207
 
5.9%
207
 
5.9%
177
 
5.1%
143
 
4.1%
Other values (73) 1336
38.4%
Decimal Number
ValueCountFrequency (%)
1 227
24.8%
2 115
12.5%
3 97
10.6%
0 84
 
9.2%
7 81
 
8.8%
8 78
 
8.5%
5 75
 
8.2%
6 66
 
7.2%
9 47
 
5.1%
4 47
 
5.1%
Space Separator
ValueCountFrequency (%)
941
100.0%
Close Punctuation
ValueCountFrequency (%)
) 208
100.0%
Open Punctuation
ValueCountFrequency (%)
( 208
100.0%
Other Punctuation
ValueCountFrequency (%)
, 123
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3480
59.0%
Common 2414
40.9%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
299
 
8.6%
249
 
7.2%
239
 
6.9%
209
 
6.0%
207
 
5.9%
207
 
5.9%
207
 
5.9%
207
 
5.9%
177
 
5.1%
143
 
4.1%
Other values (73) 1336
38.4%
Common
ValueCountFrequency (%)
941
39.0%
1 227
 
9.4%
) 208
 
8.6%
( 208
 
8.6%
, 123
 
5.1%
2 115
 
4.8%
3 97
 
4.0%
0 84
 
3.5%
7 81
 
3.4%
8 78
 
3.2%
Other values (5) 252
 
10.4%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3480
59.0%
ASCII 2415
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
941
39.0%
1 227
 
9.4%
) 208
 
8.6%
( 208
 
8.6%
, 123
 
5.1%
2 115
 
4.8%
3 97
 
4.0%
0 84
 
3.5%
7 81
 
3.4%
8 78
 
3.2%
Other values (6) 253
 
10.5%
Hangul
ValueCountFrequency (%)
299
 
8.6%
249
 
7.2%
239
 
6.9%
209
 
6.0%
207
 
5.9%
207
 
5.9%
207
 
5.9%
207
 
5.9%
177
 
5.1%
143
 
4.1%
Other values (73) 1336
38.4%
Distinct179
Distinct (%)86.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-12T22:58:03.073020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length35
Mean length22.183575
Min length17

Characters and Unicode

Total characters4592
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

Unique155 ?
Unique (%)74.9%

Sample

1st row부산광역시 북구 구포동 145-1
2nd row부산광역시 북구 덕천동 400-8
3rd row부산광역시 북구 구포동 1060-288
4th row부산광역시 북구 구포동 1060-266
5th row부산광역시 북구 덕천동 396-1 (지하1층)
ValueCountFrequency (%)
부산광역시 207
22.2%
북구 207
22.2%
덕천동 72
 
7.7%
구포동 70
 
7.5%
화명동 52
 
5.6%
만덕동 13
 
1.4%
지층 11
 
1.2%
2층 11
 
1.2%
지하1층 9
 
1.0%
2275-5 7
 
0.8%
Other values (187) 272
29.2%
2023-12-12T22:58:03.588798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
920
20.0%
277
 
6.0%
208
 
4.5%
208
 
4.5%
207
 
4.5%
207
 
4.5%
207
 
4.5%
207
 
4.5%
207
 
4.5%
- 203
 
4.4%
Other values (73) 1741
37.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2347
51.1%
Decimal Number 1106
24.1%
Space Separator 920
 
20.0%
Dash Punctuation 203
 
4.4%
Other Punctuation 7
 
0.2%
Open Punctuation 4
 
0.1%
Close Punctuation 4
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
277
11.8%
208
8.9%
208
8.9%
207
8.8%
207
8.8%
207
8.8%
207
8.8%
207
8.8%
85
 
3.6%
72
 
3.1%
Other values (57) 462
19.7%
Decimal Number
ValueCountFrequency (%)
2 188
17.0%
1 157
14.2%
5 134
12.1%
3 129
11.7%
0 104
9.4%
7 92
8.3%
9 89
8.0%
4 86
7.8%
6 75
 
6.8%
8 52
 
4.7%
Space Separator
ValueCountFrequency (%)
920
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 203
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2347
51.1%
Common 2244
48.9%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
277
11.8%
208
8.9%
208
8.9%
207
8.8%
207
8.8%
207
8.8%
207
8.8%
207
8.8%
85
 
3.6%
72
 
3.1%
Other values (57) 462
19.7%
Common
ValueCountFrequency (%)
920
41.0%
- 203
 
9.0%
2 188
 
8.4%
1 157
 
7.0%
5 134
 
6.0%
3 129
 
5.7%
0 104
 
4.6%
7 92
 
4.1%
9 89
 
4.0%
4 86
 
3.8%
Other values (5) 142
 
6.3%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2347
51.1%
ASCII 2245
48.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
920
41.0%
- 203
 
9.0%
2 188
 
8.4%
1 157
 
7.0%
5 134
 
6.0%
3 129
 
5.7%
0 104
 
4.6%
7 92
 
4.1%
9 89
 
4.0%
4 86
 
3.8%
Other values (6) 143
 
6.4%
Hangul
ValueCountFrequency (%)
277
11.8%
208
8.9%
208
8.9%
207
8.8%
207
8.8%
207
8.8%
207
8.8%
207
8.8%
85
 
3.6%
72
 
3.1%
Other values (57) 462
19.7%

소재지전화
Text

MISSING 

Distinct163
Distinct (%)97.0%
Missing39
Missing (%)18.8%
Memory size1.7 KiB
2023-12-12T22:58:03.891601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.267857
Min length12

Characters and Unicode

Total characters2061
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

Unique158 ?
Unique (%)94.0%

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-364-3007 2
 
1.2%
051-341-3040 2
 
1.2%
051-334-6660 2
 
1.2%
051-361-7589 2
 
1.2%
051-331-4745 2
 
1.2%
051-341-1218 2
 
1.2%
051-337-5060 1
 
0.6%
051-332-3913 1
 
0.6%
051-338-5914 1
 
0.6%
051-338-5053 1
 
0.6%
Other values (152) 152
90.5%
2023-12-12T22:58:04.277764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 374
18.1%
- 336
16.3%
1 278
13.5%
0 260
12.6%
5 253
12.3%
6 128
 
6.2%
4 105
 
5.1%
8 86
 
4.2%
7 77
 
3.7%
2 76
 
3.7%
Other values (2) 88
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1681
81.6%
Dash Punctuation 336
 
16.3%
Space Separator 44
 
2.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 374
22.2%
1 278
16.5%
0 260
15.5%
5 253
15.1%
6 128
 
7.6%
4 105
 
6.2%
8 86
 
5.1%
7 77
 
4.6%
2 76
 
4.5%
9 44
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 336
100.0%
Space Separator
ValueCountFrequency (%)
44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2061
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 374
18.1%
- 336
16.3%
1 278
13.5%
0 260
12.6%
5 253
12.3%
6 128
 
6.2%
4 105
 
5.1%
8 86
 
4.2%
7 77
 
3.7%
2 76
 
3.7%
Other values (2) 88
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2061
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 374
18.1%
- 336
16.3%
1 278
13.5%
0 260
12.6%
5 253
12.3%
6 128
 
6.2%
4 105
 
5.1%
8 86
 
4.2%
7 77
 
3.7%
2 76
 
3.7%
Other values (2) 88
 
4.3%

Missing values

2023-12-12T22:58:01.021373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:58:01.121959image/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
업종명업소명소재지(도로명)소재지(지번)소재지전화
197단란주점수정단란주점부산광역시 북구 금곡대로303번길 80, 3층 305호 (화명동, 화명코아프라자)부산광역시 북구 화명동 2266-3 화명코아프라자 305호051-337-5215
198단란주점코뿔소라이브부산광역시 북구 화명신도시로 130, 3층 303호 (화명동, 로얄펠리스)부산광역시 북구 화명동 2272-1 로얄펠리스 303호051-361-3269
199단란주점꿈의대화라이브부산광역시 북구 금곡대로285번길 39 (화명동, 대일코아빌딩 203호)부산광역시 북구 화명동 2286-2051-331-4480
200단란주점7080딥퍼플가라오케부산광역시 북구 금곡대로285번길 40, 3층 303호 (화명동, 한빛프라자)부산광역시 북구 화명동 2276-5 한빛프라자 303호<NA>
201단란주점로타리실내포장부산광역시 북구 만덕대로 11-1, 지하1층 (덕천동)부산광역시 북구 덕천동 399-7 지하1층<NA>
202단란주점그날 실내포장부산광역시 북구 구포시장길 3, 지하1층 (구포동)부산광역시 북구 구포동 599-6 지하1층051-338-7403
203단란주점티니(TiNi)부산광역시 북구 낙동대로 1708-1, 지하1층,1층 (구포동)부산광역시 북구 구포동 1060-407<NA>
204단란주점고고단란주점부산광역시 북구 금곡대로285번길 62, 스카이타워 203호 (화명동)부산광역시 북구 화명동 2275-5 스카이타워 203호<NA>
205단란주점M라이브부산광역시 북구 금곡대로285번길 62, 스카이타워 301호 (화명동)부산광역시 북구 화명동 2275-5 스카이타워<NA>
206단란주점베테랑7080부산광역시 북구 금곡대로8번길 5, 남현빌딩 1층 (덕천동)부산광역시 북구 덕천동 396-7 남현빌딩<NA>