how can I convert the string to array?

Question

I would like to convert the long-string to an array to access detail inside. In my case, the string is like below

'[{"timestamp": 1567814400033, "fair_value": 0.01641267}, {"timestamp": 1567814400141, "fair_value": 0.01641273}]'

Desired result would be single array where contain dicts inside like this

[{"timestamp": 1567814400033, "fair_value": 0.01641267}, {"timestamp": 1567814400141, "fair_value": 0.01641273}]

Thank for your help!

Answer 1

Use the python json library. You can use it to parse your strings to json and also stringfy your dictionary or arrays.

import json

# Convert string to python object
data = json.loads(<JSON_STRING>)

# Stringfy python dictionary or array
string_data = json.dumps(<PYTHON_OBJECT>)

Answer 2

You would be needing to import literal_eval from ast module of python, it is a standard package installed in python which stands for Abstract Syntax Trees, more info here : https://docs.python.org/2/library/ast.html

Your code will look something like this:

from ast import literal_eval
your_variable = literal_eval('[{"timestamp": 1567814400033, "fair_value": 0.01641267}, {"timestamp": 1567814400141, "fair_value": 0.01641273}]')

I hope this helps!

Answer 3

Try this:

import json

array = '[{"timestamp": 1567814400033, "fair_value": 0.01641267}, 
         {"timestamp": 1567814400141, "fair_value": 0.01641273}]'
data  = json.loads(array)
print (data)

Output:

Answer 4

I have solve this case by myself by using ast.literal_eval() lib