Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I write multiple CSV files from a list of data frames?

Tags:

r

csv

I have a list with two data frames. I want to loop thru the list and write a CSV for each data frame and name it after the data frame name.

library(ggplot2)
myList <- list(diamonds, cars)
for(i in mylist){
  write.csv(df, paste0(names(myList[i]),".csv"))
}

But this only outputs one CSV file names .csv with data from cars.

How do I fix this so I have two CSVs named diamonds.csv and cars.csv with the correct data in each?

like image 722
Username Avatar asked Sep 06 '16 19:09

Username


2 Answers

A few of things.

  1. myList doesn't have any names, so you aren't actually naming your files.
  2. Once you give myList names, you would do better to index along the names than along the list
  3. You use df in your for loop, but that isn't defined anywhere.

This should work (untested)

myList <- list(diamonds = diamonds, 
               cars = cars)
for(i in names(mylist)){
  write.csv(myList[[i]], paste0(i,".csv"))
}
like image 53
Benjamin Avatar answered Oct 22 '22 14:10

Benjamin


You can also use mapply:

myList <- list(diamonds = diamonds, 
               cars = cars)
mapply(write.csv, myList, file=paste0(names(myList), '.csv'))
like image 27
Neal Fultz Avatar answered Oct 22 '22 12:10

Neal Fultz