将数据帧中的多个字典列解析为单独的列

import pandas as pd

# 创建包含多个字典的数据帧
df = pd.DataFrame({
    'dict_column': [{'name': 'Alice', 'age': 25, 'gender': 'Female'},
                    {'name': 'Bob', 'age': 30, 'gender': 'Male'},
                    {'name': 'Charlie', 'age': 35, 'gender': 'Male'}]
})

# 解析多个字典列为单独的列
parsed_df = pd.concat([df.drop('dict_column', axis=1),
                      df['dict_column'].apply(pd.Series)], axis=1)

# 输出解析后的数据帧
print(parsed_df)

      name  age  gender
0    Alice   25  Female
1      Bob   30    Male
2  Charlie   35    Male