Sometimes, we want to write to a CSV line by line with Python.

In this article, we’ll look at how to write to a CSV line by line with Python.

How to write to a CSV line by line with Python?

To write to a CSV line by line with Python, we can use the CSV writer.

For instance, we write

import csv

with open(<path to output_csv>, "wb") as csv_file:
        writer = csv.writer(csv_file, delimiter=',')
        for line in data:
            writer.writerow(line)

to call open to open the csv file with write permission and as a binary file.

Then we call csv.writer with the opened csv_file to create a writer object.

We set the delimiter to the delimiter of the row items.

And then we add a for loop that calls writerow to write the line to the csv.

Conclusion

To write to a CSV line by line with Python, we can use the CSV writer.