Format of excel file exported from a web app is no in useful. Need to perform a variety of operations on it to make it suitable as a dataframe. From bubble.io, excel file would be uploaded by user, manipulated in an amazon s3 bucket using lambda function that removes couple of blank rows at the top (but that I need some cell values from), add columns and moves some columns to become further rows further down the table, before it is pulled back down as a csv file by bubble to add as a new data type (confusing terminology for a table bubble.io uses)

Ultimately, I need to use pandas to convert this excel file…

before

…to this (but as a dataframe I can export as an excel file or csv)

after