dataframe grouped by two elements

Asked May 21 '17 at 12:10

Active May 21 '17 at 12:18

Viewed 141 times

For example, there is a DataFrame named df. And I group it by column 'A' and column 'B',then get the mean value of column 'C'. I use the following code:

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

But finally I want to get a new DataFrame with 3 columns('A','B','C').How can I do after these code?

edited May 21 '17 at 12:12

Willem Van Onsem

443,496
30
428
555

asked May 21 '17 at 12:10

Chunk_Ning

Either `df.groupby(['A','B'], as_index=False)['C'].mean()` or `df.groupby(['A','B'])['C'].mean().reset_index()`. – ayhan May 21 '17 at 12:17
@ayhan.yes,it worked.Thx. – Chunk_Ning May 21 '17 at 12:21
df.groupy(['A','B']).agg({'C':'mean'}) – Scott Boston May 21 '17 at 12:23

dataframe grouped by two elements

0 Answers0