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)

Processed Bank

@kaggle.bletchley_bank_marketing.processed_bank

206.17 KB
9280 rows
66 columns

unnamed_0 Unnamed: 0	campaign Campaign	pdays Pdays	previous Previous	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	job_admin Job Admin.	job_blue_collar Job Blue-collar	job_management Job Management	job_retired Job Retired	job_technician Job Technician	age_old Age Old	age_mid Age Mid	age_young Age Young	marital_married Marital Married	marital_single Marital Single	education_basic_4y Education Basic.4y	education_basic_9y Education Basic.9y	education_high_school Education High.school	education_professional_course Education Professional.course	education_university_degree Education University.degree	education_unknown Education Unknown	default_no Default No	housing_no Housing No	housing_yes Housing Yes	loan_no Loan No	loan_yes Loan Yes	contact_cellular Contact Cellular	contact_telephone Contact Telephone	month_apr Month Apr	month_aug Month Aug	month_jul Month Jul	month_jun Month Jun	month_may Month May	month_nov Month Nov	month_sep Month Sep	day_of_week_mon Day Of Week Mon	day_of_week_thu Day Of Week Thu	day_of_week_tue Day Of Week Tue	day_of_week_wed Day Of Week Wed	poutcome_failure Poutcome Failure	poutcome_nonexistent Poutcome Nonexistent	poutcome_success Poutcome Success	contacted_before Contacted Before
34579	-0.6871095626978501	-2.555676804509097e-13	0.976407519344501	-0.7585502524618822	-0.9281024353999774	-1.1229291984490728	-0.9002023777932325	-0.4183219654905148		1						1	1		1					1		1		1	1		1						1				1			1
446	-0.6871095626978501	-2.555676804509097e-13	-0.45255664711457	0.9242128804467502	0.8067664784051977	0.7056711636723466	0.9989708425897946	0.6375088168940394	1					1		1		1					1			1	1		1			1					1					1			1
20173	-0.1355198791480188	-2.555676804509097e-13	-0.45255664711457	1.0982918252304017	-0.0598801179552402	0.7616487257781038	1.0560888341802614	1.063747359075405	1	1						1		1						1		1	1		1		1			1						1					1
18171	-0.1355198791480188	-2.555676804509097e-13	-0.45255664711457	1.0982918252304017	0.6870116759990379	-0.4698576405485661	1.055031093595253	1.063747359075405	1	1						1		1				1				1		1		1		1			1								1		1
30128	-0.6871095626978501	-2.555676804509097e-13	-0.45255664711457	-0.7585502524618822	-0.6413211980588821	-1.2908618847663458	-0.8478442188353045	-0.4183219654905148				1					1		1					1		1		1	1		1		1								1				1
36765	2.622428538601137	-2.555676804509097e-13	-0.45255664711457	-1.3968397166686048	-0.8178019594995681	-0.1153330805454329	-0.889624971943146	-0.6814179928747037	1	1							1		1						1	1	1		1			1				1						1			1
6835	1.5192491715014749	-2.555676804509097e-13	-0.45255664711457	0.9242128804467502	0.8067664784051977	0.7056711636723466	0.9989708425897946	0.6375088168940394			1					1		1			1					1	1		1			1					1						1		1
31944	-0.1355198791480188	-2.555676804509097e-13	-0.45255664711457	-0.7585502524618822	-0.9281024353999774	-1.1229291984490728	-0.8679412899504688	-0.4183219654905148	1		1					1			1		1					1	1			1	1						1				1				1
41174	-0.6871095626978501	-3.911365823769354	8.121228351639857	-0.3523660479666951	2.024798876562686	-1.9812518174040237	-1.0244868965317486	-1.9750692017593685	1				1		1			1						1		1		1	1		1							1			1					1	1
38071	-0.6871095626978501	-2.31721830237509	2.405371685803572	-1.686971291308024	-1.7380230727259114	1.937177529999016	-1.162522042875377	-1.355816980099659	1				1		1			1		1						1	1		1		1								1			1				1	1


CREATE TABLE processed_bank (
  "unnamed_0" BIGINT,
  "campaign" DOUBLE,
  "pdays" DOUBLE,
  "previous" DOUBLE,
  "emp_var_rate" DOUBLE,
  "cons_price_idx" DOUBLE,
  "cons_conf_idx" DOUBLE,
  "euribor3m" DOUBLE,
  "nr_employed" DOUBLE,
  "y" BIGINT,
  "job_admin" BIGINT,
  "job_blue_collar" BIGINT,
  "job_entrepreneur" BIGINT,
  "job_housemaid" BIGINT,
  "job_management" BIGINT,
  "job_retired" BIGINT,
  "job_self_employed" BIGINT,
  "job_services" BIGINT,
  "job_student" BIGINT,
  "job_technician" BIGINT,
  "job_unemployed" BIGINT,
  "job_unknown" BIGINT,
  "age_old" BIGINT,
  "age_mid" BIGINT,
  "age_young" BIGINT,
  "marital_divorced" BIGINT,
  "marital_married" BIGINT,
  "marital_single" BIGINT,
  "marital_unknown" BIGINT,
  "education_basic_4y" BIGINT,
  "education_basic_6y" BIGINT,
  "education_basic_9y" BIGINT,
  "education_high_school" BIGINT,
  "education_illiterate" BIGINT,
  "education_professional_course" BIGINT,
  "education_university_degree" BIGINT,
  "education_unknown" BIGINT,
  "default_no" BIGINT,
  "default_unknown" BIGINT,
  "housing_no" BIGINT,
  "housing_unknown" BIGINT,
  "housing_yes" BIGINT,
  "loan_no" BIGINT,
  "loan_unknown" BIGINT,
  "loan_yes" BIGINT,
  "contact_cellular" BIGINT,
  "contact_telephone" BIGINT,
  "month_apr" BIGINT,
  "month_aug" BIGINT,
  "month_dec" BIGINT,
  "month_jul" BIGINT,
  "month_jun" BIGINT,
  "month_mar" BIGINT,
  "month_may" BIGINT,
  "month_nov" BIGINT,
  "month_oct" BIGINT,
  "month_sep" BIGINT,
  "day_of_week_fri" BIGINT,
  "day_of_week_mon" BIGINT,
  "day_of_week_thu" BIGINT,
  "day_of_week_tue" BIGINT,
  "day_of_week_wed" BIGINT,
  "poutcome_failure" BIGINT,
  "poutcome_nonexistent" BIGINT,
  "poutcome_success" BIGINT,
  "contacted_before" BIGINT
);