Overview

Dataset statistics

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

Variable types

Numeric2
Categorical1

Dataset

Description경기도 교육재정 세입 총괄(결산) 현황
Author교육부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=QWBN0DALTFPQDZ54NUCP23639963&infSeq=2

Alerts

금액(원) has 10 (14.7%) zerosZeros

Reproduction

Analysis started2023-12-10 21:17:39.543651
Analysis finished2023-12-10 21:17:40.252427
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Real number (ℝ)

Distinct13
Distinct (%)19.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2016.2206
Minimum2010
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size744.0 B
2023-12-11T06:17:40.579620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2010
5-th percentile2010
Q12013
median2016
Q32020
95-th percentile2022
Maximum2022
Range12
Interquartile range (IQR)7

Descriptive statistics

Standard deviation3.8317043
Coefficient of variation (CV)0.001900439
Kurtosis-1.256759
Mean2016.2206
Median Absolute Deviation (MAD)3
Skewness-0.067435234
Sum137103
Variance14.681958
MonotonicityDecreasing
2023-12-11T06:17:40.690663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
2022 6
 
8.8%
2021 6
 
8.8%
2020 6
 
8.8%
2019 5
 
7.4%
2018 5
 
7.4%
2017 5
 
7.4%
2016 5
 
7.4%
2015 5
 
7.4%
2014 5
 
7.4%
2013 5
 
7.4%
Other values (3) 15
22.1%
ValueCountFrequency (%)
2010 5
7.4%
2011 5
7.4%
2012 5
7.4%
2013 5
7.4%
2014 5
7.4%
2015 5
7.4%
2016 5
7.4%
2017 5
7.4%
2018 5
7.4%
2019 5
7.4%
ValueCountFrequency (%)
2022 6
8.8%
2021 6
8.8%
2020 6
8.8%
2019 5
7.4%
2018 5
7.4%
2017 5
7.4%
2016 5
7.4%
2015 5
7.4%
2014 5
7.4%
2013 5
7.4%

항목구분명
Categorical

Distinct6
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size676.0 B
기타
13 
세입결산액
13 
이전수입
13 
자체수입
13 
차입
13 

Length

Max length5
Median length4
Mean length3.4264706
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기타
2nd row내부거래
3rd row세입결산액
4th row이전수입
5th row자체수입

Common Values

ValueCountFrequency (%)
기타 13
19.1%
세입결산액 13
19.1%
이전수입 13
19.1%
자체수입 13
19.1%
차입 13
19.1%
내부거래 3
 
4.4%

Length

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

Common Values (Plot)

2023-12-11T06:17:40.941491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 13
19.1%
세입결산액 13
19.1%
이전수입 13
19.1%
자체수입 13
19.1%
차입 13
19.1%
내부거래 3
 
4.4%

금액(원)
Real number (ℝ)

ZEROS 

Distinct59
Distinct (%)86.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.8239639 × 1012
Minimum0
Maximum2.5132643 × 1013
Zeros10
Zeros (%)14.7%
Negative0
Negative (%)0.0%
Memory size744.0 B
2023-12-11T06:17:41.080019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q14.2474991 × 1011
median1.0216719 × 1012
Q31.1134397 × 1013
95-th percentile1.8840605 × 1013
Maximum2.5132643 × 1013
Range2.5132643 × 1013
Interquartile range (IQR)1.0709647 × 1013

Descriptive statistics

Standard deviation7.3183782 × 1012
Coefficient of variation (CV)1.2565975
Kurtosis-0.43457656
Mean5.8239639 × 1012
Median Absolute Deviation (MAD)1.0216719 × 1012
Skewness0.959278
Sum3.9602954 × 1014
Variance5.3558659 × 1025
MonotonicityNot monotonic
2023-12-11T06:17:41.229254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 10
 
14.7%
1328629448420 1
 
1.5%
13490950337060 1
 
1.5%
10880636922370 1
 
1.5%
438507239250 1
 
1.5%
1495063206000 1
 
1.5%
559914397920 1
 
1.5%
12816891432010 1
 
1.5%
10873547938510 1
 
1.5%
444235506580 1
 
1.5%
Other values (49) 49
72.1%
ValueCountFrequency (%)
0 10
14.7%
123336664000 1
 
1.5%
243755264310 1
 
1.5%
264256547280 1
 
1.5%
337929000000 1
 
1.5%
400447588880 1
 
1.5%
422921377660 1
 
1.5%
423030753840 1
 
1.5%
425322968010 1
 
1.5%
425505195400 1
 
1.5%
ValueCountFrequency (%)
25132642640750 1
1.5%
23539756645050 1
1.5%
19839121520790 1
1.5%
19080207658730 1
1.5%
18395628327210 1
1.5%
18308742003480 1
1.5%
17623613219870 1
1.5%
16878037620880 1
1.5%
16590380472310 1
1.5%
15498543322310 1
1.5%

Interactions

2023-12-11T06:17:39.900603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:17:39.716845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:17:40.001316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:17:39.804300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:17:41.316152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도항목구분명금액(원)
회계연도1.0000.0000.314
항목구분명0.0001.0000.571
금액(원)0.3140.5711.000
2023-12-11T06:17:41.399425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도금액(원)항목구분명
회계연도1.0000.0230.000
금액(원)0.0231.0000.354
항목구분명0.0000.3541.000

Missing values

2023-12-11T06:17:40.127087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T06:17:40.216203image/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기타1328629448420
12022내부거래0
22022세입결산액25132642640750
32022이전수입23539756645050
42022자체수입264256547280
52022차입0
62021기타1070923216160
72021내부거래0
82021세입결산액19839121520790
92021이전수입18308742003480
회계연도항목구분명금액(원)
582011기타1067594301830
592011세입결산액10687509239750
602011이전수입9196884184080
612011자체수입423030753840
622011차입0
632010기타1198784066740
642010세입결산액9569153301630
652010이전수입7499174871820
662010자체수입428018363070
672010차입443176000000