Python Pandas - Replace index values where the condition is False

PythonServer Side ProgrammingProgramming

To replace index values where the condition is False, use the index.isin() method in Pandas. At first, import the required libraries −

import pandas as pd

Creating Pandas index −

index = pd.Index(['Electronics','Accessories','Decor', 'Books', 'Toys'], name ='Products')

Display the Pandas index −

print("Pandas Index...\n",index)

Replace values where condition is False. Here, except the 'Decor', every other element gets replaced −

print("\nReplace index vales where condition is False...\n",index.where(index.isin(['Decor']), 'Miscellaneous'))

Example

Following is the code −

import pandas as pd

# Creating Pandas index
index = pd.Index(['Electronics','Accessories','Decor', 'Books', 'Toys'], name ='Products')

# Display the Pandas index
print("Pandas Index...\n",index)

# Return the number of elements in the Index
print("\nNumber of elements in the index...\n",index.size)

# Return the dtype of the data
print("\nThe dtype object...\n",index.dtype)

# replace values where condition is False
# Here, except the 'Decor', every other element gets replaced
print("\nReplace index vales where condition is False...\n",index.where(index.isin(['Decor']), 'Miscellaneous'))

Output

This will produce the following output −

Pandas Index...
Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], dtype='object', name='Products')

Number of elements in the index...
5

The dtype object...
object

Replace index vales where condition is False...
Index(['Miscellaneous', 'Miscellaneous', 'Decor', 'Miscellaneous','Miscellaneous'],dtype='object', name='Products')
raja
Published on 13-Oct-2021 07:59:20

Advertisements