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 - Return index with a specific level removed
To return index with a specific 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. We have passed the position of the level to be removed as a parameter −
print("\nDropping a level...\n",multiIndex.droplevel(3))
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("Multindex...\n",multiIndex)
# Dropping a level
# We have passed the position of the level to be removed as a parameter
print("\nDropping a level...\n",multiIndex.droplevel(3))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([( 5, 15, 25),(10, 20, 30)],names=['a', 'b', 'c'])
Updated on: 13-Oct-2021
65 Views
Advertisements