Python将标头添加到CSV文件

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)