'Filtering a dataframe column with another column in a separate dataframe

I have a dataframe table (table_1) that contains 3 cloumns:

I want to be able to filter the column Iteam Id with the data in another data-frame column (table_2).

So the output would be:

I have tryed creating a new dataframe using:

    new_df = table_1[table_1['Iteam ID'].isin(table_2)

But it is returning an empty dataframe, any help with this would be much appreciated!

python pandas dataframe

Solution 1:^[1]

You should use the correct column instead of the whole dataframe:

new_df = table_1[table_1['Iteam ID'].isin(table_2['Iteam ID'].values)]

Just merge (inner join) them :

out = df1.merge(df2, on='Iteam Id')

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Z Li
Solution 2	eshirvana