Dataset statistics
Number of variables | 16 |
---|---|
Number of observations | 1000 |
Missing cells | 4 |
Missing cells (%) | < 0.1% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 136.8 KiB |
Average record size in memory | 140.1 B |
Variable types
Text | 1 |
---|---|
Categorical | 7 |
Numeric | 7 |
DateTime | 1 |
Dataset
Description | 한국주택금융공사 주택연금부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15072832/fileData.do |
REG_ENO has constant value "" | Constant |
PDUTY_BRCD is highly overall correlated with PDUTY_ENO and 4 other fields | High correlation |
ARCV_STRT_DY is highly overall correlated with PDUTY_ENO and 7 other fields | High correlation |
PDUTY_TEAM_CD is highly overall correlated with PDUTY_ENO and 4 other fields | High correlation |
ADV_RCV_TARIF is highly overall correlated with CUST_NO and 5 other fields | High correlation |
PNSN_PAYFORM_CD is highly overall correlated with GUARNT_TERM_DY and 2 other fields | High correlation |
PDUTY_ENO is highly overall correlated with PDUTY_BRCD and 2 other fields | High correlation |
CUST_NO is highly overall correlated with ARCV_STRT_DY and 1 other fields | High correlation |
ARCV_TERM_DY is highly overall correlated with ADV_RCV_DCNT | High correlation |
ADV_RCV_DCNT is highly overall correlated with ARCV_TERM_DY | High correlation |
GUARNT_TERM_DY is highly overall correlated with PDUTY_BRCD and 3 other fields | High correlation |
BBNK_GIRO_CD is highly overall correlated with BBNK_ORG_CD and 1 other fields | High correlation |
BBNK_ORG_CD is highly overall correlated with BBNK_GIRO_CD and 1 other fields | High correlation |
ARCV_STRT_DY is highly imbalanced (98.9%) | Imbalance |
ADV_RCV_TARIF is highly imbalanced (95.2%) | Imbalance |
INC_RATE is highly imbalanced (60.1%) | Imbalance |
GUARNT_TERM_DY is highly skewed (γ1 = -31.26709107) | Skewed |
GUARNT_NO has unique values | Unique |
Reproduction
Analysis started | 2023-12-12 22:09:03.943202 |
---|---|
Analysis finished | 2023-12-12 22:09:11.510198 |
Duration | 7.57 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
GUARNT_NO
Text
UNIQUE
 
Distinct | 1000 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Characters and Unicode
Total characters | 14000 |
---|---|
Distinct characters | 24 |
Distinct categories | 2 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 1000 ? |
---|---|
Unique (%) | 100.0% |
Sample
1st row | RTOA2020000211 |
---|---|
2nd row | RTHA2020000681 |
3rd row | RTHA2020000641 |
4th row | RQAD2020000596 |
5th row | RTQA2020000274 |
Value | Count | Frequency (%) |
rtoa2020000211 | 1 | 0.1% |
rtaa2009000096 | 1 | 0.1% |
rtha2009000119 | 1 | 0.1% |
rqad2008000216 | 1 | 0.1% |
rtha2009000117 | 1 | 0.1% |
rtha2009000116 | 1 | 0.1% |
rtma2009000028 | 1 | 0.1% |
rtha2009000112 | 1 | 0.1% |
rtma2009000027 | 1 | 0.1% |
rtho2009000007 | 1 | 0.1% |
Other values (990) | 990 |
Most occurring characters
Value | Count | Frequency (%) |
0 | 5844 | |
2 | 1393 | 10.0% |
A | 1088 | 7.8% |
R | 1003 | 7.2% |
T | 567 | 4.0% |
8 | 532 | 3.8% |
1 | 517 | 3.7% |
9 | 509 | 3.6% |
Q | 436 | 3.1% |
D | 434 | 3.1% |
Other values (14) | 1677 | 12.0% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 10004 | |
Uppercase Letter | 3996 | 28.5% |
Most frequent character per category
Uppercase Letter
Value | Count | Frequency (%) |
A | 1088 | |
R | 1003 | |
T | 567 | |
Q | 436 | |
D | 434 | 10.9% |
H | 266 | 6.7% |
O | 89 | 2.2% |
B | 39 | 1.0% |
M | 25 | 0.6% |
J | 16 | 0.4% |
Other values (4) | 33 | 0.8% |
Decimal Number
Value | Count | Frequency (%) |
0 | 5844 | |
2 | 1393 | 13.9% |
8 | 532 | 5.3% |
1 | 517 | 5.2% |
9 | 509 | 5.1% |
7 | 390 | 3.9% |
3 | 261 | 2.6% |
5 | 193 | 1.9% |
4 | 192 | 1.9% |
6 | 173 | 1.7% |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 10004 | |
Latin | 3996 | 28.5% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
A | 1088 | |
R | 1003 | |
T | 567 | |
Q | 436 | |
D | 434 | 10.9% |
H | 266 | 6.7% |
O | 89 | 2.2% |
B | 39 | 1.0% |
M | 25 | 0.6% |
J | 16 | 0.4% |
Other values (4) | 33 | 0.8% |
Common
Value | Count | Frequency (%) |
0 | 5844 | |
2 | 1393 | 13.9% |
8 | 532 | 5.3% |
1 | 517 | 5.2% |
9 | 509 | 5.1% |
7 | 390 | 3.9% |
3 | 261 | 2.6% |
5 | 193 | 1.9% |
4 | 192 | 1.9% |
6 | 173 | 1.7% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 14000 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
0 | 5844 | |
2 | 1393 | 10.0% |
A | 1088 | 7.8% |
R | 1003 | 7.2% |
T | 567 | 4.0% |
8 | 532 | 3.8% |
1 | 517 | 3.7% |
9 | 509 | 3.6% |
Q | 436 | 3.1% |
D | 434 | 3.1% |
Other values (14) | 1677 | 12.0% |
PDUTY_BRCD
Categorical
HIGH CORRELATION
 
Distinct | 25 |
---|---|
Distinct (%) | 2.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
QAD | |
---|---|
TAB | |
TAC | |
THB | |
TAD | |
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 | TOA |
---|---|
2nd row | THA |
3rd row | THA |
4th row | QAD |
5th row | TQA |
Common Values
Value | Count | Frequency (%) |
QAD | 153 | |
TAB | 150 | |
TAC | 115 | |
THB | 114 | |
TAD | 101 | |
THA | 93 | |
TAA | 91 | |
THO | 57 | 5.7% |
TOA | 19 | 1.9% |
TBA | 16 | 1.6% |
Other values (15) | 91 |
Length
Value | Count | Frequency (%) |
qad | 153 | |
tab | 150 | |
tac | 115 | |
thb | 114 | |
tad | 101 | |
tha | 93 | |
taa | 91 | |
tho | 57 | 5.7% |
toa | 19 | 1.9% |
tba | 16 | 1.6% |
Other values (15) | 91 |
PDUTY_TEAM_CD
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
3 | |
2 | |
A | 1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | 2 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
1 | 547 | |
3 | 267 | |
2 | 185 | 18.5% |
A | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 547 | |
3 | 267 | |
2 | 185 | 18.5% |
a | 1 | 0.1% |
PDUTY_ENO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 51 |
---|---|
Distinct (%) | 5.1% |
Missing | 1 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1789.7838 |
Minimum | 1174 |
---|---|
Maximum | 2003 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 1174 |
---|---|
5-th percentile | 1475 |
Q1 | 1656 |
median | 1788 |
Q3 | 1977 |
95-th percentile | 2001 |
Maximum | 2003 |
Range | 829 |
Interquartile range (IQR) | 321 |
Descriptive statistics
Standard deviation | 184.18261 |
---|---|
Coefficient of variation (CV) | 0.10290774 |
Kurtosis | -0.64652024 |
Mean | 1789.7838 |
Median Absolute Deviation (MAD) | 182 |
Skewness | -0.50803476 |
Sum | 1787994 |
Variance | 33923.234 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1977 | 142 | |
1689 | 120 | |
2001 | 98 | |
1970 | 85 | 8.5% |
1788 | 65 | 6.5% |
1917 | 57 | 5.7% |
1650 | 52 | 5.2% |
1475 | 51 | 5.1% |
1554 | 50 | 5.0% |
1656 | 49 | 4.9% |
Other values (41) | 230 |
Value | Count | Frequency (%) |
1174 | 4 | 0.4% |
1371 | 16 | 1.6% |
1385 | 2 | 0.2% |
1406 | 11 | 1.1% |
1446 | 2 | 0.2% |
1475 | 51 | |
1530 | 4 | 0.4% |
1554 | 50 | |
1557 | 13 | 1.3% |
1597 | 2 | 0.2% |
Value | Count | Frequency (%) |
2003 | 11 | 1.1% |
2001 | 98 | |
2000 | 8 | 0.8% |
1999 | 1 | 0.1% |
1977 | 142 | |
1973 | 1 | 0.1% |
1970 | 85 | |
1968 | 5 | 0.5% |
1965 | 1 | 0.1% |
1956 | 5 | 0.5% |
CUST_NO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 999 |
---|---|
Distinct (%) | 100.0% |
Missing | 1 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 66232452 |
Minimum | 2102090 |
---|---|
Maximum | 1.4473836 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 2102090 |
---|---|
5-th percentile | 20017857 |
Q1 | 65818900 |
median | 69686419 |
Q3 | 73971534 |
95-th percentile | 77432959 |
Maximum | 1.4473836 × 108 |
Range | 1.4263627 × 108 |
Interquartile range (IQR) | 8152633.5 |
Descriptive statistics
Standard deviation | 17077376 |
---|---|
Coefficient of variation (CV) | 0.25784001 |
Kurtosis | 7.6936424 |
Mean | 66232452 |
Median Absolute Deviation (MAD) | 4143429 |
Skewness | -1.1679746 |
Sum | 6.6166219 × 1010 |
Variance | 2.9163678 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
144574200 | 1 | 0.1% |
70756671 | 1 | 0.1% |
74903666 | 1 | 0.1% |
74904461 | 1 | 0.1% |
74595537 | 1 | 0.1% |
74311805 | 1 | 0.1% |
72810683 | 1 | 0.1% |
70311870 | 1 | 0.1% |
69937731 | 1 | 0.1% |
69819477 | 1 | 0.1% |
Other values (989) | 989 |
Value | Count | Frequency (%) |
2102090 | 1 | |
2179175 | 1 | |
2236759 | 1 | |
2359429 | 1 | |
2444402 | 1 | |
4413334 | 1 | |
5194209 | 1 | |
7951071 | 1 | |
8042468 | 1 | |
8066884 | 1 |
Value | Count | Frequency (%) |
144738363 | 1 | |
144635479 | 1 | |
144574200 | 1 | |
144504623 | 1 | |
144473990 | 1 | |
144469742 | 1 | |
144444424 | 1 | |
144352956 | 1 | |
144320904 | 1 | |
115145545 | 1 |
ARCV_STRT_DY
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
20201024 | |
---|---|
20201023 | 1 |
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | 20201024 |
---|---|
2nd row | 20201024 |
3rd row | 20201024 |
4th row | 20201024 |
5th row | 20201024 |
Common Values
Value | Count | Frequency (%) |
20201024 | 999 | |
20201023 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20201024 | 999 | |
20201023 | 1 | 0.1% |
ARCV_TERM_DY
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 24 |
---|---|
Distinct (%) | 2.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20201092 |
Minimum | 20201023 |
---|---|
Maximum | 20201124 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 20201023 |
---|---|
5-th percentile | 20201026 |
Q1 | 20201083 |
median | 20201110 |
Q3 | 20201118 |
95-th percentile | 20201123 |
Maximum | 20201124 |
Range | 101 |
Interquartile range (IQR) | 35 |
Descriptive statistics
Standard deviation | 37.426258 |
---|---|
Coefficient of variation (CV) | 1.8526849 × 10-6 |
Kurtosis | -0.72490391 |
Mean | 20201092 |
Median Absolute Deviation (MAD) | 9 |
Skewness | -1.0724685 |
Sum | 2.0201092 × 1010 |
Variance | 1400.7248 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20201119 | 125 | 12.5% |
20201029 | 109 | 10.9% |
20201112 | 98 | 9.8% |
20201105 | 88 | 8.8% |
20201028 | 39 | 3.9% |
20201122 | 38 | 3.8% |
20201027 | 37 | 3.7% |
20201124 | 36 | 3.6% |
20201118 | 35 | 3.5% |
20201109 | 34 | 3.4% |
Other values (14) | 361 |
Value | Count | Frequency (%) |
20201023 | 1 | 0.1% |
20201025 | 33 | 3.3% |
20201026 | 31 | 3.1% |
20201027 | 37 | 3.7% |
20201028 | 39 | 3.9% |
20201029 | 109 | |
20201101 | 26 | 2.6% |
20201102 | 22 | 2.2% |
20201103 | 25 | 2.5% |
20201104 | 27 | 2.7% |
Value | Count | Frequency (%) |
20201124 | 36 | 3.6% |
20201123 | 29 | 2.9% |
20201122 | 38 | 3.8% |
20201119 | 125 | |
20201118 | 35 | 3.5% |
20201117 | 31 | 3.1% |
20201116 | 22 | 2.2% |
20201115 | 28 | 2.8% |
20201112 | 98 | |
20201111 | 31 | 3.1% |
ADV_RCV_DCNT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 24 |
---|---|
Distinct (%) | 2.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 16.839 |
Minimum | 0 |
---|---|
Maximum | 32 |
Zeros | 1 |
Zeros (%) | 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 3 |
Q1 | 8.25 |
median | 18 |
Q3 | 26 |
95-th percentile | 31 |
Maximum | 32 |
Range | 32 |
Interquartile range (IQR) | 17.75 |
Descriptive statistics
Standard deviation | 9.2360372 |
---|---|
Coefficient of variation (CV) | 0.54849084 |
Kurtosis | -1.3018262 |
Mean | 16.839 |
Median Absolute Deviation (MAD) | 9 |
Skewness | -0.0277195 |
Sum | 16839 |
Variance | 85.304383 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
27 | 125 | 12.5% |
6 | 109 | 10.9% |
20 | 98 | 9.8% |
13 | 88 | 8.8% |
5 | 39 | 3.9% |
30 | 38 | 3.8% |
4 | 37 | 3.7% |
32 | 36 | 3.6% |
26 | 35 | 3.5% |
17 | 34 | 3.4% |
Other values (14) | 361 |
Value | Count | Frequency (%) |
0 | 1 | 0.1% |
2 | 33 | 3.3% |
3 | 31 | 3.1% |
4 | 37 | 3.7% |
5 | 39 | 3.9% |
6 | 109 | |
9 | 26 | 2.6% |
10 | 22 | 2.2% |
11 | 25 | 2.5% |
12 | 27 | 2.7% |
Value | Count | Frequency (%) |
32 | 36 | 3.6% |
31 | 29 | 2.9% |
30 | 38 | 3.8% |
27 | 125 | |
26 | 35 | 3.5% |
25 | 31 | 3.1% |
24 | 22 | 2.2% |
23 | 28 | 2.8% |
20 | 98 | |
19 | 31 | 3.1% |
ADV_RCV_TARIF
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0.5 | |
---|---|
0.75 | 9 |
1.0 | 1 |
0.0 | 1 |
Length
Max length | 4 |
---|---|
Median length | 3 |
Mean length | 3.009 |
Min length | 3 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 0.2% |
Sample
1st row | 0.75 |
---|---|
2nd row | 0.75 |
3rd row | 0.75 |
4th row | 1.0 |
5th row | 0.75 |
Common Values
Value | Count | Frequency (%) |
0.5 | 989 | |
0.75 | 9 | 0.9% |
1.0 | 1 | 0.1% |
0.0 | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0.5 | 989 | |
0.75 | 9 | 0.9% |
1.0 | 1 | 0.1% |
0.0 | 1 | 0.1% |
GUARNT_TERM_DY
Real number (ℝ)
HIGH CORRELATION
  SKEWED
 
Distinct | 909 |
---|---|
Distinct (%) | 90.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20348050 |
Minimum | 0 |
---|---|
Maximum | 20611011 |
Zeros | 1 |
Zeros (%) | 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 20270908 |
Q1 | 20330859 |
median | 20370563 |
Q3 | 20410411 |
95-th percentile | 20451006 |
Maximum | 20611011 |
Range | 20611011 |
Interquartile range (IQR) | 79551.75 |
Descriptive statistics
Standard deviation | 646534.47 |
---|---|
Coefficient of variation (CV) | 0.03177378 |
Kurtosis | 985.01489 |
Mean | 20348050 |
Median Absolute Deviation (MAD) | 39842 |
Skewness | -31.267091 |
Sum | 2.034805 × 1010 |
Variance | 4.1800682 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20330404 | 3 | 0.3% |
20311009 | 3 | 0.3% |
20410109 | 3 | 0.3% |
20351026 | 3 | 0.3% |
20410423 | 3 | 0.3% |
20351028 | 3 | 0.3% |
20371120 | 3 | 0.3% |
20371014 | 2 | 0.2% |
20310410 | 2 | 0.2% |
20301006 | 2 | 0.2% |
Other values (899) | 973 |
Value | Count | Frequency (%) |
0 | 1 | |
20210423 | 1 | |
20220428 | 1 | |
20230403 | 1 | |
20230620 | 1 | |
20230904 | 2 | |
20230905 | 1 | |
20231004 | 1 | |
20231007 | 1 | |
20231105 | 1 |
Value | Count | Frequency (%) |
20611011 | 1 | |
20531007 | 1 | |
20531005 | 1 | |
20500326 | 1 | |
20490910 | 1 | |
20490727 | 1 | |
20490527 | 1 | |
20490525 | 1 | |
20490507 | 1 | |
20490427 | 1 |
BBNK_GIRO_CD
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 720 |
---|---|
Distinct (%) | 72.1% |
Missing | 1 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 188726.68 |
Minimum | 30012 |
---|---|
Maximum | 882639 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 8.9 KiB |
Quantile statistics
Minimum | 30012 |
---|---|
5-th percentile | 34766.9 |
Q1 | 63704 |
median | 103868 |
Q3 | 207942 |
95-th percentile | 814480.5 |
Maximum | 882639 |
Range | 852627 |
Interquartile range (IQR) | 144238 |
Descriptive statistics
Standard deviation | 222975.39 |
---|---|
Coefficient of variation (CV) | 1.1814725 |
Kurtosis | 3.5130678 |
Mean | 188726.68 |
Median Absolute Deviation (MAD) | 63361 |
Skewness | 2.1467417 |
Sum | 1.8853796 × 108 |
Variance | 4.9718025 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
30371 | 11 | 1.1% |
66811 | 9 | 0.9% |
65113 | 9 | 0.9% |
66497 | 7 | 0.7% |
69193 | 6 | 0.6% |
66390 | 6 | 0.6% |
66387 | 6 | 0.6% |
66507 | 5 | 0.5% |
207476 | 5 | 0.5% |
63539 | 5 | 0.5% |
Other values (710) | 930 |
Value | Count | Frequency (%) |
30012 | 1 | 0.1% |
30038 | 1 | 0.1% |
30041 | 2 | 0.2% |
30148 | 1 | 0.1% |
30164 | 1 | 0.1% |
30326 | 1 | 0.1% |
30371 | 11 | |
30847 | 1 | 0.1% |
30889 | 1 | 0.1% |
31095 | 1 | 0.1% |
Value | Count | Frequency (%) |
882639 | 1 | |
882613 | 1 | |
882532 | 1 | |
881517 | 2 | |
842543 | 1 | |
842297 | 1 | |
842200 | 2 | |
842051 | 1 | |
842022 | 2 | |
841816 | 1 |
BBNK_ORG_CD
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 9 |
---|---|
Distinct (%) | 0.9% |
Missing | 1 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 24.761762 |
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 | 3 |
Q1 | 4 |
median | 4 |
Q3 | 20 |
95-th percentile | 88 |
Maximum | 88 |
Range | 85 |
Interquartile range (IQR) | 16 |
Descriptive statistics
Standard deviation | 32.64323 |
---|---|
Coefficient of variation (CV) | 1.3182919 |
Kurtosis | -0.23963794 |
Mean | 24.761762 |
Median Absolute Deviation (MAD) | 1 |
Skewness | 1.2707268 |
Sum | 24737 |
Variance | 1065.5805 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4 | 483 | |
88 | 139 | 13.9% |
20 | 135 | 13.5% |
11 | 100 | 10.0% |
81 | 79 | 7.9% |
3 | 57 | 5.7% |
32 | 3 | 0.3% |
34 | 2 | 0.2% |
39 | 1 | 0.1% |
(Missing) | 1 | 0.1% |
Value | Count | Frequency (%) |
3 | 57 | 5.7% |
4 | 483 | |
11 | 100 | 10.0% |
20 | 135 | 13.5% |
32 | 3 | 0.3% |
34 | 2 | 0.2% |
39 | 1 | 0.1% |
81 | 79 | 7.9% |
88 | 139 | 13.9% |
Value | Count | Frequency (%) |
88 | 139 | 13.9% |
81 | 79 | 7.9% |
39 | 1 | 0.1% |
34 | 2 | 0.2% |
32 | 3 | 0.3% |
20 | 135 | 13.5% |
11 | 100 | 10.0% |
4 | 483 | |
3 | 57 | 5.7% |
PNSN_PAYFORM_CD
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1 | |
---|---|
2 | |
6 | 1 |
<NA> | 1 |
Length
Max length | 4 |
---|---|
Median length | 1 |
Mean length | 1.003 |
Min length | 1 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 0.2% |
Sample
1st row | 1 |
---|---|
2nd row | 2 |
3rd row | 2 |
4th row | 6 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
1 | 546 | |
2 | 452 | |
6 | 1 | 0.1% |
<NA> | 1 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 546 | |
2 | 452 | |
6 | 1 | 0.1% |
na | 1 | 0.1% |
REG_ENO
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
1200 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1200 |
---|---|
2nd row | 1200 |
3rd row | 1200 |
4th row | 1200 |
5th row | 1200 |
Common Values
Value | Count | Frequency (%) |
1200 | 1000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1200 | 1000 |
REG_TS
Date
Distinct | 59 |
---|---|
Distinct (%) | 5.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
Minimum | 2020-10-24 03:00:09 |
---|---|
Maximum | 2020-10-24 03:03:23 |
INC_RATE
Categorical
IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | 0.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.9 KiB |
0 | |
---|---|
-3 | |
3 | 9 |
Length
Max length | 2 |
---|---|
Median length | 1 |
Mean length | 1.131 |
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 | 860 | |
-3 | 131 | 13.1% |
3 | 9 | 0.9% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 860 | |
3 | 140 | 14.0% |
PDUTY_BRCD | PDUTY_TEAM_CD | PDUTY_ENO | CUST_NO | ARCV_STRT_DY | ARCV_TERM_DY | ADV_RCV_DCNT | ADV_RCV_TARIF | GUARNT_TERM_DY | BBNK_GIRO_CD | BBNK_ORG_CD | PNSN_PAYFORM_CD | REG_TS | INC_RATE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PDUTY_BRCD | 1.000 | 0.997 | 0.975 | 0.235 | 1.000 | 0.000 | 0.040 | 0.806 | 1.000 | 0.541 | 0.473 | 0.000 | 0.669 | 0.112 |
PDUTY_TEAM_CD | 0.997 | 1.000 | 0.736 | 0.106 | 1.000 | 0.000 | 0.079 | 0.894 | 1.000 | 0.250 | 0.139 | 0.201 | 0.831 | 0.000 |
PDUTY_ENO | 0.975 | 0.736 | 1.000 | 0.144 | NaN | 0.000 | 0.079 | 0.000 | NaN | 0.118 | 0.102 | 0.126 | 0.000 | 0.080 |
CUST_NO | 0.235 | 0.106 | 0.144 | 1.000 | NaN | 0.169 | 0.098 | 0.790 | NaN | 0.289 | 0.281 | 0.347 | 0.758 | 0.298 |
ARCV_STRT_DY | 1.000 | 1.000 | NaN | NaN | 1.000 | NaN | 0.096 | 1.000 | 0.706 | NaN | NaN | NaN | 1.000 | 0.000 |
ARCV_TERM_DY | 0.000 | 0.000 | 0.000 | 0.169 | NaN | 1.000 | 0.990 | 0.087 | NaN | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
ADV_RCV_DCNT | 0.040 | 0.079 | 0.079 | 0.098 | 0.096 | 0.990 | 1.000 | 0.144 | 0.096 | 0.022 | 0.000 | 0.000 | 0.246 | 0.000 |
ADV_RCV_TARIF | 0.806 | 0.894 | 0.000 | 0.790 | 1.000 | 0.087 | 0.144 | 1.000 | 1.000 | 0.522 | 0.318 | 0.943 | 0.954 | 0.000 |
GUARNT_TERM_DY | 1.000 | 1.000 | NaN | NaN | 0.706 | NaN | 0.096 | 1.000 | 1.000 | NaN | NaN | NaN | 1.000 | 0.000 |
BBNK_GIRO_CD | 0.541 | 0.250 | 0.118 | 0.289 | NaN | 0.000 | 0.022 | 0.522 | NaN | 1.000 | 0.918 | 0.000 | 0.106 | 0.000 |
BBNK_ORG_CD | 0.473 | 0.139 | 0.102 | 0.281 | NaN | 0.000 | 0.000 | 0.318 | NaN | 0.918 | 1.000 | 0.000 | 0.166 | 0.000 |
PNSN_PAYFORM_CD | 0.000 | 0.201 | 0.126 | 0.347 | NaN | 0.000 | 0.000 | 0.943 | NaN | 0.000 | 0.000 | 1.000 | 0.329 | 0.046 |
REG_TS | 0.669 | 0.831 | 0.000 | 0.758 | 1.000 | 0.000 | 0.246 | 0.954 | 1.000 | 0.106 | 0.166 | 0.329 | 1.000 | 0.138 |
INC_RATE | 0.112 | 0.000 | 0.080 | 0.298 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.046 | 0.138 | 1.000 |
PDUTY_BRCD | INC_RATE | ARCV_STRT_DY | PDUTY_TEAM_CD | ADV_RCV_TARIF | PNSN_PAYFORM_CD | |
---|---|---|---|---|---|---|
PDUTY_BRCD | 1.000 | 0.056 | 0.988 | 0.982 | 0.568 | 0.000 |
INC_RATE | 0.056 | 1.000 | 0.000 | 0.000 | 0.000 | 0.013 |
ARCV_STRT_DY | 0.988 | 0.000 | 1.000 | 0.999 | 0.999 | 1.000 |
PDUTY_TEAM_CD | 0.982 | 0.000 | 0.999 | 1.000 | 0.576 | 0.063 |
ADV_RCV_TARIF | 0.568 | 0.000 | 0.999 | 0.576 | 1.000 | 0.707 |
PNSN_PAYFORM_CD | 0.000 | 0.013 | 1.000 | 0.063 | 0.707 | 1.000 |
PDUTY_ENO | CUST_NO | ARCV_TERM_DY | ADV_RCV_DCNT | GUARNT_TERM_DY | BBNK_GIRO_CD | BBNK_ORG_CD | PDUTY_BRCD | PDUTY_TEAM_CD | ARCV_STRT_DY | ADV_RCV_TARIF | PNSN_PAYFORM_CD | INC_RATE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PDUTY_ENO | 1.000 | 0.002 | 0.004 | 0.004 | 0.024 | 0.041 | 0.042 | 0.716 | 0.632 | 1.000 | 0.102 | 0.073 | 0.042 |
CUST_NO | 0.002 | 1.000 | 0.024 | 0.024 | 0.177 | 0.065 | 0.058 | 0.083 | 0.064 | 1.000 | 0.707 | 0.234 | 0.196 |
ARCV_TERM_DY | 0.004 | 0.024 | 1.000 | 1.000 | -0.030 | -0.037 | -0.033 | 0.000 | 0.000 | 0.000 | 0.067 | 0.000 | 0.000 |
ADV_RCV_DCNT | 0.004 | 0.024 | 1.000 | 1.000 | -0.030 | -0.037 | -0.033 | 0.018 | 0.057 | 0.073 | 0.086 | 0.000 | 0.000 |
GUARNT_TERM_DY | 0.024 | 0.177 | -0.030 | -0.030 | 1.000 | -0.047 | -0.044 | 0.988 | 0.999 | 0.499 | 0.999 | 1.000 | 0.000 |
BBNK_GIRO_CD | 0.041 | 0.065 | -0.037 | -0.037 | -0.047 | 1.000 | 0.895 | 0.246 | 0.106 | 1.000 | 0.251 | 0.000 | 0.000 |
BBNK_ORG_CD | 0.042 | 0.058 | -0.033 | -0.033 | -0.044 | 0.895 | 1.000 | 0.248 | 0.105 | 1.000 | 0.253 | 0.000 | 0.000 |
PDUTY_BRCD | 0.716 | 0.083 | 0.000 | 0.018 | 0.988 | 0.246 | 0.248 | 1.000 | 0.982 | 0.988 | 0.568 | 0.000 | 0.056 |
PDUTY_TEAM_CD | 0.632 | 0.064 | 0.000 | 0.057 | 0.999 | 0.106 | 0.105 | 0.982 | 1.000 | 0.999 | 0.576 | 0.063 | 0.000 |
ARCV_STRT_DY | 1.000 | 1.000 | 0.000 | 0.073 | 0.499 | 1.000 | 1.000 | 0.988 | 0.999 | 1.000 | 0.999 | 1.000 | 0.000 |
ADV_RCV_TARIF | 0.102 | 0.707 | 0.067 | 0.086 | 0.999 | 0.251 | 0.253 | 0.568 | 0.576 | 0.999 | 1.000 | 0.707 | 0.000 |
PNSN_PAYFORM_CD | 0.073 | 0.234 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.063 | 1.000 | 0.707 | 1.000 | 0.013 |
INC_RATE | 0.042 | 0.196 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.056 | 0.000 | 0.000 | 0.000 | 0.013 | 1.000 |
GUARNT_NO | PDUTY_BRCD | PDUTY_TEAM_CD | PDUTY_ENO | CUST_NO | ARCV_STRT_DY | ARCV_TERM_DY | ADV_RCV_DCNT | ADV_RCV_TARIF | GUARNT_TERM_DY | BBNK_GIRO_CD | BBNK_ORG_CD | PNSN_PAYFORM_CD | REG_ENO | REG_TS | INC_RATE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | RTOA2020000211 | TOA | 2 | 2003 | 144574200 | 20201024 | 20201122 | 30 | 0.75 | 20450927 | 340320 | 34 | 1 | 1200 | 2020/10/24 03:03:23 | 0 |
1 | RTHA2020000681 | THA | 1 | 1174 | 144738363 | 20201024 | 20201122 | 30 | 0.75 | 20611011 | 206367 | 20 | 2 | 1200 | 2020/10/24 03:03:23 | 0 |
2 | RTHA2020000641 | THA | 1 | 1879 | 144352956 | 20201024 | 20201119 | 27 | 0.75 | 20370916 | 814432 | 81 | 2 | 1200 | 2020/10/24 03:03:23 | 0 |
3 | RQAD2020000596 | QAD | 1 | 1977 | 144444424 | 20201024 | 20201119 | 27 | 1.0 | 20481011 | 110495 | 11 | 6 | 1200 | 2020/10/24 03:03:23 | 0 |
4 | RTQA2020000274 | TQA | 2 | 1874 | 144473990 | 20201024 | 20201119 | 27 | 0.75 | 20531007 | 395346 | 39 | 2 | 1200 | 2020/10/24 03:03:23 | 0 |
5 | RTAD2020000612 | TAD | 1 | 1650 | 144469742 | 20201024 | 20201119 | 27 | 0.75 | 20471007 | 205876 | 20 | 1 | 1200 | 2020/10/24 03:03:23 | 0 |
6 | RTAC2020000698 | TAC | 3 | 1788 | 144504623 | 20201024 | 20201119 | 27 | 0.75 | 20421018 | 100861 | 11 | 1 | 1200 | 2020/10/24 03:03:23 | 0 |
7 | RTAD2020000634 | TAD | 1 | 1650 | 144635479 | 20201024 | 20201119 | 27 | 0.75 | 20451012 | 213017 | 88 | 2 | 1200 | 2020/10/24 03:03:23 | 0 |
8 | RTPA2020000506 | TPA | 1 | 1655 | 115145545 | 20201024 | 20201119 | 27 | 0.75 | 20531005 | 195960 | 4 | 2 | 1200 | 2020/10/24 03:03:23 | 0 |
9 | RTAB2020000713 | TAB | 3 | 1689 | 144320904 | 20201024 | 20201119 | 27 | 0.75 | 20441005 | 202536 | 20 | 2 | 1200 | 2020/10/24 03:03:23 | 0 |
GUARNT_NO | PDUTY_BRCD | PDUTY_TEAM_CD | PDUTY_ENO | CUST_NO | ARCV_STRT_DY | ARCV_TERM_DY | ADV_RCV_DCNT | ADV_RCV_TARIF | GUARNT_TERM_DY | BBNK_GIRO_CD | BBNK_ORG_CD | PNSN_PAYFORM_CD | REG_ENO | REG_TS | INC_RATE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
990 | RTHO2009000059 | THO | 1 | 1917 | 75215560 | 20201024 | 20201029 | 6 | 0.5 | 20310715 | 115665 | 11 | 2 | 1200 | 2020/10/24 03:01:05 | 0 |
991 | RQAD2010000128 | TAD | 1 | 1656 | 78579452 | 20201024 | 20201118 | 26 | 0.5 | 20320401 | 263067 | 88 | 2 | 1200 | 2020/10/24 03:01:05 | 0 |
992 | RQAD2010000127 | QAD | 1 | 1977 | 74259064 | 20201024 | 20201112 | 20 | 0.5 | 20480401 | 68796 | 4 | 1 | 1200 | 2020/10/24 03:01:05 | 0 |
993 | RTHA2010000065 | TAA | 1 | 1799 | 77577060 | 20201024 | 20201119 | 27 | 0.5 | 20280331 | 812191 | 81 | 1 | 1200 | 2020/10/24 03:01:05 | 0 |
994 | RTHA2010000051 | TAA | 1 | 1799 | 78399412 | 20201024 | 20201104 | 12 | 0.5 | 20320319 | 115869 | 11 | 2 | 1200 | 2020/10/24 03:01:05 | 0 |
995 | RQAD2010000059 | TAD | 1 | 1650 | 2444402 | 20201024 | 20201122 | 30 | 0.5 | 20480204 | 40701 | 4 | 1 | 1200 | 2020/10/24 03:01:05 | 0 |
996 | RTHO2010000002 | THO | 1 | 1917 | 77758931 | 20201024 | 20201119 | 27 | 0.5 | 20370107 | 69009 | 4 | 1 | 1200 | 2020/10/24 03:01:05 | 0 |
997 | RTHO2010000001 | THO | 1 | 1917 | 24790422 | 20201024 | 20201027 | 4 | 0.5 | 20440105 | 268224 | 88 | 1 | 1200 | 2020/10/24 03:01:05 | 0 |
998 | RQAD2009000521 | TAB | 3 | 1689 | 77488298 | 20201024 | 20201110 | 18 | 0.5 | 20331202 | 65207 | 4 | 1 | 1200 | 2020/10/24 03:01:05 | 0 |
999 | RQAD2009000528 | TAC | 3 | 1554 | 77112687 | 20201024 | 20201119 | 27 | 0.5 | 20401209 | 842200 | 20 | 2 | 1200 | 2020/10/24 03:01:06 | 0 |