merge duplicate rows by adding a column 'count'

Question

I want to merge duplicate rows by adding a new column 'count'

Final dataframe that I want

rows can be in any order

pissall · Accepted Answer · 2019-10-04T07:30:46.033

3

You can use:

df["count"] = 1
df = df.groupby(["user_id", "item_id", "total"])["count"].count().reset_index()

edited Oct 04 '19 at 07:30

answered Oct 04 '19 at 07:24

pissall

It removes rows as i want but not working for the next column 'count' that i want to add – Rahul Chaudhary Oct 04 '19 at 07:28
@RahulChaudhary Please upvote if helped – pissall Oct 04 '19 at 07:43

1 Answers1