gimi9 Pandas Profiling

Dataset statistics

Number of variables	3
Number of observations	736
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	19.5 KiB
Average record size in memory	27.2 B

Variable types

Numeric	3

Dataset

Description	노년부양비(행정구역, 노년부양비) 정보를 제공합니다.
Author	충청남도
URL	https://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=101

Alerts

`기준연도` is highly overall correlated with `노년부양비`	High correlation
`노년부양비` is highly overall correlated with `기준연도`	High correlation
`행정구역코드` has 41 (5.6%) zeros	Zeros

Reproduction

Analysis started	2024-01-09 22:27:13.611352
Analysis finished	2024-01-09 22:27:14.675349
Duration	1.06 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준연도
Real number (ℝ)

HIGH CORRELATION

Distinct	41
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2030.053

Minimum	2010
Maximum	2050
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	2010
5-th percentile	2012
Q1	2020
median	2030
Q3	2040
95-th percentile	2048
Maximum	2050
Range	40
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	11.812419
Coefficient of variation (CV)	0.0058187737
Kurtosis	-1.1999217
Mean	2030.053
Median Absolute Deviation (MAD)	10
Skewness	-0.0011954753
Sum	1494119
Variance	139.53324
Monotonicity	Increasing

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
2031	18	2.4%
2039	18	2.4%
2032	18	2.4%
2033	18	2.4%
2034	18	2.4%
2035	18	2.4%
2036	18	2.4%
2037	18	2.4%
2038	18	2.4%
2040	18	2.4%
Other values (31)	556	75.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	17	2.3%
2011	17	2.3%
2012	18	2.4%
2013	18	2.4%
2014	18	2.4%
2015	18	2.4%
2016	18	2.4%
2017	18	2.4%
2018	18	2.4%
2019	18	2.4%

Value	Count	Frequency (%)
2050	18	2.4%
2049	18	2.4%
2048	18	2.4%
2047	18	2.4%
2046	18	2.4%
2045	18	2.4%
2044	18	2.4%
2043	18	2.4%
2042	18	2.4%
2041	18	2.4%

행정구역코드
Real number (ℝ)

ZEROS

Distinct	18
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.55163

Minimum	0
Maximum	39
Zeros	41
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	23
median	31
Q3	35
95-th percentile	39
Maximum	39
Range	39
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	9.7676432
Coefficient of variation (CV)	0.35452142
Kurtosis	1.3317351
Mean	27.55163
Median Absolute Deviation (MAD)	6
Skewness	-1.2603275
Sum	20278
Variance	95.406854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	41	5.6%
11	41	5.6%
39	41	5.6%
38	41	5.6%
37	41	5.6%
36	41	5.6%
35	41	5.6%
34	41	5.6%
33	41	5.6%
32	41	5.6%
Other values (8)	326	44.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	41	5.6%
11	41	5.6%
21	41	5.6%
22	41	5.6%
23	41	5.6%
24	41	5.6%
25	41	5.6%
26	41	5.6%
29	39	5.3%
31	41	5.6%

Value	Count	Frequency (%)
39	41	5.6%
38	41	5.6%
37	41	5.6%
36	41	5.6%
35	41	5.6%
34	41	5.6%
33	41	5.6%
32	41	5.6%
31	41	5.6%
29	39	5.3%

노년부양비
Real number (ℝ)

HIGH CORRELATION

Distinct	488
Distinct (%)	66.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.754484

Minimum	8.9
Maximum	114.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	8.9
5-th percentile	13.675
Q1	23.4
median	39.85
Q3	62.875
95-th percentile	90.2
Maximum	114.2
Range	105.3
Interquartile range (IQR)	39.475

Descriptive statistics

Standard deviation	24.722812
Coefficient of variation (CV)	0.55240973
Kurtosis	-0.54969946
Mean	44.754484
Median Absolute Deviation (MAD)	18.55
Skewness	0.61202929
Sum	32939.3
Variance	611.21745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23.9	5	0.7%
19.6	5	0.7%
74.9	4	0.5%
23.4	4	0.5%
16.3	4	0.5%
21.8	4	0.5%
59.0	4	0.5%
22.4	4	0.5%
16.9	4	0.5%
22.0	4	0.5%
Other values (478)	694	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8.9	1	0.1%
9.1	1	0.1%
9.6	1	0.1%
10.1	1	0.1%
10.6	1	0.1%
11.2	1	0.1%
11.3	1	0.1%
11.4	1	0.1%
11.6	2	0.3%
11.7	1	0.1%

Value	Count	Frequency (%)
114.2	1	0.1%
112.9	1	0.1%
111.0	1	0.1%
110.8	1	0.1%
109.8	1	0.1%
108.0	1	0.1%
107.9	1	0.1%
105.2	1	0.1%
104.6	1	0.1%
104.5	1	0.1%

Phik (φk)
Auto

Heatmap
Table

	기준연도	행정구역코드	노년부양비
기준연도	1.000	0.000	0.853
행정구역코드	0.000	1.000	0.302
노년부양비	0.853	0.302	1.000

Heatmap
Table

	기준연도	행정구역코드	노년부양비
기준연도	1.000	-0.000	0.918
행정구역코드	-0.000	1.000	0.156
노년부양비	0.918	0.156	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	2010	0	14.8
1	2010	11	12.0
2	2010	21	15.0
3	2010	22	13.5
4	2010	23	11.3
5	2010	24	12.0
6	2010	25	11.4
7	2010	26	8.9
8	2010	31	11.6
9	2010	32	21.6

	기준연도	행정구역코드	노년부양비
726	2050	29	49.7
727	2050	31	67.6
728	2050	32	104.5
729	2050	33	87.2
730	2050	34	88.6
731	2050	35	102.7
732	2050	36	114.2
733	2050	37	111.0
734	2050	38	99.9
735	2050	39	74.3

Overview

Variables

Interactions

Correlations

Missing values

Sample