Overview

Dataset statistics

Number of variables5
Number of observations409
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory16.9 KiB
Average record size in memory42.3 B

Variable types

Categorical4
Numeric1

Dataset

Description교육비 특별회계 세입 세출 결산 현황
Author행정안전부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=W4SPVGNZUGRHNJWIWO4122291729&infSeq=1

Alerts

세목명 is highly overall correlated with 구분명High correlation
구분명 is highly overall correlated with 세목명High correlation
회계연도 is highly overall correlated with 자치단체명High correlation
자치단체명 is highly overall correlated with 회계연도High correlation
회계연도 is highly imbalanced (69.8%)Imbalance
결산액(원) has unique valuesUnique

Reproduction

Analysis started2023-12-10 21:17:06.569039
Analysis finished2023-12-10 21:17:08.762823
Duration2.19 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2020
387 
2021
 
22

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 387
94.6%
2021 22
 
5.4%

Length

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

Common Values (Plot)

2023-12-11T06:17:08.933359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 387
94.6%
2021 22
 
5.4%

자치단체명
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
경기본청
45 
인천본청
 
24
부산본청
 
24
충남본청
 
24
서울본청
 
23
Other values (12)
269 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기본청
2nd row경기본청
3rd row경기본청
4th row경기본청
5th row경기본청

Common Values

ValueCountFrequency (%)
경기본청 45
 
11.0%
인천본청 24
 
5.9%
부산본청 24
 
5.9%
충남본청 24
 
5.9%
서울본청 23
 
5.6%
충북본청 23
 
5.6%
경북본청 23
 
5.6%
경남본청 23
 
5.6%
대전본청 23
 
5.6%
세종본청 23
 
5.6%
Other values (7) 154
37.7%

Length

2023-12-11T06:17:09.043064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기본청 45
 
11.0%
부산본청 24
 
5.9%
충남본청 24
 
5.9%
인천본청 24
 
5.9%
경남본청 23
 
5.6%
강원본청 23
 
5.6%
세종본청 23
 
5.6%
대전본청 23
 
5.6%
경북본청 23
 
5.6%
충북본청 23
 
5.6%
Other values (7) 154
37.7%

구분명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
세입
354 
세출
55 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세입
2nd row세출
3rd row세입
4th row세입
5th row세입

Common Values

ValueCountFrequency (%)
세입 354
86.6%
세출 55
 
13.4%

Length

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

Common Values (Plot)

2023-12-11T06:17:09.243530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
세입 354
86.6%
세출 55
 
13.4%

세목명
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
지방교육재정교부금
 
18
제재금수입
 
18
특별회계전입금
 
18
법정이전수입
 
18
비법정이전수입
 
18
Other values (21)
319 

Length

Max length9
Median length7
Mean length6.0611247
Min length3

Unique

Unique2 ?
Unique (%)0.5%

Sample

1st row지방교육재정교부금
2nd row교육일반
3rd row특별회계전입금
4th row법정이전수입
5th row비법정이전수입

Common Values

ValueCountFrequency (%)
지방교육재정교부금 18
 
4.4%
제재금수입 18
 
4.4%
특별회계전입금 18
 
4.4%
법정이전수입 18
 
4.4%
비법정이전수입 18
 
4.4%
민간이전수입 18
 
4.4%
기본적교육수입 18
 
4.4%
이자수입 18
 
4.4%
자산임대수입 18
 
4.4%
자산매각대 18
 
4.4%
Other values (16) 229
56.0%

Length

2023-12-11T06:17:09.349295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
지방교육재정교부금 18
 
4.4%
사용료및수수료수입 18
 
4.4%
국고보조금 18
 
4.4%
평생·직업교육 18
 
4.4%
유아및초중등교육 18
 
4.4%
이월금 18
 
4.4%
순세계잉여금 18
 
4.4%
제재금수입 18
 
4.4%
잡수입 18
 
4.4%
교육일반 18
 
4.4%
Other values (16) 229
56.0%

결산액(원)
Real number (ℝ)

UNIQUE 

Distinct409
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.8480363 × 1011
Minimum0
Maximum1.7406605 × 1013
Zeros1
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2023-12-11T06:17:09.488937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile41595240
Q16.68797 × 108
median1.1462178 × 1010
Q31.3499674 × 1011
95-th percentile2.9556121 × 1012
Maximum1.7406605 × 1013
Range1.7406605 × 1013
Interquartile range (IQR)1.3432795 × 1011

Descriptive statistics

Standard deviation1.7588428 × 1012
Coefficient of variation (CV)3.6279489
Kurtosis50.746697
Mean4.8480363 × 1011
Median Absolute Deviation (MAD)1.1413367 × 1010
Skewness6.544879
Sum1.9828468 × 1014
Variance3.093528 × 1024
MonotonicityNot monotonic
2023-12-11T06:17:09.629847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
13553833107360 1
 
0.2%
1361056753300 1
 
0.2%
2442760150 1
 
0.2%
25398688160 1
 
0.2%
74671280 1
 
0.2%
436752240 1
 
0.2%
5480990130 1
 
0.2%
2595499010 1
 
0.2%
29174867250 1
 
0.2%
238274463980 1
 
0.2%
Other values (399) 399
97.6%
ValueCountFrequency (%)
0 1
0.2%
113580 1
0.2%
2087800 1
0.2%
2174000 1
0.2%
2289460 1
0.2%
4703000 1
0.2%
5180460 1
0.2%
9979190 1
0.2%
10000000 1
0.2%
12776530 1
0.2%
ValueCountFrequency (%)
17406604853030 1
0.2%
16545281341560 1
0.2%
13553833107360 1
0.2%
11845282833700 1
0.2%
10323784855816 1
0.2%
5489347626070 1
0.2%
5216970653400 1
0.2%
4616164273500 1
0.2%
4511815980140 1
0.2%
4346407591700 1
0.2%

Interactions

2023-12-11T06:17:08.436686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:17:09.725649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도자치단체명구분명세목명결산액(원)
회계연도1.0000.7200.0000.0000.291
자치단체명0.7201.0000.0000.0000.000
구분명0.0000.0001.0001.0000.437
세목명0.0000.0001.0001.0000.565
결산액(원)0.2910.0000.4370.5651.000
2023-12-11T06:17:09.840787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세목명자치단체명회계연도구분명
세목명1.0000.0000.0000.970
자치단체명0.0001.0000.6490.000
회계연도0.0000.6491.0000.000
구분명0.9700.0000.0001.000
2023-12-11T06:17:09.935189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
결산액(원)회계연도자치단체명구분명세목명
결산액(원)1.0000.2170.0000.3260.258
회계연도0.2171.0000.6490.0000.000
자치단체명0.0000.6491.0000.0000.000
구분명0.3260.0000.0001.0000.970
세목명0.2580.0000.0000.9701.000

Missing values

2023-12-11T06:17:08.616235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T06:17:08.719310image/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

회계연도자치단체명구분명세목명결산액(원)
02021경기본청세입지방교육재정교부금13553833107360
12021경기본청세출교육일반1086533621970
22021경기본청세입특별회계전입금1113873552000
32021경기본청세입법정이전수입3305591667800
42021경기본청세입비법정이전수입181892410000
52021경기본청세입민간이전수입82226859320
62021경기본청세입자치단체간이전수입3120167000
72021경기본청세입기본적교육수입654314990
82021경기본청세입사용료및수수료수입855182800
92021경기본청세입자산임대수입411223310
회계연도자치단체명구분명세목명결산액(원)
3992020제주본청세입융자금원금회수1361740000
4002020제주본청세입제재금수입239396660
4012020제주본청세입잡수입13764260010
4022020제주본청세입과년도수입9979190
4032020제주본청세입순세계잉여금23160482920
4042020제주본청세입보조금사용잔액341179500
4052020제주본청세입이월금200576811580
4062020제주본청세출유아및초중등교육1257022641650
4072020제주본청세출평생·직업교육2851113910
4082020제주본청세출교육일반29081525700