[R] Help with the 'reshape' package

[Filipe Leme Botelho]

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