Overview

Dataset statistics

Number of variables3
Number of observations102
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory27.3 B

Variable types

Numeric2
Categorical1

Dataset

Description경기도 교육재정 연도별 법정 이전수입(결산) 현황
Author교육부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=5H85K58WRNNHWN5ASTGX23734375&infSeq=2

Alerts

금액(원) has 18 (17.6%) zerosZeros

Reproduction

Analysis started2023-12-10 21:48:55.668649
Analysis finished2023-12-10 21:48:56.510155
Duration0.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Real number (ℝ)

Distinct13
Distinct (%)12.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2016.3431
Minimum2010
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-11T06:48:56.566490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation3.7640696
Coefficient of variation (CV)0.0018667803
Kurtosis-1.1986107
Mean2016.3431
Median Absolute Deviation (MAD)3.5
Skewness-0.11971809
Sum205667
Variance14.16822
MonotonicityDecreasing
2023-12-11T06:48:56.690392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
2022 9
8.8%
2021 9
8.8%
2020 9
8.8%
2019 8
 
7.8%
2018 8
 
7.8%
2017 8
 
7.8%
2016 8
 
7.8%
2015 8
 
7.8%
2014 7
 
6.9%
2013 7
 
6.9%
Other values (3) 21
20.6%
ValueCountFrequency (%)
2010 7
6.9%
2011 7
6.9%
2012 7
6.9%
2013 7
6.9%
2014 7
6.9%
2015 8
7.8%
2016 8
7.8%
2017 8
7.8%
2018 8
7.8%
2019 8
7.8%
ValueCountFrequency (%)
2022 9
8.8%
2021 9
8.8%
2020 9
8.8%
2019 8
7.8%
2018 8
7.8%
2017 8
7.8%
2016 8
7.8%
2015 8
7.8%
2014 7
6.9%
2013 7
6.9%

항목구분명
Categorical

Distinct9
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size948.0 B
담배소비세전입금
13 
법정이전수입
13 
세입결산액
13 
시도세전입금
13 
지방교육세전입금
13 
Other values (4)
37 

Length

Max length12
Median length11
Mean length7.9509804
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row교육급여보조금
2nd row담배소비세전입금
3rd row무상교육경비전입금
4th row법정이전수입
5th row세입결산액

Common Values

ValueCountFrequency (%)
담배소비세전입금 13
12.7%
법정이전수입 13
12.7%
세입결산액 13
12.7%
시도세전입금 13
12.7%
지방교육세전입금 13
12.7%
지방교육재정교부금보전금 13
12.7%
학교용지일반회계부담금 13
12.7%
교육급여보조금 8
7.8%
무상교육경비전입금 3
 
2.9%

Length

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

Common Values (Plot)

2023-12-11T06:48:56.979687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
담배소비세전입금 13
12.7%
법정이전수입 13
12.7%
세입결산액 13
12.7%
시도세전입금 13
12.7%
지방교육세전입금 13
12.7%
지방교육재정교부금보전금 13
12.7%
학교용지일반회계부담금 13
12.7%
교육급여보조금 8
7.8%
무상교육경비전입금 3
 
2.9%

금액(원)
Real number (ℝ)

ZEROS 

Distinct85
Distinct (%)83.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.5989037 × 1012
Minimum0
Maximum2.5132643 × 1013
Zeros18
Zeros (%)17.6%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-11T06:48:57.154930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q15.882188 × 109
median2.8550355 × 1011
Q32.1570185 × 1012
95-th percentile1.507325 × 1013
Maximum2.5132643 × 1013
Range2.5132643 × 1013
Interquartile range (IQR)2.1511363 × 1012

Descriptive statistics

Standard deviation5.1763966 × 1012
Coefficient of variation (CV)1.9917616
Kurtosis5.8840669
Mean2.5989037 × 1012
Median Absolute Deviation (MAD)2.8550355 × 1011
Skewness2.5561861
Sum2.6508818 × 1014
Variance2.6795081 × 1025
MonotonicityNot monotonic
2023-12-11T06:48:57.335106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 18
 
17.6%
216900000000 1
 
1.0%
170023375330 1
 
1.0%
1594340670000 1
 
1.0%
342519339000 1
 
1.0%
12816891432010 1
 
1.0%
2323783384330 1
 
1.0%
194318032000 1
 
1.0%
157410123690 1
 
1.0%
1711077808220 1
 
1.0%
Other values (75) 75
73.5%
ValueCountFrequency (%)
0 18
17.6%
2666169000 1
 
1.0%
2761251860 1
 
1.0%
3143020000 1
 
1.0%
3151510000 1
 
1.0%
3268018820 1
 
1.0%
3338647000 1
 
1.0%
3562953000 1
 
1.0%
4111424000 1
 
1.0%
11194480000 1
 
1.0%
ValueCountFrequency (%)
25132642640750 1
1.0%
19839121520790 1
1.0%
19080207658730 1
1.0%
18395628327210 1
1.0%
16878037620880 1
1.0%
15107859591870 1
1.0%
14415670399540 1
1.0%
13490950337060 1
1.0%
12816891432010 1
1.0%
11632855595110 1
1.0%

Interactions

2023-12-11T06:48:56.225430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:48:56.061045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:48:56.309286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:48:56.141843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:48:57.682719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도항목구분명금액(원)
회계연도1.0000.0000.000
항목구분명0.0001.0000.642
금액(원)0.0000.6421.000
2023-12-11T06:48:57.765026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도금액(원)항목구분명
회계연도1.0000.0380.000
금액(원)0.0381.0000.381
항목구분명0.0000.3811.000

Missing values

2023-12-11T06:48:56.409471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T06:48:56.479463image/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교육급여보조금3562953000
12022담배소비세전입금0
22022무상교육경비전입금16342477000
32022법정이전수입3483661839500
42022세입결산액25132642640750
52022시도세전입금705797876240
62022지방교육세전입금2391849503760
72022지방교육재정교부금보전금296157658570
82022학교용지일반회계부담금69951370930
92021교육급여보조금3143020000
회계연도항목구분명금액(원)
922011지방교육세전입금1466189000000
932011지방교육재정교부금보전금0
942011학교용지일반회계부담금213600000000
952010담배소비세전입금0
962010법정이전수입1755349916000
972010세입결산액9569153301630
982010시도세전입금235220000000
992010지방교육세전입금1320000000000
1002010지방교육재정교부금보전금0
1012010학교용지일반회계부담금200129916000