Python 根据 url 列表创建合并的 df [pandas]

我能够从url_query个url中提取数据，但另外，我想从基于dataframe的query['ids']列创建的urls_list中获取数据.请参见以下当前逻辑:

    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)

df:

url_query响应提取了我需要的内容，但关键是我想在现有的'df'响应中添加issue_list = []中的数据.我不知道如何把issue_list = []与回应联系起来.我试图将问题列表添加到response = requests.get(issue_list, headers=headers,auth=auth, proxies=proxies)语句中，但出现了无效的模式错误.