Python – Remove multiples levels using the level names and return the index

PythonServer Side ProgrammingProgramming

To remove multiples levels using the level names and return the index, use the multiIndex.droplevel(). Set the level names as parameter.

At first, import the required libraries -

import pandas as pd

Create a multi-index. The names parameter sets the names for the levels in the index

multiIndex = pd.MultiIndex.from_arrays([[5, 10], [15, 20], [25, 30], [35, 40]], names=['a', 'b', 'c', 'd'])

Display the multi-index −

print("Multi-index...\n", multiIndex)

Dropping multiple levels using the level names. We have passed the names of the levels to be removed as a parameter −

print("\nDropping multiple level...\n", multiIndex.droplevel(['a', 'd']))

Example

Following is the code −

import pandas as pd

# Create a multi-index
# The names parameter sets the names for the levels in the index
multiIndex = pd.MultiIndex.from_arrays([[5, 10], [15, 20], [25, 30], [35, 40]],names=['a', 'b', 'c', 'd'])

# display the multi-index
print("Multi-index...\n", multiIndex)

# Dropping multiple levels using the level names
# We have passed the names of the levels to be removed as a parameter
print("\nDropping multiple level...\n", multiIndex.droplevel(['a', 'd']))

Output

This will produce the following output −

Multi-index...
MultiIndex([( 5, 15, 25, 35),(10, 20, 30, 40)],names=['a', 'b', 'c', 'd'])

Dropping multiple level...
MultiIndex([(15, 25),(20, 30)],names=['b', 'c'])
raja
Published on 13-Oct-2021 09:18:27

Advertisements