Python 在列中查找部分文本，如果找到 true，则传递 a 通过反映分配的文本值而不是 true 或 false 来创建新列

你可以将正则表达式与所有关键字一起使用.然后，根据您是想获得第一个匹配还是全部匹配，分别使用extract或extractall进行聚合.

我添加了关键字"private"作为示例，以查看第3行中的差异:

import re
words = ['health', 'therapist', 'sales', 'private']
regex = '|'.join(map(re.escape, words))
# 'health|therapist|sales|private'

# option 1: get first match
df['category_first'] = (df['keyword']
 .str.extract(f'(?i)({regex})', expand=False)
 .fillna('other')
 )

# option 2: get all matches
df['category_all'] = (df['keyword']
 .str.extractall(f'(?i)({regex})')
 [0].groupby(level=0).agg(','.join)
 .reindex(df.index, fill_value='other')
 )

print(df)

输出:

                                              keyword   category category_first       category_all
0                     HR Consultancy UK-d-uk-159_bing      other          other              other
1           it support COMPANY LONDON-D-UK-G1161_bing      other          other              other
2             global sales training platform openings      sales          sales              sales
3                     tele private practice therapist  therapist        private  private,therapist
4                       asset grant management system      other          other              other
5   digital team project management solution openings      other          other              other
6                   global training platform openings      other          other              other
7                             tele practice therapist  therapist      therapist          therapist
8             global sales training platform openings      sales          sales              sales
9                                tele health practice     health         health             health
10                             asset grant management      other          other              other
11           digital team project management solution      other          other              other