这个解决方案使用了一个最残酷的循环，并使用一个dict将每个类别名称Map到该类别的一组关键字。

import pandas as pd

df = pd.DataFrame({'Text': ['invoice received payment sent data csv', 'data is portrayed by brent spiner']})

category_keywords = {'Invoice & Payment': {'invoice', 'payment'}, 'Data Request': {'data', 'csv'}}

df['Target Sub Category'] = [{cat for word in text.split()
                                  for cat,keywords in category_keywords.items()
                                  if word.lower() in keywords
                             } for text in df['Text']]

print(df)
#                                      Text                Target Sub Category
# 0  invoice received payment sent data csv  {Data Request, Invoice & Payment}
# 1       data is portrayed by brent spiner                     {Data Request}