How to add a header to a csv file in Python?

Question

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

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

2. 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?

Answer 1

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.