I have one data frame dt, with a column named especie, with a lot of species of whales.

I want to create a new column reino from the values of the column especie. But I don’t know what is going on, because all species inside of this columns works, but not one (Ballena franca austral (Eubalaena australis)).

library(dplyr)
library(data.table)

dt = data.table(especie= c("Ballena barbada no identificada (Parvorden Mysticeti)", 
"Ballena jorobada (Megaptera novaeangliae)", "Ballena franca austral (Eubalaena australis)"))

as.character(dt$especie)

str(dt$especie)
 chr [1:305] "Ballena rorcual no identificada (Balaenoptera sp.)" ...

And I tried these options:


df$reino[df$especie %in% c('Ballena barbada no identificada (Parvorden Mysticeti)", 
"Ballena jorobada (Megaptera novaeangliae)", "Ballena franca austral (Eubalaena australis)')] 
<- "misticeto"

df$reino[df$especie %in% c('Ballena franca austral (Eubalaena australis)')]<- 'misticeto'


df$especie[df$especie %in% c('Ballena franca austral (Eubalaena australis)')]<- 'misticeto'

df[df$especie == "Ballena franca austral (Eubalaena australis)" , "reino"] <- "misticeto"

df$especie[df$especie == "Ballena franca austral (Eubalaena australis)"] <- "misticeto"

df%>%
  group_by(especie) %>%
  mutate(reino = case_when(
    ('Ballena franca austral (Eubalaena australis)') ~ "misticeto")) 

But any of them, the “Ballena franca austral (Eubalaena australis)” works, it came NA in the new column “reino”