Telco Churn¶

This example uses the Telco Churn dataset to predict which Telco user is likely to churn; that is, customers that will likely stop using Telco. You can download the Jupyter Notebook of the study here.

Churn - customers that left within the last month
Services - services of each customer (phone, multiple lines, internet, online security, online backup, device protection, tech support, and streaming TV and movies)
Customer account information - how long they’ve been a customer, contract, payment method, paperless billing, monthly charges, and total charges
Customer demographics - gender, age range, and if they have partners and dependents

We will follow the data science cycle (Data Exploration - Data Preparation - Data Modeling - Model Evaluation - Model Deployment) to solve this problem.

Initialization¶

This example uses the following version of VerticaPy:

In [1]:

import verticapy as vp
vp.__version__

Out[1]:

'0.9.0'

Connect to Vertica. This example uses an existing connection called "VerticaDSN." For details on how to create a connection, use see the connection tutorial.

In [2]:

vp.connect("VerticaDSN")

Let's create a Virtual DataFrame of the dataset. The dataset is available here.

In [3]:

churn = vp.read_csv('data/churn.csv')
display(churn)

	Abc customerID Varchar(20)	Abc gender Varchar(20)	123 SeniorCitizen Int	010 Partner Boolean	010 Dependents Boolean	123 tenure Int	010 PhoneService Boolean	Abc MultipleLines Varchar(100)	Abc InternetService Varchar(22)	Abc OnlineSecurity Varchar(38)	Abc OnlineBackup Varchar(38)	Abc DeviceProtection Varchar(38)	Abc TechSupport Varchar(38)	Abc StreamingTV Varchar(38)	Abc StreamingMovies Varchar(38)	Abc Contract Varchar(28)	010 PaperlessBilling Boolean	Abc PaymentMethod Varchar(50)	123 MonthlyCharges Numeric(8,3)	123 TotalCharges Numeric(9,3)	010 Churn Boolean
1	0002-ORFBO	Female	0	✅	✅	9	✅	No	DSL	No	Yes	No	Yes	Yes	No	One year	✅	Mailed check	65.6	593.3	❌
2	0003-MKNFE	Male	0	❌	❌	9	✅	Yes	DSL	No	No	No	No	No	Yes	Month-to-month	❌	Mailed check	59.9	542.4	❌
3	0004-TLHLJ	Male	0	❌	❌	4	✅	No	Fiber optic	No	No	Yes	No	No	No	Month-to-month	✅	Electronic check	73.9	280.85	✅
4	0011-IGKFF	Male	1	✅	❌	13	✅	No	Fiber optic	No	Yes	Yes	No	Yes	Yes	Month-to-month	✅	Electronic check	98.0	1237.85	✅
5	0013-EXCHZ	Female	1	✅	❌	3	✅	No	Fiber optic	No	No	No	Yes	Yes	No	Month-to-month	✅	Mailed check	83.9	267.4	✅
6	0013-MHZWF	Female	0	❌	✅	9	✅	No	DSL	No	No	No	Yes	Yes	Yes	Month-to-month	✅	Credit card (automatic)	69.4	571.45	❌
7	0013-SMEOE	Female	1	✅	❌	71	✅	No	Fiber optic	Yes	Yes	Yes	Yes	Yes	Yes	Two year	✅	Bank transfer (automatic)	109.7	7904.25	❌
8	0014-BMAQU	Male	0	✅	❌	63	✅	Yes	Fiber optic	Yes	No	No	Yes	No	No	Two year	✅	Credit card (automatic)	84.65	5377.8	❌
9	0015-UOCOJ	Female	1	❌	❌	7	✅	No	DSL	Yes	No	No	No	No	No	Month-to-month	✅	Electronic check	48.2	340.35	❌
10	0016-QLJIS	Female	0	✅	✅	65	✅	Yes	DSL	Yes	Yes	Yes	Yes	Yes	Yes	Two year	✅	Mailed check	90.45	5957.9	❌
11	0017-DINOC	Male	0	❌	❌	54	❌	No phone service	DSL	Yes	No	No	Yes	Yes	No	Two year	❌	Credit card (automatic)	45.2	2460.55	❌
12	0017-IUDMW	Female	0	✅	✅	72	✅	Yes	Fiber optic	Yes	Yes	Yes	Yes	Yes	Yes	Two year	✅	Credit card (automatic)	116.8	8456.75	❌
13	0018-NYROU	Female	0	✅	❌	5	✅	No	Fiber optic	No	No	No	No	No	No	Month-to-month	✅	Electronic check	68.95	351.5	❌
14	0019-EFAEP	Female	0	❌	❌	72	✅	Yes	Fiber optic	Yes	Yes	Yes	No	Yes	No	Two year	✅	Bank transfer (automatic)	101.3	7261.25	❌
15	0019-GFNTW	Female	0	❌	❌	56	❌	No phone service	DSL	Yes	Yes	Yes	Yes	No	No	Two year	❌	Bank transfer (automatic)	45.05	2560.1	❌
16	0020-INWCK	Female	0	✅	✅	71	✅	Yes	Fiber optic	No	Yes	Yes	No	No	Yes	Two year	✅	Credit card (automatic)	95.75	6849.4	❌
17	0020-JDNXP	Female	0	✅	✅	34	❌	No phone service	DSL	Yes	No	Yes	Yes	Yes	Yes	One year	❌	Mailed check	61.25	1993.2	❌
18	0021-IKXGC	Female	1	❌	❌	1	✅	Yes	Fiber optic	No	No	No	No	No	No	Month-to-month	✅	Electronic check	72.1	72.1	❌
19	0022-TCJCI	Male	1	❌	❌	45	✅	No	DSL	Yes	No	Yes	No	No	Yes	One year	❌	Credit card (automatic)	62.7	2791.5	✅
20	0023-HGHWL	Male	1	❌	❌	1	❌	No phone service	DSL	No	No	No	No	No	No	Month-to-month	✅	Electronic check	25.1	25.1	✅
21	0023-UYUPN	Female	1	✅	❌	50	✅	Yes	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	One year	❌	Electronic check	25.2	1306.3	❌
22	0023-XUOPT	Female	0	✅	❌	13	✅	Yes	Fiber optic	No	Yes	Yes	No	Yes	No	Month-to-month	❌	Electronic check	94.1	1215.6	✅
23	0027-KWYKW	Female	0	✅	✅	23	✅	Yes	Fiber optic	No	No	No	No	Yes	No	Month-to-month	✅	Electronic check	83.75	1849.95	❌
24	0030-FNXPP	Female	0	❌	❌	3	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	❌	Mailed check	19.85	57.2	❌
25	0031-PVLZI	Female	0	✅	✅	4	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	❌	Mailed check	20.35	76.35	✅
26	0032-PGELS	Female	0	✅	✅	1	❌	No phone service	DSL	Yes	No	No	No	No	No	Month-to-month	❌	Bank transfer (automatic)	30.5	30.5	✅
27	0036-IHMOT	Female	0	✅	✅	55	✅	No	Fiber optic	No	Yes	Yes	Yes	Yes	Yes	One year	✅	Bank transfer (automatic)	103.7	5656.75	❌
28	0040-HALCW	Male	0	✅	✅	54	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Two year	❌	Credit card (automatic)	20.4	1090.6	❌
29	0042-JVWOJ	Male	0	❌	❌	26	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	One year	✅	Bank transfer (automatic)	19.6	471.85	❌
30	0042-RLHYP	Female	0	✅	✅	69	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Two year	❌	Bank transfer (automatic)	19.7	1396.9	❌
31	0048-LUMLS	Male	0	✅	✅	37	✅	No	Fiber optic	No	No	No	No	Yes	Yes	One year	❌	Credit card (automatic)	91.2	3247.55	❌
32	0048-PIHNL	Female	0	✅	❌	49	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	One year	❌	Bank transfer (automatic)	20.45	900.9	❌
33	0052-DCKON	Male	0	✅	❌	66	✅	Yes	Fiber optic	Yes	Yes	Yes	Yes	Yes	Yes	One year	❌	Bank transfer (automatic)	115.8	7942.15	❌
34	0052-YNYOT	Female	0	❌	❌	67	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	One year	❌	Electronic check	20.55	1343.4	❌
35	0056-EPFBG	Male	0	✅	✅	20	❌	No phone service	DSL	Yes	No	Yes	Yes	No	No	Two year	✅	Credit card (automatic)	39.4	825.4	❌
36	0057-QBUQH	Female	0	❌	✅	43	✅	Yes	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Two year	✅	Electronic check	25.1	1070.15	❌
37	0058-EVZWM	Female	0	✅	❌	55	✅	Yes	Fiber optic	Yes	No	No	No	Yes	No	Month-to-month	✅	Bank transfer (automatic)	89.8	4959.6	❌
38	0060-FUALY	Female	0	✅	❌	59	✅	Yes	Fiber optic	Yes	Yes	No	No	Yes	No	Month-to-month	✅	Electronic check	94.75	5597.65	❌
39	0064-SUDOG	Female	0	✅	✅	12	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Two year	❌	Bank transfer (automatic)	20.3	224.5	❌
40	0064-YIJGF	Male	0	✅	✅	27	✅	Yes	Fiber optic	No	No	No	No	No	No	Month-to-month	✅	Bank transfer (automatic)	75.75	1929.0	❌
41	0067-DKWBL	Male	1	❌	❌	2	✅	No	DSL	Yes	No	No	No	No	No	Month-to-month	✅	Electronic check	49.25	91.1	✅
42	0068-FIGTF	Female	0	❌	❌	27	✅	No	DSL	No	Yes	Yes	Yes	Yes	Yes	One year	❌	Mailed check	78.2	2078.95	❌
43	0071-NDAFP	Male	0	✅	✅	25	✅	Yes	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Two year	❌	Credit card (automatic)	25.5	630.6	❌
44	0074-HDKDG	Male	0	✅	✅	25	✅	No	DSL	Yes	Yes	Yes	No	No	No	One year	✅	Bank transfer (automatic)	61.6	1611.0	❌
45	0076-LVEPS	Male	0	❌	✅	29	❌	No phone service	DSL	Yes	Yes	Yes	Yes	No	No	Month-to-month	✅	Mailed check	45.0	1242.45	❌
46	0078-XZMHT	Male	0	✅	❌	72	✅	Yes	DSL	No	Yes	Yes	Yes	Yes	Yes	Two year	✅	Bank transfer (automatic)	85.15	6316.2	❌
47	0080-EMYVY	Female	0	❌	❌	14	✅	No	DSL	No	Yes	No	No	No	No	One year	❌	Credit card (automatic)	51.45	727.85	❌
48	0080-OROZO	Female	0	❌	❌	35	✅	No	Fiber optic	No	No	Yes	Yes	Yes	Yes	One year	✅	Electronic check	99.25	3532.0	❌
49	0082-LDZUE	Male	0	❌	❌	1	✅	No	DSL	No	No	No	No	No	No	Month-to-month	✅	Mailed check	44.3	44.3	❌
50	0082-OQIQY	Male	0	❌	❌	29	✅	No	Fiber optic	No	No	No	Yes	Yes	Yes	Month-to-month	✅	Electronic check	94.2	2607.6	❌
51	0083-PIVIK	Male	0	❌	❌	64	✅	Yes	DSL	Yes	Yes	Yes	Yes	Yes	No	One year	❌	Electronic check	81.25	5567.55	❌
52	0089-IIQKO	Female	0	✅	✅	39	✅	Yes	Fiber optic	No	No	No	Yes	Yes	Yes	Month-to-month	✅	Credit card (automatic)	99.95	3767.4	❌
53	0093-EXYQL	Female	1	❌	❌	40	✅	No	Fiber optic	No	No	No	No	Yes	Yes	Month-to-month	✅	Electronic check	91.55	3673.6	❌
54	0093-XWZFY	Male	0	❌	❌	40	✅	Yes	Fiber optic	No	Yes	Yes	No	Yes	Yes	Month-to-month	✅	Credit card (automatic)	104.5	4036.85	✅
55	0094-OIFMO	Female	1	❌	❌	11	✅	No	Fiber optic	No	Yes	No	No	Yes	Yes	Month-to-month	✅	Electronic check	95.0	1120.3	✅
56	0096-BXERS	Female	0	✅	❌	6	✅	Yes	DSL	No	No	No	No	No	No	Month-to-month	❌	Electronic check	50.35	314.55	❌
57	0096-FCPUF	Male	0	❌	❌	30	✅	Yes	DSL	Yes	No	No	No	No	Yes	Month-to-month	✅	Mailed check	64.5	1888.45	❌
58	0098-BOWSO	Male	0	❌	❌	27	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	✅	Electronic check	19.4	529.8	❌
59	0100-DUVFC	Male	1	✅	❌	70	✅	Yes	Fiber optic	No	Yes	Yes	No	Yes	Yes	One year	✅	Electronic check	104.8	7308.95	❌
60	0103-CSITQ	Female	0	✅	❌	57	✅	Yes	Fiber optic	No	Yes	Yes	Yes	Yes	Yes	One year	✅	Bank transfer (automatic)	109.4	6252.7	❌
61	0104-PPXDV	Male	0	✅	❌	58	✅	No	DSL	No	No	Yes	No	No	No	One year	❌	Credit card (automatic)	50.3	2878.55	❌
62	0106-GHRQR	Male	0	❌	❌	16	✅	Yes	DSL	No	Yes	Yes	No	No	Yes	Month-to-month	✅	Bank transfer (automatic)	71.4	1212.1	❌
63	0106-UGRDO	Female	0	✅	❌	69	✅	Yes	Fiber optic	Yes	Yes	Yes	Yes	Yes	Yes	Two year	✅	Electronic check	116.0	8182.85	❌
64	0107-WESLM	Male	0	❌	❌	1	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	✅	Electronic check	19.85	19.85	✅
65	0107-YHINA	Male	0	❌	✅	1	✅	Yes	Fiber optic	No	No	Yes	No	Yes	Yes	Month-to-month	✅	Electronic check	99.75	99.75	✅
66	0111-KLBQG	Male	1	✅	✅	32	✅	No	Fiber optic	No	Yes	No	No	Yes	Yes	Month-to-month	✅	Mailed check	93.95	2861.45	❌
67	0112-QAWRZ	Male	0	✅	✅	16	✅	Yes	Fiber optic	No	No	Yes	No	Yes	No	Month-to-month	✅	Bank transfer (automatic)	90.8	1442.2	❌
68	0112-QWPNC	Male	0	✅	❌	49	✅	Yes	DSL	Yes	No	Yes	Yes	Yes	Yes	One year	❌	Electronic check	84.35	4059.35	✅
69	0114-IGABW	Female	0	✅	❌	71	❌	No phone service	DSL	No	Yes	Yes	Yes	Yes	Yes	Two year	❌	Bank transfer (automatic)	58.25	4145.9	❌
70	0114-PEGZZ	Female	0	❌	❌	33	✅	Yes	Fiber optic	No	Yes	Yes	No	Yes	Yes	Month-to-month	❌	Electronic check	107.55	3645.5	❌
71	0114-RSRRW	Female	0	✅	❌	10	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	✅	Bank transfer (automatic)	19.95	187.75	❌
72	0115-TFERT	Male	0	✅	❌	21	✅	Yes	Fiber optic	No	Yes	Yes	Yes	Yes	Yes	Month-to-month	✅	Electronic check	111.2	2317.1	✅
73	0117-LFRMW	Male	0	✅	✅	37	❌	No phone service	DSL	Yes	Yes	Yes	No	No	No	Month-to-month	❌	Bank transfer (automatic)	40.2	1448.8	✅
74	0118-JPNOY	Female	1	❌	❌	26	✅	No	Fiber optic	Yes	No	No	No	Yes	No	Month-to-month	✅	Credit card (automatic)	85.8	2193.65	❌
75	0121-SNYRK	Male	0	❌	❌	50	❌	No phone service	DSL	Yes	No	No	Yes	No	No	One year	✅	Mailed check	35.4	1748.9	❌
76	0122-OAHPZ	Female	0	❌	❌	7	✅	Yes	Fiber optic	No	No	No	No	No	No	Month-to-month	✅	Electronic check	73.85	511.25	✅
77	0123-CRBRT	Female	0	✅	✅	61	✅	Yes	DSL	Yes	Yes	Yes	Yes	Yes	Yes	Two year	❌	Mailed check	88.1	5526.75	❌
78	0125-LZQXK	Male	0	❌	❌	15	✅	No	Fiber optic	No	No	Yes	Yes	Yes	Yes	Month-to-month	✅	Electronic check	101.35	1553.95	✅
79	0128-MKWSG	Female	0	❌	✅	26	❌	No phone service	DSL	Yes	No	No	Yes	No	Yes	Month-to-month	❌	Mailed check	45.8	1147.0	❌
80	0129-KPTWJ	Male	0	✅	❌	72	✅	No	Fiber optic	No	No	Yes	No	Yes	Yes	Month-to-month	✅	Electronic check	94.65	6747.35	❌
81	0129-QMPDR	Male	0	✅	✅	44	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	One year	✅	Bank transfer (automatic)	20.5	865.05	❌
82	0130-SXOUN	Male	0	❌	❌	66	✅	Yes	Fiber optic	No	Yes	No	No	No	Yes	Month-to-month	❌	Credit card (automatic)	89.4	5976.9	❌
83	0133-BMFZO	Female	0	❌	❌	2	✅	No	Fiber optic	Yes	Yes	No	Yes	No	No	Month-to-month	✅	Electronic check	86.25	181.65	✅
84	0134-XWXCE	Female	1	❌	❌	44	✅	No	DSL	No	No	Yes	Yes	Yes	Yes	One year	❌	Bank transfer (automatic)	74.85	3268.05	❌
85	0135-NMXAP	Female	0	❌	❌	12	✅	Yes	Fiber optic	No	Yes	No	No	Yes	No	Month-to-month	✅	Bank transfer (automatic)	89.75	1052.4	✅
86	0136-IFMYD	Male	1	✅	❌	69	✅	Yes	Fiber optic	No	Yes	Yes	Yes	Yes	Yes	Two year	✅	Electronic check	109.95	7634.25	❌
87	0137-OCGAB	Female	0	❌	❌	1	✅	Yes	Fiber optic	No	Yes	No	No	No	No	Month-to-month	✅	Mailed check	80.2	80.2	✅
88	0137-UDEUO	Female	0	❌	❌	3	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	❌	Mailed check	19.85	63.75	✅
89	0139-IVFJG	Female	0	✅	❌	2	✅	No	Fiber optic	Yes	Yes	No	No	Yes	No	Month-to-month	❌	Electronic check	90.35	190.5	❌
90	0141-YEAYS	Female	1	❌	❌	27	✅	Yes	Fiber optic	No	Yes	Yes	No	No	No	Month-to-month	✅	Bank transfer (automatic)	86.45	2401.05	❌
91	0142-GVYSN	Male	0	❌	❌	26	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Month-to-month	✅	Electronic check	20.3	511.25	❌
92	0147-ESWWR	Female	1	✅	❌	39	✅	Yes	Fiber optic	No	No	No	Yes	Yes	Yes	Month-to-month	✅	Electronic check	101.25	3949.15	❌
93	0148-DCDOS	Male	0	❌	❌	25	✅	Yes	Fiber optic	No	No	No	No	Yes	Yes	Month-to-month	✅	Bank transfer (automatic)	94.7	2362.1	✅
94	0151-ONTOV	Female	0	❌	❌	1	✅	No	Fiber optic	No	No	No	No	No	No	Month-to-month	❌	Mailed check	70.9	70.9	✅
95	0156-FVPTA	Male	0	✅	❌	22	✅	No	DSL	Yes	No	No	Yes	No	No	Month-to-month	✅	Electronic check	54.2	1152.7	✅
96	0164-APGRB	Female	0	❌	❌	72	✅	Yes	Fiber optic	Yes	Yes	Yes	Yes	Yes	Yes	Two year	✅	Electronic check	114.9	8496.7	❌
97	0164-XAIRP	Female	0	❌	❌	24	✅	No	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Two year	✅	Bank transfer (automatic)	19.55	470.2	❌
98	0168-XZKBB	Female	0	✅	❌	19	✅	Yes	Fiber optic	No	No	No	No	Yes	No	Month-to-month	✅	Electronic check	86.85	1564.4	❌
99	0174-QRVVY	Male	0	✅	✅	71	✅	Yes	No	No internet service	No internet service	No internet service	No internet service	No internet service	No internet service	Two year	❌	Credit card (automatic)	25.35	1847.55	❌
100	0177-PXBAT	Male	1	✅	❌	33	✅	Yes	Fiber optic	Yes	No	Yes	Yes	Yes	Yes	Month-to-month	✅	Bank transfer (automatic)	109.9	3694.7	❌

Rows: 1-100 | Columns: 21

Data Exploration and Preparation¶

Let's examine our data.

In [6]:

churn.describe(method = "categorical", unique = True)

Out[6]:

	dtype	count	top	top_percent	unique
"customerID"	varchar(20)	7043	0002-ORFBO	0.014	7043.0
"gender"	varchar(20)	7043	Male	50.476	2.0
"SeniorCitizen"	int	7043	0	83.785	2.0
"Partner"	boolean	7043	0	51.697	2.0
"Dependents"	boolean	7043	0	70.041	2.0
"tenure"	int	7043	1	8.704	73.0
"PhoneService"	boolean	7043	1	90.317	2.0
"MultipleLines"	varchar(100)	7043	No	48.133	3.0
"InternetService"	varchar(22)	7043	Fiber optic	43.959	3.0
"OnlineSecurity"	varchar(38)	7043	No	49.666	3.0
"OnlineBackup"	varchar(38)	7043	No	43.845	3.0
"DeviceProtection"	varchar(38)	7043	No	43.944	3.0
"TechSupport"	varchar(38)	7043	No	49.311	3.0
"StreamingTV"	varchar(38)	7043	No	39.898	3.0
"StreamingMovies"	varchar(38)	7043	No	39.543	3.0
"Contract"	varchar(28)	7043	Month-to-month	55.019	3.0
"PaperlessBilling"	boolean	7043	1	59.222	2.0
"PaymentMethod"	varchar(50)	7043	Electronic check	33.579	4.0
"MonthlyCharges"	numeric(8,3)	7043	20.05	0.866	1585.0
"TotalCharges"	numeric(9,3)	7032	[null]	0.156	6530.0
"Churn"	boolean	7043	0	73.463	2.0

Rows: 1-21 | Columns: 6

Several variables are categorical, and since they all have low cardinalities, we can compute their dummies. We can also convert all booleans to numeric.

In [7]:

for column in ["DeviceProtection", 
               "MultipleLines",
               "PaperlessBilling",
               "Churn",
               "TechSupport",
               "Partner",
               "StreamingTV",
               "OnlineBackup",
               "Dependents",
               "OnlineSecurity",
               "PhoneService",
               "StreamingMovies"]:
    churn[column].decode("Yes", 1, 0)
churn.one_hot_encode().drop(["customerID", 
                             "gender", 
                             "Contract", 
                             "PaymentMethod", 
                             "InternetService"])

Out[7]:

	123 SeniorCitizen Int	123 Partner Integer	123 Dependents Integer	123 tenure Int	123 PhoneService Integer	123 MultipleLines Integer	123 OnlineSecurity Integer	123 OnlineBackup Integer	123 DeviceProtection Integer	123 TechSupport Integer	123 StreamingTV Integer	123 StreamingMovies Integer	123 PaperlessBilling Integer	123 MonthlyCharges Numeric(8,3)	123 TotalCharges Numeric(9,3)	123 Churn Integer	123 gender_Female Bool	123 InternetService_DSL Bool	123 InternetService_Fiber_optic Bool	123 Contract_Month-to-month Bool	123 Contract_One_year Bool	123 Bool	123 Bool	123 PaymentMethod_Electronic_check Bool
1	0	1	1	9	1	0	0	1	0	1	1	0	1	65.6	593.3	0	1	1	0	0	1			0
2	0	0	0	9	1	1	0	0	0	0	0	1	0	59.9	542.4	0	0	1	0	1	0			0
3	0	0	0	4	1	0	0	0	1	0	0	0	1	73.9	280.85	1	0	0	1	1	0			1
4	1	1	0	13	1	0	0	1	1	0	1	1	1	98.0	1237.85	1	0	0	1	1	0			1
5	1	1	0	3	1	0	0	0	0	1	1	0	1	83.9	267.4	1	1	0	1	1	0			0
6	0	0	1	9	1	0	0	0	0	1	1	1	1	69.4	571.45	0	1	1	0	1	0			0
7	1	1	0	71	1	0	1	1	1	1	1	1	1	109.7	7904.25	0	1	0	1	0	0			0
8	0	1	0	63	1	1	1	0	0	1	0	0	1	84.65	5377.8	0	0	0	1	0	0			0
9	1	0	0	7	1	0	1	0	0	0	0	0	1	48.2	340.35	0	1	1	0	1	0			1
10	0	1	1	65	1	1	1	1	1	1	1	1	1	90.45	5957.9	0	1	1	0	0	0			0
11	0	0	0	54	0	0	1	0	0	1	1	0	0	45.2	2460.55	0	0	1	0	0	0			0
12	0	1	1	72	1	1	1	1	1	1	1	1	1	116.8	8456.75	0	1	0	1	0	0			0
13	0	1	0	5	1	0	0	0	0	0	0	0	1	68.95	351.5	0	1	0	1	1	0			1
14	0	0	0	72	1	1	1	1	1	0	1	0	1	101.3	7261.25	0	1	0	1	0	0			0
15	0	0	0	56	0	0	1	1	1	1	0	0	0	45.05	2560.1	0	1	1	0	0	0			0
16	0	1	1	71	1	1	0	1	1	0	0	1	1	95.75	6849.4	0	1	0	1	0	0			0
17	0	1	1	34	0	0	1	0	1	1	1	1	0	61.25	1993.2	0	1	1	0	0	1			0
18	1	0	0	1	1	1	0	0	0	0	0	0	1	72.1	72.1	0	1	0	1	1	0			1
19	1	0	0	45	1	0	1	0	1	0	0	1	0	62.7	2791.5	1	0	1	0	0	1			0
20	1	0	0	1	0	0	0	0	0	0	0	0	1	25.1	25.1	1	0	1	0	1	0			1
21	1	1	0	50	1	1	0	0	0	0	0	0	0	25.2	1306.3	0	1	0	0	0	1			1
22	0	1	0	13	1	1	0	1	1	0	1	0	0	94.1	1215.6	1	1	0	1	1	0			1
23	0	1	1	23	1	1	0	0	0	0	1	0	1	83.75	1849.95	0	1	0	1	1	0			1
24	0	0	0	3	1	0	0	0	0	0	0	0	0	19.85	57.2	0	1	0	0	1	0			0
25	0	1	1	4	1	0	0	0	0	0	0	0	0	20.35	76.35	1	1	0	0	1	0			0
26	0	1	1	1	0	0	1	0	0	0	0	0	0	30.5	30.5	1	1	1	0	1	0			0
27	0	1	1	55	1	0	0	1	1	1	1	1	1	103.7	5656.75	0	1	0	1	0	1			0
28	0	1	1	54	1	0	0	0	0	0	0	0	0	20.4	1090.6	0	0	0	0	0	0			0
29	0	0	0	26	1	0	0	0	0	0	0	0	1	19.6	471.85	0	0	0	0	0	1			0
30	0	1	1	69	1	0	0	0	0	0	0	0	0	19.7	1396.9	0	1	0	0	0	0			0
31	0	1	1	37	1	0	0	0	0	0	1	1	0	91.2	3247.55	0	0	0	1	0	1			0
32	0	1	0	49	1	0	0	0	0	0	0	0	0	20.45	900.9	0	1	0	0	0	1			0
33	0	1	0	66	1	1	1	1	1	1	1	1	0	115.8	7942.15	0	0	0	1	0	1			0
34	0	0	0	67	1	0	0	0	0	0	0	0	0	20.55	1343.4	0	1	0	0	0	1			1
35	0	1	1	20	0	0	1	0	1	1	0	0	1	39.4	825.4	0	0	1	0	0	0			0
36	0	0	1	43	1	1	0	0	0	0	0	0	1	25.1	1070.15	0	1	0	0	0	0			1
37	0	1	0	55	1	1	1	0	0	0	1	0	1	89.8	4959.6	0	1	0	1	1	0			0
38	0	1	0	59	1	1	1	1	0	0	1	0	1	94.75	5597.65	0	1	0	1	1	0			1
39	0	1	1	12	1	0	0	0	0	0	0	0	0	20.3	224.5	0	1	0