<p>您可以将结果内容转换为数据帧,然后只需使用<strong>winnerOr2ndName</strong>和<strong>winnerOr2ndId</strong>列即可</p>
<p>范例</p>
<pre><code>import json
import requests
import pandas as pd
def get_items(dog_id):
url = f"https://api.gbgb.org.uk/api/results/dog/{dog_id}?page=-1"
params = {"page": "-1", "itemsPerPage": "20", "race_type": "race"}
response = requests.get(url, params=params).json()
MAX_PAGES = response["meta"]["pageCount"]
result = pd.DataFrame(pd.DataFrame(response["items"]).loc[:, ['winnerOr2ndName','winnerOr2ndId']].dropna())
result["winnerOr2ndId"] = result["winnerOr2ndId"].astype(int)
while int(params.get("page"))<MAX_PAGES:
params["page"] = str(int(params.get("page")) + 1)
response = requests.get(url, params=params).json()
new_items = pd.DataFrame(pd.DataFrame(response["items"]).loc[:, ['winnerOr2ndName','winnerOr2ndId']].dropna())
new_items["winnerOr2ndId"] = new_items["winnerOr2ndId"].astype(int)
result = pd.concat([result, new_items])
return result.drop_duplicates()
</code></pre>
<p>它将生成如下所示的数据帧:</p>
<p><a href="https://i.stack.imgur.com/tHNsz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tHNsz.png" alt="enter image description here"/></a></p>