I would like to get the mean of multiple columns in this data set https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2019/2019-01-29/milk_products_facts.csv
What I am trying to achieve is getting the averages of all the milk products from the past 10 years (2008-2017.) I so far have something like this.. but I am stuck.
milk_product_facts %>%
group_by(year > 2008) %>%
summarise(across(everything(), list(mean())))
If anyone can help me with this. Thank you!
The mean() will be not get the output as we are passing empty argument i.e
library(dplyr)
mean()
Error in mean.default() : argument "x" is missing, with no default
We need either mean called without anonymous function call (or lambda)
milk_product_facts %>%
filter(year > 2008) %>%
group_by(year) %>%
summarise(across(everything(), mean))
Or use lambda function
milk_product_facts %>%
filter(year > 2008) %>%
group_by(year) %>%
summarise(across(everything(), ~ mean(.))
Or if we are wrapping with list
milk_product_facts %>%
filter(year > 2008) %>%
group_by(year) %>%
summarise(across(everything(), list(~ mean(.))))