Reading Poorly Structured Excel Files with Pandas - Practical Business Python

In this case, we can use openpyxl directly to parse the file and convert the data into a pandas DataFrame. The fact that the data is in an Excel table can make this process a little easier.
https://pbpython.com/pandas-excel-range.html