Why does csvwriter.writerow() put a comma after each character?

by

It expects a sequence (eg: a list or tuple) of strings. You’re giving it a single string. A string happens to be a sequence of strings too, but it’s a sequence of 1 character strings, which isn’t what you want.

If you just want one string per row you could do something like this:

csvwriter.writerow([JD])

This wraps JD (a string) with a list.

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. How can I convert JSON to CSV?
  4. Skip the headers when editing a csv file using Python
  5. How to add a new column to a CSV file?
  6. Skip rows during csv import pandas
  7. How to avoid Python/Pandas creating an index in a saved csv?
  8. datetime dtypes in pandas read_csv
  9. Python CSV error: line contains NULL byte
  10. How do I convert this list of dictionaries to a csv file?
  11. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  12. sort csv by column
  13. csv.Error: iterator should return strings, not bytes
  14. How to convert CSV file to multiline JSON?
  15. Compare two CSV files and search for similar items
  16. Pandas read csv file with float values results in weird rounding and decimal digits
  17. Is it possible to keep the column order using csv.DictReader?
  18. OSError: Initializing from file failed on csv in Pandas
  19. ValueError : I/O operation on closed file
  20. Writing to a particular cell using csv module in python
  21. Writing List of Strings to Excel CSV File in Python
  22. Load CSV file with PySpark
  23. Python UTF-16 CSV reader
  24. Read specific columns with pandas or other python module
  25. load csv into 2D matrix with numpy for plotting
  26. 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?)
  27. Pandas read_csv dtype read all columns but few as string
  28. csv: writer.writerows() splitting my string inputs
  29. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  30. How to convert csv to json in python?

Leave a Comment