Name: Loan Defaulter
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Loan Defaulter

This case study aims to give us an idea of applying EDA in a real business scenario. In this case study, apart from applying the techniques that we have learnt in the EDA module, we will also develop a basic understanding of risk analytics in banking and financial services and understand how data is used to minimise the risk of losing money while lending to customers.

Tables

Application Data

@kaggle.gauravduttakiit_loan_defaulter.application_data

24.19 MB
307511 rows
122 columns


CREATE TABLE application_data (
  "sk_id_curr" BIGINT,
  "target" BIGINT,
  "name_contract_type" VARCHAR,
  "code_gender" VARCHAR,
  "flag_own_car" VARCHAR,
  "flag_own_realty" VARCHAR,
  "cnt_children" BIGINT,
  "amt_income_total" DOUBLE,
  "amt_credit" DOUBLE,
  "amt_annuity" DOUBLE,
  "amt_goods_price" DOUBLE,
  "name_type_suite" VARCHAR,
  "name_income_type" VARCHAR,
  "name_education_type" VARCHAR,
  "name_family_status" VARCHAR,
  "name_housing_type" VARCHAR,
  "region_population_relative" DOUBLE,
  "days_birth" BIGINT,
  "days_employed" BIGINT,
  "days_registration" DOUBLE,
  "days_id_publish" BIGINT,
  "own_car_age" DOUBLE,
  "flag_mobil" BIGINT,
  "flag_emp_phone" BIGINT,
  "flag_work_phone" BIGINT,
  "flag_cont_mobile" BIGINT,
  "flag_phone" BIGINT,
  "flag_email" BIGINT,
  "occupation_type" VARCHAR,
  "cnt_fam_members" DOUBLE,
  "region_rating_client" BIGINT,
  "region_rating_client_w_city" BIGINT,
  "weekday_appr_process_start" VARCHAR,
  "hour_appr_process_start" BIGINT,
  "reg_region_not_live_region" BIGINT,
  "reg_region_not_work_region" BIGINT,
  "live_region_not_work_region" BIGINT,
  "reg_city_not_live_city" BIGINT,
  "reg_city_not_work_city" BIGINT,
  "live_city_not_work_city" BIGINT,
  "organization_type" VARCHAR,
  "ext_source_1" DOUBLE,
  "ext_source_2" DOUBLE,
  "ext_source_3" DOUBLE,
  "apartments_avg" DOUBLE,
  "basementarea_avg" DOUBLE,
  "years_beginexpluatation_avg" DOUBLE,
  "years_build_avg" DOUBLE,
  "commonarea_avg" DOUBLE,
  "elevators_avg" DOUBLE,
  "entrances_avg" DOUBLE,
  "floorsmax_avg" DOUBLE,
  "floorsmin_avg" DOUBLE,
  "landarea_avg" DOUBLE,
  "livingapartments_avg" DOUBLE,
  "livingarea_avg" DOUBLE,
  "nonlivingapartments_avg" DOUBLE,
  "nonlivingarea_avg" DOUBLE,
  "apartments_mode" DOUBLE,
  "basementarea_mode" DOUBLE,
  "years_beginexpluatation_mode" DOUBLE,
  "years_build_mode" DOUBLE,
  "commonarea_mode" DOUBLE,
  "elevators_mode" DOUBLE,
  "entrances_mode" DOUBLE,
  "floorsmax_mode" DOUBLE,
  "floorsmin_mode" DOUBLE,
  "landarea_mode" DOUBLE,
  "livingapartments_mode" DOUBLE,
  "livingarea_mode" DOUBLE,
  "nonlivingapartments_mode" DOUBLE,
  "nonlivingarea_mode" DOUBLE,
  "apartments_medi" DOUBLE,
  "basementarea_medi" DOUBLE,
  "years_beginexpluatation_medi" DOUBLE,
  "years_build_medi" DOUBLE,
  "commonarea_medi" DOUBLE,
  "elevators_medi" DOUBLE,
  "entrances_medi" DOUBLE,
  "floorsmax_medi" DOUBLE,
  "floorsmin_medi" DOUBLE,
  "landarea_medi" DOUBLE,
  "livingapartments_medi" DOUBLE,
  "livingarea_medi" DOUBLE,
  "nonlivingapartments_medi" DOUBLE,
  "nonlivingarea_medi" DOUBLE,
  "fondkapremont_mode" VARCHAR,
  "housetype_mode" VARCHAR,
  "totalarea_mode" DOUBLE,
  "wallsmaterial_mode" VARCHAR,
  "emergencystate_mode" VARCHAR,
  "obs_30_cnt_social_circle" DOUBLE,
  "def_30_cnt_social_circle" DOUBLE,
  "obs_60_cnt_social_circle" DOUBLE,
  "def_60_cnt_social_circle" DOUBLE,
  "days_last_phone_change" DOUBLE,
  "flag_document_2" BIGINT,
  "flag_document_3" BIGINT,
  "flag_document_4" BIGINT,
  "flag_document_5" BIGINT
);

Columns Description

@kaggle.gauravduttakiit_loan_defaulter.columns_description

10.29 KB
160 rows
5 columns


CREATE TABLE columns_description (
  "unnamed_0" BIGINT,
  "table" VARCHAR,
  "row" VARCHAR,
  "description" VARCHAR,
  "special" VARCHAR
);

Previous Application

@kaggle.gauravduttakiit_loan_defaulter.previous_application

70.01 MB
1670214 rows
37 columns


CREATE TABLE previous_application (
  "sk_id_prev" BIGINT,
  "sk_id_curr" BIGINT,
  "name_contract_type" VARCHAR,
  "amt_annuity" DOUBLE,
  "amt_application" DOUBLE,
  "amt_credit" DOUBLE,
  "amt_down_payment" DOUBLE,
  "amt_goods_price" DOUBLE,
  "weekday_appr_process_start" VARCHAR,
  "hour_appr_process_start" BIGINT,
  "flag_last_appl_per_contract" VARCHAR,
  "nflag_last_appl_in_day" BIGINT,
  "rate_down_payment" DOUBLE,
  "rate_interest_primary" DOUBLE,
  "rate_interest_privileged" DOUBLE,
  "name_cash_loan_purpose" VARCHAR,
  "name_contract_status" VARCHAR,
  "days_decision" BIGINT,
  "name_payment_type" VARCHAR,
  "code_reject_reason" VARCHAR,
  "name_type_suite" VARCHAR,
  "name_client_type" VARCHAR,
  "name_goods_category" VARCHAR,
  "name_portfolio" VARCHAR,
  "name_product_type" VARCHAR,
  "channel_type" VARCHAR,
  "sellerplace_area" BIGINT,
  "name_seller_industry" VARCHAR,
  "cnt_payment" DOUBLE,
  "name_yield_group" VARCHAR,
  "product_combination" VARCHAR,
  "days_first_drawing" DOUBLE,
  "days_first_due" DOUBLE,
  "days_last_due_1st_version" DOUBLE,
  "days_last_due" DOUBLE,
  "days_termination" DOUBLE,
  "nflag_insured_on_approval" DOUBLE
);