Reading Excel files with openpyxl
Tutorial about reading unusual Excel files into pandas dataframes
Not every Excel file you encounter will lend itself to being easily read using the pandas libary. In the following tutorial hosted on Kaggle, I walkthough how to read data into a pandas dataframe where the data hierarchy is represented using indentation in the Excel document. This requires processing the Excel file row by row to determine which level each data row represents.