Having following dataframe.
id = c(1001, 1001, 1001, 1002, 1002, 1002, 1003, 1003, 1003)
status= c("A", "B", "C", "A", "B", "C", "A", "B", "C")
value = c(3,5,8,3,6,5,1,2,8)
foo = c("foo","foo","foo","foo","foo","foo","foo","foo","foo")
df = data.frame(id,status,value, foo)
id status value foo
1 1001 A 3 foo
2 1001 B 5 foo
3 1001 C 8 foo
4 1002 A 3 foo
5 1002 B 6 foo
6 1002 C 5 foo
7 1003 A 1 foo
8 1003 B 2 foo
9 1003 C 8 foo
I want to have columns for each element of the status column. Like the following
id A B C foo
1 1001 3 5 8 foo
2 1002 3 6 5 foo
3 1003 1 2 8 foo
I tried reshape but it affect, that the foo column will appear 3 times.
reshape(df, idvar = "id", timevar = "status", direction = "wide")
id value.A foo.A value.B foo.B value.C foo.C
1 1001 3 foo 5 foo 8 foo
4 1002 3 foo 6 foo 5 foo
7 1003 1 foo 2 foo 8 foo
´´´
