Aggregate a data frame based on unordered pairs of columns

by

One way is to create extra columns with pmax and pmin of id1 and id2as follows. I’ll use data.table solution here.

require(data.table)
DT <- data.table(DF)
# Following mnel's suggestion, g1, g2 could be used directly in by
# and it could be even shortened by using `id1` and id2` as their names
DT.OUT <- DT[, list(size=sum(size)), 
        by=list(id1 = pmin(id1, id2), id2 = pmax(id1, id2))]
#     id1  id2 size
# 1: 5400 5505   18
# 2: 5033 5458    1
# 3: 5452 2873   24
# 4: 5452 5213    2
# 5: 5452 4242   26
# 6: 4823 4823    4

More Related Contents:

  1. Faster ways to calculate frequencies and cast from long to wide
  2. Group by multiple columns and sum other multiple columns
  3. Aggregate a dataframe on a given column and display another column
  4. Returning first row of group
  5. Get the means of sub groups of means in R
  6. R use ddply or aggregate
  7. How to sum a variable by group
  8. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  9. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  10. Count number of rows per group and add result to original data frame
  11. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  12. Apply several summary functions on several variables by group in one call
  13. Summarizing multiple columns with dplyr? [duplicate]
  14. Extract the maximum value within each group in a dataframe [duplicate]
  15. How to create a lag variable within each group?
  16. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  17. Unique rows, considering two columns, in R, without order
  18. Summarizing by subgroup percentage in R
  19. Collapsing rows where some are all NA, others are disjoint with some NAs
  20. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  21. dplyr: “Error in n(): function should not be called directly”
  22. What does the dot mean in R – personal preference, naming convention or more?
  23. Count number of rows by group using dplyr
  24. Change value of variable with dplyr
  25. How to get top n companies from a data frame in decreasing order
  26. R sum a variable by two groups [duplicate]
  27. Combining duplicated rows in R and adding new column containing IDs of duplicates
  28. Aggregate by week in R
  29. Can `ddply` (or similar) do a sliding window?
  30. How can I count the number of NAs per group?

Leave a Comment