17. Practice Exercises with Answer Hints
17.3 Cleaning and Dates
Exercise E. Column Amount has values like "1,299" and "N/A". Produce a float column.
Hint E
str.replace(",", "") then pd.to_numeric(..., errors="coerce").
Exercise F. Parse 14-10-2026 19:30 as IST and flag hour ≥ 18.
Hint F
pd.to_datetime(..., dayfirst=True), dt.tz_localize("Asia/Kolkata"), then df["hour"] >= 18.