I want to know if it is possible to use the pandas to_csv()
function to add a dataframe to an existing csv file. The csv file has the same structure as the loaded data.
Python – How to Add Pandas Data to an Existing CSV File
csvdataframepandaspython
Best Answer
You can specify a python write mode in the pandas
to_csv
function. For append it is 'a'.In your case:
The default mode is 'w'.
If the file initially might be missing, you can make sure the header is printed at the first write using this variation: