Schalk, Thank you very much for this.
Noli On 1/5/10, Schalk Heunis <schalk.heu...@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 <nsi...@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@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. >> > ______________________________________________ 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.