Python:基于多个条件从行创建新列

import pandas as pd

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

df = pd.DataFrame(data)

# 创建新列
df['NewColumn'] = ''

# 根据条件设置新列的值
df.loc[(df['Age'] < 30) & (df['Gender'] == 'Male'), 'NewColumn'] = 'Young Male'
df.loc[(df['Age'] >= 30) & (df['Gender'] == 'Male'), 'NewColumn'] = 'Old Male'
df.loc[df['Gender'] == 'Female', 'NewColumn'] = 'Female'

# 打印结果
print(df)

      Name  Age  Gender  Salary   NewColumn
0    Alice   25  Female    5000      Female
1      Bob   30    Male    6000    Old Male
2  Charlie   35    Male    7000    Old Male
3    David   40    Male    8000    Old Male