Customers

Maintaining current customers is very important as acquiring new customers is very expensive compared to maintaining current customers. So to understand what rate the customers are leaving Churn is calculated. The dataset contains the customer churn which is calculated by the number of customers who leave the company during a given period. The target variable in the dataset is 'Churn'. There may be many reasons for customer churn like bad onboarding, poor customer service, less engagement, and others.

Data Set Characteristics:

Classification

Bivariate - Target Churn
Multivariate - Target Contract

Regression

Target

Total charges
Monthly charges

Number of Instances: 6499

Features

CustomerID
Gender
Senior Citizen
Partner
Dependents
Tenure
Phone Service
Multiple Lines
Internet Service
Online Security
Online Backup
Device Protection
Tech Support
Streaming TV
Streaming Movies
Contract
Paperless Billing
Payment Method
Monthly Charges
Total Charges
Churn

** Acknowledgment**

The dataset was provided by Squark

Tables

Churn Test

@kaggle.abhigm_churn_data_set.churn_test

28.94 KB
544 rows
20 columns


CREATE TABLE churn_test (
  "customerid" VARCHAR,
  "gender" VARCHAR,
  "senior_citizen" BIGINT,
  "partner" VARCHAR,
  "dependents" VARCHAR,
  "tenure" BIGINT,
  "phone_service" VARCHAR,
  "multiple_lines" VARCHAR,
  "internet_service" VARCHAR,
  "online_security" VARCHAR,
  "online_backup" VARCHAR,
  "device_protection" VARCHAR,
  "tech_support" VARCHAR,
  "streaming_tv" VARCHAR,
  "streaming_movies" VARCHAR,
  "contract" VARCHAR,
  "paperless_billing" VARCHAR,
  "payment_method" VARCHAR,
  "monthly_charges" DOUBLE,
  "total_charges" DOUBLE
);

Churn Train

@kaggle.abhigm_churn_data_set.churn_train

179.93 KB
6499 rows
21 columns


CREATE TABLE churn_train (
  "customerid" VARCHAR,
  "gender" VARCHAR,
  "senior_citizen" BIGINT,
  "partner" VARCHAR,
  "dependents" VARCHAR,
  "tenure" BIGINT,
  "phone_service" VARCHAR,
  "multiple_lines" VARCHAR,
  "internet_service" VARCHAR,
  "online_security" VARCHAR,
  "online_backup" VARCHAR,
  "device_protection" VARCHAR,
  "tech_support" VARCHAR,
  "streaming_tv" VARCHAR,
  "streaming_movies" VARCHAR,
  "contract" VARCHAR,
  "paperless_billing" VARCHAR,
  "payment_method" VARCHAR,
  "monthly_charges" DOUBLE,
  "total_charges" DOUBLE,
  "churn" VARCHAR
);