0 votes
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?
by

2 Answers

0 votes

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

by
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?
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 votes

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()

 

 

by
1,299 questions
1,327 answers
1,507 comments
11,865 users

┬ęDataiku 2012-2018 - Privacy Policy