How to write headers to a csv file?

Question

I've wrote this code to write headers to a csv file:

    with open(os.path.join(directory, 'UserPass.csv'), 'wb') as csvFile:
    writer = csv.DictWriter(csvFile, fieldnames = ['Username', 'Password'], delimeter = ',')
    writer.writeheader()

However, it comes up with an error saying that directory is not defined. Why is this happening, what would I define directory as? Is there a better way to write headers? Thank you.

Answer 1

Directory is the location of the directory (aka folder) that you want to save UserPass.csv. See os.path.join docs for more info.

Answer 2

Easiest way would be using sed since you mention alternatives, just do,

sed -i '1iUsername,Password' UserPass.csv