嘿
我使用了一個為我生成 Json 產品的虛擬 api，我想使用
如您所見，上面的python代碼
輸出
我想要的是作為標題的鍵
從：{'id': 2, 'title': 'iPhone X', 'description':}
至 ：
Id Title description
1 iPhoneX descriptionx
2 iPhoneX descriptionx
uj5u.com熱心網友回復：
該代碼段r.json()實際上回傳一個包含 4 個鍵的字典：products、total和。看來您只對 感興趣，所以只需修改程式添加after就足夠了：skiplimitproducts["products"]r.json()
import requests
import pandas as pd
r = requests.get("https://dummyjson.com/products")
json_products = pd.DataFrame(r.json()["products"])
json_products.to_csv()
print(json_products)
這輸出：
id title ... thumbnail images
0 1 iPhone 9 ... https://dummyjson.com/image/i/products/1/thumb... [https://dummyjson.com/image/i/products/1/1.jp...
1 2 iPhone X ... https://dummyjson.com/image/i/products/2/thumb... [https://dummyjson.com/image/i/products/2/1.jp...
2 3 Samsung Universe 9 ... https://dummyjson.com/image/i/products/3/thumb... [https://dummyjson.com/image/i/products/3/1.jpg]
3 4 OPPOF19 ... https://dummyjson.com/image/i/products/4/thumb... [https://dummyjson.com/image/i/products/4/1.jp...
4 5 Huawei P30 ... https://dummyjson.com/image/i/products/5/thumb... [https://dummyjson.com/image/i/products/5/1.jp...
5 6 MacBook Pro ... https://dummyjson.com/image/i/products/6/thumb... [https://dummyjson.com/image/i/products/6/1.pn...
6 7 Samsung Galaxy Book ... https://dummyjson.com/image/i/products/7/thumb... [https://dummyjson.com/image/i/products/7/1.jp...
7 8 Microsoft Surface Laptop 4 ... https://dummyjson.com/image/i/products/8/thumb... [https://dummyjson.com/image/i/products/8/1.jp...
8 9 Infinix INBOOK ... https://dummyjson.com/image/i/products/9/thumb... [https://dummyjson.com/image/i/products/9/1.jp...
...
uj5u.com熱心網友回復：
我想這就是答案
import requests
import pandas as pd
import json
wantedElements = ["id", "description", "title"]
r = requests.get("https://dummyjson.com/products").text
all_json_products = json.loads(r)['products']
result = ""
for i in all_json_products:
json_products = i
for key in json_products.keys():
if key in wantedElements:
result = " " key " "
result = "\n"
for ele in json_products:
if ele in wantedElements:
result = " " str(json_products[ele]) " "
print(result)
我們不需要熊貓來做這件事。
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/493440.html
標籤：Python json python-3.x 列表 导出到 csv
上一篇：組合重復值的串列