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 find the Jupyter Notebook from the tutorial here [Google Drive]:
👉 http://bit.ly/2M7iGzX

Subscribe: https://www.youtube.com/channel/UCZjRcM1ukeciMZ7_fvzsezQ

#excel #pandas #python