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.