Create a sequential number (counter) for rows within each group of a dataframe [duplicate]

by

Some dplyr alternatives, using convenience functions row_number and n.

library(dplyr)
df %>% group_by(personid) %>% mutate(id = row_number())
df %>% group_by(personid) %>% mutate(id = 1:n())
df %>% group_by(personid) %>% mutate(id = seq_len(n()))
df %>% group_by(personid) %>% mutate(id = seq_along(personid))

You may also use getanID from package splitstackshape. Note that the input dataset is returned as a data.table.

getanID(data = df, id.vars = "personid")
#    personid date measurement .id
# 1:        1    x          23   1
# 2:        1    x          32   2
# 3:        2    y          21   1
# 4:        3    x          23   1
# 5:        3    z          23   2
# 6:        3    y          23   3

More Related Contents:

  1. Quickly reading very large tables as dataframes
  2. Counting unique / distinct values by group in a data frame
  3. Convert a list to a data frame
  4. cbind a dataframe with an empty dataframe – cbind.fill?
  5. Split a large dataframe into a list of data frames based on common value in column
  6. How to convert a data frame column to numeric type?
  7. Filtering a data frame by values in a column [duplicate]
  8. subtract value from previous row by group
  9. Repeat rows of a data.frame [duplicate]
  10. Adding a column of means by group to original data [duplicate]
  11. pair-wise duplicate removal from dataframe [duplicate]
  12. calculate the mean for each column of a matrix in R
  13. Transpose a data frame
  14. Subset of rows containing NA (missing) values in a chosen column of a data frame
  15. rbind dataframes with a different column name
  16. Converting two columns of a data frame to a named vector
  17. Collapsing data frame by selecting one row per group
  18. Change value of variable with dplyr
  19. Creating a new variable from a lookup table
  20. How to initialize empty data frame (lot of columns at the same time) in R
  21. Practical limits of R data frame
  22. rbind data frames based on a common pattern in data frame name
  23. Read and rbind multiple csv files
  24. Count number of zeros per row, and remove rows with more than n zeros
  25. How I can select rows from a dataframe that do not match?
  26. Join two data frames in R based on closest timestamp
  27. How to append a whole dataframe to a CSV in R
  28. Numbers as column names of data frames
  29. Divide each value by the sum of values by group
  30. Convert all data frame character columns to factors

Leave a Comment