📦 Swiggy Instamart EDA & Visual Insights

📌 By Farha Kousar
⭐ If you find this useful, don't forget to give it a star on GitHub!

📘 Overview

This project presents an exploratory data analysis (EDA) on Swiggy Instamart’s order data. It covers merging order-level and product-level details, calculating KPIs like revenue and delivery efficiency, and visualizing patterns in sales, product demand, and delivery behavior.

📁 Dataset

• OrderDetails.csv: Includes individual product orders with quantity and price.
• Orders.csv: Includes order-level details such as customer, order time, delivery time, and status.

🔧 Technologies Used

• Python (v3.11+)
• pandas for data manipulation
• matplotlib & seaborn for visualizations
• Jupyter / Kaggle Notebook

🔍 Key Calculations & Features

✅ Data Processing

• Merged order_details and orders using OrderID
• Converted OrderDateTime and DeliveryDateTime to datetime
• Created DeliveryTime (mins) and TotalProductPrice fields

📊 KPIs & Metrics

Metric	Value Computed
🧾 Total Orders	nunique(OrderID)
👥 Total Customers	nunique(CustomerID)
💰 Total Revenue	sum(Quantity * PricePerUnit)
📦 Avg Order Value	mean(TotalProductPrice per Order)
⏱️ Avg Delivery Time	mean(DeliveryTime(mins))

📈 Visualizations

🛒 Top 10 Most Ordered Products

Bar chart of most frequently ordered products based on total quantity.

🚚 Delivery Status Distribution

Shows the proportion of delivered, pending, or canceled orders.

📅 Daily Revenue Trend

Line chart of total revenue by order date.

⏰ Hourly Order Volume

Line plot showing how order frequency varies by hour of day.

🔥 Heatmap: Orders by Day & Hour

Heatmap to visualize order density across weekdays and hours.

📌 How to Run

1. Clone the repository or open the Kaggle notebook:
   👉 Swiggy Instamart Kaggle Notebook

2. Run the cells sequentially — data is read from:

   pd.read_csv("/kaggle/input/orderdetails-csv/OrderDetails.csv")
   pd.read_csv("/kaggle/input/orders/Orders.csv")
   
   
   ## ✨ Author

• 👩‍💻 Farha Kousar
  
  
  

🌟 Support

If you found this helpful, please consider giving a ⭐ to the GitHub repository
and follow for more exciting data science projects.

📬 Feel free to connect with me for collaborations, internships, and project guidance.