Or perhaps faster but less general: rowSums(mydata != 0)
Michael On Tue, Mar 6, 2012 at 12:56 PM, Sarah Goslee <sarah.gos...@gmail.com> wrote: > A reproducible example would be helpful, but lacking that > here's some untested code. If your data frame has NA values, > those will also need to be dealt with. > > apply(mydata, 1, function(x)sum(x != 0)) > > > Sarah > > On Tue, Mar 6, 2012 at 12:03 PM, mari681 <marianna.bologn...@gmail.com> wrote: >> I feel this is a very easy thing but I've never done it before and it is >> getting frustrating. >> I have a big data.frame (1445846 rows, 15 col) >> that looks like this: >> >> V1 V2 V3 V4 V5 >> >> 1 home sister brother chair 0 >> 2 cat dog animal 0 0 >> 3 girl boy 0 0 0 >> 4 knife fork spoon 0 0 >> >> and I want to count how many values different from 0 are in each row, and >> get the output count in a vector that is as long as length(MyTable). For the >> above example it would be c (4,3,2,3). >> I've tried sum (MyTable != "0") but it gives the total amount of values >> different from 0 in all the data.frame. >> And sum(MyTable [1,] != "0") obviously gives only the first row, even if I >> repeat it throughout all length(MyTable). >> How does that work? >> >> Thank you, >> >> a newbie. >> >> > > -- > Sarah Goslee > http://www.functionaldiversity.org > > ______________________________________________ > 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.
