Pandas展平和合并多头数据帧和concat标头名称

import pandas as pd

# 创建多个数据帧
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df2 = pd.DataFrame({'C': [7, 8, 9], 'D': [10, 11, 12]})

# 展平数据帧
melted_df1 = pd.melt(df1, id_vars=['A'], value_vars=['B'], var_name='Variable', value_name='Value')
melted_df2 = pd.melt(df2, id_vars=['C'], value_vars=['D'], var_name='Variable', value_name='Value')

# 合并数据帧
merged_df = pd.merge(melted_df1, melted_df2, left_on='Value', right_on='C', how='inner')

# 修改标头名称
renamed_df = merged_df.rename(columns={'A': 'Column_A', 'B': 'Column_B', 'C': 'Column_C', 'D': 'Column_D'})

print(renamed_df)