python pandas save dataframe code example

Example 1: pandas save file to pickle

import pandas as pd
df.to_pickle(file_name) # save
df = pd.read_pickle(file_name) # load

Example 2: python save df to csv

df.to_csv(r'/directory/path/file_name.csv', index = False, header = True)

Example 3: save dataframe to csv

df.to_csv(file_name, sep='\t')

Example 4: save dataframe as csv

df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)