写入CSV文件时如何追加到新行 [英] how to append to a new row when writing to CSV file

问题描述

我想在写入CSV文件时将其追加到新行.当前的CSV文件如下所示:

I want to append to a new row in my CSV file when i write to it. Current CSV file look like this:

a,b,c
1,1,1

我要附加到CSV文件的代码:

my code to append to CSV file:

with open('mycsvfile.csv','a') as f:
    writer=csv.writer(f)
    writer.writerow(['0','0','0'])

新的mycsv文件:

a,b,c
1,1,1,0,0,0

我想要什么:

a,b,c
1,1,1
0,0,0

推荐答案

通过一些修补，我意识到您可以添加以下行，以确保您开始在csv中的新行中编写.虽然看起来有点黑.文档中提到了很多有关kwarg newline =''的内容，但并未被认为是有效的.

With some tinkering I realized you can add the following line to make sure you begin writing on a new line in a csv. Though it seems kind of hackish. Documentation mentions a lot about a kwarg newline='', but it wasn't recognized as valid.

writer.writerow([])

我也用'ab'参数打开.

I also open with 'ab' parameter.

import csv
with open('mycsvfile.csv','ab') as f:
    writer=csv.writer(f)
    writer.writerow([])
    writer.writerow(['0','0','0'])

这篇关于写入CSV文件时如何追加到新行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！