[R] Tranpose and Aggregate Data

[Noli Sicad]

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.
>>
>