Merge rows of a dataframe in pandas based on a column

Question

I am new to pandas. I have a dataframe that looks like this

sitename            name        date               count
0  chess.com  Autobiographer  2012-05-01               2
1  chess.com  Autobiographer  2012-05-05               1
2  chess.com  Autobiographer  2012-05-15               1
3  chess.com  Autobiographer  2012-05-01               1
4  chess.com  Autobiographer  2012-05-15               1
5  chess.com  Autobiographer  2012-05-01               1

How to merge the rows based on date and sum up the count for the same date. Like in sql

select sitename, name, date count(*) from table group by date

Answer 1

If you want to keep your sitename and name in your dataframe, you can do :

df = dataframe.groupby(['date', 'sitename', 'name']).sum()

EDIT : See @DSM's comment to reset the indexes and have a non indexed dataframe.