Example Churn Data

Typical telco churn data 100k

@kaggle.ban7002_example_churn_data

Table List

1 table(6.29 MB)

Churn 100k

@kaggle.ban7002_example_churn_data.churn_100k

6.29 MB
101000 rows
35 columns

monthly_minutes Monthly Minutes	customerservicecalls CustomerServiceCalls	streaming_minutes Streaming Minutes	totalbilled TotalBilled	prevbalance PrevBalance	latepayments LatePayments	ip_address_asn Ip Address Asn	phone_area_code Phone Area Code	customer_reg_date Customer Reg Date	email_domain Email Domain	phonemodel PhoneModel	billing_city Billing City	billing_postal Billing Postal	billing_state Billing State	partner Partner	phoneservice PhoneService	multiplelines MultipleLines	streamingplan StreamingPlan	mobilehotspot MobileHotspot	wificallingtext WifiCallingText	onlinebackup OnlineBackup	device_protection Device Protection	number_phones Number Phones	contract_code Contract Code	currency_code Currency Code	maling_code Maling Code	paperlessbilling PaperlessBilling	paymentmethod PaymentMethod	event_timestamp EVENT TIMESTAMP	customerid CustomerId	billing_address Billing Address	gender Gender	networkspeed NetworkSpeed	senior_citizen Senior Citizen	event_label EVENT LABEL
22604	2	26525	285	47	5	16767	253	Wed Apr 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	yahoo.com	Samsung Galaxy S20 Ultra	West Shannonside	39120	Rhode Island	Yes	Yes	No	3GB	Yes	No	Yes	O	6	B	usd	H	No	Mailed Check	Sat Nov 30 2019 23:48:32 GMT+0000 (Coordinated Universal Time)	1-136-08562-9	5592 Gill Pine Suite 387	Female	5G	1	legit
17059	2	16887	201	45	5	53966	241	Sun Apr 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	Samsung Galaxy S10 / S10 Plus	Jacquelinetown	24469	Alaska	Yes	Yes	Yes	Unlmited	No	Yes	Yes	S	5	S	eur	V	Yes	Mailed Check	Sun Sep 27 2020 03:23:42 GMT+0000 (Coordinated Universal Time)	0-384-11264-1	5806 Kathleen Mount Suite 186	Male	5G		legit
25848	2	26783	264	44	6	19278	232	Sat Feb 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	OnePlus 8 Pro	North Luke	68797	North Dakota	Yes	Yes	Yes	Unlmited	No	Yes	No InternetService	V	5	W	cad	R	Yes	Credit Card	Sun Jan 12 2020 15:18:38 GMT+0000 (Coordinated Universal Time)	0-08-151665-7	5037 Allen Square Apt. 727	Male	5G	1	legit
22080	3	23649	274	49	6	16680	236	Wed Aug 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	yahoo.com	iPhone XS	West Coreyberg	19352	Nebraska	No	Yes	No	3GB	No	No	Yes	O	6	W	cad	N	No	Mailed Check	Fri Oct 09 2020 18:07:46 GMT+0000 (Coordinated Universal Time)	0-02-200816-0	841 Griffin Route Suite 824	Female	5G		legit
23871	3	7705	236	61	5	51308	243	Sat Nov 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	Samsung Galaxy S10e	Joshuachester	46999	Pennsylvania	Yes	Yes	Yes	3GB	No	Yes	Yes	C	7	W	cad	V	Yes	Electronic Check	Sat Oct 17 2020 22:27:42 GMT+0000 (Coordinated Universal Time)	0-87476-135-2	46185 Mejia Manor Apt. 558	Male	4Glte	1	legit
21721	1	14283	220	80	5	58166	247	Thu Jan 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	iPhone SE 2020	Port Kathleenfurt	44317	Connecticut	Yes	Yes	No	Unlmited	Yes	No	Yes	X	6	W	cad	W	No	Electronic Check	Tue May 26 2020 06:56:08 GMT+0000 (Coordinated Universal Time)	1-60368-464-6	2599 Cindy Drive Suite 395	Female	4Glte	1	legit
28098	3	12062	307	58	6	48219	243	Fri Jan 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	iPhone SE 2020	East Danielleside	40173	South Dakota	Yes	Yes	Yes	Unlmited	No	Yes	Yes	R	5	B	cad	W	Yes	Electronic Check	Mon Dec 02 2019 02:58:56 GMT+0000 (Coordinated Universal Time)	0-560-62140-X	78462 Evans Trafficway	Male	4Glte		legit
14368	1	19082	283	71	5	21944	250	Wed Jan 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	iPhone XS	New Brittanychester	15614	South Carolina	Yes	No	No	3GB	Yes	No	Yes	U	6	W	cad	U	No	Electronic Check	Wed Aug 19 2020 13:40:37 GMT+0000 (Coordinated Universal Time)	1-165-71063-3	608 Brett Ferry	Female	5G	1	legit
16432		14182	249	80	5	21352	231	Wed Jun 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	iPhone XS	Wangfort	49987	Michigan	No	No	No	3GB	Yes	Yes	Yes	U	4	W	cad	U	No	Electronic Check	Tue Apr 07 2020 03:32:48 GMT+0000 (Coordinated Universal Time)	0-7240-2305-4	33319 Parsons Orchard Apt. 153	Male	5G	1	legit
24091	2	20752	238	39	6	47892	234	Fri Feb 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	gmail.com	Samsung Galaxy S20 Ultra	Sethport	48952	Florida	Yes	Yes	Yes	3GB	No	No	Yes	C	5	F	cad	R	Yes	Mailed Check	Sun Oct 27 2019 18:37:24 GMT+0000 (Coordinated Universal Time)	0-691-69514-8	10937 Gonzales Ramp Apt. 039	Female	5G	1	legit


CREATE TABLE churn_100k (
  "monthly_minutes" DOUBLE,
  "customerservicecalls" DOUBLE,
  "streaming_minutes" DOUBLE,
  "totalbilled" DOUBLE,
  "prevbalance" DOUBLE,
  "latepayments" DOUBLE,
  "ip_address_asn" DOUBLE,
  "phone_area_code" DOUBLE,
  "customer_reg_date" TIMESTAMP,
  "email_domain" VARCHAR,
  "phonemodel" VARCHAR,
  "billing_city" VARCHAR,
  "billing_postal" DOUBLE,
  "billing_state" VARCHAR,
  "partner" VARCHAR,
  "phoneservice" VARCHAR,
  "multiplelines" VARCHAR,
  "streamingplan" VARCHAR,
  "mobilehotspot" VARCHAR,
  "wificallingtext" VARCHAR,
  "onlinebackup" VARCHAR,
  "device_protection" VARCHAR,
  "number_phones" DOUBLE,
  "contract_code" VARCHAR,
  "currency_code" VARCHAR,
  "maling_code" VARCHAR,
  "paperlessbilling" VARCHAR,
  "paymentmethod" VARCHAR,
  "event_timestamp" TIMESTAMP,
  "customerid" VARCHAR,
  "billing_address" VARCHAR,
  "gender" VARCHAR,
  "networkspeed" VARCHAR,
  "senior_citizen" DOUBLE,
  "event_label" VARCHAR
);