how do I get at the pandas.offsets object given an offset string

Question

Suppose I have an offset string 'BM' or '7W'
I know the answer for 'BM' is pd.offsets.BMonthEnd()
for '7W' is pd.offsets.Week(7)

Is there a generic solution in which I can pass a string and get the offset object?

for others reference http://pandas.pydata.org/pandas-docs/stable/timeseries.html#offset-aliases — Steven G, Oct 24 '16 at 16:47

root · Accepted Answer · 2016-10-24T17:13:57.727

12

It looks like pandas.tseries.frequencies.to_offset is what's used internally to convert from offset strings to a DateOffset object:

from pandas.tseries.frequencies import to_offset

freq = to_offset('7W')

You can also get it in more of a hackier way without any imports by taking the freq attribute of a trivial DateTimeIndex:

freq = pd.date_range('2016-03-14', periods=0, freq='7W').freq

Using either method:

print(freq)
<7 * Weeks: weekday=6>

print(type(freq))
<class 'pandas.tseries.offsets.Week'>

edited Oct 24 '16 at 17:13

answered Oct 24 '16 at 17:11

root

found it at the same time. deleting my answer. – Steven G Oct 24 '16 at 17:13
you helped me answer my other question http://stackoverflow.com/q/40222583/2336654 – piRSquared Oct 24 '16 at 17:20

1 Answers1