I would like to get names with sp.
, sp.
, and sp
, and remove the "Antidesma cuspidatum"
df <- data.frame(name1 = c("Acranthera sp. 01", "Amydrium sp.01", "Alyxia sp.", "Antidesmatoideae sp.", "Antidesma cuspidatum"))
I am using filter_at
but "Antidesma cuspidatum"
still included since it contains sp
df %>%
filter_at(.vars = vars(name1), all_vars(grepl("sp.|sp. ",.)))
name1
1 Acranthera sp. 01
2 Amydrium sp.01
3 Alyxia sp.
4 Antidesmatoideae sp.
5 Antidesma cuspidatum
Any suggestions for me?
My desired output
name1
1 Acranthera sp. 01
2 Amydrium sp.01
3 Alyxia sp.
4 Antidesmatoideae sp.