Overview

Dataset statistics

Number of variables8
Number of observations35
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory71.8 B

Variable types

Categorical4
Numeric4

Dataset

Description농업용 면세유 사용위반(용도외사용) 정보 현황
Author농림축산식품부
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20220217000000002052

Alerts

연도 has constant value ""Constant
유형 has constant value ""Constant
위반물량(ℓ) is highly overall correlated with 위반금액(원)High correlation
위반금액(원) is highly overall correlated with 위반물량(ℓ)High correlation
회수수량(ℓ) is highly overall correlated with 회수금액(원)High correlation
회수금액(원) is highly overall correlated with 회수수량(ℓ)High correlation
기종명 is highly overall correlated with 유종명High correlation
유종명 is highly overall correlated with 기종명High correlation
위반금액(원) has 2 (5.7%) zerosZeros
회수수량(ℓ) has 30 (85.7%) zerosZeros
회수금액(원) has 30 (85.7%) zerosZeros

Reproduction

Analysis started2023-12-11 03:38:17.462620
Analysis finished2023-12-11 03:38:19.565431
Duration2.1 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
2022년
35 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022년
2nd row2022년
3rd row2022년
4th row2022년
5th row2022년

Common Values

ValueCountFrequency (%)
2022년 35
100.0%

Length

2023-12-11T12:38:19.635426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:38:19.765199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022년 35
100.0%

유형
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
농업용도 외 사용
35 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row농업용도 외 사용
2nd row농업용도 외 사용
3rd row농업용도 외 사용
4th row농업용도 외 사용
5th row농업용도 외 사용

Common Values

ValueCountFrequency (%)
농업용도 외 사용 35
100.0%

Length

2023-12-11T12:38:19.868166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:38:19.954832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
농업용도 35
33.3%
외 35
33.3%
사용 35
33.3%

기종명
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)37.1%
Missing0
Missing (%)0.0%
Memory size412.0 B
온풍난방기-간접식(유류용)
7 
농산물건조기(선반형)
6 
농업용 트랙터
5 
버섯재배소독기(균상재배)
5 
곡물건조기(순환식)
2 
Other values (8)
10 

Length

Max length21
Median length14
Mean length11.771429
Min length7

Unique

Unique6 ?
Unique (%)17.1%

Sample

1st row곡물건조기(순환식)
2nd row곡물건조기(순환식)
3rd row관리기(보행형)
4th row관리기(보행형)
5th row농산물건조기(겸용형-황색종담배)

Common Values

ValueCountFrequency (%)
온풍난방기-간접식(유류용) 7
20.0%
농산물건조기(선반형) 6
17.1%
농업용 트랙터 5
14.3%
버섯재배소독기(균상재배) 5
14.3%
곡물건조기(순환식) 2
 
5.7%
관리기(보행형) 2
 
5.7%
농산물건조기(겸용형-황색종담배) 2
 
5.7%
농산물건조기(시설형-유류용)_온수보일러 1
 
2.9%
농업용로우더(2톤미만) 1
 
2.9%
동력수피기 및 파쇄기 1
 
2.9%
Other values (3) 3
8.6%

Length

2023-12-11T12:38:20.050689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
온풍난방기-간접식(유류용 7
16.7%
농산물건조기(선반형 6
14.3%
농업용 5
11.9%
트랙터 5
11.9%
버섯재배소독기(균상재배 5
11.9%
곡물건조기(순환식 2
 
4.8%
관리기(보행형 2
 
4.8%
농산물건조기(겸용형-황색종담배 2
 
4.8%
농산물건조기(시설형-유류용)_온수보일러 1
 
2.4%
농업용로우더(2톤미만 1
 
2.4%
Other values (6) 6
14.3%

유종명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size412.0 B
실내등유
19 
경유
14 
휘발유
2 

Length

Max length4
Median length4
Mean length3.1428571
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row실내등유
2nd row실내등유
3rd row휘발유
4th row휘발유
5th row실내등유

Common Values

ValueCountFrequency (%)
실내등유 19
54.3%
경유 14
40.0%
휘발유 2
 
5.7%

Length

2023-12-11T12:38:20.433047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T12:38:20.548092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
실내등유 19
54.3%
경유 14
40.0%
휘발유 2
 
5.7%

위반물량(ℓ)
Real number (ℝ)

HIGH CORRELATION 

Distinct28
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean647.2
Minimum20
Maximum3500
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-11T12:38:20.646340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20
5-th percentile37
Q1150
median400
Q3939
95-th percentile2078
Maximum3500
Range3480
Interquartile range (IQR)789

Descriptive statistics

Standard deviation755.69562
Coefficient of variation (CV)1.1676385
Kurtosis5.2146765
Mean647.2
Median Absolute Deviation (MAD)350
Skewness2.08814
Sum22652
Variance571075.87
MonotonicityNot monotonic
2023-12-11T12:38:20.764348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
200 4
 
11.4%
1000 3
 
8.6%
400 2
 
5.7%
750 2
 
5.7%
300 1
 
2.9%
2000 1
 
2.9%
85 1
 
2.9%
55 1
 
2.9%
600 1
 
2.9%
480 1
 
2.9%
Other values (18) 18
51.4%
ValueCountFrequency (%)
20 1
 
2.9%
30 1
 
2.9%
40 1
 
2.9%
41 1
 
2.9%
50 1
 
2.9%
55 1
 
2.9%
60 1
 
2.9%
85 1
 
2.9%
100 1
 
2.9%
200 4
11.4%
ValueCountFrequency (%)
3500 1
 
2.9%
2260 1
 
2.9%
2000 1
 
2.9%
1600 1
 
2.9%
1420 1
 
2.9%
1000 3
8.6%
978 1
 
2.9%
900 1
 
2.9%
808 1
 
2.9%
750 2
5.7%

위반금액(원)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct34
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean679033.77
Minimum0
Maximum3041500
Zeros2
Zeros (%)5.7%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-11T12:38:20.890306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile24780
Q1107277.5
median316000
Q31125000
95-th percentile2145800
Maximum3041500
Range3041500
Interquartile range (IQR)1017722.5

Descriptive statistics

Standard deviation751831
Coefficient of variation (CV)1.1072071
Kurtosis2.0193714
Mean679033.77
Median Absolute Deviation (MAD)261040
Skewness1.4997554
Sum23766182
Variance5.6524985 × 1011
MonotonicityNot monotonic
2023-12-11T12:38:21.058016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
0 2
 
5.7%
1200000 1
 
2.9%
316000 1
 
2.9%
810000 1
 
2.9%
1330540 1
 
2.9%
2000000 1
 
2.9%
2486000 1
 
2.9%
97000 1
 
2.9%
54960 1
 
2.9%
285000 1
 
2.9%
Other values (24) 24
68.6%
ValueCountFrequency (%)
0 2
5.7%
35400 1
2.9%
54120 1
2.9%
54960 1
2.9%
69700 1
2.9%
76250 1
2.9%
77000 1
2.9%
97000 1
2.9%
117555 1
2.9%
135450 1
2.9%
ValueCountFrequency (%)
3041500 1
2.9%
2486000 1
2.9%
2000000 1
2.9%
1537000 1
2.9%
1500000 1
2.9%
1369200 1
2.9%
1330540 1
2.9%
1235432 1
2.9%
1200000 1
2.9%
1050000 1
2.9%

회수수량(ℓ)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct6
Distinct (%)17.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean804.45714
Minimum0
Maximum26896
Zeros30
Zeros (%)85.7%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-11T12:38:21.189141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile460
Maximum26896
Range26896
Interquartile range (IQR)0

Descriptive statistics

Standard deviation4541.73
Coefficient of variation (CV)5.6457078
Kurtosis34.941462
Mean804.45714
Median Absolute Deviation (MAD)0
Skewness5.9089479
Sum28156
Variance20627311
MonotonicityNot monotonic
2023-12-11T12:38:21.326606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 30
85.7%
7 1
 
2.9%
400 1
 
2.9%
600 1
 
2.9%
253 1
 
2.9%
26896 1
 
2.9%
ValueCountFrequency (%)
0 30
85.7%
7 1
 
2.9%
253 1
 
2.9%
400 1
 
2.9%
600 1
 
2.9%
26896 1
 
2.9%
ValueCountFrequency (%)
26896 1
 
2.9%
600 1
 
2.9%
400 1
 
2.9%
253 1
 
2.9%
7 1
 
2.9%
0 30
85.7%

회수금액(원)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct6
Distinct (%)17.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1106286.1
Minimum0
Maximum36955104
Zeros30
Zeros (%)85.7%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-11T12:38:21.426836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile696280
Maximum36955104
Range36955104
Interquartile range (IQR)0

Descriptive statistics

Standard deviation6240480.9
Coefficient of variation (CV)5.6409285
Kurtosis34.933842
Mean1106286.1
Median Absolute Deviation (MAD)0
Skewness5.9080321
Sum38720014
Variance3.8943602 × 1013
MonotonicityNot monotonic
2023-12-11T12:38:21.581254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 30
85.7%
11900 1
 
2.9%
610000 1
 
2.9%
897600 1
 
2.9%
245410 1
 
2.9%
36955104 1
 
2.9%
ValueCountFrequency (%)
0 30
85.7%
11900 1
 
2.9%
245410 1
 
2.9%
610000 1
 
2.9%
897600 1
 
2.9%
36955104 1
 
2.9%
ValueCountFrequency (%)
36955104 1
 
2.9%
897600 1
 
2.9%
610000 1
 
2.9%
245410 1
 
2.9%
11900 1
 
2.9%
0 30
85.7%

Interactions

2023-12-11T12:38:18.920974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:17.715816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.130801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.557521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:19.017313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:17.820084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.248066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.643499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:19.120244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:17.912978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.341198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.740228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:19.209110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.021694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.434402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:38:18.826360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T12:38:21.687304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기종명유종명위반물량(ℓ)위반금액(원)회수수량(ℓ)회수금액(원)
기종명1.0001.0000.5700.4500.0000.000
유종명1.0001.0000.0790.0000.0000.000
위반물량(ℓ)0.5700.0791.0000.9380.0000.000
위반금액(원)0.4500.0000.9381.0000.0000.000
회수수량(ℓ)0.0000.0000.0000.0001.0000.663
회수금액(원)0.0000.0000.0000.0000.6631.000
2023-12-11T12:38:21.810780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기종명유종명
기종명1.0000.829
유종명0.8291.000
2023-12-11T12:38:21.901505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위반물량(ℓ)위반금액(원)회수수량(ℓ)회수금액(원)기종명유종명
위반물량(ℓ)1.0000.913-0.463-0.4630.2520.000
위반금액(원)0.9131.000-0.368-0.3680.1590.000
회수수량(ℓ)-0.463-0.3681.0001.0000.0000.000
회수금액(원)-0.463-0.3681.0001.0000.0000.000
기종명0.2520.1590.0000.0001.0000.829
유종명0.0000.0000.0000.0000.8291.000

Missing values

2023-12-11T12:38:19.356260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T12:38:19.512884image/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.

Sample

연도유형기종명유종명위반물량(ℓ)위반금액(원)회수수량(ℓ)회수금액(원)
02022년농업용도 외 사용곡물건조기(순환식)실내등유30028500000
12022년농업용도 외 사용곡물건조기(순환식)실내등유455000
22022년농업용도 외 사용관리기(보행형)휘발유303540000
32022년농업용도 외 사용관리기(보행형)휘발유4169700711900
42022년농업용도 외 사용농산물건조기(겸용형-황색종담배)실내등유20027800000
52022년농업용도 외 사용농산물건조기(겸용형-황색종담배)실내등유1000150000000
62022년농업용도 외 사용농산물건조기(선반형)실내등유5076250400610000
72022년농업용도 외 사용농산물건조기(선반형)실내등유20029000000
82022년농업용도 외 사용농산물건조기(선반형)실내등유200299200600897600
92022년농업용도 외 사용농산물건조기(선반형)실내등유27521587500
연도유형기종명유종명위반물량(ℓ)위반금액(원)회수수량(ℓ)회수금액(원)
252022년농업용도 외 사용온수보일러(유류용)실내등유10097000253245410
262022년농업용도 외 사용온풍난방기-간접식(유류용)실내등유40549602689636955104
272022년농업용도 외 사용온풍난방기-간접식(유류용)실내등유605412000
282022년농업용도 외 사용온풍난방기-간접식(유류용)실내등유21513545000
292022년농업용도 외 사용온풍난방기-간접식(유류용)실내등유28017164000
302022년농업용도 외 사용온풍난방기-간접식(유류용)실내등유48040896000
312022년농업용도 외 사용온풍난방기-간접식(유류용)실내등유60050400000
322022년농업용도 외 사용온풍난방기-간접식(유류용)실내등유100090200000
332022년농업용도 외 사용콤바인(자탈형-3조이하)경유557700000
342022년농업용도 외 사용화물자동차(1톤이하)경유8511755500