Overview

Dataset statistics

Number of variables3
Number of observations911
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory24.1 KiB
Average record size in memory27.1 B

Variable types

Numeric2
Categorical1

Dataset

Description부산광역시_해운대구_재정정보공개시스템_지출내역일자합계_20191230
Author부산광역시 해운대구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15050172

Alerts

지급일자 is highly overall correlated with 세입회계년도High correlation
세입회계년도 is highly overall correlated with 지급일자High correlation
지급일자 has unique valuesUnique
지출액 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:13:51.498694
Analysis finished2023-12-10 16:13:52.288796
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지급일자
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct911
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20174963
Minimum20160105
Maximum20191105
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.1 KiB
2023-12-11T01:13:52.386695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20160105
5-th percentile20160314
Q120161212
median20171128
Q320181120
95-th percentile20190824
Maximum20191105
Range31000
Interquartile range (IQR)19907

Descriptive statistics

Standard deviation11016.962
Coefficient of variation (CV)0.00054607099
Kurtosis-1.3248638
Mean20174963
Median Absolute Deviation (MAD)9980
Skewness0.069095224
Sum1.8379391 × 1010
Variance1.2137344 × 108
MonotonicityNot monotonic
2023-12-11T01:13:52.577924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20161230 1
 
0.1%
20180622 1
 
0.1%
20180620 1
 
0.1%
20180619 1
 
0.1%
20180618 1
 
0.1%
20180615 1
 
0.1%
20180614 1
 
0.1%
20180612 1
 
0.1%
20180611 1
 
0.1%
20180608 1
 
0.1%
Other values (901) 901
98.9%
ValueCountFrequency (%)
20160105 1
0.1%
20160106 1
0.1%
20160107 1
0.1%
20160108 1
0.1%
20160111 1
0.1%
20160112 1
0.1%
20160113 1
0.1%
20160114 1
0.1%
20160115 1
0.1%
20160118 1
0.1%
ValueCountFrequency (%)
20191105 1
0.1%
20191104 1
0.1%
20191101 1
0.1%
20191030 1
0.1%
20191029 1
0.1%
20191028 1
0.1%
20191025 1
0.1%
20191024 1
0.1%
20191023 1
0.1%
20191022 1
0.1%

세입회계년도
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size7.2 KiB
2016
242 
2017
235 
2018
233 
2019
201 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2016 242
26.6%
2017 235
25.8%
2018 233
25.6%
2019 201
22.1%

Length

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

Common Values (Plot)

2023-12-11T01:13:52.816946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016 242
26.6%
2017 235
25.8%
2018 233
25.6%
2019 201
22.1%

지출액
Real number (ℝ)

UNIQUE 

Distinct911
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0969904 × 109
Minimum-28400000
Maximum1.9914897 × 1010
Zeros0
Zeros (%)0.0%
Negative4
Negative (%)0.4%
Memory size8.1 KiB
2023-12-11T01:13:52.983454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-28400000
5-th percentile1.7609294 × 108
Q14.2363688 × 108
median8.106848 × 108
Q31.7987781 × 109
95-th percentile1.0064144 × 1010
Maximum1.9914897 × 1010
Range1.9943297 × 1010
Interquartile range (IQR)1.3751412 × 109

Descriptive statistics

Standard deviation3.2332011 × 109
Coefficient of variation (CV)1.5418292
Kurtosis5.7472848
Mean2.0969904 × 109
Median Absolute Deviation (MAD)4.9023807 × 108
Skewness2.5006101
Sum1.9103583 × 1012
Variance1.0453589 × 1019
MonotonicityNot monotonic
2023-12-11T01:13:53.204465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4400755140 1
 
0.1%
3470149510 1
 
0.1%
12169539550 1
 
0.1%
431011020 1
 
0.1%
615904870 1
 
0.1%
760634310 1
 
0.1%
602529630 1
 
0.1%
957861390 1
 
0.1%
1411256120 1
 
0.1%
798457880 1
 
0.1%
Other values (901) 901
98.9%
ValueCountFrequency (%)
-28400000 1
0.1%
-25000000 1
0.1%
-19981370 1
0.1%
-770000 1
0.1%
120000 1
0.1%
400830 1
0.1%
12537000 1
0.1%
14140310 1
0.1%
51002380 1
0.1%
56294510 1
0.1%
ValueCountFrequency (%)
19914896990 1
0.1%
16374501120 1
0.1%
16143853300 1
0.1%
15780405647 1
0.1%
15669200930 1
0.1%
15648333170 1
0.1%
15163848800 1
0.1%
15001804340 1
0.1%
14768668850 1
0.1%
14413660940 1
0.1%

Interactions

2023-12-11T01:13:51.877920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:13:51.623041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:13:52.001781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:13:51.727477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:13:53.351379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지급일자세입회계년도지출액
지급일자1.0001.0000.169
세입회계년도1.0001.0000.169
지출액0.1690.1691.000
2023-12-11T01:13:53.466872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지급일자지출액세입회계년도
지급일자1.0000.0801.000
지출액0.0801.0000.102
세입회계년도1.0000.1021.000

Missing values

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

지급일자세입회계년도지출액
02016123020164400755140
12016122920162953440080
22016122820162214580480
32016122720161456042690
4201612262016768832460
520161223201610976840810
62016122220162928182460
72016122120161270193590
82016122020168994288450
9201612192016399323060
지급일자세입회계년도지출액
9012019011620191602907080
90220190115201980429990
9032019011420192104546080
9042019011120191175632360
905201901102019108306930
906201901092019935322210
90720190108201914140310
9082019010720193386322130
909201901042019318433020
910201901032019120000