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
> From:> P_ID CROP Period Ini_AgeCROP_ID CROPTYPE Period Ini_Age 83 SORI 1 31 84 SORI 1 32 85 SORI 1 33 86 SORI 1 34 82 SORI 2 28 83 SORI 2 29 84 SORI 2 30 93 SORM 2 35 62 OTRM 3 30 82 SORI 3 27 3 SORM 3 35 82 SORI 4 26 4 SORM 4 34 5 OTRI 5 25 5 OTRM 5 29 5 SORM 5 32 5 SORM 5 33 5 SORM 5 35 6 OTRI 6 22 6 OTRI 6 23 6 OTRI 6 24 6 OTRM 6 26 6 OTRM 6 27 6 OTRM 6 28 7 OTRM 7 26 8 OTRM 8 26 9 OTRM 9 26 10 OTRM 10 24 10 OTRM 10 25 10 OTRM 10 26 10 SORM 10 31> > 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 >
Sorry, the second email is accidently sent. Yes, the Cut Area should not be included in the data in the first email. The second email has a correct data. Thanks. Noli
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]]