Overview

Dataset statistics

Number of variables39
Number of observations1000
Missing cells5000
Missing cells (%)12.8%
Duplicate rows49
Duplicate rows (%)4.9%
Total size in memory339.0 KiB
Average record size in memory347.1 B

Variable types

Categorical18
Numeric15
Boolean1
Unsupported5

Dataset

Description한국주택금융공사 유동화자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터)
Author한국주택금융공사
URLhttps://www.data.go.kr/data/15072809/fileData.do

Alerts

TREAT_ORG_CD has constant value ""Constant
BHOUR_LOAN_RAMT has constant value ""Constant
REPAY_AMT has constant value ""Constant
DDELAY_FEE_AMT has constant value ""Constant
PRNINTEVEN_AMT has constant value ""Constant
CRDELAY_FEE_AMT has constant value ""Constant
AREPAY_INT_AMT has constant value ""Constant
EOUT_INT_AMT has constant value ""Constant
PDELAY_FEE_AMT has constant value ""Constant
DPRMS_INT_AMT has constant value ""Constant
PRCSS_YN has constant value ""Constant
NTRD_APPLY_DY has constant value ""Constant
RDUAPRNINT_DCNT has constant value ""Constant
HREPAY_AMT has constant value ""Constant
HREPAY_INT_AMT has constant value ""Constant
HREPAY_FEE_AMT has constant value ""Constant
Dataset has 49 (4.9%) duplicate rowsDuplicates
CNVNC_REPAY_YN is highly imbalanced (91.4%)Imbalance
REPURCH_CMPLT_YN has 1000 (100.0%) missing valuesMissing
PDLAST_APPLY_DY has 1000 (100.0%) missing valuesMissing
RDUALAST_STRT_DY has 1000 (100.0%) missing valuesMissing
RDLAST_APPLY_DY has 1000 (100.0%) missing valuesMissing
RDUALAST_APPLY_DY has 1000 (100.0%) missing valuesMissing
APAY_USE_DCNT is highly skewed (γ1 = 20.37472082)Skewed
REPURCH_CMPLT_YN is an unsupported type, check if it needs cleaning or further analysisUnsupported
PDLAST_APPLY_DY is an unsupported type, check if it needs cleaning or further analysisUnsupported
RDUALAST_STRT_DY is an unsupported type, check if it needs cleaning or further analysisUnsupported
RDLAST_APPLY_DY is an unsupported type, check if it needs cleaning or further analysisUnsupported
RDUALAST_APPLY_DY is an unsupported type, check if it needs cleaning or further analysisUnsupported
LOAN_RAMT has 18 (1.8%) zerosZeros
DEMND_AMT has 18 (1.8%) zerosZeros
DEMND_INT_AMT has 18 (1.8%) zerosZeros
CLLCT_AMT has 18 (1.8%) zerosZeros
CLLCT_INT_AMT has 18 (1.8%) zerosZeros
CDELAY_FEE_AMT has 845 (84.5%) zerosZeros
AREPAY_AMT has 679 (67.9%) zerosZeros
DELAY_AMT has 769 (76.9%) zerosZeros
DELAY_DCNT has 769 (76.9%) zerosZeros
APAY_USE_DCNT has 995 (99.5%) zerosZeros
APAY_OCCR_DCNT has 785 (78.5%) zerosZeros

Reproduction

Analysis started2023-12-12 23:26:47.053773
Analysis finished2023-12-12 23:26:47.381331
Duration0.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

LIQD_PLAN_CD
Categorical

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
KOMOCO2002S-02
704 
KOMOCO2003S-01
296 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKOMOCO2003S-01
2nd rowKOMOCO2003S-01
3rd rowKOMOCO2003S-01
4th rowKOMOCO2003S-01
5th rowKOMOCO2003S-01

Common Values

ValueCountFrequency (%)
KOMOCO2002S-02 704
70.4%
KOMOCO2003S-01 296
29.6%

Length

2023-12-13T08:26:47.439736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:47.538939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
komoco2002s-02 704
70.4%
komoco2003s-01 296
29.6%

HOLD_CD
Categorical

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
B004-2002-0001
704 
B004-2003-0001
296 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowB004-2003-0001
2nd rowB004-2003-0001
3rd rowB004-2003-0001
4th rowB004-2003-0001
5th rowB004-2003-0001

Common Values

ValueCountFrequency (%)
B004-2002-0001 704
70.4%
B004-2003-0001 296
29.6%

Length

2023-12-13T08:26:47.676193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:47.755617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
b004-2002-0001 704
70.4%
b004-2003-0001 296
29.6%

PAY_SEQ
Real number (ℝ)

Distinct47
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean120.669
Minimum97
Maximum159
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:47.876882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum97
5-th percentile99
Q1110
median118.5
Q3131
95-th percentile145
Maximum159
Range62
Interquartile range (IQR)21

Descriptive statistics

Standard deviation14.214059
Coefficient of variation (CV)0.11779379
Kurtosis0.14843275
Mean120.669
Median Absolute Deviation (MAD)11.5
Skewness0.5552887
Sum120669
Variance202.03948
MonotonicityNot monotonic
2023-12-13T08:26:47.998348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
132 93
 
9.3%
118 83
 
8.3%
131 75
 
7.5%
110 74
 
7.4%
117 62
 
6.2%
126 58
 
5.8%
104 50
 
5.0%
111 50
 
5.0%
105 41
 
4.1%
121 39
 
3.9%
Other values (37) 375
37.5%
ValueCountFrequency (%)
97 10
 
1.0%
98 30
3.0%
99 27
2.7%
100 3
 
0.3%
102 5
 
0.5%
103 4
 
0.4%
104 50
5.0%
105 41
4.1%
106 34
3.4%
107 11
 
1.1%
ValueCountFrequency (%)
159 35
3.5%
158 2
 
0.2%
145 17
1.7%
144 12
 
1.2%
143 13
 
1.3%
142 4
 
0.4%
141 20
2.0%
140 1
 
0.1%
139 1
 
0.1%
135 1
 
0.1%

TREAT_ORG_CD
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
B004
1000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowB004
2nd rowB004
3rd rowB004
4th rowB004
5th rowB004

Common Values

ValueCountFrequency (%)
B004 1000
100.0%

Length

2023-12-13T08:26:48.145171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:48.239409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
b004 1000
100.0%

BHOUR_LOAN_RAMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:48.326273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:48.403432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

REPAY_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:48.486551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:48.587249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

LOAN_RAMT
Real number (ℝ)

ZEROS 

Distinct328
Distinct (%)32.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10435294
Minimum0
Maximum11441110
Zeros18
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:48.707138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile8030190
Q110622002
median10889980
Q311095758
95-th percentile11242090
Maximum11441110
Range11441110
Interquartile range (IQR)473755

Descriptive statistics

Standard deviation1753620.3
Coefficient of variation (CV)0.16804704
Kurtosis22.551721
Mean10435294
Median Absolute Deviation (MAD)244290
Skewness-4.5991656
Sum1.0435294 × 1010
Variance3.0751841 × 1012
MonotonicityNot monotonic
2023-12-13T08:26:48.855982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 18
 
1.8%
10781490 17
 
1.7%
10646550 16
 
1.6%
11078280 14
 
1.4%
10889980 14
 
1.4%
10954750 13
 
1.3%
10217330 13
 
1.3%
11172460 12
 
1.2%
11242090 12
 
1.2%
10229380 11
 
1.1%
Other values (318) 860
86.0%
ValueCountFrequency (%)
0 18
1.8%
1956060 1
 
0.1%
3400280 3
 
0.3%
4401910 7
 
0.7%
5189650 1
 
0.1%
5443780 3
 
0.3%
5514760 1
 
0.1%
6724780 1
 
0.1%
8023550 2
 
0.2%
8028920 7
 
0.7%
ValueCountFrequency (%)
11441110 1
 
0.1%
11284020 4
0.4%
11274270 7
0.7%
11272150 1
 
0.1%
11263080 1
 
0.1%
11260570 9
0.9%
11250490 1
 
0.1%
11248970 8
0.8%
11248910 1
 
0.1%
11248860 2
 
0.2%

DEMND_AMT
Real number (ℝ)

ZEROS 

Distinct367
Distinct (%)36.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30973.27
Minimum0
Maximum78570
Zeros18
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:48.986621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile13346.5
Q126700
median31210
Q337210
95-th percentile45370
Maximum78570
Range78570
Interquartile range (IQR)10510

Descriptive statistics

Standard deviation9082.9762
Coefficient of variation (CV)0.29325209
Kurtosis3.8138582
Mean30973.27
Median Absolute Deviation (MAD)4840
Skewness-1.0235946
Sum30973270
Variance82500456
MonotonicityNot monotonic
2023-12-13T08:26:49.136282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
31210 32
 
3.2%
28110 25
 
2.5%
37740 23
 
2.3%
0 18
 
1.8%
37730 17
 
1.7%
37230 16
 
1.6%
37220 16
 
1.6%
32500 16
 
1.6%
26360 15
 
1.5%
34760 15
 
1.5%
Other values (357) 807
80.7%
ValueCountFrequency (%)
0 18
1.8%
520 1
 
0.1%
540 1
 
0.1%
1330 1
 
0.1%
1400 1
 
0.1%
1430 1
 
0.1%
1720 2
 
0.2%
1820 1
 
0.1%
1880 1
 
0.1%
1940 1
 
0.1%
ValueCountFrequency (%)
78570 1
 
0.1%
66880 1
 
0.1%
46780 1
 
0.1%
46760 1
 
0.1%
46740 2
 
0.2%
46730 1
 
0.1%
46720 2
 
0.2%
46710 2
 
0.2%
46670 1
 
0.1%
46630 5
0.5%

DEMND_INT_AMT
Real number (ℝ)

ZEROS 

Distinct371
Distinct (%)37.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean69717.46
Minimum0
Maximum76360
Zeros18
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:49.295997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile53850
Q171077.5
median72810
Q374160
95-th percentile75160.5
Maximum76360
Range76360
Interquartile range (IQR)3082.5

Descriptive statistics

Standard deviation11717.923
Coefficient of variation (CV)0.16807731
Kurtosis22.573272
Mean69717.46
Median Absolute Deviation (MAD)1600
Skewness-4.5701673
Sum69717460
Variance1.3730972 × 108
MonotonicityNot monotonic
2023-12-13T08:26:49.427788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
73220 25
 
2.5%
71060 22
 
2.2%
74160 20
 
2.0%
0 18
 
1.8%
71050 17
 
1.7%
75260 17
 
1.7%
74750 17
 
1.7%
74050 14
 
1.4%
74770 13
 
1.3%
72370 13
 
1.3%
Other values (361) 824
82.4%
ValueCountFrequency (%)
0 18
1.8%
6620 1
 
0.1%
13070 1
 
0.1%
25390 1
 
0.1%
28590 1
 
0.1%
29360 1
 
0.1%
29630 1
 
0.1%
30690 1
 
0.1%
33750 1
 
0.1%
34750 1
 
0.1%
ValueCountFrequency (%)
76360 1
 
0.1%
75600 1
 
0.1%
75540 1
 
0.1%
75480 1
 
0.1%
75390 1
 
0.1%
75370 1
 
0.1%
75330 3
0.3%
75320 5
0.5%
75280 3
0.3%
75270 3
0.3%

DDELAY_FEE_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:49.549482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:49.864904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

PRNINTEVEN_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:49.950607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:50.022804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

RECKON_DY
Real number (ℝ)

Distinct20
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20051017
Minimum20051004
Maximum20051031
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:50.091594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20051004
5-th percentile20051004
Q120051010
median20051019
Q320051024
95-th percentile20051031
Maximum20051031
Range27
Interquartile range (IQR)14

Descriptive statistics

Standard deviation8.6686516
Coefficient of variation (CV)4.3232977 × 10-7
Kurtosis-1.303804
Mean20051017
Median Absolute Deviation (MAD)8
Skewness-0.008593779
Sum2.0051017 × 1010
Variance75.145521
MonotonicityNot monotonic
2023-12-13T08:26:50.190364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
20051024 91
 
9.1%
20051031 86
 
8.6%
20051010 80
 
8.0%
20051004 79
 
7.9%
20051020 68
 
6.8%
20051005 59
 
5.9%
20051007 56
 
5.6%
20051021 52
 
5.2%
20051011 52
 
5.2%
20051027 50
 
5.0%
Other values (10) 327
32.7%
ValueCountFrequency (%)
20051004 79
7.9%
20051005 59
5.9%
20051006 24
 
2.4%
20051007 56
5.6%
20051010 80
8.0%
20051011 52
5.2%
20051012 38
3.8%
20051013 33
3.3%
20051014 28
 
2.8%
20051017 29
 
2.9%
ValueCountFrequency (%)
20051031 86
8.6%
20051028 27
 
2.7%
20051027 50
5.0%
20051026 42
4.2%
20051025 40
4.0%
20051024 91
9.1%
20051021 52
5.2%
20051020 68
6.8%
20051019 48
4.8%
20051018 18
 
1.8%

PAY_DY
Real number (ℝ)

Distinct20
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20051017
Minimum20051004
Maximum20051031
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:50.283423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20051004
5-th percentile20051004
Q120051010
median20051019
Q320051024
95-th percentile20051031
Maximum20051031
Range27
Interquartile range (IQR)14

Descriptive statistics

Standard deviation8.6686516
Coefficient of variation (CV)4.3232977 × 10-7
Kurtosis-1.303804
Mean20051017
Median Absolute Deviation (MAD)8
Skewness-0.008593779
Sum2.0051017 × 1010
Variance75.145521
MonotonicityNot monotonic
2023-12-13T08:26:50.383502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
20051024 91
 
9.1%
20051031 86
 
8.6%
20051010 80
 
8.0%
20051004 79
 
7.9%
20051020 68
 
6.8%
20051005 59
 
5.9%
20051007 56
 
5.6%
20051021 52
 
5.2%
20051011 52
 
5.2%
20051027 50
 
5.0%
Other values (10) 327
32.7%
ValueCountFrequency (%)
20051004 79
7.9%
20051005 59
5.9%
20051006 24
 
2.4%
20051007 56
5.6%
20051010 80
8.0%
20051011 52
5.2%
20051012 38
3.8%
20051013 33
3.3%
20051014 28
 
2.8%
20051017 29
 
2.9%
ValueCountFrequency (%)
20051031 86
8.6%
20051028 27
 
2.7%
20051027 50
5.0%
20051026 42
4.2%
20051025 40
4.0%
20051024 91
9.1%
20051021 52
5.2%
20051020 68
6.8%
20051019 48
4.8%
20051018 18
 
1.8%

CLLCT_AMT
Real number (ℝ)

ZEROS 

Distinct367
Distinct (%)36.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30973.27
Minimum0
Maximum78570
Zeros18
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:50.507411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile13346.5
Q126700
median31210
Q337210
95-th percentile45370
Maximum78570
Range78570
Interquartile range (IQR)10510

Descriptive statistics

Standard deviation9082.9762
Coefficient of variation (CV)0.29325209
Kurtosis3.8138582
Mean30973.27
Median Absolute Deviation (MAD)4840
Skewness-1.0235946
Sum30973270
Variance82500456
MonotonicityNot monotonic
2023-12-13T08:26:50.630496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
31210 32
 
3.2%
28110 25
 
2.5%
37740 23
 
2.3%
0 18
 
1.8%
37730 17
 
1.7%
37230 16
 
1.6%
37220 16
 
1.6%
32500 16
 
1.6%
26360 15
 
1.5%
34760 15
 
1.5%
Other values (357) 807
80.7%
ValueCountFrequency (%)
0 18
1.8%
520 1
 
0.1%
540 1
 
0.1%
1330 1
 
0.1%
1400 1
 
0.1%
1430 1
 
0.1%
1720 2
 
0.2%
1820 1
 
0.1%
1880 1
 
0.1%
1940 1
 
0.1%
ValueCountFrequency (%)
78570 1
 
0.1%
66880 1
 
0.1%
46780 1
 
0.1%
46760 1
 
0.1%
46740 2
 
0.2%
46730 1
 
0.1%
46720 2
 
0.2%
46710 2
 
0.2%
46670 1
 
0.1%
46630 5
0.5%

CLLCT_INT_AMT
Real number (ℝ)

ZEROS 

Distinct371
Distinct (%)37.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean69717.46
Minimum0
Maximum76360
Zeros18
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:50.746460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile53850
Q171077.5
median72810
Q374160
95-th percentile75160.5
Maximum76360
Range76360
Interquartile range (IQR)3082.5

Descriptive statistics

Standard deviation11717.923
Coefficient of variation (CV)0.16807731
Kurtosis22.573272
Mean69717.46
Median Absolute Deviation (MAD)1600
Skewness-4.5701673
Sum69717460
Variance1.3730972 × 108
MonotonicityNot monotonic
2023-12-13T08:26:50.871114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
73220 25
 
2.5%
71060 22
 
2.2%
74160 20
 
2.0%
0 18
 
1.8%
71050 17
 
1.7%
75260 17
 
1.7%
74750 17
 
1.7%
74050 14
 
1.4%
74770 13
 
1.3%
72370 13
 
1.3%
Other values (361) 824
82.4%
ValueCountFrequency (%)
0 18
1.8%
6620 1
 
0.1%
13070 1
 
0.1%
25390 1
 
0.1%
28590 1
 
0.1%
29360 1
 
0.1%
29630 1
 
0.1%
30690 1
 
0.1%
33750 1
 
0.1%
34750 1
 
0.1%
ValueCountFrequency (%)
76360 1
 
0.1%
75600 1
 
0.1%
75540 1
 
0.1%
75480 1
 
0.1%
75390 1
 
0.1%
75370 1
 
0.1%
75330 3
0.3%
75320 5
0.5%
75280 3
0.3%
75270 3
0.3%

CDELAY_FEE_AMT
Real number (ℝ)

ZEROS 

Distinct124
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean117.839
Minimum0
Maximum10764
Zeros845
Zeros (%)84.5%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:51.023831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile686.35
Maximum10764
Range10764
Interquartile range (IQR)0

Descriptive statistics

Standard deviation576.13465
Coefficient of variation (CV)4.8891678
Kurtosis196.52791
Mean117.839
Median Absolute Deviation (MAD)0
Skewness12.30456
Sum117839
Variance331931.13
MonotonicityNot monotonic
2023-12-13T08:26:51.165666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 845
84.5%
47 5
 
0.5%
46 4
 
0.4%
179 4
 
0.4%
95 4
 
0.4%
228 3
 
0.3%
136 2
 
0.2%
1367 2
 
0.2%
190 2
 
0.2%
674 2
 
0.2%
Other values (114) 127
 
12.7%
ValueCountFrequency (%)
0 845
84.5%
43 1
 
0.1%
45 1
 
0.1%
46 4
 
0.4%
47 5
 
0.5%
68 1
 
0.1%
77 1
 
0.1%
86 1
 
0.1%
88 2
 
0.2%
92 1
 
0.1%
ValueCountFrequency (%)
10764 1
0.1%
9582 1
0.1%
4515 1
0.1%
4192 1
0.1%
3103 1
0.1%
2953 1
0.1%
2871 1
0.1%
2719 1
0.1%
1866 1
0.1%
1863 1
0.1%

CRDELAY_FEE_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:51.292324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:51.362098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

AREPAY_AMT
Real number (ℝ)

ZEROS 

Distinct93
Distinct (%)9.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean148.52
Minimum0
Maximum990
Zeros679
Zeros (%)67.9%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:51.452167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q3200
95-th percentile870
Maximum990
Range990
Interquartile range (IQR)200

Descriptive statistics

Standard deviation273.89383
Coefficient of variation (CV)1.8441545
Kurtosis2.0445411
Mean148.52
Median Absolute Deviation (MAD)0
Skewness1.808033
Sum148520
Variance75017.827
MonotonicityNot monotonic
2023-12-13T08:26:51.569518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 679
67.9%
230 16
 
1.6%
980 13
 
1.3%
20 9
 
0.9%
500 9
 
0.9%
420 8
 
0.8%
240 7
 
0.7%
790 7
 
0.7%
160 7
 
0.7%
540 6
 
0.6%
Other values (83) 239
 
23.9%
ValueCountFrequency (%)
0 679
67.9%
10 4
 
0.4%
20 9
 
0.9%
30 1
 
0.1%
40 5
 
0.5%
60 4
 
0.4%
70 3
 
0.3%
80 3
 
0.3%
90 5
 
0.5%
100 2
 
0.2%
ValueCountFrequency (%)
990 3
 
0.3%
980 13
1.3%
970 3
 
0.3%
960 4
 
0.4%
950 3
 
0.3%
940 3
 
0.3%
930 5
 
0.5%
920 1
 
0.1%
910 6
0.6%
900 2
 
0.2%

AREPAY_INT_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:51.703237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:51.780689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

EOUT_INT_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:51.866793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:51.939716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

PDELAY_FEE_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:52.020989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:52.097601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

DELAY_AMT
Real number (ℝ)

ZEROS 

Distinct154
Distinct (%)15.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13369.26
Minimum0
Maximum62980
Zeros769
Zeros (%)76.9%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:52.185108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile59730
Maximum62980
Range62980
Interquartile range (IQR)0

Descriptive statistics

Standard deviation24486.282
Coefficient of variation (CV)1.8315361
Kurtosis-0.30297382
Mean13369.26
Median Absolute Deviation (MAD)0
Skewness1.2963239
Sum13369260
Variance5.99578 × 108
MonotonicityNot monotonic
2023-12-13T08:26:52.338274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 769
76.9%
58770 7
 
0.7%
58530 5
 
0.5%
59810 5
 
0.5%
58490 5
 
0.5%
57600 4
 
0.4%
59720 4
 
0.4%
57560 4
 
0.4%
59780 4
 
0.4%
58760 4
 
0.4%
Other values (144) 189
 
18.9%
ValueCountFrequency (%)
0 769
76.9%
22170 1
 
0.1%
29120 1
 
0.1%
42200 1
 
0.1%
45200 1
 
0.1%
47560 1
 
0.1%
47980 1
 
0.1%
48430 1
 
0.1%
49160 1
 
0.1%
49200 2
 
0.2%
ValueCountFrequency (%)
62980 1
0.1%
62960 2
0.2%
62790 1
0.1%
61540 1
0.1%
61510 1
0.1%
61470 1
0.1%
61460 1
0.1%
61450 1
0.1%
61230 1
0.1%
61220 1
0.1%

DPRMS_INT_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:52.462387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:52.541034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

DELAY_DCNT
Real number (ℝ)

ZEROS 

Distinct52
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.771
Minimum0
Maximum245
Zeros769
Zeros (%)76.9%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:52.645561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile21
Maximum245
Range245
Interquartile range (IQR)0

Descriptive statistics

Standard deviation13.964081
Coefficient of variation (CV)3.703018
Kurtosis148.39796
Mean3.771
Median Absolute Deviation (MAD)0
Skewness10.210847
Sum3771
Variance194.99555
MonotonicityNot monotonic
2023-12-13T08:26:52.767223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 769
76.9%
4 19
 
1.9%
3 19
 
1.9%
5 15
 
1.5%
1 15
 
1.5%
15 12
 
1.2%
6 12
 
1.2%
2 12
 
1.2%
7 10
 
1.0%
16 9
 
0.9%
Other values (42) 108
 
10.8%
ValueCountFrequency (%)
0 769
76.9%
1 15
 
1.5%
2 12
 
1.2%
3 19
 
1.9%
4 19
 
1.9%
5 15
 
1.5%
6 12
 
1.2%
7 10
 
1.0%
8 4
 
0.4%
9 6
 
0.6%
ValueCountFrequency (%)
245 1
0.1%
217 1
0.1%
98 1
0.1%
93 1
0.1%
72 1
0.1%
68 1
0.1%
67 1
0.1%
62 2
0.2%
60 1
0.1%
49 2
0.2%

APAY_USE_DCNT
Real number (ℝ)

SKEWED  ZEROS 

Distinct6
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.123
Minimum0
Maximum52
Zeros995
Zeros (%)99.5%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:52.863887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum52
Range52
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2.1355167
Coefficient of variation (CV)17.361924
Kurtosis444.07126
Mean0.123
Median Absolute Deviation (MAD)0
Skewness20.374721
Sum123
Variance4.5604314
MonotonicityNot monotonic
2023-12-13T08:26:52.948284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 995
99.5%
4 1
 
0.1%
11 1
 
0.1%
52 1
 
0.1%
37 1
 
0.1%
19 1
 
0.1%
ValueCountFrequency (%)
0 995
99.5%
4 1
 
0.1%
11 1
 
0.1%
19 1
 
0.1%
37 1
 
0.1%
52 1
 
0.1%
ValueCountFrequency (%)
52 1
 
0.1%
37 1
 
0.1%
19 1
 
0.1%
11 1
 
0.1%
4 1
 
0.1%
0 995
99.5%

APAY_OCCR_DCNT
Real number (ℝ)

ZEROS 

Distinct38
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.422
Minimum0
Maximum247
Zeros785
Zeros (%)78.5%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:53.051961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile16
Maximum247
Range247
Interquartile range (IQR)0

Descriptive statistics

Standard deviation18.881802
Coefficient of variation (CV)5.5177679
Kurtosis137.56957
Mean3.422
Median Absolute Deviation (MAD)0
Skewness11.122652
Sum3422
Variance356.52244
MonotonicityNot monotonic
2023-12-13T08:26:53.164325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
0 785
78.5%
1 33
 
3.3%
2 26
 
2.6%
3 26
 
2.6%
4 19
 
1.9%
6 12
 
1.2%
10 7
 
0.7%
5 7
 
0.7%
8 6
 
0.6%
18 6
 
0.6%
Other values (28) 73
 
7.3%
ValueCountFrequency (%)
0 785
78.5%
1 33
 
3.3%
2 26
 
2.6%
3 26
 
2.6%
4 19
 
1.9%
5 7
 
0.7%
6 12
 
1.2%
7 5
 
0.5%
8 6
 
0.6%
9 4
 
0.4%
ValueCountFrequency (%)
247 5
0.5%
76 3
0.3%
68 2
 
0.2%
52 2
 
0.2%
42 2
 
0.2%
39 1
 
0.1%
38 1
 
0.1%
34 1
 
0.1%
33 1
 
0.1%
30 1
 
0.1%

RMN_SEQ
Real number (ℝ)

Distinct47
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean119.331
Minimum81
Maximum143
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T08:26:53.280269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum81
5-th percentile95
Q1109
median121.5
Q3130
95-th percentile141
Maximum143
Range62
Interquartile range (IQR)21

Descriptive statistics

Standard deviation14.214059
Coefficient of variation (CV)0.11911456
Kurtosis0.14843275
Mean119.331
Median Absolute Deviation (MAD)11.5
Skewness-0.5552887
Sum119331
Variance202.03948
MonotonicityNot monotonic
2023-12-13T08:26:53.408465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
108 93
 
9.3%
122 83
 
8.3%
109 75
 
7.5%
130 74
 
7.4%
123 62
 
6.2%
114 58
 
5.8%
136 50
 
5.0%
129 50
 
5.0%
135 41
 
4.1%
119 39
 
3.9%
Other values (37) 375
37.5%
ValueCountFrequency (%)
81 35
3.5%
82 2
 
0.2%
95 17
1.7%
96 12
 
1.2%
97 13
 
1.3%
98 4
 
0.4%
99 20
2.0%
100 1
 
0.1%
101 1
 
0.1%
105 1
 
0.1%
ValueCountFrequency (%)
143 10
 
1.0%
142 30
3.0%
141 27
2.7%
140 3
 
0.3%
138 5
 
0.5%
137 4
 
0.4%
136 50
5.0%
135 41
4.1%
134 34
3.4%
133 11
 
1.1%

PRCSS_YN
Boolean

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
True
1000 
ValueCountFrequency (%)
True 1000
100.0%
2023-12-13T08:26:53.514564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

CNVNC_REPAY_YN
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
1
982 
0
 
17
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 982
98.2%
0 17
 
1.7%
2 1
 
0.1%

Length

2023-12-13T08:26:53.640344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:53.745358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 982
98.2%
0 17
 
1.7%
2 1
 
0.1%

REPURCH_CMPLT_YN
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1000
Missing (%)100.0%
Memory size8.9 KiB

NTRD_APPLY_DY
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
20051121
1000 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20051121
2nd row20051121
3rd row20051121
4th row20051121
5th row20051121

Common Values

ValueCountFrequency (%)
20051121 1000
100.0%

Length

2023-12-13T08:26:53.838378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:53.924024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20051121 1000
100.0%

PDLAST_APPLY_DY
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1000
Missing (%)100.0%
Memory size8.9 KiB

RDUALAST_STRT_DY
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1000
Missing (%)100.0%
Memory size8.9 KiB

RDLAST_APPLY_DY
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1000
Missing (%)100.0%
Memory size8.9 KiB

RDUALAST_APPLY_DY
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1000
Missing (%)100.0%
Memory size8.9 KiB

RDUAPRNINT_DCNT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:54.027701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:54.113033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

HREPAY_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:54.221868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:54.300588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

HREPAY_INT_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:54.397125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:54.768325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

HREPAY_FEE_AMT
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
0
1000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1000
100.0%

Length

2023-12-13T08:26:54.851264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:26:54.933718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1000
100.0%

Sample

LIQD_PLAN_CDHOLD_CDPAY_SEQTREAT_ORG_CDBHOUR_LOAN_RAMTREPAY_AMTLOAN_RAMTDEMND_AMTDEMND_INT_AMTDDELAY_FEE_AMTPRNINTEVEN_AMTRECKON_DYPAY_DYCLLCT_AMTCLLCT_INT_AMTCDELAY_FEE_AMTCRDELAY_FEE_AMTAREPAY_AMTAREPAY_INT_AMTEOUT_INT_AMTPDELAY_FEE_AMTDELAY_AMTDPRMS_INT_AMTDELAY_DCNTAPAY_USE_DCNTAPAY_OCCR_DCNTRMN_SEQPRCSS_YNCNVNC_REPAY_YNREPURCH_CMPLT_YNNTRD_APPLY_DYPDLAST_APPLY_DYRDUALAST_STRT_DYRDLAST_APPLY_DYRDUALAST_APPLY_DYRDUAPRNINT_DCNTHREPAY_AMTHREPAY_INT_AMTHREPAY_FEE_AMT
0KOMOCO2003S-01B004-2003-0001105B00400111448802637074690002005100720051007263707469000000000000135Y1<NA>20051121<NA><NA><NA><NA>0000
1KOMOCO2003S-01B004-2003-0001106B0040011144880269707448000200510312005103126970744800054000000007134Y1<NA>20051121<NA><NA><NA><NA>0000
2KOMOCO2003S-01B004-2003-0001106B00400111448702697074480002005102020051020269707448000530000000018134Y1<NA>20051121<NA><NA><NA><NA>0000
3KOMOCO2003S-01B004-2003-0001105B00400111760702635074680002005102020051020263507468057502300005756001300135Y1<NA>20051121<NA><NA><NA><NA>0000
4KOMOCO2003S-01B004-2003-0001105B0040011174050263707467000200510052005100526370746700043000000002135Y1<NA>20051121<NA><NA><NA><NA>0000
5KOMOCO2003S-01B004-2003-0001105B0040011174040263607467000200510052005100526360746700043000000002135Y1<NA>20051121<NA><NA><NA><NA>0000
6KOMOCO2003S-01B004-2003-0001107B0040011128250275207437000200510272005102727520743700090000000052133Y1<NA>20051121<NA><NA><NA><NA>0000
7KOMOCO2003S-01B004-2003-0001106B004001117246026910745500020051027200510272691074550000000000052134Y1<NA>20051121<NA><NA><NA><NA>0000
8KOMOCO2003S-01B004-2003-0001105B00400111724602636074670002005100720051007263607467000000000000135Y1<NA>20051121<NA><NA><NA><NA>0000
9KOMOCO2003S-01B004-2003-0001105B00400111724602636074660002005100720051007263607466000000000000135Y1<NA>20051121<NA><NA><NA><NA>0000
LIQD_PLAN_CDHOLD_CDPAY_SEQTREAT_ORG_CDBHOUR_LOAN_RAMTREPAY_AMTLOAN_RAMTDEMND_AMTDEMND_INT_AMTDDELAY_FEE_AMTPRNINTEVEN_AMTRECKON_DYPAY_DYCLLCT_AMTCLLCT_INT_AMTCDELAY_FEE_AMTCRDELAY_FEE_AMTAREPAY_AMTAREPAY_INT_AMTEOUT_INT_AMTPDELAY_FEE_AMTDELAY_AMTDPRMS_INT_AMTDELAY_DCNTAPAY_USE_DCNTAPAY_OCCR_DCNTRMN_SEQPRCSS_YNCNVNC_REPAY_YNREPURCH_CMPLT_YNNTRD_APPLY_DYPDLAST_APPLY_DYRDUALAST_STRT_DYRDLAST_APPLY_DYRDUALAST_APPLY_DYRDUAPRNINT_DCNTHREPAY_AMTHREPAY_INT_AMTHREPAY_FEE_AMT
990KOMOCO2002S-02B004-2002-0001121B00400108856703248072810002005101920051019324807281000000000000119Y1<NA>20051121<NA><NA><NA><NA>0000
991KOMOCO2002S-02B004-2002-0001121B00400108856703250072790002005100520051005325007279000240000000014119Y1<NA>20051121<NA><NA><NA><NA>0000
992KOMOCO2002S-02B004-2002-0001121B00400108992003249072870002005102620051026324907287032300000588200700119Y1<NA>20051121<NA><NA><NA><NA>0000
993KOMOCO2002S-02B004-2002-0001121B00400108992003249072800002005101920051019324907280000000000000119Y1<NA>20051121<NA><NA><NA><NA>0000
994KOMOCO2002S-02B004-2002-0001121B004001089920032470728800020051020200510203247072880460330000588200100119Y1<NA>20051121<NA><NA><NA><NA>0000
995KOMOCO2002S-02B004-2002-0001120B004001088470031720730900020051020200510203172073090505000005766003100120Y1<NA>20051121<NA><NA><NA><NA>0000
996KOMOCO2002S-02B004-2002-0001121B00400108847003244072880002005101920051019324407288000000000000119Y1<NA>20051121<NA><NA><NA><NA>0000
997KOMOCO2002S-02B004-2002-0001121B00400101765801157067920002005101920051019115706792000000000000119Y1<NA>20051121<NA><NA><NA><NA>0000
998KOMOCO2002S-02B004-2002-0001121B0040010884700325007278000200510132005101332500727800025000000006119Y1<NA>20051121<NA><NA><NA><NA>0000
999KOMOCO2002S-02B004-2002-0001121B0040010885680325007279000200510182005101832500727900024000000001119Y1<NA>20051121<NA><NA><NA><NA>0000

Duplicate rows

Most frequently occurring

LIQD_PLAN_CDHOLD_CDPAY_SEQTREAT_ORG_CDBHOUR_LOAN_RAMTREPAY_AMTLOAN_RAMTDEMND_AMTDEMND_INT_AMTDDELAY_FEE_AMTPRNINTEVEN_AMTRECKON_DYPAY_DYCLLCT_AMTCLLCT_INT_AMTCDELAY_FEE_AMTCRDELAY_FEE_AMTAREPAY_AMTAREPAY_INT_AMTEOUT_INT_AMTPDELAY_FEE_AMTDELAY_AMTDPRMS_INT_AMTDELAY_DCNTAPAY_USE_DCNTAPAY_OCCR_DCNTRMN_SEQPRCSS_YNCNVNC_REPAY_YNNTRD_APPLY_DYRDUAPRNINT_DCNTHREPAY_AMTHREPAY_INT_AMTHREPAY_FEE_AMT# duplicates
2KOMOCO2002S-02B004-2002-0001110B00400110966002811074160002005102120051021281107416000000000000130Y12005112100004
17KOMOCO2002S-02B004-2002-0001131B00400106465503722071230002005101920051019372207123000000000000109Y12005112100004
29KOMOCO2003S-01B004-2003-000198B00400112420902410075260002005100420051004241007526000000000000142Y12005112100004
36KOMOCO2003S-01B004-2003-0001104B00400111882802601074770002005100520051005260107477000000000000136Y12005112100004
38KOMOCO2003S-01B004-2003-0001104B00400111911602599074750002005102420051024259907475000000000000136Y12005112100004
8KOMOCO2002S-02B004-2002-0001121B00400108899803250072790002005102020051020325007279000000000000119Y12005112100003
18KOMOCO2002S-02B004-2002-0001131B0040010646550372307122000200510112005101137230712200029000000008109Y12005112100003
22KOMOCO2002S-02B004-2002-0001132B0040010618900377407105000200510242005102437740710500098000000004108Y12005112100003
24KOMOCO2002S-02B004-2002-0001141B0040010386220427806972000200510142005101442780697200000000000099Y02005112100003
25KOMOCO2002S-02B004-2002-0001145B0040010217330453706840000200510242005102445370684000000000000095Y12005112100003