Kedro is an open-sourced Python framework for creating maintainable and modular data science code.

Kedro

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?

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