1

I have a multi-index dataframe and need to sort the columns by the second level so that the column with 0.1 is first, does anyone know how to do this?

            WBAI           ANF           ACEL             
            0.3           0.2           0.1
2018-05-14  17.490000     23.185350     9.861
Improve this question

1 Answer 1

Reset to default
1

You can use sort_index setting axis=1 (i.e., using columns) and level=1 (counting starts from 0 so 1 is the second level) as follows:

df = df.sort_index(axis=1, level=1)

Result:

             ACEL        ANF     WBAI
              0.1        0.2      0.3
2018-05-14  9.861   23.18535    17.49
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.