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)