[R] frequency count by row

[R. Michael Weylandt]

Or perhaps faster but less general:

rowSums(mydata != 0)

Michael

On Tue, Mar 6, 2012 at 12:56 PM, Sarah Goslee <sarah.goslee at 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.bolognesi at 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 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.