我能夠從url_queryurl 中提取資料，但另外，我想從urls_list基于資料框中的query['ids']列創建的資料中獲取資料。請看下面的當前邏輯：
url = 'https://instancename.some-platform.com/api/now/table/data?display_value=true&'
team = 'query=group_name=123456789'
url_query = url team
dataframe: query
[ids]
0 aaabbb1cccdddeee4ffggghhhhh5iijj
1 aa1bbb2cccdddeee5ffggghhhhh6iijj
issue_list = []
for issue in query['ids']:
issue_list.append(f'https://instancename.some-platform.com/api/now/table/data?display_value=true&?display_value=true&query=group_name&sys_id={issue}')
response = requests.get(url_query, headers=headers,auth=auth, proxies=proxies)
data = response.json()
def api_response(k):
dct = dict(
event_id= k['number'],
created_time = k[‘created’],
status = k[‘status’],
created_by = k[‘raised_by’],
short_desc = k[‘short_description’],
group = k[‘team’]
)
return dct
raw_data = []
for p in data['result']:
rec = api_response(k)
raw_data.append(rec)
df = pd.DataFrame.from_records(raw_data)
東風：
![根據 url 串列創建合并的 df [pandas]](https://img.uj5u.com/2022/05/17/87df8c28061c434f909d5e43b86dfed9.png)
回應提取了我需要的url_query內容，但關鍵是我想添加到現有的中'df'添加來自issue_list = []. 我不知道如何issue_list = []回應。我嘗試將 issue_list 添加到response = requests.get(issue_list, headers=headers,auth=auth, proxies=proxies)陳述句中，但出現無效架構錯誤。
uj5u.com熱心網友回復：
您可以使用查詢創建 DataFrame 串列，并通過以下q方式url_query最后連接在一起concat：
dfs = []
for issue in query['ids']:
q = f'https://instancename.some-platform.com/api/now/table/data?display_value=true&?display_value=true&query=group_name&sys_id={issue}'
response = requests.get(q, headers=headers,auth=auth, proxies=proxies)
data = response.json()
raw_data = [api_response(k) for p in data['result']]
df = pd.DataFrame.from_records(raw_data)
dfs.append(df)
df = pd.concat(dfs, ignore_index=True)
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/475856.html