将带有多索引的pandas数据透视表转换为嵌套字典

import pandas as pd

# 创建一个带有多索引的数据透视表
data = {'Index1': ['A', 'A', 'B', 'B', 'C', 'C'],
        'Index2': ['X', 'Y', 'X', 'Y', 'X', 'Y'],
        'Value': [1, 2, 3, 4, 5, 6]}
df = pd.DataFrame(data)

pivot_table = df.pivot_table(index='Index1', columns='Index2', values='Value')

# 将数据透视表转换为字典
pivot_dict = pivot_table.to_dict(orient='index')

# 创建一个空的嵌套字典
nested_dict = {}

# 遍历转换后的字典
for key, value in pivot_dict.items():
    # 拆分键为多个索引值
    index_values = key.split(', ')
    
    # 将每个索引值添加到嵌套字典中的相应层级
    current_dict = nested_dict
    for i, index_value in enumerate(index_values):
        if i == len(index_values) - 1:
            current_dict[index_value] = value
        else:
            if index_value not in current_dict:
                current_dict[index_value] = {}
            current_dict = current_dict[index_value]

print(nested_dict)