PythonPandas：如何将字符串列表与DataFrame列匹配

Python / Pandas：如何将字符串列表与DataFrame列匹配

这是使用个人的可读解决方案

search_func

：

def search_func(row):    matches = [test_value in row["Description"].lower()     for test_value in row["Text_Search"]]    if any(matches):        return "Yes"    else:        return "No"

然后按行应用此函数：

# create example datadf = pd.Dataframe({"Description": ["CANSEL SURVEY E PAY", "JX154 TFR?FR xxx8690"],        "Employer": ["Cansel Survey Equipment", "Cansel Survey Equipment"]})print(df)    Description  Employer0   CANSEL SURVEY E PAY     Cansel Survey Equipment1   JX154 TFR?FR xxx8690    Cansel Survey Equipment# create text searches and match columndf["Text_Search"] = df["Employer"].str.lower().str.split()df["Match"] = df.apply(search_func, axis=1)# show resultprint(df)    Description  Employer         Text_Search          Match0   CANSEL SURVEY E PAY     Cansel Survey Equipment     [cansel, survey, equipment]     Yes1   JX154 TFR?FR xxx8690    Cansel Survey Equipment     [cansel, survey, equipment]     No