从DataFrame到嵌套字典

import pandas as pd

# 创建一个DataFrame对象
data = {'name': ['Alice', 'Bob', 'Charlie'],
        'age': [25, 30, 35],
        'city': ['New York', 'London', 'Tokyo']}
df = pd.DataFrame(data)

# 将DataFrame转换为字典
df_dict = df.to_dict()

# 将字典转换为嵌套字典
nested_dict = {}
for column, values in df_dict.items():
    nested_dict[column] = {}
    for index, value in values.items():
        nested_dict[column][index] = value

# 打印结果
print(nested_dict)

{'name': {0: 'Alice', 1: 'Bob', 2: 'Charlie'},
 'age': {0: 25, 1: 30, 2: 35},
 'city': {0: 'New York', 1: 'London', 2: 'Tokyo'}}