Python List中如何查找？

Question

例如：list1 结构: 名字，ID，颜色，数量，类型list1 = [['a',1,255,100,'03'],['a',2,481,50,'06'],['a',47,255,500,'03']，['b',3,1,50,'11']]list2结构:名字，类型,颜色list2 = [['a','03',255],['a','03',481]]如何在list1中找出所有与list2中匹配的元素？结果list = [['a',1,255,100,'03'],['a',2,481,50,'06'],['a',47,255,500,'03']]难道只能for 一个个对比吗？是否有简单的方法

Answer 1

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)