如何从嵌套的字典列表中创建包含嵌套列的pandas数据帧

import pandas as pd

data = [
    {'name': 'Alice', 'age': 25, 'address': {'city': 'New York', 'state': 'NY'}},
    {'name': 'Bob', 'age': 30, 'address': {'city': 'Los Angeles', 'state': 'CA'}},
    {'name': 'Charlie', 'age': 35, 'address': {'city': 'Chicago', 'state': 'IL'}}
]

df = pd.json_normalize(data, 'address', ['name', 'age'])

         city state    name  age
0    New York    NY   Alice   25
1  Los Angeles    CA     Bob   30
2     Chicago    IL  Charlie  35