
- Python Basic Tutorial
- Python - Home
- Python - Overview
- Python - Environment Setup
- Python - Basic Syntax
- Python - Comments
- Python - Variables
- Python - Data Types
- Python - Operators
- Python - Decision Making
- Python - Loops
- Python - Numbers
- Python - Strings
- Python - Lists
- Python - Tuples
- Python - Dictionary
- Python - Date & Time
- Python - Functions
- Python - Modules
- Python - Files I/O
- Python - Exceptions
Python Pandas - Form the intersection of two Index objects and sort the result
To form the intersection of two Index objects, use the index1.intersection(index2) method in Pandas. To sort the result, use the sort parameter.
At first, import the required libraries −
import pandas as pd
Creating Pandas index1 and index2 −
index1 = pd.Index([4, 3, 2, 1]) index2 = pd.Index([8, 2, 6, 4])
Display the Pandas index1 and index2
print("Pandas Index1...\n",index1) print("Pandas Index2...\n",index2)
Perform intersection. The results are sorted using the "sort" parameter
res = index1.intersection(index2, sort=None)
Example
Following is the code −
import pandas as pd # Creating Pandas index1 and index2 index1 = pd.Index([4, 3, 2, 1]) index2 = pd.Index([8, 2, 6, 4]) # Display the Pandas index1 and index2 print("Pandas Index1...\n",index1) print("Pandas Index2...\n",index2) # Return the number of elements in Index1 and Index2 print("\nNumber of elements in index1...\n",index1.size) print("\nNumber of elements in index2...\n",index2.size) # Perform intersection # The results are sorted using the "sort" parameter res = index1.intersection(index2, sort=None) # Intersection of both the indexes and returning sorted result print("\nThe index1 and index2 intersection (sorted result)...\n",res)
Output
This will produce the following output −
Pandas Index1... Int64Index([4, 3, 2, 1], dtype='int64') Pandas Index2... Int64Index([8, 2, 6, 4], dtype='int64') Number of elements in index1... 4 Number of elements in index2... 4 The index1 and index2 intersection (sorted result)... Int64Index([2, 4], dtype='int64')
- Related Articles
- Python Pandas - Form the intersection of two Index objects
- Python Pandas - Form the Union of two Index objects but do not sort the result
- Python Pandas - Form the Union of two Index objects
- Python Pandas - Compute the symmetric difference of two Index objects and unsort the result
- Python Pandas - Form the Union of two Index objects with different datatypes
- Python Pandas - Compute the symmetric difference of two Index objects
- Python Pandas - Sort index values and also return the indices that would sort the index
- Python Pandas - Determine if two Index objects are equal
- Python Pandas - Check whether the two Index objects have similar object attributes and types
- Python Pandas - Check if the Pandas Index holds Interval objects
- Python Pandas - Display the index of dataframe in the form of multi-index
- Python Pandas - Return the integer indices that would sort the index
- Sort index in ascending order – Python Pandas
- Python Pandas - Return a new Index with elements of index not in other but unsort the result
- Python - Fetch columns between two Pandas DataFrames by Intersection

Advertisements