Delete columns/rows with more than x% missing

by

To remove columns with some amount of NA, you can use
colMeans(is.na(...))

## Some sample data
set.seed(0)
dat <- matrix(1:100, 10, 10)
dat[sample(1:100, 50)] <- NA
dat <- data.frame(dat)

## Remove columns with more than 50% NA
dat[, which(colMeans(!is.na(dat)) > 0.5)]

## Remove rows with more than 50% NA
dat[which(rowMeans(!is.na(dat)) > 0.5), ]

## Remove columns and rows with more than 50% NA
dat[which(rowMeans(!is.na(dat)) > 0.5), which(colMeans(!is.na(dat)) > 0.5)]

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. data.table vs dplyr: can one do something well the other can’t or does poorly?
  3. Extract a dplyr tbl column as a vector
  4. Pass arguments to dplyr functions
  5. dplyr::select function clashes with MASS::select
  6. Sum across multiple columns with dplyr
  7. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  8. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  9. dplyr mutate/replace several columns on a subset of rows
  10. dplyr: How to use group_by inside a function?
  11. case_when in mutate pipe
  12. Summarize all group values and a conditional subset in the same call
  13. Concatenate unique strings after groupby in R
  14. ignore NA in dplyr row sum
  15. How to parametrize function calls in dplyr 0.7?
  16. Use filter in dplyr conditional on an if statement in R
  17. How to do range grouping on a column using dplyr?
  18. combine two data frames with all posible combinations
  19. dplyr / R cumulative sum with reset
  20. finding close match from data frame 1 in data fame 2
  21. R: How to filter/subset a sequence of dates
  22. Add a column with count of NAs and Mean
  23. select columns based on multiple strings with dplyr contains()
  24. grouped operations that result in length not equal to 1 or length of group in dplyr
  25. Error with select function from dplyr
  26. Repeating rows of data.frame in dplyr [duplicate]
  27. Run a custom function on a data frame in R, by group
  28. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  29. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  30. Count how many values in some cells of a row are not NA (in R)

Leave a Comment