将DataFrame转换为有子字典的字典

import pandas as pd
from collections import defaultdict

df = pd.DataFrame({'Name': ['Alice', 'Bob', 'Charlie'],
                   'Age': [25, 30, 35],
                   'City': ['New York', 'London', 'Paris']})

def dataframe_to_dict(df):
    result_dict = defaultdict(dict)
    for index, row in df.iterrows():
        for column in df.columns:
            result_dict[index][column] = row[column]
    return dict(result_dict)

result = dataframe_to_dict(df)
print(result)

{0: {'Name': 'Alice', 'Age': 25, 'City': 'New York'},
 1: {'Name': 'Bob', 'Age': 30, 'City': 'London'},
 2: {'Name': 'Charlie', 'Age': 35, 'City': 'Paris'}}