stack/unstack_anomalous roundtrip does not work about reciprocalspaceship HOT 4 CLOSED

On second thought, DataFrame.merge(how='outer') is supposed to sort keys lexicographically. So, that is hopefully not the culprit.

from reciprocalspaceship.

What version of pandas were you using here? I can reproduce this bug, but I do not have any stochasticity on my system (using the latest pandas v1.3.3).

from reciprocalspaceship.

In my mind, this is a bug in unstack_anomalous(), not stack_anomalous(). Your snippet can be made to work for me with the following change to the last line:

plus_labels  = ["F(+)", "loc(+)", "scale(+)"]
minus_labels = ["F(-)", "loc(-)", "scale(-)"]
unstacked.stack_anomalous(plus_labels=plus_labels, minus_labels=minus_labels)

to explicitly provide the columns in the expected order. As per the docstring, stack_anomalous() expects the corresponding column labels to be given in the same order. However, unstack_anomalous() should be made to always output the column labels in a way that would be compatible with stack_anomalous()

from reciprocalspaceship.

My pandas version:

[ins] In [1]: import pandas as pd    
                                     
[ins] In [2]: pd.__version__         
Out[2]: '1.3.2'                      

I agree that the bug is in unstack_anomalous. Sorry if that wasn't clear.

from reciprocalspaceship.