Overview

Dataset statistics

Number of variables6
Number of observations164
Missing cells61
Missing cells (%)6.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.8 KiB
Average record size in memory48.8 B

Variable types

Categorical2
Text3
DateTime1

Dataset

Description파일 데이터 자료는 영덕군 관내 커피숍, 다방, 기타조리식품 판매업소 등을 포함한 휴게음식점(커피, 음료판매하는 곳) 리스트 현황입니다.
Author경상북도 영덕군
URLhttps://www.data.go.kr/data/15127470/fileData.do

Alerts

업종명 has constant value ""Constant
기준일자 has constant value ""Constant
소재지전화 has 61 (37.2%) missing valuesMissing

Reproduction

Analysis started2024-04-06 08:53:23.991299
Analysis finished2024-04-06 08:53:24.733771
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
휴게음식점
164 

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 (%)
휴게음식점 164
100.0%

Length

2024-04-06T17:53:24.851687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:53:25.019865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
휴게음식점 164
100.0%

업소명
Text

Distinct157
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-06T17:53:25.551074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length5.5
Min length2

Characters and Unicode

Total characters902
Distinct characters252
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

Unique151 ?
Unique (%)92.1%

Sample

1st row유정다방
2nd row황제다방
3rd row궁전다방
4th row중앙다방
5th row동원다방
ValueCountFrequency (%)
카페 7
 
3.4%
황제다방 3
 
1.5%
영덕점 3
 
1.5%
이디야 3
 
1.5%
다방 3
 
1.5%
복다방 2
 
1.0%
영덕강구점 2
 
1.0%
봄봄 2
 
1.0%
텐퍼센트커피 2
 
1.0%
꽃다방 2
 
1.0%
Other values (169) 175
85.8%
2024-04-06T17:53:26.350294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
다 88
 
9.8%
방 86
 
9.5%
40
 
4.4%
영 26
 
2.9%
덕 19
 
2.1%
점 18
 
2.0%
페 17
 
1.9%
이 16
 
1.8%
커 15
 
1.7%
카 15
 
1.7%
Other values (242) 562
62.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 793
87.9%
Space Separator 40
 
4.4%
Lowercase Letter 33
 
3.7%
Decimal Number 10
 
1.1%
Uppercase Letter 9
 
1.0%
Open Punctuation 8
 
0.9%
Close Punctuation 8
 
0.9%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
다 88
 
11.1%
방 86
 
10.8%
영 26
 
3.3%
덕 19
 
2.4%
점 18
 
2.3%
페 17
 
2.1%
이 16
 
2.0%
커 15
 
1.9%
카 15
 
1.9%
리 14
 
1.8%
Other values (209) 479
60.4%
Lowercase Letter
ValueCountFrequency (%)
e 6
18.2%
r 5
15.2%
a 4
12.1%
y 3
9.1%
f 2
 
6.1%
v 2
 
6.1%
p 2
 
6.1%
b 1
 
3.0%
d 1
 
3.0%
m 1
 
3.0%
Other values (6) 6
18.2%
Uppercase Letter
ValueCountFrequency (%)
O 3
33.3%
J 1
 
11.1%
U 1
 
11.1%
Y 1
 
11.1%
L 1
 
11.1%
K 1
 
11.1%
C 1
 
11.1%
Decimal Number
ValueCountFrequency (%)
8 2
20.0%
3 2
20.0%
2 2
20.0%
1 2
20.0%
9 1
10.0%
4 1
10.0%
Space Separator
ValueCountFrequency (%)
40
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 793
87.9%
Common 67
 
7.4%
Latin 42
 
4.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
다 88
 
11.1%
방 86
 
10.8%
영 26
 
3.3%
덕 19
 
2.4%
점 18
 
2.3%
페 17
 
2.1%
이 16
 
2.0%
커 15
 
1.9%
카 15
 
1.9%
리 14
 
1.8%
Other values (209) 479
60.4%
Latin
ValueCountFrequency (%)
e 6
14.3%
r 5
 
11.9%
a 4
 
9.5%
y 3
 
7.1%
O 3
 
7.1%
f 2
 
4.8%
v 2
 
4.8%
p 2
 
4.8%
J 1
 
2.4%
b 1
 
2.4%
Other values (13) 13
31.0%
Common
ValueCountFrequency (%)
40
59.7%
( 8
 
11.9%
) 8
 
11.9%
8 2
 
3.0%
3 2
 
3.0%
2 2
 
3.0%
1 2
 
3.0%
9 1
 
1.5%
4 1
 
1.5%
& 1
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 793
87.9%
ASCII 109
 
12.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
다 88
 
11.1%
방 86
 
10.8%
영 26
 
3.3%
덕 19
 
2.4%
점 18
 
2.3%
페 17
 
2.1%
이 16
 
2.0%
커 15
 
1.9%
카 15
 
1.9%
리 14
 
1.8%
Other values (209) 479
60.4%
ASCII
ValueCountFrequency (%)
40
36.7%
( 8
 
7.3%
) 8
 
7.3%
e 6
 
5.5%
r 5
 
4.6%
a 4
 
3.7%
y 3
 
2.8%
O 3
 
2.8%
f 2
 
1.8%
v 2
 
1.8%
Other values (23) 28
25.7%

업태명
Categorical

Distinct7
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
다방
92 
커피숍
51 
기타 휴게음식점
12 
일반조리판매
 
3
푸드트럭
 
3
Other values (2)
 
3

Length

Max length8
Median length2
Mean length2.902439
Min length2

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st row다방
2nd row다방
3rd row다방
4th row다방
5th row다방

Common Values

ValueCountFrequency (%)
다방 92
56.1%
커피숍 51
31.1%
기타 휴게음식점 12
 
7.3%
일반조리판매 3
 
1.8%
푸드트럭 3
 
1.8%
패스트푸드 2
 
1.2%
떡카페 1
 
0.6%

Length

2024-04-06T17:53:26.594658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:53:26.829602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
다방 92
52.3%
커피숍 51
29.0%
기타 12
 
6.8%
휴게음식점 12
 
6.8%
일반조리판매 3
 
1.7%
푸드트럭 3
 
1.7%
패스트푸드 2
 
1.1%
떡카페 1
 
0.6%

소재지(도로명)
Text

Distinct161
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-06T17:53:27.188758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length34
Mean length23.243902
Min length18

Characters and Unicode

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

Unique

Unique158 ?
Unique (%)96.3%

Sample

1st row경상북도 영덕군 남정면 진불길 40
2nd row경상북도 영덕군 병곡면 병곡2길 4
3rd row경상북도 영덕군 축산면 축산항길 29
4th row경상북도 영덕군 강구면 신강구길 4-1
5th row경상북도 영덕군 영덕읍 강변길 6
ValueCountFrequency (%)
경상북도 164
18.2%
영덕군 164
18.2%
영덕읍 53
 
5.9%
영해면 39
 
4.3%
강구면 36
 
4.0%
1층 34
 
3.8%
영덕대게로 22
 
2.4%
2층 21
 
2.3%
축산면 14
 
1.6%
남정면 13
 
1.4%
Other values (207) 340
37.8%
2024-04-06T17:53:28.017167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
739
19.4%
영 281
 
7.4%
덕 255
 
6.7%
군 172
 
4.5%
상 167
 
4.4%
경 165
 
4.3%
도 165
 
4.3%
북 164
 
4.3%
1 156
 
4.1%
길 125
 
3.3%
Other values (99) 1423
37.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2390
62.7%
Space Separator 739
 
19.4%
Decimal Number 555
 
14.6%
Other Punctuation 66
 
1.7%
Dash Punctuation 53
 
1.4%
Math Symbol 7
 
0.2%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 281
 
11.8%
덕 255
 
10.7%
군 172
 
7.2%
상 167
 
7.0%
경 165
 
6.9%
도 165
 
6.9%
북 164
 
6.9%
길 125
 
5.2%
면 111
 
4.6%
층 63
 
2.6%
Other values (83) 722
30.2%
Decimal Number
ValueCountFrequency (%)
1 156
28.1%
2 95
17.1%
4 61
 
11.0%
5 50
 
9.0%
3 43
 
7.7%
6 35
 
6.3%
7 30
 
5.4%
8 29
 
5.2%
9 29
 
5.2%
0 27
 
4.9%
Space Separator
ValueCountFrequency (%)
739
100.0%
Other Punctuation
ValueCountFrequency (%)
, 66
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 53
100.0%
Math Symbol
ValueCountFrequency (%)
~ 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2390
62.7%
Common 1422
37.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 281
 
11.8%
덕 255
 
10.7%
군 172
 
7.2%
상 167
 
7.0%
경 165
 
6.9%
도 165
 
6.9%
북 164
 
6.9%
길 125
 
5.2%
면 111
 
4.6%
층 63
 
2.6%
Other values (83) 722
30.2%
Common
ValueCountFrequency (%)
739
52.0%
1 156
 
11.0%
2 95
 
6.7%
, 66
 
4.6%
4 61
 
4.3%
- 53
 
3.7%
5 50
 
3.5%
3 43
 
3.0%
6 35
 
2.5%
7 30
 
2.1%
Other values (6) 94
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2390
62.7%
ASCII 1422
37.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
739
52.0%
1 156
 
11.0%
2 95
 
6.7%
, 66
 
4.6%
4 61
 
4.3%
- 53
 
3.7%
5 50
 
3.5%
3 43
 
3.0%
6 35
 
2.5%
7 30
 
2.1%
Other values (6) 94
 
6.6%
Hangul
ValueCountFrequency (%)
영 281
 
11.8%
덕 255
 
10.7%
군 172
 
7.2%
상 167
 
7.0%
경 165
 
6.9%
도 165
 
6.9%
북 164
 
6.9%
길 125
 
5.2%
면 111
 
4.6%
층 63
 
2.6%
Other values (83) 722
30.2%

소재지전화
Text

MISSING 

Distinct103
Distinct (%)100.0%
Missing61
Missing (%)37.2%
Memory size1.4 KiB
2024-04-06T17:53:28.657596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique103 ?
Unique (%)100.0%

Sample

1st row054-734-0533
2nd row054-732-2218
3rd row054-732-5032
4th row054-733-6161
5th row054-734-3333
ValueCountFrequency (%)
054-734-0533 1
 
1.0%
054-734-1189 1
 
1.0%
054-733-3373 1
 
1.0%
054-733-7942 1
 
1.0%
054-733-3946 1
 
1.0%
054-732-3331 1
 
1.0%
054-732-6020 1
 
1.0%
054-733-7222 1
 
1.0%
054-734-3888 1
 
1.0%
054-733-0844 1
 
1.0%
Other values (93) 93
90.3%
2024-04-06T17:53:29.477014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 206
16.7%
3 198
16.0%
0 165
13.3%
4 159
12.9%
5 146
11.8%
7 127
10.3%
2 68
 
5.5%
8 54
 
4.4%
1 41
 
3.3%
6 37
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1030
83.3%
Dash Punctuation 206
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 198
19.2%
0 165
16.0%
4 159
15.4%
5 146
14.2%
7 127
12.3%
2 68
 
6.6%
8 54
 
5.2%
1 41
 
4.0%
6 37
 
3.6%
9 35
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 206
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1236
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 206
16.7%
3 198
16.0%
0 165
13.3%
4 159
12.9%
5 146
11.8%
7 127
10.3%
2 68
 
5.5%
8 54
 
4.4%
1 41
 
3.3%
6 37
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1236
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 206
16.7%
3 198
16.0%
0 165
13.3%
4 159
12.9%
5 146
11.8%
7 127
10.3%
2 68
 
5.5%
8 54
 
4.4%
1 41
 
3.3%
6 37
 
3.0%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2024-04-01 00:00:00
Maximum2024-04-01 00:00:00
2024-04-06T17:53:29.693598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:53:29.894274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-04-06T17:53:24.483046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:53:24.664031image/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휴게음식점유정다방다방경상북도 영덕군 남정면 진불길 40054-734-05332024-04-01
1휴게음식점황제다방다방경상북도 영덕군 병곡면 병곡2길 4054-732-22182024-04-01
2휴게음식점궁전다방다방경상북도 영덕군 축산면 축산항길 29054-732-50322024-04-01
3휴게음식점중앙다방다방경상북도 영덕군 강구면 신강구길 4-1054-733-61612024-04-01
4휴게음식점동원다방다방경상북도 영덕군 영덕읍 강변길 6054-734-33332024-04-01
5휴게음식점명다방다방경상북도 영덕군 영덕읍 덕곡길 128054-734-24782024-04-01
6휴게음식점곰다실다방경상북도 영덕군 영덕읍 덕곡길 93054-733-01232024-04-01
7휴게음식점영덕다방다방경상북도 영덕군 영덕읍 우곡길 51054-734-54432024-04-01
8휴게음식점은해다방다방경상북도 영덕군 영해면 예주2길 42-3054-734-12342024-04-01
9휴게음식점죽도커피숍다방경상북도 영덕군 축산면 축산항길 46-1054-733-60662024-04-01
업종명업소명업태명소재지(도로명)소재지전화기준일자
154휴게음식점느림커피숍경상북도 영덕군 영덕읍 영덕로 72-78, 1~2층<NA>2024-04-01
155휴게음식점복합문화예술카페 업사이클커피숍경상북도 영덕군 영해면 벌영길 147-79, 1층<NA>2024-04-01
156휴게음식점영덕대게빵기타 휴게음식점경상북도 영덕군 강구면 영덕대게로 112<NA>2024-04-01
157휴게음식점꽃다방다방경상북도 영덕군 영덕읍 덕곡천길 94054-733-67772024-04-01
158휴게음식점베이커리일이일(베이커리121)기타 휴게음식점경상북도 영덕군 영덕읍 군청길 121, 현대자동차<NA>2024-04-01
159휴게음식점디저트39 영덕중앙점커피숍경상북도 영덕군 영덕읍 중앙길 75, 1층<NA>2024-04-01
160휴게음식점만나슈퍼커피숍경상북도 영덕군 강구면 영덕대게로 497<NA>2024-04-01
161휴게음식점수평선 다방다방경상북도 영덕군 강구면 동해대로 4467, 2층054-733-32442024-04-01
162휴게음식점카페 은경이랑 은하랑(푸드트럭)푸드트럭경상북도 영덕군 축산면 영덕대게로 2062<NA>2024-04-01
163휴게음식점제이드떡카페(Jade Cafe)커피숍경상북도 영덕군 영해면 영덕로 1813, 1층<NA>2024-04-01