在angularjs控制器中将大熊猫json转换成高库存数据格式

Question

我正在绞尽脑汁地思考如何将json转换为系列图表的高库存数组格式。

在我的代码中，我执行以下操作：

df2.reset_index().to_json(orient='records')

其结果(例如)：

[{"date":1456185600000,"adj_close":94.69},
{"date":1456099200000,"adj_close":96.88},
{"date":1455840000000,"adj_close":96.04},
{"date":1455753600000,"adj_close":96.26}]

然后，我在angularjs控制器上得到json作为一个对象数组，我不知道如何将它转换为highstock格式，例如：

 [
 [1456185600000, 94.69],
 [1456099200000, 96.88],
 [1455840000000, 96.04],
 [1455753600000, 96.26],
 ]

我该怎么做才能使这一转变？

Answer 1

d = [{"date":1456185600000,"adj_close":94.69},
{"date":1456099200000,"adj_close":96.88},
{"date":1455840000000,"adj_close":96.04},
{"date":1455753600000,"adj_close":96.26}]

然后是这样的一个列表理解

[[di['date'], di['adj_close']] for di in d]

提供所需的输出：

[[1456185600000, 94.69],
 [1456099200000, 96.88],
 [1455840000000, 96.04],
 [1455753600000, 96.26]]

Answer 2

您可以使用Array.map()方法重新格式化对象：

Objects/Array/map

​

var objectArray = [
  {"date":1456185600000,"adj_close":94.69},
  {"date":1456099200000,"adj_close":96.88},
  {"date":1455840000000,"adj_close":96.04},
  {"date":1455753600000,"adj_close":96.26}]

var highStockSeries = objectArray.map(function(object){
  return [object.date, object.adj_close]
})

console.log(highStockSeries)

 <div id="result">look in the JS console for your array</div>

​