python find common data between tables code example

Example 1: find common values in different dataframes pandas

df3 = pd.merge(df1, df2, how='inner', left_on='UniqueID', right_on='ID')

Example 2: find common values in different dataframes pandas

df3.drop([column_names], inplace=True)