csv文件进行操作

最新推荐文章于 2020-09-25 16:10:12 发布

原创最新推荐文章于 2020-09-25 16:10:12 发布 · 427 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#csv

python 专栏收录该内容

15 篇文章

订阅专栏

本文详细介绍了使用Python的csv模块进行CSV文件的读写操作，包括如何使用DictWriter方法将字典列表写入CSV文件，并确保正确写入表头。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import csv

headers = ["username", "age", "height"]
#values = [
#        ("张三", 18, 180),
#        ("李四", 19, 190),
#        ("王五", 20, 160)
#        ]
#
#with open("classroom.csv", "w", encoding="utf-8", newline="") as fp:
#    writer = csv.writer(fp)
#    writer.writerow(headers)
#    writer.writerows(values)

values = [
        {"username":"张三","age":18, "height":180},
        {"username":"李四","age":19, "height":190},
        {"username":"王五","age":20, "height":160}
        ]
    
with open("classroom.csv", "w", encoding="utf-8", newline="") as fp:
    writer = csv.DictWriter(fp, headers)
    # 写表头的时候需要用writeheader()
    writer.writeheader()
    writer.writerows(values)