Customer Lifetime Value#

%load_ext autoreload
%autoreload 2
%matplotlib inline

Imports#

from fastai.vision.all import *
from aiking.data.external import * #We need to import this after fastai modules
import pandas as pd
from sklearn.ensemble import RandomForestRegressor
from sklearn.model_selection import cross_val_score
from sklearn.feature_selection import mutual_info_regression

Getting Dataset#

#kaggle datasets download -d pankajjsh06/ibm-watson-marketing-customer-value-data
path = untar_data("kaggle_datasets::pankajjsh06/ibm-watson-marketing-customer-value-data"); path
Path('/content/drive/MyDrive/PPV/S_Personal_Study/aiking/data/ibm-watson-marketing-customer-value-data')
path.ls()
(#1) [Path('/content/drive/MyDrive/PPV/S_Personal_Study/aiking/data/ibm-watson-marketing-customer-value-data/WA_Fn-UseC_-Marketing-Customer-Value-Analysis.csv')]
df = pd.read_csv(path/"WA_Fn-UseC_-Marketing-Customer-Value-Analysis.csv")
df.head().T
0 1 2 3 4
Customer BU79786 QZ44356 AI49188 WW63253 HB64268
State Washington Arizona Nevada California Washington
Customer Lifetime Value 2763.519279 6979.535903 12887.43165 7645.861827 2813.692575
Response No No No No No
Coverage Basic Extended Premium Basic Basic
Education Bachelor Bachelor Bachelor Bachelor Bachelor
Effective To Date 2/24/11 1/31/11 2/19/11 1/20/11 2/3/11
EmploymentStatus Employed Unemployed Employed Unemployed Employed
Gender F F F M M
Income 56274 0 48767 0 43836
Location Code Suburban Suburban Suburban Suburban Rural
Marital Status Married Single Married Married Single
Monthly Premium Auto 69 94 108 106 73
Months Since Last Claim 32 13 18 18 12
Months Since Policy Inception 5 42 38 65 44
Number of Open Complaints 0 0 0 0 0
Number of Policies 1 8 2 7 1
Policy Type Corporate Auto Personal Auto Personal Auto Corporate Auto Personal Auto
Policy Corporate L3 Personal L3 Personal L3 Corporate L2 Personal L1
Renew Offer Type Offer1 Offer3 Offer1 Offer1 Offer1
Sales Channel Agent Agent Agent Call Center Agent
Total Claim Amount 384.811147 1131.464935 566.472247 529.881344 138.130879
Vehicle Class Two-Door Car Four-Door Car Two-Door Car SUV Four-Door Car
Vehicle Size Medsize Medsize Medsize Medsize Medsize