Select first and last row from grouped data

by

There is probably a faster way:

df %>%
  group_by(id) %>%
  arrange(stopSequence) %>%
  filter(row_number()==1 | row_number()==n())

More Related Contents:

  1. Summarizing multiple columns with dplyr? [duplicate]
  2. Relative frequencies / proportions with dplyr
  3. How to create a lag variable within each group?
  4. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  5. Filter data frame by character column name (in dplyr)
  6. How to number/label data-table by group-number from group_by?
  7. Remove duplicated rows using dplyr
  8. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  9. dplyr: “Error in n(): function should not be called directly”
  10. dplyr: inner_join with a partial string match
  11. Can dplyr summarise over several variables without listing each one? [duplicate]
  12. Change value of variable with dplyr
  13. sample rows of subgroups from dataframe with dplyr
  14. Assigning Dates to Fiscal Year
  15. filter function in dplyr errors: object ‘name’ not found
  16. Create a ranking variable with dplyr?
  17. How to pass dynamic column names in dplyr into custom function?
  18. Calculate group mean while excluding current observation using dplyr
  19. R – Group by variable and then assign a unique ID [duplicate]
  20. Emulate split() with dplyr group_by: return a list of data frames
  21. Sparklyr: how to center a Spark table based on column?
  22. R sum a variable by two groups [duplicate]
  23. Join two data frames in R based on closest timestamp
  24. Conditionally Count in dplyr
  25. data.table row-wise sum, mean, min, max like dplyr?
  26. Update/Replace Values in Dataframe with Tidyverse Join
  27. dplyr: put count occurrences into new variable [duplicate]
  28. Add row in each group using dplyr and add_row()
  29. How to replace certain values in a specific rows and columns with NA in R?
  30. Why does as_tibble() round floats to the nearest integer?

Leave a Comment