How to assign a unique ID number to each group of identical values in a column [duplicate]

by

How about

df2 <- transform(df,id=as.numeric(factor(sample)))

?

I think this (cribbed from Add ID column by group) should be slightly more efficient, although perhaps a little harder to remember:

df3 <- transform(df, id=match(sample, unique(sample)))
all.equal(df2,df3)  ## TRUE

If you want to do this in tidyverse:

library(dplyr)
df %>% group_by(sample) %>% mutate(id=cur_group_id())

More Related Contents:

  1. Select groups based on number of unique / distinct values
  2. Count unique values for every column
  3. Deleting specific rows with a pattern[start and end indicators] from a dataframe [closed]
  4. Replace values in a dataframe based on lookup table
  5. Sample random rows in dataframe
  6. Subset / filter rows in a data frame based on a condition in a column
  7. Replacing character values with NA in a data frame
  8. Subset dataframe by multiple logical conditions of rows to remove
  9. Named List To/From Data.Frame
  10. Merge two data frames while keeping the original row order
  11. How to add a row to a data frame in R?
  12. Replace all particular values in a data frame
  13. Subtract a column in a dataframe from many columns in R
  14. Why am I getting X. in my column names when reading a data frame?
  15. Creating a summary statistical table from a data frame
  16. Merge rows in a dataframe where the rows are disjoint and contain NAs
  17. Add an index (numeric ID) column to large data frame [duplicate]
  18. Replace logical values (TRUE / FALSE) with numeric (1 / 0)
  19. How to delete rows where all the columns are zero
  20. Convert a dataframe to a vector (by rows)
  21. Transposing a dataframe maintaining the first column as heading
  22. Filter data frame rows based on values in vector
  23. Replace empty values with value from other column in a dataframe
  24. Replace values in data frame based on other data frame in R
  25. Identify records in data frame A not contained in data frame B [closed]
  26. Add an image to a table-like output in R
  27. Replace value with the name of its respective column
  28. Difference between `names(df[1])
  29. How to create a new variable in a data.frame based on a condition?
  30. Interpolating timeseries

Leave a Comment