Overview

Dataset statistics

Number of variables8
Number of observations385
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory24.6 KiB
Average record size in memory65.3 B

Variable types

Categorical4
DateTime2
Text2

Dataset

Description제주특별자치도에서 제공하는 주요 농작물 병해충 발생 및 방제와 관련한 데이터로 농작물명, 병해충유형, 방제약, 상세정보 등의 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15056329/fileData.do

Alerts

연도 has constant value ""Constant
데이터기준일자 has constant value ""Constant
분류 is highly overall correlated with 농작물명High correlation
농작물명 is highly overall correlated with 분류High correlation

Reproduction

Analysis started2023-12-12 07:53:49.681398
Analysis finished2023-12-12 07:53:50.431081
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
2022
385 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2022 385
100.0%

Length

2023-12-12T16:53:50.500787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:53:50.584140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 385
100.0%

호수
Categorical

Distinct18
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
제16호
39 
제14호
33 
제17호
29 
제15호
29 
제9호
25 
Other values (13)
230 

Length

Max length4
Median length4
Mean length3.5818182
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제1호
2nd row제1호
3rd row제1호
4th row제1호
5th row제1호

Common Values

ValueCountFrequency (%)
제16호 39
 
10.1%
제14호 33
 
8.6%
제17호 29
 
7.5%
제15호 29
 
7.5%
제9호 25
 
6.5%
제13호 24
 
6.2%
제5호 20
 
5.2%
제8호 19
 
4.9%
제11호 19
 
4.9%
제18호 19
 
4.9%
Other values (8) 129
33.5%

Length

2023-12-12T16:53:50.677098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제16호 39
 
10.1%
제14호 33
 
8.6%
제17호 29
 
7.5%
제15호 29
 
7.5%
제9호 25
 
6.5%
제13호 24
 
6.2%
제5호 20
 
5.2%
제11호 19
 
4.9%
제18호 19
 
4.9%
제8호 19
 
4.9%
Other values (8) 129
33.5%

발표일
Date

Distinct18
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
Minimum2022-02-21 00:00:00
Maximum2022-12-16 00:00:00
2023-12-12T16:53:50.801203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:53:50.899554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

분류
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
채소
205 
감귤
101 
밭작물
47 
키위
 
10
시설채소
 
10
Other values (3)
 
12

Length

Max length4
Median length2
Mean length2.187013
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row감귤
2nd row감귤
3rd row감귤
4th row키위
5th row키위

Common Values

ValueCountFrequency (%)
채소 205
53.2%
감귤 101
26.2%
밭작물 47
 
12.2%
키위 10
 
2.6%
시설채소 10
 
2.6%
감자 5
 
1.3%
감귤류 5
 
1.3%
보리 2
 
0.5%

Length

2023-12-12T16:53:51.054079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:53:51.207335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
채소 205
53.2%
감귤 101
26.2%
밭작물 47
 
12.2%
키위 10
 
2.6%
시설채소 10
 
2.6%
감자 5
 
1.3%
감귤류 5
 
1.3%
보리 2
 
0.5%

농작물명
Categorical

HIGH CORRELATION 

Distinct41
Distinct (%)10.6%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
노지감귤
43 
마늘
27 
하우스감귤(만감류)
 
22
배추
 
21
토마토
 
20
Other values (36)
252 

Length

Max length10
Median length9
Mean length3.3298701
Min length1

Unique

Unique5 ?
Unique (%)1.3%

Sample

1st row하우스감귤
2nd row하우스감귤
3rd row만감류
4th row키위
5th row키위

Common Values

ValueCountFrequency (%)
노지감귤 43
 
11.2%
마늘 27
 
7.0%
하우스감귤(만감류) 22
 
5.7%
배추 21
 
5.5%
토마토 20
 
5.2%
무 19
 
4.9%
브로콜리 17
 
4.4%
만감류 16
 
4.2%
양배추 16
 
4.2%
고추 16
 
4.2%
Other values (31) 168
43.6%

Length

2023-12-12T16:53:51.396231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
노지감귤 43
 
11.2%
마늘 27
 
7.0%
하우스감귤(만감류 22
 
5.7%
배추 21
 
5.5%
토마토 20
 
5.2%
무 19
 
4.9%
브로콜리 17
 
4.4%
만감류 16
 
4.2%
양배추 16
 
4.2%
고추 16
 
4.2%
Other values (31) 168
43.6%

병해충유형
Text

Distinct84
Distinct (%)21.8%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
2023-12-12T16:53:51.656121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length4.4441558
Min length2

Characters and Unicode

Total characters1711
Distinct characters116
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

Unique25 ?
Unique (%)6.5%

Sample

1st row잿빛곰팡이병
2nd row응애
3rd row저장병
4th row경종적방제
5th row깍지벌레류
ValueCountFrequency (%)
잿빛곰팡이병 23
 
6.0%
총채벌레 22
 
5.7%
배추좀나방 20
 
5.2%
역병 20
 
5.2%
파밤나방 18
 
4.7%
벼룩잎벌레 16
 
4.2%
귤응애 15
 
3.9%
노균병 14
 
3.6%
흰가루병 10
 
2.6%
녹병 9
 
2.3%
Other values (74) 218
56.6%
2023-12-12T16:53:52.213471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
병 172
 
10.1%
나 74
 
4.3%
방 68
 
4.0%
벌 61
 
3.6%
애 54
 
3.2%
레 54
 
3.2%
응 51
 
3.0%
이 51
 
3.0%
잎 49
 
2.9%
무 39
 
2.3%
Other values (106) 1038
60.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1691
98.8%
Math Symbol 9
 
0.5%
Open Punctuation 4
 
0.2%
Close Punctuation 4
 
0.2%
Other Punctuation 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
병 172
 
10.2%
나 74
 
4.4%
방 68
 
4.0%
벌 61
 
3.6%
애 54
 
3.2%
레 54
 
3.2%
응 51
 
3.0%
이 51
 
3.0%
잎 49
 
2.9%
무 39
 
2.3%
Other values (101) 1018
60.2%
Other Punctuation
ValueCountFrequency (%)
· 2
66.7%
/ 1
33.3%
Math Symbol
ValueCountFrequency (%)
+ 9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1691
98.8%
Common 20
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
병 172
 
10.2%
나 74
 
4.4%
방 68
 
4.0%
벌 61
 
3.6%
애 54
 
3.2%
레 54
 
3.2%
응 51
 
3.0%
이 51
 
3.0%
잎 49
 
2.9%
무 39
 
2.3%
Other values (101) 1018
60.2%
Common
ValueCountFrequency (%)
+ 9
45.0%
( 4
20.0%
) 4
20.0%
· 2
 
10.0%
/ 1
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1691
98.8%
ASCII 18
 
1.1%
None 2
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
병 172
 
10.2%
나 74
 
4.4%
방 68
 
4.0%
벌 61
 
3.6%
애 54
 
3.2%
레 54
 
3.2%
응 51
 
3.0%
이 51
 
3.0%
잎 49
 
2.9%
무 39
 
2.3%
Other values (101) 1018
60.2%
ASCII
ValueCountFrequency (%)
+ 9
50.0%
( 4
22.2%
) 4
22.2%
/ 1
 
5.6%
None
ValueCountFrequency (%)
· 2
100.0%

방제약
Text

Distinct277
Distinct (%)71.9%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
2023-12-12T16:53:52.575726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length37
Mean length27.436364
Min length5

Characters and Unicode

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

Unique

Unique212 ?
Unique (%)55.1%

Sample

1st row살림꾼(액수)·유닉스(입수)·카브리오(유)·후론사이트(수) 등
2nd row가네마이트(액수)·노블레스(액수)·아크라마이트(액수)·응애단(유)·코드원(액수) 등
3rd row벨쿠트(수)·스포르곤(수)·해비치(입수) 등
4th row전정 후 상처부위에 톱신페스트 도포
5th row기계유(유) 40~50배
ValueCountFrequency (%)
등 356
44.3%
벨스모(유)·엑설트(액수)·엘산(유)·토리치(분액 8
 
1.0%
나방스타(유)·동작그만(유)·런너(유)·베네비아(유수 8
 
1.0%
미네토스타(입수)·슈페리온(미탁)·애니충(액수 6
 
0.7%
노블레스(액수)·마이트킹(액수)·비수(액수)·진격(액수 5
 
0.6%
세배로(유)·적시타(유)·타스타(유)·피레스(유 5
 
0.6%
나방스타(유)·네이팜(유)·델리게이트(입수)·런너(액수)·벨스모(유 4
 
0.5%
비수(액수)·산마루(수)·엔젤팜(액수)·잭팟(액수 4
 
0.5%
델란케이(수)·타미나(수 4
 
0.5%
라이몬(액수)·벨스모(유)·타스타(수)·토리치(분액)·에이팜(유 4
 
0.5%
Other values (310) 400
49.8%
2023-12-12T16:53:53.042576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 1268
 
12.0%
) 1268
 
12.0%
수 957
 
9.1%
· 893
 
8.5%
액 545
 
5.2%
419
 
4.0%
등 356
 
3.4%
스 270
 
2.6%
유 259
 
2.5%
이 169
 
1.6%
Other values (316) 4159
39.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6638
62.8%
Open Punctuation 1268
 
12.0%
Close Punctuation 1268
 
12.0%
Other Punctuation 899
 
8.5%
Space Separator 419
 
4.0%
Decimal Number 52
 
0.5%
Math Symbol 10
 
0.1%
Uppercase Letter 6
 
0.1%
Dash Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
수 957
 
14.4%
액 545
 
8.2%
등 356
 
5.4%
스 270
 
4.1%
유 259
 
3.9%
이 169
 
2.5%
입 163
 
2.5%
리 156
 
2.4%
트 154
 
2.3%
타 116
 
1.7%
Other values (297) 3493
52.6%
Decimal Number
ValueCountFrequency (%)
0 18
34.6%
5 11
21.2%
4 11
21.2%
2 5
 
9.6%
1 3
 
5.8%
8 2
 
3.8%
3 2
 
3.8%
Other Punctuation
ValueCountFrequency (%)
· 893
99.3%
. 3
 
0.3%
% 2
 
0.2%
/ 1
 
0.1%
Math Symbol
ValueCountFrequency (%)
+ 5
50.0%
~ 5
50.0%
Uppercase Letter
ValueCountFrequency (%)
S 3
50.0%
G 3
50.0%
Open Punctuation
ValueCountFrequency (%)
( 1268
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1268
100.0%
Space Separator
ValueCountFrequency (%)
419
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6638
62.8%
Common 3919
37.1%
Latin 6
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
수 957
 
14.4%
액 545
 
8.2%
등 356
 
5.4%
스 270
 
4.1%
유 259
 
3.9%
이 169
 
2.5%
입 163
 
2.5%
리 156
 
2.4%
트 154
 
2.3%
타 116
 
1.7%
Other values (297) 3493
52.6%
Common
ValueCountFrequency (%)
( 1268
32.4%
) 1268
32.4%
· 893
22.8%
419
 
10.7%
0 18
 
0.5%
5 11
 
0.3%
4 11
 
0.3%
+ 5
 
0.1%
2 5
 
0.1%
~ 5
 
0.1%
Other values (7) 16
 
0.4%
Latin
ValueCountFrequency (%)
S 3
50.0%
G 3
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6638
62.8%
ASCII 3032
28.7%
None 893
 
8.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 1268
41.8%
) 1268
41.8%
419
 
13.8%
0 18
 
0.6%
5 11
 
0.4%
4 11
 
0.4%
+ 5
 
0.2%
2 5
 
0.2%
~ 5
 
0.2%
. 3
 
0.1%
Other values (8) 19
 
0.6%
Hangul
ValueCountFrequency (%)
수 957
 
14.4%
액 545
 
8.2%
등 356
 
5.4%
스 270
 
4.1%
유 259
 
3.9%
이 169
 
2.5%
입 163
 
2.5%
리 156
 
2.4%
트 154
 
2.3%
타 116
 
1.7%
Other values (297) 3493
52.6%
None
ValueCountFrequency (%)
· 893
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
Minimum2022-12-16 00:00:00
Maximum2022-12-16 00:00:00
2023-12-12T16:53:53.155020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:53:53.234908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T16:53:53.298872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
호수발표일분류농작물명병해충유형
호수1.0001.0000.5940.8210.633
발표일1.0001.0000.5940.8210.633
분류0.5940.5941.0000.9750.844
농작물명0.8210.8210.9751.0000.930
병해충유형0.6330.6330.8440.9301.000
2023-12-12T16:53:53.405808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분류농작물명호수
분류1.0000.8030.294
농작물명0.8031.0000.351
호수0.2940.3511.000
2023-12-12T16:53:53.498725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
호수분류농작물명
호수1.0000.2940.351
분류0.2941.0000.803
농작물명0.3510.8031.000

Missing values

2023-12-12T16:53:50.272191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:53:50.379984image/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

연도호수발표일분류농작물명병해충유형방제약데이터기준일자
02022제1호2022-02-21감귤하우스감귤잿빛곰팡이병살림꾼(액수)·유닉스(입수)·카브리오(유)·후론사이트(수) 등2022-12-16
12022제1호2022-02-21감귤하우스감귤응애가네마이트(액수)·노블레스(액수)·아크라마이트(액수)·응애단(유)·코드원(액수) 등2022-12-16
22022제1호2022-02-21감귤만감류저장병벨쿠트(수)·스포르곤(수)·해비치(입수) 등2022-12-16
32022제1호2022-02-21키위키위경종적방제전정 후 상처부위에 톱신페스트 도포2022-12-16
42022제1호2022-02-21키위키위깍지벌레류기계유(유) 40~50배2022-12-16
52022제1호2022-02-21채소마늘세균점무늬병델란케이(수)·타미나(수) 등2022-12-16
62022제1호2022-02-21채소마늘흑색썩음균핵병벨리스플러스(입수)· 살림꾼(액수)· 카스텔란(수) 등2022-12-16
72022제1호2022-02-21채소마늘잎집썩음병메가폰(입수)· 아무러(수)· 용마루(수용)· 일품(수) 등2022-12-16
82022제1호2022-02-21채소양파노균병명작(액수)· 오티바(액수)· 젬프로(액수)· 텔루스(액수) 등2022-12-16
92022제1호2022-02-21채소양파잿빛곰팡이병금모리(액수)· 미토스(액수)· 차단(액수)· 크린캡(유제)2022-12-16
연도호수발표일분류농작물명병해충유형방제약데이터기준일자
3752022제18호2022-12-16채소쪽파파총채벌레갤럭시(유)·모스피란(수)·엑설트(액수)·제라진(유) 등2022-12-16
3762022제18호2022-12-16채소양배추검은썩음병메가폰(입수)·비천무(입수)·용마루(수용) 등2022-12-16
3772022제18호2022-12-16채소브로콜리노균병카브리오(유)·캐스팅(액수)·텔루스(액수) 등2022-12-16
3782022제18호2022-12-16채소무노균병카브리오(유)·캐스팅(액수)·텔루스(액수) 등2022-12-16
3792022제18호2022-12-16채소시설토마토잎곰팡이병사파이어(액수)·차단(액수)·카디스(액수) 등2022-12-16
3802022제18호2022-12-16채소시설토마토잿빛곰팡이병사파이어(액수)·차단(액수)·카디스(액수) 등2022-12-16
3812022제18호2022-12-16채소시설토마토가루이류골드윈(액수)·당찬(액수)·모벤토(액수)·오신(수) 등2022-12-16
3822022제18호2022-12-16채소시설딸기잿빛곰팡이병사파이어(액수)·머니업(수)·코리스(액수) 등2022-12-16
3832022제18호2022-12-16채소시설딸기흰가루병보가드(입수)·스트로비(액수)·캐스팅(액수) 등2022-12-16
3842022제18호2022-12-16채소시설딸기총채벌레엑설트(액수)·오신(수)·제왕(액수)·팬텀(입수) 등2022-12-16