gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	38
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.1 KiB
Average record size in memory	84.4 B

Variable types

Numeric	9

Dataset

Description	직종별(정무직, 별정직, 국가직, 경찰, 소방 등) 공무상요양 승인건수에 대한 데이터입니다. 1983년부터 시작되며 연 단위로 구분됩니다.
Author	공공데이터포털
URL	https://www.data.go.kr/data/15054918/fileData.do

Alerts

`연도` is highly overall correlated with `별정직` and 6 other fields	High correlation
`별정직` is highly overall correlated with `연도` and 6 other fields	High correlation
`일반직` is highly overall correlated with `연도` and 6 other fields	High correlation
`경찰소방` is highly overall correlated with `연도` and 6 other fields	High correlation
`교육` is highly overall correlated with `연도` and 6 other fields	High correlation
`법관검사` is highly overall correlated with `연도` and 5 other fields	High correlation
`기능직` is highly overall correlated with `별정직`	High correlation
`고용직` is highly overall correlated with `연도` and 6 other fields	High correlation
`기타` is highly overall correlated with `연도` and 6 other fields	High correlation
`연도` has unique values	Unique
`법관검사` has 13 (34.2%) zeros	Zeros
`기능직` has 2 (5.3%) zeros	Zeros
`고용직` has 15 (39.5%) zeros	Zeros

Reproduction

Analysis started	2024-04-21 01:00:44.319874
Analysis finished	2024-04-21 01:00:56.771776
Duration	12.45 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	470.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	27
Distinct (%)	71.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.315789

Minimum	2
Maximum	102
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	2
5-th percentile	2.85
Q1	11.25
median	19
Q3	45.5
95-th percentile	86.5
Maximum	102
Range	100
Interquartile range (IQR)	34.25

Descriptive statistics

Standard deviation	28.398806
Coefficient of variation (CV)	0.93676617
Kurtosis	0.18064943
Mean	30.315789
Median Absolute Deviation (MAD)	11
Skewness	1.1633285
Sum	1152
Variance	806.49218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
13	3	7.9%
20	2	5.3%
8	2	5.3%
3	2	5.3%
35	2	5.3%
19	2	5.3%
2	2	5.3%
11	2	5.3%
5	2	5.3%
12	2	5.3%
Other values (17)	17	44.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	5.3%
3	2	5.3%
5	2	5.3%
8	2	5.3%
11	2	5.3%
12	2	5.3%
13	3	7.9%
16	1	2.6%
17	1	2.6%
18	1	2.6%

Value	Count	Frequency (%)
102	1	2.6%
95	1	2.6%
85	1	2.6%
77	1	2.6%
73	1	2.6%
66	1	2.6%
64	1	2.6%
62	1	2.6%
60	1	2.6%
49	1	2.6%

일반직
Real number (ℝ)

HIGH CORRELATION

Distinct	37
Distinct (%)	97.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	589.89474

Minimum	239
Maximum	1068
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	239
5-th percentile	361.8
Q1	468.25
median	536.5
Q3	621.25
95-th percentile	1037.05
Maximum	1068
Range	829
Interquartile range (IQR)	153

Descriptive statistics

Standard deviation	214.73237
Coefficient of variation (CV)	0.36401811
Kurtosis	0.28382948
Mean	589.89474
Median Absolute Deviation (MAD)	81.5
Skewness	0.99663232
Sum	22416
Variance	46109.989
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
509	2	5.3%
239	1	2.6%
623	1	2.6%
616	1	2.6%
575	1	2.6%
610	1	2.6%
580	1	2.6%
529	1	2.6%
687	1	2.6%
724	1	2.6%
Other values (27)	27	71.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
239	1	2.6%
270	1	2.6%
378	1	2.6%
389	1	2.6%
396	1	2.6%
398	1	2.6%
417	1	2.6%
444	1	2.6%
453	1	2.6%
467	1	2.6%

Value	Count	Frequency (%)
1068	1	2.6%
1060	1	2.6%
1033	1	2.6%
994	1	2.6%
948	1	2.6%
942	1	2.6%
837	1	2.6%
724	1	2.6%
687	1	2.6%
623	1	2.6%

경찰소방
Real number (ℝ)

HIGH CORRELATION

Distinct	36
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1568.1842

Minimum	198
Maximum	3095
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	198
5-th percentile	307.1
Q1	851.25
median	1417.5
Q3	2446
95-th percentile	2866.65
Maximum	3095
Range	2897
Interquartile range (IQR)	1594.75

Descriptive statistics

Standard deviation	886.89257
Coefficient of variation (CV)	0.56555382
Kurtosis	-1.3995971
Mean	1568.1842
Median Absolute Deviation (MAD)	897
Skewness	0.044550464
Sum	59591
Variance	786578.42
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
474	2	5.3%
2479	2	5.3%
198	1	2.6%
2524	1	2.6%
1948	1	2.6%
2128	1	2.6%
2148	1	2.6%
2302	1	2.6%
2327	1	2.6%
2510	1	2.6%
Other values (26)	26	68.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
198	1	2.6%
285	1	2.6%
311	1	2.6%
328	1	2.6%
436	1	2.6%
474	2	5.3%
780	1	2.6%
839	1	2.6%
849	1	2.6%
858	1	2.6%

Value	Count	Frequency (%)
3095	1	2.6%
2927	1	2.6%
2856	1	2.6%
2643	1	2.6%
2583	1	2.6%
2524	1	2.6%
2510	1	2.6%
2487	1	2.6%
2479	2	5.3%
2347	1	2.6%

교육
Real number (ℝ)

HIGH CORRELATION

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

Minimum	68
Maximum	982
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	68
5-th percentile	128.85
Q1	259
median	437.5
Q3	574
95-th percentile	960
Maximum	982
Range	914
Interquartile range (IQR)	315

Descriptive statistics

Standard deviation	260.49317
Coefficient of variation (CV)	0.56322847
Kurtosis	-0.59507639
Mean	462.5
Median Absolute Deviation (MAD)	166
Skewness	0.50568684
Sum	17575
Variance	67856.689
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
960	2	5.3%
140	2	5.3%
224	2	5.3%
68	1	2.6%
669	1	2.6%
436	1	2.6%
515	1	2.6%
576	1	2.6%
485	1	2.6%
568	1	2.6%
Other values (25)	25	65.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
68	1	2.6%
94	1	2.6%
135	1	2.6%
140	2	5.3%
159	1	2.6%
174	1	2.6%
224	2	5.3%
244	1	2.6%
304	1	2.6%
319	1	2.6%

Value	Count	Frequency (%)
982	1	2.6%
960	2	5.3%
870	1	2.6%
858	1	2.6%
828	1	2.6%
812	1	2.6%
672	1	2.6%
669	1	2.6%
576	1	2.6%
568	1	2.6%

법관검사
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	18.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5526316

Minimum	0
Maximum	6
Zeros	13
Zeros (%)	34.2%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4.15
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6056887
Coefficient of variation (CV)	1.0341724
Kurtosis	0.38158291
Mean	1.5526316
Median Absolute Deviation (MAD)	1
Skewness	0.99531182
Sum	59
Variance	2.5782361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	13	34.2%
2	9	23.7%
1	8	21.1%
4	4	10.5%
3	2	5.3%
5	1	2.6%
6	1	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	34.2%
1	8	21.1%
2	9	23.7%
3	2	5.3%
4	4	10.5%
5	1	2.6%
6	1	2.6%

Value	Count	Frequency (%)
6	1	2.6%
5	1	2.6%
4	4	10.5%
3	2	5.3%
2	9	23.7%
1	8	21.1%
0	13	34.2%

기능직
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	34
Distinct (%)	89.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	619.55263

Minimum	0
Maximum	1081
Zeros	2
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	0
5-th percentile	2.55
Q1	253
median	840
Q3	935
95-th percentile	1042.15
Maximum	1081
Range	1081
Interquartile range (IQR)	682

Descriptive statistics

Standard deviation	393.65348
Coefficient of variation (CV)	0.63538344
Kurtosis	-1.4926114
Mean	619.55263
Median Absolute Deviation (MAD)	187.5
Skewness	-0.50040797
Sum	23543
Variance	154963.06
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	2	5.3%
280	2	5.3%
884	2	5.3%
935	2	5.3%
232	1	2.6%
855	1	2.6%
995	1	2.6%
900	1	2.6%
934	1	2.6%
942	1	2.6%
Other values (24)	24	63.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	5.3%
3	1	2.6%
14	1	2.6%
21	1	2.6%
25	1	2.6%
56	1	2.6%
231	1	2.6%
232	1	2.6%
252	1	2.6%
256	1	2.6%

Value	Count	Frequency (%)
1081	1	2.6%
1043	1	2.6%
1042	1	2.6%
1013	1	2.6%
1003	1	2.6%
995	1	2.6%
992	1	2.6%
983	1	2.6%
942	1	2.6%
935	2	5.3%

고용직
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	21
Distinct (%)	55.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.131579

Minimum	0
Maximum	313
Zeros	15
Zeros (%)	39.5%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	17.5
Q3	77.25
95-th percentile	288.75
Maximum	313
Range	313
Interquartile range (IQR)	77.25

Descriptive statistics

Standard deviation	105.27266
Coefficient of variation (CV)	1.5010736
Kurtosis	0.29436063
Mean	70.131579
Median Absolute Deviation (MAD)	17.5
Skewness	1.3760597
Sum	2665
Variance	11082.334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	15	39.5%
30	2	5.3%
245	2	5.3%
25	2	5.3%
23	1	2.6%
1	1	2.6%
14	1	2.6%
15	1	2.6%
32	1	2.6%
16	1	2.6%
Other values (11)	11	28.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15	39.5%
1	1	2.6%
14	1	2.6%
15	1	2.6%
16	1	2.6%
19	1	2.6%
23	1	2.6%
25	2	5.3%
30	2	5.3%
32	1	2.6%

Value	Count	Frequency (%)
313	1	2.6%
310	1	2.6%
285	1	2.6%
270	1	2.6%
245	2	5.3%
235	1	2.6%
175	1	2.6%
151	1	2.6%
80	1	2.6%
69	1	2.6%

기타
Real number (ℝ)

HIGH CORRELATION

Distinct	36
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	284.10526

Minimum	4
Maximum	1173
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	470.0 B

Quantile statistics

Minimum	4
5-th percentile	5.85
Q1	84.75
median	172
Q3	274.75
95-th percentile	1087
Maximum	1173
Range	1169
Interquartile range (IQR)	190

Descriptive statistics

Standard deviation	321.04212
Coefficient of variation (CV)	1.1300112
Kurtosis	1.8066588
Mean	284.10526
Median Absolute Deviation (MAD)	97
Skewness	1.6452148
Sum	10796
Variance	103068.04
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
71	2	5.3%
265	2	5.3%
6	1	2.6%
449	1	2.6%
244	1	2.6%
186	1	2.6%
217	1	2.6%
221	1	2.6%
278	1	2.6%
208	1	2.6%
Other values (26)	26	68.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	1	2.6%
5	1	2.6%
6	1	2.6%
8	1	2.6%
21	1	2.6%
29	1	2.6%
35	1	2.6%
71	2	5.3%
81	1	2.6%
96	1	2.6%

Value	Count	Frequency (%)
1173	1	2.6%
1104	1	2.6%
1084	1	2.6%
788	1	2.6%
752	1	2.6%
678	1	2.6%
662	1	2.6%
449	1	2.6%
328	1	2.6%
278	1	2.6%

Phik (φk)
Auto

Heatmap
Table

	연도	별정직	일반직	경찰소방	교육	법관검사	기능직	고용직	기타
연도	1.000	0.815	0.755	0.828	0.860	0.457	0.782	0.707	0.833
별정직	0.815	1.000	0.000	0.680	0.589	0.000	0.543	0.634	0.000
일반직	0.755	0.000	1.000	0.746	0.896	0.499	0.582	0.532	0.694
경찰소방	0.828	0.680	0.746	1.000	0.934	0.608	0.751	0.616	0.835
교육	0.860	0.589	0.896	0.934	1.000	0.604	0.763	0.621	0.740
법관검사	0.457	0.000	0.499	0.608	0.604	1.000	0.479	0.000	0.898
기능직	0.782	0.543	0.582	0.751	0.763	0.479	1.000	0.585	0.797
고용직	0.707	0.634	0.532	0.616	0.621	0.000	0.585	1.000	0.000
기타	0.833	0.000	0.694	0.835	0.740	0.898	0.797	0.000	1.000

Heatmap
Table

	연도	별정직	일반직	경찰소방	교육	법관검사	기능직	고용직	기타
연도	1.000	-0.649	0.910	0.986	0.979	0.596	-0.172	-0.933	0.963
별정직	-0.649	1.000	-0.722	-0.634	-0.642	-0.382	0.586	0.612	-0.626
일반직	0.910	-0.722	1.000	0.913	0.885	0.531	-0.298	-0.791	0.857
경찰소방	0.986	-0.634	0.913	1.000	0.973	0.595	-0.140	-0.923	0.942
교육	0.979	-0.642	0.885	0.973	1.000	0.601	-0.131	-0.907	0.953
법관검사	0.596	-0.382	0.531	0.595	0.601	1.000	0.137	-0.611	0.563
기능직	-0.172	0.586	-0.298	-0.140	-0.131	0.137	1.000	0.057	-0.131
고용직	-0.933	0.612	-0.791	-0.923	-0.907	-0.611	0.057	1.000	-0.899
기타	0.963	-0.626	0.857	0.942	0.953	0.563	-0.131	-0.899	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	13	239	198	68	0	232	151	6
1	1984	17	270	285	94	0	256	175	8
2	1985	20	378	328	135	0	231	235	21
3	1986	23	398	311	159	0	252	270	29
4	1987	28	472	436	174	1	298	313	35
5	1988	35	509	474	140	0	280	245	71
6	1989	20	544	930	244	1	568	310	4
7	1990	19	507	858	224	0	523	285	5
8	1991	60	396	839	224	0	842	80	97
9	1992	62	417	780	304	0	827	57	81

	연도	별정직	일반직	경찰소방	교육	법관검사	기능직	기타
28	2011	13	687	2510	550	2	838	265
29	2012	18	724	2524	669	5	884	265
30	2013	11	623	2487	858	6	863	449
31	2014	2	837	2479	672	4	56	662
32	2015	2	994	2347	828	4	21	678
33	2016	3	1060	2583	812	2	14	752
34	2017	8	942	2643	960	0	25	788
35	2018	3	948	2856	960	1	3	1084
36	2019	8	1033	2927	982	1	0	1104
37	2020	5	1068	3095	870	2	0	1173

Overview

Variables

Interactions

Correlations

Missing values

Sample