Assign unique ID based on two columns [duplicate]

by

We can do this in base R without doing any group by operation

df$ID <- cumsum(!duplicated(df[1:2]))
df
#   School Student Year ID
#1      A      10 1999  1
#2      A      10 2000  1
#3      A      20 1999  2
#4      A      20 2000  2
#5      A      20 2001  2
#6      B      10 1999  3
#7      B      10 2000  3

NOTE: Assuming that ‘School’ and ‘Student’ are ordered

Or using tidyverse

library(dplyr)
df %>% 
    mutate(ID = group_indices_(df, .dots=c("School", "Student"))) 
#  School Student Year ID
#1      A      10 1999  1
#2      A      10 2000  1
#3      A      20 1999  2
#4      A      20 2000  2
#5      A      20 2001  2
#6      B      10 1999  3
#7      B      10 2000  3

As @radek mentioned, in the recent version (dplyr_0.8.0), we get the notification that group_indices_ is deprecated, instead use group_indices

df %>% 
   mutate(ID = group_indices(., School, Student))

More Related Contents:

  1. Combine two or more columns in a dataframe into a new column with a new name
  2. apply a function over groups of columns
  3. Change values in multiple columns of a dataframe using a lookup table
  4. R: Replace multiple values in multiple columns of dataframes with NA
  5. Apply a function to a subset of data.table columns, by column-indices instead of name
  6. replacing values in a column with another column R
  7. How to replace a value by another within a variable in R?
  8. Quickly reading very large tables as dataframes
  9. Calculating moving average
  10. Relative frequencies / proportions with dplyr
  11. How to add texture to fill colors in ggplot2
  12. Cleaning up factor levels (collapsing multiple levels/labels)
  13. Split a large dataframe into a list of data frames based on common value in column
  14. ggplot, facet, piechart: placing text in the middle of pie chart slices
  15. Dividing columns by colSums in R
  16. Convert seconds to days: hours:minutes:seconds
  17. Concatenate strings and expressions in a plot’s title
  18. Range standardization (0 to 1) in R [duplicate]
  19. Create a ranking variable with dplyr?
  20. Find value corresponding to maximum in other column [duplicate]
  21. Split delimited single value character vector
  22. R split numeric vector at position
  23. How to add different lines for facets
  24. Creating a Plot Window of a Particular Size
  25. Join two data frames in R based on closest timestamp
  26. Update/Replace Values in Dataframe with Tidyverse Join
  27. Importing a big xlsx file into R?
  28. How do you create vectors with specific intervals in R?
  29. How do I draw gridlines using abline() that are behind the data?
  30. Round a POSIX date (POSIXct) with base R functionality

Leave a Comment