python 使用csv模块csv.writer.().writerrow()写入文件时,总是每行后会插入一空行
代码:
sales = (
('Tom',(78,69,74)),
('Tony', (83,87,78)),
('Jim',(69,75,74)),
('Sundy',(68,71,78)),
('Jody',(84,79,81)),
)
with open('./tests/salse.csv','w') as w:
write = csv.writer(w)
write.writerow(['name','Jan','Feb','Mar'])
for name, qa in sales:
write.writerow([name, qa[0], qa[1], qa[2]])
效果如下:
解决方法:
在open()内增加一个参数newline=’’ 即可:
sales = (
('Tom',(78,69,74)),
('Tony', (83,87,78)),
('Jim',(69,75,74)),
('Sundy',(68,71,78)),
('Jody',(84,79,81)),
)
with open('./tests/salse.csv','w',newline='') as w:
write = csv.writer(w)
write.writerow(['name','Jan','Feb','Mar'])
for name, qa in sales:
write.writerow([name, qa[0], qa[1], qa[2]])
效果: