Dataset: Sample Telco Customer Churn Dataset

About this Dataset

Sample Telco Customer Churn Dataset

This is a sample dataset of Telco Customer Churn. It's inspired by the original dataset of "Telco customer churn (11.1.3+)" from IBM Business Analytics Community. This sample dataset is being cleaned and aggregated from the original dataset. It would be good for telco customer churn analysis or prediction by the classification or regression model for experiment and learning purposes.

Column Description:

customerID: A unique ID that identifies each customer.
gender: The customer’s gender: Male (1), Female (0).
SeniorCitizen: Indicates if the customer is 65 or older: No (0), Yes (1).
Partner: Service contract is resold by the partner: No (0), Yes (1).
Dependents: Indicates if the customer lives with any dependents: No (0), Yes (1).
Tenure: Indicates the total amount of months that the customer has been with the company.
PhoneService: Indicates if the customer subscribes to home phone service with the company: No (0), Yes (1).
MultipleLines: Indicates if the customer subscribes to multiple telephone lines with the company: No (0), Yes (1).
InternetService: Indicates if the customer subscribes to Internet service with the company: No (0), DSL (1), Fiber optic (2).
OnlineSecurity: Indicates if the customer subscribes to an additional online security service provided by the company: No (0), Yes (1), NA (2).
OnlineBackup: Indicates if the customer subscribes to an additional online backup service provided by the company: No (0), Yes (1), NA (2).
DeviceProtection: Indicates if the customer subscribes to an additional device protection plan for their Internet equipment provided by the company: No (0), Yes (1), NA (2).
TechSupport: Indicates if the customer subscribes to an additional technical support plan from the company with reduced wait times: No (0), Yes (1), NA (2).
StreamingTV: Indicates if the customer uses their Internet service to stream television programing from a third party provider: No (0), Yes (1), NA (2). The company does not charge an additional fee for this service.
StreamingMovies: Indicates if the customer uses their Internet service to stream movies from a third party provider: No (0), Yes (1), NA (2). The company does not charge an additional fee for this service.
Contract: Indicates the customer’s current contract type: Month-to-Month (0), One Year (1), Two Year (2).
PaperlessBilling: Indicates if the customer has chosen paperless billing: No (0), Yes (1).
PaymentMethod: Indicates how the customer pays their bill: Bank transfer - automatic (0), Credit card - automatic (1), Electronic cheque (2), Mailed cheque (3).
MonthlyCharges: Indicates the customer’s current total monthly charge for all their services from the company.
TotalCharges: Indicates the customer’s total charges.
Churn: Indicates if the customer churn or not: No (0), Yes (1).

Tables

Wa Fn Usec Telco Customer Churn R2

@kaggle.easonlai_sample_telco_customer_churn_dataset.wa_fn_usec_telco_customer_churn_r2

192.49 KB
7011 rows
21 columns


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

Wa Fn Usec Telco Customer Churn R2 Test

@kaggle.easonlai_sample_telco_customer_churn_dataset.wa_fn_usec_telco_customer_churn_r2_test

15.69 KB
21 rows
21 columns


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