JSON数据

obj = """
{"name": "Wes",
 "places_lived": ["United States", "Spain", "Germany"],
 "pet": null,
 "siblings": [{"name": "Scott", "age": 25, "pet": "Zuko"},
              {"name": "Katie", "age": 33, "pet": "Cisco"}]
}
"""

通过python标准库的json.loads方法可以将JSON字符串转换为Python形式

import json
result = json.loads(obj)
result

{'name': 'Wes',
 'pet': None,
 'places_lived': ['United States', 'Spain', 'Germany'],
 'siblings': [{'age': 25, 'name': 'Scott', 'pet': 'Zuko'},
  {'age': 33, 'name': 'Katie', 'pet': 'Cisco'}]}

json.dumps可以将Python对象转换为JSON格式

asjson = json.dumps(result)

向DataFrame构造器传入JSON对象，并选取数据字段子集

siblings = DataFrame(result['siblings'], columns=['name', 'age'])
siblings

    name    age
0    Scott    25
1    Katie    33