Re: [R] Reorganize data frame

From: Henrique Dallazuanna <wwwhsd_at_gmail.com>
Date: Wed, 16 Mar 2011 15:58:53 -0300

Try this:

xtabs(Return ~ Date + Ticker, stock.returns)

On Wed, Mar 16, 2011 at 11:37 AM, chris99 <cheakes_at_hotmail.com> wrote:
> Hi group,
>
> I am trying to convert the organization of a data frame so I can do some
> correlations between stocks,
>
> I have something like this:
>
> stock.returns <-
> data.frame(rbind(c("MSFT","20110301",0.05),c("MSFT","20110302",0.01),c("GOOG","20110301",-0.01),c("GOOG","20110302",0.04)))
> colnames(stock.returns) <- c("Ticker","Date","Return")
> stock.returns
>  Ticker     Date Return
> 1   MSFT 20110301   0.05
> 2   MSFT 20110302   0.01
> 3   GOOG 20110301  -0.01
> 4   GOOG 20110302   0.04
>
>
> And want to convert it to this:
>
> stock.returns <-
> data.frame(rbind(c("20110301",0.05,-0.01),c("20110302",0.01,0.04)))
> colnames(stock.returns) <- c("Date","MSFT","GOOG")
> stock.returns
>      Date MSFT  GOOG
> 1 20110301 0.05 -0.01
> 2 20110302 0.01  0.04
>
>
> Can anyone offer any suggestions?
>
> Thanks,
> Chris
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Reorganize-data-frame-tp3381929p3381929.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

-- 
Henrique Dallazuanna
Curitiba-Paranį-Brasil
25° 25' 40" S 49° 16' 22" O

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Wed 16 Mar 2011 - 19:06:50 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 16 Mar 2011 - 19:30:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive