[R] taking rows from a data frame

Bill Oliver oliver at colorado.edu
Thu Nov 21 03:29:06 CET 2002

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"))


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

More information about the R-help mailing list