select data and exclude observations from a dataset via dplyr

Question

Suppose to have:

x<-c(1,2,3,1)
y<-c(2,NA,1,1)

I want to create the following:

z<-c(2,2,3,1)

namely select the larger value, excluding NA a priori and keep the same value if x and y are equal.

Is there a way to do this in dplyr?

and with `dplyr`: data.frame(x=x, y=y) %>% mutate(z = pmax(x, y, na.rm=TRUE)) — Christoph Wolk, Sep 01 '17 at 15:16

score 1 · Answer 1 · answered Sep 01 '17 at 15:13

1

We can use pmax in dplyr

library(dplyr)
tibble(x, y) %>%
    transmute(xy = pmax(x, y, na.rm = TRUE)) %>% 
    pull(xy)
#[1] 2 2 3 1

Or another option is reduce

library(purrr)
list(x, y) %>%
     reduce(pmax, na.rm = TRUE)
#[1] 2 2 3 1

answered Sep 01 '17 at 15:13

akrun

1 Answers1