In [1]:
import numpy as np
import pandas as pd
from pandas import Series,DataFrame

In [2]:
json_obj = """
{   "zoo_animal": "Lion",
    "food": ["Meat", "Veggies", "Honey"],
    "fur": "Golden",
    "clothes": null, 
    "diet": [{"zoo_animal": "Gazelle", "food":"grass", "fur": "Brown"}]
}
"""

In [3]:
import json

In [5]:
data = json.loads(json_obj)

data


Out[5]:
{u'clothes': None,
 u'diet': [{u'food': u'grass', u'fur': u'Brown', u'zoo_animal': u'Gazelle'}],
 u'food': [u'Meat', u'Veggies', u'Honey'],
 u'fur': u'Golden',
 u'zoo_animal': u'Lion'}

In [7]:
data['food']


Out[7]:
[u'Meat', u'Veggies', u'Honey']

In [8]:
json.dumps(data)


Out[8]:
'{"food": ["Meat", "Veggies", "Honey"], "zoo_animal": "Lion", "fur": "Golden", "diet": [{"food": "grass", "zoo_animal": "Gazelle", "fur": "Brown"}], "clothes": null}'

In [9]:
df = DataFrame(data['diet'])

df


Out[9]:
food fur zoo_animal
0 grass Brown Gazelle

In [ ]: