Thanks very much :)
Daniel Malter wrote: > > length(datasetname$Events[datasetname$Length<28 & > datasetname$Method%in%c(1,2,3) ...additional conditions... , ] > returns > the number of rows > sum(datasetname$Events[datasetname$Length<28 & > datasetname$Method%in%c(1,2,3) ...additional conditions... , ] > returns > the sum of the Events variable given your conditions > > does that work for you? > Daniel > > ------------------------- > cuncta stricte discussurus > ------------------------- > > -----Ursprüngliche Nachricht----- > Von: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] Im > Auftrag von jimdare > Gesendet: Thursday, July 23, 2009 8:07 PM > An: r-help@r-project.org > Betreff: [R] Sum with Conditions > > > Dear R-Users, > > I have a huge data set (172,696 rows) that is set out in the following > way: > > Area | Length | Species | Method | Date | Events > > I want to sum the number of Events if: > > Length < 28 AND > Species is NOT "X" ,"Y", or "Z" AND > Method is either "1" ,"2", or "3" AND > Date is between 31/12/08 AND 1/02/09 (i.e. JAN 09) > > Is there an easy way to do this? > > Your help is much appreciated. > > James > > > -- > View this message in context: > http://www.nabble.com/Sum-with-Conditions-tp24636551p24636551.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. > > ______________________________________________ > 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. > > -- View this message in context: http://www.nabble.com/Sum-with-Conditions-tp24636551p24637520.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.
