根据条件在Pandas中添加行(分组)

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
        'Age': [25, 30, 35, 40, 45],
        'City': ['New York', 'Paris', 'London', 'Tokyo', 'Sydney']}
df = pd.DataFrame(data)

grouped = df.groupby('Age')

result = pd.DataFrame(columns=df.columns)

for name, group in grouped:
    # 将分组数据添加到结果DataFrame中
    result = result.append(group)
    # 计算并添加总计行
    total_row = {'Name': 'Total', 'Age': group['Age'].sum(), 'City': ''}
    result = result.append(total_row, ignore_index=True)

print(result)

      Name Age      City
0    Alice  25  New York
1    Total  25          
2      Bob  30     Paris
3    Total  30          
4  Charlie  35    London
5    Total  35          
6    David  40     Tokyo
7    Total  40          
8      Eve  45    Sydney
9    Total  45