R – add column that counts sequentially within groups but repeats for duplicates

by

dense_rank it is

library(dplyr)
df %>% 
  group_by(section) %>% 
  mutate(desire=dense_rank(exhibit))
#  section exhibit desired_result desire
#1       1       a              1      1
#2       1       b              2      2
#3       1       c              3      3
#4       1       c              3      3
#5       2       a              1      1
#6       2       b              2      2
#7       2       b              2      2
#8       2       c              3      3

More Related Contents:

  1. R spreading multiple columns with tidyr [duplicate]
  2. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  3. dplyr filter with condition on multiple columns
  4. How to add a cumulative column to an R dataframe using dplyr?
  5. Get last row of each group in R [duplicate]
  6. Change value of variable with dplyr
  7. dplyr – filter by group size
  8. Merge rows in a dataframe where the rows are disjoint and contain NAs
  9. Calculate group mean while excluding current observation using dplyr
  10. mutate_each / summarise_each in dplyr: how do I select certain columns and give new names to mutated columns?
  11. finding close match from data frame 1 in data fame 2
  12. dplyr change many data types
  13. Join two data frames in R based on closest timestamp
  14. How to dplyr rename a column, by column index?
  15. How to add only missing Dates in Dataframe
  16. Override column types when importing data using readr::read_csv() when there are many columns
  17. Adding column if it does not exist
  18. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  19. Filter rows which contain a certain string
  20. Filtering a data frame on a vector [duplicate]
  21. How to replace NA values in a table for selected columns
  22. Programming with dplyr using string as input
  23. Select every nth row from dataframe
  24. duplicates in multiple columns
  25. Delete columns/rows with more than x% missing
  26. Splitting a data.frame by a variable [duplicate]
  27. Unlist a data frame by rows, not columns
  28. dplyr: lead() and lag() wrong when used with group_by()
  29. Reorder rows using custom order
  30. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently

Leave a Comment