Python将标头添加到CSV文件

Python将标头添加到CSV文件,第1张

Python将标头添加到CSV文件

DictWriter()
班预计 字典 的每一行。如果您只想编写一个初始标头,请使用常规
csv.writer()
并在标头的简单行中传递:

import csvwith open('combined_file.csv', 'w', newline='') as outcsv:    writer = csv.writer(outcsv)    writer.writerow(["Date", "temperature 1", "Temperature 2"])    with open('t1.csv', 'r', newline='') as incsv:        reader = csv.reader(incsv)        writer.writerows(row + [0.0] for row in reader)    with open('t2.csv', 'r', newline='') as incsv:        reader = csv.reader(incsv)        writer.writerows(row[:1] + [0.0] + row[1:] for row in reader)

另一种方法是在跨数据复制时生成字典

import csvwith open('combined_file.csv', 'w', newline='') as outcsv:    writer = csv.DictWriter(outcsv, fieldnames = ["Date", "temperature 1", "Temperature 2"])    writer.writeheader()    with open('t1.csv', 'r', newline='') as incsv:        reader = csv.reader(incsv)        writer.writerows({'Date': row[0], 'temperature 1': row[1], 'temperature 2': 0.0} for row in reader)    with open('t2.csv', 'r', newline='') as incsv:        reader = csv.reader(incsv)        writer.writerows({'Date': row[0], 'temperature 1': 0.0, 'temperature 2': row[1]} for row in reader)


欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/zaji/5643838.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-12-16
下一篇 2022-12-16

发表评论

登录后才能评论

评论列表(0条)

保存