How to select columns in r by multiple condition (not using select_if)?

Question

Since select_if is superseded, I wanna know the "not superseded/tidyverse" version of:

library(tidyverse)
library(ggplot2movies)
library(purrr)

movies %>%
  select_if(~ sum(is.na(.))/length(.) > .25)

Another option that works is:

movies %>% 
  keep(~ sum(is.na(.x))/length(.x) > .25)

akrun · Accepted Answer · 2021-03-11 23:08:08Z

1

We can use select with where

library(dplyr) # // version 1.0.4
library(ggplot2movies)
out2 <- movies %>%
   select(where(~ mean(is.na(.)) > .25))

-checking with OP's code

out1 <- movies %>%
         select_if(~ sum(is.na(.))/length(.) > .25)

identical(out1, out2)
#[1] TRUE

sum(...)/n() can be mean(...)

answered Mar 11, 2021 at 23:08

akrun

891k38 gold badges590 silver badges700 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1