将resquest.content转换为Pandas Dataframe python

Question

我请求从如下服务器登录并下载数据：

import pandas as pd
import requests
from io import StringIO
import json

url = "http://192.168.18.18/vicidial/call_report_export.php"

querystring = {"DB":"",
           "run_export":"1",
           "ivr_export":"",
           "query_date":"2019-10-22",
           "end_date":"2019-10-22",
           "date_field":"call_date",
           "header_row":"YES",
           "rec_fields":"NONE",
           "call_notes":"NO",
           "export_fields":"STANDARD",
           "campaign[]":["EdsnSTF","SuperED"],
           "SUBMIT":"SUBMIT",
           "campaign%5B%5D":["EdsnSTF","SuperED"]}

headers = {'Authorization': "Basic ZWs5NjAxNDoxMjUw",
           'Accept': "*/*",
           'Cache-Control': "no-cache",
           'Host': "192.168.18.18",
           'Accept-Encoding': "gzip, deflate",
           'Connection': "keep-alive",
           'cache-control': "no-cache"
           }

response = requests.get(url, headers=headers, params=querystring)

print(response.content)

答复的内容如下：

b'call_date\tphone_number_dialed\tstatus\tuser\tfull_name\tcampaign_id\tvendor_lead_code\tsource_id\tlist_id\tgmt_offset_now\tphone_code\tphone_number\ttitle\tfirst_name\tmiddle_initial\tlast_name\taddress1\taddress2\taddress3\tcity\tstate\tprovince\tpostal_code\tcountry_code\tgender\tdate_of_birth\talt_phone\temail\tsecurity_phrase\tcomments\tlength_in_sec\tuser_group\talt_dial\trank\towner\tlead_id\tlist_name\tlist_description\tstatus_name\r\n

我无法用python将其转换为数据帧

Answer 1

该响应看起来只是响应的标题行。并且在末尾缺少一个'

它是一个bytes，因此需要将其转换为字符串content.decode(<encoding>)。编码可能是UTF8，但也可以是ASCII或其他编码，具体取决于服务器

然后用pandas.read_csv：

pd.read_csv(StringIO(content.decode("utf8")), sep="\t")

你得到一个数据帧