Q:

Python Pandas | Set levels on a MultiIndex

belongs to collection: Python Pandas Programs

0

Set levels on a MultiIndex

The pandas.MultiIndex.set_levels() method is used to set new levels on a MultiIndex.

Syntax:

MultiIndex.set_levels(levels, level=None, inplace=None, verify_integrity=True)

To work with MultiIndex in Python Pandas, we need to import the pandas library. Below is the syntax,

import pandas as pd

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

Python code to set levels on a MultiIndex

# Import the pandas package
import pandas as pd

# Create arrays
employees = [
        ['E101', 'E102', 'E102', 'E103'],
        ['Alex', 'Alvin', 'Deniel', 'Jenny']
    ]

# create a Multiindex using  from_arrays() 
mi = pd.MultiIndex.from_arrays(employees, names=('emp_ids', 'names'))

# display the Multiindex
print("The MultiIndex...\n",mi)
print()

# Get the levels in MultiIndex
print("The levels in MultiIndex...\n",mi.levels)
print()

# set the levels in MultiIndex
print("Setting new levels...\n",
    mi.set_levels([['e111', 'e112', 'e113', 'e114'], 
    ['Angelina', 'Emma', 'Kristen', 'Gal']]))

Output:

The MultiIndex...
 MultiIndex([('E101',   'Alex'),
            ('E102',  'Alvin'),
            ('E102', 'Deniel'),
            ('E103',  'Jenny')],
           names=['emp_ids', 'names'])

The levels in MultiIndex...
 [['E101', 'E102', 'E103'], ['Alex', 'Alvin', 'Deniel', 'Jenny']]

Setting new levels...
 MultiIndex([('e111', 'Angelina'),
            ('e112',     'Emma'),
            ('e112',  'Kristen'),
            ('e113',      'Gal')],
           names=['emp_ids', 'names'])

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Python Pandas Programs

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now
Python Pandas | Swap levels of a MultiIndex... >>
<< Python Pandas | How to get the name of levels in M...