×
Customer Segmentation Analysis
• Data Cleaning and Preparation:
Converted date from integer to datetime, removed salsas and outliers from QVI_purchase_behaviour.csv and QVI_transaction_data.xlsx.
• Customer Segmentation Analysis:
Identified top sales contributors: Budget older families, Mainstream young singles/couples, and Mainstream retirees. Older families buy the most packets per customer; Mainstream young singles/couples have the largest population.
• Mainstream Young Singles/Couples Preferences:
Prefer Kettles chips and 175g packets across segments; 28% more likely to buy Tyrells chips and 32% more likely to choose 270g Twisties packets compared to other segments.
Python
EDA
Data Visualization
Data Analysis
Customer Segmentation