在pandas中排除分组依据后的列

import pandas as pd

# 创建示例数据
data = {'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]}

df = pd.DataFrame(data)

# 分组并排除分组依据后的列
result = df.groupby(['A', 'B']).drop(['A'], axis=1).reset_index()

print(result)

     A    B  C   D
0  bar  one  2  20
1  bar  two  4  40
2  foo  one  6  60
3  foo  two  7  70