I have a data set consisting of over 18,000 points.
I need to average every 20 values. So, I need to average 1 through 20, then 21 through 40, and so on.
The data set is within a file. Help?
I have a data set consisting of over 18,000 points.
I need to average every 20 values. So, I need to average 1 through 20, then 21 through 40, and so on.
The data set is within a file. Help?
rollmean() and rollapply() from the zoo package is your friend here.
Try to take a look at this:
# Load libraries
library("tidyverse")
# Set dummy data
my_data <- tibble(points = rnorm(n = 18000))
# Create groups
my_data <- my_data %>%
mutate(group = rep(seq(from = 1, to = 18000 / 20), each = 20))
# Calculate grouped means
my_data %>%
group_by(group) %>%
summarise(mu = mean(points))
Hope it helps
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.