Select groups based on number of unique / distinct values

by

Here’s a solution using dplyr:

library(dplyr)

sample <- data.frame(
  ID = 1:9,  
  Group= c('AA', 'AA', 'AA', 'BB', 'BB', 'CC', 'CC', 'BB', 'CC'),  
  Value = c(1, 1, 1, 2, 2, 2, 3, 2, 3)
)

sample %>%
  group_by(Group) %>%
  filter(n_distinct(Value) == 1)

We group the data by Group, and then only select groups where the number of distinct values of Value is 1.

More Related Contents:

  1. How to assign a unique ID number to each group of identical values in a column [duplicate]
  2. Count unique values for every column
  3. Quickly reading very large tables as dataframes
  4. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  5. Combine two data frames by rows (rbind) when they have different sets of columns
  6. Convert a list to a data frame
  7. How to combine multiple conditions to subset a data-frame using “OR”?
  8. Split a large dataframe into a list of data frames based on common value in column
  9. subtract value from previous row by group
  10. calculate the mean for each column of a matrix in R
  11. Transpose a data frame
  12. Error – replacement has [x] rows, data has [y]
  13. Subset of rows containing NA (missing) values in a chosen column of a data frame
  14. rbind dataframes with a different column name
  15. Find duplicated rows (based on 2 columns) in Data Frame in R
  16. Change value of variable with dplyr
  17. Creating a new variable from a lookup table
  18. How to initialize empty data frame (lot of columns at the same time) in R
  19. R: Assign variable labels of data frame columns
  20. rbind data frames based on a common pattern in data frame name
  21. Read and rbind multiple csv files
  22. Merging rows with the same ID variable [duplicate]
  23. Count number of zeros per row, and remove rows with more than n zeros
  24. How I can select rows from a dataframe that do not match?
  25. Select last non-NA value in a row, by row
  26. Join two data frames in R based on closest timestamp
  27. Convert a data frame to a data.table without copy
  28. Shifting a column down by one
  29. Identifying where value changes in R data.frame column
  30. What is the first column in R’s mtcars dataset?

Leave a Comment