[R] how to filter variables which appear in any row but do not include
Ana Marija
@okov|c@@n@m@r|j@ @end|ng |rom gm@||@com
Wed Jun 3 16:55:48 CEST 2020
Hello.
I am trying to filter only rows that have ANY of these variables:
E109, E119, E149
so I did:
controls=t %>% filter_all(any_vars(. %in% c("E109", "E119","E149")))
than I checked what I got:
> s0 <- sapply(controls, function(x) grep('^E10', x, value = TRUE))
> d0=unlist(s0)
> d10=unique(d0)
> d10
[1] "E10" "E103" "E104" "E109" "E101" "E108" "E105" "E100" "E106" "E102"
[11] "E107"
s1 <- sapply(controls, function(x) grep('^E11', x, value = TRUE))
d1=unlist(s1)
d11=unique(d1)
> d11
[1] "E11" "E119" "E113" "E115" "E111" "E114" "E110" "E118" "E116" "E112"
[11] "E117"
I need help with changing this command
controls=t %>% filter_all(any_vars(. %in% c("E109", "E119","E149")))
so that in the output I do not have any rows that include E102 or E112?
Thanks
Ana
More information about the R-help
mailing list