Save list of ordered tuples as CSV [duplicate]

Question

I have a list of tuples ordered by value. They are in the form (name,count) where count is number of occurrences for each unique name.

I would like to take this list and transform it into CSV where each name is column header and each value is column value of a single row.

Any suggestions how to do it? Thanks.

Answer 1

You can do this:

import csv  # note: If you use 'b' for the mode, you will get a TypeError # under Python3. You can just use 'w' for Python 3  data=[('smith, bob',2),('carol',3),('ted',4),('alice',5)]  with open('ur file.csv','wb') as out:     csv_out=csv.writer(out)     csv_out.writerow(['name','num'])     for row in data:         csv_out.writerow(row)      # You can also do csv_out.writerows(data) instead of the for loop 

the output file will have:

name,num "smith, bob",2 carol,3 ted,4 alice,5