0

I'm trying to make a variable in R that is an average of 4 other variables; however, there is a missing value for one observation in one of the variables. Thus, the average value is missing for this observation.

I would like to have this observation's value for the new average variable be the average of the three variables that this observation has data on.

Here is the code that I'm using now:

data$average <- (data$var1+data$var2+data$var3+data$var4)/4
Djensen
  • 1,337
  • 1
  • 22
  • 32
PotterFan
  • 3
  • 1
  • 3
  • Try `rowMeans()` – Duck Aug 10 '20 at 20:47
  • do `rowMeans(dat, na.rm = TRUE)` if you want to take into consideration all variables of the dataframe, else you will need to do `rowMeans(dat[c("var1", "var2","var3","var4")], na.rm =TRUE)` – Onyambu Aug 10 '20 at 21:16

0 Answers0