擅长:python、mysql、java
<p>试试这个</p>
<pre><code>import json, pandas as pd
df=pd.DataFrame(json.loads('{ "shopName": "Shop", "promotions": [ { "productName": "Cookies", "oldPrice": 11.99, "newPrice": 7.99, "discount": 33 }, { "productName": "Butter", "oldPrice": 27.15, "newPrice": 21.99, "discount": 19 }, { "productName": "Milk", "oldPrice": 30.45, "newPrice": 21.99, "discount":27 } ]}')['promotions'])
print(df)
productName oldPrice newPrice discount
0 Cookies 11.99 7.99 33
1 Butter 27.15 21.99 19
2 Milk 30.45 21.99 27
print(df[df.discount==df.discount.max()])
productName oldPrice newPrice discount
0 Cookies 11.99 7.99 33
</code></pre>