Turning Json object to an array

Question

I have a JSon object that is written this way.

Data= [{
  "code" : "001",
  "city" : "Boston",
  "zipcode":"067"
  },{
  "code" : "002",
  "city" : "NY",
  },{
  "city" : "NewJersey",
  }]

In order to get a specific value "Code" in an array, I make this way.

ar= Data["code"].Values

When I print results I got

ar = [001, 002 ,'nan']

'nan' seems like the empty value. How can I get only data that exist in the field without taking in consideration these fields where we don't find "code" attribute in ?

Python 2.7 ! I did import Json using pandas as pd Pd.read_json() — user3047512, Nov 29 '13 at 01:21
That is illegal code in python2.7. I just tried it. `Data` is a list and can only use `int` indices, not `str` indices — inspectorG4dget, Nov 29 '13 at 01:21
Also, that's not JSON what you show here. That's an array of dictionaries, which makes a difference. — rdodev, Nov 29 '13 at 01:24

inspectorG4dget · Answer 1 · 2013-11-29T01:25:11.513

0

What you have shown us is not JSON. It's a list of dicts. If you want to get all the 'code' values out of those dicts, then you could do this:

[d['code'] for d in Data if 'code' in d]

edited Nov 29 '13 at 01:25

answered Nov 29 '13 at 01:18

inspectorG4dget

110,290
27
149
241

I still get 'nan' elements in the list when I print it . Let's tackle the problem frpm different corner. Can we delete empty values – user3047512 Nov 29 '13 at 01:35
@user3047512 That's a duplicate of [the question you asked just before posting this one](http://stackoverflow.com/q/20276598/198633), which has valid answers on it – inspectorG4dget Nov 29 '13 at 01:36

Turning Json object to an array

1 Answers1