How to delete rows from a dataframe that contain n*NA

by

Use rowSums. To remove rows from a data frame (df) that contain precisely n NA values:

df <- df[rowSums(is.na(df)) != n, ]

or to remove rows that contain n or more NA values:

df <- df[rowSums(is.na(df)) < n, ]

in both cases of course replacing n with the number that’s required

More Related Contents:

  1. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  2. Combine column to remove NA’s
  3. How to append rows to an R data frame
  4. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  5. Remove rows with all or some NAs (missing values) in data.frame
  6. Left join using data.table
  7. Replacing character values with NA in a data frame
  8. Merging a lot of data.frames [duplicate]
  9. Merge two data frames while keeping the original row order
  10. Coalesce two string columns with alternating missing values to one
  11. Merge unequal dataframes and replace missing rows with 0
  12. aggregate methods treat missing values (NA) differently
  13. Use merge() to update a data frame with values from a second data frame
  14. Collapse rows with overlapping ranges
  15. How to subset data in R without losing NA rows?
  16. How to delete columns that contain ONLY NAs?
  17. Combine/merge lists by elements names
  18. Randomly insert NAs into dataframe proportionaly
  19. Dealing with TRUE, FALSE, NA and NaN
  20. Merge data frames based on rownames in R
  21. Replace a value NA with the value from another column in R
  22. Counting non NAs in a data frame; getting answer as a vector
  23. Merge error : negative length vectors are not allowed
  24. Identify records in data frame A not contained in data frame B [closed]
  25. Efficiently merging two data frames on a non-trivial criteria
  26. Find names of columns which contain missing values
  27. Find columns with all missing values
  28. Deleting every n-th row in a dataframe
  29. How can I merge many data frames from csv files when the ID column is implied?
  30. How can I count the number of NAs per group?

Leave a Comment