Overview

Dataset statistics

Number of variables7
Number of observations3004
Missing cells2209
Missing cells (%)10.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory167.3 KiB
Average record size in memory57.0 B

Variable types

Categorical3
Text3
Numeric1

Dataset

Description제주특별자치도 제주시 식품접객업 관련 휴게음식점 현황 데이터입니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15055982/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 2206 (73.4%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:34:15.460007
Analysis finished2023-12-12 22:34:16.940272
Duration1.48 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
휴게음식점
3004 

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

Length

2023-12-13T07:34:17.009851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:34:17.102660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
휴게음식점 3004
100.0%

업소명
Text

UNIQUE 

Distinct3004
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
2023-12-13T07:34:17.324594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length6.755992
Min length1

Characters and Unicode

Total characters20295
Distinct characters813
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

Unique3004 ?
Unique (%)100.0%

Sample

1st row커피니제주공항국제선점
2nd row커피니제주공항국내선점
3rd row오가다제주공항점
4th row미소야제주공항점
5th row롯데리아제주공항국내선탑승점
ValueCountFrequency (%)
커피니제주공항국제선점 1
 
< 0.1%
노을 1
 
< 0.1%
미스터브리즈커피제주칠성로점 1
 
< 0.1%
템푸스 1
 
< 0.1%
메탈리코 1
 
< 0.1%
바다의별 1
 
< 0.1%
카페띠아모제주법원점 1
 
< 0.1%
귤꽃 1
 
< 0.1%
브루어스 1
 
< 0.1%
드몽드티살롱 1
 
< 0.1%
Other values (3001) 3001
99.7%
2023-12-13T07:34:17.767114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 1190
 
5.9%
주 850
 
4.2%
제 841
 
4.1%
스 612
 
3.0%
이 431
 
2.1%
피 350
 
1.7%
씨 322
 
1.6%
에 289
 
1.4%
유 284
 
1.4%
지 276
 
1.4%
Other values (803) 14850
73.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 19569
96.4%
Decimal Number 533
 
2.6%
Uppercase Letter 80
 
0.4%
Close Punctuation 47
 
0.2%
Open Punctuation 46
 
0.2%
Lowercase Letter 12
 
0.1%
Space Separator 7
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 1190
 
6.1%
주 850
 
4.3%
제 841
 
4.3%
스 612
 
3.1%
이 431
 
2.2%
피 350
 
1.8%
씨 322
 
1.6%
에 289
 
1.5%
유 284
 
1.5%
지 276
 
1.4%
Other values (771) 14124
72.2%
Decimal Number
ValueCountFrequency (%)
2 214
40.2%
5 183
34.3%
1 32
 
6.0%
3 31
 
5.8%
4 16
 
3.0%
8 14
 
2.6%
0 13
 
2.4%
7 11
 
2.1%
9 10
 
1.9%
6 9
 
1.7%
Uppercase Letter
ValueCountFrequency (%)
C 17
21.2%
G 16
20.0%
S 14
17.5%
P 13
16.2%
T 8
10.0%
D 7
8.8%
V 2
 
2.5%
U 2
 
2.5%
K 1
 
1.2%
Lowercase Letter
ValueCountFrequency (%)
m 2
16.7%
a 2
16.7%
c 2
16.7%
e 1
8.3%
f 1
8.3%
i 1
8.3%
n 1
8.3%
o 1
8.3%
p 1
8.3%
Close Punctuation
ValueCountFrequency (%)
) 47
100.0%
Open Punctuation
ValueCountFrequency (%)
( 46
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 19569
96.4%
Common 634
 
3.1%
Latin 92
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 1190
 
6.1%
주 850
 
4.3%
제 841
 
4.3%
스 612
 
3.1%
이 431
 
2.2%
피 350
 
1.8%
씨 322
 
1.6%
에 289
 
1.5%
유 284
 
1.5%
지 276
 
1.4%
Other values (771) 14124
72.2%
Latin
ValueCountFrequency (%)
C 17
18.5%
G 16
17.4%
S 14
15.2%
P 13
14.1%
T 8
8.7%
D 7
7.6%
m 2
 
2.2%
a 2
 
2.2%
c 2
 
2.2%
V 2
 
2.2%
Other values (8) 9
9.8%
Common
ValueCountFrequency (%)
2 214
33.8%
5 183
28.9%
) 47
 
7.4%
( 46
 
7.3%
1 32
 
5.0%
3 31
 
4.9%
4 16
 
2.5%
8 14
 
2.2%
0 13
 
2.1%
7 11
 
1.7%
Other values (4) 27
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 19569
96.4%
ASCII 726
 
3.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 1190
 
6.1%
주 850
 
4.3%
제 841
 
4.3%
스 612
 
3.1%
이 431
 
2.2%
피 350
 
1.8%
씨 322
 
1.6%
에 289
 
1.5%
유 284
 
1.5%
지 276
 
1.4%
Other values (771) 14124
72.2%
ASCII
ValueCountFrequency (%)
2 214
29.5%
5 183
25.2%
) 47
 
6.5%
( 46
 
6.3%
1 32
 
4.4%
3 31
 
4.3%
C 17
 
2.3%
G 16
 
2.2%
4 16
 
2.2%
S 14
 
1.9%
Other values (22) 110
15.2%

소재지
Text

Distinct2664
Distinct (%)88.7%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
2023-12-13T07:34:18.186125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length29
Mean length21.038615
Min length17

Characters and Unicode

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

Unique

Unique2430 ?
Unique (%)80.9%

Sample

1st row제주특별자치도 제주시 공항로 2
2nd row제주특별자치도 제주시 공항로 2
3rd row제주특별자치도 제주시 공항로 2
4th row제주특별자치도 제주시 공항로 2
5th row제주특별자치도 제주시 공항로 2
ValueCountFrequency (%)
제주특별자치도 3004
23.2%
제주시 3004
23.2%
애월읍 251
 
1.9%
조천읍 203
 
1.6%
구좌읍 193
 
1.5%
한림읍 156
 
1.2%
중앙로 123
 
0.9%
한경면 92
 
0.7%
2 55
 
0.4%
애월해안로 54
 
0.4%
Other values (1790) 5816
44.9%
2023-12-13T07:34:18.744128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10454
16.5%
주 6153
 
9.7%
제 6046
 
9.6%
도 3142
 
5.0%
자 3038
 
4.8%
치 3005
 
4.8%
특 3004
 
4.8%
별 3004
 
4.8%
시 3004
 
4.8%
로 2174
 
3.4%
Other values (200) 20176
31.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 43452
68.8%
Space Separator 10454
 
16.5%
Decimal Number 8858
 
14.0%
Dash Punctuation 436
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 6153
14.2%
제 6046
13.9%
도 3142
 
7.2%
자 3038
 
7.0%
치 3005
 
6.9%
특 3004
 
6.9%
별 3004
 
6.9%
시 3004
 
6.9%
로 2174
 
5.0%
길 1210
 
2.8%
Other values (188) 9672
22.3%
Decimal Number
ValueCountFrequency (%)
1 1858
21.0%
2 1300
14.7%
3 988
11.2%
4 879
9.9%
5 783
8.8%
6 769
8.7%
7 619
 
7.0%
0 587
 
6.6%
8 565
 
6.4%
9 510
 
5.8%
Space Separator
ValueCountFrequency (%)
10454
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 436
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 43452
68.8%
Common 19748
31.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 6153
14.2%
제 6046
13.9%
도 3142
 
7.2%
자 3038
 
7.0%
치 3005
 
6.9%
특 3004
 
6.9%
별 3004
 
6.9%
시 3004
 
6.9%
로 2174
 
5.0%
길 1210
 
2.8%
Other values (188) 9672
22.3%
Common
ValueCountFrequency (%)
10454
52.9%
1 1858
 
9.4%
2 1300
 
6.6%
3 988
 
5.0%
4 879
 
4.5%
5 783
 
4.0%
6 769
 
3.9%
7 619
 
3.1%
0 587
 
3.0%
8 565
 
2.9%
Other values (2) 946
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 43452
68.8%
ASCII 19748
31.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10454
52.9%
1 1858
 
9.4%
2 1300
 
6.6%
3 988
 
5.0%
4 879
 
4.5%
5 783
 
4.0%
6 769
 
3.9%
7 619
 
3.1%
0 587
 
3.0%
8 565
 
2.9%
Other values (2) 946
 
4.8%
Hangul
ValueCountFrequency (%)
주 6153
14.2%
제 6046
13.9%
도 3142
 
7.2%
자 3038
 
7.0%
치 3005
 
6.9%
특 3004
 
6.9%
별 3004
 
6.9%
시 3004
 
6.9%
로 2174
 
5.0%
길 1210
 
2.8%
Other values (188) 9672
22.3%

영업장면적
Real number (ℝ)

Distinct1718
Distinct (%)57.2%
Missing3
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean63.453579
Minimum1.8
Maximum1150.76
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size26.5 KiB
2023-12-13T07:34:18.923147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.8
5-th percentile3.3
Q110.77
median42.25
Q382
95-th percentile198.31
Maximum1150.76
Range1148.96
Interquartile range (IQR)71.23

Descriptive statistics

Standard deviation81.883183
Coefficient of variation (CV)1.2904423
Kurtosis27.266012
Mean63.453579
Median Absolute Deviation (MAD)33.33
Skewness4.0098011
Sum190424.19
Variance6704.8556
MonotonicityNot monotonic
2023-12-13T07:34:19.048196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6.6 358
 
11.9%
3.3 175
 
5.8%
9.9 47
 
1.6%
33.0 33
 
1.1%
66.0 23
 
0.8%
10.0 22
 
0.7%
16.5 20
 
0.7%
49.5 16
 
0.5%
13.2 14
 
0.5%
15.0 13
 
0.4%
Other values (1708) 2280
75.9%
ValueCountFrequency (%)
1.8 1
 
< 0.1%
2.4 1
 
< 0.1%
2.8 1
 
< 0.1%
3.0 1
 
< 0.1%
3.3 175
5.8%
3.36 1
 
< 0.1%
3.69 1
 
< 0.1%
3.75 1
 
< 0.1%
3.8 1
 
< 0.1%
3.96 1
 
< 0.1%
ValueCountFrequency (%)
1150.76 1
< 0.1%
899.3 1
< 0.1%
843.8 1
< 0.1%
743.0 1
< 0.1%
722.41 1
< 0.1%
626.97 1
< 0.1%
622.32 1
< 0.1%
576.93 1
< 0.1%
564.32 1
< 0.1%
537.84 1
< 0.1%

전화번호
Text

MISSING 

Distinct767
Distinct (%)96.1%
Missing2206
Missing (%)73.4%
Memory size23.6 KiB
2023-12-13T07:34:19.391713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.993734
Min length9

Characters and Unicode

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

Unique746 ?
Unique (%)93.5%

Sample

1st row064-723-1187
2nd row064-783-9900
3rd row064-755-3106
4th row064-752-2231
5th row064-745-7722
ValueCountFrequency (%)
064-729-1053 4
 
0.5%
064-798-2500 4
 
0.5%
064-754-2392 4
 
0.5%
064-798-1053 4
 
0.5%
064-795-6336 3
 
0.4%
064-729-1551 3
 
0.4%
064-784-7300 2
 
0.3%
064-745-5588 2
 
0.3%
064-713-0644 2
 
0.3%
064-802-8054 2
 
0.3%
Other values (757) 768
96.2%
2023-12-13T07:34:19.854292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 1595
16.7%
0 1334
13.9%
4 1308
13.7%
7 1193
12.5%
6 1140
11.9%
2 658
6.9%
5 563
 
5.9%
1 516
 
5.4%
8 454
 
4.7%
3 422
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 7976
83.3%
Dash Punctuation 1595
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1334
16.7%
4 1308
16.4%
7 1193
15.0%
6 1140
14.3%
2 658
8.2%
5 563
7.1%
1 516
 
6.5%
8 454
 
5.7%
3 422
 
5.3%
9 388
 
4.9%
Dash Punctuation
ValueCountFrequency (%)
- 1595
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 9571
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 1595
16.7%
0 1334
13.9%
4 1308
13.7%
7 1193
12.5%
6 1140
11.9%
2 658
6.9%
5 563
 
5.9%
1 516
 
5.4%
8 454
 
4.7%
3 422
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 9571
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 1595
16.7%
0 1334
13.9%
4 1308
13.7%
7 1193
12.5%
6 1140
11.9%
2 658
6.9%
5 563
 
5.9%
1 516
 
5.4%
8 454
 
4.7%
3 422
 
4.4%

업태명
Categorical

Distinct14
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
기타 휴게음식점
1237 
커피숍
775 
편의점
426 
일반조리판매
353 
패스트푸드
 
79
Other values (9)
134 

Length

Max length8
Median length6
Mean length5.4670439
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row공항
2nd row공항
3rd row공항
4th row공항
5th row공항

Common Values

ValueCountFrequency (%)
기타 휴게음식점 1237
41.2%
커피숍 775
25.8%
편의점 426
 
14.2%
일반조리판매 353
 
11.8%
패스트푸드 79
 
2.6%
다방 53
 
1.8%
푸드트럭 29
 
1.0%
과자점 12
 
0.4%
키즈카페 12
 
0.4%
아이스크림 10
 
0.3%
Other values (4) 18
 
0.6%

Length

2023-12-13T07:34:20.043099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타 1237
29.2%
휴게음식점 1237
29.2%
커피숍 775
18.3%
편의점 426
 
10.0%
일반조리판매 353
 
8.3%
패스트푸드 79
 
1.9%
다방 53
 
1.2%
푸드트럭 29
 
0.7%
과자점 12
 
0.3%
키즈카페 12
 
0.3%
Other values (5) 28
 
0.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.6 KiB
2021-02-23
3004 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-02-23
2nd row2021-02-23
3rd row2021-02-23
4th row2021-02-23
5th row2021-02-23

Common Values

ValueCountFrequency (%)
2021-02-23 3004
100.0%

Length

2023-12-13T07:34:20.204884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:34:20.329808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02-23 3004
100.0%

Interactions

2023-12-13T07:34:16.492921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:34:20.405758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업장면적업태명
영업장면적1.0000.177
업태명0.1771.000
2023-12-13T07:34:20.507194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업장면적업태명
영업장면적1.0000.075
업태명0.0751.000

Missing values

2023-12-13T07:34:16.651093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:34:16.773089image/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.
2023-12-13T07:34:16.880546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

업종명업소명소재지영업장면적전화번호업태명데이터기준일자
0휴게음식점커피니제주공항국제선점제주특별자치도 제주시 공항로 272.7<NA>공항2021-02-23
1휴게음식점커피니제주공항국내선점제주특별자치도 제주시 공항로 293.79<NA>공항2021-02-23
2휴게음식점오가다제주공항점제주특별자치도 제주시 공항로 294.02<NA>공항2021-02-23
3휴게음식점미소야제주공항점제주특별자치도 제주시 공항로 2148.0<NA>공항2021-02-23
4휴게음식점롯데리아제주공항국내선탑승점제주특별자치도 제주시 공항로 2154.43<NA>공항2021-02-23
5휴게음식점스카이31푸드에비뉴제주특별자치도 제주시 공항로 2272.0<NA>공항2021-02-23
6휴게음식점프라임도너츠제주특별자치도 제주시 관덕로4길 1-517.4064-723-1187과자점2021-02-23
7휴게음식점에스피씨(주)제주공항점제주특별자치도 제주시 공항로 226.6<NA>과자점2021-02-23
8휴게음식점올림피아베이커리제주특별자치도 제주시 애월읍 애월로11길 2527.26<NA>과자점2021-02-23
9휴게음식점(주)산굼부리제주특별자치도 제주시 조천읍 비자림로 76827.9064-783-9900과자점2021-02-23
업종명업소명소재지영업장면적전화번호업태명데이터기준일자
2994휴게음식점에이비트럭제주특별자치도 제주시 동광로 699.9<NA>푸드트럭2021-02-23
2995휴게음식점디에이치푸드트럭제주특별자치도 제주시 은수길 6910.0<NA>푸드트럭2021-02-23
2996휴게음식점피그뱅제주특별자치도 제주시 은수길 6910.0<NA>푸드트럭2021-02-23
2997휴게음식점베트남제주특별자치도 제주시 은수길 6910.0<NA>푸드트럭2021-02-23
2998휴게음식점1984에이치제주특별자치도 제주시 은수길 6911.0<NA>푸드트럭2021-02-23
2999휴게음식점호끌락제주특별자치도 제주시 건입동 505-212.0<NA>푸드트럭2021-02-23
3000휴게음식점윤스타푸드트럭제주특별자치도 제주시 은수길 6514.58<NA>푸드트럭2021-02-23
3001휴게음식점볕이드는곳벧디2호제주특별자치도 제주시 은수길 6914.58<NA>푸드트럭2021-02-23
3002휴게음식점해를품은달제주특별자치도 제주시 은수길 6914.58<NA>푸드트럭2021-02-23
3003휴게음식점달리제주특별자치도 제주시 구좌읍 종달리 724-116.5<NA>푸드트럭2021-02-23