Loans Data

Lending Club Loans Data

@kaggle.sahilnbajaj_loans_data

Table List

1 table(224.85 KB)

Loan Data

@kaggle.sahilnbajaj_loans_data.loan_data

224.85 KB
9578 rows
14 columns

credit_policy Credit.policy	purpose Purpose	int_rate Int.rate	installment Installment	log_annual_inc Log.annual.inc	dti Dti	fico Fico	days_with_cr_line Days.with.cr.line	revol_bal Revol.bal	revol_util Revol.util	inq_last_6mths Inq.last.6mths	delinq_2yrs Delinq.2yrs	pub_rec Pub.rec	not_fully_paid Not.fully.paid
1	debt_consolidation	0.1189	829.1	11.35040654	19.48	737	5639.958333	28854	52.1
1	credit_card	0.1071	228.22	11.08214255	14.29	707	2760	33623	76.7
1	debt_consolidation	0.1357	366.86	10.37349118	11.63	682	4710	3511	25.6	1
1	debt_consolidation	0.1008	162.34	11.35040654	8.1	712	2699.958333	33667	73.2	1
1	credit_card	0.1426	102.92	11.29973224	14.97	667	4066	4740	39.5		1
1	credit_card	0.0788	125.13	11.90496755	16.98	727	6120.041667	50807	51
1	debt_consolidation	0.1496	194.02	10.71441777	4	667	3180.041667	3839	76.8			1	1
1	all_other	0.1114	131.22	11.00209984	11.08	722	5116	24220	68.6				1
1	home_improvement	0.1134	87.19	11.40756495	17.25	682	3989	69909	51.1	1
1	debt_consolidation	0.1221	84.12	10.20359214	10	707	2730.041667	5630	23	1


CREATE TABLE loan_data (
  "credit_policy" BIGINT,
  "purpose" VARCHAR,
  "int_rate" DOUBLE,
  "installment" DOUBLE,
  "log_annual_inc" DOUBLE,
  "dti" DOUBLE,
  "fico" BIGINT,
  "days_with_cr_line" DOUBLE,
  "revol_bal" BIGINT,
  "revol_util" DOUBLE,
  "inq_last_6mths" BIGINT,
  "delinq_2yrs" BIGINT,
  "pub_rec" BIGINT,
  "not_fully_paid" BIGINT
);