Pandas 根据列将两行合并为一行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/51673938/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-14 05:53:07 来源:igfitidea点击:
Pandas Merge two rows into a single row based on columns
提问by Kshitij G
I have 2 rows that look like these,
我有两行看起来像这样，
------------------------------
DealName | Target | Acquirer |
-----------------------------
ABC-XYZ | ABC | None |
------------------------------
ABC-XYZ | None | XYZ |
------------------------------
I'm looking to merge them into a single as:
我希望将它们合并为一个：
------------------------------
DealName | Target | Acquirer |
-----------------------------
ABC-XYZ | ABC | XYZ |
------------------------------
Not sure how to accomplish this in Pandas. Any pointers will be highly appreciated! Thanks in advance
不知道如何在 Pandas 中实现这一点。任何指针将不胜感激！提前致谢
回答by YOBEN_S
IIUC
国际大学联盟
df.replace('None','').groupby('DealName',as_index=False).agg(''.join)
Out[25]:
DealName Target Acquirer
0 ABC-XYZ ABC XYZ
