Overview

Dataset statistics

Number of variables3
Number of observations59
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory28.2 B

Variable types

Numeric2
Categorical1

Dataset

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

Alerts

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

Reproduction

Analysis started2023-12-10 22:34:53.440108
Analysis finished2023-12-10 22:34:53.916750
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Real number (ℝ)

Distinct11
Distinct (%)18.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2018.2373
Minimum2013
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-11T07:34:53.962633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation3.2181542
Coefficient of variation (CV)0.0015945371
Kurtosis-1.2436389
Mean2018.2373
Median Absolute Deviation (MAD)3
Skewness-0.10944282
Sum119076
Variance10.356517
MonotonicityDecreasing
2023-12-11T07:34:54.055080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
2023 6
10.2%
2022 6
10.2%
2021 6
10.2%
2020 6
10.2%
2019 5
8.5%
2018 5
8.5%
2017 5
8.5%
2016 5
8.5%
2015 5
8.5%
2014 5
8.5%
ValueCountFrequency (%)
2013 5
8.5%
2014 5
8.5%
2015 5
8.5%
2016 5
8.5%
2017 5
8.5%
2018 5
8.5%
2019 5
8.5%
2020 6
10.2%
2021 6
10.2%
2022 6
10.2%
ValueCountFrequency (%)
2023 6
10.2%
2022 6
10.2%
2021 6
10.2%
2020 6
10.2%
2019 5
8.5%
2018 5
8.5%
2017 5
8.5%
2016 5
8.5%
2015 5
8.5%
2014 5
8.5%

항목구분명
Categorical

Distinct6
Distinct (%)10.2%
Missing0
Missing (%)0.0%
Memory size604.0 B
기타
11 
세입예산액
11 
이전수입
11 
자체수입
11 
차입
11 

Length

Max length5
Median length4
Mean length3.440678
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
기타 11
18.6%
세입예산액 11
18.6%
이전수입 11
18.6%
자체수입 11
18.6%
차입 11
18.6%
내부거래 4
 
6.8%

Length

2023-12-11T07:34:54.169116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:34:54.269822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 11
18.6%
세입예산액 11
18.6%
이전수입 11
18.6%
자체수입 11
18.6%
차입 11
18.6%
내부거래 4
 
6.8%

금액(원)
Real number (ℝ)

ZEROS 

Distinct50
Distinct (%)84.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.4927417 × 1012
Minimum0
Maximum2.2334511 × 1013
Zeros10
Zeros (%)16.9%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-11T07:34:54.381088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11.8925491 × 1011
median3.8940228 × 1011
Q31.1521666 × 1013
95-th percentile1.8674309 × 1013
Maximum2.2334511 × 1013
Range2.2334511 × 1013
Interquartile range (IQR)1.1332412 × 1013

Descriptive statistics

Standard deviation7.2087215 × 1012
Coefficient of variation (CV)1.3124086
Kurtosis-0.81214335
Mean5.4927417 × 1012
Median Absolute Deviation (MAD)3.8940228 × 1011
Skewness0.86210827
Sum3.2407176 × 1014
Variance5.1965665 × 1025
MonotonicityNot monotonic
2023-12-11T07:34:54.493123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 10
 
16.9%
12052413872000 1
 
1.7%
11277561748000 1
 
1.7%
348863773000 1
 
1.7%
213001718000 1
 
1.7%
189408162000 1
 
1.7%
12122991238000 1
 
1.7%
10724398203000 1
 
1.7%
351882942000 1
 
1.7%
857301931000 1
 
1.7%
Other values (40) 40
67.8%
ValueCountFrequency (%)
0 10
16.9%
68131063000 1
 
1.7%
76490404000 1
 
1.7%
121513064000 1
 
1.7%
161910498000 1
 
1.7%
189101654000 1
 
1.7%
189408162000 1
 
1.7%
212986633000 1
 
1.7%
213001718000 1
 
1.7%
218329490000 1
 
1.7%
ValueCountFrequency (%)
22334511186000 1
1.7%
21803520842000 1
1.7%
19195902297000 1
1.7%
18616354231000 1
1.7%
16465048025000 1
1.7%
15921804872000 1
1.7%
15789919340000 1
1.7%
15519041966000 1
1.7%
15417755831000 1
1.7%
14858254086000 1
1.7%

Interactions

2023-12-11T07:34:53.651909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:34:53.518496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:34:53.717579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:34:53.584582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T07:34:54.597456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도항목구분명금액(원)
회계연도1.0000.0000.507
항목구분명0.0001.0000.575
금액(원)0.5070.5751.000
2023-12-11T07:34:54.689569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도금액(원)항목구분명
회계연도1.000-0.1190.000
금액(원)-0.1191.0000.383
항목구분명0.0000.3831.000

Missing values

2023-12-11T07:34:53.816118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T07:34:53.885512image/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기타409477280000
12023내부거래0
22023세입예산액22334511186000
32023이전수입21803520842000
42023자체수입121513064000
52023차입0
62022기타390446412000
72022내부거래0
82022세입예산액19195902297000
92022이전수입18616354231000
회계연도항목구분명금액(원)
492014기타242100429000
502014세입예산액11278472732000
512014이전수입9869118297000
522014자체수입424094006000
532014차입743160000000
542013기타232654864000
552013세입예산액10933647855000
562013이전수입9965093709000
572013자체수입389402282000
582013차입346497000000