Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 1000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 5 |
Duplicate rows (%) | 0.5% |
Total size in memory | 58.7 KiB |
Average record size in memory | 60.1 B |
Variable types
Categorical | 7 |
---|
Dataset
Description | 화재보험대상채권정보에 대한 데이터로, 유동화계획코드, 인수코드, 변경일자, 보험가액 등의 항목을 제공합니다. |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073090/fileData.do |
LIQD_PLAN_CD has constant value "" | Constant |
UPDT_DY has constant value "" | Constant |
TREAT_ORG_CD has constant value "" | Constant |
INSURE_PRC_AMT has constant value "" | Constant |
Dataset has 5 (0.5%) duplicate rows | Duplicates |
INSURE_STRT_DY is highly overall correlated with HOLD_CD and 1 other fields | High correlation |
HOLD_CD is highly overall correlated with INSURE_STRT_DY | High correlation |
INSURE_EXPIRE_DY is highly overall correlated with INSURE_STRT_DY | High correlation |
INSURE_STRT_DY is highly imbalanced (83.7%) | Imbalance |
INSURE_EXPIRE_DY is highly imbalanced (88.2%) | Imbalance |
Reproduction
Analysis started | 2023-12-13 00:12:47.238822 |
---|---|
Analysis finished | 2023-12-13 00:12:47.556415 |
Duration | 0.32 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 | 3 |
---|---|
Distinct (%) | 0.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B081-2020-0101 | |
---|---|
B081-2020-0102 | |
B081-2020-0100 |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | B081-2020-0102 |
---|---|
2nd row | B081-2020-0102 |
3rd row | B081-2020-0102 |
4th row | B081-2020-0102 |
5th row | B081-2020-0102 |
Common Values
Value | Count | Frequency (%) |
B081-2020-0101 | 778 | |
B081-2020-0102 | 115 | 11.5% |
B081-2020-0100 | 107 | 10.7% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
b081-2020-0101 | 778 | |
b081-2020-0102 | 115 | 11.5% |
b081-2020-0100 | 107 | 10.7% |
UPDT_DY
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20201027 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20201027 |
---|---|
2nd row | 20201027 |
3rd row | 20201027 |
4th row | 20201027 |
5th row | 20201027 |
Common Values
Value | Count | Frequency (%) |
20201027 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20201027 | 1000 |
TREAT_ORG_CD
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B081 |
---|
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 | B081 |
4th row | B081 |
5th row | B081 |
Common Values
Value | Count | Frequency (%) |
B081 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
b081 | 1000 |
INSURE_PRC_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 |
INSURE_STRT_DY
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
10101 | |
---|---|
<NA> | 24 |
Length
Max length | 5 |
---|---|
Median length | 5 |
Mean length | 4.976 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 10101 |
---|---|
2nd row | 10101 |
3rd row | 10101 |
4th row | 10101 |
5th row | 10101 |
Common Values
Value | Count | Frequency (%) |
10101 | 976 | |
<NA> | 24 | 2.4% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
10101 | 976 | |
na | 24 | 2.4% |
INSURE_EXPIRE_DY
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | 0.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
10101 | |
---|---|
<NA> | 13 |
0 | 11 |
Length
Max length | 5 |
---|---|
Median length | 5 |
Mean length | 4.943 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 10101 |
---|---|
2nd row | 10101 |
3rd row | 10101 |
4th row | 10101 |
5th row | 10101 |
Common Values
Value | Count | Frequency (%) |
10101 | 976 | |
<NA> | 13 | 1.3% |
0 | 11 | 1.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
10101 | 976 | |
na | 13 | 1.3% |
0 | 11 | 1.1% |
HOLD_CD | INSURE_EXPIRE_DY | |
---|---|---|
HOLD_CD | 1.000 | 0.021 |
INSURE_EXPIRE_DY | 0.021 | 1.000 |
INSURE_STRT_DY | HOLD_CD | INSURE_EXPIRE_DY | |
---|---|---|---|
INSURE_STRT_DY | 1.000 | 1.000 | 1.000 |
HOLD_CD | 1.000 | 1.000 | 0.035 |
INSURE_EXPIRE_DY | 1.000 | 0.035 | 1.000 |
HOLD_CD | INSURE_STRT_DY | INSURE_EXPIRE_DY | |
---|---|---|---|
HOLD_CD | 1.000 | 1.000 | 0.035 |
INSURE_STRT_DY | 1.000 | 1.000 | 1.000 |
INSURE_EXPIRE_DY | 0.035 | 1.000 | 1.000 |
LIQD_PLAN_CD | HOLD_CD | UPDT_DY | TREAT_ORG_CD | INSURE_PRC_AMT | INSURE_STRT_DY | INSURE_EXPIRE_DY | |
---|---|---|---|---|---|---|---|
0 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
1 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
2 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
3 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
4 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
5 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
6 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
7 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
8 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
9 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 |
LIQD_PLAN_CD | HOLD_CD | UPDT_DY | TREAT_ORG_CD | INSURE_PRC_AMT | INSURE_STRT_DY | INSURE_EXPIRE_DY | |
---|---|---|---|---|---|---|---|
990 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
991 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
992 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
993 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
994 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
995 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
996 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
997 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
998 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
999 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 |
Most frequently occurring
LIQD_PLAN_CD | HOLD_CD | UPDT_DY | TREAT_ORG_CD | INSURE_PRC_AMT | INSURE_STRT_DY | INSURE_EXPIRE_DY | # duplicates | |
---|---|---|---|---|---|---|---|---|
1 | KHFCMB2020S-34 | B081-2020-0101 | 20201027 | B081 | 0 | 10101 | 10101 | 754 |
4 | KHFCMB2020S-34 | B081-2020-0102 | 20201027 | B081 | 0 | 10101 | 10101 | 115 |
0 | KHFCMB2020S-34 | B081-2020-0100 | 20201027 | B081 | 0 | 10101 | 10101 | 107 |
3 | KHFCMB2020S-34 | B081-2020-0101 | 20201027 | B081 | 0 | <NA> | <NA> | 13 |
2 | KHFCMB2020S-34 | B081-2020-0101 | 20201027 | B081 | 0 | <NA> | 0 | 11 |