For loop for specific rows

manpreet Best Answer 2 years ago

How would I remove some job titles from the data frame (like below) FROM specific LOB? E.g. I want to keep Technology manager in LOB4 and I don't need technology sales in LOB2. When I execute the code below it removes titles from the entire data frame.

Is there any way to do this?

LOB     Title
LOB1    sales rep
LOB2    technology sales
LOB2    receptionist
LOB3    Web Designer
LOB4    Technology Manager



 for (i in c("(?=.*technology)", "(?=.*designer)")) {

    del <- grepl(i, data[data$LOB == "LOB1" | data$LOB == "LOB2",2], perl = T, ignore.case = T)

    data <- data[!del, ]
 }

manpreet 2 years ago

This is likely not working because the grepl statement is returning a vector with length of three that is then used to subset a data.frame with five rows. A for loop is also probably not needed and any of the following will drop technology sales in LOB2:

data[!grepl("(?=.*(com/tag/technology">technology|designer))", data$Title, perl = TRUE), ]
data[!data$Title == "com/tag/technology">technology sales", ]
data[!data$Title %in% c("com/tag/technology">technology sales", "job2 to drop"), ]
data[-2, ]