merge duplicate rows by adding a column 'count' [duplicate]

Question

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

Final dataframe that I want

rows can be in any order

Answer 1

You can use:

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