Getting the mean value for every Id in a data frame

Question

Imagine I have a data frame with 2 columns

Id    Value
12    13
32    3
6022  11
9142  231
12    23
119   312
...

and I want to get the mean value for each "Id". Do you know of any fast way of doing this?

Answer 1

One possible solution using aggregate:

aggregate(Value ~ Id, data=tmp, FUN=mean)

Answer 2

OK I figured it out. Using the plyr library and the ddply function.

Answer 3

Beyond aggregate, other options include by and ddply (in plyr).

Answer 4

Also by will do the job, yet the output will be tricky.

Answer 5

I heart reshape:

cast(x, Id ~ ., mean)

Answer 6

Just for completeness basic solution is tapply:

tapply(data$Value, data$Id, mean)

(or using with as with(data, tapply(Value, Id, mean)))