我正在尝试将API转换为数据帧
示例API:https://api.fda.gov/drug/event.json?search=(receivedate:[20040101+TO+20210629])+AND+PREDNISOLONE
这是我的密码:
import json
import requests
import pandas as pd
def callAPI(drug_name, recievedate_from, recievedate_to):
url='https://api.fda.gov/drug/event.json?search=(receivedate:
['+str(recievedate_from)+'+TO+'+str(recievedate_to)+'])+AND+'+str(drug_name)
r = requests.get(url).json()
data = json.load(open(r))
df = pd.DataFrame(data["results"])
print(df)
callAPI('PREDNISOLONE', 20040101, 20210629)
我得到一个错误:
TypeError: expected str, bytes or os.PathLike object, not dict
我怎样才能把它做好
json.loads()
,你不应该自己调用它相关问题 更多 >
编程相关推荐