Pandas Pivot Table manually sort columns [duplicate]

Question

For a given data frame:

UUT testa testb testc testd DateTime 2017-11-21 18:47:29 1.0 1.0 1.0 3.0 2017-11-21 18:47:30 1.0 2.0 1.0 4.0 2017-11-21 18:47:31 1.0 2.0 5.0 2.0 2017-11-21 18:47:32 1.0 2.0 5.0 1.0 2017-11-21 18:47:33 1.0 2.0 5.0 4.0 2017-11-21 18:47:34 1.0 2.0 5.0 1.0

how can I manually rearrange the columns anyway I want it for example if I want to the following sequence:

testc, testd, testa, testb

So the table and the plot will be in this way:

UUT testc testd testa testb DateTime 2017-11-21 18:47:29 1.0 3.0 1.0 1.0 2017-11-21 18:47:30 1.0 4.0 1.0 2.0 2017-11-21 18:47:31 5.0 2.0 1.0 2.0 2017-11-21 18:47:32 5.0 1.0 1.0 2.0 2017-11-21 18:47:33 5.0 4.0 1.0 2.0 2017-11-21 18:47:34 5.0 1.0 1.0 2.0

There is an answer for you right here : stackoverflow.com/questions/13148429/… — Yoann boyere
– Yoann boyere, Commented Dec 19, 2017 at 8:14

Joe · Accepted Answer · 2017-12-19 08:13:40Z

12

You can use:

df = df.reindex_axis(['testc','testd', 'testa','testb'], axis=1)

answered Dec 19, 2017 at 8:13

Joe

12.4k7 gold badges44 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas Pivot Table manually sort columns [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related