Python Pandas - Return a new Index with elements of index not in other and get the difference

PythonServer Side ProgrammingProgramming

To return a new Index with elements of index not in other and get the difference, use the index1.difference(index2) method in Pandas.

At first, import the required libraries −

import pandas as pd

Creating two Pandas index −

index1 = pd.Index([10, 20, 30, 40, 50])
index2 = pd.Index([80, 40, 60, 20, 55])

Display the Pandas index1 and index2

print("Pandas Index1...\n",index1)
print("Pandas Index2...\n",index2)

Get the difference of both the indexes −

res = index1.difference(index2)

Example

Following is the code −

import pandas as pd

# Creating two Pandas index
index1 = pd.Index([10, 20, 30, 40, 50])
index2 = pd.Index([80, 40, 60, 20, 55])

# 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)

# Get the difference of both the indexes
res = index1.difference(index2)

# Difference of both the indexes i.e. return a new Index with elements of index not in other
print("\nDifference...\n",res)

Output

This will produce the following output −

Pandas Index1...
Int64Index([10, 20, 30, 40, 50], dtype='int64')
Pandas Index2...
Int64Index([80, 40, 60, 20, 55], dtype='int64')

Number of elements in index1...
5

Number of elements in index2...
5

Difference...
Int64Index([10, 30, 50], dtype='int64')
raja
Updated on 14-Oct-2021 07:19:39

Advertisements