Overview

Dataset statistics

Number of variables5
Number of observations114
Missing cells10
Missing cells (%)1.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.6 KiB
Average record size in memory41.2 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description제주특별자치도 제주시 식품관련업 관련 기타 식품 판매업 현황 데이터입니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056163/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 22:08:47.099063
Analysis finished2023-12-12 22:08:47.498615
Duration0.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
기타식품판매업
114 

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 (%)
기타식품판매업 114
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:08:47.691114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타식품판매업 114
100.0%

업소명
Text

UNIQUE 

Distinct114
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2023-12-13T07:08:47.943723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length14
Mean length7.6315789
Min length3

Characters and Unicode

Total characters870
Distinct characters177
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

Unique114 ?
Unique (%)100.0%

Sample

1st row제주시농협하나로클럽오라점
2nd row영어조합법인어민후계자수산물직판장
3rd row(주)이마트제주점
4th row나이스마트
5th row한국물류센타
ValueCountFrequency (%)
제주시농협하나로클럽오라점 1
 
0.9%
좋은마트 1
 
0.9%
김녕킹마트 1
 
0.9%
탐나마트인제점 1
 
0.9%
장보리마트 1
 
0.9%
탐나마트주공점 1
 
0.9%
주식회사제스코마트 1
 
0.9%
삼화마트 1
 
0.9%
유드림마트함덕점 1
 
0.9%
진일마트 1
 
0.9%
Other values (106) 106
91.4%
2023-12-13T07:08:48.410457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
트 88
 
10.1%
마 86
 
9.9%
점 40
 
4.6%
주 39
 
4.5%
제 24
 
2.8%
) 21
 
2.4%
( 20
 
2.3%
나 19
 
2.2%
로 19
 
2.2%
드 17
 
2.0%
Other values (167) 497
57.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 825
94.8%
Close Punctuation 21
 
2.4%
Open Punctuation 20
 
2.3%
Space Separator 2
 
0.2%
Decimal Number 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
트 88
 
10.7%
마 86
 
10.4%
점 40
 
4.8%
주 39
 
4.7%
제 24
 
2.9%
나 19
 
2.3%
로 19
 
2.3%
드 17
 
2.1%
협 16
 
1.9%
농 15
 
1.8%
Other values (162) 462
56.0%
Decimal Number
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 825
94.8%
Common 45
 
5.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
트 88
 
10.7%
마 86
 
10.4%
점 40
 
4.8%
주 39
 
4.7%
제 24
 
2.9%
나 19
 
2.3%
로 19
 
2.3%
드 17
 
2.1%
협 16
 
1.9%
농 15
 
1.8%
Other values (162) 462
56.0%
Common
ValueCountFrequency (%)
) 21
46.7%
( 20
44.4%
2
 
4.4%
1 1
 
2.2%
2 1
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 825
94.8%
ASCII 45
 
5.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
트 88
 
10.7%
마 86
 
10.4%
점 40
 
4.8%
주 39
 
4.7%
제 24
 
2.9%
나 19
 
2.3%
로 19
 
2.3%
드 17
 
2.1%
협 16
 
1.9%
농 15
 
1.8%
Other values (162) 462
56.0%
ASCII
ValueCountFrequency (%)
) 21
46.7%
( 20
44.4%
2
 
4.4%
1 1
 
2.2%
2 1
 
2.2%

소재지
Text

Distinct112
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2023-12-13T07:08:48.770782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length23
Mean length20.622807
Min length18

Characters and Unicode

Total characters2351
Distinct characters98
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

Unique110 ?
Unique (%)96.5%

Sample

1st row제주특별자치도 제주시 연삼로 113
2nd row제주특별자치도 제주시 연미길 10
3rd row제주특별자치도 제주시 탑동로 38
4th row제주특별자치도 제주시 남녕로 53
5th row제주특별자치도 제주시 우정로 33
ValueCountFrequency (%)
제주특별자치도 114
23.7%
제주시 114
23.7%
조천읍 7
 
1.5%
애월읍 6
 
1.2%
중앙로 5
 
1.0%
신북로 5
 
1.0%
구좌읍 5
 
1.0%
한림읍 4
 
0.8%
일주서로 4
 
0.8%
13 4
 
0.8%
Other values (168) 214
44.4%
2023-12-13T07:08:49.304743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
437
18.6%
주 235
 
10.0%
제 228
 
9.7%
도 117
 
5.0%
특 114
 
4.8%
별 114
 
4.8%
자 114
 
4.8%
치 114
 
4.8%
시 114
 
4.8%
로 92
 
3.9%
Other values (88) 672
28.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1602
68.1%
Space Separator 437
 
18.6%
Decimal Number 310
 
13.2%
Dash Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 235
14.7%
제 228
14.2%
도 117
 
7.3%
특 114
 
7.1%
별 114
 
7.1%
자 114
 
7.1%
치 114
 
7.1%
시 114
 
7.1%
로 92
 
5.7%
길 37
 
2.3%
Other values (76) 323
20.2%
Decimal Number
ValueCountFrequency (%)
1 78
25.2%
2 39
12.6%
4 36
11.6%
3 35
11.3%
6 28
 
9.0%
5 22
 
7.1%
0 21
 
6.8%
7 19
 
6.1%
8 19
 
6.1%
9 13
 
4.2%
Space Separator
ValueCountFrequency (%)
437
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1602
68.1%
Common 749
31.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 235
14.7%
제 228
14.2%
도 117
 
7.3%
특 114
 
7.1%
별 114
 
7.1%
자 114
 
7.1%
치 114
 
7.1%
시 114
 
7.1%
로 92
 
5.7%
길 37
 
2.3%
Other values (76) 323
20.2%
Common
ValueCountFrequency (%)
437
58.3%
1 78
 
10.4%
2 39
 
5.2%
4 36
 
4.8%
3 35
 
4.7%
6 28
 
3.7%
5 22
 
2.9%
0 21
 
2.8%
7 19
 
2.5%
8 19
 
2.5%
Other values (2) 15
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1602
68.1%
ASCII 749
31.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
437
58.3%
1 78
 
10.4%
2 39
 
5.2%
4 36
 
4.8%
3 35
 
4.7%
6 28
 
3.7%
5 22
 
2.9%
0 21
 
2.8%
7 19
 
2.5%
8 19
 
2.5%
Other values (2) 15
 
2.0%
Hangul
ValueCountFrequency (%)
주 235
14.7%
제 228
14.2%
도 117
 
7.3%
특 114
 
7.1%
별 114
 
7.1%
자 114
 
7.1%
치 114
 
7.1%
시 114
 
7.1%
로 92
 
5.7%
길 37
 
2.3%
Other values (76) 323
20.2%

전화번호
Text

MISSING 

Distinct100
Distinct (%)96.2%
Missing10
Missing (%)8.8%
Memory size1.0 KiB
2023-12-13T07:08:49.547238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique97 ?
Unique (%)93.3%

Sample

1st row064-747-6260
2nd row064-743-9333
3rd row064-729-1053
4th row064-747-9077
5th row064-747-9080
ValueCountFrequency (%)
064-726-6900 3
 
2.9%
064-724-8000 2
 
1.9%
064-729-1551 2
 
1.9%
064-740-9025 1
 
1.0%
064-780-8860 1
 
1.0%
064-725-0456 1
 
1.0%
064-747-9530 1
 
1.0%
064-758-0511 1
 
1.0%
064-773-2014 1
 
1.0%
064-799-0084 1
 
1.0%
Other values (90) 90
86.5%
2023-12-13T07:08:49.862929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 221
17.7%
- 208
16.7%
4 173
13.9%
6 154
12.3%
7 144
11.5%
2 76
 
6.1%
1 73
 
5.8%
5 58
 
4.6%
9 53
 
4.2%
8 51
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1040
83.3%
Dash Punctuation 208
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 221
21.2%
4 173
16.6%
6 154
14.8%
7 144
13.8%
2 76
 
7.3%
1 73
 
7.0%
5 58
 
5.6%
9 53
 
5.1%
8 51
 
4.9%
3 37
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 208
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1248
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 221
17.7%
- 208
16.7%
4 173
13.9%
6 154
12.3%
7 144
11.5%
2 76
 
6.1%
1 73
 
5.8%
5 58
 
4.6%
9 53
 
4.2%
8 51
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1248
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 221
17.7%
- 208
16.7%
4 173
13.9%
6 154
12.3%
7 144
11.5%
2 76
 
6.1%
1 73
 
5.8%
5 58
 
4.6%
9 53
 
4.2%
8 51
 
4.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
Minimum2021-02-26 00:00:00
Maximum2021-02-26 00:00:00
2023-12-13T07:08:49.972589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:08:50.050965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-13T07:08:47.335285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:08:47.455408image/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기타식품판매업제주시농협하나로클럽오라점제주특별자치도 제주시 연삼로 113064-747-62602021-02-26
1기타식품판매업영어조합법인어민후계자수산물직판장제주특별자치도 제주시 연미길 10064-743-93332021-02-26
2기타식품판매업(주)이마트제주점제주특별자치도 제주시 탑동로 38064-729-10532021-02-26
3기타식품판매업나이스마트제주특별자치도 제주시 남녕로 53064-747-90772021-02-26
4기타식품판매업한국물류센타제주특별자치도 제주시 우정로 33064-747-90802021-02-26
5기타식품판매업동부물류센타제주특별자치도 제주시 구좌읍 구좌로 16064-784-21122021-02-26
6기타식품판매업케이마트제주특별자치도 제주시 정존11길 36064-746-29972021-02-26
7기타식품판매업그린마트하귀점제주특별자치도 제주시 애월읍 하귀미수동길 14064-713-98762021-02-26
8기타식품판매업투다모아물류센타제주특별자치도 제주시 구좌읍 세화8길 2064-784-22272021-02-26
9기타식품판매업(주)뉴월드마트로일도점제주특별자치도 제주시 연수로3길 6064-751-46002021-02-26
업종명업소명소재지전화번호데이터기준일자
104기타식품판매업번영마트제주특별자치도 제주시 번영로 504064-725-42002021-02-26
105기타식품판매업참조은마트제주특별자치도 제주시 연오로 61064-745-45552021-02-26
106기타식품판매업노브랜드제주아라점제주특별자치도 제주시 구산로 27<NA>2021-02-26
107기타식품판매업탐나마트방선문점제주특별자치도 제주시 아란1길 34<NA>2021-02-26
108기타식품판매업대명홈마트제주특별자치도 제주시 조천읍 신북로 576<NA>2021-02-26
109기타식품판매업도남식자재마트제주특별자치도 제주시 고산동산서길 11-2<NA>2021-02-26
110기타식품판매업(주)조끄뜨레마트연동점제주특별자치도 제주시 국기로 33<NA>2021-02-26
111기타식품판매업(주)뉴월드마트로연동점제주특별자치도 제주시 일주서로 7822064-726-69002021-02-26
112기타식품판매업(주)뉴월드마트로원노형점제주특별자치도 제주시 연북로 15064-726-69002021-02-26
113기타식품판매업(주)뉴월드이도센트럴점제주특별자치도 제주시 중앙로 346064-726-69002021-02-26