Try this:

 xtabs(kmdist ~ ida + idb, data = x)

On Sun, Sep 6, 2009 at 5:12 PM, Thomas Jensen <
thomas.jensen@eup.gess.ethz.ch> wrote:

> Dear R-list,
>
> Sorry for spamming the list, but I am just learning how to manipulate data
> in R, so  if this is a trivial question I am sorry.
>
> I have the following data which list the distance between capitals:
>
>                ida     idb     kmdist
> 7108    "UK"    "BEL"   " 313"
> 7110    "UK"    "FRN"   " 365"
> 7116    "UK"    "POR"   "1618"
>
> I would like to convert this into an a valued adjacency matrix that looks
> like this:
>
>        BEL             FRN     POR
> UK      313             365             1618
>
> The full data set has all possible pairings between countries, so the end
> goal should be a symmetric adjacency matrix.
>
> Thank you,
>
> Thomas Jensen
>
> ______________________________________________
> 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.
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]


