Python附加到没有白行且没有重复列的csv文件

Question

嗨，我有一些问题。

import csv
test = ['a','b','c','d','e']

for t in test:
    with open('names.csv', 'a') as csvfile:

        fieldnames = ['acol', 'bcol', 'ccol']
        writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
        writer.writeheader()
        writer.writerow({'acol': t, 'bcol': t, 'ccol': t})

'names.csv'结果

acol bcol ccol

一个一个

acol bcol ccol

b b b

acol bcol ccol

ccc

acol bcol ccol

ddd

acol bcol ccol

e e e''

有白线和列重复我想要没有白行且没有列重复的结果

Answer 1

你可以试试这个

import csv
test = ['a','b','c','d','e']

with open('names.csv', 'wb') as csvfile:
    fieldnames = ['acol', 'bcol', 'ccol']
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    writer.writeheader()
    for t in test:
        writer.writerow({'acol': t, 'bcol': t, 'ccol': t})