Working with Dates and Times in Pandas (DatetimeIndex)

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.

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.