Python 将两个列表写入 csv、展平并带有列标题

Question

我有两个列表:

A = [[1,2,3,4,5,6], [9,2,4,5,3,2]]
B = [[12,5,6,7,8,6], [12,1,3,4,1,2]]

我想通过以下方式将这些列表中的值写入 csv 文件。

import csv    

writer = csv.writer(open('randnums.csv','w'))

for row in A,B:
    writer.writerow(row)

结果是一行，其中包含来自 A[0] 和 B[0](依此类推)的项目，标题如下:

A,B,C,D,E,F,G,H,J,K,L,M
1,2,3,4,5,6,12,5,6,7,8,6
9,2,4,5,3,2,12,1,3,4,1,2

Answer 1

>>> import csv, string
>>> A = [[1,2,3,4,5,6], [9,2,4,5,3,2]]
>>> B = [[12,5,6,7,8,6], [12,1,3,4,1,2]]
>>> with open('randnums.csv','w') as f:
    w = csv.writer(f)
    w.writerow(string.uppercase[:len(A[0] + B[0])])
    for x, y in zip(A, B):
        w.writerow(x + y)


>>> with open('randnums.csv') as f:
    print f.read()


A,B,C,D,E,F,G,H,I,J,K,L
1,2,3,4,5,6,12,5,6,7,8,6
9,2,4,5,3,2,12,1,3,4,1,2