Overview

Dataset statistics

Number of variables41
Number of observations165
Missing cells2019
Missing cells (%)29.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory53.0 KiB
Average record size in memory328.8 B

Variable types

Categorical4
Unsupported37

Dataset

Description가축위생방역지원본부_4_시도별축종품종별농가현황
Author가축위생방역지원본부
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20220713000000002157

Alerts

Unnamed: 1 has a high cardinality: 154 distinct values High cardinality
Unnamed: 22 has a high cardinality: 154 distinct values High cardinality
Unnamed: 1 has 10 (6.1%) missing values Missing
Unnamed: 3 has 2 (1.2%) missing values Missing
Unnamed: 4 has 2 (1.2%) missing values Missing
Unnamed: 5 has 31 (18.8%) missing values Missing
Unnamed: 6 has 22 (13.3%) missing values Missing
Unnamed: 7 has 21 (12.7%) missing values Missing
Unnamed: 8 has 24 (14.5%) missing values Missing
Unnamed: 9 has 72 (43.6%) missing values Missing
Unnamed: 10 has 110 (66.7%) missing values Missing
Unnamed: 11 has 153 (92.7%) missing values Missing
Unnamed: 12 has 146 (88.5%) missing values Missing
Unnamed: 13 has 140 (84.8%) missing values Missing
Unnamed: 14 has 2 (1.2%) missing values Missing
Unnamed: 15 has 30 (18.2%) missing values Missing
Unnamed: 16 has 34 (20.6%) missing values Missing
Unnamed: 17 has 2 (1.2%) missing values Missing
Unnamed: 18 has 118 (71.5%) missing values Missing
Unnamed: 19 has 88 (53.3%) missing values Missing
Unnamed: 20 has 116 (70.3%) missing values Missing
Unnamed: 22 has 10 (6.1%) missing values Missing
Unnamed: 23 has 7 (4.2%) missing values Missing
Unnamed: 24 has 91 (55.2%) missing values Missing
Unnamed: 25 has 160 (97.0%) missing values Missing
Unnamed: 26 has 130 (78.8%) missing values Missing
Unnamed: 27 has 8 (4.8%) missing values Missing
Unnamed: 28 has 58 (35.2%) missing values Missing
Unnamed: 29 has 4 (2.4%) missing values Missing
Unnamed: 30 has 97 (58.8%) missing values Missing
Unnamed: 31 has 7 (4.2%) missing values Missing
Unnamed: 32 has 15 (9.1%) missing values Missing
Unnamed: 33 has 8 (4.8%) missing values Missing
Unnamed: 34 has 98 (59.4%) missing values Missing
Unnamed: 35 has 14 (8.5%) missing values Missing
Unnamed: 36 has 44 (26.7%) missing values Missing
Unnamed: 37 has 16 (9.7%) missing values Missing
Unnamed: 38 has 88 (53.3%) missing values Missing
Unnamed: 39 has 4 (2.4%) missing values Missing
Unnamed: 40 has 35 (21.2%) missing values Missing
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 30 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 31 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 32 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 33 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 34 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 35 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 36 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 37 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 38 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 39 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 40 is an unsupported type, check if it needs cleaning or further analysis Unsupported

Reproduction

Analysis started2022-08-08 15:13:42.047313
Analysis finished2022-08-08 15:13:42.311474
Duration0.26 seconds
Software versionpandas-profiling v3.2.0
Download configurationconfig.json

Variables

Distinct20
Distinct (%)12.1%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
경기
31 
경북
23 
전남
22 
경남
18 
강원
18 
Other values (15)
53 

Length

Max length9
Median length2
Mean length2.036363636
Min length1

Unique

Unique11 ?
Unique (%)6.7%

Sample

1st row 나. 시·군별
2nd row시도
3rd row
4th row서울
5th row부산

Common Values

ValueCountFrequency (%)
경기31
18.8%
경북23
13.9%
전남22
13.3%
경남18
10.9%
강원18
10.9%
충남15
9.1%
전북14
8.5%
충북11
 
6.7%
제주2
 
1.2%
인천1
 
0.6%
Other values (10)10
 
6.1%

Length

2022-08-09T00:13:42.402670image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기31
18.7%
경북23
13.9%
전남22
13.3%
경남18
10.8%
강원18
10.8%
충남15
9.0%
전북14
8.4%
충북11
 
6.6%
제주2
 
1.2%
시·군별1
 
0.6%
Other values (11)11
 
6.6%

Unnamed: 1
Categorical

HIGH CARDINALITY
MISSING

Distinct154
Distinct (%)99.4%
Missing10
Missing (%)6.1%
Memory size1.4 KiB
고성군
 
2
영동군
 
1
부천시
 
1
하남시
 
1
의왕시
 
1
Other values (149)
149 

Length

Max length4
Median length3
Mean length3.019354839
Min length2

Unique

Unique153 ?
Unique (%)98.7%

Sample

1st row시군
2nd row수원시
3rd row성남시
4th row의정부시
5th row안양시

Common Values

ValueCountFrequency (%)
고성군2
 
1.2%
영동군1
 
0.6%
부천시1
 
0.6%
하남시1
 
0.6%
의왕시1
 
0.6%
군포시1
 
0.6%
수원시1
 
0.6%
성남시1
 
0.6%
의정부시1
 
0.6%
안양시1
 
0.6%
Other values (144)144
87.3%
(Missing)10
 
6.1%

Length

2022-08-09T00:13:42.557072image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
고성군2
 
1.3%
영암군1
 
0.6%
고흥군1
 
0.6%
경주시1
 
0.6%
보성군1
 
0.6%
화순군1
 
0.6%
장흥군1
 
0.6%
강진군1
 
0.6%
해남군1
 
0.6%
무안군1
 
0.6%
Other values (144)144
92.9%

Unnamed: 2
Unsupported

REJECTED
UNSUPPORTED

Missing1
Missing (%)0.6%
Memory size1.4 KiB

Unnamed: 3
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing2
Missing (%)1.2%
Memory size1.4 KiB

Unnamed: 4
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing2
Missing (%)1.2%
Memory size1.4 KiB

Unnamed: 5
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing31
Missing (%)18.8%
Memory size1.4 KiB

Unnamed: 6
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing22
Missing (%)13.3%
Memory size1.4 KiB

Unnamed: 7
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing21
Missing (%)12.7%
Memory size1.4 KiB

Unnamed: 8
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing24
Missing (%)14.5%
Memory size1.4 KiB

Unnamed: 9
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing72
Missing (%)43.6%
Memory size1.4 KiB

Unnamed: 10
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing110
Missing (%)66.7%
Memory size1.4 KiB

Unnamed: 11
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing153
Missing (%)92.7%
Memory size1.4 KiB

Unnamed: 12
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing146
Missing (%)88.5%
Memory size1.4 KiB

Unnamed: 13
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing140
Missing (%)84.8%
Memory size1.4 KiB

Unnamed: 14
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing2
Missing (%)1.2%
Memory size1.4 KiB

Unnamed: 15
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing30
Missing (%)18.2%
Memory size1.4 KiB

Unnamed: 16
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing34
Missing (%)20.6%
Memory size1.4 KiB

Unnamed: 17
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing2
Missing (%)1.2%
Memory size1.4 KiB

Unnamed: 18
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing118
Missing (%)71.5%
Memory size1.4 KiB

Unnamed: 19
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing88
Missing (%)53.3%
Memory size1.4 KiB

Unnamed: 20
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing116
Missing (%)70.3%
Memory size1.4 KiB

Unnamed: 21
Categorical

Distinct19
Distinct (%)11.6%
Missing1
Missing (%)0.6%
Memory size1.4 KiB
경기
31 
경북
23 
전남
22 
경남
18 
강원
18 
Other values (14)
52 

Length

Max length2
Median length2
Mean length1.993902439
Min length1

Unique

Unique10 ?
Unique (%)6.1%

Sample

1st row시도
2nd row
3rd row서울
4th row부산
5th row대구

Common Values

ValueCountFrequency (%)
경기31
18.8%
경북23
13.9%
전남22
13.3%
경남18
10.9%
강원18
10.9%
충남15
9.1%
전북14
8.5%
충북11
 
6.7%
제주2
 
1.2%
인천1
 
0.6%
Other values (9)9
 
5.5%

Length

2022-08-09T00:13:42.741301image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기31
18.9%
경북23
14.0%
전남22
13.4%
경남18
11.0%
강원18
11.0%
충남15
9.1%
전북14
8.5%
충북11
 
6.7%
제주2
 
1.2%
광주1
 
0.6%
Other values (9)9
 
5.5%

Unnamed: 22
Categorical

HIGH CARDINALITY
MISSING

Distinct154
Distinct (%)99.4%
Missing10
Missing (%)6.1%
Memory size1.4 KiB
고성군
 
2
영동군
 
1
부천시
 
1
하남시
 
1
의왕시
 
1
Other values (149)
149 

Length

Max length4
Median length3
Mean length3.019354839
Min length2

Unique

Unique153 ?
Unique (%)98.7%

Sample

1st row시군
2nd row수원시
3rd row성남시
4th row의정부시
5th row안양시

Common Values

ValueCountFrequency (%)
고성군2
 
1.2%
영동군1
 
0.6%
부천시1
 
0.6%
하남시1
 
0.6%
의왕시1
 
0.6%
군포시1
 
0.6%
수원시1
 
0.6%
성남시1
 
0.6%
의정부시1
 
0.6%
안양시1
 
0.6%
Other values (144)144
87.3%
(Missing)10
 
6.1%

Length

2022-08-09T00:13:42.835295image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
고성군2
 
1.3%
영암군1
 
0.6%
고흥군1
 
0.6%
경주시1
 
0.6%
보성군1
 
0.6%
화순군1
 
0.6%
장흥군1
 
0.6%
강진군1
 
0.6%
해남군1
 
0.6%
무안군1
 
0.6%
Other values (144)144
92.9%

Unnamed: 23
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing7
Missing (%)4.2%
Memory size1.4 KiB

Unnamed: 24
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing91
Missing (%)55.2%
Memory size1.4 KiB

Unnamed: 25
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing160
Missing (%)97.0%
Memory size1.4 KiB

Unnamed: 26
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing130
Missing (%)78.8%
Memory size1.4 KiB

Unnamed: 27
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing8
Missing (%)4.8%
Memory size1.4 KiB

Unnamed: 28
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing58
Missing (%)35.2%
Memory size1.4 KiB

Unnamed: 29
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing4
Missing (%)2.4%
Memory size1.4 KiB

Unnamed: 30
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing97
Missing (%)58.8%
Memory size1.4 KiB

Unnamed: 31
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing7
Missing (%)4.2%
Memory size1.4 KiB

Unnamed: 32
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing15
Missing (%)9.1%
Memory size1.4 KiB

Unnamed: 33
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing8
Missing (%)4.8%
Memory size1.4 KiB

Unnamed: 34
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing98
Missing (%)59.4%
Memory size1.4 KiB

Unnamed: 35
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing14
Missing (%)8.5%
Memory size1.4 KiB

Unnamed: 36
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing44
Missing (%)26.7%
Memory size1.4 KiB

Unnamed: 37
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing16
Missing (%)9.7%
Memory size1.4 KiB

Unnamed: 38
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing88
Missing (%)53.3%
Memory size1.4 KiB

Unnamed: 39
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing4
Missing (%)2.4%
Memory size1.4 KiB

Unnamed: 40
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing35
Missing (%)21.2%
Memory size1.4 KiB

Sample

First rows

* 편집참조 : 시도를 셀병합 부탁드려요, 펼쳤을때 좌우 양쪽으로 배치될 수 있도록 2페이지로 구성요망Unnamed: 1Unnamed: 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: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38Unnamed: 39Unnamed: 40
0나. 시·군별<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN(단위 :호)
1시도시군합계한우*젖소*육우*돼지일반돼지*종돈*흑돼지*멧돼지*실험돼지*미니피그*산란계*육계*토종닭*백세미*종계*산란중추*시도시군오리*육용오리*산란오리*종오리*오리기타*산양염소면양사슴칠면조거위메추리관상조기러기타조꿀벌
2<NA>207571102890967845007436454685048205160221827666181181281762095188378134<NA>23047503811482239128131231649134023111191114539160411372531074
3서울<NA>53211NaNNaNNaNNaNNaNNaNNaNNaN29NaNNaN29NaNNaNNaN서울<NA>1NaNNaNNaN1NaNNaNNaN213NaN9NaNNaNNaN6NaN
4부산<NA>65410092841010NaNNaNNaNNaNNaN342NaN2340NaNNaNNaN부산<NA>271NaNNaN26NaN64NaN91027110819NaN243
5대구<NA>14174864661033871NaNNaNNaNNaN6465NaN641NaNNaNNaN대구<NA>15NaNNaNNaN1518018122711216241736
6인천<NA>2085635525471051313NaNNaNNaNNaNNaN8871116856NaN4NaN인천<NA>433NaNNaN4071625253250516633215212
7광주<NA>3551711657777NaNNaNNaNNaNNaN11531111NaNNaNNaN광주<NA>93NaNNaN6NaN26142312NaN4NaN91
8대전<NA>531174174NaN122NaNNaNNaNNaNNaN220NaNNaN21721NaN대전<NA>7NaNNaNNaN714613615NaN1018NaN334
9울산<NA>36931721170613121814NaN12NaN113388NaN1330NaNNaNNaN울산<NA>501NaNNaN4931742272472226346121327

Last rows

* 편집참조 : 시도를 셀병합 부탁드려요, 펼쳤을때 좌우 양쪽으로 배치될 수 있도록 2페이지로 구성요망Unnamed: 1Unnamed: 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: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38Unnamed: 39Unnamed: 40
155경남창녕군1333791773171125251NaNNaNNaNNaN3791131334NaNNaN3경남창녕군145NaNNaN9154147211917NaN162
156경남고성군1683923875421444394NaNNaNNaN1442413424NaNNaN1경남고성군9NaNNaNNaN91149NaN128162202121393
157경남남해군15127137058166NaNNaNNaNNaNNaN44011438NaNNaNNaN경남남해군5NaNNaNNaN522713358NaN51103325
158경남하동군15475905701741814211NaNNaN64342637NaNNaNNaN경남하동군133NaNNaN1021591101622NaN75201373
159경남산청군170661759912832153113NaNNaN7562511720NaNNaNNaN경남산청군182NaNNaN161163117819364203353
160경남함양군1311553539910332417NaN1NaN520106505NaNNaNNaN경남함양군217NaN311292NaN101013NaN9217NaN29NaN
161경남거창군2586121612089172524NaNNaN1NaNNaN1014155991NaN12경남거창군5927NaN926NaN126NaN12326NaN86192601
162경남합천군336717391739NaN3827363NaNNaNNaN113012151100NaN21경남합천군194NaNNaN161159NaN81335NaN51034NaN1275
163제주제주시14815054692738178139334NaN111772726123NaN1NaN제주제주시141NaNNaN1363472051111236278422
164제주서귀포시814340336367657216NaNNaN1814106511NaN제주서귀포시128NaNNaN43182446NaN3551118136