Aggregating by unique identifier and concatenating related values into a string [duplicate]

by

Let’s call your data.frame DF

> aggregate(id ~ brand, data = DF, c)
         brand                           id
1   RadioShack                         2308
2   Rag & Bone                         4466
3         Ragu                   1830, 4518
4 Ralph Lauren 1638, 2719, 2720, 2721, 2722

Another alternative using aggregate is:

result <- aggregate(id ~ brand, data = DF, paste, collapse = ",")

This produces the same result and now id is not a list anymore. Thanks to @Frank comment. To see the class of each column try:

> sapply(result, class)
      brand          id 
   "factor" "character"

As mentioned by @DavidArenburg in the comments, another alternative is using the toString function:

aggregate(id ~ brand, data = DF, toString)

More Related Contents:

  1. R transpose and group by
  2. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  3. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  4. Count number of rows within each group
  5. Faster ways to calculate frequencies and cast from long to wide
  6. Extract row corresponding to minimum value of a variable by group
  7. Group by multiple columns and sum other multiple columns
  8. Add count of unique / distinct values by group to the original data
  9. Select the first and last row by group in a data frame
  10. Select the top N values by group
  11. Aggregate multiple columns at once [duplicate]
  12. R – Concatenate two dataframes?
  13. Aggregate a dataframe on a given column and display another column
  14. Aggregate a data frame based on unordered pairs of columns
  15. Compute mean and standard deviation by group for multiple variables in a data.frame
  16. aggregate methods treat missing values (NA) differently
  17. Group integer vector into consecutive runs
  18. How to concatenate factors, without them being converted to integer level?
  19. Returning first row of group
  20. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  21. Aggregate data in R
  22. Concatenate rows of a data frame
  23. aggregate() puts multiple output columns in a matrix instead
  24. data.frame Group By column [duplicate]
  25. R group by aggregate
  26. Paste/Collapse in R
  27. R use ddply or aggregate
  28. Run a custom function on a data frame in R, by group
  29. Aggregate by week in R
  30. How can I count the number of NAs per group?

Leave a Comment