how to calculate row means in a data frame?

r dataframe stat
vahab picture vahab · May 27, 2015 · Viewed 17k times · Source

I have a dataframe with 1000 columns and 8 rows, I need to calculate row means.I tried this loop:

final <- as.data.frame(matrix(nrow=8,ncol=1))
for(j in 1:8){
  value<- mean(dataframe[j,])
  final[j,]<-value
}

but got the following error:

In mean.default(df2[j, ]) : argument is not numeric or logical: returning NA

Answer

Tim Biegeleisen picture Tim Biegeleisen · May 27, 2015

Use the rowMeans() function:

final$mean <- rowMeans(final, na.rm=TRUE)

Note that you should avoid using loops for your everyday R operations. If you want to iterate over all rows yourself, you can use the apply() function like this:

final$mean <- apply(final, 1, function(x) { mean(x, na.rm=TRUE) })

Related questions

Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
Drop data frame columns by name

I have a number of columns that I would like to remove from a data frame. I know that we can delete them individually using something like: df$x <- NULL But I was hoping to do this with …

Read More
Changing column names of a data frame

I have a data frame called "newprice" (see below) and I want to change the column names in my program in R. > newprice Chang. Chang. Chang. 1 100 36 136 2 120 -33 87 3 150 14 164 In fact this is what am doing: names(newprice)[1]<-paste("premium") …

Read More