Overview

Dataset statistics

Number of variables29
Number of observations220
Missing cells897
Missing cells (%)14.1%
Duplicate rows76
Duplicate rows (%)34.5%
Total size in memory50.4 KiB
Average record size in memory234.6 B

Variable types

Unsupported26
Text3

Dataset

Description2022년 수출 동물, 수입 동물(합격), 수출 축산물 검역, 수입 축산물 검역실적(일반검역, 합격) 정보를 제공하기 위한 데이터
URLhttps://www.data.go.kr/data/15060794/fileData.do

Alerts

Dataset has 76 (34.5%) duplicate rowsDuplicates
Unnamed: 0 has 220 (100.0%) missing valuesMissing
2022년 수출동물 검역실적 has 213 (96.8%) missing valuesMissing
Unnamed: 2 has 196 (89.1%) missing valuesMissing
Unnamed: 3 has 12 (5.5%) missing valuesMissing
Unnamed: 4 has 220 (100.0%) missing valuesMissing
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 02:47:46.907708
Analysis finished2023-12-12 02:47:47.096485
Duration0.19 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing220
Missing (%)100.0%
Memory size2.1 KiB

2022년 수출동물 검역실적
Text

MISSING 

Distinct7
Distinct (%)100.0%
Missing213
Missing (%)96.8%
Memory size1.8 KiB
2023-12-12T11:47:47.182543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length5
Mean length4.1428571
Min length2

Characters and Unicode

Total characters29
Distinct characters22
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique7 ?
Unique (%)100.0%

Sample

1st row품목
2nd row포유류
3rd row조류
4th row기타동물
5th row비지정검역동물
ValueCountFrequency (%)
품목 1
14.3%
포유류 1
14.3%
조류 1
14.3%
기타동물 1
14.3%
비지정검역동물 1
14.3%
총계(마리 1
14.3%
총계(군 1
14.3%
2023-12-12T11:47:47.412215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
) 2
 
6.9%
류 2
 
6.9%
( 2
 
6.9%
계 2
 
6.9%
동 2
 
6.9%
물 2
 
6.9%
총 2
 
6.9%
품 1
 
3.4%
검 1
 
3.4%
리 1
 
3.4%
Other values (12) 12
41.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 25
86.2%
Close Punctuation 2
 
6.9%
Open Punctuation 2
 
6.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
류 2
 
8.0%
계 2
 
8.0%
동 2
 
8.0%
물 2
 
8.0%
총 2
 
8.0%
품 1
 
4.0%
검 1
 
4.0%
리 1
 
4.0%
마 1
 
4.0%
역 1
 
4.0%
Other values (10) 10
40.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 25
86.2%
Common 4
 
13.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
류 2
 
8.0%
계 2
 
8.0%
동 2
 
8.0%
물 2
 
8.0%
총 2
 
8.0%
품 1
 
4.0%
검 1
 
4.0%
리 1
 
4.0%
마 1
 
4.0%
역 1
 
4.0%
Other values (10) 10
40.0%
Common
ValueCountFrequency (%)
) 2
50.0%
( 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 25
86.2%
ASCII 4
 
13.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
) 2
50.0%
( 2
50.0%
Hangul
ValueCountFrequency (%)
류 2
 
8.0%
계 2
 
8.0%
동 2
 
8.0%
물 2
 
8.0%
총 2
 
8.0%
품 1
 
4.0%
검 1
 
4.0%
리 1
 
4.0%
마 1
 
4.0%
역 1
 
4.0%
Other values (10) 10
40.0%

Unnamed: 2
Text

MISSING 

Distinct18
Distinct (%)75.0%
Missing196
Missing (%)89.1%
Memory size1.8 KiB
2023-12-12T11:47:47.552883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length3.7083333
Min length1

Characters and Unicode

Total characters89
Distinct characters39
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16 ?
Unique (%)66.7%

Sample

1st row품명
2nd row소
3rd row말
4th row토끼
5th row곰
ValueCountFrequency (%)
품목계(마리 4
16.7%
품목계(군 4
16.7%
고양이 1
 
4.2%
거북 1
 
4.2%
햄스터 1
 
4.2%
마우스 1
 
4.2%
앵무새 1
 
4.2%
병아리 1
 
4.2%
품명 1
 
4.2%
개 1
 
4.2%
Other values (8) 8
33.3%
2023-12-12T11:47:47.827662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
품 9
 
10.1%
계 8
 
9.0%
( 8
 
9.0%
) 8
 
9.0%
목 8
 
9.0%
마 6
 
6.7%
리 5
 
5.6%
군 4
 
4.5%
이 2
 
2.2%
스 2
 
2.2%
Other values (29) 29
32.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 73
82.0%
Open Punctuation 8
 
9.0%
Close Punctuation 8
 
9.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
품 9
 
12.3%
계 8
 
11.0%
목 8
 
11.0%
마 6
 
8.2%
리 5
 
6.8%
군 4
 
5.5%
이 2
 
2.7%
스 2
 
2.7%
햄 1
 
1.4%
앵 1
 
1.4%
Other values (27) 27
37.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 73
82.0%
Common 16
 
18.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
품 9
 
12.3%
계 8
 
11.0%
목 8
 
11.0%
마 6
 
8.2%
리 5
 
6.8%
군 4
 
5.5%
이 2
 
2.7%
스 2
 
2.7%
햄 1
 
1.4%
앵 1
 
1.4%
Other values (27) 27
37.0%
Common
ValueCountFrequency (%)
( 8
50.0%
) 8
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 73
82.0%
ASCII 16
 
18.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
품 9
 
12.3%
계 8
 
11.0%
목 8
 
11.0%
마 6
 
8.2%
리 5
 
6.8%
군 4
 
5.5%
이 2
 
2.7%
스 2
 
2.7%
햄 1
 
1.4%
앵 1
 
1.4%
Other values (27) 27
37.0%
ASCII
ValueCountFrequency (%)
( 8
50.0%
) 8
50.0%

Unnamed: 3
Text

MISSING 

Distinct105
Distinct (%)50.5%
Missing12
Missing (%)5.5%
Memory size1.8 KiB
2023-12-12T11:47:48.128263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length8
Mean length3.6105769
Min length1

Characters and Unicode

Total characters751
Distinct characters146
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique31 ?
Unique (%)14.9%

Sample

1st row국가
2nd row네팔
3rd row아랍에미리트
4th row영국
5th row홍콩
ValueCountFrequency (%)
미국 9
 
4.2%
일본 6
 
2.8%
홍콩 5
 
2.3%
독일 4
 
1.9%
영국 4
 
1.9%
러시아 3
 
1.4%
말레이시아 3
 
1.4%
몽골 3
 
1.4%
폴란드 3
 
1.4%
아랍에미리트 3
 
1.4%
Other values (100) 171
79.9%
2023-12-12T11:47:48.498120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
아 56
 
7.5%
스 36
 
4.8%
국 26
 
3.5%
리 25
 
3.3%
르 23
 
3.1%
이 22
 
2.9%
라 16
 
2.1%
미 16
 
2.1%
트 13
 
1.7%
시 13
 
1.7%
Other values (136) 505
67.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 745
99.2%
Space Separator 5
 
0.7%
Control 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
아 56
 
7.5%
스 36
 
4.8%
국 26
 
3.5%
리 25
 
3.4%
르 23
 
3.1%
이 22
 
3.0%
라 16
 
2.1%
미 16
 
2.1%
트 13
 
1.7%
시 13
 
1.7%
Other values (134) 499
67.0%
Space Separator
ValueCountFrequency (%)
5
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 745
99.2%
Common 6
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
아 56
 
7.5%
스 36
 
4.8%
국 26
 
3.5%
리 25
 
3.4%
르 23
 
3.1%
이 22
 
3.0%
라 16
 
2.1%
미 16
 
2.1%
트 13
 
1.7%
시 13
 
1.7%
Other values (134) 499
67.0%
Common
ValueCountFrequency (%)
5
83.3%
1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 745
99.2%
ASCII 6
 
0.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
아 56
 
7.5%
스 36
 
4.8%
국 26
 
3.5%
리 25
 
3.4%
르 23
 
3.1%
이 22
 
3.0%
라 16
 
2.1%
미 16
 
2.1%
트 13
 
1.7%
시 13
 
1.7%
Other values (134) 499
67.0%
ASCII
ValueCountFrequency (%)
5
83.3%
1
 
16.7%

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing220
Missing (%)100.0%
Memory size2.1 KiB

Unnamed: 5
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 6
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 7
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 8
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 9
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 10
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 11
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 12
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 13
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 14
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 15
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 16
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 17
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 18
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 19
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 20
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 21
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 22
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 23
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 24
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 25
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 26
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Unnamed: 27
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.5%
Memory size1.8 KiB

Unnamed: 28
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.9%
Memory size1.8 KiB

Sample

Unnamed: 02022년 수출동물 검역실적Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28
0<NA><NA><NA><NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1<NA>품목품명국가<NA>2022.01NaN2022.02NaN2022.03NaN2022.04NaN2022.05NaN2022.06NaN2022.07NaN2022.08NaN2022.09NaN2022.1NaN2022.11NaN2022.12NaN
2<NA><NA><NA><NA><NA>건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)
3<NA>포유류소네팔<NA>----------------------8212
4<NA><NA>말아랍에미리트<NA>----------------------22
5<NA><NA><NA>영국<NA>----------------22------
6<NA><NA><NA>홍콩<NA>----------------22------
7<NA><NA><NA>일본<NA>----------------22------
8<NA><NA><NA>싱가포르<NA>----------------11------
9<NA><NA>토끼네덜란드<NA>------------11--11------
Unnamed: 02022년 수출동물 검역실적Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28
210<NA>비지정검역동물거북홍콩<NA>------150----135----------
211<NA><NA>도마뱀독일<NA>--------------------155--
212<NA><NA><NA>영국<NA>------------11----------
213<NA><NA><NA>홍콩<NA>------21451432912511391218128378210
214<NA><NA><NA>폴란드<NA>--------15--------------
215<NA><NA><NA>미국<NA>------110----127----------
216<NA><NA>품목계(마리)<NA><NA>------4746148291511413912181284133210
217<NA><NA>품목계(군)<NA><NA>------------------------
218<NA>총계(마리)<NA><NA><NA>161510984153964441655849616185716179616110205055872037687222289877193688721697831616305225413226850
219<NA>총계(군)<NA><NA><NA>------------------------

Duplicate rows

Most frequently occurring

2022년 수출동물 검역실적Unnamed: 2Unnamed: 3# duplicates
22<NA><NA>미국8
0<NA>품목계(군)<NA>4
1<NA>품목계(마리)<NA>4
40<NA><NA>영국4
74<NA><NA>홍콩4
16<NA><NA>러시아3
18<NA><NA>말레이시아3
37<NA><NA>싱가포르3
43<NA><NA>우즈베키스탄3
51<NA><NA>일본3