Overview

Dataset statistics

Number of variables8
Number of observations35
Missing cells76
Missing cells (%)27.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory67.8 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 1 (2.9%) missing valuesMissing
지정삼종 태극삼 has 24 (68.6%) missing valuesMissing
지정삼종 백삼 has 19 (54.3%) missing valuesMissing
지정삼종 흑삼 has 31 (88.6%) missing valuesMissing
업체명 has unique valuesUnique
소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-11 03:32:48.506786
Analysis finished2023-12-11 03:32:49.135713
Duration0.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
2023-12-11T12:32:49.314851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length8.6
Min length3

Characters and Unicode

Total characters301
Distinct characters79
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

Unique35 ?
Unique (%)100.0%

Sample

1st row인삼검사소
2nd row㈜한국인삼공사
3rd row백년인삼농사
4th row백제금산인삼협동조합
5th row(주)유엔아이금산지점
ValueCountFrequency (%)
인삼검사소 1
 
2.7%
㈜한국고려인삼 1
 
2.7%
유창(주 1
 
2.7%
한국고려홍삼조합(주 1
 
2.7%
영농조합법인풍기인삼나라 1
 
2.7%
농업회사법인(주 1
 
2.7%
한국인삼 1
 
2.7%
유)자연의길 1
 
2.7%
고려인삼영농조합법인 1
 
2.7%
㈜삼흥 1
 
2.7%
Other values (27) 27
73.0%
2023-12-11T12:32:49.813133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
35
 
11.6%
31
 
10.3%
20
 
6.6%
16
 
5.3%
15
 
5.0%
12
 
4.0%
10
 
3.3%
9
 
3.0%
7
 
2.3%
7
 
2.3%
Other values (69) 139
46.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 282
93.7%
Close Punctuation 6
 
2.0%
Open Punctuation 6
 
2.0%
Other Symbol 5
 
1.7%
Space Separator 2
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
35
 
12.4%
31
 
11.0%
20
 
7.1%
16
 
5.7%
15
 
5.3%
12
 
4.3%
10
 
3.5%
9
 
3.2%
7
 
2.5%
7
 
2.5%
Other values (65) 120
42.6%
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 287
95.3%
Common 14
 
4.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
35
 
12.2%
31
 
10.8%
20
 
7.0%
16
 
5.6%
15
 
5.2%
12
 
4.2%
10
 
3.5%
9
 
3.1%
7
 
2.4%
7
 
2.4%
Other values (66) 125
43.6%
Common
ValueCountFrequency (%)
) 6
42.9%
( 6
42.9%
2
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 282
93.7%
ASCII 14
 
4.7%
None 5
 
1.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
35
 
12.4%
31
 
11.0%
20
 
7.1%
16
 
5.7%
15
 
5.3%
12
 
4.3%
10
 
3.5%
9
 
3.2%
7
 
2.5%
7
 
2.5%
Other values (65) 120
42.6%
ASCII
ValueCountFrequency (%)
) 6
42.9%
( 6
42.9%
2
 
14.3%
None
ValueCountFrequency (%)
5
100.0%

대표자
Text

MISSING 

Distinct34
Distinct (%)100.0%
Missing1
Missing (%)2.9%
Memory size412.0 B
2023-12-11T12:32:50.103127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters102
Distinct characters61
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:32:50.529478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6
 
5.9%
5
 
4.9%
4
 
3.9%
4
 
3.9%
4
 
3.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
Other values (51) 64
62.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 102
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
6
 
5.9%
5
 
4.9%
4
 
3.9%
4
 
3.9%
4
 
3.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
Other values (51) 64
62.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 102
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
6
 
5.9%
5
 
4.9%
4
 
3.9%
4
 
3.9%
4
 
3.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
Other values (51) 64
62.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 102
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
6
 
5.9%
5
 
4.9%
4
 
3.9%
4
 
3.9%
4
 
3.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
Other values (51) 64
62.7%

소재지
Text

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
2023-12-11T12:32:51.230766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length19.257143
Min length16

Characters and Unicode

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

Unique35 ?
Unique (%)100.0%

Sample

1st row충남 금산군 금산읍 방아동길 52
2nd row충남 부여군 규암면 흥수로 846
3rd row충남 금산군 금성면 구름고개길 68-6
4th row충남 부여군 은산면 충의로 602-12
5th row충남 금산군 금산읍 금산천2길 51
ValueCountFrequency (%)
충남 17
 
9.7%
금산군 14
 
8.0%
경북 6
 
3.4%
풍기읍 6
 
3.4%
영주시 6
 
3.4%
금산읍 4
 
2.3%
금성면 4
 
2.3%
진안읍 3
 
1.7%
진안군 3
 
1.7%
전북 3
 
1.7%
Other values (97) 109
62.3%
2023-12-11T12:32:51.739254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
140
20.8%
27
 
4.0%
27
 
4.0%
23
 
3.4%
1 22
 
3.3%
21
 
3.1%
20
 
3.0%
20
 
3.0%
18
 
2.7%
17
 
2.5%
Other values (92) 339
50.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 411
61.0%
Space Separator 140
 
20.8%
Decimal Number 116
 
17.2%
Dash Punctuation 7
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
27
 
6.6%
27
 
6.6%
23
 
5.6%
21
 
5.1%
20
 
4.9%
20
 
4.9%
18
 
4.4%
17
 
4.1%
17
 
4.1%
16
 
3.9%
Other values (80) 205
49.9%
Decimal Number
ValueCountFrequency (%)
1 22
19.0%
2 15
12.9%
6 14
12.1%
8 14
12.1%
5 12
10.3%
3 10
8.6%
4 10
8.6%
7 7
 
6.0%
9 7
 
6.0%
0 5
 
4.3%
Space Separator
ValueCountFrequency (%)
140
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 411
61.0%
Common 263
39.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
27
 
6.6%
27
 
6.6%
23
 
5.6%
21
 
5.1%
20
 
4.9%
20
 
4.9%
18
 
4.4%
17
 
4.1%
17
 
4.1%
16
 
3.9%
Other values (80) 205
49.9%
Common
ValueCountFrequency (%)
140
53.2%
1 22
 
8.4%
2 15
 
5.7%
6 14
 
5.3%
8 14
 
5.3%
5 12
 
4.6%
3 10
 
3.8%
4 10
 
3.8%
7 7
 
2.7%
9 7
 
2.7%
Other values (2) 12
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 411
61.0%
ASCII 263
39.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
140
53.2%
1 22
 
8.4%
2 15
 
5.7%
6 14
 
5.3%
8 14
 
5.3%
5 12
 
4.6%
3 10
 
3.8%
4 10
 
3.8%
7 7
 
2.7%
9 7
 
2.7%
Other values (2) 12
 
4.6%
Hangul
ValueCountFrequency (%)
27
 
6.6%
27
 
6.6%
23
 
5.6%
21
 
5.1%
20
 
4.9%
20
 
4.9%
18
 
4.4%
17
 
4.1%
17
 
4.1%
16
 
3.9%
Other values (80) 205
49.9%

최초지정일
Date

MISSING 

Distinct33
Distinct (%)97.1%
Missing1
Missing (%)2.9%
Memory size412.0 B
Minimum1996-07-23 00:00:00
Maximum2019-04-04 00:00:00
2023-12-11T12:32:51.903786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:32:52.026807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)

지정삼종 홍삼
Boolean

CONSTANT 

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

지정삼종 태극삼
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)9.1%
Missing24
Missing (%)68.6%
Memory size202.0 B
True
11 
(Missing)
24 
ValueCountFrequency (%)
True 11
31.4%
(Missing) 24
68.6%
2023-12-11T12:32:52.242966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

지정삼종 백삼
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)6.2%
Missing19
Missing (%)54.3%
Memory size202.0 B
True
16 
(Missing)
19 
ValueCountFrequency (%)
True 16
45.7%
(Missing) 19
54.3%
2023-12-11T12:32:52.343061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

지정삼종 흑삼
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)25.0%
Missing31
Missing (%)88.6%
Memory size202.0 B
True
(Missing)
31 
ValueCountFrequency (%)
True 4
 
11.4%
(Missing) 31
88.6%
2023-12-11T12:32:52.447587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T12:32:52.531708image/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:32:48.809286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T12:32:48.944499image/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:32:49.059628image/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인삼검사소<NA>충남 금산군 금산읍 방아동길 52<NA>YYYY
1㈜한국인삼공사김재수충남 부여군 규암면 흥수로 8461996-07-23Y<NA><NA><NA>
2백년인삼농사염현숙충남 금산군 금성면 구름고개길 68-61999-12-21Y<NA>Y<NA>
3백제금산인삼협동조합강상묵충남 부여군 은산면 충의로 602-122003-12-29YY<NA><NA>
4(주)유엔아이금산지점민홍기충남 금산군 금산읍 금산천2길 512007-02-13YY<NA><NA>
5풍기특산물영농조합법인박관식경북 영주시 풍기읍 죽령로 11182007-04-05YYY<NA>
6강화인삼협동조합황우덕인천 강화군 강화읍 동문로236번길 4-72007-05-30Y<NA><NA><NA>
7삼화삼업사이종열충남 금산군 금성면 화엄로 1922007-07-04YY<NA><NA>
8천오백년홍삼영농조합법인김성돈경북 영주시 풍기읍 기주로170번길 462006-03-29Y<NA>Y<NA>
9김포파주인삼농협조재열경기 김포시 대곶면 대명항로 5182008-03-17Y<NA><NA><NA>
업체명대표자소재지최초지정일지정삼종 홍삼지정삼종 태극삼지정삼종 백삼지정삼종 흑삼
25고려인삼영농조합법인김영순경기도 포천시 소흘읍 호국로 493-432015-05-13Y<NA><NA><NA>
26대길인삼영농조합법인길기성충남 금산군 남일면 무금로 19852015-07-21Y<NA><NA><NA>
27㈜한국고려인삼고봉준충남 금산군 부리면 신촌길 1642015-10-13YYYY
28중앙인삼영농조합법인신두연경북 영주시 풍기읍 기주로41번길 222015-12-15Y<NA>Y<NA>
29정농인삼영농조합법인허재영충남 금산군 남이면 비실길 12016-04-06Y<NA>Y<NA>
30포천인삼영농조합법인박창학경기도 포천시 화현면 금강로 39812016-07-29Y<NA><NA><NA>
31풍기인삼농협권헌준경북 영주시 풍기읍 금계로 322017-09-04YYY<NA>
32안성인삼농협박봉순경기도 안성시 대덕면 만세로 2852018-06-05Y<NA><NA><NA>
33대동고려삼(주)최성근충남 금산군 군북면 군북로 5862018-06-12YYYY
34영농조합법인순우리인삼최후자경북 영주시 풍기읍 전구로 1662019-04-04Y<NA>Y<NA>