Merge multiple columns together based on a common column value in pandas - python

Question

I want to merge rows based on a common value i.e date of purchase.

How do i do this ?

Answer 1

You can try this:

df = df.groupby(['DateOfPurchase'])['Item'].apply(','.join).reset_index()
print(df)

Output:

  DateOfPurchase        Item
0    19-Aug-2020  Apple,Eggs
1    20-Aug-2020      Banana