初学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等试过,但是这种不规则的似乎不支持。因为键值对不规范。如何处理?
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)