How to group a data.frame each integer number of rows?

Question

This seems to me a very simple question but I don't manage to come up with an efficient idea.

I have a data frame in R so composed:

I want to group the dataframe each k rows (k being an integer input) and then calculate the mean of each group.

The dplyr function group_by does not allow me to group for a specific integer number of rows.

How can I do that? Is there a way to avoid creating the column position at all?

Try `df1 %>% group_by(grp = as.integer(gl(n(), k, n()))) %>% summarise(value = mean(value))` — akrun, Oct 23 '19 at 17:46
Absolutely perfect, consider updating as answer so can close the question! — Vitomir, Oct 23 '19 at 17:53

score 1 · Accepted Answer · answered Oct 23 '19 at 17:55

1

Here is one option with gl from base R. Specify the n and k values. The n would be the total number of rows in the dataset

library(dplyr)
k1 <- 5
df1 %>% 
  group_by(grp = as.integer(gl(n(), k = k1, n()))) %>% 
  summarise(value = mean(value))

answered Oct 23 '19 at 17:55

akrun

1 Answers1