Hi David,

1) Thanks very much. Your code shows that this was much simpler than I
anticipated.

2) I have made the appropriate changes to email in plain text. My apologies.

Thanks!

Dan


On Wed, Oct 30, 2013 at 1:17 PM, David Winsemius <dwinsem...@comcast.net> wrote:
>
> On Oct 30, 2013, at 4:07 AM, Dan Abner wrote:
>
>> Hi everybody,
>>
>> I have data in the format of the example data below where essentially a
>> large number of indicator variables (coded [0,1]) reflect traits of the
>> same id across multiple rows. I need to represent the data in a 1 row per
>> id format. I see this as being similar to converting from long to wide
>> format, however, there is no time component here: The multiple rows here
>> are all characteristics observed at the same measurement occasion. So,
>> really I just need an individual sum for each variable (for a large number
>> of variables) and for these to be all saved in the same row (along with the
>> id variable and other demographics (e.g., "location").
>>
>> Here is the example df and the method I used first:
>>
>>
>> d1<-data.frame(id=c(1,1,1,2,2,2,2,3,3,4),location=factor(c(rep(0,7),rep(1,3)),
>> labels=c("A","B")),var1=as.logical(round(runif(10))),
>> var2=as.logical(round(runif(10))),var3=as.logical(round(runif(10))))
>> d1
>
> Perhaps.
>
>> mysum<-aggregate(d1[-(1:2)],by=d1[1:2] ,sum)
>> mysum
>   id location var1 var2 var3
> 1  1        A    0    2    1
> 2  2        A    1    2    1
> 3  3        B    1    0    2
> 4  4        B    1    1    0
>
>>
>>       [[alternative HTML version deleted]]
>
> Please learn to use your mail client to post in plain text. (All of the free 
> mailer services support plain text, so continuing to post in HYML is evidence 
> of willful refusal to adhere to the posting guidelines.)
>
> --
> David Winsemius
> Alameda, CA, USA
>

______________________________________________
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.

Reply via email to