Skip to content

Insurance companies invest a lot of time and money into optimizing their pricing and accurately estimating the likelihood that customers will make a claim. In many countries insurance it is a legal requirement to have car insurance in order to drive a vehicle on public roads, so the market is very large!

Knowing all of this, On the Road car insurance have requested your services in building a model to predict whether a customer will make a claim on their insurance during the policy period. As they have very little expertise and infrastructure for deploying and monitoring machine learning models, they've asked you to use simple Logistic Regression, identifying the single feature that results in the best performing model, as measured by accuracy.

They have supplied you with their customer data as a csv file called car_insurance.csv, along with a table detailing the column names and descriptions below.

The dataset

ColumnDescription
idUnique client identifier
ageClient's age:
  • 0: 16-15
  • 1: 26-39
  • 2: 40-64
  • 3: 65+
genderClient's gender:
  • 0: Female
  • 1: Male
driving_experienceYears the client has been driving:
  • 0: 0-9
  • 1: 10-19
  • 2: 20-29
  • 3: 30+
educationClient's level of education:
  • 0: No education
  • 1: High school
  • 2: University
incomeClient's income level:
  • 0: Poverty
  • 1: Working class
  • 2: Middle class
  • 3: Upper class
credit_scoreClient's credit score (between zero and one)
vehicle_ownershipClient's vehicle ownership status:
  • 0: Does not own their vehilce (paying off finance)
  • 1: Owns their vehicle
vehcile_yearYear of vehicle registration:
  • 0: Before 2015
  • 1: 2015 or later
marriedClient's marital status:
  • 0: Not married
  • 1: Married
childrenClient's number of children
postal_codeClient's postal code
annual_mileageNumber of miles driven by the client each year
vehicle_typeType of car:
  • 0: Sedan
  • 1: Sports car
speeding_violationsTotal number of speeding violations received by the client
duisNumber of times the client has been caught driving under the influence of alcohol
past_accidentsTotal number of previous accidents the client has been involved in
outcomeWhether the client made a claim on their car insurance (response variable):
  • 0: No claim
  • 1: Made a claim
# Import required modules
import pandas as pd
import numpy as np
from statsmodels.formula.api import logit

# Start coding!
car_insurance = pd.read_csv("car_insurance.csv")
car_insurance.head()
pip install category_encoders
car_insurance.info()
#Get the length of the dataframe
df_len = len(car_insurance)

#Iterate over each column of the dataframe
for col in car_insurance.columns:
    miss_percent = (len(col) / df_len) * 100
    print(col, miss_percent)
#Drop rows with missing values since the missing data are not significant
car_insurance.dropna(inplace=True)
car_insurance.info()
corr_ =car_insurance.select_dtypes("number").corr()
display(corr_)
#Import seaborn as sns
import seaborn as sns
sns.heatmap(corr_)
#Get columns
car_insurance.columns
#Solit data into target vector (y) and feature matrix (X)

y = car_insurance["outcome"]
features = car_insurance.drop(columns=["outcome", "id", "duis", "postal_code"])
print(features.columns)
#Import modules for predictive model
from sklearn.linear_model import LogisticRegression
from sklearn.model_selection import train_test_split
from sklearn.model_selection import GridSearchCV
from sklearn.pipeline import make_pipeline
from category_encoders import OneHotEncoder
#Extract and save the training and test data
X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.3, random_state=42)
#Instatiate logistic regression
OHE = OneHotEncoder(use_cat_names=True)
logreg = LogisticRegression()
pipeline = make_pipeline(OHE, logreg)
#Fit and train model
pipeline.fit(X_train, y_train)
label = pipeline.predict(X_test)
label[:5]
#import performance metrics
from sklearn.metrics import accuracy_score
score = accuracy_score(y_test, label)
score