Read multiple CSV files into separate data frames

by

Thank you all for replying.

For completeness here is my final answer for loading any number of (tab) delimited files, in this case with 6 columns of data each where column 1 is characters, 2 is factor, and remainder numeric:

##Read files named xyz1111.csv, xyz2222.csv, etc.
filenames <- list.files(path="../Data/original_data",
    pattern="xyz+.*csv")

##Create list of data frame names without the ".csv" part 
names <-substr(filenames,1,7)

###Load all files
for(i in names){
    filepath <- file.path("../Data/original_data/",paste(i,".csv",sep=""))
    assign(i, read.delim(filepath,
    colClasses=c("character","factor",rep("numeric",4)),
    sep = "\t"))
}

More Related Contents:

  1. Grouping functions (tapply, by, aggregate) and the *apply family
  2. How to read data when some numbers contain commas as thousand separator?
  3. Access lapply index names inside FUN
  4. Read all files in directory and apply multiple functions to each data frame [duplicate]
  5. What’s wrong with my function to load multiple .csv files into single dataframe in R using rbind?
  6. How to convert dataframe into time series?
  7. Trimming a huge (3.5 GB) csv file to read into R
  8. Convert comma separated string to numeric columns
  9. Specifying colClasses in the read.csv
  10. How do I import a CSV file in R? [closed]
  11. Merge 2 dataframes if value within range
  12. duplicate ‘row.names’ are not allowed error
  13. Same function over multiple data frames in R
  14. Access and preserve list names in lapply function
  15. RStudio not picking the encoding I’m telling it to use when reading a file
  16. How to add a index by set of data when using rbindlist?
  17. Reading multiple csv files from a folder into a single dataframe in R [duplicate]
  18. Error in file(file, “rt”) : cannot open the connection [duplicate]
  19. How to check if CSV file has a comma or a semicolon as separator?
  20. lapply-ing with the “$” function
  21. How to get a .csv file into R?
  22. Trying to merge multiple csv files in R
  23. Partially read really large csv.gz in R using vroom
  24. Save imported csv data in vector – R
  25. Creating a named list from two vectors (names, values)
  26. R: How to save lists into csv?
  27. consolidating data frames in R
  28. Importing “csv” file with multiple-character separator to R?
  29. How can I merge many data frames from csv files when the ID column is implied?
  30. What does the error “arguments imply differing number of rows: x, y” mean?

Leave a Comment