gimi9 Pandas Profiling

Dataset statistics

Number of variables	12
Number of observations	460
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	47.7 KiB
Average record size in memory	106.3 B

Variable types

Categorical	2
Text	2
Numeric	8

Dataset

Description	부산광역시 상수도사업본부 예산집행현황에 대한 데이터로 예산과목, 예산현액, 집행금액, 지출금액 등을 제공합니다.
Author	부산광역시 상수도사업본부
URL	https://www.data.go.kr/data/15100643/fileData.do

Alerts

`예산년도` has constant value ""	Constant
`반납금액` has constant value ""	Constant
`예산현액` is highly overall correlated with `집행금액` and 4 other fields	High correlation
`집행금액` is highly overall correlated with `예산현액` and 4 other fields	High correlation
`원인행위금액` is highly overall correlated with `예산현액` and 4 other fields	High correlation
`지출결의금액` is highly overall correlated with `예산현액` and 4 other fields	High correlation
`채무확정금액` is highly overall correlated with `예산현액` and 4 other fields	High correlation
`지출금액` is highly overall correlated with `예산현액` and 4 other fields	High correlation
`예산코드` has unique values	Unique
`예산과목명` has unique values	Unique
`집행금액` has 18 (3.9%) zeros	Zeros
`지출결의금액` has 18 (3.9%) zeros	Zeros
`채무확정금액` has 18 (3.9%) zeros	Zeros
`지출금액` has 18 (3.9%) zeros	Zeros
`과목경정금액` has 441 (95.9%) zeros	Zeros
`전용금액` has 427 (92.8%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 22:58:08.361171
Analysis finished	2023-12-11 22:58:15.878178
Duration	7.52 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

예산년도
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

2023	460

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023
2nd row	2023
3rd row	2023
4th row	2023
5th row	2023

Common Values

Value	Count	Frequency (%)
2023	460	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023	460	100.0%

예산코드
Text

UNIQUE

Distinct	460
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

Length

Max length	21
Median length	21
Mean length	20.971739
Min length	18

Characters and Unicode

Total characters	9647
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	460 ?
Unique (%)	100.0%

Sample

1st row	200230231405405-01001
2nd row	200230231405405-01003
3rd row	200230231405405-01004
4th row	200230231405405-01005
5th row	200230233401401-01001

Value	Count	Frequency (%)
200230231405405-01001	1	0.2%
700710751101101-03008	1	0.2%
700710751101101-03005	1	0.2%
700710751101101-02007	1	0.2%
700710751101101-02006	1	0.2%
700710751101101-02004	1	0.2%
700710751101101-02002	1	0.2%
700710751101101-02001	1	0.2%
700710751101101-01005	1	0.2%
700710751101101-01004	1	0.2%
Other values (450)	450	97.8%

Most occurring characters

Value	Count	Frequency (%)
0	3396	35.2%
1	1961	20.3%
2	1237	12.8%
7	1098	11.4%
4	509	5.3%
3	505	5.2%
-	460	4.8%
5	310	3.2%
6	112	1.2%
8	39	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9187	95.2%
Dash Punctuation	460	4.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3396	37.0%
1	1961	21.3%
2	1237	13.5%
7	1098	12.0%
4	509	5.5%
3	505	5.5%
5	310	3.4%
6	112	1.2%
8	39	0.4%
9	20	0.2%

Dash Punctuation

Value	Count	Frequency (%)
-	460	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9647	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3396	35.2%
1	1961	20.3%
2	1237	12.8%
7	1098	11.4%
4	509	5.3%
3	505	5.2%
-	460	4.8%
5	310	3.2%
6	112	1.2%
8	39	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9647	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3396	35.2%
1	1961	20.3%
2	1237	12.8%
7	1098	11.4%
4	509	5.3%
3	505	5.2%
-	460	4.8%
5	310	3.2%
6	112	1.2%
8	39	0.4%

예산과목명
Text

UNIQUE

Distinct	460
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

Length

Max length	79
Median length	55
Mean length	37.830435
Min length	17

Characters and Unicode

Total characters	17402
Distinct characters	320
Distinct categories	10 ?
Distinct scripts	3 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	460 ?
Unique (%)	100.0%

Sample

1st row	토지 - 자산취득비 - 자산및물품취득비 - 부지취득
2nd row	토지 - 자산취득비 - 자산및물품취득비 - 철마배수지 부지취득(21년이월)
3rd row	토지 - 자산취득비 - 자산및물품취득비 - 금곡배수지 부지취득(21년이월)
4th row	토지 - 자산취득비 - 자산및물품취득비 - 철마배수지 부지취득
5th row	건물 - 시설비및부대비 - 시설비 - 건축물 보수보강

Value	Count	Frequency (%)
	1376	33.6%
일반운영비	116	2.8%
일반관리비	105	2.6%
시설비및부대비	102	2.5%
및	101	2.5%
시설비	88	2.1%
정수비	84	2.0%
인건비	62	1.5%
배·급수비	62	1.5%
구축물	53	1.3%
Other values (638)	1950	47.6%

Most occurring characters

Value	Count	Frequency (%)
	3642	20.9%
비	1389	8.0%
-	1379	7.9%
수	850	4.9%
설	356	2.0%
관	332	1.9%
시	316	1.8%
리	304	1.7%
반	267	1.5%
및	264	1.5%
Other values (310)	8303	47.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	11967	68.8%
Space Separator	3642	20.9%
Dash Punctuation	1379	7.9%
Open Punctuation	113	0.6%
Close Punctuation	113	0.6%
Other Punctuation	109	0.6%
Decimal Number	57	0.3%
Uppercase Letter	16	0.1%
Math Symbol	4	< 0.1%
Lowercase Letter	2	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
비	1389	11.6%
수	850	7.1%
설	356	3.0%
관	332	2.8%
시	316	2.6%
리	304	2.5%
반	267	2.2%
및	264	2.2%
일	260	2.2%
지	235	2.0%
Other values (280)	7394	61.8%

Uppercase Letter

Value	Count	Frequency (%)
S	3	18.8%
C	2	12.5%
T	2	12.5%
V	1	6.2%
A	1	6.2%
D	1	6.2%
P	1	6.2%
I	1	6.2%
U	1	6.2%
M	1	6.2%
Other values (2)	2	12.5%

Decimal Number

Value	Count	Frequency (%)
2	21	36.8%
1	12	21.1%
3	8	14.0%
5	8	14.0%
6	4	7.0%
0	1	1.8%
4	1	1.8%
8	1	1.8%
7	1	1.8%

Other Punctuation

Value	Count	Frequency (%)
·	107	98.2%
,	2	1.8%

Lowercase Letter

Value	Count	Frequency (%)
v	1	50.0%
k	1	50.0%

Space Separator

Value	Count	Frequency (%)
	3642	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1379	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	113	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	113	100.0%

Math Symbol

Value	Count	Frequency (%)
~	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	11967	68.8%
Common	5417	31.1%
Latin	18	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
비	1389	11.6%
수	850	7.1%
설	356	3.0%
관	332	2.8%
시	316	2.6%
리	304	2.5%
반	267	2.2%
및	264	2.2%
일	260	2.2%
지	235	2.0%
Other values (280)	7394	61.8%

Common

Value	Count	Frequency (%)
	3642	67.2%
-	1379	25.5%
(	113	2.1%
)	113	2.1%
·	107	2.0%
2	21	0.4%
1	12	0.2%
3	8	0.1%
5	8	0.1%
6	4	0.1%
Other values (6)	10	0.2%

Latin

Value	Count	Frequency (%)
S	3	16.7%
C	2	11.1%
T	2	11.1%
V	1	5.6%
A	1	5.6%
D	1	5.6%
P	1	5.6%
I	1	5.6%
U	1	5.6%
M	1	5.6%
Other values (4)	4	22.2%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	11967	68.8%
ASCII	5328	30.6%
None	107	0.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3642	68.4%
-	1379	25.9%
(	113	2.1%
)	113	2.1%
2	21	0.4%
1	12	0.2%
3	8	0.2%
5	8	0.2%
6	4	0.1%
~	4	0.1%
Other values (19)	24	0.5%

Hangul

Value	Count	Frequency (%)
비	1389	11.6%
수	850	7.1%
설	356	3.0%
관	332	2.8%
시	316	2.6%
리	304	2.5%
반	267	2.2%
및	264	2.2%
일	260	2.2%
지	235	2.0%
Other values (280)	7394	61.8%

None

Value	Count	Frequency (%)
·	107	100.0%

예산현액
Real number (ℝ)

HIGH CORRELATION

Distinct	409
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0393103 × 10⁹

Minimum	0
Maximum	2.7 × 10¹⁰
Zeros	1
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	4.2 KiB

Quantile statistics

Minimum	0
5-th percentile	4785000
Q1	39234250
median	1.7125 × 10⁸
Q3	5.7933141 × 10⁸
95-th percentile	5.2090958 × 10⁹
Maximum	2.7 × 10¹⁰
Range	2.7 × 10¹⁰
Interquartile range (IQR)	5.4009716 × 10⁸

Descriptive statistics

Standard deviation	2.8820726 × 10⁹
Coefficient of variation (CV)	2.7730626
Kurtosis	30.987032
Mean	1.0393103 × 10⁹
Median Absolute Deviation (MAD)	1.5461599 × 10⁸
Skewness	5.1268748
Sum	4.7808275 × 10¹¹
Variance	8.3063425 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000000	5	1.1%
20000000	5	1.1%
40000000	4	0.9%
30000000	4	0.9%
24000000	3	0.7%
50000000	3	0.7%
15000000	3	0.7%
220000000	3	0.7%
250000000	3	0.7%
100000000	3	0.7%
Other values (399)	424	92.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.2%
613000	1	0.2%
1000000	1	0.2%
1120000	1	0.2%
1340000	1	0.2%
1500000	1	0.2%
1620000	1	0.2%
1744000	1	0.2%
1900000	2	0.4%
2000000	3	0.7%

Value	Count	Frequency (%)
27000000000	1	0.2%
20767946000	1	0.2%
19660285000	1	0.2%
19079179000	1	0.2%
17678037000	1	0.2%
15350000000	1	0.2%
13312800000	1	0.2%
13229663000	1	0.2%
13167000000	1	0.2%
11818636000	1	0.2%

집행금액
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	442
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5148785 × 10⁸

Minimum	0
Maximum	2.7908035 × 10¹⁰
Zeros	18
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	4.2 KiB

Quantile statistics

Minimum	0
5-th percentile	610251
Q1	19694245
median	87421615
Q3	4.6230199 × 10⁸
95-th percentile	4.7298102 × 10⁹
Maximum	2.7908035 × 10¹⁰
Range	2.7908035 × 10¹⁰
Interquartile range (IQR)	4.4260775 × 10⁸

Descriptive statistics

Standard deviation	3.0955659 × 10⁹
Coefficient of variation (CV)	3.2533951
Kurtosis	35.52083
Mean	9.5148785 × 10⁸
Median Absolute Deviation (MAD)	84743295
Skewness	5.6002529
Sum	4.3768441 × 10¹¹
Variance	9.5825281 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18	3.9%
3900000	2	0.4%
23664000	1	0.2%
812589450	1	0.2%
4473189440	1	0.2%
9253260	1	0.2%
123841740	1	0.2%
24636680	1	0.2%
20250330	1	0.2%
556247910	1	0.2%
Other values (432)	432	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	3.9%
243000	1	0.2%
422900	1	0.2%
450000	1	0.2%
528000	1	0.2%
564100	1	0.2%
612680	1	0.2%
637230	1	0.2%
750000	1	0.2%
779430	1	0.2%

Value	Count	Frequency (%)
27908035170	1	0.2%
25452177520	1	0.2%
22120587240	1	0.2%
21805184470	1	0.2%
18658288360	1	0.2%
17535375330	1	0.2%
16370403820	1	0.2%
14022200920	1	0.2%
12784709560	1	0.2%
11962308150	1	0.2%

원인행위금액
Real number (ℝ)

HIGH CORRELATION

Distinct	458
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1971672 × 10⁹

Minimum	0
Maximum	3.8699446 × 10¹⁰
Zeros	1
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	4.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2167026
Q1	24683952
median	1.1402515 × 10⁸
Q3	5.9240291 × 10⁸
95-th percentile	5.3117316 × 10⁹
Maximum	3.8699446 × 10¹⁰
Range	3.8699446 × 10¹⁰
Interquartile range (IQR)	5.6771896 × 10⁸

Descriptive statistics

Standard deviation	3.8505116 × 10⁹
Coefficient of variation (CV)	3.2163524
Kurtosis	39.754863
Mean	1.1971672 × 10⁹
Median Absolute Deviation (MAD)	1.08632 × 10⁸
Skewness	5.8091288
Sum	5.5069691 × 10¹¹
Variance	1.4826439 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90000000	2	0.4%
3900000	2	0.4%
23664000	1	0.2%
1797366040	1	0.2%
24636680	1	0.2%
20250330	1	0.2%
556247910	1	0.2%
22321320	1	0.2%
5215790	1	0.2%
164135070	1	0.2%
Other values (448)	448	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.2%
243000	1	0.2%
422900	1	0.2%
528000	1	0.2%
564100	1	0.2%
612680	1	0.2%
637230	1	0.2%
750000	1	0.2%
779430	1	0.2%
860000	1	0.2%

Value	Count	Frequency (%)
38699446240	1	0.2%
30819814840	1	0.2%
27908035170	1	0.2%
25110040740	1	0.2%
21805184470	1	0.2%
21195751900	1	0.2%
19466019150	1	0.2%
19254195420	1	0.2%
14022200920	1	0.2%
13228956110	1	0.2%

지출결의금액
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	442
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5148785 × 10⁸

Minimum	0
Maximum	2.7908035 × 10¹⁰
Zeros	18
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	4.2 KiB

Quantile statistics

Minimum	0
5-th percentile	610251
Q1	19694245
median	87421615
Q3	4.6230199 × 10⁸
95-th percentile	4.7298102 × 10⁹
Maximum	2.7908035 × 10¹⁰
Range	2.7908035 × 10¹⁰
Interquartile range (IQR)	4.4260775 × 10⁸

Descriptive statistics

Standard deviation	3.0955659 × 10⁹
Coefficient of variation (CV)	3.2533951
Kurtosis	35.52083
Mean	9.5148785 × 10⁸
Median Absolute Deviation (MAD)	84743295
Skewness	5.6002529
Sum	4.3768441 × 10¹¹
Variance	9.5825281 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18	3.9%
3900000	2	0.4%
23664000	1	0.2%
812589450	1	0.2%
4473189440	1	0.2%
9253260	1	0.2%
123841740	1	0.2%
24636680	1	0.2%
20250330	1	0.2%
556247910	1	0.2%
Other values (432)	432	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	3.9%
243000	1	0.2%
422900	1	0.2%
450000	1	0.2%
528000	1	0.2%
564100	1	0.2%
612680	1	0.2%
637230	1	0.2%
750000	1	0.2%
779430	1	0.2%

Value	Count	Frequency (%)
27908035170	1	0.2%
25452177520	1	0.2%
22120587240	1	0.2%
21805184470	1	0.2%
18658288360	1	0.2%
17535375330	1	0.2%
16370403820	1	0.2%
14022200920	1	0.2%
12784709560	1	0.2%
11962308150	1	0.2%

채무확정금액
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	442
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5137191 × 10⁸

Minimum	0
Maximum	2.7908035 × 10¹⁰
Zeros	18
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	4.2 KiB

Quantile statistics

Minimum	0
5-th percentile	610251
Q1	19694245
median	87421615
Q3	4.6230199 × 10⁸
95-th percentile	4.7298102 × 10⁹
Maximum	2.7908035 × 10¹⁰
Range	2.7908035 × 10¹⁰
Interquartile range (IQR)	4.4260775 × 10⁸

Descriptive statistics

Standard deviation	3.0954445 × 10⁹
Coefficient of variation (CV)	3.253664
Kurtosis	35.526481
Mean	9.5137191 × 10⁸
Median Absolute Deviation (MAD)	84743295
Skewness	5.6007351
Sum	4.3763108 × 10¹¹
Variance	9.5817767 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18	3.9%
3900000	2	0.4%
23664000	1	0.2%
812589450	1	0.2%
4473189440	1	0.2%
9253260	1	0.2%
123841740	1	0.2%
24636680	1	0.2%
20250330	1	0.2%
556247910	1	0.2%
Other values (432)	432	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	3.9%
243000	1	0.2%
422900	1	0.2%
450000	1	0.2%
528000	1	0.2%
564100	1	0.2%
612680	1	0.2%
637230	1	0.2%
750000	1	0.2%
779430	1	0.2%

Value	Count	Frequency (%)
27908035170	1	0.2%
25452177520	1	0.2%
22120587240	1	0.2%
21805184470	1	0.2%
18658288360	1	0.2%
17535375330	1	0.2%
16370403820	1	0.2%
14022200920	1	0.2%
12784709560	1	0.2%
11952906360	1	0.2%

지출금액
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	442
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.6907922 × 10⁸

Minimum	0
Maximum	2.7908035 × 10¹⁰
Zeros	18
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	4.2 KiB

Quantile statistics

Minimum	0
5-th percentile	610251
Q1	19869415
median	88435075
Q3	4.833732 × 10⁸
95-th percentile	4.8733551 × 10⁹
Maximum	2.7908035 × 10¹⁰
Range	2.7908035 × 10¹⁰
Interquartile range (IQR)	4.6350378 × 10⁸

Descriptive statistics

Standard deviation	3.1025379 × 10⁹
Coefficient of variation (CV)	3.2015317
Kurtosis	35.057696
Mean	9.6907922 × 10⁸
Median Absolute Deviation (MAD)	85800625
Skewness	5.5534625
Sum	4.4577644 × 10¹¹
Variance	9.6257412 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18	3.9%
3900000	2	0.4%
23664000	1	0.2%
811904010	1	0.2%
4473189440	1	0.2%
9253260	1	0.2%
123841740	1	0.2%
24636680	1	0.2%
20250330	1	0.2%
556247910	1	0.2%
Other values (432)	432	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	3.9%
243000	1	0.2%
422900	1	0.2%
450000	1	0.2%
528000	1	0.2%
564100	1	0.2%
612680	1	0.2%
637230	1	0.2%
750000	1	0.2%
779430	1	0.2%

Value	Count	Frequency (%)
27908035170	1	0.2%
25452177520	1	0.2%
22120587240	1	0.2%
21805184470	1	0.2%
18658288360	1	0.2%
17535375330	1	0.2%
16370403820	1	0.2%
14022200920	1	0.2%
12784709560	1	0.2%
11952906360	1	0.2%

반납금액
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

0	460

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	460	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	460	100.0%

과목경정금액
Real number (ℝ)

ZEROS

Distinct	20
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	411080.46

Minimum	0
Maximum	48352140
Zeros	441
Zeros (%)	95.9%
Negative	0
Negative (%)	0.0%
Memory size	4.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	48352140
Range	48352140
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3733860.6
Coefficient of variation (CV)	9.0830409
Kurtosis	135.94238
Mean	411080.46
Median Absolute Deviation (MAD)	0
Skewness	11.449386
Sum	1.8909701 × 10⁸
Variance	1.3941715 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	441	95.9%
3694920	1	0.2%
48352140	1	0.2%
6583200	1	0.2%
14915900	1	0.2%
2320000	1	0.2%
90000	1	0.2%
1816720	1	0.2%
19800	1	0.2%
4251920	1	0.2%
Other values (10)	10	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	441	95.9%
19800	1	0.2%
90000	1	0.2%
360000	1	0.2%
460410	1	0.2%
726000	1	0.2%
991010	1	0.2%
1816720	1	0.2%
2320000	1	0.2%
2728000	1	0.2%

Value	Count	Frequency (%)
48352140	1	0.2%
46878000	1	0.2%
39107690	1	0.2%
14915900	1	0.2%
8110620	1	0.2%
6583200	1	0.2%
4620000	1	0.2%
4251920	1	0.2%
3694920	1	0.2%
3070680	1	0.2%

전용금액
Real number (ℝ)

ZEROS

Distinct	30
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	-281000
Maximum	381000
Zeros	427
Zeros (%)	92.8%
Negative	17
Negative (%)	3.7%
Memory size	4.2 KiB

Quantile statistics

Minimum	-281000
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	381000
Range	662000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	35855.338
Coefficient of variation (CV)	nan
Kurtosis	71.654322
Mean	0
Median Absolute Deviation (MAD)	0
Skewness	3.1017708
Sum	0
Variance	1.2856053 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	427	92.8%
-20000	2	0.4%
-30000	2	0.4%
30000	2	0.4%
20000	2	0.4%
-55000	1	0.2%
2000	1	0.2%
-2950	1	0.2%
-2000	1	0.2%
55000	1	0.2%
Other values (20)	20	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-281000	1	0.2%
-270000	1	0.2%
-190550	1	0.2%
-163947	1	0.2%
-100000	1	0.2%
-55000	1	0.2%
-50000	1	0.2%
-47900	1	0.2%
-30000	2	0.4%
-20000	2	0.4%

Value	Count	Frequency (%)
381000	1	0.2%
354497	1	0.2%
270000	1	0.2%
55000	1	0.2%
50000	1	0.2%
47900	1	0.2%
30000	2	0.4%
20000	2	0.4%
15000	1	0.2%
2760	1	0.2%

Phik (φk)
Auto

Heatmap
Table

	예산현액	집행금액	원인행위금액	지출결의금액	채무확정금액	지출금액	과목경정금액	전용금액
예산현액	1.000	0.895	0.938	0.895	0.895	0.895	0.825	0.258
집행금액	0.895	1.000	0.969	1.000	1.000	1.000	0.445	0.536
원인행위금액	0.938	0.969	1.000	0.969	0.969	0.969	0.727	0.452
지출결의금액	0.895	1.000	0.969	1.000	1.000	1.000	0.445	0.536
채무확정금액	0.895	1.000	0.969	1.000	1.000	1.000	0.445	0.536
지출금액	0.895	1.000	0.969	1.000	1.000	1.000	0.445	0.536
과목경정금액	0.825	0.445	0.727	0.445	0.445	0.445	1.000	0.000
전용금액	0.258	0.536	0.452	0.536	0.536	0.536	0.000	1.000

Heatmap
Table

	예산현액	집행금액	원인행위금액	지출결의금액	채무확정금액	지출금액	과목경정금액	전용금액
예산현액	1.000	0.931	0.972	0.931	0.931	0.925	0.159	-0.101
집행금액	0.931	1.000	0.951	1.000	1.000	0.998	0.170	-0.089
원인행위금액	0.972	0.951	1.000	0.951	0.951	0.952	0.156	-0.087
지출결의금액	0.931	1.000	0.951	1.000	1.000	0.998	0.170	-0.089
채무확정금액	0.931	1.000	0.951	1.000	1.000	0.998	0.170	-0.089
지출금액	0.925	0.998	0.952	0.998	0.998	1.000	0.168	-0.092
과목경정금액	0.159	0.170	0.156	0.170	0.170	0.168	1.000	-0.078
전용금액	-0.101	-0.089	-0.087	-0.089	-0.089	-0.092	-0.078	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	예산년도	예산코드	예산과목명	예산현액	집행금액	원인행위금액	지출결의금액	채무확정금액	지출금액
0	2023	200230231405405-01001	토지 - 자산취득비 - 자산및물품취득비 - 부지취득	24000000	23664000	23664000	23664000	23664000	23664000
1	2023	200230231405405-01003	토지 - 자산취득비 - 자산및물품취득비 - 철마배수지 부지취득(21년이월)	544521700	544521700	544521700	544521700	544521700	544521700
2	2023	200230231405405-01004	토지 - 자산취득비 - 자산및물품취득비 - 금곡배수지 부지취득(21년이월)	746779200	550121970	550121970	550121970	550121970	550121970
3	2023	200230231405405-01005	토지 - 자산취득비 - 자산및물품취득비 - 철마배수지 부지취득	100000000	94567490	94567490	94567490	94567490	94567490
4	2023	200230233401401-01001	건물 - 시설비및부대비 - 시설비 - 건축물 보수보강	141000000	302978400	302978400	302978400	302978400	302978400
5	2023	200230233401401-01002	건물 - 시설비및부대비 - 시설비 - 취·정수장 건축물 보수보강	396000000	642930160	642930160	642930160	642930160	642930160
6	2023	200230233401401-01004	건물 - 시설비및부대비 - 시설비 - 청사 보수보강	220000000	289068370	289068370	289068370	289068370	289068370
7	2023	200230233401401-01005	건물 - 시설비및부대비 - 시설비 - 직원사택 보수보강	300000000	274499400	274499400	274499400	274499400	274499400
8	2023	200230233401401-02001	건물 - 시설비및부대비 - 감리비 - 직원사택 보수보강 감리	5000000	3900000	3900000	3900000	3900000	3900000
9	2023	200230234401401-01001	구축물 - 시설비및부대비 - 시설비 - 취·정수 공정시설 보수보강	300000000	164035440	260766540	164035440	164035440	164035440

	예산년도	예산코드	예산과목명	예산현액	집행금액	원인행위금액	지출결의금액	채무확정금액	지출금액	과목경정금액	전용금액
450	2023	700710752214214-04005	징수및수용가관리비 - 수선유지교체비 - 지원사업성 시설비 - 옥내급수관 직결급수 사업	2970000000	2970000000	4837814270	2970000000	2970000000	4837814270	14915900	0
451	2023	700710752214214-05002	징수및수용가관리비 - 수선유지교체비 - 수선유지비 - 방수비 납부	961496000	574553040	592371840	574553040	574553040	569089440	0	0
452	2023	700710752214214-05003	징수및수용가관리비 - 수선유지교체비 - 수선유지비 - 블록 유수율 유지관리	2565750000	1285937100	2035564200	1285937100	1285937100	1285937100	0	0
453	2023	700710752214214-05004	징수및수용가관리비 - 수선유지교체비 - 수선유지비 - 앵글밸브 등 보호통내 시설물 정비	2232250000	1625938120	1662331180	1625938120	1625938120	1625938120	0	-190550
454	2023	700710752214214-05005	징수및수용가관리비 - 수선유지교체비 - 수선유지비 - 누수수리 도급	13312800000	9467342540	9664027710	9467342540	9467342540	9438456890	6583200	0
455	2023	700710752214214-05011	징수및수용가관리비 - 수선유지교체비 - 수선유지비 - 옥내 누수 및 수질점검	3730747000	4561283750	4561690080	4561283750	4561283750	4561283750	0	354497
456	2023	700710752214214-05014	징수및수용가관리비 - 수선유지교체비 - 수선유지비 - 급수불편해소	13167000000	9867462370	10064112740	9867462370	9867462370	9867462370	48352140	0
457	2023	700710752304304-01001	징수및수용가관리비 - 연금부담금등 - 연금부담금 - 공무직(무기계약)근로자 국민연금부담금	203564000	119304230	119304230	119304230	119304230	119304230	0	0
458	2023	700710752304304-02001	징수및수용가관리비 - 연금부담금등 - 국민건강보험부담금등 - 공무직(무기계약)근로자 보험부담금	305321000	191683730	191683730	191683730	191683730	191683730	0	0
459	2023	700770782802802-14001	전기손익수정손실 - 반환금기타 - 전기손익수정손실 - 전기손익수정손실	429000000	345919480	345919480	345919480	345919480	345919480	0	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Other Punctuation

Lowercase Letter

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

None

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample