Count
Hi,
On Wed, May 13, 2015 at 5:58 AM, venkadesan venky <venkynov10 at gmail.com> wrote:
Hello Team, I have data like this have Small doubts on the following calculation For example, Employee size Camp 1 camp 2 Camp 3 1 1 0 0 2 0 0 1 3 1 1 0 1 0 0 1 2 1 0 0
Using dput() is easier for everyone else than just pasting your data in.
for employee size columns values are repeated and its not uniqe id so i
want to find that how many zero's are there in 1st id and 2nd id?
for example for employee size(1st row) 1=0+0
(4th row) 1=0+0
here totally 4 zero,s i want results like this
I'm not at all sure I understand what you're asking, but what about: testdata <- data.frame(EmpSize = c(1,2,3,1,2), Camp1 = c(1,0,1,0,1), Camp2 = c(0,0,1,0,0), Camp3 = c(0,1,0,1,0)) aggregate(rowSums(testdata[, -1] == 0), list(testdata$EmpSize), FUN="sum")
Sarah Goslee http://www.functionaldiversity.org