Overview

Dataset statistics

Number of variables8
Number of observations140
Missing cells69
Missing cells (%)6.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.9 KiB
Average record size in memory64.9 B

Variable types

Categorical2
DateTime3
Text3

Dataset

Description경기도 여주시 관내 식품위생업 중 건강기능식품 일반판매업과 유통전문판매업에 대한 현황(업종명, 인허가일자, 업소명, 소재지, 소재지전화, 영업자시작일, 소재지시작일, 업태명)정보를 제공합니다.
Author경기도 여주시
URLhttps://www.data.go.kr/data/15038593/fileData.do

Alerts

업태명 is highly overall correlated with 업종명High correlation
업종명 is highly overall correlated with 업태명High correlation
업종명 is highly imbalanced (77.8%)Imbalance
소재지전화 has 69 (49.3%) missing valuesMissing

Reproduction

Analysis started2023-12-12 13:19:05.925199
Analysis finished2023-12-12 13:19:06.628456
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
건강기능식품일반판매업
135 
건강기능식품유통전문판매업
 
5

Length

Max length13
Median length11
Mean length11.071429
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row건강기능식품일반판매업
2nd row건강기능식품일반판매업
3rd row건강기능식품일반판매업
4th row건강기능식품일반판매업
5th row건강기능식품일반판매업

Common Values

ValueCountFrequency (%)
건강기능식품일반판매업 135
96.4%
건강기능식품유통전문판매업 5
 
3.6%

Length

2023-12-12T22:19:06.725614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:19:06.865435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건강기능식품일반판매업 135
96.4%
건강기능식품유통전문판매업 5
 
3.6%

인허가일자
Date

Distinct126
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2004-06-05 00:00:00
Maximum2021-07-05 00:00:00
2023-12-12T22:19:07.010373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:19:07.190769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업소명
Text

Distinct136
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T22:19:07.508279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length16
Mean length7.4214286
Min length2

Characters and Unicode

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

Unique

Unique132 ?
Unique (%)94.3%

Sample

1st row여주특약점
2nd row정관장 여주점
3rd row여주축협하나로마트
4th row여주농협하나로마트
5th row뉴트리
ValueCountFrequency (%)
주식회사 5
 
2.6%
여주점 4
 
2.1%
네이처컬렉션 3
 
1.6%
애터미 3
 
1.6%
밀성양봉원 2
 
1.0%
쁘띠로제 2
 
1.0%
여주 2
 
1.0%
gs25 2
 
1.0%
여주지사 2
 
1.0%
이마트 2
 
1.0%
Other values (161) 164
85.9%
2023-12-12T22:19:08.035658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
51
 
4.9%
주 51
 
4.9%
여 36
 
3.5%
이 28
 
2.7%
점 25
 
2.4%
트 20
 
1.9%
마 20
 
1.9%
리 20
 
1.9%
스 16
 
1.5%
) 15
 
1.4%
Other values (289) 757
72.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 884
85.1%
Space Separator 51
 
4.9%
Decimal Number 25
 
2.4%
Uppercase Letter 24
 
2.3%
Lowercase Letter 22
 
2.1%
Close Punctuation 15
 
1.4%
Open Punctuation 15
 
1.4%
Dash Punctuation 1
 
0.1%
Other Punctuation 1
 
0.1%
Letter Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 51
 
5.8%
여 36
 
4.1%
이 28
 
3.2%
점 25
 
2.8%
트 20
 
2.3%
마 20
 
2.3%
리 20
 
2.3%
스 16
 
1.8%
사 14
 
1.6%
원 14
 
1.6%
Other values (247) 640
72.4%
Uppercase Letter
ValueCountFrequency (%)
S 4
16.7%
M 3
12.5%
G 3
12.5%
C 3
12.5%
B 2
8.3%
O 2
8.3%
P 1
 
4.2%
R 1
 
4.2%
E 1
 
4.2%
A 1
 
4.2%
Other values (3) 3
12.5%
Lowercase Letter
ValueCountFrequency (%)
y 3
13.6%
o 3
13.6%
a 2
9.1%
s 2
9.1%
n 2
9.1%
e 2
9.1%
d 2
9.1%
p 1
 
4.5%
l 1
 
4.5%
c 1
 
4.5%
Other values (3) 3
13.6%
Decimal Number
ValueCountFrequency (%)
1 6
24.0%
2 4
16.0%
5 4
16.0%
0 4
16.0%
8 2
 
8.0%
9 1
 
4.0%
7 1
 
4.0%
3 1
 
4.0%
6 1
 
4.0%
4 1
 
4.0%
Space Separator
ValueCountFrequency (%)
51
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 884
85.1%
Common 108
 
10.4%
Latin 47
 
4.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 51
 
5.8%
여 36
 
4.1%
이 28
 
3.2%
점 25
 
2.8%
트 20
 
2.3%
마 20
 
2.3%
리 20
 
2.3%
스 16
 
1.8%
사 14
 
1.6%
원 14
 
1.6%
Other values (247) 640
72.4%
Latin
ValueCountFrequency (%)
S 4
 
8.5%
M 3
 
6.4%
G 3
 
6.4%
C 3
 
6.4%
y 3
 
6.4%
o 3
 
6.4%
a 2
 
4.3%
B 2
 
4.3%
s 2
 
4.3%
n 2
 
4.3%
Other values (17) 20
42.6%
Common
ValueCountFrequency (%)
51
47.2%
) 15
 
13.9%
( 15
 
13.9%
1 6
 
5.6%
2 4
 
3.7%
5 4
 
3.7%
0 4
 
3.7%
8 2
 
1.9%
9 1
 
0.9%
7 1
 
0.9%
Other values (5) 5
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 884
85.1%
ASCII 154
 
14.8%
Number Forms 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
51
33.1%
) 15
 
9.7%
( 15
 
9.7%
1 6
 
3.9%
S 4
 
2.6%
2 4
 
2.6%
5 4
 
2.6%
0 4
 
2.6%
M 3
 
1.9%
G 3
 
1.9%
Other values (31) 45
29.2%
Hangul
ValueCountFrequency (%)
주 51
 
5.8%
여 36
 
4.1%
이 28
 
3.2%
점 25
 
2.8%
트 20
 
2.3%
마 20
 
2.3%
리 20
 
2.3%
스 16
 
1.8%
사 14
 
1.6%
원 14
 
1.6%
Other values (247) 640
72.4%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

소재지
Text

Distinct136
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T22:19:08.450013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length37
Mean length24.985714
Min length14

Characters and Unicode

Total characters3498
Distinct characters163
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

Unique132 ?
Unique (%)94.3%

Sample

1st row경기도 여주시 소양로 105
2nd row경기도 여주시 여흥로109번길 1 (홍문동)
3rd row경기도 여주시 강변북로 50
4th row경기도 여주시 여흥로47번길 8-16
5th row경기도 여주시 여흥로47번길 18-9
ValueCountFrequency (%)
경기도 140
 
17.4%
여주시 140
 
17.4%
1층 23
 
2.9%
가남읍 19
 
2.4%
세종로 17
 
2.1%
2층 16
 
2.0%
홍문동 13
 
1.6%
하동 12
 
1.5%
대신면 11
 
1.4%
현암동 9
 
1.1%
Other values (268) 406
50.4%
2023-12-12T22:19:09.005771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
669
19.1%
여 178
 
5.1%
1 173
 
4.9%
주 151
 
4.3%
도 143
 
4.1%
경 142
 
4.1%
기 141
 
4.0%
시 140
 
4.0%
2 105
 
3.0%
로 103
 
2.9%
Other values (153) 1553
44.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1942
55.5%
Space Separator 669
 
19.1%
Decimal Number 621
 
17.8%
Other Punctuation 77
 
2.2%
Open Punctuation 72
 
2.1%
Close Punctuation 72
 
2.1%
Dash Punctuation 44
 
1.3%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
여 178
 
9.2%
주 151
 
7.8%
도 143
 
7.4%
경 142
 
7.3%
기 141
 
7.3%
시 140
 
7.2%
로 103
 
5.3%
동 93
 
4.8%
길 63
 
3.2%
층 45
 
2.3%
Other values (136) 743
38.3%
Decimal Number
ValueCountFrequency (%)
1 173
27.9%
2 105
16.9%
3 69
 
11.1%
4 57
 
9.2%
0 56
 
9.0%
5 55
 
8.9%
8 33
 
5.3%
7 25
 
4.0%
6 24
 
3.9%
9 24
 
3.9%
Other Punctuation
ValueCountFrequency (%)
, 76
98.7%
@ 1
 
1.3%
Space Separator
ValueCountFrequency (%)
669
100.0%
Open Punctuation
ValueCountFrequency (%)
( 72
100.0%
Close Punctuation
ValueCountFrequency (%)
) 72
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1942
55.5%
Common 1555
44.5%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
여 178
 
9.2%
주 151
 
7.8%
도 143
 
7.4%
경 142
 
7.3%
기 141
 
7.3%
시 140
 
7.2%
로 103
 
5.3%
동 93
 
4.8%
길 63
 
3.2%
층 45
 
2.3%
Other values (136) 743
38.3%
Common
ValueCountFrequency (%)
669
43.0%
1 173
 
11.1%
2 105
 
6.8%
, 76
 
4.9%
( 72
 
4.6%
) 72
 
4.6%
3 69
 
4.4%
4 57
 
3.7%
0 56
 
3.6%
5 55
 
3.5%
Other values (6) 151
 
9.7%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1942
55.5%
ASCII 1556
44.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
669
43.0%
1 173
 
11.1%
2 105
 
6.7%
, 76
 
4.9%
( 72
 
4.6%
) 72
 
4.6%
3 69
 
4.4%
4 57
 
3.7%
0 56
 
3.6%
5 55
 
3.5%
Other values (7) 152
 
9.8%
Hangul
ValueCountFrequency (%)
여 178
 
9.2%
주 151
 
7.8%
도 143
 
7.4%
경 142
 
7.3%
기 141
 
7.3%
시 140
 
7.2%
로 103
 
5.3%
동 93
 
4.8%
길 63
 
3.2%
층 45
 
2.3%
Other values (136) 743
38.3%

소재지전화
Text

MISSING 

Distinct67
Distinct (%)94.4%
Missing69
Missing (%)49.3%
Memory size1.2 KiB
2023-12-12T22:19:09.310468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12
Min length11

Characters and Unicode

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

Unique63 ?
Unique (%)88.7%

Sample

1st row031-882-1176
2nd row031-885-0385
3rd row031-886-2471
4th row031-883-3045
5th row031-883-3611
ValueCountFrequency (%)
031-883-7362 2
 
2.8%
031-798-5990 2
 
2.8%
031-882-1176 2
 
2.8%
031-883-0303 2
 
2.8%
031-886-9420 1
 
1.4%
031-880-7770 1
 
1.4%
031-884-9025 1
 
1.4%
031-883-8575 1
 
1.4%
031-885-1000 1
 
1.4%
031-884-5290 1
 
1.4%
Other values (57) 57
80.3%
2023-12-12T22:19:09.793138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8 148
17.4%
- 142
16.7%
0 115
13.5%
3 115
13.5%
1 99
11.6%
5 52
 
6.1%
6 47
 
5.5%
2 44
 
5.2%
7 34
 
4.0%
4 30
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 710
83.3%
Dash Punctuation 142
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 148
20.8%
0 115
16.2%
3 115
16.2%
1 99
13.9%
5 52
 
7.3%
6 47
 
6.6%
2 44
 
6.2%
7 34
 
4.8%
4 30
 
4.2%
9 26
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 142
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 852
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
8 148
17.4%
- 142
16.7%
0 115
13.5%
3 115
13.5%
1 99
11.6%
5 52
 
6.1%
6 47
 
5.5%
2 44
 
5.2%
7 34
 
4.0%
4 30
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 852
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8 148
17.4%
- 142
16.7%
0 115
13.5%
3 115
13.5%
1 99
11.6%
5 52
 
6.1%
6 47
 
5.5%
2 44
 
5.2%
7 34
 
4.0%
4 30
 
3.5%

영업자시작일
Date

Distinct128
Distinct (%)91.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2004-06-05 00:00:00
Maximum2021-07-16 00:00:00
2023-12-12T22:19:09.954360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:19:10.133909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

소재지시작일
Date

Distinct127
Distinct (%)90.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2004-06-05 00:00:00
Maximum2021-07-05 00:00:00
2023-12-12T22:19:10.311542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:19:10.491979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업태명
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
영업장판매
65 
전자상거래(통신판매업)
40 
방문판매
20 
건강기능식품유통전문판매업
 
5
통신판매
 
3
Other values (4)
7 

Length

Max length13
Median length12
Mean length7.2
Min length4

Unique

Unique2 ?
Unique (%)1.4%

Sample

1st row방문판매
2nd row영업장판매
3rd row영업장판매
4th row영업장판매
5th row방문판매

Common Values

ValueCountFrequency (%)
영업장판매 65
46.4%
전자상거래(통신판매업) 40
28.6%
방문판매 20
 
14.3%
건강기능식품유통전문판매업 5
 
3.6%
통신판매 3
 
2.1%
도매업(유통) 3
 
2.1%
전화권유판매 2
 
1.4%
다단계판매 1
 
0.7%
기타(복합 등) 1
 
0.7%

Length

2023-12-12T22:19:10.990272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:19:11.124828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업장판매 65
46.1%
전자상거래(통신판매업 40
28.4%
방문판매 20
 
14.2%
건강기능식품유통전문판매업 5
 
3.5%
통신판매 3
 
2.1%
도매업(유통 3
 
2.1%
전화권유판매 2
 
1.4%
다단계판매 1
 
0.7%
기타(복합 1
 
0.7%
등 1
 
0.7%

Correlations

2023-12-12T22:19:11.234977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종명소재지전화업태명
업종명1.0000.0001.000
소재지전화0.0001.0000.000
업태명1.0000.0001.000
2023-12-12T22:19:11.347273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업태명업종명
업태명1.0000.974
업종명0.9741.000
2023-12-12T22:19:11.456893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종명업태명
업종명1.0000.974
업태명0.9741.000

Missing values

2023-12-12T22:19:06.425657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:19:06.563339image/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건강기능식품일반판매업2004-06-05여주특약점경기도 여주시 소양로 105031-882-11762004-06-052004-06-05방문판매
1건강기능식품일반판매업2004-06-10정관장 여주점경기도 여주시 여흥로109번길 1 (홍문동)031-885-03852021-07-162004-06-10영업장판매
2건강기능식품일반판매업2004-06-11여주축협하나로마트경기도 여주시 강변북로 50031-886-24712019-04-152012-04-19영업장판매
3건강기능식품일반판매업2004-06-09여주농협하나로마트경기도 여주시 여흥로47번길 8-16031-883-30452019-04-162008-12-22영업장판매
4건강기능식품일반판매업2004-06-18뉴트리경기도 여주시 여흥로47번길 18-9<NA>2004-06-182004-06-18방문판매
5건강기능식품일반판매업2004-06-18대신농협 하나로마트경기도 여주시 대신면 여양로 1540, 대신농협 하나로마트031-883-36112018-08-282018-08-29영업장판매
6건강기능식품일반판매업2004-06-18흥천농협경기도 여주시 흥천면 효자로 145031-882-03312006-12-132004-06-18영업장판매
7건강기능식품일반판매업2004-06-16다애메디칼경기도 여주시 대신면 여양로 1421031-882-76362004-06-162004-06-16영업장판매
8건강기능식품일반판매업2004-06-21금사농업협동조합경기도 여주시 금사면 이포로 25<NA>2020-12-032004-06-21영업장판매
9건강기능식품일반판매업2004-06-21씽킹빅경기도 여주시 여흥로4번길 31-5, 삼성가빌 301호 (하동)<NA>2010-08-132019-11-29다단계판매
업종명인허가일자업소명소재지소재지전화영업자시작일소재지시작일업태명
130건강기능식품일반판매업2021-05-24베스트제이몰경기도 여주시 강천면 곱새기로 32-12<NA>2021-05-242021-05-24전자상거래(통신판매업)
131건강기능식품일반판매업2021-06-22코리아나뷰티센터 여주지점경기도 여주시 여흥로 141 (상동)<NA>2021-06-222021-06-22방문판매
132건강기능식품일반판매업2021-06-22내맘에콕경기도 여주시 세종로 255, 101동 702호 (교동, 삼성명가타운아파트)<NA>2021-06-222021-06-22전자상거래(통신판매업)
133건강기능식품일반판매업2021-06-22894플러스경기도 여주시 능서면 중부대로2703번길 49, 1층<NA>2021-06-222021-06-22전자상거래(통신판매업)
134건강기능식품일반판매업2021-07-05아이디어클라우드경기도 여주시 웅골로 84-2, 레드힐 207호 (점봉동)<NA>2021-07-052021-07-05전자상거래(통신판매업)
135건강기능식품유통전문판매업2005-12-22금사식품경기도 여주시 금사면 점뜰길 16-4031-885-01582005-12-222007-02-01건강기능식품유통전문판매업
136건강기능식품유통전문판매업2006-01-24밀성양봉원경기도 여주시 산북면 주어1길 25-12031-883-73622016-11-092006-01-24건강기능식품유통전문판매업
137건강기능식품유통전문판매업2018-02-26코카콜라음료(주)경기도 여주시 세종로 415, 코카콜라여주공장 (점봉동)031-880-20802019-04-032018-02-26건강기능식품유통전문판매업
138건강기능식품유통전문판매업2018-09-12비에스팜 주식회사경기도 여주시 가남읍 연삼로 284, 1동 2층031-798-59902021-06-012019-05-27건강기능식품유통전문판매업
139건강기능식품유통전문판매업2020-08-20쁘띠로제경기도 여주시 흥천면 신촌동길 52-1<NA>2020-08-202020-10-15건강기능식품유통전문판매업