This project builds an AI-powered Pricing Intelligence & Demand Trade-Off Simulator using the Amazon India Electronics dataset.
The system integrates:
- 📈 Price Elasticity Modeling
- 🧠 NLP-Based Sentiment Intelligence
- 🎛 Interactive What-If Scenario Simulator
- 🤖 Generative AI Business Strategy Summaries
The goal is to transform raw pricing + review data into an actionable decision-support system for e-commerce pricing strategy.
E-commerce platforms frequently apply discounts without:
- Quantifying demand response
- Understanding customer perception
- Visualizing margin trade-offs
- Generating explainable pricing strategies
This project solves the problem by combining Machine Learning + NLP + Generative AI into a unified pricing intelligence engine.
Source: Amazon India Electronics Dataset
- USB Cables
- HDMI Cables
- Smart TVs
- WiFi Adapters
- Remote Controls
| Column | Purpose |
|---|---|
| discounted_price | Pricing analysis |
| actual_price | Margin trade-off |
| discount_percentage | Elasticity modeling |
| rating | Quality proxy |
| rating_count | Demand proxy |
| review_title + review_content | Sentiment analysis |
| category | Segmentation |
↓
Integrated Streamlit Dashboard
↓
Claude API → Auto-Generated Business Brief
Regression Model:
rating_count ~ discount_percentage + actual_price + rating
Outputs:
- Elasticity coefficients
- Demand sensitivity
- Category-level responsiveness
PSI = rating_count / discount_percentage
- High PSI → Strong organic demand
- Low PSI → Requires aggressive discounting
- VADER Sentiment Scoring
- Keyword Extraction (KeyBERT / TF-IDF)
- Sentiment vs Price Tier Mapping
- Red Flag Detection (High discount + Low sentiment)
Claude API is used to:
- Generate executive-level pricing recommendations
- Summarize customer review themes
- Convert model outputs into actionable strategy briefs
Example Output:
"Reducing discount from 60% to 40% decreases demand by 18% but improves margin by 12%. Sentiment remains strong, suggesting low pricing risk."
Built using Streamlit, the simulator allows users to:
- Select product category
- Adjust discount via slider
- View:
- Predicted demand change
- Revenue impact
- Margin trade-off
- Sentiment risk
- AI-generated pricing recommendation
This transforms static analytics into a real-time decision tool.
| Task | Tool |
|---|---|
| Data Cleaning | Python, Pandas |
| Elasticity Modeling | Scikit-learn, Statsmodels |
| Visualization | Matplotlib, Seaborn, Plotly |
| NLP | VADER, KeyBERT |
| Dashboard | Streamlit |
| AI Summaries | Claude API |
| Code Acceleration | Cursor + ChatGPT |
- Review bias (only customers who review are represented)
- rating_count used as proxy for demand (not exact sales)
- Linear regression assumes linear elasticity
- Generative AI outputs require prompt grounding
- Category imbalance may influence model strength
This system enables:
✔ Quantified discount strategy
✔ Margin-demand trade-off visibility
✔ Sentiment-aware pricing decisions
✔ Automated executive-ready summaries
✔ Category benchmarking
- Integrate real sales volume data
- Add time-series demand modeling
- Incorporate competitor pricing
- Implement non-linear ML models
- Deploy as SaaS pricing intelligence platform
- Select category
- Adjust discount slider
- Instantly see:
- % Demand Change
- % Margin Impact
- Sentiment Risk
- AI-Generated Strategy
The entire pricing trade-off becomes visible in under 30 seconds.
- Member 1 – Price Elasticity Analyst
- Member 2 – NLP Sentiment Analyst
- Member 3 – Scenario Simulator & Dashboard Builder
This project demonstrates the power of integrating:
- Econometric modeling
- NLP-based customer intelligence
- Interactive simulation
- Generative AI explanation
It converts raw e-commerce data into a Pricing Intelligence Engine that is:
📊 Quantifiable
🧠 Sentiment-aware
📈 Margin-conscious
🤖 Strategically explainable