Pass a variable to dplyr "rename" to change columnname

[sothy]

What I am trying to do is: rename column from a dataframe with a variable. My approch is not working. Any help is appreciated.

example: (is not working)

variable <- sym("new_name")
df %>% rename(!!variable = name_of_col_from_df)

[rensa]

I'm not the best person to explain the ins and outs of tidyeval, but I think that if you're using bang-bang (!!) to unquote the left hand side of an assignment, you need to use a special substitute := operator:

df %>% rename(!!variable := name_of_col_from_df)

How does that go for you?

[sothy]

Hi Rensa,

Worked like a charm! Thank you very much.

Greetings

[EconomiCurtis]

If your question's been answered— even by you, would you mind choosing a solution? (see FAQ below for how) It makes it a bit easier to visually navigate the site and see which questions still need help.

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

Thanks