Read Messy & Poorly Structured Excel Files Using Pandas (Python)
In the real world, Excel files are not always so neat & clean as the ones you will find in many tutorials.
I will walk you through how to read messy and poorly structured Excel Files using pandas.
In particular, I will cover the following options in the
pandas read_excel() function:
pandas.read_excel( io, sheet_name=0, header=0, usecols=None, true_values=None, skipfooter=0 converters=None, dtype=None, )
You can download the Jupyter Notebook from the tutorial here:Download Here