Data preparation for MBA

The time series data was transformed to ensure that each row of data represented the customer's purchase basket. A sample of 500 active customers was selected for the analysis. The definition of active stipulated that the customer had used at least one product or service in the last 12 months and had at least one open product at the time of selection. Only customers with multiple products/services were chosen for the analysis.

The following is a snapshot of the customer data used for modeling:

Custid	Pr1	Pr2	Pr3	Pr4	Pr5
1	`Residential_Mortgage`	`Insurance`	`Personal_Current_Account`	`Savings_Account`	`Premium_Current_Account`
2	`Personal_Current_Account`	`Credit_Card`	`Premium_Current_Account`
3	`Locker`	`Residential_Mortgage`	`Insurance`	`Credit_Card`	`Currency_Services`
4	`Personal_Current_Account`	`Trading_Account`	`Business_Current_Account`	`Insurance`	`Credit_Card`
5	`Savings_Account`	`Personal_Current_Account`	`Credit_Card`	`Insurance`	`Personal_Loans`
6	`Savings_Account`	`Residential_Mortgage`	`Personal_Current_Account`	`Credit_Card`	`Insurance`
7	`Personal_Current_Account`	`Personal_Loans`	`Credit_Card`	`Savings_Account`	`BTL_Mortgage`
8	`Locker`	`Business_Current_Account`	`Trading_Account`
9	`Business_Current_Account`	`Currency_Services`	`Trading_Account`	`Credit_Card`	`BTL_Mortgage`
10	`Personal_Current_Account`	`Savings_Account`	`Credit_Card`	`BTL_Mortgage`	`Locker`

Figure 7.3: Snapshot of modeling data

Table of Contents for Data preparation for MBA

Create new playlist

Sign In

Sign Up

Table of Contents for
Data preparation for MBA