
- 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 - Getting values from a specific level in Multiindex
To get values from a specific level in Multiindex, use the multiIndex.get_level_values() 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'])
Get value from specific value. Get 0th level value −
print("\nGet level value (0th level)...\n",multiIndex.get_level_values(0))
Get 1st level value −
print("\nGet level value (1st level)...\n",multiIndex.get_level_values(1))
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("Multi-index...\n",multiIndex) # get 0th level value print("\nGet level value (0th level)...\n",multiIndex.get_level_values(0)) # get 1st level value print("\nGet level value (1st level)...\n",multiIndex.get_level_values(1)) # dropping a level from the multiindex print("\nDropping a level...\n",multiIndex.droplevel())
Output
This will produce the following output −
Multi-index... MultiIndex([( 5, 15, 25, 35), (10, 20, 30, 40)], names=['a', 'b', 'c', 'd']) Get level value (0th level)... Int64Index([5, 10], dtype='int64', name='a') Get level value (1st level)... Int64Index([15, 20], dtype='int64', name='b') Dropping a level... MultiIndex([(15, 25, 35), (20, 30, 40)], names=['b', 'c', 'd'])
- Related Questions & Answers
- Python Pandas - How to Sort MultiIndex at a specific level
- Python Pandas - Set only a single new specific level in a MultiIndex
- Python Pandas - Set only a single new specific level using the level name in a MultiIndex
- Python Pandas - How to Sort MultiIndex at a specific level in descending order
- Python - Drop specific rows from multiindex Pandas Dataframe
- Python Pandas - Return vector of label values for requested level in a MultiIndex
- Python Pandas - Return MultiIndex with requested level removed
- Python Pandas - Get a tuple with the length of each level from MultiIndex
- Python Pandas - Rearrange levels using level name in MultiIndex
- Python Pandas - Return vector of label values using level name in the MultiIndex
- Python Pandas - Convert a MultiIndex to an Index of Tuples containing the level values
- Python Pandas - Return MultiIndex with requested level removed using the level name
- Python Pandas - Create Multiindex from arrays
- Python Pandas - Create Multiindex from dataframe
- Python Pandas - Return vector of label values using integer position of the level in the MultiIndex
Advertisements