Write a python code:

Question $6$: Segmenting Consumers of Bath Soap. $(20$ points$)$

Business Situation CRISA is an Asian market research agency that specializes in tracking consumer purchase behavior in consumer goods $($both durable and nondurable$).$ In one major research project, CRISA tracks numerous consumer product categories $($e$.$g$.,$detergents$),$ and, within each category, perhaps dozens of brands. To track purchase

behavior, CRISA constituted household panels in over $100$ cities and towns in India, covering most of the Indian urban market. The households were carefully selected using stratified sampling to ensure a representative sample; a subset of $600$ records is analyzed here. The strata were defined on the basis of socioeconomic status and the market $($a collection of cities$).$

CRISA has both transaction data $($each row is a transaction$)$ and household data $($each row is a household$),$ and for the household data it maintains the following information:

Demographics of the households $($updated annually$)$

Possession of durable goods $($car$,$ washing machine, etc., updated annually; an $$affluence index$$ is computed from this information$)$

Purchase data of product categories and brands $($updated monthly$)$

CRISA has two categories of clients: $(1)$ advertising agencies that subscribe to the database services, obtain updated data every month, and use the data to advise their clients on advertising and promotion strategies; $(2)$ consumer goods manufacturers, which monitor their market share using the CRISA database.

Key Problems

CRISA has traditionally segmented markets on the basis of purchaser demographics.

They would now like to segment the market based on two key sets of variables more directly related to the purchase process and to brand loyalty:

Purchase behavior $($volume$,$ frequency, susceptibility to discounts, and brand loyalty$)$

Basis of purchase $($price$,$ selling proposition$)$

Doing so would allow CRISA to gain information about what demographic attributes are associated with different purchase behaviors and degrees of brand loyalty, and thus deploy promotion budgets more effectively. More effective market segmentation would enable CRISA$$s clients $($in this case, a firm called IMRB$)$ to design more cost$-$effective promotions targeted at appropriate segments. Thus, multiple promotions could be

launched, each targeted at different market segments at different times of the year. This would result in a more cost$-$effective allocation of the promotion budget to different market segments. It would also enable IMRB to design more effective customer reward systems and thereby increase brand loyalty.

Data

The data in Table below profile each household, each row containing the data for one household.

Measuring Brand Loyalty

Several variables in this case measure aspects of brand loyalty. The number of different brands purchased by the customer is one measure of loyalty. However, a consumer who purchases one or two brands in quick succession, then settles on a third for a long streak, is different from a consumer who constantly switches back and forth among

three brands. Therefore, how often customers switch from one brand to another is another measure of loyalty. Yet a third perspective on the same issue is the proportion of purchases that go to different brands$$a consumer who spends $90\%$ of his or her purchase money on one brand is more loyal than a consumer who spends more equally

among several brands. All three of these components can be measured with the data in the purchase summary

worksheet.

Assignment

$1.$ Use k$-$means clustering to identify clusters of households based on:

A$.$ The variables that describe purchase behavior $($including brand loyalty$)$

B$.$ The variables that describe the basis for purchase

C$.$ The variables that describe both purchase behavior and basis of purchase

Note $1$: How should k be chosen? Think about how the clusters would be used. It is likely that the marketing efforts would support two to five different promotional approaches.

Note $2$: How should the percentages of total purchases comprised by various brands be treated? Isn$$t a customer who buys all brand A just as loyal as a customer who buys all brand B$?$ What will be the effect on any distance measure of using the brand share variables as is$?$ Consider using a single derived variable.

$2.$ Select what you think is the best segmentation and comment on the

characteristics $($demographic$,$ brand loyalty, and basis for purchase$)$ of these

clusters. $($This information would be used to guide the development of advertising and promotional campaigns.$)$

$3.$ Develop a model that classifies the data into these segments. Since this

information would most likely be used in targeting direct$-$mail promotions, it would be useful to select a market segment that would be defined as a success in theclassification model.

USE:

df $=$ dmba.load$\_$data$(\text{'}$BathSoapHousehold$.$csv$\text{'})$