which is better to read excel files ? pandas or xlrd

liquiddeath

I'm new to this platform, so not sure if the forum selected is correct or not. I'm creating a webapp, where most of the backend operations include reading excel files. I'm aware that internally pandas use xlrd.

1. So if i use xlrd to read an excel file instead of pandas, will the operation be faster?

2. Using pandas just for reading an excel with not much work to process using pandas, which is recommended? pandas or xlrd ?

Alex Putkov.1

@liquiddeath

This portal is aimed at software developers utilizing Refinitiv APIs. I'm afraid your question is off-topic here, as it pertains to generic software development in Python, not specific to any Refinitiv products, services or APIs. I suggest you post your question on resources that are better suited for generic programming problems like Stackoverflow etc.

zoya faberov

Hello @liquiddeath,

Let us confirm if you are in a correct Refinitiv API developers forum.

Which Refinitiv API are you using, is it Data Fusion? (this question was posted in Data Fusion section)

liquiddeath

https://community.developers.refinitiv.com/discussion/comment/73282#Comment_73282

Hi, No im not using any of the Refinitive API. when i searched pandas forum, this is the site shown up first. so expected to get an answer from here

liquiddeath

https://community.developers.refinitiv.com/discussion/comment/73283#Comment_73283

Sure. it was of no use creating account here then .