gimi9 Pandas Profiling

Dataset statistics

Number of variables	7
Number of observations	41
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.7 KiB
Average record size in memory	66.2 B

Variable types

Numeric	7

Dataset

Description	사립학교교직원연금공단 해당연도의 합산내역별 승인 건수와 관련된 데이터로 연도, 유형별(사립학교, 재임용, 공무원, 군인), 교직원별(교원, 사무직원) 등의 항목을 제공합니다.
URL	https://www.data.go.kr/data/15049779/fileData.do

Alerts

`연도` is highly overall correlated with `사립학교교원` and 4 other fields	High correlation
`사립학교교원` is highly overall correlated with `연도` and 4 other fields	High correlation
`사립학교사무직원` is highly overall correlated with `연도` and 4 other fields	High correlation
`재임용교원` is highly overall correlated with `연도` and 4 other fields	High correlation
`재임용사무직원` is highly overall correlated with `연도` and 4 other fields	High correlation
`공무원군인사무직원` is highly overall correlated with `연도` and 4 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 14:57:35.834013
Analysis finished	2023-12-12 14:57:41.199968
Duration	5.37 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	501.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	674.63415

Minimum	225
Maximum	1689
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	501.0 B

Quantile statistics

Minimum	225
5-th percentile	238
Q1	453
median	601
Q3	908
95-th percentile	993
Maximum	1689
Range	1464
Interquartile range (IQR)	455

Descriptive statistics

Standard deviation	314.14509
Coefficient of variation (CV)	0.46565252
Kurtosis	1.6022662
Mean	674.63415
Median Absolute Deviation (MAD)	182
Skewness	1.0188508
Sum	27660
Variance	98687.138
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
238	1	2.4%
913	1	2.4%
601	1	2.4%
955	1	2.4%
749	1	2.4%
992	1	2.4%
915	1	2.4%
1689	1	2.4%
852	1	2.4%
783	1	2.4%
Other values (31)	31	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
225	1	2.4%
237	1	2.4%
238	1	2.4%
272	1	2.4%
345	1	2.4%
413	1	2.4%
420	1	2.4%
431	1	2.4%
448	1	2.4%
452	1	2.4%

Value	Count	Frequency (%)
1689	1	2.4%
1425	1	2.4%
993	1	2.4%
992	1	2.4%
987	1	2.4%
981	1	2.4%
955	1	2.4%
919	1	2.4%
915	1	2.4%
913	1	2.4%

사립학교사무직원
Real number (ℝ)

HIGH CORRELATION

Distinct	38
Distinct (%)	92.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	344.34146

Minimum	43
Maximum	1150
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	501.0 B

Quantile statistics

Minimum	43
5-th percentile	97
Q1	158
median	245
Q3	477
95-th percentile	709
Maximum	1150
Range	1107
Interquartile range (IQR)	319

Descriptive statistics

Standard deviation	239.13434
Coefficient of variation (CV)	0.6944686
Kurtosis	1.6176891
Mean	344.34146
Median Absolute Deviation (MAD)	135
Skewness	1.2010296
Sum	14118
Variance	57185.23
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
191	2	4.9%
110	2	4.9%
158	2	4.9%
445	1	2.4%
502	1	2.4%
467	1	2.4%
706	1	2.4%
477	1	2.4%
420	1	2.4%
476	1	2.4%
Other values (28)	28	68.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
43	1	2.4%
92	1	2.4%
97	1	2.4%
110	2	4.9%
133	1	2.4%
142	1	2.4%
143	1	2.4%
144	1	2.4%
158	2	4.9%
160	1	2.4%

Value	Count	Frequency (%)
1150	1	2.4%
719	1	2.4%
709	1	2.4%
706	1	2.4%
699	1	2.4%
669	1	2.4%
596	1	2.4%
536	1	2.4%
502	1	2.4%
483	1	2.4%

재임용교원
Real number (ℝ)

HIGH CORRELATION UNIQUE

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

Minimum	84
Maximum	2799
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	501.0 B

Quantile statistics

Minimum	84
5-th percentile	93
Q1	238
median	557
Q3	1944
95-th percentile	2702
Maximum	2799
Range	2715
Interquartile range (IQR)	1706

Descriptive statistics

Standard deviation	961.09971
Coefficient of variation (CV)	0.95960179
Kurtosis	-1.0043116
Mean	1001.561
Median Absolute Deviation (MAD)	444
Skewness	0.79164913
Sum	41064
Variance	923712.65
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
808	1	2.4%
2150	1	2.4%
557	1	2.4%
755	1	2.4%
1064	1	2.4%
1118	1	2.4%
1038	1	2.4%
1303	1	2.4%
1494	1	2.4%
1944	1	2.4%
Other values (31)	31	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
84	1	2.4%
92	1	2.4%
93	1	2.4%
99	1	2.4%
113	1	2.4%
140	1	2.4%
141	1	2.4%
162	1	2.4%
175	1	2.4%
234	1	2.4%

Value	Count	Frequency (%)
2799	1	2.4%
2728	1	2.4%
2702	1	2.4%
2612	1	2.4%
2604	1	2.4%
2461	1	2.4%
2418	1	2.4%
2311	1	2.4%
2245	1	2.4%
2150	1	2.4%

재임용사무직원
Real number (ℝ)

HIGH CORRELATION

Distinct	35
Distinct (%)	85.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	224.73171

Minimum	11
Maximum	1594
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	501.0 B

Quantile statistics

Minimum	11
5-th percentile	24
Q1	49
median	82
Q3	166
95-th percentile	1028
Maximum	1594
Range	1583
Interquartile range (IQR)	117

Descriptive statistics

Standard deviation	358.86516
Coefficient of variation (CV)	1.5968604
Kurtosis	5.780808
Mean	224.73171
Median Absolute Deviation (MAD)	38
Skewness	2.4904951
Sum	9214
Variance	128784.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
54	2	4.9%
82	2	4.9%
44	2	4.9%
166	2	4.9%
83	2	4.9%
75	2	4.9%
38	1	2.4%
393	1	2.4%
126	1	2.4%
219	1	2.4%
Other values (25)	25	61.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	1	2.4%
13	1	2.4%
24	1	2.4%
29	1	2.4%
32	1	2.4%
38	1	2.4%
42	1	2.4%
44	2	4.9%
46	1	2.4%
49	1	2.4%

Value	Count	Frequency (%)
1594	1	2.4%
1174	1	2.4%
1028	1	2.4%
963	1	2.4%
754	1	2.4%
499	1	2.4%
393	1	2.4%
240	1	2.4%
226	1	2.4%
219	1	2.4%

공무원군인교원
Real number (ℝ)

UNIQUE

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

Minimum	169
Maximum	5206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	501.0 B

Quantile statistics

Minimum	169
5-th percentile	368
Q1	485
median	862
Q3	1115
95-th percentile	1918
Maximum	5206
Range	5037
Interquartile range (IQR)	630

Descriptive statistics

Standard deviation	837.71787
Coefficient of variation (CV)	0.8513604
Kurtosis	15.909116
Mean	983.97561
Median Absolute Deviation (MAD)	355
Skewness	3.4420709
Sum	40343
Variance	701771.22
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
169	1	2.4%
1099	1	2.4%
485	1	2.4%
589	1	2.4%
548	1	2.4%
552	1	2.4%
432	1	2.4%
1897	1	2.4%
854	1	2.4%
2282	1	2.4%
Other values (31)	31	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
169	1	2.4%
301	1	2.4%
368	1	2.4%
382	1	2.4%
388	1	2.4%
410	1	2.4%
412	1	2.4%
427	1	2.4%
432	1	2.4%
480	1	2.4%

Value	Count	Frequency (%)
5206	1	2.4%
2282	1	2.4%
1918	1	2.4%
1897	1	2.4%
1831	1	2.4%
1676	1	2.4%
1317	1	2.4%
1246	1	2.4%
1217	1	2.4%
1125	1	2.4%

공무원군인사무직원
Real number (ℝ)

HIGH CORRELATION

Distinct	38
Distinct (%)	92.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	340.17073

Minimum	36
Maximum	1701
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	501.0 B

Quantile statistics

Minimum	36
5-th percentile	144
Q1	210
median	260
Q3	388
95-th percentile	720
Maximum	1701
Range	1665
Interquartile range (IQR)	178

Descriptive statistics

Standard deviation	271.77315
Coefficient of variation (CV)	0.79893161
Kurtosis	15.834593
Mean	340.17073
Median Absolute Deviation (MAD)	60
Skewness	3.5359273
Sum	13947
Variance	73860.645
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
210	2	4.9%
215	2	4.9%
237	2	4.9%
338	1	2.4%
260	1	2.4%
247	1	2.4%
457	1	2.4%
305	1	2.4%
917	1	2.4%
409	1	2.4%
Other values (28)	28	68.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36	1	2.4%
115	1	2.4%
144	1	2.4%
182	1	2.4%
183	1	2.4%
185	1	2.4%
200	1	2.4%
202	1	2.4%
203	1	2.4%
206	1	2.4%

Value	Count	Frequency (%)
1701	1	2.4%
917	1	2.4%
720	1	2.4%
529	1	2.4%
502	1	2.4%
495	1	2.4%
478	1	2.4%
457	1	2.4%
446	1	2.4%
409	1	2.4%

Phik (φk)
Auto

Heatmap
Table

	연도	사립학교교원	사립학교사무직원	재임용교원	재임용사무직원	공무원군인교원	공무원군인사무직원
연도	1.000	0.738	0.739	0.940	0.576	0.694	0.674
사립학교교원	0.738	1.000	0.855	0.764	0.650	0.480	0.624
사립학교사무직원	0.739	0.855	1.000	0.639	0.932	0.089	0.627
재임용교원	0.940	0.764	0.639	1.000	0.697	0.769	0.779
재임용사무직원	0.576	0.650	0.932	0.697	1.000	0.000	0.685
공무원군인교원	0.694	0.480	0.089	0.769	0.000	1.000	0.921
공무원군인사무직원	0.674	0.624	0.627	0.779	0.685	0.921	1.000

Heatmap
Table

	연도	사립학교교원	사립학교사무직원	재임용교원	재임용사무직원	공무원군인교원	공무원군인사무직원
연도	1.000	0.703	0.921	0.751	0.824	-0.418	0.514
사립학교교원	0.703	1.000	0.814	0.728	0.781	0.095	0.759
사립학교사무직원	0.921	0.814	1.000	0.698	0.804	-0.261	0.580
재임용교원	0.751	0.728	0.698	1.000	0.848	-0.231	0.660
재임용사무직원	0.824	0.781	0.804	0.848	1.000	-0.178	0.652
공무원군인교원	-0.418	0.095	-0.261	-0.231	-0.178	1.000	0.375
공무원군인사무직원	0.514	0.759	0.580	0.660	0.652	0.375	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	238	43	808	38	169	36
1	1983	683	110	475	56	5206	720
2	1984	465	92	762	54	1831	291
3	1985	624	143	412	82	1918	308
4	1986	448	133	234	11	1676	277
5	1987	431	110	238	44	1115	200
6	1988	569	188	175	13	1217	322
7	1989	489	142	258	83	1317	214
8	1990	420	160	241	42	1061	215
9	1991	513	158	351	83	933	237

	연도	사립학교교원	사립학교사무직원	재임용교원	재임용사무직원	공무원군인교원	공무원군인사무직원
31	2013	913	476	2150	219	1099	409
32	2014	900	483	2245	240	865	307
33	2015	981	445	2612	226	862	338
34	2016	908	709	2728	393	608	1701
35	2017	919	596	2799	499	725	478
36	2018	904	536	2702	754	607	388
37	2019	993	669	2604	1174	558	446
38	2020	1425	699	2461	963	494	502
39	2021	987	719	2311	1028	480	529
40	2022	781	1150	2418	1594	388	495

Overview

Variables

Interactions

Correlations

Missing values

Sample