How to convert part of columns to row by using pandas dataframe

Asked Aug 15 '19 at 01:40

Active Aug 15 '19 at 01:40

Viewed 22 times

I have a dataframe like this:

A      B      C      D      E ...
a1     b1     c1     d1     e1 ...
a2     b2     c2     d2     e2 ...

I want to change to:

A      B      Name  Value
a1     b1     D     d1 
a1     b1     E     e1
...

a2     b2     D     d2
a2     b2     E     e2

Is it possible to do with pandas? (Column A & B is the unique union column, column C is the one we don't need any more)

asked Aug 15 '19 at 01:40

Niuya

1

@Datanovice I feel like this is melt , df.melt(['A','B']) – BENY Aug 15 '19 at 01:52
1

@WeNYoBen now that I look at it again you are right thank you sir – Umar.H Aug 15 '19 at 01:54

0 Answers0