Dataset statistics
Number of variables | 10 |
---|---|
Number of observations | 1000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 84.1 KiB |
Average record size in memory | 86.1 B |
Variable types
Categorical | 7 |
---|---|
Numeric | 3 |
Dataset
Description | 한국주택금융공사 신탁자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073064/fileData.do |
BASIS_DY has constant value "" | Constant |
STS has constant value "" | Constant |
REG_ENO has constant value "" | Constant |
LOAN_ORG_CD is highly overall correlated with LOAN_ACC_NO and 3 other fields | High correlation |
HOLD_CD is highly overall correlated with LOAN_ORG_CD and 2 other fields | High correlation |
REG_DT is highly overall correlated with LOAN_ACC_NO and 3 other fields | High correlation |
LIQD_PLAN_CD is highly overall correlated with LOAN_ORG_CD and 2 other fields | High correlation |
LOAN_ACC_NO is highly overall correlated with LOAN_ORG_CD and 1 other fields | High correlation |
LOAN_ACC_NO has unique values | Unique |
LOAN_RAMT has 97 (9.7%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 09:58:54.915596 |
---|---|
Analysis finished | 2023-12-12 09:58:57.177716 |
Duration | 2.26 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
LOAN_ORG_CD
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
I003 | |
---|---|
I004 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | I003 |
---|---|
2nd row | I003 |
3rd row | I003 |
4th row | I003 |
5th row | I003 |
Common Values
Value | Count | Frequency (%) |
I003 | 630 | |
I004 | 370 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
i003 | 630 | |
i004 | 370 |
LIQD_PLAN_CD
Categorical
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 0.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2019S-01 | |
---|---|
KHFCMB2019S-22 | |
KHFCMB2017S-24 | |
KHFCMB2018S-07 | |
KHFCMB2013S-33 | 34 |
Other values (3) |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2013S-11 |
---|---|
2nd row | KHFCMB2013S-11 |
3rd row | KHFCMB2013S-11 |
4th row | KHFCMB2013S-11 |
5th row | KHFCMB2013S-11 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2019S-01 | 349 | |
KHFCMB2019S-22 | 253 | |
KHFCMB2017S-24 | 215 | |
KHFCMB2018S-07 | 78 | 7.8% |
KHFCMB2013S-33 | 34 | 3.4% |
KHFCMB2018S-25 | 33 | 3.3% |
KHFCMB2013S-11 | 32 | 3.2% |
KHFCMB2017S-21 | 6 | 0.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
khfcmb2019s-01 | 349 | |
khfcmb2019s-22 | 253 | |
khfcmb2017s-24 | 215 | |
khfcmb2018s-07 | 78 | 7.8% |
khfcmb2013s-33 | 34 | 3.4% |
khfcmb2018s-25 | 33 | 3.3% |
khfcmb2013s-11 | 32 | 3.2% |
khfcmb2017s-21 | 6 | 0.6% |
HOLD_CD
Categorical
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 0.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
I003-2019-0001 | |
---|---|
I004-2019-0001 | |
I003-2017-0001 | |
I004-2018-0001 | |
I003-2013-0003 | 34 |
Other values (3) |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | I003-2013-0001 |
---|---|
2nd row | I003-2013-0001 |
3rd row | I003-2013-0001 |
4th row | I003-2013-0001 |
5th row | I003-2013-0001 |
Common Values
Value | Count | Frequency (%) |
I003-2019-0001 | 349 | |
I004-2019-0001 | 253 | |
I003-2017-0001 | 215 | |
I004-2018-0001 | 78 | 7.8% |
I003-2013-0003 | 34 | 3.4% |
I004-2018-0002 | 33 | 3.3% |
I003-2013-0001 | 32 | 3.2% |
I004-2017-0002 | 6 | 0.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
i003-2019-0001 | 349 | |
i004-2019-0001 | 253 | |
i003-2017-0001 | 215 | |
i004-2018-0001 | 78 | 7.8% |
i003-2013-0003 | 34 | 3.4% |
i004-2018-0002 | 33 | 3.3% |
i003-2013-0001 | 32 | 3.2% |
i004-2017-0002 | 6 | 0.6% |
LOAN_ACC_NO
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 1000 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.4286176 × 1012 |
Minimum | 1.005501 × 1011 |
---|---|
Maximum | 9.9667971 × 1012 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1.005501 × 1011 |
---|---|
5-th percentile | 1.0300246 × 1011 |
Q1 | 1.0300254 × 1011 |
median | 2.7061047 × 1012 |
Q3 | 6.4349075 × 1012 |
95-th percentile | 9.2020358 × 1012 |
Maximum | 9.9667971 × 1012 |
Range | 9.866247 × 1012 |
Interquartile range (IQR) | 6.331905 × 1012 |
Descriptive statistics
Standard deviation | 3.3157322 × 1012 |
---|---|
Coefficient of variation (CV) | 0.96707554 |
Kurtosis | -1.22971 |
Mean | 3.4286176 × 1012 |
Median Absolute Deviation (MAD) | 2.6031022 × 1012 |
Skewness | 0.47401146 |
Sum | 3.4286176 × 1015 |
Variance | 1.099408 × 1025 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1523995100024 | 1 | 0.1% |
103002542440 | 1 | 0.1% |
103002543374 | 1 | 0.1% |
103002543349 | 1 | 0.1% |
103002543124 | 1 | 0.1% |
103002543085 | 1 | 0.1% |
103002543072 | 1 | 0.1% |
103002542870 | 1 | 0.1% |
103002542842 | 1 | 0.1% |
103002542841 | 1 | 0.1% |
Other values (990) | 990 |
Value | Count | Frequency (%) |
100550100051 | 1 | |
103002414151 | 1 | |
103002414163 | 1 | |
103002414179 | 1 | |
103002414211 | 1 | |
103002414265 | 1 | |
103002414593 | 1 | |
103002447781 | 1 | |
103002447788 | 1 | |
103002447790 | 1 |
Value | Count | Frequency (%) |
9966797100020 | 1 | |
9964684200005 | 1 | |
9930135200008 | 1 | |
9924515200001 | 1 | |
9922905200001 | 1 | |
9920135200008 | 1 | |
9887874200015 | 1 | |
9874324200011 | 1 | |
9871874200006 | 1 | |
9863174200009 | 1 |
BASIS_DY
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20200901 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20200901 |
---|---|
2nd row | 20200901 |
3rd row | 20200901 |
4th row | 20200901 |
5th row | 20200901 |
Common Values
Value | Count | Frequency (%) |
20200901 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20200901 | 1000 |
LOAN_RAMT
Real number (ℝ)
ZEROS
 
Distinct | 894 |
---|---|
Distinct (%) | 89.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.4277166 × 108 |
Minimum | 0 |
---|---|
Maximum | 4.750301 × 108 |
Zeros | 97 |
Zeros (%) | 9.7% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 77407467 |
median | 1.3799062 × 108 |
Q3 | 1.9564387 × 108 |
95-th percentile | 3.183975 × 108 |
Maximum | 4.750301 × 108 |
Range | 4.750301 × 108 |
Interquartile range (IQR) | 1.182364 × 108 |
Descriptive statistics
Standard deviation | 91816299 |
---|---|
Coefficient of variation (CV) | 0.6430989 |
Kurtosis | 0.38123324 |
Mean | 1.4277166 × 108 |
Median Absolute Deviation (MAD) | 59082585 |
Skewness | 0.60645011 |
Sum | 1.4277166 × 1011 |
Variance | 8.4302327 × 1015 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 97 | 9.7% |
203308259 | 2 | 0.2% |
135029961 | 2 | 0.2% |
151985608 | 2 | 0.2% |
230322110 | 2 | 0.2% |
172849696 | 2 | 0.2% |
143951312 | 2 | 0.2% |
116926163 | 2 | 0.2% |
123678497 | 2 | 0.2% |
201991993 | 2 | 0.2% |
Other values (884) | 885 |
Value | Count | Frequency (%) |
0 | 97 | |
9385707 | 1 | 0.1% |
9609257 | 1 | 0.1% |
14173667 | 1 | 0.1% |
17588697 | 1 | 0.1% |
17616083 | 1 | 0.1% |
18632354 | 1 | 0.1% |
19463214 | 1 | 0.1% |
24741774 | 1 | 0.1% |
27953414 | 1 | 0.1% |
Value | Count | Frequency (%) |
475030095 | 1 | |
468990923 | 1 | |
466614152 | 1 | |
460871521 | 1 | |
428644701 | 1 | |
420785861 | 1 | |
409374441 | 1 | |
396567563 | 1 | |
396076360 | 1 | |
395306385 | 1 |
APPLY_RAT
Real number (ℝ)
Distinct | 161 |
---|---|
Distinct (%) | 16.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.72102 |
Minimum | 2.32 |
---|---|
Maximum | 5.72 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 2.32 |
---|---|
5-th percentile | 2.8995 |
Q1 | 3.61 |
median | 3.81 |
Q3 | 3.92 |
95-th percentile | 4.17 |
Maximum | 5.72 |
Range | 3.4 |
Interquartile range (IQR) | 0.31 |
Descriptive statistics
Standard deviation | 0.39149793 |
---|---|
Coefficient of variation (CV) | 0.10521253 |
Kurtosis | 2.9011069 |
Mean | 3.72102 |
Median Absolute Deviation (MAD) | 0.16 |
Skewness | -0.65150703 |
Sum | 3721.02 |
Variance | 0.15327063 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3.81 | 85 | 8.5% |
3.91 | 46 | 4.6% |
3.87 | 43 | 4.3% |
3.92 | 40 | 4.0% |
3.67 | 32 | 3.2% |
4.02 | 28 | 2.8% |
3.77 | 26 | 2.6% |
3.74 | 26 | 2.6% |
3.9 | 23 | 2.3% |
3.73 | 21 | 2.1% |
Other values (151) | 630 |
Value | Count | Frequency (%) |
2.32 | 1 | 0.1% |
2.4 | 1 | 0.1% |
2.48 | 1 | 0.1% |
2.49 | 4 | |
2.5 | 3 | |
2.52 | 1 | 0.1% |
2.54 | 4 | |
2.6 | 2 | |
2.64 | 2 | |
2.69 | 1 | 0.1% |
Value | Count | Frequency (%) |
5.72 | 1 | |
5.46 | 1 | |
5.37 | 1 | |
5.29 | 1 | |
5.06 | 1 | |
4.88 | 1 | |
4.82 | 1 | |
4.66 | 1 | |
4.63 | 2 | |
4.62 | 1 |
STS
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
2 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2 |
---|---|
2nd row | 2 |
3rd row | 2 |
4th row | 2 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
2 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 1000 |
REG_ENO
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1769 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1769 |
---|---|
2nd row | 1769 |
3rd row | 1769 |
4th row | 1769 |
5th row | 1769 |
Common Values
Value | Count | Frequency (%) |
1769 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1769 | 1000 |
REG_DT
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
2020/10/13 20:19:14 | |
---|---|
2020/10/13 15:17:01 |
Length
Max length | 19 |
---|---|
Median length | 19 |
Mean length | 19 |
Min length | 19 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2020/10/13 20:19:14 |
---|---|
2nd row | 2020/10/13 20:19:14 |
3rd row | 2020/10/13 20:19:14 |
4th row | 2020/10/13 20:19:14 |
5th row | 2020/10/13 20:19:14 |
Common Values
Value | Count | Frequency (%) |
2020/10/13 20:19:14 | 630 | |
2020/10/13 15:17:01 | 370 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2020/10/13 | 1000 | |
20:19:14 | 630 | |
15:17:01 | 370 | 18.5% |
LOAN_ORG_CD | LIQD_PLAN_CD | HOLD_CD | LOAN_ACC_NO | LOAN_RAMT | APPLY_RAT | REG_DT | |
---|---|---|---|---|---|---|---|
LOAN_ORG_CD | 1.000 | 1.000 | 1.000 | 0.998 | 0.637 | 0.492 | 1.000 |
LIQD_PLAN_CD | 1.000 | 1.000 | 1.000 | 0.626 | 0.449 | 0.624 | 1.000 |
HOLD_CD | 1.000 | 1.000 | 1.000 | 0.626 | 0.449 | 0.624 | 1.000 |
LOAN_ACC_NO | 0.998 | 0.626 | 0.626 | 1.000 | 0.462 | 0.363 | 0.998 |
LOAN_RAMT | 0.637 | 0.449 | 0.449 | 0.462 | 1.000 | 0.199 | 0.637 |
APPLY_RAT | 0.492 | 0.624 | 0.624 | 0.363 | 0.199 | 1.000 | 0.492 |
REG_DT | 1.000 | 1.000 | 1.000 | 0.998 | 0.637 | 0.492 | 1.000 |
LOAN_ORG_CD | HOLD_CD | REG_DT | LIQD_PLAN_CD | |
---|---|---|---|---|
LOAN_ORG_CD | 1.000 | 0.997 | 0.998 | 0.997 |
HOLD_CD | 0.997 | 1.000 | 0.997 | 1.000 |
REG_DT | 0.998 | 0.997 | 1.000 | 0.997 |
LIQD_PLAN_CD | 0.997 | 1.000 | 0.997 | 1.000 |
LOAN_ACC_NO | LOAN_RAMT | APPLY_RAT | LOAN_ORG_CD | LIQD_PLAN_CD | HOLD_CD | REG_DT | |
---|---|---|---|---|---|---|---|
LOAN_ACC_NO | 1.000 | 0.439 | 0.152 | 0.950 | 0.360 | 0.360 | 0.950 |
LOAN_RAMT | 0.439 | 1.000 | 0.111 | 0.492 | 0.233 | 0.233 | 0.492 |
APPLY_RAT | 0.152 | 0.111 | 1.000 | 0.383 | 0.366 | 0.366 | 0.383 |
LOAN_ORG_CD | 0.950 | 0.492 | 0.383 | 1.000 | 0.997 | 0.997 | 0.998 |
LIQD_PLAN_CD | 0.360 | 0.233 | 0.366 | 0.997 | 1.000 | 1.000 | 0.997 |
HOLD_CD | 0.360 | 0.233 | 0.366 | 0.997 | 1.000 | 1.000 | 0.997 |
REG_DT | 0.950 | 0.492 | 0.383 | 0.998 | 0.997 | 0.997 | 1.000 |
LOAN_ORG_CD | LIQD_PLAN_CD | HOLD_CD | LOAN_ACC_NO | BASIS_DY | LOAN_RAMT | APPLY_RAT | STS | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|---|---|
0 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 1523995100024 | 20200901 | 41123502 | 2.7 | 2 | 1769 | 2020/10/13 20:19:14 |
1 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 7180282000071 | 20200901 | 82030919 | 5.46 | 2 | 1769 | 2020/10/13 20:19:14 |
2 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 6277611200004 | 20200901 | 33226161 | 5.06 | 2 | 1769 | 2020/10/13 20:19:14 |
3 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 6598860200010 | 20200901 | 69814933 | 3.1 | 2 | 1769 | 2020/10/13 20:19:14 |
4 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 5660776100032 | 20200901 | 72122991 | 5.29 | 2 | 1769 | 2020/10/13 20:19:14 |
5 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 2465190200014 | 20200901 | 228049188 | 2.72 | 2 | 1769 | 2020/10/13 20:19:14 |
6 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 1579455000043 | 20200901 | 63597767 | 2.64 | 2 | 1769 | 2020/10/13 20:19:14 |
7 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 5750536000009 | 20200901 | 181325153 | 2.5 | 2 | 1769 | 2020/10/13 20:19:14 |
8 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 6354310200010 | 20200901 | 207918255 | 2.64 | 2 | 1769 | 2020/10/13 20:19:14 |
9 | I003 | KHFCMB2013S-11 | I003-2013-0001 | 7234900200006 | 20200901 | 31837784 | 2.4 | 2 | 1769 | 2020/10/13 20:19:14 |
LOAN_ORG_CD | LIQD_PLAN_CD | HOLD_CD | LOAN_ACC_NO | BASIS_DY | LOAN_RAMT | APPLY_RAT | STS | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|---|---|
990 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002535085 | 20200901 | 0 | 3.59 | 2 | 1769 | 2020/10/13 15:17:01 |
991 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002535036 | 20200901 | 75625001 | 3.62 | 2 | 1769 | 2020/10/13 15:17:01 |
992 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534668 | 20200901 | 87328285 | 3.7 | 2 | 1769 | 2020/10/13 15:17:01 |
993 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534641 | 20200901 | 0 | 3.63 | 2 | 1769 | 2020/10/13 15:17:01 |
994 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534388 | 20200901 | 0 | 3.7 | 2 | 1769 | 2020/10/13 15:17:01 |
995 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534385 | 20200901 | 94135020 | 3.73 | 2 | 1769 | 2020/10/13 15:17:01 |
996 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534364 | 20200901 | 132489247 | 3.74 | 2 | 1769 | 2020/10/13 15:17:01 |
997 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534342 | 20200901 | 150398711 | 3.7 | 2 | 1769 | 2020/10/13 15:17:01 |
998 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534337 | 20200901 | 52879863 | 3.59 | 2 | 1769 | 2020/10/13 15:17:01 |
999 | I004 | KHFCMB2019S-22 | I004-2019-0001 | 103002534325 | 20200901 | 237361391 | 3.89 | 2 | 1769 | 2020/10/13 15:17:01 |