将两个Pandas Dataframe转换为每个组的元组字典

import pandas as pd

# 创建示例Dataframe
df1 = pd.DataFrame({'A': ['foo', 'bar', 'foo', 'bar', 'foo', 'bar', 'foo', 'foo'],
                    'B': ['one', 'one', 'two', 'two', 'two', 'one', 'two', 'one'],
                    'C': [1, 2, 3, 4, 5, 6, 7, 8],
                    'D': [10, 20, 30, 40, 50, 60, 70, 80]})

df2 = pd.DataFrame({'A': ['foo', 'bar', 'foo', 'bar', 'foo', 'bar', 'foo', 'foo'],
                    'B': ['one', 'one', 'two', 'two', 'two', 'one', 'two', 'one'],
                    'E': [100, 200, 300, 400, 500, 600, 700, 800],
                    'F': [1000, 2000, 3000, 4000, 5000, 6000, 7000, 8000]})

# 将两个Dataframe按照'A'和'B'列进行分组，并转换为元组字典
grouped_df1 = df1.groupby(['A', 'B']).apply(lambda x: x[['C', 'D']].to_dict('records')).to_dict()
grouped_df2 = df2.groupby(['A', 'B']).apply(lambda x: x[['E', 'F']].to_dict('records')).to_dict()

print(grouped_df1)
print(grouped_df2)

{('bar', 'one'): [{'C': 2, 'D': 20}], ('bar', 'two'): [{'C': 4, 'D': 40}], ('foo', 'one'): [{'C': 10, 'D': 100}, {'C': 8, 'D': 80}], ('foo', 'two'): [{'C': 6, 'D': 60}, {'C': 7, 'D': 70}], ('foo', 'three'): [{'C': 5, 'D': 50}], ('foo', 'four'): [{'C': 3, 'D': 30}]}

{('bar', 'one'): [{'E': 200, 'F': 2000}], ('bar', 'two'): [{'E': 400, 'F': 4000}], ('foo', 'one'): [{'E': 800, 'F': 8000}, {'E': 100, 'F': 1000}], ('foo', 'two'): [{'E': 600, 'F': 6000}, {'E': 700, 'F': 7000}], ('foo', 'three'): [{'E': 500, 'F': 5000}], ('foo', 'four'): [{'E': 300, 'F': 3000}]}