How to convert dataframe (df), to a excel file that I can share with my colleagues ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2022 09:46 PM
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)
- Labels:
-
Dataframe
-
Microsoft azure
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2022 08:08 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2022 02:15 AM
You could try this way, convert Pyspark Dataframe to Pandas Dataframe then export to excel file.
