Get fields from a JSON file with Python

Question

I have this json file loaded in Python with json.loads('myfile.json'):

    [
    {
        "cart": {
            "items": {
                "3154ba405e5c5a22bbdf9bf1": {
                    "item": {
                        "_id": "3154ba405e5c5a22bbdf9bf1",
                        "title": "Drink alla cannella",
                        "price": 5.65,
                        "__v": 0
                    },
                    "qty": 1,
                    "price": 5.65
                }
            },
            "totalQty": 1,
            "totalPrice": 5.65
        }
    },
    {
        "cart": {
            "items": {
                "6214ba405e4c5a31bbdf9ad7": {
                    "item": {
                        "_id": "6214ba405e4c5a31bbdf9ad7",
                        "title": "Drink alla menta",
                        "price": 5.65,
                        "__v": 0
                    },
                    "qty": 2,
                    "price": 11.3
                }
            },
            "totalQty": 2,
            "totalPrice": 11.3
        }
    }
]

How I can access to both totalQty and totalPrice fields at same time and sum them?

How I can access to both Title fields to print it?

sum(dct["cart"]["totalQty"] for dct in my_json) and sum(dct["cart"]["totalPrice"] for dct in my_json)? — Axe319
– Axe319, Commented Feb 25, 2022 at 14:40
Thanks a lot Axe, I have added one more question, How i can access to Title field? — BearGrillz
– BearGrillz, Commented Feb 25, 2022 at 14:45

jackal · Accepted Answer · 2022-02-25 15:48:27Z

2

Let's assume that you have the JSON data available as a string then:

jdata = '''
[
    {
        "cart": {
            "items": {
                "3154ba405e5c5a22bbdf9bf1": {
                    "item": {
                        "_id": "3154ba405e5c5a22bbdf9bf1",
                        "title": "Drink alla cannella",
                        "price": 5.65,
                        "__v": 0
                    },
                    "qty": 1,
                    "price": 5.65
                }
            },
            "totalQty": 1,
            "totalPrice": 5.65
        }
    },
    {
        "cart": {
            "items": {
                "6214ba405e4c5a31bbdf9ad7": {
                    "item": {
                        "_id": "6214ba405e4c5a31bbdf9ad7",
                        "title": "Drink alla menta",
                        "price": 5.65,
                        "__v": 0
                    },
                    "qty": 2,
                    "price": 11.3
                }
            },
            "totalQty": 2,
            "totalPrice": 11.3
        }
    }
]
'''
totalQty = 0
totalPrice = 0
for d in json.loads(jdata):
    c = d['cart']
    totalQty += c['totalQty']
    totalPrice += c['totalPrice']
    for sd in c['items'].values():
        print(sd['item']['title'])
print(f'{totalQty:d}', f'{totalPrice:.2f}')

Output:

3 16.95

Note:

I suspect that what you really want to do is multiply those two values

edited Feb 25, 2022 at 15:48

answered Feb 25, 2022 at 14:46

jackal

29.1k3 gold badges9 silver badges27 bronze badges

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

4 Comments

BearGrillz Over a year ago

Thanks for the help, I need to sum the two totalQty and the two TotalPrice, but it is the same. But if I want to access to Title fields??

jackal Over a year ago

@Alessio That's clearer regarding the summation. I'll edit the code

BearGrillz Over a year ago

Thanks alot and there is a way to access into Title fields with the same json??

jackal Over a year ago

@Alessio I have added that to the answer

Collectives™ on Stack Overflow

Get fields from a JSON file with Python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related