在多个字段上搜索Python列表列表的最有效方法？

data = [
    ['Alice', 30, 'Engineer'],
    ['Bob', 25, 'Designer'],
    ['Charlie', 35, 'Manager']
]

search_criteria = ('Engineer',)

# 搜索所有字段
result = [item for item in data if all(item[i] == criteria for i, criteria in enumerate(search_criteria))]

print(result)

data = [
    ['Alice', 30, 'Engineer'],
    ['Bob', 25, 'Designer'],
    ['Charlie', 35, 'Manager']
]

search_criteria = ('Engineer',)

# 使用filter函数
result = list(filter(lambda x: all(x[i] == criteria for i, criteria in enumerate(search_criteria)), data))

print(result)

import pandas as pd

data = [
    ['Alice', 30, 'Engineer'],
    ['Bob', 25, 'Designer'],
    ['Charlie', 35, 'Manager']
]

df = pd.DataFrame(data, columns=['Name', 'Age', 'Job'])

search_criteria = {'Job': 'Engineer'}

# 使用Pandas进行搜索
result = df[df.isin(search_criteria).all(axis=1)]

print(result)