Writing a Python list into a single CSV column

With Python3, open the file in w mode:

with open('returns.csv', 'w') as f:    writer = csv.writer(f)    for val in daily_returns:        writer.writerow([val])

With Python2.6+, open the file in wb mode:

with open('returns.csv', 'wb') as f:    writer = csv.writer(f)    for val in daily_returns:        writer.writerow([val])

python csv writer

Alternate solution: Assuming daily_returns is the name of the list you wish to write as a column in a CSV file, the following code should work:

with open('return.csv','w') as f:    writer = csv.writer(f)    writer.writerows(zip(daily_returns))

python csv writer

Just for the record:

I'm using Python 3.2 and I could only get the following to work

with open('returns','w')as f:    writer=csv.writer(f,lineterminator='\n')    for val in returns:        writer.writerow([val])

CodeHunter