python - 如何阻止 Python 的 csv.DictWriter.writerows 在 Windows 中的行之间添加空行？

Question

当我在 Windows 上使用 Python 的 csv.DictWriter.writerows 时，行之间会添加空换行符。我该如何阻止它？该代码在 Linux 上运行良好。

Answer 1

• 在 Python 2 中:始终以二进制模式打开文件； csv.DictWriter() 写入 \r\n 行结尾:

  with open(filename, 'ab') as outputfile:
      writer = csv.DictWriter(outputfile, fieldnames)
  

  来自csv.writer() documentation :

  If csvfile is a file object, it must be opened with the ‘b’ flag on platforms where that makes a difference.

• 在 Python 3 中:使用 newline='' 打开文件，这样 csv.DictWriter() 就可以控制没有翻译的换行符:

  with open(filename, 'a', newline='') as outputfile:
      writer = csv.DictWriter(outputfile, fieldnames)
  

  再次引用相关的csv.writer() documenation :

  If csvfile is a file object, it should be opened with newline=''

  [ ... ]

  If newline='' is not specified, newlines embedded inside quoted fields will not be interpreted correctly, and on platforms that use \r\n linendings on write an extra \r will be added. It should always be safe to specify newline='', since the csv module does its own (universal) newline handling.