Python Json搜索值并汇总

2024-10-03 21:31:01 发布

您现在位置:Python中文网/ 问答频道 /正文

假设我有类似的json

{ 
   "name":"Land cruiser, Toyota "
   "rate":"98"
 },

 {
   "name":"Triton, Mitsubishi"
   "rate":"96"
 },
 {
    "name":"l200, Mitsubishi"
    "rate":"98"
 },
 {
    "name":"Hiace, Toyota"
    "rate":"98"
 }

我只想搜索丰田的名字,并总结所有的价格

例如:

#load json here
def getSum(lastname):
     #search and sum calulation
      return resutl
getSum('Toyota')

Tags: namejsonhererateload价格名字triton
1条回答
网友
1楼 · 发布于 2024-10-03 21:31:01

假设您的json是一个对象列表,您已经读入变量l

def get_manufacturer_sum(l, manufacturer):
    return sum([int(d["rate"]) for d in l if manufacturer in d["name"]])


toyota_sum = get_manufacturer_sum(l, "Toyota")

相关问题 更多 >