python - 如何基于一个现有列插入值

Question

我正在尝试根据另一列中的值填写。请在下面查看我的脚本，让我知道如何避免最后一行覆盖前面的语句。非常感谢您提前提供的帮助！

data_xls['New'] = np.where(data_xls['Old'].str.contains('(?:ps1)', regex=True), "Promoted Story", "" )
data_xls['New'] = np.where(data_xls['Old'].str.contains('(?:native)', regex=True), "Native","" )
data_xls['New'] = np.where(data_xls['Old'].str.contains('(?:email)', regex=True), "Email", "" )
data_xls['New'] = np.where(data_xls['Old'].str.contains('(?:email)', regex=True), "InMail","" )
data_xls['New'] = np.where(data_xls['Old'].str.contains('(?:sponsored)', regex=True), "Sponsored Content","")

谢谢你，泰

标签： pythonpandasnumpy