Python reading CSV file using URL giving error

Question

I am trying to read a CSV file using the requests library but I am having issues.

import requests
import csv

url = 'https://storage.googleapis.com/sentiment-analysis-dataset/training_data.csv'
r = requests.get(url)
text = r.iter_lines()
reader = csv.reader(text, delimiter=',')

I then tried

for row in reader:
  print(row)

but it gave me this error:

Error: iterator should return strings, not bytes (did you open the file in text mode?)

How should I fix this?

Pit · Accepted Answer · 2017-03-16 07:18:05Z

1

What you probably want is:

text = r.iter_lines(decode_unicode=True)

This will return a strings-iterator instead of a bytes-iterator. (See here for documentation.)

answered Mar 16, 2017 at 7:18

Pit

4,1362 gold badges27 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Python reading CSV file using URL giving error

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