将多个pandas数据框列的groupby加权平均值作为数据框返回

import pandas as pd

df1 = pd.DataFrame({'Group': ['A', 'B', 'A', 'B'],
                    'Value': [1, 2, 3, 4],
                    'Weight': [0.5, 0.3, 0.2, 0.4]})
                    
df2 = pd.DataFrame({'Group': ['A', 'B', 'A', 'B'],
                    'Value': [5, 6, 7, 8],
                    'Weight': [0.1, 0.2, 0.3, 0.4]})

dfs = [df1, df2]

combined_df = pd.concat(dfs)
weighted_avg = combined_df.groupby('Group')['Value'].apply(lambda x: sum(x * combined_df.loc[x.index, 'Weight']) / sum(combined_df.loc[x.index, 'Weight'])).reset_index()

  Group  Value
0     A    2.6
1     B    5.4