pandas select all rows that have a matching value in another dataframe code example
Example: select rows which entries equals one of the values pandas
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