Create counter with multiple variables [duplicate]

by

Use ave. Assuming your data.frame is called “mydf”:

mydf$counter <- with(mydf, ave(CustomerID, CustomerID, FUN = seq_along))
mydf
#   CustomerID TripDate counter
# 1          1 1/3/2013       1
# 2          1 1/4/2013       2
# 3          1 1/9/2013       3
# 4          2 2/1/2013       1
# 5          2 2/4/2013       2
# 6          3 1/2/2013       1

For what it’s worth, I also implemented a version of this approach in a function included in my “splitstackshape” package. The function is called getanID:

mydf <- data.frame(IDA = c("a", "a", "a", "b", "b", "b", "b"),
                   IDB = c(1, 2, 1, 1, 2, 2, 2), values = 1:7)
mydf
# install.packages("splitstackshape")
library(splitstackshape)
# getanID(mydf, id.vars = c("IDA", "IDB"))
getanID(mydf, id.vars = 1:2)
#   IDA IDB values .id
# 1   a   1      1   1
# 2   a   2      2   1
# 3   a   1      3   2
# 4   b   1      4   1
# 5   b   2      5   1
# 6   b   2      6   2
# 7   b   2      7   3

As you can see from the example above, I’ve written the function in such a way that you can specify one or more columns that should be treated as ID columns. It checks to see if any of the id.vars are duplicated, and if they are, then it generates a new ID variable for you.

More Related Contents:

  1. How to find common elements from multiple vectors?
  2. Calculating cumulative sum for each row
  3. Scatterplot with marginal histograms in ggplot2
  4. `lm` summary not display all factor levels
  5. How to perform natural (lexicographic) sorting in R? [duplicate]
  6. Unlist data frame column preserving information from other column
  7. Test if characters are in a string
  8. How can I handle R CMD check “no visible binding for global variable” notes when my ggplot2 syntax is sensible?
  9. Plotting time-series with Date labels on x-axis
  10. How to strsplit different number of strings in certain column by do function
  11. Why does R use partial matching?
  12. Operator == inconsistent in logical columns in data.table
  13. Change temporary directory
  14. How to Loop/Repeat a Linear Regression in R
  15. Complex non-equi merge in R
  16. What IDEs are available for R in Linux? [closed]
  17. eval and quote in data.table
  18. ggplot2: How to specify multiple fill colors for points that are connected by lines of different colors
  19. Change values in multiple columns of a dataframe using a lookup table
  20. caught segfault error in R
  21. How to detect the right encoding for read.csv?
  22. Writing multiple data frames into .csv files using R
  23. Converting factors to binary in R
  24. Return df with a columns values that occur more than once [duplicate]
  25. How to find the indices of the top 10,000 elements in a symmetric matrix(12k X 12k) in R
  26. Generate ggplot2 boxplot with different colours for multiple groups
  27. Importing csv file into R – numeric values read as characters
  28. Read csv from specific row
  29. Add raster to ggmap base map: set alpha (transparency) and fill color to inset_raster() in ggplot2
  30. Is it possible to have a multi-line comments in R? [duplicate]

Leave a Comment