Omit rows containing specific column of NA

by

Use is.na

DF <- data.frame(x = c(1, 2, 3), y = c(0, 10, NA), z=c(NA, 33, 22))
DF[!is.na(DF$y),]

More Related Contents:

  1. How do I replace NA values with zeros in an R dataframe?
  2. Replacing character values with NA in a data frame
  3. How to replace NA values in a table for selected columns
  4. Count NAs per row in dataframe [duplicate]
  5. Subset of rows containing NA (missing) values in a chosen column of a data frame
  6. Remove columns from dataframe where some of values are NA
  7. How to subset data in R without losing NA rows?
  8. How to delete columns that contain ONLY NAs?
  9. Randomly insert NAs into dataframe proportionaly
  10. Select last non-NA value in a row, by row
  11. Replace in a factor column
  12. Replace all NA with FALSE in selected columns in R
  13. Find columns with all missing values
  14. R: replacing NAs in a data.frame with values in the same position in another dataframe
  15. Move NAs to the end of each column in a data frame
  16. Repeat each row of data.frame the number of times specified in a column
  17. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  18. Filtering a data frame on a vector [duplicate]
  19. Take random sample by group
  20. How do I delete rows in a data frame?
  21. Convert data.frame column to a vector?
  22. Add new row to dataframe, at specific row-index, not appended?
  23. Growing a data.frame in a memory-efficient manner
  24. Splitting a data.frame by a variable [duplicate]
  25. Unlist a data frame by rows, not columns
  26. Using lapply to apply a function over list of data frames and saving output to files with different names
  27. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  28. Row-wise sum of values grouped by columns with same name
  29. How to create a new variable in a data.frame based on a condition?
  30. Interpolating timeseries

Leave a Comment