Overview

Dataset statistics

Number of variables29
Number of observations247
Missing cells1002
Missing cells (%)14.0%
Duplicate rows65
Duplicate rows (%)26.3%
Total size in memory56.6 KiB
Average record size in memory234.5 B

Variable types

Unsupported26
Text3

Dataset

Description수출·입 동물 및 축산물 검역실적, 불합격 정보를 제공하는 서비스
Author농림축산검역본부
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20181019000000000968

Alerts

Dataset has 65 (26.3%) duplicate rowsDuplicates
Unnamed: 0 has 247 (100.0%) missing valuesMissing
2019년 수출동물 검역실적 has 241 (97.6%) missing valuesMissing
Unnamed: 2 has 221 (89.5%) missing valuesMissing
Unnamed: 3 has 10 (4.0%) missing valuesMissing
Unnamed: 4 has 247 (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-11 03:44:52.184229
Analysis finished2023-12-11 03:44:52.508905
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing247
Missing (%)100.0%
Memory size2.3 KiB

2019년 수출동물 검역실적
Text

MISSING 

Distinct6
Distinct (%)100.0%
Missing241
Missing (%)97.6%
Memory size2.1 KiB
2023-12-11T12:44:52.652432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4.5
Mean length3.6666667
Min length2

Characters and Unicode

Total characters22
Distinct characters17
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

Unique6 ?
Unique (%)100.0%

Sample

1st row품목
2nd row포유류
3rd row조류
4th row기타동물
5th row총계(군)
ValueCountFrequency (%)
품목 1
16.7%
포유류 1
16.7%
조류 1
16.7%
기타동물 1
16.7%
총계(군 1
16.7%
총계(마리 1
16.7%
2023-12-11T12:44:53.088715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
) 2
 
9.1%
류 2
 
9.1%
( 2
 
9.1%
계 2
 
9.1%
총 2
 
9.1%
품 1
 
4.5%
물 1
 
4.5%
마 1
 
4.5%
군 1
 
4.5%
동 1
 
4.5%
Other values (7) 7
31.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 18
81.8%
Close Punctuation 2
 
9.1%
Open Punctuation 2
 
9.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
류 2
 
11.1%
계 2
 
11.1%
총 2
 
11.1%
품 1
 
5.6%
물 1
 
5.6%
마 1
 
5.6%
군 1
 
5.6%
동 1
 
5.6%
목 1
 
5.6%
타 1
 
5.6%
Other values (5) 5
27.8%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 18
81.8%
Common 4
 
18.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
류 2
 
11.1%
계 2
 
11.1%
총 2
 
11.1%
품 1
 
5.6%
물 1
 
5.6%
마 1
 
5.6%
군 1
 
5.6%
동 1
 
5.6%
목 1
 
5.6%
타 1
 
5.6%
Other values (5) 5
27.8%
Common
ValueCountFrequency (%)
) 2
50.0%
( 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 18
81.8%
ASCII 4
 
18.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
) 2
50.0%
( 2
50.0%
Hangul
ValueCountFrequency (%)
류 2
 
11.1%
계 2
 
11.1%
총 2
 
11.1%
품 1
 
5.6%
물 1
 
5.6%
마 1
 
5.6%
군 1
 
5.6%
동 1
 
5.6%
목 1
 
5.6%
타 1
 
5.6%
Other values (5) 5
27.8%

Unnamed: 2
Text

MISSING 

Distinct22
Distinct (%)84.6%
Missing221
Missing (%)89.5%
Memory size2.1 KiB
2023-12-11T12:44:53.356863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length3.5
Min length1

Characters and Unicode

Total characters91
Distinct characters52
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

Unique20 ?
Unique (%)76.9%

Sample

1st row품명
2nd row말
3rd row토끼
4th row너구리
5th row다람쥐
ValueCountFrequency (%)
품목계(마리 3
 
11.5%
품목계(군 3
 
11.5%
렛트 1
 
3.8%
햄스터 1
 
3.8%
마우스 1
 
3.8%
조류기타 1
 
3.8%
펭귄 1
 
3.8%
앵무새 1
 
3.8%
병아리 1
 
3.8%
닭 1
 
3.8%
Other values (12) 12
46.2%
2023-12-11T12:44:53.822005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
품 7
 
7.7%
계 6
 
6.6%
( 6
 
6.6%
) 6
 
6.6%
목 6
 
6.6%
리 5
 
5.5%
마 4
 
4.4%
아 3
 
3.3%
군 3
 
3.3%
기 2
 
2.2%
Other values (42) 43
47.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 79
86.8%
Open Punctuation 6
 
6.6%
Close Punctuation 6
 
6.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
품 7
 
8.9%
계 6
 
7.6%
목 6
 
7.6%
리 5
 
6.3%
마 4
 
5.1%
아 3
 
3.8%
군 3
 
3.8%
기 2
 
2.5%
스 2
 
2.5%
펭 1
 
1.3%
Other values (40) 40
50.6%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 79
86.8%
Common 12
 
13.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
품 7
 
8.9%
계 6
 
7.6%
목 6
 
7.6%
리 5
 
6.3%
마 4
 
5.1%
아 3
 
3.8%
군 3
 
3.8%
기 2
 
2.5%
스 2
 
2.5%
펭 1
 
1.3%
Other values (40) 40
50.6%
Common
ValueCountFrequency (%)
( 6
50.0%
) 6
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 79
86.8%
ASCII 12
 
13.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
품 7
 
8.9%
계 6
 
7.6%
목 6
 
7.6%
리 5
 
6.3%
마 4
 
5.1%
아 3
 
3.8%
군 3
 
3.8%
기 2
 
2.5%
스 2
 
2.5%
펭 1
 
1.3%
Other values (40) 40
50.6%
ASCII
ValueCountFrequency (%)
( 6
50.0%
) 6
50.0%

Unnamed: 3
Text

MISSING 

Distinct106
Distinct (%)44.7%
Missing10
Missing (%)4.0%
Memory size2.1 KiB
2023-12-11T12:44:54.180130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6
Mean length3.9409283
Min length1

Characters and Unicode

Total characters934
Distinct characters146
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

Unique43 ?
Unique (%)18.1%

Sample

1st row국 가
2nd row아랍에미리트
3rd row프랑스
4th row영국
5th row홍콩
ValueCountFrequency (%)
품명계(마리 19
 
7.9%
품명계(군 19
 
7.9%
미국 9
 
3.7%
중국 8
 
3.3%
일본 7
 
2.9%
프랑스 4
 
1.7%
영국 4
 
1.7%
우즈베키스탄 3
 
1.2%
말레이지아 3
 
1.2%
몽골 3
 
1.2%
Other values (100) 162
67.2%
2023-12-11T12:44:54.785029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
아 49
 
5.2%
리 42
 
4.5%
명 38
 
4.1%
) 38
 
4.1%
품 38
 
4.1%
( 38
 
4.1%
계 38
 
4.1%
스 34
 
3.6%
국 31
 
3.3%
마 28
 
3.0%
Other values (136) 560
60.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 853
91.3%
Close Punctuation 38
 
4.1%
Open Punctuation 38
 
4.1%
Space Separator 5
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
아 49
 
5.7%
리 42
 
4.9%
명 38
 
4.5%
품 38
 
4.5%
계 38
 
4.5%
스 34
 
4.0%
국 31
 
3.6%
마 28
 
3.3%
군 20
 
2.3%
이 18
 
2.1%
Other values (133) 517
60.6%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 853
91.3%
Common 81
 
8.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
아 49
 
5.7%
리 42
 
4.9%
명 38
 
4.5%
품 38
 
4.5%
계 38
 
4.5%
스 34
 
4.0%
국 31
 
3.6%
마 28
 
3.3%
군 20
 
2.3%
이 18
 
2.1%
Other values (133) 517
60.6%
Common
ValueCountFrequency (%)
) 38
46.9%
( 38
46.9%
5
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 853
91.3%
ASCII 81
 
8.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
아 49
 
5.7%
리 42
 
4.9%
명 38
 
4.5%
품 38
 
4.5%
계 38
 
4.5%
스 34
 
4.0%
국 31
 
3.6%
마 28
 
3.3%
군 20
 
2.3%
이 18
 
2.1%
Other values (133) 517
60.6%
ASCII
ValueCountFrequency (%)
) 38
46.9%
( 38
46.9%
5
 
6.2%

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing247
Missing (%)100.0%
Memory size2.3 KiB

Unnamed: 5
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 6
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 7
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 8
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 9
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 10
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 11
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 12
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 13
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 14
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 15
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 16
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 17
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 18
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 19
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 20
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 21
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 22
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 23
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 24
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 25
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 26
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Unnamed: 27
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.4%
Memory size2.1 KiB

Unnamed: 28
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.8%
Memory size2.1 KiB

Sample

Unnamed: 02019년 수출동물 검역실적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>2019.01NaN2019.02NaN2019.03NaN2019.04NaN2019.05NaN2019.06NaN2019.07NaN2019.08NaN2019.09NaN2019.10NaN2019.11NaN2019.12NaN
2<NA><NA><NA><NA><NA>건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)건수수량(마리,군)
3<NA>포유류말아랍에미리트<NA>----------------------44
4<NA><NA><NA>프랑스<NA>----------------11------
5<NA><NA><NA>영국<NA>----------------22------
6<NA><NA><NA>홍콩<NA>----------------22------
7<NA><NA><NA>미국<NA>------22--------6622--13
8<NA><NA><NA>품명계(마리)<NA>------22--------111122--57
9<NA><NA><NA>품명계(군)<NA>------------------------
Unnamed: 02019년 수출동물 검역실적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
237<NA><NA><NA>품명계(마리)<NA>120116--120120--120116112120120--
238<NA><NA><NA>품명계(군)<NA>------------------------
239<NA><NA>기니아피그태국<NA>------------12----------
240<NA><NA><NA>미국<NA>112----112--11112----112----
241<NA><NA><NA>품명계(마리)<NA>112----112--11214----112----
242<NA><NA><NA>품명계(군)<NA>------------------------
243<NA><NA>품목계(군)<NA><NA>------------------------
244<NA><NA>품목계(마리)<NA><NA>17137721110466910124151132613127581090959619884452121191915118331412902910880
245<NA>총계(군)<NA><NA><NA>------------------------
246<NA>총계(마리)<NA><NA><NA>15411563913241687113691189914251313813171687116501111615651247717186491146313802128013476127017045177713267

Duplicate rows

Most frequently occurring

2019년 수출동물 검역실적Unnamed: 2Unnamed: 3# duplicates
56<NA><NA>품명계(군)19
57<NA><NA>품명계(마리)19
20<NA><NA>미국8
34<NA><NA>영국4
41<NA><NA>일본4
58<NA><NA>프랑스4
0<NA>품목계(군)<NA>3
1<NA>품목계(마리)<NA>3
10<NA><NA>독일3
13<NA><NA>러시아3