Bank Customer Churn

Bank Customer Data for Customer Churn

@kaggle.sandiledesmondmfazi_bank_customer_churn

Table List

1 table(14.22 MB)

Botswana Bank Customer Churn

@kaggle.sandiledesmondmfazi_bank_customer_churn.botswana_bank_customer_churn

14.22 MB
115640 rows
25 columns

rownumber RowNumber	customerid CustomerId	surname Surname	first_name First Name	date_of_birth Date Of Birth	gender Gender	marital_status Marital Status	number_of_dependents Number Of Dependents	occupation Occupation	income Income	education_level Education Level	address Address	contact_information Contact Information	customer_tenure Customer Tenure	customer_segment Customer Segment	preferred_communication_channel Preferred Communication Channel	credit_score Credit Score	credit_history_length Credit History Length	outstanding_loans Outstanding Loans	churn_flag Churn Flag	churn_reason Churn Reason	churn_date Churn Date	balance Balance	numofproducts NumOfProducts	numcomplaints NumComplaints
1	83ef0b54-35f6-4f84-af58-5653ac0c0dc4	Smith	Troy	Sat Aug 29 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Male	Divorced	3	Information systems manager	77710.14	High School	26644 Diaz Viaduct North Jessicaville, VI 14852	001-301-934-3058x0825	30	Retail	Phone	397	24	41959.74		nan		211359.05	1
2	009f115a-e5ca-4cf4-97d6-530140545e4e	Sullivan	Katrina	Mon Feb 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Female	Married	1	Charity fundraiser	58209.87	High School	5642 Rachel Pass Suite 320 Port Peggy, RI 75805	+1-581-683-4267	27	SME	Email	665	10	8916.67		nan		30624.76	4	1
3	66309fd3-5009-44d3-a3f7-1657c869d573	Fuller	Henry	Wed Feb 03 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	Female	Single	1	Television production assistant	9794.01	High School	00025 Brittany Flats Apt. 543 New Amandaborough, MH 69279	9753900004	14	Retail	Email	715	21	43270.54		nan		111956.61	2	6
4	b02a30df-1a5f-4087-8075-2a35432da641	Young	Antonio	Tue Jan 15 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Female	Divorced	5	Agricultural engineer	15088.98	High School	Unit 3386 Box 0088 DPO AE 71940	+1-928-477-2856x660	23	Corporate	Phone	747	17	17887.65		nan		201187.61	1
5	0d932e5b-bb3a-4104-8c83-f84270f7f2ea	Andersen	John	Wed Apr 08 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	Female	Divorced	2	Teacher, early years/pre	60726.56	Master's	0120 Leslie River West Lindseychester, MN 98290	204.515.2388	22	Corporate	Email	549	25	32686.84		nan		60391.24	5	6
6	c18b027e-b108-4900-b413-dac87e2ee9b5	Gonzales	Ashley	Sat Nov 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Male	Single		Surveyor, building	55608.75	Bachelor's	PSC 3787, Box 9869 APO AP 62324	001-880-967-5883x0508	15	Retail	Email	809	27	37218.81	1	Account Closure	Wed Jul 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	31206.81	2	10
7	7091e271-7d2b-4e73-934f-8398e2a1dcbc	Wilcox	Daniel	Tue Sep 07 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	Female	Single	1	Publishing copy	22032.61	Diploma	983 Adams Coves Lake Roberto, MP 82550	4756961139	15	Retail	Email	690	29	26200		nan		198443.5	2	1
8	d5e80b75-bd3f-4d8a-b847-0868f8eb9e40	Lopez	Johnny	Thu Aug 05 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	Male	Divorced	4	Industrial buyer	73462.72	Diploma	905 Jackson View Suite 009 South Amymouth, PA 54407	001-577-988-4031x4410	3	Corporate	Email	605	30	25156.25		nan		96378.05	4	6
9	9eba62c1-0af0-4424-9218-435ece0689aa	Miles	Kelly	Fri Aug 03 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	Male	Divorced	3	Medical sales representative	30054.43	Bachelor's	6398 Morgan Knolls Julieborough, NH 55183	001-245-374-7034x4970	20	Corporate	Phone	634	16	41854.08		nan		108395.17	5	1
10	4eea7068-ea07-4898-bb04-6ccd8b729fc9	Thompson	Anthony	Sat Jan 12 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Female	Divorced	5	Media buyer	24129.53	Master's	674 Reed Islands Loweville, TX 67579	+1-814-630-2270x6096	21	SME	Phone	831	10	30914.02		nan		99830.84	4	5


CREATE TABLE botswana_bank_customer_churn (
  "rownumber" BIGINT,
  "customerid" VARCHAR,
  "surname" VARCHAR,
  "first_name" VARCHAR,
  "date_of_birth" TIMESTAMP,
  "gender" VARCHAR,
  "marital_status" VARCHAR,
  "number_of_dependents" BIGINT,
  "occupation" VARCHAR,
  "income" DOUBLE,
  "education_level" VARCHAR,
  "address" VARCHAR,
  "contact_information" VARCHAR,
  "customer_tenure" BIGINT,
  "customer_segment" VARCHAR,
  "preferred_communication_channel" VARCHAR,
  "credit_score" BIGINT,
  "credit_history_length" BIGINT,
  "outstanding_loans" DOUBLE,
  "churn_flag" BIGINT,
  "churn_reason" VARCHAR,
  "churn_date" TIMESTAMP,
  "balance" DOUBLE,
  "numofproducts" BIGINT,
  "numcomplaints" BIGINT
);