Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 346 |
Missing cells | 69 |
Missing cells (%) | 2.8% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 21.1 KiB |
Average record size in memory | 62.4 B |
Variable types
Text | 1 |
---|---|
Numeric | 6 |
Dataset
Description | 한국주택금융공사에서 발행한 주택저당채권담보부채권(MBB) 현황에 대한 데이터입니다. 상품명,전월대출잔액, 조기상환액 ,조기상환율(퍼센트),기준월 대출잔액,연체금액,연체율(퍼센트) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073664/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 10 (2.9%) missing values | Missing |
조기상환액 has 26 (7.5%) missing values | Missing |
기준월 대출잔액 has 10 (2.9%) missing values | Missing |
연체금액 has 23 (6.6%) missing values | Missing |
상품명 has unique values | Unique |
조기상환율(퍼센트) has 26 (7.5%) zeros | Zeros |
연체율(퍼센트) has 23 (6.6%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 13:59:53.010978 |
---|---|
Analysis finished | 2023-12-12 13:59:59.832141 |
Duration | 6.82 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
상품명
Text
UNIQUE
 
Distinct | 346 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.8 KiB |
Length
Max length | 11 |
---|---|
Median length | 11 |
Mean length | 10.690751 |
Min length | 10 |
Characters and Unicode
Total characters | 3699 |
---|---|
Distinct characters | 15 |
Distinct categories | 4 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 346 ? |
---|---|
Unique (%) | 100.0% |
Sample
1st row | MBS 2005-2 |
---|---|
2nd row | MBS 2005-3 |
3rd row | MBS 2005-4 |
4th row | MBS 2005-5 |
5th row | MBS 2005-6 |
Value | Count | Frequency (%) |
mbs | 346 | |
2016-19 | 1 | 0.1% |
2016-27 | 1 | 0.1% |
2016-26 | 1 | 0.1% |
2016-25 | 1 | 0.1% |
2016-24 | 1 | 0.1% |
2016-23 | 1 | 0.1% |
2016-22 | 1 | 0.1% |
2017-05 | 1 | 0.1% |
2016-20 | 1 | 0.1% |
Other values (337) | 337 |
Most occurring characters
Value | Count | Frequency (%) |
2 | 521 | |
0 | 478 | |
1 | 461 | |
M | 346 | |
B | 346 | |
S | 346 | |
346 | ||
- | 346 | |
3 | 96 | 2.6% |
5 | 72 | 1.9% |
Other values (5) | 341 |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 1969 | |
Uppercase Letter | 1038 | |
Space Separator | 346 | 9.4% |
Dash Punctuation | 346 | 9.4% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
2 | 521 | |
0 | 478 | |
1 | 461 | |
3 | 96 | 4.9% |
5 | 72 | 3.7% |
8 | 71 | 3.6% |
9 | 70 | 3.6% |
6 | 69 | 3.5% |
7 | 69 | 3.5% |
4 | 62 | 3.1% |
Uppercase Letter
Value | Count | Frequency (%) |
M | 346 | |
B | 346 | |
S | 346 |
Space Separator
Value | Count | Frequency (%) |
346 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 346 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2661 | |
Latin | 1038 | 28.1% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
2 | 521 | |
0 | 478 | |
1 | 461 | |
346 | ||
- | 346 | |
3 | 96 | 3.6% |
5 | 72 | 2.7% |
8 | 71 | 2.7% |
9 | 70 | 2.6% |
6 | 69 | 2.6% |
Other values (2) | 131 | 4.9% |
Latin
Value | Count | Frequency (%) |
M | 346 | |
B | 346 | |
S | 346 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 3699 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
2 | 521 | |
0 | 478 | |
1 | 461 | |
M | 346 | |
B | 346 | |
S | 346 | |
346 | ||
- | 346 | |
3 | 96 | 2.6% |
5 | 72 | 1.9% |
Other values (5) | 341 |
전월대출잔액
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 335 |
---|---|
Distinct (%) | 99.7% |
Missing | 10 |
Missing (%) | 2.9% |
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) | 10 | 2.9% |
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 | 26 |
Missing (%) | 7.5% |
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.2% |
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) | 26 | 7.5% |
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 (%) | 61.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.7848844 |
Minimum | 0 |
---|---|
Maximum | 14.09 |
Zeros | 26 |
Zeros (%) | 7.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0.825 |
median | 1.77 |
Q3 | 2.415 |
95-th percentile | 3.5 |
Maximum | 14.09 |
Range | 14.09 |
Interquartile range (IQR) | 1.59 |
Descriptive statistics
Standard deviation | 1.3450302 |
---|---|
Coefficient of variation (CV) | 0.75356712 |
Kurtosis | 20.423063 |
Mean | 1.7848844 |
Median Absolute Deviation (MAD) | 0.755 |
Skewness | 2.7248452 |
Sum | 617.57 |
Variance | 1.8091062 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 26 | 7.5% |
2.4 | 4 | 1.2% |
1.3 | 4 | 1.2% |
2.38 | 3 | 0.9% |
2.56 | 3 | 0.9% |
1.87 | 3 | 0.9% |
0.52 | 3 | 0.9% |
2.39 | 3 | 0.9% |
1.81 | 3 | 0.9% |
0.69 | 3 | 0.9% |
Other values (203) | 291 |
Value | Count | Frequency (%) |
0.0 | 26 | |
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 | 10 |
Missing (%) | 2.9% |
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) | 10 | 2.9% |
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 | 23 |
Missing (%) | 6.6% |
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.9% |
84 | 3 | 0.9% |
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) | 23 | 6.6% |
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 (%) | 53.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.4147399 |
Minimum | 0 |
---|---|
Maximum | 51.28 |
Zeros | 23 |
Zeros (%) | 6.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.2 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0.2 |
median | 0.56 |
Q3 | 1.805 |
95-th percentile | 8.625 |
Maximum | 51.28 |
Range | 51.28 |
Interquartile range (IQR) | 1.605 |
Descriptive statistics
Standard deviation | 5.7716707 |
---|---|
Coefficient of variation (CV) | 2.3901832 |
Kurtosis | 32.46653 |
Mean | 2.4147399 |
Median Absolute Deviation (MAD) | 0.5 |
Skewness | 5.1753092 |
Sum | 835.5 |
Variance | 33.312182 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 23 | 6.6% |
0.02 | 7 | 2.0% |
0.14 | 7 | 2.0% |
0.01 | 7 | 2.0% |
0.21 | 6 | 1.7% |
0.2 | 6 | 1.7% |
0.08 | 6 | 1.7% |
0.32 | 5 | 1.4% |
0.24 | 5 | 1.4% |
0.4 | 5 | 1.4% |
Other values (176) | 269 |
Value | Count | Frequency (%) |
0.0 | 23 | |
0.01 | 7 | 2.0% |
0.02 | 7 | 2.0% |
0.03 | 3 | 0.9% |
0.04 | 4 | 1.2% |
0.05 | 3 | 0.9% |
0.06 | 3 | 0.9% |
0.07 | 3 | 0.9% |
0.08 | 6 | 1.7% |
0.1 | 4 | 1.2% |
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.276 |
기준월 대출잔액 | 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.276 | -0.680 | -0.115 | 1.000 |
상품명 | 전월대출잔액 | 조기상환액 | 조기상환율(퍼센트) | 기준월 대출잔액 | 연체금액 | 연체율(퍼센트) | |
---|---|---|---|---|---|---|---|
0 | MBS 2005-2 | 3032 | 9 | 0.3 | 3001 | 1417 | 47.21 |
1 | MBS 2005-3 | 2372 | 25 | 1.06 | 2305 | 457 | 19.81 |
2 | MBS 2005-4 | 1965 | 13 | 0.66 | 1927 | 21 | 1.1 |
3 | MBS 2005-5 | 2096 | 16 | 0.75 | 2062 | 582 | 28.23 |
4 | MBS 2005-6 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
5 | MBS 2005-7 | 2983 | 25 | 0.82 | 2934 | 1104 | 37.61 |
6 | MBS 2005-8 | 2518 | 67 | 2.64 | 2428 | 1245 | 51.28 |
7 | MBS 2005-9 | <NA> | <NA> | 0.0 | <NA> | <NA> | 0.0 |
8 | MBS 2006-1 | 2138 | 25 | 1.18 | 2087 | 295 | 14.11 |
9 | MBS 2006-2 | 2125 | 10 | 0.46 | 2097 | 614 | 29.3 |
상품명 | 전월대출잔액 | 조기상환액 | 조기상환율(퍼센트) | 기준월 대출잔액 | 연체금액 | 연체율(퍼센트) | |
---|---|---|---|---|---|---|---|
336 | MBS 2020-12 | 796423 | 3942 | 0.49 | 790383 | 85 | 0.01 |
337 | MBS 2020-13 | 801280 | 4239 | 0.53 | 794427 | 320 | 0.04 |
338 | MBS 2020-14 | 401509 | 1107 | 0.28 | 399130 | <NA> | 0.0 |
339 | MBS 2020-15 | 852583 | 3612 | 0.42 | 846144 | 637 | 0.08 |
340 | MBS 2020-16 | 497545 | 3421 | 0.69 | 493053 | 144 | 0.03 |
341 | MBS 2020-17 | 1199992 | 3780 | 0.32 | 1191951 | 153 | 0.01 |
342 | MBS 2020-18 | 1314367 | 3547 | 0.27 | 1303159 | 206 | 0.02 |
343 | MBS 2020-19 | 1402552 | 2406 | 0.17 | 1394006 | 515 | 0.04 |
344 | MBS 2020-20 | 1435813 | 2368 | 0.16 | 1427437 | 218 | 0.02 |
345 | MBS 2020-21 | 857678 | 2880 | 0.34 | 852705 | 390 | 0.05 |