Overview

Dataset statistics

Number of variables6
Number of observations1120
Missing cells525
Missing cells (%)7.8%
Duplicate rows2
Duplicate rows (%)0.2%
Total size in memory52.6 KiB
Average record size in memory48.1 B

Variable types

Categorical2
Text4

Dataset

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

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 2 (0.2%) duplicate rowsDuplicates
전화번호 has 515 (46.0%) missing valuesMissing

Reproduction

Analysis started2023-12-12 04:43:38.783501
Analysis finished2023-12-12 04:43:40.187763
Duration1.4 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
즉석판매제조가공업
1120 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row즉석판매제조가공업
2nd row즉석판매제조가공업
3rd row즉석판매제조가공업
4th row즉석판매제조가공업
5th row즉석판매제조가공업

Common Values

ValueCountFrequency (%)
즉석판매제조가공업 1120
100.0%

Length

2023-12-12T13:43:40.269887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:43:40.390503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
즉석판매제조가공업 1120
100.0%

업소명
Text

Distinct1105
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
2023-12-12T13:43:40.620790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length6.0732143
Min length1

Characters and Unicode

Total characters6802
Distinct characters546
Distinct categories5 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1097 ?
Unique (%)97.9%

Sample

1st row(주고려바이오홍삼 제주지점
2nd row(주나베식품
3rd row(주농협홍삼제주시농협하나로유통센터점
4th row(주뉴월드마트로노형점
5th row(주뉴월드마트로연동점
ValueCountFrequency (%)
주식회사 11
 
1.0%
원이원유통 5
 
0.4%
반찬코너 5
 
0.4%
씨엔 4
 
0.3%
한국생식품연합 4
 
0.3%
가치 3
 
0.3%
대찬수산 3
 
0.3%
제주점 3
 
0.3%
웰빙우렁각시 2
 
0.2%
미소담은 2
 
0.2%
Other values (1108) 1112
96.4%
2023-12-12T13:43:41.339831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 228
 
3.4%
제 191
 
2.8%
마 161
 
2.4%
이 147
 
2.2%
점 142
 
2.1%
트 136
 
2.0%
원 131
 
1.9%
식 112
 
1.6%
( 94
 
1.4%
산 93
 
1.4%
Other values (536) 5367
78.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6571
96.6%
Decimal Number 102
 
1.5%
Open Punctuation 94
 
1.4%
Space Separator 34
 
0.5%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 228
 
3.5%
제 191
 
2.9%
마 161
 
2.5%
이 147
 
2.2%
점 142
 
2.2%
트 136
 
2.1%
원 131
 
2.0%
식 112
 
1.7%
산 93
 
1.4%
건 87
 
1.3%
Other values (523) 5143
78.3%
Decimal Number
ValueCountFrequency (%)
1 31
30.4%
2 25
24.5%
3 12
 
11.8%
0 7
 
6.9%
9 7
 
6.9%
5 5
 
4.9%
8 4
 
3.9%
4 4
 
3.9%
7 4
 
3.9%
6 3
 
2.9%
Open Punctuation
ValueCountFrequency (%)
( 94
100.0%
Space Separator
ValueCountFrequency (%)
34
100.0%
Letter Number
ValueCountFrequency (%)
Ⅰ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6571
96.6%
Common 230
 
3.4%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 228
 
3.5%
제 191
 
2.9%
마 161
 
2.5%
이 147
 
2.2%
점 142
 
2.2%
트 136
 
2.1%
원 131
 
2.0%
식 112
 
1.7%
산 93
 
1.4%
건 87
 
1.3%
Other values (523) 5143
78.3%
Common
ValueCountFrequency (%)
( 94
40.9%
34
 
14.8%
1 31
 
13.5%
2 25
 
10.9%
3 12
 
5.2%
0 7
 
3.0%
9 7
 
3.0%
5 5
 
2.2%
8 4
 
1.7%
4 4
 
1.7%
Other values (2) 7
 
3.0%
Latin
ValueCountFrequency (%)
Ⅰ 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6571
96.6%
ASCII 230
 
3.4%
Number Forms 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 228
 
3.5%
제 191
 
2.9%
마 161
 
2.5%
이 147
 
2.2%
점 142
 
2.2%
트 136
 
2.1%
원 131
 
2.0%
식 112
 
1.7%
산 93
 
1.4%
건 87
 
1.3%
Other values (523) 5143
78.3%
ASCII
ValueCountFrequency (%)
( 94
40.9%
34
 
14.8%
1 31
 
13.5%
2 25
 
10.9%
3 12
 
5.2%
0 7
 
3.0%
9 7
 
3.0%
5 5
 
2.2%
8 4
 
1.7%
4 4
 
1.7%
Other values (2) 7
 
3.0%
Number Forms
ValueCountFrequency (%)
Ⅰ 1
100.0%

도로명주소
Text

Distinct899
Distinct (%)80.8%
Missing7
Missing (%)0.6%
Memory size8.9 KiB
2023-12-12T13:43:41.939067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length27
Mean length20.844564
Min length17

Characters and Unicode

Total characters23200
Distinct characters194
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

Unique822 ?
Unique (%)73.9%

Sample

1st row제주특별자치도 제주시 연삼로 3
2nd row제주특별자치도 제주시 일주서로 7427
3rd row제주특별자치도 제주시 월광로 77
4th row제주특별자치도 제주시 월랑로10길 14
5th row제주특별자치도 제주시 일주서로 7822
ValueCountFrequency (%)
제주특별자치도 1113
23.4%
제주시 1113
23.4%
애월읍 80
 
1.7%
한림읍 74
 
1.6%
조천읍 65
 
1.4%
구좌읍 46
 
1.0%
한경면 38
 
0.8%
중앙로13길 36
 
0.8%
일주서로 31
 
0.7%
16-12 29
 
0.6%
Other values (859) 2141
44.9%
2023-12-12T13:43:42.725592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3653
15.7%
주 2284
 
9.8%
제 2229
 
9.6%
도 1139
 
4.9%
자 1121
 
4.8%
시 1114
 
4.8%
별 1113
 
4.8%
치 1113
 
4.8%
특 1113
 
4.8%
1 865
 
3.7%
Other values (184) 7456
32.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 15987
68.9%
Space Separator 3653
 
15.7%
Decimal Number 3346
 
14.4%
Dash Punctuation 214
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 2284
14.3%
제 2229
13.9%
도 1139
 
7.1%
자 1121
 
7.0%
시 1114
 
7.0%
별 1113
 
7.0%
치 1113
 
7.0%
특 1113
 
7.0%
로 816
 
5.1%
길 589
 
3.7%
Other values (172) 3356
21.0%
Decimal Number
ValueCountFrequency (%)
1 865
25.9%
2 432
12.9%
3 387
11.6%
4 332
 
9.9%
6 276
 
8.2%
5 261
 
7.8%
0 214
 
6.4%
7 212
 
6.3%
8 201
 
6.0%
9 166
 
5.0%
Space Separator
ValueCountFrequency (%)
3653
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 214
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 15987
68.9%
Common 7213
31.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 2284
14.3%
제 2229
13.9%
도 1139
 
7.1%
자 1121
 
7.0%
시 1114
 
7.0%
별 1113
 
7.0%
치 1113
 
7.0%
특 1113
 
7.0%
로 816
 
5.1%
길 589
 
3.7%
Other values (172) 3356
21.0%
Common
ValueCountFrequency (%)
3653
50.6%
1 865
 
12.0%
2 432
 
6.0%
3 387
 
5.4%
4 332
 
4.6%
6 276
 
3.8%
5 261
 
3.6%
- 214
 
3.0%
0 214
 
3.0%
7 212
 
2.9%
Other values (2) 367
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 15987
68.9%
ASCII 7213
31.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3653
50.6%
1 865
 
12.0%
2 432
 
6.0%
3 387
 
5.4%
4 332
 
4.6%
6 276
 
3.8%
5 261
 
3.6%
- 214
 
3.0%
0 214
 
3.0%
7 212
 
2.9%
Other values (2) 367
 
5.1%
Hangul
ValueCountFrequency (%)
주 2284
14.3%
제 2229
13.9%
도 1139
 
7.1%
자 1121
 
7.0%
시 1114
 
7.0%
별 1113
 
7.0%
치 1113
 
7.0%
특 1113
 
7.0%
로 816
 
5.1%
길 589
 
3.7%
Other values (172) 3356
21.0%

지번주소
Text

Distinct911
Distinct (%)81.6%
Missing3
Missing (%)0.3%
Memory size8.9 KiB
2023-12-12T13:43:43.114211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length27
Mean length22.898836
Min length18

Characters and Unicode

Total characters25578
Distinct characters115
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

Unique834 ?
Unique (%)74.7%

Sample

1st row제주특별자치도 제주시 연동 1911-12
2nd row제주특별자치도 제주시 내도동 628-1
3rd row제주특별자치도 제주시 노형동 2860
4th row제주특별자치도 제주시 노형동 1051-4
5th row제주특별자치도 제주시 연동 2420
ValueCountFrequency (%)
제주특별자치도 1117
23.4%
제주시 1117
23.4%
노형동 127
 
2.7%
이도일동 82
 
1.7%
애월읍 81
 
1.7%
일도이동 75
 
1.6%
한림읍 74
 
1.5%
연동 70
 
1.5%
조천읍 65
 
1.4%
이도이동 63
 
1.3%
Other values (997) 1908
39.9%
2023-12-12T13:43:43.677297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3674
14.4%
제 2234
 
8.7%
주 2234
 
8.7%
도 1511
 
5.9%
1 1209
 
4.7%
자 1122
 
4.4%
특 1117
 
4.4%
별 1117
 
4.4%
치 1117
 
4.4%
시 1117
 
4.4%
Other values (105) 9126
35.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 15928
62.3%
Decimal Number 5095
 
19.9%
Space Separator 3674
 
14.4%
Dash Punctuation 881
 
3.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 2234
14.0%
주 2234
14.0%
도 1511
9.5%
자 1122
 
7.0%
특 1117
 
7.0%
별 1117
 
7.0%
치 1117
 
7.0%
시 1117
 
7.0%
동 816
 
5.1%
일 404
 
2.5%
Other values (93) 3139
19.7%
Decimal Number
ValueCountFrequency (%)
1 1209
23.7%
2 725
14.2%
3 510
10.0%
4 454
 
8.9%
9 446
 
8.8%
6 405
 
7.9%
5 371
 
7.3%
7 346
 
6.8%
0 344
 
6.8%
8 285
 
5.6%
Space Separator
ValueCountFrequency (%)
3674
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 881
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 15928
62.3%
Common 9650
37.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 2234
14.0%
주 2234
14.0%
도 1511
9.5%
자 1122
 
7.0%
특 1117
 
7.0%
별 1117
 
7.0%
치 1117
 
7.0%
시 1117
 
7.0%
동 816
 
5.1%
일 404
 
2.5%
Other values (93) 3139
19.7%
Common
ValueCountFrequency (%)
3674
38.1%
1 1209
 
12.5%
- 881
 
9.1%
2 725
 
7.5%
3 510
 
5.3%
4 454
 
4.7%
9 446
 
4.6%
6 405
 
4.2%
5 371
 
3.8%
7 346
 
3.6%
Other values (2) 629
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 15928
62.3%
ASCII 9650
37.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3674
38.1%
1 1209
 
12.5%
- 881
 
9.1%
2 725
 
7.5%
3 510
 
5.3%
4 454
 
4.7%
9 446
 
4.6%
6 405
 
4.2%
5 371
 
3.8%
7 346
 
3.6%
Other values (2) 629
 
6.5%
Hangul
ValueCountFrequency (%)
제 2234
14.0%
주 2234
14.0%
도 1511
9.5%
자 1122
 
7.0%
특 1117
 
7.0%
별 1117
 
7.0%
치 1117
 
7.0%
시 1117
 
7.0%
동 816
 
5.1%
일 404
 
2.5%
Other values (93) 3139
19.7%

전화번호
Text

MISSING 

Distinct574
Distinct (%)94.9%
Missing515
Missing (%)46.0%
Memory size8.9 KiB
2023-12-12T13:43:44.059304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.001653
Min length9

Characters and Unicode

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

Unique555 ?
Unique (%)91.7%

Sample

1st row064-712-7070
2nd row064-726-6900
3rd row064-726-6900
4th row064-726-6900
5th row064-726-6900
ValueCountFrequency (%)
064-729-1551 8
 
1.3%
064-798-1053 5
 
0.8%
064-726-6900 5
 
0.8%
064-784-0111 2
 
0.3%
064-755-1426 2
 
0.3%
064-758-9458 2
 
0.3%
064-745-8118 2
 
0.3%
064-798-2530 2
 
0.3%
064-723-9000 2
 
0.3%
064-722-7899 2
 
0.3%
Other values (564) 573
94.7%
2023-12-12T13:43:44.679597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 1209
16.7%
0 1042
14.4%
4 976
13.4%
7 885
12.2%
6 877
12.1%
2 491
6.8%
5 451
 
6.2%
8 338
 
4.7%
1 336
 
4.6%
9 332
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 6052
83.3%
Dash Punctuation 1209
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1042
17.2%
4 976
16.1%
7 885
14.6%
6 877
14.5%
2 491
8.1%
5 451
7.5%
8 338
 
5.6%
1 336
 
5.6%
9 332
 
5.5%
3 324
 
5.4%
Dash Punctuation
ValueCountFrequency (%)
- 1209
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 7261
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 1209
16.7%
0 1042
14.4%
4 976
13.4%
7 885
12.2%
6 877
12.1%
2 491
6.8%
5 451
 
6.2%
8 338
 
4.7%
1 336
 
4.6%
9 332
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7261
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 1209
16.7%
0 1042
14.4%
4 976
13.4%
7 885
12.2%
6 877
12.1%
2 491
6.8%
5 451
 
6.2%
8 338
 
4.7%
1 336
 
4.6%
9 332
 
4.6%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
2021-02-26
1120 

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

Length

2023-12-12T13:43:44.883111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:43:45.029560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02-26 1120
100.0%

Missing values

2023-12-12T13:43:39.476681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:43:39.595825image/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-12T13:43:40.075742image/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즉석판매제조가공업(주고려바이오홍삼 제주지점제주특별자치도 제주시 연삼로 3제주특별자치도 제주시 연동 1911-12<NA>2021-02-26
1즉석판매제조가공업(주나베식품제주특별자치도 제주시 일주서로 7427제주특별자치도 제주시 내도동 628-1<NA>2021-02-26
2즉석판매제조가공업(주농협홍삼제주시농협하나로유통센터점제주특별자치도 제주시 월광로 77제주특별자치도 제주시 노형동 2860<NA>2021-02-26
3즉석판매제조가공업(주뉴월드마트로노형점제주특별자치도 제주시 월랑로10길 14제주특별자치도 제주시 노형동 1051-4064-712-70702021-02-26
4즉석판매제조가공업(주뉴월드마트로연동점제주특별자치도 제주시 일주서로 7822제주특별자치도 제주시 연동 2420064-726-69002021-02-26
5즉석판매제조가공업(주뉴월드마트로원노형점제주특별자치도 제주시 연북로 15제주특별자치도 제주시 노형동 710064-726-69002021-02-26
6즉석판매제조가공업(주뉴월드마트로탑동점제주특별자치도 제주시 중앙로 13제주특별자치도 제주시 건입동 1441064-726-69002021-02-26
7즉석판매제조가공업(주뉴월드마트화북점제주특별자치도 제주시 일주동로 233제주특별자치도 제주시 화북일동 1244-1064-726-69002021-02-26
8즉석판매제조가공업(주뉴월드서사라점제주특별자치도 제주시 평전1길 6제주특별자치도 제주시 삼도일동 520064-721-46012021-02-26
9즉석판매제조가공업(주뉴월드이도1호점제주특별자치도 제주시 승천로 63제주특별자치도 제주시 아라이동 3001-5064-744-46002021-02-26
업종명업소명도로명주소지번주소전화번호데이터기준일자
1110즉석판매제조가공업효미농원제주특별자치도 제주시 구좌읍 덕평로 77제주특별자치도 제주시 구좌읍 덕천리 1033064-784-55422021-02-26
1111즉석판매제조가공업효민맘반찬스토어제주특별자치도 제주시 연화로1길 15제주특별자치도 제주시 연동 1496064-747-33342021-02-26
1112즉석판매제조가공업효창수산제주특별자치도 제주시 임항로 37-2제주특별자치도 제주시 건입동 1319-129<NA>2021-02-26
1113즉석판매제조가공업훈이식육점제주특별자치도 제주시 서사로 78제주특별자치도 제주시 삼도일동 787-5064-755-26862021-02-26
1114즉석판매제조가공업흑돈사랑직매장(신촌점제주특별자치도 제주시 조천읍 신북로 95제주특별자치도 제주시 조천읍 신촌리 539-1<NA>2021-02-26
1115즉석판매제조가공업흑돼지가있는풍경노형점제주특별자치도 제주시 진군1길 27제주특별자치도 제주시 노형동 735-7<NA>2021-02-26
1116즉석판매제조가공업흙내음제주특별자치도 제주시 중앙로 415제주특별자치도 제주시 아라이동 2423<NA>2021-02-26
1117즉석판매제조가공업흥부상회제주특별자치도 제주시 성신북길 36제주특별자치도 제주시 연동 2303-7<NA>2021-02-26
1118즉석판매제조가공업힐링건강샵제주특별자치도 제주시 월대4길 5제주특별자치도 제주시 외도이동 250-17<NA>2021-02-26
1119즉석판매제조가공업힐링푸드반찬전문점제주특별자치도 제주시 월랑로2길 22제주특별자치도 제주시 노형동 1295-6064-712-11392021-02-26

Duplicate rows

Most frequently occurring

업종명업소명도로명주소지번주소전화번호데이터기준일자# duplicates
0즉석판매제조가공업원이원유통제주특별자치도 제주시 월광로 77제주특별자치도 제주시 노형동 2860<NA>2021-02-263
1즉석판매제조가공업한국생식품연합제주특별자치도 제주시 애월읍 일주서로 7136제주특별자치도 제주시 애월읍 하귀1리 190-1<NA>2021-02-262