Overview

Dataset statistics

Number of variables3
Number of observations184
Missing cells0
Missing cells (%)0.0%
Duplicate rows4
Duplicate rows (%)2.2%
Total size in memory4.8 KiB
Average record size in memory26.7 B

Variable types

Numeric2
Categorical1

Dataset

Description경기도 교육재정 기능별·정책사업별(예산) 현황
Author교육부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=EJ1FRFM9H51B65GGSD5P23874103&infSeq=2

Alerts

Dataset has 4 (2.2%) duplicate rowsDuplicates
금액(원) has 3 (1.6%) zerosZeros

Reproduction

Analysis started2023-12-10 22:35:29.779666
Analysis finished2023-12-10 22:35:30.260879
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Real number (ℝ)

Distinct11
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2018.1902
Minimum2013
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2023-12-11T07:35:30.306576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2013
5-th percentile2013
Q12015
median2018
Q32021
95-th percentile2023
Maximum2023
Range10
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.2309487
Coefficient of variation (CV)0.0016009139
Kurtosis-1.2597932
Mean2018.1902
Median Absolute Deviation (MAD)3
Skewness-0.06099911
Sum371347
Variance10.439029
MonotonicityDecreasing
2023-12-11T07:35:30.396001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
2023 20
10.9%
2022 19
10.3%
2021 17
9.2%
2020 16
8.7%
2019 16
8.7%
2018 16
8.7%
2017 16
8.7%
2016 16
8.7%
2015 16
8.7%
2014 16
8.7%
ValueCountFrequency (%)
2013 16
8.7%
2014 16
8.7%
2015 16
8.7%
2016 16
8.7%
2017 16
8.7%
2018 16
8.7%
2019 16
8.7%
2020 16
8.7%
2021 17
9.2%
2022 19
10.3%
ValueCountFrequency (%)
2023 20
10.9%
2022 19
10.3%
2021 17
9.2%
2020 16
8.7%
2019 16
8.7%
2018 16
8.7%
2017 16
8.7%
2016 16
8.7%
2015 16
8.7%
2014 16
8.7%

항목구분명
Categorical

Distinct17
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
평생교육
22 
예비비및기타
12 
학교재정지원관리
 
11
교육일반
 
11
교육행정일반
 
11
Other values (12)
117 

Length

Max length10
Median length8
Mean length5.4673913
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row교수학습활동지원
2nd row교육복지
3rd row교육일반
4th row교육행정일반
5th row기관운영

Common Values

ValueCountFrequency (%)
평생교육 22
 
12.0%
예비비및기타 12
 
6.5%
학교재정지원관리 11
 
6.0%
교육일반 11
 
6.0%
교육행정일반 11
 
6.0%
기관운영 11
 
6.0%
보건급식 11
 
6.0%
세출예산액 11
 
6.0%
교수학습활동지원 11
 
6.0%
유아 및 초중등교육 11
 
6.0%
Other values (7) 62
33.7%

Length

2023-12-11T07:35:30.496402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
평생교육 22
 
10.7%
예비비및기타 12
 
5.8%
교육복지 11
 
5.3%
학교시설여건개선 11
 
5.3%
직업교육 11
 
5.3%
재무활동 11
 
5.3%
인적자원운용 11
 
5.3%
초중등교육 11
 
5.3%
및 11
 
5.3%
유아 11
 
5.3%
Other values (9) 84
40.8%

금액(원)
Real number (ℝ)

ZEROS 

Distinct173
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.6418894 × 1012
Minimum0
Maximum2.2334511 × 1013
Zeros3
Zeros (%)1.6%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2023-12-11T07:35:30.605980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.2 × 109
Q13.5846093 × 1010
median5.7836605 × 1011
Q31.7593043 × 1012
95-th percentile1.348158 × 1013
Maximum2.2334511 × 1013
Range2.2334511 × 1013
Interquartile range (IQR)1.7234582 × 1012

Descriptive statistics

Standard deviation4.6601129 × 1012
Coefficient of variation (CV)1.7639319
Kurtosis3.1992423
Mean2.6418894 × 1012
Median Absolute Deviation (MAD)5.6311435 × 1011
Skewness2.0272005
Sum4.8610764 × 1014
Variance2.1716652 × 1025
MonotonicityNot monotonic
2023-12-11T07:35:30.721222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 3
 
1.6%
10871711145000 2
 
1.1%
1200000000 2
 
1.1%
33372182000 2
 
1.1%
1040000000 2
 
1.1%
15986236000 2
 
1.1%
21842252000 2
 
1.1%
11416662574000 2
 
1.1%
26243097000 2
 
1.1%
35000000000 2
 
1.1%
Other values (163) 163
88.6%
ValueCountFrequency (%)
0 3
1.6%
235320000 1
 
0.5%
345080000 1
 
0.5%
398390000 1
 
0.5%
550000000 1
 
0.5%
1040000000 2
1.1%
1200000000 2
1.1%
1364500000 1
 
0.5%
8302635000 1
 
0.5%
9109720000 1
 
0.5%
ValueCountFrequency (%)
22334511186000 1
0.5%
19195902297000 1
0.5%
16465048025000 1
0.5%
15921804872000 1
0.5%
15859814219000 1
0.5%
15417755831000 1
0.5%
15290136958000 1
0.5%
14548472098000 1
0.5%
14506975299000 1
0.5%
13721331283000 1
0.5%

Interactions

2023-12-11T07:35:30.008133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:35:29.860535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:35:30.084646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:35:29.927229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T07:35:30.793411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도항목구분명금액(원)
회계연도1.0000.0000.281
항목구분명0.0001.0000.713
금액(원)0.2810.7131.000
2023-12-11T07:35:30.867169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도금액(원)항목구분명
회계연도1.0000.0930.000
금액(원)0.0931.0000.365
항목구분명0.0000.3651.000

Missing values

2023-12-11T07:35:30.168447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T07:35:30.235810image/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

회계연도항목구분명금액(원)
02023교수학습활동지원1132189534000
12023교육복지1422527923000
22023교육일반2328885445000
32023교육행정일반306360020000
42023기관운영131770701000
52023보건급식1068219652000
62023세출예산액22334511186000
72023예비비35000000000
82023예비비및기타0
92023예비비및기타35000000000
회계연도항목구분명금액(원)
1742013세출예산액10933647855000
1752013예비비및기타105355017000
1762013유아 및 초중등교육10333774906000
1772013인적자원운용6219468151000
1782013재무활동367337435000
1792013직업교육1200000000
1802013평생교육11912373000
1812013평생교육10712373000
1822013학교시설여건개선1078755536000
1832013학교재정지원관리1391167982000

Duplicate rows

Most frequently occurring

회계연도항목구분명금액(원)# duplicates
02022인건비108717111450002
12022평생교육262430970002
22023인건비114166625740002
32023평생교육218422520002