在R中删除包含具有附加条件的特定单词的行 [英] Delete rows containing specific words with additional conditions in R

问题描述

除了包含广告还是营销，我想摆脱关键字中包含计划一词的行。特别是在样本数据集中，应该删除包含hr plan和operation plan的行。

I would like to get rid of rows where the word "plan" is included in keyword unless "advertising" or "marketing" is also included. Specifically in the sample dataset, the rows with keyword containing "hr plan" and "operation plan" should be deleted.

keyword <- c("advertising plan",
               "advertising budget",
               "marketing plan",
               "marketing budget",
               "hr plan",
               "hr budget",
               "operation plan",
               "operation budget")
indicator <- c(1,0,0,1,1,1,0,1)
sample <- cbind(keyword,indicator)

推荐答案

不用花哨的正则表达式，我可能只需要结合你的两个规则：

Without using fancy regular expressions, I'd probably just go for combining your two rules:

sample[!(grepl("plan", sample[,"keyword"]) &
        (!grepl("marketing|advertising", sample[,"keyword"]))),]
#     keyword              indicator
#[1,] "advertising plan"   "1"      
#[2,] "advertising budget" "0"      
#[3,] "marketing plan"     "0"      
#[4,] "marketing budget"   "1"      
#[5,] "hr budget"          "1"      
#[6,] "operation budget"   "1" 

这篇关于在R中删除包含具有附加条件的特定单词的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！