pandas.DataFrame.reorder_levels#

DataFrame.reorder_levels(order,axis=0)[source]#

Rearrange index levels using input order. May not drop or duplicate levels.

Parameters:

orderlist of int or list of str

List representing new level order. Reference level by number(position) or by key (label).

axis{0 or ‘index’, 1 or ‘columns’}, default 0

Where to reorder levels.

Returns:

DataFrame

Examples

>>>data={..."class":["Mammals","Mammals","Reptiles"],..."diet":["Omnivore","Carnivore","Carnivore"],..."species":["Humans","Dogs","Snakes"],...}>>>df=pd.DataFrame(data,columns=["class","diet","species"])>>>df=df.set_index(["class","diet"])>>>df                                  speciesclass      dietMammals    Omnivore                Humans           Carnivore                 DogsReptiles   Carnivore               Snakes

Let’s reorder the levels of the index:

>>>df.reorder_levels(["diet","class"])                                  speciesdiet      classOmnivore  Mammals                  HumansCarnivore Mammals                    Dogs          Reptiles                 Snakes