如何用json来分割

采集新浪股票的数据
http://vip.stock.finance.sina.com.cn/quotes_service/api/json_v2.php/Market_Center.getHQNodeData?page=1&num=10&sort=changepercent&asc=0&node=sz_a&symbol=

结果是
[{symbol:"sz002632",code:"002632",name:"道明光学",trade:"11.830",pricechange:"1.080",changepercent:"10.047",buy:"11.830",sell:"0.000",settlement:"10.750",open:"11.050",high:"11.830",low:"11.050",volume:"5738784",amount:"67506360",ticktime:"10:17:24",per:31.973,pb:1.827,mktcap:164047.793,nmc:59632.0725,turnoverratio:11.38478},{symbol:"sz300076",code:"300076",name:"GQY视讯",trade:"22.080",pricechange:"2.010",changepercent:"10.015",buy:"22.080",sell:"0.000",settlement:"20.070",open:"19.760",high:"22.080",low:"19.750",volume:"2770681",amount:"59061084",ticktime:"10:17:24",per:71.226,pb:2.186,mktcap:234048,nmc:179340.964704,turnoverratio:3.41119},{symbol:"sz002577",code:"002577",name:"雷柏科技",trade:"12.420",pricechange:"1.130",changepercent:"10.009",buy:"12.420",sell:"0.000",settlement:"11.290",open:"12.420",high:"12.420",low:"12.420",volume:"172540",amount:"2142947",ticktime:"10:17:24",per:36.529,pb:2.512,mktcap:351336.96,nmc:87834.24,turnoverratio:0.24398},{symbol:"sz002240",code:"002240",name:"威华股份",trade:"8.470",pricechange:"0.770",changepercent:"10.000",buy:"8.470",sell:"0.000",settlement:"7.700",open:"8.470",high:"8.470",low:"8.470",volume:"2524799",amount:"21385048",ticktime:"10:17:24",per:-35.292,pb:2.659,mktcap:415626.288,nmc:249231.314409,turnoverratio:0.85804},{symbol:"sz300269",code:"300269",name:"联建光电",trade:"18.950",pricechange:"1.720",changepercent:"9.983",buy:"18.950",sell:"0.000",settlement:"17.230",open:"18.880",high:"18.950",low:"18.010",volume:"3610133",amount:"67796368",ticktime:"10:17:24",per:51.216,pb:3.884,mktcap:223094.56,nmc:110361.246875,turnoverratio:6.19892},{symbol:"sz300006",code:"300006",name:"莱美药业",trade:"26.830",pricechange:"1.990",changepercent:"8.011",buy:"26.830",sell:"26.880",settlement:"24.840",open:"25.000",high:"27.320",low:"24.850",volume:"2288823",amount:"60361640",ticktime:"10:17:24",per:92.517,pb:5.009,mktcap:541412.650031,nmc:312658.717799,turnoverratio:1.96409},{symbol:"sz002174",code:"002174",name:"梅花伞",trade:"48.900",pricechange:"3.360",changepercent:"7.378",buy:"48.890",sell:"48.900",settlement:"45.540",open:"45.750",high:"49.000",low:"45.700",volume:"1338748",amount:"63857448",ticktime:"10:17:24",per:828.814,pb:18.276,mktcap:405576.21369,nmc:405576.21369,turnoverratio:1.61412},{symbol:"sz300236",code:"300236",name:"上海新阳",trade:"40.500",pricechange:"2.620",changepercent:"6.917",buy:"40.500",sell:"40.590",settlement:"37.880",open:"37.570",high:"40.970",low:"37.210",volume:"1101917",amount:"43087972",ticktime:"10:17:24",per:86.17,pb:5.961,mktcap:460890,nmc:87075,turnoverratio:5.1252},{symbol:"sz002634",code:"002634",name:"棒杰股份",trade:"15.220",pricechange:"0.960",changepercent:"6.732",buy:"15.210",sell:"15.220",settlement:"14.260",open:"15.670",high:"15.690",low:"14.950",volume:"6943193",amount:"107920056",ticktime:"10:17:24",per:38.05,pb:3.116,mktcap:152276.1,nmc:53901.63,turnoverratio:19.60523},{symbol:"sz300276",code:"300276",name:"三丰智能",trade:"14.280",pricechange:"0.810",changepercent:"6.013",buy:"14.280",sell:"14.310",settlement:"13.470",open:"13.370",high:"14.360",low:"13.100",volume:"8006739",amount:"109766856",ticktime:"10:17:24",per:24.621,pb:3.283,mktcap:178214.4,nmc:65093.303688,turnoverratio:17.56498}]
如何用json先生成列表然后列表项再变成字典或json数据？

Volume

turnoverratio

trade

9 条回复 • 1970-01-01 08:00:00 +08:00

mengzhuo

2013-12-20 11:51:15 +08:00

我竟然看成了……如何用json先生/成列表/然后列表项再变成字典或json数据？

这本身就是个js可读的列表，列表里是object，不明白LZ要干什么

justfly

2013-12-20 12:08:40 +08:00

import json
data_list=json.loads("xxxxx")
for data_item_dict in data_list:
# do something

pc10201

2013-12-20 12:18:12 +08:00

@justfly

#coding=utf-8
import json
import requests

r=requests.get('http://vip.stock.finance.sina.com.cn/quotes_service/api/json_v2.php/Market_Center.getHQNodeData?page=1&num=10&sort=changepercent&asc=0&node=sz_a&symbol=')
print r.text
data_list=json.loads(r.text)
for data_item_dict in data_list:
print data_item_dict

不行啊，代码报错
Traceback (most recent call last):
File "D:/python_project/myself/��˹�Ʊ/test.py", line 8, in <module>
data_list=json.loads(r.text)
File "D:\Python27\lib\json\__init__.py", line 338, in loads
return _default_decoder.decode(s)
File "D:\Python27\lib\json\decoder.py", line 365, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "D:\Python27\lib\json\decoder.py", line 381, in raw_decode
obj, end = self.scan_once(s, idx)
ValueError: Expecting property name enclosed in double quotes: line 1 column 3 (char 2)