Overview

Dataset statistics

Number of variables6
Number of observations1064
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory53.1 KiB
Average record size in memory51.1 B

Variable types

Numeric3
DateTime2
Categorical1

Dataset

Description사립학교교직원연금공단 급여지급현황(연계연금결정지급, 연계월연금지급, 연금급여, 연금월지급, 장기급여, 재해장기급여)의 자료로 순서, 처리일, 지급구분, 지급일, 건수, 급여금액의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15113281/fileData.do

Alerts

건수 is highly overall correlated with 급여금액High correlation
급여금액 is highly overall correlated with 건수High correlation
순서 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:29:43.409393
Analysis finished2023-12-12 11:29:46.528055
Duration3.12 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순서
Real number (ℝ)

UNIQUE 

Distinct1064
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean532.5
Minimum1
Maximum1064
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.5 KiB
2023-12-12T20:29:46.647523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile54.15
Q1266.75
median532.5
Q3798.25
95-th percentile1010.85
Maximum1064
Range1063
Interquartile range (IQR)531.5

Descriptive statistics

Standard deviation307.29465
Coefficient of variation (CV)0.57707915
Kurtosis-1.2
Mean532.5
Median Absolute Deviation (MAD)266
Skewness0
Sum566580
Variance94430
MonotonicityStrictly increasing
2023-12-12T20:29:46.895973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
716 1
 
0.1%
702 1
 
0.1%
703 1
 
0.1%
704 1
 
0.1%
705 1
 
0.1%
706 1
 
0.1%
707 1
 
0.1%
708 1
 
0.1%
709 1
 
0.1%
Other values (1054) 1054
99.1%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1064 1
0.1%
1063 1
0.1%
1062 1
0.1%
1061 1
0.1%
1060 1
0.1%
1059 1
0.1%
1058 1
0.1%
1057 1
0.1%
1056 1
0.1%
1055 1
0.1%

처리일
Date

Distinct241
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size8.4 KiB
Minimum2022-01-03 00:00:00
Maximum2022-12-27 00:00:00
2023-12-12T20:29:47.110685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:47.330005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

지급구분
Categorical

Distinct6
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size8.4 KiB
장기급여
415 
연금급여
334 
연금월지급
219 
연계연금결정지급
66 
연계월연금지급
 
21

Length

Max length8
Median length4
Mean length4.5300752
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row장기급여
2nd row연금급여
3rd row연금월지급
4th row장기급여
5th row연금급여

Common Values

ValueCountFrequency (%)
장기급여 415
39.0%
연금급여 334
31.4%
연금월지급 219
20.6%
연계연금결정지급 66
 
6.2%
연계월연금지급 21
 
2.0%
재해장기급여 9
 
0.8%

Length

2023-12-12T20:29:47.624455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:29:47.809336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
장기급여 415
39.0%
연금급여 334
31.4%
연금월지급 219
20.6%
연계연금결정지급 66
 
6.2%
연계월연금지급 21
 
2.0%
재해장기급여 9
 
0.8%

지급일
Date

Distinct241
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size8.4 KiB
Minimum2022-01-03 00:00:00
Maximum2023-01-03 00:00:00
2023-12-12T20:29:48.017092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:48.263653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

건수
Real number (ℝ)

HIGH CORRELATION 

Distinct202
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1222.4041
Minimum1
Maximum105797
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.5 KiB
2023-12-12T20:29:48.512905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median9
Q348
95-th percentile246.4
Maximum105797
Range105796
Interquartile range (IQR)46

Descriptive statistics

Standard deviation10873.163
Coefficient of variation (CV)8.8949003
Kurtosis84.204753
Mean1222.4041
Median Absolute Deviation (MAD)8
Skewness9.2714506
Sum1300638
Variance1.1822567 × 108
MonotonicityNot monotonic
2023-12-12T20:29:48.801873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 203
19.1%
2 90
 
8.5%
4 63
 
5.9%
3 61
 
5.7%
5 32
 
3.0%
6 28
 
2.6%
7 25
 
2.3%
8 25
 
2.3%
9 25
 
2.3%
10 17
 
1.6%
Other values (192) 495
46.5%
ValueCountFrequency (%)
1 203
19.1%
2 90
8.5%
3 61
 
5.7%
4 63
 
5.9%
5 32
 
3.0%
6 28
 
2.6%
7 25
 
2.3%
8 25
 
2.3%
9 25
 
2.3%
10 17
 
1.6%
ValueCountFrequency (%)
105797 1
0.1%
105762 1
0.1%
105670 1
0.1%
105483 1
0.1%
102863 1
0.1%
102792 1
0.1%
102598 1
0.1%
102542 1
0.1%
102467 1
0.1%
102363 1
0.1%

급여금액
Real number (ℝ)

HIGH CORRELATION 

Distinct1054
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.360441 × 109
Minimum0
Maximum2.9895126 × 1011
Zeros9
Zeros (%)0.8%
Negative0
Negative (%)0.0%
Memory size9.5 KiB
2023-12-12T20:29:49.048504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile938176
Q119953755
median2.3641724 × 108
Q37.6495376 × 108
95-th percentile3.9755542 × 109
Maximum2.9895126 × 1011
Range2.9895126 × 1011
Interquartile range (IQR)7.45 × 108

Descriptive statistics

Standard deviation3.1325289 × 1010
Coefficient of variation (CV)7.1839725
Kurtosis77.609854
Mean4.360441 × 109
Median Absolute Deviation (MAD)2.3270652 × 108
Skewness8.8468946
Sum4.6395093 × 1012
Variance9.812737 × 1020
MonotonicityNot monotonic
2023-12-12T20:29:49.332358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9
 
0.8%
2047700 2
 
0.2%
1418190 2
 
0.2%
122641540 1
 
0.1%
602351170 1
 
0.1%
540286130 1
 
0.1%
1193270 1
 
0.1%
205070 1
 
0.1%
460008410 1
 
0.1%
506134900 1
 
0.1%
Other values (1044) 1044
98.1%
ValueCountFrequency (%)
0 9
0.8%
18990 1
 
0.1%
69230 1
 
0.1%
72740 1
 
0.1%
91820 1
 
0.1%
95330 1
 
0.1%
127060 1
 
0.1%
140470 1
 
0.1%
157000 1
 
0.1%
192180 1
 
0.1%
ValueCountFrequency (%)
298951257820 1
0.1%
298944508610 1
0.1%
298876479350 1
0.1%
298659968244 1
0.1%
290174743910 1
0.1%
290147338880 1
0.1%
289766653520 1
0.1%
289668574430 1
0.1%
289575975310 1
0.1%
289528952140 1
0.1%

Interactions

2023-12-12T20:29:44.940774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:43.799305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:44.433582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:45.157399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:44.006624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:44.594175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:45.484491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:44.211039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:29:44.767085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:29:49.533446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순서지급구분건수급여금액
순서1.0000.0000.0000.000
지급구분0.0001.0000.2760.139
건수0.0000.2761.0001.000
급여금액0.0000.1391.0001.000
2023-12-12T20:29:49.702676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순서건수급여금액지급구분
순서1.000-0.128-0.0970.000
건수-0.1281.0000.8800.198
급여금액-0.0970.8801.0000.094
지급구분0.0000.1980.0941.000

Missing values

2023-12-12T20:29:46.287648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:29:46.471714image/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

순서처리일지급구분지급일건수급여금액
012022-01-03장기급여2022-01-032472505033360
122022-01-03연금급여2022-01-037475294810
232022-01-03연금월지급2022-01-0368337560
342022-01-03장기급여2022-01-035456068655540
452022-01-03연금급여2022-01-0321800337430
562022-01-04장기급여2022-01-061391749183370
672022-01-04연금급여2022-01-04371634180220
782022-01-04연계연금결정지급2022-01-0411178230
892022-01-04연금월지급2022-01-0513108436600
9102022-01-04장기급여2022-01-042862135026050
순서처리일지급구분지급일건수급여금액
105410552022-12-23장기급여2022-12-231101545874000
105510562022-12-23연금급여2022-12-232125790000
105610572022-12-23연금월지급2022-12-231157000
105710582022-12-23장기급여2022-12-23113107440
105810592022-12-26장기급여2022-12-2751356244710
105910602022-12-26연금급여2022-12-276356343980
106010612022-12-27장기급여2022-12-29871084823790
106110622022-12-27연금급여2022-12-278599202060
106210632022-12-27연계연금결정지급2022-12-271127060
106310642022-12-27연금월지급2022-12-2890