Bank User Dataset

This dataset contains user behaviors contributing to their credit score

@kaggle.khanmdsaifullahanjar_bank_user_dataset

Table List

1 table(4.3 MB)

Bank Data

@kaggle.khanmdsaifullahanjar_bank_user_dataset.bank_data

4.3 MB
50000 rows
27 columns

id ID	customer_id Customer ID	month Month	name Name	age Age	ssn SSN	occupation Occupation	annual_income Annual Income	monthly_inhand_salary Monthly Inhand Salary	num_bank_accounts Num Bank Accounts	num_credit_card Num Credit Card	interest_rate Interest Rate	num_of_loan Num Of Loan	type_of_loan Type Of Loan	delay_from_due_date Delay From Due Date	num_of_delayed_payment Num Of Delayed Payment	changed_credit_limit Changed Credit Limit	num_credit_inquiries Num Credit Inquiries	credit_mix Credit Mix	outstanding_debt Outstanding Debt	credit_utilization_ratio Credit Utilization Ratio	credit_history_age Credit History Age	payment_of_min_amount Payment Of Min Amount	total_emi_per_month Total EMI Per Month	amount_invested_monthly Amount Invested Monthly	payment_behaviour Payment Behaviour	monthly_balance Monthly Balance
0x160a	CUS_0xd40	September	Aaron Maashoh	23	821-00-0265	Scientist	19114.12	1824.8433333333328	3	4	3	4	Auto Loan, Credit-Builder Loan, Personal Loan, and Home Equity Loan	3	7	11.27	2022	Good	809.98	35.03040185583525	22 Years and 9 Months	No	49.57494921489417	236.64268203272135	Low_spent_Small_value_payments	186.26670208571772
0x160b	CUS_0xd40	October	Aaron Maashoh	24	821-00-0265	Scientist	19114.12	1824.8433333333328	3	4	3	4	Auto Loan, Credit-Builder Loan, Personal Loan, and Home Equity Loan	3	9	13.27	4	Good	809.98	33.053114497012245	22 Years and 10 Months	No	49.57494921489417	21.465380264657146	High_spent_Medium_value_payments	361.44400385378196
0x160c	CUS_0xd40	November	Aaron Maashoh	24	821-00-0265	Scientist	19114.12	1824.8433333333328	3	4	3	4	Auto Loan, Credit-Builder Loan, Personal Loan, and Home Equity Loan	-1	4	12.27	4	Good	809.98	33.811894118574465	nan	No	49.57494921489417	148.23393788500925	Low_spent_Medium_value_payments	264.67544623342997
0x160d	CUS_0xd40	December	Aaron Maashoh	24_	821-00-0265	Scientist	19114.12		3	4	3	4	Auto Loan, Credit-Builder Loan, Personal Loan, and Home Equity Loan	4	5	11.27	4	Good	809.98	32.430559017296765	23 Years and 0 Months	No	49.57494921489417	39.08251089460281	High_spent_Medium_value_payments	343.82687322383634
0x1616	CUS_0x21b1	September	Rick Rothackerj	28	004-07-5839	_______	34847.84	3037.986666666666	2	4	6	1	Credit-Builder Loan	3	1	5.42	5	Good	605.03	25.92682170377555	27 Years and 3 Months	No	18.816214573128885	39.684018417945296	High_spent_Large_value_payments	485.2984336755923
0x1617	CUS_0x21b1	October	Rick Rothackerj	28	#F%$D@*&8	Teacher	34847.84	3037.986666666666	2	4	6	1	Credit-Builder Loan	3	3	5.42	5	Good	605.03	30.11660045002501	27 Years and 4 Months	No	18.816214573128885	251.62736875017606	Low_spent_Large_value_payments	303.3550833433617
0x1618	CUS_0x21b1	November	Rick Rothackerj	28	004-07-5839	Teacher	34847.84	3037.986666666666	2	4	6	1	Credit-Builder Loan	3	nan	5.42	5	_	605.03	30.996423739085607	27 Years and 5 Months	No	18.816214573128885	72.68014533363515	High_spent_Large_value_payments	452.30230675990265
0x1619	CUS_0x21b1	December	Rick Rothackerj	28	004-07-5839	Teacher	34847.84	3037.986666666666	2	4	6	1	Credit-Builder Loan	3	2_	7.42	5	_	605.03	33.875167221549795	27 Years and 6 Months	No	18.816214573128885	153.53448761392985	!@9#%8	421.44796447960783
0x1622	CUS_0x2dbc	September	Langep	35	486-85-3974	Engineer	143162.64		1	5	8	3	Auto Loan, Auto Loan, and Not Specified	8	1942	7.1	3	Good	1303.01	35.22970733005963	18 Years and 5 Months	No	246.9923194537421	397.50365354404653	Low_spent_Medium_value_payments	854.2260270022115
0x1623	CUS_0x2dbc	October	Langep	35	486-85-3974	Engineer	143162.64	12187.22	1	5	8	3	Auto Loan, Auto Loan, and Not Specified	6	3	2.1	3	Good	1303.01	35.68583594909283	18 Years and 6 Months	No	246.9923194537421	453.6151305781054	Low_spent_Large_value_payments	788.1145499681528


CREATE TABLE bank_data (
  "id" VARCHAR,
  "customer_id" VARCHAR,
  "month" VARCHAR,
  "name" VARCHAR,
  "age" VARCHAR,
  "ssn" VARCHAR,
  "occupation" VARCHAR,
  "annual_income" VARCHAR,
  "monthly_inhand_salary" DOUBLE,
  "num_bank_accounts" BIGINT,
  "num_credit_card" BIGINT,
  "interest_rate" BIGINT,
  "num_of_loan" VARCHAR,
  "type_of_loan" VARCHAR,
  "delay_from_due_date" BIGINT,
  "num_of_delayed_payment" VARCHAR,
  "changed_credit_limit" VARCHAR,
  "num_credit_inquiries" DOUBLE,
  "credit_mix" VARCHAR,
  "outstanding_debt" VARCHAR,
  "credit_utilization_ratio" DOUBLE,
  "credit_history_age" VARCHAR,
  "payment_of_min_amount" VARCHAR,
  "total_emi_per_month" DOUBLE,
  "amount_invested_monthly" VARCHAR,
  "payment_behaviour" VARCHAR,
  "monthly_balance" VARCHAR
);