DataFrame 'groupby' is fixing group columns with index

Question

I have used a simple 'groupby' to condense rows in a Pandas dataframe:

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

In the new DataFrame 'df', the three columns that were used in the 'groupby' function are now fixed within the index and are no longer column indexes 0, 1 and 2 - what was previously column index 4 is now column index 0.

How do I stop this from happening / reinclude the three 'groupby' columns along with the original data?

Nk03 · Accepted Answer · 2021-04-28 09:49:24Z

1

Try -

df = df.groupby(['col1', 'col2', 'col3'], as_index = False).sum()
#or
df = df.groupby(['col1', 'col2', 'col3']).sum().reset_index()

answered Apr 28, 2021 at 9:49

Nk03

15k2 gold badges11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SlowlyLearning Over a year ago

Thanks - this was really stupid of me. I thought reset_index was only for resetting row indexes, for example after I had dropped rows.

imdevskp · Accepted Answer · 2021-04-28 09:47:28Z

1

Try resetting the index

df = df.reset_index()

answered Apr 28, 2021 at 9:47

imdevskp

2,2532 gold badges13 silver badges23 bronze badges

1 Comment

SlowlyLearning Over a year ago

Thanks - this was really stupid of me. I thought reset_index was only for resetting row indexes, for example after I had dropped rows.

Collectives™ on Stack Overflow

DataFrame 'groupby' is fixing group columns with index

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related