Python csv string to array

by

You can convert a string to a file object using io.StringIO and then pass that to the csv module:

from io import StringIO
import csv

scsv = """text,with,Polish,non-Latin,letters
1,2,3,4,5,6
a,b,c,d,e,f
gęś,zółty,wąż,idzie,wąską,dróżką,
"""

f = StringIO(scsv)
reader = csv.reader(f, delimiter=",")
for row in reader:
    print('\t'.join(row))

simpler version with split() on newlines:

reader = csv.reader(scsv.split('\n'), delimiter=",")
for row in reader:
    print('\t'.join(row))

Or you can simply split() this string into lines using \n as separator, and then split() each line into values, but this way you must be aware of quoting, so using csv module is preferred.

On Python 2 you have to import StringIO as

from StringIO import StringIO

instead.

More Related Contents:

  1. create a loop inside a loop in python
  2. Check if multiple strings exist in another string
  3. Create Pandas DataFrame from a string
  4. Dump a NumPy array into a csv file
  5. How to split a string of space separated numbers into integers?
  6. How to convert a string of bytes into an int?
  7. How to write to a CSV line by line?
  8. How do I write data into CSV format as string (not file)?
  9. How to create a numpy array of arbitrary length strings?
  10. Filter string data based on its string length
  11. How to parse a string and return a nested array?
  12. Element-wise string concatenation in numpy
  13. load csv into 2D matrix with numpy for plotting
  14. Pandas read_csv dtype leading zeros
  15. Byte Array to Hex String
  16. How can I interleave or create unique permutations of two strings (without recursion)
  17. Setting the fmt option in numpy.savetxt
  18. CSV reader behavior with None and empty string
  19. How can I slice each element of a numpy array of strings?
  20. Fast string array – Cython
  21. pandas – convert string into list of strings [duplicate]
  22. Pythonic way to create a long multi-line string
  23. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  24. How can I reorder a list? [closed]
  25. How to detect lowercase letters in Python?
  26. How to apply __str__ function when printing a list of objects in Python [duplicate]
  27. How to “scale” a numpy array?
  28. Python – re-ordering columns in a csv
  29. Why are str.count(”) and len(str) giving different outputs when used on an empty string?
  30. How to upload a CSV file in FastAPI and convert it into JSON?

Leave a Comment