22.2 to_csv आणि to_excel — Blinkit summaries

उदाहरण A — Build and export (fictional).

import pandas as pd
from pathlib import Path

Path("outputs").mkdir(exist_ok=True)

df = pd.DataFrame({
    "order_id": [
        "BLK-261022-001", "BLK-261022-002", "BLK-261022-003",
        "AMN-261022-004", "BLK-261022-005", "BLK-261022-006",
        "BLK-261022-007", "AMN-261022-008", "BLK-261022-009",
    ],
    "city": [
        "Pune", "Pune", "Solapur", "Nashik", "Kolhapur",
        "Nagpur", "Sambhaji Nagar", "Pune", "Nashik",
    ],
    "status": [
        "Delivered", "Cancelled", "Delivered", "Delivered", "Delivered",
        "Returned", "Delivered", "Delivered", "Delivered",
    ],
    "amount": [189, 90, 120, 95, 210, 150, 340, 72, 88],
    "customer": [
        "Ruhi Bagale", "Amir", "Zoya", "Salman", "Ravina",
        "Raja", "Rani", "Shraddha Bagale", "Shahrukh",
    ],
})

summary = (
    df.groupby(["city", "status"], as_index=False)
      .agg(orders=("order_id", "count"), gmv_inr=("amount", "sum"))
      .sort_values(["gmv_inr", "city"], ascending=[False, True])
)
summary.to_csv("outputs/city_status.csv", index=False)
summary.to_excel("outputs/city_status.xlsx", index=False, sheet_name="city_status")
print(summary)
print("delivered gmv check", df.loc[df["status"].eq("Delivered"), "amount"].sum())

What you should see. A tidy sheet: one row per city×status, columns orders and gmv_inr. Pune Delivered should not include the Cancelled ₹90.

उदाहरण B — Multi-sheet workbook for Ravindra.

daily = (
    df.assign(day="22-10-2026")
      .groupby(["day", "city"], as_index=False)
      .agg(orders=("order_id", "count"), gmv_inr=("amount", "sum"))
)
notes = pd.DataFrame({
    "note": [
        "Fictional sample for learning only.",
        "GMV = sum of amount; confirm status filter with ops.",
        "Contact for questions: analyst@example.com",
    ]
})
with pd.ExcelWriter("outputs/blinkit_friday_pack.xlsx", engine="openpyxl") as xlw:
    summary.to_excel(xlw, sheet_name="city_status", index=False)
    daily.to_excel(xlw, sheet_name="daily_city", index=False)
    notes.to_excel(xlw, sheet_name="notes", index=False)

उदाहरण C — CSV for systems; Excel for people.

# UTF-8 CSV for pipelines / pandas peers
summary.to_csv("outputs/city_status_utf8.csv", index=False, encoding="utf-8")
# Excel-friendly CSV on some Windows setups (only if a peer asks)
summary.to_csv("outputs/city_status_utf8_sig.csv", index=False, encoding="utf-8-sig")

Prefer utf-8 by default. Use utf-8-sig when a colleague’s Excel mangles Marathi city notes (if you ever add them).