Python Pandas - Create a DateOffset and increment date

To create a DateOffset in Pandas, use the DateOffset() constructor to define time increments. This allows you to add or subtract specific periods like days, months, or years from datetime objects.

Syntax

DateOffset(days=0, months=0, years=0, hours=0, minutes=0, seconds=0)

Basic DateOffset Creation

First, import the required libraries and create a timestamp ?

from pandas.tseries.offsets import DateOffset
import pandas as pd

# Create a timestamp object
timestamp = pd.Timestamp('2021-09-11 02:30:55')
print("Original Timestamp:", timestamp)

Original Timestamp: 2021-09-11 02:30:55

Incrementing Months

Use the months parameter to add months to a timestamp ?

from pandas.tseries.offsets import DateOffset
import pandas as pd

timestamp = pd.Timestamp('2021-09-11 02:30:55')

# Add 2 months using DateOffset
new_date = timestamp + DateOffset(months=2)
print("After adding 2 months:", new_date)

After adding 2 months: 2021-11-11 02:30:55

Multiple Time Units

You can combine different time units in a single DateOffset ?

from pandas.tseries.offsets import DateOffset
import pandas as pd

timestamp = pd.Timestamp('2021-09-11 02:30:55')

# Add multiple units: 1 year, 2 months, 15 days
offset = DateOffset(years=1, months=2, days=15)
new_date = timestamp + offset
print("Combined offset result:", new_date)

Combined offset result: 2022-11-26 02:30:55

Common Use Cases

Conclusion

DateOffset provides flexible date arithmetic in Pandas. Use it to increment timestamps by specific time units like days, months, or years for time series operations.