写入csv-fi时，结尾为空行

Question

Python 3.6版

我每天要在CSV文件中写几次。当我启动脚本再次写入时，在最后一行和新行之间有一个空行。 我不认为它在我写的文本中，因为在同一个会话中写的行之间没有空行。如何避免？谢谢

csvTwitter = open("twitterDB.csv", 'a', newline='', encoding='utf-8')
wr = csv.writer(csvTwitter, quoting=csv.QUOTE_ALL)
listeInfosTweet = [tweet['id'],tweet['timestamp_ms'],tweet['created_at'],tweet['user']['name'],tweet['user']['location'],tweet['user']['followers_count'],texteTweet,tweet['lang']]
wr.writerow(listeInfosTweet)

Answer 1

我用python3运行了三次相同的条件代码，它不会重现您的问题。你知道吗

import csv


csvFile = open("./test.csv", 'a', newline='', encoding='utf-8')
try:
    writer = csv.writer(csvFile, quoting=csv.QUOTE_ALL)
    writer.writerow(['number', 'number plus 2', 'number times 2'])
    for i in range(10):
        writer.writerow([i, i+2, i*2])
finally:
    csvFile.close()

这个例子来自《用Python进行Web抓取：从现代Web收集数据》一书。 可能是你的数据源造成的？你知道吗

输出：

"number","number plus 2","number times 2"
"0","2","0"
"1","3","2"
"2","4","4"
"3","5","6"
"4","6","8"
"5","7","10"
"6","8","12"
"7","9","14"
"8","10","16"
"9","11","18"
"number","number plus 2","number times 2"
"0","2","0"
"1","3","2"
"2","4","4"
"3","5","6"
"4","6","8"
"5","7","10"
"6","8","12"
"7","9","14"
"8","10","16"
"9","11","18"
"number","number plus 2","number times 2"
"0","2","0"
"1","3","2"
"2","4","4"
"3","5","6"
"4","6","8"
"5","7","10"
"6","8","12"
"7","9","14"
"8","10","16"
"9","11","18"