Adding a entire column data below the other column in pandas

Question

I have a dataframe like this:

time a   b
0    10  20
1    11  21

Now i need a dataframe like this:

`df.melt('time')` or specifically : `df.melt('time',value_name='a').drop("variable",1)` — anky, Jun 23 '20 at 16:16
Thank you very much. Is there any other way using join, concat and merge? — Ashok Silwal, Jun 23 '20 at 16:20
Okay thank you :) I find it easy since i am trying it for the first time. — Ashok Silwal, Jun 23 '20 at 16:34

score 0 · Accepted Answer · answered Jun 23 '20 at 16:15

This can be done with melt:

df.melt('time', value_name='a').drop('variable', axis=1)

Output:

   time   a
0     0  10
1     1  11
2     0  20
3     1  21

Or if you have columns other than a,b in your data:

df.melt('time', ['a','b'], value_name='a').drop('variable', axis=1)

1 Answers1