python - 如何使用 Python 从 URL 读取 CSV 文件？

Question

当我 curl 到 API 调用链接 http://example.com/passkey=wedsmdjsjmdd

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

我以 csv 文件格式获取员工输出数据，例如:

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

如何使用 python 解析。

我试过了:

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

但它不起作用，我收到了一个错误

http://example.com/passkey=wedsmdjsjmdd 没有这样的文件或目录:

谢谢!

Answer 1

使用 pandas 直接从 url 读取 csv 文件非常简单

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

这将以表格格式读取您的数据，这将非常容易处理