将有序元组列表保存为 CSV

2022-01-20 00:00:00 python csv tuples

问题描述

我有一个按值排序的元组列表.它们采用 (name,count) 形式，其中count 是每个唯一名称的出现次数.

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.

我想将此列表转换为 CSV，其中每个名称都是列标题每个值都是单行的列值.

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.

有什么建议吗?谢谢.

解决方案

你可以这样做:

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

输出文件将有:

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

相关文章