Tranpose and Aggregate Data
Schalk, Thank you very much for this. Noli
On 1/5/10, Schalk Heunis <schalk.heunis at gmail.com> wrote:
Hi
You can use the reshape package to achieve this. If you don't have it
installed, install.packages('reshape'). Then look at ?cast and (possibly)
?melt
HTH!
Schalk
On Tue, Jan 5, 2010 at 7:59 AM, Noli Sicad <nsicad at gmail.com> wrote:
Hi,
I need to transpose and aggregate the 4th and 5th column of this data
set (below). The period is 1 to 100 years and some period has 1 entry
as shown in the example below.
Any ideas how to do this. Thanks in advance.
Noli
~~~~~~~~~~
From:
P_ID CROP Period Ini_Age Area_Cut
83 SORI 1 31 528.2465512
84 SORI 1 32 74.55179899
85 SORI 1 33 72.45778618
86 SORI 1 34 139.5272947
82 SORI 2 28 1.711642933
83 SORI 2 29 2.500000071
84 SORI 2 30 432.5139327
93 ORM 2 35 316.8422545
62 OTRM 3 30 64.60526438
82 SORI 3 27 26.93674606
3 SORM 3 35 223.3658345
82 SORI 4 26 2.500000071
4 SORM 4 34 1008.643
5 OTRI 5 25 32.42603214
5 OTRM 5 29 65.9031344
5 SORM 5 32 223.1489321
5 SORM 5 33 72.59203041
5 SORM 5 35 222.8402746
6 OTRI 6 22 2.499999851
6 OTRI 6 23 3.374626509
6 OTRI 6 24 96.13462257
6 OTRM 6 26 830.7463641
6 OTRM 6 27 731.6228643
6 OTRM 6 28 16.3519762
7 OTRM 7 26 1636.5693
8 OTRM 8 26 553.0050146
9 OTRM 9 26 894.414033
10 OTRM 10 24 38.72597099
10 OTRM 10 25 308.6452707
10 OTRM 10 26 786.1761969
10 SORM 10 31 235.8360136
To this.
P_ID CROP P1 P2 P3 P4 P5 P6 P7
P8 P9 P10
83 SORI 31
84 SORI 32
85 SORI 33
86 SORI 34
82 SORI 28
83 SORI 29
84 SORI 30
93 SORM 35
62 OTRM 30
82 SORI 27
3 SORM 35
82 SORI 26
4 SORM 34
5 OTRI 25
5 OTRM 29
5 SORM 32
5 SORM 33
5 SORM 35
6 OTRI 22
6 OTRI 23
6 OTRI 24
6 OTRM 26
6 OTRM 27
6 OTRM 28
7 OTRM 26
8 OTRM 26
9 OTRM
26
10 OTRM
24
10 OTRM
25
10 OTRM
26
10 SORM
31
______________________________________________ R-help at 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.