BUG/API: bug in multi-index slicing with missing indexers (original) (raw)

I think the following could work and not raise KeyError because of a missing indexer. This would follow the API of loc which will be effectively a reindex as long as you have at least 1 found value.

s = pd.Series(np.arange(9),index=pd.MultiIndex.from_product([['A','B','C'],['foo','bar','baz']],names=['one','two'])).sortlevel()

s.loc[['A','D']]

idx = pd.IndexSlice
s.loc[idx[:,['foo','bah']]]