Is there a preferred format for Python to retrieve time-series data - between .txt or xlsx?

Question

I am using a third party tool to extract vast amounts of time-series data (to be analysed within python). The options are to save this as a text file or excel file. Which is the more efficient route speed-wise?

Save files in .csv format – tawab_shakeel Jun 21 '19 at 09:45 — tawab_shakeel, Jun 21 '19 at 09:45

score 0 · Accepted Answer · answered Jun 21 '19 at 09:46

0

You can have a look here: Faster way to read Excel files to pandas dataframe

Here it is also mentioned that csv is fater, so the text file should be the better option.

answered Jun 21 '19 at 09:46

PV8

5,799
7
43
87

Is there a preferred format for Python to retrieve time-series data - between .txt or xlsx?

1 Answers1