make two tables having same orders in both column and row names

Ping-Hsun Hsieh hsiehp at ohsu.edu
Wed Nov 18 21:57:11 CET 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