topic How to convert dataframe (df), to a excel file that I can share with my colleagues ? in Data Engineering

How to convert dataframe (df), to a excel file that I can share with my colleagues ?

rajat1 — Wed, 28 Sep 2022 04:46:37 GMT

I am working on microsoft azure databrick, I have a final dataframe of shape (3276*23) , I want to share it in form of excel file? How can I do it ( I am using

->df.to_excel('fileOutput.xlsx', sheet_name = 'Sheet1', index = False) , command is running showing no error but I dont know file saving location)

Re: How to convert dataframe (df), to a excel file that I can share with my colleagues ?

Anonymous — Sat, 19 Nov 2022 10:15:43 GMT

You could try this way, convert Pyspark Dataframe to Pandas Dataframe then export to excel file.

Re: How to convert dataframe (df), to a excel file that I can share with my colleagues ?

Debayan — Wed, 28 Sep 2022 15:08:14 GMT

Hi, You can refer: https://towardsdatascience.com/databricks-how-to-save-files-in-csv-on-your-local-computer-3d0c70e6a9ab also https://docs.databricks.com/data/data-sources/read-csv.html to get a better understanding.