LoanTap Data

Classification analysis

@kaggle.yekahaaagayeham_loantap_data

Table List

1 table(25.18 MB)

Loantapdata

@kaggle.yekahaaagayeham_loantap_data.loantapdata

25.18 MB
396030 rows
27 columns

loan_amnt Loan Amnt	term Term	int_rate Int Rate	installment Installment	grade Grade	sub_grade Sub Grade	emp_title Emp Title	emp_length Emp Length	home_ownership Home Ownership	annual_inc Annual Inc	verification_status Verification Status	issue_d Issue D	loan_status Loan Status	purpose Purpose	title Title	dti Dti	earliest_cr_line Earliest Cr Line	open_acc Open Acc	revol_bal Revol Bal	revol_util Revol Util	total_acc Total Acc	initial_list_status Initial List Status	application_type Application Type	mort_acc Mort Acc	address Address
10000	36 months	11.44	329.48	B	B4	Marketing	10+ years	RENT	117000	Not Verified	Jan-2015	Fully Paid	vacation	Vacation	26.24	Jun-1990	16	36369	41.8	25	w	INDIVIDUAL		0174 Michelle Gateway Mendozaberg, OK 22690
8000	36 months	11.99	265.68	B	B5	Credit analyst	4 years	MORTGAGE	65000	Not Verified	Jan-2015	Fully Paid	debt_consolidation	Debt consolidation	22.05	Jul-2004	17	20131	53.3	27	f	INDIVIDUAL	3	1076 Carney Fort Apt. 347 Loganmouth, SD 05113
15600	36 months	10.49	506.97	B	B3	Statistician	< 1 year	RENT	43057	Source Verified	Jan-2015	Fully Paid	credit_card	Credit card refinancing	12.79	Aug-2007	13	11987	92.2	26	f	INDIVIDUAL		87025 Mark Dale Apt. 269 New Sabrina, WV 05113
7200	36 months	6.49	220.65	A	A2	Client Advocate	6 years	RENT	54000	Not Verified	Nov-2014	Fully Paid	credit_card	Credit card refinancing	2.6	Sep-2006	6	5472	21.5	13	f	INDIVIDUAL		823 Reid Ford Delacruzside, MA 00813
24375	60 months	17.27	609.33	C	C5	Destiny Management Inc.	9 years	MORTGAGE	55000	Verified	Apr-2013	Charged Off	credit_card	Credit Card Refinance	33.95	Mar-1999	13	24584	69.8	43	f	INDIVIDUAL	1	679 Luna Roads Greggshire, VA 11650
20000	36 months	13.33	677.07	C	C3	HR Specialist	10+ years	MORTGAGE	86788	Verified	Sep-2015	Fully Paid	debt_consolidation	Debt consolidation	16.31	Jan-2005	8	25757	100.6	23	f	INDIVIDUAL	4	1726 Cooper Passage Suite 129 North Deniseberg, DE 30723
18000	36 months	5.32	542.07	A	A1	Software Development Engineer	2 years	MORTGAGE	125000	Source Verified	Sep-2015	Fully Paid	home_improvement	Home improvement	1.36	Aug-2005	8	4178	4.9	25	f	INDIVIDUAL	3	1008 Erika Vista Suite 748 East Stephanie, TX 22690
13000	36 months	11.14	426.47	B	B2	Office Depot	10+ years	RENT	46000	Not Verified	Sep-2012	Fully Paid	credit_card	No More Credit Cards	26.87	Sep-1994	11	13425	64.5	15	f	INDIVIDUAL		USCGC Nunez FPO AE 30723
18900	60 months	10.99	410.84	B	B3	Application Architect	10+ years	RENT	103000	Verified	Oct-2014	Fully Paid	debt_consolidation	Debt consolidation	12.52	Jun-1994	13	18637	32.9	40	w	INDIVIDUAL	3	USCGC Tran FPO AP 22690
26300	36 months	16.29	928.4	C	C5	Regado Biosciences	3 years	MORTGAGE	115000	Verified	Apr-2012	Fully Paid	debt_consolidation	Debt Consolidation	23.69	Dec-1997	13	22171	82.4	37	f	INDIVIDUAL	1	3390 Luis Rue Mauricestad, VA 00813


CREATE TABLE loantapdata (
  "loan_amnt" DOUBLE,
  "term" VARCHAR,
  "int_rate" DOUBLE,
  "installment" DOUBLE,
  "grade" VARCHAR,
  "sub_grade" VARCHAR,
  "emp_title" VARCHAR,
  "emp_length" VARCHAR,
  "home_ownership" VARCHAR,
  "annual_inc" DOUBLE,
  "verification_status" VARCHAR,
  "issue_d" VARCHAR,
  "loan_status" VARCHAR,
  "purpose" VARCHAR,
  "title" VARCHAR,
  "dti" DOUBLE,
  "earliest_cr_line" VARCHAR,
  "open_acc" DOUBLE,
  "pub_rec" DOUBLE,
  "revol_bal" DOUBLE,
  "revol_util" DOUBLE,
  "total_acc" DOUBLE,
  "initial_list_status" VARCHAR,
  "application_type" VARCHAR,
  "mort_acc" DOUBLE,
  "pub_rec_bankruptcies" DOUBLE,
  "address" VARCHAR
);