Mutate specific columns based on position

Question

I trying to convert all negative values to 0 in specific columns of a dataframe. How would I for an example convert negative values to zero in column 3:5 and 8 in the mtcars data?

mtcars <- mtcars%>%
mutate(across(c(3:5,8), funs(replace(., .<0, 0)))

Thanks a lot for any help!

score 1 · Accepted Answer · answered Sep 18 '20 at 09:10

1

This could be achieved like so:

library(dplyr)

mtcars <- mtcars %>%
  mutate(across(c(3:5,8), ~ if_else(. < 0, 0, .)))

answered Sep 18 '20 at 09:10

stefan

90,330
6
25
51

You can even reduce it further by replacing `if_else` with `pmax(., 0)`. – WilliamGram Apr 10 '21 at 12:20

Mutate specific columns based on position

1 Answers1