我正在嘗試將 json 資料轉換為 csv 并且我能夠做到
但是一個主要問題是我需要在串列中硬編碼我的標題......如何自動獲取標題，甚至我正在傳遞 - jsdata['clients'] - >客戶端硬編碼
需要使我傳遞的標頭和客戶端通用
代碼 ：
import json
import csv
header = ["id","isActive","age","name","gender","company","email","phone","address"]
with open('/content/sample_data/ABC.json') as rd:
jsdata = json.loads(rd.read())
with open('/content/sample_data/Ts.csv','w') as wr:
csv_wr = csv.DictWriter(wr,fieldnames=header)
csv_wr.writeheader()
csv_wr.writerows(jsdata['clients'])
以下是我的 json 資料
{
"clients": [
{
"id": "59761c23b30d971669fb42ff",
"isActive": true,
"age": 36,
"name": "Dunlap Hubbard",
"gender": "male",
"company": "CEDWARD",
"email": "[email protected]",
"phone": " 1 (890) 543-2508",
"address": "169 Rutledge Street, Konterra, Northern Mariana Islands, 8551"
},
{
"id": "59761c233d8d0f92a6b0570d",
"isActive": true,
"age": 24,
"name": "Kirsten Sellers",
"gender": "female",
"company": "EMERGENT",
"email": "[email protected]",
"phone": " 1 (831) 564-2190",
"address": "886 Gallatin Place, Fannett, Arkansas, 4656"
},
{
"id": "59761c23fcb6254b1a06dad5",
"isActive": true,
"age": 30,
"name": "Acosta Robbins",
"gender": "male",
"company": "ORGANICA",
"email": "[email protected]",
"phone": " 1 (882) 441-3367",
"address": "697 Linden Boulevard, Sattley, Idaho, 1035"
}
]
}
uj5u.com熱心網友回復：
如果客戶端串列中的每個字典都具有相同的鍵，那么...
csv_wr = csv.DictWriter(wr,fieldnames=jsdata['clients'][0])
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/448564.html