Overview

Dataset statistics

Number of variables8
Number of observations109
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.9 KiB
Average record size in memory65.2 B

Variable types

Text3
Categorical2
DateTime3

Dataset

Description탁주, 약주, 청주, 과실주 등의 술 품질인증 관리 정보(인증번호, 인증기관, 인증업체, 품목명, 인증일자, 인증시작일, 인증종료일 등)
Author국립농산물품질관리원
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20220204000000001687

Alerts

인증기관 has constant value ""Constant
인증번호 has unique valuesUnique

Reproduction

Analysis started2024-03-23 07:55:33.369624
Analysis finished2024-03-23 07:55:35.227270
Duration1.86 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

인증번호
Text

UNIQUE 

Distinct109
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2024-03-23T07:55:35.558416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.4770642
Min length8

Characters and Unicode

Total characters1033
Distinct characters15
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

Unique109 ?
Unique (%)100.0%

Sample

1st row국가지정-가-1
2nd row국가지정-가-2
3rd row국가지정-가-4
4th row국가지정-가-5
5th row국가지정-가-6
ValueCountFrequency (%)
국가지정-가-1 1
 
0.9%
국가지정-가-105 1
 
0.9%
국가지정-가-130 1
 
0.9%
국가지정-가-129 1
 
0.9%
국가지정-가-128 1
 
0.9%
국가지정-가-127 1
 
0.9%
국가지정-가-126 1
 
0.9%
국가지정-가-125 1
 
0.9%
국가지정-가-124 1
 
0.9%
국가지정-가-123 1
 
0.9%
Other values (99) 99
90.8%
2024-03-23T07:55:36.551734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
218
21.1%
- 218
21.1%
109
10.6%
109
10.6%
109
10.6%
1 81
 
7.8%
5 27
 
2.6%
2 27
 
2.6%
4 26
 
2.5%
3 24
 
2.3%
Other values (5) 85
 
8.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 545
52.8%
Decimal Number 270
26.1%
Dash Punctuation 218
 
21.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 81
30.0%
5 27
 
10.0%
2 27
 
10.0%
4 26
 
9.6%
3 24
 
8.9%
7 21
 
7.8%
0 20
 
7.4%
8 16
 
5.9%
6 15
 
5.6%
9 13
 
4.8%
Other Letter
ValueCountFrequency (%)
218
40.0%
109
20.0%
109
20.0%
109
20.0%
Dash Punctuation
ValueCountFrequency (%)
- 218
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 545
52.8%
Common 488
47.2%

Most frequent character per script

Common
ValueCountFrequency (%)
- 218
44.7%
1 81
 
16.6%
5 27
 
5.5%
2 27
 
5.5%
4 26
 
5.3%
3 24
 
4.9%
7 21
 
4.3%
0 20
 
4.1%
8 16
 
3.3%
6 15
 
3.1%
Hangul
ValueCountFrequency (%)
218
40.0%
109
20.0%
109
20.0%
109
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 545
52.8%
ASCII 488
47.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
218
40.0%
109
20.0%
109
20.0%
109
20.0%
ASCII
ValueCountFrequency (%)
- 218
44.7%
1 81
 
16.6%
5 27
 
5.5%
2 27
 
5.5%
4 26
 
5.3%
3 24
 
4.9%
7 21
 
4.3%
0 20
 
4.1%
8 16
 
3.3%
6 15
 
3.1%

인증기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1004.0 B
한국식품연구원
109 

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 (%)
한국식품연구원 109
100.0%

Length

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

Common Values (Plot)

2024-03-23T07:55:37.327692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한국식품연구원 109
100.0%
Distinct62
Distinct (%)56.9%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2024-03-23T07:55:37.725381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length11
Mean length8.4587156
Min length2

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)33.0%

Sample

1st row(주)국순당(횡성공장)
2nd row(주)국순당(옥천공장)
3rd row서울장수주식회사
4th row서울장수주식회사
5th row구암농산
ValueCountFrequency (%)
농업회사법인 13
 
9.6%
주)조은술세종 6
 
4.4%
국순당여주명주 6
 
4.4%
주식회사 6
 
4.4%
서울장수주식회사 5
 
3.7%
주)화요 5
 
3.7%
동해명주 3
 
2.2%
안양주조2공장 3
 
2.2%
제주샘영농조합법인 3
 
2.2%
농업회사법인주식회사좋은술 3
 
2.2%
Other values (60) 82
60.7%
2024-03-23T07:55:38.513592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
95
 
10.3%
50
 
5.4%
40
 
4.3%
38
 
4.1%
37
 
4.0%
35
 
3.8%
( 34
 
3.7%
) 34
 
3.7%
32
 
3.5%
28
 
3.0%
Other values (117) 499
54.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 815
88.4%
Open Punctuation 34
 
3.7%
Close Punctuation 34
 
3.7%
Space Separator 26
 
2.8%
Decimal Number 10
 
1.1%
Uppercase Letter 2
 
0.2%
Other Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
95
 
11.7%
50
 
6.1%
40
 
4.9%
38
 
4.7%
37
 
4.5%
35
 
4.3%
32
 
3.9%
28
 
3.4%
20
 
2.5%
18
 
2.2%
Other values (107) 422
51.8%
Decimal Number
ValueCountFrequency (%)
2 6
60.0%
1 2
 
20.0%
9 1
 
10.0%
3 1
 
10.0%
Uppercase Letter
ValueCountFrequency (%)
L 1
50.0%
B 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 34
100.0%
Space Separator
ValueCountFrequency (%)
26
100.0%
Other Symbol
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 816
88.5%
Common 104
 
11.3%
Latin 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
95
 
11.6%
50
 
6.1%
40
 
4.9%
38
 
4.7%
37
 
4.5%
35
 
4.3%
32
 
3.9%
28
 
3.4%
20
 
2.5%
18
 
2.2%
Other values (108) 423
51.8%
Common
ValueCountFrequency (%)
( 34
32.7%
) 34
32.7%
26
25.0%
2 6
 
5.8%
1 2
 
1.9%
9 1
 
1.0%
3 1
 
1.0%
Latin
ValueCountFrequency (%)
L 1
50.0%
B 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 815
88.4%
ASCII 106
 
11.5%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
95
 
11.7%
50
 
6.1%
40
 
4.9%
38
 
4.7%
37
 
4.5%
35
 
4.3%
32
 
3.9%
28
 
3.4%
20
 
2.5%
18
 
2.2%
Other values (107) 422
51.8%
ASCII
ValueCountFrequency (%)
( 34
32.1%
) 34
32.1%
26
24.5%
2 6
 
5.7%
1 2
 
1.9%
9 1
 
0.9%
3 1
 
0.9%
L 1
 
0.9%
B 1
 
0.9%
None
ValueCountFrequency (%)
1
100.0%
Distinct60
Distinct (%)55.0%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2024-03-23T07:55:38.932030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters327
Distinct characters91
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)30.3%

Sample

1st row배중호
2nd row배중호
3rd row유재찬
4th row유재찬
5th row신현길
ValueCountFrequency (%)
박용구 6
 
5.5%
경기호 6
 
5.5%
조태권 5
 
4.6%
유재찬 5
 
4.6%
김숙희 3
 
2.8%
이예령 3
 
2.8%
정회철 3
 
2.8%
정태식 3
 
2.8%
채창윤 3
 
2.8%
유황철 3
 
2.8%
Other values (50) 69
63.3%
2024-03-23T07:55:39.775503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
17
 
5.2%
16
 
4.9%
16
 
4.9%
14
 
4.3%
13
 
4.0%
10
 
3.1%
9
 
2.8%
9
 
2.8%
8
 
2.4%
8
 
2.4%
Other values (81) 207
63.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 327
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
17
 
5.2%
16
 
4.9%
16
 
4.9%
14
 
4.3%
13
 
4.0%
10
 
3.1%
9
 
2.8%
9
 
2.8%
8
 
2.4%
8
 
2.4%
Other values (81) 207
63.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 327
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
17
 
5.2%
16
 
4.9%
16
 
4.9%
14
 
4.3%
13
 
4.0%
10
 
3.1%
9
 
2.8%
9
 
2.8%
8
 
2.4%
8
 
2.4%
Other values (81) 207
63.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 327
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
17
 
5.2%
16
 
4.9%
16
 
4.9%
14
 
4.3%
13
 
4.0%
10
 
3.1%
9
 
2.8%
9
 
2.8%
8
 
2.4%
8
 
2.4%
Other values (81) 207
63.3%

품목명
Categorical

Distinct7
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Memory size1004.0 B
탁주
48 
증류식소주
22 
약주
17 
살균탁주
과실주
Other values (2)

Length

Max length5
Median length2
Mean length2.9908257
Min length2

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row탁주
2nd row살균탁주
3rd row탁주
4th row살균탁주
5th row살균탁주

Common Values

ValueCountFrequency (%)
탁주 48
44.0%
증류식소주 22
20.2%
약주 17
 
15.6%
살균탁주 9
 
8.3%
과실주 7
 
6.4%
일반증류주 5
 
4.6%
기타주류 1
 
0.9%

Length

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

Common Values (Plot)

2024-03-23T07:55:40.643939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
탁주 48
44.0%
증류식소주 22
20.2%
약주 17
 
15.6%
살균탁주 9
 
8.3%
과실주 7
 
6.4%
일반증류주 5
 
4.6%
기타주류 1
 
0.9%
Distinct25
Distinct (%)22.9%
Missing0
Missing (%)0.0%
Memory size1004.0 B
Minimum2015-10-05 00:00:00
Maximum2018-06-20 00:00:00
2024-03-23T07:55:41.248796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:55:41.643203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
Distinct25
Distinct (%)22.9%
Missing0
Missing (%)0.0%
Memory size1004.0 B
Minimum2015-10-05 00:00:00
Maximum2018-07-20 00:00:00
2024-03-23T07:55:42.056837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:55:42.491825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
Distinct26
Distinct (%)23.9%
Missing0
Missing (%)0.0%
Memory size1004.0 B
Minimum2018-10-04 00:00:00
Maximum2021-06-19 00:00:00
2024-03-23T07:55:42.859790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:55:43.250834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

Correlations

2024-03-23T07:55:43.544037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
인증업체대표자명품목명인증일자인증시작일인증종료일
인증업체1.0001.0000.9600.9870.9890.987
대표자명1.0001.0000.9430.9820.9880.986
품목명0.9600.9431.0000.4260.3520.362
인증일자0.9870.9820.4261.0000.9990.995
인증시작일0.9890.9880.3520.9991.0000.995
인증종료일0.9870.9860.3620.9950.9951.000

Missing values

2024-03-23T07:55:34.649671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T07:55:35.076733image/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한국식품연구원(주)국순당(횡성공장)배중호탁주2017-03-182017-03-182020-03-17
1국가지정-가-2한국식품연구원(주)국순당(옥천공장)배중호살균탁주2017-03-182017-03-182020-03-17
2국가지정-가-4한국식품연구원서울장수주식회사유재찬탁주2017-03-182017-03-182020-03-17
3국가지정-가-5한국식품연구원서울장수주식회사유재찬살균탁주2017-03-182017-03-182020-03-17
4국가지정-가-6한국식품연구원구암농산신현길살균탁주2017-03-182017-03-182020-03-17
5국가지정-가-12한국식품연구원(주)성광주조성기욱탁주2017-06-022017-06-022020-06-01
6국가지정-가-14한국식품연구원울산탁주김홍수탁주2017-04-182017-04-182020-04-17
7국가지정-가-18한국식품연구원신평양조장 영농조합법인김동교탁주2017-05-232017-05-232020-05-22
8국가지정-가-19한국식품연구원동진합동주조장정태식살균탁주2017-05-232018-07-062020-05-22
9국가지정-가-20한국식품연구원동진합동주조장정테식살균탁주2017-05-232018-07-062020-05-22
인증번호인증기관인증업체대표자명품목명인증일자인증시작일인증종료일
99국가지정-가-149한국식품연구원(주)조은술세종경기호증류식소주2017-09-142017-09-142021-01-25
100국가지정-가-150한국식품연구원(주)조은술세종경기호증류식소주2017-09-142017-09-142021-01-25
101국가지정-가-151한국식품연구원(주)조은술세종경기호증류식소주2017-09-142017-09-142021-01-25
102국가지정-가-152한국식품연구원농업회사법인주식회사좋은술이예령탁주2017-09-142017-09-142021-01-25
103국가지정-가-153한국식품연구원농업회사법인주식회사좋은술이예령약주2017-09-142017-09-142021-01-25
104국가지정-가-154한국식품연구원농업회사법인주식회사좋은술이예령증류식소주2017-09-142017-09-142021-01-25
105국가지정-가-155한국식품연구원새순천양조영농조합법인송병기탁주2017-12-222017-12-222021-01-29
106국가지정-가-156한국식품연구원춘천양조장강왕기탁주2017-12-222017-12-222021-01-29
107국가지정-가-157한국식품연구원춘천양조장강왕기탁주2017-12-222017-12-222021-01-29
108국가지정-가-158한국식품연구원예밀2리영농조합법인김진혁과실주2017-12-222017-12-222021-01-29