Pandas get mean value per (row,col) across list of dataframes

Question

I have a dictionary of dataframes:

{1 : df1, 2 : df2 .. }

All dataframe are with the same shapes. (but different number of rows). I want to create the dataframe where every column is the mean of this column for this row. So if:

df1 : A  B  C
      2  4  6
      1  3  5
df2 : A  B  C
      0  2  8
      7  9  5

I will get:

new_df:  A  B  C 
         1  3  7
         4  6  5

What is the best way to do so?

Sunderam Dubey · Accepted Answer · 2022-11-23 12:41:34Z

2

Try via concat() and mean():

out=pd.concat(d.values()).mean(level=0)

OR

out=pd.concat(d).mean(level=1)

Note: here d is your dictionary of dataframes

output of out:

    A   B   C
0   1   3   7
1   4   6   5

edited Nov 23, 2022 at 12:41

Sunderam Dubey

8,83312 gold badges26 silver badges43 bronze badges

answered Jul 22, 2021 at 9:13

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Pandas get mean value per (row,col) across list of dataframes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related