Overview

Dataset statistics

Number of variables7
Number of observations761
Missing cells846
Missing cells (%)15.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory45.5 KiB
Average record size in memory61.2 B

Variable types

Categorical2
Numeric5

Dataset

Description대출상품별(일반상환학자금대출, 취업후상환학자금대출, 정부보증부학자금대출, 특별상환유예대출, 군복무이자유예대출, 대졸원리금유예대출) 사회적배려계층 및 중소기업재직자 분할상환약정금액, 승인건수, 유지건수 정보를 제공함분할상환약정 관련 지원내용, 신청절차 등 상세정보는 재단 홈페이지 참고- 사회적배려계층: https://www.kosaf.go.kr/ko/tuition.do?pg=tuition07_03- 중소기업 재직자: https://www.kosaf.go.kr/ko/tuition.do?pg=tuition07_11
Author한국장학재단
URLhttps://www.data.go.kr/data/15113894/fileData.do

Alerts

약정승인금액 is highly overall correlated with 약정승인건수High correlation
약정승인건수 is highly overall correlated with 약정승인금액 and 2 other fieldsHigh correlation
약정유지건수 is highly overall correlated with 약정승인건수High correlation
약정구분 is highly overall correlated with 약정승인건수High correlation
약정승인금액 has 423 (55.6%) missing valuesMissing
약정승인건수 has 423 (55.6%) missing valuesMissing

Reproduction

Analysis started2024-03-23 06:43:10.435769
Analysis finished2024-03-23 06:43:22.189956
Duration11.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약정구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
사회적배려계층
476 
중소기업
285 

Length

Max length7
Median length7
Mean length5.8764783
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사회적배려계층
2nd row사회적배려계층
3rd row사회적배려계층
4th row사회적배려계층
5th row사회적배려계층

Common Values

ValueCountFrequency (%)
사회적배려계층 476
62.5%
중소기업 285
37.5%

Length

2024-03-23T06:43:23.060822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:43:23.758328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사회적배려계층 476
62.5%
중소기업 285
37.5%

약정연도
Real number (ℝ)

Distinct11
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2019.611
Minimum2013
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.8 KiB
2024-03-23T06:43:24.338937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2013
5-th percentile2015
Q12018
median2020
Q32022
95-th percentile2023
Maximum2023
Range10
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.6134438
Coefficient of variation (CV)0.0012940332
Kurtosis-0.67279018
Mean2019.611
Median Absolute Deviation (MAD)2
Skewness-0.48883075
Sum1536924
Variance6.8300885
MonotonicityNot monotonic
2024-03-23T06:43:25.208108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
2023 119
15.6%
2022 108
14.2%
2021 100
13.1%
2020 96
12.6%
2019 90
11.8%
2018 72
9.5%
2017 70
9.2%
2016 43
 
5.7%
2015 32
 
4.2%
2014 24
 
3.2%
ValueCountFrequency (%)
2013 7
 
0.9%
2014 24
 
3.2%
2015 32
 
4.2%
2016 43
 
5.7%
2017 70
9.2%
2018 72
9.5%
2019 90
11.8%
2020 96
12.6%
2021 100
13.1%
2022 108
14.2%
ValueCountFrequency (%)
2023 119
15.6%
2022 108
14.2%
2021 100
13.1%
2020 96
12.6%
2019 90
11.8%
2018 72
9.5%
2017 70
9.2%
2016 43
 
5.7%
2015 32
 
4.2%
2014 24
 
3.2%

약정월
Real number (ℝ)

Distinct12
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.6636005
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.8 KiB
2024-03-23T06:43:25.748610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q14
median7
Q310
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.4602787
Coefficient of variation (CV)0.51928063
Kurtosis-1.2226537
Mean6.6636005
Median Absolute Deviation (MAD)3
Skewness-0.059271501
Sum5071
Variance11.973529
MonotonicityNot monotonic
2024-03-23T06:43:26.099090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
10 68
8.9%
11 68
8.9%
12 68
8.9%
9 66
8.7%
7 63
8.3%
8 63
8.3%
5 62
8.1%
6 62
8.1%
3 61
8.0%
4 61
8.0%
Other values (2) 119
15.6%
ValueCountFrequency (%)
1 59
7.8%
2 60
7.9%
3 61
8.0%
4 61
8.0%
5 62
8.1%
6 62
8.1%
7 63
8.3%
8 63
8.3%
9 66
8.7%
10 68
8.9%
ValueCountFrequency (%)
12 68
8.9%
11 68
8.9%
10 68
8.9%
9 66
8.7%
8 63
8.3%
7 63
8.3%
6 62
8.1%
5 62
8.1%
4 61
8.0%
3 61
8.0%

상품명
Categorical

Distinct11
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
일반상환학자금대출
187 
정부보증부학자금대출
187 
취업후상환학자금대출
162 
특별상환유예대출
64 
군복무이자유예대출
42 
Other values (6)
119 

Length

Max length10
Median length9
Mean length8.7963206
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반상환학자금대출
2nd row정부보증부학자금대출
3rd row일반상환학자금대출
4th row정부보증부학자금대출
5th row일반상환학자금대출

Common Values

ValueCountFrequency (%)
일반상환학자금대출 187
24.6%
정부보증부학자금대출 187
24.6%
취업후상환학자금대출 162
21.3%
특별상환유예대출 64
 
8.4%
군복무이자유예대출 42
 
5.5%
든든학자금 24
 
3.2%
은행대출보증 24
 
3.2%
일반학자금 24
 
3.2%
특별상환유예 24
 
3.2%
현역이자 12
 
1.6%

Length

2024-03-23T06:43:26.779905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
일반상환학자금대출 187
24.6%
정부보증부학자금대출 187
24.6%
취업후상환학자금대출 162
21.3%
특별상환유예대출 64
 
8.4%
군복무이자유예대출 42
 
5.5%
든든학자금 24
 
3.2%
은행대출보증 24
 
3.2%
일반학자금 24
 
3.2%
특별상환유예 24
 
3.2%
현역이자 12
 
1.6%

약정승인금액
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct338
Distinct (%)100.0%
Missing423
Missing (%)55.6%
Infinite0
Infinite (%)0.0%
Mean40532061
Minimum170024
Maximum2.5130182 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.8 KiB
2024-03-23T06:43:27.300305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum170024
5-th percentile1644295.7
Q19254246.8
median29999652
Q359175369
95-th percentile1.1634566 × 108
Maximum2.5130182 × 108
Range2.5113179 × 108
Interquartile range (IQR)49921122

Descriptive statistics

Standard deviation39111540
Coefficient of variation (CV)0.96495316
Kurtosis2.6902595
Mean40532061
Median Absolute Deviation (MAD)22461336
Skewness1.4396069
Sum1.3699837 × 1010
Variance1.5297126 × 1015
MonotonicityNot monotonic
2024-03-23T06:43:28.024185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
89076999 1
 
0.1%
11383642 1
 
0.1%
90067847 1
 
0.1%
18243874 1
 
0.1%
38052445 1
 
0.1%
29936528 1
 
0.1%
6639490 1
 
0.1%
1777408 1
 
0.1%
74339939 1
 
0.1%
24636655 1
 
0.1%
Other values (328) 328
43.1%
(Missing) 423
55.6%
ValueCountFrequency (%)
170024 1
0.1%
262569 1
0.1%
486681 1
0.1%
512238 1
0.1%
559197 1
0.1%
681281 1
0.1%
694995 1
0.1%
731431 1
0.1%
905398 1
0.1%
1053541 1
0.1%
ValueCountFrequency (%)
251301818 1
0.1%
182446112 1
0.1%
164566757 1
0.1%
152899224 1
0.1%
148276387 1
0.1%
145510103 1
0.1%
140299011 1
0.1%
139374839 1
0.1%
137409453 1
0.1%
136831510 1
0.1%

약정승인건수
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct26
Distinct (%)7.7%
Missing423
Missing (%)55.6%
Infinite0
Infinite (%)0.0%
Mean6.7899408
Minimum1
Maximum36
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.8 KiB
2024-03-23T06:43:28.528039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median5
Q310
95-th percentile17
Maximum36
Range35
Interquartile range (IQR)8

Descriptive statistics

Standard deviation5.9603253
Coefficient of variation (CV)0.87781697
Kurtosis1.7117434
Mean6.7899408
Median Absolute Deviation (MAD)4
Skewness1.2164985
Sum2295
Variance35.525477
MonotonicityNot monotonic
2024-03-23T06:43:29.284492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
1 83
 
10.9%
2 30
 
3.9%
3 23
 
3.0%
4 20
 
2.6%
6 20
 
2.6%
7 19
 
2.5%
5 17
 
2.2%
10 16
 
2.1%
8 14
 
1.8%
12 13
 
1.7%
Other values (16) 83
 
10.9%
(Missing) 423
55.6%
ValueCountFrequency (%)
1 83
10.9%
2 30
 
3.9%
3 23
 
3.0%
4 20
 
2.6%
5 17
 
2.2%
6 20
 
2.6%
7 19
 
2.5%
8 14
 
1.8%
9 13
 
1.7%
10 16
 
2.1%
ValueCountFrequency (%)
36 1
 
0.1%
27 1
 
0.1%
26 1
 
0.1%
25 2
 
0.3%
24 1
 
0.1%
23 1
 
0.1%
21 2
 
0.3%
20 2
 
0.3%
18 5
0.7%
17 8
1.1%

약정유지건수
Real number (ℝ)

HIGH CORRELATION 

Distinct282
Distinct (%)37.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean207.5703
Minimum1
Maximum1443
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.8 KiB
2024-03-23T06:43:29.840131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median12
Q3296
95-th percentile1096
Maximum1443
Range1442
Interquartile range (IQR)293

Descriptive statistics

Standard deviation353.28329
Coefficient of variation (CV)1.7019934
Kurtosis2.737724
Mean207.5703
Median Absolute Deviation (MAD)11
Skewness1.8882489
Sum157961
Variance124809.08
MonotonicityNot monotonic
2024-03-23T06:43:30.520424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 135
 
17.7%
3 66
 
8.7%
2 48
 
6.3%
9 43
 
5.7%
8 28
 
3.7%
4 15
 
2.0%
6 15
 
2.0%
7 12
 
1.6%
34 12
 
1.6%
11 10
 
1.3%
Other values (272) 377
49.5%
ValueCountFrequency (%)
1 135
17.7%
2 48
 
6.3%
3 66
8.7%
4 15
 
2.0%
5 4
 
0.5%
6 15
 
2.0%
7 12
 
1.6%
8 28
 
3.7%
9 43
 
5.7%
10 1
 
0.1%
ValueCountFrequency (%)
1443 1
0.1%
1436 1
0.1%
1427 1
0.1%
1423 1
0.1%
1416 1
0.1%
1411 1
0.1%
1408 1
0.1%
1396 1
0.1%
1392 1
0.1%
1388 1
0.1%

Interactions

2024-03-23T06:43:18.448254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:11.345611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:13.197592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:14.996596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:16.830484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:18.756753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:11.726471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:13.542080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:15.305062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:17.124722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:19.099837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:12.112261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:13.825913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:15.734564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:17.384305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:19.455413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:12.430908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:14.154329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:16.052316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:17.681154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:19.879645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:12.824983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:14.611014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:16.407537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:43:18.098752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T06:43:30.903127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약정구분약정연도약정월상품명약정승인금액약정승인건수약정유지건수
약정구분1.0000.3180.0000.2510.3110.5630.625
약정연도0.3181.0000.0000.6470.2740.2470.769
약정월0.0000.0001.0000.0000.0000.0710.000
상품명0.2510.6470.0001.0000.4000.3090.575
약정승인금액0.3110.2740.0000.4001.0000.9310.490
약정승인건수0.5630.2470.0710.3090.9311.0000.499
약정유지건수0.6250.7690.0000.5750.4900.4991.000
2024-03-23T06:43:31.424305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상품명약정구분
상품명1.0000.239
약정구분0.2391.000
2024-03-23T06:43:31.858224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약정연도약정월약정승인금액약정승인건수약정유지건수약정구분상품명
약정연도1.000-0.045-0.291-0.342-0.0920.2530.344
약정월-0.0451.000-0.0050.003-0.0150.0000.000
약정승인금액-0.291-0.0051.0000.8880.4370.3050.139
약정승인건수-0.3420.0030.8881.0000.5400.5610.094
약정유지건수-0.092-0.0150.4370.5401.0000.4820.288
약정구분0.2530.0000.3050.5610.4821.0000.239
상품명0.3440.0000.1390.0940.2880.2391.000

Missing values

2024-03-23T06:43:20.351546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T06:43:21.054760image/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.
2024-03-23T06:43:21.896335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

약정구분약정연도약정월상품명약정승인금액약정승인건수약정유지건수
0사회적배려계층20139일반상환학자금대출285097411
1사회적배려계층201310정부보증부학자금대출775658201515
2사회적배려계층201310일반상환학자금대출5192598889
3사회적배려계층201311정부보증부학자금대출24850380419
4사회적배려계층201311일반상환학자금대출33991575615
5사회적배려계층201312정부보증부학자금대출39341690726
6사회적배려계층201312일반상환학자금대출21114357520
7사회적배려계층20141정부보증부학자금대출17716480329
8사회적배려계층20141일반상환학자금대출18261092424
9사회적배려계층20142정부보증부학자금대출36368730635
약정구분약정연도약정월상품명약정승인금액약정승인건수약정유지건수
751중소기업202310일반학자금181617081100
752중소기업202310특별상환유예<NA><NA>1
753중소기업202311든든학자금<NA><NA>3
754중소기업202311은행대출보증<NA><NA>37
755중소기업202311일반학자금36172741101
756중소기업202311특별상환유예<NA><NA>1
757중소기업202312든든학자금<NA><NA>3
758중소기업202312은행대출보증<NA><NA>37
759중소기업202312일반학자금366446021102
760중소기업202312특별상환유예<NA><NA>1