[R] question about aggregate

[Weidong Gu]

Thanks for providing the example data, try this

 aggregate(si[,7],list(si[,2],si[,1]),function(x) sum(table(x)))

Weidong

On Sat, Oct 22, 2011 at 9:28 AM, Adel ESSAFI <adel.safi at imag.fr> wrote:
> NO
>> aggregate(si[,7],list(si[,2],si[,1]),mean)
>    Group.1 Group.2           x
> 1      0.0       D 212.5015448
> 2      0.2       D 200.5271137
> 3      0.4       D 191.5387529
> 4      0.6       D 131.5856218
> 5      0.8       D  16.4515798
> 6      1.0       D   0.9698699
> 7      0.0       F 211.6176036
> 8      0.2       F 199.5358336
> 9      0.4       F 179.1472057
> 10     0.6       F  70.3376311
> 11     0.8       F  25.0939253
> 12     1.0       F   0.9759778
> 13     0.0       I 199.1829674
> 14     0.2       I 188.8703456
> 15     0.4       I 147.5194562
> 16     0.6       I  18.1743204
> 17     0.8       I   0.9563789
> 18     1.0       I   0.9531993
> 19     0.0       L  95.1813009
> 20     0.2       L  95.1813009
> 21     0.4       L  92.3533476
> 22     0.6       L  47.1235041
> 23     0.8       L   9.4129464
> 24     1.0       L   0.9336508
> 25     0.0       S  95.1813009
> 26     0.2       S  91.4119070
> 27     0.4       S  81.9875960
> 28     0.6       S  11.3183831
> 29     0.8       S   1.8843307
> 30     1.0       S   0.9310779
>
> for exemple, for the last line, I want aggregate to show me the number of
> lines with col1=1 and col2=S in stead of the mean.
>
> Regards
>
>
>
> 2011/10/22 Weidong Gu <anopheles123 at gmail.com>
>>
>> Is this waht you want?
>>
>> sci[,5][sci[,2]==0 & sci[,1]==L]
>>
>> Weidong
>>
>> On Sat, Oct 22, 2011 at 8:19 AM, Adel ESSAFI <adelessafi at gmail.com> wrote:
>> > Hi,
>> > It is not what I want, but, thx anyway.
>> > Regards
>> >
>> >
>> > 2011/10/22 Weidong Gu <anopheles123 at gmail.com>
>> >>
>> >> try this
>> >>
>> >> table(sci[,2]=0,sci[,1]=L)
>> >>
>> >> Weidong Gu
>> >>
>> >> On Sat, Oct 22, 2011 at 7:51 AM, Adel ESSAFI <adel.safi at imag.fr> wrote:
>> >> > Hello,
>> >> > is there any help please.
>> >> > Regards
>> >> >
>> >> >
>> >> > 2011/10/21 Adel ESSAFI <adelessafi at gmail.com>
>> >> >
>> >> >> Hello
>> >> >> I am discovering R and I find it is really very powerful.
>> >> >>
>> >> >> However, I find some newbie difficulties.
>> >> >>
>> >> >> Here, I have a data frame with manu values that I want to calculate
>> >> >> the
>> >> >> frequency (the nomber of line) of the some criteria.
>> >> >> For exemple here,  I want it to print the number of occurence where
>> >> >> sci[,2]=0 and sci[,1]=L. In my exemple, he is printing the number of
>> >> >> the
>> >> >> line in the result data frame.
>> >> >> however, I have at least 90 line with sci[,2]=0 and sci[,1]=L.
>> >> >> Thank you in advance for any input.
>> >> >>
>> >> >>
>> >> >> >  aggregate(sci[,5],list(sci[,2],sci[,1]),frequency)
>> >> >>    Group.1 Group.2 x
>> >> >> 1      0.0       L 1
>> >> >> 2      0.2       L 1
>> >> >>
>> >> >>
>> >> >> --
>> >> >> PhD candidate in Computer Science
>> >> >> Address
>> >> >> 3 avenue lamine, cité ezzahra, Sousse 4000
>> >> >> Tunisia
>> >> >> tel: +216 97 246 706 (+33640302046 jusqu'au 15/6)
>> >> >> fax: +216 71 391 166
>> >> >>
>> >> >
>> >> >
>> >> >
>> >> > --
>> >> > *PhD candidate in Computer Science
>> >> > Address
>> >> > 3 avenue lamine, cité ezzahra, Sousse 4000
>> >> > Tunisia
>> >> > tel: +216 97 246 706
>> >> > fax: +216 71 391 166*
>> >> >
>> >> >        [[alternative HTML version deleted]]
>> >> >
>> >> >
>> >> > ______________________________________________
>> >> > 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.
>> >> >
>> >> >
>> >>
>> >> ______________________________________________
>> >> 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.
>> >
>> >
>> >
>> > --
>> > PhD candidate in Computer Science
>> > Address
>> > 3 avenue lamine, cité ezzahra, Sousse 4000
>> > Tunisia
>> > tel: +216 97 246 706 (+33640302046 jusqu'au 15/6)
>> > fax: +216 71 391 166
>> >
>
>
>
> --
> PhD candidate in Computer Science
> Address
> 3 avenue lamine, cité ezzahra, Sousse 4000
> Tunisia
> tel: +216 97 246 706
> fax: +216 71 391 166
>