Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 1000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 66.5 KiB |
Average record size in memory | 68.1 B |
Variable types
Categorical | 3 |
---|---|
Numeric | 3 |
Boolean | 1 |
DateTime | 1 |
Dataset
Description | MBS 배당수익계산가중편균정보에 대한 데이터로, 유동화계획코드, 가중편균금리(금융기관), 일치여부, 등록사번 등의 항목을 제공합니다. |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073183/fileData.do |
LIQD_PLAN_CD is highly overall correlated with HF_WA_RAT and 2 other fields | High correlation |
LOAN_ORG_CD is highly overall correlated with HF_WA_RAT and 2 other fields | High correlation |
BASIS_DY is highly overall correlated with REG_ENO | High correlation |
HF_WA_RAT is highly overall correlated with FI_WA_RAT and 2 other fields | High correlation |
FI_WA_RAT is highly overall correlated with HF_WA_RAT and 2 other fields | High correlation |
REG_ENO is highly overall correlated with BASIS_DY | High correlation |
SAME_YN is highly imbalanced (98.9%) | Imbalance |
Reproduction
Analysis started | 2023-12-12 05:18:53.830120 |
---|---|
Analysis finished | 2023-12-12 05:18:55.603785 |
Duration | 1.77 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
LOAN_ORG_CD
Categorical
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
I004 | |
---|---|
I001 | |
I003 | |
F001 | |
F002 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | I003 |
---|---|
2nd row | I003 |
3rd row | F001 |
4th row | F001 |
5th row | I003 |
Common Values
Value | Count | Frequency (%) |
I004 | 437 | |
I001 | 282 | |
I003 | 107 | 10.7% |
F001 | 87 | 8.7% |
F002 | 58 | 5.8% |
F003 | 29 | 2.9% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
i004 | 437 | |
i001 | 282 | |
i003 | 107 | 10.7% |
f001 | 87 | 8.7% |
f002 | 58 | 5.8% |
f003 | 29 | 2.9% |
LIQD_PLAN_CD
Categorical
HIGH CORRELATION
 
Distinct | 36 |
---|---|
Distinct (%) | 3.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2013S-24 | 29 |
---|---|
KHFCMB2016S-02 | 29 |
KHFCMB2016S-18 | 29 |
KHFCMB2012S-36 | 29 |
KHFCMB2012S-12 | 29 |
Other values (31) |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2019S-01 |
---|---|
2nd row | KHFCMB2013S-33 |
3rd row | KHFCMB2012S-36 |
4th row | KHFCMB2012S-12 |
5th row | KHFCMB2017S-24 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2013S-24 | 29 | 2.9% |
KHFCMB2016S-02 | 29 | 2.9% |
KHFCMB2016S-18 | 29 | 2.9% |
KHFCMB2012S-36 | 29 | 2.9% |
KHFCMB2012S-12 | 29 | 2.9% |
KHFCMB2017S-24 | 29 | 2.9% |
KHFCMB2013S-11 | 29 | 2.9% |
KHFCMB2014S-04 | 29 | 2.9% |
KHFCMB2013S-13 | 29 | 2.9% |
KHFCMB2012S-27 | 29 | 2.9% |
Other values (26) | 710 |
Length
Value | Count | Frequency (%) |
khfcmb2013s-24 | 29 | 2.9% |
khfcmb2013s-12 | 29 | 2.9% |
khfcmb2013s-38 | 29 | 2.9% |
khfcmb2017s-06 | 29 | 2.9% |
khfcmb2017s-21 | 29 | 2.9% |
khfcmb2018s-07 | 29 | 2.9% |
khfcmb2015s-19 | 29 | 2.9% |
khfcmb2015s-08 | 29 | 2.9% |
khfcmb2016s-02 | 29 | 2.9% |
khfcmb2014s-22 | 29 | 2.9% |
Other values (26) | 710 |
BASIS_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 44 |
---|---|
Distinct (%) | 4.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20191328 |
Minimum | 20180501 |
---|---|
Maximum | 20200901 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180501 |
---|---|
5-th percentile | 20180601 |
Q1 | 20181203 |
median | 20190701 |
Q3 | 20200301 |
95-th percentile | 20200803 |
Maximum | 20200901 |
Range | 20400 |
Interquartile range (IQR) | 19098 |
Descriptive statistics
Standard deviation | 7465.8597 |
---|---|
Coefficient of variation (CV) | 0.00036975575 |
Kurtosis | -1.2600682 |
Mean | 20191328 |
Median Absolute Deviation (MAD) | 9500 |
Skewness | -0.10701343 |
Sum | 2.0191328 × 1010 |
Variance | 55739061 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20200901 | 36 | 3.6% |
20200701 | 36 | 3.6% |
20200601 | 36 | 3.6% |
20200401 | 36 | 3.6% |
20191001 | 35 | 3.5% |
20190201 | 35 | 3.5% |
20190401 | 35 | 3.5% |
20190701 | 35 | 3.5% |
20190801 | 35 | 3.5% |
20191101 | 35 | 3.5% |
Other values (34) | 646 |
Value | Count | Frequency (%) |
20180501 | 10 | 1.0% |
20180502 | 15 | |
20180601 | 33 | |
20180701 | 18 | |
20180702 | 15 | |
20180801 | 33 | |
20180901 | 18 | |
20180903 | 15 | |
20181001 | 33 | |
20181101 | 33 |
Value | Count | Frequency (%) |
20200901 | 36 | |
20200803 | 18 | |
20200801 | 18 | |
20200701 | 36 | |
20200601 | 36 | |
20200504 | 18 | |
20200501 | 18 | |
20200401 | 36 | |
20200302 | 18 | |
20200301 | 18 |
HF_WA_RAT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 164 |
---|---|
Distinct (%) | 16.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.52423 |
Minimum | 2.36 |
---|---|
Maximum | 4.65 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 2.36 |
---|---|
5-th percentile | 2.7895 |
Q1 | 3.33 |
median | 3.51 |
Q3 | 3.83 |
95-th percentile | 4.2205 |
Maximum | 4.65 |
Range | 2.29 |
Interquartile range (IQR) | 0.5 |
Descriptive statistics
Standard deviation | 0.43068306 |
---|---|
Coefficient of variation (CV) | 0.12220629 |
Kurtosis | 0.69777386 |
Mean | 3.52423 |
Median Absolute Deviation (MAD) | 0.27 |
Skewness | -0.23142287 |
Sum | 3524.23 |
Variance | 0.18548789 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3.52 | 35 | 3.5% |
3.49 | 32 | 3.2% |
3.53 | 29 | 2.9% |
3.4 | 28 | 2.8% |
3.56 | 27 | 2.7% |
3.36 | 26 | 2.6% |
3.57 | 26 | 2.6% |
3.51 | 22 | 2.2% |
3.87 | 21 | 2.1% |
3.48 | 20 | 2.0% |
Other values (154) | 734 |
Value | Count | Frequency (%) |
2.36 | 5 | 0.5% |
2.37 | 17 | |
2.38 | 5 | 0.5% |
2.39 | 2 | 0.2% |
2.42 | 2 | 0.2% |
2.51 | 1 | 0.1% |
2.55 | 3 | 0.3% |
2.56 | 1 | 0.1% |
2.67 | 2 | 0.2% |
2.68 | 3 | 0.3% |
Value | Count | Frequency (%) |
4.65 | 5 | |
4.64 | 3 | |
4.63 | 3 | |
4.62 | 3 | |
4.61 | 1 | 0.1% |
4.59 | 1 | 0.1% |
4.56 | 1 | 0.1% |
4.53 | 1 | 0.1% |
4.48 | 1 | 0.1% |
4.44 | 2 | 0.2% |
FI_WA_RAT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 164 |
---|---|
Distinct (%) | 16.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.52424 |
Minimum | 2.36 |
---|---|
Maximum | 4.65 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 2.36 |
---|---|
5-th percentile | 2.7895 |
Q1 | 3.33 |
median | 3.515 |
Q3 | 3.83 |
95-th percentile | 4.2205 |
Maximum | 4.65 |
Range | 2.29 |
Interquartile range (IQR) | 0.5 |
Descriptive statistics
Standard deviation | 0.43068284 |
---|---|
Coefficient of variation (CV) | 0.12220588 |
Kurtosis | 0.69780283 |
Mean | 3.52424 |
Median Absolute Deviation (MAD) | 0.265 |
Skewness | -0.23149298 |
Sum | 3524.24 |
Variance | 0.18548771 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3.52 | 36 | 3.6% |
3.49 | 32 | 3.2% |
3.53 | 29 | 2.9% |
3.4 | 28 | 2.8% |
3.56 | 27 | 2.7% |
3.36 | 26 | 2.6% |
3.57 | 26 | 2.6% |
3.51 | 21 | 2.1% |
3.87 | 21 | 2.1% |
3.48 | 20 | 2.0% |
Other values (154) | 734 |
Value | Count | Frequency (%) |
2.36 | 5 | 0.5% |
2.37 | 17 | |
2.38 | 5 | 0.5% |
2.39 | 2 | 0.2% |
2.42 | 2 | 0.2% |
2.51 | 1 | 0.1% |
2.55 | 3 | 0.3% |
2.56 | 1 | 0.1% |
2.67 | 2 | 0.2% |
2.68 | 3 | 0.3% |
Value | Count | Frequency (%) |
4.65 | 5 | |
4.64 | 3 | |
4.63 | 3 | |
4.62 | 3 | |
4.61 | 1 | 0.1% |
4.59 | 1 | 0.1% |
4.56 | 1 | 0.1% |
4.53 | 1 | 0.1% |
4.48 | 1 | 0.1% |
4.44 | 2 | 0.2% |
SAME_YN
Boolean
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.1 KiB |
True | |
---|---|
False | 1 |
Value | Count | Frequency (%) |
True | 999 | |
False | 1 | 0.1% |
REG_ENO
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1438 | |
---|---|
1769 | |
1841 | |
1628 | |
1460 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1769 |
---|---|
2nd row | 1769 |
3rd row | 1769 |
4th row | 1769 |
5th row | 1769 |
Common Values
Value | Count | Frequency (%) |
1438 | 308 | |
1769 | 265 | |
1841 | 245 | |
1628 | 124 | |
1460 | 58 | 5.8% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1438 | 308 | |
1769 | 265 | |
1841 | 245 | |
1628 | 124 | |
1460 | 58 | 5.8% |
REG_DT
Date
Distinct | 670 |
---|---|
Distinct (%) | 67.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2018-05-31 10:32:35 |
---|---|
Maximum | 2020-10-13 20:19:27 |
LOAN_ORG_CD | LIQD_PLAN_CD | BASIS_DY | HF_WA_RAT | FI_WA_RAT | SAME_YN | REG_ENO | |
---|---|---|---|---|---|---|---|
LOAN_ORG_CD | 1.000 | 1.000 | 0.000 | 0.758 | 0.758 | 0.000 | 0.000 |
LIQD_PLAN_CD | 1.000 | 1.000 | 0.000 | 0.937 | 0.937 | 0.000 | 0.000 |
BASIS_DY | 0.000 | 0.000 | 1.000 | 0.403 | 0.403 | 0.012 | 0.786 |
HF_WA_RAT | 0.758 | 0.937 | 0.403 | 1.000 | 1.000 | 0.000 | 0.399 |
FI_WA_RAT | 0.758 | 0.937 | 0.403 | 1.000 | 1.000 | 0.000 | 0.399 |
SAME_YN | 0.000 | 0.000 | 0.012 | 0.000 | 0.000 | 1.000 | 0.000 |
REG_ENO | 0.000 | 0.000 | 0.786 | 0.399 | 0.399 | 0.000 | 1.000 |
LIQD_PLAN_CD | LOAN_ORG_CD | SAME_YN | REG_ENO | |
---|---|---|---|---|
LIQD_PLAN_CD | 1.000 | 0.985 | 0.000 | 0.000 |
LOAN_ORG_CD | 0.985 | 1.000 | 0.000 | 0.000 |
SAME_YN | 0.000 | 0.000 | 1.000 | 0.000 |
REG_ENO | 0.000 | 0.000 | 0.000 | 1.000 |
BASIS_DY | HF_WA_RAT | FI_WA_RAT | LOAN_ORG_CD | LIQD_PLAN_CD | SAME_YN | REG_ENO | |
---|---|---|---|---|---|---|---|
BASIS_DY | 1.000 | -0.208 | -0.209 | 0.000 | 0.000 | 0.010 | 0.743 |
HF_WA_RAT | -0.208 | 1.000 | 1.000 | 0.530 | 0.682 | 0.000 | 0.176 |
FI_WA_RAT | -0.209 | 1.000 | 1.000 | 0.530 | 0.682 | 0.000 | 0.176 |
LOAN_ORG_CD | 0.000 | 0.530 | 0.530 | 1.000 | 0.985 | 0.000 | 0.000 |
LIQD_PLAN_CD | 0.000 | 0.682 | 0.682 | 0.985 | 1.000 | 0.000 | 0.000 |
SAME_YN | 0.010 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 |
REG_ENO | 0.743 | 0.176 | 0.176 | 0.000 | 0.000 | 0.000 | 1.000 |
LOAN_ORG_CD | LIQD_PLAN_CD | BASIS_DY | HF_WA_RAT | FI_WA_RAT | SAME_YN | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|
0 | I003 | KHFCMB2019S-01 | 20200901 | 3.86 | 3.86 | Y | 1769 | 2020/10/13 20:19:27 |
1 | I003 | KHFCMB2013S-33 | 20200901 | 3.51 | 3.51 | Y | 1769 | 2020/10/13 20:19:27 |
2 | F001 | KHFCMB2012S-36 | 20200901 | 2.75 | 2.75 | Y | 1769 | 2020/10/13 20:09:11 |
3 | F001 | KHFCMB2012S-12 | 20200901 | 3.09 | 3.09 | Y | 1769 | 2020/10/13 20:09:11 |
4 | I003 | KHFCMB2017S-24 | 20200901 | 3.78 | 3.78 | Y | 1769 | 2020/10/13 20:19:27 |
5 | I003 | KHFCMB2013S-11 | 20200901 | 3.09 | 3.09 | Y | 1769 | 2020/10/13 20:19:27 |
6 | F001 | KHFCMB2014S-04 | 20200901 | 2.99 | 2.99 | Y | 1769 | 2020/10/13 20:09:11 |
7 | F002 | KHFCMB2013S-12 | 20200901 | 2.39 | 2.39 | Y | 1769 | 2020/10/13 16:01:40 |
8 | F002 | KHFCMB2012S-27 | 20200901 | 2.42 | 2.42 | Y | 1769 | 2020/10/13 16:01:40 |
9 | I001 | KHFCMB2013S-10 | 20200901 | 3.24 | 3.24 | Y | 1769 | 2020/10/13 15:44:24 |
LOAN_ORG_CD | LIQD_PLAN_CD | BASIS_DY | HF_WA_RAT | FI_WA_RAT | SAME_YN | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|
990 | I004 | KHFCMB2013S-13 | 20180501 | 3.6 | 3.6 | Y | 1460 | 2018/05/31 10:39:18 |
991 | I004 | KHFCMB2012S-38 | 20180501 | 4.25 | 4.25 | Y | 1460 | 2018/05/31 10:39:18 |
992 | I004 | KHFCMB2012S-26 | 20180501 | 4.62 | 4.62 | Y | 1460 | 2018/05/31 10:39:17 |
993 | F002 | KHFCMB2013S-12 | 20180501 | 2.36 | 2.36 | Y | 1460 | 2018/05/31 10:38:20 |
994 | F002 | KHFCMB2012S-27 | 20180501 | 2.76 | 2.76 | Y | 1460 | 2018/05/31 10:38:20 |
995 | F001 | KHFCMB2014S-04 | 20180502 | 3.54 | 3.54 | Y | 1460 | 2018/05/31 10:33:52 |
996 | F001 | KHFCMB2012S-36 | 20180501 | 3.49 | 3.49 | Y | 1460 | 2018/05/31 10:33:44 |
997 | F001 | KHFCMB2012S-12 | 20180501 | 3.68 | 3.68 | Y | 1460 | 2018/05/31 10:33:44 |
998 | I001 | KHFCMB2013S-10 | 20180501 | 3.28 | 3.28 | Y | 1460 | 2018/05/31 10:32:36 |
999 | I001 | KHFCMB2012S-37 | 20180501 | 3.3 | 3.3 | Y | 1460 | 2018/05/31 10:32:35 |