dplyr group_by a large number of variables

Sometimes one has a number of variables with the same grouping, in particular as a result of doing a gather on some variables, ex:

  x0     x1    x2 variable     value 1  1   Male Green        1 0.1803306 2  1   Male Green        2 0.5619410 3  1   Male Green        3 0.9905186 4  2 Female  Blue        1 0.1549419 5  2 Female  Blue        2 0.6917326 6  2 Female  Blue        3 0.6509738 

In such a case, I'd like to compute a grouped summary statistic (say, group_by(x0) %>% summarize(sum(value))) while preserving all the ID variables given by the first columns. One way is to do group_by(x0, x1, x2) but this becomes a little messy if there are a large number of ID variables, and group_by doesn't seem to work with the functions from select, so I can't do group_by(starts_with("x")). How can I cleanly preserve all my ID variables post-summarize without typing out each variable name individually?

Replay

Category: r Time: 2016-07-28 Views: 0
Tags: dplyr

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.247 (s). 12 q(s)