Python3通过writerow写入csv文件 多了一条空行

1.声明csv.writer() 时 将dialect设置为unix，换行符即为'\n'

1.  
   with open(self.game_name '2022.csv', 'w', encoding='utf-8-sig') as f:
2.  
   writer = csv.writer(f, dialect='unix') # 将dialect设置为unix，换行符即为'\n'
3.  
   writer.writerow(self.bilibili_columns)
4.  
   for line in self.data:
5.  
   writer.writerow(line)
6.  
   if self.index % 1000 == 0:
7.  
   ct = time.time()
8.  
   print("当前总进度: {0}, 当前进度: {1}, 每次进度耗时{2}s".format(len(self.data), self.index, ct-tt))
9.  
   tt = ct
10.  
    self.index = 1

2.打开方式加newline='' 空字符

1.  
   with open(self.game_name '2022.csv', 'w', encoding='utf-8-sig', newline='') as f:
2.  
   writer = csv.writer(f) # 将dialect设置为unix，换行符即为'\n'
3.  
   writer.writerow(self.bilibili_columns)
4.  
   for line in self.data:
5.  
   writer.writerow(line)
6.  
   if self.index % 1000 == 0:
7.  
   ct = time.time()
8.  
   print("当前总进度: {0}, 当前进度: {1}, 每次进度耗时{2}s".format(len(self.data), self.index, ct-tt))
9.  
   tt = ct
10.  
    self.index = 1

这篇好文章是转载于：学新通技术网