Parsing Json (list within dictionaries) in Python

Question

I want to get sum of count Below is my json:

json_data={
"note":abbcccc,
"comments":
    [{"count":100,"name"=leven},{"count":120,"name"=sam}]
}

How do I get the sum of all counts (100+120)

I can get indivdual like this:

data=json.loads(json_data)
count=data["comments"][0]["count"]

But stuck on "How to loop though it"

phihag · Accepted Answer · 2015-12-10 05:05:35Z

4

count = sum(c["count"] for c in data["comments"])

answered Dec 10, 2015 at 3:17

phihag

289k75 gold badges475 silver badges489 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aneroid · Accepted Answer · 2015-12-10 03:16:31Z

2

Loop through each of the items in the comments list. Then pick "count" from each dict in that list. And add up.

data=json.loads(json_data)
total = 0
for each_counts in data["comments"]
    total += each_counts["count"]

This can be shortened to:

total = sum(each_count["count"] for each_count in data["comments"]

answered Dec 10, 2015 at 3:16

aneroid

16.7k3 gold badges42 silver badges77 bronze badges

Jim Reardon · Accepted Answer · 2015-12-10 03:18:36Z

1

You can loop through it like any list:

count = 0
for c in data['comments']:
  count += c['count']

answered Dec 10, 2015 at 3:18

Jim Reardon

261 bronze badge