值错误：无效的文件路径或缓冲区对象类型：<类"字典">python

Question

运行以下代码时，出现以下错误：

值错误：文件路径或缓冲区对象类型无效：类"dict>

法典：

import requests as rq
import pandas as pd
import json
df = pd.DataFrame()
temp = pd.DataFrame()
with open("tfl_list_stops.txt", encoding="utf-8") as file:
fileList = [line.strip() for line in file]
for ids in fileList:
r = rq.get('https://api.tfl.gov.uk/StopPoint/' + ids + '?includeCrowdingData=true')
r = r.text
content = json.loads(r)
temp = pd.read_json(content)
df = pd.concat([df, temp], axis=1)
df.to_csv('stop_loc.csv')

Answer 1

你可以试试这个，

import requests as rq
import pandas as pd
import json
dfs = []
with open('tfl_list_stops.txt', encoding='utf-8') as file:
file_list = [line.strip() for line in file]
for ids in file_list:
url = 'https://api.tfl.gov.uk/StopPoint/' + ids + '?includeCrowdingData=true'
r = rq.get(url)
content = json.loads(r.text)
dfs.append(pd.DataFrame([content]))
df = pd.concat(dfs, ignore_index=True, sort=False)
df.to_csv('stop_loc.csv')
print(df)
$type     naptanId  
0  Tfl.Api.Presentation.Entities.StopPoint, Tfl.A...  940GZZLUBMY   
modes  icsCode smsCode            stopType stationNaptan  
0  [bus, tube]  1000021   77031  NaptanMetroStation   940GZZLUBMY   
lines  
0  [{'$type': 'Tfl.Api.Presentation.Entities.Iden...   
lineGroup  
0  [{'$type': 'Tfl.Api.Presentation.Entities.Line...   
lineModeGroups  status           id  
0  [{'$type': 'Tfl.Api.Presentation.Entities.Line...    True  940GZZLUBMY   
commonName  placeType  
0  Bermondsey Underground Station  StopPoint   
additionalProperties  
0  [{'$type': 'Tfl.Api.Presentation.Entities.Addi...   
children       lat       lon  
0  [{'$type': 'Tfl.Api.Presentation.Entities.Stop...  51.49775 -0.063993