Credit EDA Case Study

Identifying target customer audience for providing loan

@kaggle.venkatasubramanian_credit_eda_case_study

Table List

2 tables(94.2 MB)

Previous Application

@kaggle.venkatasubramanian_credit_eda_case_study.previous_application

70.01 MB
1670214 rows
37 columns

sk_id_prev SK ID PREV	sk_id_curr SK ID CURR	name_contract_type NAME CONTRACT TYPE	amt_annuity AMT ANNUITY	amt_application AMT APPLICATION	amt_credit AMT CREDIT	amt_goods_price AMT GOODS PRICE	weekday_appr_process_start WEEKDAY APPR PROCESS START	hour_appr_process_start HOUR APPR PROCESS START	flag_last_appl_per_contract FLAG LAST APPL PER CONTRACT	nflag_last_appl_in_day NFLAG LAST APPL IN DAY	rate_interest_primary RATE INTEREST PRIMARY	rate_interest_privileged RATE INTEREST PRIVILEGED	name_cash_loan_purpose NAME CASH LOAN PURPOSE	name_contract_status NAME CONTRACT STATUS	days_decision DAYS DECISION	name_payment_type NAME PAYMENT TYPE	code_reject_reason CODE REJECT REASON	name_type_suite NAME TYPE SUITE	name_client_type NAME CLIENT TYPE	name_goods_category NAME GOODS CATEGORY	name_portfolio NAME PORTFOLIO	name_product_type NAME PRODUCT TYPE	channel_type CHANNEL TYPE	sellerplace_area SELLERPLACE AREA	name_seller_industry NAME SELLER INDUSTRY	cnt_payment CNT PAYMENT	name_yield_group NAME YIELD GROUP	product_combination PRODUCT COMBINATION	days_first_drawing DAYS FIRST DRAWING	days_first_due DAYS FIRST DUE	days_last_due_1st_version DAYS LAST DUE 1ST VERSION	days_last_due DAYS LAST DUE	days_termination DAYS TERMINATION	nflag_insured_on_approval NFLAG INSURED ON APPROVAL
2030495	271877	Consumer loans	1730.43	17145	17145	17145	SATURDAY	15	Y	1	0.1828318032415278	0.8673361522198731	XAP	Approved	-73	Cash through the bank	XAP	nan	Repeater	Mobile	POS	XNA	Country-wide	35	Connectivity	12	middle	POS mobile with interest	365243	-42	300	-42	-37
2802425	108129	Cash loans	25188.615	607500	679671	607500	THURSDAY	11	Y	1			XNA	Approved	-164	XNA	XAP	Unaccompanied	Repeater	XNA	Cash	x-sell	Contact center	-1	XNA	36	low_action	Cash X-Sell: low	365243	-134	916	365243	365243	1
2523466	122040	Cash loans	15060.735	112500	136444.5	112500	TUESDAY	11	Y	1			XNA	Approved	-301	Cash through the bank	XAP	Spouse, partner	Repeater	XNA	Cash	x-sell	Credit and cash offices	-1	XNA	12	high	Cash X-Sell: high	365243	-271	59	365243	365243	1
2819243	176158	Cash loans	47041.335	450000	470790	450000	MONDAY	7	Y	1			XNA	Approved	-512	Cash through the bank	XAP	nan	Repeater	XNA	Cash	x-sell	Credit and cash offices	-1	XNA	12	middle	Cash X-Sell: middle	365243	-482	-152	-182	-177	1
1784265	202054	Cash loans	31924.395	337500	404055	337500	THURSDAY	9	Y	1			Repairs	Refused	-781	Cash through the bank	HC	nan	Repeater	XNA	Cash	walk-in	Credit and cash offices	-1	XNA	24	high	Cash Street: high
1383531	199383	Cash loans	23703.93	315000	340573.5	315000	SATURDAY	8	Y	1			Everyday expenses	Approved	-684	Cash through the bank	XAP	Family	Repeater	XNA	Cash	x-sell	Credit and cash offices	-1	XNA	18	low_normal	Cash X-Sell: low	365243	-654	-144	-144	-137	1
2315218	175704	Cash loans					TUESDAY	11	Y	1			XNA	Canceled	-14	XNA	XAP	nan	Repeater	XNA	XNA	XNA	Credit and cash offices	-1	XNA		XNA	Cash
1656711	296299	Cash loans					MONDAY	7	Y	1			XNA	Canceled	-21	XNA	XAP	nan	Repeater	XNA	XNA	XNA	Credit and cash offices	-1	XNA		XNA	Cash
2367563	342292	Cash loans					MONDAY	15	Y	1			XNA	Canceled	-386	XNA	XAP	nan	Repeater	XNA	XNA	XNA	Credit and cash offices	-1	XNA		XNA	Cash
2579447	334349	Cash loans					SATURDAY	15	Y	1			XNA	Canceled	-57	XNA	XAP	nan	Repeater	XNA	XNA	XNA	Credit and cash offices	-1	XNA		XNA	Cash


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
);