Dataset statistics
Number of variables | 18 |
---|---|
Number of observations | 1000 |
Missing cells | 1504 |
Missing cells (%) | 8.4% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 154.4 KiB |
Average record size in memory | 158.1 B |
Variable types
Numeric | 9 |
---|---|
Categorical | 7 |
DateTime | 2 |
Dataset
Description | 한국주택금융공사에서 발행한 유동화자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) 에 관한 내용입니다. |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073229/fileData.do |
DPOSIT_THING_KIND_CD has constant value "" | Constant |
REG_BR_CD is highly overall correlated with UPDT_ENO and 1 other fields | High correlation |
UPDT_BRCD is highly overall correlated with UPDT_ENO and 1 other fields | High correlation |
DPOSIT_ADV_DY is highly overall correlated with REL_PTNO and 4 other fields | High correlation |
REL_PTNO is highly overall correlated with DPOSIT_ADV_DY and 4 other fields | High correlation |
TRNSFER_DEMND_ACPT_PTNO is highly overall correlated with DPOSIT_ADV_DY and 5 other fields | High correlation |
DPOSIT_ACPT_DY is highly overall correlated with DPOSIT_ADV_DY and 4 other fields | High correlation |
RECKON_DY is highly overall correlated with DPOSIT_ADV_DY and 4 other fields | High correlation |
DECIS_DY is highly overall correlated with DPOSIT_ADV_DY and 4 other fields | High correlation |
UPDT_ENO is highly overall correlated with UPDT_BRCD and 1 other fields | High correlation |
DPOSIT_PAY_MTHD_CD is highly overall correlated with TRNSFER_DEMND_ACPT_PTNO | High correlation |
DPOSIT_SEQ is highly imbalanced (82.3%) | Imbalance |
EXEC_PTTN_SEQ is highly imbalanced (93.3%) | Imbalance |
DPOSIT_RSCD is highly imbalanced (97.3%) | Imbalance |
DPOSIT_PAY_MTHD_CD is highly imbalanced (94.7%) | Imbalance |
UPDT_BRCD is highly imbalanced (58.5%) | Imbalance |
TRNSFER_DEMND_ACPT_PTNO has 29 (2.9%) missing values | Missing |
DPOSIT_ACPT_DY has 19 (1.9%) missing values | Missing |
UPDT_TS has 728 (72.8%) missing values | Missing |
UPDT_ENO has 728 (72.8%) missing values | Missing |
Reproduction
Analysis started | 2023-12-12 01:12:22.920360 |
---|---|
Analysis finished | 2023-12-12 01:12:35.724954 |
Duration | 12.8 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
MDBTR_CUST_NO
Real number (ℝ)
Distinct | 939 |
---|---|
Distinct (%) | 93.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 94199462 |
Minimum | 7884180 |
---|---|
Maximum | 1.3603451 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 7884180 |
---|---|
5-th percentile | 42706787 |
Q1 | 81967306 |
median | 97161579 |
Q3 | 1.1357951 × 108 |
95-th percentile | 1.2355048 × 108 |
Maximum | 1.3603451 × 108 |
Range | 1.2815033 × 108 |
Interquartile range (IQR) | 31612201 |
Descriptive statistics
Standard deviation | 24245407 |
---|---|
Coefficient of variation (CV) | 0.25738371 |
Kurtosis | 1.1041705 |
Mean | 94199462 |
Median Absolute Deviation (MAD) | 15592892 |
Skewness | -1.0670492 |
Sum | 9.4199462 × 1010 |
Variance | 5.8783976 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
95624351 | 8 | 0.8% |
97747142 | 3 | 0.3% |
119620163 | 3 | 0.3% |
119368742 | 3 | 0.3% |
119150594 | 3 | 0.3% |
112880612 | 3 | 0.3% |
106235053 | 3 | 0.3% |
106347608 | 3 | 0.3% |
128336338 | 3 | 0.3% |
62931938 | 3 | 0.3% |
Other values (929) | 965 |
Value | Count | Frequency (%) |
7884180 | 1 | |
10869244 | 1 | |
11786494 | 1 | |
11794114 | 1 | |
14470383 | 1 | |
14929656 | 2 | |
15360874 | 1 | |
17194585 | 1 | |
18716043 | 1 | |
19006723 | 1 |
Value | Count | Frequency (%) |
136034509 | 1 | 0.1% |
130043473 | 2 | |
129907119 | 1 | 0.1% |
129398236 | 1 | 0.1% |
128943598 | 1 | 0.1% |
128881391 | 1 | 0.1% |
128690087 | 1 | 0.1% |
128336338 | 3 | |
128236111 | 1 | 0.1% |
128050287 | 1 | 0.1% |
DPOSIT_ADV_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 248 |
---|---|
Distinct (%) | 24.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20199160 |
Minimum | 20180518 |
---|---|
Maximum | 20201030 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180518 |
---|---|
5-th percentile | 20191113 |
Q1 | 20200224 |
median | 20200423 |
Q3 | 20200805 |
95-th percentile | 20201008 |
Maximum | 20201030 |
Range | 20512 |
Interquartile range (IQR) | 581 |
Descriptive statistics
Standard deviation | 3490.1003 |
---|---|
Coefficient of variation (CV) | 0.00017278443 |
Kurtosis | 4.0040964 |
Mean | 20199160 |
Median Absolute Deviation (MAD) | 290 |
Skewness | -2.2297203 |
Sum | 2.019916 × 1010 |
Variance | 12180800 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20191119 | 12 | 1.2% |
20200421 | 11 | 1.1% |
20200326 | 11 | 1.1% |
20200924 | 11 | 1.1% |
20200318 | 11 | 1.1% |
20200429 | 10 | 1.0% |
20200928 | 10 | 1.0% |
20200716 | 9 | 0.9% |
20200407 | 9 | 0.9% |
20200707 | 9 | 0.9% |
Other values (238) | 897 |
Value | Count | Frequency (%) |
20180518 | 1 | 0.1% |
20181030 | 3 | |
20191015 | 1 | 0.1% |
20191016 | 3 | |
20191017 | 1 | 0.1% |
20191018 | 5 | |
20191021 | 2 | 0.2% |
20191022 | 2 | 0.2% |
20191023 | 2 | 0.2% |
20191024 | 1 | 0.1% |
Value | Count | Frequency (%) |
20201030 | 1 | 0.1% |
20201028 | 3 | |
20201027 | 1 | 0.1% |
20201026 | 1 | 0.1% |
20201023 | 4 | |
20201022 | 2 | 0.2% |
20201021 | 3 | |
20201020 | 6 | |
20201019 | 6 | |
20201016 | 6 |
DPOSIT_SEQ
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
2 | 38 |
3 | 13 |
4 | 2 |
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 | 947 | |
2 | 38 | 3.8% |
3 | 13 | 1.3% |
4 | 2 | 0.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 947 | |
2 | 38 | 3.8% |
3 | 13 | 1.3% |
4 | 2 | 0.2% |
REL_PTNO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 986 |
---|---|
Distinct (%) | 98.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0198385 × 1010 |
Minimum | 2.0180103 × 1010 |
---|---|
Maximum | 2.0200106 × 1010 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 2.0180103 × 1010 |
---|---|
5-th percentile | 2.0190107 × 1010 |
Q1 | 2.0200101 × 1010 |
median | 2.0200102 × 1010 |
Q3 | 2.0200104 × 1010 |
95-th percentile | 2.0200105 × 1010 |
Maximum | 2.0200106 × 1010 |
Range | 20002868 |
Interquartile range (IQR) | 3485.5 |
Descriptive statistics
Standard deviation | 3901911.7 |
---|---|
Coefficient of variation (CV) | 0.00019317939 |
Kurtosis | 2.7419996 |
Mean | 2.0198385 × 1010 |
Median Absolute Deviation (MAD) | 1662.5 |
Skewness | -1.9918068 |
Sum | 2.0198385 × 1013 |
Variance | 1.5224915 × 1013 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190107782 | 3 | 0.3% |
20200103581 | 3 | 0.3% |
20180105508 | 3 | 0.3% |
20200101470 | 3 | 0.3% |
20190107060 | 2 | 0.2% |
20200105344 | 2 | 0.2% |
20200104431 | 2 | 0.2% |
20190108055 | 2 | 0.2% |
20200104672 | 2 | 0.2% |
20200100478 | 2 | 0.2% |
Other values (976) | 976 |
Value | Count | Frequency (%) |
20180102652 | 1 | 0.1% |
20180104024 | 1 | 0.1% |
20180105508 | 3 | |
20190103267 | 1 | 0.1% |
20190106275 | 1 | 0.1% |
20190106397 | 1 | 0.1% |
20190106424 | 1 | 0.1% |
20190106543 | 1 | 0.1% |
20190106759 | 1 | 0.1% |
20190106935 | 1 | 0.1% |
Value | Count | Frequency (%) |
20200105520 | 1 | |
20200105507 | 1 | |
20200105474 | 1 | |
20200105473 | 1 | |
20200105454 | 1 | |
20200105443 | 1 | |
20200105430 | 1 | |
20200105426 | 1 | |
20200105423 | 1 | |
20200105416 | 1 |
EXEC_PTTN_SEQ
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
2 | 12 |
3 | 3 |
6 | 1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 984 | |
2 | 12 | 1.2% |
3 | 3 | 0.3% |
6 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 984 | |
2 | 12 | 1.2% |
3 | 3 | 0.3% |
6 | 1 | 0.1% |
TRNSFER_DEMND_ACPT_PTNO
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 927 |
---|---|
Distinct (%) | 95.5% |
Missing | 29 |
Missing (%) | 2.9% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0197716 × 1010 |
Minimum | 2.0180403 × 1010 |
---|---|
Maximum | 2.0200407 × 1010 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 2.0180403 × 1010 |
---|---|
5-th percentile | 2.0190406 × 1010 |
Q1 | 2.0190407 × 1010 |
median | 2.0200402 × 1010 |
Q3 | 2.0200404 × 1010 |
95-th percentile | 2.0200406 × 1010 |
Maximum | 2.0200407 × 1010 |
Range | 20003901 |
Interquartile range (IQR) | 9997165 |
Descriptive statistics
Standard deviation | 4526322.3 |
---|---|
Coefficient of variation (CV) | 0.0002241007 |
Kurtosis | -0.24444946 |
Mean | 2.0197716 × 1010 |
Median Absolute Deviation (MAD) | 2519 |
Skewness | -1.1776648 |
Sum | 1.9611982 × 1013 |
Variance | 2.0487593 × 1013 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20200403874 | 3 | 0.3% |
20200406172 | 3 | 0.3% |
20190407236 | 3 | 0.3% |
20200403070 | 3 | 0.3% |
20200403727 | 3 | 0.3% |
20200403672 | 3 | 0.3% |
20180406245 | 3 | 0.3% |
20200406550 | 3 | 0.3% |
20200400508 | 3 | 0.3% |
20200404689 | 3 | 0.3% |
Other values (917) | 941 | |
(Missing) | 29 | 2.9% |
Value | Count | Frequency (%) |
20180402953 | 1 | 0.1% |
20180406245 | 3 | |
20190403786 | 1 | 0.1% |
20190404758 | 1 | 0.1% |
20190404831 | 1 | 0.1% |
20190404910 | 1 | 0.1% |
20190404937 | 1 | 0.1% |
20190404960 | 1 | 0.1% |
20190404977 | 1 | 0.1% |
20190404978 | 1 | 0.1% |
Value | Count | Frequency (%) |
20200406854 | 1 | |
20200406801 | 1 | |
20200406728 | 1 | |
20200406718 | 1 | |
20200406698 | 1 | |
20200406660 | 1 | |
20200406658 | 1 | |
20200406632 | 1 | |
20200406627 | 1 | |
20200406626 | 1 |
DPOSIT_ACPT_DY
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 331 |
---|---|
Distinct (%) | 33.7% |
Missing | 19 |
Missing (%) | 1.9% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20195245 |
Minimum | 20010924 |
---|---|
Maximum | 20201209 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20010924 |
---|---|
5-th percentile | 20190604 |
Q1 | 20191018 |
median | 20191230 |
Q3 | 20200407 |
95-th percentile | 20200728 |
Maximum | 20201209 |
Range | 190285 |
Interquartile range (IQR) | 9389 |
Descriptive statistics
Standard deviation | 9291.8997 |
---|---|
Coefficient of variation (CV) | 0.00046010334 |
Kurtosis | 257.71853 |
Mean | 20195245 |
Median Absolute Deviation (MAD) | 8876 |
Skewness | -13.676887 |
Sum | 1.9811535 × 1010 |
Variance | 86339400 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20191204 | 15 | 1.5% |
20191129 | 11 | 1.1% |
20191118 | 10 | 1.0% |
20200220 | 10 | 1.0% |
20191203 | 10 | 1.0% |
20200205 | 10 | 1.0% |
20200528 | 9 | 0.9% |
20200130 | 9 | 0.9% |
20191127 | 9 | 0.9% |
20200107 | 9 | 0.9% |
Other values (321) | 879 | |
(Missing) | 19 | 1.9% |
Value | Count | Frequency (%) |
20010924 | 1 | 0.1% |
20030422 | 1 | 0.1% |
20180406 | 1 | 0.1% |
20180817 | 3 | |
20181102 | 1 | 0.1% |
20181217 | 2 | |
20190102 | 1 | 0.1% |
20190108 | 1 | 0.1% |
20190114 | 1 | 0.1% |
20190115 | 1 | 0.1% |
Value | Count | Frequency (%) |
20201209 | 1 | |
20201012 | 1 | |
20201005 | 1 | |
20200928 | 1 | |
20200925 | 1 | |
20200921 | 1 | |
20200914 | 1 | |
20200909 | 2 | |
20200908 | 1 | |
20200907 | 2 |
RECKON_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 248 |
---|---|
Distinct (%) | 24.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20199159 |
Minimum | 20180518 |
---|---|
Maximum | 20201030 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180518 |
---|---|
5-th percentile | 20191112 |
Q1 | 20200224 |
median | 20200423 |
Q3 | 20200805 |
95-th percentile | 20201008 |
Maximum | 20201030 |
Range | 20512 |
Interquartile range (IQR) | 581 |
Descriptive statistics
Standard deviation | 3490.7712 |
---|---|
Coefficient of variation (CV) | 0.00017281765 |
Kurtosis | 4.0019008 |
Mean | 20199159 |
Median Absolute Deviation (MAD) | 290 |
Skewness | -2.2295125 |
Sum | 2.0199159 × 1010 |
Variance | 12185484 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20191119 | 12 | 1.2% |
20200318 | 11 | 1.1% |
20200326 | 11 | 1.1% |
20200924 | 11 | 1.1% |
20200421 | 11 | 1.1% |
20200429 | 10 | 1.0% |
20200928 | 10 | 1.0% |
20200312 | 9 | 0.9% |
20200407 | 9 | 0.9% |
20200416 | 9 | 0.9% |
Other values (238) | 897 |
Value | Count | Frequency (%) |
20180518 | 1 | 0.1% |
20181030 | 3 | |
20190910 | 1 | 0.1% |
20191015 | 1 | 0.1% |
20191016 | 3 | |
20191017 | 1 | 0.1% |
20191018 | 5 | |
20191021 | 2 | 0.2% |
20191022 | 2 | 0.2% |
20191023 | 2 | 0.2% |
Value | Count | Frequency (%) |
20201030 | 1 | 0.1% |
20201028 | 3 | |
20201027 | 1 | 0.1% |
20201026 | 1 | 0.1% |
20201023 | 5 | |
20201022 | 2 | 0.2% |
20201021 | 3 | |
20201020 | 6 | |
20201019 | 4 | |
20201016 | 7 |
DPOSIT_RSCD
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
2 | 2 |
6 | 2 |
3 | 1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 995 | |
2 | 2 | 0.2% |
6 | 2 | 0.2% |
3 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 995 | |
2 | 2 | 0.2% |
6 | 2 | 0.2% |
3 | 1 | 0.1% |
DPOSIT_THING_KIND_CD
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 |
DPOSIT_PAY_MTHD_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
2 | |
---|---|
1 | 6 |
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 | 994 | |
1 | 6 | 0.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 994 | |
1 | 6 | 0.6% |
DECIS_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 248 |
---|---|
Distinct (%) | 24.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20199160 |
Minimum | 20180518 |
---|---|
Maximum | 20201030 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180518 |
---|---|
5-th percentile | 20191112 |
Q1 | 20200224 |
median | 20200423 |
Q3 | 20200805 |
95-th percentile | 20201008 |
Maximum | 20201030 |
Range | 20512 |
Interquartile range (IQR) | 581 |
Descriptive statistics
Standard deviation | 3490.1026 |
---|---|
Coefficient of variation (CV) | 0.00017278454 |
Kurtosis | 4.0040894 |
Mean | 20199160 |
Median Absolute Deviation (MAD) | 290 |
Skewness | -2.2297196 |
Sum | 2.019916 × 1010 |
Variance | 12180816 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20191119 | 12 | 1.2% |
20200326 | 11 | 1.1% |
20200421 | 11 | 1.1% |
20200924 | 11 | 1.1% |
20200318 | 11 | 1.1% |
20200429 | 10 | 1.0% |
20200928 | 10 | 1.0% |
20200716 | 9 | 0.9% |
20200407 | 9 | 0.9% |
20200707 | 9 | 0.9% |
Other values (238) | 897 |
Value | Count | Frequency (%) |
20180518 | 1 | 0.1% |
20181030 | 3 | |
20191015 | 1 | 0.1% |
20191016 | 3 | |
20191017 | 1 | 0.1% |
20191018 | 5 | |
20191021 | 2 | 0.2% |
20191022 | 2 | 0.2% |
20191023 | 2 | 0.2% |
20191024 | 1 | 0.1% |
Value | Count | Frequency (%) |
20201030 | 1 | 0.1% |
20201028 | 3 | |
20201027 | 1 | 0.1% |
20201026 | 1 | 0.1% |
20201023 | 4 | |
20201022 | 2 | 0.2% |
20201021 | 3 | |
20201020 | 6 | |
20201019 | 6 | |
20201016 | 6 |
UPDT_TS
Date
MISSING
 
Distinct | 272 |
---|---|
Distinct (%) | 100.0% |
Missing | 728 |
Missing (%) | 72.8% |
Memory size | 7.9 KiB |
Minimum | 2019-11-04 10:40:26 |
---|---|
Maximum | 2020-10-29 15:57:20 |
UPDT_ENO
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 56 |
---|---|
Distinct (%) | 20.6% |
Missing | 728 |
Missing (%) | 72.8% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1739.3125 |
Minimum | 1209 |
---|---|
Maximum | 1987 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1209 |
---|---|
5-th percentile | 1515.75 |
Q1 | 1592 |
median | 1817 |
Q3 | 1864 |
95-th percentile | 1927 |
Maximum | 1987 |
Range | 778 |
Interquartile range (IQR) | 272 |
Descriptive statistics
Standard deviation | 150.65077 |
---|---|
Coefficient of variation (CV) | 0.086615126 |
Kurtosis | -0.78872238 |
Mean | 1739.3125 |
Median Absolute Deviation (MAD) | 111 |
Skewness | -0.41819671 |
Sum | 473093 |
Variance | 22695.655 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1842 | 43 | 4.3% |
1592 | 23 | 2.3% |
1872 | 13 | 1.3% |
1590 | 12 | 1.2% |
1696 | 12 | 1.2% |
1883 | 12 | 1.2% |
1823 | 12 | 1.2% |
1927 | 10 | 1.0% |
1518 | 9 | 0.9% |
1897 | 9 | 0.9% |
Other values (46) | 117 | 11.7% |
(Missing) | 728 |
Value | Count | Frequency (%) |
1209 | 1 | 0.1% |
1345 | 2 | 0.2% |
1476 | 2 | 0.2% |
1487 | 2 | 0.2% |
1513 | 7 | |
1518 | 9 | |
1520 | 5 | |
1521 | 2 | 0.2% |
1530 | 1 | 0.1% |
1544 | 4 |
Value | Count | Frequency (%) |
1987 | 4 | 0.4% |
1978 | 1 | 0.1% |
1965 | 1 | 0.1% |
1937 | 1 | 0.1% |
1934 | 2 | 0.2% |
1929 | 1 | 0.1% |
1927 | 10 | |
1926 | 4 | 0.4% |
1921 | 2 | 0.2% |
1908 | 2 | 0.2% |
UPDT_BRCD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 23 |
---|---|
Distinct (%) | 2.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
<NA> | |
---|---|
THA | 63 |
TAB | 27 |
TAC | 26 |
TAA | 24 |
Other values (18) |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 3.728 |
Min length | 3 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 728 | |
THA | 63 | 6.3% |
TAB | 27 | 2.7% |
TAC | 26 | 2.6% |
TAA | 24 | 2.4% |
THB | 23 | 2.3% |
THO | 19 | 1.9% |
QAD | 12 | 1.2% |
TPB | 11 | 1.1% |
TLB | 9 | 0.9% |
Other values (13) | 58 | 5.8% |
Length
Value | Count | Frequency (%) |
na | 728 | |
tha | 63 | 6.3% |
tab | 27 | 2.7% |
tac | 26 | 2.6% |
taa | 24 | 2.4% |
thb | 23 | 2.3% |
tho | 19 | 1.9% |
qad | 12 | 1.2% |
tpb | 11 | 1.1% |
tlb | 9 | 0.9% |
Other values (13) | 58 | 5.8% |
REG_TS
Date
Distinct | 956 |
---|---|
Distinct (%) | 95.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2018-05-18 13:31:55 |
---|---|
Maximum | 2020-10-30 10:54:08 |
REG_ENO
Real number (ℝ)
Distinct | 102 |
---|---|
Distinct (%) | 10.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4443.205 |
Minimum | 1157 |
---|---|
Maximum | 53620 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1157 |
---|---|
5-th percentile | 1345 |
Q1 | 1595 |
median | 1696 |
Q3 | 1872 |
95-th percentile | 53321 |
Maximum | 53620 |
Range | 52463 |
Interquartile range (IQR) | 277 |
Descriptive statistics
Standard deviation | 11572.744 |
---|---|
Coefficient of variation (CV) | 2.6045938 |
Kurtosis | 13.992757 |
Mean | 4443.205 |
Median Absolute Deviation (MAD) | 146 |
Skewness | 3.9950653 |
Sum | 4443205 |
Variance | 1.3392841 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1690 | 72 | 7.2% |
1842 | 64 | 6.4% |
1696 | 61 | 6.1% |
1592 | 48 | 4.8% |
53321 | 42 | 4.2% |
1883 | 40 | 4.0% |
1823 | 40 | 4.0% |
1590 | 27 | 2.7% |
1345 | 26 | 2.6% |
1487 | 26 | 2.6% |
Other values (92) | 554 |
Value | Count | Frequency (%) |
1157 | 3 | 0.3% |
1262 | 5 | 0.5% |
1339 | 21 | |
1345 | 26 | |
1348 | 10 | 1.0% |
1406 | 6 | 0.6% |
1455 | 6 | 0.6% |
1460 | 7 | 0.7% |
1476 | 12 | |
1477 | 1 | 0.1% |
Value | Count | Frequency (%) |
53620 | 1 | 0.1% |
53350 | 10 | 1.0% |
53321 | 42 | |
2002 | 1 | 0.1% |
2000 | 2 | 0.2% |
1987 | 4 | 0.4% |
1980 | 5 | 0.5% |
1978 | 7 | 0.7% |
1973 | 5 | 0.5% |
1958 | 4 | 0.4% |
REG_BR_CD
Categorical
HIGH CORRELATION
 
Distinct | 25 |
---|---|
Distinct (%) | 2.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
TAA | |
---|---|
THA | |
QAD | |
TAD | |
THB | |
Other values (20) |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | TAB |
---|---|
2nd row | THB |
3rd row | THB |
4th row | TAB |
5th row | TLB |
Common Values
Value | Count | Frequency (%) |
TAA | 147 | |
THA | 109 | |
QAD | 80 | 8.0% |
TAD | 78 | 7.8% |
THB | 69 | 6.9% |
TAC | 65 | 6.5% |
TAB | 64 | 6.4% |
THO | 60 | 6.0% |
TLB | 50 | 5.0% |
TPA | 44 | 4.4% |
Other values (15) | 234 |
Length
Value | Count | Frequency (%) |
taa | 147 | |
tha | 109 | |
qad | 80 | 8.0% |
tad | 78 | 7.8% |
thb | 69 | 6.9% |
tac | 65 | 6.5% |
tab | 64 | 6.4% |
tho | 60 | 6.0% |
tlb | 50 | 5.0% |
tpa | 44 | 4.4% |
Other values (15) | 234 |
MDBTR_CUST_NO | DPOSIT_ADV_DY | DPOSIT_SEQ | REL_PTNO | EXEC_PTTN_SEQ | TRNSFER_DEMND_ACPT_PTNO | DPOSIT_ACPT_DY | RECKON_DY | DPOSIT_RSCD | DPOSIT_PAY_MTHD_CD | DECIS_DY | UPDT_ENO | UPDT_BRCD | REG_ENO | REG_BR_CD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MDBTR_CUST_NO | 1.000 | 0.089 | 0.000 | 0.198 | 0.000 | 0.118 | 0.000 | 0.089 | 0.000 | 0.111 | 0.089 | 0.387 | 0.412 | 0.082 | 0.213 |
DPOSIT_ADV_DY | 0.089 | 1.000 | 0.325 | 0.825 | 0.052 | 0.793 | 0.825 | 1.000 | 0.000 | 0.113 | 1.000 | 0.371 | 0.411 | 0.052 | 0.328 |
DPOSIT_SEQ | 0.000 | 0.325 | 1.000 | 0.510 | 0.280 | 0.709 | 0.255 | 0.325 | 0.000 | 0.000 | 0.325 | 0.295 | 0.000 | 0.000 | 0.000 |
REL_PTNO | 0.198 | 0.825 | 0.510 | 1.000 | 0.627 | 0.953 | 0.436 | 0.825 | 0.000 | 0.254 | 0.825 | 0.408 | 0.424 | 0.137 | 0.237 |
EXEC_PTTN_SEQ | 0.000 | 0.052 | 0.280 | 0.627 | 1.000 | 0.000 | 0.048 | 0.052 | 0.683 | 0.478 | 0.052 | 0.128 | 0.210 | 0.000 | 0.179 |
TRNSFER_DEMND_ACPT_PTNO | 0.118 | 0.793 | 0.709 | 0.953 | 0.000 | 1.000 | 0.499 | 0.793 | 0.000 | NaN | 0.793 | 0.172 | 0.000 | 0.448 | 0.183 |
DPOSIT_ACPT_DY | 0.000 | 0.825 | 0.255 | 0.436 | 0.048 | 0.499 | 1.000 | 0.825 | 0.000 | 0.000 | 0.825 | 0.000 | 0.546 | 0.000 | 0.182 |
RECKON_DY | 0.089 | 1.000 | 0.325 | 0.825 | 0.052 | 0.793 | 0.825 | 1.000 | 0.000 | 0.113 | 1.000 | 0.371 | 0.411 | 0.052 | 0.328 |
DPOSIT_RSCD | 0.000 | 0.000 | 0.000 | 0.000 | 0.683 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
DPOSIT_PAY_MTHD_CD | 0.111 | 0.113 | 0.000 | 0.254 | 0.478 | NaN | 0.000 | 0.113 | 0.000 | 1.000 | 0.113 | 0.143 | 0.333 | 0.000 | 0.175 |
DECIS_DY | 0.089 | 1.000 | 0.325 | 0.825 | 0.052 | 0.793 | 0.825 | 1.000 | 0.000 | 0.113 | 1.000 | 0.371 | 0.411 | 0.052 | 0.328 |
UPDT_ENO | 0.387 | 0.371 | 0.295 | 0.408 | 0.128 | 0.172 | 0.000 | 0.371 | 0.000 | 0.143 | 0.371 | 1.000 | 0.864 | 0.244 | 0.864 |
UPDT_BRCD | 0.412 | 0.411 | 0.000 | 0.424 | 0.210 | 0.000 | 0.546 | 0.411 | 0.000 | 0.333 | 0.411 | 0.864 | 1.000 | 0.498 | 1.000 |
REG_ENO | 0.082 | 0.052 | 0.000 | 0.137 | 0.000 | 0.448 | 0.000 | 0.052 | 0.000 | 0.000 | 0.052 | 0.244 | 0.498 | 1.000 | 0.513 |
REG_BR_CD | 0.213 | 0.328 | 0.000 | 0.237 | 0.179 | 0.183 | 0.182 | 0.328 | 0.000 | 0.175 | 0.328 | 0.864 | 1.000 | 0.513 | 1.000 |
DPOSIT_RSCD | REG_BR_CD | DPOSIT_SEQ | EXEC_PTTN_SEQ | UPDT_BRCD | DPOSIT_PAY_MTHD_CD | |
---|---|---|---|---|---|---|
DPOSIT_RSCD | 1.000 | 0.000 | 0.000 | 0.329 | 0.000 | 0.000 |
REG_BR_CD | 0.000 | 1.000 | 0.000 | 0.094 | 1.000 | 0.150 |
DPOSIT_SEQ | 0.000 | 0.000 | 1.000 | 0.113 | 0.000 | 0.000 |
EXEC_PTTN_SEQ | 0.329 | 0.094 | 0.113 | 1.000 | 0.105 | 0.323 |
UPDT_BRCD | 0.000 | 1.000 | 0.000 | 0.105 | 1.000 | 0.253 |
DPOSIT_PAY_MTHD_CD | 0.000 | 0.150 | 0.000 | 0.323 | 0.253 | 1.000 |
MDBTR_CUST_NO | DPOSIT_ADV_DY | REL_PTNO | TRNSFER_DEMND_ACPT_PTNO | DPOSIT_ACPT_DY | RECKON_DY | DECIS_DY | UPDT_ENO | REG_ENO | DPOSIT_SEQ | EXEC_PTTN_SEQ | DPOSIT_RSCD | DPOSIT_PAY_MTHD_CD | UPDT_BRCD | REG_BR_CD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MDBTR_CUST_NO | 1.000 | 0.041 | 0.057 | 0.043 | 0.103 | 0.041 | 0.041 | 0.175 | 0.060 | 0.000 | 0.143 | 0.000 | 0.085 | 0.161 | 0.076 |
DPOSIT_ADV_DY | 0.041 | 1.000 | 0.982 | 0.938 | 0.739 | 0.999 | 1.000 | -0.004 | -0.002 | 0.317 | 0.049 | 0.000 | 0.187 | 0.173 | 0.194 |
REL_PTNO | 0.057 | 0.982 | 1.000 | 0.931 | 0.746 | 0.981 | 0.982 | 0.002 | 0.011 | 0.228 | 0.258 | 0.000 | 0.169 | 0.182 | 0.141 |
TRNSFER_DEMND_ACPT_PTNO | 0.043 | 0.938 | 0.931 | 1.000 | 0.786 | 0.938 | 0.938 | -0.016 | -0.061 | 0.337 | 0.000 | 0.000 | 1.000 | 0.000 | 0.117 |
DPOSIT_ACPT_DY | 0.103 | 0.739 | 0.746 | 0.786 | 1.000 | 0.740 | 0.739 | -0.093 | -0.037 | 0.197 | 0.018 | 0.000 | 0.000 | 0.328 | 0.175 |
RECKON_DY | 0.041 | 0.999 | 0.981 | 0.938 | 0.740 | 1.000 | 0.999 | -0.004 | -0.002 | 0.317 | 0.049 | 0.000 | 0.187 | 0.173 | 0.194 |
DECIS_DY | 0.041 | 1.000 | 0.982 | 0.938 | 0.739 | 0.999 | 1.000 | -0.004 | -0.002 | 0.317 | 0.049 | 0.000 | 0.187 | 0.173 | 0.194 |
UPDT_ENO | 0.175 | -0.004 | 0.002 | -0.016 | -0.093 | -0.004 | -0.004 | 1.000 | 0.263 | 0.120 | 0.052 | 0.000 | 0.087 | 0.533 | 0.533 |
REG_ENO | 0.060 | -0.002 | 0.011 | -0.061 | -0.037 | -0.002 | -0.002 | 0.263 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.382 | 0.441 |
DPOSIT_SEQ | 0.000 | 0.317 | 0.228 | 0.337 | 0.197 | 0.317 | 0.317 | 0.120 | 0.000 | 1.000 | 0.113 | 0.000 | 0.000 | 0.000 | 0.000 |
EXEC_PTTN_SEQ | 0.143 | 0.049 | 0.258 | 0.000 | 0.018 | 0.049 | 0.049 | 0.052 | 0.000 | 0.113 | 1.000 | 0.329 | 0.323 | 0.105 | 0.094 |
DPOSIT_RSCD | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.329 | 1.000 | 0.000 | 0.000 | 0.000 |
DPOSIT_PAY_MTHD_CD | 0.085 | 0.187 | 0.169 | 1.000 | 0.000 | 0.187 | 0.187 | 0.087 | 0.000 | 0.000 | 0.323 | 0.000 | 1.000 | 0.253 | 0.150 |
UPDT_BRCD | 0.161 | 0.173 | 0.182 | 0.000 | 0.328 | 0.173 | 0.173 | 0.533 | 0.382 | 0.000 | 0.105 | 0.000 | 0.253 | 1.000 | 1.000 |
REG_BR_CD | 0.076 | 0.194 | 0.141 | 0.117 | 0.175 | 0.194 | 0.194 | 0.533 | 0.441 | 0.000 | 0.094 | 0.000 | 0.150 | 1.000 | 1.000 |
MDBTR_CUST_NO | DPOSIT_ADV_DY | DPOSIT_SEQ | REL_PTNO | EXEC_PTTN_SEQ | TRNSFER_DEMND_ACPT_PTNO | DPOSIT_ACPT_DY | RECKON_DY | DPOSIT_RSCD | DPOSIT_THING_KIND_CD | DPOSIT_PAY_MTHD_CD | DECIS_DY | UPDT_TS | UPDT_ENO | UPDT_BRCD | REG_TS | REG_ENO | REG_BR_CD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 73382673 | 20201030 | 1 | 20200105507 | 1 | 20200406854 | 20200928 | 20201030 | 1 | 1 | 2 | 20201030 | <NA> | <NA> | <NA> | 2020/10/30 10:54:08 | 1696 | TAB |
1 | 93950386 | 20201028 | 1 | 20200105454 | 1 | 20200406718 | 20200624 | 20201028 | 1 | 1 | 2 | 20201028 | <NA> | <NA> | <NA> | 2020/10/28 15:05:56 | 1592 | THB |
2 | 123549816 | 20201028 | 1 | 20200105520 | 1 | 20200406801 | 20200902 | 20201028 | 1 | 1 | 2 | 20201028 | <NA> | <NA> | <NA> | 2020/10/28 14:59:01 | 1592 | THB |
3 | 50919426 | 20201028 | 1 | 20200105474 | 1 | 20200406627 | 20200609 | 20201028 | 1 | 1 | 2 | 20201028 | <NA> | <NA> | <NA> | 2020/10/28 13:30:50 | 1696 | TAB |
4 | 121119031 | 20201027 | 1 | 20200105430 | 1 | 20200406179 | 20200706 | 20201027 | 1 | 1 | 2 | 20201027 | <NA> | <NA> | <NA> | 2020/10/27 14:23:50 | 1476 | TLB |
5 | 124058610 | 20201026 | 1 | 20200105473 | 1 | 20200406728 | 20200702 | 20201026 | 1 | 1 | 2 | 20201026 | <NA> | <NA> | <NA> | 2020/10/26 14:01:05 | 1590 | TAC |
6 | 87102072 | 20201023 | 1 | 20200105443 | 1 | 20200406698 | 20200706 | 20201023 | 1 | 1 | 2 | 20201023 | <NA> | <NA> | <NA> | 2020/10/23 15:23:56 | 1606 | TMA |
7 | 128336338 | 20201023 | 3 | 20200105387 | 1 | 20200406550 | 20200803 | 20201023 | 1 | 1 | 2 | 20201023 | <NA> | <NA> | <NA> | 2020/10/23 13:29:35 | 1926 | TLB |
8 | 128336338 | 20201023 | 2 | 20200105386 | 1 | 20200406550 | 20200803 | 20201023 | 1 | 1 | 2 | 20201023 | <NA> | <NA> | <NA> | 2020/10/23 13:29:35 | 1926 | TLB |
9 | 128336338 | 20201023 | 1 | 20200105383 | 1 | 20200406550 | 20200803 | 20201023 | 1 | 1 | 2 | 20201023 | <NA> | <NA> | <NA> | 2020/10/23 13:29:35 | 1926 | TLB |
MDBTR_CUST_NO | DPOSIT_ADV_DY | DPOSIT_SEQ | REL_PTNO | EXEC_PTTN_SEQ | TRNSFER_DEMND_ACPT_PTNO | DPOSIT_ACPT_DY | RECKON_DY | DPOSIT_RSCD | DPOSIT_THING_KIND_CD | DPOSIT_PAY_MTHD_CD | DECIS_DY | UPDT_TS | UPDT_ENO | UPDT_BRCD | REG_TS | REG_ENO | REG_BR_CD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | 102651589 | 20191018 | 1 | 20190107120 | 1 | 20190405864 | 20190108 | 20191018 | 1 | 1 | 2 | 20191018 | 2020/06/25 16:38:36 | 1592 | THB | 2019/10/18 11:36:32 | 1592 | THB |
991 | 115814096 | 20191018 | 1 | 20190107165 | 1 | 20190405902 | 20190726 | 20191018 | 1 | 1 | 2 | 20191018 | <NA> | <NA> | <NA> | 2019/10/18 10:58:55 | 1867 | TPA |
992 | 49502585 | 20191018 | 2 | 20190107143 | 1 | 20190405568 | 20190905 | 20191018 | 1 | 1 | 2 | 20191018 | 2020/01/21 16:09:26 | 1345 | THA | 2019/10/18 10:48:13 | 1345 | THA |
993 | 49502585 | 20191018 | 1 | 20190107148 | 1 | 20190405568 | 20190905 | 20191018 | 1 | 1 | 2 | 20191018 | 2020/01/21 16:10:41 | 1345 | THA | 2019/10/18 10:48:12 | 1345 | THA |
994 | 99128604 | 20191018 | 1 | 20190107153 | 1 | 20190405570 | 20190822 | 20191018 | 1 | 1 | 2 | 20191018 | 2020/08/04 16:37:43 | 1927 | THA | 2019/10/18 10:05:47 | 1345 | THA |
995 | 118887224 | 20191017 | 1 | 20190107111 | 1 | 20190405866 | <NA> | 20191017 | 1 | 1 | 2 | 20191017 | <NA> | <NA> | <NA> | 2019/10/17 15:20:21 | 1595 | QAD |
996 | 81695268 | 20191016 | 1 | 20190106967 | 1 | 20190405867 | <NA> | 20191016 | 1 | 1 | 2 | 20191016 | 2020/04/24 10:22:52 | 1863 | QAD | 2019/10/16 12:18:50 | 1595 | QAD |
997 | 108706344 | 20191016 | 1 | 20190107035 | 1 | 20190405694 | 20190730 | 20191016 | 1 | 1 | 2 | 20191016 | 2020/05/12 16:18:01 | 1635 | TOB | 2019/10/16 11:23:11 | 1635 | TOB |
998 | 69059237 | 20191016 | 1 | 20190107072 | 1 | 20190405728 | 20190529 | 20191016 | 1 | 1 | 2 | 20191016 | 2019/12/24 17:09:01 | 1593 | TAC | 2019/10/16 10:57:24 | 1696 | TAC |
999 | 92442688 | 20191015 | 1 | 20190106759 | 1 | 20190405506 | 20190723 | 20191015 | 1 | 1 | 2 | 20191015 | <NA> | <NA> | <NA> | 2019/10/15 14:03:09 | 1690 | TAD |