JSON 和 pandas 配合下
- import JSON
- import pandas as pd
- JS='''
- {
- "message":"abc","result":{
- "paramtypeitems":[
- {"name":"基本参数","paramitems":[
- {"id":567,"name":"车型","valueitems":[
- {"specid":37017,"value":"xDrive40i M 运动套装"},
- {"specid":37018,"value":"xDrive40i 尊享型 M 运动套装"},
- {"specid":33307,"value":"xDrive28i"}]
- }]
- }]
- }
- }
- '''
- dj=JSON.loads(JS)
- d=dj['result']['paramtypeitems'][0]['paramitems'][0]['valueitems']
- df=pd.DataFrame(d)
- print(df)
来源: http://www.bubuko.com/infodetail-3385189.html