擅长:python、mysql、java
<p>考虑到数据是一个字典列表,您可以使用<code>csv.DictWriter()</code>并使用最大键指定csv的列名。大概是这样的:</p>
<pre class="lang-py prettyprint-override"><code>data = [
{
"dscpTagValue": {"data": 10, "accuracy": "Low Drop"},
"description": "Latency Insensitive"
},
.
.
.
]
import csv
len_keys = [len(d.keys()) for d in data] # no. of keys of each dictionary
csv_columns = list(data[np.argmax(len_keys)]) # csv column headers == longest dict (keys)
try:
with open('file.csv', 'w') as f:
writer = csv.DictWriter(f, fieldnames=csv_columns)
writer.writeheader()
for d in data:
writer.writerow(d)
except IOError:
print('IOError')
</code></pre>