如何在Python中添加标题到csv文件? [英] How to add a header to a csv file in Python?

查看:1833
本文介绍了如何在Python中添加标题到csv文件?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我试过很多解决方案来添加一个标题到我的csv文件,但没有什么工作正常。这里他们是:


  1. 我使用writerow方法,但我的数据覆盖第一行。

    li>
  2. 我使用DictWriter方法,但我不知道如何正确填充它。这是我的代码:

      csv = csv.DictWriter(open(directory +'/ csv.csv','wt') ,fieldnames = [stuff1,stuff2,stuff3],delimiter =';')
    csv.writeheader([stuff1,stuff2,stuff3])


我有一个2参数而不是一个不知道为什么。



任何建议?

解决方案

您需要做的是调用 DictWriter.writeheader() writer = csv.DictWriter(csvfile,fieldnames = [stuff1,stuff2,stuff3],delimiter =';')
writer。 writeheader()

您已经告诉 DictWriter )您的标题是什么。


I've tried many solutions to add a header to my csv file, but nothing's working properly. Here they are :

  1. I used the writerow method, but my data are overwriting the first row.

  2. I used the DictWriter method, but I don't know how to fill it correctly. Here is my code:

    csv = csv.DictWriter(open(directory +'/csv.csv', 'wt'), fieldnames = ["stuff1", "stuff2", "stuff3"], delimiter = ';')
    csv.writeheader(["stuff1", "stuff2", "stuff3"])
    

I got a "2 arguments instead of one" error and I really don't know why.

Any advice?

解决方案

All you need to do is call DictWriter.writeheader() without arguments:

with open(os.path.join(directory, 'csv.csv'), 'wb') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames = ["stuff1", "stuff2", "stuff3"], delimiter = ';')
    writer.writeheader()

You already told DictWriter() what your headers are.

这篇关于如何在Python中添加标题到csv文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆