Finance Loan Approval Prediction Data
Home Loan Approval Prediction Data
@kaggle.krishnaraj30_finance_loan_approval_prediction_data
Home Loan Approval Prediction Data
@kaggle.krishnaraj30_finance_loan_approval_prediction_data
Finance company deals in all loans. The customer first applies for a home loan after that company validates the customer's eligibility for a loan.
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 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 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.