In the image above, you can find the run-time comparison of storing a Pandas DataFrame in various file formats. Although CSVs are a widely adopted format, it is the slowest format in this list. Thus, CSVs should be avoided unless you want to open the data outside Python (in Excel, for instance).
The Best File Format To Store A Pandas DataFrame
The Best File Format To Store A Pandas…
The Best File Format To Store A Pandas DataFrame
In the image above, you can find the run-time comparison of storing a Pandas DataFrame in various file formats. Although CSVs are a widely adopted format, it is the slowest format in this list. Thus, CSVs should be avoided unless you want to open the data outside Python (in Excel, for instance).