Rearranging tables in R: column as variables

Question

I have a data.frame as follows:

df1 = data.table(Year=c(2009,2009, 2009,2010, 2010, 2010,2011,2011,2011), ID =c(162, 163,164,162, 163,164,162, 163,164), sum = c(2,5,6,3,4,6,4,2,7) )

I would like to rearrange df1 in such a way that the items of the variable "ID" are the new columns (or variable names) and the different years in variable "Year" become the rows. The third variable "sum" should complete table.

The desired output is as follows:

df2 = data.table(Year=c(2009, 2010, 2011), "162" = c(2,3,4 ), "163" = c( 5,4,2), "164" = c(6,6,7) )

Any smart solution?

the sample code reshape(df1, idvar = "Year", timevar = "ID", direction = "wide") — Lorenzo Benassi, Jul 17 '17 at 13:14

score -1 · Accepted Answer · answered Jul 17 '17 at 13:12

-1

   library(data.table)
 df2<-dcast(df1,Year~ID)

answered Jul 17 '17 at 13:12

Federico Manigrasso

1,130
1
7
11

Rearranging tables in R: column as variables

1 Answers1