In[10]: df Name Amount --------------- Alice 100 Bob 50 Charlie 200 Alice 30 Charlie 10 In [11]: df['Name'].isin(['Alice', 'Bob']) Out[11]: 0 True 1 True 2 False 3 True 4 False Name: Name, dtype: bool In [12]: df[df.Name.isin(['Alice', 'Bob'])] Out[12]: Name Amount 0 Alice 100 1 Bob 50 3 Alice 30
Here is what the above code is Doing:
1. df[‘Name’].isin([‘Alice’, ‘Bob’]) returns a boolean Series, which is a Series of True/False values.
2. df[df.Name.isin([‘Alice’, ‘Bob’])] returns a DataFrame for which the boolean Series is True.