pandas.MultiIndex.drop — pandas 2.2.3 documentation (original) (raw)

MultiIndex.drop(codes, level=None, errors='raise')[source]#

Make a new pandas.MultiIndex with the passed list of codes deleted.

Parameters:

codesarray-like

Must be a list of tuples when level is not specified.

levelint or level name, default None

errorsstr, default ‘raise’

Returns:

MultiIndex

Examples

idx = pd.MultiIndex.from_product([(0, 1, 2), ('green', 'purple')], ... names=["number", "color"]) idx MultiIndex([(0, 'green'), (0, 'purple'), (1, 'green'), (1, 'purple'), (2, 'green'), (2, 'purple')], names=['number', 'color']) idx.drop([(1, 'green'), (2, 'purple')]) MultiIndex([(0, 'green'), (0, 'purple'), (1, 'purple'), (2, 'green')], names=['number', 'color'])

We can also drop from a specific level.

idx.drop('green', level='color') MultiIndex([(0, 'purple'), (1, 'purple'), (2, 'purple')], names=['number', 'color'])

idx.drop([1, 2], level=0) MultiIndex([(0, 'green'), (0, 'purple')], names=['number', 'color'])