What’s wrong with my function to load multiple .csv files into single dataframe in R using rbind?

by

There’s a lot of unnecessary code in your function. You can simplify it to:

load_data <- function(path) { 
  files <- dir(path, pattern = '\\.csv', full.names = TRUE)
  tables <- lapply(files, read.csv)
  do.call(rbind, tables)
}

pollutantmean <- load_data("specdata")

Be aware that do.call + rbind is relatively slow. You might find dplyr::bind_rows or data.table::rbindlist to be substantially faster.

More Related Contents:

  1. how to use loop to subset 1000 csv files and do co-integration test in R?
  2. Read multiple CSV files into separate data frames
  3. Efficient way to rbind data.frames with different columns
  4. Why is rbindlist “better” than rbind?
  5. How to convert dataframe into time series?
  6. Trimming a huge (3.5 GB) csv file to read into R
  7. Convert comma separated string to numeric columns
  8. Simplest way to get rbind to ignore column names
  9. Converting nested list to dataframe
  10. How do I import a CSV file in R? [closed]
  11. Merge 2 dataframes if value within range
  12. Delete “” from csv values and change column names when writing to a CSV
  13. duplicate ‘row.names’ are not allowed error
  14. Download a file from HTTPS using download.file()
  15. RStudio not picking the encoding I’m telling it to use when reading a file
  16. How can I prevent rbind() from geting really slow as dataframe grows larger?
  17. How to add a index by set of data when using rbindlist?
  18. Error in file(file, “rt”) : cannot open the connection [duplicate]
  19. Difference between rbind() and bind_rows() in R
  20. How to read csv file in R where some values contain the percent symbol (%)
  21. write.csv for large data.table
  22. Using R to download zipped data file, extract, and import .csv
  23. Partially read really large csv.gz in R using vroom
  24. Save imported csv data in vector – R
  25. Calculate the mean of one column from several CSV files
  26. Correct number of decimal places reading in a .csv
  27. Reading a CSV file organized horizontally
  28. Importing “csv” file with multiple-character separator to R?
  29. How to read specific rows of CSV file with fread function
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment