如何使用groupby制作条件列？

import pandas as pd

# 创建一个示例数据集
data = {'Name': ['Alice', 'Bob', 'Charlie', 'Alice', 'Bob'],
        'Age': [25, 30, 35, 40, 45],
        'Gender': ['Female', 'Male', 'Male', 'Female', 'Male'],
        'Salary': [5000, 6000, 7000, 8000, 9000]}

df = pd.DataFrame(data)

# 使用groupby和条件列
df['Total Salary'] = df.groupby('Name')['Salary'].transform('sum')

print(df)

      Name  Age  Gender  Salary  Total Salary
0    Alice   25  Female    5000         13000
1      Bob   30    Male    6000         15000
2  Charlie   35    Male    7000          7000
3    Alice   40  Female    8000         13000
4      Bob   45    Male    9000         15000