taking rows from a data frame
Lei Jiang wrote:
hi, there.
Here is my problem. I have a data frame by read.table(). I want to take
every row from this data frame and compute the correlation between the
current row and a fixed vector. finally I want to append the correlation
computed as a column to the data frame.
this is what i am doing.
df<-read.delim("filename", col.names=v)
myv<-c(....)#this is my vector that I need to compute cor with
corv<-cor(t(df[,c(..)]), myv, use="complete.obs") #only use c(..) in df
the values I got from corv doesnt seem to be right when I tried to verify
them. the way i am doing this is probably not very smart or totally wrong.
Can someone help?
Perhaps the following would do the trick. df$corv <- apply(df,1,function(x) cor(x,myv,use="complete.obs")) -Bill -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._