How to save a Pandas Dataframe to a pickle file

Question

Hi Guys,

I am new to the Pandas module. I want to save the Dataframe in a pickle file. How can I do that?

Answer 1

Hi@akhtar,

Python pickle module is used for serializing and de-serializing a Python object structure. Any object in Python can be pickled so that it can be saved on disk. You can use the below commands to save the Dataframe in a pickle file.

import pandas as pd
df = pd.DataFrame({"foo": range(5), "bar": range(5, 10)})
pd.to_pickle(df, "./dummy.pkl")