Dataset statistics
Number of variables | 5 |
---|---|
Number of observations | 1000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 42.1 KiB |
Average record size in memory | 43.1 B |
Variable types
Categorical | 4 |
---|---|
Numeric | 1 |
Dataset
Description | 한국주택금융공사 신탁자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073111/fileData.do |
RCV_DY has constant value "" | Constant |
DWRT_BASIS_DY has constant value "" | Constant |
HOLD_CD is highly overall correlated with SEQ and 1 other fields | High correlation |
LIQD_PLAN_CD is highly overall correlated with SEQ and 1 other fields | High correlation |
SEQ is highly overall correlated with LIQD_PLAN_CD and 1 other fields | High correlation |
LIQD_PLAN_CD is highly imbalanced (69.7%) | Imbalance |
HOLD_CD is highly imbalanced (69.7%) | Imbalance |
SEQ has unique values | Unique |
Reproduction
Analysis started | 2023-12-12 22:28:58.491274 |
---|---|
Analysis finished | 2023-12-12 22:28:58.957537 |
Duration | 0.47 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
LIQD_PLAN_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2014S-04 | |
---|---|
KHFCMB2012S-36 | 54 |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2014S-04 |
---|---|
2nd row | KHFCMB2014S-04 |
3rd row | KHFCMB2014S-04 |
4th row | KHFCMB2014S-04 |
5th row | KHFCMB2014S-04 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2014S-04 | 946 | |
KHFCMB2012S-36 | 54 | 5.4% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
khfcmb2014s-04 | 946 | |
khfcmb2012s-36 | 54 | 5.4% |
HOLD_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
F001-2014-0001 | |
---|---|
F001-2012-0004 | 54 |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | F001-2014-0001 |
---|---|
2nd row | F001-2014-0001 |
3rd row | F001-2014-0001 |
4th row | F001-2014-0001 |
5th row | F001-2014-0001 |
Common Values
Value | Count | Frequency (%) |
F001-2014-0001 | 946 | |
F001-2012-0004 | 54 | 5.4% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
f001-2014-0001 | 946 | |
f001-2012-0004 | 54 | 5.4% |
RCV_DY
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20140203 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20140203 |
---|---|
2nd row | 20140203 |
3rd row | 20140203 |
4th row | 20140203 |
5th row | 20140203 |
Common Values
Value | Count | Frequency (%) |
20140203 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20140203 | 1000 |
DWRT_BASIS_DY
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20140131 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20140131 |
---|---|
2nd row | 20140131 |
3rd row | 20140131 |
4th row | 20140131 |
5th row | 20140131 |
Common Values
Value | Count | Frequency (%) |
20140131 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20140131 | 1000 |
SEQ
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 1000 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4248.5 |
Minimum | 3749 |
---|---|
Maximum | 4748 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 3749 |
---|---|
5-th percentile | 3798.95 |
Q1 | 3998.75 |
median | 4248.5 |
Q3 | 4498.25 |
95-th percentile | 4698.05 |
Maximum | 4748 |
Range | 999 |
Interquartile range (IQR) | 499.5 |
Descriptive statistics
Standard deviation | 288.81944 |
---|---|
Coefficient of variation (CV) | 0.067981508 |
Kurtosis | -1.2 |
Mean | 4248.5 |
Median Absolute Deviation (MAD) | 250 |
Skewness | 0 |
Sum | 4248500 |
Variance | 83416.667 |
Monotonicity | Strictly decreasing |
Value | Count | Frequency (%) |
4748 | 1 | 0.1% |
4076 | 1 | 0.1% |
4089 | 1 | 0.1% |
4088 | 1 | 0.1% |
4087 | 1 | 0.1% |
4086 | 1 | 0.1% |
4085 | 1 | 0.1% |
4084 | 1 | 0.1% |
4083 | 1 | 0.1% |
4082 | 1 | 0.1% |
Other values (990) | 990 |
Value | Count | Frequency (%) |
3749 | 1 | |
3750 | 1 | |
3751 | 1 | |
3752 | 1 | |
3753 | 1 | |
3754 | 1 | |
3755 | 1 | |
3756 | 1 | |
3757 | 1 | |
3758 | 1 |
Value | Count | Frequency (%) |
4748 | 1 | |
4747 | 1 | |
4746 | 1 | |
4745 | 1 | |
4744 | 1 | |
4743 | 1 | |
4742 | 1 | |
4741 | 1 | |
4740 | 1 | |
4739 | 1 |
LIQD_PLAN_CD | HOLD_CD | SEQ | |
---|---|---|---|
LIQD_PLAN_CD | 1.000 | 1.000 | 0.876 |
HOLD_CD | 1.000 | 1.000 | 0.876 |
SEQ | 0.876 | 0.876 | 1.000 |
HOLD_CD | LIQD_PLAN_CD | |
---|---|---|
HOLD_CD | 1.000 | 0.990 |
LIQD_PLAN_CD | 0.990 | 1.000 |
SEQ | LIQD_PLAN_CD | HOLD_CD | |
---|---|---|---|
SEQ | 1.000 | 0.711 | 0.711 |
LIQD_PLAN_CD | 0.711 | 1.000 | 0.990 |
HOLD_CD | 0.711 | 0.990 | 1.000 |
LIQD_PLAN_CD | HOLD_CD | RCV_DY | DWRT_BASIS_DY | SEQ | |
---|---|---|---|---|---|
0 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4748 |
1 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4747 |
2 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4746 |
3 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4745 |
4 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4744 |
5 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4743 |
6 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4742 |
7 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4741 |
8 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4740 |
9 | KHFCMB2014S-04 | F001-2014-0001 | 20140203 | 20140131 | 4739 |
LIQD_PLAN_CD | HOLD_CD | RCV_DY | DWRT_BASIS_DY | SEQ | |
---|---|---|---|---|---|
990 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3758 |
991 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3757 |
992 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3756 |
993 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3755 |
994 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3754 |
995 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3753 |
996 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3752 |
997 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3751 |
998 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3750 |
999 | KHFCMB2012S-36 | F001-2012-0004 | 20140203 | 20140131 | 3749 |