pandas get row where column equals code example

Example 1: fetch row where column is equal to a value pandas

df.loc[df['column_name'] == 'value']

Example 2: panda select rows where column value inferior to

df.loc[df['column_name'] == some_value]

Example 3: 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

Example 4: only keep rows of a dataframe based on a column value

df.loc[(df['column_name'] >= A) & (df['column_name'] <= B)]