Pandas如何计算数据透视表中的2列

df.pivot_table(values, index, columns, aggfunc)

import pandas as pd

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

pivot_table = df.pivot_table(values=['C', 'D'], index='A', columns='B', aggfunc='mean')
print(pivot_table)

        C           D      
B     one  two   one   two
A                          
bar   3.0  4.0  30.0  40.0
foo   3.0  2.0  15.0  30.0