我的目标是计算客户在当前日期之前的购买量
例如:
ID Date Purchases_Made Purchase_Mades_So_Far(Result)
ClientA Jan/2019 5 5
ClientA Feb/2019 8 13
ClientB Jan/2019 1 1
ClientB Feb/2019 3 4
我试过lambda表达式和group by,但都不起作用
到目前为止,我最好的尝试是:
for index, row in df.iterrows():
for index2, compare in df.iterrows():
row['Result'] = teste[(compare['ID'] == row['ID']) &
(compare['Date'] < row['Date'])
]['Purchases_Made'].sum()
使用^{} :
输出:
相关问题 更多 >
编程相关推荐