CSV file written with Python has blank lines between each row

by

In Python 2, open outfile with mode 'wb' instead of 'w'. The csv.writer writes \r\n into the file directly. If you don’t open the file in binary mode, it will write \r\r\n because on Windows text mode will translate each \n into \r\n.

In Python 3 the required syntax changed and the csv module now works with text mode 'w', but also needs the newline="" (empty string) parameter to suppress Windows line translation (see documentation links below).

Examples:

# Python 2
with open('/pythonwork/thefile_subset11.csv', 'wb') as outfile:
    writer = csv.writer(outfile)

# Python 3
with open('/pythonwork/thefile_subset11.csv', 'w', newline="") as outfile:
    writer = csv.writer(outfile)

Documentation Links

More Related Contents:

  1. CSV in Python adding an extra carriage return, on Windows
  2. Python 2 CSV writer produces wrong line terminator on Windows
  3. portable way to write csv file in python 2 or python 3
  4. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x96 in position 35: invalid start byte
  5. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  6. Python3: writing csv files
  7. Python import csv to list
  8. Python – PIP install trouble shooting – PermissionError: [WinError 5] Access is denied
  9. How to write to a CSV line by line?
  10. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  11. List running processes on 64-bit Windows
  12. Python out of memory on large CSV file (numpy)
  13. Writing a dictionary to a csv file with one line for every ‘key: value’
  14. Python – Windows Shutdown Events
  15. How can I hide the console window in a PyQt app running on Windows?
  16. How do I write data into CSV format as string (not file)?
  17. Is Tensorflow compatible with a Windows workflow?
  18. How to write UTF-8 in a CSV file
  19. How do you have shared log files under Windows?
  20. Using numpy.genfromtxt to read a csv file with strings containing commas
  21. How to transpose a dataset in a csv file?
  22. Python Script does not take sys.argv in Windows
  23. MSSQL2008 – Pyodbc – Previous SQL was not a query
  24. How to configure Python Kivy for PyCharm on Windows?
  25. Processes stuck in loop with PyInstaller-executable
  26. How to read a CSV file from a URL with Python?
  27. Can you upload to S3 using a stream rather than a local file?
  28. Convert percent string to float in pandas read_csv
  29. Easiest way to read csv files with multiprocessing in Pandas
  30. build a .exe for Windows from a python 3 script

Leave a Comment