如何创建新列替换列中的多个值

import pandas as pd

# 创建示例数据
data = {
    'id': [1, 2, 3, 4],
    'status': ['old', 'new', 'old', 'active']
}
df = pd.DataFrame(data)

# 替换值
df['status_new'] = df['status'].replace('old', 'new')

print(df)

   id  status status_new
0   1    old         new
1   2    new         new
2   3    old         new
3   4  active       active

# 检查要替换的值是否存在于列中
if 'old' in df['status'].values:
    df['status_new'] = df['status'].replace('old', 'new')
else:
    print("值 'old' 不存在于列中")

# 替换多个值
replace_dict = {'old': 'new', 'active': 'inactive'}
df['status_new'] = df['status'].replace(replace_dict)

print(df)

   id  status status_new
0   1    old         new
1   2    new         new
2   3    old         new
3   4  active    inactive