means and SD for columns in a dataframe with NA values

r mean sapply standard-deviation
Anand Roopsind picture Anand Roopsind · Dec 27, 2013 · Viewed 22.5k times · Source

I'm trying to calculate the mean and standard deviation of several columns (except the first column) in a data.frame with NA values.

I've tried colMeans, sapply, etc., to create a loop that runs through the data.frame and then stores means and standard deviations in a separate table but keep getting a "FUN" error. any help would be great. Thanks

a

Answer

IRTFM picture IRTFM · Dec 27, 2013 
sapply(df, function(cl) list(means=mean(cl,na.rm=TRUE), sds=sd(cl,na.rm=TRUE)))
      col1     col2     col3     col4     col5    
means 3        8        12.5     18.25    22.5    
sds   1.581139 1.581139 1.290994 1.707825 1.290994

as.data.frame( t(sapply(df, function(cl) list(means=mean(cl,na.rm=TRUE), 
                                              sds=sd(cl,na.rm=TRUE))) ))
     means      sds
col1     3 1.581139
col2     8 1.581139
col3  12.5 1.290994
col4 18.25 1.707825
col5  22.5 1.290994

Related questions

Loop function and add columns to dataframe in R

I want to loop a function over dataframes and add information from the function to the data frame. I have read the many relevant posts on looping and applying functions to dataframes that have got me close to what I …

Read More
Mean of a column in a data frame, given the column's name

I'm inside a big function I have to write. In the last part I have to calculate the mean of a column in a data frame. The name of the column I am operating on is given as an argument …

Read More
calculate the mean for each column of a matrix in R

I am working on R in R studio. I need to calculate the mean for each column of a data frame. cluster1 // 5 by 4 data frame mean(cluster1) // I got : Warning message: In mean.default(cluster1) : argument is not numeric or …

Read More