add_column in tibble with variable column name

r dplyr tibble
Joe picture Joe · Aug 17, 2017 · Viewed 10.6k times · Source

This code doesn't work to add a column in tibble:

  library(tidyverse)
  df <- data.frame("Oranges" = 5)
  mycols <- c("Apples", "Bananas", "Oranges")
  add_column(df, mycols[[2]] = 7)

I get the error message:

  Error: unexpected '=' in "add_column(df, mycols[[2]] ="

But this code works:

  add_column(df, "Bananas" = 7)

Why?

I don't know the values of 'mycols' ahead of time. That's why I wrote my code for it to be a variable. Is this not possible in dplry?

Answer

MrFlick picture MrFlick · Aug 17, 2017

You can use one of the two options:

add_column(df, "{mycols[2]}" := 7)
add_column(df, !!(mycols[2]) := 7)

The first one is the more preferred style now where you can use glue strings to create parameter names. Otherwise you can use !! to inject the parameter name. Both require := allows you to use variables for parameter names (which you cannot do with the = that's normally used when calling a function).

Related questions

Error in bind_rows_(x, .id) : Column can't be converted from factor to numeric

I have ten datasets that have been read from Excel files, using the xlsx library, and stored in tibbles. I want to merge them. Here are example datasets. The number of variables differ between datasets, and some variables are only …

Read More
What is the difference between as.tibble(), as_data_frame(), and tbl_df()?

I remember reading somewhere that as.tibble() is an alias for as_data_frame(), but I don't know what exactly an alias is in programming terminology. Is it similar to a wrapper? So I guess my question probably comes down …

Read More
Having trouble viewing more than 10 rows in a tibble

First off - I am a beginner at programming and R, so excuse me if this is a silly question. I am having trouble viewing more than ten rows in a tibble that is generated from the following code. The …

Read More