topic Re: Exporting R data frame variable in Data Engineering

Exporting R data frame variable

Brave — Fri, 13 Jan 2023 20:14:46 GMT

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 — Sat, 14 Jan 2023 09:18:16 GMT

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 — Tue, 17 Jan 2023 12:26:35 GMT

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 — Tue, 17 Jan 2023 18:24:04 GMT

@FELIPE VALENTE

you mean local download ?

Brave — Tue, 17 Jan 2023 19:03:06 GMT

Yes!

sher — Wed, 18 Jan 2023 03:56:03 GMT

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.