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.

[Kaniz]

Hi @Rajat Saroj​  , We haven't heard from you since the last response from @Debayan Mukherjee​​, 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.

[Anonymous]

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