How can I delete rows/items of pandas series with indices' labels not in a list?

Question

I have a list of labels.

I also have a pandas series that has multiple rows/items, some of which have their index labels in that list and some others have index labels not in that list.

I want to delete the rows/items of that series that have labels not in that list.

The only way I could come up with is to iterate on the series, check if the index label is in that list or not and delete it if not.

Is there any other easier way? And if not, could someone provide a code to do this way, as I also couldn't get it to work (not sure how to iterate on a series and how to compare its index labels to labels in a list).

Your help would be very appreciated.

Answer 1

You can use Index.intersection with loc:

s = pd.Series([1,2,5,6], index=list('abcd'))
print (s)
a    1
b    2
c    5
d    6
dtype: int64

L = list('cdef')
print (s.loc[s.index.intersection(L)])
c    5
d    6
dtype: int64

Another posible solution with isin:

print (s.loc[s.index.isin(L)])
c    5
d    6
dtype: int64