[R] Help on reshape function

[mails]

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.