Do You Read Excel Files with Python? There is a 1000x Faster Way by Nicolas Vandeput via @TDataScience

In this article, Nicholas shows you five ways to load data in Python. Achieving a speedup of 3 orders of magnitude. 

This is really useful as I knew there had to be a way to do it faster but this clearly gave me to the right ways to do it faster,