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@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]]

