找到在pandas中使用groupby的另一种方法，python

pandas.pivot_table(data, values=None, index=None, columns=None, aggfunc='mean', fill_value=None, margins=False, dropna=True, margins_name='All')

import pandas as pd

data = {'A': ['foo', 'foo', 'foo', 'bar', 'bar', 'bar'],
        'B': ['one', 'one', 'two', 'two', 'one', 'one'],
        'C': [1, 2, 3, 4, 5, 6],
        'D': [10, 20, 30, 40, 50, 60]}

df = pd.DataFrame(data)

# 使用pivot_table方法按列A和B进行分组，并计算C和D的平均值
result = df.pivot_table(index='A', columns='B', values=['C', 'D'], aggfunc='mean')

print(result)

       C             D        
B    one  two       one   two
A                            
bar  50.0  4.0      55.0  40.0
foo   1.5  3.0      15.0  30.0