Convert string of list to python list [duplicate]

Question

I downloaded a csv table from a database using SQL. One of the fields has values like so:

'[0.1234,0.0,0.0]'

I want to convert this string to a python list to get the first value. I only know how to convert strings to ints and floats... is there any way to de-string this object? The table I got from SQL is from a web-based viewer, I'm not getting it from my command line.

Thomas Fenzl · Accepted Answer · 2014-06-27 16:06:26Z

1

You could take the substring from index 1 to index -1 and then split it using the comma as a delimiter. In python

array = variable[1:-1].split(',')

should work.

edited Jun 27, 2014 at 16:06

Thomas Fenzl

4,4221 gold badge19 silver badges25 bronze badges

answered Jun 27, 2014 at 15:45

RevanProdigalKnight

1,3261 gold badge14 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hoopdady · Accepted Answer · 2014-06-27 15:48:45Z

0

If you're sure it is always valid list syntax, you could use"

myList = eval('[0.1234,0.0,0.0]')

Or if the value itself has quotes ' in it, you can slice those off

value = "'[0.1234,0.0,0.0]'"
myList = eval(value[1:-1])

Then to get the first value you just

myList[0]

edited Jun 27, 2014 at 15:48

answered Jun 27, 2014 at 15:42

Hoopdady

2,3563 gold badges25 silver badges42 bronze badges

Collectives™ on Stack Overflow

Convert string of list to python list [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related