江湖小妞

zzss

import json　　In [65]: obj = """{"name":"Wes", "places_lived":["United States", "Spain", "Germany"], "pet":nu
　　...: ll, "siblings":[{"name":"Scott","age":25,"pet":"Zuko"},{"name":"Katy","age":33,"pet":"
　　...: Cisco"}]}"""
　　In [68]: res = json.loads(obj) # 将JSON字符串转换为Python形式
　　In [69]: res
　　Out[69]:
　　{u'name': u'Wes',
　　u'pet': None,
　　u'places_lived': [u'United States', u'Spain', u'Germany'],
　　u'siblings': [{u'age': 25, u'name': u'Scott', u'pet': u'Zuko'},
　　{u'age': 33, u'name': u'Katy', u'pet': u'Cisco'}]}
　　# 将Python转换为json
　　In [71]: asjson = json.dumps(res)
　　In [72]: asjson
　　Out[72]: '{"pet": null, "siblings": [{"pet": "Zuko", "age": 25, "name": "Scott"}, {"pet": "Cisco", "age": 33, "name": "Katy"}], "name": "Wes", "places_lived": ["United States", "Spain", "Germany"]}'
　　In[]: data = DataFrame(res['siblings'], columns=['name', 'age'])
　　In [75]: data
　　Out[75]:
　　name  age
　　0  Scott   25
　　1   Katy   33