Ravindra BagaleCourses & study guides

10. Dates, Times (IST), and Text

10.2 IST Time Zone

# Localise naive timestamps as IST, then optionally convert
df["order_ts"] = df["order_ts"].dt.tz_localize("Asia/Kolkata")
print(df["order_ts"])

df["date"] = df["order_ts"].dt.date
df["hour"] = df["order_ts"].dt.hour
df["month"] = df["order_ts"].dt.month
df["weekday"] = df["order_ts"].dt.day_name()

Worked example. 15-10-2026 19:40 IST is evening Diwali rush in Nashik for Amir’s fictional order — hour 19 helps heatmap later.

Ravindra Bagale's Tip

Khup students Excel madhun CSV kadhun 01-02-2026 US format samjun chukatat. Maharashtra exports sathi dayfirst=True kiwa explicit format="%d-%m-%Y %H:%M". Format thambun liha. Dhyan rakho!