JSON file modification with Python

Question

I'm trying to write a Python script to read data from a JSON file, do some calculations with it and then write output to a new JSON file. But I can't seem to automate the JSON reading process. I get this error. Could you please help me with this issue? Thank you very much

print([a[0]][b[1]][c[1]])
TypeError: list indices must be integers or slices, not str

test.json

{
      "male": {
            "jack": {
                  "id": "001",
                  "telephone": "+31 2225 345",
                  "address": "10 Street, Aukland",
                  "balance": "1500"
            },
            "john": {
                  "id": "002",
                  "telephone": "+31 6542 365",
                  "address": "Main street, Hanota",
                  "balance": "2500"
            }
      },

      "female": {
            "kay": {
                  "id": "00",
                  "telephone": "+31 6542 365",
                  "address": "Main street, Kiro",
                  "balance": "500"
            }
      }
}

test.py

with open("q.json") as datafile:
    data = json.load(datafile)

    a = ['male', 'female']
    b = ['jack', 'john', 'kay']
    c = ['id', 'telephone', 'address', 'balance']

    print([a[1]][b[1]][c[1]])

print(data[a[0]][b[1]][c[1]]) ? --> Note: keys are case sensitive — Rakesh
– Rakesh, Commented Mar 6, 2019 at 6:52
If you get json data via data = json.load(datafile), data will be dict type. So you can access male -> John -> telephone with data['Male']['John']['telephone']. — Ellisein
– Ellisein, Commented Mar 6, 2019 at 6:53

velis · Accepted Answer · 2019-03-06 06:54:11Z

1

If I understand you correctly, you really want to print data from the JSON, not your intermediary arrays.

So:

print(data['Male'])  # will print the entire Male subsection
print(data['Male']['Jack'])  # will print the entire Jack record
print(data['Male']['Jack']['telephone'])  # will print Jack's telephone

But to relate that with your intermediary arrays too:

print(data[a[0]])  # will print the entire Male subsection
print(data[a[0]][b[0]])  # will print the entire Jack record
print(data[a[0]][b[0]][c[0]])  # will print Jack's telephone

assuming that you declare a correctly:

a = ['Male', 'Female']  # Notice the capitals

answered Mar 6, 2019 at 6:54

velis

10.2k4 gold badges50 silver badges79 bronze badges

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

2 Comments

root Over a year ago

Thanks for your quick reply. I want to relate to arrays because that's how I intend to iterate through the array. Thanks so much :)

velis Over a year ago

You can also iterate through the dictionary: for key, value in data.items(). This will give you males first, then females. iterating again through the value would give you persons and iterating again each person's details

Tobias S · Accepted Answer · 2019-03-06 06:51:49Z

0

I dont know, how you access data in your code, because you directly write hard coded values into a, b and c. In addition, you could print out your test via: print(a[1], b[1], c[1]).

answered Mar 6, 2019 at 6:51

Tobias S

1,2758 silver badges23 bronze badges

Collectives™ on Stack Overflow

JSON file modification with Python

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related