首頁猿問 Python List中如何查找？

Python List中如何查找？

Python

森林海 2018-12-17 09:21:56

例如：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 一個個對比嗎？是否有簡單的方法

查看完整描述

1 回答

開滿天機

TA貢獻1786條經(jīng)驗獲得超13個贊

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)

反對回復 2018-12-17