How to find the average value for a combination of columns in R

Asked Dec 04 '18 at 09:14

Active Dec 04 '18 at 09:14

Viewed 14 times

I have the Following Dataset:

I want to be able to find the average value of C based on the combination of A and B. So basically I want to have the Following dataset as a result :

A B Avr_C
1 2 5
3 2 6
2 2 3

Any idea on how to proceed ? Thank you.

asked Dec 04 '18 at 09:14

MarGa

`aggregate(C~A + B, df, mean)` or with `dplyr`, `df %>% group_by(A, B) %>% summarise(Avr_C = mean(C))` – Ronak Shah Dec 04 '18 at 09:16
Thank you I tried aggregate and it worked – MarGa Dec 12 '18 at 12:52

0 Answers0