gimi9 Pandas Profiling

Dataset statistics

Number of variables	5
Number of observations	41
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.9 KiB
Average record size in memory	48.1 B

Variable types

Numeric	5

Dataset

Description	공무원연금 선택가능 인원, 연금(일시금, 연금)선택 추이에 대한 데이터입니다. 1982년부터 시작되며 연 단위로 구분됩니다.
Author	공무원연금공단
URL	https://www.data.go.kr/data/15054091/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	2024-03-14 16:20:54.919862
Analysis finished	2024-03-14 16:21:01.785134
Duration	6.87 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

구분
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	41
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2002

Minimum	1982
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	497.0 B

Quantile statistics

Minimum	1982
5-th percentile	1984
Q1	1992
median	2002
Q3	2012
95-th percentile	2020
Maximum	2022
Range	40
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	11.979149
Coefficient of variation (CV)	0.0059835907
Kurtosis	-1.2
Mean	2002
Median Absolute Deviation (MAD)	10
Skewness	0
Sum	82082
Variance	143.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1982	1	2.4%
2013	1	2.4%
2005	1	2.4%
2006	1	2.4%
2007	1	2.4%
2008	1	2.4%
2009	1	2.4%
2010	1	2.4%
2011	1	2.4%
2012	1	2.4%
Other values (31)	31	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1982	1	2.4%
1983	1	2.4%
1984	1	2.4%
1985	1	2.4%
1986	1	2.4%
1987	1	2.4%
1988	1	2.4%
1989	1	2.4%
1990	1	2.4%
1991	1	2.4%

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

연금선택가능퇴직인원
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	41
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19761.512

Minimum	5106
Maximum	59612
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	497.0 B

Quantile statistics

Minimum	5106
5-th percentile	5936
Q1	9576
median	16822
Q3	30604
95-th percentile	35984
Maximum	59612
Range	54506
Interquartile range (IQR)	21028

Descriptive statistics

Standard deviation	11953.144
Coefficient of variation (CV)	0.60486988
Kurtosis	1.3896511
Mean	19761.512
Median Absolute Deviation (MAD)	8569
Skewness	1.0206589
Sum	810222
Variance	1.4287764 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
5106	1	2.4%
19927	1	2.4%
23831	1	2.4%
19805	1	2.4%
20828	1	2.4%
25941	1	2.4%
15098	1	2.4%
19967	1	2.4%
16505	1	2.4%
22888	1	2.4%
Other values (31)	31	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5106	1	2.4%
5491	1	2.4%
5936	1	2.4%
6036	1	2.4%
6199	1	2.4%
7331	1	2.4%
7966	1	2.4%
8253	1	2.4%
8427	1	2.4%
8789	1	2.4%

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

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

HIGH CORRELATION UNIQUE

Distinct	41
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4023.561

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

Quantile statistics

Minimum	1260
5-th percentile	1276
Q1	1570
median	2736
Q3	4446
95-th percentile	8911
Maximum	19845
Range	18585
Interquartile range (IQR)	2876

Descriptive statistics

Standard deviation	4030.2055
Coefficient of variation (CV)	1.0016514
Kurtosis	9.2171429
Mean	4023.561
Median Absolute Deviation (MAD)	1391
Skewness	2.8742503
Sum	164966
Variance	16242556
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
3440	1	2.4%
1270	1	2.4%
1276	1	2.4%
1421	1	2.4%
1363	1	2.4%
1588	1	2.4%
1282	1	2.4%
1321	1	2.4%
1260	1	2.4%
1442	1	2.4%
Other values (31)	31	75.6%

Minimum 10 values
Maximum 10 values

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

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

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

HIGH CORRELATION UNIQUE

Distinct	41
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15737.951

Minimum	1600
Maximum	39767
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	497.0 B

Quantile statistics

Minimum	1600
5-th percentile	1809
Q1	4621
median	13929
Q3	24353
95-th percentile	33734
Maximum	39767
Range	38167
Interquartile range (IQR)	19732

Descriptive statistics

Standard deviation	11375.172
Coefficient of variation (CV)	0.72278606
Kurtosis	-1.0808709
Mean	15737.951
Median Absolute Deviation (MAD)	9586
Skewness	0.40373715
Sum	645256
Variance	1.2939453 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1666	1	2.4%
18657	1	2.4%
22555	1	2.4%
18384	1	2.4%
19465	1	2.4%
24353	1	2.4%
13816	1	2.4%
18646	1	2.4%
15245	1	2.4%
21446	1	2.4%
Other values (31)	31	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1600	1	2.4%
1666	1	2.4%
1809	1	2.4%
1832	1	2.4%
1875	1	2.4%
3021	1	2.4%
3156	1	2.4%
3871	1	2.4%
4203	1	2.4%
4343	1	2.4%

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

연금선택률
Real number (ℝ)

HIGH CORRELATION

Distinct	37
Distinct (%)	90.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.978049

Minimum	29.1
Maximum	95.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	497.0 B

Quantile statistics

Minimum	29.1
5-th percentile	30.4
Q1	48.6
median	84
Q3	93.3
95-th percentile	94.6
Maximum	95.6
Range	66.5
Interquartile range (IQR)	44.7

Descriptive statistics

Standard deviation	24.754035
Coefficient of variation (CV)	0.34875621
Kurtosis	-1.5188199
Mean	70.978049
Median Absolute Deviation (MAD)	10.6
Skewness	-0.44581949
Sum	2910.1
Variance	612.76226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
93.3	2	4.9%
92.5	2	4.9%
94.6	2	4.9%
93.7	2	4.9%
32.6	1	2.4%
91.5	1	2.4%
87.9	1	2.4%
91.0	1	2.4%
92.8	1	2.4%
93.5	1	2.4%
Other values (27)	27	65.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29.1	1	2.4%
30.2	1	2.4%
30.4	1	2.4%
30.5	1	2.4%
32.6	1	2.4%
38.2	1	2.4%
41.2	1	2.4%
46.7	1	2.4%
48.3	1	2.4%
48.4	1	2.4%

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

Phik (φk)
Auto

Heatmap
Table

	구분	연금선택가능퇴직인원	퇴직및유족급여(일시금선택)	퇴직및유족급여(연금선택)	연금선택률
구분	1.000	0.671	0.736	0.714	0.822
연금선택가능퇴직인원	0.671	1.000	0.671	0.917	0.800
퇴직및유족급여(일시금선택)	0.736	0.671	1.000	0.791	0.787
퇴직및유족급여(연금선택)	0.714	0.917	0.791	1.000	0.742
연금선택률	0.822	0.800	0.787	0.742	1.000

Heatmap
Table

	구분	연금선택가능퇴직인원	퇴직및유족급여(일시금선택)	퇴직및유족급여(연금선택)	연금선택률
구분	1.000	0.843	-0.595	0.906	0.894
연금선택가능퇴직인원	0.843	1.000	-0.233	0.967	0.754
퇴직및유족급여(일시금선택)	-0.595	-0.233	1.000	-0.392	-0.714
퇴직및유족급여(연금선택)	0.906	0.967	-0.392	1.000	0.855
연금선택률	0.894	0.754	-0.714	0.855	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	1982	5106	3440	1666	32.6
1	1983	6199	4324	1875	30.2
2	1984	5491	3891	1600	29.1
3	1985	5936	4127	1809	30.5
4	1986	6036	4204	1832	30.4
5	1987	7966	4095	3871	48.6
6	1988	8253	5097	3156	38.2
7	1989	7331	4310	3021	41.2
8	1990	8427	4224	4203	49.9
9	1991	8789	4446	4343	49.4

	구분	연금선택가능퇴직인원	퇴직및유족급여(일시금선택)	퇴직및유족급여(연금선택)	연금선택률
31	2013	19927	1270	18657	93.6
32	2014	34541	1570	32971	95.5
33	2015	32147	1401	30746	95.6
34	2016	30889	2321	28568	92.5
35	2017	30646	2065	28581	93.3
36	2018	30604	2048	28556	93.3
37	2019	31675	1718	29957	94.6
38	2020	35984	2250	33734	93.7
39	2021	31719	2200	29519	93.1
40	2022	38661	2884	35777	92.5

Overview

Variables

Interactions

Correlations

Missing values

Sample