Overview

Dataset statistics

Number of variables5
Number of observations258
Missing cells116
Missing cells (%)9.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.2 KiB
Average record size in memory40.5 B

Variable types

Categorical2
Text3

Dataset

Description제주특별자치도 제주시 식품관련업 관련 현황 데이터를 제공합니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056172/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 16:01:07.826465
Analysis finished2023-12-12 16:01:08.277100
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
유통전문판매업
258 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유통전문판매업
2nd row유통전문판매업
3rd row유통전문판매업
4th row유통전문판매업
5th row유통전문판매업

Common Values

ValueCountFrequency (%)
유통전문판매업 258
100.0%

Length

2023-12-13T01:01:08.351816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:01:08.446165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유통전문판매업 258
100.0%

업소명
Text

UNIQUE 

Distinct258
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2023-12-13T01:01:08.643466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length8.4108527
Min length2

Characters and Unicode

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

Unique

Unique258 ?
Unique (%)100.0%

Sample

1st row농업회사법인주식회사 오제주
2nd row(주) 대동
3rd row(주)제주아침
4th row(주)제주킹마트
5th row삼포수산
ValueCountFrequency (%)
주식회사 12
 
4.2%
농업회사법인 5
 
1.8%
영어조합법인 2
 
0.7%
영농조합법인 2
 
0.7%
주식회사제주태양 1
 
0.4%
컬러슈가주식회사 1
 
0.4%
제주패밀리 1
 
0.4%
농업회사법인(주)삼원네이처 1
 
0.4%
영어조합법인올래씨푸드 1
 
0.4%
주식회사이도 1
 
0.4%
Other values (257) 257
90.5%
2023-12-13T01:01:09.361982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 221
 
10.2%
제 107
 
4.9%
사 106
 
4.9%
회 101
 
4.7%
( 75
 
3.5%
) 75
 
3.5%
인 75
 
3.5%
농 67
 
3.1%
법 66
 
3.0%
식 62
 
2.9%
Other values (310) 1215
56.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1993
91.8%
Open Punctuation 75
 
3.5%
Close Punctuation 75
 
3.5%
Space Separator 26
 
1.2%
Decimal Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 221
 
11.1%
제 107
 
5.4%
사 106
 
5.3%
회 101
 
5.1%
인 75
 
3.8%
농 67
 
3.4%
법 66
 
3.3%
식 62
 
3.1%
업 43
 
2.2%
이 39
 
2.0%
Other values (306) 1106
55.5%
Open Punctuation
ValueCountFrequency (%)
( 75
100.0%
Close Punctuation
ValueCountFrequency (%)
) 75
100.0%
Space Separator
ValueCountFrequency (%)
26
100.0%
Decimal Number
ValueCountFrequency (%)
9 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1993
91.8%
Common 177
 
8.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 221
 
11.1%
제 107
 
5.4%
사 106
 
5.3%
회 101
 
5.1%
인 75
 
3.8%
농 67
 
3.4%
법 66
 
3.3%
식 62
 
3.1%
업 43
 
2.2%
이 39
 
2.0%
Other values (306) 1106
55.5%
Common
ValueCountFrequency (%)
( 75
42.4%
) 75
42.4%
26
 
14.7%
9 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1993
91.8%
ASCII 177
 
8.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 221
 
11.1%
제 107
 
5.4%
사 106
 
5.3%
회 101
 
5.1%
인 75
 
3.8%
농 67
 
3.4%
법 66
 
3.3%
식 62
 
3.1%
업 43
 
2.2%
이 39
 
2.0%
Other values (306) 1106
55.5%
ASCII
ValueCountFrequency (%)
( 75
42.4%
) 75
42.4%
26
 
14.7%
9 1
 
0.6%

소재지
Text

Distinct220
Distinct (%)85.3%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2023-12-13T01:01:09.836256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length26
Mean length21.228682
Min length17

Characters and Unicode

Total characters5477
Distinct characters151
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

Unique206 ?
Unique (%)79.8%

Sample

1st row제주특별자치도 제주시 고사마루길 62
2nd row제주특별자치도 제주시 구좌읍 행원로13길 39
3rd row제주특별자치도 제주시 동화로 40
4th row제주특별자치도 제주시 지석10길 13-5
5th row제주특별자치도 제주시 중앙로 28
ValueCountFrequency (%)
제주특별자치도 258
23.2%
제주시 258
23.2%
애월읍 22
 
2.0%
조천읍 18
 
1.6%
제주대학로 14
 
1.3%
구좌읍 14
 
1.3%
102 11
 
1.0%
한림읍 10
 
0.9%
첨단로 8
 
0.7%
일주동로 8
 
0.7%
Other values (331) 489
44.1%
2023-12-13T01:01:10.424525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
852
15.6%
주 546
 
10.0%
제 532
 
9.7%
도 278
 
5.1%
자 262
 
4.8%
치 259
 
4.7%
시 259
 
4.7%
별 258
 
4.7%
특 258
 
4.7%
1 197
 
3.6%
Other values (141) 1776
32.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3755
68.6%
Space Separator 852
 
15.6%
Decimal Number 809
 
14.8%
Dash Punctuation 61
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 546
14.5%
제 532
14.2%
도 278
 
7.4%
자 262
 
7.0%
치 259
 
6.9%
시 259
 
6.9%
별 258
 
6.9%
특 258
 
6.9%
로 176
 
4.7%
길 118
 
3.1%
Other values (129) 809
21.5%
Decimal Number
ValueCountFrequency (%)
1 197
24.4%
2 123
15.2%
3 85
10.5%
4 80
9.9%
0 73
 
9.0%
5 63
 
7.8%
6 58
 
7.2%
7 50
 
6.2%
8 42
 
5.2%
9 38
 
4.7%
Space Separator
ValueCountFrequency (%)
852
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 61
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3755
68.6%
Common 1722
31.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 546
14.5%
제 532
14.2%
도 278
 
7.4%
자 262
 
7.0%
치 259
 
6.9%
시 259
 
6.9%
별 258
 
6.9%
특 258
 
6.9%
로 176
 
4.7%
길 118
 
3.1%
Other values (129) 809
21.5%
Common
ValueCountFrequency (%)
852
49.5%
1 197
 
11.4%
2 123
 
7.1%
3 85
 
4.9%
4 80
 
4.6%
0 73
 
4.2%
5 63
 
3.7%
- 61
 
3.5%
6 58
 
3.4%
7 50
 
2.9%
Other values (2) 80
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3755
68.6%
ASCII 1722
31.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
852
49.5%
1 197
 
11.4%
2 123
 
7.1%
3 85
 
4.9%
4 80
 
4.6%
0 73
 
4.2%
5 63
 
3.7%
- 61
 
3.5%
6 58
 
3.4%
7 50
 
2.9%
Other values (2) 80
 
4.6%
Hangul
ValueCountFrequency (%)
주 546
14.5%
제 532
14.2%
도 278
 
7.4%
자 262
 
7.0%
치 259
 
6.9%
시 259
 
6.9%
별 258
 
6.9%
특 258
 
6.9%
로 176
 
4.7%
길 118
 
3.1%
Other values (129) 809
21.5%

전화번호
Text

MISSING 

Distinct141
Distinct (%)99.3%
Missing116
Missing (%)45.0%
Memory size2.1 KiB
2023-12-13T01:01:10.695432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique140 ?
Unique (%)98.6%

Sample

1st row064-748-2200
2nd row064-783-5853
3rd row064-713-5575
4th row064-724-0111
5th row064-702-0072
ValueCountFrequency (%)
064-744-7777 2
 
1.4%
064-902-9899 1
 
0.7%
064-755-5889 1
 
0.7%
064-756-8080 1
 
0.7%
064-712-5949 1
 
0.7%
064-745-2466 1
 
0.7%
064-721-3400 1
 
0.7%
064-782-1823 1
 
0.7%
064-748-0230 1
 
0.7%
064-755-3734 1
 
0.7%
Other values (131) 131
92.3%
2023-12-13T01:01:11.104638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 284
16.7%
4 247
14.5%
0 232
13.6%
7 208
12.2%
6 188
11.0%
2 108
 
6.3%
8 103
 
6.0%
5 90
 
5.3%
9 87
 
5.1%
1 83
 
4.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1420
83.3%
Dash Punctuation 284
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 247
17.4%
0 232
16.3%
7 208
14.6%
6 188
13.2%
2 108
7.6%
8 103
7.3%
5 90
 
6.3%
9 87
 
6.1%
1 83
 
5.8%
3 74
 
5.2%
Dash Punctuation
ValueCountFrequency (%)
- 284
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1704
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 284
16.7%
4 247
14.5%
0 232
13.6%
7 208
12.2%
6 188
11.0%
2 108
 
6.3%
8 103
 
6.0%
5 90
 
5.3%
9 87
 
5.1%
1 83
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1704
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 284
16.7%
4 247
14.5%
0 232
13.6%
7 208
12.2%
6 188
11.0%
2 108
 
6.3%
8 103
 
6.0%
5 90
 
5.3%
9 87
 
5.1%
1 83
 
4.9%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2021-02-26
258 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2021-02-26 258
100.0%

Length

2023-12-13T01:01:11.262247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:01:11.362092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02-26 258
100.0%

Missing values

2023-12-13T01:01:08.124846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:01:08.235421image/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유통전문판매업농업회사법인주식회사 오제주제주특별자치도 제주시 고사마루길 62064-748-22002021-02-26
1유통전문판매업(주) 대동제주특별자치도 제주시 구좌읍 행원로13길 39064-783-58532021-02-26
2유통전문판매업(주)제주아침제주특별자치도 제주시 동화로 40064-713-55752021-02-26
3유통전문판매업(주)제주킹마트제주특별자치도 제주시 지석10길 13-5064-724-01112021-02-26
4유통전문판매업삼포수산제주특별자치도 제주시 중앙로 28064-702-00722021-02-26
5유통전문판매업(주)명품제주점제주특별자치도 제주시 아연로 26064-746-97572021-02-26
6유통전문판매업농업회사법인(주)삼무제주특별자치도 제주시 조천읍 와흘로 128064-784-00312021-02-26
7유통전문판매업(주)제주느낌제주특별자치도 제주시 구산로 55-9064-724-21342021-02-26
8유통전문판매업골든팜제주특별자치도 제주시 신광로6길 25064-747-09452021-02-26
9유통전문판매업가도(주)제주특별자치도 제주시 고마로 54064-721-60772021-02-26
업종명업소명소재지전화번호데이터기준일자
248유통전문판매업미래셀바이오제주특별자치도 제주시 인다6길 35064-755-87592021-02-26
249유통전문판매업주식회사파란공장제주특별자치도 제주시 조천읍 신와로 119-1064-799-75202021-02-26
250유통전문판매업제주헬스케어굼제주특별자치도 제주시 한림읍 귀덕6길 94064-792-69772021-02-26
251유통전문판매업글래드호텔앤리조트(주)메종글래드제주제주특별자치도 제주시 노연로 80064-710-81282021-02-26
252유통전문판매업제주푸드몰제주특별자치도 제주시 사장길 10<NA>2021-02-26
253유통전문판매업돈마유통제주특별자치도 제주시 주르레길 1064-757-40002021-02-26
254유통전문판매업주식회사스위트몽키농업회사법인제주특별자치도 제주시 한경면 산양2길 41-36<NA>2021-02-26
255유통전문판매업인픽스제주특별자치도 제주시 서광로 242-1<NA>2021-02-26
256유통전문판매업장인떡방제주특별자치도 제주시 동문로4길 17<NA>2021-02-26
257유통전문판매업(주)월드위버제주특별자치도 제주시 용문로21길 3-1064-904-11052021-02-26