pandas中两个数据帧的瀑布图

import pandas as pd
import matplotlib.pyplot as plt

# 创建两个数据帧
df1 = pd.DataFrame({'Category': ['A', 'B', 'C', 'D'],
                    'Value': [10, 20, 30, 40]})
df2 = pd.DataFrame({'Category': ['A', 'B', 'C', 'D'],
                    'Value': [15, 25, 35, 45]})

# 计算两个数据帧的差异
df_diff = df2['Value'] - df1['Value']

# 创建瀑布图
plt.bar(df1['Category'], df1['Value'], label='Before')
plt.bar(df2['Category'], df_diff, bottom=df1['Value'], label='Change')
plt.bar(df2['Category'], df2['Value'], label='After')

# 添加图例和标签
plt.legend()
plt.xlabel('Category')
plt.ylabel('Value')
plt.title('Waterfall Chart')

# 显示图形
plt.show()