Overview

Dataset statistics

Number of variables4
Number of observations588
Missing cells0
Missing cells (%)0.0%
Duplicate rows2
Duplicate rows (%)0.3%
Total size in memory18.5 KiB
Average record size in memory32.2 B

Variable types

Text4

Dataset

Description대구광역시 서구_카페현황_20240201
Author대구광역시 서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15092718&dataSetDetailId=1509271819d4255fea609&provdMethod=FILE

Alerts

Dataset has 2 (0.3%) duplicate rowsDuplicates

Reproduction

Analysis started2024-04-21 19:59:45.251669
Analysis finished2024-04-21 19:59:46.383539
Duration1.13 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct572
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
2024-04-22T04:59:47.081383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length20
Mean length7.5340136
Min length2

Characters and Unicode

Total characters4430
Distinct characters462
Distinct categories9 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique562 ?
Unique (%)95.6%

Sample

1st row광명다방
2nd row고전다방
3rd row원대휴랜드
4th row수정다방
5th row명성다방
ValueCountFrequency (%)
세븐일레븐 14
 
1.9%
씨유 10
 
1.4%
비산점 6
 
0.8%
트레이더스 5
 
0.7%
클럽 5
 
0.7%
홀세일 5
 
0.7%
gs25 5
 
0.7%
카페 5
 
0.7%
김밥천국 4
 
0.6%
대구중리점 3
 
0.4%
Other values (622) 662
91.4%
2024-04-22T04:59:48.408466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
215
 
4.9%
138
 
3.1%
136
 
3.1%
132
 
3.0%
118
 
2.7%
106
 
2.4%
105
 
2.4%
103
 
2.3%
102
 
2.3%
100
 
2.3%
Other values (452) 3175
71.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3696
83.4%
Uppercase Letter 231
 
5.2%
Space Separator 136
 
3.1%
Lowercase Letter 125
 
2.8%
Decimal Number 98
 
2.2%
Close Punctuation 65
 
1.5%
Open Punctuation 65
 
1.5%
Other Punctuation 13
 
0.3%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
215
 
5.8%
138
 
3.7%
132
 
3.6%
118
 
3.2%
106
 
2.9%
105
 
2.8%
103
 
2.8%
102
 
2.8%
100
 
2.7%
70
 
1.9%
Other values (390) 2507
67.8%
Uppercase Letter
ValueCountFrequency (%)
S 36
15.6%
C 32
13.9%
G 32
13.9%
P 16
 
6.9%
E 14
 
6.1%
O 14
 
6.1%
U 11
 
4.8%
T 11
 
4.8%
R 8
 
3.5%
F 8
 
3.5%
Other values (14) 49
21.2%
Lowercase Letter
ValueCountFrequency (%)
e 19
15.2%
o 13
10.4%
f 13
10.4%
a 11
8.8%
n 10
8.0%
c 10
8.0%
g 9
7.2%
i 9
7.2%
u 6
 
4.8%
s 5
 
4.0%
Other values (10) 20
16.0%
Decimal Number
ValueCountFrequency (%)
2 42
42.9%
5 38
38.8%
4 8
 
8.2%
9 4
 
4.1%
1 3
 
3.1%
3 1
 
1.0%
7 1
 
1.0%
0 1
 
1.0%
Other Punctuation
ValueCountFrequency (%)
& 5
38.5%
, 2
 
15.4%
' 2
 
15.4%
. 2
 
15.4%
# 1
 
7.7%
? 1
 
7.7%
Space Separator
ValueCountFrequency (%)
136
100.0%
Close Punctuation
ValueCountFrequency (%)
) 65
100.0%
Open Punctuation
ValueCountFrequency (%)
( 65
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3695
83.4%
Common 378
 
8.5%
Latin 356
 
8.0%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
215
 
5.8%
138
 
3.7%
132
 
3.6%
118
 
3.2%
106
 
2.9%
105
 
2.8%
103
 
2.8%
102
 
2.8%
100
 
2.7%
70
 
1.9%
Other values (389) 2506
67.8%
Latin
ValueCountFrequency (%)
S 36
 
10.1%
C 32
 
9.0%
G 32
 
9.0%
e 19
 
5.3%
P 16
 
4.5%
E 14
 
3.9%
O 14
 
3.9%
o 13
 
3.7%
f 13
 
3.7%
U 11
 
3.1%
Other values (34) 156
43.8%
Common
ValueCountFrequency (%)
136
36.0%
) 65
17.2%
( 65
17.2%
2 42
 
11.1%
5 38
 
10.1%
4 8
 
2.1%
& 5
 
1.3%
9 4
 
1.1%
1 3
 
0.8%
, 2
 
0.5%
Other values (8) 10
 
2.6%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3695
83.4%
ASCII 734
 
16.6%
CJK 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
215
 
5.8%
138
 
3.7%
132
 
3.6%
118
 
3.2%
106
 
2.9%
105
 
2.8%
103
 
2.8%
102
 
2.8%
100
 
2.7%
70
 
1.9%
Other values (389) 2506
67.8%
ASCII
ValueCountFrequency (%)
136
18.5%
) 65
 
8.9%
( 65
 
8.9%
2 42
 
5.7%
5 38
 
5.2%
S 36
 
4.9%
C 32
 
4.4%
G 32
 
4.4%
e 19
 
2.6%
P 16
 
2.2%
Other values (52) 253
34.5%
CJK
ValueCountFrequency (%)
1
100.0%
Distinct573
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
2024-04-22T04:59:49.479388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length49
Mean length28.790816
Min length9

Characters and Unicode

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

Unique

Unique562 ?
Unique (%)95.6%

Sample

1st row대구광역시 서구 문화로 211 (평리동)
2nd row대구광역시 서구 국채보상로 190-1 (중리동)
3rd row대구광역시 서구 달서로 253 (비산동,3층)
4th row대구광역시 서구 서대구로 193 (평리동)
5th row대구광역시 서구 달구벌대로373길 1 (내당동)
ValueCountFrequency (%)
대구광역시 587
16.7%
서구 587
16.7%
1층 296
 
8.4%
비산동 197
 
5.6%
평리동 172
 
4.9%
내당동 122
 
3.5%
국채보상로 53
 
1.5%
서대구로 52
 
1.5%
중리동 51
 
1.5%
서대구로62길 43
 
1.2%
Other values (575) 1349
38.4%
2024-04-22T04:59:50.983376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2921
17.3%
1390
 
8.2%
828
 
4.9%
812
 
4.8%
1 789
 
4.7%
638
 
3.8%
597
 
3.5%
590
 
3.5%
( 587
 
3.5%
) 587
 
3.5%
Other values (151) 7190
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9444
55.8%
Space Separator 2921
 
17.3%
Decimal Number 2822
 
16.7%
Open Punctuation 587
 
3.5%
Close Punctuation 587
 
3.5%
Other Punctuation 447
 
2.6%
Dash Punctuation 92
 
0.5%
Uppercase Letter 23
 
0.1%
Math Symbol 4
 
< 0.1%
Lowercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1390
14.7%
828
 
8.8%
812
 
8.6%
638
 
6.8%
597
 
6.3%
590
 
6.2%
587
 
6.2%
586
 
6.2%
357
 
3.8%
290
 
3.1%
Other values (120) 2769
29.3%
Uppercase Letter
ValueCountFrequency (%)
B 5
21.7%
E 4
17.4%
A 3
13.0%
K 2
 
8.7%
T 2
 
8.7%
X 2
 
8.7%
D 1
 
4.3%
P 1
 
4.3%
R 1
 
4.3%
C 1
 
4.3%
Decimal Number
ValueCountFrequency (%)
1 789
28.0%
2 409
14.5%
3 351
12.4%
6 232
 
8.2%
4 219
 
7.8%
5 200
 
7.1%
0 188
 
6.7%
7 188
 
6.7%
9 128
 
4.5%
8 118
 
4.2%
Math Symbol
ValueCountFrequency (%)
~ 2
50.0%
< 1
25.0%
> 1
25.0%
Lowercase Letter
ValueCountFrequency (%)
a 1
50.0%
e 1
50.0%
Space Separator
ValueCountFrequency (%)
2921
100.0%
Open Punctuation
ValueCountFrequency (%)
( 587
100.0%
Close Punctuation
ValueCountFrequency (%)
) 587
100.0%
Other Punctuation
ValueCountFrequency (%)
, 447
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 92
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9444
55.8%
Common 7460
44.1%
Latin 25
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1390
14.7%
828
 
8.8%
812
 
8.6%
638
 
6.8%
597
 
6.3%
590
 
6.2%
587
 
6.2%
586
 
6.2%
357
 
3.8%
290
 
3.1%
Other values (120) 2769
29.3%
Common
ValueCountFrequency (%)
2921
39.2%
1 789
 
10.6%
( 587
 
7.9%
) 587
 
7.9%
, 447
 
6.0%
2 409
 
5.5%
3 351
 
4.7%
6 232
 
3.1%
4 219
 
2.9%
5 200
 
2.7%
Other values (8) 718
 
9.6%
Latin
ValueCountFrequency (%)
B 5
20.0%
E 4
16.0%
A 3
12.0%
K 2
 
8.0%
T 2
 
8.0%
X 2
 
8.0%
D 1
 
4.0%
P 1
 
4.0%
R 1
 
4.0%
a 1
 
4.0%
Other values (3) 3
12.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9444
55.8%
ASCII 7485
44.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2921
39.0%
1 789
 
10.5%
( 587
 
7.8%
) 587
 
7.8%
, 447
 
6.0%
2 409
 
5.5%
3 351
 
4.7%
6 232
 
3.1%
4 219
 
2.9%
5 200
 
2.7%
Other values (21) 743
 
9.9%
Hangul
ValueCountFrequency (%)
1390
14.7%
828
 
8.8%
812
 
8.6%
638
 
6.8%
597
 
6.3%
590
 
6.2%
587
 
6.2%
586
 
6.2%
357
 
3.8%
290
 
3.1%
Other values (120) 2769
29.3%
Distinct519
Distinct (%)88.3%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
2024-04-22T04:59:52.306905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length35
Mean length20.993197
Min length16

Characters and Unicode

Total characters12344
Distinct characters123
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

Unique473 ?
Unique (%)80.4%

Sample

1st row대구광역시 서구 평리동 723-7
2nd row대구광역시 서구 중리동 37-9
3rd row대구광역시 서구 비산동 1192-33 3층
4th row대구광역시 서구 평리동 1491-13
5th row대구광역시 서구 내당동 75-1
ValueCountFrequency (%)
대구광역시 588
23.7%
서구 588
23.7%
비산동 199
 
8.0%
평리동 174
 
7.0%
내당동 126
 
5.1%
중리동 52
 
2.1%
원대동3가 19
 
0.8%
1층 15
 
0.6%
1290 8
 
0.3%
1676 8
 
0.3%
Other values (564) 707
28.5%
2024-04-22T04:59:53.879390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2465
20.0%
1202
 
9.7%
1 747
 
6.1%
637
 
5.2%
613
 
5.0%
600
 
4.9%
598
 
4.8%
591
 
4.8%
589
 
4.8%
- 538
 
4.4%
Other values (113) 3764
30.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6391
51.8%
Decimal Number 2925
23.7%
Space Separator 2465
 
20.0%
Dash Punctuation 538
 
4.4%
Other Punctuation 14
 
0.1%
Uppercase Letter 8
 
0.1%
Lowercase Letter 2
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1202
18.8%
637
10.0%
613
9.6%
600
9.4%
598
9.4%
591
9.2%
589
9.2%
246
 
3.8%
201
 
3.1%
200
 
3.1%
Other values (93) 914
14.3%
Decimal Number
ValueCountFrequency (%)
1 747
25.5%
2 369
12.6%
3 304
10.4%
6 273
 
9.3%
4 260
 
8.9%
0 229
 
7.8%
5 212
 
7.2%
8 195
 
6.7%
9 175
 
6.0%
7 161
 
5.5%
Uppercase Letter
ValueCountFrequency (%)
E 2
25.0%
K 2
25.0%
X 2
25.0%
T 2
25.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
50.0%
a 1
50.0%
Space Separator
ValueCountFrequency (%)
2465
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 538
100.0%
Other Punctuation
ValueCountFrequency (%)
, 14
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6391
51.8%
Common 5943
48.1%
Latin 10
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1202
18.8%
637
10.0%
613
9.6%
600
9.4%
598
9.4%
591
9.2%
589
9.2%
246
 
3.8%
201
 
3.1%
200
 
3.1%
Other values (93) 914
14.3%
Common
ValueCountFrequency (%)
2465
41.5%
1 747
 
12.6%
- 538
 
9.1%
2 369
 
6.2%
3 304
 
5.1%
6 273
 
4.6%
4 260
 
4.4%
0 229
 
3.9%
5 212
 
3.6%
8 195
 
3.3%
Other values (4) 351
 
5.9%
Latin
ValueCountFrequency (%)
E 2
20.0%
K 2
20.0%
X 2
20.0%
T 2
20.0%
e 1
10.0%
a 1
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6391
51.8%
ASCII 5953
48.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2465
41.4%
1 747
 
12.5%
- 538
 
9.0%
2 369
 
6.2%
3 304
 
5.1%
6 273
 
4.6%
4 260
 
4.4%
0 229
 
3.8%
5 212
 
3.6%
8 195
 
3.3%
Other values (10) 361
 
6.1%
Hangul
ValueCountFrequency (%)
1202
18.8%
637
10.0%
613
9.6%
600
9.4%
598
9.4%
591
9.2%
589
9.2%
246
 
3.8%
201
 
3.1%
200
 
3.1%
Other values (93) 914
14.3%
Distinct145
Distinct (%)24.7%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
2024-04-22T04:59:54.869903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length4.9727891
Min length1

Characters and Unicode

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

Unique39 ?
Unique (%)6.6%

Sample

1st row41773
2nd row41833
3rd row41717
4th row41765
5th row41871
ValueCountFrequency (%)
41856 24
 
4.1%
41713 23
 
3.9%
41724 14
 
2.4%
41847 14
 
2.4%
41714 13
 
2.2%
41855 13
 
2.2%
41863 12
 
2.1%
41843 12
 
2.1%
41723 12
 
2.1%
41722 11
 
1.9%
Other values (134) 436
74.7%
2024-04-22T04:59:56.125424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 742
25.4%
1 728
24.9%
7 435
14.9%
8 324
11.1%
3 152
 
5.2%
2 142
 
4.9%
5 137
 
4.7%
6 112
 
3.8%
0 79
 
2.7%
9 69
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2920
99.9%
Space Separator 4
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 742
25.4%
1 728
24.9%
7 435
14.9%
8 324
11.1%
3 152
 
5.2%
2 142
 
4.9%
5 137
 
4.7%
6 112
 
3.8%
0 79
 
2.7%
9 69
 
2.4%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2924
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 742
25.4%
1 728
24.9%
7 435
14.9%
8 324
11.1%
3 152
 
5.2%
2 142
 
4.9%
5 137
 
4.7%
6 112
 
3.8%
0 79
 
2.7%
9 69
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2924
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 742
25.4%
1 728
24.9%
7 435
14.9%
8 324
11.1%
3 152
 
5.2%
2 142
 
4.9%
5 137
 
4.7%
6 112
 
3.8%
0 79
 
2.7%
9 69
 
2.4%

Missing values

2024-04-22T04:59:46.269497image/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광명다방대구광역시 서구 문화로 211 (평리동)대구광역시 서구 평리동 723-741773
1고전다방대구광역시 서구 국채보상로 190-1 (중리동)대구광역시 서구 중리동 37-941833
2원대휴랜드대구광역시 서구 달서로 253 (비산동,3층)대구광역시 서구 비산동 1192-33 3층41717
3수정다방대구광역시 서구 서대구로 193 (평리동)대구광역시 서구 평리동 1491-1341765
4명성다방대구광역시 서구 달구벌대로373길 1 (내당동)대구광역시 서구 내당동 75-141871
5홍다방대구광역시 서구 달서로 252 (원대동1가)대구광역시 서구 원대동1가 14041731
6평화다방대구광역시 서구 서대구로 303-30, 2층 (비산동)대구광역시 서구 비산동 1856-1141711
7신성다방대구광역시 서구 달구벌대로361길 7 (내당동)대구광역시 서구 내당동 218-2241866
8동원다방대구광역시 서구 문화로 273-1, 지하1층 (평리동)대구광역시 서구 평리동 870-4 지하141772
9호다방대구광역시 서구 서대구로 303-10 (비산동)대구광역시 서구 비산동 1840-141711
업소명소재지(도로명)소재지(지번)우편번호(도로명)
578GS25서대구서한퍼스트점대구광역시 서구 국채보상로37길 38, 지하 1층 1단지 10호 (평리동, 서대구역서한이다음더퍼스트)대구광역시 서구 평리동 1497-44 서대구역서한이다음더퍼스트41765
579뮤리엘커피 대구점대구광역시 서구 당산로47길 21, 1층 (내당동)대구광역시 서구 내당동 426-1641847
580세븐일레븐 서대구센트럴자이점대구광역시 서구 고성로 33, 405동 1층 6호 (원대동3가, 서대구센트럴자이)대구광역시 서구 원대동3가 1401 서대구센트럴자이41716
581세븐일레븐대구의료원점 죽집대구광역시 서구 평리로 157, 대구의료원 1층 (중리동)대구광역시 서구 중리동 1162 대구의료원41845
582카고커피대구광역시 서구 국채보상로 360, 1층 (비산동)대구광역시 서구 비산동 333-641815
583파스쿠찌 서대구센트럴자이점대구광역시 서구 고성로 33, 405동 1층 13,14호 (원대동3가, 서대구센트럴자이)대구광역시 서구 원대동3가 1401 서대구센트럴자이41716
584신비커피숍대구광역시 서구 국채보상로46길 22, 지하 1층 (평리동)대구광역시 서구 평리동 1368-441824
585세담찹쌀꽈배기 내당점대구광역시 서구 서대구로8길 49, 상가 다동 1층 102호 (내당동, 내당보성홍실아파트)대구광역시 서구 내당동 28-1 내당보성홍실아파트41862
586호두랑붕대구광역시 서구 국채보상로45길 27, 1층 (평리동)대구광역시 서구 평리동 1085-341776
587카페봄봄 삼익뉴타운점대구광역시 서구 평리로 245, 1층 (중리동)대구광역시 서구 중리동 116-741838

Duplicate rows

Most frequently occurring

업소명소재지(도로명)소재지(지번)우편번호(도로명)# duplicates
0트레이더스 홀세일 클럽 비산점대구광역시 서구 팔달로 54 (비산동)대구광역시 서구 비산동 1610-3417105
1홈플러스(주)내당점대구광역시 서구 달구벌대로 1821 (내당동)대구광역시 서구 내당동 65-8418632