Overview

Dataset statistics

Number of variables4
Number of observations8139
Missing cells0
Missing cells (%)0.0%
Duplicate rows53
Duplicate rows (%)0.7%
Total size in memory270.4 KiB
Average record size in memory34.0 B

Variable types

Categorical3
Numeric1

Dataset

Description성질별 단체별 세출결산 현황
Author행정안전부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=H6H79BW0B35AHHAWUPQD22527079&infSeq=1

Alerts

Dataset has 53 (0.7%) duplicate rowsDuplicates
시군명 is highly overall correlated with 회계연도High correlation
회계연도 is highly overall correlated with 시군명High correlation
시군명 is highly imbalanced (77.3%)Imbalance
세출결산액(원) has 842 (10.3%) zerosZeros

Reproduction

Analysis started2023-12-10 23:07:13.021517
Analysis finished2023-12-10 23:07:13.677662
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size63.7 KiB
2020
7145 
2021
994 

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 7145
87.8%
2021 994
 
12.2%

Length

2023-12-11T08:07:13.729284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:07:13.822752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 7145
87.8%
2021 994
 
12.2%

시군명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct33
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size63.7 KiB
<NA>
7145 
고양시
 
35
성남시
 
34
양주시
 
34
경기도
 
34
Other values (28)
857 

Length

Max length4
Median length4
Mean length3.8883155
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가평군
2nd row가평군
3rd row가평군
4th row가평군
5th row가평군

Common Values

ValueCountFrequency (%)
<NA> 7145
87.8%
고양시 35
 
0.4%
성남시 34
 
0.4%
양주시 34
 
0.4%
경기도 34
 
0.4%
수원시 34
 
0.4%
가평군 34
 
0.4%
광주시 33
 
0.4%
오산시 33
 
0.4%
화성시 32
 
0.4%
Other values (23) 691
 
8.5%

Length

2023-12-11T08:07:13.918356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 7145
87.8%
고양시 35
 
0.4%
성남시 34
 
0.4%
양주시 34
 
0.4%
경기도 34
 
0.4%
수원시 34
 
0.4%
가평군 34
 
0.4%
광주시 33
 
0.4%
오산시 33
 
0.4%
화성시 32
 
0.4%
Other values (23) 691
 
8.5%

세목명
Categorical

Distinct38
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size63.7 KiB
민간이전
 
275
여비
 
275
예비비
 
275
시설비및부대비
 
275
자산취득비
 
275
Other values (33)
6764 

Length

Max length10
Median length9
Mean length5.0788795
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row민간이전
2nd row출연금
3rd row전출금
4th row차입금이자상환
5th row시설비및부대비

Common Values

ValueCountFrequency (%)
민간이전 275
 
3.4%
여비 275
 
3.4%
예비비 275
 
3.4%
시설비및부대비 275
 
3.4%
자산취득비 275
 
3.4%
자치단체등자본이전 275
 
3.4%
반환금기타 275
 
3.4%
출연금 275
 
3.4%
인건비 275
 
3.4%
일반운영비 275
 
3.4%
Other values (28) 5389
66.2%

Length

2023-12-11T08:07:14.025580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
민간이전 275
 
3.4%
업무추진비 275
 
3.4%
여비 275
 
3.4%
연금부담금등 275
 
3.4%
포상금 275
 
3.4%
일반보전금 275
 
3.4%
연구개발비 275
 
3.4%
재료비 275
 
3.4%
의회비 275
 
3.4%
직무수행경비 275
 
3.4%
Other values (28) 5389
66.2%

세출결산액(원)
Real number (ℝ)

ZEROS 

Distinct7184
Distinct (%)88.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.2721715 × 1010
Minimum0
Maximum3.7709991 × 1012
Zeros842
Zeros (%)10.3%
Negative0
Negative (%)0.0%
Memory size71.7 KiB
2023-12-11T08:07:14.158317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q14.5401356 × 108
median3.6290384 × 109
Q32.6632099 × 1010
95-th percentile2.0986011 × 1011
Maximum3.7709991 × 1012
Range3.7709991 × 1012
Interquartile range (IQR)2.6178086 × 1010

Descriptive statistics

Standard deviation1.4210401 × 1011
Coefficient of variation (CV)3.3262711
Kurtosis246.94664
Mean4.2721715 × 1010
Median Absolute Deviation (MAD)3.6290384 × 109
Skewness12.346768
Sum3.4771204 × 1014
Variance2.0193549 × 1022
MonotonicityNot monotonic
2023-12-11T08:07:14.406273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 842
 
10.3%
229140000 10
 
0.1%
200000000 9
 
0.1%
10000000 8
 
0.1%
50000000 7
 
0.1%
20000000 6
 
0.1%
30000000 5
 
0.1%
3505350 5
 
0.1%
100000000 5
 
0.1%
150000000 4
 
< 0.1%
Other values (7174) 7238
88.9%
ValueCountFrequency (%)
0 842
10.3%
88100 1
 
< 0.1%
100000 1
 
< 0.1%
116840 1
 
< 0.1%
121000 1
 
< 0.1%
156290 1
 
< 0.1%
183000 1
 
< 0.1%
186000 1
 
< 0.1%
187000 1
 
< 0.1%
196900 1
 
< 0.1%
ValueCountFrequency (%)
3770999111764 1
< 0.1%
3761171288000 1
< 0.1%
3715766097477 1
< 0.1%
3049489545340 1
< 0.1%
2707926725000 1
< 0.1%
2559534571526 1
< 0.1%
2400098817655 1
< 0.1%
1773681506810 1
< 0.1%
1641805487000 1
< 0.1%
1550138734890 1
< 0.1%

Interactions

2023-12-11T08:07:13.468349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:07:14.644763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계연도시군명세목명세출결산액(원)
회계연도1.000NaN0.1170.050
시군명NaN1.0000.0000.184
세목명0.1170.0001.0000.285
세출결산액(원)0.0500.1840.2851.000
2023-12-11T08:07:14.742286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군명세목명회계연도
시군명1.0000.0001.000
세목명0.0001.0000.093
회계연도1.0000.0931.000
2023-12-11T08:07:14.825729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세출결산액(원)회계연도시군명세목명
세출결산액(원)1.0000.0500.0800.108
회계연도0.0501.0001.0000.093
시군명0.0801.0001.0000.000
세목명0.1080.0930.0001.000

Missing values

2023-12-11T08:07:13.576799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:07:13.646055image/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가평군민간이전78650806068
12021가평군출연금948708000
22021가평군전출금10281900980
32021가평군차입금이자상환232827390
42021가평군시설비및부대비177310831283
52021가평군민간자본이전26670889334
62021가평군자치단체등자본이전46437181000
72021가평군공사공단자본전출금641781730
82021가평군자산취득비4500631275
92021가평군기타자본이전0
회계연도시군명세목명세출결산액(원)
81292020<NA>출연금9539095000
81302020<NA>민간이전261025273880
81312020<NA>자치단체등이전41474147390
81322020<NA>전출금17663290570
81332020<NA>국외이전14613320
81342020<NA>차입금이자상환3777766630
81352020<NA>시설비및부대비306747654086
81362020<NA>민간자본이전50160502620
81372020<NA>자치단체등자본이전21338442000
81382020<NA>자산취득비6080102060

Duplicate rows

Most frequently occurring

회계연도시군명세목명세출결산액(원)# duplicates
262020<NA>예비비0243
242020<NA>기타회계등전출금0225
292020<NA>예탁금064
302020<NA>융자금044
62020<NA>기타내부거래043
272020<NA>예수금원리금상환040
72020<NA>기타자본이전016
12020<NA>교육비특별회계전출금22914000010
252020<NA>배상금등08
22020<NA>국외이전07