Creating an R dataframe row-by-row

by

You can grow them row by row by appending or using rbind().

That does not mean you should. Dynamically growing structures is one of the least efficient ways to code in R.

If you can, allocate your entire data.frame up front:

N <- 1e4  # total number of rows to preallocate--possibly an overestimate

DF <- data.frame(num=rep(NA, N), txt=rep("", N),  # as many cols as you need
                 stringsAsFactors=FALSE)          # you don't know levels yet

and then during your operations insert row at a time

DF[i, ] <- list(1.4, "foo")

That should work for arbitrary data.frame and be much more efficient. If you overshot N you can always shrink empty rows out at the end.

More Related Contents:

  1. data.frame rows to a list
  2. Recombining a list of Data.frames into a single data frame [duplicate]
  3. What is the most efficient way to cast a list as a data frame?
  4. rbind dataframes in a list of lists
  5. How do I make a list of data frames?
  6. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  7. Simultaneously merge multiple data.frames in a list
  8. Combine a list of data frames into one data frame by row
  9. Convert a list to a data frame
  10. Unlist data frame column preserving information from other column
  11. Create a data.frame where a column is a list
  12. Combining (cbind) vectors of different length
  13. How to convert a matrix to a list of column-vectors in R?
  14. How to flatten a list to a list without coercion?
  15. Convert a matrix to a list of column-vectors
  16. Merge Two Lists in R
  17. Delete a column in a data frame within a list
  18. Converting a list of data frames into individual data frames in R [duplicate]
  19. Python: create a pandas data frame from a list
  20. What is difference between dataframe and list in R?
  21. R: Print list to a text file
  22. Convert list to data frame while keeping list-element names
  23. Find empty or NaN entry in Pandas Dataframe
  24. Prevent unlist to drop NULL values
  25. How to add variable key/value pair to list object?
  26. What are the differences between vector and list data types in R?
  27. Create an empty data.frame
  28. Segregating Lists in Prolog
  29. Last Observation Carried Forward In a data frame? [duplicate]
  30. Erlang lists with single numbers over 8?

Leave a Comment