filter for complete cases in data.frame using dplyr (case-wise deletion)

by

Try this:

df %>% na.omit

or this:

df %>% filter(complete.cases(.))

or this:

library(tidyr)
df %>% drop_na

If you want to filter based on one variable’s missingness, use a conditional:

df %>% filter(!is.na(x1))

or

df %>% drop_na(x1)

Other answers indicate that of the solutions above na.omit is much slower but that has to be balanced against the fact that it returns row indices of the omitted rows in the na.action attribute whereas the other solutions above do not.

str(df %>% na.omit)
## 'data.frame':   2 obs. of  2 variables:
##  $ x1: num  1 2
##  $ x2: num  1 2
##  - attr(*, "na.action")= 'omit' Named int  3 4
##    ..- attr(*, "names")= chr  "3" "4"

ADDED Have updated to reflect latest version of dplyr and comments.

ADDED Have updated to reflect latest version of tidyr and comments.

More Related Contents:

  1. R Conditional evaluation when using the pipe operator %>%
  2. What does %>% function mean in R?
  3. Error: could not find function “%>%”
  4. Chain arithmetic operators in dplyr with %>% pipe
  5. Adding prefix or suffix to most data.frame variable names in piped R workflow
  6. Get name of dataframe passed through pipe in R
  7. Use dynamic name for new column/variable in `dplyr`
  8. data.table vs dplyr: can one do something well the other can’t or does poorly?
  9. Extract a dplyr tbl column as a vector
  10. Pass arguments to dplyr functions
  11. dplyr::select function clashes with MASS::select
  12. Sum across multiple columns with dplyr
  13. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  14. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  15. dplyr mutate/replace several columns on a subset of rows
  16. dplyr: How to use group_by inside a function?
  17. Summarize all group values and a conditional subset in the same call
  18. dplyr mutate with conditional values
  19. How to add a cumulative column to an R dataframe using dplyr?
  20. Concatenate unique strings after groupby in R
  21. Get last row of each group in R [duplicate]
  22. dplyr on data.table, am I really using data.table?
  23. Set certain values to NA with dplyr
  24. Use filter in dplyr conditional on an if statement in R
  25. dplyr / R cumulative sum with reset
  26. finding close match from data frame 1 in data fame 2
  27. Add a column with count of NAs and Mean
  28. select columns based on multiple strings with dplyr contains()
  29. dplyr: put count occurrences into new variable [duplicate]
  30. Add row in each group using dplyr and add_row()

Leave a Comment