Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 354 |
Missing cells | 101 |
Missing cells (%) | 4.1% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 21.6 KiB |
Average record size in memory | 62.4 B |
Variable types
Text | 1 |
---|---|
Numeric | 6 |
Dataset
Description | 한국주택금융공사에서 발행한 MBS 기초자산 상환 및 연체현황에 대한 공공데이터 자료입니다. 공공데이터 개방정책에 따라 등록되었습니다. |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073662/fileData.do |
전월대출잔액 is highly overall correlated with 조기상환액 and 3 other fields | High correlation |
조기상환액 is highly overall correlated with 전월대출잔액 and 3 other fields | High correlation |
기준월 대출잔액 is highly overall correlated with 전월대출잔액 and 3 other fields | High correlation |
연체금액 is highly overall correlated with 전월대출잔액 and 2 other fields | High correlation |
연체율 is highly overall correlated with 전월대출잔액 and 2 other fields | High correlation |
전월대출잔액 has 18 (5.1%) missing values | Missing |
조기상환액 has 34 (9.6%) missing values | Missing |
기준월 대출잔액 has 18 (5.1%) missing values | Missing |
연체금액 has 31 (8.8%) missing values | Missing |
상품명 has unique values | Unique |
조기상환율(퍼센트) has 34 (9.6%) zeros | Zeros |
연체율 has 31 (8.8%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 21:23:19.992265 |
---|---|
Analysis finished | 2023-12-12 21:23:24.240668 |
Duration | 4.25 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
상품명
Text
UNIQUE
 
Distinct | 354 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.9 KiB |
Length
Max length | 11 |
---|---|
Median length | 11 |
Mean length | 10.675141 |
Min length | 10 |
Characters and Unicode
Total characters | 3779 |
---|---|
Distinct characters | 14 |
Distinct categories | 3 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 354 ? |
---|---|
Unique (%) | 100.0% |
Sample
1st row | MBS 2004 1 |
---|---|
2nd row | MBS 2004 2 |
3rd row | MBS 2004 3 |
4th row | MBS 2004 4 |
5th row | MBS 2004 5 |
Value | Count | Frequency (%) |
mbs | 354 | |
2012 | 41 | 3.9% |
2013 | 38 | 3.6% |
2018 | 31 | 2.9% |
2017 | 30 | 2.8% |
2016 | 29 | 2.7% |
2019 | 28 | 2.6% |
2015 | 28 | 2.6% |
2014 | 22 | 2.1% |
2011 | 21 | 2.0% |
Other values (58) | 440 |
Most occurring characters
Value | Count | Frequency (%) |
708 | ||
2 | 530 | |
0 | 494 | |
1 | 463 | |
M | 354 | |
B | 354 | |
S | 354 | |
3 | 97 | 2.6% |
5 | 74 | 2.0% |
8 | 71 | 1.9% |
Other values (4) | 280 | 7.4% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 2009 | |
Uppercase Letter | 1062 | |
Space Separator | 708 | 18.7% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
2 | 530 | |
0 | 494 | |
1 | 463 | |
3 | 97 | 4.8% |
5 | 74 | 3.7% |
8 | 71 | 3.5% |
4 | 70 | 3.5% |
6 | 70 | 3.5% |
7 | 70 | 3.5% |
9 | 70 | 3.5% |
Uppercase Letter
Value | Count | Frequency (%) |
M | 354 | |
B | 354 | |
S | 354 |
Space Separator
Value | Count | Frequency (%) |
708 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2717 | |
Latin | 1062 | 28.1% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
708 | ||
2 | 530 | |
0 | 494 | |
1 | 463 | |
3 | 97 | 3.6% |
5 | 74 | 2.7% |
8 | 71 | 2.6% |
4 | 70 | 2.6% |
6 | 70 | 2.6% |
7 | 70 | 2.6% |
Latin
Value | Count | Frequency (%) |
M | 354 | |
B | 354 | |
S | 354 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 3779 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
708 | ||
2 | 530 | |
0 | 494 | |
1 | 463 | |
M | 354 | |
B | 354 | |
S | 354 | |
3 | 97 | 2.6% |
5 | 74 | 2.0% |
8 | 71 | 1.9% |
Other values (4) | 280 | 7.4% |
전월대출잔액
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 335 |
---|---|
Distinct (%) | 99.7% |
Missing | 18 |
Missing (%) | 5.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 391930.73 |
Minimum | 481 |
---|---|
Maximum | 3271402 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 481 |
---|---|
5-th percentile | 1584.75 |
Q1 | 17464.5 |
median | 99148.5 |
Q3 | 650330.75 |
95-th percentile | 1495421.5 |
Maximum | 3271402 |
Range | 3270921 |
Interquartile range (IQR) | 632866.25 |
Descriptive statistics
Standard deviation | 528518.81 |
---|---|
Coefficient of variation (CV) | 1.3485006 |
Kurtosis | 4.7070273 |
Mean | 391930.73 |
Median Absolute Deviation (MAD) | 97797.5 |
Skewness | 1.9315677 |
Sum | 1.3168873 × 108 |
Variance | 2.7933214 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2493 | 2 | 0.6% |
879893 | 1 | 0.3% |
717714 | 1 | 0.3% |
974052 | 1 | 0.3% |
1033910 | 1 | 0.3% |
1019197 | 1 | 0.3% |
903884 | 1 | 0.3% |
306065 | 1 | 0.3% |
512847 | 1 | 0.3% |
605538 | 1 | 0.3% |
Other values (325) | 325 | |
(Missing) | 18 | 5.1% |
Value | Count | Frequency (%) |
481 | 1 | |
844 | 1 | |
909 | 1 | |
938 | 1 | |
968 | 1 | |
975 | 1 | |
1004 | 1 | |
1020 | 1 | |
1023 | 1 | |
1059 | 1 |
Value | Count | Frequency (%) |
3271402 | 1 | |
2911065 | 1 | |
2193355 | 1 | |
2162247 | 1 | |
1985207 | 1 | |
1930132 | 1 | |
1929739 | 1 | |
1891572 | 1 | |
1883499 | 1 | |
1865125 | 1 |
조기상환액
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 310 |
---|---|
Distinct (%) | 96.9% |
Missing | 34 |
Missing (%) | 9.6% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5794.0437 |
Minimum | 0 |
---|---|
Maximum | 32483 |
Zeros | 1 |
Zeros (%) | 0.3% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 23.75 |
Q1 | 430.5 |
median | 2421.5 |
Q3 | 9970.5 |
95-th percentile | 19956.95 |
Maximum | 32483 |
Range | 32483 |
Interquartile range (IQR) | 9540 |
Descriptive statistics
Standard deviation | 6736.0858 |
---|---|
Coefficient of variation (CV) | 1.162588 |
Kurtosis | 1.0162055 |
Mean | 5794.0437 |
Median Absolute Deviation (MAD) | 2361.5 |
Skewness | 1.2656469 |
Sum | 1854094 |
Variance | 45374852 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
25 | 4 | 1.1% |
1361 | 2 | 0.6% |
160 | 2 | 0.6% |
75 | 2 | 0.6% |
5 | 2 | 0.6% |
1 | 2 | 0.6% |
122 | 2 | 0.6% |
10 | 2 | 0.6% |
15072 | 1 | 0.3% |
13809 | 1 | 0.3% |
Other values (300) | 300 | |
(Missing) | 34 | 9.6% |
Value | Count | Frequency (%) |
0 | 1 | |
1 | 2 | |
2 | 1 | |
3 | 1 | |
4 | 1 | |
5 | 2 | |
9 | 1 | |
10 | 2 | |
11 | 1 | |
13 | 1 |
Value | Count | Frequency (%) |
32483 | 1 | |
28821 | 1 | |
25334 | 1 | |
24392 | 1 | |
24192 | 1 | |
24137 | 1 | |
24098 | 1 | |
23683 | 1 | |
23450 | 1 | |
23251 | 1 |
조기상환율(퍼센트)
Real number (ℝ)
ZEROS
 
Distinct | 213 |
---|---|
Distinct (%) | 60.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.744548 |
Minimum | 0 |
---|---|
Maximum | 14.09 |
Zeros | 34 |
Zeros (%) | 9.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0.75 |
median | 1.73 |
Q3 | 2.4 |
95-th percentile | 3.452 |
Maximum | 14.09 |
Range | 14.09 |
Interquartile range (IQR) | 1.65 |
Descriptive statistics
Standard deviation | 1.3559774 |
---|---|
Coefficient of variation (CV) | 0.77726574 |
Kurtosis | 19.53341 |
Mean | 1.744548 |
Median Absolute Deviation (MAD) | 0.805 |
Skewness | 2.6365637 |
Sum | 617.57 |
Variance | 1.8386747 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 34 | 9.6% |
2.4 | 4 | 1.1% |
1.3 | 4 | 1.1% |
1.46 | 3 | 0.8% |
2.39 | 3 | 0.8% |
2.18 | 3 | 0.8% |
2.9 | 3 | 0.8% |
0.69 | 3 | 0.8% |
2.65 | 3 | 0.8% |
1.87 | 3 | 0.8% |
Other values (203) | 291 |
Value | Count | Frequency (%) |
0.0 | 34 | |
0.01 | 1 | 0.3% |
0.03 | 1 | 0.3% |
0.09 | 1 | 0.3% |
0.14 | 1 | 0.3% |
0.16 | 1 | 0.3% |
0.17 | 1 | 0.3% |
0.19 | 2 | 0.6% |
0.23 | 1 | 0.3% |
0.26 | 2 | 0.6% |
Value | Count | Frequency (%) |
14.09 | 1 | |
6.83 | 1 | |
6.69 | 1 | |
5.9 | 1 | |
5.64 | 1 | |
5.61 | 1 | |
5.13 | 1 | |
4.95 | 1 | |
4.77 | 1 | |
4.32 | 1 |
기준월 대출잔액
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 336 |
---|---|
Distinct (%) | 100.0% |
Missing | 18 |
Missing (%) | 5.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 385008.77 |
Minimum | 475 |
---|---|
Maximum | 3245437 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 475 |
---|---|
5-th percentile | 1517.5 |
Q1 | 16645.5 |
median | 96582.5 |
Q3 | 632553.25 |
95-th percentile | 1483607 |
Maximum | 3245437 |
Range | 3244962 |
Interquartile range (IQR) | 615907.75 |
Descriptive statistics
Standard deviation | 521662.99 |
---|---|
Coefficient of variation (CV) | 1.3549379 |
Kurtosis | 4.8445843 |
Mean | 385008.77 |
Median Absolute Deviation (MAD) | 95249 |
Skewness | 1.9548306 |
Sum | 1.2936295 × 108 |
Variance | 2.7213228 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
863049 | 1 | 0.3% |
704013 | 1 | 0.3% |
954707 | 1 | 0.3% |
1015777 | 1 | 0.3% |
1001261 | 1 | 0.3% |
885668 | 1 | 0.3% |
299753 | 1 | 0.3% |
503436 | 1 | 0.3% |
595173 | 1 | 0.3% |
155050 | 1 | 0.3% |
Other values (326) | 326 | |
(Missing) | 18 | 5.1% |
Value | Count | Frequency (%) |
475 | 1 | |
839 | 1 | |
875 | 1 | |
931 | 1 | |
962 | 1 | |
970 | 1 | |
974 | 1 | |
977 | 1 | |
980 | 1 | |
1016 | 1 |
Value | Count | Frequency (%) |
3245437 | 1 | |
2892010 | 1 | |
2178289 | 1 | |
2145207 | 1 | |
1966745 | 1 | |
1897013 | 1 | |
1895445 | 1 | |
1858429 | 1 | |
1851011 | 1 | |
1832877 | 1 |
연체금액
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 300 |
---|---|
Distinct (%) | 92.9% |
Missing | 31 |
Missing (%) | 8.8% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1189.743 |
Minimum | 2 |
---|---|
Maximum | 14327 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 2 |
---|---|
5-th percentile | 33.1 |
Q1 | 277 |
median | 791 |
Q3 | 1702 |
95-th percentile | 3709.1 |
Maximum | 14327 |
Range | 14325 |
Interquartile range (IQR) | 1425 |
Descriptive statistics
Standard deviation | 1362.5487 |
---|---|
Coefficient of variation (CV) | 1.1452462 |
Kurtosis | 26.589065 |
Mean | 1189.743 |
Median Absolute Deviation (MAD) | 588 |
Skewness | 3.5970514 |
Sum | 384287 |
Variance | 1856538.9 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2 | 3 | 0.8% |
84 | 3 | 0.8% |
323 | 2 | 0.6% |
1110 | 2 | 0.6% |
398 | 2 | 0.6% |
641 | 2 | 0.6% |
215 | 2 | 0.6% |
1454 | 2 | 0.6% |
468 | 2 | 0.6% |
144 | 2 | 0.6% |
Other values (290) | 301 | |
(Missing) | 31 | 8.8% |
Value | Count | Frequency (%) |
2 | 3 | |
5 | 1 | 0.3% |
6 | 1 | 0.3% |
10 | 1 | 0.3% |
12 | 1 | 0.3% |
13 | 2 | |
18 | 1 | 0.3% |
21 | 1 | 0.3% |
24 | 1 | 0.3% |
25 | 1 | 0.3% |
Value | Count | Frequency (%) |
14327 | 1 | |
5153 | 1 | |
5137 | 1 | |
5027 | 1 | |
4792 | 1 | |
4760 | 1 | |
4656 | 1 | |
4651 | 1 | |
4425 | 1 | |
4401 | 1 |
연체율
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 186 |
---|---|
Distinct (%) | 52.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.3601695 |
Minimum | 0 |
---|---|
Maximum | 51.28 |
Zeros | 31 |
Zeros (%) | 8.8% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0.1825 |
median | 0.54 |
Q3 | 1.7775 |
95-th percentile | 8.505 |
Maximum | 51.28 |
Range | 51.28 |
Interquartile range (IQR) | 1.595 |
Descriptive statistics
Standard deviation | 5.7172014 |
---|---|
Coefficient of variation (CV) | 2.422369 |
Kurtosis | 33.191663 |
Mean | 2.3601695 |
Median Absolute Deviation (MAD) | 0.495 |
Skewness | 5.2303682 |
Sum | 835.5 |
Variance | 32.686392 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 31 | 8.8% |
0.02 | 7 | 2.0% |
0.01 | 7 | 2.0% |
0.14 | 7 | 2.0% |
0.21 | 6 | 1.7% |
0.08 | 6 | 1.7% |
0.2 | 6 | 1.7% |
0.4 | 5 | 1.4% |
0.62 | 5 | 1.4% |
0.32 | 5 | 1.4% |
Other values (176) | 269 |
Value | Count | Frequency (%) |
0.0 | 31 | |
0.01 | 7 | 2.0% |
0.02 | 7 | 2.0% |
0.03 | 3 | 0.8% |
0.04 | 4 | 1.1% |
0.05 | 3 | 0.8% |
0.06 | 3 | 0.8% |
0.07 | 3 | 0.8% |
0.08 | 6 | 1.7% |
0.1 | 4 | 1.1% |
Value | Count | Frequency (%) |
51.28 | 1 | |
47.21 | 1 | |
37.61 | 1 | |
29.35 | 1 | |
29.3 | 1 | |
28.23 | 1 | |
22.37 | 1 | |
21.28 | 1 | |
19.81 | 1 | |
18.51 | 1 |
전월대출잔액 | 조기상환액 | 조기상환율(퍼센트) | 기준월 대출잔액 | 연체금액 | 연체율 | |
---|---|---|---|---|---|---|
전월대출잔액 | 1.000 | 0.723 | 0.310 | 1.000 | 0.532 | 0.000 |
조기상환액 | 0.723 | 1.000 | 0.226 | 0.723 | 0.919 | 0.000 |
조기상환율(퍼센트) | 0.310 | 0.226 | 1.000 | 0.310 | 0.126 | 0.000 |
기준월 대출잔액 | 1.000 | 0.723 | 0.310 | 1.000 | 0.532 | 0.000 |
연체금액 | 0.532 | 0.919 | 0.126 | 0.532 | 1.000 | 0.000 |
연체율 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
전월대출잔액 | 조기상환액 | 조기상환율(퍼센트) | 기준월 대출잔액 | 연체금액 | 연체율 | |
---|---|---|---|---|---|---|
전월대출잔액 | 1.000 | 0.922 | -0.034 | 1.000 | 0.609 | -0.679 |
조기상환액 | 0.922 | 1.000 | 0.100 | 0.920 | 0.700 | -0.596 |
조기상환율(퍼센트) | -0.034 | 0.100 | 1.000 | -0.038 | 0.189 | 0.319 |
기준월 대출잔액 | 1.000 | 0.920 | -0.038 | 1.000 | 0.608 | -0.680 |
연체금액 | 0.609 | 0.700 | 0.189 | 0.608 | 1.000 | -0.115 |
연체율 | -0.679 | -0.596 | 0.319 | -0.680 | -0.115 | 1.000 |
상품명 | 전월대출잔액 | 조기상환액 | 조기상환율(퍼센트) | 기준월 대출잔액 | 연체금액 | 연체율 | |
---|---|---|---|---|---|---|---|
0 | MBS 2004 1 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
1 | MBS 2004 2 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
2 | MBS 2004 3 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
3 | MBS 2004 4 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
4 | MBS 2004 5 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
5 | MBS 2004 6 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
6 | MBS 2004 7 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
7 | MBS 2005 1 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
8 | MBS 2005 2 | 3032 | 9 | 0.3 | 3001 | 1417 | 47.21 |
9 | MBS 2005 3 | 2372 | 25 | 1.06 | 2305 | 457 | 19.81 |
상품명 | 전월대출잔액 | 조기상환액 | 조기상환율(퍼센트) | 기준월 대출잔액 | 연체금액 | 연체율 | |
---|---|---|---|---|---|---|---|
344 | MBS 2020 12 | 796423 | 3942 | 0.49 | 790383 | 85 | 0.01 |
345 | MBS 2020 13 | 801280 | 4239 | 0.53 | 794427 | 320 | 0.04 |
346 | MBS 2020 14 | 401509 | 1107 | 0.28 | 399130 | <NA> | 0.0 |
347 | MBS 2020 15 | 852583 | 3612 | 0.42 | 846144 | 637 | 0.08 |
348 | MBS 2020 16 | 497545 | 3421 | 0.69 | 493053 | 144 | 0.03 |
349 | MBS 2020 17 | 1199992 | 3780 | 0.32 | 1191951 | 153 | 0.01 |
350 | MBS 2020 18 | 1314367 | 3547 | 0.27 | 1303159 | 206 | 0.02 |
351 | MBS 2020 19 | 1402552 | 2406 | 0.17 | 1394006 | 515 | 0.04 |
352 | MBS 2020 20 | 1435813 | 2368 | 0.16 | 1427437 | 218 | 0.02 |
353 | MBS 2020 21 | 857678 | 2880 | 0.34 | 852705 | 390 | 0.05 |