将深度嵌套的JSON响应转换为pandas数据帧

import pandas as pd
import json
from pandas.io.json import json_normalize

json_response = '{"data": [{"name": "John", "age": 30, "address": {"city": "New York", "state": "NY"}}, {"name": "Alice", "age": 25, "address": {"city": "San Francisco", "state": "CA"}}]}'
data = json.loads(json_response)

df = json_normalize(data, 'data', ['name', 'age', ['address', 'city'], ['address', 'state']])

print(df)