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 | 7 |
---|---|
Numeric | 1 |
Dataset
Description | 한국주택금융공사 유동화자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15072810/fileData.do |
OBJECT_CODE has constant value "" | Constant |
OFFER_CNT has constant value "" | Constant |
LOAN_ORG_CD is highly overall correlated with LIQD_PLAN_CD and 1 other fields | High correlation |
RCV_DY is highly overall correlated with DWRT_BASIS_DY and 1 other fields | High correlation |
HOLD_CD is highly overall correlated with LOAN_ORG_CD and 1 other fields | High correlation |
DWRT_BASIS_DY is highly overall correlated with RCV_DY and 1 other fields | High correlation |
LIQD_PLAN_CD is highly overall correlated with LOAN_ORG_CD and 3 other fields | High correlation |
LOAN_ORG_CD is highly imbalanced (84.3%) | Imbalance |
Reproduction
Analysis started | 2023-12-12 20:42:22.201919 |
---|---|
Analysis finished | 2023-12-12 20:42:23.017405 |
Duration | 0.82 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
LOAN_ORG_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B003 | |
---|---|
I001 | 35 |
B004 | 9 |
B020 | 6 |
B081 | 2 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | B081 |
---|---|
2nd row | B081 |
3rd row | B020 |
4th row | B020 |
5th row | B020 |
Common Values
Value | Count | Frequency (%) |
B003 | 948 | |
I001 | 35 | 3.5% |
B004 | 9 | 0.9% |
B020 | 6 | 0.6% |
B081 | 2 | 0.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
b003 | 948 | |
i001 | 35 | 3.5% |
b004 | 9 | 0.9% |
b020 | 6 | 0.6% |
b081 | 2 | 0.2% |
RCV_DY
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20161215 | |
---|---|
20180612 | |
20180913 | |
20170217 |
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20180913 |
---|---|
2nd row | 20180913 |
3rd row | 20180913 |
4th row | 20180913 |
5th row | 20180913 |
Common Values
Value | Count | Frequency (%) |
20161215 | 447 | |
20180612 | 296 | |
20180913 | 130 | 13.0% |
20170217 | 127 | 12.7% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20161215 | 447 | |
20180612 | 296 | |
20180913 | 130 | 13.0% |
20170217 | 127 | 12.7% |
DWRT_BASIS_DY
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20161214 | |
---|---|
20180611 | |
20180912 | |
20170216 |
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20180912 |
---|---|
2nd row | 20180912 |
3rd row | 20180912 |
4th row | 20180912 |
5th row | 20180912 |
Common Values
Value | Count | Frequency (%) |
20161214 | 447 | |
20180611 | 296 | |
20180912 | 130 | 13.0% |
20170216 | 127 | 12.7% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20161214 | 447 | |
20180611 | 296 | |
20180912 | 130 | 13.0% |
20170216 | 127 | 12.7% |
OBJECT_CODE
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
SD |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | SD |
---|---|
2nd row | SD |
3rd row | SD |
4th row | SD |
5th row | SD |
Common Values
Value | Count | Frequency (%) |
SD | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
sd | 1000 |
OFFER_CNT
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 1000 |
SEQ
Real number (ℝ)
Distinct | 478 |
---|---|
Distinct (%) | 47.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 173.003 |
Minimum | 1 |
---|---|
Maximum | 478 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 13 |
Q1 | 67 |
median | 137.5 |
Q3 | 262.25 |
95-th percentile | 428.05 |
Maximum | 478 |
Range | 477 |
Interquartile range (IQR) | 195.25 |
Descriptive statistics
Standard deviation | 128.78147 |
---|---|
Coefficient of variation (CV) | 0.74438867 |
Kurtosis | -0.60733613 |
Mean | 173.003 |
Median Absolute Deviation (MAD) | 91.5 |
Skewness | 0.65267663 |
Sum | 173003 |
Variance | 16584.668 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
24 | 4 | 0.4% |
1 | 4 | 0.4% |
25 | 4 | 0.4% |
23 | 4 | 0.4% |
22 | 4 | 0.4% |
21 | 4 | 0.4% |
20 | 4 | 0.4% |
19 | 4 | 0.4% |
18 | 4 | 0.4% |
17 | 4 | 0.4% |
Other values (468) | 960 |
Value | Count | Frequency (%) |
1 | 4 | |
2 | 4 | |
3 | 4 | |
4 | 4 | |
5 | 4 | |
6 | 4 | |
7 | 4 | |
8 | 4 | |
9 | 4 | |
10 | 4 |
Value | Count | Frequency (%) |
478 | 1 | |
477 | 1 | |
476 | 1 | |
475 | 1 | |
474 | 1 | |
473 | 1 | |
472 | 1 | |
471 | 1 | |
470 | 1 | |
469 | 1 |
LIQD_PLAN_CD
Categorical
HIGH CORRELATION
 
Distinct | 11 |
---|---|
Distinct (%) | 1.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2016L-04 | |
---|---|
KHFCMB2013L-A1 | |
KHFCMB2012L-A3 | |
KHFCMB2013L-A5 | |
KHFCMB2015L-05 | |
Other values (6) |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2015L-A4 |
---|---|
2nd row | KHFCMB2015L-A4 |
3rd row | KHFCMB2014L-A1 |
4th row | KHFCMB2015L-A4 |
5th row | KHFCMB2014L-A1 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2016L-04 | 296 | |
KHFCMB2013L-A1 | 199 | |
KHFCMB2012L-A3 | 139 | |
KHFCMB2013L-A5 | 109 | 10.9% |
KHFCMB2015L-05 | 88 | 8.8% |
KHFCMB2015L-A4 | 68 | 6.8% |
KHFCMB2014L-A4 | 49 | 4.9% |
KHFCMB2014L-05 | 36 | 3.6% |
KHFCMB2014L-A1 | 8 | 0.8% |
KHFCMB2015L-A3 | 5 | 0.5% |
Length
Value | Count | Frequency (%) |
khfcmb2016l-04 | 296 | |
khfcmb2013l-a1 | 199 | |
khfcmb2012l-a3 | 139 | |
khfcmb2013l-a5 | 109 | 10.9% |
khfcmb2015l-05 | 88 | 8.8% |
khfcmb2015l-a4 | 68 | 6.8% |
khfcmb2014l-a4 | 49 | 4.9% |
khfcmb2014l-05 | 36 | 3.6% |
khfcmb2014l-a1 | 8 | 0.8% |
khfcmb2015l-a3 | 5 | 0.5% |
HOLD_CD
Categorical
HIGH CORRELATION
 
Distinct | 47 |
---|---|
Distinct (%) | 4.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B003-2010-0003 | |
---|---|
B003-2010-0008 | |
B003-2010-0011 | |
B003-2010-0014 | |
B003-2010-0006 | |
Other values (42) |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 10 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | B081-2012-0025 |
---|---|
2nd row | B081-2012-0008 |
3rd row | B020-2012-0002 |
4th row | B020-2011-0010 |
5th row | B020-2012-0002 |
Common Values
Value | Count | Frequency (%) |
B003-2010-0003 | 254 | |
B003-2010-0008 | 157 | |
B003-2010-0011 | 108 | |
B003-2010-0014 | 94 | 9.4% |
B003-2010-0006 | 75 | 7.5% |
B003-2010-0018 | 63 | 6.3% |
B003-2010-0020 | 40 | 4.0% |
B003-2011-0001 | 36 | 3.6% |
I001-2010-0006 | 15 | 1.5% |
B003-2012-0002 | 15 | 1.5% |
Other values (37) | 143 |
Length
Value | Count | Frequency (%) |
b003-2010-0003 | 254 | |
b003-2010-0008 | 157 | |
b003-2010-0011 | 108 | |
b003-2010-0014 | 94 | 9.4% |
b003-2010-0006 | 75 | 7.5% |
b003-2010-0018 | 63 | 6.3% |
b003-2010-0020 | 40 | 4.0% |
b003-2011-0001 | 36 | 3.6% |
i001-2010-0006 | 15 | 1.5% |
b003-2012-0002 | 15 | 1.5% |
Other values (37) | 143 |
LOAN_ORG_CD | RCV_DY | DWRT_BASIS_DY | SEQ | LIQD_PLAN_CD | HOLD_CD | |
---|---|---|---|---|---|---|
LOAN_ORG_CD | 1.000 | 0.386 | 0.386 | 0.421 | 0.744 | 1.000 |
RCV_DY | 0.386 | 1.000 | 1.000 | 0.607 | 1.000 | 0.664 |
DWRT_BASIS_DY | 0.386 | 1.000 | 1.000 | 0.607 | 1.000 | 0.664 |
SEQ | 0.421 | 0.607 | 0.607 | 1.000 | 0.565 | 0.407 |
LIQD_PLAN_CD | 0.744 | 1.000 | 1.000 | 0.565 | 1.000 | 0.879 |
HOLD_CD | 1.000 | 0.664 | 0.664 | 0.407 | 0.879 | 1.000 |
LOAN_ORG_CD | RCV_DY | HOLD_CD | DWRT_BASIS_DY | LIQD_PLAN_CD | |
---|---|---|---|---|---|
LOAN_ORG_CD | 1.000 | 0.323 | 0.979 | 0.323 | 0.529 |
RCV_DY | 0.323 | 1.000 | 0.390 | 1.000 | 0.996 |
HOLD_CD | 0.979 | 0.390 | 1.000 | 0.390 | 0.516 |
DWRT_BASIS_DY | 0.323 | 1.000 | 0.390 | 1.000 | 0.996 |
LIQD_PLAN_CD | 0.529 | 0.996 | 0.516 | 0.996 | 1.000 |
SEQ | LOAN_ORG_CD | RCV_DY | DWRT_BASIS_DY | LIQD_PLAN_CD | HOLD_CD | |
---|---|---|---|---|---|---|
SEQ | 1.000 | 0.187 | 0.410 | 0.410 | 0.281 | 0.148 |
LOAN_ORG_CD | 0.187 | 1.000 | 0.323 | 0.323 | 0.529 | 0.979 |
RCV_DY | 0.410 | 0.323 | 1.000 | 1.000 | 0.996 | 0.390 |
DWRT_BASIS_DY | 0.410 | 0.323 | 1.000 | 1.000 | 0.996 | 0.390 |
LIQD_PLAN_CD | 0.281 | 0.529 | 0.996 | 0.996 | 1.000 | 0.516 |
HOLD_CD | 0.148 | 0.979 | 0.390 | 0.390 | 0.516 | 1.000 |
LOAN_ORG_CD | RCV_DY | DWRT_BASIS_DY | OBJECT_CODE | OFFER_CNT | SEQ | LIQD_PLAN_CD | HOLD_CD | |
---|---|---|---|---|---|---|---|---|
0 | B081 | 20180913 | 20180912 | SD | 1 | 130 | KHFCMB2015L-A4 | B081-2012-0025 |
1 | B081 | 20180913 | 20180912 | SD | 1 | 129 | KHFCMB2015L-A4 | B081-2012-0008 |
2 | B020 | 20180913 | 20180912 | SD | 1 | 128 | KHFCMB2014L-A1 | B020-2012-0002 |
3 | B020 | 20180913 | 20180912 | SD | 1 | 127 | KHFCMB2015L-A4 | B020-2011-0010 |
4 | B020 | 20180913 | 20180912 | SD | 1 | 126 | KHFCMB2014L-A1 | B020-2012-0002 |
5 | B004 | 20180913 | 20180912 | SD | 1 | 125 | KHFCMB2015L-A4 | B004-2011-0022 |
6 | B003 | 20180913 | 20180912 | SD | 1 | 124 | KHFCMB2015L-A4 | B003-2012-0002 |
7 | B003 | 20180913 | 20180912 | SD | 1 | 123 | KHFCMB2014L-A1 | B003-2010-0003 |
8 | B003 | 20180913 | 20180912 | SD | 1 | 122 | KHFCMB2015L-A3 | B003-2010-0003 |
9 | B003 | 20180913 | 20180912 | SD | 1 | 121 | KHFCMB2014L-A4 | B003-2010-0006 |
LOAN_ORG_CD | RCV_DY | DWRT_BASIS_DY | OBJECT_CODE | OFFER_CNT | SEQ | LIQD_PLAN_CD | HOLD_CD | |
---|---|---|---|---|---|---|---|---|
990 | B003 | 20161215 | 20161214 | SD | 1 | 92 | KHFCMB2013L-A5 | B003-2010-0003 |
991 | B003 | 20161215 | 20161214 | SD | 1 | 91 | KHFCMB2013L-A5 | B003-2010-0003 |
992 | B003 | 20161215 | 20161214 | SD | 1 | 90 | KHFCMB2013L-A5 | B003-2010-0003 |
993 | B003 | 20161215 | 20161214 | SD | 1 | 89 | KHFCMB2012L-A3 | B003-2010-0006 |
994 | B003 | 20161215 | 20161214 | SD | 1 | 88 | KHFCMB2012L-A3 | B003-2010-0006 |
995 | B003 | 20161215 | 20161214 | SD | 1 | 87 | KHFCMB2013L-A1 | B003-2010-0014 |
996 | B003 | 20161215 | 20161214 | SD | 1 | 86 | KHFCMB2013L-A1 | B003-2011-0004 |
997 | B003 | 20161215 | 20161214 | SD | 1 | 85 | KHFCMB2013L-A5 | B003-2010-0003 |
998 | B003 | 20161215 | 20161214 | SD | 1 | 84 | KHFCMB2012L-A3 | B003-2010-0008 |
999 | B003 | 20161215 | 20161214 | SD | 1 | 83 | KHFCMB2013L-A1 | B003-2011-0001 |