selecting columns from one data frame by name from a different data frame in R

Question

I have two dataframes:

df1<-matrix(data = 1:10,
nrow = 5,
ncol = 5)
colnames(df1)=c("a","b","c","d","e")

df2=c("a","c","e")

I want to create a new table using the values from the first data frame but including only the columns whose name is present in the second data frame.

thanks! that is simpler that what i was trying to do. I had df2 as a dataframe as opposed to a string of characters and it was giving me issues. — João Duarte, May 11 '21 at 14:16

score 1 · Accepted Answer · answered May 11 '21 at 14:16

1

Try adding below to your code

df3 <- data.frame(df1[,df2])

answered May 11 '21 at 14:16

leonhnoel

28
5

selecting columns from one data frame by name from a different data frame in R

1 Answers1