如何才能在文件顶部只放一次标题

Question

我想把标题放在第一行，数据将在下一行，但标题不断重复。有人能帮我修改程序吗？

这是我的节目

`if str(raw_data[0:6]) == "b'$GNRMC'":
lat = parsed_data.lat
lon = parsed_data.lon
t2 = time.time()        
elapsed_time = t2 - t1
gps = [str(elapsed_time), str(lat), str(lon)]

header = ['Time', 'Latitude', 'Longitude']

with open('C:/Desktop/GPS_Trial/9.csv', 'a', newline = '', encoding='UTF8') as f:
writer = csv.writer(f)
writer.writerow(header)
writer.writerow(gps)
print(gps)`

Answer 1

在写入文件之前，请检查该文件是否存在。

filename = 'C:/Desktop/GPS_Trial/9.csv'
rows_to_be_written = []
if not os.path.exists(filename):
rows_to_be_written.append(header)
rows_to_be_written.append(gps)
with open(filename, 'a', newline='', encoding='UTF8') as f:
writer = csv.writer(f)
for row in rows_to_be_written:
writer.writerow(row)