Skip to content
Advertisement

Tag: import-from-excel

Faster way to read Excel files to pandas dataframe

I have a 14MB Excel file with five worksheets that I’m reading into a Pandas dataframe, and although the code below works, it takes 9 minutes! Does anyone have suggestions for speeding it up? Answer As others have suggested, csv reading is faster. So if you are on windows and have Excel, you could call a vbscript to convert the

Advertisement