How to reference variable names in a for loop in R?

Question

I'm trying to reference variable names in for loop in R. For example, if I want to change each of the following variables to from numeric to a string

xtable<- tbl_df(cbind(x1=c(1,2,3), x2=c(3,4,5)))

for (varname in names(xtable)) {
 xtable$varname<- as.character(xtable$varname)
}

or rename each variable by adding an 'a' after each variable name

for (varname in names(xtable)) {
 dplyr::rename(xtable, varname = paste0(varname,'a', sep='') )
}

In general, I'm having trouble referencing the indexing variable "varname" within the for loop as the variable name it represents rather than as the word "varname".

@docendodiscimus how would I do it without a for loop? But for more complicated complications, how to reference index variables in a for loop as variable names themselves? — Amazonian
– Amazonian, Commented Nov 15, 2017 at 16:05
@Amazonian what you want to achieve can be done with one line: data.frame(lapply(xtable, as.character)) so no need for a for loop — Mehdi Nellen
– Mehdi Nellen, Commented Nov 15, 2017 at 16:09
@MehdiNellen thanks! that works for the first for loop, but I'm having trouble making it work for the second... — Amazonian
– Amazonian, Commented Nov 15, 2017 at 16:25

Adam Sampson · Accepted Answer · 2017-11-15 16:41:16Z

2

Note that tbl_df is depricated in the dplyr library. But you can use data.frame or as.data.frame easily.

xtable <- data.frame(x1=c(1,2,3), x2=c(3,4,5))
str(xtable) # shows the structure of the data.frame

R allows us to perform vector operations easily which take away the requirements for many loops.

# lapply applies a function to every column in a data.frame
xtable <- as.data.frame(lapply(xtable,as.character))
str(xtable) # shows the structure of the data.frame

# we can directly input into the names() of an object
# paste0 has a default separator of '' 
# If we put a vector into paste0 it will return a vector!
names(xtable) <- paste0(names(xtable),"a")
str(xtable)

But if you really need to reference a variable name in a loop (for a different problem)

for(varname in names(xtable)) {
  print(xtable[varname]) # xtable[varname] outputs a table with one column including header
  print(xtable[[varname]]) # xtable[[varname]] outputs only the contects of the varname vector
}

answered Nov 15, 2017 at 16:41

Adam Sampson

2,0411 gold badge9 silver badges18 bronze badges

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

2 Comments

Adam Sampson Over a year ago

Also, if you only want to update one name...use the [] to do it. names(xtable)[2] <- "x2b" #Only update the second name

acylam Over a year ago

as.tibble is the replacement for tbl_df

acylam · Accepted Answer · 2017-11-15 16:57:28Z

As others have mentioned, there is no need to use a for loop in both of your cases. There are two convenience functions in dplyr called mutate_all and mutate_if that will let you do the first case very easily:

library(dplyr)

# Convert all columns to character
xtable %>%
  mutate_all(as.character)

# Convert all numeric columns to character
xtable %>%
  mutate_if(is.numeric, as.character)

Result:

# A tibble: 3 x 2
     x1    x2
  <chr> <chr>
1     1     3
2     2     4
3     3     5

For second case, you can also use setNames and chain it with the first case:

xtable %>%
  mutate_all(as.character) %>%
  setNames(paste0(names(xtable), "a"))

Result:

# A tibble: 3 x 2
    x1a   x2a
  <chr> <chr>
1     1     3
2     2     4
3     3     5

Collectives™ on Stack Overflow

How to reference variable names in a for loop in R?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related