import pandas as pd
list1 = [['a',1,255,100,'03'],['a',2,481,50,'06'],['a',47,255,500,'03'],['b',3,1,50,'11']]
df1=pd.DataFrame(list1,columns=["","ID","","",""])
list2 = [['a','03',255],['a','06',481]]
df2=pd.DataFrame(list2,columns=["","",""])
df=pd.merge(df1,df2,how='inner',on=["","",""],right_index=True)
df.sort_index(inplace=True)
print(df)

if it is ordered, you can use dichotomy to find it, if it is not a loop traversal. The data structure of
list is not suitable for random query. If the amount of data is large, try other data structures, such as dictionaries.