将解析后的csv文件自动转换为pandas data fram

Question

我想从myportsfeeds.com网站它返回一个csv文件，这个文件立即转换成python中的字符串。在

import requests
import base64


username = 'XXXX'
password = 'XXXX'


def send_request(request):
    # Request

    try:
        response = requests.get(
        url=request,
        params={
            "fordate": "20170401"
        },
        headers={
            "Authorization": "Basic " + base64.b64encode(username + ":" + password)
        }
    )
    return response.content
except requests.exceptions.RequestException:
        print('HTTP Request failed')

res_table = send_request('https://www.mysportsfeeds.com/api/feed/pull/nba/2016-2017-regular/daily_game_schedule.csv?fordate=20170407')

如何以最快的方式将res_table转换为pandasdataFrame？在

它看起来像：

^{pr2}$

Answer 1

似乎您需要StringIO：

from pandas.compat import StringIO

df = pd.read_csv(StringIO(res_table))