pandas get row where column value equals code example
Example 1: fetch row where column is equal to a value pandas
df.loc[df['column_name'] == 'value']
Example 2: 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