I have 2 data frames that I would like to match more than 2 numbers that match in the row I'm looking up. import pandas as pd cols = ['Num1','Num2','Num3','Num4','Num5','Num6'] df1 = pd.DataFrame([[2,4,6,8,9,10]], columns=cols) df2 = pd.DataFrame([[1,1,2,4,5,6,8], [2,5,6,20,22,23,34], [3,8,12,13,34,45,46], [4,9,10,14,29,32,33], [5,1,22,13,23,33,35], [6,1,6,7,8,9,10], [7,0,2,3,5,6,8]], columns = ['Id','Num1','Num2','Num3','Num4','Num5','Num6']) I have this code that matches but i would like to enhance by matching more than 2 numbers in the row. # convert the values in the first dataframe to a list vals_to_find = df1.iloc[0].tolist() # Print the values to find print("Vals to find:", vals_to_find) # Create an empty list to hold the matching IDs matc
A site where you can share knowledge