Message-ID: <3DDC44F2.8040206@colorado.edu>
Date: 2002-11-21T02:29:06Z
From: Bill Oliver
Subject: 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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._