擅长:python、mysql、java
<p>这适用于您发布的JSON示例。问题是您已经嵌套了<code>dict</code>,并且您无法根据需要为<code>pcredit, pdebit, pbalance, ptransactiondate, pvaluedate and ptest</code>创建子标题和子行。在</p>
<p>您可以使用<code>csv.DictWriter</code>:</p>
<pre><code>import csv
import json
with open("BankStatementJSON1.json", "r") as inputFile: # open json file
data = json.loads(inputFile.read()) # load json content
with open("testing.csv", "w") as outputFile: # open csv file
output = csv.DictWriter(outputFile, data.keys()) # create a writer
output.writeheader()
output.writerow(data)
</code></pre>