Reading a remove csv file

[Peter Otten]

ROGER GRAYDON CHRISTMAN wrote:

>  Just a quick question on how best to read a remote CSV file.
> So far, I tried:
> 
> filelink = urllib.request.urlopen(path)
> dictread = csv.DictReader(filelink)
> for row in dictread:    ...
> But I'm running into the difference between strings and bytes.
> I'd like to squeeze a note that talks about the utf-8 encoding,
> but although I find that as an option for a local file (with open())
> I did not see that on my first glance at the two functions above.
> 
> Is there an easy way to read a remove CSV file with utf-8 encoding
> without copying the whole file locally first?

Try wrapping the resqponse, it should be sufficiently file-like:

response = urllib.request.urlopen(...)
stream = io.TextIOWrapper(response, newline="", encoding="utf-8")
rows = csv.DictReader(stream)