Course Material: Bank Marketing

A balanced and processed version of UCI's bank marketing dataset

@kaggle.bletchley_bank_marketing

Table List

2 tables(373.04 KB)

Balanced Bank

@kaggle.bletchley_bank_marketing.balanced_bank

166.86 KB
9280 rows
22 columns

unnamed_0 Unnamed: 0	age Age	job Job	marital Marital	education Education	default Default	housing Housing	loan Loan	contact Contact	month Month	day_of_week Day Of Week	duration Duration	campaign Campaign	pdays Pdays	previous Previous	poutcome Poutcome	emp_var_rate Emp.var.rate	cons_price_idx Cons.price.idx	cons_conf_idx Cons.conf.idx	euribor3m Euribor3m	nr_employed Nr.employed	y Y
34579	35	admin.	single	university.degree	no	yes	no	cellular	may	thu	143	1	999	1	failure	-1.8	92.893	-46.2	1.266	5099.1	no
446	42	technician	married	professional.course	no	no	no	telephone	may	tue	1623	1	999		nonexistent	1.1	93.994	-36.4	4.857	5191	yes
20173	36	admin.	married	university.degree	no	no	no	cellular	aug	mon	610	2	999		nonexistent	1.4	93.444	-36.1	4.965	5228.1	yes
18171	37	admin.	married	high.school	no	yes	yes	telephone	jul	wed	1089	2	999		nonexistent	1.4	93.918	-42.7	4.963	5228.1	yes
30128	31	management	single	university.degree	no	yes	no	cellular	apr	thu	211	1	999		nonexistent	-1.8	93.075	-47.1	1.365	5099.1	no
36765	25	admin.	single	unknown	no	no	no	telephone	jun	tue	221	7	999		nonexistent	-2.9	92.963	-40.8	1.286	5076.2	yes
6835	42	blue-collar	married	basic.9y	no	no	no	telephone	may	wed	92	5	999		nonexistent	1.1	93.994	-36.4	4.857	5191	no
31944	36	blue-collar	single	basic.9y	no	no	yes	cellular	may	thu	1516	2	999		nonexistent	-1.8	92.893	-46.2	1.327	5099.1	yes
41174	62	retired	married	university.degree	no	yes	no	cellular	nov	thu	208	1	1	6	success	-1.1	94.767	-50.8	1.031	4963.6	yes
38071	70	retired	married	basic.4y	no	no	no	cellular	sep	tue	150	1	3	2	success	-3.4	92.379	-29.8	0.77	5017.5	yes


CREATE TABLE balanced_bank (
  "unnamed_0" BIGINT,
  "age" BIGINT,
  "job" VARCHAR,
  "marital" VARCHAR,
  "education" VARCHAR,
  "default" VARCHAR,
  "housing" VARCHAR,
  "loan" VARCHAR,
  "contact" VARCHAR,
  "month" VARCHAR,
  "day_of_week" VARCHAR,
  "duration" BIGINT,
  "campaign" BIGINT,
  "pdays" BIGINT,
  "previous" BIGINT,
  "poutcome" VARCHAR,
  "emp_var_rate" DOUBLE,
  "cons_price_idx" DOUBLE,
  "cons_conf_idx" DOUBLE,
  "euribor3m" DOUBLE,
  "nr_employed" DOUBLE,
  "y" VARCHAR
);