gimi9 Pandas Profiling

Dataset statistics

Number of variables	5
Number of observations	38
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 KiB
Average record size in memory	48.5 B

Variable types

Numeric	5

Dataset

Description	순직유족보상금 승인, 불승인 건수 및 승인율과 불승인율에 대한 데이터입니다. 1983년부터 시작되며 연 단위로 구분됩니다.
Author	공무원연금공단
URL	https://www.data.go.kr/data/15054917/fileData.do

Alerts

`연 도` is highly overall correlated with `순직유족보상금 승인건수` and 2 other fields	High correlation
`순직유족보상금 승인건수` is highly overall correlated with `연 도` and 3 other fields	High correlation
`순직유족보상금 불승인건수` is highly overall correlated with `순직유족보상금 승인건수`	High correlation
`승인율(퍼센트)` is highly overall correlated with `연 도` and 2 other fields	High correlation
`불승인율(퍼센트)` is highly overall correlated with `연 도` and 2 other fields	High correlation
`연 도` has unique values	Unique
`승인율(퍼센트)` has unique values	Unique
`불승인율(퍼센트)` has unique values	Unique

Reproduction

Analysis started	2023-12-12 06:47:12.191029
Analysis finished	2023-12-12 06:47:15.455000
Duration	3.26 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연 도
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	38
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2001.5

Minimum	1983
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	474.0 B

Quantile statistics

Minimum	1983
5-th percentile	1984.85
Q1	1992.25
median	2001.5
Q3	2010.75
95-th percentile	2018.15
Maximum	2020
Range	37
Interquartile range (IQR)	18.5

Descriptive statistics

Standard deviation	11.113055
Coefficient of variation (CV)	0.0055523634
Kurtosis	-1.2
Mean	2001.5
Median Absolute Deviation (MAD)	9.5
Skewness	0
Sum	76057
Variance	123.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
1983	1	2.6%
2012	1	2.6%
2005	1	2.6%
2006	1	2.6%
2007	1	2.6%
2008	1	2.6%
2009	1	2.6%
2010	1	2.6%
2011	1	2.6%
2013	1	2.6%
Other values (28)	28	73.7%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
2020	1	2.6%
2019	1	2.6%
2018	1	2.6%
2017	1	2.6%
2016	1	2.6%
2015	1	2.6%
2014	1	2.6%
2013	1	2.6%
2012	1	2.6%
2011	1	2.6%

순직유족보상금 승인건수
Real number (ℝ)

HIGH CORRELATION

Distinct	35
Distinct (%)	92.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	222.07895

Minimum	47
Maximum	506
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	474.0 B

Quantile statistics

Minimum	47
5-th percentile	63.8
Q1	76.25
median	249
Q3	350
95-th percentile	454.65
Maximum	506
Range	459
Interquartile range (IQR)	273.75

Descriptive statistics

Standard deviation	141.56278
Coefficient of variation (CV)	0.63744349
Kurtosis	-1.232868
Mean	222.07895
Median Absolute Deviation (MAD)	139.5
Skewness	0.2730633
Sum	8439
Variance	20040.021
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
65	2	5.3%
249	2	5.3%
66	2	5.3%
91	1	2.6%
133	1	2.6%
77	1	2.6%
85	1	2.6%
93	1	2.6%
47	1	2.6%
276	1	2.6%
Other values (25)	25	65.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
47	1	2.6%
57	1	2.6%
65	2	5.3%
66	2	5.3%
69	1	2.6%
73	1	2.6%
74	1	2.6%
76	1	2.6%
77	1	2.6%
78	1	2.6%

Value	Count	Frequency (%)
506	1	2.6%
464	1	2.6%
453	1	2.6%
440	1	2.6%
372	1	2.6%
369	1	2.6%
367	1	2.6%
359	1	2.6%
358	1	2.6%
355	1	2.6%

순직유족보상금 불승인건수
Real number (ℝ)

HIGH CORRELATION

Distinct	33
Distinct (%)	86.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	143.21053

Minimum	61
Maximum	228
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	474.0 B

Quantile statistics

Minimum	61
5-th percentile	66.7
Q1	104.25
median	153
Q3	170.75
95-th percentile	215.05
Maximum	228
Range	167
Interquartile range (IQR)	66.5

Descriptive statistics

Standard deviation	46.833897
Coefficient of variation (CV)	0.32702832
Kurtosis	-0.86645058
Mean	143.21053
Median Absolute Deviation (MAD)	30
Skewness	-0.16160897
Sum	5442
Variance	2193.4139
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
170	2	5.3%
123	2	5.3%
171	2	5.3%
155	2	5.3%
137	2	5.3%
61	1	2.6%
69	1	2.6%
73	1	2.6%
86	1	2.6%
101	1	2.6%
Other values (23)	23	60.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
61	1	2.6%
65	1	2.6%
67	1	2.6%
69	1	2.6%
73	1	2.6%
86	1	2.6%
87	1	2.6%
98	1	2.6%
100	1	2.6%
101	1	2.6%

Value	Count	Frequency (%)
228	1	2.6%
221	1	2.6%
214	1	2.6%
206	1	2.6%
201	1	2.6%
197	1	2.6%
187	1	2.6%
182	1	2.6%
171	2	5.3%
170	2	5.3%

승인율(퍼센트)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	38
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.686842

Minimum	24.9
Maximum	80.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	474.0 B

Quantile statistics

Minimum	24.9
5-th percentile	31.42
Q1	43.025
median	60.65
Q3	65.625
95-th percentile	76.125
Maximum	80.5
Range	55.6
Interquartile range (IQR)	22.6

Descriptive statistics

Standard deviation	15.204288
Coefficient of variation (CV)	0.27303196
Kurtosis	-0.99691284
Mean	55.686842
Median Absolute Deviation (MAD)	10.4
Skewness	-0.34517377
Sum	2116.1
Variance	231.17036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
80.5	1	2.6%
39.4	1	2.6%
43.8	1	2.6%
31.6	1	2.6%
33.3	1	2.6%
33.8	1	2.6%
30.4	1	2.6%
24.9	1	2.6%
42.5	1	2.6%
37.6	1	2.6%
Other values (28)	28	73.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
24.9	1	2.6%
30.4	1	2.6%
31.6	1	2.6%
33.3	1	2.6%
33.8	1	2.6%
36.1	1	2.6%
37.6	1	2.6%
39.4	1	2.6%
42.5	1	2.6%
43.0	1	2.6%

Value	Count	Frequency (%)
80.5	1	2.6%
77.4	1	2.6%
75.9	1	2.6%
75.6	1	2.6%
74.1	1	2.6%
70.8	1	2.6%
70.2	1	2.6%
69.5	1	2.6%
69.1	1	2.6%
65.9	1	2.6%

불승인율(퍼센트)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	38
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.315789

Minimum	19.5
Maximum	75.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	474.0 B

Quantile statistics

Minimum	19.5
5-th percentile	23.875
Q1	34.375
median	39.35
Q3	56.975
95-th percentile	68.58
Maximum	75.1
Range	55.6
Interquartile range (IQR)	22.6

Descriptive statistics

Standard deviation	15.206409
Coefficient of variation (CV)	0.3431375
Kurtosis	-0.99803694
Mean	44.315789
Median Absolute Deviation (MAD)	10.4
Skewness	0.34482812
Sum	1684
Variance	231.23488
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
19.5	1	2.6%
60.6	1	2.6%
56.3	1	2.6%
68.4	1	2.6%
66.7	1	2.6%
66.2	1	2.6%
69.6	1	2.6%
75.1	1	2.6%
57.5	1	2.6%
62.4	1	2.6%
Other values (28)	28	73.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.5	1	2.6%
22.6	1	2.6%
24.1	1	2.6%
24.4	1	2.6%
25.9	1	2.6%
29.2	1	2.6%
29.8	1	2.6%
30.5	1	2.6%
30.9	1	2.6%
34.1	1	2.6%

Value	Count	Frequency (%)
75.1	1	2.6%
69.6	1	2.6%
68.4	1	2.6%
66.7	1	2.6%
66.2	1	2.6%
63.9	1	2.6%
62.4	1	2.6%
60.6	1	2.6%
57.5	1	2.6%
57.0	1	2.6%

Phik (φk)
Auto

Heatmap
Table

	연 도	순직유족보상금 승인건수	순직유족보상금 불승인건수	승인율(퍼센트)	불승인율(퍼센트)
연 도	1.000	0.728	0.866	0.929	0.929
순직유족보상금 승인건수	0.728	1.000	0.364	0.205	0.205
순직유족보상금 불승인건수	0.866	0.364	1.000	0.752	0.752
승인율(퍼센트)	0.929	0.205	0.752	1.000	1.000
불승인율(퍼센트)	0.929	0.205	0.752	1.000	1.000

Heatmap
Table

	연 도	순직유족보상금 승인건수	순직유족보상금 불승인건수	승인율(퍼센트)	불승인율(퍼센트)
연 도	1.000	-0.753	-0.364	-0.745	0.745
순직유족보상금 승인건수	-0.753	1.000	0.538	0.859	-0.859
순직유족보상금 불승인건수	-0.364	0.538	1.000	0.093	-0.093
승인율(퍼센트)	-0.745	0.859	0.093	1.000	-1.000
불승인율(퍼센트)	0.745	-0.859	-0.093	-1.000	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	1983	276	67	80.5	19.5
1	1984	226	155	59.3	40.7
2	1985	249	137	64.5	35.5
3	1986	249	155	61.6	38.4
4	1987	283	124	69.5	30.5
5	1988	359	114	75.9	24.1
6	1989	335	98	77.4	22.6
7	1990	372	130	74.1	25.9
8	1991	369	165	69.1	30.9
9	1992	358	221	61.8	38.2

	연 도	순직유족보상금 승인건수	순직유족보상금 불승인건수	승인율(퍼센트)	불승인율(퍼센트)
28	2011	91	123	42.5	57.5
29	2012	65	100	39.4	60.6
30	2013	74	123	37.6	62.4
31	2014	66	87	43.1	56.9
32	2015	57	101	36.1	63.9
33	2016	65	86	43.0	57.0
34	2017	73	73	50.0	50.0
35	2018	78	69	53.1	46.9
36	2019	76	61	55.5	44.5
37	2020	69	65	51.5	48.5

Overview

Variables

Interactions

Correlations

Missing values

Sample