Dataset statistics
Number of variables | 18 |
---|---|
Number of observations | 1000 |
Missing cells | 22 |
Missing cells (%) | 0.1% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 153.4 KiB |
Average record size in memory | 157.1 B |
Variable types
Numeric | 9 |
---|---|
Categorical | 6 |
DateTime | 2 |
Text | 1 |
Dataset
Description | 한국주택금융공사 주택연금부에서 제공하는 주연보이수관보증료정보에 대한 데이터로, 이수관관리번호,고객번호,이수관구분코드 등의 항목을 제공합니다. |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15073008/fileData.do |
COMPLT_DVCD has constant value "" | Constant |
MABR_CD is highly overall correlated with UPDT_DY and 4 other fields | High correlation |
ACCT_DVCD is highly overall correlated with CUST_NO and 12 other fields | High correlation |
CDRI_MCLASS_CD is highly overall correlated with CDRI_LCLASS_CD and 1 other fields | High correlation |
PRESENT_CTRL_BRCD is highly overall correlated with UPDT_DY and 4 other fields | High correlation |
CDRI_LCLASS_CD is highly overall correlated with CDRI_MCLASS_CD and 1 other fields | High correlation |
CUST_NO is highly overall correlated with TRNSFER_SLIP_NO and 2 other fields | High correlation |
UPDT_DY is highly overall correlated with ACCT_DY and 3 other fields | High correlation |
OCCR_AMT is highly overall correlated with ACCT_DVCD | High correlation |
PLOAN_ITEM_CD is highly overall correlated with GCTPT_PLC_CD and 1 other fields | High correlation |
GCTPT_PLC_CD is highly overall correlated with PLOAN_ITEM_CD and 1 other fields | High correlation |
ACCT_DY is highly overall correlated with UPDT_DY and 3 other fields | High correlation |
TRNSFER_SLIP_NO is highly overall correlated with CUST_NO and 2 other fields | High correlation |
RCV_SLIP_NO is highly overall correlated with CUST_NO and 2 other fields | High correlation |
REG_ENO is highly overall correlated with PRESENT_CTRL_BRCD and 2 other fields | High correlation |
CDRI_LCLASS_CD is highly imbalanced (92.9%) | Imbalance |
CDRI_MCLASS_CD is highly imbalanced (89.4%) | Imbalance |
ACCT_DVCD is highly imbalanced (94.7%) | Imbalance |
Reproduction
Analysis started | 2023-12-12 07:14:17.435737 |
---|---|
Analysis finished | 2023-12-12 07:14:29.000801 |
Duration | 11.57 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
CUST_NO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 989 |
---|---|
Distinct (%) | 98.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.0754569 × 108 |
Minimum | 7986907 |
---|---|
Maximum | 1.3863365 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 7986907 |
---|---|
5-th percentile | 73867943 |
Q1 | 97828854 |
median | 1.1393457 × 108 |
Q3 | 1.217548 × 108 |
95-th percentile | 1.2773611 × 108 |
Maximum | 1.3863365 × 108 |
Range | 1.3064674 × 108 |
Interquartile range (IQR) | 23925943 |
Descriptive statistics
Standard deviation | 21089988 |
---|---|
Coefficient of variation (CV) | 0.1961026 |
Kurtosis | 6.1429128 |
Mean | 1.0754569 × 108 |
Median Absolute Deviation (MAD) | 9401585.5 |
Skewness | -2.0948531 |
Sum | 1.0754569 × 1011 |
Variance | 4.447876 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
88243383 | 5 | 0.5% |
103994533 | 2 | 0.2% |
112730652 | 2 | 0.2% |
84607965 | 2 | 0.2% |
114317468 | 2 | 0.2% |
75712186 | 2 | 0.2% |
82730339 | 2 | 0.2% |
70863328 | 2 | 0.2% |
120338402 | 1 | 0.1% |
118900949 | 1 | 0.1% |
Other values (979) | 979 |
Value | Count | Frequency (%) |
7986907 | 1 | |
8587583 | 1 | |
8736554 | 1 | |
8796109 | 1 | |
8843010 | 1 | |
9819771 | 1 | |
9826913 | 1 | |
10700772 | 1 | |
10772742 | 1 | |
10824027 | 1 |
Value | Count | Frequency (%) |
138633652 | 1 | |
137726489 | 1 | |
137588847 | 1 | |
137577939 | 1 | |
137527109 | 1 | |
137505312 | 1 | |
137409874 | 1 | |
137368711 | 1 | |
137360557 | 1 | |
137312505 | 1 |
COMPLT_DVCD
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 |
UPDT_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 56 |
---|---|
Distinct (%) | 5.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20191161 |
Minimum | 20180716 |
---|---|
Maximum | 20200813 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180716 |
---|---|
5-th percentile | 20180716 |
Q1 | 20190311 |
median | 20190318 |
Q3 | 20190627 |
95-th percentile | 20200413 |
Maximum | 20200813 |
Range | 20097 |
Interquartile range (IQR) | 316 |
Descriptive statistics
Standard deviation | 5789.663 |
---|---|
Coefficient of variation (CV) | 0.00028674245 |
Kurtosis | -0.15666913 |
Mean | 20191161 |
Median Absolute Deviation (MAD) | 309 |
Skewness | 0.045007798 |
Sum | 2.0191161 × 1010 |
Variance | 33520198 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190311 | 268 | |
20190318 | 196 | |
20200413 | 189 | |
20190627 | 129 | |
20180716 | 119 | |
20190326 | 16 | 1.6% |
20180821 | 10 | 1.0% |
20191227 | 5 | 0.5% |
20180822 | 5 | 0.5% |
20200416 | 5 | 0.5% |
Other values (46) | 58 | 5.8% |
Value | Count | Frequency (%) |
20180716 | 119 | |
20180718 | 1 | 0.1% |
20180810 | 1 | 0.1% |
20180821 | 10 | 1.0% |
20180822 | 5 | 0.5% |
20181024 | 1 | 0.1% |
20181204 | 1 | 0.1% |
20181217 | 1 | 0.1% |
20190103 | 4 | 0.4% |
20190121 | 1 | 0.1% |
Value | Count | Frequency (%) |
20200813 | 1 | 0.1% |
20200805 | 1 | 0.1% |
20200717 | 1 | 0.1% |
20200602 | 1 | 0.1% |
20200528 | 1 | 0.1% |
20200526 | 1 | 0.1% |
20200519 | 1 | 0.1% |
20200416 | 5 | 0.5% |
20200413 | 189 | |
20200410 | 1 | 0.1% |
CDRI_LCLASS_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
5 | 11 |
7 | 5 |
0 | 2 |
2 | 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 | 981 | |
5 | 11 | 1.1% |
7 | 5 | 0.5% |
0 | 2 | 0.2% |
2 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 981 | |
5 | 11 | 1.1% |
7 | 5 | 0.5% |
0 | 2 | 0.2% |
2 | 1 | 0.1% |
CDRI_MCLASS_CD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 | |
---|---|
1 | 14 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 986 | |
1 | 14 | 1.4% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 986 | |
1 | 14 | 1.4% |
OCCR_AMT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 645 |
---|---|
Distinct (%) | 64.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5.7182644 × 108 |
Minimum | 0 |
---|---|
Maximum | 3.883 × 109 |
Zeros | 2 |
Zeros (%) | 0.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 1.57 × 108 |
Q1 | 2.99 × 108 |
median | 4.625 × 108 |
Q3 | 7.25 × 108 |
95-th percentile | 1.3767 × 109 |
Maximum | 3.883 × 109 |
Range | 3.883 × 109 |
Interquartile range (IQR) | 4.26 × 108 |
Descriptive statistics
Standard deviation | 4.2259781 × 108 |
---|---|
Coefficient of variation (CV) | 0.7390316 |
Kurtosis | 10.144857 |
Mean | 5.7182644 × 108 |
Median Absolute Deviation (MAD) | 1.9 × 108 |
Skewness | 2.3356195 |
Sum | 5.7182644 × 1011 |
Variance | 1.7858891 × 1017 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
416000000 | 6 | 0.6% |
480000000 | 6 | 0.6% |
265000000 | 6 | 0.6% |
228000000 | 6 | 0.6% |
249000000 | 6 | 0.6% |
549000000 | 5 | 0.5% |
463000000 | 5 | 0.5% |
410000000 | 5 | 0.5% |
333000000 | 5 | 0.5% |
344000000 | 5 | 0.5% |
Other values (635) | 945 |
Value | Count | Frequency (%) |
0 | 2 | |
396 | 1 | |
486 | 1 | |
820 | 1 | |
893 | 1 | |
939 | 1 | |
1652 | 1 | |
1871 | 1 | |
2761 | 1 | |
3227 | 1 |
Value | Count | Frequency (%) |
3883000000 | 1 | |
3785000000 | 1 | |
3479000000 | 1 | |
2334000000 | 1 | |
2287000000 | 1 | |
2132000000 | 1 | |
2084000000 | 1 | |
2078000000 | 1 | |
2022000000 | 1 | |
1993000000 | 1 |
PLOAN_ITEM_CD
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 10 |
---|---|
Distinct (%) | 1.0% |
Missing | 8 |
Missing (%) | 0.8% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 17.606855 |
Minimum | 3 |
---|---|
Maximum | 88 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 3 |
---|---|
5-th percentile | 4 |
Q1 | 11 |
median | 11 |
Q3 | 11 |
95-th percentile | 81 |
Maximum | 88 |
Range | 85 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 21.54386 |
---|---|
Coefficient of variation (CV) | 1.2236064 |
Kurtosis | 5.0973906 |
Mean | 17.606855 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 2.5024173 |
Sum | 17466 |
Variance | 464.13791 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
11 | 576 | |
4 | 204 | 20.4% |
88 | 47 | 4.7% |
32 | 41 | 4.1% |
81 | 34 | 3.4% |
20 | 30 | 3.0% |
39 | 29 | 2.9% |
3 | 18 | 1.8% |
31 | 9 | 0.9% |
12 | 4 | 0.4% |
(Missing) | 8 | 0.8% |
Value | Count | Frequency (%) |
3 | 18 | 1.8% |
4 | 204 | 20.4% |
11 | 576 | |
12 | 4 | 0.4% |
20 | 30 | 3.0% |
31 | 9 | 0.9% |
32 | 41 | 4.1% |
39 | 29 | 2.9% |
81 | 34 | 3.4% |
88 | 47 | 4.7% |
Value | Count | Frequency (%) |
88 | 47 | 4.7% |
81 | 34 | 3.4% |
39 | 29 | 2.9% |
32 | 41 | 4.1% |
31 | 9 | 0.9% |
20 | 30 | 3.0% |
12 | 4 | 0.4% |
11 | 576 | |
4 | 204 | 20.4% |
3 | 18 | 1.8% |
GCTPT_PLC_CD
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 268 |
---|---|
Distinct (%) | 27.0% |
Missing | 8 |
Missing (%) | 0.8% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 168175.08 |
Minimum | 31192 |
---|---|
Maximum | 887171 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 31192 |
---|---|
5-th percentile | 44558 |
Q1 | 103606 |
median | 117333 |
Q3 | 118950 |
95-th percentile | 808878.8 |
Maximum | 887171 |
Range | 855979 |
Interquartile range (IQR) | 15344 |
Descriptive statistics
Standard deviation | 175511.99 |
---|---|
Coefficient of variation (CV) | 1.0436266 |
Kurtosis | 8.2164536 |
Mean | 168175.08 |
Median Absolute Deviation (MAD) | 5254 |
Skewness | 2.9318239 |
Sum | 1.6682968 × 108 |
Variance | 3.080446 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
112558 | 50 | 5.0% |
117333 | 35 | 3.5% |
117896 | 26 | 2.6% |
118031 | 26 | 2.6% |
118057 | 25 | 2.5% |
117346 | 24 | 2.4% |
117799 | 22 | 2.2% |
114213 | 21 | 2.1% |
46527 | 20 | 2.0% |
69698 | 20 | 2.0% |
Other values (258) | 723 |
Value | Count | Frequency (%) |
31192 | 1 | 0.1% |
31273 | 3 | |
31600 | 2 | |
31956 | 2 | |
32353 | 1 | 0.1% |
32861 | 3 | |
32887 | 1 | 0.1% |
33721 | 2 | |
33747 | 1 | 0.1% |
33967 | 1 | 0.1% |
Value | Count | Frequency (%) |
887171 | 1 | 0.1% |
885089 | 1 | 0.1% |
884158 | 1 | 0.1% |
884019 | 1 | 0.1% |
881384 | 1 | 0.1% |
844855 | 6 | |
844745 | 2 | 0.2% |
844266 | 1 | 0.1% |
844101 | 1 | 0.1% |
843856 | 1 | 0.1% |
PRESENT_CTRL_BRCD
Categorical
HIGH CORRELATION
 
Distinct | 20 |
---|---|
Distinct (%) | 2.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
TQB | |
---|---|
TJB | |
TQC | |
TMB | |
TBB | |
Other values (15) |
Length
Max length | 4 |
---|---|
Median length | 3 |
Mean length | 3.006 |
Min length | 3 |
Unique
Unique | 5 ? |
---|---|
Unique (%) | 0.5% |
Sample
1st row | TQC |
---|---|
2nd row | TQC |
3rd row | TQC |
4th row | TQC |
5th row | TQC |
Common Values
Value | Count | Frequency (%) |
TQB | 269 | |
TJB | 213 | |
TQC | 194 | |
TMB | 139 | |
TBB | 137 | |
THA | 9 | 0.9% |
QAD | 7 | 0.7% |
<NA> | 6 | 0.6% |
TJA | 5 | 0.5% |
TAA | 4 | 0.4% |
Other values (10) | 17 | 1.7% |
Length
Value | Count | Frequency (%) |
tqb | 269 | |
tjb | 213 | |
tqc | 194 | |
tmb | 139 | |
tbb | 137 | |
tha | 9 | 0.9% |
qad | 7 | 0.7% |
na | 6 | 0.6% |
tja | 5 | 0.5% |
taa | 4 | 0.4% |
Other values (10) | 17 | 1.7% |
TRNSFER_TS
Date
Distinct | 544 |
---|---|
Distinct (%) | 54.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2018-07-13 18:58:17 |
---|---|
Maximum | 2020-08-13 13:12:15 |
RCV_TS
Text
Distinct | 534 |
---|---|
Distinct (%) | 53.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Length
Max length | 19 |
---|---|
Median length | 19 |
Mean length | 19 |
Min length | 19 |
Characters and Unicode
Total characters | 19000 |
---|---|
Distinct characters | 13 |
Distinct categories | 3 ? |
Distinct scripts | 1 ? |
Distinct blocks | 1 ? |
Unique
Unique | 242 ? |
---|---|
Unique (%) | 24.2% |
Sample
1st row | 2020/04/13 15:56:15 |
---|---|
2nd row | 2020/04/13 15:54:46 |
3rd row | 2020/04/13 15:56:31 |
4th row | 2020/04/13 15:54:46 |
5th row | 2020/04/13 15:56:33 |
Value | Count | Frequency (%) |
2019/03/11 | 267 | 13.4% |
2019/03/18 | 196 | 9.8% |
2020/04/13 | 189 | 9.4% |
2019/06/27 | 129 | 6.5% |
2018/07/16 | 119 | 5.9% |
2019/03/26 | 16 | 0.8% |
2018/08/21 | 10 | 0.5% |
0001/01/01 | 6 | 0.3% |
01:01:01 | 6 | 0.3% |
2018/08/22 | 5 | 0.2% |
Other values (576) | 1057 |
Most occurring characters
Value | Count | Frequency (%) |
1 | 3394 | |
0 | 2938 | |
2 | 2111 | |
/ | 2000 | |
: | 2000 | |
5 | 1275 | 6.7% |
3 | 1224 | 6.4% |
1000 | 5.3% | |
9 | 878 | 4.6% |
8 | 726 | 3.8% |
Other values (3) | 1454 |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 14000 | |
Other Punctuation | 4000 | 21.1% |
Space Separator | 1000 | 5.3% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
1 | 3394 | |
0 | 2938 | |
2 | 2111 | |
5 | 1275 | 9.1% |
3 | 1224 | 8.7% |
9 | 878 | 6.3% |
8 | 726 | 5.2% |
4 | 525 | 3.8% |
6 | 513 | 3.7% |
7 | 416 | 3.0% |
Other Punctuation
Value | Count | Frequency (%) |
/ | 2000 | |
: | 2000 |
Space Separator
Value | Count | Frequency (%) |
1000 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 19000 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
1 | 3394 | |
0 | 2938 | |
2 | 2111 | |
/ | 2000 | |
: | 2000 | |
5 | 1275 | 6.7% |
3 | 1224 | 6.4% |
1000 | 5.3% | |
9 | 878 | 4.6% |
8 | 726 | 3.8% |
Other values (3) | 1454 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 19000 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
1 | 3394 | |
0 | 2938 | |
2 | 2111 | |
/ | 2000 | |
: | 2000 | |
5 | 1275 | 6.7% |
3 | 1224 | 6.4% |
1000 | 5.3% | |
9 | 878 | 4.6% |
8 | 726 | 3.8% |
Other values (3) | 1454 |
ACCT_DVCD
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
7 | |
---|---|
<NA> | 6 |
Length
Max length | 4 |
---|---|
Median length | 1 |
Mean length | 1.018 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 7 |
---|---|
2nd row | 7 |
3rd row | 7 |
4th row | 7 |
5th row | 7 |
Common Values
Value | Count | Frequency (%) |
7 | 994 | |
<NA> | 6 | 0.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
7 | 994 | |
na | 6 | 0.6% |
MABR_CD
Categorical
HIGH CORRELATION
 
Distinct | 18 |
---|---|
Distinct (%) | 1.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
TQA | |
---|---|
TJA | |
TPA | |
TMA | |
TBA | |
Other values (13) |
Length
Max length | 4 |
---|---|
Median length | 3 |
Mean length | 3.006 |
Min length | 3 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | TPA |
---|---|
2nd row | TPA |
3rd row | TPA |
4th row | TPA |
5th row | TPA |
Common Values
Value | Count | Frequency (%) |
TQA | 327 | |
TJA | 213 | |
TPA | 195 | |
TMA | 143 | |
TBA | 80 | 8.0% |
THB | 7 | 0.7% |
<NA> | 6 | 0.6% |
TAB | 6 | 0.6% |
TJB | 5 | 0.5% |
TAC | 3 | 0.3% |
Other values (8) | 15 | 1.5% |
Length
Value | Count | Frequency (%) |
tqa | 327 | |
tja | 213 | |
tpa | 195 | |
tma | 143 | |
tba | 80 | 8.0% |
thb | 7 | 0.7% |
na | 6 | 0.6% |
tab | 6 | 0.6% |
tjb | 5 | 0.5% |
tac | 3 | 0.3% |
Other values (8) | 15 | 1.5% |
ACCT_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 53 |
---|---|
Distinct (%) | 5.3% |
Missing | 6 |
Missing (%) | 0.6% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20191153 |
Minimum | 20180716 |
---|---|
Maximum | 20200813 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20180716 |
---|---|
5-th percentile | 20180716 |
Q1 | 20190311 |
median | 20190318 |
Q3 | 20190627 |
95-th percentile | 20200413 |
Maximum | 20200813 |
Range | 20097 |
Interquartile range (IQR) | 316 |
Descriptive statistics
Standard deviation | 5799.6144 |
---|---|
Coefficient of variation (CV) | 0.00028723542 |
Kurtosis | -0.16535732 |
Mean | 20191153 |
Median Absolute Deviation (MAD) | 302 |
Skewness | 0.044909577 |
Sum | 2.0070006 × 1010 |
Variance | 33635527 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190311 | 267 | |
20190318 | 196 | |
20200413 | 189 | |
20190627 | 129 | |
20180716 | 119 | |
20190326 | 16 | 1.6% |
20180821 | 10 | 1.0% |
20200416 | 5 | 0.5% |
20180822 | 5 | 0.5% |
20191227 | 5 | 0.5% |
Other values (43) | 53 | 5.3% |
(Missing) | 6 | 0.6% |
Value | Count | Frequency (%) |
20180716 | 119 | |
20180718 | 1 | 0.1% |
20180810 | 1 | 0.1% |
20180821 | 10 | 1.0% |
20180822 | 5 | 0.5% |
20181024 | 1 | 0.1% |
20181204 | 1 | 0.1% |
20181217 | 1 | 0.1% |
20190103 | 4 | 0.4% |
20190121 | 1 | 0.1% |
Value | Count | Frequency (%) |
20200813 | 1 | 0.1% |
20200805 | 1 | 0.1% |
20200717 | 1 | 0.1% |
20200602 | 1 | 0.1% |
20200528 | 1 | 0.1% |
20200526 | 1 | 0.1% |
20200519 | 1 | 0.1% |
20200416 | 5 | 0.5% |
20200413 | 189 | |
20200330 | 1 | 0.1% |
TRNSFER_SLIP_NO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 365 |
---|---|
Distinct (%) | 36.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 183.176 |
Minimum | 0 |
---|---|
Maximum | 991 |
Zeros | 6 |
Zeros (%) | 0.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 34.95 |
Q1 | 101 |
median | 159 |
Q3 | 218 |
95-th percentile | 438.25 |
Maximum | 991 |
Range | 991 |
Interquartile range (IQR) | 117 |
Descriptive statistics
Standard deviation | 145.02564 |
---|---|
Coefficient of variation (CV) | 0.79172842 |
Kurtosis | 10.361923 |
Mean | 183.176 |
Median Absolute Deviation (MAD) | 58.5 |
Skewness | 2.8263187 |
Sum | 183176 |
Variance | 21032.437 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
100 | 10 | 1.0% |
156 | 7 | 0.7% |
180 | 7 | 0.7% |
159 | 6 | 0.6% |
0 | 6 | 0.6% |
188 | 6 | 0.6% |
178 | 6 | 0.6% |
115 | 5 | 0.5% |
176 | 5 | 0.5% |
183 | 5 | 0.5% |
Other values (355) | 937 |
Value | Count | Frequency (%) |
0 | 6 | |
3 | 1 | 0.1% |
4 | 1 | 0.1% |
5 | 1 | 0.1% |
6 | 1 | 0.1% |
7 | 1 | 0.1% |
17 | 1 | 0.1% |
18 | 1 | 0.1% |
19 | 1 | 0.1% |
20 | 2 | 0.2% |
Value | Count | Frequency (%) |
991 | 1 | |
961 | 1 | |
959 | 1 | |
954 | 1 | |
922 | 1 | |
917 | 1 | |
912 | 1 | |
906 | 1 | |
901 | 1 | |
862 | 1 |
RCV_SLIP_NO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 345 |
---|---|
Distinct (%) | 34.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 148.63 |
Minimum | 0 |
---|---|
Maximum | 1123 |
Zeros | 6 |
Zeros (%) | 0.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 8 |
Q1 | 47 |
median | 107 |
Q3 | 171 |
95-th percentile | 566.6 |
Maximum | 1123 |
Range | 1123 |
Interquartile range (IQR) | 124 |
Descriptive statistics
Standard deviation | 184.5071 |
---|---|
Coefficient of variation (CV) | 1.2413853 |
Kurtosis | 10.943707 |
Mean | 148.63 |
Median Absolute Deviation (MAD) | 62 |
Skewness | 3.1671267 |
Sum | 148630 |
Variance | 34042.87 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
5 | 11 | 1.1% |
14 | 7 | 0.7% |
28 | 6 | 0.6% |
44 | 6 | 0.6% |
110 | 6 | 0.6% |
15 | 6 | 0.6% |
17 | 6 | 0.6% |
114 | 6 | 0.6% |
19 | 6 | 0.6% |
13 | 6 | 0.6% |
Other values (335) | 934 |
Value | Count | Frequency (%) |
0 | 6 | |
1 | 4 | 0.4% |
2 | 5 | |
3 | 5 | |
4 | 4 | 0.4% |
5 | 11 | |
6 | 6 | |
7 | 5 | |
8 | 6 | |
9 | 4 | 0.4% |
Value | Count | Frequency (%) |
1123 | 1 | |
1110 | 1 | |
1109 | 1 | |
1084 | 1 | |
1082 | 1 | |
1077 | 1 | |
1045 | 1 | |
1040 | 1 | |
1035 | 1 | |
1029 | 1 |
REG_ENO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 39 |
---|---|
Distinct (%) | 3.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1639.012 |
Minimum | 1300 |
---|---|
Maximum | 2001 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1300 |
---|---|
5-th percentile | 1300 |
Q1 | 1426 |
median | 1679 |
Q3 | 1684 |
95-th percentile | 1921 |
Maximum | 2001 |
Range | 701 |
Interquartile range (IQR) | 258 |
Descriptive statistics
Standard deviation | 194.03373 |
---|---|
Coefficient of variation (CV) | 0.11838457 |
Kurtosis | -1.0321045 |
Mean | 1639.012 |
Median Absolute Deviation (MAD) | 234 |
Skewness | -0.022651239 |
Sum | 1639012 |
Variance | 37649.089 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1679 | 270 | |
1426 | 215 | |
1921 | 142 | |
1655 | 124 | |
1300 | 72 | 7.2% |
1913 | 66 | 6.6% |
1493 | 47 | 4.7% |
1795 | 10 | 1.0% |
1801 | 7 | 0.7% |
1889 | 5 | 0.5% |
Other values (29) | 42 | 4.2% |
Value | Count | Frequency (%) |
1300 | 72 | 7.2% |
1371 | 1 | 0.1% |
1406 | 1 | 0.1% |
1426 | 215 | |
1475 | 1 | 0.1% |
1493 | 47 | 4.7% |
1497 | 1 | 0.1% |
1498 | 2 | 0.2% |
1513 | 1 | 0.1% |
1544 | 1 | 0.1% |
Value | Count | Frequency (%) |
2001 | 1 | 0.1% |
1938 | 1 | 0.1% |
1932 | 1 | 0.1% |
1921 | 142 | |
1914 | 1 | 0.1% |
1913 | 66 | |
1889 | 5 | 0.5% |
1875 | 1 | 0.1% |
1851 | 4 | 0.4% |
1846 | 1 | 0.1% |
REG_TS
Date
Distinct | 547 |
---|---|
Distinct (%) | 54.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2018-07-13 18:58:26 |
---|---|
Maximum | 2020-08-13 13:12:24 |
CUST_NO | UPDT_DY | CDRI_LCLASS_CD | CDRI_MCLASS_CD | OCCR_AMT | PLOAN_ITEM_CD | GCTPT_PLC_CD | PRESENT_CTRL_BRCD | MABR_CD | ACCT_DY | TRNSFER_SLIP_NO | RCV_SLIP_NO | REG_ENO | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CUST_NO | 1.000 | 0.305 | 0.314 | 0.256 | 0.254 | 0.215 | 0.263 | 0.335 | 0.284 | 0.293 | 0.664 | 0.595 | 0.159 |
UPDT_DY | 0.305 | 1.000 | 0.159 | 0.261 | 0.304 | 0.351 | 0.518 | 0.947 | 0.878 | 1.000 | 0.370 | 0.109 | 0.697 |
CDRI_LCLASS_CD | 0.314 | 0.159 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.385 | 0.236 | 0.201 | 0.000 | 0.000 | 0.299 |
CDRI_MCLASS_CD | 0.256 | 0.261 | 1.000 | 1.000 | 0.119 | 0.000 | 0.000 | 0.428 | 0.268 | 0.109 | 0.157 | 0.025 | 0.144 |
OCCR_AMT | 0.254 | 0.304 | 0.000 | 0.119 | 1.000 | 0.195 | 0.233 | 0.634 | 0.698 | 0.323 | 0.324 | 0.254 | 0.444 |
PLOAN_ITEM_CD | 0.215 | 0.351 | 0.000 | 0.000 | 0.195 | 1.000 | 0.976 | 0.549 | 0.495 | 0.353 | 0.307 | 0.287 | 0.397 |
GCTPT_PLC_CD | 0.263 | 0.518 | 0.000 | 0.000 | 0.233 | 0.976 | 1.000 | 0.700 | 0.676 | 0.520 | 0.444 | 0.335 | 0.547 |
PRESENT_CTRL_BRCD | 0.335 | 0.947 | 0.385 | 0.428 | 0.634 | 0.549 | 0.700 | 1.000 | 0.968 | 0.947 | 0.576 | 0.585 | 0.935 |
MABR_CD | 0.284 | 0.878 | 0.236 | 0.268 | 0.698 | 0.495 | 0.676 | 0.968 | 1.000 | 0.878 | 0.643 | 0.639 | 0.912 |
ACCT_DY | 0.293 | 1.000 | 0.201 | 0.109 | 0.323 | 0.353 | 0.520 | 0.947 | 0.878 | 1.000 | 0.369 | 0.103 | 0.703 |
TRNSFER_SLIP_NO | 0.664 | 0.370 | 0.000 | 0.157 | 0.324 | 0.307 | 0.444 | 0.576 | 0.643 | 0.369 | 1.000 | 0.966 | 0.524 |
RCV_SLIP_NO | 0.595 | 0.109 | 0.000 | 0.025 | 0.254 | 0.287 | 0.335 | 0.585 | 0.639 | 0.103 | 0.966 | 1.000 | 0.505 |
REG_ENO | 0.159 | 0.697 | 0.299 | 0.144 | 0.444 | 0.397 | 0.547 | 0.935 | 0.912 | 0.703 | 0.524 | 0.505 | 1.000 |
MABR_CD | ACCT_DVCD | CDRI_MCLASS_CD | PRESENT_CTRL_BRCD | CDRI_LCLASS_CD | |
---|---|---|---|---|---|
MABR_CD | 1.000 | 1.000 | 0.238 | 0.775 | 0.132 |
ACCT_DVCD | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
CDRI_MCLASS_CD | 0.238 | 1.000 | 1.000 | 0.377 | 0.998 |
PRESENT_CTRL_BRCD | 0.775 | 1.000 | 0.377 | 1.000 | 0.218 |
CDRI_LCLASS_CD | 0.132 | 1.000 | 0.998 | 0.218 | 1.000 |
CUST_NO | UPDT_DY | OCCR_AMT | PLOAN_ITEM_CD | GCTPT_PLC_CD | ACCT_DY | TRNSFER_SLIP_NO | RCV_SLIP_NO | REG_ENO | CDRI_LCLASS_CD | CDRI_MCLASS_CD | PRESENT_CTRL_BRCD | ACCT_DVCD | MABR_CD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CUST_NO | 1.000 | 0.104 | -0.167 | 0.068 | 0.092 | 0.109 | 0.686 | 0.603 | 0.095 | 0.135 | 0.196 | 0.132 | 1.000 | 0.114 |
UPDT_DY | 0.104 | 1.000 | -0.159 | -0.034 | -0.054 | 1.000 | -0.149 | -0.388 | 0.320 | 0.126 | 0.171 | 0.865 | 1.000 | 0.753 |
OCCR_AMT | -0.167 | -0.159 | 1.000 | 0.058 | 0.053 | -0.155 | -0.079 | 0.008 | 0.063 | 0.000 | 0.119 | 0.306 | 1.000 | 0.365 |
PLOAN_ITEM_CD | 0.068 | -0.034 | 0.058 | 1.000 | 0.771 | -0.032 | 0.085 | 0.096 | -0.047 | 0.000 | 0.000 | 0.324 | 1.000 | 0.290 |
GCTPT_PLC_CD | 0.092 | -0.054 | 0.053 | 0.771 | 1.000 | -0.053 | 0.149 | 0.106 | 0.115 | 0.000 | 0.000 | 0.411 | 1.000 | 0.394 |
ACCT_DY | 0.109 | 1.000 | -0.155 | -0.032 | -0.053 | 1.000 | -0.146 | -0.387 | 0.323 | 0.069 | 0.051 | 0.865 | 1.000 | 0.753 |
TRNSFER_SLIP_NO | 0.686 | -0.149 | -0.079 | 0.085 | 0.149 | -0.146 | 1.000 | 0.882 | -0.107 | 0.000 | 0.120 | 0.255 | 1.000 | 0.313 |
RCV_SLIP_NO | 0.603 | -0.388 | 0.008 | 0.096 | 0.106 | -0.387 | 0.882 | 1.000 | -0.293 | 0.000 | 0.019 | 0.262 | 1.000 | 0.310 |
REG_ENO | 0.095 | 0.320 | 0.063 | -0.047 | 0.115 | 0.323 | -0.107 | -0.293 | 1.000 | 0.176 | 0.146 | 0.690 | 1.000 | 0.690 |
CDRI_LCLASS_CD | 0.135 | 0.126 | 0.000 | 0.000 | 0.000 | 0.069 | 0.000 | 0.000 | 0.176 | 1.000 | 0.998 | 0.218 | 1.000 | 0.132 |
CDRI_MCLASS_CD | 0.196 | 0.171 | 0.119 | 0.000 | 0.000 | 0.051 | 0.120 | 0.019 | 0.146 | 0.998 | 1.000 | 0.377 | 1.000 | 0.238 |
PRESENT_CTRL_BRCD | 0.132 | 0.865 | 0.306 | 0.324 | 0.411 | 0.865 | 0.255 | 0.262 | 0.690 | 0.218 | 0.377 | 1.000 | 1.000 | 0.775 |
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 |
MABR_CD | 0.114 | 0.753 | 0.365 | 0.290 | 0.394 | 0.753 | 0.313 | 0.310 | 0.690 | 0.132 | 0.238 | 0.775 | 1.000 | 1.000 |
CUST_NO | COMPLT_DVCD | UPDT_DY | CDRI_LCLASS_CD | CDRI_MCLASS_CD | OCCR_AMT | PLOAN_ITEM_CD | GCTPT_PLC_CD | PRESENT_CTRL_BRCD | TRNSFER_TS | RCV_TS | ACCT_DVCD | MABR_CD | ACCT_DY | TRNSFER_SLIP_NO | RCV_SLIP_NO | REG_ENO | REG_TS | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 127910988 | 1 | 20200413 | 1 | 0 | 173000000 | 11 | 117896 | TQC | 2020/04/13 14:54:18 | 2020/04/13 15:56:15 | 7 | TPA | 20200413 | 246 | 141 | 1655 | 2020/04/13 14:54:27 |
1 | 98960627 | 1 | 20200413 | 1 | 0 | 509000000 | 31 | 310062 | TQC | 2020/04/13 14:54:14 | 2020/04/13 15:54:46 | 7 | TPA | 20200413 | 131 | 26 | 1913 | 2020/04/13 14:54:23 |
2 | 137312505 | 1 | 20200413 | 1 | 0 | 301000000 | 11 | 117906 | TQC | 2020/04/13 14:54:05 | 2020/04/13 15:56:31 | 7 | TPA | 20200413 | 277 | 172 | 1655 | 2020/04/13 14:54:14 |
3 | 100512468 | 1 | 20200413 | 1 | 0 | 504000000 | 31 | 310062 | TQC | 2020/04/13 14:53:57 | 2020/04/13 15:54:46 | 7 | TPA | 20200413 | 132 | 27 | 1913 | 2020/04/13 14:54:06 |
4 | 137577939 | 1 | 20200413 | 1 | 0 | 327000000 | 11 | 117333 | TQC | 2020/04/13 14:53:43 | 2020/04/13 15:56:33 | 7 | TPA | 20200413 | 282 | 177 | 1913 | 2020/04/13 14:53:52 |
5 | 124393498 | 1 | 20200413 | 1 | 0 | 257000000 | 11 | 117906 | TQC | 2020/04/13 14:53:43 | 2020/04/13 15:56:00 | 7 | TPA | 20200413 | 223 | 118 | 1655 | 2020/04/13 14:53:52 |
6 | 137360557 | 1 | 20200413 | 1 | 0 | 229000000 | 11 | 117333 | TQC | 2020/04/13 14:53:31 | 2020/04/13 15:56:31 | 7 | TPA | 20200413 | 278 | 173 | 1913 | 2020/04/13 14:53:40 |
7 | 97547313 | 1 | 20200413 | 1 | 0 | 386000000 | 11 | 117906 | TQC | 2020/04/13 14:53:23 | 2020/04/13 15:54:42 | 7 | TPA | 20200413 | 127 | 22 | 1655 | 2020/04/13 14:53:32 |
8 | 112927821 | 1 | 20200413 | 1 | 0 | 271000000 | 11 | 117333 | TQC | 2020/04/13 14:53:18 | 2020/04/13 15:55:12 | 7 | TPA | 20200413 | 158 | 53 | 1913 | 2020/04/13 14:53:27 |
9 | 115782801 | 1 | 20200413 | 1 | 0 | 671000000 | 11 | 117896 | TQC | 2020/04/13 14:53:12 | 2020/04/13 15:55:23 | 7 | TPA | 20200413 | 173 | 68 | 1655 | 2020/04/13 14:53:21 |
CUST_NO | COMPLT_DVCD | UPDT_DY | CDRI_LCLASS_CD | CDRI_MCLASS_CD | OCCR_AMT | PLOAN_ITEM_CD | GCTPT_PLC_CD | PRESENT_CTRL_BRCD | TRNSFER_TS | RCV_TS | ACCT_DVCD | MABR_CD | ACCT_DY | TRNSFER_SLIP_NO | RCV_SLIP_NO | REG_ENO | REG_TS | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | 10772742 | 1 | 20180716 | 1 | 0 | 1013000000 | 32 | 323703 | TBB | 2018/07/13 23:23:31 | 2018/07/16 09:35:11 | 7 | TQA | 20180716 | 32 | 3 | 1493 | 2018/07/13 23:23:40 |
991 | 118645479 | 1 | 20180716 | 1 | 0 | 1183000000 | 32 | 323800 | TBB | 2018/07/13 23:23:31 | 2018/07/16 09:36:00 | 7 | TQA | 20180716 | 178 | 149 | 1493 | 2018/07/13 23:23:40 |
992 | 119195999 | 1 | 20180716 | 1 | 0 | 508000000 | 11 | 102254 | TBB | 2018/07/13 23:23:31 | 2018/07/16 09:36:02 | 7 | TQA | 20180716 | 183 | 154 | 1493 | 2018/07/13 23:23:40 |
993 | 119371153 | 1 | 20180716 | 1 | 0 | 1061000000 | 11 | 102254 | TBB | 2018/07/13 23:23:31 | 2018/07/16 09:36:03 | 7 | TQA | 20180716 | 186 | 157 | 1493 | 2018/07/13 23:23:40 |
994 | 119545798 | 1 | 20180716 | 1 | 0 | 228000000 | 4 | 69096 | TBB | 2018/07/13 23:23:31 | 2018/07/16 09:36:04 | 7 | TQA | 20180716 | 187 | 158 | 1493 | 2018/07/13 23:23:40 |
995 | 120054391 | 1 | 20180716 | 1 | 0 | 324000000 | 39 | 397289 | TBB | 2018/07/13 23:23:30 | 2018/07/16 09:36:05 | 7 | TQA | 20180716 | 190 | 161 | 1493 | 2018/07/13 23:23:39 |
996 | 90124571 | 1 | 20180716 | 1 | 0 | 1028000000 | 11 | 105206 | TBB | 2018/07/13 23:23:30 | 2018/07/16 09:35:20 | 7 | TQA | 20180716 | 61 | 32 | 1493 | 2018/07/13 23:23:39 |
997 | 120546414 | 1 | 20180716 | 1 | 0 | 617000000 | 4 | 68437 | TBB | 2018/07/13 23:23:30 | 2018/07/16 09:36:06 | 7 | TQA | 20180716 | 194 | 165 | 1493 | 2018/07/13 23:23:39 |
998 | 120015327 | 1 | 20180716 | 1 | 0 | 892000000 | 32 | 323800 | TBB | 2018/07/13 23:23:30 | 2018/07/16 09:36:04 | 7 | TQA | 20180716 | 189 | 160 | 1493 | 2018/07/13 23:23:39 |
999 | 120447584 | 1 | 20180716 | 1 | 0 | 686000000 | 11 | 118196 | TBB | 2018/07/13 23:23:30 | 2018/07/16 09:36:06 | 7 | TQA | 20180716 | 193 | 164 | 1493 | 2018/07/13 23:23:39 |