Repeat rows of a data.frame N times

by

EDIT: updated to a better modern R answer.

You can use replicate(), then rbind the result back together. The rownames are automatically altered to run from 1:nrows. 

d <- data.frame(a = c(1,2,3),b = c(1,2,3))
n <- 3
do.call("rbind", replicate(n, d, simplify = FALSE))

A more traditional way is to use indexing, but here the rowname altering is not quite so neat (but more informative): 

 d[rep(seq_len(nrow(d)), n), ]

Here are improvements on the above, the first two using purrr functional programming, idiomatic purrr: 

purrr::map_dfr(seq_len(3), ~d)

and less idiomatic purrr (identical result, though more awkward): 

purrr::map_dfr(seq_len(3), function(x) d)

and finally via indexing rather than list apply using dplyr:

d %>% slice(rep(row_number(), 3))

More Related Contents:

  1. Dynamically select data frame columns using $ and a character value
  2. Simultaneously merge multiple data.frames in a list
  3. Merging a lot of data.frames [duplicate]
  4. Create a group number for each consecutive sequence
  5. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  6. Remove columns with zero values from a dataframe
  7. Calculating statistics on subsets of data [duplicate]
  8. How to convert dataframe into time series?
  9. Identifying duplicate columns in a dataframe
  10. For each row in an R dataframe
  11. Replace all occurrences of a string in a data frame
  12. Convert Named Character Vector to data.frame
  13. How to add a cumulative column to an R dataframe using dplyr?
  14. Get last row of each group in R [duplicate]
  15. Create empty data frame with column names by assigning a string vector? [duplicate]
  16. Add extra level to factors in dataframe
  17. Determine the data types of a data frame’s columns
  18. finding close match from data frame 1 in data fame 2
  19. Combine several data frames in the global environment by row (rbind)
  20. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  21. Extract text after “/” in a data frame column
  22. What is difference between dataframe and list in R?
  23. Define dimensions of an empty dataframe
  24. use multiple columns as variables with sapply
  25. Merge overlapping ranges into unique groups, in dataframe
  26. Deleting specific rows from a data frame
  27. Count number of non-NA values for every column in a dataframe [duplicate]
  28. Convert a data frame to a data.table without copy
  29. How can I merge more than 2 dataframes in R by rownames?
  30. What is the first column in R’s mtcars dataset?

Leave a Comment