使用Python填充csv fi

Question

下面的代码创建了一个CSV文件，但每隔一行是空白的。我怎样才能防止这些断线的发生？在

import datetime
import time
import csv

i = 0
while i < 10:
    TempProbe = "78.12" 
    CurrentTime = time.strftime("%x")
    CurrentDate = time.strftime("%I:%M:%S")
    stringAll = TempProbe + "," + CurrentTime + "," + CurrentDate
    print(stringAll)
    file = open("outFile.csv", "a")
    csvWriter = csv.writer( file )
    csvWriter.writerow( [TempProbe, CurrentTime,CurrentDate] )
    file.close()
    i = i + 1
    time.sleep(1)

Answer 1

这可能是因为默认的行终止符是'\r\n'。您可以通过将lineterminator='\n'传递给您的csv.writer对象来更正此问题，如下所示：

csvWriter = csv.writer(file, lineterminator='\n')

请注意，请将这一行移出while循环，以避免破坏和重新创建文件编写器对象。在

Answer 2

您只需使用open函数来编写csv文件：

file = open("outFile.csv", "a")
file.write(stringAll+'\n')

另外，您应该将文件open和close函数从循环中取出。在

Answer 3

您需要为csvWriter设置lineterminator，如下面的代码所示。在

csvWriter = csv.writer(file, lineterminator='\n')

有关原因的解释，请参见：CSV file written with Python has blank lines between each row