问题描述
我的JSON看起来像这样:
[
{
1332879360000.0:300,
1332797760000.0:353,
1332799320000.0:358,
1332879780000.0:302,
1332800160000.0:359,
1332880200000.0:299,
1332880620000.0:298,
1332881040000.0:301,
1332881460000.0:402,
1332880020000.0:330,
1332882300000.0:466,
1332796620000.0:519,
1332800520000.0:447,
1332797460000.0:359,
1332801000000.0:442
}
]
我想在Highchart中加载这些数据,但它需要另一种格式:
[
[
1332879360000,
300
],
[
1332797760000,
353
],
[
1332799320000,
358
],
[
1332879780000,
302
]
]
数据生成数据库不是像text.json这样的单个文件,而是直接生成的。
json1 = [{1332879360000.0:300.0,1332797760000.0:353.0,1332799320000.0:358.0,1332879780000.0:302.0,1332800160000.0:359.0,1332880200000.0:299.0,1332880620000.0:298.0,1332881040000.0 301.0,1332881460000.0:402.0,1332880020000.0:330.0,1332882300000.0:466.0,1332796620000.0:519.0,1332800520000.0:447.0,1332797460000.0:359.0,1332801000000.0:442.0}];
$ b $ hc = []
for(key in json1 [0])
{
hc.push([key,json1 [0] [ key]])
}
json2 = JSON.stringify(hc)
json2现在包含您想要的数据=>
My JSON looks like this:
[
{
"1332879360000.0": 300,
"1332797760000.0": 353,
"1332799320000.0": 358,
"1332879780000.0": 302,
"1332800160000.0": 359,
"1332880200000.0": 299,
"1332880620000.0": 298,
"1332881040000.0": 301,
"1332881460000.0": 402,
"1332880020000.0": 330,
"1332882300000.0": 466,
"1332796620000.0": 519,
"1332800520000.0": 447,
"1332797460000.0": 359,
"1332801000000.0": 442
}
]
And I want to load those data in Highchart but it needs another format:
[
[
1332879360000,
300
],
[
1332797760000,
353
],
[
1332799320000,
358
],
[
1332879780000,
302
]
]
The data is generated by database not in a single file like text.json but it directly generated.
json1 = [{"1332879360000.0": 300.0, "1332797760000.0": 353.0, "1332799320000.0": 358.0, "1332879780000.0": 302.0, "1332800160000.0": 359.0, "1332880200000.0": 299.0, "1332880620000.0": 298.0, "1332881040000.0": 301.0, "1332881460000.0": 402.0, "1332880020000.0": 330.0, "1332882300000.0": 466.0, "1332796620000.0": 519.0, "1332800520000.0": 447.0, "1332797460000.0": 359.0, "1332801000000.0": 442.0}];
hc = []
for(key in json1[0])
{
hc.push([key,json1[0][key]])
}
json2 = JSON.stringify(hc)
json2 now contains your data the way you want it =)
这篇关于如何更改JSON格式用于将数据加载到Highchart的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!