pandas to_pickle – Write DataFrame to Pickle File

To write a DataFrame to a pickle file, the simplest way is to use the pandas to_pickle() function.

df.to_pickle("./filename.pkl")

When working with data as a data science or data analyst, many times we want to read data and write data to different file types.

One common file type which analysts use is a pickle file. Pickle (.pkl) files are byte streams, and the pandas module is easily able to read and write pickle files.

In pandas, we can write pickle files with the pandas to_pickle() method.

df.to_pickle("./filename.pkl")

If you need to compress the pickle file in any way, you can pass the compression parameter with the appropriate string. The options for the compression parameter are “infer”, “gzip”, “bz2”, “zip”, “xz”, and None.

df.to_pickle("./filename.pkl", compression="gzip")

If you need to read a pickle file using pandas, you can use the pandas read_pickle() method.

Hopefully this article has been useful for you to understand how to use pandas to write a DataFrame to a pickle file with the pandas to_pickle function.