Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 7515 |
Missing cells | 20021 |
Missing cells (%) | 33.3% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 506.5 KiB |
Average record size in memory | 69.0 B |
Variable types
DateTime | 1 |
---|---|
Categorical | 2 |
Numeric | 4 |
Unsupported | 1 |
Dataset
Description | 경상북도 영주시 재정정보공개시스템 세입현황(일자, 회계명, 세임명, 수입액 등) |
---|---|
Author | 경상북도 영주시 |
URL | https://www.data.go.kr/data/15062964/fileData.do |
세입명 is highly overall correlated with 회계명 | High correlation |
회계명 is highly overall correlated with 세입명 | High correlation |
전일누계(천원) is highly overall correlated with 수입액(천원) and 1 other fields | High correlation |
수입액(천원) is highly overall correlated with 전일누계(천원) and 1 other fields | High correlation |
합계(천원) is highly overall correlated with 전일누계(천원) and 1 other fields | High correlation |
전일누계(천원) has 161 (2.1%) missing values | Missing |
수입액(천원) has 5247 (69.8%) missing values | Missing |
과오납반환(천원) has 7098 (94.5%) missing values | Missing |
과목경정 has 7515 (100.0%) missing values | Missing |
과목경정 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
합계(천원) has 149 (2.0%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 05:46:14.233131 |
---|---|
Analysis finished | 2023-12-12 05:46:16.971468 |
Duration | 2.74 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
일자
Date
Distinct | 1033 |
---|---|
Distinct (%) | 13.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 58.8 KiB |
Minimum | 2016-01-04 00:00:00 |
---|---|
Maximum | 2020-03-17 00:00:00 |
회계명
Categorical
HIGH CORRELATION
 
Distinct | 13 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 58.8 KiB |
수질개선특별회계 | |
---|---|
주차장특별회계 | |
의료급여기금특별회계 | |
일반회계 | |
저소득주민주거안정기금특별회계 | |
Other values (8) |
Length
Max length | 21 |
---|---|
Median length | 15 |
Mean length | 10.40519 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 수질개선특별회계 |
---|---|
2nd row | 주차장특별회계 |
3rd row | 수질개선특별회계 |
4th row | 주차장특별회계 |
5th row | 수질개선특별회계 |
Common Values
Value | Count | Frequency (%) |
수질개선특별회계 | 1006 | |
주차장특별회계 | 755 | |
의료급여기금특별회계 | 524 | 7.0% |
일반회계 | 523 | 7.0% |
저소득주민주거안정기금특별회계 | 523 | 7.0% |
주민소득지원및생활안정기금특별회계 | 523 | 7.0% |
장기미집행도시계획시설대지보상임시특별회계 | 523 | 7.0% |
농공지구조성사업특별회계 | 523 | 7.0% |
치수사업특별회계 | 523 | 7.0% |
기반시설특별회계 | 523 | 7.0% |
Other values (3) | 1569 |
Length
Value | Count | Frequency (%) |
수질개선특별회계 | 1006 | |
주차장특별회계 | 755 | |
의료급여기금특별회계 | 524 | 7.0% |
일반회계 | 523 | 7.0% |
저소득주민주거안정기금특별회계 | 523 | 7.0% |
주민소득지원및생활안정기금특별회계 | 523 | 7.0% |
장기미집행도시계획시설대지보상임시특별회계 | 523 | 7.0% |
농공지구조성사업특별회계 | 523 | 7.0% |
치수사업특별회계 | 523 | 7.0% |
기반시설특별회계 | 523 | 7.0% |
Other values (3) | 1569 |
세입명
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 58.8 KiB |
회계별총계 | |
---|---|
세외수입 |
Length
Max length | 5 |
---|---|
Median length | 5 |
Mean length | 4.7656687 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 세외수입 |
---|---|
2nd row | 세외수입 |
3rd row | 세외수입 |
4th row | 세외수입 |
5th row | 세외수입 |
Common Values
Value | Count | Frequency (%) |
회계별총계 | 5754 | |
세외수입 | 1761 | 23.4% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
회계별총계 | 5754 | |
세외수입 | 1761 | 23.4% |
전일누계(천원)
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 2566 |
---|---|
Distinct (%) | 34.9% |
Missing | 161 |
Missing (%) | 2.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 35986057 |
Minimum | 3 |
---|---|
Maximum | 8.2544233 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 66.2 KiB |
Quantile statistics
Minimum | 3 |
---|---|
5-th percentile | 153359 |
Q1 | 1355799 |
median | 2576696 |
Q3 | 10813684 |
95-th percentile | 3.3199534 × 108 |
Maximum | 8.2544233 × 108 |
Range | 8.2544233 × 108 |
Interquartile range (IQR) | 9457885 |
Descriptive statistics
Standard deviation | 1.1778594 × 108 |
---|---|
Coefficient of variation (CV) | 3.2730994 |
Kurtosis | 16.010549 |
Mean | 35986057 |
Median Absolute Deviation (MAD) | 1852796 |
Skewness | 4.0514186 |
Sum | 2.6464146 × 1011 |
Variance | 1.3873528 × 1016 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
574637 | 119 | 1.6% |
300129 | 119 | 1.6% |
16775 | 102 | 1.4% |
1663725 | 96 | 1.3% |
560474 | 67 | 0.9% |
2298561 | 67 | 0.9% |
992361 | 63 | 0.8% |
345008 | 63 | 0.8% |
2118444 | 62 | 0.8% |
299847 | 61 | 0.8% |
Other values (2556) | 6535 | |
(Missing) | 161 | 2.1% |
Value | Count | Frequency (%) |
3 | 7 | 0.1% |
264 | 1 | < 0.1% |
686 | 1 | < 0.1% |
1247 | 58 | |
1485 | 1 | < 0.1% |
2541 | 1 | < 0.1% |
3000 | 11 | 0.1% |
3666 | 1 | < 0.1% |
5301 | 1 | < 0.1% |
5729 | 1 | < 0.1% |
Value | Count | Frequency (%) |
825442329 | 1 | |
799732053 | 1 | |
799128007 | 1 | |
774751772 | 1 | |
774381734 | 1 | |
773753352 | 1 | |
772397835 | 1 | |
747630801 | 1 | |
744375877 | 1 | |
743079198 | 1 |
수입액(천원)
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 1930 |
---|---|
Distinct (%) | 85.1% |
Missing | 5247 |
Missing (%) | 69.8% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 799544.11 |
Minimum | -4000000 |
---|---|
Maximum | 1.5772321 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 37 |
Negative (%) | 0.5% |
Memory size | 66.2 KiB |
Quantile statistics
Minimum | -4000000 |
---|---|
5-th percentile | 26.35 |
Q1 | 1519.75 |
median | 4764.5 |
Q3 | 157718.5 |
95-th percentile | 3007578.2 |
Maximum | 1.5772321 × 108 |
Range | 1.6172321 × 108 |
Interquartile range (IQR) | 156198.75 |
Descriptive statistics
Standard deviation | 4795910.7 |
---|---|
Coefficient of variation (CV) | 5.9983065 |
Kurtosis | 526.03024 |
Mean | 799544.11 |
Median Absolute Deviation (MAD) | 4749 |
Skewness | 18.60138 |
Sum | 1.813366 × 109 |
Variance | 2.3000759 × 1013 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
6 | 20 | 0.3% |
100 | 19 | 0.3% |
2000 | 17 | 0.2% |
12000 | 17 | 0.2% |
50 | 12 | 0.2% |
30 | 12 | 0.2% |
200 | 11 | 0.1% |
60 | 11 | 0.1% |
-75394 | 9 | 0.1% |
5 | 6 | 0.1% |
Other values (1920) | 2134 | |
(Missing) | 5247 |
Value | Count | Frequency (%) |
-4000000 | 1 | < 0.1% |
-3000000 | 4 | |
-2000000 | 2 | |
-1000000 | 1 | < 0.1% |
-816363 | 1 | < 0.1% |
-800000 | 1 | < 0.1% |
-668999 | 1 | < 0.1% |
-650000 | 1 | < 0.1% |
-325265 | 1 | < 0.1% |
-196673 | 1 | < 0.1% |
Value | Count | Frequency (%) |
157723214 | 1 | |
46837101 | 1 | |
44943245 | 1 | |
39959024 | 1 | |
38306213 | 1 | |
36088241 | 1 | |
34329605 | 1 | |
33670073 | 1 | |
33322061 | 1 | |
31796525 | 1 |
과오납반환(천원)
Real number (ℝ)
MISSING
 
Distinct | 368 |
---|---|
Distinct (%) | 88.2% |
Missing | 7098 |
Missing (%) | 94.5% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 7903.8801 |
Minimum | -5349 |
---|---|
Maximum | 1056166 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 2 |
Negative (%) | < 0.1% |
Memory size | 66.2 KiB |
Quantile statistics
Minimum | -5349 |
---|---|
5-th percentile | 12.6 |
Q1 | 144 |
median | 757 |
Q3 | 2866 |
95-th percentile | 15325.2 |
Maximum | 1056166 |
Range | 1061515 |
Interquartile range (IQR) | 2722 |
Descriptive statistics
Standard deviation | 56425.214 |
---|---|
Coefficient of variation (CV) | 7.1389259 |
Kurtosis | 289.88453 |
Mean | 7903.8801 |
Median Absolute Deviation (MAD) | 712 |
Skewness | 16.07238 |
Sum | 3295918 |
Variance | 3.1838048 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4 | 6 | 0.1% |
40 | 5 | 0.1% |
2 | 4 | 0.1% |
50 | 3 | < 0.1% |
581 | 3 | < 0.1% |
30 | 3 | < 0.1% |
494 | 3 | < 0.1% |
10 | 3 | < 0.1% |
26 | 2 | < 0.1% |
20 | 2 | < 0.1% |
Other values (358) | 383 | 5.1% |
(Missing) | 7098 |
Value | Count | Frequency (%) |
-5349 | 1 | < 0.1% |
-4110 | 1 | < 0.1% |
2 | 4 | |
3 | 2 | < 0.1% |
4 | 6 | |
6 | 1 | < 0.1% |
9 | 1 | < 0.1% |
10 | 3 | |
11 | 2 | < 0.1% |
13 | 2 | < 0.1% |
Value | Count | Frequency (%) |
1056166 | 1 | |
267120 | 1 | |
238361 | 1 | |
225116 | 1 | |
142731 | 1 | |
79611 | 1 | |
74882 | 1 | |
67707 | 1 | |
63051 | 1 | |
60106 | 1 |
과목경정
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 7515 |
---|---|
Missing (%) | 100.0% |
Memory size | 66.2 KiB |
합계(천원)
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 2626 |
---|---|
Distinct (%) | 34.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 35456836 |
Minimum | 0 |
---|---|
Maximum | 8.271938 × 108 |
Zeros | 149 |
Zeros (%) | 2.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 66.2 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 16775 |
Q1 | 1331660 |
median | 2557843 |
Q3 | 9717235.5 |
95-th percentile | 3.2947458 × 108 |
Maximum | 8.271938 × 108 |
Range | 8.271938 × 108 |
Interquartile range (IQR) | 8385575.5 |
Descriptive statistics
Standard deviation | 1.1729455 × 108 |
---|---|
Coefficient of variation (CV) | 3.3080941 |
Kurtosis | 16.359811 |
Mean | 35456836 |
Median Absolute Deviation (MAD) | 1982862 |
Skewness | 4.0921615 |
Sum | 2.6645812 × 1011 |
Variance | 1.3758011 × 1016 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 149 | 2.0% |
574637 | 119 | 1.6% |
300129 | 119 | 1.6% |
16775 | 101 | 1.3% |
1663725 | 97 | 1.3% |
2298561 | 67 | 0.9% |
560474 | 67 | 0.9% |
345008 | 63 | 0.8% |
992361 | 63 | 0.8% |
2118444 | 61 | 0.8% |
Other values (2616) | 6609 |
Value | Count | Frequency (%) |
0 | 149 | |
3 | 7 | 0.1% |
351 | 1 | < 0.1% |
686 | 1 | < 0.1% |
1247 | 58 | 0.8% |
2541 | 1 | < 0.1% |
3000 | 10 | 0.1% |
3666 | 1 | < 0.1% |
5301 | 1 | < 0.1% |
5729 | 1 | < 0.1% |
Value | Count | Frequency (%) |
827193801 | 1 | |
800676932 | 1 | |
799735243 | 1 | |
775934697 | 1 | |
774467018 | 1 | |
773846727 | 1 | |
773716282 | 1 | |
772399837 | 1 | |
744931124 | 1 | |
744373947 | 1 |
회계명 | 세입명 | 전일누계(천원) | 수입액(천원) | 과오납반환(천원) | 합계(천원) | |
---|---|---|---|---|---|---|
회계명 | 1.000 | 1.000 | 0.637 | 0.140 | 0.000 | 0.638 |
세입명 | 1.000 | 1.000 | 0.194 | 0.052 | 0.000 | 0.190 |
전일누계(천원) | 0.637 | 0.194 | 1.000 | 0.353 | 0.136 | 1.000 |
수입액(천원) | 0.140 | 0.052 | 0.353 | 1.000 | 0.642 | 0.322 |
과오납반환(천원) | 0.000 | 0.000 | 0.136 | 0.642 | 1.000 | 0.161 |
합계(천원) | 0.638 | 0.190 | 1.000 | 0.322 | 0.161 | 1.000 |
세입명 | 회계명 | |
---|---|---|
세입명 | 1.000 | 0.999 |
회계명 | 0.999 | 1.000 |
전일누계(천원) | 수입액(천원) | 과오납반환(천원) | 합계(천원) | 회계명 | 세입명 | |
---|---|---|---|---|---|---|
전일누계(천원) | 1.000 | 0.643 | 0.197 | 0.997 | 0.327 | 0.148 |
수입액(천원) | 0.643 | 1.000 | 0.135 | 0.651 | 0.076 | 0.064 |
과오납반환(천원) | 0.197 | 0.135 | 1.000 | 0.201 | 0.000 | 0.000 |
합계(천원) | 0.997 | 0.651 | 0.201 | 1.000 | 0.327 | 0.146 |
회계명 | 0.327 | 0.076 | 0.000 | 0.327 | 1.000 | 0.999 |
세입명 | 0.148 | 0.064 | 0.000 | 0.146 | 0.999 | 1.000 |
일자 | 회계명 | 세입명 | 전일누계(천원) | 수입액(천원) | 과오납반환(천원) | 과목경정 | 합계(천원) | |
---|---|---|---|---|---|---|---|---|
0 | 2020-03-17 | 수질개선특별회계 | 세외수입 | 2438950 | <NA> | <NA> | <NA> | 2438950 |
1 | 2020-03-17 | 주차장특별회계 | 세외수입 | 11310093 | 2238 | <NA> | <NA> | 11312331 |
2 | 2020-03-16 | 수질개선특별회계 | 세외수입 | 2438950 | <NA> | <NA> | <NA> | 2438950 |
3 | 2020-03-16 | 주차장특별회계 | 세외수입 | 11308867 | 1225 | <NA> | <NA> | 11310092 |
4 | 2020-03-13 | 수질개선특별회계 | 세외수입 | 2438950 | <NA> | <NA> | <NA> | 2438950 |
5 | 2020-03-13 | 주차장특별회계 | 세외수입 | 11306250 | <NA> | <NA> | <NA> | 11306250 |
6 | 2020-03-12 | 수질개선특별회계 | 세외수입 | 2438950 | <NA> | <NA> | <NA> | 2438950 |
7 | 2020-03-12 | 주차장특별회계 | 세외수입 | 11304870 | <NA> | <NA> | <NA> | 11304870 |
8 | 2020-03-11 | 수질개선특별회계 | 세외수입 | 2438950 | <NA> | <NA> | <NA> | 2438950 |
9 | 2020-03-11 | 주차장특별회계 | 세외수입 | 11303619 | <NA> | <NA> | <NA> | 11303619 |
일자 | 회계명 | 세입명 | 전일누계(천원) | 수입액(천원) | 과오납반환(천원) | 과목경정 | 합계(천원) | |
---|---|---|---|---|---|---|---|---|
7505 | 2016-01-04 | 의료급여기금특별회계 | 회계별총계 | 2057475 | <NA> | <NA> | <NA> | 2057475 |
7506 | 2016-01-04 | 저소득주민주거안정기금특별회계 | 회계별총계 | 1093049 | <NA> | <NA> | <NA> | 1093049 |
7507 | 2016-01-04 | 주민소득지원및생활안정기금특별회계 | 회계별총계 | 2068506 | <NA> | <NA> | <NA> | 2068506 |
7508 | 2016-01-04 | 장기미집행도시계획시설대지보상임시특별회계 | 회계별총계 | 1247 | <NA> | <NA> | <NA> | 1247 |
7509 | 2016-01-04 | 농공지구조성사업특별회계 | 회계별총계 | 2962879 | <NA> | <NA> | <NA> | 2962879 |
7510 | 2016-01-04 | 치수사업특별회계 | 회계별총계 | 30838722 | <NA> | <NA> | <NA> | 30838722 |
7511 | 2016-01-04 | 기반시설특별회계 | 회계별총계 | 16775 | <NA> | <NA> | <NA> | 16775 |
7512 | 2016-01-04 | 주거환경개선사업특별회계 | 회계별총계 | 1494204 | <NA> | <NA> | <NA> | 1494204 |
7513 | 2016-01-04 | 수도사업특별회계 | 회계별총계 | 20343513 | 1735 | <NA> | <NA> | 20345248 |
7514 | 2016-01-04 | 하수도사업특별회계 | 회계별총계 | 42348193 | <NA> | <NA> | <NA> | 42348193 |