Dataset statistics
Number of variables | 18 |
---|---|
Number of observations | 1000 |
Missing cells | 41 |
Missing cells (%) | 0.2% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 152.5 KiB |
Average record size in memory | 156.1 B |
Variable types
Categorical | 7 |
---|---|
Numeric | 9 |
DateTime | 2 |
Dataset
Description | 한국주택금융공사 채권관리부 업무 관련 공개 데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15072890/fileData.do |
UPDT_BRCD is highly overall correlated with RMT_BNK_CD and 5 other fields | High correlation |
ACCT_DEPT_CD is highly overall correlated with RMT_BNK_CD and 5 other fields | High correlation |
DECIS_NO is highly overall correlated with ACCT_DVCD | High correlation |
DEPT_CD is highly overall correlated with RMT_BNK_CD and 5 other fields | High correlation |
REG_BRCD is highly overall correlated with RMT_BNK_CD and 5 other fields | High correlation |
ACCT_DVCD is highly overall correlated with DECIS_DY and 14 other fields | High correlation |
STLE_CD is highly overall correlated with DEPT_CD and 4 other fields | High correlation |
DECIS_DY is highly overall correlated with ACCT_DY and 3 other fields | High correlation |
CNFM_ENO is highly overall correlated with ACCT_DVCD | High correlation |
RMT_BNK_CD is highly overall correlated with DEPT_CD and 4 other fields | High correlation |
ACCT_DY is highly overall correlated with DECIS_DY and 3 other fields | High correlation |
SLIP_NO is highly overall correlated with ACCT_DVCD | High correlation |
UPDT_ENO is highly overall correlated with REG_ENO and 1 other fields | High correlation |
REG_ENO is highly overall correlated with UPDT_ENO and 1 other fields | High correlation |
GENRT_DY is highly overall correlated with DECIS_DY and 3 other fields | High correlation |
CARD_STTL_DY is highly overall correlated with DECIS_DY and 3 other fields | High correlation |
DECIS_NO is highly imbalanced (85.4%) | Imbalance |
STLE_CD is highly imbalanced (82.0%) | Imbalance |
ACCT_DVCD is highly imbalanced (92.6%) | Imbalance |
Reproduction
Analysis started | 2023-12-12 17:37:18.065388 |
---|---|
Analysis finished | 2023-12-12 17:37:30.579840 |
Duration | 12.51 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
DEPT_CD
Categorical
HIGH CORRELATION
 
Distinct | 26 |
---|---|
Distinct (%) | 2.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
ACS | |
---|---|
TLB | 48 |
TAA | 48 |
TOA | 48 |
TAB | 48 |
Other values (21) |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | THA |
---|---|
2nd row | TNA |
3rd row | TAC |
4th row | TBB |
5th row | TAD |
Common Values
Value | Count | Frequency (%) |
ACS | 88 | 8.8% |
TLB | 48 | 4.8% |
TAA | 48 | 4.8% |
TOA | 48 | 4.8% |
TAB | 48 | 4.8% |
TPA | 47 | 4.7% |
THO | 46 | 4.6% |
QAD | 45 | 4.5% |
TAC | 45 | 4.5% |
TPB | 44 | 4.4% |
Other values (16) | 493 |
Length
Value | Count | Frequency (%) |
acs | 88 | 8.8% |
taa | 48 | 4.8% |
toa | 48 | 4.8% |
tab | 48 | 4.8% |
tlb | 48 | 4.8% |
tpa | 47 | 4.7% |
tho | 46 | 4.6% |
qad | 45 | 4.5% |
tac | 45 | 4.5% |
tad | 44 | 4.4% |
Other values (16) | 493 |
DECIS_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 302 |
---|---|
Distinct (%) | 30.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20185783 |
Minimum | 20170223 |
---|---|
Maximum | 20201026 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20170223 |
---|---|
5-th percentile | 20170512 |
Q1 | 20180221 |
median | 20190123 |
Q3 | 20191125 |
95-th percentile | 20200820 |
Maximum | 20201026 |
Range | 30803 |
Interquartile range (IQR) | 10904.25 |
Descriptive statistics
Standard deviation | 10687.372 |
---|---|
Coefficient of variation (CV) | 0.00052945046 |
Kurtosis | -1.257933 |
Mean | 20185783 |
Median Absolute Deviation (MAD) | 9801 |
Skewness | -0.036945547 |
Sum | 2.0185783 × 1010 |
Variance | 1.1421993 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20170424 | 11 | 1.1% |
20170724 | 11 | 1.1% |
20180724 | 10 | 1.0% |
20191021 | 10 | 1.0% |
20190325 | 10 | 1.0% |
20180524 | 10 | 1.0% |
20171023 | 9 | 0.9% |
20170925 | 9 | 0.9% |
20190924 | 9 | 0.9% |
20200219 | 9 | 0.9% |
Other values (292) | 902 |
Value | Count | Frequency (%) |
20170223 | 1 | 0.1% |
20170224 | 5 | |
20170315 | 1 | 0.1% |
20170317 | 3 | |
20170320 | 3 | |
20170321 | 1 | 0.1% |
20170322 | 1 | 0.1% |
20170323 | 5 | |
20170324 | 7 | |
20170412 | 1 | 0.1% |
Value | Count | Frequency (%) |
20201026 | 2 | |
20201022 | 2 | |
20201021 | 2 | |
20201020 | 1 | 0.1% |
20201019 | 2 | |
20201016 | 1 | 0.1% |
20201015 | 3 | |
20201013 | 1 | 0.1% |
20201006 | 1 | 0.1% |
20200928 | 1 | 0.1% |
DECIS_NO
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
2 | 43 |
3 | 7 |
5 | 1 |
4 | 1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 0.2% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 948 | |
2 | 43 | 4.3% |
3 | 7 | 0.7% |
5 | 1 | 0.1% |
4 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 948 | |
2 | 43 | 4.3% |
3 | 7 | 0.7% |
5 | 1 | 0.1% |
4 | 1 | 0.1% |
STLE_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | 0.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
2 | 35 |
<NA> | 8 |
Length
Max length | 4 |
---|---|
Median length | 1 |
Mean length | 1.024 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | <NA> |
4th row | 1 |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
1 | 957 | |
2 | 35 | 3.5% |
<NA> | 8 | 0.8% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 957 | |
2 | 35 | 3.5% |
na | 8 | 0.8% |
CNFM_ENO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 80 |
---|---|
Distinct (%) | 8.1% |
Missing | 7 |
Missing (%) | 0.7% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1243.7422 |
Minimum | 1009 |
---|---|
Maximum | 6078 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1009 |
---|---|
5-th percentile | 1095 |
Q1 | 1153 |
median | 1201 |
Q3 | 1295 |
95-th percentile | 1377 |
Maximum | 6078 |
Range | 5069 |
Interquartile range (IQR) | 142 |
Descriptive statistics
Standard deviation | 319.86771 |
---|---|
Coefficient of variation (CV) | 0.25718168 |
Kurtosis | 205.94829 |
Mean | 1243.7422 |
Median Absolute Deviation (MAD) | 59 |
Skewness | 13.808715 |
Sum | 1235036 |
Variance | 102315.35 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1212 | 62 | 6.2% |
1377 | 39 | 3.9% |
1127 | 38 | 3.8% |
1187 | 38 | 3.8% |
1198 | 34 | 3.4% |
1142 | 34 | 3.4% |
1360 | 33 | 3.3% |
1183 | 33 | 3.3% |
1235 | 29 | 2.9% |
1205 | 26 | 2.6% |
Other values (70) | 627 |
Value | Count | Frequency (%) |
1009 | 2 | 0.2% |
1037 | 15 | |
1086 | 3 | 0.3% |
1087 | 11 | |
1095 | 23 | |
1103 | 1 | 0.1% |
1117 | 5 | 0.5% |
1118 | 10 | |
1121 | 13 | |
1122 | 7 | 0.7% |
Value | Count | Frequency (%) |
6078 | 3 | 0.3% |
6015 | 1 | 0.1% |
1499 | 1 | 0.1% |
1421 | 2 | 0.2% |
1419 | 16 | |
1395 | 7 | 0.7% |
1394 | 7 | 0.7% |
1393 | 4 | 0.4% |
1377 | 39 | |
1375 | 7 | 0.7% |
RMT_BNK_CD
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 0.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 23.282 |
Minimum | 2 |
---|---|
Maximum | 88 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 2 |
---|---|
5-th percentile | 3 |
Q1 | 4 |
median | 4 |
Q3 | 32 |
95-th percentile | 88 |
Maximum | 88 |
Range | 86 |
Interquartile range (IQR) | 28 |
Descriptive statistics
Standard deviation | 33.253846 |
---|---|
Coefficient of variation (CV) | 1.4283071 |
Kurtosis | -0.37680394 |
Mean | 23.282 |
Median Absolute Deviation (MAD) | 1 |
Skewness | 1.2346031 |
Sum | 23282 |
Variance | 1105.8183 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4 | 455 | |
3 | 232 | |
81 | 130 | 13.0% |
88 | 94 | 9.4% |
11 | 46 | 4.6% |
32 | 26 | 2.6% |
39 | 16 | 1.6% |
2 | 1 | 0.1% |
Value | Count | Frequency (%) |
2 | 1 | 0.1% |
3 | 232 | |
4 | 455 | |
11 | 46 | 4.6% |
32 | 26 | 2.6% |
39 | 16 | 1.6% |
81 | 130 | 13.0% |
88 | 94 | 9.4% |
Value | Count | Frequency (%) |
88 | 94 | 9.4% |
81 | 130 | 13.0% |
39 | 16 | 1.6% |
32 | 26 | 2.6% |
11 | 46 | 4.6% |
4 | 455 | |
3 | 232 | |
2 | 1 | 0.1% |
ACCT_DVCD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
2 | |
---|---|
<NA> | 9 |
Length
Max length | 4 |
---|---|
Median length | 1 |
Mean length | 1.027 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2 |
---|---|
2nd row | 2 |
3rd row | <NA> |
4th row | 2 |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
2 | 991 | |
<NA> | 9 | 0.9% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 991 | |
na | 9 | 0.9% |
ACCT_DEPT_CD
Categorical
HIGH CORRELATION
 
Distinct | 27 |
---|---|
Distinct (%) | 2.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
ACS | |
---|---|
TLB | 48 |
TOA | 48 |
TAB | 48 |
TAA | 47 |
Other values (22) |
Length
Max length | 4 |
---|---|
Median length | 3 |
Mean length | 3.009 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | THA |
---|---|
2nd row | TNA |
3rd row | <NA> |
4th row | TBB |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
ACS | 88 | 8.8% |
TLB | 48 | 4.8% |
TOA | 48 | 4.8% |
TAB | 48 | 4.8% |
TAA | 47 | 4.7% |
TPA | 46 | 4.6% |
THO | 45 | 4.5% |
THA | 44 | 4.4% |
TAC | 44 | 4.4% |
QAD | 44 | 4.4% |
Other values (17) | 498 |
Length
Value | Count | Frequency (%) |
acs | 88 | 8.8% |
toa | 48 | 4.8% |
tab | 48 | 4.8% |
tlb | 48 | 4.8% |
taa | 47 | 4.7% |
tpa | 46 | 4.6% |
tho | 45 | 4.5% |
tha | 44 | 4.4% |
tac | 44 | 4.4% |
qad | 44 | 4.4% |
Other values (17) | 498 |
ACCT_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 99 |
---|---|
Distinct (%) | 10.0% |
Missing | 9 |
Missing (%) | 0.9% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20185686 |
Minimum | 20170223 |
---|---|
Maximum | 20201026 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20170223 |
---|---|
5-th percentile | 20170474 |
Q1 | 20180174 |
median | 20190124 |
Q3 | 20191125 |
95-th percentile | 20200825 |
Maximum | 20201026 |
Range | 30803 |
Interquartile range (IQR) | 10951.5 |
Descriptive statistics
Standard deviation | 10664.178 |
---|---|
Coefficient of variation (CV) | 0.00052830396 |
Kurtosis | -1.2548762 |
Mean | 20185686 |
Median Absolute Deviation (MAD) | 9798 |
Skewness | -0.027847584 |
Sum | 2.0004015 × 1010 |
Variance | 1.1372469 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20191125 | 26 | 2.6% |
20200525 | 26 | 2.6% |
20200825 | 24 | 2.4% |
20170724 | 24 | 2.4% |
20190524 | 23 | 2.3% |
20190225 | 23 | 2.3% |
20181224 | 23 | 2.3% |
20200625 | 23 | 2.3% |
20200427 | 23 | 2.3% |
20170925 | 23 | 2.3% |
Other values (89) | 753 |
Value | Count | Frequency (%) |
20170223 | 1 | 0.1% |
20170224 | 5 | 0.5% |
20170323 | 2 | 0.2% |
20170324 | 19 | |
20170412 | 1 | 0.1% |
20170424 | 21 | |
20170425 | 1 | 0.1% |
20170523 | 3 | 0.3% |
20170524 | 18 | |
20170623 | 2 | 0.2% |
Value | Count | Frequency (%) |
20201026 | 7 | 0.7% |
20200928 | 1 | 0.1% |
20200925 | 22 | |
20200825 | 24 | |
20200730 | 1 | 0.1% |
20200729 | 1 | 0.1% |
20200727 | 21 | |
20200625 | 23 | |
20200525 | 26 | |
20200427 | 23 |
SLIP_NO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 208 |
---|---|
Distinct (%) | 21.0% |
Missing | 9 |
Missing (%) | 0.9% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 77.810293 |
Minimum | 1 |
---|---|
Maximum | 2989 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 1 |
Q1 | 1 |
median | 10 |
Q3 | 64 |
95-th percentile | 241 |
Maximum | 2989 |
Range | 2988 |
Interquartile range (IQR) | 63 |
Descriptive statistics
Standard deviation | 243.36999 |
---|---|
Coefficient of variation (CV) | 3.1277352 |
Kurtosis | 52.323156 |
Mean | 77.810293 |
Median Absolute Deviation (MAD) | 9 |
Skewness | 6.614741 |
Sum | 77110 |
Variance | 59228.954 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1 | 361 | |
4 | 31 | 3.1% |
2 | 28 | 2.8% |
7 | 21 | 2.1% |
3 | 20 | 2.0% |
13 | 15 | 1.5% |
5 | 12 | 1.2% |
16 | 10 | 1.0% |
6 | 10 | 1.0% |
28 | 9 | 0.9% |
Other values (198) | 474 |
Value | Count | Frequency (%) |
1 | 361 | |
2 | 28 | 2.8% |
3 | 20 | 2.0% |
4 | 31 | 3.1% |
5 | 12 | 1.2% |
6 | 10 | 1.0% |
7 | 21 | 2.1% |
8 | 5 | 0.5% |
9 | 2 | 0.2% |
10 | 7 | 0.7% |
Value | Count | Frequency (%) |
2989 | 1 | |
2322 | 1 | |
2162 | 1 | |
2153 | 1 | |
2118 | 1 | |
1617 | 1 | |
1616 | 1 | |
1465 | 1 | |
1407 | 1 | |
1384 | 1 |
UPDT_TS
Date
Distinct | 904 |
---|---|
Distinct (%) | 91.1% |
Missing | 8 |
Missing (%) | 0.8% |
Memory size | 7.9 KiB |
Minimum | 2017-02-23 14:50:00 |
---|---|
Maximum | 2020-10-26 09:43:00 |
UPDT_ENO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 90 |
---|---|
Distinct (%) | 9.1% |
Missing | 8 |
Missing (%) | 0.8% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5980.3206 |
Minimum | 1118 |
---|---|
Maximum | 52549 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1118 |
---|---|
5-th percentile | 1818 |
Q1 | 6033 |
median | 6054 |
Q3 | 6076 |
95-th percentile | 7626 |
Maximum | 52549 |
Range | 51431 |
Interquartile range (IQR) | 43 |
Descriptive statistics
Standard deviation | 2856.1045 |
---|---|
Coefficient of variation (CV) | 0.47758385 |
Kurtosis | 212.25781 |
Mean | 5980.3206 |
Median Absolute Deviation (MAD) | 22 |
Skewness | 12.884671 |
Sum | 5932478 |
Variance | 8157333.1 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
6050 | 75 | 7.5% |
6054 | 47 | 4.7% |
6076 | 45 | 4.5% |
6040 | 44 | 4.4% |
6066 | 44 | 4.4% |
6002 | 42 | 4.2% |
6063 | 37 | 3.7% |
6077 | 36 | 3.6% |
6012 | 34 | 3.4% |
6033 | 30 | 3.0% |
Other values (80) | 558 |
Value | Count | Frequency (%) |
1118 | 1 | 0.1% |
1214 | 4 | |
1256 | 7 | |
1585 | 1 | 0.1% |
1592 | 1 | 0.1% |
1596 | 2 | 0.2% |
1603 | 7 | |
1618 | 3 | |
1641 | 2 | 0.2% |
1648 | 2 | 0.2% |
Value | Count | Frequency (%) |
52549 | 2 | 0.2% |
52485 | 1 | 0.1% |
7763 | 1 | 0.1% |
7759 | 2 | 0.2% |
7711 | 10 | |
7706 | 7 | |
7682 | 5 | 0.5% |
7656 | 13 | |
7626 | 14 | |
7610 | 3 | 0.3% |
UPDT_BRCD
Categorical
HIGH CORRELATION
 
Distinct | 27 |
---|---|
Distinct (%) | 2.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
ACS | |
---|---|
TLB | 48 |
TOA | 48 |
TAB | 48 |
TAA | 47 |
Other values (22) |
Length
Max length | 4 |
---|---|
Median length | 3 |
Mean length | 3.008 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | THA |
---|---|
2nd row | TNA |
3rd row | <NA> |
4th row | TBB |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
ACS | 88 | 8.8% |
TLB | 48 | 4.8% |
TOA | 48 | 4.8% |
TAB | 48 | 4.8% |
TAA | 47 | 4.7% |
TPA | 46 | 4.6% |
THO | 46 | 4.6% |
THA | 44 | 4.4% |
TAC | 44 | 4.4% |
QAD | 44 | 4.4% |
Other values (17) | 497 |
Length
Value | Count | Frequency (%) |
acs | 88 | 8.8% |
toa | 48 | 4.8% |
tab | 48 | 4.8% |
tlb | 48 | 4.8% |
taa | 47 | 4.7% |
tpa | 46 | 4.6% |
tho | 46 | 4.6% |
tha | 44 | 4.4% |
tac | 44 | 4.4% |
qad | 44 | 4.4% |
Other values (17) | 497 |
REG_TS
Date
Distinct | 979 |
---|---|
Distinct (%) | 97.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2017-02-23 14:39:00 |
---|---|
Maximum | 2020-10-26 09:43:00 |
REG_ENO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 71 |
---|---|
Distinct (%) | 7.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5858.766 |
Minimum | 1214 |
---|---|
Maximum | 7763 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1214 |
---|---|
5-th percentile | 1815 |
Q1 | 6033 |
median | 6054 |
Q3 | 6076 |
95-th percentile | 7626 |
Maximum | 7763 |
Range | 6549 |
Interquartile range (IQR) | 43 |
Descriptive statistics
Standard deviation | 1224.4367 |
---|---|
Coefficient of variation (CV) | 0.20899224 |
Kurtosis | 7.1512426 |
Mean | 5858.766 |
Median Absolute Deviation (MAD) | 22 |
Skewness | -2.6306843 |
Sum | 5858766 |
Variance | 1499245.1 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
6050 | 77 | 7.7% |
6066 | 47 | 4.7% |
6076 | 46 | 4.6% |
6040 | 46 | 4.6% |
6054 | 44 | 4.4% |
6002 | 43 | 4.3% |
6077 | 38 | 3.8% |
6063 | 38 | 3.8% |
6012 | 34 | 3.4% |
6033 | 32 | 3.2% |
Other values (61) | 555 |
Value | Count | Frequency (%) |
1214 | 4 | |
1256 | 7 | |
1596 | 2 | 0.2% |
1603 | 8 | |
1618 | 3 | 0.3% |
1648 | 1 | 0.1% |
1681 | 1 | 0.1% |
1688 | 4 | |
1692 | 2 | 0.2% |
1694 | 1 | 0.1% |
Value | Count | Frequency (%) |
7763 | 1 | 0.1% |
7759 | 1 | 0.1% |
7711 | 10 | |
7706 | 7 | |
7682 | 5 | 0.5% |
7656 | 15 | |
7626 | 14 | |
7610 | 2 | 0.2% |
7579 | 13 | |
6202 | 5 | 0.5% |
REG_BRCD
Categorical
HIGH CORRELATION
 
Distinct | 26 |
---|---|
Distinct (%) | 2.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
ACS | |
---|---|
TLB | 48 |
TAA | 48 |
TOA | 48 |
TAB | 48 |
Other values (21) |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | THA |
---|---|
2nd row | TNA |
3rd row | TAC |
4th row | TBB |
5th row | TAD |
Common Values
Value | Count | Frequency (%) |
ACS | 88 | 8.8% |
TLB | 48 | 4.8% |
TAA | 48 | 4.8% |
TOA | 48 | 4.8% |
TAB | 48 | 4.8% |
TPA | 47 | 4.7% |
THO | 46 | 4.6% |
QAD | 45 | 4.5% |
TAC | 45 | 4.5% |
TPB | 44 | 4.4% |
Other values (16) | 493 |
Length
Value | Count | Frequency (%) |
acs | 88 | 8.8% |
taa | 48 | 4.8% |
toa | 48 | 4.8% |
tab | 48 | 4.8% |
tlb | 48 | 4.8% |
tpa | 47 | 4.7% |
tho | 46 | 4.6% |
qad | 45 | 4.5% |
tac | 45 | 4.5% |
tad | 44 | 4.4% |
Other values (16) | 493 |
GENRT_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 302 |
---|---|
Distinct (%) | 30.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20185783 |
Minimum | 20170223 |
---|---|
Maximum | 20201026 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20170223 |
---|---|
5-th percentile | 20170512 |
Q1 | 20180221 |
median | 20190123 |
Q3 | 20191125 |
95-th percentile | 20200820 |
Maximum | 20201026 |
Range | 30803 |
Interquartile range (IQR) | 10904.25 |
Descriptive statistics
Standard deviation | 10687.372 |
---|---|
Coefficient of variation (CV) | 0.00052945046 |
Kurtosis | -1.257933 |
Mean | 20185783 |
Median Absolute Deviation (MAD) | 9801 |
Skewness | -0.036945547 |
Sum | 2.0185783 × 1010 |
Variance | 1.1421993 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20170424 | 11 | 1.1% |
20170724 | 11 | 1.1% |
20180724 | 10 | 1.0% |
20191021 | 10 | 1.0% |
20190325 | 10 | 1.0% |
20180524 | 10 | 1.0% |
20171023 | 9 | 0.9% |
20170925 | 9 | 0.9% |
20190924 | 9 | 0.9% |
20200219 | 9 | 0.9% |
Other values (292) | 902 |
Value | Count | Frequency (%) |
20170223 | 1 | 0.1% |
20170224 | 5 | |
20170315 | 1 | 0.1% |
20170317 | 3 | |
20170320 | 3 | |
20170321 | 1 | 0.1% |
20170322 | 1 | 0.1% |
20170323 | 5 | |
20170324 | 7 | |
20170412 | 1 | 0.1% |
Value | Count | Frequency (%) |
20201026 | 2 | |
20201022 | 2 | |
20201021 | 2 | |
20201020 | 1 | 0.1% |
20201019 | 2 | |
20201016 | 1 | 0.1% |
20201015 | 3 | |
20201013 | 1 | 0.1% |
20201006 | 1 | 0.1% |
20200928 | 1 | 0.1% |
CARD_STTL_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 99 |
---|---|
Distinct (%) | 9.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20185813 |
Minimum | 20170223 |
---|---|
Maximum | 20201026 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20170223 |
---|---|
5-th percentile | 20170518 |
Q1 | 20180225 |
median | 20190124 |
Q3 | 20191125 |
95-th percentile | 20200825 |
Maximum | 20201026 |
Range | 30803 |
Interquartile range (IQR) | 10899.75 |
Descriptive statistics
Standard deviation | 10704.795 |
---|---|
Coefficient of variation (CV) | 0.0005303128 |
Kurtosis | -1.2618778 |
Mean | 20185813 |
Median Absolute Deviation (MAD) | 9798 |
Skewness | -0.039420524 |
Sum | 2.0185813 × 1010 |
Variance | 1.1459264 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20191125 | 26 | 2.6% |
20200525 | 26 | 2.6% |
20200825 | 24 | 2.4% |
20170724 | 24 | 2.4% |
20190225 | 23 | 2.3% |
20170925 | 23 | 2.3% |
20190924 | 23 | 2.3% |
20190624 | 23 | 2.3% |
20181224 | 23 | 2.3% |
20190524 | 23 | 2.3% |
Other values (89) | 762 |
Value | Count | Frequency (%) |
20170223 | 1 | 0.1% |
20170224 | 5 | 0.5% |
20170323 | 2 | 0.2% |
20170324 | 19 | |
20170412 | 1 | 0.1% |
20170424 | 21 | |
20170425 | 1 | 0.1% |
20170523 | 3 | 0.3% |
20170524 | 18 | |
20170623 | 2 | 0.2% |
Value | Count | Frequency (%) |
20201026 | 15 | |
20200928 | 1 | 0.1% |
20200925 | 22 | |
20200825 | 24 | |
20200730 | 1 | 0.1% |
20200729 | 1 | 0.1% |
20200727 | 21 | |
20200625 | 23 | |
20200525 | 26 | |
20200427 | 23 |
DEPT_CD | DECIS_DY | DECIS_NO | STLE_CD | CNFM_ENO | RMT_BNK_CD | ACCT_DEPT_CD | ACCT_DY | SLIP_NO | UPDT_ENO | UPDT_BRCD | REG_ENO | REG_BRCD | GENRT_DY | CARD_STTL_DY | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DEPT_CD | 1.000 | 0.087 | 0.346 | 0.635 | 0.197 | 0.998 | 1.000 | 0.096 | 0.411 | 0.585 | 1.000 | 0.636 | 1.000 | 0.087 | 0.085 |
DECIS_DY | 0.087 | 1.000 | 0.047 | 0.263 | 0.064 | 0.101 | 0.099 | 1.000 | 0.191 | 0.073 | 0.099 | 0.249 | 0.087 | 1.000 | 1.000 |
DECIS_NO | 0.346 | 0.047 | 1.000 | 0.000 | 0.000 | 0.103 | 0.345 | 0.047 | 0.397 | 0.043 | 0.345 | 0.032 | 0.346 | 0.047 | 0.045 |
STLE_CD | 0.635 | 0.263 | 0.000 | 1.000 | 0.000 | 0.348 | 0.634 | 0.263 | 0.000 | 0.017 | 0.635 | 0.069 | 0.635 | 0.263 | 0.263 |
CNFM_ENO | 0.197 | 0.064 | 0.000 | 0.000 | 1.000 | 0.000 | 0.196 | 0.064 | 0.000 | 0.000 | 0.197 | 0.000 | 0.197 | 0.064 | 0.065 |
RMT_BNK_CD | 0.998 | 0.101 | 0.103 | 0.348 | 0.000 | 1.000 | 0.998 | 0.104 | 0.000 | 0.161 | 0.998 | 0.183 | 0.998 | 0.101 | 0.103 |
ACCT_DEPT_CD | 1.000 | 0.099 | 0.345 | 0.634 | 0.196 | 0.998 | 1.000 | 0.096 | 0.411 | 0.586 | 1.000 | 0.637 | 1.000 | 0.099 | 0.096 |
ACCT_DY | 0.096 | 1.000 | 0.047 | 0.263 | 0.064 | 0.104 | 0.096 | 1.000 | 0.190 | 0.074 | 0.096 | 0.245 | 0.096 | 1.000 | 1.000 |
SLIP_NO | 0.411 | 0.191 | 0.397 | 0.000 | 0.000 | 0.000 | 0.411 | 0.190 | 1.000 | 0.000 | 0.411 | 0.127 | 0.411 | 0.191 | 0.190 |
UPDT_ENO | 0.585 | 0.073 | 0.043 | 0.017 | 0.000 | 0.161 | 0.586 | 0.074 | 0.000 | 1.000 | 0.585 | 0.657 | 0.585 | 0.073 | 0.074 |
UPDT_BRCD | 1.000 | 0.099 | 0.345 | 0.635 | 0.197 | 0.998 | 1.000 | 0.096 | 0.411 | 0.585 | 1.000 | 0.638 | 1.000 | 0.099 | 0.096 |
REG_ENO | 0.636 | 0.249 | 0.032 | 0.069 | 0.000 | 0.183 | 0.637 | 0.245 | 0.127 | 0.657 | 0.638 | 1.000 | 0.636 | 0.249 | 0.250 |
REG_BRCD | 1.000 | 0.087 | 0.346 | 0.635 | 0.197 | 0.998 | 1.000 | 0.096 | 0.411 | 0.585 | 1.000 | 0.636 | 1.000 | 0.087 | 0.085 |
GENRT_DY | 0.087 | 1.000 | 0.047 | 0.263 | 0.064 | 0.101 | 0.099 | 1.000 | 0.191 | 0.073 | 0.099 | 0.249 | 0.087 | 1.000 | 1.000 |
CARD_STTL_DY | 0.085 | 1.000 | 0.045 | 0.263 | 0.065 | 0.103 | 0.096 | 1.000 | 0.190 | 0.074 | 0.096 | 0.250 | 0.085 | 1.000 | 1.000 |
UPDT_BRCD | ACCT_DEPT_CD | DECIS_NO | DEPT_CD | REG_BRCD | ACCT_DVCD | STLE_CD | |
---|---|---|---|---|---|---|---|
UPDT_BRCD | 1.000 | 1.000 | 0.171 | 1.000 | 1.000 | 1.000 | 0.504 |
ACCT_DEPT_CD | 1.000 | 1.000 | 0.171 | 1.000 | 1.000 | 1.000 | 0.504 |
DECIS_NO | 0.171 | 0.171 | 1.000 | 0.172 | 0.172 | 1.000 | 0.000 |
DEPT_CD | 1.000 | 1.000 | 0.172 | 1.000 | 1.000 | 1.000 | 0.504 |
REG_BRCD | 1.000 | 1.000 | 0.172 | 1.000 | 1.000 | 1.000 | 0.504 |
ACCT_DVCD | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
STLE_CD | 0.504 | 0.504 | 0.000 | 0.504 | 0.504 | 1.000 | 1.000 |
DECIS_DY | CNFM_ENO | RMT_BNK_CD | ACCT_DY | SLIP_NO | UPDT_ENO | REG_ENO | GENRT_DY | CARD_STTL_DY | DEPT_CD | DECIS_NO | STLE_CD | ACCT_DVCD | ACCT_DEPT_CD | UPDT_BRCD | REG_BRCD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DECIS_DY | 1.000 | 0.315 | 0.056 | 1.000 | -0.038 | 0.166 | 0.203 | 1.000 | 1.000 | 0.046 | 0.039 | 0.174 | 1.000 | 0.052 | 0.052 | 0.046 |
CNFM_ENO | 0.315 | 1.000 | 0.069 | 0.315 | -0.013 | 0.131 | 0.135 | 0.315 | 0.317 | 0.155 | 0.000 | 0.000 | 1.000 | 0.154 | 0.154 | 0.155 |
RMT_BNK_CD | 0.056 | 0.069 | 1.000 | 0.060 | -0.214 | -0.080 | -0.067 | 0.056 | 0.061 | 0.985 | 0.039 | 0.424 | 1.000 | 0.985 | 0.985 | 0.985 |
ACCT_DY | 1.000 | 0.315 | 0.060 | 1.000 | -0.038 | 0.163 | 0.207 | 1.000 | 1.000 | 0.050 | 0.038 | 0.174 | 1.000 | 0.050 | 0.050 | 0.050 |
SLIP_NO | -0.038 | -0.013 | -0.214 | -0.038 | 1.000 | -0.028 | -0.042 | -0.038 | -0.038 | 0.175 | 0.257 | 0.000 | 1.000 | 0.175 | 0.175 | 0.175 |
UPDT_ENO | 0.166 | 0.131 | -0.080 | 0.163 | -0.028 | 1.000 | 0.911 | 0.166 | 0.162 | 0.365 | 0.032 | 0.028 | 1.000 | 0.365 | 0.365 | 0.365 |
REG_ENO | 0.203 | 0.135 | -0.067 | 0.207 | -0.042 | 0.911 | 1.000 | 0.203 | 0.199 | 0.383 | 0.018 | 0.041 | 1.000 | 0.383 | 0.384 | 0.383 |
GENRT_DY | 1.000 | 0.315 | 0.056 | 1.000 | -0.038 | 0.166 | 0.203 | 1.000 | 1.000 | 0.046 | 0.039 | 0.174 | 1.000 | 0.052 | 0.052 | 0.046 |
CARD_STTL_DY | 1.000 | 0.317 | 0.061 | 1.000 | -0.038 | 0.162 | 0.199 | 1.000 | 1.000 | 0.045 | 0.037 | 0.174 | 1.000 | 0.050 | 0.051 | 0.045 |
DEPT_CD | 0.046 | 0.155 | 0.985 | 0.050 | 0.175 | 0.365 | 0.383 | 0.046 | 0.045 | 1.000 | 0.172 | 0.504 | 1.000 | 1.000 | 1.000 | 1.000 |
DECIS_NO | 0.039 | 0.000 | 0.039 | 0.038 | 0.257 | 0.032 | 0.018 | 0.039 | 0.037 | 0.172 | 1.000 | 0.000 | 1.000 | 0.171 | 0.171 | 0.172 |
STLE_CD | 0.174 | 0.000 | 0.424 | 0.174 | 0.000 | 0.028 | 0.041 | 0.174 | 0.174 | 0.504 | 0.000 | 1.000 | 1.000 | 0.504 | 0.504 | 0.504 |
ACCT_DVCD | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
ACCT_DEPT_CD | 0.052 | 0.154 | 0.985 | 0.050 | 0.175 | 0.365 | 0.383 | 0.052 | 0.050 | 1.000 | 0.171 | 0.504 | 1.000 | 1.000 | 1.000 | 1.000 |
UPDT_BRCD | 0.052 | 0.154 | 0.985 | 0.050 | 0.175 | 0.365 | 0.384 | 0.052 | 0.051 | 1.000 | 0.171 | 0.504 | 1.000 | 1.000 | 1.000 | 1.000 |
REG_BRCD | 0.046 | 0.155 | 0.985 | 0.050 | 0.175 | 0.365 | 0.383 | 0.046 | 0.045 | 1.000 | 0.172 | 0.504 | 1.000 | 1.000 | 1.000 | 1.000 |
DEPT_CD | DECIS_DY | DECIS_NO | STLE_CD | CNFM_ENO | RMT_BNK_CD | ACCT_DVCD | ACCT_DEPT_CD | ACCT_DY | SLIP_NO | UPDT_TS | UPDT_ENO | UPDT_BRCD | REG_TS | REG_ENO | REG_BRCD | GENRT_DY | CARD_STTL_DY | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | THA | 20201026 | 1 | 1 | 1173 | 3 | 2 | THA | 20201026 | 122 | 2020-10-26 9:43 | 6069 | THA | 2020-10-26 9:43 | 6069 | THA | 20201026 | 20201026 |
1 | TNA | 20201026 | 1 | 1 | 1195 | 4 | 2 | TNA | 20201026 | 1 | 2020-10-26 8:43 | 6077 | TNA | 2020-10-26 8:43 | 6077 | TNA | 20201026 | 20201026 |
2 | TAC | 20201022 | 1 | <NA> | 1258 | 81 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2020-10-22 15:18 | 6059 | TAC | 20201022 | 20201026 |
3 | TBB | 20201022 | 1 | 1 | 1205 | 32 | 2 | TBB | 20201026 | 16 | 2020-10-26 9:18 | 6153 | TBB | 2020-10-22 13:20 | 6153 | TBB | 20201022 | 20201026 |
4 | TAD | 20201021 | 1 | <NA> | 1377 | 81 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2020-10-21 17:18 | 6040 | TAD | 20201021 | 20201026 |
5 | TQA | 20201021 | 1 | <NA> | 1262 | 88 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2020-10-21 9:23 | 6070 | TQA | 20201021 | 20201026 |
6 | TPB | 20201020 | 1 | <NA> | 1367 | 3 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2020-10-20 16:18 | 6152 | TPB | 20201020 | 20201026 |
7 | TPA | 20201019 | 1 | <NA> | 1228 | 3 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2020-10-19 16:39 | 6066 | TPA | 20201019 | 20201026 |
8 | THB | 20201019 | 1 | <NA> | 1141 | 88 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2020-10-19 15:13 | 6003 | THB | 20201019 | 20201026 |
9 | TLA | 20201016 | 1 | 1 | 1212 | 4 | 2 | TLA | 20201026 | 1 | 2020-10-26 9:01 | 6202 | TLA | 2020-10-16 10:29 | 6202 | TLA | 20201016 | 20201026 |
DEPT_CD | DECIS_DY | DECIS_NO | STLE_CD | CNFM_ENO | RMT_BNK_CD | ACCT_DVCD | ACCT_DEPT_CD | ACCT_DY | SLIP_NO | UPDT_TS | UPDT_ENO | UPDT_BRCD | REG_TS | REG_ENO | REG_BRCD | GENRT_DY | CARD_STTL_DY | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | TAC | 20170317 | 1 | 1 | 1185 | 81 | 2 | TAC | 20170324 | 3 | 2017-03-24 8:47 | 6047 | TAC | 2017-03-17 18:51 | 6047 | TAC | 20170317 | 20170324 |
991 | THB | 20170317 | 1 | 1 | 1037 | 88 | 2 | THB | 20170324 | 1 | 2017-03-24 9:16 | 6018 | THB | 2017-03-17 11:38 | 6018 | THB | 20170317 | 20170324 |
992 | ACS | 20170315 | 1 | 1 | <NA> | 4 | 2 | ACS | 20170324 | 221 | 2017-03-24 9:03 | 1214 | ACS | 2017-03-15 15:39 | 1214 | ACS | 20170315 | 20170324 |
993 | TAB | 20170317 | 1 | 1 | 1127 | 4 | 2 | TAB | 20170324 | 1 | 2017-03-24 8:59 | 1764 | TAB | 2017-03-17 11:09 | 6040 | TAB | 20170317 | 20170324 |
994 | TPA | 20170224 | 1 | 1 | 1187 | 3 | 2 | TPA | 20170224 | 110 | 2017-02-24 15:26 | 6066 | TPA | 2017-02-24 15:26 | 6066 | TPA | 20170224 | 20170224 |
995 | TOA | 20170224 | 1 | 1 | 1132 | 3 | 2 | TOA | 20170224 | 71 | 2017-02-24 14:04 | 6076 | TOA | 2017-02-24 12:54 | 6076 | TOA | 20170224 | 20170224 |
996 | TAC | 20170224 | 1 | 1 | 1185 | 81 | 2 | TAC | 20170224 | 34 | 2017-02-24 10:09 | 6047 | TAC | 2017-02-24 10:08 | 6047 | TAC | 20170224 | 20170224 |
997 | TMA | 20170224 | 1 | 1 | 1095 | 4 | 2 | TMA | 20170224 | 33 | 2017-02-24 10:01 | 6036 | TMA | 2017-02-24 10:01 | 6036 | TMA | 20170224 | 20170224 |
998 | TJA | 20170224 | 1 | 2 | 1142 | 11 | 2 | TJA | 20170224 | 1 | 2017-02-24 9:14 | 6053 | TJA | 2017-02-24 9:14 | 6053 | TJA | 20170224 | 20170224 |
999 | TLB | 20170223 | 1 | 1 | 1157 | 3 | 2 | TLB | 20170223 | 60 | 2017-02-23 14:50 | 6054 | TLB | 2017-02-23 14:39 | 6054 | TLB | 20170223 | 20170223 |