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


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

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


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


Total Posts: 268
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