嗨,我有一个数据框,它是这样的:
index event action date
0 event1 action1 date1
1 event2 action2 date1
2 event3 action3 date2
3 event4 action4 date2我想合并列和行。我已经使用groupby和lambda function合并了行,但不能同时合并行和列以得到类似的输出
index final_actions date
0 for event1 do action1 and date1
for event2 do action2
1 for event3 do action3 and date2
for event4 do action4提前感谢你的帮助
发布于 2020-07-12 12:36:17
试试这个,groupby + zip
(
df.groupby('date')['event', 'action']
.apply(lambda x:
" and ".join([f"for {x} do {y}"
for x, y in zip(x['event'], x['action'])]))
)https://stackoverflow.com/questions/62857026
复制相似问题