Pandas change muliindex to index and multiple columns

Question

I have a df like this

| Feature | Channel | Value |
|---------|---------|-------|
| a       | 0       | 1.3   |
|         | 1       | 1.3   |
|         | 2       | 1.3   |
| b       | 0       | 1.2   |
|         | 1       | 1.2   |
|         | 2       | 1.2   |

where Feature and Channel are a multiindex

how can I turn this into the following:

| channel | a   | b   |
|---------|-----|-----|
| 0       | 1.3 | 1.2 |
| 1       | 1.3 | 1.2 |
| 2       | 1.3 | 1.2 |

where channel is now the index, and a and b are separate columns?

Henry Ecker · Accepted Answer · 2021-07-01 20:09:54Z

2

Use unstack:

new_df = df.unstack(level=0)

new_df:

        Value     
Feature     a    b
Channel           
0         1.3  1.2
1         1.3  1.2
2         1.3  1.2

With droplevel + rename_axis:

new_df = df.unstack(0).droplevel(0, 1).rename_axis(columns=None)

new_df:

           a    b
Channel          
0        1.3  1.2
1        1.3  1.2
2        1.3  1.2

answered Jul 1, 2021 at 20:09

community wiki

Henry Ecker

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

Comments

dww142 · Accepted Answer · 2021-07-01 20:14:38Z

0

Pivot might be easier (drop the index first) -

df.reset_index(inplace=True)
df.pivot(index='Channel',columns='Feature',values='Value')

edited Jul 1, 2021 at 20:14

answered Jul 1, 2021 at 20:12

dww142

964 bronze badges

1 Comment

dww142 Over a year ago

Yep, you beat me to my edit, revised to show reset_index first.

Collectives™ on Stack Overflow

Pandas change muliindex to index and multiple columns

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related