That works.
Thanks
On Mon, Aug 9, 2010 at 7:55 AM, Henrique Dallazuanna <www...@gmail.com>wrote:
> Try this:
>
> aggregate(example[c('x', 'y')], example[c('id', 'Year')], 'mean')
>
>
> On Mon, Aug 9, 2010 at 11:46 AM, steven mosher <mosherste...@gmail.com>wrote:
>
>> Assuming a data frame or matrix with two columns representing variable
>> that
>> you want to aggregate over.
>> you want to calculate column means, by year, for each Id
>>
>>
>>
>>
>> example<-data.frame(id=c(rep(12345,5),rep(54321,6),rep(45678,7)),Year=rep(seq(1900,1902,by=1),6),
>> x=seq(1,18,by=1),y=seq(18,1,by=-1))
>> example
>> id Year x y
>> 1 12345 1900 1 18
>> 2 12345 1901 2 17
>> 3 12345 1902 3 16
>> 4 12345 1900 4 15
>> 5 12345 1901 5 14
>> 6 54321 1902 6 13
>> 7 54321 1900 7 12
>> 8 54321 1901 8 11
>> 9 54321 1902 9 10
>> 10 54321 1900 10 9
>> 11 54321 1901 11 8
>> 12 45678 1902 12 7
>> 13 45678 1900 13 6
>> 14 45678 1901 14 5
>> 15 45678 1902 15 4
>> 16 45678 1900 16 3
>> 17 45678 1901 17 2
>> 18 45678 1902 18 1
>>
>> result<-by(example[,3:4], example$id, by(example[,3:4],
>> example$Year,colMeans, na.rm=T))
>> Error in FUN(X[[1L]], ...) : could not find function "FUN
>>
>>
>> desired result should look like:
>> id Year meanx mean y
>> 1 12345 1900 ... ...
>> 2 12345 1901 ...
>> 3 12345 1902 ...
>> 4 54321 1900
>> 5 54321 1901
>> 6 54321 1902
>> 7 45678 1900
>> 8 45678 1901
>> 9 45678 1902
>>
>> [[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.
>>
>
>
>
> --
> Henrique Dallazuanna
> Curitiba-Paraná-Brasil
> 25° 25' 40" S 49° 16' 22" O
>
[[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.
