I have an extensive data frame with 30+ columns and 10000+ rows. Today I want to focus in two columns: languages and languages2:
languages languages2
Spanish NA
Spanish NA
Other (specify) French
Other (specify) German
Other (specify) Russian
English NA
Other (specify) Portuguese
English NA
(...)
This is what I need:
languages
Spanish
Spanish
French
German
Russian
English
Portuguese
English
(...)
I am looking for an answer using mutate function from dplyr
>Solution :
data %>%
mutate(languages=if_else(languages=="Other (specify)", languages2, languages)