Calculate the mean of every 13 rows in data frame

by

Here’s a solution using aggregate() and rep().

df <- data.frame(a=1:12, b=13:24 );
df;
##     a  b
## 1   1 13
## 2   2 14
## 3   3 15
## 4   4 16
## 5   5 17
## 6   6 18
## 7   7 19
## 8   8 20
## 9   9 21
## 10 10 22
## 11 11 23
## 12 12 24
n <- 5;
aggregate(df, list(rep(1:(nrow(df) %/% n + 1), each = n, len = nrow(df))), mean)[-1];
##      a    b
## 1  3.0 15.0
## 2  8.0 20.0
## 3 11.5 23.5

The important part of this solution that handles the issue of non-divisibility of nrow(df) by n is specifying the len parameter (actually the full parameter name is length.out) of rep(), which automatically caps the group vector to the appropriate length.

More Related Contents:

  1. Split data frame string column into multiple columns
  2. How to split a data frame?
  3. Split a large dataframe into a list of data frames based on common value in column
  4. Splitting a dataframe string column into multiple different columns [duplicate]
  5. Split dataframe into multiple output files
  6. Split data.frame by value
  7. Splitting a string into new rows in R [duplicate]
  8. Splitting a large data frame into smaller segments
  9. Split Data Frame into Rows of Fixed Size
  10. Split up a dataframe by number of rows
  11. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  12. Split a column by group [duplicate]
  13. Count number of rows within each group
  14. Drop unused factor levels in a subsetted data frame
  15. Why is it not advisable to use attach() in R, and what should I use instead?
  16. Create an empty data.frame
  17. Select rows with min value by group
  18. Shifting non-NA cells to the left
  19. Omit rows containing specific column of NA
  20. Repeat rows of a data.frame N times
  21. For each row in an R dataframe
  22. Same function over multiple data frames in R
  23. Dataframe create new column based on other columns
  24. What is about the first column in R’s dataset mtcars?
  25. Last Observation Carried Forward In a data frame? [duplicate]
  26. finding close match from data frame 1 in data fame 2
  27. Combine several data frames in the global environment by row (rbind)
  28. Define dimensions of an empty dataframe
  29. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  30. Data.frame Merge and Selection of values which are common in 2 Data.frames

Leave a Comment