Python Forum
which format to use .csv or .xlsx or .txt - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: General (https://python-forum.io/forum-1.html)
+--- Forum: News and Discussions (https://python-forum.io/forum-31.html)
+--- Thread: which format to use .csv or .xlsx or .txt (/thread-9459.html)



which format to use .csv or .xlsx or .txt - garikhgh0 - Apr-10-2018

Hi. please share your experiance on this question.

I must read the data from the files with pandas, but the data is stored in excel file (.xlsx).

I have an excel file 374 kb (the shapeis (13612,6)) when I am changing the file format into .csv or .txt it becomes 913 kb. So, my question is the following, which format is the best to read from?

Maybe the .csv is bigger, but faster than the .xlsx ?


thanks in advance


RE: which format to use .csv or .xlsx or .txt - garikhgh0 - Apr-10-2018

I tried to read both of them. the csv format was two time faster than the xlsx in spite of it was about 3 smaller than csv.