Concatenate unique strings after groupby in R

by

Use unique on cc before pasting it, and also no need for the mutate step, you can use summarize directly:

data %>% 
    group_by(bb) %>% 
    summarise(cc = paste(unique(cc), collapse=" "))

# A tibble: 2 x 2
#  bb    cc                  
#  <fct> <chr>               
#1 a     hello hi message bye
#2 b     q w r t

More Related Contents:

  1. Gather multiple sets of columns
  2. How to get summary statistics by group
  3. Is there a dplyr equivalent to data.table::rleid?
  4. Replace NA with previous or next value, by group, using dplyr
  5. Filter rows which contain a certain string
  6. Calculate group mean, sum, or other summary stats. and assign column to original data
  7. Select groups which have at least one of a certain value
  8. Rolling mean (moving average) by group/id with dplyr
  9. Programming with dplyr using string as input
  10. Count number of rows by group using dplyr
  11. Finding Overlaps between interval sets / Efficient Overlap Joins
  12. R dplyr rolling sum
  13. How to remove rows with any zero value
  14. pass function arguments to both dplyr and ggplot
  15. Select columns based on string match – dplyr::select
  16. Delete columns/rows with more than x% missing
  17. How to aggregate a dataframe by week?
  18. Mutate multiple columns in a dataframe
  19. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  20. dplyr mutate rowwise max of range of columns
  21. dplyr: lead() and lag() wrong when used with group_by()
  22. Reorder rows using custom order
  23. Cartesian product with dplyr
  24. Spreading a two column data frame with tidyr
  25. Categorize continuous variable with dplyr [duplicate]
  26. R dplyr rowwise mean or min and other methods?
  27. Chain arithmetic operators in dplyr with %>% pipe
  28. How to find difference between values in two rows in an R dataframe using dplyr
  29. Collapse all columns by an ID column [duplicate]
  30. Unlisting columns by groups

Leave a Comment