Calculate mean across 2 variables of a 3 variable data.frame

Question

I have a data frame with color, quality and price and I want to compare how the color changes perception of quality.
I need to get a table with the mean of the prices for every color and quality combination.
I am currently trying with aggregate but I can't seem to find the proper combination.

aggregate(price ~ color, list(Quality = D$quality), data=D, FUN=mean);

make a reproducible example with simulated data or dput and desired output — Andre Elrico, Oct 13 '17 at 10:59
Look here: [minimal reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example). — Samuel, Oct 13 '17 at 11:10

score 0 · Answer 1 · answered Oct 13 '17 at 11:19

0

Yuo can try:

library(tidyverse)
mtcars %>% 
  group_by(cyl, gear) %>% 
  summarise(M_mpg=mean(mpg)) %>% 
  spread(cyl, M_mpg)

answered Oct 13 '17 at 11:19

Roman

17,008
3
36
49

Calculate mean across 2 variables of a 3 variable data.frame

1 Answers1