pandas groupby multiple columns values

Question

I was try to get a average columns for all the std columns

I want to add one more column to calculate the average value from Std_4-Std_10 values. Not sure should I use groupby or pivot. Thanks

And you shouldn't need either, just use `df.iloc[:, 1:].mean(1)` — user3483203, Sep 06 '18 at 21:18

score 0 · Answer 1 · answered Sep 06 '18 at 21:19

0

Use:

df.filter(like='Std').mean(1)

To add it back into your dataframe, use:

df['mean_Std'] = df.filter(like='Std').mean(1)

answered Sep 06 '18 at 21:19

sacuL

1 Answers1