I have a dictionary of stock data like below:
{'_id': ObjectId('5ed25b3a4893efeab4cef4b3'),
'time': 1286699400000.0,
'open': 1128.0,
'high': 1128.0,
'low': 1128.0,
'close': 1128.0,
'volume': 100}
And tried to convert it to a list/array of data with the following code, but it only works for 1 item of dictionary. I don't know how to iterate over dictionaries?
def dict_to_array(data):
training_set1 = []
training_set1.append(data["open"])
training_set1.append(data["high"])
training_set1.append(data["low"])
training_set1.append(data["close"])
training_set1.append(data["volume"])
training_set1 = np.array(training_set1).T
return training_set1
EDIT: I like to have training_set1
as the result like:
[[o1, h1, l1, c1, v1],
[o2, h2, l2, c2, v2],
...
[on, hn, ln, cn, vn]]
EDIT2: I added data = data.values()
to my code like below:
def dict_to_array(data):
data = data.values()
training_set1 = []
training_set1.append(data["open"])
training_set1.append(data["high"])
training_set1.append(data["low"])
training_set1.append(data["close"])
training_set1.append(data["volume"])
training_set1 = np.array(training_set1).T
return training_set1
But I get the following error:
TypeError: 'dict_values' object is not subscriptable