Python – Return index with a level removed

PythonServer Side ProgrammingProgramming

To return index with a level removed, use the multiIndex.droplevel() method in Pandas. 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'])

Dropping a level from the multiindex −

print("\nDropping a level...\n",multiIndex.droplevel())

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'])

print("Multindex...\n",multiIndex)

# dropping a level from the multiindex
print("\nDropping a level...\n",multiIndex.droplevel())

Output

This will produce the following output −

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

Dropping a level...
MultiIndex([(15, 25, 35),
   (20, 30, 40)],
   names=['b', 'c', 'd'])
raja
Published on 13-Oct-2021 09:04:36
Advertisements