Sometimes, we want to add Python Pandas data to an existing csv file.
In this article, we’ll look at how to add Python Pandas data to an existing csv file.
How to add Python Pandas data to an existing csv file?
To add Python Pandas data to an existing csv file, we can write the data to a csv with to_csv
.
For instance, we write
df.to_csv('my_csv.csv', mode='a', header=False)
to call to_csv
with the CSV file path.
The mode
is set to 'a'
for append.
And header
is set to false
so the header row won’t be appended.
Conclusion
To add Python Pandas data to an existing csv file, we can write the data to a csv with to_csv
.