gimi9 Pandas Profiling

Dataset statistics

Number of variables	5
Number of observations	48
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.2 KiB
Average record size in memory	47.8 B

Variable types

Numeric	5

Dataset

Description	연금 선택 가능 퇴직자수, 퇴직 및 유족급여 연금, 일시금 선택자 수, 연금선택률 등에 대한 데이터입니다. 1975년부터 2022년까지 연 단위로 구분됩니다.
URL	https://www.data.go.kr/data/15052996/fileData.do

Alerts

`연도` is highly overall correlated with `연금선택_가능_퇴직자_수` and 3 other fields	High correlation
`연금선택_가능_퇴직자_수` is highly overall correlated with `연도` and 2 other fields	High correlation
`퇴직_및_유족급여_일시금선택자수` is highly overall correlated with `연도` and 1 other fields	High correlation
`퇴직_및_유족급여_연금선택자수` is highly overall correlated with `연도` and 2 other fields	High correlation
`연금선택률(퍼센트)` is highly overall correlated with `연도` and 3 other fields	High correlation
`연도` has unique values	Unique
`연금선택_가능_퇴직자_수` has unique values	Unique
`퇴직_및_유족급여_일시금선택자수` has unique values	Unique
`퇴직_및_유족급여_연금선택자수` has unique values	Unique

Reproduction

Analysis started	2023-12-12 12:33:36.807841
Analysis finished	2023-12-12 12:33:40.758183
Duration	3.95 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연도
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	48
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1998.5

Minimum	1975
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	1975
5-th percentile	1977.35
Q1	1986.75
median	1998.5
Q3	2010.25
95-th percentile	2019.65
Maximum	2022
Range	47
Interquartile range (IQR)	23.5

Descriptive statistics

Standard deviation	14
Coefficient of variation (CV)	0.0070052539
Kurtosis	-1.2
Mean	1998.5
Median Absolute Deviation (MAD)	12
Skewness	0
Sum	95928
Variance	196
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
1975	1	2.1%
2000	1	2.1%
2002	1	2.1%
2003	1	2.1%
2004	1	2.1%
2005	1	2.1%
2006	1	2.1%
2007	1	2.1%
2008	1	2.1%
2009	1	2.1%
Other values (38)	38	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1975	1	2.1%
1976	1	2.1%
1977	1	2.1%
1978	1	2.1%
1979	1	2.1%
1980	1	2.1%
1981	1	2.1%
1982	1	2.1%
1983	1	2.1%
1984	1	2.1%

Value	Count	Frequency (%)
2022	1	2.1%
2021	1	2.1%
2020	1	2.1%
2019	1	2.1%
2018	1	2.1%
2017	1	2.1%
2016	1	2.1%
2015	1	2.1%
2014	1	2.1%
2013	1	2.1%

연금선택_가능_퇴직자_수
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	48
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17367.146

Minimum	2206
Maximum	59612
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	2206
5-th percentile	3414.05
Q1	7048
median	14752
Q3	26341.25
95-th percentile	35786.25
Maximum	59612
Range	57406
Interquartile range (IQR)	19293.25

Descriptive statistics

Standard deviation	12488.091
Coefficient of variation (CV)	0.7190641
Kurtosis	1.1324529
Mean	17367.146
Median Absolute Deviation (MAD)	8766
Skewness	1.0089876
Sum	833623
Variance	1.5595242 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
2643	1	2.1%
27542	1	2.1%
10524	1	2.1%
13716	1	2.1%
15307	1	2.1%
23831	1	2.1%
19805	1	2.1%
20828	1	2.1%
25941	1	2.1%
15098	1	2.1%
Other values (38)	38	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2206	1	2.1%
2643	1	2.1%
3371	1	2.1%
3494	1	2.1%
3618	1	2.1%
3911	1	2.1%
4158	1	2.1%
5106	1	2.1%
5491	1	2.1%
5936	1	2.1%

Value	Count	Frequency (%)
59612	1	2.1%
38661	1	2.1%
35984	1	2.1%
35419	1	2.1%
34541	1	2.1%
32147	1	2.1%
31719	1	2.1%
31675	1	2.1%
30889	1	2.1%
30646	1	2.1%

퇴직_및_유족급여_일시금선택자수
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	48
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3889.9792

Minimum	1260
Maximum	19845
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	1260
5-th percentile	1278.1
Q1	1641.25
median	3028.5
Q3	4313.5
95-th percentile	8427.65
Maximum	19845
Range	18585
Interquartile range (IQR)	2672.25

Descriptive statistics

Standard deviation	3738.6174
Coefficient of variation (CV)	0.96108932
Kurtosis	11.281155
Mean	3889.9792
Median Absolute Deviation (MAD)	1354.5
Skewness	3.1481699
Sum	186719
Variance	13977260
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
2588	1	2.1%
6015	1	2.1%
1689	1	2.1%
1659	1	2.1%
1378	1	2.1%
1276	1	2.1%
1421	1	2.1%
1363	1	2.1%
1588	1	2.1%
1282	1	2.1%
Other values (38)	38	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1260	1	2.1%
1270	1	2.1%
1276	1	2.1%
1282	1	2.1%
1321	1	2.1%
1363	1	2.1%
1378	1	2.1%
1401	1	2.1%
1421	1	2.1%
1442	1	2.1%

Value	Count	Frequency (%)
19845	1	2.1%
18893	1	2.1%
8911	1	2.1%
7530	1	2.1%
7003	1	2.1%
6015	1	2.1%
5953	1	2.1%
5561	1	2.1%
5097	1	2.1%
4955	1	2.1%

퇴직_및_유족급여_연금선택자수
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	48
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13477.167

Minimum	55
Maximum	39767
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	55
5-th percentile	190.35
Q1	2734.5
median	10031.5
Q3	21784
95-th percentile	33466.95
Maximum	39767
Range	39712
Interquartile range (IQR)	19049.5

Descriptive statistics

Standard deviation	11861.73
Coefficient of variation (CV)	0.88013531
Kurtosis	-0.97464305
Mean	13477.167
Median Absolute Deviation (MAD)	8523
Skewness	0.5577585
Sum	646904
Variance	1.4070065 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
55	1	2.1%
21527	1	2.1%
8835	1	2.1%
12057	1	2.1%
13929	1	2.1%
22555	1	2.1%
18384	1	2.1%
19465	1	2.1%
24353	1	2.1%
13816	1	2.1%
Other values (38)	38	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
55	1	2.1%
147	1	2.1%
190	1	2.1%
191	1	2.1%
198	1	2.1%
257	1	2.1%
610	1	2.1%
1600	1	2.1%
1666	1	2.1%
1809	1	2.1%

Value	Count	Frequency (%)
39767	1	2.1%
35777	1	2.1%
33734	1	2.1%
32971	1	2.1%
30746	1	2.1%
29957	1	2.1%
29519	1	2.1%
28581	1	2.1%
28568	1	2.1%
28556	1	2.1%

연금선택률(퍼센트)
Real number (ℝ)

HIGH CORRELATION

Distinct	44
Distinct (%)	91.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.625

Minimum	2.1
Maximum	95.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	2.1
5-th percentile	5.51
Q1	36.8
median	60.95
Q3	93.15
95-th percentile	94.6
Maximum	95.6
Range	93.5
Interquartile range (IQR)	56.35

Descriptive statistics

Standard deviation	32.356146
Coefficient of variation (CV)	0.52504903
Kurtosis	-1.2038029
Mean	61.625
Median Absolute Deviation (MAD)	31.5
Skewness	-0.46076656
Sum	2958
Variance	1046.9202
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
93.3	2	4.2%
92.5	2	4.2%
93.7	2	4.2%
94.6	2	4.2%
2.1	1	2.1%
93.5	1	2.1%
78.2	1	2.1%
79.7	1	2.1%
84.0	1	2.1%
87.9	1	2.1%
Other values (34)	34	70.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.1	1	2.1%
3.8	1	2.1%
5.3	1	2.1%
5.9	1	2.1%
7.4	1	2.1%
8.7	1	2.1%
14.7	1	2.1%
29.1	1	2.1%
30.2	1	2.1%
30.4	1	2.1%

Value	Count	Frequency (%)
95.6	1	2.1%
95.5	1	2.1%
94.6	2	4.2%
93.9	1	2.1%
93.7	2	4.2%
93.6	1	2.1%
93.5	1	2.1%
93.4	1	2.1%
93.3	2	4.2%
93.1	1	2.1%

Phik (φk)
Auto

Heatmap
Table

	연도	연금선택_가능_퇴직자_수	퇴직_및_유족급여_일시금선택자수	퇴직_및_유족급여_연금선택자수	연금선택률(퍼센트)
연도	1.000	0.745	0.680	0.888	0.822
연금선택_가능_퇴직자_수	0.745	1.000	0.733	0.903	0.730
퇴직_및_유족급여_일시금선택자수	0.680	0.733	1.000	0.713	0.786
퇴직_및_유족급여_연금선택자수	0.888	0.903	0.713	1.000	0.781
연금선택률(퍼센트)	0.822	0.730	0.786	0.781	1.000

Heatmap
Table

	연도	연금선택_가능_퇴직자_수	퇴직_및_유족급여_일시금선택자수	퇴직_및_유족급여_연금선택자수	연금선택률(퍼센트)
연도	1.000	0.900	-0.521	0.941	0.933
연금선택_가능_퇴직자_수	0.900	1.000	-0.238	0.977	0.844
퇴직_및_유족급여_일시금선택자수	-0.521	-0.238	1.000	-0.366	-0.604
퇴직_및_유족급여_연금선택자수	0.941	0.977	-0.366	1.000	0.909
연금선택률(퍼센트)	0.933	0.844	-0.604	0.909	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	1975	2643	2588	55	2.1
1	1976	3911	3764	147	3.8
2	1977	3618	3428	190	5.3
3	1978	3371	3173	198	5.9
4	1979	2206	2015	191	8.7
5	1980	4158	3548	610	14.7
6	1981	3494	3237	257	7.4
7	1982	5106	3440	1666	32.6
8	1983	6199	4324	1875	30.2
9	1984	5491	3891	1600	29.1

	연도	연금선택_가능_퇴직자_수	퇴직_및_유족급여_일시금선택자수	퇴직_및_유족급여_연금선택자수	연금선택률(퍼센트)
38	2013	19927	1270	18657	93.6
39	2014	34541	1570	32971	95.5
40	2015	32147	1401	30746	95.6
41	2016	30889	2321	28568	92.5
42	2017	30646	2065	28581	93.3
43	2018	30604	2048	28556	93.3
44	2019	31675	1718	29957	94.6
45	2020	35984	2250	33734	93.7
46	2021	31719	2200	29519	93.1
47	2022	38661	2884	35777	92.5

Overview

Variables

Interactions

Correlations

Missing values

Sample