isin():Whether each element in the DataFrame is contained in values
判断元素是否在 传入的参数values中。
待读取文件预览:
![](https://i-blog.csdnimg.cn/blog_migrate/e9ae8b8de59cf5342f32c221798c3d6c.png)
import pandas as pd
# 读取excel
file_path = r'C:\Users\123\Desktop\pandastest\example.xlsx'
df = pd.read_excel(file_path, sheet_name=0, header=0, skipfooter=0)
# 预览原dataframe
print(df)
# 筛选条件
value_list = ["长裙", "鞋子"]
select_df = df[df["标题"].isin(value_list)]
# 筛选后的df
print(select_df)
运行结果: