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 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')
Updated on: 14-Oct-2021
464 Views
Advertisements