<p>数据集太过自定义,无法与某些框架一起使用。这是一种方法:</p>
<pre><code>import csv
data = {"test_sheet": {"testheader": [{"2018-12-31": {"field1": 8482000000, "field2": 166731000000, "field3": 92128000000}}, {"2018-11-30": {"field1": 7579000000, "field2": 171652000000, "field3": 85967000000}}, {"2018-10-31": {"field1": 8053000000, "field2": 176130000000, "field3": 82718000000}}, {"2018-09-30": {"field1": 8544000000, "field2": 166258000000, "field3": 79239000000}}]}}
pf = open("out.csv", "w")
writer = csv.DictWriter(pf, fieldnames=["Report", "Name", "Date", "Field1", "Field2", "Field3"])
writer.writeheader()
for report, report_data in data.items():
for name, name_data in report_data.items():
for date_wrapper in name_data:
date = list(date_wrapper.keys())[0]
date_data = date_wrapper[date]
writer.writerow({
"Report": report,
"Name": name,
"Date": date,
"Field1": date_data['field1'],
"Field2": date_data['field2'],
"Field3": date_data['field3']
})
pf.close()
</code></pre>
<p><strong>更新:</strong>对于第二个版本:</p>
^{pr2}$