python怎么添加csv模式,如何在Python中添加标题到csv文件？

I've tried many solutions to add a header to my csv file, but nothing's working properly. Here they are :

I used the writerow method, but my data are overwriting the first row.

I used the DictWriter method, but I don't know how to fill it correctly. Here is my code:

csv = csv.DictWriter(open(directory +'/csv.csv', 'wt'), fieldnames = ["stuff1", "stuff2", "stuff3"], delimiter = ';')

csv.writeheader(["stuff1", "stuff2", "stuff3"])

I got a "2 arguments instead of one" error and I really don't know why.

Any advice?

解决方案

All you need to do is call DictWriter.writeheader() without arguments:

with open(os.path.join(directory, 'csv.csv'), 'wb') as csvfile:

writer = csv.DictWriter(csvfile, fieldnames = ["stuff1", "stuff2", "stuff3"], delimiter = ';')

writer.writeheader()

You already told DictWriter() what your headers are.