Sometimes, we want to write a pandas DataFrame to CSV file with Python.
In this article, we’ll look at how to write a pandas DataFrame to CSV file with Python.
How to write a pandas DataFrame to CSV file with Python?
To write a pandas DataFrame to CSV file with Python, w ecan use the to_csv
method.
For instance, we write
df.to_csv(file_name, sep='\t', encoding='utf-8')
to call to_csv
to write the df
data frame’s data to the file at path file_name
.
We also set the sep
argument to set the item separator.
And we set the encoding
argument to set the encoding for the file.
Conclusion
To write a pandas DataFrame to CSV file with Python, w ecan use the to_csv
method.