- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-13-2023 12:14 PM
Hi all.
I am trying to export R data frame variable as csv file.
I am using this formula:
df<- data.frame(VALIDADOR_FIM)
df.coalesce(1).write.format("com.databricks.spark.csv").option("header", "true").save("dbfs:/FileStore/df/df.csv")
But isnยดt working. How can this as export a csv file?
- Labels:
-
CSV Export
-
R
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-14-2023 01:18 AM
Please try to execute write.csv with the following path instead:
write.csv(TotalData,file='/dbfs/tmp/df.csv',row.names = FALSE)
%fs ls /tmp
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-14-2023 01:18 AM
Please try to execute write.csv with the following path instead:
write.csv(TotalData,file='/dbfs/tmp/df.csv',row.names = FALSE)
%fs ls /tmp
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-17-2023 04:26 AM
Hi @sherbin wโ tanks for Help! Now how i can acess this .csv to download?
I tryed:
%fs ls /tmp
and
read.df(path = "/tmp/VALIDADOR_FIM.csv")
but both didnยดt worked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-17-2023 10:24 AM
@FELIPE VALENTEโ
you mean local download ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-17-2023 11:03 AM
Yes!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-17-2023 07:56 PM
I don't think that will be possible in databricks. may be i wrong.
But what I did was mount s3 put that CSV file there and download it.