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 | 6 |
---|---|
Numeric | 1 |
DateTime | 1 |
Dataset
Description | 한국주택금융공사 신탁자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073292/fileData.do |
LIQD_PLAN_CD has constant value "" | Constant |
PROD_DIV_CD has constant value "" | Constant |
MNG_FEE_CD is highly overall correlated with LOAN_ACC_NO and 3 other fields | High correlation |
HOLD_CD is highly overall correlated with LOAN_ACC_NO and 3 other fields | High correlation |
FEE_RAT is highly overall correlated with LOAN_ACC_NO and 2 other fields | High correlation |
REG_ENO is highly overall correlated with HOLD_CD and 1 other fields | High correlation |
LOAN_ACC_NO is highly overall correlated with HOLD_CD and 2 other fields | High correlation |
MNG_FEE_CD is highly imbalanced (54.7%) | Imbalance |
FEE_RAT is highly imbalanced (90.6%) | Imbalance |
Reproduction
Analysis started | 2023-12-11 23:23:33.366819 |
---|---|
Analysis finished | 2023-12-11 23:23:34.193946 |
Duration | 0.83 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
LIQD_PLAN_CD
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2020S-34 |
---|
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2020S-34 |
---|---|
2nd row | KHFCMB2020S-34 |
3rd row | KHFCMB2020S-34 |
4th row | KHFCMB2020S-34 |
5th row | KHFCMB2020S-34 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2020S-34 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
khfcmb2020s-34 | 1000 |
HOLD_CD
Categorical
HIGH CORRELATION
 
Distinct | 10 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B10-2015-0037 | |
---|---|
B023-2020-0038 | |
B10-2015-0035 | |
B10-2015-0039 | |
B10-2015-0047 | |
Other values (5) |
Length
Max length | 14 |
---|---|
Median length | 13 |
Mean length | 13.226 |
Min length | 13 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | B035-2020-0016 |
---|---|
2nd row | B035-2020-0016 |
3rd row | B035-2020-0016 |
4th row | B035-2020-0016 |
5th row | B035-2020-0016 |
Common Values
Value | Count | Frequency (%) |
B10-2015-0037 | 256 | |
B023-2020-0038 | 202 | |
B10-2015-0035 | 196 | |
B10-2015-0039 | 187 | |
B10-2015-0047 | 47 | 4.7% |
B10-2015-0043 | 41 | 4.1% |
B10-2015-0045 | 39 | 3.9% |
B035-2020-0016 | 22 | 2.2% |
B10-2015-0041 | 8 | 0.8% |
B020-2020-0103 | 2 | 0.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
b10-2015-0037 | 256 | |
b023-2020-0038 | 202 | |
b10-2015-0035 | 196 | |
b10-2015-0039 | 187 | |
b10-2015-0047 | 47 | 4.7% |
b10-2015-0043 | 41 | 4.1% |
b10-2015-0045 | 39 | 3.9% |
b035-2020-0016 | 22 | 2.2% |
b10-2015-0041 | 8 | 0.8% |
b020-2020-0103 | 2 | 0.2% |
LOAN_ACC_NO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 988 |
---|---|
Distinct (%) | 98.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.6933338 × 1011 |
Minimum | 6.5073017 × 1010 |
---|---|
Maximum | 3.3328404 × 1012 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 6.5073017 × 1010 |
---|---|
5-th percentile | 6.7573096 × 1010 |
Q1 | 1.1080372 × 1011 |
median | 1.1420241 × 1011 |
Q3 | 1.1810412 × 1011 |
95-th percentile | 1.198034 × 1011 |
Maximum | 3.3328404 × 1012 |
Range | 3.2677674 × 1012 |
Interquartile range (IQR) | 7.3003934 × 109 |
Descriptive statistics
Standard deviation | 4.2542157 × 1011 |
---|---|
Coefficient of variation (CV) | 2.5123314 |
Kurtosis | 46.136138 |
Mean | 1.6933338 × 1011 |
Median Absolute Deviation (MAD) | 3.6980504 × 109 |
Skewness | 6.8590427 |
Sum | 1.6933338 × 1014 |
Variance | 1.8098351 × 1023 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3332840400010 | 2 | 0.2% |
3132123900175 | 2 | 0.2% |
3332832700011 | 2 | 0.2% |
1203101819074 | 2 | 0.2% |
832639800020 | 2 | 0.2% |
2932224700033 | 2 | 0.2% |
1832694100039 | 2 | 0.2% |
3132593900027 | 2 | 0.2% |
3132661200013 | 2 | 0.2% |
3332499300011 | 2 | 0.2% |
Other values (978) | 980 |
Value | Count | Frequency (%) |
65073016915 | 1 | |
65073017331 | 1 | |
65073018014 | 1 | |
65073018995 | 1 | |
65073019009 | 1 | |
65273127130 | 1 | |
65273127453 | 1 | |
65273127743 | 1 | |
65273128051 | 1 | |
65273128062 | 1 |
Value | Count | Frequency (%) |
3332840400010 | 2 | |
3332832700011 | 2 | |
3332816900027 | 2 | |
3332672400031 | 2 | |
3332499300011 | 2 | |
3132661200013 | 2 | |
3132593900027 | 2 | |
3132123900175 | 2 | |
2932224700033 | 2 | |
1832694100039 | 2 |
MNG_FEE_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
PL | |
---|---|
QB | |
CL | 12 |
C1 | 12 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | CL |
---|---|
2nd row | C1 |
3rd row | CL |
4th row | C1 |
5th row | CL |
Common Values
Value | Count | Frequency (%) |
PL | 774 | |
QB | 202 | 20.2% |
CL | 12 | 1.2% |
C1 | 12 | 1.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
pl | 774 | |
qb | 202 | 20.2% |
cl | 12 | 1.2% |
c1 | 12 | 1.2% |
FEE_RAT
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0.1 | |
---|---|
0.15 | 12 |
Length
Max length | 4 |
---|---|
Median length | 3 |
Mean length | 3.012 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0.1 |
---|---|
2nd row | 0.15 |
3rd row | 0.1 |
4th row | 0.15 |
5th row | 0.1 |
Common Values
Value | Count | Frequency (%) |
0.1 | 988 | |
0.15 | 12 | 1.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0.1 | 988 | |
0.15 | 12 | 1.2% |
PROD_DIV_CD
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 |
REG_ENO
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1478 | |
---|---|
6045 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1478 |
---|---|
2nd row | 1478 |
3rd row | 1478 |
4th row | 1478 |
5th row | 1478 |
Common Values
Value | Count | Frequency (%) |
1478 | 798 | |
6045 | 202 | 20.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1478 | 798 | |
6045 | 202 | 20.2% |
REG_DT
Date
Distinct | 10 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2020-10-27 17:05:05 |
---|---|
Maximum | 2020-10-28 11:04:42 |
HOLD_CD | LOAN_ACC_NO | MNG_FEE_CD | FEE_RAT | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|
HOLD_CD | 1.000 | 0.828 | 0.918 | 0.866 | 1.000 | 1.000 |
LOAN_ACC_NO | 0.828 | 1.000 | 0.739 | 0.887 | 0.048 | 0.828 |
MNG_FEE_CD | 0.918 | 0.739 | 1.000 | 1.000 | 1.000 | 0.918 |
FEE_RAT | 0.866 | 0.887 | 1.000 | 1.000 | 0.048 | 0.866 |
REG_ENO | 1.000 | 0.048 | 1.000 | 0.048 | 1.000 | 1.000 |
REG_DT | 1.000 | 0.828 | 0.918 | 0.866 | 1.000 | 1.000 |
MNG_FEE_CD | HOLD_CD | FEE_RAT | REG_ENO | |
---|---|---|---|---|
MNG_FEE_CD | 1.000 | 0.812 | 0.999 | 0.999 |
HOLD_CD | 0.812 | 1.000 | 0.697 | 0.996 |
FEE_RAT | 0.999 | 0.697 | 1.000 | 0.031 |
REG_ENO | 0.999 | 0.996 | 0.031 | 1.000 |
LOAN_ACC_NO | HOLD_CD | MNG_FEE_CD | FEE_RAT | REG_ENO | |
---|---|---|---|---|---|
LOAN_ACC_NO | 1.000 | 0.627 | 0.574 | 0.700 | 0.035 |
HOLD_CD | 0.627 | 1.000 | 0.812 | 0.697 | 0.996 |
MNG_FEE_CD | 0.574 | 0.812 | 1.000 | 0.999 | 0.999 |
FEE_RAT | 0.700 | 0.697 | 0.999 | 1.000 | 0.031 |
REG_ENO | 0.035 | 0.996 | 0.999 | 0.031 | 1.000 |
LIQD_PLAN_CD | HOLD_CD | LOAN_ACC_NO | MNG_FEE_CD | FEE_RAT | PROD_DIV_CD | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|
0 | KHFCMB2020S-34 | B035-2020-0016 | 3332840400010 | CL | 0.1 | 1 | 1478 | 2020/10/28 11:04:42 |
1 | KHFCMB2020S-34 | B035-2020-0016 | 3332840400010 | C1 | 0.15 | 1 | 1478 | 2020/10/28 11:04:42 |
2 | KHFCMB2020S-34 | B035-2020-0016 | 3332832700011 | CL | 0.1 | 1 | 1478 | 2020/10/28 11:04:42 |
3 | KHFCMB2020S-34 | B035-2020-0016 | 3332832700011 | C1 | 0.15 | 1 | 1478 | 2020/10/28 11:04:42 |
4 | KHFCMB2020S-34 | B035-2020-0016 | 3332816900027 | CL | 0.1 | 1 | 1478 | 2020/10/28 11:04:42 |
5 | KHFCMB2020S-34 | B035-2020-0016 | 3332816900027 | C1 | 0.15 | 1 | 1478 | 2020/10/28 11:04:42 |
6 | KHFCMB2020S-34 | B035-2020-0016 | 3332672400031 | CL | 0.1 | 1 | 1478 | 2020/10/28 11:04:42 |
7 | KHFCMB2020S-34 | B035-2020-0016 | 3332672400031 | C1 | 0.15 | 1 | 1478 | 2020/10/28 11:04:42 |
8 | KHFCMB2020S-34 | B035-2020-0016 | 3332499300011 | CL | 0.1 | 1 | 1478 | 2020/10/28 11:04:42 |
9 | KHFCMB2020S-34 | B035-2020-0016 | 3332499300011 | C1 | 0.15 | 1 | 1478 | 2020/10/28 11:04:42 |
LIQD_PLAN_CD | HOLD_CD | LOAN_ACC_NO | MNG_FEE_CD | FEE_RAT | PROD_DIV_CD | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|
990 | KHFCMB2020S-34 | B10-2015-0041 | 119303623151 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:16 |
991 | KHFCMB2020S-34 | B10-2015-0047 | 117001724511 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
992 | KHFCMB2020S-34 | B10-2015-0047 | 117001723911 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
993 | KHFCMB2020S-34 | B10-2015-0047 | 117001723421 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
994 | KHFCMB2020S-34 | B10-2015-0047 | 116603947471 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
995 | KHFCMB2020S-34 | B10-2015-0047 | 116603915691 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
996 | KHFCMB2020S-34 | B10-2015-0047 | 116504746381 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
997 | KHFCMB2020S-34 | B10-2015-0047 | 116504702381 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
998 | KHFCMB2020S-34 | B10-2015-0047 | 116402240871 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |
999 | KHFCMB2020S-34 | B10-2015-0047 | 116402229391 | PL | 0.1 | 1 | 1478 | 2020/10/28 10:32:30 |