在字典中格式化python字典以导出到excel

您可以定义一个助手函数来展平字典:

def flatten(user):
    favorite_movies = []
    years = []
    for key, value in user.items():
        if isinstance(value, dict):
            favorite_movies.append(pd.Series(value))
            years.append(key[-4:])
    return pd.DataFrame(pd.concat(favorite_movies, axis=1).T).assign(
        Name=user["Name"], Age=user["Age"], Movie_year=years
    )

然后将展开的词典连接到新的数据帧中:

dfs = [flatten(user) for user in [test_dict, test_dict2]]

df = (
    pd.concat(dfs, axis=0)
    .reindex(
        columns=["Name", "Age", "Movie_year"]
        + [col for col in dfs[0].columns if col not in ["Name", "Age", "Movie_year"]]
    )
    .reset_index(drop=True)
)

df.to_excel("output2.xlsx")

print(df)
# Output
     Name  Age Movie_year  Harry Potter  Fake Movie  Cinderella  Hollywood
0     Tom   20       2020            20          20          10         20
1     Tom   20       2021            21          20          10         20
2  Oliver   40       2020            30          50          90         20