Overview

Dataset statistics

Number of variables9
Number of observations176
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.7 KiB
Average record size in memory73.8 B

Variable types

Categorical9

Dataset

Description현재 제주 지역에서 발견되어 감귤산업에 경제적 피해를 주고 있는 감귤황룡병 방제 등록 약제정보를 국민에게 제공하여 농가에서 손쉽게 사전에 방제할수 있도록 하는 등 농민의 자산 및 자연환경 보호에 활용하고자 함
Author농림축산검역본부
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20220214000000001863

Alerts

YEAR has constant value ""Constant
PRDUCT_ENG_NM is highly overall correlated with INSEDE_DRFSTF and 4 other fieldsHigh correlation
PRDUCT_KOREAN_NM is highly overall correlated with INSEDE_DRFSTF and 4 other fieldsHigh correlation
AGCHM_PROCESS_LMTT_INTRVL is highly overall correlated with INSEDE_DRFSTF and 4 other fieldsHigh correlation
NNMY_AFFC is highly overall correlated with INSEDE_DRFSTF and 4 other fieldsHigh correlation
HARVESTBFE_AGCHMPROCESS_INTRVL is highly overall correlated with INSEDE_DRFSTF and 4 other fieldsHigh correlation
INSEDE_DRFSTF is highly overall correlated with PRDUCT_ENG_NM and 4 other fieldsHigh correlation

Reproduction

Analysis started2023-12-11 03:22:44.943599
Analysis finished2023-12-11 03:22:46.198662
Duration1.26 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

YEAR
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2016
176 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2016
2nd row2016
3rd row2016
4th row2016
5th row2016

Common Values

ValueCountFrequency (%)
2016 176
100.0%

Length

2023-12-11T12:22:46.302540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:22:46.477327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016 176
100.0%

INSEDE_DRFSTF
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)11.9%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
티아메톡삼
16 
제타싸이퍼메트린
 
8
포스메트
 
8
피리다벤
 
8
스피노사드
 
8
Other values (16)
128 

Length

Max length13
Median length10
Mean length6.6818182
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row메톡시페노자이드
2nd row메톡시페노자이드
3rd row메톡시페노자이드
4th row석유계 유분
5th row석유계 유분

Common Values

ValueCountFrequency (%)
티아메톡삼 16
 
9.1%
제타싸이퍼메트린 8
 
4.5%
포스메트 8
 
4.5%
피리다벤 8
 
4.5%
스피노사드 8
 
4.5%
스피네토람 8
 
4.5%
스피로디크로펜 8
 
4.5%
스피로테트라맷 8
 
4.5%
황 8
 
4.5%
석유계 유분 8
 
4.5%
Other values (11) 88
50.0%

Length

2023-12-11T12:22:46.604368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
티아메톡삼 16
 
8.0%
제타싸이퍼메트린 8
 
4.0%
이미다클로프리드 8
 
4.0%
유제 8
 
4.0%
아바멕틴 8
 
4.0%
이미다클로프리드(토양 8
 
4.0%
펜프로파스린 8
 
4.0%
산화펜부타주석 8
 
4.0%
디메토에이트 8
 
4.0%
디플루벤주론 8
 
4.0%
Other values (14) 112
56.0%

PRDUCT_ENG_NM
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)11.9%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
numerous
16 
Mustang Insecticide
 
8
Imidan 70W
 
8
Nexter Miticide
 
8
Spintor 2SC
 
8
Other values (16)
128 

Length

Max length20
Median length14.5
Mean length13.181818
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowIntrepid 2F
2nd rowIntrepid 2F
3rd rowIntrepid 2F
4th rownumerous
5th rownumerous

Common Values

ValueCountFrequency (%)
numerous 16
 
9.1%
Mustang Insecticide 8
 
4.5%
Imidan 70W 8
 
4.5%
Nexter Miticide 8
 
4.5%
Spintor 2SC 8
 
4.5%
Delegate WG 8
 
4.5%
Envidor 2SC 8
 
4.5%
Movento 240SC 8
 
4.5%
Actara 25 WG 8
 
4.5%
Platinum 75 SG 8
 
4.5%
Other values (11) 88
50.0%

Length

2023-12-11T12:22:46.762811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
numerous 16
 
4.3%
4e 16
 
4.3%
2sc 16
 
4.3%
wg 16
 
4.3%
vendex 8
 
2.2%
lorsban 8
 
2.2%
belay 8
 
2.2%
50 8
 
2.2%
wdg 8
 
2.2%
micromite 8
 
2.2%
Other values (32) 256
69.6%

PRDUCT_KOREAN_NM
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)10.8%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
<NA>
24 
아타라
16 
터보사이드
 
8
완승
 
8
부메랑
 
8
Other values (14)
112 

Length

Max length15
Median length9.5
Mean length5.2272727
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row런너, 나방전문 등
2nd row런너, 나방전문 등
3rd row런너, 나방전문 등
4th row슈퍼란
5th row슈퍼란

Common Values

ValueCountFrequency (%)
<NA> 24
 
13.6%
아타라 16
 
9.1%
터보사이드 8
 
4.5%
완승 8
 
4.5%
부메랑 8
 
4.5%
델리게이트 8
 
4.5%
시나위 8
 
4.5%
모벤토 8
 
4.5%
슈퍼란 8
 
4.5%
올스타, 버티맥, 아라틴 등 8
 
4.5%
Other values (9) 72
40.9%

Length

2023-12-11T12:22:46.919872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
등 48
 
17.1%
na 24
 
8.6%
아타라 16
 
5.7%
똑소리 8
 
2.9%
나방전문 8
 
2.9%
런너 8
 
2.9%
세단 8
 
2.9%
세빈 8
 
2.9%
한주먹 8
 
2.9%
토큐 8
 
2.9%
Other values (17) 136
48.6%

AGCHM_PROCESS_LMTT_INTRVL
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
12 시간
104 
4 시간
24 
24 시간
24 
5 일
 
8
10 일
 
8

Length

Max length6
Median length6
Mean length5.7272727
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4 시간
2nd row4 시간
3rd row4 시간
4th row12 시간
5th row12 시간

Common Values

ValueCountFrequency (%)
12 시간 104
59.1%
4 시간 24
 
13.6%
24 시간 24
 
13.6%
5 일 8
 
4.5%
10 일 8
 
4.5%
48 시간 8
 
4.5%

Length

2023-12-11T12:22:47.123933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:22:47.305878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시간 160
45.5%
12 104
29.5%
4 24
 
6.8%
24 24
 
6.8%
일 16
 
4.5%
5 8
 
2.3%
10 8
 
2.3%
48 8
 
2.3%

HARVESTBFE_AGCHMPROCESS_INTRVL
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
0
56 
1 일
48 
7 일
40 
21 일
16 
5 일
8 

Length

Max length8
Median length4
Mean length3.3181818
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1 일
2nd row1 일
3rd row1 일
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 56
31.8%
1 일 48
27.3%
7 일 40
22.7%
21 일 16
 
9.1%
5 일 8
 
4.5%
15-45 일 8
 
4.5%

Length

2023-12-11T12:22:47.503320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:22:47.651912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일 120
40.5%
0 56
18.9%
1 48
 
16.2%
7 40
 
13.5%
21 16
 
5.4%
5 8
 
2.7%
15-45 8
 
2.7%

HLSCT_NM
Categorical

Distinct8
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
성충뿌리바구미
22 
깍지벌레
22 
가루깍지벌레
22 
작용방식¹
22 
귤나무이
22 
Other values (3)
66 

Length

Max length7
Median length6.5
Mean length4.625
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성충뿌리바구미
2nd row깍지벌레
3rd row가루깍지벌레
4th row작용방식¹
5th row귤나무이

Common Values

ValueCountFrequency (%)
성충뿌리바구미 22
12.5%
깍지벌레 22
12.5%
가루깍지벌레 22
12.5%
작용방식¹ 22
12.5%
귤나무이 22
12.5%
잎굴파리 22
12.5%
녹응매 22
12.5%
거미응애 22
12.5%

Length

2023-12-11T12:22:47.810143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:22:47.941394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성충뿌리바구미 22
12.5%
깍지벌레 22
12.5%
가루깍지벌레 22
12.5%
작용방식¹ 22
12.5%
귤나무이 22
12.5%
잎굴파리 22
12.5%
녹응매 22
12.5%
거미응애 22
12.5%

HLSCT_ADJST
Categorical

Distinct22
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
-
55 
+++,R
36 
?
22 
+
21 
++
8 
Other values (17)
34 

Length

Max length8
Median length2
Mean length3.1022727
Min length1

Unique

Unique8 ?
Unique (%)4.5%

Sample

1st row-
2nd row-
3rd row-
4th rowNR
5th row+

Common Values

ValueCountFrequency (%)
- 55
31.2%
+++,R 36
20.5%
? 22
 
12.5%
+ 21
 
11.9%
++ 8
 
4.5%
4 5
 
2.8%
+++ 4
 
2.3%
++,R 3
 
1.7%
+ (oil) 3
 
1.7%
1B 3
 
1.7%
Other values (12) 16
 
9.1%

Length

2023-12-11T12:22:48.138628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
114
63.3%
r 40
 
22.2%
4 5
 
2.8%
oil 3
 
1.7%
1b 3
 
1.7%
5 2
 
1.1%
nr 2
 
1.1%
3 2
 
1.1%
23 2
 
1.1%
21 1
 
0.6%
Other values (6) 6
 
3.3%

NNMY_AFFC
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
저
88 
고
40 
중
16 
중/고
 
8
고 (짧은기간)
 
8
Other values (2)
16 

Length

Max length9
Median length2
Mean length2.3181818
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row저
2nd row저
3rd row저
4th row저
5th row저

Common Values

ValueCountFrequency (%)
저 88
50.0%
고 40
22.7%
중 16
 
9.1%
중/고 8
 
4.5%
고 (짧은기간) 8
 
4.5%
중 8
 
4.5%
고 8
 
4.5%

Length

2023-12-11T12:22:48.348099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:22:48.543715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
저 88
47.8%
고 56
30.4%
중 24
 
13.0%
중/고 8
 
4.3%
짧은기간 8
 
4.3%

Correlations

2023-12-11T12:22:48.655415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
INSEDE_DRFSTFPRDUCT_ENG_NMPRDUCT_KOREAN_NMAGCHM_PROCESS_LMTT_INTRVLHARVESTBFE_AGCHMPROCESS_INTRVLHLSCT_NMHLSCT_ADJSTNNMY_AFFC
INSEDE_DRFSTF1.0001.0001.0001.0001.0000.0000.5901.000
PRDUCT_ENG_NM1.0001.0001.0001.0001.0000.0000.4800.999
PRDUCT_KOREAN_NM1.0001.0001.0001.0001.0000.0000.6160.984
AGCHM_PROCESS_LMTT_INTRVL1.0001.0001.0001.0000.9480.0000.2710.743
HARVESTBFE_AGCHMPROCESS_INTRVL1.0001.0001.0000.9481.0000.0000.3970.769
HLSCT_NM0.0000.0000.0000.0000.0001.0000.6470.000
HLSCT_ADJST0.5900.4800.6160.2710.3970.6471.0000.553
NNMY_AFFC1.0000.9990.9840.7430.7690.0000.5531.000
2023-12-11T12:22:48.841218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
HLSCT_NMPRDUCT_ENG_NMPRDUCT_KOREAN_NMAGCHM_PROCESS_LMTT_INTRVLNNMY_AFFCHLSCT_ADJSTHARVESTBFE_AGCHMPROCESS_INTRVLINSEDE_DRFSTF
HLSCT_NM1.0000.0000.0000.0000.0000.3150.0000.000
PRDUCT_ENG_NM0.0001.0000.9960.9550.9070.1470.9550.971
PRDUCT_KOREAN_NM0.0000.9961.0000.9580.9140.2220.9581.000
AGCHM_PROCESS_LMTT_INTRVL0.0000.9550.9581.0000.5590.1180.6650.955
NNMY_AFFC0.0000.9070.9140.5591.0000.2590.5910.931
HLSCT_ADJST0.3150.1470.2220.1180.2591.0000.1830.197
HARVESTBFE_AGCHMPROCESS_INTRVL0.0000.9550.9580.6650.5910.1831.0000.955
INSEDE_DRFSTF0.0000.9711.0000.9550.9310.1970.9551.000
2023-12-11T12:22:49.020887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
INSEDE_DRFSTFPRDUCT_ENG_NMPRDUCT_KOREAN_NMAGCHM_PROCESS_LMTT_INTRVLHARVESTBFE_AGCHMPROCESS_INTRVLHLSCT_NMHLSCT_ADJSTNNMY_AFFC
INSEDE_DRFSTF1.0000.9711.0000.9550.9550.0000.1970.931
PRDUCT_ENG_NM0.9711.0000.9960.9550.9550.0000.1470.907
PRDUCT_KOREAN_NM1.0000.9961.0000.9580.9580.0000.2220.914
AGCHM_PROCESS_LMTT_INTRVL0.9550.9550.9581.0000.6650.0000.1180.559
HARVESTBFE_AGCHMPROCESS_INTRVL0.9550.9550.9580.6651.0000.0000.1830.591
HLSCT_NM0.0000.0000.0000.0000.0001.0000.3150.000
HLSCT_ADJST0.1970.1470.2220.1180.1830.3151.0000.259
NNMY_AFFC0.9310.9070.9140.5590.5910.0000.2591.000

Missing values

2023-12-11T12:22:45.923782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T12:22:46.125029image/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

YEARINSEDE_DRFSTFPRDUCT_ENG_NMPRDUCT_KOREAN_NMAGCHM_PROCESS_LMTT_INTRVLHARVESTBFE_AGCHMPROCESS_INTRVLHLSCT_NMHLSCT_ADJSTNNMY_AFFC
02016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일성충뿌리바구미-저
12016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일깍지벌레-저
22016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일가루깍지벌레-저
32016석유계 유분numerous슈퍼란12 시간0작용방식¹NR저
42016석유계 유분numerous슈퍼란12 시간0귤나무이+저
52016석유계 유분numerous슈퍼란12 시간0잎굴파리++,R저
62016석유계 유분numerous슈퍼란12 시간0녹응매++,R저
72016석유계 유분numerous슈퍼란12 시간0거미응애++저
82016석유계 유분numerous슈퍼란12 시간0성충뿌리바구미+(eggs)저
92016석유계 유분numerous슈퍼란12 시간0깍지벌레++,R저
YEARINSEDE_DRFSTFPRDUCT_ENG_NMPRDUCT_KOREAN_NMAGCHM_PROCESS_LMTT_INTRVLHARVESTBFE_AGCHMPROCESS_INTRVLHLSCT_NMHLSCT_ADJSTNNMY_AFFC
1662016이미다클로프리드 (잎)Provado 1.6F코니도12 시간0녹응매-중
1672016이미다클로프리드 (잎)Provado 1.6F코니도12 시간0거미응애-중
1682016이미다클로프리드 (잎)Provado 1.6F코니도12 시간0성충뿌리바구미-중
1692016이미다클로프리드 (잎)Provado 1.6F코니도12 시간0깍지벌레++중
1702016이미다클로프리드 (잎)Provado 1.6F코니도12 시간0가루깍지벌레+중
1712016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일작용방식¹18저
1722016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일귤나무이-저
1732016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일잎굴파리+++,R저
1742016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일녹응매-저
1752016메톡시페노자이드Intrepid 2F런너, 나방전문 등4 시간1 일거미응애-저