python save df to csv

df.to_csv('out.csv')

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

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

df.to_csv('file_name.csv', index=False)

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

>>> df = pd.DataFrame({'name': ['Raphael', 'Donatello'],
...                    'mask': ['red', 'purple'],
...                    'weapon': ['sai', 'bo staff']})
>>> df.to_csv(index=False)
'name,mask,weapon\nRaphael,red,sai\nDonatello,purple,bo staff\n'

import numpy as np
np.savetxt('data.csv', (col1_array, col2_array, col3_array), delimiter=',')

import csv

with open("infile.dat") as infile, open("outfile.csv", "w") as outfile:
    csv_writer = csv.writer(outfile)
    prev = ''
    csv_writer.writerow(['ID', 'PARENT_ID'])
    for line in infile.read().splitlines():
        csv_writer.writerow([line, prev])
        prev = line

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