vDataFrame.bool_to_int

In [ ]:
vDataFrame.bool_to_int()

Converts all booleans vcolumns to integers.

Returns

vDataFrame : self

Example

In [130]:
from verticapy import vDataFrame
churn = vDataFrame("public.churn")
for column in ["DeviceProtection", 
               "MultipleLines", 
               "PaperlessBilling", 
               "Churn",
               "TechSupport",
               "Partner",
               "StreamingTV",
               "OnlineBackup",
               "Dependents",
               "OnlineSecurity",
               "PhoneService",
               "StreamingMovies"]:
    churn[column].apply("DECODE({}, 'Yes', True, False)")
display(churn)
Abc
customerID
Varchar(10)
Abc
gender
Varchar(6)
010
DeviceProtection
Boolean
Abc
Contract
Varchar(20)
010
MultipleLines
Boolean
010
PaperlessBilling
Boolean
010
Churn
Boolean
010
TechSupport
Boolean
Abc
PaymentMethod
Varchar(30)
010
Partner
Boolean
123
tenure
Int
123
TotalCharges
Float
Abc
InternetService
Varchar(20)
010
StreamingTV
Boolean
123
SeniorCitizen
Int
010
OnlineBackup
Boolean
010
Dependents
Boolean
123
MonthlyCharges
Float
010
OnlineSecurity
Boolean
010
PhoneService
Boolean
010
StreamingMovies
Boolean
10002-ORFBOFemale
❌
One year
❌
✅
❌
✅
Mailed check
✅
9593.3DSL
✅
0
✅
✅
65.6
❌
✅
❌
20003-MKNFEMale
❌
Month-to-month
✅
❌
❌
❌
Mailed check
❌
9542.4DSL
❌
0
❌
❌
59.9
❌
✅
✅
30004-TLHLJMale
✅
Month-to-month
❌
✅
✅
❌
Electronic check
❌
4280.85Fiber optic
❌
0
❌
❌
73.9
❌
✅
❌
40011-IGKFFMale
✅
Month-to-month
❌
✅
✅
❌
Electronic check
✅
131237.85Fiber optic
✅
1
✅
❌
98.0
❌
✅
✅
50013-EXCHZFemale
❌
Month-to-month
❌
✅
✅
✅
Mailed check
✅
3267.4Fiber optic
✅
1
❌
❌
83.9
❌
✅
❌
60013-MHZWFFemale
❌
Month-to-month
❌
✅
❌
✅
Credit card (automatic)
❌
9571.45DSL
✅
0
❌
✅
69.4
❌
✅
✅
70013-SMEOEFemale
✅
Two year
❌
✅
❌
✅
Bank transfer (automatic)
✅
717904.25Fiber optic
✅
1
✅
❌
109.7
✅
✅
✅
80014-BMAQUMale
❌
Two year
✅
✅
❌
✅
Credit card (automatic)
✅
635377.8Fiber optic
❌
0
❌
❌
84.65
✅
✅
❌
90015-UOCOJFemale
❌
Month-to-month
❌
✅
❌
❌
Electronic check
❌
7340.35DSL
❌
1
❌
❌
48.2
✅
✅
❌
100016-QLJISFemale
✅
Two year
✅
✅
❌
✅
Mailed check
✅
655957.9DSL
✅
0
✅
✅
90.45
✅
✅
✅
110017-DINOCMale
❌
Two year
❌
❌
❌
✅
Credit card (automatic)
❌
542460.55DSL
✅
0
❌
❌
45.2
✅
❌
❌
120017-IUDMWFemale
✅
Two year
✅
✅
❌
✅
Credit card (automatic)
✅
728456.75Fiber optic
✅
0
✅
✅
116.8
✅
✅
✅
130018-NYROUFemale
❌
Month-to-month
❌
✅
❌
❌
Electronic check
✅
5351.5Fiber optic
❌
0
❌
❌
68.95
❌
✅
❌
140019-EFAEPFemale
✅
Two year
✅
✅
❌
❌
Bank transfer (automatic)
❌
727261.25Fiber optic
✅
0
✅
❌
101.3
✅
✅
❌
150019-GFNTWFemale
✅
Two year
❌
❌
❌
✅
Bank transfer (automatic)
❌
562560.1DSL
❌
0
✅
❌
45.05
✅
❌
❌
160020-INWCKFemale
✅
Two year
✅
✅
❌
❌
Credit card (automatic)
✅
716849.4Fiber optic
❌
0
✅
✅
95.75
❌
✅
✅
170020-JDNXPFemale
✅
One year
❌
❌
❌
✅
Mailed check
✅
341993.2DSL
✅
0
❌
✅
61.25
✅
❌
✅
180021-IKXGCFemale
❌
Month-to-month
✅
✅
❌
❌
Electronic check
❌
172.1Fiber optic
❌
1
❌
❌
72.1
❌
✅
❌
190022-TCJCIMale
✅
One year
❌
❌
✅
❌
Credit card (automatic)
❌
452791.5DSL
❌
1
❌
❌
62.7
✅
✅
✅
200023-HGHWLMale
❌
Month-to-month
❌
✅
✅
❌
Electronic check
❌
125.1DSL
❌
1
❌
❌
25.1
❌
❌
❌
210023-UYUPNFemale
❌
One year
✅
❌
❌
❌
Electronic check
✅
501306.3No
❌
1
❌
❌
25.2
❌
✅
❌
220023-XUOPTFemale
✅
Month-to-month
✅
❌
✅
❌
Electronic check
✅
131215.6Fiber optic
✅
0
✅
❌
94.1
❌
✅
❌
230027-KWYKWFemale
❌
Month-to-month
✅
✅
❌
❌
Electronic check
✅
231849.95Fiber optic
✅
0
❌
✅
83.75
❌
✅
❌
240030-FNXPPFemale
❌
Month-to-month
❌
❌
❌
❌
Mailed check
❌
357.2No
❌
0
❌
❌
19.85
❌
✅
❌
250031-PVLZIFemale
❌
Month-to-month
❌
❌
✅
❌
Mailed check
✅
476.35No
❌
0
❌
✅
20.35
❌
✅
❌
260032-PGELSFemale
❌
Month-to-month
❌
❌
✅
❌
Bank transfer (automatic)
✅
130.5DSL
❌
0
❌
✅
30.5
✅
❌
❌
270036-IHMOTFemale
✅
One year
❌
✅
❌
✅
Bank transfer (automatic)
✅
555656.75Fiber optic
✅
0
✅
✅
103.7
❌
✅
✅
280040-HALCWMale
❌
Two year
❌
❌
❌
❌
Credit card (automatic)
✅
541090.6No
❌
0
❌
✅
20.4
❌
✅
❌
290042-JVWOJMale
❌
One year
❌
✅
❌
❌
Bank transfer (automatic)
❌
26471.85No
❌
0
❌
❌
19.6
❌
✅
❌
300042-RLHYPFemale
❌
Two year
❌
❌
❌
❌
Bank transfer (automatic)
✅
691396.9No
❌
0
❌
✅
19.7
❌
✅
❌
310048-LUMLSMale
❌
One year
❌
❌
❌
❌
Credit card (automatic)
✅
373247.55Fiber optic
✅
0
❌
✅
91.2
❌
✅
✅
320048-PIHNLFemale
❌
One year
❌
❌
❌
❌
Bank transfer (automatic)
✅
49900.9No
❌
0
❌
❌
20.45
❌
✅
❌
330052-DCKONMale
✅
One year
✅
❌
❌
✅
Bank transfer (automatic)
✅
667942.15Fiber optic
✅
0
✅
❌
115.8
✅
✅
✅
340052-YNYOTFemale
❌
One year
❌
❌
❌
❌
Electronic check
❌
671343.4No
❌
0
❌
❌
20.55
❌
✅
❌
350056-EPFBGMale
✅
Two year
❌
✅
❌
✅
Credit card (automatic)
✅
20825.4DSL
❌
0
❌
✅
39.4
✅
❌
❌
360057-QBUQHFemale
❌
Two year
✅
✅
❌
❌
Electronic check
❌
431070.15No
❌
0
❌
✅
25.1
❌
✅
❌
370058-EVZWMFemale
❌
Month-to-month
✅
✅
❌
❌
Bank transfer (automatic)
✅
554959.6Fiber optic
✅
0
❌
❌
89.8
✅
✅
❌
380060-FUALYFemale
❌
Month-to-month
✅
✅
❌
❌
Electronic check
✅
595597.65Fiber optic
✅
0
✅
❌
94.75
✅
✅
❌
390064-SUDOGFemale
❌
Two year
❌
❌
❌
❌
Bank transfer (automatic)
✅
12224.5No
❌
0
❌
✅
20.3
❌
✅
❌
400064-YIJGFMale
❌
Month-to-month
✅
✅
❌
❌
Bank transfer (automatic)
✅
271929.0Fiber optic
❌
0
❌
✅
75.75
❌
✅
❌
410067-DKWBLMale
❌
Month-to-month
❌
✅
✅
❌
Electronic check
❌
291.1DSL
❌
1
❌
❌
49.25
✅
✅
❌
420068-FIGTFFemale
✅
One year
❌
❌
❌
✅
Mailed check
❌
272078.95DSL
✅
0
✅
❌
78.2
❌
✅
✅
430071-NDAFPMale
❌
Two year
✅
❌
❌
❌
Credit card (automatic)
✅
25630.6No
❌
0
❌
✅
25.5
❌
✅
❌
440074-HDKDGMale
✅
One year
❌
✅
❌
❌
Bank transfer (automatic)
✅
251611.0DSL
❌
0
✅
✅
61.6
✅
✅
❌
450076-LVEPSMale
✅
Month-to-month
❌
✅
❌
✅
Mailed check
❌
291242.45DSL
❌
0
✅
✅
45.0
✅
❌
❌
460078-XZMHTMale
✅
Two year
✅
✅
❌
✅
Bank transfer (automatic)
✅
726316.2DSL
✅
0
✅
❌
85.15
❌
✅
✅
470080-EMYVYFemale
❌
One year
❌
❌
❌
❌
Credit card (automatic)
❌
14727.85DSL
❌
0
✅
❌
51.45
❌
✅
❌
480080-OROZOFemale
✅
One year
❌
✅
❌
✅
Electronic check
❌
353532.0Fiber optic
✅
0
❌
❌
99.25
❌
✅
✅
490082-LDZUEMale
❌
Month-to-month
❌
✅
❌
❌
Mailed check
❌
144.3DSL
❌
0
❌
❌
44.3
❌
✅
❌
500082-OQIQYMale
❌
Month-to-month
❌
✅
❌
✅
Electronic check
❌
292607.6Fiber optic
✅
0
❌
❌
94.2
❌
✅
✅
510083-PIVIKMale
✅
One year
✅
❌
❌
✅
Electronic check
❌
645567.55DSL
✅
0
✅
❌
81.25
✅
✅
❌
520089-IIQKOFemale
❌
Month-to-month
✅
✅
❌
✅
Credit card (automatic)
✅
393767.4Fiber optic
✅
0
❌
✅
99.95
❌
✅
✅
530093-EXYQLFemale
❌
Month-to-month
❌
✅
❌
❌
Electronic check
❌
403673.6Fiber optic
✅
1
❌
❌
91.55
❌
✅
✅
540093-XWZFYMale
✅
Month-to-month
✅
✅
✅
❌
Credit card (automatic)
❌
404036.85Fiber optic
✅
0
✅
❌
104.5
❌
✅
✅
550094-OIFMOFemale
❌
Month-to-month
❌
✅
✅
❌
Electronic check
❌
111120.3Fiber optic
✅
1
✅
❌
95.0
❌
✅
✅
560096-BXERSFemale
❌
Month-to-month
✅
❌
❌
❌
Electronic check
✅
6314.55DSL
❌
0
❌
❌
50.35
❌
✅
❌
570096-FCPUFMale
❌
Month-to-month
✅
✅
❌
❌
Mailed check
❌
301888.45DSL
❌
0
❌
❌
64.5
✅
✅
✅
580098-BOWSOMale
❌
Month-to-month
❌
✅
❌
❌
Electronic check
❌
27529.8No
❌
0
❌
❌
19.4
❌
✅
❌
590100-DUVFCMale
✅
One year
✅
✅
❌
❌
Electronic check
✅
707308.95Fiber optic
✅
1
✅
❌
104.8
❌
✅
✅
600103-CSITQFemale
✅
One year
✅
✅
❌
✅
Bank transfer (automatic)
✅
576252.7Fiber optic
✅
0
✅
❌
109.4
❌
✅
✅
610104-PPXDVMale
✅
One year
❌
❌
❌
❌
Credit card (automatic)
✅
582878.55DSL
❌
0
❌
❌
50.3
❌
✅
❌
620106-GHRQRMale
✅
Month-to-month
✅
✅
❌
❌
Bank transfer (automatic)
❌
161212.1DSL
❌
0
✅
❌
71.4
❌
✅
✅
630106-UGRDOFemale
✅
Two year
✅
✅
❌
✅
Electronic check
✅
698182.85Fiber optic
✅
0
✅
❌
116.0
✅
✅
✅
640107-WESLMMale
❌
Month-to-month
❌
✅
✅
❌
Electronic check
❌
119.85No
❌
0
❌
❌
19.85
❌
✅
❌
650107-YHINAMale
✅
Month-to-month
✅
✅
✅
❌
Electronic check
❌
199.75Fiber optic
✅
0
❌
✅
99.75
❌
✅
✅
660111-KLBQGMale
❌
Month-to-month
❌
✅
❌
❌
Mailed check
✅
322861.45Fiber optic
✅
1
✅
✅
93.95
❌
✅
✅
670112-QAWRZMale
✅
Month-to-month
✅
✅
❌
❌
Bank transfer (automatic)
✅
161442.2Fiber optic
✅
0
❌
✅
90.8
❌
✅
❌
680112-QWPNCMale
✅
One year
✅
❌
✅
✅
Electronic check
✅
494059.35DSL
✅
0
❌
❌
84.35
✅
✅
✅
690114-IGABWFemale
✅
Two year
❌
❌
❌
✅
Bank transfer (automatic)
✅
714145.9DSL
✅
0
✅
❌
58.25
❌
❌
✅
700114-PEGZZFemale
✅
Month-to-month
✅
❌
❌
❌
Electronic check
❌
333645.5Fiber optic
✅
0
✅
❌
107.55
❌
✅
✅
710114-RSRRWFemale
❌
Month-to-month
❌
✅
❌
❌
Bank transfer (automatic)
✅
10187.75No
❌
0
❌
❌
19.95
❌
✅
❌
720115-TFERTMale
✅
Month-to-month
✅
✅
✅
✅
Electronic check
✅
212317.1Fiber optic
✅
0
✅
❌
111.2
❌
✅
✅
730117-LFRMWMale
✅
Month-to-month
❌
❌
✅
❌
Bank transfer (automatic)
✅
371448.8DSL
❌
0
✅
✅
40.2
✅
❌
❌
740118-JPNOYFemale
❌
Month-to-month
❌
✅
❌
❌
Credit card (automatic)
❌
262193.65Fiber optic
✅
1
❌
❌
85.8
✅
✅
❌
750121-SNYRKMale
❌
One year
❌
✅
❌
✅
Mailed check
❌
501748.9DSL
❌
0
❌
❌
35.4
✅
❌
❌
760122-OAHPZFemale
❌
Month-to-month
✅
✅
✅
❌
Electronic check
❌
7511.25Fiber optic
❌
0
❌
❌
73.85
❌
✅
❌
770123-CRBRTFemale
✅
Two year
✅
❌
❌
✅
Mailed check
✅
615526.75DSL
✅
0
✅
✅
88.1
✅
✅
✅
780125-LZQXKMale
✅
Month-to-month
❌
✅
✅
✅
Electronic check
❌
151553.95Fiber optic
✅
0
❌
❌
101.35
❌
✅
✅
790128-MKWSGFemale
❌
Month-to-month
❌
❌
❌
✅
Mailed check
❌
261147.0DSL
❌
0
❌
✅
45.8
✅
❌
✅
800129-KPTWJMale
✅
Month-to-month
❌
✅
❌
❌
Electronic check
✅
726747.35Fiber optic
✅
0
❌
❌
94.65
❌
✅
✅
810129-QMPDRMale
❌
One year
❌
✅
❌
❌
Bank transfer (automatic)
✅
44865.05No
❌
0
❌
✅
20.5
❌
✅
❌
820130-SXOUNMale
❌
Month-to-month
✅
❌
❌
❌
Credit card (automatic)
❌
665976.9Fiber optic
❌
0
✅
❌
89.4
❌
✅
✅
830133-BMFZOFemale
❌
Month-to-month
❌
✅
✅
✅
Electronic check
❌
2181.65Fiber optic
❌
0
✅
❌
86.25
✅
✅
❌
840134-XWXCEFemale
✅
One year
❌
❌
❌
✅
Bank transfer (automatic)
❌
443268.05DSL
✅
1
❌
❌
74.85
❌
✅
✅
850135-NMXAPFemale
❌
Month-to-month
✅
✅
✅
❌
Bank transfer (automatic)
❌
121052.4Fiber optic
✅
0
✅
❌
89.75
❌
✅
❌
860136-IFMYDMale
✅
Two year
✅
✅
❌
✅
Electronic check
✅
697634.25Fiber optic
✅
1
✅
❌
109.95
❌
✅
✅
870137-OCGABFemale
❌
Month-to-month
✅
✅
✅
❌
Mailed check
❌
180.2Fiber optic
❌
0
✅
❌
80.2
❌
✅
❌
880137-UDEUOFemale
❌
Month-to-month
❌
❌
✅
❌
Mailed check
❌
363.75No
❌
0
❌
❌
19.85
❌
✅
❌
890139-IVFJGFemale
❌
Month-to-month
❌
❌
❌
❌
Electronic check
✅
2190.5Fiber optic
✅
0
✅
❌
90.35
✅
✅
❌
900141-YEAYSFemale
✅
Month-to-month
✅
✅
❌
❌
Bank transfer (automatic)
❌
272401.05Fiber optic
❌
1
✅
❌
86.45
❌
✅
❌
910142-GVYSNMale
❌
Month-to-month
❌
✅
❌
❌
Electronic check
❌
26511.25No
❌
0
❌
❌
20.3
❌
✅
❌
920147-ESWWRFemale
❌
Month-to-month
✅
✅
❌
✅
Electronic check
✅
393949.15Fiber optic
✅
1
❌
❌
101.25
❌
✅
✅
930148-DCDOSMale
❌
Month-to-month
✅
✅
✅
❌
Bank transfer (automatic)
❌
252362.1Fiber optic
✅
0
❌
❌
94.7
❌
✅
✅
940151-ONTOVFemale
❌
Month-to-month
❌
❌
✅
❌
Mailed check
❌
170.9Fiber optic
❌
0
❌
❌
70.9
❌
✅
❌
950156-FVPTAMale
❌
Month-to-month
❌
✅
✅
✅
Electronic check
✅
221152.7DSL
❌
0
❌
❌
54.2
✅
✅
❌
960164-APGRBFemale
✅
Two year
✅
✅
❌
✅
Electronic check
❌
728496.7Fiber optic
✅
0
✅
❌
114.9
✅
✅
✅
970164-XAIRPFemale
❌
Two year
❌
✅
❌
❌
Bank transfer (automatic)
❌
24470.2No
❌
0
❌
❌
19.55
❌
✅
❌
980168-XZKBBFemale
❌
Month-to-month
✅
✅
❌
❌
Electronic check
✅
191564.4Fiber optic
✅
0
❌
❌
86.85
❌
✅
❌
990174-QRVVYMale
❌
Two year
✅
❌
❌
❌
Credit card (automatic)
✅
711847.55No
❌
0
❌
✅
25.35
❌
✅
❌
1000177-PXBATMale
✅
Month-to-month
✅
✅
❌
✅
Bank transfer (automatic)
✅
333694.7Fiber optic
✅
1
❌
❌
109.9
✅
✅
✅
Rows: 1-100 of 7032 | Columns: 21
In [131]:
churn.bool_to_int()
Abc
customerID
Varchar(10)
Abc
gender
Varchar(6)
123
DeviceProtection
Int
Abc
Contract
Varchar(20)
123
MultipleLines
Int
123
PaperlessBilling
Int
123
Churn
Int
123
TechSupport
Int
Abc
PaymentMethod
Varchar(30)
123
Partner
Int
123
tenure
Int
123
TotalCharges
Float
Abc
InternetService
Varchar(20)
123
StreamingTV
Int
123
SeniorCitizen
Int
123
OnlineBackup
Int
123
Dependents
Int
123
MonthlyCharges
Float
123
OnlineSecurity
Int
123
PhoneService
Int
123
StreamingMovies
Int
10002-ORFBOFemale0One year0101Mailed check19593.3DSL101165.6010
20003-MKNFEMale0Month-to-month1000Mailed check09542.4DSL000059.9011
30004-TLHLJMale1Month-to-month0110Electronic check04280.85Fiber optic000073.9010
40011-IGKFFMale1Month-to-month0110Electronic check1131237.85Fiber optic111098.0011
50013-EXCHZFemale0Month-to-month0111Mailed check13267.4Fiber optic110083.9010
60013-MHZWFFemale0Month-to-month0101Credit card (automatic)09571.45DSL100169.4011
70013-SMEOEFemale1Two year0101Bank transfer (automatic)1717904.25Fiber optic1110109.7111
80014-BMAQUMale0Two year1101Credit card (automatic)1635377.8Fiber optic000084.65110
90015-UOCOJFemale0Month-to-month0100Electronic check07340.35DSL010048.2110
100016-QLJISFemale1Two year1101Mailed check1655957.9DSL101190.45111
110017-DINOCMale0Two year0001Credit card (automatic)0542460.55DSL100045.2100
120017-IUDMWFemale1Two year1101Credit card (automatic)1728456.75Fiber optic1011116.8111
130018-NYROUFemale0Month-to-month0100Electronic check15351.5Fiber optic000068.95010
140019-EFAEPFemale1Two year1100Bank transfer (automatic)0727261.25Fiber optic1010101.3110
150019-GFNTWFemale1Two year0001Bank transfer (automatic)0562560.1DSL001045.05100
160020-INWCKFemale1Two year1100Credit card (automatic)1716849.4Fiber optic001195.75011
170020-JDNXPFemale1One year0001Mailed check1341993.2DSL100161.25101
180021-IKXGCFemale0Month-to-month1100Electronic check0172.1Fiber optic010072.1010
190022-TCJCIMale1One year0010Credit card (automatic)0452791.5DSL010062.7111
200023-HGHWLMale0Month-to-month0110Electronic check0125.1DSL010025.1000
210023-UYUPNFemale0One year1000Electronic check1501306.3No010025.2010
220023-XUOPTFemale1Month-to-month1010Electronic check1131215.6Fiber optic101094.1010
230027-KWYKWFemale0Month-to-month1100Electronic check1231849.95Fiber optic100183.75010
240030-FNXPPFemale0Month-to-month0000Mailed check0357.2No000019.85010
250031-PVLZIFemale0Month-to-month0010Mailed check1476.35No000120.35010
260032-PGELSFemale0Month-to-month0010Bank transfer (automatic)1130.5DSL000130.5100
270036-IHMOTFemale1One year0101Bank transfer (automatic)1555656.75Fiber optic1011103.7011
280040-HALCWMale0Two year0000Credit card (automatic)1541090.6No000120.4010
290042-JVWOJMale0One year0100Bank transfer (automatic)026471.85No000019.6010
300042-RLHYPFemale0Two year0000Bank transfer (automatic)1691396.9No000119.7010
310048-LUMLSMale0One year0000Credit card (automatic)1373247.55Fiber optic100191.2011
320048-PIHNLFemale0One year0000Bank transfer (automatic)149900.9No000020.45010
330052-DCKONMale1One year1001Bank transfer (automatic)1667942.15Fiber optic1010115.8111
340052-YNYOTFemale0One year0000Electronic check0671343.4No000020.55010
350056-EPFBGMale1Two year0101Credit card (automatic)120825.4DSL000139.4100
360057-QBUQHFemale0Two year1100Electronic check0431070.15No000125.1010
370058-EVZWMFemale0Month-to-month1100Bank transfer (automatic)1554959.6Fiber optic100089.8110
380060-FUALYFemale0Month-to-month1100Electronic check1595597.65Fiber optic101094.75110
390064-SUDOGFemale0Two year0000Bank transfer (automatic)112224.5No000120.3010
400064-YIJGFMale0Month-to-month1100Bank transfer (automatic)1271929.0Fiber optic000175.75010
410067-DKWBLMale0Month-to-month0110Electronic check0291.1DSL010049.25110
420068-FIGTFFemale1One year0001Mailed check0272078.95DSL101078.2011
430071-NDAFPMale0Two year1000Credit card (automatic)125630.6No000125.5010
440074-HDKDGMale1One year0100Bank transfer (automatic)1251611.0DSL001161.6110
450076-LVEPSMale1Month-to-month0101Mailed check0291242.45DSL001145.0100
460078-XZMHTMale1Two year1101Bank transfer (automatic)1726316.2DSL101085.15011
470080-EMYVYFemale0One year0000Credit card (automatic)014727.85DSL001051.45010
480080-OROZOFemale1One year0101Electronic check0353532.0Fiber optic100099.25011
490082-LDZUEMale0Month-to-month0100Mailed check0144.3DSL000044.3010
500082-OQIQYMale0Month-to-month0101Electronic check0292607.6Fiber optic100094.2011
510083-PIVIKMale1One year1001Electronic check0645567.55DSL101081.25110
520089-IIQKOFemale0Month-to-month1101Credit card (automatic)1393767.4Fiber optic100199.95011
530093-EXYQLFemale0Month-to-month0100Electronic check0403673.6Fiber optic110091.55011
540093-XWZFYMale1Month-to-month1110Credit card (automatic)0404036.85Fiber optic1010104.5011
550094-OIFMOFemale0Month-to-month0110Electronic check0111120.3Fiber optic111095.0011
560096-BXERSFemale0Month-to-month1000Electronic check16314.55DSL000050.35010
570096-FCPUFMale0Month-to-month1100Mailed check0301888.45DSL000064.5111
580098-BOWSOMale0Month-to-month0100Electronic check027529.8No000019.4010
590100-DUVFCMale1One year1100Electronic check1707308.95Fiber optic1110104.8011
600103-CSITQFemale1One year1101Bank transfer (automatic)1576252.7Fiber optic1010109.4011
610104-PPXDVMale1One year0000Credit card (automatic)1582878.55DSL000050.3010
620106-GHRQRMale1Month-to-month1100Bank transfer (automatic)0161212.1DSL001071.4011
630106-UGRDOFemale1Two year1101Electronic check1698182.85Fiber optic1010116.0111
640107-WESLMMale0Month-to-month0110Electronic check0119.85No000019.85010
650107-YHINAMale1Month-to-month1110Electronic check0199.75Fiber optic100199.75011
660111-KLBQGMale0Month-to-month0100Mailed check1322861.45Fiber optic111193.95011
670112-QAWRZMale1Month-to-month1100Bank transfer (automatic)1161442.2Fiber optic100190.8010
680112-QWPNCMale1One year1011Electronic check1494059.35DSL100084.35111
690114-IGABWFemale1Two year0001Bank transfer (automatic)1714145.9DSL101058.25001
700114-PEGZZFemale1Month-to-month1000Electronic check0333645.5Fiber optic1010107.55011
710114-RSRRWFemale0Month-to-month0100Bank transfer (automatic)110187.75No000019.95010
720115-TFERTMale1Month-to-month1111Electronic check1212317.1Fiber optic1010111.2011
730117-LFRMWMale1Month-to-month0010Bank transfer (automatic)1371448.8DSL001140.2100
740118-JPNOYFemale0Month-to-month0100Credit card (automatic)0262193.65Fiber optic110085.8110
750121-SNYRKMale0One year0101Mailed check0501748.9DSL000035.4100
760122-OAHPZFemale0Month-to-month1110Electronic check07511.25Fiber optic000073.85010
770123-CRBRTFemale1Two year1001Mailed check1615526.75DSL101188.1111
780125-LZQXKMale1Month-to-month0111Electronic check0151553.95Fiber optic1000101.35011
790128-MKWSGFemale0Month-to-month0001Mailed check0261147.0DSL000145.8101
800129-KPTWJMale1Month-to-month0100Electronic check1726747.35Fiber optic100094.65011
810129-QMPDRMale0One year0100Bank transfer (automatic)144865.05No000120.5010
820130-SXOUNMale0Month-to-month1000Credit card (automatic)0665976.9Fiber optic001089.4011
830133-BMFZOFemale0Month-to-month0111Electronic check02181.65Fiber optic001086.25110
840134-XWXCEFemale1One year0001Bank transfer (automatic)0443268.05DSL110074.85011
850135-NMXAPFemale0Month-to-month1110Bank transfer (automatic)0121052.4Fiber optic101089.75010
860136-IFMYDMale1Two year1101Electronic check1697634.25Fiber optic1110109.95011
870137-OCGABFemale0Month-to-month1110Mailed check0180.2Fiber optic001080.2010
880137-UDEUOFemale0Month-to-month0010Mailed check0363.75No000019.85010
890139-IVFJGFemale0Month-to-month0000Electronic check12190.5Fiber optic101090.35110
900141-YEAYSFemale1Month-to-month1100Bank transfer (automatic)0272401.05Fiber optic011086.45010
910142-GVYSNMale0Month-to-month0100Electronic check026511.25No000020.3010
920147-ESWWRFemale0Month-to-month1101Electronic check1393949.15Fiber optic1100101.25011
930148-DCDOSMale0Month-to-month1110Bank transfer (automatic)0252362.1Fiber optic100094.7011
940151-ONTOVFemale0Month-to-month0010Mailed check0170.9Fiber optic000070.9010
950156-FVPTAMale0Month-to-month0111Electronic check1221152.7DSL000054.2110
960164-APGRBFemale1Two year1101Electronic check0728496.7Fiber optic1010114.9111
970164-XAIRPFemale0Two year0100Bank transfer (automatic)024470.2No000019.55010
980168-XZKBBFemale0Month-to-month1100Electronic check1191564.4Fiber optic100086.85010
990174-QRVVYMale0Two year1000Credit card (automatic)1711847.55No000125.35010
1000177-PXBATMale1Month-to-month1101Bank transfer (automatic)1333694.7Fiber optic1100109.9111
Out[131]:
Rows: 1-100 of 7032 | Columns: 21

See Also

vDataFrame.astype Converts the vcolumns to the input types.