Overview

Dataset statistics

Number of variables6
Number of observations29
Missing cells5
Missing cells (%)2.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory55.6 B

Variable types

Categorical4
Numeric2

Dataset

Description경기도 성남시 배출가스 저감사업의 현황에 관한 데이터로, 사업명, 보조금 지원 대상, 보조금 지원 금액, 차량 대수 의 데이터를 제공합니다.
URLhttps://www.data.go.kr/data/15116926/fileData.do

Alerts

시군명 has constant value ""Constant
사업명 is highly overall correlated with 보조금지원대상High correlation
보조금지원대상 is highly overall correlated with 사업명High correlation
차량대수 has 5 (17.2%) missing valuesMissing
지원금액 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:27:15.440553
Analysis finished2023-12-12 08:27:16.326615
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준년도
Categorical

Distinct5
Distinct (%)17.2%
Missing0
Missing (%)0.0%
Memory size364.0 B
2019
6 
2020
6 
2021
6 
2022
6 
2018
5 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2018
2nd row2018
3rd row2018
4th row2018
5th row2018

Common Values

ValueCountFrequency (%)
2019 6
20.7%
2020 6
20.7%
2021 6
20.7%
2022 6
20.7%
2018 5
17.2%

Length

2023-12-12T17:27:16.398987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:27:16.538360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019 6
20.7%
2020 6
20.7%
2021 6
20.7%
2022 6
20.7%
2018 5
17.2%

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size364.0 B
성남시
29 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성남시
2nd row성남시
3rd row성남시
4th row성남시
5th row성남시

Common Values

ValueCountFrequency (%)
성남시 29
100.0%

Length

2023-12-12T17:27:16.682481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:27:16.783751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성남시 29
100.0%

사업명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)13.8%
Missing0
Missing (%)0.0%
Memory size364.0 B
친환경자동차보급
14 
조기폐차
5 
저감장치부착
5 
저감장치성능검사
5 

Length

Max length8
Median length8
Mean length6.9655172
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row조기폐차
2nd row저감장치부착
3rd row저감장치성능검사
4th row친환경자동차보급
5th row친환경자동차보급

Common Values

ValueCountFrequency (%)
친환경자동차보급 14
48.3%
조기폐차 5
 
17.2%
저감장치부착 5
 
17.2%
저감장치성능검사 5
 
17.2%

Length

2023-12-12T17:27:16.932069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:27:17.062021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
친환경자동차보급 14
48.3%
조기폐차 5
 
17.2%
저감장치부착 5
 
17.2%
저감장치성능검사 5
 
17.2%

보조금지원대상
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)13.8%
Missing0
Missing (%)0.0%
Memory size364.0 B
노후경유차/노후건설기계
15 
CNG버스
5 
전기차
5 
전기버스
4 

Length

Max length12
Median length12
Mean length8.137931
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row노후경유차/노후건설기계
2nd row노후경유차/노후건설기계
3rd row노후경유차/노후건설기계
4th rowCNG버스
5th row전기차

Common Values

ValueCountFrequency (%)
노후경유차/노후건설기계 15
51.7%
CNG버스 5
 
17.2%
전기차 5
 
17.2%
전기버스 4
 
13.8%

Length

2023-12-12T17:27:17.193155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:27:17.329217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노후경유차/노후건설기계 15
51.7%
cng버스 5
 
17.2%
전기차 5
 
17.2%
전기버스 4
 
13.8%

지원금액
Real number (ℝ)

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.9588025 × 109
Minimum3960000
Maximum3.5213602 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2023-12-12T17:27:17.490022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3960000
5-th percentile9110860
Q16.06054 × 108
median2.18669 × 109
Q38.247754 × 109
95-th percentile1.3325159 × 1010
Maximum3.5213602 × 1010
Range3.5209642 × 1010
Interquartile range (IQR)7.6417 × 109

Descriptive statistics

Standard deviation7.1572349 × 109
Coefficient of variation (CV)1.4433394
Kurtosis11.139504
Mean4.9588025 × 109
Median Absolute Deviation (MAD)2.1590349 × 109
Skewness2.9360642
Sum1.4380527 × 1011
Variance5.1226011 × 1019
MonotonicityNot monotonic
2023-12-12T17:27:17.665277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
3684680000 1
 
3.4%
606054000 1
 
3.4%
9536000000 1
 
3.4%
35213602000 1
 
3.4%
132000000 1
 
3.4%
6306300 1
 
3.4%
504233000 1
 
3.4%
680760000 1
 
3.4%
8606824000 1
 
3.4%
15676360000 1
 
3.4%
Other values (19) 19
65.5%
ValueCountFrequency (%)
3960000 1
3.4%
6306300 1
3.4%
13317700 1
3.4%
27655100 1
3.4%
98233300 1
3.4%
132000000 1
3.4%
504233000 1
3.4%
606054000 1
3.4%
636000000 1
3.4%
648000000 1
3.4%
ValueCountFrequency (%)
35213602000 1
3.4%
15676360000 1
3.4%
9798358000 1
3.4%
9536000000 1
3.4%
9363776000 1
3.4%
8910655000 1
3.4%
8606824000 1
3.4%
8247754000 1
3.4%
7568710000 1
3.4%
4936780000 1
3.4%

차량대수
Real number (ℝ)

MISSING 

Distinct24
Distinct (%)100.0%
Missing5
Missing (%)17.2%
Infinite0
Infinite (%)0.0%
Mean989.91667
Minimum11
Maximum4994
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2023-12-12T17:27:17.837861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile33.45
Q166.25
median359
Q31428.25
95-th percentile3568.1
Maximum4994
Range4983
Interquartile range (IQR)1362

Descriptive statistics

Standard deviation1366.6605
Coefficient of variation (CV)1.3805814
Kurtosis2.1051516
Mean989.91667
Median Absolute Deviation (MAD)298.5
Skewness1.6406819
Sum23758
Variance1867761
MonotonicityNot monotonic
2023-12-12T17:27:18.007315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
62 1
 
3.4%
83 1
 
3.4%
3698 1
 
3.4%
11 1
 
3.4%
127 1
 
3.4%
428 1
 
3.4%
67 1
 
3.4%
1240 1
 
3.4%
53 1
 
3.4%
539 1
 
3.4%
Other values (14) 14
48.3%
(Missing) 5
 
17.2%
ValueCountFrequency (%)
11 1
3.4%
30 1
3.4%
53 1
3.4%
59 1
3.4%
62 1
3.4%
64 1
3.4%
67 1
3.4%
68 1
3.4%
83 1
3.4%
93 1
3.4%
ValueCountFrequency (%)
4994 1
3.4%
3698 1
3.4%
2832 1
3.4%
2570 1
3.4%
2483 1
3.4%
1588 1
3.4%
1375 1
3.4%
1240 1
3.4%
576 1
3.4%
539 1
3.4%

Interactions

2023-12-12T17:27:15.913163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:27:15.691105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:27:16.042517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:27:15.815657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:27:18.119041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준년도사업명보조금지원대상지원금액차량대수
기준년도1.0000.0000.0000.2580.497
사업명0.0001.0000.8510.0000.553
보조금지원대상0.0000.8511.0000.4900.000
지원금액0.2580.0000.4901.0000.714
차량대수0.4970.5530.0000.7141.000
2023-12-12T17:27:18.252833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
보조금지원대상기준년도사업명
보조금지원대상1.0000.0000.503
기준년도0.0001.0000.000
사업명0.5030.0001.000
2023-12-12T17:27:18.346969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지원금액차량대수기준년도사업명보조금지원대상
지원금액1.0000.4830.0540.0000.409
차량대수0.4831.0000.2830.3490.000
기준년도0.0540.2831.0000.0000.000
사업명0.0000.3490.0001.0000.503
보조금지원대상0.4090.0000.0000.5031.000

Missing values

2023-12-12T17:27:16.165005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:27:16.282790image/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

기준년도시군명사업명보조금지원대상지원금액차량대수
02018성남시조기폐차노후경유차/노후건설기계36846800002483
12018성남시저감장치부착노후경유차/노후건설기계60605400093
22018성남시저감장치성능검사노후경유차/노후건설기계3960000<NA>
32018성남시친환경자동차보급CNG버스67300000059
42018성남시친환경자동차보급전기차4776790000327
52019성남시조기폐차노후경유차/노후건설기계75687100004994
62019성남시저감장치부착노후경유차/노후건설기계89106550001588
72019성남시저감장치성능검사노후경유차/노후건설기계13317700<NA>
82019성남시친환경자동차보급CNG버스64800000064
92019성남시친환경자동차보급전기차4936780000391
기준년도시군명사업명보조금지원대상지원금액차량대수
192021성남시저감장치성능검사노후경유차/노후건설기계27655100<NA>
202021성남시친환경자동차보급CNG버스63600000053
212021성남시친환경자동차보급전기차156763600001240
222021성남시친환경자동차보급전기버스860682400067
232022성남시조기폐차노후경유차/노후건설기계680760000428
242022성남시저감장치부착노후경유차/노후건설기계504233000127
252022성남시저감장치성능검사노후경유차/노후건설기계6306300<NA>
262022성남시친환경자동차보급CNG버스13200000011
272022성남시친환경자동차보급전기차352136020003698
282022성남시친환경자동차보급전기버스953600000083