R help - Feb 2009 - transform key value pair to column

Hi, is there a good way (instead of a time-consuming for loop) to
transfer a key/value pair dataframe to a dataframe with key as column
and value as row?  For example, I have a dataframe with three columns:
id, code, value:
 
id,code,value
1,hi,10.3
1,lo,5.2
2,hi,19.4
3,hi,20
3,lo,12
4,lo,5.8
 
I want to get a dataframe like this:
 
id,hi,lo
1,10.3,5.2
2,19.4,NA
3,20,12
4,NA,5.8
 
Thank you,
Richard

	[[alternative HTML version deleted]]

see ?stack, for example.

vQ

Tan, Richard wrote:
> Hi, is there a good way (instead of a time-consuming for loop) to
> transfer a key/value pair dataframe to a dataframe with key as column
> and value as row?  For example, I have a dataframe with three columns:
> id, code, value:
>  
> id,code,value
> 1,hi,10.3
> 1,lo,5.2
> 2,hi,19.4
> 3,hi,20
> 3,lo,12
> 4,lo,5.8
>  
> I want to get a dataframe like this:
>  
> id,hi,lo
> 1,10.3,5.2
> 2,19.4,NA
> 3,20,12
> 4,NA,5.8
>  
> Thank you,
> Richard
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>