question

Upvotes
Accepted
liquiddeath avatar image
3 ●0 ●1 ●1

which is better to read excel files ? pandas or xlrd

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 ?

data-fusion
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

zoya faberov avatar image zoya faberov

Hello @placementseaso,

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 avatar image liquiddeath zoya faberov

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

1 Answer

Upvotes
Accepted
Alex Putkov.1 avatar image
39.3k ●77 ●11 ●27

@placementseaso

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

liquiddeath avatar image liquiddeath

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