dplyr summarize multiple column

Question

I have a simple dataframe with the following column name

Subject # Type #  Value0 # value1# value2# ....value100

I want to use the dplyr summarize operation in order to get the mean of each value columns. I think there is a useful alternative to

ddply(dataframe, c("Subject,Type"), summarize, m1= mean(value1), m2=mean(value2)....)

If I gather all Value column name in a list

names =c("Value0,Value1,....Value100)

How can I use this list in ddply?

score 0 · Answer 1 · answered Jan 21 '16 at 10:57

0

We can use summarise_each

library(dplyr)
df1 %>%
     group_by(Subject, Type) %>%
     summarise_each(funs(mean= mean(., na.rm=TRUE)))

answered Jan 21 '16 at 10:57

akrun

Thank. But If i want the mean for each column from Value0 to Value5 ? – fableb Jan 22 '16 at 12:08
@user2226667 Have you tried the code? It is giving the mean for each column. – akrun Jan 22 '16 at 12:10
1

@user2226667 `summarise_each(funs(mean), Value0:Value5)` is the way you should be able to do that. – Paul Hiemstra Jan 16 '17 at 15:43

1 Answers1