python - pandas groups by column A and column B, and averages column C. How to generate a dataframe of columns A, B, and C?

Question

df = df.groupby(['A','B'])['c'].mean()

In this way, df is grouped, but how to turn df into a dataframe with columns A, B, and C?
Thanks

Answer 1

I asked this question on stackoverflow, and some netizens gave me the answer. In fact, you only need to add one parameter. The method is as follows:

df = df.groupby(['A','B'],as_index = False)['C'].mean()

Answer 2

At least one reassignment is needed to extract these three columns. The grouping method seems to be like yours