如果任何列包含关键字之一，则删除行

Question

我想删除任何列包含关键字的行

keywords=['Nokia' , 'Asus']

data = [['Nokia', 'AB123','broken'], ['iPhone', 'DF747','battery'], ['Acer', 'KH298','exchanged for a nokia'], ['Blackberry', 'jj091','exchanged for a Asus']] 
df = pd.DataFrame(data, columns = ['Brand', 'ID', 'Description']) 

前测向：

Brand      | ID    |  Description
----------------------------------------
Nokia      | AB123 | broken
iPhone     | DF747 | battery
Acer       | KH298 | exchanged for a nokia
Blackberry | jj091 | exchanged for a Asus

df后：

Brand      | ID    |  Description
----------------------------------------
iPhone     | DF747 | battery
Acer       | KH298 | exchanged for a nokia

我怎样才能做到这一点？你知道吗

Answer 1

df = df[~(df.stack().str.contains('|'.join(keywords)).any(level=0))]

或者

df = df[~(df.astype(str).sum(axis=1).str.contains('|'.join(keywords)))]

输出

     Brand  ID      Description
1   iPhone  DF747   battery
2   Acer    KH298   exchanged for a nokia