Hello,
I am trying to reshape a data.frame in wide format into long format.
Although in the reshape R documentation
they programmer list some examples I am struggling to bring my data.frame
into long and then transform it back into wide format. The data.frame I look
at is:
df <- data.frame(ID1 = c(1,1,1,1,1,1,1,1,1), ID2 = c("A", "A", "A", "B",
"B", "B", "C", "C", "C"),
ID3 = c("E", "E", "E", "E", "E", "E", "E",
"E", "E"),
X1 = c(1,4,3,5,2,4,6,4,2), X2 =
c(6,8,9,6,7,8,9,6,7),
X3 = c(7,6,7,5,6,5,6,7,5), X4 =
c(1,2,1,2,3,1,2,1,2))
> df
ID1 ID2 ID3 X1 X2 X3 X4
1 1 A E 1 6 7 1
2 1 A E 4 8 6 2
3 1 A E 3 9 7 1
4 1 B E 5 6 5 2
5 1 B E 2 7 6 3
6 1 B E 4 8 5 1
7 1 C E 6 9 6 2
8 1 C E 4 6 7 1
9 1 C E 2 7 5 2
I want to use the reshape function to get the following result:
> df
ID1 ID2 ID3 X
1 1 A E 1
2 1 A E 4
3 1 A E 3
4 1 B E 5
5 1 B E 2
6 1 B E 4
7 1 C E 6
8 1 C E 4
9 1 C E 2
10 1 A E 6
11 1 A E 8
12 1 A E 9
13 1 B E 6
14 1 B E 7
15 1 B E 8
16 1 C E 9
17 1 C E 6
18 1 C E 7
19 1 A E 7
20 1 A E 6
21 1 A E 7
22 1 B E 5
23 1 B E 6
24 1 B E 5
25 1 C E 6
26 1 C E 7
27 1 C E 5
28 1 A E 1
29 1 A E 2
30 1 A E 1
31 1 B E 2
32 1 B E 3
33 1 B E 1
34 1 C E 2
35 1 C E 1
36 1 C E 2
Can anyone help?
Cheers
--
View this message in context:
http://r.789695.n4.nabble.com/Help-on-reshape-function-tp4449464p4449464.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
