In which package do I find the "cast" function. At the moment it's not
recognized.
Thx,
Bert

-----Original Message-----
From: John Kane [mailto:[EMAIL PROTECTED] 
Sent: 19 December 2007 17:57
To: Bert Jacobs; 'hadley wickham'
Cc: [EMAIL PROTECTED]
Subject: Re: [R] Reshape Dataframe

I think if you use Gabor's suggested addtion of
add.missing to the original cast command you get what
you want.

cast(dfm, ... ~ Var3, add.missing=TRUE)

--- Bert Jacobs <[EMAIL PROTECTED]> wrote:

> 
> Thx Hadley,
> It works, but I need some finetuning.
> 
> If I use the following expression:
> Newdf <-reshape(df, timevar="Var3",
> idvar=c("Var1","Var2"),direction="wide")
> 
> Newdf
> Var1  Var2    Var3.W1 Var3.W2 Var3.W3 var3.W4
> A     Fa      1               3               
> A     Si      2                               4
> B     Si      5               
> C     La                      6
> C     Do                                                      7
> 
> Is there an option so that for each Var1 all
> possible combinations of Var2
> are listed (i.e. creation of blanco lines).
> Is it possible to name the columns with the values
> of the original Var3
> variable, so that the name Var3.W1 changes to W1? 
> 
> Var1  Var2    W1      W2      W3      W4
> A     Fa      1       3               
> A     Si      2               4
> A     La
> A     Do                      
> B     Fa                              
> B     Si      5               
> B     La
> B     Do
> C     Fa                              
> C     Si                      
> C     La              6
> C     Do                              7
> 
> 
> Thx,
> Bert
> 
> -----Original Message-----
> From: hadley wickham [mailto:[EMAIL PROTECTED] 
> Sent: 18 December 2007 15:16
> To: Bert Jacobs
> Cc: [EMAIL PROTECTED]
> Subject: Re: [R] Reshape Dataframe
> 
> On 12/18/07, Bert Jacobs <[EMAIL PROTECTED]>
> wrote:
> >
> > Hi,
> >
> > I'm having a bit of problems in creating a new
> dataframe.
> > Below you'll find a description of the current
> dataframe and of the
> > dataframe that needs to be created.
> > Can someone help me out on this one?
> 
> library(reshape)
> dfm <- melt(df, id = 1:3)
> cast(dfm, ... ~ Var3)
> 
> You can find out more about the reshape package at
> http://had.co.nz/reshape
> 
> Hadley
> 
> -- 
> http://had.co.nz/
> 
> ______________________________________________
> 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.
> 



      Looking for a X-Mas gift?  Everybody needs a Flickr Pro Account.

 

http://www.flickr.com/gift/

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

Reply via email to