How do I write data into CSV format as string (not file)?

by

In Python 3:

>>> import io
>>> import csv
>>> output = io.StringIO()
>>> csvdata = [1,2,'a','He said "what do you mean?"',"Whoa!\nNewlines!"]
>>> writer = csv.writer(output, quoting=csv.QUOTE_NONNUMERIC)
>>> writer.writerow(csvdata)
59
>>> output.getvalue()
'1,2,"a","He said ""what do you mean?""","Whoa!\nNewlines!"\r\n'

Some details need to be changed a bit for Python 2:

>>> output = io.BytesIO()
>>> writer = csv.writer(output)
>>> writer.writerow(csvdata)
57L
>>> output.getvalue()
'1,2,a,"He said ""what do you mean?""","Whoa!\nNewlines!"\r\n'

More Related Contents:

  1. Create Pandas DataFrame from a string
  2. How to write to a CSV line by line?
  3. Python csv string to array
  4. Filter string data based on its string length
  5. Pandas read_csv dtype leading zeros
  6. CSV reader behavior with None and empty string
  7. pandas – convert string into list of strings [duplicate]
  8. Split Strings into words with multiple word boundary delimiters
  9. Filter pandas DataFrame by substring criteria
  10. How to delete a character from a string using Python
  11. Python str vs unicode types
  12. n-grams in python, four, five, six grams?
  13. Python csv.reader: How do I return to the top of the file?
  14. How do I convert all strings in a list of lists to integers?
  15. TypeError: cannot concatenate ‘str’ and ‘int’ objects [duplicate]
  16. NLTK-based text processing with pandas
  17. How to do row-to-column transposition of data in csv table?
  18. Python 3.1.1 string to hex
  19. Python: Using vars() to assign a string to a variable
  20. Why can’t I end a raw string with a backslash? [duplicate]
  21. Why empty string is on every string? [duplicate]
  22. String exact match
  23. Get pandas.read_csv to read empty values as empty string instead of nan
  24. Is there a native templating system for plain text files in Python?
  25. Row count in a csv file
  26. Proper way to reset csv.reader for multiple iterations?
  27. Setting the fmt option in numpy.savetxt
  28. Adding backslashes without escaping [duplicate]
  29. What does “table” in the string.translate function mean?
  30. How to add a new column to the beginning of the rows of a CSV file?

Leave a Comment