Exporting Data to Feather, SQL, and JSON

Feather

Here’s an option that is a relative newcomer. Feather is a binary file format for persisting columnar data that is found in DataFrames. This is not a surprise because the creator of pandas works on it. Feather tends to be fast, and it keeps type information (for the most part). It’s also supposed to be supported by other languages in case we need to deal with processing data in R, Julia, or others.

Note: We’ll need to install the Feather format library to leverage this functionality.

Let’s try exporting our data:

Note: The above code will give ValueError because Feather does not support serializing a nondefault index for the ...