Writing header to a csv file in python

Question

I have this csv file ( file.csv) :

1,4.00,B
1,8.00,C
2,5.00,"B,C"
2,6.50,"C,D"
3,4.00,B
3,8.00,"B,D"

I would like to read this file in python and then write a header( ID, COST, NAME) to this csv file in python. So that it looks like this.

ID,COST,NAME
1,4.00,B
1,8.00,C
2,5.00,"B,C"
2,6.50,"C,D"
3,4.00,B
3,8.00,"B,D"

How can I do this ?

Do you really have a problem with this? What stops you from simply writing "ID,COST,NAME" as the first time to the new file? — Raul Guiu
– Raul Guiu, Commented Mar 18, 2014 at 6:56

barrios · Accepted Answer · 2014-03-18 07:09:15Z

1

What about this?

headers = ["ID", "COST", "NAME"]
rows = [(1, 4.00,"B"),
        (1, 8.00,"C")]
with open(name.csv','w') as f:
    f_csv = csv.writer(f)
    f_csv.writerow(headers)
    f_csv.writerows(rows)

answered Mar 18, 2014 at 7:09

barrios

1,1341 gold badge12 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Writing header to a csv file in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related