How to read large xlsx file to fast in python?

Question

Is there any option to read and get DataFrame in fast with large excel files in python?

If it is a single sheet, save it as .csv and use pd.read_csv(). If it is multi sheet try https://stackoverflow.com/questions/28766133/faster-way-to-read-excel-files-to-pandas-dataframe — Ehsan, Apr 16 '20 at 07:03

score 0 · Answer 1 · answered Apr 16 '20 at 13:23

0

Pandas provides a function to read excel files:

I think you need to install xlrd separately for this

pip install xlrd

Please mention in your question if you already know about this and looking for an alternate solution.

answered Apr 16 '20 at 13:23

Pushkar Nimkar

I kow this ,but what I am asking, how to large xlsx file to get dataframe in fast? – Jebaraj P May 25 '20 at 03:07

1 Answers1