擅长:python、mysql、java
<p>使用<code>from_records</code>尝试此操作:</p>
<pre><code>data = []
request2 = requests.get('https://www.punters.com.au/api/web/public/Odds/getOddsComparisonCacheable/?allowGet=true&APIKey=65d5a3e79fcd603b3845f0dc7c2437f0&eventId=1051322&betType=FixedWin', headers={'User-Agent': 'Mozilla/5.0'})
json2 = request2.json()
for selection in json2['selections']:
for fluc in selection['flucs'][0]:
flucs1 = ast.literal_eval(selection['flucs'])
flucs2 = flucs1[-2:]
flucs3 = [x[1] for x in flucs2] #Note: remove extra brackets from here
data.append(flucs3)
df3 = pd.DataFrame.from_records(data, columns=['Flucs 1', 'Flucs 2'])
</code></pre>
<p>输出:</p>
<pre><code> Flucs 1 Flucs 2
0 9.05 9.08
1 8.55 8.45
2 7.45 7.55
3 36.62 37.38
4 18.55 18.78
5 14.97 14.89
6 10.09 10.02
7 16.97 17.05
8 30.38 30.77
9 9.82 9.89
10 9.82 9.89
11 9.78 9.61
12 8.91 8.90
13 13.82 13.83
</code></pre>