create csv from dataframe without index code example
Example 1: to_csv drop index
df.to_csv('file.csv', index=False)
Example 2: saving a pandas dataframe as a csv
df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)