Append data frames together in a for loop

by

Don’t do it inside the loop. Make a list, then combine them outside the loop.

datalist = list()

for (i in 1:5) {
    # ... make some data
    dat <- data.frame(x = rnorm(10), y = runif(10))
    dat$i <- i  # maybe you want to keep track of which iteration produced it?
    datalist[[i]] <- dat # add it to your list
}

big_data = do.call(rbind, datalist)
# or big_data <- dplyr::bind_rows(datalist)
# or big_data <- data.table::rbindlist(datalist)

This is a much more R-like way to do things. It can also be substantially faster, especially if you use dplyr::bind_rows or data.table::rbindlist for the final combining of data frames.

More Related Contents:

  1. Finding unique values in a dataset for market basket analysis in csv file
  2. Replace values greater than zero with 1 in r
  3. Extract row corresponding to minimum value of a variable by group
  4. Why do R objects not print in a function or a “for” loop?
  5. Workflow for statistical analysis and report writing
  6. Proxy setting for R
  7. Pass column name in data.table using variable [duplicate]
  8. Grouped bar plot in ggplot
  9. Merge several data.frames into one data.frame with a loop
  10. How to parse milliseconds?
  11. Create discrete color bar with varying interval widths and no spacing between legend levels
  12. Sum values in a rolling/sliding window
  13. Detect at least one match between each data frame row and values in vector
  14. Extract Month and Year From Date in R
  15. How to spread columns with duplicate identifiers?
  16. R error “sum not meaningful for factors”
  17. How to Parse Year + Week Number in R?
  18. Adding labels to ggplot bar chart
  19. How to edit and debug R library sources
  20. Return data subset time frames within another timeframes?
  21. Remove extra space and ring at the edge of a polar plot
  22. Is there a faster lm function
  23. Access odd-named object returned by getSymbols
  24. R – emulate the default behavior of hist() with ggplot2 for bin width
  25. How to jitter both geom_line and geom_point by the same magnitude?
  26. How to show only part of the plot area of polar ggplot with facet?
  27. Plot two graphs in a same plot
  28. ggplot multiple grouping bar
  29. Create a time interval of 15 minutes from minutely data in R?
  30. Fill option for fread

Leave a Comment