Extracting an array that contains Json fields in Python

Question

I would like to extract make an array that contains a specific field. Looping in the object of "d" and store all the fields of "data2". In this case we will have Array_ = ["Title col1","Title col2","Title col3" ]

d = {
    "row1": {
      "data1": "0.87", 
      "data2": "Title col1", 
      "data3": "14.4878", 
      "data4": "Title row1"
    }, 
    "row2": {
      "data1": "15352.3", 
      "data2": "Title col2", 
      "data3": "14.9561", 
      "data4": "Title row2"
    }, 
    "row3": {
      "data1": "0", 
      "data2": "Title col3", 
      "data3": "16.8293", 
      "data4": "Title row3"
    }
  }
}

thefourtheye · Accepted Answer · 2013-11-27 00:54:29Z

1

You can use list comprehension, like this

print [v["data2"] for v in d.values()]

Output

['Title col1', 'Title col2', 'Title col3']

answered Nov 27, 2013 at 0:54

thefourtheye

241k53 gold badges466 silver badges505 bronze badges

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

Comments

score 0 · Accepted Answer · 2013-11-27 01:00:41Z

0

You can use a list comprehension:

>>> d = {
...     "row1": {
...       "data1": "0.87",
...       "data2": "Title col1",
...       "data3": "14.4878",
...       "data4": "Title row1"
...     },
...     "row2": {
...       "data1": "15352.3",
...       "data2": "Title col2",
...       "data3": "14.9561",
...       "data4": "Title row2"
...     },
...     "row3": {
...       "data1": "0",
...       "data2": "Title col3",
...       "data3": "16.8293",
...       "data4": "Title row3"
...     }
...   }
>>> Array_ = [x["data2"] for x in d.values()]
>>> Array_
['Title col1', 'Title col2', 'Title col3']
>>>

Note that the above code assumes that all of the items returned by d.values have a "data2" key. However, if this isn't always the case, then you can use dict.get to avoid a KeyError:

Array_ = [x.get("data2") for x in d.values()]

edited Nov 27, 2013 at 1:00

answered Nov 27, 2013 at 0:54

user2555451

2 Comments

user3001937 Over a year ago

SyntaxError: invalid syntax >>>

user2555451 Over a year ago

@user3001937 - I don't understand. My code was tested in Python 3.3 and Python 2.7 and it worked fine. What is wrong? Your dictionary sample has an extra closing curly brace. Perhaps that is the issue? (notice that I simply ignored this in my code).

Collectives™ on Stack Overflow

Extracting an array that contains Json fields in Python

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related