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

[rajat1]

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)

[Debayan]

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

[Anonymous]

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