Making A Credit In The Bank
Dataset for determining credit extension to a potential customer
@kaggle.dimabutko_making_a_credit_in_the_bank
Bank
@kaggle.dimabutko_making_a_credit_in_the_bank.bank
- 1.77 MB
- 75829 rows
- 19 columns
statement_idStatement Id | first_paymentFirst Payment | credit_amountCredit Amount | credit_termCredit Term | income_normIncome Norm | income_sumIncome Sum | income_sum_confirmedIncome Sum Confirmed | month_paymentMonth Payment | gender_normGender Norm | family_childrenFamily Children | marriageMarriage | job_experience_yearJob Experience Year | job_general_experience_yearJob General Experience Year | family_yearsFamily Years | education_normEducation Norm | ageAge | job_is_officialJob Is Official | work_positionWork Position | decisionDecision |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 907265 | 25.4 | 1505135 | 60 | 0.38 | 100000 | 37800 | 1 | 1 | 1 | 16 | 40 | 32 | 2 | 59 | head_of_department | 1 | ||
| 754448 | 45.6 | 2026699.39 | 36 | 0.08 | 335000 | 26060 | 1 | 1 | 4 | 14 | 8 | 4 | 37 | specialist | 1 | |||
| 1226984 | 80 | 608440 | 24 | 0.25 | 130000 | 32420 | 1 | 1 | 1 | 27 | 8 | 4 | 52 | specialist | 1 | |||
| 1302527 | 73.9 | 530000 | 60 | 0.09 | 150000 | 14000 | 1 | 4 | 10 | 37 | 4 | 65 | specialist | 1 | ||||
| 1066046 | 30.9 | 1691240 | 84 | 0.24 | 150000 | 35536.3 | 1 | 1 | 5 | 20 | 12 | 2 | 43 | specialist | ||||
| 1411351 | 42.1 | 1693632 | 60 | 0.5 | 80000 | 39800 | 17 | 4 | 41 | owner | 1 | |||||||
| 1122537 | 63.9 | 822960 | 36 | 0.26 | 100000 | 25900 | 1 | 2 | 1 | 26 | 26 | 18 | 2 | 47 | unskilled_worker | 1 | ||
| 1354353 | 10 | 2314092.22 | 96 | 0.25 | 180000 | 44950 | 6 | 28 | 2 | 48 | specialist | 1 | ||||||
| 1178708 | 2370000 | 84 | 0.37 | 150000 | 56060 | 1 | 3 | 12 | 4 | 45 | head_of_department | 1 | ||||||
| 1258996 | 40 | 1569336 | 60 | 0.18 | 200000 | 35200 | 1 | 1 | 13 | 20 | 3 | 4 | 43 | owner | 1 |
CREATE TABLE bank (
"statement_id" BIGINT,
"first_payment" DOUBLE,
"credit_amount" DOUBLE,
"credit_term" BIGINT,
"income_norm" DOUBLE,
"income_sum" BIGINT,
"income_sum_confirmed" BIGINT,
"month_payment" DOUBLE,
"gender_norm" BIGINT,
"family_children" BIGINT,
"marriage" BIGINT,
"job_experience_year" BIGINT,
"job_general_experience_year" BIGINT,
"family_years" BIGINT,
"education_norm" BIGINT,
"age" BIGINT,
"job_is_official" BIGINT,
"work_position" VARCHAR,
"decision" BIGINT
);