[R] restructuring datset problem
Gellrich Mario
mario.gellrich at env.ethz.ch
Sun Sep 7 20:23:23 CEST 2008
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
More information about the R-help
mailing list