| # | Product Name | Category | Actual Price | Discounted Price | Discount | Rating | Reviews | Performance |
|---|---|---|---|---|---|---|---|---|
| 1 | Amazon Basics USB-A Cable (6ft) | Electronics | ₹799 | ₹349 | 56% | ★★★★★ 4.6 | 322,145 | Best Seller |
| 2 | boAt Rockerz 450 Bluetooth Headphone | Electronics | ₹3,990 | ₹1,299 | 67% | ★★★★ 4.1 | 288,430 | Best Seller |
| 3 | AmazonBasics HDMI Cable 6ft | Computers | ₹699 | ₹329 | 53% | ★★★★★ 4.5 | 245,810 | Best Seller |
| 4 | Instant Pot Duo 7-in-1 Electric Pressure Cooker | Home & Kitchen | ₹9,999 | ₹6,499 | 35% | ★★★★★ 4.7 | 198,200 | Top Rated |
| 5 | TP-Link WiFi 6 AX3000 Smart WiFi Router | Computers | ₹7,499 | ₹4,199 | 44% | ★★★★ 4.3 | 172,560 | High Demand |
| 6 | Milton Thermosteel Flip Lid Flask 750ml | Home & Kitchen | ₹1,199 | ₹599 | 50% | ★★★★ 4.4 | 158,900 | High Demand |
| 7 | boAt Airdopes 141 Bluetooth Earbuds | Electronics | ₹4,499 | ₹1,299 | 71% | ★★★★ 4.0 | 144,320 | Best Seller |
| 8 | Pigeon by Stovekraft Amaze Plus 1800W Mixer Grinder | Home & Kitchen | ₹2,995 | ₹1,699 | 43% | ★★★★ 4.2 | 138,740 | High Demand |
| 9 | Portronics Konnect L 2.4A Micro USB Cable | Computers | ₹549 | ₹219 | 60% | ★★★★ 4.1 | 122,600 | High Demand |
| 10 | Lifelong LLNS1 Jump Rope with Cushion Handle | Sports | ₹499 | ₹249 | 50% | ★★★★ 4.3 | 115,480 | Growing |
Products with 40–60% discount have the highest average ratings (4.2+). Products discounted above 70% show lower ratings (3.7 avg), suggesting deep discounts may attract lower-quality segments.
Electronics & Computers account for 58% of all listed products and receive the deepest average discounts (54–58%), indicating highly competitive pricing in these categories.
82% of all products are rated between 4.0 and 5.0 stars, showing Amazon's review ecosystem naturally filters out consistently poor products over time.
Products with 100,000+ reviews maintain an average rating of 4.3 — significantly higher than newer products (avg 3.9), confirming that review volume is a strong quality proxy.
Items priced under ₹500 (post-discount) account for 31% of products but 47% of total review volume — low price-point items drive disproportionately high customer engagement.
Sellers should target the ₹500–₹2,000 discounted price band with 40–60% discounts to maximise both sales volume and customer satisfaction scores.
Downloaded amazon.csv from Kaggle (Amazon Sales Dataset). Dataset contains 1,465 rows × 16 columns including product name, category, prices, ratings, and review counts.
Used df.isnull().sum() to identify 24 missing values in rating_count. Removed ₹ symbols and commas using str.replace(), then cast price columns to float. Extracted main category using str.split('|').
Used df.describe(), groupby(), and value_counts() to compute category-level aggregates. Binned discount percentages using pd.cut() to build the distribution histogram.
Loaded cleaned data into MySQL. Ran GROUP BY category queries to compute average discount and rating. Used ORDER BY rating_count DESC LIMIT 10 to extract top reviewed products.
Built charts using matplotlib and seaborn in Jupyter Notebook. Exported the final interactive dashboard as HTML using Chart.js for portfolio presentation.
Correlated discount bands with average rating using df.corr(). Identified the 40–60% discount sweet spot and price sensitivity patterns from review volume distribution.