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