Remove groups with less than three unique observations

by

With data.table you could do:

library(data.table)
DT[, if(uniqueN(Day) >= 3) .SD, by = Group]

which gives:

   Group Day
1:     1   1
2:     1   3
3:     1   5
4:     1   5
5:     3   1
6:     3   2
7:     3   3

Or with dplyr:

library(dplyr)
DT %>% 
  group_by(Group) %>% 
  filter(n_distinct(Day) >= 3)

which gives the same result.

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Select rows from a data frame based on values in a vector
  3. Subset data frame based on number of rows per group
  4. Why is `[` better than `subset`?
  5. How to subset matrix to one column, maintain matrix data type, maintain row/column names?
  6. Subset / filter rows in a data frame based on a condition in a column
  7. Subset rows in a data frame based on a vector of values
  8. R subset based on range of dates [closed]
  9. How should I deal with “package ‘xxx’ is not available (for R version x.y.z)” warning?
  10. Plotting two variables as lines using ggplot2 on the same graph
  11. Add legend to ggplot2 line plot
  12. How to find the statistical mode?
  13. Split data.frame based on levels of a factor into new data.frames
  14. Unique combination of all elements from two (or more) vectors
  15. How to read data when some numbers contain commas as thousand separator?
  16. Error: unexpected symbol/input/string constant/numeric constant/SPECIAL in my code
  17. How can two strings be concatenated?
  18. How do you use “
  19. Elegant way to check for missing packages and install them?
  20. How to plot all the columns of a data frame in R
  21. Opposite of %in%: exclude rows with values specified in a vector
  22. Vectorized IF statement in R?
  23. How to remove all whitespace from a string?
  24. How to subtract/add days from/to a date?
  25. How can I remove an element from a list?
  26. Remove backslashes from character string
  27. Dollar sign before a variable
  28. How to find all functions in an R package?
  29. R: How to filter/subset a sequence of dates
  30. R: How to split a data frame into training, validation, and test sets?

Leave a Comment