Dataset statistics
Number of variables | 39 |
---|---|
Number of observations | 1000 |
Missing cells | 3000 |
Missing cells (%) | 7.7% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 339.0 KiB |
Average record size in memory | 347.1 B |
Variable types
Categorical | 26 |
---|---|
Numeric | 9 |
Boolean | 1 |
Unsupported | 3 |
Dataset
Description | 한국주택금융공사 유동화자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) 유동화계획코드,인수코드,납입회차,취급기관코드,매입시대출잔액,상환금액,대출잔액,청구금액,청구이자금액,청구연체료금액,원리금균등액,잔여회차,처리완료여부와 관련된 정보가 포함되어있습니다. |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15072813/fileData.do |
REPAY_AMT has constant value "" | Constant |
DDELAY_FEE_AMT has constant value "" | Constant |
CDELAY_FEE_AMT has constant value "" | Constant |
CRDELAY_FEE_AMT has constant value "" | Constant |
AREPAY_AMT has constant value "" | Constant |
AREPAY_INT_AMT has constant value "" | Constant |
EOUT_INT_AMT has constant value "" | Constant |
PDELAY_FEE_AMT has constant value "" | Constant |
DELAY_AMT has constant value "" | Constant |
DPRMS_INT_AMT has constant value "" | Constant |
DELAY_DCNT has constant value "" | Constant |
APAY_USE_DCNT has constant value "" | Constant |
APAY_OCCR_DCNT has constant value "" | Constant |
RDUAPRNINT_DCNT has constant value "" | Constant |
HREPAY_FEE_AMT has constant value "" | Constant |
RECKON_DY is highly imbalanced (93.5%) | Imbalance |
PAY_DY is highly imbalanced (93.5%) | Imbalance |
PRCSS_YN is highly imbalanced (88.8%) | Imbalance |
NTRD_APPLY_DY is highly imbalanced (93.4%) | Imbalance |
PDLAST_APPLY_DY is highly imbalanced (88.8%) | Imbalance |
RDLAST_APPLY_DY is highly imbalanced (88.8%) | Imbalance |
RDUALAST_STRT_DY is highly imbalanced (88.8%) | Imbalance |
HREPAY_AMT is highly imbalanced (98.0%) | Imbalance |
HREPAY_INT_AMT is highly imbalanced (98.0%) | Imbalance |
CNVNC_REPAY_YN has 1000 (100.0%) missing values | Missing |
REPURCH_CMPLT_YN has 1000 (100.0%) missing values | Missing |
RDUALAST_APPLY_DY has 1000 (100.0%) missing values | Missing |
CNVNC_REPAY_YN is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
REPURCH_CMPLT_YN is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
RDUALAST_APPLY_DY is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
LOAN_RAMT has 902 (90.2%) zeros | Zeros |
CLLCT_AMT has 985 (98.5%) zeros | Zeros |
CLLCT_INT_AMT has 985 (98.5%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 17:34:45.662167 |
---|---|
Analysis finished | 2023-12-12 17:34:46.111608 |
Duration | 0.45 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
LIQD_PLAN_CD
Categorical
Distinct | 27 |
---|---|
Distinct (%) | 2.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2016S-13 | |
---|---|
KHFCMB2017S-17 | |
KHFCMB2018S-12 | |
KHFCMB2013S-23 | 62 |
KHFCMB2018S-04 | 59 |
Other values (22) |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 3 ? |
---|---|
Unique (%) | 0.3% |
Sample
1st row | KHFCMB2018S-12 |
---|---|
2nd row | KHFCMB2018S-12 |
3rd row | KHFCMB2018S-12 |
4th row | KHFCMB2018S-12 |
5th row | KHFCMB2018S-12 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2016S-13 | 84 | 8.4% |
KHFCMB2017S-17 | 80 | 8.0% |
KHFCMB2018S-12 | 80 | 8.0% |
KHFCMB2013S-23 | 62 | 6.2% |
KHFCMB2018S-04 | 59 | 5.9% |
KHFCMB2016S-20 | 42 | 4.2% |
KHFCMB2016S-22 | 41 | 4.1% |
KHFCMB2017S-08 | 41 | 4.1% |
KHFCMB2018S-20 | 41 | 4.1% |
KHFCMB2018S-19 | 41 | 4.1% |
Other values (17) | 429 |
Length
Value | Count | Frequency (%) |
khfcmb2016s-13 | 84 | 8.4% |
khfcmb2018s-12 | 80 | 8.0% |
khfcmb2017s-17 | 80 | 8.0% |
khfcmb2013s-23 | 62 | 6.2% |
khfcmb2018s-04 | 59 | 5.9% |
khfcmb2016s-20 | 42 | 4.2% |
khfcmb2016s-22 | 41 | 4.1% |
khfcmb2017s-08 | 41 | 4.1% |
khfcmb2018s-20 | 41 | 4.1% |
khfcmb2018s-19 | 41 | 4.1% |
Other values (17) | 429 |
HOLD_CD
Categorical
Distinct | 29 |
---|---|
Distinct (%) | 2.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B088-2016-0057 | |
---|---|
B023-2018-0032 | |
B027-2013-0013 | 62 |
B088-2018-0014 | 59 |
B088-2016-0092 | 42 |
Other values (24) |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 3 ? |
---|---|
Unique (%) | 0.3% |
Sample
1st row | B023-2018-0032 |
---|---|
2nd row | B023-2018-0032 |
3rd row | B023-2018-0032 |
4th row | B023-2018-0032 |
5th row | B023-2018-0032 |
Common Values
Value | Count | Frequency (%) |
B088-2016-0057 | 84 | 8.4% |
B023-2018-0032 | 80 | 8.0% |
B027-2013-0013 | 62 | 6.2% |
B088-2018-0014 | 59 | 5.9% |
B088-2016-0092 | 42 | 4.2% |
B088-2016-0105 | 41 | 4.1% |
B020-2017-0044 | 41 | 4.1% |
B088-2018-0058 | 41 | 4.1% |
B023-2018-0047 | 41 | 4.1% |
B023-2019-0040 | 41 | 4.1% |
Other values (19) | 468 |
Length
Value | Count | Frequency (%) |
b088-2016-0057 | 84 | 8.4% |
b023-2018-0032 | 80 | 8.0% |
b027-2013-0013 | 62 | 6.2% |
b088-2018-0014 | 59 | 5.9% |
b088-2016-0092 | 42 | 4.2% |
b088-2016-0105 | 41 | 4.1% |
b020-2017-0044 | 41 | 4.1% |
b088-2018-0058 | 41 | 4.1% |
b023-2018-0047 | 41 | 4.1% |
b023-2019-0040 | 41 | 4.1% |
Other values (19) | 468 |
PAY_SEQ
Real number (ℝ)
Distinct | 303 |
---|---|
Distinct (%) | 30.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 217.61 |
Minimum | 8 |
---|---|
Maximum | 360 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 8 |
---|---|
5-th percentile | 67.95 |
Q1 | 142 |
median | 233 |
Q3 | 282 |
95-th percentile | 348 |
Maximum | 360 |
Range | 352 |
Interquartile range (IQR) | 140 |
Descriptive statistics
Standard deviation | 88.223689 |
---|---|
Coefficient of variation (CV) | 0.40542112 |
Kurtosis | -0.98462984 |
Mean | 217.61 |
Median Absolute Deviation (MAD) | 78 |
Skewness | -0.22472107 |
Sum | 217610 |
Variance | 7783.4193 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
38 | 13 | 1.3% |
246 | 7 | 0.7% |
245 | 7 | 0.7% |
258 | 6 | 0.6% |
343 | 6 | 0.6% |
261 | 6 | 0.6% |
257 | 6 | 0.6% |
236 | 6 | 0.6% |
235 | 6 | 0.6% |
234 | 6 | 0.6% |
Other values (293) | 931 |
Value | Count | Frequency (%) |
8 | 1 | 0.1% |
38 | 13 | |
39 | 2 | 0.2% |
40 | 2 | 0.2% |
41 | 2 | 0.2% |
42 | 2 | 0.2% |
43 | 2 | 0.2% |
44 | 2 | 0.2% |
45 | 2 | 0.2% |
46 | 2 | 0.2% |
Value | Count | Frequency (%) |
360 | 4 | |
359 | 4 | |
358 | 4 | |
357 | 4 | |
356 | 4 | |
355 | 4 | |
354 | 4 | |
353 | 4 | |
352 | 4 | |
351 | 4 |
TREAT_ORG_CD
Categorical
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B088 | |
---|---|
B020 | |
B023 | |
B003 | |
B027 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | B023 |
---|---|
2nd row | B023 |
3rd row | B023 |
4th row | B023 |
5th row | B023 |
Common Values
Value | Count | Frequency (%) |
B088 | 418 | |
B020 | 242 | |
B023 | 202 | |
B003 | 76 | 7.6% |
B027 | 62 | 6.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
b088 | 418 | |
b020 | 242 | |
b023 | 202 | |
b003 | 76 | 7.6% |
b027 | 62 | 6.2% |
BHOUR_LOAN_RAMT
Real number (ℝ)
Distinct | 43 |
---|---|
Distinct (%) | 4.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.1611045 × 108 |
Minimum | 14500000 |
---|---|
Maximum | 3.9707145 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 14500000 |
---|---|
5-th percentile | 19963819 |
Q1 | 59760741 |
median | 93828798 |
Q3 | 1.6553889 × 108 |
95-th percentile | 2.4655014 × 108 |
Maximum | 3.9707145 × 108 |
Range | 3.8257145 × 108 |
Interquartile range (IQR) | 1.0577815 × 108 |
Descriptive statistics
Standard deviation | 77895653 |
---|---|
Coefficient of variation (CV) | 0.67087549 |
Kurtosis | 1.9732772 |
Mean | 1.1611045 × 108 |
Median Absolute Deviation (MAD) | 52933729 |
Skewness | 1.2196953 |
Sum | 1.1611045 × 1011 |
Variance | 6.0677327 × 1015 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
199698769 | 59 | 5.9% |
80000000 | 43 | 4.3% |
19963819 | 42 | 4.2% |
89000000 | 42 | 4.2% |
149770465 | 42 | 4.2% |
59760741 | 41 | 4.1% |
99682027 | 41 | 4.1% |
49860792 | 41 | 4.1% |
29954335 | 41 | 4.1% |
104811334 | 41 | 4.1% |
Other values (33) | 567 |
Value | Count | Frequency (%) |
14500000 | 20 | |
19963819 | 42 | |
24320256 | 26 | |
29954335 | 41 | |
35000000 | 16 | 1.6% |
44851865 | 40 | |
49860792 | 41 | |
50000000 | 15 | 1.5% |
59760741 | 41 | |
63918000 | 1 | 0.1% |
Value | Count | Frequency (%) |
397071451 | 22 | |
374850000 | 1 | 0.1% |
345100000 | 1 | 0.1% |
299044420 | 1 | 0.1% |
287000000 | 1 | 0.1% |
248546846 | 1 | 0.1% |
246550138 | 40 | |
239608908 | 1 | 0.1% |
224000000 | 40 | |
206000000 | 1 | 0.1% |
REPAY_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
LOAN_RAMT
Real number (ℝ)
ZEROS
 
Distinct | 99 |
---|---|
Distinct (%) | 9.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 6645174.1 |
Minimum | 0 |
---|---|
Maximum | 3.1815 × 108 |
Zeros | 902 |
Zeros (%) | 90.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 67917842 |
Maximum | 3.1815 × 108 |
Range | 3.1815 × 108 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 25600794 |
---|---|
Coefficient of variation (CV) | 3.8525393 |
Kurtosis | 55.138202 |
Mean | 6645174.1 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 6.2039268 |
Sum | 6.6451741 × 109 |
Variance | 6.5540067 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 902 | |
65339723 | 1 | 0.1% |
69583334 | 1 | 0.1% |
69163015 | 1 | 0.1% |
68741803 | 1 | 0.1% |
68319696 | 1 | 0.1% |
67896692 | 1 | 0.1% |
67472789 | 1 | 0.1% |
67047985 | 1 | 0.1% |
66622278 | 1 | 0.1% |
Other values (89) | 89 | 8.9% |
Value | Count | Frequency (%) |
0 | 902 | |
1550092 | 1 | 0.1% |
3096559 | 1 | 0.1% |
4639426 | 1 | 0.1% |
6178702 | 1 | 0.1% |
7714394 | 1 | 0.1% |
9246511 | 1 | 0.1% |
10775062 | 1 | 0.1% |
12300054 | 1 | 0.1% |
13821496 | 1 | 0.1% |
Value | Count | Frequency (%) |
318150000 | 1 | |
292900000 | 1 | |
280874534 | 1 | |
196695076 | 1 | |
125763306 | 1 | |
121725460 | 1 | |
97784000 | 1 | |
95062821 | 1 | |
89474000 | 1 | |
83493151 | 1 |
DEMND_AMT
Real number (ℝ)
Distinct | 805 |
---|---|
Distinct (%) | 80.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 345615.71 |
Minimum | 1748 |
---|---|
Maximum | 1575000 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1748 |
---|---|
5-th percentile | 38530.7 |
Q1 | 138888 |
median | 298673 |
Q3 | 461111 |
95-th percentile | 742327.95 |
Maximum | 1575000 |
Range | 1573252 |
Interquartile range (IQR) | 322223 |
Descriptive statistics
Standard deviation | 272626.7 |
---|---|
Coefficient of variation (CV) | 0.78881456 |
Kurtosis | 5.9776464 |
Mean | 345615.71 |
Median Absolute Deviation (MAD) | 159785 |
Skewness | 2.0170644 |
Sum | 3.4561571 × 108 |
Variance | 7.432532 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
247222 | 42 | 4.2% |
461111 | 41 | 4.1% |
138888 | 41 | 4.1% |
67744 | 26 | 2.6% |
376585 | 18 | 1.8% |
91666 | 16 | 1.6% |
1748 | 15 | 1.5% |
269501 | 3 | 0.3% |
277000 | 2 | 0.2% |
95413 | 1 | 0.1% |
Other values (795) | 795 |
Value | Count | Frequency (%) |
1748 | 15 | |
35630 | 1 | 0.1% |
35710 | 1 | 0.1% |
35790 | 1 | 0.1% |
35870 | 1 | 0.1% |
35951 | 1 | 0.1% |
36031 | 1 | 0.1% |
36112 | 1 | 0.1% |
36193 | 1 | 0.1% |
36274 | 1 | 0.1% |
Value | Count | Frequency (%) |
1575000 | 1 | |
1550092 | 1 | |
1546467 | 1 | |
1542867 | 1 | |
1539276 | 1 | |
1535692 | 1 | |
1532117 | 1 | |
1528551 | 1 | |
1524992 | 1 | |
1521442 | 1 |
DEMND_INT_AMT
Real number (ℝ)
Distinct | 997 |
---|---|
Distinct (%) | 99.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 112116.81 |
Minimum | 303 |
---|---|
Maximum | 901519 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 303 |
---|---|
5-th percentile | 4118.4 |
Q1 | 24204.25 |
median | 63764 |
Q3 | 160376 |
95-th percentile | 297608.9 |
Maximum | 901519 |
Range | 901216 |
Interquartile range (IQR) | 136171.75 |
Descriptive statistics
Standard deviation | 125948.83 |
---|---|
Coefficient of variation (CV) | 1.1233716 |
Kurtosis | 6.3956869 |
Mean | 112116.81 |
Median Absolute Deviation (MAD) | 52758 |
Skewness | 2.2214724 |
Sum | 1.1211681 × 108 |
Variance | 1.5863108 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1247 | 2 | 0.2% |
45103 | 2 | 0.2% |
259595 | 2 | 0.2% |
545578 | 1 | 0.1% |
550299 | 1 | 0.1% |
549124 | 1 | 0.1% |
547946 | 1 | 0.1% |
546764 | 1 | 0.1% |
544388 | 1 | 0.1% |
552638 | 1 | 0.1% |
Other values (987) | 987 |
Value | Count | Frequency (%) |
303 | 1 | |
417 | 1 | |
606 | 1 | |
833 | 1 | |
908 | 1 | |
994 | 1 | |
1030 | 1 | |
1185 | 1 | |
1191 | 1 | |
1199 | 1 |
Value | Count | Frequency (%) |
901519 | 1 | |
832383 | 1 | |
806694 | 1 | |
566564 | 1 | |
559567 | 1 | |
558421 | 1 | |
557271 | 1 | |
556118 | 1 | |
554962 | 1 | |
553802 | 1 |
DDELAY_FEE_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
PRNINTEVEN_AMT
Real number (ℝ)
Distinct | 43 |
---|---|
Distinct (%) | 4.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 448954.28 |
Minimum | 1748 |
---|---|
Maximum | 1575000 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1748 |
---|---|
5-th percentile | 62363 |
Q1 | 195842 |
median | 378785 |
Q3 | 601295 |
95-th percentile | 995320 |
Maximum | 1575000 |
Range | 1573252 |
Interquartile range (IQR) | 405453 |
Descriptive statistics
Standard deviation | 324603.29 |
---|---|
Coefficient of variation (CV) | 0.7230208 |
Kurtosis | 1.4247317 |
Mean | 448954.28 |
Median Absolute Deviation (MAD) | 222510 |
Skewness | 1.1484192 |
Sum | 4.4895428 × 108 |
Variance | 1.0536729 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
926231 | 59 | 5.9% |
62363 | 42 | 4.2% |
332127 | 42 | 4.2% |
247222 | 42 | 4.2% |
677576 | 42 | 4.2% |
118799 | 41 | 4.1% |
446258 | 41 | 4.1% |
138888 | 41 | 4.1% |
137915 | 41 | 4.1% |
427541 | 41 | 4.1% |
Other values (33) | 568 |
Value | Count | Frequency (%) |
1748 | 15 | 1.5% |
62363 | 42 | |
67744 | 26 | |
90000 | 1 | 0.1% |
91666 | 16 | 1.6% |
118799 | 41 | |
137682 | 20 | |
137915 | 41 | |
138888 | 41 | |
195842 | 40 |
Value | Count | Frequency (%) |
1575000 | 1 | 0.1% |
1553692 | 22 | 2.2% |
1450000 | 1 | 0.1% |
1337106 | 1 | 0.1% |
995320 | 40 | |
937436 | 1 | 0.1% |
926231 | 59 | |
917475 | 40 | |
677576 | 42 | |
647848 | 40 |
RECKON_DY
Categorical
IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
<NA> | |
---|---|
20201021 | 14 |
20191007 | 2 |
20191008 | 1 |
20201022 | 1 |
Length
Max length | 8 |
---|---|
Median length | 4 |
Mean length | 4.072 |
Min length | 4 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 0.2% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 982 | |
20201021 | 14 | 1.4% |
20191007 | 2 | 0.2% |
20191008 | 1 | 0.1% |
20201022 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 982 | |
20201021 | 14 | 1.4% |
20191007 | 2 | 0.2% |
20191008 | 1 | 0.1% |
20201022 | 1 | 0.1% |
PAY_DY
Categorical
IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
<NA> | |
---|---|
20201021 | 14 |
20191007 | 2 |
20191008 | 1 |
20201022 | 1 |
Length
Max length | 8 |
---|---|
Median length | 4 |
Mean length | 4.072 |
Min length | 4 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 0.2% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 982 | |
20201021 | 14 | 1.4% |
20191007 | 2 | 0.2% |
20191008 | 1 | 0.1% |
20201022 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 982 | |
20201021 | 14 | 1.4% |
20191007 | 2 | 0.2% |
20191008 | 1 | 0.1% |
20201022 | 1 | 0.1% |
CLLCT_AMT
Real number (ℝ)
ZEROS
 
Distinct | 15 |
---|---|
Distinct (%) | 1.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 6935.739 |
Minimum | 0 |
---|---|
Maximum | 1575000 |
Zeros | 985 |
Zeros (%) | 98.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 1575000 |
Range | 1575000 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 76987.879 |
---|---|
Coefficient of variation (CV) | 11.10017 |
Kurtosis | 301.19684 |
Mean | 6935.739 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 16.240165 |
Sum | 6935739 |
Variance | 5.9271335 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 985 | |
277000 | 2 | 0.2% |
239603 | 1 | 0.1% |
90000 | 1 | 0.1% |
229515 | 1 | 0.1% |
144027 | 1 | 0.1% |
370872 | 1 | 0.1% |
267335 | 1 | 0.1% |
237128 | 1 | 0.1% |
1450000 | 1 | 0.1% |
Other values (5) | 5 | 0.5% |
Value | Count | Frequency (%) |
0 | 985 | |
90000 | 1 | 0.1% |
144027 | 1 | 0.1% |
229515 | 1 | 0.1% |
237128 | 1 | 0.1% |
239603 | 1 | 0.1% |
267335 | 1 | 0.1% |
277000 | 2 | 0.2% |
304847 | 1 | 0.1% |
370872 | 1 | 0.1% |
Value | Count | Frequency (%) |
1575000 | 1 | |
1450000 | 1 | |
541000 | 1 | |
530412 | 1 | |
402000 | 1 | |
370872 | 1 | |
304847 | 1 | |
277000 | 2 | |
267335 | 1 | |
239603 | 1 |
CLLCT_INT_AMT
Real number (ℝ)
ZEROS
 
Distinct | 16 |
---|---|
Distinct (%) | 1.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5418.295 |
Minimum | 0 |
---|---|
Maximum | 901519 |
Zeros | 985 |
Zeros (%) | 98.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 901519 |
Range | 901519 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 55087.568 |
---|---|
Coefficient of variation (CV) | 10.166956 |
Kurtosis | 179.518 |
Mean | 5418.295 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 12.778909 |
Sum | 5418295 |
Variance | 3.0346402 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 985 | |
832383 | 1 | 0.1% |
901519 | 1 | 0.1% |
240220 | 1 | 0.1% |
806694 | 1 | 0.1% |
253068 | 1 | 0.1% |
126837 | 1 | 0.1% |
230553 | 1 | 0.1% |
362251 | 1 | 0.1% |
225058 | 1 | 0.1% |
Other values (6) | 6 | 0.6% |
Value | Count | Frequency (%) |
0 | 985 | |
45045 | 1 | 0.1% |
82737 | 1 | 0.1% |
126837 | 1 | 0.1% |
174721 | 1 | 0.1% |
220025 | 1 | 0.1% |
225058 | 1 | 0.1% |
230553 | 1 | 0.1% |
240220 | 1 | 0.1% |
253068 | 1 | 0.1% |
Value | Count | Frequency (%) |
901519 | 1 | |
832383 | 1 | |
806694 | 1 | |
566564 | 1 | |
362251 | 1 | |
350620 | 1 | |
253068 | 1 | |
240220 | 1 | |
230553 | 1 | |
225058 | 1 |
CDELAY_FEE_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
CRDELAY_FEE_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
AREPAY_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
AREPAY_INT_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
EOUT_INT_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
PDELAY_FEE_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
DELAY_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
DPRMS_INT_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
DELAY_DCNT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
APAY_USE_DCNT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
APAY_OCCR_DCNT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
RMN_SEQ
Real number (ℝ)
Distinct | 281 |
---|---|
Distinct (%) | 28.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 117.07 |
Minimum | 0 |
---|---|
Maximum | 352 |
Zeros | 7 |
Zeros (%) | 0.7% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 7 |
Q1 | 43 |
median | 104 |
Q3 | 153 |
95-th percentile | 271.05 |
Maximum | 352 |
Range | 352 |
Interquartile range (IQR) | 110 |
Descriptive statistics
Standard deviation | 86.150944 |
---|---|
Coefficient of variation (CV) | 0.73589257 |
Kurtosis | -0.59675242 |
Mean | 117.07 |
Median Absolute Deviation (MAD) | 57.5 |
Skewness | 0.61242148 |
Sum | 117070 |
Variance | 7421.9851 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
17 | 9 | 0.9% |
322 | 8 | 0.8% |
18 | 8 | 0.8% |
16 | 8 | 0.8% |
15 | 8 | 0.8% |
14 | 8 | 0.8% |
13 | 8 | 0.8% |
102 | 7 | 0.7% |
6 | 7 | 0.7% |
0 | 7 | 0.7% |
Other values (271) | 922 |
Value | Count | Frequency (%) |
0 | 7 | |
1 | 7 | |
2 | 7 | |
3 | 7 | |
4 | 7 | |
5 | 7 | |
6 | 7 | |
7 | 7 | |
8 | 7 | |
9 | 7 |
Value | Count | Frequency (%) |
352 | 1 | 0.1% |
322 | 8 | |
321 | 1 | 0.1% |
320 | 1 | 0.1% |
319 | 1 | 0.1% |
318 | 1 | 0.1% |
317 | 1 | 0.1% |
316 | 1 | 0.1% |
315 | 1 | 0.1% |
314 | 1 | 0.1% |
PRCSS_YN
Boolean
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.1 KiB |
False | |
---|---|
True | 15 |
Value | Count | Frequency (%) |
False | 985 | |
True | 15 | 1.5% |
CNVNC_REPAY_YN
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 1000 |
---|---|
Missing (%) | 100.0% |
Memory size | 8.9 KiB |
REPURCH_CMPLT_YN
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 1000 |
---|---|
Missing (%) | 100.0% |
Memory size | 8.9 KiB |
NTRD_APPLY_DY
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
<NA> | |
---|---|
20201020 | 7 |
20201021 | 7 |
20191005 | 1 |
Length
Max length | 8 |
---|---|
Median length | 4 |
Mean length | 4.06 |
Min length | 4 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 985 | |
20201020 | 7 | 0.7% |
20201021 | 7 | 0.7% |
20191005 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 985 | |
20201020 | 7 | 0.7% |
20201021 | 7 | 0.7% |
20191005 | 1 | 0.1% |
PDLAST_APPLY_DY
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
<NA> | |
---|---|
19000101 | 15 |
Length
Max length | 8 |
---|---|
Median length | 4 |
Mean length | 4.06 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 985 | |
19000101 | 15 | 1.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 985 | |
19000101 | 15 | 1.5% |
RDLAST_APPLY_DY
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
<NA> | |
---|---|
19000101 | 15 |
Length
Max length | 8 |
---|---|
Median length | 4 |
Mean length | 4.06 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 985 | |
19000101 | 15 | 1.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 985 | |
19000101 | 15 | 1.5% |
RDUALAST_STRT_DY
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
<NA> | |
---|---|
19000101 | 15 |
Length
Max length | 8 |
---|---|
Median length | 4 |
Mean length | 4.06 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 985 | |
19000101 | 15 | 1.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 985 | |
19000101 | 15 | 1.5% |
RDUALAST_APPLY_DY
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 1000 |
---|---|
Missing (%) | 100.0% |
Memory size | 8.9 KiB |
RDUAPRNINT_DCNT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
HREPAY_AMT
Categorical
IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 | |
---|---|
563044 | 1 |
7516692 | 1 |
16300000 | 1 |
50000000 | 1 |
Length
Max length | 8 |
---|---|
Median length | 1 |
Mean length | 1.025 |
Min length | 1 |
Unique
Unique | 4 ? |
---|---|
Unique (%) | 0.4% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 996 | |
563044 | 1 | 0.1% |
7516692 | 1 | 0.1% |
16300000 | 1 | 0.1% |
50000000 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 996 | |
563044 | 1 | 0.1% |
7516692 | 1 | 0.1% |
16300000 | 1 | 0.1% |
50000000 | 1 | 0.1% |
HREPAY_INT_AMT
Categorical
IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 | |
---|---|
458 | 1 |
12267 | 1 |
38015 | 1 |
117827 | 1 |
Length
Max length | 6 |
---|---|
Median length | 1 |
Mean length | 1.015 |
Min length | 1 |
Unique
Unique | 4 ? |
---|---|
Unique (%) | 0.4% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 996 | |
458 | 1 | 0.1% |
12267 | 1 | 0.1% |
38015 | 1 | 0.1% |
117827 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 996 | |
458 | 1 | 0.1% |
12267 | 1 | 0.1% |
38015 | 1 | 0.1% |
117827 | 1 | 0.1% |
HREPAY_FEE_AMT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 1000 |
LIQD_PLAN_CD | HOLD_CD | PAY_SEQ | TREAT_ORG_CD | BHOUR_LOAN_RAMT | REPAY_AMT | LOAN_RAMT | DEMND_AMT | DEMND_INT_AMT | DDELAY_FEE_AMT | PRNINTEVEN_AMT | RECKON_DY | PAY_DY | CLLCT_AMT | CLLCT_INT_AMT | CDELAY_FEE_AMT | CRDELAY_FEE_AMT | AREPAY_AMT | AREPAY_INT_AMT | EOUT_INT_AMT | PDELAY_FEE_AMT | DELAY_AMT | DPRMS_INT_AMT | DELAY_DCNT | APAY_USE_DCNT | APAY_OCCR_DCNT | RMN_SEQ | PRCSS_YN | CNVNC_REPAY_YN | REPURCH_CMPLT_YN | NTRD_APPLY_DY | PDLAST_APPLY_DY | RDLAST_APPLY_DY | RDUALAST_STRT_DY | RDUALAST_APPLY_DY | RDUAPRNINT_DCNT | HREPAY_AMT | HREPAY_INT_AMT | HREPAY_FEE_AMT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | KHFCMB2018S-12 | B023-2018-0032 | 258 | B023 | 149770465 | 0 | 0 | 495145 | 182431 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 102 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
1 | KHFCMB2018S-12 | B023-2018-0032 | 257 | B023 | 149770465 | 0 | 0 | 493639 | 183937 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 103 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
2 | KHFCMB2018S-12 | B023-2018-0032 | 256 | B023 | 149770465 | 0 | 0 | 492138 | 185438 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 104 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
3 | KHFCMB2018S-12 | B023-2018-0032 | 255 | B023 | 149770465 | 0 | 0 | 490642 | 186934 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 105 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
4 | KHFCMB2018S-12 | B023-2018-0032 | 254 | B023 | 149770465 | 0 | 0 | 489150 | 188426 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 106 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
5 | KHFCMB2018S-12 | B023-2018-0032 | 253 | B023 | 149770465 | 0 | 0 | 487662 | 189914 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 107 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
6 | KHFCMB2018S-12 | B023-2018-0032 | 252 | B023 | 149770465 | 0 | 0 | 486179 | 191397 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 108 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
7 | KHFCMB2018S-12 | B023-2018-0032 | 251 | B023 | 149770465 | 0 | 0 | 484701 | 192875 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 109 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
8 | KHFCMB2018S-12 | B023-2018-0032 | 250 | B023 | 149770465 | 0 | 0 | 483227 | 194349 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
9 | KHFCMB2018S-12 | B023-2018-0032 | 249 | B023 | 149770465 | 0 | 0 | 481758 | 195818 | 0 | 677576 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 111 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
LIQD_PLAN_CD | HOLD_CD | PAY_SEQ | TREAT_ORG_CD | BHOUR_LOAN_RAMT | REPAY_AMT | LOAN_RAMT | DEMND_AMT | DEMND_INT_AMT | DDELAY_FEE_AMT | PRNINTEVEN_AMT | RECKON_DY | PAY_DY | CLLCT_AMT | CLLCT_INT_AMT | CDELAY_FEE_AMT | CRDELAY_FEE_AMT | AREPAY_AMT | AREPAY_INT_AMT | EOUT_INT_AMT | PDELAY_FEE_AMT | DELAY_AMT | DPRMS_INT_AMT | DELAY_DCNT | APAY_USE_DCNT | APAY_OCCR_DCNT | RMN_SEQ | PRCSS_YN | CNVNC_REPAY_YN | REPURCH_CMPLT_YN | NTRD_APPLY_DY | PDLAST_APPLY_DY | RDLAST_APPLY_DY | RDUALAST_STRT_DY | RDUALAST_APPLY_DY | RDUAPRNINT_DCNT | HREPAY_AMT | HREPAY_INT_AMT | HREPAY_FEE_AMT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | KHFCMB2017S-28 | B003-2017-0156 | 38 | B003 | 345100000 | 0 | 292900000 | 1450000 | 832383 | 0 | 1450000 | 20201021 | 20201021 | 1450000 | 832383 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 202 | Y | <NA> | <NA> | 20201020 | 19000101 | 19000101 | 19000101 | <NA> | 0 | 0 | 0 | 0 |
991 | KHFCMB2017S-28 | B003-2017-0153 | 38 | B003 | 183460000 | 0 | 81364000 | 402000 | 230553 | 0 | 402000 | 20201021 | 20201021 | 402000 | 230553 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 202 | Y | <NA> | <NA> | 20201020 | 19000101 | 19000101 | 19000101 | <NA> | 0 | 0 | 0 | 0 |
992 | KHFCMB2017S-28 | B003-2017-0153 | 38 | B003 | 63918000 | 0 | 44442000 | 541000 | 126837 | 0 | 541000 | 20201021 | 20201021 | 541000 | 126837 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82 | Y | <NA> | <NA> | 20201020 | 19000101 | 19000101 | 19000101 | <NA> | 0 | 0 | 0 | 0 |
993 | KHFCMB2017S-28 | B003-2017-0153 | 38 | B003 | 99446000 | 0 | 89474000 | 277000 | 253068 | 0 | 277000 | 20201021 | 20201021 | 277000 | 253068 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 322 | Y | <NA> | <NA> | 20201020 | 19000101 | 19000101 | 19000101 | <NA> | 0 | 0 | 0 | 0 |
994 | KHFCMB2017S-28 | B003-2017-0153 | 38 | B003 | 299044420 | 0 | 280874534 | 530412 | 806694 | 0 | 1337106 | 20201021 | 20201021 | 530412 | 806694 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 322 | Y | <NA> | <NA> | 20201021 | 19000101 | 19000101 | 19000101 | <NA> | 0 | 0 | 0 | 0 |
995 | KHFCMB2017S-28 | B003-2017-0153 | 38 | B003 | 248546846 | 0 | 83493151 | 304847 | 240220 | 0 | 545067 | 20201021 | 20201021 | 304847 | 240220 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 202 | Y | <NA> | <NA> | 20201021 | 19000101 | 19000101 | 19000101 | <NA> | 0 | 0 | 0 | 0 |
996 | KHFCMB2017S-28 | B003-2017-0153 | 38 | B003 | 374850000 | 0 | 318150000 | 1575000 | 901519 | 0 | 1575000 | 20201021 | 20201021 | 1575000 | 901519 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 202 | Y | <NA> | <NA> | 20201020 | 19000101 | 19000101 | 19000101 | <NA> | 0 | 0 | 0 | 0 |
997 | KHFCMB2015S-12 | B088-2015-0026 | 192 | B088 | 159872342 | 0 | 0 | 269501 | 129334 | 0 | 269501 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
998 | KHFCMB2015S-12 | B088-2015-0026 | 191 | B088 | 159872342 | 0 | 0 | 269501 | 143820 | 0 | 269501 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 49 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |
999 | KHFCMB2015S-12 | B088-2015-0026 | 190 | B088 | 159872342 | 0 | 0 | 269501 | 144450 | 0 | 269501 | <NA> | <NA> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | N | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 0 | 0 | 0 | 0 |