Remove group from data.frame if at least one group member meets condition

by

Try

library(dplyr)
df2 %>%
  group_by(group) %>%
  filter(!any(world == "AF"))

Or as per metionned by @akrun:

setDT(df2)[, if(!any(world == "AF")) .SD, group]

Or

setDT(df2)[, if(all(world != "AF")) .SD, group]

Which gives:

#Source: local data frame [7 x 3]
#Groups: group
#
#  world place group
#1    AB     1     1
#2    AC     1     1
#3    AD     2     1
#4    AB     1     3
#5    AE     2     3
#6    AC     3     3
#7    AE     1     3

More Related Contents:

  1. Extract rows based on only one column using R [closed]
  2. R subset based on range of dates [closed]
  3. Faster ways to calculate frequencies and cast from long to wide
  4. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  5. Select rows from a data frame based on values in a vector
  6. Opposite of %in%: exclude rows with values specified in a vector
  7. How to replace NA with mean by group / subset?
  8. Unique rows, considering two columns, in R, without order
  9. Subset rows in a data frame based on a vector of values
  10. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  11. dplyr: “Error in n(): function should not be called directly”
  12. Subsetting R data frame results in mysterious NA rows
  13. Subset of rows containing NA (missing) values in a chosen column of a data frame
  14. Subset with unique cases, based on multiple columns
  15. Remove groups with less than three unique observations
  16. Update subset of data.table based on join
  17. Change value of variable with dplyr
  18. dplyr – filter by group size
  19. R gotcha: logical-and operator for combining conditions is & not &&
  20. How to get top n companies from a data frame in decreasing order
  21. Split Data Frame into Rows of Fixed Size
  22. Subsetting data.table using variables with same name as column
  23. R: How to filter/subset a sequence of dates
  24. Subset data.frame by date
  25. Standard error bars using stat_summary
  26. How to remove rows of a matrix by row name, rather than numerical index?
  27. Read FASTA into a dataframe and extract subsequences of FASTA file
  28. How to pass “nothing” as an argument to `[` for subsetting?
  29. Can `ddply` (or similar) do a sliding window?
  30. Set global object in Shiny

Leave a Comment