Add n months to a pandas Period object?

Question

This seems like it should be easy but I can find no answer when googling. Say I have some variable k that is of type pandas.Period, and whose value is:

Period('2018-11', 'M')

How do I add n months to this variable. For example if n is 3 i would want k to be

Period('2019-02', 'M')

I have tried the following:

k.month = k.month + 12

But this fails saying:

AttributeError: attribute 'month' of 'pandas._libs.tslibs.period._Period' objects is not writable

cs95 · Accepted Answer · 2019-01-23T06:54:15.350

6

Add a pd.offsets.MonthEnd object:

pd.Period('2018-11', 'M') + pd.offsets.MonthEnd(3)

edited Jan 23 '19 at 06:54

answered Jan 23 '19 at 05:48

cs95

379,657
97
704
746

`from pandas.tseries.frequencies import to_offset` then `p + 3*to_offset('M')` – It_is_Chris Jan 23 '19 at 06:07
I think your answer is wrong, output should be `2019-02` – jezrael Jan 23 '19 at 06:08
Problem is `print (pd.Timedelta(3, unit='M')) 91 days 07:27:18` – jezrael Jan 23 '19 at 06:10
@jezrael not home to test, but perhaps DateOffset can be used instead of Timedelta? – cs95 Jan 23 '19 at 06:29
@coldspeed - yes, it should be way, but here overcomplicated. – jezrael Jan 23 '19 at 06:29
@jezrael Okay, I guessed there might be a better way, and I was right, your way is definitely simpler. I've upvoted it! – cs95 Jan 23 '19 at 06:33
@coldspeed - Thank you, I really do it too, but answer is wrong. :( – jezrael Jan 23 '19 at 06:34
1

@jezrael Aha, it was an `offset` object after all. Thank you for the edit :) – cs95 Jan 23 '19 at 06:54

score 5 · Answer 2 · answered Jan 23 '19 at 06:08

5

Because you add months to month period, only use +:

k = pd.Period('2018-11', 'M')
print (k)
2018-11

k1 = k + 3
print (k1)
2019-02

k2 = k + 12
print (k2)
2019-11

answered Jan 23 '19 at 06:08

jezrael

822,522
95
1,334
1,252

Add n months to a pandas Period object?

2 Answers2

Linked