Try this:
> # read in data ensuring NAME is character, not factor
> Lines <- " CODE NAME
+ 1 3 aaa
+ 2 3 aab
+ 3 3 aac
+ 4 4 bba
+ 5 4 bbb
+ 6 4 bbc
+ 7 4 bbd
+ 8 5 cca
+ 9 5 ccb
+ "
> DF <- read.table(textConnection(Lines), header = TRUE, as.is = TRUE)
>
> DF$seq = ave(DF$CODE, DF$CODE, FUN = seq_along)
> tapply(DF$NAME, DF[c("CODE", "seq")], c)
seq
CODE 1 2 3 4
3 "aaa" "aab" "aac" NA
4 "bba" "bbb" "bbc" "bbd"
5 "cca" "ccb" NA NA
On Sun, Sep 7, 2008 at 2:23 PM, Gellrich Mario
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've got a question regarding the restructering of a data set. What I have
> are municipality zip-codes and the names of 5'000 built-up areas within
> municipalities. The following example shows, what I would like to do:
>
> Input (Zip-Codes and Names):
>
> # CODE NAME
> #1 3 aaa
> #2 3 aab
> #3 3 aac
> #4 4 bba
> #5 4 bbb
> #6 4 bbc
> #7 4 bbd
> #8 5 cca
> #9 5 ccb
>
> Desired Output (Zip-Codes and restructured names)
>
> # CODE V2 V3 V4 V5
> #1 3 aaa aab aac NA
> #2 4 bba bbb bbc bbd
> #3 5 cca ccb NA NA
>
> I tougth about this problem several hours and tried functions like
> aggregate() and t() in combination with for-loops but didn't came to the
> output above. Can anybody help me?
>
> Best regards,
>
> Mario
>
>
>
> ______________________________________________
> 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.
>
______________________________________________
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.
