Dataset statistics
Number of variables | 17 |
---|---|
Number of observations | 1000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 23 |
Duplicate rows (%) | 2.3% |
Total size in memory | 148.6 KiB |
Average record size in memory | 152.1 B |
Variable types
Categorical | 4 |
---|---|
Numeric | 13 |
Dataset
Description | 한국주택금융공사 신탁자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15072806/fileData.do |
BASIS_MM has constant value "" | Constant |
OPER_DY has constant value "" | Constant |
Dataset has 23 (2.3%) duplicate rows | Duplicates |
T07 is highly overall correlated with T08 and 1 other fields | High correlation |
T08 is highly overall correlated with T07 and 1 other fields | High correlation |
T09 is highly overall correlated with T07 and 1 other fields | High correlation |
T10 is highly overall correlated with T11 | High correlation |
T11 is highly overall correlated with T10 | High correlation |
T14 is highly overall correlated with T15 and 1 other fields | High correlation |
T15 is highly overall correlated with T14 and 1 other fields | High correlation |
T16 is highly overall correlated with T14 and 1 other fields | High correlation |
T12 is highly imbalanced (98.3%) | Imbalance |
T05 is highly skewed (γ1 = 29.91068345) | Skewed |
T07 is highly skewed (γ1 = 24.02790843) | Skewed |
T08 is highly skewed (γ1 = 25.61828575) | Skewed |
T09 is highly skewed (γ1 = 21.9651479) | Skewed |
T14 is highly skewed (γ1 = 30.50916908) | Skewed |
T15 is highly skewed (γ1 = 30.82602665) | Skewed |
T16 is highly skewed (γ1 = 30.22875795) | Skewed |
T03 has 225 (22.5%) zeros | Zeros |
T04 has 32 (3.2%) zeros | Zeros |
T05 has 985 (98.5%) zeros | Zeros |
T06 has 951 (95.1%) zeros | Zeros |
T07 has 968 (96.8%) zeros | Zeros |
T08 has 971 (97.1%) zeros | Zeros |
T09 has 970 (97.0%) zeros | Zeros |
T10 has 907 (90.7%) zeros | Zeros |
T11 has 876 (87.6%) zeros | Zeros |
T13 has 993 (99.3%) zeros | Zeros |
T14 has 994 (99.4%) zeros | Zeros |
T15 has 995 (99.5%) zeros | Zeros |
T16 has 994 (99.4%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-11 23:44:37.273090 |
---|---|
Analysis finished | 2023-12-11 23:44:57.227130 |
Duration | 19.95 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
LIQD_PLAN_CD
Categorical
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
KHFCMB2018S-20 | |
---|---|
KHFCMB2018S-19 |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | KHFCMB2018S-20 |
---|---|
2nd row | KHFCMB2018S-20 |
3rd row | KHFCMB2018S-20 |
4th row | KHFCMB2018S-20 |
5th row | KHFCMB2018S-20 |
Common Values
Value | Count | Frequency (%) |
KHFCMB2018S-20 | 804 | |
KHFCMB2018S-19 | 196 | 19.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
khfcmb2018s-20 | 804 | |
khfcmb2018s-19 | 196 | 19.6% |
BASIS_MM
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
201806 |
---|
Length
Max length | 6 |
---|---|
Median length | 6 |
Mean length | 6 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 201806 |
---|---|
2nd row | 201806 |
3rd row | 201806 |
4th row | 201806 |
5th row | 201806 |
Common Values
Value | Count | Frequency (%) |
201806 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
201806 | 1000 |
T03
Real number (ℝ)
ZEROS
 
Distinct | 657 |
---|---|
Distinct (%) | 65.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 264842.97 |
Minimum | 0 |
---|---|
Maximum | 10500000 |
Zeros | 225 |
Zeros (%) | 22.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 30123 |
median | 198587 |
Q3 | 365902.5 |
95-th percentile | 780583.3 |
Maximum | 10500000 |
Range | 10500000 |
Interquartile range (IQR) | 335779.5 |
Descriptive statistics
Standard deviation | 419214 |
---|---|
Coefficient of variation (CV) | 1.5828776 |
Kurtosis | 355.93236 |
Mean | 264842.97 |
Median Absolute Deviation (MAD) | 168427.5 |
Skewness | 14.995603 |
Sum | 2.6484297 × 108 |
Variance | 1.7574038 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 225 | 22.5% |
555555 | 8 | 0.8% |
833333 | 6 | 0.6% |
150615 | 6 | 0.6% |
500000 | 6 | 0.6% |
458333 | 5 | 0.5% |
305555 | 4 | 0.4% |
75307 | 4 | 0.4% |
135554 | 4 | 0.4% |
105430 | 4 | 0.4% |
Other values (647) | 728 |
Value | Count | Frequency (%) |
0 | 225 | |
1897 | 1 | 0.1% |
1954 | 1 | 0.1% |
2060 | 1 | 0.1% |
6492 | 1 | 0.1% |
11210 | 1 | 0.1% |
13592 | 1 | 0.1% |
13981 | 1 | 0.1% |
14988 | 1 | 0.1% |
15036 | 1 | 0.1% |
Value | Count | Frequency (%) |
10500000 | 1 | |
1888888 | 1 | |
1658333 | 1 | |
1468212 | 1 | |
1454768 | 1 | |
1450000 | 1 | |
1376224 | 1 | |
1322621 | 1 | |
1250000 | 1 | |
1216666 | 1 |
T04
Real number (ℝ)
ZEROS
 
Distinct | 879 |
---|---|
Distinct (%) | 87.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 297189.9 |
Minimum | 0 |
---|---|
Maximum | 1369526 |
Zeros | 32 |
Zeros (%) | 3.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 19926.65 |
Q1 | 144245.25 |
median | 278119.5 |
Q3 | 411613.75 |
95-th percentile | 652213.95 |
Maximum | 1369526 |
Range | 1369526 |
Interquartile range (IQR) | 267368.5 |
Descriptive statistics
Standard deviation | 204938.19 |
---|---|
Coefficient of variation (CV) | 0.68958667 |
Kurtosis | 3.632059 |
Mean | 297189.9 |
Median Absolute Deviation (MAD) | 133800.5 |
Skewness | 1.3227131 |
Sum | 2.971899 × 108 |
Variance | 4.1999662 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 32 | 3.2% |
467123 | 10 | 1.0% |
433150 | 7 | 0.7% |
373698 | 6 | 0.6% |
416164 | 6 | 0.6% |
192500 | 4 | 0.4% |
450136 | 4 | 0.4% |
129452 | 3 | 0.3% |
249698 | 3 | 0.3% |
64166 | 3 | 0.3% |
Other values (869) | 922 |
Value | Count | Frequency (%) |
0 | 32 | |
4054 | 1 | 0.1% |
5725 | 1 | 0.1% |
6164 | 1 | 0.1% |
9870 | 1 | 0.1% |
10144 | 1 | 0.1% |
11866 | 1 | 0.1% |
12194 | 1 | 0.1% |
14219 | 1 | 0.1% |
14230 | 1 | 0.1% |
Value | Count | Frequency (%) |
1369526 | 1 | |
1328116 | 1 | |
1281434 | 1 | |
1259977 | 1 | |
1239480 | 1 | |
1209849 | 1 | |
1181824 | 1 | |
1144452 | 1 | |
1122916 | 1 | |
1068438 | 1 |
T05
Real number (ℝ)
SKEWED
  ZEROS
 
Distinct | 15 |
---|---|
Distinct (%) | 1.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.829 |
Minimum | 0 |
---|---|
Maximum | 1775 |
Zeros | 985 |
Zeros (%) | 98.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 1775 |
Range | 1775 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 57.21228 |
---|---|
Coefficient of variation (CV) | 20.2235 |
Kurtosis | 924.38353 |
Mean | 2.829 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 29.910683 |
Sum | 2829 |
Variance | 3273.245 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 985 | |
64 | 2 | 0.2% |
37 | 1 | 0.1% |
20 | 1 | 0.1% |
120 | 1 | 0.1% |
76 | 1 | 0.1% |
113 | 1 | 0.1% |
75 | 1 | 0.1% |
108 | 1 | 0.1% |
2 | 1 | 0.1% |
Other values (5) | 5 | 0.5% |
Value | Count | Frequency (%) |
0 | 985 | |
2 | 1 | 0.1% |
15 | 1 | 0.1% |
17 | 1 | 0.1% |
20 | 1 | 0.1% |
37 | 1 | 0.1% |
64 | 2 | 0.2% |
75 | 1 | 0.1% |
76 | 1 | 0.1% |
108 | 1 | 0.1% |
Value | Count | Frequency (%) |
1775 | 1 | |
234 | 1 | |
120 | 1 | |
113 | 1 | |
109 | 1 | |
108 | 1 | |
76 | 1 | |
75 | 1 | |
64 | 2 | |
37 | 1 |
T06
Real number (ℝ)
ZEROS
 
Distinct | 46 |
---|---|
Distinct (%) | 4.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 7.453 |
Minimum | 0 |
---|---|
Maximum | 1107 |
Zeros | 951 |
Zeros (%) | 95.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 1107 |
Range | 1107 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 50.836543 |
---|---|
Coefficient of variation (CV) | 6.8209504 |
Kurtosis | 244.16934 |
Mean | 7.453 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 13.453674 |
Sum | 7453 |
Variance | 2584.3541 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 951 | |
115 | 2 | 0.2% |
62 | 2 | 0.2% |
131 | 2 | 0.2% |
53 | 2 | 0.2% |
16 | 1 | 0.1% |
96 | 1 | 0.1% |
92 | 1 | 0.1% |
85 | 1 | 0.1% |
225 | 1 | 0.1% |
Other values (36) | 36 | 3.6% |
Value | Count | Frequency (%) |
0 | 951 | |
16 | 1 | 0.1% |
27 | 1 | 0.1% |
29 | 1 | 0.1% |
35 | 1 | 0.1% |
38 | 1 | 0.1% |
42 | 1 | 0.1% |
51 | 1 | 0.1% |
52 | 1 | 0.1% |
53 | 2 | 0.2% |
Value | Count | Frequency (%) |
1107 | 1 | |
563 | 1 | |
418 | 1 | |
391 | 1 | |
358 | 1 | |
271 | 1 | |
235 | 1 | |
225 | 1 | |
197 | 1 | |
187 | 1 |
T07
Real number (ℝ)
HIGH CORRELATION
  SKEWED
  ZEROS
 
Distinct | 24 |
---|---|
Distinct (%) | 2.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 184356.03 |
Minimum | 0 |
---|---|
Maximum | 68000000 |
Zeros | 968 |
Zeros (%) | 96.8% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 68000000 |
Range | 68000000 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 2386555.5 |
---|---|
Coefficient of variation (CV) | 12.945362 |
Kurtosis | 660.10528 |
Mean | 184356.03 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 24.027908 |
Sum | 1.8435603 × 108 |
Variance | 5.695647 × 1012 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 968 | |
10000000 | 6 | 0.6% |
3000000 | 4 | 0.4% |
1000000 | 2 | 0.2% |
5000000 | 1 | 0.1% |
1480000 | 1 | 0.1% |
170392 | 1 | 0.1% |
500000 | 1 | 0.1% |
920000 | 1 | 0.1% |
600000 | 1 | 0.1% |
Other values (14) | 14 | 1.4% |
Value | Count | Frequency (%) |
0 | 968 | |
6400 | 1 | 0.1% |
100000 | 1 | 0.1% |
170392 | 1 | 0.1% |
200000 | 1 | 0.1% |
399238 | 1 | 0.1% |
440000 | 1 | 0.1% |
500000 | 1 | 0.1% |
600000 | 1 | 0.1% |
700000 | 1 | 0.1% |
Value | Count | Frequency (%) |
68000000 | 1 | 0.1% |
20000000 | 1 | 0.1% |
10000000 | 6 | |
5000000 | 1 | 0.1% |
4500000 | 1 | 0.1% |
3000000 | 4 | |
2140000 | 1 | 0.1% |
2000000 | 1 | 0.1% |
1480000 | 1 | 0.1% |
1300000 | 1 | 0.1% |
T08
Real number (ℝ)
HIGH CORRELATION
  SKEWED
  ZEROS
 
Distinct | 30 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 185.156 |
Minimum | 0 |
---|---|
Maximum | 81972 |
Zeros | 971 |
Zeros (%) | 97.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 81972 |
Range | 81972 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 2817.2726 |
---|---|
Coefficient of variation (CV) | 15.21567 |
Kurtosis | 721.61976 |
Mean | 185.156 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 25.618286 |
Sum | 185156 |
Variance | 7937025.1 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 971 | |
19 | 1 | 0.1% |
4430 | 1 | 0.1% |
27424 | 1 | 0.1% |
2653 | 1 | 0.1% |
7134 | 1 | 0.1% |
12216 | 1 | 0.1% |
43 | 1 | 0.1% |
128 | 1 | 0.1% |
5657 | 1 | 0.1% |
Other values (20) | 20 | 2.0% |
Value | Count | Frequency (%) |
0 | 971 | |
5 | 1 | 0.1% |
19 | 1 | 0.1% |
43 | 1 | 0.1% |
128 | 1 | 0.1% |
196 | 1 | 0.1% |
203 | 1 | 0.1% |
316 | 1 | 0.1% |
492 | 1 | 0.1% |
522 | 1 | 0.1% |
Value | Count | Frequency (%) |
81972 | 1 | |
27424 | 1 | |
12216 | 1 | |
8321 | 1 | |
8219 | 1 | |
7191 | 1 | |
7134 | 1 | |
5657 | 1 | |
4430 | 1 | |
4109 | 1 |
T09
Real number (ℝ)
HIGH CORRELATION
  SKEWED
  ZEROS
 
Distinct | 30 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2202.32 |
Minimum | 0 |
---|---|
Maximum | 714744 |
Zeros | 970 |
Zeros (%) | 97.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 714744 |
Range | 714744 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 26034.672 |
---|---|
Coefficient of variation (CV) | 11.821475 |
Kurtosis | 571.5115 |
Mean | 2202.32 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 21.965148 |
Sum | 2202320 |
Variance | 6.7780414 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 970 | |
119124 | 2 | 0.2% |
2189 | 1 | 0.1% |
35540 | 1 | 0.1% |
117153 | 1 | 0.1% |
16982 | 1 | 0.1% |
108503 | 1 | 0.1% |
1923 | 1 | 0.1% |
5644 | 1 | 0.1% |
115839 | 1 | 0.1% |
Other values (20) | 20 | 2.0% |
Value | Count | Frequency (%) |
0 | 970 | |
75 | 1 | 0.1% |
1167 | 1 | 0.1% |
1923 | 1 | 0.1% |
2189 | 1 | 0.1% |
5246 | 1 | 0.1% |
5644 | 1 | 0.1% |
6917 | 1 | 0.1% |
9477 | 1 | 0.1% |
10526 | 1 | 0.1% |
Value | Count | Frequency (%) |
714744 | 1 | |
234963 | 1 | |
136488 | 1 | |
119890 | 1 | |
119124 | 2 | |
117153 | 1 | |
115839 | 1 | |
108503 | 1 | |
59507 | 1 | |
59287 | 1 |
T10
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 93 |
---|---|
Distinct (%) | 9.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 31624.387 |
Minimum | 0 |
---|---|
Maximum | 1658333 |
Zeros | 907 |
Zeros (%) | 90.7% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 261527.65 |
Maximum | 1658333 |
Range | 1658333 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 130739.07 |
---|---|
Coefficient of variation (CV) | 4.134122 |
Kurtosis | 49.077395 |
Mean | 31624.387 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 6.0541045 |
Sum | 31624387 |
Variance | 1.7092706 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 907 | |
416666 | 2 | 0.2% |
848455 | 1 | 0.1% |
295050 | 1 | 0.1% |
293061 | 1 | 0.1% |
555555 | 1 | 0.1% |
490008 | 1 | 0.1% |
1658333 | 1 | 0.1% |
383266 | 1 | 0.1% |
13981 | 1 | 0.1% |
Other values (83) | 83 | 8.3% |
Value | Count | Frequency (%) |
0 | 907 | |
13981 | 1 | 0.1% |
14988 | 1 | 0.1% |
17716 | 1 | 0.1% |
22196 | 1 | 0.1% |
22948 | 1 | 0.1% |
44678 | 1 | 0.1% |
47639 | 1 | 0.1% |
52715 | 1 | 0.1% |
59190 | 1 | 0.1% |
Value | Count | Frequency (%) |
1658333 | 1 | |
1468212 | 1 | |
900000 | 1 | |
848455 | 1 | |
791666 | 1 | |
777777 | 1 | |
750000 | 1 | |
716666 | 1 | |
703941 | 1 | |
666666 | 1 |
T11
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 118 |
---|---|
Distinct (%) | 11.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 38684.336 |
Minimum | 0 |
---|---|
Maximum | 1239480 |
Zeros | 876 |
Zeros (%) | 87.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 341745 |
Maximum | 1239480 |
Range | 1239480 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 123278.66 |
---|---|
Coefficient of variation (CV) | 3.1867849 |
Kurtosis | 19.868632 |
Mean | 38684.336 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 3.9961908 |
Sum | 38684336 |
Variance | 1.5197628 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 876 | |
249698 | 3 | 0.3% |
467123 | 3 | 0.3% |
238232 | 2 | 0.2% |
50342 | 2 | 0.2% |
450136 | 2 | 0.2% |
501435 | 1 | 0.1% |
413123 | 1 | 0.1% |
582689 | 1 | 0.1% |
677574 | 1 | 0.1% |
Other values (108) | 108 | 10.8% |
Value | Count | Frequency (%) |
0 | 876 | |
31372 | 1 | 0.1% |
31892 | 1 | 0.1% |
33226 | 1 | 0.1% |
41205 | 1 | 0.1% |
46519 | 1 | 0.1% |
48125 | 1 | 0.1% |
49315 | 1 | 0.1% |
50342 | 2 | 0.2% |
76438 | 1 | 0.1% |
Value | Count | Frequency (%) |
1239480 | 1 | |
909095 | 1 | |
861814 | 1 | |
735342 | 1 | |
732534 | 1 | |
677574 | 1 | |
653581 | 1 | |
633610 | 1 | |
582689 | 1 | |
563315 | 1 |
T12
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 | |
---|---|
20 | 1 |
120 | 1 |
109 | 1 |
Length
Max length | 3 |
---|---|
Median length | 1 |
Mean length | 1.005 |
Min length | 1 |
Unique
Unique | 3 ? |
---|---|
Unique (%) | 0.3% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 997 | |
20 | 1 | 0.1% |
120 | 1 | 0.1% |
109 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 997 | |
20 | 1 | 0.1% |
120 | 1 | 0.1% |
109 | 1 | 0.1% |
T13
Real number (ℝ)
ZEROS
 
Distinct | 8 |
---|---|
Distinct (%) | 0.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 0.647 |
Minimum | 0 |
---|---|
Maximum | 187 |
Zeros | 993 |
Zeros (%) | 99.3% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 187 |
Range | 187 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 8.6457585 |
---|---|
Coefficient of variation (CV) | 13.362842 |
Kurtosis | 279.7853 |
Mean | 0.647 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 15.785321 |
Sum | 647 |
Variance | 74.74914 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 993 | |
115 | 1 | 0.1% |
63 | 1 | 0.1% |
62 | 1 | 0.1% |
187 | 1 | 0.1% |
97 | 1 | 0.1% |
29 | 1 | 0.1% |
94 | 1 | 0.1% |
Value | Count | Frequency (%) |
0 | 993 | |
29 | 1 | 0.1% |
62 | 1 | 0.1% |
63 | 1 | 0.1% |
94 | 1 | 0.1% |
97 | 1 | 0.1% |
115 | 1 | 0.1% |
187 | 1 | 0.1% |
Value | Count | Frequency (%) |
187 | 1 | 0.1% |
115 | 1 | 0.1% |
97 | 1 | 0.1% |
94 | 1 | 0.1% |
63 | 1 | 0.1% |
62 | 1 | 0.1% |
29 | 1 | 0.1% |
0 | 993 |
T14
Real number (ℝ)
HIGH CORRELATION
  SKEWED
  ZEROS
 
Distinct | 7 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 85040 |
Minimum | 0 |
---|---|
Maximum | 68000000 |
Zeros | 994 |
Zeros (%) | 99.4% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 68000000 |
Range | 68000000 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 2178110.6 |
---|---|
Coefficient of variation (CV) | 25.612778 |
Kurtosis | 949.32645 |
Mean | 85040 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 30.509169 |
Sum | 85040000 |
Variance | 4.744166 × 1012 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 994 | |
4500000 | 1 | 0.1% |
10000000 | 1 | 0.1% |
440000 | 1 | 0.1% |
68000000 | 1 | 0.1% |
1100000 | 1 | 0.1% |
1000000 | 1 | 0.1% |
Value | Count | Frequency (%) |
0 | 994 | |
440000 | 1 | 0.1% |
1000000 | 1 | 0.1% |
1100000 | 1 | 0.1% |
4500000 | 1 | 0.1% |
10000000 | 1 | 0.1% |
68000000 | 1 | 0.1% |
Value | Count | Frequency (%) |
68000000 | 1 | 0.1% |
10000000 | 1 | 0.1% |
4500000 | 1 | 0.1% |
1100000 | 1 | 0.1% |
1000000 | 1 | 0.1% |
440000 | 1 | 0.1% |
0 | 994 |
T15
Real number (ℝ)
HIGH CORRELATION
  SKEWED
  ZEROS
 
Distinct | 6 |
---|---|
Distinct (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 99.104 |
Minimum | 0 |
---|---|
Maximum | 81972 |
Zeros | 995 |
Zeros (%) | 99.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 81972 |
Range | 81972 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 2615.2295 |
---|---|
Coefficient of variation (CV) | 26.388738 |
Kurtosis | 964.45078 |
Mean | 99.104 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 30.826027 |
Sum | 99104 |
Variance | 6839425.2 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 995 | |
8321 | 1 | 0.1% |
7191 | 1 | 0.1% |
81972 | 1 | 0.1% |
203 | 1 | 0.1% |
1417 | 1 | 0.1% |
Value | Count | Frequency (%) |
0 | 995 | |
203 | 1 | 0.1% |
1417 | 1 | 0.1% |
7191 | 1 | 0.1% |
8321 | 1 | 0.1% |
81972 | 1 | 0.1% |
Value | Count | Frequency (%) |
81972 | 1 | 0.1% |
8321 | 1 | 0.1% |
7191 | 1 | 0.1% |
1417 | 1 | 0.1% |
203 | 1 | 0.1% |
0 | 995 |
T16
Real number (ℝ)
HIGH CORRELATION
  SKEWED
  ZEROS
 
Distinct | 7 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 916.436 |
Minimum | 0 |
---|---|
Maximum | 714744 |
Zeros | 994 |
Zeros (%) | 99.4% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 714744 |
Range | 714744 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 22975.64 |
---|---|
Coefficient of variation (CV) | 25.070643 |
Kurtosis | 936.03208 |
Mean | 916.436 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 30.228758 |
Sum | 916436 |
Variance | 5.2788003 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 994 | |
53113 | 1 | 0.1% |
119124 | 1 | 0.1% |
5246 | 1 | 0.1% |
714744 | 1 | 0.1% |
12790 | 1 | 0.1% |
11419 | 1 | 0.1% |
Value | Count | Frequency (%) |
0 | 994 | |
5246 | 1 | 0.1% |
11419 | 1 | 0.1% |
12790 | 1 | 0.1% |
53113 | 1 | 0.1% |
119124 | 1 | 0.1% |
714744 | 1 | 0.1% |
Value | Count | Frequency (%) |
714744 | 1 | 0.1% |
119124 | 1 | 0.1% |
53113 | 1 | 0.1% |
12790 | 1 | 0.1% |
11419 | 1 | 0.1% |
5246 | 1 | 0.1% |
0 | 994 |
OPER_DY
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20180928 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20180928 |
---|---|
2nd row | 20180928 |
3rd row | 20180928 |
4th row | 20180928 |
5th row | 20180928 |
Common Values
Value | Count | Frequency (%) |
20180928 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20180928 | 1000 |
LIQD_PLAN_CD | T03 | T04 | T05 | T06 | T07 | T08 | T09 | T10 | T11 | T12 | T13 | T14 | T15 | T16 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LIQD_PLAN_CD | 1.000 | 0.000 | 0.177 | 0.029 | 0.095 | 0.000 | 0.069 | 0.000 | 0.000 | 0.041 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
T03 | 0.000 | 1.000 | 0.272 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.358 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
T04 | 0.177 | 0.272 | 1.000 | 0.454 | 0.000 | 0.000 | 0.000 | 0.051 | 0.154 | 0.589 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
T05 | 0.029 | 0.000 | 0.454 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
T06 | 0.095 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.368 | 0.000 | 0.000 | 0.000 |
T07 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.956 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.721 | 0.675 | 0.721 |
T08 | 0.069 | 0.000 | 0.000 | 0.000 | 0.000 | 0.956 | 1.000 | 0.954 | 0.000 | 0.000 | 0.000 | 0.000 | 0.675 | 0.763 | 0.675 |
T09 | 0.000 | 0.000 | 0.051 | 0.000 | 0.000 | 1.000 | 0.954 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.715 | 0.675 | 0.715 |
T10 | 0.000 | 0.358 | 0.154 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.632 | 0.286 | 0.507 | 0.000 | 0.000 | 0.000 |
T11 | 0.041 | 0.000 | 0.589 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.632 | 1.000 | 0.175 | 0.418 | 0.000 | 0.000 | 0.000 |
T12 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.286 | 0.175 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
T13 | 0.000 | 0.000 | 0.000 | 0.000 | 0.368 | 0.000 | 0.000 | 0.000 | 0.507 | 0.418 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 |
T14 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.721 | 0.675 | 0.715 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.943 | 1.000 |
T15 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.675 | 0.763 | 0.675 | 0.000 | 0.000 | 0.000 | 0.000 | 0.943 | 1.000 | 0.943 |
T16 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.721 | 0.675 | 0.715 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.943 | 1.000 |
T12 | LIQD_PLAN_CD | |
---|---|---|
T12 | 1.000 | 0.000 |
LIQD_PLAN_CD | 0.000 | 1.000 |
T03 | T04 | T05 | T06 | T07 | T08 | T09 | T10 | T11 | T13 | T14 | T15 | T16 | LIQD_PLAN_CD | T12 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
T03 | 1.000 | 0.343 | 0.004 | -0.048 | -0.245 | -0.233 | -0.237 | 0.147 | -0.001 | -0.046 | -0.105 | -0.096 | -0.105 | 0.000 | 0.000 |
T04 | 0.343 | 1.000 | -0.058 | 0.048 | -0.305 | -0.290 | -0.295 | 0.031 | 0.060 | 0.004 | -0.130 | -0.119 | -0.130 | 0.135 | 0.000 |
T05 | 0.004 | -0.058 | 1.000 | 0.008 | -0.022 | -0.021 | -0.022 | 0.043 | 0.027 | -0.010 | -0.010 | -0.009 | -0.010 | 0.048 | 0.000 |
T06 | -0.048 | 0.048 | 0.008 | 1.000 | -0.041 | -0.039 | -0.040 | -0.010 | 0.012 | 0.366 | -0.018 | -0.016 | -0.018 | 0.068 | 0.000 |
T07 | -0.245 | -0.305 | -0.022 | -0.041 | 1.000 | 0.952 | 0.967 | -0.058 | -0.068 | -0.015 | 0.430 | 0.394 | 0.430 | 0.000 | 0.000 |
T08 | -0.233 | -0.290 | -0.021 | -0.039 | 0.952 | 1.000 | 0.914 | -0.055 | -0.065 | -0.015 | 0.376 | 0.414 | 0.376 | 0.046 | 0.000 |
T09 | -0.237 | -0.295 | -0.022 | -0.040 | 0.967 | 0.914 | 1.000 | -0.056 | -0.066 | -0.015 | 0.443 | 0.406 | 0.443 | 0.000 | 0.000 |
T10 | 0.147 | 0.031 | 0.043 | -0.010 | -0.058 | -0.055 | -0.056 | 1.000 | 0.848 | 0.135 | -0.025 | -0.023 | -0.025 | 0.000 | 0.131 |
T11 | -0.001 | 0.060 | 0.027 | 0.012 | -0.068 | -0.065 | -0.066 | 0.848 | 1.000 | 0.221 | -0.029 | -0.027 | -0.029 | 0.040 | 0.112 |
T13 | -0.046 | 0.004 | -0.010 | 0.366 | -0.015 | -0.015 | -0.015 | 0.135 | 0.221 | 1.000 | -0.007 | -0.006 | -0.007 | 0.000 | 0.000 |
T14 | -0.105 | -0.130 | -0.010 | -0.018 | 0.430 | 0.376 | 0.443 | -0.025 | -0.029 | -0.007 | 1.000 | 0.913 | 1.000 | 0.000 | 0.000 |
T15 | -0.096 | -0.119 | -0.009 | -0.016 | 0.394 | 0.414 | 0.406 | -0.023 | -0.027 | -0.006 | 0.913 | 1.000 | 0.913 | 0.000 | 0.000 |
T16 | -0.105 | -0.130 | -0.010 | -0.018 | 0.430 | 0.376 | 0.443 | -0.025 | -0.029 | -0.007 | 1.000 | 0.913 | 1.000 | 0.000 | 0.000 |
LIQD_PLAN_CD | 0.000 | 0.135 | 0.048 | 0.068 | 0.000 | 0.046 | 0.000 | 0.000 | 0.040 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 |
T12 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.131 | 0.112 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
LIQD_PLAN_CD | BASIS_MM | T03 | T04 | T05 | T06 | T07 | T08 | T09 | T10 | T11 | T12 | T13 | T14 | T15 | T16 | OPER_DY | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | KHFCMB2018S-20 | 201806 | 420000 | 163493 | 0 | 0 | 0 | 0 | 0 | 420000 | 163493 | 0 | 0 | 0 | 0 | 0 | 20180928 |
1 | KHFCMB2018S-20 | 201806 | 980000 | 1144452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
2 | KHFCMB2018S-20 | 201806 | 0 | 96250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
3 | KHFCMB2018S-20 | 201806 | 76678 | 126088 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
4 | KHFCMB2018S-20 | 201806 | 73691 | 36770 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
5 | KHFCMB2018S-20 | 201806 | 275968 | 4054 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
6 | KHFCMB2018S-20 | 201806 | 127572 | 219486 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
7 | KHFCMB2018S-20 | 201806 | 68891 | 145449 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
8 | KHFCMB2018S-20 | 201806 | 120492 | 82191 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
9 | KHFCMB2018S-20 | 201806 | 196839 | 39747 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
LIQD_PLAN_CD | BASIS_MM | T03 | T04 | T05 | T06 | T07 | T08 | T09 | T10 | T11 | T12 | T13 | T14 | T15 | T16 | OPER_DY | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | KHFCMB2018S-19 | 201806 | 305555 | 359684 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
991 | KHFCMB2018S-19 | 201806 | 583333 | 659546 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
992 | KHFCMB2018S-19 | 201806 | 192367 | 417083 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
993 | KHFCMB2018S-19 | 201806 | 128738 | 279125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
994 | KHFCMB2018S-19 | 201806 | 517912 | 1122916 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
995 | KHFCMB2018S-19 | 201806 | 305015 | 621216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
996 | KHFCMB2018S-19 | 201806 | 108280 | 220532 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
997 | KHFCMB2018S-19 | 201806 | 224922 | 487666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
998 | KHFCMB2018S-19 | 201806 | 55455 | 64166 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
999 | KHFCMB2018S-19 | 201806 | 504974 | 931878 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 |
Most frequently occurring
LIQD_PLAN_CD | BASIS_MM | T03 | T04 | T05 | T06 | T07 | T08 | T09 | T10 | T11 | T12 | T13 | T14 | T15 | T16 | OPER_DY | # duplicates | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | KHFCMB2018S-20 | 201806 | 0 | 433150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 6 |
12 | KHFCMB2018S-20 | 201806 | 0 | 467123 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 6 |
9 | KHFCMB2018S-20 | 201806 | 0 | 416164 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 5 |
6 | KHFCMB2018S-20 | 201806 | 0 | 373698 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 4 |
16 | KHFCMB2018S-20 | 201806 | 150615 | 102739 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 3 |
0 | KHFCMB2018S-19 | 201806 | 29595 | 64166 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 2 |
1 | KHFCMB2018S-19 | 201806 | 133177 | 288750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 2 |
2 | KHFCMB2018S-19 | 201806 | 342252 | 160416 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 2 |
3 | KHFCMB2018S-20 | 201806 | 0 | 239506 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 2 |
4 | KHFCMB2018S-20 | 201806 | 0 | 303205 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20180928 | 2 |