How to Write CSV Data Line by Line in Python?

Writing to a CSV File Line by Line

To save data received in CSV format from an HTTP response to a CSV file, a common approach is to use Python's StringIO module to iterate over the data line by line. However, to properly write each line to a CSV file, additional steps are necessary.

One method involves using the open() function to create a file handle for the CSV file, followed by a loop to iterate over each line in the StringIO object. Within the loop, use the write() method of the file handle to append the line to the CSV file. For example:

<code class="python">import StringIO
s = StringIO.StringIO(text)
with open('fileName.csv', 'w') as f:
    for line in s:
        f.write(line)</code>

Another approach leverages the csv module. The writer function can be used to create a CSV writer object, which provides a convenient interface for writing rows and columns to a CSV file:

<code class="python">import csv
with open('csvfile.csv', 'wb') as csv_file:
    writer = csv.writer(csv_file, delimiter=',')
    for line in data:
        writer.writerow(line)</code>

A simpler method for writing to a CSV file is to directly open the CSV file for writing and use the write() method to write the line to the file. Python automatically handles line breaks based on the operating system's conventions:

<code class="python">f = open('csvfile.csv', 'w')
f.write('hi there') #Write a line to the CSV file.
f.close()</code>

The above is the detailed content of How to Write CSV Data Line by Line in Python?. For more information, please follow other related articles on the PHP Chinese website!