dplyr filter with condition on multiple columns

by

A possible dplyr(0.5.0.9004 <= version < 1.0) solution is:

# > packageVersion('dplyr')
# [1] ‘0.5.0.9004’

dataset %>%
    filter(!is.na(father), !is.na(mother)) %>%
    filter_at(vars(-father, -mother), all_vars(is.na(.)))

Explanation:

  • vars(-father, -mother): select all columns except father and mother.
  • all_vars(is.na(.)): keep rows where is.na is TRUE for all the selected columns.

note: any_vars should be used instead of all_vars if rows where is.na is TRUE for any column are to be kept.

Update (2020-11-28)

As the _at functions and vars have been superseded by the use of across since dplyr 1.0, the following way (or similar) is recommended now:

dataset %>%
    filter(across(c(father, mother), ~ !is.na(.x))) %>%
    filter(across(c(-father, -mother), is.na))

See more example of across and how to rewrite previous code with the new approach here: Colomn-wise operatons or type vignette("colwise") in R after installing the latest version of dplyr.

More Related Contents:

  1. R spreading multiple columns with tidyr [duplicate]
  2. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  3. How to add a cumulative column to an R dataframe using dplyr?
  4. Get last row of each group in R [duplicate]
  5. R – add column that counts sequentially within groups but repeats for duplicates
  6. Change value of variable with dplyr
  7. dplyr – filter by group size
  8. Merge rows in a dataframe where the rows are disjoint and contain NAs
  9. Calculate group mean while excluding current observation using dplyr
  10. mutate_each / summarise_each in dplyr: how do I select certain columns and give new names to mutated columns?
  11. finding close match from data frame 1 in data fame 2
  12. dplyr change many data types
  13. Join two data frames in R based on closest timestamp
  14. How to dplyr rename a column, by column index?
  15. How to add only missing Dates in Dataframe
  16. Override column types when importing data using readr::read_csv() when there are many columns
  17. Adding column if it does not exist
  18. Pass arguments to dplyr functions
  19. dplyr::select function clashes with MASS::select
  20. Remove columns with zero values from a dataframe
  21. Identifying duplicate columns in a dataframe
  22. R pass variable column indices to ggplot2 [duplicate]
  23. Convert Named Character Vector to data.frame
  24. dplyr on data.table, am I really using data.table?
  25. Determine the data types of a data frame’s columns
  26. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  27. Extract text after “/” in a data frame column
  28. Deleting specific rows from a data frame
  29. Shifting a column down by one
  30. Identifying where value changes in R data.frame column

Leave a Comment