Menu
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
593
To merge rows within a group together in Pandas we can use the agg(~) method together with the join(~) method to concatenate the row values.
merge() for combining data on common columns or indices. . join() for combining data on a key column or an index. concat() for combining DataFrames across rows or columns.
Both join and merge can be used to combines two dataframes but the join method combines two dataframes on the basis of their indexes whereas the merge method is more versatile and allows us to specify columns beside the index to join on for both dataframes.
IIUC
df.replace('None','').groupby('DealName',as_index=False).agg(''.join)
Out[25]:
DealName Target Acquirer
0 ABC-XYZ ABC XYZ
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
