Exporting R data frame variable

[Brave]

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?

[sher · Accepted solution]

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

[Brave]

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.

[sher]

@FELIPE VALENTE​ 

you mean local download ?

[Brave]

Yes!

[sher]

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.

[Kaniz]

Hi @FELIPE VALENTE​  (Customer)​, We haven’t heard from you since the last response from @sherbin w​  (Customer)​ , and I was checking back to see if his suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.