Community Conundrum 28: News Engagement is live! Read More

Export multiple datasets into one single excel file with multiple sheets

Level 1
Export multiple datasets into one single excel file with multiple sheets
Hi All,

I am trying to export different processed datasets ( for example dataset1 and dataset2) into one single excel file with multiple work sheets ( sheet 1 containing dataset1 and sheet 2 containing dataset2). Is this possible?
0 Kudos
4 Replies
Dataiker
Dataiker

Hi,



This is quite easy to do with a bit of Python code: see example on http://xlsxwriter.readthedocs.io/example_pandas_multiple.html.



The equivalent also exists in R code: 



https://statmethods.wordpress.com/2014/06/19/quickly-export-multiple-r-objects-to-an-excel-workbook/



Cheers,



Alex

0 Kudos
Level 1
Author
Hi Alex,

Thanks for your answer. However, I cannot import the module 'xlsxwriter' on python environment on Dataiku.

Moreover, I have the issue of saving the merged excel file in an existing folder on dataiku. Would you be so kind to share an example?
0 Kudos
Dataiker
Dataiker
Here is how to install a package on the Dataiku python environment: https://www.dataiku.com/learn/guide/code/python/install-python-packages.html

Reading and writing from/to "managed_folders" is documented here: https://doc.dataiku.com/dss/latest/connecting/managed_folders.html#usage-in-python
0 Kudos
Dataiker
Dataiker

Hi Francesco,



You can write to a folder with a python script. The file below shows how to write in the test_writeExcel.



test_writeExcel = dataiku.Folder("RaZzKNKs")

test_writeExcel_info = test_writeExcel.get_info()



name = 'test.xlsx'



df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})



path = os.path.join(test_writeExcel_info['path'], name)



writer = pd.ExcelWriter(path)



df.to_excel(writer, sheet_name='Sheet1', encoding='utf-8')



writer.save()



 



 

0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS