Credit Card Customers

Predict Churning customers

@kaggle.sakshigoyal7_credit_card_customers

Table List

1 table(386 KB)

Bankchurners

@kaggle.sakshigoyal7_credit_card_customers.bankchurners

386 KB
10127 rows
23 columns

clientnum CLIENTNUM	attrition_flag Attrition Flag	customer_age Customer Age	gender Gender	dependent_count Dependent Count	education_level Education Level	marital_status Marital Status	income_category Income Category	card_category Card Category	months_on_book Months On Book	total_relationship_count Total Relationship Count	months_inactive_12_mon Months Inactive 12 Mon	contacts_count_12_mon Contacts Count 12 Mon	credit_limit Credit Limit	total_revolving_bal Total Revolving Bal	avg_open_to_buy Avg Open To Buy	total_amt_chng_q4_q1 Total Amt Chng Q4 Q1	total_trans_amt Total Trans Amt	total_trans_ct Total Trans Ct	total_ct_chng_q4_q1 Total Ct Chng Q4 Q1	avg_utilization_ratio Avg Utilization Ratio	naive_bayes_classifier_attrition_flag_card_category_co_121d9ef8 Naive Bayes Classifier Attrition Flag Card Category Contacts Count 12 Mon Dependent Count Education Level Months Inactive 12 Mon 1	naive_bayes_classifier_attrition_flag_card_category_co_eaea8887 Naive Bayes Classifier Attrition Flag Card Category Contacts Count 12 Mon Dependent Count Education Level Months Inactive 12 Mon 2
768805383	Existing Customer	45	M	3	High School	Married	$60K - $80K	Blue	39	5	1	3	12691	777	11914	1.335	1144	42	1.625	0.061	0.000093448	0.99991
818770008	Existing Customer	49	F	5	Graduate	Single	Less than $40K	Blue	44	6	1	2	8256	864	7392	1.541	1291	33	3.714	0.105	0.000056861	0.99994
713982108	Existing Customer	51	M	3	Graduate	Married	$80K - $120K	Blue	36	4	1		3418		3418	2.594	1887	20	2.333		0.000021081	0.99998
769911858	Existing Customer	40	F	4	High School	Unknown	Less than $40K	Blue	34	3	4	1	3313	2517	796	1.405	1171	20	2.333	0.76	0.00013366	0.99987
709106358	Existing Customer	40	M	3	Uneducated	Married	$60K - $80K	Blue	21	5	1		4716		4716	2.175	816	28	2.5		0.000021676	0.99998
713061558	Existing Customer	44	M	2	Graduate	Married	$40K - $60K	Blue	36	3	1	2	4010	1247	2763	1.376	1088	24	0.846	0.311	0.000055077	0.99994
810347208	Existing Customer	51	M	4	Unknown	Married	$120K +	Gold	46	6	1	3	34516	2264	32252	1.975	1330	31	0.722	0.066	0.00012303	0.99988
818906208	Existing Customer	32	M		High School	Unknown	$60K - $80K	Silver	27	2	2	2	29081	1396	27685	2.204	1538	36	0.714	0.048	0.000085795	0.99991
710930508	Existing Customer	37	M	3	Uneducated	Single	$60K - $80K	Blue	36	5	2		22352	2517	19835	3.355	1350	24	1.182	0.113	0.000044796	0.99996
719661558	Existing Customer	48	M	2	Graduate	Single	$80K - $120K	Blue	36	6	3	3	11656	1677	9979	1.524	1441	32	0.882	0.144	0.00030251	0.9997


CREATE TABLE bankchurners (
  "clientnum" BIGINT,
  "attrition_flag" VARCHAR,
  "customer_age" BIGINT,
  "gender" VARCHAR,
  "dependent_count" BIGINT,
  "education_level" VARCHAR,
  "marital_status" VARCHAR,
  "income_category" VARCHAR,
  "card_category" VARCHAR,
  "months_on_book" BIGINT,
  "total_relationship_count" BIGINT,
  "months_inactive_12_mon" BIGINT,
  "contacts_count_12_mon" BIGINT,
  "credit_limit" DOUBLE,
  "total_revolving_bal" BIGINT,
  "avg_open_to_buy" DOUBLE,
  "total_amt_chng_q4_q1" DOUBLE,
  "total_trans_amt" BIGINT,
  "total_trans_ct" BIGINT,
  "total_ct_chng_q4_q1" DOUBLE,
  "avg_utilization_ratio" DOUBLE,
  "naive_bayes_classifier_attrition_flag_card_category_co_121d9ef8" DOUBLE,
  "naive_bayes_classifier_attrition_flag_card_category_co_eaea8887" DOUBLE
);