Overview

Dataset statistics

Number of variables19
Number of observations29
Missing cells113
Missing cells (%)20.5%
Duplicate rows1
Duplicate rows (%)3.4%
Total size in memory4.4 KiB
Average record size in memory156.6 B

Variable types

Text3
Unsupported16

Dataset

Description462018년농지전용허가협의신고현황공공빅데이터
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202030

Alerts

Dataset has 1 (3.4%) duplicate rowsDuplicates
2018년 농지전용허가(협의·신고) 현황 has 23 (79.3%) missing valuesMissing
Unnamed: 1 has 26 (89.7%) missing valuesMissing
Unnamed: 2 has 5 (17.2%) missing valuesMissing
Unnamed: 3 has 4 (13.8%) missing valuesMissing
Unnamed: 4 has 3 (10.3%) missing valuesMissing
Unnamed: 5 has 4 (13.8%) missing valuesMissing
Unnamed: 6 has 4 (13.8%) missing valuesMissing
Unnamed: 7 has 3 (10.3%) missing valuesMissing
Unnamed: 8 has 4 (13.8%) missing valuesMissing
Unnamed: 9 has 4 (13.8%) missing valuesMissing
Unnamed: 10 has 3 (10.3%) missing valuesMissing
Unnamed: 11 has 4 (13.8%) missing valuesMissing
Unnamed: 12 has 4 (13.8%) missing valuesMissing
Unnamed: 13 has 3 (10.3%) missing valuesMissing
Unnamed: 14 has 4 (13.8%) missing valuesMissing
Unnamed: 15 has 4 (13.8%) missing valuesMissing
Unnamed: 16 has 3 (10.3%) missing valuesMissing
Unnamed: 17 has 4 (13.8%) missing valuesMissing
Unnamed: 18 has 4 (13.8%) missing valuesMissing
Unnamed: 3 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

Reproduction

Analysis started2024-03-14 02:18:06.096321
Analysis finished2024-03-14 02:18:06.907944
Duration0.81 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2018년 농지전용허가(협의·신고) 현황
Text

MISSING 

Distinct6
Distinct (%)100.0%
Missing23
Missing (%)79.3%
Memory size364.0 B
2024-03-14T11:18:07.007686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length9.5
Mean length15.5
Min length3

Characters and Unicode

Total characters93
Distinct characters54
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks3 ?
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 (%)
전 2
 
7.7%
용 2
 
7.7%
의 2
 
7.7%
수정될수 1
 
3.8%
일부 1
 
3.8%
자료는 1
 
3.8%
발표전으로 1
 
3.8%
최종 1
 
3.8%
농식품부(한국농어촌공사 1
 
3.8%
2018년도 1
 
3.8%
Other values (13) 13
50.0%
2024-03-14T11:18:07.274892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
  13
 
14.0%
12
 
12.9%
10
 
10.8%
전 3
 
3.2%
부 2
 
2.2%
수 2
 
2.2%
농 2
 
2.2%
의 2
 
2.2%
용 2
 
2.2%
정 1
 
1.1%
Other values (44) 44
47.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 49
52.7%
Space Separator 23
24.7%
Control 12
 
12.9%
Decimal Number 4
 
4.3%
Other Punctuation 3
 
3.2%
Close Punctuation 1
 
1.1%
Open Punctuation 1
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 3
 
6.1%
부 2
 
4.1%
수 2
 
4.1%
농 2
 
4.1%
의 2
 
4.1%
용 2
 
4.1%
정 1
 
2.0%
표 1
 
2.0%
공 1
 
2.0%
다 1
 
2.0%
Other values (32) 32
65.3%
Decimal Number
ValueCountFrequency (%)
2 1
25.0%
0 1
25.0%
1 1
25.0%
8 1
25.0%
Other Punctuation
ValueCountFrequency (%)
· 1
33.3%
* 1
33.3%
. 1
33.3%
Space Separator
ValueCountFrequency (%)
  13
56.5%
10
43.5%
Control
ValueCountFrequency (%)
12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 49
52.7%
Common 44
47.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 3
 
6.1%
부 2
 
4.1%
수 2
 
4.1%
농 2
 
4.1%
의 2
 
4.1%
용 2
 
4.1%
정 1
 
2.0%
표 1
 
2.0%
공 1
 
2.0%
다 1
 
2.0%
Other values (32) 32
65.3%
Common
ValueCountFrequency (%)
  13
29.5%
12
27.3%
10
22.7%
) 1
 
2.3%
· 1
 
2.3%
* 1
 
2.3%
2 1
 
2.3%
0 1
 
2.3%
1 1
 
2.3%
8 1
 
2.3%
Other values (2) 2
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 49
52.7%
ASCII 30
32.3%
None 14
 
15.1%

Most frequent character per block

None
ValueCountFrequency (%)
  13
92.9%
· 1
 
7.1%
ASCII
ValueCountFrequency (%)
12
40.0%
10
33.3%
) 1
 
3.3%
* 1
 
3.3%
2 1
 
3.3%
0 1
 
3.3%
1 1
 
3.3%
8 1
 
3.3%
( 1
 
3.3%
. 1
 
3.3%
Hangul
ValueCountFrequency (%)
전 3
 
6.1%
부 2
 
4.1%
수 2
 
4.1%
농 2
 
4.1%
의 2
 
4.1%
용 2
 
4.1%
정 1
 
2.0%
표 1
 
2.0%
공 1
 
2.0%
다 1
 
2.0%
Other values (32) 32
65.3%

Unnamed: 1
Text

MISSING 

Distinct3
Distinct (%)100.0%
Missing26
Missing (%)89.7%
Memory size364.0 B
2024-03-14T11:18:07.430044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length5
Min length1

Characters and Unicode

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

Unique

Unique3 ?
Unique (%)100.0%

Sample

1st row계
2nd row공 공 부 문
3rd row민 간 부 문
ValueCountFrequency (%)
공 2
22.2%
부 2
22.2%
문 2
22.2%
계 1
11.1%
민 1
11.1%
간 1
11.1%
2024-03-14T11:18:07.692525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6
40.0%
공 2
 
13.3%
부 2
 
13.3%
문 2
 
13.3%
계 1
 
6.7%
민 1
 
6.7%
간 1
 
6.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9
60.0%
Control 6
40.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 2
22.2%
부 2
22.2%
문 2
22.2%
계 1
11.1%
민 1
11.1%
간 1
11.1%
Control
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9
60.0%
Common 6
40.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 2
22.2%
부 2
22.2%
문 2
22.2%
계 1
11.1%
민 1
11.1%
간 1
11.1%
Common
ValueCountFrequency (%)
6
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9
60.0%
ASCII 6
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6
100.0%
Hangul
ValueCountFrequency (%)
공 2
22.2%
부 2
22.2%
문 2
22.2%
계 1
11.1%
민 1
11.1%
간 1
11.1%

Unnamed: 2
Text

MISSING 

Distinct22
Distinct (%)91.7%
Missing5
Missing (%)17.2%
Memory size364.0 B
2024-03-14T11:18:07.857311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length14.5
Mean length11.666667
Min length1

Characters and Unicode

Total characters280
Distinct characters68
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique20 ?
Unique (%)83.3%

Sample

1st row용 도 별
2nd row소 계
3rd row(1)국방.군사시설
4th row(2)도로·철도·항만·공항시설
5th row(3)기 타 시 설
ValueCountFrequency (%)
시 10
 
13.2%
설 10
 
13.2%
용 5
 
6.6%
업 5
 
6.6%
계 4
 
5.3%
소 2
 
2.6%
타 2
 
2.6%
16)하 1
 
1.3%
13)어 1
 
1.3%
14)농수산물유통가공시설 1
 
1.3%
Other values (35) 35
46.1%
2024-03-14T11:18:08.118743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
73
26.1%
( 20
 
7.1%
) 20
 
7.1%
설 16
 
5.7%
시 16
 
5.7%
1 12
 
4.3%
농 6
 
2.1%
업 6
 
2.1%
공 6
 
2.1%
용 5
 
1.8%
Other values (58) 100
35.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 133
47.5%
Space Separator 73
26.1%
Decimal Number 29
 
10.4%
Open Punctuation 20
 
7.1%
Close Punctuation 20
 
7.1%
Other Punctuation 4
 
1.4%
Control 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
설 16
 
12.0%
시 16
 
12.0%
농 6
 
4.5%
업 6
 
4.5%
공 6
 
4.5%
용 5
 
3.8%
산 5
 
3.8%
계 4
 
3.0%
수 3
 
2.3%
물 3
 
2.3%
Other values (42) 63
47.4%
Decimal Number
ValueCountFrequency (%)
1 12
41.4%
6 3
 
10.3%
8 2
 
6.9%
7 2
 
6.9%
5 2
 
6.9%
2 2
 
6.9%
4 2
 
6.9%
3 2
 
6.9%
0 1
 
3.4%
9 1
 
3.4%
Other Punctuation
ValueCountFrequency (%)
· 3
75.0%
. 1
 
25.0%
Space Separator
ValueCountFrequency (%)
73
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 147
52.5%
Hangul 133
47.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
설 16
 
12.0%
시 16
 
12.0%
농 6
 
4.5%
업 6
 
4.5%
공 6
 
4.5%
용 5
 
3.8%
산 5
 
3.8%
계 4
 
3.0%
수 3
 
2.3%
물 3
 
2.3%
Other values (42) 63
47.4%
Common
ValueCountFrequency (%)
73
49.7%
( 20
 
13.6%
) 20
 
13.6%
1 12
 
8.2%
6 3
 
2.0%
· 3
 
2.0%
8 2
 
1.4%
7 2
 
1.4%
5 2
 
1.4%
2 2
 
1.4%
Other values (6) 8
 
5.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 144
51.4%
Hangul 133
47.5%
None 3
 
1.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
73
50.7%
( 20
 
13.9%
) 20
 
13.9%
1 12
 
8.3%
6 3
 
2.1%
8 2
 
1.4%
7 2
 
1.4%
5 2
 
1.4%
2 2
 
1.4%
4 2
 
1.4%
Other values (5) 6
 
4.2%
Hangul
ValueCountFrequency (%)
설 16
 
12.0%
시 16
 
12.0%
농 6
 
4.5%
업 6
 
4.5%
공 6
 
4.5%
용 5
 
3.8%
산 5
 
3.8%
계 4
 
3.0%
수 3
 
2.3%
물 3
 
2.3%
Other values (42) 63
47.4%
None
ValueCountFrequency (%)
· 3
100.0%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)10.3%
Memory size364.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)10.3%
Memory size364.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)10.3%
Memory size364.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)10.3%
Memory size364.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)10.3%
Memory size364.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)13.8%
Memory size364.0 B

Correlations

2024-03-14T11:18:08.190696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2018년 농지전용허가(협의·신고) 현황Unnamed: 1Unnamed: 2
2018년 농지전용허가(협의·신고) 현황1.000NaN1.000
Unnamed: 1NaN1.000NaN
Unnamed: 21.000NaN1.000

Missing values

2024-03-14T11:18:06.280392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T11:18:06.505047image/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.
2024-03-14T11:18:06.715927image/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

2018년 농지전용허가(협의·신고) 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
0<NA><NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구 분<NA>용 도 별건\n수계(㎡)NaNNaN농업진흥지역NaNNaN농업진흥구역NaNNaN농업보호구역NaNNaN농업진흥지역밖NaNNaN
2<NA><NA><NA>NaN계답전계답전계답전계답전계답전
3합             계<NA><NA>1044018745094.110254742.184903521855659.31475029.9380629.4989209.3807603.9181605.486645066742619902416889434.88779712.28109722.6
4허 가 · 협 의계<NA>1001618468909.610126200.18342709.51793934.31422912.9371021.4930569.3758341.9172227.486336566457119879416674975.38703287.27971688.1
5<NA>공 공 부 문소 계2722371564.11795453.1576111608718.4481328127390.4544267.4433083111184.46445148245162061762845.71314125.1448720.6
6<NA><NA>(1)국방.군사시설31484312379246400000000014843123792464
7<NA><NA>(2)도로·철도·항만·공항시설116613404.1398561.2214842.9285655.6218154.367501.3256813.6195921.360892.328842222336609327748.5180406.9147341.6
8<NA><NA>(3)기 타 시 설15317433171384512.9358804.1323062.8263173.759889.1287453.8237161.750292.1356092601295971420254.21121339.2298915
9<NA>민 간 부 문소 계974416097345.583307477766598.51185215.9941584.9243631386301.9325258.96104379891461632618258814912129.67389162.17522967.5
2018년 농지전용허가(협의·신고) 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
19<NA><NA>(12)농 업 용 시 설18111706464573524914518040022515842985378275158219521950718842455147333
20<NA><NA>(13)어 업 용 시 설510453595145020000000001045359514502
21<NA><NA>(14)농수산물유통가공시설151706246401242220842084020842084000014978255612422
22<NA><NA>(15) 산업촉진지구시설NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
23<NA><NA>(16) 기타시설23264962030061968088080808808000025688194926196
24임 의 전 용<NA>계0000000000000000
25<NA><NA>(16)하 천 관 리 시 설0000000000000000
26<NA><NA>(17)산 림 복 구0000000000000000
27<NA><NA>(18)천재지변으로 원상불능지0000000000000000
28* 2018년도 농식품부(한국농어촌공사) 최종 발표전으로 자료는 일부 수정될수 있습니다.<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN

Duplicate rows

Most frequently occurring

2018년 농지전용허가(협의·신고) 현황Unnamed: 1Unnamed: 2# duplicates
0<NA><NA><NA>2