Returning first row of group

by

By reproducing the example data frame and testing it I found a way of getting the needed result:

  1. Order data by relevant columns (ID, Start)

    ordered_data <- data[order(data$ID, data$Start),]

  2. Find the first row for each new ID

    final <- ordered_data[!duplicated(ordered_data$ID),]

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. Aggregate a data frame based on unordered pairs of columns
  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. Apply function conditionally
  18. Unique rows, considering two columns, in R, without order
  19. Summarizing by subgroup percentage in R
  20. Collapsing rows where some are all NA, others are disjoint with some NAs
  21. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  22. dplyr: “Error in n(): function should not be called directly”
  23. Change value of variable with dplyr
  24. Aggregate and reshape from long to wide
  25. R sum a variable by two groups [duplicate]
  26. Combining duplicated rows in R and adding new column containing IDs of duplicates
  27. ddply for sum by group in R
  28. Run a custom function on a data frame in R, by group
  29. R – Faster Way to Calculate Rolling Statistics Over a Variable Interval
  30. Aggregating all unique values of each column of data frame

Leave a Comment