Duplicated keys column after join about arquero HOT 2 CLOSED

Thanks! This is the intended behavior. The join verb also supports arbitrary predicate functions for testing if two rows match, and so it is not always apparent if two columns are equivalent. To drop unwanted duplicate columns you can do something like this:

dt.join(table, ['key', 'key'], [aq.all(), aq.not('key')])

This will join on two columns both named 'key', with a result that drops the 'key' column drawn from the second table. As a result no suffix will be added to the column drawn from the first table.

from arquero.

Thanks for the detailed explanation !

from arquero.