如何在Python中导入API url到json
我必须使用API中的数据集。我试图以json格式导入数据，但出现了错误。
这是我的密码：
import requests as rq
r = rq.get('https://api.tfl.gov.uk/BikePoint')
print(r.status_code)
print(r.headers['content-type'])
print(r.text[:1000])这就是结果：
200份申请书/json；charset=utf-8 [{"$type":"Tfl.Api.Presentation.Entities.Place，Tfl.Api.Presentation.Entities，"id":"BikePoints_1"，“url”：“/Place/BikePoint_1”，"commonName":"River Street，Clerkenwell"，"placeType":"BikePoint"，"additionalProperties":[{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties，Tfl.Api.Presentation.Entities，“分类”：“Description”，"key":"TerminalName"，"sourceSystemKey":"BikePoints"，"value":"001023"，“修改”：“2019-08-19T14:23:57.613Z”}，sourceSystemKey Tfl.Api.Presentation.Entities，“类别”：“描述”，“键”：“已安装”，"sourceSystemKey":"BikePoints"，“值”：“真”，“修改”：“2019-08-19T14:23:57.613Z”}，{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties，Tfl.Api.Presentation.Entities、“类别”：“描述”、“键”：“锁定”、"sourceSystemKey":"BikePoints“、”值“：”false“、”修改“：”2019-08-19T14:23:57.613Z“}、{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties，Tfl.Api.Presentation.Entities、”BikePoints“：”Description“
我想将它导入到json中，然后将数据转换为数据。
有人能告诉我正确的方法吗？
回答 1
Stack Overflow用户
发布于 2019-08-19 15:11:11
您可以使用read_json()函数在pandas中获得它。下面是如何从api中检索数据。
import pandas as pd
import requests as rq
r = rq.get('https://api.tfl.gov.uk/BikePoint')
r = r.text
df = pd.read_json(r)
print(df.head()) $type id ... lat lon
0 Tfl.Api.Presentation.Entities.Place, Tfl.Api.P... BikePoints_1 ... 51.529163 -0.109970
1 Tfl.Api.Presentation.Entities.Place, Tfl.Api.P... BikePoints_2 ... 51.499606 -0.197574
2 Tfl.Api.Presentation.Entities.Place, Tfl.Api.P... BikePoints_3 ... 51.521283 -0.084605
3 Tfl.Api.Presentation.Entities.Place, Tfl.Api.P... BikePoints_4 ... 51.530059 -0.120973
4 Tfl.Api.Presentation.Entities.Place, Tfl.Api.P... BikePoints_5 ... 51.493130 -0.156876https://stackoverflow.com/questions/57559411
复制相似问题
腾讯云开发者
