Json data selection

Question

I'm relatively new to this so please excuse me if I'm missing something very obvious :)

I'm trying to print code, and value of the attached Json file.

for example

for item in dataxchjs['data']:
    print(item)

works perfectly, and prints me AED as the first value

But

for item in dataxchjs['data']:
    print(item["code"], item["value"])

returns the error code

, line 47, in <module>
    print(item["code"], item["value"])
TypeError: string indices must be integers

What am I missing?

json file:

{
 "meta": {
  "last_updated_at": "2022-04-04T23:59:59Z"
 },
 "data": {
  "AED": {
   "code": "AED",
   "value": 3.67321
  },
  "AFN": {
   "code": "AFN",
   "value": 89.00134
  },
...
}

Thank you all very much

please don't dislike the post I really tried to understand the problem myself for a while now

Use for key, item in dataxchjs['data'].items() or for item in dataxchjs['data'].values() — Olvin Roght
– Olvin Roght, Commented Apr 5, 2022 at 12:14
data is a dict. when you iterate over dict, you iterate over dict keys. In your case - str AED, AFN, etc. — buran
– buran, Commented Apr 5, 2022 at 12:14

Lukas Schmid · Accepted Answer · 2022-04-05 12:16:57Z

2

The for ... in dictionary iterator will only iterate over the keys.

To get keys and their values (in this case AED,{"code": "AED", "value": 3.67321} and AEDAFNcode": "AFN", "value": 89.00134) use for key,value in yourdict.items()

answered Apr 5, 2022 at 12:16

Lukas Schmid

1,9561 gold badge8 silver badges19 bronze badges

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

Comments

eccentricOrange · Accepted Answer · 2022-04-05 12:54:23Z

0

In Python, a JSON file is usually converted to a dictionary.

Use the .items() method to extract the key and value variables while looping. Your current method gives you the keys (strings "AFN", "AED" etc) only.

for key, item in dataxchjs['data'].items():
    print(key, item["value"])

About second question.

Python has an in keyword. See if that does the job for you?

def find_in_data(key):
    return dataxchjs['data'][key] if key in dataxchjs['data'] else None

print(find_in_data('AED'))
print(find_in_data('XDR'))

edited Apr 5, 2022 at 12:54

answered Apr 5, 2022 at 12:19

eccentricOrange

1,27411 silver badges23 bronze badges

2 Comments

PetersServers Over a year ago

Does anyone know how I could find the corresponding value if i use the code to iterate throught the dictionary? my idea was 'code' def find_value(currency): for key, value in dataxchjs['data'].items(): return value if key == currency in dataxchjs['data'].items() else exit("not found")'

eccentricOrange Over a year ago

@PetersServers, this is technically a separate question, and it would be better if you searched online or made a separate post. However, since you're new here, I'll edit the solution into my current solution. Please make sure to accept the solution that works for you, as that helps people who search for this question in the future.

RomanG · Accepted Answer · 2022-04-05 16:42:32Z

is_dict = {
    "meta": {
        "last_updated_at": "2022-04-04T23:59:59Z"
    },
    "data": {
        "AED": {
            "code": "AED",
            "value": 3.67321
        },
        "AFN": {
            "code": "AFN",
            "value": 89.00134
        }
    }
}

### Like this:

for x in is_dict['data'].values():
    for key, value in x.items():
        if key == "code":
            print(value)
        elif key == "value":
            print(value)

### Or like this:

for x in is_dict['data'].values():
    print(x["code"])
    print(x["value"])

### Or this for errors:

data = is_dict.get('data')

if data:
    for x in data.values():
        print(x.get("code"))
        print(x.get("value"))

JSON package converts file to a python dictionary.
Navigate in dictionary through the loop with items(), values() and keys() methods of dictionary, or use indexes(keys) as dictionary["key"], or to exclude errors on not existing keys use get() method as dictionary.get("key").

Collectives™ on Stack Overflow

Json data selection

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related