Python: How to save for loop string values into csv file?

Question

I would like to save my strings into a csv file. Given the code below, there is a closed file issue, how can I save the list of strings into csv file? I don't understand why is this not working.

Code

import csv
with open('onehot.csv','wb') as testfile:
    csv_writer=csv.writer(testfile)

collection = ['hey', '5', 'd']
for x in collection:
    csv_writer.writerow(x)

Martijn Pieters · Accepted Answer · 2016-02-21 11:19:53Z

1

Indent your code block to be within the with statement scope, and wrap each string in a list to make it an actual row:

import csv
with open('onehot.csv','wb') as testfile:
    csv_writer=csv.writer(testfile)

    collection = ['hey', '5', 'd']
    for x in collection:
        csv_writer.writerow([x])

File objects are context managers, and the with statement informs them when the context is exited (the block under the with statement has ended or an exception was raised). File objects respond by closing the file, so you can't write to it anymore outside of a with block.

answered Feb 21, 2016 at 11:19

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python: How to save for loop string values into csv file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related