Relative Content

Tag Archive for pythonexcelpandas

Organising excel file as pandas dataframe

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)