Select variables on multiple conditions in R

Question

I am trying to select columns on multiple conditions: 1. I want to select specific columns but I also want to select variables with specific expressions in their name. I tried this:

df.waste <- w0%>%
  select(council_name, Period, year | contains("households" | "Tonnage"))

So I am trying to select the columns "council_name", "Period", "year" AND all those which contain the expressions "household" OR "Tonnage" in their name.

I tried different things all similar to the one above but I'm not quite getting what I want. Thanks!

Try w0 %>% select(council_name, Period, year, contains(c("households", "Tonnage"))) — Darren Tsai
– Darren Tsai, Commented Jun 11, 2020 at 14:55

Ahorn · Accepted Answer · 2020-06-11 14:53:43Z

2

Like this?

w0%>%
  select(council_name, Period, year | contains(c("households", "Tonnage")))

# A tibble: 1 x 5
  council_name Period year  householdsabc Tonnageabc
  <lgl>        <lgl>  <lgl> <lgl>         <lgl>     
1 NA           NA     NA    NA            NA

Data

council_name <- NA
Period <- NA
year <- NA
householdsabc <- NA
Tonnageabc <- NA

w0 <- tibble(council_name, Period, year, householdsabc, Tonnageabc)

answered Jun 11, 2020 at 14:53

Ahorn

3,9141 gold badge13 silver badges18 bronze badges

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

2 Comments

AntVal Over a year ago

Perfect. Was so close and couldn't figure it haha. Thanks!

Ahorn Over a year ago

You're welcome! Also as mentioned by @Darren you can replace | with ,

akrun · Accepted Answer · 2020-06-11 19:07:18Z

1

Another option is grep in base R

w0[c(1, 2, grep("households|Tonnage", names(w0)))]

answered Jun 11, 2020 at 19:07

akrun

891k38 gold badges590 silver badges700 bronze badges

Collectives™ on Stack Overflow

Select variables on multiple conditions in R

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related