Python Forum
reading a line of a CSV - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/Forum-Python-Coding)
+--- Forum: General Coding Help (https://python-forum.io/Forum-General-Coding-Help)
+--- Thread: reading a line of a CSV (/Thread-reading-a-line-of-a-CSV)



reading a line of a CSV - Skaperen - Feb-10-2019

my .csv file could have numbers or quoted strings between the commas. this seems to be the same syntax as that found in a Python literal for a list. so what if i read in a line, .strip() it, prepend '[' to the front, append ']' to the end, and run that through exec() and verify that what is returned is a single simple list with just numbers and strings in it?


RE: reading a line of a CSV - buran - Feb-10-2019

I would definitely use csv module, but if you insist on your approach, at least use ast.literal_eval()
>>>import ast
>>> line = '[1, "some text, with comma", "1,000.5"]'
>>> ast.literal_eval(line)
[1, 'some text, with comma', '1,000.5']



RE: reading a line of a CSV - Skaperen - Feb-10-2019

it looks like ast.literal_eval() is the way to go.