Replace NA values by row means

by

Here’s some sample data.

m <- matrix(1:16, nrow=4)
m[c(1,4,6,11,16)] <- NA

And here’s how I’d fill in missings with the row means.

k <- which(is.na(m), arr.ind=TRUE)
m[k] <- rowMeans(m, na.rm=TRUE)[k[,1]]

Your data will be in a data.frame; you’ll have to convert to a matrix first using as.matrix. You may or may not want to leave it in that format; to convert back use as.data.frame.

More Related Contents:

  1. Several questions on ggplot2 [closed]
  2. Row-wise sum for select columns while ignoring NAs [closed]
  3. Error in if/while (condition) {: missing Value where TRUE/FALSE needed
  4. Interpreting “condition has length > 1” warning from `if` function
  5. How to change legend title in ggplot
  6. Explicitly calling return in a function or not
  7. Importing Excel files into R, xlsx or xls
  8. Removing empty rows of a data file in R
  9. data.table – select first n rows within group [duplicate]
  10. Converting latitude and longitude points to UTM
  11. Read Excel file from a URL using the readxl package
  12. ggplot2 heatmaps: using different gradients for categories
  13. RcppArmadillo pass user-defined function
  14. Different legends and fill colours for facetted ggplot?
  15. Make Frequency Histogram for Factor Variables
  16. Find the most frequent value by row
  17. How to change type of target column when doing := by group in a data.table in R?
  18. Randomly insert NAs into dataframe proportionaly
  19. Can dplyr join on multiple columns or composite key?
  20. R color scatter plot points based on values
  21. What is the difference between = and == in R?
  22. Remove all punctuation except apostrophes in R
  23. How to make variable bar widths in ggplot2 not overlap or gap
  24. R: Select values from data table in range
  25. How to upgrade R in linux?
  26. How to group by two columns in R
  27. Messy plot when plotting predictions of a polynomial regression using lm() in R
  28. How to set legend alpha with ggplot2
  29. Avoid wasting space when placing multiple aligned plots onto one page
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment