Overview

Dataset statistics

Number of variables4
Number of observations732
Missing cells524
Missing cells (%)17.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.0 KiB
Average record size in memory32.2 B

Variable types

Categorical1
Text3

Dataset

Description부산광역시수영구_개인카페및프랜차이즈카페현황_20221110
Author부산광역시 수영구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15094378

Alerts

업종명 has constant value ""Constant
소재지전화 has 524 (71.6%) missing valuesMissing

Reproduction

Analysis started2024-04-21 08:31:45.062464
Analysis finished2024-04-21 08:31:46.179222
Duration1.12 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
휴게음식점
732 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row휴게음식점
2nd row휴게음식점
3rd row휴게음식점
4th row휴게음식점
5th row휴게음식점

Common Values

ValueCountFrequency (%)
휴게음식점 732
100.0%

Length

2024-04-21T17:31:46.394168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T17:31:46.702790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
휴게음식점 732
100.0%
Distinct727
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
2024-04-21T17:31:47.578693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length28
Mean length9.1693989
Min length2

Characters and Unicode

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

Unique

Unique724 ?
Unique (%)98.9%

Sample

1st row바다커피숍
2nd row경진커피
3rd row미화커피숍
4th row흙커피숍
5th row성원다방
ValueCountFrequency (%)
세븐일레븐 34
 
2.9%
수영점 21
 
1.8%
씨유 17
 
1.5%
coffee 16
 
1.4%
광안점 15
 
1.3%
컴포즈커피 14
 
1.2%
gs25 13
 
1.1%
카페 11
 
0.9%
남천점 11
 
0.9%
이마트24 9
 
0.8%
Other values (853) 999
86.1%
2024-04-21T17:31:48.701782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
428
 
6.4%
305
 
4.5%
159
 
2.4%
144
 
2.1%
) 135
 
2.0%
( 135
 
2.0%
133
 
2.0%
130
 
1.9%
127
 
1.9%
126
 
1.9%
Other values (526) 4890
72.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4785
71.3%
Uppercase Letter 551
 
8.2%
Lowercase Letter 474
 
7.1%
Space Separator 428
 
6.4%
Decimal Number 181
 
2.7%
Close Punctuation 135
 
2.0%
Open Punctuation 135
 
2.0%
Other Punctuation 21
 
0.3%
Dash Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
305
 
6.4%
159
 
3.3%
144
 
3.0%
133
 
2.8%
130
 
2.7%
127
 
2.7%
126
 
2.6%
116
 
2.4%
98
 
2.0%
84
 
1.8%
Other values (459) 3363
70.3%
Uppercase Letter
ValueCountFrequency (%)
S 59
 
10.7%
E 54
 
9.8%
C 51
 
9.3%
G 48
 
8.7%
O 40
 
7.3%
A 30
 
5.4%
P 26
 
4.7%
F 25
 
4.5%
T 23
 
4.2%
B 21
 
3.8%
Other values (15) 174
31.6%
Lowercase Letter
ValueCountFrequency (%)
e 82
17.3%
o 50
10.5%
a 39
 
8.2%
f 38
 
8.0%
r 29
 
6.1%
c 25
 
5.3%
t 25
 
5.3%
i 23
 
4.9%
s 22
 
4.6%
l 20
 
4.2%
Other values (12) 121
25.5%
Decimal Number
ValueCountFrequency (%)
2 54
29.8%
5 46
25.4%
4 18
 
9.9%
1 18
 
9.9%
3 15
 
8.3%
0 12
 
6.6%
9 6
 
3.3%
6 5
 
2.8%
8 5
 
2.8%
7 2
 
1.1%
Other Punctuation
ValueCountFrequency (%)
& 8
38.1%
. 6
28.6%
' 4
19.0%
! 1
 
4.8%
· 1
 
4.8%
: 1
 
4.8%
Space Separator
ValueCountFrequency (%)
428
100.0%
Close Punctuation
ValueCountFrequency (%)
) 135
100.0%
Open Punctuation
ValueCountFrequency (%)
( 135
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4783
71.3%
Latin 1025
 
15.3%
Common 902
 
13.4%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
305
 
6.4%
159
 
3.3%
144
 
3.0%
133
 
2.8%
130
 
2.7%
127
 
2.7%
126
 
2.6%
116
 
2.4%
98
 
2.0%
84
 
1.8%
Other values (457) 3361
70.3%
Latin
ValueCountFrequency (%)
e 82
 
8.0%
S 59
 
5.8%
E 54
 
5.3%
C 51
 
5.0%
o 50
 
4.9%
G 48
 
4.7%
O 40
 
3.9%
a 39
 
3.8%
f 38
 
3.7%
A 30
 
2.9%
Other values (37) 534
52.1%
Common
ValueCountFrequency (%)
428
47.5%
) 135
 
15.0%
( 135
 
15.0%
2 54
 
6.0%
5 46
 
5.1%
4 18
 
2.0%
1 18
 
2.0%
3 15
 
1.7%
0 12
 
1.3%
& 8
 
0.9%
Other values (10) 33
 
3.7%
Han
ValueCountFrequency (%)
1
50.0%
1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4783
71.3%
ASCII 1926
28.7%
CJK 2
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
428
22.2%
) 135
 
7.0%
( 135
 
7.0%
e 82
 
4.3%
S 59
 
3.1%
E 54
 
2.8%
2 54
 
2.8%
C 51
 
2.6%
o 50
 
2.6%
G 48
 
2.5%
Other values (56) 830
43.1%
Hangul
ValueCountFrequency (%)
305
 
6.4%
159
 
3.3%
144
 
3.0%
133
 
2.8%
130
 
2.7%
127
 
2.7%
126
 
2.6%
116
 
2.4%
98
 
2.0%
84
 
1.8%
Other values (457) 3361
70.3%
CJK
ValueCountFrequency (%)
1
50.0%
1
50.0%
None
ValueCountFrequency (%)
· 1
100.0%
Distinct715
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
2024-04-21T17:31:49.605300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length54
Mean length33.804645
Min length21

Characters and Unicode

Total characters24745
Distinct characters270
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique701 ?
Unique (%)95.8%

Sample

1st row부산광역시 수영구 남천동로 103 (남천동)
2nd row부산광역시 수영구 수영로 606, 지하1층 (광안동)
3rd row부산광역시 수영구 수영로725번길 10 (수영동)
4th row부산광역시 수영구 과정로 45, 지하1층 (망미동)
5th row부산광역시 수영구 수미로14번길 51 (수영동)
ValueCountFrequency (%)
부산광역시 732
 
15.0%
수영구 732
 
15.0%
1층 502
 
10.3%
광안동 307
 
6.3%
남천동 140
 
2.9%
민락동 124
 
2.5%
망미동 99
 
2.0%
수영로 82
 
1.7%
수영동 72
 
1.5%
2층 45
 
0.9%
Other values (803) 2040
41.8%
2024-04-21T17:31:50.771927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4143
 
16.7%
1 1302
 
5.3%
1280
 
5.2%
1096
 
4.4%
1032
 
4.2%
863
 
3.5%
, 829
 
3.4%
777
 
3.1%
768
 
3.1%
751
 
3.0%
Other values (260) 11904
48.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 13948
56.4%
Space Separator 4143
 
16.7%
Decimal Number 4142
 
16.7%
Other Punctuation 836
 
3.4%
Close Punctuation 742
 
3.0%
Open Punctuation 742
 
3.0%
Dash Punctuation 98
 
0.4%
Uppercase Letter 49
 
0.2%
Math Symbol 30
 
0.1%
Lowercase Letter 14
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1280
 
9.2%
1096
 
7.9%
1032
 
7.4%
863
 
6.2%
777
 
5.6%
768
 
5.5%
751
 
5.4%
746
 
5.3%
739
 
5.3%
735
 
5.3%
Other values (218) 5161
37.0%
Uppercase Letter
ValueCountFrequency (%)
B 13
26.5%
A 6
12.2%
S 4
 
8.2%
C 4
 
8.2%
K 4
 
8.2%
D 3
 
6.1%
E 2
 
4.1%
W 2
 
4.1%
P 2
 
4.1%
G 1
 
2.0%
Other values (8) 8
16.3%
Decimal Number
ValueCountFrequency (%)
1 1302
31.4%
2 531
12.8%
0 417
 
10.1%
3 351
 
8.5%
6 317
 
7.7%
4 313
 
7.6%
5 293
 
7.1%
7 255
 
6.2%
9 192
 
4.6%
8 171
 
4.1%
Other Punctuation
ValueCountFrequency (%)
, 829
99.2%
/ 4
 
0.5%
' 2
 
0.2%
. 1
 
0.1%
Lowercase Letter
ValueCountFrequency (%)
e 11
78.6%
y 1
 
7.1%
s 1
 
7.1%
c 1
 
7.1%
Space Separator
ValueCountFrequency (%)
4143
100.0%
Close Punctuation
ValueCountFrequency (%)
) 742
100.0%
Open Punctuation
ValueCountFrequency (%)
( 742
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 98
100.0%
Math Symbol
ValueCountFrequency (%)
~ 30
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 13948
56.4%
Common 10733
43.4%
Latin 64
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1280
 
9.2%
1096
 
7.9%
1032
 
7.4%
863
 
6.2%
777
 
5.6%
768
 
5.5%
751
 
5.4%
746
 
5.3%
739
 
5.3%
735
 
5.3%
Other values (218) 5161
37.0%
Latin
ValueCountFrequency (%)
B 13
20.3%
e 11
17.2%
A 6
9.4%
S 4
 
6.2%
C 4
 
6.2%
K 4
 
6.2%
D 3
 
4.7%
E 2
 
3.1%
W 2
 
3.1%
P 2
 
3.1%
Other values (13) 13
20.3%
Common
ValueCountFrequency (%)
4143
38.6%
1 1302
 
12.1%
, 829
 
7.7%
) 742
 
6.9%
( 742
 
6.9%
2 531
 
4.9%
0 417
 
3.9%
3 351
 
3.3%
6 317
 
3.0%
4 313
 
2.9%
Other values (9) 1046
 
9.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 13948
56.4%
ASCII 10796
43.6%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4143
38.4%
1 1302
 
12.1%
, 829
 
7.7%
) 742
 
6.9%
( 742
 
6.9%
2 531
 
4.9%
0 417
 
3.9%
3 351
 
3.3%
6 317
 
2.9%
4 313
 
2.9%
Other values (31) 1109
 
10.3%
Hangul
ValueCountFrequency (%)
1280
 
9.2%
1096
 
7.9%
1032
 
7.4%
863
 
6.2%
777
 
5.6%
768
 
5.5%
751
 
5.4%
746
 
5.3%
739
 
5.3%
735
 
5.3%
Other values (218) 5161
37.0%
Number Forms
ValueCountFrequency (%)
1
100.0%

소재지전화
Text

MISSING 

Distinct203
Distinct (%)97.6%
Missing524
Missing (%)71.6%
Memory size5.8 KiB
2024-04-21T17:31:51.950746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.961538
Min length10

Characters and Unicode

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

Unique200 ?
Unique (%)96.2%

Sample

1st row 051- 625-5955
2nd row 051- 753-0342
3rd row 051-752 -0825
4th row 051-0754-6028
5th row 051- 754-3963
ValueCountFrequency (%)
051 179
31.9%
757 21
 
3.7%
755 16
 
2.9%
070 15
 
2.7%
754 13
 
2.3%
751 13
 
2.3%
752 11
 
2.0%
761 9
 
1.6%
756 7
 
1.2%
753 6
 
1.1%
Other values (240) 271
48.3%
2024-04-21T17:31:53.358908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 416
14.3%
5 401
13.8%
395
13.6%
0 372
12.8%
1 329
11.3%
7 261
9.0%
2 145
 
5.0%
6 145
 
5.0%
4 127
 
4.4%
3 114
 
3.9%
Other values (2) 199
6.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2093
72.1%
Dash Punctuation 416
 
14.3%
Space Separator 395
 
13.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 401
19.2%
0 372
17.8%
1 329
15.7%
7 261
12.5%
2 145
 
6.9%
6 145
 
6.9%
4 127
 
6.1%
3 114
 
5.4%
8 104
 
5.0%
9 95
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 416
100.0%
Space Separator
ValueCountFrequency (%)
395
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2904
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 416
14.3%
5 401
13.8%
395
13.6%
0 372
12.8%
1 329
11.3%
7 261
9.0%
2 145
 
5.0%
6 145
 
5.0%
4 127
 
4.4%
3 114
 
3.9%
Other values (2) 199
6.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2904
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 416
14.3%
5 401
13.8%
395
13.6%
0 372
12.8%
1 329
11.3%
7 261
9.0%
2 145
 
5.0%
6 145
 
5.0%
4 127
 
4.4%
3 114
 
3.9%
Other values (2) 199
6.9%

Missing values

2024-04-21T17:31:45.797343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T17:31:46.070726image/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휴게음식점바다커피숍부산광역시 수영구 남천동로 103 (남천동)051- 625-5955
1휴게음식점경진커피부산광역시 수영구 수영로 606, 지하1층 (광안동)051- 753-0342
2휴게음식점미화커피숍부산광역시 수영구 수영로725번길 10 (수영동)051-752 -0825
3휴게음식점흙커피숍부산광역시 수영구 과정로 45, 지하1층 (망미동)051-0754-6028
4휴게음식점성원다방부산광역시 수영구 수미로14번길 51 (수영동)051- 754-3963
5휴게음식점맥심부산광역시 수영구 광안해변로277번길 23 (민락동)051- 751-2873
6휴게음식점약속부산광역시 수영구 망미로8번길 96 (망미동)051-754 -1463
7휴게음식점한일부산광역시 수영구 수영로 687 (광안동)051- 755-3052
8휴게음식점누구나부산광역시 수영구 광안로7번길 34 (광안동)051-751 -6549
9휴게음식점오렌지다실부산광역시 수영구 민락본동로19번길 68, 지하 1층 (민락동)051 -755 -5877
업종명업소명소재지(도로명)소재지전화
722휴게음식점요것두부산광역시 수영구 수영로 544, 102호 (광안동)<NA>
723휴게음식점씨유 부산남천점부산광역시 수영구 수영로408번길 65, 우성보라아파트 상가동 14호 (남천동)<NA>
724휴게음식점리초야(RICHOYA)부산광역시 수영구 민락수변로17번길 56, 2층 B-5호 (민락동)<NA>
725휴게음식점더블투 디저트부산광역시 수영구 수영로 759, 알파오피스텔 101호 (수영동)<NA>
726휴게음식점솜타래부산광역시 수영구 민락수변로17번길 56, 2층 B-9호 (민락동)<NA>
727휴게음식점플레인에떼부산광역시 수영구 연수로401번길 3, 2층 일부 (수영동)<NA>
728휴게음식점세븐일레븐 부산광안에이스점부산광역시 수영구 수영로652번길 26, 1층 (광안동)<NA>
729휴게음식점과일수레부산광역시 수영구 민락수변로17번길 56, 2층 c-6호 (민락동)<NA>
730휴게음식점광안김밥부산광역시 수영구 수영로606번길 7, 1층 (광안동)<NA>
731휴게음식점스스스부산광역시 수영구 수미로42번길 1, 1층 일부 (수영동)<NA>