How do I aggregate multiple rows in one in pandas without using a function like sum?

Question

I want to aggregate multiple rows in a dataset. However, the usual functions I found on the net are "sum()" and "mean()".

I have How can I aggregate multiple rows:

Movie | Comedy | Horror | Drama
A         1        0        0
A         0        0        1    
B         0        1        0
B         0        0        1

to

Movie | Comedy | Horror | Drama
A         1        0        1
B         0        1        1

It's not clear why you don't want to use `sum` here. What is the problem with that? — cs95, Sep 04 '18 at 23:20

Abhi · Answer 1 · 2018-09-24T21:07:35.657

1

Use groupby

df.groupby('Movie', as_index=False).sum()

output:

Movie   Comedy  Horror  Drama           
   A      1       0       1
   B      0       1       1

edited Sep 24 '18 at 21:07

answered Sep 04 '18 at 22:40

Abhi

4,068
1
16
29

1

can also add index=False to avoid setting 'Movie' as index – user3582076 Sep 04 '18 at 22:43

How do I aggregate multiple rows in one in pandas without using a function like sum?

1 Answers1