Read and rbind multiple csv files

by

Find files (list.files) and read the files in a loop (lapply), then call (do.call) row bind (rbind) to put all files together by rows.

myMergedData <- 
  do.call(rbind,
          lapply(list.files(path = "N:/Ring data by cruise"), read.csv))

Update: There is a vroom package, according to the manuals it is much faster than data.table::fread and base read.csv. The syntax looks neat, too:

library(vroom)
myMergedData <- vroom(files)

More Related Contents:

  1. Simultaneously merge multiple data.frames in a list
  2. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  3. Merging a lot of data.frames [duplicate]
  4. Merge two data frames while keeping the original row order
  5. How do I combine two data-frames based on two columns? [duplicate]
  6. How to convert dataframe into time series?
  7. Subset of rows containing NA (missing) values in a chosen column of a data frame
  8. Merge unequal dataframes and replace missing rows with 0
  9. How to append rows to an R data frame
  10. Select rows from one data.frame that are not present in a second data.frame
  11. Merge data frames based on rownames in R
  12. Merge or combine by rownames
  13. write.csv for large data.table
  14. How to append a whole dataframe to a CSV in R
  15. Identify records in data frame A not contained in data frame B [closed]
  16. How can I merge more than 2 dataframes in R by rownames?
  17. How can I merge many data frames from csv files when the ID column is implied?
  18. Data.frame Merge and Selection of values which are common in 2 Data.frames
  19. Override column types when importing data using readr::read_csv() when there are many columns
  20. Select the row with the maximum value in each group
  21. How to drop columns by name in a data frame
  22. Remove columns from dataframe where ALL values are NA
  23. Detect at least one match between each data frame row and values in vector
  24. Converting nested list to dataframe
  25. Cartesian product data frame
  26. Merge Two Lists in R
  27. Replace values in data frame based on other data frame in R
  28. Add an image to a table-like output in R
  29. Identifying where value changes in R data.frame column
  30. What does the error “arguments imply differing number of rows: x, y” mean?

Leave a Comment