Upload one Excel with Multiple Sheets

wl1
wl1 Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1

Hi,

I am developing a visual application in which the users will upload one excel with multiple sheets (each sheet contains different column headers).

One solution is to let users upload it multiple times, each time they can select a different sheet name. The shortcoming is if the excel file is large, uploading could take long. One sheet is very large, and remaining sheets only have a few rows. Then even uploading the small sheet still takes the same time as uploading the large sheet.

The current solution is to upload the excel file into a Dataiku folder, and then use a python recipe to parse the sheets by their sheet names. But if the excel file is large, using 'pd.read_excel' could still take ~3 min to read inputs.

Is there a faster way to automatically upload one excel and parse the specified sheets into different Dataiku tables? Thank you!

Answers

Setup Info
    Tags
      Help me…