Data Science · मराठी आवृत्ती

25.7 Practice, tip आणि close

By Ravindra Bagale

हे का शिकायचं?

एक city leaderboard + एक running total — दोन्ही काढून वाक्यात सांगा.

हे काय आहे?

Practice + quiz.

कसं करायचं?

उदाहरणं: copy करा आणि चालवा

हा code / output:

from pathlib import Path
import pandas as pd

Path("outputs").mkdir(exist_ok=True)
orders = pd.DataFrame({
    "order_id": [f"BLK-{i}" for i in range(1, 13)],
    "city": ["Pune", "Pune", "Nashik", "Kolhapur", "Solapur", "Pune",
             "Nashik", "Pune", "Nagpur", "Kolhapur", "Solapur", "Pune"],
    "order_date": pd.to_datetime(
        ["2026-10-20"] * 3 + ["2026-10-21"] * 3 + ["2026-10-22"] * 2
        + ["2026-10-23"] * 2 + ["2026-10-24"] * 2
    ),
    "amount_inr": [90, 210, 95, 180, 70, 220, 110, 150, 200, 340, 80, 210],
})
orders["rank_global"] = orders["amount_inr"].rank(ascending=False, method="dense")
orders["rank_city"] = (
    orders.groupby("city")["amount_inr"].rank(ascending=False, method="dense")
)
orders.to_csv("outputs/rank_cumsum_lab.csv", index=False)

daily = (
    orders.groupby("order_date", as_index=False)["amount_inr"]
    .sum()
    .rename(columns={"amount_inr": "gmv"})
    .sort_values("order_date")
)
daily["gmv_running"] = daily["gmv"].cumsum()
daily["gmv_roll3"] = daily["gmv"].rolling(3).mean()
print(orders.head())
print(daily)