Python Pandas - 在条件为 False 的情况下替换索引值
若要在条件为 False 的情况下替换索引值,请使用 Pandas 中的 index.isin() 方法。首先,导入所需的库 -
import pandas as pd
创建 Pandas 索引 -
index = pd.Index(['Electronics','Accessories','Decor', 'Books', 'Toys'], name ='Products')
显示 Pandas 索引 -
print("Pandas Index...\n",index)
替换条件为 False 的值。在此处,除了 'Decor' 之外,所有其他元素都得到了替换 -
print("\nReplace index vales where condition is False...\n",index.where(index.isin(['Decor']), 'Miscellaneous'))
示例
以下是代码 -
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'))
输出
这将产生以下输出 -
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')
广告