Bank Marketing : Term Deposits Classification
Portuguese bank marketing historical data to predict term deposit subscriptions.
@kaggle.saranyaponnarasu_bank_marketing_term_deposits_classification
Portuguese bank marketing historical data to predict term deposit subscriptions.
@kaggle.saranyaponnarasu_bank_marketing_term_deposits_classification
The data is related with direct marketing campaigns (phone calls) of a Portuguese banking institution. The classification goal is to predict if the client will subscribe a term deposit (variable y).
Bivariate
Business
Classification
The data is related with direct marketing campaigns of a Portuguese banking institution. The marketing campaigns were based on phone calls. Often, more than one contact to the same client was required, in order to access if the product (bank term deposit) would be ('yes') or not ('no') subscribed.
1 - age (numeric)
2 - job : type of job (categorical: "admin.","unknown","unemployed","management","housemaid","entrepreneur","student",
"blue-collar","self-employed","retired","technician","services")
3 - marital : marital status (categorical: "married","divorced","single"; note: "divorced" means divorced or widowed)
4 - education (categorical: "unknown","secondary","primary","tertiary")
5 - default: has credit in default? (binary: "yes","no")
6 - balance: average yearly balance, in euros (numeric)
7 - housing: has housing loan? (binary: "yes","no")
8 - loan: has personal loan? (binary: "yes","no")
9 - contact: contact communication type (categorical: "unknown","telephone","cellular")
10 - day: last contact day of the month (numeric)
11 - month: last contact month of year (categorical: "jan", "feb", "mar", …, "nov", "dec")
12 - duration: last contact duration, in seconds (numeric)
13 - campaign: number of contacts performed during this campaign and for this client (numeric, includes last contact)
14 - pdays: number of days that passed by after the client was last contacted from a previous campaign (numeric, -1 means client was not previously contacted)
15 - previous: number of contacts performed before this campaign and for this client (numeric)
16 - poutcome: outcome of the previous marketing campaign (categorical: "unknown","other","failure","success")
17 - y - has the client subscribed a term deposit? (binary: "yes","no")
Moro,S., Rita,P., and Cortez,P.. (2012). Bank Marketing. UCI Machine Learning Repository. https://doi.org/10.24432/C5K306.
CREATE TABLE test (
"age" BIGINT,
"job" VARCHAR,
"marital" VARCHAR,
"education" VARCHAR,
"default" VARCHAR,
"balance" BIGINT,
"housing" VARCHAR,
"loan" VARCHAR,
"contact" VARCHAR,
"day" BIGINT,
"month" VARCHAR,
"duration" BIGINT,
"campaign" BIGINT,
"pdays" BIGINT,
"previous" BIGINT,
"poutcome" VARCHAR,
"y" VARCHAR
);CREATE TABLE train (
"age" BIGINT,
"job" VARCHAR,
"marital" VARCHAR,
"education" VARCHAR,
"default" VARCHAR,
"balance" BIGINT,
"housing" VARCHAR,
"loan" VARCHAR,
"contact" VARCHAR,
"day" BIGINT,
"month" VARCHAR,
"duration" BIGINT,
"campaign" BIGINT,
"pdays" BIGINT,
"previous" BIGINT,
"poutcome" VARCHAR,
"y" VARCHAR
);Anyone who has the link will be able to view this.