Merging rows with the same ID variable [duplicate]

by

You could use the enhanced dcast function from the data.table package for that where you can select multiple value variables. With setDT(mydf) you convert your dataframe to a datatable and with [, idx := 1:.N, by = ID] you add a index by ID which you use subsequently in the dcast formula:

library(data.table)
dcast(setDT(mydf)[, idx := 1:.N, by = ID], ID ~ idx, value.var = c("x","y"))

Or with the development version of data.table (v1.9.7+), you can use the new rowid function:

dcast(setDT(mydf), ID ~ rowid(ID), value.var = c("x","y"))

gives:

   ID x_1 x_2 x_3 y_1 y_2 y_3
1:  a   1   1   2   2   4   3
2:  b   1   3  NA   3   2  NA
3:  c   2  NA  NA   4  NA  NA
4:  d   1  NA  NA   3  NA  NA

Used data:

mydf <- structure(list(x = c(1L, 1L, 2L, 1L, 1L, 3L, 2L), y = c(2L, 3L, 
4L, 3L, 4L, 2L, 3L), ID = structure(c(1L, 2L, 3L, 4L, 1L, 2L, 
1L), .Label = c("a", "b", "c", "d"), class = "factor")), .Names = c("x", 
"y", "ID"), class = "data.frame", row.names = c(NA, -7L))

More Related Contents:

  1. How can I remove all duplicates so that NONE are left in a data frame?
  2. data.table with two string columns of set elements, extract unique rows with each row unsorted
  3. Simultaneously merge multiple data.frames in a list
  4. Finding ALL duplicate rows, including “elements with smaller subscripts”
  5. Overlap join with start and end positions
  6. Add count of unique / distinct values by group to the original data
  7. Find indices of duplicated rows [duplicate]
  8. Left join using data.table
  9. Merging a lot of data.frames [duplicate]
  10. How to assign a unique ID number to each group of identical values in a column [duplicate]
  11. Plot multiple lines (data series) each with unique color in R
  12. Merge two data frames while keeping the original row order
  13. How to delete rows from a dataframe that contain n*NA
  14. Filtering out duplicated/non-unique rows in data.table
  15. Merge unequal dataframes and replace missing rows with 0
  16. Use merge() to update a data frame with values from a second data frame
  17. Remove duplicates keeping entry with largest absolute value
  18. R ggplot2 merge with shapefile and csv data to fill polygons
  19. unique() for more than one variable
  20. Combine/merge lists by elements names
  21. Delete duplicate rows in two columns simultaneously [duplicate]
  22. Select rows from one data.frame that are not present in a second data.frame
  23. Merge data frames based on rownames in R
  24. Merging two columns into one in R [duplicate]
  25. Merge error : negative length vectors are not allowed
  26. Identify records in data frame A not contained in data frame B [closed]
  27. Efficiently merging two data frames on a non-trivial criteria
  28. How can I merge more than 2 dataframes in R by rownames?
  29. list of masked functions in R
  30. How can I merge many data frames from csv files when the ID column is implied?

Leave a Comment