Hi > Hi all, > > I am reading previous posts and guidance on the 'reshape' package in order > to solve the simple problem below. Thinking that this might be very > trivial for most of you, I thought there could be a fast solution coming
> from you guys, and I´d be very thankful for that. > > I have a matrix with dates, companies, prices, just like > > Date Company Price > set-11 A 3 > dez-11 A 3,2 > jan-12 A 3,3 > fev-12 A 2,7 > mar-12 A 2,7 > abr-12 A 2,8 > mai-12 A 2,9 > jun-12 A 3 > jul-12 A 3,1 > mar-12 B 5 > abr-12 B 5,5 > mai-12 B 5,7 > jun-12 B 7 > jul-12 B 6,6 > dez-11 C 1 > jan-12 C 1,1 > fev-12 C 1,11 > mar-12 C 1,2 > abr-12 C 1,3 > > and I want to convert it into something like below (missing data can be > zeros or NAs) > > A B C > set-11 3 NA NA > dez-11 3,2 NA 1 > jan-12 3,3 NA 1,1 > fev-12 2,7 NA 1,11 > mar-12 2,7 5 1,2 > abr-12 2,8 5,5 1,3 > mai-12 2,9 5,7 NA > jun-12 3 7 NA > jul-12 3,1 6,6 NA You have already melted data (long format). So simply cast cast(test, Date~Company) Using Price as value column. Use the value argument to cast to override this choice Date A B C 1 abr-12 2.8 5.5 1.30 2 dez-11 3.2 NA 1.00 3 fev-12 2.7 NA 1.11 4 jan-12 3.3 NA 1.10 5 jul-12 3.1 6.6 NA 6 jun-12 3.0 7.0 NA 7 mai-12 2.9 5.7 NA 8 mar-12 2.7 5.0 1.20 9 set-11 3.0 NA NA Shall be OK. Regards Petr > > Workspace is attached. Thanks in advance. > > "This message and its attachments may contain confidential and/or > privileged information. If you are not the addressee, please, advise the > sender immediately by replying to the e-mail and delete this message." > > "Este mensaje y sus anexos pueden contener información confidencial o > privilegiada. Si ha recibido este e-mail por error por favor bórrelo y > envíe un mensaje al remitente." > > "Esta mensagem e seus anexos podem conter informação confidencial ou > privilegiada. Caso não seja o destinatário, solicitamos a imediata > notificação ao remetente e exclusão da > mensagem."______________________________________________ > 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. ______________________________________________ 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.