Get json object with value with python for loop

Question

When I use:

for reports in raw_data:
        for names in reports["names"]:
                report_name = json.dumps(names).strip('"')
                report_names.append(report_name)

I get the key/object name: 'report1', ...

When I use:

for reports in raw_data:
        for names in reports["names"].values():
                report_name = json.dumps(names).strip('"')
                report_names.append(report_name)

I get the value of the object: 'name1', ...

How do get the object and value together, for example: 'report1': 'name1', ...

The json:

[
  {
    "names": {
      "report1": "name1",
      "report2": "name2"
    }
  },
  {
    "names": {
      "report3": "name3",
      "report4": "name4"
    }
  }
]

RoadRunner · Accepted Answer · 2019-05-15 02:05:05Z

1

You need to loop over each dictionary in the object, then extract each key: value pair from items():

data = [
  {
    "names": {
      "report1": "name1",
      "report2": "name2"
    }
  },
  {
    "names": {
      "report3": "name3",
      "report4": "name4"
    }
  }
]

for d in data:
    for k, v in d["names"].items():
        print(k, v)

Result:

report1 name1
report2 name2
report3 name3
report4 name4

Or if you can just print out the tuple pairs:

for d in data:
    for pair in d["names"].items():
        print(pair)

# ('report1', 'name1')
# ('report2', 'name2')
# ('report3', 'name3')
# ('report4', 'name4')

If you want all of the pairs in a list, use a list comprehension:

[pair for d in data for pair in d["names"].items()]
# [('report1', 'name1'), ('report2', 'name2'), ('report3', 'name3'), ('report4', 'name4')]

edited May 15, 2019 at 2:05

answered May 15, 2019 at 1:58

RoadRunner

26.4k6 gold badges46 silver badges77 bronze badges

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

Comments

EcSync · Accepted Answer · 2019-05-15 08:52:47Z

0

Try something like this:

import json
with open(r'jsonfile.json', 'r') as f:
        qe = json.load(f)
        for item in qe:
            if item == 'name1': 
                print(qe)

answered May 15, 2019 at 8:52

EcSync

8622 gold badges7 silver badges22 bronze badges

Collectives™ on Stack Overflow

Get json object with value with python for loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related