Forums  > Software  > python read xlsx  
     
Page 1 of 1
Display using:  

Omega


Total Posts: 426
Joined: Jul 2006
 
Posted: 2017-08-15 12:33
Hi

Im trying to read a file in python. Have the following

pd.read_excel('H-1B_FY14_Q4.xlsx')

My problem is that it takes forever. How can I speed this up? Tried saving it as a csv file and loading it as read_csv but this brought up errors. Tried saving as xls and reading it as read_excel but still taking forever. Using Anaconda

tbretagn


Total Posts: 251
Joined: Oct 2004
 
Posted: 2017-08-15 13:54
What's the size of the file? read_excel is pretty slow (hence I end up using hdf5 files for quicker load times).
Did you specify the engine? Could help, unless your file is weird and it has to default to the python engine.

Et meme si ce n'est pas vrai, il faut croire en l'histoire ancienne
Previous Thread :: Next Thread 
Page 1 of 1