我需要使用两列创建组。例如,我以shop_id和week为例。以下是df:
shop_id week
0 1 1
1 1 2
2 1 3
3 2 1
4 2 2
5 3 2
6 1 5想象一下,每一组都是连续地(一周又一周)在每一家商店里进行的促销活动。因此,我的尝试是使用排序,移位1以获得last_week,使用布尔值,然后对它们进行迭代,每次递增,而条件不满足:
test_df = pd.DataFrame({'shop_id':[1,1,1,2,2,3,1], 'week':[1,2,3,1,2,2,5]})
def createGroups(df, shop_id, week, group):
'''Create groups where is the same shop_id and consecutive week
'''
periods = []
period = 0
# sorting to create chronological order
df = df.sort_values(by = [shop_id,week],ignore_index = True)
last_week = df[week].shift(+1)==df[week]-1
last_shop = df[shop_id].shift(+1)==df[shop_id]
# here i iterate over booleans and increment group by 1
# if shop is different or last period is more than 1 week ago
for p,s in zip(last_week,last_shop):
if (p == True) and (s == True):
periods.append(period)
else:
period += 1
periods.append(period)
df[group] = periods
return df
createGroups(test_df, 'shop_id', 'week', 'promo')我得到了我需要的分组:
shop_id week promo
0 1 1 1
1 1 2 1
2 1 3 1
3 1 5 2
4 2 1 3
5 2 2 3
6 3 2 4然而,函数似乎是过度的。对于如何在不使用本地熊猫功能的情况下获得相同的功能,有什么想法吗?我在docs中看到了.ngroups(),但不知道如何将它应用到我的案例中。更好的办法是以某种方式将其矢量化,但我不知道如何实现:
发布于 2020-11-05 15:07:08
首先,我们要识别促销活动(连续几周),然后使用groupby().ngroup()枚举促销活动:
df = df.sort_values('shop_id')
s = df['week'].diff().ne(1).groupby(df['shop_id']).cumsum()
df['promo'] = df.groupby(['shop_id',s]).ngroup() + 1更新:这是基于您的解决方案:
df = df.sort_values(['shop_id','week'])
s = df[['shop_id', 'week']]
df['promo'] = (s['shop_id'].ne(s['shop_id'].shift()) |
s['week'].diff().ne(1) ).cumsum()输出:
shop_id week promo
0 1 1 1
1 1 2 1
2 1 3 1
6 1 5 2
3 2 1 3
4 2 2 3
5 3 2 4https://stackoverflow.com/questions/64699807
复制相似问题