Loan Default Dataset

Loan Default Classification Problem

@kaggle.yasserh_loan_default_dataset

Table List

1 table(3.58 MB)

Loan Default

@kaggle.yasserh_loan_default_dataset.loan_default

3.58 MB
148670 rows
34 columns

id ID	year Year	loan_limit Loan Limit	gender Gender	approv_in_adv Approv In Adv	loan_type Loan Type	loan_purpose Loan Purpose	credit_worthiness Credit Worthiness	open_credit Open Credit	business_or_commercial Business Or Commercial	loan_amount Loan Amount	rate_of_interest Rate Of Interest	interest_rate_spread Interest Rate Spread	upfront_charges Upfront Charges	term Term	neg_ammortization Neg Ammortization	interest_only Interest Only	lump_sum_payment Lump Sum Payment	property_value Property Value	construction_type Construction Type	occupancy_type Occupancy Type	secured_by Secured By	total_units Total Units	income Income	credit_type Credit Type	credit_score Credit Score	co_applicant_credit_type Co-applicant Credit Type	age Age	submission_of_application Submission Of Application	ltv LTV	region Region	security_type Security Type	status Status	dtir1 Dtir1
24890	2019	cf	Sex Not Available	nopre	type1	p1	l1	nopc	nob/c	116500				360	not_neg	not_int	not_lpsm	118000	sb	pr	home	1U	1740	EXP	758	CIB	25-34	to_inst	98.72881356	south	direct	1	45
24891	2019	cf	Male	nopre	type2	p1	l1	nopc	b/c	206500				360	not_neg	not_int	lpsm		sb	pr	home	1U	4980	EQUI	552	EXP	55-64	to_inst		North	direct	1
24892	2019	cf	Male	pre	type1	p1	l1	nopc	nob/c	406500	4.56	0.2	595	360	neg_amm	not_int	not_lpsm	508000	sb	pr	home	1U	9480	EXP	834	CIB	35-44	to_inst	80.01968504	south	direct		46
24893	2019	cf	Male	nopre	type1	p4	l1	nopc	nob/c	456500	4.25	0.681		360	not_neg	not_int	not_lpsm	658000	sb	pr	home	1U	11880	EXP	587	CIB	45-54	not_inst	69.3768997	North	direct		42
24894	2019	cf	Joint	pre	type1	p1	l1	nopc	nob/c	696500	4	0.3042		360	not_neg	not_int	not_lpsm	758000	sb	pr	home	1U	10440	CRIF	602	EXP	25-34	not_inst	91.88654354	North	direct		39
24895	2019	cf	Joint	pre	type1	p1	l1	nopc	nob/c	706500	3.99	0.1523	370	360	not_neg	not_int	not_lpsm	1008000	sb	pr	home	1U	10080	EXP	864	EXP	35-44	not_inst	70.08928571	North	direct		40
24896	2019	cf	Joint	pre	type1	p3	l1	nopc	nob/c	346500	4.5	0.9998	5120	360	not_neg	not_int	not_lpsm	438000	sb	pr	home	1U	5040	EXP	860	EXP	55-64	to_inst	79.10958904	North	direct		44
24897	2019	nan	Female	nopre	type1	p4	l1	nopc	nob/c	266500	4.125	0.2975	5609.88	360	not_neg	not_int	not_lpsm	308000	sb	pr	home	1U	3780	CIB	863	CIB	55-64	to_inst	86.52597403	North	direct		42
24898	2019	cf	Joint	nopre	type1	p3	l1	nopc	nob/c	376500	4.875	0.7395	1150	360	not_neg	not_int	not_lpsm	478000	sb	pr	home	1U	5580	CIB	580	EXP	55-64	to_inst	78.76569038	central	direct		44
24899	2019	cf	Sex Not Available	nopre	type3	p3	l1	nopc	nob/c	436500	3.49	-0.2776	2316.5	360	not_neg	not_int	not_lpsm	688000	sb	pr	home	1U	6720	CIB	788	EXP	55-64	to_inst	63.44476744	south	direct		30


CREATE TABLE loan_default (
  "id" BIGINT,
  "year" BIGINT,
  "loan_limit" VARCHAR,
  "gender" VARCHAR,
  "approv_in_adv" VARCHAR,
  "loan_type" VARCHAR,
  "loan_purpose" VARCHAR,
  "credit_worthiness" VARCHAR,
  "open_credit" VARCHAR,
  "business_or_commercial" VARCHAR,
  "loan_amount" BIGINT,
  "rate_of_interest" DOUBLE,
  "interest_rate_spread" DOUBLE,
  "upfront_charges" DOUBLE,
  "term" DOUBLE,
  "neg_ammortization" VARCHAR,
  "interest_only" VARCHAR,
  "lump_sum_payment" VARCHAR,
  "property_value" DOUBLE,
  "construction_type" VARCHAR,
  "occupancy_type" VARCHAR,
  "secured_by" VARCHAR,
  "total_units" VARCHAR,
  "income" DOUBLE,
  "credit_type" VARCHAR,
  "credit_score" BIGINT,
  "co_applicant_credit_type" VARCHAR,
  "age" VARCHAR,
  "submission_of_application" VARCHAR,
  "ltv" DOUBLE,
  "region" VARCHAR,
  "security_type" VARCHAR,
  "status" BIGINT,
  "dtir1" DOUBLE
);