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

嗨，我有一些问题。

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''

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

请您参考如下方法:

你可以试试这个

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})