Overview

Dataset statistics

Number of variables8
Number of observations34
Missing cells75
Missing cells (%)27.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory67.9 B

Variable types

Text3
DateTime1
Boolean4

Dataset

Description인삼류(홍삼, 태극삼, 백삼, 흑삼)를 시중에 유통 및 판매하기 위해 품질검사를 실시하는 검사업체 정보(업체명, 대표자, 소재지, 최초지정일자, 지정삼종별 검사여부)
Author국립농산물품질관리원
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20191011000000001209

Alerts

지정삼종 홍삼 has constant value ""Constant
지정삼종 태극삼 has constant value ""Constant
지정삼종 백삼 has constant value ""Constant
지정삼종 흑삼 has constant value ""Constant
최초지정일 has 1 (2.9%) missing valuesMissing
지정삼종 태극삼 has 25 (73.5%) missing valuesMissing
지정삼종 백삼 has 19 (55.9%) missing valuesMissing
지정삼종 흑삼 has 30 (88.2%) missing valuesMissing
업체명 has unique valuesUnique
대표자 has unique valuesUnique
소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-11 03:33:03.365421
Analysis finished2023-12-11 03:33:04.044901
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-12-11T12:33:04.491084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length8.5
Min length4

Characters and Unicode

Total characters289
Distinct characters77
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique34 ?
Unique (%)100.0%

Sample

1st row인삼검사소
2nd row㈜한국인삼공사
3rd row대금인삼
4th row금산인삼협동조합
5th row(주)유엔아이금산지점
ValueCountFrequency (%)
인삼검사소 1
 
2.8%
개성인삼농업협동조합 1
 
2.8%
영농조합법인순우리인삼 1
 
2.8%
대동고려삼(주 1
 
2.8%
안성인삼농협 1
 
2.8%
풍기인삼농협 1
 
2.8%
포천인삼영농조합법인 1
 
2.8%
정농인삼영농조합법인 1
 
2.8%
㈜한국인삼공사 1
 
2.8%
풍기중앙인삼영농조합법인 1
 
2.8%
Other values (26) 26
72.2%
2023-12-11T12:33:04.914010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
인 34
 
11.8%
삼 32
 
11.1%
농 19
 
6.6%
조 14
 
4.8%
합 13
 
4.5%
법 11
 
3.8%
영 9
 
3.1%
협 9
 
3.1%
주 7
 
2.4%
) 6
 
2.1%
Other values (67) 135
46.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 270
93.4%
Close Punctuation 6
 
2.1%
Open Punctuation 6
 
2.1%
Other Symbol 5
 
1.7%
Space Separator 2
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 34
 
12.6%
삼 32
 
11.9%
농 19
 
7.0%
조 14
 
5.2%
합 13
 
4.8%
법 11
 
4.1%
영 9
 
3.3%
협 9
 
3.3%
주 7
 
2.6%
사 6
 
2.2%
Other values (63) 116
43.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 5
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 275
95.2%
Common 14
 
4.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 34
 
12.4%
삼 32
 
11.6%
농 19
 
6.9%
조 14
 
5.1%
합 13
 
4.7%
법 11
 
4.0%
영 9
 
3.3%
협 9
 
3.3%
주 7
 
2.5%
사 6
 
2.2%
Other values (64) 121
44.0%
Common
ValueCountFrequency (%)
) 6
42.9%
( 6
42.9%
2
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 270
93.4%
ASCII 14
 
4.8%
None 5
 
1.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
인 34
 
12.6%
삼 32
 
11.9%
농 19
 
7.0%
조 14
 
5.2%
합 13
 
4.8%
법 11
 
4.1%
영 9
 
3.3%
협 9
 
3.3%
주 7
 
2.6%
사 6
 
2.2%
Other values (63) 116
43.0%
ASCII
ValueCountFrequency (%)
) 6
42.9%
( 6
42.9%
2
 
14.3%
None
ValueCountFrequency (%)
㈜ 5
100.0%

대표자
Text

UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-12-11T12:33:05.200672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters102
Distinct characters60
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

Unique34 ?
Unique (%)100.0%

Sample

1st row최광진
2nd row허철호
3rd row염현숙
4th row강상묵
5th row민홍기
ValueCountFrequency (%)
최광진 1
 
2.9%
허철호 1
 
2.9%
최후자 1
 
2.9%
최성근 1
 
2.9%
양희종 1
 
2.9%
권헌준 1
 
2.9%
박창학 1
 
2.9%
허재영 1
 
2.9%
신두연 1
 
2.9%
민순기 1
 
2.9%
Other values (24) 24
70.6%
2023-12-11T12:33:05.667784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
성 5
 
4.9%
김 5
 
4.9%
종 5
 
4.9%
영 4
 
3.9%
기 4
 
3.9%
열 3
 
2.9%
호 3
 
2.9%
광 3
 
2.9%
최 3
 
2.9%
박 3
 
2.9%
Other values (50) 64
62.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 102
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
성 5
 
4.9%
김 5
 
4.9%
종 5
 
4.9%
영 4
 
3.9%
기 4
 
3.9%
열 3
 
2.9%
호 3
 
2.9%
광 3
 
2.9%
최 3
 
2.9%
박 3
 
2.9%
Other values (50) 64
62.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 102
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
성 5
 
4.9%
김 5
 
4.9%
종 5
 
4.9%
영 4
 
3.9%
기 4
 
3.9%
열 3
 
2.9%
호 3
 
2.9%
광 3
 
2.9%
최 3
 
2.9%
박 3
 
2.9%
Other values (50) 64
62.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 102
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
성 5
 
4.9%
김 5
 
4.9%
종 5
 
4.9%
영 4
 
3.9%
기 4
 
3.9%
열 3
 
2.9%
호 3
 
2.9%
광 3
 
2.9%
최 3
 
2.9%
박 3
 
2.9%
Other values (50) 64
62.7%

소재지
Text

UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-12-11T12:33:06.080230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length24
Mean length19.352941
Min length16

Characters and Unicode

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

Unique34 ?
Unique (%)100.0%

Sample

1st row충남 금산군 금산읍 방아동길 52
2nd row충남 부여군 규암면 흥수로 846
3rd row충남 금산군 금성면 진산로 87-19
4th row충남 부여군 은산면 충의로 602-12
5th row충남 금산군 금산읍 금산천2길 51
ValueCountFrequency (%)
충남 16
 
9.4%
금산군 13
 
7.6%
경북 5
 
2.9%
영주시 5
 
2.9%
금산읍 4
 
2.3%
풍기읍 4
 
2.3%
금성면 4
 
2.3%
소백로 3
 
1.8%
진안읍 3
 
1.8%
인천 3
 
1.8%
Other values (96) 111
64.9%
2023-12-11T12:33:06.709022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
137
20.8%
금 26
 
4.0%
군 26
 
4.0%
로 24
 
3.6%
1 22
 
3.3%
산 21
 
3.2%
남 19
 
2.9%
충 19
 
2.9%
면 19
 
2.9%
3 16
 
2.4%
Other values (88) 329
50.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 397
60.3%
Space Separator 137
 
20.8%
Decimal Number 117
 
17.8%
Dash Punctuation 7
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
금 26
 
6.5%
군 26
 
6.5%
로 24
 
6.0%
산 21
 
5.3%
남 19
 
4.8%
충 19
 
4.8%
면 19
 
4.8%
북 15
 
3.8%
길 14
 
3.5%
읍 14
 
3.5%
Other values (76) 200
50.4%
Decimal Number
ValueCountFrequency (%)
1 22
18.8%
3 16
13.7%
8 15
12.8%
5 13
11.1%
2 12
10.3%
6 11
9.4%
4 8
 
6.8%
9 8
 
6.8%
7 7
 
6.0%
0 5
 
4.3%
Space Separator
ValueCountFrequency (%)
137
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 397
60.3%
Common 261
39.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
금 26
 
6.5%
군 26
 
6.5%
로 24
 
6.0%
산 21
 
5.3%
남 19
 
4.8%
충 19
 
4.8%
면 19
 
4.8%
북 15
 
3.8%
길 14
 
3.5%
읍 14
 
3.5%
Other values (76) 200
50.4%
Common
ValueCountFrequency (%)
137
52.5%
1 22
 
8.4%
3 16
 
6.1%
8 15
 
5.7%
5 13
 
5.0%
2 12
 
4.6%
6 11
 
4.2%
4 8
 
3.1%
9 8
 
3.1%
7 7
 
2.7%
Other values (2) 12
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 397
60.3%
ASCII 261
39.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
137
52.5%
1 22
 
8.4%
3 16
 
6.1%
8 15
 
5.7%
5 13
 
5.0%
2 12
 
4.6%
6 11
 
4.2%
4 8
 
3.1%
9 8
 
3.1%
7 7
 
2.7%
Other values (2) 12
 
4.6%
Hangul
ValueCountFrequency (%)
금 26
 
6.5%
군 26
 
6.5%
로 24
 
6.0%
산 21
 
5.3%
남 19
 
4.8%
충 19
 
4.8%
면 19
 
4.8%
북 15
 
3.8%
길 14
 
3.5%
읍 14
 
3.5%
Other values (76) 200
50.4%

최초지정일
Date

MISSING 

Distinct32
Distinct (%)97.0%
Missing1
Missing (%)2.9%
Memory size404.0 B
Minimum1996-07-23 00:00:00
Maximum2020-09-25 00:00:00
2023-12-11T12:33:06.880305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:33:07.036134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)

지정삼종 홍삼
Boolean

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size166.0 B
True
34 
ValueCountFrequency (%)
True 34
100.0%
2023-12-11T12:33:07.186179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

지정삼종 태극삼
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)11.1%
Missing25
Missing (%)73.5%
Memory size200.0 B
True
9 
(Missing)
25 
ValueCountFrequency (%)
True 9
 
26.5%
(Missing) 25
73.5%
2023-12-11T12:33:07.296558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

지정삼종 백삼
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)6.7%
Missing19
Missing (%)55.9%
Memory size200.0 B
True
15 
(Missing)
19 
ValueCountFrequency (%)
True 15
44.1%
(Missing) 19
55.9%
2023-12-11T12:33:07.390907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

지정삼종 흑삼
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)25.0%
Missing30
Missing (%)88.2%
Memory size200.0 B
True
4 
(Missing)
30 
ValueCountFrequency (%)
True 4
 
11.8%
(Missing) 30
88.2%
2023-12-11T12:33:07.474298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T12:33:07.535289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명대표자소재지최초지정일
업체명1.0001.0001.0001.000
대표자1.0001.0001.0001.000
소재지1.0001.0001.0001.000
최초지정일1.0001.0001.0001.000

Missing values

2023-12-11T12:33:03.712349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T12:33:03.835488image/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.
2023-12-11T12:33:03.961447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

업체명대표자소재지최초지정일지정삼종 홍삼지정삼종 태극삼지정삼종 백삼지정삼종 흑삼
0인삼검사소최광진충남 금산군 금산읍 방아동길 52<NA>YYYY
1㈜한국인삼공사허철호충남 부여군 규암면 흥수로 8461996-07-23Y<NA><NA><NA>
2대금인삼염현숙충남 금산군 금성면 진산로 87-191999-12-21Y<NA>Y<NA>
3금산인삼협동조합강상묵충남 부여군 은산면 충의로 602-122003-12-29YY<NA><NA>
4(주)유엔아이금산지점민홍기충남 금산군 금산읍 금산천2길 512007-02-13YY<NA><NA>
5강화인삼농협한홍열인천 강화군 강화읍 강화대로 3352007-05-30Y<NA><NA><NA>
6삼화삼업사이종열충남 금산군 금성면 화엄로 1922007-07-04YY<NA><NA>
7천오백년홍삼영농조합법인김성돈경북 영주시 봉현면 소백로 1701번길 33-142006-03-29Y<NA>Y<NA>
8김포파주인삼농협조재열경기 김포시 대곶면 대명항로 5182008-03-17Y<NA><NA><NA>
9개성인삼농업협동조합민순기경기 포천시 일동면 기산동길 742008-03-25Y<NA>Y<NA>
업체명대표자소재지최초지정일지정삼종 홍삼지정삼종 태극삼지정삼종 백삼지정삼종 흑삼
24대길인삼영농조합법인길기성충남 금산군 남일면 무금로 19852015-07-21Y<NA><NA><NA>
25㈜한국고려인삼고봉준충남 금산군 부리면 신촌길 1642015-10-13YYYY
26풍기중앙인삼영농조합법인신두연경북 영주시 풍기읍 소백로 21652015-12-15Y<NA>Y<NA>
27정농인삼영농조합법인허재영충남 금산군 남이면 비실길 12016-04-06Y<NA>Y<NA>
28포천인삼영농조합법인박창학경기도 포천시 화현면 금강로 39812016-07-29Y<NA><NA><NA>
29풍기인삼농협권헌준경북 영주시 풍기읍 금계로 322017-09-04YYY<NA>
30안성인삼농협양희종경기도 안성시 대덕면 만세로 2852018-06-05Y<NA><NA><NA>
31대동고려삼(주)최성근충남 금산군 군북면 군북로 5862018-06-12YYYY
32영농조합법인순우리인삼최후자경북 영주시 풍기읍 전구로 1662019-04-04Y<NA>Y<NA>
33고려홍삼원(주)이종원인천 강화군 송해면 강화대로833번길 382020-09-25Y<NA><NA><NA>