Using get() inside of mutate() to add columns based on a value from a vector [duplicate]

Question

I would like to add a column for every element of a vector. The column value will be based on some criteria. I have used get() inside of filter() but it does not work inside of mutate().

Here is an example:

df <- read.table(text =
"A   B    C
1     2     3 
4     5     6
7     8     9",
header = TRUE, stringsAsFactors = FALSE)

I then use a function to go through the vector. Here is an example of just sending one character string

ID_function = function(var_name){

  df = df%>%
    mutate(get(var_name)=A + B)
}

ID_function("TEST")

The error is:

Error: unexpected '=' in:
"  df = df%>%
    mutate(get(var_name)="

Is there another method I could use?

akrun · Accepted Answer · 2019-06-11 16:00:28Z

2

We can use the assignment operator (:=) instead of <- and evaluate (!!) the string to create the column in tidyverse

library(tidyverse)
ID_function = function(var_name){

  df %>%
       mutate(!!var_name := A + B)
     }

ID_function("TEST")
#    A B C TEST
#1 1 2 3    3
#2 4 5 6    9
#3 7 8 9   15

answered Jun 11, 2019 at 16:00

akrun

891k38 gold badges590 silver badges700 bronze badges

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

Collectives™ on Stack Overflow

Using get() inside of mutate() to add columns based on a value from a vector [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related