Overview

Dataset statistics

Number of variables7
Number of observations187
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.4 KiB
Average record size in memory56.7 B

Variable types

Text2
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:55.055931
Analysis finished2024-03-23 07:55:56.487284
Duration1.43 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

인증번호
Text

UNIQUE 

Distinct187
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-03-23T07:55:56.708264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

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

Unique187 ?
Unique (%)100.0%

Sample

1st row국가지정-가-004
2nd row국가지정-가-005
3rd row국가지정-가-006
4th row국가지정-가-014
5th row국가지정-가-022
ValueCountFrequency (%)
국가지정-가-004 1
 
0.5%
국가지정-가-254 1
 
0.5%
국가지정-가-265 1
 
0.5%
국가지정-가-246 1
 
0.5%
국가지정-가-247 1
 
0.5%
국가지정-가-248 1
 
0.5%
국가지정-가-249 1
 
0.5%
국가지정-가-250 1
 
0.5%
국가지정-가-251 1
 
0.5%
국가지정-가-252 1
 
0.5%
Other values (177) 177
94.7%
2024-03-23T07:55:57.635545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
가 374
20.0%
- 374
20.0%
국 187
10.0%
지 187
10.0%
정 187
10.0%
2 123
 
6.6%
1 91
 
4.9%
0 74
 
4.0%
3 49
 
2.6%
5 41
 
2.2%
Other values (5) 183
9.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 935
50.0%
Decimal Number 561
30.0%
Dash Punctuation 374
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 123
21.9%
1 91
16.2%
0 74
13.2%
3 49
 
8.7%
5 41
 
7.3%
7 40
 
7.1%
8 39
 
7.0%
4 37
 
6.6%
6 34
 
6.1%
9 33
 
5.9%
Other Letter
ValueCountFrequency (%)
가 374
40.0%
국 187
20.0%
지 187
20.0%
정 187
20.0%
Dash Punctuation
ValueCountFrequency (%)
- 374
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 935
50.0%
Common 935
50.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 374
40.0%
2 123
 
13.2%
1 91
 
9.7%
0 74
 
7.9%
3 49
 
5.2%
5 41
 
4.4%
7 40
 
4.3%
8 39
 
4.2%
4 37
 
4.0%
6 34
 
3.6%
Hangul
ValueCountFrequency (%)
가 374
40.0%
국 187
20.0%
지 187
20.0%
정 187
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 935
50.0%
ASCII 935
50.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
가 374
40.0%
국 187
20.0%
지 187
20.0%
정 187
20.0%
ASCII
ValueCountFrequency (%)
- 374
40.0%
2 123
 
13.2%
1 91
 
9.7%
0 74
 
7.9%
3 49
 
5.2%
5 41
 
4.4%
7 40
 
4.3%
8 39
 
4.2%
4 37
 
4.0%
6 34
 
3.6%

인증기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
한국식품연구원
187 

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

Length

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

Common Values (Plot)

2024-03-23T07:55:58.159770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한국식품연구원 187
100.0%

인증업체
Text

Distinct90
Distinct (%)48.1%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-03-23T07:55:58.511879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length15
Mean length8.973262
Min length2

Characters and Unicode

Total characters1678
Distinct characters166
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 (%)19.3%

Sample

1st row서울장수주식회사
2nd row서울장수주식회사
3rd row구암농산
4th row울산탁주
5th row한주양조
ValueCountFrequency (%)
농업회사법인 28
 
11.1%
주식회사 10
 
4.0%
국순당여주명주 7
 
2.8%
농업회사법인(주)죽향도가 6
 
2.4%
양주골 6
 
2.4%
이가전통주 6
 
2.4%
제주샘영농조합법인 6
 
2.4%
주)조은술세종 5
 
2.0%
주)화요 5
 
2.0%
서울장수주식회사 5
 
2.0%
Other values (91) 168
66.7%
2024-03-23T07:55:59.442656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 137
 
8.2%
농 88
 
5.2%
사 85
 
5.1%
인 81
 
4.8%
회 80
 
4.8%
법 75
 
4.5%
65
 
3.9%
조 63
 
3.8%
업 57
 
3.4%
( 53
 
3.2%
Other values (156) 894
53.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1492
88.9%
Space Separator 65
 
3.9%
Open Punctuation 53
 
3.2%
Close Punctuation 53
 
3.2%
Decimal Number 9
 
0.5%
Other Symbol 4
 
0.2%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 137
 
9.2%
농 88
 
5.9%
사 85
 
5.7%
인 81
 
5.4%
회 80
 
5.4%
법 75
 
5.0%
조 63
 
4.2%
업 57
 
3.8%
양 36
 
2.4%
장 35
 
2.3%
Other values (148) 755
50.6%
Decimal Number
ValueCountFrequency (%)
2 5
55.6%
1 4
44.4%
Uppercase Letter
ValueCountFrequency (%)
B 1
50.0%
L 1
50.0%
Space Separator
ValueCountFrequency (%)
65
100.0%
Open Punctuation
ValueCountFrequency (%)
( 53
100.0%
Close Punctuation
ValueCountFrequency (%)
) 53
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1496
89.2%
Common 180
 
10.7%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 137
 
9.2%
농 88
 
5.9%
사 85
 
5.7%
인 81
 
5.4%
회 80
 
5.3%
법 75
 
5.0%
조 63
 
4.2%
업 57
 
3.8%
양 36
 
2.4%
장 35
 
2.3%
Other values (149) 759
50.7%
Common
ValueCountFrequency (%)
65
36.1%
( 53
29.4%
) 53
29.4%
2 5
 
2.8%
1 4
 
2.2%
Latin
ValueCountFrequency (%)
B 1
50.0%
L 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1492
88.9%
ASCII 182
 
10.8%
None 4
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 137
 
9.2%
농 88
 
5.9%
사 85
 
5.7%
인 81
 
5.4%
회 80
 
5.4%
법 75
 
5.0%
조 63
 
4.2%
업 57
 
3.8%
양 36
 
2.4%
장 35
 
2.3%
Other values (148) 755
50.6%
ASCII
ValueCountFrequency (%)
65
35.7%
( 53
29.1%
) 53
29.1%
2 5
 
2.7%
1 4
 
2.2%
B 1
 
0.5%
L 1
 
0.5%
None
ValueCountFrequency (%)
㈜ 4
100.0%

품목명
Categorical

Distinct8
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
탁주
67 
약주
41 
증류식소주
39 
과실주
18 
일반증류주
9 
Other values (3)
13 

Length

Max length5
Median length2
Mean length3
Min length2

Unique

Unique1 ?
Unique (%)0.5%

Sample

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

Common Values

ValueCountFrequency (%)
탁주 67
35.8%
약주 41
21.9%
증류식소주 39
20.9%
과실주 18
 
9.6%
일반증류주 9
 
4.8%
기타주류 7
 
3.7%
살균탁주 5
 
2.7%
리큐르 1
 
0.5%

Length

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

Common Values (Plot)

2024-03-23T07:56:00.224646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
탁주 67
35.8%
약주 41
21.9%
증류식소주 39
20.9%
과실주 18
 
9.6%
일반증류주 9
 
4.8%
기타주류 7
 
3.7%
살균탁주 5
 
2.7%
리큐르 1
 
0.5%

인증일자
Date

Distinct26
Distinct (%)13.9%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2017-09-14 00:00:00
Maximum2023-09-14 00:00:00
2024-03-23T07:56:00.669798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:56:01.136086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

인증시작일자
Date

Distinct25
Distinct (%)13.4%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2020-10-07 00:00:00
Maximum2023-09-14 00:00:00
2024-03-23T07:56:01.558022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:56:01.927869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

인증종료일자
Date

Distinct25
Distinct (%)13.4%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2023-10-06 00:00:00
Maximum2026-09-13 00:00:00
2024-03-23T07:56:02.287305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:56:02.663195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

Correlations

2024-03-23T07:56:02.894665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
인증업체품목명인증일자인증시작일자인증종료일자
인증업체1.0000.9280.9870.9920.992
품목명0.9281.0000.6400.6540.685
인증일자0.9870.6401.0000.9990.998
인증시작일자0.9920.6540.9991.0001.000
인증종료일자0.9920.6850.9981.0001.000

Missing values

2024-03-23T07:55:56.098087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T07:55:56.408160image/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국가지정-가-004한국식품연구원서울장수주식회사탁주2022-10-052022-10-052025-10-04
1국가지정-가-005한국식품연구원서울장수주식회사살균탁주2022-10-052022-10-052025-10-04
2국가지정-가-006한국식품연구원구암농산살균탁주2022-10-052022-10-052025-10-04
3국가지정-가-014한국식품연구원울산탁주탁주2022-10-052022-10-052025-10-04
4국가지정-가-022한국식품연구원한주양조탁주2022-10-052022-10-052025-10-04
5국가지정-가-027한국식품연구원배상면주가고창LB주식회사과실주2022-10-052022-10-052025-10-04
6국가지정-가-028한국식품연구원여수주조공사탁주2022-10-052022-10-052025-10-04
7국가지정-가-032한국식품연구원순천주조탁주2022-10-052022-10-052025-10-04
8국가지정-가-035한국식품연구원순천주조탁주2022-10-052022-10-052025-10-04
9국가지정-가-043한국식품연구원(주)제주막걸리탁주2022-10-052022-10-052025-10-04
인증번호인증기관인증업체품목명인증일자인증시작일자인증종료일자
177국가지정-가-304한국식품연구원착한농부일반증류주2023-05-112023-05-112026-05-10
178국가지정-가-305한국식품연구원착한농부일반증류주2023-05-112023-05-112026-05-10
179국가지정-가-306한국식품연구원석이원주조약주2023-05-112023-05-112026-05-10
180국가지정-가-307한국식품연구원석이원주조약주2023-05-112023-05-112026-05-10
181국가지정-가-308한국식품연구원내올담약주2023-05-112023-05-112026-05-10
182국가지정-가-309한국식품연구원술아원탁주2023-05-112023-05-112026-05-10
183국가지정-가-310한국식품연구원술아원약주2023-05-112023-05-112026-05-10
184국가지정-가-311한국식품연구원술아원증류식소주2023-05-112023-05-112026-05-10
185국가지정-가-312한국식품연구원태안발효약주2023-05-232023-05-232026-05-22
186국가지정-가-313한국식품연구원태안발효증류식소주2023-05-232023-05-232026-05-22