Pyxl was the main culprit slowing down the process alot , replacing it with fastexcel was very effective, ditching pandas was absolutely worth it .