Dataset statistics
Number of variables | 15 |
---|---|
Number of observations | 1000 |
Missing cells | 2000 |
Missing cells (%) | 13.3% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 128.1 KiB |
Average record size in memory | 131.1 B |
Variable types
Categorical | 3 |
---|---|
Numeric | 8 |
Unsupported | 2 |
Boolean | 1 |
DateTime | 1 |
Dataset
Description | 유동화변동금리이력(트렌치코드, 유동화계획코드, 시작일자 등) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073168/fileData.do |
CONFM_YN has constant value "" | Constant |
LIQD_PLAN_CD is highly overall correlated with BASIS_RAT and 3 other fields | High correlation |
TRNCH_CD is highly overall correlated with BASIS_RAT and 3 other fields | High correlation |
STRT_DY is highly overall correlated with END_DY and 4 other fields | High correlation |
END_DY is highly overall correlated with STRT_DY and 4 other fields | High correlation |
PAY_DY is highly overall correlated with STRT_DY and 4 other fields | High correlation |
RAT_STRT_DY is highly overall correlated with STRT_DY and 4 other fields | High correlation |
RAT_END_DY is highly overall correlated with STRT_DY and 4 other fields | High correlation |
BASIS_RAT is highly overall correlated with FACE_RAT and 2 other fields | High correlation |
FACE_RAT is highly overall correlated with BASIS_RAT and 2 other fields | High correlation |
IAPPLY_SPREAD_RAT is highly overall correlated with TRNCH_CD and 1 other fields | High correlation |
REG_ENO is highly overall correlated with STRT_DY and 4 other fields | High correlation |
DEBENTURE_BENIF_RAT has 1000 (100.0%) missing values | Missing |
RMK has 1000 (100.0%) missing values | Missing |
DEBENTURE_BENIF_RAT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
RMK is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
Analysis started | 2023-12-12 15:03:55.424898 |
---|---|
Analysis finished | 2023-12-12 15:04:04.681036 |
Duration | 9.26 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
TRNCH_CD
Categorical
HIGH CORRELATION
 
Distinct | 41 |
---|---|
Distinct (%) | 4.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2010S-06-A420-1 | 25 |
---|---|
KHFCMB2013S-13-A420-1 | 25 |
KHFCMB2017S-06-A420-1 | 25 |
KHFCMB2013S-11-A420-1 | 25 |
KHFCMB2014S-04-A420-1 | 25 |
Other values (36) |
Length
Max length | 21 |
---|---|
Median length | 21 |
Mean length | 21 |
Min length | 21 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2019S-01-A420-1 |
---|---|
2nd row | KHFCMB2017S-24-A421-1 |
3rd row | KHFCMB2013S-33-A420-1 |
4th row | KHFCMB2013S-11-A420-1 |
5th row | KHFCMB2014S-04-A420-1 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2010S-06-A420-1 | 25 | 2.5% |
KHFCMB2013S-13-A420-1 | 25 | 2.5% |
KHFCMB2017S-06-A420-1 | 25 | 2.5% |
KHFCMB2013S-11-A420-1 | 25 | 2.5% |
KHFCMB2014S-04-A420-1 | 25 | 2.5% |
KHFCMB2012S-36-A421-1 | 25 | 2.5% |
KHFCMB2012S-12-A420-1 | 25 | 2.5% |
KHFCMB2010S-08-A420-1 | 25 | 2.5% |
KHFCMB2009S-07-A360-1 | 25 | 2.5% |
KHFCMB2011S-20-A421-1 | 25 | 2.5% |
Other values (31) | 750 |
Length
Value | Count | Frequency (%) |
khfcmb2010s-06-a420-1 | 25 | 2.5% |
khfcmb2013s-33-a420-1 | 25 | 2.5% |
khfcmb2013s-13-a420-1 | 25 | 2.5% |
khfcmb2013s-24-a420-1 | 25 | 2.5% |
khfcmb2009s-13-a420-1 | 25 | 2.5% |
khfcmb2012s-26-a420-1 | 25 | 2.5% |
khfcmb2012s-38-a421-1 | 25 | 2.5% |
khfcmb2010s-18-a420-1 | 25 | 2.5% |
khfcmb2017s-21-a421-1 | 25 | 2.5% |
khfcmb2018s-07-a420-1 | 25 | 2.5% |
Other values (31) | 750 |
LIQD_PLAN_CD
Categorical
HIGH CORRELATION
 
Distinct | 41 |
---|---|
Distinct (%) | 4.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2010S-06 | 25 |
---|---|
KHFCMB2013S-13 | 25 |
KHFCMB2017S-06 | 25 |
KHFCMB2013S-11 | 25 |
KHFCMB2014S-04 | 25 |
Other values (36) |
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 | KHFCMB2017S-24 |
3rd row | KHFCMB2013S-33 |
4th row | KHFCMB2013S-11 |
5th row | KHFCMB2014S-04 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2010S-06 | 25 | 2.5% |
KHFCMB2013S-13 | 25 | 2.5% |
KHFCMB2017S-06 | 25 | 2.5% |
KHFCMB2013S-11 | 25 | 2.5% |
KHFCMB2014S-04 | 25 | 2.5% |
KHFCMB2012S-36 | 25 | 2.5% |
KHFCMB2012S-12 | 25 | 2.5% |
KHFCMB2010S-08 | 25 | 2.5% |
KHFCMB2009S-07 | 25 | 2.5% |
KHFCMB2011S-20 | 25 | 2.5% |
Other values (31) | 750 |
Length
Value | Count | Frequency (%) |
khfcmb2010s-06 | 25 | 2.5% |
khfcmb2013s-33 | 25 | 2.5% |
khfcmb2013s-13 | 25 | 2.5% |
khfcmb2013s-24 | 25 | 2.5% |
khfcmb2009s-13 | 25 | 2.5% |
khfcmb2012s-26 | 25 | 2.5% |
khfcmb2012s-38 | 25 | 2.5% |
khfcmb2010s-18 | 25 | 2.5% |
khfcmb2017s-21 | 25 | 2.5% |
khfcmb2018s-07 | 25 | 2.5% |
Other values (31) | 750 |
STRT_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 261 |
---|---|
Distinct (%) | 26.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20192639 |
Minimum | 20180815 |
---|---|
Maximum | 20200930 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180815 |
---|---|
5-th percentile | 20181020 |
Q1 | 20190325 |
median | 20190925 |
Q3 | 20200325 |
95-th percentile | 20200825 |
Maximum | 20200930 |
Range | 20115 |
Interquartile range (IQR) | 10000 |
Descriptive statistics
Standard deviation | 6758.1253 |
---|---|
Coefficient of variation (CV) | 0.00033468262 |
Kurtosis | -0.94347225 |
Mean | 20192639 |
Median Absolute Deviation (MAD) | 9200 |
Skewness | -0.25707565 |
Sum | 2.0192639 × 1010 |
Variance | 45672258 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20200725 | 25 | 2.5% |
20200825 | 25 | 2.5% |
20181225 | 25 | 2.5% |
20200125 | 25 | 2.5% |
20200625 | 25 | 2.5% |
20200325 | 25 | 2.5% |
20190725 | 25 | 2.5% |
20191225 | 25 | 2.5% |
20190825 | 25 | 2.5% |
20190125 | 25 | 2.5% |
Other values (251) | 750 |
Value | Count | Frequency (%) |
20180815 | 1 | |
20180816 | 1 | |
20180818 | 1 | |
20180820 | 1 | |
20180826 | 1 | |
20180827 | 1 | |
20180831 | 2 | |
20180915 | 1 | |
20180916 | 1 | |
20180918 | 1 |
Value | Count | Frequency (%) |
20200930 | 1 | 0.1% |
20200926 | 1 | 0.1% |
20200925 | 25 | |
20200920 | 1 | 0.1% |
20200901 | 1 | 0.1% |
20200831 | 2 | 0.2% |
20200830 | 1 | 0.1% |
20200827 | 1 | 0.1% |
20200826 | 3 | 0.3% |
20200825 | 25 |
END_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 254 |
---|---|
Distinct (%) | 25.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20193523 |
Minimum | 20180915 |
---|---|
Maximum | 20201029 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180915 |
---|---|
5-th percentile | 20181124 |
Q1 | 20190424 |
median | 20191024 |
Q3 | 20200424 |
95-th percentile | 20200924 |
Maximum | 20201029 |
Range | 20114 |
Interquartile range (IQR) | 10000 |
Descriptive statistics
Standard deviation | 6489.4928 |
---|---|
Coefficient of variation (CV) | 0.00032136506 |
Kurtosis | -0.8358201 |
Mean | 20193523 |
Median Absolute Deviation (MAD) | 9100 |
Skewness | -0.35178685 |
Sum | 2.0193523 × 1010 |
Variance | 42113516 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190924 | 30 | 3.0% |
20190324 | 30 | 3.0% |
20181224 | 30 | 3.0% |
20191124 | 30 | 3.0% |
20190624 | 30 | 3.0% |
20200424 | 30 | 3.0% |
20190524 | 30 | 3.0% |
20190724 | 30 | 3.0% |
20200824 | 30 | 3.0% |
20200224 | 30 | 3.0% |
Other values (244) | 700 |
Value | Count | Frequency (%) |
20180915 | 1 | 0.1% |
20180917 | 1 | 0.1% |
20180918 | 1 | 0.1% |
20180923 | 1 | 0.1% |
20180930 | 1 | 0.1% |
20181015 | 1 | 0.1% |
20181017 | 1 | 0.1% |
20181018 | 1 | 0.1% |
20181023 | 1 | 0.1% |
20181024 | 28 |
Value | Count | Frequency (%) |
20201029 | 1 | 0.1% |
20201025 | 1 | 0.1% |
20201024 | 30 | |
20201019 | 1 | 0.1% |
20200930 | 2 | 0.2% |
20200929 | 1 | 0.1% |
20200925 | 1 | 0.1% |
20200924 | 30 | |
20200923 | 1 | 0.1% |
20200919 | 1 | 0.1% |
PAY_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 90 |
---|---|
Distinct (%) | 9.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20193667 |
Minimum | 20181025 |
---|---|
Maximum | 20201030 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20181025 |
---|---|
5-th percentile | 20181126 |
Q1 | 20190425 |
median | 20191025 |
Q3 | 20200427 |
95-th percentile | 20200925 |
Maximum | 20201030 |
Range | 20005 |
Interquartile range (IQR) | 10002 |
Descriptive statistics
Standard deviation | 6448.5118 |
---|---|
Coefficient of variation (CV) | 0.00031933338 |
Kurtosis | -0.82304542 |
Mean | 20193667 |
Median Absolute Deviation (MAD) | 9103 |
Skewness | -0.3668579 |
Sum | 2.0193667 × 1010 |
Variance | 41583305 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20201026 | 39 | 3.9% |
20200727 | 39 | 3.9% |
20200128 | 39 | 3.9% |
20200427 | 39 | 3.9% |
20190527 | 38 | 3.8% |
20191226 | 38 | 3.8% |
20200325 | 38 | 3.8% |
20200525 | 38 | 3.8% |
20200625 | 38 | 3.8% |
20200225 | 38 | 3.8% |
Other values (80) | 616 |
Value | Count | Frequency (%) |
20181025 | 33 | |
20181026 | 1 | 0.1% |
20181030 | 1 | 0.1% |
20181120 | 1 | 0.1% |
20181126 | 36 | |
20181130 | 1 | 0.1% |
20181220 | 1 | 0.1% |
20181226 | 37 | |
20181231 | 1 | 0.1% |
20190121 | 1 | 0.1% |
Value | Count | Frequency (%) |
20201030 | 1 | 0.1% |
20201026 | 39 | |
20201020 | 1 | 0.1% |
20201005 | 1 | 0.1% |
20200928 | 1 | 0.1% |
20200925 | 38 | |
20200921 | 1 | 0.1% |
20200831 | 1 | 0.1% |
20200826 | 1 | 0.1% |
20200825 | 38 |
RAT_STRT_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 266 |
---|---|
Distinct (%) | 26.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20191666 |
Minimum | 20180625 |
---|---|
Maximum | 20200825 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180625 |
---|---|
5-th percentile | 20180831 |
Q1 | 20190203 |
median | 20190825 |
Q3 | 20200225 |
95-th percentile | 20200725 |
Maximum | 20200825 |
Range | 20200 |
Interquartile range (IQR) | 10021.75 |
Descriptive statistics
Standard deviation | 6937.8995 |
---|---|
Coefficient of variation (CV) | 0.00034360214 |
Kurtosis | -1.0324376 |
Mean | 20191666 |
Median Absolute Deviation (MAD) | 9300 |
Skewness | -0.13455763 |
Sum | 2.0191666 × 1010 |
Variance | 48134449 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190125 | 25 | 2.5% |
20191225 | 25 | 2.5% |
20181225 | 25 | 2.5% |
20200325 | 25 | 2.5% |
20190725 | 25 | 2.5% |
20180825 | 25 | 2.5% |
20200225 | 25 | 2.5% |
20190525 | 25 | 2.5% |
20200425 | 25 | 2.5% |
20190825 | 25 | 2.5% |
Other values (256) | 750 |
Value | Count | Frequency (%) |
20180625 | 1 | |
20180626 | 1 | |
20180630 | 1 | |
20180715 | 1 | |
20180716 | 1 | |
20180718 | 1 | |
20180720 | 2 | |
20180725 | 1 | |
20180726 | 2 | |
20180727 | 1 |
Value | Count | Frequency (%) |
20200825 | 24 | |
20200801 | 1 | 0.1% |
20200731 | 2 | 0.2% |
20200727 | 1 | 0.1% |
20200726 | 2 | 0.2% |
20200725 | 24 | |
20200720 | 1 | 0.1% |
20200718 | 2 | 0.2% |
20200716 | 1 | 0.1% |
20200715 | 2 | 0.2% |
RAT_END_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 254 |
---|---|
Distinct (%) | 25.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20192719 |
Minimum | 20180815 |
---|---|
Maximum | 20200929 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180815 |
---|---|
5-th percentile | 20181024 |
Q1 | 20190324 |
median | 20190924 |
Q3 | 20200324 |
95-th percentile | 20200824 |
Maximum | 20200929 |
Range | 20114 |
Interquartile range (IQR) | 10000 |
Descriptive statistics
Standard deviation | 6737.1693 |
---|---|
Coefficient of variation (CV) | 0.00033364349 |
Kurtosis | -0.93363732 |
Mean | 20192719 |
Median Absolute Deviation (MAD) | 9200 |
Skewness | -0.26655842 |
Sum | 2.0192719 × 1010 |
Variance | 45389450 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190824 | 30 | 3.0% |
20200924 | 30 | 3.0% |
20191024 | 30 | 3.0% |
20200624 | 30 | 3.0% |
20200124 | 30 | 3.0% |
20181224 | 30 | 3.0% |
20191124 | 30 | 3.0% |
20200524 | 30 | 3.0% |
20200424 | 30 | 3.0% |
20190124 | 30 | 3.0% |
Other values (244) | 700 |
Value | Count | Frequency (%) |
20180815 | 1 | 0.1% |
20180817 | 1 | 0.1% |
20180818 | 1 | 0.1% |
20180823 | 1 | 0.1% |
20180831 | 1 | 0.1% |
20180915 | 1 | 0.1% |
20180917 | 1 | 0.1% |
20180918 | 1 | 0.1% |
20180923 | 1 | 0.1% |
20180924 | 28 |
Value | Count | Frequency (%) |
20200929 | 1 | 0.1% |
20200925 | 1 | 0.1% |
20200924 | 30 | |
20200919 | 1 | 0.1% |
20200831 | 2 | 0.2% |
20200829 | 1 | 0.1% |
20200825 | 1 | 0.1% |
20200824 | 30 | |
20200823 | 1 | 0.1% |
20200819 | 1 | 0.1% |
BASIS_RAT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 219 |
---|---|
Distinct (%) | 21.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.26341 |
Minimum | 0.66 |
---|---|
Maximum | 4.65 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0.66 |
---|---|
5-th percentile | 1.5 |
Q1 | 3.1175 |
median | 3.48 |
Q3 | 3.78 |
95-th percentile | 4.18 |
Maximum | 4.65 |
Range | 3.99 |
Interquartile range (IQR) | 0.6625 |
Descriptive statistics
Standard deviation | 0.78492941 |
---|---|
Coefficient of variation (CV) | 0.2405243 |
Kurtosis | 1.5111993 |
Mean | 3.26341 |
Median Absolute Deviation (MAD) | 0.33 |
Skewness | -1.365736 |
Sum | 3263.41 |
Variance | 0.61611419 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3.52 | 31 | 3.1% |
3.49 | 28 | 2.8% |
3.57 | 26 | 2.6% |
3.56 | 25 | 2.5% |
3.4 | 24 | 2.4% |
3.51 | 22 | 2.2% |
3.87 | 21 | 2.1% |
3.36 | 21 | 2.1% |
3.53 | 21 | 2.1% |
3.48 | 20 | 2.0% |
Other values (209) | 761 |
Value | Count | Frequency (%) |
0.66 | 1 | |
0.68 | 1 | |
0.7 | 2 | |
0.71 | 2 | |
0.75 | 1 | |
0.77 | 2 | |
0.78 | 1 | |
0.79 | 1 | |
0.82 | 1 | |
0.86 | 1 |
Value | Count | Frequency (%) |
4.65 | 5 | |
4.64 | 1 | 0.1% |
4.63 | 2 | 0.2% |
4.62 | 2 | 0.2% |
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% |
FACE_RAT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 195 |
---|---|
Distinct (%) | 19.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.02194 |
Minimum | 0.99 |
---|---|
Maximum | 4.2 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0.99 |
---|---|
5-th percentile | 2.0795 |
Q1 | 2.79 |
median | 3.04 |
Q3 | 3.37 |
95-th percentile | 3.74 |
Maximum | 4.2 |
Range | 3.21 |
Interquartile range (IQR) | 0.58 |
Descriptive statistics
Standard deviation | 0.47413314 |
---|---|
Coefficient of variation (CV) | 0.15689694 |
Kurtosis | 1.1657565 |
Mean | 3.02194 |
Median Absolute Deviation (MAD) | 0.29 |
Skewness | -0.57376106 |
Sum | 3021.94 |
Variance | 0.22480224 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3.07 | 32 | 3.2% |
3.11 | 30 | 3.0% |
3.04 | 29 | 2.9% |
2.95 | 26 | 2.6% |
3.12 | 25 | 2.5% |
3.08 | 22 | 2.2% |
2.91 | 21 | 2.1% |
3.06 | 21 | 2.1% |
3.03 | 21 | 2.1% |
3.42 | 20 | 2.0% |
Other values (185) | 753 |
Value | Count | Frequency (%) |
0.99 | 1 | 0.1% |
1.04 | 1 | 0.1% |
1.15 | 1 | 0.1% |
1.27 | 1 | 0.1% |
1.45 | 1 | 0.1% |
1.58 | 1 | 0.1% |
1.7 | 1 | 0.1% |
1.79 | 1 | 0.1% |
1.8 | 2 | |
1.81 | 3 |
Value | Count | Frequency (%) |
4.2 | 5 | |
4.19 | 1 | 0.1% |
4.18 | 2 | 0.2% |
4.17 | 2 | 0.2% |
4.16 | 1 | 0.1% |
4.14 | 1 | 0.1% |
4.11 | 1 | 0.1% |
4.08 | 1 | 0.1% |
4.03 | 1 | 0.1% |
3.99 | 2 | 0.2% |
IAPPLY_SPREAD_RAT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 7 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -0.24147 |
Minimum | -0.45 |
---|---|
Maximum | 1.96 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 877 |
Negative (%) | 87.7% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | -0.45 |
---|---|
5-th percentile | -0.45 |
Q1 | -0.45 |
median | -0.45 |
Q3 | -0.45 |
95-th percentile | 1.23 |
Maximum | 1.96 |
Range | 2.41 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 0.58048057 |
---|---|
Coefficient of variation (CV) | -2.4039449 |
Kurtosis | 5.8855934 |
Mean | -0.24147 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 2.7011794 |
Sum | -241.47 |
Variance | 0.3369577 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-0.45 | 827 | |
-0.4 | 50 | 5.0% |
1.96 | 25 | 2.5% |
1.23 | 25 | 2.5% |
1.09 | 25 | 2.5% |
1.49 | 24 | 2.4% |
0.33 | 24 | 2.4% |
Value | Count | Frequency (%) |
-0.45 | 827 | |
-0.4 | 50 | 5.0% |
0.33 | 24 | 2.4% |
1.09 | 25 | 2.5% |
1.23 | 25 | 2.5% |
1.49 | 24 | 2.4% |
1.96 | 25 | 2.5% |
Value | Count | Frequency (%) |
1.96 | 25 | 2.5% |
1.49 | 24 | 2.4% |
1.23 | 25 | 2.5% |
1.09 | 25 | 2.5% |
0.33 | 24 | 2.4% |
-0.4 | 50 | 5.0% |
-0.45 | 827 |
DEBENTURE_BENIF_RAT
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 1000 |
---|---|
Missing (%) | 100.0% |
Memory size | 8.9 KiB |
CONFM_YN
Boolean
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.1 KiB |
True |
---|
Value | Count | Frequency (%) |
True | 1000 |
REG_ENO
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1769 | |
---|---|
1841 | |
1438 | |
1628 |
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 (%) |
1769 | 289 | |
1841 | 279 | |
1438 | 264 | |
1628 | 168 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1769 | 289 | |
1841 | 279 | |
1438 | 264 | |
1628 | 168 |
REG_DT
Date
Distinct | 378 |
---|---|
Distinct (%) | 37.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2018-10-02 16:41:27 |
---|---|
Maximum | 2020-10-13 20:19:38 |
RMK
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 1000 |
---|---|
Missing (%) | 100.0% |
Memory size | 8.9 KiB |
TRNCH_CD | LIQD_PLAN_CD | STRT_DY | END_DY | PAY_DY | RAT_STRT_DY | RAT_END_DY | BASIS_RAT | FACE_RAT | IAPPLY_SPREAD_RAT | REG_ENO | |
---|---|---|---|---|---|---|---|---|---|---|---|
TRNCH_CD | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.937 | 0.932 | 1.000 | 0.000 |
LIQD_PLAN_CD | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.937 | 0.932 | 1.000 | 0.000 |
STRT_DY | 0.000 | 0.000 | 1.000 | 0.990 | 0.977 | 0.990 | 1.000 | 0.350 | 0.240 | 0.000 | 0.965 |
END_DY | 0.000 | 0.000 | 0.990 | 1.000 | 0.996 | 0.970 | 0.993 | 0.318 | 0.224 | 0.000 | 0.945 |
PAY_DY | 0.000 | 0.000 | 0.977 | 0.996 | 1.000 | 0.951 | 0.978 | 0.300 | 0.216 | 0.000 | 0.924 |
RAT_STRT_DY | 0.000 | 0.000 | 0.990 | 0.970 | 0.951 | 1.000 | 0.988 | 0.339 | 0.243 | 0.000 | 0.970 |
RAT_END_DY | 0.000 | 0.000 | 1.000 | 0.993 | 0.978 | 0.988 | 1.000 | 0.342 | 0.238 | 0.000 | 0.965 |
BASIS_RAT | 0.937 | 0.937 | 0.350 | 0.318 | 0.300 | 0.339 | 0.342 | 1.000 | 0.951 | 0.835 | 0.388 |
FACE_RAT | 0.932 | 0.932 | 0.240 | 0.224 | 0.216 | 0.243 | 0.238 | 0.951 | 1.000 | 0.695 | 0.243 |
IAPPLY_SPREAD_RAT | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.835 | 0.695 | 1.000 | 0.000 |
REG_ENO | 0.000 | 0.000 | 0.965 | 0.945 | 0.924 | 0.970 | 0.965 | 0.388 | 0.243 | 0.000 | 1.000 |
LIQD_PLAN_CD | TRNCH_CD | REG_ENO | |
---|---|---|---|
LIQD_PLAN_CD | 1.000 | 1.000 | 0.000 |
TRNCH_CD | 1.000 | 1.000 | 0.000 |
REG_ENO | 0.000 | 0.000 | 1.000 |
STRT_DY | END_DY | PAY_DY | RAT_STRT_DY | RAT_END_DY | BASIS_RAT | FACE_RAT | IAPPLY_SPREAD_RAT | TRNCH_CD | LIQD_PLAN_CD | REG_ENO | |
---|---|---|---|---|---|---|---|---|---|---|---|
STRT_DY | 1.000 | 0.999 | 0.997 | 0.997 | 0.999 | -0.200 | -0.256 | 0.016 | 0.000 | 0.000 | 0.749 |
END_DY | 0.999 | 1.000 | 0.998 | 0.996 | 1.000 | -0.194 | -0.251 | 0.009 | 0.000 | 0.000 | 0.686 |
PAY_DY | 0.997 | 0.998 | 1.000 | 0.995 | 0.998 | -0.182 | -0.241 | 0.001 | 0.000 | 0.000 | 0.648 |
RAT_STRT_DY | 0.997 | 0.996 | 0.995 | 1.000 | 0.996 | -0.158 | -0.239 | -0.046 | 0.000 | 0.000 | 0.767 |
RAT_END_DY | 0.999 | 1.000 | 0.998 | 0.996 | 1.000 | -0.194 | -0.251 | 0.009 | 0.000 | 0.000 | 0.748 |
BASIS_RAT | -0.200 | -0.194 | -0.182 | -0.158 | -0.194 | 1.000 | 0.855 | -0.437 | 0.671 | 0.671 | 0.241 |
FACE_RAT | -0.256 | -0.251 | -0.241 | -0.239 | -0.251 | 0.855 | 1.000 | -0.062 | 0.656 | 0.656 | 0.147 |
IAPPLY_SPREAD_RAT | 0.016 | 0.009 | 0.001 | -0.046 | 0.009 | -0.437 | -0.062 | 1.000 | 0.982 | 0.982 | 0.000 |
TRNCH_CD | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.671 | 0.656 | 0.982 | 1.000 | 1.000 | 0.000 |
LIQD_PLAN_CD | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.671 | 0.656 | 0.982 | 1.000 | 1.000 | 0.000 |
REG_ENO | 0.749 | 0.686 | 0.648 | 0.767 | 0.748 | 0.241 | 0.147 | 0.000 | 0.000 | 0.000 | 1.000 |
TRNCH_CD | LIQD_PLAN_CD | STRT_DY | END_DY | PAY_DY | RAT_STRT_DY | RAT_END_DY | BASIS_RAT | FACE_RAT | IAPPLY_SPREAD_RAT | DEBENTURE_BENIF_RAT | CONFM_YN | REG_ENO | REG_DT | RMK | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | KHFCMB2019S-01-A420-1 | KHFCMB2019S-01 | 20200804 | 20200902 | 20201026 | 20200704 | 20200802 | 3.86 | 3.41 | -0.45 | <NA> | Y | 1769 | 2020/10/13 20:19:38 | <NA> |
1 | KHFCMB2017S-24-A421-1 | KHFCMB2017S-24 | 20200826 | 20201024 | 20201026 | 20200726 | 20200924 | 3.78 | 3.33 | -0.45 | <NA> | Y | 1769 | 2020/10/13 20:19:38 | <NA> |
2 | KHFCMB2013S-33-A420-1 | KHFCMB2013S-33 | 20200925 | 20201024 | 20201026 | 20200825 | 20200924 | 3.51 | 3.06 | -0.45 | <NA> | Y | 1769 | 2020/10/13 20:19:38 | <NA> |
3 | KHFCMB2013S-11-A420-1 | KHFCMB2013S-11 | 20200925 | 20201024 | 20201026 | 20200825 | 20200924 | 3.09 | 2.64 | -0.45 | <NA> | Y | 1769 | 2020/10/13 20:19:38 | <NA> |
4 | KHFCMB2014S-04-A420-1 | KHFCMB2014S-04 | 20200925 | 20201024 | 20201026 | 20200825 | 20200924 | 2.99 | 2.54 | -0.45 | <NA> | Y | 1769 | 2020/10/13 20:09:45 | <NA> |
5 | KHFCMB2012S-36-A421-1 | KHFCMB2012S-36 | 20200925 | 20201024 | 20201026 | 20200825 | 20200924 | 2.75 | 2.3 | -0.45 | <NA> | Y | 1769 | 2020/10/13 20:09:45 | <NA> |
6 | KHFCMB2012S-12-A420-1 | KHFCMB2012S-12 | 20200925 | 20201024 | 20201026 | 20200825 | 20200924 | 3.09 | 2.64 | -0.45 | <NA> | Y | 1769 | 2020/10/13 20:09:45 | <NA> |
7 | KHFCMB2010S-08-A420-1 | KHFCMB2010S-08 | 20200926 | 20201025 | 20201026 | 20200626 | 20200925 | 0.7 | 2.66 | 1.96 | <NA> | Y | 1769 | 2020/10/13 19:53:20 | <NA> |
8 | KHFCMB2009S-02-A420-1 | KHFCMB2009S-02 | 20200930 | 20201029 | 20201030 | 20200630 | 20200929 | 0.7 | 1.93 | 1.23 | <NA> | Y | 1769 | 2020/10/13 19:50:27 | <NA> |
9 | KHFCMB2009S-03-A366-1 | KHFCMB2009S-03 | 20200901 | 20200930 | 20201026 | 20200801 | 20200831 | 0.68 | 2.17 | 1.49 | <NA> | Y | 1769 | 2020/10/13 19:27:00 | <NA> |
TRNCH_CD | LIQD_PLAN_CD | STRT_DY | END_DY | PAY_DY | RAT_STRT_DY | RAT_END_DY | BASIS_RAT | FACE_RAT | IAPPLY_SPREAD_RAT | DEBENTURE_BENIF_RAT | CONFM_YN | REG_ENO | REG_DT | RMK | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | KHFCMB2012S-04-A421-1 | KHFCMB2012S-04 | 20180925 | 20181024 | 20181025 | 20180825 | 20180924 | 3.54 | 3.09 | -0.45 | <NA> | Y | 1438 | 2018/10/04 10:45:21 | <NA> |
991 | KHFCMB2011S-20-A421-1 | KHFCMB2011S-20 | 20180925 | 20181024 | 20181025 | 20180825 | 20180924 | 3.35 | 2.9 | -0.45 | <NA> | Y | 1438 | 2018/10/04 10:45:21 | <NA> |
992 | KHFCMB2011S-15-A421-1 | KHFCMB2011S-15 | 20180925 | 20181024 | 20181025 | 20180825 | 20180924 | 3.41 | 2.96 | -0.45 | <NA> | Y | 1438 | 2018/10/04 10:45:21 | <NA> |
993 | KHFCMB2011S-06-A421-1 | KHFCMB2011S-06 | 20180925 | 20181024 | 20181025 | 20180825 | 20180924 | 3.58 | 3.13 | -0.45 | <NA> | Y | 1438 | 2018/10/04 10:45:21 | <NA> |
994 | KHFCMB2010S-18-A420-1 | KHFCMB2010S-18 | 20180925 | 20181024 | 20181025 | 20180825 | 20180924 | 3.19 | 2.74 | -0.45 | <NA> | Y | 1438 | 2018/10/04 10:45:21 | <NA> |
995 | KHFCMB2010S-06-A420-1 | KHFCMB2010S-06 | 20180925 | 20181024 | 20181025 | 20180825 | 20180924 | 3.84 | 3.44 | -0.4 | <NA> | Y | 1438 | 2018/10/04 10:45:21 | <NA> |
996 | KHFCMB2009S-13-A420-1 | KHFCMB2009S-13 | 20180925 | 20181024 | 20181025 | 20180825 | 20180924 | 3.7 | 3.3 | -0.4 | <NA> | Y | 1438 | 2018/10/04 10:45:21 | <NA> |
997 | KHFCMB2010S-08-A420-1 | KHFCMB2010S-08 | 20180926 | 20181025 | 20181026 | 20180626 | 20180925 | 1.65 | 3.61 | 1.96 | <NA> | Y | 1438 | 2018/10/02 17:05:02 | <NA> |
998 | KHFCMB2009S-07-A360-1 | KHFCMB2009S-07 | 20180925 | 20181024 | 20181025 | 20180625 | 20180924 | 1.65 | 2.74 | 1.09 | <NA> | Y | 1438 | 2018/10/02 17:04:30 | <NA> |
999 | KHFCMB2009S-02-A420-1 | KHFCMB2009S-02 | 20180930 | 20181029 | 20181030 | 20180630 | 20180929 | 1.65 | 2.88 | 1.23 | <NA> | Y | 1438 | 2018/10/02 16:41:27 | <NA> |