Dataset statistics
Number of variables | 20 |
---|---|
Number of observations | 1000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 170.1 KiB |
Average record size in memory | 174.1 B |
Variable types
Categorical | 10 |
---|---|
Numeric | 8 |
Boolean | 2 |
Dataset
Description | 한국주택금융공사 신탁자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073030/fileData.do |
LIQD_PLAN_CD has constant value "" | Constant |
RPT_OFFER_SEQ has constant value "" | Constant |
ONLIN_YN has constant value "" | Constant |
DOC_OFFER_DY has constant value "" | Constant |
REG_ENO has constant value "" | Constant |
REG_DT is highly overall correlated with LOAN_ACC_NO and 6 other fields | High correlation |
WRT_BASIS_DY is highly overall correlated with LOAN_ACC_NO and 6 other fields | High correlation |
ARCV_RECVBLE_DVCD is highly overall correlated with DEMND_DY and 1 other fields | High correlation |
LEDGER_PRCSS_YN is highly overall correlated with DEMND_DY and 1 other fields | High correlation |
TREAT_ORG_CD is highly overall correlated with LOAN_ACC_NO and 5 other fields | High correlation |
HOLD_CD is highly overall correlated with SEQ and 4 other fields | High correlation |
LOAN_ACC_NO is highly overall correlated with WRT_BASIS_DY and 2 other fields | High correlation |
SEQ is highly overall correlated with TELGRM_SEQ and 4 other fields | High correlation |
TELGRM_SEQ is highly overall correlated with SEQ and 2 other fields | High correlation |
OCCR_SEQ is highly overall correlated with HOLD_CD and 3 other fields | High correlation |
DEMND_DY is highly overall correlated with CALC_DCNT and 4 other fields | High correlation |
ICALC_TRGT_AMT is highly overall correlated with INT_CALC_AMT | High correlation |
CALC_DCNT is highly overall correlated with DEMND_DY and 1 other fields | High correlation |
INT_CALC_AMT is highly overall correlated with DEMND_DY and 2 other fields | High correlation |
DMCUT_CALC_DVCD is highly overall correlated with DEMND_DY | High correlation |
ARCV_RECVBLE_DVCD is highly imbalanced (91.9%) | Imbalance |
DMCUT_CALC_DVCD is highly imbalanced (97.1%) | Imbalance |
LEDGER_PRCSS_YN is highly imbalanced (91.9%) | Imbalance |
CALC_DCNT has 19 (1.9%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 20:26:33.384958 |
---|---|
Analysis finished | 2023-12-12 20:26:43.661591 |
Duration | 10.28 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-31 |
---|
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2020S-31 |
---|---|
2nd row | KHFCMB2020S-31 |
3rd row | KHFCMB2020S-31 |
4th row | KHFCMB2020S-31 |
5th row | KHFCMB2020S-31 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2020S-31 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
khfcmb2020s-31 | 1000 |
HOLD_CD
Categorical
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B023-2020-0034 | |
---|---|
B023-2020-0035 | |
B027-2020-0006 | |
B003-2020-0072 | |
B003-2020-0073 |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | B023-2020-0035 |
---|---|
2nd row | B023-2020-0034 |
3rd row | B023-2020-0035 |
4th row | B023-2020-0035 |
5th row | B023-2020-0035 |
Common Values
Value | Count | Frequency (%) |
B023-2020-0034 | 452 | |
B023-2020-0035 | 260 | |
B027-2020-0006 | 96 | 9.6% |
B003-2020-0072 | 90 | 9.0% |
B003-2020-0073 | 88 | 8.8% |
B039-2020-0045 | 14 | 1.4% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
b023-2020-0034 | 452 | |
b023-2020-0035 | 260 | |
b027-2020-0006 | 96 | 9.6% |
b003-2020-0072 | 90 | 9.0% |
b003-2020-0073 | 88 | 8.8% |
b039-2020-0045 | 14 | 1.4% |
LOAN_ACC_NO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 993 |
---|---|
Distinct (%) | 99.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.1437912 × 1015 |
Minimum | 1.0073123 × 1010 |
---|---|
Maximum | 9.9700491 × 1015 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1.0073123 × 1010 |
---|---|
5-th percentile | 3.0163076 × 1010 |
Q1 | 6.0448019 × 1010 |
median | 6.5873134 × 1010 |
Q3 | 6.388804 × 1013 |
95-th percentile | 6.7302414 × 1015 |
Maximum | 9.9700491 × 1015 |
Range | 9.970039 × 1015 |
Interquartile range (IQR) | 6.3827592 × 1013 |
Descriptive statistics
Standard deviation | 2.5510455 × 1015 |
---|---|
Coefficient of variation (CV) | 2.2303419 |
Kurtosis | 3.1831693 |
Mean | 1.1437912 × 1015 |
Median Absolute Deviation (MAD) | 1.0200038 × 1010 |
Skewness | 2.0950794 |
Sum | 1.1437912 × 1018 |
Variance | 6.507833 × 1030 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
35873045164 | 5 | 0.5% |
4900717063200032 | 2 | 0.2% |
48073069165 | 2 | 0.2% |
64473138957 | 2 | 0.2% |
25573004355 | 1 | 0.1% |
25073102330 | 1 | 0.1% |
25173064272 | 1 | 0.1% |
25173064443 | 1 | 0.1% |
25573004311 | 1 | 0.1% |
25573004816 | 1 | 0.1% |
Other values (983) | 983 |
Value | Count | Frequency (%) |
10073122584 | 1 | |
10273024188 | 1 | |
11173088749 | 1 | |
11773066039 | 1 | |
11773066136 | 1 | |
12873089126 | 1 | |
15273038864 | 1 | |
15273038905 | 1 | |
15273039376 | 1 | |
15773119568 | 1 |
Value | Count | Frequency (%) |
9970049073200031 | 1 | |
9970049003200032 | 1 | |
9970048883200031 | 1 | |
9970048873200033 | 1 | |
9970048803200033 | 1 | |
9970048763200032 | 1 | |
9970048423200031 | 1 | |
9940071623200031 | 1 | |
9930067433200032 | 1 | |
9930066813200033 | 1 |
SEQ
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 986 |
---|---|
Distinct (%) | 98.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1587888.4 |
Minimum | 1587070 |
---|---|
Maximum | 1588467 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1587070 |
---|---|
5-th percentile | 1587105.9 |
Q1 | 1587526.8 |
median | 1587967.5 |
Q3 | 1588217.2 |
95-th percentile | 1588417.1 |
Maximum | 1588467 |
Range | 1397 |
Interquartile range (IQR) | 690.5 |
Descriptive statistics
Standard deviation | 403.54783 |
---|---|
Coefficient of variation (CV) | 0.00025414118 |
Kurtosis | -0.77098625 |
Mean | 1587888.4 |
Median Absolute Deviation (MAD) | 288 |
Skewness | -0.56025052 |
Sum | 1.5878884 × 109 |
Variance | 162850.85 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1587076 | 2 | 0.2% |
1587071 | 2 | 0.2% |
1587080 | 2 | 0.2% |
1587079 | 2 | 0.2% |
1587078 | 2 | 0.2% |
1587077 | 2 | 0.2% |
1587083 | 2 | 0.2% |
1587075 | 2 | 0.2% |
1587074 | 2 | 0.2% |
1587073 | 2 | 0.2% |
Other values (976) | 980 |
Value | Count | Frequency (%) |
1587070 | 2 | |
1587071 | 2 | |
1587072 | 2 | |
1587073 | 2 | |
1587074 | 2 | |
1587075 | 2 | |
1587076 | 2 | |
1587077 | 2 | |
1587078 | 2 | |
1587079 | 2 |
Value | Count | Frequency (%) |
1588467 | 1 | |
1588466 | 1 | |
1588465 | 1 | |
1588464 | 1 | |
1588463 | 1 | |
1588462 | 1 | |
1588461 | 1 | |
1588460 | 1 | |
1588459 | 1 | |
1588458 | 1 |
WRT_BASIS_DY
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20200922 | |
---|---|
20200921 |
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20200922 |
---|---|
2nd row | 20200922 |
3rd row | 20200922 |
4th row | 20200922 |
5th row | 20200922 |
Common Values
Value | Count | Frequency (%) |
20200922 | 822 | |
20200921 | 178 | 17.8% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20200922 | 822 | |
20200921 | 178 | 17.8% |
TREAT_ORG_CD
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
B023 | |
---|---|
B003 | |
B027 | |
B039 | 14 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | B023 |
---|---|
2nd row | B023 |
3rd row | B023 |
4th row | B023 |
5th row | B023 |
Common Values
Value | Count | Frequency (%) |
B023 | 712 | |
B003 | 178 | 17.8% |
B027 | 96 | 9.6% |
B039 | 14 | 1.4% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
b023 | 712 | |
b003 | 178 | 17.8% |
b027 | 96 | 9.6% |
b039 | 14 | 1.4% |
RPT_OFFER_SEQ
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 |
ONLIN_YN
Boolean
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.1 KiB |
True |
---|
Value | Count | Frequency (%) |
True | 1000 |
TELGRM_SEQ
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 712 |
---|---|
Distinct (%) | 71.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 330.234 |
Minimum | 1 |
---|---|
Maximum | 712 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 18.95 |
Q1 | 140.75 |
median | 352 |
Q3 | 477 |
95-th percentile | 662.05 |
Maximum | 712 |
Range | 711 |
Interquartile range (IQR) | 336.25 |
Descriptive statistics
Standard deviation | 202.88567 |
---|---|
Coefficient of variation (CV) | 0.61436942 |
Kurtosis | -1.0917175 |
Mean | 330.234 |
Median Absolute Deviation (MAD) | 161 |
Skewness | -0.015352062 |
Sum | 330234 |
Variance | 41162.596 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
11 | 3 | 0.3% |
7 | 3 | 0.3% |
14 | 3 | 0.3% |
13 | 3 | 0.3% |
12 | 3 | 0.3% |
10 | 3 | 0.3% |
9 | 3 | 0.3% |
8 | 3 | 0.3% |
6 | 3 | 0.3% |
5 | 3 | 0.3% |
Other values (702) | 970 |
Value | Count | Frequency (%) |
1 | 3 | |
2 | 3 | |
3 | 3 | |
4 | 3 | |
5 | 3 | |
6 | 3 | |
7 | 3 | |
8 | 3 | |
9 | 3 | |
10 | 3 |
Value | Count | Frequency (%) |
712 | 1 | |
711 | 1 | |
710 | 1 | |
709 | 1 | |
708 | 1 | |
707 | 1 | |
706 | 1 | |
705 | 1 | |
704 | 1 | |
703 | 1 |
DOC_OFFER_DY
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20200922 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20200922 |
---|---|
2nd row | 20200922 |
3rd row | 20200922 |
4th row | 20200922 |
5th row | 20200922 |
Common Values
Value | Count | Frequency (%) |
20200922 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20200922 | 1000 |
ARCV_RECVBLE_DVCD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
2 | |
---|---|
1 | 10 |
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 | 990 | |
1 | 10 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 990 | |
1 | 10 | 1.0% |
DMCUT_CALC_DVCD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
2 | 3 |
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 | 997 | |
2 | 3 | 0.3% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 997 | |
2 | 3 | 0.3% |
OCCR_SEQ
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 0.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4.798 |
Minimum | 1 |
---|---|
Maximum | 8 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 2 |
Q1 | 4 |
median | 5 |
Q3 | 5 |
95-th percentile | 7 |
Maximum | 8 |
Range | 7 |
Interquartile range (IQR) | 1 |
Descriptive statistics
Standard deviation | 1.2323614 |
---|---|
Coefficient of variation (CV) | 0.25684899 |
Kurtosis | 1.4010098 |
Mean | 4.798 |
Median Absolute Deviation (MAD) | 0 |
Skewness | -0.63683837 |
Sum | 4798 |
Variance | 1.5187147 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
5 | 541 | |
4 | 175 | 17.5% |
7 | 97 | 9.7% |
6 | 76 | 7.6% |
2 | 45 | 4.5% |
3 | 44 | 4.4% |
1 | 20 | 2.0% |
8 | 2 | 0.2% |
Value | Count | Frequency (%) |
1 | 20 | 2.0% |
2 | 45 | 4.5% |
3 | 44 | 4.4% |
4 | 175 | 17.5% |
5 | 541 | |
6 | 76 | 7.6% |
7 | 97 | 9.7% |
8 | 2 | 0.2% |
Value | Count | Frequency (%) |
8 | 2 | 0.2% |
7 | 97 | 9.7% |
6 | 76 | 7.6% |
5 | 541 | |
4 | 175 | 17.5% |
3 | 44 | 4.4% |
2 | 45 | 4.5% |
1 | 20 | 2.0% |
DEMND_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 40 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20200879 |
Minimum | 20200819 |
---|---|
Maximum | 20201031 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20200819 |
---|---|
5-th percentile | 20200824 |
Q1 | 20200825 |
median | 20200907 |
Q3 | 20200915 |
95-th percentile | 20200922 |
Maximum | 20201031 |
Range | 212 |
Interquartile range (IQR) | 90 |
Descriptive statistics
Standard deviation | 46.090542 |
---|---|
Coefficient of variation (CV) | 2.2816108 × 10-6 |
Kurtosis | -1.022156 |
Mean | 20200879 |
Median Absolute Deviation (MAD) | 15 |
Skewness | -0.044422269 |
Sum | 2.0200879 × 1010 |
Variance | 2124.338 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20200824 | 188 | |
20200922 | 111 | 11.1% |
20200909 | 74 | 7.4% |
20200914 | 72 | 7.2% |
20200919 | 67 | 6.7% |
20200904 | 54 | 5.4% |
20200825 | 44 | 4.4% |
20200829 | 31 | 3.1% |
20200826 | 29 | 2.9% |
20200920 | 27 | 2.7% |
Other values (30) | 303 |
Value | Count | Frequency (%) |
20200819 | 2 | 0.2% |
20200820 | 1 | 0.1% |
20200821 | 11 | 1.1% |
20200822 | 25 | 2.5% |
20200823 | 11 | 1.1% |
20200824 | 188 | |
20200825 | 44 | 4.4% |
20200826 | 29 | 2.9% |
20200827 | 11 | 1.1% |
20200828 | 10 | 1.0% |
Value | Count | Frequency (%) |
20201031 | 5 | 0.5% |
20201024 | 2 | 0.2% |
20201023 | 2 | 0.2% |
20200929 | 1 | 0.1% |
20200924 | 2 | 0.2% |
20200923 | 1 | 0.1% |
20200922 | 111 | |
20200920 | 27 | 2.7% |
20200919 | 67 | |
20200918 | 5 | 0.5% |
ICALC_TRGT_AMT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 857 |
---|---|
Distinct (%) | 85.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.589274 × 108 |
Minimum | 11993 |
---|---|
Maximum | 4.9819199 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 11993 |
---|---|
5-th percentile | 40413982 |
Q1 | 97023597 |
median | 1.4774337 × 108 |
Q3 | 2.1325901 × 108 |
95-th percentile | 3.0919447 × 108 |
Maximum | 4.9819199 × 108 |
Range | 4.9818 × 108 |
Interquartile range (IQR) | 1.1623542 × 108 |
Descriptive statistics
Standard deviation | 86245654 |
---|---|
Coefficient of variation (CV) | 0.5426733 |
Kurtosis | 0.77528017 |
Mean | 1.589274 × 108 |
Median Absolute Deviation (MAD) | 57589246 |
Skewness | 0.81644598 |
Sum | 1.589274 × 1011 |
Variance | 7.4383129 × 1015 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
148885099 | 9 | 0.9% |
99256733 | 8 | 0.8% |
297770200 | 6 | 0.6% |
238216163 | 5 | 0.5% |
218364816 | 5 | 0.5% |
99456988 | 5 | 0.5% |
208439141 | 5 | 0.5% |
178662122 | 4 | 0.4% |
109182410 | 4 | 0.4% |
143922266 | 4 | 0.4% |
Other values (847) | 945 |
Value | Count | Frequency (%) |
11993 | 2 | |
12897 | 1 | |
57612 | 1 | |
8570806 | 1 | |
9259732 | 1 | |
19857693 | 1 | |
19863602 | 1 | |
21140667 | 1 | |
21142000 | 1 | |
21836482 | 1 |
Value | Count | Frequency (%) |
498191992 | 1 | |
496363650 | 1 | |
495732117 | 1 | |
495472291 | 1 | |
470681782 | 1 | |
453703974 | 1 | |
427067441 | 1 | |
425314296 | 1 | |
418202910 | 1 | |
416960814 | 1 |
CALC_DCNT
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 35 |
---|---|
Distinct (%) | 3.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 17.045 |
Minimum | 0 |
---|---|
Maximum | 35 |
Zeros | 19 |
Zeros (%) | 1.9% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 2 |
Q1 | 8 |
median | 17 |
Q3 | 28 |
95-th percentile | 29 |
Maximum | 35 |
Range | 35 |
Interquartile range (IQR) | 20 |
Descriptive statistics
Standard deviation | 9.9529914 |
---|---|
Coefficient of variation (CV) | 0.5839244 |
Kurtosis | -1.4450868 |
Mean | 17.045 |
Median Absolute Deviation (MAD) | 10 |
Skewness | -0.19589378 |
Sum | 17045 |
Variance | 99.062037 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
28 | 192 | |
12 | 75 | 7.5% |
7 | 74 | 7.4% |
2 | 72 | 7.2% |
27 | 54 | 5.4% |
17 | 54 | 5.4% |
23 | 39 | 3.9% |
22 | 31 | 3.1% |
10 | 30 | 3.0% |
30 | 30 | 3.0% |
Other values (25) | 349 |
Value | Count | Frequency (%) |
0 | 19 | 1.9% |
1 | 29 | 2.9% |
2 | 72 | |
3 | 11 | 1.1% |
4 | 11 | 1.1% |
5 | 15 | 1.5% |
6 | 15 | 1.5% |
7 | 74 | |
8 | 21 | 2.1% |
9 | 25 | 2.5% |
Value | Count | Frequency (%) |
35 | 1 | 0.1% |
33 | 2 | 0.2% |
32 | 1 | 0.1% |
31 | 12 | 1.2% |
30 | 30 | 3.0% |
29 | 15 | 1.5% |
28 | 192 | |
27 | 54 | 5.4% |
26 | 30 | 3.0% |
25 | 21 | 2.1% |
INT_CALC_AMT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 956 |
---|---|
Distinct (%) | 95.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 195485.67 |
Minimum | 0 |
---|---|
Maximum | 918555 |
Zeros | 2 |
Zeros (%) | 0.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 16372.75 |
Q1 | 68188 |
median | 150721 |
Q3 | 288371.25 |
95-th percentile | 523171 |
Maximum | 918555 |
Range | 918555 |
Interquartile range (IQR) | 220183.25 |
Descriptive statistics
Standard deviation | 163740.4 |
---|---|
Coefficient of variation (CV) | 0.83760823 |
Kurtosis | 1.483391 |
Mean | 195485.67 |
Median Absolute Deviation (MAD) | 100373.5 |
Skewness | 1.2235447 |
Sum | 1.9548567 × 108 |
Variance | 2.681092 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
72611 | 4 | 0.4% |
193631 | 4 | 0.4% |
145223 | 3 | 0.3% |
290447 | 3 | 0.3% |
88043 | 3 | 0.3% |
103650 | 3 | 0.3% |
130701 | 2 | 0.2% |
425990 | 2 | 0.2% |
369837 | 2 | 0.2% |
21238 | 2 | 0.2% |
Other values (946) | 972 |
Value | Count | Frequency (%) |
0 | 2 | |
7 | 1 | |
8 | 1 | |
12 | 1 | |
25 | 1 | |
4263 | 1 | |
4495 | 1 | |
4999 | 1 | |
5083 | 1 | |
5107 | 1 |
Value | Count | Frequency (%) |
918555 | 1 | |
867231 | 1 | |
864453 | 1 | |
860336 | 1 | |
852103 | 1 | |
808541 | 1 | |
793885 | 1 | |
693177 | 1 | |
685180 | 1 | |
670823 | 1 |
LEDGER_PRCSS_YN
Boolean
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.1 KiB |
True | |
---|---|
False | 10 |
Value | Count | Frequency (%) |
True | 990 | |
False | 10 | 1.0% |
REG_ENO
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1841 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1841 |
---|---|
2nd row | 1841 |
3rd row | 1841 |
4th row | 1841 |
5th row | 1841 |
Common Values
Value | Count | Frequency (%) |
1841 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1841 | 1000 |
REG_DT
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 0.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
2020/10/13 14:54:00 | |
---|---|
2020/10/13 14:53:58 | |
2020/10/13 14:53:59 |
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 14:54:00 |
---|---|
2nd row | 2020/10/13 14:54:00 |
3rd row | 2020/10/13 14:54:00 |
4th row | 2020/10/13 14:54:00 |
5th row | 2020/10/13 14:54:00 |
Common Values
Value | Count | Frequency (%) |
2020/10/13 14:54:00 | 712 | |
2020/10/13 14:53:58 | 178 | 17.8% |
2020/10/13 14:53:59 | 110 | 11.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2020/10/13 | 1000 | |
14:54:00 | 712 | |
14:53:58 | 178 | 8.9% |
14:53:59 | 110 | 5.5% |
HOLD_CD | LOAN_ACC_NO | SEQ | WRT_BASIS_DY | TREAT_ORG_CD | TELGRM_SEQ | ARCV_RECVBLE_DVCD | DMCUT_CALC_DVCD | OCCR_SEQ | DEMND_DY | ICALC_TRGT_AMT | CALC_DCNT | INT_CALC_AMT | LEDGER_PRCSS_YN | REG_DT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HOLD_CD | 1.000 | 0.831 | 0.855 | 1.000 | 1.000 | 0.616 | 0.064 | 0.000 | 0.833 | 0.263 | 0.311 | 0.366 | 0.169 | 0.064 | 1.000 |
LOAN_ACC_NO | 0.831 | 1.000 | 0.835 | 1.000 | 0.739 | 0.650 | 0.113 | 0.000 | 0.646 | 0.095 | 0.281 | 0.240 | 0.000 | 0.113 | 0.941 |
SEQ | 0.855 | 0.835 | 1.000 | 1.000 | 0.895 | 0.904 | 0.067 | 0.000 | 0.770 | 0.335 | 0.282 | 0.279 | 0.146 | 0.067 | 1.000 |
WRT_BASIS_DY | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.741 | 0.000 | 0.000 | 0.998 | 0.130 | 0.310 | 0.354 | 0.114 | 0.000 | 1.000 |
TREAT_ORG_CD | 1.000 | 0.739 | 0.895 | 1.000 | 1.000 | 0.688 | 0.000 | 0.000 | 0.980 | 0.252 | 0.303 | 0.418 | 0.121 | 0.000 | 1.000 |
TELGRM_SEQ | 0.616 | 0.650 | 0.904 | 0.741 | 0.688 | 1.000 | 0.089 | 0.000 | 0.560 | 0.303 | 0.214 | 0.224 | 0.000 | 0.089 | 0.732 |
ARCV_RECVBLE_DVCD | 0.064 | 0.113 | 0.067 | 0.000 | 0.000 | 0.089 | 1.000 | 0.653 | 0.586 | 0.582 | 0.058 | 0.238 | 0.000 | 0.997 | 0.000 |
DMCUT_CALC_DVCD | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.653 | 1.000 | 0.556 | 0.472 | 0.000 | 0.137 | 0.124 | 0.653 | 0.000 |
OCCR_SEQ | 0.833 | 0.646 | 0.770 | 0.998 | 0.980 | 0.560 | 0.586 | 0.556 | 1.000 | 0.485 | 0.272 | 0.321 | 0.181 | 0.586 | 0.959 |
DEMND_DY | 0.263 | 0.095 | 0.335 | 0.130 | 0.252 | 0.303 | 0.582 | 0.472 | 0.485 | 1.000 | 0.000 | 0.940 | 0.626 | 0.582 | 0.324 |
ICALC_TRGT_AMT | 0.311 | 0.281 | 0.282 | 0.310 | 0.303 | 0.214 | 0.058 | 0.000 | 0.272 | 0.000 | 1.000 | 0.117 | 0.805 | 0.058 | 0.354 |
CALC_DCNT | 0.366 | 0.240 | 0.279 | 0.354 | 0.418 | 0.224 | 0.238 | 0.137 | 0.321 | 0.940 | 0.117 | 1.000 | 0.674 | 0.238 | 0.377 |
INT_CALC_AMT | 0.169 | 0.000 | 0.146 | 0.114 | 0.121 | 0.000 | 0.000 | 0.124 | 0.181 | 0.626 | 0.805 | 0.674 | 1.000 | 0.000 | 0.157 |
LEDGER_PRCSS_YN | 0.064 | 0.113 | 0.067 | 0.000 | 0.000 | 0.089 | 0.997 | 0.653 | 0.586 | 0.582 | 0.058 | 0.238 | 0.000 | 1.000 | 0.000 |
REG_DT | 1.000 | 0.941 | 1.000 | 1.000 | 1.000 | 0.732 | 0.000 | 0.000 | 0.959 | 0.324 | 0.354 | 0.377 | 0.157 | 0.000 | 1.000 |
REG_DT | WRT_BASIS_DY | ARCV_RECVBLE_DVCD | DMCUT_CALC_DVCD | LEDGER_PRCSS_YN | TREAT_ORG_CD | HOLD_CD | |
---|---|---|---|---|---|---|---|
REG_DT | 1.000 | 0.999 | 0.000 | 0.000 | 0.000 | 0.999 | 0.998 |
WRT_BASIS_DY | 0.999 | 1.000 | 0.000 | 0.000 | 0.000 | 0.999 | 0.998 |
ARCV_RECVBLE_DVCD | 0.000 | 0.000 | 1.000 | 0.453 | 0.949 | 0.000 | 0.046 |
DMCUT_CALC_DVCD | 0.000 | 0.000 | 0.453 | 1.000 | 0.453 | 0.000 | 0.000 |
LEDGER_PRCSS_YN | 0.000 | 0.000 | 0.949 | 0.453 | 1.000 | 0.000 | 0.046 |
TREAT_ORG_CD | 0.999 | 0.999 | 0.000 | 0.000 | 0.000 | 1.000 | 0.999 |
HOLD_CD | 0.998 | 0.998 | 0.046 | 0.000 | 0.046 | 0.999 | 1.000 |
LOAN_ACC_NO | SEQ | TELGRM_SEQ | OCCR_SEQ | DEMND_DY | ICALC_TRGT_AMT | CALC_DCNT | INT_CALC_AMT | HOLD_CD | WRT_BASIS_DY | TREAT_ORG_CD | ARCV_RECVBLE_DVCD | DMCUT_CALC_DVCD | LEDGER_PRCSS_YN | REG_DT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LOAN_ACC_NO | 1.000 | -0.230 | 0.425 | 0.260 | 0.284 | -0.060 | -0.149 | -0.138 | 0.446 | 0.998 | 0.574 | 0.081 | 0.000 | 0.081 | 0.704 |
SEQ | -0.230 | 1.000 | 0.740 | -0.028 | -0.409 | -0.103 | 0.151 | 0.031 | 0.630 | 0.996 | 0.813 | 0.067 | 0.000 | 0.067 | 0.997 |
TELGRM_SEQ | 0.425 | 0.740 | 1.000 | 0.352 | -0.269 | -0.054 | 0.017 | -0.049 | 0.382 | 0.579 | 0.488 | 0.068 | 0.000 | 0.068 | 0.596 |
OCCR_SEQ | 0.260 | -0.028 | 0.352 | 1.000 | -0.149 | 0.222 | -0.154 | -0.017 | 0.658 | 0.953 | 0.807 | 0.442 | 0.418 | 0.442 | 0.972 |
DEMND_DY | 0.284 | -0.409 | -0.269 | -0.149 | 1.000 | -0.054 | -0.804 | -0.637 | 0.182 | 0.160 | 0.208 | 0.702 | 0.572 | 0.702 | 0.259 |
ICALC_TRGT_AMT | -0.060 | -0.103 | -0.054 | 0.222 | -0.054 | 1.000 | -0.050 | 0.543 | 0.167 | 0.238 | 0.184 | 0.045 | 0.000 | 0.045 | 0.226 |
CALC_DCNT | -0.149 | 0.151 | 0.017 | -0.154 | -0.804 | -0.050 | 1.000 | 0.719 | 0.213 | 0.336 | 0.273 | 0.189 | 0.105 | 0.189 | 0.265 |
INT_CALC_AMT | -0.138 | 0.031 | -0.049 | -0.017 | -0.637 | 0.543 | 0.719 | 1.000 | 0.089 | 0.087 | 0.072 | 0.000 | 0.094 | 0.000 | 0.094 |
HOLD_CD | 0.446 | 0.630 | 0.382 | 0.658 | 0.182 | 0.167 | 0.213 | 0.089 | 1.000 | 0.998 | 0.999 | 0.046 | 0.000 | 0.046 | 0.998 |
WRT_BASIS_DY | 0.998 | 0.996 | 0.579 | 0.953 | 0.160 | 0.238 | 0.336 | 0.087 | 0.998 | 1.000 | 0.999 | 0.000 | 0.000 | 0.000 | 0.999 |
TREAT_ORG_CD | 0.574 | 0.813 | 0.488 | 0.807 | 0.208 | 0.184 | 0.273 | 0.072 | 0.999 | 0.999 | 1.000 | 0.000 | 0.000 | 0.000 | 0.999 |
ARCV_RECVBLE_DVCD | 0.081 | 0.067 | 0.068 | 0.442 | 0.702 | 0.045 | 0.189 | 0.000 | 0.046 | 0.000 | 0.000 | 1.000 | 0.453 | 0.949 | 0.000 |
DMCUT_CALC_DVCD | 0.000 | 0.000 | 0.000 | 0.418 | 0.572 | 0.000 | 0.105 | 0.094 | 0.000 | 0.000 | 0.000 | 0.453 | 1.000 | 0.453 | 0.000 |
LEDGER_PRCSS_YN | 0.081 | 0.067 | 0.068 | 0.442 | 0.702 | 0.045 | 0.189 | 0.000 | 0.046 | 0.000 | 0.000 | 0.949 | 0.453 | 1.000 | 0.000 |
REG_DT | 0.704 | 0.997 | 0.596 | 0.972 | 0.259 | 0.226 | 0.265 | 0.094 | 0.998 | 0.999 | 0.999 | 0.000 | 0.000 | 0.000 | 1.000 |
LIQD_PLAN_CD | HOLD_CD | LOAN_ACC_NO | SEQ | WRT_BASIS_DY | TREAT_ORG_CD | RPT_OFFER_SEQ | ONLIN_YN | TELGRM_SEQ | DOC_OFFER_DY | ARCV_RECVBLE_DVCD | DMCUT_CALC_DVCD | OCCR_SEQ | DEMND_DY | ICALC_TRGT_AMT | CALC_DCNT | INT_CALC_AMT | LEDGER_PRCSS_YN | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | KHFCMB2020S-31 | B023-2020-0035 | 80073070812 | 1588467 | 20200922 | B023 | 1 | Y | 712 | 20200922 | 2 | 1 | 5 | 20200825 | 181703224 | 27 | 376661 | Y | 1841 | 2020/10/13 14:54:00 |
1 | KHFCMB2020S-31 | B023-2020-0034 | 79573117704 | 1588466 | 20200922 | B023 | 1 | Y | 711 | 20200922 | 2 | 1 | 5 | 20200824 | 119108081 | 28 | 232358 | Y | 1841 | 2020/10/13 14:54:00 |
2 | KHFCMB2020S-31 | B023-2020-0035 | 79573117533 | 1588465 | 20200922 | B023 | 1 | Y | 710 | 20200922 | 2 | 1 | 5 | 20200824 | 93357834 | 28 | 217834 | Y | 1841 | 2020/10/13 14:54:00 |
3 | KHFCMB2020S-31 | B023-2020-0035 | 79573117522 | 1588464 | 20200922 | B023 | 1 | Y | 709 | 20200922 | 2 | 1 | 5 | 20200824 | 72997882 | 28 | 170328 | Y | 1841 | 2020/10/13 14:54:00 |
4 | KHFCMB2020S-31 | B023-2020-0035 | 79573117470 | 1588463 | 20200922 | B023 | 1 | Y | 708 | 20200922 | 2 | 1 | 5 | 20200914 | 158634280 | 7 | 92840 | Y | 1841 | 2020/10/13 14:54:00 |
5 | KHFCMB2020S-31 | B023-2020-0035 | 79573117458 | 1588462 | 20200922 | B023 | 1 | Y | 707 | 20200922 | 2 | 1 | 5 | 20200919 | 98400000 | 2 | 15378 | Y | 1841 | 2020/10/13 14:54:00 |
6 | KHFCMB2020S-31 | B023-2020-0034 | 78473018383 | 1588461 | 20200922 | B023 | 1 | Y | 706 | 20200922 | 2 | 1 | 5 | 20200909 | 105212139 | 12 | 87964 | Y | 1841 | 2020/10/13 14:54:00 |
7 | KHFCMB2020S-31 | B023-2020-0035 | 78473018060 | 1588460 | 20200922 | B023 | 1 | Y | 705 | 20200922 | 2 | 1 | 5 | 20200829 | 180756662 | 23 | 346450 | Y | 1841 | 2020/10/13 14:54:00 |
8 | KHFCMB2020S-31 | B023-2020-0034 | 78473018015 | 1588459 | 20200922 | B023 | 1 | Y | 704 | 20200922 | 2 | 1 | 5 | 20200824 | 106725954 | 28 | 187791 | Y | 1841 | 2020/10/13 14:54:00 |
9 | KHFCMB2020S-31 | B023-2020-0035 | 78473017882 | 1588458 | 20200922 | B023 | 1 | Y | 703 | 20200922 | 2 | 1 | 5 | 20200824 | 101992326 | 28 | 238762 | Y | 1841 | 2020/10/13 14:54:00 |
LIQD_PLAN_CD | HOLD_CD | LOAN_ACC_NO | SEQ | WRT_BASIS_DY | TREAT_ORG_CD | RPT_OFFER_SEQ | ONLIN_YN | TELGRM_SEQ | DOC_OFFER_DY | ARCV_RECVBLE_DVCD | DMCUT_CALC_DVCD | OCCR_SEQ | DEMND_DY | ICALC_TRGT_AMT | CALC_DCNT | INT_CALC_AMT | LEDGER_PRCSS_YN | REG_ENO | REG_DT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | KHFCMB2020S-31 | B003-2020-0073 | 4600512293200031 | 1587396 | 20200921 | B003 | 1 | Y | 323 | 20200922 | 2 | 1 | 6 | 20200823 | 247732346 | 29 | 529984 | Y | 1841 | 2020/10/13 14:53:58 |
991 | KHFCMB2020S-31 | B003-2020-0073 | 4600511303200035 | 1587395 | 20200921 | B003 | 1 | Y | 322 | 20200922 | 2 | 1 | 7 | 20200913 | 143419937 | 8 | 84641 | Y | 1841 | 2020/10/13 14:53:58 |
992 | KHFCMB2020S-31 | B003-2020-0072 | 4580578043200032 | 1587394 | 20200921 | B003 | 1 | Y | 319 | 20200922 | 2 | 1 | 6 | 20200827 | 277468731 | 25 | 515515 | Y | 1841 | 2020/10/13 14:53:58 |
993 | KHFCMB2020S-31 | B003-2020-0072 | 4580576523200033 | 1587393 | 20200921 | B003 | 1 | Y | 321 | 20200922 | 2 | 1 | 7 | 20200913 | 138417557 | 8 | 75032 | Y | 1841 | 2020/10/13 14:53:58 |
994 | KHFCMB2020S-31 | B003-2020-0072 | 4580575303200032 | 1587392 | 20200921 | B003 | 1 | Y | 320 | 20200922 | 2 | 1 | 6 | 20200912 | 312702000 | 9 | 190696 | Y | 1841 | 2020/10/13 14:53:58 |
995 | KHFCMB2020S-31 | B003-2020-0073 | 4560196453200032 | 1587391 | 20200921 | B003 | 1 | Y | 318 | 20200922 | 2 | 1 | 6 | 20200825 | 136748258 | 27 | 272375 | Y | 1841 | 2020/10/13 14:53:58 |
996 | KHFCMB2020S-31 | B003-2020-0072 | 4510711503200033 | 1587390 | 20200921 | B003 | 1 | Y | 317 | 20200922 | 2 | 1 | 7 | 20200920 | 186912795 | 1 | 13380 | Y | 1841 | 2020/10/13 14:53:58 |
997 | KHFCMB2020S-31 | B003-2020-0072 | 4510711383200032 | 1587389 | 20200921 | B003 | 1 | Y | 316 | 20200922 | 2 | 1 | 7 | 20200909 | 296592177 | 12 | 238246 | Y | 1841 | 2020/10/13 14:53:58 |
998 | KHFCMB2020S-31 | B003-2020-0072 | 4480491343200032 | 1587388 | 20200921 | B003 | 1 | Y | 315 | 20200922 | 2 | 1 | 7 | 20200913 | 49434845 | 8 | 26797 | Y | 1841 | 2020/10/13 14:53:58 |
999 | KHFCMB2020S-31 | B003-2020-0073 | 4470682893200033 | 1587387 | 20200921 | B003 | 1 | Y | 314 | 20200922 | 2 | 1 | 6 | 20200912 | 199500000 | 9 | 132454 | Y | 1841 | 2020/10/13 14:53:58 |