Why is my Python CSV code reading in each row as a string?

Question

I'm working on a spin-off project from a Code Academy lesson and running into an error when trying to append a specific column from each row of a CSV to a list.

The code from the lesson:

import csv

with open('cool_csv.csv') as cool_csv_file:
  cool_csv_dict = csv.DictReader(cool_csv_file)
  for row in cool_csv_dict:
    print(row['Cool Fact'])

I need to read in each row from my CSV, and append the value of the "subject" column to the entries list.

import csv

entries = []

with open("list.csv") as list_csv:
  list_reader = csv.DictReader(list_csv)
  for row in list_csv:
    entries.append(row["subject"])

But I'm getting the following error:

entries.append(row[“subject”]) TypeError: string indices must be integers

I get that the error is saying that the value passed by row was a string, so I can’t access it with the header name, but what I don’t get is why. My file is a valid CSV as far as I can see, and my code is no different to that in the lesson other than appending instead of printing (I tested print, same error.)

My CSV:

subject,subject_type
first,test
second,test

What have I done wrong that’s making my code read in a string instead of the csv row?

I’m voting to close this as off-topic/typo/can’t be reproduced. It’s essentially a typo, a trivial mixup. — AMC
– AMC, Commented Jan 29, 2020 at 18:30

Alireza Tajadod · Accepted Answer · 2020-01-29 15:49:27Z

1

You need to loop the reader

  for row in list_csv:
      entries.append(row["subject"])

You are looping the list_csv by mistake.

answered Jan 29, 2020 at 15:49

Alireza Tajadod

3271 silver badge8 bronze badges

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

1 Comment

CLockeWork Over a year ago

Doh, so obvious now 😂 Thank you

kederrac · Accepted Answer · 2020-01-29 15:54:38Z

1

as @AlirezaTajadod was saying, you are iterating over a bad object, you have to iterate over list_reader

with open("list.csv") as list_csv:
  list_reader = csv.DictReader(list_csv)
  for row in list_reader:
    entries.append(row["subject"])

answered Jan 29, 2020 at 15:54

kederrac

17.4k6 gold badges36 silver badges58 bronze badges

Comments

A l w a y s S u n n y · Accepted Answer · 2020-01-29 16:01:33Z

1

Need to use list_reader instead of list_csv. See the following example file, marks.csv.

id,subject,marks
1,English,20
2,French,21
3,Spanish,21

So we have,

import csv
list_reader = csv.DictReader(open("marks.csv"))

You may iterate over the rows of the CSV file by iterating over list_reader. So if we do a for loop like below

for row in list_reader:
    print row

It will print row like this,

{'id': '1', 'subject': 'English','marks': '20' }
{'id': '2', 'subject': 'French', 'marks': '21' }
{'id': '3', 'subject': 'Spanish','marks': '22' }

Now to get the subject value simply do print row['subject']

answered Jan 29, 2020 at 16:01

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

Collectives™ on Stack Overflow

Why is my Python CSV code reading in each row as a string?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related