dataframe write to csv use open file code example
Example 1: how to save a dataframe into an csv file
df.to_csv('file_name.csv', index=False)
Example 2: write to csv pandas
df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)
Source:datatofish.com