将有序元组列表保存为 CSV

Save list of ordered tuples as CSV(将有序元组列表保存为 CSV)
本文介绍了将有序元组列表保存为 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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Leetcode 234: Palindrome LinkedList(Leetcode 234:回文链接列表)
How do I read an Excel file directly from Dropbox#39;s API using pandas.read_excel()?(如何使用PANDAS.READ_EXCEL()直接从Dropbox的API读取Excel文件?)
subprocess.Popen tries to write to nonexistent pipe(子进程。打开尝试写入不存在的管道)
I want to realize Popen-code from Windows to Linux:(我想实现从Windows到Linux的POpen-code:)
Reading stdout from a subprocess in real time(实时读取子进程中的标准输出)
How to call type safely on a random file in Python?(如何在Python中安全地调用随机文件上的类型?)