Transform data frame rows into columns using duplicate ID in R

Question

I want to transform my data frame using my ID columns creating new variable under a single ID.

>Data1
ID  Object  ITEM    Time    Value
1   a       123     7pm     12.0
1   b       234     8pm     4.0
1   c       345     7pm     1.0 
2   a       123     7am     6.0
2   b       234     8pm     8.1
2   c       345     12pm    9.7


ID  Object1 ITEM1   Time1   Value1  Object2 ITEM2   Time2   Value2  Object3 ITEM3   Time3   Value3
1   a       123     7pm     12.0    b       234     8pm     4.0     c       345     7pm     1.0
2   a       123     7am     6.0     b       234     8pm     8.1     c       345     12pm    9.7

Thank you.

score 1 · Accepted Answer · answered Feb 26 '17 at 04:41

We can do this using dcast from data.table which can take multiple value.var columns

library(data.table)
dcast(setDT(Data1), ID~rowid(ID), value.var = names(Data1)[-1])
#   ID Object_1 Object_2 Object_3 ITEM_1 ITEM_2 ITEM_3 Time_1 Time_2 Time_3
#1:  1        a        b        c    123    234    345    7pm    8pm    7pm
#2:  2        a        b        c    123    234    345    7am    8pm   12pm
#   Value_1 Value_2 Value_3
#1:      12     4.0     1.0
#2:       6     8.1     9.7

Transform data frame rows into columns using duplicate ID in R

1 Answers1