Overview

Dataset statistics

Number of variables5
Number of observations233
Missing cells39
Missing cells (%)3.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.2 KiB
Average record size in memory40.6 B

Variable types

Categorical1
Text4

Dataset

Description수성구 노래연습장 현황_20200918
Author대구광역시 수성구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3075542&dataSetDetailId=30755421e9736f0935f4&provdMethod=FILE

Alerts

업종 has constant value ""Constant
전화번호 has 39 (16.7%) missing valuesMissing
영업소도로명소재지 has unique valuesUnique
영업소지번소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-10 19:17:29.065568
Analysis finished2023-12-10 19:17:29.684709
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
노래연습장업
233 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row노래연습장업
2nd row노래연습장업
3rd row노래연습장업
4th row노래연습장업
5th row노래연습장업

Common Values

ValueCountFrequency (%)
노래연습장업 233
100.0%

Length

2023-12-11T04:17:29.775326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:17:29.905768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노래연습장업 233
100.0%
Distinct215
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-11T04:17:30.159856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length16
Mean length6.9356223
Min length1

Characters and Unicode

Total characters1616
Distinct characters250
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 (%)85.8%

Sample

1st row(주)포스트모던 넥서스동전노래연습장
2nd row3080노래연습장
3rd rowK-2 노래연습장
4th rowMBC노래연습장
5th rowSBS노래연습장
ValueCountFrequency (%)
노래연습장 7
 
2.9%
칼라노래연습장 3
 
1.2%
축제노래연습장 3
 
1.2%
멜론노래연습장 3
 
1.2%
라이브노래연습장 2
 
0.8%
큐노래연습장 2
 
0.8%
발리노래연습장 2
 
0.8%
톡톡 2
 
0.8%
토토노래연습장 2
 
0.8%
스타노래연습장 2
 
0.8%
Other values (209) 215
88.5%
2023-12-11T04:17:30.722580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
199
 
12.3%
198
 
12.3%
198
 
12.3%
197
 
12.2%
196
 
12.1%
26
 
1.6%
20
 
1.2%
16
 
1.0%
16
 
1.0%
13
 
0.8%
Other values (240) 537
33.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1586
98.1%
Space Separator 10
 
0.6%
Uppercase Letter 7
 
0.4%
Decimal Number 6
 
0.4%
Close Punctuation 3
 
0.2%
Open Punctuation 3
 
0.2%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
199
 
12.5%
198
 
12.5%
198
 
12.5%
197
 
12.4%
196
 
12.4%
26
 
1.6%
20
 
1.3%
16
 
1.0%
16
 
1.0%
13
 
0.8%
Other values (227) 507
32.0%
Uppercase Letter
ValueCountFrequency (%)
S 2
28.6%
B 2
28.6%
C 1
14.3%
M 1
14.3%
K 1
14.3%
Decimal Number
ValueCountFrequency (%)
0 2
33.3%
2 2
33.3%
3 1
16.7%
8 1
16.7%
Space Separator
ValueCountFrequency (%)
10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1586
98.1%
Common 23
 
1.4%
Latin 7
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
199
 
12.5%
198
 
12.5%
198
 
12.5%
197
 
12.4%
196
 
12.4%
26
 
1.6%
20
 
1.3%
16
 
1.0%
16
 
1.0%
13
 
0.8%
Other values (227) 507
32.0%
Common
ValueCountFrequency (%)
10
43.5%
) 3
 
13.0%
( 3
 
13.0%
0 2
 
8.7%
2 2
 
8.7%
- 1
 
4.3%
3 1
 
4.3%
8 1
 
4.3%
Latin
ValueCountFrequency (%)
S 2
28.6%
B 2
28.6%
C 1
14.3%
M 1
14.3%
K 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1586
98.1%
ASCII 30
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
199
 
12.5%
198
 
12.5%
198
 
12.5%
197
 
12.4%
196
 
12.4%
26
 
1.6%
20
 
1.3%
16
 
1.0%
16
 
1.0%
13
 
0.8%
Other values (227) 507
32.0%
ASCII
ValueCountFrequency (%)
10
33.3%
) 3
 
10.0%
( 3
 
10.0%
S 2
 
6.7%
B 2
 
6.7%
0 2
 
6.7%
2 2
 
6.7%
C 1
 
3.3%
M 1
 
3.3%
- 1
 
3.3%
Other values (3) 3
 
10.0%
Distinct233
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-11T04:17:31.183106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length39
Mean length25.04721
Min length20

Characters and Unicode

Total characters5836
Distinct characters91
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

Unique233 ?
Unique (%)100.0%

Sample

1st row대구광역시 수성구 화랑로 46 (만촌동)
2nd row대구광역시 수성구 달구벌대로 2398, 지하1층 (범어동)
3rd row대구광역시 수성구 들안로 59, 2층 (상동)
4th row대구광역시 수성구 지범로23길 47-1 (지산동)
5th row대구광역시 수성구 신매로19길 38 (신매동)
ValueCountFrequency (%)
대구광역시 233
19.5%
수성구 233
19.5%
지산동 42
 
3.5%
범어동 36
 
3.0%
들안로 34
 
2.8%
두산동 30
 
2.5%
만촌동 23
 
1.9%
황금동 17
 
1.4%
신매동 14
 
1.2%
달구벌대로 14
 
1.2%
Other values (271) 518
43.4%
2023-12-11T04:17:31.814235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
961
16.5%
514
 
8.8%
283
 
4.8%
281
 
4.8%
275
 
4.7%
259
 
4.4%
244
 
4.2%
233
 
4.0%
233
 
4.0%
233
 
4.0%
Other values (81) 2320
39.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3528
60.5%
Space Separator 961
 
16.5%
Decimal Number 823
 
14.1%
Open Punctuation 233
 
4.0%
Close Punctuation 233
 
4.0%
Dash Punctuation 35
 
0.6%
Other Punctuation 23
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
514
14.6%
283
 
8.0%
281
 
8.0%
275
 
7.8%
259
 
7.3%
244
 
6.9%
233
 
6.6%
233
 
6.6%
233
 
6.6%
93
 
2.6%
Other values (66) 880
24.9%
Decimal Number
ValueCountFrequency (%)
1 169
20.5%
2 130
15.8%
3 115
14.0%
4 81
9.8%
9 70
8.5%
6 65
 
7.9%
5 63
 
7.7%
8 49
 
6.0%
0 41
 
5.0%
7 40
 
4.9%
Space Separator
ValueCountFrequency (%)
961
100.0%
Open Punctuation
ValueCountFrequency (%)
( 233
100.0%
Close Punctuation
ValueCountFrequency (%)
) 233
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 35
100.0%
Other Punctuation
ValueCountFrequency (%)
, 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3528
60.5%
Common 2308
39.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
514
14.6%
283
 
8.0%
281
 
8.0%
275
 
7.8%
259
 
7.3%
244
 
6.9%
233
 
6.6%
233
 
6.6%
233
 
6.6%
93
 
2.6%
Other values (66) 880
24.9%
Common
ValueCountFrequency (%)
961
41.6%
( 233
 
10.1%
) 233
 
10.1%
1 169
 
7.3%
2 130
 
5.6%
3 115
 
5.0%
4 81
 
3.5%
9 70
 
3.0%
6 65
 
2.8%
5 63
 
2.7%
Other values (5) 188
 
8.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3528
60.5%
ASCII 2308
39.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
961
41.6%
( 233
 
10.1%
) 233
 
10.1%
1 169
 
7.3%
2 130
 
5.6%
3 115
 
5.0%
4 81
 
3.5%
9 70
 
3.0%
6 65
 
2.8%
5 63
 
2.7%
Other values (5) 188
 
8.1%
Hangul
ValueCountFrequency (%)
514
14.6%
283
 
8.0%
281
 
8.0%
275
 
7.8%
259
 
7.3%
244
 
6.9%
233
 
6.6%
233
 
6.6%
233
 
6.6%
93
 
2.6%
Other values (66) 880
24.9%
Distinct233
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-11T04:17:32.264617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length33
Mean length21.034335
Min length16

Characters and Unicode

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

Unique

Unique233 ?
Unique (%)100.0%

Sample

1st row대구광역시 수성구 만촌동 1356-22
2nd row대구광역시 수성구 범어동 561-4
3rd row대구광역시 수성구 상동 70-12 외1필지(70-8)
4th row대구광역시 수성구 지산동 1285-5
5th row대구광역시 수성구 신매동 567-36
ValueCountFrequency (%)
대구광역시 233
24.4%
수성구 233
24.4%
지산동 42
 
4.4%
범어동 36
 
3.8%
두산동 30
 
3.1%
만촌동 23
 
2.4%
황금동 17
 
1.8%
신매동 14
 
1.5%
수성동4가 12
 
1.3%
상동 11
 
1.2%
Other values (264) 304
31.8%
2023-12-11T04:17:33.359387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
954
19.5%
468
 
9.5%
262
 
5.3%
261
 
5.3%
241
 
4.9%
238
 
4.9%
234
 
4.8%
234
 
4.8%
234
 
4.8%
1 226
 
4.6%
Other values (72) 1549
31.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2672
54.5%
Decimal Number 1071
21.9%
Space Separator 954
 
19.5%
Dash Punctuation 202
 
4.1%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
468
17.5%
262
9.8%
261
9.8%
241
9.0%
238
8.9%
234
8.8%
234
8.8%
234
8.8%
72
 
2.7%
52
 
1.9%
Other values (58) 376
14.1%
Decimal Number
ValueCountFrequency (%)
1 226
21.1%
2 154
14.4%
5 97
9.1%
4 95
8.9%
3 94
8.8%
8 90
 
8.4%
7 89
 
8.3%
6 81
 
7.6%
0 80
 
7.5%
9 65
 
6.1%
Space Separator
ValueCountFrequency (%)
954
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 202
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2672
54.5%
Common 2229
45.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
468
17.5%
262
9.8%
261
9.8%
241
9.0%
238
8.9%
234
8.8%
234
8.8%
234
8.8%
72
 
2.7%
52
 
1.9%
Other values (58) 376
14.1%
Common
ValueCountFrequency (%)
954
42.8%
1 226
 
10.1%
- 202
 
9.1%
2 154
 
6.9%
5 97
 
4.4%
4 95
 
4.3%
3 94
 
4.2%
8 90
 
4.0%
7 89
 
4.0%
6 81
 
3.6%
Other values (4) 147
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2672
54.5%
ASCII 2229
45.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
954
42.8%
1 226
 
10.1%
- 202
 
9.1%
2 154
 
6.9%
5 97
 
4.4%
4 95
 
4.3%
3 94
 
4.2%
8 90
 
4.0%
7 89
 
4.0%
6 81
 
3.6%
Other values (4) 147
 
6.6%
Hangul
ValueCountFrequency (%)
468
17.5%
262
9.8%
261
9.8%
241
9.0%
238
8.9%
234
8.8%
234
8.8%
234
8.8%
72
 
2.7%
52
 
1.9%
Other values (58) 376
14.1%

전화번호
Text

MISSING 

Distinct193
Distinct (%)99.5%
Missing39
Missing (%)16.7%
Memory size1.9 KiB
2023-12-11T04:17:33.695867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique192 ?
Unique (%)99.0%

Sample

1st row053-746-6250
2nd row053-751-0521
3rd row053-782-6151
4th row053-793-6020
5th row053-765-4539
ValueCountFrequency (%)
053-764-6500 2
 
1.0%
053-766-7464 1
 
0.5%
053-767-2218 1
 
0.5%
053-746-6250 1
 
0.5%
053-754-2905 1
 
0.5%
053-781-2175 1
 
0.5%
053-762-0038 1
 
0.5%
053-794-1004 1
 
0.5%
053-784-5888 1
 
0.5%
053-781-1808 1
 
0.5%
Other values (183) 183
94.3%
2023-12-11T04:17:34.237414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 388
16.7%
5 312
13.4%
3 302
13.0%
0 293
12.6%
7 270
11.6%
6 168
7.2%
4 143
 
6.1%
8 126
 
5.4%
1 123
 
5.3%
2 108
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1940
83.3%
Dash Punctuation 388
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 312
16.1%
3 302
15.6%
0 293
15.1%
7 270
13.9%
6 168
8.7%
4 143
7.4%
8 126
6.5%
1 123
 
6.3%
2 108
 
5.6%
9 95
 
4.9%
Dash Punctuation
ValueCountFrequency (%)
- 388
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2328
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 388
16.7%
5 312
13.4%
3 302
13.0%
0 293
12.6%
7 270
11.6%
6 168
7.2%
4 143
 
6.1%
8 126
 
5.4%
1 123
 
5.3%
2 108
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2328
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 388
16.7%
5 312
13.4%
3 302
13.0%
0 293
12.6%
7 270
11.6%
6 168
7.2%
4 143
 
6.1%
8 126
 
5.4%
1 123
 
5.3%
2 108
 
4.6%

Missing values

2023-12-11T04:17:29.454782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T04:17:29.627202image/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노래연습장업(주)포스트모던 넥서스동전노래연습장대구광역시 수성구 화랑로 46 (만촌동)대구광역시 수성구 만촌동 1356-22053-746-6250
1노래연습장업3080노래연습장대구광역시 수성구 달구벌대로 2398, 지하1층 (범어동)대구광역시 수성구 범어동 561-4053-751-0521
2노래연습장업K-2 노래연습장대구광역시 수성구 들안로 59, 2층 (상동)대구광역시 수성구 상동 70-12 외1필지(70-8)<NA>
3노래연습장업MBC노래연습장대구광역시 수성구 지범로23길 47-1 (지산동)대구광역시 수성구 지산동 1285-5053-782-6151
4노래연습장업SBS노래연습장대구광역시 수성구 신매로19길 38 (신매동)대구광역시 수성구 신매동 567-36053-793-6020
5노래연습장업가빈노래연습장대구광역시 수성구 동대구로3길 13 (두산동)대구광역시 수성구 두산동 202-11053-765-4539
6노래연습장업가요무대대구광역시 수성구 범안로3안길 25-12 (범물동)대구광역시 수성구 범물동 1346-7053-782-7072
7노래연습장업강변노래연습장대구광역시 수성구 수성로 424 (수성동4가)대구광역시 수성구 수성동4가 1114-1053-752-5147
8노래연습장업강산노래연습장대구광역시 수성구 청수로 190 (지산동)대구광역시 수성구 지산동 915053-762-2648
9노래연습장업고래고래노래연습장대구광역시 수성구 수성로 285 (수성동1가)대구광역시 수성구 수성동1가 423-3053-761-9909
업종업소명영업소도로명소재지영업소지번소재지전화번호
223노래연습장업호박노래연습장대구광역시 수성구 달구벌대로526길 12 (만촌동)대구광역시 수성구 만촌동 849-30<NA>
224노래연습장업호반노래연습장대구광역시 수성구 용학로46길 9 (지산동)대구광역시 수성구 지산동 1205-11<NA>
225노래연습장업화이트노래연습장대구광역시 수성구 지산로 63 (지산동)대구광역시 수성구 지산동 1268-20<NA>
226노래연습장업황금대구광역시 수성구 청솔로 35-1 (황금동)대구광역시 수성구 황금동 728-3053-762-4227
227노래연습장업황실대구광역시 수성구 청솔로 136, 지하1층 (범어동)대구광역시 수성구 범어동 804-42053-744-3667
228노래연습장업황실대구광역시 수성구 신천동로88길 69 (수성동4가)대구광역시 수성구 수성동4가 1186-13053-983-6918
229노래연습장업황제노래연습장대구광역시 수성구 희망로 195 (황금동)대구광역시 수성구 황금동 760-18053-761-2461
230노래연습장업황제노래연습장대구광역시 수성구 수성로 316-1 (수성동2가)대구광역시 수성구 수성동2가 268-3053-764-1854
231노래연습장업황진이노래연습장대구광역시 수성구 동대구로 367-1 (범어동)대구광역시 수성구 범어동 13-12<NA>
232노래연습장업힐링노래연습장대구광역시 수성구 동대구로7길 30 (두산동)대구광역시 수성구 두산동 129-1053-761-3800