make two tables having same orders in both column and row names
Ping-Hsun Hsieh
hsiehp at ohsu.edu
Wed Nov 18 15:57:11 EST 2009
Hi,
I would like to compare values in two table with same column and row names, but with different orders in column and row names.
For example, table_A in a file looks like the follows:
AA100 AA109 AA101 AA103 AA102
BB1 2 9 2.3 1 28
BB3 12 9 2.3 1 28
BB9 0.5 2 2.3 1 28
BB2 2 9 21 1 20
Table_B in the other file looks like the follows:
AA101 AA109 AA100 AA103 AA102
BB1 2 9 2.3 2 28
BB2 2 9 2.3 1 28
BB9 2 9 2.3 1 28
BB3 2 2 2 1 28
Can anyone give an efficient way to make the two tables having same orders in column and row names so I can easily and correctly compare the values in positions?
Thanks,
PingHsun
More information about the Python-list
mailing list