Try this: xtabs(kmdist ~ ida + idb, data = x)
On Sun, Sep 6, 2009 at 5:12 PM, Thomas Jensen < thomas.jen...@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]]
______________________________________________ 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.
