to_csv separator code example

Example 1: python save df to csv

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

Example 2: read_csv separator

import pandas as pd

df = pd.read_csv('data.csv',sep=';')

# also working
df = pd.read_csv('data.csv',delimiter=';')

Example 3: save dataframe as csv

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