Pandas — DateTime

Convert to datetime

import pandas as pd

df = pd.DataFrame({'date': ['2024-01-01', '2024-01-02', '2024-01-03']})
df['date'] = pd.to_datetime(df['date'])

Extract components

df['year'] = df['date'].dt.year
df['month'] = df['date'].dt.month
df['day'] = df['date'].dt.day
df['day_name'] = df['date'].dt.day_name()

Date arithmetic

df['next_week'] = df['date'] + pd.Timedelta(days=7)
df['days_diff'] = df['date'] - pd.Timestamp('2024-01-01')

Date range

dates = pd.date_range(start='2024-01-01', end='2024-12-31', freq='D')

Mini Practice

1. Convert to datetime
2. Extract components
3. Perform date arithmetic
4. Create date ranges

Up Next

Continue with Timedelta - Time differences.