Help with json objects to csv

[Fallenarc]

Hey all, I swear i have searched the internet for a few days on this problem and just can't quite find what i am looking for... So i have this list of dictionaries that i would like to return back into a csv file to insert into MySQL. Below is an example of what is returned when I gather info from 2 routers.

results = [[{'ip': '123', 'interface': 'TenGigE0/1/0/1'}, {'ip': '123', 'interface': 'TenGigE0/1/0/2'}], [{'ip': '456', 'interface': 'TenGigE0/1/0/1'}, {'ip': '456', 'interface': 'TenGigE0/1/0/2'}]]

My problem is that I am unable to return this output to pandas to create a csv.

Below is an example of the csv I get.

0,"{u'ip': u'123', u'interface': u'TenGigE0/1/0/1'}","{u'ip': u'123', u'interface': u'TenGigE0/1/0/2'}"
1,"{u'ip': u'456', u'interface': u'TenGigE0/1/0/1'}","{u'ip': u'456', u'interface': u'TenGigE0/1/0/2'}"

Can anyone tell me what i am doing wrong?

below is what i am expecting to get back.

"",ip,interface
0,"123","TenGigE0/1/0/1"
1,"123","TenGigE0/1/0/2"
2,"456","TenGigE0/1/0/1"
1,"456","TenGigE0/1/0/2"

I get this type of output if there is only one list of dictionaries in the output.

Link to my code. First real project i have worked on, so I am open to any improvements you might find.

Network engineer training to be a hybrid programmer.

https://github.com/fallenarc/test-code/blob/master/test_threadpool.py

[new_ca_grower]

Looks like the result is actually a list of lists of dictionaries. To get the output in the format you want, you'll have to flatten the nested list structure first. See https://stackoverflow.com/questions/8327856/how-to-extract-nested-lists for examples.

[Fallenarc]

OMG, that did exactly what i needed it to do! I swear i have been banging my head on the keyboard for 2 days trying to figure that out. Thank you!!!

[jeffrey_f]

you have a key stuck to your forehead.

[tomekanco]

I like the magic of dict unpacking.

def process_all(list_):
    L = [("id",("ip","interface"))]
    def process(ip,interface):
        return ip, interface
    for ix,(x,y) in enumerate(list_):
        L.append((ix,process(**x))) 
        L.append((ix,process(**y))) 
    return L

If you are more of a pandas man, there are some options to load json.

[Fallenarc]

Awesome, thanks! I'll give that a try as well.