Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Python – Remove a level using the name of the level and return the index
To remove a level using the name of the level and return the index, use the multiIndex.droplevel() method in Pandas. Set the name of the level to be removed 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 a level using the level name. We have passed the name of the level to be removed as a parameter −
print("\nDropping a level...\n", multiIndex.droplevel('b'))
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 a level using the level name
# We have passed the name of the level to be removed as a parameter
print("\nDropping a level...\n", multiIndex.droplevel('b'))Output
This will produce the following output −
Multi-index... MultiIndex([( 5, 15, 25, 35),(10, 20, 30, 40)],names=['a', 'b', 'c', 'd']) Dropping a level... MultiIndex([( 5, 25, 35),(10, 30, 40)],names=['a', 'c', 'd'])
Updated on: 13-Oct-2021
577 Views
Advertisements