Overview

Dataset statistics

Number of variables5
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory46.4 B

Variable types

Categorical3
Numeric2

Dataset

Description사립학교교직원연금공단 퇴직연금일시급 지급 현황과 관련된 데이터로 구분, 직종(교원,사무직원), 성별, 건수, 금액 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15065018/fileData.do

Alerts

건수 is highly overall correlated with 금액High correlation
금액 is highly overall correlated with 건수High correlation
건수 has 2 (6.7%) zerosZeros
금액 has 2 (6.7%) zerosZeros

Reproduction

Analysis started2023-12-12 13:23:57.125353
Analysis finished2023-12-12 13:23:57.767186
Duration0.64 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct8
Distinct (%)26.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
유치원
초등학교
중학교
고등학교
전문대학
Other values (3)
10 

Length

Max length6
Median length4
Mean length4
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유치원
2nd row유치원
3rd row유치원
4th row유치원
5th row초등학교

Common Values

ValueCountFrequency (%)
유치원 4
13.3%
초등학교 4
13.3%
중학교 4
13.3%
고등학교 4
13.3%
전문대학 4
13.3%
대학(교) 4
13.3%
특수학교 4
13.3%
학교경영기관 2
6.7%

Length

2023-12-12T22:23:57.829783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:23:57.933230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유치원 4
13.3%
초등학교 4
13.3%
중학교 4
13.3%
고등학교 4
13.3%
전문대학 4
13.3%
대학(교 4
13.3%
특수학교 4
13.3%
학교경영기관 2
6.7%

직종
Categorical

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
사무직원
16 
교원
14 

Length

Max length4
Median length4
Mean length3.0666667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row교원
2nd row교원
3rd row사무직원
4th row사무직원
5th row교원

Common Values

ValueCountFrequency (%)
사무직원 16
53.3%
교원 14
46.7%

Length

2023-12-12T22:23:58.074178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:23:58.183694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사무직원 16
53.3%
교원 14
46.7%

성별
Categorical

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
15 
15 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
15
50.0%
15
50.0%

Length

2023-12-12T22:23:58.275411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:23:58.380349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
15
50.0%
15
50.0%

건수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct23
Distinct (%)76.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.7
Minimum0
Maximum333
Zeros2
Zeros (%)6.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-12T22:23:58.486031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.45
Q12.25
median9.5
Q323
95-th percentile197.9
Maximum333
Range333
Interquartile range (IQR)20.75

Descriptive statistics

Standard deviation75.612966
Coefficient of variation (CV)2.005649
Kurtosis8.5065014
Mean37.7
Median Absolute Deviation (MAD)8.5
Skewness2.8982953
Sum1131
Variance5717.3207
MonotonicityNot monotonic
2023-12-12T22:23:58.599435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
1 5
 
16.7%
10 2
 
6.7%
0 2
 
6.7%
4 2
 
6.7%
34 1
 
3.3%
2 1
 
3.3%
224 1
 
3.3%
106 1
 
3.3%
55 1
 
3.3%
166 1
 
3.3%
Other values (13) 13
43.3%
ValueCountFrequency (%)
0 2
 
6.7%
1 5
16.7%
2 1
 
3.3%
3 1
 
3.3%
4 2
 
6.7%
5 1
 
3.3%
6 1
 
3.3%
7 1
 
3.3%
9 1
 
3.3%
10 2
 
6.7%
ValueCountFrequency (%)
333 1
3.3%
224 1
3.3%
166 1
3.3%
106 1
3.3%
55 1
3.3%
46 1
3.3%
34 1
3.3%
24 1
3.3%
20 1
3.3%
19 1
3.3%

금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.1245372 × 109
Minimum0
Maximum1.9725228 × 1010
Zeros2
Zeros (%)6.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-12T22:23:58.729964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile17182152
Q11.719039 × 108
median7.2473066 × 108
Q32.2182354 × 109
95-th percentile1.5846237 × 1010
Maximum1.9725228 × 1010
Range1.9725228 × 1010
Interquartile range (IQR)2.0463314 × 109

Descriptive statistics

Standard deviation5.3392011 × 109
Coefficient of variation (CV)1.7087974
Kurtosis3.775843
Mean3.1245372 × 109
Median Absolute Deviation (MAD)6.8490457 × 108
Skewness2.1597453
Sum9.3736116 × 1010
Variance2.8507068 × 1019
MonotonicityNot monotonic
2023-12-12T22:23:58.854389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
0 2
 
6.7%
1089169240 1
 
3.3%
14051399090 1
 
3.3%
40819360 1
 
3.3%
56877700 1
 
3.3%
154484200 1
 
3.3%
643571150 1
 
3.3%
17314741380 1
 
3.3%
11190511120 1
 
3.3%
5430309380 1
 
3.3%
Other values (19) 19
63.3%
ValueCountFrequency (%)
0 2
6.7%
38182560 1
3.3%
38832820 1
3.3%
40819360 1
3.3%
56877700 1
3.3%
59013480 1
3.3%
154484200 1
3.3%
224163020 1
3.3%
247686800 1
3.3%
386252470 1
3.3%
ValueCountFrequency (%)
19725227590 1
3.3%
17314741380 1
3.3%
14051399090 1
3.3%
11190511120 1
3.3%
6299286830 1
3.3%
5430309380 1
3.3%
4211858750 1
3.3%
2246524670 1
3.3%
2133367410 1
3.3%
1751217010 1
3.3%

Interactions

2023-12-12T22:23:57.462979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:23:57.302909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:23:57.543429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:23:57.378011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:23:58.950453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분직종성별건수금액
구분1.0000.0000.0000.0000.000
직종0.0001.0000.0000.4790.569
성별0.0000.0001.0000.0000.000
건수0.0000.4790.0001.0001.000
금액0.0000.5690.0001.0001.000
2023-12-12T22:23:59.048841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
직종성별구분
직종1.0000.0000.000
성별0.0001.0000.000
구분0.0000.0001.000
2023-12-12T22:23:59.136642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건수금액구분직종성별
건수1.0000.9860.0000.3120.000
금액0.9861.0000.0000.3720.000
구분0.0000.0001.0000.0000.000
직종0.3120.3720.0001.0000.000
성별0.0000.0000.0000.0001.000

Missing values

2023-12-12T22:23:57.649505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:23:57.734023image/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

구분직종성별건수금액
0유치원교원101089169240
1유치원교원33314051399090
2유치원사무직원10689161540
3유치원사무직원7555661350
4초등학교교원3386252470
5초등학교교원138182560
6초등학교사무직원159013480
7초등학교사무직원138832820
8중학교교원142133367410
9중학교교원6703170760
구분직종성별건수금액
20대학(교)교원16619725227590
21대학(교)교원555430309380
22대학(교)사무직원10611190511120
23대학(교)사무직원22417314741380
24특수학교교원4643571150
25특수학교교원2154484200
26특수학교사무직원156877700
27특수학교사무직원00
28학교경영기관사무직원140819360
29학교경영기관사무직원00