
- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 Pandas - Return MultiIndex with requested level removed using the level name
To return MultiIndex with requested level removed using the level name, use the MultiIndex.droplevel() method and set the level (level name) to be removed as an argument.
At first, import the required libraries −
import pandas as pd
MultiIndex is a multi-level, or hierarchical, index object for pandas objects. Create arrays −
arrays = [[2, 4, 3, 1], ['Peter', 'Chris', 'Andy', 'Jacob']]
The "names" parameter sets the names for each of the index levels. The from_arrays() is used to create a MultiIndex −
multiIndex = pd.MultiIndex.from_arrays(arrays, names=('ranks', 'student'))
Drop a specific level from MultiIndex. The level to be dropped is set as the level name in parameter i.e.
# level name 'student' gets dropped −
print("\nMulti-index after dropping a level...\n",multiIndex.droplevel('student'))
Example
Following is the code −
import pandas as pd # MultiIndex is a multi-level, or hierarchical, index object for pandas objects # Create arrays arrays = [[2, 4, 3, 1], ['Peter', 'Chris', 'Andy', 'Jacob']] # The "names" parameter sets the names for each of the index levels # The from_arrays() is used to create a MultiIndex multiIndex = pd.MultiIndex.from_arrays(arrays, names=('ranks', 'student')) # display the MultiIndex print("The Multi-index...\n",multiIndex) # get the levels in MultiIndex print("\nThe levels in Multi-index...\n",multiIndex.levels) # Drop a specific level from MultiIndex # The level to be dropped is set as the level name in parameter i.e. # level name 'student' gets dropped print("\nMulti-index after dropping a level...\n",multiIndex.droplevel('student'))
Output
This will produce the following output −
The Multi-index... MultiIndex([(2, 'Peter'), (4, 'Chris'), (3, 'Andy'), (1, 'Jacob')], names=['ranks', 'student']) The levels in Multi-index... [[1, 2, 3, 4], ['Andy', 'Chris', 'Jacob', 'Peter']] Multi-index after dropping a level... Int64Index([2, 4, 3, 1], dtype='int64', name='ranks')
- Related Questions & Answers
- Python Pandas - Return MultiIndex with requested level removed
- Python Pandas - Return MultiIndex with multiple levels removed using the level names
- Python Pandas - Rearrange levels using level name in MultiIndex
- Python Pandas - Return vector of label values using level name in the MultiIndex
- Python Pandas - Return vector of label values for requested level in a MultiIndex
- Python Pandas - Set only a single new specific level using the level name in a MultiIndex
- Python – Return index with a level removed
- Python - Return index with a specific level removed
- Python Pandas - Get location and sliced index for requested label/ level in a MultiIndex
- Python – Remove a level using the name of the level and return the index
- Python Pandas - Return vector of label values using integer position of the level in the MultiIndex
- Python Pandas - Get location and sliced index for requested label/ level but do not drop the level
- Python Pandas - Get a tuple with the length of each level from MultiIndex
- Python Pandas - Getting values from a specific level in Multiindex
- Python Pandas - How to Sort MultiIndex at a specific level
Advertisements