Writing output in first column of csv

Question

I have sequence of numbers:

6577

I would like to see them in the .csv file like this:

6  
5  
7

I've tried with file writer but it writes all numbers in first row.

sequence is string..

s = ['6','5','7','7','6']
item_length = len(s)

with open('test.csv', 'wb') as test_file:
    file_writer = csv.writer(test_file)
    for i in range(item_length):
        file_writer.writerow([x[i] for x in s])

Please post you code along with question, you will get much more useful feedback that way. Right now python -c "for d in '6577':print d" > file solves you problem. — Chris Seymour
– Chris Seymour, Commented Dec 20, 2012 at 11:36
s = '657' is not the same as 6577. Which is it? And if there's only one column, why do you need csv? — Shawn Chin
– Shawn Chin, Commented Dec 20, 2012 at 11:41
Your initial sequence and the expected .csv output and the sequence in the code example are still all different. Is the code meant to remove duplicates? — Shawn Chin
– Shawn Chin, Commented Dec 20, 2012 at 11:46

Shawn Chin · Accepted Answer · 2012-12-20 11:48:59Z

2

If you wish to write each list item as a row, you can try:

s = ['6','5','7','7','6']
item_length = len(s)

with open('test.csv', 'wb') as test_file:
    file_writer = csv.writer(test_file)
    for item in s:
        file_writer.writerow(item)

Also, with only a single column to write out, this might suffice:

s = ['6','5','7','7','6']
with open('test.csv', 'wb') as test_file:
   test_file.write("\n".join(s) + "\n")

answered Dec 20, 2012 at 11:48

Shawn Chin

87.4k20 gold badges168 silver badges193 bronze badges

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

2 Comments

ttwis Over a year ago

I tried that...But i guess output cannot be writen in columns in .csv

Shawn Chin Over a year ago

Glad you found a solution.

Collectives™ on Stack Overflow

Writing output in first column of csv

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related