找到值并将其扩展到pandas中的分组

import pandas as pd

# 创建一个示例数据集
data = {'Name': ['Alice', 'Bob', 'Charlie', 'Alice', 'Bob'],
        'Age': [25, 30, 35, 25, 30],
        'Salary': [5000, 6000, 7000, 5500, 6500]}

df = pd.DataFrame(data)

# 按照Name列进行分组
grouped = df.groupby('Name')

# 查看分组后的结果
for name, group in grouped:
    print(name)
    print(group)

Alice
    Name  Age  Salary
0  Alice   25    5000
3  Alice   25    5500
Bob
  Name  Age  Salary
1  Bob   30    6000
4  Bob   30    6500
Charlie
      Name  Age  Salary
2  Charlie   35    7000

# 计算每个组的平均值和总和
result = grouped.agg({'Age': 'mean', 'Salary': 'sum'})
print(result)

         Age  Salary
Name                
Alice   25.0   10500
Bob     30.0   12500
Charlie 35.0    7000