Python Forum
which format to use .csv or .xlsx or .txt
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
which format to use .csv or .xlsx or .txt
#1
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
Reply
#2
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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy xlsx cell format into data frame or table Johnse 4 648 Aug-30-2019, 04:27 PM
Last Post: Johnse

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020