gimi9 Pandas Profiling

Dataset statistics

Number of variables	11
Number of observations	48
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.7 KiB
Average record size in memory	100.7 B

Variable types

Categorical	1
Numeric	10

Dataset

Description	공무원의 나이(18세이상~65세이상)별로 근무연수(5년미만~40년이상 등)별 공무원연금 가입자한 수 데이터
Author	공무원연금공단
URL	https://www.data.go.kr/data/15053033/fileData.do

Alerts

`구분` has unique values	Unique
`계` has unique values	Unique
`5년미만` has unique values	Unique
`5년이상10년미만` has 4 (8.3%) zeros	Zeros
`10년이상15년미만` has 10 (20.8%) zeros	Zeros
`15년이상20년미만` has 15 (31.2%) zeros	Zeros
`20년이상25년미만` has 19 (39.6%) zeros	Zeros
`25년이상30년미만` has 24 (50.0%) zeros	Zeros
`30년이상33년이하` has 27 (56.2%) zeros	Zeros
`33년초과40년미만` has 29 (60.4%) zeros	Zeros
`40년이상` has 36 (75.0%) zeros	Zeros

Reproduction

Analysis started	2022-11-19 09:50:05.176205
Analysis finished	2022-11-19 09:50:19.224011
Duration	14.05 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

구분
Categorical

UNIQUE

Distinct	48
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	512.0 B

18세이상	1
19세	1
29세	1
20세	1
21세	1
Other values (43)	43

Length

Max length	5
Median length	3
Mean length	3.083333333
Min length	3

Unique

Unique	48 ?
Unique (%)	100.0%

Sample

1st row	18세이상
2nd row	19세
3rd row	20세
4th row	21세
5th row	22세

Common Values

Value	Count	Frequency (%)
18세이상	1	2.1%
19세	1	2.1%
29세	1	2.1%
20세	1	2.1%
21세	1	2.1%
22세	1	2.1%
23세	1	2.1%
24세	1	2.1%
25세	1	2.1%
26세	1	2.1%
Other values (38)	38	79.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
18세이상	1	2.1%
19세	1	2.1%
53세	1	2.1%
44세	1	2.1%
45세	1	2.1%
46세	1	2.1%
47세	1	2.1%
48세	1	2.1%
49세	1	2.1%
50세	1	2.1%
Other values (38)	38	79.2%

계
Real number (ℝ_≥0)

UNIQUE

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

Minimum	33
Maximum	43870
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	33
5-th percentile	792.1
Q1	12069.75
median	33734
Q3	37812.25
95-th percentile	42701.4
Maximum	43870
Range	43837
Interquartile range (IQR)	25742.5

Descriptive statistics

Standard deviation	15192.88691
Coefficient of variation (CV)	0.5781246482
Kurtosis	-1.020241763
Mean	26279.60417
Median Absolute Deviation (MAD)	5142.5
Skewness	-0.7898024613
Sum	1261421
Variance	230823812.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
33	1	2.1%
43581	1	2.1%
692	1	2.1%
978	1	2.1%
1544	1	2.1%
5037	1	2.1%
10443	1	2.1%
16708	1	2.1%
23694	1	2.1%
30038	1	2.1%
Other values (38)	38	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
33	1	2.1%
471	1	2.1%
692	1	2.1%
978	1	2.1%
1000	1	2.1%
1026	1	2.1%
1104	1	2.1%
1544	1	2.1%
2248	1	2.1%
5037	1	2.1%

Value	Count	Frequency (%)
43870	1	2.1%
43581	1	2.1%
42798	1	2.1%
42522	1	2.1%
39959	1	2.1%
39318	1	2.1%
38435	1	2.1%
38324	1	2.1%
38138	1	2.1%
38131	1	2.1%

5년미만
Real number (ℝ_≥0)

UNIQUE

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

Minimum	33
Maximum	27626
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	33
5-th percentile	200.65
Q1	586.25
median	2006.5
Q3	6710
95-th percentile	24986.9
Maximum	27626
Range	27593
Interquartile range (IQR)	6123.75

Descriptive statistics

Standard deviation	7994.157828
Coefficient of variation (CV)	1.377550963
Kurtosis	1.75196474
Mean	5803.166667
Median Absolute Deviation (MAD)	1721.5
Skewness	1.691797023
Sum	278552
Variance	63906559.38
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
33	1	2.1%
3709	1	2.1%
692	1	2.1%
978	1	2.1%
1538	1	2.1%
4929	1	2.1%
10004	1	2.1%
16230	1	2.1%
22877	1	2.1%
27626	1	2.1%
Other values (38)	38	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
33	1	2.1%
171	1	2.1%
194	1	2.1%
213	1	2.1%
227	1	2.1%
266	1	2.1%
313	1	2.1%
381	1	2.1%
466	1	2.1%
471	1	2.1%

Value	Count	Frequency (%)
27626	1	2.1%
27422	1	2.1%
26123	1	2.1%
22877	1	2.1%
22721	1	2.1%
17405	1	2.1%
16230	1	2.1%
14287	1	2.1%
11697	1	2.1%
10004	1	2.1%

5년이상10년미만
Real number (ℝ_≥0)

ZEROS

Distinct	45
Distinct (%)	93.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4384.916667

Minimum	0
Maximum	20211
Zeros	4
Zeros (%)	8.3%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	145.25
median	1031
Q3	6836.25
95-th percentile	18465.8
Maximum	20211
Range	20211
Interquartile range (IQR)	6691

Descriptive statistics

Standard deviation	6273.217427
Coefficient of variation (CV)	1.430635495
Kurtosis	0.7621261695
Mean	4384.916667
Median Absolute Deviation (MAD)	1006.5
Skewness	1.447358662
Sum	210476
Variance	39353256.89
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
0	4	8.3%
20211	1	2.1%
108	1	2.1%
439	1	2.1%
478	1	2.1%
817	1	2.1%
2412	1	2.1%
6769	1	2.1%
11977	1	2.1%
17148	1	2.1%
Other values (35)	35	72.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	8.3%
6	1	2.1%
43	1	2.1%
56	1	2.1%
60	1	2.1%
79	1	2.1%
105	1	2.1%
108	1	2.1%
137	1	2.1%
148	1	2.1%

Value	Count	Frequency (%)
20211	1	2.1%
19667	1	2.1%
18750	1	2.1%
17938	1	2.1%
17148	1	2.1%
15486	1	2.1%
12961	1	2.1%
11977	1	2.1%
10329	1	2.1%
9378	1	2.1%

10년이상15년미만
Real number (ℝ_≥0)

ZEROS

Distinct	39
Distinct (%)	81.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3075.1875

Minimum	0
Maximum	16053
Zeros	10
Zeros (%)	20.8%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	28.5
median	590.5
Q3	3620.5
95-th percentile	15289.7
Maximum	16053
Range	16053
Interquartile range (IQR)	3592

Descriptive statistics

Standard deviation	4991.680234
Coefficient of variation (CV)	1.623211669
Kurtosis	1.583044863
Mean	3075.1875
Median Absolute Deviation (MAD)	590.5
Skewness	1.703523319
Sum	147609
Variance	24916871.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
0	10	20.8%
564	1	2.1%
31	1	2.1%
90	1	2.1%
340	1	2.1%
1168	1	2.1%
3910	1	2.1%
6978	1	2.1%
10311	1	2.1%
16019	1	2.1%
Other values (29)	29	60.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	20.8%
3	1	2.1%
24	1	2.1%
30	1	2.1%
31	1	2.1%
32	1	2.1%
48	1	2.1%
83	1	2.1%
85	1	2.1%
90	1	2.1%

Value	Count	Frequency (%)
16053	1	2.1%
16019	1	2.1%
15933	1	2.1%
14095	1	2.1%
13911	1	2.1%
11196	1	2.1%
10311	1	2.1%
8787	1	2.1%
6978	1	2.1%
5713	1	2.1%

15년이상20년미만
Real number (ℝ_≥0)

ZEROS

Distinct	34
Distinct (%)	70.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3810.875

Minimum	0
Maximum	24061
Zeros	15
Zeros (%)	31.2%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	289.5
Q3	4157
95-th percentile	18212.1
Maximum	24061
Range	24061
Interquartile range (IQR)	4157

Descriptive statistics

Standard deviation	6588.314719
Coefficient of variation (CV)	1.728819423
Kurtosis	2.335961059
Mean	3810.875
Median Absolute Deviation (MAD)	289.5
Skewness	1.844935709
Sum	182922
Variance	43405890.84
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	15	31.2%
18190	1	2.1%
10664	1	2.1%
13518	1	2.1%
17046	1	2.1%
18224	1	2.1%
24061	1	2.1%
22530	1	2.1%
12757	1	2.1%
6697	1	2.1%
Other values (24)	24	50.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15	31.2%
5	1	2.1%
19	1	2.1%
26	1	2.1%
29	1	2.1%
47	1	2.1%
53	1	2.1%
109	1	2.1%
113	1	2.1%
206	1	2.1%

Value	Count	Frequency (%)
24061	1	2.1%
22530	1	2.1%
18224	1	2.1%
18190	1	2.1%
17046	1	2.1%
13518	1	2.1%
12757	1	2.1%
10664	1	2.1%
9027	1	2.1%
6861	1	2.1%

20년이상25년미만
Real number (ℝ_≥0)

ZEROS

Distinct	30
Distinct (%)	62.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2554.979167

Minimum	0
Maximum	17387
Zeros	19
Zeros (%)	39.6%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	72.5
Q3	2061
95-th percentile	14286.8
Maximum	17387
Range	17387
Interquartile range (IQR)	2061

Descriptive statistics

Standard deviation	4767.558693
Coefficient of variation (CV)	1.865987306
Kurtosis	2.764018016
Mean	2554.979167
Median Absolute Deviation (MAD)	72.5
Skewness	1.986124004
Sum	122639
Variance	22729615.89
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	19	39.6%
8680	1	2.1%
28	1	2.1%
18	1	2.1%
68	1	2.1%
188	1	2.1%
595	1	2.1%
2469	1	2.1%
6519	1	2.1%
10596	1	2.1%
Other values (20)	20	41.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	39.6%
1	1	2.1%
18	1	2.1%
28	1	2.1%
46	1	2.1%
68	1	2.1%
77	1	2.1%
146	1	2.1%
188	1	2.1%
228	1	2.1%

Value	Count	Frequency (%)
17387	1	2.1%
15612	1	2.1%
14599	1	2.1%
13707	1	2.1%
11489	1	2.1%
10596	1	2.1%
8680	1	2.1%
6519	1	2.1%
5697	1	2.1%
3923	1	2.1%

25년이상30년미만
Real number (ℝ_≥0)

ZEROS

Distinct	25
Distinct (%)	52.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2866.125

Minimum	0
Maximum	20553
Zeros	24
Zeros (%)	50.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4.5
Q3	2244.25
95-th percentile	17202.4
Maximum	20553
Range	20553
Interquartile range (IQR)	2244.25

Descriptive statistics

Standard deviation	5633.303632
Coefficient of variation (CV)	1.965477302
Kurtosis	3.465415374
Mean	2866.125
Median Absolute Deviation (MAD)	4.5
Skewness	2.133567366
Sum	137574
Variance	31734109.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	24	50.0%
8690	1	2.1%
52	1	2.1%
126	1	2.1%
450	1	2.1%
919	1	2.1%
2192	1	2.1%
5765	1	2.1%
11594	1	2.1%
15398	1	2.1%
Other values (15)	15	31.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	24	50.0%
9	1	2.1%
52	1	2.1%
126	1	2.1%
171	1	2.1%
191	1	2.1%
297	1	2.1%
450	1	2.1%
505	1	2.1%
919	1	2.1%

Value	Count	Frequency (%)
20553	1	2.1%
19575	1	2.1%
18174	1	2.1%
15398	1	2.1%
13573	1	2.1%
11594	1	2.1%
8690	1	2.1%
6204	1	2.1%
5765	1	2.1%
4383	1	2.1%

30년이상33년이하
Real number (ℝ_≥0)

ZEROS

Distinct	21
Distinct (%)	43.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1851.270833

Minimum	0
Maximum	14262
Zeros	27
Zeros (%)	56.2%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	729
95-th percentile	11372.85
Maximum	14262
Range	14262
Interquartile range (IQR)	729

Descriptive statistics

Standard deviation	3876.006712
Coefficient of variation (CV)	2.093700523
Kurtosis	3.924850573
Mean	1851.270833
Median Absolute Deviation (MAD)	0
Skewness	2.215646275
Sum	88861
Variance	15023428.03
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	27	56.2%
1	2	4.2%
43	1	2.1%
12	1	2.1%
507	1	2.1%
1487	1	2.1%
3476	1	2.1%
5609	1	2.1%
9487	1	2.1%
14076	1	2.1%
Other values (11)	11	22.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	27	56.2%
1	2	4.2%
12	1	2.1%
43	1	2.1%
156	1	2.1%
164	1	2.1%
220	1	2.1%
408	1	2.1%
507	1	2.1%
1395	1	2.1%

Value	Count	Frequency (%)
14262	1	2.1%
14076	1	2.1%
12349	1	2.1%
9560	1	2.1%
9487	1	2.1%
7005	1	2.1%
5609	1	2.1%
4835	1	2.1%
3808	1	2.1%
3476	1	2.1%

33년초과40년미만
Real number (ℝ_≥0)

ZEROS

Distinct	20
Distinct (%)	41.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1847.020833

Minimum	0
Maximum	15099
Zeros	29
Zeros (%)	60.4%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	276
95-th percentile	13954.15
Maximum	15099
Range	15099
Interquartile range (IQR)	276

Descriptive statistics

Standard deviation	4231.09826
Coefficient of variation (CV)	2.290769105
Kurtosis	4.544699649
Mean	1847.020833
Median Absolute Deviation (MAD)	0
Skewness	2.389007503
Sum	88657
Variance	17902192.49
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	29	60.4%
7992	1	2.1%
145	1	2.1%
2	1	2.1%
6	1	2.1%
22	1	2.1%
224	1	2.1%
1590	1	2.1%
3843	1	2.1%
5353	1	2.1%
Other values (10)	10	20.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29	60.4%
1	1	2.1%
2	1	2.1%
6	1	2.1%
22	1	2.1%
145	1	2.1%
224	1	2.1%
267	1	2.1%
303	1	2.1%
817	1	2.1%

Value	Count	Frequency (%)
15099	1	2.1%
14740	1	2.1%
14455	1	2.1%
13024	1	2.1%
7992	1	2.1%
7894	1	2.1%
5353	1	2.1%
3843	1	2.1%
2880	1	2.1%
1590	1	2.1%

40년이상
Real number (ℝ_≥0)

ZEROS

Distinct	13
Distinct (%)	27.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86.0625

Minimum	0
Maximum	1229
Zeros	36
Zeros (%)	75.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.25
95-th percentile	823.5
Maximum	1229
Range	1229
Interquartile range (IQR)	0.25

Descriptive statistics

Standard deviation	276.1409913
Coefficient of variation (CV)	3.208609921
Kurtosis	11.11720065
Mean	86.0625
Median Absolute Deviation (MAD)	0
Skewness	3.473762194
Sum	4131
Variance	76253.84707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	36	75.0%
1	1	2.1%
11	1	2.1%
20	1	2.1%
40	1	2.1%
222	1	2.1%
1044	1	2.1%
1229	1	2.1%
1055	1	2.1%
414	1	2.1%
Other values (3)	3	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	36	75.0%
1	1	2.1%
11	1	2.1%
20	1	2.1%
21	1	2.1%
31	1	2.1%
40	1	2.1%
43	1	2.1%
222	1	2.1%
414	1	2.1%

Value	Count	Frequency (%)
1229	1	2.1%
1055	1	2.1%
1044	1	2.1%
414	1	2.1%
222	1	2.1%
43	1	2.1%
40	1	2.1%
31	1	2.1%
21	1	2.1%
20	1	2.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

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

	구분	계	5년미만	5년이상10년미만
0	18세이상	33	33	0
1	19세	471	471	0
2	20세	692	692	0
3	21세	978	978	0
4	22세	1544	1538	6
5	23세	5037	4929	108
6	24세	10443	10004	439
7	25세	16708	16230	478
8	26세	23694	22877	817
9	27세	30038	27626	2412

Last rows

	구분	계	5년미만	5년이상10년미만	10년이상15년미만	15년이상20년미만	20년이상25년미만	25년이상30년미만	30년이상33년이하	33년초과40년미만	40년이상
38	56세	30467	545	256	564	869	1246	4383	9560	13024	20
39	57세	27699	466	194	336	666	1103	3149	7005	14740	40
40	58세	24019	381	175	261	476	813	2401	4835	14455	222
41	59세	23865	313	137	167	408	731	2158	3808	15099	1044
42	60세	12612	227	105	85	206	426	1045	1395	7894	1229
43	61세	5582	266	79	48	113	228	505	408	2880	1055
44	62세	2248	213	56	32	53	146	297	220	817	414
45	63세	1026	194	43	30	29	77	191	164	267	31
46	64세	1000	171	60	24	26	46	171	156	303	43
47	65세이상	1104	537	148	83	47	28	52	43	145	21

Overview

Variables

Common Values

Length

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows