1.声明csv.writer() 时 将dialect设置为unix,换行符即为'\n'
with open(self.game_name + '2022.csv', 'w', encoding='utf-8-sig') as f:
writer = csv.writer(f, dialect='unix') # 将dialect设置为unix,换行符即为'\n'
writer.writerow(self.bilibili_columns)
for line in self.data:
writer.writerow(line)
if self.index % 1000 == 0:
ct = time.time()
print("当前总进度: ++++++ {0}, 当前进度: ++++++ {1}, 每次进度耗时{2}s".format(len(self.data), self.index, ct-tt))
tt = ct
self.index += 1
2.打开方式加newline='' 空字符
with open(self.game_name + '2022.csv', 'w', encoding='utf-8-sig', newline='') as f:
writer = csv.writer(f) # 将dialect设置为unix,换行符即为'\n'
writer.writerow(self.bilibili_columns)
for line in self.data:
writer.writerow(line)
if self.index % 1000 == 0:
ct = time.time()
print("当前总进度: ++++++ {0}, 当前进度: ++++++ {1}, 每次进度耗时{2}s".format(len(self.data), self.index, ct-tt))
tt = ct
self.index += 1