I have a dataframe, WB. On WB I'm using dplyr's mutate() and ifelse() to convert ".." values to the values from adjacent variables.
The solution I've come to is,
mutate(WB, Rents2 = ifelse(Rents == "..", `X2014..YR2014.`, Rents)))
which produces this output: https://i.stack.imgur.com/7GFg5.png
Why does Rents2 return large values instead of the 2014 variable data?
".."
toNA
– Benjamin