Collapsing data frame by selecting one row per group

by

Maybe duplicated() can help:

R> d[ !duplicated(d$x), ]
  x  y  z
1 1 10 20
3 2 12 18
4 4 13 17
R>

Edit Shucks, never mind. This picks the first in each block of repetitions, you wanted the last. So here is another attempt using plyr:

R> ddply(d, "x", function(z) tail(z,1))
  x  y  z
1 1 11 19
2 2 12 18
3 4 13 17
R>

Here plyr does the hard work of finding unique subsets, looping over them and applying the supplied function — which simply returns the last set of observations in a block z using tail(z, 1).

More Related Contents:

  1. Dynamically select data frame columns using $ and a character value
  2. Simultaneously merge multiple data.frames in a list
  3. Count number of rows within each group
  4. Drop unused factor levels in a subsetted data frame
  5. Why is it not advisable to use attach() in R, and what should I use instead?
  6. Create an empty data.frame
  7. Merging a lot of data.frames [duplicate]
  8. Create a group number for each consecutive sequence
  9. Subset data frame based on multiple conditions [duplicate]
  10. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  11. R – Concatenate two dataframes?
  12. Remove columns with zero values from a dataframe
  13. Calculating statistics on subsets of data [duplicate]
  14. Identifying duplicate columns in a dataframe
  15. R pass variable column indices to ggplot2 [duplicate]
  16. Get last row of each group in R [duplicate]
  17. Same function over multiple data frames in R
  18. Create empty data frame with column names by assigning a string vector? [duplicate]
  19. Dataframe create new column based on other columns
  20. What is about the first column in R’s dataset mtcars?
  21. Last Observation Carried Forward In a data frame? [duplicate]
  22. Determine the data types of a data frame’s columns
  23. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  24. What is difference between dataframe and list in R?
  25. Define dimensions of an empty dataframe
  26. Merge overlapping ranges into unique groups, in dataframe
  27. Deleting specific rows from a data frame
  28. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  29. R how can I calculate difference between rows in a data frame
  30. Color one point and add an annotation in ggplot2?

Leave a Comment