Try this also; xtabs(rate ~ date + corp_id + investment_id, data = DF)
On Thu, Feb 18, 2010 at 7:21 AM, Anna Carter <anna_carte...@yahoo.com> wrote: > Hi! > I have just started learning R and today only I have joined this group. This > is my first mail and I wish to thank all of you for allowing me to be part of > this group. > > I have following problem. I have an input.csv file such that > > corp_id date investment_id rate > corp1 17-Feb 1 65 > corp1 16-Feb 1 70 > corp1 15-Feb 1 69 > corp1 14-Feb 1 89 > corp1 13-Feb 1 88 > corp2 17-Feb 1 95 > corp2 16-Feb 1 135 > corp2 15-Feb 1 140 > corp3 17-Feb 2 86 > corp3 16-Feb 2 73 > corp5 17-Feb 3 24 > corp6 17-Feb 4 44 > corp11 17-Feb 1 30 > corp13 17-Feb 1 16 > corp21 15-Feb 3 21 > > > I have filtered them based on investment id as > > invest_data = read.csv('input.csv') > investment_id = invest_data$investment_id > > filtered1 <- subset(invest_data,investment_id==1) > filtered2 <- subset(invest_data,investment_id==2) > filtered3 <- subset(invest_data,investment_id==3) > filtered4 <- subset(invest_data,investment_id==4) > > so filtered1 will give me > >> filtered1 > corp_id date investment_id stock_rate > 1 corp1 17-Feb 1 65 > 2 corp1 16-Feb 1 70 > 3 corp1 15-Feb 1 69 > 4 corp1 14-Feb 1 89 > 5 corp1 13-Feb 1 88 > 6 corp2 17-Feb 1 95 > 7 corp2 16-Feb 1 135 > 8 corp2 15-Feb 1 140 > 13 corp11 17-Feb 1 30 > 14 corp17 17-Feb 1 16 > > My objective is to rearrange filtered1 as > > date corp1 corp2 corp11 corp17 > 17-Feb 65 95 30 16 > 16-Feb 70 135 > 15-Feb 69 140 > 14-Feb 89 > 13-Feb 88 > > #(The above figures represent the corp-wise and date-wise rates for > investment_id = 1.) > > Please guide me how the filtered1 can be rearranged? > > Thanking you > > Anna Carter > > > > > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > [[alternative HTML version deleted]] > > > ______________________________________________ > R-help@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@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.