Add ID column by group [duplicate]

by

Here’s one way using interaction.

d <- read.table(text="LAT LONG
13.5330 -15.4180 
13.5330 -15.4180 
13.5330 -15.4180 
13.5330 -15.4180 
13.5330 -15.4170 
13.5330 -15.4170 
13.5330 -15.4170 
13.5340 -14.9350 
13.5340 -14.9350 
13.5340 -15.9170 
13.3670 -14.6190", header=TRUE)

d <- transform(d, Cluster_ID = as.numeric(interaction(LAT, LONG, drop=TRUE)))

#       LAT    LONG Cluster_ID
# 1  13.533 -15.418          2
# 2  13.533 -15.418          2
# 3  13.533 -15.418          2
# 4  13.533 -15.418          2
# 5  13.533 -15.417          3
# 6  13.533 -15.417          3
# 7  13.533 -15.417          3
# 8  13.534 -14.935          4
# 9  13.534 -14.935          4
# 10 13.534 -15.917          1
# 11 13.367 -14.619          5

EDIT: Incorporated @Spacedman’s suggestion to supply drop=TRUE to interaction.

More Related Contents:

  1. Add count of unique / distinct values by group to the original data
  2. How can I remove all duplicates so that NONE are left in a data frame?
  3. Select groups based on number of unique / distinct values
  4. Count number of occurences for each unique value
  5. How to assign a unique ID number to each group of identical values in a column [duplicate]
  6. Unique rows, considering two columns, in R, without order
  7. Plot multiple lines (data series) each with unique color in R
  8. Unique on a dataframe with only selected columns
  9. Subset with unique cases, based on multiple columns
  10. data.table with two string columns of set elements, extract unique rows with each row unsorted
  11. unique() for more than one variable
  12. Merging rows with the same ID variable [duplicate]
  13. Count unique values for every column
  14. Removing duplicate combinations (irrespective of order)
  15. Index values from a matrix using row, col indices
  16. How to insert elements into a vector?
  17. R-Project no applicable method for ‘meta’ applied to an object of class “character”
  18. Update subset of data.table based on join
  19. R – use rbind on multiple variables with similar names
  20. Find start and end positions/indices of runs/consecutive values
  21. Modifying fonts in ggplot2
  22. spearman correlation by group in R
  23. Calculate cumulative average (mean)
  24. Using ifelse in R
  25. Put a break in the Y-Axis of a histogram
  26. Can rbind be parallelized in R?
  27. Linking Intel’s Math Kernel Library (MKL) to R on Windows
  28. Different Robust Standard Errors of Logit Regression in Stata and R
  29. dynamically add function to r6 class instance
  30. How to grep a word exactly

Leave a Comment