Overview

Dataset statistics

Number of variables7
Number of observations394
Missing cells219
Missing cells (%)7.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory22.1 KiB
Average record size in memory57.3 B

Variable types

Categorical3
Text3
Numeric1

Dataset

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

Alerts

업종명 has constant value ""Constant
업태명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 219 (55.6%) missing valuesMissing

Reproduction

Analysis started2023-12-12 06:41:32.593433
Analysis finished2023-12-12 06:41:33.203775
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
제과점영업
394 

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

Length

2023-12-12T15:41:33.261607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:41:33.348029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제과점영업 394
100.0%

업소명
Text

Distinct382
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
2023-12-12T15:41:33.854142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length12
Mean length6.9035533
Min length1

Characters and Unicode

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

Unique

Unique379 ?
Unique (%)96.2%

Sample

1st row가야
2nd row가야베이커리시청점
3rd row갓식빵삼도점
4th row갓식빵제주삼화점
5th row갓식빵제주연동점
ValueCountFrequency (%)
주영올레베이커리 11
 
2.8%
하나로베이커리 2
 
0.5%
한라산쑥찐빵 2
 
0.5%
행복나눔베이커리 1
 
0.3%
자연드림삼화점 1
 
0.3%
제주보리빵전문점 1
 
0.3%
제주명품쑥보리빵 1
 
0.3%
제주명과 1
 
0.3%
제주달고나 1
 
0.3%
제제캐러멜 1
 
0.3%
Other values (372) 372
94.4%
2023-12-12T15:41:34.245290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 147
 
5.4%
리 144
 
5.3%
이 105
 
3.9%
제 89
 
3.3%
빵 87
 
3.2%
주 85
 
3.1%
베 76
 
2.8%
커 66
 
2.4%
파 49
 
1.8%
레 48
 
1.8%
Other values (341) 1824
67.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2677
98.4%
Decimal Number 42
 
1.5%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 147
 
5.5%
리 144
 
5.4%
이 105
 
3.9%
제 89
 
3.3%
빵 87
 
3.2%
주 85
 
3.2%
베 76
 
2.8%
커 66
 
2.5%
파 49
 
1.8%
레 48
 
1.8%
Other values (332) 1781
66.5%
Decimal Number
ValueCountFrequency (%)
2 17
40.5%
1 11
26.2%
3 4
 
9.5%
5 3
 
7.1%
4 3
 
7.1%
0 2
 
4.8%
6 1
 
2.4%
8 1
 
2.4%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2677
98.4%
Common 43
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 147
 
5.5%
리 144
 
5.4%
이 105
 
3.9%
제 89
 
3.3%
빵 87
 
3.2%
주 85
 
3.2%
베 76
 
2.8%
커 66
 
2.5%
파 49
 
1.8%
레 48
 
1.8%
Other values (332) 1781
66.5%
Common
ValueCountFrequency (%)
2 17
39.5%
1 11
25.6%
3 4
 
9.3%
5 3
 
7.0%
4 3
 
7.0%
0 2
 
4.7%
) 1
 
2.3%
6 1
 
2.3%
8 1
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2677
98.4%
ASCII 43
 
1.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 147
 
5.5%
리 144
 
5.4%
이 105
 
3.9%
제 89
 
3.3%
빵 87
 
3.2%
주 85
 
3.2%
베 76
 
2.8%
커 66
 
2.5%
파 49
 
1.8%
레 48
 
1.8%
Other values (332) 1781
66.5%
ASCII
ValueCountFrequency (%)
2 17
39.5%
1 11
25.6%
3 4
 
9.3%
5 3
 
7.0%
4 3
 
7.0%
0 2
 
4.7%
) 1
 
2.3%
6 1
 
2.3%
8 1
 
2.3%

소재지
Text

Distinct383
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
2023-12-12T15:41:34.622640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length26
Mean length20.502538
Min length17

Characters and Unicode

Total characters8078
Distinct characters140
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

Unique373 ?
Unique (%)94.7%

Sample

1st row제주특별자치도 제주시 중앙로 320
2nd row제주특별자치도 제주시 동광로6길 23
3rd row제주특별자치도 제주시 서사로 90
4th row제주특별자치도 제주시 건주로4길 6-8
5th row제주특별자치도 제주시 은남1길 21
ValueCountFrequency (%)
제주특별자치도 394
23.7%
제주시 394
23.7%
애월읍 31
 
1.9%
조천읍 18
 
1.1%
중앙로 17
 
1.0%
구좌읍 13
 
0.8%
한림읍 11
 
0.7%
2 11
 
0.7%
신북로 9
 
0.5%
29 8
 
0.5%
Other values (422) 753
45.4%
2023-12-12T15:41:35.155526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1389
17.2%
주 803
 
9.9%
제 788
 
9.8%
도 409
 
5.1%
자 396
 
4.9%
특 394
 
4.9%
별 394
 
4.9%
치 394
 
4.9%
시 394
 
4.9%
로 312
 
3.9%
Other values (130) 2405
29.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5533
68.5%
Space Separator 1389
 
17.2%
Decimal Number 1103
 
13.7%
Dash Punctuation 53
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 803
14.5%
제 788
14.2%
도 409
 
7.4%
자 396
 
7.2%
특 394
 
7.1%
별 394
 
7.1%
치 394
 
7.1%
시 394
 
7.1%
로 312
 
5.6%
길 153
 
2.8%
Other values (118) 1096
19.8%
Decimal Number
ValueCountFrequency (%)
1 235
21.3%
2 173
15.7%
3 121
11.0%
4 108
9.8%
5 98
8.9%
6 88
 
8.0%
0 76
 
6.9%
7 75
 
6.8%
8 69
 
6.3%
9 60
 
5.4%
Space Separator
ValueCountFrequency (%)
1389
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 53
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5533
68.5%
Common 2545
31.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 803
14.5%
제 788
14.2%
도 409
 
7.4%
자 396
 
7.2%
특 394
 
7.1%
별 394
 
7.1%
치 394
 
7.1%
시 394
 
7.1%
로 312
 
5.6%
길 153
 
2.8%
Other values (118) 1096
19.8%
Common
ValueCountFrequency (%)
1389
54.6%
1 235
 
9.2%
2 173
 
6.8%
3 121
 
4.8%
4 108
 
4.2%
5 98
 
3.9%
6 88
 
3.5%
0 76
 
3.0%
7 75
 
2.9%
8 69
 
2.7%
Other values (2) 113
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5533
68.5%
ASCII 2545
31.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1389
54.6%
1 235
 
9.2%
2 173
 
6.8%
3 121
 
4.8%
4 108
 
4.2%
5 98
 
3.9%
6 88
 
3.5%
0 76
 
3.0%
7 75
 
2.9%
8 69
 
2.7%
Other values (2) 113
 
4.4%
Hangul
ValueCountFrequency (%)
주 803
14.5%
제 788
14.2%
도 409
 
7.4%
자 396
 
7.2%
특 394
 
7.1%
별 394
 
7.1%
치 394
 
7.1%
시 394
 
7.1%
로 312
 
5.6%
길 153
 
2.8%
Other values (118) 1096
19.8%

영업장면적
Real number (ℝ)

Distinct332
Distinct (%)84.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean63.43698
Minimum0
Maximum426.58
Zeros1
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size3.6 KiB
2023-12-12T15:41:35.312374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3.86
Q127.125
median48.095
Q384.2775
95-th percentile168.811
Maximum426.58
Range426.58
Interquartile range (IQR)57.1525

Descriptive statistics

Standard deviation55.194325
Coefficient of variation (CV)0.87006546
Kurtosis8.3245294
Mean63.43698
Median Absolute Deviation (MAD)24.95
Skewness2.2659444
Sum24994.17
Variance3046.4135
MonotonicityNot monotonic
2023-12-12T15:41:35.466045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.3 16
 
4.1%
6.6 12
 
3.0%
33.0 5
 
1.3%
66.0 4
 
1.0%
99.0 4
 
1.0%
26.4 4
 
1.0%
55.0 3
 
0.8%
9.9 2
 
0.5%
50.0 2
 
0.5%
32.4 2
 
0.5%
Other values (322) 340
86.3%
ValueCountFrequency (%)
0.0 1
 
0.3%
3.3 16
4.1%
3.42 1
 
0.3%
3.52 1
 
0.3%
3.6 1
 
0.3%
4.0 1
 
0.3%
4.5 1
 
0.3%
6.2 1
 
0.3%
6.6 12
3.0%
8.72 1
 
0.3%
ValueCountFrequency (%)
426.58 1
0.3%
344.0 1
0.3%
314.96 1
0.3%
305.23 1
0.3%
285.46 1
0.3%
257.53 1
0.3%
238.14 1
0.3%
221.0 1
0.3%
200.0 1
0.3%
192.61 1
0.3%

전화번호
Text

MISSING 

Distinct163
Distinct (%)93.1%
Missing219
Missing (%)55.6%
Memory size3.2 KiB
2023-12-12T15:41:35.727853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique155 ?
Unique (%)88.6%

Sample

1st row064-757-3586
2nd row064-724-6262
3rd row064-772-4709
4th row064-726-4922
5th row064-795-6336
ValueCountFrequency (%)
064-758-7904 4
 
2.3%
064-753-7904 4
 
2.3%
064-745-4600 2
 
1.1%
064-744-4600 2
 
1.1%
064-723-0425 2
 
1.1%
064-702-0919 2
 
1.1%
064-717-9181 2
 
1.1%
064-711-0435 2
 
1.1%
064-784-5404 1
 
0.6%
064-729-1551 1
 
0.6%
Other values (153) 153
87.4%
2023-12-12T15:41:36.216920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 350
16.7%
0 313
14.9%
4 291
13.9%
6 251
12.0%
7 237
11.3%
5 141
6.7%
2 137
 
6.5%
1 117
 
5.6%
8 95
 
4.5%
3 85
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1750
83.3%
Dash Punctuation 350
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 313
17.9%
4 291
16.6%
6 251
14.3%
7 237
13.5%
5 141
8.1%
2 137
7.8%
1 117
 
6.7%
8 95
 
5.4%
3 85
 
4.9%
9 83
 
4.7%
Dash Punctuation
ValueCountFrequency (%)
- 350
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2100
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 350
16.7%
0 313
14.9%
4 291
13.9%
6 251
12.0%
7 237
11.3%
5 141
6.7%
2 137
 
6.5%
1 117
 
5.6%
8 95
 
4.5%
3 85
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2100
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 350
16.7%
0 313
14.9%
4 291
13.9%
6 251
12.0%
7 237
11.3%
5 141
6.7%
2 137
 
6.5%
1 117
 
5.6%
8 95
 
4.5%
3 85
 
4.0%

업태명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
제과점영업
394 

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

Length

2023-12-12T15:41:36.342732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:41:36.420098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제과점영업 394
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
2021-02-23
394 

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 394
100.0%

Length

2023-12-12T15:41:36.507517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:41:36.626477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02-23 394
100.0%

Interactions

2023-12-12T15:41:32.939620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T15:41:33.050577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:41:33.161611image/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제과점영업가야제주특별자치도 제주시 중앙로 32016.8064-757-3586제과점영업2021-02-23
1제과점영업가야베이커리시청점제주특별자치도 제주시 동광로6길 236.6064-724-6262제과점영업2021-02-23
2제과점영업갓식빵삼도점제주특별자치도 제주시 서사로 9044.71<NA>제과점영업2021-02-23
3제과점영업갓식빵제주삼화점제주특별자치도 제주시 건주로4길 6-838.61<NA>제과점영업2021-02-23
4제과점영업갓식빵제주연동점제주특별자치도 제주시 은남1길 2185.22<NA>제과점영업2021-02-23
5제과점영업갓식빵중앙여고점제주특별자치도 제주시 구남동5길 340.8<NA>제과점영업2021-02-23
6제과점영업겔빠제주특별자치도 제주시 월광로 7798.05<NA>제과점영업2021-02-23
7제과점영업고산빵제과제주특별자치도 제주시 한경면 고산로 1843.06064-772-4709제과점영업2021-02-23
8제과점영업고튼올레제주특별자치도 제주시 중앙로 57329.7064-726-4922제과점영업2021-02-23
9제과점영업곱닥헌케익엔쿠키제주특별자치도 제주시 금월길 2725.85<NA>제과점영업2021-02-23
업종명업소명소재지영업장면적전화번호업태명데이터기준일자
384제과점영업행복나눔베이커리노형점제주특별자치도 제주시 원노형로 4635.0064-711-0043제과점영업2021-02-23
385제과점영업행복밀제주특별자치도 제주시 서광로 23952.0064-757-4998제과점영업2021-02-23
386제과점영업허브카페제주특별자치도 제주시 한림읍 한림로 30096.36064-796-0001제과점영업2021-02-23
387제과점영업현대제주특별자치도 제주시 관덕로14길 1414.4064-757-5020제과점영업2021-02-23
388제과점영업혼아름베이커리제주특별자치도 제주시 구좌읍 세평항로 140.09064-782-6917제과점영업2021-02-23
389제과점영업홍마트베이커리제주특별자치도 제주시 사메기길 53-133.92064-743-0500제과점영업2021-02-23
390제과점영업화북빵굽는사람들제주특별자치도 제주시 일주동로 23330.9<NA>제과점영업2021-02-23
391제과점영업훈베이커리제주특별자치도 제주시 동광로 2653.82064-758-0292제과점영업2021-02-23
392제과점영업훈베이커리연동점제주특별자치도 제주시 일주서로 786432.0<NA>제과점영업2021-02-23
393제과점영업흥부네찐빵제주특별자치도 제주시 동광로 94-229.44064-722-1348제과점영업2021-02-23