例如：list1 結(jié)構(gòu): 名字，ID，顏色，數(shù)量，類型list1 = [['a',1,255,100,'03'],['a',2,481,50,'06'],['a',47,255,500,'03']，['b',3,1,50,'11']]list2結(jié)構(gòu):名字，類型,顏色list2 = [['a','03',255],['a','03',481]]如何在list1中找出所有與list2中匹配的元素？結(jié)果list = [['a',1,255,100,'03'],['a',2,481,50,'06'],['a',47,255,500,'03']]難道只能for 一個(gè)個(gè)對(duì)比嗎？是否有簡(jiǎn)單的方法
1 回答
開(kāi)滿天機(jī)
TA貢獻(xiàn)1786條經(jīng)驗(yàn) 獲得超13個(gè)贊
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","顏色","數(shù)量","類型"]) 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)
添加回答
舉報(bào)
0/150
提交
取消