How do I add headers to a csv in python?

Question

I have added multiple lists to a csv with the following code:

with open(r'my\file\path.csv', 'w', newline='') as f:
    spamwriter = csv.writer(f, delimiter=',', quotechar='|', quoting=csv.QUOTE_MINIMAL)
    data = list(zip(First_Name, Last_Name, Emails, Phones, Status))
    for row in data:
        row = list(row)
        spamwriter.writerow(row)

However, the csv doesn't contain the headers:

['First_Name', 'Last_Name', 'Emails', 'Phones', 'Status']

How do I get the headers in the first row of the CSV? I need them to do some logic about which email addresses to send to.

Please refer to any tutorial on dealing with CSV files from Python. — Prune
– Prune, Commented Jul 18, 2020 at 17:54
Does this answer your question? Pythonically add header to a csv file — Roim
– Roim, Commented Jul 18, 2020 at 18:03

Matt · Accepted Answer · 2020-07-18 18:04:30Z

0

I found a way around it. I simply appended to header to each of the empty lists before going through each row. The header will print once at the top of each column in the csv.

Emails = []
Emails.append('Emails')
Status = []
Status.append('Status')
First_Name = []
First_Name.append('First_Name')
Last_Name = []
Last_Name.append('Last_Name')
Phones = []
Phones.append('Phones')

transactions = dict["transactions"]
for transaction in transactions:
    email = transaction['order']['description']['billingAddress']['email']
    Emails.append(email)
    status = transaction['order']['description']['subscription']['status']
    Status.append(status)
    first_name = transaction['order']['description']['billingAddress']['firstName']
    First_Name.append(first_name)
    last_name = transaction['order']['description']['billingAddress']['lastName']
    Last_Name.append(last_name)
    phone_number = transaction['order']['description']['billingAddress']['phone']
    Phones.append(phone_number)

with open(r'my\file\path.csv', 'w', newline='') as f:
    spamwriter = csv.writer(f, delimiter=',', quotechar='|', quoting=csv.QUOTE_MINIMAL)
    data = list(zip(First_Name, Last_Name, Emails, Phones, Status))
    for row in data:
        row = list(row)
        spamwriter.writerow(row)
    f.close()

answered Jul 18, 2020 at 18:04

Matt

51 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Roim Over a year ago

I recommend you to read about pandas package. It is a package for dealing with data, it will make all of your code much more simpler. Including reading from / writing to csv files

alani Over a year ago

Did you see Craig's comment? Literally all you need to do is write the header row before the for loop. spamwriter.writerow(['First_Name', 'Last_Name', 'Emails', 'Phones', 'Status'])

Collectives™ on Stack Overflow

How do I add headers to a csv in python?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related