Add count of unique / distinct values by group to the original data

by

Here’s a solution with the dplyr package – it has n_distinct() as a wrapper for length(unique()).

df %>%
  group_by(color) %>%
  mutate(unique_types = n_distinct(type))

More Related Contents:

  1. Count number of rows per group and add result to original data frame
  2. Count number of occurences for each unique value
  3. Count unique values for every column
  4. How can I count the number of NAs per group?
  5. R transpose and group by
  6. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  7. Faster ways to calculate frequencies and cast from long to wide
  8. Aggregating by unique identifier and concatenating related values into a string [duplicate]
  9. Extract row corresponding to minimum value of a variable by group
  10. Group by multiple columns and sum other multiple columns
  11. How can I remove all duplicates so that NONE are left in a data frame?
  12. Select the top N values by group
  13. How to assign a unique ID number to each group of identical values in a column [duplicate]
  14. Plot multiple lines (data series) each with unique color in R
  15. Aggregate multiple columns at once [duplicate]
  16. Aggregate a dataframe on a given column and display another column
  17. Aggregate a data frame based on unordered pairs of columns
  18. Compute mean and standard deviation by group for multiple variables in a data.frame
  19. aggregate methods treat missing values (NA) differently
  20. data.table with two string columns of set elements, extract unique rows with each row unsorted
  21. How to count the frequency of a string for each row in R
  22. Group integer vector into consecutive runs
  23. unique() for more than one variable
  24. Find the most frequent value by row
  25. Returning first row of group
  26. Count number of columns by a condition (>) for each row
  27. aggregate() puts multiple output columns in a matrix instead
  28. R group by aggregate
  29. R use ddply or aggregate
  30. Aggregate by week in R

Leave a Comment