Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python

Question

I am using DictWriter to output data in a dictionary to a csv file   Why does the CSV file have a blank line in between each data line   It s not a huge deal  but my dataset is big and doesn t fit into one csv file because it has too many lines since the  double-spacing  doubles the number of lines in the file   My code for writing to the dictionary is   headers   id    year    activity    lineitem    datum   output   csv DictWriter open  file3 csv   w    delimiter      fieldnames headers  output writerow dict  fn fn  for fn in headers   for row in rows      output writerow row

User · Accepted Answer

By default  the classes in the csv module use Windows-style line terminators   r n  rather than Unix-style   n   Could this be what   s causing the apparent double line breaks   If so  you can override it in the DictWriter constructor   output   csv DictWriter open  file3 csv   w    delimiter      lineterminator   n   fieldnames headers

User · Answer

I just tested your snippet  and their is no double spacing line here  The end-of-line are  r n  so what i would check in your case is    your editor is reading correctly DOS file no  n exist in values of your rows dict     Note that even by putting a value with  n  DictWriter automaticly quote the value

User · Answer

Changing the  w   write  in this line   output   csv DictWriter open  file3 csv   w    delimiter      fieldnames headers    To  wb   write binary  fixed this problem for me   output   csv DictWriter open  file3 csv   wb    delimiter      fieldnames headers    Python v2 75  Open    Credit to  dandrejvv for the solution in the comment on the original post above

User · Answer

From http   docs python org library csv html csv writer      If csvfile is a file object  it must be opened with the    b    flag on   platforms where that makes a difference    In other words  when opening the file you pass  wb  as opposed to  w   You can also use a with statement to close the file when you re done writing to it  Tested example below   from   future   import with statement   not necessary in newer versions import csv headers   id    year    activity    lineitem    datum   with open  file3 csv   wb   as fou    note   wb  instead of  w      output   csv DictWriter fou delimiter     fieldnames headers      output writerow dict  fn fn  for fn in headers       output writerows rows

[python] Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python

Examples related to python

Examples related to csv

Examples related to dictionary