Overview

Dataset statistics

Number of variables5
Number of observations83
Missing cells40
Missing cells (%)9.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.4 KiB
Average record size in memory41.6 B

Variable types

Categorical1
Text4

Dataset

Description부산광역시 북구 관내에 존재하는 제과점업 현황 데이터로 업소명, 소재지(도로명),전화번호 등의 항목을 제공합니다
Author부산광역시 북구
URLhttps://www.data.go.kr/data/15033840/fileData.do

Alerts

업종명 has constant value ""Constant
소재지전화 has 40 (48.2%) missing valuesMissing
소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:29:20.291687
Analysis finished2023-12-12 07:29:21.108592
Duration0.82 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size796.0 B
제과점영업
83 

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 (%)
제과점영업 83
100.0%

Length

2023-12-12T16:29:21.206655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:29:21.306487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제과점영업 83
100.0%
Distinct79
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Memory size796.0 B
2023-12-12T16:29:21.483176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length12
Mean length7.7228916
Min length3

Characters and Unicode

Total characters641
Distinct characters172
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

Unique75 ?
Unique (%)90.4%

Sample

1st row빵굽는마을
2nd row규문당과자점
3rd row드레곤베이커리
4th row하베스트베이커리
5th row베이글스
ValueCountFrequency (%)
파리바게트 3
 
3.1%
파리바게뜨(만덕삼성점 2
 
2.0%
파티쉐 2
 
2.0%
안동현 2
 
2.0%
탑스베이커리 2
 
2.0%
뚜레쥬르 2
 
2.0%
구운(gu:un 1
 
1.0%
어리틀베이크샵(a 1
 
1.0%
드래곤과자점(덕천점 1
 
1.0%
부산화명점 1
 
1.0%
Other values (81) 81
82.7%
2023-12-12T16:29:21.837479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
40
 
6.2%
40
 
6.2%
27
 
4.2%
22
 
3.4%
20
 
3.1%
17
 
2.7%
16
 
2.5%
15
 
2.3%
15
 
2.3%
15
 
2.3%
Other values (162) 414
64.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 562
87.7%
Lowercase Letter 27
 
4.2%
Space Separator 15
 
2.3%
Open Punctuation 13
 
2.0%
Close Punctuation 13
 
2.0%
Uppercase Letter 9
 
1.4%
Other Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
40
 
7.1%
40
 
7.1%
27
 
4.8%
22
 
3.9%
20
 
3.6%
17
 
3.0%
16
 
2.8%
15
 
2.7%
15
 
2.7%
12
 
2.1%
Other values (134) 338
60.1%
Lowercase Letter
ValueCountFrequency (%)
e 5
18.5%
a 3
11.1%
u 2
 
7.4%
t 2
 
7.4%
b 2
 
7.4%
r 2
 
7.4%
h 2
 
7.4%
g 1
 
3.7%
n 1
 
3.7%
p 1
 
3.7%
Other values (6) 6
22.2%
Uppercase Letter
ValueCountFrequency (%)
N 2
22.2%
L 2
22.2%
I 1
11.1%
A 1
11.1%
P 1
11.1%
C 1
11.1%
O 1
11.1%
Other Punctuation
ValueCountFrequency (%)
: 1
50.0%
& 1
50.0%
Space Separator
ValueCountFrequency (%)
15
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 562
87.7%
Common 43
 
6.7%
Latin 36
 
5.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
40
 
7.1%
40
 
7.1%
27
 
4.8%
22
 
3.9%
20
 
3.6%
17
 
3.0%
16
 
2.8%
15
 
2.7%
15
 
2.7%
12
 
2.1%
Other values (134) 338
60.1%
Latin
ValueCountFrequency (%)
e 5
 
13.9%
a 3
 
8.3%
u 2
 
5.6%
t 2
 
5.6%
N 2
 
5.6%
b 2
 
5.6%
r 2
 
5.6%
h 2
 
5.6%
L 2
 
5.6%
g 1
 
2.8%
Other values (13) 13
36.1%
Common
ValueCountFrequency (%)
15
34.9%
( 13
30.2%
) 13
30.2%
: 1
 
2.3%
& 1
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 562
87.7%
ASCII 79
 
12.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
40
 
7.1%
40
 
7.1%
27
 
4.8%
22
 
3.9%
20
 
3.6%
17
 
3.0%
16
 
2.8%
15
 
2.7%
15
 
2.7%
12
 
2.1%
Other values (134) 338
60.1%
ASCII
ValueCountFrequency (%)
15
19.0%
( 13
16.5%
) 13
16.5%
e 5
 
6.3%
a 3
 
3.8%
u 2
 
2.5%
t 2
 
2.5%
N 2
 
2.5%
b 2
 
2.5%
r 2
 
2.5%
Other values (18) 20
25.3%
Distinct83
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size796.0 B
2023-12-12T16:29:22.095368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length43
Mean length31.698795
Min length21

Characters and Unicode

Total characters2631
Distinct characters139
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

Unique83 ?
Unique (%)100.0%

Sample

1st row부산광역시 북구 팽나무로 2 (구포동)
2nd row부산광역시 북구 덕천로 306, 가동 (만덕동, 1층102호,지하)
3rd row부산광역시 북구 만덕대로 88 (덕천동)
4th row부산광역시 북구 효열로 136 (금곡동)
5th row부산광역시 북구 효열로 76-1, 103호 (금곡동, 주공아파트4단지상가)
ValueCountFrequency (%)
부산광역시 83
 
15.6%
북구 83
 
15.6%
화명동 33
 
6.2%
1층 31
 
5.8%
덕천동 16
 
3.0%
구포동 14
 
2.6%
금곡대로 13
 
2.4%
만덕동 12
 
2.3%
상가동 7
 
1.3%
화명대로 6
 
1.1%
Other values (164) 233
43.9%
2023-12-12T16:29:22.524982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
448
 
17.0%
1 137
 
5.2%
104
 
4.0%
103
 
3.9%
96
 
3.6%
91
 
3.5%
87
 
3.3%
( 84
 
3.2%
, 84
 
3.2%
) 84
 
3.2%
Other values (129) 1313
49.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1515
57.6%
Space Separator 448
 
17.0%
Decimal Number 406
 
15.4%
Open Punctuation 84
 
3.2%
Other Punctuation 84
 
3.2%
Close Punctuation 84
 
3.2%
Dash Punctuation 7
 
0.3%
Uppercase Letter 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
104
 
6.9%
103
 
6.8%
96
 
6.3%
91
 
6.0%
87
 
5.7%
84
 
5.5%
83
 
5.5%
83
 
5.5%
76
 
5.0%
52
 
3.4%
Other values (113) 656
43.3%
Decimal Number
ValueCountFrequency (%)
1 137
33.7%
2 57
14.0%
0 50
 
12.3%
3 37
 
9.1%
6 33
 
8.1%
7 23
 
5.7%
8 23
 
5.7%
4 17
 
4.2%
5 16
 
3.9%
9 13
 
3.2%
Space Separator
ValueCountFrequency (%)
448
100.0%
Open Punctuation
ValueCountFrequency (%)
( 84
100.0%
Other Punctuation
ValueCountFrequency (%)
, 84
100.0%
Close Punctuation
ValueCountFrequency (%)
) 84
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1515
57.6%
Common 1113
42.3%
Latin 3
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
104
 
6.9%
103
 
6.8%
96
 
6.3%
91
 
6.0%
87
 
5.7%
84
 
5.5%
83
 
5.5%
83
 
5.5%
76
 
5.0%
52
 
3.4%
Other values (113) 656
43.3%
Common
ValueCountFrequency (%)
448
40.3%
1 137
 
12.3%
( 84
 
7.5%
, 84
 
7.5%
) 84
 
7.5%
2 57
 
5.1%
0 50
 
4.5%
3 37
 
3.3%
6 33
 
3.0%
7 23
 
2.1%
Other values (5) 76
 
6.8%
Latin
ValueCountFrequency (%)
B 3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1515
57.6%
ASCII 1116
42.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
448
40.1%
1 137
 
12.3%
( 84
 
7.5%
, 84
 
7.5%
) 84
 
7.5%
2 57
 
5.1%
0 50
 
4.5%
3 37
 
3.3%
6 33
 
3.0%
7 23
 
2.1%
Other values (6) 79
 
7.1%
Hangul
ValueCountFrequency (%)
104
 
6.9%
103
 
6.8%
96
 
6.3%
91
 
6.0%
87
 
5.7%
84
 
5.5%
83
 
5.5%
83
 
5.5%
76
 
5.0%
52
 
3.4%
Other values (113) 656
43.3%
Distinct81
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size796.0 B
2023-12-12T16:29:22.841285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length38
Mean length23.626506
Min length16

Characters and Unicode

Total characters1961
Distinct characters113
Distinct categories6 ?
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 (%)95.2%

Sample

1st row부산광역시 북구 구포동 700-36
2nd row부산광역시 북구 만덕동 846-8 1층102호,지하 가동
3rd row부산광역시 북구 덕천동 387-12
4th row부산광역시 북구 금곡동 810-3
5th row부산광역시 북구 금곡동 1108 주공아파트 4단지상가 103호
ValueCountFrequency (%)
부산광역시 83
21.3%
북구 83
21.3%
화명동 34
 
8.7%
덕천동 16
 
4.1%
구포동 15
 
3.9%
만덕동 12
 
3.1%
금곡동 7
 
1.8%
상가동 5
 
1.3%
2324 3
 
0.8%
화명동대림타운 2
 
0.5%
Other values (118) 129
33.2%
2023-12-12T16:29:23.301165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
379
19.3%
1 107
 
5.5%
98
 
5.0%
98
 
5.0%
85
 
4.3%
85
 
4.3%
84
 
4.3%
83
 
4.2%
83
 
4.2%
83
 
4.2%
Other values (103) 776
39.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1064
54.3%
Decimal Number 445
22.7%
Space Separator 379
 
19.3%
Dash Punctuation 67
 
3.4%
Other Punctuation 4
 
0.2%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
98
 
9.2%
98
 
9.2%
85
 
8.0%
85
 
8.0%
84
 
7.9%
83
 
7.8%
83
 
7.8%
83
 
7.8%
40
 
3.8%
40
 
3.8%
Other values (89) 285
26.8%
Decimal Number
ValueCountFrequency (%)
1 107
24.0%
2 67
15.1%
3 53
11.9%
0 45
10.1%
8 34
 
7.6%
9 32
 
7.2%
4 31
 
7.0%
7 29
 
6.5%
6 25
 
5.6%
5 22
 
4.9%
Space Separator
ValueCountFrequency (%)
379
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 67
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1064
54.3%
Common 895
45.6%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
98
 
9.2%
98
 
9.2%
85
 
8.0%
85
 
8.0%
84
 
7.9%
83
 
7.8%
83
 
7.8%
83
 
7.8%
40
 
3.8%
40
 
3.8%
Other values (89) 285
26.8%
Common
ValueCountFrequency (%)
379
42.3%
1 107
 
12.0%
2 67
 
7.5%
- 67
 
7.5%
3 53
 
5.9%
0 45
 
5.0%
8 34
 
3.8%
9 32
 
3.6%
4 31
 
3.5%
7 29
 
3.2%
Other values (3) 51
 
5.7%
Latin
ValueCountFrequency (%)
B 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1064
54.3%
ASCII 897
45.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
379
42.3%
1 107
 
11.9%
2 67
 
7.5%
- 67
 
7.5%
3 53
 
5.9%
0 45
 
5.0%
8 34
 
3.8%
9 32
 
3.6%
4 31
 
3.5%
7 29
 
3.2%
Other values (4) 53
 
5.9%
Hangul
ValueCountFrequency (%)
98
 
9.2%
98
 
9.2%
85
 
8.0%
85
 
8.0%
84
 
7.9%
83
 
7.8%
83
 
7.8%
83
 
7.8%
40
 
3.8%
40
 
3.8%
Other values (89) 285
26.8%

소재지전화
Text

MISSING 

Distinct43
Distinct (%)100.0%
Missing40
Missing (%)48.2%
Memory size796.0 B
2023-12-12T16:29:23.905577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.255814
Min length12

Characters and Unicode

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

Unique43 ?
Unique (%)100.0%

Sample

1st row051-334-9991
2nd row051-336-7386
3rd row 051-338-5673
4th row051-362-3131
5th row 051-361-1929
ValueCountFrequency (%)
051-336-8212 2
 
4.7%
051-334-9991 1
 
2.3%
051-361-6220 1
 
2.3%
051-332-8436 1
 
2.3%
051-363-8201 1
 
2.3%
051-365-1719 1
 
2.3%
051-337-8282 1
 
2.3%
051-365-2227 1
 
2.3%
051-363-8225 1
 
2.3%
051-361-8289 1
 
2.3%
Other values (32) 32
74.4%
2023-12-12T16:29:24.327262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 86
16.3%
3 85
16.1%
1 69
13.1%
5 68
12.9%
0 65
12.3%
2 38
7.2%
6 33
 
6.3%
8 26
 
4.9%
9 18
 
3.4%
4 16
 
3.0%
Other values (2) 23
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 430
81.6%
Dash Punctuation 86
 
16.3%
Space Separator 11
 
2.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 85
19.8%
1 69
16.0%
5 68
15.8%
0 65
15.1%
2 38
8.8%
6 33
 
7.7%
8 26
 
6.0%
9 18
 
4.2%
4 16
 
3.7%
7 12
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 86
100.0%
Space Separator
ValueCountFrequency (%)
11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 527
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 86
16.3%
3 85
16.1%
1 69
13.1%
5 68
12.9%
0 65
12.3%
2 38
7.2%
6 33
 
6.3%
8 26
 
4.9%
9 18
 
3.4%
4 16
 
3.0%
Other values (2) 23
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 527
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 86
16.3%
3 85
16.1%
1 69
13.1%
5 68
12.9%
0 65
12.3%
2 38
7.2%
6 33
 
6.3%
8 26
 
4.9%
9 18
 
3.4%
4 16
 
3.0%
Other values (2) 23
 
4.4%

Correlations

2023-12-12T16:29:24.416764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명소재지(도로명)소재지(지번)소재지전화
업소명1.0001.0000.9881.000
소재지(도로명)1.0001.0001.0001.000
소재지(지번)0.9881.0001.0001.000
소재지전화1.0001.0001.0001.000

Missing values

2023-12-12T16:29:20.956451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:29:21.062966image/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제과점영업빵굽는마을부산광역시 북구 팽나무로 2 (구포동)부산광역시 북구 구포동 700-36051-334-9991
1제과점영업규문당과자점부산광역시 북구 덕천로 306, 가동 (만덕동, 1층102호,지하)부산광역시 북구 만덕동 846-8 1층102호,지하 가동051-336-7386
2제과점영업드레곤베이커리부산광역시 북구 만덕대로 88 (덕천동)부산광역시 북구 덕천동 387-12051-338-5673
3제과점영업하베스트베이커리부산광역시 북구 효열로 136 (금곡동)부산광역시 북구 금곡동 810-3051-362-3131
4제과점영업베이글스부산광역시 북구 효열로 76-1, 103호 (금곡동, 주공아파트4단지상가)부산광역시 북구 금곡동 1108 주공아파트 4단지상가 103호051-361-1929
5제과점영업슬준베이커리부산광역시 북구 대천천길 15 (화명동)부산광역시 북구 화명동 194-2<NA>
6제과점영업마들렌과자점부산광역시 북구 양달로8번길 12 (화명동)부산광역시 북구 화명동 191-3051-361-0065
7제과점영업브레드베이커리부산광역시 북구 구포시장8길 3 (구포동)부산광역시 북구 구포동 614-53051-338-9091
8제과점영업쿠켄하임과자점부산광역시 북구 덕천로234번길 13 (만덕동)부산광역시 북구 만덕동 925-1051-337-9552
9제과점영업파리바게트부산광역시 북구 덕천로 239-1, 1층 (만덕동)부산광역시 북구 만덕동 920-8 338동 4784호051-338-4784
업종명업소명소재지(도로명)소재지(지번)소재지전화
73제과점영업원베이커리&구우당부산광역시 북구 기찰로 164, 메가마트 덕천점 1층 (덕천동)부산광역시 북구 덕천동 370<NA>
74제과점영업마실카페부산광역시 북구 은행나무로 50-1, 1층 일부호 (만덕동)부산광역시 북구 만덕동 852-11<NA>
75제과점영업티니케이크부산광역시 북구 의성로 110, 1층 (덕천동)부산광역시 북구 덕천동 384-17<NA>
76제과점영업키키네과자집부산광역시 북구 모분재로 115, 1층 (구포동)부산광역시 북구 구포동 816-19<NA>
77제과점영업파리바게뜨 덕천포레나점부산광역시 북구 만덕대로 74, 1층 (덕천동)부산광역시 북구 덕천동 386-2<NA>
78제과점영업드래곤과자점(동문점)부산광역시 북구 덕천로276번길 60, 상가동 108,109호 (만덕동, 백양산동문굿모닝힐)부산광역시 북구 만덕동 955 백양산동문굿모닝힐<NA>
79제과점영업드래곤과자점부산광역시 북구 화명대로 31, 현호타워 105호 (화명동)부산광역시 북구 화명동 2272-5 현호타워<NA>
80제과점영업파밀로베이커리부산광역시 북구 금곡대로285번길 29, 네오플러스 108호, 109(일부)호 (화명동)부산광역시 북구 화명동 2286-3 네오플러스<NA>
81제과점영업엔제리너스 부산덕천점부산광역시 북구 덕천1길 24, 덕천동 세정인디안매장 1,2층 (덕천동)부산광역시 북구 덕천동 403-26 덕천동 세정인디안매장051-336-9665
82제과점영업화이트리에 화명점부산광역시 북구 금곡대로303번길 36, 101호 (화명동)부산광역시 북구 화명동 2268-3051-365-5233