Walmart is an American multinational retail corporation that operates a chain of supercenters, discount departmental stores, and grocery stores in the United States. Walmart has more than 100 million customers worldwide.
The Management team at Walmart Inc. wants to analyze the customer purchase behaviour (specifically, purchase amount) against the customerโs gender and the various other factors to help the business make better decisions. They want to understand if the spending habits differ between male and female customers: Do women spend more on Black Friday than men? (Assume 50 million customers are male and 50 million are female).
Dataset link: https://d2beiqkhq929f0.cloudfront.net/public_assets/assets/000/001/293/original/walmart_data.csv?1641285094
The company collected the transactional data of customers who purchased products from Walmart Stores during Black Friday. The dataset has the following features:
| Features | description |
|---|---|
| User_ID | User ID |
| Product_ID | Product ID |
| Gender | Sex of User |
| Age | Age in bins |
| Occupation | Occupation(Masked) |
| City_Category | Category of the City (A,B,C) |
| StayInCurrentCityYears | Number of years stay in the current city |
| Marital_Status | Marital Status |
| ProductCategory | Product Category (Masked) |
| Purchase | Purchase Amount |
Analyzed 550,068 Walmart customer transactions focusing on demographic and purchase data.
๐๐๐ฒ ๐๐๐ญ๐ซ๐ข๐๐ฌ:Assessed spending patterns by gender, age, marital status, and product category.
๐๐๐ง๐๐๐ซ ๐๐ง๐๐ฅ๐ฒ๐ฌ๐ข๐ฌ:75% of customers were male, with males spending more than females.
๐๐ ๐ ๐๐ซ๐จ๐ฎ๐ฉ ๐๐ง๐ฌ๐ข๐ ๐ก๐ญ๐ฌ: 26-35 age group had the highest purchases at 39.92%, followed by 36-45 at 20%.
๐๐ซ๐จ๐๐ฎ๐๐ญ ๐๐ซ๐๐๐๐ซ๐๐ง๐๐๐ฌ: Product category 5 was the most popular, followed by categories 1 and 8.
๐๐ญ๐๐ญ๐ข๐ฌ๐ญ๐ข๐๐๐ฅ ๐๐ง๐ฌ๐ข๐ ๐ก๐ญ๐ฌ: Married customers spent 8.8% less than unmarried customers.
๐๐จ๐ง๐๐ข๐๐๐ง๐๐ ๐๐ง๐ญ๐๐ซ๐ฏ๐๐ฅ๐ฌ: Males spent between 895,617 and 955,070, while females spent between 673,254 and 750,794.
๐๐๐ญ๐ข๐จ๐ง๐๐๐ฅ๐ ๐๐ง๐ฌ๐ข๐ ๐ก๐ญ๐ฌ: Suggested targeted marketing for the 26-35 age group, popular products, and adjustments based on gender and marital status.
๐๐๐๐ก ๐๐ญ๐๐๐ค:Python (Data Analysis, Visualization).