Overview

Dataset statistics

Number of variables8
Number of observations119
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.6 KiB
Average record size in memory65.1 B

Variable types

Text2
Categorical6

Dataset

Description국립농산물품질관리원에서 관리하는 농산물 원산지 인증정보(인증번호, 최초인증일, 인증유효기간, 인증업체명, 제품명, 원산지, 비율, 인증기관)
Author국립농산물품질관리원
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20220609000000002101

Alerts

최초인증일자 is highly overall correlated with 인증유효기간 and 4 other fieldsHigh correlation
인증업체명 is highly overall correlated with 최초인증일자 and 4 other fieldsHigh correlation
인증유효기간 is highly overall correlated with 최초인증일자 and 4 other fieldsHigh correlation
원산지 is highly overall correlated with 최초인증일자 and 3 other fieldsHigh correlation
비율 is highly overall correlated with 최초인증일자 and 2 other fieldsHigh correlation
인증기관 is highly overall correlated with 최초인증일자 and 3 other fieldsHigh correlation
원산지 is highly imbalanced (67.2%)Imbalance
인증번호 has unique valuesUnique

Reproduction

Analysis started2024-03-23 07:49:12.876843
Analysis finished2024-03-23 07:49:14.345597
Duration1.47 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

인증번호
Text

UNIQUE 

Distinct119
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-03-23T07:49:14.728260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.02521
Min length10

Characters and Unicode

Total characters1431
Distinct characters22
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

Unique119 ?
Unique (%)100.0%

Sample

1st row푸름 원산지 제1호
2nd row푸름 원산지 제2호
3rd row푸름 원산지 제3호
4th row푸름 원산지 제4호
5th row푸름 원산지 제5호
ValueCountFrequency (%)
원산지 119
33.3%
식품연 85
23.8%
푸름 31
 
8.7%
한식연 3
 
0.8%
제31호 2
 
0.6%
제69호 1
 
0.3%
제70호 1
 
0.3%
제163호 1
 
0.3%
제162호 1
 
0.3%
제161호 1
 
0.3%
Other values (112) 112
31.4%
2024-03-23T07:49:15.639879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
238
16.6%
호 119
8.3%
원 119
8.3%
산 119
8.3%
지 119
8.3%
제 119
8.3%
연 88
 
6.1%
식 88
 
6.1%
품 85
 
5.9%
1 66
 
4.6%
Other values (12) 271
18.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 921
64.4%
Decimal Number 272
 
19.0%
Space Separator 238
 
16.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
호 119
12.9%
원 119
12.9%
산 119
12.9%
지 119
12.9%
제 119
12.9%
연 88
9.6%
식 88
9.6%
품 85
9.2%
름 31
 
3.4%
푸 31
 
3.4%
Decimal Number
ValueCountFrequency (%)
1 66
24.3%
6 31
11.4%
7 31
11.4%
8 26
 
9.6%
5 23
 
8.5%
2 22
 
8.1%
4 22
 
8.1%
3 21
 
7.7%
9 17
 
6.2%
0 13
 
4.8%
Space Separator
ValueCountFrequency (%)
238
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 921
64.4%
Common 510
35.6%

Most frequent character per script

Common
ValueCountFrequency (%)
238
46.7%
1 66
 
12.9%
6 31
 
6.1%
7 31
 
6.1%
8 26
 
5.1%
5 23
 
4.5%
2 22
 
4.3%
4 22
 
4.3%
3 21
 
4.1%
9 17
 
3.3%
Hangul
ValueCountFrequency (%)
호 119
12.9%
원 119
12.9%
산 119
12.9%
지 119
12.9%
제 119
12.9%
연 88
9.6%
식 88
9.6%
품 85
9.2%
름 31
 
3.4%
푸 31
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 921
64.4%
ASCII 510
35.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
238
46.7%
1 66
 
12.9%
6 31
 
6.1%
7 31
 
6.1%
8 26
 
5.1%
5 23
 
4.5%
2 22
 
4.3%
4 22
 
4.3%
3 21
 
4.1%
9 17
 
3.3%
Hangul
ValueCountFrequency (%)
호 119
12.9%
원 119
12.9%
산 119
12.9%
지 119
12.9%
제 119
12.9%
연 88
9.6%
식 88
9.6%
품 85
9.2%
름 31
 
3.4%
푸 31
 
3.4%

최초인증일자
Categorical

HIGH CORRELATION 

Distinct29
Distinct (%)24.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2019-12-09
27 
2018-12-18
18 
2021-02-08
11 
2023-02-25
7 
2021-07-12
6 
Other values (24)
50 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique11 ?
Unique (%)9.2%

Sample

1st row2021-05-27
2nd row2021-07-12
3rd row2021-07-12
4th row2021-08-02
5th row2021-08-02

Common Values

ValueCountFrequency (%)
2019-12-09 27
22.7%
2018-12-18 18
15.1%
2021-02-08 11
 
9.2%
2023-02-25 7
 
5.9%
2021-07-12 6
 
5.0%
2022-07-28 5
 
4.2%
2020-11-09 5
 
4.2%
2021-11-22 4
 
3.4%
2022-02-25 3
 
2.5%
2021-08-02 3
 
2.5%
Other values (19) 30
25.2%

Length

2024-03-23T07:49:16.048554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2019-12-09 27
22.7%
2018-12-18 18
15.1%
2021-02-08 11
 
9.2%
2023-02-25 7
 
5.9%
2021-07-12 6
 
5.0%
2022-07-28 5
 
4.2%
2020-11-09 5
 
4.2%
2021-11-22 4
 
3.4%
2022-02-25 3
 
2.5%
2021-08-02 3
 
2.5%
Other values (19) 30
25.2%

인증유효기간
Categorical

HIGH CORRELATION 

Distinct29
Distinct (%)24.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2022-12-08
27 
2024-12-17
18 
2024-02-07
11 
2026-02-24
7 
2024-07-11
6 
Other values (24)
50 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique11 ?
Unique (%)9.2%

Sample

1st row2024-05-26
2nd row2024-07-11
3rd row2024-07-11
4th row2024-08-01
5th row2024-08-01

Common Values

ValueCountFrequency (%)
2022-12-08 27
22.7%
2024-12-17 18
15.1%
2024-02-07 11
 
9.2%
2026-02-24 7
 
5.9%
2024-07-11 6
 
5.0%
2025-07-27 5
 
4.2%
2023-11-08 5
 
4.2%
2024-11-21 4
 
3.4%
2025-02-24 3
 
2.5%
2024-08-01 3
 
2.5%
Other values (19) 30
25.2%

Length

2024-03-23T07:49:16.356200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-12-08 27
22.7%
2024-12-17 18
15.1%
2024-02-07 11
 
9.2%
2026-02-24 7
 
5.9%
2024-07-11 6
 
5.0%
2025-07-27 5
 
4.2%
2023-11-08 5
 
4.2%
2024-11-21 4
 
3.4%
2025-02-24 3
 
2.5%
2024-08-01 3
 
2.5%
Other values (19) 30
25.2%

인증업체명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)26.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
㈜농가식품
21 
서안동농협 풍산김치공장
18 
고삼농협 안성마춤 푸드센터
10 
㈜송원식품
9 
농업회사법인(주)영양F&S
 
5
Other values (26)
56 

Length

Max length21
Median length14
Mean length9.4453782
Min length3

Unique

Unique11 ?
Unique (%)9.2%

Sample

1st row농업회사법인 온샘㈜
2nd row태장고
3rd row태장고
4th row지보농협참기름가공공장
5th row지보농협참기름가공공장

Common Values

ValueCountFrequency (%)
㈜농가식품 21
17.6%
서안동농협 풍산김치공장 18
15.1%
고삼농협 안성마춤 푸드센터 10
 
8.4%
㈜송원식품 9
 
7.6%
농업회사법인(주)영양F&S 5
 
4.2%
태장고 5
 
4.2%
안동제비원전통식품 5
 
4.2%
농업회사법인 어울림(유) 4
 
3.4%
서일농원 4
 
3.4%
에버그린에버블루협동조합 3
 
2.5%
Other values (21) 35
29.4%

Length

2024-03-23T07:49:16.687735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
㈜농가식품 21
 
12.4%
풍산김치공장 18
 
10.6%
서안동농협 18
 
10.6%
고삼농협 10
 
5.9%
안성마춤 10
 
5.9%
푸드센터 10
 
5.9%
㈜송원식품 9
 
5.3%
농업회사법인 6
 
3.5%
농업회사법인(주)영양f&s 5
 
2.9%
태장고 5
 
2.9%
Other values (28) 58
34.1%

제품명
Text

Distinct114
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-03-23T07:49:17.204254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length19
Mean length8.1176471
Min length2

Characters and Unicode

Total characters966
Distinct characters205
Distinct categories6 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique109 ?
Unique (%)91.6%

Sample

1st row안동참마분말
2nd row새뜸된장
3rd row새뜸고추장
4th row참기름
5th row들기름
ValueCountFrequency (%)
고춧가루(고춧가루 4
 
2.5%
서분례명인 4
 
2.5%
좋은 3
 
1.9%
아주 3
 
1.9%
이혜정의 3
 
1.9%
구운요술콩 2
 
1.3%
청결고춧가루 2
 
1.3%
안동제비원 2
 
1.3%
시리얼 2
 
1.3%
들기름 2
 
1.3%
Other values (122) 130
82.8%
2024-03-23T07:49:18.096562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
고 41
 
4.2%
38
 
3.9%
가 35
 
3.6%
치 35
 
3.6%
김 34
 
3.5%
루 33
 
3.4%
춧 33
 
3.4%
기 25
 
2.6%
아 22
 
2.3%
한 19
 
2.0%
Other values (195) 651
67.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 890
92.1%
Space Separator 38
 
3.9%
Open Punctuation 18
 
1.9%
Close Punctuation 17
 
1.8%
Lowercase Letter 2
 
0.2%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
고 41
 
4.6%
가 35
 
3.9%
치 35
 
3.9%
김 34
 
3.8%
루 33
 
3.7%
춧 33
 
3.7%
기 25
 
2.8%
아 22
 
2.5%
한 19
 
2.1%
삭 19
 
2.1%
Other values (189) 594
66.7%
Lowercase Letter
ValueCountFrequency (%)
e 1
50.0%
h 1
50.0%
Space Separator
ValueCountFrequency (%)
38
100.0%
Open Punctuation
ValueCountFrequency (%)
( 18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Uppercase Letter
ValueCountFrequency (%)
T 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 889
92.0%
Common 73
 
7.6%
Latin 3
 
0.3%
Han 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
고 41
 
4.6%
가 35
 
3.9%
치 35
 
3.9%
김 34
 
3.8%
루 33
 
3.7%
춧 33
 
3.7%
기 25
 
2.8%
아 22
 
2.5%
한 19
 
2.1%
삭 19
 
2.1%
Other values (188) 593
66.7%
Common
ValueCountFrequency (%)
38
52.1%
( 18
24.7%
) 17
23.3%
Latin
ValueCountFrequency (%)
e 1
33.3%
h 1
33.3%
T 1
33.3%
Han
ValueCountFrequency (%)
愛 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 889
92.0%
ASCII 76
 
7.9%
CJK 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
고 41
 
4.6%
가 35
 
3.9%
치 35
 
3.9%
김 34
 
3.8%
루 33
 
3.7%
춧 33
 
3.7%
기 25
 
2.8%
아 22
 
2.5%
한 19
 
2.1%
삭 19
 
2.1%
Other values (188) 593
66.7%
ASCII
ValueCountFrequency (%)
38
50.0%
( 18
23.7%
) 17
22.4%
e 1
 
1.3%
h 1
 
1.3%
T 1
 
1.3%
CJK
ValueCountFrequency (%)
愛 1
100.0%

원산지
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct13
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
국산
99 
건고추(한국산100%)
 
5
고추(한국산100%)
 
2
콩(한국산100%), 소금(한국산100%)
 
2
들깨(국산)
 
2
Other values (8)
 
9

Length

Max length23
Median length2
Mean length3.5798319
Min length2

Unique

Unique7 ?
Unique (%)5.9%

Sample

1st row국산
2nd row국산
3rd row국산
4th row국산
5th row국산

Common Values

ValueCountFrequency (%)
국산 99
83.2%
건고추(한국산100%) 5
 
4.2%
고추(한국산100%) 2
 
1.7%
콩(한국산100%), 소금(한국산100%) 2
 
1.7%
들깨(국산) 2
 
1.7%
참깨 한국산 100% 2
 
1.7%
고추(100%) 1
 
0.8%
콩(한국산100%) 1
 
0.8%
참깨(국산) 1
 
0.8%
건고추 / 한국산 1
 
0.8%
Other values (3) 3
 
2.5%

Length

2024-03-23T07:49:18.448636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
국산 99
74.4%
한국산 6
 
4.5%
건고추(한국산100 5
 
3.8%
콩(한국산100 3
 
2.3%
100 3
 
2.3%
건고추 3
 
2.3%
고추(한국산100 2
 
1.5%
소금(한국산100 2
 
1.5%
들깨(국산 2
 
1.5%
참깨 2
 
1.5%
Other values (5) 6
 
4.5%

비율
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
100%
74 
95%
45 

Length

Max length4
Median length4
Mean length3.6218487
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row100%
2nd row100%
3rd row100%
4th row100%
5th row100%

Common Values

ValueCountFrequency (%)
100% 74
62.2%
95% 45
37.8%

Length

2024-03-23T07:49:18.801489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T07:49:19.125591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 74
62.2%
95 45
37.8%

인증기관
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
한국식품연구원
88 
주식회사 푸름인증원
31 

Length

Max length10
Median length7
Mean length7.7815126
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주식회사 푸름인증원
2nd row주식회사 푸름인증원
3rd row주식회사 푸름인증원
4th row주식회사 푸름인증원
5th row주식회사 푸름인증원

Common Values

ValueCountFrequency (%)
한국식품연구원 88
73.9%
주식회사 푸름인증원 31
 
26.1%

Length

2024-03-23T07:49:19.503962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T07:49:19.817757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한국식품연구원 88
58.7%
주식회사 31
 
20.7%
푸름인증원 31
 
20.7%

Correlations

2024-03-23T07:49:20.012028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
최초인증일자인증유효기간인증업체명원산지비율인증기관
최초인증일자1.0001.0000.9970.9420.8810.980
인증유효기간1.0001.0000.9970.9420.8810.980
인증업체명0.9970.9971.0000.9290.9160.991
원산지0.9420.9420.9291.0000.1680.758
비율0.8810.8810.9160.1681.0000.632
인증기관0.9800.9800.9910.7580.6321.000
2024-03-23T07:49:20.292392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
최초인증일자인증업체명인증기관인증유효기간원산지비율
최초인증일자1.0000.9150.8431.0000.6210.705
인증업체명0.9151.0000.8540.9150.5730.734
인증기관0.8430.8541.0000.8430.6900.435
인증유효기간1.0000.9150.8431.0000.6210.705
원산지0.6210.5730.6900.6211.0000.146
비율0.7050.7340.4350.7050.1461.000
2024-03-23T07:49:20.570813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
최초인증일자인증유효기간인증업체명원산지비율인증기관
최초인증일자1.0001.0000.9150.6210.7050.843
인증유효기간1.0001.0000.9150.6210.7050.843
인증업체명0.9150.9151.0000.5730.7340.854
원산지0.6210.6210.5731.0000.1460.690
비율0.7050.7050.7340.1461.0000.435
인증기관0.8430.8430.8540.6900.4351.000

Missing values

2024-03-23T07:49:13.776134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T07:49:14.188368image/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푸름 원산지 제1호2021-05-272024-05-26농업회사법인 온샘㈜안동참마분말국산100%주식회사 푸름인증원
1푸름 원산지 제2호2021-07-122024-07-11태장고새뜸된장국산100%주식회사 푸름인증원
2푸름 원산지 제3호2021-07-122024-07-11태장고새뜸고추장국산100%주식회사 푸름인증원
3푸름 원산지 제4호2021-08-022024-08-01지보농협참기름가공공장참기름국산100%주식회사 푸름인증원
4푸름 원산지 제5호2021-08-022024-08-01지보농협참기름가공공장들기름국산100%주식회사 푸름인증원
5푸름 원산지 제6호2021-08-022024-08-01지보농협참기름가공공장볶음참깨국산100%주식회사 푸름인증원
6푸름 원산지 제7호2021-08-252024-08-24대풍년영농조합법인친정엄마꾸러미 요리 앤 고춧가루국산100%주식회사 푸름인증원
7푸름 원산지 제8호2021-11-222024-11-21농업회사법인 어울림(유)구운요술콩 백태국산100%주식회사 푸름인증원
8푸름 원산지 제9호2021-11-222024-11-21농업회사법인 어울림(유)구운요술콩 서리태국산100%주식회사 푸름인증원
9푸름 원산지 제10호2021-11-222024-11-21농업회사법인 어울림(유)위트밀 구운통곡물 시리얼국산100%주식회사 푸름인증원
인증번호최초인증일자인증유효기간인증업체명제품명원산지비율인증기관
109식품연 원산지 제186호2021-05-102024-05-09안면도농협고추가공공장안면도태양초고춧가루국산100%한국식품연구원
110식품연 원산지 제187호2021-06-142024-06-13맑은샘자연교육농원조금자채소잡곡국산100%한국식품연구원
111식품연 원산지 제188호2021-06-142024-06-13맑은샘자연교육농원조금자채소볼국산100%한국식품연구원
112식품연 원산지 제189호2021-07-122024-07-11서일농원서분례명인 청국장국산100%한국식품연구원
113식품연 원산지 제190호2021-07-122024-07-11서일농원서분례명인 매운청국장국산100%한국식품연구원
114식품연 원산지 제191호2021-07-122024-07-11서일농원서분례명인 마늘청국장국산100%한국식품연구원
115식품연 원산지 제192호2021-07-122024-07-11서일농원서분례명인 들깨청국장국산100%한국식품연구원
116한식연 원산지 제196호2023-04-102026-04-09㈜송원식품도라지배차국산100%한국식품연구원
117한식연 원산지 제197호2023-04-102026-04-09㈜송원식품돼지감자차국산100%한국식품연구원
118한식연 원산지 제201호2023-07-102026-07-09도미솔식품왕비포기김치국산95%한국식품연구원