If you load a CSV with dates, Pandas usually reads them as simple strings (objects). To do real analysis like “Calculate monthly average sales“, you must convert them to datetime objects. This Pandas Datetime Guide will help you understand how to work with date and time data efficiently in Pandas.
Step 1: Convert to Datetime
import pandas as pd
df = pd.DataFrame({
'date': ['2025-01-01', '2025-01-02', '2025-01-05'],
'sales': [100, 150, 200]
})
# Currently 'date' is just a string (object)
print(df.info())
# Convert it!
df['date'] = pd.to_datetime(df['date'])Step 2: Set as Index
The real power comes when you make the date the index of your DataFrame. In fact, many Pandas Datetime Guide resources recommend this technique for best results.
df = df.set_index('date')
# Now you can slice by date easily!
print(df.loc['2025-01-01':'2025-01-04'])Step 3: Resampling (Group by Time)
Want to know total sales per month? Or average sales per week?
# 'M' means Month end frequency
monthly_sales = df.resample('M').sum()
print(monthly_sales)This is incredibly powerful for financial or scientific data.
Key Takeaways
- Pandas reads dates as strings, so you need to convert them into datetime objects for analysis.
- The second step is to set the date as the index of your DataFrame for better results.
- Resampling the data enables you to group by time, making it easy to calculate totals or averages.
- This technique is especially useful for financial and scientific data analysis.
