Mean of each column of multiple dataframes to a dataframe - Python pandas

Question

I have a dataframe df as follows:

And I would like the mean of every column and make a dataframe with it. That would be in this example:

A B C
2 2 2

The code I did was:

import pandas as pd
import numpy as np
df = pd.DataFrame(np.random.randn(10, 3), columns=list('ABC')) # To create df
dfs = np.array_split(df.sample(frac=1),4) # Split it in 4
daf = []
for i in range(len(dfs):
   daf.append(dfs[i].mean())
daf.to_frame()

However I am unable to make it work.

jezrael · Accepted Answer · 2017-11-27 15:57:33Z

4

Use mean, but because it return Series use to_frame and transpose:

df = df.mean().to_frame().T
print (df)
     A    B    C
0  2.0  2.0  2.0

Or:

df = pd.DataFrame([df.mean()])
print (df)
     A    B    C
0  2.0  2.0  2.0

For multiple DataFrames:

daf = []
for i in dfs:
   daf.append(i.mean().to_frame().T)

print (daf[0])
         A         B        C
0 -0.92493  1.022305  1.52295

what is same as list comprehension solution:

daf = [i.mean().to_frame().T for i in dfs]

edited Nov 27, 2017 at 15:57

answered Nov 27, 2017 at 15:51

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

Antonio López Ruiz Over a year ago

If it is multiple dataframes, how can I do it?

frhyme · Accepted Answer · 2017-11-27 16:00:45Z

0

the method of dataframe, 'apply' will be good. the code is below.

import pandas as pd
import numpy as np
df = pd.DataFrame(np.random.randn(10, 3), columns=list('ABC')) # To create df
df.apply(lambda x: np.mean(x), axis=0)

answered Nov 27, 2017 at 16:00

frhyme

1,0361 gold badge16 silver badges29 bronze badges

Collectives™ on Stack Overflow

Mean of each column of multiple dataframes to a dataframe - Python pandas

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related