Overview

Dataset statistics

Number of variables3
Number of observations2071
Missing cells119
Missing cells (%)1.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory48.7 KiB
Average record size in memory24.1 B

Variable types

Categorical1
Text2

Dataset

Description식물검역 병해충정보로서 관리병균, 관리해충, 관리잡초에 대한 정보이며, 병해충 위험평가후 위원회에서 확정되면 업데이트
URLhttps://www.data.go.kr/data/15073134/fileData.do

Alerts

별표. is highly imbalanced (54.4%)Imbalance
Unnamed: 2 has 118 (5.7%) missing valuesMissing

Reproduction

Analysis started2023-12-12 16:00:48.916607
Analysis finished2023-12-12 16:00:49.413923
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

별표.
Categorical

IMBALANCE 

Distinct11
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size16.3 KiB
곤충
1442 
진균
318 
바이러스
 
100
응애
 
57
세균
 
54
Other values (6)
 
100

Length

Max length5
Median length2
Mean length2.1207146
Min length2

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row<NA>
2nd row구분
3rd row진균
4th row진균
5th row진균

Common Values

ValueCountFrequency (%)
곤충 1442
69.6%
진균 318
 
15.4%
바이러스 100
 
4.8%
응애 57
 
2.8%
세균 54
 
2.6%
잡초 35
 
1.7%
선충 33
 
1.6%
달팽이 21
 
1.0%
바이로이드 9
 
0.4%
<NA> 1
 
< 0.1%

Length

2023-12-13T01:00:49.495864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
곤충 1442
69.6%
진균 318
 
15.4%
바이러스 100
 
4.8%
응애 57
 
2.8%
세균 54
 
2.6%
잡초 35
 
1.7%
선충 33
 
1.6%
달팽이 21
 
1.0%
바이로이드 9
 
0.4%
na 1
 
< 0.1%

관리병해충(제2조 관련)
Text

Distinct2070
Distinct (%)100.0%
Missing1
Missing (%)< 0.1%
Memory size16.3 KiB
2023-12-13T01:00:49.777042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length347
Median length145
Mean length34.45314
Min length2

Characters and Unicode

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

Unique

Unique2070 ?
Unique (%)100.0%

Sample

1st row학명
2nd rowAcroconidiella tropaeoli (T.E.T. Bond) J.C. Lindq. & Alippi
3rd rowAlternaria triticina Prasada & Prabhu
4th rowAnisogramma anomala (Peck) E. Müll.
5th rowAphanomyces euteiches Drechsler
ValueCountFrequency (%)
401
 
4.8%
virus 101
 
1.2%
fabricius 90
 
1.1%
linnaeus 64
 
0.8%
walker 51
 
0.6%
et 36
 
0.4%
say 35
 
0.4%
cockerell 30
 
0.4%
leconte 27
 
0.3%
al 27
 
0.3%
Other values (4411) 7460
89.6%
2023-12-13T01:00:50.237781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
a 6158
 
8.6%
6150
 
8.6%
i 5354
 
7.5%
e 4890
 
6.9%
s 4454
 
6.2%
r 4339
 
6.1%
o 4100
 
5.7%
l 3396
 
4.8%
n 3289
 
4.6%
u 2948
 
4.1%
Other values (77) 26240
36.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 55167
77.4%
Space Separator 6150
 
8.6%
Uppercase Letter 5454
 
7.6%
Open Punctuation 1335
 
1.9%
Close Punctuation 1332
 
1.9%
Other Punctuation 1265
 
1.8%
Decimal Number 277
 
0.4%
Math Symbol 155
 
0.2%
Control 151
 
0.2%
Dash Punctuation 24
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 6158
11.2%
i 5354
9.7%
e 4890
 
8.9%
s 4454
 
8.1%
r 4339
 
7.9%
o 4100
 
7.4%
l 3396
 
6.2%
n 3289
 
6.0%
u 2948
 
5.3%
t 2924
 
5.3%
Other values (26) 13315
24.1%
Uppercase Letter
ValueCountFrequency (%)
C 578
 
10.6%
P 509
 
9.3%
S 459
 
8.4%
M 397
 
7.3%
B 350
 
6.4%
L 313
 
5.7%
D 303
 
5.6%
H 286
 
5.2%
A 284
 
5.2%
F 265
 
4.9%
Other values (16) 1710
31.4%
Decimal Number
ValueCountFrequency (%)
1 75
27.1%
9 57
20.6%
8 39
14.1%
7 24
 
8.7%
3 16
 
5.8%
0 15
 
5.4%
5 15
 
5.4%
4 14
 
5.1%
2 12
 
4.3%
6 10
 
3.6%
Other Letter
ValueCountFrequency (%)
단 2
25.0%
제 2
25.0%
외 2
25.0%
학 1
12.5%
명 1
12.5%
Other Punctuation
ValueCountFrequency (%)
. 895
70.8%
& 253
 
20.0%
, 114
 
9.0%
' 3
 
0.2%
Space Separator
ValueCountFrequency (%)
6150
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1335
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1332
100.0%
Math Symbol
ValueCountFrequency (%)
= 155
100.0%
Control
ValueCountFrequency (%)
151
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 24
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 60621
85.0%
Common 10689
 
15.0%
Hangul 8
 
< 0.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
a 6158
 
10.2%
i 5354
 
8.8%
e 4890
 
8.1%
s 4454
 
7.3%
r 4339
 
7.2%
o 4100
 
6.8%
l 3396
 
5.6%
n 3289
 
5.4%
u 2948
 
4.9%
t 2924
 
4.8%
Other values (52) 18769
31.0%
Common
ValueCountFrequency (%)
6150
57.5%
( 1335
 
12.5%
) 1332
 
12.5%
. 895
 
8.4%
& 253
 
2.4%
= 155
 
1.5%
151
 
1.4%
, 114
 
1.1%
1 75
 
0.7%
9 57
 
0.5%
Other values (10) 172
 
1.6%
Hangul
ValueCountFrequency (%)
단 2
25.0%
제 2
25.0%
외 2
25.0%
학 1
12.5%
명 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 71252
99.9%
None 58
 
0.1%
Hangul 8
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 6158
 
8.6%
6150
 
8.6%
i 5354
 
7.5%
e 4890
 
6.9%
s 4454
 
6.3%
r 4339
 
6.1%
o 4100
 
5.8%
l 3396
 
4.8%
n 3289
 
4.6%
u 2948
 
4.1%
Other values (62) 26174
36.7%
None
ValueCountFrequency (%)
é 20
34.5%
ü 18
31.0%
ö 8
 
13.8%
ë 3
 
5.2%
á 3
 
5.2%
ä 2
 
3.4%
å 1
 
1.7%
ý 1
 
1.7%
ó 1
 
1.7%
ø 1
 
1.7%
Hangul
ValueCountFrequency (%)
단 2
25.0%
제 2
25.0%
외 2
25.0%
학 1
12.5%
명 1
12.5%

Unnamed: 2
Text

MISSING 

Distinct523
Distinct (%)26.8%
Missing118
Missing (%)5.7%
Memory size16.3 KiB
2023-12-13T01:00:50.514193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length82
Median length47
Mean length17.579109
Min length1

Characters and Unicode

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

Unique

Unique383 ?
Unique (%)19.6%

Sample

1st row비고(일반명, 과명)
2nd rowLeaf spot
3rd rowLeaf blight
4th rowEastern filbert blight
5th rowRoot rot
ValueCountFrequency (%)
curculionidae(바구미과 154
 
5.9%
diaspididae(깍지벌레과 91
 
3.5%
pseudococcidae(가루깍지벌레과 79
 
3.0%
scolytidae(나무좀과 66
 
2.5%
cerambycidae(하늘소과 64
 
2.4%
tortricidae(잎말이나방과 61
 
2.3%
virus 56
 
2.1%
spot 54
 
2.1%
chrysomelidae(잎벌레과 52
 
2.0%
leaf 52
 
2.0%
Other values (583) 1884
72.1%
2023-12-13T01:00:50.998470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
i 2908
 
8.5%
e 2789
 
8.1%
a 2606
 
7.6%
d 2098
 
6.1%
( 1536
 
4.5%
) 1536
 
4.5%
과 1535
 
4.5%
o 1456
 
4.2%
r 1435
 
4.2%
c 1259
 
3.7%
Other values (231) 15174
44.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 21250
61.9%
Other Letter 7338
 
21.4%
Uppercase Letter 1944
 
5.7%
Open Punctuation 1536
 
4.5%
Close Punctuation 1536
 
4.5%
Space Separator 687
 
2.0%
Other Punctuation 20
 
0.1%
Dash Punctuation 16
 
< 0.1%
Modifier Symbol 2
 
< 0.1%
Final Punctuation 1
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
과 1535
20.9%
벌 466
 
6.4%
레 431
 
5.9%
나 364
 
5.0%
미 271
 
3.7%
방 255
 
3.5%
지 230
 
3.1%
깍 226
 
3.1%
구 203
 
2.8%
바 177
 
2.4%
Other values (170) 3180
43.3%
Lowercase Letter
ValueCountFrequency (%)
i 2908
13.7%
e 2789
13.1%
a 2606
12.3%
d 2098
9.9%
o 1456
 
6.9%
r 1435
 
6.8%
c 1259
 
5.9%
l 985
 
4.6%
t 958
 
4.5%
u 719
 
3.4%
Other values (16) 4037
19.0%
Uppercase Letter
ValueCountFrequency (%)
C 459
23.6%
P 232
11.9%
T 223
11.5%
A 169
 
8.7%
S 160
 
8.2%
D 125
 
6.4%
B 105
 
5.4%
L 81
 
4.2%
N 61
 
3.1%
F 56
 
2.9%
Other values (15) 273
14.0%
Other Punctuation
ValueCountFrequency (%)
, 15
75.0%
' 5
 
25.0%
Open Punctuation
ValueCountFrequency (%)
( 1536
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1536
100.0%
Space Separator
ValueCountFrequency (%)
687
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 2
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 1
100.0%
Control
ValueCountFrequency (%)
1
100.0%
Math Symbol
ValueCountFrequency (%)
= 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 23194
67.6%
Hangul 7338
 
21.4%
Common 3800
 
11.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
과 1535
20.9%
벌 466
 
6.4%
레 431
 
5.9%
나 364
 
5.0%
미 271
 
3.7%
방 255
 
3.5%
지 230
 
3.1%
깍 226
 
3.1%
구 203
 
2.8%
바 177
 
2.4%
Other values (170) 3180
43.3%
Latin
ValueCountFrequency (%)
i 2908
12.5%
e 2789
12.0%
a 2606
11.2%
d 2098
 
9.0%
o 1456
 
6.3%
r 1435
 
6.2%
c 1259
 
5.4%
l 985
 
4.2%
t 958
 
4.1%
u 719
 
3.1%
Other values (41) 5981
25.8%
Common
ValueCountFrequency (%)
( 1536
40.4%
) 1536
40.4%
687
18.1%
- 16
 
0.4%
, 15
 
0.4%
' 5
 
0.1%
` 2
 
0.1%
’ 1
 
< 0.1%
1
 
< 0.1%
= 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 26993
78.6%
Hangul 7338
 
21.4%
Punctuation 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
i 2908
 
10.8%
e 2789
 
10.3%
a 2606
 
9.7%
d 2098
 
7.8%
( 1536
 
5.7%
) 1536
 
5.7%
o 1456
 
5.4%
r 1435
 
5.3%
c 1259
 
4.7%
l 985
 
3.6%
Other values (50) 8385
31.1%
Hangul
ValueCountFrequency (%)
과 1535
20.9%
벌 466
 
6.4%
레 431
 
5.9%
나 364
 
5.0%
미 271
 
3.7%
방 255
 
3.5%
지 230
 
3.1%
깍 226
 
3.1%
구 203
 
2.8%
바 177
 
2.4%
Other values (170) 3180
43.3%
Punctuation
ValueCountFrequency (%)
’ 1
100.0%

Missing values

2023-12-13T01:00:49.180596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:00:49.261586image/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-13T01:00:49.353774image/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

별표.관리병해충(제2조 관련)Unnamed: 2
0<NA><NA><NA>
1구분학명비고(일반명, 과명)
2진균Acroconidiella tropaeoli (T.E.T. Bond) J.C. Lindq. & AlippiLeaf spot
3진균Alternaria triticina Prasada & PrabhuLeaf blight
4진균Anisogramma anomala (Peck) E. Müll.Eastern filbert blight
5진균Aphanomyces euteiches DrechslerRoot rot
6진균Apiosporina morbosa (Schwein.) Arx (= Dibotryon morbosum (Schwein.) Theiss. & Syd.)Black know
7진균Ascochyta corticola McAlpineBark boltch
8진균Ascochyta ligulariae Sawada<NA>
9진균Ascochyta sorghi Sacc.Rough leaf spot
별표.관리병해충(제2조 관련)Unnamed: 2
2061잡초Oenanthe pimpinelloidesCorky-fruited water-dropwort
2062잡초Onopordum acanthiumScotch thistle
2063잡초Orobanche spp.<NA>
2064잡초Rhaponticum repens (= Centaurea repens)Russian Knapweed
2065잡초Salvinia adnata (= Salvinia molesta)Karibaweed
2066잡초Senecio jacobaeaStinking willie
2067잡초Solanum elaeagnifoliumWhite horsenettle
2068잡초Striga spp.Witchweed
2069잡초Themeda quadrivalvisGrader grass
2070잡초Xanthium spinosumPrickly burweed