Unalignable boolean Series provided as indexer

user_11755414 0
Viewed 6473

I am trying to filter a dataframe as:

a= a[~(b['var1'].isin(c['var2']))]

but get the following error:

"Unalignable boolean Series provided as "
pandas.core.indexing.IndexingError: Unalignable boolean Series provided as indexer (index of the boolean Series and of the indexed object do not match).

I understand that the statement:

print(~(b['var1'].isin(c['var2'])) [:10])

is returning a series that is boolean masked which may not be acceptable. So, I tried to use loc as:

a= a.loc[:, ~(b['var1'].isin(c['var2']))]

but I am getting the same error. What am I missing here? Any input would be appreciated.

Thanks

pandas filtering python
1 Answers

Error means there are different index of a and of mask created with isin, it means different index of b.

mask = ~(b['var1'].isin(c['var2']))

So possible solution is change index by a.index and for not matched values add Falses:

a[mask.reindex(a.index, fill_value=False)]

Or:

a[~(b['var1'].reindex(a.index, fill_value=False).isin(c['var2']))]
user_29010020
Related