exporting csv file in python keep index and columns names code example
Example 1: save pandas into csv
df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)
Example 2: how to write csv from a dataframe pythin
df.to_csv('file_name.csv')