5000
Total Order Items
23
Columns
11
Product Categories
51
Unique Products
Dataset Overview
| Joined Files: | orders, order_items, products |
|---|---|
| Date Span: | 2023-03-16 to 2024-11-04 |
| Missing Values: | 0 Missing |
Missing Values Check
| Column Name | Missing Count | Status |
|---|---|---|
order_id |
0 | Clean |
product_id |
0 | Clean |
quantity |
0 | Clean |
unit_price |
0 | Clean |
customer_id |
0 | Clean |
order_date |
0 | Clean |
promised_delivery_time |
0 | Clean |
actual_delivery_time |
0 | Clean |
delivery_status |
0 | Clean |
order_total |
0 | Clean |
payment_method |
0 | Clean |
delivery_partner_id |
0 | Clean |
store_id |
0 | Clean |
product_name |
0 | Clean |
category |
0 | Clean |
brand |
0 | Clean |
price |
0 | Clean |
mrp |
0 | Clean |
margin_percentage |
0 | Clean |
shelf_life_days |
0 | Clean |
min_stock_level |
0 | Clean |
max_stock_level |
0 | Clean |
total_sales |
0 | Clean |
Dataset Preview
| Order ID | Order Date | Product Name | Category | Quantity | Unit Price (₹) | Total Sales (₹) |
|---|---|---|---|---|---|---|
7164827734 |
2023-03-16 | Toothpaste | Personal Care | 2 | ₹88.43 | ₹176.86 |
4028266143 |
2023-03-16 | Wheat Flour | Grocery & Staples | 3 | ₹97.04 | ₹291.12 |
4376524554 |
2023-03-16 | Potatoes | Fruits & Vegetables | 2 | ₹416.65 | ₹833.30 |
208989475 |
2023-03-16 | Baby Wipes | Baby Care | 2 | ₹863.18 | ₹1726.36 |
757816226 |
2023-03-16 | Spinach | Fruits & Vegetables | 3 | ₹630.84 | ₹1892.52 |
168180571 |
2023-03-16 | Eggs | Dairy & Breakfast | 1 | ₹826.21 | ₹826.21 |
8469170680 |
2023-03-16 | Cough Syrup | Pharmacy | 1 | ₹90.56 | ₹90.56 |
5627902734 |
2023-03-16 | Baby Wipes | Baby Care | 3 | ₹426.72 | ₹1280.16 |
9653859166 |
2023-03-16 | Ice Cream | Instant & Frozen Food | 1 | ₹140.8 | ₹140.80 |
32613017 |
2023-03-17 | Pain Reliever | Pharmacy | 1 | ₹530.85 | ₹530.85 |
9458183390 |
2023-03-17 | Biscuits | Snacks & Munchies | 2 | ₹826.21 | ₹1652.42 |
6156638188 |
2023-03-17 | Dog Food | Pet Care | 1 | ₹831.1 | ₹831.10 |
4037647778 |
2023-03-17 | Detergent | Household Care | 2 | ₹162.67 | ₹325.34 |
4845607487 |
2023-03-17 | Cola | Cold Drinks & Juices | 1 | ₹422.23 | ₹422.23 |
6131815766 |
2023-03-17 | Cat Food | Pet Care | 2 | ₹215.65 | ₹431.30 |