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
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.
