Overview

Dataset statistics

Number of variables3
Number of observations174
Missing cells119
Missing cells (%)22.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory24.8 B

Variable types

Text3

Dataset

Description서울특별시 성동구 노래연습장 현황 정보입니다. 노래방 상호명, 영업소 도로명 소재지 주소, 영업장 전화번호 등의 정보를 포함하고 있습니다.
URLhttps://www.data.go.kr/data/15084624/fileData.do

Alerts

전화번호 has 117 (67.2%) missing valuesMissing

Reproduction

Analysis started2023-12-12 04:08:32.056928
Analysis finished2023-12-12 04:08:32.648858
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

Distinct160
Distinct (%)92.5%
Missing1
Missing (%)0.6%
Memory size1.5 KiB
2023-12-12T13:08:32.994605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length14
Mean length7.699422
Min length2

Characters and Unicode

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

Unique

Unique149 ?
Unique (%)86.1%

Sample

1st row1,2,3노래연습장
2nd row기린노래방
3rd rowSao Mai 노래연습장
4th row세븐틴코인노래연습장(성수점)
5th row즐거운 노래방
ValueCountFrequency (%)
노래연습장 46
 
19.0%
노래방 8
 
3.3%
코인노래연습장 7
 
2.9%
팡팡노래연습장 3
 
1.2%
열창노래방 3
 
1.2%
즐거운 3
 
1.2%
도깨비코인노래연습장 2
 
0.8%
스타 2
 
0.8%
얼짱 2
 
0.8%
이브노래연습장 2
 
0.8%
Other values (157) 164
67.8%
2023-12-12T13:08:33.556610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
래 170
 
12.8%
노 167
 
12.5%
연 125
 
9.4%
습 125
 
9.4%
장 121
 
9.1%
69
 
5.2%
방 46
 
3.5%
코 19
 
1.4%
인 15
 
1.1%
스 14
 
1.1%
Other values (211) 461
34.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1203
90.3%
Space Separator 69
 
5.2%
Uppercase Letter 26
 
2.0%
Decimal Number 15
 
1.1%
Lowercase Letter 8
 
0.6%
Open Punctuation 3
 
0.2%
Close Punctuation 3
 
0.2%
Other Punctuation 3
 
0.2%
Math Symbol 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
래 170
14.1%
노 167
13.9%
연 125
 
10.4%
습 125
 
10.4%
장 121
 
10.1%
방 46
 
3.8%
코 19
 
1.6%
인 15
 
1.2%
스 14
 
1.2%
타 14
 
1.2%
Other values (181) 387
32.2%
Uppercase Letter
ValueCountFrequency (%)
S 8
30.8%
D 4
15.4%
V 3
 
11.5%
B 3
 
11.5%
R 2
 
7.7%
M 1
 
3.8%
Y 1
 
3.8%
K 1
 
3.8%
I 1
 
3.8%
P 1
 
3.8%
Decimal Number
ValueCountFrequency (%)
2 5
33.3%
5 3
20.0%
1 2
 
13.3%
0 2
 
13.3%
3 1
 
6.7%
6 1
 
6.7%
9 1
 
6.7%
Lowercase Letter
ValueCountFrequency (%)
e 2
25.0%
a 2
25.0%
i 1
12.5%
l 1
12.5%
f 1
12.5%
o 1
12.5%
Other Punctuation
ValueCountFrequency (%)
, 2
66.7%
@ 1
33.3%
Space Separator
ValueCountFrequency (%)
69
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1203
90.3%
Common 95
 
7.1%
Latin 34
 
2.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
래 170
14.1%
노 167
13.9%
연 125
 
10.4%
습 125
 
10.4%
장 121
 
10.1%
방 46
 
3.8%
코 19
 
1.6%
인 15
 
1.2%
스 14
 
1.2%
타 14
 
1.2%
Other values (181) 387
32.2%
Latin
ValueCountFrequency (%)
S 8
23.5%
D 4
11.8%
V 3
 
8.8%
B 3
 
8.8%
R 2
 
5.9%
e 2
 
5.9%
a 2
 
5.9%
M 1
 
2.9%
i 1
 
2.9%
Y 1
 
2.9%
Other values (7) 7
20.6%
Common
ValueCountFrequency (%)
69
72.6%
2 5
 
5.3%
5 3
 
3.2%
( 3
 
3.2%
) 3
 
3.2%
~ 2
 
2.1%
1 2
 
2.1%
0 2
 
2.1%
, 2
 
2.1%
3 1
 
1.1%
Other values (3) 3
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1203
90.3%
ASCII 129
 
9.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
래 170
14.1%
노 167
13.9%
연 125
 
10.4%
습 125
 
10.4%
장 121
 
10.1%
방 46
 
3.8%
코 19
 
1.6%
인 15
 
1.2%
스 14
 
1.2%
타 14
 
1.2%
Other values (181) 387
32.2%
ASCII
ValueCountFrequency (%)
69
53.5%
S 8
 
6.2%
2 5
 
3.9%
D 4
 
3.1%
5 3
 
2.3%
V 3
 
2.3%
B 3
 
2.3%
( 3
 
2.3%
) 3
 
2.3%
R 2
 
1.6%
Other values (20) 26
 
20.2%

영업소도로명소재지
Text

Distinct171
Distinct (%)98.8%
Missing1
Missing (%)0.6%
Memory size1.5 KiB
2023-12-12T13:08:33.885837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length34
Mean length26.815029
Min length18

Characters and Unicode

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

Unique169 ?
Unique (%)97.7%

Sample

1st row서울특별시 성동구 독서당로 312 (금호동4가)
2nd row서울특별시 성동구 광나루로11길 5 (송정동)
3rd row서울특별시 성동구 무학봉28길 12 (하왕십리동)
4th row서울특별시 성동구 아차산로7길 3 (성수동2가)
5th row서울특별시 성동구 행당동 12-39
ValueCountFrequency (%)
서울특별시 173
19.3%
성동구 173
19.3%
성수동2가 36
 
4.0%
행당동 29
 
3.2%
성수동1가 22
 
2.5%
성덕정길 17
 
1.9%
용답동 13
 
1.4%
금호동4가 11
 
1.2%
아차산로 8
 
0.9%
지하1층 8
 
0.9%
Other values (224) 407
45.4%
2023-12-12T13:08:34.416443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
774
 
16.7%
동 351
 
7.6%
성 265
 
5.7%
서 180
 
3.9%
1 175
 
3.8%
시 174
 
3.8%
특 173
 
3.7%
별 173
 
3.7%
구 173
 
3.7%
울 173
 
3.7%
Other values (89) 2028
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2790
60.1%
Space Separator 774
 
16.7%
Decimal Number 645
 
13.9%
Open Punctuation 168
 
3.6%
Close Punctuation 168
 
3.6%
Other Punctuation 51
 
1.1%
Dash Punctuation 37
 
0.8%
Uppercase Letter 6
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 351
 
12.6%
성 265
 
9.5%
서 180
 
6.5%
시 174
 
6.2%
특 173
 
6.2%
별 173
 
6.2%
구 173
 
6.2%
울 173
 
6.2%
길 109
 
3.9%
로 104
 
3.7%
Other values (72) 915
32.8%
Decimal Number
ValueCountFrequency (%)
1 175
27.1%
2 134
20.8%
3 65
 
10.1%
4 61
 
9.5%
5 45
 
7.0%
7 38
 
5.9%
8 33
 
5.1%
0 33
 
5.1%
9 32
 
5.0%
6 29
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
B 5
83.3%
A 1
 
16.7%
Space Separator
ValueCountFrequency (%)
774
100.0%
Open Punctuation
ValueCountFrequency (%)
( 168
100.0%
Close Punctuation
ValueCountFrequency (%)
) 168
100.0%
Other Punctuation
ValueCountFrequency (%)
, 51
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2790
60.1%
Common 1843
39.7%
Latin 6
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 351
 
12.6%
성 265
 
9.5%
서 180
 
6.5%
시 174
 
6.2%
특 173
 
6.2%
별 173
 
6.2%
구 173
 
6.2%
울 173
 
6.2%
길 109
 
3.9%
로 104
 
3.7%
Other values (72) 915
32.8%
Common
ValueCountFrequency (%)
774
42.0%
1 175
 
9.5%
( 168
 
9.1%
) 168
 
9.1%
2 134
 
7.3%
3 65
 
3.5%
4 61
 
3.3%
, 51
 
2.8%
5 45
 
2.4%
7 38
 
2.1%
Other values (5) 164
 
8.9%
Latin
ValueCountFrequency (%)
B 5
83.3%
A 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2790
60.1%
ASCII 1849
39.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
774
41.9%
1 175
 
9.5%
( 168
 
9.1%
) 168
 
9.1%
2 134
 
7.2%
3 65
 
3.5%
4 61
 
3.3%
, 51
 
2.8%
5 45
 
2.4%
7 38
 
2.1%
Other values (7) 170
 
9.2%
Hangul
ValueCountFrequency (%)
동 351
 
12.6%
성 265
 
9.5%
서 180
 
6.5%
시 174
 
6.2%
특 173
 
6.2%
별 173
 
6.2%
구 173
 
6.2%
울 173
 
6.2%
길 109
 
3.9%
로 104
 
3.7%
Other values (72) 915
32.8%

전화번호
Text

MISSING 

Distinct57
Distinct (%)100.0%
Missing117
Missing (%)67.2%
Memory size1.5 KiB
2023-12-12T13:08:34.729612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.368421
Min length8

Characters and Unicode

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

Unique57 ?
Unique (%)100.0%

Sample

1st row02-2281-0437
2nd row02-3409-1551
3rd row02-2231-1589
4th row02-2295-9121
5th row02-2215-4833
ValueCountFrequency (%)
02-2296-5033 1
 
1.8%
469-5225 1
 
1.8%
2295-4561 1
 
1.8%
499-3488 1
 
1.8%
461-4999 1
 
1.8%
02-2252-8599 1
 
1.8%
02-469-9295 1
 
1.8%
02-2296-6509 1
 
1.8%
02-2282-2747 1
 
1.8%
02-468-4119 1
 
1.8%
Other values (47) 47
82.5%
2023-12-12T13:08:35.198264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 136
21.0%
- 109
16.8%
0 69
10.6%
9 56
8.6%
4 51
 
7.9%
8 44
 
6.8%
6 41
 
6.3%
5 40
 
6.2%
1 39
 
6.0%
7 34
 
5.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 539
83.2%
Dash Punctuation 109
 
16.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 136
25.2%
0 69
12.8%
9 56
10.4%
4 51
 
9.5%
8 44
 
8.2%
6 41
 
7.6%
5 40
 
7.4%
1 39
 
7.2%
7 34
 
6.3%
3 29
 
5.4%
Dash Punctuation
ValueCountFrequency (%)
- 109
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 648
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 136
21.0%
- 109
16.8%
0 69
10.6%
9 56
8.6%
4 51
 
7.9%
8 44
 
6.8%
6 41
 
6.3%
5 40
 
6.2%
1 39
 
6.0%
7 34
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 648
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 136
21.0%
- 109
16.8%
0 69
10.6%
9 56
8.6%
4 51
 
7.9%
8 44
 
6.8%
6 41
 
6.3%
5 40
 
6.2%
1 39
 
6.0%
7 34
 
5.2%

Missing values

2023-12-12T13:08:32.315558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:08:32.418186image/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.
2023-12-12T13:08:32.578466image/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

상호명영업소도로명소재지전화번호
01,2,3노래연습장서울특별시 성동구 독서당로 312 (금호동4가)<NA>
1기린노래방서울특별시 성동구 광나루로11길 5 (송정동)<NA>
2Sao Mai 노래연습장서울특별시 성동구 무학봉28길 12 (하왕십리동)<NA>
3세븐틴코인노래연습장(성수점)서울특별시 성동구 아차산로7길 3 (성수동2가)<NA>
4즐거운 노래방서울특별시 성동구 행당동 12-39<NA>
5뚝섬노래방서울특별시 성동구 성덕정17길 4-10 (성수동2가)<NA>
6소리꾼노래방서울특별시 성동구 행당로17길 20 (행당동)02-2281-0437
7스타노래연습장서울특별시 성동구 왕십리로4길 16, 지하층 (성수동1가)02-3409-1551
8개골개골노래방서울특별시 성동구 동호로 103 (금호동3가)02-2231-1589
9팡팡노래방서울특별시 성동구 마장로 192 (홍익동)<NA>
상호명영업소도로명소재지전화번호
164코인싱어 동전노래연습장서울특별시 성동구 마조로3길 6, B1층 (행당동)<NA>
165딴따라 코인노래연습장서울특별시 성동구 용답29길 18, 2층 (용답동)<NA>
166슈퍼스타코인노래연습장서울특별시 성동구 마조로 15-8, 지하1층 (행당동)<NA>
167도깨비코인노래연습장서울특별시 성동구 무학봉28길 6 (하왕십리동, 금용빌딩)<NA>
168혜성노래연습장서울특별시 성동구 독서당로 312-1 (금호동4가)<NA>
169올래 노래연습장서울특별시 성동구 행당로17길 23-1 (행당동)<NA>
170고래고래 코인노래연습장서울특별시 성동구 마조로5길 5, 2,3층 (행당동)<NA>
171락휴 코인노래연습장 왕십리점서울특별시 성동구 행당로17길 26, 3층 (행당동)<NA>
172도깨비코인노래연습장서울특별시 성동구 왕십리로 284, 2층 (행당동)<NA>
173<NA><NA><NA>