使用python请求下载CSV

这应该有助于：

import csvimport requestsCSV_URL = 'http://samplecsvs.s3.amazonaws.com/Sacramentorealestatetransactions.csv'with requests.Session() as s:    download = s.get(CSV_URL)    depred_content = download.content.depre('utf-8')    cr = csv.reader(depred_content.splitlines(), delimiter=',')    my_list = list(cr)    for row in my_list:        print(row)

输出样本：

['street', 'city', 'zip', 'state', 'beds', 'baths', 'sq__ft', 'type', 'sale_date', 'price', 'latitude', 'longitude']['3526 HIGH ST', 'SACRAMENTO', '95838', 'CA', '2', '1', '836', 'Residential', 'Wed May 21 00:00:00 EDT 2008', '59222', '38.631913', '-121.434879']['51 OMAHA CT', 'SACRAMENTO', '95823', 'CA', '3', '1', '1167', 'Residential', 'Wed May 21 00:00:00 EDT 2008', '68212', '38.478902', '-121.431028']['2796 BRANCH ST', 'SACRAMENTO', '95815', 'CA', '2', '1', '796', 'Residential', 'Wed May 21 00:00:00 EDT 2008', '68880', '38.618305', '-121.443839']['2805 JANETTE WAY', 'SACRAMENTO', '95815', 'CA', '2', '1', '852', 'Residential', 'Wed May 21 00:00:00 EDT 2008', '69307', '38.616835', '-121.439146'][...]

答案相关的问题:

使用此功能将csv加载到列表中

import csvcsvfile = open(myfile, 'r')reader = csv.reader(csvfile, delimiter='t')my_list = list(reader)print my_list>>>[['1st_line', '0'],    ['2nd_line', '0']]

编辑：如果您需要下载大文件（即

stream=True