python处理不规则的json数据

Question

python3解析不规则的json格式

初学python，请教json数据处理。

现有的数据

{
    "招牌菜": [{
        "草鸡": "(1份)¥50"
    }, {
        "土豆丝": "(1份)¥20"
    }, {
        "稀饭": "(2份)¥10"
    }, {
        "米饭": "(2份)¥1"
    }, {
        "餐巾纸": "(1份)¥2"
    }]
}

期望的数据

{
    "招牌菜": [{
        "name": "草鸡",
        "count": "1份",
        "price": "¥50"
    }, {
        "name": "土豆丝",
        "count": "1份",
        "price": "¥20"
    }, {
        "name": "稀饭",
        "count": "2份",
        "price": "¥10"
    }, {
        "name": "餐巾纸",
        "count": "1份",
        "price": "¥2"
    }]
}

尝试过的方法

怎么利用python，将“现有的数据”处理为“期望的数据”？

我利用jsonpath等试过，但是这种不规则的似乎不支持。因为键值对不规范。如何处理？

Answer 1

result = {}

data = {
    "招牌菜": [{
        "草鸡": "(1份)¥50"
    }, {
        "土豆丝": "(1份)¥20"
    }, {
        "稀饭": "(2份)¥10"
    }, {
        "米饭": "(2份)¥1"
    }, {
        "餐巾纸": "(1份)¥2"
    }]
}


for key,item in data.items():
    result[key] = []
    for info in item:
        for k,v in info.items():
            name = k
            count = v.split(')')[0].replace('(','')
            price = v.split(')')[1]
            result[key].append({
                'name':name,
                'count':count,
                'price':price
            })

print(result)