Python csv string to array

Question

Anyone know of a simple library or function to parse a csv encoded string and turn it into an array or dictionary   I don t think I want the built in csv module because in all the examples I ve seen that takes filepaths  not strings

User · Answer

Simple - the csv module works with lists  too    gt  gt  gt  a   1 2 3   4 5 6      or a    1 2 3 n4 5 6  split   n    gt  gt  gt  import csv  gt  gt  gt  x   csv reader a   gt  gt  gt  list x     1    2    3      4    5    6

User · Answer

gt  gt  gt  a    1 2   gt  gt  gt  a  1 2   gt  gt  gt  b   a split       gt  gt  gt  b   1    2     To parse a CSV file   f   open file csv   r   lines   f read   split   n       r n  if needed  for line in lines      if line          add other needed checks to skip titles         cols   line split              print cols

User · Answer

Use this to have a csv loaded into a list  import csv  csvfile   open myfile   r   reader   csv reader csvfile  delimiter   t   my list   list reader  print my list  gt  gt  gt    1st line    0          2nd line    0

User · Answer

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 ges z  lty waz idzie waska dr  zka       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

User · Answer

The official doc for csv reader   https   docs python org 2 library csv html  is very helpful  which says      file objects and list objects are both suitable   import csv  text      1 2 3 a b c d e f     lines   text splitlines   reader   csv reader lines  delimiter      for row in reader      print   t  join row

User · Answer

Here s an alternative solution    gt  gt  gt  import pyexcel as pe  gt  gt  gt  text    1 2 3     a b c     d e f     gt  gt  gt  s   pe load from memory  csv   text   gt  gt  gt  s Sheet Name  csv  --- --- ---    1   2   3    --- --- ---    a   b   c    --- --- ---    d   e   f    --- --- ---   gt  gt  gt  s to array     u 1   u 2   u 3     u a   u b   u c     u d   u e   u f      Here s the documentation

User · Answer

Per the documentation      And while the module doesn   t directly support parsing strings  it can easily be done    import csv for row in csv reader   one two three         print row   Just turn your string into a single element list   Importing StringIO seems a bit excessive to me when this example is explicitly in the docs

User · Answer

https   docs python org 2 library csv html highlight csv csv reader     csvfile can be any object which supports the iterator protocol and returns a string each time its next   method is called   Thus  a StringIO StringIO    str splitlines   or even a generator are all good

User · Answer

Panda is quite powerful and smart library reading CSV in Python  A simple example here  I have example zip file with four files in it   EXAMPLE zip  -- example1 csv  -- example1 txt  -- example2 csv  -- example2 txt     from zipfile import ZipFile import pandas as pd   filepath    EXAMPLE zip  file prefix   filepath  -4  lower    zipfile   ZipFile filepath  target file      join  file prefix       file prefix  1     csv     df   pd read csv zipfile open target file    print df head      print first five row of csv print df COL NAME     fetch the col name data   Once you have data you can manipulate to play with a list or other formats

User · Answer

As others have already pointed out  Python includes a module to read and write CSV files  It works pretty well as long as the input characters stay within ASCII limits  In case you want to process other encodings  more work is needed   The Python documentation for the csv module implements an extension of csv reader  which uses the same interface but can handle other encodings and returns unicode strings  Just copy and paste the code from the documentation  After that  you can process a CSV file like this   with open  some csv    rb   as csvFile       for row in UnicodeReader csvFile  encoding  iso-8859-15            print row

[python] Python csv string to array

Examples related to python

Examples related to string

Examples related to arrays

Examples related to csv