I need to reshape a dataframe like that:
| A | B | X | Y | 
|---|---|---|---|
| a1 | b1 | x1 | y1 | 
| a2 | b2 | x2 | y2 | 
to
| A | B | Columns1 | result | 
|---|---|---|---|
| a1 | b1 | X | x1 | 
| a2 | b2 | X | x2 | 
| a1 | b1 | Y | y1 | 
| a2 | b2 | Y | y2 | 
is there an easy way? I need to avoid an output with pandas multi-index.
Thanks for the suggestions
I need to reshape a dataframe like that:
| A | B | X | Y | 
|---|---|---|---|
| a1 | b1 | x1 | y1 | 
| a2 | b2 | x2 | y2 | 
to
| A | B | Columns1 | result | 
|---|---|---|---|
| a1 | b1 | X | x1 | 
| a2 | b2 | X | x2 | 
| a1 | b1 | Y | y1 | 
| a2 | b2 | Y | y2 | 
is there an easy way? I need to avoid an output with pandas multi-index.
Thanks for the suggestions
