Write list of data frames to CSVs in R

Question

I have a named list of data frames and want to write each data frame out to a CSV, using the data frame name as the filename. How can I modify my function to do that? The function below gives me the entire data frame in the file name instead of the name of the data frame.

a <- data.frame('col1' = c(1,2,3))
b <- data.frame('col1' = c(3,4,5))
mylist <- list(a,b)
names(mylist) <- c('a', 'b')
lapply(mylist, function(x) write.csv(x, file = paste0(x, '.csv')))

rpolicastro · Accepted Answer · 2020-05-09 17:08:59Z

4

With base R you can do.

lapply(names(mylist), function(x) {write.csv(mylist[[x]], file = paste0(x, ".csv"))})

Or you can use the shortcut command iwalk from the tidyverse library purrr.

iwalk(mylist, function(x, y) {write.csv(x, file = paste0(y, ".csv"))})

## Or this alternative syntax.

iwalk(mylist, ~write.csv(.x, file = paste0(.y, ".csv")))

answered May 9, 2020 at 17:08

rpolicastro

1,31510 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DeduciveR Over a year ago

great answer - so many red herrings elsewhere using over complex code.

Collectives™ on Stack Overflow

Write list of data frames to CSVs in R

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related