python3 如何遍历以下json数据

Question

数据如下

{    "message":"abc","result":{            "paramtypeitems":[
                {"name":"基本参数","paramitems":[
                    {"id":567,"name":"车型","valueitems":[
                        {"specid":37017,"value":"xDrive40i M运动套装"},
                        {"specid":37018,"value":"xDrive40i 尊享型 M运动套装"},
                        {"specid":33307,"value":"xDrive28i"}]
                    }]
                }]
            }
        }

Answer 1

json和pandas配合下import jsonimport 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)