如何在dataframe中转换嵌套的json或list？

import pandas as pd

# 创建一个包含嵌套JSON或列表的DataFrame
data = {
    'id': [1, 2, 3],
    'name': ['John', 'Mike', 'Sarah'],
    'details': [
        {'age': 25, 'city': 'New York'},
        {'age': 30, 'city': 'London'},
        {'age': 28, 'city': 'Paris'}
    ]
}

df = pd.DataFrame(data)

# 将嵌套的JSON转换为多列
df_details = pd.json_normalize(df['details'])

# 将多列合并到原始DataFrame中
df = pd.concat([df.drop('details', axis=1), df_details], axis=1)

print(df)

   id   name  age      city
0   1   John   25  New York
1   2   Mike   30    London
2   3  Sarah   28     Paris