Overview

Dataset statistics

Number of variables7
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)4.2%
Total size in memory1.6 KiB
Average record size in memory68.5 B

Variable types

Numeric7

Dataset

Description사립학교교직원연금공단 직역연금별 재직기간 합산 승인 내역(공무원)과 관련된 데이터로 연도, 교직원별(교원, 사무직원) 공무원연금 재직기간 합산 승인 건수, 평균합산기간 및 평균반납금액을 제공합니다.
URLhttps://www.data.go.kr/data/15049781/fileData.do

Alerts

Dataset has 1 (4.2%) duplicate rowsDuplicates
연도 is highly overall correlated with 교원 평균반납금액(원) and 3 other fieldsHigh correlation
교원 건수 is highly overall correlated with 교원 평균반납금액(원) and 1 other fieldsHigh correlation
교원 평균반납금액(원) is highly overall correlated with 연도 and 3 other fieldsHigh correlation
사무직원 건수 is highly overall correlated with 연도 and 2 other fieldsHigh correlation
사무직원 평균기간(개월) is highly overall correlated with 연도High correlation
사무직원 평균반납금액(원) is highly overall correlated with 연도 and 3 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 18:54:57.899043
Analysis finished2023-12-12 18:55:05.766082
Duration7.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Real number (ℝ)

HIGH CORRELATION 

Distinct23
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2010.5833
Minimum2000
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T03:55:05.867057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2000
5-th percentile2001
Q12004.75
median2010.5
Q32016.25
95-th percentile2020.85
Maximum2022
Range22
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation6.9402209
Coefficient of variation (CV)0.0034518445
Kurtosis-1.2583183
Mean2010.5833
Median Absolute Deviation (MAD)6
Skewness0.054843043
Sum48254
Variance48.166667
MonotonicityIncreasing
2023-12-13T03:55:06.082250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
2001 2
 
8.3%
2000 1
 
4.2%
2022 1
 
4.2%
2021 1
 
4.2%
2020 1
 
4.2%
2019 1
 
4.2%
2018 1
 
4.2%
2017 1
 
4.2%
2016 1
 
4.2%
2015 1
 
4.2%
Other values (13) 13
54.2%
ValueCountFrequency (%)
2000 1
4.2%
2001 2
8.3%
2002 1
4.2%
2003 1
4.2%
2004 1
4.2%
2005 1
4.2%
2006 1
4.2%
2007 1
4.2%
2008 1
4.2%
2009 1
4.2%
ValueCountFrequency (%)
2022 1
4.2%
2021 1
4.2%
2020 1
4.2%
2019 1
4.2%
2018 1
4.2%
2017 1
4.2%
2016 1
4.2%
2015 1
4.2%
2014 1
4.2%
2013 1
4.2%

교원 건수
Real number (ℝ)

HIGH CORRELATION 

Distinct22
Distinct (%)91.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean472.25
Minimum231
Maximum1998
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T03:55:06.283542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum231
5-th percentile256
Q1285.75
median344
Q3458.25
95-th percentile1132.8
Maximum1998
Range1767
Interquartile range (IQR)172.5

Descriptive statistics

Standard deviation387.22685
Coefficient of variation (CV)0.81996156
Kurtosis10.919957
Mean472.25
Median Absolute Deviation (MAD)72
Skewness3.1606282
Sum11334
Variance149944.63
MonotonicityNot monotonic
2023-12-13T03:55:06.949764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
297 2
 
8.3%
256 2
 
8.3%
265 1
 
4.2%
803 1
 
4.2%
231 1
 
4.2%
300 1
 
4.2%
318 1
 
4.2%
367 1
 
4.2%
436 1
 
4.2%
383 1
 
4.2%
Other values (12) 12
50.0%
ValueCountFrequency (%)
231 1
4.2%
256 2
8.3%
265 1
4.2%
273 1
4.2%
285 1
4.2%
286 1
4.2%
297 2
8.3%
300 1
4.2%
318 1
4.2%
323 1
4.2%
ValueCountFrequency (%)
1998 1
4.2%
1191 1
4.2%
803 1
4.2%
542 1
4.2%
533 1
4.2%
525 1
4.2%
436 1
4.2%
417 1
4.2%
387 1
4.2%
383 1
4.2%

교원 평균기간(개월)
Real number (ℝ)

Distinct17
Distinct (%)70.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean89.041667
Minimum76
Maximum143
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T03:55:07.132588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum76
5-th percentile77
Q183
median85.5
Q393
95-th percentile101.8
Maximum143
Range67
Interquartile range (IQR)10

Descriptive statistics

Standard deviation13.392013
Coefficient of variation (CV)0.15040164
Kurtosis11.693094
Mean89.041667
Median Absolute Deviation (MAD)6
Skewness2.9929157
Sum2137
Variance179.34601
MonotonicityNot monotonic
2023-12-13T03:55:07.326474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
83 4
16.7%
95 2
 
8.3%
85 2
 
8.3%
93 2
 
8.3%
77 2
 
8.3%
76 1
 
4.2%
88 1
 
4.2%
94 1
 
4.2%
92 1
 
4.2%
78 1
 
4.2%
Other values (7) 7
29.2%
ValueCountFrequency (%)
76 1
 
4.2%
77 2
8.3%
78 1
 
4.2%
80 1
 
4.2%
83 4
16.7%
84 1
 
4.2%
85 2
8.3%
86 1
 
4.2%
88 1
 
4.2%
90 1
 
4.2%
ValueCountFrequency (%)
143 1
4.2%
103 1
4.2%
95 2
8.3%
94 1
4.2%
93 2
8.3%
92 1
4.2%
91 1
4.2%
90 1
4.2%
88 1
4.2%
86 1
4.2%

교원 평균반납금액(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct23
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27482254
Minimum15032145
Maximum72285014
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T03:55:07.523528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum15032145
5-th percentile16700828
Q122499994
median26179322
Q329991402
95-th percentile40163434
Maximum72285014
Range57252869
Interquartile range (IQR)7491407.2

Descriptive statistics

Standard deviation11245738
Coefficient of variation (CV)0.40919997
Kurtosis11.154603
Mean27482254
Median Absolute Deviation (MAD)3850602
Skewness2.8907106
Sum6.595741 × 108
Variance1.2646661 × 1014
MonotonicityNot monotonic
2023-12-13T03:55:07.729134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
16700828 2
 
8.3%
15032145 1
 
4.2%
30106970 1
 
4.2%
33830049 1
 
4.2%
30674663 1
 
4.2%
27120404 1
 
4.2%
27216918 1
 
4.2%
25379048 1
 
4.2%
26026449 1
 
4.2%
26736661 1
 
4.2%
Other values (13) 13
54.2%
ValueCountFrequency (%)
15032145 1
4.2%
16700828 2
8.3%
18344070 1
4.2%
19128555 1
4.2%
21446165 1
4.2%
22851271 1
4.2%
22968501 1
4.2%
24936674 1
4.2%
25379048 1
4.2%
25606810 1
4.2%
ValueCountFrequency (%)
72285014 1
4.2%
41281090 1
4.2%
33830049 1
4.2%
30674663 1
4.2%
30483255 1
4.2%
30106970 1
4.2%
29952879 1
4.2%
28432656 1
4.2%
27216918 1
4.2%
27120404 1
4.2%

사무직원 건수
Real number (ℝ)

HIGH CORRELATION 

Distinct20
Distinct (%)83.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean225.79167
Minimum40
Maximum1425
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T03:55:07.908420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum40
5-th percentile68.6
Q177
median136.5
Q3251.5
95-th percentile681.15
Maximum1425
Range1385
Interquartile range (IQR)174.5

Descriptive statistics

Standard deviation293.23844
Coefficient of variation (CV)1.2987124
Kurtosis13.003683
Mean225.79167
Median Absolute Deviation (MAD)62.5
Skewness3.4556746
Sum5419
Variance85988.781
MonotonicityNot monotonic
2023-12-13T03:55:08.128105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
77 3
 
12.5%
92 2
 
8.3%
257 2
 
8.3%
40 1
 
4.2%
136 1
 
4.2%
251 1
 
4.2%
256 1
 
4.2%
253 1
 
4.2%
200 1
 
4.2%
1425 1
 
4.2%
Other values (10) 10
41.7%
ValueCountFrequency (%)
40 1
 
4.2%
68 1
 
4.2%
72 1
 
4.2%
76 1
 
4.2%
77 3
12.5%
92 2
8.3%
103 1
 
4.2%
121 1
 
4.2%
136 1
 
4.2%
137 1
 
4.2%
ValueCountFrequency (%)
1425 1
4.2%
756 1
4.2%
257 2
8.3%
256 1
4.2%
253 1
4.2%
251 1
4.2%
228 1
4.2%
200 1
4.2%
198 1
4.2%
170 1
4.2%

사무직원 평균기간(개월)
Real number (ℝ)

HIGH CORRELATION 

Distinct20
Distinct (%)83.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean83.875
Minimum49
Maximum159
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T03:55:08.340663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum49
5-th percentile54.8
Q168.75
median82.5
Q386.75
95-th percentile130.75
Maximum159
Range110
Interquartile range (IQR)18

Descriptive statistics

Standard deviation23.279609
Coefficient of variation (CV)0.27755123
Kurtosis4.6662665
Mean83.875
Median Absolute Deviation (MAD)6.5
Skewness1.7847594
Sum2013
Variance541.94022
MonotonicityNot monotonic
2023-12-13T03:55:08.559734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
86 2
 
8.3%
89 2
 
8.3%
85 2
 
8.3%
80 2
 
8.3%
82 1
 
4.2%
49 1
 
4.2%
53 1
 
4.2%
67 1
 
4.2%
78 1
 
4.2%
66 1
 
4.2%
Other values (10) 10
41.7%
ValueCountFrequency (%)
49 1
4.2%
53 1
4.2%
65 1
4.2%
66 1
4.2%
67 1
4.2%
68 1
4.2%
69 1
4.2%
78 1
4.2%
80 2
8.3%
81 1
4.2%
ValueCountFrequency (%)
159 1
4.2%
136 1
4.2%
101 1
4.2%
92 1
4.2%
89 2
8.3%
86 2
8.3%
85 2
8.3%
84 1
4.2%
83 1
4.2%
82 1
4.2%

사무직원 평균반납금액(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct23
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19707539
Minimum10073429
Maximum55088037
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T03:55:08.769011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10073429
5-th percentile10572509
Q113128914
median16178371
Q321069974
95-th percentile44479447
Maximum55088037
Range45014608
Interquartile range (IQR)7941060.8

Descriptive statistics

Standard deviation11097716
Coefficient of variation (CV)0.56312031
Kurtosis4.5561534
Mean19707539
Median Absolute Deviation (MAD)3708874
Skewness2.1742382
Sum4.7298095 × 108
Variance1.2315929 × 1014
MonotonicityNot monotonic
2023-12-13T03:55:08.977799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
12469497 2
 
8.3%
12062622 1
 
4.2%
14649315 1
 
4.2%
16248892 1
 
4.2%
21688365 1
 
4.2%
25608724 1
 
4.2%
19154167 1
 
4.2%
20863844 1
 
4.2%
35730134 1
 
4.2%
13858094 1
 
4.2%
Other values (13) 13
54.2%
ValueCountFrequency (%)
10073429 1
4.2%
10309548 1
4.2%
12062622 1
4.2%
12287174 1
4.2%
12469497 2
8.3%
13348719 1
4.2%
13858094 1
4.2%
14649315 1
4.2%
15277358 1
4.2%
16156934 1
4.2%
ValueCountFrequency (%)
55088037 1
4.2%
46023443 1
4.2%
35730134 1
4.2%
25608724 1
4.2%
22841719 1
4.2%
21688365 1
4.2%
20863844 1
4.2%
19154167 1
4.2%
17483425 1
4.2%
16931267 1
4.2%

Interactions

2023-12-13T03:55:04.234073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:58.197635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:59.144220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:00.102508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.002262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.877206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:02.987435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:04.370472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:58.319528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:59.355798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:00.233232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.119249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:02.011564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:03.134548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:04.525665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:58.452843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:59.511098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:00.344705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.250099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:02.155461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:03.300081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:04.682979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:58.568771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:59.632041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:00.481433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.376033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:02.344244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:03.582293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:04.883231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:58.703857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:59.747127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:00.602233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.499768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:02.515793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:03.760176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:05.076124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:58.847860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:59.864886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:00.747878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.642551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:02.688211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:03.952960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:05.238076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:58.997283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:54:59.981913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:00.864802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:01.761636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:02.837234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:55:04.085307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:55:09.138035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도교원 건수교원 평균기간(개월)교원 평균반납금액(원)사무직원 건수사무직원 평균기간(개월)사무직원 평균반납금액(원)
연도1.0000.6450.5620.7470.7480.6120.677
교원 건수0.6451.0000.8690.7730.6100.7980.781
교원 평균기간(개월)0.5620.8691.0000.5460.5810.6350.552
교원 평균반납금액(원)0.7470.7730.5461.0000.7680.8250.775
사무직원 건수0.7480.6100.5810.7681.0000.7320.940
사무직원 평균기간(개월)0.6120.7980.6350.8250.7321.0000.897
사무직원 평균반납금액(원)0.6770.7810.5520.7750.9400.8971.000
2023-12-13T03:55:09.290522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도교원 건수교원 평균기간(개월)교원 평균반납금액(원)사무직원 건수사무직원 평균기간(개월)사무직원 평균반납금액(원)
연도1.0000.3250.1140.7800.857-0.5410.655
교원 건수0.3251.000-0.1510.5360.4910.1940.671
교원 평균기간(개월)0.114-0.1511.0000.4400.0500.3850.202
교원 평균반납금액(원)0.7800.5360.4401.0000.728-0.0790.749
사무직원 건수0.8570.4910.0500.7281.000-0.3530.809
사무직원 평균기간(개월)-0.5410.1940.385-0.079-0.3531.000-0.005
사무직원 평균반납금액(원)0.6550.6710.2020.7490.809-0.0051.000

Missing values

2023-12-13T03:55:05.437749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:55:05.677604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

연도교원 건수교원 평균기간(개월)교원 평균반납금액(원)사무직원 건수사무직원 평균기간(개월)사무직원 평균반납금액(원)
020002659115032145408612062622
120012568316700828778012469497
220012568316700828778012469497
320022858518344070688310309548
420032869022851271778913348719
520042738621446165768512287174
620053238019128555928610073429
720064178422968501928416931267
82007365932560681012110116187417
92008387103299528791038916169325
연도교원 건수교원 평균기간(개월)교원 평균반납금액(원)사무직원 건수사무직원 평균기간(개월)사무직원 평균반납금액(원)
142013803934128109022813646023443
15201454283304832551368217483425
16201553377267366611706813858094
172016383832602644914258535730134
18201743678253790482576520863844
19201836792272169182006619154167
20201931885271204042537825608724
21202030095306746632566721688365
22202129794338300492575316248892
23202223188301069702514914649315

Duplicate rows

Most frequently occurring

연도교원 건수교원 평균기간(개월)교원 평균반납금액(원)사무직원 건수사무직원 평균기간(개월)사무직원 평균반납금액(원)# duplicates
0200125683167008287780124694972