How to access element in json using python?

Question

I need help on how do I use python to access element from JSON structure.

Assuming I have a JSON like this

{
'result':
  [
    {
     'aa':1, 
     'bb':2
    },
    {
     'cc':3, 
     'dd':4
    }
  ]
 }

In python, how exactly to get the data for aa or dd ? I tried with

str1 = {'result':[{'aa':1, 'bb':2},{'cc':3, 'dd':4}]}
str1new = str1['result']['aa]

but it gives me error

list indices must be integers, not str

How do I solve this? Is there any other method using python to get the data from JSON? Thank you for the help. I really appreciated it.

kemis · Accepted Answer · 2017-07-11 08:37:43Z

6

Try this and for the next ones use indexes like 1 or 2 if you have more, or you can loop if you have multiple indexes within the json.

str1new = str1['result'][0]['aa']

edited Jul 11, 2017 at 8:37

kemis

4,7026 gold badges29 silver badges40 bronze badges

answered Jul 11, 2017 at 8:32

Exprator

27.8k6 gold badges54 silver badges64 bronze badges

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

3 Comments

Ling Over a year ago

there is a typo there but never mind. can you explain the index [0] there? what does it means?

Exprator Over a year ago

well the 0 is for the index as you do in list or dictionary , you can see the starting [] which means its a index start

Rahul Over a year ago

@Exprator well the 0 is for the index as you do in list or dictionary? Dictionary is not indexed.

Rahul · Accepted Answer · 2017-07-11 08:37:59Z

2

In python if you write:

str1 = {'result':[{'aa':1, 'bb':2},{'cc':3, 'dd':4}]}

it's dictionary and not json.

if your input is having json string you need to use

import json

json_str = """{
"result":
  [
    {
     "aa":1, 
     "bb":2
    },
    {
     "cc":3, 
     "dd":4
    }
  ]
 }"""
str1 = json.loads(json_str)

then you can use similar to python dictionary.

as answered by others you can then use

aa = str1['result'][0]['aa']

answered Jul 11, 2017 at 8:37

Rahul

11.7k5 gold badges63 silver badges100 bronze badges

Comments

Arpit Solanki · Accepted Answer · 2017-07-11 08:31:55Z

1

try

str1new = str1['result'][0]['aa]

answered Jul 11, 2017 at 8:31

Arpit Solanki

10k4 gold badges45 silver badges57 bronze badges

Comments

pramod · Accepted Answer · 2017-07-11 08:34:02Z

1

As str1['result'] is a list, that's why you're getting list indices must be integers, not str error.

aa = str1['result'][0]['aa']
dd = str1['result'][1]['dd']

answered Jul 11, 2017 at 8:34

pramod

1,5231 gold badge14 silver badges17 bronze badges

1 Comment

Ling Over a year ago

thank you. now I understand why it needs [0] or [1]in the answer based on your and others answer

K. Kirsz · Accepted Answer · 2017-07-11 08:34:49Z

1

result is a list, so you need to reference a valid index before accessing aa:

str1 = {'result':[{'aa':1, 'bb':2},{'cc':3, 'dd':4}]}
str1new = str1['result'][0]['aa']

answered Jul 11, 2017 at 8:34

K. Kirsz

1,42011 silver badges12 bronze badges

Comments

Thomas Dussaut · Accepted Answer · 2017-07-11 08:36:09Z

1

In Python, unless you're using a package (then specify it), "JSON" structure are actually dicts.

{
'result':
  [
    {
     'aa':1, 
     'bb':2
    },
    {
     'cc':3, 
     'dd':4
    }
  ]
 }

Here, your dict has only one key : result. Its values are contained in a list. This list is a list of dicts. So use cascade index access to get your aa value :

str1['result'][0]['aa']

answered Jul 11, 2017 at 8:36

Thomas Dussaut

7551 gold badge7 silver badges21 bronze badges

Comments

benhorgen · Accepted Answer · 2020-07-31 17:19:30Z

0

For Python3, using the Json library you can easily parse Json.

# import statement
import json

# using example sting from above
jsonString = '{ "result" : [{ "aa": 1,"bb": 2 }, { "cc": 3, "dd": 4 }]}'

# parse json string
parsedJsonObject = json.loads(jsonString)

# access a specific property in the json object 
resultObject = parsedJsonObject['result']

answered Jul 31, 2020 at 17:19

benhorgen

2,0072 gold badges37 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to access element in json using python?

7 Answers 7

3 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

3 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related