与TimeGrouper一起“向后"分组 [英] Groupby with TimeGrouper 'backwards'

问题描述

我有一个包含时间序列的DataFrame:

I have a DataFrame containing a time series:

rng = pd.date_range('2016-06-01', periods=24*7, freq='H')
ones = pd.Series([1]*24*7, rng)
rdf = pd.DataFrame({'a': ones})

最后一项是2016-06-07 23:00:00.我现在想将其分组，例如两天，基本上是这样的:

Last entry is 2016-06-07 23:00:00. I now want to group this by, say two days, basically like so:

rdf.groupby(pd.TimeGrouper('2D')).sum()

但是，我想从我的最后一个数据点开始向后分组，所以不要获得此结果:

However, I want to group starting from my last data point backwards, so instead of getting this result:

            a
2016-06-01  48
2016-06-03  48
2016-06-05  48
2016-06-07  24

我更希望这样:

            a
2016-06-01  24
2016-06-03  48
2016-06-05  48
2016-06-07  48

以及按'3D'分组时:

            a
2016-06-01  24
2016-06-04  72
2016-06-07  72

按'4D'分组时的预期结果是:

Expected outcome when grouping by '4D' is:

            a
2016-06-03  72
2016-06-07  96

我无法通过closed，label等的每种组合来获得此功能.我能想到.

I am not able to get this with every combination of closed, label etc. I could think of.

我该如何实现?

推荐答案

由于我主要想按7天(也就是一周)进行分组，因此我现在使用此方法来找到所需的垃圾箱:

Since I primarily want to group by 7 days, aka one week, I am using this method now to come to the desired bins:

from pandas.tseries.offsets import Week

# Let's not make full weeks
hours = 24*6*4
rng = pd.date_range('2016-06-01', periods=hours, freq='H')

# Set week start to whatever the last weekday of the range is
print("Last day is %s" % rng[-1])
freq = Week(weekday=rng[-1].weekday())

ones = pd.Series([1]*hours, rng)
rdf = pd.DataFrame({'a': ones})
rdf.groupby(pd.TimeGrouper(freq=freq, closed='right', label='right')).sum()

这给了我所需的输出

2016-06-25  96
2016-07-02  168
2016-07-09  168

这篇关于与TimeGrouper一起“向后"分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！