Customer Churn Prediction

Synthetic data for modeling and analysis of telecom customer churn.

@kaggle.rashadrmammadov_customer_churn_dataset

Table List

1 table(142.75 KB)

Customer Churn Data

@kaggle.rashadrmammadov_customer_churn_dataset.customer_churn_data

142.75 KB
5880 rows
21 columns

customerid CustomerID	gender Gender	seniorcitizen SeniorCitizen	partner Partner	dependents Dependents	tenure Tenure	phoneservice PhoneService	multiplelines MultipleLines	internetservice InternetService	onlinesecurity OnlineSecurity	onlinebackup OnlineBackup	deviceprotection DeviceProtection	techsupport TechSupport	streamingtv StreamingTV	streamingmovies StreamingMovies	contract Contract	paperlessbilling PaperlessBilling	paymentmethod PaymentMethod	monthlycharges MonthlyCharges	totalcharges TotalCharges	churn Churn
CUST0000	Male		No	Yes	23	No	No phone service	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	Yes	Bank transfer	49.85	1146.55	No
CUST0001	Female		Yes	No	43	No	No phone service	DSL	Yes	No	Yes	No	Yes	No	Month-to-month	No	Mailed check	100.7	4330.1	Yes
CUST0002	Male	1	No	No	51	Yes	No	DSL	No	Yes	Yes	Yes	No	No	One year	No	Electronic check	97.33	4963.83	Yes
CUST0003	Male	1	No	No	72	Yes	Yes	DSL	Yes	No	Yes	No	No	No	Month-to-month	No	Credit card	101.38	7299.36	No
CUST0004	Male	1	No	No	25	Yes	Yes	DSL	No	No	No	Yes	No	Yes	Month-to-month	No	Electronic check	52.22	1305.5	Yes
CUST0005	Female		Yes	No	35	Yes	No	DSL	No	No	No	Yes	Yes	Yes	One year	No	Credit card	116.96	4093.6	No
CUST0006	Male		Yes	No	17	No	No phone service	DSL	No	No	No	Yes	No	Yes	One year	Yes	Bank transfer	91.53	1556.01	Yes
CUST0007	Male		Yes	Yes	18	Yes	No	DSL	No	Yes	Yes	Yes	No	Yes	One year	No	Mailed check	26.52	477.36	Yes
CUST0008	Male		No	No	27	No	No phone service	DSL	Yes	No	No	Yes	No	No	One year	No	Mailed check	67.77	1829.79	Yes
CUST0009	Female		No	No	15	No	No phone service	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	One year	No	Electronic check	86.45	1296.75	Yes


CREATE TABLE customer_churn_data (
  "customerid" VARCHAR,
  "gender" VARCHAR,
  "seniorcitizen" BIGINT,
  "partner" VARCHAR,
  "dependents" VARCHAR,
  "tenure" BIGINT,
  "phoneservice" VARCHAR,
  "multiplelines" VARCHAR,
  "internetservice" VARCHAR,
  "onlinesecurity" VARCHAR,
  "onlinebackup" VARCHAR,
  "deviceprotection" VARCHAR,
  "techsupport" VARCHAR,
  "streamingtv" VARCHAR,
  "streamingmovies" VARCHAR,
  "contract" VARCHAR,
  "paperlessbilling" VARCHAR,
  "paymentmethod" VARCHAR,
  "monthlycharges" DOUBLE,
  "totalcharges" DOUBLE,
  "churn" VARCHAR
);