Overview

Dataset statistics

Number of variables3
Number of observations86
Missing cells36
Missing cells (%)14.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory25.5 B

Variable types

Text3

Dataset

Description부산광역시남구_노래연습장업현황_20230626
Author부산광역시 남구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15045444

Alerts

상호명 has 1 (1.2%) missing valuesMissing
영업소도로명소재지 has 1 (1.2%) missing valuesMissing
전화번호 has 34 (39.5%) missing valuesMissing

Reproduction

Analysis started2024-04-21 08:18:23.923308
Analysis finished2024-04-21 08:18:25.288963
Duration1.37 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

MISSING 

Distinct82
Distinct (%)96.5%
Missing1
Missing (%)1.2%
Memory size816.0 B
2024-04-21T17:18:25.956484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length8.2941176
Min length6

Characters and Unicode

Total characters705
Distinct characters159
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

Unique79 ?
Unique (%)92.9%

Sample

1st row너랑나랑노래연습장
2nd row에뜨랑제노래연습장
3rd row앗사노래연습장
4th row하프노래연습장
5th row야호노래연습장
ValueCountFrequency (%)
노래연습장 10
 
10.0%
세느노래연습장 2
 
2.0%
마법의송노래연습장 2
 
2.0%
누구나노래연습장 2
 
2.0%
코인싱어 2
 
2.0%
7080 1
 
1.0%
짱헤라노래연습장 1
 
1.0%
아이팅노래연습장 1
 
1.0%
k-star2 1
 
1.0%
k-star 1
 
1.0%
Other values (77) 77
77.0%
2024-04-21T17:18:26.999996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
86
 
12.2%
86
 
12.2%
84
 
11.9%
84
 
11.9%
84
 
11.9%
15
 
2.1%
9
 
1.3%
9
 
1.3%
8
 
1.1%
6
 
0.9%
Other values (149) 234
33.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 650
92.2%
Uppercase Letter 24
 
3.4%
Space Separator 15
 
2.1%
Decimal Number 8
 
1.1%
Close Punctuation 3
 
0.4%
Open Punctuation 3
 
0.4%
Dash Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
86
13.2%
86
13.2%
84
12.9%
84
12.9%
84
12.9%
9
 
1.4%
9
 
1.4%
8
 
1.2%
6
 
0.9%
6
 
0.9%
Other values (126) 188
28.9%
Uppercase Letter
ValueCountFrequency (%)
C 4
16.7%
K 3
12.5%
Y 2
8.3%
R 2
8.3%
A 2
8.3%
T 2
8.3%
S 2
8.3%
D 1
 
4.2%
L 1
 
4.2%
E 1
 
4.2%
Other values (4) 4
16.7%
Decimal Number
ValueCountFrequency (%)
2 3
37.5%
0 2
25.0%
8 1
 
12.5%
7 1
 
12.5%
1 1
 
12.5%
Space Separator
ValueCountFrequency (%)
15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 650
92.2%
Common 31
 
4.4%
Latin 24
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
86
13.2%
86
13.2%
84
12.9%
84
12.9%
84
12.9%
9
 
1.4%
9
 
1.4%
8
 
1.2%
6
 
0.9%
6
 
0.9%
Other values (126) 188
28.9%
Latin
ValueCountFrequency (%)
C 4
16.7%
K 3
12.5%
Y 2
8.3%
R 2
8.3%
A 2
8.3%
T 2
8.3%
S 2
8.3%
D 1
 
4.2%
L 1
 
4.2%
E 1
 
4.2%
Other values (4) 4
16.7%
Common
ValueCountFrequency (%)
15
48.4%
) 3
 
9.7%
2 3
 
9.7%
( 3
 
9.7%
- 2
 
6.5%
0 2
 
6.5%
8 1
 
3.2%
7 1
 
3.2%
1 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 650
92.2%
ASCII 55
 
7.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
86
13.2%
86
13.2%
84
12.9%
84
12.9%
84
12.9%
9
 
1.4%
9
 
1.4%
8
 
1.2%
6
 
0.9%
6
 
0.9%
Other values (126) 188
28.9%
ASCII
ValueCountFrequency (%)
15
27.3%
C 4
 
7.3%
) 3
 
5.5%
K 3
 
5.5%
2 3
 
5.5%
( 3
 
5.5%
Y 2
 
3.6%
R 2
 
3.6%
A 2
 
3.6%
T 2
 
3.6%
Other values (13) 16
29.1%
Distinct84
Distinct (%)98.8%
Missing1
Missing (%)1.2%
Memory size816.0 B
2024-04-21T17:18:27.965739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length35
Mean length25.023529
Min length18

Characters and Unicode

Total characters2127
Distinct characters78
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

Unique83 ?
Unique (%)97.6%

Sample

1st row부산광역시 남구 용호로 112 (용호동)
2nd row부산광역시 남구 석포로 27 (감만동)
3rd row부산광역시 남구 동명로 125 (용호동)
4th row부산광역시 남구 문현로66번길 2 (문현동)
5th row부산광역시 남구 용호로 94, 지하 1층 (용호동)
ValueCountFrequency (%)
부산광역시 85
18.9%
남구 85
18.9%
대연동 40
 
8.9%
용호동 22
 
4.9%
문현동 12
 
2.7%
동명로 7
 
1.6%
감만동 7
 
1.6%
용소로8번길 6
 
1.3%
용소로13번길 5
 
1.1%
석포로 5
 
1.1%
Other values (109) 175
39.0%
2024-04-21T17:18:29.168826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
364
 
17.1%
97
 
4.6%
90
 
4.2%
85
 
4.0%
85
 
4.0%
85
 
4.0%
85
 
4.0%
85
 
4.0%
85
 
4.0%
85
 
4.0%
Other values (68) 981
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1266
59.5%
Space Separator 364
 
17.1%
Decimal Number 297
 
14.0%
Open Punctuation 84
 
3.9%
Close Punctuation 84
 
3.9%
Other Punctuation 24
 
1.1%
Dash Punctuation 8
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
97
 
7.7%
90
 
7.1%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
60
 
4.7%
Other values (53) 424
33.5%
Decimal Number
ValueCountFrequency (%)
1 80
26.9%
2 45
15.2%
3 39
13.1%
4 28
 
9.4%
6 23
 
7.7%
9 20
 
6.7%
7 18
 
6.1%
8 17
 
5.7%
5 17
 
5.7%
0 10
 
3.4%
Space Separator
ValueCountFrequency (%)
364
100.0%
Open Punctuation
ValueCountFrequency (%)
( 84
100.0%
Close Punctuation
ValueCountFrequency (%)
) 84
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1266
59.5%
Common 861
40.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
97
 
7.7%
90
 
7.1%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
60
 
4.7%
Other values (53) 424
33.5%
Common
ValueCountFrequency (%)
364
42.3%
( 84
 
9.8%
) 84
 
9.8%
1 80
 
9.3%
2 45
 
5.2%
3 39
 
4.5%
4 28
 
3.3%
, 24
 
2.8%
6 23
 
2.7%
9 20
 
2.3%
Other values (5) 70
 
8.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1266
59.5%
ASCII 861
40.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
364
42.3%
( 84
 
9.8%
) 84
 
9.8%
1 80
 
9.3%
2 45
 
5.2%
3 39
 
4.5%
4 28
 
3.3%
, 24
 
2.8%
6 23
 
2.7%
9 20
 
2.3%
Other values (5) 70
 
8.1%
Hangul
ValueCountFrequency (%)
97
 
7.7%
90
 
7.1%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
85
 
6.7%
60
 
4.7%
Other values (53) 424
33.5%

전화번호
Text

MISSING 

Distinct52
Distinct (%)100.0%
Missing34
Missing (%)39.5%
Memory size816.0 B
2024-04-21T17:18:29.951614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique

Unique52 ?
Unique (%)100.0%

Sample

1st row051-628-8444
2nd row051-644-0604
3rd row051-627-6753
4th row051-631-8401
5th row051-623-2201
ValueCountFrequency (%)
051-624-6622 1
 
1.9%
051-626-9200 1
 
1.9%
051-628-6219 1
 
1.9%
051-636-3035 1
 
1.9%
051-636-0308 1
 
1.9%
051-622-4348 1
 
1.9%
051-621-1646 1
 
1.9%
051-623-3512 1
 
1.9%
051-634-1114 1
 
1.9%
051-621-2184 1
 
1.9%
Other values (42) 42
80.8%
2024-04-21T17:18:30.938917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 104
16.7%
1 83
13.3%
6 82
13.1%
5 77
12.3%
0 69
11.1%
2 67
10.7%
4 44
7.1%
3 37
 
5.9%
8 27
 
4.3%
7 24
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 520
83.3%
Dash Punctuation 104
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 83
16.0%
6 82
15.8%
5 77
14.8%
0 69
13.3%
2 67
12.9%
4 44
8.5%
3 37
7.1%
8 27
 
5.2%
7 24
 
4.6%
9 10
 
1.9%
Dash Punctuation
ValueCountFrequency (%)
- 104
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 624
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 104
16.7%
1 83
13.3%
6 82
13.1%
5 77
12.3%
0 69
11.1%
2 67
10.7%
4 44
7.1%
3 37
 
5.9%
8 27
 
4.3%
7 24
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 624
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 104
16.7%
1 83
13.3%
6 82
13.1%
5 77
12.3%
0 69
11.1%
2 67
10.7%
4 44
7.1%
3 37
 
5.9%
8 27
 
4.3%
7 24
 
3.8%

Correlations

2024-04-21T17:18:31.091595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호명영업소도로명소재지전화번호
상호명1.0000.9961.000
영업소도로명소재지0.9961.0001.000
전화번호1.0001.0001.000

Missing values

2024-04-21T17:18:24.773928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T17:18:25.016077image/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.
2024-04-21T17:18:25.199111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

상호명영업소도로명소재지전화번호
0너랑나랑노래연습장부산광역시 남구 용호로 112 (용호동)051-628-8444
1에뜨랑제노래연습장부산광역시 남구 석포로 27 (감만동)051-644-0604
2앗사노래연습장부산광역시 남구 동명로 125 (용호동)051-627-6753
3하프노래연습장부산광역시 남구 문현로66번길 2 (문현동)051-631-8401
4야호노래연습장부산광역시 남구 용호로 94, 지하 1층 (용호동)051-623-2201
5금메달노래연습장부산광역시 남구 진남로 210 (문현동)051-634-2892
6채플린노래연습장부산광역시 남구 용호로106번길 56 (용호동)051-623-5268
7영상노래연습장부산광역시 남구 수영로266번길 29 (대연동)051-467-6469
8감만노래연습장부산광역시 남구 홍곡로 4 (감만동)051-647-8417
9애니콜노래연습장부산광역시 남구 진남로 181 (문현동)051-632-5243
상호명영업소도로명소재지전화번호
76코인싱어 동전노래연습장부산광역시 남구 용소로19번길 20, 2층 (대연동, 혜성빌딩)<NA>
77아이코인 노래연습장부산광역시 남구 용소로13번길 26, 4층 (대연동)<NA>
78CCY코인노래연습장(부경대점)부산광역시 남구 용소로13번길 12, 3층 (대연동, 쌍둥이빌딩)<NA>
79코인싱어 동전노래연습장(경성대점)부산광역시 남구 용소로8번길 7, 3층 (대연동)<NA>
80온 노래연습장부산광역시 남구 수영로322번길 22, 지하1층 (대연동, 반석빌딩)051-627-2225
81포텐코인노래연습장부산광역시 남구 동명로 142, 4층 (용호동)<NA>
82락휴 코인노래연습장 대연점부산광역시 남구 용소로7번길 45, 2층 (대연동)<NA>
83대왕동전노래연습장부산광역시 남구 용소로13번길 6 (대연동)<NA>
84큐브코인노래연습장부산광역시 남구 용소로13번길 13, 3층 (대연동)<NA>
85<NA><NA><NA>