返回数据框形式的行，该行在特定列中包含一些字

Question

我希望在包含多个搜索条件的数据帧中获得这样一行。 例如 路径描述 他是个好孩子 拉宾是个好孩子 他很好 他是个男孩

我希望以数据帧的形式获取所有行，其中包含（'good'，'boy'）） retun应该是 他是个好孩子 拉宾是个好孩子

Answer 1

我为你做这个。。。没有测试

def find_intrastr_column_df(df, column_name, list_of_str_to_find):
    """
    Loop in a pandas dataframe, trying to find all rows 
    that contains the listed words in a particular column and 
    return a selected dataframe only with the rows founded.

    df: Pandas Dataframe
    column_name: String. Columns name
    list_of_str_to_find: List. List of String of words to find.
    """

    list_rows_find = []

    for index, row in df.iterrows():
        cell_value = row[column_name]
        # ignore nan values
        if cell_value != cell_value:
            break
        else:
            pass

        found = True
        for str in list_of_str_to_find:
            if str not in cell_value:
                found = False
                break
            else:
                pass

        if found:
            list_rows_find.append(index)
        else:
            pass

    df_selected = df.loc[list_rows_find,:]
    return df_selected