Python for loop iterate over dict pairs

Question

0.00/5 (No votes)

See more:

i have api call response as below,

x = response.json()

{'selectedColumns': [], 'totalRows': 2, 'pageNumber': 0, 'pageSize': 0, 'searchResults': 
{'items': [
{'id': '199', 'tiName': 'host-a', 'cmbMake': 'Cisco Systems', 'cmbModel': 'Catalyst C2960G-48TC-L', 'tiCustomField_CDP Neighbors': "[{'dest_host': ' AAA', 'sysname': ''}, {'dest_host': ' BBB', 'sysname': ''}]"}, 
{'id': '1504', 'tiName': 'host-b', 'cmbMake': 'Cisco Systems', 'cmbModel': 'Catalyst C2960-48TC-L', 'tiCustomField_CDP Neighbors': "[{'dest_host': ' CCC', 'sysname': ''}, {'dest_host': ' DDD', 'sysname': ''}]"}
]}}

What I have tried:

y = x['searchResults']['items']

keys = {"tiCustomField_CDP Neighbors","id"}
res = {}
l = []
for i in y:
    for k, v in i.items(): 
        if k in keys:
            sub = {k: v}
            res.update(sub)
            l.append(res)
out = l
print(out)

based on above code i am getting output as:

[{
    "id": "1504",
    "tiCustomField_CDP Neighbors": "[{'dest_host': ' CCC', 'sysname': ''}, {'dest_host': ' DDD', 'sysname': ''}]"
},
{
    "id": "1504",
    "tiCustomField_CDP Neighbors": "[{'dest_host': ' CCC', 'sysname': ''}, {'dest_host': ' DDD', 'sysname': ''}]"
}]

the way i wanted is:

[
    {
        "id": "199",
        "tiCustomField_CDP Neighbors": "[{'dest_host': ' AAA', 'sysname': ''}, {'dest_host': ' BBB', 'sysname': ''}]"
    },

    {
        "id": "1504",
        "tiCustomField_CDP Neighbors": "[{'dest_host': ' CCC', 'sysname': ''}, {'dest_host': ' DDD', 'sysname': ''}]"
    }
]

Please any one suggest the right way of for loop so that i get above output.

i am running python3. also i am new to python. still trying to learn it.apologies for any mistakes that i did.

Posted 28-Jan-22 11:58am

vr20222

Updated 28-Jan-22 13:52pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manuel L. Monge · Accepted Answer · 2022-01-28T13:52:00

Solution 1

vr20222,

It's much simpler that what you have produced...

Python

my_keys = {"id","tiCustomField_CDP Neighbors"}
res = {}
l = []

for i in y:
  res = {my_key:i[my_key] for my_key in my_keys}
  l.append(res)
  
print(l)

You'll note that I reversed the order of the 'my_keys' var. This way, the 'id' key is appended first.

Hope this helps!

Posted 28-Jan-22 13:52pm

Manuel L. Monge

Comments

vr20222 28-Jan-22 22:46pm

Thank you Manuel, your solution worked.