pandas groupby without turning grouped by column into index

Question

The default behavior of pandas groupby is to turn the group by columns into index and remove them from the list of columns of the dataframe. For instance, say I have a dataFrame with these columns

col1|col2|col3|col4 

if I apply a groupby say with columns col2 and col3 this way

df.groupby(['col2','col3']).sum() 

The dataframe df no longer has the ['col2','col3'] in the list of columns. They are automatically turned into the indices of the resulting dataframe.

My question is how can I perform groupby on a column and yet keep that column in the dataframe?

Answer 1

df.groupby(['col2','col3'], as_index=False).sum() 

Answer 2

Another way to do this would be:

df.groupby(['col2', 'col3']).sum().reset_index()