Writing to CSV with Python adds blank lines [duplicate]

by

The way you use the csv module changed in Python 3 in several respects (docs), at least with respect to how you need to open the file. Anyway, something like

import csv
with open('test.csv', 'w', newline="") as fp:
    a = csv.writer(fp, delimiter=",")
    data = [['Me', 'You'],
            ['293', '219'],
            ['54', '13']]
    a.writerows(data)

should work.

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How to write a python code which copies a unique column from an output file to a .csv file
  3. Skip the headers when editing a csv file using Python
  4. How to add a new column to a CSV file?
  5. Skip rows during csv import pandas
  6. How to avoid Python/Pandas creating an index in a saved csv?
  7. datetime dtypes in pandas read_csv
  8. Python CSV error: line contains NULL byte
  9. How do I convert this list of dictionaries to a csv file?
  10. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  11. sort csv by column
  12. csv.Error: iterator should return strings, not bytes
  13. Compare two CSV files and search for similar items
  14. Pandas read csv file with float values results in weird rounding and decimal digits
  15. Why does csvwriter.writerow() put a comma after each character?
  16. How to delete columns in a CSV file?
  17. Precision lost while using read_csv in pandas
  18. Python Pandas: How to read only first n rows of CSV files in?
  19. Is it possible to keep the column order using csv.DictReader?
  20. OSError: Initializing from file failed on csv in Pandas
  21. ValueError : I/O operation on closed file
  22. Writing List of Strings to Excel CSV File in Python
  23. Load CSV file with PySpark
  24. Read specific columns with pandas or other python module
  25. Read .csv file from URL into Python 3.x – _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
  26. Read random lines from huge CSV file
  27. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  28. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  29. Printing subscript in python
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment