Consolidate duplicate rows

by

This works:

library(plyr)
ddply(df,"x",numcolwise(sum))

in words: (1) split the data frame df by the "x" column; (2) for each chunk, take the sum of each numeric-valued column; (3) stick the results back into a single data frame. (dd in ddply stands for “take a d ata frame as input, return a d ata frame”)

Another, possibly clearer, approach:

aggregate(y~x,data=df,FUN=sum)

See quick/elegant way to construct mean/variance summary table for a related (slightly more complex) question.

More Related Contents:

  1. r – How to find value with condition
  2. Reshaping data.frame from wide to long format
  3. Combine two data frames by rows (rbind) when they have different sets of columns
  4. How to combine multiple conditions to subset a data-frame using “OR”?
  5. Formula with dynamic number of variables
  6. Order a “mixed” vector (numbers with letters)
  7. Remove space between plotted data and the axes
  8. How to merge 2 vectors alternating indexes?
  9. do.call(rbind, list) for uneven number of column
  10. Converting decimal to binary in R?
  11. How to read in numbers with a comma as decimal separator?
  12. Convert factor to integer [duplicate]
  13. Why use purrr::map instead of lapply?
  14. Create categories by comparing a numeric column with a fixed value
  15. Append value to empty vector in R?
  16. Add empty columns to a dataframe with specified names from a vector
  17. How to save a data.frame in R?
  18. Select first element of nested list
  19. listing contents of an R data file without loading
  20. R: Plotting a 3D surface from x, y, z
  21. How to prevent scientific notation in R? [duplicate]
  22. For the same code, labels (q1, median) appear on one computer but don’t appear on another computer
  23. How to reverse order a vector?
  24. Subset data.frame by date
  25. Asymmetric expansion of ggplot axis limits
  26. as.Date(as.POSIXct()) gives the wrong date?
  27. Convert scientific notation to numeric, preserving decimals
  28. Rcpp function check if missing value
  29. Fill option for fread
  30. Give name to list variable

Leave a Comment