pandas select based on values from another dataframe code example

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

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

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

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