How can I organize my code according to output that I want?

Question

I have the code below.

import json
name = " "
username = " "
ip_address = " "
with open('data6.json', 'r') as myfile:
    data = json.load(myfile)
    for i in data:
        print(i[0].get('Manufacturer'))
        print(i[0].get('Name'))
        print(i[0].get('IPAddress'))

The output is the code like that:

VMware, Inc.
DC01
None
None
None
['192.168.1.240,fe80::350e:d28d:14a5:5cbb']
None
DC01
None

But i want an output like:

VMware, Inc.
DC01
['192.168.1.240,fe80::350e:d28d:14a5:5cbb']

How can i organize my code according to output that i want?

data6.json is like in the below:

[[{"Manufacturer": "VMware, Inc.", "Model": "VMware7,1", "Name": "DC01"}], [{"Index": "1", "IPAddress": ["192.168.1.240,fe80::350e:d28d:14a5:5cbb"]}], [{"Name": "DC01", "UserName": null}]]

Answer 1

If you load your initial json File you have: one list -> contains 3 one-element lists -> contains the dict

If you have more of these nestes Lists in files, I would recommend to flatten them If you want your data you have to access the correct one-element list, first index, then get the element in the one-element list, then choose the right value from the dict. Additionally you should close your file handler to close all resources before further working.

with open('data6.json', 'r') as myfile:
    data = json.load(myfile)

print(data[0][0]['Manufacturer'])
print(data[0][0]['Name'])
print(data[1][0]['IPAddress'])