例如：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 一個個對比嗎？是否有簡單的方法
1 回答
侃侃爾雅
TA貢獻1801條經驗 獲得超16個贊
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)
添加回答
舉報
0/150
提交
取消