本文介绍了将有序元组列表保存为 CSV的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个按值排序的元组列表.它们采用 (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
这篇关于将有序元组列表保存为 CSV的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!