I have a dataframe call "Data" below, I want to split it by the first column and create separate CSV files with it.
For some reason when I got to the pwalk function, to do the export CSV by each file, it gives me an error.
The error says it's not a dataframe, but even when I convert it to a dataframe still throws an error.
any help would be great!
Data = data.frame(
stringsAsFactors = FALSE,
A = c(1L, 2L, 3L, 4L),
B = c("a", "b", "c", "d")
)
Files = split(Data, Data$A)
pwalk(Files, ~write_csv(Files, path = paste0(Files, ".csv"))) ```
You can't use Files
inside write.csv
. And you should use iwalk
not pwalk
in this case.
Try this code.
Files |>
iwalk(~write_csv(.x, file = paste0(.y, ".csv")))
iwalk
basically converts the names of the elements as .y
.
Hope this helps.
Best
1 Like
system
Closed
3
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.