split index of tuples into multindex pandas dataframe - using python

Question

I created a dataframe from a list of dataframes like this:

team_df = pd.concat(all_teams, keys=flat_list, axis=0)

I attached a picture of the output.

I want to convert

it to is something like this:

team1

player 1
player 2
player 3
player 4
player 5
player 6

team2

player 1
player 2
player 3
player 4
player 5
player 6

Zero · Accepted Answer · 2017-07-14 13:14:55Z

7

You can use pd.MultiIndex.from_tuples to set index.

In [1045]: df.index = pd.MultiIndex.from_tuples(df.index, names=['team', 'player'])

In [1046]: df
Out[1046]:
             d
team player
1    2       1
     3       2
2    3       3

answered Jul 14, 2017 at 13:14

Zero

77.4k22 gold badges154 silver badges154 bronze badges

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

Collectives™ on Stack Overflow

split index of tuples into multindex pandas dataframe - using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related