[R] Create pairwise table from columns?

From: knussear <knussear_at_mac.com>
Date: Fri, 09 May 2008 17:17:44 -0700 (PDT)

Hi Group

I have a large data set of individual pairwise values (250,000 rows) that I need to reshape into a pairwise matrix for mantel tests of these values versus genetic distances.

the data are currently in columns formatted like so AnimalA, AnimalB, Score

A1, A2, S1
A1, A3, S2
A1, A4, S3
A2, A3, S4
A2, A4, S5
A3, A4, S6

...,....,....

I need the final matrix to be formatted as

     A1    A2    A3    A4
A1  0     S1    S2    S3
A2  S1    0     S4    S5
A3  S2    S4   0      S6
A4  S3    S4   S6     0

are there any functions/packages that will make this easier?

Thanks

Ken

-- 
View this message in context: http://www.nabble.com/Create-pairwise-table-from-columns--tp17158538p17158538.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help_at_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.
Received on Sat 10 May 2008 - 00:21:46 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 10 May 2008 - 13:30:38 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive