https://kedro.org/ logo
#questions
Title
# questions
s

Sarthak Bhatt

11/29/2023, 4:19 PM
Hi team, I am working to create a node in Kedro that saves all the excel files within each subfolders in a single excel file with different tabs. The tab names should be the subfolder_filename. The number of subfolders can be variable. Wanted to check if someone did implement this before?
d

datajoely

11/29/2023, 4:23 PM
so if you return a
Dict[str, pd.DataFrame]
an
pandas.ExcelDataSet
will be written where each tab is the sheet name you provide it
now the subfolder element is a bit more complicated since kedro nodes don’t have any knowledge of the IO, just the data going in and out
so if you really want that I think you need to subclass
pandas.ExcelDataSet
and add your own custom
save()
method
4 Views