Credit Analysis
Current & previous loan application data from a bank dealing with Risk Analytics
@kaggle.kapoorshivam_credit_analysis
Previous App
@kaggle.kapoorshivam_credit_analysis.previous_app
- 70.01 MB
- 1670214 rows
- 37 columns
sk_id_prevSK ID PREV | sk_id_currSK ID CURR | name_contract_typeNAME CONTRACT TYPE | amt_annuityAMT ANNUITY | amt_applicationAMT APPLICATION | amt_creditAMT CREDIT | amt_down_paymentAMT DOWN PAYMENT | amt_goods_priceAMT GOODS PRICE | weekday_appr_process_startWEEKDAY APPR PROCESS START | hour_appr_process_startHOUR APPR PROCESS START | flag_last_appl_per_contractFLAG LAST APPL PER CONTRACT | nflag_last_appl_in_dayNFLAG LAST APPL IN DAY | rate_down_paymentRATE DOWN PAYMENT | rate_interest_primaryRATE INTEREST PRIMARY | rate_interest_privilegedRATE INTEREST PRIVILEGED | name_cash_loan_purposeNAME CASH LOAN PURPOSE | name_contract_statusNAME CONTRACT STATUS | days_decisionDAYS DECISION | name_payment_typeNAME PAYMENT TYPE | code_reject_reasonCODE REJECT REASON | name_type_suiteNAME TYPE SUITE | name_client_typeNAME CLIENT TYPE | name_goods_categoryNAME GOODS CATEGORY | name_portfolioNAME PORTFOLIO | name_product_typeNAME PRODUCT TYPE | channel_typeCHANNEL TYPE | sellerplace_areaSELLERPLACE AREA | name_seller_industryNAME SELLER INDUSTRY | cnt_paymentCNT PAYMENT | name_yield_groupNAME YIELD GROUP | product_combinationPRODUCT COMBINATION | days_first_drawingDAYS FIRST DRAWING | days_first_dueDAYS FIRST DUE | days_last_due_1st_versionDAYS LAST DUE 1ST VERSION | days_last_dueDAYS LAST DUE | days_terminationDAYS TERMINATION | nflag_insured_on_approvalNFLAG 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_app (
"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
);