«

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

On Nov 18, 8:57*pm, Ping-Hsun Hsieh <hsi...@ohsu.edu> wrote:
> 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

Use a dictionary with a tuple of the row 'name' and column 'name' as
the key.

The following was put together in a hurry, so take with a pinch of
salt (and brandy or something )...

t1data = """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"""


def create_table(what):
from itertools import imap, islice, izip, cycle, repeat
table = filter(None, imap(str.split, what.split('\n')))
table_dict = {}
for cols in islice(table, 1, None):
for row_name, col_name, col in izip(cycle(table[0]), repeat
(cols[0]), islice(cols, 1, None)):
table_dict[(row_name, col_name)] = col
return table_dict


print create_table(t1data)


hth
Jon.