[R] Converting strings into data frame column names

[dthomas]

Hi all,

I want to loop through a series of data frames and append them into one data
frame, however I do not want all columns of the original data frames to be
in the new data frame. I have the following code:

phList<-c('ph2010','ph2009','ph2008','ph2007','ph2006') #Name of original
data frames

for (i in phList) {

x<-c(paste(i,"$ID",sep=""),paste(i,"$DATE_DISPENSED",sep=""),paste(i,"$TG_NAME1",sep=""),
paste(i,"$TG_NAME2",sep=""),paste(i,"$TG_NAME3",sep="")) # I may be over
complicating things here!?

phNew<-rbind(phNew,(data.frame(ID=get(x[1]), DATE_DISPENSED=get(x[2]), 
TG_NAME1= get(x[3]),  TG_NAME2=get(x[4]), TG_NAME3=get(x[5]))))
}

The error i get is that the columns for extration are not recognised as
objects which i understand. What i need resolving is how do i get around
this so that each column desired is extracted from the original data frames?
Is there a way to make the string (where my over complicating note is) of
the column name into the column name as get() does not work as I have it.

Your help is much appreciated,
D

--
View this message in context: http://r.789695.n4.nabble.com/Converting-strings-into-data-frame-column-names-tp4325870p4325870.html
Sent from the R help mailing list archive at Nabble.com.