Pandas groupby multiple column然后再绘制子图

import pandas as pd
import matplotlib.pyplot as plt

# 假设有一个名为df的DataFrame，包含多个列，如下所示：
df = 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]
})

grouped = df.groupby(['A', 'B'])

aggregated = grouped.mean()

fig, axes = plt.subplots(len(aggregated), 1, figsize=(8, 6))

for i, ((a, b), data) in enumerate(aggregated.groupby(level=[0, 1])):
    data.plot(kind='bar', ax=axes[i])
    axes[i].set_title(f'Group: {a}-{b}')

plt.tight_layout()
plt.show()