Telco Customer Churn (11.1.3+)

Use Data Science to Reduce Churn and Boost Revenue

@kaggle.alfathterry_telco_customer_churn_11_1_3

Table List

1 table(479.43 KB)

Telco

@kaggle.alfathterry_telco_customer_churn_11_1_3.telco

479.43 KB
7043 rows
50 columns

customer_id Customer ID	gender Gender	age Age	under_30 Under 30	senior_citizen Senior Citizen	married Married	dependents Dependents	number_of_dependents Number Of Dependents	country Country	state State	city City	zip_code Zip Code	latitude Latitude	longitude Longitude	population Population	quarter Quarter	referred_a_friend Referred A Friend	number_of_referrals Number Of Referrals	tenure_in_months Tenure In Months	offer Offer	phone_service Phone Service	avg_monthly_long_distance_charges Avg Monthly Long Distance Charges	multiple_lines Multiple Lines	internet_service Internet Service	internet_type Internet Type	avg_monthly_gb_download Avg Monthly GB Download	online_security Online Security	online_backup Online Backup	device_protection_plan Device Protection Plan	premium_tech_support Premium Tech Support	streaming_tv Streaming TV	streaming_movies Streaming Movies	streaming_music Streaming Music	unlimited_data Unlimited Data	contract Contract	paperless_billing Paperless Billing	payment_method Payment Method	monthly_charge Monthly Charge	total_charges Total Charges	total_refunds Total Refunds	total_extra_data_charges Total Extra Data Charges	total_long_distance_charges Total Long Distance Charges	total_revenue Total Revenue	satisfaction_score Satisfaction Score	customer_status Customer Status	churn_label Churn Label	churn_score Churn Score	cltv CLTV	churn_category Churn Category	churn_reason Churn Reason
8779-QRDMV	Male	78	No	Yes	No	No		United States	California	Los Angeles	90022	34.02381	-118.156582	68701	Q3	No		1	nan	No		No	Yes	DSL	8	No	No	Yes	No	No	Yes	No	No	Month-to-Month	Yes	Bank Withdrawal	39.65	39.65		20		59.65	3	Churned	Yes	91	5433	Competitor	Competitor offered more data
7495-OOKFY	Female	74	No	Yes	Yes	Yes	1	United States	California	Los Angeles	90063	34.044271	-118.185237	55668	Q3	Yes	1	8	Offer E	Yes	48.85	Yes	Yes	Fiber Optic	17	No	Yes	No	No	No	No	No	Yes	Month-to-Month	Yes	Credit Card	80.65	633.3			390.8	1024.1	3	Churned	Yes	69	5302	Competitor	Competitor made better offer
1658-BYGOY	Male	71	No	Yes	No	Yes	3	United States	California	Los Angeles	90065	34.108833	-118.229715	47534	Q3	No		18	Offer D	Yes	11.33	Yes	Yes	Fiber Optic	52	No	No	No	No	Yes	Yes	Yes	Yes	Month-to-Month	Yes	Bank Withdrawal	95.45	1752.55	45.61		203.94	1910.88	2	Churned	Yes	81	3179	Competitor	Competitor made better offer
4598-XLKNJ	Female	78	No	Yes	Yes	Yes	1	United States	California	Inglewood	90303	33.936291	-118.332639	27778	Q3	Yes	1	25	Offer C	Yes	19.76	No	Yes	Fiber Optic	12	No	Yes	Yes	No	Yes	Yes	No	Yes	Month-to-Month	Yes	Bank Withdrawal	98.5	2514.5	13.43		494.00000000000006	2995.07	2	Churned	Yes	88	5337	Dissatisfaction	Limited range of services
4846-WHAFZ	Female	80	No	Yes	Yes	Yes	1	United States	California	Whittier	90602	33.972119	-118.020188	26265	Q3	Yes	1	37	Offer C	Yes	6.33	Yes	Yes	Fiber Optic	14	No	No	No	No	No	No	No	Yes	Month-to-Month	Yes	Bank Withdrawal	76.5	2868.15			234.21	3102.36	2	Churned	Yes	67	2793	Price	Extra data charges
4412-YLTKF	Female	72	No	Yes	No	Yes	1	United States	California	Pico Rivera	90660	33.989524	-118.089299	63288	Q3	No		27	Offer C	Yes	3.33	Yes	Yes	Fiber Optic	18	No	No	Yes	No	No	No	No	No	Month-to-Month	Yes	Bank Withdrawal	78.05	2135.5		10	89.91	2235.41	1	Churned	Yes	95	4638	Competitor	Competitor had better devices
0390-DCFDQ	Female	76	No	Yes	Yes	Yes	2	United States	California	Los Alamitos	90720	33.79499	-118.065591	21343	Q3	Yes	1	1	Offer E	Yes	15.28	No	Yes	Fiber Optic	30	No	No	No	No	No	No	No	Yes	Month-to-Month	Yes	Mailed Check	70.45	70.45			15.28	85.73	2	Churned	Yes	76	3964	Other	Don't know
3445-HXXGF	Male	66	No	Yes	Yes	No		United States	California	Sierra Madre	91024	34.168686	-118.057505	10558	Q3	Yes	6	58	Offer B	No		No	Yes	DSL	24	No	Yes	Yes	No	No	Yes	No	Yes	Month-to-Month	Yes	Bank Withdrawal	45.3	2651.2	40.95			2610.25	1	Churned	Yes	91	5444	Dissatisfaction	Service dissatisfaction
2656-FMOKZ	Female	70	No	Yes	No	Yes	2	United States	California	Pasadena	91106	34.139402	-118.128658	23742	Q3	No		15	Offer D	Yes	44.07	Yes	Yes	Fiber Optic	19	No	No	No	No	No	No	No	Yes	Month-to-Month	Yes	Mailed Check	74.45	1145.7			661.05	1806.75	2	Churned	Yes	91	5717	Dissatisfaction	Limited range of services
2070-FNEXE	Female	77	No	Yes	No	Yes	2	United States	California	Pasadena	91107	34.159007	-118.087353	32369	Q3	No		7	Offer E	Yes	26.95	No	Yes	Fiber Optic	18	Yes	No	No	No	No	No	No	No	Month-to-Month	No	Bank Withdrawal	76.45	503.6	11.05		188.65	681.2	2	Churned	Yes	81	4419	Price	Lack of affordable download/upload speed


CREATE TABLE telco (
  "customer_id" VARCHAR,
  "gender" VARCHAR,
  "age" BIGINT,
  "under_30" VARCHAR,
  "senior_citizen" VARCHAR,
  "married" VARCHAR,
  "dependents" VARCHAR,
  "number_of_dependents" BIGINT,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "population" BIGINT,
  "quarter" VARCHAR,
  "referred_a_friend" VARCHAR,
  "number_of_referrals" BIGINT,
  "tenure_in_months" BIGINT,
  "offer" VARCHAR,
  "phone_service" VARCHAR,
  "avg_monthly_long_distance_charges" DOUBLE,
  "multiple_lines" VARCHAR,
  "internet_service" VARCHAR,
  "internet_type" VARCHAR,
  "avg_monthly_gb_download" BIGINT,
  "online_security" VARCHAR,
  "online_backup" VARCHAR,
  "device_protection_plan" VARCHAR,
  "premium_tech_support" VARCHAR,
  "streaming_tv" VARCHAR,
  "streaming_movies" VARCHAR,
  "streaming_music" VARCHAR,
  "unlimited_data" VARCHAR,
  "contract" VARCHAR,
  "paperless_billing" VARCHAR,
  "payment_method" VARCHAR,
  "monthly_charge" DOUBLE,
  "total_charges" DOUBLE,
  "total_refunds" DOUBLE,
  "total_extra_data_charges" BIGINT,
  "total_long_distance_charges" DOUBLE,
  "total_revenue" DOUBLE,
  "satisfaction_score" BIGINT,
  "customer_status" VARCHAR,
  "churn_label" VARCHAR,
  "churn_score" BIGINT,
  "cltv" BIGINT,
  "churn_category" VARCHAR,
  "churn_reason" VARCHAR
);