aggregate with multiple functions in r

Asked May 30 '19 at 11:17

Active May 30 '19 at 12:43

Viewed 17 times

I have a simple dataframe, and want to aggregate on both mean and count of each.

I have three steps:

aggregate(x$value1,list(x$col1),mean)
aggregate(x$value1,list(x$col1),nrow)
merge(d1,d2,by='Group.1')
colnames(m)=c('col1','mean','count')

I am sure there is a more efficient way to do this in R.

Any suggestions?

edited May 30 '19 at 12:43

Rohit

asked May 30 '19 at 11:17

frank

`aggregate(value1 ~ col1, x, function(p) c(mean(p), length(p)))` – Ronak Shah May 30 '19 at 11:22
I would suggest using the `dplyr` package. You could do : `x %>% group_by(col1) %>% summarise(mean=mean(value1),count=n())` – Rohit May 30 '19 at 11:26
thanks, I knew it was there!! Don't code 10hours straight without caffeine – frank May 30 '19 at 11:28

0 Answers0