Loan Prepayment Dataset

Unlocking Financial Freedom: Analyzing Loan Prepayment Patterns

@kaggle.nikunjhemani_loan_prepayment_dataset

Table List

1 table(2.29 MB)

Preprocessed Data Improved

@kaggle.nikunjhemani_loan_prepayment_dataset.preprocessed_data_improved

2.29 MB
148938 rows
30 columns

unnamed_0 Unnamed: 0	creditscore CreditScore	firsttimehomebuyer FirstTimeHomebuyer	msa MSA	mip MIP	units Units	occupancy Occupancy	ocltv OCLTV	dti DTI	origupb OrigUPB	ltv LTV	originterestrate OrigInterestRate	channel Channel	propertystate PropertyState	propertytype PropertyType	loanpurpose LoanPurpose	origloanterm OrigLoanTerm	numborrowers NumBorrowers	sellername SellerName	servicername ServicerName	everdelinquent EverDelinquent	monthsdelinquent MonthsDelinquent	monthsinrepayment MonthsInRepayment	firstpayment_year FirstPayment Year	firstpayment_month FirstPayment Month	parsed_firstpaymentdate Parsed FirstPaymentDate	maturity_year Maturity Year	maturity_month Maturity Month	parsed_maturitydate Parsed MaturityDate
	670.5336708312466		16974	25	1	O	89	27	117000	89	6.75	T	Midwest	SF	P	360	2	FL	Major Banks			52	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
1	670.5336708312466		19740		1	O	73	17	109000	73	6.5	R	Others	SF	N	360	1	FT	Non-Bank Servicers			144	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
2	670.5336708312466		29940		1	O	75	16	88000	75	6.875	T	Others	SF	N	360	2	FL	Major Banks			67	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
3	670.5336708312466		31084		1	O	76	14	160000	76	6.875	R	West Coast	SF	N	360	2	GM	Major Banks			35	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
4	670.5336708312466		35644		1	O	78	18	109000	78	7.125	R	Northeast	SF	N	360	2	GM	Major Banks			54	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
5	670.5336708312466		30660	25	1	O	89	40	207000	89	7.125	T	Others	SF	N	360	2	Ot	Other Servicers			42	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
6	670.5336708312466		30660	25	1	O	90	21	111000	90	6.875	T	Midwest	SF	P	360	1	RE	Other Servicers			44	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
7	670.5336708312466		36740		1	O	72	20	97000	72	6.75	R	South	SF	N	360	1	NO	Major Banks	1	3	145	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)
8	670.5336708312466	1	25540	30	1	O	95	38	55000	95	7	R	Northeast	SF	P	345	1	Ot	Other Servicers			64	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2027	10	Fri Oct 01 2027 00:00:00 GMT+0000 (Coordinated Universal Time)
9	670.5336708312466	1	48620	30	1	O	95	27	35000	95	7.125	T	Others	SF	P	360	1	Ot	Major Banks	1	104	212	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE preprocessed_data_improved (
  "unnamed_0" BIGINT,
  "creditscore" DOUBLE,
  "firsttimehomebuyer" BIGINT,
  "msa" BIGINT,
  "mip" BIGINT,
  "units" BIGINT,
  "occupancy" VARCHAR,
  "ocltv" BIGINT,
  "dti" DOUBLE,
  "origupb" BIGINT,
  "ltv" DOUBLE,
  "originterestrate" DOUBLE,
  "channel" VARCHAR,
  "ppm" BIGINT,
  "propertystate" VARCHAR,
  "propertytype" VARCHAR,
  "loanpurpose" VARCHAR,
  "origloanterm" DOUBLE,
  "numborrowers" BIGINT,
  "sellername" VARCHAR,
  "servicername" VARCHAR,
  "everdelinquent" DOUBLE,
  "monthsdelinquent" DOUBLE,
  "monthsinrepayment" DOUBLE,
  "firstpayment_year" BIGINT,
  "firstpayment_month" VARCHAR,
  "parsed_firstpaymentdate" TIMESTAMP,
  "maturity_year" BIGINT,
  "maturity_month" BIGINT,
  "parsed_maturitydate" TIMESTAMP
);