Subset of rows containing NA (missing) values in a chosen column of a data frame

by

Never use ==’NA’ to test for missing values. Use is.na() instead. This should do it:

new_DF <- DF[rowSums(is.na(DF)) > 0,]

or in case you want to check a particular column, you can also use

new_DF <- DF[is.na(DF$Var),]

In case you have NA character values, first run

Df[Df=='NA'] <- NA

to replace them with missing values.

More Related Contents:

  1. How to subset data in R without losing NA rows?
  2. Filter data.frame rows by a logical condition
  3. How do I replace NA values with zeros in an R dataframe?
  4. Opposite of %in%: exclude rows with values specified in a vector
  5. How to drop columns by name in a data frame
  6. Subset / filter rows in a data frame based on a condition in a column
  7. Replacing character values with NA in a data frame
  8. How to replace NA with mean by group / subset?
  9. How do I extract a single column from a data.frame as a data.frame?
  10. Subset dataframe by multiple logical conditions of rows to remove
  11. Filtering a data frame on a vector [duplicate]
  12. How to replace NA values in a table for selected columns
  13. Subset data frame based on multiple conditions [duplicate]
  14. Subsetting R data frame results in mysterious NA rows
  15. How to convert dataframe into time series?
  16. Omit rows containing specific column of NA
  17. Count NAs per row in dataframe [duplicate]
  18. Remove columns from dataframe where some of values are NA
  19. dplyr – filter by group size
  20. How to delete columns that contain ONLY NAs?
  21. Using grep to help subset a data frame
  22. Randomly insert NAs into dataframe proportionaly
  23. Read and rbind multiple csv files
  24. Filter data frame rows based on values in vector
  25. Select last non-NA value in a row, by row
  26. Replace all NA with FALSE in selected columns in R
  27. How to append a whole dataframe to a CSV in R
  28. Undefined columns selected when subsetting data frame
  29. Find columns with all missing values
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment