Pandas Merge two rows into a single row based on columns

python python-2.7 pandas pandas-groupby pandasql
Kshitij G picture Kshitij G · Aug 3, 2018 · Viewed 10.2k times · Source

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

Answer

BENY picture BENY · Aug 3, 2018

IIUC

df.replace('None','').groupby('DealName',as_index=False).agg(''.join)
Out[25]: 
  DealName Target Acquirer
0  ABC-XYZ    ABC      XYZ

Related questions

TypeError: unhashable type: 'list' when use groupby in python

There is something wrong when I use groupby method: data = pd.Series(np.random.randn(100),index=pd.date_range('01/01/2001',periods=100)) keys = lambda x: [x.year,x.month] data.groupby(keys).mean() but it has an error: TypeError: unhashable …

Read More
How do I create test and train samples from one dataframe with pandas?

I have a fairly large dataset in the form of a dataframe and I was wondering how I would be able to split the dataframe into two random samples (80% and 20%) for training and testing. Thanks!

Read More
Why isn't my Pandas 'apply' function referencing multiple columns working?

I have some problems with the Pandas apply function, when using multiple columns with the following dataframe df = DataFrame ({'a' : np.random.randn(6), 'b' : ['foo', 'bar'] * 3, 'c' : np.random.randn(6)}) and the following function def my_test(a, b): return …

Read More