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

by

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, in python 2 you can override it in the DictWriter constructor:

output = csv.DictWriter(open('file3.csv','w'), delimiter=",", lineterminator="\n", fieldnames=headers)

More Related Contents:

  1. Connecting data in python to spreadsheets
  2. Creating a dictionary from a csv file?
  3. How do I convert this list of dictionaries to a csv file?
  4. Writing a dictionary to a csv file with one line for every ‘key: value’
  5. Creating a dictionary from a CSV file
  6. Merging two CSV files using Python
  7. Write dictionary of lists to a CSV file
  8. Python Dictionary to CSV
  9. convert csv file to list of dictionaries
  10. Converting a csv file into a list of tuples with python
  11. Python: Writing Nested Dictionary to CSV
  12. How to select random key with common values?
  13. How to “perfectly” override a dict?
  14. List of unique dictionaries
  15. How to properly subclass dict and override __getitem__ & __setitem__
  16. How to overcome TypeError: unhashable type: ‘list’
  17. What do I do when I need a self referential dictionary?
  18. Save results to csv file with Python
  19. Search for a key in a nested Python dictionary
  20. Split string on commas but ignore commas within double-quotes?
  21. Read CSV file with comma within fields in Python
  22. Accessing items in an collections.OrderedDict by index
  23. How do I make a dictionary with multiple keys to one value?
  24. Creating a new dictionary in Python
  25. Reading rows from a CSV file in Python
  26. How to check if a dictionary is empty?
  27. module ‘pandas’ has no attribute ‘read_csv
  28. Is the order of a Python dictionary guaranteed over iterations?
  29. Get data from Twitter using Tweepy and store in csv file
  30. How can I make a list of dictionaries according to the Cartesian product of values in a source dictionary (“explode” the dictionary)?

Leave a Comment