Extracting specific columns from a data frame?

Question

I have an R data frame with 6 columns, and I want to create a new dataframe that only has three of the columns.Assuming my data frame is `df`, and I want to extract columns `A`, `B`, and `E`, this is the only command I can figure out: data.frame(df$A,df$B,df$E)Is there a more compact way of doing this?

Answer 1

Hi,

Try this code below:

df[ ,names(df)%in%c("A","B","E"))] # if column names are important

Thanks,

Jay

Answer 2

newdf<-df[ ,c(1,2,5)] where 1,2, & 5 are the columns' position in the original data frame.