An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111021/cbab86c1/attachment.pl>
question about aggregate
11 messages · Weidong Gu, R. Michael Weylandt, Adel ESSAFI
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111022/d5620785/attachment.pl>
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111022/1ef7efe2/attachment.pl>
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.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111022/4847692e/attachment.pl>
Perhaps I misunderstand your request, but isn't this just: sum( (sci[,,2]==0L) & (sci[,1] =="L")) with the usual floating point caveats. Michael
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 ? ? ? ?[[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.
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
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111022/7b8058da/attachment.pl>
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111022/e991eb02/attachment.pl>
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
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111022/27006b55/attachment.pl>