This project explores and analyzes Diwali sales data to derive meaningful business insights using Python and Pandas. The goal is to understand customer behavior, product performance, and regional performance to help businesses enhance their marketing strategies during festive seasons.
File: Diwali_Sales_Data.csv
Source: Hypothetical e-commerce dataset collected during Diwali season.
User_ID: Unique customer IDGender: Male / FemaleAge: Age group of customersOccupation: Profession categoryMarital_Status: 0 = Unmarried, 1 = MarriedProduct_ID: Unique ID of purchased productProduct_Category: Product segmentPurchase: Purchase amount (in βΉ)State: Region of the customer
- Clean and preprocess the dataset.
- Perform exploratory data analysis (EDA).
- Identify high-performing customer segments.
- Understand purchasing behavior based on:
- Age
- Gender
- State
- Product category
- Provide business recommendations based on findings.
- Python
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Jupyter Notebook
- Male customers contribute significantly more to total sales.
- Most purchases are made by customers aged 26β35.
- The top purchasing states include Uttar Pradesh, Maharashtra, and Karnataka.
- Specific product categories dominate sales β helping guide inventory and promotion decisions.
(π See the full analysis in Analysis.ipynb)