Resample a dataframe with n day window

Question

I know I can resample daily data, by month, like this:

df = data.resample('M')

But how do I resample by an arbitrary length, say 180?

df = data.resample('Days', 180) # six months # I am just guessing here

score 2 · Answer 1 · answered Jun 02 '22 at 19:05

2

Use the rule directly

df = data.resample('180D')

For a list of possibilities on rules, please refer to the docs. There's a nice summary table in this link.

answered Jun 02 '22 at 19:05

rafaelc

Thanks. But the return is not a dataframe anymore? – Ivan Jun 02 '22 at 19:44
I might not have asked the right question. I just want the entries of the dataframe that are n days apart and throw out all the rows in between of the dataframe – Ivan Jun 02 '22 at 19:45
@Ivan please provide a [mcve] – rafaelc Jun 02 '22 at 20:02

1 Answers1