How can I get xtabs to calculate means instead of sums in R?

r average mean
Waldir Leoncio picture Waldir Leoncio · Jan 25, 2012 · Viewed 8.4k times · Source

I have a data frame where each line represents an individual. That data frame has two variables: age and year. I want to make a table of average ages per year. How can I do it?

The best I could come up with was xtabs(age ~ year, dataframe), but this gives me the sum of ages per year.

Answer

James picture James · Jan 25, 2012

Use aggregate:

xtabs(hp~cyl+gear,aggregate(hp~cyl+gear,mtcars,mean))
   gear
cyl        3        4        5
  4  97.0000  76.0000 102.0000
  6 107.5000 116.5000 175.0000
  8 194.1667   0.0000 299.5000

Related questions

Average across Columns in R, excluding NAs

I can't imagine I'm the first person with this question, but I haven't found a solution yet (here or elsewhere). I have a few columns, which I want to average in R. The only minimally tricky aspect is that some …

Read More
Calculate cumulative average (mean)

I would like to know how to calculate the cumulative average for some numbers. I will give a simple example to describe what I am looking for. I have the following numbers vec <- c(1, 2, 3, 4, 5) If I do the …

Read More
R : add an average line to an existing plot

I have done an application RShiny with a plot using ggplot. Now, I want to add an average line to the existing plot. library(ggplot2) A <- c(1:10) B <- c(1,1,2,2,3,3,4,4,5,5) donnees <- data.frame(A,B) …

Read More