On Dec 20, 2007 4:56 PM, Bert Jacobs <[EMAIL PROTECTED]> wrote: > Hi, > > The problem is probably that my Var4, does not contain number but factor > information, and therefore I think Gabor's suggestion does not work. > The same holds for Hadley's solution with the functions melt/cast, where the > resulting dataframe looks OK, but the dataframe is filled with the number of > times Var3 occurred for a certain Var1 and a certain Var2. It looks more > like: > > Var1 Var2 W1 W2 W3 W4 > A Fa 1 1 > A Si 1 1 > B Si 1 > C La 1 > C Do 2 > > While it should be: > > Var1 Var2 W1 W2 W3 W4 > A Fa F1 F3 > A Si F2 F4 > B Si F5 > C La F6 > C Do F7 > C Do F8 > > Or even better: > > Var1 Var2 W1 W2 W3 W4 > A Fa F1 F3 > A Si F2 F4 > B Si F5 > C La F6 > C Do F7/F8
In that case you'll need to specify an aggregation function. You probably want: cast(dfm, ... ~ Var3, function(x) paste(x, collapse="/"), add.missing=TRUE) -- 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.
