解决python写入csv文件每两行间 隔一个空行的问题

像这样。

这是因为导入的时候,是这样写的:

with open('book_statics.csv', 'w+') as csvfile:
    writer = csv.writer(csvfile)
    for i in ans:
        writer.writerow(i)

只要改成wb+,也就是写二进制文件,就好了吗?

with open('book_statics.csv', 'wb+') as csvfile:
    writer = csv.writer(csvfile)
    for i in ans:
        writer.writerow(i)

 并没有!!!

报错:TypeError: a bytes-like object is required, not 'str'

查阅了官方文档,改成如下即可

with open('book_statics.csv', 'w+', newline='') as csvfile:
    writer = csv.writer(csvfile)
    for i in ans:
        writer.writerow(i)

  

成功解决。

posted @ 2017-11-19 17:34  深圳地铁Princess  阅读(1787)  评论(0编辑  收藏  举报