Home Loan Approval
Data Analytics Project
@kaggle.rishikeshkonapure_home_loan_approval
Data Analytics Project
@kaggle.rishikeshkonapure_home_loan_approval
Problem Statement:
About Company
Dream Housing Finance company deals in all home loans. They have a presence across all urban, semi-urban and rural areas. The customer first applies for a home loan after that company validates the customer's eligibility for a loan.
Problem
The company wants to automate the loan eligibility process (real-time) based on customer detail provided while filling out the online application form. These details are Gender, Marital Status, Education, Number of Dependents, Income, Loan Amount, Credit History and others. To automate this process, they have given a problem identifying the customer segments eligible for loan amounts to target these customers specifically. Here they have provided a partial data set.
Steps to Follow:
CREATE TABLE loan_sanction_test (
"loan_id" VARCHAR,
"gender" VARCHAR,
"married" VARCHAR,
"dependents" VARCHAR,
"education" VARCHAR,
"self_employed" VARCHAR,
"applicantincome" BIGINT,
"coapplicantincome" BIGINT,
"loanamount" DOUBLE,
"loan_amount_term" DOUBLE,
"credit_history" DOUBLE,
"property_area" VARCHAR
);CREATE TABLE loan_sanction_train (
"loan_id" VARCHAR,
"gender" VARCHAR,
"married" VARCHAR,
"dependents" VARCHAR,
"education" VARCHAR,
"self_employed" VARCHAR,
"applicantincome" BIGINT,
"coapplicantincome" DOUBLE,
"loanamount" DOUBLE,
"loan_amount_term" DOUBLE,
"credit_history" DOUBLE,
"property_area" VARCHAR,
"loan_status" VARCHAR
);Anyone who has the link will be able to view this.