擅长:python、mysql、java
<p>给定</p>
<pre><code>dict = {}
dict['key1']=[1,2,3]
dict['key2']=[4,5,6]
dict['key3']=[7,8,9]
</code></pre>
<p>以下代码:</p>
<pre><code>COL_WIDTH = 6
FMT = "%%-%ds" % COL_WIDTH
keys = sorted(dict.keys())
with open('out.csv', 'w') as csv:
# Write keys
csv.write(''.join([FMT % k for k in keys]) + '\n')
# Assume all values of dict are equal
for i in range(len(dict[keys[0]])):
csv.write(''.join([FMT % dict[k][i] for k in keys]) + '\n')
</code></pre>
<p>生成一个csv,它看起来像:</p>
<pre><code>key1 key2 key3
1 4 7
2 5 8
3 6 9
</code></pre>