Python Pandas - 从 CategoricalIndex 中删除指定的类别
要从CategoricalIndex中删除指定的类别,请使用remove_categories()Pandas中的方法。
首先,导入所需的库-
import pandas as pd
使用“categories”参数设置分类的类别。使用“ordered”参数按顺序处理分类-
catIndex = pd.CategoricalIndex(["p", "q", "r", "s","p", "q", "r", "s"], ordered=True, categories=["p", "q", "r", "s"])
使用删除类别remove_categories()。将要删除的类别设置为参数。已删除类别中的值将设置为NaN-
print("\nCategoricalIndex after removing specified categories...\n", catIndex.remove_categories(["p", "q"]))
示例
以下是代码-
import pandas as pd # Set the categories for the categorical using the "categories" parameter # Treat the categorical as ordered using the "ordered" parameter catIndex = pd.CategoricalIndex(["p", "q", "r", "s","p", "q", "r", "s"], ordered=True, categories=["p", "q", "r", "s"]) #显示分类索引 print("CategoricalIndex...\n",catIndex) #获取类别 print("\nDisplaying Categories from CategoricalIndex...\n",catIndex.categories) #使用remove_categories()删除类别 #设置要删除的类别作为参数 #已删除类别中的值将设置为NaN print("\nCategoricalIndex after removing specified categories...\n", catIndex.remove_categories(["p", "q"]))输出结果
这将产生以下输出-
CategoricalIndex... CategoricalIndex(['p', 'q', 'r', 's', 'p', 'q', 'r', 's'], categories=['p', 'q', 'r', 's'], ordered=True, dtype='category') Displaying Categories from CategoricalIndex... Index(['p', 'q', 'r', 's'], dtype='object') CategoricalIndex after removing specified categories... CategoricalIndex([nan, nan, 'r', 's', nan, nan, 'r', 's'], categories=['r', 's'], ordered=True, dtype='category')