循环通过url端点并将json转换为pandas dataframe。

import pandas as pd
import requests

def get_json_data(url):
    response = requests.get(url)
    json_data = response.json()
    df = pd.DataFrame(json_data)
    return df

url_endpoints = ['url1', 'url2', 'url3']

dataframes = []
for endpoint in url_endpoints:
    df = get_json_data(endpoint)
    dataframes.append(df)

merged_df = pd.concat(dataframes, ignore_index=True)