Overview

Dataset statistics

Number of variables3
Number of observations110
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.9 KiB
Average record size in memory27.2 B

Variable types

Numeric2
Categorical1

Dataset

Description경기도 교육재정 통합 재정통계(예산) 현황
Author교육부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=LOF90KYH4AV5B0U91GVD23857742&infSeq=2

Alerts

금액(원) has 17 (15.5%) zerosZeros

Reproduction

Analysis started2023-12-10 21:22:51.048757
Analysis finished2023-12-10 21:22:51.573609
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Real number (ℝ)

Distinct11
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2018
Minimum2013
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-11T06:22:51.643193image/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.1767504
Coefficient of variation (CV)0.0015742073
Kurtosis-1.2207321
Mean2018
Median Absolute Deviation (MAD)3
Skewness0
Sum221980
Variance10.091743
MonotonicityDecreasing
2023-12-11T06:22:51.756449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
2023 10
9.1%
2022 10
9.1%
2021 10
9.1%
2020 10
9.1%
2019 10
9.1%
2018 10
9.1%
2017 10
9.1%
2016 10
9.1%
2015 10
9.1%
2014 10
9.1%
ValueCountFrequency (%)
2013 10
9.1%
2014 10
9.1%
2015 10
9.1%
2016 10
9.1%
2017 10
9.1%
2018 10
9.1%
2019 10
9.1%
2020 10
9.1%
2021 10
9.1%
2022 10
9.1%
ValueCountFrequency (%)
2023 10
9.1%
2022 10
9.1%
2021 10
9.1%
2020 10
9.1%
2019 10
9.1%
2018 10
9.1%
2017 10
9.1%
2016 10
9.1%
2015 10
9.1%
2014 10
9.1%

항목구분명
Categorical

Distinct10
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size1012.0 B
내부거래(세입)(B)
11 
내부거래(세출)(G)
11 
보전수입(E)
11 
보전지출(J)
11 
세입총계(A=B+C)
11 
Other values (5)
55 

Length

Max length14
Median length11
Mean length10.4
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row내부거래(세입)(B)
2nd row내부거래(세출)(G)
3rd row보전수입(E)
4th row보전지출(J)
5th row세입총계(A=B+C)

Common Values

ValueCountFrequency (%)
내부거래(세입)(B) 11
10.0%
내부거래(세출)(G) 11
10.0%
보전수입(E) 11
10.0%
보전지출(J) 11
10.0%
세입총계(A=B+C) 11
10.0%
세출총계(F=G+H) 11
10.0%
총수입(순계)(C=D+E) 11
10.0%
총지출(순계)(H=I+J) 11
10.0%
통합재정수입(D) 11
10.0%
통합재정지출(I) 11
10.0%

Length

2023-12-11T06:22:51.872693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:22:52.043428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
내부거래(세입)(b 11
10.0%
내부거래(세출)(g 11
10.0%
보전수입(e 11
10.0%
보전지출(j 11
10.0%
세입총계(a=b+c 11
10.0%
세출총계(f=g+h 11
10.0%
총수입(순계)(c=d+e 11
10.0%
총지출(순계)(h=i+j 11
10.0%
통합재정수입(d 11
10.0%
통합재정지출(i 11
10.0%

금액(원)
Real number (ℝ)

ZEROS 

Distinct59
Distinct (%)53.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.0835154 × 1012
Minimum0
Maximum2.7005154 × 1013
Zeros17
Zeros (%)15.5%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-11T06:22:52.246795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11.9590792 × 1011
median1.1278473 × 1013
Q31.536148 × 1013
95-th percentile2.0157514 × 1013
Maximum2.7005154 × 1013
Range2.7005154 × 1013
Interquartile range (IQR)1.5165572 × 1013

Descriptive statistics

Standard deviation7.8048653 × 1012
Coefficient of variation (CV)0.859234
Kurtosis-1.0770457
Mean9.0835154 × 1012
Median Absolute Deviation (MAD)7.0807027 × 1012
Skewness0.16038136
Sum9.991867 × 1014
Variance6.0915922 × 1025
MonotonicityNot monotonic
2023-12-11T06:22:52.666422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 17
 
15.5%
11764860214000 5
 
4.5%
10933647855000 5
 
4.5%
11278472732000 5
 
4.5%
14548472098000 4
 
3.6%
15417755831000 4
 
3.6%
12052413872000 4
 
3.6%
12122991238000 4
 
3.6%
1010000000 3
 
2.7%
16465666945000 2
 
1.8%
Other values (49) 57
51.8%
ValueCountFrequency (%)
0 17
15.5%
718920000 1
 
0.9%
1000000000 2
 
1.8%
1010000000 3
 
2.7%
56321500000 1
 
0.9%
95058206000 1
 
0.9%
112643000000 1
 
0.9%
149332833000 1
 
0.9%
188434061000 1
 
0.9%
218329490000 1
 
0.9%
ValueCountFrequency (%)
27005153860000 2
1.8%
25440722797000 2
1.8%
22105411343000 1
0.9%
20782226610000 1
0.9%
19393976476000 2
1.8%
19392966476000 2
1.8%
19174550171000 1
0.9%
18819901489000 1
0.9%
16466666945000 2
1.8%
16465666945000 2
1.8%

Interactions

2023-12-11T06:22:51.295767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:22:51.140240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:22:51.367370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:22:51.217614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:22:52.782838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도항목구분명금액(원)
회계연도1.0000.0000.735
항목구분명0.0001.0000.603
금액(원)0.7350.6031.000
2023-12-11T06:22:52.869606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도금액(원)항목구분명
회계연도1.0000.4270.000
금액(원)0.4271.0000.324
항목구분명0.0000.3241.000

Missing values

2023-12-11T06:22:51.463777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T06:22:51.541385image/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내부거래(세입)(B)1564431063000
12023내부거래(세출)(G)1564431063000
22023보전수입(E)3335311454000
32023보전지출(J)4658496187000
42023세입총계(A=B+C)27005153860000
52023세출총계(F=G+H)27005153860000
62023총수입(순계)(C=D+E)25440722797000
72023총지출(순계)(H=I+J)25440722797000
82023통합재정수입(D)22105411343000
92023통합재정지출(I)20782226610000
회계연도항목구분명금액(원)
1002013내부거래(세입)(B)0
1012013내부거래(세출)(G)0
1022013보전수입(E)579151864000
1032013보전지출(J)0
1042013세입총계(A=B+C)10933647855000
1052013세출총계(F=G+H)10933647855000
1062013총수입(순계)(C=D+E)10933647855000
1072013총지출(순계)(H=I+J)10933647855000
1082013통합재정수입(D)10354495991000
1092013통합재정지출(I)10933647855000