In [1]:

    

import numpy as np
from pandas import Series, DataFrame
import pandas as pd


    

In [3]:

    

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


    

In [4]:

    

import json


    

In [5]:

    

data = json.loads(json_obj)


    

In [6]:

    

data


    

    
Out[6]:





{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]:

    

json.dumps(data)


    

    
Out[7]:





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

In [8]:

    

dframe = DataFrame(data['diet'])


    

In [9]:

    

dframe


    

    
Out[9]:






  

    

      

      
food
      
fur
      
zoo_animal
    
  
  

    

      
0
      
grass
      
brown
      
Gazelle
    
  

In [ ]: