How to fix "Error: iterable expected, not int" when writing to a CSV file?

Question

Why is my CSV write function not working? This seems to be a very simple code but the CSV writerow is asking for an iterable. I just need to write the 1,2,3 in a column.

import csv

data = [1,2,3]

output = 'output.csv'

with open(output,'w') as f:
    writer = csv.writer(f)
    for item in data:
        writer.writerow(item)

Have you seen this question? I think that writerow expects a list. stackoverflow.com/a/39282731/92953 — Joshua Lowry
– Joshua Lowry, Commented Jul 1, 2020 at 2:41
A row must be an iterable of strings or numbers for Writer objects and a dictionary mapping fieldnames to strings or numbers (by passing them through str() first) for DictWriter objects. docs.python.org/3/library/csv.html — Joshua Lowry
– Joshua Lowry, Commented Jul 1, 2020 at 2:42
Not to be overly picky, but if there is literally only one value on each line, why is CSV getting involved? For consistent newline format? Because you didn't pass newline='' to open, so you won't be getting that anyway. — ShadowRanger
– ShadowRanger, Commented Jul 1, 2020 at 3:03
What can I use if not CSV? Are you implying I use txt instead? — rmore911
– rmore911, Commented Jul 1, 2020 at 3:56

Joshua Lowry · Accepted Answer · 2020-07-01 02:47:33Z

2

You are passing an integer but a list is expected.

import csv

data = [[1],[2],[3]]

output = 'output.csv'

with open(output,'w') as f:
    writer = csv.writer(f)
    for item in data:
        writer.writerow(item)

answered Jul 1, 2020 at 2:47

Joshua Lowry

1,1053 gold badges12 silver badges31 bronze badges

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

Comments

Gino Mempin · Accepted Answer · 2022-05-24 10:14:32Z

2

We need to provide a list to the CSV writer writerow function, in which there are values for 1 complete row.

e.g

import csv

data = [1,2,3]

output = 'output.csv'

with open(output,'w') as f:
    writer = csv.writer(f)
    writer.writerow(data) # as data includes only 1 row. For multiple rows write every row with a loop

edited May 24, 2022 at 10:14

Gino Mempin

30.5k31 gold badges125 silver badges174 bronze badges

answered Jul 1, 2020 at 3:00

Sohaib Anwaar

1,5572 gold badges15 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to fix "Error: iterable expected, not int" when writing to a CSV file?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related