How to read a CSV file from a URL with Python?

Question

when I do curl to a API call link http://example.com/passkey=wedsmdjsjmdd

curl 'http://example.com/passkey=wedsmdjsjmdd' 

I get the employee output data on a csv file format, like:

"Steve","421","0","421","2","","","","","","","","","421","0","421","2" 

how can parse through this using python.

I tried:

import csv  cr = csv.reader(open('http://example.com/passkey=wedsmdjsjmdd',"rb")) for row in cr:     print row 

but it didn't work and I got an error

http://example.com/passkey=wedsmdjsjmdd No such file or directory:

Thanks!

Answer 1

Using pandas it is very simple to read a csv file directly from a url

import pandas as pd data = pd.read_csv('https://example.com/passkey=wedsmdjsjmdd') 

This will read your data in tabular format, which will be very easy to process