Overview

Dataset statistics

Number of variables9
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory810.5 KiB
Average record size in memory83.0 B

Variable types

Numeric2
Categorical5
Text2

Dataset

Description부산광역시해운대구_재정정보공개시스템_세입자료수납내역표_20221219
Author부산광역시 해운대구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15050173

Alerts

세입예산액(receipt_budget) has constant value ""Constant
세입과목단계2(receipt_subject_depth_2) is highly overall correlated with 세입과목단계1(receipt_subject_depth_1) and 2 other fieldsHigh correlation
세입과목단계4(receipt_subject_depth_4) is highly overall correlated with 세입과목단계1(receipt_subject_depth_1) and 2 other fieldsHigh correlation
세입과목단계1(receipt_subject_depth_1) is highly overall correlated with 세입과목단계2(receipt_subject_depth_2) and 2 other fieldsHigh correlation
세입과목단계3(receipt_subject_depth_3) is highly overall correlated with 세입과목단계1(receipt_subject_depth_1) and 2 other fieldsHigh correlation
세입금일수납(receipt_purchase) is highly skewed (γ1 = 30.57826898)Skewed
세입금일수납(receipt_purchase) has 8373 (83.7%) zerosZeros

Reproduction

Analysis started2023-12-10 16:57:48.343361
Analysis finished2023-12-10 16:57:50.211294
Duration1.87 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

세입자료일련번호(tax_revenue_seq)
Real number (ℝ)

Distinct4536
Distinct (%)45.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.018799 × 1011
Minimum2.0152015 × 1011
Maximum2.0222022 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:57:50.534882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0152015 × 1011
5-th percentile2.0152016 × 1011
Q12.0162018 × 1011
median2.0192019 × 1011
Q32.0202022 × 1011
95-th percentile2.0222022 × 1011
Maximum2.0222022 × 1011
Range7.0007012 × 108
Interquartile range (IQR)4.000404 × 108

Descriptive statistics

Standard deviation2.1863055 × 108
Coefficient of variation (CV)0.0010829733
Kurtosis-1.1036993
Mean2.018799 × 1011
Median Absolute Deviation (MAD)2.000111 × 108
Skewness-0.29453035
Sum2.018799 × 1015
Variance4.7799318 × 1016
MonotonicityNot monotonic
2023-12-11T01:57:50.691249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
202020220115 7
 
0.1%
201720170402 6
 
0.1%
201620160609 6
 
0.1%
202120221003 6
 
0.1%
201920200911 6
 
0.1%
201620180123 6
 
0.1%
202020221114 6
 
0.1%
201920201209 6
 
0.1%
202120210411 6
 
0.1%
201520170217 6
 
0.1%
Other values (4526) 9939
99.4%
ValueCountFrequency (%)
201520151103 4
< 0.1%
201520151105 2
< 0.1%
201520151106 3
< 0.1%
201520151107 1
 
< 0.1%
201520151108 2
< 0.1%
201520151109 2
< 0.1%
201520151110 1
 
< 0.1%
201520151111 2
< 0.1%
201520151112 3
< 0.1%
201520151113 3
< 0.1%
ValueCountFrequency (%)
202220221218 3
< 0.1%
202220221217 1
 
< 0.1%
202220221216 3
< 0.1%
202220221214 3
< 0.1%
202220221212 2
 
< 0.1%
202220221211 1
 
< 0.1%
202220221210 1
 
< 0.1%
202220221209 5
0.1%
202220221208 1
 
< 0.1%
202220221207 1
 
< 0.1%

세입과목단계1(receipt_subject_depth_1)
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반회계(세외수입)
1318 
일반회계(보조금)
1314 
일반회계(보전수입등및내부거래)
1298 
지하수관리특별회계(회계별총계)
1256 
기반시설특별회계(회계별총계)
1254 
Other values (3)
3560 

Length

Max length16
Median length12
Mean length12.5066
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반회계(보조금)
2nd row지하수관리특별회계(회계별총계)
3rd row지하수관리특별회계(회계별총계)
4th row일반회계(보전수입등및내부거래)
5th row지하수관리특별회계(회계별총계)

Common Values

ValueCountFrequency (%)
일반회계(세외수입) 1318
13.2%
일반회계(보조금) 1314
13.1%
일반회계(보전수입등및내부거래) 1298
13.0%
지하수관리특별회계(회계별총계) 1256
12.6%
기반시설특별회계(회계별총계) 1254
12.5%
일반회계(조정교부금등) 1226
12.3%
일반회계(지방세수입) 1214
12.1%
일반회계(지방교부세) 1120
11.2%

Length

2023-12-11T01:57:50.845363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:57:50.964907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반회계(세외수입 1318
13.2%
일반회계(보조금 1314
13.1%
일반회계(보전수입등및내부거래 1298
13.0%
지하수관리특별회계(회계별총계 1256
12.6%
기반시설특별회계(회계별총계 1254
12.5%
일반회계(조정교부금등 1226
12.3%
일반회계(지방세수입 1214
12.1%
일반회계(지방교부세 1120
11.2%

세입과목단계2(receipt_subject_depth_2)
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반회계(세외수입)
1318 
일반회계(보조금)
1314 
일반회계(보전수입등및내부거래)
1298 
지하수관리특별회계(회계별총계)
1256 
기반시설특별회계(회계별총계)
1254 
Other values (3)
3560 

Length

Max length16
Median length12
Mean length12.5066
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반회계(보조금)
2nd row지하수관리특별회계(회계별총계)
3rd row지하수관리특별회계(회계별총계)
4th row일반회계(보전수입등및내부거래)
5th row지하수관리특별회계(회계별총계)

Common Values

ValueCountFrequency (%)
일반회계(세외수입) 1318
13.2%
일반회계(보조금) 1314
13.1%
일반회계(보전수입등및내부거래) 1298
13.0%
지하수관리특별회계(회계별총계) 1256
12.6%
기반시설특별회계(회계별총계) 1254
12.5%
일반회계(조정교부금등) 1226
12.3%
일반회계(지방세수입) 1214
12.1%
일반회계(지방교부세) 1120
11.2%

Length

2023-12-11T01:57:51.134533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:57:51.310261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반회계(세외수입 1318
13.2%
일반회계(보조금 1314
13.1%
일반회계(보전수입등및내부거래 1298
13.0%
지하수관리특별회계(회계별총계 1256
12.6%
기반시설특별회계(회계별총계 1254
12.5%
일반회계(조정교부금등 1226
12.3%
일반회계(지방세수입 1214
12.1%
일반회계(지방교부세 1120
11.2%

세입과목단계3(receipt_subject_depth_3)
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반회계(세외수입)
1318 
일반회계(보조금)
1314 
일반회계(보전수입등및내부거래)
1298 
지하수관리특별회계(회계별총계)
1256 
기반시설특별회계(회계별총계)
1254 
Other values (3)
3560 

Length

Max length16
Median length12
Mean length12.5066
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반회계(보조금)
2nd row지하수관리특별회계(회계별총계)
3rd row지하수관리특별회계(회계별총계)
4th row일반회계(보전수입등및내부거래)
5th row지하수관리특별회계(회계별총계)

Common Values

ValueCountFrequency (%)
일반회계(세외수입) 1318
13.2%
일반회계(보조금) 1314
13.1%
일반회계(보전수입등및내부거래) 1298
13.0%
지하수관리특별회계(회계별총계) 1256
12.6%
기반시설특별회계(회계별총계) 1254
12.5%
일반회계(조정교부금등) 1226
12.3%
일반회계(지방세수입) 1214
12.1%
일반회계(지방교부세) 1120
11.2%

Length

2023-12-11T01:57:51.499534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:57:51.695976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반회계(세외수입 1318
13.2%
일반회계(보조금 1314
13.1%
일반회계(보전수입등및내부거래 1298
13.0%
지하수관리특별회계(회계별총계 1256
12.6%
기반시설특별회계(회계별총계 1254
12.5%
일반회계(조정교부금등 1226
12.3%
일반회계(지방세수입 1214
12.1%
일반회계(지방교부세 1120
11.2%

세입과목단계4(receipt_subject_depth_4)
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반회계(세외수입)
1318 
일반회계(보조금)
1314 
일반회계(보전수입등및내부거래)
1298 
지하수관리특별회계(회계별총계)
1256 
기반시설특별회계(회계별총계)
1254 
Other values (3)
3560 

Length

Max length16
Median length12
Mean length12.5066
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반회계(보조금)
2nd row지하수관리특별회계(회계별총계)
3rd row지하수관리특별회계(회계별총계)
4th row일반회계(보전수입등및내부거래)
5th row지하수관리특별회계(회계별총계)

Common Values

ValueCountFrequency (%)
일반회계(세외수입) 1318
13.2%
일반회계(보조금) 1314
13.1%
일반회계(보전수입등및내부거래) 1298
13.0%
지하수관리특별회계(회계별총계) 1256
12.6%
기반시설특별회계(회계별총계) 1254
12.5%
일반회계(조정교부금등) 1226
12.3%
일반회계(지방세수입) 1214
12.1%
일반회계(지방교부세) 1120
11.2%

Length

2023-12-11T01:57:51.931345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:57:52.093728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반회계(세외수입 1318
13.2%
일반회계(보조금 1314
13.1%
일반회계(보전수입등및내부거래 1298
13.0%
지하수관리특별회계(회계별총계 1256
12.6%
기반시설특별회계(회계별총계 1254
12.5%
일반회계(조정교부금등 1226
12.3%
일반회계(지방세수입 1214
12.1%
일반회계(지방교부세 1120
11.2%

세입예산액(receipt_budget)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2023-12-11T01:57:52.278517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:57:52.386035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

세입전일누계(receipt_sum)
Text

Distinct2527
Distinct (%)25.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T01:57:52.658141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.5609
Min length2

Characters and Unicode

Total characters115609
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1866 ?
Unique (%)18.7%

Sample

1st row177506382950
2nd row1538702560
3rd row619120850
4th row45349620980
5th row1761470250
ValueCountFrequency (%)
82817063770 253
 
2.5%
48749791000 192
 
1.9%
62875053390 188
 
1.9%
588536483740 182
 
1.8%
1956168110 176
 
1.8%
336424480 174
 
1.7%
45349620980 173
 
1.7%
150345555300 169
 
1.7%
73266962030 168
 
1.7%
94177247310 163
 
1.6%
Other values (2517) 8162
81.6%
2023-12-11T01:57:53.106086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 21543
18.6%
1 11377
9.8%
3 10431
9.0%
7 10268
8.9%
9991
8.6%
5 9756
8.4%
8 8808
7.6%
9 8673
7.5%
6 8370
 
7.2%
4 8190
 
7.1%
Other values (3) 8202
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 105600
91.3%
Space Separator 9991
 
8.6%
Open Punctuation 9
 
< 0.1%
Close Punctuation 9
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 21543
20.4%
1 11377
10.8%
3 10431
9.9%
7 10268
9.7%
5 9756
9.2%
8 8808
8.3%
9 8673
8.2%
6 8370
 
7.9%
4 8190
 
7.8%
2 8184
 
7.8%
Space Separator
ValueCountFrequency (%)
9991
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 115609
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 21543
18.6%
1 11377
9.8%
3 10431
9.0%
7 10268
8.9%
9991
8.6%
5 9756
8.4%
8 8808
7.6%
9 8673
7.5%
6 8370
 
7.2%
4 8190
 
7.1%
Other values (3) 8202
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 115609
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 21543
18.6%
1 11377
9.8%
3 10431
9.0%
7 10268
8.9%
9991
8.6%
5 9756
8.4%
8 8808
7.6%
9 8673
7.5%
6 8370
 
7.2%
4 8190
 
7.1%
Other values (3) 8202
 
7.1%

세입금일수납(receipt_purchase)
Real number (ℝ)

SKEWED  ZEROS 

Distinct1602
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2498359 × 108
Minimum0
Maximum7.46 × 1010
Zeros8373
Zeros (%)83.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:57:53.317815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1.8484513 × 108
Maximum7.46 × 1010
Range7.46 × 1010
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.2154256 × 109
Coefficient of variation (CV)9.7246811
Kurtosis1535.401
Mean1.2498359 × 108
Median Absolute Deviation (MAD)0
Skewness30.578269
Sum1.2498359 × 1012
Variance1.4772593 × 1018
MonotonicityNot monotonic
2023-12-11T01:57:53.515060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 8373
83.7%
311660 5
 
0.1%
358750 4
 
< 0.1%
266660 4
 
< 0.1%
153080 3
 
< 0.1%
482500 3
 
< 0.1%
510000 3
 
< 0.1%
310000000 2
 
< 0.1%
10000000 2
 
< 0.1%
4200 2
 
< 0.1%
Other values (1592) 1599
 
16.0%
ValueCountFrequency (%)
0 8373
83.7%
130 1
 
< 0.1%
1930 1
 
< 0.1%
1940 1
 
< 0.1%
2630 1
 
< 0.1%
2820 1
 
< 0.1%
3600 1
 
< 0.1%
3630 1
 
< 0.1%
4030 1
 
< 0.1%
4200 2
 
< 0.1%
ValueCountFrequency (%)
74600000000 1
< 0.1%
33053361570 1
< 0.1%
27685839000 1
< 0.1%
20000000000 1
< 0.1%
17504870000 1
< 0.1%
16600000000 1
< 0.1%
16446655000 1
< 0.1%
15632843000 1
< 0.1%
15599930000 1
< 0.1%
15128768260 1
< 0.1%

세입합계(receipt_total)
Text

Distinct2549
Distinct (%)25.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T01:57:53.813648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.5749
Min length2

Characters and Unicode

Total characters115749
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1923 ?
Unique (%)19.2%

Sample

1st row177506382950
2nd row1538702560
3rd row619120850
4th row45349620980
5th row1764855370
ValueCountFrequency (%)
82817063770 254
 
2.5%
48749791000 192
 
1.9%
62875053390 189
 
1.9%
588536483740 182
 
1.8%
1956168110 176
 
1.8%
336424480 175
 
1.8%
45349620980 173
 
1.7%
150345555300 169
 
1.7%
73266962030 168
 
1.7%
94177247310 163
 
1.6%
Other values (2539) 8159
81.6%
2023-12-11T01:57:54.313499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 21512
18.6%
1 11417
9.9%
3 10458
9.0%
7 10294
8.9%
9993
8.6%
5 9767
8.4%
8 8836
7.6%
9 8639
7.5%
6 8373
 
7.2%
2 8261
 
7.1%
Other values (3) 8199
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 105742
91.4%
Space Separator 9993
 
8.6%
Open Punctuation 7
 
< 0.1%
Close Punctuation 7
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 21512
20.3%
1 11417
10.8%
3 10458
9.9%
7 10294
9.7%
5 9767
9.2%
8 8836
8.4%
9 8639
8.2%
6 8373
 
7.9%
2 8261
 
7.8%
4 8185
 
7.7%
Space Separator
ValueCountFrequency (%)
9993
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 115749
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 21512
18.6%
1 11417
9.9%
3 10458
9.0%
7 10294
8.9%
9993
8.6%
5 9767
8.4%
8 8836
7.6%
9 8639
7.5%
6 8373
 
7.2%
2 8261
 
7.1%
Other values (3) 8199
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 115749
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 21512
18.6%
1 11417
9.9%
3 10458
9.0%
7 10294
8.9%
9993
8.6%
5 9767
8.4%
8 8836
7.6%
9 8639
7.5%
6 8373
 
7.2%
2 8261
 
7.1%
Other values (3) 8199
 
7.1%

Interactions

2023-12-11T01:57:49.599067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:57:49.209449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:57:49.760345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:57:49.385231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:57:54.449638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세입자료일련번호(tax_revenue_seq)세입과목단계1(receipt_subject_depth_1)세입과목단계2(receipt_subject_depth_2)세입과목단계3(receipt_subject_depth_3)세입과목단계4(receipt_subject_depth_4)세입금일수납(receipt_purchase)
세입자료일련번호(tax_revenue_seq)1.0000.0000.0000.0000.0000.028
세입과목단계1(receipt_subject_depth_1)0.0001.0001.0001.0001.0000.074
세입과목단계2(receipt_subject_depth_2)0.0001.0001.0001.0001.0000.074
세입과목단계3(receipt_subject_depth_3)0.0001.0001.0001.0001.0000.074
세입과목단계4(receipt_subject_depth_4)0.0001.0001.0001.0001.0000.074
세입금일수납(receipt_purchase)0.0280.0740.0740.0740.0741.000
2023-12-11T01:57:54.601821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세입과목단계2(receipt_subject_depth_2)세입과목단계4(receipt_subject_depth_4)세입과목단계1(receipt_subject_depth_1)세입과목단계3(receipt_subject_depth_3)
세입과목단계2(receipt_subject_depth_2)1.0001.0001.0001.000
세입과목단계4(receipt_subject_depth_4)1.0001.0001.0001.000
세입과목단계1(receipt_subject_depth_1)1.0001.0001.0001.000
세입과목단계3(receipt_subject_depth_3)1.0001.0001.0001.000
2023-12-11T01:57:54.726769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세입자료일련번호(tax_revenue_seq)세입금일수납(receipt_purchase)세입과목단계1(receipt_subject_depth_1)세입과목단계2(receipt_subject_depth_2)세입과목단계3(receipt_subject_depth_3)세입과목단계4(receipt_subject_depth_4)
세입자료일련번호(tax_revenue_seq)1.0000.0460.0000.0000.0000.000
세입금일수납(receipt_purchase)0.0461.0000.0410.0410.0410.041
세입과목단계1(receipt_subject_depth_1)0.0000.0411.0001.0001.0001.000
세입과목단계2(receipt_subject_depth_2)0.0000.0411.0001.0001.0001.000
세입과목단계3(receipt_subject_depth_3)0.0000.0411.0001.0001.0001.000
세입과목단계4(receipt_subject_depth_4)0.0000.0411.0001.0001.0001.000

Missing values

2023-12-11T01:57:49.941434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:57:50.120940image/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

세입자료일련번호(tax_revenue_seq)세입과목단계1(receipt_subject_depth_1)세입과목단계2(receipt_subject_depth_2)세입과목단계3(receipt_subject_depth_3)세입과목단계4(receipt_subject_depth_4)세입예산액(receipt_budget)세입전일누계(receipt_sum)세입금일수납(receipt_purchase)세입합계(receipt_total)
11011201720170611일반회계(보조금)일반회계(보조금)일반회계(보조금)일반회계(보조금)01775063829500177506382950
11168201720170522지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)0153870256001538702560
17301201520170625지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)06191208500619120850
21181201520160223일반회계(보전수입등및내부거래)일반회계(보전수입등및내부거래)일반회계(보전수입등및내부거래)일반회계(보전수입등및내부거래)045349620980045349620980
4172201920190410지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)0176147025033851201764855370
17941201520170405지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)06191208500619120850
30684202020221023지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)0195616811001956168110
13454201620170315일반회계(보조금)일반회계(보조금)일반회계(보조금)일반회계(보조금)02989358989600298935898960
11412201720170421일반회계(보조금)일반회계(보조금)일반회계(보조금)일반회계(보조금)01300573066304929884000134987190630
3027201920190831지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)0183083435001830834350
세입자료일련번호(tax_revenue_seq)세입과목단계1(receipt_subject_depth_1)세입과목단계2(receipt_subject_depth_2)세입과목단계3(receipt_subject_depth_3)세입과목단계4(receipt_subject_depth_4)세입예산액(receipt_budget)세입전일누계(receipt_sum)세입금일수납(receipt_purchase)세입합계(receipt_total)
16662201620160129지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)0598187600966720599154320
3997201920190502일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)05403160000540316000
21235201520160216지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)06191208500619120850
16158201620160409일반회계(보조금)일반회계(보조금)일반회계(보조금)일반회계(보조금)096282807770096282807770
23052202220220805지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)지하수관리특별회계(회계별총계)019775209105886701978109580
19202201520161029일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)034597790000034597790000
11559201720170402일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)014095520000014095520000
13213201620170414일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)일반회계(조정교부금등)039776203000039776203000
20862201520160404기반시설특별회계(회계별총계)기반시설특별회계(회계별총계)기반시설특별회계(회계별총계)기반시설특별회계(회계별총계)07793146900779314690
10184201820180206일반회계(세외수입)일반회계(세외수입)일반회계(세외수입)일반회계(세외수입)02546405530852881502631693680