Reshaping Data in Pandas

Question

I have a dataframe that currently looks like the following:

X  |  A  |  B  |  C  
X1 |  1  |  3  |  5
X2 |  3  |  5  |  7

I want to reshape it either in Pandas or OpenRefine so it looks like the following:

A  | X1 | 1
A  | X2 | 3
B  | X1 | 3
B  | X2 | 5
C  | X1 | 5
C  | X2 | 7

I know I have done something like it in the past, but cannot for the life of me remember how.

This question smells like a duplicate... can someone find the right one? — cs95, Nov 08 '17 at 19:04

score 3 · Accepted Answer · edited Nov 08 '17 at 19:08

3

Use df.melt()

df.melt(id_vars='X', value_vars=['A','B','C'])


    X   variable    value
0   X1  A           1
1   X2  A           3
2   X1  B           3
3   X2  B           5
4   X1  C           5
5   X2  C           7

edited Nov 08 '17 at 19:08

BENY

296,997
19
147
204

answered Nov 08 '17 at 18:52

Vaishali

35,413
4
48
78

2

@Wen Nice gold badge Pandas badge there. Congrats. – Scott Boston Nov 08 '17 at 19:27
@ScottBoston just get it today ... I even do not notice that :-) – BENY Nov 08 '17 at 19:29

Reshaping Data in Pandas

1 Answers1