Resample time series in pandas to a weekly interval

python date pandas numpy interpolation
2daaa picture 2daaa · Jan 25, 2013 · Viewed 33.9k times · Source

How do I resample a time series in pandas to a weekly frequency where the weeks start on an arbitrary day? I see that there's an optional keyword base but it only works for intervals shorter than a day.

Answer

Andy Hayden picture Andy Hayden · Jan 25, 2013

You can pass anchored offsets to resample, among other options they cover this case.

For example the weekly frequency from Monday:

ts.resample('W-MON')

Related questions

Can pandas automatically recognize dates?

Today I was positively surprised by the fact that while reading data from a data file (for example) pandas is able to recognize types of values: df = pandas.read_csv('test.dat', delimiter=r"\s+", names=['col1','col2',…

Read More
How do I convert dates in a Pandas data frame to a 'date' data type?

I have a Pandas data frame, one of the column contains date strings in the format YYYY-MM-DD For e.g. '2013-10-28' At the moment the dtype of the column is object. How do I convert the column …

Read More
Add missing dates to pandas dataframe

My data can have multiple events on a given date or NO events on a date. I take these events, get a count by date and plot them. However, when I plot them, my two series don't always match. idx = …

Read More