Overview

Dataset statistics

Number of variables3
Number of observations25
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory782.0 B
Average record size in memory31.3 B

Variable types

Categorical2
Numeric1

Dataset

Description경기도 교육재정 누리과정(결산) 현황
Author교육부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=GQK3WDBDEJPB8ZQ69N1J23754787&infSeq=2

Alerts

금액(원) is highly overall correlated with 항목구분명High correlation
항목구분명 is highly overall correlated with 금액(원)High correlation
금액(원) has unique valuesUnique

Reproduction

Analysis started2023-12-10 20:59:58.005651
Analysis finished2023-12-10 20:59:58.322335
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Categorical

Distinct5
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2016
5 
2015
5 
2014
5 
2013
5 
2012
5 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2016
2nd row2016
3rd row2016
4th row2016
5th row2016

Common Values

ValueCountFrequency (%)
2016 5
20.0%
2015 5
20.0%
2014 5
20.0%
2013 5
20.0%
2012 5
20.0%

Length

2023-12-11T05:59:58.385976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:59:58.509544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016 5
20.0%
2015 5
20.0%
2014 5
20.0%
2013 5
20.0%
2012 5
20.0%

항목구분명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
공립
5 
사립
5 
어린이집
5 
유치원
5 
합계
5 

Length

Max length4
Median length2
Mean length2.6
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공립
2nd row사립
3rd row어린이집
4th row유치원
5th row합계

Common Values

ValueCountFrequency (%)
공립 5
20.0%
사립 5
20.0%
어린이집 5
20.0%
유치원 5
20.0%
합계 5
20.0%

Length

2023-12-11T05:59:58.643718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:59:58.781725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공립 5
20.0%
사립 5
20.0%
어린이집 5
20.0%
유치원 5
20.0%
합계 5
20.0%

금액(원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.9934926 × 1011
Minimum1.2949035 × 1010
Maximum1.055925 × 1012
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2023-12-11T05:59:58.925228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.2949035 × 1010
5-th percentile3.5047833 × 1010
Q11.2787688 × 1011
median4.337588 × 1011
Q35.1000344 × 1011
95-th percentile1.0187261 × 1012
Maximum1.055925 × 1012
Range1.0429759 × 1012
Interquartile range (IQR)3.8212655 × 1011

Descriptive statistics

Standard deviation3.0483475 × 1011
Coefficient of variation (CV)0.76332871
Kurtosis-0.0065133942
Mean3.9934926 × 1011
Median Absolute Deviation (MAD)1.9057322 × 1011
Skewness0.66328781
Sum9.9837314 × 1012
Variance9.2924225 × 1022
MonotonicityNot monotonic
2023-12-11T05:59:59.081847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
39044398000 1
 
4.0%
470959037000 1
 
4.0%
243185587110 1
 
4.0%
140825918110 1
 
4.0%
102359669000 1
 
4.0%
127876882700 1
 
4.0%
12949035410 1
 
4.0%
723062864610 1
 
4.0%
400109252610 1
 
4.0%
322953612000 1
 
4.0%
Other values (15) 15
60.0%
ValueCountFrequency (%)
12949035410 1
4.0%
34276586590 1
4.0%
38132817480 1
4.0%
38441670000 1
4.0%
39044398000 1
4.0%
102359669000 1
4.0%
127876882700 1
4.0%
140825918110 1
4.0%
243185587110 1
4.0%
322953612000 1
4.0%
ValueCountFrequency (%)
1055924955000 1
4.0%
1046017650000 1
4.0%
909559928000 1
4.0%
723062864610 1
4.0%
545921520000 1
4.0%
540927318000 1
4.0%
510003435000 1
4.0%
505090332000 1
4.0%
472200475000 1
4.0%
470959037000 1
4.0%

Interactions

2023-12-11T05:59:58.110667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T05:59:59.195042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도항목구분명금액(원)
회계연도1.0000.0000.514
항목구분명0.0001.0000.754
금액(원)0.5140.7541.000
2023-12-11T05:59:59.312369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도항목구분명
회계연도1.0000.000
항목구분명0.0001.000
2023-12-11T05:59:59.410874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
금액(원)회계연도항목구분명
금액(원)1.0000.2560.513
회계연도0.2561.0000.000
항목구분명0.5130.0001.000

Missing values

2023-12-11T05:59:58.213917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T05:59:58.287563image/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

회계연도항목구분명금액(원)
02016공립39044398000
12016사립470959037000
22016어린이집545921520000
32016유치원510003435000
42016합계1055924955000
52015공립38132817480
62015사립466957514520
72015어린이집540927318000
82015유치원505090332000
92015합계1046017650000
회계연도항목구분명금액(원)
152013공립34276586590
162013사립365832666020
172013어린이집322953612000
182013유치원400109252610
192013합계723062864610
202012공립12949035410
212012사립127876882700
222012어린이집102359669000
232012유치원140825918110
242012합계243185587110