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!

CodePudding user response：

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)]

CodePudding user response：

Just merge (inner join) them :

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