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. > [[alternative HTML version deleted]] ______________________________________________ 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.